{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Corporate","Stores"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":3,"comments":0,"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":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[[10,1,10,9],[16,1,17,9],[5,1,5,9],[6,1,6,9],[11,1,12,9],[13,1,15,9]]}
["P&L Report Formating and Distribution"]
[]
["Inputs"]
["Period:",12,null,"EOP:","2018-09-30"]
["Year:",2018]
["Source File:",{"$f":"\"P\"&$B$5&\".xls\"","v":"P2018.xls"}]
["Review File:",{"$f":"\"PL Review_\"&B5&\"-P\"&IF(B4<10,\"0\",\"\")&B4&\".xlsm\"","v":"PL Review_2018-P12.xlsm"}]
[]
["Instructions - Report running and formatting"]
[1,"Update the inputs above (yellow boxes)."]
[{"$f":"A10+1","v":2},"Ensure that all open stores are reflected in the Stores sheet in this file."]
[{"$f":"A11+1","v":3},"Run the 18 PL Review report in FRx using the applicable report date that matches the EOP date above.  This will refresh the P2018.xls file in the FRx Downloads folder."]
[]
[{"$f":"[1]!Next_Number_Letter(A12)","v":4},"After the P2018.xls file is finished running, open it and then click the Format P&Ls button to the right to run the macro that will copy all of the sheets from the source file run in FRx to the period P&L template file, and format them so that they are easy to review.",null,null,null,null,null,null,null,null,null,"I:\\ReportingPkg\\2018 Rpt Pkg - Julios\\Frx Download\\P2018.XLS"]
[]
[]
[{"$f":"[1]!Next_Number_Letter(A14)","v":5},"Note - if you need to refresh the file, you must save the review file (filename referenced above in cell B7) as a different name, or it will be overwritten."]

{"sheet":"Corporate","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
["#","Cost center","Department","Group","Filename/Reviewer","Owner","Owner Email","Reviewer_Count","CC2"]
[1,0,"Unallocated","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E3&\"_\"&COUNTIFS($E$3:E3,E3)","v":"Accounting_KG_1"},{"$f":"IF(H3=\"\",\"\",B3)","v":0}]
[{"$f":"A3+1","v":2},10,"DFDE Corp","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E4&\"_\"&COUNTIFS($E$3:E4,E4)","v":"Accounting_KG_2"},10]
[3,20,"SULL Corp","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E5&\"_\"&COUNTIFS($E$3:E5,E5)","v":"Accounting_KG_3"},20]
[4,30,"DFG Corp","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E6&\"_\"&COUNTIFS($E$3:E6,E6)","v":"Accounting_KG_4"},30]
[5,60,"Lone Star Finance","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E7&\"_\"&COUNTIFS($E$3:E7,E7)","v":"Accounting_KG_5"},60]
[6,61,"Southlake Corporate Office","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E8&\"_\"&COUNTIFS($E$3:E8,E8)","v":"Accounting_KG_6"},61]
[7,81,"Center Cut Marketing","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E9&\"_\"&COUNTIFS($E$3:E9,E9)","v":"Accounting_KG_7"},81]
[8,1000,"Center Cut Hospitality","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E10&\"_\"&COUNTIFS($E$3:E10,E10)","v":"Accounting_KG_8"},1000]
[9,1005,"Executive","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E11&\"_\"&COUNTIFS($E$3:E11,E11)","v":"Accounting_KG_9"},1005]
[10,1009,"LS Consolidating Company","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E12&\"_\"&COUNTIFS($E$3:E12,E12)","v":"Accounting_KG_10"},{"$f":"IF(H12=\"\",\"\",B12)","v":1009}]
[11,1010,"Construction","Construction","Construction_BM","Bill Martens","bmartens@dfrg.com",{"$f":"E13&\"_\"&COUNTIFS($E$3:E13,E13)","v":"Construction_BM_1"},1010]
[12,1015,"Real Estate","Construction","Construction_BM","Bill Martens","bmartens@dfrg.com",{"$f":"E14&\"_\"&COUNTIFS($E$3:E14,E14)","v":"Construction_BM_2"},1015]
[13,1020,"Marketing","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E15&\"_\"&COUNTIFS($E$3:E15,E15)","v":"Marketing_BC_1"},1020]
[14,1035,"Internal Audit","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E16&\"_\"&COUNTIFS($E$3:E16,E16)","v":"Accounting_KG_11"},1035]
[15,1025,"Accounting","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E17&\"_\"&COUNTIFS($E$3:E17,E17)","v":"Accounting_KG_12"},1025]
[16,1030,"FP&A","FPA","FPA_AT","Andy Theodosis","atheodosis@dfrg.com",{"$f":"E18&\"_\"&COUNTIFS($E$3:E18,E18)","v":"FPA_AT_1"},1030]
[17,1040,"IT","IT","IT_JS","Juan Salas","jsalas@dfrg.com",{"$f":"E19&\"_\"&COUNTIFS($E$3:E19,E19)","v":"IT_JS_1"},1040]
[18,1045,"Legal","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E20&\"_\"&COUNTIFS($E$3:E20,E20)","v":"Accounting_KG_13"},1045]
[19,1055,"People & Education","People","People_AS","April Scopa","ascopa@dfrg.com",{"$f":"E21&\"_\"&COUNTIFS($E$3:E21,E21)","v":"People_AS_1"},1055]
[20,1060,"Management Education","People","People_AS","April Scopa","ascopa@dfrg.com",{"$f":"E22&\"_\"&COUNTIFS($E$3:E22,E22)","v":"People_AS_2"},1060]
[21,1065,"Del Frisco's RD's","DFDE RD","DFDE RD_RR","Ray Risley","rrisley@dfrg.com",{"$f":"E23&\"_\"&COUNTIFS($E$3:E23,E23)","v":"DFDE RD_RR_1"},1065]
[22,1066,"Sullivan's RD's","SULL RD","SULL RD_SS","Scott Smith","ssmith@dfrg.com",{"$f":"E24&\"_\"&COUNTIFS($E$3:E24,E24)","v":"SULL RD_SS_1"},1066]
[23,1067,"Grille RD's","DFG RD","DFG RD_SM","Sarah McAloon","smcaloon@dfrg.com",{"$f":"E25&\"_\"&COUNTIFS($E$3:E25,E25)","v":"DFG RD_SM_1"},1067]
[24,1070,"Corporate Culinary","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E26&\"_\"&COUNTIFS($E$3:E26,E26)","v":"Marketing_BC_2"},1070]
[25,1071,"Sullivan's Culinary","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E27&\"_\"&COUNTIFS($E$3:E27,E27)","v":"Marketing_BC_3"},1071]
[26,1072,"Del Frisco's Culinary","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E28&\"_\"&COUNTIFS($E$3:E28,E28)","v":"Marketing_BC_4"},1072]
[27,1073,"Grille Culinary","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E29&\"_\"&COUNTIFS($E$3:E29,E29)","v":"Marketing_BC_5"},1073]
[28,1075,"National Sales & Private Dining","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E30&\"_\"&COUNTIFS($E$3:E30,E30)","v":"Marketing_BC_6"},1075]
[29,1080,"Beverage","Marketing","Marketing_BC","Brandon Coleman","bcoleman@dfrg.com",{"$f":"E31&\"_\"&COUNTIFS($E$3:E31,E31)","v":"Marketing_BC_7"},1080]
[30,1085,"Purchasing","Purchasing","Purchasing_TS","Tony Schwappach","tschwappach@dfrg.com",{"$f":"E32&\"_\"&COUNTIFS($E$3:E32,E32)","v":"Purchasing_TS_1"},1085]
[31,2000,"Corporate Intercompany Clearing","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E33&\"_\"&COUNTIFS($E$3:E33,E33)","v":"Accounting_KG_14"},2000]
[32,5000,"Master Concentration","Accounting","Accounting_KG","Kyle Gathright","kgathright@dfrg.com",{"$f":"E34&\"_\"&COUNTIFS($E$3:E34,E34)","v":"Accounting_KG_15"},5000]

