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?
Help B with an Excel Question
- 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
Everything's perfectly all right now. We're fine. We're all fine here, now, thank you. How are you?
- 96583UP
- The Master
- Posts: 29574
- Joined: Sun September 15, 2013 5:50 am
Re: Help B with an Excel Question
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
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
- 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
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?
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
- 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.
- 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
I'm looking at csv file that has 2743 lines with 9 fields. The fields average 10 characters and the file is 288 KB.
- 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
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