Excel Expert Required for Document Production - One Time Job
Bütçe £20-150 GBP
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.
Bu iş için 44 freelancer ortalamada £122 teklif veriyor
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 Daha Fazla
"""""”""""""""""""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 Daha Fazla
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 Daha Fazla
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.
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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/ Daha Fazla
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 Daha Fazla
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 Daha Fazla
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.
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
