Setup tables, etc.

[Bruce Barnett]

In v9n1:
>Another big project that I would like to undertake in the upcoming
>months is to create a compilation of setup tables:

Along those lines, here is a spreadsheet template for calculating disk
partitions.

The template looks like this:
              A             B       C       D       E       F       G   
0                       <
1   Heads/Disk        20
2   Sectors/Cylinders 67
3   Starting Cylinder  0
4  
5   Blocks/Cylinder         1340
6  
7                size(C) Size(B) Size(M) Strt(C) Strt(B)  End(C)  End(B)
8   Partition a       15   20100   10.29       0       0      15   20100
9   Partition b      154  206360  105.66      15   20100     169  226460
10  Partition d      359  481060  246.30     169  226460     528  707520
11  Partition e      200  268000  137.22     528  707520     728  975520
12  Partition f       17   22780   11.66     728  975520     745  998300
13  Partition g       95  127300   65.18     745  998300     840 1125600
14  Partition h        0       0    0.00     840 1125600     840 1125600
15                     0       0    0.00       0       0       0       0
16 
17  Total            840 1125600  576.31                       0


You modify the numbers in the first column (rows 1,2,3,8-14).

I have used it to calculate ND partitions for SunOS 3.5 servers.  The
spreadsheet program, currently supported by Bob Bond (uunet!sequent!rgb)
has been posted to USENET several times.

Spreadsheet template follows:

# This data file was generated by the Spreadsheet Calculator.
# You almost certainly shouldn't edit it.
# Created by Bruce Barnett <barnett at crd.ge.com>
# All commercial rights reserved
# Copyright 1990
format A 20 0
format B 8 0
format C 8 2
format D 8 0
format E 8 0
format F 8 0
format G 8 0
leftstring A1 = "Heads/Disk"
let A1 = 20
leftstring A2 = "Sectors/Cylinders"
let A2 = 67
leftstring A3 = "Starting Cylinder"
let A3 = 0
leftstring A5 = "Blocks/Cylinder"
let B5 = A1*A2
rightstring A7 = "size(C)"
rightstring B7 = "Size(B)"
rightstring C7 = "Size(M)"
rightstring D7 = "Strt(C)"
rightstring E7 = "Strt(B)"
rightstring F7 = "End(C)"
rightstring G7 = "End(B)"
leftstring A8 = "Partition a"
let A8 = 15
let B8 = A8*fixed B5
let C8 = B8*0.000512
let D8 = fixed A3+A7
let E8 = D8*fixed B5
let F8 = D8+A8
let G8 = F8*fixed B5
leftstring A9 = "Partition b"
let A9 = 154
let B9 = A9*fixed B5
let C9 = B9*0.000512
let D9 = F8
let E9 = D9*fixed B5
let F9 = D9+A9
let G9 = F9*fixed B5
leftstring A10 = "Partition d"
let A10 = 359
let B10 = A10*fixed B5
let C10 = B10*0.000512
let D10 = F9
let E10 = D10*fixed B5
let F10 = D10+A10
let G10 = F10*fixed B5
leftstring A11 = "Partition e"
let A11 = 200
let B11 = A11*fixed B5
let C11 = B11*0.000512
let D11 = F10
let E11 = D11*fixed B5
let F11 = D11+A11
let G11 = F11*fixed B5
leftstring A12 = "Partition f"
let A12 = 17
let B12 = A12*fixed B5
let C12 = B12*0.000512
let D12 = F11
let E12 = D12*fixed B5
let F12 = D12+A12
let G12 = F12*fixed B5
leftstring A13 = "Partition g"
let A13 = 95
let B13 = A13*fixed B5
let C13 = B13*0.000512
let D13 = F12
let E13 = D13*fixed B5
let F13 = D13+A13
let G13 = F13*fixed B5
leftstring A14 = "Partition h"
let A14 = 0
let B14 = A14*fixed B5
let C14 = B14*0.000512
let D14 = F13
let E14 = D14*fixed B5
let F14 = D14+A14
let G14 = F14*fixed B5
let A15 = 0
let B15 = A15*fixed B5
let C15 = B15*0.000512
let D15 = F15
let E15 = D15*fixed B5
let F15 = D15+A15
let G15 = F15*fixed B5
leftstring A17 = "Total"
let A17 = @sum(A8:A15)
let B17 = A17*fixed B5
let C17 = B17*0.000512
let F17 = F15