{"sheet":"Stores","index":2,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["No","Name",null,null,null,null,null,null,null,null,null,null,"Comp Store List"]
["001","Dallas, TX (Lemmon Ave.)"]
["002","Bethesda, MD"]
["004","Fort Worth, TX (Camp Bowie)"]
["005","Arlington, VA (Ballston)"]
["006","Reston, VA"]
["007","Chicago, IL (North Ave.)"]
["008","Dallas, TX (Keller Springs)"]
["009","Atlanta, GA (Peachtree)"]
["010","Gaithersburg, MD"]
["011","Lombard, IL (Oak Brook)"]
["012","Fairfax, VA"]
["014","Grapevine, TX"]
["015","Allen, TX (Stacy Rd)"]
["016","Boca Raton, FL (Mizner)"]
["017","Sandy Springs, GA (Perimeter)"]
["018","Woodbridge, VA"]
["019","Austin, TX"]
["020","Orland Park, IL"]
["022","Skokie, IL (Old Orchard)"]
["023","Ashburn, VA (Loudoun)"]
["024","Gainesville, VA"]
["025","Naperville, IL"]
["026","Katy, TX"]
["027","Vernon Hills, IL"]
["028","Schamburg, IL (Woodfield)"]
["029","Fort Worth, TX (Alliance)"]
["030","Brentwood, TN"]
["031","Orlando, FL (I-Drive)"]
["032","Kildeer, IL (Deer Park)"]
["033","Arlington, TX"]
["034","Spring, TX"]
["035","Columbia, MD"]
["036","Oklahoma City, OK"]
[{"$f":"\"037\"","v":"037"},"Annapolis, MD"]
[{"$f":"\"038\"","v":"038"},"Raleigh, NC (Durham)"]
[{"$f":"\"039\"","v":"039"},"Brookfield, WI"]