Interactive database data management system

Overview: In the steelmaking production process, the ladle is the key equipment for holding molten steel, secondary refining, and continuous pouring. In a modern steelmaking plant, refractory materials are required for converters, refining, and ladles. In the steelmaking process, ladle is the main equipment for using and consuming refractory materials. Improving the service life of ladles and reducing refractory consumption is the key technology for steelmaking plants to save costs and reduce energy consumption for green production. In order to ensure the orderly operation of the ladle, save the consumption of refractory materials, prolong the service life of the ladle, and ensure the safe operation of the ladle, Wuhan CenterRise M&C Engineering CO. developed and launched the LDT-N200 integrated management system for the ladle. Introduction: LDT-N200 ladle integrated management system integrates LDT-L200 ladle lining thickness gauge, TBP-S300 ladle, tundish baking temperature and leakage monitoring system, RFD -C100 metallurgical electronic positioning system, and also integrates SQL Server database and NeuralWare (American computer software company) neural network software NeuralWorks to realize intelligent and optimized management of ladles. LDT-L200 ladle lining thickness gauge uses a laser area array scanning sensor to accurately measure the real-time thickness of the ladle lining, calculate the lining loss, and predict the service life of the ladle. TBP-S300 ladle, tundish baking temperature and leakage monitoring system uses infrared thermal imaging camera and embedded armor wire system to comprehensively monitor and prevent ladle leakage. RFD-C100 metallurgical electronic positioning system installs RFID electronic tags on all ladles to realize full-time and full-space ladle positioning and tracking. LDT-S200 ladle optimization control and analysis software, based on SQL Server database, B/S network structure, realizes online management of ladles, and adopts BP neural network system to realize intelligent optimization control of ladles. LDT-N200 ladle integrated management system can realize ladle age management based on ladle lining data and neural network algorithm, safety process control of ladle turnover and use, full-time tracking management of steelmaking production and full-space tracking management of ladle use and provide optimal control and management of steelmaking production and ladle maintenance. Comprehensive ladle measurement and monitoring, ladle positioning and management, and data management and optimization enable the LDT-N200 ladle integrated management system to fully realize ladle entire process management, optimize the service life of ladles, and comprehensively reduce the cost of refractory materials. The features: Using a lining thickness gauge to measure the thickness of the ladle lining Using infrared thermal imaging camera/embedded armor wire to realize ladle leakage detection Using RFID/number plate recognition to realize the location management of ladles Ladle age management system based on overall tracking Overall (full-time full-space) ladle management system based on database Provide overall production scheduling data Using neural network to predict ladle service life based on big data Ladle Optimal Scheduling System based on database and ladle service life Increase the service life of ladle by 12%-20% Reduce the use of refractory materials more than 15% Realize orderly management of ladle baking Realize full space and full time domain control Reduce the costs of ladle management and maintenance Improve the efficiency of ladle turnover operation

We specialize in providing a Business / System Analysis service with the associated custom software written to suit your business requirements. We assist businesses and individuals to improve their business processes through data modelling and database management. We make use of sophisticated and customizable SQL database solutions and MS Access to suit your own requirements. Our system offers a dynamic approach to software development. Our software is a user-customizable application that allows users to create their own software modules on the fly. Our software is unique in that it allows its users to build additional functionality within the software completely, without programmer intervention. Modules can be added to the system which supports hierarchical data structures, with customizable fields for each module created. The system is an effective Interactive Database Data Management System that has been designed to allow setups to suit user requirements from all industries. Our system program is also particularly useful to freelance consultants, freelance programmers or system developers to use as their preferred database system platform for their own clients. The development time for programmers and developers is substantially less than other conventional system platforms available. The process of database design has been simplified to the extent that users proficient in Microsoft Excel can easily convert a spreadsheet application into our database application type. Programming is simple as it mirrors much of Microsoft Excel and Microsoft Access functionality. Advanced Crystal Report writing, VB.Net, VB Visual Basic, VBA, C Sharp or C++ functions can also be integrated into the system. The system platform offers a combination of the functionality of a database program together with spreadsheet, word processing, documentation control functionality and Microsoft Project-style gantt chart planning. Multiple databases can be combined into one application using the system platform. The system platform supports various methods to populate a database including a direct interface, a webpage interface, a tablet interface or through an Excel or Word interface. The system can be setup to run on a stand alone computer or on a network. We currently have applications setup on the system that include: Construction Management Document control and Document Management Marketing Management Tender Management and Construction Cost Estimating Contract Management Subcontract Management Correspondence Management Programming and Planning Management Risk Management Health and Safety Management Quality Assurance Environmental Management Human Resources Management Internal Plant Management Stores Management Wage Personnel Management Salary Personnel Management Labour Costing Goods Received Costing Hired Plant and Equipment Costing Overheads Costing Subcontractor Costing Head Office Costing Accounting Cost and Management Performance Reporting Our skill sets include: Dynamic SQL / T-SQL SQL Server Database Administration, Reporting, Integration, Management, Database Building, SQL Store Procedures C#, VB.Net, VBA, HTML, AjaxControlToolkit, Javascript Crystal Report Writing Web interfaces to integrate data to databases Tablet Interfaces to integrate data to databases Windows server management Network setup and secity Microsoft Visual Studio Kaspersky security management Infragistic controls

