Spreadsheet: 149111d1333703322-how-many-if-functions-can-you-use-excel-2011-mac-chp-consumption-test
Sheet: CHP Performance

CHP Unit Performance Data
Existing CHP 110 |  | Energy Balance and Part Load Operation |  |  |  |  | Correlation
 | Units | 1 | 0.75 | 0.5 |  |  | Electrical Output | Thermal Output | Fuel Used
Electrical Output | kW |  |  |  |  | 75 - 100
Heat Output | kW | 177 |  |  |  | 50 - 75
Fuel Used | kW | 367
Electrical Efficiency | %
Thermal Efficiency | %
Total Efficiency (Gross) | %
 | Elec Output (kW) | Thermal Output (kW) | Fuel Used (kW)
0.5 | 55 | 95.35916819846882 | 218.983423763219
0.51 | 56.10000000000008 | 97.39349714733004 | 221.9437552998904
0.52 | 57.20000000000008 | 99.42782609619128 | 224.9040868365617
0.53 | 58.30000000000008 | 101.4621550450525 | 227.8644183732329
0.54 | 59.40000000000008 | 103.4964839939138 | 230.8247499099042
0.55 | 60.50000000000009 | 105.530812942775 | 233.7850814465754
0.56 | 61.60000000000009 | 107.5651418916363 | 236.7454129832467
0.57 | 62.70000000000009 | 109.5994708404975 | 239.7057445199179
0.58 | 63.80000000000009 | 111.6337997893587 | 242.6660760565892
0.59 | 64.90000000000009 | 113.66812873822 | 245.6264075932604
0.6 | 66.00000000000009 | 115.7024576870812 | 248.5867391299317
0.61 | 67.10000000000008 | 117.7367866359425 | 251.5470706666029
0.62 | 68.20000000000007 | 119.7711155848037 | 254.5074022032742
0.63 | 69.30000000000007 | 121.805444533665 | 257.4677337399454
0.64 | 70.40000000000006 | 123.8397734825262 | 260.4280652766166
0.65 | 71.50000000000006 | 125.8741024313875 | 263.3883968132878
0.66 | 72.60000000000005 | 127.9084313802487 | 266.3487283499591
0.67 | 73.70000000000005 | 129.9427603291099 | 269.3090598866303
0.68 | 74.80000000000004 | 131.9770892779712 | 272.2693914233015
0.69 | 75.90000000000003 | 134.0114182268325 | 275.2297229599727
0.7 | 77.00000000000003 | 136.0457471756937 | 278.1900544966439
0.71 | 78.10000000000002 | 138.080076124555 | 281.1503860333152
0.72 | 79.20000000000002 | 140.1144050734162 | 284.1107175699864
0.73 | 80.30000000000001 | 142.1487340222775 | 287.0710491066576
0.74 | 81.4 | 144.1830629711388 | 290.0313806433288
0.75 | 82.5 | 146.21739192 | 292.99171218
0.76 | 83.60000000000014 | 147.4486962432002 | 295.9520436928001
0.77 | 84.70000000000013 | 148.6800005664002 | 298.9123752056001
0.78 | 85.80000000000013 | 149.9113048896002 | 301.8727067184001
0.79 | 86.90000000000012 | 151.1426092128002 | 304.8330382312001
0.8 | 88.00000000000011 | 152.3739135360001 | 307.7933697440001
0.81 | 89.10000000000011 | 153.6052178592001 | 310.7537012568001
0.82 | 90.2000000000001 | 154.8365221824001 | 313.7140327696001
0.83 | 91.3000000000001 | 156.0678265056001 | 316.6743642824001
0.84 | 92.40000000000009 | 157.2991308288001 | 319.6346957952001
0.85 | 93.50000000000009 | 158.5304351520001 | 322.5950273080001
0.86 | 94.60000000000008 | 159.7617394752001 | 325.5553588208001
0.87 | 95.70000000000007 | 160.9930437984001 | 328.5156903336
0.88 | 96.80000000000007 | 162.2243481216001 | 331.4760218464
0.89 | 97.90000000000006 | 163.4556524448001 | 334.4363533592
0.9 | 99.00000000000006 | 164.6869567680001 | 337.396684872
0.91 | 100.1000000000001 | 165.9182610912001 | 340.3570163848
0.92 | 101.2 | 167.1495654144001 | 343.3173478976
0.93 | 102.3 | 168.3808697376001 | 346.2776794104
0.94 | 103.4 | 169.6121740608 | 349.2380109232
0.95 | 104.5 | 170.843478384 | 352.198342436
0.96 | 105.6 | 172.0747827072 | 355.1586739488
0.97 | 106.7 | 173.3060870304 | 358.1190054616
0.98 | 107.8 | 174.5373913536 | 361.0793369744
0.99 | 108.9 | 175.7686956768 | 364.0396684872
1 | 110 | 177 | 367