{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"Sheet1","index":0,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["20XX Premium Goal",600000,null,null,null,"Key"]
["YTD",45000,null,null,null,"1 = \"Top 20\"",null,null,"E = Excellent (3-6 mos)"]
["20XX Pipeline",{"$f":"SUM(C18:K18)+SUM(C22:K22)+SUM(C26:K26)+SUM(C30:K30)+SUM(C34:K34)+SUM(C38:K38)+SUM(C42:K42)+SUM(C46:K46)+SUM(C50:K50)+SUM(C54:K54)+SUM(C58:K58)+SUM(C62:K62)+SUM(C66:K66)+SUM(C70:K70)","v":1270000},"Formula",null,null,"2 = Referrals",null,null,"G = Good (6-12 mos)"]
["Reflecting probability",{"$f":"SUMPRODUCT(C18:K18,C19:K19)+SUMPRODUCT(C22:K22,C23:K23)+SUMPRODUCT(C26:K26,C27:K27)+SUMPRODUCT(C30:K30,C31:K31)+SUMPRODUCT(C34:K34,C35:K35)+SUMPRODUCT(C38:K38,C39:K39)+SUMPRODUCT(C42:K42,C43:K43)+SUMPRODUCT(C46:K46,C47:K47)+SUMPRODUCT(C50:K50,C51:K51)+SUMPRODUCT(C54:K54,C55:K55)+SUMPRODUCT(C58:K58,C59:K59)+SUMPRODUCT(C62:K62,C63:K63)+SUMPRODUCT(C66:K66,C67:K67)+SUMPRODUCT(C70:K70,C71:K71)","v":433500},"Formula",null,null,"3 = Cross Selling",null,null,"F = Fair (12-24 mos)"]
["20XX Current View",{"$f":"SUM(B7+B9)","v":478500},"Formula",null,null,"4 = Account Rounding",null,null,"O = Who can Say"]
["12 mo Pipeline",{"$f":"SUM(C18:N18)+SUM(C22:N22)+SUM(C26:N26)+SUM(C30:N30)+SUM(C34:N34)+SUM(C38:N38)+SUM(C42:N42)+SUM(C46:N46)+SUM(C50:N50)+SUM(C54:N54)+SUM(C58:N58)+SUM(C62:N62)+SUM(C66:N66)+SUM(C70:N70)","v":1510000},"Formula",null,null,"5 = Networking"]
["Reflecting probability",{"$f":"SUMPRODUCT(C18:N18,C19:N19)+SUMPRODUCT(C22:N22,C23:N23)+SUMPRODUCT(C26:N26,C27:N27)+SUMPRODUCT(C30:N30,C31:N31)+SUMPRODUCT(C34:N34,C35:N35)+SUMPRODUCT(C38:N38,C39:N39)+SUMPRODUCT(C42:N42,C43:N43)+SUMPRODUCT(C46:N46,C47:N47)+SUMPRODUCT(C50:N50,C51:N51)+SUMPRODUCT(C54:N54,C55:N55)+SUMPRODUCT(C58:N58,C59:N59)+SUMPRODUCT(C62:N62,C63:N63)+SUMPRODUCT(C66:N66,C67:N67)+SUMPRODUCT(C70:N70,C71:N71)","v":553500},"Formula",null,null,"6 = Other"]
[]
[null,null,null,null,"Sample Pipeline Management Worksheet - Premium based"]
[null,null,null,null,null,"20XX",null,null,null,null,null,null,"20XX"]
["Prospect",null,"A","M","J","J","A","S","O","N","D ","J ","F","M"]
[]
["A",null,null,null,200000]
[null,null,null,null,0.5]
[null,null,null,null,2]
[null,null,null,null,"F"]
["B",null,null,null,null,null,150000]
[null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,2]
[null,null,null,null,null,null,"G"]
["C",null,null,null,null,null,null,null,300000]
[null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,"G"]
["D",null,null,null,null,null,null,120000]
[null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,"E"]
["E"]
[]
[]
[]
["F"]
[]
[]
[]
["G"]
[]
[]
[]
["H"]
[]
[]
[]
["I"]
[]
[]
[]
["J",null,null,null,null,null,80000]
[null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,2]
[null,null,null,null,null,null,"G"]
["K",null,null,null,null,null,null,null,null,150000]
[null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,"F"]
["L",null,null,null,null,null,null,null,null,null,120000]
[null,null,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"F"]
["M",null,null,null,null,150000]
[null,null,null,null,null,0.2]
[null,null,null,null,null,2]
[null,null,null,null,null,"O"]
["N",null,null,null,null,null,null,null,null,null,null,240000]
[null,null,null,null,null,null,null,null,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,"E"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}