The prime numbers appear in certain spokes. The PNC function will generate a graphic – the PNC – on a blank Excel sheet according to the number of spokes and circles assigned.
The PNC as an Excel sheet
The numbers can also be set on an ordinary Excel sheet with cells. The columns in this sheet corresponds to the spokes and the rows corresponds to the circles.
Marking the spokes and primes
The prime number spokes can be marked, with or without other columns visible. Cells containing the primes can also be marked, with or without other numbers visible.
Formatting
Formatting can be applied to cells and numbers. Cell width and height, justification, font size, bold font and font color can be set.
Marking
Marking of different items is possible. Here powers of 2, powers of 3, prime powers and the Fibonacci series are marked. Note that start number in this example is set to 125.
Statistics
Vertical: Statistics for each prime number column is shown on top of the sheet. The rows show from top and down: Number or primes om spoke, % primes in spoke, sum of all numbers in spoke, sum of primes in spoke, primes sum % in spoke and number of primes with certain end digit..
Horizontal: Statistics for each circle (row) is shown to the left in the sheet. The columns show from left to right: Number of primes in row, sum of primes in row and sum of all number in row.
Xn±1
Xn±1 can be marked where X=6 or X=4. In this example X=6, blue background marks 6n+1 and red background marks 6n-1.
Prime Factors
This function checks numbers for two prime factors and if found shows factors in cell with colors according to 6n±1. Note that in this example the start number is quite high.
Reduce numbers
This function reduces numbers to one digit by successively adding the numbers digits until one digit remains. This example starts at the number 1. Note that the prime numbers still are marked.
