3 ms·
Putting aside the issue of whether or not Excel is suitable. Excel has a column limit of 16,384 columns. Could this mean they are storing each person as a colum
by rrayns 6y ago
Putting aside the issue of whether or not Excel is suitable. Excel has a column limit of 16,384 columns. Could this mean they are storing each person as a column? That seems a pretty strange way of recording this data. Or have they gone 16,000 over the 1,048,576 row limit?
- sdeer 6y agoThe article says they went over the row limit so the later.
- thomasedwards 6y agoUsing Excel is strange, so using columns really isn’t a massive leap. It is rows as per other articles, there aren’t even that many tests available to go over 1m.
- deleted 6y ago[deleted]
- i_are_smart 6y agoModern versions of excel (after office 2007), using .xlsx files, have a 1,048,576 row limit. But older versions of excel (before office 2007) used .xls files and had a limit of 65,536 rows. I could easily see them exceeding this limit, if they were using an older version of excel. Alternatively, even the new versions of excel enforce the 2^16 row limit if working on a .xls file instead of a .xlsx file.