Using Excel

Reply #7

Greenfox — Mon, 23 Mar 2020 16:20:40 GMT

Yes. I do that same thing. It's a good tip to put out there for sure. I really liked some of the new stuff from the new version from the new version, but it seemed to go into the not responding mode more on me. I had a lot of trouble with Windows 10 and the new version of Excel for some reason. Finally got 10 going right, but had to revert back to 2016. It's actually ran a lot faster and the not responding has cut way down. I guess machines play a difference with a lot of it though.

I also ke... [ More ]

Reply #6

db101 — Sun, 22 Mar 2020 22:13:53 GMT

What I do with a macro-enabled Excel sheet is copy-paste the source code of the macro into a txt document and save it in the same folder as the Excel sheet, and save it with the same name as the Excel sheet, but with _macro1, _macro2, etc. appended to the end. That way if the sheets don't save properly with the macro, I still have the code I can insert on the fly. I have not really had this problem since I upgraded to the latest version of Excel, though.

Reply #5

Greenfox — Sat, 21 Mar 2020 18:24:08 GMT

I use all of it. In steps. I build what I need with functions and formulas so I know what it's doing and why. 10 books with 10 different purposes. A main book as a control to compile everything and give me all my data in one spot and 31 days worth of sheets to give me a months worth of pick and play. 9 other books that feed from then back to the control book. Those 9 books track and let me know what is going on and what to look for only. I use as much basic formulas as possible in all of it to h... [ More ]

Reply #4

AllenB — Mon, 09 Mar 2020 19:16:30 GMT

It all starts with the number of times an Option is Drawn and the Number of Options from which it is Drawn. That History is a listing of all Options drawn in each Draw in Each Game. That is a Grid and perfect for a Spread Sheet.

Excel is a Spread Sheet Program. Maintaining an updated Historical Grid serves as a platform from which to look back. The look back increases the number of columns in the grid. Excel has a pretty good set of functions to analyze and group the data. Excel maintains St... [ More ]

Reply #3

Mr-B 216 — Sun, 01 Mar 2020 16:28:16 GMT

I somewhat agree, but for me, I get better performance writing code and creating standalone programs. I find it faster both in terms of creation and performance.

Reply #2

phileight — Sun, 01 Mar 2020 10:23:47 GMT

macros unleash the real power of excel. if you can write a complex formula macros are easier to write, edit or adapt

Reply #1

Mr-B 216 — Wed, 26 Feb 2020 16:20:31 GMT

I rarely use Excel, but when I do, I use it all except for the macros.

Using Excel

Mr-B 216 — Wed, 26 Feb 2020 16:09:57 GMT

1. Power is Functions, Formulas, and Macros.

2. Basics are Sum button and/or changing cell formats.

3. Furmulas and Funtions such as:

=COUNTIF($A$1:$C$10,E1)

=MOD(A1+A2,10)

=IF(AND(A1 3,A1 8), Yes , No )

4. Use it all is all the above plus Macros.