CsJHUN
Active Member
- Joined
- Jan 13, 2015
- Messages
- 360
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
- Mobile
Hi guys,
I have (must) to make a system based on excel and macros input, store data from production and later pivot them.
Im started here:
- 20-25 process (each process has its own files)
- 15-20 production line (probably each line will has its own folder for process files)
- hourly (12h/ shift) machine and headcount planned and used (p/u) data: machine pcs (p/u), product pcs (p/u), ng pcs (/u), tacttimes(p/u), product data (/u), production headcount data(p/u)...
I thought i will use access viewpoint and one row one shift (like: 2020-12-03; night shift. The line and process could be extracted from filename and foldername so i dont want to store it) Also started to count how many columns would have for one shift, its over 520 (different columns for plan and used caused duplicated column count)
Is this feasible with excel? I think it is but merge the data could take a while and any modification could cause mess.
Thanks for the replies in advance
I have (must) to make a system based on excel and macros input, store data from production and later pivot them.
Im started here:
- 20-25 process (each process has its own files)
- 15-20 production line (probably each line will has its own folder for process files)
- hourly (12h/ shift) machine and headcount planned and used (p/u) data: machine pcs (p/u), product pcs (p/u), ng pcs (/u), tacttimes(p/u), product data (/u), production headcount data(p/u)...
I thought i will use access viewpoint and one row one shift (like: 2020-12-03; night shift. The line and process could be extracted from filename and foldername so i dont want to store it) Also started to count how many columns would have for one shift, its over 520 (different columns for plan and used caused duplicated column count)
Is this feasible with excel? I think it is but merge the data could take a while and any modification could cause mess.
Thanks for the replies in advance