{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Baiting Calculator","Settings"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":0,"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":"1904"}

{"sheet":"Baiting Calculator","index":0,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[31,3,35,3],[41,3,46,3],[50,3,52,3],[1,8,1,9],[2,8,2,9],[5,8,5,10],[12,2,12,5],[1,2,1,6],[2,2,2,6],[3,2,3,3],[4,2,4,4],[5,2,5,4]]}
[null,"BASIC INFORMATION"]
[null,"Client's Name",0,null,null,null,null,"Job number",0]
[null,"Address",0,null,null,null,null,"Inspection completed",0]
[null,"Date",0,null,null,null,null,"Active termine (Y/N)",0]
[null,"Email",0,null,null,null,null,"Urgency (High/Med/Low) ",0]
[null,"Phone",0,null,null,null,null,"Building type",0]
[null,"Linear meter soil*",55,null,null,null,null,"(House/Commercial/Government/Others)"]
[null,"Linear meter concrete*",15]
[]
[null,"TREATEMENT TO ACTIVE TERMITE (Stage 1)"]
[null,"Amount of AG station required*",3]
[null,"Estimated visitation*",4]
[null,"Termite species","Coptotermes spp"]
[null,"Quantity of bait used*",0.5]
[null,"Distance To and From job site*",30,null,"(*) Required field"]
[]
[null,"TERMITE MANAGEMENT SYSTEM (Stage 2)"]
[null,"Number of In Ground station required",{"$f":"ROUND((C7/3),0)","v":18}]
[null,"Number of In Concrete Station required",{"$f":"ROUND((C8/3),0)","v":5}]
[]
[null,"Monitoring and maintenance of system - Current year"]
[null,"Annual visitation",{"$f":"10-C12","v":6}]
[null,"Timber replacement",0]
[]
[null,"Monitoring and maintenance of system - Following year"]
[null,"Annual visitation",8]
[null,"Timber replacement (pairs)",{"$f":"ROUND(((C7+C8)/3),0)","v":23}]
[]
[null,"BUSINESS PROFITABILITY"]
[null,"TERMITE TREATMENT STAGE 1"]
[null,"Quote to Home Owner (Colony Elimination)*",1100]
[null,"Purchase of Above ground station",{"$f":"+C11*Settings!D4","v":16.5},{"$f":"SUM(C32:C36)","v":268.5}]
[null,"Installation of AG station",{"$f":"(15/60)*C11*Settings!D14","v":22.5}]
[null,"Exterminex™ termite bait",{"$f":"+C14*Settings!D5","v":94.5}]
[null,"Visitation/Inspection cost",{"$f":"+Settings!D15*'Baiting Calculator'!C15*'Baiting Calculator'!C12*Settings!D14","v":120}]
[null,"Fuel",{"$f":"+C12*C15*Settings!D13","v":15}]
[]
[null,"TERMITE MANAGEMENT STAGE 2"]
[null,"Sale of In Ground Station (Home Owner)",{"$f":"+Settings!D19*'Baiting Calculator'!C18","v":1584}]
[null,"Sale of In Concrete Station",{"$f":"+Settings!D20*'Baiting Calculator'!C19","v":550}]
[null,"Visitation & Inspection, charged to home owner",{"$f":"IF(+C39=0,0,+Settings!D16*'Baiting Calculator'!C22)","v":660}]
[null,"Cost of IG station",{"$f":"IF(+C39=0,0,+C18*Settings!D6)","v":270},{"$f":"SUM(C42:C47)","v":660.00000000000023}]
[null,"Cost of In Concrete Sation",{"$f":"IF(+C40=0,0,+C19*Settings!D7)","v":60}]
[null,"Install IG station",{"$f":"IF(+C39=0,0,+C18*(0.166666666666667)*Settings!D14)","v":90.000000000000171}]
[null,"Install In Concrete Station",{"$f":"IF(+C40=0,0,+C19*(0.25)*Settings!D14)","v":37.5}]
[null,"Visitation / Inspection",{"$f":"IF(C39=0,0,+C22*Settings!D15*'Baiting Calculator'!C15*Settings!D14)","v":180}]
[null,"Fuel",{"$f":"IF(+C46=0,0,+C22*C15*Settings!D13)","v":22.5}]
[]
[null,"YEAR 2"]
[null,"Renewal of Structural Protection Plan",{"$f":"+C26*Settings!D16","v":880}]
[null,"Visitation / Inspection cost",{"$f":"+C26*Settings!D15*'Baiting Calculator'!C15*Settings!D14","v":240},{"$f":"SUM(C51:C53)","v":326.0625}]
[null,"Fuel",{"$f":"+C26*C15*Settings!D13","v":30}]
[null,"Timber replacement",{"$f":"+Settings!D8*'Baiting Calculator'!C27","v":56.0625}]
[]
[]
[null,"Exterminex Business Plan","Year 1","Year 2"]
[null,"Termite Treatment - Exterminex Bait",{"$f":"+$C$31","v":1100}]
[null,"Maintenance of structure",{"$f":"+C39+C40+C41","v":2794},{"$f":"+C50","v":880}]
[null,"Annual Termite Inspection",{"$f":"+Settings!D21","v":0},{"$f":"+Settings!D22","v":179}]
[null,"Quote to home owners",{"$f":"SUM(C57:C58)","v":3894},{"$f":"+D59+D58","v":1059}]
[null,"Total expenses",{"$f":"+D32+D42","v":928.50000000000023},{"$f":"+D51","v":326.0625}]
[null,"Net Profit",{"$f":"+C60-C61","v":2965.5},{"$f":"+D60-D61","v":732.9375}]
[null,null,{"$f":"+C62/C60","v":0.76155624036979974},{"$f":"+D62/D58","v":0.83288352272727273}]
[]
[null,null,null,"End"]

{"sheet":"Settings","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Cost of working materials:"]
[null,null,"Above Ground Station/pc",5.5]
[null,null,"Exterminex bait/kg",189]
[null,null,"In Ground bait station (RTI)",{"$f":"240/16","v":15}]
[null,null,"In Conctere station/pc",12]
[null,null,"Timber replacement (pair)",{"$f":"39/16","v":2.4375}]
[]
[null,null,"Variable cost:"]
[null,null,"Fuel price/liter",1.5]
[null,null,"Mileage (km/liter)",12]
[null,null,"Cost per km",{"$f":"+D11/D12","v":0.125}]
[null,null,"Labour cost per hour",30]
[null,null,"Travel time (hour/km)",{"$f":"(30/15)/60","v":3.3333333333333333E-2}]
[null,null,"Charge per visit",110]
[]
[null,null,"Materials/Services sold to Home Owner:"]
[null,null,"In Ground bait station (RTI)",88]
[null,null,"In Conctere station",110]
[null,null,"Termite Inspection (Prior to Install)",0]
[null,null,"Annual Termite Inspection (Year 2)",179]