<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:o="urn:schemas-microsoft-com:office:office"
 xmlns:x="urn:schemas-microsoft-com:office:excel"
 xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"
 xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
 xmlns:html="http://www.w3.org/TR/REC-html40">
 <DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <Author>Jira Align</Author>
  <LastAuthor>Jira Align</LastAuthor>
  <Created>2016-04-14T16:26:49Z</Created>
  <LastSaved>2017-02-14T09:31:09Z</LastSaved>
  <Version>15.00</Version>
 </DocumentProperties>
 <CustomDocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
  <WorkbookGuid dt:dt="string">fafb8e3f-0c2a-4ad3-b36f-2f2e0a34dccf</WorkbookGuid>
  <TemplateVersion dt:dt="string">1.00</TemplateVersion>
 </CustomDocumentProperties>
 <OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
  <AllowPNG/>
 </OfficeDocumentSettings>
 <ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
  <WindowHeight>10935</WindowHeight>
  <WindowWidth>28800</WindowWidth>
  <WindowTopX>0</WindowTopX>
  <WindowTopY>0</WindowTopY>
  <RefModeR1C1/>
  <ProtectStructure>False</ProtectStructure>
  <ProtectWindows>False</ProtectWindows>
 </ExcelWorkbook>
 <Styles>
  <Style ss:ID="Default" ss:Name="Normal">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s62">
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="s63">
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Size="11"
    ss:Color="#000000" ss:Bold="1"/>
  </Style>
  <Style ss:ID="s65">
   <Alignment ss:Horizontal="Center" ss:Vertical="Top" ss:WrapText="1"/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Size="11"
    ss:Italic="1"/>
  </Style>
  <Style ss:ID="s67">
   <Alignment ss:Horizontal="Left" ss:Vertical="Top" ss:WrapText="1"/>
   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000"/>
  </Style>
  <Style ss:ID="s68">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Size="11"
    ss:Color="#000000"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s69">
   <Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Color="#000000"
    ss:Italic="1"/>
  </Style>
  <Style ss:ID="s70">
   <Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Color="#000000"
    ss:Italic="1"/>
   <NumberFormat ss:Format="@"/>
  </Style>
  <Style ss:ID="s73">
   <Alignment ss:Vertical="Bottom" ss:WrapText="1"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Color="#000000"
    ss:Italic="1"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s74">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Size="11"
    ss:Color="#000000" ss:Bold="1"/>
   <Interior/>
   <NumberFormat/>
   <Protection/>
  </Style>
  <Style ss:ID="s75">
   <Alignment ss:Vertical="Bottom"/>
   <Borders/>
   <Font ss:FontName="Calibri" x:CharSet="204" x:Family="Swiss" ss:Size="11"
    ss:Color="#000000" ss:Bold="1"/>
   <Interior/>
   <NumberFormat ss:Format="@"/>
   <Protection/>
  </Style>
 </Styles>
 <Names>
  <NamedRange ss:Name="LOCAL_DATE_SEPARATOR"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),17)" ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_DAY_FORMAT" ss:RefersTo="=INDEX(GET.WORKSPACE(37),21)"
   ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_HOUR_FORMAT"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),22)" ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_MINUTE_FORMAT"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),23)" ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_MONTH_FORMAT"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),20)" ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_MYSQL_DATE_FORMAT"
   ss:RefersTo="=REPT(LOCAL_YEAR_FORMAT,4)&amp;LOCAL_DATE_SEPARATOR&amp;REPT(LOCAL_MONTH_FORMAT,2)&amp;LOCAL_DATE_SEPARATOR&amp;REPT(LOCAL_DAY_FORMAT,2)&amp;&quot; &quot;&amp;REPT(LOCAL_HOUR_FORMAT,2)&amp;LOCAL_TIME_SEPARATOR&amp;REPT(LOCAL_MINUTE_FORMAT,2)&amp;LOCAL_TIME_SEPARATOR&amp;REPT(LOCAL_SECOND_FORMAT,2)"
   ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_SECOND_FORMAT"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),24)" ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_TIME_SEPARATOR"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),18)" ss:Hidden="1"/>
  <NamedRange ss:Name="LOCAL_YEAR_FORMAT"
   ss:RefersTo="=INDEX(GET.WORKSPACE(37),19)" ss:Hidden="1"/>
 </Names>
 <Worksheet ss:Name="Person Record">
  <Table ss:ExpandedColumnCount="38" ss:ExpandedRowCount="4" x:FullColumns="1"
   x:FullRows="1" ss:DefaultRowHeight="15">
   <Column ss:Index="2" ss:AutoFitWidth="0" ss:Width="98.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="110.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="97.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="129.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="129"/>
   <Column ss:AutoFitWidth="0" ss:Width="110.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="138" ss:Span="1"/>
   <Column ss:Index="10" ss:AutoFitWidth="0" ss:Width="126"/>
   <Column ss:AutoFitWidth="0" ss:Width="125.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="159.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="121.5" ss:Span="1"/>
   <Column ss:Index="15" ss:StyleID="s62" ss:AutoFitWidth="0" ss:Width="141.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="111.75" ss:Span="1"/>
   <Column ss:Index="18" ss:AutoFitWidth="0" ss:Width="93.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="149.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="126.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="137.25"/>
   <Column ss:AutoFitWidth="0" ss:Width="135.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="141.75"/>
   <Column ss:AutoFitWidth="0" ss:Width="123"/>
   <Column ss:AutoFitWidth="0" ss:Width="106.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="112.5" ss:Span="2"/>
   <Column ss:Index="29" ss:AutoFitWidth="0" ss:Width="106.5"/>
   <Column ss:AutoFitWidth="0" ss:Width="120"/>
   <Column ss:AutoFitWidth="0" ss:Width="140.25" ss:Span="5"/>
   <Column ss:Index="37" ss:AutoFitWidth="0" ss:Width="99.75"/>
   <Row ss:AutoFitHeight="0" Header="true">
    <Cell><Data ss:Type="String">Description (expand for the details)</Data></Cell>
    <Cell ss:Index="3" ss:StyleID="s63"/>
    <Cell ss:Index="5" ss:StyleID="s63"><Data ss:Type="String">Legend</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="52.5" Header="true">
    <Cell ss:MergeAcross="3" ss:StyleID="s65"><Data ss:Type="String">This sheet contains the list of the system users with their settings.</Data></Cell>
    <Cell ss:MergeAcross="2" ss:StyleID="s67"><Data ss:Type="String">An asterisk (*) denotes a required field&#10;A plus sign (+) denotes a required field if time tracking is set to YES</Data></Cell>
    <Cell ss:Index="10" ss:StyleID="s63"/>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="238.5" ss:StyleID="s68" Header="true">
    <Cell ss:Index="2" ss:StyleID="s69"><Data ss:Type="String">Enter as YYYY-MM-DD</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Enter as YYYY-MM-DD</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">User Type:&#10;Internal&#10;External</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">User ID. The UID is a unique value provided by the system to identify a user. It can not be updated.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">External ID is a value provided by the system administrator and is used for SSO authentication.  It can be an alphanumeric string.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's first name.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's last name.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's ID.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's email address.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's title or job description.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's role.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Associate the user with the portion of the enterprise he belongs to</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's company name.</Data></Cell>
    <Cell ss:StyleID="s70"><Data ss:Type="String">The user's company ID.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The region where the user works.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The city where the user works.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The cost center the user is associated with.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Does this user track time in AgileCraft?&#10; - Yes&#10; - No</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The date the user can begin to track time in timesheets.&#10;Enter as YYYY-MM-DD</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's time approver. If AgileCraft is used for time tracking the person that will approve the timesheet. The field is required if time tracking is set to YES.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's classification within your organization:&#10; - Full Time&#10; - Part Time&#10; - Contractor&#10; - Custom Classification</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String" x:Ticked="1">User's Manager</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The contractor's manager. Generally this is the person the contractor would report to within the contracting organization.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The calendar the user is assigned. This calendar will appear in the user's timesheet.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Select yes if this user is involved with time tracker compliance and audits.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">User Manages People&#10; - Yes &#10; - No</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The time tracking roles users will be assigned. Use a comma delimited list for multiples:&#10;Time Entry, Time Approver, etc</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Select this option if you want to include hours for this user in your financial system. In some cases, you might want to exclude this user's hours for billing purposes.&#10;- Yes&#10;- No</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's billing rate. (Rate should be a number value with no more than 2 digits after the comma)</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's billing rate start date.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The user's billing rate end date.</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The date the account was created. (ISO 8601 - 24 hour UTC Time i.e. yyyy-MM-ddTHH:mm:ssZ)</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The date/time the user logged in last. (ISO 8601 - 24 hour UTC Time i.e. yyyy-MM-ddTHH:mm:ssZ)</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The date/time the user's record was updated last. (ISO 8601 - 24 hour UTC Time i.e. yyyy-MM-ddTHH:mm:ssZ)</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">The date this export was run. (ISO 8601 - 24 hour UTC Time i.e. yyyy-MM-ddTHH:mm:ssZ)</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Activate and deactivate users with this option.&#10;- Active&#10;- Deactivated</Data></Cell>
    <Cell ss:StyleID="s69"><Data ss:Type="String">Notes.</Data></Cell>
   </Row>
   <Row ss:AutoFitHeight="0" ss:Height="21.75" ss:StyleID="s73" Header="true" ColumnNames="true">
    <Cell ss:StyleID="s63"><Data ss:Type="String">Id</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">Start Date</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">End Date</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">User Type*</Data></Cell>
    <Cell ss:StyleID="s63"><Data ss:Type="String">UID</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">External ID</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">First Name*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Last Name*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Employee ID</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Email*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Title*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Role*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Enterprise Hierarchy*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Company</Data></Cell>
    <Cell ss:StyleID="s75"><Data ss:Type="String">Company ID</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Region*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">City*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Cost Center*</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Time Tracker</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Time Tracking Start Date</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Time Approver +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Employee Classification +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Manager +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Contractor Manager +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Holiday Calendar +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Compliance Manager</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Is Manager</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Time Tracking Roles +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Include Hours +</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Billing Rate</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Billing Rate Start Date</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Billing Rate End Date</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Account Creation Date</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Last Logged In</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Last Modified Date</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Export Generation Date</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Active User</Data></Cell>
    <Cell ss:StyleID="s74"><Data ss:Type="String">Notes</Data></Cell>
   </Row>
  </Table>
  <WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
   <Unsynced/>
   <Print>
    <ValidPrinterInfo/>
    <PaperSizeIndex>9</PaperSizeIndex>
    <HorizontalResolution>600</HorizontalResolution>
    <VerticalResolution>600</VerticalResolution>
   </Print>
   <Selected/>
   <Panes>
    <Pane>
     <Number>3</Number>
     <ActiveRow>5</ActiveRow>
    </Pane>
   </Panes>
   <ProtectObjects>False</ProtectObjects>
   <ProtectScenarios>False</ProtectScenarios>
   <x:Gridlines/>
  </WorksheetOptions>
 </Worksheet>
</Workbook>
