Method for realizing automatic generation of fire-fighting equipment cabinet diagram based on EXCEL

Abstract

The invention relates to a method for realizing automatic generation of a fire-fighting equipment cabinet diagram based on EXCEL, and belongs to the technical field of automatic generation of cabinet diagrams. The method comprises the following steps: forming a standard typesetting model according to the type of fire-fighting equipment, and establishing a one-to-one correspondence relationship between a cabinet diagram and EXCEL; recording configuration components required by a fire extinguishing system controller into the bill of the EXCEL; generating a cabinet diagram, popping up a cabinet diagram file storage interface, and downloading and checking the cabinet diagram in real time; performing content proofreading in a manual proofreading mode; generating a controller cabinet diagram according to the configuration assembly, calculating auxiliary materials required by assembly, and inputting the auxiliary materials into a production system; adopting a consistent cabinet diagram,wherein the made material lists are uniform in style, and the types and types of original materials are greatly reduced; in the production link, receiving and assembling materials for production according to a bill of materials so that pre-production of conventional standard products can be realized, and goods are delivered immediately after ordering. Typesetting accuracy can be improved, the typesetting consistency can be achieved, and complex management caused by material diversification is reduced.

Description

technical field [0001] The invention relates to an EXCEL-based method for automatically generating cabinet diagrams of fire-fighting equipment, and belongs to the technical field of cabinet diagram automatic generation. Background technique [0002] The controllers of automatic fire alarm and fire linkage control system, fire special telephone system, fire emergency broadcasting system, fire door monitoring system and other related fire protection systems are the nerve center of each fire alarm system, so the assembly and cabinet of each system controller Typesetting (hereinafter referred to as cabinet map) production is particularly important. With the differentiation of usage scenarios and the surge in the number of various types of controllers, the correct rate of manual typesetting of controllers and cabinets is low, and the consistency of typesetting cannot be achieved, causing considerable problems for equipment production, debugging, use, and connection between differ...

AI Technical Summary

Problems solved by technology

[0003] Aiming at the defects of high cabinet typesetting error rate, inconsistent raw materials, and long delivery cycle existing in the prior art, the present invention proposes a method based on EXCEL to realize the automatic generation of fire equipment cabinet diagrams, and prefabricated standard Functions such as typesetting model, typesetting logical relationship of non-standard parts, component configuration rationality judgment, cabinet assembly material generation logic, cabinet diagram generation instant display, cabinet diagram style unification, etc.

Images