Autopopulated Day to Day Rate Table using specific day rate, week rate and month rates
Each row contains details for a specific piece of equipment with differing day rates, week rates, and month rates.
The file needs to produce a table of values accounting for each active row covering the full duration of the project utilizing the entered day rate, week rate and month rate.
That way when I enter the end date or estimated end date it will pull from that table and tell me how much I’ll owe on rent if it is called off on that date.
I also have some formatting requests and buttons with assigned tasks that I would like included into the sheet. All of these additional details are explained in the attached file.
Each row contains details for a specific piece of equipment with differing day rates, week rates, and month rates.The file needs to produce a table of values accounting for each active row covering the full duration of the project utilizing the entered day rate, week rate and month rate.That way when I enter the end date or estimated end date it will pull from that table and tell me how much I’ll owe on rent if it is called off on that date.I also have some formatting requests and buttons with assigned tasks that I would like included into the sheet. All of these additional details are explained in the attached file. Read More