Forum Discussion

youngken's avatar
youngken
Copper Contributor
Aug 30, 2022

Any formula for cartesian coordinates applicable to building construction?

In a building plan drawing, it contains gridlines in X & Y directions. Taking a drawing as an example, gridlines A to F in X direction and gridline 1 to 6 in Y direction. Gridline B is 1000 offset fr...
Formulas and Functions
  • youngken's avatar
    youngken
    Aug 30, 2022
    Xlookup is the best, maybe I rename the 1 to 12 to small capital alphabet.
  • youngken's avatar
    youngken
    Copper Contributor
    Aug 30, 2022

    Riny_van_Eekelen 

    Thanks Riny.

    What if the Gridline in Y direction with 2 digits number, such as 11,12... etc. Is it possible to work out a  solution?

    Thanks

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Aug 30, 2022

      youngken Not sure what you mean. And perhaps you should not mark your own follow-up question as the "best answer". 

      • youngken's avatar
        youngken
        Copper Contributor
        Aug 30, 2022
        If a drawing as an example, gridlines A to F in X direction and gridline 1 to 12 in Y direction. If it possible to find a solution?

Resources