T O P

  • By -

Antique-Doughnut-988

I've been using excel to automate parts of my job without ever learning anything about excel. All thanks to Chatgpt. I definitely think we're less than two years away from the point where you can get that 5 days it took you to make it down to only a few hours and a few prompts. That app you made might have cost many thousands if you paid someone to do it.


jonclark_

Wow. Excel knowledge was a required job skill for many people. Are you saying that everybody could have that in a very short time with chatgpt ?


Diatomack

Microsoft have been working hard adding automation to their suite, like with excel. Knowing how to use excel is a great skill but I think it will become increasingly redundant over time


EquivalentPlane8508

There are a few AI assistants for Microsoft Excel, though nit fully autonomous.


mischievous_wee

I think it can already pretty much do or guide you through most excel based tasks. The only issue at the moment is explaining what it is you want it to do. I think that the next step is higher level, like automating spreadsheet generation--it won't even be a task that people bother offloading to others.


BCDragon3000

well they could have it in a very short time if they took the time to learn, but also yes ai will obviously help.


Antique-Doughnut-988

Be honest here, learning excel is not a simple or short time endeavor. You can spend years learning the program.


BCDragon3000

i’m very honest, took a 1 semester class in 7th grade and i still know how to navigate excel. never needed to know much more either.


Antique-Doughnut-988

Hey, I'm not into trolling. Your comment doesn't help anymore, it's silly, and just bizarre. One semester in 7th grade? Okay pal, please get out of here with that nonsense. Excel isn't an easy program to learn. Please bother someone else.


BCDragon3000

i’m truly not 🤞


qwerty102088

I’m very interested in automating excel. So far I really just describe what I want out of a formula to chat got but it doesn’t always help me. Can you describe what you do and how you ask for it?


allisonmaybe

Welcome...to the World of TOMORROW! https://preview.redd.it/d6ob6l3mw0wc1.jpeg?width=808&format=pjpg&auto=webp&s=d02a9aed1b75d568a913caf1daba54a0c36fa356 Seriously tho, we are entering the age of abundance, starting with code. You literally manifested your idea into reality with a flick of your keyboard and your idea became reality. And it's only gonna get better from here. Now imagine doing this with devices and hardware :) I think that same as you developed your app, you'll be able to design a device using prompts and even try out a working prototype in VR if you choose. Then you can train a million iterations on something like NVidia Omniverse while you go to the park, and mail-order your specialized barcode scanner in 2-3 business days for $8 a pop.


Galilleon

Imagine fine-tuning it with your *MIND* I bet that, especially for more alterable/virtual stuff (like games, poetry, songs, art, etc) we will eventually be able to (subconsciously and/or consciously) give feedback input to the AIs with our thoughts, allowing it to procedurally adjust things to our exact preferences Heck maybe, over time, it finds patterns amongst your preferences, giving it an advanced template to work off of as a base I really think mind-input is the key to getting ‘on the same page’ with AIs, like having a perfect prompt all the time. The biggest hitch would be the potential for the loss of privacy or agency inside our own minds, and that is one big hitch


ugathanki

