Particle flow - sparkling

[Paiche59]

Hi Tom,

I'm not a specialist of google sheets, but after a first try the calculation macro is not converted. So it seems that the use of google Sheets is not feasible without a translation of the VBA macro to google Sheets script.

Pascal.

[tom95521]

I forgot I had a free online Excel live.com that launched Excel on my PC. I think I have it (almost) working. The calculation lasted about 12 seconds. I just need to change the image property to the correct path.

Thanks!
Tom

[Paiche59]

Great, you're almost there

[tom95521]

Hi Pascal,

Still playing around with parameters but it works great.

Thanks,
Tom

 

[Paiche59]

Thanks Tom, I really appreciate it. The particles are very elegant.

Best regards,

Pascal.
 

[Sheila Haycox]

Is there an easy way of changing the colour from yellow to white for the Particle Sparkling Stars.   I have tried selecting all and changing the colour but it looks as though you have to do one at a time.

[Paiche59]

12 hours ago, Sheila Haycox said:

Is there an easy way of changing the colour from yellow to white for the Particle Sparkling Stars.   I have tried selecting all and changing the colour but it looks as though you have to do one at a time.

Hello Sheila,

The easiest way to do this is to use the Excel generator which allows you to select the start and end colour of a particle. Simply modify the min and max values of the Red, Green and Blue components in the "Start color" and "Final color" sections. The Excel macro will calculate the colour for all particles.

Good luck,

Pascal.