Help B with an Excel Question

Post Reply
User avatar
B
Troglodyte
Posts: 24953
Joined: Wed December 19, 2012 9:53 pm
Twitter: https://bsky.app/profile/rectormsw.bsky.social
Location: Chapel Hill, NC, USA

Help B with an Excel Question

Post 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?
Everything's perfectly all right now. We're fine. We're all fine here, now, thank you. How are you?
User avatar
96583UP
The Master
Posts: 29574
Joined: Sun September 15, 2013 5:50 am

Re: Help B with an Excel Question

Post 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
All posts by this account, even those referencing real things, are entirely fictional and are for entertainment purposes only; i.e. very low-quality entertainment. These may contain coarse language and due to their content should not be viewed by anyone
User avatar
Sgt. Crackpot
F.U.B.A.R
Posts: 9104
Joined: Wed July 03, 2013 11:21 pm
Twitter: RobertDowneyJr
Location: Lft Craquepeau
Contact:

Re: Help B with an Excel Question

Post 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?
Rangi Guy wrote:So skating back to the train station after work today things went wrong.....now my skateboard is at the bottom of the harbour :(
User avatar
BurtReynolds
An enigma of a man shaped hole in the wall between reality and the soul of the devil.
Posts: 45825
Joined: Tue January 01, 2013 5:13 pm
Location: 6000 feet beyond man and time.

Re: Help B with an Excel Question

Post by BurtReynolds »

wat
RM's resident disinformation expert.
User avatar
Self
Polluted
Posts: 4644
Joined: Tue January 01, 2013 10:27 am
Location: PM me, I have everything.

Re: Help B with an Excel Question

Post 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.
User avatar
E.H. Ruddock
Guys, I am not a moderator! I swear to God! Why does everyone think I'm a moderator?
Posts: 51786
Joined: Tue January 01, 2013 2:48 pm

Re: Help B with an Excel Question

Post 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.
Clouuuuds Rolll byyy...BANG BANG BANG BANG
Post Reply