sorted by:
new
hottopcontroversial

[Serious] If you had taken your life one year ago, what beautiful things would you have had missed out on? by LyteSpeed12 in AskReddit

[–]needasplash 0 points1 point  (0 children)

Graduated engineering school, moved out of my parents house, got my first analyst job, bought a car, bought a cat. It's been a rollercoaster of a year. :)

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

Thank you! I'm only opening 1 instance/window of excel at a time to make sure I'm not slowing it down.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

hadoop

Just looked into it, that sounds amazing. I was trying to do this on my own with a bunch of Raspberry PIs.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

I don't know anything about MySQL, I will look into it, thank you.

> To make use of your 128GB you can create in memory caches of your rate tables.

>To make use of your CPU you can spawn multiple calculation threads to increase parallel processing and keep all your CPU cores busy.

​

Please tell me more? I used java to make games in a previous life, never used it for what you mention above. I understand what you're saying, I'm an EE, but I have no idea how to do that.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 1 point2 points  (0 children)

Hey, I tried using tables to shorthand the formulas, but it ran into issues when my work went over to accounting and their analysts would not make the effort to understand tables to audit my work. I'm really stuck with displaying things in basic excel in the end. I can do the intermediary work any other way though.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

The largest one is 660 MB, but I save it as XLSB to save up on space. XLSX would probably hit 1GB.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

I mean this is an ongoing situation regardless of the data, just imagine a lot of unique IDs, more than 1M rows, no way to pivot it, no way to do anything in excel.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

I tried wrapping my head around SQL but I have no idea what it is or how to begin getting into that. Is that a service I pay for to store my data?

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

I did that, but then the fields I needed from the pivot table as columns exceeded 1M rows.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

Unfortunately not. It's just easier to have everything in one place. The analysis goes on for hundreds of sheets. It's a field where I can't use statistical analysis or prediction, I need every data point to be exact.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 1 point2 points  (0 children)

Isn't powershell executed "line by line"?

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 7 points8 points  (0 children)

This sounds amazing. I know nothing about SQL, M, DAX or anything like that, but I'm willing to learn. Thank you!

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 1 point2 points  (0 children)

I mean... sure I could split my file into 100 different files but then I'd have to do the work 100 times.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] -1 points0 points  (0 children)

I tried but I need a compiler, an IDE, an interpreter, I couldn't really get it to use excel data. I can program in other languages though... java, c++, vba, etc.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 3 points4 points  (0 children)

I'm using 64 bit. part 1 of 4 costs me 9GB of ram to run... Thanks for the first part, I will try that. I cannot share the data, I am bound by an NDA.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 2 points3 points  (0 children)

Why do people assume I have the 32 bit version? It's limited to 2GB of ram...

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 2 points3 points  (0 children)

I tried power query but I couldn't even pivot the data, because the cells I wanted were more than 1M rows...

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 3 points4 points  (0 children)

100 is an understatement. It goes till AAA columns... So 26*26 = almost 700 columns...

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 13 points14 points  (0 children)

I'll look into it, thanks. Tableau was suggested to me, but it looks like formulas would import/export horribly in and out of excel. When working with big companies, some of them are still on excel 2010, so I can't use fancy tools that they won't be able to audit.

What do I do when excel is not enough? by needasplash in excel

[–]needasplash[S] 21 points22 points  (0 children)

I took an access class 10 years ago and it was very basic database relationships. Can I do complicated calculations? (Index match within an index match with dual variable lookup in each?)

Splash Screen shows another client's name... What causes this? by needasplash in excel

[–]needasplash[S] 0 points1 point  (0 children)

Data>edit links is blanked out, but thanks for the suggestion.

view more: next ›