app description
Post on 23-Feb-2016
31 Views
Preview:
DESCRIPTION
TRANSCRIPT
APP DESCRIPTION
NON DISCLOSURE AGREEMENT ELC Group Inc. (henceforth The Company) is willing to disclose certain valuable and/or proprietary information to you which may include information about its business, subsidiaries, shareholders and other information (altogether hereinafter also referred to as 'the Company'). The information may include, without limitation, valuable financial, commercial and technical information, know how, inventions and ideas. 1. As a condition to such information being furnished to you, and - if any - your directors, officers, employees, agents, or advisors (including without limitation attorneys, accountants, consultants, bankers and financial advisors) collectively referred to as ‘representatives’, you agree to treat any information concerning the Company as confidential and in accordance with the provisions of this Confidentiality Agreement. 2. You will treat the information as confidential and shall not divulge or disclose any of the information to any third party during your consideration and assessment of the material or at any time thereafter. You will use the information solely for the purpose of preparing a proposal, as well as in the course of any follow up actions for advising The Company and not for any other commercial or other purpose whatsoever. 3. You will not disclose to any third party that you have received information about The Company. You are aware of the fact that any disclosure in this respect could lead to irreparable damage for The Company and its shareholders. 4. You will return all information furnished pursuant to this agreement at first request and will confirm that no information in this respect has been kept by you, except for information, which was already available before you received this information, and except for information, which is deemed to be generally available. 5. Internal dissemination within your organization shall be limited to those employees or directors whose duties justify the need to know such information and then only on the basis of a clear understanding by these employees of their obligation to maintain the secret status of such information and to restrict the use of such information solely to the use specified in paragraph 1. External dissemination and informing and engagement of third parties is only allowed if these parties have co-signed this agreement and after you have informed us of the parties to whom this information has been provided. 6. You will be responsible in any event for any breach of this agreement by you and any of your representatives and you agree, at your sole expense, to take all reasonable measures to restrain your representatives from disclosure or unauthorized use of the information. 7. You will be under no obligation with respect to any information after one (1) year following the effective date of this agreement. 8. This confidentiality agreement shall be governed by and construed in accordance with the laws of Turkey and all disputes arising in connection with this agreement shall only be submitted to a competent court in Turkey, which shall have exclusive jurisdiction. 9. This confidentiality agreement is not a guarantee for a contract between The Company and you
Requirements
• It needs to be developed on IOS and Android tablets• Multilanguage ready (English language text will be
provided, but we need to be able to supply other languages incrementally without problems)
• Development time max 3 calendar months• Source code ownership with me• Table structure is just a recommendation . If a better
arrangement is needed feel free to recommend it.
Logical viewProject • name• Location• Company details• Description• Note• Focus/Improvements Process
• Name• Description• notes
Components• Value Stream Map
• Takt time calculation• Cycle timing observation• Spaghetti chart +distance calculation• PQPR
Each Project have multiple processes
Each process have multiple components
Screens sequence
start
Open existingshow VSM If VSM
empty, do you want to
create a new one?
when user taps on one of the processes the he is
offered to open one of the elements related to that
process (takt, cycle time, pqpr, spaghetti)
Create new vsm. Define version name / unique
number, creates high level process boxes
No
Yes
User access the elements and
updates them several times. (takt, cycle
time, pqpr, spaghetti)
New or existing project?
New project
Updare project profile
No
Help
Export See the export page for how it works
open help manual online version at website for support refer to email
Tables and views (xls file here too) Microsoft Excel Worksheet
Versions• As you can see from the data model, many tables have versions• We need versions because datasets need to be compared with
each other (i.e. if I time a cycle the first time, then I want to perform some change and take the time again the second time))
• The table t_version stores the basic versions recordset• Sometimes I store previous versions difference in the table / view
for easier reference• There is one version per the overall process, not the elements.
every time the users wants to change version he will be asked if he wants to update the other elements before moving forward.
Export
• All content (project, process, elements, videos) need to be exported to excel / pdf format
• Content can be:– Sent via email– Placed on icould, google docs, dropbox and box
Focus and Improvements pageGIVEN A SELECTED VERSION, from the view called v_improvements shows:• A bar chart with the following sql : Select top 10(sum(Adjusted_time)) where project =
‘xyz’ and version =‘3’ (note there is no process, I want to see the top 10 steps for a given project belonging to any process). On the x axis the series are named process name+ step name
• A bar chart with the following sql : Select top10(vol_x_time(sum(tot_time from pqpr )where project = ‘xyz’ (note there is no process, I want to see the top 10 parts for a given project belonging to any process). On the x axis the series are named process name+ part name
• FOR every process step where sum(Prev_vers_difference_Adjusted_time)>0, group by process, a bar chart showing :– sum(Adjusted_time) Named AFTER• sum(Adjusted_time) from previous version Named BEFORE (alternatively you can use the
sum(Prev_vers_difference_Adjusted_time) and calculate tis value)• Process TAKT TIME (from t_Takt time table) as a red line on top.
• A table listing process, step, saved cycle time:(sum(Prev_vers_difference_Adjusted_time), and increased throughput Prev_vers_difference_throughput(throughput this version - throughput previous version)
TEXT TEXT
Assembly Process- Step 1
Painting Process - Step 3
Picking Process - Step 5
Packing Process - Step 5
02000400060008000
10000120001400016000
15000
40001000 400
Top 10 parts duration PQPR
Volumes* duration in minutes
Painting Step 2 Assembly Step 3 Packing Step 2 Picking Step 40
50100150200250300350 300
200
5010
Top 10 steps duration
Duration in minutes
Process Step Saved C.T. Increased throughput / day
Picking 2 50 +200 units
Packing 4 10 +400 units
Painting 3 10 + 100 units
Assembly 4 20 + 50 units
Total 90 Sec / cycle + 50 unitsAssembly Painting Picking Packing0
100
200
300
400
500
600500
400
200
100
250200 180
80
Before After
TEXT TEXT
Cycle time reduction
= TAKT TIME
Project Xyz
Value Stream mapping• A flowchart connecting the various processes
(v_VSM)• Process blocks are t_process records • Possibility to draw flow charts with the selected
shapes and connect them to each other• All shapes are measured with a timeline at the
bottom of the chart (v_vsm. sum(value adding time, sum(Non Value adding time, Total time = sum(value adding + non value adding time)
• Tapping on the individual process boxes brings the user to choose if he she wants to go to timing observation, spaghetti chart or pqpr
• TAKT time is displayed all the time.
Value Steam mapping example
TAKT TIME CALCULATION
Input form:• Shifts per day• Hours / shift• Break time / shift (minutes)• Lunch time / shift (minutes)• Planned downtime/shift
(minutes)• Customer demand / shift
(units)
Formula [(Shifts per day *Hours)- sum(Break time + Lunch time + Planned downtime) ] / Customer demand = TAKT TIME (expressed in seconds, minutes, hours, days)
Stored in the t_takt time table . It measures the pace of customer demand: cycle
time must be lower or equal to takt time in order
for the customer to be satisfied
Cycle timing observation
• Reference tables are: t_steps, t_cycle time• Initiation: Given a certain project / process, the users defines the process steps (i.e. step 1, 2 and 3) • RECORDING FEATURE :
– A: the cycle counter is set to 1, the step is set to 1. The users start recording a video.– B: Upon user input, the step changes to the next one. The time stamp of the start and the end of the step is saved .
Alternatively (recommended) when the users move on to the next step, the video stops and it is saved, then a new video recording immediately start. The recording file name is saved in the t_steps table so it can be referenced later.
– C: The user continue recording the following steps. When he reach the last step (i.e. step 3 in this example) the step start again from 1 and the cycle counter goes to 2. Then it continue again from point B of this list.
– D: When the user is satisfied it presses the STOP ALL And SAVE button.– The recorded video need to show: the time the project, the process the step the operator name
• ANALYSIS FEATURE:– The user is presented with a split screen: the upper half is the video with the controls as well as the export function (export
to excel with the video files attached as well as export to icloud / google/ dropbox etc.)– The lower part of the screen is an interactive table with the results and it is containing the data coming from t_Steps and
t_cycle time filtered by project, process, version. – Users might want to view older versions too, therefore it is important that the videos are saved not in HD resolution but in a
resolution that will allow to save enough video. – When clicking on the first cell of each row (i.e. the step number 3 in the next slide) the system should be able to play the
videos related to step number 3 in cycle 1 and 2 in parallel at the same time , so that the user can identify variation. More about this here:
http://iosguy.com/2012/01/11/multiple-video-playback-on-ios/http://stackoverflow.com/questions/6828256/multiple-video-same-screenhttp://developer.apple.com/library/ios/#documentation/AudioVideo/Conceptual/AVFoundationPG/Articles/00_Introduction.html
VIDEO WINDOW
VIDEO WINDOW
Cycle timing observation
Stop all +Save
HH:MM:SS
Text: Current step description
Start / Restart
Go to Next step
Step Cycle Lowest elemental time
Adjustment factor
Adjusted elemental time
1 OPERATOR NAME
2OPERATOR NAME
1 (note) 25s 15s 15s 5s 20s
2 30s 45s 30s 4s 34s
3 50s 60s 50s 5s 55s
Time for 1 cycle
105s 120s 119s
Text: Current Cycle = 1, 2, etc
1 2 3STEP
Record Audio note
Export to excel only / Export to video + excel to cloud, email, dropbox, box,com, google docs
Edit: # operators (2 etc)
Edit: Shift and Names
Video controls
Click to number play video portion (one step or the whole cycle)
Click to play audio note
Export Version #, CYCLE # . STEP #
Editable field
Possibility to compare different cycles of the same process steps identifying variations
Recording screen Analysis screen
Spaghetti chart• Reference table is t_spaghetti• Several improvement phases (again using versions)• There is always a Baseline version:
– The users first draws the background layer: squares and lines, no need to save on db– Then Import process steps from cycle timing observation (using the step_id field)– Then Connect process steps graphically and define distance between steps, distance measure and
speed of walking the other fields are calculated.(Previous_step_id, Next_Step_id, distance_previous_step, Distance_next_step, Distance_unit, Travel_speed, travel_unit, Time_to_next, Time_from_previous)
• Then the user can start creating one or more improved versions where he or she:– Remove – Rearrange – Move process steps (status field gets updated )– Renumber process steps therefore changing the sequence– Compare baseline with another version and calculate saved distance and travel time.– N.B. the saved distance and time is theoretical and it needs to be validated by timing again the cycle
using the cycle timing observation element. This data is anyway saved in the version ( Prev_vers_saved_time, Prev_vers_saved_distance)
• More on this subject here http://www.slideshare.net/onimproving/how-to-build-a-spaghetti-chart
Spaghetti chart
Draw background (squares and lines)
Import process steps from cycle timing
observation
Connect process steps and define distance
between steps
Remove – Rearrange – Move process steps
Re number process steps
Compare before and after and calculate saved distance and
travel time
Baseline Current state Future state versions
Part No.Demand Quanity
% of Total As Found (Compass)
LP VAC NEG FPGAMH38 5k7607
AMH38 7601
AMH100 7102 HP Gas HP Oil 2492
Total (Min)
G15k 54 4% 22 22LP 42 3% 186 186100k 39 3% 48 48160k 29 2% 48 48200k-3.5M 244 20% 54 547M-10M 135 11% 26 2614M 13 1% 45 50 957250 72 6% 10 48 44 68 7 88.5
PQPR (part quantity process route)• A simple table t_pqpr , with a basic record set:• Part number (item code)• Part Description (text)• Demand quantity (number)• % of total (% over total demand quantity)• Each process step description, coming from the timing observation, or defined at runtime• Each process step duration in minutes (also from timing observation)• Step sequence ( first, second etc.) so that the order can be understood.• Total time (calculated per part number)Function: Export to excel, send via email, upload to icloud, box, google docs, dropboxThe app will automatically identify the highest volume/highest time steps and color code them (using the t_focus boolean in the table)
top related