Đang Thực Hiện

Combustion engine theory specifications in Excel spreadsheet

Hello there!

Do you know how a 4 stroke combustion engine works? Well, I don't know as much as you so I would like a good mechanical engineer to develop a spreadsheet with some intricate formulas about engines, aspirated or turbocharged.

I would like to answer some specific questions, with the spreadsheet having the appropriate commented formulas on each and places to provide the input.

For example: I have an engine that has 72HP with a 7:1 compression ratio. If I raise the compression ratio to 8:1, what would be the theoretical power increase? And if I change from using gasoline (petrol) to methanol? I believe - and this is what I am really looking for, that more information should be provided to achieve the result that I am looking for. So here is where all your knowledge comes forward.

In the above example, which is just an example of what I want, more information has to be provided to achieve the final result.

The information I am looking for, which is a must for the project to be called complete, is the following:

1 - What will be the cylinder compression based on known compression ratio? This would be measured during cranking only. Air pressure, air density, humidity and temperature should be considered.

2 - What would be the pressure on the cylinder chamber at TDC?

3 - What would be the cylinder volumetric efficiency, at various RPM, using different types of camshaft adjustment? ( I want to know here, if I change the camshaft position in relation to the piston, what will happen. For example, a 272 degrees intake camshaft: what happens if I open the valve 2 degrees earlier? 3 degrees earlier? 5 degress later? etc. These "degrees" are free input).

4 - What would be the perfect ignition timing? For example, should I set the ignition at 18 degrees BTDC? What if I use methanol instead of gasoline? When would pre-ignition occur? I know this depends, among others, on the compression ratio, cylinder compression, camshaft adjustment, spark plug, spark plug gap, air temperature, etc.

In summary, I want to determine an engine's theoretical capacity using different configurations, with all of the formulas with a nice description and comments!

Please add to your price some time that you are going to spend with me (via email, etc) to explain me and go through some of your work, if I might have any question.

Please ask any questions if you have them.


*** Deadline will be taken seriously. If not handed in by the deadline date, don't bother in delivering it anymore. Will ask for someone else to do it.

*** Communication is a must. By this, we are talking about your progress, too. So, if you are not going to work that day, please let us know, so we can keep calm on our side and be certain that the project will be completed on time.

*** Freelancer will hand in the updated files for our comments and further corrections, on a DAILY basis. This is also very important so I can understand what is going on and come back with some fresh questions.


What I need is the project to be done. Completely. Fully. Working. In all it's extent. Period. I don't want half of a project, or a partial schematic, or partial code, or partial something whatever. What I want is the FULL complete project and this is what I am willing to get and, of course, pay for.

By this, I am creating one full milestone only, to be released when all that I asked for up here is delivered. This is why I tried to be so criterious about each part. No exceptions will be made. *****PLEASE BID ONLY IF YOU ACCEPT THESE TERMS.

Kĩ năng: Kĩ thuật, Kĩ thuật cơ khí, Cơ điện tử, Vật lý

Xem nhiều hơn: working places for freelancer, working as freelancer engineer, working as a freelancer in the us, why you want to be an engineer, why i can t bid on freelancer, why do you want to work here answer, why do you want to work for us answer, why do you want to be an mechanical engineer, why do you want to be an engineer, why do you want this position, why do i want to work here, why do i want to be an engineer, where is freelancer based in, when to ask for a raise, what to get an engineer, what is power up, what is milestone in freelancer, what is engineering all about, what i need for mechanical engineering, what do freelancer do

Về Bên Thuê:
( 35 nhận xét ) BRASILIA, Brazil

ID dự án: #5249928

Được trao cho:


hello sir, ready for the job, and read all your instructions to follow, and respect it all, but you may give me an idea about the deadline date? and about the combustion engines, that's my favorite part in mechan Thêm

$277 USD trong 7 ngày
(2 Đánh Giá)

4 freelancer đang chào giá trung bình $192 cho công việc này


Professional engineer from academic institute can take care ......................................................................................................

$226 USD trong 5 ngày
(50 Nhận xét)

Hi, I am Mechanical Engineer and working in design and development dept. of local Oil Refinery Complex. I have checked all of your requirements and understand them completely. The final delivery that you want is an Thêm

$200 USD trong 10 ngày
(6 Nhận xét)

Dear Client I am currently a master student in Computational Mechanics in RUB, Germany. I can do the requred for you with accepting all your rules and regulations. I have had an extensive course on engines in my bac Thêm

$66 USD trong 3 ngày
(2 Nhận xét)