(Imported from TWiki) |
Sfosteriam (talk | contribs) m (Added categories) Tag: Navigation |
||
(2 intermediate revisions by the same user not shown) Navigation | |||
| Line 1: | Line 1: | ||
| + | {{DISPLAYTITLE:EMS Inventory System}} |
||
| − | = Burning man stuff = |
||
| + | ==Overview== |
||
| − | === Shade Structure (in container) === |
||
| + | We have tools, resources and systems and we need to answer the same questions for each: |
||
| − | Please see [[Camp Build]] for building instructions. |
||
| − | ==== Center Domes ==== |
||
| − | {| border="1" |
||
| − | |- |
||
| − | | '''Description''' || '''Needed''' || '''Spares''' || '''On hand''' |
||
| − | |- |
||
| − | | Silver tarp 30*30 || 2 || 0 || 2 |
||
| − | |- |
||
| − | | Ten foot 1-1/2" PVC || 20 || 2 || 22 |
||
| − | |- |
||
| − | | Ten foot 1-1/2 PVC with junction || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Parts for Ten foot with junction || 0 || 1 (parts) || 1 |
||
| − | |- |
||
| − | | 1.5 foot 2" PVC couplers || 12 || 2 || 14 |
||
| − | |- |
||
| − | | Two foot PVC cross for center || 1 || 1 (parts) || 1 |
||
| − | |- |
||
| − | | Rebar stakes 3 feet 1/2" || 8 || 1 || 9 |
||
| − | |- |
||
| − | | Rebar stakes 4 feet 1/2" || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Rebar stakes HD , washers , 3 feet 1/2" || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Bolts with wingnuts || 36 || 8 || 44 |
||
| − | |- |
||
| − | | Short rope || 4 || 1 || Lots |
||
| − | |- |
||
| − | | Rope 50 feet 3/16" || 2 || 1 || Lots |
||
| − | |- |
||
| − | | Bamboo poles 23+ foot || 4 || 0 || 4 |
||
| − | |- |
||
| − | | Rebar stakes for above 2' 1/2" || 4 || 0 || 4 |
||
| − | |- |
||
| − | | Rebar stakes for Bamboo guy ropes || 8 || 5 || 13 |
||
| + | * What is it? |
||
| − | |- |
||
| + | * Who does it belong to? |
||
| − | | '''Description''' || '''Needed''' || '''Spares''' || '''On hand''' |
||
| + | * Where is it (or where should it be?) |
||
| − | |- |
||
| + | * Is it available or assigned/checked out by a particular person? |
||
| − | | Silver tarp 30*30 || 2 || 0 || 2 |
||
| + | * Where do I find out more about the thing? |
||
| − | |- |
||
| − | | Ten foot 1-1/2" PVC || 20 || 2 || 22 |
||
| − | |- |
||
| − | | Ten foot 1-1/2 PVC with junction || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Parts for ten foot with junction || 0 || 1 (parts) || 1 |
||
| − | |- |
||
| − | | 1.5 foot 2" PVC couplers || 12 || 2 || 14 |
||
| − | |- |
||
| − | | Two foot Cross for center || 1 || 1 (parts) || 1 |
||
| − | |- |
||
| − | | Rebar stakes 3 feet 1/2" || 8 || 1 || 9 |
||
| − | |- |
||
| − | | Rebar stakes 4 feet 1/2" || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Rebar stakes HD , washers ,3 feet 1/2" || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Bolts with wingnuts || 36 || 8 || 44 |
||
| − | |- |
||
| − | | Short rope || 4 || 1 || Lots |
||
| − | |- |
||
| − | | Rope 50 feet 3/16" || 2 || 1 || Lots |
||
| − | |} |
||
| + | We currently track this stuff in a [https://docs.google.com/spreadsheets/d/1KinB6corc6sPZfWouWg_btkuTiHJbCExcFd8fIOzSDs/edit?usp=sharing google sheet]. When it grows up it wants to be a database. |
||
| − | ==== Bays ==== |
||
| − | {| border="1" |
||
| − | |- |
||
| − | | '''Description''' || '''Needed''' || '''Spares''' || '''On hand''' |
||
| − | |- |
||
| − | | Silver tarps 20 * 30 || 4 || 1 || 5 |
||
| − | |- |
||
| − | | 10 foot sections 1" PVC || 60 || 5 || 65 |
||
| − | |- |
||
| − | | Rope for troughs in bays 1/8" || 600 feet || | 1050feet |
||
| − | |- |
||
| − | | Rope for bay guys and center ties 3/16" || 400 feet || | 650 feet |
||
| − | |- |
||
| − | | Unopened light rope 1/8" || 0 || | 150 feet |
||
| − | |- |
||
| − | | Unopened heavey rope 3/16" || 0 || | 50 feet |
||
| − | |- |
||
| − | | Bay rails || 8 || 0 || 8 |
||
| − | |- |
||
| − | | Rebar 4' 3/8" for PVC || 0 || 12 || 50 |
||
| − | |- |
||
| − | | Rebar stakes for trough rope hooks and washers || 0 || 12 || 21H + 41W |
||
| − | |- |
||
| − | | Rebar stakes for guy ropes 1/2" x 2 (washers) || 8 || 2 || 10 |
||
| − | |- |
||
| − | | 10 foot sections of 1-1/4 PVC || 24 || 1 || 31 |
||
| − | |- |
||
| − | | Couplers for above || 8 || 2 || 9 |
||
| − | |- |
||
| − | | Different colored streamer tape for guy ropes || 2 roles || 0 || |
||
| − | |- |
||
| − | | Shorter bolts and wingnuts for 1-1/4 PVC || 16 || 4 || 20 |
||
| − | |- |
||
| − | | Bamboo poles 15 foot || 8 || 2 || 9 |
||
| − | |- |
||
| − | | Rebar stakes for 15 footers, no washers || 8 || 2 || 15 |
||
| − | |} |
||
| − | == |
+ | ==How it works== |
| − | {| border="1" |
||
| − | |- |
||
| − | | '''Description''' || '''Needed''' || '''Spares''' || '''On hand''' |
||
| − | |- |
||
| − | | Silver tarps 20 * 30 || 2 || 1 || 3 |
||
| − | |- |
||
| − | | 10 foot sections 1" PVC || 36 || 5 || 90? |
||
| − | |- |
||
| − | | Rope for troughs in bays 1/8" || 300 feet || | 1050feet |
||
| − | |- |
||
| − | | Rope for bay guys and center ties 3/16" || 200 feet || | 650 feet |
||
| − | |- |
||
| − | | Bay rails || 6 || 0 || 6 |
||
| − | |- |
||
| − | | Rebar 4' 3/8" for PVC || 0 || 12 || 12 |
||
| − | |- |
||
| − | | Rebar stakes for pleat rope hooks and washers || 0 || 12 || 21H + 41W |
||
| − | |- |
||
| − | | Rebar stakes for guy ropes 1/2" x 2 (washers) || 4 || 2 || 10 |
||
| − | |- |
||
| − | | 10 foot sections of 1-1/4 PVC || 6 || 1 || 31 |
||
| − | |- |
||
| − | | Couplers for above || 2 || 1 || 3 |
||
| − | |- |
||
| − | | Shorter bolts and wingnuts for 1-1/4 PVC || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Bamboo poles 15 foot || 4 || 1 || 5 |
||
| − | |- |
||
| − | | Rebar stakes for 15 footers, no washers || 4 || 1 || 5 |
||
| − | |} |
||
| + | The google sheet is owned by the `system@` eugenemakerspace.com account. If you don't have access to edit this already, you can request access, or ask a lead or board member to update the inventory for you. |
||
| − | ==== Bay Ends(Obsolete) ==== |
||
| − | {| border="1" |
||
| − | |- |
||
| − | | '''Description''' || '''Needed''' || '''Spares''' || '''On hand''' |
||
| − | |- |
||
| − | | Silver Tarps 20 * 30 || 3 || 0 || 3 |
||
| − | |- |
||
| − | | 10 foot sections 1" PVC || 36 || 0 || 36 |
||
| − | |- |
||
| − | | Rope for troughs in ends || 150 feet || 50 || 200 feet |
||
| − | |- |
||
| − | | Rope for top edge || 50 feet || | 50 feet |
||
| − | |- |
||
| − | | Rebar for hinges || 18 || 0 || 18 |
||
| − | |- |
||
| − | | Rebar stakes for trough rope hooks and washers || 6 || 0 || 6 |
||
| − | |} |
||
| + | There's an app script attached to that sheet that gives us a simple web page for each item. That's handy as with a URL we can create short links and QR Codes. The app script basically just enumerates the column values and links up the URLs in there. |
||
| − | ==== Carpets, (this is out of date but there are a few in the container) ==== |
||
| − | {| border="1" |
||
| − | |- |
||
| − | | '''Description''' || '''Length''' || '''Width''' |
||
| − | |- |
||
| − | | Brown with trim || 12 || 9 |
||
| − | |- |
||
| − | | Brown with trim || 9.9 || 7.9 |
||
| − | |- |
||
| − | | Wavy biege || 13.2 || 3.5 |
||
| − | |- |
||
| − | | Still more to come... || | |
||
| − | |} |
||
| + | ==The schema: what each column means== |
||
| − | === Kitchen (Suggestions only, we have only a few misc items) === |
||
| − | * Stoves |
||
| − | * Three propane tanks |
||
| − | * Metal cupboards? |
||
| − | * Tables |
||
| − | * Food |
||
| − | * Pots Pans, Utensils |
||
| − | * Paper plates |
||
| − | * Basket plate stiffeners |
||
| − | * Cooler |
||
| − | * Wash tubs |
||
| − | ** Dish soap |
||
| − | ** Scrubbers |
||
| − | === Recycling === |
||
| − | * Garbage bags |
||
| − | * Garbage can |
||
| − | * Compost bags / burlap |
||
| − | * Cheese cloth |
||
| + | ===ID=== |
||
| − | Water |
||
| + | is the unique identifier. We use the ID in the URLs that get bookmarked, QR Coded etc. IDs need to be stable and shouldn't be changed once an item is entered into the inventory. |
||
| − | * Lots of 5 Gal containers, collapsible is good |
||
| − | === Network === |
||
| − | * |
||
| − | * 802.11 Gear |
||
| − | * |
||
| − | ** Two Clif Systems boxes |
||
| − | *** 64MB CF Cards |
||
| − | *** OpenWRT images |
||
| − | *** 4 U-Bolts |
||
| − | *** DC PoEs, only one has a long wire. |
||
| − | *** 1 ADCs with cables |
||
| − | *** Serial cable |
||
| − | ** Two Pelican case SBCs with bateries |
||
| − | *** 96MB CF Cards |
||
| − | ** 6 generic omnis with mounts<br /> |
||
| − | *** 6 small hose clamps |
||
| − | *** two omni mounts |
||
| − | ** 3 yagis with mounts |
||
| − | ** 1 Long N MM coax cables |
||
| − | ** 5 short N MM coax cables |
||
| − | ** 3+ 48V AC PoEs |
||
| − | ** 3 24V AC PoEs |
||
| − | ** 12V Wall bugs |
||
| − | ** 1 Amps + DC injector |
||
| − | ** 802.11 PCMCIA cards |
||
| − | ** Pigails |
||
| − | ** M-TO-M barrel couplers |
||
| − | ** 4 F-TO-F barrel couplers |
||
| − | ** 2 802.11b PCI cards |
||
| − | ** R-TNC Rubber duckies |
||
| − | ** 4 802.11a Mini PCI cards |
||
| − | ** PCI to Mini-PCI adapter |
||
| − | ** Pico Stations. |
||
| − | *** High gain rubber duckies |
||
| − | ** NanoStations |
||
| − | ** Repeter gear |
||
| − | *** 8 Standoffs with hose clamps |
||
| − | *** Tripod Mounts, in container |
||
| − | *** pipes in container |
||
| − | *** Small pipe clamps |
||
| − | *** Wall mount |
||
| − | *** Vent pipe mount |
||
| − | *** spare U bolts |
||
| − | *** Nano Bridges and switches |
||
| − | * VoIP Gear |
||
| − | ** ATA |
||
| − | *** POTS phone |
||
| − | ** Cisco telephone |
||
| − | ** telephone cords? |
||
| − | * 4 Euro Cords |
||
| − | * Hubs (2) with power. |
||
| − | * 10BT cable |
||
| − | ** 3 soft-to-touch light-blue ethernet patch cables (you know, the nice ones) |
||
| − | ** 8 ethernet patch cables in assorted colors and various lengths |
||
| − | ** 4 red or orange cross-over ethernet cables |
||
| − | ** 2 long pre-crimped ethernet cables |
||
| − | ** 700 ft cat5e |
||
| − | * Net4800 |
||
| − | * WiSpy with external antenna |
||
| − | * Laptop |
||
| − | ** Spare batteries |
||
| − | ** Headset |
||
| − | ** Audio cable |
||
| − | ** Blank CDs with sleves |
||
| − | ** CF card reader |
||
| − | ** RJ-45 Cross over connector(s) |
||
| − | ** Serial cables and adapters |
||
| − | ** Garmin Serial cable |
||
| − | * Small Laptop |
||
| − | ** Linux install |
||
| − | ** USB Serial dongle |
||
| − | * Misc |
||
| − | ** 10 10BT FF connectors |
||
| − | ** 2 MM 10BT Ys, puts two cables on one. |
||
| − | ** FRS Radios |
||
| − | *** Bateries |
||
| − | ** Locks, cables, and keys |
||
| − | * Video |
||
| − | ** Camcorders |
||
| − | === Tools === |
||
| − | * Tool bags / day packs |
||
| − | * Clipboard |
||
| − | * Dewalt |
||
| − | ** Drill bits |
||
| − | * Tape mesures (2) |
||
| − | * Drywall screws |
||
| − | * Two stake hammers |
||
| − | * Wooden mallet |
||
| − | * Vice grips |
||
| − | * Adjustable wrenches |
||
| − | * Pry Bar |
||
| − | * Bailing wire |
||
| − | * Big chisel |
||
| − | * Wire brush |
||
| − | * Scraper |
||
| − | * Hand saw |
||
| − | * Hack saw |
||
| − | * Shovel |
||
| − | * OCF Super rebar puller |
||
| − | * Rake |
||
| − | * Posthole digger |
||
| − | * Ladder(s) |
||
| − | * Climbing belt |
||
| − | ** Ropes |
||
| − | ** Carabiners |
||
| − | * Gloves |
||
| − | === Supplies === |
||
| − | * Several roles of duct tape |
||
| − | * Polly tape! |
||
| − | * Plumbers tape |
||
| − | * Super Glue and JB weld |
||
| − | * 50 RJ45s |
||
| − | * Electical tape |
||
| − | * Rubber tape |
||
| − | * DC cable parts. |
||
| − | * AA bateries |
||
| − | * AAA bateries |
||
| − | * Nine volt Batteries |
||
| − | * Nine inch nails for Geotek |
||
| − | === Electronic tools === |
||
| − | * Tool box |
||
| − | * 2 tool day packs |
||
| − | * Meter |
||
| − | * GPS |
||
| − | * Jumpers |
||
| − | * Soldering gun |
||
| − | * Soldering iron |
||
| − | * UT-50 |
||
| − | * Soder |
||
| − | * Desodering tool |
||
| − | * Combo screwdriver |
||
| − | * Security bits and driver |
||
| − | * Small screwdrivers |
||
| − | * Needle nose plyers |
||
| − | * Side cutters |
||
| − | * Small vise grips |
||
| − | * Wire striper / crimper |
||
| − | * RJ45 Crimper |
||
| − | * RJ45 Tester |
||
| − | ** Check bateries |
||
| − | * Small Crescent wrench |
||
| − | * Exacto knife |
||
| − | * Dental pics |
||
| − | * Hemastat |
||
| − | * Safety glasses |
||
| − | * Battery chargers |
||
| − | === Communications === |
||
| − | * Yeasu Handheld |
||
| − | ** Spare Batteries |
||
| − | ** Charger |
||
| − | === Power === |
||
| − | * Power distros with spare parts |
||
| − | * Power cords |
||
| − | * Power strips |
||
| − | * Baterie(s) |
||
| − | * Distilled water |
||
| − | === Airport === |
||
| − | * 2 Batteries |
||
| − | * Distilled water |
||
| − | * Charger (from power cart) |
||
| − | * Grounding wire + Clamp |
||
| − | * New spout |
||
| − | === Misc. === |
||
| − | * Spare tarps |
||
| − | * Lawn chairs 3 full size |
||
| − | * Extra bike |
||
| − | * Air mattress patch kit |
||
| − | * Moisturizer, lip balm |
||
| − | * Good duct tape! (Cheap, Medium, High Quality) |
||
| − | * Lanterns 2? |
||
| − | * Got Fire? |
||
| − | * Need lots of pillows!!! clean? |
||
| − | * Rope lights |
||
| − | * Xmas tree lights! |
||
| − | ** Dimmers |
||
| − | * Decorations |
||
| − | ** More poles for windsocks |
||
| − | * CF lights |
||
| − | * Mixer |
||
| − | * Cigarette lighter adapters |
||
| − | === Transportation === |
||
| − | ==== Clif's Truck ==== |
||
| − | * Chage Oil, top fluids |
||
| − | * New air filter and a spare under driver's seat |
||
| − | * Spare tire |
||
| − | * Jack and lug wrench |
||
| − | * Correct lugnuts |
||
| − | * AAA card |
||
| − | * Charged cellphones and 12V Charger(s) |
||
| − | * Emergency procedures |
||
| − | ==== Little trailer ==== |
||
| − | * Get new tires |
||
| − | * Check spare tire |
||
| − | * Check wheel bearings |
||
| − | * Lug wrench |
||
| − | * Check lights |
||
| − | * Blocks to support back so we can leave water barrows on trailer |
||
| − | * Six 50 gallon barrels |
||
| − | * Spare tire |
||
| − | * Lug wrench |
||
| − | * Rebar |
||
| − | * PVC |
||
| − | * Tables |
||
| − | * Rope |
||
| − | * More heavy stuff |
||
| − | === Trailer Notes === |
||
| + | ===Name=== |
||
| − | If you're going to use a trailer find out its max (GVWR) weight. Also how much it actually weighs, and its tong weight. What kind of hitch 2" ball, 2 5/16" Ball, Pintle hook or GI hitch, Goose neck, Fith wheel?, etc... Does it have electric breaks? are they 4 wire, 6 wire, or 7 wire? What is the GVWR, GAWR, GCWR of the pulling truck? |
||
| + | is a short product or descriptive name. Ideally this fits on a label & trips off the tonque. It doesn't need to be unique, but if it helps to disambiguate, you can add a number or something (e.g. Thing 1 and Thing 2) |
||
| − | === Bicycles === |
||
| − | * Mutant bikes? |
||
| − | * Cruisers? |
||
| − | * 1 Peach cart |
||
| − | * Bike locks |
||
| − | * Tools |
||
| − | ** Allen wrenches |
||
| − | ** Bike pump |
||
| − | ** 2 Extra inner tubes, 26 inches with shrader valve (at walmart for <$4) |
||
| − | ** Patch kit |
||
| − | ** Tire levers |
||
| − | === Other Notes === |
||
| − | ==== Manifest ==== |
||
| − | * Wifi Trunk |
||
| − | * Computer Misc |
||
| − | * NanoBridge Box |
||
| − | * BM Tools |
||
| − | * Climbing gear bag |
||
| − | * Mixer |
||
| − | * Spare Tarps |
||
| − | * Air matress, pump etc... |
||
| − | * 2 decoration bags |
||
| − | ** Poles |
||
| − | * CF lights. |
||
| − | * Structure stuff |
||
| − | * computer misc |
||
| − | * tent misc |
||
| − | * power cords |
||
| − | * power strips |
||
| − | * Lawn chairs 3 full size |
||
| − | * Spare Tent |
||
| − | * Clifs large camping bags |
||
| − | * Tools and supplies |
||
| − | * Kitchen gear. |
||
| − | * Plane oil |
||
| − | * Granola. |
||
| − | * Bathroom scale |
||
| + | ===Quantity=== |
||
| − | -- Main.ClifCox - 2011-08-14 |
||
| + | there was a thought that we might track consumables or groups of things as one inventory item. TBD. Everything is quantity 1 right now. |
||
| + | |||
| + | ===Status=== |
||
| + | One of a few states indicating if its available and usable or otherwise |
||
| + | |||
| + | ===Assigned to=== |
||
| + | Who to contact about a thing. Some things may for exclusive use by a member - like lockers or other storage area. Or if tool is under repair, it should be assigned to a single individual as point of contact. |
||
| + | |||
| + | ===Location=== |
||
| + | Where does it live? One of a list of locations at the space. |
||
| + | |||
| + | ===Details URL=== |
||
| + | Usually a link to a wiki page - its the first stop for more information on the thing. |
||
| + | |||
| + | ===Agreement URL=== |
||
| + | For donated or loaned tools and equipment, we try to save and link a copy of the agreement the owner signed to google drive and link it here. |
||
| + | |||
| + | ===Inventory URL=== |
||
| + | We use euglink.org to create shortened URLs from the long script.google.com/a/macros/eugenemaker... etc URLs that can be shared, referenced, QR-Coded, etc. Tracking that here helps keep a single short URL per inventory item. |
||
| + | |||
| + | ===Owner=== |
||
| + | Who owns the thing? Most of our equipment is owned by Eugene Makerspace. Some is on loan. |
||
| + | |||
| + | ===Notes=== |
||
| + | Short notes. Use the Details URL for more than a few words. |
||
| + | [[Category:EMSResources]] |
||
| + | [[Category:Member Handbook]] |
||
Latest revision as of 06:54, 16 February 2026
Overview
We have tools, resources and systems and we need to answer the same questions for each:
- What is it?
- Who does it belong to?
- Where is it (or where should it be?)
- Is it available or assigned/checked out by a particular person?
- Where do I find out more about the thing?
We currently track this stuff in a google sheet. When it grows up it wants to be a database.
How it works
The google sheet is owned by the `system@` eugenemakerspace.com account. If you don't have access to edit this already, you can request access, or ask a lead or board member to update the inventory for you.
There's an app script attached to that sheet that gives us a simple web page for each item. That's handy as with a URL we can create short links and QR Codes. The app script basically just enumerates the column values and links up the URLs in there.
The schema: what each column means
ID
is the unique identifier. We use the ID in the URLs that get bookmarked, QR Coded etc. IDs need to be stable and shouldn't be changed once an item is entered into the inventory.
Name
is a short product or descriptive name. Ideally this fits on a label & trips off the tonque. It doesn't need to be unique, but if it helps to disambiguate, you can add a number or something (e.g. Thing 1 and Thing 2)
Quantity
there was a thought that we might track consumables or groups of things as one inventory item. TBD. Everything is quantity 1 right now.
Status
One of a few states indicating if its available and usable or otherwise
Assigned to
Who to contact about a thing. Some things may for exclusive use by a member - like lockers or other storage area. Or if tool is under repair, it should be assigned to a single individual as point of contact.
Location
Where does it live? One of a list of locations at the space.
Details URL
Usually a link to a wiki page - its the first stop for more information on the thing.
Agreement URL
For donated or loaned tools and equipment, we try to save and link a copy of the agreement the owner signed to google drive and link it here.
Inventory URL
We use euglink.org to create shortened URLs from the long script.google.com/a/macros/eugenemaker... etc URLs that can be shared, referenced, QR-Coded, etc. Tracking that here helps keep a single short URL per inventory item.
Owner
Who owns the thing? Most of our equipment is owned by Eugene Makerspace. Some is on loan.
Notes
Short notes. Use the Details URL for more than a few words.