Spreadsheet: 45211d1243979913-ignore-blanks-using-sumif-countif-sumifcountif-sample
Sheet: Sample

RELIABILITY (Monthly per unit)
 |  |  |  |  |  |  | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
 |  |  | Solar
 |  |  | Solar
 |  |  | Solar
 |  |  | Solar
 |  |  | Other 1
 |  |  | Other 1
 |  |  | Solar
 |  |  | Solar
 |  |  | Solar
 |  |  | Solar |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 0.9946 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 1 | 1 | 1 | 1 | 0.8833 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 0.9944 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 1 | 1 | 1 | 0.8226 | 0.9833 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.9985 | 0.9758 | 0.8666666666666667 | 0.9838709677419355 | 1 | 1 | 0.9986559139784947 | 1 | 0.9516129032258065 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 1 | 1 | 0.9694444444444444 | 0.9919354838709677 | 0.9916666666666667 | 0.967741935483871 | 0.9946236559139785 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 1 | 0.9745 | 0.9736111111111111 | 0.9637096774193549 | 1 | 0.9784946236559139 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.9777 | 1 | 0.9875 | 0.9623655913978494 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 0.15 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.994 | 1 | 0.9055555555555556 | 1 | 1 | 1 | 1 | 0.9861111111111112 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 0.957 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.9985119047619048 | 0.7096774193548387 | 0.8 | 0.7043010752688171 | 1 | 0.9032258064516129 | 0.9879032258064516 | 1 | 0.9986559139784946 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.5952380952380952 | 0.9166666666666667 | 0.9888888888888888 | 0.9919354838709677 | 0.9652777777777779 | 1 | 0.9959677419354839 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.5892857142857144 | 0.9314516129032258 | 0.9236111111111112 | 0.9879032258064516 | 1 | 1 | 1 | 1 | 0.9879032258064516 |  |  |  |  |  | 0.9833 | 0.996 | 0.8833 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.9776785714285714 | 0.9368279569892474 | 0.9958333333333333 | 0.9838709677419355 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Solar |  |  |  | 1 | 0.9940476190476192 | 0.9932795698924731 | 0.9972222222222221 | 0.9879032258064516 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 0.9667 | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.9839 | 0.9694 | 0.9899 | 1 | 0.9987 | 0.9866 | 0.9591 | 0.9556 | 0.8958 | 0.9736 | 0.9736 | 0.9861 | 0.7392 | 0 | 0 | 0.2278 | 1 | 0.9486
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 1 | 0.9993 | 1 | 1 | 1 | 0.9879 | 0.9727 | 0.9503 | 1 | 0.9973 | 1 | 0.9503 | 1 | 1 | 1 | 1 | 0.789 | 0.789
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0.9987 | 1 | 1 | 1 | 0.9943 | 0.9167 | 1 | 0.9987 | 1 | 1 | 1 | 0.9653 | 1 | 1 | 0.9919 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.8797 | 0.8056 | 0 | 0.9875 | 0.9419 | 0.9389 | 0.995 | 0.9014 | 0.9986 | 0.9919 | 1 | 0.9341 | 0.6431 | 0.991 | 1 | 1 | 1 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.9677 | 0.9972 | 1 | 0.9986 | 1 | 0.9987 | 0.9828 | 0.9892 | 1 | 0.9906 | 1 | 0.8508 | 1 | 1 | 1 | 1 | 0.9987 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 1 | 0.9972 | 1 | 0.9987 | 0.9993 | 0.7997 | 0.4111 | 1 | 0.9264 | 0.9488 | 0.9032 | 0.9986 | 1 | 0.9986 | 1 | 0.9906
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0.9987 | 1 | 0.9758 | 0.8938 | 0.9583 | 0.8952 | 1 | 0.9919 | 1 | 0.9879 | 0.8253 | 1 | 1 | 1 | 0.9987 | 0.9677
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 0.9113 | 0.5603 | 0.8898 | 1 | 1 | 0.9986 | 0.9839 | 0.7608 | 1 | 1 | 1 | 1 | 0.9946
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 0.9972 | 0.5114 | 0 | 0 | 0.871 | 1 | 1 | 0.9944 | 0.9825 | 0.9651 | 0.9778 | 1 | 1 | 1 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 0.9417 | 1 | 0.8978 | 0.9626 | 0.753 | 1 | 0.5995 | 0.4097 | 0.8978 | 0.9866 | 1 | 1 | 1 | 0.9792 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.0968 | 0.9341 | 0.9943 | 1 | 1 | 0.6522 | 0.2 | 0.4099 | 1 | 1 | 1 | 1 | 1 | 0.9825
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0.996 | 1 | 0.9597 | 0.9986 | 1 | 0.7583 | 0.7196 | 1 | 0.9944 | 1 | 1 | 1 | 0.9731
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.2581
 |  |  | Other 2
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9 | 1 | 0.4658 | 0.8898 | 0.9866 | 0.75 | 0.1833 | 0.6078 | 0.996 | 0.9987
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6778 | 0.9973 | 0.9695 | 1 | 0.9987 | 0.9986 | 0.9845 | 0.7222 | 0.6559 | 0.5941
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8833 | 1 | 0.9643 | 0.918 | 0.9745 | 1 | 0.9536 | 0.9958 | 1 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.996 | 0.9896 | 0.8387 | 0.7419 | 0.4333 | 1 | 0.6875 | 0.6613 | 0.9933
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.7419 | 0.5179 | 0.6801 | 0.3226 | 1 | 1 | 0.9679 | 0.9987 | 0.6304
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0.9892 | 1 | 0.9972 | 0.9973 | 0.5639 | 0.8871 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0833 | 0.5161 | 0.9368 | 1 | 0 | 0.0345 | 1 | 0.9987
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.8548 | 0.3871 | 0.6917 | 1 | 1 | 0.9778 | 0.8387
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.9442 | 0.9979 | 1 | 0.9882 | 0.9654 | 0.9987 | 0.9802 | 0.9026 | 0.9944 | 1 | 0.9986 | 0.9933 | 1 | 0.9986 | 1 | 0.8965 | 1 | 0.8938
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.9906 | 1 | 1 | 0.9931 | 0.9933 | 1 | 1 | 0.9953 | 0.9917 | 0.9714 | 0.996 | 0.9832 | 0.9745 | 0.9896 | 0 | 0.9649 | 0.9987 | 1
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.9798 | 0.7 | 1 | 0.9931 | 0.8965 | 0.9987 | 1 | 0.9701 | 0.9849 | 0.9698 | 1 | 1 | 1 | 0.9917 | 0.9677 | 0.7667 | 0 | 0
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.798 | 0.962 | 0.8911 | 0.977 | 0.914 | 0.8705 | 0.9684 | 0.9583 | 0.9624 | 0.9966 | 0.9847 | 0.9987 | 0.9941 | 1 | 0.9812
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9884 | 0.9825 | 0.9684
 |  |  | Other 2 |  |  |  |  |  |  |  |  |  |  | 0.873 | 0.9458 | 1 | 0.8972 | 1 | 0.9926 | 0.9717 | 0.9825 | 0.9785 | 0.9396 | 0.6979 | 0.9909 | 0.996 | 0.9681 | 0.9731 | 0.9785 | 1 | 1
RELIABILITY (Monthly per Badge) |  |  |  | Badge |  |  | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
 |  |  |  | Solar |  |  | 0.6666666666666666
 |  |  |  | Other 1
 |  |  |  | Other 2