{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Class calculator","Teams","Instructions for Scorekeepers","Instructions for Jury members"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Class calculator","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[13,14,14,16]]}
["Netherlands",null,null,null,null,null,"Max players",5,"Australia"]
["Name","Number","Value",null,"Players total","Class total","Max value",11,"Name","Number","Value",null,"Players total","Class total"]
["Arjen Robben",71,1,null,{"$f":"COUNTIF(D3:D12,\"x\")","v":0},{"$f":"SUMIFS(C3:C12,D3:D12,\"x\")","v":0},null,null,"Crocodile Dundee",68,1,null,{"$f":"COUNTIF(L3:L12,\"x\")","v":0},{"$f":"SUMIFS(K3:K12,L3:L12,\"x\")","v":0}]
["Robin van Persie",79,3,null,null,null,null,null,"Elle MacPherson",51,3]
["Edwin van der Sar",54,2,null,null,null,null,null,"Mick Hogan",84,4]
["Wesley Sneijder",12,1,null,0,null,null,null,"James Cook",66,4,null,0]
["Kitty van Male",93,4,null,7,null,null,null,"Jane Halifax",4,2,null,1]
["Daphne Koster",9,3,null,null,null,null,null,"Rita McNoggin",27,3]
["Ellie van den Brom",65,1,null,null,null,null,null,"John Harrington",13,1]
["Eva Lubbers",61,1,null,null,null,null,null,"Dick \"Tracy\" Hamm",56,4]
["Martin Stekelenburg",6,3,null,null,null,null,null,"Vanessa Doubledee",73,1]
["Vincent Kompany",80,4,null,null,null,null,null,"Anita Zhou",62,2]

{"sheet":"Teams","index":1,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["Team","Name","Number","Class",null,null,null,null,"Teams"]
["Australia","Crocodile Dundee",68,1,null,null,null,null,"Australia"]
["Australia","Elle MacPherson",51,3,null,null,null,null,"Belgium"]
["Australia","Mick Hogan",84,4,null,null,null,null,"Denmark"]
["Australia","James Cook",66,4,null,null,null,null,"Finland"]
["Australia","Jane Halifax",4,2,null,null,null,null,"Germany"]
["Australia","Rita McNoggin",27,3,null,null,null,null,"Italy"]
["Australia","John Harrington",13,1,null,null,null,null,"Netherlands"]
["Australia","Dick \"Tracy\" Hamm",56,4,null,null,null,null,"Switzerland"]
["Australia","Vanessa Doubledee",73,1]
["Australia","Anita Zhou",62,2]
["Belgium","Nika van Kleeft",41,1]
["Belgium","Sandra Boughert",60,3]
["Belgium","Jan Dwenklin",81,2]
["Belgium","Godiva Brimm",26,1]
["Belgium","Manequin Piss",70,2]
["Belgium","Ana Marie Nosieux",93,3]
["Belgium","Marike van Kalken",37,4]
["Belgium","Arjan Dwann",44,1]
["Belgium","Edgar Pitt",48,1]
["Belgium","Alex Buttner",3,4]
["Denmark","Karl Nielson",15,4]
["Denmark","Gustav Hanberg",32,1]
["Denmark","Doris Duo",75,2]
["Denmark","Beatrix Bernard",35,1]
["Denmark","Jon Snow",83,1]
["Denmark","Astrid Lundgren",72,2]
["Denmark","Dolph Lundgren",24,3]
["Denmark","Thomas Guldrun",39,2]
["Denmark","Dina Antberg",56,3]
["Denmark","Anders Bardal",5,1]
["Finland","Janne Ahonen",29,4]
["Finland","Michael Granlund",75,3]
["Finland","Tuukka Rask",1,4]
["Finland","Tanja Poutiainen",85,1]
["Finland","Teemu Selänne",64,4]
["Finland","Kimi Räikkönen",88,2]
["Finland","Matti Nykänen",47,1]
["Finland","Kalle Palander",66,1]
["Finland","Mika Kohonen",52,1]
["Finland","Karina Saaloma",5,3]
["Germany","Manuel Neuer",57,3]
["Germany","Michael Schumacher",75,2]
["Germany","Felix Neureuter",64,4]
["Germany","Boris Becker",21,4]
["Germany","Steffi Graf",86,3]
["Germany","Oliver Kahn",80,4]
["Germany","Dirk Nowitzki",32,4]
["Germany","Magdalena Neuner",62,4]
["Germany","Kati Wilhelm",85,1]
["Germany","Michael Ballack",39,1]
["Italy","Alberto Tomba",35,1]
["Italy","Andrea Pirlo",94,4]
["Italy","Mario Balotelli",61,1]
["Italy","Pippo Inzaghi",95,2]
["Italy","Max Blardone",50,3]
["Italy","Anna Oxa",43,3]
["Italy","Romina Power",79,4]
["Italy","Al Bano",52,2]
["Italy","Eros Ramazzotti",59,3]
["Italy","Gianna Nanini",90,3]
["Netherlands","Arjen Robben",71,1]
["Netherlands","Robin van Persie",79,3]
["Netherlands","Edwin van der Sar",54,2]
["Netherlands","Wesley Sneijder",12,1]
["Netherlands","Kitty van Male",93,4]
["Netherlands","Daphne Koster",9,3]
["Netherlands","Ellie van den Brom",65,1]
["Netherlands","Eva Lubbers",61,1]
["Netherlands","Martin Stekelenburg",6,3]
["Netherlands","Vincent Kompany",80,4]
["Switzerland","Roger Federer",56,2]
["Switzerland","Michael Musche",15,1]
["Switzerland","Johannes Straube",84,2]
["Switzerland","Karin Achtung",63,1]
["Switzerland","Jan Grosse",86,3]
["Switzerland","Annette Staubahn",7,1]
["Switzerland","Christian Moser",61,1]
["Switzerland","Fabian Jopin",16,3]
["Switzerland","Daniel Bollinger",31,4]
["Switzerland","Martina Hingis",3,4]

{"sheet":"Instructions for Scorekeepers","index":2,"n_rows":62,"n_cols":1,"rows_kept":62,"cut":false,"hidden":false,"merged":[[2,0,2,11],[3,0,3,11],[4,0,4,11]]}
["Class Value Calculator instructions for use"]
[]
["Class Value Calculator (CVC) is an assistant tool for the Scorekeeper on official ICEWH tournaments."]
["It allows quick and easy verification of current and suggested (in case of substitutions) total Class Value of the team during a match."]
["The teams and player values will be prepared before the match by the Jury members and can't be changed once the match starts."]
[]
["Selecting the field players"]
[]
["Players on the field are selected by pressing the In/Out button in the same line as their name. The button title will toggle between In and Out,"]
["depending on the status of the player. If the player is in the field, the button should display the word In. If the player is in the team area"]
["the button should display the word Out. "]
[]
["Class value for players with T-sticks"]
[]
["A player that ordinarily plays with the hand-held stick (and has a Class value >1) can choose to play with the T-stick. However, their class"]
["value doesn't change. In such cases, check the box titled T-stick in the line with the player's name before pressing the In/Out button."]
["If the same player decides to play with the hand-held stick in the same match, clear the box. This can only be done when player is \"Out\"."]
["The T-stick box has to be checked in order to correctly calculate number of hand-held sticks in the lineup on the field."]
[]
["Checking class value"]
[]
["The current class value is displayed under the heading Class total in the section of the calculator that refers to the team in question."]
["The field is colour coded and will turn red if the class total exceeds the allowed maximum. In other cases, the field will be green."]
[]
["Checking the number of players on the field"]
[]
["The current number of players on the field in one team is displayed in under the heading Players total in the section of the calculator for "]
["the team in question. The field will be colour coded and will turn red if the maximum allowed number of players on the field is exceeded."]
["The field will be coloured green if the number of players on the field is exactly 5 and yellow, if the number is less than five. It is possible"]
["for a team to play with less than 5 players on the field, hence the warning (yellow) colour."]
[]
["Clearing the player status for the whole team"]
[]
["If at any point it becomes necessary to clear the In/Out status for the whole team, click the Clear team A/B button. A confirmation box will"]
["be displayed. Clicking on Yes will reset all the player statuses to Out, while clicking on No will not make any changes. Also, the T-stick"]
["boxes for hand-stick players will be reset, along with the class values for those players that have been marked as \"playing with the T-stick\"."]
[]
["Using CVC - before the match"]
[]
["When the starting lineup is received from the coaches, mark all the starting players as In. Make sure to mark any players that ordinarily play"]
["with the hand-held stick, but will be using the T-stick, by checking the T-stick box in the line with their name. Verify that the total Class Value"]
["doesn't exceed the allowed limit (the field is not red)."]
[]
["Using CVC - during the match"]
[]
["When a substitution is announced by the coact, do the following:"]
["1. mark the player leaving the field as Out by clicking on the In/Out button in the line with their name"]
["2. mark the player entering the field as In by clicking on the In/Out button in the line with their name"]
["3. verify that the total Class value for the team doesn't exceed the allowed maximum (field is not red)"]
["4. signal the substitution to the referees"]
[]
["If the total Class value exceeds the allowed maximum (the field is red), signal the team coach that the substitution is incorrect. Reset the "]
["In/Out values of the players back to the state before the substitution has been announced (the player that was supposed to leave the field"]
["should be marked as In, while the new player should be marked as Out)."]
[]
["Warnings"]
[]
["The calculator will display the following warnings:"]
["- Too many hand sticks (text and red colour)"]
["- Too many players on the field (red colour)"]
["- Class value too high (red colour)"]
["- Too few players on the field (yellow colour, as it is possible to play with less than 5 players)"]

{"sheet":"Instructions for Jury members","index":3,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["At the beginning of the tournament"]
[]
["After all the classification procedures have been completed (along with any possible complaints), enter the team names in "]
["the Teams worksheet under the heading Teams. This will limit the selection for the team membership when entering "]
["players, as well as set up the team boxes in the Class calculator worksheet."]
[]
["Proceed by entering all the players with their names, numbers and class values in the appropriate columns."]
["All players of one team must be entered sequentially. If there are less than 10 players in a team, leave their name and"]
["number empty. All teams must have 10 player slots occupied!"]
[]
["After all the teams and players have been entered, click on the Lock/Unlock button and enter the password for sheet"]
["protection. Make sure that the password is known only to other Jury members!"]
[]
["Before the match"]
[]
["In the Class calculator sheet, select the teams that play in the coming match. The player names and values will automatically be"]
["copied to the required places. If you select two identical teams, the Team name fields will be coloured red."]
["Click on both Clear team buttons to ensure that all In/Out and T-stick values are reset,"]
[]
["Once everything is set to your satisfaction, click on the Lock button and enter the protection password. Make sure that the "]
["password is known only to other Jury members and not to the Match table personnel."]