211–220 of 275 posts
Earlier quoted context omitted.
My dad, a retired accountant, still refuses to switch from Lotus 1-2-3 to Excel.
Tell him about my Linux port, I'm updating it regularly and fixing bugs :) https://github.com/taviso/123elf/wiki/Getting-Started
Excel runs the world. Every large company claiming to be ERP-native is telling lies. Shit gets done in Excel, and is then exported back into ERP, if at all. Things you would consider quite irresponsible to be done in Excel, is done in Excel regardless. Indeed, that annual financial report of a Fortune 500 boils down to financialresults_v2_nowaitonemorechange_final_FINAL_withcomments_official.xlsx" My g/f works for on…
Given the general quality of software in the world today, I would expect that most ERPs are just as bad as Excel sheets under the hood.
Earlier quoted context omitted.
Google Sheets is pretty basic compared to Excel in terms of the kinds of data analysis and queries it permits (without dropping into another language). Excel added tables over a decade ago that allow for some very useful and much cleaner query and data analysis stuffs in straight Excel. Then there are power queries and pivot tables, not sure how long those two have been around but last I used Google Sheets it had not…
Not sure what you mean by "power queries", but Google Sheets support SQL queries. Would be easier to see on an example.
Earlier quoted context omitted.
At least 50% of my day job could be described as "replace some guy's Excel file that got out of hand". I'm not even mad, I'll die before excel does.
I'm curious, how do you find a job like that? It sounds kinda fun with clear requirements.
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Golfing around with LEFT and MID and LEN and RIGHT gets old after a while, and I believe that regular expressions are much easier to explain to someone than the aforementioned nested formulas. (I have some Excel teaching experience.) Not just matching, regex string replace too.
Also, there's always room for adding new options when importing CSVs!
Its a two part sheet. One table sis a simple two column lookup where 1 2,3,...9,11,12....19,30,40,....90,100,1000,100000... etc are in front of One, Two, Three etc. All the vocabulary required to write a number.
Second table is a 9 row table, each row working on a digit of maximum number of 9 digits. First row works on 1st number of 9 long number. If its a smaller number like 12657, the first 4 rows return blank string. 5th row works on 1 of 12657. Kind of like loop. Every third from left gets Hundred, Thousand, Million word etc. Every 2-3 etc gets translated if its 11 to 19 or 20+1.
Since 10 years it has worked nicely, and everytime I use it to convert numbers to words for cheque printing, I feel good.
I wrote a bit about it here https://davinder.net/excel-numbers-to-words-no-VBA-part-01/
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Earlier quoted context omitted.
Parent said run perfectly not gives the same result.
If you consider 1+1 = 3 to be running perfectly excel sounds like the right tool for any job you have.
https://docs.microsoft.com/en-us/office/troubleshoot/excel/w...
Hey, I work on Excel at Microsoft and wanted to say: if anyone here has any feature requests they want escalated - write them here and I will bring them up. P.S we actually do read all the feedback people leave in the feedback box - it goes mostly straight to the devs.
Please bring back CTRL+SHIFT+V as paste values only