For the Stats worksheet most of the information seems to be entered from the pdf data file, the only formula i can think of is for the Ballast required to meet the minimum car weight, are there any other formulas in the spreadsheet model???
i think this is correct because there are two drivers so there must be a formula our class thought you might need a drop down box to specift driver weight
For the Stats worksheet most of the information seems to be entered from the pdf data file, the only formula i can think of is for the Ballast required to meet the minimum car weight, are there any other formulas in the spreadsheet model???
If you look at the pdf sheet given there is information given there. The number of laps is 75 if you look at the stats sheet in the model it tells you there. The minimum car weight is 640kg. Car weight is 560kg. The driver weight depends, the man is 61 and the woman 53, easiest way to do this is by creating a drop down list on the model so you can switch between the two. The ballast section will fill itself when you enter all of the above and will varie with the driver. the lap length is 5.27km and you can get this by 392 km (which is the total length of the lap) divided by the number of laps (75)
Hope this can help.
thanks.. will try n let u know if any difficulties...
i think this is correct because there are two drivers so there must be a formula our class thought you might need a drop down box to specift driver weight
yh this could be but we thought it was unlikely as they have never asked to make a drop down box before i mean is it really that likely, or class thought you would just have to pick one driver hope this helps
If you look at the pdf sheet given there is information given there. The number of laps is 75 if you look at the stats sheet in the model it tells you there. The minimum car weight is 640kg. Car weight is 560kg. The driver weight depends, the man is 61 and the woman 53, easiest way to do this is by creating a drop down list on the model so you can switch between the two. The ballast section will fill itself when you enter all of the above and will varie with the driver. the lap length is 5.27km and you can get this by 392 km (which is the total length of the lap) divided by the number of laps (75)
Hope this can help.
THANKS,,, for the values.. have any idea about the below ones??
For the final race time, you just link the cell to I84 on the lap times sheet. The problem with this is that it seems tooo easy. Only thing we are having a problem with is figuring out what possible charts to create
For the final race time, you just link the cell to I84 on the lap times sheet. The problem with this is that it seems tooo easy. Only thing we are having a problem with is figuring out what possible charts to create
thanks for your reply, when i do this the cell generates 0 how are you linking the cell?, also the only idea our class came up with for a chart was a pie chart showing the spread of the stint laps to show that the car doesnt run our of fuel because it runs an even number of laps per refill but this doesnt seem right but i cant think of anything else
For the final race time, you just link the cell to I84 on the lap times sheet. The problem with this is that it seems tooo easy. Only thing we are having a problem with is figuring out what possible charts to create
for a chart we used final lap times for all 4 types of tyre but this seems a little complicated but this could work ?