{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Info","Trial","Instructions","Data","Daily","ChartDaily","Monthly","ChartMonthly"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"ChartDaily","index":5,"reason":"not_a_worksheet"},{"sheet":"ChartMonthly","index":7,"reason":"not_a_worksheet"}],"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":"Info","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Trial","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Instructions","index":2,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Excel Skills | Sales Analysis Template"]
["Instructions"]
["www.excel-skills.com"]
[]
["This template enables users to produce daily and monthly sales analysis charts by simply entering or copying daily sales data. The daily sales chart includes a 60 day period and the monthly sales chart includes a 12 month period. The date range that is included in each chart can be adjusted by simply changing a single input cell. The default date cell range can also be amended by completing the steps that are detailed under the Customization section of these instructions."]
[]
["The following sheets are included in this template:"]
["Data - enter the appropriate dates and sales amounts on this sheet."]
["Daily - this is the source data sheet of the daily sales chart. It includes a 60 day period by default and the date range that is included can be amended by simply entering the appropriate date in the Start Date input cell (cell B3). This is the only user input that is required on this sheet."]
["ChartDaily - this sheet contains the daily sales analysis chart."]
["Monthly - this is the source data sheet of the monthly sales chart. It includes a 12 month period by default and the date range that is included can be amended by simply entering the appropriate date in the Start Date input cell (cell B3). This is the only user input that is required on this sheet."]
["ChartMonthly - this sheet contains the monthly sales analysis chart."]
[]
["Entering Sales Data"]
[]
["The charts that are included in this template are based on the data that is entered on the Data sheet. This sheet only includes two columns - enter the appropriate date in column A and the appropriate sales amount in column B. The daily and monthly charts are automatically updated."]
[]
["If you only want to use the template to measure monthly sales data, you can simply enter the appropriate month end dates and sales amounts and the monthly sales chart will be updated automatically. The Daily and ChartDaily sheets can then be deleted."]
[]
["Note: The Data sheet can be customized if you want to copy daily sales data from another source. You can insert additional columns in order to align the layout of the data on this sheet to the data structure of the source data file. You can also move the Date and Amount columns if required but these columns should not be deleted."]
[]
["Note: The default columns have been included in an Excel table. You can add additional rows to the table by entering or copying data into the empty rows below the table in order to automatically entend the table (as long as you don't leave a row open directly below the table)."]
[]
["Customization"]
[]
["The daily sales chart includes a default period of 60 days and the monthly sales chart includes a default period of 12 months. If you want to extend or reduce the default date range, you can simply drag the arrow in the bottom right corner of the table on the Daily sheet (for the daily sales chart) or the table on the Monthly sheet (for the monthly sales chart) to automatically include the appropriate number of additional dates in the chart. The default periods can also be reduced by simply deleting the appropriate number of rows from the bottom of the appropriate table."]
[]
["Note: The cells in the Date and Sales columns on both the Daily and Monthly sheets contain formulas that are automatically copied when you extend the tables. The appropriate chart is also updated automatically which means that you don't even need to edit the source data cell ranges of the charts when making changes to the tables."]
[]
["Help & Customization"]
[]
["If you experience any difficulty while using this template and you are not able to find the appropriate guidance in these instructions, please e-mail us at support@excel-skills.com for assistance. This template has been designed with flexibility in mind to ensure that it can be used in most business environments. If however you need an Excel based template that is customized specifically for your business requirements, please e-mail our Support function and provide a brief explanation of your requirements."]
[]
["© Copyright"]
[]
["This template remains the intellectual property of www.excel-skills.com and is protected by international copyright laws. Any publication or distribution of this template outside the scope of the permitted use of the template is expressly prohibited. In terms of the permitted use of this template, only the distribution of the template to persons within the same organisation as the registered user or persons outside the organisation who can reasonably be expected to require access to the template as a direct result of the use of the template by the registered user is allowed. Subsequent distribution of the template by parties outside of the organisation is however expressly prohibited and represents an infringement of international copyright laws."]

