{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","BidSchedule"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":16,"n_cols":13,"rows_kept":16,"merged":[[0,4,0,5],[1,4,1,8],[11,1,11,4],[12,1,12,4],[12,12,13,18],[13,1,13,3],[14,1,14,3],[15,1,15,3],[15,4,15,5]]}
[null,"\nBidding Schedule LOT A"]
[{"$nulls":4},"Name of Offer as identified on the cover page. Full legal name of business submitte the offer"]
[{"$nulls":12},"1) Enter your company name here"]
[null,"Facility/Property","Quantity","Unit of Measure","Monthly Monitoring Fee Unit Price","Monthly Maintenance Fee Unit Price","Total Monthly Monitoring & Maintenance Fee per each Location","Total Extended Price Per Month (Qty F5 x Total per locationJ5","Total Extended Price  x 12 Months"]
[null,"Monthly Security Alarm System Monitoring & Maintenance per each location.",72,"each",0,0,{"$f":"SUM(E5:F5)","v":0},{"$f":"SUM(C5*G5)","v":0},{"$f":"SUM(H5*12)","v":0}]
[]
[null,"Labor Rate for Unscheduled non-maintenance repairs and capital projects","Estimated Quantity","Unit of Measure","Unit Price per Hour","Total Extended Unit Price",{"$nulls":6},"2) Enter your unit price per column in each shaded cell ."]
[null,"LABOR-Hourly Rate - Regular - (Monday-Friday 8 am - 5 pm)  Unit Price",150,"Hour",0,{"$f":"SUM(C8*E8)","v":0}]
[null,"LABOR - Hourly Rate -Overtime - Maint/Repair (Monday-Friday 5 pm -12  am)  Unit Price",10,"Hour",0,{"$f":"SUM(C9*E9)","v":0}]
[]
[]
[null,"Calculation for Total Evaluated Amount"]
[null,"NOTE:  THE BELOW CALCULATIONS AUTOMATICALLY POPULATE BASED ON THE INPUTS ABOVE.",{"$nulls":10},"3.The spreadsheet will automatically calculate the \"Total Evaluated Amount\" in the  cells at the bottom of the worksheet.  Do not attempt to modify bid schedule."]
[null,"Total Extended Price  for Monthly Security Alarm System Monitoring & Maintenance per each location x 12 Months",null,null,{"$f":"SUM(I5+0)","v":0}]
[null,"Estimated Extended Labor Amount Total",null,null,{"$f":"SUM(F8+F9+0)","v":0}]
[null,"TOTAL EVALUATED AMOUNT (Include amount on page 32 of solicitation, VIII.BIDDING SCHEDULE/PRICE-BUSINESS PROPOSAL)",null,null,{"$f":"SUM(E14:E15)","v":0}]

{"sheet":"BidSchedule","index":1,"n_rows":16,"n_cols":9,"rows_kept":16,"merged":[[0,4,0,5],[1,4,1,8],[11,1,11,4],[12,1,12,4],[13,1,13,3],[14,1,14,3],[15,1,15,3],[15,4,15,5]]}
[null,"\nBidding Schedule LOT A"]
[{"$nulls":4},"Name of Offer as identified on the cover page. Full legal name of business submitte the offer"]
[]
[null,"Facility/Property","Quantity","Unit of Measure","Monthly Monitoring Fee Unit Price","Monthly Maintenance Fee Unit Price","Total Monthly Monitoring & Maintenance Fee per each Location","Total Extended Price Per Month (Qty F5 x Total per locationJ5","Total Extended Price  x 12 Months"]
[null,"Monthly Security Alarm System Monitoring & Maintenance per each location.",72,"each",0,0,{"$f":"SUM(E5:F5)","v":0},{"$f":"SUM(C5*G5)","v":0},{"$f":"SUM(H5*12)","v":0}]
[]
[null,"Labor Rate for Unscheduled non-maintenance repairs and capital projects","Estimated Quantity","Unit of Measure","Unit Price per Hour","Total Extended Unit Price"]
[null,"LABOR-Hourly Rate Hours- Regular - (Monday-Friday 8 am - 5 pm)  Unit Price",150,"Hour",0,{"$f":"SUM(C8*E8)","v":0}]
[null,"LABOR - Hourly Rate -Overtime - Maint/Repair (Monday-Friday 5 pm -12  am) or weekends  Unit Price",10,"Hour",0,{"$f":"SUM(C9*E9)","v":0}]
[]
[]
[null,"Calculation for Total Evaluated Amount"]
[null,"NOTE:  THE BELOW CALCULATIONS AUTOMATICALLY POPULATE BASED ON THE INPUTS ABOVE."]
[null,"Total Extended Price  for Monthly Security Alarm System Monitoring & Maintenance per each location x 12 Months",null,null,{"$f":"SUM(I5+0)","v":0}]
[null,"Estimated Extended Labor Rate for Unscheduled non-maintenance repairs and capital projects",null,null,{"$f":"SUM(F8+F9+0)","v":0}]
[null,"TOTAL EVALUATED AMOUNT (Include amount on page 32 of solicitation, VIII.BIDDING SCHEDULE/PRICE-BUSINESS PROPOSAL)",null,null,{"$f":"SUM(E14:E15)","v":0}]