PC Review


Reply
Thread Tools Rate Thread

Carton size and cubic feet auto calculate..

 
 
Satwinder Saluja
Guest
Posts: n/a
 
      22nd Apr 2010
How to calculate carton size in cubic ft.



shawn wrote:

Carton size and cubic feet auto calculate..
23-May-07

I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
in a carton, carton size, cubic feet, etc.

We have standard carton sizes we use which we've named.

Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
... etc, on down to Carton J.

Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
column it will automatically enter the cubic feet for us under the cubic
feet column? Then at the bottom of the sheet we'll have a total which will
total up the cubic feet for us.

Previous Posts In This Thread:

On Wednesday, May 23, 2007 1:50 PM
shawn wrote:

Carton size and cubic feet auto calculate..
I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
in a carton, carton size, cubic feet, etc.

We have standard carton sizes we use which we've named.

Carton A = 18 x 18 x 18 = 3.38 Cubic Feet
Carton B = 18 x 18 x 14 = 2.63 Cubic Feet
Carton C = 18 x 16 x 14 = 2.33 Cubic Feet
... etc, on down to Carton J.

Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
column it will automatically enter the cubic feet for us under the cubic
feet column? Then at the bottom of the sheet we'll have a total which will
total up the cubic feet for us.

On Wednesday, May 23, 2007 2:03 PM
Ron Rosenfeld wrote:

Re: Carton size and cubic feet auto calculate..
Set up a table. Name it something like CuFtTbl.

A 3.38
B 2.63
C 2.33
....
J

Then use this formula:

=VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE)
--ron

On Wednesday, May 23, 2007 3:03 PM
shawn wrote:

But then won't that table show up on printouts?
But then will not that table show up on printouts? Is there a way to put the
table on sheet2 and have it read the data off that?

On Wednesday, May 23, 2007 3:07 PM
shawn wrote:

So far I've tried and can't get it to work.
So far I have tried and cannot get it to work. I have tried to make a table below
my information on sheet1.

On Wednesday, May 23, 2007 3:07 PM
Peo Sjoblom wrote:

Yes, you can have the table in another sheet and even hide that sheet if you
Yes, you can have the table in another sheet and even hide that sheet if you
want


--
Regards,

Peo Sjoblom

On Wednesday, May 23, 2007 3:33 PM
Bob I wrote:

If your "Letter" is in cell A1, then put the following in the Cell you want
If your "Letter" is in cell A1, then put the following in the Cell you
want the size to appear.

=HLOOKUP(A1,{"A","B","C";3.38,2.63,2.33},2)&" Cubic Feet"

shawn wrote:

On Wednesday, May 23, 2007 3:53 PM
shawn wrote:

Here's what I have currently..Sheet1 has my Shipping Manifest.
Here's what I have currently..

Sheet1 has my Shipping Manifest.

Sheet2 has the following data from A1 to B11

BOX CF
A 3.38
B 2.63
C 2.33
D 2.04
E 1.56
F 1.04
G .65
H .41
I .41
J .25

I typed that data in, highlighted it all then converted it to a table.

I think where I am having trouble is the "lookup value"

I have written what Ron suggested and tried to go through the evaluate thing
to find errors.

On Wednesday, May 23, 2007 4:05 PM
Peo Sjoblom wrote:

You can use=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!
You can use

=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)))


replace A1 with the cell where you input the size



or hard coded which means you don't need the table in Sheet2

=IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
Value
Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)))



replace A1 with the cell where you input the size





--
Regards,

Peo Sjoblom

"shawn" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

On Friday, May 25, 2007 11:36 AM
shawn wrote:

Thanks. I used the hard coded method.
Thanks. I used the hard coded method. Is there a way for this to also work
in Excel 97-2003 format? It's not a big deal if it won't work, but three
machines in our office aren't upgraded to Excel 2007.


"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

On Friday, May 25, 2007 11:47 AM
Peo Sjoblom wrote:

The formula works fine in previous versions, you need to save the file in xls
The formula works fine in previous versions, you need to save the file in
xls format, do a save as after hitting the office button and you will se what
I mean


--
Regards,

Peo Sjoblom


Submitted via EggHeadCafe - Software Developer Portal of Choice
BOOK REVIEW: Effective C#, Second Edition [Addison Wesley]
http://www.eggheadcafe.com/tutorials...fective-c.aspx
 
Reply With Quote
 
 
 
 
Satwinder Saluja
Guest
Posts: n/a
 
      22nd Apr 2010
How to calculate carton size in cubic ft.



shawn wrote:

Carton size and cubic feet auto calculate..
23-May-07

I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
in a carton, carton size, cubic feet, etc

We have standard carton sizes we use which we've named

Carton A = 18 x 18 x 18 = 3.38 Cubic Fee
Carton B = 18 x 18 x 14 = 2.63 Cubic Fee
Carton C = 18 x 16 x 14 = 2.33 Cubic Fee
... etc, on down to Carton J

Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
column it will automatically enter the cubic feet for us under the cubic
feet column? Then at the bottom of the sheet we'll have a total which will
total up the cubic feet for us.

Previous Posts In This Thread:

On Wednesday, May 23, 2007 1:50 PM
shawn wrote:

