{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Changes","ChangedDeals","Deals-File1","Deals-File2","UniqueIDs","Filters","ChangeCategory"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"Changes","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,4,1,4]]}
["Department","(all)"]
["Oppty Owner","(all)"]
[null,null,null,null,"Changes from 04/04 07:14 AM to 04/05 08:14 AM"]
[null,null,null,"Adv","Back","New","Deleted","NC"]
[null,null,null,"Oppty Advanced","Oppty Backtracked","Oppty Added","Oppty Deleted","Price Change","Total"]
["Closed",null,"Closed $ Increases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(CurStatus=$A6),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(CurStatus=$A6),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(CurStatus=$A6),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(CurStatus=$A6),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(CurStatus=$A6),--(PriceChange>0),(PriceChange))","v":0},{"$f":"SUM(D6:H6)","v":0}]
["Closed",null,"Closed $ Decreases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(PriorStatus=$A7),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(PriorStatus=$A7),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(PriorStatus=$A7),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(PriorStatus=$A7),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(PriorStatus=$A7),-(PriceChange<0),(PriceChange))","v":0},{"$f":"SUM(D7:H7)","v":0}]
["Closed",null,"Closed - Net Change",{"$f":"D6-D7","v":0},0,0,0,0,0]
[]
["Commit",null,"Forecast $ Increases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(CurStatus=$A10),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(CurStatus=$A10),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(CurStatus=$A10),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(CurStatus=$A10),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(CurStatus=$A10),--(PriceChange>0),(PriceChange))","v":0},{"$f":"SUM(D10:H10)","v":0}]
["Commit",null,"Forecast $ Decreases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(PriorStatus=$A11),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(PriorStatus=$A11),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(PriorStatus=$A11),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(PriorStatus=$A11),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(PriorStatus=$A11),-(PriceChange<0),(PriceChange))","v":0},{"$f":"SUM(D11:H11)","v":0}]
["Commit",null,"Forecast - Net Change",{"$f":"D10-D11","v":0},0,0,0,0,0]
[]
["Best Case",null,"Upside $ Increases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(CurStatus=$A14),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(CurStatus=$A14),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(CurStatus=$A14),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(CurStatus=$A14),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(CurStatus=$A14),--(PriceChange>0),(PriceChange))","v":0},{"$f":"SUM(D14:H14)","v":0}]
["Best Case",null,"Upside $ Decreases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(PriorStatus=$A15),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(PriorStatus=$A15),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(PriorStatus=$A15),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(PriorStatus=$A15),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(PriorStatus=$A15),-(PriceChange<0),(PriceChange))","v":0},{"$f":"SUM(D15:H15)","v":0}]
["Best Case",null,"Upside Sales - Net Change",{"$f":"D14-D15","v":0},0,0,0,0,0]
[]
["Pipeline",null,"Pipeline $ Increases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(CurStatus=$A18),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(CurStatus=$A18),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(CurStatus=$A18),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(CurStatus=$A18),(CurPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(CurStatus=$A18),--(PriceChange>0),(PriceChange))","v":0},{"$f":"SUM(D18:H18)","v":0}]
["Pipeline",null,"Pipeline $ Decreases",{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=D$4),--(PriorStatus=$A19),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=E$4),--(PriorStatus=$A19),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=F$4),--(PriorStatus=$A19),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(ChangeCategory=G$4),--(PriorStatus=$A19),(PriorPrice))","v":0},{"$f":"SUMPRODUCT(--(Selected=TRUE),--(PriorStatus=$A19),-(PriceChange<0),(PriceChange))","v":0},{"$f":"SUM(D19:H19)","v":0}]
["Pipeline",null,"Pipeline Sales - Net Change",{"$f":"D18-D19","v":0},0,0,0,0,0]
[]
[]
[]
[]
["Changes in ","Forecast",{"$f":"MATCH(B25 & \" $ Increases\",C:C,0)","v":10}]
[null,null,"Oppty Advanced","Oppty Backtracked","New Oppty","Deleted Oppty","Price Increase","Price Drop","Net Change"]
[null,null,{"$f":"INDEX(D:D,$C$25+2)","v":0},{"$f":"INDEX(E:E,$C$25+2)","v":0},{"$f":"INDEX(F:F,$C$25+2)","v":0},{"$f":"INDEX(G:G,$C$25+2)","v":0},{"$f":"INDEX(H:H,$C$25)","v":0},{"$f":"-INDEX(H:H,$C$25+1)","v":0},{"$f":"SUM(C27:H27)","v":0}]
[null,"Column",null,null,null,null,null,null,{"$f":"H30","v":0}]
[null,"Starting",0,{"$f":"C30","v":0},{"$f":"D30","v":0},{"$f":"E30","v":0},{"$f":"F30","v":0},{"$f":"G30","v":0},{"$error":"#N/A"}]
[null,"Ending",{"$f":"C27","v":0},{"$f":"C30+D27","v":0},{"$f":"D30+E27","v":0},{"$f":"E30+F27","v":0},{"$f":"F30+G27","v":0},{"$f":"G30+H27","v":0},{"$f":"H30","v":0}]

