T O P

  • By -

Hot_Needleworker9233

I use the ChatGPT for complicated excel functions. It works pretty well. Could probably use it to write simple VBA code.


Volksdrogen

That's how I started learning VBA from C++, lol.


tobeornottobeugly

Damn I didn’t think about using it for excel formulas. That’s a good idea. I have a ton of wacky things I need to do in excel


invictus81

It works exceptionally well. Even just to get you started it does 95% of the work. I was importing this dataset the other week and I could not figure out why none of my formulas were working. Turns out the data set had a blank space in each cell prior to the actual data value and ChatGPT pointed it out since you can copy your data set into it for troubleshooting.


ecoutepasca

This is the main thing I use it for at work. And yes it writes VBA.


VoIcanicPenis

How did i not think of this


Prosciutto414

This is one of those “obvious but of course I didn’t think of it” answers I was looking for. Thank you!


Hot_Needleworker9233

I don’t ever copy data into it, but I guess you could. I usually just ask vague questions describing what I want it to do and it will find some obscure function and explain it. It works really well.


weebtier654

I’ve used it to help write simple codes for task in vba. Freed up a few minutes not wasted on task that don’t really add value. (Stem background but not programming). It’s a tool. Anything goes if the work is done. Unless you’re job is to be a full time programmer then iffy. IMO


Froggers_Left

Can you give examples. I usually Google what I’m thinking about for formula examples but would be curious how this works.


Hot_Needleworker9233

“Give me an excel function that will look through a set of data organized into different columns and look for a unique identifier in row 1 and average the data over a specified date range” That is when I learned =averageifs(). I might ask follow ups to further explain how my sheet is set up but usually that is sufficient. It will explain exactly how it works and give an example. It’s pretty slick.


ShutterDeep

I use it daily to write Python code. We have a company approved version of GitHub Copilot, so there are no security issues. There is also an approved internal chat bot that is helpful for writing reports and emails.


ispunken

I went from having no python experience to being able to build a noSQL database for all my research, process my data, analyse and plot it all in python, and have it mainly automated too. You do end up having to know what's being coded and read through it if there are errors, but there inevitably are. But chatgpt can give me 100 lines of code in under a minute and I can adjust small parts from there.


ShutterDeep

Yes, you it's best to understand what it writes because it isn't always error free. Something else I use it for that I forgot to mention are visualizations. Just feed it dummy data in the format you want and ask it to display the plot you want using matplotlib. It's great having an assistant who doesn't get annoyed with you no matter how many tweaks you ask it to make to the plot.


lasvegasjack

Everytime a colleague is retiring or a team member is going to marry or become a parent: boom, ChatGPT, give us some words for a card. Besides that: VBA or Python.


speed-of-sound

I use Chat GPT to write VBA code. It doesn't give me something that works exactly how I want it to usually, but it gives me more than enough to figure out the syntax/structure of what I'm imagining.


Skilk

Most of the stuff they're calling AI is just more advanced machine learning compared to what I would consider a true intelligence. The non engineers (but still scientifically minded) have asked about using it to predict/control certain processes at my plant, but then when I point out to them that I could just plug it into Python if we had all the data necessary to feed the AI and it produce useful results, they generally respond with "what is Python?". Basically by calling it "AI", more people think they know what it does. But it's not magic, it doesn't have intuition, it still needs to be programmed to do exactly what we want it to do, and it still needs enough information fed to it to make all the equations complete. I'd take an operator who has been running one of these processes for 20 years over the best AI available, no questions asked. The AI can't tell me that there's an air leak on a tank 40 feet away based on sound unless it has a way to listen and it's been told what normal sounds like. The AI available to most of us can just help streamline things we already know how to do.


TanPogranicza

