Find Jobs
Hire Freelancers

Create a smart Excel spreadsheet to calculate vehicle weights

$250-750 AUD

Closed
Posted almost 9 years ago

$250-750 AUD

Paid on delivery
We currently use an Excel spreadsheet (see attached PDF) to calculate the final weight of a vehicle after we have fitted our equipment. This was done a few years ago and it has a few problems that need to be resolved and a few new features that need to be added. Vehicle Image: At the top of the document is an image of the vehicle. Currently it only shows one type which is confusing for the customer when they receive the printed document. The sheet should be modified so that there is a new drop-down list with several options which allows the user to select the type of vehicle and automatically change the picture according to their selection. some vehicle types have two seats whilst others have 4. If a 4 seat vehicle is selected, the table at the bottom should automatically add the weight of the extra passengers. If a 2 seat vehicle is selected, it should remove their weight. Vehicle load position: On many vehicles it is easy to over-load the suspension and tyres by placing the load in the wrong place on the vehicle. Currently we have to type in some different numbers to move the load around and work out the best place for it. We would like the sheet to include a graph that shows the vehicle axle loads Vs. the position of the load, relative to the front wheel. Other information: There will be around 6 vehicle types The document should be well designed so that when printed it fits nicely onto an A4 size sheet. Calculations are made by "taking moments" around the front axle. There are several verifications that are made to ensure the vehicle remains legal - These are simple calculations based on the dimensions given by the user. The current spreadsheet shall be provided to the successful bidder. Images for each vehicle type shall be provided.
Project ID: 7874931

About the project

