{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Qtrly. Summary (for IGB use)","Qtly Financial Sumry (for IGB)","Instructions","Chart of Accounts","Questionnaire","Financial Stmt Data Entry","Business Activity","Use Agreement Tracking","1st Qtr.","2nd Qtr.","3rd Qtr.","4th Qtr.","Annual Review","QrtlyGraphs","AnnualGraphs","Graph Data","Selected Disclosures","Shareholders Equity Recon","Debt Schedule","Available Financing","Accts Receivable","Accts Payable","Financial Stmt Change Log"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":27,"comments":3,"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":"Qtrly. Summary (for IGB use)","index":0,"n_rows":166,"n_cols":2,"rows_kept":166,"cut":false,"hidden":true,"merged":[]}
[null,"XYZ TERMINAL OPERATOR"]
[null,"QUARTELY FINANCIAL ANALYSIS SUMMARY"]
[]
[null,"FIRST QUARTER ENDED MARCH 31, 2013"]
[]
[null,"Number of new use agreements:        Signed     ______"]
[null,"Number of new locations:                  Installed   ______"]
[null,"Number of new machines:                 Intalled    ______  "]
[]
[null,"Changes in Ownership:   Name          % owned         Inv. Amt.      90-1 completed"]
[]
[]
[null,"New Debt/Financing:           Source           Type             Amount                   Terms"]
[]
[]
[]
[]
[null,"Results of Operations (Describe and explain major changes in revenue and expenses)"]
[]
[null,"Video Gaming:  XYZ's net terminal income increased x% from $------ to $------ due to x new "]
[null,"locations and xx machines going on line during the quarter.  Projections for the first quarter were "]
[null,"x locations and xx machines.  The difference between the projected results and actual is due to…."]
[null,"Video Gaming Cost of Sales was $------ for the quarter resulting in a Gross Profit from Video "]
[null,"Gaming of $----- or xx%."]
[null,"Amusement:  XYZ's amusement income increased x% from $----- to $---- for the quarter due "]
[null,"to ………  Amusement Cost of Sales was $----- for the quarter resulting in a Gross Profit from"]
[null,"Amusement of $----- or xx%"]
[null,"Other Income:  XYZ also had ATM income of $----- for the quarter with related expenses of "]
[null,"$----- for a gross profit of $-----."]
[null,"Operating Expenses:  (Describe and explain major changes in the various operating "]
[null,"expenses)  XYZ's operating expenses increased x% from $----- to $----- due to increases "]
[null,"in personnel and related expenses, and equipment leases of $------ and $-------, respectively."]
[null,"These increases were due to………"]
[null,"Interest Income/Expenses: (Describe and explain changes in interest income & expense)"]
[null,"Depreciation & Amortization: (Describe and explain changes in Depreciation & Amortization)"]
[null,"Other Income & Expenses: (Descrive and explain changes in Other Income & Expenses)"]
[]
[null,"Financial Condition (Descibe and explain major changes in balances from one quarter to another)"]
[null,"Total Assets at March 31, 2013 were $----- an increase of $----- over the prior quarter.  The increase is "]
[null,"primarily due to …….  Total Liabilites at March 31, 2013 were $------ an increas of $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  "]
[]
[]
[null,"SECOND QUARTER ENED JUNE 30, 2013"]
[]
[null,"Number of new use agreements:    Signed     ______"]
[null,"Number of new locations:                  Installed ______"]
[null,"Number of new machines:                 Intalled   ______  "]
[]
[null,"Changes in Ownership:         Name          % owned         Inv. Amt.      90-1 completed"]
[]
[]
[null,"New Debt/Financing:           Source           Type             Amount                   Terms"]
[]
[]
[]
[null,"Results of Operations (Describe and explain major changes in revenue and expenses)"]
[]
[null,"Video Gaming:  XYZ's net terminal income increased x% from $------ to $------ due to x new "]
[null,"locations and xx machines going on line during the quarter.  Projections for the first quarter were "]
[null,"x locations and xx machines.  The difference between the projected results and actual is due to…."]
[null,"Video Gaming Cost of Sales was $------ for the quarter resulting in a Gross Profit from Video "]
[null,"Gaming of $----- or xx%."]
[null,"Amusement:  XYZ's amusement income increased x% from $----- to $---- for the quarter due "]
[null,"to ………  Amusement Cost of Sales was $----- for the quarter resulting in a Gross Profit from"]
[null,"Amusement of $----- or xx%"]
[null,"Other Income:  XYZ also had ATM income of $----- for the quarter with related expenses of "]
[null,"$----- for a gross profit of $-----."]
[null,"Operating Expenses:  (Describe and explain major changes in the various operating "]
[null,"expenses)  XYZ's operating expenses increased x% from $----- to $----- due to increases "]
[null,"in personnel and related expenses, and equipment leases of $------ and $-------, respectively."]
[null,"These increases were due to………"]
[null,"Interest Income/Expenses: (Describe and explain changes in interest income & expense)"]
[null,"Depreciation & Amortization: (Describe and explain changes in Depreciation & Amortization)"]
[null,"Other Income & Expenses: (Descrive and explain changes in Other Income & Expenses)"]
[]
[null,"Financial Condition (Descibe and explain major changes in balances from one quarter to another)"]
[null,"Total Assets at March 31, 2013 were $----- an increase of $----- over the prior quarter.  The increase is "]
[null,"primarily due to …….  Total Liabilites at March 31, 2013 were $------ an increas of $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  "]
[]
[]
[null,"THIRD QUARTER ENDED SEPTEMBER 30,2012"]
[]
[null,"Number of new use agreements:    Signed     ______"]
[null,"Number of new locations:                  Installed ______"]
[null,"Number of new machines:                 Intalled   ______  "]
[]
[null,"Changes in Ownership:         Name          % owned         Inv. Amt.      90-1 completed"]
[]
[]
[null,"New Debt/Financing:           Source           Type             Amount                   Terms"]
[]
[]
[]
[null,"Results of Operations (Describe and explain major changes in revenue and expenses)"]
[]
[null,"Video Gaming:  XYZ's net terminal income increased x% from $------ to $------ due to x new "]
[null,"locations and xx machines going on line during the quarter.  Projections for the first quarter were "]
[null,"x locations and xx machines.  The difference between the projected results and actual is due to…."]
[null,"Video Gaming Cost of Sales was $------ for the quarter resulting in a Gross Profit from Video "]
[null,"Gaming of $----- or xx%."]
[null,"Amusement:  XYZ's amusement income increased x% from $----- to $---- for the quarter due "]
[null,"to ………  Amusement Cost of Sales was $----- for the quarter resulting in a Gross Profit from"]
[null,"Amusement of $----- or xx%"]
[null,"Other Income:  XYZ also had ATM income of $----- for the quarter with related expenses of "]
[null,"$----- for a gross profit of $-----."]
[null,"Operating Expenses:  (Describe and explain major changes in the various operating "]
[null,"expenses)  XYZ's operating expenses increased x% from $----- to $----- due to increases "]
[null,"in personnel and related expenses, and equipment leases of $------ and $-------, respectively."]
[null,"These increases were due to………"]
[null,"Interest Income/Expenses: (Describe and explain changes in interest income & expense)"]
[null,"Depreciation & Amortization: (Describe and explain changes in Depreciation & Amortization)"]
[null,"Other Income & Expenses: (Descrive and explain changes in Other Income & Expenses)"]
[]
[null,"Financial Condition (Descibe and explain major changes in balances from one quarter to another)"]
[null,"Total Assets at March 31, 2013 were $----- an increase of $----- over the prior quarter.  The increase is "]
[null,"primarily due to …….  Total Liabilites at March 31, 2013 were $------ an increas of $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  "]
[]
[]
[null,"FOURTH QUARTER ENDED DECEMBER 31, 2013"]
[]
[null,"Number of new use agreements:    Signed     ______"]
[null,"Number of new locations:                  Installed ______"]
[null,"Number of new machines:                 Intalled   ______  "]
[]
[null,"Changes in Ownership:         Name          % owned         Inv. Amt.      90-1 completed"]
[]
[]
[null,"New Debt/Financing:           Source           Type             Amount                   Terms"]
[]
[]
[]
[null,"Results of Operations (Describe and explain major changes in revenue and expenses)"]
[]
[null,"Video Gaming:  XYZ's net terminal income increased x% from $------ to $------ due to x new "]
[null,"locations and xx machines going on line during the quarter.  Projections for the first quarter were "]
[null,"x locations and xx machines.  The difference between the projected results and actual is due to…."]
[null,"Video Gaming Cost of Sales was $------ for the quarter resulting in a Gross Profit from Video "]
[null,"Gaming of $----- or xx%."]
[null,"Amusement:  XYZ's amusement income increased x% from $----- to $---- for the quarter due "]
[null,"to ………  Amusement Cost of Sales was $----- for the quarter resulting in a Gross Profit from"]
[null,"Amusement of $----- or xx%"]
[null,"Other Income:  XYZ also had ATM income of $----- for the quarter with related expenses of "]
[null,"$----- for a gross profit of $-----."]
[null,"Operating Expenses:  (Describe and explain major changes in the various operating "]
[null,"expenses)  XYZ's operating expenses increased x% from $----- to $----- due to increases "]
[null,"in personnel and related expenses, and equipment leases of $------ and $-------, respectively."]
[null,"These increases were due to………"]
[null,"Interest Income/Expenses: (Describe and explain changes in interest income & expense)"]
[null,"Depreciation & Amortization: (Describe and explain changes in Depreciation & Amortization)"]
[null,"Other Income & Expenses: (Descrive and explain changes in Other Income & Expenses)"]
[]
[null,"Financial Condition (Descibe and explain major changes in balances from one quarter to another)"]
[null,"Total Assets at March 31, 2013 were $----- an increase of $----- over the prior quarter.  The increase is "]
[null,"primarily due to …….  Total Liabilites at March 31, 2013 were $------ an increas of $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  Stockholders' Equity increased to $----- over the prior "]
[null,"quarter.  This increase is primarily due to ……..  "]

{"sheet":"Qtly Financial Sumry (for IGB)","index":1,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,0,0,12],[30,0,30,12]]}
["INCOME STATEMENT"]
[null,null,"1st Qtr",null,"2nd Qtr",null,"3rd qtr",null,"4th qtr",null,"Annual","Adjustments","Annual Financial Statement"]
["Video Gaming"]
["Gross Revenue (Funds In)"]
["Payouts (Funds Out)"]
["Credits"]
["Net Terninal income"]
["Cost of Sales"]
["   Gaming Tax"]
["   Admin fee (Sci Games)"]
["   Establishement Payout"]
["   TO Revenue Sharing Payout"]
["   Personnel"]
["   Equipment Leasing"]
["   Other cost of sales"]
["Total Cost of Sales"]
["     Gross Profit Video Gaming"]
["Amusement"]
["Amusement Income"]
["Amusement Cost of Sales"]
["     Gross Profit Amusement"]
["          Total Gross Profit"]
["Operating Expenses"]
["          EBITDAE"]
["Interest Income"]
["Interest Expense"]
["Depreciation /Amortization"]
["Other"]
["Net Income (Loss)"]
[]
["BALANCE SHEET"]
[null,null,"1st Qtr",null,"2nd Qtr",null,"3rd qtr",null,"4th qtr",null,"Annual","Adjustments","Annual Financial Statement"]
["Cash & Cash Equivalents"]
["Accounts Receivable"]
["Inventories"]
["Other Current Assets"]
["     Total Current Assets"]
["Property & Equipment, net"]
["Goodwill & Intangiblles"]
["Other Assets"]
["          Total Assets"]
[]
["Accounts Payable"]
["Current portion of L/T debt"]
["Revolving line of credit"]
["Other current liabilities"]
["     Total Current Liabilities"]
["Long-Term Debt"]
["Other Long-term Liabilities"]
["     Total Liabilities"]
["Capital Stock"]
["Distributions"]
["Retained Earnings"]
["     Total Stockholder Equity"]
["          Total Liabilities & Stockholder Equity "]
[]
["RATIOS"]
["Gross Profit Margin"]
["Profit Margin"]
["Debt Ratio"]
["Interest Coverage Ratio"]
["Liability Ratio"]
["Net Working Capital Ratio"]

{"sheet":"Instructions","index":2,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[[22,0,22,1],[4,0,4,1],[33,0,33,1]]}
[null,"Quarterly Reporting Template Instructions"]
[]
[null,"Last Template Update:  07/19/2021  -  OBTAIN BLANK TEMPLATE ONCE FOR NEW TERMINAL OPERATOR FIRST SUBMISSION-   FOR ALL SUBSEQUENT YEARS USE YOUR PRIOR YEAR TEMPLATE AND ROLL FORWARD FOR THE NEW YEAR PER INSTRUCTIONS BELOW."]
[]
["General Instructions:"]
["1.","Make sure you have enabled macros upon opening the excel workbook.    Depending on your excel security settings, you might see a Security Warning just below the toolbar when you open the file.   Click on Options and Enable this content."]
["2.","This workbook is to be completed and uploaded using the DUS system along with your YTD financial statements (including a cash flow statement and statement of equity, if available) as of the end of the quarter, YTD AP payment transactions and any other supporting documentation not already submitted to the IGB within 30 days following the quarter end (Q1, Q2 and Q3) and within 90 days following the year end (Q4).  Please refer to the DUS instructions for upload procedures. "]
["3.","Once a quarter is submitted, the expectation is that the quarter is now closed.   We would expect any financial statement adjustments related to a prior quarter in the current year to be made within the current open quarter.  (NOT to a prior period.)  If a change is related to a prior year, please use the Financial Stmt Change Log at the end of this workbook to log and explain the change that was made.  "]
["4.","Worksheet tabs which are colored in green are informational and do not require input."]
["5.","Certain worksheet cells have been locked to maintain the integrity of the formulas and links to other worksheets.   "]
["6.","Please do not use the 'Cut' and 'Paste' functions if you happen to enter something in the wrong cell.   This will compromise the formulas.   The 'Copy' and 'Paste' functions may be used with unprotected cells."]
["7.","The 'Financial Stmt Data Entry' worksheet is where you will enter financial statement information.   To assist in the classification on your line item entries, please refer to the Chart of Accounts tab for a description of each income statement and balance sheet line item.   We ask that you provide the financial statement data in the lowest level of detail possible based on the detailed financial statement line item descriptions.    Please make sure you identify and report the Current and Long Term Debt in each quarter.   This is required to accurately calculate certain ratios."]
["8.","For your first submission, we are requiring that you enter all historical data.    Each new year going forward (2017+), your template will require additional updating steps as indicated below.   When you are ready to complete the first quarter of a new year, you will need to follow these instructions first."]
["9.","Please enter all financial data rounded to the nearest whole dollar."]
["10.","When an entity includes both 'Video Gaming' and 'Amusement & Other' activity, we ask that you split the direct cost of sales expenses related to each revenue stream in order to calculate a true gross profit for each revenue stream."]
["11.","When completing the '4th Qtr' submission, you will also need to complete the 'Annual Review' worksheet tab."]
["12.","Worksheet tabs colored in blue require input.   Cells highlighted in pale yellow require input."]
["13.","While you are getting familiar with this workbook, it will be beneficial to enter information into the worksheets in the order in which they appear.   Certain cells are linked to other worksheets to prevent duplicate data entry.  In addition, there are check formulas in certain worksheets to ensure amounts are tied back to the financial statement data entry.   Note:  You must make sure the check balances are '0' prior to sending in your workbook.   If any out of balances exist, the workbook will need to be re-submitted with corrections."]
["14.","Please enter any requested dates in short format:   i.e. '12/31/15'.   This is to help maintain the integrity of dates used in certain formulas.  On the 'Use Agreement Tracking' tab do not use N/A or other text in date columns.  Date columns should contain a date or be blank."]
["15.","Printing Note for Use Agreement Tracking worksheet -   The Page Layout, Print Area has been set to print 1 page.  If you have more than 46 use agreements, please reset the Print Area to include all of the rows where you have input data.    "]
["16.","If you need to add rows to the Debt Schedule, Accounts Payable or Accounts Receivable worksheets, please do so within the yellow shaded area so that total formulas will automatically update.   Adjust print ranges if needed."]
[]
["Annual Updating Steps for years 2017 forward.  Perform these steps prior to data entry of Q1 in the new year:"]
["1.","Make sure you have enabled macros upon opening the excel workbook.    Depending on your excel security settings, you might see a Security Warning just below the toolbar when you open the file.   Click on Options and Enable this content."]
["2.","Save your file with the filename for the new quarter end."]
["3.","Execute macro - Ctrl+Shift+T.    Enter the current year on the Financial Stmt Data Entry worksheet in cell C5."]
["4.","On the Selected Disclosures worksheet tab, clear the shaded cells indicating Current Year Changes in Ownership, Related Party Transactions and Illinois Taxes.    The easiest way to do this is to highlight each sections yellow shaded rows and then hit the delete key."]
["5.","On the Debt Schedule worksheet tab, select the yellow shaded rows with data input within columns G to N and then hit the delete key."]
["6.","On the Available Financing worksheet, select the yellow shaded rows with data input in column E and then hit the delete key.  Repeat for columns G, I and K."]
["7.","On the Accts Receivable worksheet tab clear the prior year data.   Highlight each section of yellow shaded rows and then hit the delete key.  ie.  Highlight Q1 all yellow rows columns Customer and Industry, hit delete key.  Q1 Current through Explanation columns all yellow shaded rows, hit delete key.  Repeat process for remaining quarters."]
["8.","On the Accts Payable worksheet clear the prior year data.  Highlight each section of yellow shaded rows and then hit the delete key.  ie.  Highlight Q1 all yellow rows columns Vendor and Industry, hit delete key.  Q1 Current through Explanation columns all yellow shaded rows, hit delete key.  Repeat process for remaining quarters."]
["9.","On the Financial Stmt Change Log tab,  highlight any journal entries listed which are related to years no longer reported on the Financial Stmt Data Entry tab and hit the delete key."]
[]
["Suggestions:"]
[null,"Suggestions which may be helpful in completing the workbook."]
["1.","While it is not required, it may be helpful for you to restructure your financial statements in the same chart of accounts format we are requesting in this template."]
["2.","Treat the Use Agreement Tracking tab within this workbook as a daily live document for tracking that should be updated as you experience use agreement activities.  Updating this activity regularly will save time at the quarter end."]

