jagomart
digital resources
picture1_Vol4 Ch10  Mcf Calculation Spreadsheet


 196x       Filetype XLSX       File size 0.04 MB       Source: www.ipcc-nggip.iges.or.jp


File: Vol4 Ch10 Mcf Calculation Spreadsheet
colour code required optional fixed input calculation user input user input don t edit don t edit inputs air manure temperature temperature manure month month c c removed yn january ...

icon picture XLSX Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Partial file snippet.
             COLOUR CODE:    REQUIRED      OPTIONAL        FIXED INPUT       CALCULATION 
                             USER INPUT    USER INPUT       DON'T EDIT        DON'T EDIT
            INPUTS:
                                               Air           Manure
                                           Temperature     Temperature          Manure
            Month             Month            °C              °C            Removed (Y/N)
            January              1            -9.0             1.0                N
            February             2            -7.7             1.0                N
            March                3            -2.3             1.0                N
            April                4            4.7              1.0                N
            May                  5            10.7             4.7                Y
            June                 6            15.2            10.7                N
            July                 7            17.7            15.2                n
            August               8            16.7            17.7                N
            September            9            12.0            16.7                N
            October             10            5.8             12.0                N
            November            11            -1.4             5.8                Y
            December            12            -6.7             1.0                N
                                              4.6              7.3                2
                                             Average         Average          Count of "Y"
                          RESULTS:         Analysis of model year 3
                                          VS Excreted (kg)                             1,200 
                                           VS Loaded (kg)                             1,200 
                                       Potential CH4 (m3)                                 288 
            MODEL: Runs for three years  in order to ensure VS available has stabilized on an annual basis. The results from the third year (stabilized conditions) are used
                                            (lookup)       (converted)   (calculated - van't Hoff)
                 Year         Month          Tav_C            Tav_K                f
                         1             1      1.0            274.15              0.02
                         1             2      1.0            274.15              0.02
                         1             3      1.0            274.15              0.02
                         1             4      1.0            274.15              0.02
                         1             5      4.7            277.85              0.03
                         1             6      10.7           283.85              0.07
                         1             7      15.2           288.35              0.11
                         1             8      17.7           290.85              0.15
                         1             9      16.7           289.85              0.14
                         1            10      12.0           285.15              0.08
             1      11   5.8     278.95    0.04
             1      12   1.0     274.15    0.02
             2      13   1.0     274.15    0.02
             2      14   1.0     274.15    0.02
             2      15   1.0     274.15    0.02
             2      16   1.0     274.15    0.02
             2      17   4.7     277.85    0.03
             2      18   10.7    283.85    0.07
             2      19   15.2    288.35    0.11
             2      20   17.7    290.85    0.15
             2      21   16.7    289.85    0.14
             2      22   12.0    285.15    0.08
             2      23   5.8     278.95    0.04
             2      24   1.0     274.15    0.02
             3      25   1.0     274.15    0.02
             3      26   1.0     274.15    0.02
             3      27   1.0     274.15    0.02
             3      28   1.0     274.15    0.02
             3      29   4.7     277.85    0.03
             3      30   10.7    283.85    0.07
             3      31   15.2    288.35    0.11
             3      32   17.7    290.85    0.15
             3      33   16.7    289.85    0.14
             3      34   12.0    285.15    0.08
             3      35   5.8     278.95    0.04
             3      36   1.0     274.15    0.02
                                               SUM:
                                               Year 1
                                               Year 2
                                               Year 3
                                                                   Parameter:                                          Value                              Units
                                                                   VS Excretion:                                                      1200kg/year
                                                                   VS % liquid storage:                                              100%%
                                                                   f equation:                            f = EXP((Ea*(T2-T1))/(R*T2*303.16))
                                                                                                     T1                            308.16K 
                                                                                                     T2         monthly input                  K
                                                                                                     Ea                             19347cal/mol
                                                                                                       R                             1.987cal/K.mol
                                                                                    Minimum T2                                           1.0C
                                                                                     Damping T2                                          3.0C
                                                                   B0                                                                  0.24m3/kg VS added
                                                                   MDP                                                                   1.0unitless
                                                                   emptying efficiency                                                 95%%
                                                                   CH4 density                                                       0.662kg/m3
                                                                        VS "consumed" (kg)                               249                            MCF =
                                                                        CH4 emissions (m3)                                 60 
Runs for three years  in order to ensure VS available has stabilized on an annual basis. The results from the third year (stabilized conditions) are used
                                               VS Excreted                              VS Loaded                   Emptying                               VS Emptied
                                                  kg/month                               kg/month                        Y/N                                              kg
                                                               100                                   100                   N                                            n/a 
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   Y                                            362 
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   n                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   Y                                            398 
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   Y                                            548 
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   n                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   Y                                            403 
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   Y                                            548 
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   n                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   N                                                -   
                                                               100                                   100                   Y                                            403 
                                                               100                                   100                   N                                                -   
                                                           1,200                                1,200                                                                   760 
                                                           1,200                                1,200                                                                   951 
                                                           1,200                                1,200                                                                   951 
The words contained in this file might help you see if this file matches what you are looking for:

...Colour code required optional fixed input calculation user don t edit inputs air manure temperature month c removed yn january n february march april may y june july august september october november december average count of results analysis model year vs excreted kg loaded potential ch m runs for three years in order to ensure available has stabilized on an annual basis the from third conditions are used lookup converted calculated van hoff tav k f sum parameter value units excretion kgyear liquid storage equation exp ea tt r monthly calmol calkmol minimum damping b mkg added mdp unitless emptying efficiency density kgm consumed mcf emissions emptied kgmonth na...

no reviews yet
Please Login to review.