A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | By: EventHorizon01 | ||||||||||||||||
2 | Sadly, the calculator will not funciton with view only permssions so the table starting on line 8 provides the full overview of needed materials for the various sizes | ||||||||||||||||
3 | If you copy this sheet to your drive, you'll be able to use line 7 with it's dropdown selection to calculate all the needed values in a single row ;) Enjoy! | ||||||||||||||||
4 | |||||||||||||||||
5 | Cleenroom Size & Resource Calculator | ||||||||||||||||
6 | Width | Height | Length | Filter Machine Casings | Plascrete Blocks | Max Rein. Glass | PE Pulp | Black Steel Frame | Wet Concrete L's | Black Steel Rods (Assembler) | Black Steel Ingots | Nickle Dust | Steel Dust | Black Bronze (Mixer) | Copper Dust | Gold Dust | |
7 | 15 | 15 | 15 | 168 | 3207 | 160 | 3207 | 3207 | 461808 | 12828 | 6414 | 1283 | 1283 | 3849 | 2310 | 1540 | |
8 | |||||||||||||||||
9 | Full Table Overview | ||||||||||||||||
10 | Min | 3 | 4 | 3 | 0 | 20 | 1 | 20 | 20 | 2880 | 80 | 40 | 8 | 8 | 24 | 15 | 10 |
11 | Max | 15 | 15 | 15 | 168 | 3207 | 160 | 3207 | 3207 | 461808 | 12828 | 6414 | 1283 | 1283 | 3849 | 2310 | 1540 |
12 | 3 | 5 | 3 | 0 | 45 | 2 | 45 | 45 | 6480 | 180 | 90 | 18 | 18 | 54 | 33 | 22 | |
13 | 3 | 6 | 3 | 0 | 54 | 3 | 54 | 54 | 7776 | 216 | 108 | 22 | 22 | 65 | 39 | 26 | |
14 | 3 | 7 | 3 | 0 | 63 | 3 | 63 | 63 | 9072 | 252 | 126 | 26 | 26 | 76 | 46 | 31 | |
15 | 3 | 8 | 3 | 0 | 72 | 4 | 72 | 72 | 10368 | 288 | 144 | 29 | 29 | 87 | 53 | 35 | |
16 | 3 | 9 | 3 | 0 | 81 | 4 | 81 | 81 | 11664 | 324 | 162 | 33 | 33 | 98 | 59 | 40 | |
17 | 3 | 10 | 3 | 0 | 90 | 5 | 90 | 90 | 12960 | 360 | 180 | 36 | 36 | 108 | 65 | 44 | |
18 | 3 | 11 | 3 | 0 | 99 | 5 | 99 | 99 | 14256 | 396 | 198 | 40 | 40 | 119 | 72 | 48 | |
19 | 3 | 12 | 3 | 0 | 108 | 5 | 108 | 108 | 15552 | 432 | 216 | 44 | 44 | 130 | 78 | 52 | |
20 | 3 | 13 | 3 | 0 | 117 | 6 | 117 | 117 | 16848 | 468 | 234 | 47 | 47 | 141 | 85 | 57 | |
21 | 3 | 14 | 3 | 0 | 126 | 6 | 126 | 126 | 18144 | 504 | 252 | 51 | 51 | 152 | 92 | 61 | |
22 | 3 | 15 | 3 | 0 | 135 | 7 | 135 | 135 | 19440 | 540 | 270 | 54 | 54 | 162 | 98 | 65 | |
23 | 5 | 4 | 5 | 8 | 92 | 5 | 92 | 92 | 13248 | 368 | 184 | 37 | 37 | 111 | 67 | 45 | |
24 | 5 | 5 | 5 | 8 | 117 | 6 | 117 | 117 | 16848 | 468 | 234 | 47 | 47 | 141 | 85 | 57 | |
25 | 5 | 6 | 5 | 8 | 142 | 7 | 142 | 142 | 20448 | 568 | 284 | 57 | 57 | 171 | 103 | 69 | |
26 | 5 | 7 | 5 | 8 | 167 | 8 | 167 | 167 | 24048 | 668 | 334 | 67 | 67 | 201 | 121 | 81 | |
27 | 5 | 8 | 5 | 8 | 192 | 10 | 192 | 192 | 27648 | 768 | 384 | 77 | 77 | 231 | 139 | 93 | |
28 | 5 | 9 | 5 | 8 | 217 | 11 | 217 | 217 | 31248 | 868 | 434 | 87 | 87 | 261 | 157 | 105 | |
29 | 5 | 10 | 5 | 8 | 242 | 12 | 242 | 242 | 34848 | 968 | 484 | 97 | 97 | 291 | 175 | 117 | |
30 | 5 | 11 | 5 | 8 | 267 | 13 | 267 | 267 | 38448 | 1068 | 534 | 107 | 107 | 321 | 193 | 129 | |
31 | 5 | 12 | 5 | 8 | 292 | 15 | 292 | 292 | 42048 | 1168 | 584 | 117 | 117 | 351 | 211 | 141 | |
32 | 5 | 13 | 5 | 8 | 317 | 16 | 317 | 317 | 45648 | 1268 | 634 | 127 | 127 | 381 | 229 | 153 | |
33 | 5 | 14 | 5 | 8 | 342 | 17 | 342 | 342 | 49248 | 1368 | 684 | 137 | 137 | 411 | 247 | 165 | |
34 | 5 | 15 | 5 | 8 | 367 | 18 | 367 | 367 | 52848 | 1468 | 734 | 147 | 147 | 441 | 265 | 177 | |
35 | 7 | 4 | 7 | 24 | 172 | 9 | 172 | 172 | 24768 | 688 | 344 | 69 | 69 | 207 | 125 | 83 | |
36 | 7 | 5 | 7 | 24 | 221 | 11 | 221 | 221 | 31824 | 884 | 442 | 89 | 89 | 266 | 160 | 107 | |
37 | 7 | 6 | 7 | 24 | 270 | 14 | 270 | 270 | 38880 | 1080 | 540 | 108 | 108 | 324 | 195 | 130 | |
38 | 7 | 7 | 7 | 24 | 319 | 16 | 319 | 319 | 45936 | 1276 | 638 | 128 | 128 | 383 | 230 | 154 | |
39 | 7 | 8 | 7 | 24 | 368 | 18 | 368 | 368 | 52992 | 1472 | 736 | 148 | 148 | 442 | 266 | 177 | |
40 | 7 | 9 | 7 | 24 | 417 | 21 | 417 | 417 | 60048 | 1668 | 834 | 167 | 167 | 501 | 301 | 201 | |
41 | 7 | 10 | 7 | 24 | 466 | 23 | 466 | 466 | 67104 | 1864 | 932 | 187 | 187 | 560 | 336 | 224 | |
42 | 7 | 11 | 7 | 24 | 515 | 26 | 515 | 515 | 74160 | 2060 | 1030 | 206 | 206 | 618 | 371 | 248 | |
43 | 7 | 12 | 7 | 24 | 564 | 28 | 564 | 564 | 81216 | 2256 | 1128 | 226 | 226 | 677 | 407 | 271 | |
44 | 7 | 13 | 7 | 24 | 613 | 31 | 613 | 613 | 88272 | 2452 | 1226 | 246 | 246 | 736 | 442 | 295 | |
45 | 7 | 14 | 7 | 24 | 662 | 33 | 662 | 662 | 95328 | 2648 | 1324 | 265 | 265 | 795 | 477 | 318 | |
46 | 7 | 15 | 7 | 24 | 711 | 36 | 711 | 711 | 102384 | 2844 | 1422 | 285 | 285 | 854 | 513 | 342 | |
47 | 9 | 4 | 9 | 48 | 276 | 14 | 276 | 276 | 39744 | 1104 | 552 | 111 | 111 | 332 | 200 | 133 | |
48 | 9 | 5 | 9 | 48 | 357 | 18 | 357 | 357 | 51408 | 1428 | 714 | 143 | 143 | 429 | 258 | 172 | |
49 | 9 | 6 | 9 | 48 | 438 | 22 | 438 | 438 | 63072 | 1752 | 876 | 176 | 176 | 526 | 316 | 211 | |
50 | 9 | 7 | 9 | 48 | 519 | 26 | 519 | 519 | 74736 | 2076 | 1038 | 208 | 208 | 623 | 374 | 250 | |
51 | 9 | 8 | 9 | 48 | 600 | 30 | 600 | 600 | 86400 | 2400 | 1200 | 240 | 240 | 720 | 432 | 288 | |
52 | 9 | 9 | 9 | 48 | 681 | 34 | 681 | 681 | 98064 | 2724 | 1362 | 273 | 273 | 818 | 491 | 328 | |
53 | 9 | 10 | 9 | 48 | 762 | 38 | 762 | 762 | 109728 | 3048 | 1524 | 305 | 305 | 915 | 549 | 366 | |
54 | 9 | 11 | 9 | 48 | 843 | 42 | 843 | 843 | 121392 | 3372 | 1686 | 338 | 338 | 1012 | 608 | 405 | |
55 | 9 | 12 | 9 | 48 | 924 | 46 | 924 | 924 | 133056 | 3696 | 1848 | 370 | 370 | 1109 | 666 | 444 | |
56 | 9 | 13 | 9 | 48 | 1005 | 50 | 1005 | 1005 | 144720 | 4020 | 2010 | 402 | 402 | 1206 | 724 | 483 | |
57 | 9 | 14 | 9 | 48 | 1086 | 54 | 1086 | 1086 | 156384 | 4344 | 2172 | 435 | 435 | 1304 | 783 | 522 | |
58 | 9 | 15 | 9 | 48 | 1167 | 58 | 1167 | 1167 | 168048 | 4668 | 2334 | 467 | 467 | 1401 | 841 | 561 | |
59 | 11 | 4 | 11 | 80 | 404 | 20 | 404 | 404 | 58176 | 1616 | 808 | 162 | 162 | 485 | 291 | 194 | |
60 | 11 | 5 | 11 | 80 | 525 | 26 | 525 | 525 | 75600 | 2100 | 1050 | 210 | 210 | 630 | 378 | 252 | |
61 | 11 | 6 | 11 | 80 | 646 | 32 | 646 | 646 | 93024 | 2584 | 1292 | 259 | 259 | 776 | 466 | 311 | |
62 | 11 | 7 | 11 | 80 | 767 | 38 | 767 | 767 | 110448 | 3068 | 1534 | 307 | 307 | 921 | 553 | 369 | |
63 | 11 | 8 | 11 | 80 | 888 | 44 | 888 | 888 | 127872 | 3552 | 1776 | 356 | 356 | 1066 | 640 | 427 | |
64 | 11 | 9 | 11 | 80 | 1009 | 50 | 1009 | 1009 | 145296 | 4036 | 2018 | 404 | 404 | 1211 | 727 | 485 | |
65 | 11 | 10 | 11 | 80 | 1130 | 57 | 1130 | 1130 | 162720 | 4520 | 2260 | 452 | 452 | 1356 | 814 | 543 | |
66 | 11 | 11 | 11 | 80 | 1251 | 63 | 1251 | 1251 | 180144 | 5004 | 2502 | 501 | 501 | 1502 | 902 | 601 | |
67 | 11 | 12 | 11 | 80 | 1372 | 69 | 1372 | 1372 | 197568 | 5488 | 2744 | 549 | 549 | 1647 | 989 | 659 | |
68 | 11 | 13 | 11 | 80 | 1493 | 75 | 1493 | 1493 | 214992 | 5972 | 2986 | 598 | 598 | 1792 | 1076 | 717 | |
69 | 11 | 14 | 11 | 80 | 1614 | 81 | 1614 | 1614 | 232416 | 6456 | 3228 | 646 | 646 | 1937 | 1163 | 775 | |
70 | 11 | 15 | 11 | 80 | 1735 | 87 | 1735 | 1735 | 249840 | 6940 | 3470 | 694 | 694 | 2082 | 1250 | 833 | |
71 | 13 | 4 | 13 | 120 | 556 | 28 | 556 | 556 | 80064 | 2224 | 1112 | 223 | 223 | 668 | 401 | 268 | |
72 | 13 | 5 | 13 | 120 | 725 | 36 | 725 | 725 | 104400 | 2900 | 1450 | 290 | 290 | 870 | 522 | 348 | |
73 | 13 | 6 | 13 | 120 | 894 | 45 | 894 | 894 | 128736 | 3576 | 1788 | 358 | 358 | 1073 | 644 | 430 | |
74 | 13 | 7 | 13 | 120 | 1063 | 53 | 1063 | 1063 | 153072 | 4252 | 2126 | 426 | 426 | 1276 | 766 | 511 | |
75 | 13 | 8 | 13 | 120 | 1232 | 62 | 1232 | 1232 | 177408 | 4928 | 2464 | 493 | 493 | 1479 | 888 | 592 | |
76 | 13 | 9 | 13 | 120 | 1401 | 70 | 1401 | 1401 | 201744 | 5604 | 2802 | 561 | 561 | 1682 | 1010 | 673 | |
77 | 13 | 10 | 13 | 120 | 1570 | 79 | 1570 | 1570 | 226080 | 6280 | 3140 | 628 | 628 | 1884 | 1131 | 754 | |
78 | 13 | 11 | 13 | 120 | 1739 | 87 | 1739 | 1739 | 250416 | 6956 | 3478 | 696 | 696 | 2087 | 1253 | 835 | |
79 | 13 | 12 | 13 | 120 | 1908 | 95 | 1908 | 1908 | 274752 | 7632 | 3816 | 764 | 764 | 2290 | 1374 | 916 | |
80 | 13 | 13 | 13 | 120 | 2077 | 104 | 2077 | 2077 | 299088 | 8308 | 4154 | 831 | 831 | 2493 | 1496 | 998 | |
81 | 13 | 14 | 13 | 120 | 2246 | 112 | 2246 | 2246 | 323424 | 8984 | 4492 | 899 | 899 | 2696 | 1618 | 1079 | |
82 | 13 | 15 | 13 | 120 | 2415 | 121 | 2415 | 2415 | 347760 | 9660 | 4830 | 966 | 966 | 2898 | 1739 | 1160 | |
83 | 15 | 4 | 15 | 168 | 732 | 37 | 732 | 732 | 105408 | 2928 | 1464 | 293 | 293 | 879 | 528 | 352 | |
84 | 15 | 5 | 15 | 168 | 957 | 48 | 957 | 957 | 137808 | 3828 | 1914 | 383 | 383 | 1149 | 690 | 460 | |
85 | 15 | 6 | 15 | 168 | 1182 | 59 | 1182 | 1182 | 170208 | 4728 | 2364 | 473 | 473 | 1419 | 852 | 568 | |
86 | 15 | 7 | 15 | 168 | 1407 | 70 | 1407 | 1407 | 202608 | 5628 | 2814 | 563 | 563 | 1689 | 1014 | 676 | |
87 | 15 | 8 | 15 | 168 | 1632 | 82 | 1632 | 1632 | 235008 | 6528 | 3264 | 653 | 653 | 1959 | 1176 | 784 | |
88 | 15 | 9 | 15 | 168 | 1857 | 93 | 1857 | 1857 | 267408 | 7428 | 3714 | 743 | 743 | 2229 | 1338 | 892 | |
89 | 15 | 10 | 15 | 168 | 2082 | 104 | 2082 | 2082 | 299808 | 8328 | 4164 | 833 | 833 | 2499 | 1500 | 1000 | |
90 | 15 | 11 | 15 | 168 | 2307 | 115 | 2307 | 2307 | 332208 | 9228 | 4614 | 923 | 923 | 2769 | 1662 | 1108 | |
91 | 15 | 12 | 15 | 168 | 2532 | 127 | 2532 | 2532 | 364608 | 10128 | 5064 | 1013 | 1013 | 3039 | 1824 | 1216 | |
92 | 15 | 13 | 15 | 168 | 2757 | 138 | 2757 | 2757 | 397008 | 11028 | 5514 | 1103 | 1103 | 3309 | 1986 | 1324 | |
93 | 15 | 14 | 15 | 168 | 2982 | 149 | 2982 | 2982 | 429408 | 11928 | 5964 | 1193 | 1193 | 3579 | 2148 | 1432 | |
94 | 15 | 15 | 15 | 168 | 3207 | 160 | 3207 | 3207 | 461808 | 12828 | 6414 | 1283 | 1283 | 3849 | 2310 | 1540 |