Worksheets Database Headers

[gasjar]

I am new to VW and I am trying to create a Light and Vent schedule. When I select the Criteria for the Header field for the Actual Area ,=('Space'.'Actual Area'), the program returns a 0 and all fields have a zero. The syntax seems to be the issue but I am trying to follow what appears to be the correct syntax. When I select the field from the Criteria list it returns the following variations which do not seem to work either. I have had similar problems with other worksheets that I was trying to create which fortunately you have already defined.

(Space.'Actual Area')

((Space.'Actual Area'))

(('Space'.'Actual Area'))

Additionally, once this is working, can I input "if-then" functions as database headers to produce calcs based on the Actual Area fields culled into the spreadsheet?

thanks

Greg Randall

[Robert Anderson]

try using single quotes on the 'Habitable' string. I'm also not sure about your (dollar-sign) absolute references. I know this kind of thing can be done, but there is some finesse. You can email me directly on this issue, and maybe send me a file:

randerson@nemetschek.net

[gasjar]

Thanks, the single quotes worked perfectly. I just have to tie in the window references and it will be done.

I suppose you get the "Mr. Anderson" reference all the time?

Greg

[Robert Anderson]

You mean, "Mr. Anderson" as intoned by Hugo Weaving? ....only occasionally ;-)

[Robert Anderson]

Use the formula: =Space.Area .

"Actual Area" is a so-called "alternative name" for this field. You can look up the actual names by selecting the Space object in the Plug-in Editor window and clicking the Parameters... button.

[Robert Anderson]

I saw your second question. There is an IF() function in the worksheet. Look at the section of your documentation "Additional Worksheet Operations".

[gasjar]

"Mr. Anderson"

Thanks for your reply it helped getting the real parameter name. I am still unclear on the "if-then" issue. The following is the syntax I have put in the Database Header line and the only result that I get is the equation repeated in the subsequent fields.

=if(($H4="Habitable"),$C4*.08,0)

Are the database header fields reserved for data lookup only?

Greg

[gasjar]

I have done that...but I dont follow how to cull the appropriate data into a different Worksheet. May I send this to you to clarify?

[Robert Anderson]

I don't know what you mean by "cull". You can set up a different worksheet that has a single database row, for example. Is this what you mean?

[gasjar]

By "cull" I mean to grab info in one worksheet that meets a given criteria and bring it into another worksheet for use in a different way. For example in the window schedule, I have database fields for the width and height of the frame. From that, in the same worksheet I have created a calculation for the light area and another calculation field for the vent area of the window. Now in a separate worksheet, I want to grab the areas of all windows for a given room ID from the window schedule to sum the areas per room. It is this latter step that I am unable to do.

[gasjar]

I am back today. I hit another stumbling block. I am trying to cull data from one worksheet and summarize it in another. Not sure how to do this. Can you shed some light on this? The worksheet I am trying to get info from is a dataworksheet which culls "window records" from the file. This dataworksheet then calcs the areas for light and vent per instance of window record. Then I want to cull that info into a summary worksheet for all windows in each room. I will also do the same for Doors, and eventually cull both door and window summaries for each room into the light and vent schedule. If I place the Summary function in the column for the window schedule location, it summarizes the areas that I need for windows in that room. However, I want this info separated from the Window Schedule proper in a separate table.

[Robert Anderson]

You'll have to have a field in each window record that is your room ID. Then you'll use the room ID as the search criteria for each database row, and you'll have a database row for each room.

[Robert Anderson]

But this is the step that I described four postings above. Try this:

1. Copy the database header row from the window schedule worksheet that you want to "cull" from;

2. Create a new worksheet with the same number of columns;

3. Paste the database header row; now you will have a duplicate of your schedule.

4. Now modify the criteria of the database to show only windows for a particiular room, e.g. something like: =database(R IN ['Window'] & Window.RoomID = '101')

5. Now you should have a window schedule for just that room.

[gasjar]

I have clarified this issue a little bit more. I have created a worksheet, 'Window Schedule', that has all the window info (ie, ID, size [from the record], and calculations for light area and vent area). Now I want to create a separate worksheet, 'Light and Vent', that references 'Window Schedule' to get the info from the calculated columns of light area {'Window Area':P4} and vent area {'Window Area':P5}. To keep both Worksheets the same size and with the same number of rows, both worksheets are database worksheets that refer to the 'Window Record'.ID and 'Window Record'.Location and both are sorted in sequence.

Now to get the calculated values from 'Window Schedule':P3 into 'Light and Vent':D3, I am using an IF statement that compares the ID value in 'Light and Vent':A3 to 'Window Schedule':A3. If true, then the cell references 'Window Schedule':P3. If false, then the cell is ERR.

In spite of the value that is calculate in 'Window Schedule':P3, the IF-Then always returns ERR. Is this because "Window Schedule':P3 is a formula? If so, how do I get its value into 'Light and Vent':D3?

[gasjar]

I apologize {'Window Area':P4} and {'Window Area':P5} should read {'Window Schedule':P4} and {'Window Schedule':P5} in the previous post.

[gasjar]

If I put in the following formula in 'Light and Vent':D3 (='Window Schedule':A3), my result is the number in the database header (the number of records) instead of the corresponding value in A3.1, A3.2, A3.3 etc....

[Robert Anderson]

Make sure your record format fields are defined as numeric and not text fields.

[gasjar]

Is it possible to call and talk to you. I feel like we are discussing China and Bolivia. Please refer to the post sent at 11:06AM today.

[Robert Anderson]

You should be calling the Tech Support staff on this issue so they can provide more continuity. I'm technically in development, not in Tech Support.

[gasjar]

???????? (Confusion)

I don't understand. Why does it matter whether the values are numeric or text in the record field? The sizes are numeric but the ID and Location fields are Text.

[Robert Anderson]

Only the things you want to total must be numeric. Other things will be counted instead of totaled.