{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Budget Chart","Budget","importData","All Transactions","RentalData","Categorization Rules","Loan Sensitivity","Amortization Schedule"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":21,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Budget Chart","index":0,"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":"Budget","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"Start Date","End Date"]
["Month","2015-04-01","2015-04-22"]
[]
["Category","Budget","Actual","Difference"]
["Car",25,0,{"$f":"B5-C5","v":25}]
["Clothes",25,0,{"$f":"B6-C6","v":25}]
["Donations",25,20,5]
["Eating Out",25,0,25]
["Education",25,68.09,-43.09]
["Fast Food",25,17.27,7.73]
["Gas",100,41.01,58.99]
["Gifts",25,0,25]
["Groceries",300,133.9,166.1]
["Health",500,0,500]
["Insurance",25,191.42,-166.42]
["Rent",800,85,715]
["Tithing",0,0,0]
["Travel",0,0,0]
["Tupperware",0,0,0]
["Uncategorized",0,2019.03,-2019.03]
["Utilities",25,24.15,0.85000000000000142]

{"sheet":"importData","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Account","Date","Amount","Description","Category","Memo","Notes"]
["VISA Credit","2015-04-22",22.75,"MACEYS PROVO","Groceries"]
["VISA Credit","2015-04-22",-21.63,"SALEM HILLS PHARMACY SALEM UT","Utilities"]
["Checking","2015-04-21",-7.48,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["Checking","2015-04-20",-123.66,"WINCO FOODS # 76 895 N Orem UT","Groceries"]
["VISA Credit","2015-04-20",-8.99,"DENTALPLANS.COM 800-494-9294 FL","Health"]
["VISA Credit","2015-04-19",-5.04,"STEVENSONS GENEALOGY A PROVO UT","Utilities"]
["VISA Credit","2015-04-19",-12.69,"MCDONALD'S F37150 WEST VALLEY C UT","Fast Food"]
["VISA Credit","2015-04-19",-66.14,"JOANN FABRIC #1756 OREM UT","Utilities"]
["VISA Credit","2015-04-19",-1.22,"ASIAN MARKET PROVO UT","Utilities"]
["VISA Credit","2015-04-19",-19.48,"ASIAN MARKET PROVO UT","Utilities"]
["Checking","2015-04-17",703.98,"Check Deposit","Uncategorized"]
["Checking","2015-04-17",-150,"ACH Withdrawal BYU","Utilities"]
["VISA Credit","2015-04-16",-37.9,"CHEVRON 00072863 OREM UT","Gas"]
["VISA Credit","2015-04-15",-12.14,"COSTA VIDA PROVO UT","Utilities"]
["VISA Credit","2015-04-14",-8.5299999999999994,"SQ *NYCE-YCE LLC Salem UT","Utilities"]
["Checking","2015-04-14",-15,"Check Withdrawal: #000455","Uncategorized"]
["VISA Credit","2015-04-13",-2.99,"SQ *NYCE-YCE LLC Salem UT","Utilities"]
["Checking","2015-04-13",900,"Online Deposit From Share 01","Internal Transfer"]
["Savings","2015-04-13",-900,"Online Withdrawal To Share 50","Internal Transfer"]
["Checking","2015-04-13",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2015-04-13",895,"ACH Deposit REAL PROPERTY MA","Rental Income"]
["VISA Credit","2015-04-12",-33.659999999999997,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["VISA Credit","2015-04-12",-10.34,"SWEET TOMATOES 54 Q14 SANDY UT","Groceries"]
["VISA Credit","2015-04-12",-12.8,"DRESSING YOUR TRUTH LEHI UT","Clothes"]

{"sheet":"All Transactions","index":3,"n_rows":236,"n_cols":7,"rows_kept":236,"cut":false,"hidden":false,"merged":[]}
["Account","Date","Amount","Description","Category","Memo","Notes"]
["Checking","2015-04-11",-8.1300000000000008,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["Checking","2015-04-10",-7.49,"EL AZTECA TACO SHOP PROVO UT","Fast Food"]
["Checking","2015-04-09",-31.5,"BYU STORE PROVO UT","Education"]
["Checking","2015-04-09",-1840,"Check Withdrawal: #000456","Uncategorized"]
["Checking","2015-04-09",-16.010000000000002,"BYU STORE - INTERNET 801-422-2400 UT","Education"]
["VISA Credit","2015-04-08",-11.49,"RANCHO MARKET #4 PROVO UT","Groceries"]
["Checking","2015-04-08",-191.42,"ACH Withdrawal ALLSTATE INS CO","Insurance"]
["Checking","2015-04-08",-20,"ACH Withdrawal STEVE SOULIER","Utilities"]
["Checking","2015-04-07",-4.1500000000000004,"SQ *RESTRANT THE CHOCOL Orem UT","Utilities"]
["Checking","2015-04-07",-20,"PAYPAL *INDIEGOGO 402-935-7733 CA","Donations"]
["Checking","2015-04-07",-97.1,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-04-07",-32.700000000000003,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-04-06",1200,"Online Deposit From Share 01","Internal Transfer"]
["Savings","2015-04-06",-1200,"Online Withdrawal To Share 50","Internal Transfer"]
["VISA Credit","2015-04-04",-114.28,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["VISA Credit","2015-04-04",-9.7799999999999994,"JAMBA JUICE #201 PROVO UT","Fast Food"]
["VISA Credit","2015-04-03",-41.01,"CHEVRON 00073049 PROVO UT","Gas"]
["Checking","2015-04-03",-18.73,"Check Withdrawal: #000454","Uncategorized"]
["Checking","2015-04-03",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2015-04-02",-9,"Check Withdrawal: #000453","Uncategorized"]
["Checking","2015-04-02",-21.5,"AMAZON MKTPLACE PMTS AMZN.COM/BILL WA","Uncategorized"]
["Checking","2015-04-02",-12.65,"BYU STORE PROVO UT","Education"]
["Checking","2015-04-02",-7.93,"BYU STORE PROVO UT","Education"]
["Checking","2015-04-01",-11.29,"IFA PROVO 55 WEST 500 SOUTH PROVO UT","Utilities"]
["Checking","2015-04-01",-35,"ART CITY TROLLEY SPRINGVILLE UT","Utilities"]
["Checking","2015-03-31",0.46,"Dividend Deposit 0.100%","Income"]
["Megan Savings","2015-03-31",0.02,"Dividend Deposit 0.100%","Income"]
["Savings","2015-03-31",0.21,"Dividend Deposit 0.100%","Income"]
["Checking","2015-03-31",1500,"Online Deposit From Share 01","Internal Transfer"]
["Savings","2015-03-31",-1500,"Online Withdrawal To Share 50","Internal Transfer"]
["VISA Credit","2015-03-30",-670.43,"Loan Advance To Share 50","Internal Transfer"]
["Checking","2015-03-30",-825,"ACH Withdrawal TIE ALPHA L.C.","Rent"]
["Checking","2015-03-30",670.43,"Deposit From Loan 75","Internal Transfer"]
["VISA Credit","2015-03-29",-8,"WIGGY WASH SPANISH FORK UT","Car"]
["Checking","2015-03-29",50,"HYATT HOTELS HOUSTON HOUSTON TX","Travel"]
["VISA Credit","2015-03-28",-4.88,"TACO BELL #27887 PAYSON UT","Fast Food"]
["Checking","2015-03-27",-50,"HYATT HOTELS HOUSTON HOUSTON TX","Travel"]
["VISA Credit","2015-03-26",-1.03,"HARMONS - DIXIE ST. GEORGE UT","Groceries"]
["VISA Credit","2015-03-26",-39.049999999999997,"HARMONS - DIXIE ST. GEORGE UT","Groceries"]
["VISA Credit","2015-03-25",-52.77,"KID TO KID ST GEORGE ST GEORGE UT","Clothes"]
["VISA Credit","2015-03-25",-20,"ST GEORGE COMMUNITY HE ST GEORGE UT","Health"]
["Checking","2015-03-25",-10.93,"PAPPAS BAR-B-Q #664Q80 HOUSTON TX","Eating Out"]
["VISA Credit","2015-03-24",-8.44,"REAL FOODS MARKET LLC SALT LAKE CIT UT","Groceries"]
["Checking","2015-03-24",-3.2,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["Checking","2015-03-23",-0.08,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-23",-8.09,"SUPERCHE 652 SAMARA ST MEXICO DF MX","Travel"]
["Checking","2015-03-23",-6.5,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-23",-650.04,"HILTON MEX CITY STA FE MEXICO DF MX","Travel"]
["VISA Credit","2015-03-23",3381.78,"Online Loan Payment From Share 01","Internal Transfer"]
["Savings","2015-03-23",-3381.78,"Online Withdrawal To Loan 75","Internal Transfer"]
["Checking","2015-03-23",-2.14,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-23",-213.71,"BUDGET AEROPUERTO DE M MEXICO DF MX","Travel"]
["VISA Credit","2015-03-22",-9.09,"YOGURTLAND ST.GEORGE UT ST GEORGE UT","Fast Food"]
["Checking","2015-03-21",-0.09,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-21",-9.2799999999999994,"REST EL GRILL OPERADOR MEXICO DF MX","Travel"]
["VISA Credit","2015-03-21",-37.79,"VITAMIN COTTAGESG WASHINGTON UT","Groceries"]
["Checking","2015-03-21",-1.5,"Fee Withdrawal NON CO-OP ATM","Travel"]
["Checking","2015-03-21",-0.36,"Fee Withdrawal ATM Fee","Travel"]
["Checking","2015-03-21",-35.619999999999997,"ATM Withdrawal #508001064327","Travel"]
["Checking","2015-03-21",-0.04,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-21",-4.41,"LA CREPE PARISIENE MEXICO DF MX","Travel"]
["VISA Credit","2015-03-20",-27.66,"REAL FOODS MARKET LLC SALT LAKE CIT UT","Groceries"]
["VISA Credit","2015-03-20",-35,"ST GEORGE COMMUNITY HE ST GEORGE UT","Health"]
["Checking","2015-03-20",-0.09,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-20",-8.61,"JUG IMAGINARIUM STA FE MEXICO DF MX","Travel"]
["Checking","2015-03-20",-26.98,"FTD*FTD.COM 501-8336470 IL","Gifts"]
["VISA Credit","2015-03-20",-8.99,"DENTALPLANS.COM 800-494-9294 FL","Health"]
["Checking","2015-03-20",-0.06,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-20",-5.79,"COMI POLLO VA QUE VUEL MEXICO DF MX","Travel"]
["Checking","2015-03-20",-15,"GROUPON INC 877-788-7858 IL","Gifts"]
["Checking","2015-03-19",-0.02,"Fee Withdrawal Card Fee","Travel"]
["Checking","2015-03-19",-2.2400000000000002,"BURGER KING SAMARA MEXICO DF MX","Fast Food"]
["Checking","2015-03-19",-2.5,"UTA-FRONTRUNNER TVM SALT LAKE CIT UT","Travel"]
["Checking","2015-03-19",-5.5,"UTA-FRONTRUNNER TVM SALT LAKE CIT UT","Travel"]
["VISA Credit","2015-03-18",-32.979999999999997,"Company 00209539 OREM UT","Gas"]
["Checking","2015-03-18",-15.39,"NOODLES & CO 716 PROVO UT","Eating Out"]
["Checking","2015-03-17",-7000,"Online Withdrawal To Share 01","Internal Transfer"]
["Savings","2015-03-17",7000,"Online Deposit From Share 50","Internal Transfer"]
["VISA Credit","2015-03-17",500,"Online Loan Payment From Share 50","Internal Transfer"]
["Checking","2015-03-17",-500,"Online Withdrawal To Loan 75","Internal Transfer"]
["VISA Credit","2015-03-17",-68.23,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["VISA Credit","2015-03-17",-7.09,"JAMBA JUICE #201 PROVO UT","Fast Food"]
["Checking","2015-03-17",-14.73,"ACH Withdrawal PAYPAL","Uncategorized"]
["VISA Credit","2015-03-16",45,"Total Payment: $45.00","Gifts"]
["VISA Credit","2015-03-16",-36,"GROUPON INC 877-788-7858 IL","Health"]
["VISA Credit","2015-03-16",-45,"GROUPON INC 877-788-7858 IL","Gifts"]
["VISA Credit","2015-03-15",-5.47,"BYU COUGAR CREATIONS PROVO UT","Uncategorized"]
["Checking","2015-03-15",-2,"PROVO UT RECREATION CE PROVO UT","Uncategorized"]
["VISA Credit","2015-03-14",-282.66000000000003,"UTAH VALLEY HOSPITAL PROVO UT","Fast Food"]
["VISA Credit","2015-03-14",-18.809999999999999,"SHOPKO 00500868 PROVO UT","Uncategorized"]
["VISA Credit","2015-03-14",-11.72,"SEAGULL BOOK - 0160 PROVO UT","Uncategorized"]
["Checking","2015-03-13",-7.64,"BYU STORE PROVO UT","Education"]
["Checking","2015-03-13",-19.600000000000001,"LDS BYU CENTER 707 PROVO UT","Uncategorized"]
["Checking","2015-03-13",-3.63,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-03-12",-6.02,"YOGURTLAND OREM OREM UT","Fast Food"]
["Checking","2015-03-11",-62.91,"SMITHS 350 N. FREEDOM PROVO UT","Uncategorized"]
["Checking","2015-03-11",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2015-03-11",-69.77,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-03-11",-1097.5,"KEVIN J REECE DDS PAYSON UT","Health"]
["VISA Credit","2015-03-10",-68.040000000000006,"MACEYS PROVO PROVO UT","Groceries"]
["VISA Credit","2015-03-10",-6.37,"DOLRTREE 2626 00026260 PROVO UT","Uncategorized"]
["VISA Credit","2015-03-10",-10.32,"JAMBA JUICE #201 PROVO UT","Fast Food"]
["Checking","2015-03-10",-41.79,"Bill Pay Withdrawal #X8AX2NF7HOBY","Uncategorized"]
["Checking","2015-03-10",-20,"PP*CRIO INC LINDON UT","Uncategorized"]
["Checking","2015-03-10",-100,"ACH Withdrawal DHS TTP PROG FEE","Uncategorized"]
["Checking","2015-03-10",895,"ACH Deposit REAL PROPERTY MA","Rental Income"]
["Checking","2015-03-09",-30.28,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-03-09",-30,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-03-09",-20,"ACH Withdrawal STEVE SOULIER","Utilities"]
["VISA Credit","2015-03-08",-24,"THAI VILLAGE - AMERICAN AMERICAN FORK UT","Eating Out"]
["VISA Credit","2015-03-08",-45,"HEBER VALLEY HISTORIC 801-376-8028 UT","Uncategorized"]
["VISA Credit","2015-03-08",-100,"PP*SELFRELIANT SARATOGA SP UT","Uncategorized"]
["VISA Credit","2015-03-07",-36.67,"Company 00073049 PROVO UT","Gas"]
["VISA Credit","2015-03-07",-18.5,"ALPINE FOOD STORAGE HIGHLAND UT","Uncategorized"]
["VISA Credit","2015-03-07",-14.2,"ALPINE FOOD STORAGE HIGHLAND UT","Uncategorized"]
["Checking","2015-03-06",-9,"CITY OF PROVO PEAKS IC PROVO UT","Uncategorized"]
["VISA Credit","2015-03-05",-51.23,"HERFF JONES COLLEGE 217-351-9500 IL","Uncategorized"]
["Checking","2015-03-04",-20,"THE OLIVE GARD00012922 PROVO UT","Eating Out"]
["Checking","2015-03-04",-15,"Bill Pay Withdrawal #M4UOSWSKJY9D","Uncategorized"]
["Checking","2015-03-04",-3.68,"Bill Pay Withdrawal #BM86TYSCFXQQ","Uncategorized"]
["Checking","2015-03-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2015-03-04",-351.13,"RIVERWOODS ADV DIAG IMA PROVO UT","Uncategorized"]
["VISA Credit","2015-03-03",-703.98,"DELTA AIR 00623033581 DELTA.COM CA","Travel"]
["Checking","2015-03-02",-825,"ACH Withdrawal TIE ALPHA L.C.","Rent"]
["Checking","2015-03-02",-65,"ACH Withdrawal CASSIE LEEPER","Uncategorized"]
["Checking","2015-03-01",-13.01,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["Checking","2015-02-28",0.3,"Dividend Deposit 0.100%","Income"]
["Checking","2015-02-28",-41.63,"COSTCO WHSE #0484 648 EAST 800 SOUTH OREM","Groceries"]
["Megan Savings","2015-02-28",0.02,"Dividend Deposit 0.100%","Income"]
["Checking","2015-02-27",-9.6999999999999993,"PAPA JOHN'S #01566 801-356-7272 UT","Eating Out"]
["Checking","2015-02-27",-6.27,"Bill Pay Withdrawal #UJWVMO66TB2K","Uncategorized"]
["Checking","2015-02-26",-35.049999999999997,"MACEYS PROVO PROVO UT","Groceries"]
["Checking","2015-02-26",-32.840000000000003,"COSTCO WHSE #0484 648 EAST 800 SOUTH OREM","Groceries"]
["Checking","2015-02-25",-9.06,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["Checking","2015-02-25",-170,"Check Withdrawal: #000452","Uncategorized"]
["Checking","2015-02-24",10027,"ACH Deposit IRS TREAS 310","Taxes"]
["Checking","2015-02-23",13.84,"SPROUTS FARMERS MARSSS OREM UT","Groceries"]
["Checking","2015-02-22",-796.03,"CENTRAL UTAH SURGICAL C 801-374-0354 UT","Health"]
["Checking","2015-02-22",-2.66,"MANY LANDS PROVO UT","Uncategorized"]
["VISA Credit","2015-02-21",-38.99,"DENTALPLANS.COM 800-494-9294 FL","Health"]
["Checking","2015-02-21",-48.41,"SPROUTS FARMERS MKT#602 OREM UT","Groceries"]
["Checking","2015-02-21",-24,"BRIGHAM YOUNG UNIV WEB 801-422-4701 UT","Education"]
["Checking","2015-02-20",-71.5,"UTAH-DMV OFFICES SALT LAKE CIT UT","Car"]
["VISA Credit","2015-02-19",-7.49,"JAMBA JUICE #201 PROVO UT","Fast Food"]
["Checking","2015-02-19",-91.61,"JIFFY LUBE #968 290 W 1230 N PROVO UT","Car"]
["Checking","2015-02-19",-25,"UT CO-MARRIAGE LICENSE PROVO UT","Uncategorized"]
["VISA Credit","2015-02-18",500,"Online Loan Payment From Share 50","Internal Transfer"]
["Checking","2015-02-18",-500,"Online Withdrawal To Loan 75","Internal Transfer"]
["Checking","2015-02-18",30,"AMAZON.COM REFUNDAMAZON.COM SEATTLE WA","Uncategorized"]
["Checking","2015-02-18",-2.81,"USPS 4971760601 95 W 100 S PROVO UT","Uncategorized"]
["Checking","2015-02-18",1590,"ACH Deposit FRANCHISE TAX BD","Taxes"]
["VISA Credit","2015-02-17",-8.74,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["Checking","2015-02-17",920,"ACH Deposit REAL PROPERTY MA","Rental Income"]
["Checking","2015-02-16",-121.13,"COSTCO WHSE #0484 648 EAST 800 SOUTH OREM","Groceries"]
["Checking","2015-02-16",-5.33,"COSTCO WHSE #0484 648 EAST 800 SOUTH OREM","Groceries"]
["VISA Credit","2015-02-15",-23.53,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["VISA Credit","2015-02-13",-1.39,"BYU COUGAR CREATIONS PROVO UT","Uncategorized"]
["VISA Credit","2015-02-13",-6.1,"BYU COUGAR CREATIONS PROVO UT","Uncategorized"]
["VISA Credit","2015-02-12",-3.59,"LEHI ROLLER MILLS LEHI UT","Uncategorized"]
["Checking","2015-02-12",-40,"Check Withdrawal: #000495","Uncategorized"]
["Checking","2015-02-12",-43.24,"MACEYS PROVO PROVO UT","Groceries"]
["Checking","2015-02-12",-30.7,"Company 00073049 PROVO UT","Gas"]
["VISA Credit","2015-02-11",-24.51,"NATURAL GROCERS-LG LOGAN UT","Groceries"]
["VISA Credit","2015-02-11",-65,"SUNRISE CYCLERY LOGAN UT","Uncategorized"]
["Checking","2015-02-11",-24.94,"Bill Pay Withdrawal #DULXATORZ8G6","Uncategorized"]
["Checking","2015-02-11",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2015-02-11",-370,"ACH Withdrawal STEVE SOULIER","Utilities"]
["VISA Credit","2015-02-10",-12.46,"NATURAL GROCERS-LG LOGAN UT","Groceries"]
["Checking","2015-02-10",-2.3199999999999998,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["VISA Credit","2015-02-09",-45,"SQ *STEPHANIE A. HOGLUN Hyde Park UT","Uncategorized"]
["Checking","2015-02-09",-20,"ACH Withdrawal STEVE SOULIER","Utilities"]
["Checking","2015-02-06",-305.16000000000003,"ACH Withdrawal THE LOGO SHOP","Uncategorized"]
["Checking","2015-02-05",-90.32,"Check Withdrawal: #000492","Uncategorized"]
["VISA Credit","2015-02-04",-42.62,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["Checking","2015-02-04",-17.28,"HEBER VALLEY MILK MIDWAY UT","Groceries"]
["Checking","2015-02-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2015-02-03",-15,"ART OF BEAUTY 216-4366363 OH","Uncategorized"]
["Checking","2015-02-03",-25.31,"COSTCO GAS #0484 648 EAST 800 S. OREM UT","Groceries"]
["Checking","2015-02-03",-151.58000000000001,"COSTCO WHSE #0484 648 EAST 800 SOUTH OREM","Groceries"]
["VISA Credit","2015-01-31",-18.760000000000002,"BEEHIVE HEALTH ESS SPANISH FORK UT","Health"]
["VISA Credit","2015-01-31",-29.7,"MACEY'S SPANISH FORK UT","Groceries"]
["VISA Credit","2015-01-31",-6.18,"MY SISTER'S CLOSET LLC SPANISH FORK UT","Clothes"]
["VISA Credit","2015-01-31",-95,"KEVIN J REECE DDS 801-465-4474 UT","Health"]
["Checking","2015-01-31",0.43,"Dividend Deposit 0.100%","Income"]
["Checking","2015-01-31",-18,"DENNY'S #7482 PROVO UT","Eating Out"]
["Megan Savings","2015-01-31",0.02,"Dividend Deposit 0.100%","Income"]
["Checking","2015-01-30",-4.09,"BYU CREAMERY FOUNTAIN PROVO UT","Groceries"]
["Checking","2015-01-29",55,"ACH Deposit PAYPAL","Uncategorized"]
["VISA Credit","2015-01-28",-19.52,"BYU STORE PROVO UT","Education"]
["Checking","2015-01-28",-825,"ACH Withdrawal TIE ALPHA L.C.","Rent"]
["Checking","2015-01-27",-20,"IHOP 1730 00017301 OREM UT","Eating Out"]
["Checking","2015-01-27",-1694,"ACH Withdrawal BYU","Uncategorized"]
["VISA Credit","2015-01-23",1000,"Online Loan Payment From Share 50","Internal Transfer"]
["Checking","2015-01-23",-1000,"Online Withdrawal To Loan 75","Internal Transfer"]
["VISA Credit","2015-01-23",-8.39,"RICE GARDEN 052 PROVO UT","Uncategorized"]
["Checking","2015-01-23",-52.7,"ACH Withdrawal PAYPAL","Uncategorized"]
["Checking","2015-01-22",-111.34,"SMITHS 350 N. FREEDOM PROVO UT","Uncategorized"]
["VISA Credit","2015-01-20",-6.42,"LITTLE CAESARS 0373 000 SAINT GEORGE UT","Fast Food"]
["VISA Credit","2015-01-20",-4,"BRIGHAM YOUNG UNIV WEB 801-422-4701 UT","Education"]
["Checking","2015-01-20",-29.8,"MAVERIK CNTRY STRE 229 ST GEORGE UT","Gas"]
["Checking","2015-01-20",-6.05,"EINSTEIN BROS 4064 STOR ST GEORGE UT","Fast Food"]
["Checking","2015-01-19",-15.19,"7 ELEVEN 36341 DALLAS T SPRINGVILLE UT","Uncategorized"]
["Checking","2015-01-19",-6.36,"MAVERIK COUNTRY STORE229 690 RIVER RD ST","Gas"]
["VISA Credit","2015-01-16",-27.51,"REAL FOODS MARKET LLC SALT LAKE CIT UT","Groceries"]
["VISA Credit","2015-01-16",-37.76,"HARMONS - DIXIE ST. GEORGE UT","Groceries"]
["Checking","2015-01-15",-15.36,"CEDAR CITY ARCTIC CIRCL CEDAR CITY UT","Fast Food"]
["VISA Credit","2015-01-14",-11.5,"PROVO DI PROVO UT","Uncategorized"]
["Checking","2015-01-14",-20,"DRIVER LIC RENEWAL NET 801-965-4435 UT","Uncategorized"]
["Checking","2015-01-13",895,"ACH Deposit REAL PROPERTY MA","Rental Income"]
["Checking","2015-01-12",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2015-01-11",-52,"AAA MEMBERSHIP 800-922-8228 CA","Car"]
["VISA Credit","2015-01-09",-41.96,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["VISA Credit","2015-01-09",-1.63,"SPROUTS FARMERS MAR OREM UT","Groceries"]
["Checking","2015-01-09",-145.5,"BYU STORE PROVO UT","Education"]
["Checking","2015-01-09",-10.55,"COSTCO GAS #1118 273 EAST 100 NORTH","Groceries"]
["Checking","2015-01-09",-147,"COSTCO WHSE #1118 273 EAST 1000 NORTH","Groceries"]
["Checking","2015-01-09",-14.19,"Check Withdrawal: #000494","Uncategorized"]
["Checking","2015-01-09",-29.57,"DRESSING YOUR TRUTH 801-631-0923 UT","Clothes"]
["Checking","2015-01-08",-28.99,"Bill Pay Withdrawal #HR2YX0GWXPUH","Uncategorized"]
["Checking","2015-01-08",-30,"Bill Pay Withdrawal #WQ7AMCSPE4KE","Uncategorized"]
["Checking","2015-01-08",5931,"ACH Deposit BYU Refund","Uncategorized"]
["Checking","2015-01-08",-38.869999999999997,"Bill Pay Withdrawal #T3UB60Q285EJ","Uncategorized"]
["Checking","2015-01-07",-48.3,"BYU CREAMERY ON NINTH PROVO UT","Groceries"]
["Checking","2015-01-07",-20,"ACH Withdrawal STEVE SOULIER","Utilities"]
["VISA Credit","2015-01-06",-2.44,"AUTOZONE #3765 PROVO UT","Car"]
["Checking","2015-01-06",-90.97,"ACH Withdrawal AMAZON MARKETPLA","Uncategorized"]
["VISA Credit","2015-01-05",-34.479999999999997,"Company 00073049 PROVO UT","Gas"]
["Checking","2015-01-05",-400,"Check Withdrawal: #000493","Uncategorized"]
["Checking","2015-01-05",-117.7,"ACH Withdrawal BYU","Uncategorized"]
["Checking","2015-01-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2015-01-05",-5,"ACH Withdrawal BYU","Uncategorized"]
["Checking","2015-01-02",-61.63,"ACH Withdrawal AMAZON MARKETPLA","Uncategorized"]
["Checking","2015-01-02",-37.31,"ACH Withdrawal AMAZON MARKETPLA","Uncategorized"]
["VISA Credit","2015-01-01",250,"Online Loan Payment From Share 50","Internal Transfer"]
["Checking","2015-01-01",-250,"Online Withdrawal To Loan 75","Internal Transfer"]

{"sheet":"RentalData","index":4,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Account","Date","Amount","Description","Category",null,"Year","Yearly Costs","Yearly Income"]
["Checking","2015-03-11",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null,2016]
["Checking","2015-03-10",895,"ACH Deposit REAL PROPERTY MA","Rental Income",null,2015,{"$f":"(SUMIFS(C:C,B:B,\">1/1/2015\",E:E,\"=* Mortgage\")+SUMIFS(C:C,B:B,\">1/1/2015\",E:E,\"=* Costs\"))*-1","v":2937.36},{"$f":"SUMIFS(C:C,B:B,\">1/1/2015\",E:E,\"*Income\")","v":2710}]
["Checking","2015-03-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null,2014,{"$f":"(SUMIFS(C:C,B:B,\">1/1/2014 \",E:E,\"=*Mortgage\")+SUMIFS(C:C,B:B,\">1/1/2014 \",E:E,\"=*Costs\")-(SUMIFS(C:C,B:B,\">1/1/2015 \",E:E,\"=* Mortgage\")+SUMIFS(C:C,B:B,\">1/1/2015 \",E:E,\"=* Costs\")))*-1","v":11725.389999999998},{"$f":"SUMIFS(C:C,B:B,\">1/1/2014\",E:E,\"*Income\")-SUMIFS(C:C,B:B,\">1/1/2015\",E:E,\"*Income\")","v":9837.4}]
["Checking","2015-02-17",920,"ACH Deposit REAL PROPERTY MA","Rental Income",null,2013,{"$f":"(SUMIFS(C:C,B:B,\">1/1/2013 \",E:E,\"=*Mortgage\")+SUMIFS(C:C,B:B,\">1/1/2013 \",E:E,\"=*Costs\")-(SUMIFS(C:C,B:B,\">1/1/2014 \",E:E,\"=* Mortgage\")+SUMIFS(C:C,B:B,\">1/1/2014 \",E:E,\"=* Costs\")))*-1","v":4818.6000000000004},{"$f":"SUMIFS(C:C,B:B,\">1/1/2013\",E:E,\"*Income\")-SUMIFS(C:C,B:B,\">1/1/2014\",E:E,\"*Income\")","v":325.06999999999971}]
["Checking","2015-02-11",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2015-02-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2015-01-13",895,"ACH Deposit REAL PROPERTY MA","Rental Income",null," "]
["Checking","2015-01-12",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2015-01-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-12-11",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-12-11",856,"ACH Deposit REAL PROPERTY MA","Rental Income",null," "]
["Checking","2014-12-03",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-11-12",-894.12,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-11-12",895,"ACH Deposit REAL PROPERTY MA","Rental Income",null," "]
["Checking","2014-11-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-10-14",-887.71,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-10-14",739.24,"ACH Deposit REAL PROPERTY MA","Rental Income",null," "]
["Checking","2014-10-03",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-09-15",613.13,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-09-11",-887.71,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-09-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-08-14",895,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-08-11",-887.71,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-08-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-07-15",850,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-07-11",-887.71,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-07-03",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-06-12",850,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-06-11",-887.71,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-06-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-05-14",760,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-05-12",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-05-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-04-15",748.83,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-04-11",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-04-03",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-03-17",860,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-03-11",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-03-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs",null," "]
["Checking","2014-02-13",850,"ACH Deposit PAYLEASE.COM","Rental Income",null," "]
["Checking","2014-02-11",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage",null," "]
["Checking","2014-02-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2014-01-15",920.2,"ACH Deposit PAYLEASE.COM","Rental Income"]
["Checking","2014-01-08",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2014-01-06",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2013-12-09",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2013-12-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2013-11-15",325.07,"ACH Deposit PAYLEASE.COM","Rental Income"]
["Checking","2013-11-08",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2013-11-04",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2013-10-08",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2013-10-03",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2013-09-09",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]
["Checking","2013-09-05",-85,"ACH Withdrawal SPRING CREEK CRO","Rental Costs"]
["Checking","2013-08-08",-895.72,"ACH Withdrawal JPMORGAN CHASE","Rental Mortgage"]

{"sheet":"Categorization Rules","index":5,"n_rows":25,"n_cols":3,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Categories","Rules","This structure was inspired by http://vbaprojects.blogspot.com/2014/04/vba-final-project-automated-personal.html"]
["Car","DMV,JIFFY LUBE,AAA,AUTOZONE"]
["Clothes","DRESSING YOUR TRUTH,KID TO KID,SISTER'S CLOSET"]
["Donations","INDIEGOGO,PUBLIC RADIO"]
["Eating Out","BAR-B-Q,BBQ,NOODLES,THAI,OLIVE GAR,PAPA JOHN,DENNY,IHOP"]
["Education","BYU STORE,BRIGHAM YOUNG"]
["Fast Food","JAMBA,TACO,YOGURT,MCDONALD,BURGER,WENDY,ARCTIC,LITTLE CAESARS,EINSTEIN BR,PITA,SUBS,CARL'S"]
["Gas","CHEVRON,MAVERIK"]
["Gifts","FTD"]
["Groceries","SPROUTS,SWEET TOMATOES,CREAMERY,RANCHO,HARMONS,REAL FOOD,VITAMIN,MACEY,COSTCO,GROCERS,MILK,WINCO"]
["Health","HOSPITAL,DDS,SURGICAL,DENTAL,HEALTH"]
["Income","COMPANY,DIVIDEND"]
["Insurance","ALLSTATE,ALL STATE"]
["Internal Transfer","ONLINE DEPOSIT,ONLINE WITHDRAWAL,LOAN ADVANCE, LOAN PAYMENT"]
["Rent","TIE ALPHA"]
["Rental Costs","SPRING CREEK"]
["Rental Income","REAL PROPERTY,PAYLEASE"]
["Rental Mortgage","JPMORGAN"]
["Taxes","IRS, TAX"]
["Tithing"]
["Travel","HOTEL,HILTON,MARRIOTT,DELTA,UNITED,BUDGET"]
["Tupperware","TUPPERWARE"]
["Uncategorized","Check,PAYPAL,AMAZON,GROUPON"]
["Utilities","ELECTRIC,"]
["Megan's Black Market"]

{"sheet":"Loan Sensitivity","index":6,"n_rows":20,"n_cols":18,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Home/Car Loan","Gray are Inputs to manually change",null,"This entire worksheet taken from http://files.gove.net/shares/files/14f/jensen48/Jensen_Final_Project.xlsm"]
[null,null,null,null,"Price",null,null,null,"Down Payment",null,null,null,"Term",null,null,null,"Interest Rate"]
["Inputs"]
["Price",300000,null,"Price","Monthly Payment","Total Interest",null,"Down Payment","Monthly Payment","Total Interest",null,"Term","Monthly Payment","Total Interest",null,"Interest Rate","Monthly Payment","Total Interest"]
["Down Payment",10000,null,150000,751.55,130558.1,null,5000,1583.62,275104.56,null,180,2293.3000000000002,122794.27,null,2.5000000000000001E-2,1145.8499999999999,122506.22]
["Annual Interest Rate",0.05,null,180000,912.6,158534.82999999999,null,6000,1578.26,274172.01,null,360,1556.78,270441.77,null,3.0000000000000002E-2,1222.6500000000001,150154.60999999999]
["Term (Months to Pay) ",360,null,210000,1073.6400000000001,186511.57,null,7000,1572.89,273239.45,null,null,null,null,null,3.5000000000000003E-2,1302.23,178802.65]
["*If Car Loan enter 12, 24, 36, 48, or 60",null,null,240000,1234.69,214488.3,null,8000,1567.52,272306.89,null,null,null,null,null,0.04,1384.5,208421.57]
["*If Home Loan enter 180 or 360",null,null,270000,1395.74,242465.04,null,9000,1562.15,271374.33,null,null,null,null,null,4.5000000000000005E-2,1469.39,238979.46]
[null,null,null,300000,1556.78,270441.77,null,10000,1556.78,270441.77,null,null,null,null,null,0.05,1556.78,270441.77]
["Outputs",null,null,330000,1717.83,298418.51,null,11000,1551.41,269509.21999999997,null,null,null,null,null,5.5E-2,1646.59,302771.71999999997]
["Amount Financed",{"$f":"Price-DownPay","v":290000},null,360000,1878.88,326395.25,null,12000,1546.05,268576.65999999997,null,null,null,null,null,6.0000000000000005E-2,1738.7,335930.75]
["Monthly Payment",{"$f":"PMT(IntRate/12,Term,-Loan)","v":1556.7827067352034},null,390000,2039.92,354371.98,null,13000,1540.68,267644.09999999998,null,null,null,null,null,6.5000000000000002E-2,1833,369879.02]
["Total Interest Paid ",{"$f":"Payment*Term-Loan","v":270441.77442467317},null,420000,2200.9699999999998,382348.72,null,14000,1535.31,266711.53999999998,null,null,null,null,null,7.0000000000000007E-2,1929.38,404575.81]
[null,null,null,450000,2362.02,410325.45,null,15000,1529.94,265778.99,null,null,null,null,null,7.5000000000000011E-2,2027.72,439979.95]
[null,null,null,480000,2523.06,438302.19,null,16000,1524.57,264846.43,null,null,null,null,null,0.08,2127.92,476050.22]
[null,null,null,510000,2684.11,466278.92,null,17000,1519.21,263913.87,null,null,null,null,null,8.5000000000000006E-2,2229.85,512745.68]
[null,null,null,540000,2845.15,494255.66,null,18000,1513.84,262981.31,null,null,null,null,null,9.0000000000000011E-2,2333.41,550026.01]
[null,null,null,570000,3006.2,522232.39,null,19000,1508.47,262048.75,null,null,null,null,null,9.5000000000000001E-2,2438.48,587851.79]
[null,null,null,600000,3167.25,550209.13,null,20000,1503.1,261116.2,null,null,null,null,null,0.1,2544.96,626184.72]

{"sheet":"Amortization Schedule","index":7,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Inputs","Gray are Inputs to manually change",null,"Month ","Payment ","Interest ","Principal","Extra Payment ","Loan",null,"This entire worksheet taken from http://files.gove.net/shares/files/14f/jensen48/Jensen_Final_Project.xlsm"]
["Price",30000,null,null,null,null,null,null,{"$f":"B4","v":25000}]
["Down Payment",5000,null,1,{"$f":"$B$12","v":1080.0680533935877},{"$f":"$B$5/12*I2","v":72.916666666666671},{"$f":"E3-F3","v":1007.151386726921},null,{"$f":"I2-G3-H3","v":23992.84861327308}]
["Total Financed ",{"$f":"B2-B3","v":25000},null,2,{"$f":"$B$12","v":1080.0680533935877},{"$f":"$B$5/12*I3","v":69.97914178871315},{"$f":"E4-F4","v":1010.0889116048745},75,{"$f":"I3-G4-H4","v":22907.759701668205}]
["Annual Interest Rate",3.5000000000000003E-2,null,3,1080.0680533935877,66.814299129865603,1013.253754263722,75,21819.505947404483]
["Term (Months to Pay) ",24,null,4,1080.0680533935877,63.640225679929742,1016.427827713658,75,20728.078119690825]
["*If Car Loan Enter 12, 24, 36, 48, or 60",null,null,5,1080.0680533935877,60.456894515764908,1019.6111588778227,75,19633.466960813003]
["*If Home Loan Enter 180 or 360",null,null,6,1080.0680533935877,57.264278635704592,1022.803774757883,75,18535.663186055121]
[null,null,null,7,1080.0680533935877,54.062350959327439,1026.0057024342602,75,17434.65748362086]
["Outputs",null,null,8,1080.0680533935877,50.851084327227511,1029.2169690663602,75,16330.440514554499]
["Amount Financed",{"$f":"B4","v":25000},null,9,1080.0680533935877,47.630451500783956,1032.4376018928037,75,15223.002912661696]
["Monthly Payment",{"$f":"PMT(B5/12,B6,-B4)","v":1080.0680533935877},null,10,1080.0680533935877,44.400425161929945,1035.6676282316578,75,14112.335284430037]
["Total Interest Paid ",{"$f":"B12*B6-B11","v":921.63328144610568},null,11,1080.0680533935877,41.160977912920941,1038.9070754806667,75,12998.42820894937]
["Total Cost of Loan",{"$f":"B13+B11","v":25921.633281446106},null,12,1080.0680533935877,37.912082276102332,1042.1559711174853,null,11956.272237831885]
[null,null,null,13,1080.0680533935877,34.872460693676331,1045.1955926999112,null,10911.076645131974]
["Extra Payment ",null,null,14,1080.0680533935877,31.823973548301591,1048.244079845286,null,9862.8325652866879]
["Extra Payment Amount",75,null,15,1080.0680533935877,28.766594982086175,1051.3014584115015,null,8811.5311068751871]
["# of Months Remaining on Loan",23,null,16,1080.0680533935877,25.700299061719296,1054.3677543318684,null,7757.163352543319]
["# of Months Extra Payment is Made ",10,null,17,1080.0680533935877,22.625059778251348,1057.4429936153363,null,6699.7203589279825]
[null,null,null,18,1080.0680533935877,19.540851046873282,1060.5272023467144,null,5639.1931565812683]
["New Total Interest Paid ",{"$f":"SUM(F3:F26)","v":882.3892456002277},null,19,1080.0680533935877,16.447646706695366,1063.6204066868922,null,4575.5727498943761]
[null,null,null,20,1080.0680533935877,13.345420520525265,1066.7226328730624,null,3508.850117021314]
["Total Interest Saved ",{"$f":"B13-B21","v":39.244035845877988},null,21,1080.0680533935877,10.234146174645499,1069.8339072189422,null,2439.016209802372]
["# of Months Reduced ",0,null,22,1080.0680533935877,7.1137972785902521,1072.9542561149974,null,1366.0619536873746]
[null,null,null,23,1080.0680533935877,3.9843473649215095,1076.0837060286663,null,289.97824765870837]
[null,null,null,24,290.82401754771291,0.84576988900456607,289.97824765870837,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Payment Savings ",{"$f":"B14-B24","v":25921.633281446106}]
["Total Ineterest Savings ",{"$f":"B16-B25","v":0}]