Overview The system realizes the fixed-length measurement of the width, thickness and length of the continuously cast product through machine vision and laser rangefinding system. The measured data is transmitted to the host system through the optical fiber. The host system calculates the weight of each billet according to different steel grades and specific gravity, so that we can realize the fixed length measurement and fixed weight control of the cast products and the precise control of the steelmaking process in the production process. After cutting the billets by fixed weight and length, the fixed weight cut-to-length system is checked by the online weighing measurement system, so as to give feedback to the fixed length model of control system. The slab number (automatic checking) can also be automatically identified online by using machine vision, and the weight and slab number can be automatically stored in the local database for use in the production and management system. The measuring principle of the system On the upper surface of the billet, a set of linear CCD cameras and a laser rangefinding instrument are respectively installed. Through machine vision and laser correction, we can achieve precise measurement of the cast products’ shape. Through accurate cast products’ shape monitoring, the billet thermal expansion coefficient of cast products and cast products’ density at the current temperature, we can obtain the quality of the billet. At the same time, we can achieve high-precision quality cut-to-length , namely, fixed-weight and fixed-length. The system can be matched with the weight detection and calibration system. The system adopts the online barrier-free hidden integral roller table weighing method for continuous casting products, and connects its weighing data into the intelligent control model. The model and steel billet weighing system, and the fixed weight cut-to-length system realize the closed-loop control of the system model, and optimize the fixed weight accuracy through automatic signal collection. The features of the equipment The cutting control technology for fixed-length and fixed-weight of cast products is a concrete manifestation of the lean production management of steel products. In the era of high-quality competition of steel products, only high-end intelligent technology and management can reduce costs, improve quality and market competitiveness. 1. Data management can be carried out according to shifts, pouring times, days, weeks, months, etc., as well as data management according to specifications, production capacity, quality, etc. 2. Each stream can send out signals such as pre-clamping, clamping, cutting, roll-up, roll-down and return of the cutting car according to the user's requirements. 3. The detection and cutting precision is high, the controllable length sizing accuracy is ±1mm, and the quality sizing accuracy is more than 1.5‰. 4. It is not sensitive to other high-intensity light interference, and overcomes the influence of light sources such as sunlight and arc welding. 5. The monitor displays the running status of the current hot billet in real time and displays the corresponding parameters. 6. Laser rangefinding and CCD machine vision are used to calculate the weight of the cast products and optimize the cutting to length. 7. Historical cutting data is automatically stored, and the system can set rules for historical data. 8. Support the free transformation of fixed length, and a variety of operation modes are available for the operator to choose. 9. Adopt advanced high temperature laser measurement and high pixel linear CCD technology. 10. The system provides abundant interfaces, which can communicate with the PLC control. 11. Applicable to all kinds of continuous casting machine flame cutting system. 12. Provide automatic, upper and manual cutting control. The main technical requirements 1. Width range of the inspected cast product: 120~2000 mm 2. Length range of the inspected cast product: 1000~20000 mm 3. Thickness range of the inspected cast product: 35~400 mm 4. Steel billet moving speed: 3.5 m/s 5. Billet running speed: 6.5m/min 6. Temperature of the measured steel billet: 0~850 °C 7. Measurement accuracy: width ±0.2mm thickness ±0.2mm length ±0.2mm 8. Fixed weight accuracy: 0.8‰ (temperature model verification) 9. Quality inspection check: 1‰

