{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","NGC36Sheet","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":37,"n_cols":27,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,5],[3,0,3,8],[16,2,16,3],[17,2,17,3],[2,0,2,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[8,0,8,8],[7,0,7,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[30,2,30,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[22,2,22,3],[23,2,23,3],[27,2,27,3],[28,2,28,3],[29,2,29,3]]}
["Instructions for creating NGC-36 Form in Excel and  generate an XML file for upload"]
["Please Note:  The data entered in NGC36Sheet must meet the validation rules as shown in table below. No cells or rows may be left blank. If this is not done correctly, the XML will not be created correctly and the upload process will fail"]
[]
["1.  Enable macros for the NGC36XML.xlsx workbook."]
["2.  Enter the filing location number of the SRO in the locid field."]
["3.  Enter the serviced location information into the NGC36Sheet beneath the pre-defined columns."]
["4.  Generate the XML file:"]
["a.  Excel 2007 and above, click the \"Generate XML\" button on the NGC36Sheet worksheet. (Note: The XML file will be created in the same folder as this spreadsheet.)"]
["b.  Older versions of Excel, click \"File\" => \"Save As\" option from the menu bar at the top of the page."]
["i.  Select and note the location where you would like to save the file."]
["ii.  Enter the name of the file, without spaces or special characters."]
["iii.  Select \"XML Data\" as the type of file to save."]
["iv.  If prompted about the loss of worksheet features, click the \"Continue\" button."]
["5.  If prompted about an error indicating that the data is not valid according to its schema, click the \"Details\" button to view the error.  Correct the invalid entry and re-create the XML file (repeat step 4 above)."]
[]
["Data entered must follow the rules defined below:"]
["Column Title","Column Name","Values Allowed",null,"Column Title","Column Name","Values Allowed"]
["locid","A","Filing location number eg. 99999-99",null,"NickelDrop","N","Between -999999999.99 and 999999999.99"]
["ServiceLocId","A","Location number ",null,"NickelWin","O","Between -999999999.99 and 999999999.99"]
["PercentOwnership","B","Between 0 and 100",null,"QuarterCount","P","Between 0 and 9999.99"]
["SPFlag","C","S or P",null,"QuarterCoinIn","Q","Between -999999999.99 and 999999999.99"]
["PrimaryOrSecondary","D","P or S",null,"QuarterDrop","R","Between -999999999.99 and 999999999.99"]
["DaysOperated","E","Between 0 and 92",null,"QuarterWin","S","Between -999999999.99 and 999999999.99"]
["EndOfPeriod","F","Y or N",null,"DollarCount","T","Between 0 and 9999.99"]
["SpaceLeasePayment","G","Between 0 And 999999999.99",null,"DollarCoinIn","U","Between -999999999.99 and 999999999.99"]
["TotalWinRetained","H","Between -999999999.99 and 999999999.99",null,"DollarDrop","V","Between -999999999.99 and 999999999.99"]
["AnnualFee","I","Between 0 And 999999999.99",null,"DollarWin","W","Between -999999999.99 and 999999999.99"]
["QuarterlyFee","J","Between 0 And 999999999.99",null,"OtherCount","X","Between 0 and 9999.99"]
["PercentageFee","K","Between 0 And 999999999.99",null,"OtherCoinIn","Y","Between -999999999.99 and 999999999.99"]
["NickelCount","L","Between 0 and 9999.99",null,"OtherDrop","Z","Between -999999999.99 and 999999999.99"]
["NickelCoinIn","M","Between -999999999.99 and 999999999.99",null,"OtherWin","AA","Between -999999999.99 and 999999999.99"]
[]
["Sample Data:"]
["locid","99999-99"]
["ServiceLocId","PercentOwnership","SPFlag","PrimaryOrSecondary","DaysOperated","EndOfPeriod","SpaceLeasePayment","TotalWinRetained","AnnualFee","QuarterlyFee","PercentageFee","NickelCount","NickelCoinIn","NickelDrop","NickelWin","QuarterCount","QuarterCoinIn","QuarterDrop","QuarterWin","DollarCount","DollarCoinIn","DollarDrop","DollarWin","OtherCount","OtherCoinIn","OtherDrop","OtherWin"]
["11111-11",0,"P","P",92,"Y",0,23278.45,224.97,72.03,1706.54,0,0,0,0,0,0,0,0,0,0,0,0,18,1569043.36,911982.86,126409.95]
["22222-22",0,"P","P",30,"Y",0,75.58,3.13,1,5.77,0,0,0,0,0,0,0,0,0,0,0,0,1,17604.099999999999,9403.91,569.82000000000005]

{"sheet":"NGC36Sheet","index":1,"n_rows":4,"n_cols":27,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[]
["locid"]
["ServiceLocId","PercentOwnership","SPFlag","PrimaryOrSecondary","DaysOperated","EndOfPeriod","SpaceLeasePayment","TotalWinRetained","AnnualFee","QuarterlyFee","PercentageFee","NickelCount","NickelCoinIn","NickelDrop","NickelWin","QuarterCount","QuarterCoinIn","QuarterDrop","QuarterWin","DollarCount","DollarCoinIn","DollarDrop","DollarWin","OtherCount","OtherCoinIn","OtherDrop","OtherWin"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}