COPY For Sample - Out Of Stock Report - Other Facilities with Stock.xlsx

	A	B	C	D	E	F	G	H	I	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1										In the future I want to use a slicer to select the Facility and populate all the products with "0" and then all the facilities with positive "Qty O/H" will poulate with the total product available.	I want to duplicate this report but change the "Qty O/H" with the "MTH Avg Usage". I want to select a facility and then a list of all products that have a "Qty O/H <0" but a "=>0 Mth Avg Usage" and then under the facilities their Mth Avg Usage would populate. This will help us ship "deadstock" to a facility that has demand.
2	Facility	ProductNumber	Product Description	Storeroom Location	Qty O/H	RO	Max	UOI	MTH Avg Usage	`=FILTER($B$2:$B$18132,$E$2:$E$18132>0)	FILTER Formula	Product Number With Qty of Zero	GRR10	HFG10	RAE10	RCO10	REB10	REB20	RFL10	RHE10	RJB10	RJB20	RJH10	RJH20	RJR10	RJR20	RJR30	RMD10	RMD20	RMD30	RMG10	RNR10	RVG10
3	GRR10	20003205	CANSTR SUCT 2000ML 90D LOCK LI	STR01_J_03_C	17	10	40	EA	6.75		#NAME?	20014219	0															43
4	GRR10	20005015	TAPE SURG 10YDX2IN TRNSPR PLAS	STR01_C_03_A	6	6	12	EA	1			20028009	0
5	GRR10	20005019	ELCTROD DEFIB RED 5.95X5.24IN	STR01_D_01_C	7	3	6	EA	2.33			20037856	0	3
6	GRR10	20005306	SOL ANTISEP 3% HYDROGEN PEROXI	STR01_A_02_F	27	5	24	EA	5.58			20049760	0																				158
7	GRR10	20005627	NEEDLE FILTR 1.5IN 18GA BLUNT	STR01_G_01_A	100	0	100	EA	16.66			20049777	0		8										10
8	GRR10	20005767	AIRWAY 12FR 60MM PVC NASOPH BV	STR01_F_02_B	4	0	1	EA	0			20049800	0			3	17		8		16		8		91						9		39
9	GRR10	20005768	AIRWAY 14FR 72MM PVC NASOPH BV	STR01_F_02_B	7	0	1	EA	0			20053330	0		24										59
10	GRR10	20006705	PACKING WND 5YDX.25IN IODO COT	STR01_C_01_C	2	1	2	EA	0			20077279	0		43
11	GRR10	20007159	WRAP COMPR 5YDX1IN COBAN FBR P	STR01_C_04_B	52	60	90	EA	147			20082406	0			7
12	GRR10	20008396	SOL PREP HIBI 4% CHG 4OZ ANTIM	STR01_K_02_E	32	8	48	EA	12.58			20086419	0
13	GRR10	20008515	TUBE ET 8MM NASAL ORAL CUFF MU	STR01_F_01_A	2	3	10	EA	0.58			20088655	0		3		9				9		7		12
14	GRR10	20009572	BATTERY ALK 1.5V D ZINC-MNGN D	STR01_A_01_C	4	12	24	EA	11.41			20008490		0	6		21				4		6		26							11	11
15	GRR10	20009590	BATTERY ALK 1.5V C ZINC MNGN D	STR01_A_01_C	7	4	12	EA	0.25			20012746		0																35
16	GRR10	20010934	BARRIER SKIN HYPOALL TRNSP ALC	STR01_C_02_C	60	30	60	EA	17.5			20027303		0	3
17	GRR10	20011279	SYRINGE SFGLD .5IN 27GA 1ML LT	STR01_G_02_B	35	20	100	EA	20.41			20030583		0								30			14
18	GRR10	20011342	HOLDER LIMB 13X3IN THK3/8IN UN	STR01_B_02_E	29	4	8	PR	1			20037710		0				13				12
19	GRR10	20011383	BAG DRAIN 19OZ BARD FLP DABG M	STR01_F_02_D	5	2	5	EA	1.08			20037772		0								17
20	GRR10	20011499	TAPE SURG 10YDX2IN 3M DURPO CL	STR01_C_02_A	18	12	18	EA	1.5			20045614		0								34
21	GRR10	20011679	CUFF BLOOD PRESS CRTKN SOFCUF	STR01_E_03_D	30	20	40	EA	31.33			20048864		0								14
22	GRR10	20011680	CUFF BLOOD PRESS CRTKN SOFCUF	STR01_E_04_D	80	80	100	EA	63.83			20053601		0	38										48						103
23	GRR10	20011681	CUFF BLOOD PRESS CRTKN SOFCUF	STR01_E_04_D	82	80	100	EA	206.91			20058447		0	130		400				431		100		775			70					343
24	GRR10	20012225	WRAP PROTECT EZ WRAP EAR FOAM	STR01_J_02_B	46	10	20	EA	0			20069757		0							32		18
25	GRR10	20013131	PAN 900ML PLAS URN STOOL GRAD	STR01_D_04_C	19	36	100	EA	83.16			20083451	270	0							0		94		883			318			50	350	248
26	GRR10	20013188	CATH URETH BARDX LBTCATH 24FR	STR01_F_04_B	2	1	4	EA	0.16			20084756	54	0							87
27	GRR10	20013209	BAG DRAIN 2000ML BARD RND TRDR	STR01_F_02_D	15	5	20	EA	1.25			20011619			0	14									184						12	6	0
28	GRR10	20013223	DETRG INST 22OZ TRNSPT GEL RNS	STR01_K_02_E	4	1	4	EA	0			20012412			0
29	GRR10	20013263	PITCHER BEDSD GRAD 3ANG PLAS C	STR01_D_02_D	123	20	50	EA	16.25			20016819			0		193		95		76				349			78			65	71	88
30	GRR10	20013264	NEEDLE HYPO 21GA 1.5IN THNWL S	STR01_G_01_B	350	50	150	EA	33.33			20051064			0
31	GRR10	20013385	TAPE SURG 10YDX3IN 3M TRNSPR H	STR01_C_03_A	12	8	12	EA	0			20051362			0	2			1				12					16			7	3	9
32	GRR10	20013479	DEPRES 6IN STER BLDE SMTH SPLI	STR01_A_02_B	400	200	1000	EA	125			20065960			0
33	GRR10	20013758	SPLINT ORTHO 15FTX2IN ROLL FBR	STR01_J_04_C	1	0	1	EA	0.25			20074672			0
34	GRR10	20014187	WIPE PREP 8X5.5IN 18% ISOP ALC	STR01_A_02_C	400	300	1000	EA	25			20079349	13		0	0	48				10		20								11	46	60
35	GRR10	20014194	TAPE SURG 10YDX3IN 3M DURPO HY	STR01_C_02_A	12	8	12	EA	0.33			20083391			0		325								373
36	GRR10	20014196	TAPE SURG 10YDX2IN MDPR CLTH S	STR01_B_02_D	8	4	12	EA	0.16			20010735				0																2
37	GRR10	20014197	SWBSTK PREP 10% PVP IOD 1 SATU	STR01_A_02_C	125	27	250	EA	18.75			20011539		9	32	0			22		10							14			34	40	50
38	GRR10	20014198	SOL ANTISEP 70% ISOP ALC BOTL	STR01_K_02_E	3	1	3	EA	0.33			20013264	350			0			165		75		700										20
39	GRR10	20014219	DRSG ALG 4X4IN ACTCT POLYETH N	STR01_K_01_F	0	1	10	EA	1			20013410				0															4		3
40	GRR10	20014223	TUBE ET 8.5MM NASAL ORAL CUFF	STR01_F_01_A	3	1	3	EA	0.91			20013715				0																5
41	GRR10	20014291	BANDAGE MTRX 5YDX3IN NONSTRL B	STR01_C_03_B	7	10	20	EA	7.75			20015672				0															2	1	3
42	GRR10	20014292	BANDAGE MTRX 5YDX4IN NONSTRL B	STR01_C_03_B	14	10	20	EA	12.83			20034244				0															151		314
43	GRR10	20014316	MASK TRACH ADLT AERO SWVL ADAP	STR01_J_01_D	3	0	1	EA	0			20039311				0															1182	0	1790
44	GRR10	20014427	ROLL ON SKIN MEDSPA ANTIPRS RO	STR01_E_01_C	54	10	96	EA	22.5			20043171				0	995						250									32
45	GRR10	20014455	NEEDLE HYPO 25GA 1IN REG WALL	STR01_G_02_B	150	100	200	EA	20.83			20046004	2125	247	7225	0	1922		515		0		275		5294			2139			0	510	310
46	GRR10	20014650	SWAB ORAL 4IN GUM GO-BETWEENS	STR01_A_02_C	42	25	50	EA	1.91			20048087				0															4
47	GRR10	20014660	SET ENEMA 54IN VNYL SLIDE CLAM	STR01_D_03_A	27	15	50	EA	1.75			20048916				0									22
48	GRR10	20014983	DRSG TRNSP 4.75X4IN POLYURE AD	STR01_C_03_C	108	50	100	EA	14.75			20063422			1	0
49	GRR10	20015419	NEEDLE HYPO 21GA 1IN MONJCT MG	STR01_G_01_B	100	100	150	EA	20.83			20066203				0															132	32	300
50	GRR10	20015692	BANDAGE MTRX 5YDX2IN NONSTRL B	STR01_C_03_B	20	10	20	EA	6.66			20069259				0																2	87
51	GRR10	20015708	POUCH TELE WHT 7.5X6IN 2.5IN S	STR01_D_02_C	59	1	8	EA	1.25			20069722				0									534			89			56	28	198
52	GRR10	20016203	TOOTHBRSH ORAL WHT 30 TUFT ADL	STR01_E_01_B	108	24	144	EA	27.66			20069762				0									12						41		29
53	GRR10	20016258	DRSG TRNSP 2.75INX2 3/8IN POLY	STR01_C_03_C	306	100	400	EA	183.25			20070529				0																155
54	GRR10	20016306	TUBE ET 7.5MM NASAL ORAL CUFF	STR01_F_01_A	10	1	3	EA	1.16			20073636				0															72		47
55	GRR10	20016309	NEEDLE HYPO 27GA 1.5IN DISP	STR01_G_03_D	150	1	100	EA	4.16			20079349	13		0	0	48				10		20								11	46	60
56	GRR10	20017472	SET BLOOD ADMIN 180UM 15 GTT 1	STR01_N_03_C	42	20	40	EA	0.33			20082284				0
57	GRR10	20017690	GARMENT COMPR STD UNIV CALF FL	STR01_L_02_D	3	2	5	EA	0.25			20082295				0
58	GRR10	20018383	BANDAGE GAUZE 4.1YDX4.5IN BLK2	STR01_C_03_D	73	10	100	EA	23			20093302				0	400														800		200
59	GRR10	20018395	APPL COTN WOOD 6IN SWBSTK STER	STR01_A_02_B	700	100	1000	EA	116.66			20020790					0
60	GRR10	20019210	PAD ABDMNL 10X8IN DISECT ABSOR	STR01_C_04_C	126	50	144	EA	14			20031794					0
61	GRR10	20020623	STRIP 5YDX1IN COTN IODO WND CU	STR01_C_02_C	2	1	3	EA	0			20041881					0				48												44
62	GRR10	20020624	STRIP 5YDX.5IN IODO COTN GAUZE	STR01_C_02_C	2	1	3	EA	0.16			20074509					0
63	GRR10	20021263	BANDAGE GAUZE 75X4IN SFFRM POL	STR01_C_04_D	23	12	24	EA	6.16			20074675					0															0	0
64	GRR10	20021271	BANDAGE GAUZE 75X2IN SFFRM RAY	STR01_C_04_D	24	12	36	EA	12.41			20083489					0
65	GRR10	20021273	PAD DRSG 4X3IN CURAD POLY COTN	STR01_K_03_C	100	25	100	EA	15.5			20011603						0				13											62
66	GRR10	20021438	PAPER COPY 8.5X11IN 20LB WHITE	STR01_H_01_A	72	30	80	RM	87.41			20013098						0
67	GRR10	20021572	MASK ANES RED 22MM CL CMFRT LG	STR01_J_02_A	16	5	30	EA	0.41			20017529			26			0							92				248
68	GRR10	20021836	BAG ICE 9.5IN STDR LG TIE CLOS	STR01_E_04_C	29	25	50	EA	16.41			20020424		7				0			21							7
69	GRR10	20021854	BAG PT BLUE CLR 20X20X3IN PLAS	STR01_B_02_E	400	50	500	EA	87.5			20022566						0								2
70	GRR10	20022693	STRIP 5YDX.25IN COTN GAUZE WND	STR01_C_01_C	2	1	2	EA	0			20030652						0				16											63
71	GRR10	20022694	PACKING WND 5YDX.5IN COTN CURA	STR01_C_02_C	2	1	12	EA	0			20040962						0
72	GRR10	20022995	SPONGE GAUZE 4X4IN AVANT GAUZ	STR01_C_04_C	58	10	50	EA	1			20066032						0				15			15
73	GRR10	20023008	SPONGE SURG 4X4IN 16 PLY XRAY	STR01_L_02_F	5	4	8	PK	0			20068757						0
74	GRR10	20023106	PAD EYE 2 5/8INX1 5/8IN OVL CU	STR01_B_01_D	28	20	50	EA	0.83			20070394						0
75	GRR10	20025248	SET EXT 2.1ML 60IN IV M LL ADA	STR01_N_03_B	18	5	20	EA	0.16			20085247						0
76	GRR10	20026400	CANNULA NASAL 7FT O2 TUBE ELAS	STR01_J_01_D	27	25	50	EA	1.41			20087242						0
77	GRR10	20026533	SPLINT ORTHO 15FTX4IN ROLL FBR	STR01_J_04_C	1	0	1	EA	0.25			20088509						0
78	GRR10	20026539	TUBE ET 6MM NASAL ORAL CUFF MU	STR01_F_01_A	7	3	10	EA	0.08			20093491						0							3
79	GRR10	20026544	SYRINGE MONJCT 35ML LTXFR STER	STR01_G_03_D	5	1	30	EA	2.08			20005245		4	178	48			0		14		37		1038			88			354	175	219
80	GRR10	20026656	JELLY LUB H2O SOL NONGRS TRNSL	STR01_D_03_B	278	144	288	EA	70.16			20013210			15				0						18							17
81	GRR10	20026657	PAD ADHES TXTR LTXFR ALC	STR01_C_02_C	200	100	400	EA	16.66			20018347							0
82	GRR10	20026662	BANDAGE 4X2IN CURAD PLAS ADHES	STR01_A_02_D	200	50	200	EA	25			20022961							0
83	GRR10	20027050	BAG RESP STUP 15X12IN DRWSTRG	STR01_J_03_B	296	100	500	EA	20.75			20033162	34				62		0									96
84	GRR10	20027051	CNTNR DNTR CLR PLAS IMPRT LID	HOUSE_A_01_A	150	75	250	EA	12.66			20033412							0						484
85	GRR10	20027052	PAD ABDMNL 9X5IN DISECT ABSORB	STR01_C_04_C	19	0	1	EA	3.33			20039310							0
86	GRR10	20027305	STRIP 4X.5IN STRSTRP POLY REIN	STR01_A_02_D	31	2	50	PK	2.16			20055758	91	110	278		284		0		393		138		1083			389			245	250	193
87	GRR10	20027307	STRIP 3X1/8IN STRSTRP POLY REI	STR01_A_02_D	58	10	50	PK	3			20062036							0
88	GRR10	20027361	CATH DRAIN 20FR 15.75IN ARG SE	STR01_F_02_A	1	0	1	EA	0.16			20069758							0						22			26				0
89	GRR10	20027381	NEEDLE HYPO 23GA 1IN REG WALL	STR01_G_01_B	200	150	200	EA	83.33			20075734			64				0		0											80
90	GRR10	20027404	TAPE SURG 10YDX2IN STD MICROPR	STR01_C_02_A	14	6	6	EA	0			20084899			36		312		0						271
91	GRR10	20027405	TAPE SURG 10YDX1IN STD MICROPR	STR01_C_02_A	24	24	36	EA	14.33			20085241			34		64		0						127							35
92	GRR10	20027406	TAPE SURG 10YDX1IN 3M TRNSPR H	STR01_C_03_A	36	24	36	EA	23			20004728									0
93	GRR10	20027407	TAPE SURG 10YDX.5IN 3M TRNSPR	STR01_C_03_A	48	48	72	EA	11.16			20004733									0	64											72
94	GRR10	20027798	KIT DRAIN 6.44IN 8FR 22GA PNMT	STR01_F_02_C	2	1	5	EA	0			20004769									0							11
95	GRR10	20028009	CHAMBER HMDF ARCHB+ Z STAT FLW	STR01_J_02_E	0	4	12	EA	7.33			20010764									0
96	GRR10	20028996	SYRINGE THNWL .5IN 29GA 1ML IN	STR01_G_02_B	100	100	200	EA	108.33			20012736		17	59	15					0		63		146			65					27
97	GRR10	20029000	CATH IV 22GA .75IN RADOPQ NDL	STR01_G_02_B	25	5	25	EA	6.25			20013460									0
98	GRR10	20029071	BANDAGE GAUZE 75X3IN SFFRM RAY	STR01_C_04_D	19	12	24	EA	7.5			20014063									0
99	GRR10	20030124	CNTNR POLYPRO 4OZ LEAK RESIST	STR01_D_02_D	105	50	100	EA	208.75			20020624	2	14	6	4	2				0		14		22			17			17	11	11
100	GRR10	20030218	TRAY SKIN SCRUB STD VNYL COTN	STR01_L_03_D	3	1	3	EA	0.08			20030126					118				0