{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Issue Tracker","calculations"],"not_rendered":{"charts":1,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Issue Tracker","index":0,"n_rows":107,"n_cols":10,"rows_kept":107,"merged":[[1,1,2,5]]}
[]
[null,"OPEN vs. CLOSED ISSUE TRACKER",{"$nulls":4},"TYPE","PRIORITY","DATE","LAST (days)"]
[{"$nulls":6},"*","*","2013-05-30",30]
{"$rows_empty":12}
[null,"#","ISSUE","TYPE","PRIORITY","OPENED ON","OPENED BY","CLOSED ON","CLOSED BY","NOTES"]
[null,1,"Issue #1","Type 2","Medium","2013-02-01","James","2013-02-04","James"]
[null,2,"Issue #2","Type 2","Low","2013-02-01","Kim","2013-02-01","James"]
[null,3,"Issue #3","Type 3","Low","2013-02-04","Lilly","2013-02-04","Lilly"]
[null,4,"Issue #4","Type 1","Medium","2013-02-04","Lilly","2013-02-05","Lilly"]
[null,5,"Issue #5","Type 1","Medium","2013-02-04","James","2013-02-04","Ted"]
[null,6,"Issue #6","Type 1","Low","2013-02-08","Ted","2013-02-08","James"]
[null,7,"Issue #7","Type 1","High","2013-02-08","Kim","2013-02-13","James"]
[null,8,"Issue #8","Type 2","Medium","2013-02-08","Kim","2013-02-11","James"]
[null,9,"Issue #9","Type 3","Medium","2013-02-08","Kim","2013-02-11","Kim"]
[null,10,"Issue #10","Type 4","High","2013-02-12","Ted","2013-02-12","Lilly"]
[null,11,"Issue #11","Type 2","Medium","2013-02-12","Kim","2013-02-13","Lilly"]
[null,12,"Issue #12","Type 1","High","2013-02-15","Ted","2013-02-18","James"]
[null,13,"Issue #13","Type 2","High","2013-02-20","Kim","2013-02-20","Kim"]
[null,14,"Issue #14","Type 2","High","2013-02-23","Ted","2013-02-23","James"]
[null,15,"Issue #15","Type 2","Low","2013-02-26","James","2013-02-27","Lilly"]
[null,16,"Issue #16","Type 4","Medium","2013-02-26","Lilly","2013-02-26","James"]
[null,17,"Issue #17","Type 2","Low","2013-02-26","Ted","2013-02-26","Ted"]
[null,18,"Issue #18","Type 3","High","2013-02-27","Lilly","2013-02-27","Lilly"]
[null,19,"Issue #19","Type 2","Low","2013-02-27","Ted","2013-02-28","Lilly"]
[null,20,"Issue #20","Type 3","Low","2013-03-04","Lilly","2013-03-04","Ted"]
[null,21,"Issue #21","Type 4","Low","2013-03-04","Lilly","2013-03-07","Kim"]
[null,22,"Issue #22","Type 3","Low","2013-03-04","Ted","2013-03-09","Kim"]
[null,23,"Issue #23","Type 3","Medium","2013-03-05","Kim","2013-03-05","James"]
[null,24,"Issue #24","Type 3","Medium","2013-03-05","Lilly","2013-03-05","James"]
[null,25,"Issue #25","Type 1","High","2013-03-06","Kim","2013-03-10","Ted"]
[null,26,"Issue #26","Type 1","High","2013-03-06","Kim","2013-03-08","Kim"]
[null,27,"Issue #27","Type 1","High","2013-03-06","James","2013-03-08","Ted"]
[null,28,"Issue #28","Type 4","Low","2013-03-11","Ted","2013-03-12","James"]
[null,29,"Issue #29","Type 3","Low","2013-03-12","Kim","2013-03-13","Kim"]
[null,30,"Issue #30","Type 2","Medium","2013-03-12","Lilly","2013-03-13","Kim"]
[null,31,"Issue #31","Type 4","Medium","2013-03-17","Lilly","2013-03-19","James"]
[null,32,"Issue #32","Type 4","Low","2013-03-21","Ted","2013-03-26","James"]
[null,33,"Issue #33","Type 4","Low","2013-03-25","James","2013-03-27","Lilly"]
[null,34,"Issue #34","Type 3","Low","2013-03-25","Kim","2013-03-30","Lilly"]
[null,35,"Issue #35","Type 1","Low","2013-03-29","James","2013-03-29","Kim"]
[null,36,"Issue #36","Type 4","Medium","2013-03-31","Ted","2013-04-04","Lilly"]
[null,37,"Issue #37","Type 4","Medium","2013-04-05","James","2013-04-06","Lilly"]
[null,38,"Issue #38","Type 2","High","2013-04-09","Lilly","2013-04-14","James"]
[null,39,"Issue #39","Type 4","Low","2013-04-10","Lilly","2013-04-12","Ted"]
[null,40,"Issue #40","Type 3","Low","2013-04-10","Ted","2013-04-13","Lilly"]
[null,41,"Issue #41","Type 4","Low","2013-04-12","James","2013-04-13","James"]
[null,42,"Issue #42","Type 1","Medium","2013-04-16","Kim","2013-04-16","Ted"]
[null,43,"Issue #43","Type 2","Medium","2013-04-18","Lilly","2013-04-18","Kim"]
[null,44,"Issue #44","Type 1","Medium","2013-04-18","Ted","2013-04-22","Kim"]
[null,45,"Issue #45","Type 1","Medium","2013-04-22","Lilly","2013-04-23","Kim"]
[null,46,"Issue #46","Type 2","High","2013-04-23","James","2013-04-24","Kim"]
[null,47,"Issue #47","Type 1","Medium","2013-04-25","Ted","2013-04-25","Lilly"]
[null,48,"Issue #48","Type 3","Medium","2013-04-30","Ted","2013-05-01","Kim"]
[null,49,"Issue #49","Type 1","Medium","2013-05-05","Lilly","2013-05-05","Ted"]
[null,50,"Issue #50","Type 2","Medium","2013-05-05","Kim","2013-05-09","James"]
[null,51,"Issue #51","Type 2","High","2013-05-08","James","2013-05-12","Kim"]
[null,52,"Issue #52","Type 3","Low","2013-05-11","James","2013-05-14","Ted"]
[null,53,"Issue #53","Type 4","Medium","2013-05-11","James","2013-05-11","Ted"]
[null,54,"Issue #54","Type 1","Low","2013-05-12","James","2013-05-12","Ted"]
[null,55,"Issue #55","Type 1","Low","2013-05-15","Ted","2013-05-15","James"]
[null,56,"Issue #56","Type 1","Medium","2013-05-17","Lilly","2013-05-17","Lilly"]
[null,57,"Issue #57","Type 1","High","2013-05-17","Lilly","2013-05-21","Kim"]
[null,58,"Issue #58","Type 1","High","2013-05-17","Lilly","2013-05-19","Lilly"]
[null,59,"Issue #59","Type 3","Medium","2013-05-21","Kim","2013-05-21","Ted"]
[null,60,"Issue #60","Type 3","High","2013-05-24","Ted","2013-05-26","Kim"]
[null,61,"Issue #61","Type 2","Medium","2013-05-25","Kim","2013-05-25","Lilly"]
[null,62,"Issue #62","Type 3","Low","2013-05-30","Lilly","2013-06-03","James"]
[null,63,"Issue #63","Type 4","Low","2013-06-04","James","2013-06-04","James"]
[null,64,"Issue #64","Type 4","Low","2013-06-07","Ted","2013-06-09","Ted"]
[null,65,"Issue #65","Type 4","High","2013-06-07","Ted","2013-06-07","James"]
[null,66,"Issue #66","Type 4","Medium","2013-06-12","Kim","2013-06-12","Kim"]
[null,67,"Issue #67","Type 1","Medium","2013-06-17","Ted","2013-06-17","James"]
[null,68,"Issue #68","Type 4","Low","2013-06-18","Lilly","2013-06-18","James"]
[null,69,"Issue #69","Type 3","Medium","2013-06-18","James","2013-06-18","Lilly"]
[null,70,"Issue #70","Type 4","High","2013-06-18","Lilly","2013-06-18","Kim"]
[null,71,"Issue #71","Type 3","High","2013-06-19","James","2013-06-19","Lilly"]
[null,72,"Issue #72","Type 2","High","2013-06-23","Ted","2013-06-23","James"]
[null,73,"Issue #73","Type 4","Low","2013-06-28","James","2013-06-30","Kim"]
[null,74,"Issue #74","Type 1","Low","2013-06-28","Kim","2013-06-28","Kim"]
[null,75,"Issue #75","Type 4","High","2013-07-03","James","2013-07-03","Kim"]
[null,76,"Issue #76","Type 3","High","2013-07-04","Kim","2013-07-08","Ted"]
[null,77,"Issue #77","Type 2","High","2013-07-04","Ted","2013-07-04","Kim"]
[null,78,"Issue #78","Type 2","High","2013-07-05","Ted","2013-07-10","Lilly"]
[null,79,"Issue #79","Type 4","Medium","2013-07-10","James","2013-07-15","Lilly"]
[null,80,"Issue #80","Type 1","High","2013-07-10","Ted","2013-07-12","James"]
[null,81,"Issue #81","Type 4","High","2013-07-11","Lilly","2013-07-13","Ted"]
[null,82,"Issue #82","Type 1","High","2013-07-15","Lilly","2013-07-18","Kim"]
[null,83,"Issue #83","Type 4","High","2013-07-17","Kim","2013-07-20","Ted"]
[null,84,"Issue #84","Type 2","Low","2013-07-20","James","2013-07-20","Lilly"]
[null,85,"Issue #85","Type 1","Medium","2013-07-23","James","2013-07-23","Ted"]
[null,86,"Issue #86","Type 3","Medium","2013-07-28","Kim","2013-07-28","Kim"]
[null,87,"Issue #87","Type 2","Medium","2013-07-28","Lilly","2013-08-02","Kim"]
[null,88,"Issue #88","Type 2","Medium","2013-07-31","Ted","2013-07-31","James"]
[null,89,"Issue #89","Type 3","High","2013-08-02","Kim","2013-08-06","Lilly"]
[null,90,"Issue #90","Type 4","Medium","2013-08-06","Kim","2013-08-06","James"]
[null,91,"Issue #91","Type 2","High","2013-08-08","Kim","2013-08-10","Lilly"]

