{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Price Estimate For Services"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Price Estimate For Services","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[16,1,16,6]]}
[]
[]
[null,"Price Estimate for Services "]
[null,{"$f":"NOW()","v":"2010-04-19T17:58:12.860"}]
[null,"Name of Job","Job 1","Job 2","Job 3","Job 4","Job 5"]
[null,"Wage rate per hour",{"v":10,"d":"$10.00"},{"v":22,"d":"$22.00"},{"v":14,"d":"$14.00"},{"v":15,"d":"$15.00"},{"v":19,"d":"$19.00"}]
[null,"Fringe Benefit as a % of wages",{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
[null,"Projected Overhead Cost for Year",{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"}]
[null,"Projected Direct Labor Cost for Year",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"}]
[]
[null,"Hours worked on job",{"v":1.5,"d":"1.50"},{"v":2,"d":"2.00"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"}]
[null,"Direct Labor Cost",{"$f":"IF(SUM(C11,C6),(C11*C6)*(1+C7),\"\")","v":{"v":19.5,"d":"$19.50"}},{"$f":"IF(SUM(D11,D6),(D11*D6)*(1+D7),\"\")","v":{"v":57.2,"d":"$57.20"}},{"$f":"IF(SUM(E11,E6),(E11*E6)*(1+E7),\"\")","v":{"v":27.3,"d":"$27.30"}},{"$f":"IF(SUM(F11,F6),(F11*F6)*(1+F7),\"\")","v":{"v":29.25,"d":"$29.25"}},{"$f":"IF(SUM(G11,G6),(G11*G6)*(1+G7),\"\")","v":{"v":37.050000000000004,"d":"$37.05"}}]
[null,"Overhead Cost",{"$f":"IF(C9>0,C8/C9*C12,\"\")","v":{"v":15.600000000000001,"d":"15.60"}},{"$f":"IF(D9>0,D8/D9*D12,\"\")","v":{"v":45.760000000000005,"d":"45.76"}},{"$f":"IF(E9>0,E8/E9*E12,\"\")","v":{"v":21.840000000000003,"d":"21.84"}},{"$f":"IF(F9>0,F8/F9*F12,\"\")","v":{"v":23.400000000000002,"d":"23.40"}},{"$f":"IF(G9>0,G8/G9*G12,\"\")","v":{"v":29.640000000000004,"d":"29.64"}}]
[null,"Cost of materials for the job",{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"}]
[null,"Total cost",{"$f":"IF(SUM(C12:C14),SUM(C12:C14),\"\")","v":{"v":45.1,"d":"$45.10"}},{"$f":"IF(SUM(D12:D14),SUM(D12:D14),\"\")","v":{"v":112.96000000000001,"d":"$112.96"}},{"$f":"IF(SUM(E12:E14),SUM(E12:E14),\"\")","v":{"v":59.14,"d":"$59.14"}},{"$f":"IF(SUM(F12:F14),SUM(F12:F14),\"\")","v":{"v":62.650000000000006,"d":"$62.65"}},{"$f":"IF(SUM(G12:G14),SUM(G12:G14),\"\")","v":{"v":76.69000000000001,"d":"$76.69"}}]