Is it possible to have a vba script to generate daily chart sheets (one day per chart sheet) from a worksheet data set?
Any help would be greatly appreciated.
Example data set
<colgroup><col><col span="19"></colgroup><tbody>
</tbody>
Any help would be greatly appreciated.
Example data set
Date | Time | Lmax | L1 | L5 | L10 | L50 | L90 | L95 | L99 | Lmin | Leq | Relative Humidity (%) | Temp (Deg C) | Temp 2 (Deg C) | Rainfall (mm) | Mean Wind Speed (m/s) | Gust Wind Speed (m/s) | Solar Radiation (W/m^2) | Wind Direction (Degrees) |
28-Nov-17 | 13:15 | 91.3 | 67 | 61.7 | 59.3 | 55.1 | 52.8 | 52.1 | 51.1 | 50.2 | 59.5 | 100 | 18.9 | 0 | 1.944444 | 67.5 | |||
28-Nov-17 | 13:30 | 87.2 | 66 | 60.6 | 58.4 | 53.9 | 52.2 | 51.9 | 51.1 | 49.6 | 58.1 | - | 19.1 | 0 | 2.5 | 67.5 | |||
28-Nov-17 | 13:45 | 80.2 | 70.3 | 63.9 | 60.5 | 53.9 | 51.8 | 51.3 | 50.9 | 49.9 | 59.3 | 100 | 19 | 0 | 1.944444 | 90 | |||
28-Nov-17 | 14:00 | 73.2 | 65.7 | 61.6 | 59.8 | 55.8 | 54.2 | 53.8 | 52.7 | 52.2 | 57.7 | - | 18.5 | 0 | 1.111111 | 180 | |||
28-Nov-17 | 14:15 | 72 | 63.6 | 60 | 58.3 | 55.2 | 53.4 | 53 | 52.1 | 52 | 56.5 | 100 | 18.9 | 0 | 1.111111 | 157.5 | |||
28-Nov-17 | 14:30 | 83.8 | 76.5 | 65 | 61 | 55.8 | 53.9 | 53.3 | 52.4 | 50.8 | 62.9 | - | 18.7 | 0 | 1.111111 | 112.5 | |||
28-Nov-17 | 14:45 | 73.2 | 69.1 | 63.9 | 61.3 | 58.3 | 56.3 | 54.9 | 53.2 | 52.4 | 60 | 100 | 18.6 | 0 | 1.111111 | 112.5 | |||
28-Nov-17 | 15:00 | 72.5 | 64.2 | 61.3 | 59.3 | 55.8 | 54.2 | 53.9 | 53.1 | 52.4 | 57.2 | - | 18.6 | 0 | 1.666667 | 135 | |||
28-Nov-17 | 15:15 | 79.9 | 67.2 | 63.1 | 61 | 56.5 | 54.7 | 54.3 | 53.5 | 52.7 | 59.2 | 100 | 18.9 | 0 | 1.111111 | 135 | |||
28-Nov-17 | 15:30 | 73.7 | 66 | 61.6 | 59.9 | 56.2 | 53.9 | 53.3 | 52.4 | 52 | 58 | - | 18.9 | 0 | 0.555556 | 360 | |||
28-Nov-17 | 15:45 | 76.7 | 67.2 | 62.1 | 60.5 | 56.2 | 53.4 | 52.8 | 51.6 | 49.2 | 58.3 | 100 | 19 | 0 | 0.555556 | 315 | |||
28-Nov-17 | 16:00 | 80 | 67.4 | 61.7 | 59.7 | 55.7 | 53.2 | 52.5 | 51.4 | 50.8 | 58 | - | 18.3 | 0 | 1.944444 | 135 | |||
28-Nov-17 | 16:15 | 78.4 | 64.8 | 61.8 | 60 | 54.1 | 50.7 | 50 | 48.7 | 47.8 | 56.8 | 100 | 18.3 | 0 | 2.5 | 135 | |||
28-Nov-17 | 16:30 | 79.7 | 67.8 | 61.9 | 59.3 | 52.7 | 49.1 | 48 | 46.5 | 45.3 | 57 | - | 18.5 | 0 | 1.666667 | 180 | |||
28-Nov-17 | 16:45 | 85.4 | 70.1 | 61.6 | 59.4 | 52.4 | 48.9 | 48 | 46.4 | 45.1 | 58.9 | 100 | 18.5 | 0 | 1.111111 | 135 | |||
28-Nov-17 | 17:00 | 75.7 | 70.4 | 62.6 | 60.2 | 53.1 | 48.6 | 47.8 | 46.5 | 45.5 | 57.9 | - | 18.9 | 0 | 1.666667 | 157.5 | |||
28-Nov-17 | 17:15 | 83.6 | 66.6 | 61.5 | 59.4 | 53 | 49 | 48 | 46.4 | 45.6 | 59.2 | 100 | 18.4 | 0 | 1.666667 | 157.5 | |||
28-Nov-17 | 17:30 | 76.2 | 65.2 | 61 | 58.8 | 53 | 48.8 | 47.7 | 46.2 | 44.8 | 56.2 | - | 18.1 | 0 | 1.944444 | 180 | |||
28-Nov-17 | 17:45 | 76.8 | 65.4 | 61.9 | 59.3 | 52.6 | 48.7 | 47.5 | 45.7 | 44.4 | 56.2 | 100 | 18.2 | 0 | 1.944444 | 180 | |||
28-Nov-17 | 18:00 | 79.9 | 64.6 | 60.7 | 58.2 | 52.2 | 47.5 | 46.6 | 45 | 43 | 55.7 | - | 18.2 | 0 | 1.666667 | 157.5 | |||
28-Nov-17 | 18:15 | 73 | 63.5 | 59.2 | 56.7 | 50.5 | 46 | 45 | 43.1 | 41.5 | 53.7 | 100 | 18.1 | 0 | 1.666667 | 135 | |||
28-Nov-17 | 18:30 | 75.4 | 63.9 | 59.9 | 57.8 | 51.2 | 46.8 | 46.1 | 45 | 43.1 | 55 | - | 18.4 | 0 | 1.111111 | 90 | |||
28-Nov-17 | 18:45 | 72.3 | 64.7 | 60.9 | 58.4 | 51.6 | 45.6 | 44.6 | 43.3 | 41.5 | 55.2 | 100 | 18.4 | 0 | 1.666667 | 90 | |||
28-Nov-17 | 19:00 | 81.4 | 64.3 | 61.2 | 59 | 52.2 | 47.1 | 45.9 | 44.3 | 42.7 | 57.2 | - | 18.5 | 0 | 1.111111 | 112.5 | |||
28-Nov-17 | 19:15 | 69.5 | 61.1 | 58.3 | 56.4 | 51.8 | 50 | 49.6 | 49 | 48.3 | 53.7 | 100 | 18.6 | 0 | 0.555556 | 135 | |||
28-Nov-17 | 19:30 | 81.5 | 71.1 | 63 | 61 | 53.8 | 50.7 | 50.2 | 49.3 | 48.7 | 59.3 | - | 18.4 | 0 | 2.5 | 180 | |||
28-Nov-17 | 19:45 | 68.1 | 62.6 | 57.5 | 55.6 | 51.5 | 49.7 | 49.3 | 48.7 | 48.3 | 53.6 | 100 | 17.9 | 0 | 3.611111 | 180 | |||
28-Nov-17 | 20:00 | 75.9 | 67.2 | 60.5 | 58.2 | 51.9 | 49.4 | 49 | 48.1 | 47.3 | 56.1 | - | 18.3 | 0 | 2.5 | 202.5 | |||
28-Nov-17 | 20:15 | 65.8 | 61.3 | 58.2 | 56.7 | 53.1 | 49.7 | 49.2 | 48.3 | 47.9 | 54.2 | 100 | 18.5 | 0 | 2.5 | 180 | |||
28-Nov-17 | 20:30 | 71.5 | 64.1 | 60.2 | 57.9 | 53.4 | 51.5 | 51.1 | 50.2 | 49.5 | 55.5 | - | 18.3 | 0 | 3.611111 | 180 | |||
28-Nov-17 | 20:45 | 68.4 | 64.3 | 60.4 | 58.5 | 53.9 | 51.6 | 51.1 | 50.2 | 49.4 | 55.8 | 100 | 18.5 | 0 | 3.611111 | 180 | |||
28-Nov-17 | 21:00 | 67.8 | 62.2 | 58.7 | 57 | 53.7 | 50.8 | 50.2 | 49.3 | 48.4 | 54.8 | - | 18.8 | 0 | 3.055556 | 202.5 | |||
28-Nov-17 | 21:15 | 69.4 | 63.8 | 59.2 | 56.7 | 52.5 | 50.4 | 50.1 | 49.2 | 48.3 | 54.7 | 100 | 19.3 | 0 | 3.055556 | 180 | |||
28-Nov-17 | 21:30 | 69.9 | 63.7 | 58.4 | 56.6 | 53 | 50.5 | 50.1 | 49.3 | 49.1 | 54.7 | - | 19.1 | 0 | 4.166667 | 180 | |||
28-Nov-17 | 21:45 | 64.2 | 61.1 | 58.7 | 57.4 | 53.6 | 50.9 | 50.3 | 49.4 | 49.1 | 54.7 | 100 | 18.9 | 0 | 4.166667 | 180 | |||
28-Nov-17 | 22:00 | 75.2 | 60.6 | 56.5 | 55.1 | 52.6 | 50.7 | 50.2 | 49.6 | 49.2 | 54.3 | - | 18.8 | 0 | 5.277778 | 180 | |||
28-Nov-17 | 22:15 | 65.2 | 61.5 | 57.8 | 56.6 | 54.2 | 51.1 | 50.5 | 49.8 | 49.1 | 54.8 | 100 | 19 | 0 | 4.722222 | 180 | |||
28-Nov-17 | 22:30 | 77.2 | 64.4 | 58.4 | 56.2 | 52.7 | 51 | 50.6 | 50 | 49.5 | 55.4 | - | 19 | 0 | 4.722222 | 180 | |||
28-Nov-17 | 22:45 | 69.5 | 62 | 57.1 | 54.8 | 52 | 50.3 | 50.1 | 49.3 | 49.2 | 53.6 | 100 | 19.4 | 0 | 4.722222 | 180 | |||
28-Nov-17 | 23:00 | 60.9 | 56.6 | 54.4 | 53.8 | 52.1 | 50.6 | 50.2 | 49.8 | 49.2 | 52.4 | - | 19.9 | 0 | 4.166667 | 180 | |||
28-Nov-17 | 23:15 | 73.3 | 60 | 55.8 | 54.9 | 53.1 | 50.8 | 50.3 | 49.5 | 49.2 | 54.1 | 100 | 19.8 | 0 | 4.722222 | 180 | |||
28-Nov-17 | 23:30 | 62.4 | 57.6 | 54 | 53.3 | 51.4 | 50.1 | 50 | 49.1 | 48.9 | 51.9 | 100 | 19.8 | 0.2 | 4.166667 | 180 | |||
28-Nov-17 | 23:45 | 64.5 | 61.3 | 57.4 | 55.7 | 53.6 | 51.8 | 51.3 | 50.6 | 50 | 54.3 | 100 | 19.9 | 0 | 4.166667 | 180 | |||
29-Nov-17 | 0:00 | 68.2 | 58.9 | 54.6 | 53.3 | 51.6 | 50.2 | 50 | 49.2 | 49 | 52.3 | 100 | 20.1 | 0 | 4.166667 | 180 | |||
29-Nov-17 | 0:15 | 62.1 | 57.8 | 55.7 | 54.9 | 52.6 | 50.2 | 49.8 | 49.1 | 48.9 | 53.1 | 100 | 20.3 | 0 | 5.277778 | 180 | |||
29-Nov-17 | 0:30 | 61.5 | 54.8 | 53.7 | 53.2 | 51.5 | 50.2 | 50 | 49.1 | 49.1 | 51.8 | 100 | 20.2 | 0 | 5.277778 | 180 | |||
29-Nov-17 | 0:45 | 66.7 | 58 | 55.7 | 55 | 52.7 | 50.3 | 50.1 | 49.3 | 49.1 | 53.3 | 100 | 20.1 | 0 | 5.555556 | 180 | |||
29-Nov-17 | 1:00 | 67 | 62 | 54.1 | 53.1 | 51.2 | 50 | 49.5 | 49 | 48.8 | 52.6 | 100 | 20.2 | 0 | 6.666667 | 180 | |||
29-Nov-17 | 1:15 | 60 | 57.7 | 55.6 | 54.9 | 52.7 | 50.1 | 49.6 | 49 | 48.7 | 53.1 | 100 | 20.3 | 0 | 6.111111 | 180 | |||
29-Nov-17 | 1:30 | 67.7 | 57.1 | 53.4 | 52.8 | 51.1 | 49.7 | 49.3 | 48.9 | 48.4 | 51.7 | 100 | 20.3 | 0 | 6.111111 | 180 | |||
29-Nov-17 | 1:45 | 63.3 | 55.7 | 54.8 | 54.6 | 52.4 | 50.1 | 49.7 | 49.1 | 48.8 | 52.7 | 100 | 20.3 | 0 | 5.555556 | 180 | |||
29-Nov-17 | 2:00 | 66.1 | 56.2 | 53 | 52.7 | 51.2 | 50 | 49.6 | 49.1 | 48.9 | 51.5 | 100 | 20.5 | 0 | 5.277778 | 180 | |||
29-Nov-17 | 2:15 | 66.1 | 55.8 | 54.9 | 54.6 | 52.8 | 50.3 | 50 | 49.2 | 48.9 | 52.9 | 100 | 20.5 | 0 | 6.111111 | 180 | |||
29-Nov-17 | 2:30 | 66.5 | 55.6 | 53.4 | 52.8 | 51.2 | 49.9 | 49.4 | 49 | 48.3 | 51.5 | 100 | 20.4 | 0 | 4.722222 | 180 | |||
29-Nov-17 | 2:45 | 57.9 | 53.7 | 52.6 | 51.9 | 50.4 | 49.2 | 49 | 48.2 | 47.8 | 50.6 | 100 | 20.5 | 0 | 5.277778 | 180 | |||
29-Nov-17 | 3:00 | 58.6 | 55.8 | 54.9 | 54.7 | 52.8 | 49.8 | 49.3 | 48.5 | 47.9 | 52.9 | 100 | 20.5 | 0 | 5.277778 | 180 | |||
29-Nov-17 | 3:15 | 63.4 | 58.3 | 53.5 | 52.6 | 51 | 50 | 49.5 | 49 | 48.6 | 51.6 | 100 | 20.6 | 0 | 4.722222 | 180 | |||
29-Nov-17 | 3:30 | 59.3 | 57.2 | 55.8 | 55.2 | 52.8 | 50.2 | 50 | 49.1 | 48.9 | 53.2 | 100 | 20.6 | 0 | 4.722222 | 180 | |||
29-Nov-17 | 3:45 | 57.8 | 54.7 | 53.4 | 52.8 | 51.3 | 50 | 49.7 | 49.1 | 48.7 | 51.5 | 100 | 20.8 | 0 | 4.166667 | 180 |
<colgroup><col><col span="19"></colgroup><tbody>
</tbody>
Last edited: