Dear all,

I have monthly gas data for a soccer stadium and I'm trying to develop
it toward daily (or even hourly) data so this can be used in subsequent
assessments.

My own efforts on previous assessments have extended to relatively crude
application of multipliers (possibly based on a simulation study) and an
overall divisor. This is very limited, especially in this case.

In an ideal world, it would be helpful to develop the daily consumption
weighted with the following factors:

* Parasitic losses - these can be estimated from when the facility is
largely closed during the off season
* Historic game fixtures - readily available from the web
* Weather, including about 1MW of underpitch heating

I'm surrendered to the possibility that this is well beyond me! But, can
anybody suggest excel functions or other software tools they may have
used, or even what math for me to look up on Google?

Many thanks

Chris