{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Defined Names","Cash","AR","Sales"],"not_rendered":{"charts":0,"images":4,"macros":0,"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":"Cover","index":0,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office 2016 Video #30"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Examples:"]
[null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"'Defined Names'!A1","v":"Example 1: Create Defined Names for Formulas"}]
[null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"'Defined Names'!A9","v":"Example 2: Create Names From Selection"}]
[null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"'Defined Names'!F1","v":"Example 3: Defined Names to Jump to Ledger Accounts"}]

{"sheet":"Defined Names","index":1,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Example 1: Create Defined Names for Formulas",null,null,null,null,"Example 3: Defined Names to Jump to Ledger Accounts"]
[]
["Loan Amount",25000]
["Month Rate",5.7499999999999999E-3]
["TotalMonths",60]
["Monthly PMT"]
[]
[]
["Example 2: Create Names From Selection"]
[]
["Transaction Number","Date","Sales","SalesRep",null,"SalesRep","Sales"]
[12568,"2014-12-01",19161,"Jo",null,"Jo"]
[12569,"2014-12-01",15027,"Gigi",null,"Gigi"]
[12570,"2014-12-02",12953,"Chin",null,"Chin"]
[12571,"2014-12-02",12670,"Jo"]
[12572,"2014-12-02",8893,"Gigi",null,"Total"]
[12573,"2014-12-03",4667,"Chin",null,"Count"]
[12574,"2014-12-03",20272,"Jo",null,"Max"]
[12575,"2014-12-03",20204,"Gigi",null,"Min"]
[12576,"2014-12-03",17223,"Chin"]

{"sheet":"Cash","index":2,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Account:",null,null,"Cash - BECU",null,null,"Account Number:",null,100]
[null,"Date",null,"Item","Post. Ref.","Debit","Credit","Balance"]
[null,null,null,null,null,null,null,"Debit","Credit"]

{"sheet":"AR","index":3,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Account:",null,null,"Accounts Receivable",null,null,"Account Number:",null,120]
[null,"Date",null,"Item","Post. Ref.","Debit","Credit","Balance"]
[null,null,null,null,null,null,null,"Debit","Credit"]

{"sheet":"Sales","index":4,"n_rows":3,"n_cols":9,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Account:",null,null,"Sales",null,null,"Account Number:",null,400]
[null,"Date",null,"Item","Post. Ref.","Debit","Credit","Balance"]
[null,null,null,null,null,null,null,"Debit","Credit"]