{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["YTD Budget Summary","Monthly Expenses","1000-Office","2000-Store","3000-Staffing","4000-Equipment","5000-Other"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"YTD Budget Summary","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,0,1,5]]}
[]
["2007 Actual versus Budget YTD"]
[]
["Account Number","Account","YTD Actual","YTD Budget","Remaining Budget $","Remaining Budget %"]
[1000,"Office",{"$f":"'Monthly Expenses'!O5","v":{"v":425,"d":"$425.00"}},{"v":50000,"d":"$50,000.00"},{"$f":"SUM(Budget[[#This Row],[YTD Budget]]-Budget[[#This Row],[YTD Actual]])","v":{"v":49575,"d":"$49,575.00"}},{"$f":"SUM(Budget[[#This Row],[Remaining Budget $]]/Budget[[#This Row],[YTD Budget]])","v":{"v":0.9915,"d":"99.15%"}}]
[2000,"Store",{"$f":"'Monthly Expenses'!O6","v":{"v":905.27,"d":"$905.27"}},{"v":75000,"d":"$75,000.00"},{"$f":"SUM(Budget[[#This Row],[YTD Budget]]-Budget[[#This Row],[YTD Actual]])","v":{"v":74094.73,"d":"$74,094.73"}},{"$f":"SUM(Budget[[#This Row],[Remaining Budget $]]/Budget[[#This Row],[YTD Budget]])","v":{"v":0.9879297333333332,"d":"98.79%"}}]
[3000,"Staffing",{"$f":"'Monthly Expenses'!O7","v":{"v":17500,"d":"$17,500.00"}},{"v":100000,"d":"$100,000.00"},{"$f":"SUM(Budget[[#This Row],[YTD Budget]]-Budget[[#This Row],[YTD Actual]])","v":{"v":82500,"d":"$82,500.00"}},{"$f":"SUM(Budget[[#This Row],[Remaining Budget $]]/Budget[[#This Row],[YTD Budget]])","v":{"v":0.825,"d":"82.50%"}}]
[4000,"Equipment",{"$f":"'Monthly Expenses'!O8","v":{"v":1854,"d":"$1,854.00"}},{"v":25000,"d":"$25,000.00"},{"$f":"SUM(Budget[[#This Row],[YTD Budget]]-Budget[[#This Row],[YTD Actual]])","v":{"v":23146,"d":"$23,146.00"}},{"$f":"SUM(Budget[[#This Row],[Remaining Budget $]]/Budget[[#This Row],[YTD Budget]])","v":{"v":0.92584,"d":"92.58%"}}]
[5000,"Other",{"$f":"'Monthly Expenses'!O9","v":{"v":35.6,"d":"$35.60"}},{"v":50000,"d":"$50,000.00"},{"$f":"SUM(Budget[[#This Row],[YTD Budget]]-Budget[[#This Row],[YTD Actual]])","v":{"v":49964.4,"d":"$49,964.40"}},{"$f":"SUM(Budget[[#This Row],[Remaining Budget $]]/Budget[[#This Row],[YTD Budget]])","v":{"v":0.9992880000000001,"d":"99.93%"}}]
["Total",null,null,{"$f":"SUBTOTAL(109,[YTD Budget])","v":{"v":300000,"d":"$300,000.00"}},{"$f":"SUBTOTAL(109,[Remaining Budget $])","v":{"v":279280.13,"d":"$279,280.13"}},{"$f":"SUM(Budget[[#Totals],[Remaining Budget $]]/Budget[[#Totals],[YTD Budget]])","v":{"v":0.9309337666666667,"d":"93.09%"}}]

{"sheet":"Monthly Expenses","index":1,"n_rows":10,"n_cols":15,"rows_kept":10,"merged":[[1,0,1,14]]}
[]
["2007 Monthly Expenses"]
[]
["Account Number","Account","Jan-07","Feb-07","Mar-07","Apr-07","May-07","Jun-07","Jul-07","Aug-07","Sep-07","Oct-07","Nov-07","Dec-07","2007 Total"]
[1000,"Office",{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jan-07]],\"mmm-yy\")),Office[Amount of Check])","v":{"v":100,"d":"$100.00"}},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Feb-07]],\"mmm-yy\")),Office[Amount of Check])","v":{"v":325,"d":"$325.00"}},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Mar-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Apr-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[May-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jun-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jul-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Aug-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Sep-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Oct-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Nov-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUMIF(Office[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Dec-07]],\"mmm-yy\")),Office[Amount of Check])","v":0},{"$f":"SUM([Jan-07]+[Feb-07]+[Mar-07]+[Apr-07]+[May-07]+[Jun-07]+[Jul-07]+[Aug-07]+[Sep-07]+[Oct-07]+[Nov-07]+[Dec-07])","v":{"v":425,"d":"$425.00"}}]
[2000,"Store",{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jan-07]],\"mmm-yy\")),Store[Amount of Check])","v":{"v":905.27,"d":"$905.27"}},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Feb-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Mar-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Apr-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[May-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jun-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jul-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Aug-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Sep-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Oct-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Nov-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUMIF(Store[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Dec-07]],\"mmm-yy\")),Store[Amount of Check])","v":0},{"$f":"SUM([Jan-07]+[Feb-07]+[Mar-07]+[Apr-07]+[May-07]+[Jun-07]+[Jul-07]+[Aug-07]+[Sep-07]+[Oct-07]+[Nov-07]+[Dec-07])","v":{"v":905.27,"d":"$905.27"}}]
[3000,"Staffing",{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jan-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Feb-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":{"v":17500,"d":"$17,500.00"}},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Mar-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Apr-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[May-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jun-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jul-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Aug-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Sep-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Oct-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Nov-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUMIF(Staffing[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Dec-07]],\"mmm-yy\")),Staffing[Amount of Check])","v":0},{"$f":"SUM([Jan-07]+[Feb-07]+[Mar-07]+[Apr-07]+[May-07]+[Jun-07]+[Jul-07]+[Aug-07]+[Sep-07]+[Oct-07]+[Nov-07]+[Dec-07])","v":{"v":17500,"d":"$17,500.00"}}]
[4000,"Equipment",{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jan-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":{"v":1854,"d":"$1,854.00"}},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Feb-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Mar-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Apr-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[May-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jun-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jul-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Aug-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Sep-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Oct-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Nov-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUMIF(Equipment[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Dec-07]],\"mmm-yy\")),Equipment[Amount of Check])","v":0},{"$f":"SUM([Jan-07]+[Feb-07]+[Mar-07]+[Apr-07]+[May-07]+[Jun-07]+[Jul-07]+[Aug-07]+[Sep-07]+[Oct-07]+[Nov-07]+[Dec-07])","v":{"v":1854,"d":"$1,854.00"}}]
[5000,"Other",{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jan-07]],\"mmm-yy\")),Other[Amount of Check])","v":{"v":35.6,"d":"$35.60"}},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Feb-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Mar-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Apr-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[May-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jun-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Jul-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Aug-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Sep-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Oct-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Nov-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUMIF(Other[Constructed Key Field],\"=\"&(TEXT(Expenses[[#Headers],[Dec-07]],\"mmm-yy\")),Other[Amount of Check])","v":0},{"$f":"SUM([Jan-07]+[Feb-07]+[Mar-07]+[Apr-07]+[May-07]+[Jun-07]+[Jul-07]+[Aug-07]+[Sep-07]+[Oct-07]+[Nov-07]+[Dec-07])","v":{"v":35.6,"d":"$35.60"}}]
["Total",null,{"$f":"SUBTOTAL(109,[Jan-07])","v":{"v":2894.87,"d":"$2,894.87"}},{"$f":"SUBTOTAL(109,[Feb-07])","v":{"v":17825,"d":"$17,825.00"}},{"$f":"SUBTOTAL(109,[Mar-07])","v":0},{"$f":"SUBTOTAL(109,[Apr-07])","v":0},{"$f":"SUBTOTAL(109,[May-07])","v":0},{"$f":"SUBTOTAL(109,[Jun-07])","v":0},{"$f":"SUBTOTAL(109,[Jul-07])","v":0},{"$f":"SUBTOTAL(109,[Aug-07])","v":0},{"$f":"SUBTOTAL(109,[Sep-07])","v":0},{"$f":"SUBTOTAL(109,[Oct-07])","v":0},{"$f":"SUBTOTAL(109,[Nov-07])","v":0},{"$f":"SUBTOTAL(109,[Dec-07])","v":0},{"$f":"SUBTOTAL(109,[2007 Total])","v":{"v":20719.87,"d":"$20,719.87"}}]

