{"text_format":"2","workbook":"xlsx","n_sheets":11,"sheets":["Annual Sales - 2019 - 2020","Annual % Report - 2025","Annual % Report - 2024","Annual % Report - 2023","Annual % Report - 2022","Annual % Report - 2021","Annual % Report - 2020","Rent Schedule","Annual % Report - 2019","Annual Sales - 2020 - 2021","Annual Sales - 2018"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":8,"defined_names":1697,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Annual Sales - 2019 - 2020","index":0,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[{"$nulls":5},"GPS Percent Rent Calculation"]
[]
["001442-BKC (Thibodaux)"]
["Vendor Info","BKC",null,null,null,"001442-BKC"]
["2020 Base Rent ",11406.58]
[]
[]
[]
[null,null,"Sales","Monthly Breakpoint ","Excess Sales 1","Excess Sales 2","% - Tier 1","$ - Tier 1","% - Tier 2","$ - Tier 1","Total Tier Sales* %","Monthly Base Rents","Total Percent Rent - YTD","Amount Paid - YTD","Notes","Balance Due"]
[null,"2020-01-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!B$1,FALSE)","v":217878.14},{"$f":"(1599999.99/12)","v":133333.33249999999},{"$f":"IFERROR(IF(C10<D10,C10,D10),\"\")","v":133333.33249999999},{"$f":"IFERROR(IF(C10=\"\",\"\",IF(C10>D10,C10-D10,0)),\"\")","v":84544.807500000024},8.5000000000000006E-2,{"$f":"IFERROR(IF(C10=\"\",\"\",E10*G10),\"\")","v":11333.3332625},0.1,{"$f":"IFERROR(IF(C10=\"\",\"\",F10*I10),\"\")","v":8454.4807500000024},{"$f":"IFERROR(+H10+J10,\"\")","v":19787.814012500003},{"$f":"$B$5","v":11406.58},{"$f":"K10-L10","v":8381.2340125000028},null,null,{"$f":"K10-L10","v":8381.2340125000028}]
[null,"2020-02-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!C$1,FALSE)","v":233370.02999999997},{"$f":"(1599999.99/12)","v":133333.33249999999},{"$f":"IFERROR(IF(C11<D11,C11,D11),\"\")","v":133333.33249999999},{"$f":"IFERROR(IF(C11=\"\",\"\",IF(C11>D11,C11-D11,0)),\"\")","v":100036.69749999998},8.5000000000000006E-2,{"$f":"IFERROR(IF(C11=\"\",\"\",E11*G11),\"\")","v":11333.3332625},0.1,{"$f":"IFERROR(IF(C11=\"\",\"\",F11*I11),\"\")","v":10003.669749999999},{"$f":"IFERROR(+H11+J11,\"\")","v":21337.003012499998},{"$f":"$B$5","v":11406.58},{"$f":"K11-L11","v":9930.4230124999976},null,null,{"$f":"K11-L11","v":9930.4230124999976}]
[null,"2020-03-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!D$1,FALSE)","v":199115.05999999994},133333.33249999999,133333.33249999999,{"$f":"IFERROR(IF(C12=\"\",\"\",IF(C12>D12,C12-D12,0)),\"\")","v":65781.72749999995},8.5000000000000006E-2,{"$f":"IFERROR(IF(C12=\"\",\"\",E12*G12),\"\")","v":11333.3332625},0.1,{"$f":"IFERROR(IF(C12=\"\",\"\",F12*I12),\"\")","v":6578.1727499999952},17911.506012499995,11406.58,6504.9260124999946,null,null,6504.9260124999946]
[null,"Q1",{"$f":"SUM(C10:C12)","v":650363.23},{"$f":"SUM(D10:D12)","v":399999.99749999994},{"$f":"C13-D13","v":250363.23250000004},{"$f":"SUM(F10:F12)","v":250363.23249999995},8.5000000000000006E-2,{"$f":"SUM(H10:H12)","v":33999.999787499997},0.1,{"$f":"SUM(J10:J12)","v":25036.323249999998},{"$f":"SUM(K10:K12)","v":59036.323037499991},{"$f":"SUM(L10:L12)","v":34219.74},{"$f":"K13-L13","v":24816.583037499993},null,null,{"$f":"M13-N13","v":24816.583037499993},"Period Accrual to Actual Month Payment Variance"]
[null,"2020-04-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!E$1,FALSE)","v":170785.86},133333.33249999999,133333.33249999999,{"$f":"IFERROR(IF(C14=\"\",\"\",IF(C14>D14,C14-D14,0)),\"\")","v":37452.527499999997},8.5000000000000006E-2,{"$f":"IFERROR(IF(C14=\"\",\"\",E14*G14),\"\")","v":11333.3332625},0.1,{"$f":"IFERROR(IF(C14=\"\",\"\",F14*I14),\"\")","v":3745.2527499999997},15078.5860125,11406.58,3672.0060125,null,null,3672.0060125]
[null,"2020-05-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!F$1,FALSE)","v":221984.80999999982},133333.33249999999,133333.33249999999,{"$f":"IFERROR(IF(C15=\"\",\"\",IF(C15>D15,C15-D15,0)),\"\")","v":88651.477499999834},8.5000000000000006E-2,{"$f":"IFERROR(IF(C15=\"\",\"\",E15*G15),\"\")","v":11333.3332625},0.1,{"$f":"IFERROR(IF(C15=\"\",\"\",F15*I15),\"\")","v":8865.1477499999837},20198.481012499986,11406.58,8791.9010124999859,null,null,8791.9010124999859]
[null,"2020-06-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!G$1,FALSE)","v":231089.46000000002},133333.33249999999,133333.33249999999,{"$f":"IFERROR(IF(C16=\"\",\"\",IF(C16>D16,C16-D16,0)),\"\")","v":97756.127500000031},8.5000000000000006E-2,{"$f":"IFERROR(IF(C16=\"\",\"\",E16*G16),\"\")","v":11333.3332625},0.1,{"$f":"IFERROR(IF(C16=\"\",\"\",F16*I16),\"\")","v":9775.6127500000039},{"$f":"IFERROR(+H16+J16,\"\")","v":21108.946012500004},11406.58,9702.3660125000042,null,null,9702.3660125000042]
[null,"Q2",{"$f":"SUM(C14:C16)","v":623860.12999999989},{"$f":"SUM(D14:D16)","v":399999.99749999994},{"$f":"C17-D17","v":223860.13249999995},{"$f":"SUM(F14:F16)","v":223860.13249999986},8.5000000000000006E-2,{"$f":"SUM(H14:H16)","v":33999.999787499997},0.1,{"$f":"SUM(J14:J16)","v":22386.013249999989},{"$f":"SUM(K14:K16)","v":56386.013037499986},{"$f":"SUM(L14:L16)","v":34219.74},{"$f":"K17-L17","v":22166.273037499988},null,null,{"$f":"M17-N17","v":22166.273037499988},"Period Accrual to Actual Month Payment Variance"]
[null,"2020-07-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!H$1,FALSE)","v":0},null,0,{"$f":"IFERROR(IF(C18=\"\",\"\",IF(C18>D18,C18-D18,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C18=\"\",\"\",E18*G18),\"\")","v":0},0.1,{"$f":"IFERROR(IF(C18=\"\",\"\",F18*I18),\"\")","v":0},0,null,0,null,null,0]
[null,"2020-08-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!I$1,FALSE)","v":0},null,0,{"$f":"IFERROR(IF(C19=\"\",\"\",IF(C19>D19,C19-D19,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C19=\"\",\"\",E19*G19),\"\")","v":0},0.1,{"$f":"IFERROR(IF(C19=\"\",\"\",F19*I19),\"\")","v":0},{"$f":"IFERROR(+H19+J19,\"\")","v":0},null,{"$f":"K19-L19","v":0},null,null,{"$f":"K19-L19","v":0}]
[null,"2020-09-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!J$1,FALSE)","v":0},0,0,{"$f":"IFERROR(IF(C20=\"\",\"\",IF(C20>D20,C20-D20,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C20=\"\",\"\",E20*G20),\"\")","v":0},0.1,{"$f":"IFERROR(IF(C20=\"\",\"\",F20*I20),\"\")","v":0},0,0,0,null,null,0]
[null,"Q3",{"$f":"SUM(C18:C20)","v":0},{"$f":"SUM(D18:D20)","v":0},{"$f":"C21-D21","v":0},{"$f":"SUM(F18:F20)","v":0},8.5000000000000006E-2,{"$f":"SUM(H18:H20)","v":0},0.1,{"$f":"SUM(J18:J20)","v":0},{"$f":"SUM(K18:K20)","v":0},{"$f":"SUM(L18:L20)","v":0},{"$f":"K21-L21","v":0},null,null,{"$f":"M21-N21","v":0},"Period Accrual to Actual Month Payment Variance"]
[null,"2020-10-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!K$1,FALSE)","v":0},0,0,{"$f":"IFERROR(IF(C22=\"\",\"\",IF(C22>D22,C22-D22,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C22=\"\",\"\",E22*G22),\"\")","v":0},0.1,{"$f":"IFERROR(IF(C22=\"\",\"\",F22*I22),\"\")","v":0},0,0,0,null,null,{"$f":"K22-L22","v":0}]
[null,"2020-11-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!L$1,FALSE)","v":0},0,0,{"$f":"IFERROR(IF(C23=\"\",\"\",IF(C23>D23,C23-D23,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C23=\"\",\"\",E23*G23),\"\")","v":0},0.1,{"$f":"IFERROR(IF(C23=\"\",\"\",F23*I23),\"\")","v":0},0,0,0,null,null,0]
[null,"2020-12-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$N,'[2]BKC PIVOT'!M$1,FALSE)","v":0},0,0,{"$f":"IFERROR(IF(C24=\"\",\"\",IF(C24>D24,C24-D24,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C24=\"\",\"\",E24*G24),\"\")","v":0},0.1,{"$f":"IFERROR(IF(C24=\"\",\"\",F24*I24),\"\")","v":0},0,0,0,null,null,0]
[null,"Q4",{"$f":"SUM(C22:C24)","v":0},{"$f":"SUM(D22:D24)","v":0},{"$f":"C25-D25","v":0},{"$f":"SUM(F22:F24)","v":0},8.5000000000000006E-2,{"$f":"SUM(H22:H24)","v":0},0.1,{"$f":"SUM(J22:J24)","v":0},{"$f":"SUM(K22:K24)","v":0},{"$f":"SUM(L22:L24)","v":0},{"$f":"K25-L25","v":0},null,null,{"$f":"M25-N25","v":0},"Period Accrual to Actual Month Payment Variance"]
[null,"Total",{"$f":"$C$25+$C$21+$C$17+$C$13","v":1274223.3599999999},{"$f":"$D$25+$D$21+$D$17+$D$13","v":799999.99499999988},{"$f":"$E$25+$E$21+$E$17+$E$13","v":474223.36499999999},{"$f":"$F$25+$F$21+$F$17+$F$13","v":474223.36499999982},8.4999999999999978E-2,{"$f":"$H$25+$H$21+$H$17+$H$13","v":67999.999574999994},9.9999999999999992E-2,{"$f":"$J$25+$J$21+$J$17+$J$13","v":47422.33649999999},{"$f":"$K$25+$K$21+$K$17+$K$13","v":115422.33607499997},{"$f":"$L$25+$L$21+$L$17+$L$13","v":68439.48},{"$f":"K26-L26","v":46982.856074999974},{"$f":"$N$25+$N$21+$N$17+$N$13","v":0},null,{"$f":"M26-N26","v":46982.856074999974}]
[]
[{"$nulls":14},"P6 Accrual",7915.08]
[{"$nulls":15},{"$f":"P26-P28","v":39067.776074999972}]

