• 21 Posts
  • 189 Comments
Joined 1 year ago
cake
Cake day: June 2nd, 2024

help-circle






  • Look at the last table in my original post. It contains 26 columns (A–Z), some of which are not shown, and 27 rows (blank–Z). There are 27 rows and 26 columns, regardless of the contents of the table. If the top-left cell (A, blank) were a 1 and (B, blank) were a 2, then (Z, blank) would contain a 26, and ZZ would contain a 702. Nothing about the layout of that table changes.

    To summarize: The table will always be lopsided, if you start counting at 0 or at 1.




  • I have been able to outsource low level parsing to third party libraries

    Hahaha!!!

    Today I watched a Java server crash because a library decided it needed more than 3GB of heap space to read a 10MB file. That was after manually removed background colors from around 100,000 cells, which apparently caused the parser to create even more objects in its internal representation of the sheet.















  • I take it the most pressing issue right now is cooling. If that is right, you might have yet another avenue to explore: Ask facilities with cooling needs if you can store one or two pallets there. I’m thinking schools, (yet again) restaurants, ice cream parlors, ice skating rinks (not sure how they work exactly – is the whole building cooled or just the rink itself?), butchers. You could ask an outdoor gear shop (I mean a place where skis and winter jackets etc. are sold) if they know of a place where one can test jackets. They might know a cool place, too.