{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Example","Blank Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"comments":1,"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":"Example","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[6,0,6,2],[6,3,6,5],[8,1,8,5],[8,6,8,7],[8,9,8,10],[5,0,5,2],[5,3,5,5],[1,0,1,10],[3,0,3,2],[3,3,3,5],[4,0,4,2],[4,3,4,5]]}
[]
["Figure 1: NCM Compliance Schedule"]
[]
["Company name",null,null,"Firm X"]
["Date prepared",null,null,"2012-05-15"]
["For costs incurred during fiscal year ended",null,null,"2011-12-31"]
["Gross revenue from engineering consulting services",null,null,{"$f":"[1]NCMTool!C5","v":8250000},null,null,"(revenue applicable to general engineering, and related, services)"]
[]
["(Steps 1 & 2)","(Step 1)",null,null,null,null,"(Step 3)",null,"(Step 4)","(Step 5)"]
[]
["Position \n(Match to NCM \nJob Descriptions)","Salary","Bonus","Deferred Compensation","Other Compensation","Total Compensation"," Adjustment for Unallowable Activities & Unallowable Forms of Compensation","Compensation Subject to Reasonable-ness Test","NCM Amount","Adjustment: Amount in Excess of NCM","Total Required Adjustment"]
["Chief Executive Officer",255000,55000,32000,23000,{"$f":"SUM(B12:E12)","v":365000},-18500,{"$f":"SUM(F12:G12)","v":346500},{"$f":"[1]NCMTool!E9","v":343720.81560807145},{"$f":"IF(H12>I12,I12-H12,0)","v":-2779.1843919285457},{"$f":"J12+G12","v":-21279.184391928546}]
["Chief Financial Officer",204000,22000,18000,28000,272000,-17500,254500,{"$f":"[1]NCMTool!E13","v":200695.20852977835},-53804.791470221651,-71304.791470221651]
["Senior Vice President",195840,29376,17000,2584,244800,-10500,234300,{"$f":"[1]NCMTool!E11","v":227273.21974563019},-7026.7802543698053,-17526.780254369805]
["Vice President",146250,35100,12000,1650,195000,-7100,187900,{"$f":"[1]NCMTool!E12","v":197339.95982781769},0,-7100]
["Vice President",146250,38500,9000,1250,195000,-7100,187900,{"$f":"[1]NCMTool!E12","v":197339.95982781769},0,-7100]
["Human Resource Director",165000,8000,10000,5000,188000,-8500,179500,{"$f":"[1]NCMTool!E15","v":120462.53421539534},-59037.465784604661,-67537.465784604661]
["  TOTALS",{"$f":"SUM(B12:B17)","v":1112340},187976,98000,61484,1459800,-69200,1390600,1286831.6977545107,-122648.22190112466,-191848.22190112466]
[]
[]
["I hereby certify that, to the best of my knowledge, this schedule is complete and accurate:"]
[]
[]
[]
[]
[null,"Name and Title (printed or typed)"]
[]
[]
[]
[]
[]
[null,"Signature"]
[]
[]
[]
[]
[null,"Date"]
[]
["(Note: This schedule should be certified by a Company officer/executive.)"]

{"sheet":"Blank Form","index":1,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[6,0,6,2],[6,3,6,5],[2,0,2,10],[4,0,4,2],[4,3,4,5],[5,0,5,2],[5,3,5,5],[7,0,7,2],[7,3,7,5],[9,1,9,5],[9,6,9,7],[9,9,9,10]]}
["This worksheet has space available for 15 executive positions. Additional positions may be added by clicking here: "]
[]
["NCM Compliance Schedule"]
[]
["Company name",null,null,"eee"]
["Date prepared"]
["For costs incurred during fiscal year ended"]
["Gross revenue from engineering consulting services",null,null,null,null,null,"(revenue applicable to general engineering, and related, services)"]
[]
["(Steps 1 & 2)","(Step 1)",null,null,null,null,"(Step 3)",null,"(Step 4)","(Step 5)"]
[]
["Position \n(Match to NCM \nJob Descriptions)","Salary","Bonus","Deferred Compensation","Other Compensation","Total Compensation"," Adjustment for Unallowable Activities & Unallowable Forms of Compensation","Compensation Subject to Reasonable-ness Test","NCM Amount","Adjustment: Amount in Excess of NCM","Total Required Adjustment"]
[null,0,0,0,0,{"$f":"SUM(B13:E13)","v":0},0,{"$f":"SUM(F13:G13)","v":0},0,{"$f":"IF(H13>I13,I13-H13,0)","v":0},{"$f":"IF(H13>I13,J13+G13,0)","v":0}]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,{"$f":"SUM(B16:E16)","v":0},0,{"$f":"SUM(F16:G16)","v":0},0,{"$f":"IF(H16>I16,I16-H16,0)","v":0},0]
[null,0,0,0,0,0,0,0,0,0,{"$f":"IF(H17>I17,J17+G17,0)","v":0}]
[null,0,0,0,0,0,0,0,0,0,{"$f":"IF(H18>I18,J18+G18,0)","v":0}]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,{"$f":"SUM(B22:E22)","v":0},0,{"$f":"SUM(F22:G22)","v":0},0,{"$f":"IF(H22>I22,I22-H22,0)","v":0},0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,{"$f":"IF(H25>I25,J25+G25,0)","v":0}]
[null,0,0,0,0,0,0,0,0,0,{"$f":"IF(H26>I26,J26+G26,0)","v":0}]
[null,0,0,0,0,0,0,0,0,0,0]
["  TOTALS",{"$f":"SUM(B13:B27)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
["I hereby certify that, to the best of my knowledge, this schedule is complete and accurate:"]
[]
[]
[]
[]
[null,"Name and Title (printed or typed)"]
[]
[]
[]
[]
[]
[null,"Signature"]
[]
[]
[]
[]
[null,"Date"]
[]
["(Note: This schedule should be certified by a Company officer/executive.)"]