{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Transactions"],"not_rendered":{"charts":0,"images":0,"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":"Budget","index":0,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[1,8,3,10],[11,9,13,15]]}
["Cash Inflows","Estimated","Actual",null,"Cash Outflows","Esimated","Actual"]
["Paycheck",1100,null,null,"Tithing and Fast Offerings",null,null,null,"2011-03-01"]
[null,null,null,null,"Tithing",250]
["Other",0,null,null,null,{"$f":"SUM(F3)","v":250},{"$f":"SUM(G3)","v":0}]
["Interest",0,null,null,"House",null,null,null,{"$f":"I2","v":"2011-03-01"},"to",{"$f":"IF(DATE(YEAR(I2), MONTH(I2)+1, 1) - 1>TODAY(), TODAY(), DATE(YEAR(I2), MONTH(I2)+1, 1) - 1)","v":"2011-03-31"}]
["Total",{"$f":"SUM(B2:B5)","v":1100},{"$f":"SUM(C2:C5)","v":0},null,"Rent",430]
[null,null,null,null,"Electric Bill",100]
[null,null,null,null,"Misc",null,null,null,"Budget vs. Actual","Net Cash"]
[null,null,null,null,null,{"$f":"SUM(F6:F8)","v":530},{"$f":"SUM(G6:G8)","v":0},null,{"$f":"F50-G50","v":1646.81},{"$f":"C6-G50","v":0}]
[null,null,null,null,"Auto"]
[null,null,null,null,"Car Repairs"]
[null,null,null,null,"Car inspection/emission",null,null,null,"*Note:","I've set this particular example up so that you don't have to download the Zion's Bank information since you don't have my Zion's Bank Login.  To test the categorization feature, just click the button below and it will use a pre-populated transaction sheet!"]
[null,null,null,null,"Oil Changes"]
[null,null,null,null,"Insurance (6 months)"]
[null,null,null,null,"Gasoline",60]
[null,null,null,null,null,{"$f":"SUM(F12:F15)","v":60},{"$f":"SUM(G11:G15)","v":0}]
[null,null,null,null,"Health"]
[null,null,null,null,"Beauty Supplies"]
[null,null,null,null,"Medical Supplies"]
[null,null,null,null,"Dentist"]
[null,null,null,null,"Doctor"]
[null,null,null,null,"Health Insurance"]
[null,null,null,null,null,{"$f":"SUM(F18:F22)","v":0},{"$f":"SUM(G11:G22)","v":0}]
[null,null,null,null,"Necessities"]
[null,null,null,null,"Groceries",350]
[null,null,null,null,"Dining out",100]
[null,null,null,null,"Dry Cleaning"]
[null,null,null,null,"Clothes"]
[null,null,null,null,null,{"$f":"SUM(F25:F28)","v":450},{"$f":"SUM(G25:G28)","v":0}]
[null,null,null,null,"Entertainment"]
[null,null,null,null,"Dates",100]
[null,null,null,null,"Golf"]
[null,null,null,null,"Netflix",10.67]
[null,null,null,null,"Computer"]
[null,null,null,null,"Quilting"]
[null,null,null,null,"iPhone apps",5]
[null,null,null,null,"Allowances"]
[null,null,null,null,null,{"$f":"SUM(F31:F37)","v":115.67},{"$f":"SUM(G31:G37)","v":0}]
[null,null,null,null,"Other Expenses"]
[null,null,null,null,"Haircuts",90]
[null,null,null,null,"Cell phones",121.14]
[null,null,null,null,"School"]
[null,null,null,null,"Gifts",30]
[null,null,null,null,"Tuition"]
[null,null,null,null,"Textbooks"]
[null,null,null,null,"Credit Card"]
[null,null,null,null,null,{"$f":"SUM(F40:F46)","v":241.14},{"$f":"SUM(G40:G46)","v":0}]
[]
[]
[null,null,null,null,"Total",{"$f":"SUM(F4, F9, F16, F23, F29, F38, F47)","v":1646.81},{"$f":"SUM(G4, G9, G16, G23, G29, G38, G47)","v":0}]

{"sheet":"Transactions","index":1,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["03/02/2011 ","24323011WGPXNY655 MARKETPLACE CAFE PROVO UT",5.05,null,"03/04/2011 ","ZIONS BANK PAYROLL",589.46]
["03/02/2011 ","P.O.S. PURCHASE MAVERIK CO 1240 S 800 OREM UT",5.38,null,"03/08/2011 ","DEPOSIT",67.38]
["03/03/2011 ","24692161X00RJY35T AMAZON MKTPLACE PMTS AMZN.COM/BILL WA",4.51,null,"03/14/2011 ","DEPOSIT",86.37]
["03/04/2011 ","24323011YGPXRV78N MARKETPLACE CAFE PROVO UT",7.3,null,"03/18/2011 ","ZIONS BANK PAYROLL",575.37]
["03/04/2011 ","24224431Z30VMWTQ4 PANDA EXPRESS 724 PROVO UT",12.91]
["03/07/2011 ","24071051ZWPAJKGF5 GROUPON INC. 877-7887858 IL",1,null,null,null,{"$f":"SUM(G1:G4)","v":1318.58}]
["03/07/2011 ","243230120GPXSR755 MARKETPLACE CAFE PROVO UT",5.05]
["03/07/2011 ","P.O.S. PURCHASE COSTCO WHS 648 EAST 80 OREM UT",20.52]
["03/07/2011 ","2449398205SAZLHVM RED ROBIN 416 PROVO UT",22.45]
["03/07/2011 ","P.O.S. PURCHASE Wal-Mart S 3208 WAL-SA SPRINGVILL UT",28.8]
["03/07/2011 ","P.O.S. PURCHASE MACEYS PRO 1400 N STAT PROVO UT",56.54]
["03/08/2011 ","24692162200R5KG9F NFI*WWW.NETFLIX.COM/CC NETFLIX.COM CA",10.67]
["03/09/2011 ","CHECK",162.80000000000001]
["03/09/2011 ","243230123GPXVNRLX MARKETPLACE CAFE PROVO UT",6.23]
["03/10/2011 ","P.O.S. PURCHASE MAVERIK CO 1240 S 800 OREM UT",3.07]
["03/10/2011 ","243230124GPXWMA48 MARKETPLACE CAFE PROVO UT",5.04]
["03/11/2011 ","TELLER CASHED CHECK",17.5]
["03/11/2011 ","2444500252XEH65GH WENDYS #4710 Q25 PROVO UT",12.75]
["03/14/2011 ","CHECK",420]
["03/14/2011 ","2443106278B5TAK7B PITA PIT UTAH LLC PROVO UT",3.77]
["03/14/2011 ","243230127GPXZGTW6 MARKETPLACE CAFE PROVO UT",5.05]
["03/14/2011 ","P.O.S. PURCHASE COSTCO WHS 648 EAST 80 OREM UT",20.49]
["03/14/2011 ","P.O.S. PURCHASE MACEYS PRO 1400 N STAT PROVO UT",25.19]
["03/16/2011 ","P.O.S. PURCHASE 7TH EAST C 695 E 800 N PROVO UT",45.38]
["03/17/2011 ","24707802BLS0NRS2P BRICK OVEN PROVO UT",18.309999999999999]
["03/21/2011 ","24323012DGPY3AXE6 MARKETPLACE CAFE PROVO UT",5.15]
["03/21/2011 ","P.O.S. PURCHASE COSTCO WHS 648 EAST 80 OREM UT",15.86]
["03/21/2011 ","24164072DMJ8X17FV FEDEX 875058481478 800-4633339 TN",21.65]
["03/21/2011 ","P.O.S. PURCHASE MACEYS PRO 1400 N STAT PROVO UT",28.72]
["03/21/2011 ","BYU MARKETPLACE PROVO UT US",6.23]
["03/22/2011 ","24493982H5SAWQRSF RED ROBIN 416 PROVO UT",17.170000000000002]
["03/22/2011 ","BYU MARKETPLACE PROVO UT US",5.05]
["03/22/2011 ","MAVERIK COUNTRY STORE3OREM UT US",1]
[]
[null,null,{"$f":"SUM(C1:C33)","v":1026.5899999999999}]