barnett@unclejack.crd.ge.com (Bruce Barnett) (01/03/90)
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@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