Sample.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Quantity | A (m) | B (m) | Hight (m) | Type | test | antall | sortert | sum | filtrert | vektet | ||||
2 | 1 | 0,3 | 0,2 | 3,34 | R | 1 | 0,000 | 0 | 0,533 | 5 | 5 | 1 | |||
3 | 15 | 0,3 | 0,1 | 2,19 | O1 | 2 | 0,000 | 0 | 0,423 | 1 | 1 | 1 | |||
4 | 4 | 0,3 | 0,15 | 3,34 | F | 3 | 0,013 | 4 | 0,013 | 4 | 4 | 1 | |||
5 | 5 | 0,3 | 0,8 | 3,34 | F | 4 | 0,533 | 5 | 0,000 | 0 | 0 | 0 | |||
6 | 1 | 0,3 | 0,4 | 3,24 | O2 | 5 | 0,000 | 0 | 0,000 | 0 | 0 | 0 | |||
7 | 1 | 0,4 | 0,7 | 3,24 | F | 6 | 0,423 | 1 | 0,000 | 0 | 0 | 0 | |||
8 | 1 | 0,3 | 0,6 | 3,34 | R | 7 | 0,000 | 0 | 0,000 | 0 | 0 | 0 | |||
9 | 4 | 0,3 | 0,2 | 3,34 | O3 | 8 | 0,000 | 0 | 0,000 | 0 | 0 | 0 | |||
10 | Result | 3 | |||||||||||||
11 | |||||||||||||||
12 | Bucket | 15 | |||||||||||||
Ark1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H2:H9 | H2 | =IF(AND((B2^2+C2^2)^2>0,E2="F"),(B2^2+C2^2)^2,0) |
I2:I9 | I2 | =IF(H2<>0,A2,0) |
J2:J9 | J2 | =IFERROR(LARGE($H$2:$H$9,G2),"") |
K2:K9 | K2 | =SUMIF($H$2:$H$9,J2,$I$2:$I$9) |
L2:L9 | L2 | =IF(J2<>J1,SUMIF($H$2:$H$9,J2,$I$2:$I$9),0) |
M2:M9 | M2 | =IFERROR(ROUNDUP(L2/$B$12,0),0) |
M10 | M10 | =SUM(M2:M9) |
Information:
- A, and B represents a square cross section.
- Hight is the hight of the column.
- Type is the type of Column ("R" for Round, "O" for oval, "F" for Square).
- Successfull/unique test is the diameter of the profile (does not matter what order A and B come in). Pytagoras.
- Neglect type R, and O?, just focus on type "F".
- See my solution.
Task:
1. How many unique profiles are there of type F? And how many are these if you count in the bucket/basket of a maximum of 15 pieces?
2. How meny unique profiles are there of type F, with the exact same length? Count in bucket.
Thanks in advance!