Hi all,
I'm trying to figure out the best way of automating a labour calculation task, to replicate what was achieved manually in the attached spreadsheet.
Starting out with 2 known values, of duration & average labour resources on-site.
I then want to divide the total duration into quarters, the 1st quarter will consume 10% of total labour, 2nd quarter 20%, 3rd = 45% & 4th = 25%.
Ideally this would all be automated after inputting the initial 2 figures, however i am unsure if this is possible.
As best I understand the request is to automatically populate column D.
This proposal employs a helper column which could be any unused column starting in row 7 and which may be hidden for aesthetic purposes.
For illustrative purposes, paste the following into cell F7 and double click the fill handle to copy down:Formula:
Please Login or Register to view this content.
Paste the following into cell D7 and double click the fill handle to copy down:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Hi JeteMc,
Thanks for your reply. That worked well in that scenario.
I have updated the sheet with a slight amendment & wonder would it be to possible to populate column D, based on 4 week blocks, rather than previous 25% of total duration blocks?
Thanks
The following formula, pasted into cell D7 and then copied down, yields the same results in columns D:E as those seen in the file attached to post #3:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks