konchada2/Excel-Projects — reverse-engineered prompt
Reverse engineered prompt
I want an Excel based mini portfolio with two polished projects I can open and use right away.
First, make a dynamic accident heat map for Cambridge that lets me pick accident type and season from simple drop downs. The heat map should update automatically so I can quickly see the safest and most dangerous times to travel. Show the total number of accidents in the top left, keep the time and day labels dynamic based on when the workbook is opened, and include a geographic map view at the bottom that changes with the same filters.
Second, create a sales dashboard that helps analyze products by category and region. I want it to feel interactive and easy to explore, with pivot tables, charts, slicers, sparklines, and a map style view if possible. Make sure the data can be refreshed and the labels stay clean and readable.
Please make it look professional and easy for a normal Excel user to understand. If you need to, look up current Excel feature details online.
Want more depth? Deep Reverse