As a recruiter I've used GPT to write Job descriptions and format resumes, etc.

Problem:
I've got a spread sheet with 400 rows & x3 columns.
Column 1 = Role Classification : IT, Finance, Ops, etc.
Column 2 = Job Title : Controller, Full Stack Developer, Mechanical Engineer, etc.
Column 3 = Blank but need to input job descriptions here.

It's to much data for it to really do more than say x3 at a time and get decent descriptions. Anyone have any fancy prompt engineering or ideas?

I can do them one, two or three at a time. It just takes forever to copy / paste them. I'd love a solution where I can just get the dang thing to fill out the spread sheet. But I don't see a lot of options. Tried one excel plug in but it failed pretty bad and couldn't even get a prompt to come up.

Ideas?

Just spit balling here, but with some coding you might be able to piece a solution together that calls an CGPT API or use a command line interface that will take your input and pipe the results out to a flat file or .xls file.

Something like this maybe:

Here is the question I put in:

I have a spread sheet with 3 columns and 400 rows. Column 1 is a role classification of IT, Finance, Ops. Column 2 is a job title Controller, Full Stack Developer, Mechanical Engineer. Column 3 needs to be a formula for a job description. What could that formula be?

Notice I didn't put in an etc. in columns 1 or 2, I assumed that there is a finite number of options for each column and the text in them will be consistent


Here was the response (seemed reasonable to me):

Creating a formula for job descriptions in Column 3 based on the role classification in Column 1 and the job title in Column 2 can be done using Excel formulas or functions. You can create a formula that concatenates different text descriptions based on the values in Columns 1 and 2. Here's an example of how you can do this:

Assuming Column 1 is labeled as "Role" and Column 2 is labeled as "Job Title," and you want the job descriptions in Column 3, you can use an Excel formula like this:

excel
Copy code
=IF(AND(A2="IT", B2="Controller"), "This is an IT Controller job description.",
IF(AND(A2="IT", B2="Full Stack Developer"), "This is an IT Full Stack Developer job description.",
IF(AND(A2="IT", B2="Mechanical Engineer"), "This is an IT Mechanical Engineer job description.",
IF(AND(A2="Finance", B2="Controller"), "This is a Finance Controller job description.",
IF(AND(A2="Finance", B2="Full Stack Developer"), "This is a Finance Full Stack Developer job description.",
IF(AND(A2="Finance", B2="Mechanical Engineer"), "This is a Finance Mechanical Engineer job description.",
IF(AND(A2="Ops", B2="Controller"), "This is an Ops Controller job description.",
IF(AND(A2="Ops", B2="Full Stack Developer"), "This is an Ops Full Stack Developer job description.",
IF(AND(A2="Ops", B2="Mechanical Engineer"), "This is an Ops Mechanical Engineer job description.",
"Unknown Job Description"))))))))))
This formula uses nested IF functions to check both the role and job title and provide different descriptions accordingly. You can expand or modify this formula as needed to cover all your combinations of role classifications and job titles.

Remember to adjust the cell references (e.g., A2 and B2) to match the location of your data in your spreadsheet. Additionally, you can customize the job descriptions within the formula to match your specific requirements.

It appears what I've found out is that its results are limited to X character or word count. Even with Plus subscription. So I'm hammering away doing them one at a time.

Once I got the basic prompts down on what content I want out of it. Intro, Responsibilities, word count range, industry, and minimum qualifications required. It's actually pretty good at churning them out.