{"sheet":"Data","index":3,"n_rows":368,"n_cols":2,"rows_kept":368,"cut":false,"hidden":true,"merged":[]}
["Daily Sales Data"]
[]
["Date","Amount"]
["2020-06-01",8500]
["2020-06-02",10200]
["2020-06-03",7650]
["2020-06-04",9350]
["2020-06-05",6800]
["2020-06-06",5950]
["2020-06-07",7650]
["2020-06-08",8500]
["2020-06-09",9520]
["2020-06-10",9265]
["2020-06-11",8075]
["2020-06-12",8330]
["2020-06-13",8670]
["2020-06-14",9180]
["2020-06-15",6885]
["2020-06-16",7820]
["2020-06-17",9359]
["2020-06-18",9240]
["2020-06-19",8502]
["2020-06-20",8383]
["2020-06-21",8160]
["2020-06-22",7820]
["2020-06-23",8755]
["2020-06-24",8925]
["2020-06-25",8755]
["2020-06-26",9435]
["2020-06-27",8160]
["2020-06-28",7820]
["2020-06-29",7225]
["2020-06-30",7905]
["2020-07-01",8415]
["2020-07-02",8840]
["2020-07-03",7820]
["2020-07-04",6885]
["2020-07-05",8925]
["2020-07-06",9435]
["2020-07-07",10455]
["2020-07-08",12325]
["2020-07-09",11739]
["2020-07-10",10208]
["2020-07-11",11220]
["2020-07-12",8262]
["2020-07-13",8467]
["2020-07-14",8755]
["2020-07-15",10455]
["2020-07-16",9180]
["2020-07-17",9860]
["2020-07-18",10277]
["2020-07-19",8772]
["2020-07-20",8483]
["2020-07-21",8747]
["2020-07-22",9605]
["2020-07-23",9520]
["2020-07-24",10117]
["2020-07-25",10226]
["2020-07-26",8339]
["2020-07-27",11220]
["2020-07-28",12580]
["2020-07-29",9095]
["2020-07-30",9520]
["2020-07-31",11033]
["2020-08-01",7290]
["2020-08-02",8280]
["2020-08-03",9909]
["2020-08-04",9783]
["2020-08-05",9002]
["2020-08-06",8876]
["2020-08-07",8640]
["2020-08-08",8280]
["2020-08-09",9270]
["2020-08-10",9450]
["2020-08-11",9270]
["2020-08-12",9990]
["2020-08-13",8640]
["2020-08-14",8280]
["2020-08-15",7650]
["2020-08-16",8370]
["2020-08-17",8910]
["2020-08-18",9360]
["2020-08-19",8280]
["2020-08-20",7290]
["2020-08-21",9450]
["2020-08-22",9990]
["2020-08-23",11070]
["2020-08-24",13050]
["2020-08-25",12429]
["2020-08-26",10808]
["2020-08-27",11880]
["2020-08-28",8748]
["2020-08-29",8965]
["2020-08-30",9270]
["2020-08-31",13050]
["2020-09-01",12429]
["2020-09-02",10808]
["2020-09-03",11880]
["2020-09-04",8748]
["2020-09-05",8965]
["2020-09-06",9270]
["2020-09-07",11070]
["2020-09-08",9720]
["2020-09-09",10440]
["2020-09-10",10881]
["2020-09-11",9288]
["2020-09-12",8982]
["2020-09-13",9261]
["2020-09-14",10170]
["2020-09-15",10080]
["2020-09-16",10712]
["2020-09-17",10827]
["2020-09-18",8829]
["2020-09-19",11880]
["2020-09-20",13320]
["2020-09-21",9630]
["2020-09-22",10080]
["2020-09-23",11682]
["2020-09-24",7290]
["2020-09-25",8280]
["2020-09-26",9909]
["2020-09-27",9783]
["2020-09-28",9002]
["2020-09-29",8876]
["2020-09-30",8640]
["2020-10-01",8280]
["2020-10-02",9270]
["2020-10-03",9450]
["2020-10-04",9270]
["2020-10-05",10881]
["2020-10-06",9288]
["2020-10-07",8982]
["2020-10-08",9261]
["2020-10-09",10170]
["2020-10-10",10080]
["2020-10-11",10712]
["2020-10-12",10827]
["2020-10-13",8829]
["2020-10-14",11880]
["2020-10-15",13320]
["2020-10-16",9630]
["2020-10-17",10080]
["2020-10-18",11682]
["2020-10-19",7290]
["2020-10-20",8280]
["2020-10-21",9909]
["2020-10-22",9783]
["2020-10-23",9002]
["2020-10-24",8876]
["2020-10-25",8640]
["2020-10-26",8280]
["2020-10-27",9270]
["2020-10-28",9450]
["2020-10-29",9270]
["2020-10-30",9990]
["2020-10-31",8640]
["2020-11-01",9200]
["2020-11-02",8500]
["2020-11-03",9300]
["2020-11-04",9900]
["2020-11-05",10400]
["2020-11-06",9200]
["2020-11-07",8100]
["2020-11-08",10500]
["2020-11-09",11100]
["2020-11-10",12300]
["2020-11-11",14500]
["2020-11-12",13810]
["2020-11-13",12009]
["2020-11-14",13200]
["2020-11-15",9720]
["2020-11-16",9961]
["2020-11-17",10300]
["2020-11-18",14500]
["2020-11-19",13810]
["2020-11-20",12009]
["2020-11-21",14800]
["2020-11-22",10700]
["2020-11-23",11200]
["2020-11-24",12980]
["2020-11-25",8100]
["2020-11-26",9200]
["2020-11-27",11010]
["2020-11-28",10870]
["2020-11-29",10002]
["2020-11-30",9862]
["2020-12-01",9600]
["2020-12-02",9200]
["2020-12-03",10300]
["2020-12-04",10500]
["2020-12-05",10300]
["2020-12-06",11100]
["2020-12-07",9600]
["2020-12-08",9200]
["2020-12-09",8500]
["2020-12-10",9300]
["2020-12-11",9900]
["2020-12-12",10400]
["2020-12-13",9200]
["2020-12-14",8100]
["2020-12-15",10500]
["2020-12-16",11100]
["2020-12-17",12300]
["2020-12-18",14500]
["2020-12-19",13810]
["2020-12-20",12009]
["2020-12-21",10500]
["2020-12-22",10300]
["2020-12-23",11100]
["2020-12-24",9600]
["2020-12-25",9200]
["2020-12-26",8500]
["2020-12-27",9300]
["2020-12-28",9900]
["2020-12-29",10400]
["2020-12-30",9200]
["2020-12-31",8100]
["2021-01-01",10500]
["2021-01-02",11100]
["2021-01-03",12300]
["2021-01-04",14500]
["2021-01-05",13810]
["2021-01-06",12009]
["2021-01-07",13200]
["2021-01-08",9720]
["2021-01-09",9961]
["2021-01-10",10300]
["2021-01-11",14500]
["2021-01-12",13810]
["2021-01-13",12009]
["2021-01-14",13200]
["2021-01-15",9720]
["2021-01-16",9961]
["2021-01-17",10300]
["2021-01-18",12300]
["2021-01-19",10800]
["2021-01-20",11600]
["2021-01-21",12090]
["2021-01-22",10320]
["2021-01-23",9980]
["2021-01-24",10290]
["2021-01-25",11300]
["2021-01-26",11200]
["2021-01-27",11902]
["2021-01-28",12030]
["2021-01-29",9810]
["2021-01-30",13200]
["2021-01-31",14800]
["2021-02-01",10700]
["2021-02-02",11200]
["2021-02-03",12980]
["2021-02-04",8100]
["2021-02-05",9200]
["2021-02-06",11010]
["2021-02-07",10870]
["2021-02-08",10002]
["2021-02-09",9862]
["2021-02-10",9600]
["2021-02-11",9200]
["2021-02-12",10300]
["2021-02-13",10500]
["2021-02-14",10300]
["2021-02-15",12090]
["2021-02-16",10320]
["2021-02-17",9980]
["2021-02-18",10290]
["2021-02-19",11300]
["2021-02-20",11200]
["2021-02-21",11902]
["2021-02-22",12030]
["2021-02-23",9810]
["2021-02-24",13200]
["2021-02-25",14800]
["2021-02-26",10700]
["2021-02-27",11200]
["2021-02-28",12980]
["2021-03-01",8100]
["2021-03-02",9200]
["2021-03-03",11010]
["2021-03-04",10870]
["2021-03-05",10002]
["2021-03-06",9862]
["2021-03-07",9600]
["2021-03-08",9200]
["2021-03-09",10300]
["2021-03-10",10500]
["2021-03-11",10300]
["2021-03-12",11100]
["2021-03-13",9600]
["2021-03-14",9200]
["2021-03-15",8500]
["2021-03-16",9300]
["2021-03-17",9900]
["2021-03-18",10400]
["2021-03-19",11100]
["2021-03-20",12300]
["2021-03-21",14500]
["2021-03-22",13810]
["2021-03-23",12009]
["2021-03-24",13200]
["2021-03-25",9720]
["2021-03-26",9961]
["2021-03-27",10300]
["2021-03-28",14500]
["2021-03-29",13810]
["2021-03-30",12009]
["2021-03-31",14800]
["2021-04-01",10700]
["2021-04-02",11200]
["2021-04-03",12980]
["2021-04-04",8100]
["2021-04-05",9200]
["2021-04-06",11010]
["2021-04-07",10870]
["2021-04-08",10002]
["2021-04-09",9862]
["2021-04-10",9600]
["2021-04-11",9200]
["2021-04-12",10300]
["2021-04-13",10500]
["2021-04-14",10300]
["2021-04-15",11100]
["2021-04-16",9600]
["2021-04-17",9200]
["2021-04-18",8500]
["2021-04-19",9300]
["2021-04-20",9900]
["2021-04-21",10400]
["2021-04-22",9200]
["2021-04-23",8100]
["2021-04-24",10500]
["2021-04-25",11100]
["2021-04-26",12300]
["2021-04-27",14500]
["2021-04-28",13810]
["2021-04-29",12009]
["2021-04-30",10500]
["2021-05-01",10300]
["2021-05-02",11100]
["2021-05-03",9600]
["2021-05-04",9200]
["2021-05-05",8500]
["2021-05-06",9300]
["2021-05-07",9900]
["2021-05-08",10400]
["2021-05-09",9200]
["2021-05-10",8100]
["2021-05-11",10500]
["2021-05-12",11100]
["2021-05-13",12300]
["2021-05-14",14500]
["2021-05-15",13810]
["2021-05-16",12009]
["2021-05-17",14500]
["2021-05-18",13810]
["2021-05-19",12009]
["2021-05-20",13200]
["2021-05-21",9720]
["2021-05-22",9961]
["2021-05-23",10300]
["2021-05-24",14500]
["2021-05-25",13810]
["2021-05-26",12009]
["2021-05-27",14800]
["2021-05-28",10700]
["2021-05-29",11200]
["2021-05-30",12980]
["2021-05-31",8100]