Overview The continuous casting vibration type ladle slag detection device is used to detect the slag content of the ladle nozzle in the steelmaking continuous casting process, so as to improve the cleanliness of the tundish molten steel and obtain the best yield of the ladle molten steel. The device adopts the principle of vibration detection. The LAG-S200 continuous casting ladle slag automatic detection system is developed by Wuhan CenterRise M&C Engineering Co., Ltd. after many years of research with many scientific research institutes, and fully combined with the actual situation on site. It has a real field application value as a continuous casting ladle slag automatic detection system. The meaning of the system 1. Reduce the amount of tundish slag 2. Improve the purity of molten steel 3. Improve the life of the tundish 4. Reduce sliding nozzle erosion 5. Reduce nozzle blockage 6. Increase continuous pouring heats 7. Reduce the amount of residual steel in the ladle when high-quality steel is casting 8. Improve the yield of molten steel 9. Improve the quality of continuous casting billets In order to improve the purity of the molten steel in the tundish, and improve the quality of the casting billet, especially to improve the quality of the billet in the transition section, and reduce the amount of residual steel in the high-quality ladle, and prolong the life of the tundish lining, and increase the continuous casting heats, it’s necessary to detect and control the slag in the later stage of continuous casting ladle casting. The working principle The LAG-S200 continuous casting ladle slag automatic monitoring system detects the slag state during the pouring process by receiving the vibration signal of the mechanical operating arm of the ladle nozzle. In the process of molten steel pouring, when molten steel flows through the long nozzle and pours into the tundish, the molten steel impacts the wall of the long nozzle and causes the vibration of the mechanical operating arm used to support the long nozzle. Since the specific gravity of the steelmaking slag is less than half of the specific gravity of the molten steel, it floats on the surface of the molten steel, and the steelmaking slag appears when the molten steel is about to be all poured. At this time, due to the high viscosity and poor fluidity of light steelmaking slag, the impact force of the mixed flow of molten steel and steel slag on the wall of the long nozzle is quite different from that of pure molten steel. The system mainly monitors the ladle slag of the continuous casting by measuring and analyzing the vibration difference of the mechanical operating arm. The vibration signal is connected to the operation control unit of the system control cabinet through the front-stage conditioning and amplification module through the sensor installed in the middle of the operating rod. After processing, it is output to the industrial computer for operation and analysis. The slag signal detected by the system is output from the system control cabinet to the front-end control unit, and then control the alarm horn and alarm light to work, or issue an instruction to close the ladle nozzle. The features of the system (1) It is easy to install, basically no modification is made to the field equipment, and the installation and debugging work will not affect the normal production of the enterprise. (2) The detection accuracy is high, and the effective rate is greater than or equal to 95%. The threshold of slag volume is accurately set, the output control function is powerful. It has excellent performance in technical indicators such as the sensor service life and sensor usage times. (3) The sensor is installed at a position far away from the molten steel, and is cooled by a special refrigeration device for 24 hours. The outer layer adopts a composite protection structure, which has a long service life. (4) Adopt professional and targeted signal processing methods to obtain the vibration characteristic parameters of the ladle slag, and analyze, reason and judge the effective slag signal through the vibration signal database, which has a high accuracy of slag alarm. (5) The architecture is established based on the artificial intelligence network, which has the functions of self-learning and self-induction. (6) The equipment adopts a modular design. The failure of each module will not affect other parts, which ensure more reliable operation of the system and easy maintenance. (7) The alarm display device is used on site to visually indicate the flow state of molten steel and slag. When slag carryover strats, we can choose automatic mode or manual mode. In both modes, the system will give audible and visual alarm signals to remind on-site operators. (8) The system has a powerful database function. Including the comparison function for last two ladles of casting time record, the system automatically stores the running data, and generates a record file every day. (9) The system has the function of automatically controlling the ladle nozzle. The control unit is an auxiliary system of the system, which is interconnected with the ladle slag detection system to automatically control the opening of the ladle nozzle and realize the whole-process control of the liquid level of the molten steel in the tundish. The composition of the system The LAG-S200 slag detection system consists of: vibration detection sensor, pre-signal amplifier, slag detection operation unit, tundish liquid level control unit, on-site operation indication box, and process control cabinet. 1. Vibration detection sensor: It is installed on the robotic arm of the stopper to detect the vibration signal of the whole casting process of the ladle. 2. Pre-signal amplifier: Amplify, convert and transmit the weak vibration signal detected by the vibration detection sensor. 3. Slag detection operation unit: Analyze, judge and discriminate the vibration signal to realize the discrimination of all steel, mixed slag and full slag , and output the slag alarm signal. 4. Tundish liquid level control unit: Accept the control signal of the tundish nozzle and the ladle nozzle, and realize automatic or manual control to the ladle slag according to the requirements. 5. On-site operation instruction box: Provides man-machine exchange for slag alarm indication, fault indication, system activation mode selection, and control mode selection. 6. Process control cabinet, providing power management, displaying man-machine interface and setting management. The parameters of the system 1. The system controls the slag inclusion in molten steel with high precision and closes the nozzle in real time. 2. Improve the quality of steel, reduce defective products, and improve the yield. 3. The yield of molten steel is increased by 0.3%-0.5%. The nozzle can be automatically closed, so that the disadvantage of untimely manual response is overcome and less molten steel remains in the ladle. The threshold value of molten steel (slag threshold) is set by the user within a wide range. 4. No artificial factors are involved, high reliability, good repeatability or consistency. 5. The steelmaking slag does not pass through or rarely flows into the tundish, which increases the service life of the refractory material and the sliding nozzle. 6. Reduce the blockage of the tundish nozzle and increase the number of continuous pouring heats of the tundish.

