VBA Function for Curvy Star Shape
Budget: £20 – £250 GBP
I'm working on a VBA project that creates a PowerPoint slide pack using an Excel VBA model to process my data.
The task involves delivering a single function that will take a 64,2 array as input and output a much better array (N,2) consisting of curves that will join up the points to form the outline of a smooth 16-sided curvy star shape. The infographic represents 16 data values with longer spokes indicating a higher value range (0-1), the entire shape sitting inside a circle.
Key Requirements:
- Uniform smoothness across all segments of the star.
- No abrupt direction changes; valleys and peaks must curve smoothly.
- The spokes bulge based on the value of the adjacent spokes.
The ideal candidate should:
- Prioritize code readability and documentation.
- Implement error handling and validation within the VBA function.
- Have experience with creating complex VBA functions.
- Have a good understanding of how to process data into a visually appealing format.
I've already generated the 64 point framework; I just need a function to join up the points. Feel free to use AI to generate the code if you prefer, but ChatGPT doesn't seem to have a clue and I need this finished soon.
The task involves delivering a single function that will take a 64,2 array as input and output a much better array (N,2) consisting of curves that will join up the points to form the outline of a smooth 16-sided curvy star shape. The infographic represents 16 data values with longer spokes indicating a higher value range (0-1), the entire shape sitting inside a circle.
Key Requirements:
- Uniform smoothness across all segments of the star.
- No abrupt direction changes; valleys and peaks must curve smoothly.
- The spokes bulge based on the value of the adjacent spokes.
The ideal candidate should:
- Prioritize code readability and documentation.
- Implement error handling and validation within the VBA function.
- Have experience with creating complex VBA functions.
- Have a good understanding of how to process data into a visually appealing format.
I've already generated the 64 point framework; I just need a function to join up the points. Feel free to use AI to generate the code if you prefer, but ChatGPT doesn't seem to have a clue and I need this finished soon.