{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Page 1","Page 2"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":2,"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"}

{"sheet":"Instructions","index":0,"n_rows":73,"n_cols":3,"rows_kept":73,"cut":false,"hidden":false,"merged":[[69,2,69,12],[4,1,4,13],[2,1,2,13],[25,2,25,12],[29,2,29,12],[16,2,16,12],[36,1,36,4],[12,2,12,12],[8,2,9,13],[35,5,36,9]]}
[]
[]
[null,"STANDARD FORM INSTRUCTIONS"]
[]
[null,"To simplify the form and request for payment process, formulas have been inserted in the form. Fields shaded in light blue are formula fields and cannot be manipulated. Please start by completing the top of Page 1 along with the RED outlined fields, then move to Page 2 inserting the necessary detail. Formulas will pull the detail from Page 2 into Page 1 to correctly calculate payment due. "]
[]
[null,"SUBMISSION"]
[null,null,"Periodic Estimates for Partial Payment (Form 101) should be submitted with a valid signature at the bottom of Page 1."]
[null,null,"Scanned/Emailed requests for payment are acceptable with a valid signature and date.\nEmailed requests should be sent to pdc@montana.edu and CC the Project Manager.\nPlease send pay applications in separate emails and put in subject line: PPA/SC#, Project name, and Pay Request#."]
[]
[]
[null,"CONSULTANT APPROVAL"]
[null,null,"N/A"]
[]
[]
[null,"COMPLETE BOTH PAGES"]
[null,null,"Please complete BOTH pages of the Periodic Estimate for Partial Payment (Form 101). Because both pages are contract documents, your request can be declined if both pages are not completed. Also, your amount due is calculated from the detail on Page 2, it will not calculate appropriately without Page 2 completed. (Use the tabs at the bottom of Excel to move between the instructions and both pages)"]
[]
[]
[null,"FINAL REQUESTS"]
[null,null,"N/A"]
[]
[]
[]
[null,"RETAINAGE CALCULATION"]
[null,null,"N/A"]
[]
[]
[null,"GENERAL SERVICE CONTRACT INSTRUCTIONS"]
[]
[]
[]
[null,"If you have questions on the Pay Request Form or need additional information regarding the usage of this form: "]
[null,"Please Contact:"]
[]
[null,"Kristin Harbuck | MSU Bozeman"]
[null,"kristin.harbuck@montana.edu"]
[null,"406-994-5504"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"HINTS:"]
[]
[]
[]
[null,null,"Please note: the Macro Settings for the user computer need to be set at \"Enable\" in order to run the PRINT and "]
[null,null,"RESET FORM macros."]
[]
[null,null,"That can be done by entering the Trust Center for Microsoft Excel and selecting Enable Macros. "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"*(Trust Center is on Windows XP and newer versions)"]
[null,null,"*(Older versions have the \"Enable Macros\" setting, however, it is under Security settings)"]
[]
[null,null,"If you need additional help adjusting these settings do a search under Microsoft Excel Help for \"Enable Macros\", there you can get step by step instructions for adjusting your macro settings."]
[]
[]
[null,"If you are having trouble viewing this form on a smaller monitor, utilize the ZOOM funtion at the bottom right of the screen…"]

