{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Commercial Comparison","Reference 1. Resources","Reference 2. Expenses","Reference 3. Discount","Aux"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Commercial Comparison Template"]
[null,"This template allows the commercial comparison of supplier proposals"]
[]
[null,"To use this checklist, please follow these steps:"]
[null,"As per number of supplier proposals received, complete each supplier box with the following data:"]
[null,"1. Estimated Engagement Duration"]
[null,"2. Resource Breakdown (use of supplier role name column is optional)"]
[null,"3. Additional discount rate as % (if applicable)"]
[null,"4. Estimated expenses ($)"]
[]
[]
[]
[null,"Legend"]
[null,"Input Box -  Enter data here"]
[null,"Compliant Box - Data entry is compliant"]
[null,"Non-Compliant Box - Data entry is non compliant. (Please refer to relavent reference tabs)"]

{"sheet":"Commercial Comparison","index":1,"n_rows":34,"n_cols":24,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,20,4,23],[20,20,20,23],[20,12,20,15],[20,4,20,7],[16,1,16,5],[16,22,16,23],[13,20,13,21],[14,21,14,22],[15,21,15,22],[16,17,16,21],[4,17,4,18],[20,1,20,2],[20,9,20,10],[20,17,20,18],[33,2,33,7],[33,10,33,15],[33,18,33,23],[17,2,17,7],[17,10,17,15],[17,18,17,23],[31,21,31,22],[32,17,32,21],[32,22,32,23],[30,5,30,6],[29,20,29,21],[30,21,30,22],[29,4,29,5],[29,12,29,13],[30,13,30,14],[32,1,32,5],[32,6,32,7],[31,5,31,6],[31,13,31,14],[32,9,32,13],[32,14,32,15],[1,2,1,3],[13,12,13,13],[14,13,14,14],[15,13,15,14],[16,9,16,13],[16,6,16,7],[16,14,16,15],[4,1,4,2],[4,9,4,10],[13,4,13,5],[14,5,14,6],[15,5,15,6],[4,4,4,7],[4,12,4,15]]}
[]
[null,"Capped Rate Type","ICT Consulting"]
[]
[null,null,null,null,"Supplier 1",null,null,null,null,null,null,null,"Supplier 2",null,null,null,null,null,null,null,"Supplier 3"]
[null,"Estimated Project Duration (Days)",null,null,null,null,null,null,null,"Estimated Project Duration (Days)",null,null,null,null,null,null,null,"Estimated Project Duration (Days)"]
[null,"Supplier Resource Type","Govt. Resource Type","Resource Mix (%)","Daily Rate","Deviation  Capped Rate (%)","Estimated Days","Total Cost",null,"Supplier Resource Type","Govt. Resource Type","Resource Mix (%)","Daily Rate","Deviation  Capped Rate (%)","Estimated Days","Total Cost",null,"Supplier Resource Type","Govt. Resource Type","Resource Mix (%)","Daily Rate","Deviation  Capped Rate (%)","Estimated Days","Total Cost"]
[null,null,null,{"$f":"IFERROR(SUMIF($C$7:$C$13,C7, $G$7:$G$13)/$G$14,0)","v":0},null,{"$f":"_xlfn.IFNA((E7 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C7,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C7,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"G7*E7","v":0},null,null,null,{"$f":"IFERROR(SUMIF($K$7:$K$13,K7, $O$7:$O$13)/$O$14,0)","v":0},null,{"$f":"_xlfn.IFNA((M7 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K7,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K7,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"O7*M7","v":0},null,null,null,{"$f":"IFERROR(SUMIF($S$7:$S$13,S7, $W$7:$W$13)/$W$14,0)","v":0},null,{"$f":"_xlfn.IFNA((U7 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S7,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S7,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"W7*U7","v":0}]
[null,null,null,{"$f":"IFERROR(SUMIF($C$7:$C$13,C8, $G$7:$G$13)/$G$14,0)","v":0},null,{"$f":"_xlfn.IFNA((E8 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C8,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C8,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"G8*E8","v":0},null,null,null,{"$f":"IFERROR(SUMIF($K$7:$K$13,K8, $O$7:$O$13)/$O$14,0)","v":0},null,{"$f":"_xlfn.IFNA((M8 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K8,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K8,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"O8*M8","v":0},null,null,null,{"$f":"IFERROR(SUMIF($S$7:$S$13,S8, $W$7:$W$13)/$W$14,0)","v":0},null,{"$f":"_xlfn.IFNA((U8 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S8,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S8,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"W8*U8","v":0}]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E9 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C9,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C9,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M9 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K9,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K9,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U9 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S9,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S9,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E10 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C10,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C10,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M10 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K10,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K10,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U10 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S10,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S10,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E11 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C11,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C11,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M11 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K11,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K11,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U11 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S11,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S11,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,{"$f":"IFERROR(SUMIF($C$7:$C$13,C12, $G$7:$G$13)/$G$14,0)","v":0},null,{"$f":"_xlfn.IFNA((E12 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C12,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C12,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"G12*E12","v":0},null,null,null,{"$f":"IFERROR(SUMIF($K$7:$K$13,K12, $O$7:$O$13)/$O$14,0)","v":0},null,{"$f":"_xlfn.IFNA((M12 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K12,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K12,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"O12*M12","v":0},null,null,null,{"$f":"IFERROR(SUMIF($S$7:$S$13,S12, $W$7:$W$13)/$W$14,0)","v":0},null,{"$f":"_xlfn.IFNA((U12 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S12,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S12,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"W12*U12","v":0}]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E13 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C13,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C13,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M13 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K13,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K13,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U13 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S13,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S13,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,null,"Total Days | Total Cost:",null,{"$f":"SUM(INDIRECT(\"G7:G\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"H7:H\"&ROW()-1))","v":0},null,null,null,null,"Total Days | Total Cost:",null,{"$f":"SUM(INDIRECT(\"O7:O\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"P7:P\"&ROW()-1))","v":0},null,null,null,null,"Total Days | Total Cost:",null,{"$f":"SUM(INDIRECT(\"W7:W\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"X7:X\"&ROW()-1))","v":0}]
[null,null,null,"Discount Structure",{"$f":"IF($F$5=\"Yes\",10%,VLOOKUP(H14,Aux!$K$2:$L$6,2,TRUE))","v":0},"Additional Discount",null,null,null,null,null,"Discount Structure",{"$f":"IF($N$5=\"Yes\",10%,VLOOKUP(P14,Aux!$K$2:$L$6,2,TRUE))","v":0},"Additional Discount",null,null,null,null,null,"Discount Structure",{"$f":"IF($V$5=\"Yes\",10%,VLOOKUP(X14,Aux!$K$2:$L$6,2,TRUE))","v":0},"Additional Discount"]
[null,"Maximum expenses estimated",null,"Total Discount $",{"$f":"H14*(E15+H15)","v":0},"Total Eng. Cost after discount",null,{"$f":"H14-E16","v":0},null,"Maximum expenses estimated",null,"Total Discount $",{"$f":"P14*(M15+P15)","v":0},"Total Eng. Cost after discount",null,{"$f":"P14-M16","v":0},null,"Maximum expenses estimated",null,"Total Discount $",{"$f":"X14*(U15+X15)","v":0},"Total Eng. Cost after discount",null,{"$f":"X14-U16","v":0}]
[null,"Estimated engagement cost after discounts and expenses",null,null,null,null,{"$f":"H16+C16","v":0},null,null,"Estimated engagement cost after discounts and expenses",null,null,null,null,{"$f":"P16+K16","v":0},null,null,"Estimated engagement cost after discounts and expenses",null,null,null,null,{"$f":"X16+S16","v":0}]
[null,"Comments",null,null,null,null,null,null,null,"Comments",null,null,null,null,null,null,null,"Comments"]
[]
[null,null,null,null,"Supplier 4",null,null,null,null,null,null,null,"Supplier 5",null,null,null,null,null,null,null,"Supplier 6"]
[null,"Estimated Project Duration (Days)",null,null,null,null,null,null,null,"Estimated Project Duration (Days)",null,100,null,null,null,null,null,"Estimated Project Duration (Days)"]
[null,"Supplier Resource Type","Govt. Resource Type","Resource Mix (%)","Daily Rate","Deviation  Capped Rate (%)","Estimated Days","Total Cost",null,"Supplier Resource Type","Govt. Resource Type","Resource Mix (%)","Daily Rate","Deviation  Capped Rate (%)","Estimated Days","Total Cost",null,"Supplier Resource Type","Govt. Resource Type","Resource Mix (%)","Daily Rate","Deviation  Capped Rate (%)","Estimated Days","Total Cost"]
[null,null,null,{"$f":"IFERROR(SUMIF($C$23:$C$29,C23, $G$23:$G$29)/$G$30,0)","v":0},null,{"$f":"_xlfn.IFNA((E23 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C23,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C23,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"G23*E23","v":0},null,null,null,{"$f":"IFERROR(SUMIF($K$23:$K$29,K23, $O$23:$O$29)/$O$30,0)","v":0},null,{"$f":"_xlfn.IFNA((M23 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K23,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K23,Aux!$C$2:$J$2,0),0),0)","v":0},50,{"$f":"O23*M23","v":0},null,null,null,{"$f":"IFERROR(SUMIF($S$23:$S$29,S23, $W$23:$W$29)/$W$30,0)","v":0},null,{"$f":"_xlfn.IFNA((U23 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S23,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S23,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"W23*U23","v":0}]
[null,null,null,{"$f":"IFERROR(SUMIF($C$23:$C$29,C24, $G$23:$G$29)/$G$30,0)","v":0},null,{"$f":"_xlfn.IFNA((E24 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C24,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C24,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"G24*E24","v":0},null,null,null,{"$f":"IFERROR(SUMIF($K$23:$K$29,K24, $O$23:$O$29)/$O$30,0)","v":0},null,{"$f":"_xlfn.IFNA((M24 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K24,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K24,Aux!$C$2:$J$2,0),0),0)","v":0},80,{"$f":"O24*M24","v":0},null,null,null,{"$f":"IFERROR(SUMIF($S$23:$S$29,S24, $W$23:$W$29)/$W$30,0)","v":0},null,{"$f":"_xlfn.IFNA((U24 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S24,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S24,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"W24*U24","v":0}]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E25 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C25,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C25,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M25 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K25,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K25,Aux!$C$2:$J$2,0),0),0)","v":0},60,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U25 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S25,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S25,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E26 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C26,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C26,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M26 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K26,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K26,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U26 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S26,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S26,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E27 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C27,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C27,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M27 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K27,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K27,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U27 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S27,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S27,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,{"$f":"IFERROR(SUMIF($C$23:$C$29,C28, $G$23:$G$29)/$G$30,0)","v":0},null,{"$f":"_xlfn.IFNA((E28 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C28,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C28,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"G28*E28","v":0},null,null,null,{"$f":"IFERROR(SUMIF($K$23:$K$29,K28, $O$23:$O$29)/$O$30,0)","v":0},null,{"$f":"_xlfn.IFNA((M28 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K28,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K28,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"O28*M28","v":0},null,null,null,{"$f":"IFERROR(SUMIF($S$23:$S$29,S28, $W$23:$W$29)/$W$30,0)","v":0},null,{"$f":"_xlfn.IFNA((U28 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S28,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S28,Aux!$C$2:$J$2,0),0),0)","v":0},null,{"$f":"W28*U28","v":0}]
[null,null,null,0,null,{"$f":"_xlfn.IFNA((E29 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C29,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(C29,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((M29 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K29,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(K29,Aux!$C$2:$J$2,0),0),0)","v":0},null,0,null,null,null,0,null,{"$f":"_xlfn.IFNA((U29 - VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S29,Aux!$C$2:$J$2,0),0))/VLOOKUP($C$2,Aux!$C$3:$J$15,MATCH(S29,Aux!$C$2:$J$2,0),0),0)","v":0},null,0]
[null,null,null,null,"Total Days | Total Cost:",null,{"$f":"SUM(INDIRECT(\"G21:G\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"H21:H\"&ROW()-1))","v":0},null,null,null,null,"Total Days | Total Cost:",null,{"$f":"SUM(INDIRECT(\"O21:O\"&ROW()-1))","v":190},{"$f":"SUM(INDIRECT(\"P21:P\"&ROW()-1))","v":0},null,null,null,null,"Total Days | Total Cost:",null,{"$f":"SUM(INDIRECT(\"W21:W\"&ROW()-1))","v":0},{"$f":"SUM(INDIRECT(\"X21:X\"&ROW()-1))","v":0}]
[null,null,null,"Discount Structure",{"$f":"IF($F$21=\"Yes\",10%,VLOOKUP(H30,Aux!$K$2:$L$6,2,TRUE))","v":0},"Additional Discount",null,null,null,null,null,"Discount Structure",{"$f":"IF($N$21=\"Yes\",10%,VLOOKUP(P30,Aux!$K$2:$L$6,2,TRUE))","v":0},"Additional Discount",null,null,null,null,null,"Discount Structure",{"$f":"IF($V$21=\"Yes\",10%,VLOOKUP(X30,Aux!$K$2:$L$6,2,TRUE))","v":0},"Additional Discount"]
[null,"Maximum expenses estimated",null,"Total Discount $",{"$f":"H30*(E31+H31)","v":0},"Total Eng. Cost after discount",null,{"$f":"H30-E32","v":0},null,"Maximum expenses estimated",null,"Total Discount $",{"$f":"P30*(M31+P31)","v":0},"Total Eng. Cost after discount",null,{"$f":"P30-M32","v":0},null,"Maximum expenses estimated",null,"Total Discount $",{"$f":"X30*(U31+X31)","v":0},"Total Eng. Cost after discount",null,{"$f":"X30-U32","v":0}]
[null,"Estimated engagement cost after discounts and expenses",null,null,null,null,{"$f":"H32+C32","v":0},null,null,"Estimated engagement cost after discounts and expenses",null,null,null,null,{"$f":"P32+K32","v":0},null,null,"Estimated engagement cost after discounts and expenses",null,null,null,null,{"$f":"X32+S32","v":0}]
[null,"Comments",null,null,null,null,null,null,null,"Comments",null,null,null,null,null,null,null,"Comments"]

{"sheet":"Reference 1. Resources","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reference 2. Expenses","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Reference 3. Discount","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Aux","index":5,"n_rows":5,"n_cols":24,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Engagement Type","Pricing Model","Capped Rates",null,null,null,null,null,null,null,"Discount Structure",null,null,null,null,null,"Resouce Mix"]
["ICT Consulting","Fixed price",null,"Partner","Director","Senior Manager","Manager","Senior Consultant","Consultant","Analyst",0,0,null,null,null,null,null,"Partner","Director","Senior Manager","Manager","Senior Consultant","Consultant","Analyst"]
[null,"Time and materials - capped","ICT Consulting",3100,2700,2400,2000,1650,1250,950,250000.01,0.02,null,null,null,null,"ICT Consulting",0.06,0.06,0.06,0.2,0.19,0.24,0.19]
[null,"Time and materials - uncapped",null,null,null,null,null,null,null,null,500000.01,0.05]
[null,"Risk/reward - outcome based",null,null,null,null,null,null,null,null,1000000.01,7.0000000000000007E-2]