Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About stevenmorgan94

  • Rank

Personal Information

  • Location
    United States

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. stevenmorgan94

    Strip Text From Worksheet

    Digging this one back up. I am trying to get the total weight of this column. I am able to strip away the 'lb' using Pat's formula above, however I can't total the column. I have tried: =SUM(G4.1..G4.4) However I don't think you can select sub-rows using the range symbol. Also tried: =Value(Substring(G4, 'lb', 1)) Obviously it just returns the '4.00' which is the count of the column. I can't find a way to only apply that to sub-rows. Any ideas?
  2. stevenmorgan94

    Strip Text From Worksheet

    Thanks Pat! Kickass class this week at VWX Summit.
  3. stevenmorgan94

    Strip Text From Worksheet

    Searched the forum and couldn't find anything. I have a bunch of default instruments in spotlight that bring in some numerical data as text. ( 93lbs instead of 93). Rather than changing all of my records is there a way to strip out a string of text from a worksheet column? If I could remove 'lbs' and 'watts' and return only numerical data I would be in good shape. Thanks!
  4. stevenmorgan94

    Hoist Label Background Not Working

    Having the weirdest issue lately. All of the sudden all of my hoist label backgrounds have disappeared on all of my files. I have tried setting it in my classes and by selecting the label and adding a solid white background, still shows as transparent. Anybody had this issue before? If I remember correctly it was all working, and then I clicked "Refresh Hoist Symbols" and it erased them from everything. File attached if you want to take a look. MLS_Production_Basecamp_VW.vwx
  5. stevenmorgan94

    Importing Custom Photometrics .ies File

    Awesome, thanks guys. My only problem now is that when I input a photometric grid everything is reading 0. Any advice on getting that working?
  6. stevenmorgan94

    Importing Custom Photometrics .ies File

    I am trying to create a custom house light fixture, it's an Altman Downlight Chalice. I have imported the .dwg of it, converted it into a lighting lighting symbol. Now I want to use the Photometrics file that Altman provides which is an .ies file. I have looked all over and cannot find a way to import and assign that to a custom fixture. Anybody have any ideas? Or am I looking at this totally wrong?


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.