{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Title","Invoice","Wrap Up"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":3,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2096]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: sign/post/b1ae9fa6-f05e-4252-a2d3 / Pixabay"]

{"sheet":"Invoice","index":1,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,6],[1,1,1,2],[3,2,3,3],[3,5,3,7],[17,3,17,4],[4,2,4,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,1,13,6],[14,4,14,5],[15,4,15,5],[29,3,29,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[36,3,36,4],[40,2,40,6],[41,2,41,6],[43,2,43,5],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4]]}
[null,null,"Solving your Excel problems since 1998",null,"INVOICE"]
[]
[null,null,"MrExcel.com Consulting"]
[null,null,"PO Box 541731",null,"Invoice No :",1235]
[null,null,"Merritt Island FL 32954",null,"Date :",{"$f":"TODAY()","v":"2018-02-03"}]
[null,null,null,null,"Customer ID :","[ABC12345]"]
[]
[]
[null,"TO","[Name]"]
[null,null,"[Company Name]"]
[null,null,"[Street Address]"]
[null,null,"[City, State,  ZIP Code]"]
[null,null,"[Phone]"]
[]
[null,null,"Salesperson","Job","Payment Terms",null,"Due Date"]
[null,null,null,null,"Due upon receipt"]
[]
[null,"QUANTITY","Quantity","Description",null,"Unit Price","Line Total"]
[null,null,null,null,null,null,{"$f":"IF(SUM(C19)>0,SUM(C19*F19),\"\")","v":""}]
[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,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,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,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,"Subtotal",{"$f":"IF(SUM(G19:G37)>0,SUM(G19:G37),\"\")","v":""}]
[null,null,null,null,"Sales Tax @",9.5000000000000001E-2,{"$f":"IF(SUM(G38)>0,SUM(G38*F39),\"\")","v":""}]
[null,null,null,null,null,"TOTAL",{"$f":"IF(SUM(G38)>0,SUM(G38,G39),\"\")","v":""}]
[null,null,"Make all checks payable to [Your Company Name]"]
[null,null,"THANK YOU FOR YOUR BUSINESS!"]

{"sheet":"Wrap Up","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"You have an Excel VBA Macro that is not working"]
[null,"VBA has amazing debugging tools"]
[null,"Rather than run your code, you can step through the code using F8"]
[null,"The line in yellow is the line that it about to be run"]
[null,"Hover over any variable to see the value of that variable."]
[null,"Toggle back and forth to Excel to see what is happening"]