Excel Expert Needed for Relay Bicycle Team Tracker
Budget: $30 – $250 USD
Project Title: Excel Expert Needed for Relay Bicycle Team Tracker
Overview: I am working with an Excel file related to a race grid for a bicycle team (attached: "BLANK_ Race Grid_Coaches Prediction.xlsm"). The file tracks race predictions with color-coded blocks across multiple rows and columns. The main task is to automate counting colored sets of blocks in even-numbered rows and place the results in specific cells, AND count the number of cell with in each block, this needs to be updated in real time.
Key Tasks:
Count Consecutive Colored Sets:
For even-numbered rows (e.g., rows 4, 6, 8, etc.), count consecutive blocks of the same color.
The range of cells being analyzed spans from columns D to BK.
The color reference for each row is located in column B of that row. For example, if row 4 has a red reference in B4, the code should count only the red blocks in row 4.
Output the Results:
The counts of these consecutive color blocks should be output in consecutive columns, starting from F32 for row 4, F33 for row 6, and so on.
For each row, the output should continue horizontally in consecutive columns (e.g., G32, H32, etc.). for the number of cells in that set, again in real time.
Automate with VBA:
The project requires the use of VBA to automate this task, specifically using a macro that can be run either manually or triggered when changes are made to the file.
Handling Color Issues:
Ensure that if no color is detected in column B for any given row, the macro skips that row or outputs an error message.
The colors need to be detected based on the cell's background (Interior.Color).
Additional Details:
A Worksheet_Change event should be included to trigger the macro when relevant cells (e.g., those in the D:BK range) are modified.
Debugging and handling of errors related to undefined macros or incorrect range references will be necessary.
Attached File: Please refer to the attached file "BLANK_ Race Grid_Coaches Prediction.xlsm" for the exact data structure.
Skills Required:
Strong VBA (Excel Macros) experience.
Ability to work with color detection and manage cell ranges dynamically in Excel.
Experience automating tasks based on events (e.g., Worksheet_Change).
Overview: I am working with an Excel file related to a race grid for a bicycle team (attached: "BLANK_ Race Grid_Coaches Prediction.xlsm"). The file tracks race predictions with color-coded blocks across multiple rows and columns. The main task is to automate counting colored sets of blocks in even-numbered rows and place the results in specific cells, AND count the number of cell with in each block, this needs to be updated in real time.
Key Tasks:
Count Consecutive Colored Sets:
For even-numbered rows (e.g., rows 4, 6, 8, etc.), count consecutive blocks of the same color.
The range of cells being analyzed spans from columns D to BK.
The color reference for each row is located in column B of that row. For example, if row 4 has a red reference in B4, the code should count only the red blocks in row 4.
Output the Results:
The counts of these consecutive color blocks should be output in consecutive columns, starting from F32 for row 4, F33 for row 6, and so on.
For each row, the output should continue horizontally in consecutive columns (e.g., G32, H32, etc.). for the number of cells in that set, again in real time.
Automate with VBA:
The project requires the use of VBA to automate this task, specifically using a macro that can be run either manually or triggered when changes are made to the file.
Handling Color Issues:
Ensure that if no color is detected in column B for any given row, the macro skips that row or outputs an error message.
The colors need to be detected based on the cell's background (Interior.Color).
Additional Details:
A Worksheet_Change event should be included to trigger the macro when relevant cells (e.g., those in the D:BK range) are modified.
Debugging and handling of errors related to undefined macros or incorrect range references will be necessary.
Attached File: Please refer to the attached file "BLANK_ Race Grid_Coaches Prediction.xlsm" for the exact data structure.
Skills Required:
Strong VBA (Excel Macros) experience.
Ability to work with color detection and manage cell ranges dynamically in Excel.
Experience automating tasks based on events (e.g., Worksheet_Change).