{"sheet":"Chart of Accounts","index":3,"n_rows":154,"n_cols":4,"rows_kept":154,"cut":false,"hidden":false,"merged":[]}
["Uniform Chart of Accounts"]
[]
["Primary Financial Statement Category","Financial Statement Sub-category","Account Name","Account Description"]
["Current Asset ","Cash and Cash Equivalents","Cash on hand/Petty Cash","Currency and coin of the United States in hand."]
["Current Asset ","Cash and Cash Equivalents","Cash in bank","Currency and coin of the United States in banks."]
["Current Asset ","Cash and Cash Equivalents","Cash in Redemption Terminals","Currency and coin of the United States in redemption terminals funded by the terminal operator."]
["Current Asset ","Cash and Cash Equivalents","Cash in ATM's","Currency and coin of the United States in automatic teller machines funded by the terminal operator."]
["Current Asset ","Cash and Cash Equivalents","Cash in Video Gaming Terminals","Currency and coin of the United States in video gaming terminals at licensed establishments."]
["Current Asset ","Cash and Cash Equivalents","Cash in Amusement Machines","Currency and coin of the United States in amusement machines."]
["Current Asset ","Cash and Cash Equivalents","Marketable securities","Investments in common stock, preferred stock, corporate bonds, or government bonds that can be readily sold on a stock or bond exchange.  These investments are reported as a current asset if the investor's intention is to sell the securities within one year."]
["Current Asset ","Accounts Receivable","Accounts Receivable - Other","Miscellaneous amounts due to the terminal operator, such as loans to employees and/or shared expenses charged to the establishment."]
["Current Asset ","Accounts Receivable","Accounts Receivable - Other - Allowance for doubtful Accounts","The allowance for doubtful accounts provides for an estimated amount which by historical experience, or specific appraisal of the individual accounts, is likely to be uncollectible.  Accounts which become uncollectible should be charged to these accounts, and any recoveries of accounts previously written off should be credited to them."]
["Current Asset ","Other Receivables","Notes Receivable","A formal type of receivable usually evidenced by a signed promissory note.  If the note is not collectable within the current 12 month accounting cycle, it should be classified as a 'Non-Current Asset'."]
["Current Asset ","Other Receivables","Notes Receivable - Allowance for doubtful Accounts","The allowance for doubtful accounts provides for an estimated amount which by historical experience, or specific appraisal of the individual accounts, is likely to be uncollectible.  "]
["Current Asset ","Other Receivables","Loans Receivable from Affiliated Companies","Amounts due to the terminal operator from related entities."]
["Current Asset ","Other Receivables","Accrued Interest Receivable","Accrued interest on notes/loans receivable due in the next 12 months."]
["Current Asset ","Prepaids","Prepaid Expenses","Prepayments on items such as insurance, rent and advertising that have been prepaid beyond this financial period."]
["Current Asset ","Inventory","Video Gaming Terminals - Work in Progress and Finished Goods","Deposits on video gaming terminals and video gaming terminals not placed in service."]
["Current Asset ","Inventory","Video Gaming Terminal - Spare Parts","Video Gaming Terminal parts not placed in service."]
["Current Asset ","Other Current Assets","Other Current Assets","Other current assets not specifically included in previous accounts."]
["Non-Current Assets","Long-Term Investments","Long-Term Investments","Long-term investments in securities or shares in listed and unlisted companies not expected to be realized in the next 12  months.  "]
["Non-Current Assets","Fixed Assets, net of Depreciation","Land and Improvements","Land and improvements such as paved parking lots, streets and sidewalks, lighting and drainage which are shown at cost, impaired value or revalued amount.  "]
["Non-Current Assets","Fixed Assets, net of Depreciation","Construction in Progress","Cost of a building prior to completion."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Buildings and improvements","Buildings and improvements including cost of constructing, purchasing or improving buildings."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Leasehold Improvements","Cost of improvements to leased property used by the business."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Furniture and Fixtures","Cost of all the office furniture and equipment (including computers and software) used in the conduct of business."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Gaming Equipment","Video gaming terminals, redemption terminals, ATM's and currency counting equipment owned by the terminal operator."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Automobiles","Cost of automobiles purchased for use in the course of business."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Other Fixed Assets","Fixed assets not included in the other categories described above."]
["Non-Current Assets","Fixed Assets, net of Depreciation","Accumulated Depreciation","Accumulated depreciation on fixed assets placed in service."]
["Non-Current Assets","Long-Term Notes Receivable","Notes Receivable","A formal type of receivable usually evidenced by a signed promissory note.  If the note is not collectable within the current 12 month accounting cycle, it should be classified as 'Non-Current - Asset'."]
["Non-Current Assets","Long-Term Notes Receivable","Notes Receivable - Allowance for doubtful Accounts","The allowance for doubtful accounts provides for an estimated amount which by historical experience, or specific appraisal of the individual accounts, is likely to be uncollectible.  "]
["Non-Current Assets","Intangibles, net of Amortization","Start Up/Organization Costs","The costs of checking out the various factors involved in site selection and the costs of creating a business include advertising, wages and salaries, professional and consultant fees.   Adjusted for impairment as needed."]
["Non-Current Assets","Intangibles, net of Amortization","Customer Contracts","Cost of use agreements purchased from another terminal operator.  Adjusted for impairment as needed."]
["Non-Current Assets","Intangibles, net of Amortization","Goodwill","The value of goodwill - the excess of the purchase price of a company over its book value.  Adjusted for impairment as needed."]
["Non-Current Assets","Intangibles, net of Amortization","Deferred Financing Costs","Debt issuance costs such as fees and commissions paid to investment banks, law firms, auditors and regulators which are capitalized and amortized over the life of the underlying debt instrument.  This account can also be used for the present value of maitenance contracts associated with capital leases and amortized over the life of the lease."]
["Non-Current Assets","Intangibles, net of Amortization","Amortization of Intangibles","Amortization of intangible assets, excluding goodwill."]
["Non-Current Assets","Other Non-Current Assets","Security Deposits","Rent or utility deposits which will be returned at an undetermined future date."]
["Non-Current Assets","Other Non-Current Assets","Other Non-Current Assets","Any other non-current assets not described above and not be collected or sold in the next 12 months."]
["Current Liabilities","Current Portion of Long-Term Debt","Current Portion of 3rd Party Long-Term Debt","Loans payable to 3rd party creditors within the next 12 months."]
["Current Liabilities","Current Portion of Long-Term Debt","Current Portion of Loans Payable to Owner","Loans with owners payable within the next 12 months."]
["Current Liabilities","Current Portion of Long-Term Debt","Current Portion of Affiliated Entity Loan","Loans with affiliated companies payable within the next 12 months."]
["Current Liabilities","Current Portion of Long-Term Debt","Current Portion of Capital Leases","Capital lease payments due within the next 12 months considered to have the economic characteristics of asset ownership. A capital lease would be considered a purchased asset for accounting purposes. A lease falls into this category if any of the following requirements are met:\n1. The life of the lease is 75% or greater of the assets useful life. \n2. The lease contains a purchase agreement for less than market value.\n3. The lessee gains ownership at the end of the lease period.\n4. The present value of lease payments is greater than 90% of the asset's market value.\n"]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accounts Payable","The accounts payable owing to trade creditors or suppliers which have been processed but not yet paid at the end of the reporting period."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Accounts Payable","The accounts payable owing to trade creditors or suppliers which have not been processed or have not been invoiced and/or entered into the accounts payable system at the end of the reporting period."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Cash Out Vouchers Payable","Payable for cash out vouchers which have not been redeemed."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Payroll ","The wages payable to employees at the end of the reporting period."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Vacation/Personal Days/Sick Days","The wages payable to employees for vacation, personal days and sick days at the end of the reporting period which have not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Payroll Taxes","The payroll taxes payable at the end of the reporting period which have not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Payroll Taxes","The 401-K/Pension and health insurance payable at the end of the reporting period which have not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Gaming Taxes","The gaming taxes payable at the end of the reporting period which have not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Income Taxes","The income taxes payable at the end of the reporting period which have not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Revenue Share","The revenue share due to establishments at the end of the reporting period which has not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Administration  Fee - Scientific Games","The administrative fee due to Scientific Games payable at the end of the reporting period which has not been invoiced or paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Professional Fees","Costs of professional services including legal and accounting which have been incurred, but not yet invoiced."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Interest Payable","The interest expense incurred, but not yet paid on loans payable."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Accrued Commissions","Commissions earned during the reporting period but have not been paid."]
["Current Liabilities","Accounts Payable & Accrued Liabilities","Other Accrued Liabilities","Expenses payable within 12 months not accounted for in the above accounts - accrual of real estate taxes,  sales taxes, etc…  Expenses incurred but not yet invoiced or paid as part of a quarterly, bi-annual or annual filing/billing period."]
["Current Liabilities","Other Current Liabilities","Current Portion of Deferred Income Tax","The amount of deferred income taxes related to current assets."]
["Current Liabilities","Other Current Liabilities","Other Current Liabilities","Other current liabilities not mentioned above."]
["Non-Current Liabilities","Long-Term Debt","Long-Term Debt, 3rd Party","Loans payable to 3rd party creditors not payable within the next 12 months."]
["Non-Current Liabilities","Long-Term Debt","Long-Term Debt, Loans Payable to Owners","Loans payable to owners not payable within the next 12 months."]
["Non-Current Liabilities","Long-Term Debt","Long-Term Debt, Loans Payable to Affiliated Entities","Loans payable to affiliated entities not payable within the next 12 months."]
["Non-Current Liabilities","Long-Term Debt","Capital Leases","Amounts not payable within the next 12 months for a capital lease considered to have the economic characteristics of asset ownership. A capital lease would be considered a purchased asset for accounting purposes. A lease falls into this category if any of the following requirements are met:\n1. The life of the lease is 75% or greater of the assets useful life. \n2. The lease contains a purchase agreement for less than market value.\n3. The lessee gains ownership at the end of the lease period.\n4. The present value of lease payments is greater than 90% of the asset's market value.\n"]
["Non-Current Liabilities","Other Long-Term Liabilities","Deferred Income Tax","The portion of income tax expense that will be paid in future years."]
["Non-Current Liabilities","Other Long-Term Liabilities","Other Long-Term Liabilities","Other long-term liabilities not accounted for in the above accounts."]
["Equity","Capital","Common Stock","Securities representing equity ownership in a corporation."]
["Equity","Capital","Preferred Stock","Securities representing equity ownership in a corporation, have a specific dividend that is paid before any dividends are paid to common stockholders and which takes precedence over common stock in the event of a liquidation."]
["Equity","Capital","Additional Paid In Capital","Stockholder contributions that are in excess of a stock's stated or par value."]
["Equity","Capital","Member Capital","Investments provided by or distributions to owning members in a partnership or sole proprietorship.  This also can include prior years retaineded earnings which is sometimes rolled into member capital each year end."]
["Equity","Retained Earnings","Retained Earnings","Cumulative total of prior period (s) net income (loss) for corporations or partnership prior to rolling retained earnings into member capital at year end."]
["Equity","Retained Earnings","Net Income (Loss)","Current period's net income or loss."]
["Revenue","Video Gaming Revenue","Funds In","Cash put in to video gaming terminals by players."]
["Revenue","Video Gaming Revenue","Funds Out","Credits paid out to video gaming terminal players."]
["Revenue","Amusement & Other Revenue","Amusement Revenue","Revenue earned from amusements machines."]
["Revenue","Amusement & Other Revenue","ATM Fee Income","Amounts earned from ATM transactions."]
["Revenue","Amusement & Other Revenue","Rental Income","Amounts earned from rental of property or equipment."]
["Revenue","Amusement & Other Revenue","Other Operating Revenue","Other amounts earned in the normal course of business not described in the accounts above."]
["Cost of Sales - Video Gaming","Gaming Tax","Gaming Tax","The 30% gaming tax imposed on the net terminal income earned by terminal operators."]
["Cost of Sales - Video Gaming","Revenue Share","Establishment Revenue Share - Video Gaming","The 35% share of net terminal income due to establishments."]
["Cost of Sales - Video Gaming","Revenue Share","Other Revenue Share Agreements","Amounts paid to a revenue sharer as per a contract with the terminal operator."]
["Cost of Sales - Video Gaming","Gaming Administrative Fee","Gaming Administrative Fee","The .7275% of net terminal income due to Scientific Games."]
["Cost of Sales - Video Gaming","Equipment Lease Expense","Equipment Lease Expense","Any operating lease expense for gaming equipment."]
["Cost of Sales - Video Gaming","Field Payroll and Contract Labor","Field /Direct Wages and Salaries Expense","Any direct employee payroll expenses such as Terminal Handlers and Terminal Technicians."]
["Cost of Sales - Video Gaming","Field Payroll and Contract Labor","Field/Direct Payroll Taxes","Any direct employee payroll tax expenses such as Terminal Handlers and Terminal Technicians."]
["Cost of Sales - Video Gaming","Field Payroll and Contract Labor","Field/Direct - Employee Benefits","Any direct employee benefits expenses."]
["Cost of Sales - Video Gaming","Field Payroll and Contract Labor","Operating Contract Labor","Any direct outside labor expenses for contracted Terminal Handlers and Terminal Technicians."]
["Cost of Sales - Video Gaming","Vehicle and Equipment Maintenance","VGT Parts and Maintenance Expense","Any parts and outside labor expensed for repair and maintenance of video gaming terminals."]
["Cost of Sales - Video Gaming","Vehicle and Equipment Maintenance","Fuel Expense","Fuel for vehicles used to maintain the slot route operations."]
["Cost of Sales - Video Gaming","Vehicle and Equipment Maintenance","Vehicle Maintenance","Maintenance costs for vehicles used to maintain the slot route operations."]
["Cost of Sales - Video Gaming","Vehicle and Equipment Maintenance","Vehicle Lease Expense","Lease expense for vehicles used to maintain the slot route operations."]
["Cost of Sales - Video Gaming","Other Direct Operating Costs","Redemption Machine Services","Charges for outside servicing of redemption machines."]
["Cost of Sales - Video Gaming","Other Direct Operating Costs","Shared Expenses","Credits and debits for shared cost of sales expenses charged to/from establishments and terminal operators. For example, terminal operators pay Scientific Games administrative fee at full expense.  A second entry would be booked to record a receivable from the establishment and credit Shared Expenses."]
["Cost of Sales - Video Gaming","Other Direct Operating Costs","License Fees","All license fees for operating video gaming businesses and machines."]
["Cost of Sales - Video Gaming","Other Direct Operating Costs","Other Direct Operating Expenses - Video Gaming","Other direct operating expenses for video gaming not specifically named above."]
["Cost of Sales - Amusement & Other","Amusement Operating Purchases","Amusement Prizes","Prizes purchased for amusement machines."]
["Cost of Sales - Amusement & Other","Amusement Operating Purchases","Amusement Music","Music purchased for amusement machines."]
["Cost of Sales - Amusement & Other","Cost of Sales - Amusement","Establishment Revenue Share - Amusement","Establishment share of amusement revenues."]
["Cost of Sales - Amusement & Other","Field Payroll and Contract Labor","Field /Direct Wages and Salaries Expense","Any direct employee payroll expenses servicing amusement machines."]
["Cost of Sales - Amusement & Other","Field Payroll and Contract Labor","Field/Direct Payroll Taxes","Any direct employee payroll tax expenses servicing amusement machines."]
["Cost of Sales - Amusement & Other","Field Payroll and Contract Labor","Field/Direct - Employee Benefits","Any direct employee benefits expense related to amusement machines."]
["Cost of Sales - Amusement & Other","Field Payroll and Contract Labor","Operating Contract Labor","Any direct outside labor expenses for contracted amusement machine handlers."]
["Cost of Sales - Amusement & Other","Vehicle and Equipment Maintenance","Amusement Parts and Maintenance Expense","Any parts and outside labor expensed for repair and maintenance of amusement games."]
["Cost of Sales - Amusement & Other","Vehicle and Equipment Maintenance","Fuel Expense","Fuel for vehicles used to maintain the amusement route operations."]
["Cost of Sales - Amusement & Other","Vehicle and Equipment Maintenance","Vehicle Maintenance","Maintenance costs for vehicles used to maintain the amusement route operations."]
["Cost of Sales - Amusement & Other","Vehicle and Equipment Maintenance","Vehicle Lease Expense","Lease expense for vehicles used to maintain the amusement operations."]
["Cost of Sales - Amusement & Other","Other Direct Operating Costs","Shared Expenses","Credits and debits for shared cost of sales expenses charged to/from establishments related to amusement machines. "]
["Cost of Sales - Amusement & Other","Other Direct Operating Costs","ATM Fee Services","Charges for outside servicing of ATM machines."]
["Cost of Sales - Amusement & Other","Other Direct Operating Costs","License Fees","All license fees for operating amusement businesses and machines."]
["Cost of Sales - Amusement & Other","Other Direct Operating Costs","Other Direct Operating Expenses - Amusement","Other direct operating expenses for amusement machines not mentioned above."]
["General & Administrative Expenses","Sales & Marketing Expenses","Sales Wages and Salaries Expense","Payroll for employees engaged in sales activities."]
["General & Administrative Expenses","Sales & Marketing Expenses","Sales Payroll taxes","Sales employee payroll taxes."]
["General & Administrative Expenses","Sales & Marketing Expenses","Sales - Employee Benefits","Any sales employee benefits expense."]
["General & Administrative Expenses","Sales & Marketing Expenses","Sales Contract Labor","Any sales outside labor expenses for contracted sales employees."]
["General & Administrative Expenses","Sales & Marketing Expenses","Sales Commissions","Any commissions or bonus paid as incentives for sales activities."]
["General & Administrative Expenses","Sales & Marketing Expenses","Promotional Supplies","Supplies purchased for advertising and sales activities."]
["General & Administrative Expenses","Sales & Marketing Expenses","Advertising Expense","Costs of advertisements."]
["General & Administrative Expenses","Sales & Marketing Expenses","Marketing - Outside Services","3rd parties engaged for advertising consulting activities."]
["General & Administrative Expenses","Sales & Marketing Expenses","Sales & Marketing - Other","Other expenses for sales and marketing not mentioned above."]
["General & Administrative Expenses","Travel & Entertainment Expenses","Transportation Expenses","Cost of airfare, taxi, tolls and mileage reimbursement incurred during business travel."]
["General & Administrative Expenses","Travel & Entertainment Expenses","Lodging","Cost of lodging expenses incurred during business travel."]
["General & Administrative Expenses","Travel & Entertainment Expenses","Meals & Entertainment Expense","Cost of meals and entertainment expenses incurred during business travel."]
["General & Administrative Expenses","Travel & Entertainment Expenses","Parking","Cost of parking incurred during business travel."]
["General & Administrative Expenses","Travel & Entertainment Expenses","Travel & Entertainment - Other","Any travel and entertainment expense not described above."]
["General & Administrative Expenses","Professional Fees","Legal Fees","Professional fees for legal services."]
["General & Administrative Expenses","Professional Fees","Accounting Fees","Professional fees for accounting and payroll services."]
["General & Administrative Expenses","Professional Fees","Professional Fees - Other","Other professional fees not mentioned above."]
["General & Administrative Expenses","Building & Maintenance Expenses","Utilities","Amounts related to office utilities - water, sewer, gas and electric."]
["General & Administrative Expenses","Building & Maintenance Expenses","Rent Expense","Any lease/rent expense incurred for office space, warehouse space and or machinery needed to run the administrative offices."]
["General & Administrative Expenses","Building & Maintenance Expenses","Property Taxes","Real estate taxes on property."]
["General & Administrative Expenses","Building & Maintenance Expenses","Other Building Maintenance Expenses","Office cleaning, garbage pick up, security, pest control, outside services for lawn care or other property maintenance fees."]
["General & Administrative Expenses","Other General & Administrative Expenses","Management & Office Wages and Salaries Expense","Employee payroll for managers and other general and administrative employees."]
["General & Administrative Expenses","Other General & Administrative Expenses","Management & Office Payroll Taxes","Employee payroll taxes for managers and other general and administrative employees."]
["General & Administrative Expenses","Other General & Administrative Expenses","Management & Office Employee Benefits","Employee benefits expense for managers and other general and administrative employees."]
["General & Administrative Expenses","Other General & Administrative Expenses","Management & Office Contract Labor","Any outside labor hired to function as management or to perform office services."]
["General & Administrative Expenses","Other General & Administrative Expenses","Office Supplies","Any expense for supplies needed to run the administrative offices."]
["General & Administrative Expenses","Other General & Administrative Expenses","Bank Service Fees","Any service fees charged by banks."]
["General & Administrative Expenses","Other General & Administrative Expenses","License Fees","Non Gaming related license fees.  "]
["General & Administrative Expenses","Other General & Administrative Expenses","Dues and Subscriptions","Dues and subscriptions for professional memberships and/or magazines."]
["General & Administrative Expenses","Other General & Administrative Expenses","Political Contributions","Amounts donated to political campaigns."]
["General & Administrative Expenses","Other General & Administrative Expenses","Charitable Contributions","Amounts donated to charitable organizations."]
["General & Administrative Expenses","Other General & Administrative Expenses","Insurance Expense","Liability and workmen's compensation insurance expenses."]
["General & Administrative Expenses","Other General & Administrative Expenses","Postage and Delivery Expense","Cost of postage and express delivery services."]
["General & Administrative Expenses","Other General & Administrative Expenses","Telephone and Data charges","Cost of telephone and internet services."]
["General & Administrative Expenses","Other General & Administrative Expenses","Other Miscellaneous Expenses","Miscellaneous other general and administrative expenses."]
["Other Non-Operating Income","Other Non-Operating Income","Other Non-Operating Income","Income not related to the operations of video or amusement gaming."]
["Interest Income","Interest Income","Interest Income","Interest earned on interest bearing instruments."]
["Interest Expense","Interest Expense","Interest Expense","Interest expense incurred on debt instruments."]
["Income Taxes","Income Taxes","Income Taxes","Provision for federal and state income taxes."]
["Amortization Expense","Amortization Expense","Amortization Expense","Amortization of intangible assets."]
["Deprecation Expense","Depreciation Expense","Depreciation Expense","Depreciation expense on fixed assets."]
["Other Gains (Losses) - (Net of Taxes)","Other Gains (Losses) - (Net of Taxes)","Gain (Loss) on Sale of Fixed Assets","Gain or loss on sale of fixed assets."]
["Other Gains (Losses) - (Net of Taxes)","Other Gains (Losses) - (Net of Taxes)","Gain (Loss) on Discontinued Operations","Gain or loss on discontinued operations."]
["Other Gains (Losses) - (Net of Taxes)","Other Gains (Losses) - (Net of Taxes)","Other Non Operating Gains (Losses)","Gains or losses on non-operating activities not described above."]

{"sheet":"Questionnaire","index":4,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[19,1,19,3],[0,0,0,8],[1,0,1,8],[3,0,3,8],[15,2,15,3],[18,1,18,3]]}
["Type Terminal Operator Name and License # Here"]
["Questionnaire"]
[]
["Please complete the following questionnaire.  If changes occur from a prior quarterly submission, update accordingly."]
[]
[]
[]
["1.  The financial statements presented in this workbook use the:"]
[]
[null,null,"Cash Method for gaming, accrual method for other than gaming"]
[null,null,"Cash Method"]
[null,null,"Accrual Method"]
[null,null,"Income Tax "]
[null,null,"Modified Accrual"]
[null,null,"Other (please describe below)"]
[]
[]
["2.  What accounting software do you use to prepare your financial information?"]
[]
[]
[]
["3.  To whom should inquiries for additional information be directed? "]
[]
[null,null,"Name"]
[null,null,"Position"]
[null,null,"Email"]
[null,null,"Address"]
[null,null,"Phone "]
[]
["4.  Independent accountants:  (if None incicated \"None\" on Firm Name Line)"]
[]
[null,null,"Firm Name"]
[null,null,"Contact"]
[null,null,"Position"]
[null,null,"Address"]
[null,null,"Phone"]
[]
["5.  Please enter your video gaming 'go live' date."]

{"sheet":"Financial Stmt Data Entry","index":5,"n_rows":257,"n_cols":12,"rows_kept":257,"cut":false,"hidden":false,"merged":[[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,10,4,10],[3,11,4,11],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9]]}
[{"$f":"+Questionnaire!A1","v":"Type Terminal Operator Name and License # Here"}]
[null,"Date of Financial Statement Run:"]
[]
[null,null,2021,{"$f":"\"Q4 \"& +C4","v":"Q4 2021"},{"$f":"\"Q3 \"& +C4","v":"Q3 2021"},{"$f":"\"Q2 \"& +C4","v":"Q2 2021"},{"$f":"\"Q1 \"& +C4","v":"Q1 2021"},{"$f":"\"Q4 \"& +I4","v":"Q4 2020"},{"$f":"+C4-1","v":2020},{"$f":"+I4-1","v":2019},{"$f":"+J4-1","v":2018},{"$f":"+K4-1","v":2017}]
[]
[null,"# of VGT's live at the end of the period",{"$f":"+D6","v":0},null,null,null,null,{"$f":"+I6","v":0}]
[]
["Detailed Income Statement"]
["Revenue"]
[null,"Video Gaming Revenue"]
[null,"   Funds In",{"$f":"SUM(D11:G11)","v":0},null,null,null,0,0,0]
[null,"   Funds Out",{"$f":"SUM(D12:G12)","v":0},null,null,null,null,null,0]
[null,"      Net Terminal Income",{"$f":"+C11-C12","v":0},{"$f":"+D11-D12","v":0},0,0,0,0,0,{"$f":"+J11-J12","v":0},0,0]
[]
[null,"Amusement & Other Revenue"]
[null,"  Amusement Revenue",{"$f":"SUM(D16:G16)","v":0},null,null,null,null,null,0]
[null,"  ATM Fee Income",0,null,null,null,null,null,0]
[null,"  Rental Income",0,null,null,null,null,null,0]
[null,"  Other Operating Revenue",0,null,null,null,null,null,0]
[null,"     Total Amusement & Other Revenue",{"$f":"SUM(C16:C19)","v":0},0,0,0,{"$f":"SUM(G16:G19)","v":0},0,0,{"$f":"SUM(J16:J19)","v":0},0,0]
[]
[null,"          Total Revenue",{"$f":"+C20+C13","v":0},{"$f":"+D20+D13","v":0},0,0,{"$f":"+G20+G13","v":0},0,0,{"$f":"+J20+J13","v":0},0,0]
[]
["Cost of Sales Video Gaming"]
[null,"Gaming Tax",{"$f":"SUM(D25:G25)","v":0},null,null,null,null,null,0]
[null,"Establishment Revenue Share",0,null,null,null,null,null,0]
[null,"Other Revenue Share Agreements",0,null,null,null,null,null,0]
[null,"Gaming Administrative Fee",0,null,null,null,null,null,0]
[null,"Equipment Lease Expense",0,null,null,null,null,null,0]
[null,"Field /Direct Wages and Salaries Expense",0,null,null,null,null,null,0]
[null,"Field/Direct Payroll Taxes",0,null,null,null,null,null,0]
[null,"Field/Direct - Employee Benefits",0,null,null,null,null,null,0]
[null,"Operating Contract Labor",0,null,null,null,null,null,0]
[null,"VGT Parts and Maintenance Expense",0,null,null,null,null,null,0]
[null,"Fuel Expense",0,null,null,null,null,null,0]
[null,"Vehicle Maintenance",0,null,null,null,null,null,0]
[null,"Vehicle Lease Expense",0,null,null,null,null,null,0]
[null,"Redemption Machine Services",0,null,null,null,null,null,0]
[null,"Shared Expenses",0,null,null,null,null,null,0]
[null,"License Fees",{"$f":"SUM(D40:G40)","v":0},null,null,null,null,null,0]
[null,"Other Direct Operating Costs",0,null,null,null,null,null,0]
[null,"  Total Cost of Sales Video Gaming",{"$f":"SUM(C25:C41)","v":0},0,0,0,{"$f":"SUM(G25:G41)","v":0},0,0,{"$f":"SUM(J25:J41)","v":0},0,0]
[]
["Cost of Sales Amusement & Other"]
[null,"Amusement Prizes",{"$f":"SUM(D45:G45)","v":0},null,null,null,null,null,0]
[null,"Amusement Music",0,null,null,null,null,null,0]
[null,"Establishment Revenue Share",0,null,null,null,null,null,0]
[null,"Field /Direct Wages and Salaries Expense",0,null,null,null,null,null,0]
[null,"Field/Direct Payroll Taxes",0,null,null,null,null,null,0]
[null,"Field/Direct - Employee Benefits",0,null,null,null,null,null,0]
[null,"Operating Contract Labor",0,null,null,null,null,null,0]
[null,"Amusement Parts and Maintenance Expense",0,null,null,null,null,null,0]
[null,"Fuel Expense",0,null,null,null,null,null,0]
[null,"Vehicle Maintenance",0,null,null,null,null,null,0]
[null,"Vehicle Lease Expense",0,null,null,null,null,null,0]
[null,"Shared Expenses",0,null,null,null,null,null,0]
[null,"ATM Fee Services",0,null,null,null,null,null,0]
[null,"License Fees",{"$f":"SUM(D58:G58)","v":0},null,null,null,null,null,0]
[null,"Other Direct Operating Costs",0,null,null,null,null,null,0]
[null,"  Total Cost of Sales Amusement & Other",{"$f":"SUM(C45:C59)","v":0},0,0,0,0,{"$f":"SUM(H45:H59)","v":0},0,{"$f":"SUM(J45:J59)","v":0},0,0]
[]
[null,"          Total Cost of Sales",{"$f":"+C60+C42","v":0},{"$f":"+D60+D42","v":0},0,0,0,0,0,{"$f":"+J60+J42","v":0},0,0]
[]
[null,"Gross Profit Terminal Operator",{"$f":"+C13-C42","v":0},{"$f":"+D13-D42","v":0},0,0,0,0,0,{"$f":"+J13-J42","v":0},0,0]
[]
[null,"Gross Profit Amusement & Other",{"$f":"+C20-C60","v":0},{"$f":"+D20-D60","v":0},0,0,0,0,0,{"$f":"+J20-J60","v":0},0,0]
[]
[null,"          Total Gross Profit",{"$f":"+C66+C64","v":0},{"$f":"+D66+D64","v":0},0,0,0,0,0,{"$f":"+J66+J64","v":0},0,0]
[]
["General & Administrative Expense:"]
["  Sales & Marketing Expense"]
[null,"Sales Wages and Salaries Expense",{"$f":"SUM(D72:G72)","v":0},null,null,null,null,null,0]
[null,"Sales Payroll taxes",0,null,null,null,null,null,0]
[null,"Sales - Employee Benefits",0,null,null,null,null,null,0]
[null,"Sales Contract Labor",0,null,null,null,null,null,0]
[null,"Sales Commissions",0,null,null,null,null,null,0]
[null,"Promotional Supplies",0,null,null,null,null,null,0]
[null,"Advertising Expense",0,null,null,null,null,null,0]
[null,"Marketing - Outside Services",0,null,null,null,null,null,0]
[null,"Sales & Marketing - Other",0,null,null,null,null,null,0]
[null,"  Total Sales & Marketing Expense",{"$f":"SUM(C72:C80)","v":0},0,0,0,{"$f":"SUM(G72:G80)","v":0},0,0,{"$f":"SUM(J72:J80)","v":0},0,0]
[]
["  Travel & Entertainment Expense"]
[null,"Transportation Expenses",{"$f":"SUM(D84:G84)","v":0},null,null,null,null,null,0]
[null,"Lodging",0,null,null,null,null,null,0]
[null,"Meals & Entertainment Expense",0,null,null,null,null,null,0]
[null,"Parking",0,null,null,null,null,null,0]
[null,"Travel & Entertainment - Other",0,null,null,null,null,null,0]
[null,"  Total Travel & Entertainment Expense",{"$f":"SUM(C84:C88)","v":0},{"$f":"SUM(D84:D88)","v":0},0,0,{"$f":"SUM(G84:G88)","v":0},0,0,{"$f":"SUM(J84:J88)","v":0},0,0]
[]
["  Professional Fees"]
[null,"Legal Fees",{"$f":"SUM(D92:G92)","v":0},null,null,null,null,null,0]
[null,"Accounting Fees",0,null,null,null,null,null,0]
[null,"Professional Fees - Other",0,null,null,null,null,null,0]
[null,"  Total Professional Fees",{"$f":"SUM(C92:C94)","v":0},0,0,0,{"$f":"SUM(G92:G94)","v":0},0,0,{"$f":"SUM(J92:J94)","v":0},0,0]
[]
["  Building & Maintenance Expense"]
[null,"Utilities",{"$f":"SUM(D98:G98)","v":0},null,null,null,null,null,0]
[null,"Rent Expense",0,null,null,null,null,null,0]
[null,"Property Taxes",0,null,null,null,null,null,0]
[null,"Other Building Maintenance Expenses",0,null,null,null,null,null,0]
[null,"  Total Building & Maintenance Expense",{"$f":"SUM(C98:C101)","v":0},{"$f":"SUM(D98:D101)","v":0},0,0,{"$f":"SUM(G98:G101)","v":0},0,0,{"$f":"SUM(J98:J101)","v":0},0,0]
[]
["  Other General & Administrative Expense"]
[null,"Management & Office Wages & Salaries Expense",{"$f":"SUM(D105:G105)","v":0},null,null,null,null,null,0]
[null,"Management & Office Payroll Taxes",0,null,null,null,null,null,0]
[null,"Management & Office Employee Benefits",0,null,null,null,null,null,0]
[null,{"$f":"+'Chart of Accounts'!C135","v":"Management & Office Contract Labor"},{"$f":"SUM(D108:G108)","v":0},null,null,null,null,null,0]
[null,"Office Supplies",0,null,null,null,null,null,0]
[null,"Bank Service Fees",0,null,null,null,null,null,0]
[null,"License Fees",0,null,null,null,null,null,0]
[null,"Dues and Subscriptions",0,null,null,null,null,null,0]
[null,"Political Contributions",0,null,null,null,null,null,0]
[null,"Charitable Contributions",0,null,null,null,null,null,0]
[null,"Insurance Expense",0,null,null,null,null,null,0]
[null,"Postage and Delivery Expense",0,null,null,null,null,null,0]
[null,"Telephone and Data charges",0,null,null,null,null,null,0]
[null,"Other Miscellaneous Expenses",0,null,null,null,null,null,0]
[null,"    Total Other General & Administrative Expense",{"$f":"SUM(C105:C118)","v":0},{"$f":"SUM(D105:D118)","v":0},0,0,0,{"$f":"SUM(H105:H118)","v":0},0,{"$f":"SUM(J105:J118)","v":0},0,0]
[null,"          Total General & Administrative Expense",{"$f":"+C119+C102+C95+C89+C81","v":0},{"$f":"+D119+D102+D95+D89+D81","v":0},0,0,0,0,0,{"$f":"+J119+J102+J95+J89+J81","v":0},0,0]
[]
[null,"Operating Income (Loss)",{"$f":"+C68-C120","v":0},{"$f":"+D68-D120","v":0},0,0,0,0,0,{"$f":"+J68-J120","v":0},0,0]
[]
["Other Non Operating Income"]
[]
[null,"EBITDAE",{"$f":"+C124+C122","v":0},{"$f":"+D124+D122","v":0},0,0,0,{"$f":"+H124+H122","v":0},0,{"$f":"+J124+J122","v":0},0,0]
[]
["Interest Income",null,{"$f":"SUM(D128:G128)","v":0},null,null,null,null,null,0]
["Interest Expense",null,0,null,null,null,null,null,0]
["Income Taxes",null,0,null,null,null,null,null,0]
["Depreciation Expense",null,0,null,null,null,null,null,0]
["Amortization Expense",null,0,null,null,null,null,null,0]
["Gain (Loss) on Sale of Fixed Assets",null,0,null,null,null,null,null,0]
["Gain (Loss) on Discontinued Operations",null,0,null,null,null,null,null,0]
["Other Non Operating Gains (Losses)",null,0,null,null,null,null,null,0]
[null,"Net Income (Loss)",{"$f":"+C126+C128-C129-C130-C131-C132+C133+C134+C135","v":0},{"$f":"+D126+D128-D129-D130-D131-D132+D133+D134+D135","v":0},0,0,0,0,{"$f":"+I126+I128-I129-I130-I131-I132+I133+I134+I135","v":0},{"$f":"+J126+J128-J129-J130-J131-J132+J133+J134+J135","v":0},{"$f":"+K126+K128-K129-K130-K131-K132+K133+K134+K135","v":0},{"$f":"+L126+L128-L129-L130-L131-L132+L133+L134+L135","v":0}]
[]
["Balance Sheet"]
[]
["Current Assets"]
["  Cash & Cash Equivalents"]
[null,"Cash on hand/Petty Cash",{"$f":"+D142","v":0},null,null,null,null,{"$f":"+I142","v":0}]
[null,"Cash in bank",{"$f":"+D143","v":0},null,null,null,null,{"$f":"+I143","v":0},0]
[null,"Cash in Redemption Terminals",0,null,null,null,null,0,0]
[null,"Cash in ATM's",0,null,null,null,null,0,0]
[null,"Cash in Video Gaming Terminals",0,null,null,null,null,0,0]
[null,"Cash in Amusement Machines",0,null,null,null,null,0,0]
[null,"Marketable securities",0,null,null,null,null,0,0]
[null,"  Total Cash & Cash Equivalents",{"$f":"SUM(C142:C148)","v":0},{"$f":"SUM(D142:D148)","v":0},0,0,0,{"$f":"SUM(H142:H148)","v":0},0,{"$f":"SUM(J142:J148)","v":0},0,0]
["  Accounts Receivable"]
[null,"Accounts Receivable - Other",{"$f":"+D151","v":0},null,null,null,null,{"$f":"+I151","v":0},0]
[null,"A/R - Other Allowance for Doubtful Accts",{"$f":"+D152","v":0},null,null,null,null,0,0]
[null,"  Total Accounts Receivable",{"$f":"+C152+C151","v":0},{"$f":"+D152+D151","v":0},0,0,0,{"$f":"+H152+H151","v":0},0,{"$f":"+J152+J151","v":0},0,0]
["  Other Receivables"]
[null,"Notes Receivable",{"$f":"+D155","v":0},null,null,null,null,{"$f":"+I155","v":0},0]
[null,"Notes Receivable - Allowance for doubtful Accounts",0,null,null,null,null,0,0]
[null,"Loans Receivable from Affiliated Companies",0,null,null,null,null,0,0]
[null,"Accrued Interest Receivable",0,null,null,null,null,0,0]
[null,"  Total Other Receivables",{"$f":"SUM(C155:C158)","v":0},{"$f":"SUM(D155:D158)","v":0},0,0,0,{"$f":"SUM(H155:H158)","v":0},0,{"$f":"SUM(J155:J158)","v":0},0,0]
[]
["  Prepaid Expenses",null,{"$f":"+D161","v":0},null,null,null,null,{"$f":"+I161","v":0},0]
["  Inventory"]
[null,"Video Gaming Terminals - Work in Progress and Finished Goods",{"$f":"+D163","v":0},null,null,null,null,{"$f":"+I163","v":0},0]
[null,"Video Gaming Terminal - Spare Parts",0,null,null,null,null,0,0]
[null,"   Total Inventory",{"$f":"+C164+C163","v":0},{"$f":"+D164+D163","v":0},0,0,0,{"$f":"+H164+H163","v":0},0,{"$f":"+J164+J163","v":0},0,0]
[]
["  Other Current Assets",null,{"$f":"+D167","v":0},null,null,null,null,{"$f":"+I167","v":0},0]
["Total Current Assets",null,{"$f":"+C167+C165+C159+C153+C149+C161","v":0},{"$f":"+D167+D165+D159+D153+D149+D161","v":0},0,0,0,{"$f":"+H167+H165+H159+H153+H149+H161","v":0},0,{"$f":"+J167+J165+J159+J153+J149+J161","v":0},0,0]
[]
["  Long-Term Investments",null,{"$f":"+D170","v":0},null,null,null,null,{"$f":"+I170","v":0},0]
["  Fixed Assets, net of Depreciation"]
[null,"Land and Improvements",{"$f":"+D172","v":0},null,null,null,null,0,0]
[null,"Construction in Progress",0,null,null,null,null,0,0]
[null,"Buildings and improvements",0,null,null,null,null,0,0]
[null,"Leasehold Improvements",0,null,null,null,null,0,0]
[null,"Furniture and Fixtures",0,null,null,null,null,0,0]
[null,"Gaming Equipment",0,null,null,null,null,0,0]
[null,"Automobiles",0,null,null,null,null,0,0]
[null,"Other Fixed Assets",0,null,null,null,null,0,0]
[null,"Accumulated Depreciation",0,null,null,null,null,0,0]
[null,"  Total Fixed Assets, net of Depreciation",{"$f":"SUM(C172:C180)","v":0},{"$f":"SUM(D172:D180)","v":0},0,0,0,{"$f":"SUM(H172:H180)","v":0},0,{"$f":"SUM(J172:J180)","v":0},0,0]
["  Long-Term Notes Receivable"]
[null,"Notes Receivable",{"$f":"+D183","v":0},null,null,null,null,{"$f":"+I183","v":0},0]
[null,"N/R - Allowance for Doubtful Accounts",0,null,null,null,null,0,0]
[null,"  Total Long-Term Notes Receivable",{"$f":"+C184+C183","v":0},{"$f":"+D184+D183","v":0},0,0,0,{"$f":"+H184+H183","v":0},0,{"$f":"+J184+J183","v":0},0,0]
["  Intangibles"]
[null,"Start Up/Organization Costs",{"$f":"+D187","v":0},null,null,null,null,{"$f":"+I187","v":0},0]
[null,"Customer Contracts",0,null,null,null,null,0,0]
[null,"Goodwill",0,null,null,null,null,0,0]
[null,"Deferred Financing Costs",0,null,null,null,null,0,0]
[null,"Amortization of Intangibles",0,null,null,null,null,0,0]
[null,"  Total Intangibles, net of Amortization",{"$f":"SUM(C187:C191)","v":0},{"$f":"SUM(D187:D191)","v":0},0,0,0,{"$f":"SUM(H187:H191)","v":0},0,{"$f":"SUM(J187:J191)","v":0},0,0]
["  Other Non-Current Assets"]
[null,"  Security Deposits",{"$f":"+D194","v":0},null,null,null,null,{"$f":"+I194","v":0},0]
[null,"  Other Non-Current Assets",0,null,null,null,null,0,0]
[null,"     Total Other Non-Current Assets",{"$f":"+C195+C194","v":0},{"$f":"+D195+D194","v":0},0,0,{"$f":"+G195+G194","v":0},{"$f":"+H195+H194","v":0},0,{"$f":"+J195+J194","v":0},0,0]
["  Total Non-Current Assets",null,{"$f":"+C196+C192+C185+C181+C170","v":0},{"$f":"+D196+D192+D185+D181+D170","v":0},0,0,{"$f":"+G196+G192+G185+G181+G170","v":0},{"$f":"+H196+H192+H185+H181+H170","v":0},0,{"$f":"+J196+J192+J185+J181+J170","v":0},0,0]
[null,"Total Assets",{"$f":"+C197+C168","v":0},{"$f":"+D197+D168","v":0},0,0,{"$f":"+G197+G168","v":0},{"$f":"+H197+H168","v":0},0,{"$f":"+J197+J168","v":0},0,0]
[]
["Current Liabilities"]
["  Current Portion of Long-Term Debt"]
[null,"Current Portion of 3rd Party Long-Term Debt",{"$f":"+D202","v":0},null,null,null,null,{"$f":"+I202","v":0},0]
[null,"Current Portion of Loans Payable to Owner",0,null,null,null,null,0,0]
[null,"Current Portion of Affiliated Entity Loan",0,null,null,null,null,0,0]
[null,"Current Portion of Capital Leases",0,null,null,null,null,0,0]
[null,"  Total Current Portion of Long-Term Debt",{"$f":"SUM(C202:C205)","v":0},{"$f":"SUM(D202:D205)","v":0},0,0,0,{"$f":"SUM(H202:H205)","v":0},0,{"$f":"SUM(J202:J205)","v":0},0,0]
["  Accounts Payable & Accrued Liabilities"]
[null,"Accounts Payable",{"$f":"+D208","v":0},null,null,null,null,{"$f":"+I208","v":0},0]
[null,"Accrued Accounts Payable",0,null,null,null,null,0,0]
[null,"Accrued Cash Out Vouchers Payable",0,null,null,null,null,0,0]
[null,"Accrued Payroll ",0,null,null,null,null,0,0]
[null,"Accrued Vacation/Personal Days/Sick Days",0,null,null,null,null,0,0]
[null,"Accrued Payroll Taxes",0,null,null,null,null,0,0]
[null,"Accrued Benefits (401K/Pension/Health)",0,null,null,null,null,0,0]
[null,"Accrued Gaming Taxes",0,null,null,null,null,0,0]
[null,"Accrued Income Taxes",0,null,null,null,null,0,0]
[null,"Accrued Revenue Share",0,null,null,null,null,0,0]
[null,"Accrued Admin.  Fee - Scientific Games",0,null,null,null,null,0,0]
[null,"Accrued Professional Fees",0,null,null,null,null,0,0]
[null,"Accrued Interest Payable",0,null,null,null,null,0,0]
[null,"Accrued Commissions",0,null,null,null,null,0,0]
[null,"Other Accrued Liabilities",0,null,null,null,null,0,0]
[null,"  Total A/P & Accrued Liabilities",{"$f":"SUM(C208:C222)","v":0},{"$f":"SUM(D208:D222)","v":0},0,0,0,{"$f":"SUM(H208:H222)","v":0},0,{"$f":"SUM(J208:J222)","v":0},0,0]
[]
["  Other Current Liabilities"]
[null,"Current Portion of Deferred Income Tax",{"$f":"+D226","v":0},null,null,null,null,{"$f":"+I226","v":0},0]
[null,"Other Current Liabilities",0,null,null,null,null,0,0]
[null,"  Total Other Current Liabilities",{"$f":"+C227+C226","v":0},{"$f":"+D227+D226","v":0},0,0,{"$f":"+G227+G226","v":0},{"$f":"+H227+H226","v":0},0,{"$f":"+J227+J226","v":0},0,0]
[null,"     Total Current Liabilities",{"$f":"+C228+C223+C206","v":0},{"$f":"+D228+D223+D206","v":0},0,0,0,0,0,{"$f":"+J228+J223+J206","v":0},0,0]
["Non-Current Liabilities"]
["  Long-Term Debt"]
[null,"Long-Term Debt, 3rd Party",{"$f":"+D232","v":0},null,null,null,null,{"$f":"+I232","v":0},0]
[null,"Long-Term Debt, Loans Payable to Owners",0,null,null,null,null,0,0]
[null,"Long-Term Debt, Loans Payable to Affiliates",0,null,null,null,null,0,0]
[null,"Capital Leases",0,null,null,null,null,0,0]
[null,"  Total Long-Term Debt",{"$f":"SUM(C232:C235)","v":0},{"$f":"SUM(D232:D235)","v":0},0,0,0,{"$f":"SUM(H232:H235)","v":0},0,{"$f":"SUM(J232:J235)","v":0},0,0]
["  Other Long-Term Liabilities"]
[null,"Deferred Income Tax",{"$f":"+D238","v":0},null,null,null,null,{"$f":"+I238","v":0},0]
[null,"Other Long-Term Liabilities",0,null,null,null,null,0,0]
[null,"  Total Other Long-Term Liabilities",{"$f":"+C239+C238","v":0},{"$f":"+D239+D238","v":0},0,0,{"$f":"+G239+G238","v":0},{"$f":"+H239+H238","v":0},0,{"$f":"+J239+J238","v":0},0,0]
["Total Non-Current Liabilities",null,{"$f":"+C240+C236","v":0},{"$f":"+D240+D236","v":0},0,0,{"$f":"+G240+G236","v":0},{"$f":"+H240+H236","v":0},0,{"$f":"+J240+J236","v":0},0,0]
[null,"Total Liabilities",{"$f":"+C241+C229","v":0},{"$f":"+D241+D229","v":0},0,0,{"$f":"+G241+G229","v":0},{"$f":"+H241+H229","v":0},0,{"$f":"+J241+J229","v":0},0,0]
["Equity"]
["  Capital"]
[null,"Common Stock",{"$f":"+D245","v":0},null,null,null,null,{"$f":"+I245","v":0},0]
[null,"Preferred Stock",0,null,null,null,null,0,0]
[null,"Additional Paid In Capital",0,null,null,null,null,0,0]
[null,"Member Capital",0,null,null,null,null,0,0]
[null,"  Total Capital",{"$f":"SUM(C245:C248)","v":0},{"$f":"SUM(D245:D248)","v":0},0,0,0,{"$f":"SUM(H245:H248)","v":0},0,{"$f":"SUM(J245:J248)","v":0},0,0]
["  Retained Earnings"]
[null,"Retained Earnings",{"$f":"+D251","v":0},null,null,null,null,{"$f":"+I251","v":0},0]
[null,"Net Income (Loss)",0,{"$f":"+E252+D136","v":0},{"$f":"+F252+E136","v":0},{"$f":"+G252+F136","v":0},{"$f":"+G136","v":0},0,{"$f":"+I136","v":0},{"$f":"+J136","v":0},0,0]
[null,"  Total Retained Earnings",{"$f":"+C252+C251","v":0},{"$f":"+D252+D251","v":0},{"$f":"+E252+E251","v":0},{"$f":"+F252+F251","v":0},0,{"$f":"+H252+H251","v":0},0,{"$f":"+J252+J251","v":0},0,0]
["   Total Equity",null,{"$f":"+C253+C249","v":0},{"$f":"+D253+D249","v":0},{"$f":"+E253+E249","v":0},{"$f":"+F253+F249","v":0},0,{"$f":"+H253+H249","v":0},0,{"$f":"+J253+J249","v":0},0,0]
[null,"Total Liabilities and Equity",{"$f":"+C254+C242","v":0},{"$f":"+D254+D242","v":0},{"$f":"+E254+E242","v":0},{"$f":"+F254+F242","v":0},0,{"$f":"+H254+H242","v":0},0,{"$f":"+J254+J242","v":0},0,0]
[]
[null,"Balance Check - Should be 0",{"$f":"+C198-C255","v":0},{"$f":"+D198-D255","v":0},0,0,{"$f":"+G198-G255","v":0},{"$f":"+H198-H255","v":0},0,{"$f":"+J198-J255","v":0},0,0]

