{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Summary","Filters","Calculations","Opptys","User"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":35,"comments":1,"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":"Summary","index":0,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":false,"merged":[[13,4,13,6],[8,4,8,6],[9,4,9,6],[10,4,10,6],[11,4,11,6],[12,4,12,6],[20,4,20,6],[21,4,21,6],[22,4,22,6],[23,4,23,6],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6],[19,4,19,6],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[27,2,27,3],[27,4,27,6],[28,2,28,3],[28,4,28,6],[24,2,24,3],[24,4,24,6],[25,2,25,3],[25,4,25,6],[26,2,26,3],[26,4,26,6]]}
["Department","(All)",{"$f":"F1Val=\"(All)\"","v":true},null,null,null,null,null,null,null,null,"Updated 11/13/11 9:50 AM"]
["Opportunity Owner","(All)",{"$f":"F2Val=\"(All)\"","v":true}]
["Forecast Category","(All)",{"$f":"F3Val=\"(All)\"","v":true}]
[]
[null,"Sales Stage:","Closed Won","Negotiation/ Review","Proposal/ Price Quote","Needs Analysis","Closed Lost"]
[null,"Total Amount:",{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=C$5),Amount)","v":0},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=D$5),Amount)","v":0},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=E$5),Amount)","v":8128},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=F$5),Amount)","v":0},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=G$5),Amount)","v":0}]
[null,"Expected Amount:",{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=C$5),Amount,Probability)/100","v":0},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=D$5),Amount,Probability)/100","v":0},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=E$5),Amount,Probability)/100","v":4064},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=F$5),Amount,Probability)/100","v":0},{"$f":"SUMPRODUCT(-(Selected=TRUE),-(Stage=G$5),Amount,Probability)/100","v":0}]
[]
[null,null,"Account",null,"Opportunity",null,null,"Forecast Category","Amount","Probability","Close Date","Last Update","Next Steps",null,null,"row","Name","ID"]
[null,1,{"$f":"IF(ISNA(P10),\"\",INDEX(Opptys!E:E,P10))","v":"Sample Account"},null,{"$f":"IF(ISNA(P10),\"\",HYPERLINK(SFlink&R10,Q10))","v":"Sample Opportunity"},null,null,{"$f":"IF(ISNA(P10),\"\",INDEX(Category,P10))","v":"Best Case"},{"$f":"IF(ISNA(P10),\"\",INDEX(Amount,P10))","v":8128},{"$f":"IF(ISNA(P10),\"\",INDEX(Probability,P10))","v":50},{"$f":"IF(ISNA(P10),\"\",INDEX(Opptys!I:I,P10))","v":"2011-08-23"},{"$f":"IF(ISNA(P10),\"\",INDEX(Opptys!M:M,P10))","v":"2011-09-20"},{"$f":"IF(ISNA(P10),\"\",IF(LEN(INDEX(NextStep,P10))=0,\"\",INDEX(NextStep,P10)))","v":"Illustrative Next Steps"},null,null,{"$f":"MATCH(B10,Opptys!B:B,0)","v":2},{"$f":"INDEX(Opptys!G:G,P10)","v":"Sample Opportunity"},{"$f":"INDEX(Opptys!H:H,P10)","v":"0067000000BYgCN"}]
[null,{"$f":"B10+1","v":2},{"$f":"IF(ISNA(P11),\"\",INDEX(Opptys!E:E,P11))","v":""},null,"",null,null,{"$f":"IF(ISNA(P11),\"\",INDEX(Category,P11))","v":""},{"$f":"IF(ISNA(P11),\"\",INDEX(Amount,P11))","v":""},{"$f":"IF(ISNA(P11),\"\",INDEX(Probability,P11))","v":""},{"$f":"IF(ISNA(P11),\"\",INDEX(Opptys!I:I,P11))","v":""},{"$f":"IF(ISNA(P11),\"\",INDEX(Opptys!M:M,P11))","v":""},{"$f":"IF(ISNA(P11),\"\",IF(LEN(INDEX(NextStep,P11))=0,\"\",INDEX(NextStep,P11)))","v":""},null,null,{"$f":"MATCH(B11,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P11)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P11)","v":{"$error":"#N/A"}}]
[null,{"$f":"B11+1","v":3},{"$f":"IF(ISNA(P12),\"\",INDEX(Opptys!E:E,P12))","v":""},null,"",null,null,{"$f":"IF(ISNA(P12),\"\",INDEX(Category,P12))","v":""},{"$f":"IF(ISNA(P12),\"\",INDEX(Amount,P12))","v":""},{"$f":"IF(ISNA(P12),\"\",INDEX(Probability,P12))","v":""},{"$f":"IF(ISNA(P12),\"\",INDEX(Opptys!I:I,P12))","v":""},{"$f":"IF(ISNA(P12),\"\",INDEX(Opptys!M:M,P12))","v":""},{"$f":"IF(ISNA(P12),\"\",IF(LEN(INDEX(NextStep,P12))=0,\"\",INDEX(NextStep,P12)))","v":""},null,null,{"$f":"MATCH(B12,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P12)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P12)","v":{"$error":"#N/A"}}]
[null,4,{"$f":"IF(ISNA(P13),\"\",INDEX(Opptys!E:E,P13))","v":""},null,"",null,null,{"$f":"IF(ISNA(P13),\"\",INDEX(Category,P13))","v":""},{"$f":"IF(ISNA(P13),\"\",INDEX(Amount,P13))","v":""},{"$f":"IF(ISNA(P13),\"\",INDEX(Probability,P13))","v":""},{"$f":"IF(ISNA(P13),\"\",INDEX(Opptys!I:I,P13))","v":""},{"$f":"IF(ISNA(P13),\"\",INDEX(Opptys!M:M,P13))","v":""},{"$f":"IF(ISNA(P13),\"\",IF(LEN(INDEX(NextStep,P13))=0,\"\",INDEX(NextStep,P13)))","v":""},null,null,{"$f":"MATCH(B13,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P13)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P13)","v":{"$error":"#N/A"}}]
[null,5,{"$f":"IF(ISNA(P14),\"\",INDEX(Opptys!E:E,P14))","v":""},null,"",null,null,{"$f":"IF(ISNA(P14),\"\",INDEX(Category,P14))","v":""},{"$f":"IF(ISNA(P14),\"\",INDEX(Amount,P14))","v":""},{"$f":"IF(ISNA(P14),\"\",INDEX(Probability,P14))","v":""},{"$f":"IF(ISNA(P14),\"\",INDEX(Opptys!I:I,P14))","v":""},{"$f":"IF(ISNA(P14),\"\",INDEX(Opptys!M:M,P14))","v":""},{"$f":"IF(ISNA(P14),\"\",IF(LEN(INDEX(NextStep,P14))=0,\"\",INDEX(NextStep,P14)))","v":""},null,null,{"$f":"MATCH(B14,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P14)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P14)","v":{"$error":"#N/A"}}]
[null,6,{"$f":"IF(ISNA(P15),\"\",INDEX(Opptys!E:E,P15))","v":""},null,"",null,null,{"$f":"IF(ISNA(P15),\"\",INDEX(Category,P15))","v":""},{"$f":"IF(ISNA(P15),\"\",INDEX(Amount,P15))","v":""},{"$f":"IF(ISNA(P15),\"\",INDEX(Probability,P15))","v":""},{"$f":"IF(ISNA(P15),\"\",INDEX(Opptys!I:I,P15))","v":""},{"$f":"IF(ISNA(P15),\"\",INDEX(Opptys!M:M,P15))","v":""},{"$f":"IF(ISNA(P15),\"\",IF(LEN(INDEX(NextStep,P15))=0,\"\",INDEX(NextStep,P15)))","v":""},null,null,{"$f":"MATCH(B15,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P15)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P15)","v":{"$error":"#N/A"}}]
[null,7,{"$f":"IF(ISNA(P16),\"\",INDEX(Opptys!E:E,P16))","v":""},null,"",null,null,{"$f":"IF(ISNA(P16),\"\",INDEX(Category,P16))","v":""},{"$f":"IF(ISNA(P16),\"\",INDEX(Amount,P16))","v":""},{"$f":"IF(ISNA(P16),\"\",INDEX(Probability,P16))","v":""},{"$f":"IF(ISNA(P16),\"\",INDEX(Opptys!I:I,P16))","v":""},{"$f":"IF(ISNA(P16),\"\",INDEX(Opptys!M:M,P16))","v":""},{"$f":"IF(ISNA(P16),\"\",IF(LEN(INDEX(NextStep,P16))=0,\"\",INDEX(NextStep,P16)))","v":""},null,null,{"$f":"MATCH(B16,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P16)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P16)","v":{"$error":"#N/A"}}]
[null,8,{"$f":"IF(ISNA(P17),\"\",INDEX(Opptys!E:E,P17))","v":""},null,"",null,null,{"$f":"IF(ISNA(P17),\"\",INDEX(Category,P17))","v":""},{"$f":"IF(ISNA(P17),\"\",INDEX(Amount,P17))","v":""},{"$f":"IF(ISNA(P17),\"\",INDEX(Probability,P17))","v":""},{"$f":"IF(ISNA(P17),\"\",INDEX(Opptys!I:I,P17))","v":""},{"$f":"IF(ISNA(P17),\"\",INDEX(Opptys!M:M,P17))","v":""},{"$f":"IF(ISNA(P17),\"\",IF(LEN(INDEX(NextStep,P17))=0,\"\",INDEX(NextStep,P17)))","v":""},null,null,{"$f":"MATCH(B17,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P17)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P17)","v":{"$error":"#N/A"}}]
[null,9,{"$f":"IF(ISNA(P18),\"\",INDEX(Opptys!E:E,P18))","v":""},null,"",null,null,{"$f":"IF(ISNA(P18),\"\",INDEX(Category,P18))","v":""},{"$f":"IF(ISNA(P18),\"\",INDEX(Amount,P18))","v":""},{"$f":"IF(ISNA(P18),\"\",INDEX(Probability,P18))","v":""},{"$f":"IF(ISNA(P18),\"\",INDEX(Opptys!I:I,P18))","v":""},{"$f":"IF(ISNA(P18),\"\",INDEX(Opptys!M:M,P18))","v":""},{"$f":"IF(ISNA(P18),\"\",IF(LEN(INDEX(NextStep,P18))=0,\"\",INDEX(NextStep,P18)))","v":""},null,null,{"$f":"MATCH(B18,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P18)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P18)","v":{"$error":"#N/A"}}]
[null,10,{"$f":"IF(ISNA(P19),\"\",INDEX(Opptys!E:E,P19))","v":""},null,"",null,null,{"$f":"IF(ISNA(P19),\"\",INDEX(Category,P19))","v":""},{"$f":"IF(ISNA(P19),\"\",INDEX(Amount,P19))","v":""},{"$f":"IF(ISNA(P19),\"\",INDEX(Probability,P19))","v":""},{"$f":"IF(ISNA(P19),\"\",INDEX(Opptys!I:I,P19))","v":""},{"$f":"IF(ISNA(P19),\"\",INDEX(Opptys!M:M,P19))","v":""},{"$f":"IF(ISNA(P19),\"\",IF(LEN(INDEX(NextStep,P19))=0,\"\",INDEX(NextStep,P19)))","v":""},null,null,{"$f":"MATCH(B19,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P19)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P19)","v":{"$error":"#N/A"}}]
[null,11,{"$f":"IF(ISNA(P20),\"\",INDEX(Opptys!E:E,P20))","v":""},null,"",null,null,{"$f":"IF(ISNA(P20),\"\",INDEX(Category,P20))","v":""},{"$f":"IF(ISNA(P20),\"\",INDEX(Amount,P20))","v":""},{"$f":"IF(ISNA(P20),\"\",INDEX(Probability,P20))","v":""},{"$f":"IF(ISNA(P20),\"\",INDEX(Opptys!I:I,P20))","v":""},{"$f":"IF(ISNA(P20),\"\",INDEX(Opptys!M:M,P20))","v":""},{"$f":"IF(ISNA(P20),\"\",IF(LEN(INDEX(NextStep,P20))=0,\"\",INDEX(NextStep,P20)))","v":""},null,null,{"$f":"MATCH(B20,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P20)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P20)","v":{"$error":"#N/A"}}]
[null,12,{"$f":"IF(ISNA(P21),\"\",INDEX(Opptys!E:E,P21))","v":""},null,"",null,null,{"$f":"IF(ISNA(P21),\"\",INDEX(Category,P21))","v":""},{"$f":"IF(ISNA(P21),\"\",INDEX(Amount,P21))","v":""},{"$f":"IF(ISNA(P21),\"\",INDEX(Probability,P21))","v":""},{"$f":"IF(ISNA(P21),\"\",INDEX(Opptys!I:I,P21))","v":""},{"$f":"IF(ISNA(P21),\"\",INDEX(Opptys!M:M,P21))","v":""},{"$f":"IF(ISNA(P21),\"\",IF(LEN(INDEX(NextStep,P21))=0,\"\",INDEX(NextStep,P21)))","v":""},null,null,{"$f":"MATCH(B21,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P21)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P21)","v":{"$error":"#N/A"}}]
[null,13,{"$f":"IF(ISNA(P22),\"\",INDEX(Opptys!E:E,P22))","v":""},null,"",null,null,{"$f":"IF(ISNA(P22),\"\",INDEX(Category,P22))","v":""},{"$f":"IF(ISNA(P22),\"\",INDEX(Amount,P22))","v":""},{"$f":"IF(ISNA(P22),\"\",INDEX(Probability,P22))","v":""},{"$f":"IF(ISNA(P22),\"\",INDEX(Opptys!I:I,P22))","v":""},{"$f":"IF(ISNA(P22),\"\",INDEX(Opptys!M:M,P22))","v":""},{"$f":"IF(ISNA(P22),\"\",IF(LEN(INDEX(NextStep,P22))=0,\"\",INDEX(NextStep,P22)))","v":""},null,null,{"$f":"MATCH(B22,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P22)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P22)","v":{"$error":"#N/A"}}]
[null,14,{"$f":"IF(ISNA(P23),\"\",INDEX(Opptys!E:E,P23))","v":""},null,"",null,null,{"$f":"IF(ISNA(P23),\"\",INDEX(Category,P23))","v":""},{"$f":"IF(ISNA(P23),\"\",INDEX(Amount,P23))","v":""},{"$f":"IF(ISNA(P23),\"\",INDEX(Probability,P23))","v":""},{"$f":"IF(ISNA(P23),\"\",INDEX(Opptys!I:I,P23))","v":""},{"$f":"IF(ISNA(P23),\"\",INDEX(Opptys!M:M,P23))","v":""},{"$f":"IF(ISNA(P23),\"\",IF(LEN(INDEX(NextStep,P23))=0,\"\",INDEX(NextStep,P23)))","v":""},null,null,{"$f":"MATCH(B23,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P23)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P23)","v":{"$error":"#N/A"}}]
[null,15,{"$f":"IF(ISNA(P24),\"\",INDEX(Opptys!E:E,P24))","v":""},null,"",null,null,{"$f":"IF(ISNA(P24),\"\",INDEX(Category,P24))","v":""},{"$f":"IF(ISNA(P24),\"\",INDEX(Amount,P24))","v":""},{"$f":"IF(ISNA(P24),\"\",INDEX(Probability,P24))","v":""},{"$f":"IF(ISNA(P24),\"\",INDEX(Opptys!I:I,P24))","v":""},{"$f":"IF(ISNA(P24),\"\",INDEX(Opptys!M:M,P24))","v":""},{"$f":"IF(ISNA(P24),\"\",IF(LEN(INDEX(NextStep,P24))=0,\"\",INDEX(NextStep,P24)))","v":""},null,null,{"$f":"MATCH(B24,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P24)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P24)","v":{"$error":"#N/A"}}]
[null,16,{"$f":"IF(ISNA(P25),\"\",INDEX(Opptys!E:E,P25))","v":""},null,"",null,null,{"$f":"IF(ISNA(P25),\"\",INDEX(Category,P25))","v":""},{"$f":"IF(ISNA(P25),\"\",INDEX(Amount,P25))","v":""},{"$f":"IF(ISNA(P25),\"\",INDEX(Probability,P25))","v":""},{"$f":"IF(ISNA(P25),\"\",INDEX(Opptys!I:I,P25))","v":""},{"$f":"IF(ISNA(P25),\"\",INDEX(Opptys!M:M,P25))","v":""},{"$f":"IF(ISNA(P25),\"\",IF(LEN(INDEX(NextStep,P25))=0,\"\",INDEX(NextStep,P25)))","v":""},null,null,{"$f":"MATCH(B25,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P25)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P25)","v":{"$error":"#N/A"}}]
[null,17,{"$f":"IF(ISNA(P26),\"\",INDEX(Opptys!E:E,P26))","v":""},null,"",null,null,{"$f":"IF(ISNA(P26),\"\",INDEX(Category,P26))","v":""},{"$f":"IF(ISNA(P26),\"\",INDEX(Amount,P26))","v":""},{"$f":"IF(ISNA(P26),\"\",INDEX(Probability,P26))","v":""},{"$f":"IF(ISNA(P26),\"\",INDEX(Opptys!I:I,P26))","v":""},{"$f":"IF(ISNA(P26),\"\",INDEX(Opptys!M:M,P26))","v":""},{"$f":"IF(ISNA(P26),\"\",IF(LEN(INDEX(NextStep,P26))=0,\"\",INDEX(NextStep,P26)))","v":""},null,null,{"$f":"MATCH(B26,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P26)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P26)","v":{"$error":"#N/A"}}]
[null,18,{"$f":"IF(ISNA(P27),\"\",INDEX(Opptys!E:E,P27))","v":""},null,"",null,null,{"$f":"IF(ISNA(P27),\"\",INDEX(Category,P27))","v":""},{"$f":"IF(ISNA(P27),\"\",INDEX(Amount,P27))","v":""},{"$f":"IF(ISNA(P27),\"\",INDEX(Probability,P27))","v":""},{"$f":"IF(ISNA(P27),\"\",INDEX(Opptys!I:I,P27))","v":""},{"$f":"IF(ISNA(P27),\"\",INDEX(Opptys!M:M,P27))","v":""},{"$f":"IF(ISNA(P27),\"\",IF(LEN(INDEX(NextStep,P27))=0,\"\",INDEX(NextStep,P27)))","v":""},null,null,{"$f":"MATCH(B27,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P27)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P27)","v":{"$error":"#N/A"}}]
[null,19,{"$f":"IF(ISNA(P28),\"\",INDEX(Opptys!E:E,P28))","v":""},null,"",null,null,{"$f":"IF(ISNA(P28),\"\",INDEX(Category,P28))","v":""},{"$f":"IF(ISNA(P28),\"\",INDEX(Amount,P28))","v":""},{"$f":"IF(ISNA(P28),\"\",INDEX(Probability,P28))","v":""},{"$f":"IF(ISNA(P28),\"\",INDEX(Opptys!I:I,P28))","v":""},{"$f":"IF(ISNA(P28),\"\",INDEX(Opptys!M:M,P28))","v":""},{"$f":"IF(ISNA(P28),\"\",IF(LEN(INDEX(NextStep,P28))=0,\"\",INDEX(NextStep,P28)))","v":""},null,null,{"$f":"MATCH(B28,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P28)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P28)","v":{"$error":"#N/A"}}]
[null,20,{"$f":"IF(ISNA(P29),\"\",INDEX(Opptys!E:E,P29))","v":""},null,"",null,null,{"$f":"IF(ISNA(P29),\"\",INDEX(Category,P29))","v":""},{"$f":"IF(ISNA(P29),\"\",INDEX(Amount,P29))","v":""},{"$f":"IF(ISNA(P29),\"\",INDEX(Probability,P29))","v":""},{"$f":"IF(ISNA(P29),\"\",INDEX(Opptys!I:I,P29))","v":""},{"$f":"IF(ISNA(P29),\"\",INDEX(Opptys!M:M,P29))","v":""},{"$f":"IF(ISNA(P29),\"\",IF(LEN(INDEX(NextStep,P29))=0,\"\",INDEX(NextStep,P29)))","v":""},null,null,{"$f":"MATCH(B29,Opptys!B:B,0)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!G:G,P29)","v":{"$error":"#N/A"}},{"$f":"INDEX(Opptys!H:H,P29)","v":{"$error":"#N/A"}}]

