{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Results ","Instructions ","Sheet1"],"not_rendered":{"charts":0,"images":2,"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":"Results ","index":0,"n_rows":38,"n_cols":40,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,8,0,37],[2,1,2,2],[0,0,0,7],[1,0,1,7],[3,1,3,2],[2,5,2,7],[38,0,38,37],[7,39,34,39],[3,5,4,7],[4,1,4,2],[5,1,5,2],[5,3,5,4],[2,3,4,4],[3,8,3,37]]}
["Claro Lamp-O Results -",null,null,null,null,null,null,null,"Control Number"]
["2018-01-01",null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Time",null,null,null,"Control Value",null,null,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,10,null,"<-- Edit points if not 10"]
[null,"limit (min)",null,null,null,null,null,null,"Lamppost Number(s)"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< use for third possible value >"]
[null,"Time",null,"Controls",null,null,"Time","Final",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"< use for second possible value >"]
["Name","Min","Sec","Visited","Correct","Points","Pen.","Points",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<-- Put correct number here; use 99 for no number - not\"0\""]
[null,null,null,{"$f":"COUNT(I8:AL8)","v":0},{"$f":"SUMPRODUCT(--((I8:AL8>0)*(I8:AL8=I$7:AL$7)+((I8:AL8>0)*(I8:AL8=I$6:AL$6))+((I8:AL8>0)*(I8:AL8=I$5:AL$5))))","v":0},{"$f":"SUMPRODUCT(--((I8:AL8>0)*(I8:AL8=I$7:AL$7)+((I8:AL8>0)*(I8:AL8=I$6:AL$6))+((I8:AL8>0)*(I8:AL8=I$5:AL$5))),I$3:AL$3)","v":0},{"$f":"IF(B8>($B$5-1),IF(C8>0,B8-($B$5-1),B8-$B$5),0)*10","v":0},{"$f":"F8-G8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"<- Enter the names, times and numbers off the control cards here - In any Order.\nThe coloured ranges are auto-calculated.\n\nWhen all added, sort using a Macro by Holding down <Ctrl><Shift> and pressing <S>\n\nOnce sorted you can delete any blank rows - or just send it through for web upload, and it will be done for you."]
[null,null,null,0,{"$f":"SUMPRODUCT(--((I9:AL9>0)*(I9:AL9=I$7:AL$7)+((I9:AL9>0)*(I9:AL9=I$6:AL$6))+((I9:AL9>0)*(I9:AL9=I$5:AL$5))))","v":0},{"$f":"SUMPRODUCT(--((I9:AL9>0)*(I9:AL9=I$7:AL$7)+((I9:AL9>0)*(I9:AL9=I$6:AL$6))+((I9:AL9>0)*(I9:AL9=I$5:AL$5))),I$3:AL$3)","v":0},0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[null,null,null,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"Wrong:"]
["Comments:"]

{"sheet":"Instructions ","index":1,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["How to complete the results sheet"]
[]
["The results sheet is fairly easy to use and should do most of the analysis for you."]
[]
["1.  SETUP - For a standard Lampo this is already done for you.  The basic sheets assumes that there are 30 controls all with value 10 and that the time limit is 45 minutes."]
[null,"If you have less controls just leave the lamppost numbers (rows 5, 6 & 7) blank"]
[null,"If you want to use different points the overwrite the row of 10s on Row 3"]
[null,"If you have a different duration change the value in cell B5"]
[]
["2.  Add the answers"]
[null,"Before you add the results, type in the correct lamppost numbers in Row 7.  If there is more than one correct answer use the additional two boxes in Rows 5 & 6"]
[null,"The formula does not work with \"0\" so for a missing number use 99 or similar (not text)."]
[]
["3. Add the names, times and recorded numbers"]
[null,"After the event type in the names, finish times (minutes and seconds), and type in the recorded answers (decipher the squigles) in the relevant boxes.  Wrong numbers should  highlight yellow automatically. The scores are calculated automatically by comparing their result to your correct answer(s)."]
[null,"If there are a lot of errors against one lamppost you may need to check. If you decide to allow additional values add them in to rows 5 or 6."]
[]
["4. Sort to get results order"]
[null,"A) Run the macro to sort for you by pressing <Ctrl><Shift><S>"]
[null,"B) Alternative if macro doesn't work:"]
[null," Highlight A7 to  AL35 then click on \"Sort & Filter\" (this varies between formats and versions - see right)"]
[null,"Click on \"Custom Sort\" There should be a saved sort with 3 sort levels already saved as shown - if so just click OK."]
[null,"If not, you need to create a sort - don't forget to tick \"My data has headers\" as you should have highlighted row 7 including the headers."]
[null,"You can delete unused rows below runners data."]
[]
["5.  Add your organiser comments"]
[]
["6.  Email the completed sheet to Allen Banister, copied to Steve Fry. Emails on the website \"people\" page if you don't have them."]
[]
[null,"If you get stuck, either give it your best shot, use manual overwrite if necessary and/or ask for help. "]
[]
[null,"Original simple spreadsheet by Tim Moon or Chris Dicken?   Automated by Tim Evans March 2017 with minor updates from Vince and Allen"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}