+ Reply to Thread
Results 1 to 14 of 14

Saleman target tracker daily

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Saleman target tracker daily

    Find attached

    Running total should divide target divide 12 divide days in month , fetch 26 in formula , expected result attached
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    formula on c11 only , want to see if the drag right and down will work

  3. #3
    Valued Forum Contributor AZ-XL's Avatar
    Join Date
    03-22-2013
    Location
    Azerbaijan, Baku
    MS-Off Ver
    Excel 2007
    Posts
    603

    Re: Saleman target tracker daily

    I cannot understand how you get your expected results. Can you give mathematical explanation of them
    Appreciate the help? CLICK *

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    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

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    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

  6. #6
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    Meaning I multiplied per day with column heads 1 2 3 and so on

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    I need one formula thus to skip all the additional steps

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    Anyone , seems it looks tricky not sure

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    Anyone again ?

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    Anyone re type so that it flashes on the top for someone

  11. #11
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    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%

  12. #12
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    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

  13. #13
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    100,000,000 is on cell c17 and 26 is on d17

  14. #14
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2019 PRO
    Posts
    3,618

    Re: Saleman target tracker daily

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to create a daily sales tracker file when figures are altered every day?
    By sajithnair in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-01-2014, 02:52 PM
  2. Need Excel daily Task tracker template
    By fzzd2x in forum Excel General
    Replies: 0
    Last Post: 09-26-2012, 09:37 AM
  3. Daily data point tracker
    By MoonpieCCSD in forum Excel General
    Replies: 0
    Last Post: 05-01-2012, 12:55 PM
  4. Daily/Monthly/Quarterly Tracker question
    By swanzie in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2011, 02:51 AM
  5. Create Daily Report From Master Tracker.
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 53
    Last Post: 06-16-2010, 11:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1