Measurement Calculator

Posted on 2014-02-13
Last Modified: 2014-04-26
Hello Experts,

Please bare with me as I explain this one...

There is probably no right answer to this question, as the solution will probably be pretty subjective.  And technically, it's not an Excel question - though the calculator lives within an Excel workbook.

I'm really looking for someone to guide me, or help me with a new way of thinking of this calculator based on an issue that has come up after a few months of actual use.

See the attached file I created.

The purpose of this calculator is to recommended a specific size bag, based on the object they are lining or covering.

I recommend enabling macros if you open the workbook as many features are dependent on code running in the background.

Let's take a look at two different examples, so you can see my dilemma.

Example 1:

Object = Square/Rectangle
Width = 50
Depth = 10
Height = 20
Bag Type = Gusseted
Objective = Liner with Tie Off

Answer = 51x11x35 (Bag Size)

Example 2:

Object = Square/Rectangle
Width = 20
Depth = 10
Height = 50
Bag Type = Gusseted
Objective = Liner with Tie Off

Answer = 21x11x65 (Bag Size)

As you can see, the object in each of the examples - has 3 dimensions.  And the width/depth/height, is different depending on how you're viewing the object.

And while the dimensions of the object never change, only how I 'view' those dimensions - I can get two very different bags sizes to cover/line the object.

In the first example, that size is great - if I am holding the large object (50" left to right) and bending down and placing the object into the bag.

But in the second example, that size is great - if I'm placing the large object into the bag, just like I would be placing my foot into a sock.

Hopefully, I haven't lost you.

Well, that is my dilemma.

Instead of the user having to change around the width depth & height measurements - I want the user to always follow the same logic.

The "Width" is always the widest dimension.
The "Depth" is always the shortest dimension.
And the "Height" is always how far off the ground the object is.

My logic in thinking this through, is that I need another field - basically talking about the orientation of the object, or how the object is placed into the bag - but that's where it all becomes gray to me.

I am hoping someone can offer me some advice on how to solve this problem. And just to be clear, I am not looking for any formulas.  I am only looking for advice on how I should be tackling this next problem.

Am I right, that I need to include something about orientation of object?  And if so, how am I wording it? How am I incorporating that?

Again, this is all subjective - so I'm sorry in advance.

~ Geekamo
Question by:Geekamo
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Expert Comment

ID: 39858281

as long as you want to put it into Excel, that has to be measureable, and then you need to be able to put it into some kind of formula.

That is what Excel is for.



Author Comment

ID: 39858296
@ Jorgen,

I think you're missing the point of my question, or maybe I didn't do a good enough explanation.

I am aware - anything I want to do will involve the use of more formulas.  But before I even get to that point - I need to figure out how I am going to approach my new problem that I outlined in my question.

@ all,

If anything I wrote isn't clear enough, please let me know.
LVL 29

Accepted Solution

IrogSinta earned 167 total points
ID: 39858313
How about having a different image appear whenever an object is selected.  Each image should be a representation of the shape and identify the respective dimensions lines.  Take a look at the image below:

LVL 33

Assisted Solution

by:Rob Henson
Rob Henson earned 167 total points
ID: 39859435
If you want to force users into putting the largest dimension as the width, use some data validation on the other two dimensions to ensure they are smaller.

Rob H
LVL 81

Assisted Solution

byundt earned 166 total points
ID: 39860889
Continuing Rob's line of thought, if the width is always the biggest, then perform your calcs as follows:
Width = MAX(user-entered width, height, depth)
Height = MEDIAN(user-entered width, height, depth)
Depth = MIN(user-entered width, height, depth)

It doesn't matter how the user decides to interpret width, height and depth--just that he enters three values. And if you are confident that the most economical bag has the Width as the largest dimension and the Depth as the smallest, then perform your calcs using the results of the MAX, MEDIAN and MIN of the user-entered dimensions.

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question