{"sheet":"Daily","index":4,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
["Daily Sales"]
["© www.excel-skills.com"]
["Start Date","2021-04-02"]
[]
["Date","Sales"]
[{"$f":"B3","v":"2021-04-02"},{"$f":"SUMIF(DailyData,A6,DailyAmount)","v":11200}]
[{"$f":"DATE(YEAR(A6),MONTH(A6),DAY(A6)+1)","v":"2021-04-03"},12980]
["2021-04-04",8100]
["2021-04-05",9200]
["2021-04-06",11010]
["2021-04-07",10870]
["2021-04-08",10002]
["2021-04-09",9862]
["2021-04-10",9600]
["2021-04-11",9200]
["2021-04-12",10300]
["2021-04-13",10500]
["2021-04-14",10300]
["2021-04-15",11100]
["2021-04-16",9600]
["2021-04-17",9200]
["2021-04-18",8500]
["2021-04-19",9300]
["2021-04-20",9900]
["2021-04-21",10400]
["2021-04-22",9200]
["2021-04-23",8100]
["2021-04-24",10500]
["2021-04-25",11100]
["2021-04-26",12300]
["2021-04-27",14500]
["2021-04-28",13810]
["2021-04-29",12009]
["2021-04-30",10500]
["2021-05-01",10300]
["2021-05-02",11100]
["2021-05-03",9600]
["2021-05-04",{"$f":"SUMIF(DailyData,A38,DailyAmount)","v":9200}]
[{"$f":"DATE(YEAR(A38),MONTH(A38),DAY(A38)+1)","v":"2021-05-05"},8500]
["2021-05-06",9300]
["2021-05-07",9900]
["2021-05-08",10400]
["2021-05-09",9200]
["2021-05-10",8100]
["2021-05-11",10500]
["2021-05-12",11100]
["2021-05-13",12300]
["2021-05-14",14500]
["2021-05-15",13810]
["2021-05-16",12009]
["2021-05-17",14500]
["2021-05-18",13810]
["2021-05-19",12009]
["2021-05-20",13200]
["2021-05-21",9720]
["2021-05-22",9961]
["2021-05-23",10300]
["2021-05-24",14500]
["2021-05-25",13810]
["2021-05-26",12009]
["2021-05-27",14800]
["2021-05-28",10700]
["2021-05-29",11200]
["2021-05-30",12980]
["2021-05-31",8100]

{"sheet":"Monthly","index":6,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Monthly Sales"]
["© www.excel-skills.com"]
["Start Date","2020-06-01"]
[]
["Date","Sales"]
[{"$f":"DATE(YEAR(B3),MONTH(B3)+1,0)","v":"2020-06-30"},{"$f":"SUMPRODUCT((DailyDate>=DATE(YEAR($A6),MONTH($A6),1))*(DailyDate<=$A6)*(DailyAmount))","v":250789}]
[{"$f":"DATE(YEAR(A6),MONTH(A6)+2,0)","v":"2020-07-31"},298780]
[{"$f":"DATE(YEAR(A7),MONTH(A7)+2,0)","v":"2020-08-31"},293530]
["2020-09-30",300732]
["2020-10-31",298572]
["2020-11-30",331043]
["2020-12-31",315519]
["2021-01-31",362522]
["2021-02-28",305626]
["2021-03-31",338963]
["2021-04-30",313843]
["2021-05-31",351418]