sapionapio
New Member
- Joined
- Oct 25, 2019
- Messages
- 7
Hello
I have a list of costs to be divided for a list of users.
Is it possible to allocate the costs, which the date range concerning, to users on the days of use?
NB if in one day more users use the same service / cost, the cost must be divided by the number of users
<html><head><title>Excel Jeanie HTML</title></head>******>
</body></html>
Explanation:
The daily cost of FOOD from 2019/01/01 to 2019/02/28 should be divided into 2 for Matthew and Alex but, from 2019/03/01 to 2019/03/31 it should be shared only for Alex
The daily cost of DRINKS from 2019/02/01 to 2019/02/28 should be divided into 2 for Matthew and Alex but, from 2019/03/01 to 2019/03/31 it should be shared only for Alex
<html><head><title>Excel Jeanie HTML</title></head>******>
</body></html>
Thanks!
I have a list of costs to be divided for a list of users.
Is it possible to allocate the costs, which the date range concerning, to users on the days of use?
NB if in one day more users use the same service / cost, the cost must be divided by the number of users
<html><head><title>Excel Jeanie HTML</title></head>******>
| Excel Workbook | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | 150.00 | 100.00 | 50.00 | |||||||||||
| 2 | COST | FROM | TO | $ | USER | FROM | TO | TOT | FOOD | DRINKS | ||||
| 3 | FOOD | 2019/01/01 | 2019/03/31 | 100 | Matthew | 2019/01/01 | 2019/02/28 | 44.64 | 32.78 | 11.86 | ||||
| 4 | DRINKS | 2019/02/01 | 2019/03/31 | 50 | Alex | 2019/01/01 | 2019/03/31 | 105.36 | 67.22 | 38.14 | ||||
example | ||||||||||||||
</body></html>
Explanation:
The daily cost of FOOD from 2019/01/01 to 2019/02/28 should be divided into 2 for Matthew and Alex but, from 2019/03/01 to 2019/03/31 it should be shared only for Alex
The daily cost of DRINKS from 2019/02/01 to 2019/02/28 should be divided into 2 for Matthew and Alex but, from 2019/03/01 to 2019/03/31 it should be shared only for Alex
<html><head><title>Excel Jeanie HTML</title></head>******>
| Excel Workbook | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |||
| 1 | 1500.00 | 222.00 | 427.00 | 403.00 | 201.00 | 247.00 | |||||||||||
| 2 | COST | FROM | TO | $ | USER | FROM | TO | TOT | FOOD | DRINKS | PHONE | DRESS | FUEL | ||||
| 3 | FOOD | 2019/01/01 | 2019/03/31 | 100 | Matthew | 2019/01/01 | 2019/02/28 | ||||||||||
| 4 | DRINKS | 2019/02/01 | 2019/03/31 | 50 | Alex | 2019/01/01 | 2019/03/31 | ||||||||||
| 5 | DRINKS | 2019/02/09 | 2019/12/31 | 31 | Brian | 2019/02/08 | 2019/12/31 | ||||||||||
| 6 | FUEL | 2019/02/25 | 2019/06/22 | 90 | Rebecca | 2019/02/23 | 2019/04/01 | ||||||||||
| 7 | FUEL | 2019/02/27 | 2019/03/28 | 46 | Ben | 2019/03/25 | 2019/12/19 | ||||||||||
| 8 | DRINKS | 2019/02/27 | 2019/10/18 | 38 | Jeremy | 2019/04/30 | 2019/09/30 | ||||||||||
| 9 | PHONE | 2019/02/28 | 2019/07/29 | 48 | Bryana | 2019/06/12 | 2019/11/19 | ||||||||||
| 10 | DRESS | 2019/03/02 | 2019/08/16 | 62 | Cathleen | 2019/07/17 | 2019/08/28 | ||||||||||
| 11 | PHONE | 2019/03/03 | 2019/10/24 | 73 | |||||||||||||
| 12 | FOOD | 2019/03/13 | 2019/10/13 | 67 | |||||||||||||
| 13 | PHONE | 2019/03/14 | 2019/09/12 | 89 | |||||||||||||
| 14 | DRINKS | 2019/03/14 | 2019/12/26 | 87 | |||||||||||||
| 15 | PHONE | 2019/03/22 | 2019/09/13 | 94 | |||||||||||||
| 16 | FOOD | 2019/03/23 | 2019/07/25 | 50 | |||||||||||||
| 17 | DRINKS | 2019/03/27 | 2019/04/24 | 13 | |||||||||||||
| 18 | DRINKS | 2019/03/27 | 2019/07/20 | 99 | |||||||||||||
| 19 | PHONE | 2019/04/06 | 2019/06/28 | 99 | |||||||||||||
| 20 | FUEL | 2019/04/06 | 2019/09/15 | 59 | |||||||||||||
| 21 | DRINKS | 2019/04/10 | 2019/06/18 | 73 | |||||||||||||
| 22 | DRESS | 2019/04/15 | 2019/07/04 | 74 | |||||||||||||
| 23 | FUEL | 2019/05/28 | 2019/08/08 | 39 | |||||||||||||
| 24 | FUEL | 2019/05/31 | 2019/07/31 | 13 | |||||||||||||
| 25 | DRINKS | 2019/06/22 | 2019/07/28 | 36 | |||||||||||||
| 26 | FOOD | 2019/06/27 | 2019/10/24 | 5 | |||||||||||||
| 27 | DRESS | 2019/07/10 | 2019/10/14 | 65 | |||||||||||||
to solve | |||||||||||||||||
</body></html>
Thanks!
