
Closed
Posted
Paid on delivery
I want an Excel workbook that lets me track live data in real time To make that possible, build a streamlined input panel—simple text boxes or drop-downs—so I can feed data quickly . Behind the scenes the workbook must hold the formulas and any VBA needed to keep the table live and automatically roll the numbers forward over overs and innings. Deliverables • A ready-to-use Excel file (.xlsx) with protected formulas and an unlocked input area Acceptance I will test the sheet during a short mock innings; if the three stats update instantly and the reset works, the job is done.
Project ID: 40763370
18 proposals
Remote project
Active 19 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
18 freelancers are bidding on average ₹1,276 INR for this job

Hello! I can build a streamlined Excel score-tracking sheet with a simple input panel, protected formulas, and automatic updates as the innings progresses. Could you clarify which three statistics must update and how the reset should work? I will choose the simplest reliable implementation using Excel formulas and VBA if needed, and ensure the sheet works correctly during your mock-innings test.
₹1,004 INR in 1 day
7.2
7.2

With my deep expertise in data analysis, processing, and visualization, I am confident that I can deliver an Excel workbook that exceeds your expectations. My track-record of leveraging Excel Macros and VBA to create dynamic and automated spreadsheets means that your live data tracking feature will operate seamlessly without the need for any manual intervention or number-crunching. I will ensure that the workbook is highly-intuitive so that even users with minimal Excel experience can effectively use it. Additionally, being fluent in English and Hindi, I can provide exceptional translation services if you need to cater to an audience beyond English. Moreover, since time-efficiency is a priority for me, you can be assured of my commitment to on-time delivery without compromising quality as my extensive skillset gives me the ability to automate processes and complete projects swiftly. Selecting me for this project gives you immediate access to reliable 24/7 support and a strong determination to exceed your expectations. I look forward to the opportunity of working with you in providing a ready-to-use Excel file showcasing protected formulas and an unlocked input area that tick all your boxes in terms of function and design. Thank you for considering my application!
₹5,050 INR in 1 day
6.5
6.5

Each ball goes into a running log on a hidden sheet; the three stats are pure formulas off that log, so they refresh with no macro lag. Day 1 you get a working draft to run a few overs through and flag anything off; day 2 I lock the formula cells, wire the one-click reset and hand over the final file. 1. Which three stats should the panel show, e.g. run rate, required rate, projected total? 2. .xlsx cannot store VBA; is .xlsm fine for the reset button, or should the reset be macro-free? I can start today and send the first draft within a few hours.
₹980 INR in 2 days
6.5
6.5

Hi, I'd build one input panel (dropdowns for the ball outcome: runs, wicket, wide, no-ball, extras) and a calculation sheet where formulas roll the numbers over overs and innings automatically. Formula cells are locked and only the input area stays open, and a reset button clears the match without touching any formula. Buttons need a macro, so the file would be .xlsm. If you need a plain .xlsx, I'd do the same with dropdowns and a log table, with the reset as a documented two-step instead. Which three stats should update instantly, and do you need both innings in the same file?
₹1,246 INR in 3 days
4.2
4.2

I can build an intuitive, real-time Excel scoring workbook that updates key statistics instantly as you enter data, making live tracking accurate, fast, and easy during an innings. Thank you for considering my proposal. I have gone through the requirements in detail. I will create a streamlined input panel with text boxes or drop-downs, automated formulas, and VBA where required to update the score table across overs and innings. The workbook will include protected formulas, an unlocked input area, and a reliable reset function. I will test the workbook using a mock innings to verify that all three required statistics update immediately, overs and innings roll forward correctly, and the reset function works as expected. I have uploaded samples of similar Excel and dashboard projects completed by me earlier in my profile. With 10+ years of experience as a Chartered Accountant (ICAI) and CPA, I bring strong Excel, formula automation, and data accuracy expertise to this project. Payment & delivery assurance: ✅ No upfront payment ✅ Release payment after completion or milestone ✅ Regular update related to project ✅ Timely delivery ✅ 100% commitment to project completion I’m committed to delivering a dependable, easy-to-use workbook that performs smoothly during live scoring. Which three statistics do you need to see update instantly?
₹1,000 INR in 1 day
3.7
3.7

I can create a user-friendly Excel workbook with a simple input panel, automated formulas, and live score tracking that updates runs, overs, and innings instantly. I’ll include a clear reset function, protected formulas, and unlocked input cells, along with brief instructions for testing and use.
₹1,050 INR in 1 day
2.3
2.3