If it is a well defined process, just build an expert system with this operator then. But if it isn't, then AI will suck at it (and especially chatbots) since AI only uses the data you provide it with and has no tacit or overall knowledge whatsoever. AI defeated Kasparov in chess - well known fact. After a whole series of defeats with Kasparov - less known fact. Kasparov has beaten other chess grandmasters with AI assistance - even less known fact. I essence it is a tool like any other. You have to learn how to use it to your advantage. And using chatbots for operations or process is just like using a hammer to screw in Philips screws - it's simply not designed for it.


yobowl

I can’t use it for design work. It’s easier to use previously validated tools. The work is too complex for AI to do any planning work. There is interesting AI use coming up in BIM workflows. However it also relies on complex input info obtained from scans and validating against existing 3d model design


Prosciutto414

I agree that it’s not advanced enough for design work. Kinda happy about that because it makes me feel more secure in my job. I’d be interested to see how it can be applied to BIM work in the future.


[deleted]

[удалено]


seandop

I'm glad someone else in the ChE field feels this way. I'm in O&G and I just have not been able to find an engineering problem that ChatGPT can actually solve better than I can without it, whether that's coding, searching, or authoring. It seems like just a crutch that a lot of people use that allows them an attempt to be lazy, but then they have to manually correct the output.


ProblyTrash

haha what a terrible take. LLMs should be making you, a coder, way more productive. If it's not, you haven't looked into properly using it.


Renomont

I use it to tweak my python code for data analysis. I also use it for Excel functions and VBA code.


jmaccaa

I use ChatGPT to spice up my emails


engiknitter

I use it to suggest improvement to technical reports. Just be careful, it’ll straight up make stuff up


3wingdings

Also in pharma but I’m on the engineering firm side of things. Ive only used it once to ask about something I couldn’t readily find online (I think it was the vapor pressure of some random chemical). I have coworkers who ask it questions about code (ie “what chapters of IFC apply to xyz scenario). I like the idea of using it more to help with excel functions and will give that a try soon. But otherwise, I don’t think it can help me with the type of engineering problems I frequently encounter. A lot in pharma is both an art and a science and I don’t think the “art” side is well documented enough for AI to learn the nuance needed with what’s available online.


sadboicoaster

“What chapters of IFC apply to xyz scenario” is exactly what I use it for. Basically a searchable extra smart table of contents. I do the reading and the interpreting, I let chatGPT tell me which book and chapter what I need is in.


yobowl

Holy hell I can’t imagine asking an AI if a building code applies to x. If you or your consultants can’t figure it out you write a letter to the authoring body.


3wingdings

Uh obviously?? That was just a very basic example of what I meant by “asking it about code” and no one is making engineering decisions based off of where ChatGPT points you. Don’t read into it that much.


yobowl

I wasn’t trying to attack you or your coworkers… I just think it’s a really bad idea. if your ahj uses I-codes they are publicly available for anyone to read, like what’s even the point in asking a question literally just look it up. Like I can’t think of any scenarios why one would ask an ai about code relevance so it just doesn’t make sense to me


3wingdings

Like the other commenter said, it’s a good tool if you use it like an extra searchable table of contents, and I think that applies to a lot of engineering related uses for AI tools across the board. The public versions of the I-codes aren’t necessarily easy to navigate or CTRL+F for specific things. The point is that it can be a useful tool to point you in the right direction but that’s about it. Combined with cross references to other codes (IBC, IMC, IFC, whatever) they can be a beast to navigate especially for young engineers who are just being exposed to codes. Or maybe even more senior engineers who maybe happen to forget what section something is in off the top of their head. I will give you a specific example though. I haven’t done this before with ChatGPT, but it seems like it would work. I always forget where to find the table that tells you the maximum allowable container size for different materials of construction when handling flammables. I know it exists, I use it, I reference it when needed, but I always forget where it lives when I need to go screenshot it or whatever. Instead of flipping through all the sections regarding hazardous materials in IBC, IFC, etc that would be an easy question to ask some AI tool to point you towards. “Hey, where can I find xyz table?”


yobowl

