Forgot to add some data rowid id meterId pollDate pollTime interval importKwh importCost importKwhRate periodType line1Part line2Part line3Part reversePart reverseIncome reverseKwhRate kWhsGenerated exportIntervalRate assumedConsumptionBenefit pfactor p1ave p2ave p3ave toGrid selfConsumed dateCreated time_stamp 1 1 5 1899-12-30 00:00:00.000 2014-12-29 07:30:01.000 15 6 0.01962 0.327 2 6 0 27 27 0.18414 0.682 27 0.681999981403351 0.07521 L096 109 0 279 4 23 2014-12-29 08:28:52.000 201412290828 2 2 5 1899-12-30 00:00:00.000 2014-12-29 08:00:00.000 16 18 0.03204 0.178 1 18 0 41 41 0.27962 0.682 41 0.178 0.06052 L080 247 0 409 7 34 2014-12-29 08:58:51.000 201412290858 3 3 5 1899-12-30 00:00:00.000 2014-12-29 08:30:00.000 17 1 0.00178 0.178 1 1 0 64 64 0.43648 0.682 64 0.178 0.04806 C099 375 0 633 37 27 2014-12-29 09:28:50.000 201412290928 4 4 5 1899-12-30 00:00:00.000 2014-12-29 09:00:00.000 18 -1 -0.00178 0.178 1 -1 0 56 56 0.38192 0.682 56 0.178 0.03382 C097 366 0 562 37 19 2014-12-29 09:58:50.000 201412290958 5 5 5 1899-12-30 00:00:00.000 2014-12-29 09:30:00.000 19 1 0.00178 0.178 1 1 0 84 84 0.57288 0.682 84 0.178 0.04806 C099 574 0 840 57 27 2014-12-29 10:28:50.000 201412291028 6 6 5 1899-12-30 00:00:00.000 2014-12-29 10:00:00.000 20 3 0.00534 0.178 1 3 0 67 67 0.45694 0.682 67 0.178 0.08544 L024 217 0 662 19 48 2014-12-29 10:58:51.000 201412291058 7 7 5 1899-12-30 00:00:00.000 2014-12-29 10:30:00.000 21 2 0.00356 0.178 1 2 0 46 46 0.31372 0.682 46 0.178 0.05518 C090 166 0 461 15 31 2014-12-29 11:28:50.000 201412291128 8 8 5 1899-12-30 00:00:00.000 2014-12-29 11:00:00.000 22 1 0.00178 0.178 1 1 0 42 42 0.28644 0.682 42 0.178 0.03916 C098 205 0 420 20 22 2014-12-29 11:58:51.000 201412291158 9 9 5 1899-12-30 00:00:00.000 2014-12-29 11:30:00.000 23 4 0.00712 0.178 1 4 0 29 29 0.19778 0.682 29 0.178 0.03026 C091 169 0 287 12 17 2014-12-29 12:28:51.000 201412291228 10 10 5 1899-12-30 00:00:00.000 2014-12-29 12:00:00.000 24 0 0 0.178 1 0 0 80 80 0.5456 0.682 80 0.178 0.04272 L082 557 0 802 56 24 2014-12-29 12:58:51.000 201412291258 11 11 5 1899-12-30 00:00:00.000 2014-12-29 12:30:00.000 25 26 0.04628 0.178 1 26 0 20 20 0.1364 0.682 20 0.178 0.03382 C092 266 0 201 1 19 2014-12-29 13:28:50.000 201412291328 12 12 5 1899-12-30 00:00:00.000 2014-12-29 13:00:00.000 26 4 0.00712 0.178 1 4 0 28 28 0.19096 0.682 28 0.178 0.0267 C074 174 0 279 13 15 2014-12-29 13:58:50.000 201412291358 13 13 5 1899-12-30 00:00:00.000 2014-12-29 13:30:00.000 27 12 0.02136 0.178 1 12 0 10 10 0.0682 0.682 10 0.178 0.0178 L099 118 0 101 0 10 2014-12-29 14:28:51.000 201412291428 14 14 5 1899-12-30 00:00:00.000 2014-12-29 14:00:00.000 28 40 0.0712 0.178 1 40 0 18 18 0.12276 0.682 18 0.178 0.03026 C072 412 0 179 1 17 2014-12-29 14:58:50.000 201412291458 15 15 5 1899-12-30 00:00:00.000 2014-12-29 14:30:00.000 29 1 0.00178 0.178 1 1 0 117 117 0.79794 0.682 117 0.178 0.06052 100 838 0 1164 83 34 2014-12-29 15:28:50.000 201412291528