Hello! Your live-data Excel sheet with a quick input panel, ready 2 days after the award. You pay us nothing until you've seen it working. Here is what you get: • An input panel with drop-downs and boxes, so you feed each ball in seconds • Your three stats update instantly and roll over by overs and innings • Formulas protected, only the input area unlocked • A one-step reset for the next innings or match Good to know: an .xlsx file cannot hold macros, so the roll-over and the reset run on formulas. You still get the same result on screen. ✅ Included: 3 small changes within 3 weeks after you approve the work, and we fix any mistake of ours for free. Bonus: a short "how to use" tab inside the workbook. Our own demo: a data clean-up pipeline with a change log and a quality report, every row checked. Price: ₹1,500 for the whole job. Which three stats should update, for example runs, wickets and overs? P.S. Oldrich, the owner, supervises the work and stands behind every result. We use various tools and AI agents to work fast and efficiently.
₹1,500 INR in 2 days
1.7
1.7

Hi, one catch first: an .xlsx file cannot store VBA. I can deliver either (a) an .xlsm with buttons (Add ball, Undo, Reset innings), or (b) a pure-formula .xlsx where the input panel is drop-down cells and everything recalculates instantly with no macros. Both keep formulas locked and only the input area unlocked. How it will work: - Each ball is one row in a log: batter, bowler, runs, extra type (wide, no-ball, bye, leg-bye), wicket. - Overs count legal balls only: wides and no-balls add a run but don't advance the over; byes and leg-byes go to the team, not to the batter or bowler. - Run rate from balls, not the decimal: 85 runs in 12.4 overs = 85 / (76/6) = 6.71, not 6.85. Required rate in the chase = runs needed / (balls left / 6). - Strike rotates automatically on odd runs and at the end of each over; the innings rolls over at 10 wickets or the over limit. I'll test it with a mock innings against a hand-checked scorecard before delivery. Which three stats do you want live (score/wickets, overs, run rate, required rate, batter or bowler figures), and how many overs per innings?
₹1,000 INR in 1 day
0.0
0.0

Hi, I can create a user-friendly Excel workbook with a simple input panel, automatic live updates for all three stats, over and innings tracking, and a reset option. I’ll protect formulas, keep input cells unlocked, and thoroughly test the workbook during a mock innings to ensure accuracy and smooth operation.
₹1,050 INR in 7 days
0.0
0.0

Hello, I can help create an interactive Excel workbook for live cricket score tracking using Excel formulas, data validation, and automation. I have experience in Microsoft Excel, Excel VBA, Macros, Data Analysis, and Data Visualization. I can build a simple input panel with dropdowns or input fields, set up automatic calculations for runs and overs, and ensure the required statistics update immediately when new data is entered. I will also protect the formula cells, keep the input area editable, and implement a suitable reset function. I will test the workbook using sample innings to check that everything works correctly. I am ready to start. Please confirm which three statistics you want to track and how the reset function should work. I prefer communication through Freelancer chat. Thank you.
₹1,200 INR in 2 days
0.0
0.0

Hi, I recently helped a client with a similar project and can bring the same practical approach to your requirements. I have extensive experience in creating dynamic Excel workbooks tailored for real-time data tracking. I will design a streamlined input panel with user-friendly text boxes and drop-downs for quick data entry. The workbook will integrate the necessary formulas and VBA to ensure your stats update instantly, rolling forward seamlessly over overs and innings. I'm confident that I can deliver a ready-to-use Excel file with protected formulas and an unlocked input area that meets your expectations. I'd be happy to discuss your needs and the best approach for your project. Regards, James
₹750 INR in 7 days
0.0
0.0

With my extensive background in finance and over 8 years of experience working with Excel, I have the expertise needed to create a dynamic and efficient live data tracking workbook for you. I am well-versed in data analysis and processing, which will be crucial for ensuring that your sheet captures and updates information accurately and in real time. Furthermore, my experience in financial reporting and compliance has honed my ability to work with complex formulas and VBA implementations, a skillset that can be utilized to keep your workbook protected yet highly functional. My deep familiarity with advanced features of Excel such as locking specific cells and sections will ensure that not only are your desired data fields secure, but also protected from accidental editing or deletion. I pride myself on my strict attention to detail, a quality that proves invaluable when dealing with intricate tasks like yours. My goal-oriented mindset drives me to deliver high-quality results within agreed-upon timelines. If chosen for this project, I commit to producing an Excel file that meets all your requirements and demonstrates the utmost efficiency by providing accurate live data tracking.
₹1,050 INR in 7 days
0.0
0.0

