Results 1 to 9 of 9

Thread: Can I pay someone to solve my excel problem?

  1. #1

    Question Can I pay someone to solve my excel problem?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can I pay someone to solve my excel problem?

    Am I allowed to use this forum in this way?

    I am just after one elusive formula, I have posted the question all over the Internet with no luck so far and am more than willing to pay someone to help.

    I have emailed a number of freelancers with shiny websites but have not received replies yet.

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    I had a brief look around the FAQ and didn't see anything about this. My guess is that yes I'm sure that you would find many experts willing to accept payment :-) However best you e-mail a site moderator for comment, I think both Bob and Ken are moderators here.
    is this referring to http://www.excelguru.ca/forums/showt...e-numbers-only or a different problem

  3. #3
    I don't know how to email a site moderator :S - I rarely ever use forums. And yes this is about the same problem, to "Spread a yearly total evenly across chosen months using whole numbers only".

  4. #4
    I am sure that there is no objection to commissioning someone, many sites have a specific consultancy facility, and anyone is free to PM the OP if they so wish.

    However, it seems unnecessary for what looks like a relatively simple problem (assuming that other thread is the problem). I looked at that other thread, but could not see what the proposed solution was, I saw no formulas.

  5. #5

    Question

    Quote Originally Posted by Bob Phillips View Post
    I am sure that there is no objection to commissioning someone, many sites have a specific consultancy facility, and anyone is free to PM the OP if they so wish.

    However, it seems unnecessary for what looks like a relatively simple problem (assuming that other thread is the problem). I looked at that other thread, but could not see what the proposed solution was, I saw no formulas.
    The proposed solution wasn't much help, after working all day I think I got close to a solution.

    The formula does the maths but comes up with a different total than the original total it used to spread the quantities across the months.

    If you look at my attached spreadsheet and enter different values in AF5, you will see what I mean. The 2 totals, T1 and T2 don't always match up so i have to manually fix the error.

    It's a half solution that allows me to get by (just). But maybe you can fix it?
    Attached Files Attached Files

  6. #6
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    When a formula looks like that you are looking for trouble.
    Quick clarification on spread you have a month and (1) or (E) e.g. D8 and E8 the customer wants 2 items of Product 1 in Dec 2016
    and moving over to I8 they want 100 items delivered from (and including June) until end of the year (7 months) (i.e. 5 months of 14 and 2 months of 15)

    Also are there production constraints, i.e. if the ideal solution says 1000 widgets in June are they only able to make 500 so need to do this over May and June?

    I would also suggest a slight rearrangement in layout so that you can treat it as a database (region,customer, product, year, QTY, spread) that way it will work for new years immediately.
    Followed by a pivot table to get your spread summed (region and customer is irrelevant to production, assuming one plant)

    End of the day here, will see tomorrow if you are closer to a solution

  7. #7
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    This should do it.


    • Extensive use of drop down validation lists
    • Orders replaced by a more database type structure. Make sure you copy down (and check pivot range). Can sort and go crazy
    • Scaling done once on "ramp" and "even" named ranges. After doing this realised that it could be simplified to one line and a complex if.
    • If production exceeds order e.g made 5 but only 4 expected can manually change the month's to 5 and the following months will recalculate
    • Pivot table to summarise total
    • Pink (bad style) represents formulas, green (good style) headers. I wasn't spending too much time making it look pretty.
    • Donations welcome as per thread title, click on wizzard allows you to send a message to that person
    Attached Files Attached Files

  8. #8
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Ok minor changes to simplify scaling based on if month not started = 0 else..

    Then change scaling, if production started this month how would it be ramped schedule(type,month)

    Then formula = (total - existing year sum) x ramp
    i.e. =IF(MATCH(I$1,Months,0)<MATCH($F2,Months,0),0,ROUND(($E2-SUM($H2:H2))*INDEX(MnthSplt,MATCH($G2,Schedule,0),MATCH(I$1,Months,0)),0))
    getting rid of the indirect function and rolling three named ranges (on, even, ramp) into schedule

    MonthSpread.xlsx

  9. #9
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,225
    Articles
    57
    Blog Entries
    14
    Excel Version
    Excel Office 365 Insider
    Quote Originally Posted by rkobeyer View Post
    Can I pay someone to solve my excel problem?

    Am I allowed to use this forum in this way?
    Just to answer the original question here, by all means you can, so long at that's YOUR choice. We wouldn't permit an expert to hold out on completing a forum answer unless payment was provided, but if you want to pay someone that is your own prerogative.

    By looking at this, though, it seems like you may have your answer, so a moot point in this case.
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training) or with my book M is for Data Monkey!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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