Jump to content

ChadL

Member
  • Content Count

    208
  • Joined

  • Last visited

Everything posted by ChadL

  1. It is true that there are more things involved in spare quantity than simple math, but it what I am trying to have the worksheet do is generally what I am going to ask for.
  2. I think I've figure out what my problem with the COUNT function is. Let me know if this is working as designed. It seems as if you do a addition or subtraction it will always use the number as a multiple of COUNT. For example (we will use a value of 10 for count: =(COUNT+1)+1 This would return a value of 30, I would expect this to be 12 =(COUNT*2)+1 This would return a value of 30, I would expect this to be 21 =(COUNT/2)+1 This would return a value of 15, I would expect 6 =(COUNT-2)+1 This would return a value of 0, I would expect 9 I imagine this is why I am having problems using the INT or ROUND function with COUNT If this is working as designed, how would I do addition or subtractions?
  3. Jonathan, I don't really understand what this formula does. I'm trying to get a whole number that is at least 15% of the Value in a C3.* cell. So if I do your formula, and I have a value of 10 in C3.7 I get this: =INT(10)+(If((3)-INT(10)>0,1,0) =10+((3-10)>0,1,0) =10+((-7)>0,1,0) =10+0 =10 The number I would be going for in cell 3.7 is 2 (1.5 rounded up), and 1 in 3.1-3.6. I think this is doing the calculation on the value in the C3 cell, and not the C3.* cells. And that is part of the problem I am having. I think have to include COUNT in the formula somewhere, but I can't seem to figure out how to make this work.
  4. After messing around with the INT, and IF statements, I have not been able to get the desired result. I think I need to include the =COUNT function in the equation, because otherwise it seems to just be working off the total count of all items below. However any time I try to modify the COUNT beyond a simple math equation, I don't the desired answer. So I've tried: =ROUND(COUNT*.15) =INT(COUNT*.15) Both of those result in a 0 Then I try =ROUND((COUNT*.15)+1) =INT((COUNT*.15)+1) both of those result in the original count. I feel like I'm getting close, but I'm missing something here.
  5. I'm trying to create a worksheet that auto calculates spare lighting fixtures. So far I have it setup a database row that shows symbol image, instrument type, count per fixture. I want to add a column that calculates spares. I want the spare fixture count to be 15% of the total count. I would also like this number rounded up to the nearest whole number. For example, if I have 5 fixtures, instead of the column saying .75, I want it to say 1. I have tried using the Round command. I've been trying =(Round(C3*.15)+1). In my head that should get me a minimum of 1. What always seems to happen is the formula is calculated on the total of all the fixture below, instead of each row. See Image. My next question is, how do I set the row height for the cells in 3.*. I know I can select the cells and change the height, but I want to change the default height for those cells, so anytime I add a fixture to the drawing it gets added at the correct height? Thanks.
  6. ChadL

    Create Classes

    That did it, Thanks!
  7. ChadL

    Create Classes

    Here is what I currently have. the only Int with a value higher than 0 is the bottom one, which is set to 65535
  8. ChadL

    Create Classes

    I've tried that too. I have 3 int nodes feeding a 3d point node, feeding a set pen color node. AAhhhhh, that is probably the problem, i used 255
  9. ChadL

    Create Classes

    Okay, I've been playing with this and I like it. However, now that I got a taste, I want to go deeper. I have been struggling to create a class and assign it line colors and fill colors without having an object to pull that info from. I think the problem is in how I am compiling my RGB values. Right now I have 3 int nodes with my RGB value, then I've tried using a series node, or an ordered list. Nothing I've done so far sets a color.
  10. ChadL

    Create Classes

    Thanks, this is super helpful. I played around with this for about 30 minutes yesterday, making me excited again to try to learn marionette.
  11. ChadL

    Create Classes

    Thanks, I will play with this.
  12. ChadL

    Create Classes

    HI Pat, thanks for the reply. I have done the resource before, I was using this as a project to start learning scripting. Thanks,
  13. ChadL

    Create Classes

    I'm not a scripter, and in my limited research I was not able to successfully do this. I want to create a tool (marionette node, vectorscript, anything) that when I run it it will create a series of classes in the active document. I know what I want all those classes to be, just don't know how to make this script. Thanks,
  14. Thank you, this is exactly what I was looking for!
  15. Two questions, both of these questions are for after I convert to object node. 1) Is there a way in marionette to have a drop down menu in the OIP to select the way the network gets inputs. For example, I want to have the option to choose between using a fixed distance, or percentange. Then based on what is selected the network uses the corresponding input node. 2) Is there a way to display information from somewhere in the network back to the OIP. For example, the area or an object created. Thanks, Chad
  16. ChadL

    Texture Size

    Is there a work around for this? Or is there a python script that will do this? I do not know python or VS, so any help would be great. Thank.
  17. ChadL

    wrapper order

    Is there a way to order the way inputs and outputs show up on a wrapper? For some reason I can't get it to change, and I want them to line up with the order of the nodes on the outside. Thanks, Chad
  18. ChadL

    Duplicate Array

    That was the trick I needed, Thanks!
  19. ChadL

    Duplicate Array

    I am still struggling with how to make an array in 3d space. I am trying to make cubes and stack them. I keep finding that if I get my xyz for the starting point for each cube, and make rectangles to extrude they ignore the z coordinate. This makes sense to me why it doesn't work they are only 2d objects, but I have not been able find the work around. If I create extrude first I don't know how to duplicate array them. Thanks for any help. Chad
  20. ChadL

    Duplicate Array

    I am still struggling with how to make an array in 3d space. I am trying to make cubes and stack them. I keep finding that if I get my xyz for the starting point for each cube, and make rectangles to extrude they ignore the z coordinate. This makes sense to me why it doesn't work they are only 2d objects, but I have not been able find the work around. If I create extrude first I don't know how to duplicate array them. Thanks for any help. Chad
  21. ChadL

    Duplicate Array

    Thanks for you help Alan, After looking over these I was able to get closer to what I needed.
  22. ChadL

    Duplicate Array

    I am working on my first scripting project, with very little experience in scripting at all, hence why I am playing with Marionette. I am trying to do a basic duplicate array, where my x offset would have a value, as would the z, but nothing for the y. I don't see a node for this. What is the best way of doing this? Thanks for you help. Chad
  23. ChadL

    Texture Size

    I am trying to change the size of an existing texture, so when it is applied to my surface, it is sized to the surface. I used the 'set texture' node, and connected that to the texture input on the 'set texture size' node. For the size I used a 'dim' node. This seems to have no affect the size of the texture when running the script. I am starting to think that the 'set texture size' node is only for when you create a texture, not for using an existing one. What would be the method of changing the size for an existing texture? Thanks,

 

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.

×
×
  • Create New...