{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,9]]}
[]
[null,"Skipping Every Other Column"]
[]
[null,"Name ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"]
[null,"Pope",2974,3179,2839,2620,2819,2774,3123,2614]
[null,"Nick ",2915,2625,3184,2969,2774,3129,3053,2856]
[null,"James",2791,2572,3124,2867,2993,2513,2713,2883]
[null,"William",2828,3097,2551,2555,3079,3161,2544,3077]
[null,"Noah",2920,2897,3193,3013,2839,2599,3005,3013]
[null,"Elijah",2504,2950,2996,3098,2619,3148,2633,2725]
[null,"Daniel",2928,2530,2715,2894,2931,3006,3153,3020]
[null,"Gakpo",3088,2674,3185,3129,2637,3015,3001,2553]

{"sheet":"Sheet1","index":1,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,12]]}
[]
[null,"Combination of MOD,COLUMN and SUMPRODUCT Functions"]
[]
[null,"Name ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug",null,"Name","Result "]
[null,"Pope",2974,3179,2839,2620,2819,2774,3123,2614,null,"Pope",{"$f":"SUMPRODUCT(C5:J5*MOD(COLUMN(C5:J5)-COLUMN(C5)+1,2))","v":11755}]
[null,"Nick ",2915,2625,3184,2969,2774,3129,3053,2856,null,"Nick ",{"$f":"SUMPRODUCT(C6:J6*MOD(COLUMN(C6:J6)-COLUMN(C6)+1,2))","v":11926}]
[null,"James",2791,2572,3124,2867,2993,2513,2713,2883,null,"James",{"$f":"SUMPRODUCT(C7:J7*MOD(COLUMN(C7:J7)-COLUMN(C7)+1,2))","v":11621}]
[null,"William",2828,3097,2551,2555,3079,3161,2544,3077,null,"William",{"$f":"SUMPRODUCT(C8:J8*MOD(COLUMN(C8:J8)-COLUMN(C8)+1,2))","v":11002}]
[null,"Noah",2920,2897,3193,3013,2839,2599,3005,3013,null,"Noah",{"$f":"SUMPRODUCT(C9:J9*MOD(COLUMN(C9:J9)-COLUMN(C9)+1,2))","v":11957}]
[null,"Elijah",2504,2950,2996,3098,2619,3148,2633,2725,null,"Elijah",{"$f":"SUMPRODUCT(C10:J10*MOD(COLUMN(C10:J10)-COLUMN(C10)+1,2))","v":10752}]
[null,"Daniel",2928,2530,2715,2894,2931,3006,3153,3020,null,"Daniel",{"$f":"SUMPRODUCT(C11:J11*MOD(COLUMN(C11:J11)-COLUMN(C11)+1,2))","v":11727}]
[null,"Gakpo",3088,2674,3185,3129,2637,3015,3001,2553,null,"Gakpo",{"$f":"SUMPRODUCT(C12:J12*MOD(COLUMN(C12:J12)-COLUMN(C12)+1,2))","v":11911}]

{"sheet":"Sheet2","index":2,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,12]]}
[]
[null,"Applying SUM, COLUMN and IF Functions"]
[]
[null,"Name ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug",null,"Name ","Result "]
[null,"Pope",2974,3179,2839,2620,2819,2774,3123,2614,null,"Pope",{"$f":"SUM(IF(MOD(COLUMN($C5:$J5),2)=0,$C5:$J5,0))","v":11187}]
[null,"Nick ",2915,2625,3184,2969,2774,3129,3053,2856,null,"Nick ",{"$f":"SUM(IF(MOD(COLUMN($C6:$J6),2)=0,$C6:$J6,0))","v":11579}]
[null,"James",2791,2572,3124,2867,2993,2513,2713,2883,null,"James",{"$f":"SUM(IF(MOD(COLUMN($C7:$J7),2)=0,$C7:$J7,0))","v":10835}]
[null,"William",2828,3097,2551,2555,3079,3161,2544,3077,null,"William",{"$f":"SUM(IF(MOD(COLUMN($C8:$J8),2)=0,$C8:$J8,0))","v":11890}]
[null,"Noah",2920,2897,3193,3013,2839,2599,3005,3013,null,"Noah",{"$f":"SUM(IF(MOD(COLUMN($C9:$J9),2)=0,$C9:$J9,0))","v":11522}]
[null,"Elijah",2504,2950,2996,3098,2619,3148,2633,2725,null,"Elijah",{"$f":"SUM(IF(MOD(COLUMN($C10:$J10),2)=0,$C10:$J10,0))","v":11921}]
[null,"Daniel",2928,2530,2715,2894,2931,3006,3153,3020,null,"Daniel",{"$f":"SUM(IF(MOD(COLUMN($C11:$J11),2)=0,$C11:$J11,0))","v":11450}]
[null,"Gakpo",3088,2674,3185,3129,2637,3015,3001,2553,null,"Gakpo",{"$f":"SUM(IF(MOD(COLUMN($C12:$J12),2)=0,$C12:$J12,0))","v":11371}]

{"sheet":"Sheet3","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,12]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Name ","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug",null,"Name","Result "]
[null,"Pope",2974,3179,2839,2620,2819,2774,3123,2614,null,"Pope",{"$f":"SumIntervalColumns(C5:J5,2)","v":11187}]
[null,"Nick ",2915,2625,3184,2969,2774,3129,3053,2856,null,"Nick ",{"$f":"SumIntervalColumns(C6:J6,2)","v":11579}]
[null,"James",2791,2572,3124,2867,2993,2513,2713,2883,null,"James",10835]
[null,"William",2828,3097,2551,2555,3079,3161,2544,3077,null,"William",11890]
[null,"Noah",2920,2897,3193,3013,2839,2599,3005,3013,null,"Noah",11522]
[null,"Elijah",2504,2950,2996,3098,2619,3148,2633,2725,null,"Elijah",11921]
[null,"Daniel",2928,2530,2715,2894,2931,3006,3153,3020,null,"Daniel",11450]
[null,"Gakpo",3088,2674,3185,3129,2637,3015,3001,2553,null,"Gakpo",11371]