{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Deliverables","Costing"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Deliverables","index":0,"n_rows":33,"n_cols":47,"rows_kept":33,"cut":false,"hidden":true,"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: \"&#REF!","v":{"$error":"#REF!"}},null,null,null,{"$f":"\"Bid Ref: \"&#REF!","v":{"$error":"#REF!"}},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(#REF!,AD$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AE$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AF$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AG$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AH$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AI$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AJ$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AK$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AL$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AM$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AN$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AO$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AP$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AQ$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AR$1,#REF!)","v":{"$error":"#REF!"}},{"$f":"SUMIF(#REF!,AS$1,#REF!)","v":{"$error":"#REF!"}}]
["#","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":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"E4-D4","v":{"$error":"#REF!"}},{"$f":"SUM(AD4:AS4)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUMIF($H$3:$W$3,A4,$H$24:$W$24)","v":0},null,{"$f":"H4*AD$2","v":{"$error":"#REF!"}},{"$f":"I4*AE$2","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$f":"SUM(AD4:AS4)","v":{"$error":"#REF!"}}]
[2,null,{"$f":"SUM(H5:W5)","v":0},null,null,{"$f":"E5-D5","v":0},{"$f":"SUM(AD5:AS5)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUMIF($H$3:$W$3,A5,$H$24:$W$24)","v":0},null,{"$f":"H5*AD$2","v":{"$error":"#REF!"}},{"$f":"I5*AE$2","v":{"$error":"#REF!"}},{"$f":"J5*AF$2","v":{"$error":"#REF!"}},{"$f":"K5*AG$2","v":{"$error":"#REF!"}},{"$f":"L5*AH$2","v":{"$error":"#REF!"}},{"$f":"M5*AI$2","v":{"$error":"#REF!"}},{"$f":"N5*AJ$2","v":{"$error":"#REF!"}},{"$f":"O5*AK$2","v":{"$error":"#REF!"}},{"$f":"P5*AL$2","v":{"$error":"#REF!"}},{"$f":"Q5*AM$2","v":{"$error":"#REF!"}},{"$f":"R5*AN$2","v":{"$error":"#REF!"}},{"$f":"S5*AO$2","v":{"$error":"#REF!"}},{"$f":"T5*AP$2","v":{"$error":"#REF!"}},{"$f":"U5*AQ$2","v":{"$error":"#REF!"}},{"$f":"V5*AR$2","v":{"$error":"#REF!"}},{"$f":"W5*AS$2","v":{"$error":"#REF!"}},null,{"$f":"SUM(AD5:AS5)","v":{"$error":"#REF!"}}]
[3,null,{"$f":"SUM(H6:W6)","v":0},null,null,{"$f":"E6-D6","v":0},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUMIF($H$3:$W$3,A6,$H$24:$W$24)","v":0},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[4,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[5,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[6,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[7,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[8,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[9,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[10,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[11,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[12,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[13,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[14,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[15,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[16,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},0,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[17,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[18,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[19,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[20,null,0,null,null,0,{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[null,null,{"$f":"SUM(C4:C23)","v":0},null,null,{"$f":"SUM(F4:F23)","v":{"$error":"#REF!"}},{"$f":"SUM(G4:G23)","v":{"$error":"#REF!"}},{"$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":{"$error":"#REF!"}},null,"The start date for bid purposes is the expected date of award as indicated by DPME.  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":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,"NB - inception not more than 10%"]

{"sheet":"Costing","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[25,8,28,8],[2,0,2,8],[22,0,22,1],[5,0,5,1],[12,0,12,1]]}
["Annexure B3: Costing of Proposal"]
[{"$f":"\"Bidder Name: \"&#REF!","v":{"$error":"#REF!"}}]
[{"$f":"\"Bid Ref: \"&#REF!","v":{"$error":"#REF!"}}]
["#","Description","Unit","Rate","Total","Year 1","Year 2","Year 3","R (Incl. VAT)"]
[]
["PART 1: COSTING OF SERVICES",null,null,null,null,null,null,null,{"$f":"SUM(I7:I12)","v":0}]
[1,"A website and a call centre are available 24/7 (and 365 days in a year). The call centre has a toll free number, and call back service and the service should be provided in 11 official languages.",1]
[2,"An interactive health and wellness website",1]
[3,"Provide monthly desk drops on financial management, legal services and health and wellness. Telephone counselling for financial management and legal services / advice.",1]
[4,"Monitoring and evaluation by providing monthly and quarterly reports on client usage and organizational health trends with recommendations on interventions to improve the health and wellbeing of DPME employees.",1]
[5,"Fixed monthly fee",1,null,{"$f":"SUM(C11*D11)","v":0}]
[6,"e-Care programme to enhance and accelerate access to services ( online wellness programme )",1]
["PART 2: COSTING OF SERVICES",null,null,null,null,null,null,null,{"$f":"SUM(I14:I21)","v":0}]
[1,"Face-to-face counselling for employees and family members. \nFamily members should attend group sessions. \nDPME will use a “per session rate” to pay for this services after they have been rendered. \n",50,null,{"$f":"SUM(C14*D14)","v":0}]
[2,"Critical incident service (trauma and onsite group counselling) 50 employees in each group per session ( X4 Per Annum) quarterly",4,null,0]
[3,"Conduct 4 wellness workshops for different pillars per annum (Half day). Costs must specify according to different experts:                                       Travelling cost per kilometre and hand-outs  to be included    General expert X 4 session per annum\nProfessional Health expert (specialist) X 4 session per annum\nProfessional Legal expert (specialist) X 4 session per annum\nProfessional Finance expert (specialist) X 4 session per annum\n",4,null,0]
[4,"Absenteeism and incapacity consultancy",50,null,0]
[5,"Lifestyle & Financial awareness workshops ( DPME premises )\nHIV/AIDS and TB Management X 4 Per annummplement four EHW awareness campaigns per year in line with the National Health Calendar and DPME Health and Wellness calendar.\n",4,null,0]
[6,"Provide counselling sessions for employees infected and \naffected by HIV/AIDS (3 sessions per person)\n",50,null,0]
[7,"Conduct four Health screenings per year",4,null,0]
[8,"Transformation campaigns and workshops                                                   Implement transformation awareness campaigns 4 per year regarding Gender mainstreaming, disability mainstreaming youth and other related matters",4,null,0]
[]
["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,null,null,null,null,null,null,{"$f":"I6+I13","v":0}]
[]
[null,null,null,null,null,null,null,null,"Bidder signature"]
[null,null,null,null,null,null,null,null,"Signature"]