Eamon Posted October 28, 2010 Posted October 28, 2010 Hi I have imported an Excel 2003 spreadsheet into an AutoCAD 2010 Table, all came in fine except the following formula =ROUNDUP(((SUM(E27:E33))/24),0) Does 2010 not support ROUNDUP ? is there another way to do this? The formula is used to calculate the number (whole) of driver boards required to drive the number of LED's calculated by the SUM function. Each driver board can drive 24 LED's, so if i have 23 LED's I need 1 driver or if I have 25 LED's I need 2 drivers Also is there a list or table that shows what Excel functions are or are not supported in AutoCAD? I can't seem to find one. Any help would be greatly appreciated Eamon Quote
ReMark Posted October 28, 2010 Posted October 28, 2010 The spreadsheet is an OLE object and not dynamically linked? Quote
Eamon Posted October 28, 2010 Author Posted October 28, 2010 Hi the spreadsheet is not OLE, I am trying to duplicate the spreadsheet in an AutoCAD Table in our template drawing so we don't need Excel. Then I should be able to generate a Bill of Material inside the drawing thanks Eamon The spreadsheet is an OLE object and not dynamically linked? Quote
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.