{"sheet":"1000-Office","index":2,"n_rows":6,"n_cols":10,"rows_kept":6}
["G/L - Expense","Invoice Date","Invoice #","Requested by","Amount of Check","Name of Payee","Check Use","Method of Distribution","File Date","Constructed Key Field"]
[1000,{"v":39097,"d":"3909700.00%"},1,"David Daniels",{"v":100,"d":"$100.00"},"Consolidated Messenger ","Blank CDs","Credit",{"v":39102,"d":"3910200.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-07"}]
[1000,"2007-02-07",5,"David Daniels",{"v":50,"d":"$50.00"},"Consolidated Messenger ","Printer ink","Credit",{"v":39123,"d":"3912300.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Feb-07"}]
[1000,"2007-02-15",10,"David Daniels",{"v":275,"d":"$275.00"},"Acme","General office","Credit",{"v":39123,"d":"3912300.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Feb-07"}]
[1000,{"$nulls":8},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-00"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Amount of Check])","v":{"v":425,"d":"$425.00"}}]

{"sheet":"2000-Store","index":3,"n_rows":5,"n_cols":10,"rows_kept":5}
["G/L - Expense","Invoice Date","Invoice #","Requested by","Amount of Check","Name of Payee","Check Use","Method of Distribution","File Date","Constructed Key Field"]
[2000,{"v":39099,"d":"3909900.00%"},2,"Marc Faeber",{"v":550,"d":"$550.00"},"Fabrikam, Inc. ","Replace store window","Credit",{"v":39102,"d":"3910200.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-07"}]
[2000,"2007-01-19",3,"Marc Faeber",{"v":355.27,"d":"$355.27"},"A. Datum Corporation ","New cash register","Credit",{"v":39102,"d":"3910200.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-07"}]
[2000,{"$nulls":8},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-00"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Amount of Check])","v":{"v":905.27,"d":"$905.27"}}]

