| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
2 | =arrayformula(if(B6:B<>"","Please remove your values when you're done.",if(G6:G<>"","Please remove your values when you're done.",""))) | =arrayformula(if(B6:B<>"",right(B6:B,len(B6:B)-find("-",B6:B))&" MT/s","")) | =arrayformula(if(C6:C<>"",text(1/(left(C6:C,find(" ",C6:C)-1))*1000,".000")&" ns","")) | =arrayformula(if(C6:C<>"",if(left(B6:B,3)="DDR",int(left(C6:C,find(" ",C6:C)-1)/2)&" MHz",if(left(B6:B,2)="PC",int(left(C6:C,find(" ",C6:C)-1))&" MHz","")),"")) | =arrayformula(if(D6:D<>"",if(left(B6:B,3)="DDR",text(left(D6:D,find(" ",D6:D)-1)*2,".000")&" ns",if(left(B6:B,2)="PC",D6:D,"")),"")) | =arrayformula(if(G6:G<>"",if(left(B6:B,3)="DDR",round(((G6:G*2)+(1-1))*left(D6:D,find(" ",D6:D)-1),2),if(left(B6:B,2)="PC",round((G6:G+(1-1))*left(D6:D,find(" ",D6:D)-1),2),"")),"")) | =arrayformula(if(G6:G<>"",if(left(B6:B,3)="DDR",round(((G6:G*2)+(4-1))*left(D6:D,find(" ",D6:D)-1),2),if(left(B6:B,2)="PC",round((G6:G+(4-1))*left(D6:D,find(" ",D6:D)-1),2),"")),"")) | =arrayformula(if(G6:G<>"",if(left(B6:B,3)="DDR",round(((G6:G*2)+(8-1))*left(D6:D,find(" ",D6:D)-1),2),if(left(B6:B,2)="PC",round((G6:G+(8-1))*left(D6:D,find(" ",D6:D)-1),2),"")),"")) | ||
3 | Type | Data rate | Bit time | Command rate | Cycle time | CAS latency | First word (ns) | Fourth word (ns) | Eighth word (ns) | |
4 | Example: | DDR4-4000 | 4000 MT/s | .250 ns | 2000 MHz | .500 ns | 19 | 9.50 | 10.25 | 11.25 |
5 | Please remove your values in Columns B & G when you're done. | Fill in any yellow fields below. \/ \/ | If different users are using the sheet at the same time, please cooperate - you can each use different sets of rows. i.e. User 1 rows 6-16, User 2 rows 20-30, etc. | |||||||
6 | Please remove your values in Columns B & G when you're done. | DDR5-6000 | 6000 MT/s | .167 ns | 3000 MHz | .334 ns | 28 | 9.35 | 9.85 | 10.52 |
7 | Please remove your values in Columns B & G when you're done. | DDR5-6200 | 6200 MT/s | .161 ns | 3100 MHz | .322 ns | 30 | 9.66 | 10.14 | 10.79 |
8 | Please remove your values in Columns B & G when you're done. | DDR5-6200 | 6200 MT/s | .161 ns | 3100 MHz | .322 ns | 28 | 9.02 | 9.50 | 10.14 |
9 | Please remove your values in Columns B & G when you're done. | DDR5-8000 | 8000 MT/s | .125 ns | 4000 MHz | .250 ns | 36 | 9.00 | 9.38 | 9.88 |
10 | Please remove your values in Columns B & G when you're done. | DDR5-5200 | 5200 MT/s | .192 ns | 2600 MHz | .384 ns | 42 | 16.13 | 16.70 | 17.47 |
11 | ||||||||||
12 | ||||||||||
13 | ||||||||||
14 | ||||||||||
15 | ||||||||||
16 | ||||||||||
17 | ||||||||||
18 | ||||||||||
19 | ||||||||||
20 | ||||||||||
21 | ||||||||||
22 | ||||||||||
23 | ||||||||||
24 | ||||||||||
25 | ||||||||||
26 | ||||||||||
27 | ||||||||||
28 | ||||||||||
29 | ||||||||||
30 | ||||||||||
31 | ||||||||||
32 | ||||||||||
33 | ||||||||||
34 | ||||||||||
35 | ||||||||||
36 | ||||||||||
37 | ||||||||||
38 | ||||||||||
39 | ||||||||||
40 | ||||||||||
41 | ||||||||||
42 | ||||||||||
43 | ||||||||||
44 | ||||||||||
45 | ||||||||||
46 | ||||||||||
47 | ||||||||||
48 | ||||||||||
49 | ||||||||||
50 | ||||||||||
51 | ||||||||||
52 | ||||||||||
53 | ||||||||||
54 | ||||||||||
55 | ||||||||||