{"sheet":"Filters","index":1,"n_rows":7,"n_cols":20,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Department","Owners","First Owner Row","Owner Count",null,"Group By:",{"$f":"IF(AND(F1All,$A$4<>\"\"),\"Department\",\"Opportunity Owner\")","v":"Opportunity Owner"},{"$f":"IF(Q1=\"Department\",1,2)","v":2},"Chart Final Row:",{"$f":"IF($Q$1=\"Department\",COUNTA(F1List),COUNTA(F2List))+1","v":3}]
["(All)","(All)","(All)",null,null,3,4,10,12,null,"Sales","Bruce Peltzer",{"$f":"MATCH(F1Val,K:K,0)","v":{"$error":"#N/A"}},{"$f":"COUNTIF(K:K,F1Val)","v":0},null,{"$f":"Q1","v":"Opportunity Owner"},"Closed","Commit","Best Case","Pipeline"]
["Sales","Sales Rep 1","Closed",null,null,"Sales","Sales Rep 1","Best Case","Closed Lost",null,null,null,null,null,null,"Sales Rep 1",{"$f":"IF($R$1=1,SUMPRODUCT(Amount,-(Category=Q$2),-(Department=$P3)),SUMPRODUCT(Amount,-(Category=Q$2),-(Owner=$P3)))","v":0},{"$f":"IF($R$1=1,SUMPRODUCT(Amount,-(Category=R$2),-(Department=$P3)),SUMPRODUCT(Amount,-(Category=R$2),-(Owner=$P3)))","v":0},{"$f":"IF($R$1=1,SUMPRODUCT(Amount,-(Category=S$2),-(Department=$P3)),SUMPRODUCT(Amount,-(Category=S$2),-(Owner=$P3)))","v":8128},{"$f":"IF($R$1=1,SUMPRODUCT(Amount,-(Category=T$2),-(Department=$P3)),SUMPRODUCT(Amount,-(Category=T$2),-(Owner=$P3)))","v":0}]
[null,null,"Commit",null,null,null,null,"Closed","Closed Won"]
[null,null,"Best Case",null,null,null,null,"Commit","Needs Analysis"]
[null,null,"Pipeline",null,null,null,null,"Omitted","Negotiation/ Review"]
[null,null,"Omitted",null,null,null,null,"Pipeline","Proposal/ Price Quote"]

{"sheet":"Calculations","index":2,"n_rows":1,"n_cols":12,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,null,0,null,null,null,null,null,null,null,"Departments","Owners"]

{"sheet":"Opptys","index":3,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Selected","Rank","Opportunity Owner: Department","Opportunity Owner","Account Name","Account ID","Opportunity Name","Opportunity ID","Close Date","Forecast Category","Probability (%)","Stage","Last Modified Date","Amount","Next Step"]
[{"$f":"AND(IF(F1All,1,F1Val=C2),IF(F2All,1,F2Val=D2),IF(F3All,1,F3Val=J2))","v":true},{"$f":"IF($A2,1,0)","v":1},"Sales","Sales Rep 1","Sample Account","0017000000O9pgY","Sample Opportunity","0067000000BYgCN","2011-08-23","Best Case",50,"Proposal/ Price Quote","2011-09-20",8128,"Illustrative Next Steps"]
[]
[null,null,"Opportunity Report"]
[null,null,"Copyright (c) 2000-2011 salesforce.com, inc. All rights reserved."]
[null,null,"Confidential Information - Do Not Distribute"]
[null,null,"Generated By: Bruce Peltzer 7/26/2011 11:19 PM"]
[null,null,"Stack Ranking, LLC"]

{"sheet":"User","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Username"]
["salesrep1@stackranking.com"]
[]
["User List Report"]
["Copyright (c) 2000-2011 salesforce.com, inc. All rights reserved."]
["Confidential Information - Do Not Distribute"]
["Generated By: Bruce Peltzer 3/21/2011 11:13 PM"]
["Stack Ranking, LLC"]