| 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. | DDR4-3600 | 3600 MT/s | .278 ns | 1800 MHz | .556 ns | 18 | 10.01 | 10.84 | 11.95 |
7 | Please remove your values in Columns B & G when you're done. | DDR3-1600 | 1600 MT/s | .625 ns | 800 MHz | 1.250 ns | 9 | 11.25 | 13.13 | 15.63 |
8 | Please remove your values in Columns B & G when you're done. | DDR2-700 | 700 MT/s | 1.429 ns | 350 MHz | 2.858 ns | 3 | 8.57 | 12.86 | 18.58 |
9 | ||||||||||
10 | ||||||||||
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 | ||||||||||