Unified Construction Bidding Spreadsheet - 13/04/2026 17:12 EDT

$500-5000 USD

Complété

Publié il y a 26 jours

$500-5000 USD

Payé lors de la livraison

Project Overview I have an existing Excel workbook used for job costing in a construction/striping business. The workbook is already functional and calculates costs based on quantities entered across multiple sheets (organized by item types such as striping widths, colors, markers, removals, etc.). Each sheet calculates unit pricing based on quantity tiers and produces totals. However, my current summary sheet only shows category totals (e.g., total striping, total removals) and does not provide a detailed, itemized breakdown. What I Want to Achieve I need to create a final summary sheet that dynamically pulls and displays ONLY the items used in a job, including: Item description (ex: 4” White Stripe, RPM Marker, etc.) Quantity entered Unit cost (based on the pricing logic already built) Total cost per item Important: The summary should ONLY display rows for items that are actually used (i.e., quantity > 0). If an item is not used (quantity is blank or zero), it should NOT appear in the summary. Current Structure Multiple sheets organized by item type (striping, removals, markers, etc.) Each sheet: User inputs quantities Unit Price remains hidden to user, Unit price is calculated via lookup tables (tiered pricing) Extended totals are calculated Final sheet: Currently shows only high-level totals (no item-level detail) Scope of Work Build a dynamic summary/output sheet that: Pulls data from all relevant sheets Consolidates into one clean table Filters out unused items automatically Ensure: No manual filtering required Clean formatting suitable for printing or exporting to PDF Maintain compatibility with my existing workbook (do not break current formulas) Preferred Approach (Open to Suggestions) I’m open to how this is built, but it may involve: Power Query, OR Advanced formulas (FILTER, UNIQUE, INDEX/MATCH, etc.), OR Pivot table with dynamic filtering, OR VBA (if necessary, but prefer non-VBA if possible) End Goal A clean, professional print-ready breakdown sheet that shows only the relevant items for a job, instead of printing multiple sheets with unused/blank items.

N° de projet : 40369656

Concernant le projet

46 propositions

Projet à distance

Actif à il y a 17 jours

Cherchez-vous à gagner de l'argent ?

Adresse e-mail

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais

Soyez payé pour votre travail

Surlignez votre proposition

Il est gratuit de s'inscrire et de faire des offres sur des travaux

Décerné à :

@indrapandu

$0 USD en 2 jours

5,0

(392 commentaires)

8,1

46 freelances proposent en moyenne $2 368 USD pour ce travail

@obelal

Hello there, This is exactly the kind of Excel enhancement I specialize in—transforming functional workbooks into clean, professional, and fully automated reporting systems without disrupting existing logic. I have strong experience working with multi-sheet costing models, tiered pricing structures, and building dynamic summary outputs that present only relevant data in a clear, print-ready format. For your project, I will: * Build a dynamic summary sheet that pulls item-level data across all sheets * Display only items with quantity > 0 (no blanks or unused rows) * Include item description, quantity, unit cost, and total cost per item * Ensure everything updates automatically with no manual filtering * Maintain your existing pricing logic and formulas without breaking anything * Format the output for clean printing or PDF export My approach will prioritize a non-VBA solution using advanced formulas (such as FILTER, INDEX/MATCH, and structured ranges) or Power Query if it improves performance and scalability. I’ve built similar systems where clarity and usability are critical—especially for job costing and operational reporting—so you can expect a solution that is both reliable and easy to use. I’m ready to start immediately and deliver a polished, professional summary sheet tailored to your workflow. Best regards, Osama Belal

$1 500 USD en 7 jours

5,0

(49 commentaires)

6,7

@diektech

Hi, This is Elias from Miami. I checked your project description and understand you need your existing Excel job-costing workbook enhanced with a dynamic final summary sheet that pulls only the items actually used in a job, showing description, quantity, unit cost, and total cost in a clean print-ready layout without affecting your current formulas. I would approach this by reviewing the workbook structure first, then building a non-VBA dynamic summary layer that consolidates data from all relevant sheets, filters out zero/blank items automatically, and keeps the output reliable for PDF export and day-to-day use. I’ve worked on similar Excel systems involving multi-sheet costing logic, dynamic summaries, and clean client-ready output sheets. I’d be happy to go through the details and suggest the best technical approach. I have a few questions to get a better understanding: Q1 – Are all item sheets structured in a similar format, or does each category sheet have different column layouts that the summary will need to normalize? Q2 – Which Excel version are you using, so I can confirm whether dynamic formulas like FILTER and LET are safe to use? Q3 – Do you want the final summary sheet grouped by category (striping, removals, markers) or as one fully combined itemized list for printing? Looking forward to hearing from you.

$2 750 USD en 7 jours

4,9

(4 commentaires)

6,6

@OscarMozo

Hi, I can help you with this. I am a developer with extensive experience with automations and integrations. I've helped clients with similar projects. Let me know your interest, Sincerely, Nicolas

$2 750 USD en 7 jours

5,0

(4 commentaires)

5,2

@juanjosec63

Hi, I have strong experience in Excel, advanced formulas, Power Query, and data automation, building dynamic reporting sheets without breaking existing workbook logic. For this setup, I would create a clean summary layer that pulls from all sheets and uses dynamic filtering (FILTER + structured references or Power Query) so only items with quantity > 0 appear automatically, while preserving your pricing logic and keeping everything print-ready. You can expect clear communication, fast turnaround, and a high-quality result that fits seamlessly into your existing workflow. Best regards, Juan

$2 500 USD en 7 jours

5,0

(3 commentaires)

4,9

@Crayon1365

Hi there, I’m an expert Microsoft Excel developer with strong experience in advanced formulas, conditional formatting, building reports connected to various data sources and VBA macro. I'm interested to check your workbook and work with you in this project. I'll deliver a professional and user friend work to you. Please feel free to message me so I can share a sample of my previous work to help you evaluate my capabilities. Also there are several screenshots of my past Ms Excel works in my profile Best regards

$500 USD en 4 jours

5,0

(9 commentaires)

4,0

@saad2038

I can build a clean, dynamic itemized summary sheet that pulls only the used items from your existing workbook without breaking your current logic. I have strong experience with advanced Excel formulas and Power Query, especially for job costing and reporting setups. My approach will consolidate data from all sheets into one structured table and use dynamic filtering (e.g., FILTER/XLOOKUP or Power Query) to display only rows where quantity > 0. The summary will include item description, quantity, unit cost, and total, formatted in a professional, print-ready layout. The solution will be fully automated (no manual steps), scalable for future updates, and compatible with your existing workbook. I’ll also ensure the output is clean and easy to export as PDF for client-facing use.

$4 000 USD en 7 jours