Creating the most symmetrical layout based on a range of spans and quantities

%3CLINGO-SUB%20id%3D%22lingo-sub-1534955%22%20slang%3D%22en-US%22%3ECreating%20the%20most%20symmetrical%20layout%20based%20on%20a%20range%20of%20spans%20and%20quantities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1534955%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20complex%20problem%20that%20can%20be%20solved%20by%20nested%20loops%2C%20which%20means%20programming%20skills%20which%20I%20am%20not%20equipped%20with%20at%20this%20point%2C%20but%20I%20thought%20you%20might%20have%20a%20suggestion%20on%20how%20to%20use%20Excel%20to%20solve%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20is%20the%20problem%3A%3C%2FP%3E%3CP%3EThere%20is%20a%20range%20of%20standards%20element%20spans%20and%20corresponding%20quantities.%20I%20need%20to%20find%20the%20most%20symmetrical%20layout%20for%20them.%3C%2FP%3E%3CP%3EFx.%20if%20we%20have%20the%20following%20data%20in%20excel%3C%2FP%3E%3CP%3E6x6m%2B3x4.2m%2B1x3m%3C%2FP%3E%3CP%3Ethen%20it%20would%20generate%20the%20most%20symmetrical%20combination(s)%20of%20layout%20for%20them.%3C%2FP%3E%3CP%3E3x6m-2x4.2m-1x3m-1x4.2m-3x6m%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20appreciate%20your%20help%20and%20time%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%2C%3C%2FP%3E%3CP%3EFarshid%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1534955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546051%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20the%20most%20symmetrical%20layout%20based%20on%20a%20range%20of%20spans%20and%20quantities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546051%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F726614%22%20target%3D%22_blank%22%3E%40FarshidKaviani%3C%2FA%3E%26nbsp%3B%2C%20Can%20you%20provide%20some%20more%20details%20please%3F%20For%20example%2C%20will%20the%20elements%20always%20be%20combined%20in%20groups%20of%205%3F%20Are%20there%20any%20rules%20around%20the%20spans%20and%20where%20they%20lie%20in%20the%20combination%3F%20Any%20additional%20information%20will%20be%20helpful.%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20it%20would%20be%20useful%20if%20you%20could%20share%20a%20sample%20workbook%20with%20any%20confidential%20information%20removed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546226%22%20slang%3D%22en-US%22%3ERe%3A%20Creating%20the%20most%20symmetrical%20layout%20based%20on%20a%20range%20of%20spans%20and%20quantities%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546226%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F383224%22%20target%3D%22_blank%22%3E%40TheAntony%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20for%20getting%20back%20to%20me.%20Unfortunately%2C%20there%20are%20not%20many%20rules%20and%20information%20that%20can%20be%20provided%20as%20they%20change%20in%20every%20single%20project%2C%20the%20only%20general%20rule%20that%20can%20be%20applied%20is%20all%20of%20the%20sub-spans%20and%20the%20total%20span%20should%20be%20divisible%20bt%20300%20mm.%3C%2FP%3E%3CP%3EFrom%20an%20architectural%20point%20of%20view%2C%20I%20can%20say%20that%20the%20smaller%20spans%20are%20the%20ones%20that%20should%20be%20placed%20closer%20to%20the%20middle.%20Besides%2C%20we%20always%20try%20to%20keep%20the%26nbsp%3Bvariety%20of%20span%20types%20as%20a%20minimum%2C%20if%20it%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20appreciate%20your%20help%20and%20time%20once%20again.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegard%2C%3C%2FP%3E%3CP%3EFarshid%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I have a complex problem that can be solved by nested loops, which means programming skills which I am not equipped with at this point, but I thought you might have a suggestion on how to use Excel to solve that.

 

Here is the problem:

There is a range of standards element spans and corresponding quantities. I need to find the most symmetrical layout for them.

Fx. if we have the following data in excel

6x6m+3x4.2m+1x3m

then it would generate the most symmetrical combination(s) of layout for them.

3x6m-2x4.2m-1x3m-1x4.2m-3x6m

 

I do appreciate your help and time in advance.

 

Best Regards,

Farshid

 

2 Replies

@FarshidKaviani , Can you provide some more details please? For example, will the elements always be combined in groups of 5? Are there any rules around the spans and where they lie in the combination? Any additional information will be helpful. 

Also, it would be useful if you could share a sample workbook with any confidential information removed.

@TheAntony Thank you so much for getting back to me. Unfortunately, there are not many rules and information that can be provided as they change in every single project, the only general rule that can be applied is all of the sub-spans and the total span should be divisible bt 300 mm.

From an architectural point of view, I can say that the smaller spans are the ones that should be placed closer to the middle. Besides, we always try to keep the variety of span types as a minimum, if it helps.

 

I do appreciate your help and time once again.

 

Regard,

Farshid