Create a spreadsheet to calculate vehicle drive requirements

$250-750 AUD

In Progress

Posted

over 7 years ago

$250-750 AUD

Paid on delivery

We need a simple-to-use excel spreadsheet that can be used by non-technical sales staff when they look at customer requirements. The spreadsheet will be used to calculate the required torque (Nm) and power (kW) to move and accelerate a vehicle based on a number of input parameters. The vehicles are trucks and buses that are not very aerodynamic so that must be taken into account - This important factor is often forgotten by some people. The spreadsheet must require the user to input the following data: * Width and height of vehicle (to calculate air resistance) (mm) * Wheel diameter (mm) * Number of driven wheels * A drop-down list with several options for running surface (asphalt, concrete etc.) * Gradient in the form of a ratio (for example 1:100) * Weight of the vehicle (kg) * Top speed required (km/h) * Time to reach top speed (sec) All units must be metric and as specified above. The spreadsheet must be well presented and look professional when printed on an A4 sheet. To be considered for this project your bid must explain to us why you are suitable and what relevant experience or qualifications you have.

Engineering

Excel

Mechanical Engineering

Physics

Project ID: 11369539

About the project

38 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

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

38 freelancers are bidding on average $408 AUD for this job

@someka

We will basically build a calculator for your specific need. And as this will be used by a non-technical staff we should make the layout quite clear and easy to use. I am proficient at user interface and features. I can also send you some samples or you can check my profile. I am mostly online. Lets discuss. Thanks..

$550 AUD in 4 days

5.0

(132 reviews)

7.0

@DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I am an engineer with more than 6 yrs of experience working with MS-Excel (including VBA macros). As you can see in my profile, I have built several easy-to-use excel dashboards to make repetitive work more efficient and simple. I can guarantee an excellent job and deliver as soon as possible. Thanks!

$299 AUD in 7 days

4.7

(77 reviews)

6.6

@irfanshekh

