Jump to content


  • Posts

  • Joined

  • Last visited


7 Neutral

Personal Information

  • Location
    IL, USA

Recent Profile Visitors

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

  1. ChadL

    Text Alignment

    @Antonio Landsberger For the tool I'm making, I don't even want it as an option, I always want it to be placed in the center of the text.
  2. ChadL

    Text Alignment

    @Antonio Landsberger You have pinned what I have been wrongly trying to correct. Yes, what I want is to insert the text on a chosen reference point in the text. I never thought of that, so I was trying to figure out how to do it with alignments. How would one place text on a reference point, of my choosing, in the text field?
  3. ChadL

    Text Alignment

    @Antonio Landsberger I've thought about this kind of solution, but the problem is, this assumes the document default is left justified. If the document is anything other, then this doesn't work.
  4. ChadL

    Text Alignment

    Hi Antonio. The Set text properties has the same problem as you mentioned and I mentioned, they both set the alignment after the text is placed. I want to place the text with the alignment already set so the text is placed where I want it. Any ideas for that?
  5. @michaelk, I'm trying to do it within the Marionette. I can change the order after I run the script, but trying to avoid that. @jesse, That worked, thanks!
  6. I am having difficulty getting text to insert different from the document defaults. I use the Set Char Properties, and set alignment there, but it only does it after the text has been inserted. So if I am Top Left justified in doc setting, it will insert it there, then change to the Center Center I set in the node, but the text stays where it was initially drawn. I don't see a node that can set the defaults, or anyway to change it before I get the text string. What am I missing? Thanks.
  7. Hi All, Is there a way to change the stacking order of objects drawn? I am making a line with some text on it, and I can't seem to figure out how to get the text on top of the line. Thanks,
  8. 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.
  9. 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?
  10. 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.
  11. 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.
  12. 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.
  • Create New...