Dynamic Excel Tracker for 3-Digit Combinations
Budget: $30 – $100 USD
I'm looking for an Excel expert to create a variable tracking Excel file for me. I will be inputting a list of 1000 or more 3-digit numbers (ranging from 1-5) like 123, 231, 542, etc.
Key Requirements:
- Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence).
- Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on.
- Allow me to constantly update the list of 1000 numbers.
- I will be copying and pasting the numbers into the file.
Outputs/Reports Needed:
- A summary table that presents the movements in a clear and comprehensible manner.
- Please use standard formatting for the summary table, no need for conditional or custom formatting.
Ideal Skills & Experience:
- Proficient in Excel, with experience in creating complex tracking files.
- Previous experience with data analysis and reporting.
- Excellent attention to detail, to ensure accurate tracking and reporting.
The list of numbers will be updated daily.
Key Requirements:
- Track the movement of each digit (whether it's +1,2,3, or 4 or -1,2,3,4, and also 0 when the number remains the same in the next sequence).
- Provide a tally of movements for each digit in each position. For example, digit 1 in position 1 moved +1 75 times into the next sequence, +2 100 times, and so on.
- Allow me to constantly update the list of 1000 numbers.
- I will be copying and pasting the numbers into the file.
Outputs/Reports Needed:
- A summary table that presents the movements in a clear and comprehensible manner.
- Please use standard formatting for the summary table, no need for conditional or custom formatting.
Ideal Skills & Experience:
- Proficient in Excel, with experience in creating complex tracking files.
- Previous experience with data analysis and reporting.
- Excellent attention to detail, to ensure accurate tracking and reporting.
The list of numbers will be updated daily.