New Sticky Note

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

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.