{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Cover","Event Info","Scores","Pro.Payouts","Am.Jr.Payouts","Finance","SupportData"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":39,"comments":2,"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":"Instructions","index":0,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[21,4,21,6],[22,4,22,6],[14,4,14,6],[15,4,15,6],[11,4,12,6],[23,4,23,6],[13,4,13,6],[24,4,24,6],[16,4,16,6],[18,4,18,6],[19,4,19,6],[20,4,20,6]]}
[]
[null,null,"Guide to the PDGA Tour International Event Report"]
[null,null,{"$f":"CONCATENATE(\"Version \",Cover!A1)","v":"Version 16.3"}]
[null,null,"Dear PDGA Tournament Director,"]
[]
[null,null,"Thanks for directing a PDGA Tour Event! The TD report has been updated to M/S Excel 2007+"]
[null,null,"and serves as a key component of the PDGA's database system in M/S Access. All TDs are expected"]
[null,null,"to use this tool and to return their completed event report to the PDGA by email as an attached"]
[null,null,"file as soon as possible. This will speed the processing of your event including the posting of official"]
[null,null,"results at www.pdga.com, and the calculation of player statistics including ratings."]
[]
[null,"Instructions:","The presentation of the report is similar to previous years. Please begin by filling in the Division Codes",null,"NOTE"]
[null,null,"Player Names and PDGA#s on the Scores sheet - this in turn will auto-fill or auto-highlight fields in the "]
[null,null,"Cover and Event Info sheets. The different worksheets can be accessed by clicking on the tabs at the bottom",null,"Type only in white"]
[null,null,"of your screen. To simplify data entry, TDs should only enter information in the yellow boxes. All other parts of",null,"or yellow boxes"]
[null,null,"the spreadsheet are locked. The green boxes are automated calculations, and the red text sections are areas",null,"DO NOT TYPE IN"]
[null,null,"for PDGA office use only. If your info does not fit in the space provided, try using smaller sized text. ",null,"BLUE OR"]
[]
[null,null,"Please note that certain details are essential for accurate data entry and for determining course and player ",null,"GREEN BOXES!"]
[null,null,"ratings. On the Event Info sheet this includes the order of course layouts played by the different divisions,",null,"These all use"]
[null,null,"tiebreakers for 1st place, and the identification of players who decline pro cash. On the Scores sheet ",null,"automatic entries"]
[null,null,"please be sure to include player PDGA#s, the place of finish for all players, the cash won by the pros,",null,"Do not insert or"]
[null,null,"and account for all ties in the places of finish and in the breakdown of the pro purse and am/junior prize value.",null,"delete rows. All "]
[null,null,"Please also note that per PDGA Rules of Play, all ties for 1st place must be broken, and a winner declared.",null,"cells postitioned"]
[null,null,null,null,"for data importing"]
[]
[null,null,"The following worksheets can be accessed by clicking on the tabs at bottom:"]
[]
[null,"Cover:","Summarizes players, entry fees, prizes, and player fees and memberships collected for the PDGA."]
[null,null,"International TDs should choose their local currency and calculate the exchange rate to US$ on this sheet."]
[null,null,"The report can then be completed in the local currency and the report features will automatically"]
[null,null,"calculate the values in US$ that will be entered into the PDGA database. "]
[null,null,"Enter a 'Yes' in cell M8 if your event is part of  the Eurotour Series. You may use your local currency to calculate"]
[null,null,"event expenses and payouts. However, your Eurotour fees will be calculated in Euros and shown in cell M43."]
[]
[null,"Event Info:","Provides key and general information on the event including courses and layouts played which are used to "]
[null,null,"generate player ratings. Please ensure that you also complete the section on Notes to Player Scores"]
[null,null,"including any withdrawals, Ams who declined pro cash, and disqualifications."]
[]
[]
[null,"Scores:","This sheet links to the PDGA database and shows the requested presentation of player information and"]
[null,null,"scores. Remember that all ties for 1st place must be broken, and that the PDGA does not recognize"]
[null,null,"the breaking of ties for places below first place. A new Basic Sort button has been added to help get your players into"]
[null,null,"Final Finish position. When your event has Semi and/or Final rounds, use the new Special Finals Sort button."]
[null,null,"Note that the Cash/Local Column is used to enter each player's payout in Local Currency (Euros, Yen etc)"]
[null,null,"From this the equivalent values in US$ are automatically calculated and displayed in the Cash/Value column."]
[null," >> ","Code 888 was added for TDs to indicate when a player has been confirmed to have been"]
[null,null,"manipulating their score or did not complete the round to protect their rating. "]
[null,null,"In addition, enter 888 when a player does not play their next round and did not notify the TD in advance."]
[]
[null,"ProPayout","These sheets are provided to help TDs automatically calculate payouts. Information is linked from the"]
[null,"AmJrPayout","Cover sheet for each division being hosted. Note: Entry fee boxes must be filled in on the Cover sheet using your local"]
[null,null,"currency before going to the Pro.Payout & Am.Jr.Payout sheets. Then, just enter the amount of net local currency"]
[null,null,"cash added or subtracted for each division and the program will calculate both exact and rounded off payout values."]
[null,null,"On the Pro or Am/Jr payout tables, TDs can select 15%, 20%, 25%, 33%, or 40% (45% Ams) payout for each division."]
[null,null,"The Manual Adj. & Final Place columns let TDs adjust payouts to account for ties. For Am divisions, the"]
[null,null,"currency values and \"added cash\" for the payouts are based on retail merchandise values in local currency."]
[null,null,"Once you have calculated your event payout make sure you enter the amounts won by the players "]
[null,null,"in the Scores sheet in the Cash/Local in your local currency."]
[]
[null,"Finance:","Part 1 on Sponsors is requested of all TDs. The Income Statement that follows (Part 2) is provided as a "]
[null,null,"resource to assist your event management. Only Majors and EuroTour events are required to complete and "]
[null,null,"submit this section."]
[]
[null,"Reporting","Once you have completed the Tour Event Report please return it as an email attachment:"]
[null,"to PDGA","- To the PDGA Office at tdreport@pdga.com "]
[null,null,"- For all EuroTour Series events, please copy to the EuroTour Manager at hans@pdga-europe.com"]
[]
[null,"Questions ? ","Please contact the report designers at ck34@aol.com or asweeton@pdga.com or bhoeniger@pdga.com ."]
[]
[null,"TDR2015","Thanks and good luck with your International PDGA Tour event!"]

