![]() ![]() Here I am using either Dynamic Array formulas (such as FILTER & SORT) or good old INDEX MATCH formulas to get the correct values.Once the data is loaded to Excel, I created two different views, one for group stage and another for knock-out (elimination) stage.I am using Power Query (Data Ribbon) to fetch the relevant tables from the Wikipedia page.All the data comes from 2022 FIFA World Cup page on Wikipedia.But here is the quick run-down of the process: ![]() I plan to make a video explaining the process if time permits. The workbook uses Power Query in Excel to connect to Wikipedia page and fetch standings & results. If you hit CTRL ALT F5 (or Data ribbon > Refresh All), the group standings, points etc. ![]() The workbook also provides match schedules (dates & times as per local Qatar timezone) and quick access links to the match report. Switch between Fantasy and actual standings anytime. Pick your own winners for each of the 48 group stage matches and then see how that pans out at the knock-out stages (bracket view) with this cool Fantasy view. They will auto-update whenever you refresh the workbook.įantasy View (set your own Group Stage Winners) Two separate tabs provide clear view of the schedules & results from Group Stage & Knock out stage of the football worldcup. ![]() Features of this FIFA World Cup Schedule Workbook: This fixed a bug with the knockout stage view (bracket).ĭownload the Excel workbook (Excel 365 version)ĭon’t have Excel 365? Use the Non 365 version here. Download the FREE Excel Workbooks (updated on 6 December):ĭownload the latest files from below links. It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |