Excel calculating drop rates

0 votes

To determine the Drop rates for each item, I want an excel spreadsheet that I can update with new information each time I play. This will allow the results to be more precise.

example data:

Drop # = how many times the item has been dropped

Drop % = the percentage that that item was dropped

data example

The data is in a table, the total value of Drop # is not. Each Drop# should represent an input, so I can add the quantity dropped of each item after I stopped playing.

Oct 29, 2022 in Others by Kithuzzz
• 38,020 points
906 views

1 answer to this question.

0 votes

Each column's "total" row is just the sum of the cells above it. The formulas should be like so:

Cell   Formula
C25    =SUM(C6:C24) 
D25    =SUM(D6:D24)
 . . .

Then, each cell in the second column will be an

When you copy and paste the formula into other cells, Excel will leave that portion of the formula alone since the dollar signs make the cell references absolute rather than relative.

It is not necessary to calculate the sums for this; for example, using B6, =SUM(C6/Z6)/SUM($C$6:$Z$24) would also work. However, I kept it as is since I figured the totals by themselves could be instructive to you.

If you need more or fewer columns, feel free to change the Z, which assumes that your data extends up to column Z.

I believe there is a technique to support any amount of columns, but I'm not certain right now. I'm sure you can find it on this site or Google.

overall drop % (for all data). You calculate it by dividing the sum of that row by the sum of all rows:

Cell   Formula
B6     =SUM(C6:Z6)/SUM($C$25:$Z$25)
B7     =SUM(C7:Z7)/SUM($C$25:$Z$25)
 . . .

answered Oct 29, 2022 by narikkadan
• 63,720 points

Related Questions In Others

0 votes
1 answer

How to create a drop-down list in Excel?

Making a list of the items you ...READ MORE

answered Oct 9, 2022 in Others by narikkadan
• 63,720 points
661 views
0 votes
1 answer

Navigate Excel Drop-Down List via Keyboard

You are aware of the auto-complete feature ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,720 points
514 views
0 votes
1 answer

Excel VBA - downloading multiple historical exchange rates

Do columns C and D contain your ...READ MORE

answered Oct 18, 2022 in Others by narikkadan
• 63,720 points
569 views
0 votes
1 answer

Frequency Array formula EXCEL not calculating

You obtain the same outcome, which suggests ...READ MORE

answered Oct 31, 2022 in Others by narikkadan
• 63,720 points
446 views
0 votes
1 answer

Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
1,719 views
0 votes
1 answer

Getting subtraction wrong in excel

Solution: If your values are a result of ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 63,720 points
1,682 views
0 votes
0 answers

Why is Excel not calculating the cube root as the cube root?

I think Excel treats exponents with recurring ...READ MORE

Nov 2, 2022 in Others by Kithuzzz
• 38,020 points
300 views
0 votes
1 answer

2D rotation of an object along a custom axis

Use this: Option Explicit Type ObjLocData ...READ MORE

answered Jan 31, 2023 in Others by narikkadan
• 63,720 points
325 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,720 points
983 views
0 votes
1 answer

On focus after tabbing of Excel drop down, automatically show list for selection

Put the following code in the Microsoft ...READ MORE

answered Oct 3, 2022 in Others by narikkadan
• 63,720 points
600 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP