{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Summary","Valuation Method","Participant Awards","Participant Values","Company Perspective","Variables","Calcs","Rate Table"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":10,"defined_names":177,"comments":2,"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":"Summary","index":0,"n_rows":81,"n_cols":35,"rows_kept":81,"cut":false,"hidden":false,"merged":[[7,1,8,55],[5,0,5,56],[10,1,10,10],[11,3,11,54],[75,3,75,54],[74,1,74,10],[15,1,15,10],[16,3,16,54],[12,3,12,54],[13,3,13,54],[70,3,72,54],[22,1,22,12],[38,5,39,54],[47,1,47,10],[64,5,64,54],[69,1,69,10]]}
[]
[]
[]
[]
[]
["The Phantom Stock Plan Modeler - Executive Benefit Solutions"]
[]
[null,"Phantom stock plans are a form of a Deferred Compensation and does not represent equity ownership in the Company. Phantom stock plans may be subject to either ERISA and/or IRC Section 409A depending upon the structure of the plan. Companies should seek guidance from qualified advisors if they wish to avoid these regulations"]
[]
[]
[null,"PURPOSE OF THE MODELER"]
[null,null,null,"The purpose of the Modeler is to provide a better understanding of how phantom stock plans work, and to provide an opportunity for you to study the potential value and cost of various plan designs."]
[null,null,null,"Phantom stock plans are extremely flexible and can be customized to meet the specific objectives of the plan sponsor, and the needs of the key employees.  This version of the Modeler is designed to illustrate some of the basic issues associated with plan design, and to stimulate your thinking as to how such a program could assist in meeting the financial and strategic goals for the Company. "]
[null,null,null,"There are only a few inputs required to get started modeling, which are outlined below.  But first, we would like to pose some basic questions to be addressed in the plan design process."]
[]
[null,"    OBJECTIVES"]
[null,null,null,"The sponsor’s objectives for the implementation of a phantom stock plan vary from company to company based on the specific facts and circumstances. However, some common objectives include the creation of a long-term incentive compensation plan that:"]
[null,null,null,null,"■  ","Has significant retention characteristics "]
[null,null,null,null,"■  ","Incents key employees to act like owners"]
[null,null,null,null,"■  ","Allows each to share in the future growth and appreciation of the company "]
[null,null,null,null,"■  ","Delivers a clear message that he/she is important to the future success of the business"]
[]
[null,"PLAN DESIGN CONSIDERATIONS"]
[null,null,null,"Fundamental Principles"]
[null,null,null,"The plan design is most likely to be successful if it: "]
[null,null,null,null,"■  ","Provides a direct link between performance and pay"]
[null,null,null,null,"■  ","Bases the valuation of the phantom shares or units on financial performance criteria over which the key employee has control"]
[null,null,null,null,"■  ","Takes into consideration strategic as well as financial goals"]
[null,null,null,null,"■  ","Is easy for the participants to understand and to assess the potential value"]
[null,null,null,null,"■  ","Coordinates the phantom stock plan with other components of the total rewards package, such as the short-term incentive plan and/or the deferred compensation plan"]
[null,null,null,null,"■  ","Is sufficiently flexible to deal with changing circumstances in the future"]
[null,null,null,"Nature of the Plan"]
[null,null,null,null,"■  ","Full value versus appreciation:  Is the design intended to reward participants for valuable past service, or is it an incentive for future performance (or both)?"]
[null,null,null,null,"■  ","The Modeler can illustrate the potential value of either full value or appreciation phantom shares or units, or a combination of the two."]
[null,null,null,"Valuation of the Business / Phantom Shares - Units"]
[null,null,null,null,"■  ","What is the basis for the valuation of the business – appraisal value, or formula value (e.g., a multiple of EBITDA)?"]
[null,null,null,null,"■  ","How much of the current value of the business, or the future appreciation, should be allocated to the plan (e.g., 10 - 15%)?"]
[null,null,null,null,"■  ","Are plan awards open-ended, or limited?"]
[null,null,null,null,"■  ","The Modeler can help determine the level of grant to ensure that the awards are significant, but not an unreasonable financial burden (ideally, funded out of incremental profitability)."]
[]
[null,null,null,"Mechanics"]
[null,null,null,null,"■  ","When are the phantom shares/units granted - one-time/periodically/annually?"]
[null,null,null,null,"■  ","What is the period over which the performance criteria are measured, e.g., 3 – 5 years?"]
[null,null,null,null,"■  ","How is the amount of each grant determined?"]
[null,null,null,null,"■  ","When and how are the granted shares/units earned, vested and paid?"]
[null,null,null,null,"■  ","What is the tax impact to the participant?"]
[]
[null,"    GETTING STARTED"]
[null,null,null," Screen 1:  Valuation Method"]
[null,null,null,null,"■  ","Enter data in the input boxes on the left of the screen regarding:"]
[null,null,null,null,null,null,"-","The projected business value – based on appraisal value or formula."]
[null,null,null,null,null,null,"-","If a formula approach, indicate the basis of the formula."]
[null,null,null,null,null,null,"-","And the vesting period."]
[null,null,null,null,"■  ","If you hold the cursor over each input box, a dialog box appears with instructions."]
[null,null,null,null,"■  ","Also, if you click on the red triangle in the input box, a drop down menu will appear."]
[null,null,null,null,"■  ","The projected value of the business, the cumulative appreciation, the amount of the total phantom stock pool and the share/unit value are displayed on the right"]
[null,null,null,"Screen 2:  Participant Awards"]
[null,null,null,null,"■  ","Enter the participants on the left."]
[null,null,null,null,"■  ","Enter the percentage of the phantom stock pool to be allocated to each on the right."]
[null,null,null,"Screen 3:  Participant Values"]
[null,null,null,null,"■  ","Enter the participant for whom you would like to view the projected benefits in the yellow box in the upper left of the screen."]
[null,null,null,null,"■  ","The columns to the right illustrate the projected award values for the period specified."]
[null,null,null,null,"■  ","A total compensation summary is presented at the bottom of the screen to illustrate the relative value of the phantom stock plan."]
[null,null,null,"Screen 4:  Company Perspective"]
[null,null,null,null,"■  ","The data in this screen is automatically generated based on previous inputs, and illustrates the projected total Company value, the appreciation, and the aggregate value of the phantom stock shares/units earned and vested in relation to the total compensation paid to the participants."]
[null,null,null,null,"■  ","You can adjust the inputs on the first screen, and project a range of possible results."]
[null,null,null,"Screen 5:  Rate Table"]
[null,null,null,null,"■  ","This is a detailed input page for rate tables for projections of the business value and the vesting period."]
[]
[null,"    IN SUMMARY"]
[null,null,null,"Once again, this generic version of the Phantom Stock Modeler is designed to illustrate some basic plan design options.  The actual plan design would be customized to the facts and circumstances of each situation to reflect the specific goals and objectives of the sponsor, and the needs of the participants. And the Modeler would be customized to provide detailed financial information from the Company’s perspective, as well as an effective participant communication tool."]
[]
[]
[]
[null,"HELP IS AVAILABLE"]
[null,null,null,"For assistance using the Modeler, please contact EBS:"]
[null,null,null,null,null,null,"Chris Rich",null,null,null,null,null,null,null,null,null,null,null,null,null,"Chris Wyrtzen",null,null,null,null,null,null,null,null,null,null,null,null,null,"Karl Reinhold"]
[null,null,null,null,null,null,"Managing Director",null,null,null,null,null,null,null,null,null,null,null,null,null,"Managing Director",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vice President, Design"]
[null,null,null,null,null,null,"EBS - Boston",null,null,null,null,null,null,null,null,null,null,null,null,null,"EBS - Boston",null,null,null,null,null,null,null,null,null,null,null,null,null,"EBS - Boston"]
[null,null,null,null,null,null,"Phone:  617-904-9444 x 112",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:  617-904-9444 x 111",null,null,null,null,null,null,null,null,null,null,null,null,null,"Phone:  617-904-9444 x 113"]
[null,null,null,null,null,null,"Email:  crich@ebs-boston.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:  cwyrtzen@ebs-boston.com",null,null,null,null,null,null,null,null,null,null,null,null,null,"Email:  kreinhold@ebs-boston.com"]

{"sheet":"Valuation Method","index":1,"n_rows":24,"n_cols":23,"rows_kept":24,"cut":false,"hidden":false,"merged":[[20,7,20,8],[15,2,15,6],[17,7,17,8],[15,7,15,8],[5,7,5,8],[16,7,16,8],[21,7,21,8],[22,7,22,8],[4,2,4,8],[9,2,9,6],[9,7,9,8],[10,7,10,8],[21,2,21,6],[12,2,12,8],[6,7,6,8],[8,7,8,8],[7,7,7,8],[13,7,13,8],[14,7,14,8],[19,2,19,8]]}
[]
[]
[]
[]
[null,null,"PROJECTED BUSINESS VALUE - Specied or Formula Based"]
[null,null,"Base line year for measurement period to begin",null,null,null,null,2015]
[null,null,"How many future years do you want to model (3-10)?",null,null,null,null,10]
[null,null,"How many total shares are there?",null,null,null,null,100000]
[null,null,"What % of future value are you willing to give to Execs?",null,null,null,null,0.2]
[null,null,"Specify Business Value or use a Formula based Approach",null,null,null,null,"Formula Based"]
[null,null,{"$f":"IF(InputValueMethod=\"Specify Values\",\"Click on the Hyperlink to go Table to Input Values==>\",\"Use Next Section to Specify Valuation Formula\")","v":"Use Next Section to Specify Valuation Formula"},null,null,null,null,"Go To Input Table"]
[]
[null,null,"If Formula Based Approach Selected Above, use this Secion (otherwise ignored)"]
[null,null,"Select Measurement Criteria",null,null,null,null,"EBITDA"]
[null,null,{"$f":"\"Input Current \"&ValueCriteriaSelected","v":"Input Current EBITDA"},null,null,null,null,500000]
[null,null,{"$f":"\"Project \"&ValueCriteriaSelected&\" using Single Rate or a Rate Table?\"","v":"Project EBITDA using Single Rate or a Rate Table?"},null,null,null,null,"Rate Table"]
[null,null,{"$f":"IF(GrowRateSelected=\"Single Rate\",\"Enter the Single Rate here ==>\",\"Click on the Hyperlink to go Rate Table\")","v":"Click on the Hyperlink to go Rate Table"},null,null,null,null,"Go To Rate Table"]
[null,null,{"$f":"\"What Multiple of \"&ValueCriteriaSelected&\" Would a Buyer Pay?\"","v":"What Multiple of EBITDA Would a Buyer Pay?"},null,null,null,null,5]
[]
[null,null,"Specify the Vesting Time Period"]
[null,null,"Select Number of Years to Vest (3-10)?",null,null,null,null,5]
[null,null,"Default is Cliff Vesting or Choose Vesting Schedule",null,null,null,null,"Vesting Schedule"]
[null,null,"Click on the Hyperlink to Enter the Vesting Schedule",null,null,null,null,"Go To Vesting Table",null,null,null,null,null,{"$f":"M23+1","v":1},{"$f":"N23+1","v":2},{"$f":"O23+1","v":3},{"$f":"P23+1","v":4},{"$f":"Q23+1","v":5},6,7,8,{"$f":"U23+1","v":9},{"$f":"V23+1","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Calcs!I9","v":25},{"$f":"Calcs!I10","v":33.25},{"$f":"Calcs!I11","v":44.222499999999997},{"$f":"Calcs!I12","v":58.815925},{"$f":"Calcs!I13","v":73.519906250000005},{"$f":"Calcs!I14","v":91.899882812499996},{"$f":"Calcs!I15","v":114.87485351562501},{"$f":"Calcs!I16","v":132.10608154296875},{"$f":"Calcs!I17","v":151.92199377441403},{"$f":"Calcs!I18","v":174.71029284057613},{"$f":"Calcs!I19","v":200.91683676666253}]

{"sheet":"Participant Awards","index":2,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,3,21,7],[7,2,7,7],[7,9,7,18]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Enter the List of Executives who will Participate in the Plan",null,null,null,null,null,null,"Enter the % of the Pool to be Awarded to Each Participant"]
[null,null,null,null,null,"1st Year",null,"% Target",null,1,{"$f":"J9+1","v":2},{"$f":"K9+1","v":3},4,5,6,7,8,9,10]
[null,null,"#"," Name"," Title","Eligible","Salary","Bonus",null,{"$f":"'Valuation Method'!H6+1","v":2016},{"$f":"J10+1","v":2017},{"$f":"K10+1","v":2018},{"$f":"L10+1","v":2019},2020,{"$f":"N10+1","v":2021},2022,2023,2024,2025]
[null,null,1,"John Smith","COO",1,300000,0.3,null,0.3,null,0.1]
[null,null,{"$f":"C11+1","v":2},"Jim Douglas","CFO",1,275000,0.3,null,0.2]
[null,null,3,"Jane Doe","SVP Marketing",1,250000,0.25,null,0.15]
[null,null,4,"Nancy Jenkins","SVP Manufacturing",3,250000,0.25,null,null,null,0.15]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11,"All Participants"]
[null,null,null,"Cumulative Awards==>",null,null,null,null,null,{"$f":"SUM(J11:J21)","v":0.65},{"$f":"SUM(K11:K21)+J22","v":0.65},{"$f":"SUM(L11:L21)+K22","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9]

{"sheet":"Participant Values","index":3,"n_rows":274,"n_cols":46,"rows_kept":274,"cut":false,"hidden":false,"merged":[[7,3,7,4]]}
[]
[]
[]
[]
[null,null,null,"Go to the Yellow Box and select which Executive's results to view"]
[]
[]
[null,null,{"$f":"Variables!$X$30","v":1},"John Smith",null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I9)+1,MONTH(I9),DAY(I9))","v":"2017-12-31"},{"$f":"DATE(YEAR(J9)+1,MONTH(J9),DAY(J9))","v":"2018-12-31"},{"$f":"DATE(YEAR(K9)+1,MONTH(K9),DAY(K9))","v":"2019-12-31"},"2020-12-31","2021-12-31","2022-12-31","2023-12-31","2024-12-31","2025-12-31"]
[null,null,null,null,null,null,null,null,1,{"$f":"I10+1","v":2},{"$f":"J10+1","v":3},4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H12","v":33.25},{"$f":"H13","v":44.222499999999997},{"$f":"H14","v":58.815925},{"$f":"H15","v":73.519906250000005},{"$f":"H16","v":91.899882812499996},{"$f":"H17","v":114.87485351562501},{"$f":"H18","v":132.10608154296875},{"$f":"H19","v":151.92199377441403},{"$f":"H20","v":174.71029284057613},{"$f":"H21","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH($E12,TopRow,0))","v":0.3},{"$f":"PoolPercent*SharesNumber*F12","v":6000},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G12*(I11-$H11)","v":49500},115334.99999999999,202895.55,291119.43750000006,401399.296875,539249.12109375,642636.4892578125,761531.96264648426,898261.75704345678,1055501.0205999753,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I12*Z12","v":0},{"$f":"J12*AA12","v":0},0,116447.77500000002,401399.296875,539249.12109375,642636.4892578125,761531.96264648426,898261.75704345678,1055501.0205999753]
[null,null,null,{"$f":"D12+1","v":2},{"$f":"E12+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E13,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G13*(J11-$I11)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I13*Z13","v":0},{"$f":"J13*AA13","v":0},{"$f":"K13*AB13","v":0},{"$f":"L13*AC13","v":0},{"$f":"M13*AD13","v":0},{"$f":"N13*AE13","v":0},{"$f":"O13*AF13","v":0},{"$f":"P13*AG13","v":0},{"$f":"Q13*AH13","v":0},{"$f":"R13*AI13","v":0}]
[null,null,null,{"$f":"D13+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E14,TopRow,0))","v":0.1},2000,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G14*(K11-$J11)","v":29186.850000000006},58594.812500000015,95354.765625,141304.70703125003,175767.1630859375,215398.98754882807,260975.58568115227,313388.67353332508,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,56521.882812500015,175767.1630859375,215398.98754882807,260975.58568115227,313388.67353332508]
[null,null,null,4,2019,{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E15,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G15*(L11-$K11)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,5,{"$f":"E15+1","v":2020},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E16,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F16","v":0},{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G16*(M11-$L11)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,6,{"$f":"E16+1","v":2021},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E17,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G17*(N11-$M11)","v":0},{"$f":"$G17*(O11-$M11)","v":0},{"$f":"$G17*(P11-$M11)","v":0},{"$f":"$G17*(Q11-$M11)","v":0},{"$f":"$G17*(R11-$M11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,7,{"$f":"E17+1","v":2022},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E18,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G18*(O11-$N11)","v":0},{"$f":"$G18*(P11-$N11)","v":0},{"$f":"$G18*(Q11-$N11)","v":0},{"$f":"$G18*(R11-$N11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,8,{"$f":"E18+1","v":2023},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E19,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G19*(P11-$O11)","v":0},{"$f":"$G19*(Q11-$O11)","v":0},{"$f":"$G19*(R11-$O11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,9,{"$f":"E19+1","v":2024},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E20,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G20*(Q11-$P11)","v":0},{"$f":"$G20*(R11-$P11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,10,{"$f":"E20+1","v":2025},{"$f":"INDEX(ParticipantData,MATCH(C8,ParticipantNums,0),MATCH(E21,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G21*(R11-$Q11)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F12:F21)","v":0.4},{"$f":"SUM(G12:G21)","v":8000},"Earned",{"$f":"SUM(I12:I21)","v":49500},{"$f":"SUM(J12:J21)","v":115334.99999999999},232082.4,349714.25000000006,496754.0625,680553.828125,818403.65234375,976930.95019531227,1159237.342724609,1368889.6941333003]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK12:AK21)","v":0},{"$f":"SUM(AL12:AL21)","v":0},0,116447.77500000002,401399.296875,595771.00390625,818403.65234375,976930.95019531227,1159237.342724609,1368889.6941333003]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":300000},{"$f":"I25*(1+CompGrowthRate)","v":309000},318270,327818.10000000003,337652.64300000004,347782.22229000006,358215.68895870005,368962.15962746105,380031.02441628487,391431.95514877344]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":90000},{"$f":"J25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":92700},{"$f":"K25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":95481},{"$f":"L25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":98345.430000000008},{"$f":"M25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":101295.79290000001},{"$f":"N25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":104334.66668700002},{"$f":"O25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":107464.70668761001},{"$f":"P25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":110688.64788823831},{"$f":"Q25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":114009.30732488546},{"$f":"R25*VLOOKUP(C8,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":117429.58654463202}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I25+I26","v":390000},{"$f":"J25+J26","v":401700},413751,426163.53,438948.43590000004,452116.88897700008,465680.39564631006,479650.80751569936,494040.33174117032,508861.54169340548]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I25=0,0,I22/I25)","v":0.16500000000000001},{"$f":"IF(J25=0,0,J22/J25)","v":0.373252427184466},0.72919973607314548,1.066793596814819,1.4711985017691687,1.9568390346229847,2.284667248167644,2.6477808759080168,3.0503755436945164,3.4971332210550359]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,{"$f":"\"  \"&IF(VLOOKUP(C38,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C38,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  John Smith"},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I39)+1,MONTH(I39),DAY(I39))","v":"2017-12-31"},{"$f":"DATE(YEAR(J39)+1,MONTH(J39),DAY(J39))","v":"2018-12-31"},{"$f":"DATE(YEAR(K39)+1,MONTH(K39),DAY(K39))","v":"2019-12-31"},{"$f":"DATE(YEAR(L39)+1,MONTH(L39),DAY(L39))","v":"2020-12-31"},{"$f":"DATE(YEAR(M39)+1,MONTH(M39),DAY(M39))","v":"2021-12-31"},{"$f":"DATE(YEAR(N39)+1,MONTH(N39),DAY(N39))","v":"2022-12-31"},{"$f":"DATE(YEAR(O39)+1,MONTH(O39),DAY(O39))","v":"2023-12-31"},{"$f":"DATE(YEAR(P39)+1,MONTH(P39),DAY(P39))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q39)+1,MONTH(Q39),DAY(Q39))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H41","v":33.25},{"$f":"H42","v":44.222499999999997},{"$f":"H43","v":58.815925},{"$f":"H44","v":73.519906250000005},{"$f":"H45","v":91.899882812499996},{"$f":"H46","v":114.87485351562501},{"$f":"H47","v":132.10608154296875},{"$f":"H48","v":151.92199377441403},{"$f":"H49","v":174.71029284057613},{"$f":"H50","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH($E41,TopRow,0))","v":0.3},{"$f":"PoolPercent*SharesNumber*F41","v":6000},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G41*(I40-$H40)","v":49500},115334.99999999999,202895.55,291119.43750000006,401399.296875,539249.12109375,642636.4892578125,761531.96264648426,898261.75704345678,1055501.0205999753,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I41*Z41","v":0},{"$f":"J41*AA41","v":0},{"$f":"K41*AB41","v":0},{"$f":"L41*AC41","v":116447.77500000002},{"$f":"M41*AD41","v":401399.296875},{"$f":"N41*AE41","v":539249.12109375},{"$f":"O41*AF41","v":642636.4892578125},{"$f":"P41*AG41","v":761531.96264648426},{"$f":"Q41*AH41","v":898261.75704345678},{"$f":"R41*AI41","v":1055501.0205999753}]
[null,null,null,{"$f":"D41+1","v":2},{"$f":"E41+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E42,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G42*(J40-$I40)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I42*Z42","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D42+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E43,TopRow,0))","v":0.1},2000,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G43*(K40-$J40)","v":29186.850000000006},58594.812500000015,95354.765625,141304.70703125003,175767.1630859375,215398.98754882807,260975.58568115227,313388.67353332508,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,56521.882812500015,175767.1630859375,215398.98754882807,260975.58568115227,313388.67353332508]
[null,null,null,{"$f":"D43+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E44,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G44*(L40-$K40)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D44+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E45,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G45*(M40-$L40)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D45+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E46,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G46*(N40-$M40)","v":0},{"$f":"$G46*(O40-$M40)","v":0},{"$f":"$G46*(P40-$M40)","v":0},{"$f":"$G46*(Q40-$M40)","v":0},{"$f":"$G46*(R40-$M40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D46+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E47,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G47*(O40-$N40)","v":0},{"$f":"$G47*(P40-$N40)","v":0},{"$f":"$G47*(Q40-$N40)","v":0},{"$f":"$G47*(R40-$N40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D47+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E48,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G48*(P40-$O40)","v":0},{"$f":"$G48*(Q40-$O40)","v":0},{"$f":"$G48*(R40-$O40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D48+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E49,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G49*(Q40-$P40)","v":0},{"$f":"$G49*(R40-$P40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D49+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C38,ParticipantNums,0),MATCH(E50,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G50*(R40-$Q40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F41:F50)","v":0.4},{"$f":"SUM(G41:G50)","v":8000},"Earned",{"$f":"SUM(I41:I50)","v":49500},{"$f":"SUM(J41:J50)","v":115334.99999999999},232082.4,349714.25000000006,496754.0625,680553.828125,818403.65234375,976930.95019531227,1159237.342724609,1368889.6941333003]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK41:AK50)","v":0},{"$f":"SUM(AL41:AL50)","v":0},{"$f":"SUM(AM41:AM50)","v":0},{"$f":"SUM(AN41:AN50)","v":116447.77500000002},{"$f":"SUM(AO41:AO50)","v":401399.296875},{"$f":"SUM(AP41:AP50)","v":595771.00390625},{"$f":"SUM(AQ41:AQ50)","v":818403.65234375},{"$f":"SUM(AR41:AR50)","v":976930.95019531227},{"$f":"SUM(AS41:AS50)","v":1159237.342724609},{"$f":"SUM(AT41:AT50)","v":1368889.6941333003}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":300000},{"$f":"I54*(1+CompGrowthRate)","v":309000},{"$f":"J54*(1+CompGrowthRate)","v":318270},{"$f":"K54*(1+CompGrowthRate)","v":327818.10000000003},{"$f":"L54*(1+CompGrowthRate)","v":337652.64300000004},{"$f":"M54*(1+CompGrowthRate)","v":347782.22229000006},{"$f":"N54*(1+CompGrowthRate)","v":358215.68895870005},{"$f":"O54*(1+CompGrowthRate)","v":368962.15962746105},{"$f":"P54*(1+CompGrowthRate)","v":380031.02441628487},{"$f":"Q54*(1+CompGrowthRate)","v":391431.95514877344}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":90000},{"$f":"J54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":92700},{"$f":"K54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":95481},{"$f":"L54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":98345.430000000008},{"$f":"M54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":101295.79290000001},{"$f":"N54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":104334.66668700002},{"$f":"O54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":107464.70668761001},{"$f":"P54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":110688.64788823831},{"$f":"Q54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":114009.30732488546},{"$f":"R54*VLOOKUP(C38,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":117429.58654463202}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I54+I55","v":390000},{"$f":"J54+J55","v":401700},413751,426163.53,438948.43590000004,452116.88897700008,465680.39564631006,479650.80751569936,494040.33174117032,508861.54169340548]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I54=0,0,I51/I54)","v":0.16500000000000001},{"$f":"IF(J54=0,0,J51/J54)","v":0.373252427184466},0.72919973607314548,1.066793596814819,1.4711985017691687,1.9568390346229847,2.284667248167644,2.6477808759080168,3.0503755436945164,3.4971332210550359]
[]
[]
[]
[null,null,2,{"$f":"\"  \"&IF(VLOOKUP(C62,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C62,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  Jim Douglas"},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I63)+1,MONTH(I63),DAY(I63))","v":"2017-12-31"},{"$f":"DATE(YEAR(J63)+1,MONTH(J63),DAY(J63))","v":"2018-12-31"},{"$f":"DATE(YEAR(K63)+1,MONTH(K63),DAY(K63))","v":"2019-12-31"},{"$f":"DATE(YEAR(L63)+1,MONTH(L63),DAY(L63))","v":"2020-12-31"},{"$f":"DATE(YEAR(M63)+1,MONTH(M63),DAY(M63))","v":"2021-12-31"},{"$f":"DATE(YEAR(N63)+1,MONTH(N63),DAY(N63))","v":"2022-12-31"},{"$f":"DATE(YEAR(O63)+1,MONTH(O63),DAY(O63))","v":"2023-12-31"},{"$f":"DATE(YEAR(P63)+1,MONTH(P63),DAY(P63))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q63)+1,MONTH(Q63),DAY(Q63))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H65","v":33.25},{"$f":"H66","v":44.222499999999997},{"$f":"H67","v":58.815925},{"$f":"H68","v":73.519906250000005},{"$f":"H69","v":91.899882812499996},{"$f":"H70","v":114.87485351562501},{"$f":"H71","v":132.10608154296875},{"$f":"H72","v":151.92199377441403},{"$f":"H73","v":174.71029284057613},{"$f":"H74","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH($E65,TopRow,0))","v":0.2},{"$f":"PoolPercent*SharesNumber*F65","v":4000},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G65*(I64-$H64)","v":33000},76889.999999999985,135263.70000000001,194079.62500000003,267599.53125,359499.4140625,428424.326171875,507687.97509765613,598841.17136230448,703667.34706665017,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I65*Z65","v":0},{"$f":"J65*AA65","v":0},{"$f":"K65*AB65","v":0},{"$f":"L65*AC65","v":77631.85000000002},{"$f":"M65*AD65","v":267599.53125},{"$f":"N65*AE65","v":359499.4140625},{"$f":"O65*AF65","v":428424.326171875},{"$f":"P65*AG65","v":507687.97509765613},{"$f":"Q65*AH65","v":598841.17136230448},{"$f":"R65*AI65","v":703667.34706665017}]
[null,null,null,{"$f":"D65+1","v":2},{"$f":"E65+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E66,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G66*(J64-$I64)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I66*Z66","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D66+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E67,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G67*(K64-$J64)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D67+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E68,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G68*(L64-$K64)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D68+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E69,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G69*(M64-$L64)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D69+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E70,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G70*(N64-$M64)","v":0},{"$f":"$G70*(O64-$M64)","v":0},{"$f":"$G70*(P64-$M64)","v":0},{"$f":"$G70*(Q64-$M64)","v":0},{"$f":"$G70*(R64-$M64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D70+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E71,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G71*(O64-$N64)","v":0},{"$f":"$G71*(P64-$N64)","v":0},{"$f":"$G71*(Q64-$N64)","v":0},{"$f":"$G71*(R64-$N64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D71+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E72,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G72*(P64-$O64)","v":0},{"$f":"$G72*(Q64-$O64)","v":0},{"$f":"$G72*(R64-$O64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D72+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E73,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G73*(Q64-$P64)","v":0},{"$f":"$G73*(R64-$P64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D73+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C62,ParticipantNums,0),MATCH(E74,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G74*(R64-$Q64)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F65:F74)","v":0.2},{"$f":"SUM(G65:G74)","v":4000},"Earned",{"$f":"SUM(I65:I74)","v":33000},{"$f":"SUM(J65:J74)","v":76889.999999999985},135263.70000000001,194079.62500000003,267599.53125,359499.4140625,428424.326171875,507687.97509765613,598841.17136230448,703667.34706665017]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK65:AK74)","v":0},{"$f":"SUM(AL65:AL74)","v":0},{"$f":"SUM(AM65:AM74)","v":0},{"$f":"SUM(AN65:AN74)","v":77631.85000000002},{"$f":"SUM(AO65:AO74)","v":267599.53125},{"$f":"SUM(AP65:AP74)","v":359499.4140625},{"$f":"SUM(AQ65:AQ74)","v":428424.326171875},{"$f":"SUM(AR65:AR74)","v":507687.97509765613},{"$f":"SUM(AS65:AS74)","v":598841.17136230448},{"$f":"SUM(AT65:AT74)","v":703667.34706665017}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":275000},{"$f":"I78*(1+CompGrowthRate)","v":283250},{"$f":"J78*(1+CompGrowthRate)","v":291747.5},{"$f":"K78*(1+CompGrowthRate)","v":300499.92499999999},{"$f":"L78*(1+CompGrowthRate)","v":309514.92274999997},{"$f":"M78*(1+CompGrowthRate)","v":318800.37043249997},{"$f":"N78*(1+CompGrowthRate)","v":328364.38154547499},{"$f":"O78*(1+CompGrowthRate)","v":338215.31299183925},{"$f":"P78*(1+CompGrowthRate)","v":348361.77238159446},{"$f":"Q78*(1+CompGrowthRate)","v":358812.62555304228}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":82500},{"$f":"J78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":84975},{"$f":"K78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":87524.25},{"$f":"L78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":90149.977499999994},{"$f":"M78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":92854.476824999991},{"$f":"N78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":95640.111129749988},{"$f":"O78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":98509.314463642499},{"$f":"P78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":101464.59389755178},{"$f":"Q78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":104508.53171447833},{"$f":"R78*VLOOKUP(C62,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":107643.78766591268}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I78+I79","v":357500},{"$f":"J78+J79","v":368225},379271.75,390649.90249999997,402369.39957499993,414440.48156224994,426873.69600911747,439679.90688939102,452870.3040960728,466456.41321895493]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I78=0,0,I75/I78)","v":0.12},{"$f":"IF(J78=0,0,J75/J78)","v":0.27145631067961162},0.46363276463380154,0.6458558184332327,0.86457715470521701,1.127663100186445,1.3047222849063571,1.5010792107745461,1.7190209111300985,1.9610997410753848]
[]
[]
[]
[null,null,3,{"$f":"\"  \"&IF(VLOOKUP(C86,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C86,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  Jane Doe"},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I87)+1,MONTH(I87),DAY(I87))","v":"2017-12-31"},{"$f":"DATE(YEAR(J87)+1,MONTH(J87),DAY(J87))","v":"2018-12-31"},{"$f":"DATE(YEAR(K87)+1,MONTH(K87),DAY(K87))","v":"2019-12-31"},{"$f":"DATE(YEAR(L87)+1,MONTH(L87),DAY(L87))","v":"2020-12-31"},{"$f":"DATE(YEAR(M87)+1,MONTH(M87),DAY(M87))","v":"2021-12-31"},{"$f":"DATE(YEAR(N87)+1,MONTH(N87),DAY(N87))","v":"2022-12-31"},{"$f":"DATE(YEAR(O87)+1,MONTH(O87),DAY(O87))","v":"2023-12-31"},{"$f":"DATE(YEAR(P87)+1,MONTH(P87),DAY(P87))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q87)+1,MONTH(Q87),DAY(Q87))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H89","v":33.25},{"$f":"H90","v":44.222499999999997},{"$f":"H91","v":58.815925},{"$f":"H92","v":73.519906250000005},{"$f":"H93","v":91.899882812499996},{"$f":"H94","v":114.87485351562501},{"$f":"H95","v":132.10608154296875},{"$f":"H96","v":151.92199377441403},{"$f":"H97","v":174.71029284057613},{"$f":"H98","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH($E89,TopRow,0))","v":0.15},{"$f":"PoolPercent*SharesNumber*F89","v":3000},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G89*(I88-$H88)","v":24750},57667.499999999993,101447.77499999999,145559.71875000003,200699.6484375,269624.560546875,321318.24462890625,380765.98132324213,449130.87852172839,527750.51029998763,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I89*Z89","v":0},{"$f":"J89*AA89","v":0},{"$f":"K89*AB89","v":0},{"$f":"L89*AC89","v":58223.887500000012},{"$f":"M89*AD89","v":200699.6484375},{"$f":"N89*AE89","v":269624.560546875},{"$f":"O89*AF89","v":321318.24462890625},{"$f":"P89*AG89","v":380765.98132324213},{"$f":"Q89*AH89","v":449130.87852172839},{"$f":"R89*AI89","v":527750.51029998763}]
[null,null,null,{"$f":"D89+1","v":2},{"$f":"E89+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E90,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G90*(J88-$I88)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I90*Z90","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D90+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E91,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G91*(K88-$J88)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D91+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E92,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G92*(L88-$K88)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D92+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E93,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G93*(M88-$L88)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D93+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E94,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G94*(N88-$M88)","v":0},{"$f":"$G94*(O88-$M88)","v":0},{"$f":"$G94*(P88-$M88)","v":0},{"$f":"$G94*(Q88-$M88)","v":0},{"$f":"$G94*(R88-$M88)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D94+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E95,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G95*(O88-$N88)","v":0},{"$f":"$G95*(P88-$N88)","v":0},{"$f":"$G95*(Q88-$N88)","v":0},{"$f":"$G95*(R88-$N88)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D95+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E96,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G96*(P88-$O88)","v":0},{"$f":"$G96*(Q88-$O88)","v":0},{"$f":"$G96*(R88-$O88)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D96+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E97,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G97*(Q88-$P88)","v":0},{"$f":"$G97*(R88-$P88)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D97+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C86,ParticipantNums,0),MATCH(E98,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G98*(R88-$Q88)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F89:F98)","v":0.15},{"$f":"SUM(G89:G98)","v":3000},"Earned",{"$f":"SUM(I89:I98)","v":24750},{"$f":"SUM(J89:J98)","v":57667.499999999993},101447.77499999999,145559.71875000003,200699.6484375,269624.560546875,321318.24462890625,380765.98132324213,449130.87852172839,527750.51029998763]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK89:AK98)","v":0},{"$f":"SUM(AL89:AL98)","v":0},{"$f":"SUM(AM89:AM98)","v":0},{"$f":"SUM(AN89:AN98)","v":58223.887500000012},{"$f":"SUM(AO89:AO98)","v":200699.6484375},{"$f":"SUM(AP89:AP98)","v":269624.560546875},{"$f":"SUM(AQ89:AQ98)","v":321318.24462890625},{"$f":"SUM(AR89:AR98)","v":380765.98132324213},{"$f":"SUM(AS89:AS98)","v":449130.87852172839},{"$f":"SUM(AT89:AT98)","v":527750.51029998763}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":250000},{"$f":"I102*(1+CompGrowthRate)","v":257500},{"$f":"J102*(1+CompGrowthRate)","v":265225},{"$f":"K102*(1+CompGrowthRate)","v":273181.75},{"$f":"L102*(1+CompGrowthRate)","v":281377.20250000001},{"$f":"M102*(1+CompGrowthRate)","v":289818.51857499999},{"$f":"N102*(1+CompGrowthRate)","v":298513.07413224998},{"$f":"O102*(1+CompGrowthRate)","v":307468.46635621751},{"$f":"P102*(1+CompGrowthRate)","v":316692.52034690406},{"$f":"Q102*(1+CompGrowthRate)","v":326193.29595731117}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":62500},{"$f":"J102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":64375},{"$f":"K102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":66306.25},{"$f":"L102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":68295.4375},{"$f":"M102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":70344.300625000003},{"$f":"N102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":72454.629643749999},{"$f":"O102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":74628.268533062495},{"$f":"P102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":76867.116589054378},{"$f":"Q102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":79173.130086726014},{"$f":"R102*VLOOKUP(C86,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":81548.323989327793}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I102+I103","v":312500},{"$f":"J102+J103","v":321875},331531.25,341477.1875,351721.50312500005,362273.14821875002,373141.34266531246,384335.58294527186,395865.6504336301,407741.61994663894]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I102=0,0,I99/I102)","v":9.9000000000000005E-2},{"$f":"IF(J102=0,0,J99/J102)","v":0.22395145631067959},0.38249703082288622,0.53283105020741695,0.71327615263180388,0.93032205765381704,1.0763958850477446,1.2383903488890005,1.4181922516823313,1.6179072863871924]
[]
[]
[]
[null,null,4,{"$f":"\"  \"&IF(VLOOKUP(C110,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C110,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  Nancy Jenkins"},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I111)+1,MONTH(I111),DAY(I111))","v":"2017-12-31"},{"$f":"DATE(YEAR(J111)+1,MONTH(J111),DAY(J111))","v":"2018-12-31"},{"$f":"DATE(YEAR(K111)+1,MONTH(K111),DAY(K111))","v":"2019-12-31"},{"$f":"DATE(YEAR(L111)+1,MONTH(L111),DAY(L111))","v":"2020-12-31"},{"$f":"DATE(YEAR(M111)+1,MONTH(M111),DAY(M111))","v":"2021-12-31"},{"$f":"DATE(YEAR(N111)+1,MONTH(N111),DAY(N111))","v":"2022-12-31"},{"$f":"DATE(YEAR(O111)+1,MONTH(O111),DAY(O111))","v":"2023-12-31"},{"$f":"DATE(YEAR(P111)+1,MONTH(P111),DAY(P111))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q111)+1,MONTH(Q111),DAY(Q111))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H113","v":33.25},{"$f":"H114","v":44.222499999999997},{"$f":"H115","v":58.815925},{"$f":"H116","v":73.519906250000005},{"$f":"H117","v":91.899882812499996},{"$f":"H118","v":114.87485351562501},{"$f":"H119","v":132.10608154296875},{"$f":"H120","v":151.92199377441403},{"$f":"H121","v":174.71029284057613},{"$f":"H122","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH($E113,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F113","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G113*(I112-$H112)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I113*Z113","v":0},{"$f":"J113*AA113","v":0},{"$f":"K113*AB113","v":0},{"$f":"L113*AC113","v":0},{"$f":"M113*AD113","v":0},{"$f":"N113*AE113","v":0},{"$f":"O113*AF113","v":0},{"$f":"P113*AG113","v":0},{"$f":"Q113*AH113","v":0},{"$f":"R113*AI113","v":0}]
[null,null,null,{"$f":"D113+1","v":2},{"$f":"E113+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E114,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G114*(J112-$I112)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I114*Z114","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D114+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E115,TopRow,0))","v":0.15},3000,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G115*(K112-$J112)","v":43780.275000000009},87892.218750000029,143032.1484375,211957.06054687503,263650.74462890625,323098.48132324213,391463.37852172839,470083.01029998757,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,84782.824218750015,263650.74462890625,323098.48132324213,391463.37852172839,470083.01029998757]
[null,null,null,{"$f":"D115+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E116,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G116*(L112-$K112)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D116+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E117,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G117*(M112-$L112)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D117+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E118,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G118*(N112-$M112)","v":0},{"$f":"$G118*(O112-$M112)","v":0},{"$f":"$G118*(P112-$M112)","v":0},{"$f":"$G118*(Q112-$M112)","v":0},{"$f":"$G118*(R112-$M112)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D118+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E119,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G119*(O112-$N112)","v":0},{"$f":"$G119*(P112-$N112)","v":0},{"$f":"$G119*(Q112-$N112)","v":0},{"$f":"$G119*(R112-$N112)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D119+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E120,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G120*(P112-$O112)","v":0},{"$f":"$G120*(Q112-$O112)","v":0},{"$f":"$G120*(R112-$O112)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D120+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E121,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G121*(Q112-$P112)","v":0},{"$f":"$G121*(R112-$P112)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D121+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C110,ParticipantNums,0),MATCH(E122,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G122*(R112-$Q112)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F113:F122)","v":0.15},{"$f":"SUM(G113:G122)","v":3000},"Earned",{"$f":"SUM(I113:I122)","v":0},{"$f":"SUM(J113:J122)","v":0},43780.275000000009,87892.218750000029,143032.1484375,211957.06054687503,263650.74462890625,323098.48132324213,391463.37852172839,470083.01029998757]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK113:AK122)","v":0},{"$f":"SUM(AL113:AL122)","v":0},{"$f":"SUM(AM113:AM122)","v":0},{"$f":"SUM(AN113:AN122)","v":0},{"$f":"SUM(AO113:AO122)","v":0},{"$f":"SUM(AP113:AP122)","v":84782.824218750015},{"$f":"SUM(AQ113:AQ122)","v":263650.74462890625},{"$f":"SUM(AR113:AR122)","v":323098.48132324213},{"$f":"SUM(AS113:AS122)","v":391463.37852172839},{"$f":"SUM(AT113:AT122)","v":470083.01029998757}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":250000},{"$f":"I126*(1+CompGrowthRate)","v":257500},{"$f":"J126*(1+CompGrowthRate)","v":265225},{"$f":"K126*(1+CompGrowthRate)","v":273181.75},{"$f":"L126*(1+CompGrowthRate)","v":281377.20250000001},{"$f":"M126*(1+CompGrowthRate)","v":289818.51857499999},{"$f":"N126*(1+CompGrowthRate)","v":298513.07413224998},{"$f":"O126*(1+CompGrowthRate)","v":307468.46635621751},{"$f":"P126*(1+CompGrowthRate)","v":316692.52034690406},{"$f":"Q126*(1+CompGrowthRate)","v":326193.29595731117}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":62500},{"$f":"J126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":64375},{"$f":"K126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":66306.25},{"$f":"L126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":68295.4375},{"$f":"M126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":70344.300625000003},{"$f":"N126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":72454.629643749999},{"$f":"O126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":74628.268533062495},{"$f":"P126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":76867.116589054378},{"$f":"Q126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":79173.130086726014},{"$f":"R126*VLOOKUP(C110,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":81548.323989327793}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I126+I127","v":312500},{"$f":"J126+J127","v":321875},331531.25,341477.1875,351721.50312500005,362273.14821875002,373141.34266531246,384335.58294527186,395865.6504336301,407741.61994663894]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I126=0,0,I123/I126)","v":0},{"$f":"IF(J126=0,0,J123/J126)","v":0},0.16506843246300315,0.32173532364442364,0.50832884528909195,0.73134408935992201,0.88321339155852618,1.0508345299674291,1.2360992236031358,1.4411179387374877]
[]
[]
[]
[null,null,5,{"$f":"\"  \"&IF(VLOOKUP(C134,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C134,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  "},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I135)+1,MONTH(I135),DAY(I135))","v":"2017-12-31"},{"$f":"DATE(YEAR(J135)+1,MONTH(J135),DAY(J135))","v":"2018-12-31"},{"$f":"DATE(YEAR(K135)+1,MONTH(K135),DAY(K135))","v":"2019-12-31"},{"$f":"DATE(YEAR(L135)+1,MONTH(L135),DAY(L135))","v":"2020-12-31"},{"$f":"DATE(YEAR(M135)+1,MONTH(M135),DAY(M135))","v":"2021-12-31"},{"$f":"DATE(YEAR(N135)+1,MONTH(N135),DAY(N135))","v":"2022-12-31"},{"$f":"DATE(YEAR(O135)+1,MONTH(O135),DAY(O135))","v":"2023-12-31"},{"$f":"DATE(YEAR(P135)+1,MONTH(P135),DAY(P135))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q135)+1,MONTH(Q135),DAY(Q135))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H137","v":33.25},{"$f":"H138","v":44.222499999999997},{"$f":"H139","v":58.815925},{"$f":"H140","v":73.519906250000005},{"$f":"H141","v":91.899882812499996},{"$f":"H142","v":114.87485351562501},{"$f":"H143","v":132.10608154296875},{"$f":"H144","v":151.92199377441403},{"$f":"H145","v":174.71029284057613},{"$f":"H146","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH($E137,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F137","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G137*(I136-$H136)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I137*Z137","v":0},{"$f":"J137*AA137","v":0},{"$f":"K137*AB137","v":0},{"$f":"L137*AC137","v":0},{"$f":"M137*AD137","v":0},{"$f":"N137*AE137","v":0},{"$f":"O137*AF137","v":0},{"$f":"P137*AG137","v":0},{"$f":"Q137*AH137","v":0},{"$f":"R137*AI137","v":0}]
[null,null,null,{"$f":"D137+1","v":2},{"$f":"E137+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E138,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G138*(J136-$I136)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I138*Z138","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D138+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E139,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G139*(K136-$J136)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D139+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E140,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G140*(L136-$K136)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D140+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E141,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G141*(M136-$L136)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D141+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E142,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G142*(N136-$M136)","v":0},{"$f":"$G142*(O136-$M136)","v":0},{"$f":"$G142*(P136-$M136)","v":0},{"$f":"$G142*(Q136-$M136)","v":0},{"$f":"$G142*(R136-$M136)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D142+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E143,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G143*(O136-$N136)","v":0},{"$f":"$G143*(P136-$N136)","v":0},{"$f":"$G143*(Q136-$N136)","v":0},{"$f":"$G143*(R136-$N136)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D143+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E144,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G144*(P136-$O136)","v":0},{"$f":"$G144*(Q136-$O136)","v":0},{"$f":"$G144*(R136-$O136)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D144+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E145,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G145*(Q136-$P136)","v":0},{"$f":"$G145*(R136-$P136)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D145+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C134,ParticipantNums,0),MATCH(E146,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G146*(R136-$Q136)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F137:F146)","v":0},{"$f":"SUM(G137:G146)","v":0},"Earned",{"$f":"SUM(I137:I146)","v":0},{"$f":"SUM(J137:J146)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK137:AK146)","v":0},{"$f":"SUM(AL137:AL146)","v":0},{"$f":"SUM(AM137:AM146)","v":0},{"$f":"SUM(AN137:AN146)","v":0},{"$f":"SUM(AO137:AO146)","v":0},{"$f":"SUM(AP137:AP146)","v":0},{"$f":"SUM(AQ137:AQ146)","v":0},{"$f":"SUM(AR137:AR146)","v":0},{"$f":"SUM(AS137:AS146)","v":0},{"$f":"SUM(AT137:AT146)","v":0}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":0},{"$f":"I150*(1+CompGrowthRate)","v":0},{"$f":"J150*(1+CompGrowthRate)","v":0},{"$f":"K150*(1+CompGrowthRate)","v":0},{"$f":"L150*(1+CompGrowthRate)","v":0},{"$f":"M150*(1+CompGrowthRate)","v":0},{"$f":"N150*(1+CompGrowthRate)","v":0},{"$f":"O150*(1+CompGrowthRate)","v":0},{"$f":"P150*(1+CompGrowthRate)","v":0},{"$f":"Q150*(1+CompGrowthRate)","v":0}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"J150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"K150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"L150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"M150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"N150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"O150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"P150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"Q150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"R150*VLOOKUP(C134,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I150+I151","v":0},{"$f":"J150+J151","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I150=0,0,I147/I150)","v":0},{"$f":"IF(J150=0,0,J147/J150)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,6,{"$f":"\"  \"&IF(VLOOKUP(C158,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C158,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  "},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I159)+1,MONTH(I159),DAY(I159))","v":"2017-12-31"},{"$f":"DATE(YEAR(J159)+1,MONTH(J159),DAY(J159))","v":"2018-12-31"},{"$f":"DATE(YEAR(K159)+1,MONTH(K159),DAY(K159))","v":"2019-12-31"},{"$f":"DATE(YEAR(L159)+1,MONTH(L159),DAY(L159))","v":"2020-12-31"},{"$f":"DATE(YEAR(M159)+1,MONTH(M159),DAY(M159))","v":"2021-12-31"},{"$f":"DATE(YEAR(N159)+1,MONTH(N159),DAY(N159))","v":"2022-12-31"},{"$f":"DATE(YEAR(O159)+1,MONTH(O159),DAY(O159))","v":"2023-12-31"},{"$f":"DATE(YEAR(P159)+1,MONTH(P159),DAY(P159))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q159)+1,MONTH(Q159),DAY(Q159))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H161","v":33.25},{"$f":"H162","v":44.222499999999997},{"$f":"H163","v":58.815925},{"$f":"H164","v":73.519906250000005},{"$f":"H165","v":91.899882812499996},{"$f":"H166","v":114.87485351562501},{"$f":"H167","v":132.10608154296875},{"$f":"H168","v":151.92199377441403},{"$f":"H169","v":174.71029284057613},{"$f":"H170","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH($E161,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F161","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G161*(I160-$H160)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I161*Z161","v":0},{"$f":"J161*AA161","v":0},{"$f":"K161*AB161","v":0},{"$f":"L161*AC161","v":0},{"$f":"M161*AD161","v":0},{"$f":"N161*AE161","v":0},{"$f":"O161*AF161","v":0},{"$f":"P161*AG161","v":0},{"$f":"Q161*AH161","v":0},{"$f":"R161*AI161","v":0}]
[null,null,null,{"$f":"D161+1","v":2},{"$f":"E161+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E162,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G162*(J160-$I160)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I162*Z162","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D162+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E163,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G163*(K160-$J160)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D163+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E164,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G164*(L160-$K160)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D164+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E165,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G165*(M160-$L160)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D165+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E166,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G166*(N160-$M160)","v":0},{"$f":"$G166*(O160-$M160)","v":0},{"$f":"$G166*(P160-$M160)","v":0},{"$f":"$G166*(Q160-$M160)","v":0},{"$f":"$G166*(R160-$M160)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D166+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E167,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G167*(O160-$N160)","v":0},{"$f":"$G167*(P160-$N160)","v":0},{"$f":"$G167*(Q160-$N160)","v":0},{"$f":"$G167*(R160-$N160)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D167+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E168,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G168*(P160-$O160)","v":0},{"$f":"$G168*(Q160-$O160)","v":0},{"$f":"$G168*(R160-$O160)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D168+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E169,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G169*(Q160-$P160)","v":0},{"$f":"$G169*(R160-$P160)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D169+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C158,ParticipantNums,0),MATCH(E170,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G170*(R160-$Q160)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F161:F170)","v":0},{"$f":"SUM(G161:G170)","v":0},"Earned",{"$f":"SUM(I161:I170)","v":0},{"$f":"SUM(J161:J170)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK161:AK170)","v":0},{"$f":"SUM(AL161:AL170)","v":0},{"$f":"SUM(AM161:AM170)","v":0},{"$f":"SUM(AN161:AN170)","v":0},{"$f":"SUM(AO161:AO170)","v":0},{"$f":"SUM(AP161:AP170)","v":0},{"$f":"SUM(AQ161:AQ170)","v":0},{"$f":"SUM(AR161:AR170)","v":0},{"$f":"SUM(AS161:AS170)","v":0},{"$f":"SUM(AT161:AT170)","v":0}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":0},{"$f":"I174*(1+CompGrowthRate)","v":0},{"$f":"J174*(1+CompGrowthRate)","v":0},{"$f":"K174*(1+CompGrowthRate)","v":0},{"$f":"L174*(1+CompGrowthRate)","v":0},{"$f":"M174*(1+CompGrowthRate)","v":0},{"$f":"N174*(1+CompGrowthRate)","v":0},{"$f":"O174*(1+CompGrowthRate)","v":0},{"$f":"P174*(1+CompGrowthRate)","v":0},{"$f":"Q174*(1+CompGrowthRate)","v":0}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"J174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"K174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"L174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"M174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"N174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"O174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"P174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"Q174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"R174*VLOOKUP(C158,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I174+I175","v":0},{"$f":"J174+J175","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I174=0,0,I171/I174)","v":0},{"$f":"IF(J174=0,0,J171/J174)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,7,{"$f":"\"  \"&IF(VLOOKUP(C182,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C182,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  "},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I183)+1,MONTH(I183),DAY(I183))","v":"2017-12-31"},{"$f":"DATE(YEAR(J183)+1,MONTH(J183),DAY(J183))","v":"2018-12-31"},{"$f":"DATE(YEAR(K183)+1,MONTH(K183),DAY(K183))","v":"2019-12-31"},{"$f":"DATE(YEAR(L183)+1,MONTH(L183),DAY(L183))","v":"2020-12-31"},{"$f":"DATE(YEAR(M183)+1,MONTH(M183),DAY(M183))","v":"2021-12-31"},{"$f":"DATE(YEAR(N183)+1,MONTH(N183),DAY(N183))","v":"2022-12-31"},{"$f":"DATE(YEAR(O183)+1,MONTH(O183),DAY(O183))","v":"2023-12-31"},{"$f":"DATE(YEAR(P183)+1,MONTH(P183),DAY(P183))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q183)+1,MONTH(Q183),DAY(Q183))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H185","v":33.25},{"$f":"H186","v":44.222499999999997},{"$f":"H187","v":58.815925},{"$f":"H188","v":73.519906250000005},{"$f":"H189","v":91.899882812499996},{"$f":"H190","v":114.87485351562501},{"$f":"H191","v":132.10608154296875},{"$f":"H192","v":151.92199377441403},{"$f":"H193","v":174.71029284057613},{"$f":"H194","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH($E185,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F185","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G185*(I184-$H184)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I185*Z185","v":0},{"$f":"J185*AA185","v":0},{"$f":"K185*AB185","v":0},{"$f":"L185*AC185","v":0},{"$f":"M185*AD185","v":0},{"$f":"N185*AE185","v":0},{"$f":"O185*AF185","v":0},{"$f":"P185*AG185","v":0},{"$f":"Q185*AH185","v":0},{"$f":"R185*AI185","v":0}]
[null,null,null,{"$f":"D185+1","v":2},{"$f":"E185+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E186,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G186*(J184-$I184)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I186*Z186","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D186+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E187,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G187*(K184-$J184)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D187+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E188,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G188*(L184-$K184)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D188+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E189,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G189*(M184-$L184)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D189+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E190,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G190*(N184-$M184)","v":0},{"$f":"$G190*(O184-$M184)","v":0},{"$f":"$G190*(P184-$M184)","v":0},{"$f":"$G190*(Q184-$M184)","v":0},{"$f":"$G190*(R184-$M184)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D190+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E191,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G191*(O184-$N184)","v":0},{"$f":"$G191*(P184-$N184)","v":0},{"$f":"$G191*(Q184-$N184)","v":0},{"$f":"$G191*(R184-$N184)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D191+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E192,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G192*(P184-$O184)","v":0},{"$f":"$G192*(Q184-$O184)","v":0},{"$f":"$G192*(R184-$O184)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D192+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E193,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G193*(Q184-$P184)","v":0},{"$f":"$G193*(R184-$P184)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D193+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C182,ParticipantNums,0),MATCH(E194,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G194*(R184-$Q184)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F185:F194)","v":0},{"$f":"SUM(G185:G194)","v":0},"Earned",{"$f":"SUM(I185:I194)","v":0},{"$f":"SUM(J185:J194)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK185:AK194)","v":0},{"$f":"SUM(AL185:AL194)","v":0},{"$f":"SUM(AM185:AM194)","v":0},{"$f":"SUM(AN185:AN194)","v":0},{"$f":"SUM(AO185:AO194)","v":0},{"$f":"SUM(AP185:AP194)","v":0},{"$f":"SUM(AQ185:AQ194)","v":0},{"$f":"SUM(AR185:AR194)","v":0},{"$f":"SUM(AS185:AS194)","v":0},{"$f":"SUM(AT185:AT194)","v":0}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":0},{"$f":"I198*(1+CompGrowthRate)","v":0},{"$f":"J198*(1+CompGrowthRate)","v":0},{"$f":"K198*(1+CompGrowthRate)","v":0},{"$f":"L198*(1+CompGrowthRate)","v":0},{"$f":"M198*(1+CompGrowthRate)","v":0},{"$f":"N198*(1+CompGrowthRate)","v":0},{"$f":"O198*(1+CompGrowthRate)","v":0},{"$f":"P198*(1+CompGrowthRate)","v":0},{"$f":"Q198*(1+CompGrowthRate)","v":0}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"J198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"K198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"L198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"M198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"N198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"O198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"P198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"Q198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"R198*VLOOKUP(C182,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I198+I199","v":0},{"$f":"J198+J199","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I198=0,0,I195/I198)","v":0},{"$f":"IF(J198=0,0,J195/J198)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,8,{"$f":"\"  \"&IF(VLOOKUP(C206,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C206,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  "},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I207)+1,MONTH(I207),DAY(I207))","v":"2017-12-31"},{"$f":"DATE(YEAR(J207)+1,MONTH(J207),DAY(J207))","v":"2018-12-31"},{"$f":"DATE(YEAR(K207)+1,MONTH(K207),DAY(K207))","v":"2019-12-31"},{"$f":"DATE(YEAR(L207)+1,MONTH(L207),DAY(L207))","v":"2020-12-31"},{"$f":"DATE(YEAR(M207)+1,MONTH(M207),DAY(M207))","v":"2021-12-31"},{"$f":"DATE(YEAR(N207)+1,MONTH(N207),DAY(N207))","v":"2022-12-31"},{"$f":"DATE(YEAR(O207)+1,MONTH(O207),DAY(O207))","v":"2023-12-31"},{"$f":"DATE(YEAR(P207)+1,MONTH(P207),DAY(P207))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q207)+1,MONTH(Q207),DAY(Q207))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H209","v":33.25},{"$f":"H210","v":44.222499999999997},{"$f":"H211","v":58.815925},{"$f":"H212","v":73.519906250000005},{"$f":"H213","v":91.899882812499996},{"$f":"H214","v":114.87485351562501},{"$f":"H215","v":132.10608154296875},{"$f":"H216","v":151.92199377441403},{"$f":"H217","v":174.71029284057613},{"$f":"H218","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH($E209,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F209","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G209*(I208-$H208)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I209*Z209","v":0},{"$f":"J209*AA209","v":0},{"$f":"K209*AB209","v":0},{"$f":"L209*AC209","v":0},{"$f":"M209*AD209","v":0},{"$f":"N209*AE209","v":0},{"$f":"O209*AF209","v":0},{"$f":"P209*AG209","v":0},{"$f":"Q209*AH209","v":0},{"$f":"R209*AI209","v":0}]
[null,null,null,{"$f":"D209+1","v":2},{"$f":"E209+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E210,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G210*(J208-$I208)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I210*Z210","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D210+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E211,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G211*(K208-$J208)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D211+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E212,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G212*(L208-$K208)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D212+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E213,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G213*(M208-$L208)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D213+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E214,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G214*(N208-$M208)","v":0},{"$f":"$G214*(O208-$M208)","v":0},{"$f":"$G214*(P208-$M208)","v":0},{"$f":"$G214*(Q208-$M208)","v":0},{"$f":"$G214*(R208-$M208)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D214+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E215,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G215*(O208-$N208)","v":0},{"$f":"$G215*(P208-$N208)","v":0},{"$f":"$G215*(Q208-$N208)","v":0},{"$f":"$G215*(R208-$N208)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D215+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E216,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G216*(P208-$O208)","v":0},{"$f":"$G216*(Q208-$O208)","v":0},{"$f":"$G216*(R208-$O208)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D216+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E217,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G217*(Q208-$P208)","v":0},{"$f":"$G217*(R208-$P208)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D217+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C206,ParticipantNums,0),MATCH(E218,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G218*(R208-$Q208)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F209:F218)","v":0},{"$f":"SUM(G209:G218)","v":0},"Earned",{"$f":"SUM(I209:I218)","v":0},{"$f":"SUM(J209:J218)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK209:AK218)","v":0},{"$f":"SUM(AL209:AL218)","v":0},{"$f":"SUM(AM209:AM218)","v":0},{"$f":"SUM(AN209:AN218)","v":0},{"$f":"SUM(AO209:AO218)","v":0},{"$f":"SUM(AP209:AP218)","v":0},{"$f":"SUM(AQ209:AQ218)","v":0},{"$f":"SUM(AR209:AR218)","v":0},{"$f":"SUM(AS209:AS218)","v":0},{"$f":"SUM(AT209:AT218)","v":0}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":0},{"$f":"I222*(1+CompGrowthRate)","v":0},{"$f":"J222*(1+CompGrowthRate)","v":0},{"$f":"K222*(1+CompGrowthRate)","v":0},{"$f":"L222*(1+CompGrowthRate)","v":0},{"$f":"M222*(1+CompGrowthRate)","v":0},{"$f":"N222*(1+CompGrowthRate)","v":0},{"$f":"O222*(1+CompGrowthRate)","v":0},{"$f":"P222*(1+CompGrowthRate)","v":0},{"$f":"Q222*(1+CompGrowthRate)","v":0}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"J222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"K222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"L222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"M222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"N222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"O222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"P222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"Q222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"R222*VLOOKUP(C206,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I222+I223","v":0},{"$f":"J222+J223","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I222=0,0,I219/I222)","v":0},{"$f":"IF(J222=0,0,J219/J222)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,9,{"$f":"\"  \"&IF(VLOOKUP(C230,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C230,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  "},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I231)+1,MONTH(I231),DAY(I231))","v":"2017-12-31"},{"$f":"DATE(YEAR(J231)+1,MONTH(J231),DAY(J231))","v":"2018-12-31"},{"$f":"DATE(YEAR(K231)+1,MONTH(K231),DAY(K231))","v":"2019-12-31"},{"$f":"DATE(YEAR(L231)+1,MONTH(L231),DAY(L231))","v":"2020-12-31"},{"$f":"DATE(YEAR(M231)+1,MONTH(M231),DAY(M231))","v":"2021-12-31"},{"$f":"DATE(YEAR(N231)+1,MONTH(N231),DAY(N231))","v":"2022-12-31"},{"$f":"DATE(YEAR(O231)+1,MONTH(O231),DAY(O231))","v":"2023-12-31"},{"$f":"DATE(YEAR(P231)+1,MONTH(P231),DAY(P231))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q231)+1,MONTH(Q231),DAY(Q231))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H233","v":33.25},{"$f":"H234","v":44.222499999999997},{"$f":"H235","v":58.815925},{"$f":"H236","v":73.519906250000005},{"$f":"H237","v":91.899882812499996},{"$f":"H238","v":114.87485351562501},{"$f":"H239","v":132.10608154296875},{"$f":"H240","v":151.92199377441403},{"$f":"H241","v":174.71029284057613},{"$f":"H242","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH($E233,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F233","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G233*(I232-$H232)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I233*Z233","v":0},{"$f":"J233*AA233","v":0},{"$f":"K233*AB233","v":0},{"$f":"L233*AC233","v":0},{"$f":"M233*AD233","v":0},{"$f":"N233*AE233","v":0},{"$f":"O233*AF233","v":0},{"$f":"P233*AG233","v":0},{"$f":"Q233*AH233","v":0},{"$f":"R233*AI233","v":0}]
[null,null,null,{"$f":"D233+1","v":2},{"$f":"E233+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E234,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G234*(J232-$I232)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I234*Z234","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D234+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E235,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G235*(K232-$J232)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D235+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E236,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G236*(L232-$K232)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D236+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E237,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G237*(M232-$L232)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D237+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E238,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G238*(N232-$M232)","v":0},{"$f":"$G238*(O232-$M232)","v":0},{"$f":"$G238*(P232-$M232)","v":0},{"$f":"$G238*(Q232-$M232)","v":0},{"$f":"$G238*(R232-$M232)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D238+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E239,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G239*(O232-$N232)","v":0},{"$f":"$G239*(P232-$N232)","v":0},{"$f":"$G239*(Q232-$N232)","v":0},{"$f":"$G239*(R232-$N232)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D239+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E240,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G240*(P232-$O232)","v":0},{"$f":"$G240*(Q232-$O232)","v":0},{"$f":"$G240*(R232-$O232)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D240+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E241,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G241*(Q232-$P232)","v":0},{"$f":"$G241*(R232-$P232)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D241+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C230,ParticipantNums,0),MATCH(E242,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G242*(R232-$Q232)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F233:F242)","v":0},{"$f":"SUM(G233:G242)","v":0},"Earned",{"$f":"SUM(I233:I242)","v":0},{"$f":"SUM(J233:J242)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK233:AK242)","v":0},{"$f":"SUM(AL233:AL242)","v":0},{"$f":"SUM(AM233:AM242)","v":0},{"$f":"SUM(AN233:AN242)","v":0},{"$f":"SUM(AO233:AO242)","v":0},{"$f":"SUM(AP233:AP242)","v":0},{"$f":"SUM(AQ233:AQ242)","v":0},{"$f":"SUM(AR233:AR242)","v":0},{"$f":"SUM(AS233:AS242)","v":0},{"$f":"SUM(AT233:AT242)","v":0}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":0},{"$f":"I246*(1+CompGrowthRate)","v":0},{"$f":"J246*(1+CompGrowthRate)","v":0},{"$f":"K246*(1+CompGrowthRate)","v":0},{"$f":"L246*(1+CompGrowthRate)","v":0},{"$f":"M246*(1+CompGrowthRate)","v":0},{"$f":"N246*(1+CompGrowthRate)","v":0},{"$f":"O246*(1+CompGrowthRate)","v":0},{"$f":"P246*(1+CompGrowthRate)","v":0},{"$f":"Q246*(1+CompGrowthRate)","v":0}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"J246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"K246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"L246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"M246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"N246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"O246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"P246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"Q246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"R246*VLOOKUP(C230,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I246+I247","v":0},{"$f":"J246+J247","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I246=0,0,I243/I246)","v":0},{"$f":"IF(J246=0,0,J243/J246)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,10,{"$f":"\"  \"&IF(VLOOKUP(C254,'Participant Awards'!$C$11:$D$20,2,FALSE)=0,\"\",VLOOKUP(C254,'Participant Awards'!$C$11:$D$20,2,FALSE))","v":"  "},null,"Phantom\nStock","Phantom\nShares","Share"]
[null,null,null,"Year","Cal Year","Award","Granted","Price",{"$f":"EOYDate","v":"2016-12-31"},{"$f":"DATE(YEAR(I255)+1,MONTH(I255),DAY(I255))","v":"2017-12-31"},{"$f":"DATE(YEAR(J255)+1,MONTH(J255),DAY(J255))","v":"2018-12-31"},{"$f":"DATE(YEAR(K255)+1,MONTH(K255),DAY(K255))","v":"2019-12-31"},{"$f":"DATE(YEAR(L255)+1,MONTH(L255),DAY(L255))","v":"2020-12-31"},{"$f":"DATE(YEAR(M255)+1,MONTH(M255),DAY(M255))","v":"2021-12-31"},{"$f":"DATE(YEAR(N255)+1,MONTH(N255),DAY(N255))","v":"2022-12-31"},{"$f":"DATE(YEAR(O255)+1,MONTH(O255),DAY(O255))","v":"2023-12-31"},{"$f":"DATE(YEAR(P255)+1,MONTH(P255),DAY(P255))","v":"2024-12-31"},{"$f":"DATE(YEAR(Q255)+1,MONTH(Q255),DAY(Q255))","v":"2025-12-31"}]
[null,null,null,null,null,null,null,{"$f":"Calcs!$I$9","v":25},{"$f":"H257","v":33.25},{"$f":"H258","v":44.222499999999997},{"$f":"H259","v":58.815925},{"$f":"H260","v":73.519906250000005},{"$f":"H261","v":91.899882812499996},{"$f":"H262","v":114.87485351562501},{"$f":"H263","v":132.10608154296875},{"$f":"H264","v":151.92199377441403},{"$f":"H265","v":174.71029284057613},{"$f":"H266","v":200.91683676666253},null,null,null,null,null,null,null,"Vesting Rates",null,null,null,null,null,null,null,null,null,null,"Vested Value"]
[null,null,null,1,{"$f":"'Valuation Method'!$H$6+1","v":2016},{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH($E257,TopRow,0))","v":0},{"$f":"PoolPercent*SharesNumber*F257","v":0},{"$f":"Calcs!$I$10","v":33.25},{"$f":"$G257*(I256-$H256)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},{"$f":"'Rate Table'!$O$17","v":1},null,{"$f":"I257*Z257","v":0},{"$f":"J257*AA257","v":0},{"$f":"K257*AB257","v":0},{"$f":"L257*AC257","v":0},{"$f":"M257*AD257","v":0},{"$f":"N257*AE257","v":0},{"$f":"O257*AF257","v":0},{"$f":"P257*AG257","v":0},{"$f":"Q257*AH257","v":0},{"$f":"R257*AI257","v":0}]
[null,null,null,{"$f":"D257+1","v":2},{"$f":"E257+1","v":2017},{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E258,TopRow,0))","v":0},0,{"$f":"Calcs!$I$11","v":44.222499999999997},null,{"$f":"$G258*(J256-$I256)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},{"$f":"'Rate Table'!$O$16","v":1},null,{"$f":"I258*Z258","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D258+1","v":3},2018,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E259,TopRow,0))","v":0},0,{"$f":"Calcs!$I$12","v":58.815925},null,null,{"$f":"$G259*(K256-$J256)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},{"$f":"'Rate Table'!$O$15","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D259+1","v":4},2019,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E260,TopRow,0))","v":0},0,{"$f":"Calcs!$I$13","v":73.519906250000005},null,null,null,{"$f":"$G260*(L256-$K256)","v":0},0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},{"$f":"'Rate Table'!$O$14","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D260+1","v":5},2020,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E261,TopRow,0))","v":0},0,{"$f":"Calcs!$I$14","v":91.899882812499996},null,null,null,null,{"$f":"$G261*(M256-$L256)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},{"$f":"'Rate Table'!$O$13","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D261+1","v":6},2021,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E262,TopRow,0))","v":0},0,{"$f":"Calcs!$I$15","v":114.87485351562501},null,null,null,null,null,{"$f":"$G262*(N256-$M256)","v":0},{"$f":"$G262*(O256-$M256)","v":0},{"$f":"$G262*(P256-$M256)","v":0},{"$f":"$G262*(Q256-$M256)","v":0},{"$f":"$G262*(R256-$M256)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},{"$f":"'Rate Table'!$O$12","v":1},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D262+1","v":7},2022,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E263,TopRow,0))","v":0},0,{"$f":"Calcs!$I$16","v":132.10608154296875},null,null,null,null,null,null,{"$f":"$G263*(O256-$N256)","v":0},{"$f":"$G263*(P256-$N256)","v":0},{"$f":"$G263*(Q256-$N256)","v":0},{"$f":"$G263*(R256-$N256)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},{"$f":"'Rate Table'!$O$11","v":0.4},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D263+1","v":8},2023,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E264,TopRow,0))","v":0},0,{"$f":"Calcs!$I$17","v":151.92199377441403},null,null,null,null,null,null,null,{"$f":"$G264*(P256-$O256)","v":0},{"$f":"$G264*(Q256-$O256)","v":0},{"$f":"$G264*(R256-$O256)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},{"$f":"'Rate Table'!$O$10","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D264+1","v":9},2024,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E265,TopRow,0))","v":0},0,{"$f":"Calcs!$I$18","v":174.71029284057613},null,null,null,null,null,null,null,null,{"$f":"$G265*(Q256-$P256)","v":0},{"$f":"$G265*(R256-$P256)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},{"$f":"'Rate Table'!$O$9","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"D265+1","v":10},2025,{"$f":"INDEX(ParticipantData,MATCH(C254,ParticipantNums,0),MATCH(E266,TopRow,0))","v":0},0,{"$f":"Calcs!$I$19","v":200.91683676666253},null,null,null,null,null,null,null,null,null,{"$f":"$G266*(R256-$Q256)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Rate Table'!$O$8","v":0},null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"SUM(F257:F266)","v":0},{"$f":"SUM(G257:G266)","v":0},"Earned",{"$f":"SUM(I257:I266)","v":0},{"$f":"SUM(J257:J266)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Vested",{"$f":"SUM(AK257:AK266)","v":0},{"$f":"SUM(AL257:AL266)","v":0},{"$f":"SUM(AM257:AM266)","v":0},{"$f":"SUM(AN257:AN266)","v":0},{"$f":"SUM(AO257:AO266)","v":0},{"$f":"SUM(AP257:AP266)","v":0},{"$f":"SUM(AQ257:AQ266)","v":0},{"$f":"SUM(AR257:AR266)","v":0},{"$f":"SUM(AS257:AS266)","v":0},{"$f":"SUM(AT257:AT266)","v":0}]
[]
[null,null,null,null,null,null,null,"Salary",{"$f":"VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,5,FALSE)","v":0},{"$f":"I270*(1+CompGrowthRate)","v":0},{"$f":"J270*(1+CompGrowthRate)","v":0},{"$f":"K270*(1+CompGrowthRate)","v":0},{"$f":"L270*(1+CompGrowthRate)","v":0},{"$f":"M270*(1+CompGrowthRate)","v":0},{"$f":"N270*(1+CompGrowthRate)","v":0},{"$f":"O270*(1+CompGrowthRate)","v":0},{"$f":"P270*(1+CompGrowthRate)","v":0},{"$f":"Q270*(1+CompGrowthRate)","v":0}]
[null,null,null,null,null,null,null,"Bonus",{"$f":"I270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"J270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"K270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"L270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"M270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"N270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"O270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"P270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"Q270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0},{"$f":"R270*VLOOKUP(C254,'Participant Awards'!$C$11:$H$20,6,FALSE)","v":0}]
[null,null,null,null,null,null,null,"Total Comp",{"$f":"I270+I271","v":0},{"$f":"J270+J271","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,"  Phantom Stock Value as % of Salary",null,null,{"$f":"IF(I270=0,0,I267/I270)","v":0},{"$f":"IF(J270=0,0,J267/J270)","v":0},0,0,0,0,0,0,0,0]

{"sheet":"Company Perspective","index":4,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Future Appreciation"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Phantom Stock Pool"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[Share of Future Appreciation]"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Current Company Value"]
[]
[]
[]
[]
[null,null,null,null,null,null,1,{"$f":"G17+1","v":2},{"$f":"H17+1","v":3},4,5,6,7,8,9,10]
[null,null,null,null,"Projected Company Value ",{"$f":"Calcs!F9","v":2500000},{"$f":"Calcs!F10","v":3325000},{"$f":"Calcs!F11","v":4422250},{"$f":"Calcs!F12","v":5881592.5},{"$f":"Calcs!F13","v":7351990.625},{"$f":"Calcs!F14","v":9189988.28125},{"$f":"Calcs!F15","v":11487485.3515625},{"$f":"Calcs!F16","v":13210608.154296875},{"$f":"Calcs!F17","v":15192199.377441404},{"$f":"Calcs!F18","v":17471029.284057613},{"$f":"Calcs!F19","v":20091683.676666252}]
[null,null,null,null,"Appreciation ",null,{"$f":"Calcs!G10","v":825000},{"$f":"Calcs!G11","v":1922250},{"$f":"Calcs!G12","v":3381592.5},{"$f":"Calcs!G13","v":4851990.625},{"$f":"Calcs!G14","v":6689988.28125},{"$f":"Calcs!G15","v":8987485.3515625},{"$f":"Calcs!G16","v":10710608.154296875},{"$f":"Calcs!G17","v":12692199.377441404},{"$f":"Calcs!G18","v":14971029.284057613},{"$f":"Calcs!G19","v":17591683.676666252}]
[null,null,null,null,{"$f":"\"Phantom Stock Pool (\"&TEXT(PoolPercent,\"0.0%\")&\") \"","v":"Phantom Stock Pool (20.0%) "},null,{"$f":"Calcs!H10","v":165000},{"$f":"Calcs!H11","v":384450},{"$f":"Calcs!H12","v":676318.5},{"$f":"Calcs!H13","v":970398.125},{"$f":"Calcs!H14","v":1337997.65625},{"$f":"Calcs!H15","v":1797497.0703125},{"$f":"Calcs!H16","v":2142121.630859375},{"$f":"Calcs!H17","v":2538439.8754882813},{"$f":"Calcs!H18","v":2994205.856811523},{"$f":"Calcs!H19","v":3518336.7353332508}]
[]
[null,null,null,null,null,"Total Annual Awards (%) ",{"$f":"'Participant Awards'!J22","v":0.65},{"$f":"'Participant Awards'!K22-'Participant Awards'!J22","v":0},{"$f":"'Participant Awards'!L22-'Participant Awards'!K22","v":0.25},{"$f":"'Participant Awards'!M22-'Participant Awards'!L22","v":0},{"$f":"'Participant Awards'!N22-'Participant Awards'!M22","v":0},{"$f":"'Participant Awards'!O22-'Participant Awards'!N22","v":0},{"$f":"'Participant Awards'!P22-'Participant Awards'!O22","v":0},{"$f":"'Participant Awards'!Q22-'Participant Awards'!P22","v":0},{"$f":"'Participant Awards'!R22-'Participant Awards'!Q22","v":0},{"$f":"'Participant Awards'!S22-'Participant Awards'!R22","v":0}]
[null,null,null,null,null,"Value of Awards (Earned) ",{"$f":"Calcs!U10","v":107250},{"$f":"Calcs!U11","v":249892.49999999997},{"$f":"Calcs!U12","v":512574.15},{"$f":"Calcs!U13","v":777245.81250000012},{"$f":"Calcs!U14","v":1108085.390625},{"$f":"Calcs!U15","v":1521634.86328125},{"$f":"Calcs!U16","v":1831796.9677734375},{"$f":"Calcs!U17","v":2188483.3879394527},{"$f":"Calcs!U18","v":2598672.77113037},{"$f":"Calcs!U19","v":3070390.5617999258}]
[null,null,null,null,null,"Value of Awards (Vested) ",{"$f":"Calcs!V10","v":0},{"$f":"Calcs!V11","v":0},{"$f":"Calcs!V12","v":0},{"$f":"Calcs!V13","v":252303.51250000007},{"$f":"Calcs!V14","v":869698.4765625},{"$f":"Calcs!V15","v":1309677.802734375},{"$f":"Calcs!V16","v":1831796.9677734375},{"$f":"Calcs!V17","v":2188483.3879394527},{"$f":"Calcs!V18","v":2598672.77113037},{"$f":"Calcs!V19","v":3070390.5617999258}]
[]
[null,null,null,null,null," Total Salaries ",{"$f":"Calcs!W10","v":1075000},{"$f":"Calcs!W11","v":1107250},{"$f":"Calcs!W12","v":1140467.5},{"$f":"Calcs!W13","v":1174681.5249999999},{"$f":"Calcs!W14","v":1209921.9707500001},{"$f":"Calcs!W15","v":1246219.6298725},{"$f":"Calcs!W16","v":1283606.2187686749},{"$f":"Calcs!W17","v":1322114.4053317353},{"$f":"Calcs!W18","v":1361777.8374916874},{"$f":"Calcs!W19","v":1402631.172616438}]
[null,null,null,null,null,"Total Bonuses ",{"$f":"Calcs!X10","v":297500},{"$f":"Calcs!X11","v":306425},{"$f":"Calcs!X12","v":315617.75},{"$f":"Calcs!X13","v":325086.28249999997},{"$f":"Calcs!X14","v":334838.87097500009},{"$f":"Calcs!X15","v":344884.03710425005},{"$f":"Calcs!X16","v":355230.55821737746},{"$f":"Calcs!X17","v":365887.47496389877},{"$f":"Calcs!X18","v":376864.09921281587},{"$f":"Calcs!X19","v":388170.02218920027}]
[null,null,null,null,null,"Total Compensation ",{"$f":"Calcs!Y10","v":1372500},{"$f":"Calcs!Y11","v":1413675},{"$f":"Calcs!Y12","v":1456085.25},{"$f":"Calcs!Y13","v":1499767.8075000001},{"$f":"Calcs!Y14","v":1544760.8417249999},{"$f":"Calcs!Y15","v":1591103.6669767501},{"$f":"Calcs!Y16","v":1638836.7769860523},{"$f":"Calcs!Y17","v":1688001.880295634},{"$f":"Calcs!Y18","v":1738641.9367045034},{"$f":"Calcs!Y19","v":1790801.1948056384}]
[]
[null,null,null,null,null,"  Phantom Stock Earned as % of Salary ",{"$f":"G23/G26","v":9.9767441860465114E-2},{"$f":"H23/H26","v":0.22568751411153756},0.44944213666763849,0.66166513728050691,0.91583210935340387,1.2210005578526537,1.4270708111173112,1.6552904794879189,1.9082942162702312,2.1890220478078248]

{"sheet":"Variables","index":5,"n_rows":39,"n_cols":29,"rows_kept":39,"cut":false,"hidden":true,"merged":[[15,22,15,23],[38,8,38,9]]}
["Variables"]
[]
[]
[]
[null,null,null,"Calc or Reference - Don’t Change","Red    "]
[null,null,null,"From Census Tab","Green   "]
[null,null,null,"Change on Variables Page","Black   ",null,null,null,null,null,null,null,null,"ValueCritList",null,"NumYrsList",null,"GrowRateMethod",null,"YrsToVest",null,"VestingPeriod",null,"PlanType",null,null,"YrToGraph",null,"BenefitPayments"]
[null,null,"Set in Valuation Tab",null,null,null,null,null,null,null,null,null,null,"Gross Revenue",null,3,null,"Single Rate",null,3,null,"Cliff Vesting",null,"Full Value",null,null,1,null,"Annual Benefit Payments"]
[null,null,null,"Specify Values or Use Formulas",{"$f":"'Valuation Method'!H10","v":"Formula Based"},"InputValueMethod",null,null,null,null,null,null,null,"Operating Income",null,{"$f":"P8+1","v":4},null,"Rate Table",null,{"$f":"T8+1","v":4},null,"Vesting Schedule",null,"Incremental Value",null,null,2,null,"Cumulative Benefit Payments"]
[null,null,null,"Measurement Criteria",{"$f":"'Valuation Method'!H14","v":"EBITDA"},"ValueCriteriaSelected",null,null,null,null,null,null,null,"EBITDA",null,{"$f":"P9+1","v":5},null,null,null,{"$f":"T9+1","v":5},null,null,null,null,null,null,3]
[null,null,null,"Current Value of Measurement Criteria",{"$f":"'Valuation Method'!H15","v":500000},"CurrentValueofMeasure",null,null,null,null,null,null,null,"Net Income",null,6,null,"BusValueMethod",null,6,null,null,null,null,null,null,4]
[null,null,null,"Starting Year",{"$f":"'Valuation Method'!H6","v":2015},"StartingYear",null,null,null,null,null,null,null,null,null,7,null,"Specify Values",null,7,null,null,null,null,null,null,5]
[null,null,null,"Number of Future Years",{"$f":"'Valuation Method'!H7","v":10},"NumYrsSelected",null,null,null,null,null,null,null,null,null,8,null,"Formula Based",null,8,null,null,null,null,null,null,6]
[null,null,null,"% of Future Value in the Pool",{"$f":"'Valuation Method'!H9","v":0.2},"PoolPercent",null,null,null,null,null,null,null,null,null,9,null,null,null,9,null,null,null,null,null,null,7]
[null,null,null,"Use Single Rate or Rate Table",{"$f":"'Valuation Method'!H16","v":"Rate Table"},"GrowRateSelected",null,null,null,null,null,null,null,null,null,10,null,null,null,10,null,null,null,null,null,null,8]
[null,null,null,"Single Rate (if Selected)",{"$f":"'Valuation Method'!G17","v":0},"SingleRate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nancy Jenkins",null," <==Goto",null,9]
[null,null,null,"Display Number Format - Valuation Chart",{"$f":"Variables!I39","v":2},"DisplayNumber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[null,null,null,"Valuation Multiple",{"$f":"'Valuation Method'!H18","v":5},"ValuationMultiple",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All"]
[null,null,null,"Number of Shares",{"$f":"'Valuation Method'!H8","v":100000},"SharesNumber",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exec","Exec#"]
[null,null,null,"Use Cliff Vesting or Enter Vesting Schedule",{"$f":"'Valuation Method'!H22","v":"Vesting Schedule"},"VestingMethod",null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D11","v":"John Smith"},1]
[null,null,null,"Vesting Years Selected",{"$f":"K20","v":3},"VestingYears",null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D12","v":"Jim Douglas"},2]
[null,null,null,"Display Number Format - Benefit Chart",{"$f":"#REF!","v":{"$error":"#REF!"}},"DisplayGraph",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D13","v":"Jane Doe"},3]
[null,null,null,"Plan Type Description",{"$f":"IF(PlanTypeSelected=1,\"Full Value\",\"Incremental Value\")","v":"Incremental Value"},"Plantype1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D14","v":"Nancy Jenkins"},4]
[null,null,null,"Plan Type Selected",2,"PlanTypeSelected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D15","v":0},5]
[null,null,null,"Vesting Period Selected",2,"VestingPeriodSelected",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D16","v":0},6]
[null,null,null,"Vesting Year",{"$f":"CHOOSE(VestingPeriodSelected,3,4,5,6,7,8,9,10)","v":4},"VestingYear",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D17","v":0},7]
[null,null,null,"Comp Growth Rate",0.03,"CompGrowthRate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D18","v":0},8]
[null,null,"Set in Participant Value Tab",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D19","v":0},9]
[null,null,null,"Display Number Format - Exhibit",{"$f":"#REF!","v":{"$error":"#REF!"}},"DisplayNumberExhibit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Participant Awards'!D20","v":0},10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Participant Values'!D8,$X$20:$Y$29,2,FALSE)","v":1}," <==Exec#"]
[]
[]
[null,null,"Other Variable"]
[null,null,null,"End of Yr Date",{"$f":"DATE(StartingYear+1,12,31)","v":"2016-12-31"},"EOYDate"]
[null,null,null,"Age",{"$f":"INT((Age_As_Of_Date-DOB)/365.25+0.5)","v":{"$error":"#NAME?"}},"Age"]
[null,null,null,"Salary Increase",0.03,"SalaryGrowth"]
[null,null,null,"Death Age",85,"DeathAge"]
[]
[null,null,null,"For Graph, use Actual (1), Thousands (2) or Millions (3)",null,null,null,null,2]

{"sheet":"Calcs","index":6,"n_rows":19,"n_cols":31,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"SharesNumber","v":100000}]
[]
[null,"Year","Year",{"$f":"ValueCriteriaSelected","v":"EBITDA"},"Projected\nRates","Business \nValue","Appreciation","Phantom Stock Pool","Share\nPrice",null,"Year","Year",{"$f":"IF(InputValueMethod=\"Specify Values\",\"Business Value is Specified Below\",\"Projected \"&ValueCriteriaSelected&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\")))","v":"Projected EBITDA ($ Thousands)"},{"$f":"\"Projected Business Value\"&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Projected Business Value ($ Thousands)"},{"$f":"\"Initial Business Value\"&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Initial Business Value ($ Thousands)"},{"$f":"\"Projected Appreciation\"&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Projected Appreciation ($ Thousands)"},{"$f":"\"Phantom Stock Pool\"&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Phantom Stock Pool ($ Thousands)"},{"$f":"\"Phantom Stock Pool\"&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Phantom Stock Pool ($ Thousands)"},null,null,"Earned","Vested","Salary","Bonus","Total Comp",null,{"$f":"U8&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Earned ($ Thousands)"},{"$f":"V8&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Vested ($ Thousands)"},{"$f":"W8&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Salary ($ Thousands)"},{"$f":"X8&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Bonus ($ Thousands)"},{"$f":"Y8&IF(DisplayNumber=2,\" ($ Thousands)\",IF(DisplayNumber=3,\" ($ Millions)\",\"($ Dollars)\"))","v":"Total Comp ($ Thousands)"}]
[null,null,{"$f":"StartingYear","v":2015},{"$f":"IF(InputValueMethod=\"Specify Values\",0,CurrentValueofMeasure)","v":500000},null,{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D7,D9*ValuationMultiple)","v":2500000},null,null,{"$f":"IF(SharesNumber=0,0,F9/SharesNumber)","v":25},null,{"$f":"StartingYear","v":2015},{"$f":"IF(InputValueMethod=\"Specify Values\",\"\",K9)","v":2015},{"$f":"IF(InputValueMethod=\"Specify Values\",\"\",D9/CHOOSE(DisplayNumber,1,1000,1000000))","v":500},{"$f":"F9/CHOOSE(DisplayNumber,1,1000,1000000)","v":2500},{"$f":"$F$9/CHOOSE(DisplayNumber,1,1000,1000000)","v":2500},null,null,{"$f":"Q9+O9","v":2500}]
[null,{"$f":"B9+1","v":1},{"$f":"C9+1","v":2016},{"$f":"D9*(1+E10)","v":665000},{"$f":"IF(InputValueMethod=\"Specify Values\",(F10-F9)/F9,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I8,SingleRate))","v":0.33},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D8,D10*ValuationMultiple)","v":3325000},{"$f":"F10-$F$9","v":825000},{"$f":"G10*PoolPercent","v":165000},33.25,null,{"$f":"K9+1","v":2016},2016,665,3325,2500,{"$f":"G10/CHOOSE(DisplayNumber,1,1000,1000000)","v":825},{"$f":"H10/CHOOSE(DisplayNumber,1,1000,1000000)","v":165},{"$f":"Q10+O10","v":2665},null,null,{"$f":"'Participant Values'!I51+'Participant Values'!I75+'Participant Values'!I99+'Participant Values'!I123+'Participant Values'!I147+'Participant Values'!I171+'Participant Values'!I195+'Participant Values'!I219+'Participant Values'!I243+'Participant Values'!I267","v":107250},{"$f":"'Participant Values'!I52+'Participant Values'!I76+'Participant Values'!I100+'Participant Values'!I124+'Participant Values'!I148+'Participant Values'!I172+'Participant Values'!I196+'Participant Values'!I220+'Participant Values'!I244+'Participant Values'!I268","v":0},{"$f":"'Participant Values'!I54+'Participant Values'!I78+'Participant Values'!I102+'Participant Values'!I126+'Participant Values'!I150+'Participant Values'!I174+'Participant Values'!I198+'Participant Values'!I222+'Participant Values'!I246+'Participant Values'!I270","v":1075000},{"$f":"'Participant Values'!I55+'Participant Values'!I79+'Participant Values'!I103+'Participant Values'!I127+'Participant Values'!I151+'Participant Values'!I175+'Participant Values'!I199+'Participant Values'!I223+'Participant Values'!I247+'Participant Values'!I271","v":297500},{"$f":"'Participant Values'!I56+'Participant Values'!I80+'Participant Values'!I104+'Participant Values'!I128+'Participant Values'!I152+'Participant Values'!I176+'Participant Values'!I200+'Participant Values'!I224+'Participant Values'!I248+'Participant Values'!I272","v":1372500},null,{"$f":"U10/CHOOSE(DisplayNumber,1,1000,1000000)","v":107.25},{"$f":"V10/CHOOSE(DisplayNumber,1,1000,1000000)","v":0},{"$f":"W10/CHOOSE(DisplayNumber,1,1000,1000000)","v":1075},{"$f":"X10/CHOOSE(DisplayNumber,1,1000,1000000)","v":297.5},{"$f":"Y10/CHOOSE(DisplayNumber,1,1000,1000000)","v":1372.5}]
[null,{"$f":"B10+1","v":2},{"$f":"C10+1","v":2017},{"$f":"D10*(1+E11)","v":884450},{"$f":"IF(InputValueMethod=\"Specify Values\",(F11-F10)/F10,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I9,SingleRate))","v":0.33},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D9,D11*ValuationMultiple)","v":4422250},1922250,384450,44.222499999999997,null,{"$f":"K10+1","v":2017},2017,884.45,4422.25,2500,1922.25,384.45,{"$f":"Q11+O11","v":2884.45},null,null,{"$f":"'Participant Values'!J51+'Participant Values'!J75+'Participant Values'!J99+'Participant Values'!J123+'Participant Values'!J147+'Participant Values'!J171+'Participant Values'!J195+'Participant Values'!J219+'Participant Values'!J243+'Participant Values'!J267","v":249892.49999999997},{"$f":"'Participant Values'!J52+'Participant Values'!J76+'Participant Values'!J100+'Participant Values'!J124+'Participant Values'!J148+'Participant Values'!J172+'Participant Values'!J196+'Participant Values'!J220+'Participant Values'!J244+'Participant Values'!J268","v":0},{"$f":"'Participant Values'!J54+'Participant Values'!J78+'Participant Values'!J102+'Participant Values'!J126+'Participant Values'!J150+'Participant Values'!J174+'Participant Values'!J198+'Participant Values'!J222+'Participant Values'!J246+'Participant Values'!J270","v":1107250},{"$f":"'Participant Values'!J55+'Participant Values'!J79+'Participant Values'!J103+'Participant Values'!J127+'Participant Values'!J151+'Participant Values'!J175+'Participant Values'!J199+'Participant Values'!J223+'Participant Values'!J247+'Participant Values'!J271","v":306425},{"$f":"'Participant Values'!J56+'Participant Values'!J80+'Participant Values'!J104+'Participant Values'!J128+'Participant Values'!J152+'Participant Values'!J176+'Participant Values'!J200+'Participant Values'!J224+'Participant Values'!J248+'Participant Values'!J272","v":1413675},null,249.89249999999998,0,1107.25,306.42500000000001,1413.675]
[null,{"$f":"B11+1","v":3},2018,1176318.5,{"$f":"IF(InputValueMethod=\"Specify Values\",(F12-F11)/F11,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I10,SingleRate))","v":0.33},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D10,D12*ValuationMultiple)","v":5881592.5},3381592.5,676318.5,58.815925,null,{"$f":"K11+1","v":2018},2018,1176.3185000000001,5881.5924999999997,2500,3381.5925000000002,676.31849999999997,3176.3184999999999,null,null,{"$f":"'Participant Values'!K51+'Participant Values'!K75+'Participant Values'!K99+'Participant Values'!K123+'Participant Values'!K147+'Participant Values'!K171+'Participant Values'!K195+'Participant Values'!K219+'Participant Values'!K243+'Participant Values'!K267","v":512574.15},{"$f":"'Participant Values'!K52+'Participant Values'!K76+'Participant Values'!K100+'Participant Values'!K124+'Participant Values'!K148+'Participant Values'!K172+'Participant Values'!K196+'Participant Values'!K220+'Participant Values'!K244+'Participant Values'!K268","v":0},{"$f":"'Participant Values'!K54+'Participant Values'!K78+'Participant Values'!K102+'Participant Values'!K126+'Participant Values'!K150+'Participant Values'!K174+'Participant Values'!K198+'Participant Values'!K222+'Participant Values'!K246+'Participant Values'!K270","v":1140467.5},{"$f":"'Participant Values'!K55+'Participant Values'!K79+'Participant Values'!K103+'Participant Values'!K127+'Participant Values'!K151+'Participant Values'!K175+'Participant Values'!K199+'Participant Values'!K223+'Participant Values'!K247+'Participant Values'!K271","v":315617.75},{"$f":"'Participant Values'!K56+'Participant Values'!K80+'Participant Values'!K104+'Participant Values'!K128+'Participant Values'!K152+'Participant Values'!K176+'Participant Values'!K200+'Participant Values'!K224+'Participant Values'!K248+'Participant Values'!K272","v":1456085.25},null,512.57415000000003,0,1140.4675,315.61775,1456.0852500000001]
[null,4,2019,1470398.125,{"$f":"IF(InputValueMethod=\"Specify Values\",(F13-F12)/F12,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I11,SingleRate))","v":0.25},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D11,D13*ValuationMultiple)","v":7351990.625},4851990.625,970398.125,73.519906250000005,null,2019,2019,1470.3981249999999,7351.9906250000004,2500,4851.9906250000004,970.39812500000005,3470.3981250000002,null,null,{"$f":"'Participant Values'!L51+'Participant Values'!L75+'Participant Values'!L99+'Participant Values'!L123+'Participant Values'!L147+'Participant Values'!L171+'Participant Values'!L195+'Participant Values'!L219+'Participant Values'!L243+'Participant Values'!L267","v":777245.81250000012},{"$f":"'Participant Values'!L52+'Participant Values'!L76+'Participant Values'!L100+'Participant Values'!L124+'Participant Values'!L148+'Participant Values'!L172+'Participant Values'!L196+'Participant Values'!L220+'Participant Values'!L244+'Participant Values'!L268","v":252303.51250000007},{"$f":"'Participant Values'!L54+'Participant Values'!L78+'Participant Values'!L102+'Participant Values'!L126+'Participant Values'!L150+'Participant Values'!L174+'Participant Values'!L198+'Participant Values'!L222+'Participant Values'!L246+'Participant Values'!L270","v":1174681.5249999999},{"$f":"'Participant Values'!L55+'Participant Values'!L79+'Participant Values'!L103+'Participant Values'!L127+'Participant Values'!L151+'Participant Values'!L175+'Participant Values'!L199+'Participant Values'!L223+'Participant Values'!L247+'Participant Values'!L271","v":325086.28249999997},{"$f":"'Participant Values'!L56+'Participant Values'!L80+'Participant Values'!L104+'Participant Values'!L128+'Participant Values'!L152+'Participant Values'!L176+'Participant Values'!L200+'Participant Values'!L224+'Participant Values'!L248+'Participant Values'!L272","v":1499767.8075000001},null,777.24581250000017,252.30351250000007,1174.681525,325.08628249999998,1499.7678075000001]
[null,5,2020,1837997.65625,{"$f":"IF(InputValueMethod=\"Specify Values\",(F14-F13)/F13,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I12,SingleRate))","v":0.25},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D12,D14*ValuationMultiple)","v":9189988.28125},6689988.28125,1337997.65625,91.899882812499996,null,2020,2020,1837.9976562500001,9189.98828125,2500,6689.98828125,1337.9976562500001,3837.9976562500001,null,null,{"$f":"'Participant Values'!M51+'Participant Values'!M75+'Participant Values'!M99+'Participant Values'!M123+'Participant Values'!M147+'Participant Values'!M171+'Participant Values'!M195+'Participant Values'!M219+'Participant Values'!M243+'Participant Values'!M267","v":1108085.390625},{"$f":"'Participant Values'!M52+'Participant Values'!M76+'Participant Values'!M100+'Participant Values'!M124+'Participant Values'!M148+'Participant Values'!M172+'Participant Values'!M196+'Participant Values'!M220+'Participant Values'!M244+'Participant Values'!M268","v":869698.4765625},{"$f":"'Participant Values'!M54+'Participant Values'!M78+'Participant Values'!M102+'Participant Values'!M126+'Participant Values'!M150+'Participant Values'!M174+'Participant Values'!M198+'Participant Values'!M222+'Participant Values'!M246+'Participant Values'!M270","v":1209921.9707500001},{"$f":"'Participant Values'!M55+'Participant Values'!M79+'Participant Values'!M103+'Participant Values'!M127+'Participant Values'!M151+'Participant Values'!M175+'Participant Values'!M199+'Participant Values'!M223+'Participant Values'!M247+'Participant Values'!M271","v":334838.87097500009},{"$f":"'Participant Values'!M56+'Participant Values'!M80+'Participant Values'!M104+'Participant Values'!M128+'Participant Values'!M152+'Participant Values'!M176+'Participant Values'!M200+'Participant Values'!M224+'Participant Values'!M248+'Participant Values'!M272","v":1544760.8417249999},null,1108.0853906249999,869.69847656249999,1209.9219707500001,334.83887097500008,1544.7608417249999]
[null,6,2021,2297497.0703125,{"$f":"IF(InputValueMethod=\"Specify Values\",(F15-F14)/F14,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I13,SingleRate))","v":0.25},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D13,D15*ValuationMultiple)","v":11487485.3515625},8987485.3515625,1797497.0703125,114.87485351562501,null,2021,2021,2297.4970703125,11487.4853515625,2500,8987.4853515625,1797.4970703125,4297.4970703125,null,null,{"$f":"'Participant Values'!N51+'Participant Values'!N75+'Participant Values'!N99+'Participant Values'!N123+'Participant Values'!N147+'Participant Values'!N171+'Participant Values'!N195+'Participant Values'!N219+'Participant Values'!N243+'Participant Values'!N267","v":1521634.86328125},{"$f":"'Participant Values'!N52+'Participant Values'!N76+'Participant Values'!N100+'Participant Values'!N124+'Participant Values'!N148+'Participant Values'!N172+'Participant Values'!N196+'Participant Values'!N220+'Participant Values'!N244+'Participant Values'!N268","v":1309677.802734375},{"$f":"'Participant Values'!N54+'Participant Values'!N78+'Participant Values'!N102+'Participant Values'!N126+'Participant Values'!N150+'Participant Values'!N174+'Participant Values'!N198+'Participant Values'!N222+'Participant Values'!N246+'Participant Values'!N270","v":1246219.6298725},{"$f":"'Participant Values'!N55+'Participant Values'!N79+'Participant Values'!N103+'Participant Values'!N127+'Participant Values'!N151+'Participant Values'!N175+'Participant Values'!N199+'Participant Values'!N223+'Participant Values'!N247+'Participant Values'!N271","v":344884.03710425005},{"$f":"'Participant Values'!N56+'Participant Values'!N80+'Participant Values'!N104+'Participant Values'!N128+'Participant Values'!N152+'Participant Values'!N176+'Participant Values'!N200+'Participant Values'!N224+'Participant Values'!N248+'Participant Values'!N272","v":1591103.6669767501},null,1521.6348632812501,1309.6778027343751,1246.2196298725,344.88403710425007,1591.1036669767502]
[null,7,2022,2642121.630859375,{"$f":"IF(InputValueMethod=\"Specify Values\",(F16-F15)/F15,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I14,SingleRate))","v":0.15},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D14,D16*ValuationMultiple)","v":13210608.154296875},10710608.154296875,2142121.630859375,132.10608154296875,null,2022,2022,2642.1216308593748,13210.608154296875,2500,10710.608154296875,2142.1216308593748,4642.1216308593748,null,null,{"$f":"'Participant Values'!O51+'Participant Values'!O75+'Participant Values'!O99+'Participant Values'!O123+'Participant Values'!O147+'Participant Values'!O171+'Participant Values'!O195+'Participant Values'!O219+'Participant Values'!O243+'Participant Values'!O267","v":1831796.9677734375},{"$f":"'Participant Values'!O52+'Participant Values'!O76+'Participant Values'!O100+'Participant Values'!O124+'Participant Values'!O148+'Participant Values'!O172+'Participant Values'!O196+'Participant Values'!O220+'Participant Values'!O244+'Participant Values'!O268","v":1831796.9677734375},{"$f":"'Participant Values'!O54+'Participant Values'!O78+'Participant Values'!O102+'Participant Values'!O126+'Participant Values'!O150+'Participant Values'!O174+'Participant Values'!O198+'Participant Values'!O222+'Participant Values'!O246+'Participant Values'!O270","v":1283606.2187686749},{"$f":"'Participant Values'!O55+'Participant Values'!O79+'Participant Values'!O103+'Participant Values'!O127+'Participant Values'!O151+'Participant Values'!O175+'Participant Values'!O199+'Participant Values'!O223+'Participant Values'!O247+'Participant Values'!O271","v":355230.55821737746},{"$f":"'Participant Values'!O56+'Participant Values'!O80+'Participant Values'!O104+'Participant Values'!O128+'Participant Values'!O152+'Participant Values'!O176+'Participant Values'!O200+'Participant Values'!O224+'Participant Values'!O248+'Participant Values'!O272","v":1638836.7769860523},null,1831.7969677734375,1831.7969677734375,1283.6062187686748,355.23055821737745,1638.8367769860522]
[null,8,2023,3038439.8754882808,{"$f":"IF(InputValueMethod=\"Specify Values\",(F17-F16)/F16,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I15,SingleRate))","v":0.15},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D15,D17*ValuationMultiple)","v":15192199.377441404},12692199.377441404,2538439.8754882813,151.92199377441403,null,2023,2023,3038.4398754882809,15192.199377441404,2500,12692.199377441404,2538.4398754882814,5038.4398754882814,null,null,{"$f":"'Participant Values'!P51+'Participant Values'!P75+'Participant Values'!P99+'Participant Values'!P123+'Participant Values'!P147+'Participant Values'!P171+'Participant Values'!P195+'Participant Values'!P219+'Participant Values'!P243+'Participant Values'!P267","v":2188483.3879394527},{"$f":"'Participant Values'!P52+'Participant Values'!P76+'Participant Values'!P100+'Participant Values'!P124+'Participant Values'!P148+'Participant Values'!P172+'Participant Values'!P196+'Participant Values'!P220+'Participant Values'!P244+'Participant Values'!P268","v":2188483.3879394527},{"$f":"'Participant Values'!P54+'Participant Values'!P78+'Participant Values'!P102+'Participant Values'!P126+'Participant Values'!P150+'Participant Values'!P174+'Participant Values'!P198+'Participant Values'!P222+'Participant Values'!P246+'Participant Values'!P270","v":1322114.4053317353},{"$f":"'Participant Values'!P55+'Participant Values'!P79+'Participant Values'!P103+'Participant Values'!P127+'Participant Values'!P151+'Participant Values'!P175+'Participant Values'!P199+'Participant Values'!P223+'Participant Values'!P247+'Participant Values'!P271","v":365887.47496389877},{"$f":"'Participant Values'!P56+'Participant Values'!P80+'Participant Values'!P104+'Participant Values'!P128+'Participant Values'!P152+'Participant Values'!P176+'Participant Values'!P200+'Participant Values'!P224+'Participant Values'!P248+'Participant Values'!P272","v":1688001.880295634},null,2188.4833879394528,2188.4833879394528,1322.1144053317353,365.8874749638988,1688.001880295634]
[null,9,2024,3494205.8568115225,{"$f":"IF(InputValueMethod=\"Specify Values\",(F18-F17)/F17,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I16,SingleRate))","v":0.15},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D16,D18*ValuationMultiple)","v":17471029.284057613},14971029.284057613,2994205.856811523,174.71029284057613,null,2024,2024,3494.2058568115226,17471.029284057615,2500,14971.029284057613,2994.2058568115231,5494.2058568115226,null,null,{"$f":"'Participant Values'!Q51+'Participant Values'!Q75+'Participant Values'!Q99+'Participant Values'!Q123+'Participant Values'!Q147+'Participant Values'!Q171+'Participant Values'!Q195+'Participant Values'!Q219+'Participant Values'!Q243+'Participant Values'!Q267","v":2598672.77113037},{"$f":"'Participant Values'!Q52+'Participant Values'!Q76+'Participant Values'!Q100+'Participant Values'!Q124+'Participant Values'!Q148+'Participant Values'!Q172+'Participant Values'!Q196+'Participant Values'!Q220+'Participant Values'!Q244+'Participant Values'!Q268","v":2598672.77113037},{"$f":"'Participant Values'!Q54+'Participant Values'!Q78+'Participant Values'!Q102+'Participant Values'!Q126+'Participant Values'!Q150+'Participant Values'!Q174+'Participant Values'!Q198+'Participant Values'!Q222+'Participant Values'!Q246+'Participant Values'!Q270","v":1361777.8374916874},{"$f":"'Participant Values'!Q55+'Participant Values'!Q79+'Participant Values'!Q103+'Participant Values'!Q127+'Participant Values'!Q151+'Participant Values'!Q175+'Participant Values'!Q199+'Participant Values'!Q223+'Participant Values'!Q247+'Participant Values'!Q271","v":376864.09921281587},{"$f":"'Participant Values'!Q56+'Participant Values'!Q80+'Participant Values'!Q104+'Participant Values'!Q128+'Participant Values'!Q152+'Participant Values'!Q176+'Participant Values'!Q200+'Participant Values'!Q224+'Participant Values'!Q248+'Participant Values'!Q272","v":1738641.9367045034},null,2598.6727711303702,2598.6727711303702,1361.7778374916875,376.86409921281586,1738.6419367045035]
[null,10,2025,4018336.7353332504,{"$f":"IF(InputValueMethod=\"Specify Values\",(F19-F18)/F18,IF(GrowRateSelected=\"Rate Table\",'Rate Table'!I17,SingleRate))","v":0.15},{"$f":"IF(InputValueMethod=\"Specify Values\",'Rate Table'!D17,D19*ValuationMultiple)","v":20091683.676666252},17591683.676666252,3518336.7353332508,200.91683676666253,null,2025,2025,4018.3367353332505,20091.683676666253,2500,17591.683676666253,3518.336735333251,6018.3367353332505,null,null,{"$f":"'Participant Values'!R51+'Participant Values'!R75+'Participant Values'!R99+'Participant Values'!R123+'Participant Values'!R147+'Participant Values'!R171+'Participant Values'!R195+'Participant Values'!R219+'Participant Values'!R243+'Participant Values'!R267","v":3070390.5617999258},{"$f":"'Participant Values'!R52+'Participant Values'!R76+'Participant Values'!R100+'Participant Values'!R124+'Participant Values'!R148+'Participant Values'!R172+'Participant Values'!R196+'Participant Values'!R220+'Participant Values'!R244+'Participant Values'!R268","v":3070390.5617999258},{"$f":"'Participant Values'!R54+'Participant Values'!R78+'Participant Values'!R102+'Participant Values'!R126+'Participant Values'!R150+'Participant Values'!R174+'Participant Values'!R198+'Participant Values'!R222+'Participant Values'!R246+'Participant Values'!R270","v":1402631.172616438},{"$f":"'Participant Values'!R55+'Participant Values'!R79+'Participant Values'!R103+'Participant Values'!R127+'Participant Values'!R151+'Participant Values'!R175+'Participant Values'!R199+'Participant Values'!R223+'Participant Values'!R247+'Participant Values'!R271","v":388170.02218920027},{"$f":"'Participant Values'!R56+'Participant Values'!R80+'Participant Values'!R104+'Participant Values'!R128+'Participant Values'!R152+'Participant Values'!R176+'Participant Values'!R200+'Participant Values'!R224+'Participant Values'!R248+'Participant Values'!R272","v":1790801.1948056384},null,3070.3905617999258,3070.3905617999258,1402.6311726164381,388.17002218920027,1790.8011948056385]

{"sheet":"Rate Table","index":7,"n_rows":17,"n_cols":35,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,1,2,4],[4,1,5,4],[2,6,2,9],[7,24,7,35],[6,24,6,27],[6,28,6,31],[6,32,6,35],[4,6,5,9],[2,11,2,15],[4,11,5,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(Z11:AK11,\">0\")","v":2},"Vesting Years"]
[null,"Back to Valuation Method Exhibit",null,null,null,null,"Back to Valuation Method Exhibit",null,null,null,null,"Back to Valuation Method Exhibit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valuation Method'!H21","v":5},"Vesting Period"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Valuation Method'!H22","v":"Vesting Schedule"},"Vesting Schedule"]
[null,"Specified Business Value",null,null,null,null,"Valuation Growth Rate",null,null,null,null,"Vesting Schedule"]
[]
[null,"Start Year",{"$f":"StartingYear","v":2015},null,null,null,"Start Year",{"$f":"'Valuation Method'!H6","v":2015},"Enter\nRate",null,null,null,"Grant\nYear","Annual","Cum",null,null,null,null,null,null,null,null,null,"Back to Valuation Method Exhibit"]
[null,1,{"$f":"IF(B8<=NumYrsSelected,C7+1,\"\")","v":2016},null,null,null,1,{"$f":"IF(G8<=NumYrsSelected,H7+1,\"\")","v":2016},0.33,null,null,null,1,0,{"$f":"SUM($N$8:N8)","v":0},null,null,null,null,null,null,null,null,null,"Vesting Table"]
[null,{"$f":"B8+1","v":2},{"$f":"IF(B9<=NumYrsSelected,C8+1,\"\")","v":2017},null,null,null,{"$f":"G8+1","v":2},{"$f":"IF(G9<=NumYrsSelected,H8+1,\"\")","v":2017},0.33,null,null,null,{"$f":"IF(L9<=NumYrsSelected,M8+1,\"\")","v":2},0,{"$f":"SUM($N$8:N9)","v":0},null,null,null,null,null,null,null,null,null,null,1,{"$f":"Z9+1","v":2},{"$f":"AA9+1","v":3},4,5,6,7,8,9,10]
[null,{"$f":"B9+1","v":3},2018,null,null,null,{"$f":"G9+1","v":3},2018,0.33,null,null,null,3,0,{"$f":"SUM($N$8:N10)","v":0},null,null,null,null,null,null,null,null,null,null,2015,{"$f":"Z10+1","v":2016},{"$f":"AA10+1","v":2017},2018,2019,2020,2021,2022,2023,2024]
[null,4,2019,null,null,null,4,2019,0.25,null,null,null,4,0.4,{"$f":"SUM($N$8:N11)","v":0.4},null,null,null,null,null,null,null,null,null,"Annual",0,0,0,0,0,0.5,0.5,0,0,0]
[null,5,2020,null,null,null,5,2020,0.25,null,null,null,5,0.6,{"$f":"SUM($N$8:N12)","v":1},null,null,null,null,null,null,null,null,null,"Cumulative",{"$f":"SUM($Z$11:Z11)","v":0},{"$f":"SUM($Z$11:AA11)","v":0},{"$f":"SUM($Z$11:AB11)","v":0},{"$f":"SUM($Z$11:AC11)","v":0},{"$f":"SUM($Z$11:AD11)","v":0},{"$f":"SUM($Z$11:AE11)","v":0.5},{"$f":"SUM($Z$11:AF11)","v":1},{"$f":"SUM($Z$11:AG11)","v":1},{"$f":"SUM($Z$11:AH11)","v":1},{"$f":"SUM($Z$11:AI11)","v":1}]
[null,6,2021,null,null,null,6,2021,0.25,null,null,null,6,0,{"$f":"SUM($N$8:N13)","v":1}]
[null,7,2022,null,null,null,7,2022,0.15,null,null,null,7,0,{"$f":"SUM($N$8:N14)","v":1}]
[null,8,2023,null,null,null,8,2023,0.15,null,null,null,8,0,{"$f":"SUM($N$8:N15)","v":1}]
[null,9,2024,null,null,null,9,2024,0.15,null,null,null,9,0,{"$f":"SUM($N$8:N16)","v":1}]
[null,10,{"$f":"IF(B17<=NumYrsSelected,C16+1,\"\")","v":2025},null,null,null,10,2025,0.15,null,null,null,10,0,{"$f":"SUM($N$8:N17)","v":1}]