Excel Expert Required for Document Production - One Time Job
Budget: £20 – £150 GBP
Hi,
This is a lot to take in. If the Job Description doesn't make sense then please
refer to the Summary at the bottom which might make it easier
for you to get started. I've attached the WordPad document.
Don't worry about my abbreviations meanings below. These are for my information. Please only focus on how I wish the Excel document to function.
I would also like instructions on what you did to create the Excel document and its formulae.
I would like the instructions to be delivered in video format so I can see exactly how you create this.
Please ask questions if I've left anything out or you need clarification on anything.
JOB DESCRIPTION
I am testing a betting system. I require an Excel document template to be created where I can input the following:
Consecutive numbering under a Date Heading. Numbers to continue to run consecutively regardless of date.
Then:
Whether the result (FOR INPUT) is:
W
MGSW
UDW
L
MGSL
UDL
UNDER A NEW HEADING (FORMULA):
TOTAL NUMBER OF: W, MGSW, UDW, L, MGSL, UDL
Then, (whether as part of same spreadsheet (preferably) or separate one) I need to put the following for input:
In relation to W, MGSW, UDW = PLUS X [add whatever amount will be]
In relation to L, MGSL, UDL = MINUS X [subtract whatever amount will be]
What I want to do here is input number of wins and losses which will be of a specific monetary amount and total up profit/loss for the day.
So the value of a W, MGSW, UDW is +£9.80 (for example). I want to be able to change these values if I choose.
The value of a L, MGSL, UDL is -£10.00 (for example). I want to be able to change these values if I choose.
Starting Bank amount - this is the amount of betting bank I start with so will be the first figure of entry, and could be anything.
Please set up so Excel will calculate this figure as it relates to figures above and below. The Starting Bank for this example is £500
Then:
Based on figures above Excel should work out:
Daily Net Profit:
In relation to how many W, MGSW, UDW and L, MGSL, UDL there were
(Which is the MONETARY VALUE NUMBER OF WINS MINUS MONETARY VALUE NUMBER OF LOSSES)
It's important it's worked out this way round so we include negative values to
reflect losing days. So it can't just be big number minus little number.
Daily Strike Rate (As a percentage. So that's number of W out of number of matches for the day)
equation: X (number of W) divided by number of matches x 100
Percentage Return on Daily Bank amount
Daily Net Profit divided by Accumulated Bank Amount - (The Accumulated Bank Amount is: Total Bank Amount MINUS Starting Bank Amount).
In this case the Starting Bank amount was £500.
Percentage Return on Starting Bank amount [in this case the Starting Bank is £500 but please make this so Starting Bank amount can be changed)
and Excel will calculate accurately accordingly.
Accumulated Bank Amount DIVIDED by Starting Bank x 100
If Possible could I also collect data to give total daily number of...
W
MGSW
UDW
L
MGSL
UDL
...as a separate column.
I've attached the data I've collated so far in a Wordpad document if this makes it easier to understand what I'm looking to collate and
what Excel needs to work out on automation.
IN SUMMARY: If you study the figures for FRIDAY 20TH JANUARY 2023 (A LOSING DAY) AND SATURDAY 21 JANUARY 2023 in the Wordpad document,
imagine this in Excel and being able to input into
Excel and Excel automating all the figures so I don't have to do it manually each time.
This is a lot to take in. If the Job Description doesn't make sense then please
refer to the Summary at the bottom which might make it easier
for you to get started. I've attached the WordPad document.
Don't worry about my abbreviations meanings below. These are for my information. Please only focus on how I wish the Excel document to function.
I would also like instructions on what you did to create the Excel document and its formulae.
I would like the instructions to be delivered in video format so I can see exactly how you create this.
Please ask questions if I've left anything out or you need clarification on anything.
JOB DESCRIPTION
I am testing a betting system. I require an Excel document template to be created where I can input the following:
Consecutive numbering under a Date Heading. Numbers to continue to run consecutively regardless of date.
Then:
Whether the result (FOR INPUT) is:
W
MGSW
UDW
L
MGSL
UDL
UNDER A NEW HEADING (FORMULA):
TOTAL NUMBER OF: W, MGSW, UDW, L, MGSL, UDL
Then, (whether as part of same spreadsheet (preferably) or separate one) I need to put the following for input:
In relation to W, MGSW, UDW = PLUS X [add whatever amount will be]
In relation to L, MGSL, UDL = MINUS X [subtract whatever amount will be]
What I want to do here is input number of wins and losses which will be of a specific monetary amount and total up profit/loss for the day.
So the value of a W, MGSW, UDW is +£9.80 (for example). I want to be able to change these values if I choose.
The value of a L, MGSL, UDL is -£10.00 (for example). I want to be able to change these values if I choose.
Starting Bank amount - this is the amount of betting bank I start with so will be the first figure of entry, and could be anything.
Please set up so Excel will calculate this figure as it relates to figures above and below. The Starting Bank for this example is £500
Then:
Based on figures above Excel should work out:
Daily Net Profit:
In relation to how many W, MGSW, UDW and L, MGSL, UDL there were
(Which is the MONETARY VALUE NUMBER OF WINS MINUS MONETARY VALUE NUMBER OF LOSSES)
It's important it's worked out this way round so we include negative values to
reflect losing days. So it can't just be big number minus little number.
Daily Strike Rate (As a percentage. So that's number of W out of number of matches for the day)
equation: X (number of W) divided by number of matches x 100
Percentage Return on Daily Bank amount
Daily Net Profit divided by Accumulated Bank Amount - (The Accumulated Bank Amount is: Total Bank Amount MINUS Starting Bank Amount).
In this case the Starting Bank amount was £500.
Percentage Return on Starting Bank amount [in this case the Starting Bank is £500 but please make this so Starting Bank amount can be changed)
and Excel will calculate accurately accordingly.
Accumulated Bank Amount DIVIDED by Starting Bank x 100
If Possible could I also collect data to give total daily number of...
W
MGSW
UDW
L
MGSL
UDL
...as a separate column.
I've attached the data I've collated so far in a Wordpad document if this makes it easier to understand what I'm looking to collate and
what Excel needs to work out on automation.
IN SUMMARY: If you study the figures for FRIDAY 20TH JANUARY 2023 (A LOSING DAY) AND SATURDAY 21 JANUARY 2023 in the Wordpad document,
imagine this in Excel and being able to input into
Excel and Excel automating all the figures so I don't have to do it manually each time.