241–250 of 275 posts
As someone with a perhaps well deserved reputation as a Microsoft hater (ha, check my history..) Microsoft Excel is perhaps the greatest program-slash-programming language ever invented. Nothing has much come close in terms of giving regular folks the power of general-purpose computing (sadly, further and further removed from what we're doing today.)
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…
Except for the back-end, which is COBOL.
Earlier quoted context omitted.
Second time I'm seeing your platform. I still don't quite understand what it does exactly, but I'm intrigued nonetheless
That makes two of us! I'm reworking the marketing and landing page, and I'm working on different stabs. There are two things to consider. First, I built a reactive document engine. Imagine Excel except instead of many very large grids, I have tables, objects, and single variables. Formulas can be attached any aspect to compute things reactivly, Second, I put that document within a NoSQL style platform such that sprea…
Not that it matters, but, personally, I cannot understand anything in that sentence, nor most of what you have on your site.
Maybe, just maybe, you could provide a couple of real-life examples, if you cannot find a way to explain in a simpler manner what the platform does.
In your FAQ's : >For a more detailed answer, there is an entire chapter outline what Adama is within the book. The book also has examples of some of these use-cases in action.
I cannot find "the book".
Earlier quoted context omitted.
> It also really annoys me when I see Linux/FOSS partisans tell Windows normies "oh you can do everything you can do in Excel in LibreOffice Calc" -- no you fucking well cannot. (And I use Linux on my personal computers full time). It seems like your argument is that alternatives don't have PowerQuery. That might be true (I don't even know what it is), but isn't that like saying Linux can't compete with Windows, beca…
Do Sheets and LibreOffice have Solver? No. They don’t.
Does Microsoft tell their customers they invented these features? Just a few days ago I saw a Windows developer who thought Microsoft invented conditional breakpoints.
I would argue that CSVs never die and most people simply do not know how to use `grep`,`sed`, or `awk`
Links to learn? (awk specifically - I know some sed because of vim, and grep is easy)
[0] https://archive.org/details/pdfy-MgN0H1joIoDVoIC7/page/n3/mo...
Earlier quoted context omitted.
Ok, besides python support... The thing I'd like more than anything: A better way to edit cell with really long function calls. If nothing else, add color coded parenthesis to the bar at the top and not just in the cell. Like, sometimes you just need some if/else statements... but try to parse and edit even something fairly simple like: =IF(AND(LongExpression > 3, Other_longexpression 5,Other_longexpression Even with…
FYI, the formula bar in Excel is resizable already. Expand the bar (or drag the vertical resize handle at its bottom edge), and then you can use alt+enter to insert a newline.
Earlier quoted context omitted.
Wait really? Well if thats the case, making VLookups be able to use any column as an input or output, rather than being limited to having the input on the left and the output on the right. Ideally I'd be able to have 2 additional parameters, one that would indicate the column where the input value is to be found, and another that would indicated the column from which the output value would come from. I know there are…
You may already know this, but if not and for others: my Excel files became a lot more manageable, maintainable, and readable when I switched from _LOOKUP() functions to the INDEX-MATCH pattern, and in particular using the pattern with Tables. Basically - Put the data to be looked up in a named Excel Table with a short, meaningful name. `data` is a good default name, but something with more meaning is better. - Put t…
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.
You would be a hero to thousands and thousands of junior bankers if you made this change lol.
I recently sat down and built something more complicated than simple accounting in a spreadsheet. It's what I considered to be a pretty typical usecase for a non-math related sheet; taking in several tables of data and selectively joining them. You enter an ID, press a button, and it finds all of the data related to that ID and presents it to you. I was horrified to find that even with the supporting scripting capabi…
I work in financial services and have build prototypes with Excel that are now multi-million dollar revenue providers (implemented properly). Excel is powerful in this respect because it is a shared experience. Build something with SAS/R/Python, explaining the results is possible but getting buy-in from other teams is harder.