{"sheet":"Business Activity","index":6,"n_rows":24,"n_cols":1,"rows_kept":24,"cut":false,"hidden":false,"merged":[[24,0,24,7],[17,0,17,7],[22,0,22,7],[0,0,0,7],[1,0,1,7],[4,0,4,7],[12,0,12,7],[9,0,9,7],[14,0,14,7],[19,0,19,7],[7,0,7,7]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["CURRENT AND FUTURE BUSINESS ACTIVITY BY QUARTER  "]
[]
[]
["This section is to be used to briefly explain any significant business related activity that occurred during the quarter;  i.e. acquisiton or sale of business lines, use agreements, large equipment purchases or sales, related party transactions, litigation, etc.  Also, explain any significant future plans scheduled to occur within one year from the end of the current quarter;  i.e. planned acquisition or sale of business lines, use agreements, equipment, incurring or paying off new debt, etc. "]
["Business Activity - Quarter 1:"]
["Current:   "]
[]
["Future:   "]
[]
["Business Activity - Quarter 2:"]
["Current:   "]
[]
["Future:   "]
[]
["Business Activity - Quarter 3:"]
["Current:   "]
[]
["Future:   "]
[]
["Business Activity - Quarter 4:"]
["Current:   "]
[]
["Future:   "]

{"sheet":"Use Agreement Tracking","index":7,"n_rows":5003,"n_cols":19,"rows_kept":5003,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,14]]}
[null,{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
[null,"USE AGREEMENT TRACKING  - Purpose: To track all location use agreement activity as well as timing of activity with the Central Communications System.  (Please include all activity, live or not.)                                                                                                                       Please enter dates in the MM/DD/YY format - do NOT enter N/A or TEXT in the date fields."]
[null,"Establishment Name","Street Address","City","County","Zipcode","Business Type","Date Current TO Acquired Use Agreement","Purchased From           (If Applicable)","Date Connected to Sci Games under Current TO","Part of a Revenue Share","Revenue Sharer","Change in Agreement Status","Date Use Agreement Sold, Expired, Revoked, Denied, Business Closed                  (If Applicable)","Sold To                          (If applicable)"]
[1]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Liquor (Retail)"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Truck Stop"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fraternal"]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Veterans"]
[6]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[9]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sold"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expired"]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revoked"]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Denied"]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Closed"]
[15]
[16]
[17]
[18]
[19]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[21,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[22,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[23,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[24,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[25,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[26,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[27,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[28,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[29,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[30,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[31,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[32,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[33,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[35,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[36,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[37,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[38,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[39,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[41,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[42,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[43,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[44,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[45,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[46,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[47,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[48,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[49,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[50,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[51,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[52,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[53,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[54,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[55,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[56,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[57,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[58,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[59,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[60,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[61,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[62,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[63,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[64,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[65,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[66,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[68,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[69,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[70,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[71,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[72,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[73,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[74,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[75,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[76,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[77,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[78,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[79,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[80,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[81,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[82,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[83,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[84,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[85,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[86,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[87,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[88,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[89,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[90,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[91,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[92,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[93,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[94,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[95,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[96,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[97,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[98,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[99,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[100,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[101,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[102,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[103,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[104,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[105,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[106,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[107,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[108,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[109,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[110,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[111,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[112,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[113,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[114,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[115,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[116,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[117,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[118,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[119,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[120,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[121,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[122,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[123,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[124,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[125,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[126,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[127,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[128,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[129,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[130,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[131,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[132,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[133,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[134,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[135,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[136,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[137,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[138,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[139,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[140,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[141,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[142,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[143,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[144,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[145,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[146,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[147,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[148,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[149,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[150,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[151,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[152,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[153,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[154,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[155,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[156,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[157,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[158,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[159,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[160,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[161,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[162,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[163,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[164,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[165,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[166,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[167,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[168,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[169,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[170,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[171,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[172,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[173,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[174,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[175,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[176,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[177,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[178,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[179,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[180,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[181,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[182,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[183,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[184,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[185,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[186,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[187,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[188,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[189,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[190,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[191,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[192,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[193,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[194,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[195,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[196,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[197,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[198,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[199,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[200,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[201,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[202,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[203,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[204,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[205,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[206,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[207,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[208,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[209,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[210,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[211,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[212,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[213,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[214,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[215,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[216,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[217,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[218,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[219,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[220,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[221,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[222,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[223,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[224,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[225,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[226,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[227,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[228,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[229,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[230,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[231,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[232,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[233,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[234,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[235,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[236,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[237,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[238,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[239,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[240,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[241,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[242,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[243,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[244,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[245,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[246,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[247,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[248,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[249,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[250,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[251,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[252,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[253,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[254,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[255,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[256,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[257,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[258,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[259,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[260,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[261,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[262,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[263,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[264,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[265,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[266,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[267,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[268,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[269,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[270,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[271,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[272,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[273,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[274,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[275,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[276,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[277,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[278,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[279,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[280,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[281,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[282,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[283,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[284,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[285,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[286,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[287,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[288,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[289,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[290,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[291,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[292,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[293,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[294,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[295,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[296,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[297,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[298,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[299,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[300,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[301,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[302,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[303,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[304,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[305,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[306,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[307,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[308,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[309,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[310,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[311,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[312,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[313,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[314,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[315,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[316,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[317,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[318,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[319,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[320,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[321,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[322,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[323,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[324,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[325,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[326,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[327,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[328,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[329,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[330,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[331,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[332,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[333,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[334,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[335,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[336,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[337,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[338,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[339,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[340,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[341,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[342,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[343,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[344,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[345,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[346,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[347,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[348,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[349,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[350,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[351,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[352,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[353,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[354,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[355,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[356,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[357,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[358,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[359,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[360,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[361,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[362,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[363,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]
[600]
[601]
[602]
[603]
[604]
[605]
[606]
[607]
[608]
[609]
[610]
[611]
[612]
[613]
[614]
[615]
[616]
[617]
[618]
[619]
[620]
[621]
[622]
[623]
[624]
[625]
[626]
[627]
[628]
[629]
[630]
[631]
[632]
[633]
[634]
[635]
[636]
[637]
[638]
[639]
[640]
[641]
[642]
[643]
[644]
[645]
[646]
[647]
[648]
[649]
[650]
[651]
[652]
[653]
[654]
[655]
[656]
[657]
[658]
[659]
[660]
[661]
[662]
[663]
[664]
[665]
[666]
[667]
[668]
[669]
[670]
[671]
[672]
[673]
[674]
[675]
[676]
[677]
[678]
[679]
[680]
[681]
[682]
[683]
[684]
[685]
[686]
[687]
[688]
[689]
[690]
[691]
[692]
[693]
[694]
[695]
[696]
[697]
[698]
[699]
[700]
[701]
[702]
[703]
[704]
[705]
[706]
[707]
[708]
[709]
[710]
[711]
[712]
[713]
[714]
[715]
[716]
[717]
[718]
[719]
[720]
[721]
[722]
[723]
[724]
[725]
[726]
[727]
[728]
[729]
[730]
[731]
[732]
[733]
[734]
[735]
[736]
[737]
[738]
[739]
[740]
[741]
[742]
[743]
[744]
[745]
[746]
[747]
[748]
[749]
[750]
[751]
[752]
[753]
[754]
[755]
[756]
[757]
[758]
[759]
[760]
[761]
[762]
[763]
[764]
[765]
[766]
[767]
[768]
[769]
[770]
[771]
[772]
[773]
[774]
[775]
[776]
[777]
[778]
[779]
[780]
[781]
[782]
[783]
[784]
[785]
[786]
[787]
[788]
[789]
[790]
[791]
[792]
[793]
[794]
[795]
[796]
[797]
[798]
[799]
[800]
[801]
[802]
[803]
[804]
[805]
[806]
[807]
[808]
[809]
[810]
[811]
[812]
[813]
[814]
[815]
[816]
[817]
[818]
[819]
[820]
[821]
[822]
[823]
[824]
[825]
[826]
[827]
[828]
[829]
[830]
[831]
[832]
[833]
[834]
[835]
[836]
[837]
[838]
[839]
[840]
[841]
[842]
[843]
[844]
[845]
[846]
[847]
[848]
[849]
[850]
[851]
[852]
[853]
[854]
[855]
[856]
[857]
[858]
[859]
[860]
[861]
[862]
[863]
[864]
[865]
[866]
[867]
[868]
[869]
[870]
[871]
[872]
[873]
[874]
[875]
[876]
[877]
[878]
[879]
[880]
[881]
[882]
[883]
[884]
[885]
[886]
[887]
[888]
[889]
[890]
[891]
[892]
[893]
[894]
[895]
[896]
[897]
[898]
[899]
[900]
[901]
[902]
[903]
[904]
[905]
[906]
[907]
[908]
[909]
[910]
[911]
[912]
[913]
[914]
[915]
[916]
[917]
[918]
[919]
[920]
[921]
[922]
[923]
[924]
[925]
[926]
[927]
[928]
[929]
[930]
[931]
[932]
[933]
[934]
[935]
[936]
[937]
[938]
[939]
[940]
[941]
[942]
[943]
[944]
[945]
[946]
[947]
[948]
[949]
[950]
[951]
[952]
[953]
[954]
[955]
[956]
[957]
[958]
[959]
[960]
[961]
[962]
[963]
[964]
[965]
[966]
[967]
[968]
[969]
[970]
[971]
[972]
[973]
[974]
[975]
[976]
[977]
[978]
[979]
[980]
[981]
[982]
[983]
[984]
[985]
[986]
[987]
[988]
[989]
[990]
[991]
[992]
[993]
[994]
[995]
[996]
[997]
[998]
[999]
[1000]
[1001]
[1002]
[1003]
[1004]
[1005]
[1006]
[1007]
[1008]
[1009]
[1010]
[1011]
[1012]
[1013]
[1014]
[1015]
[1016]
[1017]
[1018]
[1019]
[1020]
[1021]
[1022]
[1023]
[1024]
[1025]
[1026]
[1027]
[1028]
[1029]
[1030]
[1031]
[1032]
[1033]
[1034]
[1035]
[1036]
[1037]
[1038]
[1039]
[1040]
[1041]
[1042]
[1043]
[1044]
[1045]
[1046]
[1047]
[1048]
[1049]
[1050]
[1051]
[1052]
[1053]
[1054]
[1055]
[1056]
[1057]
[1058]
[1059]
[1060]
[1061]
[1062]
[1063]
[1064]
[1065]
[1066]
[1067]
[1068]
[1069]
[1070]
[1071]
[1072]
[1073]
[1074]
[1075]
[1076]
[1077]
[1078]
[1079]
[1080]
[1081]
[1082]
[1083]
[1084]
[1085]
[1086]
[1087]
[1088]
[1089]
[1090]
[1091]
[1092]
[1093]
[1094]
[1095]
[1096]
[1097]
[1098]
[1099]
[1100]
[1101]
[1102]
[1103]
[1104]
[1105]
[1106]
[1107]
[1108]
[1109]
[1110]
[1111]
[1112]
[1113]
[1114]
[1115]
[1116]
[1117]
[1118]
[1119]
[1120]
[1121]
[1122]
[1123]
[1124]
[1125]
[1126]
[1127]
[1128]
[1129]
[1130]
[1131]
[1132]
[1133]
[1134]
[1135]
[1136]
[1137]
[1138]
[1139]
[1140]
[1141]
[1142]
[1143]
[1144]
[1145]
[1146]
[1147]
[1148]
[1149]
[1150]
[1151]
[1152]
[1153]
[1154]
[1155]
[1156]
[1157]
[1158]
[1159]
[1160]
[1161]
[1162]
[1163]
[1164]
[1165]
[1166]
[1167]
[1168]
[1169]
[1170]
[1171]
[1172]
[1173]
[1174]
[1175]
[1176]
[1177]
[1178]
[1179]
[1180]
[1181]
[1182]
[1183]
[1184]
[1185]
[1186]
[1187]
[1188]
[1189]
[1190]
[1191]
[1192]
[1193]
[1194]
[1195]
[1196]
[1197]
[1198]
[1199]
[1200]
[1201]
[1202]
[1203]
[1204]
[1205]
[1206]
[1207]
[1208]
[1209]
[1210]
[1211]
[1212]
[1213]
[1214]
[1215]
[1216]
[1217]
[1218]
[1219]
[1220]
[1221]
[1222]
[1223]
[1224]
[1225]
[1226]
[1227]
[1228]
[1229]
[1230]
[1231]
[1232]
[1233]
[1234]
[1235]
[1236]
[1237]
[1238]
[1239]
[1240]
[1241]
[1242]
[1243]
[1244]
[1245]
[1246]
[1247]
[1248]
[1249]
[1250]
[1251]
[1252]
[1253]
[1254]
[1255]
[1256]
[1257]
[1258]
[1259]
[1260]
[1261]
[1262]
[1263]
[1264]
[1265]
[1266]
[1267]
[1268]
[1269]
[1270]
[1271]
[1272]
[1273]
[1274]
[1275]
[1276]
[1277]
[1278]
[1279]
[1280]
[1281]
[1282]
[1283]
[1284]
[1285]
[1286]
[1287]
[1288]
[1289]
[1290]
[1291]
[1292]
[1293]
[1294]
[1295]
[1296]
[1297]
[1298]
[1299]
[1300]
[1301]
[1302]
[1303]
[1304]
[1305]
[1306]
[1307]
[1308]
[1309]
[1310]
[1311]
[1312]
[1313]
[1314]
[1315]
[1316]
[1317]
[1318]
[1319]
[1320]
[1321]
[1322]
[1323]
[1324]
[1325]
[1326]
[1327]
[1328]
[1329]
[1330]
[1331]
[1332]
[1333]
[1334]
[1335]
[1336]
[1337]
[1338]
[1339]
[1340]
[1341]
[1342]
[1343]
[1344]
[1345]
[1346]
[1347]
[1348]
[1349]
[1350]
[1351]
[1352]
[1353]
[1354]
[1355]
[1356]
[1357]
[1358]
[1359]
[1360]
[1361]
[1362]
[1363]
[1364]
[1365]
[1366]
[1367]
[1368]
[1369]
[1370]
[1371]
[1372]
[1373]
[1374]
[1375]
[1376]
[1377]
[1378]
[1379]
[1380]
[1381]
[1382]
[1383]
[1384]
[1385]
[1386]
[1387]
[1388]
[1389]
[1390]
[1391]
[1392]
[1393]
[1394]
[1395]
[1396]
[1397]
[1398]
[1399]
[1400]
[1401]
[1402]
[1403]
[1404]
[1405]
[1406]
[1407]
[1408]
[1409]
[1410]
[1411]
[1412]
[1413]
[1414]
[1415]
[1416]
[1417]
[1418]
[1419]
[1420]
[1421]
[1422]
[1423]
[1424]
[1425]
[1426]
[1427]
[1428]
[1429]
[1430]
[1431]
[1432]
[1433]
[1434]
[1435]
[1436]
[1437]
[1438]
[1439]
[1440]
[1441]
[1442]
[1443]
[1444]
[1445]
[1446]
[1447]
[1448]
[1449]
[1450]
[1451]
[1452]
[1453]
[1454]
[1455]
[1456]
[1457]
[1458]
[1459]
[1460]
[1461]
[1462]
[1463]
[1464]
[1465]
[1466]
[1467]
[1468]
[1469]
[1470]
[1471]
[1472]
[1473]
[1474]
[1475]
[1476]
[1477]
[1478]
[1479]
[1480]
[1481]
[1482]
[1483]
[1484]
[1485]
[1486]
[1487]
[1488]
[1489]
[1490]
[1491]
[1492]
[1493]
[1494]
[1495]
[1496]
[1497]
[1498]
[1499]
[1500]
[1501]
[1502]
[1503]
[1504]
[1505]
[1506]
[1507]
[1508]
[1509]
[1510]
[1511]
[1512]
[1513]
[1514]
[1515]
[1516]
[1517]
[1518]
[1519]
[1520]
[1521]
[1522]
[1523]
[1524]
[1525]
[1526]
[1527]
[1528]
[1529]
[1530]
[1531]
[1532]
[1533]
[1534]
[1535]
[1536]
[1537]
[1538]
[1539]
[1540]
[1541]
[1542]
[1543]
[1544]
[1545]
[1546]
[1547]
[1548]
[1549]
[1550]
[1551]
[1552]
[1553]
[1554]
[1555]
[1556]
[1557]
[1558]
[1559]
[1560]
[1561]
[1562]
[1563]
[1564]
[1565]
[1566]
[1567]
[1568]
[1569]
[1570]
[1571]
[1572]
[1573]
[1574]
[1575]
[1576]
[1577]
[1578]
[1579]
[1580]
[1581]
[1582]
[1583]
[1584]
[1585]
[1586]
[1587]
[1588]
[1589]
[1590]
[1591]
[1592]
[1593]
[1594]
[1595]
[1596]
[1597]
[1598]
[1599]
[1600]
[1601]
[1602]
[1603]
[1604]
[1605]
[1606]
[1607]
[1608]
[1609]
[1610]
[1611]
[1612]
[1613]
[1614]
[1615]
[1616]
[1617]
[1618]
[1619]
[1620]
[1621]
[1622]
[1623]
[1624]
[1625]
[1626]
[1627]
[1628]
[1629]
[1630]
[1631]
[1632]
[1633]
[1634]
[1635]
[1636]
[1637]
[1638]
[1639]
[1640]
[1641]
[1642]
[1643]
[1644]
[1645]
[1646]
[1647]
[1648]
[1649]
[1650]
[1651]
[1652]
[1653]
[1654]
[1655]
[1656]
[1657]
[1658]
[1659]
[1660]
[1661]
[1662]
[1663]
[1664]
[1665]
[1666]
[1667]
[1668]
[1669]
[1670]
[1671]
[1672]
[1673]
[1674]
[1675]
[1676]
[1677]
[1678]
[1679]
[1680]
[1681]
[1682]
[1683]
[1684]
[1685]
[1686]
[1687]
[1688]
[1689]
[1690]
[1691]
[1692]
[1693]
[1694]
[1695]
[1696]
[1697]
[1698]
[1699]
[1700]
[1701]
[1702]
[1703]
[1704]
[1705]
[1706]
[1707]
[1708]
[1709]
[1710]
[1711]
[1712]
[1713]
[1714]
[1715]
[1716]
[1717]
[1718]
[1719]
[1720]
[1721]
[1722]
[1723]
[1724]
[1725]
[1726]
[1727]
[1728]
[1729]
[1730]
[1731]
[1732]
[1733]
[1734]
[1735]
[1736]
[1737]
[1738]
[1739]
[1740]
[1741]
[1742]
[1743]
[1744]
[1745]
[1746]
[1747]
[1748]
[1749]
[1750]
[1751]
[1752]
[1753]
[1754]
[1755]
[1756]
[1757]
[1758]
[1759]
[1760]
[1761]
[1762]
[1763]
[1764]
[1765]
[1766]
[1767]
[1768]
[1769]
[1770]
[1771]
[1772]
[1773]
[1774]
[1775]
[1776]
[1777]
[1778]
[1779]
[1780]
[1781]
[1782]
[1783]
[1784]
[1785]
[1786]
[1787]
[1788]
[1789]
[1790]
[1791]
[1792]
[1793]
[1794]
[1795]
[1796]
[1797]
[1798]
[1799]
[1800]
[1801]
[1802]
[1803]
[1804]
[1805]
[1806]
[1807]
[1808]
[1809]
[1810]
[1811]
[1812]
[1813]
[1814]
[1815]
[1816]
[1817]
[1818]
[1819]
[1820]
[1821]
[1822]
[1823]
[1824]
[1825]
[1826]
[1827]
[1828]
[1829]
[1830]
[1831]
[1832]
[1833]
[1834]
[1835]
[1836]
[1837]
[1838]
[1839]
[1840]
[1841]
[1842]
[1843]
[1844]
[1845]
[1846]
[1847]
[1848]
[1849]
[1850]
[1851]
[1852]
[1853]
[1854]
[1855]
[1856]
[1857]
[1858]
[1859]
[1860]
[1861]
[1862]
[1863]
[1864]
[1865]
[1866]
[1867]
[1868]
[1869]
[1870]
[1871]
[1872]
[1873]
[1874]
[1875]
[1876]
[1877]
[1878]
[1879]
[1880]
[1881]
[1882]
[1883]
[1884]
[1885]
[1886]
[1887]
[1888]
[1889]
[1890]
[1891]
[1892]
[1893]
[1894]
[1895]
[1896]
[1897]
[1898]
[1899]
[1900]
[1901]
[1902]
[1903]
[1904]
[1905]
[1906]
[1907]
[1908]
[1909]
[1910]
[1911]
[1912]
[1913]
[1914]
[1915]
[1916]
[1917]
[1918]
[1919]
[1920]
[1921]
[1922]
[1923]
[1924]
[1925]
[1926]
[1927]
[1928]
[1929]
[1930]
[1931]
[1932]
[1933]
[1934]
[1935]
[1936]
[1937]
[1938]
[1939]
[1940]
[1941]
[1942]
[1943]
[1944]
[1945]
[1946]
[1947]
[1948]
[1949]
[1950]
[1951]
[1952]
[1953]
[1954]
[1955]
[1956]
[1957]
[1958]
[1959]
[1960]
[1961]
[1962]
[1963]
[1964]
[1965]
[1966]
[1967]
[1968]
[1969]
[1970]
[1971]
[1972]
[1973]
[1974]
[1975]
[1976]
[1977]
[1978]
[1979]
[1980]
[1981]
[1982]
[1983]
[1984]
[1985]
[1986]
[1987]
[1988]
[1989]
[1990]
[1991]
[1992]
[1993]
[1994]
[1995]
[1996]
[1997]
[1998]
[1999]
[2000]
[2001]
[2002]
[2003]
[2004]
[2005]
[2006]
[2007]
[2008]
[2009]
[2010]
[2011]
[2012]
[2013]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[2051]
[2052]
[2053]
[2054]
[2055]
[2056]
[2057]
[2058]
[2059]
[2060]
[2061]
[2062]
[2063]
[2064]
[2065]
[2066]
[2067]
[2068]
[2069]
[2070]
[2071]
[2072]
[2073]
[2074]
[2075]
[2076]
[2077]
[2078]
[2079]
[2080]
[2081]
[2082]
[2083]
[2084]
[2085]
[2086]
[2087]
[2088]
[2089]
[2090]
[2091]
[2092]
[2093]
[2094]
[2095]
[2096]
[2097]
[2098]
[2099]
[2100]
[2101]
[2102]
[2103]
[2104]
[2105]
[2106]
[2107]
[2108]
[2109]
[2110]
[2111]
[2112]
[2113]
[2114]
[2115]
[2116]
[2117]
[2118]
[2119]
[2120]
[2121]
[2122]
[2123]
[2124]
[2125]
[2126]
[2127]
[2128]
[2129]
[2130]
[2131]
[2132]
[2133]
[2134]
[2135]
[2136]
[2137]
[2138]
[2139]
[2140]
[2141]
[2142]
[2143]
[2144]
[2145]
[2146]
[2147]
[2148]
[2149]
[2150]
[2151]
[2152]
[2153]
[2154]
[2155]
[2156]
[2157]
[2158]
[2159]
[2160]
[2161]
[2162]
[2163]
[2164]
[2165]
[2166]
[2167]
[2168]
[2169]
[2170]
[2171]
[2172]
[2173]
[2174]
[2175]
[2176]
[2177]
[2178]
[2179]
[2180]
[2181]
[2182]
[2183]
[2184]
[2185]
[2186]
[2187]
[2188]
[2189]
[2190]
[2191]
[2192]
[2193]
[2194]
[2195]
[2196]
[2197]
[2198]
[2199]
[2200]
[2201]
[2202]
[2203]
[2204]
[2205]
[2206]
[2207]
[2208]
[2209]
[2210]
[2211]
[2212]
[2213]
[2214]
[2215]
[2216]
[2217]
[2218]
[2219]
[2220]
[2221]
[2222]
[2223]
[2224]
[2225]
[2226]
[2227]
[2228]
[2229]
[2230]
[2231]
[2232]
[2233]
[2234]
[2235]
[2236]
[2237]
[2238]
[2239]
[2240]
[2241]
[2242]
[2243]
[2244]
[2245]
[2246]
[2247]
[2248]
[2249]
[2250]
[2251]
[2252]
[2253]
[2254]
[2255]
[2256]
[2257]
[2258]
[2259]
[2260]
[2261]
[2262]
[2263]
[2264]
[2265]
[2266]
[2267]
[2268]
[2269]
[2270]
[2271]
[2272]
[2273]
[2274]
[2275]
[2276]
[2277]
[2278]
[2279]
[2280]
[2281]
[2282]
[2283]
[2284]
[2285]
[2286]
[2287]
[2288]
[2289]
[2290]
[2291]
[2292]
[2293]
[2294]
[2295]
[2296]
[2297]
[2298]
[2299]
[2300]
[2301]
[2302]
[2303]
[2304]
[2305]
[2306]
[2307]
[2308]
[2309]
[2310]
[2311]
[2312]
[2313]
[2314]
[2315]
[2316]
[2317]
[2318]
[2319]
[2320]
[2321]
[2322]
[2323]
[2324]
[2325]
[2326]
[2327]
[2328]
[2329]
[2330]
[2331]
[2332]
[2333]
[2334]
[2335]
[2336]
[2337]
[2338]
[2339]
[2340]
[2341]
[2342]
[2343]
[2344]
[2345]
[2346]
[2347]
[2348]
[2349]
[2350]
[2351]
[2352]
[2353]
[2354]
[2355]
[2356]
[2357]
[2358]
[2359]
[2360]
[2361]
[2362]
[2363]
[2364]
[2365]
[2366]
[2367]
[2368]
[2369]
[2370]
[2371]
[2372]
[2373]
[2374]
[2375]
[2376]
[2377]
[2378]
[2379]
[2380]
[2381]
[2382]
[2383]
[2384]
[2385]
[2386]
[2387]
[2388]
[2389]
[2390]
[2391]
[2392]
[2393]
[2394]
[2395]
[2396]
[2397]
[2398]
[2399]
[2400]
[2401]
[2402]
[2403]
[2404]
[2405]
[2406]
[2407]
[2408]
[2409]
[2410]
[2411]
[2412]
[2413]
[2414]
[2415]
[2416]
[2417]
[2418]
[2419]
[2420]
[2421]
[2422]
[2423]
[2424]
[2425]
[2426]
[2427]
[2428]
[2429]
[2430]
[2431]
[2432]
[2433]
[2434]
[2435]
[2436]
[2437]
[2438]
[2439]
[2440]
[2441]
[2442]
[2443]
[2444]
[2445]
[2446]
[2447]
[2448]
[2449]
[2450]
[2451]
[2452]
[2453]
[2454]
[2455]
[2456]
[2457]
[2458]
[2459]
[2460]
[2461]
[2462]
[2463]
[2464]
[2465]
[2466]
[2467]
[2468]
[2469]
[2470]
[2471]
[2472]
[2473]
[2474]
[2475]
[2476]
[2477]
[2478]
[2479]
[2480]
[2481]
[2482]
[2483]
[2484]
[2485]
[2486]
[2487]
[2488]
[2489]
[2490]
[2491]
[2492]
[2493]
[2494]
[2495]
[2496]
[2497]
[2498]
[2499]
[2500]
[2501]
[2502]
[2503]
[2504]
[2505]
[2506]
[2507]
[2508]
[2509]
[2510]
[2511]
[2512]
[2513]
[2514]
[2515]
[2516]
[2517]
[2518]
[2519]
[2520]
[2521]
[2522]
[2523]
[2524]
[2525]
[2526]
[2527]
[2528]
[2529]
[2530]
[2531]
[2532]
[2533]
[2534]
[2535]
[2536]
[2537]
[2538]
[2539]
[2540]
[2541]
[2542]
[2543]
[2544]
[2545]
[2546]
[2547]
[2548]
[2549]
[2550]
[2551]
[2552]
[2553]
[2554]
[2555]
[2556]
[2557]
[2558]
[2559]
[2560]
[2561]
[2562]
[2563]
[2564]
[2565]
[2566]
[2567]
[2568]
[2569]
[2570]
[2571]
[2572]
[2573]
[2574]
[2575]
[2576]
[2577]
[2578]
[2579]
[2580]
[2581]
[2582]
[2583]
[2584]
[2585]
[2586]
[2587]
[2588]
[2589]
[2590]
[2591]
[2592]
[2593]
[2594]
[2595]
[2596]
[2597]
[2598]
[2599]
[2600]
[2601]
[2602]
[2603]
[2604]
[2605]
[2606]
[2607]
[2608]
[2609]
[2610]
[2611]
[2612]
[2613]
[2614]
[2615]
[2616]
[2617]
[2618]
[2619]
[2620]
[2621]
[2622]
[2623]
[2624]
[2625]
[2626]
[2627]
[2628]
[2629]
[2630]
[2631]
[2632]
[2633]
[2634]
[2635]
[2636]
[2637]
[2638]
[2639]
[2640]
[2641]
[2642]
[2643]
[2644]
[2645]
[2646]
[2647]
[2648]
[2649]
[2650]
[2651]
[2652]
[2653]
[2654]
[2655]
[2656]
[2657]
[2658]
[2659]
[2660]
[2661]
[2662]
[2663]
[2664]
[2665]
[2666]
[2667]
[2668]
[2669]
[2670]
[2671]
[2672]
[2673]
[2674]
[2675]
[2676]
[2677]
[2678]
[2679]
[2680]
[2681]
[2682]
[2683]
[2684]
[2685]
[2686]
[2687]
[2688]
[2689]
[2690]
[2691]
[2692]
[2693]
[2694]
[2695]
[2696]
[2697]
[2698]
[2699]
[2700]
[2701]
[2702]
[2703]
[2704]
[2705]
[2706]
[2707]
[2708]
[2709]
[2710]
[2711]
[2712]
[2713]
[2714]
[2715]
[2716]
[2717]
[2718]
[2719]
[2720]
[2721]
[2722]
[2723]
[2724]
[2725]
[2726]
[2727]
[2728]
[2729]
[2730]
[2731]
[2732]
[2733]
[2734]
[2735]
[2736]
[2737]
[2738]
[2739]
[2740]
[2741]
[2742]
[2743]
[2744]
[2745]
[2746]
[2747]
[2748]
[2749]
[2750]
[2751]
[2752]
[2753]
[2754]
[2755]
[2756]
[2757]
[2758]
[2759]
[2760]
[2761]
[2762]
[2763]
[2764]
[2765]
[2766]
[2767]
[2768]
[2769]
[2770]
[2771]
[2772]
[2773]
[2774]
[2775]
[2776]
[2777]
[2778]
[2779]
[2780]
[2781]
[2782]
[2783]
[2784]
[2785]
[2786]
[2787]
[2788]
[2789]
[2790]
[2791]
[2792]
[2793]
[2794]
[2795]
[2796]
[2797]
[2798]
[2799]
[2800]
[2801]
[2802]
[2803]
[2804]
[2805]
[2806]
[2807]
[2808]
[2809]
[2810]
[2811]
[2812]
[2813]
[2814]
[2815]
[2816]
[2817]
[2818]
[2819]
[2820]
[2821]
[2822]
[2823]
[2824]
[2825]
[2826]
[2827]
[2828]
[2829]
[2830]
[2831]
[2832]
[2833]
[2834]
[2835]
[2836]
[2837]
[2838]
[2839]
[2840]
[2841]
[2842]
[2843]
[2844]
[2845]
[2846]
[2847]
[2848]
[2849]
[2850]
[2851]
[2852]
[2853]
[2854]
[2855]
[2856]
[2857]
[2858]
[2859]
[2860]
[2861]
[2862]
[2863]
[2864]
[2865]
[2866]
[2867]
[2868]
[2869]
[2870]
[2871]
[2872]
[2873]
[2874]
[2875]
[2876]
[2877]
[2878]
[2879]
[2880]
[2881]
[2882]
[2883]
[2884]
[2885]
[2886]
[2887]
[2888]
[2889]
[2890]
[2891]
[2892]
[2893]
[2894]
[2895]
[2896]
[2897]
[2898]
[2899]
[2900]
[2901]
[2902]
[2903]
[2904]
[2905]
[2906]
[2907]
[2908]
[2909]
[2910]
[2911]
[2912]
[2913]
[2914]
[2915]
[2916]
[2917]
[2918]
[2919]
[2920]
[2921]
[2922]
[2923]
[2924]
[2925]
[2926]
[2927]
[2928]
[2929]
[2930]
[2931]
[2932]
[2933]
[2934]
[2935]
[2936]
[2937]
[2938]
[2939]
[2940]
[2941]
[2942]
[2943]
[2944]
[2945]
[2946]
[2947]
[2948]
[2949]
[2950]
[2951]
[2952]
[2953]
[2954]
[2955]
[2956]
[2957]
[2958]
[2959]
[2960]
[2961]
[2962]
[2963]
[2964]
[2965]
[2966]
[2967]
[2968]
[2969]
[2970]
[2971]
[2972]
[2973]
[2974]
[2975]
[2976]
[2977]
[2978]
[2979]
[2980]
[2981]
[2982]
[2983]
[2984]
[2985]
[2986]
[2987]
[2988]
[2989]
[2990]
[2991]
[2992]
[2993]
[2994]
[2995]
[2996]
[2997]
[2998]
[2999]
[3000]
[3001]
[3002]
[3003]
[3004]
[3005]
[3006]
[3007]
[3008]
[3009]
[3010]
[3011]
[3012]
[3013]
[3014]
[3015]
[3016]
[3017]
[3018]
[3019]
[3020]
[3021]
[3022]
[3023]
[3024]
[3025]
[3026]
[3027]
[3028]
[3029]
[3030]
[3031]
[3032]
[3033]
[3034]
[3035]
[3036]
[3037]
[3038]
[3039]
[3040]
[3041]
[3042]
[3043]
[3044]
[3045]
[3046]
[3047]
[3048]
[3049]
[3050]
[3051]
[3052]
[3053]
[3054]
[3055]
[3056]
[3057]
[3058]
[3059]
[3060]
[3061]
[3062]
[3063]
[3064]
[3065]
[3066]
[3067]
[3068]
[3069]
[3070]
[3071]
[3072]
[3073]
[3074]
[3075]
[3076]
[3077]
[3078]
[3079]
[3080]
[3081]
[3082]
[3083]
[3084]
[3085]
[3086]
[3087]
[3088]
[3089]
[3090]
[3091]
[3092]
[3093]
[3094]
[3095]
[3096]
[3097]
[3098]
[3099]
[3100]
[3101]
[3102]
[3103]
[3104]
[3105]
[3106]
[3107]
[3108]
[3109]
[3110]
[3111]
[3112]
[3113]
[3114]
[3115]
[3116]
[3117]
[3118]
[3119]
[3120]
[3121]
[3122]
[3123]
[3124]
[3125]
[3126]
[3127]
[3128]
[3129]
[3130]
[3131]
[3132]
[3133]
[3134]
[3135]
[3136]
[3137]
[3138]
[3139]
[3140]
[3141]
[3142]
[3143]
[3144]
[3145]
[3146]
[3147]
[3148]
[3149]
[3150]
[3151]
[3152]
[3153]
[3154]
[3155]
[3156]
[3157]
[3158]
[3159]
[3160]
[3161]
[3162]
[3163]
[3164]
[3165]
[3166]
[3167]
[3168]
[3169]
[3170]
[3171]
[3172]
[3173]
[3174]
[3175]
[3176]
[3177]
[3178]
[3179]
[3180]
[3181]
[3182]
[3183]
[3184]
[3185]
[3186]
[3187]
[3188]
[3189]
[3190]
[3191]
[3192]
[3193]
[3194]
[3195]
[3196]
[3197]
[3198]
[3199]
[3200]
[3201]
[3202]
[3203]
[3204]
[3205]
[3206]
[3207]
[3208]
[3209]
[3210]
[3211]
[3212]
[3213]
[3214]
[3215]
[3216]
[3217]
[3218]
[3219]
[3220]
[3221]
[3222]
[3223]
[3224]
[3225]
[3226]
[3227]
[3228]
[3229]
[3230]
[3231]
[3232]
[3233]
[3234]
[3235]
[3236]
[3237]
[3238]
[3239]
[3240]
[3241]
[3242]
[3243]
[3244]
[3245]
[3246]
[3247]
[3248]
[3249]
[3250]
[3251]
[3252]
[3253]
[3254]
[3255]
[3256]
[3257]
[3258]
[3259]
[3260]
[3261]
[3262]
[3263]
[3264]
[3265]
[3266]
[3267]
[3268]
[3269]
[3270]
[3271]
[3272]
[3273]
[3274]
[3275]
[3276]
[3277]
[3278]
[3279]
[3280]
[3281]
[3282]
[3283]
[3284]
[3285]
[3286]
[3287]
[3288]
[3289]
[3290]
[3291]
[3292]
[3293]
[3294]
[3295]
[3296]
[3297]
[3298]
[3299]
[3300]
[3301]
[3302]
[3303]
[3304]
[3305]
[3306]
[3307]
[3308]
[3309]
[3310]
[3311]
[3312]
[3313]
[3314]
[3315]
[3316]
[3317]
[3318]
[3319]
[3320]
[3321]
[3322]
[3323]
[3324]
[3325]
[3326]
[3327]
[3328]
[3329]
[3330]
[3331]
[3332]
[3333]
[3334]
[3335]
[3336]
[3337]
[3338]
[3339]
[3340]
[3341]
[3342]
[3343]
[3344]
[3345]
[3346]
[3347]
[3348]
[3349]
[3350]
[3351]
[3352]
[3353]
[3354]
[3355]
[3356]
[3357]
[3358]
[3359]
[3360]
[3361]
[3362]
[3363]
[3364]
[3365]
[3366]
[3367]
[3368]
[3369]
[3370]
[3371]
[3372]
[3373]
[3374]
[3375]
[3376]
[3377]
[3378]
[3379]
[3380]
[3381]
[3382]
[3383]
[3384]
[3385]
[3386]
[3387]
[3388]
[3389]
[3390]
[3391]
[3392]
[3393]
[3394]
[3395]
[3396]
[3397]
[3398]
[3399]
[3400]
[3401]
[3402]
[3403]
[3404]
[3405]
[3406]
[3407]
[3408]
[3409]
[3410]
[3411]
[3412]
[3413]
[3414]
[3415]
[3416]
[3417]
[3418]
[3419]
[3420]
[3421]
[3422]
[3423]
[3424]
[3425]
[3426]
[3427]
[3428]
[3429]
[3430]
[3431]
[3432]
[3433]
[3434]
[3435]
[3436]
[3437]
[3438]
[3439]
[3440]
[3441]
[3442]
[3443]
[3444]
[3445]
[3446]
[3447]
[3448]
[3449]
[3450]
[3451]
[3452]
[3453]
[3454]
[3455]
[3456]
[3457]
[3458]
[3459]
[3460]
[3461]
[3462]
[3463]
[3464]
[3465]
[3466]
[3467]
[3468]
[3469]
[3470]
[3471]
[3472]
[3473]
[3474]
[3475]
[3476]
[3477]
[3478]
[3479]
[3480]
[3481]
[3482]
[3483]
[3484]
[3485]
[3486]
[3487]
[3488]
[3489]
[3490]
[3491]
[3492]
[3493]
[3494]
[3495]
[3496]
[3497]
[3498]
[3499]
[3500]
[3501]
[3502]
[3503]
[3504]
[3505]
[3506]
[3507]
[3508]
[3509]
[3510]
[3511]
[3512]
[3513]
[3514]
[3515]
[3516]
[3517]
[3518]
[3519]
[3520]
[3521]
[3522]
[3523]
[3524]
[3525]
[3526]
[3527]
[3528]
[3529]
[3530]
[3531]
[3532]
[3533]
[3534]
[3535]
[3536]
[3537]
[3538]
[3539]
[3540]
[3541]
[3542]
[3543]
[3544]
[3545]
[3546]
[3547]
[3548]
[3549]
[3550]
[3551]
[3552]
[3553]
[3554]
[3555]
[3556]
[3557]
[3558]
[3559]
[3560]
[3561]
[3562]
[3563]
[3564]
[3565]
[3566]
[3567]
[3568]
[3569]
[3570]
[3571]
[3572]
[3573]
[3574]
[3575]
[3576]
[3577]
[3578]
[3579]
[3580]
[3581]
[3582]
[3583]
[3584]
[3585]
[3586]
[3587]
[3588]
[3589]
[3590]
[3591]
[3592]
[3593]
[3594]
[3595]
[3596]
[3597]
[3598]
[3599]
[3600]
[3601]
[3602]
[3603]
[3604]
[3605]
[3606]
[3607]
[3608]
[3609]
[3610]
[3611]
[3612]
[3613]
[3614]
[3615]
[3616]
[3617]
[3618]
[3619]
[3620]
[3621]
[3622]
[3623]
[3624]
[3625]
[3626]
[3627]
[3628]
[3629]
[3630]
[3631]
[3632]
[3633]
[3634]
[3635]
[3636]
[3637]
[3638]
[3639]
[3640]
[3641]
[3642]
[3643]
[3644]
[3645]
[3646]
[3647]
[3648]
[3649]
[3650]
[3651]
[3652]
[3653]
[3654]
[3655]
[3656]
[3657]
[3658]
[3659]
[3660]
[3661]
[3662]
[3663]
[3664]
[3665]
[3666]
[3667]
[3668]
[3669]
[3670]
[3671]
[3672]
[3673]
[3674]
[3675]
[3676]
[3677]
[3678]
[3679]
[3680]
[3681]
[3682]
[3683]
[3684]
[3685]
[3686]
[3687]
[3688]
[3689]
[3690]
[3691]
[3692]
[3693]
[3694]
[3695]
[3696]
[3697]
[3698]
[3699]
[3700]
[3701]
[3702]
[3703]
[3704]
[3705]
[3706]
[3707]
[3708]
[3709]
[3710]
[3711]
[3712]
[3713]
[3714]
[3715]
[3716]
[3717]
[3718]
[3719]
[3720]
[3721]
[3722]
[3723]
[3724]
[3725]
[3726]
[3727]
[3728]
[3729]
[3730]
[3731]
[3732]
[3733]
[3734]
[3735]
[3736]
[3737]
[3738]
[3739]
[3740]
[3741]
[3742]
[3743]
[3744]
[3745]
[3746]
[3747]
[3748]
[3749]
[3750]
[3751]
[3752]
[3753]
[3754]
[3755]
[3756]
[3757]
[3758]
[3759]
[3760]
[3761]
[3762]
[3763]
[3764]
[3765]
[3766]
[3767]
[3768]
[3769]
[3770]
[3771]
[3772]
[3773]
[3774]
[3775]
[3776]
[3777]
[3778]
[3779]
[3780]
[3781]
[3782]
[3783]
[3784]
[3785]
[3786]
[3787]
[3788]
[3789]
[3790]
[3791]
[3792]
[3793]
[3794]
[3795]
[3796]
[3797]
[3798]
[3799]
[3800]
[3801]
[3802]
[3803]
[3804]
[3805]
[3806]
[3807]
[3808]
[3809]
[3810]
[3811]
[3812]
[3813]
[3814]
[3815]
[3816]
[3817]
[3818]
[3819]
[3820]
[3821]
[3822]
[3823]
[3824]
[3825]
[3826]
[3827]
[3828]
[3829]
[3830]
[3831]
[3832]
[3833]
[3834]
[3835]
[3836]
[3837]
[3838]
[3839]
[3840]
[3841]
[3842]
[3843]
[3844]
[3845]
[3846]
[3847]
[3848]
[3849]
[3850]
[3851]
[3852]
[3853]
[3854]
[3855]
[3856]
[3857]
[3858]
[3859]
[3860]
[3861]
[3862]
[3863]
[3864]
[3865]
[3866]
[3867]
[3868]
[3869]
[3870]
[3871]
[3872]
[3873]
[3874]
[3875]
[3876]
[3877]
[3878]
[3879]
[3880]
[3881]
[3882]
[3883]
[3884]
[3885]
[3886]
[3887]
[3888]
[3889]
[3890]
[3891]
[3892]
[3893]
[3894]
[3895]
[3896]
[3897]
[3898]
[3899]
[3900]
[3901]
[3902]
[3903]
[3904]
[3905]
[3906]
[3907]
[3908]
[3909]
[3910]
[3911]
[3912]
[3913]
[3914]
[3915]
[3916]
[3917]
[3918]
[3919]
[3920]
[3921]
[3922]
[3923]
[3924]
[3925]
[3926]
[3927]
[3928]
[3929]
[3930]
[3931]
[3932]
[3933]
[3934]
[3935]
[3936]
[3937]
[3938]
[3939]
[3940]
[3941]
[3942]
[3943]
[3944]
[3945]
[3946]
[3947]
[3948]
[3949]
[3950]
[3951]
[3952]
[3953]
[3954]
[3955]
[3956]
[3957]
[3958]
[3959]
[3960]
[3961]
[3962]
[3963]
[3964]
[3965]
[3966]
[3967]
[3968]
[3969]
[3970]
[3971]
[3972]
[3973]
[3974]
[3975]
[3976]
[3977]
[3978]
[3979]
[3980]
[3981]
[3982]
[3983]
[3984]
[3985]
[3986]
[3987]
[3988]
[3989]
[3990]
[3991]
[3992]
[3993]
[3994]
[3995]
[3996]
[3997]
[3998]
[3999]
[4000]
[4001]
[4002]
[4003]
[4004]
[4005]
[4006]
[4007]
[4008]
[4009]
[4010]
[4011]
[4012]
[4013]
[4014]
[4015]
[4016]
[4017]
[4018]
[4019]
[4020]
[4021]
[4022]
[4023]
[4024]
[4025]
[4026]
[4027]
[4028]
[4029]
[4030]
[4031]
[4032]
[4033]
[4034]
[4035]
[4036]
[4037]
[4038]
[4039]
[4040]
[4041]
[4042]
[4043]
[4044]
[4045]
[4046]
[4047]
[4048]
[4049]
[4050]
[4051]
[4052]
[4053]
[4054]
[4055]
[4056]
[4057]
[4058]
[4059]
[4060]
[4061]
[4062]
[4063]
[4064]
[4065]
[4066]
[4067]
[4068]
[4069]
[4070]
[4071]
[4072]
[4073]
[4074]
[4075]
[4076]
[4077]
[4078]
[4079]
[4080]
[4081]
[4082]
[4083]
[4084]
[4085]
[4086]
[4087]
[4088]
[4089]
[4090]
[4091]
[4092]
[4093]
[4094]
[4095]
[4096]
[4097]
[4098]
[4099]
[4100]
[4101]
[4102]
[4103]
[4104]
[4105]
[4106]
[4107]
[4108]
[4109]
[4110]
[4111]
[4112]
[4113]
[4114]
[4115]
[4116]
[4117]
[4118]
[4119]
[4120]
[4121]
[4122]
[4123]
[4124]
[4125]
[4126]
[4127]
[4128]
[4129]
[4130]
[4131]
[4132]
[4133]
[4134]
[4135]
[4136]
[4137]
[4138]
[4139]
[4140]
[4141]
[4142]
[4143]
[4144]
[4145]
[4146]
[4147]
[4148]
[4149]
[4150]
[4151]
[4152]
[4153]
[4154]
[4155]
[4156]
[4157]
[4158]
[4159]
[4160]
[4161]
[4162]
[4163]
[4164]
[4165]
[4166]
[4167]
[4168]
[4169]
[4170]
[4171]
[4172]
[4173]
[4174]
[4175]
[4176]
[4177]
[4178]
[4179]
[4180]
[4181]
[4182]
[4183]
[4184]
[4185]
[4186]
[4187]
[4188]
[4189]
[4190]
[4191]
[4192]
[4193]
[4194]
[4195]
[4196]
[4197]
[4198]
[4199]
[4200]
[4201]
[4202]
[4203]
[4204]
[4205]
[4206]
[4207]
[4208]
[4209]
[4210]
[4211]
[4212]
[4213]
[4214]
[4215]
[4216]
[4217]
[4218]
[4219]
[4220]
[4221]
[4222]
[4223]
[4224]
[4225]
[4226]
[4227]
[4228]
[4229]
[4230]
[4231]
[4232]
[4233]
[4234]
[4235]
[4236]
[4237]
[4238]
[4239]
[4240]
[4241]
[4242]
[4243]
[4244]
[4245]
[4246]
[4247]
[4248]
[4249]
[4250]
[4251]
[4252]
[4253]
[4254]
[4255]
[4256]
[4257]
[4258]
[4259]
[4260]
[4261]
[4262]
[4263]
[4264]
[4265]
[4266]
[4267]
[4268]
[4269]
[4270]
[4271]
[4272]
[4273]
[4274]
[4275]
[4276]
[4277]
[4278]
[4279]
[4280]
[4281]
[4282]
[4283]
[4284]
[4285]
[4286]
[4287]
[4288]
[4289]
[4290]
[4291]
[4292]
[4293]
[4294]
[4295]
[4296]
[4297]
[4298]
[4299]
[4300]
[4301]
[4302]
[4303]
[4304]
[4305]
[4306]
[4307]
[4308]
[4309]
[4310]
[4311]
[4312]
[4313]
[4314]
[4315]
[4316]
[4317]
[4318]
[4319]
[4320]
[4321]
[4322]
[4323]
[4324]
[4325]
[4326]
[4327]
[4328]
[4329]
[4330]
[4331]
[4332]
[4333]
[4334]
[4335]
[4336]
[4337]
[4338]
[4339]
[4340]
[4341]
[4342]
[4343]
[4344]
[4345]
[4346]
[4347]
[4348]
[4349]
[4350]
[4351]
[4352]
[4353]
[4354]
[4355]
[4356]
[4357]
[4358]
[4359]
[4360]
[4361]
[4362]
[4363]
[4364]
[4365]
[4366]
[4367]
[4368]
[4369]
[4370]
[4371]
[4372]
[4373]
[4374]
[4375]
[4376]
[4377]
[4378]
[4379]
[4380]
[4381]
[4382]
[4383]
[4384]
[4385]
[4386]
[4387]
[4388]
[4389]
[4390]
[4391]
[4392]
[4393]
[4394]
[4395]
[4396]
[4397]
[4398]
[4399]
[4400]
[4401]
[4402]
[4403]
[4404]
[4405]
[4406]
[4407]
[4408]
[4409]
[4410]
[4411]
[4412]
[4413]
[4414]
[4415]
[4416]
[4417]
[4418]
[4419]
[4420]
[4421]
[4422]
[4423]
[4424]
[4425]
[4426]
[4427]
[4428]
[4429]
[4430]
[4431]
[4432]
[4433]
[4434]
[4435]
[4436]
[4437]
[4438]
[4439]
[4440]
[4441]
[4442]
[4443]
[4444]
[4445]
[4446]
[4447]
[4448]
[4449]
[4450]
[4451]
[4452]
[4453]
[4454]
[4455]
[4456]
[4457]
[4458]
[4459]
[4460]
[4461]
[4462]
[4463]
[4464]
[4465]
[4466]
[4467]
[4468]
[4469]
[4470]
[4471]
[4472]
[4473]
[4474]
[4475]
[4476]
[4477]
[4478]
[4479]
[4480]
[4481]
[4482]
[4483]
[4484]
[4485]
[4486]
[4487]
[4488]
[4489]
[4490]
[4491]
[4492]
[4493]
[4494]
[4495]
[4496]
[4497]
[4498]
[4499]
[4500]
[4501]
[4502]
[4503]
[4504]
[4505]
[4506]
[4507]
[4508]
[4509]
[4510]
[4511]
[4512]
[4513]
[4514]
[4515]
[4516]
[4517]
[4518]
[4519]
[4520]
[4521]
[4522]
[4523]
[4524]
[4525]
[4526]
[4527]
[4528]
[4529]
[4530]
[4531]
[4532]
[4533]
[4534]
[4535]
[4536]
[4537]
[4538]
[4539]
[4540]
[4541]
[4542]
[4543]
[4544]
[4545]
[4546]
[4547]
[4548]
[4549]
[4550]
[4551]
[4552]
[4553]
[4554]
[4555]
[4556]
[4557]
[4558]
[4559]
[4560]
[4561]
[4562]
[4563]
[4564]
[4565]
[4566]
[4567]
[4568]
[4569]
[4570]
[4571]
[4572]
[4573]
[4574]
[4575]
[4576]
[4577]
[4578]
[4579]
[4580]
[4581]
[4582]
[4583]
[4584]
[4585]
[4586]
[4587]
[4588]
[4589]
[4590]
[4591]
[4592]
[4593]
[4594]
[4595]
[4596]
[4597]
[4598]
[4599]
[4600]
[4601]
[4602]
[4603]
[4604]
[4605]
[4606]
[4607]
[4608]
[4609]
[4610]
[4611]
[4612]
[4613]
[4614]
[4615]
[4616]
[4617]
[4618]
[4619]
[4620]
[4621]
[4622]
[4623]
[4624]
[4625]
[4626]
[4627]
[4628]
[4629]
[4630]
[4631]
[4632]
[4633]
[4634]
[4635]
[4636]
[4637]
[4638]
[4639]
[4640]
[4641]
[4642]
[4643]
[4644]
[4645]
[4646]
[4647]
[4648]
[4649]
[4650]
[4651]
[4652]
[4653]
[4654]
[4655]
[4656]
[4657]
[4658]
[4659]
[4660]
[4661]
[4662]
[4663]
[4664]
[4665]
[4666]
[4667]
[4668]
[4669]
[4670]
[4671]
[4672]
[4673]
[4674]
[4675]
[4676]
[4677]
[4678]
[4679]
[4680]
[4681]
[4682]
[4683]
[4684]
[4685]
[4686]
[4687]
[4688]
[4689]
[4690]
[4691]
[4692]
[4693]
[4694]
[4695]
[4696]
[4697]
[4698]
[4699]
[4700]
[4701]
[4702]
[4703]
[4704]
[4705]
[4706]
[4707]
[4708]
[4709]
[4710]
[4711]
[4712]
[4713]
[4714]
[4715]
[4716]
[4717]
[4718]
[4719]
[4720]
[4721]
[4722]
[4723]
[4724]
[4725]
[4726]
[4727]
[4728]
[4729]
[4730]
[4731]
[4732]
[4733]
[4734]
[4735]
[4736]
[4737]
[4738]
[4739]
[4740]
[4741]
[4742]
[4743]
[4744]
[4745]
[4746]
[4747]
[4748]
[4749]
[4750]
[4751]
[4752]
[4753]
[4754]
[4755]
[4756]
[4757]
[4758]
[4759]
[4760]
[4761]
[4762]
[4763]
[4764]
[4765]
[4766]
[4767]
[4768]
[4769]
[4770]
[4771]
[4772]
[4773]
[4774]
[4775]
[4776]
[4777]
[4778]
[4779]
[4780]
[4781]
[4782]
[4783]
[4784]
[4785]
[4786]
[4787]
[4788]
[4789]
[4790]
[4791]
[4792]
[4793]
[4794]
[4795]
[4796]
[4797]
[4798]
[4799]
[4800]
[4801]
[4802]
[4803]
[4804]
[4805]
[4806]
[4807]
[4808]
[4809]
[4810]
[4811]
[4812]
[4813]
[4814]
[4815]
[4816]
[4817]
[4818]
[4819]
[4820]
[4821]
[4822]
[4823]
[4824]
[4825]
[4826]
[4827]
[4828]
[4829]
[4830]
[4831]
[4832]
[4833]
[4834]
[4835]
[4836]
[4837]
[4838]
[4839]
[4840]
[4841]
[4842]
[4843]
[4844]
[4845]
[4846]
[4847]
[4848]
[4849]
[4850]
[4851]
[4852]
[4853]
[4854]
[4855]
[4856]
[4857]
[4858]
[4859]
[4860]
[4861]
[4862]
[4863]
[4864]
[4865]
[4866]
[4867]
[4868]
[4869]
[4870]
[4871]
[4872]
[4873]
[4874]
[4875]
[4876]
[4877]
[4878]
[4879]
[4880]
[4881]
[4882]
[4883]
[4884]
[4885]
[4886]
[4887]
[4888]
[4889]
[4890]
[4891]
[4892]
[4893]
[4894]
[4895]
[4896]
[4897]
[4898]
[4899]
[4900]
[4901]
[4902]
[4903]
[4904]
[4905]
[4906]
[4907]
[4908]
[4909]
[4910]
[4911]
[4912]
[4913]
[4914]
[4915]
[4916]
[4917]
[4918]
[4919]
[4920]
[4921]
[4922]
[4923]
[4924]
[4925]
[4926]
[4927]
[4928]
[4929]
[4930]
[4931]
[4932]
[4933]
[4934]
[4935]
[4936]
[4937]
[4938]
[4939]
[4940]
[4941]
[4942]
[4943]
[4944]
[4945]
[4946]
[4947]
[4948]
[4949]
[4950]
[4951]
[4952]
[4953]
[4954]
[4955]
[4956]
[4957]
[4958]
[4959]
[4960]
[4961]
[4962]
[4963]
[4964]
[4965]
[4966]
[4967]
[4968]
[4969]
[4970]
[4971]
[4972]
[4973]
[4974]
[4975]
[4976]
[4977]
[4978]
[4979]
[4980]
[4981]
[4982]
[4983]
[4984]
[4985]
[4986]
[4987]
[4988]
[4989]
[4990]
[4991]
[4992]
[4993]
[4994]
[4995]
[4996]
[4997]
[4998]
[4999]
[5000]

{"sheet":"1st Qtr.","index":8,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,7,82,9],[77,7,77,9],[78,7,78,9],[79,7,79,9],[80,7,80,9],[81,7,81,9],[0,0,0,9],[1,0,1,9],[18,9,19,9],[76,7,76,9],[50,9,51,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Q1 Financial Summary"]
[]
["GAMING STATISTIC SUMMARY",{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},null,"Acquired/",null,"Sold/",null,{"$f":"+B4","v":"Q1 2021"}]
[null,"Beginning",null,"Installed",null,"Removed",null,"Ending"]
["No. of Live Establishments",{"$f":"COUNTIF('Use Agreement Tracking'!J4:J1048576,\"<=\"&'Graph Data'!A24)-COUNTIFS('Use Agreement Tracking'!N4:N1048576,\"<=\"&'Graph Data'!A24,'Use Agreement Tracking'!J4:J1048576,\"<>\")","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!J4:J65000,\">\"&'Graph Data'!A24,'Use Agreement Tracking'!J4:J65000,\"<=\"&'Graph Data'!A20)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N4:N65000,\">\"&'Graph Data'!A24,'Use Agreement Tracking'!N4:N65000,\"<=\"&'Graph Data'!A20,'Use Agreement Tracking'!J4:J65000,\"<>\")","v":0},null,{"$f":"+B6+D6-F6","v":0}]
["No. of VGTs",{"$f":"+'Financial Stmt Data Entry'!H6","v":0},null,null,null,null,null,{"$f":"+B7+D7-F7","v":0},null,{"$f":"IF(H7<>'Financial Stmt Data Entry'!G6,\"Does Not Match Financial Stmt Data Entry\",\"\")","v":""}]
["No. of Use Agreements",{"$f":"COUNTIF('Use Agreement Tracking'!H3:H63360,\"<=\"&'Graph Data'!A24)-COUNTIF('Use Agreement Tracking'!N3:N63360,\"<=\"&'Graph Data'!A24)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!H3:H63360,\">\"&'Graph Data'!A24,'Use Agreement Tracking'!H3:H63360,\"<=\"&'Graph Data'!A20)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N3:N63360,\">\"&+'Graph Data'!A24,'Use Agreement Tracking'!N3:N63360,\"<=\"&+'Graph Data'!A20)","v":0},null,{"$f":"+B8+D8-F8","v":0}]
[null,"Beginning",null,"Hired",null,"Terminated",null,"Ending"]
["No. of Permanent Employees",null,null,null,null,null,null,{"$f":"+B10+D10-F10","v":0}]
["No. of Independent Contractors",null,null,null,null,null,null,{"$f":"+B11+D11-F11","v":0}]
[null,{"$f":"+B4","v":"Q1 2021"},null,{"$f":"+'Financial Stmt Data Entry'!H4","v":"Q4 2020"},null,"Difference"]
["Amount Played",null,null,null,null,{"$f":"+B13-D13","v":0}]
["Average per terminal income per day",{"$f":"IFERROR(IF(Questionnaire!$D$39<+'Graph Data'!C20,+B24/+'Graph Data'!B20/H7,(+B24/(+'Graph Data'!C21-Questionnaire!$D$39)/H7)),0)","v":0},null,{"$f":"IFERROR(IF(Questionnaire!$D$39<'Graph Data'!C24,+D24/+'Graph Data'!B24/B7,(+D24/(+'Graph Data'!A24-Questionnaire!$D$39)/B7)),0)","v":0},null,{"$f":"+B14-D14","v":0}]
["Aggregate Hold",{"$f":"IFERROR(+B24/B13,0)","v":0},null,{"$f":"IFERROR(+D24/D13,0)","v":0},null,0]
["Gaming Tax % of NTI",{"$f":"IFERROR(+B26/B24,0)","v":0},null,{"$f":"IFERROR(+D26/D24,0)","v":0},null,{"$f":"+B16-D16","v":0}]
["Gaming Administrative Fee % of NTI",{"$f":"IFERROR(+B28/B24,0)","v":0},null,{"$f":"IFERROR(+D28/D24,0)","v":0},null,{"$f":"+B17-D17","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["INCOME STATEMENT",{"$f":"+B12","v":"Q1 2021"},null,{"$f":"+D12","v":"Q4 2020"},null,"Difference",null,"Absolute %"]
["Video Gaming:"]
["Gross Revenue (Funds In)",{"$f":"+'Financial Stmt Data Entry'!G11","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H11","v":0},null,{"$f":"B22-D22","v":0},null,{"$f":"+ABS(F22)/(IF(D22=0, 1, ABS(D22)))","v":0}]
["Payouts (Funds Out)",{"$f":"-'Financial Stmt Data Entry'!G12","v":0},null,{"$f":"-'Financial Stmt Data Entry'!H12","v":0},null,{"$f":"B23-D23","v":0},null,{"$f":"+ABS(F23)/(IF(D23=0, 1, ABS(D23)))","v":0}]
["Net Terminal Income",{"$f":"SUM(B22:B23)","v":0},null,{"$f":"SUM(D22:D23)","v":0},null,{"$f":"SUM(F22:F23)","v":0},null,0]
["Cost of Sales",null,null,null,null,null,null,0]
["   Gaming Tax",{"$f":"+'Financial Stmt Data Entry'!G25","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H25","v":0},null,{"$f":"B26-D26","v":0},null,0]
["   Establishment Revenue Share",{"$f":"+'Financial Stmt Data Entry'!G26","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H26","v":0},null,0,null,0]
["   Gaming Administrative Fee",{"$f":"+'Financial Stmt Data Entry'!G28","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H28","v":0},null,0,null,0]
["   Other Revenue Share Agreements",{"$f":"+'Financial Stmt Data Entry'!G27","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H27","v":0},null,0,null,0]
["   Personnel",{"$f":"+'Financial Stmt Data Entry'!G30+'Financial Stmt Data Entry'!G31+'Financial Stmt Data Entry'!G32+'Financial Stmt Data Entry'!G33","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H30+'Financial Stmt Data Entry'!H31+'Financial Stmt Data Entry'!H32+'Financial Stmt Data Entry'!H33","v":0},null,0,null,0]
["   Equipment Leasing",{"$f":"+'Financial Stmt Data Entry'!G29","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H29","v":0},null,0,null,0]
["   Other cost of sales",{"$f":"+'Financial Stmt Data Entry'!G34+'Financial Stmt Data Entry'!G35+'Financial Stmt Data Entry'!G36+'Financial Stmt Data Entry'!G37+'Financial Stmt Data Entry'!G38+'Financial Stmt Data Entry'!G39+'Financial Stmt Data Entry'!G41+'Financial Stmt Data Entry'!G40","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H34+'Financial Stmt Data Entry'!H35+'Financial Stmt Data Entry'!H36+'Financial Stmt Data Entry'!H37+'Financial Stmt Data Entry'!H38+'Financial Stmt Data Entry'!H39+'Financial Stmt Data Entry'!H41+'Financial Stmt Data Entry'!H40","v":0},null,0,null,0]
["Total Cost of Sales",{"$f":"SUM(B26:B32)","v":0},null,{"$f":"SUM(D26:D32)","v":0},null,{"$f":"SUM(F26:F32)","v":0},null,0]
["     Gross Profit Video Gaming",{"$f":"B24-B33","v":0},null,{"$f":"D24-D33","v":0},null,{"$f":"F24-F33","v":0},null,0]
["Amusement & Other:",null,null,null,null,null,null,{"$f":"+ABS(F35)/(IF(D35=0, 1, ABS(D35)))","v":0}]
["Amusement Revenue",{"$f":"+'Financial Stmt Data Entry'!G16","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H16","v":0},null,{"$f":"B36-D36","v":0},null,0]
["Other Revenue",{"$f":"+'Financial Stmt Data Entry'!G17+'Financial Stmt Data Entry'!G18+'Financial Stmt Data Entry'!G19","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H17+'Financial Stmt Data Entry'!H18+'Financial Stmt Data Entry'!H19","v":0},null,{"$f":"B37-D37","v":0},null,0]
["   Total Amusement & Other",{"$f":"+B37+B36","v":0},null,{"$f":"+D37+D36","v":0},null,{"$f":"+F37+F36","v":0},null,0]
["Amusement & Other Cost of Sales",{"$f":"+'Financial Stmt Data Entry'!G60","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H60","v":0},null,{"$f":"B39-D39","v":0},null,0]
["     Gross Profit Amusement & Other",{"$f":"+B38-B39","v":0},null,{"$f":"+D38-D39","v":0},null,{"$f":"+F38-F39","v":0},null,0]
["          Total Gross Profit",{"$f":"+B40+B34","v":0},null,{"$f":"+D34+D40","v":0},null,{"$f":"+F40+F34","v":0},null,0]
["Total General & Administrative Expense",{"$f":"+'Financial Stmt Data Entry'!G120","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H120","v":0},null,{"$f":"+B42-D42","v":0},null,0]
["          EBITDAE",{"$f":"B41-B42","v":0},null,{"$f":"D41-D42","v":0},null,0,null,0]
["Interest Income",{"$f":"+'Financial Stmt Data Entry'!G128","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H128","v":0},null,0,null,0]
["Interest Expense",{"$f":"+'Financial Stmt Data Entry'!G129","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H129","v":0},null,0,null,0]
["Depreciation /Amortization",{"$f":"+'Financial Stmt Data Entry'!G131+'Financial Stmt Data Entry'!G132","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H131+'Financial Stmt Data Entry'!H132","v":0},null,0,null,0]
["Gain (Loss) on Sale of Fixed Asset",{"$f":"+'Financial Stmt Data Entry'!G133","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H133","v":0},null,0,null,0]
["Other",{"$f":"+'Financial Stmt Data Entry'!G134+'Financial Stmt Data Entry'!G135-'Financial Stmt Data Entry'!G130","v":0},null,{"$f":"'Financial Stmt Data Entry'!H134+'Financial Stmt Data Entry'!H135-'Financial Stmt Data Entry'!H130","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+B43+B44-B45-B46+B48+B47","v":0},{"$f":"+C43+C44-C45-C46-C48+C47","v":0},{"$f":"+D43+D44-D45-D46+D48+D47","v":0},{"$f":"+E43+E44-E45-E46-E48","v":0},0,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["BALANCE SHEET",{"$f":"+B20","v":"Q1 2021"},null,{"$f":"+D20","v":"Q4 2020"},null,"Difference",null,"Absolute %"]
["Cash & Cash Equivalents",{"$f":"+'Financial Stmt Data Entry'!G149","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H149","v":0},null,{"$f":"B53-D53","v":0},null,0]
["Accounts Receivable",{"$f":"+'Financial Stmt Data Entry'!G153","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H153","v":0},null,{"$f":"B54-D54","v":0},null,0]
["Inventories",{"$f":"+'Financial Stmt Data Entry'!G165","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H165","v":0},null,0,null,0]
["Other Current Assets",{"$f":"+'Financial Stmt Data Entry'!G159+'Financial Stmt Data Entry'!G161+'Financial Stmt Data Entry'!G167","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H159+'Financial Stmt Data Entry'!H161+'Financial Stmt Data Entry'!H167","v":0},null,0,null,0]
["     Total Current Assets",{"$f":"SUM(B53:B56)","v":0},null,{"$f":"SUM(D53:D56)","v":0},{"$f":"SUM(E53:E56)","v":0},0,null,0]
["Property & Equipment, net",{"$f":"+'Financial Stmt Data Entry'!G181","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H181","v":0},null,0,null,0]
["Goodwill & Intangiblles",{"$f":"+'Financial Stmt Data Entry'!G192","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H192","v":0},null,0,null,0]
["Other Assets",{"$f":"+'Financial Stmt Data Entry'!G185+'Financial Stmt Data Entry'!G196","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H185+'Financial Stmt Data Entry'!H196","v":0},null,0,null,0]
["          Total Assets",{"$f":"SUM(B57:B60)","v":0},null,{"$f":"SUM(D57:D60)","v":0},null,0,null,0]
[null,null,null,null,null,null,null,0]
["Accounts Payable & Accrued Liabilities",{"$f":"+'Financial Stmt Data Entry'!G223","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H223","v":0},null,0,null,0]
["Current portion of L/T debt",{"$f":"+'Financial Stmt Data Entry'!G206","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H206","v":0},null,0,null,0]
["Other current liabilities",{"$f":"+'Financial Stmt Data Entry'!G228","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H228","v":0},null,0,null,0]
["     Total Current Liabilities",{"$f":"SUM(B63:B65)","v":0},null,{"$f":"SUM(D63:D65)","v":0},null,0,null,0]
["Long-Term Debt",{"$f":"+'Financial Stmt Data Entry'!G236","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H236","v":0},null,0,null,0]
["Other Long-term Liabilities",{"$f":"+'Financial Stmt Data Entry'!G240","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H240","v":0},null,0,null,0]
["     Total Liabilities",{"$f":"+B68+B67+B66","v":0},null,{"$f":"+D68+D67+D66","v":0},null,0,null,0]
["Capital",{"$f":"+'Financial Stmt Data Entry'!G249","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H249","v":0},null,0,null,0]
["Retained Earnings",{"$f":"+'Financial Stmt Data Entry'!G251","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H251","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+'Financial Stmt Data Entry'!G252","v":0},null,{"$f":"+'Financial Stmt Data Entry'!H252","v":0},null,0,null,0]
["     Total Stockholder Equity",{"$f":"+B72+B71+B70","v":0},null,{"$f":"+D72+D71+D70","v":0},null,0,null,0]
["          Total Liabilities & Stockholder Equity ",{"$f":"+B73+B69","v":0},null,{"$f":"+D73+D69","v":0},null,{"$f":"+F73+F69","v":0},null,0]
[]
["Ratio Analysis"]
["Gross Profit Margin",{"$f":"IFERROR(+B41/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D41/(D24+D38),0)","v":0},null,{"$f":"+B77-D77","v":0},null,"Total Gross Profit/(NTI + Amusement & Other Rev.)"]
["Net Profit Margin",{"$f":"IFERROR(+B49/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D49/(D24+D38),0)","v":0},null,{"$f":"+B78-D78","v":0},null,"Net Inc (Loss)/(NTI + Amusement & Other Rev.)"]
["Return on Assets",{"$f":"IFERROR(+B49/((B61+D61)/2),0)","v":0},null,{"$f":"IFERROR(+D49/((D61+'Financial Stmt Data Entry'!J198)/2),)","v":0},null,{"$f":"+B79-D79","v":0},null,"Net Inc (Loss)/(Avg. of Last two Periods Total Assets)"]
["Debt Ratio",{"$f":"IFERROR((B64+B67)/B61,0)","v":0},":1",{"$f":"IFERROR((+D67+D64)/D61,0)","v":0},":1",{"$f":"+B80-D80","v":0},":1","(Current Debt + Long Term Debt)/Total Assets"]
["Interest Coverage Ratio",{"$f":"IFERROR(+B43/B45,0)","v":0},":1",{"$f":"IFERROR(+D43/D45,0)","v":0},":1",{"$f":"+B81-D81","v":0},":1","EBITDA/Interest Expense"]
["Liability Ratio",{"$f":"IFERROR(+B69/B61,0)","v":0},":1",{"$f":"IFERROR(+D69/D61,0)","v":0},":1",0,":1","Total Liabilities/Total Assets"]
["Net Working Capital Ratio",{"$f":"IFERROR((+B57-B66)/B61,0)","v":0},":1",{"$f":"IFERROR((+D57-D66)/D61,0)","v":0},":1",0,":1","(Current Assets - Current Liabilities)/Total Assets"]

{"sheet":"2nd Qtr.","index":9,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,7,82,9],[77,7,77,9],[78,7,78,9],[79,7,79,9],[80,7,80,9],[81,7,81,9],[0,0,0,9],[1,0,1,9],[18,9,19,9],[50,9,51,9],[76,7,76,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Q2 Financial Summary"]
[]
["GAMING STATISTIC SUMMARY",{"$f":"+'Financial Stmt Data Entry'!F4:F5","v":"Q2 2021"},null,"Acquired/",null,"Sold/",null,{"$f":"+B4","v":"Q2 2021"}]
[null,"Beginning",null,"Installed",null,"Removed",null,"Ending"]
["No. of Live Establishments",{"$f":"+'1st Qtr.'!H6","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!J4:J65000,\">\"&'Graph Data'!A20,'Use Agreement Tracking'!J4:J65000,\"<=\"&'Graph Data'!A21)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N4:N65000,\">\"&'Graph Data'!A20,'Use Agreement Tracking'!N4:N65000,\"<=\"&'Graph Data'!A21,'Use Agreement Tracking'!J4:J65000,\"<>\")","v":0},null,{"$f":"+B6+D6-F6","v":0}]
["No. of VGTs",{"$f":"+'1st Qtr.'!H7","v":0},null,null,null,null,null,{"$f":"+B7+D7-F7","v":0},null,{"$f":"IF(H7<>'Financial Stmt Data Entry'!F6,\"Does Not Match Financial Stmt Data Entry\",\"\")","v":""}]
["No. of Use Agreements",{"$f":"+'1st Qtr.'!H8","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!H3:H63360,\">\"&'Graph Data'!A20,'Use Agreement Tracking'!H3:H63360,\"<=\"&'Graph Data'!A21)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N3:N63360,\">\"&+'Graph Data'!A20,'Use Agreement Tracking'!N3:N63360,\"<=\"&+'Graph Data'!A21)","v":0},null,{"$f":"+B8+D8-F8","v":0}]
[null,"Beginning",null,"Hired",null,"Terminated",null,"Ending"]
["No. of Permanent Employees",{"$f":"+'1st Qtr.'!H10","v":0},null,null,null,null,null,{"$f":"+B10+D10-F10","v":0}]
["No. of Independent Contractors",{"$f":"+'1st Qtr.'!H11","v":0},null,null,null,null,null,{"$f":"+B11+D11-F11","v":0}]
[null,{"$f":"+B4","v":"Q2 2021"},null,{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},null,"Difference"]
["Amount Played",null,null,{"$f":"+'1st Qtr.'!B13","v":0},null,{"$f":"+B13-D13","v":0}]
["Average per terminal income per day",{"$f":"IFERROR(IF(Questionnaire!$D$39<+'Graph Data'!C21,+B24/+'Graph Data'!B21/H7,(+B24/(+'Graph Data'!C22-Questionnaire!$D$39)/H7)),0)","v":0},null,{"$f":"+'1st Qtr.'!B14","v":0},null,{"$f":"+B14-D14","v":0}]
["Aggregate Hold",{"$f":"IFERROR(+B24/B13,0)","v":0},null,{"$f":"IFERROR(+D24/D13,0)","v":0},null,0]
["Gaming Tax % of NTI",{"$f":"IFERROR(+B26/B24,0)","v":0},null,{"$f":"IFERROR(+D26/D24,0)","v":0},null,{"$f":"+B16-D16","v":0}]
["Gaming Administrative Fee % of NTI",{"$f":"IFERROR(+B28/B24,0)","v":0},null,{"$f":"IFERROR(+D28/D24,0)","v":0},null,{"$f":"+B17-D17","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["INCOME STATEMENT",{"$f":"+B12","v":"Q2 2021"},null,{"$f":"+D12","v":"Q1 2021"},null,"Difference",null,"Absolute %"]
["Video Gaming:"]
["Gross Revenue (Funds In)",{"$f":"+'Financial Stmt Data Entry'!F11","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G11","v":0},null,{"$f":"B22-D22","v":0},null,{"$f":"+ABS(F22)/(IF(D22=0, 1, ABS(D22)))","v":0}]
["Payouts (Funds Out)",{"$f":"-'Financial Stmt Data Entry'!F12","v":0},null,{"$f":"-'Financial Stmt Data Entry'!G12","v":0},null,{"$f":"B23-D23","v":0},null,0]
["Net Terminal Income",{"$f":"SUM(B22:B23)","v":0},null,{"$f":"SUM(D22:D23)","v":0},null,{"$f":"SUM(F22:F23)","v":0},null,0]
["Cost of Sales",null,null,null,null,null,null,0]
["   Gaming Tax",{"$f":"+'Financial Stmt Data Entry'!F25","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G25","v":0},null,{"$f":"B26-D26","v":0},null,0]
["   Establishment Revenue Share",{"$f":"+'Financial Stmt Data Entry'!F26","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G26","v":0},null,0,null,0]
["   Gaming Administrative Fee",{"$f":"+'Financial Stmt Data Entry'!F28","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G28","v":0},null,0,null,0]
["   Other Revenue Share Agreements",{"$f":"+'Financial Stmt Data Entry'!F27","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G27","v":0},null,0,null,0]
["   Personnel",{"$f":"+'Financial Stmt Data Entry'!F30+'Financial Stmt Data Entry'!F31+'Financial Stmt Data Entry'!F32+'Financial Stmt Data Entry'!F33","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G30+'Financial Stmt Data Entry'!G31+'Financial Stmt Data Entry'!G32+'Financial Stmt Data Entry'!G33","v":0},null,0,null,0]
["   Equipment Leasing",{"$f":"+'Financial Stmt Data Entry'!F29","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G29","v":0},null,0,null,0]
["   Other cost of sales",{"$f":"+'Financial Stmt Data Entry'!F34+'Financial Stmt Data Entry'!F35+'Financial Stmt Data Entry'!F36+'Financial Stmt Data Entry'!F37+'Financial Stmt Data Entry'!F38+'Financial Stmt Data Entry'!F39+'Financial Stmt Data Entry'!F41+'Financial Stmt Data Entry'!F40","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G34+'Financial Stmt Data Entry'!G35+'Financial Stmt Data Entry'!G36+'Financial Stmt Data Entry'!G37+'Financial Stmt Data Entry'!G38+'Financial Stmt Data Entry'!G39+'Financial Stmt Data Entry'!G41+'Financial Stmt Data Entry'!G40","v":0},null,0,null,0]
["Total Cost of Sales",{"$f":"SUM(B26:B32)","v":0},null,{"$f":"SUM(D26:D32)","v":0},null,{"$f":"SUM(F26:F32)","v":0},null,0]
["     Gross Profit Video Gaming",{"$f":"B24-B33","v":0},null,{"$f":"D24-D33","v":0},null,{"$f":"F24-F33","v":0},null,0]
["Amusement & Other:"]
["Amusement Revenue",{"$f":"+'Financial Stmt Data Entry'!F16","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G16","v":0},null,{"$f":"B36-D36","v":0},null,0]
["Other Revenue",{"$f":"+'Financial Stmt Data Entry'!F17+'Financial Stmt Data Entry'!F18+'Financial Stmt Data Entry'!F19","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G17+'Financial Stmt Data Entry'!G18+'Financial Stmt Data Entry'!G19","v":0},null,{"$f":"B37-D37","v":0},null,0]
["   Total Amusement & Other",{"$f":"+B37+B36","v":0},null,{"$f":"+D37+D36","v":0},null,{"$f":"+F37+F36","v":0},null,0]
["Amusement & Other Cost of Sales",{"$f":"+'Financial Stmt Data Entry'!F60","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G60","v":0},null,{"$f":"B39-D39","v":0},null,0]
["     Gross Profit Amusement & Other",{"$f":"+B38-B39","v":0},null,{"$f":"+D38-D39","v":0},null,{"$f":"+F38-F39","v":0},null,0]
["          Total Gross Profit",{"$f":"+B40+B34","v":0},null,{"$f":"+D34+D40","v":0},null,{"$f":"+F40+F34","v":0},null,0]
["Total General & Administrative Expense",{"$f":"+'Financial Stmt Data Entry'!F120","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G120","v":0},null,{"$f":"+B42-D42","v":0},null,0]
["          EBITDAE",{"$f":"B41-B42","v":0},null,{"$f":"D41-D42","v":0},null,0,null,0]
["Interest Income",{"$f":"+'Financial Stmt Data Entry'!F128","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G128","v":0},null,0,null,0]
["Interest Expense",{"$f":"+'Financial Stmt Data Entry'!F129","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G129","v":0},null,0,null,0]
["Depreciation /Amortization",{"$f":"+'Financial Stmt Data Entry'!F131+'Financial Stmt Data Entry'!F132","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G131+'Financial Stmt Data Entry'!G132","v":0},null,0,null,0]
["Gain (Loss) on Sale of Fixed Asset",{"$f":"+'Financial Stmt Data Entry'!F133","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G133","v":0},null,0,null,0]
["Other",{"$f":"+'Financial Stmt Data Entry'!F134+'Financial Stmt Data Entry'!F135-'Financial Stmt Data Entry'!F130","v":0},null,{"$f":"'Financial Stmt Data Entry'!G134+'Financial Stmt Data Entry'!G135-'Financial Stmt Data Entry'!G130","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+B43+B44-B45-B46+B48+B47","v":0},{"$f":"+C43+C44-C45-C46-C48+C47","v":0},{"$f":"+D43+D44-D45-D46+D48+D47","v":0},{"$f":"+E43+E44-E45-E46-E48","v":0},0,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["BALANCE SHEET",{"$f":"+B20","v":"Q2 2021"},null,{"$f":"+D20","v":"Q1 2021"},null,"Difference",null,"Absolute %"]
["Cash & Cash Equivalents",{"$f":"+'Financial Stmt Data Entry'!F149","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G149","v":0},null,{"$f":"B53-D53","v":0},null,{"$f":"+ABS(F53)/(IF(D53=0, 1, ABS(D53)))","v":0}]
["Accounts Receivable",{"$f":"+'Financial Stmt Data Entry'!F153","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G153","v":0},null,{"$f":"B54-D54","v":0},null,0]
["Inventories",{"$f":"+'Financial Stmt Data Entry'!F165","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G165","v":0},null,0,null,0]
["Other Current Assets",{"$f":"+'Financial Stmt Data Entry'!F159+'Financial Stmt Data Entry'!F161+'Financial Stmt Data Entry'!F167","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G159+'Financial Stmt Data Entry'!G161+'Financial Stmt Data Entry'!G167","v":0},null,0,null,0]
["     Total Current Assets",{"$f":"SUM(B53:B56)","v":0},null,{"$f":"SUM(D53:D56)","v":0},{"$f":"SUM(E53:E56)","v":0},0,null,0]
["Property & Equipment, net",{"$f":"+'Financial Stmt Data Entry'!F181","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G181","v":0},null,0,null,0]
["Goodwill & Intangiblles",{"$f":"+'Financial Stmt Data Entry'!F192","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G192","v":0},null,0,null,0]
["Other Assets",{"$f":"+'Financial Stmt Data Entry'!F185+'Financial Stmt Data Entry'!F196","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G185+'Financial Stmt Data Entry'!G196","v":0},null,0,null,0]
["          Total Assets",{"$f":"SUM(B57:B60)","v":0},null,{"$f":"SUM(D57:D60)","v":0},null,0,null,0]
[]
["Accounts Payable & Accrued Liabilities",{"$f":"+'Financial Stmt Data Entry'!F223","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G223","v":0},null,0,null,{"$f":"+ABS(F63)/(IF(D63=0, 1, ABS(D63)))","v":0}]
["Current portion of L/T debt",{"$f":"+'Financial Stmt Data Entry'!F206","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G206","v":0},null,0,null,0]
["Other current liabilities",{"$f":"+'Financial Stmt Data Entry'!F228","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G228","v":0},null,0,null,0]
["     Total Current Liabilities",{"$f":"SUM(B63:B65)","v":0},null,{"$f":"SUM(D63:D65)","v":0},null,0,null,0]
["Long-Term Debt",{"$f":"+'Financial Stmt Data Entry'!F236","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G236","v":0},null,0,null,0]
["Other Long-term Liabilities",{"$f":"+'Financial Stmt Data Entry'!F240","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G240","v":0},null,0,null,0]
["     Total Liabilities",{"$f":"+B68+B67+B66","v":0},null,{"$f":"+D68+D67+D66","v":0},null,0,null,0]
["Capital",{"$f":"+'Financial Stmt Data Entry'!F249","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G249","v":0},null,0,null,0]
["Retained Earnings",{"$f":"+'Financial Stmt Data Entry'!F251","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G251","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+'Financial Stmt Data Entry'!F252","v":0},null,{"$f":"+'Financial Stmt Data Entry'!G252","v":0},null,0,null,0]
["     Total Stockholder Equity",{"$f":"+B72+B71+B70","v":0},null,{"$f":"+D72+D71+D70","v":0},null,0,null,0]
["          Total Liabilities & Stockholder Equity ",{"$f":"+B73+B69","v":0},null,{"$f":"+D73+D69","v":0},null,{"$f":"+F73+F69","v":0},null,0]
[]
["Ratio Analysis"]
["Gross Profit Margin",{"$f":"IFERROR(+B41/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D41/(D24+D38),0)","v":0},null,{"$f":"+B77-D77","v":0},null,"Total Gross Profit/(NTI + Amusement & Other Rev.)"]
["Net Profit Margin",{"$f":"IFERROR(+B49/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D49/(D24+D38),0)","v":0},null,{"$f":"+B78-D78","v":0},null,"Net Inc (Loss)/(NTI + Amusement & Other Rev.)"]
["Return on Assets",{"$f":"IFERROR(+B49/((B61+D61)/2),0)","v":0},null,{"$f":"IFERROR(+D49/((D61+'Financial Stmt Data Entry'!H198)/2),)","v":0},null,{"$f":"+B79-D79","v":0},null,"Net Inc (Loss)/(Avg. of Last two Periods Total Assets)"]
["Debt Ratio",{"$f":"IFERROR((B64+B67)/B61,0)","v":0},":1",{"$f":"IFERROR((+D67+D64)/D61,0)","v":0},":1",{"$f":"+B80-D80","v":0},":1","(Current Debt + Long Term Debt)/Total Assets"]
["Interest Coverage Ratio",{"$f":"IFERROR(+B43/B45,0)","v":0},":1",{"$f":"IFERROR(+D43/D45,0)","v":0},":1",{"$f":"+B81-D81","v":0},":1","EBITDA/Interest Expense"]
["Liability Ratio",{"$f":"IFERROR(+B69/B61,0)","v":0},":1",{"$f":"IFERROR(+D69/D61,0)","v":0},":1",0,":1","Total Liabilities/Total Assets"]
["Net Working Capital Ratio",{"$f":"IFERROR((+B57-B66)/B61,0)","v":0},":1",{"$f":"IFERROR((+D57-D66)/D61,0)","v":0},":1",0,":1","(Current Assets - Current Liabilities)/Total Assets"]

{"sheet":"3rd Qtr.","index":10,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,7,82,9],[77,7,77,9],[78,7,78,9],[79,7,79,9],[80,7,80,9],[81,7,81,9],[0,0,0,9],[1,0,1,9],[18,9,19,9],[50,9,51,9],[76,7,76,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Q3 Financial Summary"]
[]
["GAMING STATISTIC SUMMARY",{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},null,"Acquired/",null,"Sold/",null,{"$f":"+B4","v":"Q3 2021"}]
[null,"Beginning",null,"Installed",null,"Removed",null,"Ending"]
["No. of Live Establishments",{"$f":"+'2nd Qtr.'!H6","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!J4:J65000,\">\"&'Graph Data'!A21,'Use Agreement Tracking'!J4:J65000,\"<=\"&'Graph Data'!A22)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N4:N65000,\">\"&'Graph Data'!A21,'Use Agreement Tracking'!N4:N65000,\"<=\"&'Graph Data'!A22,'Use Agreement Tracking'!J4:J65000,\"<>\")","v":0},null,{"$f":"+B6+D6-F6","v":0}]
["No. of VGTs",{"$f":"+'2nd Qtr.'!H7","v":0},null,null,null,null,null,{"$f":"+B7+D7-F7","v":0},null,{"$f":"IF(H7<>'Financial Stmt Data Entry'!E6,\"Does Not Match Financial Stmt Data Entry\",\"\")","v":""}]
["No. of Use Agreements",{"$f":"+'2nd Qtr.'!H8","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!H3:H63360,\">\"&'Graph Data'!A21,'Use Agreement Tracking'!H3:H63360,\"<=\"&'Graph Data'!A22)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N3:N63360,\">\"&+'Graph Data'!A21,'Use Agreement Tracking'!N3:N63360,\"<=\"&+'Graph Data'!A22)","v":0},null,{"$f":"+B8+D8-F8","v":0}]
[null,"Beginning",null,"Hired",null,"Terminated",null,"Ending"]
["No. of Permanent Employees",{"$f":"+'2nd Qtr.'!H10","v":0},null,null,null,null,null,{"$f":"+B10+D10-F10","v":0}]
["No. of Independent Contractors",{"$f":"+'2nd Qtr.'!H11","v":0},null,null,null,null,null,{"$f":"+B11+D11-F11","v":0}]
[null,{"$f":"+B4","v":"Q3 2021"},null,{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"},null,"Difference"]
["Amount Played",null,null,{"$f":"+'2nd Qtr.'!B13","v":0},null,{"$f":"+B13-D13","v":0}]
["Average per terminal income per day",{"$f":"IFERROR(IF(Questionnaire!$D$39<+'Graph Data'!C22,+B24/+'Graph Data'!B22/H7,(+B24/(+'Graph Data'!C23-Questionnaire!$D$39)/H7)),0)","v":0},null,{"$f":"+'2nd Qtr.'!B14","v":0},null,{"$f":"+B14-D14","v":0}]
["Aggregate Hold",{"$f":"IFERROR(+B24/B13,0)","v":0},null,{"$f":"IFERROR(+D24/D13,0)","v":0},null,0]
["Gaming Tax % of NTI",{"$f":"IFERROR(+B26/B24,0)","v":0},null,{"$f":"IFERROR(+D26/D24,0)","v":0},null,{"$f":"+B16-D16","v":0}]
["Gaming Administrative Fee % of NTI",{"$f":"IFERROR(+B28/B24,0)","v":0},null,{"$f":"IFERROR(+D28/D24,0)","v":0},null,{"$f":"+B17-D17","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["INCOME STATEMENT",{"$f":"+B12","v":"Q3 2021"},null,{"$f":"+D12","v":"Q2 2021"},null,"Difference",null,"Absolute %"]
["Video Gaming:"]
["Gross Revenue (Funds In)",{"$f":"+'Financial Stmt Data Entry'!E11","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F11","v":0},null,{"$f":"B22-D22","v":0},null,{"$f":"+ABS(F22)/(IF(D22=0, 1, ABS(D22)))","v":0}]
["Payouts (Funds Out)",{"$f":"-'Financial Stmt Data Entry'!E12","v":0},null,{"$f":"-'Financial Stmt Data Entry'!F12","v":0},null,{"$f":"B23-D23","v":0},null,0]
["Net Terminal Income",{"$f":"SUM(B22:B23)","v":0},null,{"$f":"SUM(D22:D23)","v":0},null,{"$f":"SUM(F22:F23)","v":0},null,0]
["Cost of Sales",null,null,null,null,null,null,0]
["   Gaming Tax",{"$f":"+'Financial Stmt Data Entry'!E25","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F25","v":0},null,{"$f":"B26-D26","v":0},null,0]
["   Establishment Revenue Share",{"$f":"+'Financial Stmt Data Entry'!E26","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F26","v":0},null,0,null,0]
["   Gaming Administrative Fee",{"$f":"+'Financial Stmt Data Entry'!E28","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F28","v":0},null,0,null,0]
["   Other Revenue Share Agreements",{"$f":"+'Financial Stmt Data Entry'!E27","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F27","v":0},null,0,null,0]
["   Personnel",{"$f":"+'Financial Stmt Data Entry'!E30+'Financial Stmt Data Entry'!E31+'Financial Stmt Data Entry'!E32+'Financial Stmt Data Entry'!E33","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F30+'Financial Stmt Data Entry'!F31+'Financial Stmt Data Entry'!F32+'Financial Stmt Data Entry'!F33","v":0},null,0,null,0]
["   Equipment Leasing",{"$f":"+'Financial Stmt Data Entry'!E29","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F29","v":0},null,0,null,0]
["   Other cost of sales",{"$f":"+'Financial Stmt Data Entry'!E34+'Financial Stmt Data Entry'!E35+'Financial Stmt Data Entry'!E36+'Financial Stmt Data Entry'!E37+'Financial Stmt Data Entry'!E38+'Financial Stmt Data Entry'!E39+'Financial Stmt Data Entry'!E41+'Financial Stmt Data Entry'!E40","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F34+'Financial Stmt Data Entry'!F35+'Financial Stmt Data Entry'!F36+'Financial Stmt Data Entry'!F37+'Financial Stmt Data Entry'!F38+'Financial Stmt Data Entry'!F39+'Financial Stmt Data Entry'!F41+'Financial Stmt Data Entry'!F40","v":0},null,0,null,0]
["Total Cost of Sales",{"$f":"SUM(B26:B32)","v":0},null,{"$f":"SUM(D26:D32)","v":0},null,{"$f":"SUM(F26:F32)","v":0},null,0]
["     Gross Profit Video Gaming",{"$f":"B24-B33","v":0},null,{"$f":"D24-D33","v":0},null,{"$f":"F24-F33","v":0},null,0]
["Amusement & Other:"]
["Amusement Revenue",{"$f":"+'Financial Stmt Data Entry'!E16","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F16","v":0},null,{"$f":"B36-D36","v":0},null,{"$f":"+ABS(F36)/(IF(D36=0, 1, ABS(D36)))","v":0}]
["Other Revenue",{"$f":"+'Financial Stmt Data Entry'!E17+'Financial Stmt Data Entry'!E18+'Financial Stmt Data Entry'!E19","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F17+'Financial Stmt Data Entry'!F18+'Financial Stmt Data Entry'!F19","v":0},null,{"$f":"B37-D37","v":0},null,0]
["   Total Amusement & Other",{"$f":"+B37+B36","v":0},null,{"$f":"+D37+D36","v":0},null,{"$f":"+F37+F36","v":0},null,0]
["Amusement & Other Cost of Sales",{"$f":"+'Financial Stmt Data Entry'!E60","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F60","v":0},null,{"$f":"B39-D39","v":0},null,0]
["     Gross Profit Amusement & Other",{"$f":"+B38-B39","v":0},null,{"$f":"+D38-D39","v":0},null,{"$f":"+F38-F39","v":0},null,0]
["          Total Gross Profit",{"$f":"+B40+B34","v":0},null,{"$f":"+D34+D40","v":0},null,{"$f":"+F40+F34","v":0},null,0]
["Total General & Administrative Expense",{"$f":"+'Financial Stmt Data Entry'!E120","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F120","v":0},null,{"$f":"+B42-D42","v":0},null,0]
["          EBITDAE",{"$f":"B41-B42","v":0},null,{"$f":"D41-D42","v":0},null,0,null,0]
["Interest Income",{"$f":"+'Financial Stmt Data Entry'!E128","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F128","v":0},null,0,null,0]
["Interest Expense",{"$f":"+'Financial Stmt Data Entry'!E129","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F129","v":0},null,0,null,0]
["Depreciation /Amortization",{"$f":"+'Financial Stmt Data Entry'!E131+'Financial Stmt Data Entry'!E132","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F131+'Financial Stmt Data Entry'!F132","v":0},null,0,null,0]
["Gain (Loss) on Sale of Fixed Asset",{"$f":"+'Financial Stmt Data Entry'!E133","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F133","v":0},null,0,null,0]
["Other",{"$f":"+'Financial Stmt Data Entry'!E134+'Financial Stmt Data Entry'!E135-'Financial Stmt Data Entry'!E130","v":0},null,{"$f":"'Financial Stmt Data Entry'!F134+'Financial Stmt Data Entry'!F135-'Financial Stmt Data Entry'!F130","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+B43+B44-B45-B46+B48+B47","v":0},{"$f":"+C43+C44-C45-C46-C48+C47","v":0},{"$f":"+D43+D44-D45-D46+D48+D47","v":0},{"$f":"+E43+E44-E45-E46-E48","v":0},0,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["BALANCE SHEET",{"$f":"+B20","v":"Q3 2021"},null,{"$f":"+D20","v":"Q2 2021"},null,"Difference",null,"Absolute %"]
["Cash & Cash Equivalents",{"$f":"+'Financial Stmt Data Entry'!E149","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F149","v":0},null,{"$f":"B53-D53","v":0},null,{"$f":"+ABS(F53)/(IF(D53=0, 1, ABS(D53)))","v":0}]
["Accounts Receivable",{"$f":"+'Financial Stmt Data Entry'!E153","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F153","v":0},null,{"$f":"B54-D54","v":0},null,0]
["Inventories",{"$f":"+'Financial Stmt Data Entry'!E165","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F165","v":0},null,0,null,0]
["Other Current Assets",{"$f":"+'Financial Stmt Data Entry'!E159+'Financial Stmt Data Entry'!E161+'Financial Stmt Data Entry'!E167","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F159+'Financial Stmt Data Entry'!F161+'Financial Stmt Data Entry'!F167","v":0},null,0,null,0]
["     Total Current Assets",{"$f":"SUM(B53:B56)","v":0},null,{"$f":"SUM(D53:D56)","v":0},{"$f":"SUM(E53:E56)","v":0},0,null,0]
["Property & Equipment, net",{"$f":"+'Financial Stmt Data Entry'!E181","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F181","v":0},null,0,null,0]
["Goodwill & Intangiblles",{"$f":"+'Financial Stmt Data Entry'!E192","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F192","v":0},null,0,null,0]
["Other Assets",{"$f":"+'Financial Stmt Data Entry'!E185+'Financial Stmt Data Entry'!E196","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F185+'Financial Stmt Data Entry'!F196","v":0},null,0,null,0]
["          Total Assets",{"$f":"SUM(B57:B60)","v":0},null,{"$f":"SUM(D57:D60)","v":0},null,0,null,0]
[]
["Accounts Payable & Accrued Liabilities",{"$f":"+'Financial Stmt Data Entry'!E223","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F223","v":0},null,0,null,{"$f":"+ABS(F63)/(IF(D63=0, 1, ABS(D63)))","v":0}]
["Current portion of L/T debt",{"$f":"+'Financial Stmt Data Entry'!E206","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F206","v":0},null,0,null,0]
["Other current liabilities",{"$f":"+'Financial Stmt Data Entry'!E228","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F228","v":0},null,0,null,0]
["     Total Current Liabilities",{"$f":"SUM(B63:B65)","v":0},null,{"$f":"SUM(D63:D65)","v":0},null,0,null,0]
["Long-Term Debt",{"$f":"+'Financial Stmt Data Entry'!E236","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F236","v":0},null,0,null,0]
["Other Long-term Liabilities",{"$f":"+'Financial Stmt Data Entry'!E240","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F240","v":0},null,0,null,0]
["     Total Liabilities",{"$f":"+B68+B67+B66","v":0},null,{"$f":"+D68+D67+D66","v":0},null,0,null,0]
["Capital",{"$f":"+'Financial Stmt Data Entry'!E249","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F249","v":0},null,0,null,0]
["Retained Earnings",{"$f":"+'Financial Stmt Data Entry'!E251","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F251","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+'Financial Stmt Data Entry'!E252","v":0},null,{"$f":"+'Financial Stmt Data Entry'!F252","v":0},null,0,null,0]
["     Total Stockholder Equity",{"$f":"+B72+B71+B70","v":0},null,{"$f":"+D72+D71+D70","v":0},null,0,null,0]
["          Total Liabilities & Stockholder Equity ",{"$f":"+B73+B69","v":0},null,{"$f":"+D73+D69","v":0},null,{"$f":"+F73+F69","v":0},null,0]
[]
["Ratio Analysis"]
["Gross Profit Margin",{"$f":"IFERROR(+B41/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D41/(D24+D38),0)","v":0},null,{"$f":"+B77-D77","v":0},null,"Total Gross Profit/(NTI + Amusement & Other Rev.)"]
["Net Profit Margin",{"$f":"IFERROR(+B49/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D49/(D24+D38),0)","v":0},null,{"$f":"+B78-D78","v":0},null,"Net Inc (Loss)/(NTI + Amusement & Other Rev.)"]
["Return on Assets",{"$f":"IFERROR(+B49/((B61+D61)/2),0)","v":0},null,{"$f":"IFERROR(+D49/((D61+'Financial Stmt Data Entry'!G198)/2),)","v":0},null,{"$f":"+B79-D79","v":0},null,"Net Inc (Loss)/(Avg. of Last two Periods Total Assets)"]
["Debt Ratio",{"$f":"IFERROR((B64+B67)/B61,0)","v":0},":1",{"$f":"IFERROR((+D67+D64)/D61,0)","v":0},":1",{"$f":"+B80-D80","v":0},":1","(Current Debt + Long Term Debt)/Total Assets"]
["Interest Coverage Ratio",{"$f":"IFERROR(+B43/B45,0)","v":0},":1",{"$f":"IFERROR(+D43/D45,0)","v":0},":1",{"$f":"+B81-D81","v":0},":1","EBITDA/Interest Expense"]
["Liability Ratio",{"$f":"IFERROR(+B69/B61,0)","v":0},":1",{"$f":"IFERROR(+D69/D61,0)","v":0},":1",0,":1","Total Liabilities/Total Assets"]
["Net Working Capital Ratio",{"$f":"IFERROR((+B57-B66)/B61,0)","v":0},":1",{"$f":"IFERROR((+D57-D66)/D61,0)","v":0},":1",0,":1","(Current Assets - Current Liabilities)/Total Assets"]

{"sheet":"4th Qtr.","index":11,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[[82,7,82,9],[77,7,77,9],[78,7,78,9],[79,7,79,9],[80,7,80,9],[81,7,81,9],[0,0,0,9],[1,0,1,9],[18,9,19,9],[50,9,51,9],[76,7,76,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Q4 Financial Summary"]
[]
["GAMING STATISTIC SUMMARY",{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"},null,"Acquired/",null,"Sold/",null,{"$f":"+B4","v":"Q4 2021"}]
[null,"Beginning",null,"Installed",null,"Removed",null,"Ending"]
["No. of Live Establishments",{"$f":"+'3rd Qtr.'!H6","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!J4:J65000,\">\"&'Graph Data'!A22,'Use Agreement Tracking'!J4:J65000,\"<=\"&'Graph Data'!A23)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N4:N65000,\">\"&'Graph Data'!A22,'Use Agreement Tracking'!N4:N65000,\"<=\"&'Graph Data'!A23,'Use Agreement Tracking'!J4:J65000,\"<>\")","v":0},null,{"$f":"+B6+D6-F6","v":0}]
["No. of VGTs",{"$f":"+'3rd Qtr.'!H7","v":0},null,null,null,null,null,{"$f":"+B7+D7-F7","v":0},null,{"$f":"IF(H7<>'Financial Stmt Data Entry'!D6,\"Does Not Match Financial Stmt Data Entry\",\"\")","v":""}]
["No. of Use Agreements",{"$f":"+'3rd Qtr.'!H8","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!H3:H63360,\">\"&'Graph Data'!A22,'Use Agreement Tracking'!H3:H63360,\"<=\"&'Graph Data'!A23)","v":0},null,{"$f":"COUNTIFS('Use Agreement Tracking'!N3:N63360,\">\"&+'Graph Data'!A22,'Use Agreement Tracking'!N3:N63360,\"<=\"&+'Graph Data'!A23)","v":0},null,{"$f":"+B8+D8-F8","v":0}]
[null,"Beginning",null,"Hired",null,"Terminated",null,"Ending"]
["No. of Permanent Employees",{"$f":"+'3rd Qtr.'!H10","v":0},null,null,null,null,null,{"$f":"+B10+D10-F10","v":0}]
["No. of Independent Contractors",{"$f":"+'3rd Qtr.'!H11","v":0},null,null,null,null,null,{"$f":"+B11+D11-F11","v":0}]
[null,{"$f":"+B4","v":"Q4 2021"},null,{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},null,"Difference"]
["Amount Played",null,null,{"$f":"+'3rd Qtr.'!B13","v":0},null,{"$f":"+B13-D13","v":0}]
["Average per terminal income per day",{"$f":"IFERROR(IF(Questionnaire!$D$39<+'Graph Data'!C23,+B24/+'Graph Data'!B23/H7,(+B24/(+'Graph Data'!D20-Questionnaire!$D$39)/H7)),0)","v":0},null,{"$f":"+'3rd Qtr.'!B14","v":0},null,{"$f":"+B14-D14","v":0}]
["Aggregate Hold",{"$f":"IFERROR(+B24/B13,0)","v":0},null,{"$f":"IFERROR(+D24/D13,0)","v":0},null,0]
["Gaming Tax % of NTI",{"$f":"IFERROR(+B26/B24,0)","v":0},null,{"$f":"IFERROR(+D26/D24,0)","v":0},null,{"$f":"+B16-D16","v":0}]
["Gaming Administrative Fee % of NTI",{"$f":"IFERROR(+B28/B24,0)","v":0},null,{"$f":"IFERROR(+D28/D24,0)","v":0},null,{"$f":"+B17-D17","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["INCOME STATEMENT",{"$f":"+B12","v":"Q4 2021"},null,{"$f":"+D12","v":"Q3 2021"},null,"Difference",null,"Absolute %"]
["Video Gaming:"]
["Gross Revenue (Funds In)",{"$f":"+'Financial Stmt Data Entry'!D11","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E11","v":0},null,{"$f":"B22-D22","v":0},null,{"$f":"+ABS(F22)/(IF(D22=0, 1, ABS(D22)))","v":0}]
["Payouts (Funds Out)",{"$f":"-'Financial Stmt Data Entry'!D12","v":0},null,{"$f":"-'Financial Stmt Data Entry'!E12","v":0},null,{"$f":"B23-D23","v":0},null,0]
["Net Terminal Income",{"$f":"SUM(B22:B23)","v":0},null,{"$f":"SUM(D22:D23)","v":0},null,{"$f":"SUM(F22:F23)","v":0},null,0]
["Cost of Sales",null,null,null,null,null,null,0]
["   Gaming Tax",{"$f":"+'Financial Stmt Data Entry'!D25","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E25","v":0},null,{"$f":"B26-D26","v":0},null,0]
["   Establishment Revenue Share",{"$f":"+'Financial Stmt Data Entry'!D26","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E26","v":0},null,0,null,0]
["   Gaming Administrative Fee",{"$f":"+'Financial Stmt Data Entry'!D28","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E28","v":0},null,0,null,0]
["   Other Revenue Share Agreements",{"$f":"+'Financial Stmt Data Entry'!D27","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E27","v":0},null,0,null,0]
["   Personnel",{"$f":"+'Financial Stmt Data Entry'!D30+'Financial Stmt Data Entry'!D31+'Financial Stmt Data Entry'!D32+'Financial Stmt Data Entry'!D33","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E30+'Financial Stmt Data Entry'!E31+'Financial Stmt Data Entry'!E32+'Financial Stmt Data Entry'!E33","v":0},null,0,null,0]
["   Equipment Leasing",{"$f":"+'Financial Stmt Data Entry'!D29","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E29","v":0},null,0,null,0]
["   Other cost of sales",{"$f":"+'Financial Stmt Data Entry'!D34+'Financial Stmt Data Entry'!D35+'Financial Stmt Data Entry'!D36+'Financial Stmt Data Entry'!D37+'Financial Stmt Data Entry'!D38+'Financial Stmt Data Entry'!D39+'Financial Stmt Data Entry'!D41+'Financial Stmt Data Entry'!D40","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E34+'Financial Stmt Data Entry'!E35+'Financial Stmt Data Entry'!E36+'Financial Stmt Data Entry'!E37+'Financial Stmt Data Entry'!E38+'Financial Stmt Data Entry'!E39+'Financial Stmt Data Entry'!E41+'Financial Stmt Data Entry'!E40","v":0},null,0,null,0]
["Total Cost of Sales",{"$f":"SUM(B26:B32)","v":0},null,{"$f":"SUM(D26:D32)","v":0},null,{"$f":"SUM(F26:F32)","v":0},null,0]
["     Gross Profit Video Gaming",{"$f":"B24-B33","v":0},null,{"$f":"D24-D33","v":0},null,{"$f":"F24-F33","v":0},null,0]
["Amusement & Other:"]
["Amusement Revenue",{"$f":"+'Financial Stmt Data Entry'!D16","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E16","v":0},null,{"$f":"B36-D36","v":0},null,0]
["Other Revenue",{"$f":"+'Financial Stmt Data Entry'!D17+'Financial Stmt Data Entry'!D18+'Financial Stmt Data Entry'!D19","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E17+'Financial Stmt Data Entry'!E18+'Financial Stmt Data Entry'!E19","v":0},null,{"$f":"B37-D37","v":0},null,0]
["   Total Amusement & Other",{"$f":"+B37+B36","v":0},null,{"$f":"+D37+D36","v":0},null,{"$f":"+F37+F36","v":0},null,0]
["Amusement & Other Cost of Sales",{"$f":"+'Financial Stmt Data Entry'!D60","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E60","v":0},null,{"$f":"B39-D39","v":0},null,0]
["     Gross Profit Amusement & Other",{"$f":"+B38-B39","v":0},null,{"$f":"+D38-D39","v":0},null,{"$f":"+F38-F39","v":0},null,0]
["          Total Gross Profit",{"$f":"+B40+B34","v":0},null,{"$f":"+D34+D40","v":0},null,{"$f":"+F40+F34","v":0},null,0]
["Total General & Administrative Expense",{"$f":"+'Financial Stmt Data Entry'!D120","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E120","v":0},null,{"$f":"+B42-D42","v":0},null,0]
["          EBITDAE",{"$f":"B41-B42","v":0},null,{"$f":"D41-D42","v":0},null,0,null,0]
["Interest Income",{"$f":"+'Financial Stmt Data Entry'!D128","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E128","v":0},null,0,null,0]
["Interest Expense",{"$f":"+'Financial Stmt Data Entry'!D129","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E129","v":0},null,0,null,0]
["Depreciation /Amortization",{"$f":"+'Financial Stmt Data Entry'!D131+'Financial Stmt Data Entry'!D132","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E131+'Financial Stmt Data Entry'!E132","v":0},null,0,null,0]
["Gain (Loss) on Sale of Fixed Asset",{"$f":"+'Financial Stmt Data Entry'!D133","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E133","v":0},null,0,null,0]
["Other",{"$f":"+'Financial Stmt Data Entry'!D134+'Financial Stmt Data Entry'!D135-'Financial Stmt Data Entry'!D130","v":0},null,{"$f":"'Financial Stmt Data Entry'!E134+'Financial Stmt Data Entry'!E135-'Financial Stmt Data Entry'!E130","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+B43+B44-B45-B46+B48+B47","v":0},{"$f":"+C43+C44-C45-C46-C48+C47","v":0},{"$f":"+D43+D44-D45-D46+D48+D47","v":0},{"$f":"+E43+E44-E45-E46-E48","v":0},0,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["BALANCE SHEET",{"$f":"+B20","v":"Q4 2021"},null,{"$f":"+D20","v":"Q3 2021"},null,"Difference",null,"Absolute %"]
["Cash & Cash Equivalents",{"$f":"+'Financial Stmt Data Entry'!D149","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E149","v":0},null,{"$f":"B53-D53","v":0},null,{"$f":"+ABS(F53)/(IF(D53=0, 1, ABS(D53)))","v":0}]
["Accounts Receivable",{"$f":"+'Financial Stmt Data Entry'!D153","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E153","v":0},null,{"$f":"B54-D54","v":0},null,0]
["Inventories",{"$f":"+'Financial Stmt Data Entry'!D165","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E165","v":0},null,0,null,0]
["Other Current Assets",{"$f":"+'Financial Stmt Data Entry'!D159+'Financial Stmt Data Entry'!D161+'Financial Stmt Data Entry'!D167","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E159+'Financial Stmt Data Entry'!E161+'Financial Stmt Data Entry'!E167","v":0},null,0,null,0]
["     Total Current Assets",{"$f":"SUM(B53:B56)","v":0},null,{"$f":"SUM(D53:D56)","v":0},{"$f":"SUM(E53:E56)","v":0},0,null,0]
["Property & Equipment, net",{"$f":"+'Financial Stmt Data Entry'!D181","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E181","v":0},null,0,null,0]
["Goodwill & Intangiblles",{"$f":"+'Financial Stmt Data Entry'!D192","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E192","v":0},null,0,null,0]
["Other Assets",{"$f":"+'Financial Stmt Data Entry'!D185+'Financial Stmt Data Entry'!D196","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E185+'Financial Stmt Data Entry'!E196","v":0},null,0,null,0]
["          Total Assets",{"$f":"SUM(B57:B60)","v":0},null,{"$f":"SUM(D57:D60)","v":0},null,0,null,0]
[]
["Accounts Payable & Accrued Liabilities",{"$f":"+'Financial Stmt Data Entry'!D223","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E223","v":0},null,0,null,{"$f":"+ABS(F63)/(IF(D63=0, 1, ABS(D63)))","v":0}]
["Current portion of L/T debt",{"$f":"+'Financial Stmt Data Entry'!D206","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E206","v":0},null,0,null,0]
["Other current liabilities",{"$f":"+'Financial Stmt Data Entry'!D228","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E228","v":0},null,0,null,0]
["     Total Current Liabilities",{"$f":"SUM(B63:B65)","v":0},null,{"$f":"SUM(D63:D65)","v":0},null,0,null,0]
["Long-Term Debt",{"$f":"+'Financial Stmt Data Entry'!D236","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E236","v":0},null,0,null,0]
["Other Long-term Liabilities",{"$f":"+'Financial Stmt Data Entry'!D240","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E240","v":0},null,0,null,0]
["     Total Liabilities",{"$f":"+B68+B67+B66","v":0},null,{"$f":"+D68+D67+D66","v":0},null,0,null,0]
["Capital",{"$f":"+'Financial Stmt Data Entry'!D249","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E249","v":0},null,0,null,0]
["Retained Earnings",{"$f":"+'Financial Stmt Data Entry'!D251","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E251","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+'Financial Stmt Data Entry'!D252","v":0},null,{"$f":"+'Financial Stmt Data Entry'!E252","v":0},null,0,null,0]
["     Total Stockholder Equity",{"$f":"+B72+B71+B70","v":0},null,{"$f":"+D72+D71+D70","v":0},null,0,null,0]
["          Total Liabilities & Stockholder Equity ",{"$f":"+B73+B69","v":0},null,{"$f":"+D73+D69","v":0},null,{"$f":"+F73+F69","v":0},null,0]
[]
["Ratio Analysis"]
["Gross Profit Margin",{"$f":"IFERROR(+B41/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D41/(D24+D38),0)","v":0},null,{"$f":"+B77-D77","v":0},null,"Total Gross Profit/(NTI + Amusement & Other Rev.)"]
["Net Profit Margin",{"$f":"IFERROR(+B49/(B24+B38),0)","v":0},null,{"$f":"IFERROR(+D49/(D24+D38),0)","v":0},null,{"$f":"+B78-D78","v":0},null,"Net Inc (Loss)/(NTI + Amusement & Other Rev.)"]
["Return on Assets",{"$f":"IFERROR(+B49/((B61+D61)/2),0)","v":0},null,{"$f":"IFERROR(+D49/((D61+'Financial Stmt Data Entry'!F198)/2),)","v":0},null,{"$f":"+B79-D79","v":0},null,"Net Inc (Loss)/(Avg. of Last two Periods Total Assets)"]
["Debt Ratio",{"$f":"IFERROR((B64+B67)/B61,0)","v":0},":1",{"$f":"IFERROR((+D67+D64)/D61,0)","v":0},":1",{"$f":"+B80-D80","v":0},":1","(Current Debt + Long Term Debt)/Total Assets"]
["Interest Coverage Ratio",{"$f":"IFERROR(+B43/B45,0)","v":0},":1",{"$f":"IFERROR(+D43/D45,0)","v":0},":1",{"$f":"+B81-D81","v":0},":1","EBITDA/Interest Expense"]
["Liability Ratio",{"$f":"IFERROR(+B69/B61,0)","v":0},":1",{"$f":"IFERROR(+D69/D61,0)","v":0},":1",0,":1","Total Liabilities/Total Assets"]
["Net Working Capital Ratio",{"$f":"IFERROR((+B57-B66)/B61,0)","v":0},":1",{"$f":"IFERROR((+D57-D66)/D61,0)","v":0},":1",0,":1","(Current Assets - Current Liabilities)/Total Assets"]

{"sheet":"Annual Review","index":12,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[[81,7,81,9],[76,7,76,9],[77,7,77,9],[78,7,78,9],[79,7,79,9],[80,7,80,9],[0,0,0,9],[1,0,1,9],[17,9,18,9],[49,9,50,9],[75,7,75,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Annual Financial Summary"]
[]
["GAMING STATISTIC SUMMARY",{"$f":"+'Financial Stmt Data Entry'!I4","v":2020},null,"Acquired/ Installed",null,"Sold/  Removed",null,{"$f":"+'Financial Stmt Data Entry'!C4","v":2021}]
["No. of Live Establishments",{"$f":"COUNTIF('Use Agreement Tracking'!J4:J65000,\"<=\"&'Graph Data'!A24)-COUNTIFS('Use Agreement Tracking'!N4:N65000,\"<=\"&'Graph Data'!A24,'Use Agreement Tracking'!J4:J65000,\"<>\")","v":0},null,{"$f":"+'1st Qtr.'!D6+'2nd Qtr.'!D6+'3rd Qtr.'!D6+'4th Qtr.'!D6","v":0},null,{"$f":"+'1st Qtr.'!F6+'2nd Qtr.'!F6+'3rd Qtr.'!F6+'4th Qtr.'!F6","v":0},null,{"$f":"+B5+D5-F5","v":0}]
["No. of VGTs",{"$f":"+'Financial Stmt Data Entry'!I6","v":0},null,{"$f":"+'4th Qtr.'!D7+'3rd Qtr.'!D7+'2nd Qtr.'!D7+'1st Qtr.'!D7","v":0},null,{"$f":"+'4th Qtr.'!F7+'3rd Qtr.'!F7+'2nd Qtr.'!F7+'1st Qtr.'!F7","v":0},null,{"$f":"+B6+D6-F6","v":0},null,{"$f":"IF(H6<>'Financial Stmt Data Entry'!D6,\"Does Not Match Financial Stmt Data Entry\",\"\")","v":""}]
["No. of Use Agreements",{"$f":"+'1st Qtr.'!B8","v":0},null,{"$f":"+'1st Qtr.'!D8+'2nd Qtr.'!D8+'3rd Qtr.'!D8+'4th Qtr.'!D8","v":0},null,{"$f":"+'1st Qtr.'!F8+'2nd Qtr.'!F8+'3rd Qtr.'!F8+'4th Qtr.'!F8","v":0},null,{"$f":"+B7+D7-F7","v":0}]
[null,{"$f":"+B4","v":2020},null,"Hired",null,"Terminated",null,{"$f":"+H4","v":2021}]
["No. of Permanent Employees",{"$f":"+'1st Qtr.'!B10","v":0},null,{"$f":"+'1st Qtr.'!D10+'2nd Qtr.'!D10+'3rd Qtr.'!D10+'4th Qtr.'!D10","v":0},null,{"$f":"+'1st Qtr.'!F10+'2nd Qtr.'!F10+'3rd Qtr.'!F10+'4th Qtr.'!F10","v":0},null,{"$f":"+B9+D9-F9","v":0}]
["No. of Independent Contractors",{"$f":"+'1st Qtr.'!B11","v":0},null,{"$f":"+'1st Qtr.'!D11+'2nd Qtr.'!D11+'3rd Qtr.'!D11+'4th Qtr.'!D11","v":0},null,{"$f":"+'1st Qtr.'!F11+'2nd Qtr.'!F11+'3rd Qtr.'!F11+'4th Qtr.'!F11","v":0},null,{"$f":"+B10+D10-F10","v":0}]
[null,{"$f":"+H8","v":2021},null,{"$f":"+B8","v":2020},null,"Difference"]
["Amount Played",{"$f":"+'4th Qtr.'!B13+'3rd Qtr.'!B13+'2nd Qtr.'!B13+'1st Qtr.'!B13","v":0},null,0,null,{"$f":"+B12-D12","v":0}]
["Average per terminal income per day",{"$f":"IFERROR(IF(Questionnaire!$D$39<+'Graph Data'!C20,+B23/365/H6,(+B23/(+'Graph Data'!D20-Questionnaire!$D$39)/H6)),0)","v":0},null,{"$f":"IFERROR(IF(Questionnaire!$D$39<'Graph Data'!D24,+D23/365/B6,IF(Questionnaire!$D$39<='Graph Data'!A24,(+D23/(+'Graph Data'!A24-Questionnaire!$D$39)/B6),0)),0)","v":0},null,{"$f":"+B13-D13","v":0}]
["Aggregate Hold",{"$f":"IFERROR(+B23/B12,0)","v":0},null,{"$f":"IFERROR(+D23/D12,0)","v":0},null,0]
["Gaming Tax % of NTI",{"$f":"IFERROR(+B25/B23,0)","v":0},null,{"$f":"IFERROR(+D25/D23,0)","v":0},null,{"$f":"+B15-D15","v":0}]
["Gaming Administrative Fee % of NTI",{"$f":"IFERROR(+B27/B23,0)","v":0},null,{"$f":"IFERROR(+D27/D23,0)","v":0},null,{"$f":"+B16-D16","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["INCOME STATEMENT",{"$f":"+B11","v":2021},null,{"$f":"+D11","v":2020},null,"Difference",null,"Absolute %"]
["Video Gaming:"]
["Gross Revenue (Funds In)",{"$f":"+'Financial Stmt Data Entry'!C11","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I11","v":0},null,{"$f":"B21-D21","v":0},null,{"$f":"+ABS(F21)/(IF(D21=0, 1, ABS(D21)))","v":0}]
["Payouts (Funds Out)",{"$f":"-'Financial Stmt Data Entry'!C12","v":0},null,{"$f":"-'Financial Stmt Data Entry'!I12","v":0},null,{"$f":"B22-D22","v":0},null,0]
["Net Terminal Income",{"$f":"SUM(B21:B22)","v":0},null,{"$f":"SUM(D21:D22)","v":0},null,{"$f":"SUM(F21:F22)","v":0},null,0]
["Cost of Sales"]
["   Gaming Tax",{"$f":"+'Financial Stmt Data Entry'!C25","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I25","v":0},null,{"$f":"B25-D25","v":0},null,{"$f":"+ABS(F25)/(IF(D25=0, 1, ABS(D25)))","v":0}]
["   Establishment Revenue Share",{"$f":"+'Financial Stmt Data Entry'!C26","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I26","v":0},null,0,null,0]
["   Gaming Administrative Fee",{"$f":"+'Financial Stmt Data Entry'!C28","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I28","v":0},null,0,null,0]
["   Other Revenue Share Agreements",{"$f":"+'Financial Stmt Data Entry'!C27","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I27","v":0},null,0,null,0]
["   Personnel",{"$f":"+'Financial Stmt Data Entry'!C30+'Financial Stmt Data Entry'!C31+'Financial Stmt Data Entry'!C32+'Financial Stmt Data Entry'!C33","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I30+'Financial Stmt Data Entry'!I31+'Financial Stmt Data Entry'!I32+'Financial Stmt Data Entry'!I33","v":0},null,0,null,0]
["   Equipment Leasing",{"$f":"+'Financial Stmt Data Entry'!C29","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I29","v":0},null,0,null,0]
["   Other cost of sales",{"$f":"+'Financial Stmt Data Entry'!C34+'Financial Stmt Data Entry'!C35+'Financial Stmt Data Entry'!C36+'Financial Stmt Data Entry'!C37+'Financial Stmt Data Entry'!C38+'Financial Stmt Data Entry'!C39+'Financial Stmt Data Entry'!C41+'Financial Stmt Data Entry'!C40","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I34+'Financial Stmt Data Entry'!I35+'Financial Stmt Data Entry'!I36+'Financial Stmt Data Entry'!I37+'Financial Stmt Data Entry'!I38+'Financial Stmt Data Entry'!I39+'Financial Stmt Data Entry'!I41+'Financial Stmt Data Entry'!I40","v":0},null,0,null,0]
["Total Cost of Sales",{"$f":"SUM(B25:B31)","v":0},null,{"$f":"SUM(D25:D31)","v":0},null,{"$f":"SUM(F25:F31)","v":0},null,0]
["     Gross Profit Video Gaming",{"$f":"B23-B32","v":0},null,{"$f":"D23-D32","v":0},null,{"$f":"F23-F32","v":0},null,0]
["Amusement & Other:"]
["Amusement Revenue",{"$f":"+'Financial Stmt Data Entry'!C16","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I16","v":0},null,{"$f":"B35-D35","v":0},null,{"$f":"+ABS(F35)/(IF(D35=0, 1, ABS(D35)))","v":0}]
["Other Revenue",{"$f":"+'Financial Stmt Data Entry'!C17+'Financial Stmt Data Entry'!C18+'Financial Stmt Data Entry'!C19","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I17+'Financial Stmt Data Entry'!I18+'Financial Stmt Data Entry'!I19","v":0},null,{"$f":"B36-D36","v":0},null,0]
["   Total Amusement & Other",{"$f":"+B36+B35","v":0},null,{"$f":"+D36+D35","v":0},null,{"$f":"+F36+F35","v":0},null,0]
["Amusement & Other Cost of Sales",{"$f":"+'Financial Stmt Data Entry'!C60","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I60","v":0},null,{"$f":"B38-D38","v":0},null,0]
["     Gross Profit Amusement & Other",{"$f":"+B37-B38","v":0},null,{"$f":"+D37-D38","v":0},null,{"$f":"+F37-F38","v":0},null,0]
["          Total Gross Profit",{"$f":"+B39+B33","v":0},null,{"$f":"+D33+D39","v":0},null,{"$f":"+F39+F33","v":0},null,0]
["Total General & Administrative Expense",{"$f":"+'Financial Stmt Data Entry'!C120","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I120","v":0},null,{"$f":"+B41-D41","v":0},null,0]
["          EBITDAE",{"$f":"B40-B41","v":0},null,{"$f":"D40-D41","v":0},null,0,null,0]
["Interest Income",{"$f":"+'Financial Stmt Data Entry'!C128","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I128","v":0},null,0,null,0]
["Interest Expense",{"$f":"+'Financial Stmt Data Entry'!C129","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I129","v":0},null,0,null,0]
["Depreciation /Amortization",{"$f":"+'Financial Stmt Data Entry'!C131+'Financial Stmt Data Entry'!C132","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I131+'Financial Stmt Data Entry'!I132","v":0},null,0,null,0]
["Gain (Loss) on Sale of Fixed Asset",{"$f":"+'Financial Stmt Data Entry'!C133","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I133","v":0},null,0,null,0]
["Other",{"$f":"+'Financial Stmt Data Entry'!C134+'Financial Stmt Data Entry'!C135-'Financial Stmt Data Entry'!C130","v":0},null,{"$f":"'Financial Stmt Data Entry'!I134+'Financial Stmt Data Entry'!I135-'Financial Stmt Data Entry'!I130","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+B42+B43-B44-B45+B47+B46","v":0},{"$f":"+C42+C43-C44-C45-C47+C46","v":0},{"$f":"+D42+D43-D44-D45+D47+D46","v":0},{"$f":"+E42+E43-E44-E45-E47","v":0},0,null,0]
[]
[null,null,null,null,null,null,null,null,null,"Provide explanation when variance exceeds +/-25%  (Highlighted in red.)"]
["BALANCE SHEET",{"$f":"+B19","v":2021},null,{"$f":"+D19","v":2020},null,"Difference",null,"Absolute %"]
["Cash & Cash Equivalents",{"$f":"+'Financial Stmt Data Entry'!C149","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I149","v":0},null,{"$f":"B52-D52","v":0},null,{"$f":"+ABS(F52)/(IF(D52=0, 1, ABS(D52)))","v":0}]
["Accounts Receivable",{"$f":"+'Financial Stmt Data Entry'!C153","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I153","v":0},null,{"$f":"B53-D53","v":0},null,0]
["Inventories",{"$f":"+'Financial Stmt Data Entry'!C165","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I165","v":0},null,0,null,0]
["Other Current Assets",{"$f":"+'Financial Stmt Data Entry'!C159+'Financial Stmt Data Entry'!C161+'Financial Stmt Data Entry'!C167","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I159+'Financial Stmt Data Entry'!I161+'Financial Stmt Data Entry'!I167","v":0},null,0,null,0]
["     Total Current Assets",{"$f":"SUM(B52:B55)","v":0},null,{"$f":"SUM(D52:D55)","v":0},{"$f":"SUM(E52:E55)","v":0},0,null,0]
["Property & Equipment, net",{"$f":"+'Financial Stmt Data Entry'!C181","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I181","v":0},null,0,null,0]
["Goodwill & Intangiblles",{"$f":"+'Financial Stmt Data Entry'!C192","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I192","v":0},null,0,null,0]
["Other Assets",{"$f":"+'Financial Stmt Data Entry'!C185+'Financial Stmt Data Entry'!C196","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I185+'Financial Stmt Data Entry'!I196","v":0},null,0,null,0]
["          Total Assets",{"$f":"SUM(B56:B59)","v":0},null,{"$f":"SUM(D56:D59)","v":0},null,0,null,0]
[]
["Accounts Payable & Accrued Liabilities",{"$f":"+'Financial Stmt Data Entry'!C223","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I223","v":0},null,0,null,{"$f":"+ABS(F62)/(IF(D62=0, 1, ABS(D62)))","v":0}]
["Current portion of L/T debt",{"$f":"+'Financial Stmt Data Entry'!C206","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I206","v":0},null,0,null,0]
["Other current liabilities",{"$f":"+'Financial Stmt Data Entry'!C228","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I228","v":0},null,0,null,0]
["     Total Current Liabilities",{"$f":"SUM(B62:B64)","v":0},null,{"$f":"SUM(D62:D64)","v":0},null,0,null,0]
["Long-Term Debt",{"$f":"+'Financial Stmt Data Entry'!C236","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I236","v":0},null,0,null,0]
["Other Long-term Liabilities",{"$f":"+'Financial Stmt Data Entry'!C240","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I240","v":0},null,0,null,0]
["     Total Liabilities",{"$f":"+B67+B66+B65","v":0},null,{"$f":"+D67+D66+D65","v":0},null,0,null,0]
["Capital",{"$f":"+'Financial Stmt Data Entry'!C249","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I249","v":0},null,0,null,0]
["Retained Earnings",{"$f":"+'Financial Stmt Data Entry'!C251","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I251","v":0},null,0,null,0]
["Net Income (Loss)",{"$f":"+'Financial Stmt Data Entry'!C252","v":0},null,{"$f":"+'Financial Stmt Data Entry'!I252","v":0},null,0,null,0]
["     Total Stockholder Equity",{"$f":"+B71+B70+B69","v":0},null,{"$f":"+D71+D70+D69","v":0},null,0,null,0]
["          Total Liabilities & Stockholder Equity ",{"$f":"+B72+B68","v":0},null,{"$f":"+D72+D68","v":0},null,{"$f":"+F72+F68","v":0},null,0]
[]
["Ratio Analysis"]
["Gross Profit Margin",{"$f":"IFERROR(+B40/(B23+B37),0)","v":0},null,{"$f":"IFERROR(+D40/(D23+D37),0)","v":0},null,{"$f":"+B76-D76","v":0},null,"Total Gross Profit/(NTI + Amusement & Other Rev.)"]
["Net Profit Margin",{"$f":"IFERROR(+B48/(B23+B37),0)","v":0},null,{"$f":"IFERROR(+D48/(D23+D37),0)","v":0},null,{"$f":"+B77-D77","v":0},null,"Net Inc (Loss)/(NTI + Amusement & Other Rev.)"]
["Return on Assets",{"$f":"IFERROR(+B48/((B60+D60)/2),0)","v":0},null,{"$f":"IFERROR(+D48/((D60+'Financial Stmt Data Entry'!J198)/2),)","v":0},null,{"$f":"+B78-D78","v":0},null,"Net Inc (Loss)/(Avg. of Last two Periods Total Assets)"]
["Debt Ratio",{"$f":"IFERROR((B63+B66)/B60,0)","v":0},":1",{"$f":"IFERROR((+D66+D63)/D60,0)","v":0},":1",{"$f":"+B79-D79","v":0},":1","(Current Debt + Long Term Debt)/Total Assets"]
["Interest Coverage Ratio",{"$f":"IFERROR(+B42/B44,0)","v":0},":1",{"$f":"IFERROR(+D42/D44,0)","v":0},":1",{"$f":"+B80-D80","v":0},":1","EBITDA/Interest Expense"]
["Liability Ratio",{"$f":"IFERROR(+B68/B60,0)","v":0},":1",{"$f":"IFERROR(+D68/D60,0)","v":0},":1",0,":1","Total Liabilities/Total Assets"]
["Net Working Capital Ratio",{"$f":"IFERROR((+B56-B65)/B60,0)","v":0},":1",{"$f":"IFERROR((+D56-D65)/D60,0)","v":0},":1",0,":1","(Current Assets - Current Liabilities)/Total Assets"]

{"sheet":"QrtlyGraphs","index":13,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Quarterly Trend Analysis"]

{"sheet":"AnnualGraphs","index":14,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,15],[1,0,1,15]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Annual Trend Analysis  (To be reviewed at year end.)"]

{"sheet":"Graph Data","index":15,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Graph  Data"]
[]
[null,"Revenue","NTI","Amusement & Other","Gross Profit Margin","Avg WPU","Net Profit","Net Profit Margin","Aggregate Hold","Return on Assets","Debt Ratio","Liability Ratio","Net Working Capital Ratio","VGT's"]
[{"$f":"+'Financial Stmt Data Entry'!L4","v":2017},{"$f":"+'Financial Stmt Data Entry'!$L22","v":0},{"$f":"+'Financial Stmt Data Entry'!$L13","v":0},{"$f":"+'Financial Stmt Data Entry'!L$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!L$68/'Financial Stmt Data Entry'!L$22,0)","v":0},null,{"$f":"+'Financial Stmt Data Entry'!$L136","v":0},{"$f":"IFERROR(G4/B4,0)","v":0},null,{"$f":"IFERROR(+'Financial Stmt Data Entry'!L$136/((+'Financial Stmt Data Entry'!L$198)/1),0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!L$206+'Financial Stmt Data Entry'!L$236)/'Financial Stmt Data Entry'!L$198,0)","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!L$242/'Financial Stmt Data Entry'!L$198,0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!L$168-'Financial Stmt Data Entry'!L$229)/'Financial Stmt Data Entry'!L$198,0)","v":0},{"$f":"+'Financial Stmt Data Entry'!L$6","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!K4","v":2018},{"$f":"+'Financial Stmt Data Entry'!$K22","v":0},{"$f":"+'Financial Stmt Data Entry'!$K13","v":0},{"$f":"+'Financial Stmt Data Entry'!K$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!K$68/'Financial Stmt Data Entry'!K$22,0)","v":0},null,{"$f":"+'Financial Stmt Data Entry'!$K136","v":0},{"$f":"IFERROR(G5/B5,0)","v":0},null,{"$f":"IFERROR(+'Financial Stmt Data Entry'!K$136/((+'Financial Stmt Data Entry'!L$198+'Financial Stmt Data Entry'!K$198)/2),0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!K$206+'Financial Stmt Data Entry'!K$236)/'Financial Stmt Data Entry'!K$198,0)","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!K$242/'Financial Stmt Data Entry'!K$198,0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!K$168-'Financial Stmt Data Entry'!K$229)/'Financial Stmt Data Entry'!K$198,0)","v":0},{"$f":"+'Financial Stmt Data Entry'!K$6","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!J4","v":2019},{"$f":"+'Financial Stmt Data Entry'!$J22","v":0},{"$f":"+'Financial Stmt Data Entry'!$J13","v":0},{"$f":"+'Financial Stmt Data Entry'!J$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!J$68/'Financial Stmt Data Entry'!J$22,0)","v":0},0,{"$f":"+'Financial Stmt Data Entry'!$J136","v":0},0,0,{"$f":"IFERROR(+'Financial Stmt Data Entry'!J$136/((+'Financial Stmt Data Entry'!J$198+'Financial Stmt Data Entry'!K$198)/2),0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!J$206+'Financial Stmt Data Entry'!J$236)/'Financial Stmt Data Entry'!J$198,0)","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!J$242/'Financial Stmt Data Entry'!J$198,0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!J$168-'Financial Stmt Data Entry'!J$229)/'Financial Stmt Data Entry'!J$198,0)","v":0},{"$f":"+'Financial Stmt Data Entry'!J$6","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!I4","v":2020},{"$f":"+'Financial Stmt Data Entry'!$I22","v":0},{"$f":"+'Financial Stmt Data Entry'!$I13","v":0},{"$f":"+'Financial Stmt Data Entry'!I$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!I$68/'Financial Stmt Data Entry'!I$22,0)","v":0},{"$f":"+'Annual Review'!D13","v":0},{"$f":"+'Financial Stmt Data Entry'!$I136","v":0},{"$f":"IFERROR(G7/B7,0)","v":0},{"$f":"+'Annual Review'!D14","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!I$136/((+'Financial Stmt Data Entry'!J$198+'Financial Stmt Data Entry'!I$198)/2),0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!I$206+'Financial Stmt Data Entry'!I$236)/'Financial Stmt Data Entry'!I$198,0)","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!I$242/'Financial Stmt Data Entry'!I$198,0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!I$168-'Financial Stmt Data Entry'!I$229)/'Financial Stmt Data Entry'!I$198,0)","v":0},{"$f":"+'Financial Stmt Data Entry'!I$6","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!C4","v":2021},{"$f":"+'Financial Stmt Data Entry'!C22","v":0},{"$f":"+'Financial Stmt Data Entry'!$C13","v":0},{"$f":"+'Financial Stmt Data Entry'!C$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!C$68/'Financial Stmt Data Entry'!C$22,0)","v":0},{"$f":"+'Annual Review'!B13","v":0},{"$f":"+'Financial Stmt Data Entry'!$C136","v":0},{"$f":"IFERROR(G8/B8,0)","v":0},{"$f":"+'Annual Review'!B14","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!C$136/((+'Financial Stmt Data Entry'!C$198+'Financial Stmt Data Entry'!I$198)/2),0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!C$206+'Financial Stmt Data Entry'!C$236)/'Financial Stmt Data Entry'!C$198,0)","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!C$242/'Financial Stmt Data Entry'!C$198,0)","v":0},{"$f":"IFERROR((+'Financial Stmt Data Entry'!C$168-'Financial Stmt Data Entry'!C$229)/'Financial Stmt Data Entry'!C$198,0)","v":0},{"$f":"+'Financial Stmt Data Entry'!C$6","v":0}]
[]
[{"$f":"+'Financial Stmt Data Entry'!H4","v":"Q4 2020"},{"$f":"+'Financial Stmt Data Entry'!$H22","v":0},{"$f":"+'Financial Stmt Data Entry'!$H13","v":0},{"$f":"+'Financial Stmt Data Entry'!H$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!H$68/'Financial Stmt Data Entry'!H$22,0)","v":0},{"$f":"+'1st Qtr.'!D14","v":0},{"$f":"+'Financial Stmt Data Entry'!$H136","v":0},{"$f":"IFERROR(G10/B10,0)","v":0},{"$f":"+'1st Qtr.'!D15","v":0},{"$f":"+'1st Qtr.'!D79","v":0},{"$f":"+'1st Qtr.'!D80","v":0},{"$f":"+'1st Qtr.'!D82","v":0},{"$f":"+'1st Qtr.'!D83","v":0},{"$f":"+'1st Qtr.'!B7","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},{"$f":"+'Financial Stmt Data Entry'!$G22","v":0},{"$f":"+'Financial Stmt Data Entry'!$G13","v":0},{"$f":"+'Financial Stmt Data Entry'!G$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!G$68/'Financial Stmt Data Entry'!G$22,0)","v":0},{"$f":"+'1st Qtr.'!B14","v":0},{"$f":"+'Financial Stmt Data Entry'!$G136","v":0},0,{"$f":"+'1st Qtr.'!B15","v":0},{"$f":"+'1st Qtr.'!B79","v":0},{"$f":"+'1st Qtr.'!B80","v":0},{"$f":"+'1st Qtr.'!B82","v":0},{"$f":"+'1st Qtr.'!B83","v":0},{"$f":"+'1st Qtr.'!H7","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"},{"$f":"+'Financial Stmt Data Entry'!$F22","v":0},{"$f":"+'Financial Stmt Data Entry'!$F13","v":0},{"$f":"+'Financial Stmt Data Entry'!F$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!F$68/'Financial Stmt Data Entry'!F$22,0)","v":0},{"$f":"+'2nd Qtr.'!B14","v":0},{"$f":"+'Financial Stmt Data Entry'!$F136","v":0},0,{"$f":"+'2nd Qtr.'!B15","v":0},{"$f":"+'2nd Qtr.'!B79","v":0},{"$f":"+'2nd Qtr.'!B80","v":0},{"$f":"+'2nd Qtr.'!B82","v":0},{"$f":"+'2nd Qtr.'!B83","v":0},{"$f":"+'2nd Qtr.'!H7","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},{"$f":"+'Financial Stmt Data Entry'!$E22","v":0},{"$f":"+'Financial Stmt Data Entry'!$E13","v":0},{"$f":"+'Financial Stmt Data Entry'!E$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!E$68/'Financial Stmt Data Entry'!E$22,0)","v":0},{"$f":"+'3rd Qtr.'!B14","v":0},{"$f":"+'Financial Stmt Data Entry'!$E136","v":0},0,{"$f":"+'3rd Qtr.'!B15","v":0},{"$f":"+'3rd Qtr.'!B79","v":0},{"$f":"+'3rd Qtr.'!B80","v":0},{"$f":"+'3rd Qtr.'!B82","v":0},{"$f":"+'3rd Qtr.'!B83","v":0},{"$f":"+'3rd Qtr.'!H7","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"},{"$f":"+'Financial Stmt Data Entry'!$D22","v":0},{"$f":"+'Financial Stmt Data Entry'!$D13","v":0},{"$f":"+'Financial Stmt Data Entry'!D$20","v":0},{"$f":"IFERROR(+'Financial Stmt Data Entry'!D$68/'Financial Stmt Data Entry'!D$22,0)","v":0},{"$f":"+'4th Qtr.'!B14","v":0},{"$f":"+'Financial Stmt Data Entry'!$D136","v":0},0,{"$f":"+'4th Qtr.'!B15","v":0},{"$f":"+'4th Qtr.'!B79","v":0},{"$f":"+'4th Qtr.'!B80","v":0},{"$f":"+'4th Qtr.'!B82","v":0},{"$f":"+'4th Qtr.'!B83","v":0},{"$f":"+'4th Qtr.'!H7","v":0}]
[]
[]
[]
["Dates for annual update to formulas"]
[null,"# of days","Qtr Begin"]
[{"$f":"EDATE(\"12/31/\"& +'Financial Stmt Data Entry'!$C$4,-9)","v":"2021-03-31"},{"$f":"+A20-A24","v":90},{"$f":"+A20-B20+1","v":"2021-01-01"},{"$f":"+C20+365","v":"2022-01-01"}]
[{"$f":"EDATE(\"12/31/\"& +'Financial Stmt Data Entry'!$C$4,-6)","v":"2021-06-30"},{"$f":"+A21-A20","v":91},{"$f":"+A21-B21+1","v":"2021-04-01"}]
[{"$f":"EDATE(\"12/31/\"& +'Financial Stmt Data Entry'!$C$4,-3)","v":"2021-09-30"},{"$f":"+A22-A21","v":92},"2021-07-01"]
[{"$f":"\"12/31/\"&+'Financial Stmt Data Entry'!$C$4","v":"12/31/2021"},{"$f":"+A23-A22","v":92},"2021-10-01"]
[{"$f":"(\"12/31/\"&+'Financial Stmt Data Entry'!$I$4)","v":"12/31/2020"},{"$f":"+A24-A25","v":92},"2020-10-01",{"$f":"+A24-364","v":"2020-01-02"}]
[{"$f":"EDATE(\"12/31/\"& +'Financial Stmt Data Entry'!$I$4,-3)","v":"2020-09-30"}]

{"sheet":"Selected Disclosures","index":16,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[31,0,31,7],[0,0,0,7],[3,0,3,4],[12,0,12,3],[21,0,21,7],[1,0,1,7]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["SELECTED DISCLOSURES"]
[]
["LIST OF ALL ACTIVE REVENUE SHARE AGREEMENTS (Note \"none\" if not applicable):"]
["Date of Executed Agreement","Name of Revenue Sharer","Address","# of locations","Terms of Revenue Share","Date Disclosure Information filed with IGB*"]
[]
[]
[]
[]
[]
["*Attach copy of executed contract if not already supplied."]
[]
["CURRENT YEAR CHANGES IN OWNERSHIP (Note \"none\" if not applicable):"]
["Date of transaction","Name","Address","% Owned","How Acquired and from whom","Amount Invested","Date Disclosure Information filed with IGB*"]
[]
[]
[]
[]
[]
[]
[]
["CURRENT YEAR RELATED PARTY TRANSACTIONS  Transactions with stockholders/members; PSIC's Business Entities classified as PSIC's or other parties related to the entity or its stockholders/members.  Exclude equity contributions and distributions made to members.     (Note \"none\" if not applicable)"]
["Date of transaction","Name","Address","Amount","Description of transaction","Purpose","Attach copy of executed contract.  If \"none\" indicate on line."]
[]
[]
[]
[]
[]
[]
[]
[]
["Illinois Tax per Financial Statements"]
[null,"Gaming Tax","Illinois Income Tax","Illinois Sales Tax","Illinois Payroll Tax","Illinois Property Tax","Other state & local taxes*","Total Illinois Tax"]
[{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},{"$f":"+'Financial Stmt Data Entry'!G25","v":0},null,null,null,null,null,{"$f":"SUM(B34:G34)","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"},{"$f":"+'Financial Stmt Data Entry'!F25","v":0},null,null,null,null,null,{"$f":"SUM(B35:G35)","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},{"$f":"+'Financial Stmt Data Entry'!E25","v":0},null,null,null,null,null,0]
[{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"},{"$f":"+'Financial Stmt Data Entry'!D25","v":0},null,null,null,null,null,0]
["Total",{"$f":"SUM(B34:B37)","v":0},0,0,0,0,0,0]
["* Includes local municipality license fees per VGT."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Affiliate shared services to/from"]
["Affiliate/Owner/Member Loan"]
["Property/Equipment Sale"]
["Property/Equipment Exchange"]
["Other Explain in Description"]

{"sheet":"Shareholders Equity Recon","index":17,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["Stockholders Equity Reconciliation"]
[]
[]
[]
[null,{"$f":"+'Financial Stmt Data Entry'!L4","v":2017},{"$f":"+'Financial Stmt Data Entry'!K4","v":2018},{"$f":"+'Financial Stmt Data Entry'!J4","v":2019},{"$f":"+'Financial Stmt Data Entry'!I4","v":2020},{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"},{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"},{"$f":"+'Financial Stmt Data Entry'!C4","v":2021}]
[]
["Shareholder's Equity Beginning",0,{"$f":"+B19","v":0},{"$f":"+C19","v":0},{"$f":"+D19","v":0},{"$f":"E19","v":0},{"$f":"+F19","v":0},{"$f":"+G19","v":0},{"$f":"+H19","v":0},{"$f":"+E19","v":0}]
["Net Income(per Inc Stmt)",{"$f":"+'Financial Stmt Data Entry'!L136","v":0},{"$f":"+'Financial Stmt Data Entry'!K136","v":0},{"$f":"+'Financial Stmt Data Entry'!J136","v":0},{"$f":"+'Financial Stmt Data Entry'!I136","v":0},{"$f":"+'Financial Stmt Data Entry'!G136","v":0},{"$f":"+'Financial Stmt Data Entry'!F136","v":0},{"$f":"+'Financial Stmt Data Entry'!E136","v":0},{"$f":"+'Financial Stmt Data Entry'!D136","v":0},{"$f":"+'Financial Stmt Data Entry'!C136","v":0}]
["Member Contributions",null,null,null,0,null,null,null,null,{"$f":"SUM(F10:I10)","v":0}]
["Members Draw",null,null,null,0,null,null,null,null,{"$f":"SUM(F11:I11)","v":0}]
["Dividends",null,null,null,0,null,null,null,null,0]
["Changes in accounting method",null,null,null,0,null,null,null,null,0]
["Other (Explain):",null,null,null,0,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,0]
[null,null,null,null,0,null,null,null,null,0]
[]
["Shareholder's Equity Ending",{"$f":"SUM(B8:B18)","v":0},0,0,0,0,0,0,0,0]
[]
["Equity Per Balance Sheet",{"$f":"+'Financial Stmt Data Entry'!L254","v":0},{"$f":"+'Financial Stmt Data Entry'!K254","v":0},{"$f":"+'Financial Stmt Data Entry'!J254","v":0},{"$f":"+'Financial Stmt Data Entry'!I254","v":0},{"$f":"+'Financial Stmt Data Entry'!G254","v":0},{"$f":"+'Financial Stmt Data Entry'!F254","v":0},{"$f":"+'Financial Stmt Data Entry'!E254","v":0},{"$f":"+'Financial Stmt Data Entry'!D254","v":0},{"$f":"+'Financial Stmt Data Entry'!C254","v":0}]
["    Difference (should be zero)",{"$f":"+B21-B19","v":0},0,0,0,0,0,0,0,0]

{"sheet":"Debt Schedule","index":18,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,0,1,18],[51,0,51,4],[54,0,54,1],[4,6,4,7],[3,6,3,7],[3,8,3,9],[4,8,4,9]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["FINANCIAL DEBT SCHEDULE"]
[]
[null,null,"Date of ",null,null,null,"Balance Due",null,"Balance Due",null,"Balance Due",null,"Balance Due",null,null,null,null,"Debt  Covenants             "]
[null,null,"Last",null,null,null,{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},null,{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"},null,{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},null,{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"},null,"Interest","Maturity","List all Debt Covenants","Met? *"]
["Lender","Loan #","Draw","Type","Purpose","Amount Drawn","Current","Long-Term","Current","Long-Term","Current","Long-Term","Current","Long-Term","Rate","Date","(If None, enter n/a)","Yes/No","List Covenants Not Met"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total",{"$f":"SUM(F7:F47)","v":0},{"$f":"SUM(G7:G47)","v":0},{"$f":"SUM(H7:H47)","v":0},0,0,0,0,0,0]
[]
[null,null,null,"  Balance Per Balance Sheet",null,null,{"$f":"+'Financial Stmt Data Entry'!G206","v":0},{"$f":"+'Financial Stmt Data Entry'!G236","v":0},{"$f":"'Financial Stmt Data Entry'!F206","v":0},{"$f":"+'Financial Stmt Data Entry'!F236","v":0},{"$f":"'Financial Stmt Data Entry'!E206","v":0},{"$f":"+'Financial Stmt Data Entry'!E236","v":0},{"$f":"'Financial Stmt Data Entry'!C206","v":0},{"$f":"+'Financial Stmt Data Entry'!C236","v":0}]
[null,null,null,"Difference (Should be zero)",null,null,{"$f":"+G50-G48","v":0},0,0,0,0,0,0,0]
["* If debt convenant not met, please attach bank waiver."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Line of Credit"]
["Revolving Note"]
["Demand Note"]
["Term Loan"]
["Shareholder/Member Loan"]
["Other"]
["Equipment Financing"]
["Route Purchase"]
["Other Operating"]
["Yes"]
["No"]
["N/A"]

{"sheet":"Available Financing","index":19,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,10,3,11],[0,0,0,11],[1,0,1,11]]}
[{"$f":"+Questionnaire!A1","v":"Type Terminal Operator Name and License # Here"}]
["Financing Review"]
[]
[null,"Approved","Date of","Date","Q1",null,"Q2 ",null,"Q3",null,"Q4"]
[null,"Financing","Executed","Sent","Life-To-Date","Financing","Life-To-Date","Financing","Life-To-Date","Financing","Life-To-Date","Financing"]
["Vendor","Amount","Agreement","To IGB","Draws","Available","Draws","Available","Draws","Available","Draws","Available"]
[null,null,null,null,null,{"$f":"+B7-E7","v":0},null,{"$f":"+B7-G7","v":0},null,{"$f":"+B7-I7","v":0},null,{"$f":"+B7-K7","v":0}]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
[null,null,null,null,null,0,null,0,null,0,null,0]
["  Total",{"$f":"SUM(B7:B35)","v":0},null,null,{"$f":"SUM(E7:E35)","v":0},0,0,0,0,0,0,0]
["  Quarter Comparison",null,null,null,null,null,null,{"$f":"+H36-F36","v":0},null,{"$f":"+J36-H36","v":0},null,{"$f":"+L36-J36","v":0}]

{"sheet":"Accts Receivable","index":20,"n_rows":71,"n_cols":13,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,8],[37,0,37,8],[54,0,54,8],[1,0,1,8],[2,0,2,8]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["AGED LISTING OF ACCOUNTS RECEIVABLE"]
["List all Gaming receivables separately - Gaming includes establishments, gaming suppliers and other terminal operators."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Gaming"]
[{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},null,null,null,null,null,null,null,null,null,null,null,"Other"]
["Customer (Provide Detailed List)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D7:H7)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total All Other","Other",0]
["TOTAL ACCOUNTS RECEIVABLE",null,{"$f":"SUM(C7:C17)","v":0},0,0,0,0,0]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!G151","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C18-C19","v":0}]
[]
[{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"}]
["Customer (Provide Detailed List)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D24:H24)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total All Other","Other",0]
["TOTAL ACCOUNTS RECEIVABLE",null,{"$f":"SUM(C24:C34)","v":0},0,0,0,0,0]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!F151","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C35-C36","v":0}]
[]
[{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"}]
["Customer (Provide Detailed List)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D41:H41)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total All Other","Other",0]
["TOTAL ACCOUNTS RECEIVABLE",null,{"$f":"SUM(C41:C51)","v":0},0,0,0,0,0]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!E151","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C52-C53","v":0}]
[]
[{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"}]
["Customer (Provide Detailed List)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D58:H58)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total All Other","Other",0]
["TOTAL ACCOUNTS RECEIVABLE",null,{"$f":"SUM(C58:C68)","v":0},0,0,0,0,0]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!D151","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C69-C70","v":0}]

{"sheet":"Accts Payable","index":21,"n_rows":124,"n_cols":13,"rows_kept":124,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8]]}
[{"$f":"+'Financial Stmt Data Entry'!A1","v":"Type Terminal Operator Name and License # Here"}]
["AGED LISTING OF ACCOUNTS PAYABLE"]
["List all Gaming payables separately - Gaming includes establishments, gaming suppliers, other terminal operators and gaming license/tax authorities.  Include an AP Vendor Payments listing with year to date activity with each quarterly submission."]
[{"$f":"+'Financial Stmt Data Entry'!G4","v":"Q1 2021"},null,null,null,null,null,null,null,null,null,null,null,"Gaming"]
["Vendor (Provide Detailed Listing)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D6:H6)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total - All Other","Other",0]
["TOTAL ACCOUNTS PAYABLE",null,{"$f":"SUM(C6:C31)","v":0},0,0,0,0,0]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!G208","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C32-C33","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!F4","v":"Q2 2021"},null,null,null,null,null,null,null,null,null,null,null,"Video Gaming"]
["Vendor (Provide Detailed Listing)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D37:H37)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total - All Other","Other",0]
["TOTAL ACCOUNTS PAYABLE",null,{"$f":"SUM(C37:C61)","v":0},{"$f":"SUM(D37:D61)","v":0},{"$f":"SUM(E37:E61)","v":0},{"$f":"SUM(F37:F61)","v":0},{"$f":"SUM(G37:G61)","v":0},{"$f":"SUM(H37:H61)","v":0}]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!F208","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C62-C63","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!E4","v":"Q3 2021"},null,null,null,null,null,null,null,null,null,null,null,"Video Gaming"]
["Vendor (Provide Detailed Listing)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D67:H67)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total - All Other","Other",0]
["TOTAL ACCOUNTS PAYABLE",null,{"$f":"SUM(C67:C91)","v":0},{"$f":"SUM(D67:D91)","v":0},{"$f":"SUM(E67:E91)","v":0},{"$f":"SUM(F67:F91)","v":0},{"$f":"SUM(G67:G91)","v":0},{"$f":"SUM(H67:H91)","v":0}]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!E208","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C92-C93","v":0}]
[{"$f":"+'Financial Stmt Data Entry'!D4","v":"Q4 2021"},null,null,null,null,null,null,null,null,null,null,null,"Video Gaming"]
["Vendor (Provide Detailed Listing)","Industry","Total","Current","30 Days","60 Days","90 Days","180+ Days","Explanation for over 90 days"]
[null,"Gaming",{"$f":"SUM(D97:H97)","v":0}]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
[null,"Gaming",0]
["Sub-total - All Other","Other",0]
["TOTAL ACCOUNTS PAYABLE",null,{"$f":"SUM(C97:C121)","v":0},{"$f":"SUM(D97:D121)","v":0},{"$f":"SUM(E97:E121)","v":0},{"$f":"SUM(F97:F121)","v":0},{"$f":"SUM(G97:G121)","v":0},{"$f":"SUM(H97:H121)","v":0}]
["Balance Per Balance Sheet",null,{"$f":"+'Financial Stmt Data Entry'!D208","v":0}]
["Check: Total Should be zero - Tie to Balance Sheet",null,{"$f":"+C122-C123","v":0}]

{"sheet":"Financial Stmt Change Log","index":22,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[{"$f":"+Questionnaire!A1","v":"Type Terminal Operator Name and License # Here"},null,null,null,null,null,null,null,"Yes"]
["Financial Statement Change Log ",null,null,null,null,null,null,null,"No"]
["(List journal entries posted to a prior reporting period; update financial stmt data entry and upload updated template, financial statements and amended return when applicable.)"]
[]
[]
["Date","Financial",null,null,null,"Amended"]
["Journal","Statement","Description",null,null,"Tax"]
["Entry","Period ","of Account","Debit/(Credit)",null,"Return"]
["Posted","Month/Year","Impacted","Amount","Reason for Change","Filed"]
["2014-07-26","2013-12-01","Depreciation Expense",50000,"06/14 audit revealed incorrect fixed asset lives used when calculating book depreciation.","No","Example"]
["2014-07-26","2013-12-01","Accumulated Depreciation",-50000,"06/14 audit revealed incorrect fixed asset lives used when calculating book depreciation.","No","Example"]