# Modelling Diesel Cycle in Excel.

1. Nov 8, 2013

### SherlockOhms

1. The problem statement, all variables and given/known data
Construct a Microsoft Excel® spreadsheet that models an internal combustion engine based on the ideal air-standard Diesel cycle. Given the minimum temperature ($T_1$) and pressure ($P_1$) in the cycle, the engine size ($V_1$), the compression ratio ($r_v$), the cut-off ratio ($r_c$) and two properties of the working fluid (Either $R$, $C_P$, $C_V$ or $\gamma$), the spreadsheet should calculate the temperature ($T$, pressure ($P$) and volume ($V$) at any point in the cycle, the work ($W$) and heat transfers ($Q$) for each process, the net work output ($W_{net}$), the Diesel cycle efficiency ($\eta_{Diesel}$) and the Carnot efficiency ($\eta_{Carnot}$) of the cycle. The spreadsheet should allow the user to vary the minimum temperature in the cycle, the compression and cut-off ratios, the inlet pressure, the engine size, and the properties of the working fluid. Note that if the engine size is not specified, all quantities should be worked out per unit mass.

2. Relevant equations
$$PV = mRT$$

3. The attempt at a solution
From the above equation it can be shown that $Pv = RT$. Seeing as for an air standard cycle, the mass is constant throughout, when $V_1$ isn't known, the rest of the values will have to be calculated per unit mass.

My problem is with the underlined, bold statement in the problem. How can I make so that excel knows, when $V_1$ is not inputted, that the rest of the problems should be carried out per unit mass? I'm just looking for a general idea here.

My general layout for this spreadsheet will be:
Section 1) Input the above stated values.

Section 2) Calculate work and heat transfers for given sections of the cycle. (I've derived expressions for all the work and heat transfers in terms of the initial conditions. This is also where the problem of when the engine capacity isn't inputted occurs. Would an IF statement, checking the earlier value of $V_1$ work here? Like IF($V_1$ = 0, {Calculate per unit mass},{Calculate normally}).)

Section 3) Tabulate and graph results.

2. Nov 8, 2013

### SteamKing

Staff Emeritus
It's going to take more than Pv = RT to model your diesel cycle. You need to assemble all of your equations, list all the inputs and outputs, and go from there.

3. Nov 8, 2013

### SherlockOhms

I was only stating that equation to illustrate that when the initial volume isn't known, the rest of the values will have to be calculated specifically. I'll be modelling it using a T-S/s and P-V/v diagram. What equations can I use to find multiple points on each of the process curves?

It's not acceptable to plot straight lines between the initial and final temperatures for each process. For example, looking at the P-V/v diagram. The first process is an isentropic compression. I can easily find the initial and final conditions of P and V/v. But, how would I go about finding intermediate points on this process curve? Would using the relation $PV^{\gamma} = k$ be the equation required to model this curve, and if so, how would I go about using this equation to find at least 100 intermediate points on the curve in excel? Thanks for the quick reply and apologies for getting off topic.

4. Nov 8, 2013

### SherlockOhms

What I'm thinking is that, I'll know my initial and final V/v. Then, if I split that interval up into, let's say, 100 different values of V/v I can use the equation $P_{intermediate}V_{intermediate}^{\gamma} = P_{Final}V_{Final}^{\gamma}$ to find the corresponding values of $P_{intermediate}$. This will give me multiple plottable points. Does this sound correct and if so, is it possible to do this in excel without the spreadsheet looking too verbose, SteamKing?