{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Guidelines","Worksheet","(HIDE) MASTER-Chart","(HIDE) Sheet1"],"not_rendered":{"charts":0,"images":2,"macros":0,"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":158,"n_cols":4,"rows_kept":158,"cut":false,"hidden":false,"merged":[[41,0,41,8],[42,0,42,8],[154,0,154,2],[150,3,150,8],[152,3,152,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[96,0,96,8],[137,1,138,8],[141,1,142,8],[146,3,146,8],[148,3,148,8],[149,3,149,8],[146,0,146,2],[148,0,148,2],[152,0,152,2],[121,1,129,8],[131,1,135,8],[111,0,115,8],[117,1,119,8],[98,0,101,8],[102,0,102,8],[103,0,109,8],[81,1,87,8],[74,0,74,8],[89,1,92,8],[94,0,95,8],[61,1,64,8],[66,0,66,8],[67,0,72,8],[75,0,79,8],[45,0,50,8],[52,0,53,8],[57,1,58,8],[59,1,60,8],[0,0,0,8],[2,0,5,8],[7,0,7,8],[39,1,39,8],[21,1,32,8],[20,1,20,8],[34,1,37,8],[9,0,10,8],[12,1,12,8],[11,1,11,6],[18,1,18,8],[13,0,16,8]]}
["Instructions for MSUAASF Salary Placement"]
[]
["Step placement for new MSUAASF members is determined by the number of years of creditable experience the individual has, as well as the number of years the individual has spent previously in a MSUAASF or Minnesota State Academic Professional, Academic Supervisor or Administrator position assigned to the same or a higher salary range."]
[]
[]
[]
[]
["Steps for Manual Process:"]
[]
["Step 1: Calculate the TOTAL number of years of creditable work experience, Type 1 through Type 3.6. Files to use:"]
[]
[null,"1) MSUAASF Creditable Work Experience: Worksheet"]
[null,"2) MSUAASF Creditable Work Experience: Guidelines. "]
["The Guidelines provide detailed, specific information for analyzing work experience. This step is the most time-consuming; it requires detailed analysis of the candidate's resume. The TOTAL number of years will be used to move down the vertical axis of the MSUAASF Salary Corridor Grid for the appropriate range (see Step 3). "]
[]
[]
[]
[]
[null,"IMPORTANT!  What Experience is Creditable? "]
[]
[null,"1. Not all work experience is creditable for the ASF position being analyzed. "]
[null,"For example, some experience is only creditable if it is \"directly related to the ASF position upon hire.\" This means that the experience could be useful to the candidate hired on his/her first day of work. Also, in order for prior ASF and Minnesota State Administrator (i.e., Minnesota State Academic Professional, Academic Supervisor, and/or Administrator) work to be creditable in Type 1, it must have been in the same or a higher salary range than the current ASF position.\n\nNote: Prior Minnesota State work that does NOT fall under Type 1 (because it falls into a lower salary range), the work may nonetheless be creditable under the Discretionary sub-categories of work, specifically Type 3.3 Clerical/Technical/Paraprofessional/Lower-Level Professional Experience, but ONLY if the experience is \"directly related to the ASF position upon hire\". "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Not all prior work experience is valued at 100%; creditable Professional-level K-12 Teaching and Administrative experience, Clerical/Technical/Paraprofessional/Lower-Level Professional experience and Graduate/Teaching Assistantships experience is valued at 50%. "]
[]
[]
[]
[]
[null,"3. No more than 1.00 FTE is credited in any twelve-month period. "]
[]
["For more details on the creditability and value of specific work experience, see the:"]
["MSUAASF Creditable Work Experience: Guidelines"]
[]
[]
["Step 2: Identify the number of years previously spent in an equal or higher range MSUAASF or Minnesota State Academic Professional, Academic Supervisor or Administrator position, if any. (Found in Type 1 experience).  Note that this applies only when the new MSUAASF employee was previously assigned to an equal or higher range, followed by a break in service, than that for which the employee is currently being hired. This number will be used to move across the horizontal axis of the MSUAASF Salary Corridor Grid for the appropriate range (see Step 3)."]
[]
[]
[]
[]
[]
[]
["Step 3: Determine the appropriate salary corridor (that is, the Target Step and two steps lower) in which to set the new MSUAASF employee’s initial salary:"]
[]
[null,"A.   For the appropriate salary period (i.e. AY16 or AY17), go to the:"]
[null,"MSUAASF Salary Corridor Grid"]
[null,"B.      Find the appropriate previously-determined Range, A-E"]
[null,"C.      Find the TOTAL number of years of creditable work experience (see Step 1 above),\n      rounded down to the nearest whole number, on the vertical axis of the grid. "]
[]
[null,"D.     Find the number of years of previous equal or higher MnSCU work experience, if\n     any, (see Step 2, above/Type 1) on the horizontal axis of the grid. "]
[]
[null,"E.      The new MSUAASF employee’s salary corridor/parameter is located at the\n      intersection of the employee’s placement on the vertical and horizontal axes. The\n      corridor identifies both the Target Step and associated salary and the salary found\n      two steps lower than the target step."]
[]
[]
[]
[]
["Automated Process: Calculation of Years of Experience AND Target Step Determination"]
["After reviewing for relevance and accuracy, enter the information from Step 1 and Step 2 into the automated Worksheet, as indicated. The Worksheet is designed to automatically calculate the years of experience and identify the appropriate salary corridor, aka the Target Step and two steps lower. However, the manual method, described in Steps 1-3, above, can be performed any time. It is a good idea to know the manual process behind the automation, in case an explanation is requested. "]
[]
[]
[]
[]
[]
[]
["Other Considerations and Definitions:"]
["Events Requiring Creditable Experience Analysis, aka Salary Setting Events. In addition to Initial Hire, under ASF Article 12, Section F, two additional ASF situations are also \"salary setting events\" requiring a creditable experience analysis: 1) Promotion and 2) Re-Hire, after an unpaid break in service. However, the ONLY situations where a desired salary above the midpoint must be submitted to the System Office for approval is Initial Hire and Re-Hire.  "]
[]
[]
[]
[]
[]
[null,"1. Promotion to a MUSAASF position in a higher range requires a creditable experience analysis. See Article 12, Section G, Subd. 1. Exception: Classified employees whose positions have been re-compared to a MSUAASF position and whose initial salary placement in the appropriate MSUAASF range is determined by the compensation provisions of MMB’s Administrative Procedure 15.6, Transfers and Demotions; such promotions are treated for salary purposes as a Re-assignment under the MSUAASF contract and do NOT require creditable experience analysis. "]
[]
[]
[]
[]
[]
[]
[]
[null,"2. Re-hire into a MSUAASF position, after a break in service, also requires a creditable experience analysis. For this purpose, a break in service is an unpaid break with a distinct end date of the previous MSUAASF job and a distinct start date of the new MSUAASF job. In essence, the re-hired individual is treated the same as an initial hire."]
[]
[]
[]
[]
["Recording Work History. The individual’s work history must be recorded in SCUPPS on the Employee Information tab, including actual and creditable years. "]
[]
["An Explanation of this screen is available here. "]
[]
["Salary Corridor Grid; Identifying the Target Step. The salary corridor is a range of salaries encompassing the Target Step as the maximum salary, and the minimum salary found two steps lower than the Target Step. Determining the desired initial salary of a new MSUAASF employee requires use of the:"]
[]
[]
[]
["MSUAASF Salary Corridor Grid for Ranges A-E"]
["The TOTAL number of years of creditable work experience, rounded down to the nearest whole number, is placed on the vertical axis of the salary grid for the appropriate range. If any, the number of years previously spent in an equal or higher MSUAASF or a MnSCU Academic Professional, Academic Supervisor or Administrator position, also rounded down to the nearest whole number, is placed on the horizontal axis of the salary grid for the appropriate range. The new employee’s salary corridor is located within the salary grid at the intersection of the employee’s placement on the vertical and horizontal axes."]
[]
[]
[]
[]
[]
[]
[]
["Final Salary Determination. The overlying principle of compensation for ASF employees is consistency in equity and experience. However, some administrative discretion is built into the process. The campus may desire to place an ASF salary 1) within the salary corridor, 2) above the Target Step, or 3) above the midpoint of the salary range; each of which has different levels of discretion.  "]
[]
[]
[]
[]
[]
[null,"1. Within the Salary Corridor. Actual salary determination within the corridor for each new MSUAASF employee is at the university’s discretion. Initial salary step placement may be at the Target Step or down to two steps lower than the target. "]
[]
[]
[]
[null,"2. Above the Target Step. If a salary higher than the Target Step is needed to secure the new ASF employee, or an ASF employee re-hired after a break in service, the university may at its discretion offer a higher salary up to the midpoint of the range. These offers of a salary above the Target Step, but at or below the midpoint of the range, must take into consideration internal equity, market factors, and any other recruitment or unique circumstances related to the search and job offer. It is expected that the university will document these issues and retain this information in the employee’s personnel file. Market factors will ordinarily be documented through comparison to CUPA-HR salary survey data. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"3. Above the Midpoint. Upon initial hire and rehire after a break in service, if the university wishes to offer the new MSUAASF employee a salary above the midpoint of the salary range, including circumstances where the Target Step is above the midpoint, supporting documentation of the market and other factors must be submitted to the System Office for approval. Required, supporting documentation includes:"]
[]
[]
[]
[]
[null,"·   ASF Position Description (NOT simply the job posting)"]
[null,"·   Completed Creditable Work Experience Worksheet including indication of\n      Target Step"]
[]
[null,"·   Candidate's Resume"]
[null,"·   Applicable Campus Organization Chart, showing the position at issue"]
[null,"·   Comparable CUPA-HR Salary Survey Data from the table entitled, \"Unweighted\n      Salary Percentiles-Master's Institutions\""]
[]
[null,"·   Short narrative as to the underlying reasons and support for the request"]
[]
[]
["Form: ",null,null,"MSUAASF Creditable Work Experience: Worksheet "]
[]
["Other References:",null,null,"MSUAASF Creditable Work Experience: Guidelines "]
["                           ",null,null,"MSUAASF Salary Corridor Grids"]
[null,null,null,"MSUAASF Sample \"Above-the-Midpoint\" Request"]
[]
["Contracts and Plans: ",null,null,"MSUAASF Article 12"]
[]
["System Office Contact: ",null,null,"Mary Nadeau"]
[null,null,null,"Labor Relations Analyst"]
[null,null,null,"651-201-1880"]
[null,null,null,"mary.nadeau@so.mnscu.edu0."]

{"sheet":"Guidelines","index":1,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,0,0,10],[2,0,3,10],[6,0,8,10],[10,0,12,10],[14,0,14,10],[42,0,43,7],[33,8,33,10],[42,8,43,10],[16,0,17,10],[19,0,21,10],[23,0,25,10],[27,0,29,10],[33,0,33,7],[34,0,37,7],[34,8,37,10],[38,0,39,7],[38,8,39,10],[40,0,41,7],[40,8,41,10],[44,0,46,7],[44,8,46,10],[47,0,49,7],[47,8,49,10],[50,0,53,7],[50,8,53,10],[54,0,56,7],[54,8,56,10],[58,0,58,3],[59,0,59,3],[60,0,60,3],[58,8,58,10],[58,4,58,7],[59,8,59,10],[60,8,60,10],[59,4,59,7],[60,4,60,7],[62,4,62,7],[63,4,63,7],[61,8,61,10],[62,8,62,10],[63,8,63,10],[61,0,61,3],[67,0,67,3],[67,4,67,7],[67,8,67,10],[68,0,68,3],[68,4,68,7],[68,8,68,10],[64,8,64,10],[66,0,66,3],[66,4,66,7],[66,8,66,10],[62,0,62,3],[63,0,63,3],[64,0,64,3],[64,4,64,7],[61,4,61,7],[69,0,69,3],[69,4,69,7],[69,8,69,10],[70,0,70,3],[70,4,70,7],[70,8,70,10],[76,0,76,10],[71,0,71,3],[71,4,71,7],[71,8,71,10],[72,0,72,3],[72,4,72,7],[72,8,72,10]]}
["MSUAASF Creditable Work Experience: Guidelines"]
[]
["Note: These guidelines are intended to be used in conjunction with the MSUAASF Creditable Work Experience: Worksheet."]
[]
[]
["Criteria: "]
["·         Generally, the process for analyzing creditable work experience applies to initial hires into \n      MSUAASF, even if the candidate is coming from Minnesota State MAPE/MSCF/IFO positions, for \n      example, or if a former Minnesota State employee is re-hired after an unpaid break in service. "]
[]
[]
[]
["·         Years of work experience are expressed in terms of full-time equivalent (FTE) service with full-\n      time twelve-month workload equal to one (1) FTE year. No more than 1:00 FTE is credited in any \n      twelve month period. "]
[]
[]
[]
["·         No experience credit is accrued for time spent on leaves of absence without pay."]
[]
["·         Years of Service in teaching positions or administrative positions (i.e., Resident Hall Director, \n      Coaching, etc.) that are seasonal in nature are equal to one (1) FTE year."]
[]
[]
["·         Aggregate total creditable work experience for all categories is rounded down to the number of \n      full years completed. For example, a total of 7.67 FTE years is rounded down to seven (7) years\n      of total creditable experience for salary grid placement."]
[]
[]
[]
["·         Each period of work experience must be reviewed against the Categories of Creditable Work \n      experience for inclusion of exclusion. (See below.) Although most categories are valued at 100%, \n      some categories are valued at 50%. "]
[]
[]
[]
["·         All allowable full-time work experience is credited on a full-time equivalent (FTE) basis. Part-\n      time work is counted on a pro-rated basis. Academic and Non-Academic Experience is valued\n      according to the following formulas:  "]
[]
[]
[]
["Categories of Creditable Work:"]
[]
["Category (Each category coincides with a Type listed on the Worksheet)",null,null,null,null,null,null,null,"Percentage Credited"]
["Type 1 – Professional-level teaching & administrative experience WITHIN all Minnesota State colleges & universities. Includes: Years in Equal or Higher MSUAASF, MnSCU Academic Professional, MnSCU Academic Supervisor and/or MnSCU Administrator ranges. ",null,null,null,null,null,null,null,"FTE x 1.00 (fully-credited)"]
[]
[]
[]
["Type 2 – Professional-level teaching & administrative experience within higher education, OUTSIDE Minnesota State.",null,null,null,null,null,null,null,"FTE x 1.00 (fully-credited)"]
[]
["Type 3.1 - Professional-level teaching & administrative experience in K-12 (e.g., teacher, librarian, principal, superintendent, etc.)",null,null,null,null,null,null,null,"FTE x .50 (credited at 50%)"]
[]
["Type 3.2 - Professional-level OUTSIDE of education ONLY if the work experience is directly related to MSUAASF position upon hire.",null,null,null,null,null,null,null,"FTE x 1.00 (fully-credited)"]
[]
["Type 3.3 – Clerical/Technical/Paraprofessional/Lower-Level Professional experience WITHIN or OUTSIDE Minnesota State institutions ONLY if the work experience is directly related to MSUAASF position upon hire.",null,null,null,null,null,null,null,"FTE x .50 (credited at 50%)"]
[]
[]
["Type 3.4 – Graduate/teaching assistantships experience WITHIN or OUTSIDE Minnesota State institutions ONLY if the work experience is directly related to MSUAASF position upon hire.",null,null,null,null,null,null,null,"FTE x .50 (credited at 50%)"]
[]
[]
["Type 3.5 – Volunteer Experience: Professional-level volunteer experience ONLY if a) the work experience is directly related to MSUAASF position upon hire and b) if percent time is listed and c) volunteer work does not overlap with other experience credited.",null,null,null,null,null,null,null,"FTE x 1.00 (fully-credited)"]
[]
[]
[]
["Type 3.6 – Minnesota Statute §192.261 requires recognition of years of military service which resulted from conscription and which interrupted service in the Minnesota State Colleges and Universities system. ",null,null,null,null,null,null,null,"FTE x 1.00 (fully-credited)"]
[]
[]
[]
["Academic Experience",null,null,null,null,null,null,null,"Applicable FTE Credit"]
["Full-time Academic Year",null,null,null,"Equals",null,null,null,"1.00 FTE"]
["Part-time Academic Year",null,null,null,"Percent time employed equals",null,null,null,"Portion of 1.00 FTE"]
["Full-time Academic Quarter",null,null,null,"Equals ",null,null,null,".33 FTE"]
["Part-time Academic Quarter",null,null,null,"Percent time employed X .33 equals",null,null,null,"Portion of .33 FTE"]
["Full-time Academic Semester",null,null,null,"Equals",null,null,null,".50 FTE"]
["Part-time Academic Semester",null,null,null,"Percent time employed X .50 equals",null,null,null,"Portion of .50 FTE"]
[]
["Non-Academic Experience",null,null,null,null,null,null,null,"Applicable FTE Credit"]
["Full-time twelve months",null,null,null,"Equals",null,null,null,"1.00 FTE"]
["Part-time twelve months",null,null,null,"Percent time employed equals",null,null,null,"Portion of 1.00 FTE"]
["Full-time Academic Quarter",null,null,null,"Equals ",null,null,null,".25 FTE"]
["Part-time Academic Quarter",null,null,null,"Percent time employed X .25 equals",null,null,null,"Portion of .25 FTE"]
["Full-time Academic Semester",null,null,null,"Equals",null,null,null,".33 FTE"]
["Part-time Academic Semester",null,null,null,"Percent time employed X .33 equals",null,null,null,"Portion of .33 FTE"]
[]
[]
[]
["2016-11-10"]

{"sheet":"Worksheet","index":2,"n_rows":172,"n_cols":22,"rows_kept":172,"cut":false,"hidden":false,"merged":[[147,8,147,9],[148,8,148,9],[150,8,150,9],[148,21,148,22],[151,21,151,22],[171,3,171,9],[148,3,148,6],[151,3,151,6],[145,3,145,6],[160,6,161,8],[158,4,159,5],[160,4,161,5],[155,4,155,8],[156,4,157,5],[156,6,157,8],[158,6,159,8],[151,8,151,9],[147,3,147,6],[150,3,150,6],[137,2,137,9],[144,21,144,22],[145,21,145,22],[139,3,142,9],[144,3,144,6],[124,2,124,9],[118,3,119,8],[120,3,121,8],[118,9,119,9],[120,9,121,9],[145,8,145,9],[144,8,144,9],[126,7,130,9],[72,3,72,8],[83,3,83,8],[96,3,96,8],[83,9,84,9],[72,9,73,9],[96,9,97,9],[21,2,21,9],[74,9,80,9],[85,9,91,9],[32,6,32,7],[30,6,30,7],[25,9,31,9],[36,9,42,9],[42,6,42,7],[43,6,43,7],[45,2,45,9],[70,2,70,9],[94,2,94,9],[59,9,60,9],[56,6,56,7],[16,3,16,9],[48,3,48,8],[47,3,47,8],[23,3,23,8],[23,9,24,9],[34,3,34,8],[48,9,49,9],[34,9,35,9],[17,5,17,9],[41,6,41,7],[31,6,31,7],[98,9,104,9],[0,2,0,10],[2,17,2,19],[3,17,3,19],[2,5,2,6],[3,5,3,6],[18,3,18,4],[18,5,18,9],[8,3,8,4],[11,3,11,4],[10,3,10,4],[9,3,9,4],[8,5,8,9],[9,5,9,9],[10,5,10,9],[11,5,11,9],[6,2,6,9],[13,3,13,4],[14,3,14,4],[13,5,13,9],[3,3,3,4],[2,3,2,4],[14,5,14,9],[17,3,17,4],[1,14,1,15],[116,6,116,7],[90,6,90,7],[91,6,91,7],[92,6,92,7],[103,6,103,7],[104,6,104,7],[57,6,57,7],[66,6,66,7],[67,6,67,7],[59,3,59,8],[109,9,115,9],[105,6,105,7],[114,6,114,7],[115,6,115,7],[68,6,68,7],[79,6,79,7],[80,6,80,7],[81,6,81,7],[50,9,56,9],[61,9,67,9],[55,6,55,7],[107,3,107,8],[107,9,108,9]]}
[1,null,"MSUAASF Creditable Work Experience: Worksheet",null,null,null,null,null,null,null,null,null,"Range"]
[1,null,null,null,null,null,null,null,null,null,null,null,"A",null,"TEST"]
[1,null,null,"Name of Candidate:",null,null,null,null,"Range:",null,null,null,"B",null,"H3",{"$f":"OR(LEN(J3)=0)","v":true}]
[1,null,null,"Department/Position:",null,null,null,null,"Date:",null,null,null,"C",null,"D4",{"$f":"OR(LEN(F4)=0)","v":true}]
[1,null,null,null,"FY:","7/1/2022 (FY23)",null,null,null,null,null,null,"D"]
[1,null,null,null,null,null,null,null,null,null,null,null,"E"]
[1,null,"A.  Degree/Professional Certification/Equivalency Requirement:"]
[1]
[1,null,null,"Degree:"]
[1,null,null,"Date:"]
[1,null,null,"Educational Institution:"]
[1,null,null,"Field of Study:"]
[1,null,null,"OR"]
[1,null,null,"Professional Certification:"]
[1,null,null,"Granting Authority:"]
[1,null,null,"OR"]
[1,null,null,"Equivalent Combination of Education and Experience"]
[1,null,null,"Education Information:"]
[1,null,null,"Experience Information:"]
[1]
[1]
[1,null,"B.  Creditable Experience Determination"]
[1]
[1,null,null,"Type 1: Professional-level teaching & administrative experience within ALL Minnesota State colleges and universities. Includes: Years in Equal or Higher MSUAASF, MnSCU Academic Professional, MnSCU Academic Supervisor  and/or MnSCU Administrator Ranges",null,null,null,null,null,"Creditable\nYears",null,"heruherherheirfheujfuh"]
[1,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[1,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H26),\"\",(E26-D26)/365*H26)","v":""}]
[1,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H27),\"\",(E27-D27)/365*H27)","v":""}]
[1,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H28),\"\",(E28-D28)/365*H28)","v":""}]
[1,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H29),\"\",(E29-D29)/365*H29)","v":""}]
[1,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H30),\"\",(E30-D30)/365*H30)","v":""}]
[1,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I26:I30)","v":0}]
[1,null,null,null,null,null,"Weighted Value:",null,1]
[1,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I31*I32,0)","v":0},{"$f":"I33","v":0}]
[1]
[2,null,null,"Type 2: Professional-level teaching & administrative experience within higher education, outside of Minnesota State",null,null,null,null,null,"Creditable\nYears",null,"reorjhioehrio"]
[2,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H37),\"\",(E37-D37)/365*H37)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H38),\"\",(E38-D38)/365*H38)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H39),\"\",(E39-D39)/365*H39)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H40),\"\",(E40-D40)/365*H40)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H41),\"\",(E41-D41)/365*H41)","v":""}]
[2,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I37:I41)","v":0}]
[2,null,null,null,null,null,"Weighted Value:",null,1]
[2,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I42*I43,0)","v":0},{"$f":"I44","v":0}]
[2]
[1,null,"B.  Creditable Experience Determination (Continued)"]
[1]
[2,null,null,"Type 3: Discretionary"]
[2,null,null,"Type 3.1: Professional-level teaching & administrative experience in K-12 (e.g., teacher, librarian, principal, superintendent, etc.) ",null,null,null,null,null,"Creditable\nYears",null,"reorjhioehrio"]
[2,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H51),\"\",(E51-D51)/365*H51)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H52),\"\",(E52-D52)/365*H52)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H53),\"\",(E53-D53)/365*H53)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H54),\"\",(E54-D54)/365*H54)","v":""}]
[2,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H55),\"\",(E55-D55)/365*H55)","v":""}]
[2,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I51:I55)","v":0}]
[2,null,null,null,null,null,"Weighted Value:",null,0.5]
[2,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I56*I57,0)","v":0},{"$f":"I58","v":0}]
[2]
[3,null,null,"Type 3.2: Professional level experience outside education ONLY if work experience is directly related to the MSUAASF position upon hire",null,null,null,null,null,"Creditable\nYears",null,"reorjhioehrio"]
[3,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H62),\"\",(E62-D62)/365*H62)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H63),\"\",(E63-D63)/365*H63)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H64),\"\",(E64-D64)/365*H64)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H65),\"\",(E65-D65)/365*H65)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H66),\"\",(E66-D66)/365*H66)","v":""}]
[3,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I62:I66)","v":0}]
[3,null,null,null,null,null,"Weighted Value:",null,1]
[3,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I67*I68,0)","v":0},{"$f":"I69","v":0}]
[3]
[1,null,"B.  Creditable Experience Determination (Continued)"]
[1]
[3,null,null,"Type 3.3: Clerical/Technical/Paraprofessional/Lower-Level Professional experience within/or outside Minnesota State institutions ONLY if the work experience is directly related to the MSUAASF position upon hire",null,null,null,null,null,"Creditable\nYears",null,"uehrehruehrueihewu"]
[3,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H75),\"\",(E75-D75)/365*H75)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H76),\"\",(E76-D76)/365*H76)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H77),\"\",(E77-D77)/365*H77)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H78),\"\",(E78-D78)/365*H78)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H79),\"\",(E79-D79)/365*H79)","v":""}]
[3,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I75:I79)","v":0}]
[3,null,null,null,null,null,"Weighted Value:",null,0.5]
[3,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I80*I81,0)","v":0},{"$f":"I82","v":0}]
[3]
[3,null,null,"Type 3.4: Graduate/teaching assistantships Experience within/or outside Minnesota State institutions ONLY if the work experience is directly related to the MSUAASF position upon hire",null,null,null,null,null,"Creditable\nYears",null,"reorjhioehrio"]
[3,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H86),\"\",(E86-D86)/365*H86)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H87),\"\",(E87-D87)/365*H87)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H88),\"\",(E88-D88)/365*H88)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H89),\"\",(E89-D89)/365*H89)","v":""}]
[3,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H90),\"\",(E90-D90)/365*H90)","v":""}]
[3,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I86:I90)","v":0}]
[3,null,null,null,null,null,"Weighted Value:",null,0.5]
[3,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I91*I92,0)","v":0},{"$f":"I93","v":0}]
[3]
[1,null,"B.  Creditable Experience Determination (Continued)"]
[1]
[4,null,null,"Type 3.5: Volunteer Experience: Professional-level experience ONLY if:\na) the work experience is directly related to the MSUAASF position upon hire and\nb) if percent time is listed and \nc) volunteer work does not overlap with other experience credited \n",null,null,null,null,null,"Creditable\nYears",null,"reorjhioehriojekthekhehernejrhejr"]
[4,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H99),\"\",(E99-D99)/365*H99)","v":""}]
[4]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H101),\"\",(E101-D101)/365*H101)","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H102),\"\",(E102-D102)/365*H102)","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H103),\"\",(E103-D103)/365*H103)","v":""}]
[4,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I99:I103)","v":0}]
[4,null,null,null,null,null,"Weighted Value:",null,1]
[4,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I104*I105,0)","v":0},{"$f":"I106","v":0}]
[4]
[4,null,null,"Type 3.6: Minnesota Statute 192.261 requires recognition of years of military service which resulted from conscription (drafted) and which interrupted service to Minnesota State",null,null,null,null,null,"Creditable\nYears",null,"reorjhioehriojekt"]
[4,null,null,"Start Date","End Date","Position/\nRank","Institution","FTE ","Applicable\nYears",null,null,"heruherherheir"]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H110),\"\",(E110-D110)/365*H110)","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H111),\"\",(E111-D111)/365*H111)","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H112),\"\",(E112-D112)/365*H112)","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H113),\"\",(E113-D113)/365*H113)","v":""}]
[4,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(H114),\"\",(E114-D114)/365*H114)","v":""}]
[4,null,null,null,null,null,"Subtotal Applicable Years:",null,{"$f":"SUM(I110:I114)","v":0}]
[4,null,null,null,null,null,"Weighted Value:",null,1]
[4,null,null,null,null,null,"Creditable Years:",null,{"$f":"ROUNDDOWN(I115*I116,0)","v":0},{"$f":"I117","v":0}]
[4]
[4,null,null,"Total Creditable Years Experience:\n(Sum of Type 1 through Type 3.6)",null,null,null,null,null,{"$f":"ROUNDDOWN(SUM($J$33:$J$117),0)","v":0}]
[4]
[4,null,null,"Total Creditable Years Minnesota State Experience:\n(Type 1 Total)",null,null,null,null,null,{"$f":"ROUNDDOWN(J33,0)","v":0}]
[4]
[4]
[4]
[4,null,"C.  Step Placement Determination Based on Creditable Years Experience"]
[4]
[4,null,null,null,"Type","Step","Salary",{"$f":"IF($F$128=\"\",\"\",IF($F$128>10,\"Contact System Office for approval above Step 10. Attach Approval.\",\"\"))","v":""}]
[4,null,null,null,"Target"]
[4,null,null,null,"Minimum"]
[4]
[4,null,null,"NOTE:"]
[4,null,null,"1. At or below target - may not be more than two steps lower than target,"]
[4,null,null,"2. Above target up to and including step 10 - university must retain market justification, or"]
[4,null,null,"3. Above target over step 10 - university must receive prior approval from Minnesota State system office"]
[4]
[4]
[4]
[5,null,"D.  Approvals"]
[5]
[5,null,null,"I attest that all statements and representations set forth above are true and accurate. Inaccurate statements or misrepresentations concerning my work experience may lead the University to take one or more of the following actions: withdrawal of an offer of employment; modification of starting salary; and in the event that I become an employee, disciplinary action up to and including discharge."]
[5]
[5]
[5]
[5]
[5]
[5,null,null,"Candidate Signature",null,null,null,null,"Date",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[5]
[5]
[5,null,null,"Evaluator 1 Signature\n(Supervisor or VP)",null,null,null,null,"Date",null,null,"fnwrfhjewerhfie",null,null,null,null,null,null,null,null,null,"Date"]
[5]
[5]
[5,null,null,"Evaluator 2 Signature\n(CHRO/Designee)",null,null,null,null,"Date",null,null,"fnwrfhjewerhfie",null,null,null,null,null,null,null,null,null,"Date"]
[5]
[5]
[5]
[5,null,null,null,"Director / Vice President Use Only"]
[5,null,null,null,"PRF Number"]
[5]
[5,null,null,null,"Position Number"]
[5,null,null,null,"Position Number"]
[5,null,null,null,"Appt Status"]
[5,null,null,null,"Appt Status"]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[5]
[null,null,null,"Retain this form and all attached documentation in Human Resources.  Last Revision 11/2016."]

{"sheet":"(HIDE) MASTER-Chart","index":3,"n_rows":22,"n_cols":18,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,0,0,6],[0,11,0,17]]}
["7/1/2021 (FY22)",null,null,null,null,null,null,null,"Ranges for \nDropdown","FY",null,"7/1/2022 (FY23)"]
["Step","Sort","Range A","Range B","Range C","Range D","Range E",null,"A","7/1/2021 (FY22)",null,"Step","Sort","Range A","Range B","Range C","Range D","Range E"]
["Step 1",1,0,36632,43785,51311,59867,null,"B","7/1/2022 (FY23)",null,"Step 1",1,"$            -",37108,44354,51978,60645]
["Step 2",2,0,37606,44950,52677,61457,null,"C",null,null,"Step 2",2,"$            -",38095,45534,53362,62256]
["Step 3",3,0,38723,46314,54241,63282,null,"D",null,null,"Step 3",3,"$            -",39226,46916,54946,64105]
["Step 4",4,0,39884,47675,55870,65183,null,"E",null,null,"Step 4",4,"$            -",40402,48295,56596,66030]
["Step 5",5,34160,41193,49125,58079,67259,null,null,null,null,"Step 5",5,34604,41729,49764,58834,68133]
["Step 6",6,35070,42500,50727,60282,69340,null,null,null,null,"Step 6",6,35526,43053,51386,61066,70241]
["Step 7",7,36110,43809,52089,62486,71418,null,null,null,null,"Step 7",7,36579,44379,52766,63298,72346]
["Step 8",8,37194,45121,53607,64694,73516,null,null,null,null,"Step 8",8,37678,45708,54304,65535,74472]
["Step 9",9,38422,46426,55171,66863,75679,null,null,null,null,"Step 9",9,38921,47030,55888,67732,76663]
["Step 10",10,39653,47777,56781,69112,77907,null,null,null,null,"Step 10",10,40168,48398,57519,70010,78920]
["Step 11",11,40885,49165,58440,71436,80202,null,null,null,null,"Step 11",11,41417,49804,59200,72365,81245]
["Step 12",12,42119,50598,60150,73838,82562,null,null,null,null,"Step 12",12,42667,51256,60932,74798,83635]
["Step 13",13,43345,52070,61910,76325,84993,null,null,null,null,"Step 13",13,43908,52747,62715,77317,86098]
["Step 14",14,44600,53586,63726,78897,87502,null,null,null,null,"Step 14",14,45180,54283,64554,79923,88640]
["Step 15",15,45892,55154,65591,81553,90082,null,null,null,null,"Step 15",15,46489,55871,66444,82613,91253]
["Step 16",16,47225,56765,67513,84309,92742,null,null,null,null,"Step 16",16,47839,57503,68391,85405,93948]
["Step 17",17,48596,58423,69498,86793,95480,null,null,null,null,"Step 17",17,49228,59182,70401,87921,96721]
["Step 18",18,50014,60133,71534,89351,98303,null,null,null,null,"Step 18",18,50664,60915,72464,90513,99581]
["Step 19",19,51471,61890,73632,91984,101206,null,null,null,null,"Step 19",19,52140,62695,74589,93180,102522]
["Step 20",20,53014,63747,75840,94744,104244,null,null,null,null,"Step 20",20,53703,64576,76826,95976,105599]

