New Sticky Note

NOTICE: This league is using the BLEEDING EDGE game engine. For more information, click here.

The new user interface is in preview!

Want to check it out? Click here! (If you don't like it, you can still switch back)

League Forums

Main - Beta Bug Box

Passes Knocked Down in CSV File have Null Value for YardsGained

By setherick
9/28/2019 9:28 pm
This probably only applies to me, but the YardsGained is null in the CSV file for games when a pass is knocked down. This makes importing the CSV into a SQLite database ... interesting.

Re: Passes Knocked Down in CSV File have Null Value for YardsGained

By shauma_llama
9/29/2019 7:45 am
If you want a formula for "was this play a run or a pass?" that's also tricky as you have to parse the text of the play description.

Re: Passes Knocked Down in CSV File have Null Value for YardsGained

By setherick
9/29/2019 7:49 am
shauma_llama wrote:
If you want a formula for "was this play a run or a pass?" that's also tricky as you have to parse the text of the play description.


Yeah, I noticed that as well. It's pretty obnoxious, but not as obnoxious as loading extension-functions.c on Windows. (Luckily I found a compiled version on github.)

Re: Passes Knocked Down in CSV File have Null Value for YardsGained

By shauma_llama
9/29/2019 7:52 am
Creating cell-functions in portable apps' spreadsheet app is really tough when there are nulls.

Re: Passes Knocked Down in CSV File have Null Value for YardsGained

By setherick
9/29/2019 7:56 am
shauma_llama wrote:
Creating cell-functions in portable apps' spreadsheet app is really tough when there are nulls.


Gross. Didn't consider that.