7 ms·
GPT Excel
- joel99 3y ago[dead]
- joel99 3y agoGenerate Spreadsheet Formulas, scripts and excel templates with AI.
- deleted 3y ago[deleted]
- chirau 3y agoThis is a feature in the upcoming Excel from Microsoft.
- bagels 3y agoIf it isn't already, it's an obvious thing to add since chatgpt got popular.
- quickthrower2 3y agoEspecially as M$ is heavily in bed with OpenAI (a complex bed)
- siva7 3y agonice but i expect microsoft integrating this feature into excel for their enterprise customers soon
- meatjuice 3y agoYep. There'll soon be some opensource alternatives as well.
- stanislavb 3y ago"130k+ Happy users" that's a very good traction for a new project. I'm wondering how it got so popular. It got viral somewhere?
- purplecats 3y agoit's also super easy to lie about something like that. what are the practical consequences of accidentally adding an extra "k" character on there? or what is deemed as the definition of "happy" or "user" — could be extremely weak definitions
- h1fra 3y agoNot to be too cynical but I would also had my doubt. 130K is huge number for a brand new product, the 3 avatars shown are stock photos. And when you combine that with the advertised "845,022 formulas generated, so far." (6 per person) + "4 requests per day." (on free plan) , seems very unlikely that there is that much paying or regular users.
- septillianator 3y agoam i misssing something....but what can someone do with this that they cant do on chat gpt.
- swah 3y agoMaybe 130k people have visited the page, or seen the tweet..
- hdjjhhvvhga 3y agoI believe this is the standard way of doing things now. And has been for decades. Practically all big brands used some form of "growth hacking techniques" on launch so you can't really blame newcomers.
- quickthrower2 3y agoTheir Twitter has 15 followers. And not not “k followers”
- dave1010uk 3y agoIf you use Google Sheets, there's 10's of different GPT formula plugins that are integrated. The challenge is knowing which ones are any good and have good privacy measures. https://workspace.google.com/marketplace/search/Gpt?host=sheets https://workspace.google.com/marketplace/search/Gpt?host=she...
- totetsu 3y agoAnd there is Bard built right in now.
- bugglebeetle 3y agoNow, just to make Excel formulas actually work consistently and we’ll be all set. VLOOKUP doesn’t even work correctly about half of the time.
- mhh__ 3y agovlookup is usually not the right tool for the job (index + match better)
- cm2187 3y agoOr xlookup if you are younger.
- cm2187 3y agoYou are probably doing an approximate match which is the default. Always add FALSE as the last argument.
- bugglebeetle 3y agoNope, I know about that. It’s just garbage software, especially their Mac version. See also the inability to open a CSV file correctly without corrupting it, unless you use a specialized import.
- bythreads 3y agoMan i just want to be able to use js instead of excels crappy meta dsl
- deleted 3y ago[deleted]
- surfingdino 3y agoThis looks to me like what the old Clippy should have been. And I mean it as a praise not a diss. I'm all for AI assisting us.
- poisonborz 3y agoThis may be really dangerous. Many will see enablement here and speeding up dull processes, I see untrained users getting results via a GPT that can spout out hallucination and false answers any time, and the user will simply believe it as he won't/can't do validation. It's one thing developers using it to create easy to review code snippets, another to generate complex queries in office apps to operate on raw data. I know, the same user would have copy pasted a formula before without checking, but using GPT will open up the floodgates for such issues.
- mhh__ 3y agoGood excel (such a thing does exist) should almost never refer to a cell by its coordinate rather than using either a named range or better still a table, this probably encourages not doing that.
- cm2187 3y agoNamed ranges are evil except in a limited number of cases (referring to a cell from VBA). If you duplicate a tab or move it to another workbook and you have named ranges, hell starts there.
- mhh__ 3y agoTrue of variables in most languages, are they evil too?
- cm2187 3y agoIn the languages where all variables are global variables, they are.
- hannofcart 3y agoAlso, I find that named ranges seem to slow down the Excel file when the number of rows get a bit large (100k or so)
- qsort 3y ago
- complex_exp 3y agoNot sure if everyone knows just how easy making something like this is. This kind of an app takes less than one week to develop, using the OpenAI function calling API.
- andybak 3y agoA week!?
- belter 3y agoAn hour if developed with ChatGPT...
- meiraleal 3y agoI'll give you 10k usd if you copy this work in 1 hour (which is much easier than creating it, mind you). Otherwise stop downplaying other's people work.
- belter 3y agoOther people work was not the target of the remark. Stop not having a sense of humour...
- meiraleal 3y agoOk, one week.
- hdjjhhvvhga 3y agoOK, do I understand correctly you are offering 10000 USD for someone who recreates this service (=a website that generates an Excel formula based on its description in English) in a week? Frankly, and I don't want to downplay anybody's work, but this seems doable. The core engine based on API calls to OpenAI is probably a few hours. The remaining time is for user authentication, subscriptions, payments, graphics and so on. I know this because I'm using OpenAI API for personal automation projects and in spite of its quirks it's relatively simple especially if you don't need continuity and each task is independent.
- andybak 3y agoNot working in Firefox. Console shows "Uncaught (in promise) TypeError: r is undefined"
- joel99 3y agohey there. just checked with firefox and its working fine. are you using a phone? also what were you trying when this error happened
- andybak 3y agoStrange. It's working now. Might have been user error.
- quickthrower2 3y agoSmells like network request failure
- quickthrower2 3y agoThat have the io domain but redirect to uk. Very odd!
- phkahler 3y agoA friend of mine has created some amazingly sophisticated spreadsheets with the help of the regular chatGPT. How is this any different?
- moffkalast 3y agoThat's the neat part, it's not. https://chat.openai.com/share/bce0e12f-ebfc-4fcd-babc-9e0a48a57428 https://chat.openai.com/share/bce0e12f-ebfc-4fcd-babc-9e0a48... Just another in a long line of fancy wrappers made by AI grifters.
- belter 3y agoIt's not called AI grifting, but Trickle-down economics...
- quickthrower2 3y agoWe are Costco customers complaining about convenience stores
- garymiklos 3y agoIs this a spam?
- softgrow 3y agoThis could be more of a symptom of Excel (and spreadsheets) being too darn hard to get right. I've switched to Sqlite and Jupyter from what was a useful but hard to debug spreadsheet with really long repeated formulas that were just database joins. The amount of code to view has probably dropped by 90%. Of course now its easier there is ten times the functionality, but at least its a lot easier to understand some SQL vs Excel formulas.
- cykros 3y agoPowerQuery and the built in data model do a lot to make Excel better at handling joins in a sane fashion, but are relatively recent features that some are still realizing are there in the first place, particularly for the Office365/Mac crowd. Nice way to keep your basic tables basic and still maintain the full depth of your relationships all inside of Excel. Throw in some calculated columns and measures using DAX and it's a pretty darn powerful tool. That said, in the data science world, there's a LOT of crossover when it comes to functionality, between tools like Excel, Tableau, and *SQL in particular. And the crossover seems to be growing by the day, especially with Python functionality being built into Excel in the near future.
- xupybd 3y agoSomeone needs to wrap this in a clippy UI
- bdunks 3y agoFour requests per day seems a little low to verify the quality of the responses before shelling out even a few bucks. That said, I've already gotten great quality formula and VBA generation directly in ChatGPT (GPT-4.0), with only a sentence of prompting, so I'm not the target customer.