34 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
34 freelancers are bidding on average $334 AUD for this job
User Avatar
Hi, I'll be happy to help you with this project. Please feel free to message me if you need to discuss any questions
$350 AUD in 3 days
4.9 (251 reviews)
7.6
7.6
User Avatar
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet 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).
$250 AUD in 8 days
4.9 (227 reviews)
7.4
7.4
User Avatar
I can do it for you quickly and exactly. . .
$311 AUD in 7 days
4.9 (119 reviews)
7.0
7.0
User Avatar
Hello Sir :) Im excel VBA macro and formula Expert :) i can do your job Sir :), please give me a chance for doing your job and im able to start doing your job right now :) please see my portfolio and my feedback ( the most of work that has been done its about VBA project macro ) :) Thank You Sincerely Prameswara :)
$250 AUD in 5 days
4.9 (365 reviews)
7.2
7.2
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at a some Excel projects I did: https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$300 AUD in 5 days
4.8 (198 reviews)
7.1
7.1
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. PS:I'm thinking of a worksheet where all necessary data are entered, and with the simple push of a button all the calculations (according to stipulated rules) are made, and that also can automatically generate the PDF. Best regards
$444 AUD in 5 days
4.9 (231 reviews)
6.9
6.9
User Avatar
Hi: Please note that I have 100% completion rate and 5-star feedback on all projects (>50 total completed projects). More than 90% of my completed projects are related to Excel and VBA Script. Please check my profile to confirm the quality of my work. Please connect with me to discuss more
$250 AUD in 7 days
4.9 (165 reviews)
7.0
7.0
User Avatar
Hi..I am Excel expert with experience of over 7 years...I would like to review the current spreadsheet and discuss with you further details..
$250 AUD in 5 days
4.9 (248 reviews)
6.7
6.7
User Avatar
Hello, I´m work with spreadsheets and I woul like to help you in your request, please feel free to contact me for more informations and lets make a good deal. I want to do the best for you, and any revisions that would be necessary will make. Thank you
$526 AUD in 10 days
4.8 (37 reviews)
6.5
6.5
User Avatar
Hi, I would love to work on this project. I have 8 years of experience in Microsoft Excel including working with excel modeling, dashboards and macros. Please contact with further details if interested. Regards Raghav Bansal
$289 AUD in 3 days
4.9 (95 reviews)
6.5
6.5
User Avatar
Hi, I have more than 14 years of VBA/Excel exp and I am expert in this kind of work. I have completed more than 240 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$250 AUD in 7 days
4.9 (115 reviews)
6.2
6.2
User Avatar
Hello, I read through the requirement description you shared and also saw the attachment. At a high level I understand what needs to be done and would recommend a use of macros and formulas to achieve the results you are looking for. Like for example, we could simply create a list of vehicle types on one sheet and add images to it. Now, based on vehicle selection, the appropriate image would be referred and show in the weight sheet. The other validations could be coded as well. For the graph, I will need to know how to calculate the position of the load. If you could explain this and a few other queries and share the existing workbook, I would certainly be able to create the sheet as required. Do let me know if you would like me to work on this project for you and we may discuss the next steps. Look forward to working with you and thank you for considering my bid. Regards, Rishi Automyze Consulting - The Business Process Automation and Optimization Experts
$388 AUD in 10 days
4.8 (95 reviews)
6.3
6.3
User Avatar
Having more than 11 years of experience in banking /finance/accounting, Web research, scrapping, business analysis and data analysis. Expert in MS office, complex formulae , Graphs, macros (VBA), pivot, shortcuts, templates, dashboard, etc. Worked on several complex excel VBA projects (PROFITABILITY, PO TRACKING, EXPENSE MONITORING, ACCOUNTING, ETC.,) and created several dash boards and tracking tools. Hence I can complete the task very quickly without compromising the quality
$250 AUD in 2 days
4.8 (72 reviews)
5.9
5.9
User Avatar
Hi, This is Santhosh from India. I am a Business Management Graduate with Computer Science engineering background who is passionate about Data, Mathematics and Technology. I have worked in few data analytics projects involving SAS & R. Also I have worked on many projects involving Excel (Pivot Table, Macros) and VBA. I am relatively new to freelancing so I don't have many projects to showcase in this site. I have a good experience in making Dashboards similar to your requirement. First I will give you a visualization of how the Final Output will look like and only after you are convinced,we will proceed to the next stage. I am sure that you will be 100% satisfied with my work. Please get in touch. Looking forward to hear from you. Thanks & Regards, Santhosh Kanna
$270 AUD in 5 days
5.0 (38 reviews)
5.7
5.7
User Avatar
Expert in Excel, excel functions, pivot table, graphs, Finance, experienced MBA Finance and a Bank manager as well. I can work and complete it on time.
$250 AUD in 10 days
4.7 (67 reviews)
5.7
5.7
User Avatar
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready to start Waiting for further discussion.. with thanks and regards
$333 AUD in 3 days
4.6 (43 reviews)
5.5
5.5
User Avatar
Hi, I am a mechanical engineer with master’s degree as well. Currently, I am teaching machine design courses in an Engineering University. I have technical knowledge of your work and I have also good expertise in excel. I want to make my reputation here; therefore, I will definitely give my 100% to any job I get. I assure you best work within the deadline. Thanks.
$366 AUD in 6 days
4.9 (15 reviews)
4.9
4.9
User Avatar
Hi, The total Estimated cost that I have mentioned is not final cost. First let's discuss about your project then we can finalize the cost. I am having 2 years of experience in mechanical design in National Wind Tunnel Facility, IIT Kanpur. I am having sound experience in working with CATIA, SOLIDWORKS, AUTOCAD, ANSYS, ABAQUS, MATLAB, EXCEL and other softwares needed for design. I have designed number of aerospace models for NWTF, IIT Kanpur for wind tunnel testing. What I can provide you better are: 3D modeling, drafting Surface modeling Simulation of the design Structural and Thermal Analysis Basic design calculations I believe, I can help you in this project and can provide a quality work as per your expectations. Please go through my design portfolio and profile. If you find my credentials matching with your requirement, lets discuss about all the aspects of this project. Thanks & Regards, Om Prakash Yadav
$666 AUD in 10 days
4.9 (36 reviews)
5.1
5.1
User Avatar
hi, i can create excel formulas and macros which can perform all your calculation. for example if vehicle is 2 seater remove weight and if 4 seater add weight can easily be done via formula lets discuss more on chat thanks and regards vibearning
$278 AUD in 5 days
4.9 (22 reviews)
4.4
4.4
User Avatar
I am an electromechanical engineer with five years of experience in mechanical design and development with a master degree in structural design, I have always work with Excel, even with macros and visual basic applications for Excel, you will see in my profile projects I have work for very easy excel sheets but may give you confidence about my work, I'm certain of delivering a great quality work, Thank you and I look forward to be working with you.
$300 AUD in 10 days
4.8 (13 reviews)
3.8
3.8

About the client

Flag of AUSTRALIA
Wangara, Australia
5.0
35
Payment method verified
Member since Feb 27, 2015

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.