•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
SO! I’ve always just use the basic sum functions to do my recipe costs, My boss wants me to use the Google LLM to check the math, how can I generate a word problem from a table
I’ve got a series of columns
that list off ingredients
then go
price of case($100)
weight in KG(10KG)
then a column with the sum of those divided to get price per KG($10)
I divide that by 35.274 to get price per oz($0.28)
Then a column with the portion amount in the recipe(5oz)
I multiply the price per oz by the portion amount to get my ingredient cost($1.40)
Last column tallies up those to price out recipes, that part works
Now the idea is to make something that will take my raw numbers
So I need to insert the raw numbers into a table and spit out a prompt for an LLM to check
EXAMPLE based on parentheses above
“If 10 KG costs $100, how much is 5 oz”
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives
#google sheets
#recipe costs
#Google LLM
#ingredients
#price of case
#ingredient cost
#price per KG
#price per oz
#cost calculation
#weight in KG
#portion amount
#check math