Closed

Excel Expert Required for Document Production - One Time Job

Job Description:

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.

Skills: Data Entry, Data Processing, Excel, Statistics, Visual Basic

About the Client:
( 1 review ) United Kingdom

Project ID: #35819868

44 freelancers are bidding on average £122 for this job

Giovanni704

Hi there! I have more than 10 years of experience as a Data Base Administrator and Analytics Engineer. I'd love to work together on your project. I'm so responsible and kind, I'll always send you the files on time and More

£20 GBP in 1 day
(49 Reviews)
6.9
AccountantArman

"""""”""""""""""""ADVANCE EXCEL EXPERT""""""""""""""""""""" "Sir, I am EXCEL ALL FIELDS Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant More

£85 GBP in 1 day
(226 Reviews)
6.9
simonklemp

Hello Janet, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skil More

£200 GBP in 4 days
(21 Reviews)
5.8
ARTICLEYOUWANT

I am damn sure that I can complete this project beyond your expectations within your given time and budget. I do not believe in charging high rates because I just love to write and fulfill my client’s need.

£100 GBP in 3 days
(64 Reviews)
5.7
mohamedahmedmoha

Hi, I have gone through your project, my expertise areas are bookkeeping , business plans , payroll, GST, account and financial modeling. I can create payroll, maintain bookkeeping and all accounting works very smoothl More

£135 GBP in 7 days
(6 Reviews)
3.6
USAMA1834

I have more than 5 years of hands on experience in Data Analysis, Process Automation and Reporting in Excel or Google Sheets. I specialize in: Compensation and Payroll Management Attendance, Rota/Shift and Leave More

£100 GBP in 7 days
(2 Reviews)
2.9
khushbooshaikh23

Hi, Greetings! ✅checked your project details: ✅Agreed on the budget ✔ Data entry ✔ PDF, Word, Excel, PowerPoint ✔ Typing ✔ Internet research ✔ Data mining ✔ Web scraping ✅Completed Time: In project deadline I hav More

£85 GBP in 7 days
(4 Reviews)
2.9
jeetparekhnmims

Hello, I am excited to apply for this project and believe that my skills and experience make me the perfect fit. I am highly motivated and committed to delivering top-quality work. I am also available to start immediat More

£250 GBP in 1 day
(1 Review)
2.4
andrwojsz

Hi, I have read description and checked attached notepad file. I prepared draft of desired excel file. If you are interested in, I would like to share short video of that. I have small question about manually changin More

£99 GBP in 3 days
(4 Reviews)
2.5
habib1433

Hi, I am an advance level excel expert. I checked your text file. I will the excel sheet for you that you exactly want. I have expertise in it. If you want I will submit you a sample without hiring me. So please messag More

£100 GBP in 2 days
(3 Reviews)
2.7
mscottjordan

This sounds like a ton of fun and I’m curious to hear more about your posting, but from what I can tell this is totally doable and a quick turnaround. Just finished something very similar regarding analysing results at More

£100 GBP in 2 days
(1 Review)
2.3
elijahadedayo30

I will do this for £50. I will create the TEMPLATE in one sheet and DASHBOARD that shows summary in another sheet. This can help you to track up and monitor your business. Kindly let us discuss it better in the chat se More

£50 GBP in 2 days
(2 Reviews)
1.5
tkmaina868

Hey! I am interested in your project Excel Expert Required for Document Production - One Time Job I have completed similar papers in the past and can assure you of exceptional and original work within the agreed deadli More

£121 GBP in 2 days
(2 Reviews)
0.8
moaaz995

Greetings, I read your project and I have experienced of web scraping, web searching, b2b leads generation, emails scraping, yellow pages scraping, email signature creating, WordPress typing/page designing, MS office/ More

£50 GBP in 3 days
(0 Reviews)
0.0
ahmedtahashalaby

Hello I am a data analyst. I will give you excellent excel sheet to fulfill your needs as your describe in you post .I am a production engineer. I have done this many times please check my profile to see my portfoli More

£135 GBP in 2 days
(0 Reviews)
0.0
anoopsinghaniya9

Hi. Thank you for your job posting. I have just checked your requirements carefully. It is an ideal match for my skills and experience. I have rich experience in Excel. I can start working immediately. Let's discuss mo More

£85 GBP in 1 day
(0 Reviews)
0.0
shubhu997102

Hello sir, I am expert in excel, data entry, web scraping, data mining. I am tech in a excel institute. I do you project at that you time given. I am honest, punctuate, self motivated and hardworking.

£70 GBP in 7 days
(0 Reviews)
0.0
kathmandu00977

Thank you for posting this project. I am a skilled freelancer with experience in creating spreadsheets and I am confident that I can deliver the high-quality results you are looking for. I have reviewed the text file a More

£112 GBP in 4 days
(0 Reviews)
0.0
MariamShafik1

I can make unique, creative, professional work for you as you want, Attention to detail My Expertise:- ●Data Entry: Ms. Office ( Excel, Access, Word, PowerPoint, Outlook ). ●Excel Expert. ● PowerPoint Expert. ●Word P More

£100 GBP in 4 days
(0 Reviews)
0.0
Sadhvini

Hello, I believe I will be a good fit for this project as I have been working in Testing for the past 2 years ,and I'm thorough in the Excel documentation,data processing I have all the skills that are needed to make More

£20 GBP in 2 days
(0 Reviews)
0.0