Find Jobs
Hire Freelancers

Change Order Template - Create Excel Workbook Summarizing Data from Other Excel Workbooks

$750-1500 USD

In Progress
Posted about 10 years ago

$750-1500 USD

Paid on delivery
1) Current Change Order Template is a 10-worksheet workbook with 2 additional sheets with reference data 2) Pricing is linked to an external workbook that contains labor rates, material pricing, etc. 3) Macros exist to automatically export the change order to PDF (only the applicable worksheets, not the entire workbook) 4) The ultimate goal is to have a summary log automatically created based on each change order. The log would include the total change order value, labor hours, material costs, etc. How this would be achieved is the part I need your help with. I’m OK with one master workbook that contains 50 change order templates…or if it makes more sense, create a log in a separate workbook that’s linked to the change orders (as long as it’s linked automatically and remains linked regardless of the file name/location). The size of the workbook is important, but not critical. The current change order template workbook is 2 MB. My concern is that if we have multiple templates within a workbook, the file size will be astronomical. Hence the logic of having the log in a separate workbook as long as it’s automatically linked. Attached is a PDF sample of the log and change order. This project requires a non-disclosure agreement.
Project ID: 5328771

About the project

2 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Anaheim, United States
5.0
11
Payment method verified
Member since Jan 12, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.