Cleaned_Data.xlsx (21.5 KB)
Challenge182_Data.xlsx (24.0 KB)
Challenge182_Data.xlsx (20.5 KB)
1 Like
Avalanche_Metrics.xlsx (5.5 KB)
Using the exact prompts from the original post, this is what ChatGPT output.
Challenge182_Data.xlsx (20.2 KB)
This was interesting, did not know ChatGPT could be used like this!
Time to complete: 25 min
Rating: 6/10 difficulty
Challenge 182 Avalanche Analysis.xlsx (21.5 KB)
Time to Complete: 30 minutes
Rating: Intermediate
This was definitely an interesting challenge that could show the benefits and fluidity of being able to use generative AI
Cleaned_Challenge182_Data.xlsx (10.4 KB)
Average_Depth_by_Region.csv (160 Bytes)
Avalanches_by_Region.csv (100 Bytes)
Processed_Avalanche_Data.xlsx (11.5 KB)
Cleaned_Challenge182_Data.xlsx (21.5 KB)
Time to complete: 30 minutes
Difficulty: Beginner
I enjoyed this challenge and it was very interesting to see how GPT 4 can manipulate excel files. I was very impressed with its capabilities and I will definitely consider it as a supplemental tool in the future.
Processed_Challenge182_Data - Chat GPT Cleaned .xlsx (20.5 KB)
Challenge182_Data CHATgpt.xlsx (23.5 KB)
Cleaned_Challenge182_Data.xlsx (10.5 KB)
Time to complete: 5 minutes
Rating: Beginner
Cleaned_Avalanche_Data.xlsx (10.3 KB)
Time: 30 minutes
Difficulty: Easy
I liked the challenge. For me, I took note that Chat had a hard time splitting out the columns and accounting for the depth being listed in both feet and inches. I had to ask a few times for it to reformat it and convert everything to feet. Not that it affected my final answer, but if this was a professional setting, it might be important to make sure those little details are also smoothed over.
Time spent: 30min
Difficulty: easy
Comment: Chatgpt can split cells… Can it split my bills too? I had to prompt a couple of times to have the right pivot tables and the correct cleaned data.
Time to complete: 30 minutes
Difficulty: Beginner
Chat worked great for splitting columns and cleaning up the data. I wanted to see if Chat could also create pivot tables, but it was unable to. However, after the data was cleaned and formatted correctly with the help of Chat, it was much easier to manually create the pivot tables.
Cleaned_Avalanche_Data_Final.xlsx (25.1 KB)
Time to complete: 15 minutes
Difficulty: Easy
Thoughts: I enjoyed this case, it was awesome to interact with the table inside of ChatGPT’s interface.
Cleaned_Data.xlsx (9.4 KB)
Time to complete: 25 minutes
Rating: Easy
Comments: This was an easy task with ChatGPT. While doing it manually wouldn’t have taken too much time, using ChatGPT made the process significantly easier and more efficient.
Cleaned_Data_with_Region__Depth__and_Width.csv (163 Bytes)
Time to complete 25 minutes
Challenge182_dataclean.xlsx (29.3 KB)
Time to complete: 30 minutes
Difficulty: Beginner
Really great challenge, helped test ChatGPT and your knowledge of excel a little bit.
Cleaned_Avalanche_Data.xlsx (38.0 KB)