Spreadsheet: 472244d1469511159-formula-vlookup-to-calculate-running-total-of-master-inventory-sheet-final-inventory-2
Sheet: Master Inventory-All Items

ITEM |  |  | Physical Inventory
Type | ITEM NAME | [NAME] | Number Per Box | Number of Boxes | Loose | Issued | Total | Notes
Promo | Air Freshner, Car | Scent: Citrus Blossom | 50 | 1
Promo | Air Pressure Gauge | Red | 50 | 1
Promo | Bag | Green, Black, Mesh | 200 | 1
Promo | Bag | Red, Black, Mesh | 25 | 1
Promo | Bag | Green, Black | 200 | 1
Promo | Bag | Red, White, Blue | 100 | 1
Promo | Bag, Drawstring | Orange, Grey | 200 | 11
Promo | Bag, Drawstring | Red | 300 | 5
Promo | Bag, Drawstring-Earth Day | Bright Green | 300 | 1 |  |  |  | Earth Day
Promo | Bag, Drawstring-EV | Orange, Grey | 200 | 4 |  |  |  | EV
Promo | Bag, Grocery | Grey | 100 | 1 |  |  |  | Rebates
Promo | Bag, Grocery | Black | 100 | 12
Promo | Bag, Grocery-Insulated | Red | 25 | 12 |  |  |  | Rebates
Promo | Bag, Grocery-Insulated | Lime | 25 | 4 |  |  |  | LED
Promo | Bag, Grocery-Insulated | Black | 25 | 10 |  |  |  | Home Performance
Promo | Bag, Gromets | Green, Black | 200 | 6
Promo | Bag, Insulated | Grey | 30 | 1
Promo | Bag, [NAME] | Green, White, Black | 200 | 7
Promo | Bag, [NAME] | Orange, Black | 200 | 3
Promo | Bag, [NAME] | Red, Black, Grey | 100 | 1
Promo | Bag, Paper/Gift | Orange | 150 | 1
Promo | Bag, Soccer | Black, White | 125 | 1
Promo | Bag, Woven | Khaki | 50 | 1
Promo | Ball, Beach | Multi | 200 | 2
Promo | Ball, Beach | Orange, Silver | 0 | 0
Promo | [NAME], Collapasable | Red, White | 40 | 1
Promo | Beads | Orange | 150 | 3
Promo | Bottle, Foil, Pop Up Top | Silver | 50 | 1
Promo | Bottle, Little | Light Green | 80 | 11
Promo | Bottle, Plastic, [NAME] | Orange | 500 | 3
Promo | Bottle, Sports | Red | 130 | 20
Promo | Car Shade | Orange | 20 | 1
Promo | Chapstick | White | 150 | 1
Promo | Charger, Car | Blue | 60 | 1
Promo | Clapper, Hand | Purple, White | 200 | 2
Promo | Clip | Red, White | 300 | 2
Promo | Clip | Orange | 50 | 1
Promo | Coloring Book |  | 125 | 11
Promo | Coloring Book, Disney | Princess | 24 | 17
Promo | Coloring Book, Disney | Monsters, Inc. | 36 | 9
Promo | Cup Sleeve | Red | 500 | 1
Promo | Cup Sleeve | Black | 100 | 1
Promo | Cup, Metal | Orange | 15 | 1
Promo | Cup, Plastic with Straw | Clear | 15 | 2
Promo | Cup, Plastic with Straw | Orange | 24 | 3
Promo | Ear Plugs |  | 500 | 1
Promo | Fan, Battery, LED Message |  | 48 | 9
Promo | Fan/Mister, Deluxe | Red | 30 | 1
Promo | First Aid Kit | Orange, White | 250 | 7
Promo | Flashlight w/Batteries | Grey | 100 | 1
Promo | [NAME] |  | 25 | 1
Promo | iPad Holder | Black | 45 | 1
Promo | Keychain, Hard Hat with Light | White | 300 | 1
Promo | Keychain, LED Light | Silver, Black | 250 | 1
Promo | Light Stick, Foam | White | 15 | 1
Promo | Marker | Black, Yellow, Orange, Green, Purple, Red | 150 | 6
Promo | Nightlight, LED | White | 200 | 7
Promo | Notebook, Recycled |  | 100 | 1
Promo | Pen | Silver, Lime Green | 100 | 1
Promo | Pen | Orange, White | 50 | 1
Promo | Pen, Light Up | Red | 70 | 12
Promo | Pen, Light Up | Green | 70 | 5
Promo | Pen, Recycled | Wood | 55 | 1
Promo | Pen, Recycled | Orange | 500 | 1
Promo | Pen, [NAME] | Green | 1000 | 2
Promo | Pencils, Mood | Multi | 250 | 8
Promo | Ponchos
Promo | Portfolio, Leather | Black | 15 | 2
Promo | Power Bank | Black | 75 | 1
Promo | [NAME] | Green | 200 | 2
Promo | [NAME] | Red | 200 | 1
Promo | Stressball | Red | 200 | 2
Promo | Sunglasses | Green | 300 | 2
Promo | Sunglasses | Orange | 300 | 1
Promo | Sunglasses, [NAME] | Yellow | 300 | 1
Promo | Sunglasses, [NAME] | Red | 300 | 1
Promo | Sunglasses, [NAME] | Pink | 300 | 1
Promo | Sunglasses, [NAME] | Purple | 300 | 1
Promo | Sunscreen, Foil Packet | White | 40 | 1
Promo | Sunscreen, Tube w/Chain | White | 75 | 1
Promo | Thermometer, Solar | Green | 75 | 1
Promo | [NAME] | Black, Grey | 10 | 1
Promo | Vase, Flat | Orange | 500 | 1
Promo | Wallet | Black | 125 | 1
Promo | Wallet, [NAME] | Red | 12 | 28
Promo | Wet Wipes | White | 6 | 1
Displays
Displays | Tablecloth-Fitted | 6' |  |  | 4
Displays | Tablecloth-Skins | 6' |  |  | 2
Displays | Tablecloth-Fitted | 8' |  |  | 4
Displays | A Frame (White) |  |  |  | 25
Displays | Bamboo Tree | Potted |  |  | 4
Displays | Bench |  |  |  | 5
Displays | Bistro Table |  |  |  | 6
Displays | Blu-Ray Player |  |  |  | 1
Displays | Cart | green |  |  | 1
Displays | Chairs (Collapsable) | grey |  |  | 2
Displays | Collateral Boxes (Rolling) | Black |  |  | 6
Displays | Couch | Red |  |  | 2
Displays | Dolly | grey |  |  | 1
Displays | Easels |  |  |  | 10
Displays | Ice Chest (Large) |  |  |  | 1
Displays | Ice Chest (Small) |  |  |  | 2
Displays | Leather Chair |  |  |  | 8
Displays | Mirage | City Scape |  |  | 1 |  |  | 2 cases
Displays | Mirage | Lineman |  |  | 1
Displays | Mirage | Child |  |  | 1
Displays | Podium | Electricity |  |  | 1
Displays | Pop up banner | Solar |  |  | 1
Displays | Prize Wheel | Large |  |  | 1
Displays | Prize Wheel | Small |  |  | 1
Displays | Side Tables | Red, Yellow, Green |  |  | 10
Displays | Stool |  |  |  | 4
Displays | Table (Folding) | 6 ft |  |  | 4
Displays | Tent | 10x10 |  |  | 4
Displays
Displays | Trade Show Box |  |  |  | 6
Displays | TV |  |  |  | 1
Displays | Vacuum |  |  |  | 1
Displays | Xpressions | SEED |  |  | 1
Displays | Xpressions | ED |  |  | 1
Displays | Sign Holders-Stands |  |  |  | 4
Displays | Heaters-Propane |  |  |  | 4
Banners
[NAME] | 70th Anniversary | 8x3 |  |  | 4
[NAME] | Charge Free for a Year |  |  |  | 1
[NAME] | Children-Windmill | 8x3 |  |  | 2
[NAME] | Considering Solar |  |  |  | 1
[NAME] | Earth Day | 8x3 |  |  | 13
[NAME] | Father-Daughter | 8x3 |  |  | 3 |  |  | 1 is double sided
[NAME] | Greenergy-Child-Windmill | 8x3 |  |  | 1
[NAME] | MLK | 8x3 |  |  | 1
[NAME] | Pop Up-Solar | 8x3 |  |  | 4
[NAME] | Power Lines | 8x3 |  |  | 1
[NAME] | Western Festival | 8x3 |  |  | 4
[NAME] | Power Savings-Baby, Dryer | 8x3 |  |  | 1
[NAME] | March for Babies | 8x3 |  |  | 3
[NAME] | [NAME] | 8x3 |  |  | 2
[NAME] | Solar Smart Home | 8x3 |  |  | 1
[NAME] | Let's Power Our Community-Baseball | 8x3 |  |  | 2
[NAME] | Wind Turbines | 8x3 |  |  | 1
[NAME] | Save Energy-Spanish | 8x3 |  |  | 1 |  |  | Double-Sided
[NAME] | Earth Day 2015 | 8x3 |  |  | 2 |  |  | 2015
[NAME] | LED | 8x3 |  |  | 1
[NAME] | Community Solar | 8x3 |  |  | 1
Collateral
Collateral | 2015 Customer Solutions Energy Efficiency Incentive Programs
Collateral | Appliance Calculation Fact Sheet
Collateral | Application for Energy Assistance Program Rate (EAPR) |  | 1000 | 1
Collateral | Application for Energy Assistance Program Rate (EAPR) (Spanish)
Collateral | Build a Solar CooKit
Collateral | Building a Smarter Energy Future
Collateral | Can You Dig It?
Collateral | Category List for EBSS |  | 500 | 1
Collateral | Commercial Greenergy
Collateral | Community Solar
Collateral | Complete Energy Solutions (CES) Energy Efficient Solutions for Your Business
Collateral | Custom Due Date
Collateral | Custom Energy Efficiency Incentives (CEEI) Air Conditioning and Refrigeration, Lighting and Controls, Motors and Process Imporvement Equipment and More
Collateral | Custom Energy Efficiency Incentives (CEEI) Pump Energy Assessment Program
Collateral | Energy Help |  | 1200 | 2
Collateral | Energy Saving Tips (EST) Lighting, Office Equipment, HVAC Systems, Motors, Refrigeration, Food Service Equipment, Weatherization
Collateral | Energy Solutions for Property Managers (ESPR) Energy Efficiency Solutions for Leased Properties and Tenant Improvements
Collateral | Express Energy Solutions (EES) Energy Efficiency Solutions for Your Business
Collateral | Get a FREE Energy-Efficient Refrigerator
Collateral | Getting to Know SMUD |  | 1400 | 3
Collateral | Greenergy |  | 600 | 1
Collateral | Greenergy (Spanish)
Collateral | Greenergy Partner Program (GPP) Renewable Energy Solutions for Your Business
Collateral | Grow Sacramento Fund (Pamphlet)
Collateral | Grow Sacramento Fund (Sheet)
Collateral | Grow Your Business with SEED
Collateral | Heat Pump Water Heater Replacement Incentive |  | 1000 | 1
Collateral | Heating Season Tips to Keep You Warm in the Winter |  | 500 | 1
Collateral | Help Shape the Future of SMUD and Have a Chance to Win Great Prizes Every Month
Collateral | Helping You Feel at Home |  | 500 | 3
Collateral | High-Efficiency Air Conditioning Program
Collateral | Home Performance Program
Collateral | Home Rebates & Energy Solutions Guide
Collateral | HomePower
Collateral | Hydropower
Collateral | Is Solar Right for You?
Collateral | Keep Your Home Warm, Cozy, and Safe (English)
Collateral | Keep Your Home Warm, Cozy, and [NAME] (Spanish)
Collateral | Keep Your Home Warm, Cozy, and Safe (language)
Collateral | Keep Your Home Warm, Cozy, and Safe (language)
Collateral | Keep Your Home Warm, Cozy, and Safe (language)
Collateral | Keep Your Home Warm, Cozy, and Safe (language)
Collateral | Keep Your Home Warm, Cozy, and Safe (language)
Collateral | Keep Your Home Warm, Cozy, and Safe (language)
Collateral | Let Us Weatherize Your Home |  | 500 | 1
Collateral | Let's Power Our Community |  | 500 | 1
Collateral | Let's Power Summer Savings
Collateral | Let's Power Your Home's Performance |  | 500 | 1
Collateral | Lighting the Way Ahead |  | 500 | 1
Collateral | Make Your Next Home a SolarSmart Home
Collateral | Manage Your SMUD Account at smud.org
Collateral | Medical Equipment Discount (MED) Rate
Collateral | Medical Equipment Discount (MED) Rate (Spanish)
Collateral | Money-Saving Programs That Really Add Up |  | 600 | 2
Collateral | Moving Connections
Collateral | Plug in and Save with SMUD
Collateral | Powering Futures Scholarship
Collateral | Proposition 39  SMUD Support Services
Collateral | Rebates on Variable-Speed Pool Pumps
Collateral | Residential ENERGY STAR Lighting Program
Collateral | Residential Loan Program and Eligibility
Collateral | Sacramento Shade
Collateral | Sacramento Shade (Spanish)
Collateral | Savings by Design 2015
Collateral | SMUD Business Resource Guide |  | 175 | 4
Collateral | SMUD's Supply Chain Contacts
Collateral | [NAME] Guide
Collateral | SolarShares
Collateral | Start or Expand your Business in Sacramento
Collateral | [NAME] with Business Connections
Collateral | Swim and Save All Summer Long
Collateral | Teaching Through Solar Exhibit
Collateral | Team With SMUD and Save
Collateral | The Distribution System and the Smart Grid
Collateral | Tips for Successful Proposals
Collateral | To Register on SMUD's Electronic Bidding Solicitation System
Collateral | Tree Planting Guide |  | 500 | 1
Collateral | Voluntary Emergency Curtailment Program (VECP) Non-Essential Load Reduction by Local Businesses During Periods of High Demand
Collateral | Want to Do Business with SMUD?
Collateral | Ways to Keep Cool |  | 500 | 1
Collateral | Winter Storm Tips For Your Home
Collateral | Working for You