[Equest-users] Excel Based schedule maker?

[M. Shields]

Assuming your schedule is from cell A1 to A24 you could do the following. 

In Cell B1 type=A1

In Cell B2 type =B1&", "&A2

Fill cell B2 down to B24

Special paste cell B24 into a new cell as "values"

 

The new values cell should give you everything that goes into the
parenthesis for the day schedule

 

Hope that helps.

 

From: equest-users-bounces at lists.onebuilding.org
[mailto:equest-users-bounces at lists.onebuilding.org] On Behalf Of Greg Garcia
Sent: Tuesday, May 24, 2011 5:05 PM
To: equest-users at lists.onebuilding.org
Subject: [Equest-users] Excel Based schedule maker?

 

I've got a building with 9 unique occupancy schedules which are detailed in
an excel spreadsheet as a fraction.  Does anyone have a spreadsheet tool
that has the ability to quickly create an .inp snippet for a schedule?   

 

G.Garcia

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.onebuilding.org/pipermail/equest-users-onebuilding.org/attachments/20110524/178d3d4e/attachment-0002.htm>