| In the Spreadsheet (Spreadsheet.xls): |
| |
(The examples are that of a 22" f/4.75 mirror.)
|
| |
Input: |
| |
|
CCD: |
| |
|
|
G2 = The E-300 CCD cell size in microns (=0.00003937 inches)[2] |
| |
|
|
F2 = The E-300 Lens mount to CCD spacing [3] |
| |
|
|
E2 = Slit to lens mount distance - Figure 13 and 14 |
| |
|
|
J2 = The E-300 CCD glass thickness [2] |
| |
|
|
K2 = The E-300 CCD glass index of refraction [2] |
| |
|
FILM: |
| |
|
|
D2 = Slit to image plane (usually zero). |
|
|
|
H2 = Scanned DPI. |
| |
|
A2 = Mirror optical diameter. |
| |
|
B2 = ROC initially to +/- 1/8". Then refined from Sixtests results. |
| |
|
B4:B12 = Zone h's (linked to 'router mask'!D12:D18) |
| |
|
|
Accuracy of hole positions is refined by flatbed scanning the mask
(direction of scan is most accurate), and then processed in 'router mask' B23:C30 & B33:C40.
The hole positions are then adjusted, using Solver to compensate for parallax i.e.,
rays are not at right angels to the mask.
|
| |
|
|
Solve for the h's - Cells D12:D18 of
'router mask' 12. |
| |
|
|
|
Tools->Solver can only solve for one at a time: |
| |
|
|
|
|
First: F12 value of 0, By Changing D12 |
| |
|
|
|
|
.......................................................... |
| |
|
|
|
|
Last: F18 value of 0, By Changing D18 |
| |
|
Ypix's As measured in Photoshop. |
| |
|
|
D5:D11 left side. |
| |
|
|
E5:E11 right side |
| |
|
|
D4 = Center. |
| |
|
|
|
Used to check if the mask was properly centered. If any of the pixel differences, F5:F11 are greater than +/- 9,
the mask needs to be re-centered and the test done again.
|
| |
Solve for l (C14) - Figure 11 and 12 |
| |
|
Tools->Solver (computations are relative to the edge zone) |
| |
|
|
Target Cell = D14, value of 0 |
| |
|
|
By Changing Cell C14 |
| |
Solve for the Foucault's - Cells F18:F23. |
| |
|
Tools->Solver can only solve for one at a time: |
| |
|
|
First: E18 value of 0, By Changing F18 |
| |
|
|
.......................................................... |
| |
|
|
Last: E23 value of 0, By Changing F23 |
| |
|
Note: |
Because the calculations are relative to the edge, the outer zones s'
(F24) is h2/(2R) (using the outer zones h).
|