Animation

zzdave · May 22nd, 2002, 03:38 AM

I saw a cool spreadsheet which showed an animation of numbers which looked like a man walking along. Anyone know how you could this? I tried conditional formatting and looped functions but to no avail.
Any ideas?

Cheerzz

Anne Troy · May 22nd, 2002, 05:20 AM

Hi Dave.

Animation is done with animated graphic files, GIFs.

If you check out your search engine for *free animated gifs*, you'll probably find some pretty cool ones for free. Download them and insert them on your spreadsheet (insert-Picture-from file).

Ivan F Moala · May 22nd, 2002, 05:41 AM

Quote:

On 2002-05-22 02:38, zzdave wrote:
I saw a cool spreadsheet which showed an animation of numbers which looked like a man walking along. Anyone know how you could this? I tried conditional formatting and looped functions but to no avail.
Any ideas?

Cheerzz

Just to add to Dreamboats advice.
get the animated gifs PLUS you will probably
need an ocx file to animate these.
Have a look @ this site for an Ocx.
http://cuinl.tripod.com/downloads/ac...nimatedgif.zip

Can't say I have used this much.

Other alternatives:
Prgm the animation your self.
I have some examples if you are interested.

elgringo56 · May 22nd, 2002, 06:09 AM

Ivan, I would be interested, if the price isn't to high. I would just like to kinda play with it, something to occupy my spare time.

Ivan F Moala · May 22nd, 2002, 06:38 AM

Quote:

On 2002-05-22 05:09, elgringo56 wrote:
Ivan, I would be interested, if the price isn't to high. I would just like to kinda play with it, something to occupy my spare time.

Hi elgringo...the price is right...for you
it cost $0.00

Q · May 22nd, 2002, 06:48 AM

I have put animation in a lot of spreadsheets I have developed, I usually get the same reaction,” Wow, how did you do that. I've never seen movement in a spreadsheet."
Animated gif's work but they can bulk up the file size, and they can be choppy or slow. I use Macromedia Flash. It keeps the file size very low. For instance the file size of a movie with a few dozen words with all the animation bells and whistles is around 5k. Also as long as that users browser has the flash plug-in installed (Win2K & WinXP have it by default), which they usually do, the movie will play in Excel. If you are worried about price you can download a trial version from Morpheos.
And just an FYI- You can use Flash as a front end for an Access database, damn cool for comanies that have a database on an intranet.

[ This Message was edited by: Q on 2002-05-22 05:50 ]

RogerC · Sep 24th, 2002, 08:34 PM

Q - Wow, how DID you do that?

I would like to learn how to use Flash in Excel, but I can't find any information on how to do it. Do you know of any information on this? What is at Morpheos that you are suggesting could be downloaded? I couldn't find anything on it there. Thanks!

Scottie P™ · Sep 24th, 2002, 09:15 PM

Hi RogerC.
funny you should mention Flash in Excel - I was just discussing that with someone via email today.
I - and a few others here - have been working with this technology for a while and the results are stiking!
Considerations for this are:
The end user must have a player for the media and if you want to develop your own, custom Flash Splash screens you need to have Flash or pay someone to do it for you. Generally, nice Flash swf files are not easy to find and you really have to look to find them.
I am fortunate to have Flash so, I am able to work directly with it.
I pulled your email from the member profile page - check your mailbox tomorrow for an email from Viper . . .I will send you a sample of a working Flash film on a userform.

Regards,

ViperGTS

May 22nd, 2002, 05:20 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Hi Dave. Animation is done with animated graphic files, GIFs. If you check out your search engine for free animated gifs, you'll probably find some pretty cool ones for free. Download them and insert them on your spreadsheet (insert-Picture-from file). __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 03:38 AM	#1
zzdave New Member Join Date: May 2002 Location: Aylesbury Posts: 13	I saw a cool spreadsheet which showed an animation of numbers which looked like a man walking along. Anyone know how you could this? I tried conditional formatting and looped functions but to no avail. Any ideas? Cheerzz

May 22nd, 2002, 06:09 AM	#4
elgringo56 Board Regular Join Date: Apr 2002 Location: Puerto Vallarta, Mexico Posts: 869	Ivan, I would be interested, if the price isn't to high. I would just like to kinda play with it, something to occupy my spare time.

May 22nd, 2002, 06:48 AM	#6
Q Board Regular Join Date: Apr 2002 Location: 20 Minutes outside Manhattan Posts: 64	I have put animation in a lot of spreadsheets I have developed, I usually get the same reaction,” Wow, how did you do that. I've never seen movement in a spreadsheet." Animated gif's work but they can bulk up the file size, and they can be choppy or slow. I use Macromedia Flash. It keeps the file size very low. For instance the file size of a movie with a few dozen words with all the animation bells and whistles is around 5k. Also as long as that users browser has the flash plug-in installed (Win2K & WinXP have it by default), which they usually do, the movie will play in Excel. If you are worried about price you can download a trial version from Morpheos. And just an FYI- You can use Flash as a front end for an Access database, damn cool for comanies that have a database on an intranet. [ This Message was edited by: Q on 2002-05-22 05:50 ]

Sep 24th, 2002, 08:34 PM	#7
RogerC Board Regular Join Date: Mar 2002 Location: Phoenix, Arizona Posts: 454	Q - Wow, how DID you do that? I would like to learn how to use Flash in Excel, but I can't find any information on how to do it. Do you know of any information on this? What is at Morpheos that you are suggesting could be downloaded? I couldn't find anything on it there. Thanks!

Sep 24th, 2002, 09:15 PM	#8
Scottie P™ Just A Dude Join Date: Jun 2002 Location: 32137 USA Posts: 268	Hi RogerC. funny you should mention Flash in Excel - I was just discussing that with someone via email today. I - and a few others here - have been working with this technology for a while and the results are stiking! Considerations for this are: The end user must have a player for the media and if you want to develop your own, custom Flash Splash screens you need to have Flash or pay someone to do it for you. Generally, nice Flash swf files are not easy to find and you really have to look to find them. I am fortunate to have Flash so, I am able to work directly with it. I pulled your email from the member profile page - check your mailbox tomorrow for an email from Viper . . .I will send you a sample of a working Flash film on a userform. Regards, ViperGTS