I need new ideas

[Legacy 420921]

I want create new NFL schedule file. anybody have any ideas.


Thanks You


Thomas

 

[DRSteele]

I do. Instead of typing in your scores, use Power Query to download the data from a website. I do it every day during NHL season. The scores come from this website (https://www.hockey-reference.com/) and the rest of my enormous file contains the analysis.

https://www.pro-football-reference.com/

Those websites are formatted in such a way that all the data is in HTML tables that PQ can parse. Most other websites (like NHL.com and whatever the one is for futbol) use formatting that PQ cannot grab.

 

[Legacy 420921]

click link to get my file
https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=pXCZjo


i want to create new file different way that why i need ideas





thanks you

Thomas

 

[Legacy 420921]

https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=ChlD2N

click link above to get my last file I made.

anbody have any new ideas let me know. if possible give me a sample file.


Thanks you

Thomas