Find Jobs
Hire Freelancers

Create Estimating spreadsheet in Excel

£20-250 GBP

Completed
Posted over 9 years ago

£20-250 GBP

Paid on delivery
We are an electric gate installation company. We require an estimating excel spreadsheet to help reduce our current labour intensive estimating process. We require a spreadsheet which allow us to select the following: - Manufacturer of Automation - Automation Model / Kit - Timber Gate Price - Size of gate - Wood type - Steel Gate Price - Size of Gate - Intercom System - Make/Model - Exit System - Exit Loop Required? - Exit Keypad Required? - Labour - Estimated hours on site - Groundworks Cost - Bricklaying Costs Basically this system requires other backend pages allow us to enter costs from our supplies as and when they change. So end user can simply select the different automation, model etc. If the job requires a timber gate, they choose the size, and wood type and price is pulled from information we enter in back end. We would also require the document to allow us to put different levels of margins say 20% 30% 40% depending how competitive we require to be. It would be great if this information could then be merged to a standardised 'Word' quote document. Which pulls the information selected in the excel document, and the separate prices down to the total price.
Project ID: 6611667

About the project

37 proposals
Remote project
Active 9 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
Hello, I've done a lot of work on quote generating programs in Excel and have done something very similar like you describe. I would envision have a worksheet tab that would house the various options with their associated costs. Then on the front sheet there would be a well laid out quote form that would have the pertinent logos/language etc. that had dropdown boxes to easily populate the pertinent fields and type in quantities and a cell where you type in your desired margin. You would also need to give consideration as to how to handle freight/duties/taxes. I look forward to possibly lending a hand.
£80 GBP in 3 days
4.8 (69 reviews)
5.5
5.5
37 freelancers are bidding on average £136 GBP for this job
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience creating spreadsheets from scratch and working with formulas and macros to process the information. Check my excel reviews and chat with me. Greetings.
£102 GBP in 2 days
5.0 (328 reviews)
7.5
7.5
User Avatar
Hi, I'll be happy to help you with this project. I guarantee accuracy, timely completion and after-completion support. Please feel free to message me if you need to discuss any questions
£200 GBP in 2 days
4.9 (251 reviews)
7.7
7.7
User Avatar
Hi I have seen your job post and understood your requirement . As an expert in web search and data analysis, I can do the job you posted within given time frame with maximum accuracy, and looking forward to work with you for longer period of time. Thanks Khushh Freelancer INDIA
£133 GBP in 5 days
4.8 (333 reviews)
7.3
7.3
User Avatar
Hi there. I am Usman and I have designed a very similar project in Excel before. I would be glad to design a pilot sheet in Excel for you to evaluate. Kindly discuss, if you are interested. Regards.
£160 GBP in 3 days
5.0 (73 reviews)
6.9
6.9
User Avatar
Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have a strong financial background (I think you need both these expertize in your project). Further, I have already developed such dynamic pricing models for various businesses. If you are comfortable with my ratings and reliability, please send me the information you have. I assure you that I will go beyond your expectations. I look forward to hearing from you. Best regards, Priyal
£150 GBP in 3 days
5.0 (194 reviews)
6.7
6.7
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
£147 GBP in 3 days
4.9 (162 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
£150 GBP in 10 days
4.9 (121 reviews)
6.3
6.3
User Avatar
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. When considering the delivery time in my bid please take into account that job specification is not yet fully completed, and the design phase of a project comes out at a very significant percentage of the total completion time! Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
£111 GBP in 5 days
4.9 (64 reviews)
5.7
5.7
User Avatar
Thank you very much for posting the ad and providing your exact requirements. The project seems to be very interesting and we'll defined. To give you a brief background of myself, I belong to India and I have graduated from India's most prestigious institute called IIT. I have over 7 years of professional work experience. I am very proficient in excel and vba and I have built a lot of business solutions and dashboards. Though I am new to this site , I have been independently freelanceing for over 2 years. I joined this site a month ago and have already won 3 contests here. Regarding the project, I am proposing the following solution but we can discuss and develop it further. 1) Home page : This will be our landing page when you open the file. From here we can go to the following places a) Create Quote b) update database c) Open quote 2) Create Quote : this is the page where you generate the quote by entering all the details you mentioned, in a userform and click on "Submit" . A quote will get generated with options to take printout, mail to the customer, save the quote. 3) update database: here you add more options, edit existing options, delete old options, provide supplier and manufacturer information etc. This will be the complete backend. 4) open quote : here we enter the customer I'd or order I'd to retrieve his quote and then either edit it based on some change requests from the customer and generate modified quote. We can also use use it for our internal reference.
£175 GBP in 2 days
4.9 (18 reviews)
5.7
5.7
User Avatar
Hello ready to start asap to deliver you, If you can give me your notes and conditions, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions), creating pretty charts and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project. I have a base of statistics, data analysis, mathematics, accounting, business analysis, cost calculating, project scheduling and project management and finance that helps in this project.
£89 GBP in 4 days
4.9 (60 reviews)
5.2
5.2
User Avatar
Pls check my portfolio, profile and contact me if interested. I have done such projects, you can award me with trust. Thanks, Tom
£194 GBP in 5 days
4.9 (34 reviews)
5.3
5.3
User Avatar
Hello! My name is Shamy López from Bolivia in South America. I'm experienced developing all types of applications using EXCEL macros and I'd be glad to collaborate with your project. Please don't hesitate to ask for a trial in case you'd like to verify the quality of my work prior to hiring. Looking forward to the oportunity of serving you, Shamy
£150 GBP in 3 days
5.0 (32 reviews)
4.9
4.9
User Avatar
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio images to see few pieces of my kind of work. (This is what I do on daily basis). I am a professional and I can do a very good job. Also fast and accurate. Do not hesitate to contact me for further details. Kind Regards, Jon
£125 GBP in 2 days
5.0 (34 reviews)
4.9
4.9
User Avatar
Greetings for the Day!!!! I have 5 years of experience in Excel and Advanced excel along with macro creations using applications like SAP, Internet Explorer, PDF and text file, MS Access and SQL Server databases. Hope if awarded with this project i can make it best and better with maximum 100% satisfaction and accuracy.. Please award me this project and contact me for further details Thanks Prabakar M
£111 GBP in 2 days
5.0 (48 reviews)
4.6
4.6
User Avatar
Hi, I would be interested to develop estimating excel spreadsheet for your labour estimating process as per your requirements. I have knowledge and experience in Excel and have worked on similar projects before and would be happy to share my previous work if you need. The assignment would be delivered with high quality through predefined template and intellectual analysis within agreed timeliness. Quality is the essence of my delivery and I get into specific details for clarity and quality. About myself, I am an experienced Finance & Accounting consulting Professional with MBA Finance and Cost & Management Accounting Intermediate and handle clients' assignments in Finance & Accounting functions. Looking forward to work with you,
£142 GBP in 5 days
5.0 (6 reviews)
3.7
3.7
User Avatar
I have over 8 years of experience in Excel and Access VBA. I have developed several Application, dashboard, Online Extraction Tools using VBA. I have done a similar project for a manufacturing company using Excel VBA.
£150 GBP in 3 days
4.9 (12 reviews)
3.9
3.9
User Avatar
Hello! I am an assistant prof in Technical University of Sofia. I have two different degrees but what I really do is automatics (DC motors, other electrical devices, car processors and so on). Usually the data is being typed into an Excel document in almost the same way you need because sometimes me and my coleagues need to use or to compare some previous data to new (details) or sth like that. I has just finished a project with excel-word sheets and submitting data by both files so your task is just what I want to do and I have enough time to work on it. Looking forward to contacting you.
£150 GBP in 3 days
4.6 (2 reviews)
3.2
3.2
User Avatar
Dear Sir Can you please chat with me first time for some clarification.I am interested to provide you this service. Thanks Sumon
£23 GBP in 3 days
5.0 (6 reviews)
2.4
2.4
User Avatar
I usually charge more for this, but I have some free time at the moment and this looks like a quick project. Please send me the details of at least 2 of the supplier costs and a brief description of how you want the input to look like. I can send you an initial output within 2 days. You can do this asap, even before you award the bid so I can snd you something you can review to help you decide on the award.
£20 GBP in 14 days
5.0 (2 reviews)
2.2
2.2
User Avatar
Hi,f I am post graduate in Computer Applications and have good knowledge of Ms-office. I assure you to complete your task with in time with 100% accuracy.I understand a freelancer's responsibilities very well. You can trust me. If i am suitable person in your view, please contact me for further discussion. Waiting in positive response.. Thanks in advance.
£167 GBP in 5 days
5.0 (2 reviews)
0.8
0.8

About the client

Flag of UNITED KINGDOM
Raywell, United Kingdom
0.0
0
Payment method verified
Member since Oct 19, 2014

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.