{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Notes","SummaryData","NewData#1","NewData#2"],"not_rendered":{"charts":0,"images":3,"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":"Notes","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Overview"]
[]
[null,null,"If you're interested to become better in Excel, check out my ONLINE COURSES."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Sharing & Learning"]
[null,null,"Feel free to share this with anyone who can benefit!"]
[null,null,"Visit my other free Excel Tutorials."]

{"sheet":"SummaryData","index":1,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Absolute Versus Relative Recording"]
["Make sure you have values in A4 (Later we learn different methods of ensuring we don't run into problems)"]
["Company","Business Unit","Main Unit","Red Flag","Actual Revenue","Budget Revenue"]
["Entity A","BU_1","VC_A","Y",10200,10404]
["Entity B","BU_1","VC_A","N",12240,12484.800000000001]
["Entity C","BU_1","VC_A","N",14688,14981.76]
["Entity D","BU_1","VC_A","N",{"$f":"F7*1.1","v":19775.923199999997},17978.111999999997]
["Entity E","BU_2","VC_A","Y",10300,10506]

{"sheet":"NewData#1","index":2,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Copy data to Summary Tab"]
["Make sure you have more than one line of data"]
["Company","Business Unit","Main Unit","Red Flag","Actual Revenue","Budget Revenue"]
["Entity F","BU_2","VC_A","N",12360,12607.2]
["Entity G","BU_2","VC_A","N",14832,15128.64]
["Entity H","BU_2","VC_A","N",17798.399999999998,18154.367999999999]
["Entity I","BU_3","VC_B","Y",10400,10608]
["Entity J","BU_3","VC_B","N",{"$f":"F8","v":12729.6},12729.6]
["Entity K","BU_3","VC_B","N",14976,15275.52]
["Entity L","BU_4","VC_B","N",20000,20400]
["Entity M","BU_4","VC_B","Y",24000,24480]
["Entity N","BU_4","VC_B","N",28800,29376]
["Entity O","BU_4","VC_B","N",34560,35251.199999999997]
["Entity P","BU_5","VC_B","Y",41472,42301.440000000002]
["Entity Q","BU_6","VC_C","Y",49766.400000000001,50761.728000000003]
["Entity R","BU_6","VC_C","Y",10500,10710]
["Entity S","BU_6","VC_C","Y",{"$f":"F17*1.1","v":23731.107840000001},21573.734399999998]

{"sheet":"NewData#2","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Copy data to Summary Tab"]
["Make sure you have more than one line of data"]
["Company","Business Unit","Main Unit","Red Flag","Actual Revenue","Budget Revenue"]
["Entity T","BU_6","VC_C","N",25380.863999999998,25888.48128]
["Entity U","BU_7","VC_C","N",30457.036799999994,31066.177535999996]
["Entity V","BU_7","VC_C","N",10200,10404]
["Entity W","BU_7","VC_C","Y",12240,12484.800000000001]
["Entity X","BU_7","VC_C","N",14688,14981.76]
["Entity Y","BU_8","VC_C","N",10100,10302]
["Entity Z","BU_8","VC_C","N",10300,10506]