{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["October2012"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":8,"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":"October2012","index":0,"n_rows":137,"n_cols":27,"rows_kept":137,"cut":false,"hidden":false,"merged":[[3,11,3,12],[45,4,46,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"You can edit only these cells",null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AA2),MONTH(AA2)+1,DAY(AA2))","v":"2012-11-01"}]
[null,"Revenue Tracker",null,null,null,null,null,{"$f":"DATE(YEAR(AA2),MONTH(AA2),1)","v":"2012-10-01"},null,null,null,{"$f":"DATE(YEAR(AA2),MONTH(AA2),1)","v":"2012-10-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2012-10-01"]
[null,null,null,null,"Revenue",null,null,null,null,null,null,null,null,null,"Dashboard",null,null,null,null,null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AA1),MONTH(AA1)+1,DAY(AA1))","v":"2012-12-01"}]
[null,null,null,null,"Customer /\nClient","Forecast","Actual Revenue","Paid","Due","% Variance","Customer Type","Comments",null,null,"Revenue",{"$f":"G25","v":0}]
[null,null,{"$f":"IF(I5<>\"\",1,\"\")","v":""},{"$f":"IF(I5<>\"\",COUNTIF($C$5:C5,\"1\"),\"\")","v":""},"Client1",null,null,null,{"$f":"IF(G5-H5=0,\"\",G5-H5)","v":""},{"$f":"IF(ISERROR((G5-F5)/F5),\"\",(G5-F5)/F5)","v":""},null,null,null,null,"Paid",{"$f":"H25","v":0},null,null,null,null,null,null,null,null,null,null,"https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=7KRFM7MQCVYZC"]
[null,null,{"$f":"IF(I6<>\"\",1,\"\")","v":""},{"$f":"IF(I6<>\"\",COUNTIF($C$5:C6,\"1\"),\"\")","v":""},"Client2",null,null,null,{"$f":"IF(G6-H6=0,\"\",G6-H6)","v":""},{"$f":"IF(ISERROR((G6-F6)/F6),\"\",(G6-F6)/F6)","v":""},null,null,null,null,"Due",{"$f":"I25","v":0}]
[null,null,"",{"$f":"IF(I7<>\"\",COUNTIF($C$5:C7,\"1\"),\"\")","v":""},"Client3",null,null,null,"","",null,null,null,null,"Previous Dues",{"$f":"G44","v":0}]
[null,null,"",{"$f":"IF(I8<>\"\",COUNTIF($C$5:C8,\"1\"),\"\")","v":""},"Client4",null,null,null,"","",null,null,null,null,"Cash position"]
[null,null,"",{"$f":"IF(I9<>\"\",COUNTIF($C$5:C9,\"1\"),\"\")","v":""},"Client5",null,null,null,"","",null,null,null,null,"Bank 1"]
[null,null,"",{"$f":"IF(I10<>\"\",COUNTIF($C$5:C10,\"1\"),\"\")","v":""},"Client6",null,null,null,"","",null,null,null,null,"Bank 2"]
[null,null,"",{"$f":"IF(I11<>\"\",COUNTIF($C$5:C11,\"1\"),\"\")","v":""},"Client7",null,null,null,"","",null,null,null,null,"Paypal"]
[null,null,"",{"$f":"IF(I12<>\"\",COUNTIF($C$5:C12,\"1\"),\"\")","v":""},"Client8",null,null,null,"","",null,null,null,null,"FD"]
[null,null,"",{"$f":"IF(I13<>\"\",COUNTIF($C$5:C13,\"1\"),\"\")","v":""},"Client9",null,null,null,"","",null,null,null,null,"Bank Balance",null,{"$f":"SUM(P9:P12)","v":0}]
[null,null,"",{"$f":"IF(I14<>\"\",COUNTIF($C$5:C14,\"1\"),\"\")","v":""},"Client10",null,null,null,"","",null,null,null,null,"Receivables",null,{"$f":"K44","v":0}]
[null,null,"",{"$f":"IF(I15<>\"\",COUNTIF($C$5:C15,\"1\"),\"\")","v":""},null,null,null,null,"","",null,null,null,null,"Potential balance",null,{"$f":"SUM(Q13:Q14)","v":0}]
[null,null,"",{"$f":"IF(I16<>\"\",COUNTIF($C$5:C16,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I17<>\"\",COUNTIF($C$5:C17,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I18<>\"\",COUNTIF($C$5:C18,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I19<>\"\",COUNTIF($C$5:C19,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I20<>\"\",COUNTIF($C$5:C20,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I21<>\"\",COUNTIF($C$5:C21,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I22<>\"\",COUNTIF($C$5:C22,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I23<>\"\",COUNTIF($C$5:C23,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,"",{"$f":"IF(I24<>\"\",COUNTIF($C$5:C24,\"1\"),\"\")","v":""},null,null,null,null,"",""]
[null,null,null,null,"Total",{"$f":"SUM(F5:F24)","v":0},{"$f":"SUM(G5:G24)","v":0},{"$f":"SUM(H5:H24)","v":0},{"$f":"SUM(I5:I24)","v":0},{"$f":"IF(ISERROR(I25/F25),\"\",(I25/F25))","v":""}]
[]
[null,null,null,null,"Previous Receivables",null,null,null,"Current Receivables"]
[null,null,null,null,"Customer / Client","Paid/Unpaid","Amount",null,"Customer/Client","Paid/Unpaid","Amount"]
[null,null,null,null,"Previous Receivables","Unpaid",0,null,"Previous Receivables","Unpaid",{"$f":"G44","v":0}]
[null,null,1,null,"","","",null,{"$f":"IFERROR(VLOOKUP(C30,$D$5:$E$24,2,FALSE),\"\")","v":""},{"$f":"IF(I30=\"\",\"\",\"Unpaid\")","v":""},{"$f":"IFERROR(VLOOKUP(C30,$D$5:$I$24,6,FALSE),\"\")","v":""}]
[null,null,2,null,"","","",null,{"$f":"IFERROR(VLOOKUP(C31,$D$5:$E$24,2,FALSE),\"\")","v":""},{"$f":"IF(I31=\"\",\"\",\"Unpaid\")","v":""},""]
[null,null,3,null,"","","",null,"","",""]
[null,null,4,null,"","","",null,"","",""]
[null,null,5,null,"","","",null,"","",""]
[null,null,6,null,"","","",null,"","",""]
[null,null,7,null,"","","",null,"","",""]
[null,null,8,null,"","","",null,"","",""]
[null,null,9,null,"","","",null,"","",""]
[null,null,10,null,"","","",null,"","",""]
[null,null,11,null,"","","",null,"","",""]
[null,null,12,null,"","","",null,"","",""]
[null,null,13,null,"","","",null,"","",""]
[null,null,14,null,"","","",null,"","",""]
[null,null,null,null,"Total",null,{"$f":"SUMIF(F29:F43,\"Unpaid\",G29:G43)","v":0},null,"Total",null,{"$f":"SUMIF(J29:J43,\"Unpaid\",K29:K43)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=7KRFM7MQCVYZC"]