{"sheet":"ChangedDeals","index":1,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,6,1,7]]}
[null,{"$f":"MATCH(A1,'Deals-File1'!F:F,0)","v":{"$error":"#N/A"}},{"$f":"MATCH(A1,'Deals-File2'!F:F,0)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(B1),INDEX('Deals-File2'!E:E,C1),INDEX('Deals-File1'!E:E,B1))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(B1),INDEX('Deals-File2'!A:A,C1),INDEX('Deals-File1'!A:A,B1))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(B1),INDEX('Deals-File2'!B:B,C1),INDEX('Deals-File1'!B:B,B1))","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(B1),\"-\",INDEX('Deals-File1'!H:H,B1))","v":"-"},{"$f":"IF(ISNA(B1),0,INDEX('Deals-File1'!L:L,B1))","v":0},{"$f":"IF(ISNA(C1),\"-\",INDEX('Deals-File2'!H:H,C1))","v":"-"},{"$f":"IF(ISNA(C1),0,INDEX('Deals-File2'!L:L,C1))","v":0},{"$f":"AND(OR(Changes!B$1=\"(all)\",Changes!B$1=E1),OR(Changes!B$2=\"(all)\",Changes!B$2=F1))","v":{"$error":"#N/A"}},{"$f":"OR(G1<>I1,H1<>J1)","v":false},{"$f":"OFFSET(ChangeCategory!$A$1,MATCH(I1,ChangeCategory!$A$2:$A$6,0),MATCH(G1,ChangeCategory!$B$1:$F$1,0))","v":"NC"},{"$f":"IF(M1=\"NC\",H1-J1,0)","v":0}]
[null,null,null,null,null,null,"Current Status",null,"Prior Status"]
["Opportunity ID","Row - File1","Row - File2","Opportunity Name","Department","Owner","Forecast Status","Price","Forecast Status","Price","Selected","Changed?","Category Change Type","Dollar Change"]
["0067000000BYgCNAA1",2,2,"Sample Opportunity","Sales","Account Manager","Commit",66495,"Commit",66495,{"$f":"AND(OR(Changes!B$1=\"(all)\",Changes!B$1=E4),OR(Changes!B$2=\"(all)\",Changes!B$2=F4))","v":true},true,"NC",0]

