• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cloths size

F

flashgordon

New Member
Hello everyone,
I'm a little stuck at the moment, I have to order Christmas present for everyone in the company (approx 100 people). The present will be a fleece with a logo on.
So far I already have the height and weight of everyone in my database, but without having to get in touch with everyone to find out if they are S, M, L, XL, etc... etc.
Is there a caluculation that I could use to get an approximate size for everyone ?
Thanks in advance,
Gordon
 
Hi flashgordon,

I can't see how you are going to know their size i.e. S, M, L, XL, etc. if you only have their height and weight?

I would order a few extra, you never know they might put some extra pounds on over Christmas! :DD
 
Hi oldchippy,

I am using a table with a body mass index for people and then adding a calculation incorporating their weight and finally coding that with a size...

Its a lot but it should work
 
Hi, flashgordon!
If had height and weight why not install a 3D scanner at the entrance and register all the remaining biometric data? :rolleyes:
Regards!
PS: If it's a modeling agency,... ehmmm... why about uploading the HR file? ;)
 
Hi, flashgordon!

Give a look at the uploaded file. Maybe it helps, at least as a base model.

It has 2 main tables:
- worksheet BMI: body mass index (source: https://en.wikipedia.org/wiki/Body-mass-index)
- worksheet Size: default relation height size (no source, just trial and error, upon your own population sample)

BMI table has a Correction Index (column D) provided by a nutritionist friend. It also has a Coefficient used to temper the Correction Index impact. Trial and error too.

The main worksheet calculates the BMI, extract its Correction Index, displays the Default Size upon height, and calculates an Adjusted Size using the previously described values.

Check it for a initial theoretic H/W vs. final size relation]; if it works, go on to the final step, test again your actual data. If it doesn't work, well, play a bit with the tables and see if you arrive to a relatively reasonable conclusion.

Just advise if any issue.

Regards!

PS: If it works, please tell Chandoo he's able to royalty-free use it for the 10-set T-shirts for the Ninja team.
 

Attachments

Being a Textile Engineer i suggest you to ask your staff regarding this information, otherwise a too loose or too fit clothing will spoil your plan :)
 
SirJB7 said:
Hi, flashgordon!

Give a look at the uploaded file. Maybe it helps, at least as a base model.

It has 2 main tables:
- worksheet BMI: body mass index (source: https://en.wikipedia.org/wiki/Body-mass-index)
- worksheet Size: default relation height size (no source, just trial and error, upon your own population sample)

BMI table has a Correction Index (column D) provided by a nutritionist friend. It also has a Coefficient used to temper the Correction Index impact. Trial and error too.

The main worksheet calculates the BMI, extract its Correction Index, displays the Default Size upon height, and calculates an Adjusted Size using the previously described values.

Check it for a initial theoretic H/W vs. final size relation]; if it works, go on to the final step, test again your actual data. If it doesn't work, well, play a bit with the tables and see if you arrive to a relatively reasonable conclusion.

Just advise if any issue.

Regards!

PS: If it works, please tell Chandoo he's able to royalty-free use it for the 10-set T-shirts for the Ninja team.
Click to expand...

Thanks for this upload SirJB7, I was onto something very similar but yours look very complet, so I'll switch on to your model for the moment and tweek the details to suit my needs. ;)

Believe me if this was a model agency I would be visiting everyone to ask them what size they want but it's far from "Elite model agency".. lol

Once again thanks for your time and input.

Gordon
 
Faseeh said:
Being a Textile Engineer i suggest you to ask your staff regarding this information, otherwise a too loose or too fit clothing will spoil your plan :)
Click to expand...

Not so easy to get everyone to cooporate in the time delay that I need to get this sorted and I have people based all over the country... Thanks for the heads up :)
 
I never imagined we could do this with Excel ! amazing. :)

P.S. - from the post heading, initial re-action was, is it a spam ? :DD

P.S. 1 - comments in the Sheet Hoja1 Column Status are just :p
 
Last edited:
You must log in or register to reply here.
Back
Top