I looked at how Gramener uses ChatGPT Plus by evaluating 600+ chats asked over 3 months from Oct 2023 to Jan 2024.
The team asks 6 questions a day. We don’t track who or how many actively use ChatGPT Plus. This also excludes personal ChatGPT accounts. Still, 6/day is low for an entire team put together.
The questions fall into 8 categories.
| Category | % |
|---|---|
| Excel, data exploration & analysis | 25% |
| Text extraction and summarization | 13% |
| HTML, CSS, or JavaScript code | 13% |
| Python code | 13% |
| LLMs, AI and use cases | 9% |
| OCR and image analysis | 9% |
| Generate images, logos, and designs | 7% |
| General knowledge, policy & environment | 5% |
| Audio and translation | 5% |
Here are some questions from each category – to give you an idea of emergent ChatGPT Plus usage.
Excel, data exploration & analysis (25%)
- Excel clean and merge. There are 2 worksheets in this excel with data, can you clean up the data and merge the data in both the sheets
- Excel CO2 Data Analysis. You are an expert Data Analyst who is capable of extracting insights out of data. Analyze this sheet and let me know the findings
- Excel Chi-Square Analysis Guide. how to perform chi square analysis in excel
- Log Data Insights & KPIs. Looking at the columns from this excel, what kind of insights are possible, what are key KPIs to be looked at
Text extraction and summarization (13%)
- Complaint Investigation Summary. The following is the summary of an internal investigation for a customer complaint. Now this internal summary is to be paraphrased (in 3-4 lines) as part of a closure
- Extracting Tables from RTF. Can you write a script to extract the tables from this document
- Extracting Entities from Text.
[{'word1': '(P)', 'nearest_word1': 'P/N:', 'nearest_word2': '0150-25034', 'nearest_word3': 'CARTIRIDGE'}, {'word1': 'P/N:', 'nearest_word1': '(P)', 'nearest_word2': '015... - Extract PDF Font Details. Extract text formatting information from this document. Especially find font styles, families and sizes.
HTML, CSS, or JavaScript code (13%)
- HTML/CSS Chart Template. Give me HTML, CSS and chart code for this design.
- CSS Font Stack: Explanation. Explain this CSS font convention:
Arial, Helvetica, Segoe UI, sans-serif - Checkbox Validation with JavaScript. In HTML form, I have a set of checkboxes. How do I write the form so that at least one of them being checked is mandatory?
- Prevent Text Wrapping CSS.
<span class="text">Chief Communications Officer</span>I need CSS such the text inside should not wrap create new line - ReactJS App with Routing. Give me developed version using ReactJS use react router for sidebar section navigation to the pages use Tailwind css for styling. Use styled components for conditional …
Python code (13%)
- Python Code Documentation Guide. Can you generate documentation for a project code written in python?
- Linux Commands for Python. Give me list of linux commands to work on python coding
- Code explanation request. What’s this code about? …
- FastAPI Async Testing. Write a fastapi code and a python client to test the asynchronous nature of the fastapi package.
- Streamlit App for Translation. Given the following python code, give me a simple streamlit app that takes file upload and converts that into a target language: …
An interesting sub-topic was interview question generation.
- Python Decorator for Database Queries. Create one medium level question for Decorators in python Industryy usecase specific with solution
LLM, AI and use cases (9%)
- LLMs for Data “What Ifs”. You are an LLM Expert. Can you tell me how can we leverage LLM for implementing What IF scenarios on Data?
- LLMs: Current Challenges & Concerns. what are current challenges with LLMs
- LLM Applications in Marketing. Show LLM applications for the marketing function of a music company.
- Gen AI usage. What industries are using Gen AI the most
- Best LLMs in 2023. Search the internet for the most recent LLMs and list the best LLMs in terms of performance
- Best Image Classification Models. suggest best models to tell what there in the image
OCR and image analysis (9%)
- Browser history OCR. This is a screenshot of my browser history. Convert that to text. Categorize these into common topics.
- Extracted C Code. This image contains C code. Extract it.
- Image text extraction and annotation. Extract the text from this image and annotate the boundaries of the text
- Detecting Document Image Orientation. oreientation detection of documnet image
- AI Project with OpenCV & YOLO. Consider yourself as Open CV and Yolo expert and help me with AI project
- Image Correction Techniques. what are the approaches we have in computer vision where my image is tilted or rotated in reverse or image is not in readable format
Generate images, logos, and designs (7%)
- Google Chacha and ChatGPT Bhatija. Generate an image of Google Chacha and ChatGPT Bhatija
- Regenerative Systems Group Image. Generate an Image with below context > “A group of people interested in Regenerative systems. The focus is on reusing food, energy and mental health”
- Twitter Reply Icons Design. Give me three icons: icon16.png, icon48.png, icon128.png for an extension that I’m building that suggests replies to tweets
- Generate flowcharts. Make a flowchart of the underlying working of a web app. Here’s how it works. 1. The user uploads a document – a PDF or an image. They then select the language that …
- Create Animated GIF from Photos. I have 4 photos I want to make an animated gif out of them. How can i do that?
- Climate Impact Illustration. An illustration showcasing the impact of climate change on daily life, focusing on a rural setting near the coast. In the foreground, a small farm is visibly struggling, …
General knowledge, policy & environment (5%)
- Design Thinking Overview. What is Design thinking
- Arthashastra. What can Arthashastra teach us about modern politics?
- Community Impact on Habits. Is there research to suggest the impact of community on habit building?
- Focus at Age 28. What should a 28 year old focus on?
- Superconductors. Explain superconductors like I’m five years old.
- Climate Career: Impactful Choices. You a career counsellor at a University campus. You want to create 4 to 5 talking points for students to consider a career in Climate space.
- Sustainability Division Vision. I run a software outsourced product development company. I want to start a new division that focuses on sustainability services offerings. Please draft a vision…
Audio and translation (5%)
- Audio Timestamp Mapping. timestamp mapping for transcribed audio
- Transcribe Lengthy Audio: Segment. Transcribe this audio file.
- Traducción del MOU al Español. Translate this document to Spanish, and create a new translated document. Maintain text formatting.
- Telugu Transcription into Hindi. Transcribe the following telugu text into hindi. You are supposed to transcribe, not translate. శ్రీనివాస పూజావిధానము …
- GPT lacks native audio support. Does gpt support audio in audio out natively?