Useful Excel links

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Martin Ryan
Site Admin
Posts: 1988
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 »

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: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Useful Excel links

Post by jim wood »

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.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Useful Excel links

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Useful Excel links

Post by Steve Rowe »

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
Technical Director
www.infocat.co.uk
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Useful Excel links

Post by Wim Gielis »

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

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Useful Excel links

Post by Alan Kirk »

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 »

:?: 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 »

^^ yes I am interested in doing this as well, anyone?
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Useful Excel links

Post by Wim Gielis »

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

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements 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 »

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