{"sheet":"(HIDE) Sheet1","index":4,"n_rows":173,"n_cols":29,"rows_kept":173,"cut":false,"hidden":true,"merged":[[0,1,0,13],[0,16,0,28]]}
[null,"Low",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"High"]
["Lookup","Range","YRS EXP",0,1,2,3,4,5,6,7,8,9,10,null,"Lookup","Range","YRS EXP",0,1,2,3,4,5,6,7,8,9,10]
["A0","A",0,5,5,{"$f":"E3","v":5},{"$f":"F3","v":5},5,5,5,5,5,5,5,null,"A0","A",0,6,6,{"$f":"T3","v":6},6,6,6,6,6,6,6,6]
["A1","A",1,5,5,{"$f":"E4","v":5},5,5,5,5,5,5,5,5,null,"A1","A",1,6,6,6,6,6,6,6,6,6,6,6]
["A2","A",2,5,5,5,5,5,5,5,5,5,5,5,null,"A2","A",2,7,7,7,7,7,7,7,7,7,7,7]
["A3","A",3,5,5,5,5,5,5,5,5,5,5,5,null,"A3","A",3,7,7,7,7,7,7,7,7,7,7,7]
["A4","A",4,6,6,6,6,7,7,7,7,7,7,7,null,"A4","A",4,8,8,8,8,9,9,9,9,9,9,9]
["A5","A",5,6,6,6,6,7,7,7,7,7,7,7,null,"A5","A",5,8,8,8,8,9,9,9,9,9,9,9]
["A6","A",6,7,7,7,7,8,8,8,8,8,8,8,null,"A6","A",6,9,9,9,9,10,10,10,10,10,10,10]
["A7","A",7,7,7,7,7,8,8,8,8,8,8,8,null,"A7","A",7,9,9,9,9,10,10,10,10,10,10,10]
["A8","A",8,8,8,8,8,9,9,9,9,10,10,10,null,"A8","A",8,10,10,10,10,11,11,11,11,12,12,12]
["A9","A",9,8,8,8,8,9,9,9,9,10,10,10,null,"A9","A",9,10,10,10,10,11,11,11,11,12,12,12]
["A10","A",10,9,9,9,9,10,10,10,10,11,11,11,null,"A10","A",10,11,11,11,11,12,12,12,12,13,13,13]
["A11","A",11,9,9,9,9,10,10,10,10,11,11,11,null,"A11","A",11,11,11,11,11,12,12,12,12,13,13,13]
["A12","A",12,9,9,10,10,11,11,11,11,12,12,12,null,"A12","A",12,11,11,12,12,13,13,13,13,14,14,14]
["A13","A",13,9,9,10,10,11,11,11,11,12,12,12,null,"A13","A",13,11,11,12,12,13,13,13,13,14,14,14]
["A14","A",14,10,10,11,11,11,11,12,12,12,12,13,null,"A14","A",14,12,12,13,13,13,13,14,14,14,14,15]
["A15","A",15,10,10,11,11,11,11,12,12,12,12,13,null,"A15","A",15,12,12,13,13,13,13,14,14,14,14,15]
["A16","A",16,11,11,12,12,12,12,13,13,13,13,14,null,"A16","A",16,13,13,14,14,14,14,15,15,15,15,16]
["A17","A",17,11,11,12,12,12,12,13,13,13,13,14,null,"A17","A",17,13,13,14,14,14,14,15,15,15,15,16]
["A18","A",18,12,12,12,12,13,13,13,13,14,14,14,null,"A18","A",18,14,14,14,14,15,15,15,15,16,16,16]
["A19","A",19,12,12,12,12,13,13,13,13,14,14,14,null,"A19","A",19,14,14,14,14,15,15,15,15,16,16,16]
["A20","A",20,13,13,13,13,14,14,14,14,14,14,14,null,"A20","A",20,15,15,15,15,16,16,16,16,16,16,16]
["A21","A",21,13,13,13,13,14,14,14,14,14,14,14,null,"A21","A",21,15,15,15,15,16,16,16,16,16,16,16]
["A22","A",22,14,14,14,14,14,14,14,14,14,14,14,null,"A22","A",22,16,16,16,16,16,16,16,16,16,16,16]
["B0","B",0,2,2,{"$f":"E26","v":2},2,2,2,2,2,2,2,2,null,"B0","B",0,4,4,{"$f":"T26","v":4},4,4,4,4,4,4,4,4]
["B1","B",1,2,2,2,2,2,2,2,2,2,2,2,null,"B1","B",1,4,4,4,4,4,4,4,4,4,4,4]
["B2","B",2,3,3,3,3,3,3,3,3,3,3,3,null,"B2","B",2,5,5,5,5,5,5,5,5,5,5,5]
["B3","B",3,3,3,3,3,3,3,3,3,3,3,3,null,"B3","B",3,5,5,5,5,5,5,5,5,5,5,5]
["B4","B",4,4,4,4,4,5,5,5,5,5,5,5,null,"B4","B",4,6,6,6,6,7,7,7,7,7,7,7]
["B5","B",5,4,4,4,4,5,5,5,5,5,5,5,null,"B5","B",5,6,6,6,6,7,7,7,7,7,7,7]
["B6","B",6,5,5,5,5,6,6,6,6,6,6,6,null,"B6","B",6,7,7,7,7,8,8,8,8,8,8,8]
["B7","B",7,5,5,5,5,6,6,6,6,6,6,6,null,"B7","B",7,7,7,7,7,8,8,8,8,8,8,8]
["B8","B",8,5,5,6,6,6,6,7,7,7,7,7,null,"B8","B",8,7,7,8,8,8,8,9,9,9,9,9]
["B9","B",9,5,5,6,6,6,6,7,7,7,7,7,null,"B9","B",9,7,7,8,8,8,8,9,9,9,9,9]
["B10","B",10,6,6,7,7,7,7,8,8,8,8,9,null,"B10","B",10,8,8,9,9,9,9,10,10,10,10,11]
["B11","B",11,6,6,7,7,7,7,8,8,8,8,9,null,"B11","B",11,8,8,9,9,9,9,10,10,10,10,11]
["B12","B",12,7,7,8,8,8,8,8,8,9,9,9,null,"B12","B",12,9,9,10,10,10,10,10,10,11,11,11]
["B13","B",13,7,7,8,8,8,8,8,8,9,9,9,null,"B13","B",13,9,9,10,10,10,10,10,10,11,11,11]
["B14","B",14,8,8,8,8,9,9,9,9,10,10,10,null,"B14","B",14,10,10,10,10,11,11,11,11,12,12,12]
["B15","B",15,8,8,8,8,9,9,9,9,10,10,10,null,"B15","B",15,10,10,10,10,11,11,11,11,12,12,12]
["B16","B",16,9,9,9,9,9,9,10,10,10,10,11,null,"B16","B",16,11,11,11,11,11,11,12,12,12,12,13]
["B17","B",17,9,9,9,9,9,9,10,10,10,10,11,null,"B17","B",17,11,11,11,11,11,11,12,12,12,12,13]
["B18","B",18,9,9,10,10,10,10,11,11,11,11,11,null,"B18","B",18,11,11,12,12,12,12,13,13,13,13,13]
["B19","B",19,9,9,10,10,10,10,11,11,11,11,11,null,"B19","B",19,11,11,12,12,12,12,13,13,13,13,13]
["B20","B",20,10,10,10,10,11,11,11,11,12,12,12,null,"B20","B",20,12,12,12,12,13,13,13,13,14,14,14]
["B21","B",21,10,10,10,10,11,11,11,11,12,12,12,null,"B21","B",21,12,12,12,12,13,13,13,13,14,14,14]
["B22","B",22,11,11,11,11,12,12,12,12,12,12,13,null,"B22","B",22,13,13,13,13,14,14,14,14,14,14,15]
["B23","B",23,11,11,11,11,12,12,12,12,12,12,13,null,"B23","B",23,13,13,13,13,14,14,14,14,14,14,15]
["B24","B",24,11,11,12,12,12,12,13,13,13,13,13,null,"B24","B",24,13,13,14,14,14,14,15,15,15,15,15]
["B25","B",25,11,11,12,12,12,12,13,13,13,13,13,null,"B25","B",25,13,13,14,14,14,14,15,15,15,15,15]
["B26","B",26,12,12,13,13,13,13,13,13,14,14,14,null,"B26","B",26,14,14,15,15,15,15,15,15,16,16,16]
["B27","B",27,12,12,13,13,13,13,13,13,14,14,14,null,"B27","B",27,14,14,15,15,15,15,15,15,16,16,16]
["B28","B",28,13,13,13,13,14,14,14,14,14,14,14,null,"B28","B",28,15,15,15,15,16,16,16,16,16,16,16]
["B29","B",29,13,13,13,13,14,14,14,14,14,14,14,null,"B29","B",29,15,15,15,15,16,16,16,16,16,16,16]
["B30","B",30,13,13,14,14,14,14,14,14,14,14,14,null,"B30","B",30,15,15,16,16,16,16,16,16,16,16,16]
["B31","B",31,13,13,14,14,14,14,14,14,14,14,14,null,"B31","B",31,15,15,16,16,16,16,16,16,16,16,16]
["B32","B",32,14,14,14,14,14,14,14,14,14,14,14,null,"B32","B",32,16,16,16,16,16,16,16,16,16,16,16]
["C0","C",0,1,1,{"$f":"E59","v":1},1,1,1,1,1,1,1,1,null,"C0","C",0,3,3,{"$f":"T59","v":3},3,3,3,3,3,3,3,3]
["C1","C",1,1,1,1,1,1,1,1,1,1,1,1,null,"C1","C",1,3,3,3,3,3,3,3,3,3,3,3]
["C2","C",2,2,2,2,2,2,2,2,2,2,2,2,null,"C2","C",2,4,4,4,4,4,4,4,4,4,4,4]
["C3","C",3,2,2,2,2,2,2,2,2,2,2,2,null,"C3","C",3,4,4,4,4,4,4,4,4,4,4,4]
["C4","C",4,3,3,3,3,4,4,4,4,4,4,4,null,"C4","C",4,5,5,5,5,6,6,6,6,6,6,6]
["C5","C",5,3,3,3,3,4,4,4,4,4,4,4,null,"C5","C",5,5,5,5,5,6,6,6,6,6,6,6]
["C6","C",6,3,3,4,4,4,4,5,5,5,5,5,null,"C6","C",6,5,5,6,6,6,6,7,7,7,7,7]
["C7","C",7,3,3,4,4,4,4,5,5,5,5,5,null,"C7","C",7,5,5,6,6,6,6,7,7,7,7,7]
["C8","C",8,4,4,5,5,5,5,5,5,6,6,6,null,"C8","C",8,6,6,7,7,7,7,7,7,8,8,8]
["C9","C",9,4,4,5,5,5,5,5,5,6,6,6,null,"C9","C",9,6,6,7,7,7,7,7,7,8,8,8]
["C10","C",10,5,5,5,5,6,6,6,6,7,7,7,null,"C10","C",10,7,7,7,7,8,8,8,8,9,9,9]
["C11","C",11,5,5,5,5,6,6,6,6,7,7,7,null,"C11","C",11,7,7,7,7,8,8,8,8,9,9,9]
["C12","C",12,6,6,6,6,6,6,7,7,7,7,8,null,"C12","C",12,8,8,8,8,8,8,9,9,9,9,10]
["C13","C",13,6,6,6,6,6,6,7,7,7,7,8,null,"C13","C",13,8,8,8,8,8,8,9,9,9,9,10]
["C14","C",14,6,6,7,7,7,7,7,7,8,8,8,null,"C14","C",14,8,8,9,9,9,9,9,9,10,10,10]
["C15","C",15,6,6,7,7,7,7,7,7,8,8,8,null,"C15","C",15,8,8,9,9,9,9,9,9,10,10,10]
["C16","C",16,7,7,7,7,8,8,8,8,8,8,9,null,"C16","C",16,9,9,9,9,10,10,10,10,10,10,11]
["C17","C",17,7,7,7,7,8,8,8,8,8,8,9,null,"C17","C",17,9,9,9,9,10,10,10,10,10,10,11]
["C18","C",18,8,8,8,8,8,8,9,9,9,9,9,null,"C18","C",18,10,10,10,10,10,10,11,11,11,11,11]
["C19","C",19,8,8,8,8,8,8,9,9,9,9,9,null,"C19","C",19,10,10,10,10,10,10,11,11,11,11,11]
["C20","C",20,8,8,9,9,9,9,9,9,10,10,10,null,"C20","C",20,10,10,11,11,11,11,11,11,12,12,12]
["C21","C",21,8,8,9,9,9,9,9,9,10,10,10,null,"C21","C",21,10,10,11,11,11,11,11,11,12,12,12]
["C22","C",22,9,9,9,9,10,10,10,10,10,10,11,null,"C22","C",22,11,11,11,11,12,12,12,12,12,12,13]
["C23","C",23,9,9,9,9,10,10,10,10,10,10,11,null,"C23","C",23,11,11,11,11,12,12,12,12,12,12,13]
["C24","C",24,9,9,10,10,10,10,11,11,11,11,11,null,"C24","C",24,11,11,12,12,12,12,13,13,13,13,13]
["C25","C",25,9,9,10,10,10,10,11,11,11,11,11,null,"C25","C",25,11,11,12,12,12,12,13,13,13,13,13]
["C26","C",26,10,10,10,10,11,11,11,11,11,11,12,null,"C26","C",26,12,12,12,12,13,13,13,13,13,13,14]
["C27","C",27,10,10,10,10,11,11,11,11,11,11,12,null,"C27","C",27,12,12,12,12,13,13,13,13,13,13,14]
["C28","C",28,11,11,11,11,11,11,12,12,12,12,12,null,"C28","C",28,13,13,13,13,13,13,14,14,14,14,14]
["C29","C",29,11,11,11,11,11,11,12,12,12,12,12,null,"C29","C",29,13,13,13,13,13,13,14,14,14,14,14]
["C30","C",30,11,11,12,12,12,12,12,12,13,13,13,null,"C30","C",30,13,13,14,14,14,14,14,14,15,15,15]
["C31","C",31,11,11,12,12,12,12,12,12,13,13,13,null,"C31","C",31,13,13,14,14,14,14,14,14,15,15,15]
["C32","C",32,12,12,12,12,12,12,13,13,13,13,13,null,"C32","C",32,14,14,14,14,14,14,15,15,15,15,15]
["C33","C",33,12,12,12,12,12,12,13,13,13,13,13,null,"C33","C",33,14,14,14,14,14,14,15,15,15,15,15]
["C34","C",34,12,12,13,13,13,13,13,13,14,14,14,null,"C34","C",34,14,14,15,15,15,15,15,15,16,16,16]
["C35","C",35,12,12,13,13,13,13,13,13,14,14,14,null,"C35","C",35,14,14,15,15,15,15,15,15,16,16,16]
["C36","C",36,13,13,13,13,14,14,14,14,14,14,14,null,"C36","C",36,15,15,15,15,16,16,16,16,16,16,16]
["D0","D",0,3,3,{"$f":"E96","v":3},3,3,3,3,3,3,3,3,null,"D0","D",0,5,5,{"$f":"T96","v":5},5,5,5,5,5,5,5,5]
["D1","D",1,3,3,3,3,3,3,3,3,3,3,3,null,"D1","D",1,5,5,5,5,5,5,5,5,5,5,5]
["D2","D",2,4,4,4,4,4,4,4,4,4,4,4,null,"D2","D",2,6,6,6,6,6,6,6,6,6,6,6]
["D3","D",3,4,4,4,4,4,4,4,4,4,4,4,null,"D3","D",3,6,6,6,6,6,6,6,6,6,6,6]
["D4","D",4,4,4,5,5,5,5,5,5,5,5,5,null,"D4","D",4,6,6,7,7,7,7,7,7,7,7,7]
["D5","D",5,4,4,5,5,5,5,5,5,5,5,5,null,"D5","D",5,6,6,7,7,7,7,7,7,7,7,7]
["D6","D",6,5,5,5,5,5,5,6,6,6,6,6,null,"D6","D",6,7,7,7,7,7,7,8,8,8,8,8]
["D7","D",7,5,5,5,5,5,5,6,6,6,6,6,null,"D7","D",7,7,7,7,7,7,7,8,8,8,8,8]
["D8","D",8,5,5,6,6,6,6,6,6,7,7,7,null,"D8","D",8,7,7,8,8,8,8,8,8,9,9,9]
["D9","D",9,5,5,6,6,6,6,6,6,7,7,7,null,"D9","D",9,7,7,8,8,8,8,8,8,9,9,9]
["D10","D",10,6,6,6,6,6,6,7,7,7,7,7,null,"D10","D",10,8,8,8,8,8,8,9,9,9,9,9]
["D11","D",11,6,6,6,6,6,6,7,7,7,7,7,null,"D11","D",11,8,8,8,8,8,8,9,9,9,9,9]
["D12","D",12,6,6,7,7,7,7,7,7,7,7,8,null,"D12","D",12,8,8,9,9,9,9,9,9,9,9,10]
["D13","D",13,6,6,7,7,7,7,7,7,7,7,8,null,"D13","D",13,8,8,9,9,9,9,9,9,9,9,10]
["D14","D",14,7,7,7,7,7,7,8,8,8,8,8,null,"D14","D",14,9,9,9,9,9,9,10,10,10,10,10]
["D15","D",15,7,7,7,7,7,7,8,8,8,8,8,null,"D15","D",15,9,9,9,9,9,9,10,10,10,10,10]
["D16","D",16,7,7,8,8,8,8,8,8,8,8,9,null,"D16","D",16,9,9,10,10,10,10,10,10,10,10,11]
["D17","D",17,7,7,8,8,8,8,8,8,8,8,9,null,"D17","D",17,9,9,10,10,10,10,10,10,10,10,11]
["D18","D",18,8,8,8,8,8,8,9,9,9,9,9,null,"D18","D",18,10,10,10,10,10,10,11,11,11,11,11]
["D19","D",19,8,8,8,8,8,8,9,9,9,9,9,null,"D19","D",19,10,10,10,10,10,10,11,11,11,11,11]
["D20","D",20,8,8,8,8,9,9,9,9,9,9,10,null,"D20","D",20,10,10,10,10,11,11,11,11,11,11,12]
["D21","D",21,8,8,8,8,9,9,9,9,9,9,10,null,"D21","D",21,10,10,10,10,11,11,11,11,11,11,12]
["D22","D",22,9,9,9,9,9,9,9,9,10,10,10,null,"D22","D",22,11,11,11,11,11,11,11,11,12,12,12]
["D23","D",23,9,9,9,9,9,9,9,9,10,10,10,null,"D23","D",23,11,11,11,11,11,11,11,11,12,12,12]
["D24","D",24,9,9,9,9,10,10,10,10,10,10,10,null,"D24","D",24,11,11,11,11,12,12,12,12,12,12,12]
["D25","D",25,9,9,9,9,10,10,10,10,10,10,10,null,"D25","D",25,11,11,11,11,12,12,12,12,12,12,12]
["D26","D",26,9,9,10,10,10,10,10,10,10,10,11,null,"D26","D",26,11,11,12,12,12,12,12,12,12,12,13]
["D27","D",27,9,9,10,10,10,10,10,10,10,10,11,null,"D27","D",27,11,11,12,12,12,12,12,12,12,12,13]
["D28","D",28,10,10,10,10,10,10,11,11,11,11,11,null,"D28","D",28,12,12,12,12,12,12,13,13,13,13,13]
["D29","D",29,10,10,10,10,10,10,11,11,11,11,11,null,"D29","D",29,12,12,12,12,12,12,13,13,13,13,13]
["D30","D",30,10,10,11,11,11,11,11,11,11,11,12,null,"D30","D",30,12,12,13,13,13,13,13,13,13,13,14]
["D31","D",31,10,10,11,11,11,11,11,11,11,11,12,null,"D31","D",31,12,12,13,13,13,13,13,13,13,13,14]
["D32","D",32,11,11,11,11,11,11,11,11,12,12,12,null,"D32","D",32,13,13,13,13,13,13,13,13,14,14,14]
["D33","D",33,11,11,11,11,11,11,11,11,12,12,12,null,"D33","D",33,13,13,13,13,13,13,13,13,14,14,14]
["D34","D",34,11,11,11,11,12,12,12,12,12,12,12,null,"D34","D",34,13,13,13,13,14,14,14,14,14,14,14]
["D35","D",35,11,11,11,11,12,12,12,12,12,12,12,null,"D35","D",35,13,13,13,13,14,14,14,14,14,14,14]
["D36","D",36,12,12,12,12,12,12,12,12,13,13,13,null,"D36","D",36,14,14,14,14,14,14,14,14,15,15,15]
["D37","D",37,12,12,12,12,12,12,12,12,13,13,13,null,"D37","D",37,14,14,14,14,14,14,14,14,15,15,15]
["D38","D",38,12,12,12,12,13,13,13,13,13,13,13,null,"D38","D",38,14,14,14,14,15,15,15,15,15,15,15]
["D39","D",39,12,12,12,12,13,13,13,13,13,13,13,null,"D39","D",39,14,14,14,14,15,15,15,15,15,15,15]
["D40","D",40,12,12,13,13,13,13,13,13,13,13,14,null,"D40","D",40,14,14,15,15,15,15,15,15,15,15,16]
["D41","D",41,12,12,13,13,13,13,13,13,13,13,14,null,"D41","D",41,14,14,15,15,15,15,15,15,15,15,16]
["D42","D",42,13,13,13,13,13,13,14,14,14,14,14,null,"D42","D",42,15,15,15,15,15,15,16,16,16,16,16]
["E0","E",0,6,6,{"$f":"E139","v":6},6,6,6,6,6,6,6,6,null,"E0","E",0,8,8,{"$f":"T139","v":8},8,8,8,8,8,8,8,8]
["E1","E",1,6,6,6,6,6,6,6,6,6,6,6,null,"E1","E",1,8,8,8,8,8,8,8,8,8,8,8]
["E2","E",2,6,6,6,6,6,6,6,6,6,6,6,null,"E2","E",2,8,8,8,8,8,8,8,8,8,8,8]
["E3","E",3,6,6,6,6,6,6,6,6,6,6,6,null,"E3","E",3,8,8,8,8,8,8,8,8,8,8,8]
["E4","E",4,7,7,7,7,7,7,7,7,7,7,7,null,"E4","E",4,9,9,9,9,9,9,9,9,9,9,9]
["E5","E",5,7,7,7,7,7,7,7,7,7,7,7,null,"E5","E",5,9,9,9,9,9,9,9,9,9,9,9]
["E6","E",6,7,7,7,7,8,8,8,8,8,8,8,null,"E6","E",6,9,9,9,9,10,10,10,10,10,10,10]
["E7","E",7,7,7,7,7,8,8,8,8,8,8,8,null,"E7","E",7,9,9,9,9,10,10,10,10,10,10,10]
["E8","E",8,8,8,8,8,8,8,8,8,9,9,9,null,"E8","E",8,10,10,10,10,10,10,10,10,11,11,11]
["E9","E",9,8,8,8,8,8,8,8,8,9,9,9,null,"E9","E",9,10,10,10,10,10,10,10,10,11,11,11]
["E10","E",10,8,8,8,8,9,9,9,9,9,9,9,null,"E10","E",10,10,10,10,10,11,11,11,11,11,11,11]
["E11","E",11,8,8,8,8,9,9,9,9,9,9,9,null,"E11","E",11,10,10,10,10,11,11,11,11,11,11,11]
["E12","E",12,9,9,9,9,9,9,9,9,10,10,10,null,"E12","E",12,11,11,11,11,11,11,11,11,12,12,12]
["E13","E",13,9,9,9,9,9,9,9,9,10,10,10,null,"E13","E",13,11,11,11,11,11,11,11,11,12,12,12]
["E14","E",14,9,9,9,9,10,10,10,10,10,10,10,null,"E14","E",14,11,11,11,11,12,12,12,12,12,12,12]
["E15","E",15,9,9,9,9,10,10,10,10,10,10,10,null,"E15","E",15,11,11,11,11,12,12,12,12,12,12,12]
["E16","E",16,9,9,10,10,10,10,10,10,10,10,11,null,"E16","E",16,11,11,12,12,12,12,12,12,12,12,13]
["E17","E",17,9,9,10,10,10,10,10,10,10,10,11,null,"E17","E",17,11,11,12,12,12,12,12,12,12,12,13]
["E18","E",18,10,10,10,10,10,10,11,11,11,11,11,null,"E18","E",18,12,12,12,12,12,12,13,13,13,13,13]
["E19","E",19,10,10,10,10,10,10,11,11,11,11,11,null,"E19","E",19,12,12,12,12,12,12,13,13,13,13,13]
["E20","E",20,10,10,11,11,11,11,11,11,11,11,12,null,"E20","E",20,12,12,13,13,13,13,13,13,13,13,14]
["E21","E",21,10,10,11,11,11,11,11,11,11,11,12,null,"E21","E",21,12,12,13,13,13,13,13,13,13,13,14]
["E22","E",22,11,11,11,11,11,11,11,11,12,12,12,null,"E22","E",22,13,13,13,13,13,13,13,13,14,14,14]
["E23","E",23,11,11,11,11,11,11,11,11,12,12,12,null,"E23","E",23,13,13,13,13,13,13,13,13,14,14,14]
["E24","E",24,11,11,11,11,12,12,12,12,12,12,12,null,"E24","E",24,13,13,13,13,14,14,14,14,14,14,14]
["E25","E",25,11,11,11,11,12,12,12,12,12,12,12,null,"E25","E",25,13,13,13,13,14,14,14,14,14,14,14]
["E26","E",26,12,12,12,12,12,12,12,12,13,13,13,null,"E26","E",26,14,14,14,14,14,14,14,14,15,15,15]
["E27","E",27,12,12,12,12,12,12,12,12,13,13,13,null,"E27","E",27,14,14,14,14,14,14,14,14,15,15,15]
["E28","E",28,12,12,12,12,12,12,13,13,13,13,13,null,"E28","E",28,14,14,14,14,14,14,15,15,15,15,15]
["E29","E",29,12,12,12,12,12,12,13,13,13,13,13,null,"E29","E",29,14,14,14,14,14,14,15,15,15,15,15]
["E30","E",30,12,12,13,13,13,13,13,13,13,13,14,null,"E30","E",30,14,14,15,15,15,15,15,15,15,15,16]
["E31","E",31,12,12,13,13,13,13,13,13,13,13,14,null,"E31","E",31,14,14,15,15,15,15,15,15,15,15,16]
["E32","E",32,13,13,13,13,13,13,14,14,14,14,14,null,"E32","E",32,15,15,15,15,15,15,16,16,16,16,16]
["E33","E",33,13,13,13,13,13,13,14,14,14,14,14,null,"E33","E",33,15,15,15,15,15,15,16,16,16,16,16]
["E34","E",34,13,13,13,13,14,14,14,14,14,14,14,null,"E34","E",34,15,15,15,15,16,16,16,16,16,16,16]