Spreadsheet: 879156d1726600645-pickup-the-last-value-in-a-row-and-paste-it-into-a-specific-cell-just-energy-sample
Sheet: Test Sheet

Billing Start date MM/DD/YYYY |  | 2024-09-01 00:00:00
Start Time | End Time | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export
12:00 am | 12:15 am
12:15 am | 12:30 am
12:30 am | 12:45 am
12:45 am | 01:00 am
01:00 am | 01:15 am
01:15 am | 01:30 am
01:30 am | 01:45 am
01:45 am | 02:00 am
02:00 am | 02:15 am
02:15 am | 02:30 am
02:30 am | 02:45 am
02:45 am | 03:00 am
03:00 am | 03:15 am
03:15 am | 03:30 am
03:30 am | 03:45 am
03:45 am | 04:00 am
04:00 am | 04:15 am
04:15 am | 04:30 am
04:30 am | 04:45 am
04:45 am | 05:00 am
05:00 am | 05:15 am
05:15 am | 05:30 am
05:30 am | 05:45 am
05:45 am | 06:00 am
06:00 am | 06:15 am
06:15 am | 06:30 am
06:30 am | 06:45 am
06:45 am | 07:00 am
07:00 am | 07:15 am
07:15 am | 07:30 am
07:30 am | 07:45 am
07:45 am | 08:00 am
08:00 am | 08:15 am
08:15 am | 08:30 am
08:30 am | 08:45 am
08:45 am | 09:00 am
09:00 am | 09:15 am
09:15 am | 09:30 am
09:30 am | 09:45 am
09:45 am | 10:00 am
10:00 am | 10:15 am
10:15 am | 10:30 am
10:30 am | 10:45 am
10:45 am | 11:00 am
11:00 am | 11:15 am
11:15 am | 11:30 am
11:30 am | 11:45 am
11:45 am | 12:00 pm
12:00 pm | 12:15 pm
12:15 pm | 12:30 pm
12:30 pm | 12:45 pm
12:45 pm | 01:00 pm
01:00 pm | 01:15 pm
01:15 pm | 01:30 pm
01:30 pm | 01:45 pm
01:45 pm | 02:00 pm
02:00 pm | 02:15 pm
02:15 pm | 02:30 pm
02:30 pm | 02:45 pm
02:45 pm | 03:00 pm
03:00 pm | 03:15 pm
03:15 pm | 03:30 pm
03:30 pm | 03:45 pm
03:45 pm | 04:00 pm
04:00 pm | 04:15 pm
04:15 pm | 04:30 pm
04:30 pm | 04:45 pm
04:45 pm | 05:00 pm
05:00 pm | 05:15 pm
05:15 pm | 05:30 pm
05:30 pm | 05:45 pm
05:45 pm | 06:00 pm
06:00 pm | 06:15 pm
06:15 pm | 06:30 pm
06:30 pm | 06:45 pm
06:45 pm | 07:00 pm
07:00 pm | 07:15 pm
07:15 pm | 07:30 pm
07:30 pm | 07:45 pm
07:45 pm | 08:00 pm
08:00 pm | 08:15 pm
08:15 pm | 08:30 pm
08:30 pm | 08:45 pm
08:45 pm | 09:00 pm
09:00 pm | 09:15 pm
09:15 pm | 09:30 pm
09:30 pm | 09:45 pm
09:45 pm | 10:00 pm
10:00 pm | 10:15 pm
10:15 pm | 10:30 pm
10:30 pm | 10:45 pm
10:45 pm | 11:00 pm
11:00 pm | 11:15 pm
11:15 pm | 11:30 pm
11:30 pm | 11:45 pm
11:45 pm | 12:00 am
Consumption |  | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD
00:00:00 | 07:00:00
07:00:00 | 21:00:00
21:00:00 | 00:00:00
Total Consumption per Smart Meter
Consumption per System
7am - 9pm Consumption
[NAME] kWh/day (7am-9pm)
Night Usage (9pm-7am)
Exported
Production per System
Exported to Grid per Smart Meter
Exported to Grid per System
Exported to grid per Provider
Start Time | End Time | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export
12:00 am | 12:15 am
12:15 am | 12:30 am
12:30 am | 12:45 am
12:45 am | 01:00 am
01:00 am | 01:15 am
01:15 am | 01:30 am
01:30 am | 01:45 am
01:45 am | 02:00 am
02:00 am | 02:15 am
02:15 am | 02:30 am
02:30 am | 02:45 am
02:45 am | 03:00 am
03:00 am | 03:15 am
03:15 am | 03:30 am
03:30 am | 03:45 am
03:45 am | 04:00 am
04:00 am | 04:15 am
04:15 am | 04:30 am
04:30 am | 04:45 am
04:45 am | 05:00 am
05:00 am | 05:15 am
05:15 am | 05:30 am
05:30 am | 05:45 am
05:45 am | 06:00 am
06:00 am | 06:15 am
06:15 am | 06:30 am
06:30 am | 06:45 am
06:45 am | 07:00 am
07:00 am | 07:15 am
07:15 am | 07:30 am
07:30 am | 07:45 am
07:45 am | 08:00 am
08:00 am | 08:15 am
08:15 am | 08:30 am
08:30 am | 08:45 am
08:45 am | 09:00 am
09:00 am | 09:15 am
09:15 am | 09:30 am
09:30 am | 09:45 am
09:45 am | 10:00 am
10:00 am | 10:15 am
10:15 am | 10:30 am
10:30 am | 10:45 am
10:45 am | 11:00 am
11:00 am | 11:15 am
11:15 am | 11:30 am
11:30 am | 11:45 am
11:45 am | 12:00 pm
12:00 pm | 12:15 pm
12:15 pm | 12:30 pm
12:30 pm | 12:45 pm
12:45 pm | 01:00 pm
01:00 pm | 01:15 pm
01:15 pm | 01:30 pm
01:30 pm | 01:45 pm
01:45 pm | 02:00 pm
02:00 pm | 02:15 pm
02:15 pm | 02:30 pm
02:30 pm | 02:45 pm
02:45 pm | 03:00 pm
03:00 pm | 03:15 pm
03:15 pm | 03:30 pm
03:30 pm | 03:45 pm
03:45 pm | 04:00 pm
04:00 pm | 04:15 pm
04:15 pm | 04:30 pm
04:30 pm | 04:45 pm
04:45 pm | 05:00 pm
05:00 pm | 05:15 pm
05:15 pm | 05:30 pm
05:30 pm | 05:45 pm
05:45 pm | 06:00 pm
06:00 pm | 06:15 pm
06:15 pm | 06:30 pm
06:30 pm | 06:45 pm
06:45 pm | 07:00 pm
07:00 pm | 07:15 pm
07:15 pm | 07:30 pm
07:30 pm | 07:45 pm
07:45 pm | 08:00 pm
08:00 pm | 08:15 pm
08:15 pm | 08:30 pm
08:30 pm | 08:45 pm
08:45 pm | 09:00 pm
09:00 pm | 09:15 pm
09:15 pm | 09:30 pm
09:30 pm | 09:45 pm
09:45 pm | 10:00 pm
10:00 pm | 10:15 pm
10:15 pm | 10:30 pm
10:30 pm | 10:45 pm
10:45 pm | 11:00 pm
11:00 pm | 11:15 pm
11:15 pm | 11:30 pm
11:30 pm | 11:45 pm
11:45 pm | 12:00 am
Consumption |  | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD
00:00:00 | 07:00:00
07:00:00 | 21:00:00
21:00:00 | 00:00:00
Total Consumption per Smart Meter
Consumption per System
7am - 9pm Consumption
[NAME] kWh/day (7am-9pm)
Night Usage (9pm-7am)
Exported
Production per System
Exported to Grid per Smart Meter
Exported to Grid per System
Exported to grid per Provider
Start Time | End Time | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export | Consumption | Export
12:00 am | 12:15 am
12:15 am | 12:30 am
12:30 am | 12:45 am
12:45 am | 01:00 am
01:00 am | 01:15 am
01:15 am | 01:30 am
01:30 am | 01:45 am
01:45 am | 02:00 am
02:00 am | 02:15 am
02:15 am | 02:30 am
02:30 am | 02:45 am
02:45 am | 03:00 am
03:00 am | 03:15 am
03:15 am | 03:30 am
03:30 am | 03:45 am
03:45 am | 04:00 am
04:00 am | 04:15 am
04:15 am | 04:30 am
04:30 am | 04:45 am
04:45 am | 05:00 am
05:00 am | 05:15 am
05:15 am | 05:30 am
05:30 am | 05:45 am
05:45 am | 06:00 am
06:00 am | 06:15 am
06:15 am | 06:30 am
06:30 am | 06:45 am
06:45 am | 07:00 am
07:00 am | 07:15 am
07:15 am | 07:30 am
07:30 am | 07:45 am
07:45 am | 08:00 am
08:00 am | 08:15 am
08:15 am | 08:30 am
08:30 am | 08:45 am
08:45 am | 09:00 am
09:00 am | 09:15 am
09:15 am | 09:30 am
09:30 am | 09:45 am
09:45 am | 10:00 am
10:00 am | 10:15 am
10:15 am | 10:30 am
10:30 am | 10:45 am
10:45 am | 11:00 am
11:00 am | 11:15 am
11:15 am | 11:30 am
11:30 am | 11:45 am
11:45 am | 12:00 pm
12:00 pm | 12:15 pm
12:15 pm | 12:30 pm
12:30 pm | 12:45 pm
12:45 pm | 01:00 pm
01:00 pm | 01:15 pm
01:15 pm | 01:30 pm
01:30 pm | 01:45 pm
01:45 pm | 02:00 pm
02:00 pm | 02:15 pm
02:15 pm | 02:30 pm
02:30 pm | 02:45 pm
02:45 pm | 03:00 pm
03:00 pm | 03:15 pm
03:15 pm | 03:30 pm
03:30 pm | 03:45 pm
03:45 pm | 04:00 pm
04:00 pm | 04:15 pm
04:15 pm | 04:30 pm
04:30 pm | 04:45 pm
04:45 pm | 05:00 pm
05:00 pm | 05:15 pm
05:15 pm | 05:30 pm
05:30 pm | 05:45 pm
05:45 pm | 06:00 pm
06:00 pm | 06:15 pm
06:15 pm | 06:30 pm
06:30 pm | 06:45 pm
06:45 pm | 07:00 pm
07:00 pm | 07:15 pm
07:15 pm | 07:30 pm
07:30 pm | 07:45 pm
07:45 pm | 08:00 pm
08:00 pm | 08:15 pm
08:15 pm | 08:30 pm
08:30 pm | 08:45 pm
08:45 pm | 09:00 pm
09:00 pm | 09:15 pm
09:15 pm | 09:30 pm
09:30 pm | 09:45 pm
09:45 pm | 10:00 pm
10:00 pm | 10:15 pm
10:15 pm | 10:30 pm
10:30 pm | 10:45 pm
10:45 pm | 11:00 pm
11:00 pm | 11:15 pm
11:15 pm | 11:30 pm
11:30 pm | 11:45 pm
11:45 pm | 12:00 am
Consumption |  | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD | Daily | MTD
00:00:00 | 07:00:00
07:00:00 | 21:00:00
21:00:00 | 00:00:00
Consumption per Smart Meter
Consumption per System
7am - 9pm Consumption |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Energy Charges kWh
[NAME] kWh/day (7am-9pm)
Night Usage (9pm-7am) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nights Free Energy Credit kWh
Exported
Production per System
Exported to Grid per Smart Meter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | kWh that you will be credited for
Exported to Grid per System
Exported to grid per Provider