CsJHUN
Active Member
- Joined
- Jan 13, 2015
- Messages
- 360
- Office Version
- 365
- 2021
- 2019
- Platform
- Windows
- Mobile
Hi guys,
I have to make an ERP (by day it looks more complex) like a database in excel with: production type, ok PCs, ng PCs, time and other losses; key machine parts replacing, these parts lifetime; employes's on the shop floor with their leaders; lines, processes; ..... (for abbreviation and japan lingo junkies: OEE, TEEP, KPI, choko-tei, doko-tei, ...) so on for each hour... I counted the columns and lines by trying to design it, R35040C1800, and this is the minimum for a year.
Frankly, I probably could do it in months, testing and figuring out how the best and most flexible (adding more "features", getting more graphs, pivots).
I'm wondering if any of you did this something like this before and lend me some advice. Maybe i should give up this task? :D (btw, I don't have any developer like degree, nor excel/access training)
thanks
J
I have to make an ERP (by day it looks more complex) like a database in excel with: production type, ok PCs, ng PCs, time and other losses; key machine parts replacing, these parts lifetime; employes's on the shop floor with their leaders; lines, processes; ..... (for abbreviation and japan lingo junkies: OEE, TEEP, KPI, choko-tei, doko-tei, ...) so on for each hour... I counted the columns and lines by trying to design it, R35040C1800, and this is the minimum for a year.
Frankly, I probably could do it in months, testing and figuring out how the best and most flexible (adding more "features", getting more graphs, pivots).
I'm wondering if any of you did this something like this before and lend me some advice. Maybe i should give up this task? :D (btw, I don't have any developer like degree, nor excel/access training)
thanks
J
