project

Sheet1

0
500	166.6
1000	212.1																			OGR=DGR * TGR
1500	242.4
2000	282.4
2500	315																		DGR= gear ratio in defferential
3000	328.3																		TGR=transmittion gear ratio
3500	335.55
4000	322.2
4500	273.05
5000	184.3																	V=dx/dt
																		TRACE= elapsed time to finish race
																		now since TGR=TGR1,
																		then EPRM which is the engine speed is given by
																		ERPM==OGR*WHEEL SPEED
																		we use the above formula to calculate initial ERPM which is the engine speed
																	ETRQ is the engine torque
												NO
							YES										it is given by wheel torgue divided by OGR
																	This is =WTORQ/OGR
										YES
																	WFOQ is the wheel force
				NO													it is given by deviding W torq by wheel radius
																				12
								NO				YES
																	TRACE is the elapsed time ratio
																	ERPM is the engine speed
																	its given by multiplying OGR by WRPM

read values of input variables from worksheet

inialize V,Y, TRACE calculate TGRRatios let TGR=TGR1 Calculate iniatial erpm

calculate ETORQ and WFORC we calculate the new V, X, TRACE and ERPM

Is X<1320?

is ERPM<SHIFTRPM?

then we output our TRACE to worksheet

IS TGR<>TGR TOP?

Shift to the next gear