Carton size and cubic feet auto calculate..
I have an Excel sheet for our "Shipping Manifest". It shows how many pieces
in a carton, carton size, cubic feet, etc

We have standard carton sizes we use which we've named

Carton A = 18 x 18 x 18 = 3.38 Cubic Fee
Carton B = 18 x 18 x 14 = 2.63 Cubic Fee
Carton C = 18 x 16 x 14 = 2.33 Cubic Fee
... etc, on down to Carton J

Is there a way to make it so we can type A, B, C, etc under "CTN SIZE"
column it will automatically enter the cubic feet for us under the cubic
feet column? Then at the bottom of the sheet we'll have a total which will
total up the cubic feet for us.

On Wednesday, May 23, 2007 2:03 PM
Ron Rosenfeld wrote:

Re: Carton size and cubic feet auto calculate..
Set up a table. Name it something like CuFtTbl

A 3.3
B 2.6
C 2.3
...


Then use this formula

=VLOOKUP(CTN_SIZE,CuFtTbl,2,FALSE
--ron

On Wednesday, May 23, 2007 3:03 PM
shawn wrote:

But then won't that table show up on printouts?
But then will not that table show up on printouts? Is there a way to put th
table on sheet2 and have it read the data off that?

On Wednesday, May 23, 2007 3:07 PM
shawn wrote:

So far I've tried and can't get it to work.
So far I have tried and cannot get it to work. I have tried to make a table belo
my information on sheet1.

On Wednesday, May 23, 2007 3:07 PM
Peo Sjoblom wrote:

Yes, you can have the table in another sheet and even hide that sheet if you
Yes, you can have the table in another sheet and even hide that sheet if yo
wan

-
Regards

Peo Sjoblom

On Wednesday, May 23, 2007 3:33 PM
Bob I wrote:

If your "Letter" is in cell A1, then put the following in the Cell you want
If your "Letter" is in cell A1, then put the following in the Cell yo
want the size to appear

=HLOOKUP(A1,{"A","B","C";3.38,2.63,2.33},2)&" Cubic Feet

shawn wrote:

On Wednesday, May 23, 2007 3:53 PM
shawn wrote:

Here's what I have currently..Sheet1 has my Shipping Manifest.
Here's what I have currently.

Sheet1 has my Shipping Manifest

Sheet2 has the following data from A1 to B1

BOX C
A 3.3
B 2.6
C 2.3
D 2.0
E 1.5
F 1.0
G .6
H .4
I .4
J .2

I typed that data in, highlighted it all then converted it to a table

I think where I am having trouble is the "lookup value

I have written what Ron suggested and tried to go through the evaluate thing
to find errors.

On Wednesday, May 23, 2007 4:05 PM
Peo Sjoblom wrote:

You can use=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!
You can us

=IF(A1="","",IF(ISNA(VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0)),"Incorrect Value
Entered",VLOOKUP(A1,Sheet2!$A$2:$B$11,2,0))

replace A1 with the cell where you input the siz


or hard coded which means you don't need the table in Sheet

=IF(A1="","",IF(ISNA(VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0)),"Incorrect
Value
Entered",VLOOKUP(A1,{"A",3.38;"B",2.63;"C",2.33;"D",2.04;"E",1.56;"F",1.04;"G",0.65;"H",0.41;"I",0.41;"J",25},2,0))


replace A1 with the cell where you input the siz



--
Regards

Peo Sjoblo

"shawn" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

On Friday, May 25, 2007 11:36 AM
shawn wrote:

Thanks. I used the hard coded method.
Thanks. I used the hard coded method. Is there a way for this to also work
in Excel 97-2003 format? It's not a big deal if it won't work, but three
machines in our office aren't upgraded to Excel 2007.


"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

On Friday, May 25, 2007 11:47 AM
Peo Sjoblom wrote:

The formula works fine in previous versions, you need to save the file in xls
The formula works fine in previous versions, you need to save the file in
xls format, do a save as after hitting the office button and you will se what
I mean


--
Regards,

Peo Sjoblom

On Thursday, April 22, 2010 5:17 AM
Satwinder Saluja wrote:

How to calculate carton size in cubic ft.
How to calculate carton size in cubic ft.


Submitted via EggHeadCafe - Software Developer Portal of Choice
Get Silverlight 4 Installed: Tips and Tricks
http://www.eggheadcafe.com/tutorials...4-install.aspx
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How do I convert cubic feet to cubic meters? no2pzl@gmail.com Microsoft Excel Worksheet Functions 0 8th Sep 2012 04:15 PM
Excel 2003, how to convert gallons to cubic feet? Petec Microsoft Excel Worksheet Functions 6 3rd Mar 2009 03:53 AM
Cubic Parabola or Cubic Spiral =?Utf-8?B?TWljaGFlbCBN?= Microsoft Excel Worksheet Functions 0 7th Aug 2006 11:19 PM
Convert cubic centimeters to fluid ounces and cubic centimeters =?Utf-8?B?T2NhbGFFbGFpbmU=?= Microsoft Excel Worksheet Functions 4 14th Jun 2006 06:43 PM
convert cubic centimeters to fluid ounces and cubic centimeters =?Utf-8?B?T2NhbGFFbGFpbmU=?= Microsoft Excel Worksheet Functions 4 13th Jun 2006 10:03 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:36 PM.