Job title: Operations Coordinator Company: Citrogold (Pty) Ltd Closing date: 30 September 2020 Job purpose: Citrogold is looking for a full time Operations Coordinator to assist with sales and reporting to the Operation Manager. The position will be located at the Citrogold offices in Stellenbosch. Qualifications and experience required: Post Matric qualification At least 5 years of work experience in general office administration and customer liaison Proven MS Office proficiency (Excel, Word, PowerPoint, SharePoint etc.) Proven Pastel accounting system proficiency Proven data processing experience (Access, Excel or another database platform) Experience in database management programs Experience co-ordinating with many service providers for order completion Experience in agricultural industry such as nursery, farming, packhouse or import/export Customer service qualification/course (advantageous but not essential) Competencies: Code 08 Drivers licence will be a prerequisite Fully bilingual in English and Afrikaans. Interpersonal skills / team work Ability to focus on detail Customer relationship management skills Good work coordination skills Good communication skills & friendly disposition Duties: Customer and service provider liaison for processing of orders Reconciliations Database management Implementation of licensing contracts Assisting with reporting requirements Electronic filing & general administration If you are a professionally presentable, proactive person with strong organisational skills, take pride and ownership in your contribution, have excellent attention to detail and want to be part of a dynamic organisation, please forward a comprehensive CV, a letter motivating your application and expected remuneration to cv@citrogold.co.za. Feel free to call our office for more information on 021 880 0650. Please note that only shortlisted candidates selected for interview will be contacted. If you haven’t heard from us within two weeks of submitting your cv, your application was unsuccessful. Citrogold reserves the right not to make an appointment.

Manufacturing IT Systems Analyst – East London (24 month contract) Please note: 1. This position is a fixed term contract for 24 months 2. Completed tertiary qualification at NQF level 7 is essential (certificate to be submitted with CV) Requirements: · Matric certificate · Completed degree in Information Technology (NQF 7) · Minimum 2 years working experience (post-grad) as a Systems Analyst · Must be willing to work shifts if required Must be proficient in the following: · Linux, Storage, Networks, VWWare, Interfaces · Data modelling and database management systems – SQL, Oracle, PostgreSQL, · JAVA · Experience using Crystal Reports · DevOps (JIRA, GitHub, SonarCube, Jenkins) Outputs: · Responsible for designing solutions, failover designs, system sizing requirements · Manage software upgrades, deployments, downtime, patches etc. · Conduct testing after deployment or patches · Managing interfaces between applications · Provide technical support · Responsible for monitoring system performance and capacity planning · Develop reports (Crystal Reports) · Managing cross-functional programs and projects Salary negotiable, based on experience