{"sheet":"Annual % Report - 2025","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",2025,2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2,{"$f":"EOMONTH('Annual % Report - 2024'!$C$21,1)","v":"2025-01-31"},247685.0100000001]
[null,3,{"$f":"EOMONTH(C10,1)","v":"2025-02-28"},242612.35000000012]
[null,4,{"$f":"EOMONTH(C11,1)","v":"2025-03-31"},294045.14999999962]
[null,5,"2025-04-30",274013.88000000018]
[null,6,"2025-05-31",287382.53000000014]
[null,7,"2025-06-30",265797.94000000006]
[null,8,"2025-07-31",276841.80999999994]
[null,9,"2025-08-31",286849.9800000001]
[null,10,"2025-09-30",275114.53999999998]
[null,11,"2025-10-31",295420.04999999993]
[null,12,"2025-11-30",270726.18]
[null,13,"2025-12-31",298854.42]

{"sheet":"Annual % Report - 2024","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",{"$f":"YEAR($C$10)","v":2024},2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2,{"$f":"EOMONTH('Annual % Report - 2023'!$C$21,1)","v":"2024-01-31"},{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B10,FALSE)","v":235071.60000000009}]
[null,3,{"$f":"EOMONTH(C10,1)","v":"2024-02-29"},{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B11,FALSE)","v":246218.06999999992}]
[null,4,{"$f":"EOMONTH(C11,1)","v":"2024-03-31"},{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B12,FALSE)","v":260850.79000000012}]
[null,5,"2024-04-30",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B13,FALSE)","v":244260.22000000009}]
[null,6,"2024-05-31",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B14,FALSE)","v":253799.24999999991}]
[null,7,"2024-06-30",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B15,FALSE)","v":249325.80999999988}]
[null,8,"2024-07-31",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B16,FALSE)","v":239529.55999999985}]
[null,9,"2024-08-31",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B17,FALSE)","v":250273.30999999994}]
[null,10,"2024-09-30",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B18,FALSE)","v":245249.49999999994}]
[null,11,"2024-10-31",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B19,FALSE)","v":276829.53999999975}]
[null,12,"2024-11-30",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B20,FALSE)","v":252265.07}]
[null,13,"2024-12-31",{"$f":"VLOOKUP($F$4,'[3]BKC PIVOT'!$A:$M,$B21,FALSE)","v":270441.53000000003}]

{"sheet":"Annual % Report - 2023","index":3,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",{"$f":"YEAR($C$10)","v":2023},2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2,{"$f":"EOMONTH('Annual % Report - 2022'!$C$21,1)","v":"2023-01-31"},{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B10,FALSE)","v":237525.94999999998}]
[null,3,{"$f":"EOMONTH(C10,1)","v":"2023-02-28"},{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B11,FALSE)","v":244699.13000000006}]
[null,4,{"$f":"EOMONTH(C11,1)","v":"2023-03-31"},{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B12,FALSE)","v":274400.28000000009}]
[null,5,"2023-04-30",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B13,FALSE)","v":255666.43000000028}]
[null,6,"2023-05-31",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B14,FALSE)","v":258438.18000000002}]
[null,7,"2023-06-30",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B15,FALSE)","v":247348.27999999997}]
[null,8,"2023-07-31",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B16,FALSE)","v":252216.56000000003}]
[null,9,"2023-08-31",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B17,FALSE)","v":255644.6099999999}]
[null,10,"2023-09-30",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B18,FALSE)","v":259596.64}]
[null,11,"2023-10-31",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B19,FALSE)","v":270544.56}]
[null,12,"2023-11-30",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B20,FALSE)","v":244241.89999999997}]
[null,13,"2023-12-31",{"$f":"VLOOKUP($F$4,'[4]BKC PIVOT'!$A:$M,$B21,FALSE)","v":259052.67999999996}]

{"sheet":"Annual % Report - 2022","index":4,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",{"$f":"YEAR($C$10)","v":2022},2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2,{"$f":"EOMONTH('Annual % Report - 2021'!$C$21,1)","v":"2022-01-31"},{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B10,FALSE)","v":218223.59000000008}]
[null,3,{"$f":"EOMONTH(C10,1)","v":"2022-02-28"},{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B11,FALSE)","v":230700.60000000006}]
[null,4,{"$f":"EOMONTH(C11,1)","v":"2022-03-31"},{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B12,FALSE)","v":266878.99999999988}]
[null,5,"2022-04-30",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B13,FALSE)","v":232587.00999999998}]
[null,6,"2022-05-31",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B14,FALSE)","v":244609.4899999999}]
[null,7,"2022-06-30",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B15,FALSE)","v":234937.60000000009}]
[null,8,"2022-07-31",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B16,FALSE)","v":244882.33999999997}]
[null,9,"2022-08-31",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B17,FALSE)","v":237888.16}]
[null,10,"2022-09-30",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B18,FALSE)","v":242279.50999999992}]
[null,11,"2022-10-31",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B19,FALSE)","v":255465.59}]
[null,12,"2022-11-30",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B20,FALSE)","v":243547.57000000007}]
[null,13,"2022-12-31",{"$f":"VLOOKUP($F$4,'[5]BKC PIVOT'!$A:$M,$B21,FALSE)","v":253183.11000000004}]

{"sheet":"Annual % Report - 2021","index":5,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",{"$f":"YEAR($C$10)","v":2021},2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2,{"$f":"EOMONTH('Annual % Report - 2020'!$C$21,1)","v":"2021-01-31"},{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B10,FALSE)","v":218366.94999999995}]
[null,3,{"$f":"EOMONTH(C10,1)","v":"2021-02-28"},{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B11,FALSE)","v":193725.25000000003}]
[null,4,{"$f":"EOMONTH(C11,1)","v":"2021-03-31"},{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B12,FALSE)","v":239248.85000000006}]
[null,5,"2021-04-30",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B13,FALSE)","v":237868.63000000009}]
[null,6,"2021-05-31",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B14,FALSE)","v":229087.54000000007}]
[null,7,"2021-06-30",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B15,FALSE)","v":218066.71}]
[null,8,"2021-07-31",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B16,FALSE)","v":231612.91000000003}]
[null,9,"2021-08-31",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B17,FALSE)","v":196245.21999999991}]
[null,10,"2021-09-30",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B18,FALSE)","v":116072.94000000005}]
[null,11,"2021-10-31",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B19,FALSE)","v":219950.42}]
[null,12,"2021-11-30",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B20,FALSE)","v":163694.89999999997}]
[null,13,"2021-12-31",{"$f":"VLOOKUP($F$4,'[6]BKC PIVOT'!$A:$M,$B21,FALSE)","v":123190.87999999998}]

{"sheet":"Annual % Report - 2020","index":6,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",{"$f":"YEAR($C$10)","v":2020},2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2,"2020-01-01",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B10,FALSE)","v":217878.14}]
[null,3,{"$f":"EOMONTH(C10,1)","v":"2020-02-29"},{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B11,FALSE)","v":233370.02999999997}]
[null,4,{"$f":"EOMONTH(C11,1)","v":"2020-03-31"},{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B12,FALSE)","v":199115.05999999994}]
[null,5,"2020-04-30",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B13,FALSE)","v":170785.86000000002}]
[null,6,"2020-05-31",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B14,FALSE)","v":221984.80999999994}]
[null,7,"2020-06-30",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B15,FALSE)","v":231089.46000000005}]
[null,8,"2020-07-31",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B16,FALSE)","v":246338.51000000004}]
[null,9,"2020-08-31",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B17,FALSE)","v":249464.7}]
[null,10,"2020-09-30",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B18,FALSE)","v":227764.61}]
[null,11,"2020-10-31",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B19,FALSE)","v":249109.03000000003}]
[null,12,"2020-11-30",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B20,FALSE)","v":220720.09000000003}]
[null,13,"2020-12-31",{"$f":"VLOOKUP($F$4,'[7]BKC PIVOT'!$A:$M,$B21,FALSE)","v":234449.15000000005}]

{"sheet":"Rent Schedule","index":7,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Begin Date","End Date","Approval Status","Payment Amount","Daily Rent Rate","Annual Amount","Rate","First Payment","Last Payment","Is CPI?","Notes"]
["2016-12-19","2019-12-31","Approved",9918.75,null,119025,null,4159.4799999999996,9918.75,"No","Extension Yr 11-15 Base Rent per 1st Amendment (prior BK SL)"]
["2020-01-01","2024-12-31","Approved",11406.58,null,136879,null,11406.58,11406.58,"No","Option 1 Base Rent per 1st Amendment (prior BK SL)"]
["2025-01-01","2029-12-31","Approved",13117.5,null,157410,null,13117.5,13117.5,"No","Yr 1-5 Base Rent per Lease"]
["2030-01-01","2034-12-31","Approved",14429.33,null,173152,null,14429.33,14429.33,"No","Yr 6-10 Base Rent per Lease"]
["2035-01-01","2039-12-31","Approved",15872.25,null,190467,null,15872.25,15872.25,"No","Yr 11-15 Base Rent per Lease"]
["2040-01-01","2044-12-31","Approved",17459.5,null,209514,null,17459.5,17459.5,"No","Option 1 Base Rent per Lease"]
["2045-01-01","2049-12-31","Approved",19205.419999999998,null,230465,null,19205.419999999998,19205.419999999998,"No","Option 2 Base Rent per Lease"]
["2050-01-01","2054-12-31","Approved",21126,null,253512,null,21126,21126,"No","Option 3 Base Rent per Lease"]
["2055-01-01","2059-12-31","Approved",23238.58,null,278863,null,23238.58,23238.58,"No","Option 4 Base Rent per Lease"]

{"sheet":"Annual % Report - 2019","index":8,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",2019,2017]
[null,null,"ALIGNMENT","001442-BKC (Thibodaux)",null,{"$f":"LEFT(D4,10)","v":"001442-BKC"}]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,2019,"January",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!B$3,FALSE)","v":239769.37999999992}]
[null,2019,"February",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!C$3,FALSE)","v":243787.07}]
[null,2019,"March",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!D$3,FALSE)","v":270527.04999999987}]
[null,2019,"April",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!E$3,FALSE)","v":246494.97000000006}]
[null,2019,"May",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!F$3,FALSE)","v":249695.28999999989}]
[null,2019,"June",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!G$3,FALSE)","v":239179.78000000009}]
[null,2019,"July",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!H$3,FALSE)","v":232995.72}]
[null,2019,"August",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!I$3,FALSE)","v":245259.78}]
[null,2019,"September",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!J$3,FALSE)","v":242782.47}]
[null,2019,"October",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!K$3,FALSE)","v":256216.3300000001}]
[null,2019,"November",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!L$3,FALSE)","v":227318.01999999993}]
[null,2019,"December",{"$f":"VLOOKUP($F$4,'[8]BKC PIVOT 2'!$A:$M,'[8]BKC PIVOT 2'!M$3,FALSE)","v":235114.49000000005}]
[]
[null,null,"Gross Sales",{"$f":"SUM(D10:D21)","v":2929140.35}]
[null,null,{"$f":"\"- Breakpoint\"","v":"- Breakpoint"},{"$f":"(119025/0.05)/12*COUNT($D$10:$D$21)","v":2380500}]
[]
[null,null,"Sales over breakpoint",{"$f":"IF(D23-D24<0,0,D23-D24)","v":548640.35000000009}]
[null,null,"Percent Rent %",0.05]
[null,null,"Percent Rent Due",{"$f":"D26*D27","v":27432.017500000005}]
[null,null,"Less Annual Percent Rent Paid ",{"$f":"7858.45+6919.71+6211.43+6095.94","v":27085.53}]
[null,null,"Percent Rent Due",{"$f":"D28-D29","v":346.48750000000655}]

{"sheet":"Annual Sales - 2020 - 2021","index":9,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[{"$nulls":5},"GPS Percent Rent Calculation"]
[]
["000331-BKC (7 Mile Livonia)"]
["Vendor Info","BKC",null,null,null,"000331-BKC"]
["2020 Base Rent ",10301.68]
[]
[]
[]
[null,null,"Sales","Monthly Breakpoint ","Excess Sales 1","Excess Sales 2","% - Tier 1","$ - Tier 1","% - Tier 2","$ - Tier 1","Total Tier Sales* %","Monthly Base Rents","Total Percent Rent - YTD","Amount Paid - YTD","Notes","Balance Due"]
[null,"2020-08-01",130419.57,{"$f":"(1599999.99/12)","v":133333.33249999999},{"$f":"IFERROR(IF(C10<D10,C10,D10),\"\")","v":130419.57},{"$f":"IFERROR(IF(C10=\"\",\"\",IF(C10>D10,C10-D10,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C10=\"\",\"\",E10*G10),\"\")","v":11085.663450000002},0.1,{"$f":"IFERROR(IF(C10=\"\",\"\",F10*I10),\"\")","v":0},{"$f":"IFERROR(+H10+J10,\"\")","v":11085.663450000002},7091.69,{"$f":"K10-L10","v":3993.9734500000022},null,null,{"$f":"K10-L10","v":3993.9734500000022}]
[null,"2020-09-01",123659.55,{"$f":"(1599999.99/12)","v":133333.33249999999},{"$f":"IFERROR(IF(C11<D11,C11,D11),\"\")","v":123659.55},{"$f":"IFERROR(IF(C11=\"\",\"\",IF(C11>D11,C11-D11,0)),\"\")","v":0},8.5000000000000006E-2,{"$f":"IFERROR(IF(C11=\"\",\"\",E11*G11),\"\")","v":10511.061750000001},0.1,{"$f":"IFERROR(IF(C11=\"\",\"\",F11*I11),\"\")","v":0},{"$f":"IFERROR(+H11+J11,\"\")","v":10511.061750000001},7091.69,{"$f":"K11-L11","v":3419.3717500000012},null,null,{"$f":"K11-L11","v":3419.3717500000012}]
[null,"2020-10-01",124947.21,133333.33249999999,124947.21,0,8.5000000000000006E-2,10620.512850000001,0.1,0,10620.512850000001,7091.69,3528.8228500000014,null,null,3528.8228500000014]
[null,"2020-11-01",100113.79000000001,133333.33249999999,100113.79000000001,0,8.5000000000000006E-2,8509.6721500000021,0.1,0,8509.6721500000021,7091.69,1417.9821500000025,null,null,1417.9821500000025]
[null,"2020-12-01",125419.31000000003,133333.33249999999,125419.31000000003,0,8.5000000000000006E-2,10660.641350000004,0.1,0,10660.641350000004,7091.69,3568.9513500000039,null,null,3568.9513500000039]
[null,"2021-01-01",127059.73000000001,133333.33249999999,127059.73000000001,0,8.5000000000000006E-2,10800.077050000002,0.1,0,10800.077050000002,7091.69,3708.3870500000021,null,null,3708.3870500000021]
[null,"2021-02-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$G,'[2]BKC PIVOT'!$E$1,FALSE)","v":108861.31000000001},133333.33249999999,108861.31000000001,0,8.5000000000000006E-2,9253.2113500000014,0.1,0,9253.2113500000014,7091.69,2161.5213500000018,null,null,{"$f":"K16-L16","v":2161.5213500000018}]
[null,"2021-03-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$G,'[2]BKC PIVOT'!$F$1,FALSE)","v":152867.48999999985},133333.33249999999,133333.33249999999,19534.157499999856,8.5000000000000006E-2,11333.3332625,0.1,1953.4157499999856,{"$f":"IFERROR(+H17+J17,\"\")","v":13286.749012499986},7091.69,{"$f":"K17-L17","v":6195.0590124999862},null,null,{"$f":"K17-L17","v":6195.0590124999862}]
[null,"2021-04-01",{"$f":"VLOOKUP($F$4,'[2]BKC PIVOT'!$A:$G,'[2]BKC PIVOT'!$G$1,FALSE)","v":170000.16999999995},133333.33249999999,133333.33249999999,36666.837499999965,8.5000000000000006E-2,11333.3332625,0.1,3666.6837499999965,15000.017012499997,7091.69,7908.3270124999972,null,null,7908.3270124999972]
[null,"2021-05-01",0,0,0,0,8.5000000000000006E-2,0,0.1,0,0,0,0,null,null,{"$f":"K19-L19","v":0}]
[null,"2021-06-01",0,0,0,0,8.5000000000000006E-2,0,0.1,0,0,0,0,null,null,0]
[null,"2021-07-01",0,0,0,0,8.5000000000000006E-2,0,0.1,0,0,0,0,null,null,0]
[]
[null,"Total",{"$f":"SUM(C10:C22)","v":1163348.1299999999},{"$f":"SUM(D10:D22)","v":1199999.9924999999},{"$f":"SUM(E10:E22)","v":1107147.135},{"$f":"SUM(F10:F22)","v":56200.994999999821},8.4999999999999978E-2,{"$f":"SUM(H10:H22)","v":94107.506475000017},9.9999999999999992E-2,{"$f":"SUM(J10:J22)","v":5620.0994999999821},{"$f":"SUM(K10:K22)","v":99727.605974999999},{"$f":"SUM(L10:L22)","v":63825.210000000006},{"$f":"SUM(M10:M22)","v":35902.395974999999},0,null,{"$f":"SUM(P10:P22)","v":35902.395974999999}]

{"sheet":"Annual Sales - 2018","index":10,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["#hidecolumn","GPS MONTHLY SALES REPORT"]
[]
[null,null,"YEAR",2019,2017]
[null,null,"ALIGNMENT","000035-BKC (35 - Mobile Hwy)",null,"000035-BKC"]
[{"$f":"IFERROR(IF(D5=\"\",\"#hiderow\",IF(D5=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR INFO"]
[{"$f":"IFERROR(IF(D6=\"\",\"#hiderow\",IF(D6=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR FAX"]
[{"$f":"IFERROR(IF(D7=\"\",\"#hiderow\",IF(D7=0,\"hiderow\",\"\")),\"hiderow\")","v":"#hiderow"},null,"VENDOR EMAIL"]
[]
[null,null,null,"Sales"]
[null,null,"2019-01-01",146973.81000000006]
[null,null,"2019-02-01",149364.53999999998]
[null,null,"2019-03-01",173418.35000000009]
[null,null,"2019-04-01",153529.26999999993]
[null,null,"2019-05-01",143860.27000000011]
[null,null,"2019-06-01",131093.26]
[null,null,"2019-07-01",133792.84000000003]
[null,null,"2019-08-01",140272.81999999998]
[null,null,"2019-09-01",125703.84000000001]
[null,null,"2019-10-01",130419.56999999999]
[null,null,"2019-11-01",123659.54999999997]
[null,null,"2019-12-01",124947.21000000004]
[null,null,"2019 Total",1677035.33]