{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Data Entry Backup","Data Entry","Instructions","Goals","NACIS-Data"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"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":"Data Entry Backup","index":0,"n_rows":96,"n_cols":18,"rows_kept":96,"cut":false,"hidden":true,"merged":[[58,5,58,9],[59,5,59,6],[59,8,59,9],[55,3,55,4],[56,3,56,4],[58,2,60,2],[58,3,60,3],[58,4,60,4],[38,2,38,3],[51,2,51,3],[39,2,39,3],[42,0,51,1],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[47,2,47,3],[46,2,46,3],[48,2,48,3],[49,2,49,3],[50,2,50,3],[16,0,39,0],[16,1,26,1],[26,2,26,3],[21,2,22,2],[10,3,10,6],[11,3,11,6],[13,2,15,3],[13,4,13,17],[20,2,20,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[35,1,37,1],[35,2,35,3],[36,2,36,3],[37,2,37,3],[9,3,9,6],[28,1,34,1],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[1,1,2,17],[5,3,5,6],[6,3,6,6],[7,3,7,6],[8,3,8,6]]}
[]
[null,"Profit Gap Manual Entry Form"]
[]
[]
[]
[null,null,"Your Name:","John Doe"]
[null,null,"Company Name:","John's Diner"]
[null,null,"Email Address:","johndoe@email.com"]
[null,null,"2007 NAICS Code:",243545,null,null,null,null,null,"Protection Password=\"protect\""]
[null,null,"Phone:","707-587-2341"]
[null,null,"Ending date of report:","2015-03-31"]
[null,null,"Report Password:","password"]
[]
[null,null,"Accounts",null,"Date"]
[null,null,null,null,"Starting Period",1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,{"$f":"DATE(YEAR($R$16),MONTH($R$16)-12,0)","v":"2014-02-28"},{"$f":"DATE(YEAR($R$16),MONTH($R$16)-(12-F15),0)","v":"2014-03-31"},"2014-04-30","2014-05-31","2014-06-30","2014-07-31","2014-08-31","2014-09-30","2014-10-31","2014-11-30","2014-12-31","2015-01-31",{"$f":"DATE(YEAR($R$16),MONTH($R$16)-(12-Q15),0)","v":"2015-02-28"},{"$f":"D11","v":"2015-03-31"}]
["Balance Sheet","Assets","Cash",null,148155.79,211444.44333333327,10000,136100.6146666666,12472.027973333243,15844,65077,31282.078452224232,6864,12809,23903,10771,52755.355565007514,13777.007985250675]
[null,null,"Receivables",null,900000,850000,973600,1000000,1065000,1000100,1005000,1105000,1015000,1005000,1010000,1035000,900000,900056]
[null,null,"Inventory",null,450000,462000,523000,467800,554800,677000,544000,557750,643350,607500,554000,555000,639000,650000]
[null,null,"Other Operating Assets",null,10122.719999999999,9298.89,8475.0600000000013,7651.2300000000005,10000,24255.65,27481.820000000003,26657.99,28249.160000000003,28510.33,27686.500000000004,26862.670000000002,20000,29265.010000000002]
[null,null,"Notes Receivable Trade",null,0,0,1,0,500,0,0,1,0,0,0,0,0,20]
[null,null,"Gross Fixed Assets","Land & Buildings",415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000]
[null,null,null,"All other",425000,425000,425000,425000,425000,425000,425000,425000,425000,425000,425000,425000,425000,425000]
[null,null,"Accumulated Depreciation \n(Negative Value)",null,-65908.69,-70908.69,-75908.69,-80908.69,-85908.69,-90908.69,-95908.69,-100908.69,-105908.69,-110908.69,-115908.69,-120908.69,-125908.69,-130908.69]
[null,null,"Net Fixed Assets",null,{"$f":"E22+E23+E24","v":774091.31},{"$f":"F22+F23+F24","v":769091.31},764091.31,759091.31,754091.31,749091.31,744091.31,739091.31,734091.31,729091.31,724091.31,719091.31,714091.31,709091.31]
[null,null,"Other Assets",null,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[null,null,"Total Assets",null,{"$f":"SUM(E17:E21)+E25+E26","v":2332369.8200000003},{"$f":"SUM(F17:F21)+F25+F26","v":2351834.6433333335},2329167.37,2420643.1546666669,2446863.337973333,2516290.96,2435650.13,2509782.3784522242,2477554.4699999997,2432910.64,2389680.81,2396724.98,2375846.6655650074,2352209.3279852504]
[]
[null,"Liabilities","Accounts Payables",null,210000,251999.99999999997,187000.00000000003,180000,300000,350000,174000,243750,360000,250000,260000,275000,260000,250000]
[null,null,"Debt (short term <1yr)",null,350000,340000,350000,450000,350000,350000,450000,480000,350000,425000,350000,350000,350000,350000]
[null,null,"Debt (long term >1yr)",null,800000,784000,768320,752953.6,737894.52799999993,723136.63743999996,708673.9046912,694500.426597376,680610.4180654285,666998.20970411994,653658.24551003752,640585.08059983677,627773.37898784003,615217.91140808316]
[null,null,"Other Operating Liabilities",null,0,0,0,0,0,0,0,3602.23,3624.27,3811.91,3541.95,3442.47,4951.03,3346.59]
[null,null,"Tax Due",null,0,161.49,0,0,599.65,102.53,72.180000000000007,319.20999999999998,517.61,105.51,288.02,304.63,527.25,973.82]
[null,null,"Non Operating Liabilities",null,0,0,0,0,0,0,0,0,0,0,0,0,0,458]
[null,null,"Total Liabilities",null,{"$f":"SUM(E29:E34)","v":1360000},{"$f":"SUM(F29:F34)","v":1376161.49},1305320,1382953.6,1388494.1779999998,1423239.16744,1332746.0846911999,1422171.8665973758,1394752.2980654286,1345915.6297041199,1267488.2155100375,1269332.1805998366,1243251.6589878399,1219996.3214080832]
[null,"Equity","Stock / Owners’ Equity / Beginning Capital",null,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000,850000]
[null,null,"Retained Earnings",null,122370,125673.33333333331,173846.59999999998,187689.73466666666,207869.33997333335,243052.01984053332,252904.37944372266,237609.69185484824,232801.2313510846,236995.60672406293,272192.76125624834,277392.6393644567,282595.18657716754,282595.18657716754]
[null,null,"Total Equity",null,{"$f":"E36+E37","v":972370},{"$f":"F36+F37","v":975673.33333333326},1023846.6,1037689.7346666667,1057869.3399733333,1093052.0198405334,1102904.3794437228,1087609.6918548483,1082801.2313510845,1086995.6067240629,1122192.7612562482,1127392.6393644568,1132595.1865771676,1132595.1865771676]
[null,null,"Total Liability + Equity",null,{"$f":"E35+E38","v":2332370},{"$f":"F35+F38","v":2351834.8233333332},2329166.6,2420643.3346666666,2446363.5179733331,2516291.1872805334,2435650.4641349227,2509781.5584522244,2477553.5294165132,2432911.2364281826,2389680.9767662855,2396724.8199642934,2375846.8455650075,2352591.507985251]
[null,null,"Balance Sheet Balanced?",null,{"$f":"IFERROR(IF((ABS(ROUND(E27,0)-ROUND(E39,0)))>=1,CONCATENATE(\"No by \",(ROUND(E27,0)-ROUND(E39,0))),\"Yes\"),\"\")","v":"Yes"},{"$f":"IFERROR(IF((ABS(ROUND(F27,0)-ROUND(F39,0)))>=1,CONCATENATE(\"No by \",(ROUND(F27,0)-ROUND(F39,0))),\"Yes\"),\"\")","v":"Yes"},"Yes","Yes","No by 499","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","No by -383"]
[]
[]
["Income Statement",null,"Sales",null,"NA",350000,360000,340000,300000,425000,490000,290000,325000,450000,360000,400000,395000,375000]
[null,null,"COGS",null,"NA",210000,251999.99999999997,187000.00000000003,180000,300000,350000,174000,243750,340000,250000,260000,275000,265000]
[null,null,"Gross Margin ",null,"NA",{"$f":"F43-F44","v":140000},{"$f":"G43-G44","v":108000.00000000003},152999.99999999997,120000,125000,140000,116000,81250,110000,110000,140000,120000,110000]
[null,null,"Other Variable Costs i.e. commissions",null,"NA",17500,18000,17000,15000,21250,24500,14500,16250,22500,18000,20000,18750,17500]
[null,null,"Marketing, Sales, G&A",null,"NA",100000,100000,100000,100000,100000,100000,100000,90000,90000,100000,100000,90000,80000]
[null,null,"Depreciation & Amortization",null,"NA",5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000]
[null,null,"Interest Expense",null,"NA",4833.3333333333339,4696.666666666667,4826.7333333333336,6156.8653333333332,4820.3946933333336,4817.3201328000005,6147.640396810667,6544.6875888744535,4808.4605037636311,5805.6246270216916,4802.8454678145918,4800.1218917916331,4797.452787289134]
[null,null,"Tax Expense",null,"NA",12458,0,0,10458,0,0,13458,0,0,14458,0,0,10458]
[null,null,"Other Income",null,"NA",500,15000,2540,87351,6888,5874,29004,4587,24485,4,14587,1587,15478]
[null,null,"Net Profit",null,"NA",{"$f":"F45-SUM(F46:F50)+F51","v":708.66666666668607},{"$f":"G45-SUM(G46:G50)+G51","v":-4696.6666666666424},28713.266666666634,70736.13466666668,817.60530666666455,11556.6798672,5898.3596031893394,-31957.687588874454,12176.539496236364,-33259.624627021694,24784.154532185406,3036.8781082083733,7722.547212710866]
[]
[]
[]
[null,null,"Company Name","Date of last report"]
[null,null,{"$f":"'Data Entry'!E59","v":0},{"$f":"'Data Entry'!#REF!","v":{"$error":"#REF!"}}]
[]
[null,null,"Metric","Last report Actuals","Current Goal\nCan be Adjusted*","Industry Averages"]
[null,null,null,null,null,"Top",null,"Median","Bottom"]
[null,null,null,null,null,0.1,0.25,0.5,0.25,0.1]
[null,null,"Current Ratio",2.6342177426361015,5,5,3,1.3,1,0.8]
[null,null,"Quick Ratio",1.5110212151674707,5,5,2.5,1.1000000000000001,0.8,0.7]
[null,null,"Debt-to-Worth",1.1512489129428405,0.2,0.2,0.5,1,1.1000000000000001,1.3]
[null,null,"Gross Margin",0.29333333333333333,0.82,0.82,0.75,0.6,0.32,7.5999999999999998E-2]
[null,null,"Net Margin",7.4466918467791202E-2,0.45,0.45,0.19,0.04,0.02,5.0000000000000001E-3]
[null,null,"Sale to Assets",2.0129664362569151,8,8,6,2,0.9,0.75]
[null,null,"Return on Assets",8.4980147580578369E-2,1.5,1.5,1,0.4,0.25,0.1]
[null,null,"Return on Investments",0.18281345010444136,3.12,3.12,2.2999999999999998,1.2,0.55000000000000004,0.34]
[null,null,"Inventory Turnover",null,30.416666666666668,30.416666666666668,17.38095238095238,10.428571428571429,9.125,8.1111111111111107]
[null,null,"Inventory Turn-Days",73.584905660377359,12,12,21,35,40,45]
[null,null,"Accounts Receivable Turnover",null,73,73,24.333333333333332,18.25,12.166666666666666,9.125]
[null,null,"Accounts Receivable Turn-Days",72.004480000000001,5,5,15,20,30,40]
[null,null,"Accounts Payable Turnover",null,6.6363636363636367,6.6363636363636367,12.166666666666666,121.66666666666667,365,"∞"]
[null,null,"Average Payment Period",28.30188679245283,55,55,30,3,1,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]

{"sheet":"Data Entry","index":1,"n_rows":64,"n_cols":18,"rows_kept":64,"cut":false,"hidden":false,"merged":[[49,2,49,3],[41,2,41,3],[42,2,42,3],[34,2,34,3],[44,2,44,3],[45,2,45,3],[46,2,46,3],[36,1,36,3],[48,2,48,3],[62,2,62,17],[60,2,60,4],[59,2,59,3],[53,2,53,17],[54,2,54,17],[57,2,57,17],[58,2,58,17],[60,6,60,17],[6,3,6,6],[7,3,7,6],[8,3,8,6],[1,0,2,17],[18,2,18,3],[13,2,15,3],[5,3,5,6],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[10,3,10,6],[9,3,9,6],[16,0,36,0],[16,1,25,1],[47,2,47,3],[43,2,43,3],[39,2,39,3],[31,2,31,3],[30,2,30,3],[29,2,29,3],[27,1,33,1],[27,2,27,3],[32,2,32,3],[20,2,20,3],[21,2,21,3],[19,2,19,3],[33,2,33,3],[28,2,28,3],[63,2,63,17],[11,3,11,6],[24,2,24,3],[13,4,13,17],[22,2,23,2],[16,2,16,3],[17,2,17,3],[50,2,50,3],[61,2,61,17],[55,2,55,17],[56,2,56,17],[35,1,35,3],[39,0,50,1],[25,2,25,3],[40,2,40,3],[11,0,11,2]]}
[]
["FinancialSoft Manual Entry Form"]
[]
[]
[]
["Your Name:",null,null,"John Doe"]
["Company Name:",null,null,"John's Diner"]
["Email Address:",null,null,"johndoe@email.com"]
["2012 NAICS Code:",null,null,332813]
["Phone:",null,null,"707-587-2341"]
["Ending date of report:",null,null,"2016-03-31"]
["Report Password:",null,null,"password"]
[]
[null,null,"Accounts",null,"Date"]
[null,null,null,null,"Starting Period",1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,null,null,null,{"$f":"IFERROR((DATE(YEAR($R$16),MONTH($R$16)-12,0)),\"\")","v":"2015-02-28"},{"$f":"IFERROR((DATE(YEAR($R$16),MONTH($R$16)-(12-F15),0)),\"\")","v":"2015-03-31"},{"$f":"IFERROR((DATE(YEAR($R$16),MONTH($R$16)-(12-G15),0)),\"\")","v":"2015-04-30"},"2015-05-31","2015-06-30","2015-07-31","2015-08-31","2015-09-30","2015-10-31","2015-11-30","2015-12-31","2016-01-31",{"$f":"IFERROR((DATE(YEAR($R$16),MONTH($R$16)-(12-Q15),0)),\"\")","v":"2016-02-29"},{"$f":"IF(D11=\"\",\"\",D11)","v":"2016-03-31"}]
["Balance Sheet","Assets","Cash",null,148155.79,215154,10000,136100.6146666666,12472.027973333243,15844,65077,31282.078452224232,6864,12809,23903,10771,52755.355565007514,13777.007985250675]
[null,null,"Receivables",null,339999.89999999991,250918.50999999978,344498.68999999994,315579.20866666711,308917.99269333342,161448.34071999975,247117.9677056002,211777.13036593003,68616.825108458987,65292.695739622228,32831.482291496824,57284.626445666421,15388.325485079549,31280.299910501577]
[null,null,"Inventory",null,450000,462000,523000,467800,554800,677000,544000,557750,643350,607500,554000,555000,550000,550000]
[null,null,"Other Current Assets",null,2541,2541,2541,2541,2541,2541,2541,2541,2541,2541,2541,2541,2541,2541]
[null,null,"Total Current Assets (from above)",null,{"$f":"E17+E18+E19+E20","v":940696.69},{"$f":"F17+F18+F19+F20","v":930613.50999999978},880039.69,922020.82333333371,878731.02066666668,856833.34071999975,858735.9677056002,803350.20881815429,721371.82510845899,688142.69573962223,613275.48229149682,625596.62644566642,620684.68105008709,597598.30789575225]
[null,null,"Total Other Assets",null,0,38582.003333333414,69102.3100000001,124420.79133333219,196582.007306666,279150.65928000025,197882.03229439957,333223.86963407003,386383.17489154078,379707.30426037777,417168.51770850318,417715.37355433358,413611.67451492045,408795.70008949802]
[null,null,"Fixed Assets Depreciated","Land & Buildings",415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000,415000]
[null,null,null,"All other",359091.31,354091.31,349091.31,344091.31,339091.31,334091.31,329091.31,324091.31,319091.31,314091.31,309091.31,304091.31,299091.31,294091.31]
[null,null,"Net Fixed Assets",null,{"$f":"E23+E24","v":774091.31},{"$f":"F23+F24","v":769091.31},764091.31,759091.31,754091.31,749091.31,744091.31,739091.31,734091.31,729091.31,724091.31,719091.31,714091.31,709091.31]
[null,null,"Total Assets",null,{"$f":"E21+E22+E25","v":1714788},{"$f":"F21+F22+F25","v":1738286.8233333332},1713233.31,1805532.924666666,1829404.3379733327,1885075.31,1800709.3099999998,1875665.3884522244,1841846.3099999998,1796941.31,1754535.31,1762403.31,1748387.6655650076,1715485.3179852504]
[]
[null,"Liabilities","Accounts Payables",null,210000,252000,187000.00000000003,180000,300000,350000,174000,243750,360000,250000,260000,275000,260000,250000]
[null,null,"Debt (short term <1yr)",null,350000,340000,350000,450000,350000,350000,450000,480000,350000,425000,350000,350000,350000,350000]
[null,null,"Tax Due",null,0,161.49,0,0,599.65,102.53,72.180000000000007,319.20999999999998,517.61,105.51,288.02,304.63,527.25,973.82]
[null,null,"Total Other Current Liabilities",null,0,6920,92101.310000000056,54420.791333332658,105981.35730666621,138549.12927999999,133809.85229439987,169153.65963407003,235865.56489154135,264601.79426037759,366880.49770850345,352410.74355433346,363084.42451492068,367801.880089499]
[null,null,"Total Current Liabilities",null,{"$f":"E28+E29+E30+E31","v":560000},{"$f":"F28+F29+F30+F31","v":599081.49},629101.31000000006,684420.79133333266,756581.00730666623,838651.65928000002,757882.03229439992,893222.86963406997,946383.17489154136,939707.30426037754,977168.51770850341,977715.37355433346,973611.67451492068,968775.70008949889]
[null,null,"Long Term Liabilities",null,802541,786541,770861,755494.6,740435.52799999993,725677.63743999996,711214.9046912,697041.426597376,683151.4180654285,669539.20970411994,656199.24551003752,643126.08059983677,630314.37898784003,617758.91140808316]
[null,null,"Total Liabilities",null,{"$f":"E32+E33","v":1362541},{"$f":"F32+F33","v":1385622.49},1399962.31,1439915.3913333328,1497016.535306666,1564329.29672,1469096.9369855998,1590264.2962314459,1629534.59295697,1609246.5139644975,1633367.7632185409,1620841.4541541701,1603926.0535027608,1586534.6114975819]
[null,"Equity","Total Equity (Net Worth)",null,352247,352664.33333333337,313271.00000000006,365617.53333333333,332387.80266666668,320247.01328000001,331612.37301440001,285401.09222077869,212311.71704302978,187694.79603550251,121167.54678145912,141561.85584582994,144461.61206224668,128950.70648766842]
[null,"Total Liability + Equity",null,null,{"$f":"E34+E35","v":1714788},{"$f":"F34+F35","v":1738286.8233333332},1713233.31,1805532.924666666,1829404.3379733327,1884576.31,1800709.3099999998,1875665.3884522244,1841846.3099999998,1796941.31,1754535.31,1762403.31,1748387.6655650076,1715485.3179852504]
[null,"Balance Sheet Balanced?",null,null,{"$f":"IFERROR(IF((ABS(ROUND(E26,0)-ROUND(E36,0)))>=1,CONCATENATE(\"No by \",(ROUND(E26,0)-ROUND(E36,0))),\"Yes\"),\"\")","v":"Yes"},{"$f":"IFERROR(IF((ABS(ROUND(F26,0)-ROUND(F36,0)))>=1,CONCATENATE(\"No by \",(ROUND(F26,0)-ROUND(F36,0))),\"Yes\"),\"\")","v":"Yes"},"Yes","Yes","Yes","No by 499","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
[]
[null,null,null,"Dates:",null,{"$f":"F16","v":"2015-03-31"},"2015-04-30","2015-05-31","2015-06-30","2015-07-31","2015-08-31","2015-09-30","2015-10-31","2015-11-30","2015-12-31","2016-01-31","2016-02-29","2016-03-31"]
["Income Statement",null,"Sales",null,"NA",350000,360000,340000,300000,425000,490000,290000,325000,450000,360000,400000,395000,375000]
[null,null,"COGS",null,"NA",210000,251999.99999999997,187000.00000000003,180000,300000,350000,174000,243750,340000,250000,260000,275000,265000]
[null,null,"Gross Margin ",null,"NA",{"$f":"F40-F41","v":140000},{"$f":"G40-G41","v":108000.00000000003},152999.99999999997,120000,125000,140000,116000,81250,110000,110000,140000,120000,110000]
[null,null,"Other Variable Costs not in COGS",null,"NA",17500,18000,17000,15000,21250,24500,14500,16250,22500,18000,20000,18750,17500]
[null,null,"Marketing, Sales, G&A",null,"NA",100000,100000,100000,100000,100000,100000,100000,90000,90000,100000,100000,90000,80000]
[null,null,"Depreciation & Amortization",null,"NA",5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000,5000]
[null,null,"Interest Expense",null,"NA",4833.3333333333339,4696.666666666667,4826.7333333333336,6156.8653333333332,4820.3946933333336,4817.3201328000005,6147.640396810667,6544.6875888744535,4808.4605037636311,5805.6246270216916,4802.8454678145918,4800.1218917916331,4797.452787289134]
[null,null,"Tax Expense",null,"NA",12458,0,0,10458,0,0,13458,0,0,14458,0,0,10458]
[null,null,"Other Expense",null,"NA",500,15000,2540,87351,6888,5874,29004,4587,24485,4,14587,1587,15478]
[null,null,"Total Expense",null,"NA",{"$f":"SUM(F43:F48)","v":140291.33333333331},{"$f":"SUM(G43:G48)","v":142696.66666666669},129366.73333333334,223965.86533333332,137958.39469333334,140191.3201328,168109.64039681066,122381.68758887445,146793.46050376364,143267.62462702169,144389.84546781459,120137.12189179163,133233.45278728913]
[null,null,"Other Income",null,"NA",708.66666666668607,-4696.6666666666424,28713.266666666634,70736.13466666668,817.60530666666455,11556.6798672,5898.3596031893394,-31957.687588874454,12176.539496236364,-33259.624627021694,24784.154532185406,3036.8781082083733,7722.547212710866]
[null,null,"Net Profit",null,"NA",{"$f":"F42-SUM(F43:F48)+F50","v":417.33333333337214},{"$f":"G42-SUM(G43:G48)+G50","v":-39393.333333333299},{"$f":"H42-SUM(H43:H48)+H50","v":52346.533333333267},-33229.730666666641,-12140.789386666671,11365.359734400001,-46211.280793621321,-73089.375177748909,-24616.921007527271,-66527.249254043389,20394.309064370813,2899.7562164167466,-15510.905574578268]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"v21.11"]
[null,null,"Notes on form behavior:"]
[null,null,"1. Only the cells where you can enter data can be selected."]
[null,null,"2. When you mouse over the account name, a comment box will appear showing you the definition of the account."]
[null,null,"3. The date entered in cell to the right of \"Ending date of report:\" is the date you most recently completed entering data into your financial software."]
[null,null,"4. The date entered in cell to the right of \"Ending date of report:\" will automatically populate the Date cells below the \"Periods.\""]
[null,null,"5. The cells in \"Grey\" are automatically calculated for you."]
[null,null,"6. The \"Balance Sheet Balanced?\" tells you if your Balance Sheet is balanced Assets = Liabilities + Equity."]
[null,null,"6a. \"Yes\" means it is balanced. -->",null,"Yes"]
[null,null,"6b.   A red number with a yellow background...",null,null,"No by 499","tells you how far the balance is off. A positive number means the Assets are greater than the  Liabilities + Equity, if negative Liabilities + Equity are greater than the Assets."]
[null,null,"7. The Red \"Clear Form\" button at the top right side of the form clears all the cell data."]
[null,null,"8. The Red \"Shift Data 1 Month\" button at the top right side of the form moves last month data over one month so only the last column (month books are closed) needs to be entered."]
[null,null,"9. \"NA\" in the Starting Period in the Income Statement column represents there is no data to be entered."]

{"sheet":"Instructions","index":2,"n_rows":65,"n_cols":9,"rows_kept":65,"cut":false,"hidden":false,"merged":[[60,2,60,5],[61,2,61,6],[61,8,61,25],[51,1,51,21],[22,1,22,17],[50,1,50,16],[4,1,4,20],[3,1,3,20],[2,1,2,20],[11,3,11,17],[16,1,16,14],[5,1,5,19],[6,1,6,19]]}
[]
[null,"Instructions"]
[null,"This form, once completed and submitted to FinancialSoft, will allow non-QuickBooks users to generate FinancialSoft Financial Analysis reports."]
[null,"Completing this form can be as simple as a copy and paste from another spreadsheet that displays your company’s financial statements."]
[null,"If this is your first report click the red Clear Form button at the top right of the form.                This will clear out all the entrees in the form. The following numbered steps take you through the data entry process:"]
[null,"If this is not your first report and the data on the \"Data Enter\" tab is correct for last month and needs to be moved over 1 month* select the green \"Shift Data 1 Month\" button at the top of the form then go to step 2 below."]
[null,"*NOTE: If this is not your first report but you have fallen behind by more than one month, clicking the \"Shift Data 1 Month\" button at the top of the form will move the data 1 month per click. So if you are two months behind, click the button twice, three month behind click the button three times, let the program complete after each click..."]
[null,"1.     Complete the top form"]
[null,"a.      Your Name: Name that will appear on the report"]
[null,"b.     Company Name: Company Name that will appear on the report"]
[null,"c.      Email Address: email address where the report will be sent"]
[null,"d.     ",null,"2012 NAICS Code: This is where you enter your industry NAICS code so the financial analysis report can compare your data to your industry. If you do not know your NACIS code select the link to the right marked “Find your NACIS Code.” This, when connect to the internet, will open a window in your browser. In the browser window enter your industry type to search for a similar industry shown below where indicated by the red arrow."]
[]
[]
[]
[null,"e.      Phone: A contact number in case we need contact you"]
[null,"f.      Ending date of report: This is the date your books were last completed. It must be a month end date. The dates in all the periods shown below will be automatically populated, each being the month end."]
[null,"g.     Report Password: A password that is used to encrypt your report for security purposes."]
[]
[null,"2.     Complete the Balance Sheet and Income statement"]
[null,"a.      Method 1 – Copy and Paste from 3rd party financial software"]
[null,null,null,"Export to Excel"]
[null,"If your 3rd party financial software has the ability export the Balance Sheet and the Income Statement (P&L) to an Excel spreadsheet, moving data will be easier"]
[null,"1.     Open the third party software"]
[null,"2.     Open the Balance Sheet"]
[null,"3.     Modify the balance sheet for 14 monthly periods showing the date as the last day of each month like shown below."]
[null," "]
[null,"4.     Export the Balance Sheet to Excel (make sure you have no blank columns between the dates)."]
[null,"5.     In the exported spreadsheet, copy and then paste the whole account value into this form."]
[null,"6.     Repeat for each account."]
[null,"7.     Now open the Income Statement."]
[null,"8.     Modify the Income Statement for 13 monthly periods with the date as of the last day of each month. The first period should be the Ending period as in the example shown above."]
[null,"9.     Export the Income Statement to Excel (make sure you have no blank columns between the dates)."]
[null,"10.  In the exported spreadsheet copy and then paste the whole account value into this form."]
[null,"11.  Repeat for each account."]
[]
[null,"b.     Method 2 – Copy and paste out of third party software"]
[null,null,null,"Direct from 3rd party software:"]
[null,"1.     Open the third party software"]
[null,"2.     Open the Balance Sheet"]
[null,"3.     Modify the balance sheet for 14 monthly periods with the date being the last day of each month like shown above."]
[null,"4.     Copy and then paste the whole account value into this form."]
[null,"5.     Repeat for each account."]
[null,"6.     Now open the Income Statement."]
[null,"7.     Modify the Income Statement for 13 monthly periods with the date being the last day of each month. The first period should be the Ending period as in the example shown above"]
[null,"8.     Copy and then paste the whole account value to this form."]
[null,"9.     Repeat for each account."]
[]
[null,"c.      Method 3 – Manual entry"]
[null,"                                                    Manually enter the account values according to the account name and date."]
[null,"Only After First Report. Goals are preset to the top 10% of your industry on your first report and this tab is not available until a first report is run."]
[null,"3.     Complete the \"Goals\" Tab. If this is your first report, the goals are automatically set. On your subsequent report you should review the Goals tab to see if the goals need adjustment as the initial goal was set at the top 10% of your industry NAICS code. Select the \"Goals\" tab and adjust the goals in the yellow cells accordingly. Your last actual and the Industry Averages are shown as a reference."]
[null,"Notes on form behavior:"]
[null,"1.     Only the cells where you can enter data can be selected."]
[null,"2.     When you mouse over the account name, a comment box will appear showing you the definition of the account."]
[]
[null,"3.     The date entered in the cell to the right of \"Ending date of report:\" is the date you most recently completed entering data into your financial software."]
[null,"4.     The date entered in cell to the right of \"Ending date of report:\" will automatically populate the Date cells below the \"Periods.\""]
[null,"5.     The cells in \"Grey\" are automatically calculated for you."]
[null,"6.     The \"Balance Sheet Balanced?\" tells you if your Balance Sheet is balanced: Assets = Liabilities + Equity"]
[null,"6a. \"Yes\" means it is balanced.","6a. \"Yes\" means it is balanced. -->",null,null,null,"Yes"]
[null,"6b. A red number with a yellow background tells you how far the balance is off. A positive number means the Assets are greater than the  Liabilities + Equity, if negative, Liabilities + Equity are greater than the Assets.","6b.   A red number with a yellow background...",null,null,null,null,"No by 499","tells you how far the balance is off. A positive number means the Assets are greater than the  Liabilities + Equity, if negative Liabilities + Equity are greater than the Assets."]
[null,"7.     The Red \"Clear Form\" button clears all the cell data."]
[null,"8.   The Red \"Shift Data 1 Month\" button at the top right side of the form moves last month data over one month so only the last column (month books are closed) needs to be entered."]
[null,"9. \"NA\" in the Starting Period in the Income Statement column represents that there is no data to be entered here."]

{"sheet":"Goals","index":3,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":true,"merged":[[22,1,22,3],[4,1,6,1],[4,2,6,2],[4,3,6,3],[1,2,1,3],[2,2,2,3],[5,4,5,5],[5,7,5,8],[4,4,4,8]]}
[]
[null,"Company Name","Date of last report"]
[null,{"$f":"'Data Entry'!D7","v":"John's Diner"},{"$f":"'Data Entry'!$D$11","v":"2016-03-31"}]
[]
[null,"Metric","Last report Actuals","Current Goal\nCan be Adjusted*","Industry Averages"]
[null,null,null,null,"Top",null,"Median","Bottom"]
[null,null,null,null,0.1,0.25,0.5,0.25,0.1]
[null,"Current Ratio",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H126, LEN('NACIS-Data'!H126)-13),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I126, LEN('NACIS-Data'!I126)-13),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J126, LEN('NACIS-Data'!J126)-13),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K126, LEN('NACIS-Data'!K126)-13),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L126, LEN('NACIS-Data'!L126)-13),\"0.00\")","v":{"$error":"#VALUE!"}}]
[null,"Quick Ratio",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H127, LEN('NACIS-Data'!H127)-11),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I127, LEN('NACIS-Data'!I127)-11),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J127, LEN('NACIS-Data'!J127)-11),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K127, LEN('NACIS-Data'!K127)-11),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L127, LEN('NACIS-Data'!L127)-11),\"0.00\")","v":{"$error":"#VALUE!"}}]
[null,"Debt-to-Worth",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H128, LEN('NACIS-Data'!H128)-12),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I128, LEN('NACIS-Data'!I128)-12),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J128, LEN('NACIS-Data'!J128)-12),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K128, LEN('NACIS-Data'!K128)-12),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L128, LEN('NACIS-Data'!L128)-12),\"0.00\")","v":{"$error":"#VALUE!"}}]
[null,"Gross Margin",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H129, LEN('NACIS-Data'!H129)-13),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I129, LEN('NACIS-Data'!I129)-13),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J129, LEN('NACIS-Data'!J129)-13),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K129, LEN('NACIS-Data'!K129)-13),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L129, LEN('NACIS-Data'!L129)-13),\"0.0%\")","v":{"$error":"#VALUE!"}}]
[null,"Net Margin",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H130, LEN('NACIS-Data'!H130)-10),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I130, LEN('NACIS-Data'!I130)-10),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J130, LEN('NACIS-Data'!J130)-10),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K130, LEN('NACIS-Data'!K130)-10),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L130, LEN('NACIS-Data'!L130)-10),\"0.0%\")","v":{"$error":"#VALUE!"}}]
[null,"Sale to Assets",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H131, LEN('NACIS-Data'!H131)-14),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I131, LEN('NACIS-Data'!I131)-14),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J131, LEN('NACIS-Data'!J131)-14),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K131, LEN('NACIS-Data'!K131)-14),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L131, LEN('NACIS-Data'!L131)-14),\"0.00\")","v":{"$error":"#VALUE!"}}]
[null,"Return on Assets",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H132, LEN('NACIS-Data'!H132)-15),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I132, LEN('NACIS-Data'!I132)-15),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J132, LEN('NACIS-Data'!J132)-15),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K132, LEN('NACIS-Data'!K132)-15),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L132, LEN('NACIS-Data'!L132)-15),\"0.0%\")","v":{"$error":"#VALUE!"}}]
[null,"Return on Investments",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H133, LEN('NACIS-Data'!H133)-20),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I133, LEN('NACIS-Data'!I133)-20),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J133, LEN('NACIS-Data'!J133)-20),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K133, LEN('NACIS-Data'!K133)-20),\"0.0%\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L133, LEN('NACIS-Data'!L133)-20),\"0.0%\")","v":{"$error":"#VALUE!"}}]
[null,"Inventory Turnover"]
[null,"Inventory Turn-Days",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H134, LEN('NACIS-Data'!H134)-18),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I134, LEN('NACIS-Data'!I134)-18),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J134, LEN('NACIS-Data'!J134)-18),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K134, LEN('NACIS-Data'!K134)-18),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L134, LEN('NACIS-Data'!L134)-18),\"0.00\")","v":{"$error":"#VALUE!"}}]
[null,"Accounts Receivable Turnover"]
[null,"Accounts Receivable Turn-Days",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H135, LEN('NACIS-Data'!H135)-27),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I135, LEN('NACIS-Data'!I135)-27),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J135, LEN('NACIS-Data'!J135)-27),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K135, LEN('NACIS-Data'!K135)-27),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L135, LEN('NACIS-Data'!L135)-27),\"0.00\")","v":{"$error":"#VALUE!"}}]
[null,"Accounts Payable Turnover"]
[null,"Average Payment Period",null,null,{"$f":"TEXT(RIGHT('NACIS-Data'!H136, LEN('NACIS-Data'!H136)-21),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!I136, LEN('NACIS-Data'!I136)-21),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!J136, LEN('NACIS-Data'!J136)-21),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!K136, LEN('NACIS-Data'!K136)-21),\"0.00\")","v":{"$error":"#VALUE!"}},{"$f":"TEXT(RIGHT('NACIS-Data'!L136, LEN('NACIS-Data'!L136)-21),\"0.00\")","v":{"$error":"#VALUE!"}}]
[]
[null,"*Note: Only the yellow cells are editable"]

{"sheet":"NACIS-Data","index":4,"n_rows":1804,"n_cols":18,"rows_kept":1804,"cut":false,"hidden":true,"merged":[[98,0,99,0]]}
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CompanyName=\",'Data Entry'!D7)","v":"CompanyName=John's Diner"}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Email=\",'Data Entry'!D8)","v":"Email=johndoe@email.com"}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"IndustryCode=\",'Data Entry'!D9)","v":"IndustryCode=332813"},null,null,null,null,null,"PRODUCTS"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"PhoneNumber=\",'Data Entry'!D10)","v":"PhoneNumber=707-587-2341"},null,null,null,null,null,"Profit Gap",3]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"UserName=\",'Data Entry'!D11)","v":"UserName=42460"},null,null,null,null,null,"Game Plan Tracker",2]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"UserId=\",'Data Entry'!D12)","v":"UserId=password"},null,null,null,null,null,"eFO Collier Consulting Group",10]
[null,null,null,null,null,null,null,"UserTier=7",null,null,null,null,null,"eFO",1]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Name=\",'Data Entry'!D6)","v":"Name=John Doe"},null,null,null,null,null,"eFO Sidekick",20]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"ReportPassword=\",'Data Entry'!D12)","v":"ReportPassword=password"},null,null,null,null,null,"Profit Gap SBDC",7]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"OptionA=\",'Data Entry'!D16)","v":"OptionA="}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"OptionB=\",'Data Entry'!D17)","v":"OptionB="}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"OptionC=\",'Data Entry'!D18)","v":"OptionC="}]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_CurrentRatio=\",Goals!D8)","v":"CurrentGoal_CurrentRatio="},null,null,null,null,null,null,null,null,null,"Getting data for code: 236115"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_QuickRatio=\",Goals!D9)","v":"CurrentGoal_QuickRatio="},null,null,null,null,null,null,null,null,null,"CollectionPeriod"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_DebtToWorth=\",Goals!D10)","v":"CurrentGoal_DebtToWorth="},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_GrossMargin=\",Goals!D11)","v":"CurrentGoal_GrossMargin="},null,null,null,null,null,null,null,null,null,"10 = 4.9305470885630275022178803296"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_NetMargin=\",Goals!D12)","v":"CurrentGoal_NetMargin="},null,null,null,null,null,null,null,null,null,"25 = 10.533798296329553298653984406"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_SalesToAssets=\",Goals!D13)","v":"CurrentGoal_SalesToAssets="},null,null,null,null,null,null,null,null,null,"50 = 12.155863385623666995960333167"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_ReturnOnAssets=\",Goals!D14)","v":"CurrentGoal_ReturnOnAssets="},null,null,null,null,null,null,null,null,null,"75 = 14.252421642314305000192151913"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_ReturnOnInvestments=\",Goals!D15)","v":"CurrentGoal_ReturnOnInvestments="},null,null,null,null,null,null,null,null,null,"90 = 17.998982425572446833477077894"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_InventoryTurnDays=\",Goals!D17)","v":"CurrentGoal_InventoryTurnDays="},null,null,null,null,null,null,null,null,null,"CurrentRatio"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_AccountsReceivableTurnDays=\",Goals!D19)","v":"CurrentGoal_AccountsReceivableTurnDays="},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"CurrentGoal_AveragePaymentPeriod=\",Goals!D21)","v":"CurrentGoal_AveragePaymentPeriod="},null,null,null,null,null,null,null,null,null,"10 = 1.6668312141650137815918103756"]
[null,null,null,null,null,null,null,"LastGoal_CurrentRatio=",null,null,null,null,null,null,null,null,null,"25 = 1.7757485814816503826137267796"]
[null,null,null,null,null,null,null,"LastGoal_QuickRatio=",null,null,null,null,null,null,null,null,null,"50 = 1.8972557897011710437373333981"]
[null,null,null,null,null,null,null,"LastGoal_DebtToWorth=",null,null,null,null,null,null,null,null,null,"75 = 1.9474963035185707920088011330"]
[null,null,null,null,null,null,null,"LastGoal_GrossMargin=",null,null,null,null,null,null,null,null,null,"90 = 2.0603608008779079072267880908"]
[null,null,null,null,null,null,null,"LastGoal_NetMargin=",null,null,null,null,null,null,null,null,null,"QuickRatio"]
[null,null,null,null,null,null,null,"LastGoal_SalesToAssets=",null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,"LastGoal_ReturnOnAssets=",null,null,null,null,null,null,null,null,null,"10 = 0.5073493520650875174289691217"]
[null,null,null,null,null,null,null,"LastGoal_ReturnOnInvestments=",null,null,null,null,null,null,null,null,null,"25 = 0.6217897581166831371870475998"]
[null,null,null,null,null,null,null,"LastGoal_InventoryTurnDays=",null,null,null,null,null,null,null,null,null,"50 = 0.7375874593670237945341362886"]
[null,null,null,null,null,null,null,"LastGoal_AccountsReceivableTurnDays=",null,null,null,null,null,null,null,null,null,"75 = 0.8289053326760963355354789879"]
[null,null,null,null,null,null,null,"LastGoal_AveragePaymentPeriod=",null,null,null,null,null,null,null,null,null,"90 = 0.9389262651641256841341852873"]
[null,null,null,null,null,null,null,"Actual_CurrentRatio=",null,null,null,null,null,null,null,null,null,"TotalLiabilitiesToNetWorth"]
[null,null,null,null,null,null,null,"Actual_QuickRatio=",null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,"Actual_DebtToWorth=",null,null,null,null,null,null,null,null,null,"10 = 1.4018288644686255577606583489"]
[null,null,null,null,null,null,null,"Actual_GrossMargin=",null,null,null,null,null,null,null,null,null,"25 = 1.6193883326680469248874799273"]
[null,null,null,null,null,null,null,"Actual_NetMargin=",null,null,null,null,null,null,null,null,null,"50 = 1.8333353140136401206124250014"]
[null,null,null,null,null,null,null,"Actual_SalesToAssets=",null,null,null,null,null,null,null,null,null,"75 = 2.0142145063365325557192220531"]
[null,null,null,null,null,null,null,"Actual_ReturnOnAssets=",null,null,null,null,null,null,null,null,null,"90 = 2.5143951187969059580617416493"]
[null,null,null,null,null,null,null,"Actual_ReturnOnInvestments=",null,null,null,null,null,null,null,null,null,"GrossProfitMargin"]
[null,null,null,null,null,null,null,"Actual_InventoryTurnDays=",null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,"Actual_AccountsReceivableTurnDays=",null,null,null,null,null,null,null,null,null,"10 = 0.30172364345369260"]
[null,null,null,null,null,null,null,"Actual_AveragePaymentPeriod=",null,null,null,null,null,null,null,null,null,"25 = 0.493325115904637000"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry10_\",H126)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"50 = 0.6473237183559530"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry10_\",H127)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"75 = 0.695069689281867000"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"90 = 0.73931123891967020"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"ReturnOnSales"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"10 = 0.02996727468399056"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"25 = 0.030860993024108100"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"50 = 0.0319702435210559"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"75 = 0.033003419544201100"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"90 = 0.03475603728993320"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"AssetsToSales"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry25_\",I126)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry25_\",I127)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"10 = 0.2900977862360172604446055160"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"25 = 0.3226953120343196898451883523"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"50 = 0.351461208133375629184414803"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"75 = 0.3780094024976577374925736419"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"90 = 0.4297773761382007774746073787"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"ReturnOnAssets"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"10 = 0.0723685810224822033542445058"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"25 = 0.0818221060611924347452343414"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"50 = 0.0916219491929227518418044682"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry50_\",J126)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"75 = 0.0995170265809193596451599355"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry50_\",J127)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"90 = 0.1101083359790166081305329686"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"ReturnOnInvestment"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"10 = 0.1891853600474191850331442012"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"25 = 0.2237004794742308685186920236"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"50 = 0.2577647109518838319368958944"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"75 = 0.2902185359911921399428539283"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"90 = 0.3663182363938802957404465998"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"InventoryTurnover"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry75_\",K126)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"10 = 0.0"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry75_\",K127)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"25 = 0.00"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"50 = 0"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"75 = 1.6648589156927562583474171130"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"90 = 898.5650867705446826511544234"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"DaysPay"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"-----------------"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"10 = 18.380641859065905318020576815"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"25 = 21.997656139480352952108749760"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"50 = 31.640480233497433402277495251"]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,"75 = 39.444917132357368106957401724"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry90_\",L126)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,null,null,null,"90 = 54.371802155702941085426037259"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Industry90_\",L127)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
["Real 2007 and 2012 NAICS Codes",null,null,null,null,null,null,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[111100,null,null,null,null,null,null,"RecurlyAddress1="]
[111110,null,null,null,null,null,null,"RecurlyAddress2="]
[111120,null,null,null,null,null,null,"RecurlyCity="]
[111130,null,null,null,null,null,null,"RecurlyState="]
[111140,null,null,null,null,null,null,"RecurlyCountry="]
[111150,null,null,null,null,null,null,"RecurlyZip=62864"]
[111160,null,null,null,null,null,null,"RecurlySubscriptionPlan=pg_platinum_month"]
[111190,null,null,null,null,null,null,"RecurlyUnitAmountInCents=19999"]
[111191,null,null,null,null,null,null,"RecurlyCouponCode="]
[111199,null,null,null,null,null,null,"RecurlyCouponCode="]
[111200]
[111210]
[111211]
[111219,null,"Top 10%",null,null,null,{"$f":"RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D114,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"),LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D114,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"))-28)","v":{"$error":"#VALUE!"}}]
[111300,null,"Top 25%",null,null,null,{"$f":"RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D115,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"),LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D115,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"))-28)","v":{"$error":"#VALUE!"}}]
[111310,null,"Median",null,null,null,{"$f":"RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D116,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"),LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D116,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"))-28)","v":{"$error":"#VALUE!"}}]
[111320,null,"Bottom 25%",null,null,null,{"$f":"RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D117,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"),LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D117,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"))-28)","v":{"$error":"#VALUE!"}}]
[111330,null,"Bottom 10%",null,null,null,{"$f":"RIGHT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D118,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"),LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($D118,\"\"\"\",\"\"),\":\",\"=\"),\"}\",\"\"))-28)","v":{"$error":"#VALUE!"}}]
[111331]
[111332]
[111333]
[111334]
[111335]
[111336]
[111339,null,null,null,null,null,null,"Top 10%","Top 25%","Median","Bottom 25%","Bottom 10%"]
[111400,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:1)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:1)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:1)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:1)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:1)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111410,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:2)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:2)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:2)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:2)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:2)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111411,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:3)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:3)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:3)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:3)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:3)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111419,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:4)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:4)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:4)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:4)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:4)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111420,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:5)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:5)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:5)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:5)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:5)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111421,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:6)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:6)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:6)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:6)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:6)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111422,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:7)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:7)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:7)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:7)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:7)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111900,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:8)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:8)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:8)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:8)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:8)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111910,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:9)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:9)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:9)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:9)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:9)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111920,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:10)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:10)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:10)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:10)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:10)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111930,null,null,null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($G$114,\",\",REPT(\" \",500)),(ROWS($1:11)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$115,\",\",REPT(\" \",500)),(ROWS($1:11)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$116,\",\",REPT(\" \",500)),(ROWS($1:11)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$117,\",\",REPT(\" \",500)),(ROWS($1:11)-1)*500+1,500))","v":{"$error":"#VALUE!"}},{"$f":"TRIM(MID(SUBSTITUTE($G$118,\",\",REPT(\" \",500)),(ROWS($1:11)-1)*500+1,500))","v":{"$error":"#VALUE!"}}]
[111940]
[111990]
[111991]
[111992]
[111998]
[112100]
[112110]
[112111]
[112112]
[112120]
[112130]
[112200]
[112210]
[112300]
[112310]
[112320]
[112330]
[112340]
[112390]
[112400]
[112410]
[112420]
[112500]
[112510]
[112511]
[112512]
[112519]
[112900]
[112910]
[112920]
[112930]
[112990]
[113100]
[113110]
[113200]
[113210]
[113300]
[113310]
[114100]
[114110]
[114111]
[114112]
[114119]
[114200]
[114210]
[115100]
[115110]
[115111]
[115112]
[115113]
[115114]
[115115]
[115116]
[115200]
[115210]
[115300]
[115310]
[211100]
[211110]
[211111]
[211112]
[212100]
[212110]
[212111]
[212112]
[212113]
[212200]
[212210]
[212220]
[212221]
[212222]
[212230]
[212231]
[212234]
[212290]
[212291]
[212299]
[212300]
[212310]
[212311]
[212312]
[212313]
[212319]
[212320]
[212321]
[212322]
[212324]
[212325]
[212390]
[212391]
[212392]
[212393]
[212399]
[213100]
[213110]
[213111]
[213112]
[213113]
[213114]
[213115]
[221100]
[221110]
[221111]
[221112]
[221113]
[221114]
[221115]
[221116]
[221117]
[221118]
[221119]
[221120]
[221121]
[221122]
[221200]
[221210]
[221300]
[221310]
[221320]
[221330]
[236100]
[236110]
[236115]
[236116]
[236117]
[236118]
[236200]
[236210]
[236220]
[237100]
[237110]
[237120]
[237130]
[237200]
[237210]
[237300]
[237310]
[237900]
[237990]
[238100]
[238110]
[238120]
[238130]
[238140]
[238150]
[238160]
[238170]
[238190]
[238200]
[238210]
[238220]
[238290]
[238300]
[238310]
[238320]
[238330]
[238340]
[238350]
[238390]
[238900]
[238910]
[238990]
[311100]
[311110]
[311111]
[311119]
[311200]
[311210]
[311211]
[311212]
[311213]
[311220]
[311221]
[311222]
[311223]
[311224]
[311225]
[311230]
[311300]
[311310]
[311311]
[311312]
[311313]
[311314]
[311320]
[311330]
[311340]
[311350]
[311351]
[311352]
[311400]
[311410]
[311411]
[311412]
[311420]
[311421]
[311422]
[311423]
[311500]
[311510]
[311511]
[311512]
[311513]
[311514]
[311520]
[311600]
[311610]
[311611]
[311612]
[311613]
[311615]
[311700]
[311710]
[311711]
[311712]
[311800]
[311810]
[311811]
[311812]
[311813]
[311820]
[311821]
[311822]
[311823]
[311824]
[311830]
[311900]
[311910]
[311911]
[311919]
[311920]
[311930]
[311940]
[311941]
[311942]
[311990]
[311991]
[311999]
[312100]
[312110]
[312111]
[312112]
[312113]
[312120]
[312130]
[312140]
[312200]
[312210]
[312221]
[312229]
[312230]
[313100]
[313110]
[313111]
[313112]
[313113]
[313200]
[313210]
[313220]
[313221]
[313222]
[313230]
[313240]
[313241]
[313249]
[313300]
[313310]
[313311]
[313312]
[313320]
[314100]
[314110]
[314120]
[314121]
[314129]
[314900]
[314910]
[314911]
[314912]
[314990]
[314991]
[314992]
[314994]
[314999]
[315100]
[315110]
[315111]
[315119]
[315190]
[315191]
[315192]
[315200]
[315210]
[315211]
[315212]
[315220]
[315221]
[315222]
[315223]
[315224]
[315225]
[315228]
[315231]
[315232]
[315233]
[315234]
[315239]
[315240]
[315280]
[315291]
[315292]
[315299]
[315900]
[315990]
[315991]
[315992]
[315993]
[315999]
[316100]
[316110]
[316200]
[316210]
[316211]
[316212]
[316213]
[316214]
[316219]
[316900]
[316990]
[316991]
[316992]
[316993]
[316998]
[316999]
[321100]
[321110]
[321113]
[321114]
[321200]
[321210]
[321211]
[321212]
[321213]
[321214]
[321219]
[321900]
[321910]
[321911]
[321912]
[321918]
[321920]
[321990]
[321991]
[321992]
[321999]
[322100]
[322110]
[322120]
[322121]
[322122]
[322130]
[322200]
[322210]
[322211]
[322212]
[322213]
[322214]
[322215]
[322219]
[322220]
[322221]
[322222]
[322223]
[322224]
[322225]
[322226]
[322230]
[322231]
[322232]
[322233]
[322290]
[322291]
[322299]
[323100]
[323110]
[323111]
[323112]
[323113]
[323114]
[323115]
[323116]
[323117]
[323118]
[323119]
[323120]
[323121]
[323122]
[324100]
[324110]
[324120]
[324121]
[324122]
[324190]
[324191]
[324199]
[325100]
[325110]
[325120]
[325130]
[325131]
[325132]
[325180]
[325181]
[325182]
[325188]
[325190]
[325191]
[325192]
[325193]
[325194]
[325199]
[325200]
[325210]
[325211]
[325212]
[325220]
[325221]
[325222]
[325300]
[325310]
[325311]
[325312]
[325314]
[325320]
[325400]
[325410]
[325411]
[325412]
[325413]
[325414]
[325500]
[325510]
[325520]
[325600]
[325610]
[325611]
[325612]
[325613]
[325620]
[325900]
[325910]
[325920]
[325990]
[325991]
[325992]
[325998]
[326100]
[326110]
[326111]
[326112]
[326113]
[326120]
[326121]
[326122]
[326130]
[326140]
[326150]
[326160]
[326190]
[326191]
[326192]
[326199]
[326200]
[326210]
[326211]
[326212]
[326220]
[326290]
[326291]
[326299]
[327100]
[327110]
[327111]
[327112]
[327113]
[327120]
[327121]
[327122]
[327123]
[327124]
[327125]
[327200]
[327210]
[327211]
[327212]
[327213]
[327215]
[327300]
[327310]
[327320]
[327330]
[327331]
[327332]
[327390]
[327400]
[327410]
[327420]
[327900]
[327910]
[327990]
[327991]
[327992]
[327993]
[327999]
[331100]
[331110]
[331111]
[331112]
[331200]
[331210]
[331220]
[331221]
[331222]
[331300]
[331310]
[331311]
[331312]
[331313]
[331314]
[331315]
[331316]
[331318]
[331319]
[331400]
[331410]
[331411]
[331419]
[331420]
[331421]
[331422]
[331423]
[331490]
[331491]
[331492]
[331500]
[331510]
[331511]
[331512]
[331513]
[331520]
[331521]
[331522]
[331523]
[331524]
[331525]
[331528]
[331529]
[332100]
[332110]
[332111]
[332112]
[332114]
[332115]
[332116]
[332117]
[332119]
[332200]
[332210]
[332211]
[332212]
[332213]
[332214]
[332215]
[332216]
[332300]
[332310]
[332311]
[332312]
[332313]
[332320]
[332321]
[332322]
[332323]
[332400]
[332410]
[332420]
[332430]
[332431]
[332439]
[332500]
[332510]
[332600]
[332610]
[332611]
[332612]
[332613]
[332618]
[332700]
[332710]
[332720]
[332721]
[332722]
[332800]
[332810]
[332811]
[332812]
[332813]
[332900]
[332910]
[332911]
[332912]
[332913]
[332919]
[332990]
[332991]
[332992]
[332993]
[332994]
[332995]
[332996]
[332997]
[332998]
[332999]
[333100]
[333110]
[333111]
[333112]
[333120]
[333130]
[333131]
[333132]
[333200]
[333210]
[333220]
[333240]
[333241]
[333242]
[333243]
[333244]
[333249]
[333291]
[333292]
[333293]
[333294]
[333295]
[333298]
[333300]
[333310]
[333311]
[333312]
[333313]
[333314]
[333315]
[333316]
[333318]
[333319]
[333400]
[333410]
[333411]
[333412]
[333413]
[333414]
[333415]
[333500]
[333510]
[333511]
[333512]
[333513]
[333514]
[333515]
[333516]
[333517]
[333518]
[333519]
[333600]
[333610]
[333611]
[333612]
[333613]
[333618]
[333900]
[333910]
[333911]
[333912]
[333913]
[333920]
[333921]
[333922]
[333923]
[333924]
[333990]
[333991]
[333992]
[333993]
[333994]
[333995]
[333996]
[333997]
[333999]
[334100]
[334110]
[334111]
[334112]
[334113]
[334118]
[334119]
[334200]
[334210]
[334220]
[334290]
[334300]
[334310]
[334400]
[334410]
[334411]
[334412]
[334413]
[334414]
[334415]
[334416]
[334417]
[334418]
[334419]
[334500]
[334510]
[334511]
[334512]
[334513]
[334514]
[334515]
[334516]
[334517]
[334518]
[334519]
[334600]
[334610]
[334611]
[334612]
[334613]
[334614]
[335100]
[335110]
[335120]
[335121]
[335122]
[335129]
[335200]
[335210]
[335211]
[335212]
[335220]
[335221]
[335222]
[335224]
[335228]
[335300]
[335310]
[335311]
[335312]
[335313]
[335314]
[335900]
[335910]
[335911]
[335912]
[335920]
[335921]
[335929]
[335930]
[335931]
[335932]
[335990]
[335991]
[335999]
[336100]
[336110]
[336111]
[336112]
[336120]
[336200]
[336210]
[336211]
[336212]
[336213]
[336214]
[336300]
[336310]
[336311]
[336312]
[336320]
[336321]
[336322]
[336330]
[336340]
[336350]
[336360]
[336370]
[336390]
[336391]
[336399]
[336400]
[336410]
[336411]
[336412]
[336413]
[336414]
[336415]
[336419]
[336500]
[336510]
[336600]
[336610]
[336611]
[336612]
[336900]
[336990]
[336991]
[336992]
[336999]
[337100]
[337110]
[337120]
[337121]
[337122]
[337124]
[337125]
[337127]
[337129]
[337200]
[337210]
[337211]
[337212]
[337214]
[337215]
[337900]
[337910]
[337920]
[339100]
[339110]
[339112]
[339113]
[339114]
[339115]
[339116]
[339900]
[339910]
[339911]
[339912]
[339913]
[339914]
[339920]
[339930]
[339931]
[339932]
[339940]
[339941]
[339942]
[339943]
[339944]
[339950]
[339990]
[339991]
[339992]
[339993]
[339994]
[339995]
[339999]
[423100]
[423110]
[423120]
[423130]
[423140]
[423200]
[423210]
[423220]
[423300]
[423310]
[423320]
[423330]
[423390]
[423400]
[423410]
[423420]
[423430]
[423440]
[423450]
[423460]
[423490]
[423500]
[423510]
[423520]
[423600]
[423610]
[423620]
[423690]
[423700]
[423710]
[423720]
[423730]
[423740]
[423800]
[423810]
[423820]
[423830]
[423840]
[423850]
[423860]
[423900]
[423910]
[423920]
[423930]
[423940]
[423990]
[424100]
[424110]
[424120]
[424130]
[424200]
[424210]
[424300]
[424310]
[424320]
[424330]
[424340]
[424400]
[424410]
[424420]
[424430]
[424440]
[424450]
[424460]
[424470]
[424480]
[424490]
[424500]
[424510]
[424520]
[424590]
[424600]
[424610]
[424690]
[424700]
[424710]
[424720]
[424800]
[424810]
[424820]
[424900]
[424910]
[424920]
[424930]
[424940]
[424950]
[424990]
[425100]
[425110]
[425120]
[441100]
[441110]
[441120]
[441200]
[441210]
[441220]
[441221]
[441222]
[441228]
[441229]
[441300]
[441310]
[441320]
[442100]
[442110]
[442200]
[442210]
[442290]
[442291]
[442299]
[443100]
[443111]
[443112]
[443120]
[443130]
[443140]
[443141]
[443142]
[444100]
[444110]
[444120]
[444130]
[444190]
[444200]
[444210]
[444220]
[445100]
[445110]
[445120]
[445200]
[445210]
[445220]
[445230]
[445290]
[445291]
[445292]
[445299]
[445300]
[445310]
[446100]
[446110]
[446120]
[446130]
[446190]
[446191]
[446199]
[447100]
[447110]
[447190]
[448100]
[448110]
[448120]
[448130]
[448140]
[448150]
[448190]
[448200]
[448210]
[448300]
[448310]
[448320]
[451100]
[451110]
[451120]
[451130]
[451140]
[451200]
[451210]
[451211]
[451212]
[451220]
[452100]
[452110]
[452111]
[452112]
[452900]
[452910]
[452990]
[453100]
[453110]
[453200]
[453210]
[453220]
[453300]
[453310]
[453900]
[453910]
[453920]
[453930]
[453990]
[453991]
[453998]
[454100]
[454110]
[454111]
[454112]
[454113]
[454200]
[454210]
[454300]
[454310]
[454311]
[454312]
[454319]
[454390]
[481100]
[481110]
[481111]
[481112]
[481200]
[481210]
[481211]
[481212]
[481219]
[482100]
[482110]
[482111]
[482112]
[483100]
[483110]
[483111]
[483112]
[483113]
[483114]
[483200]
[483210]
[483211]
[483212]
[484100]
[484110]
[484120]
[484121]
[484122]
[484200]
[484210]
[484220]
[484230]
[485100]
[485110]
[485111]
[485112]
[485113]
[485119]
[485200]
[485210]
[485300]
[485310]
[485320]
[485400]
[485410]
[485500]
[485510]
[485900]
[485990]
[485991]
[485999]
[486100]
[486110]
[486200]
[486210]
[486900]
[486910]
[486990]
[487100]
[487110]
[487200]
[487210]
[487900]
[487990]
[488100]
[488110]
[488111]
[488119]
[488190]
[488200]
[488210]
[488300]
[488310]
[488320]
[488330]
[488390]
[488400]
[488410]
[488490]
[488500]
[488510]
[488900]
[488990]
[488991]
[488999]
[491100]
[491110]
[492100]
[492110]
[492200]
[492210]
[493100]
[493110]
[493120]
[493130]
[493190]
[511100]
[511110]
[511120]
[511130]
[511140]
[511190]
[511191]
[511199]
[511200]
[511210]
[512100]
[512110]
[512120]
[512130]
[512131]
[512132]
[512190]
[512191]
[512199]
[512200]
[512210]
[512220]
[512230]
[512240]
[512290]
[515100]
[515110]
[515111]
[515112]
[515120]
[515200]
[515210]
[517100]
[517110]
[517200]
[517210]
[517400]
[517410]
[517900]
[517910]
[517911]
[517919]
[518200]
[518210]
[519100]
[519110]
[519120]
[519130]
[519190]
[521100]
[521110]
[522100]
[522110]
[522120]
[522130]
[522190]
[522200]
[522210]
[522220]
[522290]
[522291]
[522292]
[522293]
[522294]
[522298]
[522300]
[522310]
[522320]
[522390]
[523100]
[523110]
[523120]
[523130]
[523140]
[523200]
[523210]
[523900]
[523910]
[523920]
[523930]
[523990]
[523991]
[523999]
[524100]
[524110]
[524113]
[524114]
[524120]
[524126]
[524127]
[524128]
[524130]
[524200]
[524210]
[524290]
[524291]
[524292]
[524298]
[525100]
[525110]
[525120]
[525190]
[525900]
[525910]
[525920]
[525990]
[531100]
[531110]
[531120]
[531130]
[531190]
[531200]
[531210]
[531300]
[531310]
[531311]
[531312]
[531320]
[531390]
[532100]
[532110]
[532111]
[532112]
[532120]
[532200]
[532210]
[532220]
[532230]
[532290]
[532291]
[532292]
[532299]
[532300]
[532310]
[532400]
[532410]
[532411]
[532412]
[532420]
[532490]
[533100]
[533110]
[541100]
[541110]
[541120]
[541190]
[541191]
[541199]
[541200]
[541210]
[541211]
[541213]
[541214]
[541219]
[541300]
[541310]
[541320]
[541330]
[541340]
[541350]
[541360]
[541370]
[541380]
[541400]
[541410]
[541420]
[541430]
[541490]
[541500]
[541510]
[541511]
[541512]
[541513]
[541519]
[541600]
[541610]
[541611]
[541612]
[541613]
[541614]
[541618]
[541620]
[541690]
[541700]
[541710]
[541711]
[541712]
[541720]
[541800]
[541810]
[541820]
[541830]
[541840]
[541850]
[541860]
[541870]
[541890]
[541900]
[541910]
[541920]
[541921]
[541922]
[541930]
[541940]
[541990]
[551100]
[551110]
[551111]
[551112]
[551114]
[561100]
[561110]
[561200]
[561210]
[561300]
[561310]
[561311]
[561312]
[561320]
[561330]
[561400]
[561410]
[561420]
[561421]
[561422]
[561430]
[561431]
[561439]
[561440]
[561450]
[561490]
[561491]
[561492]
[561499]
[561500]
[561510]
[561520]
[561590]
[561591]
[561599]
[561600]
[561610]
[561611]
[561612]
[561613]
[561620]
[561621]
[561622]
[561700]
[561710]
[561720]
[561730]
[561740]
[561790]
[561900]
[561910]
[561920]
[561990]
[562100]
[562110]
[562111]
[562112]
[562119]
[562200]
[562210]
[562211]
[562212]
[562213]
[562219]
[562900]
[562910]
[562920]
[562990]
[562991]
[562998]
[611100]
[611110]
[611200]
[611210]
[611300]
[611310]
[611400]
[611410]
[611420]
[611430]
[611500]
[611510]
[611511]
[611512]
[611513]
[611519]
[611600]
[611610]
[611620]
[611630]
[611690]
[611691]
[611692]
[611699]
[611700]
[611710]
[621100]
[621110]
[621111]
[621112]
[621200]
[621210]
[621300]
[621310]
[621320]
[621330]
[621340]
[621390]
[621391]
[621399]
[621400]
[621410]
[621420]
[621490]
[621491]
[621492]
[621493]
[621498]
[621500]
[621510]
[621511]
[621512]
[621600]
[621610]
[621900]
[621910]
[621990]
[621991]
[621999]
[622100]
[622110]
[622200]
[622210]
[622300]
[622310]
[623100]
[623110]
[623200]
[623210]
[623220]
[623300]
[623310]
[623311]
[623312]
[623900]
[623990]
[624100]
[624110]
[624120]
[624190]
[624200]
[624210]
[624220]
[624221]
[624229]
[624230]
[624300]
[624310]
[624400]
[624410]
[711100]
[711110]
[711120]
[711130]
[711190]
[711200]
[711210]
[711211]
[711212]
[711219]
[711300]
[711310]
[711320]
[711400]
[711410]
[711500]
[711510]
[712100]
[712110]
[712120]
[712130]
[712190]
[713100]
[713110]
[713120]
[713200]
[713210]
[713290]
[713900]
[713910]
[713920]
[713930]
[713940]
[713950]
[713990]
[721100]
[721110]
[721120]
[721190]
[721191]
[721199]
[721200]
[721210]
[721211]
[721214]
[721300]
[721310]
[722110]
[722211]
[722212]
[722213]
[722300]
[722310]
[722320]
[722330]
[722400]
[722410]
[722500]
[722510]
[722511]
[722513]
[722514]
[722515]
[811100]
[811110]
[811111]
[811112]
[811113]
[811118]
[811120]
[811121]
[811122]
[811190]
[811191]
[811192]
[811198]
[811200]
[811210]
[811211]
[811212]
[811213]
[811219]
[811300]
[811310]
[811400]
[811410]
[811411]
[811412]
[811420]
[811430]
[811490]
[812100]
[812110]
[812111]
[812112]
[812113]
[812190]
[812191]
[812199]
[812200]
[812210]
[812220]
[812300]
[812310]
[812320]
[812330]
[812331]
[812332]
[812900]
[812910]
[812920]
[812921]
[812922]
[812930]
[812990]
[813100]
[813110]
[813200]
[813210]
[813211]
[813212]
[813219]
[813300]
[813310]
[813311]
[813312]
[813319]
[813400]
[813410]
[813900]
[813910]
[813920]
[813930]
[813940]
[813990]