Our client has implemented an integrated suite of software applications including JIRA, Confluence, Alfresco, Bitbucket and Sage X3 collectively called the Management Information Systems (MIS) in support of the business processes and information requirements. Further development, customisation, consolidation and application enhancement is required to improve the functionality and efficiency of the current set of MIS suite. Primary duties: • Develop, test and deploy custom solutions for MIS systems • Develop and test interfaces between the different applications to support the information and business requirements • Participate in needs identification and analysis with assistance of the MIS manager • Script writing (Linux) and development of reusable templates • Install, configure servlets, test, maintain, monitor and upgrade the MIS systems • Test environment setup and upgrades • System health monitoring and support • Server maintenance (Linux and Windows) • Provide user support and third-party application support on MIS systems (Jira, Confluence, Wiki, Alfresco, Bitbucket, etc.) Knowledge / Skills required: • Programming languages: Java, PHP, C++, Apache Groovy (programming and scripting language) • OS Linux any of the following: Centos, Ubuntu, Redhat • Relational Database: MySQL • Web Servers: Apache Tomcat, or Apache Web • Web development: HTML 5, CSS, JavaScript, JSON (Data Format), XML, VTL • RESTful web services • Bash and Linux scripting Beneficial / Advantageous: • Visual Basic • Experience in JIRA, Confluence, Bitbucket and Alfresco • Microsoft Server and Microsoft SQL • Source control: GIT • Docker, Hyper-V Creation Education and experience: • IT Degree, Diploma or relevant Certifications plus min 2 years relevant experience in a similar role Personal attributes: • Analytic thinking with a problem-solving approach • Enquiring mind ability to think outside the scope of what is required and eager to learn • Be a team player • Strong verbal and written communication skills • Ability to confidently interact with all stakeholders Should you wish to apply for the position, please apply directly via this job board, please ensure that you quote reference number 201989 subject heading or email body. Committed in maintaining diversity in its appointments, Surgo considers all applications in respect of its Employment Equity (EE). Surgo reserves the right not to make any appointments based on required criteria standards not met. All applications received are deemed active for a period of 3 months from date of submission. Due to the high volume of applications, should you not receive feedback within three months upon submission, you can assume your application was unsuccessful and we encourage you to reapply. Job Reference #: 201989

Job Objective: To provide a planning/scheduling service (in accordance with contract execution procedures) to both project and corporate management for home office and external (i.e. field) activities. Allocated projects are provided with the necessary set of planning documents appropriate for the size and phase of the project, including schedules/program, planning and progress procedure, Schedule Basis Memorandum etc. Documents are consistent in format and appearance. For allocated projects, planning documents comply with the contract requirements, and corporate or project specific procedures and are issued through WebDMS. For allocated projects, planning and progress monitoring tools (preferably standard tools WebDMS, CMS) are in place and updated in accordance with the project cut off and reporting requirements. For allocated projects, all planning reports and deliverables are accurate and issued on time. Where necessary these are accompanied by a narrative to explain changes and movement within the program. Progress measurement is traceable between the prepress measurement system and schedule/programme. For allocated projects, the current forecast of total key quantities is maintained. Key planning and duration statistics of the project has been populated into the Project Statistics Database on an ongoing basis, both budget/original plan and actual. Claims for extension of time are developed using detailed analysis of available data, and are accompanied by schedules/programmes that definitively prove valid claims to extension of time in accordance with the contractual framework of the project. Key Accountabilities & Responsibilities: Understand all relevant documentation pertaining to the project including scope of services, conditions of contract, project execution plan, project schedule, etc. Work within standard project planning / scheduling procedures. Ensure that these procedures comply with contractual reporting requirements and, if not, modify accordingly Prepare activity plans to accomplish all work required by the procedures Liaise with client project control personnel as necessary Prepare and issue of: overall project schedule, project network, manpower projection plan, critical equipment lists / schedules, progress ''s'' curves and tabulations, man-hour / manpower histograms, short term look ahead schedules and, monthly progress report including narrative Ensure that all involved parties participate in preparation of items described in item 5 and that they agree to their respective elements and approve documents where necessary Produce current physical progress reports and final job statistics Prepare and issue project action reports (monthly) to Project Manager Maintain accurate schedule and control curves in an updated condition and prepare forecasts of trends Act as a sponsor to trainees when nominated, regularly review their progress and make periodic reports to the Chief