{"sheet":"Cover","index":1,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[22,8,22,10],[23,8,23,10],[6,16,6,18],[9,15,9,19],[19,8,19,10],[9,9,9,10],[20,8,20,10],[15,8,15,10],[21,8,21,10],[43,13,43,18],[3,18,3,19],[1,11,1,19],[8,15,8,19],[37,13,37,18],[18,13,18,18],[14,15,14,19],[3,15,3,16],[27,13,27,18],[11,8,14,12],[30,8,30,10],[24,8,24,10],[25,8,25,10],[26,8,26,10],[27,8,27,10],[28,8,28,10],[29,8,29,10]]}
[16.3]
["              PDGA Tour International Event Report",null,null,null,null,null,null,null,null,null,"Event: "]
[null,"Enter fees 'per player' in the yellow boxes using your local currency selected below."]
[null,"Player Names and DivCodes must be entered on the \"Scores\" sheet to see player counts.",null,null,null,null,null,null,null,null,null,null,null,null,"Date(s): ",null,null,"to"]
[null,"Gross","PDGA","Other","Net","# of","Total Net",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross"]
["PROS","Entry","Fee","Fees","Entry","Plyrs","Entry Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entry Fees"]
["Open",null,{"$f":"IF(AND(F7<>0,M$8=\"Yes\"),5*N$16,0)","v":0},null,{"$f":"B7-C7-D7","v":0},{"$f":"COUNTIF(Division,\"MPO\")","v":0},{"$f":"F7*E7","v":0},null,null,null,null,"Choose Currency > ","Euro €",null,null,"Tier: ",null,null,null,null,null,null,"Pro",{"$f":"SUM(B7:B18*F7:F18)","v":0}]
["Master",null,0,null,0,{"$f":"COUNTIF(Division,\"MPM\")","v":0},{"$f":"F8*E8","v":0},null,null,null,null,"Euro Tour Event? > ","No",null,null,null,null,null,null,null,null,null,"Am",{"$f":"SUM(B21:B36*F21:F36)","v":0}]
["Grandmaster",null,0,null,0,{"$f":"COUNTIF(Division,\"MPG\")","v":0},0,null,null,null,null,null,null,null,"TD Name: ",null,null,null,null,null,null,null,"Jr",{"$f":"SUM(B39:B50*F39:F50)","v":0}]
["Sr Grandmaster",null,0,null,0,{"$f":"COUNTIF(Division,\"MPS\")","v":0},0,null,null,{"$f":"IF(M7=\"\",\"\",M7)","v":"Euro €"},null,"to","US $",null,"Email Addr: ","@",null,null,null,null,null,null,null,{"$f":"SUM(X7:X9)","v":0}]
["Legend 70+",null,0,null,0,{"$f":"COUNTIF(Division,\"MPL\")","v":0},0,null,"Enter Conversion Rate > ",null,null,null,null,null,"TD PDGA#: ",null,null,null,"Country: "]
["Sr Legend 75+",null,0,null,{"$f":"B12-C12-D12","v":0},{"$f":"COUNTIF(Division,\"MPE\")","v":0},{"$f":"F12*E12","v":0},null,"Enter value of 1 unit of local currency in USD on the tournament start date. For example on 1-1-15 EUR 1.00 = USD 1.22, Japan Yen 1 = USD .0084"]
["Gr Legend 80+",null,0,null,{"$f":"B13-C13-D13","v":0},{"$f":"COUNTIF(Division,\"MPR\")","v":0},{"$f":"F13*E13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
["Open Women",null,0,null,0,{"$f":"COUNTIF(Division,\"FPO\")","v":0},0]
["Master Women",null,0,null,0,{"$f":"COUNTIF(Division,\"FPM\")","v":0},0,null,null,null,null,null,null,null,"City: "]
["GM Women",null,0,null,0,{"$f":"COUNTIF(Division,\"FPG\")","v":0},0,null,"Conversion Rate >",null,null,"www.x-rates.com"]
["Sr GM Women",null,0,null,0,{"$f":"COUNTIF(Division,\"FPS\")","v":0},0,null,null,null,null,null,null,null,"Summary of Players, Entry Fees, & Payout"]
["Legend Women",null,0,null,0,{"$f":"COUNTIF(Division,\"FPL\")","v":0},0,null,null,null,null,null,null,null,"Total Players",null,null,null,null,{"$f":"F19+F37+F51","v":0}]
["PRO Totals",null,null,null,null,{"$f":"SUM(F7:F17)","v":0},{"$f":"SUM(G7:G18)","v":0},null,null,null,null,null,{"$f":"IF(M7=\"\",\"\",M7)","v":"Euro €"},"PROFESSIONALS",null,null,null,null,null,"US $"]
["AMATEURS",null,null,null,null,null,null,null,"NOTE",null,null,null,{"$f":"SUM(Scores!M10:M225)","v":0},null,"Total Pro Cash Purse Paid Out",null,null,null,null,{"$f":"M20*$M$11","v":0}]
["Advanced",null,{"$f":"IF(AND(F21<>0,M$8=\"Yes\"),5*N$16,0)","v":0},null,{"$f":"B21-C21-D21","v":0},{"$f":"COUNTIF(Division,\"MA1\")","v":0},{"$f":"F21*E21","v":0},null,"Type only in white",null,null,null,{"$f":"G19","v":0},null,"Total Pro Net Entry Fees",null,null,null,null,{"$f":"M21*$M$11","v":0},null,null,{"$f":"IF(M21>0,M20/M21,\"\")","v":""}]
["Intermediate",null,0,null,0,{"$f":"COUNTIF(Division,\"MA2\")","v":0},0,null,"or yellow boxes",null,null,null,{"$f":"M20-M21","v":0},null,"Net Cash to Purse - Added (Reduced)",null,null,null,null,{"$f":"M22*$M$11","v":0}]
["Recreational",null,0,null,0,{"$f":"COUNTIF(Division,\"MA3\")","v":0},0,null,"DO NOT TYPE IN",null,null,null,null,null,"Pro Player Packs + Trophies $ Value",null,null,null,null,{"$f":"M23*$M$11","v":0}]
["Novice",null,0,null,0,{"$f":"COUNTIF(Division,\"MA4\")","v":0},0,null,"BLUE OR",null,null,null,null,null,"Other Pro Prizes $ (CTPs etc)",null,null,null,null,{"$f":"M24*$M$11","v":0}]
["Adv Master",null,0,null,{"$f":"B25-C25-D25","v":0},{"$f":"COUNTIF(Division,\"MM1\")","v":0},0,null,"GREEN BOXES!",null,null,null,{"$f":"SUM(M20,M23,M24)","v":0},null,null,"Pro Event Value",null,null,null,{"$f":"SUM(T20,T23,T24)","v":0},null,null,{"$f":"IF(M21>0,M25/M21,\"\")","v":""}]
["Adv GMaster",null,0,null,{"$f":"B26-C26-D26","v":0},{"$f":"COUNTIF(Division,\"MG1\")","v":0},0,null,"These all use"]
["Adv Sr GM",null,0,null,{"$f":"B27-C27-D27","v":0},{"$f":"COUNTIF(Division,\"MS1\")","v":0},0,null,"automatic entries"]
["Adv Legend",null,0,null,{"$f":"B28-C28-D28","v":0},{"$f":"COUNTIF(Division,\"ML1\")","v":0},0,null,"Do not insert or",null,null,null,{"$f":"IF(M7=\"\",\"\",M7)","v":"Euro €"},"AMATEURS & JUNIORS",null,null,null,null,null,"US $"]
["Adv W Master",null,0,null,0,{"$f":"COUNTIF(Division,\"FM1\")","v":0},0,null,"delete rows. All ",null,null,null,{"$f":"G37+G51","v":0},null,"Total Am/Jr Net Entry Fees",null,null,null,null,{"$f":"M29*$M$11","v":0}]
["Adv W GM",null,0,null,0,{"$f":"COUNTIF(Division,\"FG1\")","v":0},0,null,"cells postitioned",null,null,null,null,null,"Am/Jr Prizes + Player Packs + Trophies",null,null,null,null,{"$f":"M30*$M$11","v":0}]
["Adv W Sr GM",null,0,null,{"$f":"B31-C31-D31","v":0},{"$f":"COUNTIF(Division,\"FS1\")","v":0},0,null,"for data importing",null,null,null,null,null,"Other Am/Jr Prizes $ (CTPs etc)",null,null,null,null,{"$f":"M31*$M$11","v":0}]
["Adv W Legend",null,0,null,0,{"$f":"COUNTIF(Division,\"FL1\")","v":0},0,null,null,null,null,null,{"$f":"SUM(M30:M31)","v":0},null,null,"Am Event Value",null,null,null,{"$f":"SUM(T30:T31)","v":0}]
["Adv Women",null,0,null,{"$f":"B33-C33-D33","v":0},{"$f":"COUNTIF(Division,\"FA1\")","v":0},{"$f":"F33*E33","v":0}]
["Inter Women",null,0,null,{"$f":"B34-C34-D34","v":0},{"$f":"COUNTIF(Division,\"FA2\")","v":0},{"$f":"F34*E34","v":0}]
["Rec Women",null,0,null,{"$f":"B35-C35-D35","v":0},{"$f":"COUNTIF(Division,\"FA3\")","v":0},{"$f":"F35*E35","v":0}]
["Novice Women",null,0,null,0,{"$f":"COUNTIF(Division,\"FA4\")","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M29>0,M32/M29,\"\")","v":""}]
["AM Totals",null,null,null,null,{"$f":"SUM(F21:F36)","v":0},{"$f":"SUM(G21:G36)","v":0}]
["JUNIORS",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25,M32)","v":0},"  Total Tour Event Value",null,null,null,null,null,{"$f":"M38*$M$11","v":0}]
["Jr Boys <18",null,{"$f":"IF(AND(F39<>0,M$8=\"Yes\"),5*N$16,0)","v":0},null,{"$f":"B39-C39-D39","v":0},{"$f":"COUNTIF(Division,\"MJ1\")","v":0},{"$f":"F39*E39","v":0}]
["Jr Boys <15",null,0,null,0,{"$f":"COUNTIF(Division,\"MJ2\")","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M51","v":{"$error":"#VALUE!"}}]
["Jr Boys <12",null,0,null,0,{"$f":"COUNTIF(Division,\"MJ3\")","v":0},0,null,"Please note: All TD",null,null,null,"EuroTour event sanctioning and player fees (€5 per player) are sent "]
["Jr Boys <10",null,0,null,0,{"$f":"COUNTIF(Division,\"MJ4\")","v":0},0,null,"Reports and fees are",null,null,null,"to Hans Nagtegaal,  PDGA EuroTour Manager. All other PDGA fees are"]
["Jr Boys <8",null,0,null,0,{"$f":"COUNTIF(Division,\"Mj5\")","v":0},0,null,"due no more than",null,null,null,"are sent in US$ to the PDGA office in USA."]
["Jr Boys <6",null,0,null,0,{"$f":"COUNTIF(Division,\"Mj6\")","v":0},0,null,"one month after your "]
["Jr Girls <18",null,0,null,0,{"$f":"COUNTIF(Division,\"FJ1\")","v":0},0,null,"event. Thank You!",null,null,null,"EuroTour"]
["Jr Girls <15",null,{"$f":"IF(AND(F46<>0,M$8=\"Yes\"),5*N$16,0)","v":0},null,{"$f":"B46-C46-D46","v":0},{"$f":"COUNTIF(Division,\"FJ2\")","v":0},{"$f":"F46*E46","v":0}]
["Jr Girls <12",null,0,null,0,{"$f":"COUNTIF(Division,\"FJ3\")","v":0},0]
["Jr Girls <10",null,0,null,0,{"$f":"COUNTIF(Division,\"FJ4\")","v":0},0]
["Jr Girls <8",null,0,null,0,{"$f":"COUNTIF(Division,\"FJ5\")","v":0},0]
["Jr Girls <6",null,0,null,0,{"$f":"COUNTIF(Division,\"FJ6\")","v":0},0,null,null,null,null,null,{"$f":"IF(M8=\"Yes\",F19+F37+F51,\"\")","v":""},null,"Players"]
["JR Totals",null,null,null,null,{"$f":"SUM(F39:F50)","v":0},{"$f":"SUM(G39:G50)","v":0},null,null,null,null,null,{"$f":"M50*5","v":{"$error":"#VALUE!"}},null,"Fees"]

{"sheet":"Event Info","index":2,"n_rows":119,"n_cols":20,"rows_kept":119,"cut":false,"hidden":false,"merged":[[81,1,81,3],[74,1,74,17],[100,1,100,17],[95,1,95,17],[88,1,88,17],[82,1,82,3],[83,1,83,3],[93,1,93,17],[94,1,94,17],[87,1,87,17],[107,1,107,8],[107,10,107,17],[101,1,101,17],[102,1,102,17],[89,1,89,17],[80,1,80,3],[62,1,62,3],[63,1,63,3],[64,1,64,3],[65,1,65,3],[70,1,70,3],[73,1,73,17],[79,6,79,7],[79,4,79,5],[66,1,66,3],[59,1,59,3],[60,1,60,3],[55,1,55,3],[56,1,56,3],[75,1,75,17],[79,16,79,17],[67,1,67,3],[68,1,68,3],[69,1,69,3],[61,1,61,3],[8,11,8,15],[9,11,9,15],[10,11,10,15],[16,11,16,15],[11,11,11,15],[12,11,12,15],[13,11,13,15],[8,5,8,9],[29,1,29,3],[59,0,70,0],[41,1,41,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[46,1,46,3],[29,0,40,0],[41,0,56,0],[30,1,30,3],[54,1,54,3],[53,1,53,3],[47,1,47,3],[8,1,8,3],[40,1,40,3],[33,1,33,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[36,1,36,3],[31,1,31,3],[32,1,32,3],[18,11,18,15],[8,19,9,21],[16,19,16,21],[25,19,25,21],[12,19,12,21],[13,19,13,21],[14,19,14,21],[15,19,15,21],[10,19,10,21],[28,19,28,21],[11,19,11,21],[27,19,27,21],[26,19,26,21],[21,11,21,15],[14,11,14,15],[19,11,19,15],[15,11,15,15],[20,11,20,15],[17,11,17,15]]}
["PDGA Tour Event Report: General Information"]
[]
["1.","Course Layouts - Important!",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Please enter your permanent courses in the PDGA Course Directory"]
[]
[null,"The PDGA uses Player Ratings for calculating amateur division eligibility. In order to accomplish this,"]
[null,"it is VERY IMPORTANT that you complete the following information accurately. If the course(s) used are"]
[null,"listed in the PDGA Course Directory please ensure that the same course name(s) are used as appear in the directory."]
[]
["Layout","Please do not use apostrophes in any names or words!",null,null,null,"Number of Holes",null,null,null,null,null,"Length",null,null,null,null,null,"Meas?",null,"NOTE"]
["Code","Park or Course Name",null," Specific Layout / Configuration Name",null,"Perm",null,"Temp",null,"TOT",null,"(meters)",null,null,null,null,null,"or Est?"]
["A",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F11>0,H11>0),F11+H11,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(AND(OR(B11<>\"\",D11<>\"\"),OR(J11=\"\",L11=\"\",R11=\"\")),\"< Please enter all info requested\",\"\")","v":""},"Type only in white"]
["B",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(AND(B12<>\"\",OR(J12=\"\",L12=\"\",R12=\"\")),\"< Please enter all info requested\",\"\")","v":""},"or yellow boxes"]
["C",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(AND(B13<>\"\",OR(J13=\"\",L13=\"\",R13=\"\")),\"< Please enter all info requested\",\"\")","v":""},"DO NOT TYPE IN"]
["D",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(AND(B14<>\"\",OR(J14=\"\",L14=\"\",R14=\"\")),\"< Please enter all info requested\",\"\")","v":""},"BLUE OR"]
["E",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(AND(B15<>\"\",OR(J15=\"\",L15=\"\",R15=\"\")),\"< Please enter all info requested\",\"\")","v":""},"GREEN BOXES!"]
["F",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(AND(B16<>\"\",OR(J16=\"\",L16=\"\",R16=\"\")),\"< Please enter all info requested\",\"\")","v":""},"These all use"]
["G",null,null,null,null,null,null,null,null,{"$f":"IF(OR(F17>0,H17>0),F17+H17,\"\")","v":""},null,null,null,null,null,null,null,null,null,"automatic entries"]
["H",null,null,null,null,null,null,null,null,""]
["I",null,null,null,null,null,null,null,null,""]
["J",null,null,null,null,null,null,null,null,""]
["K",null,null,null,null,null,null,null,null,""]
["L",null,null,null,null,null,null,null,null,""]
[]
["2.","Layouts Played by Division by Round - Important!"]
[]
[null,"Enter the proper course layout code letter from above for each round played by each division listed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not insert or"]
[null,"NOTE:  Division name is gray until at least one player has been entered for it on the COVER sheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"delete rows. All "]
[null,null,null,null,null,null,null,null,null,"Course Layout Code",null,null,null,null,null,null,null,"Div",null,"cells postitioned"]
[null,"Divisions with players entered in your event",null,null,null,"R 1",null,"R 2",null,"R 3",null,"R 4",null,"Semi",null,"Final",null,"Code",null,"for data importing"]
["PRO","MPO - Pro Open",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F7>0,LEFT(B30,3),\"\")","v":""},{"$f":"IF(AND(R30<>\"\",COUNTA(F30:P30)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MPM - Pro Master",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F8>0,LEFT(B31,3),\"\")","v":""},{"$f":"IF(AND(R31<>\"\",COUNTA(F31:P31)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MPG - Pro Grandmaster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F9>0,LEFT(B32,3),\"\")","v":""},{"$f":"IF(AND(R32<>\"\",COUNTA(F32:P32)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MPS - Pro Sr Grandmaster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F10>0,LEFT(B33,3),\"\")","v":""},{"$f":"IF(AND(R33<>\"\",COUNTA(F33:P33)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MPL - Pro Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F11>0,LEFT(B34,3),\"\")","v":""},{"$f":"IF(AND(R34<>\"\",COUNTA(F34:P34)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MPE - Pro Sr Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F12>0,LEFT(B35,3),\"\")","v":""},{"$f":"IF(AND(R35<>\"\",COUNTA(F35:P35)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MPR - Pro Grand Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F13>0,LEFT(B36,3),\"\")","v":""},{"$f":"IF(AND(R36<>\"\",COUNTA(F36:P36)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FPO - Pro Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F14>0,LEFT(B37,3),\"\")","v":""},{"$f":"IF(AND(R37<>\"\",COUNTA(F37:P37)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FPM - Pro Master Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F15>0,LEFT(B38,3),\"\")","v":""},{"$f":"IF(AND(R38<>\"\",COUNTA(F38:P38)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FPG - Pro Grandmaster Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F16>0,LEFT(B39,3),\"\")","v":""},{"$f":"IF(AND(R39<>\"\",COUNTA(F39:P39)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FPS - Pro Sr Grandmaster Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F17>0,LEFT(B40,3),\"\")","v":""},{"$f":"IF(AND(R40<>\"\",COUNTA(F40:P40)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FPL - Pro Legend Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F18>0,LEFT(B41,3),\"\")","v":""},{"$f":"IF(AND(R41<>\"\",COUNTA(F41:P41)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
["AM","MA1 - Advanced",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F21>0,LEFT(B42,3),\"\")","v":""},{"$f":"IF(AND(R42<>\"\",COUNTA(F42:P42)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MA2 - Intermediate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F22>0,LEFT(B43,3),\"\")","v":""},{"$f":"IF(AND(R43<>\"\",COUNTA(F43:P43)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MA3 - Recreational",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F23>0,LEFT(B44,3),\"\")","v":""},{"$f":"IF(AND(R44<>\"\",COUNTA(F44:P44)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MA4 - Novice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F24>0,LEFT(B45,3),\"\")","v":""},{"$f":"IF(AND(R45<>\"\",COUNTA(F45:P45)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MM1 - Advanced Master",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F25>0,LEFT(B46,3),\"\")","v":""},{"$f":"IF(AND(R46<>\"\",COUNTA(F46:P46)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MG1 - Advanced Grandmaster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F26>0,LEFT(B47,3),\"\")","v":""},{"$f":"IF(AND(R47<>\"\",COUNTA(F47:P47)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MS1 - Advanced Sr Grandmaster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F27>0,LEFT(B48,3),\"\")","v":""},{"$f":"IF(AND(R48<>\"\",COUNTA(F48:P48)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"ML1 - Advanced Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F28>0,LEFT(B49,3),\"\")","v":""},{"$f":"IF(AND(R49<>\"\",COUNTA(F49:P49)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FM1 - Advanced Women Master",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F29>0,LEFT(B50,3),\"\")","v":""},{"$f":"IF(AND(R50<>\"\",COUNTA(F50:P50)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FG1 - Advanced Women Grandmaster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F30>0,LEFT(B51,3),\"\")","v":""},{"$f":"IF(AND(R51<>\"\",COUNTA(F51:P51)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FS1 - Advanced Women Sr Grandmaster",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F31>0,LEFT(B52,3),\"\")","v":""},{"$f":"IF(AND(R52<>\"\",COUNTA(F52:P52)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FL1 - Advanced Women Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F32>0,LEFT(B53,3),\"\")","v":""},{"$f":"IF(AND(R53<>\"\",COUNTA(F53:P53)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FA1 - Advanced Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F33>0,LEFT(B54,3),\"\")","v":""},{"$f":"IF(AND(R54<>\"\",COUNTA(F54:P54)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FA2 - Intermediate Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F34>0,LEFT(B55,3),\"\")","v":""},{"$f":"IF(AND(R55<>\"\",COUNTA(F55:P55)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FA3 - Recreational Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F35>0,LEFT(B56,3),\"\")","v":""},{"$f":"IF(AND(R56<>\"\",COUNTA(F56:P56)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FA4 - Novice Women",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F36>0,LEFT(B57,3),\"\")","v":""},{"$f":"IF(AND(R57<>\"\",COUNTA(F57:P57)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Course Layout Code",null,null,null,null,null,null,null,"Div"]
[null,"Divisions with players entered in your event",null,null,null,"R 1",null,"R 2",null,"R 3",null,"R 4",null,"R 4",null,"R 5",null,"Code"]
["JR","MJ1 - Junior Boys < 18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F39>0,LEFT(B60,3),\"\")","v":""},{"$f":"IF(AND(R60<>\"\",COUNTA(F60:P60)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MJ2 - Junior Boys < 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F40>0,LEFT(B61,3),\"\")","v":""},{"$f":"IF(AND(R61<>\"\",COUNTA(F61:P61)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MJ3 - Junior Boys < 12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F41>0,LEFT(B62,3),\"\")","v":""},{"$f":"IF(AND(R62<>\"\",COUNTA(F62:P62)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MJ4 - Junior Boys < 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F42>0,LEFT(B63,3),\"\")","v":""},{"$f":"IF(AND(R63<>\"\",COUNTA(F63:P63)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MJ5 - Junior Boys < 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F43>0,LEFT(B64,3),\"\")","v":""},{"$f":"IF(AND(R64<>\"\",COUNTA(F64:P64)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"MJ6 - Junior Boys < 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F44>0,LEFT(B65,3),\"\")","v":""},{"$f":"IF(AND(R65<>\"\",COUNTA(F65:P65)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FJ1 - Junior Girls < 18",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F45>0,LEFT(B66,3),\"\")","v":""},{"$f":"IF(AND(R66<>\"\",COUNTA(F66:P66)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"FJ2 - Junior Girls < 15",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F46>0,LEFT(B67,3),\"\")","v":""}]
[null,"FJ3 - Junior Girls < 12",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F47>0,LEFT(B68,3),\"\")","v":""}]
[null,"FJ4 - Junior Girls < 10",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F48>0,LEFT(B69,3),\"\")","v":""}]
[null,"FJ5 - Junior Girls < 8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F49>0,LEFT(B70,3),\"\")","v":""}]
[null,"FJ6 - Junior Girls < 6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!F50>0,LEFT(B71,3),\"\")","v":""},{"$f":"IF(AND(R71<>\"\",COUNTA(F71:P71)<COUNT(Scores!F$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
["3.","Notes to Player Scores  - Important!"]
[null,"List any clarifications such as: Ams who played Pro and declined $, tiebreakers/playoff winners, extra skins $ won by top pros, DNFs, etc."]
[]
[]
[]
[]
["4.","Holes in One"]
[null,"For each tournament ace, please provide the player's name, course layout code (from section 1 above), hole number and distance:"]
[null,"Player Name",null,null,"Layout Code",null,"Hole #  ",null,null,"Length"]
[]
[]
[]
[]
[]
["5.","Conditions"]
[null,"Describe any extraordinary weather or other unusual conditions that may have affected scoring, and indicate which rounds were affected."]
[]
[]
[]
[]
["6.","Problems"]
[null,"Please describe in detail any problems or disqualifications."]
[]
[]
[]
[]
["7.","Comments to the PDGA"]
[null,"Please provide us with your comments about how the PDGA Tour is working and any suggestions for its improvement."]
[null,"Are there any other specific ways in which the PDGA can help you, your club, and your event ?"]
[]
[]
[]
[]
["8.","TD Signature"]
[null,"I hereby certify that the information I have provided in this report is accurate to the best of my ability and knowledge."]
[]
[]
[null,"Tournament Director",null,null,null,null,null,null,null,null,null,"Date",null,"Date"]
[]
[null,"Once you have completed the Tour Event Report please return it as an email attachment:"]
[null,"- To the PDGA Office at tdreport@pdga.com "]
[null,"- For all EuroTour Series events, please copy to the EuroTour Manager at: hans@pdga-europe.com"]
[null,"  and to the PDGA International Director at bhoeniger@pdga.com "]
[]
[null,"Please note, all TD reports and fees are due no more than one month after an event. "]
[]
[null,"Questions? Contact the PDGA International Director at bhoeniger@pdga.com "]
[null,"Thanks for a job well done!"]

{"sheet":"Scores","index":3,"n_rows":225,"n_cols":25,"rows_kept":225,"cut":false,"hidden":false,"merged":[[42,15,42,17],[42,18,42,20],[43,18,43,20],[39,15,39,17],[40,15,40,17],[41,15,41,17],[39,18,39,20],[40,18,40,20],[41,18,41,20],[0,3,0,8],[0,12,0,13],[37,15,38,17],[37,18,37,20],[2,15,5,25],[0,15,0,21],[6,15,6,25],[38,18,38,20]]}
["Tour Event Name:",null,null,{"$f":"IF(Cover!L2<>\"\",Cover!L2,\"\")","v":""},null,null,null,null,null,null,null,"Dates:",{"$f":"IF(Cover!P4<>\"\",Cover!P4,\"\")","v":""},null,null,"NOTE ON DNF (Did Not Finish) CODES"]
[]
["Please enter the player Division Codes, Names and PDGA#s on this page before",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter 888 when a player has not notified the TD they will not be playing the next scheduled round. Enter 888 when a player has been confirmed to have manipulated their score or dropped out to preserve their rating. For all other cases where a player was not able to finish the round, enter 999."]
["completing the COVER page and using the PAYOUT worksheets. Do not include"]
["players who registered but did not show up or make a throw in the tournament.",null,null,null,null,null,null,null,null,null,null,null,null," Use Special Sort button above when"]
["Click button to upload scores",null,null,null,null,null,null,"Use Basic Sort button after any  >",null,null,null,null,null,"your Event has Semis or Finals."]
[null,null,null,null,null,null,null,"round through first 4 rounds.    ",null,null,null,null,null,"You MUST enter Final rankings in Place",null,"Guide to Division Codes: Enter players using the following 3 digit codes in the DivCode field."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"column for players in Semis/Finals.",null,"PROFESSIONAL DIVISIONS",null,null,null,"AMATEUR DIVISIONS",null,null,null,"JUNIOR DIVISIONS"]
["DivCode","Place","First Name","Last Name","PDGA","Rd1","Rd2","Rd3","Rd4","Semi","Final","TOTAL","Cash/Local","Cash/Value",null,"MPO","Pro Open",null,null,"MA1","Advanced",null,null,"MJ1","Junior Boys < 19"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F10=\"\",\"\",IF(SUM(F10:K10)>=888,\"DNF\",SUM(F10:K10)))","v":""},null,{"$f":"IF(M10=\"\",\"\",M10*Cover!M$11)","v":""},null,"MPM","Pro Master",null,null,"MA2","Intermediate",null,null,"MJ2","Junior Boys < 16"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M11=\"\",\"\",M11*Cover!M$11)","v":""},null,"MPG","Pro Grandmaster",null,null,"MA3","Recreational",null,null,"MJ3","Junior Boys < 13"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M12=\"\",\"\",M12*Cover!M$11)","v":""},null,"MPS","Pro Sr Grandmaster",null,null,"MA4","Novice",null,null,"MJ4","Junior Boys < 10"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M13=\"\",\"\",M13*Cover!M$11)","v":""},null,"MPL","Pro Legend",null,null,"FA1","Advanced Women",null,null,"FJ1","Junior Girls < 19"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M14=\"\",\"\",M14*Cover!M$11)","v":""},null,"MPE","Pro Sr Legend 75+",null,null,"FA2","Intermediate Women",null,null,"FJ2","Junior Girls < 16"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M15=\"\",\"\",M15*Cover!M$11)","v":""},null,"MPR","Pro Grand Legend 80+",null,null,"FA3","Recreational Women",null,null,"FJ3","Junior Girls < 13"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M16=\"\",\"\",M16*Cover!M$11)","v":""},null,"FPO","Pro Women",null,null,"FA4","Novice Women",null,null,"FJ4","Junior Girls < 10"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M17=\"\",\"\",M17*Cover!M$11)","v":""},null,"FPM","Pro Master Women",null,null,"MM1","Advanced Master",null,null,"FM1","Adv Master Women"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M18=\"\",\"\",M18*Cover!M$11)","v":""},null,"FPG","Pro Grandmaster Women",null,null,"MG1","Adv Grandmaster",null,null,"FG1","Adv GM Women"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M19=\"\",\"\",M19*Cover!M$11)","v":""},null,"FPS","Pro Sr Grandmaster Women",null,null,"MS1","Adv Sr Grandmaster",null,null,"FS1","Adv Sr GM Women"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M20=\"\",\"\",M20*Cover!M$11)","v":""},null,"FPL","Pro Legend Women",null,null,"ML1","Adv Legend",null,null,"FL1","Adv Legend Women"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M21=\"\",\"\",M21*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M22=\"\",\"\",M22*Cover!M$11)","v":""},null,"Instructions:"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M23=\"\",\"\",M23*Cover!M$11)","v":""},null," - How to avoid common mistakes, and ensure your event results are as correct as possible"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M24=\"\",\"\",M24*Cover!M$11)","v":""},null," - Please enter players and scores as follows:"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M25=\"\",\"\",M25*Cover!M$11)","v":""},null," - Enter players names in Proper Case = John Smith (Do NOT type in players as john smith or JOHN SMITH"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M26=\"\",\"\",M26*Cover!M$11)","v":""},null,"       or John SMITH, because the PDGA database cannot process official results in these formats)"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M27=\"\",\"\",M27*Cover!M$11)","v":""},null," - Make sure the players are sorted by division and score and that places of finish reflect their place within "]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M28=\"\",\"\",M28*Cover!M$11)","v":""},null,"       their division only (and not their place within the overall event which some countries like to do)"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M29=\"\",\"\",M29*Cover!M$11)","v":""},null," - Do not leave a blank line between one division and the next division."]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M30=\"\",\"\",M30*Cover!M$11)","v":""},null," - If your event included Semi and/or Final Rounds, enter those Scores in columns J & K."]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M31=\"\",\"\",M31*Cover!M$11)","v":""},null," - TOTAL column L adds up round scores automatically"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M32=\"\",\"\",M32*Cover!M$11)","v":""},null," - Be sure to include the amounts of pro cash won by the players in local currency in the Cash/Local column "]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M33=\"\",\"\",M33*Cover!M$11)","v":""},null,"       if your event had a Pro cash payout. "]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M34=\"\",\"\",M34*Cover!M$11)","v":""},null," - DO NOT include prize values in Cash/Local column for Ams who played Pro and declined cash, but DO add that"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M35=\"\",\"\",M35*Cover!M$11)","v":""},null,"       value in cell M23 on the Cover page so your event gets credit for total value paid out in Pro divisions."]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M36=\"\",\"\",M36*Cover!M$11)","v":""},null," - List players declining cash and those values in the Notes to Players Scores on the Event Info worksheet."]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M37=\"\",\"\",M37*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M38=\"\",\"\",M38*Cover!M$11)","v":""},null,"NOTES",null,null,"Type only in white"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M39=\"\",\"\",M39*Cover!M$11)","v":""},null,null,null,null,"or yellow boxes"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M40=\"\",\"\",M40*Cover!M$11)","v":""},null,"Do not insert or",null,null,"DO NOT TYPE IN"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M41=\"\",\"\",M41*Cover!M$11)","v":""},null,"delete rows. All ",null,null,"BLUE OR"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M42=\"\",\"\",M42*Cover!M$11)","v":""},null,"cells positioned",null,null,"GREEN BOXES!"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M43=\"\",\"\",M43*Cover!M$11)","v":""},null,"for data importing",null,null,"These all use"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M44=\"\",\"\",M44*Cover!M$11)","v":""},null,null,null,null,"automatic entries"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M45=\"\",\"\",M45*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M46=\"\",\"\",M46*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M47=\"\",\"\",M47*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M48=\"\",\"\",M48*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M49=\"\",\"\",M49*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M50=\"\",\"\",M50*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M51=\"\",\"\",M51*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M52=\"\",\"\",M52*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M53=\"\",\"\",M53*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M54=\"\",\"\",M54*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M55=\"\",\"\",M55*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M56=\"\",\"\",M56*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M57=\"\",\"\",M57*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M58=\"\",\"\",M58*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M59=\"\",\"\",M59*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M60=\"\",\"\",M60*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M61=\"\",\"\",M61*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M62=\"\",\"\",M62*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M63=\"\",\"\",M63*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M64=\"\",\"\",M64*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M65=\"\",\"\",M65*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M66=\"\",\"\",M66*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M67=\"\",\"\",M67*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M68=\"\",\"\",M68*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M69=\"\",\"\",M69*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M70=\"\",\"\",M70*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M71=\"\",\"\",M71*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M72=\"\",\"\",M72*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M73=\"\",\"\",M73*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F74=\"\",\"\",IF(SUM(F74:K74)>=888,\"DNF\",SUM(F74:K74)))","v":""},null,{"$f":"IF(M74=\"\",\"\",M74*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M75=\"\",\"\",M75*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M76=\"\",\"\",M76*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M77=\"\",\"\",M77*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M78=\"\",\"\",M78*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M79=\"\",\"\",M79*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M80=\"\",\"\",M80*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M81=\"\",\"\",M81*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M82=\"\",\"\",M82*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M83=\"\",\"\",M83*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M84=\"\",\"\",M84*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M85=\"\",\"\",M85*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M86=\"\",\"\",M86*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M87=\"\",\"\",M87*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M88=\"\",\"\",M88*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M89=\"\",\"\",M89*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M90=\"\",\"\",M90*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M91=\"\",\"\",M91*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M92=\"\",\"\",M92*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M93=\"\",\"\",M93*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M94=\"\",\"\",M94*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M95=\"\",\"\",M95*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M96=\"\",\"\",M96*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M97=\"\",\"\",M97*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M98=\"\",\"\",M98*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M99=\"\",\"\",M99*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M100=\"\",\"\",M100*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M101=\"\",\"\",M101*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M102=\"\",\"\",M102*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M103=\"\",\"\",M103*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M104=\"\",\"\",M104*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M105=\"\",\"\",M105*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M106=\"\",\"\",M106*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M107=\"\",\"\",M107*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M108=\"\",\"\",M108*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M109=\"\",\"\",M109*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M110=\"\",\"\",M110*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M111=\"\",\"\",M111*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M112=\"\",\"\",M112*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M113=\"\",\"\",M113*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M114=\"\",\"\",M114*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M115=\"\",\"\",M115*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M116=\"\",\"\",M116*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M117=\"\",\"\",M117*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M118=\"\",\"\",M118*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M119=\"\",\"\",M119*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M120=\"\",\"\",M120*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M121=\"\",\"\",M121*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M122=\"\",\"\",M122*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M123=\"\",\"\",M123*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M124=\"\",\"\",M124*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M125=\"\",\"\",M125*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M126=\"\",\"\",M126*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M127=\"\",\"\",M127*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M128=\"\",\"\",M128*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M129=\"\",\"\",M129*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M130=\"\",\"\",M130*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M131=\"\",\"\",M131*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M132=\"\",\"\",M132*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M133=\"\",\"\",M133*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M134=\"\",\"\",M134*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M135=\"\",\"\",M135*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M136=\"\",\"\",M136*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M137=\"\",\"\",M137*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F138=\"\",\"\",IF(SUM(F138:K138)>=888,\"DNF\",SUM(F138:K138)))","v":""},null,{"$f":"IF(M138=\"\",\"\",M138*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M139=\"\",\"\",M139*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M140=\"\",\"\",M140*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M141=\"\",\"\",M141*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M142=\"\",\"\",M142*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M143=\"\",\"\",M143*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M144=\"\",\"\",M144*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M145=\"\",\"\",M145*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M146=\"\",\"\",M146*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M147=\"\",\"\",M147*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M148=\"\",\"\",M148*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M149=\"\",\"\",M149*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M150=\"\",\"\",M150*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M151=\"\",\"\",M151*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M152=\"\",\"\",M152*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M153=\"\",\"\",M153*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M154=\"\",\"\",M154*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M155=\"\",\"\",M155*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M156=\"\",\"\",M156*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M157=\"\",\"\",M157*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M158=\"\",\"\",M158*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M159=\"\",\"\",M159*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M160=\"\",\"\",M160*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M161=\"\",\"\",M161*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M162=\"\",\"\",M162*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M163=\"\",\"\",M163*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M164=\"\",\"\",M164*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M165=\"\",\"\",M165*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M166=\"\",\"\",M166*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M167=\"\",\"\",M167*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M168=\"\",\"\",M168*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M169=\"\",\"\",M169*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M170=\"\",\"\",M170*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M171=\"\",\"\",M171*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M172=\"\",\"\",M172*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M173=\"\",\"\",M173*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M174=\"\",\"\",M174*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M175=\"\",\"\",M175*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M176=\"\",\"\",M176*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M177=\"\",\"\",M177*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M178=\"\",\"\",M178*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M179=\"\",\"\",M179*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M180=\"\",\"\",M180*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M181=\"\",\"\",M181*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M182=\"\",\"\",M182*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M183=\"\",\"\",M183*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M184=\"\",\"\",M184*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M185=\"\",\"\",M185*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M186=\"\",\"\",M186*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M187=\"\",\"\",M187*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M188=\"\",\"\",M188*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M189=\"\",\"\",M189*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M190=\"\",\"\",M190*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M191=\"\",\"\",M191*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M192=\"\",\"\",M192*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M193=\"\",\"\",M193*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M194=\"\",\"\",M194*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M195=\"\",\"\",M195*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M196=\"\",\"\",M196*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M197=\"\",\"\",M197*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M198=\"\",\"\",M198*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M199=\"\",\"\",M199*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M200=\"\",\"\",M200*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M201=\"\",\"\",M201*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F202=\"\",\"\",IF(SUM(F202:K202)>=888,\"DNF\",SUM(F202:K202)))","v":""},null,{"$f":"IF(M202=\"\",\"\",M202*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M203=\"\",\"\",M203*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M204=\"\",\"\",M204*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M205=\"\",\"\",M205*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M206=\"\",\"\",M206*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M207=\"\",\"\",M207*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M208=\"\",\"\",M208*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M209=\"\",\"\",M209*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M210=\"\",\"\",M210*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M211=\"\",\"\",M211*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M212=\"\",\"\",M212*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M213=\"\",\"\",M213*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M214=\"\",\"\",M214*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M215=\"\",\"\",M215*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M216=\"\",\"\",M216*Cover!M$11)","v":""}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F219=\"\",\"\",IF(SUM(F219:K219)>=888,\"DNF\",SUM(F219:K219)))","v":""},null,{"$f":"IF(M219=\"\",\"\",M219*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M220=\"\",\"\",M220*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M221=\"\",\"\",M221*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M222=\"\",\"\",M222*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M223=\"\",\"\",M223*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M224=\"\",\"\",M224*Cover!M$11)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"",null,{"$f":"IF(M225=\"\",\"\",M225*Cover!M$11)","v":""}]

