OnlineConversion Forums Welcome to OnlineConversion.com Forums

Go Back   OnlineConversion Forums > Main Forums > Convert and Calculate

Convert and Calculate Post any conversion related questions and discussions here. If you're having trouble converting something, this is where you should post.
* Guest Posting is allowed.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-03-2011, 02:42 AM
ecoimpact ecoimpact is offline
Junior Member
 
Join Date: Sep 2011
Posts: 3
Rep Power: 0
ecoimpact is on a distinguished road
Default Conversion for g/m2 to Kg/ha

I need a conversion that I can put into excel i.e. =Cell number * the calculation.

The cell number is g/m2 which I need to convert to kg/ha. The data analysis pack in excel only lets you convert from a single unit into another single unit i.e. g to kg.

please help. Post reply in laymens terms please.
Reply With Quote
  #2  
Old 09-03-2011, 03:45 AM
JohnS JohnS is offline
Moderator
Long Time Member The Golden Calculator Award Over 5000 Posts
 
Join Date: Dec 2007
Location: SE Michigan, USA
Posts: 9,533
Rep Power: 19
JohnS will become famous soon enough
Default Re: Conversion for g/m2 to Kg/ha

Quote:
Originally Posted by ecoimpact View Post
I need a conversion that I can put into excel i.e. =Cell number * the calculation.

The cell number is g/m2 which I need to convert to kg/ha. The data analysis pack in excel only lets you convert from a single unit into another single unit i.e. g to kg.

please help. Post reply in laymens terms please.
It is two successive conversions, but you can combine the two numeric factors

1 g/m x 1 kg/1000 g x 10000 m/ha = 10 kg/ha
Just multiply by 10.
Reply With Quote
  #3  
Old 09-03-2011, 02:44 PM
ecoimpact ecoimpact is offline
Junior Member
 
Join Date: Sep 2011
Posts: 3
Rep Power: 0
ecoimpact is on a distinguished road
Default Re: Conversion for g/m2 to Kg/ha

Quote:
Originally Posted by JohnS View Post
It is two successive conversions, but you can combine the two numeric factors

1 g/m x 1 kg/1000 g x 10000 m/ha = 10 kg/ha
Just multiply by 10.
Ok, say what if I have 190.5 g/m2 and want to convert that to kg/ha? Do I just divide by 10,000?

How would I enter the calculation into excel?

Just in case you misunderstood the short hand:

grams/square metre to kilograms/hectare

Last edited by ecoimpact; 09-03-2011 at 02:55 PM.
Reply With Quote
  #4  
Old 09-03-2011, 04:44 PM
JohnS JohnS is offline
Moderator
Long Time Member The Golden Calculator Award Over 5000 Posts
 
Join Date: Dec 2007
Location: SE Michigan, USA
Posts: 9,533
Rep Power: 19
JohnS will become famous soon enough
Default Re: Conversion for g/m2 to Kg/ha

Quote:
Originally Posted by ecoimpact View Post
Ok, say what if I have 190.5 g/m2 and want to convert that to kg/ha? Do I just divide by 10,000?

How would I enter the calculation into excel?

Just in case you misunderstood the short hand:

grams/square metre to kilograms/hectare
No, you multiply by 10000 and divide by 1000. Net is 10
190.5 g/m = 1905 kg/ha (or 1.905 t/ha)

Actually, the symbols cross boundaries better than the words because of things like metre/meter spelling differences.

If the two figures are in columns, just multiply the figure in the g/m column by 10. You can copy the formula down a column.
Reply With Quote
  #5  
Old 10-15-2011, 03:44 PM
ecoimpact ecoimpact is offline
Junior Member
 
Join Date: Sep 2011
Posts: 3
Rep Power: 0
ecoimpact is on a distinguished road
Default Re: Conversion for g/m2 to Kg/ha

Thanks JohnS

So if I were going to use this conversion for data to be included within a report as a part of university degree, do you think I should include the following detail as an example to explain the conversion factor, as I was just going to show the converted data, not both the original and converted information:

1 g/m x 1 kg/1000 g x 10000 m/ha = 10 kg/ha

How would it look for t/ha?....>>>

1 g/m divide by 1 t/1000 g divide by 100 m/ha = 10 t/ha
Reply With Quote
  #6  
Old 10-15-2011, 04:14 PM
JohnS JohnS is offline
Moderator
Long Time Member The Golden Calculator Award Over 5000 Posts
 
Join Date: Dec 2007
Location: SE Michigan, USA
Posts: 9,533
Rep Power: 19
JohnS will become famous soon enough
Default Re: Conversion for g/m2 to Kg/ha

Quote:
Originally Posted by ecoimpact View Post
Thanks JohnS

So if I were going to use this conversion for data to be included within a report as a part of university degree, do you think I should include the following detail as an example to explain the conversion factor, as I was just going to show the converted data, not both the original and converted information:

1 g/m x 1 kg/1000 g x 10000 m/ha = 10 kg/ha

How would it look for t/ha?....>>>

1 g/m divide by 1 t/1000 g divide by 100 m/ha = 10 t/ha
No, 10 kg = 0.01 t, so
1 g/m = 10 kg/ha = 0.01 t/ha

however 100 ha = 1 km, so 1 g/m = 1 t/km
Reply With Quote
  #7  
Old 11-18-2011, 07:31 AM
Unregistered
Guest
 
Posts: n/a
Question Re: Conversion for g/m2 to Kg/ha

To show the conversion procedure in your report you could do something like this:

1 000 g = 1 kg
10 000 m^2 = 1 ha
Thus 1 000 g/10 000 m^2 = kg/ha
1g/10 m^2 = kg/ha
0.1 g/m^2 = kg/ha
Reply With Quote
  #8  
Old 03-28-2013, 10:50 PM
Unregistered
Guest
 
Posts: n/a
Default Re: Conversion for g/m2 to Kg/ha

Quote:
Originally Posted by ecoimpact View Post
I need a conversion that I can put into excel i.e. =Cell number * the calculation.

The cell number is g/m2 which I need to convert to kg/ha. The data analysis pack in excel only lets you convert from a single unit into another single unit i.e. g to kg.

please help. Post reply in laymens terms please.
The value for soil test is Kg/ha l need to convert to %. Please tell me the conversion factor

please help. Post reply in laymens terms please.[/QUOTE]
Reply With Quote
  #9  
Old 03-29-2013, 01:42 AM
JohnS JohnS is offline
Moderator
Long Time Member The Golden Calculator Award Over 5000 Posts
 
Join Date: Dec 2007
Location: SE Michigan, USA
Posts: 9,533
Rep Power: 19
JohnS will become famous soon enough
Default Re: Conversion for g/m2 to Kg/ha

Quote:
Originally Posted by Unregistered View Post
The value for soil test is Kg/ha l need to convert to %. Please tell me the conversion factor

please help. Post reply in laymens terms please.
[/QUOTE]

Did you read post #2 or #4, which have the answer?
Reply With Quote
  #10  
Old 10-26-2013, 02:39 PM
Unregistered
Guest
 
Posts: n/a
Default Conversion for lbs/ft3 to tons/acre

Does anyone know how to convert lbs/ft3 to tons/acre? For example say you have a measurement of a material (dirt) 21 lbs/ft3, how do you convert to tons/acre? ANy help is appreciated
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may post new threads
You may 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

Forum Jump


All times are GMT -8. The time now is 08:12 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 1997-2005, 2007, OnlineConversion.com