AlanW Posted May 8, 2016 Share Posted May 8, 2016 Hi, I am trying to draw the list of information from a worksheet and print on page. Problem seems to be that the spreadsheet row and the Header row may be causing problems. Also when I run the series node I get 4 items but once through the Mix2 note I only get 3 and seems that I can only get a few numbers to show. What am I doing wrong? Thanks Quote Link to comment
AlanW Posted May 8, 2016 Author Share Posted May 8, 2016 (edited) Ok, Trying to create a window schedule to print them out on an A1 sheet. Got this to work and with a spreadsheet the GetWSCellValue wont read the 2.1 or 2.2 only an integer. So if I add windows the spreadsheet lists them all under the header row causing a problem to read. Guess I will have to adjust the node to check for 2.1 etc, and because the spreadsheet is for window it may only list out 2.1 - how many doors I have so this may work. Also an earlier node read a string but this new one only reads a Name node. (The bottom half of the spreadsheet is typed in to test but top reads from the original one. Now how to get the window image to show and have the headers place on a page in a grid of my liking. Guess this comes down to setting up an array with the series or sequence nodes. Edited May 9, 2016 by Alan Woodwell Quote Link to comment
AlanW Posted May 9, 2016 Author Share Posted May 9, 2016 (edited) HI, One of my problems in reading from a window schedule spreadsheet or any with a header row is that all the cells have the same name under the header. See attached image, I selected each cell on the first column and got the results all the same in the 2 column. So fail in this way to read from a worksheet. Any ideas??? Also it appears that the maths in the Series and range node sees to be strange. See row 8-11 step by0.1 you end up with 2.3000000000000003. mmm Edited May 9, 2016 by Alan Woodwell Quote Link to comment
Marionette Maven Marissa Farrell Posted May 9, 2016 Marionette Maven Share Posted May 9, 2016 Alan, I'm going to try to answer all of your questions, although they may be out of order, and some may take longer for me to form a response to. First, this file will help you get the correct values from your spreadsheet. In this case, we need to get the value of a subrow cell, instead of the value of a row cell. I've added two brand new nodes to your network (I probably have the same ones floating around, and these ones aren't clean in the sense of descriptions, but they work. One day I'll get all of my worksheet nodes posted with correct descriptions.) The first node is "Get Subrow Count", this will tell you how many subrows there are for a row. In your spreadsheet, row 2 has 2 subrows. I've incorporated this into your network to show you how to use it. The second one is "Get Subrow Value", this node will provide you with the value in the subrow cell. It takes the same inputs as "Get Cell Value" as well as a "Subrow" input. In this case, we will use 2 as our Row input, and 1 through 2 as our subrow input. I hope this can guide you a bit. As for the series node, that just has to do with how math is calculated. Float numbers can have infinite decimal places, sometimes they don't round out the same way that you would expect. I wouldn't worry about how far this goes, because having that many zeroes before that three means it's very, very insignificant overall. Quote Link to comment
AlanW Posted May 10, 2016 Author Share Posted May 10, 2016 (edited) Thankyou Thankyou Thankyou. I am so excited (small things amuse small minds) I got this to work and I also used another worksheet node to modify your Get Subrow Value to draw out the SubRow String. Wohooooo. Well now I need the window image to be drawn out. I see nodes to bring out the image of a cell so will look at that. Well I just found the one for GetWSSubrowActualkCell String. Well it was time well spent because I learnt about the coding. Edited May 10, 2016 by Alan Woodwell Quote Link to comment
AlanW Posted May 11, 2016 Author Share Posted May 11, 2016 (edited) hi, Me again, trying to use the get image from the window schedule with out success so far, Any hints?? Edited May 11, 2016 by Alan Woodwell Quote Link to comment
AlanW Posted May 12, 2016 Author Share Posted May 12, 2016 (edited) Marissa, Hi, have you had an opportunity to look at why I am not getting the image from the worksheet to print out on screen? Have tried all the nodes associated with worksheet image. ( I think) Thanks Edited May 12, 2016 by Alan Woodwell Quote Link to comment
Marionette Maven Marissa Farrell Posted May 13, 2016 Marionette Maven Share Posted May 13, 2016 Mmmmm. I don't really know. I'll keep looking at it. I think that some of the descriptions of what these functions do are misleading. Quote Link to comment
Marionette Maven Marissa Farrell Posted May 13, 2016 Marionette Maven Share Posted May 13, 2016 (edited) In general, the "worksheet image" is considered the on-drawing worksheet object... I don't know if we can extract the image from a cell. I'm able to return a boolean if the cell has an image in it, but I don't know how to take that image and use it elsewhere, assuming that's your ultimate goal. Edited May 13, 2016 by MarissaF Quote Link to comment
AlanW Posted May 13, 2016 Author Share Posted May 13, 2016 (edited) Hi, Yes that's my ultimate goal. One of the things we have to do manually is to draw a sheet with all the windows on it in elevation with the dimensions and window number and a few lines about it. Its done all manually and many way to do it workaround but was hoping to automate it on an A1 sheet and not just in a spreadsheet which most Architects don't like. Thanks see image here https://techboard.vectorworks.net/ubbthreads.php?ubb=download&Number=15170&filename=Door%20&%20Window%20Schedule.JPG Edited May 13, 2016 by Alan Woodwell Quote Link to comment
Marionette Maven Marissa Farrell Posted May 13, 2016 Marionette Maven Share Posted May 13, 2016 I'll keep looking! I'm able to return most of the settings of the image, I just don't know how to actually take that image right out of the cell. I'll ask around here and see if I can find the right person to guide me. Quote Link to comment
AlanW Posted May 13, 2016 Author Share Posted May 13, 2016 (edited) It doesn't have to come out of the cell as it would be on a drawing from the window OIP. The spreadsheet pulls it in from a create record. maybe that's where I can chase it from Records Its an Object with a Record. So with the assist of Webinar 4 wrapper i can pull all the records for the window direct from the Object by Crit (Windoor), Now for the image (tomorrow maybe) Edited May 13, 2016 by Alan Woodwell Quote Link to comment
AlanW Posted May 13, 2016 Author Share Posted May 13, 2016 (edited) Hi, Is there any reason that when I try to read the record I end Up with not a Numeric Value. All text items read ok. Also it seems that I can only read details from 1 window at a time. I need to be able to read data from all the windows in the drawing. Thanks Edited May 13, 2016 by Alan Woodwell Quote Link to comment
AlanW Posted May 15, 2016 Author Share Posted May 15, 2016 (edited) Hi, I wonder if you can help me please? I am trying to get the maths right to shift a series of symbols (windows) that are in my drawing (see Design layer with Plan).I can run the network and draw all the windows in to a line (sort of) if you hit 2 on the keyboard you see them all in elevation, but I need to get width of the window + 250mm (or any number) and move it along so that no matter what size window I put in there will always be 250mm between the windows in the sheet. Thanks for your assistance. Regards Alan Edited May 15, 2016 by Alan Woodwell Quote Link to comment
Marionette Maven Marissa Farrell Posted May 16, 2016 Marionette Maven Share Posted May 16, 2016 Hi Alan, Here's a file that will space your windows equally. If you want some help understanding the math let me know. It uses the "Add Sequence" node I shared in this thread. Quote Link to comment
DomC Posted June 2, 2016 Share Posted June 2, 2016 This is great Marissa. I made a little modification of your GetCell Node. The first Version was not able to return text values. I added a popup on the node to switch "number values" or "string values". Quote Link to comment
AlanW Posted June 3, 2016 Author Share Posted June 3, 2016 Dom & Marissa, thanks for all this, my ultimate goal is to automate a window / door schedule as shown in the image as below. Getting them all to print out in a line was a great step forward, I can at least now just viewport them to a sheet layer. Next step is to have the dimensions to be attached automatically and have the info about the window printed under each one. This is one tedious task for architects and automation would be fantastic. Can't play with this till late June when I return from travels. https://techboard.vectorworks.net/ubbthreads.php?ubb=download&Number=15170&filename=Door%20&%20Window%20Schedule.JPG Quote Link to comment
AlanW Posted July 6, 2016 Author Share Posted July 6, 2016 Hi, Back to my window schedule. The scripts calls up windows from my plan and places them in a line ready for viewporting to sheet layer for my window schedule, bur they need to be converted to a symbol first. The top 2 networks call a list of the windows but wont place them in the drawing. Is there a node for this or do I have to write one. It would be nice not to have to convert them. Thanks Quote Link to comment
AlanW Posted October 14, 2016 Author Share Posted October 14, 2016 Hi Back to my window schedule as now with 2017 windows can be styles/symbols. The issue is the script calls the windows from the resource Manager and not the plan. The network that does call the windows directly from the plan pulls then out and just places them beside the plan and not in a straight line. Any ideas. Thanks Window_Schedule_160706-01_MFarrellRevision_v2017.vwx Quote Link to comment
AlanW Posted December 30, 2016 Author Share Posted December 30, 2016 (edited) Hi, Been playing with this again and seems to work now with 2017. What you need to do is have windows as Window Styles and have all the parameters set by the style. That way each window will be specific to height, width and height above FFL etc. Have all your windows in a folder and numbered so that the network will call up all the windows from the folder and place them in a row automatically. See sheet Layer viewport. Thanks to Marissa for helping with this network earlier on and to DomC for his nodes. Test it out and let me know how it goes. Change your window types in the Resource Manager and don't change the heights on plan. You will notice that sizes and height above FFL are set by the style. This way you can control all the windows from here. HTH Video can be seen here. Window_Schedule_001.vwx Edited December 31, 2016 by Alan Woodwell Quote Link to comment
BG Posted April 2, 2017 Share Posted April 2, 2017 Hi Alan, we've had a quick trial with your marionette window schedule & it looks promising - nice work. Just wondering, we number our windows on the plans in an anti-clockwise direction so that in elevation & on the window schedule they are going from left to right in the correct sequence. The marionette script places the windows from left to right. Is there a way an option could be added to place the windows from right to left? So that when the section viewport is created, they appear in the correct order. Thanks Brett Quote Link to comment
AlanW Posted April 3, 2017 Author Share Posted April 3, 2017 (edited) @BGHi, thanks for trying this out. You can reverse the list to make it go right to left, Hope this is what you were after? I should look at this further because I was always wanting to add dimensions to each of the items automaticaly. What is your end format to give to the builder? it would be good to see a sample so maybe I can tailor to suite. Window_Schedule_002.vwx Edited April 3, 2017 by Alan Woodwell Quote Link to comment
AlanW Posted April 3, 2017 Author Share Posted April 3, 2017 Further on I and trying to dimension in elevation. Can dimension in top plan but I need to rotate the working plane over by 90 deg and add the dimension. Can anyone have a look at the set working plane node, maybe I am using it incorrectly or maybe something else. Thanks in advance Window_Schedule_003.vwx Quote Link to comment
BG Posted April 3, 2017 Share Posted April 3, 2017 Thanks Alan, will try that out. Attached is a sample schedule. Cheers Brett Sample Window Schedule.vwx Quote Link to comment
BG Posted April 3, 2017 Share Posted April 3, 2017 Hi Alan, can you confirm how this should work. I know nothing about Marionette so sorry for the basic questions. In your schedule 001, there was a marionette string plus a marionette object - & in the OIP you could specify the space between the windows. In your schedule 002, there are 2 marionette strings, but no marionette object. The windows created are now groups and there isn't the option to specify the distance between. Can you please just explain the correct way to use this in a different file? Thank you Brett Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.