{"sheet":"3000-Staffing","index":4,"n_rows":5,"n_cols":10,"rows_kept":5}
["G/L - Expense","Invoice Date","Invoice #","Requested by","Amount of Check","Name of Payee","Check Use","Method of Distribution","File Date","Constructed Key Field"]
[3000,{"v":39123,"d":"3912300.00%"},6,"Robert O'Hara",{"v":2500,"d":"$2,500.00"},"Graphic Design Institute ","contract designer","Check",{"v":39133,"d":"3913300.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Feb-07"}]
[3000,"2007-02-15",11,"Sandeep Kaliyath",{"v":15000,"d":"$15,000.00"},"Adventure Works","contract writer","Check",{"v":39133,"d":"3913300.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Feb-07"}]
[3000,{"$nulls":8},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-00"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Amount of Check])","v":{"v":17500,"d":"$17,500.00"}}]

{"sheet":"4000-Equipment","index":5,"n_rows":4,"n_cols":10,"rows_kept":4}
["G/L - Expense","Invoice Date","Invoice #","Requested by","Amount of Check","Name of Payee","Check Use","Method of Distribution","File Date","Constructed Key Field"]
[4000,{"v":39107,"d":"3910700.00%"},5,"Robert Walters",{"v":1854,"d":"$1,854.00"},"Trey Research ","New laptop","Credit",{"v":39107,"d":"3910700.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-07"}]
[4000,{"$nulls":8},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-00"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Amount of Check])","v":{"v":1854,"d":"$1,854.00"}}]

{"sheet":"5000-Other","index":6,"n_rows":4,"n_cols":10,"rows_kept":4}
["G/L - Expense","Invoice Date","Invoice #","Requested by","Amount of Check","Name of Payee","Check Use","Method of Distribution","File Date","Constructed Key Field"]
[5000,{"v":39105,"d":"3910500.00%"},4,"Bob Gage",{"v":35.6,"d":"$35.60"},"Bob Gage","Cab fare","Check",{"v":39105,"d":"3910500.00%"},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-07"}]
[5000,{"$nulls":8},{"$f":"TEXT([Invoice Date],\"mmm-yy\")","v":"Jan-00"}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Amount of Check])","v":{"v":35.6,"d":"$35.60"}}]