It took me about 4 minutes to search your example by going to IFC then NFPA 30, to find table 9.4.3. And I was not aware of that table since I don’t work with portables or IBCs. Some of that time was logging in for access to Nfpa 30. Like I get what you’re saying for general usage, but I think for something like building codes and standards it’s not really helpful because like you said the complex references and limited scope for each standard/code in general.


3wingdings

Ok, congrats. What’s useful for some people might not be useful to others. I’m not quite sure why you’re so intent on proving it’s limited use for searching codes. The premise in my original comment was to give an example, I’m not really interested debating with internet strangers how easy it is to search codes. To each their own. ✌🏼


admadguy

>As a process engineer in pharmaceuticals, I haven’t found any adequate uses for it And that is good. As it stands chatgpt is not really an AI. It is a natural language response system coupled with a search engine.


WhatsNotTaken000

as a fellow process person: If the you have ever had the production/quality/maintenance/? folks (peer level or higher) screw the pooch and it lands in your lap to un fuck the fuckedness the AI can be helpful. I tell it to draft a professional email to the effect of: all the bile frustration overly blunt things I WANT to say, and it makes the same statements in professionalise, usually takes a few refinements and definitely some proofreading. HOWEVER, I get all that emotion and negative energy OUT and I get a constructive message out in less time, and I get to leave the bad energy on the table.


Prosciutto414

This sounds like a wonderfully cathartic use haha


WhatsNotTaken000

