Excel Expert Required for Document Production - One Time Job
Budget £20-150 GBP
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.
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.
Whether the result (FOR INPUT) is:
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
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...
...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.
44 freelancers are bidding on average £122 for this job
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
"""""”""""""""""""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
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
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 More
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
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
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
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
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
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
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
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 More
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