# sle7en7

Member

173

1. ## Sorting and subtotaling worksheets

Yes now I got it to work, thanks Pat, I did; =AREA('MyRecord'.'MyField'='Type1') fyi... Edit #1: Now I'm trying to do =AREA('MyRecord'.'MyField'≠'Type1') which ends up in <> signs for exchange with ≠ when you run it. Any ideas on this one?
2. ## Set Record Field with Alphabetical Sort

Hi Pat, You know what I'm trying to do; I'm trying to assign letters to record fields inside a worksheet. So you remember this code right; Procedure Number_Objects; {October 1, 2014} {? 2014, Coviana, Inc - Pat Stanford pat@coviana.com} {Licensed under the GNU Lesser General Public License} const MyRec='Test'; MyField='Seq'; Var NextNum: Integer; Procedure MyProc(H2:Handle); Begin SetRField(H2,MyRec,MyField,Num2Str(0,NextNum)); NextNum:=NextNum+1; End; Begin NextNum:=1; ForEachObject(MyProc,((R IN [MyRec]))); End; Run(Number_Objects); I'm trying to do the exact same thing but with letters now, if I'm explaining myself clearly.
3. ## Set Record Field with Alphabetical Sort

Thank you hippo, I know it related with that function but ... guess I'll have to get into VS and Python a little more.
4. ## Sorting and subtotaling worksheets

Although, is there are like a SUMIF function in VectorWorks? To tackle the issue of subtotaling? Meaning, say I have 3 different uses of areas which are stored under one record field and I want the subtotal for 3 types of AREA on either between database cells or on a separate spreadsheet cell, what should I do?
5. ## Set Record Field with Alphabetical Sort

I have another request since I can't code even to survive, and hopefully someone has already have one written somewhere but I was not able to find it. This time, I'm looking for an alphabetical sort script which will set the record field from A to Z on a stacking order basis or some other basis ... idk. Any ideas, or line of codes?
6. ## Worksheet Set up

This is somewhat related to this thread... When most of us are talking about creating a VP of the worksheet, it's not a magical feature where you setup a viewport only to show the worksheet content and manage the worksheet display from that viewport as you wish right? I mean, when someone says "create a VP of the worksheet", I imagine drawing a rectangle around the worksheet on the design layer and putting that VP in the sheet layer... It's just seemed like I'm doing something crude and that there is a more intelligent way of doing this that I don't know, so please let me know if such a way exists. And the purpose of writing this message is to find out if such a way exists (e.g; I put a referenced drawing in one of my files and show that as the source of my viewport... is this possible with worksheets as well?) Thank you.
7. ## Extrapolating/trend forecasting???

Thanks again Pat. The script worked fyi, and I'm sure I will be using it later on as well.
8. ## Extrapolating/trend forecasting???

Wow Pat, thanks for the script. Although there is ,database is the easy way to do other things easy Pat. Let me run this script and I'll tell you how it goes.
9. ## Extrapolating/trend forecasting???

Hey Pat, Is there a way to do the numbering thing with database headers. Basically I have 200 something objects with a record attached, I do not want to go around putting numbers into each record value but I just want to automatically number them consecutively from a worksheet. Is there a fast way to do this, sorry I'm in a bit of a time crunch and not being as explorative as I should be... thank you very much.
10. ## Extrapolating/trend forecasting???

Thanks a lot Pat, have a good one
11. ## Extrapolating/trend forecasting???

I was just wondering if there is a way to extrapolate cells like you do in excel where you just drag the lower right corner of the cell and it forecasts the trend of the originally selected cells in a vectorworks worksheet? I know you can't literally do that in a vectorworks worksheet but is there a way around it? For example automatically number certain objects with attached records? Or fill in a range of numbers from 1 to 360 per say. I guess this brings me to my other question which is really general and a topic of discussion but what are the infringement issues with Microsoft Excel? Meaning what are the obstacles ahead of VectorWorks Worksheet to be more like Excel? Thank you very much.
12. ## Space - Rounding a formula

Thank you very much Jim, I was able to bring the Space tool alive. Hoorayy. I was going to ask another question but I think I figured it out with an earlier post, hence my delayed appreciation. But thanks a lot again, for the prompt response.
13. ## Space - Rounding a formula

Hello, I know this thread has been inactive for a while, but I have a question about this space tool. First of all I do not see a "space tool" under my space planning toolset. I have a Raum Tool CW which whenever I try to use pops up this message; "error occurred while opening plug-in. Make sure that there is a "Plug-ins" folder in the same folder as the application." The Raum Tool shows up as a .vwr document rather than as a .vso like other vectorworks plug-in objects in the VectorWorks file directory. Not sure if that is related but it's a piece of information. Other than that, how can I turn a rectangle or a polyline into a space object I guess? I'm using this particular file in 2D. Thank you very much.
14. ## Script to Call the Width & Height of a Rectangle

Thank you for the heads up Pat. You think you can send a file with the script you just mentioned? I'm kind of lost at this point but I believe what I'm trying to do is to define the edges of a rectangle in terms of delta Y (height) and delta X (width), so I guess we will write a script in order to accomplish this?
15. ## Script to Call the Width & Height of a Rectangle

I have been schooled ruthlessly as it seems, thank you very much sir. Never felt dumber
16. ## Script to Call the Width & Height of a Rectangle

I was messing with worksheets again to create an areas table with length and width listed but do not want to put the information manually because I'm... umm LAZY, but fell short of the task basically. So after searching the forum a bit, I was unable to find a way to call the Width/Height of a rectangle in a database header. Is there a way to do this (like punching in "=S" to call a symbol's name) or is this information not stored as a default data like area, perimeter or ratio? Thanks for all the help in advance. :blush:

commenting to find this thread later...
18. ## Vectorworks 2014 Symbol Count?

Thanks again for the response, Pat. That's what I will do next time probably.
19. ## Vectorworks 2014 Symbol Count?

ok PAT (or anybody), I have another question/problem. I'm attaching the worksheet I'm working on as well. I have done what you have told me I suppose; This time, the custom record format I have created gets multiplied by the number of symbol instances in the file and result in a wrong "DIFFERENCE" number. I have tried couple of tricks ("VALUE" function or storing the record format as text information) but couldn't find a way around. You think there is a way around this? Thank you once again.
20. ## Vectorworks 2014 Symbol Count?

That worked fine PAT, thank you.
21. ## Vectorworks 2014 Symbol Count?

Thank you Pat, I understand. I'll let you know how that goes.
22. ## Vectorworks 2014 Symbol Count?

I have a question as well; somewhat in the same ballpark. Say, I have a worksheet with a single database header. Can I limit the columns that the Database Sub Rows goes? Meaning, I want to create other columns which have editable rows in them for comparison purposes which I will manually punch in the numbers. Thank you for the support.