Weight calculation

**artonwood** · 10-18-2009, 08:22 AM

Hi All

I am using excel 2002.

I cut alphabet letters out of MDF. I need to calculate the total weight of any letter.
I have a program that will give me the area of any shape. In the picture below I have started with the letter “A”. B7 is the over all area. D7 is the small triangle. G7 is the total area minus the triangle D7. H7 is the thickness and I7 is the total volume.

Now I am stuck.
The weight of my MDF I have set at is 850kg cubic meter. That’s set in A3.

I need the total weight of the letter in J7 to be in grams.
The idea is, I put in the areas and set the thickness and it gives me the total weight.

When I done this a while, back it worked out pretty near. But I am not getting it to work.
Regards
Roger

**DonkeyOte** · 10-18-2009, 08:45 AM

Roger, welcome to the board - rather than posting an image...

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

**artonwood** · 10-18-2009, 08:52 AM

Hi DonkeyOte

Here it is attached.
Regards
Roger

**darkyam** · 10-18-2009, 09:11 AM

Is the volume in cubic cm? If so, why not just multiply J *1000 or make A3 read 0.850000?

**artonwood** · 10-18-2009, 09:31 AM

Hello
Well? 850kg cubic meter.
Should I have 850.000 in A3?

**darkyam** · 10-18-2009, 09:34 AM

You can, but then you'd have to take into account the cm to m conversion elsewhere. It actually might a more straightforward approach, and then you can divide J by 1,000.

**artonwood** · 10-18-2009, 10:25 AM

Is this correct?

Roger

**darkyam** · 10-18-2009, 11:23 AM

No, that didn't take into account the kg to g conversion. Here, this is more what I was talking about.

**artonwood** · 10-18-2009, 01:21 PM

I see.
Thank you very much. I know I did it a different way, just can not remember.

Regards
Roger

**shg** · 10-18-2009, 01:40 PM

If you have a vector list of points for each letter, there's a simple equation to compute the area. The result could be mutiplied by scale factors for size, thickness, and material density.