Introducing WinLogStats PDB to Excel converter

User avatar
Brian-Broncos
Posts: 103
Joined: Wed Jan 17, 2024 8:49 am
Location: Minneapolis

Introducing WinLogStats PDB to Excel converter

Postby Brian-Broncos » Wed Mar 27, 2024 6:39 pm

With a name that just rolls off of the tongue, I bring you PDBtoXLSX.

Python needed. See the .docx for instructions.

https://drive.google.com/file/d/1TpTGvLdOyiD_tedIP0SC96T2XzVCdBOl/view?usp=drive_link

Oh yeah, I think this will run on Windows 7 and later, but it's only been tried on Windows 11.

Let me know if you find any issues or need help getting setup.
May the forces of evil become confused on the way to your house. - George Carlin

User avatar
Brian-Broncos
Posts: 103
Joined: Wed Jan 17, 2024 8:49 am
Location: Minneapolis

Re: Introducing WinLogStats PDB to Excel converter

Postby Brian-Broncos » Wed Mar 27, 2024 8:08 pm

The advantage is, since it's Excel, you can easily filter by team or sort by play or use Excel formulas to manipulate the data, such as totalying results per play.

Image
May the forces of evil become confused on the way to your house. - George Carlin

User avatar
Mitch-Oilers
Posts: 1232
Joined: Thu Jun 13, 2019 10:11 am

Re: Introducing WinLogStats PDB to Excel converter

Postby Mitch-Oilers » Wed Mar 27, 2024 8:26 pm

Once you get everything setup, its very easy to use.

Thank you for creating such a timesaving tool!
AFC West Champion 2038, 2039, 2041, 2043, 2044
AFC Champion 2043

Donovon-Steelers
Posts: 167
Joined: Mon Jan 30, 2023 2:35 pm
Location: Findlay, Ohio

Re: Introducing WinLogStats PDB to Excel converter

Postby Donovon-Steelers » Thu Mar 28, 2024 8:31 am

I can see why Brian's competitive already right away after joining the league - look forward to utilizing this tool - great work, thanks!

User avatar
Brian-Broncos
Posts: 103
Joined: Wed Jan 17, 2024 8:49 am
Location: Minneapolis

Re: Introducing WinLogStats PDB to Excel converter

Postby Brian-Broncos » Thu Mar 28, 2024 10:41 am

Actually, this is why I'm not competitive. Spending all my time on tools - mostly cause I can't stand updating the profiles in the game. Some day soon there will be FBProProfileEditor™.
May the forces of evil become confused on the way to your house. - George Carlin

Rich-League Officer
Posts: 1703
Joined: Tue Jun 11, 2019 12:16 pm
Location: Gilbert, Arizona
Contact:

Re: Introducing WinLogStats PDB to Excel converter

Postby Rich-League Officer » Thu Mar 28, 2024 1:02 pm

I also uploaded on the website.
https://pnfl.biz/Utilities.htm


Thanks Brian!
Image

James-Eagles
Posts: 753
Joined: Mon Jun 17, 2019 5:52 pm

Re: Introducing WinLogStats PDB to Excel converter

Postby James-Eagles » Thu Mar 28, 2024 1:07 pm

Mitch-Oilers wrote:Once you get everything setup, its very easy to use.

Thank you for creating such a timesaving tool!

Stop giving Mitch help he already is a paint to beat

User avatar
Dean-Atlanta
Posts: 1447
Joined: Fri Oct 25, 2019 3:46 pm
Location: Lynnwood, WA

Re: Introducing WinLogStats PDB to Excel converter

Postby Dean-Atlanta » Thu Mar 28, 2024 1:53 pm

You beat him. As I predicted you would. By nearly the score I predicted.
Dean
The Atlanta Falcons

"We may win big or lose big, but we don't dodge anybody and we don't makes excuses when we lose."
- Jerry Glanville

James-Eagles
Posts: 753
Joined: Mon Jun 17, 2019 5:52 pm

Re: Introducing WinLogStats PDB to Excel converter

Postby James-Eagles » Fri Mar 29, 2024 6:24 am

Dean-Atlanta wrote:You beat him. As I predicted you would. By nearly the score I predicted.

Broke clock and all.

User avatar
Matt-Jacksonville
Posts: 769
Joined: Thu Jul 04, 2019 8:58 pm
Location: South Texas

Re: Introducing WinLogStats PDB to Excel converter

Postby Matt-Jacksonville » Sat Mar 30, 2024 7:47 am

Guys, don't forget to get the DB exactly as you want it prior to running this utility. You still have to move pass plays that get flagged as run plays back to the pass tab and vice versa prior to running this or it will create an excel file with those pass plays under the run sheet.


Return to “General”

Who is online

Users browsing this forum: No registered users and 20 guests