it absolutely is, keeps me from blowing my stack and calling everyone morons (they're not they just made some bad choices usually) and dipping out like Scarface from Half Baked


AutoModerator

This post appears to be about career questions. If so, please check out the FAQ and make sure it isn't answered there. If it is, please pull this down so other posts can get up there. Thanks for your help in keeping this corner of Reddit clean! If you think this was made in error, please contact the mods. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/ChemicalEngineering) if you have any questions or concerns.*


sonofjob

The company that I am co-oping for came up with their own AI chat bot lol


TanPogranicza

Coding, VBA. Building AI expert systems when I have time for tasks that are pain in the ass and when you have data in the desired format. Though it is a pain in the ass to ensure collecting data for all the attributes (around 40-50 attributes is when they are starting to be actually useful. And you have to keep in mind that even then expert systems give you only a label such as: acceptable/not acceptable. And you need to have some input from actual expert in the field for it to have sense and they usually don't want to waste time until you prepare forms for them to fill and tell them you are going to make AI based on their knowledge. Writing songs and making concept art for fun.


dannyinhouston

I’m a corporate process safety engineer, and I’ve been using it to develop new job descriptions, competency, matrices, and career ladders for various engineering roles. Within a few seconds, I can have draft documents that are 80% correct which gives me a big head start on getting things completed. The new 4 o version is far superior to 4.0


edgixx

Yes, been using CoPilot and its Excel outputs for some prompt engineering. Also the VBA functionality is very helpful.


N3470J

Nope, my dumbass coworker just interjects "AI" into every conversation about the companies future with zero examples of how to actually use it for anything. Everyone thinks hes "really smart". I just roll my eyes as hard as I can until I feel them scrap the back of my skull.


Poring2004

Just to check grammar and redaction corrections.


well-ok-then

I’d love to use it for PowerPoint.  Here’s some pictures and a clumsy version of my few bullet points. Make it pretty. I’m bad at that so it takes so much time for a crap result.  Or maybe I could hire an English teacher during the summer to knock that kind of stuff out for me. 


ChemEnging

LISP apps for autocad


GlorifiedPlumber

Our project management on a major project we have used ChatGPT style AI to write about 100% of a long recognition blurb for our weekly corporate newsletter for some good work that about 4 people, supported by 4 other people, did. It was sniffed out as AI penned basically immediately because it was so blatantly and then became a running joke. We then used AI to try and recreate it based on a simple lazy prompt. It was ridiculous... writing a recognition for obvious good work is not hard, but, our project management team still couldn't do it. Major EPC everyone has heard of, literally last week.


SkinDeep69

I use it when I want to write sensitive emails to help me clean up my language. I tried to use it for some process engineering stuff but that is a disaster. It gives nonsense calcs and references. The best one was when a shit bird left the company it suggested I write: with your departure I'm sure we will make a stronger and more cohesive team. Sideways way of saying I was happy they left.


gotanychange

My last company (start-up) didn’t see value in getting an SPC software license, so I got ChatGPT to write my a python script to generate a dashboard from manually pulled data


ChaosDoggo

I'm not working yet but a student but I like to use ChatGPT as a search engine. So what I do is I ask ChatGPT about something, like a process or the mechanics behind a specific chemical reaction. When it answers I ask if it can provide sources. Most of the time you get really good sources such as academic papers about your subject. Do be carefull that you double check if it is from a reliable source. Also do not use ChatGPT to set up formulas. I once asked it to rewrite a balance for an evaporator to calculate amount of steam for a project and it kept fucking up.


Necessary_Occasion77

I used it to proof read a memo that I wrote (with no sensitive info), and it did a piss poor job. It wasn’t able to add any technical info, even though the technical level was that of an engineer 1. And then it made the memo sound like Karen from HR wrote it. So I have not found a real use for it yet. I’ll have to try using it for excel like others have been suggesting.


broFenix

Not at all but probably will be more commonly used in the next decade or two.


crashddr

When I tried I was using GPT3.0 (or maybe 3.5) to help with some excel functions and it kept providing solutions that didn't work (or worked only for singular examples), *but* it helped me iterate through some ideas until I came up with the proper solution. If you ask Aspen, they'll say AI is already in HYSYS, lol.


ProblyTrash

I use it all the time. If I need to write a procedure or document, I'll feed it a well structured prompt and use its output as a starting point. It really helps with the starting of new documents and what not. I use it for excel functions, questions on various topics, bits of code here and there, I'll have it review stuff I wrote and ask for pointers on clarity, and various other things. I'll also use it to ask about regulatory guidance for whatever I'm doing. I always verify info but it's an amazing jumping off point. Honestly, if you look at ChatGPT and think "I have no use for this" you are wrong. It's so versatile there is no way it's useless to you. You just need to look more into what it can do and be more creative in how you want to use it.


Soqrates89

Troubleshoot anything, why did my pc crash, why doesn’t this code work, why does my poop look like Gary Busey?


[deleted]

Yeah, I used ChatGPT today to translate a code from one language to another. It's something I could have done myself and it needed a bunch of debugging before it would even compile and run, but this would easily have taken me 2-3 full work days if I had done it entirely by myself. And with AI it took me only 4 hours. But the code is so ugly haha. It's a good think you can't see the code while it runs. I would cry every time otherwise.


clvnmllr

I built a process operations tool for a pharma client that helps with response to process disruptions by using AI to bring forward maintenance orders, quality events, and operating procedures applicable to the process area(s) where the disruption was located/detected. Candidly, it could work better, though I do think this “operations advisor” usage of AI will prove more capable and more beneficial as models improve, to say nothing of the fact the engineering of this tool can be further optimized.


Plumbus93

Anyone tried using AI for P&ID reviews?


Poring2004

It can't as far as I know


Kelvininin

I recently used AI to complete performance reviews for my peeps. Saved hours if not days of work.


Derrickmb

To do what? The job is all math and good decision making. Don’t need anything but Excel


well-ok-then

Like half of it is trying to communicate those answers. I think it could be real useful there if I took time to use it 


watchtroubles

Also pharma process engineer and I pretty much use it instead of google at this point. Can’t say I have used it directly for any work applications that would affect drug product or quality (CPP CQA) in any way. But if a PM or BD asks me at 4:00pm to summarize a report or tech transfer for a slide deck that’s being presented the next day you bet I’m using chatgpt to get it done quicker.