The board's server will undergo upgrade maintenance tonight, Nov 5, 2014, beginning approximately around 10 PM ET. Prepare for some possible down time during this process.
FAQ    Search

Board index » Help, Help » Technical Support




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Help B with an Excel Question
PostPosted: Wed April 27, 2016 2:08 am 
Offline
User avatar
Troglodyte
 WWW  Profile

Joined: Wed December 19, 2012 9:53 pm
Posts: 22334
Location: Chapel Hill, NC, USA
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?


Top
 
 Post subject: Re: Help B with an Excel Question
PostPosted: Wed April 27, 2016 2:26 am 
Offline
User avatar
NEVER STOP JAMMING!
 Profile

Joined: Sun September 15, 2013 5:50 am
Posts: 22076
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


Top
 
 Post subject: Re: Help B with an Excel Question
PostPosted: Wed April 27, 2016 3:22 am 
Offline
User avatar
F.U.B.A.R
 WWW  Profile

Joined: Wed July 03, 2013 11:21 pm
Posts: 9033
Location: Lft Craquepeau
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 :(


Top
 
 Post subject: Re: Help B with an Excel Question
PostPosted: Wed April 27, 2016 3:23 am 
Offline
User avatar
An enigma of a man shaped hole in the wall between reality and the soul of the devil.
 Profile

Joined: Tue January 01, 2013 5:13 pm
Posts: 39365
Location: 6000 feet beyond man and time.
wat

_________________
RM's resident disinformation expert.

“And truly, if life had no purpose, and I had to choose nonsense, this would be the most desirable nonsense for me as well."


Top
 
 Post subject: Re: Help B with an Excel Question
PostPosted: Wed April 27, 2016 11:31 am 
Offline
User avatar
Polluted
 Profile

Joined: Tue January 01, 2013 10:27 am
Posts: 4202
Location: PM me, I have everything.
I'm looking at csv file that has 2743 lines with 9 fields. The fields average 10 characters and the file is 288 KB.


Top
 
 Post subject: Re: Help B with an Excel Question
PostPosted: Wed April 27, 2016 12:18 pm 
Offline
User avatar
Guys, I am not a moderator! I swear to God! Why does everyone think I'm a moderator?
 Profile

Joined: Tue January 01, 2013 2:48 pm
Posts: 46539
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


Top
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

Board index » Help, Help » Technical Support


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
It is currently Tue March 19, 2024 4:41 am