Jump to content

tavbut

Member
  • Content Count

    5
  • Joined

  • Last visited

Community Reputation

1 Neutral

1 Follower

About tavbut

  • Rank
    Greenhorn

Personal Information

  • Location
    Dominican Republic

Recent Profile Visitors

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

  1. tavbut

    vLookup function

    Thanks for sharing Peter!, I'll try this soon.
  2. Hello, I've been trying to create a construction budget template that I can use in different projects and I need a lookup function for cell referencing. Some time ago I tried to write a python script that could do this for me but I could not get the code to work because of some issues including my lack of knowledge in programing. Here's a link to the discussion about the script where I explain in more detail what this function should accomplish: In other spreadsheet programs I can use this function, in Excel there is the VLOOKUP and HLOOKUP functions, in google sheets as well. I could export information from VW and do my budgeting in other apps but I would really like to do all inside VW.
  3. tavbut

    vLookup function

    I understand, I will finish the code and upload it to see if it can be added to VW. Thank you (Pat and Sam) for your replies!
  4. tavbut

    vLookup function

    Hey guys, thanks for the quick reply! I was testing a bit with the basic vs.functions I think I'll have to use to get the basic code running(without the searching and stuff) and ran into a particular issue. I used VS:GetTopVisibleWS to get a handle of the active WS, VS:GetWSSelection to get handles of the current cell's address, and then VS:SetWSCellFormula to write '=2+4' in it. When I run it like this =RUNSCRIPT('vLookup') I get this error: #OPCODE? written in the cell, but in the formula bar the =2+4 appears. How could I work around this? I was hoping not to lose the formula so if I change the reference value it would update when I hit recalculate. I can only think of having a duplicate WS so I run the codes in 1 WS and write the value in the other one but that workflow would duplicate the amount of WS I was planning on managing :(. I am currently doing this by exporting information from VW to GooGLE SHEETS and working my numbers there but I was really hoping it could be done inside VW. It seems to me that only if vLookup is a native VW function It will work. Am I right? Is it possible to get the vLookup function working as a Plugin?
  5. tavbut

    vLookup function

    Hello, I'm trying to write a python code to run inside a worksheet's(WS) cell that works as the VLOOKUP function available in EXCEL or GOOGLESHEETS. I'm a python beginner and I have the basic idea of how to get the basic code structure going... but I haven't been able to write a simple "Hello World" into a Vectorworks(VW) Worksheet's cell . I'll try to explain what the VLOOKUP function does: it is about cell referencing from one WS to another. I can do that in VW by typing something like this inside a WS's cell: ='referenceWS':cellAddress but instead of having cellAddress be "collumName,rowName" it would be "stringInCollumA,stringInRow1". Ok, I'll try and explain it better with an image, this is getting me confused already. This image shows WS-2 What I would like to do is type in any cell of WS-1 something like this: =RUNSCRIPT('vLookup.py', 'concreteCollum', 'VOLUME') ...and get value 8. So the script would have to loop through all the rows in collum 'A' until it finds the string I pass as first argument, store that 'rowLocation', then loop through all the collums in row '1' and store that collumLocation and then return the content of the cellAddres = (collumLocation, rowLocation). I have several steps missing in that description of the code... but in my head that is basically what it does :P. I want to do this so I can add to or change or re-arrange WS-2 and still get the right reference in WS-1. Anyone can point me in any direction with this crusade?

 

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.

×