Page 1 of 1

Help B with an Excel Question

Posted: Wed April 27, 2016 2:08 am
by B
So, for work, I'm giving providers some temperature data loggers that take a store a temperature reading every half hour. That's about 17,500 lines in a csv file if they let it go for a year. I keep getting asked, how big of a thumb drive would you need to hold that size of an excel sheet.

I can't imagine it takes very much space at all, but I just have no idea. Anyone have a guess at how big that file would be at the end of a year?

Re: Help B with an Excel Question

Posted: Wed April 27, 2016 2:26 am
by 96583UP
if it's just a number per line that's not gonna take up too much memory

i wonder if that would even approach 10 MB

some other honkey help me out here

Re: Help B with an Excel Question

Posted: Wed April 27, 2016 3:22 am
by Sgt. Crackpot
How much data per line, i.e. how many characters?

Could be as small as 150K, or up to around a few MB or so. Do you have a sample line of data?

Re: Help B with an Excel Question

Posted: Wed April 27, 2016 3:23 am
by BurtReynolds
wat

Re: Help B with an Excel Question

Posted: Wed April 27, 2016 11:31 am
by Self
I'm looking at csv file that has 2743 lines with 9 fields. The fields average 10 characters and the file is 288 KB.

Re: Help B with an Excel Question

Posted: Wed April 27, 2016 12:18 pm
by E.H. Ruddock
B, you can get a 64GB thumb drive for like ten bucks. I don't think you'll hit that with an excel sheet.