{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["1349"],"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":"1349","index":0,"n_rows":216,"n_cols":33,"rows_kept":216,"cut":false,"hidden":false,"merged":[]}
["Excel Magic Trick 1349: Power Query with Input Variables from Excel Sheet to Extract Records",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Product",null,"Region"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yanaki",null,"USA"]
[null,null,null,null,"Product",null,"Region",null,null,null,null,null,null,null,null,"Steps:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sunshine",null,"Asia"]
["Input Variable = Criteria = Condition = Parameter",null,null,null,"Quad",null,"USA",null,null,null,null,null,null,null,null,1,"Import and transform Data Set",null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspen",null,"Canada"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Load Report to Sheet",null,null,null,null,null,null,null,null,null,null,null,null,null,"Carlota",null,"Africa"]
["\"Parameterized Query\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Import each Parameter/Criteria Table",null,null,null,null,null,null,null,null,null,null,null,null,null,"Quad",null,"Europe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Convert each Criteria Table to a single Text Item.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"South America"]
["Date","Product","Region","Units","Category","Discount","Price",null,null,null,null,null,null,null,null,5,"Declare and Insert Variables into M Code for Report"]
["2017-03-31","Yanaki","USA",20,"Wholesale",0.35,23.950000000000003,null,null,null,null,null,null,null,null,6,"Create Macro To Refresh All and assign it to a Form button"]
["2017-01-21","Sunshine","Asia",3,"Retail",0,23.650000000000002]
["2017-01-27","Yanaki","Canada",1,"Retail",0,23.950000000000003]
["2017-02-03","Aspen","USA",33,"Wholesale",0.375,20.85]
["2017-03-12","Sunshine","Africa",204,"Wholesale",0.55000000000000004,21.450000000000003]
["2017-01-19","Yanaki","Asia",1,"Retail",0,26.85]
["2017-02-25","Aspen","Asia",3,"Retail",0,18.850000000000001]
["2017-01-07","Carlota","Europe",4,"Retail",0,26.8]
["2017-01-27","Aspen","Canada",40,"Wholesale",0.375,19.150000000000002]
["2017-03-22","Carlota","Africa",4,"Retail",0,28.5]
["2017-02-15","Yanaki","South America",3,"Retail",0,24.3]
["2017-01-10","Yanaki","Europe",2,"Retail",0,23.05]
["2017-02-12","Quad","USA",36,"Wholesale",0.375,44.800000000000004]
["2017-01-24","Carlota","Europe",4,"Retail",0,27.450000000000003]
["2017-02-23","Quad","South America",14,"Retail",0.1,43.800000000000004]
["2017-01-09","Quad","Asia",43,"Wholesale",0.375,44.5]
["2017-02-01","Aspen","Europe",2,"Retail",0,21.05]
["2017-01-30","Aspen","Canada",26,"Wholesale",0.35,21.1]
["2017-02-25","Carlota","South America",332,"Wholesale",0.55000000000000004,27.950000000000003]
["2017-01-26","Quad","Canada",66,"Wholesale",0.45,42.5]
["2017-02-17","Quad","Asia",3,"Retail",0,42.1]
["2017-01-11","Sunshine","USA",18,"Retail",0.1,23.200000000000003]
["2017-01-01","Quad","South America",29,"Wholesale",0.35,43.7]
["2017-01-09","Quad","Asia",84,"Wholesale",0.45,44.550000000000004]
["2017-02-24","Carlota","Canada",25,"Wholesale",0.35,27.05]
["2017-02-06","Aspen","Africa",37,"Wholesale",0.375,18.600000000000001]
["2017-01-16","Carlota","Canada",24,"Wholesale",0.35,27.6]
["2017-03-27","Yanaki","Asia",2,"Retail",0,24.05]
["2017-03-28","Yanaki","Europe",3,"Retail",0,26.700000000000003]
["2017-03-14","Quad","USA",19,"Retail",0.1,44.85]
["2017-02-20","Yanaki","South America",1,"Retail",0,25.75]
["2017-01-30","Yanaki","Europe",3,"Retail",0,25.1]
["2017-02-04","Quad","Asia",1,"Retail",0,45.45]
["2017-03-29","Carlota","Africa",3,"Retail",0,28.25]
["2017-03-26","Sunshine","Canada",1,"Retail",0,24.900000000000002]
["2017-02-12","Sunshine","Europe",45,"Wholesale",0.375,23.450000000000003]
["2017-03-14","Carlota","Canada",70,"Wholesale",0.45,28.35]
["2017-01-03","Quad","USA",465,"Wholesale",0.55000000000000004,44.95]
["2017-02-14","Yanaki","South America",1,"Retail",0,26.950000000000003]
["2017-01-28","Aspen","Asia",3,"Retail",0,21.85]
["2017-03-13","Yanaki","Africa",1,"Retail",0,23.75]
["2017-01-16","Aspen","Canada",3,"Retail",0,21.150000000000002]
["2017-03-27","Yanaki","Europe",3,"Retail",0,25.950000000000003]
["2017-01-22","Carlota","Asia",52,"Wholesale",0.45,27.05]
["2017-02-14","Sunshine","South America",24,"Wholesale",0.35,24.650000000000002]
["2017-02-16","Yanaki","Canada",46,"Wholesale",0.375,23.150000000000002]
["2017-03-17","Quad","South America",1,"Retail",0,43.75]
["2017-01-05","Sunshine","Asia",31,"Wholesale",0.375,22.05]
["2017-01-19","Quad","Europe",216,"Wholesale",0.55000000000000004,42.300000000000004]
["2017-03-23","Aspen","Africa",2,"Retail",0,21.400000000000002]
["2017-03-19","Aspen","Asia",2,"Retail",0,21.25]
["2017-01-02","Carlota","Asia",44,"Wholesale",0.375,28.75]
["2017-03-09","Yanaki","Europe",31,"Wholesale",0.375,26.450000000000003]
["2017-02-08","Carlota","Europe",39,"Wholesale",0.375,26.55]
["2017-01-20","Aspen","Europe",30,"Wholesale",0.375,20.700000000000003]
["2017-02-01","Aspen","Africa",71,"Wholesale",0.45,19.650000000000002]
["2017-01-06","Carlota","Africa",41,"Wholesale",0.375,27.200000000000003]
["2017-02-26","Quad","Europe",137,"Wholesale",0.5,45.45]
["2017-02-12","Aspen","USA",2,"Retail",0,18.350000000000001]
["2017-03-18","Yanaki","Asia",1,"Retail",0,25.900000000000002]
["2017-03-11","Yanaki","Asia",64,"Wholesale",0.45,23.650000000000002]
["2017-01-16","Aspen","USA",3,"Retail",0,18.650000000000002]
["2017-01-12","Sunshine","Canada",36,"Wholesale",0.375,22.150000000000002]
["2017-03-01","Aspen","Africa",38,"Wholesale",0.375,21.1]
["2017-01-26","Carlota","Asia",44,"Wholesale",0.375,27.8]
["2017-01-26","Aspen","USA",65,"Wholesale",0.45,18.75]
["2017-01-27","Carlota","South America",39,"Wholesale",0.375,27.900000000000002]
["2017-02-28","Sunshine","Africa",2,"Retail",0,24.6]
["2017-02-26","Quad","Africa",34,"Wholesale",0.375,44.45]
["2017-02-04","Quad","Africa",37,"Wholesale",0.375,45.300000000000004]
["2017-01-16","Carlota","Europe",38,"Wholesale",0.375,29.35]
["2017-02-05","Aspen","South America",32,"Wholesale",0.375,19.650000000000002]
["2017-01-09","Carlota","USA",2,"Retail",0,29.650000000000002]
["2017-03-28","Sunshine","Asia",41,"Wholesale",0.375,21]
["2017-03-16","Carlota","Europe",57,"Wholesale",0.45,29.700000000000003]
["2017-01-25","Aspen","USA",2,"Retail",0,19.400000000000002]
["2017-03-18","Sunshine","USA",2,"Retail",0,22.1]
["2017-02-18","Carlota","USA",208,"Wholesale",0.55000000000000004,26.650000000000002]
["2017-02-05","Aspen","Asia",3,"Retail",0,19.200000000000003]
["2017-01-22","Yanaki","South America",4,"Retail",0,25]
["2017-02-03","Yanaki","Asia",52,"Wholesale",0.45,23.650000000000002]
["2017-01-05","Quad","Canada",1,"Retail",0,44.75]
["2017-01-03","Sunshine","Asia",2,"Retail",0,24.55]
["2017-03-31","Aspen","USA",49,"Wholesale",0.375,21.55]
["2017-02-11","Quad","Canada",2,"Retail",0,45.6]
["2017-03-25","Carlota","South America",29,"Wholesale",0.35,29.650000000000002]
["2017-02-06","Carlota","USA",50,"Wholesale",0.45,27.05]
["2017-01-13","Quad","Europe",1,"Retail",0,43.400000000000006]
["2017-02-18","Yanaki","South America",462,"Wholesale",0.55000000000000004,24.650000000000002]
["2017-02-17","Yanaki","USA",2,"Retail",0,25.55]
["2017-02-04","Carlota","Africa",38,"Wholesale",0.375,26.650000000000002]
["2017-01-09","Yanaki","USA",46,"Wholesale",0.375,25.55]
["2017-03-08","Quad","USA",16,"Retail",0.1,43.2]
["2017-01-15","Sunshine","Canada",15,"Retail",0.1,24.200000000000003]
["2017-03-18","Sunshine","Canada",33,"Wholesale",0.375,23.35]
["2017-01-15","Sunshine","Canada",51,"Wholesale",0.45,21]
["2017-01-29","Sunshine","Africa",38,"Wholesale",0.375,21.05]
["2017-03-01","Carlota","South America",26,"Wholesale",0.35,27.450000000000003]
["2017-03-25","Quad","Europe",3,"Retail",0,45.5]
["2017-01-12","Sunshine","Canada",60,"Wholesale",0.45,24.1]
["2017-01-15","Aspen","Africa",493,"Wholesale",0.55000000000000004,19.350000000000001]
["2017-02-10","Carlota","USA",40,"Wholesale",0.375,29.400000000000002]
["2017-03-14","Sunshine","Asia",4,"Retail",0,21.25]
["2017-01-13","Carlota","USA",2,"Retail",0,26.05]
["2017-02-28","Yanaki","South America",38,"Wholesale",0.375,25.150000000000002]
["2017-01-30","Yanaki","Asia",28,"Wholesale",0.35,25.150000000000002]
["2017-02-18","Sunshine","South America",23,"Wholesale",0.35,23.35]
["2017-02-03","Sunshine","Europe",2,"Retail",0,24.400000000000002]
["2017-01-03","Carlota","Africa",175,"Wholesale",0.55000000000000004,29.950000000000003]
["2017-01-22","Yanaki","Europe",2,"Retail",0,24.85]
["2017-01-29","Sunshine","South America",40,"Wholesale",0.375,24.05]
["2017-03-10","Quad","Asia",65,"Wholesale",0.45,44.300000000000004]
["2017-03-31","Quad","South America",40,"Wholesale",0.375,45.7]
["2017-01-25","Quad","Europe",34,"Wholesale",0.375,45.7]
["2017-01-07","Quad","Canada",3,"Retail",0,42.050000000000004]
["2017-03-03","Yanaki","Europe",42,"Wholesale",0.375,25.8]
["2017-02-07","Carlota","Africa",2,"Retail",0,27.25]
["2017-02-11","Yanaki","Asia",57,"Wholesale",0.45,24.150000000000002]
["2017-02-10","Sunshine","Africa",4,"Retail",0,21.55]
["2017-02-16","Quad","Asia",39,"Wholesale",0.375,42.400000000000006]
["2017-01-14","Yanaki","USA",3,"Retail",0,25.85]
["2017-02-02","Aspen","USA",185,"Wholesale",0.55000000000000004,20.650000000000002]
["2017-02-25","Aspen","Canada",1,"Retail",0,18.55]
["2017-02-22","Yanaki","Europe",550,"Wholesale",0.55000000000000004,24.8]
["2017-01-17","Yanaki","Canada",4,"Retail",0,26.35]
["2017-02-13","Quad","South America",1,"Retail",0,43]
["2017-03-03","Carlota","Africa",3,"Retail",0,27.150000000000002]
["2017-03-30","Carlota","Asia",40,"Wholesale",0.375,29.900000000000002]
["2017-01-01","Aspen","Canada",19,"Retail",0.1,20.650000000000002]
["2017-01-20","Carlota","Canada",478,"Wholesale",0.55000000000000004,29.700000000000003]
["2017-03-09","Aspen","South America",3,"Retail",0,20.6]
["2017-03-07","Quad","Canada",1,"Retail",0,42.75]
["2017-03-26","Carlota","South America",57,"Wholesale",0.45,29.25]
["2017-01-29","Sunshine","Europe",25,"Wholesale",0.35,23.400000000000002]
["2017-01-31","Aspen","USA",58,"Wholesale",0.45,19.450000000000003]
["2017-01-23","Sunshine","Canada",38,"Wholesale",0.375,23.35]
["2017-01-11","Aspen","Africa",24,"Wholesale",0.35,21.55]
["2017-03-11","Yanaki","South America",2,"Retail",0,23.8]
["2017-02-14","Aspen","Europe",420,"Wholesale",0.55000000000000004,19]
["2017-03-18","Aspen","South America",3,"Retail",0,18]
["2017-02-01","Aspen","Europe",40,"Wholesale",0.375,20.75]
["2017-02-16","Aspen","South America",4,"Retail",0,18.3]
["2017-01-31","Sunshine","Europe",2,"Retail",0,22.200000000000003]
["2017-03-19","Carlota","Asia",439,"Wholesale",0.55000000000000004,26.25]
["2017-03-09","Yanaki","Africa",582,"Wholesale",0.55000000000000004,24.35]
["2017-01-24","Carlota","Europe",3,"Retail",0,27.150000000000002]
["2017-01-21","Carlota","Asia",43,"Wholesale",0.375,28.35]
["2017-03-02","Sunshine","Africa",1,"Retail",0,22.200000000000003]
["2017-02-08","Carlota","Europe",31,"Wholesale",0.375,26.650000000000002]
["2017-03-02","Sunshine","Europe",38,"Wholesale",0.375,22.25]
["2017-01-06","Carlota","USA",39,"Wholesale",0.375,27.5]
["2017-01-26","Aspen","Asia",48,"Wholesale",0.375,20.5]
["2017-01-16","Quad","Asia",56,"Wholesale",0.45,43.550000000000004]
["2017-02-25","Quad","Asia",20,"Wholesale",0.35,42.050000000000004]
["2017-01-13","Yanaki","Europe",14,"Retail",0.1,23.950000000000003]
["2017-03-09","Carlota","Europe",36,"Wholesale",0.375,27.5]
["2017-03-02","Carlota","Africa",15,"Retail",0.1,26.950000000000003]
["2017-02-16","Carlota","Asia",39,"Wholesale",0.375,29.85]
["2017-01-22","Quad","South America",4,"Retail",0,43.800000000000004]
["2017-02-04","Yanaki","USA",3,"Retail",0,26.3]
["2017-03-05","Quad","Asia",37,"Wholesale",0.375,44.1]
["2017-02-10","Aspen","Asia",31,"Wholesale",0.375,20.55]
["2017-01-01","Quad","Asia",54,"Wholesale",0.45,45.5]
["2017-03-27","Yanaki","Canada",22,"Wholesale",0.35,23.400000000000002]
["2017-03-22","Quad","Europe",36,"Wholesale",0.375,43.900000000000006]
["2017-02-13","Sunshine","Africa",61,"Wholesale",0.45,21.200000000000003]
["2017-02-12","Carlota","Canada",68,"Wholesale",0.45,29.6]
["2017-01-22","Quad","Canada",19,"Retail",0.1,43.75]
["2017-01-10","Carlota","Canada",55,"Wholesale",0.45,27.650000000000002]
["2017-03-10","Quad","Canada",24,"Wholesale",0.35,45.1]
["2017-02-19","Yanaki","Europe",4,"Retail",0,25.150000000000002]
["2017-01-28","Sunshine","South America",1,"Retail",0,24.700000000000003]
["2017-02-09","Carlota","Asia",34,"Wholesale",0.375,29.450000000000003]
["2017-01-19","Sunshine","Canada",41,"Wholesale",0.375,23.6]
["2017-02-13","Aspen","Africa",28,"Wholesale",0.35,20.900000000000002]
["2017-03-04","Quad","South America",246,"Wholesale",0.55000000000000004,45.550000000000004]
["2017-03-24","Carlota","Africa",2,"Retail",0,29.05]
["2017-03-01","Carlota","Asia",5,"Retail",0.05,26.55]
["2017-01-11","Yanaki","Africa",47,"Wholesale",0.375,23.25]
["2017-02-24","Sunshine","USA",2,"Retail",0,24.200000000000003]
["2017-01-09","Quad","USA",3,"Retail",0,43.5]
["2017-01-12","Sunshine","USA",21,"Wholesale",0.35,21.05]
["2017-03-31","Quad","South America",252,"Wholesale",0.55000000000000004,42.800000000000004]
["2017-02-11","Aspen","Asia",222,"Wholesale",0.55000000000000004,21.950000000000003]
["2017-03-21","Aspen","Canada",1,"Retail",0,20.150000000000002]
["2017-02-12","Carlota","Asia",3,"Retail",0,26.450000000000003]
["2017-02-02","Yanaki","Asia",325,"Wholesale",0.55000000000000004,24.55]
["2017-02-12","Carlota","Canada",68,"Wholesale",0.45,29.6]
["2017-01-22","Quad","Canada",19,"Retail",0.1,43.75]
["2017-01-10","Carlota","Canada",55,"Wholesale",0.45,27.650000000000002]
["2017-03-10","Quad","Canada",24,"Wholesale",0.35,45.1]
["2017-02-19","Yanaki","Europe",4,"Retail",0,25.150000000000002]
["2017-01-28","Sunshine","South America",1,"Retail",0,24.700000000000003]
["2017-02-09","Carlota","Asia",34,"Wholesale",0.375,29.450000000000003]
["2017-01-19","Sunshine","Canada",41,"Wholesale",0.375,23.6]
["2017-02-13","Aspen","Africa",28,"Wholesale",0.35,20.900000000000002]
["2017-03-04","Quad","South America",246,"Wholesale",0.55000000000000004,45.550000000000004]
["2017-03-24","Carlota","Africa",2,"Retail",0,29.05]
["2017-03-01","Carlota","Asia",5,"Retail",0.05,26.55]
["2017-01-11","Yanaki","Africa",47,"Wholesale",0.375,23.25]
["2017-02-24","Sunshine","USA",2,"Retail",0,24.200000000000003]
["2017-01-09","Quad","USA",3,"Retail",0,43.5]
["2017-01-12","Sunshine","USA",21,"Wholesale",0.35,21.05]
["2017-03-31","Quad","South America",252,"Wholesale",0.55000000000000004,42.800000000000004]
["2017-02-11","Aspen","Asia",222,"Wholesale",0.55000000000000004,21.950000000000003]
["2017-03-21","Aspen","Canada",1,"Retail",0,20.150000000000002]
["2017-02-12","Carlota","Asia",3,"Retail",0,26.450000000000003]
["2017-02-02","Yanaki","Asia",325,"Wholesale",0.55000000000000004,24.55]