{"sheet":"calculations","index":1,"n_rows":80,"n_cols":20,"rows_kept":80,"hidden":true}
["*** This sheet should remain hidden ***"]
[]
[]
[{"$nulls":8},"Min","2012-01-01"]
[{"$nulls":8},"Max"]
[]
[{"$nulls":8},"Days",{"$f":"'Issue Tracker'!J3","v":30}]
[{"$nulls":8},"Date",{"$f":"'Issue Tracker'!I3","v":"2013-05-30"},{"$nulls":3},{"$f":"COUNT(typesUnsorted)","v":0}]
[{"$nulls":8},"Type",{"$f":"'Issue Tracker'!G3","v":"*"}]
[{"$nulls":8},"Priority",{"$f":"'Issue Tracker'!H3","v":"*"}]
[]
[{"$nulls":13},{"$f":"OFFSET($N$16,,,$N$13)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET($O$16,,,$O$13)","v":{"$error":"#VALUE!"}}]
[{"$nulls":13},{"$f":"COUNTA(N16:N45)-COUNTIF(N16:N45,NA())","v":4},{"$f":"COUNTA(O16:O45)-COUNTIF(O16:O45,NA())","v":3},{"$nulls":3},"Sorted","Sorted"]
[{"$nulls":7},"Date","Opened","Closed",{"$nulls":3},"Types","Priorities",{"$nulls":3},"Types","Priorities"]
[{"$nulls":13},"*","*"]
[{"$nulls":6},1,{"$f":"keydate-days+G16","v":"2013-05-01"},{"$f":"I15+COUNTIFS(issues[OPENED ON],H16,issues[TYPE],type,issues[PRIORITY],priority)","v":0},{"$f":"J15+COUNTIFS(issues[CLOSED ON],H16,issues[TYPE],type,issues[PRIORITY],priority)","v":1},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N15, issues[TYPE]),0))","v":"Type 2"},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O15,issues[PRIORITY]),0))","v":"Medium"},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(1:1)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":"*"},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(1:1)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":"*"}]
[{"$nulls":6},2,"2013-05-02",{"$f":"I16+COUNTIFS(issues[OPENED ON],H17,issues[TYPE],type,issues[PRIORITY],priority)","v":0},{"$f":"J16+COUNTIFS(issues[CLOSED ON],H17,issues[TYPE],type,issues[PRIORITY],priority)","v":1},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N16, issues[TYPE]),0))","v":"Type 3"},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O16,issues[PRIORITY]),0))","v":"Low"},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(2:2)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":"Type 1"},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(2:2)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":"High"}]
[{"$nulls":6},3,"2013-05-03",{"$f":"I17+COUNTIFS(issues[OPENED ON],H18,issues[TYPE],type,issues[PRIORITY],priority)","v":0},{"$f":"J17+COUNTIFS(issues[CLOSED ON],H18,issues[TYPE],type,issues[PRIORITY],priority)","v":1},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N17, issues[TYPE]),0))","v":"Type 1"},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O17,issues[PRIORITY]),0))","v":"High"},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(3:3)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":"Type 2"},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(3:3)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":"Low"}]
[{"$nulls":6},4,"2013-05-04",{"$f":"I18+COUNTIFS(issues[OPENED ON],H19,issues[TYPE],type,issues[PRIORITY],priority)","v":0},{"$f":"J18+COUNTIFS(issues[CLOSED ON],H19,issues[TYPE],type,issues[PRIORITY],priority)","v":1},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N18, issues[TYPE]),0))","v":"Type 4"},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O18,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(4:4)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":"Type 3"},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(4:4)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":"Medium"}]
[{"$nulls":6},5,"2013-05-05",{"$f":"I19+COUNTIFS(issues[OPENED ON],H20,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$f":"J19+COUNTIFS(issues[CLOSED ON],H20,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N19, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O19,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(5:5)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":"Type 4"},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(5:5)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},6,"2013-05-06",{"$f":"I20+COUNTIFS(issues[OPENED ON],H21,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$f":"J20+COUNTIFS(issues[CLOSED ON],H21,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N20, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O20,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(6:6)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(6:6)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},7,"2013-05-07",{"$f":"I21+COUNTIFS(issues[OPENED ON],H22,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$f":"J21+COUNTIFS(issues[CLOSED ON],H22,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N21, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O21,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(7:7)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(7:7)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},8,"2013-05-08",{"$f":"I22+COUNTIFS(issues[OPENED ON],H23,issues[TYPE],type,issues[PRIORITY],priority)","v":3},{"$f":"J22+COUNTIFS(issues[CLOSED ON],H23,issues[TYPE],type,issues[PRIORITY],priority)","v":2},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N22, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O22,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(8:8)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(8:8)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},9,"2013-05-09",{"$f":"I23+COUNTIFS(issues[OPENED ON],H24,issues[TYPE],type,issues[PRIORITY],priority)","v":3},{"$f":"J23+COUNTIFS(issues[CLOSED ON],H24,issues[TYPE],type,issues[PRIORITY],priority)","v":3},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N23, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O23,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(9:9)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(9:9)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},10,"2013-05-10",{"$f":"I24+COUNTIFS(issues[OPENED ON],H25,issues[TYPE],type,issues[PRIORITY],priority)","v":3},{"$f":"J24+COUNTIFS(issues[CLOSED ON],H25,issues[TYPE],type,issues[PRIORITY],priority)","v":3},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N24, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O24,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(10:10)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(10:10)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},11,"2013-05-11",{"$f":"I25+COUNTIFS(issues[OPENED ON],H26,issues[TYPE],type,issues[PRIORITY],priority)","v":5},{"$f":"J25+COUNTIFS(issues[CLOSED ON],H26,issues[TYPE],type,issues[PRIORITY],priority)","v":4},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N25, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O25,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(11:11)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(11:11)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},12,"2013-05-12",{"$f":"I26+COUNTIFS(issues[OPENED ON],H27,issues[TYPE],type,issues[PRIORITY],priority)","v":6},{"$f":"J26+COUNTIFS(issues[CLOSED ON],H27,issues[TYPE],type,issues[PRIORITY],priority)","v":6},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N26, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O26,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(12:12)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(12:12)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},13,"2013-05-13",{"$f":"I27+COUNTIFS(issues[OPENED ON],H28,issues[TYPE],type,issues[PRIORITY],priority)","v":6},{"$f":"J27+COUNTIFS(issues[CLOSED ON],H28,issues[TYPE],type,issues[PRIORITY],priority)","v":6},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N27, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O27,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(13:13)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(13:13)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},14,"2013-05-14",{"$f":"I28+COUNTIFS(issues[OPENED ON],H29,issues[TYPE],type,issues[PRIORITY],priority)","v":6},{"$f":"J28+COUNTIFS(issues[CLOSED ON],H29,issues[TYPE],type,issues[PRIORITY],priority)","v":7},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N28, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O28,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(14:14)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(14:14)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},15,"2013-05-15",{"$f":"I29+COUNTIFS(issues[OPENED ON],H30,issues[TYPE],type,issues[PRIORITY],priority)","v":7},{"$f":"J29+COUNTIFS(issues[CLOSED ON],H30,issues[TYPE],type,issues[PRIORITY],priority)","v":8},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N29, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O29,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(15:15)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(15:15)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},16,"2013-05-16",{"$f":"I30+COUNTIFS(issues[OPENED ON],H31,issues[TYPE],type,issues[PRIORITY],priority)","v":7},{"$f":"J30+COUNTIFS(issues[CLOSED ON],H31,issues[TYPE],type,issues[PRIORITY],priority)","v":8},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N30, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O30,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(16:16)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(16:16)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},17,"2013-05-17",{"$f":"I31+COUNTIFS(issues[OPENED ON],H32,issues[TYPE],type,issues[PRIORITY],priority)","v":10},{"$f":"J31+COUNTIFS(issues[CLOSED ON],H32,issues[TYPE],type,issues[PRIORITY],priority)","v":9},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N31, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O31,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(17:17)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(17:17)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},18,"2013-05-18",{"$f":"I32+COUNTIFS(issues[OPENED ON],H33,issues[TYPE],type,issues[PRIORITY],priority)","v":10},{"$f":"J32+COUNTIFS(issues[CLOSED ON],H33,issues[TYPE],type,issues[PRIORITY],priority)","v":9},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N32, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O32,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(18:18)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(18:18)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},19,"2013-05-19",{"$f":"I33+COUNTIFS(issues[OPENED ON],H34,issues[TYPE],type,issues[PRIORITY],priority)","v":10},{"$f":"J33+COUNTIFS(issues[CLOSED ON],H34,issues[TYPE],type,issues[PRIORITY],priority)","v":10},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N33, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O33,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(19:19)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(19:19)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},20,"2013-05-20",{"$f":"I34+COUNTIFS(issues[OPENED ON],H35,issues[TYPE],type,issues[PRIORITY],priority)","v":10},{"$f":"J34+COUNTIFS(issues[CLOSED ON],H35,issues[TYPE],type,issues[PRIORITY],priority)","v":10},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N34, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O34,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(20:20)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(20:20)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},21,"2013-05-21",{"$f":"I35+COUNTIFS(issues[OPENED ON],H36,issues[TYPE],type,issues[PRIORITY],priority)","v":11},{"$f":"J35+COUNTIFS(issues[CLOSED ON],H36,issues[TYPE],type,issues[PRIORITY],priority)","v":12},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N35, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O35,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(21:21)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(21:21)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},22,"2013-05-22",{"$f":"I36+COUNTIFS(issues[OPENED ON],H37,issues[TYPE],type,issues[PRIORITY],priority)","v":11},{"$f":"J36+COUNTIFS(issues[CLOSED ON],H37,issues[TYPE],type,issues[PRIORITY],priority)","v":12},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N36, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O36,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(22:22)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(22:22)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},23,"2013-05-23",{"$f":"I37+COUNTIFS(issues[OPENED ON],H38,issues[TYPE],type,issues[PRIORITY],priority)","v":11},{"$f":"J37+COUNTIFS(issues[CLOSED ON],H38,issues[TYPE],type,issues[PRIORITY],priority)","v":12},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N37, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O37,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(23:23)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(23:23)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},24,"2013-05-24",{"$f":"I38+COUNTIFS(issues[OPENED ON],H39,issues[TYPE],type,issues[PRIORITY],priority)","v":12},{"$f":"J38+COUNTIFS(issues[CLOSED ON],H39,issues[TYPE],type,issues[PRIORITY],priority)","v":12},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N38, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O38,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(24:24)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(24:24)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},25,"2013-05-25",{"$f":"I39+COUNTIFS(issues[OPENED ON],H40,issues[TYPE],type,issues[PRIORITY],priority)","v":13},{"$f":"J39+COUNTIFS(issues[CLOSED ON],H40,issues[TYPE],type,issues[PRIORITY],priority)","v":13},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N39, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O39,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(25:25)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(25:25)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},26,"2013-05-26",{"$f":"I40+COUNTIFS(issues[OPENED ON],H41,issues[TYPE],type,issues[PRIORITY],priority)","v":13},{"$f":"J40+COUNTIFS(issues[CLOSED ON],H41,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N40, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O40,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(26:26)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(26:26)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},27,"2013-05-27",{"$f":"I41+COUNTIFS(issues[OPENED ON],H42,issues[TYPE],type,issues[PRIORITY],priority)","v":13},{"$f":"J41+COUNTIFS(issues[CLOSED ON],H42,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N41, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O41,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(27:27)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(27:27)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},28,"2013-05-28",{"$f":"I42+COUNTIFS(issues[OPENED ON],H43,issues[TYPE],type,issues[PRIORITY],priority)","v":13},{"$f":"J42+COUNTIFS(issues[CLOSED ON],H43,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N42, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O42,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(28:28)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(28:28)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},29,"2013-05-29",{"$f":"I43+COUNTIFS(issues[OPENED ON],H44,issues[TYPE],type,issues[PRIORITY],priority)","v":13},{"$f":"J43+COUNTIFS(issues[CLOSED ON],H44,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N43, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O43,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(29:29)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(29:29)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},30,"2013-05-30",{"$f":"I44+COUNTIFS(issues[OPENED ON],H45,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$f":"J44+COUNTIFS(issues[CLOSED ON],H45,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$nulls":3},{"$f":"INDEX(issues[TYPE],MATCH(0,COUNTIF(N$15:N44, issues[TYPE]),0))","v":{"$error":"#N/A"}},{"$f":"INDEX(issues[PRIORITY],MATCH(0,COUNTIF(O$15:O44,issues[PRIORITY]),0))","v":{"$error":"#N/A"}},{"$nulls":3},{"$f":"INDEX(typesUnsorted, MATCH(SMALL(COUNTIF(typesUnsorted, \"<\"&typesUnsorted), ROW(30:30)), COUNTIF(typesUnsorted, \"<\"&typesUnsorted), 0))","v":{"$error":"#NUM!"}},{"$f":"INDEX(prioritiesUnsorted, MATCH(SMALL(COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), ROW(30:30)), COUNTIF(prioritiesUnsorted, \"<\"&prioritiesUnsorted), 0))","v":{"$error":"#NUM!"}}]
[{"$nulls":6},31,"2013-05-31",{"$f":"I45+COUNTIFS(issues[OPENED ON],H46,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$f":"J45+COUNTIFS(issues[CLOSED ON],H46,issues[TYPE],type,issues[PRIORITY],priority)","v":14}]
[{"$nulls":6},32,"2013-06-01",{"$f":"I46+COUNTIFS(issues[OPENED ON],H47,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$f":"J46+COUNTIFS(issues[CLOSED ON],H47,issues[TYPE],type,issues[PRIORITY],priority)","v":14}]
[{"$nulls":6},33,{"$f":"keydate-days+G48","v":"2013-06-02"},{"$f":"I47+COUNTIFS(issues[OPENED ON],H48,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$f":"J47+COUNTIFS(issues[CLOSED ON],H48,issues[TYPE],type,issues[PRIORITY],priority)","v":14}]
[{"$nulls":6},34,"2013-06-03",{"$f":"I48+COUNTIFS(issues[OPENED ON],H49,issues[TYPE],type,issues[PRIORITY],priority)","v":14},{"$f":"J48+COUNTIFS(issues[CLOSED ON],H49,issues[TYPE],type,issues[PRIORITY],priority)","v":15}]
[{"$nulls":6},35,"2013-06-04",{"$f":"I49+COUNTIFS(issues[OPENED ON],H50,issues[TYPE],type,issues[PRIORITY],priority)","v":15},{"$f":"J49+COUNTIFS(issues[CLOSED ON],H50,issues[TYPE],type,issues[PRIORITY],priority)","v":16}]
[{"$nulls":6},36,"2013-06-05",{"$f":"I50+COUNTIFS(issues[OPENED ON],H51,issues[TYPE],type,issues[PRIORITY],priority)","v":15},{"$f":"J50+COUNTIFS(issues[CLOSED ON],H51,issues[TYPE],type,issues[PRIORITY],priority)","v":16}]
[{"$nulls":6},37,"2013-06-06",{"$f":"I51+COUNTIFS(issues[OPENED ON],H52,issues[TYPE],type,issues[PRIORITY],priority)","v":15},{"$f":"J51+COUNTIFS(issues[CLOSED ON],H52,issues[TYPE],type,issues[PRIORITY],priority)","v":16}]
[{"$nulls":6},38,"2013-06-07",{"$f":"I52+COUNTIFS(issues[OPENED ON],H53,issues[TYPE],type,issues[PRIORITY],priority)","v":17},{"$f":"J52+COUNTIFS(issues[CLOSED ON],H53,issues[TYPE],type,issues[PRIORITY],priority)","v":17}]
[{"$nulls":6},39,"2013-06-08",{"$f":"I53+COUNTIFS(issues[OPENED ON],H54,issues[TYPE],type,issues[PRIORITY],priority)","v":17},{"$f":"J53+COUNTIFS(issues[CLOSED ON],H54,issues[TYPE],type,issues[PRIORITY],priority)","v":17}]
[{"$nulls":6},40,"2013-06-09",{"$f":"I54+COUNTIFS(issues[OPENED ON],H55,issues[TYPE],type,issues[PRIORITY],priority)","v":17},{"$f":"J54+COUNTIFS(issues[CLOSED ON],H55,issues[TYPE],type,issues[PRIORITY],priority)","v":18}]
[{"$nulls":6},41,"2013-06-10",{"$f":"I55+COUNTIFS(issues[OPENED ON],H56,issues[TYPE],type,issues[PRIORITY],priority)","v":17},{"$f":"J55+COUNTIFS(issues[CLOSED ON],H56,issues[TYPE],type,issues[PRIORITY],priority)","v":18}]
[{"$nulls":6},42,"2013-06-11",{"$f":"I56+COUNTIFS(issues[OPENED ON],H57,issues[TYPE],type,issues[PRIORITY],priority)","v":17},{"$f":"J56+COUNTIFS(issues[CLOSED ON],H57,issues[TYPE],type,issues[PRIORITY],priority)","v":18}]
[{"$nulls":6},43,"2013-06-12",{"$f":"I57+COUNTIFS(issues[OPENED ON],H58,issues[TYPE],type,issues[PRIORITY],priority)","v":18},{"$f":"J57+COUNTIFS(issues[CLOSED ON],H58,issues[TYPE],type,issues[PRIORITY],priority)","v":19}]
[{"$nulls":6},44,"2013-06-13",{"$f":"I58+COUNTIFS(issues[OPENED ON],H59,issues[TYPE],type,issues[PRIORITY],priority)","v":18},{"$f":"J58+COUNTIFS(issues[CLOSED ON],H59,issues[TYPE],type,issues[PRIORITY],priority)","v":19}]
[{"$nulls":6},45,"2013-06-14",{"$f":"I59+COUNTIFS(issues[OPENED ON],H60,issues[TYPE],type,issues[PRIORITY],priority)","v":18},{"$f":"J59+COUNTIFS(issues[CLOSED ON],H60,issues[TYPE],type,issues[PRIORITY],priority)","v":19}]
[{"$nulls":6},46,"2013-06-15",{"$f":"I60+COUNTIFS(issues[OPENED ON],H61,issues[TYPE],type,issues[PRIORITY],priority)","v":18},{"$f":"J60+COUNTIFS(issues[CLOSED ON],H61,issues[TYPE],type,issues[PRIORITY],priority)","v":19}]
[{"$nulls":6},47,"2013-06-16",{"$f":"I61+COUNTIFS(issues[OPENED ON],H62,issues[TYPE],type,issues[PRIORITY],priority)","v":18},{"$f":"J61+COUNTIFS(issues[CLOSED ON],H62,issues[TYPE],type,issues[PRIORITY],priority)","v":19}]
[{"$nulls":6},48,"2013-06-17",{"$f":"I62+COUNTIFS(issues[OPENED ON],H63,issues[TYPE],type,issues[PRIORITY],priority)","v":19},{"$f":"J62+COUNTIFS(issues[CLOSED ON],H63,issues[TYPE],type,issues[PRIORITY],priority)","v":20}]
[{"$nulls":6},49,"2013-06-18",{"$f":"I63+COUNTIFS(issues[OPENED ON],H64,issues[TYPE],type,issues[PRIORITY],priority)","v":22},{"$f":"J63+COUNTIFS(issues[CLOSED ON],H64,issues[TYPE],type,issues[PRIORITY],priority)","v":23}]
[{"$nulls":6},50,"2013-06-19",{"$f":"I64+COUNTIFS(issues[OPENED ON],H65,issues[TYPE],type,issues[PRIORITY],priority)","v":23},{"$f":"J64+COUNTIFS(issues[CLOSED ON],H65,issues[TYPE],type,issues[PRIORITY],priority)","v":24}]
[{"$nulls":6},51,"2013-06-20",{"$f":"I65+COUNTIFS(issues[OPENED ON],H66,issues[TYPE],type,issues[PRIORITY],priority)","v":23},{"$f":"J65+COUNTIFS(issues[CLOSED ON],H66,issues[TYPE],type,issues[PRIORITY],priority)","v":24}]
[{"$nulls":6},52,"2013-06-21",{"$f":"I66+COUNTIFS(issues[OPENED ON],H67,issues[TYPE],type,issues[PRIORITY],priority)","v":23},{"$f":"J66+COUNTIFS(issues[CLOSED ON],H67,issues[TYPE],type,issues[PRIORITY],priority)","v":24}]
[{"$nulls":6},53,"2013-06-22",{"$f":"I67+COUNTIFS(issues[OPENED ON],H68,issues[TYPE],type,issues[PRIORITY],priority)","v":23},{"$f":"J67+COUNTIFS(issues[CLOSED ON],H68,issues[TYPE],type,issues[PRIORITY],priority)","v":24}]
[{"$nulls":6},54,"2013-06-23",{"$f":"I68+COUNTIFS(issues[OPENED ON],H69,issues[TYPE],type,issues[PRIORITY],priority)","v":24},{"$f":"J68+COUNTIFS(issues[CLOSED ON],H69,issues[TYPE],type,issues[PRIORITY],priority)","v":25}]
[{"$nulls":6},55,"2013-06-24",{"$f":"I69+COUNTIFS(issues[OPENED ON],H70,issues[TYPE],type,issues[PRIORITY],priority)","v":24},{"$f":"J69+COUNTIFS(issues[CLOSED ON],H70,issues[TYPE],type,issues[PRIORITY],priority)","v":25}]
[{"$nulls":6},56,"2013-06-25",{"$f":"I70+COUNTIFS(issues[OPENED ON],H71,issues[TYPE],type,issues[PRIORITY],priority)","v":24},{"$f":"J70+COUNTIFS(issues[CLOSED ON],H71,issues[TYPE],type,issues[PRIORITY],priority)","v":25}]
[{"$nulls":6},57,"2013-06-26",{"$f":"I71+COUNTIFS(issues[OPENED ON],H72,issues[TYPE],type,issues[PRIORITY],priority)","v":24},{"$f":"J71+COUNTIFS(issues[CLOSED ON],H72,issues[TYPE],type,issues[PRIORITY],priority)","v":25}]
[{"$nulls":6},58,"2013-06-27",{"$f":"I72+COUNTIFS(issues[OPENED ON],H73,issues[TYPE],type,issues[PRIORITY],priority)","v":24},{"$f":"J72+COUNTIFS(issues[CLOSED ON],H73,issues[TYPE],type,issues[PRIORITY],priority)","v":25}]
[{"$nulls":6},59,"2013-06-28",{"$f":"I73+COUNTIFS(issues[OPENED ON],H74,issues[TYPE],type,issues[PRIORITY],priority)","v":26},{"$f":"J73+COUNTIFS(issues[CLOSED ON],H74,issues[TYPE],type,issues[PRIORITY],priority)","v":26}]
[{"$nulls":6},60,"2013-06-29",{"$f":"I74+COUNTIFS(issues[OPENED ON],H75,issues[TYPE],type,issues[PRIORITY],priority)","v":26},{"$f":"J74+COUNTIFS(issues[CLOSED ON],H75,issues[TYPE],type,issues[PRIORITY],priority)","v":26}]
[{"$nulls":6},61,"2013-06-30",{"$f":"I75+COUNTIFS(issues[OPENED ON],H76,issues[TYPE],type,issues[PRIORITY],priority)","v":26},{"$f":"J75+COUNTIFS(issues[CLOSED ON],H76,issues[TYPE],type,issues[PRIORITY],priority)","v":27}]
[{"$nulls":6},62,"2013-07-01",{"$f":"I76+COUNTIFS(issues[OPENED ON],H77,issues[TYPE],type,issues[PRIORITY],priority)","v":26},{"$f":"J76+COUNTIFS(issues[CLOSED ON],H77,issues[TYPE],type,issues[PRIORITY],priority)","v":27}]
[{"$nulls":6},63,"2013-07-02",{"$f":"I77+COUNTIFS(issues[OPENED ON],H78,issues[TYPE],type,issues[PRIORITY],priority)","v":26},{"$f":"J77+COUNTIFS(issues[CLOSED ON],H78,issues[TYPE],type,issues[PRIORITY],priority)","v":27}]
[{"$nulls":6},64,"2013-07-03",{"$f":"I78+COUNTIFS(issues[OPENED ON],H79,issues[TYPE],type,issues[PRIORITY],priority)","v":27},{"$f":"J78+COUNTIFS(issues[CLOSED ON],H79,issues[TYPE],type,issues[PRIORITY],priority)","v":28}]
[{"$nulls":6},65,{"$f":"keydate-days+G80","v":"2013-07-04"},{"$f":"I79+COUNTIFS(issues[OPENED ON],H80,issues[TYPE],type,issues[PRIORITY],priority)","v":29},{"$f":"J79+COUNTIFS(issues[CLOSED ON],H80,issues[TYPE],type,issues[PRIORITY],priority)","v":29}]