{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["General Information","Legendary Approval Workflow","Input Configuration","Output Configuration","Record Configuration","Alarm Configuration","System Info & Annotations","User Information","Network Information","STLR&SFLR Setpoints","EQP_ID&API_KEY","Field Descriptions","Source Sheet"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":1,"defined_names":17,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"General Information","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[19,0,20,3],[21,1,21,3],[23,1,23,3],[10,1,10,3],[14,1,14,3],[16,1,16,3],[17,1,17,3],[22,1,22,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[15,1,15,3],[5,1,5,3],[4,1,4,3],[6,1,6,3],[9,1,9,3],[0,0,1,3],[8,1,8,3],[7,1,7,3],[2,0,3,3]]}
["Anderson-Negele-Venture PPR & Legendary Implementation Service Specification Form Workbook Revision 2.5 Compatible with SW: 7.6.3"]
[]
["Recorder Configuration - Recorder Setup"]
[]
["Equipment Tag"]
["Number of Records to Generate",1]
["Rate of Data being Recorded (seconds)",5]
["Record Duration Period","Time Based"]
["Record Start Time","00:00:00"]
["Record Start Day of week"]
["Record Time Period (Hours)"]
["Plant Name"]
["Plant Address"]
["Plant ID"]
["X Axis Major Chart Divisions "]
["X Axis Minor Chart Divisions (per major)"]
["Y Axis Major Chart Divisions "]
["Y Axis Minor Chart Divisions (per major)"]
[]
["Date & Time Configuration"]
[]
["Time Format"]
["Time Zone"]
["Date Format"]
[]
[null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"Legendary Approval Workflow","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,1,14,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[7,1,7,3],[2,1,2,3],[0,0,1,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3]]}
["Legendary Approval Workflow"]
[]
["Record Type"]
["Approval workflow "]
["Number of Record Approval Stages"]
["Stage 1 Group Responsible "]
["Stage 1 Approval Time requirement (Hours)"]
["Stage 2 Group Responsible "]
["Stage 2 Approval Time requirement (Hours)"]
["Stage 3 Group Responsible "]
["Stage 3 Approval Time requirement (Hours)"]
[]
[]
[]
[]
[]
[]
[null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"Input Configuration","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,1,8]]}
["Input Configuration:"]
[]
["Input Number","Display Name","Type","Display Units","Display Unit \nLower Range Value ","Display Unit \nUpper Range Value","Decimal Position","Sensor Break Recording","Damping (Seconds)"]
[1,null,null,null,null,null,1,"Record-Sensor Break",1]
[2,null,null,null,null,null,1,"Record-Sensor Break",1]
[3,null,null,null,null,null,1,"Record-Sensor Break",1]
[4,null,null,null,null,null,1,"Record-Sensor Break",1]
[]
[]
[]
[null,null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"Output Configuration","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,1,3]]}
["mA Output Configuration:"]
[]
["mA Output Channel Number","Input Variable to Retransmit (selectable)","Display Unit","Input LRV","Input URV","mA Output Mode","Output Range Limits","Output LRV e.g.@4.0mA","Output URV e.g.@20.0mA","Output Value upon Input Error Condition","Output Load Resistance"]
[1,null,{"$f":"VLOOKUP($B4,'Input Configuration'!$B$4:$H$7,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B4,'Input Configuration'!$B$4:$H$7,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B4,'Input Configuration'!$B$4:$H$7,5,FALSE)","v":{"$error":"#N/A"}}]
[2,null,{"$f":"VLOOKUP($B5,'Input Configuration'!$B$4:$H$7,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B5,'Input Configuration'!$B$4:$H$7,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B5,'Input Configuration'!$B$4:$H$7,5,FALSE)","v":{"$error":"#N/A"}}]
[3,null,{"$f":"VLOOKUP($B6,'Input Configuration'!$B$4:$H$7,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B6,'Input Configuration'!$B$4:$H$7,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B6,'Input Configuration'!$B$4:$H$7,5,FALSE)","v":{"$error":"#N/A"}}]
[4,null,{"$f":"VLOOKUP($B7,'Input Configuration'!$B$4:$H$7,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B7,'Input Configuration'!$B$4:$H$7,4,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP($B7,'Input Configuration'!$B$4:$H$7,5,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"Record Configuration","index":4,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,6,1,9],[0,0,1,2],[42,1,42,2],[42,4,42,5],[42,7,42,8],[42,10,42,11],[43,1,43,2],[43,4,43,5],[43,7,43,8],[43,10,43,11],[40,1,40,2],[40,4,40,5],[40,7,40,8],[40,10,40,11],[41,1,41,2],[41,4,41,5],[41,7,41,8],[41,10,41,11],[38,1,38,2],[38,4,38,5],[38,7,38,8],[38,10,38,11],[39,1,39,2],[39,4,39,5],[39,7,39,8],[39,10,39,11],[32,1,32,2],[32,4,32,5],[32,7,32,8],[32,10,32,11],[35,0,36,11],[37,0,37,2],[37,3,37,5],[37,6,37,8],[37,9,37,11],[30,1,30,2],[30,4,30,5],[30,7,30,8],[30,10,30,11],[31,1,31,2],[31,4,31,5],[31,7,31,8],[31,10,31,11],[28,1,28,2],[28,4,28,5],[28,7,28,8],[28,10,28,11],[29,1,29,2],[29,4,29,5],[29,7,29,8],[29,10,29,11],[24,0,25,11],[26,0,26,2],[26,3,26,5],[26,6,26,8],[26,9,26,11],[27,1,27,2],[27,4,27,5],[27,7,27,8],[27,10,27,11],[20,1,20,2],[20,4,20,5],[20,7,20,8],[20,10,20,11],[21,1,21,2],[21,4,21,5],[21,7,21,8],[21,10,21,11],[18,1,18,2],[18,4,18,5],[18,7,18,8],[18,10,18,11],[19,1,19,2],[19,4,19,5],[19,7,19,8],[19,10,19,11],[16,1,16,2],[16,4,16,5],[16,7,16,8],[16,10,16,11],[17,1,17,2],[17,4,17,5],[17,7,17,8],[17,10,17,11],[10,10,10,11],[2,0,3,11],[13,0,14,11],[15,0,15,2],[15,3,15,5],[15,6,15,8],[15,9,15,11],[4,9,4,11],[5,10,5,11],[6,10,6,11],[7,10,7,11],[8,10,8,11],[9,10,9,11],[10,4,10,5],[4,6,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[9,7,9,8],[10,7,10,8],[4,3,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[4,0,4,2]]}
["Number of Records Selected to Configure:\n(only these records need to be configured)",null,null,null,null,null,"Record Printing Configuration:"]
[null,null,null,{"$f":"'General Information'!B6:D6","v":1},0,0]
["Record 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Buttons to Navigate to other Configuration Menus"]
[{"$f":"'Input Configuration'!$B$4","v":0},null,null,{"$f":"'Input Configuration'!$B$5","v":0},null,null,{"$f":"'Input Configuration'!$B$6","v":0},null,null,{"$f":"'Input Configuration'!$B$7","v":0}]
["Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording"]
["Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color"]
["Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value"]
["Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value"]
["Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record"]
["Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label"]
[]
[]
["Record 2"]
[]
[{"$f":"'Input Configuration'!$B$4","v":0},null,null,{"$f":"'Input Configuration'!$B$5","v":0},null,null,{"$f":"'Input Configuration'!$B$6","v":0},null,null,{"$f":"'Input Configuration'!$B$7","v":0}]
["Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording"]
["Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color"]
["Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value"]
["Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value"]
["Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record"]
["Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label"]
[]
[]
["Record 3"]
[]
[{"$f":"'Input Configuration'!$B$4","v":0},null,null,{"$f":"'Input Configuration'!$B$5","v":0},null,null,{"$f":"'Input Configuration'!$B$6","v":0},null,null,{"$f":"'Input Configuration'!$B$7","v":0}]
["Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording"]
["Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color"]
["Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value"]
["Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value"]
["Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record"]
["Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label"]
[]
[]
["Record 4"]
[]
[{"$f":"'Input Configuration'!$B$4","v":0},null,null,{"$f":"'Input Configuration'!$B$5","v":0},null,null,{"$f":"'Input Configuration'!$B$6","v":0},null,null,{"$f":"'Input Configuration'!$B$7","v":0}]
["Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording",null,null,"Enable Recording"]
["Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color",null,null,"Trendline Color"]
["Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value",null,null,"Recording Lower Range Value"]
["Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value",null,null,"Recording Upper Range Value"]
["Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record",null,null,"Print Recording Scale on Record"]
["Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label",null,null,"Print Y Axis Label"]

{"sheet":"Alarm Configuration","index":5,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,1,3]]}
["Alarm and Relay Configuration:"]
[]
["Alarm Number","Alarm Name","Input Name","Alarm State upon Input Error","Alarm Type","Setpoint 1","Setpoint 2","Delay (ms)","Assigned Relay"]
[1,null,null,null,null,null,null,null,1]
[2,null,null,null,null,null,null,null,2]
[3,null,null,null,null,null,null,null,3]
[4,null,null,null,null,null,null,null,4]
[5,null,null,null,null,null,null,null,"Unassigned"]
[6,null,null,null,null,null,null,null,"Unassigned"]
[7,null,null,null,null,null,null,null,"Unassigned"]
[8,null,null,null,null,null,null,null,"Unassigned"]
[9,null,null,null,null,null,null,null,"Unassigned"]
[10,null,null,null,null,null,null,null,"Unassigned"]
[]
[null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"System Info & Annotations","index":6,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[33,6,33,8],[20,6,20,8],[21,6,21,8],[22,6,22,8],[23,6,23,8],[24,6,24,8],[25,6,25,8],[28,6,28,8],[29,6,29,8],[30,6,30,8],[31,6,31,8],[26,6,26,8],[27,6,27,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[0,0,1,9],[32,6,32,8],[19,6,19,8],[29,3,29,5],[17,3,17,5],[18,3,18,5],[19,3,19,5],[20,3,20,5],[21,3,21,5],[22,3,22,5],[30,3,30,5],[31,3,31,5],[32,3,32,5],[33,3,33,5],[23,3,23,5],[24,3,24,5],[25,3,25,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[31,0,31,2],[32,0,32,2],[33,0,33,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[24,0,24,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[19,0,19,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2],[15,0,15,2],[11,9,12,9],[2,0,6,9],[16,0,16,2],[17,0,17,2],[18,0,18,2],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,6,16,8],[17,6,17,8],[18,6,18,8],[16,3,16,5],[11,6,11,8],[12,6,12,8]]}
["Predefined System info Annotations and Add Notes Annotations:"]
[]
["Description: \nSystem Info Annoations: Are annotations selected by the PPR user from drop down lists directly on the PPR home screen.  System info annotations are always added to the record in real time following user authentication.  \nPredefined \"Annotations\" (rightmost column): Are annotations that can be choosen by PPR user in real time or added to any previously recorded PPR datapoints through the \"Add Notes\" Workflow. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Description of System Info Headers and Annotations"]
[]
[]
[]
[]
[]
[]
[]
[]
["Header # 1",null,null,"Header # 2",null,null,"Header # 3",null,null,"List of predefined \"Add Notes\" Annotations:"]
[]
["Selectable Drop-down items",null,null,"Selectable Drop-down items",null,null,"Selectable Drop-down items",null,null,"Selectable Drop-down items"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"User Information","index":7,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,1,7]]}
["Legendary and PPR User Configuration:"]
[]
["First Name","Last Name","Initials [must be unique]","PPR/Legendary Role","Privileged to  Configure or Calibrate PPR?","Grant User Legendary Access?","If yes to Legendary access provide email","Is Legendary Admin?"]
[null,null,{"$f":"CONCATENATE(LEFT(A4,1),LEFT(B4))","v":""}]
[null,null,""]
[null,null,"",null,null,null,null,null,null,null,"Buttons to Navigate to other Configuration Menus"]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"Network Information","index":8,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,1,3],[4,0,4,5],[2,0,3,4]]}
["PPR Network Configuration:"]
[]
["Collecting the Network Information is recommended if PPR IP address will not by dynamic (DHCP)"]
[]
["Note: All PPRs will ship with Dynamic IP address. "]
[]
["IP Method"]
["Address"]
["Netmask"]
["Gateway"]
["Primary DNS"]
["Secondary DNS"]
[]
[]
[]
[]
[null,"Buttons to Navigate to other Configuration Menus"]

{"sheet":"STLR&SFLR Setpoints","index":9,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,3,3],[9,4,14,5]]}
["Pasteurization Setpoints are only applicable if PPR is configured with STLR or SFLR hardware."]
["All unused STLR setpoint should remain blank or 392°F/ 200°C"]
["Pasteurization Setpoints (SP):"]
[]
[null,"Loss of Signal Alarm SP",null,"(GPM)"]
[null,"High Flow Alarm SP",null,"(GPM)"]
[null,"STLR SetPpoint dead band",null,"°F"]
[null,"STLR SP1",null,"°F"]
[null,"STLR SP2",null,"°F"]
[null,"STLR SP3",null,"°F"]
[null,"STLR SP4",null,"°F"]
[null,"STLR SP5",null,"°F"]
[null,"STLR SP6",null,"°F"]
[null,"STLR SP7",null,"°F"]
[null,"STLR SP8",null,"°F"]
[null,"STLR SP9",null,"°F"]
[null,"STLR SP10",null,"°F"]
[null,"STLR SP11",null,"°F"]
[null,"STLR SP12",null,"°F"]
[null,"STLR SP13",null,"°F"]
[null,"STLR SP14",null,"°F"]
[null,"STLR SP15",null,"°F"]
[null,"STLR SP16",null,"°F"]

