Spreadsheet: 189522d1351206573-trouble-with-an-algorithm-multiple-data-sets-formula-help
Sheet: Sheet1

In the provided example the algorithm is analyzing Data Set 1 considering a selected date of 12/15/2012; This means that information before this selected date will be used in the algorithm.
**Notes located below Data Set 1**
Algorithm
V1(All Time) | V2(Current Month) | V5(All Time) |  | V3(Current Month) | V4(Current Month)
100.7647058823529 | 85.66666666666667 | 13.35294117647059 |  | 37.5 | 71.33333333333333
 | V6 |  |  | V7
 | 0.0880885856802482 |  |  | 52.57009345794393
 |  | Final Answer
 |  | 4.63082518178875
Data Set 1 |  |  |  |  |  |  | Data Set 2 |  |  |  |  |  |  | Data Set 3
 | V1 | V2 | V3 | V4 | V5 |  |  | V1 | V2 | V3 | V4 | V5 |  |  | V1 | V2 | V3 | V4 | V5
2012-11-06 00:00:00 | 92 | 83 | 36 | 76 | 11 |  | 2012-11-08 00:00:00 | 80 | 107 | 28 | 74 | 20 |  | 2012-11-08 00:00:00 | 106 | 96 | 37 | 78 | 16
2012-11-08 00:00:00 | 87 | 89 | 38 | 91 | 12 |  | 2012-11-10 00:00:00 | 117 | 122 | 36 | 77 | 20 |  | 2012-11-09 00:00:00 | 103 | 109 | 39 | 81 | 16
2012-11-11 00:00:00 | 112 | 107 | 43 | 79 | 10 |  | 2012-11-11 00:00:00 | 103 | 112 | 35 | 92 | 13 |  | 2012-11-10 00:00:00 | 90 | 99 | 37 | 83 | 13
2012-11-12 00:00:00 | 116 | 110 | 45 | 78 | 14 |  | 2012-11-12 00:00:00 | 96 | 104 | 38 | 87 | 12 |  | 2012-11-12 00:00:00 | 93 | 116 | 34 | 82 | 15
2012-11-18 00:00:00 | 114 | 83 | 50 | 76 | 14 |  | 2012-11-13 00:00:00 | 118 | 120 | 43 | 98 | 11 |  | 2012-11-15 00:00:00 | 93 | 101 | 34 | 79 | 15
2012-11-20 00:00:00 | 84 | 89 | 33 | 68 | 14 |  | 2012-11-15 00:00:00 | 113 | 106 | 37 | 71 | 18 |  | 2012-11-17 00:00:00 | 86 | 94 | 32 | 87 | 13
2012-11-21 00:00:00 | 101 | 102 | 34 | 71 | 12 |  | 2012-11-17 00:00:00 | 125 | 119 | 44 | 77 | 18 |  | 2012-11-18 00:00:00 | 90 | 79 | 30 | 74 | 15
2012-11-23 00:00:00 | 99 | 76 | 40 | 75 | 15 |  | 2012-11-19 00:00:00 | 124 | 115 | 35 | 76 | 11 |  | 2012-11-22 00:00:00 | 114 | 116 | 43 | 93 | 15
2012-11-24 00:00:00 | 89 | 83 | 35 | 78 | 10 |  | 2012-11-20 00:00:00 | 110 | 107 | 38 | 73 | 20 |  | 2012-11-23 00:00:00 | 90 | 106 | 35 | 81 | 13
2012-11-25 00:00:00 | 110 | 101 | 41 | 76 | 11 |  | 2012-11-21 00:00:00 | 99 | 95 | 36 | 75 | 15 |  | 2012-11-24 00:00:00 | 90 | 99 | 35 | 74 | 14
2012-11-28 00:00:00 | 106 | 87 | 44 | 87 | 13 |  | 2012-11-25 00:00:00 | 90 | 99 | 35 | 74 | 11 |  | 2012-11-26 00:00:00 | 102 | 86 | 43 | 84 | 5
2012-12-02 00:00:00 | 99 | 95 | 36 | 63 | 17 |  | 2012-11-26 00:00:00 | 125 | 116 | 41 | 88 | 18 |  | 2012-11-28 00:00:00 | 88 | 79 | 31 | 66 | 13
2012-12-03 00:00:00 | 104 | 92 | 43 | 81 | 9 |  | 2012-11-30 00:00:00 | 111 | 100 | 41 | 80 | 12 |  | 2012-12-01 00:00:00 | 88 | 93 | 36 | 83 | 11
2012-12-04 00:00:00 | 100 | 75 | 39 | 77 | 13 |  | 2012-12-01 00:00:00 | 100 | 92 | 39 | 83 | 14 |  | 2012-12-05 00:00:00 | 109 | 91 | 41 | 79 | 11
2012-12-07 00:00:00 | 105 | 89 | 38 | 68 | 19 |  | 2012-12-03 00:00:00 | 116 | 99 | 43 | 88 | 11 |  | 2012-12-06 00:00:00 | 117 | 97 | 42 | 81 | 7
2012-12-11 00:00:00 | 102 | 101 | 38 | 68 | 15 |  | 2012-12-04 00:00:00 | 121 | 114 | 45 | 85 | 10 |  | 2012-12-10 00:00:00 | 101 | 102 | 37 | 81 | 11
2012-12-12 00:00:00 | 93 | 62 | 31 | 71 | 18 |  | 2012-12-07 00:00:00 | 113 | 110 | 43 | 89 | 15 |  | 2012-12-12 00:00:00 | 88 | 70 | 33 | 77 | 14
2012-12-15 00:00:00 | 118 | 116 | 45 | 86 | 13 |  | 2012-12-11 00:00:00 | 101 | 95 | 34 | 75 | 20 |  | 2012-12-13 00:00:00 | 82 | 77 | 30 | 74 | 12
2012-12-17 00:00:00 | 102 | 90 | 44 | 83 | 12 |  | 2012-12-12 00:00:00 | 129 | 125 | 46 | 88 | 6 |  | 2012-12-16 00:00:00 | 105 | 91 | 40 | 91 | 3
2012-12-19 00:00:00 | 99 | 88 | 41 | 76 | 18 |  | 2012-12-14 00:00:00 | 116 | 118 | 43 | 81 | 17 |  | 2012-12-18 00:00:00 | 81 | 93 | 33 | 88 | 13
2012-12-20 00:00:00 | 84 | 80 | 31 | 80 | 10 |  | 2012-12-16 00:00:00 | 91 | 113 | 35 | 89 | 13 |  | 2012-12-19 00:00:00 | 97 | 89 | 34 | 77 | 12
12/15/2012 is the selected date thus no information will be used for this date or any date following it (indicated in red text).
Each variable is an average of the data associated with it. The data used is based on the selected date with V1 and V3 being all time variables and [NAME], V4, and V5 using data only from the current month that is before the selected date.
V6 = (V1/V2)/V3
V7 = (V3/V4)*100
Final Answer = V6*V7
Different data sets will have different dates to choose from.