{"sheet":"Deals-File1","index":2,"n_rows":88,"n_cols":28,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
["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",null,null,null,null,"Foreign?","Type",null,null,null,null,null,null,null,null,"Fcst Category"]
["Sales","Account Manager","Leslie Platt","0017000000O9pgY","Platt - 0512 - first row","0067000000BYgCNAA1",41052,"Best Case",50,"Proposal/ Price Quote",41000,66095,"Sample Next Step"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Task 1\u008a\u008dTask2"]

{"sheet":"Deals-File2","index":3,"n_rows":88,"n_cols":28,"rows_kept":88,"cut":false,"hidden":true,"merged":[]}
["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",null,null,null,null,"Foreign?","Type",null,null,null,null,null,null,null,null,"Fcst Category"]
["Sales","Account Manager","Leslie Platt","0017000000O9pgY","Platt - 0512","0067000000BYgCNAA1",41052,"Best Case",50,"Proposal/ Price Quote",41000,66495,"Sample Next Step"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Task 1\u008a\u008dTask2"]

{"sheet":"UniqueIDs","index":4,"n_rows":202,"n_cols":1,"rows_kept":202,"cut":false,"hidden":true,"merged":[]}
["0067000000BYgCKAA1"]
["0067000000BYgCLAA1"]
["0067000000BYgCMAA1"]
["0067000000BYgCNAA1"]
["0067000000BYgCsAAL"]
["0067000000BYgCtAAL"]
["0067000000BYgCuAAL"]
["0067000000BYgCvAAL"]
["0067000000BYgD2AAL"]
["0067000000BYgD3AAL"]
["0067000000BYgD4AAL"]
["0067000000BYgD5AAL"]
["0067000000BYgD6AAL"]
["0067000000BYgD7AAL"]
["0067000000BYgD8AAL"]
["0067000000BYgD9AAL"]
["0067000000BYgDAAA1"]
["0067000000BYgDaAAL"]
["0067000000BYgDBAA1"]
["0067000000BYgDbAAL"]
["0067000000BYgDcAAL"]
["0067000000BYgDdAAL"]
["0067000000BYgDeAAL"]
["0067000000BYgDfAAL"]
["0067000000BYgDHAA1"]
["0067000000BYgDIAA1"]
["0067000000BYgDJAA1"]
["0067000000BYgDKAA1"]
["0067000000BYgDLAA1"]
["0067000000BYgDMAA1"]
["0067000000BYgDNAA1"]
["0067000000BYgDOAA1"]
["0067000000BYgDPAA1"]
["0067000000BYgDQAA1"]
["0067000000BYgDRAA1"]
["0067000000BYgDSAA1"]
["0067000000BYgDTAA1"]
["0067000000BYgDUAA1"]
["0067000000BYgDVAA1"]
["0067000000BYgDvAAL"]
["0067000000BYgDWAA1"]
["0067000000BYgDwAAL"]
["0067000000BYgDXAA1"]
["0067000000BYgDxAAL"]
["0067000000BYgDYAA1"]
["0067000000BYgDyAAL"]
["0067000000BYgDZAA1"]
["0067000000BYgDzAAL"]
["0067000000BYgE1AAL"]
["0067000000BYgE2AAL"]
["0067000000BYgE3AAL"]
["0067000000BYgE4AAL"]
["0067000000BYgEAAA1"]
["0067000000BYgEaAAL"]
["0067000000BYgEBAA1"]
["0067000000BYgEbAAL"]
["0067000000BYgECAA1"]
["0067000000BYgEcAAL"]
["0067000000BYgEDAA1"]
["0067000000BYgEdAAL"]
["0067000000BYgEEAA1"]
["0067000000BYgEeAAL"]
["0067000000BYgEFAA1"]
["0067000000BYgEfAAL"]
["0067000000BYgEGAA1"]
["0067000000BYgEgAAL"]
["0067000000BYgEHAA1"]
["0067000000BYgEhAAL"]
["0067000000BYgEIAA1"]
["0067000000BYgEiAAL"]
["0067000000BYgEJAA1"]
["0067000000BYgEjAAL"]
["0067000000BYgEKAA1"]
["0067000000BYgEkAAL"]
["0067000000BYgELAA1"]
["0067000000BYgElAAL"]
["0067000000BYgEMAA1"]
["0067000000BYgEmAAL"]
["0067000000BYgENAA1"]
["0067000000BYgEnAAL"]
["0067000000BYgEOAA1"]
["0067000000BYgEPAA1"]
["0067000000BYgEQAA1"]
["0067000000BYgERAA1"]
["0067000000BYgESAA1"]
["0067000000BYgETAA1"]
["0067000000BYgEtAAL"]
["0067000000BYgEuAAL"]
["0067000000BYgEvAAL"]
["0067000000BYgEwAAL"]
["0067000000BYgExAAL"]
["0067000000BYgEyAAL"]
["0067000000BYgEZAA1"]
["0067000000BYgEzAAL"]
["0067000000BYgF0AAL"]
["0067000000BYgF1AAL"]
["0067000000BYgF2AAL"]
["0067000000BYgF8AAL"]
["0067000000BYgF9AAL"]
["0067000000BYgFAAA1"]
["0067000000BYgFBAA1"]
["0067000000BYgFCAA1"]
["0067000000BYgFcAAL"]
["0067000000BYgFmAAL"]
["0067000000BYgFnAAL"]
["0067000000BYgFpAAL"]
["0067000000BYgFqAAL"]
["0067000000BYgFrAAL"]
["0067000000BYgFSAA1"]
["0067000000BYgFsAAL"]
["0067000000BYgFTAA1"]
["0067000000BYgFtAAL"]
["0067000000BYgFUAA1"]
["0067000000BYgFuAAL"]
["0067000000BYgFVAA1"]
["0067000000BYgFvAAL"]
["0067000000BYgFWAA1"]
["0067000000BYgFwAAL"]
["0067000000BYgFXAA1"]
["0067000000BYgFxAAL"]
["0067000000BYgFzAAL"]
["0067000000BYgG0AAL"]
["0067000000BYgG1AAL"]
["0067000000BYgG2AAL"]
["0067000000BYgG3AAL"]
["0067000000BYgG4AAL"]
["0067000000BYgG5AAL"]
["0067000000BYgG6AAL"]
["0067000000BYgG7AAL"]
["0067000000BYgG8AAL"]
["0067000000BYgG9AAL"]
["0067000000BYgGAAA1"]
["0067000000BYgGkAAL"]
["0067000000BYgGLAA1"]
["0067000000BYgGlAAL"]
["0067000000BYgGMAA1"]
["0067000000BYgGmAAL"]
["0067000000BYgGNAA1"]
["0067000000BYgGnAAL"]
["0067000000BYgGOAA1"]
["0067000000BYgGoAAL"]
["0067000000BYgGPAA1"]
["0067000000BYgGpAAL"]
["0067000000BYgGQAA1"]
["0067000000BYgGqAAL"]
["0067000000BYgGRAA1"]
["0067000000BYgGrAAL"]
["0067000000BYgGSAA1"]
["0067000000BYgGsAAL"]
["0067000000BYgGTAA1"]
["0067000000BYgGtAAL"]
["0067000000BYgGzAAL"]
["0067000000BYgH0AAL"]
["0067000000BYgH1AAL"]
["0067000000BYgH2AAL"]
["0067000000BYgH3AAL"]
["0067000000BYgH4AAL"]
["0067000000BYgH5AAL"]
["0067000000BYgH6AAL"]
["0067000000BYgH7AAL"]
["0067000000BYgH9AAL"]
["0067000000BYgHAAA1"]
["0067000000BYgHaAAL"]
["0067000000BYgHBAA1"]
["0067000000BYgHbAAL"]
["0067000000BYgHCAA1"]
["0067000000BYgHDAA1"]
["0067000000BYgHhAAL"]
["0067000000BYgHmAAL"]
["0067000000BYgHNAA1"]
["0067000000BYgHnAAL"]
["0067000000BYgHOAA1"]
["0067000000BYgHoAAL"]
["0067000000BYgHPAA1"]
["0067000000BYgHQAA1"]
["0067000000BYgHRAA1"]
["0067000000BYgHrAAL"]
["0067000000BYgHSAA1"]
["0067000000BYgHsAAL"]
["0067000000BYgHTAA1"]
["0067000000BYgHtAAL"]
["0067000000BYgHvAAL"]
["0067000000BYgHXAA1"]
["0067000000BYgHYAA1"]
["0067000000BYgHZAA1"]
["0067000000BYgI1AAL"]
["0067000000BYgI2AAL"]
["0067000000BYgI3AAL"]
["0067000000BYgI6AAL"]
["0067000000BYgI7AAL"]
["0067000000BYgI8AAL"]
["0067000000BYgI9AAL"]
["0067000000BYgIAAA1"]
["0067000000BYgIaAAL"]
["0067000000BYgIbAAL"]
["0067000000BYgIcAAL"]
["0067000000BYgIdAAL"]
["0067000000BYgIjAAL"]
["0067000000BYgIZAA1"]
["0067000000BZBmMAAX"]
["0067000000CYgH1AAL"]
["0067000000O18e4AAB"]

{"sheet":"Filters","index":5,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Department","Opportunity Owner"]
["(all)","(all)"]
["Sales","Account Manager"]

{"sheet":"ChangeCategory","index":6,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Old \\ New Status","-","Closed","Commit","Best Case","Pipeline"]
["-","NC","New","New","New","New"]
["Closed","Deleted","NC","Back","Back","Back"]
["Commit","Deleted","Adv","NC","Back","Back"]
["Best Case","Deleted","Adv","Adv","NC","Back"]
["Pipeline","Deleted","Adv","Adv","Adv","NC"]