[{"_1":2,"_252":-5,"_253":-5},"loaderData",{"_3":4,"_92":93,"_243":244,"_251":-5},"root",{"_5":6,"_33":34,"_59":60,"_90":91},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":26,"_29":30,"_31":32},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","2a24f0e9a29edb6ad45b57955e0c4d44af901bda","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","API_URL","https://api.val.town","WORKER_FINGERPRINT","c7de7de11d2fa3884730f0fa9fd384f8","clerkState",{"_61":62},"__internal_clerk_state",{"_63":64,"_65":44,"_66":67,"_68":67,"_69":26,"_70":67,"_71":67,"_72":67,"_73":67,"_74":67,"_75":67,"_76":67,"_77":67,"_78":79,"_88":26,"_89":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_80":26,"_81":67,"_82":83,"_84":67,"_85":44,"_86":26,"_87":67},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_94":95,"_96":97,"_95":98,"_238":-5,"_239":-5,"_240":241,"_130":131,"_138":139,"_101":102,"_99":100,"_118":-7,"_51":52,"_242":26},"type","val","author","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18",{"_99":100,"_96":97,"_101":102,"_103":-5,"_104":-5,"_105":106,"_107":-5,"_108":109,"_110":111,"_112":26,"_113":111,"_114":115,"_116":117,"_118":119,"_120":26,"_121":32,"_122":32,"_123":124,"_125":32,"_126":32,"_127":32,"_128":-5,"_20":129,"_134":-5,"_135":-7,"_136":137,"_138":139,"_140":141},"name","pickball_round_robin","valNameId","2e4baf86-e8d5-11ef-9ec0-e6cdfca9ef9f","parentFolderId","isOwned","privacy","public","readme","valType","http","currentVersion","1195116e-e8e6-11ef-980c-e6cdfca9ef9f","legacyPrivate","id","code","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport ExcelJS from \"https://esm.sh/exceljs@4.3.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\n\nfunction App() {\n const [numberOfPlayers, setNumberOfPlayers] = useState(25);\n const [courts, setCourts] = useState(5);\n const [rounds, setRounds] = useState(9);\n\n const handleSubmit = async (e) => {\n e.preventDefault();\n const response = await fetch(\"/generate\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ numberOfPlayers, courts, rounds }),\n });\n if (response.ok) {\n const blob = await response.blob();\n const url = window.URL.createObjectURL(blob);\n const a = document.createElement(\"a\");\n a.style.display = \"none\";\n a.href = url;\n a.download = \"pickleball_round_robin.xlsx\";\n document.body.appendChild(a);\n a.click();\n window.URL.revokeObjectURL(url);\n } else {\n alert(\"Error generating spreadsheet\");\n }\n };\n\n return (\n

Pickleball Round Robin Generator

\n \n View source on Val Town\n \n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nfunction shuffleArray(array: T[]): T[] {\n for (let i = array.length - 1; i > 0; i--) {\n const j = Math.floor(Math.random() * (i + 1));\n [array[i], array[j]] = [array[j], array[i]];\n }\n return array;\n}\n\nfunction generateRoundRobin(numberOfPlayers: number, courts: number, rounds: number) {\n const players = Array.from({ length: numberOfPlayers }, (_, i) => `P${String(i + 1).padStart(3, \"0\")}`);\n const schedule: { pairings: string[][]; byes: string[] }[] = [];\n const playerStats = new Map(players.map(player => [player, { gamesPlayed: 0, byes: 0, lastByeRound: -1 }]));\n const partnerships = new Map(players.map(player => [player, new Set()]));\n\n for (let round = 0; round < rounds; round++) {\n const roundPairings: string[][] = [];\n const byes: string[] = [];\n const availablePlayers = shuffleArray([...players]);\n\n // How many byes do we need this round?\n const byesNeeded = availablePlayers.length - courts * 4;\n if (byesNeeded > 0) {\n // Separate those who did NOT have a bye last round vs. those who DID\n const noRecentBye = availablePlayers.filter(p => playerStats.get(p)!.lastByeRound !== round - 1);\n const recentBye = availablePlayers.filter(p => playerStats.get(p)!.lastByeRound === round - 1);\n\n // Sort both groups with the original distribution logic\n const sortFn = (a: string, b: string) => {\n const statA = playerStats.get(a)!;\n const statB = playerStats.get(b)!;\n if (statA.byes !== statB.byes) return statA.byes - statB.byes;\n return (round - statA.lastByeRound) - (round - statB.lastByeRound);\n };\n noRecentBye.sort(sortFn);\n recentBye.sort(sortFn);\n\n // Merge them, picking from noRecentBye first\n const sortedPotentialByes = [...noRecentBye, ...recentBye];\n\n // Assign actual byes\n for (let i = 0; i < byesNeeded; i++) {\n if (!sortedPotentialByes.length) break;\n const player = sortedPotentialByes.shift()!;\n byes.push(player);\n const stats = playerStats.get(player)!;\n stats.byes++;\n stats.lastByeRound = round;\n }\n\n // Remove all byes from availablePlayers to avoid double-allocation\n byes.forEach(p => {\n const idx = availablePlayers.indexOf(p);\n if (idx >= 0) availablePlayers.splice(idx, 1);\n });\n }\n\n // Allocate players to courts in groups of 4\n while (availablePlayers.length >= 4) {\n const court: string[] = [];\n for (let i = 0; i < 4; i++) {\n let bestPlayer: string | null = null;\n let leastCommonPartners = Infinity;\n\n for (const player of availablePlayers) {\n const playerPartnerships = partnerships.get(player)!;\n // Check how many players on this court they've already teamed with\n const commonPartners = court.filter(p => playerPartnerships.has(p)).length;\n if (commonPartners < leastCommonPartners) {\n leastCommonPartners = commonPartners;\n bestPlayer = player;\n }\n }\n\n if (bestPlayer) {\n court.push(bestPlayer);\n availablePlayers.splice(availablePlayers.indexOf(bestPlayer), 1);\n playerStats.get(bestPlayer)!.gamesPlayed++;\n }\n }\n\n // Update partnerships for the 4 players on this court\n for (let i = 0; i < 4; i++) {\n for (let j = i + 1; j < 4; j++) {\n partnerships.get(court[i])!.add(court[j]);\n partnerships.get(court[j])!.add(court[i]);\n }\n }\n\n roundPairings.push(court);\n }\n\n schedule.push({ pairings: roundPairings, byes });\n }\n\n return schedule;\n}\n\nasync function generateExcelFile(numberOfPlayers: number, schedule: { pairings: string[][]; byes: string[] }[]) {\n const workbook = new ExcelJS.Workbook();\n\n // Player Names worksheet\n const playerNamesSheet = workbook.addWorksheet(\"Player Names\");\n playerNamesSheet.addRow([\"Player Number\", \"Player Name\"]);\n for (let i = 1; i <= numberOfPlayers; i++) {\n if (i === 1) {\n playerNamesSheet.addRow([`P${String(i).padStart(3, \"0\")}`, \"Player 01\"]);\n } else if (i === 2) {\n playerNamesSheet.addRow([`P${String(i).padStart(3, \"0\")}`, \"Player 02\"]);\n } else {\n playerNamesSheet.addRow([`P${String(i).padStart(3, \"0\")}`, `Player ${i}`]);\n }\n }\n playerNamesSheet.getColumn(1).width = 15;\n playerNamesSheet.getColumn(2).width = 20;\n\n // Schedule worksheet\n const scheduleSheet = workbook.addWorksheet(\"Schedule\");\n scheduleSheet.addRow([\n \"Round\",\n \"Court\",\n \"Team 1\",\n \"Team 2\",\n \"Score Team 1\",\n \"Score Team 2\",\n \"Team 1 Win\",\n \"Team 2 Win\",\n ]);\n let rowIndex = 2;\n schedule.forEach((round, roundIndex) => {\n round.pairings.forEach((pairing, courtIndex) => {\n scheduleSheet.addRow([\n roundIndex + 1,\n courtIndex + 1,\n {\n formula: `VLOOKUP(\"${pairing[0]}\", 'Player Names'!$A$2:$B$${\n numberOfPlayers + 1\n }, 2, FALSE) & \" / \" & VLOOKUP(\"${pairing[1]}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE)`,\n },\n {\n formula: `VLOOKUP(\"${pairing[2]}\", 'Player Names'!$A$2:$B$${\n numberOfPlayers + 1\n }, 2, FALSE) & \" / \" & VLOOKUP(\"${pairing[3]}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE)`,\n },\n null,\n null,\n { formula: `IF(AND(E${rowIndex}<>\"\", F${rowIndex}<>\"\"), IF(E${rowIndex}>F${rowIndex}, 1, 0), \"\")` },\n { formula: `IF(AND(E${rowIndex}<>\"\", F${rowIndex}<>\"\"), IF(F${rowIndex}>E${rowIndex}, 1, 0), \"\")` },\n ]);\n rowIndex++;\n });\n if (round.byes.length > 0) {\n scheduleSheet.addRow([\n roundIndex + 1,\n \"Byes\",\n {\n formula: `TEXTJOIN(\", \", TRUE, ${\n round.byes.map(player => `VLOOKUP(\"${player}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE)`)\n .join(\", \")\n })`,\n },\n ]);\n rowIndex++;\n }\n scheduleSheet.addRow([]);\n rowIndex++;\n });\n\n scheduleSheet.getColumn(\"A\").width = 10;\n scheduleSheet.getColumn(\"B\").width = 10;\n scheduleSheet.getColumn(\"C\").width = 30;\n scheduleSheet.getColumn(\"D\").width = 30;\n scheduleSheet.getColumn(\"E\").width = 15;\n scheduleSheet.getColumn(\"F\").width = 15;\n scheduleSheet.getColumn(\"G\").width = 10;\n scheduleSheet.getColumn(\"H\").width = 10;\n\n // Statistics worksheet\n const statsSheet = workbook.addWorksheet(\"Statistics\");\n statsSheet.addRow([\"Player\", \"Games Played\", \"Wins\", \"Total Points\", \"Points Percentage\", \"Byes\"]);\n for (let i = 1; i <= numberOfPlayers; i++) {\n const row = i + 1;\n const playerNumber = `P${String(i).padStart(3, \"0\")}`;\n statsSheet.addRow([\n {\n formula: `VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE)`,\n },\n {\n // Only count the game if the scores (columns E & F) are not empty\n formula: `\n COUNTIFS(\n Schedule!$C$2:$C$${rowIndex - 1}, \n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\",\n Schedule!$E$2:$E$${rowIndex - 1}, \"<>\",\n Schedule!$F$2:$F$${rowIndex - 1}, \"<>\"\n )\n +\n COUNTIFS(\n Schedule!$D$2:$D$${rowIndex - 1}, \n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\",\n Schedule!$E$2:$E$${rowIndex - 1}, \"<>\",\n Schedule!$F$2:$F$${rowIndex - 1}, \"<>\"\n )\n `.replace(/\\s+/g, \" \"), // just flatten the formula whitespace\n },\n {\n formula: `\n SUMIF(\n Schedule!$C$2:$C$${rowIndex - 1},\n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\",\n Schedule!$G$2:$G$${rowIndex - 1}\n )\n +\n SUMIF(\n Schedule!$D$2:$D$${rowIndex - 1},\n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\",\n Schedule!$H$2:$H$${rowIndex - 1}\n )\n `.replace(/\\s+/g, \" \"),\n },\n {\n formula: `\n SUMIF(\n Schedule!$C$2:$C$${rowIndex - 1},\n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\",\n Schedule!$E$2:$E$${rowIndex - 1}\n )\n +\n SUMIF(\n Schedule!$D$2:$D$${rowIndex - 1},\n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\",\n Schedule!$F$2:$F$${rowIndex - 1}\n )\n `.replace(/\\s+/g, \" \"),\n },\n {\n formula: `IF(B${row}=0, 0, D${row}/(B${row}*11))`,\n },\n {\n // Only count a bye if column B == \"Byes\" and column C includes the player's name\n formula: `\n COUNTIFS(\n Schedule!$B$2:$B$${rowIndex - 1}, \"Byes\",\n Schedule!$C$2:$C$${rowIndex - 1},\n \"*\" & VLOOKUP(\"${playerNumber}\", 'Player Names'!$A$2:$B$${numberOfPlayers + 1}, 2, FALSE) & \"*\"\n )\n `.replace(/\\s+/g, \" \"),\n },\n ]);\n }\n\n statsSheet.getColumn(\"A\").width = 20;\n statsSheet.getColumn(\"B\").width = 15;\n statsSheet.getColumn(\"C\").width = 10;\n statsSheet.getColumn(\"D\").width = 15;\n statsSheet.getColumn(\"E\").width = 20;\n statsSheet.getColumn(\"F\").width = 10;\n\n const buffer = await workbook.xlsx.writeBuffer();\n return buffer;\n}\n\nexport default async function server(request: Request): Promise {\n if (request.method === \"POST\" && new URL(request.url).pathname === \"/generate\") {\n const { numberOfPlayers, courts, rounds } = await request.json();\n const schedule = generateRoundRobin(numberOfPlayers, courts, rounds);\n const excelBuffer = await generateExcelFile(numberOfPlayers, schedule);\n\n return new Response(excelBuffer, {\n headers: {\n \"Content-Type\": \"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet\",\n \"Content-Disposition\": \"attachment; filename=pickleball_round_robin.xlsx\",\n },\n });\n }\n\n return new Response(\n `\n \n \n Pickleball Round Robin Generator\n \n \n \n

\n \n \n \n \n `,\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n}\n\nconst css = `\nbody {\n font-family: Arial, sans-serif;\n max-width: 800px;\n margin: 0 auto;\n padding: 20px;\n}\n\nh1 {\n color: #333;\n}\n\nform {\n display: flex;\n flex-direction: column;\n gap: 15px;\n}\n\nlabel {\n font-weight: bold;\n}\n\ninput {\n width: 100%;\n padding: 8px;\n border: 1px solid #ccc;\n border-radius: 4px;\n}\n\nbutton {\n background-color: #4CAF50;\n color: white;\n padding: 10px 15px;\n border: none;\n border-radius: 4px;\n cursor: pointer;\n font-size: 16px;\n}\n\nbutton:hover {\n background-color: #45a049;\n}\n`;","createdAt",["D",1739326030671],"version",24,"currentUserHasLiked","likeCount","forkCount","referenceCount",1,"dependencyCount","commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","stevekrouse","profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","forkedVal","interval","slug","stevekrouse/pickball_round_robin","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,197,201,205,209,213,217,221,225,229,232,235],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1739326030671],{"_118":146,"_143":-5,"_116":147,"_113":148},23,["D",1739325971873],"ee8aa7ec-e8e5-11ef-9747-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},22,["D",1739325820740],"947401c2-e8e5-11ef-8dde-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},21,["D",1739325614282],"19663f68-e8e5-11ef-ab75-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},20,["D",1739322895918],"c5201ec0-e8de-11ef-a5a7-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},19,["D",1739322766440],"77f31c88-e8de-11ef-9adf-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},18,["D",1739322574387],"057b9a04-e8de-11ef-b44b-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},17,["D",1739322461087],"c1f20e76-e8dd-11ef-839e-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},16,["D",1739322304569],"64a7404c-e8dd-11ef-97be-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},15,["D",1739322136898],"00b6a924-e8dd-11ef-8dde-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},14,["D",1739321842432],"51320980-e8dc-11ef-9e83-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},13,["D",1739321650126],"de94ad56-e8db-11ef-9227-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},12,["D",1739321538849],"9c3f99c0-e8db-11ef-b58f-e6cdfca9ef9f",{"_118":194,"_143":-5,"_116":195,"_113":196},11,["D",1739321187531],"cad8dc20-e8da-11ef-98b7-e6cdfca9ef9f",{"_118":198,"_143":-5,"_116":199,"_113":200},10,["D",1739321015666],"6468a998-e8da-11ef-8fb4-e6cdfca9ef9f",{"_118":202,"_143":-5,"_116":203,"_113":204},9,["D",1739320754721],"c8df4626-e8d9-11ef-87e5-e6cdfca9ef9f",{"_118":206,"_143":-5,"_116":207,"_113":208},8,["D",1739320679305],"9bec90d8-e8d9-11ef-9bd6-e6cdfca9ef9f",{"_118":210,"_143":-5,"_116":211,"_113":212},7,["D",1739320603728],"6ee48b9a-e8d9-11ef-8f6f-e6cdfca9ef9f",{"_118":214,"_143":-5,"_116":215,"_113":216},6,["D",1739320531932],"44146b7e-e8d9-11ef-a94f-e6cdfca9ef9f",{"_118":218,"_143":-5,"_116":219,"_113":220},5,["D",1739320445838],"10c34e98-e8d9-11ef-9445-e6cdfca9ef9f",{"_118":222,"_143":-5,"_116":223,"_113":224},4,["D",1739319395494],"9eb4ed0e-e8d6-11ef-8bd2-e6cdfca9ef9f",{"_118":226,"_143":-5,"_116":227,"_113":228},3,["D",1739319300680],"6632c410-e8d6-11ef-8bd2-e6cdfca9ef9f",{"_118":91,"_143":-5,"_116":230,"_113":231},["D",1739319174958],"1b423ee0-e8d6-11ef-8067-e6cdfca9ef9f",{"_118":124,"_143":-5,"_116":233,"_113":234},["D",1739318828865],"4cf868f2-e8d5-11ef-9e91-e6cdfca9ef9f",{"_118":32,"_143":-5,"_116":236,"_113":237},["D",1739318777407],"2e4ebece-e8d5-11ef-9ec0-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_245":246,"_247":32,"_248":137,"_249":32,"_95":250},"dependenciesList",[],"dependenciesCount","valname","page",{"_113":111,"_99":100,"_130":131,"_11":97,"_118":119,"_101":102,"_114":115,"_105":106,"_112":26,"_136":137},"routes/_app","actionData","errors"]