Dev build 230526

Dev build 230526

Postby stan » Fri May 26, 2023 9:22 pm

I've uploaded a new dev build with a minor improvement - when exporting tables to MS Excel there's a new option to include cell background colors (hot/cold numbers, row selection, etc)
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Re: Dev build 230526

Postby dreamweaver » Sat May 27, 2023 4:14 am

Hi Stan,

Firstly I would like to thank you for a significant improvement and enhancement to the way users can evaluate EL5 data output in a
spreadsheet environment.

Most output Scenarios/Tables at this stage seem to enable you to copy the background colours of data within those Tables. However
I have found that when I created a PAIRS Table from a Winning Number Analysis the background colours do not seem to be included
when data has been exported.


Thanks and Regards
dreamweaver
 
Posts: 113
Joined: Sat Apr 06, 2013 5:33 am

Re: Dev build 230526

Postby stan » Sat May 27, 2023 10:36 am

Thanks for letting me know, I'll look into that.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Re: Dev build 230526

Postby stan » Sat Jun 03, 2023 11:48 am

So the problem with Pairs table is that there can be two different background colors in each cell. But I can't set two different background colors in MS Excell cell. I'm afraid I can't fix this.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Re: Dev build 230526

Postby dreamweaver » Tue Jun 13, 2023 12:59 am

Hi Stan,

Once again thank you for looking into this issue... :)

I was thinking more so the colours could be set if there is a fixed set of pairs
that have been selected via the "Number Coloring" option.

In this the selected pairs are "locked" in and their coloration remains one color,
as per example below:
Pairs Coloration.JPG


Thanks and Regards
You do not have the required permissions to view the files attached to this post.
dreamweaver
 
Posts: 113
Joined: Sat Apr 06, 2013 5:33 am

Re: Dev build 230526

Postby stan » Fri Jun 16, 2023 9:45 pm

Unfortunately it's not possible either. The backgrounds of pairs and triplets are painted in a special way so the table exporter can't retrieve that color easily.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm

Re: Dev build 230526

Postby dreamweaver » Wed Jun 28, 2023 7:56 am

Sorry the late reply..

Once you have exported into Excel you can create some VB code to color those outcomes according to a criteria.

Thanks Stan
dreamweaver
 
Posts: 113
Joined: Sat Apr 06, 2013 5:33 am

Re: Dev build 230526

Postby stan » Sun Aug 27, 2023 3:28 pm

Well, I don't know how paint multi-colored background in a single cell in Excel so that doesn't seem very feasible to me.
Expert Lotto Team
User avatar
stan
Site Admin
 
Posts: 6338
Joined: Thu Sep 23, 2004 1:01 pm


Return to Development versions

Who is online

Users browsing this forum: No registered users and 5 guests