Wednesday, June 22, 2022

Excel VBA macro: The Oracle Physics Constants Generator Rev 3.0 - The Oracle - TOPCG_r3p0

This is a work in progress to investigate the uniqueness and stability of the sign-flip solution to the Full Rydberg polynomial for a single electron hydrogen atom at 0K using a MS Excel VBA macro.

The link points to an Excel file with the VBA macro.  Enable macros to run.

  1. Download Excel file (must have MS Excel to run VBA macros) 
  2. Open the downloaded Excel file and enable macros 
  3. Default is set to 8 digits, runs in under a minute (worksheet calculation is off by default)
  4. Once done running , click Formulas -> Calculate sheet to process plots
  5. Scroll to right of data window and pan around to make plots update and click Formulas -> Calculate
3 constants are set as fixed (golden/yellow) and the remainder vary.  

These are initial results.  Uniqueness and stability has not been proven/demonstrated yet.  


screen captures:
TheOracle-TopPCG_rev3p0 initial and golden values at top of file (8 digits accuracy)



Error (8 digits resolution)

The Surfer, OM-IV
Posted by at

1 comment:

  1. PhxMarkERJune 22, 2022 at 5:31 PM

    My "Convergence!" post is over-exhuberance. It looks like it converges, yet have to show it converges to same values even with different seed values (initial values). When I first developed the algorithm, it produced a -4% proton radius, and with no measurements in the early 1990s to point to a -4% proton radius, rather than go through an exhaustive set of runs and tests, I figured I wait until the data came out as I mentioned before. Now that the measurement has been accepted by NIST/CODAT in 2018, it's time to begin to fully check the algorithm for uniqueness, stability, and accuracy/precision and verification/sanity check.

    ReplyDelete

Watch the water = Lake πŸ‘© πŸŒŠπŸ¦†

Subscribe to: Post Comments (Atom)