Spreadsheet: 75802d1276371099-consolidate-4-worksheets-into-1-copypastetest
Sheet: Consolidate

Sequence | Designator | Type | Value | Footprint | Description | Qty | price | Ordercode | Note | Inspect1 | Reference
0 |  |  |  |  | PCB |  |  | PCB: MAINBOARD-V2 |  |  | GBR 02 gerber mainboard_2.2.zip
1 | U1 | ATmega16 |  | TQFP44 (smd) | microcontroller | 1 | 4.135 | DK: ATMEGA16L-8PU-ND |  | check orientation
2 | C1,C2,C3,C4,C6, C7,C9,C10,C11, C12,C16,C17,C18 | ceramic | 100n | 1206 (smd) | Capacitor | 13 | 0.012 | DK: 490-1775-2-ND
3 | C13,C14 | ceramic | 22p | 1206 (smd) | Capacitor | 2 | 0.014 | DK: 478-1308-2-ND
4 | D1,D2,D3,D18 | FM4007 |  | (smd) | diode | 4 | 0.044 | [NAME]: S1M-FDITR-ND |  | check polarity
5 | D4 | Zener 5V6 | 5V6 | pth | zener diode | 1 |  | HT: ZENER-5V6 |  | check polarity
6 | [NAME], [NAME] | 1N5819 |  | pth | Schottky diode | 4 | 0.069 | DK: 1N5819FSTR-ND |  | check polarity
7 | DS1,DS2,DS3 | LED green | green | (smd) | LED green | 3 |  | HT: LED-SMD-GREEN |  | check polarity
8 | L1 | Inductor | 1uH | 1206 (smd) | Inductor | 1 | 0.08453 | DK: 445-1517-2-ND
9 | C8,C20 | tantalon | 100uF/16V | (smd) | Capacitor | 2 | 0.473 | DK: 478-1723-2-ND |  | check polarity
10 | C15 | elco | 100uF/16V | (smd) | Capacitor | 0 | 0.473 | DK: 478-1723-2-ND | do not solder | check polarity
11 | Q1,Q2,Q8,Q9,Q10 | 2SC1815 |  | SOT23 (smd) | NPN transistor | 5 | 0.024 | DK: [NAME] | substitute MMBT3904
12 | [NAME], R9,R10,R11,R13, R14,R15,R17,R18, [NAME] | resistor | 4K7 | 1206 (smd) | Resistor | 18 | 0.0135 | [NAME]: P4.70KFTR-ND
13 | R4 | resistor | 10K | 1206 (smd) | Resistor | 1 | 0.0135 | [NAME]: P10.0KFTR-ND
14 | R21,R22 | resistor | 2K2 | 1206 (smd) | Resistor | 2 | 0.009 | DK: RHM2.20KFRTR-ND
15 | R30 | resistor | 5K6 | 1206 (smd) | Resistor | 0 | 0.00597 | DK: 311-5.60KFRTR-ND | do not solder
16 | R31,R34 | resistor | 1K | 1206 (smd) | Resistor | 0 | 0.01 | DK: 541-1.00KFTR-ND | do not solder
17 | R32 | resistor | 120 | 1206 (smd) | Resistor | 0 | 0.01104 | [NAME]: RHM120FTR-ND | do not solder
18 | R33 | resistor | 8K2 | 1206 (smd) | Resistor | 0 | 0.01 | [NAME]:  541-8.20KFTR-ND | do not solder
19 | R35 | resistor | 3K9 | 1206 (smd) | Resistor | 0 | 0.009 | DK: RHM3.90KFRTR-ND | do not solder
20 | R42,R43,R44 | resistor | 220 | 1206 (smd) | Resistor | 3 |  | [NAME]: RHM220FRTR-ND
21 | U2 | 78M05 | 500mA | (smd) | Regulator | 1 | 0.33 | [NAME]: MC78M05CDTXTR-ND
22 | U3 | LM3914N |  | dil18 | bar display driver | 0 |  | HT: LM3914N | do not solder | check orientation
23 | U4 | MAX485CPA |  | dil8 | RS485 tranceiver | 0 | 2.08 | DK: MAX485CPA+-ND | do not solder | check orientation
24 | U5 | DS1307 |  | dil8 | Real time clock | 0 |  | HT: DS1307 | do not solder | check orientation
25 | U6 | 24256 or smaller |  | dil8 | EEPROM | 1 | 0.2912 | [NAME]: AT24C02B-PU-ND | use AT24C02 | check orientation
26 | Y1 | XTAL | 4MHz | pth | Crystal | 1 | 0.2158 | DK: 887-1002-ND
27 | Y2 | XTAL | 32.768 kHz | pth | Crystal | 0 | 0.14 | DK: 535-9032-ND | do not solder
28 | C5,C19 | elco | 1000uF/16V | pth | Capacitor | 2 |  | CG: ELCO-1000uF-16V |  | check polarity
29 | X3,X4,X7 | AC conn DIN96 | A and C (socket) | pth | slot 1-3 | 3 |  | HT: AC-DINN-CONN-SOCK
30 | JP1 | header+clips |  | HDR8x2 | bargraph connector | 0 |  | HT: HDR8x2+CLIPS | do not solder | check orientation
31 | JP2 | header+clips |  | HDR5x2 | programmer connector | 1 |  | HT: HDR5x2+CLIPS |  | check orientation
32 | JP3 | Lithium battery | 3V |  | [NAME] | 0 |  | HT: LITHIUM-3V | do not solder | check polarity
0 |  |  |  |  | PCB |  |  | PCB: INTERFACE |  | GBR 05 gerber interface_1.1.zip
1 | C21, C22 | ceramic | 100n | 1206 (smd) | Capacitor | 0 | 0.012 | DK: 490-1775-2-ND | do not solder
2 | R6, R7, R8 |  | 470 | 1206 (smd) | Resistor | 0 | 0.0135 | DK: P470FTR-ND | do not solder
3 | U7 | 78M05 | 500mA | (smd) | Regulator | 0 | 0.33 | [NAME]: MC78M05CDTXTR-ND | do not solder
4 | X2 | DIN96 A-C | A-C (pin) |  | A C connector | 1 |  | HT: AC-DINN-CONN-PIN
5 | T1, T2 | header for potmeter |  | pth |  | 0 |  |  | do not solder
6 | [NAME] | header for SSR |  | pth |  | 0 |  |  | do not solder
7 | JP9,JP10,JP12 | header for alarm |  | pth |  | 0 |  |  | [NAME] for alarmled, do not solder
8 | JP11 | jumper |  | pth |  | 0 |  |  | do not solder
9 | JP5,JP7,JP8 | header for sensor |  | pth |  | 3 |  | HT: CONN2
10 | JP3 | header for buzzer |  | pth |  | 0 |  |  | do not solder
11 | JP2,JP6 | header for 12V power |  | pth |  | 2 |  |  | solder wire in
12 | JP1,JP4 | header for RS485 |  | pth |  | 0 |  |  | do not solder
13 | TA0,TA1,TA2 | tempsensor asmbly | sensor DS18B20 | TO92 | 30cm audiocable+ connector+ sensor | 0 |  |  | connect to JP5,JP7, JP8
14 | ALED | alarmled asmbly | LED red frontpanel | frontpanel mount | 20cm wire+ connector+ led | 0 |  |  | connect to JP12, do not solder
15 | SSRW | ssr wire asmbly |  |  | 20cm wire+ connector | 0 |  |  | connect to JP13, do not solder
16 | POT0,POT1 | potmeter asmbly | 10K potmeter | frontpanel mount | 20cm wire+ connector+ potmeter | 0 |  |  | connect to T1,T2, do not solder
17 | POW0,POW1 | powersupply asmbly |  |  | 20cm wire | 0
18 | BUZZ | buzzer assembly | DC 3-20V buzzer | frontpanel mount | 20cm wire+ buzzer+ MUTE+ connector | 0 |  |  | connect to JP3, do not solder
19 | MUTE | buzzer mute | toggle button | frontpanel mount | " | 0 |  |  | add to buzzer assembly, do not solder
0 |  |  |  |  | PCB |  |  | PCB: DISPLAY-V2 |  |  | GBR 03 gerber display_2.0.zip
1 | U1 | ATmega16 |  | TQFP44 (smd) | microcontroller | 1 | 4.135 | DK: ATMEGA16L-8PU-ND |  | check orientation
2 | C1,C2,C3,C4,C6, C7,C11,C12, C18 | ceramic | 100n | 1206 (smd) | Capacitor | 9 | 0.012 | DK: 490-1775-2-ND
3 | C13,C14 | ceramic | 22p | 1206 (smd) | Capacitor | 2 | 0.014 | DK: 478-1308-2-ND
4 | D1,D2,D3,D18 | FM4007 |  | (smd) | diode | 4 | 0.044 | [NAME]: S1M-FDITR-ND |  | check polarity
5 | D4, D17 | 1N5819 |  | truehole | Schottky diode | 2 | 0.069 | DK: 1N5819FSTR-ND |  | check polarity
6 | L1 | Inductor | 1uH | (smd) | Inductor | 1 | 0.08453 | DK: 445-1517-2-ND
7 | C8,C20 | tantalon | 100uF/16V | (smd) | Capacitor | 2 | 0.473 | DK: 478-1723-2-ND |  | check polarity
8 | C15 | elco | 100uF/16V | (smd) | Capacitor | 1 | 0.473 | DK: 478-1723-2-ND |  | check polarity
9 | Q8,Q9 | 2N3904 |  | SOT23 (smd) | NPN transistor | 2 | 0.024 | DK: [NAME] |  | check
10 | Q1,Q2,Q3,Q4,Q5 | 2N3906 |  | SOT23 (smd) | PNP transistor | 5 | 0.024 | [NAME]: MMBT3906-TPTR-ND |  | check
11 | R4 | resistor | 10K | 1206 (smd) | Resistor | 1 | 0.0135 | [NAME]: P10.0KFTR-ND |  | check
12 | R32 | resistor | 120 | 1206 (smd) | Resistor | 0 | 0.01 | DK: 541-120FTR-ND | do not solder | check
13 | R1,R2,R5,R6,R8,R11, R16,R20,R21 | resistor | 150 | 1206 (smd) | Resistor | 9 | 0.0135 | [NAME]: P150FTR-ND |  | check
14 | R3,R7,R9,R10,R12 | resistor | 680 | 1206 (smd) | Resistor | 5 | 0.01 | DK: 541-680FTR-ND |  | check
15 | R13,R14,R15,R17, R18,R22,R23,R24, R25 | resistor | 4K7 | 1206 (smd) | Resistor | 9 | 0.0135 | [NAME]: P4.70KFTR-ND |  | check
16 | R30 | resistor | 5K6 | 1206 (smd) | Resistor | 1 | 0.00597 | DK: 311-5.60KFRTR-ND |  | check
17 | R35 | resistor | 3K9 | 1206 (smd) | Resistor | 1 | 0.009 | DK: RHM3.90KFRTR-ND |  | check
18 | R33 | resistor | 8K2 | 1206 (smd) | Resistor | 1 | 0.01 | [NAME]:  541-8.20KFTR-ND |  | check
19 | R26 | resistor | 15K | 1206 (smd) | Resistor | 1 | 0.00597 | DK: 311-15.0KFRTR-ND |  | check
20 | R19,R27 | resistor | 1K | 1206 (smd) | Resistor | 2 | 0.01 | DK: 541-1.00KFTR-ND |  | check
21 | U2 | 78M05 | 500mA | (smd) | Regulator | 1 | 0.33 | [NAME]: MC78M05CDTXTR-ND
22 | U3 | LM3914N |  | truehole dil18 | bar display driver | 1 |  | HT: LM3914N |  | check orientation
23 | U4 | MAX485CPA |  | truehole dil8 | RS485 tranceiver | 0 | 2.08 | DK: MAX485CPA+-ND | do not solder | check orientation
24 | Y1 | XTAL | 4MHz | truehole | Crystal | 1 | 0.2158 | DK: 887-1002-ND
25 | C5 | elco | 1000uF/16V | truehole | Capacitor | 1 |  | CG: ELCO-1000uF-16V |  | check polarity
26 | JP2 | header+clips |  | HDR5x2 | programmer connector | 1 |  | HT: HDR5x2+CLIPS |  | check orientation
27 | JP3 | header |  | HDR16 | connector | 1 |  | HT: HDR16 | to LCD
28 | LCD | ATM1602 | blue backlight |  |  | 1 |  | HB: ATM1602-BLUE | order at HB China
29 | bolt/nut/washer | M2 |  |  |  | 3 |  | CG: BOLT-NUT-M2 | mount LCD
30 | LEDBAR1 | ledbar |  | PTH |  | 1 |  | HT: LEDBAR-RED | include IC socket
31 | LSEG1,LSEG2 | 7segment display | red | PTH |  | 2 |  | HT: DUAL7SEGMENT-RED | include IC socket | check dot
32 | LSEGSM1 | 7segment display | red | PTH smaller |  | 1 | 0.425 | DK: 160-1527-5-ND | include 2 IC socket | check dot
33 | J1 | SUBD15 | 2 rows | PTH | SUBD connector | 1 |  | HT: SUBD15-2ROW
34 | P1 | header |  | HDR5x2 | connector | 1 |  | HT: HDR5x2
35 | [NAME] | header | 3 pin | PTH | 485 bus | 0 |  | HT: [NAME]
36 | JP6 | Buzzer | AC | PTH | Buzzer | 1 | 1.16 | DK: 102-1146-ND
37 | JP7 | AlarmLED |  | frontpanel mount |  | 1 |  | CG: ALARMLED | include 2 wires to mount | check polarity
38 | JP8 | Mute switch |  | frontpanel mount |  | 1 |  | CG: MUTESWITCH | include 2 wires to mount
39 | T1,T2 | Potmeter 10K | 10K | frontpanel mount |  | 2 |  | HT: 10K-POTMETER | include 3 wires to mount | check polarity
0 |  |  |  |  | PCB |  |  | PCB: BUCKHEATER |  | GBR 04 gerber buckheater_1.0.zip
1 | C2,C6 | ceramic | 100n | 1206 (smd) | Capacitor | 2 | 0.012 | DK: 490-1775-2-ND
2 | [NAME] | ceramic | 1n | 1206 (smd) | Capacitor | 1 | 0.029 | DK: 478-1530-1-ND
3 | Q1 | 2N3904 |  | SOT23 (smd) | NPN transistor | 1 | 0.024 | DK: [NAME]
4 | Q3,Q4 | 2N3906 |  | SOT23 (smd) | PNP transistor | 2 | 0.024 | [NAME]: MMBT3906-TPTR-ND
5 | R1,R16 | resistor | 1K | 1206 (smd) | Resistor | 2 | 0.01 | DK: 541-1.00KFTR-ND
6 | R2,R11,R14 | resistor | 10K | 1206 (smd) | Resistor | 3 | 0.0135 | [NAME]: P10.0KFTR-ND
7 | R3 | resistor | 47 | 1206 (smd) | Resistor | 1 | 0.01104 | DK: RHM47.0FTR-ND
8 | R4,R17 | resistor | 4K7 | 1206 (smd) | Resistor | 2 | 0.0135 | [NAME]: P4.70KFTR-ND
9 | R5 | resistor | 470 | 1206 (smd) | Resistor | 1 | 0.0135 | DK: P470FTR-ND
10 | R6 | resistor | 330 | 1206 (smd) | Resistor | 1 | 0.01 | DK: 541-330FTR-ND
11 | R7,R36 | resistor | 100K | 1206 (smd) | Resistor | 2 | 0.0135 | DK: P100KFTR-ND
12 | R8 | resistor | 2K2 | 1206 (smd) | Resistor | 1 | 0.009 | DK: RHM2.20KFRTR-ND
13 | R9 | resistor | 22K | 1206 (smd) | Resistor | 1 | 0.01 | [NAME]:  541-22.0KFTR-ND
14 | R10 | resistor | 1 | 1206 (smd) | Resistor | 1 | 0.01 | [NAME]:  541-1.00FFTR-ND
15 | R15 | resistor | 3K9 | 1206 (smd) | Resistor | 1 | 0.009 | DK: RHM3.90KFRTR-ND
16 | R22 | resistor | 27K | 1206 (smd) | Resistor | 1 | 0.01 | DK: 541-27.0KFTR-ND
17 | TS1 | LM35 |  | TO92 | Temp sensor | 1 | 1.3752 | DK: LM35DZ-ND | clamp to heatsink
18 | U1 | 494 |  | dil16 | PWM switchmode | 1 | 0.4536 | DK: 296-1799-5-ND
19 | U2 | LM358 |  | dil8 | opamp | 1 | 0.3588 | [NAME]: LM358NGOS-ND
20 | R12,R13 | resistor 3W | 0.22 / 3W | pth | Resistor | 2 |  | HT: RES0.22OHM3W
21 | Q2 | IRF9540N |  | TO220 | P-MOSFET | 1 |  | HT: IRF9540N | N version really important!
22 | Q2-heatsink | heatsink | 30x12x20x1 mm |  | Heatsink | 1 |  | MTTS HEATSINK
23 | D5 | D10SC4M |  | TO220 | Schottky diode | 1 |  | HT: D10SC4M
24 | C12,C14 | elco (low esd) | 1000uF/16V | pth | Elco | 2 |  | CG: ELCO-1000uF-16V
25 | C5 | elco | 1uF/16V | smd | Elco | 1 |  | HT: ELCOSMD-1uF-16V
26 | C1 | elco | 4u7F/16V | smd | Elco | 1 |  | HT: ELCOSMD-4u7F-16V
27 | C4 | elco | 330uF/16V | pth | Capacitor | 1 |  | HT: ELCOPTH-330uF-16V | 330uF/16V for tubeset
28 | P1,P2,P3 | header |  | HDR1x3 | header+jumper | 3 |  | HT: HDR1x3
29 | X2 | DIN96 A-C | A-C (pin) | pth | A C connector | 1 |  | HT: AC-DINN-CONN-PIN
30 | L1 | inductor | 10uH | pth | Inductor | 1 |  | CG: FERRITEBAR | 7 turns. wire 0.9mm
31 | L5 | inductor | 70uH | pth | Inductor | 1 |  | CG: FERRITEBAR | 40 turns. wire 0.5mm
34 |  | bolt 10mm | M3 |  |  | 2 |  | CG: BOLT-M3-10mm | clamp heatsink+diode
35 |  | nut | M3 |  |  | 2 |  | CG: NUT-M3 | clamp heatsink+diode
36 |  |  |  |  | thermal grease | 2 |  | CG: THERMALGREASE | between heatsink/mosfet