Current State:
I manage a spreadsheet that utilizes a pivot table and slicers (CAPACITY VIEW). One very important aspect of the process is to capture notes at the work center group level during the weekly review.
Problem Statement:
The notes can be added to the pivot table / slicer worksheet (CAPACITY VIEW) but they are not dynamic. When a different slicer is viewed the notes become meaningless for the new work center group being viewed.
Future State:
Dynamic notes need to be added at the work center level.
There are four criteria:
1) The notes must be dynamic, as the work center group slicer or machine status slicer is changed the associated notes about that view must appear.
2) The notes must appear within pivot table / slicer worksheet (CAPACITY VIEW). Users will not search for the information in another worksheet.
3) Users must be able to add, change, or remove notes within pivot table / slicer worksheet (CAPACITY VIEW).
4) No other software can be used it must be Excel or Visual basic is ok to use.
What I have done:
I was able to achieve #1 and #2 above #3 is proving to be difficult.
Greeting,
I have understood your Rough Cut Capacity Model based in Excel task and can do it with your 100% satisfaction. Please ping me for more discussion.
Relevant Skills and Experience
I have more than 5 years of experience in Excel, Visual Basic
Proposed Milestones
$140 USD - Rough Cut Capacity Model based in Excel
Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
Stay tuned, I'm still working on this proposal.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews.
Best regards
Relevant Skills and Experience
VBA
Proposed Milestones
$150 USD - final
hello we can do this
Relevant Skills and Experience
experts team is here to build such kind of excel macros program
we would like to discuss more
thanks
Proposed Milestones
$155 USD - intial
Let me see your file for better overview of possibility for task completion.
Relevant Skills and Experience
Excel VBA
Proposed Milestones
$111 USD - 3rd task
Dear Sir,
I read your job description. I would like to apply as your project.I have 5 years experience. If you like to hire me. I am ready to do your project.
Thanks
Relevant Skills and Experience
yes
Proposed Milestones
$155 USD - no
I can do this.
Relevant Skills and Experience
I knows well about excel and its features.
as well as about pivot tables.
Proposed Milestones
$77 USD - Within 2 days.