I'm in the same boat with Denial. My company installed a coporate update which included Microsoft's recent update. I cannot simply remove the update like Spats. I've followed some of the threads indicated in IDS's link and have been painfully trying to implement some workarounds within VB...
Thanks IRstuff for your response. I thought about your suggestion before, but it doesn't work out so well. I've monitored supply and return water temps from a chilled water loop as well as the flow. I need to apply the following formula for each data point to calculate tons cooling: Tons =...
I've got two sets of data that I need to do some basic math with. One is set at 5 min intervals while the other is set at 6 min intervals. Is there some way to do this without manually manipulating one set of data?
I've got a question regarding EFLH and Cooling Degree Days (CDD). I've found an equation to calculating EFLH as follows: EFLH = 24 x CDD / delta T
My question is, "Delta T of what?" Thanks in advance.
Thanks everyone for your help. I was able to get it after following the directions on the first response. I ended up taking the difference between the sunset and sunrise in the same day to calculate "daytime" and 24 - "daytime" as "night".
Gotta love this site.
I have Sunrise/Sunset data in the following format:
January February...
Day Rise Set Rise Set...
01 0722 1701 0710 1732
02 0722 1702 0710 1734
. . . . .
. . . . .
. ...
Thanks InspEngr. Shortly after I started the thread, I figured out a method based on responses to an earlier "Manipulating Weather Data" thread I started one year ago. Basically I did a SUMIF divided by a COUNTIF.
I would still like to see your spreadsheet to compare to.
Send to...
I've got data in the following format:
Date Hour Temp
9/1/2003 100 59.8°F
9/2/2003 200 60.1°F
.
.
.
8/31/2004 2400 60.8°F
I need to get to the following format on a month by month basis:
January
Hour Average Temp
100 (average temp at hour 100)
200...
Combuster,
There are two Cleaver Brooks DL-60 boilers serving a hospital. These boilers have been de-rated years ago once the absorption chillers were removed. One boiler has a new Power Flame boiler rated at 20,696 MBH with FGR and a modified version of Parallel Position Controls. The other...
I'm looking for some Boiler Combustion Efficiency tables.
I seem to recall one with %Excess Air, %02 and temperature.
Does anyone know where I can find one? I have flue gas analysis data telling me I have 8.3% O2. I believe it should be in the 2-3% range. Oh yeah, the fuel is natural gas...
Thanks ivymike for pointing me in the right direction. The manual method involves a lot of manual highlighting and the frequency function.
I've tried out your method, but am a bit confused. I understand the month and the hour portion of the bin code, but don't understand the temperature...
I've got 8760 lines of weather data that I'm trying to manipulate into three different tables. Currently the data is in the following format:
Date Hour Air Temp (°F)
08/01/01 100 60.6
08/01/01 200 58.4
08/01/01 300 57.3
...
07/31/02 2200 64.3
07/31/02 2300 63.3
07/31/02 2400 62.9
I...
