Welcome to OnlineConversion.com Forums

 OnlineConversion Forums Conversion for g/m2 to Kg/ha
 User Name Remember Me? Password
 [ Home ] [ Forum Home ] Register FAQ Calendar Search Today's Posts Mark Forums Read

 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.

 Thread Tools Display Modes
#1
09-03-2011, 02:42 AM
 ecoimpact Junior Member Join Date: Sep 2011 Posts: 3 Rep Power: 0
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.
#2
09-03-2011, 03:45 AM
 JohnS Moderator Join Date: Dec 2007 Location: SE Michigan, USA Posts: 9,533 Rep Power: 19
Re: Conversion for g/m2 to Kg/ha

Quote:
 Originally Posted by ecoimpact 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.
#3
09-03-2011, 02:44 PM
 ecoimpact Junior Member Join Date: Sep 2011 Posts: 3 Rep Power: 0
Re: Conversion for g/m2 to Kg/ha

Quote:
 Originally Posted by JohnS 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.
#4
09-03-2011, 04:44 PM
 JohnS Moderator Join Date: Dec 2007 Location: SE Michigan, USA Posts: 9,533 Rep Power: 19
Re: Conversion for g/m2 to Kg/ha

Quote:
 Originally Posted by ecoimpact 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.
#5
10-15-2011, 03:44 PM
 ecoimpact Junior Member Join Date: Sep 2011 Posts: 3 Rep Power: 0
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
#6
10-15-2011, 04:14 PM
 JohnS Moderator Join Date: Dec 2007 Location: SE Michigan, USA Posts: 9,533 Rep Power: 19
Re: Conversion for g/m2 to Kg/ha

Quote:
 Originally Posted by ecoimpact 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ē
#7
11-18-2011, 07:31 AM
 Unregistered Guest Posts: n/a
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
#8
03-28-2013, 10:50 PM
 Unregistered Guest Posts: n/a
Re: Conversion for g/m2 to Kg/ha

Quote:
 Originally Posted by ecoimpact 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]
#9
03-29-2013, 01:42 AM
 JohnS Moderator Join Date: Dec 2007 Location: SE Michigan, USA Posts: 9,533 Rep Power: 19
Re: Conversion for g/m2 to Kg/ha

Quote:
 Originally Posted by Unregistered 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?
#10
10-26-2013, 02:39 PM
 Unregistered Guest Posts: n/a
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

 Thread Tools Display Modes Linear Mode

 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 Rules
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Main Forums     Convert and Calculate     Resources     General Chat

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

 Contact Us - OnlineConversion.com - Archive - Privacy Statement - Top

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