Dear Hiring Manager, Greetings for the day, I am a Design Engineer with 5 year of industrial experience, by qualification I am a Mechanical Engineer and PG in CAD/CAM. I read your requirements and found this project very interesting, I can do this task, please come in personal chat to discuss project in more details. I can use most of the CAD software like: For 3D Modelling and 3D Rendering: - Solidworks - CATIA - ProE - Creo - PDMS For FEA and CFD: - ANSYS - Abaqus - CAESAR II I have "PREFERRED FREELANCER BADGE" which you can see next to my profile picture on bid and also on my profile (https://www.freelancer.com/u/irfanshekh.html).I am well qualified, skilled and experienced for this project. Please visit my profile to check my portfolio, clients reviews on my previous work and my reputation. I am a standard member here and a full time freelancer, so you can contact me anytime. Looking forward to hear from you soon. Feel free to contact me. Thanks & Regards, Irfan Shekh

$555 AUD in 10 days

4.8

(32 reviews)

5.8

@VolKa

Hi. I am ph.d in theoretical physics and sure will be able to do this project. Regards..................

$400 AUD in 10 days

4.9

(41 reviews)

5.1

@psprongs

I have over 4 years experience creating macros and forms for excel. I also have experience in tge automotive industry work on car audio systems. Would you provide a skeleton sheet with all data needed and the formulas for calculation?

$277 AUD in 3 days

5.0

(11 reviews)

4.5

@mariannedelcu

PhD in mechanical engineering. Large experiene in design Strong knowledge in database manipulations using Excel. I will be glad to help you. Please send a message back to eztablish details.

$383 AUD in 10 days

5.0

(27 reviews)

4.4

@rainbow

I am automobile engineer working in the area of fundamentals of vehicle motion and components design fuel economy calculations are done by me . I will be able to do your job without any problem because lot of research work has been done in this area by me

$555 AUD in 10 days

4.3

(23 reviews)

5.2

@kakkanattu

Hello (I will finish the work in a short time always. Full time freelancer) I am an assistant professor in mechanical engineering. I am carrying three years of experience in teaching. Thermodynamics, heat transfer and fluid are my core areas. And also I am a post graduate in thermal engineering. All these years I have been experienced with all mechanical subjects and labs. And I am aware of all basics and core part of the subjects. In addition to this I am teaching physics online every day. I assure you a good output in very short time. I believe the price quoted is genuine and will be ready for negotiations if needed. Please see my portfolio. Hope your reply. I am aware of solidworks, CES material selection and EES. Regards Nidhin kakkanattu +919037324531 (watsapp)

$250 AUD in 2 days

4.6

(20 reviews)

4.6

@omachibrian5

Having a background in statistics and mathematics, I believe I have what it takes to perform the stipulated. I have handled data analysis in various projects among them being a binary logistic model that I had to develop to determine the probability of a student passing or failing his/her undergraduate studies within my former university. I have also worked on health data with the united nations FAO organization to get information on food security within different regions in the African continent specifically Somalia. Lately I have been involved in data process and warehousing for the SASA messenger which is a chatting app that deals with a lot of real time within a small period if time. From these projects I have been able to perfect my skills in various statistical tools and technologies such as: RStudio R-GUI Advanced Excel Epi-Info SPSS D3.js for data visualizations Shiny

$444 AUD in 10 days

5.0

(2 reviews)

2.7

@TulyakovN

Understand, how to do this job. Skills in VBA, experiance of working in word, excel, access. No problem with this job and those tasks from discription.

$250 AUD in 5 days

4.2

(5 reviews)

2.8

@techpl99SD

I I have very good experience in development of such tools which can help in quick calculation for decision making. Few of the tools I developed are - Similar tool ( mentioned by you) for design and costing of Hydraulic actuation system - PCB Dimension and packaging and costing - Vehicle data learning and generating shock load and vibration profile for electronics system - Generating loading profile based on the input data Thanks Tech

$250 AUD in 10 days

5.0

(1 review)

1.9

@Mfarzan456

i am a well professional data entry operator with great skills on Ms Office. I hope i can make out the best spreadsheet for you. Looking for your kind reply.

$250 AUD in 0 day

5.0

(1 review)

1.2

@priyankpadaria

Hey please share your photos/ design/ ideas/ concept and receive a good deliverable. I'm basically MACHINE DESIGN ENGINEER. I have a very good expertise in Machine design calculation, 3D modelling, Finite Element Analysis (FEA), Product development. Review my profile once. Feel free to contact me. You may find my profile on this link https://www.freelancer.in/hireme/priyankpadaria I've developed some Engineering calculation spread sheets for drive bogie, bending theories, leverage, pressurised cylinder or actuators, Hydraulic cylinder tonnage including KIKO (Kick In - Kick Out-) process. Let's start with some basic and preliminary work so that we can plan our project portfolio.

$250 AUD in 21 days

4.5

(2 reviews)

1.2

@ptykamikaze

I have the skills for the job you are requesting. Lets chat about your requirements! Best Regards!

$300 AUD in 5 days

5.0

(1 review)

0.8

@Hiisu

Hello, I am excited to work on creating this simple-to-use excel spreadsheet for you that can be used by your staff to calculate the required torque and power for movement and acceleration of your vehicles. I am a native English speaker with a technical background (Professional software developer) and believe that I could communicate with you effectively to determine the exact requirements of your spreadsheet. I look forward to working with you. Please contact me if you have any further questions. Thank you for your consideration, Heath Goodrum

$305 AUD in 5 days

4.0

(1 review)

0.4

@owaisali20

Hi sir I am Owais Ali and I have more than 5 years of experience in Excel Development. As because of my prior experience I really feel I can be best choice for this job. Looking forward to hear from you. Regards, Owais Ali

$250 AUD in 10 days

0.0

(0 reviews)

0.0

@Rockzainab

A proposal has not yet been provided

$555 AUD in 10 days

0.0

(0 reviews)

0.0

@fashe123

A proposal has not yet been provided

$388 AUD in 2 days

0.0

(0 reviews)

0.0

@spencerbrown351

Accurate, fast keying skills and sound knowledge of computer applications. Proven ability to collect and manage information efficiently and accurately. Excellent written and verbal communication skills and a strong desire to work hard and perform well. Skilled in planning and organizing with the ability to complete tasks on deadline. An independent worker who successfully meets the challenges of a fast-paced environment providing data entry and administrative support to a large department. Sound knowledge of database management tools and data entry technologies. Over three years experience successfully performing a number of data entry and clerical tasks. A proven track record of efficiency and accuracy in managing multiple functions, solving problems, maintaining confidentiality and producing quality work.

$800 AUD in 10 days