nebrahimjee
New Member
- Joined
- Mar 6, 2014
- Messages
- 1
Hi. I have a temperature mapping system at work and every day i get exported to excel a spreadsheet that logs temperatures twice a minute.
By the end of a week i have several thousand rows that look like this:
[TABLE="width: 175"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]08/01/2014 03:38[/TD]
[TD="align: right"]15.6[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:38[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:39[/TD]
[TD="align: right"]15.6[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:39[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:40[/TD]
[TD="align: right"]15.6
[/TD]
[/TR]
</tbody>[/TABLE]
And so on.... In column A is that Date/Time, and Column B has the temperatures. Now i need to work out the daily maximum and minimums.
At the moment I copy all one days logs into another spreadsheet then just sort by column B, and write down the top and bottom temperatures.
This sucks, and takes too long. I have 6 spreadsheets of data (different thermometers) and i have about 3months of data on each spreadsheet that now needs to be processed!
Any help would be greatly appreciated. I do not understand much about Visual Basic code, so hopefully i can get a real easy simple solution!
Thanks in advance!
By the end of a week i have several thousand rows that look like this:
[TABLE="width: 175"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: right"]08/01/2014 03:38[/TD]
[TD="align: right"]15.6[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:38[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:39[/TD]
[TD="align: right"]15.6[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:39[/TD]
[TD="align: right"]15.5[/TD]
[/TR]
[TR]
[TD="align: right"]08/01/2014 03:40[/TD]
[TD="align: right"]15.6
[/TD]
[/TR]
</tbody>[/TABLE]
And so on.... In column A is that Date/Time, and Column B has the temperatures. Now i need to work out the daily maximum and minimums.
At the moment I copy all one days logs into another spreadsheet then just sort by column B, and write down the top and bottom temperatures.
This sucks, and takes too long. I have 6 spreadsheets of data (different thermometers) and i have about 3months of data on each spreadsheet that now needs to be processed!
Any help would be greatly appreciated. I do not understand much about Visual Basic code, so hopefully i can get a real easy simple solution!
Thanks in advance!