{"sheet":"EQP_ID&API_KEY","index":10,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,0,1,3]]}
["PPR Legendary Configuration:"]
[]
["For Anderson-Negele Internal use only"]
["This information is now collected on Legendary Specification Sheet"]
[]
["Equipment ID:"]
["API Key:"]
["Endpoint URL:"]

{"sheet":"Field Descriptions","index":11,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Parameter Name","Default Value","Description","Recommended Value ","Limits ","Data Validation \"Title\"","Data Validation \"Title\" Text Only","Data Validation \"Input Message\" Formula - Do not edit these fields ","Total Character Count [255 max]","Data Validation \"Input Message\" Text only - Copy these fields to the input message of data validation"]
["Equipment Tag","PPR 1","The Equipment Tag is the name of the Paperless Process Recorder, this name appears on the home screen of PPR, in Legendary and on every record PPR creates. ","Name of process being recorded e.g. HTST1","12 Characters","Equipment Tag: Default = PPR1",null,"\nDescription: The Equipment Tag is the name of the Paperless Process Recorder, this name appears on the home screen of PPR, in Legendary and on every record PPR creates. \n\nRecommended Value: Name of process being recorded e.g. HTST1\n\nLimits: 15 Characters",{"$f":"LEN(H2)","v":255}]
["Number of Records to Generate","1 Record","PPR can be configured to create between 1 and 4 unique records per time period. ","Multiple records can be created when there is a need to review data from different inputs on unique records","Select via Dropdown",{"$f":" \"Default  = \"&B3","v":"Default  = 1 Record"},"Default  = 1",{"$f":"  CHAR(10) & \"Description: \" &C3 & CHAR(10)&CHAR(10) & \"Recommended Value: \" & D3 & CHAR(10)&CHAR(10) &\"Limits: \" & E3","v":"\nDescription: PPR can be configured to create between 1 and 4 unique records per time period. \n\nRecommended Value: Multiple records can be created when there is a need to review data from different inputs on unique records\n\nLimits: Select via Dropdown"},{"$f":"LEN(H3)","v":251},"\nDescription: PPR can be configured to create between 1 and 4 unique records per time period. \n\nRecommended Value: Multiple records can be created when there is a need to review data from different inputs on unique records\n\nLimits: Select via Dropdown"]
["Rate of Data being Recorded (seconds)",5,"The Frequency at which PPR writes process data to memory, this is independent of frequency at which data is scanned by PPR","Quicker rate for processes which require rapid changes to be recorded","Select via Dropdown",{"$f":" \"Default  = \"&B4","v":"Default  = 5"},"Default  = 5",{"$f":"  CHAR(10) & \"Description: \" &C4 & CHAR(10)&CHAR(10) & \"Recommended Value: \" & D4 & CHAR(10)&CHAR(10) &\"Limits: \" & E4","v":"\nDescription: The Frequency at which PPR writes process data to memory, this is independent of frequency at which data is scanned by PPR\n\nRecommended Value: Quicker rate for processes which require rapid changes to be recorded\n\nLimits: Select via Dropdown"},255,"\nDescription: The Frequency at which PPR writes process data to memory, this is independent of frequency at which data is scanned by PPR\n\nRecommended Value: Quicker rate for processes which require rapid changes to be recorded\n\nLimits: Select via Dropdown"]
["Record Duration Period","Time Based ","Records will be created at the conclusion of each time period","This parameter is currently not configurable","Time Based is only method available today","Default  = Time Based ","Default  = Time Based ","\nDescription: Records will be created at the conclusion of each time period\n\nRecommended Value: This parameter is currently not configurable\n\nLimits: Time Based is only method available today",191,"\nDescription: Records will be created at the conclusion of each time period\n\nRecommended Value: This parameter is currently not configurable\n\nLimits: Time Based is only method available today"]
["Record Start Time","00:00:00","Define the Hour and minute of day that a record period will typically begin","Based on plants typical production times, avoid creating a new record in the middle of a process when possible","Time of day","Default  = 0","Default  = 0","\nDescription: Define the Hour and minute of day that a record period will typically begin\n\nRecommended Value: Based on plants typical production times, avoid creating a new record in the middle of a process when possible\n\nLimits: Time of day",241,"\nDescription: Define the Hour and minute of day that a record period will typically begin\n\nRecommended Value: Based on plants typical production times, avoid creating a new record in the middle of a process when possible\n\nLimits: Time of day"]
["Record Start Day of week","Monday","Define the day of the week that records will typically start","Based on plants typical production times, avoid creating a new record in the middle of a process when possible","Select via Dropdown","Default  = Monday","Default  = Monday","\nDescription: Define the day of the week that records will typically start\n\nRecommended Value: Based on plants typical production times, avoid creating a new record in the middle of a process when possible\n\nLimits: Select via Dropdown",234,"\nDescription: Define the day of the week that records will typically start\n\nRecommended Value: Based on plants typical production times, avoid creating a new record in the middle of a process when possible\n\nLimits: Select via Dropdown"]
["Record Time Period (Hours)","12 hours","The time duration of each record that PPR creates ","Match the current process record time. 12 Hour Max for STLR applications","Select via Dropdown","Default  = 12 hours","Default  = 12 hours","\nDescription: The time duration of each record that PPR creates \n\nRecommended Value: Match the current process record time. 12 Hour Max for STLR applications\n\nLimits: Select via Dropdown",186,"\nDescription: The time duration of each record that PPR creates \n\nRecommended Value: Match the current process record time. 12 Hour Max for STLR applications\n\nLimits: Select via Dropdown"]
["Plant Name","Blank","This name will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today","Full plant name ","50 Characters","Default  = Blank","Default  = Blank","\nDescription: This name will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today\n\nRecommended Value: Full plant name \n\nLimits: 50 Characters",201,"\nDescription: This name will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today\n\nRecommended Value: Full plant name \n\nLimits: 50 Characters"]
["Plant Address","Blank","This address will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today","Plant Address, may exclude zip code ","100 Characters","Default  = Blank","Default  = Blank","\nDescription: This address will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today\n\nRecommended Value: Plant Address, may exclude zip code \n\nLimits: 100 Characters",225,"\nDescription: This address will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today\n\nRecommended Value: Plant Address, may exclude zip code \n\nLimits: 100 Characters"]
["Plant ID","Blank","This identification number will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today","IMS or other regulatory ID number when applicable","10 Characters","Default  = Blank","Default  = Blank","\nDescription: This identification number will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today\n\nRecommended Value: IMS or other regulatory ID number when applicable\n\nLimits: 10 Characters",251,"\nDescription: This identification number will appear on all records generated by PPR, similar to information that may be rubber stamped on paper records today\n\nRecommended Value: IMS or other regulatory ID number when applicable\n\nLimits: 10 Characters"]
["X Axis Major Chart Divisions ",12,"Defines the number of increments on the X axis that appear with time labels","Choosing a value that is devisable by the Record Time Period e.g. 12 for 12 hour chart, 14 for 7 day chart","Min: 1, Max: 20","Default  = 12","Default  = 12","\nDescription: Defines the number of increments on the X axis that appear with time labels\n\nRecommended Value: Choosing a value that is devisable by the Record Time Period e.g. 12 for 12 hour chart, 14 for 7 day chart\n\nLimits: Min: 1, Max: 20",241,"\nDescription: Defines the number of increments on the X axis that appear with time labels\n\nRecommended Value: Choosing a value that is devisable by the Record Time Period e.g. 12 for 12 hour chart, 14 for 7 day chart\n\nLimits: Min: 1, Max: 20"]
["X Axis Minor Chart Divisions (per major)",4,"Defines lighter colored minor divisions that appear between major divisions ","If major divisions equate to 1 hour, 6 minor will create divisions every 10 minutes, 4 minor will be every 15 minutes","Min: 1, Max: 10","Default  = 4","Default  = 4","\nDescription: Defines lighter colored minor divisions that appear between major divisions \n\nRecommended Value: If major divisions equate to 1 hour, 6 minor will create divisions every 10 minutes, 4 minor will be every 15 minutes\n\nLimits: Min: 1, Max: 10",253,"\nDescription: Defines lighter colored minor divisions that appear between major divisions \n\nRecommended Value: If major divisions equate to 1 hour, 6 minor will create divisions every 10 minutes, 4 minor will be every 15 minutes\n\nLimits: Min: 1, Max: 10"]
["Y Axis Major Chart Divisions ",10,"Defines the number of increments on the Y axis that appear with input scale labels ","a number divisible by the input range that  will be recorded on record ","Min: 1, Max: 60","Default  = 10","Default  = 10","\nDescription: Defines the number of increments on the Y axis that appear with input scale labels \n\nRecommended Value: a number divisible by the input range that  will be recorded on record \n\nLimits: Min: 1, Max: 60",214,"\nDescription: Defines the number of increments on the Y axis that appear with input scale labels \n\nRecommended Value: a number divisible by the input range that  will be recorded on record \n\nLimits: Min: 1, Max: 60"]
["Y Axis Minor Chart Divisions (per major)",10,"Defines lighter colored minor divisions (tick marks) that appear in between major divisions ",10,"Min: 1, Max: 24","Default  = 10","Default  = 10","\nDescription: Defines lighter colored minor divisions (tick marks) that appear in between major divisions \n\nRecommended Value: 10\n\nLimits: Min: 1, Max: 24",154,"\nDescription: Min: 1, Max: 24\n\nRecommended Value: Default  = 10\n\nLimits: Default  = 10"]
["Time Format",null,null,null,null,null,null,null,0]
["Time Zone",null,null,null,null,null,null,null,0]
["Date Format",null,null,null,null,null,null,null,0]
["Display Name","Input n","Name of the input that is displayed on home screen, chart view, record legend, etc.","Describe what the PPR is measuring on this input channel. e.g. Silo X, Flow","12 Characters. Not configurable on STLR/SFLR inputs ",{"$f":" \"Default  = \"&B19","v":"Default  = Input n"},"Default  = Input n",{"$f":"  CHAR(10) & \"Description: \" &C19 & CHAR(10)&CHAR(10) & \"Recommended Value: \" & D19 & CHAR(10)&CHAR(10) &\"Limits: \" & E19","v":"\nDescription: Name of the input that is displayed on home screen, chart view, record legend, etc.\n\nRecommended Value: Describe what the PPR is measuring on this input channel. e.g. Silo X, Flow\n\nLimits: 12 Characters. Not configurable on STLR/SFLR inputs "},255,"\nDescription: Name of the input that is displayed on home screen, chart view, record legend, etc.\n\nRecommended Value: Describe what the PPR is measuring on this input channel. e.g. Silo X, Flow\n\nLimits: 12 Characters. Not configurable on STLR/SFLR inputs "]
["Type","4-20mA ","List of available input types on PPR","Match process sensor ","Select via Dropdown. STLR applications: Input 1 and 2 must be Dual PT1000, selectable (°C/°F).  SFLR applications: Input 3 must be 0-20mA or 4-20mA.",{"$f":" \"Default  = \"&B20","v":"Default  = 4-20mA "},"Default  = 4-20mA ",{"$f":"  CHAR(10) & \"Description: \" &C20 & CHAR(10)&CHAR(10) & \"Recommended Value: \" & D20 & CHAR(10)&CHAR(10) &\"Limits: \" & E20","v":"\nDescription: List of available input types on PPR\n\nRecommended Value: Match process sensor \n\nLimits: Select via Dropdown. STLR applications: Input 1 and 2 must be Dual PT1000, selectable (°C/°F).  SFLR applications: Input 3 must be 0-20mA or 4-20mA."},250,"\nDescription: List of available input types on PPR\n\nRecommended Value: Match process sensor \n\nLimits: Select via Dropdown. STLR applications: Input 1 and 2 must be Dual PT1000, selectable (°C/°F).  SFLR applications: Input 3 must be 0-20mA or 4-20mA."]
["Display Units","°F","Input type is converted to display units. Data is displayed and recorded in Display units. ","Define what units are displayed when the input type is converted to display units.","Select via Dropdown, or enter custom",{"$f":" \"Default  = \"&B21","v":"Default  = °F"},"Default  = °F",{"$f":"  CHAR(10) & \"Description: \" &C21 & CHAR(10)&CHAR(10) & \"Recommended Value: \" & D21 & CHAR(10)&CHAR(10) &\"Limits: \" & E21","v":"\nDescription: Input type is converted to display units. Data is displayed and recorded in Display units. \n\nRecommended Value: Define what units are displayed when the input type is converted to display units.\n\nLimits: Select via Dropdown, or enter custom"},254,"\nDescription: Input type is converted to display units. Data is displayed and recorded in Display units. \n\nRecommended Value: Define what units are displayed when the input type is converted to display units.\n\nLimits: Select via Dropdown, or enter custom"]
["Display Unit Lower Range Value",0,"Lower limit of display range ","Match the input sensors range. e.g. if input type is 4-20mA and sensor range is 0-200°F enter 0","Numerical Value","Default  = 0","Default  = 0",{"$f":"  CHAR(10) & \"Description: \" &C22 & CHAR(10)&CHAR(10) & \"Recommended Value: \" & D22 & CHAR(10)&CHAR(10) &\"Limits: \" & E22","v":"\nDescription: Lower limit of display range \n\nRecommended Value: Match the input sensors range. e.g. if input type is 4-20mA and sensor range is 0-200°F enter 0\n\nLimits: Numerical Value"},184,"\nDescription: Lower limit of display range \n\nRecommended Value: Match the input sensors range. e.g. if input type is 4-20mA and sensor range is 0-200°F enter 0\n\nLimits: Numerical Value"]
["Display Unit Upper Range Value",200,"Upper limit of display range ","Match the input sensors range. e.g. if input type is 4-20mA and sensor range is 0-200°F enter 200","Numerical Value","Default  = 200","Default  = 200","\nDescription: Upper limit of display range \n\nRecommended Value: Match the input sensors range. e.g. if input type is 4-20mA and sensor range is 0-200°F enter 200\n\nLimits: Numerical Value",186,"\nDescription: Upper limit of display range \n\nRecommended Value: Match the input sensors range. e.g. if input type is 4-20mA and sensor range is 0-200°F enter 200\n\nLimits: Numerical Value"]
["Decimal Position",1,"Number of digits shown on home screen after the decimal point.","0 - 2 depending on input type and display range ","Min:0 , Max:6","Default  = 1","Default  = 1","\nDescription: Number of digits shown on home screen after the decimal point.\n\nRecommended Value: 0 - 2 depending on input type and display range \n\nLimits: Min:0 , Max:6",168,"\nDescription: Number of digits shown on home screen after the decimal point.\n\nRecommended Value: 0 - 2 depending on input type and display range \n\nLimits: Min:0 , Max:6"]
["Sensor Break Recording","Sensor Break ","How data is displayed on a PPR record when an input sensor error occurs. Record sensor break: will show gap in chart data when error occurs. Or record error as LRV or URV","Fail safe option ","Select via Dropdown","Default  = Sensor Break ","Default  = Sensor Break ","\nDescription: How data is displayed on a PPR record when an input sensor error occurs. Record sensor break: will show gap in chart data when error occurs. Or record error as LRV or URV\n\nRecommended Value: Fail safe option \n\nLimits: Select via Dropdown",251,"\nDescription: How data is displayed on a PPR record when an input sensor error occurs. Record sensor break: will show gap in chart data when error occurs. Or record error as LRV or URV\n\nRecommended Value: Fail safe option \n\nLimits: Select via Dropdown"]
["Damping (Seconds)",1,"Time constant used for filter dampening of PPR inputs. Dampening inputs will reduce measurement noise ","1-2 seconds for most input types","Select via Dropdown. Not configurable on STLR ","Default  = 1","Default  = 1","\nDescription: Time constant used for filter dampening of PPR inputs. Dampening inputs will reduce measurement noise \n\nRecommended Value: 1-2 seconds for most input types\n\nLimits: Select via Dropdown. Not configurable on STLR ",225,"\nDescription: Time constant used for filter dampening of PPR inputs. Dampening inputs will reduce measurement noise \n\nRecommended Value: 1-2 seconds for most input types\n\nLimits: Select via Dropdown. Not configurable on STLR "]
["Loss of Signal Alarm SP",1,"Use with SFLR config only. A low-flow or loss-of-signal alarm set point (SP) ensures that the analog flow meter input is actively being measured by PPR","5% of max. system flow rate","< High Flow Alarm ","Default  = 1","Default  = 1","\nDescription: Use with SFLR config only. A low-flow or loss-of-signal alarm set point (SP) ensures that the analog flow meter input is actively being measured by PPR\n\nRecommended Value: 5% of max. system flow rate\n\nLimits: < High Flow Alarm ",241,"\nDescription: Use with SFLR config only. A low-flow or loss-of-signal alarm set point (SP) ensures that the analog flow meter input is actively being measured by PPR\n\nRecommended Value: 5% of max. system flow rate\n\nLimits: < High Flow Alarm "]
["High Flow Alarm SP",100,"Use with SFLR config only. A High Flow Alarm set point (SP) ensures that all product is pasteurized for a proper amount of time of FDD is diverted.","Specific to each pasteurizer","< SFLR Input Upper  Range Value ","Default  = 100","Default  = 100","\nDescription: Use with SFLR config only. A High Flow Alarm set point (SP) ensures that all product is pasteurized for a proper amount of time of FDD is diverted.\n\nRecommended Value: Specific to each pasteurizer\n\nLimits: < SFLR Input Upper  Range Value ",252,"\nDescription: Use with SFLR config only. A High Flow Alarm set point (SP) ensures that all product is pasteurized for a proper amount of time of FDD is diverted.\n\nRecommended Value: Specific to each pasteurizer\n\nLimits: < SFLR Input Upper  Range Value "]
["STLR SP dead band",1,"Use with STLR config only. Entered in display units, this value is added to the chosen STLR SP which must be reached before Cut-In is achievable.  ","minimum of 1°F or 0.5°C","n/a","Default  = 1","Default  = 1","\nDescription: Use with STLR config only. Entered in display units, this value is added to the chosen STLR SP which must be reached before Cut-In is achievable.  \n\nRecommended Value: minimum of 1°F or 0.5°C\n\nLimits: n/a",218,"\nDescription: Use with STLR config only. Entered in display units, this value is added to the chosen STLR SP which must be reached before Cut-In is achievable.  \n\nRecommended Value: minimum of 1°F or 0.5°C\n\nLimits: n/a"]
["STLR SP1","165°F","Use with STLR config only. Set points (SP) are equivalent to the Cut-out Temperature","Defined by pasteurization process","n/a","Default  = 165°F","Default  = 165°F","\nDescription: Use with STLR config only. Set points (SP) are equivalent to the Cut-out Temperature\n\nRecommended Value: Defined by pasteurization process\n\nLimits: n/a",165,"\nDescription: Use with STLR config only. Set points (SP) are equivalent to the Cut-out Temperature\n\nRecommended Value: Defined by pasteurization process\n\nLimits: n/a"]
["System Info Header ","Product ","The header will appear above the dropdown list of \"System Info\" annotations on PPR home screen. See example on the right","Category or group name of items in system info list","20 characters ","Default  = Product ","Default  = Product ","\nDescription: The header will appear above the dropdown list of \"System Info\" annotations on PPR home screen. See example on the right\n\nRecommended Value: Category or group name of items in system info list\n\nLimits: 20 characters ",230,"\nDescription: The header will appear above the dropdown list of \"System Info\" annotations on PPR home screen. See example on the right\n\nRecommended Value: Category or group name of items in system info list\n\nLimits: 20 characters "]
["System Info Fields","Blank","The items that can be selected by PPR user associated with this System Info field category or Header","Most common annotations that will be added to PPR records in real time","12 Characters ","Default  = Blank","Default  = Blank","\nDescription: The items that can be selected by PPR user associated with this System Info field category or Header\n\nRecommended Value: Most common annotations that will be added to PPR records in real time\n\nLimits: 12 Characters ",229,"\nDescription: The items that can be selected by PPR user associated with this System Info field category or Header\n\nRecommended Value: Most common annotations that will be added to PPR records in real time\n\nLimits: 12 Characters "]
["List of predefined \"Add Notes\" annotations:","Blank","Text of predefined annotations can be altered by PPR user before being added to the record ","Most common annotations that may be added to PPR data points which were already recorded","20 Characters ","Default  = Blank","Default  = Blank","\nDescription: Text of predefined annotations can be altered by PPR user before being added to the record \n\nRecommended Value: Most common annotations that may be added to PPR data points which were already recorded\n\nLimits: 20 Characters ",238,"\nDescription: Text of predefined annotations can be altered by PPR user before being added to the record \n\nRecommended Value: Most common annotations that may be added to PPR data points which were already recorded\n\nLimits: 20 Characters "]

{"sheet":"Source Sheet","index":12,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Input Type",null,"Display Unit",null,"Decimal",null,"Sensor Break",null,"mA Output Mode",null,"Range Limits",null,"mA Out Error"]
["Disabled ",null,"°C",null,0,null,"Record Sensor Break",null,"Retransmit",null,"0-20mA",null,"0.0mA"]
["PT100 IEC 60751 °C",null,"°F",null,1,null,"Record-LRV",null,"Off",null,"4-20mA",null,"3.5mA"]
["PT100 IEC 60751 °F",null,"°K",null,2,null,"Record-URV",null,null,null,null,null,"4.0mA"]
["Dual PT 1000 alpha (.003750 °F)",null,"Ω",null,3,null,null,null,null,null,null,null,"20.0mA"]
["Dual PT 1000 alpha (.003750 °C)",null,"mA",null,4,null,null,null,"Alarm Type",null,null,null,"20.5mA"]
["0-20mA",null,"mV",null,null,null,null,null,"Active Above Setpoint"]
["4-20mA",null,"V",null,"Output Load Resistance",null,"Input Error",null,"Active Below Setpoint",null,"Records to Generate",null,"Recording Rate"]
["0-10V",null,"Gal",null,"High: 151-500Ω",null,"Active",null,"Active Inside Window",null,1,null,3]
["2-10V",null,"Ltr",null,"Low: 0-150Ω",null,"Inactive",null,"Active Outside Window",null,2,null,5]
["0-1500mV",null,"PPM",null,null,null,null,null,null,null,3,null,10]
["0-500Ω Resistor",null,"GPM",null,"Record Duration",null,"Record Time Period",null,"Colors",null,4,null,20]
["0-250Ω Resistor",null,"mS/cm",null,"Process Based",null,6,null,"Red",null,null,null,25]
[null,null,"µS/cm",null,"Time Based",null,8,null,"Yellow",null,null,null,30]
[null,null,"lbs",null,null,null,12,null,"Blue"]
[null,null,"Psi",null,null,null,"24 (1 Day)",null,"Black",null,"Legendary Roles"]
["PPR Time Zone",null,"Bar",null,null,null,"84 (3 Days)",null,"Green",null,"Operator"]
["Atlantic Time (AT) UTC-3/4",null,null,null,null,null,"168 (7 Days)",null,"Orange",null,"Supervisor"]
["Eastern Time (ET) UTC - 4/5",null,"Recording Scale",null,"Enable Recording",null,null,null,"Purple",null,"Quality"]
["Central Time (CT) UTC-5/6",null,"Left",null,"Enabled ",null,null,null,"Brown",null,"Admin (Cannot Approve)"]
["Mountain Time (MT)  UTC-6/7",null,"Right",null,"Disabled",null,null,null,"Gray",null,"Inspector"]
["Pacific Time (PT) UTC-7/8",null,null,null,null,null,null,null,"Teal",null,"Maintenance"]
["Alaska Time (AST) UTC-9",null,null,null,null,null,null,null,null,null,"Engineering"]
["Hawaii-Aleutian Time (HAT) UTC-10",null,"Date Format",null,"Time Format",null,"Record Type",null,"Workflow Type"]
[null,null,"MM/DD/YY",null,"HH:MM:SS (24-Hours)",null,"HTST, HHST, UHT ",null,"Quality"]
[null,null,"MM/DD/YYYY",null,"HH:MM:SS (12-Hours)",null,"Vat/Batch Past.",null,"Supervisor -> Quality"]
[null,null,"DD/MM/YYYY",null,null,null,"Clean in Place (CIP)",null,"Operator -> Supervisor -> Quality"]
[null,null,null,null,"Start Day of week ",null,"Aseptic",null,"Other"]
[null,null,"IP Method",null,"Monday",null,"Clean-Out-of-Place (COP)"]
[null,null,"Static ",null,"Tuesday",null,"Juice Past."]
[null,null,"Dynamic*",null,"Wednesday",null,"Egg Past."]
[null,null,null,null,"Thursday",null,"UV Past."]
[null,null,null,null,"Friday",null,"ESL "]
[null,null,null,null,"Saturday",null,"Cold Product Storage"]
[null,null,null,null,"Sunday",null,"Others"]
[]
[null,null,null,null,null,null,"Print Y Axis Label"]
[null,null,null,null,null,null,"Disable"]
[null,null,null,null,null,null,"Input Name "]
[null,null,null,null,null,null,"Input Name [Units]"]