{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Copy_Resize"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"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":"Copy_Resize","index":0,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Copy & Resize Variably Sized Ranges"]
["Source Data",null,null,null,null,null,null,null,null,"Destination with copy method"]
[]
["Company","Business Unit","Actual Revenue","Budget Revenue","Variance",null,null,null,null,"Company","Business Unit","Actual Revenue","Budget Revenue","Variance"]
["Entity A","BU_1",10200,10404,{"$f":"C5/D5-1","v":-1.9607843137254943E-2},null,null,null,null,"Entity A","BU_1",10200,10404,{"$f":"L5/M5-1","v":-1.9607843137254943E-2}]
["Entity B","BU_1",12240,12484.800000000001,{"$f":"C6/D6-1","v":-1.9607843137254943E-2},null,null,null,null,"Entity B","BU_1",12240,12484.800000000001,{"$f":"L6/M6-1","v":-1.9607843137254943E-2}]
["Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2,null,null,null,null,"Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2]
["Entity D","BU_1",{"$f":"D8*1.1","v":19775.923199999997},17978.111999999997,0.10000000000000009,null,null,null,null,"Entity D","BU_1",{"$f":"M8*1.1","v":19775.923199999997},17978.111999999997,0.10000000000000009]
["Entity E","BU_2",10300,10506,-1.9607843137254943E-2,null,null,null,null,"Entity E","BU_2",10300,10506,-1.9607843137254943E-2]
["Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2,null,null,null,null,"Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2]
[]
[]
[]
[]
[]
[]
[]
["Paste here without header",null,null,null,null,null,null,null,null,"Destination with paste special method"]
[]
["Entity A","BU_1",10200,10404,-1.9607843137254943E-2,null,null,null,null,"Company","Business Unit","Actual Revenue","Budget Revenue","Variance"]
["Entity B","BU_1",12240,12484.800000000001,-1.9607843137254943E-2,null,null,null,null,"Entity A","BU_1",10200,10404,-1.9607843137254943E-2]
["Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2,null,null,null,null,"Entity B","BU_1",12240,12484.800000000001,-1.9607843137254943E-2]
["Entity D","BU_1",19775.923199999997,17978.111999999997,0.10000000000000009,null,null,null,null,"Entity C","BU_1",14688,14981.76,-1.9607843137254943E-2]
["Entity E","BU_2",10300,10506,-1.9607843137254943E-2,null,null,null,null,"Entity D","BU_1",19775.923199999997,17978.111999999997,0.10000000000000009]
["Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2,null,null,null,null,"Entity E","BU_2",10300,10506,-1.9607843137254943E-2]
[null,null,null,null,null,null,null,null,null,"Entity F","BU_2",12360,12607.2,-1.9607843137254943E-2]