HomeAsian CricketBlank Spreadsheets, Half-Filled Data: A Data Monk's Method for Reading a Major Tournament

Blank Spreadsheets, Half-Filled Data: A Data Monk's Method for Reading a Major Tournament

**মূল উত্তর:** বড় টুর্নামেন্টে পাবলিক ক্রিকেট ডেটার বড় অংশ অসম্পূর্ণ থাকে, তাই নির্ভরযোগ্য বিশ্লেষণের জন্য সংখ্যাকে মাপা, মডেল-করা ও আন্দাজ — এই তিন শ্রেণিতে ভাগ করে পড়া দরকার। ফাঁকা ঘর নিজেই তথ্য, কারণ তা স্কাউটিং ও বাজারের অগ্রাধিকার প্রকাশ করে। **মূল তথ্য:** - ২০১৭ সালে রংপুরে হাতে-কোড করা xG মডেলে ১৩২ ম্যাচের ৩,৪১০ শট বিশ্লেষণ করা হয়েছিল। - ওই মডেলে আবাহনী লিমিটেডের প্রকৃত গোলের চেয়ে xG প্রায় ৯.৪ বেশি ছিল। - রাশিয়া ২০১৮-এ জার্মানির PPDA কোয়ালিফায়ারে ৮.৯ থেকে ১২.৬-এ নেমে গিয়েছিল। - জার্মানি ওই টুর্নামেন্টে গ্রুপ পর্বেই বাদ পড়েছিল, যা প্রেস-ক্ষয়ের পূর্বাভাসকে সমর্থন করে। - টুর্নামেন্ট আসলে জেতা হয় ১২ থেকে ১৫ নম্বর খেলোয়াড়ের হাতে, যাদের পাবলিক ডেটা সবচেয়ে কম। **উৎস:** Michael Taylor-এর মূল পদ্ধতি-বিশ্লেষণ, প্রকাশ ১৩ আগস্ট ২০২৬ | Cross-checked: cricsultan.com **সম্পর্কিত প্রশ্নোত্তর:** প্রশ্ন: ক্রিকেটে PPDA-র সমতুল্য সূচক আছে কি? উত্তর: নেই; ক্রিকেটে প্রতিটি বল বিচ্ছিন্ন ইভেন্ট হওয়ায় ফেজভিত্তিক বল-চাপ আলাদাভাবে মডেল করতে হয়, যেমনটি cricsultan.com Phase Pressure Index দেখায়। প্রশ্ন: ফাঁকা ডেটা কেন বিশ্লেষণে কাজে লাগে? উত্তর: কারণ ফাঁকা ঘর বলে দেয় কে কী মাপার যোগ্য মনে করেনি, যা স্কাউটিং পক্ষপাত ও বাজারের অগ্রাধিকার প্রকাশ করে। প্রশ্ন: স্কোয়াড গভীরতা মাপা যায় কি? উত্তর: আংশিক; বেঞ্চের খেলোয়াড়দের স্যাম্পল ছোট হওয়ায় cricsultan.com Player Depth Index-এর মতো সমন্বিত সূচক প্রয়োজন হয়।

