{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input","Data","Results","Next_Worksheet","Prize_Schedule","Sort_First_Round","ISPA_Scores","Version_Control"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":3,"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":"Input","index":0,"n_rows":255,"n_cols":37,"rows_kept":255,"cut":false,"hidden":false,"merged":[[0,0,0,16],[12,11,12,13],[12,8,12,10],[12,5,12,7],[12,2,12,4],[7,31,7,32],[7,34,7,35],[6,31,6,36],[253,0,253,1],[254,0,254,1],[38,5,38,7]]}
["Germania Klub - Skat Gruppe -- Weekly Tournaments  Input Sheet"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,"A) Enter tournament date as \"dd-mmm-yy\":",null,null,null,null,"B) If required, change # of days to the next tournament (very seldom)"]
[null,null,"2024-12-07",null,null,null,null,null,7,"which thus is:",null,{"$f":"+C5+I5","v":"2024-12-14"}]
[]
[null,"If applicable, enter name of any NEW guest as \"z*Last Name, First Name\" & afterwards press this button",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,"L o o k - U p   T a b l e"]
[null,null,"z*",null,null,null,null,"Repeat, if more than one new guest.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Name  (z* = Guest)",null,"Start #","Name  (z* = Guest)",null,"Start #"]
[]
[null,"Enter a) Round #, b) (permanent) Start numbers (*), c) Scores, incl. # of games won & lost & d) # of \"eingepaste\" games",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,{"$f":"+$B201","v":"z*Eggers, Barbara"},null,{"$f":"+$D201","v":1},{"$f":"+$B226","v":0},null,{"$f":"+$D226","v":26}]
[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,"z*Asbury, Mandi",null,2,0,null,27]
[null,"Round #",1,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,0,null,3,0,null,28]
[null,"Names (verify!)",{"$f":"VLOOKUP(C14,$A$201:$B$300,2)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(F14,$A$201:$B$300,2)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(I14,$A$201:$B$300,2)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP(L14,$A$201:$B$300,2)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Carl, Erwin",null,4,0,null,29]
[null,"Start #"," ","W","L"," ","W","L"," ","W","L"," ","W","L","E","Games",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Dietrich, Horst",null,5,0,null,30]
[null,"Score",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+D15+E15+G15+H15+J15+K15+M15+N15+O15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Kamer, Lance",null,6,0,null,31]
[null,"W - L x 50",{"$f":"SUM(D15-E15)*50","v":0},null,null,{"$f":"SUM(G15-H15)*50","v":0},null,null,{"$f":"SUM(J15-K15)*50","v":0},null,null,{"$f":"SUM(M15-N15)*50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Reinke, Fred",null,7,0,null,32]
[null,"lost by others",{"$f":"IF(L15=\"\",SUM(H15+K15)*40,SUM(H15+K15+N15)*30)","v":0},null,null,{"$f":"IF(L15=\"\",SUM(E15+K15)*40,SUM(E15+K15+N15)*30)","v":0},null,null,{"$f":"IF(L15=\"\",SUM(E15+H15)*40,SUM(E15+H15+N15)*30)","v":0},null,null,{"$f":"IF(L15=\"\",\"\",SUM(E15+H15+K15)*30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Feld, Manfred",null,8,0,null,33]
[null,"Final Score",{"$f":"SUM(C15:C17)","v":0},null,null,{"$f":"SUM(F15:F17)","v":0},null,null,{"$f":"SUM(I15:I17)","v":0},null,null,{"$f":"SUM(L15:L17)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Frank, Heidemarie",null,9,0,null,34]
[null,null,"After entry of data in the light blue cells compare Final Scores and Names with \"Liste\", if correct press",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,"z*Kamps, Thomas",null,10,0,null,35]
[null,null,"            if incorrect, either you need to correct an input error or correct the \"Listenführer's\" calculation error.",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,{"$f":"+$B211","v":"z*Koenen, Willi"},null,{"$f":"+$D211","v":11},{"$f":"+$B236","v":0},null,{"$f":"+$D236","v":36}]
[null,"              You have so far moved ",null,null,{"$f":"+F255","v":0},"  scores for the FIRST round and",null,null,null,{"$f":"+G255","v":0},"  scores for the SECOND round.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"z*Rausch. Thomas",null,12,0,null,37]
[null,"After all scores have been entered and moved these two figures MUST agree with the number of players for each",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,"z*Mandl, Sabine",null,13,0,null,38]
[null,"round (including any entered via step 4 below).  If not (but ONLY then), you need to start over again. Press ",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,"z*Polap, Adolf",null,14,0,null,39]
[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,"z*Kamps, Hermann",null,15,0,null,40]
[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,"z*Rischke, Harry",null,16,0,null,41]
[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,0,null,17,0,null,42]
[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,0,null,18,0,null,43]
[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,"z*Schmitz, Miranda",null,19,0,null,44]
[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,0,null,20,0,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,0,null,21,0,null,46]
[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,0,null,22,0,null,47]
[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,0,null,23,0,null,48]
[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,0,null,24,0,null,49]
[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,0,null,25,0,null,50]
[]
[null,"Only to be executed in case a player came late & participated only in the 2nd Round. (N/A if someone leaves early & doesn't play the 2nd Round) "]
[null,"Player will receive the average Score of the first round which is",null,null,null,null,null,null,{"$f":"ROUND(+F254,0)","v":0},null,null,"  Repeat  task, if applicable to another player"]
[null,"Enter Player's (permanent) Start #:",null,null,null," "]
[null,"Verify Player's name:",null,null,null,{"$f":"VLOOKUP(F38,$A$201:$B$300,2)","v":{"$error":"#N/A"}},null,null,"If correct move average Score:"]
[]
[null,"After all \"Listen\" have been entered in step 3 and the scores for each \"Liste\" moved: "]
[null," 1) update the info to the \"Data\", \"Results\" and \"Next_Worksheet\" spreadsheets"]
[null," 2) clear the \"Input\" spreadsheet to be ready for next week's entries"]
[null," 3) sort the \"Results\" and \"Next_Worksheet\" spreadsheets and enter the prizes on the \"Results\" sheet"]
[null,"     all in one step by pressing"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"If after having pressed the \"Finalize the Update\""]
[null,"Important",null,null,null,null,null,null,null,null,"the \"Verification check\" shows correct dates, go"]
[null,"Verification Results:",null,null,null,null,null,null,null,null,"to the \"Results\" sheet to make, (if required)"]
[null,"This is at present the LAST date for which score data has",null,null,null,null,null,null,null,null,"changes to the \"Upcoming Events\" section and"]
[null,"been recorded (transferred to) the DATA sheet",null,null,null,null,null,null,"2023-12-09",null,"to print the \"Results\" and \"Next_Worksheet\""]
[null,null,null,null,null,null,null,null,null,null,"sheets using the provided printing macros."]
[null,"This is at present the PREVIOUS date for which score data has",null,null,null,null,null,null,null,null,"To go there press"]
[null,"been recorded (transferred to) the DATA sheet",null,null,null,null,null,null,"2023-12-02",null,null," "]
[]
[null,null,"The following must be TRUE  P R I O R to pressing the \"Finalize the Update\" button"]
[null,null,"a) The LAST date above must equal the previous tournament date (not the one you have entered above in Step 1)"]
[null,null,"b) Both dates above must NEVER be identical"]
[]
[null,null,"The following must be TRUE   A F T E R  having pressed the \"Finalize the Update\" button.  If TRUE go to"]
[null,null,"a) The LAST date above must equal the current tournament date (I.e.the one you have entered above in Step 1)"]
[null,null,"b) Both dates above must NEVER be identical"]
[]
[null,"Note:","If both dates are identical, then the \"Finalize the Update\" button has been pressed twice for the same"]
[null,null,"week and the resulting \"year-to-date\" score data is incorrect. Go to"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["To go back to the top",null,"PLEASE do not change the width of column \"G\"!!!"]
["             press",null,"The font size has been changed instead so you can read the info in column \"G\""]
[null,null,"The font size does not affect the transferring of this info to the \"Data\" sheet."]
[null,null,null,null,null,"Scores for transfer"]
["Look-up Table",null,null,"for Info",null,"to \"Data\" sheet",null,null,"for Info",null,"Info"]
["Start #","Last Name, First Name",null,"Start#","ISPA#","1st Round","2nd Round",null,"Total",null,"Club"]
[null,null,null,null,null,{"$f":"+C5","v":"2024-12-07"},{"$f":"+C5","v":"2024-12-07"}]
[1,"z*Eggers, Barbara",null,1,645,0,0,null,{"$f":"+F201+G201","v":0},null,"HAM",0,0,null,null,null,null,null,null,645,"HAM"]
[2,"z*Asbury, Mandi",null,2,773,0,0,null,{"$f":"+F202+G202","v":0},null,"HAM",0,0,null,null,null,null,null,null,773,"HAM"]
[3,null,null,3,null,0,0,null,0,null,null,0,0]
[4,"z*Carl, Erwin",null,4,null,0,0,null,{"$f":"+F204+G204","v":0},null,null,0,0]
[5,"z*Dietrich, Horst",null,5,null,0,0,null,0,null,null,0,0]
[6,"z*Kamer, Lance",null,6,null,0,0,null,0,null,null,0,0]
[7,"z*Reinke, Fred",null,7,null,0,0,null,0,null,null,0,0]
[8,"z*Feld, Manfred",null,8,null,0,0,null,{"$f":"+F208+G208","v":0},null,null,0,0]
[9,"z*Frank, Heidemarie",null,9,414,0,0,null,0,null,"HAM",0,0,null,null,null,null,null,null,414,"HAM"]
[10,"z*Kamps, Thomas",null,10,null,0,0,null,{"$f":"+F210+G210","v":0},null,null,0,0]
[11,"z*Koenen, Willi",null,11,480,0,0,null,{"$f":"+F211+G211","v":0},null,"HAM",0,0,null,null,null,null,null,null,480,"HAM"]
[12,"z*Rausch. Thomas",null,12,481,0,0,null,0,null,"HAM",0,0,null,null,null,null,null,null,481,"HAM"]
[13,"z*Mandl, Sabine",null,13,null,0,0,null,0,null,null,0,0]
[14,"z*Polap, Adolf",null,14,null,0,0,null,0,null,null,0,0]
[15,"z*Kamps, Hermann",null,15,null,0,0,null,0,null,null,0,0]
[16,"z*Rischke, Harry",null,16,null,0,0,null,0,null,null,0,0]
[17,null,null,17,null,0,0,null,0,null,null,0,0]
[18,null,null,18,null,0,0,null,0,null,null,0,0]
[19,"z*Schmitz, Miranda",null,19,114,0,0,null,0,null,"HAM",0,0,null,null,null,null,null,null,114,"HAM"]
[20,null,null,20,null,0,0,null,0,null,null,0,0]
[21,null,null,21,null,0,0,null,0,null,null,0,0]
[22,null,null,22,null,0,0,null,0,null,null,0,0]
[23,null,null,23,null,0,0,null,0,null,null,0,0]
[24,null,null,24,null,0,0,null,0,null,null,0,0]
[25,null,null,25,null,0,0,null,0,null,null,0,0]
[26,null,null,26,null,0,0,null,{"$f":"+F226+G226","v":0},null,null,0,0]
[27,null,null,27,null,0,0,null,{"$f":"+F227+G227","v":0},null,null,0,0]
[28,null,null,28,null,0,0,null,0,null,null,0,0]
[29,null,null,29,null,0,0,null,0,null,null,0,0]
[30,null,null,30,null,0,0,null,{"$f":"+F230+G230","v":0},null,null,0,0]
[31,null,null,31,null,0,0,null,{"$f":"+F231+G231","v":0},null,null,0,0]
[32,null,null,32,null,0,0,null,0,null,null,0,0]
[33,null,null,33,null,0,0,null,0,null,null,0,0]
[34,null,null,34,null,0,0,null,0,null,null,0,0]
[35,null,null,35,null,0,0,null,0,null,null,0,0]
[36,null,null,36,null,0,0,null,{"$f":"+F236+G236","v":0},null,null,0,0]
[37,null,null,37,null,0,0,null,0,null,null,0,0]
[38,null,null,38,null,0,0,null,0,null,null,0,0]
[39,null,null,39,null,0,0,null,{"$f":"+F239+G239","v":0},null,null,0,0]
[40,null,null,40,null,0,0,null,0,null,null,0,0]
[41,null,null,41,null,0,0,null,0,null,null,0,0]
[42,null,null,42,null,0,0,null,0,null,null,0,0]
[43,null,null,43,null,0,0,null,0,null,null,0,0]
[44,null,null,44,null,0,0,null,0,null,null,0,0]
[45,null,null,45,null,0,0,null,0,null,null,0,0]
[46,null,null,46,null,0,0,null,0,null,null,0,0]
[47,null,null,47,null,0,0,null,0,null,null,0,0]
[48,null,null,48,null,0,0,null,0,null,null,0,0]
[49,null,null,49,null,0,0,null,0,null,null,0,0]
[50,null,null,50,null,0,0,null,0,null,null,0,0]
[]
["Total",null,null,null,null,{"$f":"SUM(F201:F250)","v":0},{"$f":"SUM(G201:G250)","v":0},null,{"$f":"SUM(I201:I250)","v":0}]
[]
["Average",null,null,null,null,{"$f":"IF(F252=0,0,F252/F255)","v":0},{"$f":"IF(G252=0,0,G252/G255)","v":0},null,{"$f":"IF(I252=0,0,I252/I255)","v":0}]
["Number of Players",null,null,null,null,{"$f":"COUNTIF(F201:F250, \"<>0\")","v":0},{"$f":"COUNTIF(G201:G250, \"<>0\")","v":0},null,{"$f":"COUNTIF(I201:I250, \"<>0\")","v":0}]

{"sheet":"Data","index":1,"n_rows":175,"n_cols":61,"rows_kept":175,"cut":false,"hidden":false,"merged":[[0,2,0,15],[0,0,0,1],[59,0,59,1],[56,0,56,1],[57,0,57,1],[108,59,120,61],[174,0,174,1],[1,0,1,1],[60,0,60,1],[115,0,115,1],[116,0,116,1],[119,0,119,1],[118,0,118,1]]}
["First Grouping",null,"Germania Klub - Skat Gruppe -- Weekly Tournaments"]
["Erste Runde",null,1,{"$f":"+C2+1","v":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,31,32,33,{"$f":"+AI2+1","v":34},35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,null,null,"Last Week"]
["Start #","Name          (z*=Guest)",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for copying"]
[{"$f":"+Input!A201","v":1},{"$f":"+Input!B201","v":"z*Eggers, Barbara"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"VLOOKUP(A4,$A$4:$BB$53,$BE$57+2,FALSE)","v":"z*Eggers, Barbara"}]
[{"$f":"+Input!A202","v":2},{"$f":"+Input!B202","v":"z*Asbury, Mandi"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Asbury, Mandi"]
[{"$f":"+Input!A203","v":3},{"$f":"+Input!B203","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A204","v":4},{"$f":"+Input!B204","v":"z*Carl, Erwin"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Carl, Erwin"]
[{"$f":"+Input!A205","v":5},{"$f":"+Input!B205","v":"z*Dietrich, Horst"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Dietrich, Horst"]
[{"$f":"+Input!A206","v":6},{"$f":"+Input!B206","v":"z*Kamer, Lance"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Kamer, Lance"]
[{"$f":"+Input!A207","v":7},{"$f":"+Input!B207","v":"z*Reinke, Fred"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Reinke, Fred"]
[{"$f":"+Input!A208","v":8},{"$f":"+Input!B208","v":"z*Feld, Manfred"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Feld, Manfred"]
[{"$f":"+Input!A209","v":9},{"$f":"+Input!B209","v":"z*Frank, Heidemarie"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Frank, Heidemarie"]
[{"$f":"+Input!A210","v":10},{"$f":"+Input!B210","v":"z*Kamps, Thomas"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Kamps, Thomas"]
[{"$f":"+Input!A211","v":11},{"$f":"+Input!B211","v":"z*Koenen, Willi"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Koenen, Willi"]
[{"$f":"+Input!A212","v":12},{"$f":"+Input!B212","v":"z*Rausch. Thomas"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Rausch. Thomas"]
[{"$f":"+Input!A213","v":13},{"$f":"+Input!B213","v":"z*Mandl, Sabine"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Mandl, Sabine"]
[{"$f":"+Input!A214","v":14},{"$f":"+Input!B214","v":"z*Polap, Adolf"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Polap, Adolf"]
[{"$f":"+Input!A215","v":15},{"$f":"+Input!B215","v":"z*Kamps, Hermann"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Kamps, Hermann"]
[{"$f":"+Input!A216","v":16},{"$f":"+Input!B216","v":"z*Rischke, Harry"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Rischke, Harry"]
[{"$f":"+Input!A217","v":17},{"$f":"+Input!B217","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A218","v":18},{"$f":"+Input!B218","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A219","v":19},{"$f":"+Input!B219","v":"z*Schmitz, Miranda"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Schmitz, Miranda"]
[{"$f":"+Input!A220","v":20},{"$f":"+Input!B220","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A221","v":21},{"$f":"+Input!B221","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A222","v":22},{"$f":"+Input!B222","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A223","v":23},{"$f":"+Input!B223","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A224","v":24},{"$f":"+Input!B224","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A225","v":25},{"$f":"+Input!B225","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A226","v":26},{"$f":"+Input!B226","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A227","v":27},{"$f":"+Input!B227","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A228","v":28},{"$f":"+Input!B228","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A229","v":29},{"$f":"+Input!B229","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A230","v":30},{"$f":"+Input!B230","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A231","v":31},{"$f":"+Input!B231","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A232","v":32},{"$f":"+Input!B232","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A233","v":33},{"$f":"+Input!B233","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"VLOOKUP(A36,$A$4:$BB$53,$BE$57+2,FALSE)","v":0}]
[{"$f":"+Input!A234","v":34},{"$f":"+Input!B234","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A235","v":35},{"$f":"+Input!B235","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A236","v":36},{"$f":"+Input!B236","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A237","v":37},{"$f":"+Input!B237","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A238","v":38},{"$f":"+Input!B238","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A239","v":39},{"$f":"+Input!B239","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A240","v":40},{"$f":"+Input!B240","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A241","v":41},{"$f":"+Input!B241","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A242","v":42},{"$f":"+Input!B242","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A243","v":43},{"$f":"+Input!B243","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A244","v":44},{"$f":"+Input!B244","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A245","v":45},{"$f":"+Input!B245","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A246","v":46},{"$f":"+Input!B246","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A247","v":47},{"$f":"+Input!B247","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A248","v":48},{"$f":"+Input!B248","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A249","v":49},{"$f":"+Input!B249","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+Input!A250","v":50},{"$f":"+Input!B250","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,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,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,{"$f":"INDIRECT(ADDRESS(ROW($C54:$BB54),MAX(($C54:$BB54<>0)*(COLUMN($C54:$BB54)))))","v":{"$error":"#VALUE!"}}]
["Summe",null,{"$f":"SUM(C4:C53)","v":0},{"$f":"SUM(D4:D53)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P4:P53)","v":0},{"$f":"SUM(Q4:Q53)","v":0},{"$f":"SUM(R4:R53)","v":0},{"$f":"SUM(S4:S53)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AC4:AC53)","v":0},0,{"$f":"SUM(AE4:AE53)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AP4:AP53)","v":0},{"$f":"SUM(AQ4:AQ53)","v":0},{"$f":"SUM(AR4:AR53)","v":0},{"$f":"SUM(AS4:AS53)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUMIF(BE4:BE53, \"<>0\")","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,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,{"$f":"INDIRECT(ADDRESS(ROW($C56:$BB56),MAX(($C56:$BB56<>0)*(COLUMN($C56:$BB56)))))","v":{"$error":"#VALUE!"}}]
["Durchschnitt",null,{"$f":"IF(C55=0,0,C55/C58)","v":0},{"$f":"IF(D55=0,0,D55/D58)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(P55=0,0,P55/P58)","v":0},{"$f":"IF(Q55=0,0,Q55/Q58)","v":0},{"$f":"IF(R55=0,0,R55/R58)","v":0},{"$f":"IF(S55=0,0,S55/S58)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AC55=0,0,AC55/AC58)","v":0},0,{"$f":"IF(AE55=0,0,AE55/AE58)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AP55=0,0,AP55/AP58)","v":0},{"$f":"IF(AQ55=0,0,AQ55/AQ58)","v":0},{"$f":"IF(AR55=0,0,AR55/AR58)","v":0},{"$f":"IF(AS55=0,0,AS55/AS58)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"COUNTIF(C58:BB58,\">0\")","v":0},{"$f":"+C3+(BE57*7)","v":"00:00:00"}]
["Number of Players",null,{"$f":"COUNTIF(C4:C53, \"<>0\")","v":0},{"$f":"COUNTIF(D4:D53, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(P4:P53, \"<>0\")","v":0},{"$f":"COUNTIF(Q4:Q53, \"<>0\")","v":0},{"$f":"COUNTIF(R4:R53, \"<>0\")","v":0},{"$f":"COUNTIF(S4:S53, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AC4:AC53, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AP4:AP53, \"<>0\")","v":0},{"$f":"COUNTIF(AQ4:AQ53, \"<>0\")","v":0},{"$f":"COUNTIF(AR4:AR53, \"<>0\")","v":0},{"$f":"COUNTIF(AS4:AS53, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,null,null,"No of Weeks","Date"]
[]
["Second Grouping"]
["Zweite Runde",null,{"$f":"+C2","v":1},{"$f":"+D2","v":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,{"$f":"+AC2","v":27},28,29,30,31,32,33,34,35,36,{"$f":"+AM2","v":37},38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,null,null,"Last Week"]
[{"$f":"+A3","v":"Start #"},{"$f":"+B3","v":"Name          (z*=Guest)"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for copying"]
[{"$f":"+A4","v":1},{"$f":"+B4","v":"z*Eggers, Barbara"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"VLOOKUP(A63,$A$63:$BB$112,$BE$116+2,FALSE)","v":"z*Eggers, Barbara"}]
[2,{"$f":"+B5","v":"z*Asbury, Mandi"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"VLOOKUP(A64,$A$63:$BB$112,$BE$116+2,FALSE)","v":"z*Asbury, Mandi"}]
[3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[4,"z*Carl, Erwin",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Carl, Erwin"]
[5,"z*Dietrich, Horst",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Dietrich, Horst"]
[6,"z*Kamer, Lance",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Kamer, Lance"]
[7,"z*Reinke, Fred",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Reinke, Fred"]
[8,"z*Feld, Manfred",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Feld, Manfred"]
[9,"z*Frank, Heidemarie",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Frank, Heidemarie"]
[10,"z*Kamps, Thomas",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Kamps, Thomas"]
[11,"z*Koenen, Willi",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Koenen, Willi"]
[12,"z*Rausch. Thomas",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Rausch. Thomas"]
[13,"z*Mandl, Sabine",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Mandl, Sabine"]
[14,"z*Polap, Adolf",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Polap, Adolf"]
[15,"z*Kamps, Hermann",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Kamps, Hermann"]
[16,"z*Rischke, Harry",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Rischke, Harry"]
[17,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[18,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[19,"z*Schmitz, Miranda",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,"z*Schmitz, Miranda"]
[20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[{"$f":"+A24","v":21},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[22,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[23,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[24,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[27,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[28,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[29,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[31,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[32,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[33,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[34,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[35,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[36,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[37,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[38,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[39,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[41,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[42,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[43,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[44,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[45,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[46,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[47,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0,null,null,"In column BI we are checking for potential minus scores via \"SMALL\" formula re 25 week Ave, as those ignord by \"LARGE\" formula in column BF.                              However, any minus figures showing up in column BI need to be only considered if that person has a combined total of 25 or less games at year end, at which time the result of column BI need to be added to column BF for that person (at YEAR END only)"]
[48,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[49,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
[50,{"$f":"+B53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,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,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,{"$f":"INDIRECT(ADDRESS(ROW($C113:$BB113),MAX(($C113:$BB113<>0)*(COLUMN($C113:$BB113)))))","v":{"$error":"#VALUE!"}}]
["Summe",null,{"$f":"SUM(C63:C112)","v":0},{"$f":"SUM(D63:D112)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P63:P112)","v":0},{"$f":"SUM(Q63:Q112)","v":0},{"$f":"SUM(R63:R112)","v":0},{"$f":"SUM(S63:S112)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(AC63:AC112)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AP63:AP112)","v":0},{"$f":"SUM(AQ63:AQ112)","v":0},{"$f":"SUM(AR63:AR112)","v":0},{"$f":"SUM(AS63:AS112)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"SUMIF(BE63:BE112, \"<>0\")","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,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,{"$f":"INDIRECT(ADDRESS(ROW($C115:$BB115),MAX(($C115:$BB115<>0)*(COLUMN($C115:$BB115)))))","v":{"$error":"#VALUE!"}}]
["Durchschnitt",null,{"$f":"IF(C114=0,0,C114/C117)","v":0},{"$f":"IF(D114=0,0,D114/D117)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(P114=0,0,P114/P117)","v":0},{"$f":"IF(Q114=0,0,Q114/Q117)","v":0},{"$f":"IF(R114=0,0,R114/R117)","v":0},{"$f":"IF(S114=0,0,S114/S117)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(AC114=0,0,AC114/AC117)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AP114=0,0,AP114/AP117)","v":0},{"$f":"IF(AQ114=0,0,AQ114/AQ117)","v":0},{"$f":"IF(AR114=0,0,AR114/AR117)","v":0},{"$f":"IF(AS114=0,0,AS114/AS117)","v":0},0,0,0,0,0,0,0,0,0,null,null,{"$f":"COUNTIF(C117:BB117,\">0\")","v":0}]
["Number of Players",null,{"$f":"COUNTIF(C63:C112, \"<>0\")","v":0},{"$f":"COUNTIF(D63:D112, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(P63:P112, \"<>0\")","v":0},{"$f":"COUNTIF(Q63:Q112, \"<>0\")","v":0},{"$f":"COUNTIF(R63:R112, \"<>0\")","v":0},{"$f":"COUNTIF(S63:S112, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AC63:AC112, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AP63:AP112, \"<>0\")","v":0},{"$f":"COUNTIF(AQ63:AQ112, \"<>0\")","v":0},{"$f":"COUNTIF(AR63:AR112, \"<>0\")","v":0},{"$f":"COUNTIF(AS63:AS112, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,null,null,"No of Weeks"]
[]
["Third Grouping"]
["Summe von  2 Runden",null,{"$f":"+C2","v":1},{"$f":"+D2","v":2},3,4,5,6,7,8,9,10,11,12,13,{"$f":"+P2","v":14},{"$f":"+Q2","v":15},16,17,18,19,20,21,22,23,24,25,26,{"$f":"+AC2","v":27},28,29,30,31,32,33,34,35,36,37,38,39,{"$f":"+AP2","v":40},{"$f":"+AQ2","v":41},42,43,44,45,46,47,48,49,{"$f":"+AZ2","v":50},51,52,null,"Total Score","Last Score","25 week","# of weeks"]
[{"$f":"+A62","v":"Start #"},{"$f":"+B62","v":"Name          (z*=Guest)"},{"$f":"+C3","v":"00:00:00"},{"$f":"+D3","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"+P3","v":"00:00:00"},{"$f":"+Q3","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"+AC3","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",{"$f":"+AP3","v":"00:00:00"},{"$f":"+AQ3","v":"00:00:00"},"00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00","00:00:00",null,"for copying","for copying","Ave. for copying","played for copying"]
[{"$f":"+A4","v":1},"z*Eggers, Barbara",{"$f":"+C4+C63","v":0},{"$f":"+D4+D63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC4+AC63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AP4+AP63","v":0},{"$f":"+AQ4+AQ63","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C122:BB122)","v":0},{"$f":"INDIRECT(ADDRESS(ROW($C122:$BB122),MAX(($C122:$BB122<>0)*(COLUMN($C122:$BB122)))))","v":{"$error":"#VALUE!"}},{"$f":"(+LARGE(C122:BB122,1)+LARGE(C122:BB122,2)+LARGE(C122:BB122,3)+LARGE(C122:BB122,4)+LARGE(C122:BB122,5)+LARGE(C122:BB122,6)+LARGE(C122:BB122,7)+LARGE(C122:BB122,8)+LARGE(C122:BB122,9)+LARGE(C122:BB122,10)+LARGE(C122:BB122,11)+LARGE(C122:BB122,12)+LARGE(C122:BB122,13)+LARGE(C122:BB122,14)+LARGE(C122:BB122,15)+LARGE(C122:BB122,16)+LARGE(C122:BB122,17)+LARGE(C122:BB122,18)+LARGE(C122:BB122,19)+LARGE(C122:BB122,20)+LARGE(C122:BB122,21)+LARGE(C122:BB122,22)+LARGE(C122:BB122,23)+LARGE(C122:BB122,24)+LARGE(C122:BB122,25))/25","v":0},{"$f":"COUNTIF(C122:BB122, \"<>0\")","v":0},null,{"$f":"(+SMALL(C122:BB122,1)+SMALL(C122:BB122,2)+SMALL(C122:BB122,3)+SMALL(C122:BB122,4)+SMALL(C122:BB122,5)+SMALL(C122:BB122,6)+SMALL(C122:BB122,7)+SMALL(C122:BB122,8)+SMALL(C122:BB122,9)+SMALL(C122:BB122,10)+SMALL(C122:BB122,11)+SMALL(C122:BB122,12)+SMALL(C122:BB122,13)+SMALL(C122:BB122,14)+SMALL(C122:BB122,15)+SMALL(C122:BB122,16)+SMALL(C122:BB122,17)+SMALL(C122:BB122,18)+SMALL(C122:BB122,19)+SMALL(C122:BB122,20)+SMALL(C122:BB122,21)+SMALL(C122:BB122,22)+SMALL(C122:BB122,23)+SMALL(C122:BB122,24)+SMALL(C122:BB122,25))/25","v":0}]
[2,"z*Asbury, Mandi",0,{"$f":"+D5+D64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Q5+Q64","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC5+AC64","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AQ5+AQ64","v":0},{"$f":"+AR5+AR64","v":0},0,0,{"$f":"+AU5+AU64","v":0},{"$f":"+AV5+AV64","v":0},0,0,{"$f":"+AY5+AY64","v":0},{"$f":"+AZ5+AZ64","v":0},{"$f":"+BA5+BA64","v":0},0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C123:$BB123),MAX(($C123:$BB123<>0)*(COLUMN($C123:$BB123)))))","v":{"$error":"#VALUE!"}},{"$f":"(+LARGE(C123:BB123,1)+LARGE(C123:BB123,2)+LARGE(C123:BB123,3)+LARGE(C123:BB123,4)+LARGE(C123:BB123,5)+LARGE(C123:BB123,6)+LARGE(C123:BB123,7)+LARGE(C123:BB123,8)+LARGE(C123:BB123,9)+LARGE(C123:BB123,10)+LARGE(C123:BB123,11)+LARGE(C123:BB123,12)+LARGE(C123:BB123,13)+LARGE(C123:BB123,14)+LARGE(C123:BB123,15)+LARGE(C123:BB123,16)+LARGE(C123:BB123,17)+LARGE(C123:BB123,18)+LARGE(C123:BB123,19)+LARGE(C123:BB123,20)+LARGE(C123:BB123,21)+LARGE(C123:BB123,22)+LARGE(C123:BB123,23)+LARGE(C123:BB123,24)+LARGE(C123:BB123,25))/25","v":0},{"$f":"COUNTIF(C123:BB123, \"<>0\")","v":0},null,0]
[3,0,0,{"$f":"+D6+D65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC6+AC65","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AQ6+AQ65","v":0},0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C124:$BB124),MAX(($C124:$BB124<>0)*(COLUMN($C124:$BB124)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[4,"z*Carl, Erwin",0,{"$f":"+D7+D66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC7+AC66","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AQ7+AQ66","v":0},0,0,0,0,{"$f":"+AV7+AV66","v":0},0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C125:$BB125),MAX(($C125:$BB125<>0)*(COLUMN($C125:$BB125)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[5,"z*Dietrich, Horst",0,{"$f":"+D8+D67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC8+AC67","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C126:$BB126),MAX(($C126:$BB126<>0)*(COLUMN($C126:$BB126)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[6,"z*Kamer, Lance",0,{"$f":"+D9+D68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC9+AC68","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C127:$BB127),MAX(($C127:$BB127<>0)*(COLUMN($C127:$BB127)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[7,"z*Reinke, Fred",0,{"$f":"+D10+D69","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC10+AC69","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C128:$BB128),MAX(($C128:$BB128<>0)*(COLUMN($C128:$BB128)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[8,"z*Feld, Manfred",0,{"$f":"+D11+D70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC11+AC70","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C129:$BB129),MAX(($C129:$BB129<>0)*(COLUMN($C129:$BB129)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[9,"z*Frank, Heidemarie",0,{"$f":"+D12+D71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC12+AC71","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C130:$BB130),MAX(($C130:$BB130<>0)*(COLUMN($C130:$BB130)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[10,"z*Kamps, Thomas",0,{"$f":"+D13+D72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC13+AC72","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C131:$BB131),MAX(($C131:$BB131<>0)*(COLUMN($C131:$BB131)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[11,"z*Koenen, Willi",0,{"$f":"+D14+D73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC14+AC73","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C132:$BB132),MAX(($C132:$BB132<>0)*(COLUMN($C132:$BB132)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[12,"z*Rausch. Thomas",0,{"$f":"+D15+D74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC15+AC74","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C133:$BB133),MAX(($C133:$BB133<>0)*(COLUMN($C133:$BB133)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[13,"z*Mandl, Sabine",0,{"$f":"+D16+D75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC16+AC75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C134:$BB134),MAX(($C134:$BB134<>0)*(COLUMN($C134:$BB134)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[14,"z*Polap, Adolf",0,{"$f":"+D17+D76","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C135:$BB135),MAX(($C135:$BB135<>0)*(COLUMN($C135:$BB135)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[15,"z*Kamps, Hermann",0,{"$f":"+D18+D77","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C136:$BB136),MAX(($C136:$BB136<>0)*(COLUMN($C136:$BB136)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[16,"z*Rischke, Harry",0,{"$f":"+D19+D78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C137:$BB137),MAX(($C137:$BB137<>0)*(COLUMN($C137:$BB137)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[17,0,0,{"$f":"+D20+D79","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC20+AC79","v":0},{"$f":"+AD20+AD79","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C138:$BB138),MAX(($C138:$BB138<>0)*(COLUMN($C138:$BB138)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[18,0,0,{"$f":"+D21+D80","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AD21+AD80","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C139:$BB139),MAX(($C139:$BB139<>0)*(COLUMN($C139:$BB139)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[19,"z*Schmitz, Miranda",0,{"$f":"+D22+D81","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C140:$BB140),MAX(($C140:$BB140<>0)*(COLUMN($C140:$BB140)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[20,0,0,{"$f":"+D23+D82","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C141:$BB141),MAX(($C141:$BB141<>0)*(COLUMN($C141:$BB141)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[{"$f":"+A24","v":21},0,0,{"$f":"+D24+D83","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C142:$BB142),MAX(($C142:$BB142<>0)*(COLUMN($C142:$BB142)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[22,0,0,{"$f":"+D25+D84","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+BA25+BA84","v":0},0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C143:$BB143),MAX(($C143:$BB143<>0)*(COLUMN($C143:$BB143)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[23,0,0,{"$f":"+D26+D85","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C144:$BB144),MAX(($C144:$BB144<>0)*(COLUMN($C144:$BB144)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[24,0,0,{"$f":"+D27+D86","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AQ27+AQ86","v":0},0,0,0,0,{"$f":"+AV27+AV86","v":0},0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C145:$BB145),MAX(($C145:$BB145<>0)*(COLUMN($C145:$BB145)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[25,0,0,{"$f":"+D28+D87","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C146:$BB146),MAX(($C146:$BB146<>0)*(COLUMN($C146:$BB146)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[26,0,0,{"$f":"+D29+D88","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C147:$BB147),MAX(($C147:$BB147<>0)*(COLUMN($C147:$BB147)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[27,0,0,{"$f":"+D30+D89","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C148:$BB148),MAX(($C148:$BB148<>0)*(COLUMN($C148:$BB148)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[28,0,0,{"$f":"+D31+D90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C149:$BB149),MAX(($C149:$BB149<>0)*(COLUMN($C149:$BB149)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[29,0,0,{"$f":"+D32+D91","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC32+AC91","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C150:$BB150),MAX(($C150:$BB150<>0)*(COLUMN($C150:$BB150)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[30,0,0,{"$f":"+D33+D92","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C151:$BB151),MAX(($C151:$BB151<>0)*(COLUMN($C151:$BB151)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[31,0,0,{"$f":"+D34+D93","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AD34+AD93","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C152:$BB152),MAX(($C152:$BB152<>0)*(COLUMN($C152:$BB152)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[32,0,0,{"$f":"+D35+D94","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C153:$BB153),MAX(($C153:$BB153<>0)*(COLUMN($C153:$BB153)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[33,0,{"$f":"+C36+C95","v":0},{"$f":"+D36+D95","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC36+AC95","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AP36+AP95","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C154:$BB154),MAX(($C154:$BB154<>0)*(COLUMN($C154:$BB154)))))","v":{"$error":"#VALUE!"}},0,0,null,{"$f":"(+SMALL(C154:BB154,1)+SMALL(C154:BB154,2)+SMALL(C154:BB154,3)+SMALL(C154:BB154,4)+SMALL(C154:BB154,5)+SMALL(C154:BB154,6)+SMALL(C154:BB154,7)+SMALL(C154:BB154,8)+SMALL(C154:BB154,9)+SMALL(C154:BB154,10)+SMALL(C154:BB154,11)+SMALL(C154:BB154,12)+SMALL(C154:BB154,13)+SMALL(C154:BB154,14)+SMALL(C154:BB154,15)+SMALL(C154:BB154,16)+SMALL(C154:BB154,17)+SMALL(C154:BB154,18)+SMALL(C154:BB154,19)+SMALL(C154:BB154,20)+SMALL(C154:BB154,21)+SMALL(C154:BB154,22)+SMALL(C154:BB154,23)+SMALL(C154:BB154,24)+SMALL(C154:BB154,25))/25","v":0}]
[34,0,0,{"$f":"+D37+D96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC37+AC96","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C155:$BB155),MAX(($C155:$BB155<>0)*(COLUMN($C155:$BB155)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[35,0,0,{"$f":"+D38+D97","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC38+AC97","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C156:$BB156),MAX(($C156:$BB156<>0)*(COLUMN($C156:$BB156)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[36,0,0,{"$f":"+D39+D98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC39+AC98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C157:$BB157),MAX(($C157:$BB157<>0)*(COLUMN($C157:$BB157)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[37,0,0,{"$f":"+D40+D99","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC40+AC99","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C158:$BB158),MAX(($C158:$BB158<>0)*(COLUMN($C158:$BB158)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[38,0,0,{"$f":"+D41+D100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC41+AC100","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C159:$BB159),MAX(($C159:$BB159<>0)*(COLUMN($C159:$BB159)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[39,0,0,{"$f":"+D42+D101","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC42+AC101","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C160:$BB160),MAX(($C160:$BB160<>0)*(COLUMN($C160:$BB160)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[40,0,0,{"$f":"+D43+D102","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC43+AC102","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C161:$BB161),MAX(($C161:$BB161<>0)*(COLUMN($C161:$BB161)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[{"$f":"+A44","v":41},{"$f":"+B44","v":0},0,{"$f":"+D44+D103","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC44+AC103","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C162:$BB162),MAX(($C162:$BB162<>0)*(COLUMN($C162:$BB162)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[{"$f":"+A45","v":42},{"$f":"+B45","v":0},0,{"$f":"+D45+D104","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC45+AC104","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C163:$BB163),MAX(($C163:$BB163<>0)*(COLUMN($C163:$BB163)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[{"$f":"+A46","v":43},0,0,{"$f":"+D46+D105","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC46+AC105","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+BB46+BB105","v":0},null,{"$f":"SUM(C164:BB164)","v":0},{"$f":"INDIRECT(ADDRESS(ROW($C164:$BB164),MAX(($C164:$BB164<>0)*(COLUMN($C164:$BB164)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[44,0,0,{"$f":"+D47+D106","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC47+AC106","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AQ47+AQ106","v":0},0,0,0,0,{"$f":"+AV47+AV106","v":0},0,0,0,0,0,0,null,{"$f":"SUM(C165:BB165)","v":0},{"$f":"INDIRECT(ADDRESS(ROW($C165:$BB165),MAX(($C165:$BB165<>0)*(COLUMN($C165:$BB165)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[45,0,0,{"$f":"+D48+D107","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AC48+AC107","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C166:BB166)","v":0},{"$f":"INDIRECT(ADDRESS(ROW($C166:$BB166),MAX(($C166:$BB166<>0)*(COLUMN($C166:$BB166)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[{"$f":"+A49","v":46},0,0,{"$f":"+D49+D108","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C167:BB167)","v":0},{"$f":"INDIRECT(ADDRESS(ROW($C167:$BB167),MAX(($C167:$BB167<>0)*(COLUMN($C167:$BB167)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[47,0,0,{"$f":"+D50+D109","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C168:BB168)","v":0},{"$f":"INDIRECT(ADDRESS(ROW($C168:$BB168),MAX(($C168:$BB168<>0)*(COLUMN($C168:$BB168)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[48,0,0,{"$f":"+D51+D110","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C169:$BB169),MAX(($C169:$BB169<>0)*(COLUMN($C169:$BB169)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[49,0,0,{"$f":"+D52+D111","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+AM52+AM111","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C170:$BB170),MAX(($C170:$BB170<>0)*(COLUMN($C170:$BB170)))))","v":{"$error":"#VALUE!"}},0,0,null,0]
[50,0,0,{"$f":"+D53+D112","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,{"$f":"INDIRECT(ADDRESS(ROW($C171:$BB171),MAX(($C171:$BB171<>0)*(COLUMN($C171:$BB171)))))","v":{"$error":"#VALUE!"}},0,0,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(ROW($C172:$BB172),MAX(($C172:$BB172<>0)*(COLUMN($C172:$BB172)))))","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(ADDRESS(ROW($C172:$BB172),MAX(($C172:$BB172<>0)*(COLUMN($C172:$BB172)))))","v":{"$error":"#VALUE!"}},null,52]
["Summe",null,{"$f":"SUM(C122:C171)","v":0},{"$f":"SUM(D122:D171)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P122:P171)","v":0},{"$f":"SUM(Q122:Q171)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AC122:AC171)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AP122:AP171)","v":0},{"$f":"SUM(AQ122:AQ171)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(C173:BB173)","v":0},{"$f":"SUMIF(BE122:BE171, \">0\")","v":0},{"$f":"SUM(BF122:BF171)","v":0},{"$f":"SUM(BG122:BG171)","v":0},null,{"$f":"SUM(BI122:BI171)","v":0}]
[]
["Number of Players",null,{"$f":"COUNTIF(C122:C171, \"<>0\")","v":0},{"$f":"COUNTIF(D122:D171, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(P122:P171, \"<>0\")","v":0},{"$f":"COUNTIF(Q122:Q171, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AC122:AC171, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AP122:AP171, \"<>0\")","v":0},{"$f":"COUNTIF(AQ122:AQ171, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,"Last Week's # of players",null,{"$f":"VLOOKUP(A175,$A$53:$BB$112,$BE$116+2,FALSE)","v":0}]

{"sheet":"Results","index":2,"n_rows":56,"n_cols":16,"rows_kept":56,"cut":false,"hidden":false,"merged":[[36,9,36,11],[37,9,37,11],[38,9,38,11],[39,9,39,11],[0,11,0,12],[0,0,0,10],[1,0,1,7],[1,9,1,14],[46,9,47,14],[45,9,45,11],[44,9,44,11],[40,9,40,11],[41,9,41,11],[42,9,42,11],[43,9,43,11],[48,9,48,14],[55,9,55,14],[54,9,54,14],[53,9,53,14],[49,9,49,14],[52,9,52,14]]}
["       Germania Klub - Skat Gruppe Tournaments  2025 Season                 Date:",null,null,null,null,null,null,null,null,null,null,{"$f":"+Input!C5","v":"2024-12-07"},null,"No:",{"$f":"+Data!$BE$57","v":0}]
["W e e k l y   R e s u l t s   (Members and Guests)",null,null,null,null,null,null,null,null,"Y e a r - t o - d a t e   R e s u l t s   (Members only)"]
["Rank","Name  ( z* = Guest )","Start #","Paid","First Round","Second Round","Total","Prizes",null,"Rank","Name","Start #","Year-to-date Totals","No. of Weeks Played","Running 25 week Ave."]
[1,{"$f":"Data!$B4","v":"z*Eggers, Barbara"},{"$f":"Data!$A4","v":1},{"$f":"IF(G4<>0,10,0)","v":{"$error":"#VALUE!"}},{"$f":"+Data!BE4","v":"z*Eggers, Barbara"},{"$f":"+Data!BE63","v":"z*Eggers, Barbara"},{"$f":"E4+F4","v":{"$error":"#VALUE!"}},{"$f":"+Prize_Schedule!AI17","v":{"$error":"#VALUE!"}},null,1,{"$f":"Data!$B5","v":"z*Asbury, Mandi"},{"$f":"Data!$A5","v":2},{"$f":"+Data!BD123","v":0},{"$f":"+Data!BG123","v":0},{"$f":"+Data!BF123","v":0}]
[2,{"$f":"Data!$B5","v":"z*Asbury, Mandi"},{"$f":"Data!$A5","v":2},{"$error":"#VALUE!"},{"$f":"+Data!BE5","v":"z*Asbury, Mandi"},{"$f":"+Data!BE64","v":"z*Asbury, Mandi"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI18","v":{"$error":"#VALUE!"}},null,2,{"$f":"Data!$B7","v":"z*Carl, Erwin"},{"$f":"Data!$A7","v":4},{"$f":"+Data!BD125","v":0},{"$f":"+Data!BG125","v":0},{"$f":"+Data!BF125","v":0}]
[3,{"$f":"Data!$B7","v":"z*Carl, Erwin"},{"$f":"Data!$A7","v":4},{"$error":"#VALUE!"},{"$f":"+Data!BE7","v":"z*Carl, Erwin"},{"$f":"+Data!BE66","v":"z*Carl, Erwin"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI19","v":{"$error":"#VALUE!"}},null,3,{"$f":"Data!$B8","v":"z*Dietrich, Horst"},{"$f":"Data!$A8","v":5},{"$f":"+Data!BD126","v":0},{"$f":"+Data!BG126","v":0},{"$f":"+Data!BF126","v":0}]
[4,{"$f":"Data!$B8","v":"z*Dietrich, Horst"},{"$f":"Data!$A8","v":5},{"$error":"#VALUE!"},{"$f":"+Data!BE8","v":"z*Dietrich, Horst"},{"$f":"+Data!BE67","v":"z*Dietrich, Horst"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI20","v":{"$error":"#VALUE!"}},null,4,{"$f":"Data!$B4","v":"z*Eggers, Barbara"},{"$f":"Data!$A4","v":1},{"$f":"+Data!BD122","v":0},{"$f":"+Data!BG122","v":0},{"$f":"+Data!BF122","v":0}]
[5,{"$f":"Data!$B9","v":"z*Kamer, Lance"},{"$f":"Data!$A9","v":6},{"$error":"#VALUE!"},{"$f":"+Data!BE9","v":"z*Kamer, Lance"},{"$f":"+Data!BE68","v":"z*Kamer, Lance"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI21","v":{"$error":"#VALUE!"}},null,5,{"$f":"Data!$B11","v":"z*Feld, Manfred"},{"$f":"Data!$A11","v":8},{"$f":"+Data!BD129","v":0},{"$f":"+Data!BG129","v":0},{"$f":"+Data!BF129","v":0}]
[6,{"$f":"Data!$B10","v":"z*Reinke, Fred"},{"$f":"Data!$A10","v":7},{"$error":"#VALUE!"},{"$f":"+Data!BE10","v":"z*Reinke, Fred"},{"$f":"+Data!BE69","v":"z*Reinke, Fred"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI22","v":{"$error":"#VALUE!"}},null,6,{"$f":"Data!$B12","v":"z*Frank, Heidemarie"},{"$f":"Data!$A12","v":9},{"$f":"+Data!BD130","v":0},{"$f":"+Data!BG130","v":0},{"$f":"+Data!BF130","v":0}]
[7,{"$f":"Data!$B11","v":"z*Feld, Manfred"},{"$f":"Data!$A11","v":8},{"$error":"#VALUE!"},{"$f":"+Data!BE11","v":"z*Feld, Manfred"},{"$f":"+Data!BE70","v":"z*Feld, Manfred"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI23","v":{"$error":"#VALUE!"}},null,7,{"$f":"Data!$B9","v":"z*Kamer, Lance"},{"$f":"Data!$A9","v":6},{"$f":"+Data!BD127","v":0},{"$f":"+Data!BG127","v":0},{"$f":"+Data!BF127","v":0}]
[8,{"$f":"Data!$B12","v":"z*Frank, Heidemarie"},{"$f":"Data!$A12","v":9},{"$error":"#VALUE!"},{"$f":"+Data!BE12","v":"z*Frank, Heidemarie"},{"$f":"+Data!BE71","v":"z*Frank, Heidemarie"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI24","v":{"$error":"#VALUE!"}},null,8,{"$f":"Data!$B18","v":"z*Kamps, Hermann"},{"$f":"Data!$A18","v":15},{"$f":"+Data!BD136","v":0},{"$f":"+Data!BG136","v":0},{"$f":"+Data!BF136","v":0}]
[9,{"$f":"Data!$B13","v":"z*Kamps, Thomas"},{"$f":"Data!$A13","v":10},{"$error":"#VALUE!"},{"$f":"+Data!BE13","v":"z*Kamps, Thomas"},{"$f":"+Data!BE72","v":"z*Kamps, Thomas"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI25","v":{"$error":"#VALUE!"}},null,9,{"$f":"Data!$B13","v":"z*Kamps, Thomas"},{"$f":"Data!$A13","v":10},{"$f":"+Data!BD131","v":0},{"$f":"+Data!BG131","v":0},{"$f":"+Data!BF131","v":0}]
[10,{"$f":"Data!$B14","v":"z*Koenen, Willi"},{"$f":"Data!$A14","v":11},{"$error":"#VALUE!"},{"$f":"+Data!BE14","v":"z*Koenen, Willi"},{"$f":"+Data!BE73","v":"z*Koenen, Willi"},{"$error":"#VALUE!"},{"$f":"+Prize_Schedule!AI26","v":{"$error":"#VALUE!"}},null,10,{"$f":"Data!$B14","v":"z*Koenen, Willi"},{"$f":"Data!$A14","v":11},{"$f":"+Data!BD132","v":0},{"$f":"+Data!BG132","v":0},{"$f":"+Data!BF132","v":0}]
[11,{"$f":"Data!$B15","v":"z*Rausch. Thomas"},{"$f":"Data!$A15","v":12},{"$error":"#VALUE!"},{"$f":"+Data!BE15","v":"z*Rausch. Thomas"},{"$f":"+Data!BE74","v":"z*Rausch. Thomas"},{"$error":"#VALUE!"},null,null,11,{"$f":"Data!$B16","v":"z*Mandl, Sabine"},{"$f":"Data!$A16","v":13},{"$f":"+Data!BD134","v":0},{"$f":"+Data!BG134","v":0},{"$f":"+Data!BF134","v":0}]
[12,{"$f":"Data!$B16","v":"z*Mandl, Sabine"},{"$f":"Data!$A16","v":13},{"$error":"#VALUE!"},{"$f":"+Data!BE16","v":"z*Mandl, Sabine"},{"$f":"+Data!BE75","v":"z*Mandl, Sabine"},{"$error":"#VALUE!"},null,null,12,{"$f":"Data!$B17","v":"z*Polap, Adolf"},{"$f":"Data!$A17","v":14},{"$f":"+Data!BD135","v":0},{"$f":"+Data!BG135","v":0},{"$f":"+Data!BF135","v":0}]
[13,{"$f":"Data!$B17","v":"z*Polap, Adolf"},{"$f":"Data!$A17","v":14},{"$error":"#VALUE!"},{"$f":"+Data!BE17","v":"z*Polap, Adolf"},{"$f":"+Data!BE76","v":"z*Polap, Adolf"},{"$error":"#VALUE!"},null,null,13,{"$f":"Data!$B15","v":"z*Rausch. Thomas"},{"$f":"Data!$A15","v":12},{"$f":"+Data!BD133","v":0},{"$f":"+Data!BG133","v":0},{"$f":"+Data!BF133","v":0}]
[14,{"$f":"Data!$B18","v":"z*Kamps, Hermann"},{"$f":"Data!$A18","v":15},{"$error":"#VALUE!"},{"$f":"+Data!BE18","v":"z*Kamps, Hermann"},{"$f":"+Data!BE77","v":"z*Kamps, Hermann"},{"$error":"#VALUE!"},null,null,14,{"$f":"Data!$B10","v":"z*Reinke, Fred"},{"$f":"Data!$A10","v":7},{"$f":"+Data!BD128","v":0},{"$f":"+Data!BG128","v":0},{"$f":"+Data!BF128","v":0}]
[15,{"$f":"Data!$B19","v":"z*Rischke, Harry"},{"$f":"Data!$A19","v":16},{"$error":"#VALUE!"},{"$f":"+Data!BE19","v":"z*Rischke, Harry"},{"$f":"+Data!BE78","v":"z*Rischke, Harry"},{"$error":"#VALUE!"},null,null,15,{"$f":"Data!$B19","v":"z*Rischke, Harry"},{"$f":"Data!$A19","v":16},{"$f":"+Data!BD137","v":0},{"$f":"+Data!BG137","v":0},{"$f":"+Data!BF137","v":0}]
[16,{"$f":"Data!$B22","v":"z*Schmitz, Miranda"},{"$f":"Data!$A22","v":19},{"$error":"#VALUE!"},{"$f":"+Data!BE22","v":"z*Schmitz, Miranda"},{"$f":"+Data!BE81","v":"z*Schmitz, Miranda"},{"$error":"#VALUE!"},null,null,16,{"$f":"+Data!B22","v":"z*Schmitz, Miranda"},{"$f":"Data!$A22","v":19},{"$f":"+Data!BD140","v":0},{"$f":"+Data!BG140","v":0},{"$f":"+Data!BF140","v":0}]
[17,{"$f":"Data!$B6","v":0},{"$f":"Data!$A6","v":3},0,{"$f":"+Data!BE6","v":0},{"$f":"+Data!BE65","v":0},0]
[18,{"$f":"Data!$B20","v":0},{"$f":"Data!$A20","v":17},0,{"$f":"+Data!BE20","v":0},{"$f":"+Data!BE79","v":0},0,null,null,null,null,null,null,null,null,"     To print both the Results &"]
[19,{"$f":"Data!$B21","v":0},{"$f":"Data!$A21","v":18},0,{"$f":"+Data!BE21","v":0},{"$f":"+Data!BE80","v":0},0,null,null,null,null,null,null,null,null,"     the Next_Worksheet press"]
[20,{"$f":"Data!$B23","v":0},{"$f":"Data!$A23","v":20},0,{"$f":"+Data!BE23","v":0},{"$f":"+Data!BE82","v":0},0]
[21,{"$f":"Data!$B24","v":0},{"$f":"Data!$A24","v":21},0,{"$f":"+Data!BE24","v":0},{"$f":"+Data!BE83","v":0},0,null,null,null,null,null,null,null,null,"     To print an extra Results"]
[22,{"$f":"Data!$B25","v":0},{"$f":"Data!$A25","v":22},0,{"$f":"+Data!BE25","v":0},{"$f":"+Data!BE84","v":0},0,null,null,null,null,null,null,null,null,"     sheet press"]
[23,{"$f":"Data!$B26","v":0},{"$f":"Data!$A26","v":23},0,{"$f":"+Data!BE26","v":0},{"$f":"+Data!BE85","v":0},0]
[24,{"$f":"Data!$B27","v":0},{"$f":"Data!$A27","v":24},0,{"$f":"+Data!BE27","v":0},{"$f":"+Data!BE86","v":0},0,null,null,null,null,null,null,null,null,"  Printing caveat !  These printing macros work correctly"]
[25,{"$f":"Data!$B28","v":0},{"$f":"Data!$A28","v":25},0,{"$f":"+Data!BE28","v":0},{"$f":"+Data!BE87","v":0},0,null,null,null,null,null,null,null,null,"  on my printer.  Do they work on yours?  I don't know!"]
[26,{"$f":"Data!$B29","v":0},{"$f":"Data!$A29","v":26},0,{"$f":"+Data!BE29","v":0},{"$f":"+Data!BE88","v":0},0,null,null,null,null,null,null,null,null,"  Every printer differs. Try it, if no joy, print manually. Willi"]
[27,{"$f":"Data!$B30","v":0},{"$f":"Data!$A30","v":27},0,{"$f":"+Data!BE30","v":0},{"$f":"+Data!BE89","v":0},0]
[28,{"$f":"Data!$B31","v":0},{"$f":"Data!$A31","v":28},0,{"$f":"+Data!BE31","v":0},{"$f":"+Data!BE90","v":0},0]
[29,{"$f":"Data!$B32","v":0},{"$f":"Data!$A32","v":29},0,{"$f":"+Data!BE32","v":0},{"$f":"+Data!BE91","v":0},0,null,null,null,null,null,null,null,null,"     To go back to the Input sheet "]
[30,{"$f":"Data!$B33","v":0},{"$f":"Data!$A33","v":30},0,{"$f":"+Data!BE33","v":0},{"$f":"+Data!BE92","v":0},0,null,null,null,null,null,null,null,null,"     press"]
[31,{"$f":"Data!$B34","v":0},{"$f":"Data!$A34","v":31},0,{"$f":"+Data!BE34","v":0},{"$f":"+Data!BE93","v":0},0]
[32,{"$f":"Data!$B35","v":0},{"$f":"Data!$A35","v":32},0,{"$f":"+Data!BE35","v":0},{"$f":"+Data!BE94","v":0},0]
[33,{"$f":"Data!$B36","v":0},{"$f":"Data!$A36","v":33},{"$f":"IF(G36<>0,10,0)","v":0},{"$f":"+Data!BE36","v":0},{"$f":"+Data!BE95","v":0},{"$f":"E36+F36","v":0},null,null,null,"Totals",null,{"$f":"SUM(M4:M35)","v":0},{"$f":"SUM(N4:N35)","v":0},{"$f":"SUM(O4:O35)","v":0}]
[34,{"$f":"Data!$B37","v":0},{"$f":"Data!$A37","v":34},0,{"$f":"+Data!BE37","v":0},{"$f":"+Data!BE96","v":0},0,null,null,"  Financial Information",null,null,"Forward","New"," Total "]
[35,{"$f":"Data!$B38","v":0},{"$f":"Data!$A38","v":35},0,{"$f":"+Data!BE38","v":0},{"$f":"+Data!BE97","v":0},0,null,null,"Carry forward from previous year ",null,null,0,0,{"$f":"+M38+N38","v":0},"     To go to the top-left position "]
[36,{"$f":"Data!$B39","v":0},{"$f":"Data!$A39","v":36},0,{"$f":"+Data!BE39","v":0},{"$f":"+Data!BE98","v":0},0,null,null,"Club Membership Fees ",null,null,0,0,0,"     on this sheet press"]
[37,{"$f":"Data!$B40","v":0},{"$f":"Data!$A40","v":37},0,{"$f":"+Data!BE40","v":0},{"$f":"+Data!BE99","v":0},0,null,null,"Abreizgeld collected to-date ",null,null,0,0,{"$f":"+M40+N40","v":0}]
[38,{"$f":"Data!$B41","v":0},{"$f":"Data!$A41","v":38},0,{"$f":"+Data!BE41","v":0},{"$f":"+Data!BE100","v":0},0,null,null,"Payables to Germania Club for 2024/25 ",null,null,0,0,{"$f":"+M41","v":0}]
[39,{"$f":"Data!$B42","v":0},{"$f":"Data!$A42","v":39},0,{"$f":"+Data!BE42","v":0},{"$f":"+Data!BE101","v":0},0,null,null,"Bank Interest ",null,null,0,0,{"$f":"+M42+N42","v":0}]
[40,{"$f":"Data!$B43","v":0},{"$f":"Data!$A43","v":40},0,{"$f":"+Data!BE43","v":0},{"$f":"+Data!BE102","v":0},0,null,null,"Cards, etc. expenses less sundry revenue ",null,null,0,0,{"$f":"+M43+N43","v":0}]
[41,{"$f":"Data!$B44","v":0},{"$f":"Data!$A44","v":41},0,{"$f":"+Data!BE44","v":0},{"$f":"+Data!BE103","v":0},0,null,null,"Year-End Prizes ",null,null,0,0,0]
[42,{"$f":"Data!$B45","v":0},{"$f":"Data!$A45","v":42},0,{"$f":"+Data!BE45","v":0},{"$f":"+Data!BE104","v":0},0,null,null,"Receivables from Members",null,null,0,0,0]
[43,{"$f":"Data!$B46","v":0},{"$f":"Data!$A46","v":43},0,{"$f":"+Data!BE46","v":0},{"$f":"+Data!BE105","v":0},0,null,null,"Totals",null,null,{"$f":"SUM(M38:M45)","v":0},{"$f":"SUM(N38:N45)","v":0},{"$f":"SUM(O38:O45)","v":0}]
[44,{"$f":"Data!$B47","v":0},{"$f":"Data!$A47","v":44},0,{"$f":"+Data!BE47","v":0},{"$f":"+Data!BE106","v":0},0,null,null,"I n f o r m a t i o n"]
[45,{"$f":"Data!$B48","v":0},{"$f":"Data!$A48","v":45},0,{"$f":"+Data!BE48","v":0},{"$f":"+Data!BE107","v":0},0]
[46,{"$f":"Data!$B49","v":0},{"$f":"Data!$A49","v":46},0,{"$f":"+Data!BE49","v":0},{"$f":"+Data!BE108","v":0},0]
[47,{"$f":"Data!$B50","v":0},{"$f":"Data!$A50","v":47},0,{"$f":"+Data!BE50","v":0},{"$f":"+Data!BE109","v":0},0,null,null,"The \"z*\" will be removed once the 2025 "]
[48,{"$f":"Data!$B51","v":0},{"$f":"Data!$A51","v":48},0,{"$f":"+Data!BE51","v":0},{"$f":"+Data!BE110","v":0},0,null,null,null,null,"membership fees (Skat & Germania Club) have"]
[49,{"$f":"Data!$B52","v":0},{"$f":"Data!$A52","v":49},0,{"$f":"+Data!BE52","v":0},{"$f":"+Data!BE111","v":0},0,null,null,null,null,"been collected for the respective member"]
[50,{"$f":"Data!$B53","v":0},{"$f":"Data!$A53","v":50},0,{"$f":"+Data!BE53","v":0},{"$f":"+Data!BE112","v":0},0,null,null,"Any person not renewing their membership will eventuelly be"]
[null,null,null,null,null,null,null,null,null,"removed from the right side of this sheet"]
[]
[null,"Summe/Durchschnitt",null,{"$f":"SUM(D4:D54)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E4:E54)/($D56/10)","v":{"$error":"#VALUE!"}},{"$f":"SUM(F4:F54)/($D56/10)","v":{"$error":"#VALUE!"}},{"$f":"SUM(G4:G54)/($D56/10)","v":{"$error":"#VALUE!"}},{"$f":"SUM(H4:H54)","v":{"$error":"#VALUE!"}}]

{"sheet":"Next_Worksheet","index":3,"n_rows":45,"n_cols":11,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,7,0,8],[0,0,0,6],[44,8,44,9]]}
["        Germania Klub - Skat Gruppe Tournaments 2025 Season         Date:",null,null,null,null,null,null,{"$f":"+Input!L5","v":"2024-12-14"},null,"No:",{"$f":"+Results!$O$1+1","v":1}]
["Start #","Name  ( z* = Guest )","Paid","Seating","Table #","1. Round","Table #","2. Round","Total","Ranking","Prizes"]
[{"$f":"Data!$A4","v":1},{"$f":"Data!$B4","v":"z*Eggers, Barbara"},null,{"$f":"IF(SUM(Data!$C122:'Data'!$BB122)=0, 0, +Data!BE122)","v":0}]
[{"$f":"Data!$A5","v":2},{"$f":"Data!$B5","v":"z*Asbury, Mandi"},null,{"$f":"IF(SUM(Data!$C123:'Data'!$BB123)=0, 0, +Data!BE123)","v":0}]
[{"$f":"Data!$A6","v":3},{"$f":"Data!$B6","v":0},null,{"$f":"IF(SUM(Data!$C124:'Data'!$BB124)=0, 0, +Data!BE124)","v":0}]
[{"$f":"Data!$A7","v":4},{"$f":"Data!$B7","v":"z*Carl, Erwin"},null,{"$f":"IF(SUM(Data!$C125:'Data'!$BB125)=0, 0, +Data!BE125)","v":0}]
[{"$f":"Data!$A8","v":5},{"$f":"Data!$B8","v":"z*Dietrich, Horst"},null,{"$f":"IF(SUM(Data!$C126:'Data'!$BB126)=0, 0, +Data!BE126)","v":0}]
[{"$f":"Data!$A9","v":6},{"$f":"Data!$B9","v":"z*Kamer, Lance"},null,{"$f":"IF(SUM(Data!$C127:'Data'!$BB127)=0, 0, +Data!BE127)","v":0}]
[{"$f":"Data!$A10","v":7},{"$f":"Data!$B10","v":"z*Reinke, Fred"},null,{"$f":"IF(SUM(Data!$C128:'Data'!$BB128)=0, 0, +Data!BE128)","v":0}]
[{"$f":"Data!$A11","v":8},{"$f":"Data!$B11","v":"z*Feld, Manfred"},null,{"$f":"IF(SUM(Data!$C129:'Data'!$BB129)=0, 0, +Data!BE129)","v":0}]
[{"$f":"Data!$A12","v":9},{"$f":"Data!$B12","v":"z*Frank, Heidemarie"},null,{"$f":"IF(SUM(Data!$C130:'Data'!$BB130)=0, 0, +Data!BE130)","v":0}]
[{"$f":"Data!$A13","v":10},{"$f":"Data!$B13","v":"z*Kamps, Thomas"},null,{"$f":"IF(SUM(Data!$C131:'Data'!$BB131)=0, 0, +Data!BE131)","v":0}]
[{"$f":"Data!$A14","v":11},{"$f":"Data!$B14","v":"z*Koenen, Willi"},null,{"$f":"IF(SUM(Data!$C132:'Data'!$BB132)=0, 0, +Data!BE132)","v":0}]
[{"$f":"Data!$A15","v":12},{"$f":"Data!$B15","v":"z*Rausch. Thomas"},null,{"$f":"IF(SUM(Data!$C133:'Data'!$BB133)=0, 0, +Data!BE133)","v":0}]
[{"$f":"Data!$A16","v":13},{"$f":"Data!$B16","v":"z*Mandl, Sabine"},null,{"$f":"IF(SUM(Data!$C134:'Data'!$BB134)=0, 0, +Data!BE134)","v":0}]
[{"$f":"Data!$A17","v":14},{"$f":"Data!$B17","v":"z*Polap, Adolf"},null,{"$f":"IF(SUM(Data!$C135:'Data'!$BB135)=0, 0, +Data!BE135)","v":0}]
[{"$f":"Data!$A18","v":15},{"$f":"Data!$B18","v":"z*Kamps, Hermann"},null,{"$f":"IF(SUM(Data!$C136:'Data'!$BB136)=0, 0, +Data!BE136)","v":0}]
[{"$f":"Data!$A19","v":16},{"$f":"Data!$B19","v":"z*Rischke, Harry"},null,{"$f":"IF(SUM(Data!$C137:'Data'!$BB137)=0, 0, +Data!BE137)","v":0}]
[{"$f":"Data!$A20","v":17},{"$f":"Data!$B20","v":0},null,{"$f":"IF(SUM(Data!$C138:'Data'!$BB138)=0, 0, +Data!BE138)","v":0}]
[{"$f":"Data!$A21","v":18},{"$f":"Data!$B21","v":0},null,{"$f":"IF(SUM(Data!$C139:'Data'!$BB139)=0, 0, +Data!BE139)","v":0}]
[{"$f":"Data!$A22","v":19},{"$f":"Data!$B22","v":"z*Schmitz, Miranda"},null,{"$f":"IF(SUM(Data!$C140:'Data'!$BB140)=0, 0, +Data!BE140)","v":0}]
[{"$f":"Data!$A23","v":20},{"$f":"Data!$B23","v":0},null,{"$f":"IF(SUM(Data!$C141:'Data'!$BB141)=0, 0, +Data!BE141)","v":0}]
[{"$f":"Data!$A24","v":21},{"$f":"Data!$B24","v":0},null,{"$f":"IF(SUM(Data!$C142:'Data'!$BB142)=0, 0, +Data!BE142)","v":0}]
[{"$f":"Data!$A25","v":22},{"$f":"Data!$B25","v":0},null,{"$f":"IF(SUM(Data!$C143:'Data'!$BB143)=0, 0, +Data!BE143)","v":0}]
[{"$f":"Data!$A26","v":23},{"$f":"Data!$B26","v":0},null,{"$f":"IF(SUM(Data!$C144:'Data'!$BB144)=0, 0, +Data!BE144)","v":0}]
[{"$f":"Data!$A27","v":24},{"$f":"Data!$B27","v":0},null,{"$f":"IF(SUM(Data!$C145:'Data'!$BB145)=0, 0, +Data!BE145)","v":0}]
[{"$f":"Data!$A28","v":25},{"$f":"Data!$B28","v":0},null,{"$f":"IF(SUM(Data!$C146:'Data'!$BB146)=0, 0, +Data!BE146)","v":0}]
[{"$f":"Data!$A29","v":26},{"$f":"Data!$B29","v":0},null,{"$f":"IF(SUM(Data!$C147:'Data'!$BB147)=0, 0, +Data!BE147)","v":0}]
[{"$f":"Data!$A30","v":27},{"$f":"Data!$B30","v":0},null,{"$f":"IF(SUM(Data!$C148:'Data'!$BB148)=0, 0, +Data!BE148)","v":0}]
[{"$f":"Data!$A31","v":28},{"$f":"Data!$B31","v":0},null,{"$f":"IF(SUM(Data!$C149:'Data'!$BB149)=0, 0, +Data!BE149)","v":0}]
[{"$f":"Data!$A32","v":29},{"$f":"Data!$B32","v":0},null,{"$f":"IF(SUM(Data!$C150:'Data'!$BB150)=0, 0, +Data!BE150)","v":0}]
[{"$f":"Data!$A33","v":30},{"$f":"Data!$B33","v":0},null,{"$f":"IF(SUM(Data!$C151:'Data'!$BB151)=0, 0, +Data!BE151)","v":0}]
[{"$f":"Data!$A34","v":31},{"$f":"Data!$B34","v":0},null,{"$f":"IF(SUM(Data!$C152:'Data'!$BB152)=0, 0, +Data!BE152)","v":0}]
[{"$f":"Data!$A35","v":32},{"$f":"Data!$B35","v":0},null,{"$f":"IF(SUM(Data!$C153:'Data'!$BB153)=0, 0, +Data!BE153)","v":0}]
[{"$f":"Data!$A36","v":33},{"$f":"Data!$B36","v":0},null,{"$f":"IF(SUM(Data!$C154:'Data'!$BB154)=0, 0, +Data!BE154)","v":0}]
[{"$f":"Data!$A37","v":34},{"$f":"Data!$B37","v":0},null,{"$f":"IF(SUM(Data!$C155:'Data'!$BB155)=0, 0, +Data!BE155)","v":0}]
[{"$f":"Data!$A38","v":35},{"$f":"Data!$B38","v":0},null,{"$f":"IF(SUM(Data!$C156:'Data'!$BB156)=0, 0, +Data!BE156)","v":0}]
[{"$f":"Data!$A39","v":36},{"$f":"Data!$B39","v":0},null,{"$f":"IF(SUM(Data!$C157:'Data'!$BB157)=0, 0, +Data!BE157)","v":0}]
[{"$f":"Data!$A40","v":37},{"$f":"Data!$B40","v":0},null,{"$f":"IF(SUM(Data!$C158:'Data'!$BB158)=0, 0, +Data!BE158)","v":0}]
[{"$f":"Data!$A41","v":38},{"$f":"Data!$B41","v":0},null,{"$f":"IF(SUM(Data!$C159:'Data'!$BB159)=0, 0, +Data!BE159)","v":0}]
[{"$f":"Data!$A44","v":41},{"$f":"Data!$B44","v":0},null,{"$f":"IF(SUM(Data!$C162:'Data'!$BB162)=0, 0, +Data!BE162)","v":0}]
[39]
[40]
[]
["Summe",null,{"$f":"SUMIF(C3:C43, \">0\")","v":0},{"$f":"SUMIF(D3:D43, \">0\")","v":0},null,null,null,null,"Total of Prizes"]

{"sheet":"Prize_Schedule","index":4,"n_rows":28,"n_cols":35,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,32]]}
["Prize Schedule   100 % payout  ---   Germania Klub - Skat Gruppe"]
["Players ->",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,31,32,33,34]
["Prize #","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes","Prizes"]
["1st",30,30,30,35,35,40,45,45,50,50,50,50,50,50,53,57,57,57,60,58,62,62,62,62,67,67,67,67,70]
["2nd",null,10,20,25,25,30,30,30,30,35,35,40,40,39,40,40,39,45,45,45,50,50,49,49,50,49,54,54,55]
["3rd",null,null,null,null,10,10,15,15,20,20,20,25,30,29,30,35,34,35,35,35,35,35,34,39,40,39,39,39,45]
["4th",null,null,null,null,null,null,null,10,10,15,15,15,20,19,24,25,25,25,25,25,25,30,30,30,30,30,30,30,35]
["5th",null,null,null,null,null,null,null,null,null,null,10,10,10,13,13,13,13,15,20,20,20,20,20,23,25,25,25,28,25]
["6th",null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,12,13,15,15,15,18,18,20,20,20,20,25,25]
["7th",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,12,13,15,15,15,15,15,18,20,20]
["8th",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,12,12,13,13,15,15,15]
["9th",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,12,12,12,10]
["10th",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,10,10,10,10]
[]
["Total",30,40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190,200,210,220,230,240,250,260,270,280,290,300,310," -   "," -   "," -   "]
[]
["Last",{"$f":"IF(B$2=$A$21,+B4,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"VLOOKUP(A17,$A$17:$AG$26,$AI$27+2,FALSE)","v":{"$error":"#VALUE!"}}]
["Week's",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
["# of",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
["Players",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
[{"$f":"+Data!$BE$175","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
["above #",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
["is",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
["copied",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AG$2=$A$21,+AG11,0)","v":0},null,{"$error":"#VALUE!"}]
["from",{"$f":"IF(B$2=$A$21,+B12,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
["input sheet",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$error":"#VALUE!"}]
[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,{"$f":"+A21-3","v":-3}]
["# of Prizes",{"$f":"COUNTIF(B17:B26, \"<>0\")","v":0},{"$f":"COUNTIF(C17:C26, \"<>0\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Sort_First_Round","index":5,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":false,"merged":[[28,7,29,11],[7,5,19,5],[7,6,10,11],[11,6,12,11],[13,6,15,11],[16,6,19,11],[20,6,22,11],[25,6,27,6],[25,7,27,11],[4,0,4,1],[0,0,0,12],[2,5,3,11],[4,5,5,5],[4,6,5,6]]}
["Germania Klub - Skat Gruppe -- Weekly Tournaments -- Sort 1st Round by Score to seat 2nd Round"]
["To partially automate and print the seating for the 2nd round based on first round standing but making manual adjustments"]
[null,null,null,null,null,"I   N   S   T   R   U   C   T   I   O   N   S"]
[]
["Number of Players",null,0,null,null,"Step 1","Execute macro on right"]
["Start #","Name","Scores of Round 1","Table #"]
[1,"Eggers, Barbara",0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[2,"Asbury, Mandi",0,1,null,"Step 2","Manually, make changes to the present table numbers on your left to make sure (a) each table has a capable \"Listenfuehrer\", (b) there are not too many slow players at the same table by way of moving people around, including, if necessary, creating \"dreier\" tables. ",null,null,null,null,null,null,null,null,null,null,null,null,1]
[3,"Barta, Sigfrid",0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[4,"Carl, Erwin",0,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[5,"Dietrich, Horst",0,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[6,"z*Klamer,Lance",0,2,null,null,"ENSURE you delete any seating number for non-players, those without a score.",null,null,null,null,null,null,null,null,null,null,null,null,2]
[7,"Reinke, Fred",0,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[8,"Feld, Manfred",0,2,null,null,"NOTE: if someone ended up with a MINUS score, Step 1 would have sorted that player to the very bottom, thus ensure that person is not overlooked when executing step 2. Thus Macro stops at Cell D56",null,null,null,null,null,null,null,null,null,null,null,null,2]
[9,"Frank, Heidemarie",0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[10,"Kamps, Thomas",0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[11,"Koenen, Willi",0,3,null,null,"NOTE FURTHER: The present table numbers are based on \"Vierer\" tables and while colour shaded for such, when \"Dreier\" tables are required, the shading is of little help. The same applies to minus score issues. And in view of the required manual changes there is nothing I can do about it.",null,null,null,null,null,null,null,null,null,null,null,null,3]
[12,"Rausch. Thomas",0,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[13,"Mandl, Sabine",0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[14,"Polap, Adolf",0,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[15,"Kamps, Hermann",0,4,null,null,"Execute Marco below which will RE-SORT the listing based on manually amended seating and PRINT the seating listing for round TWO !WATCH!",null,null,null,null,null,null,null,null,null,null,null,null,4]
[16,"Rischke, Harry",0,4,null,"Step 3",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[17,"z*Bremer, Mandi",0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[18,"z*Bremer, Matthias",0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[19,null,0,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[20,null,0,5,null,null,"WATCH","Prior to clicking on the macro button for step 3, ensure your printer is (1) connected, (2) powered on and (3) has paper! ",null,null,null,null,null,null,null,null,null,null,null,5]
[21,null,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[22,null,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[23,null,0,6,null,null,"Note","Clicking this macro button will now end up automatically at the top of the Input sheet",null,null,null,null,null,null,null,null,null,null,null,6]
[24,null,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[25,null,0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[26,null,0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[27,null,0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[28,null,0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[29,null,0,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[30,null,0,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[31,null,0,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[32,null,0,8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[33,null,0,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[34,null,0,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[35,null,0,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[36,null,0,9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[37,null,0,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[38,null,0,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[39,null,0,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[40,null,0,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[41,null,0,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[42,null,0,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[43,null,0,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[44,null,0,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[45,null,0,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[46,null,0,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[47,null,0,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[48,null,0,12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[49,null,0,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[50,null,0,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]

{"sheet":"ISPA_Scores","index":6,"n_rows":70,"n_cols":40,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Section \"ONE\" = Generating Information for ISPA"]
[]
[]
[]
[]
[]
[]
[]
[]
["Name      (z*=Guest)","Club","ISPA #","PT        = Total Score for ISPA","CL          = # of Games for ISPA","Total of Corrections to PT","Total of Corrections to CL","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted","Scores not to be counted"]
[{"$f":"+Input!B201","v":"z*Eggers, Barbara"},{"$f":"+Input!K201","v":"HAM"},{"$f":"+Input!E201","v":645},{"$f":"+Data!BD122-F11","v":0},{"$f":"+(Data!BG122*2)-G11","v":0},{"$f":"SUM(H11:AA11)","v":0},{"$f":"COUNT(H11:AA11)","v":0}]
[{"$f":"+Input!B202","v":"z*Asbury, Mandi"},{"$f":"+Input!K202","v":"HAM"},{"$f":"+Input!E202","v":773},{"$f":"+Data!BD123-F12","v":0},{"$f":"+(Data!BG123*2)-G12","v":0},0,0]
[{"$f":"+Input!B203","v":0},{"$f":"+Input!K203","v":0},{"$f":"+Input!E203","v":0},{"$f":"+Data!BD124-F13","v":0},{"$f":"+(Data!BG124*2)-G13","v":0},0,0]
[{"$f":"+Input!B204","v":"z*Carl, Erwin"},{"$f":"+Input!K204","v":0},{"$f":"+Input!E204","v":0},{"$f":"+Data!BD125-F14","v":0},{"$f":"+(Data!BG125*2)-G14","v":0},0,0]
[{"$f":"+Input!B205","v":"z*Dietrich, Horst"},{"$f":"+Input!K205","v":0},{"$f":"+Input!E205","v":0},{"$f":"+Data!BD126-F15","v":0},{"$f":"+(Data!BG126*2)-G15","v":0},0,0]
[{"$f":"+Input!B206","v":"z*Kamer, Lance"},{"$f":"+Input!K206","v":0},{"$f":"+Input!E206","v":0},{"$f":"+Data!BD127-F16","v":0},{"$f":"+(Data!BG127*2)-G16","v":0},0,0]
[{"$f":"+Input!B207","v":"z*Reinke, Fred"},{"$f":"+Input!K207","v":0},{"$f":"+Input!E207","v":0},{"$f":"+Data!BD128-F17","v":0},{"$f":"+(Data!BG128*2)-G17","v":0},0,0]
[{"$f":"+Input!B208","v":"z*Feld, Manfred"},{"$f":"+Input!K208","v":0},{"$f":"+Input!E208","v":0},{"$f":"+Data!BD129-F18","v":0},{"$f":"+(Data!BG129*2)-G18","v":0},0,0]
[{"$f":"+Input!B209","v":"z*Frank, Heidemarie"},{"$f":"+Input!K209","v":"HAM"},{"$f":"+Input!E209","v":414},{"$f":"+Data!BD130-F19","v":0},{"$f":"+(Data!BG130*2)-G19","v":0},0,0]
[{"$f":"+Input!B210","v":"z*Kamps, Thomas"},{"$f":"+Input!K210","v":0},{"$f":"+Input!E210","v":0},{"$f":"+Data!BD131-F20","v":0},{"$f":"+(Data!BG131*2)-G20","v":0},0,0]
[{"$f":"+Input!B211","v":"z*Koenen, Willi"},{"$f":"+Input!K211","v":"HAM"},{"$f":"+Input!E211","v":480},{"$f":"+Data!BD132-F21","v":0},{"$f":"+(Data!BG132*2)-G21","v":0},{"$f":"SUM(H21:AA21)","v":0},{"$f":"COUNT(H21:AA21)","v":0}]
[{"$f":"+Input!B212","v":"z*Rausch. Thomas"},{"$f":"+Input!K212","v":"HAM"},{"$f":"+Input!E212","v":481},{"$f":"+Data!BD133-F22","v":0},{"$f":"+(Data!BG133*2)-G22","v":0},0,0]
[{"$f":"+Input!B213","v":"z*Mandl, Sabine"},{"$f":"+Input!K213","v":0},{"$f":"+Input!E213","v":0},{"$f":"+Data!BD134-F23","v":0},{"$f":"+(Data!BG134*2)-G23","v":0},0,0]
[{"$f":"+Input!B214","v":"z*Polap, Adolf"},{"$f":"+Input!K214","v":0},{"$f":"+Input!E214","v":0},{"$f":"+Data!BD135-F24","v":0},{"$f":"+(Data!BG135*2)-G24","v":0},0,0]
[{"$f":"+Input!B215","v":"z*Kamps, Hermann"},{"$f":"+Input!K215","v":0},{"$f":"+Input!E215","v":0},{"$f":"+Data!BD136-F25","v":0},{"$f":"+(Data!BG136*2)-G25","v":0},0,0]
[{"$f":"+Input!B216","v":"z*Rischke, Harry"},{"$f":"+Input!K216","v":0},{"$f":"+Input!E216","v":0},{"$f":"+Data!BD137-F26","v":0},{"$f":"+(Data!BG137*2)-G26","v":0},0,0]
[{"$f":"+Input!B217","v":0},{"$f":"+Input!K217","v":0},{"$f":"+Input!E217","v":0},{"$f":"+Data!BD138-F27","v":0},{"$f":"+(Data!BG138*2)-G27","v":0},0,0]
[{"$f":"+Input!B218","v":0},{"$f":"+Input!K218","v":0},{"$f":"+Input!E218","v":0},{"$f":"+Data!BD139-F28","v":0},{"$f":"+(Data!BG139*2)-G28","v":0},0,0]
[{"$f":"+Input!B219","v":"z*Schmitz, Miranda"},{"$f":"+Input!K219","v":"HAM"},{"$f":"+Input!E219","v":114},{"$f":"+Data!BD140-F29","v":0},{"$f":"+(Data!BG140*2)-G29","v":0},{"$f":"SUM(H29:AA29)","v":0},{"$f":"COUNT(H29:AA29)","v":0}]
[{"$f":"+Input!B220","v":0},{"$f":"+Input!K220","v":0},{"$f":"+Input!E220","v":0},{"$f":"+Data!BD141-F30","v":0},{"$f":"+(Data!BG141*2)-G30","v":0},{"$f":"SUM(H30:AA30)","v":0},{"$f":"COUNT(H30:AA30)","v":0}]
[{"$f":"+Input!B221","v":0},{"$f":"+Input!K221","v":0},{"$f":"+Input!E221","v":0},{"$f":"+Data!BD142-F31","v":0},{"$f":"+(Data!BG142*2)-G31","v":0},0,0]
[{"$f":"+Input!B222","v":0},{"$f":"+Input!K222","v":0},{"$f":"+Input!E222","v":0},{"$f":"+Data!BD143-F32","v":0},{"$f":"+(Data!BG143*2)-G32","v":0},0,0]
[{"$f":"+Input!B223","v":0},{"$f":"+Input!K223","v":0},{"$f":"+Input!E223","v":0},{"$f":"+Data!BD144-F33","v":0},{"$f":"+(Data!BG144*2)-G33","v":0},0,0]
[{"$f":"+Input!B224","v":0},{"$f":"+Input!K224","v":0},{"$f":"+Input!E224","v":0},{"$f":"+Data!BD145-F34","v":0},{"$f":"+(Data!BG145*2)-G34","v":0},0,0]
[{"$f":"+Input!B225","v":0},{"$f":"+Input!K225","v":0},{"$f":"+Input!E225","v":0},{"$f":"+Data!BD146-F35","v":0},{"$f":"+(Data!BG146*2)-G35","v":0},{"$f":"SUM(H35:AA35)","v":0},{"$f":"COUNT(H35:AA35)","v":0}]
[{"$f":"+Input!B226","v":0},{"$f":"+Input!K226","v":0},{"$f":"+Input!E226","v":0},{"$f":"+Data!BD147-F36","v":0},{"$f":"+(Data!BG147*2)-G36","v":0},0,0]
[{"$f":"+Input!B227","v":0},{"$f":"+Input!K227","v":0},{"$f":"+Input!E227","v":0},{"$f":"+Data!BD148-F37","v":0},{"$f":"+(Data!BG148*2)-G37","v":0},0,0]
[{"$f":"+Input!B228","v":0},{"$f":"+Input!K228","v":0},{"$f":"+Input!E228","v":0},{"$f":"+Data!BD149-F38","v":0},{"$f":"+(Data!BG149*2)-G38","v":0},0,0]
[{"$f":"+Input!B229","v":0},{"$f":"+Input!K229","v":0},{"$f":"+Input!E229","v":0},{"$f":"+Data!BD150-F39","v":0},{"$f":"+(Data!BG150*2)-G39","v":0},0,0]
[{"$f":"+Input!B230","v":0},{"$f":"+Input!K230","v":0},{"$f":"+Input!E230","v":0},{"$f":"+Data!BD151-F40","v":0},{"$f":"+(Data!BG151*2)-G40","v":0},0,0]
[{"$f":"+Input!B231","v":0},{"$f":"+Input!K231","v":0},{"$f":"+Input!E231","v":0},{"$f":"+Data!BD152-F41","v":0},{"$f":"+(Data!BG152*2)-G41","v":0},0,0]
[{"$f":"+Input!B232","v":0},{"$f":"+Input!K232","v":0},{"$f":"+Input!E232","v":0},{"$f":"+Data!BD153-F42","v":0},{"$f":"+(Data!BG153*2)-G42","v":0},0,0]
[{"$f":"+Input!B233","v":0},{"$f":"+Input!K233","v":0},{"$f":"+Input!E233","v":0},{"$f":"+Data!BD154-F43","v":0},{"$f":"+(Data!BG154*2)-G43","v":0},{"$f":"SUM(H43:AA43)","v":0},{"$f":"COUNT(H43:AA43)","v":0}]
[{"$f":"+Input!B234","v":0},{"$f":"+Input!K234","v":0},{"$f":"+Input!E234","v":0},{"$f":"+Data!BD155-F44","v":0},{"$f":"+(Data!BG155*2)-G44","v":0},0,0]
[{"$f":"+Input!B235","v":0},{"$f":"+Input!K235","v":0},{"$f":"+Input!E235","v":0},{"$f":"+Data!BD156-F45","v":0},{"$f":"+(Data!BG156*2)-G45","v":0},0,0]
[{"$f":"+Input!B236","v":0},{"$f":"+Input!K236","v":0},{"$f":"+Input!E236","v":0},{"$f":"+Data!BD157-F46","v":0},{"$f":"+(Data!BG157*2)-G46","v":0},0,0]
[{"$f":"+Input!B237","v":0},{"$f":"+Input!K237","v":0},{"$f":"+Input!E237","v":0},{"$f":"+Data!BD158-F47","v":0},{"$f":"+(Data!BG158*2)-G47","v":0},0,0]
[{"$f":"+Input!B238","v":0},{"$f":"+Input!K238","v":0},{"$f":"+Input!E238","v":0},{"$f":"+Data!BD159-F48","v":0},{"$f":"+(Data!BG159*2)-G48","v":0},0,0]
[{"$f":"+Input!B239","v":0},{"$f":"+Input!K239","v":0},{"$f":"+Input!E239","v":0},{"$f":"+Data!BD160-F49","v":0},{"$f":"+(Data!BG160*2)-G49","v":0},0,0]
[{"$f":"+Input!B240","v":0},{"$f":"+Input!K240","v":0},{"$f":"+Input!E240","v":0},{"$f":"+Data!BD161-F50","v":0},{"$f":"+(Data!BG161*2)-G50","v":0},0,0]
[{"$f":"+Input!B241","v":0},{"$f":"+Input!K241","v":0},{"$f":"+Input!E241","v":0},{"$f":"+Data!BD162-F51","v":0},{"$f":"+(Data!BG162*2)-G51","v":0},{"$f":"SUM(H51:AA51)","v":0},{"$f":"COUNT(H51:AA51)","v":0}]
[{"$f":"+Input!B242","v":0},{"$f":"+Input!K242","v":0},{"$f":"+Input!E242","v":0},{"$f":"+Data!BD163-F52","v":0},{"$f":"+(Data!BG163*2)-G52","v":0},0,0]
[{"$f":"+Input!B243","v":0},{"$f":"+Input!K243","v":0},{"$f":"+Input!E243","v":0},{"$f":"+Data!BD164-F53","v":0},{"$f":"+(Data!BG164*2)-G53","v":0},0,0]
[{"$f":"+Input!B244","v":0},{"$f":"+Input!K244","v":0},{"$f":"+Input!E244","v":0},{"$f":"+Data!BD165-F54","v":0},{"$f":"+(Data!BG165*2)-G54","v":0},0,0]
[{"$f":"+Input!B245","v":0},{"$f":"+Input!K245","v":0},{"$f":"+Input!E245","v":0},{"$f":"+Data!BD166-F55","v":0},{"$f":"+(Data!BG166*2)-G55","v":0},0,0]
[{"$f":"+Input!B246","v":0},{"$f":"+Input!K246","v":0},{"$f":"+Input!E246","v":0},{"$f":"+Data!BD167-F56","v":0},{"$f":"+(Data!BG167*2)-G56","v":0},0,0]
[{"$f":"+Input!B247","v":0},{"$f":"+Input!K247","v":0},{"$f":"+Input!E247","v":0},{"$f":"+Data!BD168-F57","v":0},{"$f":"+(Data!BG168*2)-G57","v":0},0,0]
[{"$f":"+Input!B248","v":0},{"$f":"+Input!K248","v":0},{"$f":"+Input!E248","v":0},{"$f":"+Data!BD169-F58","v":0},{"$f":"+(Data!BG169*2)-G58","v":0},0,0]
[{"$f":"+Input!B249","v":0},{"$f":"+Input!K249","v":0},{"$f":"+Input!E249","v":0},{"$f":"+Data!BD170-F59","v":0},{"$f":"+(Data!BG170*2)-G59","v":0},0,0]
[{"$f":"+Input!B250","v":0},{"$f":"+Input!K250","v":0},{"$f":"+Input!E250","v":0},{"$f":"+Data!BD171-F60","v":0},{"$f":"+(Data!BG171*2)-G60","v":0},0,0]
[]
[]
[]
[]
[]
[]
[]
["Section \"TWO\" = \"Cleaned up\" information for copying to a separate Spreedsheet for transmission to ISPA"]
[]
["Name","Club","ISPA#","PT","CL"]

{"sheet":"Version_Control","index":7,"n_rows":70,"n_cols":4,"rows_kept":70,"cut":false,"hidden":false,"merged":[[35,0,35,3],[41,0,41,3],[39,0,39,3],[51,0,51,3],[0,0,0,1],[0,2,0,3],[3,0,4,0],[3,1,4,1],[32,0,32,3],[30,0,30,3],[5,0,5,3],[24,0,24,3],[17,0,17,3],[13,0,13,3],[61,0,61,3],[43,0,43,3],[37,0,37,3],[54,0,54,3],[67,0,67,3],[45,0,45,3],[49,0,49,3],[47,0,47,3],[57,0,57,3],[59,0,59,3],[65,0,65,3],[63,0,63,3]]}
["Version Number Convention:",null,"First Number represents major updates including reset of Workbook for new year.  The next two digets are for medium updates and the last two digits represents minor updates/corrections"]
["Date","Version #","Changes made","by"]
["2005-11-06","0.05.00","Initial Beta Version using still some \"mock-up\" info.  \"see e-mail to Heidi of even date re required info/changes\"","Willi Koenen"]
["2005-11-07","0.05.01","Entered 19 Members and 3 Guest names.  Reduced Data sheet to Zero's and for testing purposes entered 3 times the same scores which were moved as required to the first three score column on the Data sheet using date of Oct 8, 15 and 22/05 for all 22 names. Used score figures which would end up with \"start # x 100\" for easy testing.  Tried to put names in alpha order in the holding area (with guests at end) which would place the start numbers NOT in numerical order. However, results were unexpected and puzzling. While scores end up at the correct name in the temporary holding area (Row 201 etc on Input sheet), the name popping up at the top of the input sheet was not always correct that way, so I put the holding area back in start number order."]
[null,null,"Table look-up section cannot be sorted in alpha order, another puzzling issue, perhaps due to being on the same sheet as the \"holding\" area (used for Look-UP), since the results and next_worksheet sheets are able to be sorted in any order, notwithstanding the formulas.  Look-Up table could be placed in alpha order manually by way of changing the formula. but given those few names, I don't think it's needed, given any future new guest wouldn't be in alpha order anyway.  Also based on Toronto experience, everyone entered their start number as requested, so look-up table was never needed to date.","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 0 6"]
["2006-01-01","0.06.00","1. Made changes to the Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Row 3 of the Data sheet and replaced all scores with 0 (zeros) as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names from the Rows 200 to 250 section of the \"Input\" sheet except those who turn up frequently and/or those Toronto members who are sometimes showing up here so they can maintain the identical start numbers they use in Toronto. ","Willi Koenen"]
["2006-01-10","1.00.00","Promoted to Production version although Prizes not yet entered on the Prize_Schedule - Heidi to provide.  However, as we started with the first Tournament on Jan 7/06 - the prizes for 13 players are entered.","Willi Koenen"]
["2006-03-31","1.00.01","Made changes to the \"Next Worksheet\" as follows: (1) Reduced number of lines from 50 to 41. (2) Added recording info for \"Abreizgeld\" as a \"picture\" given Excel would have demanded the same column-widths as the table above. (3) Increased the column width for Tisch #, so that there is some room in case a correction has to be made. (4) Added \"Total of Prizes in front of the Prizes Column to the Last Row.  Also made appropriate changes to the sorting macro for this sheet due to change (1) above.","Willi Koenen"]
["2006-05-22","1.00.02","1.) Changed the sorting macro of the year-to-date section of the \"Results\" sheet to sort: firstly by the \"Running 25 week Ave\" column (descending)., then by the \"Year-to-date\" totals (descending) (secondary sort still needed in case the primary sort shows some identical scores), and then by the \"Name\" (ascending)                                                                                                                                    2) Moved the total on the \"Year-to-date\" side of the \"Results\" sheet from row 36 to row 32 and changed the adding formulas accordingly.","Willi Koenen"]
["as above","as above","3) Added a new section to record the Abreizgeld including appropiate formulas. Unprotected Cells N34/35 to allow manual input after finalization.                                                                                      4) Copied the \"Part_3_Sort_Results_and_Next_Worksheet\" macro to a new macro named \"Sort_Results_and_Next_Worksheet\" and assigned that one to the macro button on the Data sheet. 5) Added a section to the \"Part_3_Sort.......\" macro to copy the total of the Abreizgeld from column \"O\" to column \"M\" and replace the amounts in Cells N34/35 with a 0 (Zero) ","Willi Koenen"]
["2006-06-29","1.00.03","1) Moved the total on the \"Year-to-date\" side of the \"Results\" sheet from row 32 to row 31 and changed the adding formulas accordingly.                                                                                                 2) Added an extra line for \"Withdrawals\" to the Abreizgeld section and changed adding formulas accordingly. Unprotected Cells N33/34/35 to allow manual input after finalization.                                                                                      3) Changed \"Sort_Results_and_Next_Worksheet\" to account for the removed extra line.                  4) Changed the section to the \"Part_3_Sort.......\" macro to copy the total of the Abreizgeld from column \"O\" to column \"M\" and replace the amounts in Cells N33/34/35 with a 0 (Zero) ","Willi Koenen"]
["2006-06-29","1.00.04","Updated Prize_Schedule to include prizes for 19 to 31 players","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 0 7"]
["2006-12-18","2.00.00","1. Made changes to the Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Row 3 of the Data sheet and replaced all scores with 0 (zeros) as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names from the Rows 200 to 250 section of the \"Input\" sheet except those who turn up frequently and/or those Toronto members who are sometimes showing up here so they can maintain the identical start numbers they use in Toronto. ","Willi Koenen"]
["2006-12-18","2.00.01","1. Added Lisa Ruge to the Input sheet with Permanent Start Number of 22                                                                                                                      2. Placed the required formulas for Ruge in the year-to-date section of the Results sheet - so she already shows up there.","Willi Koenen"]
["2006-12-23","2.00.02","1. Changed Dietrich and Albrecht from Guests to Members.                                                                                2. Placed the required formulas for those two in the year-to-date section of the Results sheet             3. Reduced the size of the Upcoming Events section and increased the Finincial section by 4 rows and changed the Macro to copy all 7 columes from Totol to Prev. Balance.","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 0 8"]
["2007-12-21","3.00.00","1. Made changes to the Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Row 3 of the Data sheet and replaced all scores with 0 (zeros) as the finalize macro will again populate the sheet as required.                                                                                       3. Removed 5 guest names from the Rows 200 to 250 section of the \"Input\" sheet except those who turn up frequently and/or some of those Toronto members who are sometimes showing up here so they can maintain the identical start numbers they use in Toronto. ","Willi Koenen"]
["2008-01-27","3.00.01","1. Changed Fisher from Guests to Members.                                                                                              2. Placed the required formulas for him in the year-to-date section of the Results sheet                      3. Udated the Price_Schedule to reflect the newly defined prices.","Willi Koenen"]
["2008-02-13","3.00.02","1. Changed Cubrt from Guests to Members.                                                                                               2. Placed the required formulas for him in the year-to-date section of the Results sheet.","Willi Koenen"]
["2008-06-12","3.00.03","1. Changed Fischer and Debellis from Guests to Members.                                                                                2. Placed the required formulae for those two in the year-to-date section of the Results sheet             3. Reduced the size of the Upcoming Events section by 2 rows and increased the Year to date section by 2 rows and changed its totals formulae accordingly, moved the financial section two rows down and changed the two sort Macros accordingly for both the added two rows and all respective rows for the financial section aspect in the Part 3 macro.","Willi Koenen"]
["2008-07-24","3.00.04","1. Changed Pielorz, Roswitha and Mielitz, Wolfgang from Guests to Members.                                                                                2. Placed the required formulae for those two in the year-to-date section of the Results sheet             3. Deleted Frank, Paul from right side of Results sheet as, while an ISPA member for Hamilton, he doesn't play. thus no need to make at this time further major changes as done on July 12/08","Willi Koenen"]
["2008-08-30","3.00.05","1. Changed Knebel from Guests to Members and Andres from Member to Guests                                                                                2. Change the Andres formulae for those of Knebel in the year-to-date section of the Results sheet             ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 0 9"]
["2008-12-20","4.00.00","1. Made changes to the Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Row 3 of the Data sheet and replaced all scores with 0 (zeros) as the finalize macro will again populate the sheet as required.                                                                                       3. Removed various guest names from the Rows 200 to 250 section of the \"Input\" sheet except those who turn up frequently and/or some of those Toronto members who are sometimes showing up here so they can maintain the identical start numbers they use in Toronto. ","Willi Koenen"]
["2009-03-13","5.00.00","Corrected a programme bug in Workbook.  Data sheet had in Cells BE63 to BE112 the following incorrect formula  =VLOOKUP(A63,$A$53:$BB$112,$BE$116+2,FALSE).  I now corrected this to =VLOOKUP(A63,$A$63:$BB$112,$BE$116+2,FALSE). Starting with reference to $A$53 checked thas also rows 53 to 62 for info and as row 53 shows the score for round one for Startnumber 50 that score showed up for Round two as well.","Willi Koenen"]
["2009-04-24","6.00.00","Made the following major changes to the Results sheet and the applicable formulae for the totals and the applicable moving/clearing (financial section) and sorting marcro (Y-T-D scores, etc.): (1) Increased the right side for the Y-T-D member scores by 3 lines from J4-O33 to J4-O36 to make room for potential new members. (2) Moved and increased by one line (to allow recording of value of Skat Games on hand) the financial section from J34-O42 to J37-O46. (3) Reduced the Upcoming Event section by 4 lines from J43-O56 to J47-O56.","Willi Koenen"]
["2009-09-30","7.00.00","Created a new sheet \"Sort_First_Round\" and appropriate Marco \"Copy_round_1_scores_from_Input_Sheet_and_sort\" to facilitate easier table selection for 2nd round if scores for 1st round are entered at the Germania Klub.","Willi Koenen"]
["2009-09-15","8.00.00","Created a new sheet \"ISPA_Scores and appropriate Marco \"CTRL-I\" to generate the required info for the submission of ISPA Scores to ISPA on the required submission dates. ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 0"]
["2010-01-01","9.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed various guest names from the Rows 200 to 250 section of the \"Input\" sheet except those who turn up frequently and/or some of those Toronto members who are sometimes showing up here so they can maintain the identical start numbers they use in Toronto. Switched Eckert (1) to (35) and Mielitz (35) to (1) as the first row needs someone with an ISPA # which Eckert didn't have.                                                              4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                          5) On the ISPA_Score sheet deleted all scores (related to average scores) in Columns H and onward ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 1"]
["2011-01-01","10.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for 2011 from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet deleted all scores (related to average scores) in Columns H and onward ","Willi Koenen"]
["2011-11-06","10.01.00","Changed the formula on the Data sheet in column BF, Rows 122 to 171 from =COUNTIF(Cx:BBx,\">0\") to =COUNTIF(Cx:BBx,\"<>0\") where \"x\", represents the row number, thus counting the number of positive and negative scores but not ZERO scores.  A negative total score for 2 rounds very rare but has occured.","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 2"]
["`","11.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet deleted all scores (related to average scores) in Columns H and onward ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 3"]
["2013-01-01","12.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 52 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet deleted all scores (related to average scores) in Columns H and onward ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 4"]
["2013-12-25","13.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet has not been used in 2013 ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 5"]
["2014-12-19","14.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet has not been used in 2014 ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 6"]
["2015-12-12","15.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet has not been used since 2013 ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 7"]
["2016-12-10","16.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet has not been used since 2013 ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 8"]
["2017-12-11","17.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) On the ISPA_Score sheet has not been used since 2013 ","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 1 9"]
["2018-12-09","18.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) The ISPA_Score sheet has not been used since 2013 - thus ignored","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 2 0"]
["2019-12-04","19.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 200 to 250 section of the \"Input\" sheet.                                                                                                                4) Updated the Financial Section on the Results sheet with the Carry Forward financial data.                           5) The ISPA_Score sheet has not been used since 2013 - thus ignored","Willi Koenen"]
["2019-12-04","19.01.00","1) Totally changed the Sort_First_Round sheet                                                                                                    2) Changed the \"Copy_round_1_scores_from_Input_Sheet_and_sort\" macro to facilitate easier table selection for 2nd round if scores for 1st round are entered  which now stops at the bottom in case there is a player with a minus score which naturally is in a sort moved to the bottom and hence easyly overlooked              3) added a new macro to facilitate printing out the seating order and automatically going back to the top of the Input sheet.","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 2 2"]
["2022-02-14","20.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all guest names as well as previous members who will not be members for this year from the Rows 201 to 250 section of the \"Input\" sheet                                                                                         .  4) Added  z* in front of all names pending payment of 2022 membership fee and added protential names from the TOR club which may join but pending joining not added to the right side of the Results sheet.     5) Deleted a deceased previous member from the right side of the Results sheet.                                                                                                               6) Deleted info from the Financial Section on the Results sheet including the Carry Forward financial data which needs to be input by the Treasurer..                                                                                                             7) The ISPA_Score sheet has not been used since 2013 - thus ignored","Willi Koenen"]
["2022-07-26","20.01.00","1. Changed the Prize_Schedule sheet from a 100% payout to an 80% payout to be used effective June 4th, 2022\n2. Changed on Results sheet in the Financial Section the wording in a few lines                                          3. Changed on the Results sheet \"Upcoming Events\" to \"Information\"                                                        4. Removed some \"z*\" from those names who payed all for 2022 i.e., a) the Club fee, b) the ISPA fee and c) the Germanina Club fee.","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 2 3"]
["2022-12-04","21.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. Removed all but 6 guests names as well as previous members who will not be members for this year from the Rows 201 to 250 section of the \"Input\" sheet  - those left plan to come as guest or beome members                                                                                                                                                .  4) Added  z* in front of all names pending payment of 2023 membership fee   5) Deleted a deceased previous member from the right side of the Results sheet.                                                                                                               6) Deleted info from the Financial Section on the Results sheet including the Carry Forward financial data which needs to be input by the Treasurer..                                                                                                             7) The ISPA_Score sheet has not been used since 2013 - thus ignored","Willi Koenen"]
["Temporary Changes For our x-mas Skat being the first two games of our new fiscal year  2 0 2 3"]
["2022-12-10","21.01.00","1. Changed Formulae in Cell D4 of the results sheet  from \"=IF(G4<>0,10,0)\" to \"=IF(G4<>0,20,0)\". to reflect the collection of $20.00 rather than $10.00 for the 2 separate x-mas games. Will be changed back for Game 3\n2. Replaced our preset Prize_Schedule sheet by a temporaty sheet created via using present sheet amount by 8 * 20 using the fromula =ROUND(XX/8*20,0) where XX is the existing cell with current prize, thus prices will change from a payout of 80 % of $10 to 100 % of $20.  Will be changed back for Game 3","Willi Koenen"]
["Reversed temorary changes made in version 21.01.00 back to version 21.00.00"]
["2022-12-12","21.02.00","Reversed the two changes made on Dec. 10, 2022","Willi Koenen"]
["Changes based on revised payout rules per AGM of June 3rd, 2023"]
["2023-06-03","21.03.00","Replaced the 80 % payout Prize_Schedule with the previously used 100 % payout Prize_Schedule","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 2 4"]
["2024-01-03","22.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as required.                                                                                       3. As the TOR club no longer in operation and hence no need for identical start nambers for those having been a member of both clubs, reassigned all start number from 1 to 16 and added 2 potential guests to the Rows 201 to 250 section of the Input sheet.                                                                                                                                                                                                                                                                                             4) Updated the Financial Section on the Results sheet and made approprate changes to wording.                                                                                                             5) The ISPA_Score sheet has not been used since 2013 - thus ignored","Willi Koenen"]
["Changes associated due to the start of our new fiscal year  2 0 2 5"]
["2024-11-16","23.00.00","1. Changed Headings of the \"Results\" and \"Next Worksheet\" sheets to reflect our new fiscal year.\n2. Deleted all dates in Rows 3 and 62 of the Data sheet and replaced all scores with 0 (zeros) in First and Second Groupings as the finalize macro will again populate the sheet as equired                                       3. Removed 2024 guest names and S.Barta from the Input shett (Row 201 etc section).                                                                                                                                                                                                                                                                                                                          4. Updated the Financial Section on the Results sheet and made approprate changes to wording.                                                                                                             5. The ISPA_Score sheet has not been used since 2013 - thus ignored","Willi Koenen"]
["2024-11-22","23.00.01","Removed Sigfrid Barta's line (for player with start # 3 from right side of Results sheet (missed on Nov 16th (Siggy passed away last week) - May he rest in peace.","Willi Koenen"]