Hi guys.
Welcome to this session.
So in this session we'll see how we can go ahead and reorganize and improve a huge amount of data on
a spreadsheet with the help of ChatGPT.
So let's have a look at this practically.
So let's say I have this data specifically right now, which is basically a random list of car parts.
And what type of car part is it is an interior or exterior and the price of it.
So now I want to organize this in a better manner.
So let's have a look at it how we can do that.
So the first thing what I can do is I can give this list to ChatGPT.
And now what I want it to do is first organize it in a proper category.
So what type of product it is.
So all of that I want to categorize it in.
So it has taken that into consideration.
So let's see how it groups them into proper categories.
So what I'm looking for is in this particular manner.
Let's say we want to group them by the type of car part.
So now we have we have the car part category.
So these are all doors and panels.
These are exterior accessories.
And so on and so forth.
So we have the categories now in place let's say in this.
Furthermore I want to understand which all parts are not so essential for my car to have.
So I am looking for to just see the least essential parts which I can do away with as well.
So now you can see it's giving me a list of those as well.
Like a spoiler.
Mostly for aerodynamics and style.
Not necessary for most vehicles.
Gearshift knob.
Aesthetic presence.
The car can function with a basic one, so now it's giving me a list of all the least required items
of the car parts.
Now, let's say I also want to go ahead and have a look at what will be the total cost of these.
But considering the tax part of it as well.
Okay.
Tax of purchasing it.
Okay.
I'm giving the tax also specifically for California over here.
So keeping that in mind I want it to calculate the total final pricing for all the car parts.
So you can see the subtotal.
They have done it over here for interior separately.
Exterior separately.
So the final before tax tax which is being given for the California 7.25.
That is also added.
So the final total, what we have here is this much.
So that also is being added now.
So we can easily see that over here.
And let's say I want to optimize this list I want to optimize this list.
And I want it to bring down the total cost without losing any of the important items.
So what can I do with that?
So now it's telling me the suggestions, which is keep the essential items like headlights, windshield,
tail lights, steering wheel, dashboard, seats and door panel intact.
Swap for used or refurbished parts for we can do that.
Choose aftermarket parts instead of OEM, which we can do.
Skip or replace luxury convenience items, buy in bundles, negotiate prices.
Used or refurbished interior parts can save up to 15 to 30%.
So you can see now I'm able to also optimize the whole data as per my requirement.
So this is how you can pick up any type of random data which is not organized in the right manner,
and you can reorganize it with the help of ChatGPT.