Results 1 to 6 of 6

Job estimating

Threaded View

  1. #1
    Registered User
    Join Date
    10-14-2010
    Location
    BC Canada
    MS-Off Ver
    Excel 365
    Posts
    78

    Talking Job estimating

    I've got some data that I want to find the best fit for.
    Basically trying to create a tool to estimate future job time.
    For this particular situation we've broken it into two tasks, small jobs, and large jobs. Roughly taking 1.5h and 2 hours each
    As we add more and more past jobs to the excel sheet I want to be able to get more and more accurate estimating numbers



    Job Small items Large items Hours to complete
    Job 1 0 50 112
    Job 2 117 123 370
    Job 3 492 352 1120


    Formula: copy to clipboard
    0*y + 50*x = 112

    Formula: copy to clipboard
    117*y + 123*x = 370

    Formula: copy to clipboard
    402*y + 352*x = 1120


    As we get more inputs I'd like to keep adding to the data and find a more and more accurate value for y and x.

    I've added the analysis add on to excel and there is so much try I was hoping someone could point me in the right direction.(If the analysis tool is what the right direction is).

    Hope the goal and situation make sense.

    Thanks

    Jonathan
    Last edited by thisandthat; 02-10-2022 at 07:00 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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