{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Cover","Event Info","Scores","Pro.Payouts","Unified.Payouts","Finance","$10 Fees","Membership Form","Memberships","Evaluation Form","SupportData"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":69,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":95,"n_cols":3,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Guide to the PDGA Ratings Based Event Report - Excel"]
[null,null,{"$f":"CONCATENATE(\"Version \",Cover!A1)","v":"Version 17-R1a"}]
[null,null,"Dear PDGA Tournament Director,"]
[]
[null,null,"Thanks for directing a PDGA Ratings based event! The TD report has been updated to MS Excel 2007+"]
[null,null,"and serves as a key component of the PDGA's database system. All TDs are expected to use this "]
[null,null,"tool and to return their completed event report to the PDGA office by email as an attached file as soon"]
[null,null,"as possible. This will speed the processing of your event including the posting of official results at"]
[null,null,"www.pdga.com, and the calculation of player statistics including points, pro cash won and player"]
[null,null,"ratings."]
[]
[null,"Instructions:","TDs who do not have Excel* or are unable to report in this format are requested to forward this file and"]
[null,null,"assign the task of reporting to a local club member or event volunteer who has the appropriate computer"]
[null,null,"capabilities. The PDGA office will accept results in alternative computerized or handwritten documents"]
[null,null,"that are mailed in, however TDs who do so will be required to include a $25 processing fee."]
[null,null,"The report is currently not available in Open Office format."]
[]
[]
[null,null,"The presentation of the report is similar to previous years. Please begin by filling in the Player Names, "]
[null,null,"Division Codes 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,null,"of your screen. To simplify data entry, TDs should only enter information in the yellow boxes. All other parts of"]
[null,null,"the spreadsheet are locked. The green boxes are automated calculations, and the red text sections are areas"]
[null,null,"for PDGA office use only. If your info does not fit in the space provided, try using smaller sized text. "]
[]
[null,null,"Please note that certain details are essential for accurate data entry and for determining course and player "]
[null,null,"ratings. On the Event Info sheet this includes the order of course layouts played by the different divisions,"]
[null,null,"tiebreakers for 1st place, and the identification of players who decline pro cash. On the Scores sheet "]
[null,null,"please be sure to include player PDGA#s, the place of finish for all players, and account for all ties in the"]
[null,null,"places of finish and in the breakdown of the pro purse and mixed prize value."]
[null,null,"Please also note that per PDGA Rules of Play, all ties for 1st place must be broken, and a winner declared."]
[]
[]
[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,"Event Info:","2 pages providing general information on the event. Beyond courses played and highlights of the competition,"]
[null,null,"this worksheet is where any disqualifications and other problems should be outlined."]
[]
[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: The list of Division codes used by the PDGA is shown at the top of the worksheet, please use"]
[null,null,"these codes to designate each player's division. "]
[null,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,"& Unified","Cover sheet for each division being hosted. Note: Entry fee boxes must be filled in on the Cover sheet"]
[null,"Payouts","before going to the Pro.Payout & Unified.Payout sheets. Then, just enter the amount of net cash added or"]
[null,null,"subtracted (overhead allocation) for each division and the program will calculate both exact and rounded off "]
[null,null,"payout values. The payout tables allow the TD to select 40%, 45%, or 50% payout for pro divisions and 45%"]
[null,null,"or 50% for Mixed. We encourage TDs to consider using 45% or 50% with added cash for pros and promote"]
[null,null,"that your event will use deeper pro payouts as a way to encourage more players to enter Pro divisions."]
[null,null,"The Manual Adj. & Final Place columns let TDs adjust payouts to account for ties. For Mixed divisions, the"]
[null,null,"dollar amounts and \"added cash\" for the payouts are based on retail merchandise values."]
[]
[]
[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. You are not required to complete and submit this section."]
[]
[null,"Memberships:","Please type in the details on all PDGA memberships paid at the event and include with your electronic report."]
[]
[null,"$10 Fees:","Details on non-current players paying this fee. Print copies of this sheet and get the players to complete it !"]
[null,null,"Please review the information regarding the new membership discount at the top of the $10 fees worksheet."]
[]
[null,"Forms:","For printing  PDGA membership and event evaluation forms in case the TD needs more than provided."]
[]
[]
[null,"TD Package:","In addition to this report TDs should receive the following items as part of their package: Rule books, "]
[null,null,"stickers, brochures, member forms, \"Soft Cards\" (receipts for membership), Pay Tables, current member"]
[null,null,"list tailored to your event (by email), and a list of approved discs and targets. "]
[]
[null,"Changes:","- Current membership is required in order to play in Major, SuperTour (A Tier) or National Tour events"]
[null,null,"- For B & C tier events the $10 fee for non-members and non-currents extends to ALL divisions except Juniors"]
[null,null,"- The per player fee extends to ALL divisions, per Tier these fees are A-$4 B-$3 & C-$2"]
[]
[null,"Remember:","- The expectations and requirements of Tour events are described in the Sanctioning Agreement/Tour Standards"]
[null,null,"- Please alert us if your mailing or email address has recently changed"]
[]
[null,"Report","Once you have completed the Tour Event Report please return it as an email attachment to tourmgr@pdga.com"]
[null,"Submission:","TDs can either mail the player fees and membership fees collected to the PDGA office at:"]
[null,null,"PDGA, Wildwood Park, 3828 Dogwood Lane, Appling, GA 30802-3004  "]
[null,null,"or pay using PayPal at www.pdga.com/tdpayment"]
[]
[null,null,"Per the terms of the  PDGA Tour Sanctioning Agreement, SuperTour (A Tier) events must submit "]
[null,null,"TD reports by email within 48 hours after the event. B-tiers now have one week and C Tier have two weeks  "]
[null,null,"to submit this information. ALL events must submit any fees due within 30 day after the event."]
[]
[null,"Questions ? ","Contact the PDGA Office at (706) 261-6342. Thanks and good luck on Tour !"]
[null,"TDR2017","tdreport@pdga.com"]

{"sheet":"Cover","index":1,"n_rows":49,"n_cols":26,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,13,48,17],[27,14,27,19],[6,16,6,18],[5,25,5,27],[7,25,7,27],[8,25,8,27],[9,25,9,27],[6,25,6,27],[11,25,11,27],[1,8,1,19],[14,15,14,19],[3,15,3,16],[5,14,5,17],[3,18,3,19],[8,15,8,19],[2,25,2,27],[3,25,3,27],[18,14,18,19],[10,25,10,27],[12,25,12,27],[13,25,13,27],[9,15,9,19],[4,25,4,27]]}
["17-R1a"]
["            Ratings Based Event Report",null,null,null,null,null,null,"Event: "]
[null,"Enter fees 'per player' in the yellow boxes. Green boxes are protected cells and only filled automatically.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE"]
[null,"Note new options for Other Fees",null,null,null,null,null,null,null,null,null,null,null,null,"Date(s): ",null,null,"to",null,null,null,null,null,null,null,"Type only in white"]
[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",null,"or yellow boxes"]
["PROS","Entry","Fee","Fees","Entry","Plyrs","Entry Fees",null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(C7:M46,#N/A)>0,\"ENTER TIER LEVEL!\",\"\")","v":""},null,null,null,null,null,null,null,null,"Entry Fees",null,"DO NOT TYPE IN"]
["GOLD - Open",null,{"$f":"IF(AND(tier1<>\"\",F7>0),VLOOKUP(tier1,tierDB,3,FALSE),0)","v":0},null,{"$f":"B7-C7-D7","v":0},{"$f":"COUNTIF(Division,\"RPA\")","v":0},{"$f":"F7*E7","v":0},null,null,null,null,null,null,null,null,"Tier: ","C / XC",null,null,null,null,null,"Pro",{"$f":"SUM(B7:B18*F7:F18)","v":0},null,"BLUE OR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unified",{"$f":"SUM(B21:B35*F21:F35)","v":0},null,"GREEN BOXES!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TD Name: ",null,null,null,null,null,null,null,null,null,null,"These all use"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email Addr: ","@",null,null,null,null,null,null,null,{"$f":"SUM(X7:X9)","v":0},null,"automatic entries"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TD PDGA#: ",null,null,null,"State: ",null,null,null,null,null,null,"Do not insert or"]
[null,null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cells postitioned"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"for data importing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"City: ",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(I21:M34,#N/A)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary of Players, Entry Fees, & Payout"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Players",null,null,null,null,{"$f":"F19+F37","v":0}]
["PRO Totals",null,null,null,null,{"$f":"SUM(F7:F18)+SUM(L7:L17)","v":0},{"$f":"SUM(G7:G18)+SUM(M7:M15)","v":0},null,null,null,null,null,null,null,"PRO DIVISIONS"]
["UNIFIED DIVISIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Pro Cash Purse Paid Out"]
["BLUE          < 970",null,{"$f":"IF(AND(tier2<>0,F21>0),VLOOKUP(tier2,tierDB,3,FALSE),IF(AND(tier1<>\"\",F21>0),VLOOKUP(tier1,tierDB,3,FALSE),0))","v":0},null,{"$f":"B21-C21-D21","v":0},{"$f":"COUNTIF(Division,\"RAH\")","v":0},{"$f":"F21*E21","v":0},null,null,null,null,null,null,null,"Total Pro Net Entry Fees",null,null,null,null,{"$f":"G19","v":0},null,null,{"$f":"IF(T21>0,T20/T21,\"\")","v":""}]
["WHITE        < 935",null,{"$f":"IF(AND(tier2<>0,F22>0),VLOOKUP(tier2,tierDB,3,FALSE),IF(AND(tier1<>\"\",F22>0),VLOOKUP(tier1,tierDB,3,FALSE),0))","v":0},null,{"$f":"B22-C22-D22","v":0},{"$f":"COUNTIF(Division,\"RAD\")","v":0},{"$f":"F22*E22","v":0},null,null,null,null,null,null,null,"Net Cash Added to Purse",null,null,null,null,{"$f":"T20-T21","v":0}]
["RED            < 900",null,{"$f":"IF(AND(tier2<>0,F23>0),VLOOKUP(tier2,tierDB,3,FALSE),IF(AND(tier1<>\"\",F23>0),VLOOKUP(tier1,tierDB,3,FALSE),0))","v":0},null,{"$f":"B23-C23-D23","v":0},{"$f":"COUNTIF(Division,\"RAE\")","v":0},{"$f":"F23*E23","v":0},null,null,null,null,null,null,null,"Pro Player Packs - $ Value"]
["GREEN       < 850",null,{"$f":"IF(AND(tier2<>0,F24>0),VLOOKUP(tier2,tierDB,3,FALSE),IF(AND(tier1<>\"\",F24>0),VLOOKUP(tier1,tierDB,3,FALSE),0))","v":0},null,{"$f":"B24-C24-D24","v":0},{"$f":"COUNTIF(Division,\"RAF\")","v":0},{"$f":"F24*E24","v":0},null,null,null,null,null,null,null,"Pro Trophies - $ Value"]
["PURPLE     < 800",null,{"$f":"IF(AND(tier2<>0,F25>0),VLOOKUP(tier2,tierDB,3,FALSE),IF(AND(tier1<>\"\",F25>0),VLOOKUP(tier1,tierDB,3,FALSE),0))","v":0},null,{"$f":"B25-C25-D25","v":0},{"$f":"COUNTIF(Division,\"RAG\")","v":0},{"$f":"F25*E25","v":0},null,null,null,null,null,null,null,"Other Pro Prizes $ (CTPs etc)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pro Event Value",null,null,null,{"$f":"SUM(T20,T23,T24,T25)","v":0},null,null,{"$f":"IF(T21>0,T26/T21,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UNIFIED DIVISIONS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Unified Net Entry Fees",null,null,null,null,{"$f":"G37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unified Prizes + Trophies - $ Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unified Player Packs - $ Value"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Unified Prizes $ (CTPs etc)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Unified Event Value",null,null,null,{"$f":"SUM(T30:T32)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T29>0,T33/T29,\"\")","v":""}]
[]
["OTHER Totals",null,null,null,null,{"$f":"SUM(F21:F36)+SUM(L21:L36)","v":0},{"$f":"SUM(G21:G36)+SUM(M21:M36)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Total Tour Event Value",null,null,null,{"$f":"SUM(T26,T33)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Collected for the PDGA"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(tier1=\"\",\"\",tier1&\" tier\")","v":"C / XC tier"},null,"# Pro Players",{"$f":"F19","v":0},"x",{"$f":"IF(tier1=\"\",0,VLOOKUP(tier1,tierDB,3,FALSE))","v":2},"=",{"$f":"P41*R41","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(tier2=0,tier2=\"\"),\"\",tier2&\" tier\")","v":""},null,"# Unified Plyrs",{"$f":"F37","v":0},"x",{"$f":"IF(AND(tier2<>0,tier2<>\"\"),VLOOKUP(tier2,tierDB,3,FALSE),IF(tier1<>\"\",VLOOKUP(tier1,tierDB,3,FALSE),0))","v":2},"=",{"$f":"P42*R42","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SupportData!D26=5,\"D-tier three-month members\",\"Non or Non-current Members\")","v":"Non or Non-current Members"},null,null,null,"x",10,"=",{"$f":"P43*R43","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total $ PDGA Memberships & Renewals Collected",null,null,null,null,null,null,{"$f":"Memberships!A40","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"$25 fee if results/TD Report not submitted electronically"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  Total Payable to PDGA:",null,null,null,{"$f":"SUM(T41:T46)","v":0}]
[null,null,null,null,null,null,null,"Please mail a check or money order to the PDGA office for this amount. Or,"]
[null,null,null,null,null,null,null,"TDs can pay fees after event online at:",null,null,null,null,null,"www.pdga.com/tdpayment"]

{"sheet":"Event Info","index":2,"n_rows":100,"n_cols":18,"rows_kept":100,"cut":false,"hidden":false,"merged":[[32,0,36,0],[29,0,31,0],[100,1,100,15],[101,1,101,15],[55,1,55,15],[41,1,41,15],[39,1,39,15],[45,4,45,5],[45,6,45,7],[46,1,46,3],[36,1,36,3],[40,1,40,15],[56,1,56,15],[45,14,45,15],[51,1,51,3],[47,1,47,3],[102,1,102,15],[70,1,70,15],[57,1,57,15],[61,1,61,15],[62,1,62,15],[63,1,63,15],[79,1,79,8],[79,10,79,15],[72,1,72,15],[73,1,73,15],[71,1,71,15],[64,1,64,15],[48,1,48,3],[49,1,49,3],[50,1,50,3],[12,11,12,13],[13,11,13,13],[14,11,14,13],[15,11,15,13],[32,1,32,3],[33,1,33,3],[29,1,29,3],[16,11,16,13],[20,11,20,13],[21,11,21,13],[8,5,8,9],[8,11,8,13],[9,11,9,13],[10,11,10,13],[11,11,11,13],[17,17,17,19],[19,11,19,13],[35,1,35,3],[21,17,21,19],[18,17,18,19],[19,17,19,19],[20,17,20,19],[18,11,18,13],[17,11,17,13],[34,1,34,3],[14,17,14,19],[15,17,15,19],[16,17,16,19],[10,17,10,19],[11,17,11,19],[12,17,12,19],[13,17,13,19]]}
[" PDGA Tour Event Report: General Information"]
[]
["1.","Course Layouts",null,"Link to PDGA Course Directory >",null,"www.pdga.com/course-directory"]
[]
[null,"It is important you complete the following information accurately so your players get correct ratings."]
[null,"If you have any questions, please contact the PDGA office: ",null,null,null,"tdreport@pdga.com"]
[null,"Please remove any apostrophes in course names or words even if it's that way in the directory!"]
[]
["Layout",null,null,null,null,"Number of Holes",null,null,null,null,null,"Length",null,null,null,"Meas."]
["Code","Park or Course Name",null," Specific Layout / Configuration Name",null,"Perm",null,"Temp",null,"TOT",null,"(feet)",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,{"$f":"IF(AND(OR(B11<>\"\",D11<>\"\"),OR(J11=\"\",L11=\"\",P11=\"\")),\"< Please enter all info requested\",\"\")","v":""},"NOTE"]
["B",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(AND(B12<>\"\",OR(J12=\"\",L12=\"\",P12=\"\")),\"< Please enter all info requested\",\"\")","v":""},"Type only in white"]
["C",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(AND(B13<>\"\",OR(J13=\"\",L13=\"\",P13=\"\")),\"< Please enter all info requested\",\"\")","v":""},"or yellow boxes"]
["D",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(AND(B14<>\"\",OR(J14=\"\",L14=\"\",P14=\"\")),\"< Please enter all info requested\",\"\")","v":""},"DO NOT TYPE IN"]
["E",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(AND(B15<>\"\",OR(J15=\"\",L15=\"\",P15=\"\")),\"< Please enter all info requested\",\"\")","v":""},"BLUE OR"]
["F",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,{"$f":"IF(AND(B16<>\"\",OR(J16=\"\",L16=\"\",P16=\"\")),\"< Please enter all info requested\",\"\")","v":""},"GREEN BOXES!"]
["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,"These all use"]
["H",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"automatic entries"]
["I",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"Do not insert or"]
["J",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"delete rows. All "]
["K",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"cells postitioned"]
["L",null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"for data importing"]
[]
["2.","Layouts Played by Division by Round - Do not include rounds with fewer than 13 holes!"]
[]
[null,"Enter the proper course layout code letter from above for each round played by each division listed."]
[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,"Course Layout Code",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,"Final",null,"Code"]
["PRO","RPA - GOLD - Open   970+",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Cover!F7>0,Cover!L7>0),LEFT(B30,3),\"\")","v":""},{"$f":"IF(AND(P30<>\"\",COUNTA(F30:N30)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(P31<>\"\",COUNTA(F31:N31)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(P32<>\"\",COUNTA(F32:N32)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
["UNIFIED","RAH - BLUE       < 970",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Cover!F21>0,Cover!L21>0),LEFT(B33,3),\"\")","v":""},{"$f":"IF(AND(P33<>\"\",COUNTA(F33:N33)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"RAD - WHITE     < 935",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Cover!F22>0,Cover!L22>0),LEFT(B34,3),\"\")","v":""},{"$f":"IF(AND(P34<>\"\",COUNTA(F34:N34)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"RAE - RED         < 900",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Cover!F23>0,Cover!L23>0),LEFT(B35,3),\"\")","v":""},{"$f":"IF(AND(P35<>\"\",COUNTA(F35:N35)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"RAF - GREEN    < 850",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Cover!F24>0,Cover!L24>0),LEFT(B36,3),\"\")","v":""},{"$f":"IF(AND(P36<>\"\",COUNTA(F36:N36)<COUNT(Scores!G$10:K$10)),\" < Course layout may be missing\",\"\")","v":""}]
[null,"RAG - PURPLE  < 800",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Cover!F25>0,Cover!L25>0),LEFT(B37,3),\"\")","v":""},{"$f":"IF(AND(P37<>\"\",COUNTA(F37:N37)<COUNT(Scores!G$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,"Upon completion of the Event Report please send a copy by email as an attached file to the PDGA at:"]
[null,"tdreport@pdga.com "]
[]
[null,"Payments may be made online or sent by mail. For online payments, go to:"]
[null,"http://www.pdga.com/tdpayment"]
[]
[null,"Send payments by mail to:"]
[null,"PDGA, Wildwood Park, 3828 Dogwood Lane, Appling, GA 30802"]
[]
[null,"Per the terms of PDGA Tour Sanctioning Agreement, all TD reports and fees are due no more than one"]
[null,"month after an event. Questions? Contact the PDGA Office at (706) 261-6342. Thanks for a job well done!"]
[]
[]
["Press Release (Optional)"]
[null,"Many TDs submit summaries of their events to local media, and the disc golf press. This might include a synopsis of the competition"]
[null,"and its highlights (great rounds, final nine, unusual aces, big comebacks, etc), recognition of sponsors, charity and celebrity involvement,"]
[null,"number of spectators, TV and radio on-site coverage, etc. Please feel free to use more space than is provided below, and send copies"]
[null,"of items such as newspaper articles, programs, scorecards, and photos to the PDGA office. Thanks very much!"]

{"sheet":"Scores","index":3,"n_rows":500,"n_cols":20,"rows_kept":500,"cut":false,"hidden":false,"merged":[[39,19,39,21],[0,16,0,22],[36,16,36,18],[36,19,36,21],[37,16,37,18],[37,19,37,21],[33,16,34,18],[35,16,35,18],[35,19,35,21],[38,16,38,18],[38,19,38,21],[0,3,0,8],[2,16,4,26],[34,19,34,21],[6,16,6,26],[33,19,33,21],[0,11,0,13]]}
["Tour Event Name:",null,null,{"$f":"IF(Cover!I2=\"\",\"\",Cover!I2)","v":""},null,null,null,null,null,null,"Dates:",{"$f":"IF(Cover!P4=\"\",\"\",Cover!P4)","v":""},null,null,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,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",null,null,null,null,null,null,null,null,null,null,null,null," Use Special Sort button above when"]
["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,"your Event has Semi or Final round."]
["Click button to upload scores",null,null,null,null,null,null,"Use Basic Sort button after Rd1 thru  >",null,null,null,null,null,"You MUST enter Final rankings in Place"]
[null,null,null,null,null,null,null,"Rd4. Use Special Sort if Final round.    ",null,null,null,null,null,"column for players in Semi/Final.",null,null,"  Division Codes: Use the following 3 digit codes in the DivCode field."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Am Cash"]
["DivCode",null,"Place","First Name","Last Name","PDGA","Rd1","Rd2","Rd3","Rd4","Final","Total","Cash/Value","Decline?",null,null,"PRO DIVISIONS - Cash Payout"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G10:K10)=0,\"\",IF(SUM(G10:K10)>=888,\"DNF\",SUM(G10:K10)))","v":""},null,null,null,null,"RPA","GOLD - Open",null,"970+"]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"UNIFIED DIVISIONS - Merch Payout"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"RAH","BLUE",null,"< 970"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"RAD","WHITE",null,"< 935"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"RAE","RED",null,"< 900"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"RAF","GREEN",null,"< 850"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"RAG","PURPLE",null,"< 800"]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"Instructions"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,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,null,null,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,null,null,null," - TOTAL column L adds up round scores automatically"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,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,null,null,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,null,null,null," - Be sure to include the amounts of pro cash won in the Cash/Value column if event had Pro cash payout"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null," - DO NOT include prize values in Cash/Value 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,null,null,null,"       value in cell T23 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,null,null,null," - Use a Sort button to sort players by division and score so places of finish reflect their place within their division"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"       only and not their place within the overall event."]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null," - In column N, enter Yes for each amateur who declined accepting cash payout."]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"NOTES",null,null,"Type only in white"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"or yellow boxes"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"Do not insert or",null,null,"DO NOT TYPE IN"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"delete rows. All ",null,null,"BLUE OR"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"cells positioned",null,null,"GREEN BOXES!"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"for data importing",null,null,"These all use"]
[null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"automatic entries"]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G74:K74)=0,\"\",IF(SUM(G74:K74)>=888,\"DNF\",SUM(G74:K74)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G138:K138)=0,\"\",IF(SUM(G138:K138)>=888,\"DNF\",SUM(G138:K138)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G202:K202)=0,\"\",IF(SUM(G202:K202)>=888,\"DNF\",SUM(G202:K202)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G266:K266)=0,\"\",IF(SUM(G266:K266)>=888,\"DNF\",SUM(G266:K266)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G330:K330)=0,\"\",IF(SUM(G330:K330)>=888,\"DNF\",SUM(G330:K330)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G394:K394)=0,\"\",IF(SUM(G394:K394)>=888,\"DNF\",SUM(G394:K394)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(G458:K458)=0,\"\",IF(SUM(G458:K458)>=888,\"DNF\",SUM(G458:K458)))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Pro.Payouts","index":4,"n_rows":73,"n_cols":47,"rows_kept":73,"cut":false,"hidden":false,"merged":[[30,0,30,5],[29,0,29,5],[72,0,72,5]]}
[null,null,null,null,null,null,null,null,"Field","# paid"]
[null,null,null,null,null,null,null,null,null,40,45,50]
[null,null,null,null,null,null,null,null,1,1,1,1,null,"Number of Places Paid"]
[null,null,null,null,null,null,null,null,2,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,null,null,null,null,null,null,null,3,1,1,2,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,null,null,null,null,null,null,null,4,2,2,2,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]
[null,null,null,null,null,null,null,null,5,2,2,3,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]
[null,null,null,null,null,null,null,null,6,2,3,3,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]
[null,null,null,null,null,null,null,null,7,3,3,4,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]
[null,null,null,null,null,null,null,null,8,3,4,4,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]
[null,null,null,null,null,null,null,null,9,4,4,5,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]
[null,null,null,null,null,null,null,null,10,4,5,5,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]
[null,null,null,null,null,null,null,null,11,4,5,6,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]
[null,null,null,null,null,null,null,null,12,5,6,6,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]
[null,null,null,null,null,null,null,null,13,5,6,7,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]
[null,null,null,null,null,null,null,null,14,6,6,7,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]
[null,null,null,null,null,null,null,null,15,6,7,8,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]
[null,null,null,null,null,null,null,null,16,6,7,8,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,null,null,null,null,null,null,null,17,7,8,9,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,null,null,null,null,null,18,7,8,9,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,null,19,8,9,10,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,20,8,9,10,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,null,21,8,10,11,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,null,22,9,10,11,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,23,9,10,12,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,24,10,11,12,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,null,25,10,11,13,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,null,26,10,12,13,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,null,27,11,12,14,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]
["Click Here > Large Field Payout Calculator",null,null,null,null,null,null,null,28,11,13,14,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]
["GOLD (OPEN) DIVISION",null,null,null,null,null,null,null,29,12,13,15,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,"Enter Added Cash (or deduction) here* > ",0,null,null,30,12,14,15,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+Cover!M7","v":0},null,null,31,12,14,16,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+ROUNDDOWN(Cover!L7/3,0))","v":91},null,"Net Purse: ",{"$f":"F33+F32","v":0},null,null,32,13,15,16,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=45%,3,IF(E35=50%,4,2))","v":2},null,"Choose Payout Percentage>",0.4,null,null,null,33,13,15,17,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","Manual","Final",null,null,34,14,15,17,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","Payout $$","to $5","Adj. ","Place",null,null,35,14,16,18,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,null,36,14,16,18]
[{"$f":"IF(ROW()-37>$A$34,\"\",ROW()-37)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(B39=\"\",\"\",$F$34*B39)","v":{"$error":"#N/A"}},{"$f":"IF(C39=\"\",\"\",INT((C39+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,null,37,15,17,19]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,38,15,17,19]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,39,16,18,20]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,40,16,18,20]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,41,16,19,21]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,42,17,19,21]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,43,17,19,22]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,44,18,20,22]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,45,18,20,23]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,46,18,21,23]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,47,19,21,24]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,48,19,22,24]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,49,20,22,25]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,50,20,23,25]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,51,20,23,26]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,52,21,23,26]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,53,21,24,27]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,54,22,24,27]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,55,22,25,28]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,56,22,25,28]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,57,23,26,29]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,58,23,26,29]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,59,24,27,30]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,60,24,27,30]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,61,24,28,31]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,62,25,28,31]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,63,25,28,32]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,64,26,29,32]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,65,26,29,33]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,66,26,30,33]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,67,27,30,34]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,68,27,31]
[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,69,28,31]
["* Can be a negative number when expenses like trophies involved",null,null,null,null,null,null,null,70,28,32]
["Click Here > Large Field Payout Calculator",null,null,null,null,null,null,null,71,28,32]

{"sheet":"Unified.Payouts","index":5,"n_rows":148,"n_cols":61,"rows_kept":148,"cut":false,"hidden":false,"merged":[[147,14,147,19],[128,14,128,19],[86,0,86,5],[0,0,0,5],[0,7,0,12],[21,7,21,12],[41,0,41,5],[84,0,84,5],[43,0,43,5]]}
["BLUE DIVISION",null,null,null,null,null,null,"PURPLE 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,null,null,0.5,null,null,0.45]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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"]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G21+Cover!M21","v":0},null,"# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G25+Cover!M25","v":0}]
[{"$f":"IF(D4=45%,VLOOKUP(C4,dbd,2,FALSE),VLOOKUP(C4,dbe,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F21=0,91,Cover!F21+ROUNDDOWN(Cover!L21/3,0))","v":91},0.45,"Net Purse: ",{"$f":"F3+F2","v":0},null,{"$f":"IF(K4=45%,VLOOKUP(J4,dbd,2,FALSE),VLOOKUP(J4,dbe,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F25=0,91,Cover!F25+ROUNDDOWN(Cover!L25/3,0))","v":91},0.45,"Net Purse: ",{"$f":"M3+M2","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,1,1,null,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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]
[null,"Prelim","Proposed","Round","Manual","Final",null,null,"Prelim","Proposed","Round","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,null,null,3,2,null,3,1]
["Place","Factor","Payout $$","to $5","Adj. ","Place",null,"Place","Factor","Payout $$","to $5","Adj. ","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,null,null,4,2,null,4,2]
[{"$f":"IF(ROW()-7>$A$4,\"\",ROW()-7)","v":{"$error":"#N/A"}},{"$f":"IF(A8>$A$4,\"\",IF(D$4=45%,VLOOKUP(A8,__pay5,$A$4+1),VLOOKUP(A8,__pay3,$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(K$4=45%,VLOOKUP(H8,__pay5,$H$4+1),VLOOKUP(H8,__pay3,$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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,3,null,5,2]
[{"$error":"#N/A"},{"$f":"IF(A9=\"\",\"\",IF(D$4=45%,VLOOKUP(A9,__pay5,A$4+1),VLOOKUP(A9,__pay3,A$4+1)))","v":{"$error":"#N/A"}},{"$f":"IF(B9=\"\",\"\",$F$4*B9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,{"$error":"#N/A"},{"$f":"IF(H9=\"\",\"\",IF(K$4=45%,VLOOKUP(H9,__pay5,H$4+1),VLOOKUP(H9,__pay3,H$4+1)))","v":{"$error":"#N/A"}},{"$f":"IF(I9=\"\",\"\",$M$4*I9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,3,null,6,3]
[{"$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,null,null,null,null,null,null,null,null,null,null,null,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,4,null,7,3]
[{"$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,null,null,null,null,null,null,null,null,null,null,null,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,4,null,8,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,5,null,9,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,5,null,10,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,6,null,11,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,6,null,12,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,7,null,13,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,7,null,14,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8,null,15,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,8,null,16,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,9,null,17,8]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,{"$f":"SUM(I8:I20)","v":{"$error":"#N/A"}},{"$f":"SUM(J8:J20)","v":{"$error":"#N/A"}},{"$f":"SUM(K8:K20)","v":{"$error":"#N/A"}},{"$f":"SUM(L8:L20)","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,18,9,null,18,8]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"Click Here > Large Field Payout Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,10,null,19,9]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,10,null,20,9]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,11,null,21,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,11,null,22,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,12,null,23,10]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,12,null,24,11]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,13,null,25,11]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,13,null,26,12]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,14,null,27,12]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,14,null,28,13]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,15,null,29,13]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,15,null,30,14]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,16,null,31,14]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,16,null,32,15]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,17,null,33,15]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,17,null,34,15]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,18,null,35,16]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,18,null,36,16]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,19,null,37,17]
[null,{"$f":"SUM(B8:B40)","v":{"$error":"#N/A"}},{"$f":"SUM(C8:C40)","v":{"$error":"#N/A"}},{"$f":"SUM(D8:D40)","v":{"$error":"#N/A"}},{"$f":"SUM(E8:E40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,19,null,38,17]
["Click Here > Large Field Payout Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,20,null,39,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,40,20,null,40,18]
["WHITE DIVISION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,21,null,41,19]
[null,null,null,null,"Enter Added Cash (or deduction) here* > ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,null,42,21,null,42,19]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G22+Cover!M22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,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,43,22,null,43,19]
[{"$f":"IF(D47=45%,VLOOKUP(C47,dbd,2,FALSE),VLOOKUP(C47,dbe,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F22=0,91,Cover!F22+ROUNDDOWN(Cover!L22/3,0))","v":91},0.45,"Net Purse: ",{"$f":"F46+F45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,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,44,22,null,44,20]
[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,null,null,null,null,null,null,null,null,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,23,null,45,20]
[null,"Prelim","Proposed","Round","Manual","Final",null,null,null,null,null,null,null,null,null,null,null,null,null,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,46,23,null,46,21]
["Place","Factor","Payout $$","to $5","Adj. ","Place",null,null,null,null,null,null,null,null,null,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,47,24,null,47,21]
[{"$f":"IF(ROW()-50>$A$47,\"\",ROW()-50)","v":{"$error":"#N/A"}},{"$f":"IF(D$47=45%,VLOOKUP(A51,__pay5,A$47+1),VLOOKUP(A51,__pay3,A$47+1))","v":{"$error":"#N/A"}},{"$f":"IF(B51=\"\",\"\",$F$47*B51)","v":{"$error":"#N/A"}},{"$f":"IF(C51=\"\",\"\",INT((C51+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,24,null,48,22]
[{"$error":"#N/A"},{"$f":"IF(A52=\"\",\"\",IF(D$47=45%,VLOOKUP(A52,__pay5,A$47+1),VLOOKUP(A52,__pay3,A$47+1)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,25,null,49,22]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,25,null,50,23]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,26,null,51,23]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,26,null,52,23]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,27,null,53,24]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,27,null,54,24]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,28,null,55,25]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,28,null,56,25]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,29,null,57,26]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,29,null,58,26]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,30,null,59,27]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,30,null,60,27]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,61,31,null,61,28]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,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,31,null,62,28]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,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,32,null,63,28]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,64,32,null,64,29]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,65,33,null,65,29]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,66,33,null,66,30]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,67,30]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,68,31]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,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,69,31]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,70,32]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,71,32]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,72,33]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,73,33]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,74,33]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,75,34]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steeper"]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,0.625,0.47499999999999998,0.41,0.34499999999999997,0.30599999999999999,0.27400000000000002,0.249,0.22800000000000001,0.21099999999999999,0.19500000000000001,0.18099999999999999,0.17,0.159,0.15,0.14299999999999999,0.13500000000000001,0.129,0.125,0.11799999999999999,0.113,0.11,0.107,0.10199999999999999,0.1,9.5000000000000001E-2,9.2999999999999999E-2,0.09,8.7999999999999995E-2,8.5000000000000006E-2,8.3000000000000004E-2,0.08,7.8E-2]
[null,{"$f":"SUM(B51:B83)","v":{"$error":"#N/A"}},{"$f":"SUM(C51:C83)","v":{"$error":"#N/A"}},{"$f":"SUM(D51:D83)","v":{"$error":"#N/A"}},{"$f":"SUM(E51:E83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,0.375,0.3,0.26,0.24,0.218,0.2,0.185,0.17299999999999999,0.16200000000000001,0.151,0.14199999999999999,0.13400000000000001,0.127,0.121,0.115,0.111,0.105,0.10100000000000001,9.7000000000000003E-2,9.4E-2,9.0999999999999998E-2,8.7999999999999995E-2,8.5000000000000006E-2,8.3000000000000004E-2,0.08,7.8E-2,7.6999999999999999E-2,7.3999999999999996E-2,7.0999999999999994E-2,7.0999999999999994E-2,6.9000000000000006E-2,6.7000000000000004E-2]
["Click Here > Large Field Payout Calculator",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,0.22500000000000001,0.19,0.18,0.16800000000000001,0.158,0.14899999999999999,0.14099999999999999,0.13400000000000001,0.127,0.12,0.114,0.109,0.104,0.1,9.6000000000000002E-2,9.1999999999999998E-2,8.8999999999999996E-2,8.5999999999999993E-2,8.3000000000000004E-2,8.1000000000000003E-2,7.8E-2,7.5999999999999998E-2,7.3999999999999996E-2,7.1999999999999995E-2,7.0999999999999994E-2,6.9000000000000006E-2,6.7000000000000004E-2,6.6000000000000003E-2,6.5000000000000002E-2,6.3E-2,6.0999999999999999E-2]
["* 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,4,null,null,null,0.14000000000000001,0.13500000000000001,0.13,0.126,0.121,0.11700000000000001,0.112,0.107,0.10299999999999999,9.8000000000000004E-2,9.5000000000000001E-2,9.0999999999999998E-2,8.7999999999999995E-2,8.5000000000000006E-2,8.2000000000000003E-2,0.08,7.6999999999999999E-2,7.4999999999999997E-2,7.2999999999999995E-2,7.0999999999999994E-2,6.9000000000000006E-2,6.8000000000000005E-2,6.6000000000000003E-2,6.5000000000000002E-2,6.3E-2,6.2E-2,6.0999999999999999E-2,5.8999999999999997E-2,5.8000000000000003E-2,5.7000000000000002E-2]
["RED DIVISION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,null,null,0.1,0.10100000000000001,0.1,9.9000000000000005E-2,9.6000000000000002E-2,9.4E-2,9.0999999999999998E-2,8.7999999999999995E-2,8.5000000000000006E-2,8.2000000000000003E-2,7.9000000000000001E-2,7.6999999999999999E-2,7.4999999999999997E-2,7.2999999999999995E-2,7.0999999999999994E-2,6.9000000000000006E-2,6.7000000000000004E-2,6.6000000000000003E-2,6.4000000000000001E-2,6.3E-2,6.0999999999999999E-2,0.06,5.8999999999999997E-2,5.8000000000000003E-2,5.7000000000000002E-2,5.5E-2,5.5E-2,5.3999999999999999E-2,5.2999999999999999E-2]
[null,null,null,null,"Enter Added Cash (or deduction) here* > ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,7.6999999999999999E-2,7.9000000000000001E-2,7.9000000000000001E-2,7.9000000000000001E-2,7.8E-2,7.5999999999999998E-2,7.3999999999999996E-2,7.1999999999999995E-2,7.0000000000000007E-2,6.9000000000000006E-2,6.7000000000000004E-2,6.5000000000000002E-2,6.4000000000000001E-2,6.2E-2,6.0999999999999999E-2,0.06,5.8000000000000003E-2,5.7000000000000002E-2,5.6000000000000001E-2,5.5E-2,5.3999999999999999E-2,5.2999999999999999E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.0999999999999997E-2,0.05,4.9000000000000002E-2,4.8000000000000001E-2]
["# Paid",null,"Field Size","Pay pct","Total Fees: ",{"$f":"Cover!G23+Cover!M23","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,null,6.3E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.5000000000000002E-2,6.4000000000000001E-2,6.3E-2,6.0999999999999999E-2,0.06,5.8999999999999997E-2,5.8000000000000003E-2,5.7000000000000002E-2,5.6000000000000001E-2,5.5E-2,5.3999999999999999E-2,5.2999999999999999E-2,5.1999999999999998E-2,5.0999999999999997E-2,5.0999999999999997E-2,0.05,4.9000000000000002E-2,4.8000000000000001E-2,4.8000000000000001E-2,4.7E-2,4.5999999999999999E-2,4.5999999999999999E-2,4.4999999999999998E-2]
[{"$f":"IF(D90=45%,VLOOKUP(C90,dbd,2,FALSE),VLOOKUP(C90,dbe,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F23=0,91,Cover!F23+ROUNDDOWN(Cover!L23/3,0))","v":91},0.45,"Net Purse: ",{"$f":"F89+F88","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,null,null,null,null,5.2999999999999999E-2,5.3999999999999999E-2,5.5E-2,5.5E-2,5.5E-2,5.3999999999999999E-2,5.3999999999999999E-2,5.2999999999999999E-2,5.1999999999999998E-2,5.1999999999999998E-2,5.0999999999999997E-2,0.05,0.05,4.9000000000000002E-2,4.8000000000000001E-2,4.8000000000000001E-2,4.7E-2,4.5999999999999999E-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]
[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,null,null,null,null,null,null,null,null,null,null,null,9,null,null,null,null,null,null,null,null,4.7E-2,4.8000000000000001E-2,4.8000000000000001E-2,4.7E-2,4.5999999999999999E-2,4.9000000000000002E-2,4.8000000000000001E-2,4.7E-2,4.7E-2,4.7E-2,4.5999999999999999E-2,4.5999999999999999E-2,4.4999999999999998E-2,4.4999999999999998E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2999999999999997E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,0.04]
[null,"Prelim","Proposed","Round","Manual","Final",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,4.1000000000000002E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.3999999999999997E-2,4.4999999999999998E-2,4.2999999999999997E-2,4.2999999999999997E-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,0.04,0.04,0.04,3.9E-2,3.9E-2,3.9E-2,3.7999999999999999E-2,3.7999999999999999E-2,3.7999999999999999E-2]
["Place","Factor","Payout $$","to $5","Adj. ","Place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,4.1000000000000002E-2,4.2000000000000003E-2,4.2000000000000003E-2,4.1000000000000002E-2,4.1000000000000002E-2,4.1000000000000002E-2,0.04,0.04,3.9E-2,3.9E-2,3.9E-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.5999999999999997E-2,3.5999999999999997E-2,3.5999999999999997E-2]
[{"$f":"IF(ROW()-93>$A$90,\"\",ROW()-93)","v":{"$error":"#N/A"}},{"$f":"IF(D$90=45%,VLOOKUP(A94,__pay5,A$90+1),VLOOKUP(A94,__pay3,A$90+1))","v":{"$error":"#N/A"}},{"$f":"IF(B94=\"\",\"\",$F$90*B94)","v":{"$error":"#N/A"}},{"$f":"IF(C94=\"\",\"\",INT((C94+2.5)/5)*5)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,null,null,null,null,null,null,null,null,null,null,null,0.04,0.04,3.7999999999999999E-2,3.9E-2,3.9E-2,3.7999999999999999E-2,3.7999999999999999E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.6999999999999998E-2,3.5999999999999997E-2,3.5999999999999997E-2,3.5999999999999997E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2]
[{"$error":"#N/A"},{"$f":"IF(A95=\"\",\"\",IF(D$90=45%,VLOOKUP(A95,__pay5,A$90+1),VLOOKUP(A95,__pay3,A$90+1)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,3.7999999999999999E-2,3.5999999999999997E-2,3.5999999999999997E-2,3.5999999999999997E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.4000000000000002E-2,3.3000000000000002E-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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4000000000000002E-2,3.4000000000000002E-2,3.3000000000000002E-2,3.3000000000000002E-2,3.3000000000000002E-2,3.2000000000000001E-2,3.2000000000000001E-2,3.2000000000000001E-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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2000000000000001E-2,3.1E-2,3.1E-2,0.03,0.03,0.03,0.03,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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.9000000000000001E-2,2.9000000000000001E-2,2.9000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.8000000000000001E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.8000000000000001E-2,2.7E-2,2.7E-2,2.7E-2,2.7E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5999999999999999E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5999999999999999E-2,2.5999999999999999E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-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.3E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.4E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.3E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,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.3E-2,2.3E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1999999999999999E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,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,0.02,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,2.1000000000000001E-2,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,0.02,0.02,0.02,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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,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]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},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,1.6E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,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,1.4999999999999999E-2,1.4999999999999999E-2,1.4E-2,1.4E-2,1.4E-2,1.4E-2,1.4E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,1.4E-2,1.4E-2,1.4E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2999999999999999E-2,1.2999999999999999E-2,1.2999999999999999E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2E-2,1.2E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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.2E-2]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"SUM(B94:B126)","v":{"$error":"#N/A"}},{"$f":"SUM(C94:C126)","v":{"$error":"#N/A"}},{"$f":"SUM(D94:D126)","v":{"$error":"#N/A"}},{"$f":"SUM(E94:E126)","v":0}]
["* Can be a negative number when expenses like trophies involved"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GREEN DIVISION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter Added Cash (or deduction) here* > ",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,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,{"$f":"IF(R132=45%,VLOOKUP(Q132,dbd,2,FALSE),VLOOKUP(Q132,dbe,2,FALSE))","v":{"$error":"#N/A"}},null,{"$f":"IF(Cover!F24=0,91,Cover!F24)","v":91},0.45,"Net Purse: ",{"$f":"T131+T130","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,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,"Prelim","Proposed","Round","Manual","Final"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Place","Factor","Payout $$","to $5","Adj. ","Place"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ROW()-135>$O$132,\"\",ROW()-135)","v":{"$error":"#N/A"}},{"$f":"IF(R$132=45%,VLOOKUP(O136,__pay5,O$132+1),VLOOKUP(O136,__pay3,O$132+1))","v":{"$error":"#N/A"}},{"$f":"IF(P136=\"\",\"\",$T$132*P136)","v":{"$error":"#N/A"}},{"$f":"IF(Q136=\"\",\"\",INT((Q136+2.5)/5)*5)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$f":"IF(O137=\"\",\"\",IF(R$132=45%,VLOOKUP(O137,__pay5,O$132+1),VLOOKUP(O137,__pay3,O$132+1)))","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,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,null,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,null,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,null,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,null,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,null,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,null,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,null,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,null,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,null,null,null,null,null,{"$f":"SUM(P136:P146)","v":{"$error":"#N/A"}},{"$f":"SUM(Q136:Q146)","v":{"$error":"#N/A"}},{"$f":"SUM(R136:R146)","v":{"$error":"#N/A"}},{"$f":"SUM(S136:S146)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click Here > Large Field Payout Calculator"]

{"sheet":"Finance","index":6,"n_rows":78,"n_cols":20,"rows_kept":78,"cut":false,"hidden":false,"merged":[[4,11,4,14],[20,11,20,13],[41,0,41,15],[28,11,28,13],[29,11,29,13],[30,7,30,9],[21,11,21,13],[25,11,25,13],[6,11,6,13],[32,11,32,13],[40,0,40,15],[26,11,26,13],[30,11,30,13],[31,11,31,13],[27,11,27,13],[35,7,35,9],[35,4,35,5],[28,0,28,2],[30,0,30,2],[32,0,32,2],[31,0,31,2],[33,4,33,5],[34,4,34,5],[35,0,35,2],[2,2,2,4],[4,0,4,2],[4,7,4,9],[49,0,49,4],[47,0,47,4],[34,0,34,2],[33,0,33,2],[17,7,17,9],[6,0,6,2],[6,7,6,9],[46,0,46,4],[44,8,44,9],[46,8,46,13],[48,8,48,13],[48,0,48,4],[9,0,9,2],[6,4,6,5],[7,0,7,2],[7,4,7,5],[7,7,7,9],[19,0,19,2],[15,4,15,5],[16,4,16,5],[17,4,17,5],[8,0,8,2],[18,7,18,9],[15,7,15,9],[16,7,16,9],[7,11,7,13],[8,11,8,13],[9,11,9,13],[22,4,22,5],[21,4,21,5],[20,0,20,2],[22,11,22,13],[29,0,29,2],[9,4,9,5],[10,4,10,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[18,4,18,5],[19,4,19,5],[16,0,16,2],[17,0,17,2],[18,0,18,2],[20,4,20,5],[23,4,23,5],[24,4,24,5],[15,0,15,2],[24,11,24,13],[9,7,9,9],[11,4,11,5],[29,4,29,5],[25,7,25,9],[27,4,27,5],[29,7,29,9],[27,7,27,9],[24,7,24,9],[23,11,23,13],[19,11,19,13],[16,11,16,13],[17,11,17,13],[18,11,18,13],[15,11,15,13],[23,7,23,9],[20,7,20,9],[28,7,28,9],[22,7,22,9],[21,7,21,9],[31,7,31,9],[28,4,28,5],[25,4,25,5],[26,4,26,5],[31,4,31,5],[26,7,26,9],[30,4,30,5],[19,7,19,9],[8,7,8,9],[8,4,8,5],[49,8,49,13],[62,8,62,13],[58,8,58,13],[61,8,61,13],[56,8,56,13],[59,8,59,13],[52,8,52,13],[57,8,57,13],[32,4,32,5],[32,7,32,9],[34,7,34,9],[50,8,50,13],[35,11,35,14],[33,11,33,13],[34,11,34,13],[33,7,33,9],[42,0,42,15],[47,8,47,13],[60,0,60,4],[60,8,60,13],[57,0,57,4],[53,0,53,4],[52,0,52,4],[58,0,58,4],[64,8,64,13],[72,0,72,4],[69,8,69,13],[72,8,72,13],[71,8,71,13],[65,8,65,13],[65,0,65,4],[70,8,70,13],[51,8,51,13],[68,8,68,13],[66,8,66,13],[67,0,67,4],[66,0,66,4],[67,8,67,13],[64,0,64,4],[63,0,63,4],[63,8,63,13],[68,0,68,4],[59,0,59,4],[61,0,61,4],[54,0,54,4],[56,0,56,4],[62,0,62,4],[55,0,55,4],[77,8,77,13],[70,0,70,4],[69,0,69,4],[71,0,71,4],[76,8,76,13],[74,8,74,13],[73,8,73,13],[76,0,76,4],[74,0,74,4],[73,0,73,4],[56,19,56,21],[57,19,57,21],[46,19,46,21],[47,19,47,21],[48,19,48,21],[49,19,49,21],[50,19,50,21],[51,19,51,21],[52,19,52,21],[53,19,53,21],[54,19,54,21],[55,19,55,21]]}
[null,null,null,null,null,null,null," PDGA Tour Event: Financial Summary"]
[]
["Part 1:",null,"Sponsors",null,null,null,"Please list all sponsors and their contributions."]
[]
["Cash Sponsors",null,null,null,"Amount",null,null,"Non Cash Sponsors",null,null,null,"Description of Donation",null,null,null,"Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Cash Sponsors",null,null,null,{"$f":"SUM(E7:E35)","v":0},null,null,null,null,null,null,"Total Non-Cash Sponsors",null,null,null,{"$f":"SUM(P7:P35)","v":0}]
[]
[]
["Part 2:",null,"Statement of Income and Expenses"]
[]
["Instructions : Only Majors and National Tour events are required to complete this section. This sheet is provided to "]
["assist TDs with the financial management of their event. You will be asked to provide financial detail only if the PDGA "]
["receives complaints from players regarding the overall event payout (incl players packages, side games, amenities etc)."]
[]
["Income",null,null,null,null,null,"US$",null,"Expenses",null,null,null,null,null,null,"US$"]
[]
["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!T20","v":0},null,null,null,"NOTE"]
["Cash Sponsorships",null,null,null,null,null,{"$f":"+Finance!E36","v":0},null,"Pro Player Packs - Actual Cost",null,null,null,null,null,null,null,null,null,null,"Type only in white"]
[null,null,null,null,null,null,null,null,"Unified Prizes - Actual Cost",null,null,null,null,null,null,null,null,null,null,"or yellow boxes"]
["Gross Unified Entry Fees",null,null,null,null,null,{"$f":"Cover!X8","v":0},null,"Unified Player Packs - Actual Cost",null,null,null,null,null,null,null,null,null,null,"DO NOT TYPE IN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BLUE OR"]
["Non-Cash Sponsorships Value",null,null,null,null,null,{"$f":"+Finance!P36","v":0},null,"Sponsor Costs: Signs, Banners, Shirts",null,null,null,null,null,null,null,null,null,null,"GREEN BOXES!"]
["Other Cash: Raffles, Contests, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"These all use"]
[null,null,null,null,null,null,null,null,"Other Cash Prizes: Skins, etc.",null,null,null,null,null,null,null,null,null,null,"automatic entries"]
["Late Fees",null,null,null,null,null,null,null,"Other Prizes: CTPs, etc.- Actual Cost",null,null,null,null,null,null,null,null,null,null,"Do not insert or"]
[null,null,null,null,null,null,null,null,"Trophies",null,null,null,null,null,null,null,null,null,null,"delete rows. All "]
[null,null,null,null,null,null,null,null,"Player Fees to PDGA",null,null,null,null,null,null,{"$f":"Cover!T41+Cover!T42","v":0},null,null,null,"cells postitioned"]
["$10 Fees from Non-Current Players",null,null,null,null,null,{"$f":"Cover!T43","v":0},null,"$10 Non-current Fees to PDGA",null,null,null,null,null,null,{"$f":"G58","v":0},null,null,null,"for data importing"]
["Ace Pool Collected",null,null,null,null,null,null,null,"Ace Pool",null,null,null,null,null,null,{"$f":"G59","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":"R62*T62","v":0},"=",null,"X"]
[null,null,null,null,null,null,null,null,"Local Club Fees",null,null,null,null,null,null,{"$f":"R63*T63","v":0},"=",null,"X"]
[null,null,null,null,null,null,null,null,"Equipment Rental"]
[null,null,null,null,null,null,null,null,"Printing & Advertising"]
[null,null,null,null,null,null,null,null,"Communication"]
[null,null,null,null,null,null,null,null,"Staff: Shirts, Plyr Packs - Actual Cost"]
[null,null,null,null,null,null,null,null,"Charitable Contribution"]
[]
["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(G47:G75)","v":0},null,"Total Expenses",null,null,null,null,null,null,{"$f":"SUM(P47:P75)","v":0}]
[null,null,null,null,null,null,null,null,"NET:  PROFIT or (LOSS)",null,null,null,null,null,null,{"$f":"G77-P77","v":0}]

{"sheet":"$10 Fees","index":7,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[6,0,9,9]]}
["List of Non-Current Players / Supporting Members Paying the $10 PDGA Fee"]
[]
["Instructions: PDGA current membership is required at all Majors, National Tour and SuperTour (A Tier) events. For all other events, non-current or non-member"]
["players may participate by paying a $10 fee to the PDGA in lieu of membership. This fee is required of ALL players who cannot prove current membership, except"]
["for players competing in a Junior division."]
[]
["New players who pay the $10 fee are eligible for a $10 discount when registering as a new member of the PDGA. The discount can only be applied to membership registration received during the same calendar year as the $10 fee.  Players should use the code NONMEMBER10 to receive this discount.  TDs are encouraged to provide PDGA membership forms to any player who is not current."]
[]
[]
[]
[]
["PDGA#","First Name","Last Name","Address","City","State","Zip","DOB","Phone","Email"]

{"sheet":"Membership Form","index":8,"n_rows":80,"n_cols":22,"rows_kept":80,"cut":false,"hidden":false,"merged":[[42,2,42,22],[62,21,62,22]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"               PDGA Membership Form - USA & CANADA "]
[]
[]
[null,null,null,null,null,null,"Please use your common name -- First and Last. FILL OUT ALL INFORMATION IN THIS SECTION IS REQUIRED."]
[null,null,null,null,null,null,"One form per person. PLEASE PRINT TO ENSURE DELIVERY."]
[]
[null,null,null,null,null,null,"Name",null,null,null,null,null,null,null,null,null,null,"Male  ",null,"or",null,"  Female"]
[]
[null,null,null,null,null,null,"Address"]
[]
[null,null,null,null,null,null,"City",null,null,null,null,null,null,"State/Prov",null,null,null,null,null,"ZIP"]
[]
[null,null,null,null,null,null,"Phone",null,null,null,null,null,null,"Email"]
[]
[null,null,null,null,null,null,"Date of Birth (required)"]
[]
[]
[]
[null,null,"PDGA Memberships follow the calendar year – January 1st until December 31st. New PDGA members will receive a member number, a PDGA "]
[null,null,"logo disc, a PDGA mini-marker, a PDGA membership card, the official rules of disc golf and competition manual, a subscription to DiscGolfer "]
[null,null,"Magazine and a PDGA sticker. Renewing PDGA members will receive a PDGA membership card, a PDGA renewal tag, a subscription to "]
[null,null,"DiscGolfer Magazine, and a PDGA sticker. PDGA members agree that the PDGA and any affiliated media partners have the right to publish "]
[null,null,"content (photographs, videos, etc.) of their participation at PDGA sanctioned events. PDGA memberships are non-refundable."]
[]
[null,null,null,null,null,"RENEWING PDGA # __________",null,null,null,null,null,"  NEW MEMBER"]
[]
[]
[null,null," Membership Divisions and Fees   -   Please check one of the following boxes (listed in US$):"]
[]
[null,null,null,null,null,50,"Amateur",null,null,null,null,null,null,"  $45    Amateur Additional FAMILY* Membership"]
[]
[null,null,null,null,null,75,"Professional",null,null,null,null,null,null,"  $70    Pro Additional FAMILY* Membership"]
[]
[null,null,null,null,null,30,"Junior (18 years old or younger )",null,null,null,null,null,null,"  $25    Junior FAMILY* Membership"]
[]
[null,null,"*Additional FAMILY Members in the same household of a full-paid current PDGA member may receive a $5 discount.\n  Only the original full-paid membership receives a subscription to DiscGolfer Magazine."]
[null,null,null,"Family Member with:  New ______________________________ Renewal(s) PDGA #(s) ________/________/________/________"]
[]
[]
[null,null,"Upgrade your membership by increasing your support of PDGA programs:"]
[]
[null,null,null,null,null,"+ $50","Birdie Club ",null,null,"   - ADD $50 to basic fee above and receive a Birdie Club disc and Birdie Club bag tag."]
[]
[null,null,null,null,null,"+ $100","Ace Club ",null,null,"   - ADD $100 to basic fee above and receive an Ace Club disc, Ace Club bag tag and choice of"]
[null,null,null,null,null,null,null,null,null,"     the following:  ____ Ace Club metal mini  OR  ____ Ace Club sports shirt - M  L  XL  XXL"]
[]
[null,null,null,null,null,2000,"Eagle Club",null,null,"TOTAL $2000 for a Lifetime PDGA Membership. Eagle Club members receive two Eagle Club discs "]
[null,null,null,null,null,"  (Lifetime Membership)",null,null,null,"and embroidered Eagle Club jacket. Available sizes  -  M  L  XL  XXL XXXL "]
[]
[]
[null,null,"Multi-Year Membership",null,null,null,null,null,null,null,"You can renew your PDGA membership for up to 5 years"]
[null,null,null," # of Years ____ x _______ (amount from above)",null,null,null,null,null,null,"at the current membership rates. Check your division above and"]
[null,null,null,"Multi-Year Membership Total $__________",null,null,null,null,null,null,"multiply your membership fee by the # of years renewing."]
[]
[]
[null,null,null,"Total Payment to TD   $",null,null,null,null,null,null,"Signature:",null,null,null,null,null,null,null,null,null,"Date:","___/___/_____"]
[]
[]
[null,null,"Tournament Director Payment Options"]
[]
[null,null,"1.","Submit new or renewing membership fees with PDGA sanctioned fees."]
[]
[null,null,"2.","Pay online by credit card or PayPal at www.pdga.com/membership"]
[]
[null,null,"3.","Call PDGA Memberships at 706-261-6342 with your credit card and membership information."]
[]
[]
[null,null,null,null,null,"   Check here if you DO NOT want your name or contact information to appear on lists sold to disc-golf related parties."]
[]
[null,null,null,null,null,"   Check here if you DO NOT want to receive email communication from the PDGA that is not essential to your membership."]
[]
[]
[null,null,null,"Visit PDGA.com or contact the PDGA Office at (706)261-6342 or Memberships@pdga.com"]

{"sheet":"Memberships","index":9,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,0,14,12],[39,1,39,4],[38,1,38,4],[6,4,6,11]]}
["PDGA Memberships Collected",null,null,null,null,null,"Tour Event Name:",""]
[]
["Instructions: ",null,"Please provide details on any players who paid their PDGA membership at your event. Please submit this information as part of your electronic"]
[null,null,"TD report as soon as possible following your event. This information is required in order for the PDGA office to process and finalize your event results,"]
[null,null,"and it enables the PDGA to respond to these customers with timely service. Thanks very much !"]
[]
["Fees:",null,"Pro:         $75"]
[null,null,"Amateur: $50"]
[null,null,"Junior:    $30",null,"(18 years old or younger)"]
["Family Discount: $5 discount for each additional PDGA membership at the same address. Only one copy of DiscGolfer Magazine will be shipped per family."]
["Membership Upgrades: Ace Club - $100; Birdie Club - $50"]
[]
["Attention: For your convenience you and/or your players may submit membership registrations online by visiting www.pdga.com/join We strongly encourage all tournament directors to utilize this service as this will immeditately make a player current. If you do enter memberships online please use the code TDMEM as this code will eliminate the transaction fee. If you plan on paying via check, money order, or Paypal please continue to use this form. "]
[]
[]
[]
["Example:"]
[75,"Pro","Male",8787,"William","Van Anhyzer","3702 W Riverside Dr #1618","Conquistador","CA","95278-3579","1956-12-20","626-456-2345","discgolf@pdga.com"]
["$Paid","Class","Gender","PDGA#","FirstName","LastName","Address","City","State","Zip","DateOfBirth","Phone","Email"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"SUM(A20:A36)","v":0},"Total Membership $ Collected"]
[null,"Less Checks & Credit Card $ Received"]
[{"$f":"+A38-C39","v":0},"= Total Membership $ Paid by TD"]

{"sheet":"Evaluation Form","index":10,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[30,0,30,15],[31,0,31,15],[26,0,26,15],[27,0,27,15],[28,0,28,15],[29,0,29,15],[24,0,24,15],[25,0,25,15],[9,2,9,8],[9,12,9,15],[11,2,11,8],[11,12,11,13],[18,12,18,15],[23,0,23,15]]}
[null,null,null,null,null,null,null,null,null,"PDGA  Tour Event Evaluation Form"]
[]
[]
[null,null,"This form gives players the opportunity to provide feedback on Tour Events to the PDGA & TDs. "]
[null,null,"Most events run pretty smooth, are lots of fun, and have a few problems. That is the norm."]
[null,null,"Players are encouraged to use this form whenever an event or something about it was superb,"]
[null,null,"or when an event fell short of their expectations, and to provide detail as they feel appropriate."]
[]
[]
["Event:",null," ",null,null,null,null,null,null,null,"Date(s):",null," "]
[]
["Your Name:",null," ",null,null,null,null,null,null,null,"PDGA#:",null," "]
[]
["1. Rate this PDGA Tour Event in terms of meeting your expectations for this tier level ?"]
[]
["      Best event I've been to",null,null,null,null,null,null,"Fair"]
["      Excellent",null,null,null,null,null,null,"Poor"]
["      Good",null,null,null,null,null,null,"Worst event I've been to"]
["      Average",null,null,null,null,null,null,"Other (specify)"]
[]
["2. Please provide your comments."]
["    What contributed to making this event such a success ? "]
["    OR Why did this event not live up to your expectations ?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Once this form is completed you can either:"]
[]
["Give it to:  ","The Tournament Director or his/her Assistant"]
[]
["Send it to: ","PDGA Office, 3828 Dogwood Lane, Appling, GA, 30802        "]
[null,"email: tdreport@pdga.com"]

{"sheet":"SupportData","index":11,"n_rows":26,"n_cols":7,"rows_kept":26,"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"]
["RPA",null,"NT",1,5,"NT"]
["RAH",null,"A / XA",2,4,"A / XA"]
["RAD",null,"B / XB",3,3,"B / XB"]
["RAE",null,"C / XC",4,2,"C / XC"]
["RAF",null,"A Pro / B Am",9,null,"Pro A","Am B"]
["RAG",null,"A Pro / C Am",10,null,"Pro A","Am C"]
[null,null,"B Pro / C Am",11,null,"Pro B","Am C"]
[null,null,"B Pro / A Am",12,null,"Pro B","Am A"]
[null,null,"C Pro / A Am ",13,null,"Pro C","Am A"]
[null,null,"C Pro / B Am ",14,null,"Pro C","Am B"]
[]
[]
[]
[]
[null,null,"Pro A",null,4]
[null,null,"Pro B",null,3]
[null,null,"Pro C",null,2]
[null,null,"Am A",null,4]
[null,null,"Am B",null,3]
[null,null,"Am C",null,2]
[]
[null,null,null,{"$f":"IF(Cover!$Q7=\"\",\"\",VLOOKUP(Cover!$Q7,tierDB,2,FALSE))","v":4},null,{"$f":"IF(Cover!$Q7=\"\",\"\",VLOOKUP(Cover!$Q7,tierDB,4,FALSE))","v":"C / XC"},{"$f":"IF(Cover!$Q7=\"\",\"\",VLOOKUP(Cover!$Q7,tierDB,5,FALSE))","v":0}]