Announcement

Announcement Module
Collapse
No announcement yet.

Conversion for g/m2 to Kg/ha

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    Re: Conversion for g/m2 to Kg/ha

    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.

    Comment


    • #3
      Re: Conversion for g/m2 to Kg/ha

      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, 02:55 PM.

      Comment


      • #4
        Re: Conversion for g/m2 to Kg/ha

        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.

        Comment


        • #5
          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

          Comment


          • #6
            Re: Conversion for g/m2 to Kg/ha

            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

            Comment


            • #7
              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

              Comment


              • #8
                Re: Conversion for g/m2 to Kg/ha

                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]

                Comment


                • #9
                  Re: Conversion for g/m2 to Kg/ha

                  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?

                  Comment


                  • #10
                    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

                    Comment


                    • #11
                      Re: Conversion for lbs/ft3 to tons/acre

                      Originally posted by Unregistered View Post
                      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
                      An acre is a unit of area, you must specify a thickness for what you are applying to get a volume. An acre is 43560 square feet. Multiply by the thickness of what you are applying (in feet, or divide inches by 12) to get cubic feet.

                      Then multiply by density 21 lb/ft to get total pounds and divide by 2000 lb/ton to get tons (US tons, use 2240 instead for UK or long tons)

                      Comment

                      Working...
                      X