{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Bid Summary","Team","Experience","Deliverables","Costing"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":9,"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":"Bid Summary","index":0,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[[24,9,27,10],[23,1,23,10],[24,1,27,8],[20,1,20,4],[9,1,9,2],[16,1,16,4],[17,1,17,4],[19,1,19,4],[18,1,18,4],[6,1,6,2],[14,1,14,4],[14,8,14,10],[11,1,11,2],[15,1,15,4],[1,6,4,10],[6,3,6,5],[9,3,9,10],[11,3,11,10],[6,6,6,8],[6,9,6,10],[7,6,7,8],[41,1,41,4],[30,1,30,6],[31,1,31,6],[42,1,42,4],[43,1,43,4],[36,1,36,4],[33,1,34,10],[36,6,38,10],[37,1,40,4]]}
[]
[null,null,null,null,null,null,"ANNEXURE B\nSummary"]
[]
[]
[]
[]
[null,"Bid ref. number:",null,"DWYPD 01 - 2022/23",null,null,"Expected project start date:"]
[null,null,null,null,null,null,"Expected duration (Months)"]
[]
[null,"Description of bid:",null,"Outcomes Evaluation on the impact of age appropriate comprehensive sexuality education (CSE) on learners in South African Public Schools"]
[]
[null,"Name of bidder:"]
[]
[null,null,null,null,null,"Minimum","Score"]
[null,"Total number of team members",null,null,null,0,{"$f":"Team!T2","v":0},null,"Indicative project time frames"]
[null,"% of time allocated to Black PDIs",null,null,null,0.3,{"$f":"IFERROR(Team!S14,0)","v":0},null,"Start","End","Duration",null,null,{"$f":"IFERROR(IF(G16<F16,1,0),0)","v":1},{"$f":"IFERROR(IF(G16>=F16,1,0),0)","v":0}]
[null,"% of time allocated to Women",null,null,null,0.4,{"$f":"IFERROR(Team!S10,0)","v":0},null,{"$f":"Deliverables!E26","v":"00:00:00"},{"$f":"Deliverables!E27","v":"00:00:00"},{"$f":"Deliverables!E28","v":0},null,null,{"$f":"IFERROR(IF(G17<F17,1,0),0)","v":1},{"$f":"IFERROR(IF(G17>=F17,1,0),0)","v":0}]
[null,"% of time allocated to Youth",null,null,null,0.25,{"$f":"IFERROR(Team!N22,0)","v":0},null,null,"Months",{"$f":"K17/30","v":0},null,null,{"$f":"IFERROR(IF(G18<F18,1,0),0)","v":1},{"$f":"IFERROR(IF(G18>=F18,1,0),0)","v":0}]
[null,"% of time allocated to Disability",null,null,null,0.05,{"$f":"IFERROR(Team!S11,0)","v":0},null,null,null,null,null,null,{"$f":"IFERROR(IF(G19<F19,1,0),0)","v":1},{"$f":"IFERROR(IF(G19>=F19,1,0),0)","v":0}]
[null,"% Empowerment spend",null,null,null,0.3,{"$f":"Team!U20","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"IFERROR(IF(G20<F20,1,0),0)","v":0},{"$f":"IFERROR(IF(G20>=F20,1,0),0)","v":0}]
[null,"Empowerment score (functional criteria)",null,null,null,3,{"$f":"IF(N21>0,1,IF(O22>2,4,3))","v":1},null,null,null,null,null,null,{"$f":"SUM(N16:N20)","v":4},{"$f":"SUM(O16:O20)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O21>0,O21,0)","v":0}]
[]
[null,"TOTAL BID PRICE  incl. VAT"]
[null,"1. Total price required to produce/deliver all goods/services included in the ToR.\n2. Please ensure that this price matches the price indicated on SBD 1.\n3. This price will be used for PPPFA comparison purposes.",null,null,null,null,null,null,null,{"$f":"Costing!C31","v":0}]
[]
[]
[]
[]
[]
[null,"Orange coloured cells to be completed by DWYPD"]
[null,"Yellow coloured cells to be completed by bidder"]
[]
[null,"Bidders may only complete yellow cells.  Any changes to formulas in this spread sheet will invalidate the bid"]
[]
[]
[null,"Confirmation by bidder",null,null,null,null,"Bidders must print and sign all five worksheets (Summary and Annexures B1 to B4)"]
[null,"Signature"]
[]
[]
[]
[null,"Name:"]
[null,"Designation:"]
[null,"Date:"]

{"sheet":"Team","index":1,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,10],[22,1,25,1],[21,2,25,3],[1,4,1,10],[1,0,1,3]]}
["Annexure B1: Proposed Team",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(NOW())","v":2023},null,null,null,null,null,"Team count"]
[{"$f":"\"Bidder Name: \"&'Bid Summary'!D12","v":"Bidder Name: "},null,null,null,{"$f":"\"Bid Ref: \"&'Bid Summary'!D7","v":"Bid Ref: DWYPD 01 - 2022/23"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Time A",{"$f":"COUNTIF(J4:J19,\">0\")","v":0}]
["#","Name of team member","Role (As specified in ToR)","Qualifications (list)","Race","Gen","Disability","Year Born","Daily rate","Days","Exp",null,null,"Age",null,"Afr","African",{"$f":"SUMIF($E$4:$E$19,P3,$J$4:$J$19)","v":0},{"$f":"R3/$J$20","v":{"$error":"#DIV/0!"}},null,"PDI Spend","All Spend"]
[1,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB4","v":0},{"$f":"Experience!K5","v":0},null,null,{"$f":"IF(H4>0,$N$1-H4,0)","v":0},null,"Ind","Indian",{"$f":"SUMIF($E$4:$E$19,P4,$J$4:$J$19)","v":0},{"$f":"R4/$J$20","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(OR(E4=$P$3,E4=$P$4,E4=$P$5),I4*J4,0)","v":0},{"$f":"I4*J4","v":0}]
[2,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB5","v":0},{"$f":"Experience!K6","v":0},null,null,{"$f":"IF(H5>0,$N$1-H5,0)","v":0},null,"Col","Coloured",{"$f":"SUMIF($E$4:$E$19,P5,$J$4:$J$19)","v":0},{"$f":"R5/$J$20","v":{"$error":"#DIV/0!"}},null,0,{"$f":"I5*J5","v":0}]
[3,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB6","v":0},{"$f":"Experience!K7","v":0},null,null,{"$f":"IF(H6>0,$N$1-H6,0)","v":0},null,"Wht","White",{"$f":"SUMIF($E$4:$E$19,P6,$J$4:$J$19)","v":0},{"$f":"R6/$J$20","v":{"$error":"#DIV/0!"}},null,0,0]
[4,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB7","v":0},{"$f":"Experience!K8","v":0},null,null,0,null,"Other","Other",{"$f":"SUMIF($E$4:$E$19,P7,$J$4:$J$19)","v":0},{"$f":"R7/$J$20","v":{"$error":"#DIV/0!"}},null,0,0]
[5,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB8","v":0},{"$f":"Experience!K9","v":0},null,null,0,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB9","v":0},{"$f":"Experience!K10","v":0},null,null,{"$f":"IF(H9>0,$N$1-H9,0)","v":0},null,"M","Male",{"$f":"SUMIF($F$4:$F$19,P9,$J$4:$J$19)","v":0},{"$f":"R9/$J$20","v":{"$error":"#DIV/0!"}},null,0,0]
[7,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB10","v":0},{"$f":"Experience!K11","v":0},null,null,{"$f":"IF(H10>0,$N$1-H10,0)","v":0},null,"F","Female",{"$f":"SUMIF($F$4:$F$19,P10,$J$4:$J$19)","v":0},{"$f":"R10/$J$20","v":{"$error":"#DIV/0!"}},null,0,0]
[8,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB11","v":0},{"$f":"Experience!K12","v":0},null,null,0,null,"DisY","Yes",{"$f":"SUMIF($G$4:$G$19,P11,$J$4:$J$19)","v":0},{"$f":"R11/$J$20","v":{"$error":"#DIV/0!"}},null,0,0]
[9,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB12","v":0},{"$f":"Experience!K13","v":0},null,null,0,null,"DisN","No",{"$f":"SUMIF($G$4:$G$19,P12,$J$4:$J$19)","v":0},{"$f":"R12/$J$20","v":{"$error":"#DIV/0!"}},null,0,0]
[10,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB13","v":0},{"$f":"Experience!K14","v":0},null,null,0,null,null,null,null,null,null,0,0]
[11,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB14","v":0},{"$f":"Experience!K15","v":0},null,null,0,null,null,null,"PDI %",{"$f":"SUM(S3:S5)","v":{"$error":"#DIV/0!"}},null,0,0]
[12,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB15","v":0},{"$f":"Experience!K16","v":0},null,null,{"$f":"IF(H15>0,$N$1-H15,0)","v":0},null,null,null,null,null,null,0,0]
[13,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB16","v":0},{"$f":"Experience!K17","v":0},null,null,0,null,null,null,null,null,null,0,0]
[14,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB17","v":0},{"$f":"Experience!K18","v":0},null,null,0,null,null,null,null,null,null,0,0]
[15,null,null,null,null,null,null,null,null,{"$f":"Deliverables!AB18","v":0},{"$f":"Experience!K19","v":0},null,null,0,null,null,null,null,null,null,0,0]
["O","Other","Other","Various",null,null,null,null,null,{"$f":"Deliverables!AB19","v":0},{"$f":"Experience!K20","v":0},null,null,0,null,null,null,null,null,"PDI",{"$f":"SUM(U4:U18)","v":0},{"$f":"SUM(V4:V18)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J4:J19)","v":0},null,null,null,{"$f":"AVERAGEIF(N4:N19,\"<>0\")","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"% PDI",{"$f":"U19/V19","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"<36",{"$f":"COUNTIFS(N4:N19,\"<36\",N4:N19,\">0\")","v":0}]
[null,"Bidder signature","Enter the details of the 15 team members with the most time allocated to executing the required deliverables. Attach copies of qualifications to bid.  Please ensure that race/gender/Disability/birth year are entered correctly",null,null,null,null,null,null,null,null,null,"<36%",{"$f":"N21/T2","v":{"$error":"#DIV/0!"}}]
[null,"Signature"]

{"sheet":"Experience","index":2,"n_rows":51,"n_cols":11,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,2],[1,3,1,5],[3,9,3,10],[50,1,53,1],[49,3,53,5]]}
["Annexure B2: Summary of past experience of team members",null,null,null,null,null,null,"Date Format: YYYY/MM/DD"]
[{"$f":"\"Bidder Name: \"&'Bid Summary'!D12","v":"Bidder Name: "},null,null,{"$f":"\"Bid Ref: \"&'Bid Summary'!D7","v":"Bid Ref: DWYPD 01 - 2022/23"}]
["Name of team member","Project","Client name (attach details of contact persons)","Project Start","Project end","Value"]
[null,null,null,null,null,null,null,null,null,"Team (Annexure B2)"]
[null,null,null,null,null,null,null,null,1,{"$f":"Team!B4","v":0},{"$f":"COUNTIF($A$4:$A$48,J5)","v":0}]
[null,null,null,null,null,null,null,null,2,{"$f":"Team!B5","v":0},{"$f":"COUNTIF($A$4:$A$48,J6)","v":0}]
[null,null,null,null,null,null,null,null,3,{"$f":"Team!B6","v":0},0]
[null,null,null,null,null,null,null,null,4,{"$f":"Team!B7","v":0},0]
[null,null,null,null,null,null,null,null,5,{"$f":"Team!B8","v":0},0]
[null,null,null,null,null,null,null,null,6,{"$f":"Team!B9","v":0},0]
[null,null,null,null,null,null,null,null,7,{"$f":"Team!B10","v":0},0]
[null,null,null,null,null,null,null,null,8,{"$f":"Team!B11","v":0},0]
[null,null,null,null,null,null,null,null,9,{"$f":"Team!B12","v":0},0]
[null,null,null,null,null,null,null,null,10,{"$f":"Team!B13","v":0},0]
[null,null,null,null,null,null,null,null,11,{"$f":"Team!B14","v":0},0]
[null,null,null,null,null,null,null,null,12,{"$f":"Team!B15","v":0},0]
[null,null,null,null,null,null,null,null,13,{"$f":"Team!B16","v":0},0]
[null,null,null,null,null,null,null,null,14,{"$f":"Team!B17","v":0},0]
[null,null,null,null,null,null,null,null,15,{"$f":"Team!B18","v":0},0]
[null,null,null,null,null,null,null,null,"O",{"$f":"Team!B19","v":"Other"},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bidder signature",null,"Attach verifiable / contactable references to bid"]
[null,"Signature"]

{"sheet":"Deliverables","index":3,"n_rows":33,"n_cols":47,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,26,2,27],[26,1,29,1],[25,6,29,21],[0,0,0,6],[1,7,1,22],[1,0,1,3],[1,4,1,6]]}
["Annexure B3: High level project plan - Allocation of time to team members",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"O",null,1]
[{"$f":"\"Bidder Name: \"&'Bid Summary'!D12","v":"Bidder Name: "},null,null,null,{"$f":"\"Bid Ref: \"&'Bid Summary'!D7","v":"Bid Ref: DWYPD 01 - 2022/23"},null,null,"Days allocated per team member",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF(Team!$A$4:$A$19,AD$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AE$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AF$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AG$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AH$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AI$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AJ$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AK$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AL$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AM$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AN$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AO$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AP$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AQ$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AR$1,Team!$I$4:$I$19)","v":0},{"$f":"SUMIF(Team!$A$4:$A$19,AS$1,Team!$I$4:$I$19)","v":0}]
["#","Deliverable / Activities description","Person Days","Start","End","Duration (Days)","Staff Cost \n(Incl. VAT)",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"O",null,null,null,"Team (Annexure B2)"]
[1,null,{"$f":"SUM(H4:W4)","v":0},{"$f":"'[1]Bid Summary'!J7","v":"00:00:00"},null,{"$f":"E4-D4","v":0},{"$f":"SUM(AD4:AS4)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A4","v":1},{"$f":"Team!B4","v":0},{"$f":"SUMIF($H$3:$W$3,A4,$H$24:$W$24)","v":0},null,{"$f":"H4*AD$2","v":0},{"$f":"I4*AE$2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AD4:AS4)","v":0}]
[2,null,{"$f":"SUM(H5:W5)","v":0},null,null,{"$f":"E5-D5","v":0},{"$f":"SUM(AD5:AS5)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A5","v":2},{"$f":"Team!B5","v":0},{"$f":"SUMIF($H$3:$W$3,A5,$H$24:$W$24)","v":0},null,{"$f":"H5*AD$2","v":0},{"$f":"I5*AE$2","v":0},{"$f":"J5*AF$2","v":0},{"$f":"K5*AG$2","v":0},{"$f":"L5*AH$2","v":0},{"$f":"M5*AI$2","v":0},{"$f":"N5*AJ$2","v":0},{"$f":"O5*AK$2","v":0},{"$f":"P5*AL$2","v":0},{"$f":"Q5*AM$2","v":0},{"$f":"R5*AN$2","v":0},{"$f":"S5*AO$2","v":0},{"$f":"T5*AP$2","v":0},{"$f":"U5*AQ$2","v":0},{"$f":"V5*AR$2","v":0},{"$f":"W5*AS$2","v":0},null,{"$f":"SUM(AD5:AS5)","v":0}]
[3,null,{"$f":"SUM(H6:W6)","v":0},null,null,{"$f":"E6-D6","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A6","v":3},{"$f":"Team!B6","v":0},{"$f":"SUMIF($H$3:$W$3,A6,$H$24:$W$24)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[4,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A7","v":4},{"$f":"Team!B7","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[5,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A8","v":5},{"$f":"Team!B8","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[6,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A9","v":6},{"$f":"Team!B9","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[7,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A10","v":7},{"$f":"Team!B10","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[8,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A11","v":8},{"$f":"Team!B11","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[9,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A12","v":9},{"$f":"Team!B12","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[10,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A13","v":10},{"$f":"Team!B13","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[11,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A14","v":11},{"$f":"Team!B14","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[12,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A15","v":12},{"$f":"Team!B15","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[13,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A16","v":13},{"$f":"Team!B16","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[14,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A17","v":14},{"$f":"Team!B17","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[15,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A18","v":15},{"$f":"Team!B18","v":0},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[16,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Team!A19","v":"O"},{"$f":"Team!B19","v":"Other"},0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[17,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[18,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[19,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[20,null,0,null,null,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0]
[null,null,{"$f":"SUM(C4:C23)","v":0},null,null,{"$f":"SUM(F4:F23)","v":0},{"$f":"SUM(G4:G23)","v":0},{"$f":"SUM(H4:H23)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(U4:U23)","v":0},0,0]
[]
[null,"Bidder signature",null,"Start",{"$f":"MIN(D4:D23)","v":"00:00:00"},null,"The start date for bid purposes is the expected date of award as indicated by DWYPD.  The start date for contract management purposes will be the actual date of award of the bid.  "]
[null,"Signature",null,"End",{"$f":"MAX(E4:E23)","v":"00:00:00"}]
[null,null,null,"Duration",{"$f":"IF(E27-E26<0,0,E27-E26)","v":0}]
[]
[]
[]
[]
[null,"NB - inception not more than 10%"]

{"sheet":"Costing","index":4,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2],[33,2,36,2],[2,0,2,2],[30,0,30,1],[5,0,5,1],[13,0,13,1]]}
["Annexure B4: Costing of Proposal"]
[{"$f":"\"Bidder Name: \"&'Bid Summary'!D12","v":"Bidder Name: "}]
[{"$f":"\"Bid Ref: \"&'Bid Summary'!D7","v":"Bid Ref: DWYPD 01 - 2022/23"}]
["#","Description","R (Incl. VAT)"]
[]
["PART 1: COSTING OF SERVICES",null,{"$f":"SUM(C7:C12)","v":0}]
[1,"Fully inclusive resource cost for all deliverables (B3)",{"$f":"Deliverables!G24","v":0}]
[2,"Travel and subsistence cost"]
[3,"Printing / stationery cost"]
[4,"Communication cost"]
[5,"Other"]
[6,"Other"]
[]
["PART 2: COSTING OF GOODS (Leave blank if not required)",null,{"$f":"SUM(C15:C29)","v":0}]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[]
["TOTAL BID PRICE (Part 1 + Part 2) incl. VAT\n1. This is the total price required to produce and deliver all goods / services included in the ToR.\n2. Please ensure that this price matches the price indicated on SBD 1.\n3. This price will be used for PPPFA comparison purposes.\n",null,{"$f":"C6+C14","v":0}]
[]
[null,null,"Bidder signature"]
[null,null,"Signature"]