{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["pinmoney","actual money awards","6_over_avg","sweeper night","actual money awards (2)"],"read":"whole","date_system":"1900"}

{"sheet":"pinmoney","index":0,"n_rows":144,"n_cols":8,"rows_kept":144}
[]
["Wednesday Fun Fours bowling league at Double Decker Lanes 2022/23 season"]
[]
[null,null,"Prize Fund    ",{"$nulls":3},"Secretary fund"]
["(4*12*30*$3.00)",null,{"$f":"(4*12*30*3)","v":{"v":4320,"d":"4320.00"}},null,"             4*12*30*$1.00=",null,{"$f":"4*12*30","v":{"v":1440,"d":"1440.00"}}]
["  - corrections wk1-wk30 ",null,{"$f":"2*3","v":{"v":6,"d":"6.00"}},{"$nulls":3},{"v":2,"d":"2.00"}]
["     "]
[]
[null,null," ==========",{"$nulls":3}," =========="]
["             corrected total=",null,{"$f":"C5-SUM(C6:C8)","v":{"v":4314,"d":"4314.00"}},{"$nulls":3},{"$f":"G5-SUM(G6:G8)","v":{"v":1438,"d":"1438.00"}}]
["  minus awards budget",null,{"$f":"B68","v":{"v":1200,"d":"1200.00"}},"from page 2"]
["      - misc. expenses",null,{"v":0,"d":"0.00"}]
["      -other losses",null,{"v":0,"d":"0.00"}]
[null,null," =========="]
[null,null,{"$f":"C10-SUM(C11:C13)","v":{"v":3114,"d":"3114.00"}}]
[]
["Wednesday Fun Fours Pinmoney 2022/23 season: (prize fund - trophies) / total wins"]
[null,{"$f":"C15","v":{"v":3114,"d":"3114.00"}},"divided By",{"$f":"B35","v":725},"equals:",{"$f":"ROUND(B18/B35,5)","v":4.29517},"per win"]
[]
[null,null,"wins*per",null,"per person, per wk"]
["Team#","total wins:","win amt","/ by 4","/ by 120","(4 *30)=120"]
[1,65,{"$f":"ROUND(B22*$F$18,0)","v":{"v":279,"d":"279.00"}},{"$f":"C22/4","v":69.75},{"$f":"ROUND(C22/120,4)","v":{"v":2.325,"d":"2.3250"}},"**"]
[2,61,{"$f":"ROUND(B23*$F$18,0)","v":{"v":262,"d":"262.00"}},{"v":65.5,"d":"65.50"},{"$f":"ROUND(C23/120,4)","v":2.1833},"**"]
[3,62,{"$f":"ROUND(B24*$F$18,0)","v":{"v":266,"d":"266.00"}},{"v":66.5,"d":"66.50"},2.2167]
[4,67,{"v":288,"d":"288.00"},{"v":72,"d":"72.00"},{"v":2.4,"d":"2.4000"},"**"]
[5,65.5,{"v":281,"d":"281.00"},70.25,2.3417]
[6,63,{"v":271,"d":"271.00"},67.75,2.2583,"**"]
[7,50.5,{"v":217,"d":"217.00"},54.25,1.8083]
[8,62.5,{"v":268,"d":"268.00"},{"v":67,"d":"67.00"},2.2333]
[9,70,{"v":301,"d":"301.00"},75.25,2.5083,"**"]
[10,58.5,{"v":251,"d":"251.00"},62.75,2.0917]
[11,49,{"v":210,"d":"210.00"},{"v":52.5,"d":"52.50"},{"v":1.75,"d":"1.7500"}]
[12,51,{"v":219,"d":"219.00"},54.75,{"v":1.825,"d":"1.8250"}]
[null,"=========","  ========="]
["actual ------->",{"$f":"SUM(B22:B33)","v":725},{"$f":"SUM(C22:C33)","v":{"v":3113,"d":"3113.00"}}]
["total possible ","4*7*2+4*6*28",{"$f":"4*7*2+4*6*28","v":728}]
["** Additional calculations were needed to determine this amount -see additional "]
["sheet in your team envelope (if needed)"]
[]
["Wednesday Fun Fours 2022/23 season"]
["Trophies and awards Budget  "]
["(proposed guideline; actual amounts determined by prize committee)"]
[]
["Team awards:"]
[]
["1st place:","4*60.00=",{"$f":"4*60","v":240}]
["2nd place:","4*40.00=",{"$f":"4*40","v":160}]
["3rd place:","4*30.00=",{"$f":"4*30","v":120}]
["4th place:","4*25.00=",{"$f":"4*25","v":100}]
[null,null," =========="]
[null,null,{"$f":"SUM(C46:C49)","v":620}]
[]
["Individual awards:"]
[]
[{"$nulls":3},"Men:",null,null,"Women:"]
["high scratch series:",null,null,60,null,null,60]
["high scratch game:",null,null,50,null,null,50]
["high handicap series:",null,null,40,null,null,40]
["high handicap game:",null,null,30,null,null,30]
["high average",null,null,10,null,null,10]
["most improved average:",null,null,10,null,null,10,{"$f":"C51+SUM(D56:G61)","v":1020}]
["perfect attendance:",null,null,40,null,null,40]
["misc. awards:",null,null,30,null,null,30]
["misc. supplies&costs:",null,null,20,null,null,20]
[]
[]
[]
["grand total: ",{"$f":"SUM(C46:C49)+SUM(D56:D64)+SUM(G56:G64)","v":{"v":1200,"d":"1200.00"}}]
[]
["Summary:"]
[null,"expenses",{"$nulls":3},"checking account monies"]
[null,{"$f":"C35","v":{"v":3113,"d":"3113.00"}},"team pin money pay out amt.",null,null,6748.48,"balance as of 04/13/2023"]
[null,{"v":0,"d":"0.00"},"USBC card/s still owed",null,null,0,"other"]
[null,{"$f":"B68","v":{"v":1200,"d":"1200.00"}},"Awards",null,null," =========="]
[null,{"$f":"G10","v":{"v":1438,"d":"1438.00"}},"secretary money",null,null,{"$f":"F72-F73","v":6748.48}]
[null,{"$f":"4*12*4","v":{"v":192,"d":"192.00"}},"Sweeper Awards",null,null,{"$f":"D105","v":{"v":31,"d":"31.00"}},"arrearages (held out)"]
[null,{"$f":"4*12*18","v":{"v":864,"d":"864.00"}},"Sweeper Lineage wk31",null,null,{"$f":"E105","v":{"v":194,"d":"194.00"}},"owed sweeper (held out)"]
[null,30.25,"other expenses - Bank Checks"]
[null,"  =========="]
[null,{"$f":"SUM(B72:B77)","v":{"v":6807,"d":"6807.00"}},"total",null,null," =========="]
[{"$nulls":5},{"$f":"F75+F76+F77","v":6973.48}]
["_____________________________________________________________________________________________"]
[null,{"$f":"F81","v":6973.48},"checking accout monies"]
[null,{"$f":"B80","v":{"v":6807,"d":"6807.00"}},"minus expenses"]
[null,"    ========="]
[null,{"$f":"B83-B84","v":{"v":166.47999999999956,"d":"166.48"}},"balance carried over to the 2023/2024 season"]
[]
[]
[]
["Money to hold out of team's Pin Money",{"$nulls":3},"   owe for","Individual"]
[{"$nulls":3},"arrearages","sweeper","Total"," Team total:"]
["Team 1","Michael Slinsen",null,null,22,null,{"$f":"E92","v":22}]
[]
["Team 2","Sterling Grey",null,null,18]
[null,"Anthony Farnsworth",null,null,22]
[null,"James Willin",null,null,22]
[null,"Spencer Willin",null,null,22,null,{"$f":"SUM(E94:E97)","v":84}]
[]
["Team 9","Bernard O'Cop",null,1,22,{"$f":"SUM(D99:E99)","v":23}]
[null,"Ken Hanover",null,14,22,{"$f":"SUM(D100:E100)","v":36}]
[null,"Mat Hanover",null,10,22,32]
[null,"Blake Russell",null,6,22,28,{"$f":"SUM(D99:E102)","v":119}]
[]
[{"$nulls":3},"=======","=======",null," =========="]
[{"$nulls":3},{"$f":"SUM(D92:D103)","v":31},{"$f":"SUM(E92:E103)","v":194},null,{"$f":"SUM(D92:E103)","v":225}]
[]
[]
[]
[]
[]
[{"$f":"C35","v":{"v":3113,"d":"3113.00"}},"pin money total"]
[{"$f":"G105","v":{"v":225,"d":"225.00"}},"minus, money held back"]
[]
["=========="]
[{"$f":"A111-A112","v":{"v":2888,"d":"2888.00"}},"net amount of cash"]
[{"v":1200,"d":"1200.00"},"awards cash"]
[{"$f":"B76","v":{"v":192,"d":"192.00"}},"sweeper night"]
["=========="]
[{"$f":"SUM(A115:A117)","v":{"v":4280,"d":"4280.00"}}]
[]
[]
[]
[]
[]
[null,"Wednesday Fun Fours"]
[null,"Checking Account#: 108-0040783"]
[null,"Cash withdrawal needed on 4/18/2023 by around 10:00 AM"]
[]
["                   money needed=",null,{"$f":"ROUND(A119,0)","v":{"v":4280,"d":"$4,280.00"}}]
[]
[null,"singles",5,"X 1  =",{"$f":"C131","v":{"v":5,"d":"5.00"}}]
[null,"ones",3,"X 25  =",{"$f":"C132*25","v":{"v":75,"d":"75.00"}}]
[null,"fives",5,"X 100  =",{"$f":"C133*100","v":{"v":500,"d":"500.00"}}]
[null,"tens",6,"X 200  =",{"$f":"C134*200","v":{"v":1200,"d":"1200.00"}}]
[null,"twenties",5,"X 500  =",{"$f":"C135*500","v":{"v":2500,"d":"2500.00"}}]
[{"$nulls":4},"     ========"]
[{"$nulls":4},{"$f":"SUM(E131:E135)","v":{"v":4280,"d":"$4,280.00"}}]
[null,"difference=",{"$f":"C129-E137","v":0}]
["   "]
[null,"Contact:"]
[null,"John Orcutt"]
[null,"cell phone#: 707-695-8024"]
[null,"email: jorcutt@sonic.net"]
[null,"fax#: 707-595-5474"]

