<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>tema Re: RE: Sum Table Column en AutoCAD Forum</title>
    <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085144#M879572</link>
    <description>&lt;P&gt;I guess I was too vague in my issue for Replybot to be effective.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;My goal is to monitor blocks with attributes in my drawing. When the attributes change or blocks are added or removed, I need to make a total count of the attribute values. I can do this using Data Extraction and a table dropped into the drawing just fine if the number of blocks do not change. If I add or subtract blocks the range of the sum does not add up correctly.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If I use Data Extraction and send it to an Excel file, I have more issues because the Excel file that AutoCAD extracts to will not let me do a sum of a column unless I convert the values to number. It seems that there is some sort of error that shows the number, but does not allow formula evaluation on them. The other issue I have with the Excel file is that if I add or remove blocks, I have to output a new data extraction and I would have to recreate a sum of the column every time.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Here is a screen cast of my issue&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;DIV id="d775cfdc-1340-4d03-9cf8-b679333ad19d" class="myscreencast-iframe iframe-container active-myscreencast"&gt;&lt;IFRAME src="https://screencast.autodesk.com/Embed/Timeline/d775cfdc-1340-4d03-9cf8-b679333ad19d" width="640" height="650" frameborder="0" scrolling="no" allowfullscreen="allowfullscreen" webkitallowfullscreen="webkitallowfullscreen" style="display: inline;"&gt;&lt;/IFRAME&gt;&lt;/DIV&gt;</description>
    <pubDate>Mon, 15 May 2017 19:19:19 GMT</pubDate>
    <dc:creator>ArchD</dc:creator>
    <dc:date>2017-05-15T19:19:19Z</dc:date>
    <item>
      <title>Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7084953#M879553</link>
      <description>&lt;P&gt;Is there a way to sum a table column instead of just a table range? Excel allows you to use =SUM(B:B) to get a sum of all in the B column. This doesn't work in AutoCAD. Is there another way to do so without doing a data link to an Excel file?&lt;/P&gt;</description>
      <pubDate>Mon, 15 May 2017 18:07:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7084953#M879553</guid>
      <dc:creator>ArchD</dc:creator>
      <dc:date>2017-05-15T18:07:46Z</dc:date>
    </item>
    <item>
      <title>RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7084959#M879555</link>
      <description>Hello ArchD&lt;BR /&gt;&lt;BR /&gt;It looks like you are looking for information related to datalinking between AutoCAD and Excel. Community members with similar questions found the following article(s) useful: 
