Find attached
Running total should divide target divide 12 divide days in month , fetch 26 in formula , expected result attached
Find attached
Running total should divide target divide 12 divide days in month , fetch 26 in formula , expected result attached
formula on c11 only , want to see if the drag right and down will work
I cannot understand how you get your expected results. Can you give mathematical explanation of them
Appreciate the help? CLICK *
I found out how much each saleman needed per day , made a table of running total ,
eg . if the per day sales was 50,000
The table read 50,000 100,000 and son
I thus divided the running sales done over the running daily to arrive to that
I used this additional table
1 2 3 4 5 6 7 8
SAT MON TUE WED THU FRI SAT MON
01/03/2014 03/03/2014 04/03/2014 05/03/2014 06/03/2014 07/03/2014 08/03/2014 10/03/2014
person 1 320,512.82 641,025.64 961,538.46 1,282,051.28 1,602,564.10 1,923,076.92 2,243,589.74 2,564,102.56
person 2 160,256.41 320,512.82 480,769.23 641,025.64 801,282.05 961,538.46 1,121,794.87 1,282,051.28
person 3 44,871.79 89,743.59 134,615.38 179,487.18 224,358.97 269,230.77 314,102.56 358,974.36
person 4 64,102.56 128,205.13 192,307.69 256,410.26 320,512.82 384,615.38 448,717.95 512,820.51
Meaning I multiplied per day with column heads 1 2 3 and so on
I need one formula thus to skip all the additional steps
Anyone , seems it looks tricky not sure
Anyone again ?
Anyone re type so that it flashes on the top for someone
SAT MON TUE WED THU FRI SAT MON
01/03/2014 03/03/2014 04/03/2014 05/03/2014 06/03/2014 07/03/2014 08/03/2014 10/03/2014
person 1 223,854 241,703 435,659 1,051,094 1,089,969 1,524,269 1,524,269 1,524,269
person 2 16,612 16,612 46,562 47,412 67,597 83,135 148,340 235,340
person 3 10,800 25,480 65,490 117,550 200,217 248,167 319,411 334,651
person 4 0 0 0 94,295 121,390 385,958 385,958 390,098
person 5 356,659 509,784 646,817 646,817 979,411 1,175,530 1,198,225 1,267,156
SAT MON TUE WED THU FRI SAT MON
01/03/2014 03/03/2014 04/03/2014 05/03/2014 06/03/2014 07/03/2014 08/03/2014 10/03/2014
person 1
person 2
person 3
person 4
person 5
person 1 100,000,000.00 26 days march
person 2 50,000,000.00
person 3 14,000,000.00
person 4 20,000,000.00
person 5 18,000,000.00
Expected ANSWER
70% 38% 45% 82% 68% 79% 68% 59%
10% 5% 10% 7% 8% 9% 13% 18%
24% 28% 49% 65% 89% 92% 102% 93%
0% 0% 0% 37% 38% 100% 86% 76%
618% 442% 374% 280% 340% 340% 297% 275%
column a is blank , i need a formula on cell c11 , the math for person a is 100,000,000 divide 12 divide 26
then the sale 223,854 divide the above number will give 70% , this then I will drag rightwards and downwards
100,000,000 is on cell c17 and 26 is on d17
There is a small catch , the target per day needs to be multiplied by 2 for next day 3 for third day and so , the numbers are already running totals
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks