Useful Excel links

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Martin Ryan
Site Admin
Posts: 1957
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Useful Excel links

Post by Martin Ryan » Thu Jan 15, 2009 1:27 pm

Here are some links acquired from JW's blog that may be useful when building an Excel front end for your TM1 application.

Build your own toolbars
Microcharts: Bona Vista or Bissantz (both have free trials, but charge for full version)
Capturing application events, e.g. double clicks
Progress bars so your user doesn't think TM1 has died
Tree Mapper

Some non-Excel but also useful/interesting links
Free PDF builder
A history of TM1
Podcast from Nigel Pendse (author of OlapReport) talking about best techniques for Data visualisation

Please add your own. I may consolidate if the thread becomes large.

User avatar
jim wood
Site Admin
Posts: 3781
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Useful Excel links

Post by jim wood » Mon Jan 19, 2009 8:46 am

All good stuff. Thanks for bringing that across Martin. (Especially when James's blog is blocked where I work.)
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

User avatar
Steve Rowe
Site Admin
Posts: 2031
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Useful Excel links

Post by Steve Rowe » Fri Apr 17, 2009 8:36 am

Not sure if this is a duplicate of the above but below is link to a page that gives all the face ids for the icons you can put in tool bars, although they have been taken from outlook I think it's all valid for Excel too.

http://www.outlookexchange.com/articles ... KIcons.asp

User avatar
Steve Rowe
Site Admin
Posts: 2031
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: Useful Excel links

Post by Steve Rowe » Fri Jun 12, 2009 10:23 am

Useful page containing samples on VBA to modify other VBA, note the warning about virus scanners though, it's a big pain

http://www.cpearson.com/excel/vbe.aspx

Wim Gielis
MVP
Posts: 2421
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Useful Excel links

Post by Wim Gielis » Fri Jun 12, 2009 5:54 pm

Actually, the entirety of Chip's site is worth looking at... ;)

Lots of interesting material. I always go back to it when I need to work with arrays in VBA (above the obvious work of course).

Wim
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

User avatar
Alan Kirk
Site Admin
Posts: 6111
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2 Classic (PAW-free zone)
Excel Version: 2010 and 2016
Location: Sydney, Australia
Contact:

Re: Useful Excel links

Post by Alan Kirk » Tue Jun 23, 2009 10:18 pm

I'll offer up some links relating to some of my former colleagues from my days on the Excel Usenet groups. Sure do miss those guys, but I just don't have time to be on there any more:

Rob Bovey's Excel Utilities is a worthwhile addition to your toolbar: http://www.appspro.com/Utilities/Utilities.htm

Debra Dalgleish's Contextures site, containing Excel Tips. Especially useful for reminders about some more obscure or infrequently used functions like Match, Indirect, creation of dynamic ranges, etcetera: http://www.contextures.com/tiptech.html

John Walkenbach's tips page. Legendary textbook writer, he writes almost as well as I do. But gets paid a lot more for it. This page includes tips covering anything and everything in Excel: http://spreadsheetpage.com/index.php/tips

The MVP Utilities Page which includes Name Manager, a utility that no serious Excel user should be without: http://www.bmsltd.co.uk/mvp/
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.

alimurat
Posts: 18
Joined: Mon Sep 14, 2009 4:04 pm
OLAP Product: TM1
Version: 10 2 2 FP3
Excel Version: 2010

Re: Useful Excel links

Post by alimurat » Thu Jan 21, 2010 8:44 pm

:?: Any chance someone can put together a demo on how to implement those progress bars in TM1 9.4? :?:

knightowl
Posts: 5
Joined: Fri Apr 01, 2011 4:18 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2003

Re: Useful Excel links

Post by knightowl » Fri Apr 01, 2011 4:23 pm

^^ yes I am interested in doing this as well, anyone?

Wim Gielis
MVP
Posts: 2421
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Useful Excel links

Post by Wim Gielis » Fri Apr 01, 2011 8:50 pm

knightowl,

The progress meters by Andy Pope are nice, I admit. But don't forget that:

- using these meters, you execute code, so you slow down even MORE your code execution in TM1
- these progress meters cannot know how long a particular task will take, hence they cannot know where for instance 50 % or x % of the code is done.
You'll have to come up yourself with some kind of measurement. For instance, if you expect that a particular macro takes 30 seconds, you could increase the meter 10 % every 3 seconds. And so on. But how will you know the actual time it will take?
- VBA code for these meters will have to be implemented in your current codes, so you end up using even more code.

Not very appealing, isn't it? Why not a simple:

Application.Statusbar = "my message"
and
Application.Statusbar = False

Wim
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

knightowl
Posts: 5
Joined: Fri Apr 01, 2011 4:18 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2003

Re: Useful Excel links

Post by knightowl » Tue Apr 19, 2011 9:56 pm

I agree, Very appealing, and very difficult to know how long it will actually take. the Status though can be useful to tell people that it is still running! Thank you

Post Reply