pncExcel

Prime Number Cross Tool

An Excel tool for exploring prime numbers in general
and the Prime Number Cross in particular.

The Prime Number Cross

The Prime Number Cross appears when numbers are arranged in concentical circles forming a "wheel". When the wheel consists of a specific number of spokes, certain spokes, and only those spokes, contain the prime numbers. Se example above where the spokes containing prime numbers forms a "cross". The wheel is sligthly flattened which fits well to the computer screen and when printing to landscape paper orientation.

What does pncExcel do?

pncExcel will arrange the spokes as columns and the circles as rows in an Excel sheet. With this arrangement you can explore where, and if, prime number spokes appears with different numbers of spokes. Among other things that can be marked and explored with pncExcel are; different number bases, statistics for columns or rows, powers of 2, 3 and primes, primes in format Xn+1 and Xn-1 where X is 4 or 6, prime factors, Fibonacci numbers and the music of the primes. There is also a function that reduce the numbers to one digit.

Description

pncExcel is programmed with VBA and MS Excel 2016-2019 for Windows must be present. Later versions of Excel will probably work but have not been tested. There is no demo version or any limitiations but the VBA code is locked and cannot be viewed or edited.