C
conspiringfate
PROJECT 1:EXCEL and VBA
From the developer:
From the developer:
Back
Additional notes from the developer:
The code modules are fairly well laid out, so I think a strong developer
could take over and complete the remaining work. The named ranges are
also very logical and easy to get a grip on. The steps are just rather
involved. For example, from the Modes&Sectors page, you need to
1)update any existing stakeholder records (Stakeholder worksheet) then
2)insert new stakeholder record rows (stakeholder worksheet) if new ones
were added then 3) update the list of stakeholders on the
StakeholderIssues page. You also need to do error checking like
removing empty rows (users might leave those in between data rows), and
generating an error if the stakeholder name is not entered, but a sector
is assigned. For even more data security, I'd recommend doing things
like limiting the scrollable area so users can't be adding stuff at
random spots on the worksheets. So it's fairly detailed stuff you neeed
to do for the updates.
I did some work, but the next developer will probably need to
go back and redo some of that since I started on the update logic, but
didn't complete it. The logic is complex enough it'd be better if
he/she had a fresh start on that.
************************************************
Tasks from client as well as a clarification of Task 4b:
Task 2: Change Issue's Column Label to Coke Prioritization Levels
- Update column label and test
Task 3: Enhance Position Map
- Modify font so that names are easier to read, possibly larger font
and
alternating colors?
- Add scroll bar for large lists
- Test printing and different screen resolutions for best fit
Task 4:
Overall these are more complex layouts.
4a: Combine steps 2 & 3
- Create new form
- Add code to auto-populate cells from keystrokes and correctly move
to
the
next step
- Send mock-up to client for review, make any requested modifications, and
test
Task 4b: Update step 4
I'm not sure I understand this task. It says "We want to move a couple of
buttons off the current Step 4 and create a new UI for them." Which buttons
are we moving off of step 4? The mock-up seems related to the General
Info
tab. Is the idea to get all of the fields in the General Info tab to
a
different screen? If that is the case, then would the user see it before
or
after the current step 4?
To clarify:
A) Today, on Step 4: Database, in addition to free form text fields for
info, there are 3 other fields to assign values to this stakeholder group.
1) Sectors, 2) Modes of Engagement, 3) Highest Priority.
B) Task 4B, also designated by the General Info tab in the Conceptual
Mock-ups excel file sent to you, is to create separate UI for the user to
designate this particular information. We figure it will look alot like
the
UI you create for Steps 2&3, just to give the user a consistant UI to
work
with).
The reason we are making this a separte UI v.s. just having you add it to
Steps 2&3 UI is bcs my product mgr tells me theswe topics need to be focused
on separately for some reason.
The user would see this 2nd UI after the 1st UI you are creating - ie.
Steps
2&3