{"sheet":"actual money awards","index":1,"n_rows":61,"n_cols":6,"rows_kept":61}
["Wednesday Fun Fours: Actual Awards Given out amounts 4/19/2023 "]
["1st Place","4*60","Pour Decisions TBD",{"$f":"4*60","v":240}]
["2nd Place","4*40","Narrowing It Down TBD",{"$f":"4*40","v":160}]
["3rd: Place","4*30","Team To Beat  TBD",{"$f":"4*30","v":120}]
["4th: Place","4*25","Death Row PinMates TBD",{"$f":"4*25","v":100},{"$f":"SUM(D2:D5)","v":620}]
[]
["high scratch seriesM:",null,"Mike Schirman 771",60]
["high scratch seriesW:",null,"Patty Green 584",60,{"$f":"SUM(D7:D8)","v":120}]
[]
["high scratch gameM:",null,"Kenny Mosser 299",50]
["high scratch gameW:",null,"Jenny Carretero 201",50,{"$f":"SUM(D10:D11)","v":100}]
[]
["high handicap seriesM:",null,"Tim Lewallen 821",40]
["high handicap seriesW:",null,"Cindi White 769",40,{"$f":"SUM(D13:D14)","v":80}]
[]
["high handicap gameM:",null,"Sean Robinson 340",30]
["high handicap gameW:",null,"Josie Bisler 278",30,{"$f":"SUM(D16:D17)","v":60}]
[]
["High AverageM:",null,"Kenny Mosser 204",15]
["High AverageW:",null,"Patty Green 161",15,{"$f":"SUM(D19:D20)","v":30}]
[]
["most improved averageM:",null,"Kenny Mosser +18.92",15]
["most improved averageW:",null,"MaryEllen Wernet +12.74",15,{"$f":"SUM(D22:D23)","v":30}]
[]
["perfect attendance:",null,"Anthony Farnsworth",10]
[null,null,"Tammy Lang",10]
[null,null,"Cindi White",10]
[null,null,"Josie Bisler",10]
[null,null,"Mike Schirman",10]
[null,null,"Kenneth Hanover",10]
[null,null,"Matt Clark",10,null,{"$f":"SUM(D25:D31)","v":70}]
[]
[]
["Gift Cash for League Officers (3 X 25)",null,null,75]
[{"$nulls":5},{"$f":"SUM(D2:D34)","v":1185}]
[null,null,"                                   balance 1200-actual award total=",null,null,{"$f":"1200-F35","v":15}]
[]
["Sweeper Night awards ( Who _TBD)                                      ",null,null,"Men","Women"]
["(High Handicap Series)",null,null,40,40]
[{"$nulls":3},30,30]
[{"$nulls":3},15,15]
[{"$nulls":3},11,11]
[{"$nulls":4},"total:",{"$f":"SUM(D39:E42)","v":{"v":192,"d":"$192.00"}}]
["Six games over average, two concectutive weeks - 2022-2023:"]
["Everyone will receive a Certificate"]
["Devi Sharma"]
["Michael Slinsen"]
["Gregor Gonzales"]
["Andy Thomson"]
["Mike Doyel"]
["Kenny Mosser"]
["Cindi White"]
["Mary Ellen Wernet"]
["Ray Kummer"]
["Jose Bisler"]
["Ronnie Carretero"]
["Morgan Thomas"]
["Mike Schirman"]
["Kenneth Hanover"]
["Tom Woodard"]
["Jan Askew"]

