How would I calculate a ratio based on specific criteria?

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
I am trying to automate the calculation of time required to create training, based on industry averages.

For example, it should take approximately 49 hours to write/design 1 hour of basic (Level 1) learning (49:1).  The problem is training isn't always a nice, clean 60 minutes, which brings me to this forum.

I have two inputs and one results field:

input: Level of Training (Level 1, 2, 3 or Instructor Lead)
input: Length of Training (in 15 minute increments)

:result: Estimated Design Time

The Level of Training determines my ratios: Level 1 49:1.  Level 2 79:1, etc.  The problem that I run into is when I enter a Length other than a whole number (.25, 1.5 etc) and try to calculate, it creates results that are less than favorable (not unlike my last relationship).

I've spent quite a few hours trying to research ratios (and how to calculate them) since I wanted to solve this on my own, but cannot seem to find a solution via that route (as you may have noticed, math is not my sweet spot).

Any help would be greatly appreciated!
Photo of Ron

Ron

  • 300 Points 250 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Can you represent .25:1 as 1:4 ?
Photo of Ron

Ron

  • 300 Points 250 badge 2x thumb
Hey Chris - are you referring to the Length value? Such as .25 (equaling 15 minutes)?
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
Yes. 1:4 should be just as legitimate a representation of the ratio as .25:1.
Photo of Ron

Ron

  • 300 Points 250 badge 2x thumb
I guess I am not fully tracking with your suggestions.  So if it takes 49 hours to create 1 hour of content (49:1) it would take 24.5 hours to create a 30 minute session. Which would be easy to build into the formula if that was the only two options - so I am looking to find a solution that would calculate based on length - which is in 15 minute increments.  So for example: a 30 minute course would be entered as .5 and a 15 minute course would be .25, etc.  Problem is, a course could be 7.5 hours, or 58.25 hours, and I need to be able to calculate that design time based on the Level ratio (49:1 or 79:1 etc).  Does that make sense?
Photo of Ron

Ron

  • 300 Points 250 badge 2x thumb
Figured this out - I think I was actually making this more complicated than it was.