Job Description
**Budget shown is a placeholder for posting purposes. Please propose your fixed price based on the scope below and itemize any optional add-ons.**
I have an Excel workbook with multiple tabs used for a common-area budget and DRE-style forms. I want to enter data only on two tabs (CAB and Costs) and have the rest of the workbook populate automatically.
Here is a video showing the workbook:
Scope
Build and/or repair formulas so the CAB tab (lot-based quantities, sizes, descriptions, completion dates) and the Costs tab drive the RE623-Budget sheet correctly, including rollups and totals.
Populate the 624A sheet from those inputs, including facility/component, location (lot/common area), size, cost, description/type of construction, and completion date.
Populate the 611A sheet from 624A so the same data carries through consistently. the 623, 624A, and 611A tabs should all have the same items and quantities.
Make the workbook resilient so when I delete non-applicable ...
I have an Excel workbook with multiple tabs used for a common-area budget and DRE-style forms. I want to enter data only on two tabs (CAB and Costs) and have the rest of the workbook populate automatically.
Here is a video showing the workbook:
Scope
Build and/or repair formulas so the CAB tab (lot-based quantities, sizes, descriptions, completion dates) and the Costs tab drive the RE623-Budget sheet correctly, including rollups and totals.
Populate the 624A sheet from those inputs, including facility/component, location (lot/common area), size, cost, description/type of construction, and completion date.
Populate the 611A sheet from 624A so the same data carries through consistently. the 623, 624A, and 611A tabs should all have the same items and quantities.
Make the workbook resilient so when I delete non-applicable ...
Apply for this Position
Ready to join Confidential? Click the button below to submit your application.
Submit Application