Change the AutoCAD F1 key from Help to the CANCEL Command
Get Out and Vote on Your AutoCAD, Revit , and Inventor Wish List Items October 2008

Link Excel and AutoCAD Without OLE and Win at the Blackjack Tables

OK the main point is not really winning at the card game Blackjack, but the table in this AutoCAD Tables in AutoCAD example does show the best moves when playing at the Blackjack card  table. Autodesk University 2008 is in Shanghai China, Yokohama Japan and Las Vegas Nevada. In Las Vegas there is gambling available should you choose to gamble. I don't gamble when in Las Vegas myself except maybe a couple quarters in a slot machine. OK Shaan get on with it

I created a Microsoft Spreadsheet showing what to do when the dealer’s hand is showing and you have a certain pair of cards in yours. This table does even the odds a bit, but in most gambling the odds are in the casinos favor no matter the skill.MS Excel Spreadsheet

Now at this point I could copy the Excel cells and using Paste Special in AutoCAD paste as AutoCAD Entities and end up with a native AutoCAD Table with the formatting, values, and the underlying formulas but I am not. In this example I want to show a cool and time saving tip and new AutoCAD 2009 feature. I want to have the spreadsheet linked between AutoCAD and Excel so if I update either they are synched up. I don't want to use the paste OLE object into AutoCAD as OLE is one of those things in Windows that can be a real pain. So we will use the new AutoCAD 2009 ability to create a Table from a data link to Excel. Note you must have Excel installed.

So I use the DATALINK Command. You can also select the Data Link option from the Tools menu.

AutoCAD 2009 Data Link Manager

I will then use the Data Link Manager to give the Data Link a name and then browse for a Excel spreadsheet.

AutoCAD 2009 Data Link Manager

AutoCAD 2009 Data Link Manager Dialog

I then can preview the spreadsheet and use the path or a relative path. I also selected a range in the spreadsheet.

AutoCAD 2009 Linking Data to Excel

AutoCAD 2009 Data Link Manager

Now I use the AutoCAD TABLE Command and select the Insert option “From a data link” and select the Blackjack Table I linked to and you can preview the table.

AutoCAD 2009 Table Dialog

Now place the Table in your drawing. You can now edit the formatting and as I mentioned update the table from Excel using DATALINKUPDATE command.  without having to resort to OLE which is a gamble itself. ;-)

That’s it!

AutoCAD 2009 with Blackjack Table

I printed a DWF for reference and also placed one on the free Autodesk Freewheel where you can view a DWF without installing anything and works on any platform that can run JAVA in a browser.

Shaan’s Blackjack Table DWF Here

Or click the below image to see the DWF in Autodesk Freewheel.

Shaan's Blackjack Table DWF in Autodesk Freewheel 
Autodesk Freewheel is a free web service to share 3D and 2D designs without installing any software. You can also  use the Autodesk Labs Technology Preview 3D/2D ShareNow Add-in for AutoCAD, Inventor, Revit, and Design Review

http://freewheel.autodesk.com/email.aspx?path=ADSKFW%3a%2f%2f60%5c99%5c06%5c44%5c29%5c63%5cd4%5c98%5ca2%5c58%5c5c%5c0c%5c76%5c40%5c22%5cc4%5c5c%5c86%5c2e%5ce0%5cBlackJackTableMapLinked%5b1%5d.dwf&sec=1&cx=0.5&cy=0.5&scale=1

http://freewheel.labs.autodesk.com/dwf_S.aspx?store=true&dwfkey=ADSKFW%3a%2f%2f1d%5c8e%5cd7%5cec%5cb1%5ca3%5c34%5cee%5c07%5c39%5cfc%5cc8%5c4a%5c11%5cf4%5ccf%5c6e%5c85%5ccc%5ce9%5ctmp0.dwf

All you need to do it ad your path to a DWF to the URL for Freewheel or upload your DWF to Freewheel either way it is free and results in a zero client DWF viewing.

All you need to do is point Freewheel at your DWF you have on the web
Now I need to get back to writing my many presentations and packing for travel to Istanbul Turkey this week.

Cheers and I hope to see you at one of the AU’s this year,
Shaan

Comments