Recently I have been working on building a template file for my drafting work in Spotlight. I feel like I have stumbled into an issue with the limitations with the built in Worksheet functionality of Spotlight and possibly the base Fundamentals as well. Basically what I am trying to do is pull information from the databases into the worksheet, summarize and count by Symbol, Cable Length & Type, etc. I then would like to use the count function to get a total of that particular item so I can do some math with it to calculate the spare and total counts for my pull sheets.
What I have found is that the worksheets don't work this way when using the database row/sub-rows in 2022 SP2.1. For example, on my Hoist Pull Sheet worksheet, when I summarize the symbols listed in A2 and then do an =COUNT in D2 I get the proper count of the hoists in the drawing. In E2 I do the function =ROUNDUP((D2*0.2), 0) but it only calculates to 1, no matter if I have 1 or 15 as the count in a sub row of D2. in F2 I did a =SUM(D2, E2) and I somehow got it to say 11 + 1 equals 2.
What I am hoping to see in a future service pack update is for worksheets to recognize when a database row and it's sub-rows have been summarized by a column and to allow math to be done in columns following a summarized entry as if it is a spreadsheet. I know some may suggest that I export my worksheets to Excel, but I feel like that defeats the purpose of what I am trying to do with this template file and making my paperwork generation quick, easy and having a consistent look for my vendors and clients.
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.
Question
5600KDesigns
Recently I have been working on building a template file for my drafting work in Spotlight. I feel like I have stumbled into an issue with the limitations with the built in Worksheet functionality of Spotlight and possibly the base Fundamentals as well. Basically what I am trying to do is pull information from the databases into the worksheet, summarize and count by Symbol, Cable Length & Type, etc. I then would like to use the count function to get a total of that particular item so I can do some math with it to calculate the spare and total counts for my pull sheets.
What I have found is that the worksheets don't work this way when using the database row/sub-rows in 2022 SP2.1. For example, on my Hoist Pull Sheet worksheet, when I summarize the symbols listed in A2 and then do an =COUNT in D2 I get the proper count of the hoists in the drawing. In E2 I do the function =ROUNDUP((D2*0.2), 0) but it only calculates to 1, no matter if I have 1 or 15 as the count in a sub row of D2. in F2 I did a =SUM(D2, E2) and I somehow got it to say 11 + 1 equals 2.
What I am hoping to see in a future service pack update is for worksheets to recognize when a database row and it's sub-rows have been summarized by a column and to allow math to be done in columns following a summarized entry as if it is a spreadsheet. I know some may suggest that I export my worksheets to Excel, but I feel like that defeats the purpose of what I am trying to do with this template file and making my paperwork generation quick, easy and having a consistent look for my vendors and clients.
Link to comment
11 answers to this question
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.