Game Points Bank Account

jgthtrotih · Nov 4, 2009

Hi All,

Excel Workbook

R

S

T

U

V

W

X

5

Your Points

Points Needed To Level Up

Current Level

Your Credit

Withdrawal

Deposit

Credit

6

7

8

0

You Need 18,000 Pts.

Intermediate

Your Credit is 0 Pts

9

11,500

6,500

Beginner

Your Credit is 0 Pts

2500

4000

10

10,454

7,546

Beginner

Your Credit is 454 Pts

454

11

12500

5,500

Beginner

Your Credit is 1000 Pts

2000

3500

1000

Sheet6

i have a "Game Points Bank Account" that keeps track of the points users earn or spend in the game...what i need help is creating a running total for the bank..ive tried everything nothing works..

(this is actually like a traditional bank account)

each player starts with 10,000 points

*Row 8 is the only row to have formulas*

*Rows 9-11 are typed in to show my desired results*

Here is the point value "Ranking System" for Column T

Excel Workbook

AG

AH

5

Tier 1

6

Beginner

18000

7

Beginner

36000

8

Beginner

54000

9

Intermediate

72000

10

Intermediate

90000

11

Intermediate

108000

12

13

Tier 2

14

Advanced

126000

15

Advanced

144000

16

Advanced

162000

17

Expert

180000

18

Expert

198000

19

Expert

216000

20

21

Tier 3

22

Elite

234000

23

Elite

252000

24

Elite

270000

25

Superior

288000

26

Superior

306000

27

Superior

325000

Sheet6

Please ask for further questions!

Thanks!

jgthtrotih · Nov 5, 2009

Bump.

Thanks!

jgthtrotih · Nov 5, 2009

Bump.

Thanks!

jgthtrotih · Nov 5, 2009

Bump.

Thanks!

jgthtrotih · Nov 5, 2009

Bump.

Please Answer. I'm I missing some Info Or SomeThing?

Thanks!

jgthtrotih · Nov 6, 2009

Bump.

Thanks!

snowblizz · Nov 6, 2009

Trying to wrap my head around this.
Is column R supposed to hold the "running total"?
Each line is a different person?
What's the significance of V,W and X? This is where you want to make changes that will affect R right?

jgthtrotih · Nov 6, 2009

Snow,

Is column R supposed to hold the "running total"?

Yes

Each line is a different person?

Yes

What's the significance of V,W and X? This is where you want to make changes that will affect R right?

Yes, I want the default total in column R when a new person is added to read 10,000

than columns V,W,X will Affect That Total

so Column V will subtract points form column R

and W & X will both add points to column R

And Columns S,T,U are also affected by the total in column R

Hope This Makes Since!

Thanks!

snowblizz · Nov 6, 2009

Ok, step 1. This should make the adding and deleting of points work.
Place this code into the sheet module you are using.

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
Select Case Target.Column
Case 22
Target.Offset(0, -4).Value = Target.Offset(0, -4).Value - Target.Value
Case 23
Target.Offset(0, -5).Value = Target.Offset(0, -5).Value + Target.Value
Case 24
Target.Offset(0, -6).Value = Target.Offset(0, -6).Value + Target.Value
Case Else
Exit Sub
End Select
End Sub

jgthtrotih · Nov 6, 2009

Snow,

Step 1 Complete WORKS PERFECT!

how do i make it enter a default value of 10,000 for new players?

Thanks!

Game Points Bank Account

jgthtrotih

Well-known Member

Excel Facts

jgthtrotih

Well-known Member

jgthtrotih

Well-known Member

jgthtrotih

Well-known Member

jgthtrotih

Well-known Member

jgthtrotih

Well-known Member

snowblizz

Well-known Member

jgthtrotih

Well-known Member

snowblizz

Well-known Member

jgthtrotih

Well-known Member

Similar threads

Forum statistics

Share this page

Game Points Bank Account

Well-known Member

Excel Facts

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock