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 in Others by Kithuzzz
• 20,660 points
31 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 by narikkadan
• 37,660 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 in Others by narikkadan
• 37,660 points
52 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 in Others by narikkadan
• 37,660 points
52 views
0 votes
1 answer

Excel VBA - downloading multiple historical exchange rates

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

answered Oct 18 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer

Frequency Array formula EXCEL not calculating

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

answered Oct 31 in Others by narikkadan
• 37,660 points
25 views
0 votes
1 answer

Excel feet and inches to millimeters

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

answered Feb 23 in Database by gaurav
• 22,040 points
506 views
0 votes
1 answer

Getting subtraction wrong in excel

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

answered Oct 10 in Others by narikkadan
• 37,660 points
37 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 in Others by Kithuzzz
• 20,660 points
28 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
449 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 in Others by narikkadan
• 37,660 points
56 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 in Others by narikkadan
• 37,660 points
32 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