minotto

Member
  • Content count

    102
  • Joined

  • Last visited

Community Reputation

1 Neutral

About minotto

  • Rank
    Journeyman

Personal Information

  • Occupation
    designer
  • Location
    CA, USA
  1. Thanks for all your suggestions. Like the Resource Browser which was redesigned recently and is a lot more intuitive and efficient than it's prior incarnation , i think the worksheet/ schedule capabilities need a revision - simplified with BIM in mind where the whole process of extracting information from a model requires less effort.
  2. Yes but the total Roof Thickness in cell C3 which adds up cells of the components, C6 to C10 is not showing up. How would i fix this?
  3. I've attached a file that i'm using to learn worksheets. I'd like to add up the cells that contain the thickness of the roof component and show the total thickness in a separate cell. I've tried using the SUM function as suggested by JimW in another post but i'm doing something wrong. Any help is greatly appreciated. Worksheets.vwx
  4. It be nice to keep them separate though, since they each serve different functions. Thank you Michael.
  5. I'm just learning about Worksheets. It seems wall, door, window and slabs are all represented in the choices for possible functions, but not floors. Why is that? I've created a couple of floor objects and would like to create a worksheet with the names of the materials and sqft. How would this be done?
  6. Right that makes sense. Thanks again for your help.
  7. Thanks a lot michael. I changed the function to ROUND and it adds up right now. One other thing though, why do the components and the Wall Style have different Net Areas? Shouldn't they all be the same?
  8. I'm just learning about worksheets and generating reports. I've created a worksheet for a wall style and have 2 issues i can't resolve. 1) When multiplying Net Area and Price/ SqFt, the numbers are off. (The functions maybe wrong?) 2) Using =COMPNAMEBYCLASS i have the wall components listed to determine price/sqFt. but the total Net Area for each component and the wall styles don't match up. Or are they not supposed to? Attached is the file. Any insight into what i'm doing wrong is greatly appreciated. Worksheets.vwx
  9. Thanks Pat for the reply. Basically i just want to show the components that make up the wall and maybe even be able to determine cost per sqft.
  10. Is there a way to itemize each of the wall components in a wall style in the database of a worksheet? I was able to create a worksheet with the wall style showing dimensions, costs, etc without a problem. In the database header, i tried setting the criteria to the class of the component but there must be more to it since it didn't work.
  11. Yes that did it. Thanks a lot for your help.
  12. Pat, i did try just entering numbers but that didn't seem to work. I must be doing something wrong. Here is the file. Worksheets.vwx
  13. Thanks Jonathan. Just to reiterate in case i'm missing something: database header - ='Door'.'UserFld1' Database cell format - decimal, dec. 2 places and comma, leader $ In the same column, in the next spreadsheet row, I tried entering =VALUE('Door'.'UserFld1') but got #VALUE! in the cell. Am i missing something?
  14. I'm just learning about worksheets and have learned a lot on the forum. But i can't seem to find an answer to a very basic procedure. I'm creating a Door schedule and have used the User Field 1 in each of the doors for the price. With ='Door'.'UserFld1' placed in the worksheet database header, each of the database subrows have the correct price and have been formatted with decimal and the leader $. But the database header row only shows the number of doors with a dollar sign in front. How would i show the total price of all the doors in the last cell of the column? Is there a better way to do this that i'm missing?
  15. Thanks. I'm not sure if i got it right. I'm assuming that by preventing tilting in Google Earth, the aerial view is achieved since there isn't a view or setting for aerial view, birds eye or 3d. But i wonder if the assessor's map reference is off, though other documents showing the property line seem to confirm that it's correct.