Find Jobs
Hire Freelancers

Create an excel spreadsheet

$750-1500 USD

Completed
Posted over 7 years ago

$750-1500 USD

Paid on delivery
Looking to have an excel spreadsheet developed that will allow us to estimate multiple line items and get totals and subtotals for the entire project. We want one main page displaying subtotals for each line item and a grand total for all line items. We would like to click a box or something like that to include or exclude different line items in the total. We would like to be able to modify the markup on each line item or all line items. We would like to be able to add or remove line items or at least be able to collapse unused line items on the totals page. All line items throughout the spreadsheet need to be able to be coded based on our coding standard (drop down List) and subtotaled by code on a separate sheet for Quickbooks entry. We would like to create and link a searchable database for material and subcontractor pricing. Attached PDF shows the required sheets and their general graphical layout are in blue. Notes are in Red. Links and questions are in green. We would provide data for the drop down item/cost code list. Everything else is just default text and functionality. We are looking for someone to develop the functionality, database, database link and blank workbook all formatted in an attractive format.
Project ID: 10993651

About the project

16 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
Hi, Great explanation, I like that pdf draft you created :) Maybe I need to ask for some texts on it, but overall it's completely understood. Feel free to review my profile page, I have worked so many excel automation with more than 260 customers across the globe. Let me know, Daniel
$750 USD in 7 days
5.0 (181 reviews)
6.4
6.4
16 freelancers are bidding on average $1,092 USD for this job
User Avatar
Hi, I'll be happy to help you with this project . I have plenty of experience in all aspects of Microsoft Excel, especially in developing custom functions and macros and can complete the job rather quick;y. You're welcome to visit my profile to see some of my recent projects, and please feel free to message me if you need to discuss any questions
$750 USD in 4 days
4.9 (247 reviews)
7.6
7.6
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
$1,176 USD in 10 days
5.0 (333 reviews)
7.5
7.5
User Avatar
Hi, I am good at Excel and vba. Looking forward to discuss further. I have seen the pdf attachment. I would like to start discussion and understand as the project goes further.
$1,500 USD in 7 days
5.0 (230 reviews)
6.7
6.7
User Avatar
Hello there. What I am planning to build is: 1. Setting up a separate sheet which will serve as a database. We will keep the records of line items here. 2. We will set the other sheet and build up relevancies as you described in your mockups. 3. We will set the pivot tables and pivot charts for easy analysis. 4. We will start writing necessary VBA code for the features which are natively not available. 5. Finally we will set the dashboard up, put the variables in it. Lets discuss further at chat. Thanks.
$800 USD in 7 days
5.0 (98 reviews)
6.6
6.6
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel Sir :) please give me a chance for doing your job and im able to start doing your job right now Thank You Sincerely Prameswara
$794 USD in 5 days
4.9 (251 reviews)
6.6
6.6
User Avatar
Hello, We can build this for you on Google Spreadsheet so it will be always online and you can access it anywhere. We have built software based on Excel and Google Sheets which I can share with you. Also, I would like to clarify certain points in the PDF. Looking forward to talk to you. Aisha
$1,330 USD in 20 days
4.9 (94 reviews)
6.6
6.6
User Avatar
I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in developing dashboards and other reporting systems in Excel using macros, VBA, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
$1,000 USD in 7 days
4.7 (116 reviews)
6.6
6.6
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
$1,058 USD in 5 days
4.9 (118 reviews)
6.3
6.3
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$1,000 USD in 5 days
4.9 (88 reviews)
6.0
6.0
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I know that you require a Spreadsheet, but I strongly advise to have an Access database instead. I would approach your project by creating a draft Access database and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html). I can send you a sample of my previous work upon request.
$750 USD in 20 days
4.8 (95 reviews)
6.1
6.1
User Avatar
Hi there, My name is Redouane. I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you
$1,500 USD in 10 days
4.9 (87 reviews)
5.6
5.6
User Avatar
Hello, my name is Andrés. First of all thank you for considering my offer. I am an industrial engineer with more than four years of experience in the simulation, process improvement and data analysis fields. Within this experience I have developed several skills in MS excel: regression analysis, time series, descriptive statistics, modeling, complex data analysis, pivot tables and charts, PowerPivot, financial analysis, macros and VBA. I have read all the project description and the handwritten notes and I understand how to build this database/spreadsheet, however I guess we can Skype or something is there more details to check or things to improve as the project goes on. I even suggested milestones according to my bid but you're free to change them. I am really interested in this project, would love to work with you and hope you give me the chance. I will do my very best. Best regards,
$800 USD in 10 days
5.0 (23 reviews)
4.9
4.9
User Avatar
Hello! We are extremely interested in this project and would love to work on this project, please reply back to discuss further. Looking forward to hear from you soon. Thanks!
$1,764 USD in 20 days
4.5 (7 reviews)
4.1
4.1
User Avatar
Greetings! After going through your project description, I am excited to work on this project. I am experienced freelancer and fully capable to produce TOP notch work according to your requirements. Contact me to discuss. Regards
$1,500 USD in 20 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Wilmington, United States
5.0
4
Payment method verified
Member since Jul 12, 2016

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.