[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Measurement Calculator

Posted on 2014-02-13
Medium Priority
138 Views
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

Example 2:

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

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
Measuring-Up--Must-Enable-Macros.xlsm
0
Question by:Geekamo
[X]
###### 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

LVL 4

Expert Comment

ID: 39858281
Hi,

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.

regards

Jørgen
0

LVL 1

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.
0

LVL 29

Accepted Solution

IrogSinta earned 668 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:

0

LVL 33

Assisted Solution

Rob Henson earned 668 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.

Thanks
Rob H
0

LVL 81

Assisted Solution

byundt earned 664 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.
0

## Featured Post

Question has a verified solution.

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

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
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…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
###### Suggested Courses
Course of the Month13 days, 20 hours left to enroll