Step by Step Instructions
Closed
nnavarro
nnavarro
- Posts
- 7
- Registration date
- Thursday June 4, 2015
- Status
- Member
- Last seen
- August 21, 2015
nnavarro
- Posts
- 7
- Registration date
- Thursday June 4, 2015
- Status
- Member
- Last seen
- August 21, 2015
Related:
- Step by Step Instructions
- List installation steps of jsdk - How-To - Webmaster
- Lan configuration steps ✓ - Forum - Network
- Confirm it's you to log in we noticed unusual activity from your account, so we've logged you out. follow the next steps within - Forum - Instagram
- Steps to execute nasm program - Guide
- Write steps to change desktop background - Guide
4 replies
Are you attempting to create a business process in excel? That will not scale well. I would suggest a database instead. Link the task tables to the methods.
nnavarro
Aug 19, 2015 at 05:12 PM
- Posts
- 7
- Registration date
- Thursday June 4, 2015
- Status
- Member
- Last seen
- August 21, 2015
Aug 19, 2015 at 05:12 PM
Hi ac3mark,
Yes, that is exactly what I am trying to do. When you say database, do you mean access? I am preparing the analysis for someone else to audit. Seven people are supposed to do the exact same thing. So I want to have consistency on how we do it. In addition, we are supposed to forecast 5 years out so a database wouldn't work for the whole process.
We already have a warehouse called Oracle Business Intelligence. My hope was to get people to run the same reports and paste in the exact same tabs. Pivot tables would consolidate the data and vlookup would help with the calculations. People still need to do few steps on their own. Step by step directions should help standardize.
Does that make sense?
Thanks,
NN
Yes, that is exactly what I am trying to do. When you say database, do you mean access? I am preparing the analysis for someone else to audit. Seven people are supposed to do the exact same thing. So I want to have consistency on how we do it. In addition, we are supposed to forecast 5 years out so a database wouldn't work for the whole process.
We already have a warehouse called Oracle Business Intelligence. My hope was to get people to run the same reports and paste in the exact same tabs. Pivot tables would consolidate the data and vlookup would help with the calculations. People still need to do few steps on their own. Step by step directions should help standardize.
Does that make sense?
Thanks,
NN
Well, yes like access. As for scaling of access, I have a business process built in access that has been used/modified, tweaked, and altered for over 10 years! As for the process of things, it is simple to build a table of task, and make them true or false. Think of this as the controller. Then you just have to query "What is true?" to find your step in the process. I simplified my building projects down to material lists based on what process was being worked. At a time, I could run a report for more than 50 projects, and because steps were marked as true up to a portion, I could then scrape out the next step process and get the materials in the future, based on what was already completed. As for reporting, access report builder is freindly, and very fast as for speed to market for custom reports! I hope you read this with an open mind, as excel does not scale well, and is not very "Relative Friendly" when it comes to variables and such.
nnavarro
Aug 19, 2015 at 06:13 PM
- Posts
- 7
- Registration date
- Thursday June 4, 2015
- Status
- Member
- Last seen
- August 21, 2015
Aug 19, 2015 at 06:13 PM
Thanks, I will look into it since I am not familiar with it. I let you know how that works.
nnavarro
Aug 21, 2015 at 05:58 AM
- Posts
- 7
- Registration date
- Thursday June 4, 2015
- Status
- Member
- Last seen
- August 21, 2015
Aug 21, 2015 at 05:58 AM
Hi ac3mark,
thanks for the response. I will definitely explore this option.
thanks for the response. I will definitely explore this option.