{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Info","Merged","Unmerged"],"not_rendered":{"charts":0,"images":1,"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":"Info","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Find and Unmerge Merged Cells"]
[]
[]
[null,"Press ALT + F11 to open the VBA editor and see the sample code"]
[]
[]
[]
[]
["More Resources"]
[]
[null,"Courses",null,null,null,null,null,null,null,null,null,"Webinars"]
[null,"Advanced Excel","https://www.myonlinetraininghub.com/excel-expert-upgrade",null,null,null,null,null,null,null,null,"Excel Dashboards & Power BI","http://www.myonlinetraininghub.com/excel-webinars"]
[null,"PivotTables","https://www.myonlinetraininghub.com/excel-pivottable-course"]
[null,"Power Query","https://www.myonlinetraininghub.com/excel-power-query-course"]
[null,"Power Pivot","https://www.myonlinetraininghub.com/power-pivot-course",null,null,null,null,null,null,null,null,"Support"]
[null,"Excel Dashboards","http://www.myonlinetraininghub.com/excel-dashboard-course",null,null,null,null,null,null,null,null,"Excel Forum","https://www.myonlinetraininghub.com/excel-forum"]
[null,"Power BI","http://www.myonlinetraininghub.com/power-bi-course"]
[null,"Excel for Decision Making Under Uncertainty","https://www.myonlinetraininghub.com/excel-for-decision-making-course"]
[null,"Excel for Finance Professionals","https://www.myonlinetraininghub.com/excel-for-finance-course",null,null,null,null,null,null,null,null,"Tutorials"]
[null,"Excel Analysis ToolPak","https://www.myonlinetraininghub.com/excel-analysis-toolpak-course",null,null,null,null,null,null,null,null,"Excel Functions","https://www.myonlinetraininghub.com/excel-functions"]
[null,"Excel for Customer Service Professionals","https://www.myonlinetraininghub.com/excel-for-customer-service-professionals",null,null,null,null,null,null,null,null,"Charting Blog Posts","http://www.myonlinetraininghub.com/category/excel-charts"]
[null,"Excel Tables","https://www.myonlinetraininghub.com/excel-tables-course",null,null,null,null,null,null,null,null,"Excel Dashboard Blog Posts","http://www.myonlinetraininghub.com/category/excel-dashboard"]
[null,"Advanced Excel Formulas","https://www.myonlinetraininghub.com/advanced-excel-formulas-course",null,null,null,null,null,null,null,null,"Free Downloads","https://www.myonlinetraininghub.com/workbook-downloads"]
[null,"Financial Modelling","https://www.myonlinetraininghub.com/financial-modelling-course",null,null,null,null,null,null,null,null,"Excel Keyboard Shortcuts","https://www.myonlinetraininghub.com/excel-shortcuts"]
[null,null,null,null,null,null,null,null,null,null,null,"Custom Number Format Guide","https://www.myonlinetraininghub.com/excel-custom-number-format-guide"]

{"sheet":"Merged","index":1,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[9,2,9,3],[9,4,9,6],[1,6,1,8],[3,7,3,8],[5,3,5,5],[5,7,5,8],[7,1,7,8],[21,2,21,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[30,1,30,8],[35,1,35,7],[38,1,38,5],[38,6,38,7],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[28,1,28,7]]}
[]
[null,null,null,null,"INVOICE MONTH:",null,"SEPTEMBER"]
[]
[null,"Fees are due the week beginning",null,null,null,null,null,"1st April 2019"]
[]
[null,null,"for the 4 weeks from ","1st April 2019",null,null,"to","28th April 2019"]
[]
[null,"NORMAL 4 WEEK PERIOD COVERS THE FOLLOWING CLASSES"]
[]
[null,"Day","Class Type",null,"Time",null,null,"No of Classes","Cost per Class"]
[null,"Wednesday","Modern & Tap",null,4.3,"to",5.3,4,4.5]
[null,"Wednesday","Drama",null,5.3,"to",6,4,2.5]
[null,"Wednesday","Inter Groups",null,6,"to",6.3,4,2.5]
[null,"Saturday","Private Lesson",null,10,"to",10.3,4,4]
[null,"Saturday","Junior Groups",null,10.3,"to",11,4,2.5]
[null,"Saturday","Junior Duets",null,11,"to",12,4,3]
[null,"Saturday","Break (can join in class)",null,12,"to",1,4,3]
[null,"Saturday","Ballet",null,1,"to",2,4,5]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[]
[null,"Total fees due for the above classes are",null,null,null,null,null,null,{"$f":"SUM(I11:I28)*4","v":108}]
[]
[null,"LESS (cancelled classes etc)"]
[]
[]
[]
[]
[null,"Total Deductions",null,null,null,null,null,null,0]
[]
[]
[null,"Total fees due for the above classes are",null,null,null,null,"SEPTEMBER",null,{"$f":"I29-I36","v":108}]
[]
[]
[null,"CTRL+SHIFT+M to toggle highlighting of merged cells"]

{"sheet":"Unmerged","index":2,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"INVOICE MONTH:",null,"SEPTEMBER"]
[]
[null,"Fees are due the week beginning",null,null,null,null,null,"1st April 2019"]
[]
[null,null,"for the 4 weeks from ","1st April 2019",null,null,"to","28th April 2019"]
[]
[null,"NORMAL 4 WEEK PERIOD COVERS THE FOLLOWING CLASSES"]
[]
[null,"Day","Class Type",null,"Time",null,null,"No of Classes","Cost per Class"]
[null,"Wednesday","Modern & Tap",null,4.3,"to",5.3,4,4.5]
[null,"Wednesday","Drama",null,5.3,"to",6,4,2.5]
[null,"Wednesday","Inter Groups",null,6,"to",6.3,4,2.5]
[null,"Saturday","Private Lesson",null,10,"to",10.3,4,4]
[null,"Saturday","Junior Groups",null,10.3,"to",11,4,2.5]
[null,"Saturday","Junior Duets",null,11,"to",12,4,3]
[null,"Saturday","Break (can join in class)",null,12,"to",1,4,3]
[null,"Saturday","Ballet",null,1,"to",2,4,5]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[null,null,null,null,null,"to",null,"",null,""]
[]
[null,null,null,null,null,null,null,"Total fees due for the above classes are",{"$f":"SUM(I11:I28)*4","v":108}]
[]
[null,"LESS (cancelled classes etc)"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Deductions",0]
[]
[]
[null,null,null,null,null,"Total fees due for the above classes are","SEPTEMBER",null,{"$f":"I29-I36","v":108}]