[Year 12 IT Apps] vlookup

[Phillip Pike]

This one also uses vlookups, checkboxes and Ifs 


Phil Pike
Director of ICT
Bacchus Marsh Grammar
P (03) 5366 4800
F (03) 53664850
 

-----Original Message-----
From: forster at ozonline.com.au [mailto:forster at ozonline.com.au] 
Sent: Tuesday, 19 August 2008 1:33 PM
To: itapps at edulists.com.au
Subject: [Year 12 IT Apps] vlookup

Dont know if this is of any use:

The attached spreadsheet uses vlookup
It is a solution for the physics two connected balloons problem - do they
equalise or does the smaller deflate into the larger.
The user enters 6 breakpoints on a balloon p-v curve

the inflation vs time is then iteratively calculated doing a vlookup of the
p-v curve _______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe IT
Applications Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and http://www.vitta.org.au  -
VITTA Victorian Information Technology Teachers Association Inc

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Belmont paving co.doc
Type: application/msword
Size: 41472 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20080819/8922fa76/Belmontpavingco-0001.doc