&lt;BR /&gt;&lt;BR /&gt;
&lt;A href="https://knowledge.autodesk.com/support/autocad/learn-explore/caas/CloudHelp/cloudhelp/2017/ENU/AutoCAD-Core/files/GUID-E6AD1DCE-6A0A-4714-808E-FA4D895C2E7B-htm.html" target="_blank"&gt;DATALINK (Command)&lt;/A&gt;
&lt;BR /&gt;&lt;BR /&gt;
To update data links, use the &lt;A href="https://knowledge.autodesk.com/support/autocad/learn-explore/caas/CloudHelp/cloudhelp/2017/ENU/AutoCAD-Core/files/GUID-1F8FE1F0-5229-4A5C-B69F-DA47CC9C25A9-htm.html" target="_blank"&gt;DATALINKUPDATE (Command)&lt;/A&gt;
&lt;BR /&gt;&lt;BR /&gt;
To provide an interface to external database tables use:&lt;A href="https://knowledge.autodesk.com/support/autocad/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/AutoCAD-Core/files/GUID-56352196-BB2D-47A1-B091-5BD367A6F195-htm.html" target="_blank"&gt;DBCONNECT (Command)&lt;/A&gt;.</description>
      <pubDate>Mon, 15 May 2017 18:09:06 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7084959#M879555</guid>
      <dc:creator>Otto</dc:creator>
      <dc:date>2017-05-15T18:09:06Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085144#M879572</link>
      <description>&lt;P&gt;I guess I was too vague in my issue for Replybot to be effective.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;My goal is to monitor blocks with attributes in my drawing. When the attributes change or blocks are added or removed, I need to make a total count of the attribute values. I can do this using Data Extraction and a table dropped into the drawing just fine if the number of blocks do not change. If I add or subtract blocks the range of the sum does not add up correctly.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;If I use Data Extraction and send it to an Excel file, I have more issues because the Excel file that AutoCAD extracts to will not let me do a sum of a column unless I convert the values to number. It seems that there is some sort of error that shows the number, but does not allow formula evaluation on them. The other issue I have with the Excel file is that if I add or remove blocks, I have to output a new data extraction and I would have to recreate a sum of the column every time.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Here is a screen cast of my issue&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;DIV id="d775cfdc-1340-4d03-9cf8-b679333ad19d" class="myscreencast-iframe iframe-container active-myscreencast"&gt;&lt;IFRAME src="https://screencast.autodesk.com/Embed/Timeline/d775cfdc-1340-4d03-9cf8-b679333ad19d" width="640" height="650" frameborder="0" scrolling="no" allowfullscreen="allowfullscreen" webkitallowfullscreen="webkitallowfullscreen" style="display: inline;"&gt;&lt;/IFRAME&gt;&lt;/DIV&gt;</description>
      <pubDate>Mon, 15 May 2017 19:19:19 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085144#M879572</guid>
      <dc:creator>ArchD</dc:creator>
      <dc:date>2017-05-15T19:19:19Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085256#M879581</link>
      <description>Just an untested idea - have you tried to add Number of Rows (object&amp;gt;selectt table&amp;gt;rows) as a part of the range definition?</description>
      <pubDate>Mon, 15 May 2017 20:08:38 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085256#M879581</guid>
      <dc:creator>ВeekeeCZ</dc:creator>
      <dc:date>2017-05-15T20:08:38Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085279#M879584</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;how about adding a summary footer into the table, defined directly during the &lt;STRONG&gt;&lt;FONT color="#000080"&gt;_&lt;/FONT&gt;&lt;FONT color="#000080"&gt;DATAEXTRACTION&lt;/FONT&gt;&lt;/STRONG&gt; command (right-click into the column header to get the option)?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="20170515_221945.png" style="width: 426px;"&gt;&lt;img src="https://forums.autodesk.com/t5/image/serverpage/image-id/356307i2962ACC1213C6192/image-dimensions/426x486?v=v2" width="426" height="486" role="button" title="20170515_221945.png" alt="20170515_221945.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;- alfred -&lt;/P&gt;</description>
      <pubDate>Mon, 15 May 2017 20:23:45 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085279#M879584</guid>
      <dc:creator>Alfred.NESWADBA</dc:creator>
      <dc:date>2017-05-15T20:23:45Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085373#M879602</link>
      <description>&lt;P&gt;That is pretty cool, I'm sure I'll find a use for that at some point. If I could get that as a header instead of a footer I would be able to link MText to the cell and have it update automatically. As a footer it jumps around if I add or subtract a block.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;This information will be used in a block of text for reports and other notes, but I'm lazy and would like to dynamically link the info into the text instead of typing it each time. Also it eliminates user error if I can get it to work correctly.&lt;/P&gt;</description>
      <pubDate>Mon, 15 May 2017 21:05:47 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085373#M879602</guid>
      <dc:creator>ArchD</dc:creator>
      <dc:date>2017-05-15T21:05:47Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085563#M879616</link>
      <description>&lt;P&gt;Look into reactors.&lt;/P&gt;</description>
      <pubDate>Mon, 15 May 2017 22:53:20 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7085563#M879616</guid>
      <dc:creator>Ranjit_Singh2</dc:creator>
      <dc:date>2017-05-15T22:53:20Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7086361#M879655</link>
      <description>&lt;P&gt;Ok, no feedback from you - guess you did not get what I've meant.&amp;nbsp;So&amp;nbsp;&lt;A href="http://autode.sk/2pRZe9b" target="_self"&gt;HERE&lt;/A&gt;&amp;nbsp;is the screencast to see how it could be done.&amp;nbsp;And yes, it works.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Even if you can add one step to add another formula in between if your end of a range is less than the number of rows.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 16 May 2017 10:23:03 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7086361#M879655</guid>
      <dc:creator>ВeekeeCZ</dc:creator>
      <dc:date>2017-05-16T10:23:03Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7086413#M879660</link>
      <description>&lt;P&gt;with C3D have you considered using the GIS functionality?&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;after edits and check in, the bottom of the data table has the message&amp;nbsp;&amp;nbsp; Row&amp;nbsp;&amp;nbsp; &amp;nbsp; of xxxx. all built into your software.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;dave&lt;/P&gt;</description>
      <pubDate>Tue, 16 May 2017 10:59:52 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7086413#M879660</guid>
      <dc:creator>parkr4st</dc:creator>
      <dc:date>2017-05-16T10:59:52Z</dc:date>
    </item>
    <item>
      <title>Re: RE: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7090034#M879917</link>
      <description>&lt;P&gt;The Field within a Field works great. This will work for now, thanks! The screencast helped out a ton.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I really like the idea of the Reactor and I am going to look into this to create a lisp that passively watches these blocks and has a command to drop in a block of text that is formatted the way we need and updates dynamically.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I like the GIS idea, but I would like to create this as a solution for everyone at the office, even if they use basic AutoCAD.&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Awesome feedback on this topic, thanks everyone!&lt;/P&gt;</description>
      <pubDate>Wed, 17 May 2017 14:38:01 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/7090034#M879917</guid>
      <dc:creator>ArchD</dc:creator>
      <dc:date>2017-05-17T14:38:01Z</dc:date>
    </item>
    <item>
      <title>Re: Sum Table Column</title>
      <link>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/8102908#M938982</link>
      <description>&lt;P&gt;Hello!&lt;/P&gt;&lt;P&gt;I clicked several times on the cell where the sum should come up until a text entry bar appeared. Then Field, in Field names chose Formula, then Sum, then you need to select the first corner of the cell range as it's said down in command line, then select the second corner of the table range and Ok.&lt;/P&gt;</description>
      <pubDate>Sun, 01 Jul 2018 10:15:03 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/autocad-forum/sum-table-column/m-p/8102908#M938982</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-07-01T10:15:03Z</dc:date>
    </item>
  </channel>
</rss>

