{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","Choices","CPI"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":29,"comments":1,"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":"Worksheet","index":0,"n_rows":98,"n_cols":22,"rows_kept":98,"cut":false,"hidden":false,"merged":[[18,6,18,8],[5,4,5,7],[18,3,18,5],[18,9,18,12],[7,5,7,7],[0,15,0,17],[1,15,1,17],[18,13,18,15],[18,16,18,17],[0,9,0,10],[0,11,0,13],[1,11,1,13],[6,9,11,10],[4,9,5,9],[12,9,14,10]]}
[null,null,null,"CGT on Sale of Identical Shares",null,null,null,null,null,null,null,null,null,null,null,"Client Name"]
[null,null,null,"Year Ended 30 June 2016",null,null,null,null,null,null,null,null,null,null,null,"Preparer Name"]
[]
[]
[null,null,null,null,null,null,null,null,null,"IMPORTANT",null,null,"Summary",null,"Indexation","Discount","Other","Total"]
[null,null,null,"Company",null,null,null,null,null,null,null,null,"Quantity Sold",null,{"$f":"Choices!O90","v":0},{"$f":"Choices!S90","v":0},{"$f":"R6-O6-P6","v":0},{"$f":"Sold","v":0},null,null,null,{"$f":"E10","v":0}]
[null,null,null,null,null,null,null,null,1,"From 8 May 2012, foreign or temporary resident individuals must meet certain eligibility conditions to apply the CGT discount.  These calculations assume that the full discount can be claimed.",null,null,"Capital Proceeds",null,{"$f":"SUMPRODUCT(Choices!K15:K89,Choices!O15:O89)","v":0},{"$f":"SUMPRODUCT(Choices!K15:K89,Choices!S15:S89)","v":0},{"$f":"SUMIF(P21:P95,\"<>0\",K21:K95)","v":0},{"$f":"SUM(O7:Q7)","v":0}]
[null,null,null,"Date Sold",null,{"$f":"IF(OR(F10>0,F9>0),\"Reconcile Quantities in Table Below\",IF(Sold>E10,\"Disposals in Table Exceed Quantity Sold\",\"\"))","v":""},null,null,null,null,null,null,"Less Cost Base",null,{"$f":"SUMPRODUCT(Choices!L15:L89,Choices!O15:O89)","v":0},{"$f":"SUMPRODUCT(Choices!P15:P89,Choices!S15:S89)","v":0},{"$f":"SUMIF(P21:P95,\"<>0\",L21:L95)","v":0},{"$f":"SUM(O8:Q8)","v":0}]
[null,null,null,"Proceeds",null,{"$f":"IF(E10>Acquired,E10-Acquired,0)","v":0},{"$f":"IF(Acquired<E10,\"acquisitions still to be shown\",\"\")","v":""},null,null,null,null,null,"Total Capital Gain/(Loss)",null,{"$f":"O7-O8","v":0},{"$f":"P7-P8","v":0},{"$f":"Q7-Q8","v":0},{"$f":"SUM(O9:Q9)","v":0},null,null,null,{"$f":"SUM(N96:P96)","v":0}]
[null,null,null,"Quantity Sold",null,{"$f":"IF(E10>Sold,E10-Sold,0)","v":0},{"$f":"IF(Sold<E10,\"disposals still to be selected\",\"\")","v":""},null,null,null,null,null,"Offset Any Losses",null,{"$f":"IF(Q9<0,MAX(-O9,Q9),0)","v":0},{"$f":"IF(Q9<0,MAX(-P9,Q9-O10),0)","v":0},{"$f":"-O10-P10","v":0},{"$f":"SUM(O10:Q10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O9<>\"                 Error\",O9+O10,0)","v":0},{"$f":"IF(P9<>\"                 Error\",P9+P10,0)","v":0},{"$f":"IF(Q9<>\"                 Error\",Q9+Q10,0)","v":0},{"$f":"R9+R10","v":0}]
[null,null,null,"Capital Losses",null,"Current Year","Prior Year","Total",null,null,null,null,"Less Current Year Losses",null,{"$f":"IF(O11>0,MIN(O11,F13,F13-Q12),0)","v":0},{"$f":"IF(P11>0,MIN(P11,F13-O12-Q12),0)","v":0},{"$f":"IF(AND(F13>0,Q11>0),MIN(Q11,F13),0)","v":0},{"$f":"SUM(O12:Q12)","v":0}]
[null,null,null,"Other Losses Available",null,null,null,{"$f":"SUM(F13:G13)","v":0},2,"Do no leave blank rows when entering data below.  To remove blank rows and sort the table in date order, click this button.",null,null,null,null,{"$f":"O11-O12","v":0},{"$f":"P11-P12","v":0},{"$f":"IF(Q11>0,Q11-Q12,Q11)","v":0},{"$f":"R11-R12","v":0}]
[null,null,null,"Less Losses Recouped",null,{"$f":"SUM(O12:Q12)","v":0},{"$f":"SUM(O14:Q14)","v":0},{"$f":"SUM(F14:G14)","v":0},null,null,null,null,"Less Prior Year Losses",null,{"$f":"IF(O13>0,MIN(O13,G13-Q14),0)","v":0},{"$f":"IF(P13>0,MIN(P13,G13-O14-Q14),0)","v":0},{"$f":"IF(AND(G13>0,Q13>0),MIN(Q13,G13),0)","v":0},{"$f":"SUM(O14:Q14)","v":0}]
[null,null,null,"Sub-Total",null,null,null,{"$f":"H13-H14","v":0},null,null,null,null,null,null,{"$f":"O13-O14","v":0},{"$f":"P13-P14","v":0},{"$f":"IF(Q13>0,Q13-Q14,Q13)","v":0},{"$f":"R13-R14","v":0}]
[null,null,null,"Add Any Losses on These Shares",null,null,null,{"$f":"IF(R17<0,-R17,0)","v":0},null,null,null,null,"Less CGT Discount",null,null,{"$f":"P15/2","v":0},null,{"$f":"SUM(O16:Q16)","v":0}]
[null,null,null,"Net Capital Losses Carried Forward to Later Years",null,null,null,{"$f":"H15+H16","v":0},null,null,null,null,"Net Capital Gain/(Loss)",null,{"$f":"O15","v":0},{"$f":"P15-P16","v":0},{"$f":"Q15","v":0},{"$f":"R15-R16","v":0}]
[]
[null,null,null,"Acquisitions",null,null,"Cost Base Per Share",null,null,"Disposals",null,null,null,"Capital Gains/(Losses)",null,null,"Shares Remaining"]
[null,null,null,"Date","Quantity","Total Cost","Cost","Return of Cap","Cost Base","Quantity","Proceeds","Cost","Indexed Cost","Indexation","Discount","Other","Quantity","Cost"]
[null,null,1,null,null,null,{"$f":"IF(E21>0,F21/E21,0)","v":0},null,{"$f":"G21-H21","v":0},null,{"$f":"IF($E$10>0,$E$9/$E$10*J21,0)","v":0},{"$f":"J21*I21","v":0},{"$f":"IF(AND(D21>0,D21<CpiDate,L21>0),L21*CPI!$F$67/VLOOKUP(Worksheet!D21,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N15","v":0},{"$f":"Choices!R15","v":0},{"$f":"IF(AND(J21>0,OR(K21<L21,$E$8-D21+1<365)),K21-L21,0)","v":0},{"$f":"E21-J21","v":0},{"$f":"IF(E21>0,(Q21*F21/E21)-(Q21*H21),0)","v":0}]
[null,null,{"$f":"C21+1","v":2},null,null,null,0,null,0,null,{"$f":"IF($E$10>0,$E$9/$E$10*J22,0)","v":0},{"$f":"J22*I22","v":0},{"$f":"IF(AND(D22>0,D22<CpiDate,L22>0),L22*CPI!$F$67/VLOOKUP(Worksheet!D22,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N16","v":0},{"$f":"Choices!R16","v":0},0,0,{"$f":"IF(E22>0,(Q22*F22/E22)-(Q22*H22),0)","v":0},null,null,null,{"$f":"IF(OR(D22>0,E22>0,F22>0,J22>0),0,\"Blank\")","v":"Blank"}]
[null,null,{"$f":"C22+1","v":3},null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D23>0,D23<CpiDate,L23>0),L23*CPI!$F$67/VLOOKUP(Worksheet!D23,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N17","v":0},{"$f":"Choices!R17","v":0},0,0,0,null,null,null,"Blank"]
[null,null,4,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D24>0,D24<CpiDate,L24>0),L24*CPI!$F$67/VLOOKUP(Worksheet!D24,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N18","v":0},{"$f":"Choices!R18","v":0},0,0,0,null,null,null,"Blank"]
[null,null,5,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D25>0,D25<CpiDate,L25>0),L25*CPI!$F$67/VLOOKUP(Worksheet!D25,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N19","v":0},{"$f":"Choices!R19","v":0},0,0,0,null,null,null,"Blank"]
[null,null,6,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D26>0,D26<CpiDate,L26>0),L26*CPI!$F$67/VLOOKUP(Worksheet!D26,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N20","v":0},{"$f":"Choices!R20","v":0},0,0,0,null,null,null,"Blank"]
[null,null,7,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D27>0,D27<CpiDate,L27>0),L27*CPI!$F$67/VLOOKUP(Worksheet!D27,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N21","v":0},{"$f":"Choices!R21","v":0},0,0,0,null,null,null,"Blank"]
[null,null,8,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D28>0,D28<CpiDate,L28>0),L28*CPI!$F$67/VLOOKUP(Worksheet!D28,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N22","v":0},{"$f":"Choices!R22","v":0},0,0,0,null,null,null,"Blank"]
[null,null,9,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D29>0,D29<CpiDate,L29>0),L29*CPI!$F$67/VLOOKUP(Worksheet!D29,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N23","v":0},{"$f":"Choices!R23","v":0},0,0,0,null,null,null,"Blank"]
[null,null,10,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D30>0,D30<CpiDate,L30>0),L30*CPI!$F$67/VLOOKUP(Worksheet!D30,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N24","v":0},{"$f":"Choices!R24","v":0},0,0,0,null,null,null,"Blank"]
[null,null,11,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D31>0,D31<CpiDate,L31>0),L31*CPI!$F$67/VLOOKUP(Worksheet!D31,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N25","v":0},{"$f":"Choices!R25","v":0},0,0,0,null,null,null,"Blank"]
[null,null,12,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D32>0,D32<CpiDate,L32>0),L32*CPI!$F$67/VLOOKUP(Worksheet!D32,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N26","v":0},{"$f":"Choices!R26","v":0},0,0,0,null,null,null,"Blank"]
[null,null,13,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D33>0,D33<CpiDate,L33>0),L33*CPI!$F$67/VLOOKUP(Worksheet!D33,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N27","v":0},{"$f":"Choices!R27","v":0},0,0,0,null,null,null,"Blank"]
[null,null,14,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D34>0,D34<CpiDate,L34>0),L34*CPI!$F$67/VLOOKUP(Worksheet!D34,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N28","v":0},{"$f":"Choices!R28","v":0},0,0,0,null,null,null,"Blank"]
[null,null,15,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D35>0,D35<CpiDate,L35>0),L35*CPI!$F$67/VLOOKUP(Worksheet!D35,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N29","v":0},{"$f":"Choices!R29","v":0},0,0,0,null,null,null,"Blank"]
[null,null,16,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D36>0,D36<CpiDate,L36>0),L36*CPI!$F$67/VLOOKUP(Worksheet!D36,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N30","v":0},{"$f":"Choices!R30","v":0},0,0,0,null,null,null,"Blank"]
[null,null,17,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D37>0,D37<CpiDate,L37>0),L37*CPI!$F$67/VLOOKUP(Worksheet!D37,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N31","v":0},{"$f":"Choices!R31","v":0},0,0,0,null,null,null,"Blank"]
[null,null,18,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D38>0,D38<CpiDate,L38>0),L38*CPI!$F$67/VLOOKUP(Worksheet!D38,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N32","v":0},{"$f":"Choices!R32","v":0},0,0,0,null,null,null,"Blank"]
[null,null,19,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D39>0,D39<CpiDate,L39>0),L39*CPI!$F$67/VLOOKUP(Worksheet!D39,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N33","v":0},{"$f":"Choices!R33","v":0},0,0,0,null,null,null,"Blank"]
[null,null,20,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D40>0,D40<CpiDate,L40>0),L40*CPI!$F$67/VLOOKUP(Worksheet!D40,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N34","v":0},{"$f":"Choices!R34","v":0},0,0,0,null,null,null,"Blank"]
[null,null,21,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D41>0,D41<CpiDate,L41>0),L41*CPI!$F$67/VLOOKUP(Worksheet!D41,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N35","v":0},{"$f":"Choices!R35","v":0},0,0,0,null,null,null,"Blank"]
[null,null,22,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D42>0,D42<CpiDate,L42>0),L42*CPI!$F$67/VLOOKUP(Worksheet!D42,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N36","v":0},{"$f":"Choices!R36","v":0},0,0,0,null,null,null,"Blank"]
[null,null,23,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D43>0,D43<CpiDate,L43>0),L43*CPI!$F$67/VLOOKUP(Worksheet!D43,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N37","v":0},{"$f":"Choices!R37","v":0},0,0,0,null,null,null,"Blank"]
[null,null,24,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D44>0,D44<CpiDate,L44>0),L44*CPI!$F$67/VLOOKUP(Worksheet!D44,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N38","v":0},{"$f":"Choices!R38","v":0},0,0,0,null,null,null,"Blank"]
[null,null,25,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D45>0,D45<CpiDate,L45>0),L45*CPI!$F$67/VLOOKUP(Worksheet!D45,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N39","v":0},{"$f":"Choices!R39","v":0},0,0,0,null,null,null,"Blank"]
[null,null,26,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D46>0,D46<CpiDate,L46>0),L46*CPI!$F$67/VLOOKUP(Worksheet!D46,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N40","v":0},{"$f":"Choices!R40","v":0},0,0,0,null,null,null,"Blank"]
[null,null,27,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D47>0,D47<CpiDate,L47>0),L47*CPI!$F$67/VLOOKUP(Worksheet!D47,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N41","v":0},{"$f":"Choices!R41","v":0},0,0,0,null,null,null,"Blank"]
[null,null,28,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D48>0,D48<CpiDate,L48>0),L48*CPI!$F$67/VLOOKUP(Worksheet!D48,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N42","v":0},{"$f":"Choices!R42","v":0},0,0,0,null,null,null,"Blank"]
[null,null,29,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D49>0,D49<CpiDate,L49>0),L49*CPI!$F$67/VLOOKUP(Worksheet!D49,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N43","v":0},{"$f":"Choices!R43","v":0},0,0,0,null,null,null,"Blank"]
[null,null,30,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D50>0,D50<CpiDate,L50>0),L50*CPI!$F$67/VLOOKUP(Worksheet!D50,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N44","v":0},{"$f":"Choices!R44","v":0},0,0,0,null,null,null,"Blank"]
[null,null,31,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D51>0,D51<CpiDate,L51>0),L51*CPI!$F$67/VLOOKUP(Worksheet!D51,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N45","v":0},{"$f":"Choices!R45","v":0},0,0,0,null,null,null,"Blank"]
[null,null,32,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D52>0,D52<CpiDate,L52>0),L52*CPI!$F$67/VLOOKUP(Worksheet!D52,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N46","v":0},{"$f":"Choices!R46","v":0},0,0,0,null,null,null,"Blank"]
[null,null,33,null,null,null,{"$f":"IF(E53>0,F53/E53,0)","v":0},null,{"$f":"G53-H53","v":0},null,0,0,{"$f":"IF(AND(D53>0,D53<CpiDate,L53>0),L53*CPI!$F$67/VLOOKUP(Worksheet!D53,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N47","v":0},{"$f":"Choices!R47","v":0},{"$f":"IF(AND(J53>0,OR(K53<L53,$E$8-D53+1<365)),K53-L53,0)","v":0},{"$f":"E53-J53","v":0},0,null,null,null,"Blank"]
[null,null,34,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D54>0,D54<CpiDate,L54>0),L54*CPI!$F$67/VLOOKUP(Worksheet!D54,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N48","v":0},{"$f":"Choices!R48","v":0},0,0,0,null,null,null,{"$f":"IF(OR(D54>0,E54>0,F54>0,J54>0),0,\"Blank\")","v":"Blank"}]
[null,null,35,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D55>0,D55<CpiDate,L55>0),L55*CPI!$F$67/VLOOKUP(Worksheet!D55,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N49","v":0},{"$f":"Choices!R49","v":0},0,0,0,null,null,null,"Blank"]
[null,null,36,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D56>0,D56<CpiDate,L56>0),L56*CPI!$F$67/VLOOKUP(Worksheet!D56,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N50","v":0},{"$f":"Choices!R50","v":0},0,0,0,null,null,null,"Blank"]
[null,null,37,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D57>0,D57<CpiDate,L57>0),L57*CPI!$F$67/VLOOKUP(Worksheet!D57,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N51","v":0},{"$f":"Choices!R51","v":0},0,0,0,null,null,null,"Blank"]
[null,null,38,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D58>0,D58<CpiDate,L58>0),L58*CPI!$F$67/VLOOKUP(Worksheet!D58,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N52","v":0},{"$f":"Choices!R52","v":0},0,0,0,null,null,null,"Blank"]
[null,null,39,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D59>0,D59<CpiDate,L59>0),L59*CPI!$F$67/VLOOKUP(Worksheet!D59,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N53","v":0},{"$f":"Choices!R53","v":0},0,0,0,null,null,null,"Blank"]
[null,null,40,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D60>0,D60<CpiDate,L60>0),L60*CPI!$F$67/VLOOKUP(Worksheet!D60,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N54","v":0},{"$f":"Choices!R54","v":0},0,0,0,null,null,null,"Blank"]
[null,null,41,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D61>0,D61<CpiDate,L61>0),L61*CPI!$F$67/VLOOKUP(Worksheet!D61,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N55","v":0},{"$f":"Choices!R55","v":0},0,0,0,null,null,null,"Blank"]
[null,null,42,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D62>0,D62<CpiDate,L62>0),L62*CPI!$F$67/VLOOKUP(Worksheet!D62,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N56","v":0},{"$f":"Choices!R56","v":0},0,0,0,null,null,null,"Blank"]
[null,null,43,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D63>0,D63<CpiDate,L63>0),L63*CPI!$F$67/VLOOKUP(Worksheet!D63,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N57","v":0},{"$f":"Choices!R57","v":0},0,0,0,null,null,null,"Blank"]
[null,null,44,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D64>0,D64<CpiDate,L64>0),L64*CPI!$F$67/VLOOKUP(Worksheet!D64,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N58","v":0},{"$f":"Choices!R58","v":0},0,0,0,null,null,null,"Blank"]
[null,null,45,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D65>0,D65<CpiDate,L65>0),L65*CPI!$F$67/VLOOKUP(Worksheet!D65,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N59","v":0},{"$f":"Choices!R59","v":0},0,0,0,null,null,null,"Blank"]
[null,null,46,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D66>0,D66<CpiDate,L66>0),L66*CPI!$F$67/VLOOKUP(Worksheet!D66,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N60","v":0},{"$f":"Choices!R60","v":0},0,0,0,null,null,null,"Blank"]
[null,null,47,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D67>0,D67<CpiDate,L67>0),L67*CPI!$F$67/VLOOKUP(Worksheet!D67,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N61","v":0},{"$f":"Choices!R61","v":0},0,0,0,null,null,null,"Blank"]
[null,null,48,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D68>0,D68<CpiDate,L68>0),L68*CPI!$F$67/VLOOKUP(Worksheet!D68,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N62","v":0},{"$f":"Choices!R62","v":0},0,0,0,null,null,null,"Blank"]
[null,null,49,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D69>0,D69<CpiDate,L69>0),L69*CPI!$F$67/VLOOKUP(Worksheet!D69,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N63","v":0},{"$f":"Choices!R63","v":0},0,0,0,null,null,null,"Blank"]
[null,null,50,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D70>0,D70<CpiDate,L70>0),L70*CPI!$F$67/VLOOKUP(Worksheet!D70,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N64","v":0},{"$f":"Choices!R64","v":0},0,0,0,null,null,null,"Blank"]
[null,null,51,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D71>0,D71<CpiDate,L71>0),L71*CPI!$F$67/VLOOKUP(Worksheet!D71,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N65","v":0},{"$f":"Choices!R65","v":0},0,0,0,null,null,null,"Blank"]
[null,null,52,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D72>0,D72<CpiDate,L72>0),L72*CPI!$F$67/VLOOKUP(Worksheet!D72,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N66","v":0},{"$f":"Choices!R66","v":0},0,0,0,null,null,null,"Blank"]
[null,null,53,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D73>0,D73<CpiDate,L73>0),L73*CPI!$F$67/VLOOKUP(Worksheet!D73,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N67","v":0},{"$f":"Choices!R67","v":0},0,0,0,null,null,null,"Blank"]
[null,null,54,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D74>0,D74<CpiDate,L74>0),L74*CPI!$F$67/VLOOKUP(Worksheet!D74,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N68","v":0},{"$f":"Choices!R68","v":0},0,0,0,null,null,null,"Blank"]
[null,null,55,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D75>0,D75<CpiDate,L75>0),L75*CPI!$F$67/VLOOKUP(Worksheet!D75,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N69","v":0},{"$f":"Choices!R69","v":0},0,0,0,null,null,null,"Blank"]
[null,null,56,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D76>0,D76<CpiDate,L76>0),L76*CPI!$F$67/VLOOKUP(Worksheet!D76,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N70","v":0},{"$f":"Choices!R70","v":0},0,0,0,null,null,null,"Blank"]
[null,null,57,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D77>0,D77<CpiDate,L77>0),L77*CPI!$F$67/VLOOKUP(Worksheet!D77,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N71","v":0},{"$f":"Choices!R71","v":0},0,0,0,null,null,null,"Blank"]
[null,null,58,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D78>0,D78<CpiDate,L78>0),L78*CPI!$F$67/VLOOKUP(Worksheet!D78,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N72","v":0},{"$f":"Choices!R72","v":0},0,0,0,null,null,null,"Blank"]
[null,null,59,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D79>0,D79<CpiDate,L79>0),L79*CPI!$F$67/VLOOKUP(Worksheet!D79,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N73","v":0},{"$f":"Choices!R73","v":0},0,0,0,null,null,null,"Blank"]
[null,null,60,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D80>0,D80<CpiDate,L80>0),L80*CPI!$F$67/VLOOKUP(Worksheet!D80,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N74","v":0},{"$f":"Choices!R74","v":0},0,0,0,null,null,null,"Blank"]
[null,null,61,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D81>0,D81<CpiDate,L81>0),L81*CPI!$F$67/VLOOKUP(Worksheet!D81,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N75","v":0},{"$f":"Choices!R75","v":0},0,0,0,null,null,null,"Blank"]
[null,null,62,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D82>0,D82<CpiDate,L82>0),L82*CPI!$F$67/VLOOKUP(Worksheet!D82,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N76","v":0},{"$f":"Choices!R76","v":0},0,0,0,null,null,null,"Blank"]
[null,null,63,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D83>0,D83<CpiDate,L83>0),L83*CPI!$F$67/VLOOKUP(Worksheet!D83,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N77","v":0},{"$f":"Choices!R77","v":0},0,0,0,null,null,null,"Blank"]
[null,null,64,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D84>0,D84<CpiDate,L84>0),L84*CPI!$F$67/VLOOKUP(Worksheet!D84,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N78","v":0},{"$f":"Choices!R78","v":0},0,0,0,null,null,null,"Blank"]
[null,null,65,null,null,null,{"$f":"IF(E85>0,F85/E85,0)","v":0},null,{"$f":"G85-H85","v":0},null,0,0,{"$f":"IF(AND(D85>0,D85<CpiDate,L85>0),L85*CPI!$F$67/VLOOKUP(Worksheet!D85,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N79","v":0},{"$f":"Choices!R79","v":0},{"$f":"IF(AND(J85>0,OR(K85<L85,$E$8-D85+1<365)),K85-L85,0)","v":0},{"$f":"E85-J85","v":0},0,null,null,null,"Blank"]
[null,null,66,null,null,null,0,null,0,null,{"$f":"IF($E$10>0,$E$9/$E$10*J86,0)","v":0},{"$f":"J86*I86","v":0},{"$f":"IF(AND(D86>0,D86<CpiDate,L86>0),L86*CPI!$F$67/VLOOKUP(Worksheet!D86,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N80","v":0},{"$f":"Choices!R80","v":0},0,0,{"$f":"IF(E86>0,(Q86*F86/E86)-(Q86*H86),0)","v":0},null,null,null,{"$f":"IF(OR(D86>0,E86>0,F86>0,J86>0),0,\"Blank\")","v":"Blank"}]
[null,null,{"$f":"C86+1","v":67},null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D87>0,D87<CpiDate,L87>0),L87*CPI!$F$67/VLOOKUP(Worksheet!D87,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N81","v":0},{"$f":"Choices!R81","v":0},0,0,0,null,null,null,"Blank"]
[null,null,68,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D88>0,D88<CpiDate,L88>0),L88*CPI!$F$67/VLOOKUP(Worksheet!D88,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N82","v":0},{"$f":"Choices!R82","v":0},0,0,0,null,null,null,"Blank"]
[null,null,69,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D89>0,D89<CpiDate,L89>0),L89*CPI!$F$67/VLOOKUP(Worksheet!D89,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N83","v":0},{"$f":"Choices!R83","v":0},0,0,0,null,null,null,"Blank"]
[null,null,70,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D90>0,D90<CpiDate,L90>0),L90*CPI!$F$67/VLOOKUP(Worksheet!D90,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N84","v":0},{"$f":"Choices!R84","v":0},0,0,0,null,null,null,"Blank"]
[null,null,71,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D91>0,D91<CpiDate,L91>0),L91*CPI!$F$67/VLOOKUP(Worksheet!D91,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N85","v":0},{"$f":"Choices!R85","v":0},0,0,0,null,null,null,"Blank"]
[null,null,72,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D92>0,D92<CpiDate,L92>0),L92*CPI!$F$67/VLOOKUP(Worksheet!D92,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N86","v":0},{"$f":"Choices!R86","v":0},0,0,0,null,null,null,"Blank"]
[null,null,73,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D93>0,D93<CpiDate,L93>0),L93*CPI!$F$67/VLOOKUP(Worksheet!D93,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N87","v":0},{"$f":"Choices!R87","v":0},0,0,0,null,null,null,"Blank"]
[null,null,74,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D94>0,D94<CpiDate,L94>0),L94*CPI!$F$67/VLOOKUP(Worksheet!D94,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N88","v":0},{"$f":"Choices!R88","v":0},0,0,0,null,null,null,"Blank"]
[null,null,75,null,null,null,0,null,0,null,0,0,{"$f":"IF(AND(D95>0,D95<CpiDate,L95>0),L95*CPI!$F$67/VLOOKUP(Worksheet!D95,Cpi,3,TRUE),0)","v":0},{"$f":"Choices!N89","v":0},{"$f":"Choices!R89","v":0},0,0,0]
[null,null,null,null,{"$f":"SUM(E21:E95)","v":0},{"$f":"SUM(F21:F95)","v":0},null,null,null,{"$f":"SUM(J21:J95)","v":0},{"$f":"SUM(K21:K95)","v":0},{"$f":"SUM(L21:L95)","v":0},{"$f":"SUM(M21:M95)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(D98>0,E98>0,F98>0,K98>0),\"\",\"Blank\")","v":"Blank"}]

{"sheet":"Choices","index":1,"n_rows":91,"n_cols":23,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,11,0,12],[0,13,0,14],[0,16,0,18],[1,13,1,14],[1,16,1,18],[5,10,10,10],[5,3,6,5],[5,11,10,18],[12,3,12,5],[12,6,12,7],[12,8,12,9],[12,11,12,14],[12,15,12,18]]}
[null,null,null,"CGT on Sale of Identical Shares - Choice of Method Report",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worksheet!P1","v":"Client Name"},null,null,null,null,null,"HIDE"]
[null,null,null,{"$f":"Worksheet!D2","v":"Year Ended 30 June 2016"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Worksheet!P2","v":"Preparer Name"}]
[]
[]
[]
[null,null,null,"Choice of Method Report",null,null,null,null,null,null,"CHOICE","Order of Deducting Capital Losess\nCapital losses are deducted firstly from capital gains made within 12 months, then from gains using the indexation method and lastly from discounted capital gains.\n\nChoice of Indexation or Discount Methods\nAfter all capital losses have been accounted for, the worksheet will then choose either the Indexation Method or Discount Method depending on which method gives the greater benefit (lower gain). "]
[]
[]
[]
[]
[]
[]
[null,null,null,"Capital Losses to Absorb Indexation",null,null,"Share Details",null,"Methods Available",null,"Proceeds","Indexation Method",null,null,null,"Discount Method"]
[null,null,null,"B/F","Used","C/F","Date Acq","Qty Sold","Indexation","Discount","Per Share","Cost/Share","Gain/Share","Cap Gain","Qty","Cost/Share","Gain/Share","Cap Gain","Qty"]
[null,null,null,{"$f":"Worksheet!H13+IF(Worksheet!Q9<0,-Worksheet!Q9,0)","v":0},{"$f":"IF(D15>0,MIN(D15,N15),0)","v":0},{"$f":"D15-E15","v":0},{"$f":"Worksheet!D21","v":"00:00:00"},{"$f":"Worksheet!J21","v":0},{"$f":"IF(AND(Worksheet!D21>0,Worksheet!D21<CpiDate,Worksheet!K21>Worksheet!M21,Worksheet!$E$8-Worksheet!D21+1>365),\"Yes\",IF(Worksheet!D21>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D21>0,Worksheet!$E$8-Worksheet!D21+1>365,Worksheet!K21>Worksheet!L21),\"Yes\",IF(Worksheet!D21>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J21>0,Worksheet!K21/Worksheet!J21,0)","v":0},{"$f":"IF(AND(I15=\"Yes\",Worksheet!J21>0),Worksheet!M21/Worksheet!J21,0)","v":0},{"$f":"IF(I15=\"Yes\",K15-L15,0)","v":0},{"$f":"IF(AND(I15=\"Yes\",M15<Q15/2),M15*H15,IF(AND(I15=\"Yes\",D15>0),MIN(D15,M15*H15),0))","v":0},{"$f":"IF(M15>0,N15/M15,0)","v":0},{"$f":"IF(AND(J15=\"Yes\",Worksheet!E21>0),(Worksheet!F21/Worksheet!E21)-Worksheet!H21,0)","v":0},{"$f":"IF(J15=\"Yes\",K15-P15,0)","v":0},{"$f":"S15*Q15","v":0},{"$f":"IF(J15=\"Yes\",H15-O15,0)","v":0}]
[null,null,null,{"$f":"IF(H16>0,F15,0)","v":0},{"$f":"IF(D16>0,MIN(D16,N16),0)","v":0},{"$f":"D16-E16","v":0},{"$f":"Worksheet!D22","v":"00:00:00"},{"$f":"Worksheet!J22","v":0},{"$f":"IF(AND(Worksheet!D22>0,Worksheet!D22<CpiDate,Worksheet!K22>Worksheet!M22,Worksheet!$E$8-Worksheet!D22+1>365),\"Yes\",IF(Worksheet!D22>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D22>0,Worksheet!$E$8-Worksheet!D22+1>365,Worksheet!K22>Worksheet!L22),\"Yes\",IF(Worksheet!D22>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J22>0,Worksheet!K22/Worksheet!J22,0)","v":0},{"$f":"IF(AND(I16=\"Yes\",Worksheet!J22>0),Worksheet!M22/Worksheet!J22,0)","v":0},{"$f":"IF(I16=\"Yes\",K16-L16,0)","v":0},{"$f":"IF(AND(I16=\"Yes\",M16<Q16/2),M16*H16,IF(AND(I16=\"Yes\",D16>0),MIN(D16,M16*H16),0))","v":0},{"$f":"IF(M16>0,N16/M16,0)","v":0},{"$f":"IF(AND(J16=\"Yes\",Worksheet!E22>0),(Worksheet!F22/Worksheet!E22)-Worksheet!H22,0)","v":0},{"$f":"IF(J16=\"Yes\",K16-P16,0)","v":0},{"$f":"S16*Q16","v":0},{"$f":"IF(J16=\"Yes\",H16-O16,0)","v":0},null,null,null,{"$f":"IF(OR(G16>0,H16>0),0,\"Blank\")","v":"Blank"}]
[null,null,null,{"$f":"IF(H17>0,F16,0)","v":0},0,0,{"$f":"Worksheet!D23","v":"00:00:00"},{"$f":"Worksheet!J23","v":0},{"$f":"IF(AND(Worksheet!D23>0,Worksheet!D23<CpiDate,Worksheet!K23>Worksheet!M23,Worksheet!$E$8-Worksheet!D23+1>365),\"Yes\",IF(Worksheet!D23>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D23>0,Worksheet!$E$8-Worksheet!D23+1>365,Worksheet!K23>Worksheet!L23),\"Yes\",IF(Worksheet!D23>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J23>0,Worksheet!K23/Worksheet!J23,0)","v":0},{"$f":"IF(AND(I17=\"Yes\",Worksheet!J23>0),Worksheet!M23/Worksheet!J23,0)","v":0},0,0,0,{"$f":"IF(AND(J17=\"Yes\",Worksheet!E23>0),(Worksheet!F23/Worksheet!E23)-Worksheet!H23,0)","v":0},0,0,0,null,null,null,{"$f":"IF(OR(G17>0,H17>0),0,\"Blank\")","v":"Blank"}]
[null,null,null,0,0,0,{"$f":"Worksheet!D24","v":"00:00:00"},{"$f":"Worksheet!J24","v":0},{"$f":"IF(AND(Worksheet!D24>0,Worksheet!D24<CpiDate,Worksheet!K24>Worksheet!M24,Worksheet!$E$8-Worksheet!D24+1>365),\"Yes\",IF(Worksheet!D24>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D24>0,Worksheet!$E$8-Worksheet!D24+1>365,Worksheet!K24>Worksheet!L24),\"Yes\",IF(Worksheet!D24>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J24>0,Worksheet!K24/Worksheet!J24,0)","v":0},{"$f":"IF(AND(I18=\"Yes\",Worksheet!J24>0),Worksheet!M24/Worksheet!J24,0)","v":0},0,0,0,{"$f":"IF(AND(J18=\"Yes\",Worksheet!E24>0),(Worksheet!F24/Worksheet!E24)-Worksheet!H24,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D25","v":"00:00:00"},{"$f":"Worksheet!J25","v":0},{"$f":"IF(AND(Worksheet!D25>0,Worksheet!D25<CpiDate,Worksheet!K25>Worksheet!M25,Worksheet!$E$8-Worksheet!D25+1>365),\"Yes\",IF(Worksheet!D25>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D25>0,Worksheet!$E$8-Worksheet!D25+1>365,Worksheet!K25>Worksheet!L25),\"Yes\",IF(Worksheet!D25>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J25>0,Worksheet!K25/Worksheet!J25,0)","v":0},{"$f":"IF(AND(I19=\"Yes\",Worksheet!J25>0),Worksheet!M25/Worksheet!J25,0)","v":0},0,0,0,{"$f":"IF(AND(J19=\"Yes\",Worksheet!E25>0),(Worksheet!F25/Worksheet!E25)-Worksheet!H25,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D26","v":"00:00:00"},{"$f":"Worksheet!J26","v":0},{"$f":"IF(AND(Worksheet!D26>0,Worksheet!D26<CpiDate,Worksheet!K26>Worksheet!M26,Worksheet!$E$8-Worksheet!D26+1>365),\"Yes\",IF(Worksheet!D26>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D26>0,Worksheet!$E$8-Worksheet!D26+1>365,Worksheet!K26>Worksheet!L26),\"Yes\",IF(Worksheet!D26>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J26>0,Worksheet!K26/Worksheet!J26,0)","v":0},{"$f":"IF(AND(I20=\"Yes\",Worksheet!J26>0),Worksheet!M26/Worksheet!J26,0)","v":0},0,0,0,{"$f":"IF(AND(J20=\"Yes\",Worksheet!E26>0),(Worksheet!F26/Worksheet!E26)-Worksheet!H26,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D27","v":"00:00:00"},{"$f":"Worksheet!J27","v":0},{"$f":"IF(AND(Worksheet!D27>0,Worksheet!D27<CpiDate,Worksheet!K27>Worksheet!M27,Worksheet!$E$8-Worksheet!D27+1>365),\"Yes\",IF(Worksheet!D27>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D27>0,Worksheet!$E$8-Worksheet!D27+1>365,Worksheet!K27>Worksheet!L27),\"Yes\",IF(Worksheet!D27>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J27>0,Worksheet!K27/Worksheet!J27,0)","v":0},{"$f":"IF(AND(I21=\"Yes\",Worksheet!J27>0),Worksheet!M27/Worksheet!J27,0)","v":0},0,0,0,{"$f":"IF(AND(J21=\"Yes\",Worksheet!E27>0),(Worksheet!F27/Worksheet!E27)-Worksheet!H27,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D28","v":"00:00:00"},{"$f":"Worksheet!J28","v":0},{"$f":"IF(AND(Worksheet!D28>0,Worksheet!D28<CpiDate,Worksheet!K28>Worksheet!M28,Worksheet!$E$8-Worksheet!D28+1>365),\"Yes\",IF(Worksheet!D28>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D28>0,Worksheet!$E$8-Worksheet!D28+1>365,Worksheet!K28>Worksheet!L28),\"Yes\",IF(Worksheet!D28>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J28>0,Worksheet!K28/Worksheet!J28,0)","v":0},{"$f":"IF(AND(I22=\"Yes\",Worksheet!J28>0),Worksheet!M28/Worksheet!J28,0)","v":0},0,0,0,{"$f":"IF(AND(J22=\"Yes\",Worksheet!E28>0),(Worksheet!F28/Worksheet!E28)-Worksheet!H28,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D29","v":"00:00:00"},{"$f":"Worksheet!J29","v":0},{"$f":"IF(AND(Worksheet!D29>0,Worksheet!D29<CpiDate,Worksheet!K29>Worksheet!M29,Worksheet!$E$8-Worksheet!D29+1>365),\"Yes\",IF(Worksheet!D29>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D29>0,Worksheet!$E$8-Worksheet!D29+1>365,Worksheet!K29>Worksheet!L29),\"Yes\",IF(Worksheet!D29>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J29>0,Worksheet!K29/Worksheet!J29,0)","v":0},{"$f":"IF(AND(I23=\"Yes\",Worksheet!J29>0),Worksheet!M29/Worksheet!J29,0)","v":0},0,0,0,{"$f":"IF(AND(J23=\"Yes\",Worksheet!E29>0),(Worksheet!F29/Worksheet!E29)-Worksheet!H29,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D30","v":"00:00:00"},{"$f":"Worksheet!J30","v":0},{"$f":"IF(AND(Worksheet!D30>0,Worksheet!D30<CpiDate,Worksheet!K30>Worksheet!M30,Worksheet!$E$8-Worksheet!D30+1>365),\"Yes\",IF(Worksheet!D30>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D30>0,Worksheet!$E$8-Worksheet!D30+1>365,Worksheet!K30>Worksheet!L30),\"Yes\",IF(Worksheet!D30>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J30>0,Worksheet!K30/Worksheet!J30,0)","v":0},{"$f":"IF(AND(I24=\"Yes\",Worksheet!J30>0),Worksheet!M30/Worksheet!J30,0)","v":0},0,0,0,{"$f":"IF(AND(J24=\"Yes\",Worksheet!E30>0),(Worksheet!F30/Worksheet!E30)-Worksheet!H30,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D31","v":"00:00:00"},{"$f":"Worksheet!J31","v":0},{"$f":"IF(AND(Worksheet!D31>0,Worksheet!D31<CpiDate,Worksheet!K31>Worksheet!M31,Worksheet!$E$8-Worksheet!D31+1>365),\"Yes\",IF(Worksheet!D31>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D31>0,Worksheet!$E$8-Worksheet!D31+1>365,Worksheet!K31>Worksheet!L31),\"Yes\",IF(Worksheet!D31>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J31>0,Worksheet!K31/Worksheet!J31,0)","v":0},{"$f":"IF(AND(I25=\"Yes\",Worksheet!J31>0),Worksheet!M31/Worksheet!J31,0)","v":0},0,0,0,{"$f":"IF(AND(J25=\"Yes\",Worksheet!E31>0),(Worksheet!F31/Worksheet!E31)-Worksheet!H31,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D32","v":"00:00:00"},{"$f":"Worksheet!J32","v":0},{"$f":"IF(AND(Worksheet!D32>0,Worksheet!D32<CpiDate,Worksheet!K32>Worksheet!M32,Worksheet!$E$8-Worksheet!D32+1>365),\"Yes\",IF(Worksheet!D32>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D32>0,Worksheet!$E$8-Worksheet!D32+1>365,Worksheet!K32>Worksheet!L32),\"Yes\",IF(Worksheet!D32>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J32>0,Worksheet!K32/Worksheet!J32,0)","v":0},{"$f":"IF(AND(I26=\"Yes\",Worksheet!J32>0),Worksheet!M32/Worksheet!J32,0)","v":0},0,0,0,{"$f":"IF(AND(J26=\"Yes\",Worksheet!E32>0),(Worksheet!F32/Worksheet!E32)-Worksheet!H32,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D33","v":"00:00:00"},{"$f":"Worksheet!J33","v":0},{"$f":"IF(AND(Worksheet!D33>0,Worksheet!D33<CpiDate,Worksheet!K33>Worksheet!M33,Worksheet!$E$8-Worksheet!D33+1>365),\"Yes\",IF(Worksheet!D33>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D33>0,Worksheet!$E$8-Worksheet!D33+1>365,Worksheet!K33>Worksheet!L33),\"Yes\",IF(Worksheet!D33>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J33>0,Worksheet!K33/Worksheet!J33,0)","v":0},{"$f":"IF(AND(I27=\"Yes\",Worksheet!J33>0),Worksheet!M33/Worksheet!J33,0)","v":0},0,0,0,{"$f":"IF(AND(J27=\"Yes\",Worksheet!E33>0),(Worksheet!F33/Worksheet!E33)-Worksheet!H33,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D34","v":"00:00:00"},{"$f":"Worksheet!J34","v":0},{"$f":"IF(AND(Worksheet!D34>0,Worksheet!D34<CpiDate,Worksheet!K34>Worksheet!M34,Worksheet!$E$8-Worksheet!D34+1>365),\"Yes\",IF(Worksheet!D34>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D34>0,Worksheet!$E$8-Worksheet!D34+1>365,Worksheet!K34>Worksheet!L34),\"Yes\",IF(Worksheet!D34>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J34>0,Worksheet!K34/Worksheet!J34,0)","v":0},{"$f":"IF(AND(I28=\"Yes\",Worksheet!J34>0),Worksheet!M34/Worksheet!J34,0)","v":0},0,0,0,{"$f":"IF(AND(J28=\"Yes\",Worksheet!E34>0),(Worksheet!F34/Worksheet!E34)-Worksheet!H34,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D35","v":"00:00:00"},{"$f":"Worksheet!J35","v":0},{"$f":"IF(AND(Worksheet!D35>0,Worksheet!D35<CpiDate,Worksheet!K35>Worksheet!M35,Worksheet!$E$8-Worksheet!D35+1>365),\"Yes\",IF(Worksheet!D35>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D35>0,Worksheet!$E$8-Worksheet!D35+1>365,Worksheet!K35>Worksheet!L35),\"Yes\",IF(Worksheet!D35>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J35>0,Worksheet!K35/Worksheet!J35,0)","v":0},{"$f":"IF(AND(I29=\"Yes\",Worksheet!J35>0),Worksheet!M35/Worksheet!J35,0)","v":0},0,0,0,{"$f":"IF(AND(J29=\"Yes\",Worksheet!E35>0),(Worksheet!F35/Worksheet!E35)-Worksheet!H35,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D36","v":"00:00:00"},{"$f":"Worksheet!J36","v":0},{"$f":"IF(AND(Worksheet!D36>0,Worksheet!D36<CpiDate,Worksheet!K36>Worksheet!M36,Worksheet!$E$8-Worksheet!D36+1>365),\"Yes\",IF(Worksheet!D36>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D36>0,Worksheet!$E$8-Worksheet!D36+1>365,Worksheet!K36>Worksheet!L36),\"Yes\",IF(Worksheet!D36>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J36>0,Worksheet!K36/Worksheet!J36,0)","v":0},{"$f":"IF(AND(I30=\"Yes\",Worksheet!J36>0),Worksheet!M36/Worksheet!J36,0)","v":0},0,0,0,{"$f":"IF(AND(J30=\"Yes\",Worksheet!E36>0),(Worksheet!F36/Worksheet!E36)-Worksheet!H36,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D37","v":"00:00:00"},{"$f":"Worksheet!J37","v":0},{"$f":"IF(AND(Worksheet!D37>0,Worksheet!D37<CpiDate,Worksheet!K37>Worksheet!M37,Worksheet!$E$8-Worksheet!D37+1>365),\"Yes\",IF(Worksheet!D37>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D37>0,Worksheet!$E$8-Worksheet!D37+1>365,Worksheet!K37>Worksheet!L37),\"Yes\",IF(Worksheet!D37>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J37>0,Worksheet!K37/Worksheet!J37,0)","v":0},{"$f":"IF(AND(I31=\"Yes\",Worksheet!J37>0),Worksheet!M37/Worksheet!J37,0)","v":0},0,0,0,{"$f":"IF(AND(J31=\"Yes\",Worksheet!E37>0),(Worksheet!F37/Worksheet!E37)-Worksheet!H37,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D38","v":"00:00:00"},{"$f":"Worksheet!J38","v":0},{"$f":"IF(AND(Worksheet!D38>0,Worksheet!D38<CpiDate,Worksheet!K38>Worksheet!M38,Worksheet!$E$8-Worksheet!D38+1>365),\"Yes\",IF(Worksheet!D38>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D38>0,Worksheet!$E$8-Worksheet!D38+1>365,Worksheet!K38>Worksheet!L38),\"Yes\",IF(Worksheet!D38>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J38>0,Worksheet!K38/Worksheet!J38,0)","v":0},{"$f":"IF(AND(I32=\"Yes\",Worksheet!J38>0),Worksheet!M38/Worksheet!J38,0)","v":0},0,0,0,{"$f":"IF(AND(J32=\"Yes\",Worksheet!E38>0),(Worksheet!F38/Worksheet!E38)-Worksheet!H38,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D39","v":"00:00:00"},{"$f":"Worksheet!J39","v":0},{"$f":"IF(AND(Worksheet!D39>0,Worksheet!D39<CpiDate,Worksheet!K39>Worksheet!M39,Worksheet!$E$8-Worksheet!D39+1>365),\"Yes\",IF(Worksheet!D39>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D39>0,Worksheet!$E$8-Worksheet!D39+1>365,Worksheet!K39>Worksheet!L39),\"Yes\",IF(Worksheet!D39>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J39>0,Worksheet!K39/Worksheet!J39,0)","v":0},{"$f":"IF(AND(I33=\"Yes\",Worksheet!J39>0),Worksheet!M39/Worksheet!J39,0)","v":0},0,0,0,{"$f":"IF(AND(J33=\"Yes\",Worksheet!E39>0),(Worksheet!F39/Worksheet!E39)-Worksheet!H39,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D40","v":"00:00:00"},{"$f":"Worksheet!J40","v":0},{"$f":"IF(AND(Worksheet!D40>0,Worksheet!D40<CpiDate,Worksheet!K40>Worksheet!M40,Worksheet!$E$8-Worksheet!D40+1>365),\"Yes\",IF(Worksheet!D40>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D40>0,Worksheet!$E$8-Worksheet!D40+1>365,Worksheet!K40>Worksheet!L40),\"Yes\",IF(Worksheet!D40>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J40>0,Worksheet!K40/Worksheet!J40,0)","v":0},{"$f":"IF(AND(I34=\"Yes\",Worksheet!J40>0),Worksheet!M40/Worksheet!J40,0)","v":0},0,0,0,{"$f":"IF(AND(J34=\"Yes\",Worksheet!E40>0),(Worksheet!F40/Worksheet!E40)-Worksheet!H40,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D41","v":"00:00:00"},{"$f":"Worksheet!J41","v":0},{"$f":"IF(AND(Worksheet!D41>0,Worksheet!D41<CpiDate,Worksheet!K41>Worksheet!M41,Worksheet!$E$8-Worksheet!D41+1>365),\"Yes\",IF(Worksheet!D41>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D41>0,Worksheet!$E$8-Worksheet!D41+1>365,Worksheet!K41>Worksheet!L41),\"Yes\",IF(Worksheet!D41>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J41>0,Worksheet!K41/Worksheet!J41,0)","v":0},{"$f":"IF(AND(I35=\"Yes\",Worksheet!J41>0),Worksheet!M41/Worksheet!J41,0)","v":0},0,0,0,{"$f":"IF(AND(J35=\"Yes\",Worksheet!E41>0),(Worksheet!F41/Worksheet!E41)-Worksheet!H41,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D42","v":"00:00:00"},{"$f":"Worksheet!J42","v":0},{"$f":"IF(AND(Worksheet!D42>0,Worksheet!D42<CpiDate,Worksheet!K42>Worksheet!M42,Worksheet!$E$8-Worksheet!D42+1>365),\"Yes\",IF(Worksheet!D42>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D42>0,Worksheet!$E$8-Worksheet!D42+1>365,Worksheet!K42>Worksheet!L42),\"Yes\",IF(Worksheet!D42>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J42>0,Worksheet!K42/Worksheet!J42,0)","v":0},{"$f":"IF(AND(I36=\"Yes\",Worksheet!J42>0),Worksheet!M42/Worksheet!J42,0)","v":0},0,0,0,{"$f":"IF(AND(J36=\"Yes\",Worksheet!E42>0),(Worksheet!F42/Worksheet!E42)-Worksheet!H42,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D43","v":"00:00:00"},{"$f":"Worksheet!J43","v":0},{"$f":"IF(AND(Worksheet!D43>0,Worksheet!D43<CpiDate,Worksheet!K43>Worksheet!M43,Worksheet!$E$8-Worksheet!D43+1>365),\"Yes\",IF(Worksheet!D43>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D43>0,Worksheet!$E$8-Worksheet!D43+1>365,Worksheet!K43>Worksheet!L43),\"Yes\",IF(Worksheet!D43>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J43>0,Worksheet!K43/Worksheet!J43,0)","v":0},{"$f":"IF(AND(I37=\"Yes\",Worksheet!J43>0),Worksheet!M43/Worksheet!J43,0)","v":0},0,0,0,{"$f":"IF(AND(J37=\"Yes\",Worksheet!E43>0),(Worksheet!F43/Worksheet!E43)-Worksheet!H43,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D44","v":"00:00:00"},{"$f":"Worksheet!J44","v":0},{"$f":"IF(AND(Worksheet!D44>0,Worksheet!D44<CpiDate,Worksheet!K44>Worksheet!M44,Worksheet!$E$8-Worksheet!D44+1>365),\"Yes\",IF(Worksheet!D44>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D44>0,Worksheet!$E$8-Worksheet!D44+1>365,Worksheet!K44>Worksheet!L44),\"Yes\",IF(Worksheet!D44>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J44>0,Worksheet!K44/Worksheet!J44,0)","v":0},{"$f":"IF(AND(I38=\"Yes\",Worksheet!J44>0),Worksheet!M44/Worksheet!J44,0)","v":0},0,0,0,{"$f":"IF(AND(J38=\"Yes\",Worksheet!E44>0),(Worksheet!F44/Worksheet!E44)-Worksheet!H44,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D45","v":"00:00:00"},{"$f":"Worksheet!J45","v":0},{"$f":"IF(AND(Worksheet!D45>0,Worksheet!D45<CpiDate,Worksheet!K45>Worksheet!M45,Worksheet!$E$8-Worksheet!D45+1>365),\"Yes\",IF(Worksheet!D45>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D45>0,Worksheet!$E$8-Worksheet!D45+1>365,Worksheet!K45>Worksheet!L45),\"Yes\",IF(Worksheet!D45>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J45>0,Worksheet!K45/Worksheet!J45,0)","v":0},{"$f":"IF(AND(I39=\"Yes\",Worksheet!J45>0),Worksheet!M45/Worksheet!J45,0)","v":0},0,0,0,{"$f":"IF(AND(J39=\"Yes\",Worksheet!E45>0),(Worksheet!F45/Worksheet!E45)-Worksheet!H45,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D46","v":"00:00:00"},{"$f":"Worksheet!J46","v":0},{"$f":"IF(AND(Worksheet!D46>0,Worksheet!D46<CpiDate,Worksheet!K46>Worksheet!M46,Worksheet!$E$8-Worksheet!D46+1>365),\"Yes\",IF(Worksheet!D46>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D46>0,Worksheet!$E$8-Worksheet!D46+1>365,Worksheet!K46>Worksheet!L46),\"Yes\",IF(Worksheet!D46>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J46>0,Worksheet!K46/Worksheet!J46,0)","v":0},{"$f":"IF(AND(I40=\"Yes\",Worksheet!J46>0),Worksheet!M46/Worksheet!J46,0)","v":0},0,0,0,{"$f":"IF(AND(J40=\"Yes\",Worksheet!E46>0),(Worksheet!F46/Worksheet!E46)-Worksheet!H46,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D47","v":"00:00:00"},{"$f":"Worksheet!J47","v":0},{"$f":"IF(AND(Worksheet!D47>0,Worksheet!D47<CpiDate,Worksheet!K47>Worksheet!M47,Worksheet!$E$8-Worksheet!D47+1>365),\"Yes\",IF(Worksheet!D47>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D47>0,Worksheet!$E$8-Worksheet!D47+1>365,Worksheet!K47>Worksheet!L47),\"Yes\",IF(Worksheet!D47>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J47>0,Worksheet!K47/Worksheet!J47,0)","v":0},{"$f":"IF(AND(I41=\"Yes\",Worksheet!J47>0),Worksheet!M47/Worksheet!J47,0)","v":0},0,0,0,{"$f":"IF(AND(J41=\"Yes\",Worksheet!E47>0),(Worksheet!F47/Worksheet!E47)-Worksheet!H47,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D48","v":"00:00:00"},{"$f":"Worksheet!J48","v":0},{"$f":"IF(AND(Worksheet!D48>0,Worksheet!D48<CpiDate,Worksheet!K48>Worksheet!M48,Worksheet!$E$8-Worksheet!D48+1>365),\"Yes\",IF(Worksheet!D48>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D48>0,Worksheet!$E$8-Worksheet!D48+1>365,Worksheet!K48>Worksheet!L48),\"Yes\",IF(Worksheet!D48>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J48>0,Worksheet!K48/Worksheet!J48,0)","v":0},{"$f":"IF(AND(I42=\"Yes\",Worksheet!J48>0),Worksheet!M48/Worksheet!J48,0)","v":0},0,0,0,{"$f":"IF(AND(J42=\"Yes\",Worksheet!E48>0),(Worksheet!F48/Worksheet!E48)-Worksheet!H48,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D49","v":"00:00:00"},{"$f":"Worksheet!J49","v":0},{"$f":"IF(AND(Worksheet!D49>0,Worksheet!D49<CpiDate,Worksheet!K49>Worksheet!M49,Worksheet!$E$8-Worksheet!D49+1>365),\"Yes\",IF(Worksheet!D49>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D49>0,Worksheet!$E$8-Worksheet!D49+1>365,Worksheet!K49>Worksheet!L49),\"Yes\",IF(Worksheet!D49>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J49>0,Worksheet!K49/Worksheet!J49,0)","v":0},{"$f":"IF(AND(I43=\"Yes\",Worksheet!J49>0),Worksheet!M49/Worksheet!J49,0)","v":0},0,0,0,{"$f":"IF(AND(J43=\"Yes\",Worksheet!E49>0),(Worksheet!F49/Worksheet!E49)-Worksheet!H49,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D50","v":"00:00:00"},{"$f":"Worksheet!J50","v":0},{"$f":"IF(AND(Worksheet!D50>0,Worksheet!D50<CpiDate,Worksheet!K50>Worksheet!M50,Worksheet!$E$8-Worksheet!D50+1>365),\"Yes\",IF(Worksheet!D50>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D50>0,Worksheet!$E$8-Worksheet!D50+1>365,Worksheet!K50>Worksheet!L50),\"Yes\",IF(Worksheet!D50>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J50>0,Worksheet!K50/Worksheet!J50,0)","v":0},{"$f":"IF(AND(I44=\"Yes\",Worksheet!J50>0),Worksheet!M50/Worksheet!J50,0)","v":0},0,0,0,{"$f":"IF(AND(J44=\"Yes\",Worksheet!E50>0),(Worksheet!F50/Worksheet!E50)-Worksheet!H50,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D51","v":"00:00:00"},{"$f":"Worksheet!J51","v":0},{"$f":"IF(AND(Worksheet!D51>0,Worksheet!D51<CpiDate,Worksheet!K51>Worksheet!M51,Worksheet!$E$8-Worksheet!D51+1>365),\"Yes\",IF(Worksheet!D51>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D51>0,Worksheet!$E$8-Worksheet!D51+1>365,Worksheet!K51>Worksheet!L51),\"Yes\",IF(Worksheet!D51>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J51>0,Worksheet!K51/Worksheet!J51,0)","v":0},{"$f":"IF(AND(I45=\"Yes\",Worksheet!J51>0),Worksheet!M51/Worksheet!J51,0)","v":0},0,0,0,{"$f":"IF(AND(J45=\"Yes\",Worksheet!E51>0),(Worksheet!F51/Worksheet!E51)-Worksheet!H51,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D52","v":"00:00:00"},{"$f":"Worksheet!J52","v":0},{"$f":"IF(AND(Worksheet!D52>0,Worksheet!D52<CpiDate,Worksheet!K52>Worksheet!M52,Worksheet!$E$8-Worksheet!D52+1>365),\"Yes\",IF(Worksheet!D52>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D52>0,Worksheet!$E$8-Worksheet!D52+1>365,Worksheet!K52>Worksheet!L52),\"Yes\",IF(Worksheet!D52>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J52>0,Worksheet!K52/Worksheet!J52,0)","v":0},{"$f":"IF(AND(I46=\"Yes\",Worksheet!J52>0),Worksheet!M52/Worksheet!J52,0)","v":0},0,0,0,{"$f":"IF(AND(J46=\"Yes\",Worksheet!E52>0),(Worksheet!F52/Worksheet!E52)-Worksheet!H52,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D53","v":"00:00:00"},{"$f":"Worksheet!J53","v":0},{"$f":"IF(AND(Worksheet!D53>0,Worksheet!D53<CpiDate,Worksheet!K53>Worksheet!M53,Worksheet!$E$8-Worksheet!D53+1>365),\"Yes\",IF(Worksheet!D53>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D53>0,Worksheet!$E$8-Worksheet!D53+1>365,Worksheet!K53>Worksheet!L53),\"Yes\",IF(Worksheet!D53>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J53>0,Worksheet!K53/Worksheet!J53,0)","v":0},{"$f":"IF(AND(I47=\"Yes\",Worksheet!J53>0),Worksheet!M53/Worksheet!J53,0)","v":0},0,0,0,{"$f":"IF(AND(J47=\"Yes\",Worksheet!E53>0),(Worksheet!F53/Worksheet!E53)-Worksheet!H53,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D54","v":"00:00:00"},{"$f":"Worksheet!J54","v":0},{"$f":"IF(AND(Worksheet!D54>0,Worksheet!D54<CpiDate,Worksheet!K54>Worksheet!M54,Worksheet!$E$8-Worksheet!D54+1>365),\"Yes\",IF(Worksheet!D54>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D54>0,Worksheet!$E$8-Worksheet!D54+1>365,Worksheet!K54>Worksheet!L54),\"Yes\",IF(Worksheet!D54>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J54>0,Worksheet!K54/Worksheet!J54,0)","v":0},{"$f":"IF(AND(I48=\"Yes\",Worksheet!J54>0),Worksheet!M54/Worksheet!J54,0)","v":0},0,0,0,{"$f":"IF(AND(J48=\"Yes\",Worksheet!E54>0),(Worksheet!F54/Worksheet!E54)-Worksheet!H54,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D55","v":"00:00:00"},{"$f":"Worksheet!J55","v":0},{"$f":"IF(AND(Worksheet!D55>0,Worksheet!D55<CpiDate,Worksheet!K55>Worksheet!M55,Worksheet!$E$8-Worksheet!D55+1>365),\"Yes\",IF(Worksheet!D55>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D55>0,Worksheet!$E$8-Worksheet!D55+1>365,Worksheet!K55>Worksheet!L55),\"Yes\",IF(Worksheet!D55>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J55>0,Worksheet!K55/Worksheet!J55,0)","v":0},{"$f":"IF(AND(I49=\"Yes\",Worksheet!J55>0),Worksheet!M55/Worksheet!J55,0)","v":0},0,0,0,{"$f":"IF(AND(J49=\"Yes\",Worksheet!E55>0),(Worksheet!F55/Worksheet!E55)-Worksheet!H55,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D56","v":"00:00:00"},{"$f":"Worksheet!J56","v":0},{"$f":"IF(AND(Worksheet!D56>0,Worksheet!D56<CpiDate,Worksheet!K56>Worksheet!M56,Worksheet!$E$8-Worksheet!D56+1>365),\"Yes\",IF(Worksheet!D56>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D56>0,Worksheet!$E$8-Worksheet!D56+1>365,Worksheet!K56>Worksheet!L56),\"Yes\",IF(Worksheet!D56>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J56>0,Worksheet!K56/Worksheet!J56,0)","v":0},{"$f":"IF(AND(I50=\"Yes\",Worksheet!J56>0),Worksheet!M56/Worksheet!J56,0)","v":0},0,0,0,{"$f":"IF(AND(J50=\"Yes\",Worksheet!E56>0),(Worksheet!F56/Worksheet!E56)-Worksheet!H56,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D57","v":"00:00:00"},{"$f":"Worksheet!J57","v":0},{"$f":"IF(AND(Worksheet!D57>0,Worksheet!D57<CpiDate,Worksheet!K57>Worksheet!M57,Worksheet!$E$8-Worksheet!D57+1>365),\"Yes\",IF(Worksheet!D57>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D57>0,Worksheet!$E$8-Worksheet!D57+1>365,Worksheet!K57>Worksheet!L57),\"Yes\",IF(Worksheet!D57>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J57>0,Worksheet!K57/Worksheet!J57,0)","v":0},{"$f":"IF(AND(I51=\"Yes\",Worksheet!J57>0),Worksheet!M57/Worksheet!J57,0)","v":0},0,0,0,{"$f":"IF(AND(J51=\"Yes\",Worksheet!E57>0),(Worksheet!F57/Worksheet!E57)-Worksheet!H57,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D58","v":"00:00:00"},{"$f":"Worksheet!J58","v":0},{"$f":"IF(AND(Worksheet!D58>0,Worksheet!D58<CpiDate,Worksheet!K58>Worksheet!M58,Worksheet!$E$8-Worksheet!D58+1>365),\"Yes\",IF(Worksheet!D58>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D58>0,Worksheet!$E$8-Worksheet!D58+1>365,Worksheet!K58>Worksheet!L58),\"Yes\",IF(Worksheet!D58>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J58>0,Worksheet!K58/Worksheet!J58,0)","v":0},{"$f":"IF(AND(I52=\"Yes\",Worksheet!J58>0),Worksheet!M58/Worksheet!J58,0)","v":0},0,0,0,{"$f":"IF(AND(J52=\"Yes\",Worksheet!E58>0),(Worksheet!F58/Worksheet!E58)-Worksheet!H58,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D59","v":"00:00:00"},{"$f":"Worksheet!J59","v":0},{"$f":"IF(AND(Worksheet!D59>0,Worksheet!D59<CpiDate,Worksheet!K59>Worksheet!M59,Worksheet!$E$8-Worksheet!D59+1>365),\"Yes\",IF(Worksheet!D59>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D59>0,Worksheet!$E$8-Worksheet!D59+1>365,Worksheet!K59>Worksheet!L59),\"Yes\",IF(Worksheet!D59>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J59>0,Worksheet!K59/Worksheet!J59,0)","v":0},{"$f":"IF(AND(I53=\"Yes\",Worksheet!J59>0),Worksheet!M59/Worksheet!J59,0)","v":0},0,0,0,{"$f":"IF(AND(J53=\"Yes\",Worksheet!E59>0),(Worksheet!F59/Worksheet!E59)-Worksheet!H59,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D60","v":"00:00:00"},{"$f":"Worksheet!J60","v":0},{"$f":"IF(AND(Worksheet!D60>0,Worksheet!D60<CpiDate,Worksheet!K60>Worksheet!M60,Worksheet!$E$8-Worksheet!D60+1>365),\"Yes\",IF(Worksheet!D60>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D60>0,Worksheet!$E$8-Worksheet!D60+1>365,Worksheet!K60>Worksheet!L60),\"Yes\",IF(Worksheet!D60>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J60>0,Worksheet!K60/Worksheet!J60,0)","v":0},{"$f":"IF(AND(I54=\"Yes\",Worksheet!J60>0),Worksheet!M60/Worksheet!J60,0)","v":0},0,0,0,{"$f":"IF(AND(J54=\"Yes\",Worksheet!E60>0),(Worksheet!F60/Worksheet!E60)-Worksheet!H60,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D61","v":"00:00:00"},{"$f":"Worksheet!J61","v":0},{"$f":"IF(AND(Worksheet!D61>0,Worksheet!D61<CpiDate,Worksheet!K61>Worksheet!M61,Worksheet!$E$8-Worksheet!D61+1>365),\"Yes\",IF(Worksheet!D61>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D61>0,Worksheet!$E$8-Worksheet!D61+1>365,Worksheet!K61>Worksheet!L61),\"Yes\",IF(Worksheet!D61>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J61>0,Worksheet!K61/Worksheet!J61,0)","v":0},{"$f":"IF(AND(I55=\"Yes\",Worksheet!J61>0),Worksheet!M61/Worksheet!J61,0)","v":0},0,0,0,{"$f":"IF(AND(J55=\"Yes\",Worksheet!E61>0),(Worksheet!F61/Worksheet!E61)-Worksheet!H61,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D62","v":"00:00:00"},{"$f":"Worksheet!J62","v":0},{"$f":"IF(AND(Worksheet!D62>0,Worksheet!D62<CpiDate,Worksheet!K62>Worksheet!M62,Worksheet!$E$8-Worksheet!D62+1>365),\"Yes\",IF(Worksheet!D62>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D62>0,Worksheet!$E$8-Worksheet!D62+1>365,Worksheet!K62>Worksheet!L62),\"Yes\",IF(Worksheet!D62>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J62>0,Worksheet!K62/Worksheet!J62,0)","v":0},{"$f":"IF(AND(I56=\"Yes\",Worksheet!J62>0),Worksheet!M62/Worksheet!J62,0)","v":0},0,0,0,{"$f":"IF(AND(J56=\"Yes\",Worksheet!E62>0),(Worksheet!F62/Worksheet!E62)-Worksheet!H62,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D63","v":"00:00:00"},{"$f":"Worksheet!J63","v":0},{"$f":"IF(AND(Worksheet!D63>0,Worksheet!D63<CpiDate,Worksheet!K63>Worksheet!M63,Worksheet!$E$8-Worksheet!D63+1>365),\"Yes\",IF(Worksheet!D63>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D63>0,Worksheet!$E$8-Worksheet!D63+1>365,Worksheet!K63>Worksheet!L63),\"Yes\",IF(Worksheet!D63>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J63>0,Worksheet!K63/Worksheet!J63,0)","v":0},{"$f":"IF(AND(I57=\"Yes\",Worksheet!J63>0),Worksheet!M63/Worksheet!J63,0)","v":0},0,0,0,{"$f":"IF(AND(J57=\"Yes\",Worksheet!E63>0),(Worksheet!F63/Worksheet!E63)-Worksheet!H63,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D64","v":"00:00:00"},{"$f":"Worksheet!J64","v":0},{"$f":"IF(AND(Worksheet!D64>0,Worksheet!D64<CpiDate,Worksheet!K64>Worksheet!M64,Worksheet!$E$8-Worksheet!D64+1>365),\"Yes\",IF(Worksheet!D64>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D64>0,Worksheet!$E$8-Worksheet!D64+1>365,Worksheet!K64>Worksheet!L64),\"Yes\",IF(Worksheet!D64>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J64>0,Worksheet!K64/Worksheet!J64,0)","v":0},{"$f":"IF(AND(I58=\"Yes\",Worksheet!J64>0),Worksheet!M64/Worksheet!J64,0)","v":0},0,0,0,{"$f":"IF(AND(J58=\"Yes\",Worksheet!E64>0),(Worksheet!F64/Worksheet!E64)-Worksheet!H64,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D65","v":"00:00:00"},{"$f":"Worksheet!J65","v":0},{"$f":"IF(AND(Worksheet!D65>0,Worksheet!D65<CpiDate,Worksheet!K65>Worksheet!M65,Worksheet!$E$8-Worksheet!D65+1>365),\"Yes\",IF(Worksheet!D65>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D65>0,Worksheet!$E$8-Worksheet!D65+1>365,Worksheet!K65>Worksheet!L65),\"Yes\",IF(Worksheet!D65>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J65>0,Worksheet!K65/Worksheet!J65,0)","v":0},{"$f":"IF(AND(I59=\"Yes\",Worksheet!J65>0),Worksheet!M65/Worksheet!J65,0)","v":0},0,0,0,{"$f":"IF(AND(J59=\"Yes\",Worksheet!E65>0),(Worksheet!F65/Worksheet!E65)-Worksheet!H65,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D66","v":"00:00:00"},{"$f":"Worksheet!J66","v":0},{"$f":"IF(AND(Worksheet!D66>0,Worksheet!D66<CpiDate,Worksheet!K66>Worksheet!M66,Worksheet!$E$8-Worksheet!D66+1>365),\"Yes\",IF(Worksheet!D66>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D66>0,Worksheet!$E$8-Worksheet!D66+1>365,Worksheet!K66>Worksheet!L66),\"Yes\",IF(Worksheet!D66>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J66>0,Worksheet!K66/Worksheet!J66,0)","v":0},{"$f":"IF(AND(I60=\"Yes\",Worksheet!J66>0),Worksheet!M66/Worksheet!J66,0)","v":0},0,0,0,{"$f":"IF(AND(J60=\"Yes\",Worksheet!E66>0),(Worksheet!F66/Worksheet!E66)-Worksheet!H66,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D67","v":"00:00:00"},{"$f":"Worksheet!J67","v":0},{"$f":"IF(AND(Worksheet!D67>0,Worksheet!D67<CpiDate,Worksheet!K67>Worksheet!M67,Worksheet!$E$8-Worksheet!D67+1>365),\"Yes\",IF(Worksheet!D67>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D67>0,Worksheet!$E$8-Worksheet!D67+1>365,Worksheet!K67>Worksheet!L67),\"Yes\",IF(Worksheet!D67>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J67>0,Worksheet!K67/Worksheet!J67,0)","v":0},{"$f":"IF(AND(I61=\"Yes\",Worksheet!J67>0),Worksheet!M67/Worksheet!J67,0)","v":0},0,0,0,{"$f":"IF(AND(J61=\"Yes\",Worksheet!E67>0),(Worksheet!F67/Worksheet!E67)-Worksheet!H67,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D68","v":"00:00:00"},{"$f":"Worksheet!J68","v":0},{"$f":"IF(AND(Worksheet!D68>0,Worksheet!D68<CpiDate,Worksheet!K68>Worksheet!M68,Worksheet!$E$8-Worksheet!D68+1>365),\"Yes\",IF(Worksheet!D68>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D68>0,Worksheet!$E$8-Worksheet!D68+1>365,Worksheet!K68>Worksheet!L68),\"Yes\",IF(Worksheet!D68>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J68>0,Worksheet!K68/Worksheet!J68,0)","v":0},{"$f":"IF(AND(I62=\"Yes\",Worksheet!J68>0),Worksheet!M68/Worksheet!J68,0)","v":0},0,0,0,{"$f":"IF(AND(J62=\"Yes\",Worksheet!E68>0),(Worksheet!F68/Worksheet!E68)-Worksheet!H68,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D69","v":"00:00:00"},{"$f":"Worksheet!J69","v":0},{"$f":"IF(AND(Worksheet!D69>0,Worksheet!D69<CpiDate,Worksheet!K69>Worksheet!M69,Worksheet!$E$8-Worksheet!D69+1>365),\"Yes\",IF(Worksheet!D69>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D69>0,Worksheet!$E$8-Worksheet!D69+1>365,Worksheet!K69>Worksheet!L69),\"Yes\",IF(Worksheet!D69>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J69>0,Worksheet!K69/Worksheet!J69,0)","v":0},{"$f":"IF(AND(I63=\"Yes\",Worksheet!J69>0),Worksheet!M69/Worksheet!J69,0)","v":0},0,0,0,{"$f":"IF(AND(J63=\"Yes\",Worksheet!E69>0),(Worksheet!F69/Worksheet!E69)-Worksheet!H69,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D70","v":"00:00:00"},{"$f":"Worksheet!J70","v":0},{"$f":"IF(AND(Worksheet!D70>0,Worksheet!D70<CpiDate,Worksheet!K70>Worksheet!M70,Worksheet!$E$8-Worksheet!D70+1>365),\"Yes\",IF(Worksheet!D70>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D70>0,Worksheet!$E$8-Worksheet!D70+1>365,Worksheet!K70>Worksheet!L70),\"Yes\",IF(Worksheet!D70>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J70>0,Worksheet!K70/Worksheet!J70,0)","v":0},{"$f":"IF(AND(I64=\"Yes\",Worksheet!J70>0),Worksheet!M70/Worksheet!J70,0)","v":0},0,0,0,{"$f":"IF(AND(J64=\"Yes\",Worksheet!E70>0),(Worksheet!F70/Worksheet!E70)-Worksheet!H70,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D71","v":"00:00:00"},{"$f":"Worksheet!J71","v":0},{"$f":"IF(AND(Worksheet!D71>0,Worksheet!D71<CpiDate,Worksheet!K71>Worksheet!M71,Worksheet!$E$8-Worksheet!D71+1>365),\"Yes\",IF(Worksheet!D71>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D71>0,Worksheet!$E$8-Worksheet!D71+1>365,Worksheet!K71>Worksheet!L71),\"Yes\",IF(Worksheet!D71>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J71>0,Worksheet!K71/Worksheet!J71,0)","v":0},{"$f":"IF(AND(I65=\"Yes\",Worksheet!J71>0),Worksheet!M71/Worksheet!J71,0)","v":0},0,0,0,{"$f":"IF(AND(J65=\"Yes\",Worksheet!E71>0),(Worksheet!F71/Worksheet!E71)-Worksheet!H71,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D72","v":"00:00:00"},{"$f":"Worksheet!J72","v":0},{"$f":"IF(AND(Worksheet!D72>0,Worksheet!D72<CpiDate,Worksheet!K72>Worksheet!M72,Worksheet!$E$8-Worksheet!D72+1>365),\"Yes\",IF(Worksheet!D72>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D72>0,Worksheet!$E$8-Worksheet!D72+1>365,Worksheet!K72>Worksheet!L72),\"Yes\",IF(Worksheet!D72>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J72>0,Worksheet!K72/Worksheet!J72,0)","v":0},{"$f":"IF(AND(I66=\"Yes\",Worksheet!J72>0),Worksheet!M72/Worksheet!J72,0)","v":0},0,0,0,{"$f":"IF(AND(J66=\"Yes\",Worksheet!E72>0),(Worksheet!F72/Worksheet!E72)-Worksheet!H72,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D73","v":"00:00:00"},{"$f":"Worksheet!J73","v":0},{"$f":"IF(AND(Worksheet!D73>0,Worksheet!D73<CpiDate,Worksheet!K73>Worksheet!M73,Worksheet!$E$8-Worksheet!D73+1>365),\"Yes\",IF(Worksheet!D73>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D73>0,Worksheet!$E$8-Worksheet!D73+1>365,Worksheet!K73>Worksheet!L73),\"Yes\",IF(Worksheet!D73>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J73>0,Worksheet!K73/Worksheet!J73,0)","v":0},{"$f":"IF(AND(I67=\"Yes\",Worksheet!J73>0),Worksheet!M73/Worksheet!J73,0)","v":0},0,0,0,{"$f":"IF(AND(J67=\"Yes\",Worksheet!E73>0),(Worksheet!F73/Worksheet!E73)-Worksheet!H73,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D74","v":"00:00:00"},{"$f":"Worksheet!J74","v":0},{"$f":"IF(AND(Worksheet!D74>0,Worksheet!D74<CpiDate,Worksheet!K74>Worksheet!M74,Worksheet!$E$8-Worksheet!D74+1>365),\"Yes\",IF(Worksheet!D74>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D74>0,Worksheet!$E$8-Worksheet!D74+1>365,Worksheet!K74>Worksheet!L74),\"Yes\",IF(Worksheet!D74>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J74>0,Worksheet!K74/Worksheet!J74,0)","v":0},{"$f":"IF(AND(I68=\"Yes\",Worksheet!J74>0),Worksheet!M74/Worksheet!J74,0)","v":0},0,0,0,{"$f":"IF(AND(J68=\"Yes\",Worksheet!E74>0),(Worksheet!F74/Worksheet!E74)-Worksheet!H74,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D75","v":"00:00:00"},{"$f":"Worksheet!J75","v":0},{"$f":"IF(AND(Worksheet!D75>0,Worksheet!D75<CpiDate,Worksheet!K75>Worksheet!M75,Worksheet!$E$8-Worksheet!D75+1>365),\"Yes\",IF(Worksheet!D75>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D75>0,Worksheet!$E$8-Worksheet!D75+1>365,Worksheet!K75>Worksheet!L75),\"Yes\",IF(Worksheet!D75>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J75>0,Worksheet!K75/Worksheet!J75,0)","v":0},{"$f":"IF(AND(I69=\"Yes\",Worksheet!J75>0),Worksheet!M75/Worksheet!J75,0)","v":0},0,0,0,{"$f":"IF(AND(J69=\"Yes\",Worksheet!E75>0),(Worksheet!F75/Worksheet!E75)-Worksheet!H75,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D76","v":"00:00:00"},{"$f":"Worksheet!J76","v":0},{"$f":"IF(AND(Worksheet!D76>0,Worksheet!D76<CpiDate,Worksheet!K76>Worksheet!M76,Worksheet!$E$8-Worksheet!D76+1>365),\"Yes\",IF(Worksheet!D76>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D76>0,Worksheet!$E$8-Worksheet!D76+1>365,Worksheet!K76>Worksheet!L76),\"Yes\",IF(Worksheet!D76>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J76>0,Worksheet!K76/Worksheet!J76,0)","v":0},{"$f":"IF(AND(I70=\"Yes\",Worksheet!J76>0),Worksheet!M76/Worksheet!J76,0)","v":0},0,0,0,{"$f":"IF(AND(J70=\"Yes\",Worksheet!E76>0),(Worksheet!F76/Worksheet!E76)-Worksheet!H76,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D77","v":"00:00:00"},{"$f":"Worksheet!J77","v":0},{"$f":"IF(AND(Worksheet!D77>0,Worksheet!D77<CpiDate,Worksheet!K77>Worksheet!M77,Worksheet!$E$8-Worksheet!D77+1>365),\"Yes\",IF(Worksheet!D77>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D77>0,Worksheet!$E$8-Worksheet!D77+1>365,Worksheet!K77>Worksheet!L77),\"Yes\",IF(Worksheet!D77>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J77>0,Worksheet!K77/Worksheet!J77,0)","v":0},{"$f":"IF(AND(I71=\"Yes\",Worksheet!J77>0),Worksheet!M77/Worksheet!J77,0)","v":0},0,0,0,{"$f":"IF(AND(J71=\"Yes\",Worksheet!E77>0),(Worksheet!F77/Worksheet!E77)-Worksheet!H77,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D78","v":"00:00:00"},{"$f":"Worksheet!J78","v":0},{"$f":"IF(AND(Worksheet!D78>0,Worksheet!D78<CpiDate,Worksheet!K78>Worksheet!M78,Worksheet!$E$8-Worksheet!D78+1>365),\"Yes\",IF(Worksheet!D78>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D78>0,Worksheet!$E$8-Worksheet!D78+1>365,Worksheet!K78>Worksheet!L78),\"Yes\",IF(Worksheet!D78>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J78>0,Worksheet!K78/Worksheet!J78,0)","v":0},{"$f":"IF(AND(I72=\"Yes\",Worksheet!J78>0),Worksheet!M78/Worksheet!J78,0)","v":0},0,0,0,{"$f":"IF(AND(J72=\"Yes\",Worksheet!E78>0),(Worksheet!F78/Worksheet!E78)-Worksheet!H78,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D79","v":"00:00:00"},{"$f":"Worksheet!J79","v":0},{"$f":"IF(AND(Worksheet!D79>0,Worksheet!D79<CpiDate,Worksheet!K79>Worksheet!M79,Worksheet!$E$8-Worksheet!D79+1>365),\"Yes\",IF(Worksheet!D79>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D79>0,Worksheet!$E$8-Worksheet!D79+1>365,Worksheet!K79>Worksheet!L79),\"Yes\",IF(Worksheet!D79>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J79>0,Worksheet!K79/Worksheet!J79,0)","v":0},{"$f":"IF(AND(I73=\"Yes\",Worksheet!J79>0),Worksheet!M79/Worksheet!J79,0)","v":0},0,0,0,{"$f":"IF(AND(J73=\"Yes\",Worksheet!E79>0),(Worksheet!F79/Worksheet!E79)-Worksheet!H79,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D80","v":"00:00:00"},{"$f":"Worksheet!J80","v":0},{"$f":"IF(AND(Worksheet!D80>0,Worksheet!D80<CpiDate,Worksheet!K80>Worksheet!M80,Worksheet!$E$8-Worksheet!D80+1>365),\"Yes\",IF(Worksheet!D80>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D80>0,Worksheet!$E$8-Worksheet!D80+1>365,Worksheet!K80>Worksheet!L80),\"Yes\",IF(Worksheet!D80>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J80>0,Worksheet!K80/Worksheet!J80,0)","v":0},{"$f":"IF(AND(I74=\"Yes\",Worksheet!J80>0),Worksheet!M80/Worksheet!J80,0)","v":0},0,0,0,{"$f":"IF(AND(J74=\"Yes\",Worksheet!E80>0),(Worksheet!F80/Worksheet!E80)-Worksheet!H80,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D81","v":"00:00:00"},{"$f":"Worksheet!J81","v":0},{"$f":"IF(AND(Worksheet!D81>0,Worksheet!D81<CpiDate,Worksheet!K81>Worksheet!M81,Worksheet!$E$8-Worksheet!D81+1>365),\"Yes\",IF(Worksheet!D81>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D81>0,Worksheet!$E$8-Worksheet!D81+1>365,Worksheet!K81>Worksheet!L81),\"Yes\",IF(Worksheet!D81>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J81>0,Worksheet!K81/Worksheet!J81,0)","v":0},{"$f":"IF(AND(I75=\"Yes\",Worksheet!J81>0),Worksheet!M81/Worksheet!J81,0)","v":0},0,0,0,{"$f":"IF(AND(J75=\"Yes\",Worksheet!E81>0),(Worksheet!F81/Worksheet!E81)-Worksheet!H81,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D82","v":"00:00:00"},{"$f":"Worksheet!J82","v":0},{"$f":"IF(AND(Worksheet!D82>0,Worksheet!D82<CpiDate,Worksheet!K82>Worksheet!M82,Worksheet!$E$8-Worksheet!D82+1>365),\"Yes\",IF(Worksheet!D82>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D82>0,Worksheet!$E$8-Worksheet!D82+1>365,Worksheet!K82>Worksheet!L82),\"Yes\",IF(Worksheet!D82>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J82>0,Worksheet!K82/Worksheet!J82,0)","v":0},{"$f":"IF(AND(I76=\"Yes\",Worksheet!J82>0),Worksheet!M82/Worksheet!J82,0)","v":0},0,0,0,{"$f":"IF(AND(J76=\"Yes\",Worksheet!E82>0),(Worksheet!F82/Worksheet!E82)-Worksheet!H82,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D83","v":"00:00:00"},{"$f":"Worksheet!J83","v":0},{"$f":"IF(AND(Worksheet!D83>0,Worksheet!D83<CpiDate,Worksheet!K83>Worksheet!M83,Worksheet!$E$8-Worksheet!D83+1>365),\"Yes\",IF(Worksheet!D83>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D83>0,Worksheet!$E$8-Worksheet!D83+1>365,Worksheet!K83>Worksheet!L83),\"Yes\",IF(Worksheet!D83>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J83>0,Worksheet!K83/Worksheet!J83,0)","v":0},{"$f":"IF(AND(I77=\"Yes\",Worksheet!J83>0),Worksheet!M83/Worksheet!J83,0)","v":0},0,0,0,{"$f":"IF(AND(J77=\"Yes\",Worksheet!E83>0),(Worksheet!F83/Worksheet!E83)-Worksheet!H83,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D84","v":"00:00:00"},{"$f":"Worksheet!J84","v":0},{"$f":"IF(AND(Worksheet!D84>0,Worksheet!D84<CpiDate,Worksheet!K84>Worksheet!M84,Worksheet!$E$8-Worksheet!D84+1>365),\"Yes\",IF(Worksheet!D84>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D84>0,Worksheet!$E$8-Worksheet!D84+1>365,Worksheet!K84>Worksheet!L84),\"Yes\",IF(Worksheet!D84>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J84>0,Worksheet!K84/Worksheet!J84,0)","v":0},{"$f":"IF(AND(I78=\"Yes\",Worksheet!J84>0),Worksheet!M84/Worksheet!J84,0)","v":0},0,0,0,{"$f":"IF(AND(J78=\"Yes\",Worksheet!E84>0),(Worksheet!F84/Worksheet!E84)-Worksheet!H84,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D85","v":"00:00:00"},{"$f":"Worksheet!J85","v":0},{"$f":"IF(AND(Worksheet!D85>0,Worksheet!D85<CpiDate,Worksheet!K85>Worksheet!M85,Worksheet!$E$8-Worksheet!D85+1>365),\"Yes\",IF(Worksheet!D85>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D85>0,Worksheet!$E$8-Worksheet!D85+1>365,Worksheet!K85>Worksheet!L85),\"Yes\",IF(Worksheet!D85>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J85>0,Worksheet!K85/Worksheet!J85,0)","v":0},{"$f":"IF(AND(I79=\"Yes\",Worksheet!J85>0),Worksheet!M85/Worksheet!J85,0)","v":0},0,0,0,{"$f":"IF(AND(J79=\"Yes\",Worksheet!E85>0),(Worksheet!F85/Worksheet!E85)-Worksheet!H85,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,{"$f":"IF(D80>0,MIN(D80,N80),0)","v":0},{"$f":"D80-E80","v":0},{"$f":"Worksheet!D86","v":"00:00:00"},{"$f":"Worksheet!J86","v":0},{"$f":"IF(AND(Worksheet!D86>0,Worksheet!D86<CpiDate,Worksheet!K86>Worksheet!M86,Worksheet!$E$8-Worksheet!D86+1>365),\"Yes\",IF(Worksheet!D86>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D86>0,Worksheet!$E$8-Worksheet!D86+1>365,Worksheet!K86>Worksheet!L86),\"Yes\",IF(Worksheet!D86>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J86>0,Worksheet!K86/Worksheet!J86,0)","v":0},{"$f":"IF(AND(I80=\"Yes\",Worksheet!J86>0),Worksheet!M86/Worksheet!J86,0)","v":0},{"$f":"IF(I80=\"Yes\",K80-L80,0)","v":0},{"$f":"IF(AND(I80=\"Yes\",M80<Q80/2),M80*H80,IF(AND(I80=\"Yes\",D80>0),MIN(D80,M80*H80),0))","v":0},{"$f":"IF(M80>0,N80/M80,0)","v":0},{"$f":"IF(AND(J80=\"Yes\",Worksheet!E86>0),(Worksheet!F86/Worksheet!E86)-Worksheet!H86,0)","v":0},{"$f":"IF(J80=\"Yes\",K80-P80,0)","v":0},{"$f":"S80*Q80","v":0},{"$f":"IF(J80=\"Yes\",H80-O80,0)","v":0},null,null,null,"Blank"]
[null,null,null,{"$f":"IF(H81>0,F80,0)","v":0},0,0,{"$f":"Worksheet!D87","v":"00:00:00"},{"$f":"Worksheet!J87","v":0},{"$f":"IF(AND(Worksheet!D87>0,Worksheet!D87<CpiDate,Worksheet!K87>Worksheet!M87,Worksheet!$E$8-Worksheet!D87+1>365),\"Yes\",IF(Worksheet!D87>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D87>0,Worksheet!$E$8-Worksheet!D87+1>365,Worksheet!K87>Worksheet!L87),\"Yes\",IF(Worksheet!D87>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J87>0,Worksheet!K87/Worksheet!J87,0)","v":0},{"$f":"IF(AND(I81=\"Yes\",Worksheet!J87>0),Worksheet!M87/Worksheet!J87,0)","v":0},0,0,0,{"$f":"IF(AND(J81=\"Yes\",Worksheet!E87>0),(Worksheet!F87/Worksheet!E87)-Worksheet!H87,0)","v":0},0,0,0,null,null,null,{"$f":"IF(OR(G81>0,H81>0),0,\"Blank\")","v":"Blank"}]
[null,null,null,0,0,0,{"$f":"Worksheet!D88","v":"00:00:00"},{"$f":"Worksheet!J88","v":0},{"$f":"IF(AND(Worksheet!D88>0,Worksheet!D88<CpiDate,Worksheet!K88>Worksheet!M88,Worksheet!$E$8-Worksheet!D88+1>365),\"Yes\",IF(Worksheet!D88>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D88>0,Worksheet!$E$8-Worksheet!D88+1>365,Worksheet!K88>Worksheet!L88),\"Yes\",IF(Worksheet!D88>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J88>0,Worksheet!K88/Worksheet!J88,0)","v":0},{"$f":"IF(AND(I82=\"Yes\",Worksheet!J88>0),Worksheet!M88/Worksheet!J88,0)","v":0},0,0,0,{"$f":"IF(AND(J82=\"Yes\",Worksheet!E88>0),(Worksheet!F88/Worksheet!E88)-Worksheet!H88,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D89","v":"00:00:00"},{"$f":"Worksheet!J89","v":0},{"$f":"IF(AND(Worksheet!D89>0,Worksheet!D89<CpiDate,Worksheet!K89>Worksheet!M89,Worksheet!$E$8-Worksheet!D89+1>365),\"Yes\",IF(Worksheet!D89>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D89>0,Worksheet!$E$8-Worksheet!D89+1>365,Worksheet!K89>Worksheet!L89),\"Yes\",IF(Worksheet!D89>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J89>0,Worksheet!K89/Worksheet!J89,0)","v":0},{"$f":"IF(AND(I83=\"Yes\",Worksheet!J89>0),Worksheet!M89/Worksheet!J89,0)","v":0},0,0,0,{"$f":"IF(AND(J83=\"Yes\",Worksheet!E89>0),(Worksheet!F89/Worksheet!E89)-Worksheet!H89,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D90","v":"00:00:00"},{"$f":"Worksheet!J90","v":0},{"$f":"IF(AND(Worksheet!D90>0,Worksheet!D90<CpiDate,Worksheet!K90>Worksheet!M90,Worksheet!$E$8-Worksheet!D90+1>365),\"Yes\",IF(Worksheet!D90>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D90>0,Worksheet!$E$8-Worksheet!D90+1>365,Worksheet!K90>Worksheet!L90),\"Yes\",IF(Worksheet!D90>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J90>0,Worksheet!K90/Worksheet!J90,0)","v":0},{"$f":"IF(AND(I84=\"Yes\",Worksheet!J90>0),Worksheet!M90/Worksheet!J90,0)","v":0},0,0,0,{"$f":"IF(AND(J84=\"Yes\",Worksheet!E90>0),(Worksheet!F90/Worksheet!E90)-Worksheet!H90,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D91","v":"00:00:00"},{"$f":"Worksheet!J91","v":0},{"$f":"IF(AND(Worksheet!D91>0,Worksheet!D91<CpiDate,Worksheet!K91>Worksheet!M91,Worksheet!$E$8-Worksheet!D91+1>365),\"Yes\",IF(Worksheet!D91>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D91>0,Worksheet!$E$8-Worksheet!D91+1>365,Worksheet!K91>Worksheet!L91),\"Yes\",IF(Worksheet!D91>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J91>0,Worksheet!K91/Worksheet!J91,0)","v":0},{"$f":"IF(AND(I85=\"Yes\",Worksheet!J91>0),Worksheet!M91/Worksheet!J91,0)","v":0},0,0,0,{"$f":"IF(AND(J85=\"Yes\",Worksheet!E91>0),(Worksheet!F91/Worksheet!E91)-Worksheet!H91,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D92","v":"00:00:00"},{"$f":"Worksheet!J92","v":0},{"$f":"IF(AND(Worksheet!D92>0,Worksheet!D92<CpiDate,Worksheet!K92>Worksheet!M92,Worksheet!$E$8-Worksheet!D92+1>365),\"Yes\",IF(Worksheet!D92>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D92>0,Worksheet!$E$8-Worksheet!D92+1>365,Worksheet!K92>Worksheet!L92),\"Yes\",IF(Worksheet!D92>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J92>0,Worksheet!K92/Worksheet!J92,0)","v":0},{"$f":"IF(AND(I86=\"Yes\",Worksheet!J92>0),Worksheet!M92/Worksheet!J92,0)","v":0},0,0,0,{"$f":"IF(AND(J86=\"Yes\",Worksheet!E92>0),(Worksheet!F92/Worksheet!E92)-Worksheet!H92,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D93","v":"00:00:00"},{"$f":"Worksheet!J93","v":0},{"$f":"IF(AND(Worksheet!D93>0,Worksheet!D93<CpiDate,Worksheet!K93>Worksheet!M93,Worksheet!$E$8-Worksheet!D93+1>365),\"Yes\",IF(Worksheet!D93>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D93>0,Worksheet!$E$8-Worksheet!D93+1>365,Worksheet!K93>Worksheet!L93),\"Yes\",IF(Worksheet!D93>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J93>0,Worksheet!K93/Worksheet!J93,0)","v":0},{"$f":"IF(AND(I87=\"Yes\",Worksheet!J93>0),Worksheet!M93/Worksheet!J93,0)","v":0},0,0,0,{"$f":"IF(AND(J87=\"Yes\",Worksheet!E93>0),(Worksheet!F93/Worksheet!E93)-Worksheet!H93,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D94","v":"00:00:00"},{"$f":"Worksheet!J94","v":0},{"$f":"IF(AND(Worksheet!D94>0,Worksheet!D94<CpiDate,Worksheet!K94>Worksheet!M94,Worksheet!$E$8-Worksheet!D94+1>365),\"Yes\",IF(Worksheet!D94>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D94>0,Worksheet!$E$8-Worksheet!D94+1>365,Worksheet!K94>Worksheet!L94),\"Yes\",IF(Worksheet!D94>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J94>0,Worksheet!K94/Worksheet!J94,0)","v":0},{"$f":"IF(AND(I88=\"Yes\",Worksheet!J94>0),Worksheet!M94/Worksheet!J94,0)","v":0},0,0,0,{"$f":"IF(AND(J88=\"Yes\",Worksheet!E94>0),(Worksheet!F94/Worksheet!E94)-Worksheet!H94,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,0,0,0,{"$f":"Worksheet!D95","v":"00:00:00"},{"$f":"Worksheet!J95","v":0},{"$f":"IF(AND(Worksheet!D95>0,Worksheet!D95<CpiDate,Worksheet!K95>Worksheet!M95,Worksheet!$E$8-Worksheet!D95+1>365),\"Yes\",IF(Worksheet!D95>0,\"No\",\"\"))","v":""},{"$f":"IF(AND(Worksheet!D95>0,Worksheet!$E$8-Worksheet!D95+1>365,Worksheet!K95>Worksheet!L95),\"Yes\",IF(Worksheet!D95>0,\"No\",\"\"))","v":""},{"$f":"IF(Worksheet!J95>0,Worksheet!K95/Worksheet!J95,0)","v":0},{"$f":"IF(AND(I89=\"Yes\",Worksheet!J95>0),Worksheet!M95/Worksheet!J95,0)","v":0},0,0,0,{"$f":"IF(AND(J89=\"Yes\",Worksheet!E95>0),(Worksheet!F95/Worksheet!E95)-Worksheet!H95,0)","v":0},0,0,0,null,null,null,"Blank"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N15:N89)","v":0},{"$f":"SUM(O15:O89)","v":0},null,null,{"$f":"SUM(R15:R89)","v":0},{"$f":"SUM(S15:S89)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank"]

{"sheet":"CPI","index":2,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,9,0,10],[1,9,1,10],[8,3,8,4],[5,5,6,5],[0,3,0,5],[1,3,1,5]]}
[null,null,null,"Consumer Price Index"]
[null,null,null,"For Calculating Capital Gains Using Indexation"]
[]
[]
[]
[null,null,null,"Indexation Method is Available \n",null,"1999-09-21"]
[null,null,null,"If Asset Was Acquired Before"]
[]
[null,null,null,"Quarter",null,"CPI"]
[null,null,null,"From","To","Factor"]
[null,null,null,"1985-07-01","1985-09-30",39.700000000000003]
[null,null,null,{"$f":"E11+1","v":"1985-10-01"},"1985-12-31",40.5]
[null,null,null,{"$f":"E12+1","v":"1986-01-01"},"1986-03-31",41.4]
[null,null,null,{"$f":"E13+1","v":"1986-04-01"},"1986-06-30",42.1]
[null,null,null,"1986-07-01","1986-09-30",43.2]
[null,null,null,"1986-10-01","1986-12-31",44.4]
[null,null,null,"1987-01-01","1987-03-31",45.3]
[null,null,null,"1987-04-01","1987-06-30",46]
[null,null,null,"1987-07-01","1987-09-30",46.8]
[null,null,null,"1987-10-01","1987-12-31",47.6]
[null,null,null,"1988-01-01","1988-03-31",48.4]
[null,null,null,"1988-04-01","1988-06-30",49.3]
[null,null,null,"1988-07-01","1988-09-30",50.2]
[null,null,null,"1988-10-01","1988-12-31",51.2]
[null,null,null,"1989-01-01","1989-03-31",51.7]
[null,null,null,"1989-04-01","1989-06-30",53]
[null,null,null,"1989-07-01","1989-09-30",54.2]
[null,null,null,"1989-10-01","1989-12-31",55.2]
[null,null,null,"1990-01-01","1990-03-31",56.2]
[null,null,null,"1990-04-01","1990-06-30",57.1]
[null,null,null,"1990-07-01","1990-09-30",57.5]
[null,null,null,"1990-10-01","1990-12-31",59]
[null,null,null,"1991-01-01","1991-03-31",58.9]
[null,null,null,"1991-04-01","1991-06-30",59]
[null,null,null,"1991-07-01","1991-09-30",59.3]
[null,null,null,"1991-10-01","1991-12-31",59.9]
[null,null,null,"1992-01-01","1992-03-31",59.9]
[null,null,null,"1992-04-01","1992-06-30",59.7]
[null,null,null,"1992-07-01","1992-09-30",59.8]
[null,null,null,"1992-10-01","1992-12-31",60.1]
[null,null,null,"1993-01-01","1993-03-31",60.6]
[null,null,null,"1993-04-01","1993-06-30",60.8]
[null,null,null,"1993-07-01","1993-09-30",61.1]
[null,null,null,"1993-10-01","1993-12-31",61.2]
[null,null,null,"1994-01-01","1994-03-31",61.5]
[null,null,null,"1994-04-01","1994-06-30",61.9]
[null,null,null,"1994-07-01","1994-09-30",62.3]
[null,null,null,"1994-10-01","1994-12-31",62.8]
[null,null,null,"1995-01-01","1995-03-31",63.8]
[null,null,null,"1995-04-01","1995-06-30",64.7]
[null,null,null,"1995-07-01","1995-09-30",65.5]
[null,null,null,"1995-10-01","1995-12-31",66]
[null,null,null,"1996-01-01","1996-03-31",66.2]
[null,null,null,"1996-04-01","1996-06-30",66.7]
[null,null,null,"1996-07-01","1996-09-30",66.900000000000006]
[null,null,null,"1996-10-01","1996-12-31",67]
[null,null,null,"1997-01-01","1997-03-31",67.099999999999994]
[null,null,null,"1997-04-01","1997-06-30",66.900000000000006]
[null,null,null,"1997-07-01","1997-09-30",66.599999999999994]
[null,null,null,"1997-10-01","1997-12-31",66.8]
[null,null,null,"1998-01-01","1998-03-31",67]
[null,null,null,"1998-04-01","1998-06-30",67.400000000000006]
[null,null,null,"1998-07-01","1998-09-30",67.5]
[null,null,null,"1998-10-01","1998-12-31",67.8]
[null,null,null,"1999-01-01","1999-03-31",67.8]
[null,null,null,"1999-04-01","1999-06-30",68.099999999999994]
[null,null,null,"1999-07-01","1999-09-30",68.7]