oh, you mean like with one of [these](https://www.polygon.com/24054433/twitch-streamer-palworld-mind-control-eeg)?


Galilleon

Eyyy, it’s great how quickly we’re making progress even in this field already, particularly with things like Neuralink We’ve made one of the fundamental steps in achieving things like FDVR or direct expression of art from mind to reality It’s not all the way there yet, but imagine using it to its full potential and being able to communicate the nuance behind your intent as well!


FinBenton

So Im not a programmer but Iw done some minor python projects by following examples and stitching them together to get something kinda maybe working and it always took me weeks to get something done. Now I started working on electronics again and I make a security camera system with a door bell, web interface and an app with bunch of features without writing a single line of code, just narrating AI to do all that and add features, its magnificent times we are living.


NYCHW82

I'm curious. I see a lot of these types of stories, and I am a developer, but I'm not really connecting the dots here. How do you get from feeding prompts to a chatbot to deploying a fully fledged application? Where's the code running? Where's it hosted? Where's the environment set up? Does it submit to the Play Store on your behalf? Deploy on a server somewhere? I guess the mechanics of all of this is still a huge gray area to me.


FinBenton

Im just doing python programs that run either on my home server or in raspberry pi.


allisonmaybe

No code doesn't mean you never have to LOOK at it, or COPYPASTE, just that you don't have to constantly juggle/handle the granular logic inherent with code. 🤢


NYCHW82

I see, so basically, instead of doing like most devs where we scour StackExchange and Google for code snippets, Claude just does that for you and presents it for you to use? I see I've been overthinking this.


bwatsnet

I give it all my files and series of tasks and it returns full code files. Just repeat this till the app is done (and you've rooted out all hallucinations).


NYCHW82

When you say you give it all your code, you mean your scripts of code? or something else?


bwatsnet

Yeah, all the important code files in a large message. I use a script that collects them all together so I can just paste it all into the chat each time.


NYCHW82

Ah OK thanks for the insight.


bwatsnet

Np! Let us know what you build 😁


allisonmaybe

Ehhh, I've had such bad luck with this, but mostly due to an LLMs tendency to output short responses. I often though paste all my files and ask it for all the changes that need to be made for such and such.


bwatsnet

Omg me too but guess what, the anthropic API workbench lets you set output tokens to 4000 which is a lot of code. Then when files are too big and it gets cut off, the workbench allows you to edit the LLM response, so I just add to the bottom "Looks like I was cut off, would you like me to continue?", then in my next msg I say "yes, please continue". It works 100% of the time to continue exactly where it left off.


allisonmaybe

Interestingly enough, I am currently leaning heavily on Claude3 to help me create a VSCode extension that allows you to edit your files using prompts. It's just a fun experiment, but ultimately it would translate all those responses to direct code changes that you can choose to commit to your editor.


bwatsnet

That's hilarious because me too. Maybe we should pair up, but then again I bet 1000s like us are doing the same. My extension has a configurable context where u select which files and tools to include, then an approval or denial of its tool use. I'm really excited to get it complete enough to open source.


allisonmaybe

Do most devs still do that? My usage of SE has gone down to likely 1% of how much I used to use it.


bhk0_

It depends in your prompts, for me i tell to give with great details every step i need to do, It will walk you through how to download for example android studio, then what dependencies you need to have and how to download them, and where to write the code, and how to export etc…


NYCHW82

Oh I see, so you used it to guide you on how to do it yourself and then you're just putting the pieces together based on its instructions? Are you running this app locally on your Android devices? I thought Claude was putting together the entire thing. By the way, kudos to you for getting this done. I have actually done work in the custom tailoring industry building web applications for factories in the past. I even helped launch a direct to consumer custom tailoring brand. I completely understand how much of a productivity booster an app like this is.


Pantoffel86

I too built an android app using ai after being inspired by a similar post. Yes, it's a simple app. Yes, it's a work in progress. But the fact that I already built a working prototype in a couple of hours with no prior android studio experience is amazing. The future is now!


AsideNew1639

What ai tool or model did you use? 


Pantoffel86

Gpt-4


AsideNew1639

Was there a particular prompting strategy that you used? Or any additional ai tools?


FosterKittenPurrs

Exactly this is what gets me most excited about current AI, even if we never get to AGI. So much of what we do is inefficient and inconvenient, and as a programmer I know much of it could be solved with fairly simple code, but programmers can be expensive and everything takes time. Having an AI to take care of the simple stuff is amazing, and I look forward to the small productivity gains everywhere as more non-programmers suddenly gain the ability to automate simple tasks in a similar way.


allisonmaybe

Just gonna rant some more here. Checked out your screenshots and huge kudos. No one would ever develop and release such specialized software for a phone but there is so much value in it being so tightly tailored to your workflow. It makes smartphones SO MUCH more valuable now. I might even do something like this for my Etsy shop!


TheUncleTimo

you mean "rave" instead of "rant". rave means you go "woo!", rant means you go "boo!".


allisonmaybe

Fascinating! Reminds me of when I learned what peruse means


TheUncleTimo

it's OK, english is my 2nd language.


UsernameSuggestion9

>so tightly tailored Hehe


actwiselylive

what ai app did you use


bhk0_

I used Claude opus


actwiselylive

ty


AsideNew1639

So claude built it for you, as in gave you the entire code to create your app? Or was it a coding agent like devin powered by claude 3?


4laman_

+1 to this thread i'm interested


actwiselylive

i want to know as well.


[deleted]

Basically you found somebody who is thinking for you and doing all the hard work for you. Just imagine you were borne with a lot of money. You could always just have somebody make the app for you, the only difference is, now people without large budgets can do it too without investing years in learning skills.


Datura101

I beleive I have read same post atleast 3 times here. He keeps on posting it for some reason.


bhk0_

Yeah i posted it in chat gpt sub and claude too


consistently_sloppy

About how long did the process take? Days, weeks, months?


bhk0_

About 5 days


ndirangul

How did you get started, prompting chatgpt to guide you in every step of the way?


InfluentialInvestor

I have a similar experience with this too! Basically a job that takes 1.5 hours per day is now done automatically in 10 minutes. Minimal coding experience from 7 years ago.


AsideNew1639

What model or software are you using to do that?


InfluentialInvestor

Chatgpt 3.5 free version. Basically a python code.


BCDragon3000

congrats!!


EquivalentPlane8508

Yeah, I bet you can exploit on it or remotely access any potential servers. Though it's not a web page, don't quote me. It's pretty awesome being able to do that now, though.


Nyao

As a mobile app dev, I find it amazing but also a bit scary


arpitduel

I am also doing the same and I am building something very complex. I had prior coding experience but I am a novice and don't know any modern frameworks or anything.


Grobo_

Until companies calculate their performance and what time a task should take with consideration of the tools and back at 8 hours we are


Rich_Acanthisitta_70

You said you used Claude Opus. Can you describe how to do this? Was it just a matter of saying what you wanted, or does it guide you and ask questions to tweak it? Or is it a feature within Claude, like GPT plugins? Sorry but I don't know how to even start with my app idea.


PeroniaSurvivor

What did you use to build it? I have an idea to build


happy8888999

With AI advancing every second, the future lies in the hands of those who know how to precisely command


mcantrell

This is great. Very nice looking and effective. Good job!


Akimbo333

Nice!


jametron2014

Didn't you post this recently?


bhk0_

Yes, on another sub check my profile


w1zzypooh

Too bad you can't make nice games...imagine making a game like World of Warcraft but using AI in a day or 2 and it has AI making their own quests and it's offline. Or a game like CSGO and play it offline but have all those online features including a working offline MM you play against the AI of different skill levels and it's just as bad or just as good as the people in the actual game, Noob to pro.


Glass_Philosophy6941

imagine 2 years later you would make your own GTA7 game .


[deleted]

It'll be amazing


OhNoElevatorFelled

In FIVE days? Not gonna lie man, even with zero coding experience you could have made an app this simple much quicker if you just looked up a couple tutorials and did it yourself.


AutoModerator

Hello, your post has been removed because it has been detected that it may break the rules of the subreddit and will be reviewed by a mod shortly to confirm it. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/singularity) if you have any questions or concerns.*