This project immediately caught my attention because it is exactly the type of work I do best. Creating a streamlined input panel with simple text boxes or drop-downs to track live data in real time aligns perfectly with my expertise in Excel. I understand the importance of having a clean, professional, and user-friendly workbook that updates instantly and rolls the numbers forward seamlessly. While I am new to freelancer, I have tons of experience and have done other projects off site, including automating Excel workbooks with VBA. If this sounds like what you're looking for I'd love to hear more about your project. Regards, Warrick Van Eeden
₹700 INR in 7 days
0.0
0.0

Hi, I can create a clean, user-friendly Excel workbook for tracking live cricket statistics during an innings. The workbook will include: * A simple input panel for quickly recording match data. * Automatic calculations that update as new entries are made. * Protected formulas to prevent accidental changes. * Clear formatting and an easy-to-use layout. * A reset function for starting a new innings. * Testing with sample match data to verify accuracy. I will focus on making the workbook simple, reliable and easy to operate during a live match. Could you please confirm which three statistics need to update automatically and whether you have a preferred scoring layout? I’m ready to get started once the requirements are confirmed. Thank you!
₹1,100 INR in 3 days
0.0
0.0

Hi — I'd build this as a clean .xlsx with a locked formula/VBA layer plus a simple input panel (text boxes and drop-downs) so you can feed each ball quickly. The three stats update instantly, with automatic rollover across overs and innings and a one-click reset. First deliverable within a day: a working prototype with the input panel, protected formulas and mock-innings test data, so you can run your acceptance test before we polish formatting. I'm based in Hanoi (UTC+7) and turn feedback around fast, keeping all communication here in chat. — Hung
₹1,050 INR in 3 days
0.0
0.0

Hi, Luan here from Pretoria, South Africa. This project instantly caught my eye, so I had to reach out. I see you’re looking for an Excel workbook that tracks live data in real time, complete with a streamlined input panel for quick data entry. That sounds like a fun challenge! I’ve helped various clients create dynamic Excel sheets that not only function seamlessly but also incorporate VBA for real-time updates. I’m confident I can deliver a solution that meets your needs, and I’d be happy to share samples of my past work. Based on what you mentioned, here is how we would approach the project: - Design a user-friendly input panel with text boxes and drop-downs - Implement the necessary formulas and VBA for live data tracking - Ensure all formulas are protected while keeping the input area unlocked You can expect clear communication throughout the process, and I’ll make sure the final product is user-focused and optimized for performance. Best Regards, Luan
₹600 INR in 7 days
0.0
0.0

A .xlsx file cannot hold VBA, so the live update must work with formulas only. This is possible for simple stats, and it avoids macro warnings. I will build an input panel (drop-downs and cells), formulas that roll the numbers forward over overs and innings, protected formula cells, and a one-click clear-inputs range for reset. I will test it with a mock innings like yours. Similar sample: "Inventory/Purchasing Recon (Sample)" (formulas, plain .xlsx). About 3 days; ₹1,500. Which three stats must update, and is a one-click reset a must?
₹1,500 INR in 3 days
0.0
0.0

Hello, I read your post "Live Data Excel Sheet". As I understand it, you need: - Streamlined input panel with drop-downs or text boxes for rapid data entry - Formulas and VBA logic to update tables live and roll numbers across overs and innings - Protection on formula cells while keeping input areas unlocked - Instant real-time calculation of three key stats - Reset functionality to clear or reset tracking between innings I built a working sample for you with fictional data: KPI totals, a summary by innings and by month with each one's share of the total, a year filter you pick from a drop-down, and charts that update automatically. The summary formulas were recalculated and checked against an independent calculation. I can send the sample files in the chat right away. What you will get: - An .xlsx file that works in Excel, Google Sheets and LibreOffice (no macros) - Formulas checked before delivery, plus a short 'How to use' tab - One round of adjustments included Before starting I would like to confirm: - What are the specific three stats you need calculated and updated instantly? - Does the final file need to be an .xlsm (macro-enabled workbook) to support the required VBA automation? - What exact fields and drop-down options should be featured in the input panel? I will confirm the scope, price and delivery date after reviewing your sample and total workload. Best regards
₹1,137.87 INR in 1 day
0.0
0.0

New Delhi, India
Member since Oct 12, 2026
₹600-1500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
$15-25 USD / hour
$250-750 USD
$250-750 USD
$15-25 USD / hour
$250-750 USD
₹12500-37500 INR
₹12500-37500 INR
$15-25 USD / hour
₹12500-37500 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹1500-12500 INR
$250-750 USD
$30-250 USD
₹750-1250 INR / hour
€12-18 EUR / hour
$250-750 USD
₹1250-2500 INR / hour