Excel Based schedule maker?

3 posts / 0 new
Last post

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

Greg Garcia's picture
Offline
Joined: 2011-09-30
Reputation: 0

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.

M. Shields's picture
Offline
Joined: 2011-09-30
Reputation: 0

To Convert EXCEL File to DOE2.inp File
Go to
http://bepan.info/doe2inp
Under Schedules open
?0 - Convert EXCEL Schedules to DOE22.inp TEXT?
Items 1 to 6 are Excel Files that ready to be converted to DOE2.inp

Varkie Thomas's picture
Offline
Joined: 2011-09-30
Reputation: 0