mathmoron2020
New member
- Joined
- May 7, 2020
- Messages
- 5
Hi,
TLDR;
I want to find out how much of something I can make depending upon how much/many materials I have on-hand and given there is an uneven ratio of materials required.
Short Background
I'm 54. I consider myself to be an above-average person in the smarts category but not anything special. However, I truly, truly struggle with all types of math, even basic math. But I'm really good at language (I speak Japanese fluently) and at music (I play professionally). Both language and music are languages. I'm an audio-visual sort of learner, I guess. So I think the way math is taught is to blame, perhaps because its all based upon human language (English, in my case). So thank you for your help!!
Problem: I want to make a "Thingamajig" (it could be anything, so let's just use an imaginary word).
Example:
I have 3400 pentists and 400 shizzos in my inventory (made-up words, too).
One thingamajig= 12 pentists and 8 shizzos.
How many thingamajigs can I make with my current inventory?
My mind freezes up when I have to figure out how many units I can make given the amount of inventory I have on hand. Do I divide? If so, do I divide two sets of numbers? Or do I multiply? What if I have an uneven amount of materials? Gah! I'm totally lost!
Goal:
I'd like to make this into an excel formula so that I can simply enter the amount of each into inventory and get an answer as to how many thingamajigs I can make.
Can someone help me with this?
Thanks!
TLDR;
I want to find out how much of something I can make depending upon how much/many materials I have on-hand and given there is an uneven ratio of materials required.
Short Background
I'm 54. I consider myself to be an above-average person in the smarts category but not anything special. However, I truly, truly struggle with all types of math, even basic math. But I'm really good at language (I speak Japanese fluently) and at music (I play professionally). Both language and music are languages. I'm an audio-visual sort of learner, I guess. So I think the way math is taught is to blame, perhaps because its all based upon human language (English, in my case). So thank you for your help!!
Problem: I want to make a "Thingamajig" (it could be anything, so let's just use an imaginary word).
Example:
I have 3400 pentists and 400 shizzos in my inventory (made-up words, too).
One thingamajig= 12 pentists and 8 shizzos.
How many thingamajigs can I make with my current inventory?
My mind freezes up when I have to figure out how many units I can make given the amount of inventory I have on hand. Do I divide? If so, do I divide two sets of numbers? Or do I multiply? What if I have an uneven amount of materials? Gah! I'm totally lost!
Goal:
I'd like to make this into an excel formula so that I can simply enter the amount of each into inventory and get an answer as to how many thingamajigs I can make.
Can someone help me with this?
Thanks!