Excel formating for exports

[dengland]

I am not sure if I have missed something over the years or the ability is not there ....

Thanks again for this site as it saves me a ton of time keeping track of my league.

My workflow for creating a league report after each tournament (that I ultimately text out as an image) includes post processing on both the tournament rankings file and on the rankings.xlsx.

I produce a excel file that looks like this:


Post processing of the Tournament Rankings.xlsx includes removal of "points", "Round Out" and "Time Out" (Poker Maven does not populate round or time out correctly). I also change the alignment of "Position" to CENTER to match how Buy-in, Rebuy, and Add-on are displayed.

The export of rankings looks like this:


Post processing of Rankings.xlsx includes formatting of Total K.O to be a whole number with no decimal points. I change the alignment of Position, Number of tournaments, Total K.O, 1st place, 2nd place, and 3rd place to CENTER. I leave Total Net gains alone because it appears that it is a text field instead of a number. It (Net Gains) is a number in Tournament Rankings.xlsx. Actually, all the money fields are numeric.

Have I overlooked a feature that allows me to control the formatting of the fields? If it does not exist, that would be a great add.

Respectfully, I would like to request that Total K.O be output as an integer since that is the only value that makes sense and Total Net Gain be output as a number instead of text. My preference is that it is the same as Tournament Rankings.xlsx.

Thanks again for all the effort you have put into StatGenie. As others have stated, should you decide to charge something for this service, I would subscribe. Or if you added a "buy me a coffee button" I would gladly click based on the time you save me keeping the books.

[StatsGenie]

Hi Dengland,

lots of content in your question, I will try to address each point individually.

On a side note, before I begin, you could also generate ranking widgets and simply post the links to the widgets and they would update dynamically, removing your need to export/send images of updated rankings after each tournament (Look out for gear icon in header of different pages that allow you to create widgets, often besides the "export to excel" button).

Post processing of the Tournament Rankings.xlsx includes removal of "points", "Round Out" and "Time Out" (Poker Maven does not populate round or time out correctly). I also change the alignment of "Position" to CENTER to match how Buy-in, Rebuy, and Add-on are displayed.

You can create custom rankings and/or edit default Rankings using "Manage Leagues -> Rankings Management" this would allow you to remove unwanted columns from your ranking thus not needing to remove them from exported excel (Or widget link) afterward.

Unfortunately, column alignements are not editable in rankings management.

Post processing of Rankings.xlsx includes formatting of Total K.O to be a whole number with no decimal points. I change the alignment of Position, Number of tournaments, Total K.O, 1st place, 2nd place, and 3rd place to CENTER. I leave Total Net gains alone because it appears that it is a text field instead of a number. It (Net Gains) is a number in Tournament Rankings.xlsx. Actually, all the money fields are numeric.

Total K.O. is decimal based because of the way many Tournament Managers calculate K.O. . For example, if 2 players win the hand (split pot) that knocks out 1 player, they each get credited 0.5 K.O. as the K.O. is split amongst the winners, I do not intend to change this.

Have I overlooked a feature that allows me to control the formatting of the fields? If it does not exist, that would be a great add.

No overlook, this is not a feature and not a planned feature either. The field formattings should be consistent with data stored in database. We possibly have a bug here were numeric fields are exported to excel as strings, but this might be because of your decimal seperator in Excel that is not recognized so Excel converts the "numeric" field to "string".

Thanks again for all the effort you have put into StatGenie. As others have stated, should you decide to charge something for this service, I would subscribe. Or if you added a "buy me a coffee button" I would gladly click based on the time you save me keeping the books.

Thank you for the kind words, it is noted .

[dengland]

Thank for the detailed reply. I will take a much better look at the widgets as you suggested.

I am now just being curious on the difference I see between the two exports.

Should I make the assumption that records created in the what I am guessing is a tournament table are based on how they are presented in the inport file:

Code: Select all

Start=2024-01-24 19:30:00
Place7=sharkbait (0) Paid:20 Rebuys:1 KO:Psycho_bunny
Place6=CasinoDog (0) Paid:10 Rebuys:0 KO:Roxy44
Place5=Pootz (0) Paid:10 Rebuys:0 KO:Roxy44
Place4=Dexter (0) Paid:10 Rebuys:0 KO:Psycho_bunny
Place3=whitetornado (0) Paid:10 Rebuys:0 KO:Psycho_bunny
Place2=Roxy44 (28) Paid:10 Rebuys:0 KO:Psycho_bunny
Place1=Psycho_bunny (52) Paid:10 Rebuys:0 KO:Psycho_bunny
Stop=2024-01-24 21:27:30

So, when exported, Tournament Rankings.xlsx everything looks like integers and when you create Rankings.xlsx in an export you are expecting and formatting for X.X for knockouts and two decimals for currency on Total net gain?

Thanks

[StatsGenie]

Hi,

no link between imported tournament file format as all imported stats are converted to StatsGenie format... There might be some extract differences explaining this, we will investigate and get back to you.

[StatsGenie]

There is no custom manipulation of column types while exporting.

This being said, I did notice net gains being exported as strings, and this is probably due to negative number formats not recognized in excel
(ie: (40.00) instead of -40.00)

We do not plan to modify the extract for the moment.

[dengland]

There is no custom manipulation of column types while exporting.

This being said, I did notice net gains being exported as strings, and this is probably due to negative number formats not recognized in excel
(ie: (40.00) instead of -40.00)

We do not plan to modify the extract for the moment.

Thanks for the work investigating. I will put some time in with the widgets. No worry on the "no plans to modify." Thanks again.

[dengland]

I think the Rankings widget is correct (optimized, as close to final as I can get it.)

https://hsopv3.statsgenie.com/Stats_Ran ... 240EDB92DD




For the tournament ranking widget, I can eliminate "Time Out" and "Round Out", but points is NOT available to select or not select.



I think this is where you were pointing me. If not, please let me know. Otherwise, I am good. Again, I appreciate your responses above.

[StatsGenie]

Yes, I guess we figured for a league, tournament listings should always include points column, so it is in fact not available for removal for this setting