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]