{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Debt collection GEMMA  -Tender"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Debt collection GEMMA  -Tender","index":0,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[0,2,0,6],[1,0,1,6]]}
["NCOU & NWOU",null,"DEBT COLLECTION FOR GEMMA CLUSTER FOR A PERIOD OF 36 MONTHS ON AN AS AND WHEN REQUIRED BASIS"]
["***NOTE: Insert rates in the highlighted column, Where the unit rate is 0%,  insert your proposed rate in (percentage %)"]
["Item No.","Description","Unit of Measure","Estimated Quantity","Estimated Recovered Amount","Unit Rate"," Total Price"]
[1,"Stopped (Non-Active ) Accounts"]
[null,"Payment is by way of commission only"]
["1.1","LPU/SPU stopped (Non -Active) accounts, commission will be paid upon succesful recoveries of debt, on a percentage of the amount recovered from the debtor. ","%",34000,{"v":60000000,"d":"R60,000,000.00"},{"v":0,"d":"0%"},{"$f":"E6*F6","v":0}]
[2,"Active Accounts"]
[null,"Payment is by way of commission only"]
[2.1,"LPU/SPU  (Active) accounts, commission will be paid upon succesful recoveries of debt, on a percentage of the amount recovered from the debtor.","%",34000,{"v":40000000,"d":"R40,000,000.00"},{"v":0,"d":"0%"},{"$f":"E9*F9","v":0}]
[3,"Legal Collection"]
[3.1,"Payment for standard charges as gazetted for the “Proceedings of Magistrate/High Courts of South Africa” "]
["3.1.1","Application for costs on notice (including appearance in court)","each",34000,null,0,{"$f":"D12*F12","v":0}]
["3.1.2","Obtaining a certified copy of a judgment","each",34000,null,0,{"$f":"D13*F13","v":0}]
["3.1.3","Affidavit or certificate by the judgment creditor or [his or her] the Iiudament creditor's attorney","each",34000,null,0,0]
[null,"Subtotal",{"$nulls":4},{"$f":"G6+G9+G12+G13+G14","v":0}]
[null,"VAT",{"$nulls":4},{"$f":"G15*0.15","v":0}]
[null,"Total (Incl.VAT)",{"$nulls":4},{"$f":"G15+G16","v":0}]
[]
[null,"Notes"]
[null,"payment will be made  on commission "]