commit be8da8ae0070dd230c1e08fbada4b51edd7fe892
parent f3f3fa16cba77ec9fe3851bfa867f5a08e17a5ba
Author: Lukas F. Hartmann <lukas@mnt.mn>
Date: Wed, 6 Jun 2018 20:58:52 +0200
add copy of production spreadsheets
Diffstat:
3 files changed, 133 insertions(+), 0 deletions(-)
diff --git a/spreadsheets/fetch.sh b/spreadsheets/fetch.sh
@@ -0,0 +1,3 @@
+#!/bin/bash
+wget -O production_status.csv "https://docs.google.com/spreadsheets/d/1o5MmcjnUXUqvDNSovIvVbP7XQIZMDLPQgBvyF0soFjs/export?format=csv"
+wget -O motherboard_bom.csv "https://docs.google.com/spreadsheets/d/13ZvuRw21PMBu9xKJPVixFvNTR7WqUfe5qeK15DIdoU4/export?format=csv"
diff --git a/spreadsheets/motherboard_bom.csv b/spreadsheets/motherboard_bom.csv
@@ -0,0 +1,76 @@
+C0603C104K5RECAUTO,500
+F951A106MRAAQ2,10
+LMK107BBj106KALT,100
+T491C106K025AT7280,10
+GCM1885C1H180JA16D,20
+JMK107C6105KA-T,50
+GRM219R61A226MEA0D,50
+EEE-FK1A220AR,20
+GRM188R60J226MEA0D,50
+EEE-FKJ331XAP,15
+GCM1885C1H330FA16J,30
+81-GRM21BR60G336ME5L,10
+EEE-FKJ470UAR,5
+F380J686MSALZT,5
+APTD2012LVBC/D,50
+PDS1040,20
+ZLLS350,10
+48099-5701,28
+693072010801,8
+78938-104HLF,10
+KLDX-0202-AC,8
+90120-0123,10
+90120-0124,10
+951104-8622-AR,30
+826949-2,10
+M22-2520205,10
+826936-2,30
+M22-2510646,10
+826631-6,10
+M22-2520305,10
+M22-2510446,10
+710-685119134923,10
+951210-7622-AR,10
+M22-2510305,10
+M22-2510646,10
+M22-2520346,10
+2199337-5,10
+SJ-43516-SMT,7
+DF40C-100DS-0.4V(51),21
+614004190021,12
+78438356010,10
+SRP4020TA-100M,10
+B953AS-180M=P3,10
+FBMH1608HM221-TV,20
+J0G-0003NL,8
+2N7002-T1-E3,10
+SI2333DDS-T1-GE3,20
+DMNH4015SSDQ-13,10
+CRCW06030000Z0EAC,50
+ESR03EZPJ103,50
+ERA-3ARB222V,10
+PF1206FRF070R02L,10
+ERJ-3EKF2400V,25
+ERJ-3EKF27R0V,50
+CR0603-FX-2702ELF,10
+ERJ-3EKF3300V,25
+CRT0603-BY-4991ELF,15
+ERJ-3EKF4702V,10
+ERA-3AED9531V,10
+ERA-3AED9092V,10
+AP1501A-33K5G-13,7
+ATTINY841-SSU,10
+BQ24650RVAT,11
+CM2020-00TR,10
+INA260AIPW,5
+LP3962EMP-2.5,8
+SGTL5000XNAA3,10
+SN74LVC1G08DCKR,10
+TLV1117-15IDCYR,5
+TLV74311PDBVR,11
+TPS2044BDR,8
+TPS61235RWLR,10
+TUSB4041IPAPR,10
+67910-5700,28
+445I23D24M00000,10
+500SSP1S1M1QEB,15
+\ No newline at end of file
diff --git a/spreadsheets/production_status.csv b/spreadsheets/production_status.csv
@@ -0,0 +1,52 @@
+ID,Component,In Stock,Ordered,To Produce,Re-Stock ETA,Details
+,Motherboard PCB 0.4,0,20,,2018-06-15,
+,Keyboard PCB 0.4,0,20,,2018-06-15,
+,Motherboard Component Sets,15,0,,---,https://docs.google.com/spreadsheets/d/1tC8NwxsB_e73I5NA0eHqHX9hIgEEPQOdpadvEB2_x6U/edit#gid=1327218750
+,Keyboard Component Sets,0,TODO,,2018-06-15,create updated BOM
+,Keyboard Switch Sets (79+2x Cherry ML),22,0,,---,
+,i.MX6QP + 4GB RAM TinyRex 1.2GHz,5,0,,---,1 backordered
+,i.MX6QP + 4GB RAM TinyRex 1.0GHz,10,0,,---,
+,Hinge Pair SMS-ZZ-219 Silver,100,0,,---,
+,LCD LP116WH4-SLN2 (1366x768 IPS),20,0,,---,
+,40 Pin LVDS IPEX cable 300mm LP140WH1,20,0,,---,
+,LiFePo4 Battery 3.2V 11Ah,0,12,,2018-06-15,
+,LiFePo4 Battery 3.2V 10Ah,4,0,,---,
+,Power Supply 5VDC 8A,1,TODO 10,,2018-06-15,
+,Fan HY45T05A-830,10,0,,---,
+,Lasercut Acrylic Grid,0,,10,,
+,Case Part Main Box Top,0,,10,,"All materials for molds are in stock, molding process evaluation starts 2018-06-07"
+,Case Part Main Box Bottom,0,,10,,
+,Case Part Main Box Bottom Plate,0,,10,,
+,Case Part Main Box Closing,0,,10,,
+,Case Part Screen Support Bottom,0,,10,,
+,Case Part Screen Support Closing,0,,10,,
+,Case Part Screen Back,0,,10,,
+,Case Part Screen Front,0,,10,,
+,ML Key Cap 1x1 (66 per Set),0,,660,,Decide until 2018-06-11 if molded or printed in Form2
+,ML Key Cap 2.2x1 (3 per Set),0,,30,,
+,ML Key Cap 2.7x1 (3 per Set),0,,30,,
+,ML Key Cap 3.2x1 (1 per Set),0,,10,,
+,ML Key Cap 3.7x1 (1 per Set),0,,10,,
+,ML Key Cap 4.3x1 (1 per Set),0,,10,,
+,ML Key Cap 2.7x1 LSpace (1 per Set),0,,10,,
+,ML Key Cap 2.7x1 RSpace (1 per Set),0,,10,,
+,ML Key Cap 6x1 MSpace (1 per Set),0,,10,,
+,Keyboard Stabilizer Wires (4 per Set),0,,40,,Folded from wire
+,Keyboard Stabilizer Holders (8 per Set),0,,80,,3D Printed
+,Trackball Key Cap Left,0,,10,,
+,Trackball Key Cap Right,0,,10,,
+,Trackball Roof,0,,10,,
+,Trackball Base,0,,10,,
+,Trackball Ball (Steel?),0,TODO 10,,,
+,Trackball Teensy LC,10,0,,,
+,Trackball Optical Sensor PWM 3360,10,0,,,
+,Power Switch Cable,0,,10,,Soldered power cable with 4x2mm shrouded header male
+,Battery Cable Assembly,0,,10,,Soldered power cable with 4x2.54mm header female
+,Keyboard USB Cable Assembly,0,,10,,Crimped flat cable with 4x2mm pins female
+,Trackball USB Cable Assembly,0,,10,,Crimped flat cable with 4x2mm pins female
+,Trackball Sensor Cable Assembly,0,,10,,
+,Battery Holder (4 per Set),0,,40,,3D printed
+,Set of Screws,,TODO Inventory,,,
+,Package Cardboard Box,0,TODO design,10,,
+,Package Printed Sleeve,0,TODO design,10,,
+,Package Shipping Box,0,,10,,
+\ No newline at end of file
