{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Diversion Toll Calculator 365","Diversion Toll Calculator","Instructions","2005 Presentation"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":17,"n_cols":11,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"This spreadsheet is intended for use by customers of the TransCanada Canadian Mainline to help determine "]
[null,"alternate receipt and diversion transportation toll charges.  "]
[]
[null,"Disclaimer:"]
[null,"This tool is intended to be used for planning purposes only and although TransCanada endeavours to maintain "]
[null,"the tools in such a way that is accurate and current, this tool may not provide accurate results.  Use of this tool "]
[null,"is at user's sole risk and TransCanada shall not be liable for user's, or any party's, use of or reliance on any "]
[null,"results obtained from it."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Spreadsheet Last Updated:  May 28, 2012"]

{"sheet":"Diversion Toll Calculator 365","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"cut":false,"hidden":true,"merged":[[16,1,16,2],[17,1,17,2],[18,1,18,2],[5,2,5,3],[6,2,6,3],[13,3,13,4],[14,5,14,6],[14,1,14,2],[9,2,9,3],[9,5,9,6],[10,2,10,3],[10,5,10,6]]}
[]
["NOTE: ONLY ONE DIVERSION PATH PER WORKSHEET"]
[]
[null,"Enter data only in the green cells"]
[]
[null,"Customer"]
[null,"Invoice #, mmyy"]
[]
[null,null,"Receipt Point",null,null,"Delivery Point"]
[null,"PRIMARY PATH - ","St. Clair",null,"to","Union SWDA"]
[null,"Diversion Path - ","St. Clair",null,"to","Iroquois"]
[]
[]
[null,null,null,"TOLLS ($CDN)"]
[null,"Transportation Path",null,"Monthly Demand","Daily Demand Toll","Description"]
[]
[null,{"$f":"IF(C10<>\"\",IF(F10<>\"\",C10&\" to \"&F10,\"\"),\"\")","v":"St. Clair to Union SWDA"},null,1.8815,{"$f":"ROUND(D17*12/366,5)","v":6.1690000000000002E-2},"Primary Receipt to Primary Delivery"]
[null,{"$f":"IF(C10<>\"\",IF(F11<>\"\",IF(F10<>F11,C10&\" to \"&F11,\"* Not Applicable\"),\"\"),\"\")","v":"St. Clair to Iroquois"},null,15.192819999999999,{"$f":"ROUND(D18*12/366,5)","v":0.49813000000000002},"Primary Receipt to Delivery Diversion"]
[null,{"$f":"IF(C11<>\"\",IF(F10<>\"\",IF(C10<>C11,C11&\" to \"&F10,\"* Not Applicable\"),\"\"),\"\")","v":"* Not Applicable"},null,null,{"$f":"ROUND(D19*12/365,5)","v":0},"Alternate Receipt to Primary Delivery"]
[]
["Commodity charge:"]
["a",3.1480000000000001E-2,"Commodity Toll for:",{"$f":"C11&\" to \"&F11","v":"St. Clair to Iroquois"}]
[]
["Incremental Demand charges:"]
["b",{"$f":"IF(E18>E17,E18-E17,0)","v":0.43643999999999999},{"$f":"\"Calculated incremental Daily Demand Toll for \"&C10&\" to \"&F11&\" if greater than \"&C10&\" to \"&F10","v":"Calculated incremental Daily Demand Toll for St. Clair to Iroquois if greater than St. Clair to Union SWDA"}]
["c",{"$f":"IF(E19>E17,E19-E17,0)","v":0},{"$f":"\"Calculated incremental Daily Demand Toll for \"&C11&\" to \"&F11&\" if greater than \"&C10&\" to \"&F10","v":"Calculated incremental Daily Demand Toll for St. Clair to Iroquois if greater than St. Clair to Union SWDA"}]
["d",{"$f":"B25+B26","v":0.43643999999999999},"Sum of the Daily Demand incremental charges from b and c"]
[]
[{"$f":"\"Invoiced Diversion Toll for \"&C11&\" to \"&F11","v":"Invoiced Diversion Toll for St. Clair to Iroquois"}]
["e",{"$f":"B27+B22","v":0.46792},"Sum of the incremental charges (d) and the Commodity Toll (a) "]
[null,null,"of the Full Diversion Path ($/GJ could be out due to rounding)"]
[]
["*","Paths that are Not Applicable - leave the Monthly Demand Toll blank"]

{"sheet":"Diversion Toll Calculator","index":2,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[15,5,15,6],[15,1,15,2],[10,2,10,3],[10,5,10,6],[11,2,11,3],[11,5,11,6],[17,1,17,2],[18,1,18,2],[19,1,19,2],[5,2,5,3],[14,3,14,4]]}
[]
["NOTE: ONLY ONE DIVERSION PATH PER WORKSHEET"]
[]
[null,"Data required in all green cells"]
[]
[null,"Customer",null,null,"(optional)"]
[null,"Invoice #",null,"(optional)"]
[null,"Year (yyyy)",null,"(do not leave blank)",null,"# of days in yr",{"$f":"IF(Year=2016,365,IF(Year=\"\",0,DATE(Year+1,1,1)-DATE(Year,1,1)))","v":0}]
[]
[]
[null,"PRIMARY PATH - ",null,null,"to"]
[null,"Diversion Path - ",null,null,"to"]
[]
[]
[null,null,null,"TOLLS ($CDN)"]
[null,"Transportation Path",null,"Monthly Demand","Daily Demand Toll","Description"]
[]
[null,{"$f":"IF(C11<>\"\",IF(F11<>\"\",C11&\" to \"&F11,\"\"),\"\")","v":""},null,null,{"$f":"ROUND(D18*(12/$G$8),5)","v":{"$error":"#DIV/0!"}},"Primary Receipt to Primary Delivery"]
[null,{"$f":"IF(C11<>\"\",IF(F12<>\"\",IF(F11<>F12,C11&\" to \"&F12,\"* Not Applicable\"),\"\"),\"\")","v":""},null,null,{"$f":"ROUND(D19*12/$G$8,5)","v":{"$error":"#DIV/0!"}},"Primary Receipt to Delivery Diversion"]
[null,{"$f":"IF(C12<>\"\",IF(F11<>\"\",IF(C11<>C12,C12&\" to \"&F11,\"* Not Applicable\"),\"\"),\"\")","v":""},null,null,{"$f":"ROUND(D20*12/$G$8,5)","v":{"$error":"#DIV/0!"}},"Alternate Receipt to Primary Delivery"]
[]
["Commodity charge:"]
["a",null,"Commodity Toll for:",{"$f":"C12&\" to \"&F12","v":" to "}]
[]
["Incremental Demand charges:"]
["b",{"$f":"IF(E19>E18,E19-E18,0)","v":{"$error":"#DIV/0!"}},{"$f":"\"Calculated incremental Daily Demand Toll for \"&C11&\" to \"&F12&\" if greater than \"&C11&\" to \"&F11","v":"Calculated incremental Daily Demand Toll for  to  if greater than  to "}]
["c",{"$f":"IF(E20>E18,E20-E18,0)","v":{"$error":"#DIV/0!"}},{"$f":"\"Calculated incremental Daily Demand Toll for \"&C12&\" to \"&F12&\" if greater than \"&C11&\" to \"&F11","v":"Calculated incremental Daily Demand Toll for  to  if greater than  to "}]
["d",{"$f":"B26+B27","v":{"$error":"#DIV/0!"}},"Sum of the Daily Demand incremental charges from b and c"]
[]
[{"$f":"\"Invoiced Diversion Toll for \"&C12&\" to \"&F12","v":"Invoiced Diversion Toll for  to "}]
["e",{"$f":"B28+B23","v":{"$error":"#DIV/0!"}},"Sum of the incremental charges (d) and the Commodity Toll (a) "]
[null,null,"of the Full Diversion Path ($/GJ could be out due to rounding)"]
[]
["*","Paths that are Not Applicable - leave the Monthly Demand Toll blank"]

{"sheet":"Instructions","index":3,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["CALCULATING DIVERSION TOLLS ON TRANSCANADA'S CANADIAN MAINLINE."]
[]
[]
[]
["From the Mainline Tariff, Firm Transportation Toll Schedule, Section 6 - Alternate Receipt and Diversion of Gas"]
[null,"6.4 (a)  In addition to the charges payable pursuant to Section 3.1(a) and (c) above (ie. Demand Charge, Commodity Charge and Fuel), Shipper shall pay TransCanada for all Alternate Receipts and Diversions, a charge equal to the aggregate of:"]
[]
[null,"(i)  the product obtained by multiplying the amount, if any, by which the Daily Demand Toll, applicable from the Alternate Receipt point to the delivery point or area specified in Shipper’s Contract, exceeds the applicable Daily Demand Toll from the receipt point to the delivery point or area which are specified in Shipper’s Contract by Shippers Authorized Quantity, and"]
[]
[null,"(ii)  the product obtained by multiplying the amount, if any, by which the Daily Demand Toll, applicable from the receipt point specified in the Shipper’s Contract to the Diversion point, exceeds the applicable Daily Demand Toll from the receipt point to the delivery point or area which are specified in the Shipper’s Contract, by Shippers Authorized Quantity."]
[]
[null,"For more information, see an exerpt from a 2005 Presentation on the next workbook tab"]
[]
[]
["USING THE TEMPLATE TO CALCULATE DIVERSION TOLLS"]
[]
["The green shaded cells indicate that a value is required."]
["Enter Customer name on row 6 (optional)."]
["Enter the invoice number on row 7 (optional)."]
["Enter the year for the invoice on row 8, this is required to correctly calculate the daily demand toll (365 or 366 days in the year)."]
["Enter the Contract primary path receipt point and delivery point on row 11 in the boxes where indicated."]
["Enter the diversion path on row 12 in the boxes where indicated. Use one worksheet per diversion path (duplicate the template)."]
["Transportation Paths (rows 18-20):"]
[null,"The Transportation Paths will automatically populate from the data entered in rows 11 and 12."]
[null,"Where a Transportation Path says * N/A, a Demand Toll is not required to calculate the Diversion toll."]
[null,"Look up the Toll for each applicable path from the published Mainline Tolls in effect during the Billing Period and enter the Monthly Demand Toll in column D."]
["Enter the Commodity charge in row 23 for the path indicated; look up the Toll from the published Mainline Tolls in effect during the Billing Period (a)."]
["The remaining rows are automatic calculations that identify:"]
["b","If the Daily Demand charge for the Contract primary receipt to the delivery diversion point is greater than the Daily Demand charge for the primary receipt to the primary delivery point, the incremental Demand charge is the difference."]
["c","If the Daily Demand charge for the alternate receipt to the Contract primary delivery point is greater than the Daily Demand charge for the primary receipt to the primary delivery point, the incremental Demand charge is the difference."]
["d","The sum of Daily Demand incremental charges."]
["e","The Diversion charge is the sum of the Incremental Demand charge + Commodity charge for the diversion path (a + d)."]
["The Diversion charge should equal the Toll ($/GJ) on the invoice. Note there may be a slight rounding difference."]

{"sheet":"2005 Presentation","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}