Milano1000
New Member
- Joined
- Jan 31, 2021
- Messages
- 5
- Office Version
- 2019
- Platform
- Windows
Hello all, I am confused how to collate or tabulate the results in this data set. Any help would be appreciated. I think this can be accomplished by using a formula but every effort has failed. I have given up and am asking for help.
This is it is just a set of math mathematical formulas that represent data points for a roll playing game. There 3 columns, Range Band (column B), Damage (column C), and Penetration (column D). The columns C and D are two separate formulas drawn from mathematical formulas. What I am trying to accomplish is take the data set of B:3 to D:31 and have Excel automatically Create the table in cells F:20 to K:21. Could I get help doing this from you all?
To clarify or reiterate, Damage gets smaller with Range, as does the Penetration. I am looking for a way to tabulate the data in table B:3 to D:31. Then reproduce it in F:20 to K:21. I highlighted the applicable data in red (column B) and Orange (column C and D). For example, (in row 7) at 145m the data should be eventually read as "4 / 2". As in a reference to G:20 and G:21. At 900m (row 27) should eventually read "1 / nil" as in K:20 and K:21.
I hope what I am asking makes sense. If not please do not hesitate to ask me and I will try to reiterate what I am trying to do.
This is it is just a set of math mathematical formulas that represent data points for a roll playing game. There 3 columns, Range Band (column B), Damage (column C), and Penetration (column D). The columns C and D are two separate formulas drawn from mathematical formulas. What I am trying to accomplish is take the data set of B:3 to D:31 and have Excel automatically Create the table in cells F:20 to K:21. Could I get help doing this from you all?
To clarify or reiterate, Damage gets smaller with Range, as does the Penetration. I am looking for a way to tabulate the data in table B:3 to D:31. Then reproduce it in F:20 to K:21. I highlighted the applicable data in red (column B) and Orange (column C and D). For example, (in row 7) at 145m the data should be eventually read as "4 / 2". As in a reference to G:20 and G:21. At 900m (row 27) should eventually read "1 / nil" as in K:20 and K:21.
I hope what I am asking makes sense. If not please do not hesitate to ask me and I will try to reiterate what I am trying to do.
Formula results.xlsx | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | |||
1 | ||||||||||||||
2 | Band | Damage | Penetration | |||||||||||
3 | 0 | |||||||||||||
4 | 0 | 5 | 2 | |||||||||||
5 | 5 | 4 | 2 | |||||||||||
6 | 10 | 4 | 2 | |||||||||||
7 | 145 | 4 | 2 | |||||||||||
8 | 150 | 4 | 2 | |||||||||||
9 | 155 | 4 | 2 | |||||||||||
10 | 160 | 4 | 2 | |||||||||||
11 | 165 | 4 | 2 | |||||||||||
12 | 170 | 3 | 2 | |||||||||||
13 | 175 | 3 | 2 | |||||||||||
14 | 225 | 3 | 2 | |||||||||||
15 | 250 | 3 | 2 | |||||||||||
16 | 275 | 3 | 2 | |||||||||||
17 | 300 | 3 | 3 | |||||||||||
18 | 325 | 3 | 3 | |||||||||||
19 | 350 | 3 | 3 | |||||||||||
20 | 375 | 2 | 3 | 0 - 5 | 5 - 165 | 165 - 275 | 275 - 350 | 350 - 575 | 575 - 950 | |||||
21 | 400 | 2 | 3 | 5 / 2 | 4 / 2 | 3 / 2 | 3 / nil | 2 / nil | 1 / nil | |||||
22 | 525 | 2 | 4 | |||||||||||
23 | 550 | 2 | 4 | |||||||||||
24 | 575 | 2 | 4 | |||||||||||
25 | 600 | 1 | 5 | |||||||||||
26 | 625 | 1 | 5 | |||||||||||
27 | 900 | 1 | 12 | |||||||||||
28 | 925 | 1 | 13 | |||||||||||
29 | 950 | 0 | 15 | |||||||||||
30 | 975 | 0 | 16 | |||||||||||
31 | 1000 | 0 | 18 | |||||||||||
32 | ||||||||||||||
Sheet1 |