{"sheet":"Pro.Payouts","index":4,"n_rows":84,"n_cols":62,"rows_kept":84,"cut":false,"hidden":false,"merged":[[20,7,20,12],[30,14,30,19],[51,14,51,19],[20,14,20,19],[73,14,73,19],[73,0,73,5],[73,7,73,12],[0,0,0,5],[0,7,0,12],[0,14,0,19],[30,0,30,5],[30,7,30,12]]}
["WOMEN PRO DIVISION",null,null,null,null,null,null,"WOMEN MASTER PRO DIVISION",null,null,null,null,null,null,"WOMEN GM PRO DIVISION",null,null,null,null,null,null,"Field"]
[null,null,null,null,"Add (or reduce) local cash here* > ",null,null,null,null,null,null,"Add (or reduce) local cash here* > ",null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,40,33,25,20,15,null,"1-2","3-4","5-6","7-9","10-13","14-16","17-19","20-22","23-26","27-29","30-31"]
["# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G14","v":0},null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G15","v":0},null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G16","v":0},null,1,1,1,1,1,1,null,"Number of Places Paid"]
[{"$f":"VLOOKUP(C4,paypct,B5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F14=0,91,Cover!F14)","v":91},null,"Net Purse: ",{"$f":"F3+F2","v":0},null,{"$f":"VLOOKUP(J4,paypct,I5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F15=0,91,Cover!F15)","v":91},null,"Net Purse: ",{"$f":"M3+M2","v":0},null,{"$f":"VLOOKUP(Q4,paypct,P5,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F16=0,91,Cover!F16)","v":91},null,"Net Purse: ",{"$f":"T3+T2","v":0},null,2,1,1,1,1,1,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33]
[null,{"$f":"IF(E5=33%,3,IF(E5=40%,2,IF(E5=25%,4,IF(E5=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(L5=33%,3,IF(L5=40%,2,IF(L5=25%,4,IF(L5=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(S5=33%,3,IF(S5=40%,2,IF(S5=25%,4,IF(S5=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,3,2,1,1,1,1,1,1,0.625,0.47499999999999998,0.41,0.36,0.33,0.3,0.28000000000000003,0.26800000000000002,0.26,0.25,0.23799999999999999,0.23200000000000001,0.22500000000000001,0.22,0.21,0.2,0.19,0.18,0.16500000000000001,0.152,0.14499999999999999,0.14199999999999999,0.14000000000000001,0.13700000000000001,0.13200000000000001,0.13,0.127,0.125,0.122,0.11799999999999999,0.115,0.112,1]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,4,2,2,1,1,1,2,"·········",0.375,0.3,0.26,0.245,0.23,0.21,0.19,0.185,0.18,0.16500000000000001,0.16,0.155,0.15,0.14499999999999999,0.14000000000000001,0.13500000000000001,0.13,0.125,0.11799999999999999,0.115,0.112,0.11,0.107,0.105,0.1,9.8000000000000004E-2,9.5000000000000001E-2,9.2999999999999999E-2,0.09,8.6999999999999994E-2,8.5000000000000006E-2,8.2000000000000003E-2,2]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,5,2,2,2,1,1,3,"3rd","·········",0.22500000000000001,0.19,0.17,0.155,0.15,0.14499999999999999,0.14000000000000001,0.13,0.127,0.12,0.115,0.11,0.105,0.1,9.7000000000000003E-2,9.5000000000000001E-2,9.1999999999999998E-2,8.8999999999999996E-2,8.6999999999999994E-2,8.5000000000000006E-2,8.4000000000000005E-2,8.2000000000000003E-2,7.8E-2,7.5999999999999998E-2,7.4999999999999997E-2,7.2999999999999995E-2,7.0999999999999994E-2,6.8000000000000005E-2,6.5000000000000002E-2,6.3E-2,5.8000000000000003E-2,3]
[{"$f":"IF(ROW()-7>$A$4,\"\",ROW()-7)","v":{"$error":"#N/A"}},{"$f":"IF(A8=\"\",\"\",VLOOKUP(A8,_pay1,$A$4+1))","v":{"$error":"#N/A"}},{"$f":"IF(B8=\"\",\"\",$F$4*B8)","v":{"$error":"#N/A"}},{"$f":"IF(C8=\"\",\"\",INT((C8+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-7>$H$4,\"\",ROW()-7)","v":{"$error":"#N/A"}},{"$f":"IF(H8=\"\",\"\",VLOOKUP(H8,_pay1,$H$4+1))","v":{"$error":"#N/A"}},{"$f":"IF(I8=\"\",\"\",$M$4*I8)","v":{"$error":"#N/A"}},{"$f":"IF(J8=\"\",\"\",INT((J8+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-7>$O$4,\"\",ROW()-7)","v":{"$error":"#N/A"}},{"$f":"IF(O8=\"\",\"\",VLOOKUP(O8,_pay1,$O$4+1))","v":{"$error":"#N/A"}},{"$f":"IF(P8=\"\",\"\",$T$4*P8)","v":{"$error":"#N/A"}},{"$f":"IF(Q8=\"\",\"\",INT((Q8+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,6,3,2,2,2,1,4,null,"4th","·········",0.14000000000000001,0.125,0.12,0.11,0.115,0.11,0.1,9.8000000000000004E-2,9.5000000000000001E-2,0.09,8.5000000000000006E-2,8.4000000000000005E-2,8.3000000000000004E-2,8.1000000000000003E-2,0.08,7.8E-2,7.5999999999999998E-2,7.4999999999999997E-2,7.1999999999999995E-2,7.0999999999999994E-2,6.6000000000000003E-2,6.5000000000000002E-2,6.4000000000000001E-2,6.3E-2,6.0999999999999999E-2,5.8999999999999997E-2,5.6000000000000001E-2,5.5E-2,5.2999999999999999E-2,5.1999999999999998E-2,4]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,7,3,3,2,2,2,5,"P",null,"5th","·········",0.1,9.5000000000000001E-2,9.5000000000000001E-2,0.09,8.5000000000000006E-2,8.1000000000000003E-2,0.08,7.6999999999999999E-2,7.4999999999999997E-2,7.0999999999999994E-2,6.9000000000000006E-2,6.8000000000000005E-2,6.7000000000000004E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.4000000000000001E-2,6.3E-2,6.0999999999999999E-2,0.06,5.7000000000000002E-2,5.6000000000000001E-2,5.5E-2,5.3999999999999999E-2,5.1999999999999998E-2,0.05,4.9000000000000002E-2,4.8000000000000001E-2,4.8000000000000001E-2,4.8000000000000001E-2,5]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,8,4,3,2,2,2,6,null,"L",null,"6th","·········",7.0000000000000007E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.7000000000000004E-2,6.7000000000000004E-2,6.5000000000000002E-2,6.4000000000000001E-2,6.0999999999999999E-2,0.06,5.8000000000000003E-2,5.7000000000000002E-2,5.6000000000000001E-2,5.5E-2,5.5E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.2999999999999999E-2,5.1999999999999998E-2,5.0999999999999997E-2,4.9000000000000002E-2,4.8000000000000001E-2,4.7E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,6]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,9,4,3,3,2,2,7,null,null,"A",null,"7th","·········",0.06,0.06,5.5E-2,5.5E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.1999999999999998E-2,5.1999999999999998E-2,0.05,0.05,0.05,0.05,0.05,4.9000000000000002E-2,4.9000000000000002E-2,4.8000000000000001E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.2999999999999997E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,7]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,10,4,4,3,2,2,8,null,null,null,"C",null,"8th","·········",0.05,4.7E-2,4.7E-2,4.7E-2,4.7E-2,4.5999999999999999E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.1000000000000002E-2,4.1000000000000002E-2,0.04,0.04,0.04,0.04,0.04,3.9E-2,3.9E-2,8]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,11,5,4,3,3,2,9,null,null,null,null,"E",null,"9th","·········",4.2999999999999997E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,3.9E-2,3.9E-2,3.7999999999999999E-2,3.7999999999999999E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.5999999999999997E-2,3.5999999999999997E-2,9]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,12,5,4,3,3,2,10,null,null,null,null,null,null,null,"10th","·········",3.7999999999999999E-2,3.7999999999999999E-2,3.7999999999999999E-2,3.7999999999999999E-2,3.7999999999999999E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.5999999999999997E-2,3.5999999999999997E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,13,6,5,4,3,2,11,null,null,null,null,null,null,"O",null,"11th","·········",3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.3000000000000002E-2,3.3000000000000002E-2,3.3000000000000002E-2,3.3000000000000002E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-2,11]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,14,6,5,4,3,3,12,null,null,null,null,null,null,null,"F",null,"12th","·········",3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,3.1E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,12]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,15,6,5,4,3,3,13,null,null,null,null,null,null,null,null,null,null,"13th","·········",2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,13]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,16,7,6,4,4,3,14,null,null,null,null,null,null,null,null,null,"F",null,"14th","·········",2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,14]
[null,{"$f":"SUM(B8:B18)","v":{"$error":"#N/A"}},{"$f":"SUM(C8:C18)","v":{"$error":"#N/A"}},{"$f":"SUM(D8:D18)","v":{"$error":"#N/A"}},{"$f":"SUM(E8:E18)","v":0},null,null,null,{"$f":"SUM(I8:I18)","v":{"$error":"#N/A"}},{"$f":"SUM(J8:J18)","v":{"$error":"#N/A"}},{"$f":"SUM(K8:K18)","v":{"$error":"#N/A"}},{"$f":"SUM(L8:L18)","v":0},null,null,null,{"$f":"SUM(P8:P18)","v":{"$error":"#N/A"}},{"$f":"SUM(Q8:Q18)","v":{"$error":"#N/A"}},{"$f":"SUM(R8:R18)","v":{"$error":"#N/A"}},{"$f":"SUM(S8:S18)","v":0},null,null,17,7,6,5,4,3,15,null,null,null,null,null,null,null,null,null,null,"I",null,"15th","·········",2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,15]
[null,null,null,{"$f":"IF(C4=91,\"       To use this table, enter player divisions on Scores page\",IF(C4>27,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J4=91,\"       To use this table, enter player divisions on Scores page\",IF(J4>27,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q4=91,\"       To use this table, enter player divisions on Scores page\",IF(Q4>27,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,18,8,6,5,4,3,16,null,null,null,null,null,null,null,null,null,null,null,"N",null,"16th","·········",2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,16]
[null,null,null,null,null,null,null,"WOMEN LEGEND DIVISION",null,null,null,null,null,null,"WOMEN SGM PRO DIVISION",null,null,null,null,null,null,19,8,7,5,4,3,17,null,null,null,null,null,null,null,null,null,null,null,null,"I",null,"17th","·········",2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,17]
[null,null,null,null,null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,20,8,7,5,4,3,18,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",null,"18th","·········",2.1000000000000001E-2,2.1000000000000001E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,18]
[null,null,null,null,null,null,null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G18","v":0},null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G17","v":0},null,21,9,7,6,5,4,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"H",null,"19th","·········",0.02,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,19]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(J24,paypct,I25,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F18=0,91,Cover!F18)","v":91},null,"Net Purse: ",{"$f":"M23+M22","v":0},null,{"$f":"VLOOKUP(Q24,paypct,P25,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F17=0,91,Cover!F17)","v":91},null,"Net Purse: ",{"$f":"T23+T22","v":0},null,22,9,8,6,5,4,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20th","·········",2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,20]
[null,null,null,null,null,null,null,null,{"$f":"IF(L25=33%,3,IF(L25=40%,2,IF(L25=25%,4,IF(L25=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(S25=33%,3,IF(S25=40%,2,IF(S25=25%,4,IF(S25=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,23,10,8,6,5,4,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21st","·········",0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,21]
[null,null,null,null,null,null,null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,24,10,8,6,5,4,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22nd","·········",1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,1.9E-2,22]
[null,null,null,null,null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,25,10,9,7,5,4,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23rd","·········",1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7999999999999999E-2,1.7000000000000001E-2,1.7000000000000001E-2,23]
[null,null,null,null,null,null,null,{"$f":"IF(ROW()-27>$H$24,\"\",ROW()-27)","v":{"$error":"#N/A"}},{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,_pay1,$H$24+1))","v":{"$error":"#N/A"}},{"$f":"IF(I28=\"\",\"\",$M$24*I28)","v":{"$error":"#N/A"}},{"$f":"IF(J28=\"\",\"\",INT((J28+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-27>$O$24,\"\",ROW()-27)","v":{"$error":"#N/A"}},{"$f":"IF(O28=\"\",\"\",VLOOKUP(O28,_pay1,$O$24+1))","v":{"$error":"#N/A"}},{"$f":"IF(P28=\"\",\"\",$T$24*P28)","v":{"$error":"#N/A"}},{"$f":"IF(Q28=\"\",\"\",INT((Q28+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,26,11,9,7,6,4,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24th","·········",1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2,24]
[null,null,null,null,null,null,null,{"$f":"IF(ROW()-27>$H$24,\"\",ROW()-27)","v":{"$error":"#N/A"}},{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,_pay1,$H$24+1))","v":{"$error":"#N/A"}},{"$f":"IF(I29=\"\",\"\",$M$24*I29)","v":{"$error":"#N/A"}},{"$f":"IF(J29=\"\",\"\",INT((J29+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-27>$O$24,\"\",ROW()-27)","v":{"$error":"#N/A"}},{"$f":"IF(O29=\"\",\"\",VLOOKUP(O29,_pay1,$O$24+1))","v":{"$error":"#N/A"}},{"$f":"IF(P29=\"\",\"\",$T$24*P29)","v":{"$error":"#N/A"}},{"$f":"IF(Q29=\"\",\"\",INT((Q29+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,27,11,9,7,6,5,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25th","·········",1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,1.6E-2,25]
[null,null,null,{"$f":"IF(C34=91,\"       To use this table, enter player divisions on Scores page\",IF(C34>83,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,{"$f":"SUM(J28:J29)","v":{"$error":"#N/A"}},{"$f":"SUM(K28:K29)","v":{"$error":"#N/A"}},{"$f":"SUM(L28:L29)","v":0},null,null,null,{"$f":"SUM(P28:P29)","v":{"$error":"#N/A"}},{"$f":"SUM(Q28:Q29)","v":{"$error":"#N/A"}},{"$f":"SUM(R28:R29)","v":{"$error":"#N/A"}},{"$f":"SUM(S28:S29)","v":0},null,null,28,12,10,7,6,5,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"26th","·········",1.6E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,26]
["OPEN PRO DIVISION",null,null,null,null,null,null,"MASTER PRO DIVISION",null,null,null,null,null,null,"GRANDMASTER PRO DIVISION",null,null,null,null,null,null,29,12,10,8,6,5,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27th","·········",1.4999999999999999E-2,1.4999999999999999E-2,1.4E-2,1.4E-2,1.4E-2,1.4E-2,1.4E-2,27]
[null,null,null,null,"Add (or reduce) local cash here* > ",null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,30,12,10,8,6,5,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28th","·········",1.4E-2,1.4E-2,1.4E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,28]
["# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G7","v":0},null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G8","v":0},null,"# Paid",null,"Field Size","s","Total Fees: ",{"$f":"Cover!G9","v":0},null,31,13,11,8,7,5,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29th","·········",1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,29]
[{"$f":"VLOOKUP(C34,paypct,B35,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F7=0,91,Cover!F7)","v":91},null,"Net Purse: ",{"$f":"F33+F32","v":0},null,{"$f":"VLOOKUP(J34,paypct,I35,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F8=0,91,Cover!F8)","v":91},null,"Net Purse: ",{"$f":"M33+M32","v":0},null,{"$f":"VLOOKUP(Q34,paypct,P35,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F9=0,91,Cover!F9)","v":91},null,"Net Purse: ",{"$f":"T33+T32","v":0},null,32,13,11,8,7,5,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"30th","·········",1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,30]
[null,{"$f":"IF(E35=33%,3,IF(E35=40%,2,IF(E35=25%,4,IF(E35=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(L35=33%,3,IF(L35=40%,2,IF(L35=25%,4,IF(L35=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(S35=33%,3,IF(S35=40%,2,IF(S35=25%,4,IF(S35=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,33,14,11,9,7,5,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"31st","·········",1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,31]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,34,14,12,9,7,6,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"32nd","·········",1.2E-2,1.2E-2,32]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,35,14,12,9,7,6,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"33rd","·········",1.2E-2,33]
[{"$f":"IF(ROW()-37>$A$34,\"\",ROW()-37)","v":{"$error":"#N/A"}},{"$f":"IF(A38=\"\",\"\",VLOOKUP(A38,_pay1,$A$34+1))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",\"\",$F$34*B38)","v":{"$error":"#N/A"}},{"$f":"IF(C38=\"\",\"\",INT((C38+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-37>$H$34,\"\",ROW()-37)","v":{"$error":"#N/A"}},{"$f":"IF(H38=\"\",\"\",VLOOKUP(H38,_pay1,$H$34+1))","v":{"$error":"#N/A"}},{"$f":"IF(I38=\"\",\"\",$M$34*I38)","v":{"$error":"#N/A"}},{"$f":"IF(J38=\"\",\"\",INT((J38+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-37>$O$34,\"\",ROW()-37)","v":{"$error":"#N/A"}},{"$f":"IF(O38=\"\",\"\",VLOOKUP(O38,_pay1,$O$34+1))","v":{"$error":"#N/A"}},{"$f":"IF(P38=\"\",\"\",$T$34*P38)","v":{"$error":"#N/A"}},{"$f":"IF(Q38=\"\",\"\",INT((Q38+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,36,15,12,9,8,6,null,{"$f":"SUM(AD39:AD$42)","v":0.157},0.05,0.05,3.1406662176814468E-2,{"$f":"SUM(AF$32:AF38)","v":3.1406662176814468E-2}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,37,15,13,10,8,6,null,{"$f":"SUM(AD40:AD$42)","v":0.112},4.4999999999999998E-2,4.4999999999999998E-2,2.8489685942771143E-2,{"$f":"SUM(AF$32:AF39)","v":5.9896348119585607E-2}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,38,16,13,10,8,6,null,{"$f":"SUM(AD41:AD$42)","v":7.1000000000000008E-2},4.1000000000000002E-2,4.1000000000000002E-2,2.6142452068019472E-2,{"$f":"SUM(AF$32:AF40)","v":8.6038800187605083E-2}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,39,16,13,10,8,6,null,{"$f":"SUM(AD42:AD$42)","v":3.4000000000000002E-2},3.6999999999999998E-2,3.6999999999999998E-2,2.4207132776617273E-2,{"$f":"SUM(AF$32:AF41)","v":0.11024593296422236}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,40,16,14,10,8,6,null,0,3.4000000000000002E-2,3.4000000000000002E-2,2.2580143216164743E-2,{"$f":"SUM(AF$32:AF42)","v":0.13282607618038711}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,41,17,14,11,9,7,null,null,{"$f":"SUM(AE44:AE$50)","v":0.16699999999999998},3.1E-2,2.1190492118674971E-2,{"$f":"SUM(AF$32:AF43)","v":0.15401656829906207}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,42,17,14,11,9,7,null,null,{"$f":"SUM(AE45:AE$50)","v":0.13800000000000001},2.9000000000000001E-2,1.9987786649760371E-2,{"$f":"SUM(AF$32:AF44)","v":0.17400435494882244}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,43,18,15,11,9,7,null,null,{"$f":"SUM(AE46:AE$50)","v":0.11100000000000002},2.7E-2,1.8935199547221115E-2,{"$f":"SUM(AF$32:AF45)","v":0.19293955449604355}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,44,18,15,11,9,7,null,null,{"$f":"SUM(AE47:AE$50)","v":8.6000000000000007E-2},2.5000000000000001E-2,1.8005149560056263E-2,{"$f":"SUM(AF$32:AF46)","v":0.21094470405609983}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,45,18,15,12,9,7,null,null,{"$f":"SUM(AE48:AE$50)","v":6.3E-2},2.3E-2,1.7176543159122433E-2,{"$f":"SUM(AF$32:AF47)","v":0.22812124721522226}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,46,19,16,12,10,7,null,null,{"$f":"SUM(AE49:AE$50)","v":4.1000000000000002E-2},2.1999999999999999E-2,1.6432954005664944E-2,{"$f":"SUM(AF$32:AF48)","v":0.2445542012208872}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,47,19,16,12,10,8,null,null,{"$f":"SUM(AE50:AE$50)","v":0.02},2.1000000000000001E-2,1.5761386669324196E-2,{"$f":"SUM(AF$32:AF49)","v":0.26031558789021136}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$f":"SUM(P38:P49)","v":{"$error":"#N/A"}},{"$f":"SUM(Q38:Q49)","v":{"$error":"#N/A"}},{"$f":"SUM(R38:R49)","v":{"$error":"#N/A"}},{"$f":"SUM(S38:S49)","v":0},null,null,48,20,16,12,10,8,null,null,0,0.02,1.515141604136006E-2,{"$f":"SUM(AF$32:AF50)","v":0.27546700393157142}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,{"$f":"IF(Q34=91,\"       To use this table, enter player divisions on Scores page\",IF(Q34>31,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,49,20,17,13,10,8,null,null,null,null,1.4594575093997345E-2,{"$f":"SUM(AF$32:AF51)","v":0.29006157902556878}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"SENIOR GM PRO DIVISION",null,null,null,null,null,null,50,20,17,13,10,8,null,null,null,null,1.4083910843276161E-2,{"$f":"SUM(AF$32:AF52)","v":0.30414548986884493}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,51,21,17,13,11,8,null,null,null,null,1.3613656720214931E-2,{"$f":"SUM(AF$32:AF53)","v":0.31775914658905985}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G10","v":0},null,52,21,18,13,11,8,null,null,null,null,1.3178987073589138E-2,{"$f":"SUM(AF$32:AF54)","v":0.33093813366264901}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"VLOOKUP(Q55,paypct,P56,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F10=0,91,Cover!F10)","v":91},null,"Net Purse: ",{"$f":"T54+T53","v":0},null,53,22,18,14,11,8,null,null,null,null,1.277583063465882E-2,{"$f":"SUM(AF$32:AF55)","v":0.34371396429730783}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$f":"IF(S56=33%,3,IF(S56=40%,2,IF(S56=25%,4,IF(S56=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,54,22,18,14,11,9,null,null,null,null,1.2400726979875621E-2,{"$f":"SUM(AF$32:AF56)","v":0.35611469127718343}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,"Prelim","Proposed","Round to","Manual","Final",null,55,22,19,14,11,9,null,null,null,null,1.2050714800246966E-2,{"$f":"SUM(AF$32:AF57)","v":0.36816540607743037}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,56,23,19,14,12,9,null,null,null,null,1.1723244007203554E-2,{"$f":"SUM(AF$32:AF58)","v":0.37988865008463391}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$f":"IF(ROW()-58>$O$55,\"\",ROW()-58)","v":{"$error":"#N/A"}},{"$f":"IF(O59=\"\",\"\",VLOOKUP(O59,_pay1,$O$55+1))","v":{"$error":"#N/A"}},{"$f":"IF(P59=\"\",\"\",$T$55*P59)","v":{"$error":"#N/A"}},{"$f":"IF(Q59=\"\",\"\",INT((Q59+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,57,23,19,15,12,9,null,null,null,null,1.1416105916462881E-2,{"$f":"SUM(AF$32:AF59)","v":0.39130475600109677}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,58,24,20,15,12,9,null,null,null,null,1.1127377293923829E-2,{"$f":"SUM(AF$32:AF60)","v":0.40243213329502059}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,59,24,20,15,12,9,null,null,null,null,1.0855375139129349E-2,{"$f":"SUM(AF$32:AF61)","v":0.41328750843414996}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,60,24,20,15,12,9,null,null,null,null,1.0598619864527712E-2,{"$f":"SUM(AF$32:AF62)","v":0.42388612829867767}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,61,25,21,16,13,10,null,null,null,null,1.0355805096969007E-2,{"$f":"SUM(AF$32:AF63)","v":0.43424193339564665}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,62,25,21,16,13,10,null,null,null,null,1.0125772745110196E-2,{"$f":"SUM(AF$32:AF64)","v":0.44436770614075682}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,63,26,21,16,13,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$f":"SUM(P59:P65)","v":{"$error":"#N/A"}},{"$f":"SUM(Q59:Q65)","v":{"$error":"#N/A"}},{"$f":"SUM(R59:R65)","v":{"$error":"#N/A"}},{"$f":"SUM(S59:S65)","v":0},null,null,64,26,22,16,13,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,65,26,22,17,13,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,66,27,22,17,14,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,67,27,23,17,14,11]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,68,28,23,17,14,11]
[null,{"$f":"SUM(B38:B70)","v":{"$error":"#N/A"}},{"$f":"SUM(C38:C70)","v":{"$error":"#N/A"}},{"$f":"SUM(D38:D70)","v":{"$error":"#N/A"}},{"$f":"SUM(E38:E70)","v":0},null,null,null,{"$f":"SUM(I38:I70)","v":{"$error":"#N/A"}},{"$f":"SUM(J38:J70)","v":{"$error":"#N/A"}},{"$f":"SUM(K38:K70)","v":{"$error":"#N/A"}},{"$f":"SUM(L38:L70)","v":0},null,null,null,null,null,null,null,null,null,69,28,23,18,14,11]
["* Can be a negative number when expenses like trophies involved",null,null,null,null,null,null,null,null,null,{"$f":"IF(Q70=91,\"       To use this table, enter player divisions on Scores page >\",IF(Q70>4,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,70,28,24,18,14,11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,71,29,24,18,15,11]
["SENIOR LEGENDS DIVISION",null,null,null,null,null,null,"GRAND LEGENDS DIVISION",null,null,null,null,null,null,"LEGENDS DIVISION",null,null,null,null,null,null,72,29,24,18,15,11]
[null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,73,30,25,19,15,11]
["# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G12","v":0},null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G13","v":0},null,"# Paid",null,"Field Size",null,"Total Fees: ",{"$f":"Cover!G11","v":0},null,74,30,25,19,15,12]
[{"$f":"VLOOKUP(C77,paypct,B78,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F12=0,91,Cover!F12)","v":91},null,"Net Purse: ",{"$f":"F76+F75","v":0},null,{"$f":"VLOOKUP(J77,paypct,I78,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F13=0,91,Cover!F13)","v":91},null,"Net Purse: ",{"$f":"M76+M75","v":0},null,{"$f":"VLOOKUP(Q77,paypct,P78,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F11=0,91,Cover!F11)","v":91},null,"Net Purse: ",{"$f":"T76+T75","v":0},null,75,30,25,19,15,12]
[null,{"$f":"IF(E78=33%,3,IF(E78=40%,2,IF(E78=25%,4,IF(E78=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(L78=33%,3,IF(L78=40%,2,IF(L78=25%,4,IF(L78=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,null,{"$f":"IF(S78=33%,3,IF(S78=40%,2,IF(S78=25%,4,IF(S78=20%,5,6))))","v":4},null,"Choose Payout Percentage>",0.25,null,null,76,31,26,19,16,12]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,77,31,26,20,16,12]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,78,32,26,20,16,12]
[{"$f":"IF(ROW()-80>$A$77,\"\",ROW()-80)","v":{"$error":"#N/A"}},{"$f":"IF(A81=\"\",\"\",VLOOKUP(A81,_pay1,$A$77+1))","v":{"$error":"#N/A"}},{"$f":"IF(B81=\"\",\"\",$F$77*B81)","v":{"$error":"#N/A"}},{"$f":"IF(C81=\"\",\"\",INT((C81+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-80>$H$77,\"\",ROW()-80)","v":{"$error":"#N/A"}},{"$f":"IF(H81=\"\",\"\",VLOOKUP(H81,_pay1,$H$77+1))","v":{"$error":"#N/A"}},{"$f":"IF(I81=\"\",\"\",$M$77*I81)","v":{"$error":"#N/A"}},{"$f":"IF(J81=\"\",\"\",INT((J81+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-80>$O$77,\"\",ROW()-80)","v":{"$error":"#N/A"}},{"$f":"IF(O81=\"\",\"\",VLOOKUP(O81,_pay1,$O$77+1))","v":{"$error":"#N/A"}},{"$f":"IF(P81=\"\",\"\",$T$77*P81)","v":{"$error":"#N/A"}},{"$f":"IF(Q81=\"\",\"\",INT((Q81+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,79,32,27,20,16,12]
[{"$f":"IF(ROW()-80>$A$77,\"\",ROW()-80)","v":{"$error":"#N/A"}},{"$f":"IF(A82=\"\",\"\",VLOOKUP(A82,_pay1,$A$77+1))","v":{"$error":"#N/A"}},{"$f":"IF(B82=\"\",\"\",$F$77*B82)","v":{"$error":"#N/A"}},{"$f":"IF(C82=\"\",\"\",INT((C82+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-80>$H$77,\"\",ROW()-80)","v":{"$error":"#N/A"}},{"$f":"IF(H82=\"\",\"\",VLOOKUP(H82,_pay1,$H$77+1))","v":{"$error":"#N/A"}},{"$f":"IF(I82=\"\",\"\",$M$77*I82)","v":{"$error":"#N/A"}},{"$f":"IF(J82=\"\",\"\",INT((J82+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,{"$f":"IF(ROW()-80>$O$77,\"\",ROW()-80)","v":{"$error":"#N/A"}},{"$f":"IF(O82=\"\",\"\",VLOOKUP(O82,_pay1,$O$77+1))","v":{"$error":"#N/A"}},{"$f":"IF(P82=\"\",\"\",$T$77*P82)","v":{"$error":"#N/A"}},{"$f":"IF(Q82=\"\",\"\",INT((Q82+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,80,32,27,20,16,12]
[null,{"$f":"SUM(B81:B82)","v":{"$error":"#N/A"}},{"$f":"SUM(C81:C82)","v":{"$error":"#N/A"}},{"$f":"SUM(D81:D82)","v":{"$error":"#N/A"}},{"$f":"SUM(E81:E82)","v":0},null,null,null,{"$f":"SUM(I81:I82)","v":{"$error":"#N/A"}},{"$f":"SUM(J81:J82)","v":{"$error":"#N/A"}},{"$f":"SUM(K81:K82)","v":{"$error":"#N/A"}},{"$f":"SUM(L81:L82)","v":0},null,null,null,{"$f":"SUM(P81:P82)","v":{"$error":"#N/A"}},{"$f":"SUM(Q81:Q82)","v":{"$error":"#N/A"}},{"$f":"SUM(R81:R82)","v":{"$error":"#N/A"}},{"$f":"SUM(S81:S82)","v":0},null,null,81,33,27,21,17,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,33,28,21,17,13]

{"sheet":"Am.Jr.Payouts","index":5,"n_rows":198,"n_cols":67,"rows_kept":198,"cut":false,"hidden":false,"merged":[[167,0,167,5],[179,0,179,5],[179,7,179,12],[179,14,179,19],[108,7,108,12],[108,14,108,19],[128,0,128,5],[128,7,128,12],[128,14,128,19],[165,14,165,19],[148,0,148,5],[148,7,148,12],[148,14,148,19],[159,7,159,12],[56,7,56,12],[65,14,65,19],[69,7,69,12],[86,0,86,5],[86,7,86,12],[86,14,86,19],[0,0,0,5],[0,7,0,12],[0,14,0,19],[22,7,22,12],[22,14,22,19],[43,0,43,5],[43,7,43,12],[43,14,43,19]]}
["ADVANCED DIVISION",null,null,null,null,null,null,"ADVANCED MASTERS DIVISION",null,null,null,null,null,null,"ADVANCED WOMEN DIVISION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.33,null,null,0.45,null,0.25,null,0.2,null,0.15]
[null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",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,"Field","# paid",null,"Field","# paid","Field","# paid","Field","# paid","Field","# paid"]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G21","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G25","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G33","v":0}]
[{"$f":"IF(D4=45%,VLOOKUP(C4,dbd,2,FALSE),IF(D4=33%,VLOOKUP(C4,dbe,2,FALSE),IF(D4=25%,VLOOKUP(C4,dbf,2,FALSE),IF(D4=20%,VLOOKUP(C4,dbg,2,FALSE),VLOOKUP(C4,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F21=0,91,Cover!F21)","v":91},0.25,"Net Purse: ",{"$f":"F3+F2","v":0},null,{"$f":"IF(K4=45%,VLOOKUP(J4,dbd,2,FALSE),IF(K4=33%,VLOOKUP(J4,dbe,2,FALSE),IF(K4=25%,VLOOKUP(J4,dbf,2,FALSE),IF(K4=20%,VLOOKUP(J4,dbg,2,FALSE),VLOOKUP(J4,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F25=0,91,Cover!F25)","v":91},0.25,"Net Purse: ",{"$f":"M3+M2","v":0},null,{"$f":"IF(R4=45%,VLOOKUP(Q4,dbd,2,FALSE),IF(R4=33%,VLOOKUP(Q4,dbe,2,FALSE),IF(R4=25%,VLOOKUP(Q4,dbf,2,FALSE),IF(R4=20%,VLOOKUP(Q4,dbg,2,FALSE),VLOOKUP(Q4,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F33=0,91,Cover!F33)","v":91},0.25,"Net Purse: ",{"$f":"T3+T2","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,1,1,null,1,1,1,1,1,1,1,1]
[null,null,null,{"$f":"IF(C4=91,\"       To use this table, enter player divisions on Scores page\",IF(C4>75,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J4=91,\"       To use this table, enter player divisions on Scores page\",IF(J4>30,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q4=91,\"       To use this table, enter player divisions on Scores page\",IF(Q4>30,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,null,2,1,2,1,2,1,2,1]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"ROUND(0.33*BE6,0)","v":1},null,3,2,3,{"$f":"ROUND(0.25*BJ6,0)","v":1},3,1,3,1]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,2,null,4,2,4,{"$f":"ROUND(0.25*BJ7,0)","v":1},4,1,4,1]
[{"$f":"IF(ROW()-7>$A$4,\"\",ROW()-7)","v":1},{"$f":"IF(A8>$A$4,\"\",IF(D$4=45%,VLOOKUP(A8,_pay5,$A$4+1),VLOOKUP(A8,_pay3,$A$4+1)))","v":7.0000000000000007E-2},{"$f":"IF(B8=\"\",\"\",$F$4*B8)","v":0},{"$f":"IF(C8=\"\",\"\",INT((C8+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-7>$H$4,\"\",ROW()-7)","v":1},{"$f":"IF(K$4=45%,VLOOKUP(H8,_pay5,$H$4+1),VLOOKUP(H8,_pay3,$H$4+1))","v":7.0000000000000007E-2},{"$f":"IF(I8=\"\",\"\",$M$4*I8)","v":0},{"$f":"IF(J8=\"\",\"\",INT((J8+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-7>$O$4,\"\",ROW()-7)","v":1},{"$f":"IF(R$4=45%,VLOOKUP(O8,_pay5,$O$4+1),VLOOKUP(O8,_pay3,$O$4+1))","v":7.0000000000000007E-2},{"$f":"IF(P8=\"\",\"\",$T$4*P8)","v":0},{"$f":"IF(Q8=\"\",\"\",INT((Q8+2.5)/5)*5)","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,5,{"$f":"ROUND(0.33*BE8,0)","v":2},null,5,2,5,{"$f":"ROUND(0.25*BJ8,0)","v":1},5,1,5,1]
[2,{"$f":"IF(A9=\"\",\"\",IF(D$4=45%,VLOOKUP(A9,_pay5,A$4+1),VLOOKUP(A9,_pay3,A$4+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(H9=\"\",\"\",IF(K$4=45%,VLOOKUP(H9,_pay5,H$4+1),VLOOKUP(H9,_pay3,H$4+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(O9=\"\",\"\",IF(R$4=45%,VLOOKUP(O9,_pay5,O$4+1),VLOOKUP(O9,_pay3,O$4+1)))","v":6.5000000000000002E-2},0,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,6,2,null,6,3,6,2,6,1,6,1]
[3,0.06,0,0,null,null,null,3,0.06,0,0,null,null,null,3,0.06,0,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,7,2,null,7,3,7,2,7,2,7,1]
[4,0.06,0,0,null,null,null,4,0.06,0,0,null,null,null,4,0.06,0,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,8,3,null,8,4,8,2,8,2,8,1]
[5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,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,9,3,null,9,4,9,2,9,2,9,2]
[6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,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,10,3,null,10,5,10,3,10,2,10,2]
[7,0.05,0,0,null,null,null,7,0.05,0,0,null,null,null,7,0.05,0,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,11,4,null,11,5,11,3,11,2,11,2]
[8,0.05,0,0,null,null,null,8,0.05,0,0,null,null,null,8,0.05,0,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,12,4,null,12,6,12,3,12,3,12,2]
[9,0.05,0,0,null,null,null,9,0.05,0,0,null,null,null,9,0.05,0,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,13,4,null,13,6,13,3,13,3,13,2]
[10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,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,14,5,null,14,6,14,4,14,3,14,2]
[11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,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,15,5,null,15,7,15,4,15,3,15,2]
[12,4.4999999999999998E-2,0,0,null,null,null,12,4.4999999999999998E-2,0,0,null,null,null,12,4.4999999999999998E-2,0,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,16,5,null,16,7,16,4,16,3,16,3]
[13,0.04,0,0,null,null,null,13,0.04,0,0,null,null,null,13,0.04,0,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,17,6,null,17,8,17,4,17,4,17,3]
[14,0.04,0,0,null,null,null,null,{"$f":"SUM(I8:I20)","v":0.69000000000000017},{"$f":"SUM(J8:J20)","v":0},{"$f":"SUM(K8:K20)","v":0},{"$f":"SUM(L8:L20)","v":0},null,null,null,{"$f":"SUM(P8:P20)","v":0.69000000000000017},{"$f":"SUM(Q8:Q20)","v":0},{"$f":"SUM(R8:R20)","v":0},{"$f":"SUM(S8:S20)","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,18,6,null,18,8,18,5,18,4,18,3]
[15,0.04,0,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,19,6,null,19,9,19,5,19,4,19,3]
[16,3.5000000000000003E-2,0,0,null,null,null,"ADVANCED GRANDMASTER AM",null,null,null,null,null,null,"RECREATIONAL WOMEN AM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,7,null,20,9,20,5,20,4,20,3]
[17,3.5000000000000003E-2,0,0,null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",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,21,7,null,21,10,21,5,21,4,21,3]
[18,0.03,0,0,null,null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G26","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G35","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,22,7,null,22,10,22,6,22,5,22,3]
[19,0.03,0,0,null,null,null,{"$f":"IF(K26=45%,VLOOKUP(J26,dbd,2,FALSE),IF(K26=33%,VLOOKUP(J26,dbe,2,FALSE),IF(K26=25%,VLOOKUP(J26,dbf,2,FALSE),IF(K26=20%,VLOOKUP(J26,dbg,2,FALSE),VLOOKUP(J26,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F26=0,91,Cover!F26)","v":91},0.25,"Net Purse: ",{"$f":"M25+M24","v":0},null,{"$f":"IF(R26=45%,VLOOKUP(Q26,dbd,2,FALSE),IF(R26=33%,VLOOKUP(Q26,dbe,2,FALSE),IF(R26=25%,VLOOKUP(Q26,dbf,2,FALSE),IF(R26=20%,VLOOKUP(Q26,dbg,2,FALSE),VLOOKUP(Q26,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F35=0,91,Cover!F35)","v":91},0.25,"Net Purse: ",{"$f":"T25+T24","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,23,8,null,23,10,23,6,23,5,23,4]
[20,0.03,0,0,null,null,null,null,null,null,{"$f":"IF(J26=91,\"       To use this table, enter player divisions on Scores page\",IF(J26>30,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q26=91,\"       To use this table, enter player divisions on Scores page\",IF(Q26>26,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,8,null,24,11,24,6,24,5,24,4]
[21,2.5000000000000001E-2,0,0,null,null,null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,8,null,25,11,25,6,25,5,25,4]
[22,2.5000000000000001E-2,0,0,null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,9,null,26,12,26,7,26,5,26,4]
[23,0.02,0,0,null,null,null,{"$f":"IF(ROW()-29>$H$26,\"\",ROW()-29)","v":1},{"$f":"IF(K$26=45%,VLOOKUP(H30,_pay5,$H$26+1),VLOOKUP(H30,_pay3,$H$26+1))","v":7.0000000000000007E-2},{"$f":"IF(I30=\"\",\"\",$M$26*I30)","v":0},{"$f":"IF(J30=\"\",\"\",INT((J30+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-29>$O$26,\"\",ROW()-29)","v":1},{"$f":"IF(R$26=45%,VLOOKUP(O30,_pay5,O$26+1),VLOOKUP(O30,_pay3,O$26+1))","v":7.0000000000000007E-2},{"$f":"IF(P30=\"\",\"\",$T$26*P30)","v":0},{"$f":"IF(Q30=\"\",\"\",INT((Q30+2.5)/5)*5)","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,27,9,null,27,12,27,7,27,6,27,4]
["","","","",null,null,null,2,{"$f":"IF(H31=\"\",\"\",IF(K$26=45%,VLOOKUP(H31,_pay5,H$26+1),VLOOKUP(H31,_pay3,H$26+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(O31=\"\",\"\",IF(R$26=45%,VLOOKUP(O31,_pay5,O$26+1),VLOOKUP(O31,_pay3,O$26+1)))","v":6.5000000000000002E-2},0,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,28,9,null,28,13,28,7,28,6,28,4]
["","","","",null,null,null,3,0.06,0,0,null,null,null,3,0.06,0,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,29,10,null,29,13,29,7,29,6,29,4]
["","","","",null,null,null,4,0.06,0,0,null,null,null,4,0.06,0,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,30,10,null,30,14,30,8,30,6,30,5]
["","","","",null,null,null,5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,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,31,10,null,31,14,31,8,31,6,31,5]
["","","","",null,null,null,6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,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,32,11,null,32,15,32,8,32,7,32,5]
["","","","",null,null,null,7,0.05,0,0,null,null,null,7,0.05,0,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,33,11,null,33,15,33,8,33,7,33,5]
["","","","",null,null,null,8,0.05,0,0,null,null,null,8,0.05,0,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,34,11,null,34,15,34,9,34,7,34,5]
["","","","",null,null,null,9,0.05,0,0,null,null,null,9,0.05,0,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,35,12,null,35,16,35,9,35,7,35,5]
["","","","",null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,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,36,12,null,36,16,36,9,36,7,36,5]
["","","","",null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,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,37,12,null,37,17,37,9,37,8,37,6]
[null,{"$f":"SUM(B8:B40)","v":1.0000000000000004},{"$f":"SUM(C8:C40)","v":0},{"$f":"SUM(D8:D40)","v":0},{"$f":"SUM(E8:E40)","v":0},null,null,12,4.4999999999999998E-2,0,0,null,null,null,12,4.4999999999999998E-2,0,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,38,13,null,38,17,38,10,38,8,38,6]
[null,null,null,null,null,null,null,13,0.04,0,0,null,null,null,13,0.04,0,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,39,13,null,39,18,39,10,39,8,39,6]
["* Can be a negative number when expenses like trophies involved",null,null,null,null,null,null,null,{"$f":"SUM(I30:I42)","v":0.69000000000000017},{"$f":"SUM(J30:J42)","v":0},{"$f":"SUM(K30:K42)","v":0},{"$f":"SUM(L30:L42)","v":0},null,null,null,{"$f":"SUM(P30:P42)","v":0.69000000000000017},{"$f":"SUM(Q30:Q42)","v":0},{"$f":"SUM(R30:R42)","v":0},{"$f":"SUM(S30:S42)","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,40,13,null,40,18,40,10,40,8,40,6]
["INTERMEDIATE AM DIVISION",null,null,null,null,null,null,"ADVANCED SR GRANDMASTER AM",null,null,null,null,null,null,"INTERMEDIATE WOMEN AM",null,null,null,null,null,null,null,"Flatter",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41,14,null,41,19,41,10,41,8,41,6]
[null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,null,42,14,null,42,19,42,11,42,9,42,6]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G22","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G27","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G34","v":0},null,1,1,0.6,0.45,0.39,0.3,0.25,0.21,0.19,0.17,0.15,0.14000000000000001,0.13,0.115,0.11,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.1999999999999995E-2,7.0000000000000007E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.2E-2,0.06,5.7000000000000002E-2,5.5E-2,5.5E-2,5.1999999999999998E-2,0.05,4.8000000000000001E-2,4.5999999999999999E-2,null,43,14,null,43,19,43,11,43,9,43,6]
[{"$f":"IF(D47=45%,VLOOKUP(C47,dbd,2,FALSE),IF(D47=33%,VLOOKUP(C47,dbe,2,FALSE),IF(D47=25%,VLOOKUP(C47,dbf,2,FALSE),IF(D47=20%,VLOOKUP(C47,dbg,2,FALSE),VLOOKUP(C47,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F22=0,91,Cover!F22)","v":91},0.25,"Net Purse: ",{"$f":"F46+F45","v":0},null,{"$f":"IF(K47=45%,VLOOKUP(J47,dbd,2,FALSE),IF(K47=33%,VLOOKUP(J47,dbe,2,FALSE),IF(K47=25%,VLOOKUP(J47,dbf,2,FALSE),IF(K47=20%,VLOOKUP(J47,dbg,2,FALSE),VLOOKUP(J47,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F27=0,91,Cover!F27)","v":91},0.25,"Net Purse: ",{"$f":"M46+M45","v":0},null,{"$f":"IF(R47=45%,VLOOKUP(Q47,dbd,2,FALSE),IF(R47=33%,VLOOKUP(Q47,dbe,2,FALSE),IF(R47=25%,VLOOKUP(Q47,dbf,2,FALSE),IF(R47=20%,VLOOKUP(Q47,dbg,2,FALSE),VLOOKUP(Q47,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F34=0,91,Cover!F34)","v":91},0.25,"Net Purse: ",{"$f":"T46+T45","v":0},null,2,null,0.4,0.32500000000000001,0.28999999999999998,0.25,0.22,0.19,0.17,0.15,0.14000000000000001,0.13,0.12,0.11,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.0000000000000007E-2,6.8000000000000005E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,5.8000000000000003E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.8000000000000001E-2,4.5999999999999999E-2,4.3999999999999997E-2,null,44,15,null,44,20,44,11,44,9,44,7]
[null,null,null,{"$f":"IF(C47=91,\"       To use this table, enter player divisions on Scores page\",IF(C47>66,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J47=91,\"       To use this table, enter player divisions on Scores page\",IF(J47>9,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q47=91,\"       To use this table, enter player divisions on Scores page\",IF(Q47>26,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,3,null,null,0.22500000000000001,0.2,0.2,0.18,0.17,0.15,0.14000000000000001,0.13,0.12,0.11,0.105,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.2999999999999999E-2,0.05,0.05,4.8000000000000001E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.3999999999999997E-2,null,45,15,null,45,20,45,11,45,9,45,7]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,4,null,null,null,0.12,0.15,0.15,0.14000000000000001,0.13,0.12,0.12,0.11,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.3999999999999997E-2,4.2000000000000003E-2,null,46,15,null,46,21,46,12,46,9,46,7]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,5,null,null,null,null,0.1,0.12,0.12,0.12,0.11,0.11,0.1,0.09,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.3999999999999997E-2,4.2000000000000003E-2,4.2000000000000003E-2,null,47,16,null,47,21,47,12,47,10,47,7]
[{"$f":"IF(ROW()-50>$A$47,\"\",ROW()-50)","v":1},{"$f":"IF(D$47=45%,VLOOKUP(A51,_pay5,A$47+1),VLOOKUP(A51,_pay3,A$47+1))","v":7.0000000000000007E-2},{"$f":"IF(B51=\"\",\"\",$F$47*B51)","v":0},{"$f":"IF(C51=\"\",\"\",INT((C51+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-50>$H$47,\"\",ROW()-50)","v":1},{"$f":"IF(K$47=45%,VLOOKUP(H51,_pay5,H$47+1),VLOOKUP(H51,_pay3,H$47+1))","v":7.0000000000000007E-2},{"$f":"IF(I51=\"\",\"\",$M$47*I51)","v":0},{"$f":"IF(J51=\"\",\"\",INT((J51+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-50>$O$47,\"\",ROW()-50)","v":1},{"$f":"IF(R$47=45%,VLOOKUP(O51,_pay5,O$47+1),VLOOKUP(O51,_pay3,O$47+1))","v":7.0000000000000007E-2},{"$f":"IF(P51=\"\",\"\",$T$47*P51)","v":0},{"$f":"IF(Q51=\"\",\"\",INT((Q51+2.5)/5)*5)","v":0},null,null,null,6,null,null,null,null,null,0.08,0.1,0.1,0.1,0.09,0.09,0.09,0.08,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.2000000000000003E-2,0.04,0.04,null,48,16,null,48,22,48,12,48,10,48,7]
[2,{"$f":"IF(A52=\"\",\"\",IF(D$47=45%,VLOOKUP(A52,_pay5,A$47+1),VLOOKUP(A52,_pay3,A$47+1)))","v":6.5000000000000002E-2},0,0,null,null,null,{"$f":"IF(ROW()-50>$H$47,\"\",ROW()-50)","v":2},{"$f":"IF(H52=\"\",\"\",IF(K$47=45%,VLOOKUP(H52,_pay5,H$47+1),VLOOKUP(H52,_pay3,H$47+1)))","v":6.5000000000000002E-2},{"$f":"IF(I52=\"\",\"\",$M$47*I52)","v":0},{"$f":"IF(J52=\"\",\"\",INT((J52+2.5)/5)*5)","v":0},null,null,null,2,{"$f":"IF(O52=\"\",\"\",IF(R$47=45%,VLOOKUP(O52,_pay5,O$47+1),VLOOKUP(O52,_pay3,O$47+1)))","v":6.5000000000000002E-2},0,0,null,null,null,7,null,null,null,null,null,null,7.0000000000000007E-2,0.08,0.08,0.08,0.08,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,null,49,16,null,49,22,49,12,49,10,49,7]
[3,0.06,0,0,null,null,null,{"$f":"IF(ROW()-50>$H$47,\"\",ROW()-50)","v":3},{"$f":"IF(H53=\"\",\"\",IF(K$47=45%,VLOOKUP(H53,_pay5,H$47+1),VLOOKUP(H53,_pay3,H$47+1)))","v":0.06},{"$f":"IF(I53=\"\",\"\",$M$47*I53)","v":0},{"$f":"IF(J53=\"\",\"\",INT((J53+2.5)/5)*5)","v":0},null,null,null,3,0.06,0,0,null,null,null,8,null,null,null,null,null,null,null,0.06,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,3.7999999999999999E-2,null,50,17,null,50,23,50,13,50,10,50,7]
[4,0.06,0,0,null,null,null,{"$f":"IF(ROW()-50>$H$47,\"\",ROW()-50)","v":4},{"$f":"IF(H54=\"\",\"\",IF(K$47=45%,VLOOKUP(H54,_pay5,H$47+1),VLOOKUP(H54,_pay3,H$47+1)))","v":0.06},{"$f":"IF(I54=\"\",\"\",$M$47*I54)","v":0},{"$f":"IF(J54=\"\",\"\",INT((J54+2.5)/5)*5)","v":0},null,null,null,4,0.06,0,0,null,null,null,9,null,null,null,null,null,null,null,null,0.06,0.06,0.06,0.06,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,3.7999999999999999E-2,null,51,17,null,51,23,51,13,51,10,51,8]
[5,5.5E-2,0,0,null,null,null,null,{"$f":"SUM(I51:I54)","v":0.255},{"$f":"SUM(J51:J54)","v":0},{"$f":"SUM(K51:K54)","v":0},{"$f":"SUM(L51:L54)","v":0},null,null,5,5.5E-2,0,0,null,null,null,10,null,null,null,null,null,null,null,null,null,0.05,0.05,0.06,0.06,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,3.5999999999999997E-2,null,52,17,null,52,23,52,13,52,11,52,8]
[6,5.5E-2,0,0,null,null,null,null,null,null,null,null,null,null,6,5.5E-2,0,0,null,null,null,11,null,null,null,null,null,null,null,null,null,null,0.05,0.05,0.05,0.05,5.5E-2,0.05,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5999999999999997E-2,null,53,17,null,53,24,53,13,53,11,53,8]
[7,0.05,0,0,null,null,null,"ADVANCED WOMEN MASTER",null,null,null,null,null,null,7,0.05,0,0,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,0.04,4.4999999999999998E-2,4.4999999999999998E-2,0.05,0.05,0.05,4.4999999999999998E-2,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5999999999999997E-2,null,54,18,null,54,24,54,14,54,11,54,8]
[8,0.05,0,0,null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,8,0.05,0,0,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,0.04,0.04,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,null,55,18,null,55,25,55,14,55,11,55,8]
[9,0.05,0,0,null,null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G29","v":0},null,9,0.05,0,0,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,null,56,18,null,56,25,56,14,56,11,56,8]
[10,4.4999999999999998E-2,0,0,null,null,null,{"$f":"IF(K60=45%,VLOOKUP(J60,dbd,2,FALSE),IF(K60=33%,VLOOKUP(J60,dbe,2,FALSE),IF(K60=25%,VLOOKUP(J60,dbf,2,FALSE),IF(K60=20%,VLOOKUP(J60,dbg,2,FALSE),VLOOKUP(J60,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F29=0,91,Cover!F29)","v":91},0.25,"Net Purse: ",{"$f":"M59+M58","v":0},null,10,4.4999999999999998E-2,0,0,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,3.5000000000000003E-2,3.5000000000000003E-2,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.2000000000000001E-2,null,57,19,null,57,26,57,14,57,12,57,8]
[11,4.4999999999999998E-2,0,0,null,null,null,null,null,null,{"$f":"IF(J60=91,\"       To use this table, enter player divisions on Scores page\",IF(J60>9,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.03,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,3.2000000000000001E-2,null,58,19,null,58,26,58,15,58,12,58,9]
[12,4.4999999999999998E-2,0,0,null,null,null,null,"Prelim","Proposed","Round to","Manual","Final",null,12,4.4999999999999998E-2,0,0,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.03,0.03,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,null,59,19,null,59,27,59,15,59,12,59,9]
[13,0.04,0,0,null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,13,0.04,0,0,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,2.5000000000000001E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,null,60,20,null,60,27,60,15,60,12,60,9]
[14,0.04,0,0,null,null,null,{"$f":"IF(ROW()-63>$H$60,\"\",ROW()-63)","v":1},{"$f":"IF(K$60=45%,VLOOKUP(H64,_pay5,H$60+1),VLOOKUP(H64,_pay3,H$60+1))","v":7.0000000000000007E-2},{"$f":"IF(I64=\"\",\"\",$M$60*I64)","v":0},{"$f":"IF(J64=\"\",\"\",INT((J64+2.5)/5)*5)","v":0},null,null,null,null,{"$f":"SUM(P51:P63)","v":0.69000000000000017},{"$f":"SUM(Q51:Q63)","v":0},{"$f":"SUM(R51:R63)","v":0},{"$f":"SUM(S51:S63)","v":0},null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,2.8000000000000001E-2,null,61,20,null,61,28,61,15,61,12,61,9]
[15,0.04,0,0,null,null,null,{"$f":"IF(ROW()-63>$H$60,\"\",ROW()-63)","v":2},{"$f":"IF(H65=\"\",\"\",IF(K$60=45%,VLOOKUP(H65,_pay5,H$60+1),VLOOKUP(H65,_pay3,H$60+1)))","v":6.5000000000000002E-2},{"$f":"IF(I65=\"\",\"\",$M$60*I65)","v":0},{"$f":"IF(J65=\"\",\"\",INT((J65+2.5)/5)*5)","v":0},null,null,null,null,null,null,null,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,2.8000000000000001E-2,null,62,20,null,62,28,62,16,62,13,62,9]
[16,3.5000000000000003E-2,0,0,null,null,null,{"$f":"IF(ROW()-63>$H$60,\"\",ROW()-63)","v":3},{"$f":"IF(H66=\"\",\"\",IF(K$60=45%,VLOOKUP(H66,_pay5,H$60+1),VLOOKUP(H66,_pay3,H$60+1)))","v":0.06},{"$f":"IF(I66=\"\",\"\",$M$60*I66)","v":0},{"$f":"IF(J66=\"\",\"\",INT((J66+2.5)/5)*5)","v":0},null,null,null,"BOYS JR < 18",null,null,null,null,null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5999999999999999E-2,null,63,21,null,63,28,63,16,63,13,63,9]
[17,3.5000000000000003E-2,0,0,null,null,null,{"$f":"IF(ROW()-63>$H$60,\"\",ROW()-63)","v":4},{"$f":"IF(H67=\"\",\"\",IF(K$60=45%,VLOOKUP(H67,_pay5,H$60+1),VLOOKUP(H67,_pay3,H$60+1)))","v":0.06},{"$f":"IF(I67=\"\",\"\",$M$60*I67)","v":0},{"$f":"IF(J67=\"\",\"\",INT((J67+2.5)/5)*5)","v":0},null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5999999999999999E-2,null,64,21,null,64,29,64,16,64,13,64,9]
[18,0.03,0,0,null,null,null,null,{"$f":"SUM(I64:I67)","v":0.255},{"$f":"SUM(J64:J67)","v":0},{"$f":"SUM(K64:K67)","v":0},{"$f":"SUM(L64:L67)","v":0},null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G39","v":0},null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.4E-2,null,65,21,null,65,29,65,16,65,13,65,10]
[19,0.03,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R69=45%,VLOOKUP(Q69,dbd,2,FALSE),IF(R69=33%,VLOOKUP(Q69,dbe,2,FALSE),IF(R69=25%,VLOOKUP(Q69,dbf,2,FALSE),IF(R69=20%,VLOOKUP(Q69,dbg,2,FALSE),VLOOKUP(Q69,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F39=0,91,Cover!F39)","v":91},0.25,"Net Purse: ",{"$f":"T68+T67","v":0},null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.4E-2,null,66,22,null,66,30,66,17,66,13,66,10]
[20,0.03,0,0,null,null,null,"GIRLS JR < 18",null,null,null,null,null,null,null,null,null,{"$f":"IF(Q69=91,\"       To use this table, enter player divisions on Scores page\",IF(Q69>26,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,25,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.02,0.02,0.02,0.02,0.02,0.02,2.5000000000000001E-2,0.02,2.1999999999999999E-2,null,67,22,null,67,30,67,17,67,14,67,10]
[21,2.5000000000000001E-2,0,0,null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,"Prelim","Proposed","Round to","Manual","Final",null,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,0.02,0.02,0.02,0.02,0.02,0.02,0.02,2.1999999999999999E-2,null,68,{"$f":"ROUND(0.33*BE71,0)","v":22},null,68,31,68,17,68,14,68,10]
[22,2.5000000000000001E-2,0,0,null,null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G43","v":0},null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,27,null,null,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.02,0.02,0.02,0.02,0.02,0.02,0.02,null,69,23,null,69,31,69,{"$f":"ROUND(0.25*BJ72,0)","v":17},69,14,69,10]
[23,0.02,0,0,null,null,null,{"$f":"IF(K73=45%,VLOOKUP(J73,dbd,2,FALSE),IF(K73=33%,VLOOKUP(J73,dbe,2,FALSE),IF(K73=25%,VLOOKUP(J73,dbf,2,FALSE),IF(K73=20%,VLOOKUP(J73,dbg,2,FALSE),VLOOKUP(J73,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F45=0,91,Cover!F45)","v":91},0.25,"Net Purse: ",{"$f":"M72+M71","v":0},null,{"$f":"IF(ROW()-72>$O$69,\"\",ROW()-72)","v":1},{"$f":"IF(R$69=45%,VLOOKUP(O73,_pay5,O$69+1),VLOOKUP(O73,_pay3,O$69+1))","v":7.0000000000000007E-2},{"$f":"IF(P73=\"\",\"\",$T$69*P73)","v":0},{"$f":"IF(Q73=\"\",\"\",INT((Q73+2.5)/5)*5)","v":0},null,null,null,28,null,null,null,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.02,0.02,0.02,0.02,0.02,0.02,null,70,23,null,70,32,70,18,70,14,70,10]
["","","","",null,null,null,null,null,null,{"$f":"IF(J73=91,\"       To use this table, enter player divisions on Scores page\",IF(J73>18,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,2,{"$f":"IF(O74=\"\",\"\",IF(R$69=45%,VLOOKUP(O74,_pay5,O$69+1),VLOOKUP(O74,_pay3,O$69+1)))","v":6.5000000000000002E-2},0,0,null,null,null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,0.02,0.02,0.02,1.7999999999999999E-2,null,71,23,null,71,32,71,18,71,14,71,10]
["","","","",null,null,null,null,"Prelim","Proposed","Round to","Manual","Final",null,3,0.06,0,0,null,null,null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.4999999999999999E-2,0.02,1.7999999999999999E-2,null,72,24,null,72,33,72,18,72,15,72,11]
["","","","",null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,4,0.06,0,0,null,null,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.4999999999999999E-2,1.7999999999999999E-2,null,73,24,null,73,33,73,18,73,15,73,11]
["","","","",null,null,null,{"$f":"IF(ROW()-76>$H$73,\"\",ROW()-76)","v":1},{"$f":"IF(K$73=45%,VLOOKUP(H77,_pay5,H$73+1),VLOOKUP(H77,_pay3,H$73+1))","v":7.0000000000000007E-2},{"$f":"IF(I77=\"\",\"\",$M$73*I77)","v":0},{"$f":"IF(J77=\"\",\"\",INT((J77+2.5)/5)*5)","v":0},null,null,null,5,5.5E-2,0,0,null,null,null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.6E-2,null,74,24,null,74,33,74,19,74,15,74,11]
["","","","",null,null,null,2,{"$f":"IF(H78=\"\",\"\",IF(K$73=45%,VLOOKUP(H78,_pay5,H$73+1),VLOOKUP(H78,_pay3,H$73+1)))","v":6.5000000000000002E-2},0,0,null,null,null,6,5.5E-2,0,0,null,null,null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6E-2,null,75,25,null,null,null,75,19,75,15,75,11]
["","","","",null,null,null,3,0.06,0,0,null,null,null,7,0.05,0,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,76,25,null,null,null,76,19,76,15,76,11]
["","","","",null,null,null,4,0.06,0,0,null,null,null,8,0.05,0,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,77,25,null,null,null,77,19,77,16,77,11]
["","","","",null,null,null,5,5.5E-2,0,0,null,null,null,9,0.05,0,0,null,null,null,null,"Flatter (Same as above)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,26,null,null,null,78,20,78,16,78,11]
["","","","",null,null,null,6,5.5E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,null,79,26,null,null,null,79,20,79,16,79,12]
["","","","",null,null,null,7,0.05,0,0,null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,1,1,0.6,0.45,0.39,0.3,0.25,0.21,0.19,0.17,0.15,0.14000000000000001,0.13,0.115,0.11,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.1999999999999995E-2,7.0000000000000007E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.2E-2,0.06,5.7000000000000002E-2,5.5E-2,5.5E-2,5.1999999999999998E-2,0.05,4.8000000000000001E-2,4.5999999999999999E-2,null,80,26,null,null,null,80,20,80,16,80,12]
[null,{"$f":"SUM(B51:B83)","v":1.0000000000000004},{"$f":"SUM(C51:C83)","v":0},{"$f":"SUM(D51:D83)","v":0},{"$f":"SUM(E51:E83)","v":0},null,null,8,0.05,0,0,null,null,null,12,4.4999999999999998E-2,0,0,null,null,null,2,null,0.4,0.32500000000000001,0.28999999999999998,0.25,0.22,0.19,0.17,0.15,0.14000000000000001,0.13,0.12,0.11,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.0000000000000007E-2,6.8000000000000005E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,5.8000000000000003E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.8000000000000001E-2,4.5999999999999999E-2,4.3999999999999997E-2,null,81,27,null,null,null,81,20,81,16,81,12]
[null,null,null,null,null,null,null,9,0.05,0,0,null,null,null,13,0.04,0,0,null,null,null,3,null,null,0.22500000000000001,0.2,0.2,0.18,0.17,0.15,0.14000000000000001,0.13,0.12,0.11,0.105,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.2999999999999999E-2,0.05,0.05,4.8000000000000001E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.3999999999999997E-2,null,82,27,null,null,null,82,21,82,17,82,12]
["* Can be a negative number when expenses like trophies involved",null,null,null,null,null,null,null,{"$f":"SUM(I77:I85)","v":0.51500000000000001},{"$f":"SUM(J77:J85)","v":0},{"$f":"SUM(K77:K85)","v":0},{"$f":"SUM(L77:L85)","v":0},null,null,null,{"$f":"SUM(P73:P85)","v":0.69000000000000017},{"$f":"SUM(Q73:Q85)","v":0},{"$f":"SUM(R73:R85)","v":0},{"$f":"SUM(S73:S85)","v":0},null,null,4,null,null,null,0.12,0.15,0.15,0.14000000000000001,0.13,0.12,0.12,0.11,0.1,9.5000000000000001E-2,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.3999999999999997E-2,4.2000000000000003E-2,null,83,27,null,null,null,83,21,83,17,83,12]
["RECREATIONAL AM DIVISION",null,null,null,null,null,null,"GIRLS JR < 15",null,null,null,null,null,null,"BOYS JR < 15",null,null,null,null,null,null,5,null,null,null,null,0.1,0.12,0.12,0.12,0.11,0.11,0.1,0.09,0.09,8.5000000000000006E-2,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.3999999999999997E-2,4.2000000000000003E-2,4.2000000000000003E-2,null,84,28,null,null,null,84,21,84,17,84,12]
[null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,6,null,null,null,null,null,0.08,0.1,0.1,0.1,0.09,0.09,0.09,0.08,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.2000000000000003E-2,0.04,0.04,null,85,28,null,null,null,85,21,85,17,85,12]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G23","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G44","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G40","v":0},null,7,null,null,null,null,null,null,7.0000000000000007E-2,0.08,0.08,0.08,0.08,0.08,7.4999999999999997E-2,7.4999999999999997E-2,7.0000000000000007E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,null,86,28,null,null,null,86,22,86,17,86,13]
[{"$f":"IF(D90=45%,VLOOKUP(C90,dbd,2,FALSE),IF(D90=33%,VLOOKUP(C90,dbe,2,FALSE),IF(D90=25%,VLOOKUP(C90,dbf,2,FALSE),IF(D90=20%,VLOOKUP(C90,dbg,2,FALSE),VLOOKUP(C90,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F23=0,91,Cover!F23)","v":91},0.25,"Net Purse: ",{"$f":"F89+F88","v":0},null,{"$f":"IF(K90=45%,VLOOKUP(J90,dbd,2,FALSE),IF(K90=33%,VLOOKUP(J90,dbe,2,FALSE),IF(K90=25%,VLOOKUP(J90,dbf,2,FALSE),IF(K90=20%,VLOOKUP(J90,dbg,2,FALSE),VLOOKUP(J90,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F46=0,91,Cover!F46)","v":91},0.25,"Net Purse: ",{"$f":"M89+M88","v":0},null,{"$f":"IF(R90=45%,VLOOKUP(Q90,dbd,2,FALSE),IF(R90=33%,VLOOKUP(Q90,dbe,2,FALSE),IF(R90=25%,VLOOKUP(Q90,dbf,2,FALSE),IF(R90=20%,VLOOKUP(Q90,dbg,2,FALSE),VLOOKUP(Q90,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F40=0,91,Cover!F40)","v":91},0.25,"Net Purse: ",{"$f":"T89+T88","v":0},null,8,null,null,null,null,null,null,null,0.06,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,3.7999999999999999E-2,null,87,29,null,null,null,87,22,87,18,87,13]
[null,null,null,{"$f":"IF(C90=91,\"       To use this table, enter player divisions on Scores page\",IF(C90>66,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J90=91,\"       To use this table, enter player divisions on Scores page\",IF(J90>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q90=91,\"       To use this table, enter player divisions on Scores page\",IF(Q90>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,9,null,null,null,null,null,null,null,null,0.06,0.06,0.06,0.06,6.5000000000000002E-2,6.5000000000000002E-2,0.06,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,3.7999999999999999E-2,null,88,29,null,null,null,88,22,88,18,88,13]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,10,null,null,null,null,null,null,null,null,null,0.05,0.05,0.06,0.06,0.06,0.06,5.5E-2,5.5E-2,5.5E-2,5.5E-2,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,3.5999999999999997E-2,null,89,29,null,null,null,89,22,89,18,89,13]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,11,null,null,null,null,null,null,null,null,null,null,0.05,0.05,0.05,0.05,5.5E-2,0.05,0.05,0.05,0.05,0.05,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5999999999999997E-2,null,90,30,null,null,null,90,23,90,18,90,13]
[{"$f":"IF(ROW()-93>$A$90,\"\",ROW()-93)","v":1},{"$f":"IF(D$90=45%,VLOOKUP(A94,_pay5,A$90+1),VLOOKUP(A94,_pay3,A$90+1))","v":7.0000000000000007E-2},{"$f":"IF(B94=\"\",\"\",$F$90*B94)","v":0},{"$f":"IF(C94=\"\",\"\",INT((C94+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-93>$H$90,\"\",ROW()-93)","v":1},{"$f":"IF(K$90=45%,VLOOKUP(H94,_pay5,H$90+1),VLOOKUP(H94,_pay3,H$90+1))","v":7.0000000000000007E-2},{"$f":"IF(I94=\"\",\"\",$M$90*I94)","v":0},{"$f":"IF(J94=\"\",\"\",INT((J94+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-93>$O$90,\"\",ROW()-93)","v":1},{"$f":"IF(R$90=45%,VLOOKUP(O94,_pay5,O$90+1),VLOOKUP(O94,_pay3,O$90+1))","v":7.0000000000000007E-2},{"$f":"IF(P94=\"\",\"\",$T$90*P94)","v":0},{"$f":"IF(Q94=\"\",\"\",INT((Q94+2.5)/5)*5)","v":0},null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,0.04,4.4999999999999998E-2,4.4999999999999998E-2,0.05,0.05,0.05,4.4999999999999998E-2,0.05,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5999999999999997E-2,null,91,30,null,null,null,91,23,91,18,91,13]
[2,{"$f":"IF(A95=\"\",\"\",IF(D$90=45%,VLOOKUP(A95,_pay5,A$90+1),VLOOKUP(A95,_pay3,A$90+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(H95=\"\",\"\",IF(K$90=45%,VLOOKUP(H95,_pay5,H$90+1),VLOOKUP(H95,_pay3,H$90+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(O95=\"\",\"\",IF(R$90=45%,VLOOKUP(O95,_pay5,O$90+1),VLOOKUP(O95,_pay3,O$90+1)))","v":6.5000000000000002E-2},0,0,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,0.04,0.04,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.4999999999999998E-2,0.04,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,null,92,30,null,null,null,92,23,92,19,92,13]
[3,0.06,0,0,null,null,null,3,0.06,0,0,null,null,null,3,0.06,0,0,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,null,93,31,null,null,null,93,23,93,19,93,14]
[4,0.06,0,0,null,null,null,4,0.06,0,0,null,null,null,4,0.06,0,0,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,3.5000000000000003E-2,3.5000000000000003E-2,0.04,0.04,0.04,0.04,0.04,0.04,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.2000000000000001E-2,null,94,31,null,null,null,94,24,94,19,94,14]
[5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,0,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.03,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,3.2000000000000001E-2,null,95,31,null,null,null,95,24,95,19,95,14]
[6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,0,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,0.03,0.03,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,null,96,32,null,null,null,96,24,96,19,96,14]
[7,0.05,0,0,null,null,null,7,0.05,0,0,null,null,null,7,0.05,0,0,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.03,2.5000000000000001E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,null,97,32,null,null,null,97,24,97,20,97,14]
[8,0.05,0,0,null,null,null,8,0.05,0,0,null,null,null,8,0.05,0,0,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,2.8000000000000001E-2,null,98,32,null,null,null,98,25,98,20,98,14]
[9,0.05,0,0,null,null,null,9,0.05,0,0,null,null,null,9,0.05,0,0,null,null,null,20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,2.8000000000000001E-2,null,99,33,null,null,null,99,25,99,20,99,14]
[10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,21,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5999999999999999E-2,null,100,33,null,null,null,100,25,100,20,100,15]
[11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5999999999999999E-2,null,null,null,null,null,null,101,25,101,20,101,15]
[12,4.4999999999999998E-2,0,0,null,null,null,null,{"$f":"SUM(I94:I104)","v":0.60500000000000009},{"$f":"SUM(J94:J104)","v":0},{"$f":"SUM(K94:K104)","v":0},{"$f":"SUM(L94:L104)","v":0},null,null,null,{"$f":"SUM(P94:P104)","v":0.60500000000000009},{"$f":"SUM(Q94:Q104)","v":0},{"$f":"SUM(R94:R104)","v":0},{"$f":"SUM(S94:S104)","v":0},null,null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.4E-2,null,null,null,null,null,null,102,26,102,21,102,15]
[13,0.04,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.02,0.02,0.02,0.02,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.4E-2,null,null,null,null,null,null,103,26,103,21,103,15]
[14,0.04,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,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.02,0.02,0.02,0.02,0.02,0.02,2.5000000000000001E-2,0.02,2.1999999999999999E-2,null,null,null,null,null,null,104,26,104,21,104,15]
[15,0.04,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.02,0.02,0.02,0.02,0.02,0.02,0.02,2.1999999999999999E-2,null,null,null,null,null,null,105,26,105,21,105,15]
[16,3.5000000000000003E-2,0,0,null,null,null,"GIRLS JR < 12",null,null,null,null,null,null,"BOYS JR < 12",null,null,null,null,null,null,27,null,null,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.02,0.02,0.02,0.02,0.02,0.02,0.02,null,null,null,null,null,null,106,27,106,21,106,15]
[17,3.5000000000000003E-2,0,0,null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,28,null,null,null,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.02,0.02,0.02,0.02,0.02,0.02,null,null,null,null,null,null,107,27,107,22,107,16]
[18,0.03,0,0,null,null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G45","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G41","v":0},null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,0.02,0.02,0.02,1.7999999999999999E-2,null,null,null,null,null,null,108,27,108,22,108,16]
[19,0.03,0,0,null,null,null,{"$f":"IF(K112=45%,VLOOKUP(J112,dbd,2,FALSE),IF(K112=33%,VLOOKUP(J112,dbe,2,FALSE),IF(K112=25%,VLOOKUP(J112,dbf,2,FALSE),IF(K112=20%,VLOOKUP(J112,dbg,2,FALSE),VLOOKUP(J112,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F47=0,91,Cover!F47)","v":91},0.25,"Net Purse: ",{"$f":"M111+M110","v":0},null,{"$f":"IF(R112=45%,VLOOKUP(Q112,dbd,2,FALSE),IF(R112=33%,VLOOKUP(Q112,dbe,2,FALSE),IF(R112=25%,VLOOKUP(Q112,dbf,2,FALSE),IF(R112=20%,VLOOKUP(Q112,dbg,2,FALSE),VLOOKUP(Q112,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F41=0,91,Cover!F41)","v":91},0.25,"Net Purse: ",{"$f":"T111+T110","v":0},null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.4999999999999999E-2,0.02,1.7999999999999999E-2,null,null,null,null,null,null,109,27,109,22,109,16]
[20,0.03,0,0,null,null,null,null,null,null,{"$f":"IF(J112=91,\"       To use this table, enter player divisions on Scores page\",IF(J112>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q112=91,\"       To use this table, enter player divisions on Scores page\",IF(Q112>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.4999999999999999E-2,1.7999999999999999E-2,null,null,null,null,null,null,110,28,110,22,110,16]
[21,2.5000000000000001E-2,0,0,null,null,null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.6E-2,null,null,null,null,null,null,111,28,111,22,111,16]
[22,2.5000000000000001E-2,0,0,null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.6E-2,null,null,null,null,null,null,112,28,112,23,112,16]
[23,0.02,0,0,null,null,null,{"$f":"IF(ROW()-115>$H$112,\"\",ROW()-115)","v":1},{"$f":"IF(K$112=45%,VLOOKUP(H116,_pay5,H$112+1),VLOOKUP(H116,_pay3,H$112+1))","v":7.0000000000000007E-2},{"$f":"IF(I116=\"\",\"\",$M$112*I116)","v":0},{"$f":"IF(J116=\"\",\"\",INT((J116+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-115>$O$112,\"\",ROW()-115)","v":1},{"$f":"IF(R$112=45%,VLOOKUP(O116,_pay5,O$112+1),VLOOKUP(O116,_pay3,O$112+1))","v":7.0000000000000007E-2},{"$f":"IF(P116=\"\",\"\",$T$112*P116)","v":0},{"$f":"IF(Q116=\"\",\"\",INT((Q116+2.5)/5)*5)","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,113,28,113,23,113,16]
["","","","",null,null,null,2,{"$f":"IF(H117=\"\",\"\",IF(K$112=45%,VLOOKUP(H117,_pay5,H$112+1),VLOOKUP(H117,_pay3,H$112+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(O117=\"\",\"\",IF(R$112=45%,VLOOKUP(O117,_pay5,O$112+1),VLOOKUP(O117,_pay3,O$112+1)))","v":6.5000000000000002E-2},0,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,114,29,114,23,114,17]
["","","","",null,null,null,3,0.06,0,0,null,null,null,3,0.06,0,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,115,29,115,23,115,17]
["","","","",null,null,null,4,0.06,0,0,null,null,null,4,0.06,0,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,116,29,116,23,116,17]
["","","","",null,null,null,5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,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,117,29,117,24,117,17]
["","","","",null,null,null,6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,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,118,30,118,24,118,17]
["","","","",null,null,null,7,0.05,0,0,null,null,null,7,0.05,0,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,119,30,119,24,119,17]
["","","","",null,null,null,8,0.05,0,0,null,null,null,8,0.05,0,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,120,30,120,24,120,17]
["","","","",null,null,null,9,0.05,0,0,null,null,null,9,0.05,0,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,121,30,121,24,121,18]
["","","","",null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,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,122,31,122,25,122,18]
["","","","",null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,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,123,31,123,25,123,18]
[null,{"$f":"SUM(B94:B126)","v":1.0000000000000004},{"$f":"SUM(C94:C126)","v":0},{"$f":"SUM(D94:D126)","v":0},{"$f":"SUM(E94:E126)","v":0},null,null,null,{"$f":"SUM(I116:I126)","v":0.60500000000000009},{"$f":"SUM(J116:J126)","v":0},{"$f":"SUM(K116:K126)","v":0},{"$f":"SUM(L116:L126)","v":0},null,null,null,{"$f":"SUM(P116:P126)","v":0.60500000000000009},{"$f":"SUM(Q116:Q126)","v":0},{"$f":"SUM(R116:R126)","v":0},{"$f":"SUM(S116:S126)","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,124,31,124,25,124,18]
["* Can be a negative number when expenses like trophies involved",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,125,31,125,25,125,18]
["GIRLS JR < 10",null,null,null,null,null,null,"BOYS JR < 10",null,null,null,null,null,null,"NOVICE AM DIVISION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,126,32,126,25,126,18]
[null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",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,127,32,127,26,127,18]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G50","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G42","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G24","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,128,32,128,26,128,19]
[{"$f":"IF(D132=45%,VLOOKUP(C132,dbd,2,FALSE),IF(D132=33%,VLOOKUP(C132,dbe,2,FALSE),IF(D132=25%,VLOOKUP(C132,dbf,2,FALSE),IF(D132=20%,VLOOKUP(C132,dbg,2,FALSE),VLOOKUP(C132,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F48=0,91,Cover!F48)","v":91},0.25,"Net Purse: ",{"$f":"F131+F130","v":0},null,{"$f":"IF(K132=45%,VLOOKUP(J132,dbd,2,FALSE),IF(K132=33%,VLOOKUP(J132,dbe,2,FALSE),IF(K132=25%,VLOOKUP(J132,dbf,2,FALSE),IF(K132=20%,VLOOKUP(J132,dbg,2,FALSE),VLOOKUP(J132,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F42=0,91,Cover!F42)","v":91},0.25,"Net Purse: ",{"$f":"M131+M130","v":0},null,{"$f":"IF(R132=45%,VLOOKUP(Q132,dbd,2,FALSE),IF(R132=33%,VLOOKUP(Q132,dbe,2,FALSE),IF(R132=25%,VLOOKUP(Q132,dbf,2,FALSE),IF(R132=20%,VLOOKUP(Q132,dbg,2,FALSE),VLOOKUP(Q132,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F24=0,91,Cover!F24)","v":91},0.25,"Net Purse: ",{"$f":"T131+T130","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,129,32,129,26,129,19]
[null,null,null,{"$f":"IF(C132=91,\"       To use this table, enter player divisions on Scores page\",IF(C132>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J132=91,\"       To use this table, enter player divisions on Scores page\",IF(J132>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q132=91,\"       To use this table, enter player divisions on Scores page\",IF(Q132>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,130,{"$f":"ROUND(0.25*BJ133,0)","v":33},130,26,130,19]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131,{"$f":"ROUND(0.25*BJ134,0)","v":33},131,26,131,19]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,132,{"$f":"ROUND(0.25*BJ135,0)","v":33},132,27,132,19]
[{"$f":"IF(ROW()-135>$A$132,\"\",ROW()-135)","v":1},{"$f":"IF(D$132=45%,VLOOKUP(A136,_pay5,A$132+1),VLOOKUP(A136,_pay3,A$132+1))","v":7.0000000000000007E-2},{"$f":"IF(B136=\"\",\"\",$F$132*B136)","v":0},{"$f":"IF(C136=\"\",\"\",INT((C136+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-135>$H$132,\"\",ROW()-135)","v":1},{"$f":"IF(K$132=45%,VLOOKUP(H136,_pay5,H$132+1),VLOOKUP(H136,_pay3,H$132+1))","v":7.0000000000000007E-2},{"$f":"IF(I136=\"\",\"\",$M$132*I136)","v":0},{"$f":"IF(J136=\"\",\"\",INT((J136+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-135>$O$132,\"\",ROW()-135)","v":1},{"$f":"IF(R$132=45%,VLOOKUP(O136,_pay5,O$132+1),VLOOKUP(O136,_pay3,O$132+1))","v":7.0000000000000007E-2},{"$f":"IF(P136=\"\",\"\",$T$132*P136)","v":0},{"$f":"IF(Q136=\"\",\"\",INT((Q136+2.5)/5)*5)","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,133,{"$f":"ROUND(0.25*BJ136,0)","v":33},133,27,133,19]
[2,{"$f":"IF(A137=\"\",\"\",IF(D$132=45%,VLOOKUP(A137,_pay5,A$132+1),VLOOKUP(A137,_pay3,A$132+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(H137=\"\",\"\",IF(K$132=45%,VLOOKUP(H137,_pay5,H$132+1),VLOOKUP(H137,_pay3,H$132+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(O137=\"\",\"\",IF(R$132=45%,VLOOKUP(O137,_pay5,O$132+1),VLOOKUP(O137,_pay3,O$132+1)))","v":6.5000000000000002E-2},0,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,134,27,134,19]
[3,0.06,0,0,null,null,null,3,0.06,0,0,null,null,null,3,0.06,0,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,135,27,135,20]
[4,0.06,0,0,null,null,null,4,0.06,0,0,null,null,null,4,0.06,0,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,136,27,136,20]
[5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,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,137,28,137,20]
[6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,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,138,28,138,20]
[7,0.05,0,0,null,null,null,7,0.05,0,0,null,null,null,7,0.05,0,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,139,28,139,20]
[8,0.05,0,0,null,null,null,8,0.05,0,0,null,null,null,8,0.05,0,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,140,28,140,20]
[9,0.05,0,0,null,null,null,9,0.05,0,0,null,null,null,9,0.05,0,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,141,28,141,20]
[10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,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,142,29,142,21]
[11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,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,143,29,143,21]
[null,{"$f":"SUM(B136:B146)","v":0.60500000000000009},{"$f":"SUM(C136:C146)","v":0},{"$f":"SUM(D136:D146)","v":0},{"$f":"SUM(E136:E146)","v":0},null,null,null,{"$f":"SUM(I136:I146)","v":0.60500000000000009},{"$f":"SUM(J136:J146)","v":0},{"$f":"SUM(K136:K146)","v":0},{"$f":"SUM(L136:L146)","v":0},null,null,null,{"$f":"SUM(P136:P146)","v":0.60500000000000009},{"$f":"SUM(Q136:Q146)","v":0},{"$f":"SUM(R136:R146)","v":0},{"$f":"SUM(S136:S146)","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,144,29,144,21]
[]
["ADV WOMEN GRANDMASTER",null,null,null,null,null,null,"ADV WOMEN SR GRANDMASTER",null,null,null,null,null,null,"NOVICE WOMEN AM"]
[null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,null,null,null,null,"Add (or reduce) local cash here* > ",0]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G30","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G31","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G36","v":0}]
[{"$f":"IF(D152=45%,VLOOKUP(C152,dbd,2,FALSE),IF(D152=33%,VLOOKUP(C152,dbe,2,FALSE),IF(D152=25%,VLOOKUP(C152,dbf,2,FALSE),IF(D152=20%,VLOOKUP(C152,dbg,2,FALSE),VLOOKUP(C152,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F30=0,91,Cover!F30)","v":91},0.25,"Net Purse: ",{"$f":"F151+F150","v":0},null,{"$f":"IF(K152=45%,VLOOKUP(J152,dbd,2,FALSE),IF(K152=33%,VLOOKUP(J152,dbe,2,FALSE),IF(K152=25%,VLOOKUP(J152,dbf,2,FALSE),IF(K152=20%,VLOOKUP(J152,dbg,2,FALSE),VLOOKUP(J152,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F31=0,91,Cover!F31)","v":91},0.25,"Net Purse: ",{"$f":"M151+M150","v":0},null,{"$f":"IF(R152=45%,VLOOKUP(Q152,dbd,2,FALSE),IF(R152=33%,VLOOKUP(Q152,dbe,2,FALSE),IF(R152=25%,VLOOKUP(Q152,dbf,2,FALSE),IF(R152=20%,VLOOKUP(Q152,dbg,2,FALSE),VLOOKUP(Q152,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F36=0,91,Cover!F36)","v":91},0.25,"Net Purse: ",{"$f":"T151+T150","v":0}]
[null,null,null,{"$f":"IF(C152=91,\"       To use this table, enter player divisions on Scores page\",IF(C152>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J152=91,\"       To use this table, enter player divisions on Scores page\",IF(J152>4,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q152=91,\"       To use this table, enter player divisions on Scores page\",IF(Q152>16,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"}]
[null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final",null,null,"Prelim","Proposed","Round to","Manual","Final"]
["Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place"]
[{"$f":"IF(ROW()-155>$A$152,\"\",ROW()-155)","v":1},{"$f":"IF(D$152=45%,VLOOKUP(A156,_pay5,A$152+1),VLOOKUP(A156,_pay3,A$152+1))","v":7.0000000000000007E-2},{"$f":"IF(B156=\"\",\"\",$F$132*B156)","v":0},{"$f":"IF(C156=\"\",\"\",INT((C156+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-155>$H$152,\"\",ROW()-155)","v":1},{"$f":"IF(K$152=45%,VLOOKUP(H156,_pay5,H$152+1),VLOOKUP(H156,_pay3,H$152+1))","v":7.0000000000000007E-2},{"$f":"IF(I156=\"\",\"\",$M$152*I156)","v":0},{"$f":"IF(J156=\"\",\"\",INT((J156+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-155>$O$152,\"\",ROW()-155)","v":1},{"$f":"IF(R$152=45%,VLOOKUP(O156,_pay5,O$152+1),VLOOKUP(O156,_pay3,O$152+1))","v":7.0000000000000007E-2},{"$f":"IF(P156=\"\",\"\",$T$152*P156)","v":0},{"$f":"IF(Q156=\"\",\"\",INT((Q156+2.5)/5)*5)","v":0}]
[2,{"$f":"IF(A157=\"\",\"\",IF(D$152=45%,VLOOKUP(A157,_pay5,A$152+1),VLOOKUP(A157,_pay3,A$152+1)))","v":6.5000000000000002E-2},0,0,null,null,null,{"$f":"IF(ROW()-155>$H$152,\"\",ROW()-155)","v":2},{"$f":"IF(H157=\"\",\"\",IF(K$152=45%,VLOOKUP(H157,_pay5,H$152+1),VLOOKUP(H157,_pay3,H$152+1)))","v":6.5000000000000002E-2},{"$f":"IF(I157=\"\",\"\",$M$152*I157)","v":0},{"$f":"IF(J157=\"\",\"\",INT((J157+2.5)/5)*5)","v":0},null,null,null,2,{"$f":"IF(O157=\"\",\"\",IF(R$152=45%,VLOOKUP(O157,_pay5,O$152+1),VLOOKUP(O157,_pay3,O$152+1)))","v":6.5000000000000002E-2},0,0]
[3,0.06,0,0,null,null,null,null,{"$f":"SUM(I156:I157)","v":0.13500000000000001},{"$f":"SUM(J156:J157)","v":0},{"$f":"SUM(K156:K157)","v":0},{"$f":"SUM(L156:L157)","v":0},null,null,3,0.06,0,0]
[4,0.06,0,0,null,null,null,null,null,null,null,null,null,null,4,0.06,0,0]
[5,5.5E-2,0,0,null,null,null,"ADVANCED LEGENDS",null,null,null,null,null,null,5,5.5E-2,0,0]
[6,5.5E-2,0,0,null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0,null,6,5.5E-2,0,0]
[7,0.05,0,0,null,null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G28","v":0},null,7,0.05,0,0]
[8,0.05,0,0,null,null,null,{"$f":"IF(K163=45%,VLOOKUP(J163,dbd,2,FALSE),IF(K163=33%,VLOOKUP(J163,dbe,2,FALSE),IF(K163=25%,VLOOKUP(J163,dbf,2,FALSE),IF(K163=20%,VLOOKUP(J163,dbg,2,FALSE),VLOOKUP(J163,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F28=0,91,Cover!F28)","v":91},0.25,"Net Purse: ",{"$f":"M162+M161","v":0},null,8,0.05,0,0]
[9,0.05,0,0,null,null,null,null,null,null,{"$f":"IF(J163=91,\"       To use this table, enter player divisions on Scores page\",IF(J163>4,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,{"$f":"SUM(P156:P163)","v":0.46499999999999997},{"$f":"SUM(Q156:Q163)","v":0},{"$f":"SUM(R156:R163)","v":0},{"$f":"SUM(S156:S163)","v":0}]
[10,4.4999999999999998E-2,0,0,null,null,null,null,"Prelim","Proposed","Round to","Manual","Final"]
[11,4.4999999999999998E-2,0,0,null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place",null,"ADV WOMEN LEGENDS"]
[null,{"$f":"SUM(B156:B166)","v":0.60500000000000009},{"$f":"SUM(C156:C166)","v":0},{"$f":"SUM(D156:D166)","v":0},{"$f":"SUM(E156:E166)","v":0},null,null,{"$f":"IF(ROW()-166>$H$163,\"\",ROW()-166)","v":1},{"$f":"IF(K$163=45%,VLOOKUP(H167,_pay5,H$163+1),VLOOKUP(H167,_pay3,H$163+1))","v":7.0000000000000007E-2},{"$f":"IF(I167=\"\",\"\",$M$163*I167)","v":0},{"$f":"IF(J167=\"\",\"\",INT((J167+2.5)/5)*5)","v":0},null,null,null,null,null,null,null,"Add (or reduce) local cash here* > ",0]
["GIRLS JR < 6",null,null,null,null,null,null,{"$f":"IF(ROW()-166>$H$163,\"\",ROW()-166)","v":2},{"$f":"IF(H168=\"\",\"\",IF(K$163=45%,VLOOKUP(H168,_pay5,H$163+1),VLOOKUP(H168,_pay3,H$163+1)))","v":6.5000000000000002E-2},{"$f":"IF(I168=\"\",\"\",$M$163*I168)","v":0},{"$f":"IF(J168=\"\",\"\",INT((J168+2.5)/5)*5)","v":0},null,null,null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G32","v":0}]
[null,null,null,null,"Enter Added Cash (or deduction) here* > ",0,null,null,{"$f":"SUM(I167:I168)","v":0.13500000000000001},{"$f":"SUM(J167:J168)","v":0},{"$f":"SUM(K167:K168)","v":0},{"$f":"SUM(L167:L168)","v":0},null,null,{"$f":"IF(R169=45%,VLOOKUP(Q169,dbd,2,FALSE),IF(R169=33%,VLOOKUP(Q169,dbe,2,FALSE),IF(R169=25%,VLOOKUP(Q169,dbf,2,FALSE),IF(R169=20%,VLOOKUP(Q169,dbg,2,FALSE),VLOOKUP(Q169,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F32=0,91,Cover!F32)","v":91},0.25,"Net Purse: ",{"$f":"T168+T167","v":0}]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G50","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q169=91,\"       To use this table, enter player divisions on Scores page\",IF(Q169>4,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"}]
[{"$f":"IF(D171=45%,VLOOKUP(C171,dbd,2,FALSE),IF(D171=33%,VLOOKUP(C171,dbe,2,FALSE),IF(D171=25%,VLOOKUP(C171,dbf,2,FALSE),IF(D171=20%,VLOOKUP(C171,dbg,2,FALSE),VLOOKUP(C171,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F50=0,91,Cover!F50)","v":91},0.25,"Net Purse: ",{"$f":"F170+F169","v":0},null,null,null,null,null,null,null,null,null,"Prelim","Proposed","Round to","Manual","Final"]
[null,null,null,{"$f":"IF(C171=91,\"       To use this table, enter player divisions on Scores page\",IF(C171>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,null,null,null,null,"Place","Factor","Local Pay","nearest 5","Adj. (Local)","Place"]
[null,"Prelim","Proposed","Round","Manual","Final",null,null,null,null,null,null,null,null,{"$f":"IF(ROW()-172>$O$169,\"\",ROW()-172)","v":1},{"$f":"IF(R$169=45%,VLOOKUP(O173,_pay5,O$169+1),VLOOKUP(O173,_pay3,O$169+1))","v":7.0000000000000007E-2},{"$f":"IF(P173=\"\",\"\",$T$169*P173)","v":0},{"$f":"IF(Q173=\"\",\"\",INT((Q173+2.5)/5)*5)","v":0}]
["Place","Factor","Payout $$","to $5","Adj. ","Place",null,null,null,null,null,null,null,null,{"$f":"IF(ROW()-172>$O$169,\"\",ROW()-172)","v":2},{"$f":"IF(O174=\"\",\"\",IF(R$169=45%,VLOOKUP(O174,_pay5,O$169+1),VLOOKUP(O174,_pay3,O$169+1)))","v":6.5000000000000002E-2},{"$f":"IF(P174=\"\",\"\",$T$169*P174)","v":0},{"$f":"IF(Q174=\"\",\"\",INT((Q174+2.5)/5)*5)","v":0}]
[{"$f":"IF(ROW()-174>$A$171,\"\",ROW()-174)","v":1},{"$f":"IF(D$171=45%,VLOOKUP(A175,__pay5,A$171+1),VLOOKUP(A175,__pay3,A$171+1))","v":7.0000000000000007E-2},{"$f":"IF(B175=\"\",\"\",$F$171*B175)","v":0},{"$f":"IF(C175=\"\",\"\",INT((C175+2.5)/5)*5)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P173:P174)","v":0.13500000000000001},{"$f":"SUM(Q173:Q174)","v":0},{"$f":"SUM(R173:R174)","v":0},{"$f":"SUM(S173:S174)","v":0}]
[{"$f":"IF(ROW()-174>$A$171,\"\",ROW()-174)","v":2},{"$f":"IF(A176=\"\",\"\",IF(D$171=45%,VLOOKUP(A176,__pay5,A$171+1),VLOOKUP(A176,__pay3,A$171+1)))","v":6.5000000000000002E-2},{"$f":"IF(B176=\"\",\"\",$F$171*B176)","v":0},{"$f":"IF(C176=\"\",\"\",INT((C176+2.5)/5)*5)","v":0}]
[{"$f":"IF(ROW()-174>$A$171,\"\",ROW()-174)","v":3},{"$f":"IF(A177=\"\",\"\",IF(D$171=45%,VLOOKUP(A177,__pay5,A$171+1),VLOOKUP(A177,__pay3,A$171+1)))","v":0.06},{"$f":"IF(B177=\"\",\"\",$F$171*B177)","v":0},{"$f":"IF(C177=\"\",\"\",INT((C177+2.5)/5)*5)","v":0}]
[{"$f":"IF(ROW()-174>$A$171,\"\",ROW()-174)","v":4},{"$f":"IF(A178=\"\",\"\",IF(D$171=45%,VLOOKUP(A178,__pay5,A$171+1),VLOOKUP(A178,__pay3,A$171+1)))","v":0.06},{"$f":"IF(B178=\"\",\"\",$F$171*B178)","v":0},{"$f":"IF(C178=\"\",\"\",INT((C178+2.5)/5)*5)","v":0}]
[null,{"$f":"SUM(B175:B178)","v":0.255},{"$f":"SUM(C175:C178)","v":0},{"$f":"SUM(D175:D178)","v":0},{"$f":"SUM(E175:E178)","v":0}]
["GIRLS JR < 8",null,null,null,null,null,null,"BOYS JR < 8",null,null,null,null,null,null,"BOYS JR < 6"]
[null,null,null,null,"Enter Added Cash (or deduction) here* > ",0,null,null,null,null,null,"Enter Added Cash (or deduction) here* > ",0,null,null,null,null,null,"Enter Added Cash (or deduction) here* > ",0]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G49","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G43","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G44","v":0}]
[{"$f":"IF(D183=45%,VLOOKUP(C183,dbd,2,FALSE),IF(D183=33%,VLOOKUP(C183,dbe,2,FALSE),IF(D183=25%,VLOOKUP(C183,dbf,2,FALSE),IF(D183=20%,VLOOKUP(C183,dbg,2,FALSE),VLOOKUP(C183,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F49=0,91,Cover!F49)","v":91},0.25,"Net Purse: ",{"$f":"F182+F181","v":0},null,{"$f":"IF(K183=45%,VLOOKUP(J183,dbd,2,FALSE),IF(K183=33%,VLOOKUP(J183,dbe,2,FALSE),IF(K183=25%,VLOOKUP(J183,dbf,2,FALSE),IF(K183=20%,VLOOKUP(J183,dbg,2,FALSE),VLOOKUP(J183,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F43=0,91,Cover!F43)","v":91},0.25,"Net Purse: ",{"$f":"M182+M181","v":0},null,{"$f":"IF(R183=45%,VLOOKUP(Q183,dbd,2,FALSE),IF(R183=33%,VLOOKUP(Q183,dbe,2,FALSE),IF(R183=25%,VLOOKUP(Q183,dbf,2,FALSE),IF(R183=20%,VLOOKUP(Q183,dbg,2,FALSE),VLOOKUP(Q183,dbh,2,FALSE)))))","v":23},null,{"$f":"IF(Cover!F44=0,91,Cover!F44)","v":91},0.25,"Net Purse: ",{"$f":"T182+T181","v":0}]
[null,null,null,{"$f":"IF(C183=91,\"       To use this table, enter player divisions on Scores page\",IF(C183>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(J183=91,\"       To use this table, enter player divisions on Scores page\",IF(J183>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"},null,null,null,null,null,null,{"$f":"IF(Q183=91,\"       To use this table, enter player divisions on Scores page\",IF(Q183>22,\"Field limit exceeded. Use printed Payout tables.\",\"\"))","v":"       To use this table, enter player divisions on Scores page"}]
[null,"Prelim","Proposed","Round","Manual","Final",null,null,"Prelim","Proposed","Round","Manual","Final",null,null,"Prelim","Proposed","Round","Manual","Final"]
["Place","Factor","Payout $$","to $5","Adj. ","Place",null,"Place","Factor","Payout $$","to $5","Adj. ","Place",null,"Place","Factor","Payout $$","to $5","Adj. ","Place"]
[{"$f":"IF(ROW()-186>$A$183,\"\",ROW()-186)","v":1},{"$f":"IF(D$183=45%,VLOOKUP(A187,__pay5,A$183+1),VLOOKUP(A187,__pay3,A$183+1))","v":7.0000000000000007E-2},{"$f":"IF(B187=\"\",\"\",$F$183*B187)","v":0},{"$f":"IF(C187=\"\",\"\",INT((C187+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-186>$H$183,\"\",ROW()-186)","v":1},{"$f":"IF(K$183=45%,VLOOKUP(H187,__pay5,H$183+1),VLOOKUP(H187,__pay3,H$183+1))","v":7.0000000000000007E-2},{"$f":"IF(I187=\"\",\"\",$M$183*I187)","v":0},{"$f":"IF(J187=\"\",\"\",INT((J187+2.5)/5)*5)","v":0},null,null,null,{"$f":"IF(ROW()-186>$O$183,\"\",ROW()-186)","v":1},{"$f":"IF(R$183=45%,VLOOKUP(O187,__pay5,O$183+1),VLOOKUP(O187,__pay3,O$183+1))","v":7.0000000000000007E-2},{"$f":"IF(P187=\"\",\"\",$T$183*P187)","v":0},{"$f":"IF(Q187=\"\",\"\",INT((Q187+2.5)/5)*5)","v":0}]
[2,{"$f":"IF(A188=\"\",\"\",IF(D$183=45%,VLOOKUP(A188,__pay5,A$183+1),VLOOKUP(A188,__pay3,A$183+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(H188=\"\",\"\",IF(K$183=45%,VLOOKUP(H188,__pay5,H$183+1),VLOOKUP(H188,__pay3,H$183+1)))","v":6.5000000000000002E-2},0,0,null,null,null,2,{"$f":"IF(O188=\"\",\"\",IF(R$183=45%,VLOOKUP(O188,__pay5,O$183+1),VLOOKUP(O188,__pay3,O$183+1)))","v":6.5000000000000002E-2},0,0]
[3,0.06,0,0,null,null,null,3,0.06,0,0,null,null,null,3,0.06,0,0]
[4,0.06,0,0,null,null,null,4,0.06,0,0,null,null,null,4,0.06,0,0]
[5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,0,null,null,null,5,5.5E-2,0,0]
[6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,0,null,null,null,6,5.5E-2,0,0]
[7,0.05,0,0,null,null,null,7,0.05,0,0,null,null,null,7,0.05,0,0]
[8,0.05,0,0,null,null,null,8,0.05,0,0,null,null,null,8,0.05,0,0]
[9,0.05,0,0,null,null,null,9,0.05,0,0,null,null,null,9,0.05,0,0]
[10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0,null,null,null,10,4.4999999999999998E-2,0,0]
[11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,0,null,null,null,11,4.4999999999999998E-2,0,0]
[null,{"$f":"SUM(B187:B197)","v":0.60500000000000009},{"$f":"SUM(C187:C197)","v":0},{"$f":"SUM(D187:D197)","v":0},{"$f":"SUM(E187:E197)","v":0},null,null,null,{"$f":"SUM(I187:I197)","v":0.60500000000000009},{"$f":"SUM(J187:J197)","v":0},{"$f":"SUM(K187:K197)","v":0},{"$f":"SUM(L187:L197)","v":0},null,null,null,{"$f":"SUM(P187:P197)","v":0.60500000000000009},{"$f":"SUM(Q187:Q197)","v":0},{"$f":"SUM(R187:R197)","v":0},{"$f":"SUM(S187:S197)","v":0}]

{"sheet":"Finance","index":6,"n_rows":46,"n_cols":20,"rows_kept":46,"cut":false,"hidden":false,"merged":[[10,11,10,13],[10,7,10,9],[8,11,8,13],[3,2,3,4],[5,0,5,2],[5,7,5,9],[5,11,5,14],[9,11,9,13],[9,0,9,4],[7,7,7,9],[39,8,39,13],[37,8,37,13],[38,8,38,13],[28,8,28,13],[36,8,36,13],[31,8,31,13],[35,8,35,13],[34,8,34,13],[29,8,29,13],[30,8,30,13],[38,0,38,4],[35,0,35,4],[36,0,36,4],[27,0,27,4],[34,0,34,4],[33,0,33,4],[37,0,37,4],[28,0,28,4],[32,0,32,4],[15,11,15,14],[26,8,26,13],[25,0,25,4],[7,11,7,13],[15,0,15,2],[15,7,15,9],[8,7,8,9],[9,7,9,9],[10,0,10,4],[8,0,8,4],[7,0,7,4],[31,0,31,4],[27,8,27,13],[25,8,25,13],[20,0,20,15],[21,0,21,15],[23,8,23,9],[26,0,26,4],[11,0,11,4],[12,0,12,4],[45,8,45,13],[40,0,40,4],[39,0,39,4],[41,0,41,4],[42,0,42,4],[44,8,44,13],[42,8,42,13],[44,0,44,4],[41,8,41,13],[40,8,40,13],[13,0,13,4],[14,0,14,4],[11,7,11,9],[12,7,12,9],[13,7,13,9],[14,7,14,9]]}
["PDGA International Tour Event: Financial Summary",null,null,null,null,null,null,null,null,null,null,null,null,null,"Currency > ",{"$f":"IF(Cover!M7=\"\",\"\",Cover!M7)","v":"Euro €"},"  (see Cover page cell M7)"]
[]
[]
["Part 1:",null,"Sponsors",null,null,null,"Please list all sponsors and their contributions."]
[]
["Cash Sponsors",null,null,null,null,null,{"$f":"IF(P1=\"\",\"\",P1)","v":"Euro €"},"  Non Cash Sponsors",null,null,null,"Description of Donation",null,null,null,{"$f":"IF(P1=\"\",\"\",P1)","v":"Euro €"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Cash Sponsors",null,null,null,null,null,{"$f":"SUM(G8:G15)","v":0},null,null,null,null,"Total Non-Cash Sponsors",null,null,null,{"$f":"SUM(P8:P15)","v":0}]
[]
[]
["Part 2:",null,"Statement of Income and Expenses"]
[]
["Instructions : Only EuroTour Series & International Major events are required to complete this section.  "]
["Otherwise, this sheet is only provided to assist international TDs with the financial management of their event. "]
[]
["Income",null,null,null,null,null,{"$f":"IF(P1=\"\",\"\",P1)","v":"Euro €"},null,"Expenses",null,null,null,null,null,null,{"$f":"IF(P1=\"\",\"\",P1)","v":"Euro €"}]
[]
["Gross Pro Entry Fees",null,null,null,null,null,{"$f":"Cover!X7","v":0},null,"Total Pro Payout",null,null,null,null,null,null,{"$f":"Cover!M20","v":0}]
["Cash Sponsorships",null,null,null,null,null,{"$f":"+Finance!G16","v":0},null,"Pro Player Packs - Actual Cost"]
["Late Fees",null,null,null,null,null,null,null,"Amateur Prizes - Actual Cost"]
["Gross Amateur Entry Fees",null,null,null,null,null,{"$f":"Cover!X8","v":0},null,"Amateur Player Packs - Actual Cost"]
["Gross Junior Entry Fees",null,null,null,null,null,{"$f":"Cover!X9","v":0},null,"Other Cash Prizes: Skins, etc."]
["Non-Cash Sponsorships Value",null,null,null,null,null,{"$f":"+Finance!P16","v":0},null,"Other Prizes: CTPs, etc.- Actual Cost"]
["Other Cash: Raffles, Contests, etc.",null,null,null,null,null,null,null,"Sponsor Costs: Signs, Banners, Shirts"]
[null,null,null,null,null,null,null,null,"Trophies"]
[null,null,null,null,null,null,null,null,"PDGA Player Fees",null,null,null,null,null,null,{"$f":"IF(Cover!M8=\"Yes\",Cover!M51,0)","v":0}]
["Ace Pool Collected",null,null,null,null,null,null,null,"Ace Pool",null,null,null,null,null,null,{"$f":"G35","v":0}]
[null,null,null,null,null,null,null,null,"PDGA Sanctioning/Insurance"]
[null,null,null,null,null,null,null,null,"Park Permits",null,null,null,null,null,null,null,null,"# of players",null,"Fee each"]
[null,null,null,null,null,null,null,null,"Regional Series Fees",null,null,null,null,null,null,{"$f":"R38*T38","v":0},"=",null,"X"]
[null,null,null,null,null,null,null,null,"Local Club Fees",null,null,null,null,null,null,{"$f":"R39*T39","v":0},"=",null,"X"]
["Merchandise Sales",null,null,null,null,null,null,null,"Cost of Merchandise"]
["Food & Beverage Sales",null,null,null,null,null,null,null,"Food & Beverage Costs"]
["Other Income : please specify",null,null,null,null,null,null,null,"Other Expense : please specify"]
[null,null,null,null,null,null,null,null,"TD Fee (if not donated)"]
[]
["Total Income",null,null,null,null,null,{"$f":"SUM(G26:G43)","v":0},null,"Total Expenses",null,null,null,null,null,null,{"$f":"SUM(P26:P43)","v":0}]
[null,null,null,null,null,null,null,null,"NET:  PROFIT or (LOSS)",null,null,null,null,null,null,{"$f":"G45-P45","v":0}]

{"sheet":"SupportData","index":7,"n_rows":40,"n_cols":7,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["This worksheet contains data used by other worksheets and formulas in this file."]
["Please do not delete this worksheet or modify any data on it."]
[]
["Divcode",null,"Tier","Code","Fee","Tier 1","Tier 2"]
["MPO",null,"NT",1,5,"NT"]
["MPM",null,"A / XA",2,4,"A / XA"]
["MPG",null,"B / XB",3,3,"B / XB"]
["MPS",null,"C / XC",4,2,"C / XC"]
["MPL",null,"D",5,2,"D"]
["MPE",null,"A Pro / B Am",9,null,"Pro A","Am B"]
["MPR",null,"A Pro / C Am",10,null,"Pro A","Am C"]
["FPO",null,"B Pro / C Am",11,null,"Pro B","Am C"]
["FPM",null,"A Am / B Pro",12,null,"Am A","Pro B"]
["FPG",null,"A Am / C Pro",13,null,"Am A","Pro C"]
["FPS",null,"B Am / C Pro",14,null,"Am B","Pro C"]
["FPL"]
["MA1"]
["MA2"]
["MA3",null,"Pro A",null,4]
["MA4",null,"Pro B",null,3]
["MM1",null,"Pro C",null,2]
["MG1",null,"Am A",null,4]
["MS1",null,"Am B",null,3]
["ML1",null,"Am C",null,2]
["FA1"]
["FA2",null,null,{"$f":"IF(Cover!$Q7=\"\",\"\",VLOOKUP(Cover!$Q7,tierDB,2,FALSE))","v":""},null,{"$f":"IF(Cover!$Q7=\"\",\"\",VLOOKUP(Cover!$Q7,tierDB,4,FALSE))","v":""},{"$f":"IF(Cover!$Q7=\"\",\"\",VLOOKUP(Cover!$Q7,tierDB,5,FALSE))","v":""}]
["FA3"]
["FA4"]
["FM1"]
["FG1"]
["FS1"]
["FL1"]
["MJ1"]
["MJ2"]
["MJ3"]
["MJ4"]
["FJ1"]
["FJ2"]
["FJ3"]
["FJ4"]