Attempting to auto generate ID names based on uncertain parameters

[avc0002]

hello everyone hope all is well,

Background:
I need to create unique IDs for inspection locations based on known parameters
The amount created is different on every project but the naming convention is the same for all.

I want to be able to input the number of buildings and then automatically generate a complete list of everything needed to inspect. I assume its some sort of array formula. I guess I'll let you that know more tell me haha.


Naming Convention:
I only need to add info where the # is.

Stairs:
S - B# - S#
Stair - Building # - Stair #

Landings:
L - B# - F# - S#
Landing - Building # - Floor # - Stair #

Walkways:
W - B# - F# - W#
Walkway - Building # - Floor # - Walkway #


Yellow cells are the only cells where I'll be inputting information.
Green cells are where the output would go. (I could only copy a sample in the mini sheet but it would extend further down for as many as needed)

I'd like to input the number of buildings and the amount of stairs, landings, and walkways and all of the names be created automatically.


Hopefully this makes sense. If it doesn't I'll do my best to clarify.

82278 - Chino Hills - DB.xlsx
	B	C	D				H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
3											Stairs		52		Landings		148		Walkways		66
4	Building #	Type					Bldg. Type	Qty.	Description		Bldg. Type	Amount	Total		Bldg. Type	Amount	Total		Bldg. Type	Amount	Total
5	A-01	1					1	13			1	2	26		1	6	78		1	2	26
6	A-02	1					2	4			2	1	4		2	1	4		2	0	0
7	A-03	1					3	1			3	2	2		3	6	6		3	0	0
8	A-04	1					4	2			4	4	8		4	12	24		4	8	16
9	A-05	1					5	3			5	4	12		5	12	36		5	8	24
10	A-06	1
11	A-07	2
12	A-08	1
13	A-09	2
14	A-10	1
15	A-11	1
16	A-12	1
17	A-13	1
18	A-14	1
19	A-15	2
20	A-16	1
21	A-17	2
22	B-01	3
23	B-02	4
24	B-03	4
25	B-04	5
26	B-05	5									S - B# - S#				L - B# - F# - S#				W - B# - F# - W#
27	B-06	5
28											S - BA-01 - S1				L - BA-01 - F2 - S1				W - BA-01 - F2 - W1
29											S - BA-01 - S2				L - BA-01 - F2 - S2				W - BA-01 - F3 - W1
30											S - BA-02 - S1				L - BA-01 - F2.5 - S1				W - BA-02 - F2 - W1
31											S - BA-02 - S2				L - BA-01 - F2.5 - S2				W - BA-02 - F3 - W1
32											S - BA-03 - S1				L - BA-01 - F3 - S1				W - BA-03 - F2 - W1
33											S - BA-03 - S2				L - BA-01 - F3 - S2				W - BA-03 - F3 - W1
34											S - BA-04 - S1				L - BA-02 - F2 - S1				W - BA-04 - F2 - W1
35											S - BA-04 - S2				L - BA-02 - F2 - S2				W - BA-04 - F3 - W1
36											S - BA-05 - S1				L - BA-02 - F2.5 - S1				W - BA-05 - F2 - W1
37											S - BA-05 - S2				L - BA-02 - F2.5 - S2				W - BA-05 - F3 - W1
38											S - BA-06 - S1				L - BA-02 - F3 - S1				W - BA-06 - F2 - W1
39											S - BA-06 - S2				L - BA-02 - F3 - S2				W - BA-06 - F3 - W1
40											S - BA-07 - S1				L - BA-03 - F2 - S1				W - BA-08 - F2 - W1
41											S - BA-08 - S1				L - BA-03 - F2 - S2				W - BA-08 - F3 - W1
42											S - BA-08 - S2				L - BA-03 - F2.5 - S1				W - BA-10 - F2 - W1
43											S - BA-09 - S1				L - BA-03 - F2.5 - S2				W - BA-10 - F3 - W1
44											S - BA-10 - S1				L - BA-03 - F3 - S1				W - BA-11 - F2 - W1
45											S - BA-10 - S2				L - BA-03 - F3 - S2				W - BA-11 - F3 - W1
46											S - BA-11 - S1				L - BA-04 - F2 - S1				W - BA-12 - F2 - W1
47											S - BA-11 - S2				L - BA-04 - F2 - S2				W - BA-12 - F3 - W1
48											S - BA-12 - S1				L - BA-04 - F2.5 - S1				W - BA-13 - F2 - W1
49											S - BA-12 - S2				L - BA-04 - F2.5 - S2				W - BA-13 - F3 - W1
50											S - BA-13 - S1				L - BA-04 - F3 - S1				W - BA-14 - F2 - W1
51											S - BA-13 - S2				L - BA-04 - F3 - S2				W - BA-14 - F3 - W1
52											S - BA-14 - S1				L - BA-05 - F2 - S1				W - BA-16 - F2 - W1
53											S - BA-14 - S2				L - BA-05 - F2 - S2				W - BA-16 - F3 - W1
54											S - BA-15 - S1				L - BA-05 - F2.5 - S1				W - BB-02 - F2 - W1
55											S - BA-16 - S1				L - BA-05 - F2.5 - S2				W - BB-02 - F2 - W2
56											S - BA-16 - S2				L - BA-05 - F3 - S1				W - BB-02 - F2 - W3
57											S - BA-17 - S1				L - BA-05 - F3 - S2				W - BB-02 - F2 - W4
58											S - BB-01 - S1				L - BA-06 - F2 - S1				W - BB-02 - F3 - W1
Backup

Cell Formulas
Range	Formula
N3,V3,R3	N3	=IF(SUM(N5:N14)=0,"-",SUM(N5:N14))
R5:R10,N5:N24,V5:V10	R5	=IFERROR(Q5*$I5,"")
L5:L24,T5:T24,P5:P24	L5	=IF($H5=0,"",$H5)
I5:I58	I5	=IF(COUNTIF($C$5:$C$102,H5)=0,"",COUNTIF($C$5:$C$102,H5))

 

[Rijnsent]

Hi there,
have you found this page: How to Generate a List of all Possible Permutations in Excel - Sheetaki ? It has kind of your example, the only thing you'd need to do is to filter to exclude combinations that don't exist.
Good luck,
Koen