{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Blank"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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"}

{"sheet":"Blank","index":0,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,9],[4,1,4,2],[6,1,6,2],[9,1,9,2],[10,1,10,2],[3,2,3,9],[1,2,1,6],[7,1,7,2],[26,1,26,2],[16,1,16,2],[20,1,20,2],[21,1,21,2],[24,1,24,2],[25,1,25,2],[41,2,45,9],[22,1,22,2],[23,1,23,2],[8,1,8,2],[27,1,27,2],[32,3,32,6],[33,3,33,6],[31,3,31,6],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[17,1,17,2],[18,1,18,2],[19,1,19,2]]}
[null," NMSU CHANGE ORDER CALCULATION SHEET   (GC 12.2.6)                                             Revised 9/7/2017"]
[null,"Project:",null,null,null,null,null,"Date","2017-09-07",null,null,"Select Category"]
[null,"Proposal Request #",null,null,null,null,null,"PR Revision #",null,null,null,"Work by Own Forces"]
[null,"Proposal Desc:",null,null,null,null,null,null,null,null,null,"Work by Subcontractor"]
["Select the proper work category","Work Description",null,"Quantity","Unit","Cost / Unit","Burden on Labor","Contractor / Subcontractor OH&P for Work by Own Forces","Contractor OH&P for Work by Subcontractor","Total"]
[]
["Select Category"," ",null,null,null,null,null,{"$f":"IF(A7=\"work by own forces\",(D7*F7)+G7,0)","v":0},{"$f":"IF(A7=\"work by subcontractor\",D7*(F7+G7),0)","v":0},{"$f":"H7+I7","v":0}]
["Select Category"," ",null,null,null,null,null,{"$f":"IF(A8=\"work by own forces\",(D8*F8)+G8,0)","v":0},{"$f":"IF(A8=\"work by subcontractor\",D8*(F8+G8),0)","v":0},{"$f":"H8+I8","v":0}]
["Select Category"," ",null,null,null,null,null,0,{"$f":"IF(A9=\"work by subcontractor\",D9*(F9+G9),0)","v":0},{"$f":"H9+I9","v":0}]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0,null," "]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0,null,"   "]
["Select Category",null,null,null,null,null,null,0,0,0,null," "]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0,null," "]
["Select Category"," ",null,null,null,null,null,{"$f":"IF(A25=\"work by own forces\",(D25*F25)+G25,0)","v":0},{"$f":"IF(A25=\"work by subcontractor\",D25*(F25+G25),0)","v":0},{"$f":"H25+I25","v":0}]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
["Select Category"," ",null,null,null,null,null,0,0,0]
[null,null,null,null,null,null,"Change Order Amount Before Markup Total",{"$f":"SUM(H7:H28)","v":0},{"$f":"SUM(I7:I28)","v":0},0]
[null,null,null,null,null,null,null,"Contractor's Option Bond Premium @    %",0,{"$f":"IF(AND(I36<0.01,I40<0.01),J29*I30,0)","v":0},"Insert Bond value if contractor elects to add bond to cost of work only, otherwise 0.0%"]
[]
[null,null,null,"Overhead + Profit Rates Per GC 12.2.6"]
[null,null,null,"If < $20,000, Overhead + Profit (GC 12%; Sub 8%)",null,null,null,{"$f":"IF(K33=\"No\",IF(AND(0.01<J29,J29<20000.01),H29*12%,0),0)","v":0},{"$f":"IF(K33=\"No\",IF(AND(0.01<J29,J29<20000.01),I29*8%,0),0)","v":0},{"$f":"H33+I33","v":0},"no",null,"= OH&P 0% override, Yes or No?"]
[null,null,null,"If >$20,000, Overhead + Profit @ (GC 7%; Sub 5%)",null,null,null,{"$f":"IF(K34=\"No\",IF(J29>20000.01,H29*7%,0),0)","v":0},{"$f":"IF(K34=\"no\",IF(J29>20000.01,I29*5%,0),0)","v":0},{"$f":"H34+I34","v":0},"no",null,"= OH&P 0% override, Yes or No?"]
[null,null,null,null,null,null,null,null,"Cost + OH&P Subtotal",{"$f":"SUM(J29:J34)+(K35*0.01)","v":0},0,null,"= Penny adjustment"]
[null,null,null,null,null,null,null,"Contractor's Option Bond Premium @    %",0,{"$f":"IF(AND(I30<0.01,I40<0.01),J35*I36,0)","v":0},"Insert Bond value if contractor elects to add bond to work  that includes OH&P, otherwise 0.0%"]
[null,null,null,null,null,null,null,null,"Proposal Request Total w/o tax",{"$f":"J35+J36+(K37*0.01)","v":0},0,null,"= Penny adjustment",null,{"$f":"J37","v":0},"= Unprotected linkable cell"]
[null,null,null,null,null,null,null,"New Mexico Gross Receipts Tax",0,{"$f":"J37*I38","v":0}]
[null,null,null,null,null,null,null,null,"Proposal Request Total w/tax",{"$f":"J37+J38+(K39*0.01)","v":0},0,null,"= Penny adjustment"]
[null,null,null,null,null,null,null,"Contractor's Option Bond Premium @    %",0,{"$f":"IF(AND(I30<0.01,I36<0.01),J39*I40,0)","v":0},"Insert Bond value if contractor elects to add bond to work that includes OH&P, and tax, otherwise 0.0%"]
[null,null,null,null,null,null,null,null,"Proposal Request Total w/bond & tax",{"$f":"J39+J40+(K41*0.01)","v":0},0,null,"= Penny adjustment"]
[null,"Notes:"]