Spreadsheet: 895d26ef-9ad3-4b4d-aab1-4938787bc957
Sheet: Sheet1

Condensate Equalization Model | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
 |  |  |  |  |  |  |  |  |  |  |  |  | Volumetric Shrinkage Due to Blending
INPUT |  |  |  |  |  | OUTPUT |  |  |  |  |  |  | AS PER API 2509 C
Data for production month of, [NAME]/yyyy |  |  | 2013-01-01 00:00:00 |  |  | Density Slope, $[NAME] / m3 per kg/m3 |  |  | 0.72 |  |  |  | Density of Dry Crude |  | 998.6807999999999 |  |  | Dry Crude volume: |  |  | 100 | m3
Condensate Allowance Price, $[NAME]/m3 |  |  | 685.45 |  |  |  |  |  |  |  |  |  | Density of Condensate |  | 714.16 |  |  | Condensate Required in Blend: |  |  | 42.4544693771663 | m3
Heavy Allowance Price, $[NAME]/m3 |  |  | 373.0111285964463 |  |  | Calculated Density, kg / m3 |  |  | 919.4058140723487 |  |  |  | Density of Target Blend |  | 919.4058140723487 |  |  | Ideal Blend Volume |  |  | 142.4544693771663
Enbridge Reference Temperature, °C |  |  | 7.74 |  |  |  |  |  |  |  |  |  | Shrinkage Factor |  | 0.9939979362297635 |  |  | Non Ideal Blend Volume |  |  | 141.5994485676094
Average Condensate Density, Kg/m3 |  |  | 714.16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shrinkage Factor |  |  | 0.9939979362297635
 |  |  |  |  |  |  |  |  |  |  |  |  | API 2509C
 |  |  |  |  |  |  |  |  |  |  |  |  | ITERATIONS:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Iteration 1 |  | Iteration 2 |  | Iteration 3 |  | Iteration 4 |  | Iteration 5 |  | Iteration 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | API Gravity |  | API Gravity |  | API Gravity |  | API Gravity |  | API Gravity |  | API Gravity
 |  |  |  |  |  |  |  |  |  |  |  |  | Density of Condensate | kg/m3 | 714.16 | 66.63487173742578 | 714.16 | 66.63487173742578 | 714.16 | 66.63487173742578 | 714.16 | 66.63487173742578 | 714.16 | 66.63487173742578 | 714.16 | 66.63487173742578
 |  |  |  |  |  |  |  |  |  |  |  |  | Raw Crude Density | kg/m3 | 998.6807999999999 | 10.1869133761258 | 924.6854171711163 | 21.52501518071949 | 919.7832152461851 | 22.34059814803942 | 919.4379560341365 | 22.39836700927589 | 919.4090673253644 | 22.40320264257886 | 919.4062009431274 | 22.40368245814443
 |  |  |  |  |  |  |  |  |  |  |  |  | Density of Target Blend | kg/m3 | 919.4058140723487 | 22.40374721827163 | 919.4058140723487 | 22.40374721827163 | 919.4058140723487 | 22.40374721827163 | 919.4058140723487 | 22.40374721827163 | 919.4058140723487 | 22.40374721827163 | 919.4058140723487 | 22.40374721827163
 |  |  | Density | a1 | b1 | a2 | b2 | Ratio |  |  |  |  | Raw Crude Volume | m3 | 100 |  | 137.8329177618602 |  | 141.3204278285371 |  | 141.5753351041633 |  | 141.5970050929041 |  | 141.5991898965583
Cold Lake (thermal) |  |  | 1002.3 | -0.001742431717063273 | 2.526452741941541 | 0.08221959843593053 | 849.0989884029863 | 0.84 |  |  |  |  | Raw Crude Mass | [NAME] | 99868.07999999999 |  | 127452.0890605379 |  | 129984.1574880983 |  | 130169.7367330198 |  | 130185.5703885318 |  | 130187.1732394191
LLK (conventiona) |  |  | 979.68 | -0.0005798736292135057 | 1.607901510734108 | 0.02055187202094259 | 904.2330179469975 | 0.16 |  |  |  |  | Required Diluent Volume | m3 | 38.62441058101528 |  | 3.545519810071216 |  | 0.2598566776653503 |  | 0.02217101981633143 |  | 0.00224438625419273 |  | 0.0002669023439325824
Blend |  |  | 998.6807999999999 | -0.00155642242300731 | 2.379484544948352 | 0.07235276220953246 | 857.9204331300281 | 1 |  |  |  |  | Diluent Mass | [NAME] | 27584.00906053787 |  | 2532.068427560459 |  | 185.5792449214865 |  | 15.83365551203125 |  | 1.60285088729428 |  | 0.1906109779428931
 |  |  |  |  |  |  |  |  |  |  |  |  | Total Blend Mass | [NAME] | 127452.0890605379 |  | 129984.1574880983 |  | 130169.7367330198 |  | 130185.5703885318 |  | 130187.1732394191 |  | 130187.3638503971
 |  |  |  |  |  |  |  |  |  |  |  |  | Volume % Diluent in Blend | % | 27.86263286468027 |  | 2.507822176396103 |  | 0.1835401578487196 |  | 0.01565777563689503 |  | 0.001585026942196524 |  | 0.0001884910789676501
 |  |  |  | Reference |  |  | Cond | "Spec" |  |  |  |  | Diluent Shrinkage 2509C |  | 0.02049203618253097 |  | 0.01636142131529549 |  | 0.0190466609658034 |  | 0.02259846771297479 |  | 0.02654739124894767 |  | 0.03084009210921875
 |  |  |  | Temp. |  |  | Density | Density |  |  |  |  | Reduced Diluent Volume in Blend | m3 | 37.83291776186018 |  | 3.487510066676915 |  | 0.2549072756261583 |  | 0.02166998874084834 |  | 0.002184803654188916 |  | 0.0002586710510615352
 |  |  |  | (deg C) | Slope | Intercept | (kg/m3) | (kg/m3) |  |  |  |  | Ideal Blend Volume | m3 | 138.6244105810153 |  | 141.3784375719314 |  | 141.5802845062024 |  | 141.5975061239796 |  | 141.5992494791583 |  | 141.5994567989022
