Click here to Skip to main content
15,434,296 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: We're IT: We're here to _help_ you... Pin
Super Lloyd23-Nov-20 19:14
MemberSuper Lloyd23-Nov-20 19:14 
GeneralThought of the Day Pin
OriginalGriff23-Nov-20 4:51
mveOriginalGriff23-Nov-20 4:51 
QuestionRe: Thought of the Day Pin
megaadam23-Nov-20 5:02
professionalmegaadam23-Nov-20 5:02 
AnswerRe: Thought of the Day Pin
Johnny J.23-Nov-20 5:21
professionalJohnny J.23-Nov-20 5:21 
GeneralRe: Thought of the Day Pin
W Balboos, GHB23-Nov-20 5:26
mveW Balboos, GHB23-Nov-20 5:26 
GeneralRe: Thought of the Day Pin
Daniel Pfeffer23-Nov-20 9:48
professionalDaniel Pfeffer23-Nov-20 9:48 
GeneralRe: Thought of the Day Pin
Richard Deeming23-Nov-20 17:53
mveRichard Deeming23-Nov-20 17:53 
GeneralThe joys of Excel Pin
Dan Neely23-Nov-20 3:58
MemberDan Neely23-Nov-20 3:58 
I was updating the queries to generate a monster report (~33k rows, 1400 columns, 46m cells of data) and after seeing the output file wasn't the same size in the new version needed a way to compare them and see where they were different. Since Excel had no problems opening the file, or a file that had both versions of the report pasted into different tabs I figured I'd just do a 3rd tab to compare them. So I wrote my basic formula =tab1!A1=tab2!A1 selected all 46m cells on the 3rd tab and hit Ctrl-V figuring I'd have an searchable diff to look at where my results changed in a few seconds.

It took 50 minutes to complete, and peaked at 14GB of ram consumed and finished out at 12gb (only 2 after a close/reopen). The file with the formulas in it was also laggy as hell, although I managed to solve that by pasting the comparison as values into a 4th tab and deleting the 3rd. But I still need to figure out what actually went wrong with the report itself. Cry | :((

Proving once again that age old bit of wisdom: I had a problem. I used regular expressions Excel, now I have two problems. D'Oh! | :doh:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt

GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 4:07
protectorNelek23-Nov-20 4:07 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:10
MemberDan Neely23-Nov-20 4:10 
GeneralRe: The joys of Excel Pin
OriginalGriff23-Nov-20 4:21
mveOriginalGriff23-Nov-20 4:21 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:48
MemberDan Neely23-Nov-20 4:48 
GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 4:45
protectorNelek23-Nov-20 4:45 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 4:51
MemberDan Neely23-Nov-20 4:51 
GeneralRe: The joys of Excel Pin
Nelek23-Nov-20 7:15
protectorNelek23-Nov-20 7:15 
GeneralRe: The joys of Excel Pin
g_p_l23-Nov-20 4:22
Memberg_p_l23-Nov-20 4:22 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 5:18
MemberDan Neely23-Nov-20 5:18 
GeneralRe: The joys of Excel Pin
Southmountain23-Nov-20 7:38
MemberSouthmountain23-Nov-20 7:38 
GeneralRe: The joys of Excel Pin
kmoorevs23-Nov-20 5:44
Memberkmoorevs23-Nov-20 5:44 
GeneralRe: The joys of Excel Pin
Slacker00723-Nov-20 5:51
professionalSlacker00723-Nov-20 5:51 
GeneralRe: The joys of Excel Pin
Dan Neely23-Nov-20 6:58
MemberDan Neely23-Nov-20 6:58 
GeneralRe: The joys of Excel Pin
Peter Adam23-Nov-20 6:37
professionalPeter Adam23-Nov-20 6:37 
GeneralRe: The joys of Excel Pin
Sander Rossel23-Nov-20 21:17
professionalSander Rossel23-Nov-20 21:17 
GeneralRe: The joys of Excel Pin
Dan Neely24-Nov-20 2:33
MemberDan Neely24-Nov-20 2:33 
GeneralWhat tools and services do you now consider part of your daily workflow? Pin
Chris Maunder23-Nov-20 3:31
cofounderChris Maunder23-Nov-20 3:31 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

Who do you listen to most when making decisions about software development?
  Results   463 votes