1 min readfrom 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”

submitted by /u/Emergency_Act2960
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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