Group items tagged

Download Download your Esri Maps for Office. Esri Maps for Office requires Office 2010 or later. Esri Maps for Office Add-In (x86) 32-bit (70MB) Esri Maps for Office Add-In (x64) 64-bit (70MB) Download the version of Esri Maps for Office that matches the bit version of Microsoft Office 2010 you have installed, not the version of your operating system (OS). If you are not sure, open Excel (or other Office application), click the File tab, and select Help. In the About Microsoft Excel section on the right, the version information states whether the Microsoft Office 2010 installation is 32-bit or 64-bit. Once your download is complete, open Excel.

This looks to be a very valuable tool.

Tom Torok (NYT) writes: After years of looking down my nose at Excel because of its limitations, I have to say that I'm very impressed with Excel 2010 when used with a free Microsoft add-in called PowerPivot. http://office.microsoft.com/en-us/excel/download-powerpivot-HA101959985.aspx In a PowerPivot tutorial (link below), I imported eight tables  from several sources and joined them - yes, you can join relational data. It uses some magical data compression that allows for lightning fast sorts, filters and calculated fields. The largest table in the tutorial has about 2 million rows. A calculated field on that table took seconds. A did a pivot table on the table and the answers appeared as soon as I selected the fields. In one of  the training videos (http://www.powerpivot.com/) an MS guy works with a 101 million-record table on his laptop. It's really amazing. http://powerpivotsdr.codeplex.com/ If you install, be sure to read the prerequisites or you'll be installing and uninstalling both PowerPivot and Excel. I'm running it on a 32-bit XP machine (it won't run on a 64-bit XP but will work on Windows 7 64-bit). The tutorial is for a Windows 7 setup, but there are items in the menu bar that match the reference to the tutorial's ribbon. I noticed that if I call up an xlsx by double clicking on a file in Windows Explorer that PowerPivot is not enabled in the ribbon. If you call up a file from within Excel 2010 everything works as advertised.Regards, TT  

Listserv archives IRE and NICAR offer several opportunities for members and even non-members to exchange ideas, information, techniques and war stories. Joining is easy. If you are an IRE member, you may view the list archives: * Click an archive link and login with any e-mail address on record with the IRE office. Click "Get Password" if your first visit, to receive your LISTSERV password (separate from the IRE website password). Most users will login with the e-mail used for their IRE login account. Please e-mail listmaster@ire.org if you need help or have any questions. IRE-L archives. NICAR-L archives. IREPLUS-L archives. CENSUS-L archives. The following lists are less active: CFIC-L archives IRE-EDU-L archives IREBC-L archives