{"sheet":"Page 1","index":1,"n_rows":44,"n_cols":21,"rows_kept":44,"cut":false,"hidden":false,"merged":[[7,5,8,22],[30,20,30,22],[31,20,31,22],[26,20,26,22],[24,20,24,22],[25,20,25,22],[12,18,12,19],[14,15,14,22],[27,20,27,22],[28,20,28,22],[29,20,29,22],[10,16,10,17],[11,16,11,17],[12,16,12,17],[13,14,13,17],[27,6,27,8],[27,1,27,2],[14,4,14,11],[24,3,24,5],[24,6,24,8],[24,9,24,11],[25,1,25,2],[25,3,25,5],[19,9,19,11],[20,9,20,11],[21,9,21,11],[25,6,25,8],[25,9,25,11],[27,9,27,11],[26,6,26,8],[26,9,26,11],[11,18,11,19],[3,10,3,21],[31,9,31,11],[30,1,30,5],[31,1,31,8],[29,1,29,2],[29,3,29,5],[29,6,29,8],[28,1,28,2],[28,3,28,5],[28,6,28,8],[28,9,28,11],[26,3,26,5],[24,1,24,2],[26,1,26,2],[27,3,27,5],[38,3,38,10],[40,3,40,10],[41,3,41,10],[4,9,4,21],[5,14,5,21],[29,9,29,11],[30,6,30,8],[30,9,30,11],[10,18,10,19],[15,15,15,22],[16,15,16,22],[21,20,21,22],[19,20,19,22],[20,20,20,22],[10,21,10,22],[11,21,11,22]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"UNIVERSITY FACILITIES MANAGEMENT"]
[null,null,null,null,null,null,null,null,null,"Sixth Avenue and Grant Street  \u009f P.O. Box 172760 \u009f Bozeman, Montana   59717-2760"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone: (406) 994-5413 \u009f Fax: (406) 994-5665"]
[]
[null,null,null,null,null,"GENERAL SERVICE CONTRACTS ONLY Executed after May 22, 2023"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPA or SC No:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Period From",null,null,null,"Period To:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pay Estimate #"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,"[Pulls from Change Order Summary]",{"$f":"J32","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U20:W21)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"    1. Work in Place (from next page)",null,null,null,null,null,"[Column D + E Total - Page 2]",{"$f":"IF(SUM('Page 2'!I12:L37)= 0,\"NEXT PAGE\",SUM('Page 2'!I12:L37))","v":"NEXT PAGE"}]
[null,null,null,null,null,null,null,null,null,0,null,null,null,"       2. Total Work and Stored Materials",null,null,null,null,null,"[Column G Total - Page 2]",{"$f":"IF(SUM('Page 2'!O12:P37)=0,\"NEXT PAGE\",SUM('Page 2'!O12:P37))","v":"NEXT PAGE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"    3. Retainage Deleted from these calculations",null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"       4. Total Earned to Date",null,null,null,null,null,null,{"$f":"U26","v":"NEXT PAGE"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"    5. Less Previous Payments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"    6. Amount Due this Payment",null,null,null,null,null,null,{"$f":"U28-U29","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,{"$f":"SUM(G26:I30)","v":0},null,null,{"$f":"SUM(J26:L30)","v":0},null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(G31:L31)","v":0}]
[]
[]
[]
[]
[null,"    Submitted by:"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(Name)",null,null,null,null,null,null,null,"Date"]
[null,"     Reviewed by: "]
[null,null,null,"(Consultant)",null,null,null,null,null,null,null,null,"(Name)",null,null,null,null,null,null,null,"Date"]
[null,"     Approved by: ",null,"State of Montana, Montana State University"]
[null,null,null,"University Facilities Management",null,null,null,null,null,null,null,null,"(Name)",null,null,null,null,null,null,null,"Date"]
[]
[null,null,"Form 101GS",null,null,null,null,null,null,"2023-06-01",null,null,null,null,null,null,null,null,"SHEET NO.:    1   OF   2   SHEETS"]

{"sheet":"Page 2","index":2,"n_rows":39,"n_cols":20,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,2,38,5],[26,17,26,18],[26,19,26,20],[24,12,24,13],[24,14,24,15],[37,2,37,5],[37,6,37,7],[37,12,37,13],[36,17,36,18],[36,19,36,20],[36,2,36,5],[27,8,27,9],[27,10,27,11],[27,12,27,13],[27,14,27,15],[27,17,27,18],[27,19,27,20],[26,2,26,5],[26,6,26,7],[26,8,26,9],[26,10,26,11],[26,12,26,13],[26,14,26,15],[27,2,27,5],[38,12,38,13],[37,14,37,15],[38,14,38,15],[37,17,37,18],[38,17,38,18],[37,19,37,20],[38,19,38,20],[38,6,38,7],[37,8,37,9],[38,8,38,9],[37,10,37,11],[38,10,38,11],[36,6,36,7],[36,8,36,9],[36,10,36,11],[36,12,36,13],[36,14,36,15],[34,17,34,18],[35,6,35,7],[22,17,22,18],[22,19,22,20],[35,8,35,9],[35,10,35,11],[35,12,35,13],[35,14,35,15],[35,17,35,18],[35,19,35,20],[34,19,34,20],[31,10,31,11],[22,6,22,7],[22,8,22,9],[22,10,22,11],[22,12,22,13],[22,14,22,15],[23,8,23,9],[23,10,23,11],[33,19,33,20],[34,2,34,5],[34,8,34,9],[34,10,34,11],[34,12,34,13],[34,14,34,15],[31,19,31,20],[33,2,33,5],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[33,17,33,18],[32,19,32,20],[31,2,31,5],[31,8,31,9],[31,17,31,18],[30,19,30,20],[30,6,30,7],[30,2,30,5],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[30,17,30,18],[24,19,24,20],[29,12,29,13],[29,14,29,15],[29,17,29,18],[29,19,29,20],[23,12,23,13],[23,14,23,15],[27,6,27,7],[28,14,28,15],[28,17,28,18],[28,19,28,20],[29,6,29,7],[29,8,29,9],[29,10,29,11],[21,19,21,20],[28,2,28,5],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[23,2,23,5],[23,6,23,7],[25,17,25,18],[25,19,25,20],[25,2,25,5],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[25,14,25,15],[22,2,22,5],[23,17,23,18],[23,19,23,20],[24,2,24,5],[24,6,24,7],[24,8,24,9],[24,10,24,11],[24,17,24,18],[19,19,19,20],[20,2,20,5],[20,6,20,7],[20,8,20,9],[20,10,20,11],[20,12,20,13],[20,14,20,15],[20,17,20,18],[20,19,20,20],[19,2,19,5],[19,6,19,7],[19,8,19,9],[19,10,19,11],[19,12,19,13],[19,14,19,15],[17,19,17,20],[18,2,18,5],[18,6,18,7],[18,8,18,9],[18,10,18,11],[18,12,18,13],[18,14,18,15],[18,17,18,18],[18,19,18,20],[17,2,17,5],[17,6,17,7],[17,8,17,9],[17,10,17,11],[17,12,17,13],[17,14,17,15],[13,10,13,11],[13,12,13,13],[14,2,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[14,12,14,13],[14,14,14,15],[16,10,16,11],[16,12,16,13],[16,14,16,15],[15,2,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11],[15,12,15,13],[15,14,15,15],[8,17,8,18],[11,19,11,20],[4,19,4,20],[5,19,5,20],[6,19,6,20],[8,19,8,20],[8,14,8,16],[11,17,11,18],[12,17,12,18],[11,14,11,15],[12,14,12,15],[12,19,12,20],[4,4,4,7],[5,4,5,7],[9,8,9,11],[8,2,8,5],[8,6,8,7],[8,8,8,9],[6,11,6,15],[4,11,4,15],[5,11,5,15],[9,6,9,7],[8,12,8,13],[8,10,8,11],[15,19,15,20],[16,17,16,18],[16,19,16,20],[16,2,16,5],[16,6,16,7],[16,8,16,9],[12,2,12,5],[11,2,11,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[12,12,12,13],[11,6,11,7],[11,8,11,9],[11,10,11,11],[11,12,11,13],[13,17,13,18],[13,14,13,15],[13,19,13,20],[14,17,14,18],[14,19,14,20],[13,2,13,5],[13,6,13,7],[13,8,13,9],[35,2,35,5],[33,6,33,7],[34,6,34,7],[31,6,31,7],[32,6,32,7],[21,2,21,5],[21,6,21,7],[21,8,21,9],[15,17,15,18],[17,17,17,18],[19,17,19,18],[21,10,21,11],[21,12,21,13],[21,14,21,15],[21,17,21,18],[29,2,29,5],[32,2,32,5],[32,8,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,15],[32,17,32,18],[31,12,31,13],[31,14,31,15]]}
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF('Page 1'!E15=\"\",\"\",'Page 1'!E15)","v":""},null,null,null,null,null,null,{"$f":"IF('Page 1'!P15=\"\",\"\",'Page 1'!P15)","v":""},null,null,null,null,null,null,null,{"$f":"IF('Page 1'!S11=\"\",\"\",'Page 1'!S11)","v":""}]
[null,null,null,null,"MONTANA STATE UNIVERSITY",null,null,null,null,null,null,{"$f":"IF('Page 1'!P16=\"\",\"\",'Page 1'!P16)","v":""},null,null,null,null,null,null,null,{"$f":"IF('Page 1'!V11=\"\",\"\",'Page 1'!V11)","v":""}]
[]
[]
[null,"A","B",null,null,null,"C",null,"D",null,"E",null,"F",null,"G",null,null,"H",null,"I"]
[null,null,null,null,null,null,"(Contract Amt)",null,"WORK COMPLETED"]
[]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"IF(OR(I12<>\"\",K12<>\"\",M12<>\"\"),I12+K12+M12,\"\")","v":0},null,{"$f":"IF(AND(G12<>\"\",O12<>\"\"),O12/G12,\"\")","v":""},{"$f":"IF(AND(G12<>\"\",O12<>\"\"),G12-O12,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I13<>\"\",K13<>\"\",M13<>\"\"),I13+K13+M13,\"\")","v":""},null,{"$f":"IF(AND(G13<>\"\",O13<>\"\"),O13/G13,\"\")","v":""},{"$f":"IF(AND(G13<>\"\",O13<>\"\"),G13-O13,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I14<>\"\",K14<>\"\",M14<>\"\"),I14+K14+M14,\"\")","v":""},null,{"$f":"IF(AND(G14<>\"\",O14<>\"\"),O14/G14,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I15<>\"\",K15<>\"\",M15<>\"\"),I15+K15+M15,\"\")","v":""},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,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,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,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"",{"$f":"IF(AND(G23<>\"\",O23<>\"\"),G23-O23,\"\")","v":""}]
[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,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,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,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,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,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,null,null,null,null,null,"",null,"",""]
[null,null,"PAGE TOTALS",null,null,null,{"$f":"SUM(G12:H37)","v":0},null,{"$f":"SUM(I12:J37)","v":0},null,{"$f":"SUM(K12:L37)","v":0},null,{"$f":"SUM(M12:N37)","v":0},null,{"$f":"SUM(O12:P37)","v":0},null,null,{"$f":"SUM(R12:S37)","v":0},null,{"$f":"SUM(T12:U37)","v":0}]
[null,null,"GRAND TOTALS"]