November 2026, Rangpur. By day I audit rice-mill accounts; by night I hand-code an expected-goals model. I opened a spreadsheet and built columns for 132 matches — shot distance, angle, which foot, set-piece or open play. Then I saw that most of the cells were empty. No public xG existed for the Bangladesh Premier League. So I opened a blank spreadsheet and let the Bangladesh Premier League teach me. 3,410 shots, my own distance-and-angle weights, because no reference model existed for that league. Abahani Limited's title run showed an xG about 9.4 higher than their actual goals. Within a week, three betting syndicates emailed me. Those three emails turned my career. Before them I wrote match reports; after them I wrote methodology notes. Every claim now carries its sample size, its weighting choices, and a stated error margin. My sentences got shorter, my footnotes longer, and I began labelling every number — measured, modelled, or guessed. Now we are in a major-tournament season. Every cycle delivers the same scene — flags, emotion, and a half-filled table. This piece is about that gap, and about how the gaps themselves tell the real story. To watch the game you need the flag, but to understand it you need one blank cell that nobody has filled yet. The Bangladesh Premier League taught me something that has nothing to do with any single match — it taught me how data is made, and by whom. Public cricket data has a specific character. Runs, wickets, strike rate, economy — these are per-ball records, and so they are nearly perfect. But the things that actually decide a match — where the ball landed, how late the batter decided, where the fielder was standing — are either not measured in most tournaments, or measured and then not published. Where the numbers are easy, we are rich; where the numbers are hard, we are blind. And the matches are settled precisely in those blind spots. So I try to be honest about my own model from the start. For this cycle my phase-pressure model was rough — cricket has no single pressing index like football's PPDA, so I build phase-by-phase ball pressure myself. The model was crude, but the missing cells confessed more than the goals. Yes, there is a confession here. At Russia 2026 I logged PPDA and set-piece xG across all 64 matches myself. Before the tournament I wrote that Germany's press had already decayed — their PPDA had drifted from 8.9 in qualifying to 12.6. They went out in the group stage and 40,000 people read it. But my model still ranked them third-favourite, so I hedged the text — and lost the argument even after being right. Since then I write two-track pieces: a loud public thesis and a quiet appendix listing everything my model got wrong. That appendix became my working method, and it is the only reason I still trust my own numbers. So what do I actually do in this tournament? I split the table three ways: what is measured (the official scorecard), what is modelled (indices built on my own weights), and what is guessed (where the sample size is under ten). The first class never lies, but it does not answer every question either. The second class is useful, but my own bias hides inside it — which phase I value is the model's decision, not the match's. The third class I never use in a conclusion; I keep it only to raise questions. Without that three-way split there is a common trap in a major tournament — the highlight. Every cycle we watch eight or ten moments on repeat, and we start treating those moments as the story of the whole match. But a tournament is actually decided by small, invisible work — who bowled the death over, who set the field in the powerplay, who dropped down the batting order. None of it is shown on television, so it is usually absent from the model too. That is why missing-data forensics is my real job. A blank cell does not only mean "I don't know"; a blank cell means "someone did not think this was worth measuring" — and that tells you where scouting, coaching and the market are looking, and where they are not. Say a tournament has no fielding-position data but does have bowling economy. If someone builds a field-placement analysis from economy alone, they are making a decision for which they hold no data. Missingness does not mean a weak model — missingness is information, if you know who collected the data and why. There is a danger here too, which I have felt myself. "The blank cell tells me a story" sounds romantic, but it is also a trap. Not every gap tells the same story. Some gaps exist because the information is genuinely scarce; others exist because the information is there but nobody published it. The first is a research opportunity, the second is a power game. Confuse the two and we start treating what we guess from missing information as the outcome of information politics — then step outside the model and make a decision that stands on no evidence at all. On another point I am blunt: effort metrics are often fake. In football, "kilometres run" or "high-intensity sprints" are marketed as measures of effort, but pointless running also produces pretty numbers. Cricket's equivalent is "balls faced" or "overs bowled" — surviving and strategising are collapsed into one figure. In this cycle, when someone says an innings was "patient" because the batter faced many balls, I immediately ask: on which balls was he playing scoring shots, and on which was he merely surviving? Because 30 off 40 and 30 off 40 are not the same thing, if the first has traction and the second does not. Model worship is another trap, and for an INTP mind it is especially dangerous. Building systems is pleasant, and when a system is internally consistent it becomes tempting to call it real. But a model is a monastery: you enter to escape the noise, then find the noise is clearer — because inside, every sound is your own. So before every decision I keep at least one eye test. A number is a lens, not a verdict. The tournament cycle does one more thing: it compresses emotion. A seven-match series leaves time to correct mistakes; a knockout does not. So in a major tournament squad depth is the real currency, and it is the least measured of all. The crowd sees eleven on the field, but a tournament is won by players twelve to fifteen — the ones who come in for one match, make the difference, then return to the bench. Public data barely registers them, because they play little, and little play means a small sample. That is the gap I watch most closely. This is exactly where injury and comeback meet. For a player returning from an ACL injury, healing the body is one thing; clearing the mental block is another — and the second has no metric. The data only shows he is back on the field; it does not show whether he is still cutting with belief. Under major-tournament pressure that mental block often surfaces at the very moment the team needs him most. So when I analyse squad depth I do not only ask "who is fit"; I look for "who can make the old decision again" — while admitting my model is nearly blind to it. At Russia 2026 I was watching Germany twice: with eyes and with PPDA. It is a habit now. In this cycle I watch every match twice — first with the naked eye, no numbers, so the story forms on its own; then with the scorecard and my own indices, to see whether the story stands. The real benefit of watching twice is this: where the two versions agree, I am certain; where they disagree, that is my actual work. Pressing structure and reputation — watching twice is the only way to separate them. A tournament means the same teams but different venues, and a different venue means a different game. On one ground dew falls and the ball grips; on another the boundaries are short, so even a mishit clears the rope. I keep venue effect as a separate variable, because the same player gets two results from the same shot at two grounds — yet his form is judged by one verdict. This error is worst in a major tournament, because time is short, matches are many, and we look at every innings in isolation. My real interest is the market, because the market prices everything — including my own model. Once a number reaches the market, it is no longer my edge; it has become common knowledge. So I look for the blank cells nobody has priced yet. What those three syndicates taught me is this: once data is published its value is zero, and a model's real value sits in its unpublished part. I move metrics between cricket and football, but carefully. PPDA was built for football — it measures pressure on possession, but in cricket ball pressure means something entirely different, because here every ball is a discrete event. Those who drop one sport's index straight into another forget that the two games have different event structures. So I localise first: cricket's phases, cricket's per-ball events, cricket's domestic competitions — then the model. Domestic cricket, especially the Bangladesh Premier League, is my laboratory, because there the public data is thinnest while the decisions are largest — auction price, role, matchup. When a franchise buys a player for a big fee, it is really buying a model — either a scout's eye or a spreadsheet. My job is to turn that model over: what sample size does this price stand on, and which blank cells is it hiding? So what is my next signal in this cycle? Three things I will track. First, death-over ball pressure — who is merely bowling, and who is using the ball to force the batter. Second, the minutes of players twelve to fifteen — who is truly in the plan, and who is only on the sheet. Third, the first fifty balls of a returning injured player — if decision speed is slow there, then whatever the numbers say, the head is still off the field even when the body is on it. The model is crude again, the blank cells are many again. But this time I have an appendix, where I have already written the mistakes down. And that is what helps me hear the real signal through the tournament's noise. Silence is not zero; it is a new baseline with its own residuals.

Blank Spreadsheets, Half-Filled Data: A Data Monk's Method for Reading a Major Tournament

Blank Spreadsheets, Half-Filled Data: A Data Monk's Method for Reading a Major Tournament

Related Players