U.S. Department of Health and Human Services
Indian Health Service: The Federal Health Program for American Indians and Alaska Natives
 /  Register
Resource and Patient Management System.  
Information
 Technology
 Resources 		 

Tribal ITSolutions Home

IHS RPMS Advantage

Tribal IT Professionals

Tribal Negotiation Tools
Tribal Share Worksheet
Service Level Agreement
Share Distribution
Product & Service Package

ALN Tools

Products & Service Packages

FAQs

These plug-ins
may be required
for the content
on this page:

Link to Adobe Acrobat Plug-in Acrobat
Link to MicroSoft PowerPoint Plug-in PowerPoint
Link to MicroSoft Word Plug-in MS Word
Link to MicroSoft Excel Plug-in Excel
Link to Zip File Plug-in Zip File

IHS Plug-in Page

Use site contact
if unable to view
a particular file
 

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]excel icon MS Excel file

Back to Top
  Photos of people in a hospital environment.

Link to IHS-OIT Tribal Consultation for proposed IT Support Packages
Questions or Comments. Please contact the Site Manager.

These plug-ins may be required for the content on this page:

Link to Adobe Acrobat Plug-in Acrobat  Link to MicroSoft PowerPoint Plug-in PowerPoint  Link to MicroSoft Word Plug-in MS Word  Link to MicroSoft Excel Plug-in Excel  Link to Zip File Plug-in Zip File 

usa.gov link   Accessibility · Disclaimer · Website Privacy Policy · Freedom of Information Act · Kid's Page · Contact   This website is accredited by Health On the Net Foundation. Click to verify.

Indian Health Service (HQ) - The Reyes Building, 801 Thompson Avenue, Ste. 400 - Rockville, MD 20852