Tribal Share Worksheet
Below you will find a link for linked spreadsheets that have been developed to assist you in your negotiating efforts. The spreadsheets will calculate the share amounts per Tribe for the functions and services the Tribe selects. As you proceed through the spreadsheets, the functions and services that are available for contracting are highlighted so that you may click on those items and get a more in-depth definition of each item. If you should have any questions or difficulty in using this tool, please feel free to contact Sam Berry at (505) 248-4150.
Instructions
To clarify the use of the following spreadsheets, we will start with the information provided by the Division of Financial Management (DFM) Table #4, "HQ PFSA's for FY 2007 TSA and Program Formula Lines". The Area Office ISC or ALN will use the worksheets that follow to determine the distribution of various Tribal shares as they relate to the Office of Information Technology (OIT).
The OIT worksheet #1 uses input from DFM Table #4. Place the figures from the appropriate Budget Line Items (#126, #137, and #1301) from Table #4 into the appropriate shaded spaces in worksheet #1. Once those figures are entered, worksheet #2 and the Service Level Agreement #3 worksheet will be automatically populated.
After all three spreadsheets are populated, OIT worksheet #3 is then used to determine the level of service that is required as the table relates to the OIT Product Packages or Core Packages. After following the instruction in worksheet #3 that requires the selected support level shares to be reentered on the next line (this double entry enables the spreadsheet to automatically accumulate and total the selected shares), the OIT worksheet #3 becomes the document that is then used to track OIT support for a given Tribe.
To review additional information relating to the Core Packages double click on the highlighted areas of worksheet #1. To review additional information relating to the Service Level Agreements double click on the highlighted areas of worksheet #3.
The Excel version below downloads only the Excel Tribal Shares Worksheet file in an uncompressed form.
Tribal Shares Worksheet [MS-EXCEL-249KB] MS Excel file
Back to Top |