1 00:00:02,320 --> 00:00:02,920 Hi guys. 2 00:00:02,920 --> 00:00:03,920 Welcome to this session. 3 00:00:03,920 --> 00:00:09,920 So in this session we'll see how we can go ahead and reorganize and improve a huge amount of data on 4 00:00:09,920 --> 00:00:11,920 a spreadsheet with the help of ChatGPT. 5 00:00:12,280 --> 00:00:14,120 So let's have a look at this practically. 6 00:00:14,120 --> 00:00:20,880 So let's say I have this data specifically right now, which is basically a random list of car parts. 7 00:00:21,120 --> 00:00:26,400 And what type of car part is it is an interior or exterior and the price of it. 8 00:00:26,880 --> 00:00:29,480 So now I want to organize this in a better manner. 9 00:00:29,640 --> 00:00:31,760 So let's have a look at it how we can do that. 10 00:00:31,760 --> 00:00:38,120 So the first thing what I can do is I can give this list to ChatGPT. 11 00:00:46,240 --> 00:00:51,960 And now what I want it to do is first organize it in a proper category. 12 00:00:51,960 --> 00:00:54,040 So what type of product it is. 13 00:00:54,280 --> 00:00:57,200 So all of that I want to categorize it in. 14 00:00:59,760 --> 00:01:01,520 So it has taken that into consideration. 15 00:01:06,640 --> 00:01:09,680 So let's see how it groups them into proper categories. 16 00:01:09,680 --> 00:01:14,410 So what I'm looking for is in this particular manner. 17 00:01:35,930 --> 00:01:38,730 Let's say we want to group them by the type of car part. 18 00:01:51,930 --> 00:01:55,290 So now we have we have the car part category. 19 00:01:55,290 --> 00:01:57,330 So these are all doors and panels. 20 00:01:57,330 --> 00:01:59,010 These are exterior accessories. 21 00:02:01,890 --> 00:02:03,090 And so on and so forth. 22 00:02:03,090 --> 00:02:06,850 So we have the categories now in place let's say in this. 23 00:02:06,850 --> 00:02:14,050 Furthermore I want to understand which all parts are not so essential for my car to have. 24 00:02:14,370 --> 00:02:21,350 So I am looking for to just see the least essential parts which I can do away with as well. 25 00:02:21,790 --> 00:02:24,390 So now you can see it's giving me a list of those as well. 26 00:02:24,550 --> 00:02:25,510 Like a spoiler. 27 00:02:25,670 --> 00:02:27,430 Mostly for aerodynamics and style. 28 00:02:27,430 --> 00:02:29,230 Not necessary for most vehicles. 29 00:02:29,670 --> 00:02:30,910 Gearshift knob. 30 00:02:31,310 --> 00:02:32,630 Aesthetic presence. 31 00:02:32,950 --> 00:02:39,350 The car can function with a basic one, so now it's giving me a list of all the least required items 32 00:02:39,350 --> 00:02:40,470 of the car parts. 33 00:02:42,150 --> 00:02:50,550 Now, let's say I also want to go ahead and have a look at what will be the total cost of these. 34 00:02:51,310 --> 00:02:54,070 But considering the tax part of it as well. 35 00:02:54,190 --> 00:02:54,390 Okay. 36 00:02:54,470 --> 00:02:55,990 Tax of purchasing it. 37 00:02:56,030 --> 00:02:56,390 Okay. 38 00:02:56,430 --> 00:03:01,350 I'm giving the tax also specifically for California over here. 39 00:03:02,430 --> 00:03:09,630 So keeping that in mind I want it to calculate the total final pricing for all the car parts. 40 00:03:13,270 --> 00:03:16,750 So you can see the subtotal. 41 00:03:16,750 --> 00:03:19,550 They have done it over here for interior separately. 42 00:03:19,550 --> 00:03:20,830 Exterior separately. 43 00:03:21,150 --> 00:03:27,470 So the final before tax tax which is being given for the California 7.25. 44 00:03:27,470 --> 00:03:28,430 That is also added. 45 00:03:28,430 --> 00:03:31,240 So the final total, what we have here is this much. 46 00:03:32,000 --> 00:03:33,920 So that also is being added now. 47 00:03:33,920 --> 00:03:35,680 So we can easily see that over here. 48 00:03:38,040 --> 00:03:42,440 And let's say I want to optimize this list I want to optimize this list. 49 00:03:42,680 --> 00:03:48,320 And I want it to bring down the total cost without losing any of the important items. 50 00:03:48,320 --> 00:03:49,800 So what can I do with that? 51 00:03:54,000 --> 00:03:58,880 So now it's telling me the suggestions, which is keep the essential items like headlights, windshield, 52 00:03:59,040 --> 00:04:03,000 tail lights, steering wheel, dashboard, seats and door panel intact. 53 00:04:03,640 --> 00:04:07,720 Swap for used or refurbished parts for we can do that. 54 00:04:08,120 --> 00:04:11,680 Choose aftermarket parts instead of OEM, which we can do. 55 00:04:11,720 --> 00:04:17,280 Skip or replace luxury convenience items, buy in bundles, negotiate prices. 56 00:04:17,880 --> 00:04:22,040 Used or refurbished interior parts can save up to 15 to 30%. 57 00:04:22,440 --> 00:04:27,680 So you can see now I'm able to also optimize the whole data as per my requirement. 58 00:04:27,880 --> 00:04:34,240 So this is how you can pick up any type of random data which is not organized in the right manner, 59 00:04:34,240 --> 00:04:37,840 and you can reorganize it with the help of ChatGPT.