What is the volume of an amount of Natural gas with an energy content of 1 000 TJ (Gross) if its GCV is 40 000 kJ/m3? 1 000 TJ / (40 000 kJ/m3) = 1 000 TJ / (40 TJ/ (106*m3)) = 25 000 000 m3 = 25 Mm3. Basic Excel Functions The SUM function Adds all the values given and provides their sum will show 7 on the cell ”=SUM(1,2,3)“ Instead of a fixed number, you can input a formula, e.g. ”=SUM(B1:B10,C1,D1:D2,E1:G1)“ The AVERAGE function Returns the average of the given values will return 6 ”=AVERAGE(2,3,7)“ Instead of a fixed number, you can input a formula, e.g. ”=AVERAGE(A1:B3,D1/D2,3*E1)“ The function Rounds a number to the decimals specified will round to 2 decimal points, so the result will be 4.16. Similarly: ”=ROUND(4.1586,2)“ 4 ”=ROUND(4.1586,0)“ 4.2 ”=ROUND(4.1586,1)“ Instead of a fixed number, you can input a formula, e.g. ”=ROUND((C1+D1)/B1,0)“ Of course, you can combine functions: will return the sum of the cells A1 to B10, divided by 3 and “=ROUND(SUM(A1:B10)/3,0)” then rounded to 0 decimal points (therefore rounded to the closest integer).
What is the volume of an amount of Natural gas with an energy content of 1 000 TJ (Gross) if its GCV is 40 000 kJ/m3? 1 000 TJ / (40 000 kJ/m3) = 1 000 TJ / (40 TJ/ (106*m3)) = 25 000 000 m3 = 25 Mm3. Basic Excel Functions The SUM function Adds all the values given and provides their sum ”=SUM(1,2,3)“ will show 7 on the cell Instead of a fixed number, you can input a formula, e.g. ”=SUM(B1:B10,C1,D1:D2,E1:G1)“ The AVERAGE function Returns the average of the given values ”=AVERAGE(2,3,7)“ will return 6 Instead of a fixed number, you can input a formula, e.g. ”=AVERAGE(A1:B3,D1/D2,3*E1)“ The function Rounds a number to the decimals specified ”=ROUND(4.1586,2)“ will round to 2 decimal points, so the result will be 4.16. Similarly: ”=ROUND(4.1586,0)“ 4 ”=ROUND(4.1586,1)“ 4.2 Instead of a fixed number, you can input a formula, e.g. ”=ROUND((C1+D1)/B1,0)“ Of course, you can combine functions: “=ROUND(SUM(A1:B10)/3,0)” will return the sum of the cells A1 to B10, divided by 3 and then rounded to 0 decimal points (therefore rounded to the closest integer).