Click here to Skip to main content
15,894,343 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: Good grief Pin
Wendelius7-Nov-16 7:20
mentorWendelius7-Nov-16 7:20 
GeneralRe: Good grief Pin
Dar Brett8-Nov-16 3:28
Dar Brett8-Nov-16 3:28 
GeneralRe: Good grief Pin
Dan Neely7-Nov-16 4:09
Dan Neely7-Nov-16 4:09 
GeneralRe: Good grief Pin
OriginalGriff7-Nov-16 4:10
mveOriginalGriff7-Nov-16 4:10 
GeneralGood Griff! Pin
megaadam7-Nov-16 4:19
professionalmegaadam7-Nov-16 4:19 
GeneralRe: Good grief Pin
Dan Neely7-Nov-16 4:26
Dan Neely7-Nov-16 4:26 
GeneralRe: Good grief Pin
Ian Shlasko7-Nov-16 4:39
Ian Shlasko7-Nov-16 4:39 
GeneralRe: Good grief Pin
Dan Neely7-Nov-16 4:47
Dan Neely7-Nov-16 4:47 
Ian Shlasko wrote:
Just like Excel... It's an amazing application if you use it as a spreadsheet, or for prototyping. Once you have tons of VBA macros and entire applications written in it, you'll want to shoot yourself. Been there, too.


Fortunately(?) by the time your Excel turns into exHell it'll be slow enough that the bullet won't be able to break your skin.

I had one of those too, as an initial proof of concept I ported the big nasty data mangling step to C# and called it from the VBA using COM (with was a cluster elephant in and of itself). It dropped the run time on our worst data set from ~6 hours to 45 seconds. Of which ~30 were spent scraping the spreadsheet and sending it over COM, 15 were spent by C# to do the data mangling, and <1 was spent to write the much smaller data set back to the spreadsheet.

The truly amazing bit was that the intern/very junior dev (not sure if he went full time before or after writing it) managed to get the >1000 lines of very complex logic copy pasta with about 8 intend levels and gotos to short circuit another half dozen working and fully debugged. OMG | :OMG:
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging 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: Good grief Pin
Ian Shlasko7-Nov-16 5:41
Ian Shlasko7-Nov-16 5:41 
GeneralRe: Good grief Pin
Foothill7-Nov-16 6:06
professionalFoothill7-Nov-16 6:06 
GeneralRe: Good grief Pin
F-ES Sitecore7-Nov-16 4:56
professionalF-ES Sitecore7-Nov-16 4:56 
GeneralRe: Good grief Pin
kmoorevs7-Nov-16 9:42
kmoorevs7-Nov-16 9:42 
GeneralRe: Good grief PinPopular
BryanFazekas8-Nov-16 1:21
BryanFazekas8-Nov-16 1:21 
GeneralRe: Good grief Pin
glennPattonWork37-Nov-16 5:32
professionalglennPattonWork37-Nov-16 5:32 
GeneralRe: Good grief Pin
Ian Shlasko7-Nov-16 5:38
Ian Shlasko7-Nov-16 5:38 
GeneralRe: Good grief Pin
glennPattonWork37-Nov-16 5:49
professionalglennPattonWork37-Nov-16 5:49 
GeneralRe: Good grief Pin
Kornfeld Eliyahu Peter7-Nov-16 5:55
professionalKornfeld Eliyahu Peter7-Nov-16 5:55 
GeneralRe: Good grief Pin
Ian Shlasko7-Nov-16 7:31
Ian Shlasko7-Nov-16 7:31 
GeneralRe: Good grief Pin
Kornfeld Eliyahu Peter7-Nov-16 7:34
professionalKornfeld Eliyahu Peter7-Nov-16 7:34 
GeneralRe: Good grief Pin
Ian Shlasko7-Nov-16 11:22
Ian Shlasko7-Nov-16 11:22 
GeneralRe: Good grief Pin
pkfox7-Nov-16 10:47
professionalpkfox7-Nov-16 10:47 
GeneralRe: Good grief Pin
Tim Carmichael7-Nov-16 5:25
Tim Carmichael7-Nov-16 5:25 
GeneralRe: Good grief Pin
Sander Rossel7-Nov-16 5:36
professionalSander Rossel7-Nov-16 5:36 
GeneralRe: Good grief Pin
Jörgen Andersson7-Nov-16 6:18
professionalJörgen Andersson7-Nov-16 6:18 
GeneralRe: Good grief Pin
PIEBALDconsult7-Nov-16 6:02
mvePIEBALDconsult7-Nov-16 6:02 

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.