{"sheet":"6_over_avg","index":2,"n_rows":18,"n_cols":9,"rows_kept":18}
["                      Six over average - 2 weeks  (alphabetically & Team number)"]
[{"$nulls":3},"team",{"$nulls":4},"team"]
[1,"Jan Askew",null,11,null,1,"Devi Sharma",null,1]
[{"$f":"A3+1","v":2},"Jose Bisler",null,7,null,{"$f":"F3+1","v":2},"Michael Slinsen",null,1]
[{"$f":"A4+1","v":3},"Ronnie Carretero",null,7,null,{"$f":"F4+1","v":3},"Gregor Gonzales",null,1]
[4,"Mike Doyel",null,3,null,4,"Andy Thomson",null,3]
[5,"Gregor Gonzales",null,1,null,5,"Mike Doyel",null,3]
[6,"Kenneth Hanover",null,9,null,6,"Kenny Mosser",null,4]
[7,"Ray Kummer",null,6,null,7,"Cindi White",null,5]
[8,"Kenny Mosser",null,4,null,8,"Mary Ellen Wernet",null,5]
[9,"Mike Schirman",null,8,null,9,"Ray Kummer",null,6]
[10,"Devi Sharma",null,1,null,10,"Jose Bisler",null,7]
[11,"Michael Slinsen",null,1,null,11,"Ronnie Carretero",null,7]
[12,"Morgan Thomas",null,8,null,12,"Morgan Thomas",null,8]
[13,"Andy Thomson",null,3,null,13,"Mike Schirman",null,8]
[14,"Mary Ellen Wernet",null,5,null,14,"Kenneth Hanover",null,9]
[15,"Cindi White",null,5,null,15,"Tom Woodard",null,10]
[16,"Tom Woodard",null,10,null,16,"Jan Askew",null,11]

