221–230 of 435 posts
Earlier quoted context omitted.
> 4. Someone who knows the limit is 10 sheets and 20MB Excel can now deal with many gigs of data thanks to PowerPivot and the addition of an in-memory database.
it's not excel that's the problem - it's you or your replacement 6 months later trying to reverse engineer the iterated solution that you willed into being... ;-)
People say "use a real database", fine, but where is the visual data entry? Where are the easy adhoc reports? Where are the forms? I guess if you're on Windows you can use Microsoft Access, but that's the only accesible tool I know of that doesn't require a team of programmers or an enterprise license for some Oracle/SAP type monstrosity.
Any visual DB client?
> Where are the easy adhoc reports?
Isn't that just queries? Then throw it into a view to "save".
> Where are the forms?
No idea what you're looking for here, but this sounds a lot like your first question.
Earlier quoted context omitted.
> 4. Someone who knows the limit is 10 sheets and 20MB Excel can now deal with many gigs of data thanks to PowerPivot and the addition of an in-memory database.
FTFY: "Excel THINKS IT CAN DEAL with many gigs of data thanks to PowerPivot and the addition of an in-memory database." It's so cute when I hit ctrl-downarrow on a blank sheet and Excel sends me to row 1,048,576. Wishful thinking because if I ever filled 1M cells with functions, well... lololololol... time to use JMP...
Earlier quoted context omitted.
There are plenty of people whp are great at excel but you chose to talk about him. Don't give that guy any more attention. Thats what he wants. Lets all just forget about him and go on with our lives.
It is sad to me how effective the smear campaign against Shkreli was.
And before anybody downvotes me- please inform yourself- not a single person had to pay a penny more than what they had to pay before the price increase, except the insurance firms.
Earlier quoted context omitted.
It's less "not wanting to help people" and more "once people know you're 'the Excel person' they come to you for everything to do with Excel". It's very similar to being 'the computer person' in a family/group of friends and everyone coming to you with all their various tech support questions. At a certain point, it starts ruining your productivity since you get taken out of your regular job to do these one time help…
This is my experience working in offices like law firms that are filled with people that have limited technical aptitude for using software. Showing any sort of competency is a recipe for increasing your workload with no conferred benefits.
Earlier quoted context omitted.
There are plenty of people whp are great at excel but you chose to talk about him. Don't give that guy any more attention. Thats what he wants. Lets all just forget about him and go on with our lives.
It is sad to me how effective the smear campaign against Shkreli was.
HN is the only place I find people defending that guy. I suspect it's because this forum is full of douchebags who identify with him.
Shameless plug - we actually founded a service [1] that provides Excel experts on-demand, within 30 to 60 seconds. So if you're tired of being the "Excel expert" at work feel free to pass them on to us. Also happy to answer any questions. Tidbit: Most popular questions tend to be formulas, vlookups, conditional formatting, pivots. [1] https://www.excelchat.co
Earlier quoted context omitted.
It is sad to me how effective the smear campaign against Shkreli was.
Insurance firms send a clear message- fuck with us and we completely ruin you. And before anybody downvotes me- please inform yourself- not a single person had to pay a penny more than what they had to pay before the price increase, except the insurance firms.
Earlier quoted context omitted.
Obligatory Comment: "Excel as a Database" by Rory Blyth, circa early 2000's. "As a developer, you've probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of 'data' by someone in marketing and told to 'do something with it.' " http://wyorock.com/excelasadatabase.htm
As a developer, what should I do if I actually want to do that? Because I get a lot of satisfaction out of massaging messy wads of data into a clean, uniform, accessible form. Is there a job title or something I should look for?