The report develops mathematical model and Excel is ideal spreadsheet to implement a mathematical model because it is developed to carry out a number of iteration. The report uses the spreadsheet to determine the time that the engine takes to reach 3000 rpm with continuous 100% fuel input.

The Table 1 provides the layout of the spreadsheet, which reveals the time on the first row and the system variables on the subsequent columns on the right. The table 2 defines the Constant separately, which can be easily changed in order to investigate the system response.

Table 1: Layout of the Spreadsheet

A

B

C

D

E

F

G

H

I

1

Time (sec)

Fuel (%)

T

TF

TN

(Nm)

Vel

Pos

rpm

2

0

=B2*L$1

0

=C2-D2

=E2/L$3

0

0

=G2*60/(2*3.14159)

3

=$A2+0.1

=G2*L$2

=G2+(A3-A2) *0.5*(F2+F3)

=H2+(A3-A2)*0.5*(G2+G3)

4

Table 2: The Engine Parameters

K

L

Engine Parameter

1

k1=

1...
[ View Full Essay]