{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Sheet2","Features Of Template"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"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":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Date Range Reports"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Sheet2","index":1,"n_rows":155,"n_cols":11,"rows_kept":155,"cut":false,"hidden":false,"merged":[[11,7,20,11]]}
[null,null,null,null,null,null,"Start Date","2000-01-01",null,"End Date","2000-01-06"]
[]
[]
[]
["Date","Item","Location","Price","Quantity","Company"]
["2000-01-01","Apple","Ongole",25,254,"A"]
["2000-01-02","Banana","Hyderabad",25,365,"B"]
["2000-01-03","Orange","Chennai",45,254,"C"]
["2000-01-04","Grapes","Calcutta",96,152,"D"]
["2000-01-05","Sriguranjani","Delhi",85,847,"E"]
["2000-01-06","Tricks","Ongole",26,851,"A"]
["2000-01-07",12345,"Hyderabad",35,245,"B",null,"In this example retriving values \nfrom the date of 1/1/2000 to 1/6/2000"]
["2000-01-08","Eraser","Chennai",68,685,"C"]
["2000-01-09","Slate","Calcutta",95,984,"D"]
["2000-01-10","Apple","Delhi",25,254,"E"]
["2000-01-11","Banana","Ongole",25,365,"A"]
["2000-01-12","Orange","Hyderabad",45,254,"B"]
["2000-01-13","Grapes","Chennai",96,152,"C"]
["2000-01-14","Sriguranjani","Calcutta",85,847,"D"]
["2000-01-15","Tricks","Delhi",26,851,"E"]
["2000-01-16",12345,"Ongole",35,245,"A"]
["2000-01-17","Eraser","Hyderabad",68,685,"B"]
["2000-01-18","Slate","Chennai",95,984,"C"]
["2000-01-19","Apple","Calcutta",25,254,"D"]
["2000-01-20","Banana","Delhi",25,365,"E"]
["2000-01-21","Orange","Ongole",45,254,"A"]
["2000-01-22","Grapes","Hyderabad",96,152,"B"]
["2000-01-23","Sriguranjani","Chennai",85,847,"C"]
["2000-01-24","Tricks","Calcutta",26,851,"D"]
["2000-01-25",12345,"Delhi",35,245,"E"]
["2000-01-26","Eraser","Ongole",68,685,"A"]
["2000-01-27","Slate","Hyderabad",95,984,"B"]
["2000-01-28","Apple","Chennai",25,254,"C"]
["2000-01-29","Banana","Calcutta",25,365,"D"]
["2000-01-30","Orange","Delhi",45,254,"E"]
["2000-01-31","Grapes","Ongole",96,152,"A"]
["2000-02-01","Sriguranjani","Hyderabad",85,847,"B"]
["2000-02-02","Tricks","Chennai",26,851,"C"]
["2000-02-03",12345,"Calcutta",35,245,"D"]
["2000-02-04","Eraser","Delhi",68,685,"E"]
["2000-02-05","Slate","Ongole",95,984,"A"]
["2000-02-06","Apple","Hyderabad",25,254,"B"]
["2000-02-07","Banana","Chennai",25,365,"C"]
["2000-02-08","Orange","Calcutta",45,254,"D"]
["2000-02-09","Grapes","Delhi",96,152,"E"]
["2000-02-10","Sriguranjani","Ongole",85,847,"A"]
["2000-02-11","Tricks","Hyderabad",26,851,"B"]
["2000-02-12",12345,"Chennai",35,245,"C"]
["2000-02-13","Eraser","Calcutta",68,685,"D"]
["2000-02-14","Slate","Delhi",95,984,"E"]
["2000-02-15","Apple","Ongole",25,254,"A"]
["2000-02-16","Banana","Hyderabad",25,365,"B"]
["2000-02-17","Orange","Chennai",45,254,"C"]
["2000-02-18","Grapes","Calcutta",96,152,"D"]
["2000-02-19","Sriguranjani","Delhi",85,847,"E"]
["2000-02-20","Tricks","Ongole",26,851,"A"]
["2000-02-21",12345,"Hyderabad",35,245,"B"]
["2000-02-22","Eraser","Chennai",68,685,"C"]
["2000-02-23","Slate","Calcutta",95,984,"D"]
["2000-02-24","Apple","Delhi",25,254,"E"]
["2000-02-25","Banana","Ongole",25,365,"A"]
["2000-02-26","Orange","Hyderabad",45,254,"B"]
["2000-02-27","Grapes","Chennai",96,152,"C"]
["2000-02-28","Sriguranjani","Calcutta",85,847,"D"]
["2000-02-29","Tricks","Delhi",26,851,"E"]
["2000-03-01",12345,"Ongole",35,245,"A"]
["2000-03-02","Eraser","Hyderabad",68,685,"B"]
["2000-03-03","Slate","Chennai",95,984,"C"]
["2000-03-04","Apple","Calcutta",25,254,"D"]
["2000-03-05","Banana","Delhi",25,365,"E"]
["2000-03-06","Orange","Ongole",45,254,"A"]
["2000-03-07","Grapes","Hyderabad",96,152,"B"]
["2000-03-08","Sriguranjani","Chennai",85,847,"C"]
["2000-03-09","Tricks","Calcutta",26,851,"D"]
["2000-03-10",12345,"Delhi",35,245,"E"]
["2000-03-11","Eraser","Ongole",68,685,"A"]
["2000-03-12","Slate","Hyderabad",95,984,"B"]
["2000-03-13","Apple","Chennai",25,254,"C"]
["2000-03-14","Banana","Calcutta",25,365,"D"]
["2000-03-15","Orange","Delhi",45,254,"E"]
["2000-03-16","Grapes","Ongole",96,152,"A"]
["2000-03-17","Sriguranjani","Hyderabad",85,847,"B"]
["2000-03-18","Tricks","Chennai",26,851,"C"]
["2000-03-19",12345,"Calcutta",35,245,"D"]
["2000-03-20","Eraser","Delhi",68,685,"E"]
["2000-03-21","Slate","Ongole",95,984,"A"]
["2000-03-22","Apple","Hyderabad",25,254,"B"]
["2000-03-23","Banana","Chennai",25,365,"C"]
["2000-03-24","Orange","Calcutta",45,254,"D"]
["2000-03-25","Grapes","Delhi",96,152,"E"]
["2000-03-26","Sriguranjani","Ongole",85,847,"A"]
["2000-03-27","Tricks","Hyderabad",26,851,"B"]
["2000-03-28",12345,"Chennai",35,245,"C"]
["2000-03-29","Eraser","Calcutta",68,685,"D"]
["2000-03-30","Slate","Delhi",95,984,"E"]
["2000-03-31","Apple","Ongole",25,254,"A"]
["2000-04-01","Banana","Hyderabad",25,365,"B"]
["2000-04-02","Orange","Chennai",45,254,"C"]
["2000-04-03","Grapes","Calcutta",96,152,"D"]
["2000-04-04","Sriguranjani","Delhi",85,847,"E"]
["2000-04-05","Tricks","Ongole",26,851,"A"]
["2000-04-06",12345,"Hyderabad",35,245,"B"]
["2000-04-07","Eraser","Chennai",68,685,"C"]
["2000-04-08","Slate","Calcutta",95,984,"D"]
["2000-04-09","Apple","Delhi",25,254,"E"]
["2000-04-10","Banana","Ongole",25,365,"A"]
["2000-04-11","Orange","Hyderabad",45,254,"B"]
["2000-04-12","Grapes","Chennai",96,152,"C"]
["2000-04-13","Sriguranjani","Calcutta",85,847,"D"]
["2000-04-14","Tricks","Delhi",26,851,"E"]
["2000-04-15",12345,"Ongole",35,245,"A"]
["2000-04-16","Eraser","Hyderabad",68,685,"B"]
["2000-04-17","Slate","Chennai",95,984,"C"]
["2000-04-18","Apple","Calcutta",25,254,"D"]
["2000-04-19","Banana","Delhi",25,365,"E"]
["2000-04-20","Orange","Ongole",45,254,"A"]
["2000-04-21","Grapes","Hyderabad",96,152,"B"]
["2000-04-22","Sriguranjani","Chennai",85,847,"C"]
["2000-04-23","Tricks","Calcutta",26,851,"D"]
["2000-04-24",12345,"Delhi",35,245,"E"]
["2000-04-25","Eraser","Ongole",68,685,"A"]
["2000-04-26","Slate","Hyderabad",95,984,"B"]
["2000-04-27","Apple","Chennai",25,254,"C"]
["2000-04-28","Banana","Calcutta",25,365,"D"]
["2000-04-29","Orange","Delhi",45,254,"E"]
["2000-04-30","Grapes","Ongole",96,152,"A"]
["2000-05-01","Sriguranjani","Hyderabad",85,847,"B"]
["2000-05-02","Tricks","Chennai",26,851,"C"]
["2000-05-03",12345,"Calcutta",35,245,"D"]
["2000-05-04","Eraser","Delhi",68,685,"E"]
["2000-05-05","Slate","Ongole",95,984,"A"]
["2000-05-06","Apple","Hyderabad",25,254,"B"]
["2000-05-07","Banana","Chennai",25,365,"C"]
["2000-05-08","Orange","Calcutta",45,254,"D"]
["2000-05-09","Grapes","Delhi",96,152,"E"]
["2000-05-10","Sriguranjani","Ongole",85,847,"A"]
["2000-05-11","Tricks","Hyderabad",26,851,"B"]
["2000-05-12",12345,"Chennai",35,245,"C"]
["2000-05-13","Eraser","Calcutta",68,685,"D"]
["2000-05-14","Slate","Delhi",95,984,"E"]
["2000-05-15","Apple","Ongole",25,254,"A"]
["2000-05-16","Banana","Hyderabad",25,365,"B"]
["2000-05-17","Orange","Chennai",45,254,"C"]
["2000-05-18","Grapes","Calcutta",96,152,"D"]
["2000-05-19","Sriguranjani","Delhi",85,847,"E"]
["2000-05-20","Tricks","Ongole",26,851,"A"]
["2000-05-21",12345,"Hyderabad",35,245,"B"]
["2000-05-22","Eraser","Chennai",68,685,"C"]
["2000-05-23","Slate","Calcutta",95,984,"D"]
["2000-05-24","Grapes","Calcutta",96,152,"D"]
["2000-05-25","Sriguranjani","Delhi",85,847,"E"]
["2000-05-26","Tricks","Ongole",26,851,"A"]
["2000-05-27",12345,"Hyderabad",35,245,"B"]
["2000-05-28","Eraser","Chennai",68,685,"C"]
["2000-05-29","Slate","Calcutta",95,984,"D"]

{"sheet":"Features Of Template","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,3,3,14],[6,10,9,16]]}
[]
[null,null,null,"Template Features"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Hope Useful to Everyone"]
[]
[null,null,"1)","Update START DATE in H1 Cell"]
[null,null,"2)","Update END DATE in K1 Cell"]
[null,null,"3)","Click on GENERATE REPORT Command Button to retrieve results"]
[null,null,"4)","Click on RESULT IN NEW SHEET, if Filtered Data wants to display by creating new worksheet, in this workbook"]
[null,null,"5)","Click on RESULT IN NEW WORKBOOK, if Filtered Data wants to display by creating new workbook"]
[null,null,"6)","Update your data from A5 cell(with Headers)"]
[null,null,"7)","Mentioned Datavalidation  in  K1 & H1 cells through offset formula, restricted upto 10000 rows"]