{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["NASA Data","Instructions","Compatibility Report","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NASA Data","index":0,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,{"$f":"ABS(D1-B1)","v":0},null,null,null,"Rank","Deviation"]
[1,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A2)>=1,\"\",ROW())","v":2},{"$f":"IF(ROW(A2)-ROW(A$2)+1>COUNT(B$2:B$16),\"\",INDEX(A:A,SMALL(B$2:B$16,1+ROW(A2)-ROW(A$2))))","v":1},"Une boîte d’allumettes","Box of matches ",15," Virtually worthless -- there's no oxygen on the moon to sustain combustion"]
[2,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A3)>=1,\"\",ROW())","v":3},2,"Des aliments concentrés","Food concentrate ",4,"Efficient means of supplying energy requirements"]
[3,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A4)>=1,\"\",ROW())","v":4},3,"50 mètres de corde en nylon","50 feet of nylon rope ",6,"Useful in scaling cliffs and tying injured together"]
[4,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A5)>=1,\"\",ROW())","v":5},4,"Un parachute en soie","Parachute silk",8,"Protection from the sun's rays"]
[5,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A6)>=1,\"\",ROW())","v":6},5,"Un appareil de chauffage fonctionnant sur l’énergie solaire","Portable heating unit ",13,"Not needed unless on the dark side"]
[6,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A7)>=1,\"\",ROW())","v":7},6,"Deux pistolets calibre 45","Two .45 calibre pistols ",11,"Possible means of self-propulsion"]
[7,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A8)>=1,\"\",ROW())","v":8},7,"Une caisse de lait en poudre","One case of dehydrated milk",12,"Bulkier duplication of food concentrate"]
[8,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A9)>=1,\"\",ROW())","v":9},8,"Deux réservoirs de 50 kg d’oxygène chacun","Two 50kg tanks of oxygen",1,"Most pressing survival need (weight is not a factor since gravity is one-sixth of the Earth's -- each tank would weigh only about 8.25kg on the moon)"]
[9,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A10)>=1,\"\",ROW())","v":10},9,"Une carte céleste des constellations lunaires","Stellar Map",3,"Primary means of navigation - star patterns appear essentially identical on the moon as on Earth"]
[10,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A11)>=1,\"\",ROW())","v":11},10,"Un canot de sauvetage auto-gonflable","Self-inflating life raft ",9,"CO2 bottle in military raft may be used for propulsion"]
[11,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A12)>=1,\"\",ROW())","v":12},11,"Un compas magnétique","Magnetic compass ",14,"The magnetic field on the moon is not polarized, so it's worthless for navigation"]
[12,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A13)>=1,\"\",ROW())","v":13},12,"25 litres d’eau","20 litres of water ",2,"Needed for replacement of tremendous liquid loss on the light side"]
[13,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A14)>=1,\"\",ROW())","v":14},13,"Une trousse médicale avec seringues hypodermiques","Signal flares ",10,"Use as distress signal when the mother ship is sighted"]
[14,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A15)>=1,\"\",ROW())","v":15},14,"Des signaux lumineux","First aid kit, including injection needles",7,"Needles connected to vials of vitamins injection needle medicines, etc. will fit special aperture in NASA space suit"]
[15,{"$f":"IF(COUNTIF('NASA Data'!$I$2:$I$16,A16)>=1,\"\",ROW())","v":16},15,"Un émetteur-récepteur fonctionnant sur l’énergie solaire (fréquence moyenne)","Solar-powered FM receiver-transmitter",5,"For communication with mother ship (but FM requires line-of-sight transmission and can only be used over short ranges)"]
[]
[]
[null,null,null,null,null,null,null,"Score"]
[null,null,{"$f":"SUM(C2:C16)","v":120}]
[null,null,null,null,null,null,null,"Percentage"]

{"sheet":"Instructions","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"INSTRUCTIONS"]
[]
[1,"Click on the NASA data tab at the bottom"]
[2,"Using the drop down menu select the order for your items with the most important as number 1"]
[3,"Keep selecting items until there are no items left to rank. You will need to scroll up in the for some of the score values in the drop down menu."]
[4,"Each item can only be ranked at one position"]
[5,"If you wish to change a value then you will have to click out or swap to a value that is left and then swap it or reset the quiz"]
[6,"When you are happy with your selection press the caculate score button"]
[7,"Save the document with your name and upload to the assignment"]
[]
[null,"WE KNOW that you can try this several times getting a better score but we need your initial score with the initial percentage. It doesn't matter how well you do we want to see your logical steps."]
[]
[]
[null,"Thanks Space Cadets!"]

{"sheet":"Compatibility Report","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Compatibility Report for Moon Quiz protected.xls"]
[null,"Run on 20/06/2012 17:13"]
[]
[null,"The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when opening this workbook in an earlier version of Excel or if you save this workbook in an earlier file format."]
[]
[null,"Significant loss of functionality",null,null,"# of occurrences","Version"]
[]
[null,"One or more cells in this workbook contain data validation rules which refer to values on other worksheets. These data validation rules will not be saved.",null,null,2]
[null,null,null,null,"NASA Data'!I2:I16","Excel 97-2003"]
[]
[]
[null,"Minor loss of fidelity"]
[]
[null,"Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.",null,null,1,"Excel 97-2003"]

{"sheet":"Sheet1","index":3,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[8]
[12]
[2]
[3]
[4]
[7]
[11]
[9]
[14]
[15]
[13]
[1]
[5]
[6]
[10]