Click here to Skip to main content
15,436,185 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

When building an application, when is the most important time to consider the User Experience?
They are the ones we write code for, right?
  Results   297 votes