Welcome to Seeley Smart Tools!

Biting off too much and overcomplicating

Posted by:

|

On:

|

Dove into the first tool today, a media planning calculator. Spent an hour crafting what I thought would be the perfect prompt. I even structured it with <section> dividers (even though it’s o1 and some of these prompt tips are quickly getting phased out with the increasingly sophistication with the models ability to reason. But anyway, it still failed pretty miserably. You can find it here. (Great, now I need to research why a simple post doesn’t have the standard blue link, underline for hypertext links. Part of the journey.)

You see, I think I was trying to do the most. I tried to build my first web tool by starting with maybe the most complicated calculator I could think of. And the result showed. I was trying to create a relatively complicated spreadsheet formula that has roughly 3 phases of calculation (requiring new inputs each time) and uses more than 20 dynamic fields that need to be accounted for. Looking back at this hopefully it’s funny how naive I started out on this. Going to keep the old calculator live for reference and hopefully to see how far the finished project is (fingers crossed).

The prompt (again, that took me almost an hour to think through and document, and proofread, and edit, and rewrite. LOL):

 

It thought for 92 seconds and generated the following code:

JK, I can’t figure out how to past html code in here without breaking everything. Part of the journey I guess. Need to get that added in later. But first, I gotta start with a friggin’ easier calculation. Let’s simplify it next time.

P.S. might have to do with the note o1 provided: Note: Since WordPress might restrict the use of <script> tags in posts or pages for security reasons, you might need to use a plugin that allows custom JavaScript or adjust your site’s settings accordingly. I sure hope it’s not that simple.

 

The Prompt

I want you to create a website calculator by generating the code that I can copy to a wordpress page that will render a calculator where users can provide inputs and then get a calendar output they can download as a pdf or similar file. We’ll call this website tool: Media Planning Calculator. To begin, we need a field where the user can put in the total budget for the year and this should be a simple text box. We then need three fields under a section labeled “Initiatives” and those three fields are for Awareness, Consideration, and Conversion with a text box next to it where a user can input a percentage amount to represent what percentage of the total budget needs to go to each “initiative”. We need to trigger a warning message if the 3 values entered into these fields equal something other than 100. We then need a section of this calculator where users can select “Channels” from a drop down selecting under each “Initiative”, up to 4 channels each. The default options from the dropdown should be Meta, Paid Search, YouTube, and Display. Each of these “Channels” should serve as a row with a box to the right where the user can enter a percentage amount. This will take the budget provided for that Initiative and divide it to that channel based on the percentage provided. We need to show an error message if the percentage amounts under each Initiative do not equal 100. This should provide the user with a monetary value to the right of the percentage field showing what the budget for that channel is. This section is for users to add rows for each Product/Service they’ll be advertising under the 3 Initiatives outlined. The default number of rows should be 6 rows under each Initiative subsection with an option to add a new row. The user will label the row in a text field in what will serve as column 1. In a second column, we’ll call that column 2 internally, they need to provide the dates this product/service will be run. Then in the 3rd column, I’d like to label this as “Percentage of Total Budget” users will put the percentage of the total budget of that Initiative that they’d like to allocate to that Product/Service. This should fire an error message if the values in each subsection don’t total 100. Once a value is entered there should be a numerical value displayed on the right of the row that represents the percentage entered into the field multiplied by the subsection budget outlined in the first section.

It thought for 92 seconds and generated the following code:

Section 1: Total Budget and Initiatives





Awareness (%) $0.00
Consideration (%) $0.00
Conversion (%) $0.00

Section 2: Channels Allocation

Awareness Channels

Channel Percentage (%) Budget
$0.00

Consideration Channels

Conversion Channels

Section 3: Products/Services Allocation

Awareness Products

Product/Service Dates Percentage of Initiative Budget (%) Budget
$0.00

Consideration Products

Conversion Products

OMG it works WAY better as an imbedded table. Holy breakthrough. Now to bed until another day.