{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Intro","1. Personnel","2. Contractual ","3. Travel","4.  Equipment","5. Supplies","6. Indirect","BudgetSummary","Lists","Summary"],"not_rendered":{"charts":0,"images":0,"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":"Intro","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6],[10,2,10,4],[6,2,6,7],[8,2,8,7],[11,7,12,8]]}
[]
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[null," "]
[]
[]
[null,"Applying University:"]
[]
[null,"Project Name:  "]
[]
[]
[null,null,null,null,null,null,null,"Continue"]

{"sheet":"1. Personnel","index":1,"n_rows":37,"n_cols":16,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,12,34,13],[34,14,34,15],[22,3,22,9],[23,3,23,9],[8,1,8,15],[9,13,9,14],[9,15,10,15],[9,10,10,10],[9,11,10,11],[9,12,10,12],[9,1,10,1],[9,2,10,2],[19,3,19,9],[20,3,20,9],[21,3,21,9],[14,3,14,9],[0,1,0,5],[4,1,6,15],[9,3,10,9],[31,3,31,9],[26,3,26,9],[27,3,27,9],[28,3,28,9],[29,3,29,9],[30,3,30,9],[24,3,24,9],[25,3,25,9],[11,3,11,9],[13,3,13,9],[15,3,15,9],[16,3,16,9],[17,3,17,9],[12,3,12,9],[18,3,18,9],[36,7,37,8],[36,1,37,2],[32,3,32,9],[34,1,34,2],[34,7,34,9]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[null,"1.  Personnel"]
[null,"This section is where you are to list employees that will work on this project.  An employee is someone who will receive a W2 from you at the end of the year.  Personnel costs charged to the grant must be based on records that accurately refelct the work performed on the grant.  If an employee works on the grant, but also on other duties or a separate grant, the employee must keep time and activity sheets in addition to a time sheet.  These reports must be updated at least montly and are subject to review by the GLO."]
[]
[]
[]
[null,"Each section must be completed for each employee that will be charged to this project.  If additional spaces are required, please contact the GLO."]
[null,"Entry #","Employee Title","Work Done on the Grant",null,null,null,null,null,null,"Full Salary","Fringe Benefits","% of Fringe ","Amount Charged to the Grant",null,"    % of Time on the Grant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2"]
[null,"Example","Project Manager","Will oversee the project for the univeristy.",null,null,null,null,null,null,80000,15000,{"$f":"L12/(K12+L12)","v":0.15789473684210525},25000,0,{"$f":"(N12+O12)/(K12+L12)","v":0.26315789473684209}]
[null,"Example","Intern","Will work on the project for the univeristy.  The univeristy considers this an employee.",null,null,null,null,null,null,10000,2000,{"$f":"L13/(K13+L13)","v":0.16666666666666666},10000,0,{"$f":"(N13+O13)/(K13+L13)","v":0.83333333333333337}]
[null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"L14/(K14+L14)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(N14+O14)/(K14+L14)","v":{"$error":"#DIV/0!"}}]
[null,2,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,3,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,4,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,5,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,6,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,7,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,8,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,9,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,10,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,11,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,12,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,13,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,14,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,15,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,16,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,17,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,18,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,19,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[null,20,null,null,null,null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"}]
[]
[null,"Year 1 Cost:  ",null,{"$f":"SUM(N14:N33)","v":0},null,null,null,"Year 2 Cost:  ",null,null,{"$f":"SUM(O14:O33)","v":0},null,"Total Cost:  ",null,{"$f":"D35+K35","v":0},{"$f":"D35+K35","v":0}]
[]
[null,"Back to the Beginning",null,null,null,null,null,"Continue"]

{"sheet":"2. Contractual ","index":2,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,37,3],[36,8,37,9],[9,1,10,1],[9,2,10,3],[9,4,10,10],[31,2,31,3],[31,4,31,10],[32,2,32,3],[32,4,32,10],[28,2,28,3],[28,4,28,10],[29,2,29,3],[29,4,29,10],[30,2,30,3],[30,4,30,10],[25,2,25,3],[25,4,25,10],[26,2,26,3],[26,4,26,10],[27,2,27,3],[27,4,27,10],[22,2,22,3],[22,4,22,10],[23,2,23,3],[23,4,23,10],[24,2,24,3],[24,4,24,10],[19,2,19,3],[19,4,19,10],[20,2,20,3],[20,4,20,10],[21,2,21,3],[21,4,21,10],[16,2,16,3],[16,4,16,10],[17,2,17,3],[17,4,17,10],[18,2,18,3],[18,4,18,10],[13,2,13,3],[13,4,13,10],[14,2,14,3],[14,4,14,10],[15,2,15,3],[15,4,15,10],[0,1,0,6],[8,1,8,13],[11,2,11,3],[11,4,11,10],[12,2,12,3],[12,4,12,10],[4,1,6,12],[9,11,9,12]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[null,"2.  Contractual and Professional Services"]
[null,"Grantees must establish a contract administration system to consistently ensure that contract deliverables are being provided as specified in the contracts.   Please list all contractual obligations that will be charged to the grant.  This may include contracted employees.  For every line item, a signed contract must exist and be maintained through the retention period of the grant.  A contract paid through these grant funds is subject to review by the GLO during the course of grant monitoring."]
[]
[]
[]
[null,"Each contract that will be charged to the grant must have it’s own line item.  "]
[null,"Entry #","Contracted Vendor",null,"Work Done on the Grant",null,null,null,null,null,null,"Amount Charged to the Grant"]
[null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2"]
[null,"Example","ABC Temp Agency",null,"Will provide temporary employment services to do A, B, C, and D.",null,null,null,null,null,null,25000,25000]
[null,"Example","Intern (No W2)",null,"Intern who is a contractual employee ",null,null,null,null,null,null,2000,2000]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,null,null,null,"Year 1 Cost:  ",{"$f":"SUM(L14:L33)","v":0},"Year 2 Cost:",{"$f":"SUM(M14:M33)","v":0},"Total Cost:  ",{"$f":"F35+H35","v":0}]
[]
[null,"Back to the Beginning",null,null,null,null,null,null,"Continue"]

{"sheet":"3. Travel","index":3,"n_rows":42,"n_cols":13,"rows_kept":42,"cut":false,"hidden":false,"merged":[[41,1,42,3],[41,8,42,9],[4,1,11,11],[14,1,15,1],[14,2,15,3],[14,4,15,10],[14,11,14,12],[36,2,36,3],[36,4,36,10],[37,2,37,3],[37,4,37,10],[33,2,33,3],[33,4,33,10],[34,2,34,3],[34,4,34,10],[35,2,35,3],[35,4,35,10],[30,2,30,3],[30,4,30,10],[31,2,31,3],[31,4,31,10],[32,2,32,3],[32,4,32,10],[27,2,27,3],[27,4,27,10],[28,2,28,3],[28,4,28,10],[29,2,29,3],[29,4,29,10],[24,2,24,3],[24,4,24,10],[25,2,25,3],[25,4,25,10],[26,2,26,3],[26,4,26,10],[21,2,21,3],[21,4,21,10],[22,2,22,3],[22,4,22,10],[23,2,23,3],[23,4,23,10],[18,2,18,3],[18,4,18,10],[19,2,19,3],[19,4,19,10],[20,2,20,3],[20,4,20,10],[0,1,0,6],[13,1,13,13],[16,2,16,3],[16,4,16,10],[17,2,17,3],[17,4,17,10]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[null,"3.  Travel"]
[null,"Grant funds used for travel expenses must be limited to use outlined in the State of Texas travel guidelines. Keep the following policies in mind: \n                  \n                     • You must select the lowest comparable air rate. We will not reimburse for business or first class travel.\n                     • Foreign travel requires prior approval from the GLO.\n                     • Travel expenses must be directly related to the purpose of the grant.\n\nPlease note that travel is for employees only.  Travel of contractors should be a cost associated within the contract and not charged in this portion of the grant."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A separate line item must be completed for each travel event.  If an event will be ongoing, such as the example, they may be grouped together as demonstrated."]
[null,"Entry #","Travel Event",null,"Purpose of the Travel",null,null,null,null,null,null,"Amount Charged to the Grant"]
[null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2"]
[null,"Example","Ongoing Travel to Work Site",null,"Our staff will travel by rented car 3 times a week from our office in Houston to the worksite.",null,null,null,null,null,null,25000,25000]
[null,"Example","Conference",null,"Bob will be attending a conference on oil spill prevention.  The conference has not been identified yet, but the cost is est at $4,000.  This includes air, rental car, hotel, and food.",null,null,null,null,null,null,4000,4000]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,null,"Year 1 Cost:  ",{"$f":"SUM(L19:L38)","v":0},"Year 2 Cost:",{"$f":"SUM(M19:M38)","v":0},"Total Cost:  ",{"$f":"D40+F40","v":0}]
[]
[null,"Back to the Beginning",null,null,null,null,null,null,"Continue"]

{"sheet":"4.  Equipment","index":4,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,1,41,3],[40,8,41,9],[14,1,15,1],[14,2,15,3],[14,4,15,10],[31,4,31,10],[26,2,26,3],[26,4,26,10],[27,2,27,3],[27,4,27,10],[28,2,28,3],[28,4,28,10],[23,2,23,3],[23,4,23,10],[24,2,24,3],[24,4,24,10],[29,2,29,3],[29,4,29,10],[30,2,30,3],[30,4,30,10],[31,2,31,3],[35,2,35,3],[35,4,35,10],[36,2,36,3],[36,4,36,10],[32,2,32,3],[32,4,32,10],[33,2,33,3],[33,4,33,10],[34,2,34,3],[34,4,34,10],[25,2,25,3],[25,4,25,10],[20,2,20,3],[20,4,20,10],[21,2,21,3],[21,4,21,10],[22,2,22,3],[22,4,22,10],[17,2,17,3],[17,4,17,10],[18,2,18,3],[18,4,18,10],[19,2,19,3],[19,4,19,10],[0,1,0,6],[4,1,11,11],[13,1,13,13],[16,2,16,3],[16,4,16,10],[14,11,14,12]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[null,"4.  Equipment"]
[null,"Equipment must be used by the grantee in the project for which it was acquired as long as needed, whether or not the project continues to be supported by grant funds. When no longer needed for the original project the equipment may be used in other activities supported by the awarding agency.  The GLO must approve, in advance, each piece of equipment to be purchased under a grant either through the original grant award or subsequent grant adjustment.  The GLO has defined equipment as tangible personal property having a useful life of more than one year and a per-unit cost of $5,000 or more.  This includes information technology systems.  If the grantee chooses to capitalize items costing less than $5,000, this too would be considered equipment.  The list of items below that are valued between $500.00 and $4,999.99 are designated by the Texas Comptroller as controlled assets within the State Property Accounting guidance and must be maintained within the grantee’s inventory records.  These items would also be reported in this equipment section.  \n\nList:  Sound systems and other audio equipment; cameras; TVs; video players/recorders; desktop or laptop computers; data projectors; and smartphones, tablets and other hand held devices. CJD and HSGD have also designated mobile and portable radios as a controlled asset.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"A separate line item must be completed for each piece of equipment, as defined above, that will be purchased by the grant. "]
[null,"Entry #","Equipment",null,"Purpose of the Equipment",null,null,null,null,null,null,"Amount Charged to the Grant"]
[null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2"]
[null,"Example","Computer",null,"This project will require a new compluter.",null,null,null,null,null,null,1500,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,null,"Year 1 Cost:  ",{"$f":"SUM(L18:L37)","v":0},"Year 2 Cost:",{"$f":"SUM(M18:M37)","v":0},"Total Cost:  ",{"$f":"D39+F39","v":0}]
[]
[null,"Back to the Beginning",null,null,null,null,null,null,"Continue"]

{"sheet":"5. Supplies","index":5,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,37,3],[36,8,37,9],[8,1,9,1],[8,2,9,3],[8,4,9,10],[27,4,27,10],[22,2,22,3],[22,4,22,10],[23,2,23,3],[23,4,23,10],[24,2,24,3],[24,4,24,10],[19,2,19,3],[19,4,19,10],[20,2,20,3],[20,4,20,10],[25,2,25,3],[25,4,25,10],[26,2,26,3],[26,4,26,10],[27,2,27,3],[31,2,31,3],[31,4,31,10],[32,2,32,3],[32,4,32,10],[28,2,28,3],[28,4,28,10],[29,2,29,3],[29,4,29,10],[30,2,30,3],[30,4,30,10],[21,2,21,3],[21,4,21,10],[16,2,16,3],[16,4,16,10],[17,2,17,3],[17,4,17,10],[18,2,18,3],[18,4,18,10],[13,2,13,3],[13,4,13,10],[14,2,14,3],[14,4,14,10],[15,2,15,3],[15,4,15,10],[11,2,11,3],[11,4,11,10],[12,2,12,3],[12,4,12,10],[0,1,0,6],[4,1,5,11],[7,1,7,13],[10,2,10,3],[10,4,10,10],[8,11,8,12]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[null,"5.  Supplies and Operating Expenses"]
[null,"The GLO define supplies as tangible personal property with a per-unit cost of less than $5,000, unless the grantee agency chooses to capitalize the item, in which case it would be considered equipment.  This budget category also includes other direct costs such as leases for space, rental costs, tangible items that have a per unit value of less than $5,000, project supplies, office supplies, advertising costs for staff vacancies, etc. \n"]
[]
[]
[null,"A separate line item must be completed for each piece of equipment, as defined above, that will be purchased by the grant. "]
[null,"Entry #","Name",null,"Description",null,null,null,null,null,null,"Amount Charged to the Grant"]
[null,null,null,null,null,null,null,null,null,null,null,"Year 1","Year 2"]
[null,"Example","General Office Supplies",null,"Pens, paper, binder clips, paper clips",null,null,null,null,null,null,500,0]
[null,"Example","General Project Supplies",null,"Batteries, rope, fasteners, small tools",null,null,null,null,null,null,5000,5000]
[null,"Example","Publishing",null,"Cost of publishing",null,null,null,null,null,null,300,300]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[]
[null,null,"Year 1 Cost:  ",{"$f":"SUM(L14:L33)","v":0},"Year 2 Cost:",{"$f":"SUM(M14:M33)","v":0},"Total Cost:  ",{"$f":"D35+F35","v":0}]
[]
[null,"Back to the Beginning",null,null,null,null,null,null,"Continue"]

{"sheet":"6. Indirect","index":6,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,1,17,3],[16,8,17,9],[13,1,13,3],[12,2,12,3],[0,1,0,6],[10,2,10,3],[10,4,10,10],[4,1,5,11]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[null,"5.  Supplies and Operating Expenses"]
[null,"Indirect costs for this application is limited to 15%.  A copy of your cognizant record is required to be submitted with your application.\n"]
[]
[]
[]
[null,"Do you have an approved indirect cost rate from either your federal or state cognizant agency?",null,null,null,null,"Yes","  (type yes or no)"]
[null,"*Please note a copy of your letter is required to be submitted with your application"]
[]
[null,"Please enter the approved amount, up to 15%, or the de minimis of up to 15% if you do not have an approved amount: ",null,null,null,null,null,0]
[]
[null,"Your indirect cost may not exceed this amount:",null,null,"Year 1:",{"$f":"H12*BudgetSummary!C16","v":0},"  Year 2:  ",{"$f":"H12*BudgetSummary!F16","v":0},"  Total:    ",{"$f":"F14+H14","v":0}]
[]
[]
[null,"Back to the Beginning",null,null,null,null,null,null,"Continue"]

{"sheet":"BudgetSummary","index":7,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[15,2,15,3],[15,5,15,6],[15,8,15,9],[16,5,16,6],[16,8,16,9],[17,8,17,9],[10,5,10,6],[10,8,10,9],[11,5,11,6],[11,8,11,9],[12,5,12,6],[12,8,12,9],[13,8,13,9],[21,1,22,3],[5,3,5,8],[7,3,7,8],[5,1,5,2],[7,1,7,2],[9,2,9,3],[9,5,9,6],[9,8,9,9],[10,2,10,3],[14,2,14,3],[17,2,17,3],[16,2,16,3],[14,5,14,6],[14,8,14,9],[17,5,17,6],[0,1,0,6],[11,2,11,3],[12,2,12,3],[13,2,13,3],[13,5,13,6]]}
[null,"Texas General Land Office"]
[null,"Research & Development for Oil Spill Prevention - Budget"]
[]
[]
[]
[null,"Applying University:",null,{"$f":"Intro!C7","v":0}]
[]
[null,"Project Name:  ",null,{"$f":"Intro!C9","v":0}]
[]
[null,"Budget Summary","Year 1",null,null,"Year 2",null,null,"Total"]
[null,"Personnel",{"$f":"'1. Personnel'!D35","v":0},null,null,{"$f":"'1. Personnel'!K35","v":0},null,null,{"$f":"SUM(C11+F11)","v":0}]
[null,"Contractual",{"$f":"'2. Contractual '!F35","v":0},null,null,{"$f":"'2. Contractual '!H35","v":0},null,null,{"$f":"SUM(C12+F12)","v":0}]
[null,"Travel ",{"$f":"'3. Travel'!D40","v":0},null,null,{"$f":"'3. Travel'!F40","v":0},null,null,0]
[null,"Equipment",{"$f":"'4.  Equipment'!D39","v":0},null,null,{"$f":"'4.  Equipment'!F39","v":0},null,null,0]
[null,"Supplies",{"$f":"'5. Supplies'!D35","v":0},null,null,{"$f":"'5. Supplies'!F35","v":0},null,null,0]
[null,"Subtotals:  ",{"$f":"SUM(C11:D15)","v":0},null,null,{"$f":"SUM(F11:G15)","v":0},null,null,{"$f":"SUM(I11:J15)","v":0}]
[null,"Indirect",{"$f":"'6. Indirect'!F14","v":0},null,null,{"$f":"'6. Indirect'!H14","v":0},null,null,{"$f":"C17+F17","v":0}]
[null,"Totals:  ",{"$f":"SUM(C16:D17)","v":0},null,null,{"$f":"SUM(F16:G17)","v":0},null,null,{"$f":"SUM(I16:J17)","v":0}]
[]
[]
[]
[null,"Back to the Beginning"]

{"sheet":"Lists","index":8,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Select One","(Select One)"]
["Yes","Days"]
["No"]

{"sheet":"Summary","index":9,"n_rows":300,"n_cols":11,"rows_kept":300,"cut":false,"hidden":true,"merged":[[219,6,219,13],[3,1,3,9],[2,1,2,9],[1,1,1,9],[5,1,5,9],[4,1,4,9],[214,2,217,11],[0,3,0,10],[65,6,65,13],[130,6,130,13],[183,6,183,13],[197,3,199,10],[201,4,201,7],[209,2,209,11],[210,3,210,11],[211,2,212,2],[211,3,211,11],[191,2,192,3],[191,4,192,5],[191,6,192,9],[191,10,192,10],[193,2,193,10],[195,2,195,11],[187,2,188,3],[187,4,188,5],[187,6,188,9],[187,10,188,10],[189,2,190,3],[189,4,190,5],[189,6,190,9],[189,10,190,10],[181,2,181,6],[181,7,181,10],[185,2,185,10],[186,2,186,3],[186,4,186,5],[186,6,186,9],[178,2,178,6],[178,7,178,10],[179,2,179,6],[179,7,179,10],[180,2,180,6],[180,7,180,10],[175,2,175,6],[175,7,175,10],[176,2,176,6],[176,7,176,10],[177,2,177,6],[177,7,177,10],[140,3,140,10],[141,3,141,10],[144,2,145,13],[146,2,170,13],[174,2,174,6],[174,7,174,10],[134,3,134,10],[135,3,135,10],[136,3,136,10],[137,3,137,10],[138,3,138,10],[139,3,139,10],[91,2,94,11],[96,2,104,13],[108,2,116,13],[118,2,119,13],[120,2,128,13],[40,2,41,10],[42,2,63,13],[70,2,70,5],[71,2,71,5],[75,2,83,13],[35,2,35,3],[35,4,35,10],[36,2,36,3],[36,4,36,10],[38,2,38,4],[38,5,38,6],[32,2,32,3],[32,4,32,10],[33,2,33,3],[33,4,33,10],[34,2,34,3],[34,4,34,10],[29,2,29,3],[29,4,29,10],[30,2,30,3],[30,4,30,10],[31,2,31,3],[31,4,31,10],[26,2,26,3],[26,4,26,10],[27,2,27,3],[27,4,27,10],[28,2,28,3],[28,4,28,10],[23,2,24,10],[25,2,25,3],[25,4,25,10],[17,3,17,8],[19,3,19,8],[20,3,20,5],[7,2,7,7],[8,2,8,6],[11,3,11,8],[13,3,13,8],[14,3,14,5],[15,3,15,8]]}
[]
[null,"INSTRUCTIONS FOR PROJECT MANAGER:"]
[null,"1.  Print this page to PDF."]
[null,"2.  Obtain electronic signatures of the Project Manager and the Project Manager's Direct Supervisor."]
[null,"3.  Email signed needs assessment to your Contract Manager."]
[]
[]
[null,null,"Texas General Land Office"]
[null,null,"Needs Assessment"]
[]
[]
[null,null,"Division Name:",{"$f":"Intro!C7","v":0}]
[]
[null,null,"Project Name:  ",{"$f":"Intro!C9","v":0}]
[]
[null,null,"Author's Name: ",{"$f":"Intro!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Phone Number:",{"$f":"Intro!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Date Created:",{"$f":"Intro!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"1.  Projected Project Budget and Funding Source"]
[null,null,"In the space below, please provide the estimated project budget.  This should include the entire life of the contract, including any renewals."]
[]
[null,null,"Estimated Amount",null,"Funding Source"]
[null,null,{"$f":"'1. Personnel'!C12","v":"Project Manager"},null,{"$f":"'1. Personnel'!D12","v":"Will oversee the project for the univeristy."}]
[null,null,{"$f":"'1. Personnel'!C14","v":0},null,{"$f":"'1. Personnel'!D14","v":0}]
[null,null,{"$f":"'1. Personnel'!C25","v":0},null,{"$f":"'1. Personnel'!D25","v":0}]
[null,null,{"$f":"'1. Personnel'!C26","v":0},null,{"$f":"'1. Personnel'!D26","v":0}]
[null,null,{"$f":"'1. Personnel'!C27","v":0},null,{"$f":"'1. Personnel'!D27","v":0}]
[null,null,{"$f":"'1. Personnel'!C28","v":0},null,{"$f":"'1. Personnel'!D28","v":0}]
[null,null,{"$f":"'1. Personnel'!C29","v":0},null,{"$f":"'1. Personnel'!D29","v":0}]
[null,null,{"$f":"'1. Personnel'!C30","v":0},null,{"$f":"'1. Personnel'!D30","v":0}]
[null,null,{"$f":"'1. Personnel'!C31","v":0},null,{"$f":"'1. Personnel'!D31","v":0}]
[null,null,{"$f":"'1. Personnel'!C32","v":0},null,{"$f":"'1. Personnel'!D32","v":0}]
[null,null,{"$f":"'1. Personnel'!C33","v":0},null,{"$f":"'1. Personnel'!D33","v":0}]
[]
[null,null,"Estimated Total Project Cost:",null,null,{"$f":"SUM(C27:D37)","v":0}]
[]
[null,null,"If you have indicated that an estimated budget is not available at this time, please provide a detailed explanation in the section provided below."]
[]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D12,A300,D14)","v":"0: 0"}]
[]
[null,null,"2.  Consulting"]
[null,null,"As defined above, will this contract include consulting services?",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(I69=\"Yes\",\"Estimated % of Consulting:\",\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"3.  Project Description"]
[null,null,"Please state the reason the project is being proposed and the expected benefit to the General Land Office:"]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Please provide the anticipated expiration date of the project:",null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"4.  Strategic Alignment"]
[null,null,"Every project that the GLO enters into must align with the agency's mission.  Please see the GLO Mission statement below."]
[]
[null,null,"GLO Mission Statement"]
[null,null,"The mission of the Texas General Land Office is to serve the schoolchildren, veterans, and all people of Texas by preserving their history, protecting their environment, expanding economic opportunity, helping communities rebuild after disasters, and maximizing state revenue through innovative administration and prudent stewardship of state lands and resources."]
[]
[]
[]
[null,null,"Please describe how the proposed project furthers the mission of the GLO and fits within any applicable strategic priorities or approved plans:"]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"5.  Justification"]
[null,null,"Please provide a justification as to why this project should be implemented.  Please include the impact of not entering into the project."]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Compare the cost of performing the Project in-house vs. outsourcing the Project.  Explain how the  cost-comparison supports the outsourcing of this Project versus performing these services in-house.  Provide cost estimates to support this conclusion. "]
[]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D12,A300,D14)","v":"0: 0"}]
[]
[null,null,"6.  Project Goals"]
[null,null,"Please describe the project goals.  Please ensure the goals support agency or division needs."]
[null,null,"Goal","Description "]
[null,null,1,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,2,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,3,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,4,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,5,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,6,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,7,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"7.  Resources"]
[null,null,"Please describe any additional resources needed to properly administer this project.  This should include, but is not limited to, equipment, staff, and technology."]
[]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"8.  Statutory Authority"]
[null,null,"Under what statute you are mandated or authorized to perform this project:"]
[null,null,"Mandate Related to Project","Description ",null,null,null,"Statutory Authority for Procurement"]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D12,A300,D14)","v":"0: 0"}]
[]
[null,null,"Please complete the fields below with the names of the approver and obtain the necessary signatures. "]
[null,null,"Approver Name",null,"Project Title",null,"Signature",null,null,null,"Date"]
[null,null,null,null,"*Project Manager (PM)"]
[]
[null,null,null,null,"*PM Direct Supervisor"]
[]
[null,null,null,null,"Contract Manager"]
[]
[null,null," *Please note that by signing this document, you are agreeing to the estimated budget and funding source."]
[]
[null,null,"Procurement Use Only"]
[null,null,"Recommended Procurement Method:  "]
[]
[]
[]
[]
[null,null,"Procurement Signature:  ",null,null,null,null,null,null,"Date"]
[]
[]
[null,null,"General Counsel Use Only"]
[]
[null,null,"Contracts Attorney Approval:  ",null,null,null,null,null,null,"Date"]
[]
[]
[null,null,"Contract Management Use Only"]
[null,null,null,"Approved.  Submit with BuySpeed."]
[null,null,null,"This Project is subject to review by the Procurement & Grants Review Committee (\"P&GC\").\n\nThe Project has been added to the P&GC Agenda for meeting date _____________________.\nPlease ensure a representative is available to briefly describe the project and answer any \nquestions."]
[null,null,null,"Committee status (circle one):                  Approved                Denied                  More Info Requested"]
[null,null,"Comments:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"CONCATENATE(D12,A300,D14)","v":"0: 0"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[": "]