Spreadsheet: 830898d1685218133-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation
Sheet: BB

Code | [NAME] | Sr.No | From Date | To Date | From Load | To Load | Phase | [NAME] | Contract Demand | Rate/Month
IND |  | 133 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 1 | 40 | -- | -- | B | 90
IND |  | 134 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 41 | 60 | -- | -- | B | 130
IND |  | 135 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 61 | 100 | -- | -- | B | 195
IND |  | 136 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | -- | -- | -- | A | 265
IND |  | 137 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 1 | 40 | -- | -- | B | 90
IND |  | 138 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 41 | 60 | -- | -- | B | 130
IND |  | 139 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 61 | 100 | -- | -- | B | 195
IND |  | 140 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 0 | -- | -- | -- | A | 265
IND |  | 141 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 1 | 40 | -- | -- | B | 90
IND |  | 142 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 41 | 60 | -- | -- | B | 130
IND |  | 143 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 61 | 100 | -- | -- | B | 195
IND |  | 144 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 0 | -- | -- | -- | A | 265
IND |  | 145 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 1 | 40 | -- | -- | B | 90
IND |  | 146 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 41 | 60 | -- | -- | B | 130
IND |  | 147 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 61 | 100 | -- | -- | B | 195
IND |  | 148 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 0 | -- | -- | -- | A | 265
IND |  | 149 | 2022-10-29 00:00:00 | 2022-12-31 00:00:00 | 1 | 40 | -- | -- | B | 90
IND |  | 150 | 2022-10-29 00:00:00 | 2022-12-31 00:00:00 | 41 | 60 | -- | -- | B | 130
IND |  | 151 | 2022-10-29 00:00:00 | 2022-12-31 00:00:00 | 61 | 100 | -- | -- | B | 195
IND |  | 152 | 2022-10-29 00:00:00 | 2022-12-31 00:00:00 | 0 | -- | -- | -- | A | 265
IND |  | 153 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 1 | 40 | -- | -- | B | 90
IND |  | 154 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 41 | 60 | -- | -- | B | 130
IND |  | 155 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 61 | 100 | -- | -- | B | 195
IND |  | 156 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 0 | -- | -- | -- | A | 265
IND |  | 157 | 2023-04-01 00:00:00 | -- | 1 | 40 | -- | -- | B | 90
IND |  | 158 | 2023-04-01 00:00:00 | -- | 41 | 60 | -- | -- | B | 130
IND |  | 159 | 2023-04-01 00:00:00 | -- | 61 | 100 | -- | -- | B | 195
IND |  | 160 | 2023-04-01 00:00:00 | -- | 0 | -- | -- | -- | A | 265
AG |  | 34 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 35 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 36 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 37 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 1 | 7.5 | -- | -- | -- | 20
AG |  | 38 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 7.51 | 999 | -- | -- | -- | 20
AG |  | 39 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 7.51 | 999 | -- | -- | -- | 5
AG |  | 40 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 1 | 7.5 | -- | -- | -- | 10
AG |  | 41 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 7.51 | 999 | -- | -- | -- | 5
AG |  | 42 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 1 | 7.5 | -- | -- | -- | 10
AG |  | 43 | 2023-04-01 00:00:00 | -- | 7.51 | 999 | -- | -- | -- | 5
AG |  | 44 | 2023-04-01 00:00:00 | -- | 1 | 7.5 | -- | -- | -- | 10
DOM |  | 167 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | 2 | -- | -- | -- | 15
DOM |  | 168 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 169 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 170 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 6.01 | -- | -- | -- | -- | 70
DOM |  | 172 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 0 | 2 | -- | -- | -- | 15
DOM |  | 173 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 174 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 175 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 6.01 | -- | -- | -- | -- | 70
DOM |  | 177 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 0 | 2 | -- | -- | -- | 15
DOM |  | 178 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 179 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 180 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 6.01 | -- | -- | -- | -- | 70
DOM |  | 182 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 0 | 2 | -- | -- | -- | 15
DOM |  | 183 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 184 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 185 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 6.01 | -- | -- | -- | -- | 70
DOM |  | 187 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 0 | 2 | -- | -- | -- | 15
DOM |  | 188 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 189 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 190 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 6.01 | -- | -- | -- | -- | 70
DOM |  | 192 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 0 | 2 | -- | -- | -- | 15
DOM |  | 193 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 194 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 195 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 6.01 | -- | -- | -- | -- | 70
DOM |  | 197 | 2023-04-01 00:00:00 | -- | 0 | 2 | -- | -- | -- | 15
DOM |  | 198 | 2023-04-01 00:00:00 | -- | 2.01 | 4 | -- | -- | -- | 25
DOM |  | 199 | 2023-04-01 00:00:00 | -- | 4.01 | 6 | -- | -- | -- | 45
DOM |  | 200 | 2023-04-01 00:00:00 | -- | 6.01 | -- | -- | -- | -- | 70
COM |  | 67 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 1 | 10 | -- | -- | -- | 50
COM |  | 68 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 11 | 40 | -- | -- | -- | 85
COM |  | 69 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 1 | 10 | -- | -- | -- | 50
COM |  | 70 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 11 | 40 | -- | -- | -- | 85
COM |  | 71 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 1 | 10 | -- | -- | -- | 50
COM |  | 72 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 11 | 40 | -- | -- | -- | 85
COM |  | 73 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 1 | 10 | -- | -- | -- | 50
COM |  | 74 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 11 | 40 | -- | -- | -- | 85
COM |  | 75 | 2022-10-29 00:00:00 | 2022-12-31 00:00:00 | 1 | 10 | -- | -- | -- | 50
COM |  | 76 | 2022-10-29 00:00:00 | 2022-12-31 00:00:00 | 11 | 40 | -- | -- | -- | 85
COM |  | 77 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 1 | 10 | -- | -- | -- | 50
COM |  | 78 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 11 | 40 | -- | -- | -- | 85
COM |  | 79 | 2023-04-01 00:00:00 | -- | 1 | 10 | -- | -- | -- | 50
COM |  | 80 | 2023-04-01 00:00:00 | -- | 11 | 40 | -- | -- | -- | 85