{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["DataInput","PrintBlankPg1","PrintBlankPg2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":9,"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","formulas":"cached_only"}

{"sheet":"DataInput","index":0,"n_rows":38,"n_cols":40,"rows_kept":38,"cut":false,"hidden":false,"merged":[[26,34,26,35],[25,32,26,33],[24,36,24,37],[25,36,26,37],[25,34,25,35],[25,38,26,38],[35,27,35,28],[36,25,37,26],[36,27,37,28],[31,27,31,28],[34,27,34,28],[25,39,26,39],[36,30,37,30],[36,32,37,32],[36,33,36,35],[37,33,37,35],[36,29,37,29],[30,36,30,37],[31,36,31,37],[27,36,27,37],[28,36,28,37],[29,36,29,37],[26,27,26,28],[6,1,7,2],[6,0,7,0],[16,1,16,3],[18,1,18,3],[9,1,9,10],[10,1,10,10],[11,1,11,20],[8,1,8,10],[17,1,17,3],[19,36,19,37],[20,27,20,28],[20,36,20,37],[23,32,23,35],[21,36,21,37],[19,27,19,28],[20,34,20,35],[19,32,21,32],[21,27,21,28],[16,27,16,28],[16,36,16,37],[17,27,17,28],[17,36,17,37],[18,27,18,28],[18,36,18,37],[13,36,13,37],[14,27,14,28],[14,36,14,37],[15,27,15,28],[15,36,15,37],[13,27,13,28],[10,36,10,37],[11,27,11,28],[11,36,11,37],[12,27,12,28],[12,36,12,37],[10,27,10,28],[6,36,6,38],[8,27,8,28],[8,36,8,37],[9,27,9,28],[9,36,9,37],[6,24,6,33],[2,30,2,33],[4,36,4,38],[5,24,5,29],[5,30,5,33],[5,36,5,38],[4,24,4,29],[4,30,4,33],[34,24,36,24],[19,1,19,3],[21,1,21,3],[20,1,20,3],[22,1,23,3],[2,34,2,39],[3,24,3,29],[3,30,3,33],[3,36,3,38],[2,24,2,29],[30,27,30,28],[33,27,33,28],[29,27,29,28],[32,27,32,28],[22,0,23,0],[19,24,21,24],[28,27,28,28],[24,27,24,28],[27,27,27,28],[25,27,25,28]],"flags":["formulas_cached_only"]}
["Enter header information in blue boxes below."]
["Enter Equipment, Material & Labor in form to the right. For subcontractor's Equipment & Labor, place",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COUNTY OF VENTURA - PUBLIC WORKS AGENCY",null,null,null,null,"DAILY EXTRA WORK REPORT"]
["an asterisk in the column to the right of the formulas.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Spec No.: ",null,null,null,null,null,"CCO No. 0",null,null,null,"Date Report Completed: 01/00/1900"]
["A separate page must be used for each sub each day.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Project Name: ",null,null,null,null,null,"Report No. 0",null,null,null,"Previous Report",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Prime Contractor: ",null,null,null,null,null,"Sheet 0 of 0",null,null,null,"This Report",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Subcontractors: ",null,null,null,null,null,"Date Work Performed: 01/00/1900",null,null,null,"Total to Date",null,0]
[" Spec No.: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Description of Work: ",null,null,null,null,null,null,null,null,null,"Total Authorized",null,0]
[]
[" Project Name: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUIPMENT (Type, Model)","Hrs","Rate","     Prime",null,"      Sub","*",null,"LABOR (Class & Name)","Hrs","*Rate","**Mult","      Prime",null,"      Sub","*"]
[" Prime Contractor: ",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,0,null,0,null,null,null,null,null,null,0,null,0]
[" Subcontractors: ",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,0,null,0,null,null,null,null,null,null,0,null,0]
[" Description of Work: ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["CCO No. ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["Report No. ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["Sheet ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["Sheet of ",null,null,null,null,null,null,null,"Scroll Right to fill in form. ===>>>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,null,0,null,0]
["Date Work Performed: ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["Date Report Completed: ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["Previous Report: ",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,0,null,0,null,null,null,null,null,null,0,null,0]
["This Report: ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. See Specifications \n           §3-3.2.2(c)&(e)\n2. Furnish Invoices for rentals.\n3. * Use CALTRANS rates if listed,\n         or from invoices or by PWA.","Subtotal",null,0,null,0,null,null,"1. See Specifications §3-3.2.2(a).\n2. Furnish certified payrolls.\n3. Footnotes:\n    * Prevailing Wage + Fringe\n   ** CALTRANS Multiplier",null,"Subtotal",null,0,null,0]
["Total to Date: ",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15% Markup",null,0,null,0,null,null,null,0.33,"<= 33% Markup\n<= 32% if bid before 06/10/05",null,0,null,0]
["Total Authorized",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,0,null,0,null,null,null,null,"Total",null,0,null,0]
["This Sub payed previously:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MATERIAL","Qty","Unit","    Prime",null,"    Sub",null,null,"TOTALS",null,null,null,"     Prime",null,"      Sub"]
["Labor Markup per 3-3.2.3(a)",0.33,"33%, 32% If Bid before 06/10/05. Check VCSS for project.",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,null,"Total Equipment, Material & Labor",null,null,null,0,null,0]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,null,null,null,null,null,null,null,null,null,"Prime Markup on Sub \n(10% first $5,000 applied only once on each CCO))",null,"Previously Paid for Sub",null,0]
[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,null,null,null,null,null,null,0]
[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,null,null,null,null,"Prime Markup on Sub (5% over $5,000)",null,null,null,0]
[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,null,null,null,null,"Subtotal",null,null,null,0,null,0]
[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,null,null,null,null,"Total (Prime + Sub)",null,null,null,0]
[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,null,null,null,null,"Bond (1%)",null,null,null,0]
[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,null,null,null,null,"TOTAL THIS REPORT",null,null,null,0]
[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,null,null,null,null,"   I certify that the charges are accurately",null,null,null,"Contracting Agency:"]
[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,null,null,null,null,"   reported for the work indicated."]
[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. See Specifications \n           §3-3.2.2(b)&(e)\n2. Furnish Invoices.\n3. * From Invoice or by PWA.","Subtotal",null,0,null,0,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,"15% Markup",null,0,null,0,null,null," Contractor's Representative                   Date"]
[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,"Total",null,0,null,0,null,null,"SEE BACK OF FORM\nFOR REPORTING REQUIREMENTS","Received with \"A\" items only.",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,"F7.7-2 CH-37(For VCSS of 06/21/02)",null,null,null,null,null,null,null,null,"By____________Date_________",null,null,"  Project Manager     Date"]

{"sheet":"PrintBlankPg1","index":1,"n_rows":37,"n_cols":15,"rows_kept":37,"cut":false,"hidden":false,"merged":[[22,8,22,11],[35,8,36,8],[35,9,35,11],[36,9,36,11],[35,3,36,3],[35,4,36,4],[35,5,36,5],[35,6,36,6],[19,10,19,11],[7,12,7,13],[7,14,7,15],[18,0,20,0],[33,0,35,0],[7,3,7,4],[7,5,7,6],[18,8,20,9],[24,8,25,11],[35,1,36,2]],"flags":["formulas_cached_only"]}
["COUNTY OF VENTURA - PUBLIC WORKS AGENCY",null,null,null,null,"DAILY EXTRA WORK REPORT"]
[" Spec No. _____________",null,null,null,null,null,"CCO No. ________",null,null,null,"Date Report Completed _______________"]
[" Project Name ___________________________________",null,null,null,null,null,"Report No. _______",null,null,null,"Previous Report",null,"$__________________"]
[" Prime Contractor ________________________________",null,null,null,null,null,"Sheet _____ of _____",null,null,null,"This Report",null,"$__________________"]
[" Subcontractors _________________________________",null,null,null,null,null,"Date Work Performed ___________",null,null,null,"Total to Date",null,"$__________________"]
[" Description of Work ______________________________________________________________",null,null,null,null,null,null,null,null,null,"Total Authorized",null,"$__________________"]
[]
["EQUIPMENT (Type, Model)","Hrs","Rate","     Prime",null,"      Sub",null,null,"LABOR (Class & Name)","Hrs","*Rate","**Mult","      Prime",null,"      Sub"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1. See Specifications \n           §3-3.2.2(c)&(e)\n2. Furnish Invoices for rentals.\n3. * Use CALTRANS rates if listed,\n         or from invoices or by PWA.","Subtotal",null,null,null,null,null,null,"1. See Specifications §3-3.2.2(a).\n2. Furnish certified payrolls.\n3. Footnotes:\n    * Prevailing Wage + Fringe\n   ** CALTRANS Multiplier",null,"Subtotal"]
[null,"15% Mrkup",null,null,null,null,null,null,null,null,"33% Markup\n32% if bid before 06/10/05"]
[null,"Total",null,null,null,null,null,null,null,null,"Total"]
[]
["MATERIAL","Qty","Unit","    Prime",null,"    Sub",null,null,"TOTALS",null,null,null,"     Prime",null,"      Sub"]
[null,null,null,null,null,null,null,null,"Total Equipment, Material & Labor"]
[null,null,null,null,null,null,null,null,"Prime Markup on Sub \n(10% first $5,000 applied only once on each CCO))"]
[]
[null,null,null,null,null,null,null,null,"Prime Markup on Sub (5% over $5,000)"]
[null,null,null,null,null,null,null,null,"Subtotal"]
[null,null,null,null,null,null,null,null,"Total (Prime + Sub)"]
[null,null,null,null,null,null,null,null,"Bond (1%)"]
[null,null,null,null,null,null,null,null,"TOTAL THIS REPORT"]
[null,null,null,null,null,null,null,null,"   I certify that the charges are accurately",null,null,null,"Contracting Agency:"]
[null,null,null,null,null,null,null,null,"   reported for the work indicated."]
["1. See Specifications \n           §3-3.2.2(b)&(e)\n2. Furnish Invoices.\n3. * From Invoice or by PWA.","Subtotal",null,null,null,null,null,null,"  ____________________________  _________"]
[null,"15% Mrkup",null,null,null,null,null,null," Contractor's Representative                   Date"]
[null,"Total",null,null,null,null,null,null,"SEE BACK OF FORM\nFOR REPORTING REQUIREMENTS","Received with \"A\" items only.",null,null,"  _____________  _____"]
["F7.7-2 CH-37(For VCSS of 06/21/02)",null,null,null,null,null,null,null,null,"By____________Date_________",null,null,"  Project Manager     Date"]

{"sheet":"PrintBlankPg2","index":2,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,8,1,9],[2,2,2,6],[3,4,3,6],[3,8,5,8],[3,9,5,9],[4,4,4,6],[5,4,5,6],[8,4,8,6],[8,8,9,8],[8,9,9,9],[9,4,9,6],[6,4,6,6],[6,8,7,8],[6,9,7,9],[7,4,7,6],[12,2,12,6],[12,8,14,8],[12,9,14,9],[13,2,13,6],[14,2,14,6],[10,4,10,6],[10,8,11,8],[10,9,11,9],[11,2,11,6],[17,4,17,6],[17,8,18,8],[17,9,18,9],[18,4,18,6],[15,4,15,6],[15,8,16,8],[15,9,16,9],[16,4,16,6],[21,3,21,6],[21,8,23,8],[21,9,23,9],[22,3,22,6],[23,2,23,6],[19,3,19,6],[19,8,20,8],[19,9,20,9],[20,3,20,6],[26,2,26,6],[26,8,27,8],[26,9,27,9],[27,2,27,6],[24,2,24,6],[24,8,25,8],[24,9,25,9],[25,2,25,6],[31,8,32,9],[32,2,32,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6]],"flags":["formulas_cached_only"]}
[]
[null,"HOW TO COMPLETE THE REPORT\n(See Specifications Section 3-3 for full requirements)",null,null,null,null,null,null,"CALTRANS LABOR SURCHARGE\nFor __/__/____ until ___/___/_____"]
[null,"A.","ALL ITEMS WITHIN HEAVY LINES  must be completed daily and furnished to the \n       Project Manager or Inspector by the close of business on the next work day.\n       Report No. starts with 1 for each CCO.",null,null,null,null,null,"TYPE OF WORK","Multiplier\nRT/OT"]
[null,null,"1. Equipment:","a)","Describe by type and model. Use CALTRANS designations if listed.",null,null,null,"All work\n not covered below","____/____"]
[null,null,null,"b)","Show hours of use on the work covered by this report."]
[null,null,"2. Materials:","a)","Describe type of material in sufficient detail to identify on invoice."]
[null,null,null,"b)","Show quantity actually used on the work covered by this report.",null,null,null,"Concrete Construction-\nBridge","____/____"]
[null,null,null,"c)","Show unit of measurement such as: Each, CY, Tons, Sq Ft, LF, etc."]
[null,null,"3. Labor:","a)","Give name and labor classification (from prevailing wage schedule)",null,null,null,"Drilling","____/____"]
[null,null,null,null,"of each person"]
[null,null,null,"b)","Show hours worked by each on the work covered by this report.",null,null,null,"Fence & Guardrail \nConstruction","____/____"]
[null,"B.","ALL OTHER ITEMS, TOGETHER WITH SUPPORTING DOCUMENTATION, must be"]
[null,null,"       furnished on a copy of each report sheet furnished under A. above as soon as",null,null,null,null,null,"Erection of Structural\n Metal for Bridges, \nExcluding Sign Bridges","____/____"]
[null,null,"       available but before any payment can be made for the work covered by the report. "]
[null,null,"      The following documentation is required:"]
[null,null,"1. Equipment:","a)","Invoices, if equipment is not Contractor owned.",null,null,null,"Landscape Gardener","____/____"]
[null,null,null,"b)","Rate from CALTRANS list."]
[null,null,null,"c)","If equipment is Contractor owned and is not on CALTRANS list, \n",null,null,null,"Mobile Crane &\n Hoist Service","____/____"]
[null,null,null,null,"the rate and justification for the rate used."]
[null,null,"2. Materials:","Invoices that identify the materials and show the actual cost to the",null,null,null,null,"Painting Steel \nStructures or Bridges","____/____"]
[null,null,null,"Contractor Sub-contractor. Any discounts received must be shown."]
[null,null,"3. Labor:","Certified payrolls for employees on the work covered by this report\n",null,null,null,null,"Piledriving, Not Including\n Drilled, Cast-in-Place Concrete Piles","____/____"]
[null,null,null," if certified payrolls are not already being submitted for the project."]
[null,"C.","Reports and payrolls from Sub-contractors shall be submitted through the Prime Contractor."]
[null,"D.","Reports not received, as provided in A. above, may waive right to payment.",null,null,null,null,null,"Sign Erection or Repair","____/____"]
[null,"E.","Fully completed reports and supporting documentation, as provided in B. and C. above,"]
[null,null,"  must be furnished before payment will be processed.",null,null,null,null,null,"Wrecking and Demolition","____/____"]
[null,"F.","The markups shown are based on Ventura County Standard Specifications, Section 3-3"]
[null,null," dated 05/17/02.  For projects using other specifications, check the specifications to see the",null,null,null,null,null,"Get multipliers from CALTRANS web "]
[null,null,"proper markups.",null,null,null,null,null,"site :      http://www.dot.ca.gov/hq/"]
[null,"G.","\"Total Authorized $\" in header box is the amount authorized for Time & Material CCOs. ",null,null,null,null,null,"                        construc/equipmnt.htm/"]
[null,null,"The Project Manager should refer to PPPM §7.6.4 and §7.6.6 concerning potential or",null,null,null,null,null,"The first multiplier is RT=Regular\nTime, the second is OT=Overtime"]
[null,null,"actual overruns."]