Avg Heavies / Specific Diluents |  |  |  | 7.74 | 1.267949907333452 | 909.5918817895878 | 714.16 | 919.4058140723487 |  |  |  |  | Non Ideal Blend Volume | m3 | 137.8329177618602 |  | 141.3204278285371 |  | 141.5753351041633 |  | 141.5970050929041 |  | 141.5991898965583 |  | 141.5994485676094
 |  |  |  |  |  |  |  |  |  |  |  |  | Actual Blend Density | kg/m3 | 924.6854171711163 |  | 919.7832152461851 |  | 919.4379560341365 |  | 919.4090673253644 |  | 919.4062009431274 |  | 919.4058675181678
Enbridge |  |  | Enbridge | Avg
Reference | Target | Target | Cond | Raw | "Spec"
Temp. | Density | Density | Density | Density | Density | Diluent | Shrinkage | Blend | Cond | Bit. | Blend
(°C) | Slope | Intercept | (kg/m3) | (kg/m3) | (kg/m3) | in R + C | Factor | Price | Value | Real. | Value |  | 714.16 | 0.9939979362297635 | 917.3457593136383 | 918.5518803667474 | 919.7580014198566 | 920.9641224729656 | 922.1702435260748 | 923.3763645791839 | 924.5824856322931
7.74 | 1.267949907333452 | 909.5918817895878 | 714.16 | 998.6807999999999 | 919.4058140723487 | 0.2980215093393513 | 0.9939979362297635 | 373.0111285964463 | 685.45 | 237.1774216076809 | 373.0111285964463 |  | 919.4058140723487 | 680 | 0.9925226179774317 | 0.9926195077312997 | 0.9927166881769726 | 0.9928141602644477 | 0.9929119250367964 | 0.9930099836330663 | 0.9931083372914034
7.74 | 1.321117297303381 | 907.1203114325101 | 680 | 998.6807999999999 | 917.3457593136383 | 0.2767483493688126 | 0.9925226179774317 | 373.0111285964463 | 717.9194407923253 | 237.1774216076809 | 363.9575675173891 |  |  | 700 | 0.9933349363801298 | 0.9934213710714312 | 0.9935080676815716 | 0.9935950268261493 | 0.9936822492086614 | 0.9937697356228582 | 0.9938574869553104
7.74 | 1.289988848843235 | 908.5673666767008 | 700 | 998.6807999999999 | 918.5518803667474 | 0.2885077701875196 | 0.9934213710714312 | 373.0111285964463 | 699.486651965015 | 237.1774216076809 | 368.9346276500684 |  |  | 720 | 0.9940685091466576 | 0.9941454518623579 | 0.9942226319885126 | 0.9943000498108316 | 0.9943777057000798 | 0.9944556001138741 | 0.9945337335986809
7.74 | 1.258860400383089 | 910.0144219208914 | 720 | 998.6807999999999 | 919.7580014198566 | 0.3022690441388717 | 0.9942226319885126 | 373.0111285964463 | 679.4280821320427 | 237.1774216076809 | 374.8419452558797 |  |  | 740 | 0.9947338444950206 | 0.9948021316159837 | 0.9948706355204994 | 0.9949393561508189 | 0.9950082935343212 | 0.9950774477846873 | 0.9951468191032747
7.74 | 1.227731951922943 | 911.4614771650821 | 740 | 998.6807999999999 | 920.9641224729656 | 0.3184517325937744 | 0.9949393561508189 | 373.0111285964463 | 657.7938504277522 | 237.1774216076809 | 381.8630738870896 |  |  | 760 | 0.9953398296391729 | 0.9954001875389049 | 0.9954607453304729 | 0.9955215025730225 | 0.9955824589150617 | 0.9956436140948531 | 0.9957049679410137
7.74 | 1.196603503462796 | 912.9085324092728 | 760 | 998.6807999999999 | 922.1702435260748 | 0.3376236438457095 | 0.9955824589150617 | 373.0111285964463 | 634.6197140804586 | 237.1774216076809 | 390.2487829928252 |  |  | 780 | 0.9958940683144499 | 0.9959471252615789 | 0.996000369123202 | 0.9960537989922895 | 0.9961074140621858 | 0.9961612136258706 | 0.9962151970754564
7.74 | 1.16547505500265 | 914.3555876534634 | 780 | 998.6807999999999 | 923.3763645791839 | 0.360567000062903 | 0.9961612136258706 | 373.0111285964463 | 609.9286632006819 | 237.1774216076809 | 400.3465653490534 |  |  | 800 | 0.9964031668173905 | 0.9964494592649689 | 0.9964959303031288 | 0.9965425783925385 | 0.9965894021179663 | 0.9966364001855819 | 0.9966835714205932
7.74 | 1.134346606542504 | 915.8026428976541 | 800 | 998.6807999999999 | 924.5824856322931 | 0.3883849176522176 | 0.9966835714205932 | 373.0111285964463 | 583.7321823720446 | 237.1774216076809 | 412.6482484968863
 |  |  |  |  |  |  | R2
 |  |  | Blending Efficiency |  |  | -1.118725215787665 | 0.9964175386336247
 |  |  | Bitumen Blend Value |  |  | 0.4005406358453698 | 0.9761586349250995
 |  |  | Density Penalty |  |  | -0.7181845799422955