{"sheet":"sweeper night","index":3,"n_rows":13,"n_cols":5,"rows_kept":13}
[]
[]
[]
[null,{"$f":"pinmoney!A117","v":{"v":192,"d":"$192.00"}}]
[]
[]
[null,null,"Men","Women"]
[null,null,40,40]
[null,null,30,30]
[null,null,15,15]
[null,null,11,11]
[{"$nulls":3},"total:",{"$f":"SUM(C8:D11)","v":{"v":192,"d":"$192.00"}}]
[{"$nulls":3},"difference",{"$f":"E12-B4","v":{"v":0,"d":"$0.00"}}]

{"sheet":"actual money awards (2)","index":4,"n_rows":61,"n_cols":6,"rows_kept":61}
["Wednesday Fun Fours: Actual Awards Given out amounts 4/19/2023 "]
["1st Place","4*60","Team To Beat",{"$f":"4*60","v":240}]
["2nd Place","4*40","Narrowing It Down",{"$f":"4*40","v":160}]
["3rd: Place","4*30","Pour Decisions",{"$f":"4*30","v":120}]
["4th: Place","4*25","DeathRow PinMates",{"$f":"4*25","v":100},{"$f":"SUM(D2:D5)","v":620}]
[]
["high scratch seriesM:",null,"Mike Schirman 771",60]
["high scratch seriesW:",null,"Patty Green 584",60,{"$f":"SUM(D7:D8)","v":120}]
[]
["high scratch gameM:",null,"Kenny Mosser 299",50]
["high scratch gameW:",null,"Jenny Carretero 201",50,{"$f":"SUM(D10:D11)","v":100}]
[]
["high handicap seriesM:",null,"Tim Lewallen 821",40]
["high handicap seriesW:",null,"Cindi White 769",40,{"$f":"SUM(D13:D14)","v":80}]
[]
["high handicap gameM:",null,"Sean Robinson 340",30]
["high handicap gameW:",null,"Josie Bisler 278",30,{"$f":"SUM(D16:D17)","v":60}]
[]
["High AverageM:",null,"Kenny Mosser 203",15]
["High AverageW:",null,"Patty Green 161",15,{"$f":"SUM(D19:D20)","v":30}]
[]
["most improved averageM:",null,"Kenny Mosser +17.58",15]
["most improved averageW:",null,"Cindi White +12.57",15,{"$f":"SUM(D22:D23)","v":30}]
[]
["perfect attendance:",null,"Anthony Farnsworth",10]
[null,null,"Tammy Lang",10]
[null,null,"Cindi White",10]
[null,null,"Josie Bisler",10]
[null,null,"Mike Schirman",10]
[null,null,"Kenneth Hanover",10]
[null,null,"Matt Clark",10]
[{"$nulls":5},{"$f":"SUM(D25:D32)","v":70}]
[]
["Gift Cash for League Officers (3 X 25)",null,null,75]
[{"$nulls":4},"        Total =",{"$f":"SUM(D2:D34)","v":1185}]
[null,null,"                           balance $1200.00-total amount above=",null,null,{"$f":"1200-F35","v":15}]
[]
["Sweeper Night awards                                      "]
["(High Handicap Series)"]
[]
[]
[]
[]
["Six games over average, two concectutive weeks - 2021-2022:"]
["Everyone will receive a Certificate"]
["Devi Sharma"]
["Michael Slinsen"]
["Gregor Gonzales"]
["Andy Thomson"]
["Mike Doyel"]
["Kenny Mosser"]
["Cindi White"]
["Mary Ellen Wernet"]
["Ray Kummer"]
["Jose Bisler"]
["Ronnie Carretero"]
["Morgan Thomas"]
["Mike Schirman"]
["Kenneth Hanover"]
["Tom Woodard"]
["Jan Askew"]