143 reputation
5
bio website
location Boston, MA
age
visits member for 2 years, 11 months
seen Sep 1 '13 at 14:56

Feb
19
awarded  Scholar
Feb
19
accepted Best way to represent null and empty data in an excel file
Feb
6
awarded  Supporter
Feb
5
comment Best way to represent null and empty data in an excel file
null sign is neat. do you know offhand if there are any popular stats programs that don't like unicode?
Feb
5
comment Best way to represent null and empty data in an excel file
isn't the value chosen for the default text an important part of the user experience? the csv file is system generated so we couldn't put formatting in it manually.
Feb
5
comment Best way to represent null and empty data in an excel file
thanks, added a note that since we also depend on .csv we need a solution that doesn't only rely on formatting.
Feb
5
comment Best way to represent null and empty data in an excel file
Yeah, so in our forms, questions can be made (ir)relevant by other questions, and it's important to be able to differentiate in the export from "this question wasn't asked" versus "this question wasn't answered".
Feb
5
awarded  Editor
Feb
5
revised Best way to represent null and empty data in an excel file
added 108 characters in body
Feb
5
awarded  Student
Feb
5
asked Best way to represent null and empty data in an excel file
Sep
19
awarded  Teacher
Sep
16
answered What makes a good form?