Immunocyte cytoplasm examination report generation method, device, equipment, medium and product

Abstract

The application discloses an immune cell COA (Certificate Of Authenticity) generation method, device, equipment, medium and product, and the method comprises the following steps: obtaining the identification information of an immune cell analysis batch number and a cell source object corresponding to an immune cell COA to be generated; initializing a report template for the immune cell COA to be generated according to the batch number and the identification information of the immune cell, to obtain an initial immune cell COA; in response to a data input trigger operation of an interactive interface in which the initial immune cell COA is located, automatically obtaining and displaying data content associated with the data input trigger operation, to obtain a target immune cell COA corresponding to the immune cell COA to be generated. The application solves the problems of low efficiency and high error rate of manual immune cell COA editing, can efficiently assist a user to complete report editing and generation, and improves the efficiency and accuracy of report generation.

Description

Technical Field

[0001] This invention relates to the field of data processing technology, and in particular to a method, apparatus, device, medium, and product for generating an immune cell quality inspection report (COA). Background Technology

[0002] After analyzing immune cells, a Certificate of Authenticity (COA) is typically generated based on the analysis results. The creation of an immune cell COA requires integrating a large amount of data from multiple analytical sources, including cell counts, viability, and phenotypic information. The data formats are diverse, and format conversion is also necessary. Currently, this data is usually collected, organized, and entered manually, a tedious and error-prone process that results in low efficiency in immune cell COA creation. Summary of the Invention

[0003] This invention provides a method, apparatus, device, medium, and product for generating immune cell COA, which can simplify the process of immune cell COA editing and generation, assist users in efficiently completing the immune cell COA editing and generation process, and improve the efficiency and accuracy of quality inspection report generation.

[0004] In a first aspect, embodiments of the present invention provide a method for generating COA in immune cells, the method comprising:

[0005] Obtain the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated;

[0006] Based on the immune cell analysis batch number and the identification information, the report template of the immune cell COA to be generated is initialized to obtain the initial immune cell COA;

[0007] In response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation is automatically acquired and displayed to obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0008] Secondly, embodiments of the present invention provide an immune cell COA generation device, the device comprising:

[0009] The cell analysis identification information acquisition module is used to acquire the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated;

[0010] The cell quality inspection report initialization module is used to initialize the report template of the immune cell COA to be generated based on the immune cell analysis batch number and the identification information, so as to obtain the initial immune cell COA;

[0011] The cell quality inspection report content input module is used to respond to the data input trigger operation of the interactive interface where the initial immune cell COA is located, automatically acquire and display the data content associated with the data input trigger operation, and obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0012] Thirdly, embodiments of the present invention also provide a computer device, the computer device comprising:

[0013] One or more processors;

[0014] Memory, used to store one or more programs;

[0015] When the one or more programs are executed by the one or more processors, the one or more processors implement the immune cell COA generation method as provided in any embodiment of the present invention.

[0016] Fourthly, embodiments of the present invention also provide a computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the immune cell COA generation method as provided in any embodiment of the present invention.

[0017] Fifthly, embodiments of the present invention also provide a computer program product, including a computer program that, when executed by a processor, implements the immune cell COA generation method as provided in any embodiment of the present invention.

[0018] The embodiments of the above invention have the following advantages or beneficial effects:

[0019] In this embodiment of the invention, by obtaining the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the immune cell COA to be generated, the report template of the immune cell COA to be generated is initialized according to the immune cell analysis batch number and identification information to obtain the initial immune cell COA; in response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation is input and displayed to obtain the target immune cell COA corresponding to the immune cell COA to be generated. The technical solution of this embodiment of the invention solves the problems of low efficiency and easy error in manual editing of immune cell COA, simplifies the process of immune cell COA editing and generation, assists users in efficiently completing the editing and generation process of immune cell quality inspection reports, and improves the efficiency and accuracy of quality inspection report generation. Attached Figure Description

[0020] Figure 1 This is a flowchart of a method for generating COA in immune cells provided in an embodiment of the present invention;

[0021] Figure 2 This is a flowchart of a method for generating COA in immune cells provided in an embodiment of the present invention;

[0022] Figure 3 This is a schematic diagram of an application example of a method for generating COA from immune cells provided in an embodiment of the present invention;

[0023] Figure 4 This is a schematic diagram of a Python program call sequence provided in an embodiment of the present invention;

[0024] Figure 5 This is a schematic diagram of flow cytometry cell mapping provided in an embodiment of the present invention;

[0025] Figure 6 This is a schematic diagram of flow cytometry cell plot insertion provided in an embodiment of the present invention;

[0026] Figure 7 This is a schematic diagram of immune cell COA header information provided in an embodiment of the present invention;

[0027] Figure 8 This is a schematic diagram of HLA information capture provided in an embodiment of the present invention;

[0028] Figure 9 This is a schematic diagram of a Donor information entry form provided in an embodiment of the present invention;

[0029] Figure 10 This is a schematic diagram of a cell viability density input window provided in an embodiment of the present invention;

[0030] Figure 11 This is a schematic diagram of a sterile report query dialog box provided in an embodiment of the present invention;

[0031] Figure 12 This is a schematic diagram of the structure of an immune cell COA generation device provided in an embodiment of the present invention;

[0032] Figure 13 This is a schematic diagram of the structure of a computer device provided in an embodiment of the present invention. Detailed Implementation

[0033] The present invention will now be described in further detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and not intended to limit it. Furthermore, it should be noted that, for ease of description, the accompanying drawings show only the parts relevant to the present invention, and not all of the structures.

[0034] Figure 1 This is a flowchart illustrating a method for generating immune cell COAs according to an embodiment of the present invention. This embodiment is applicable to scenarios involving the editing of immune cell COAs, particularly in situations where multiple types of data content in a report need to be integrated. This method can be executed by an immune cell COA generation device, which can be implemented in software and / or hardware and integrated into a computer device with application development capabilities.

[0035] like Figure 1 As shown, the method for generating COA from immune cells in this embodiment includes the following steps:

[0036] S110. Obtain the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated.

[0037] In an immune cell COA generation device that automatically integrates immune cell analysis data and generates immune cell COAs, after activating the device, the user can input the immune cell analysis batch number and cell source object identification information corresponding to the immune cell COA to be generated, based on the prompts. The device can then obtain the corresponding immune cell analysis batch number and cell source object identification information. The immune cell analysis batch number represents the number of a single immune cell analysis, and the cell source object identification information indicates the source object of the cell object in the immune cell analysis. The immune cell analysis batch number and cell source object identification information can be used to indicate the immune analysis data source file to be integrated for the generated immune cell COA, so that the corresponding data source file can be found in the corresponding data storage path. Immune cells can be at least one of peripheral blood mononuclear cells (PBMCs) and leukocyte concentrate.

[0038] S120. Based on the immune cell analysis batch number and the identification information, initialize the report template for the immune cell COA to be generated to obtain the initial immune cell COA.

[0039] The report template can be a pre-set template for integrating immunoassay data. The template specifies the display locations for different immunoassay data points, as well as the display locations for various identifying information items included in the quality inspection report. The rendering format for each data display position is also set accordingly within the template.

[0040] Based on the batch number and identification information of the immune cell analysis, the report template is initialized to obtain the initial immune cell COA. Alternatively, the immune cell analysis batch number and identification information can be automatically filled into the corresponding information display position to obtain an initial immune cell COA with no information filled in for the immune cell analysis results.

[0041] The batch number and identification information of the immune cell analysis are automatically filled into the corresponding information display position, which adds identification information to the immune cell COA and establishes the association between the immune cell COA to be generated and the immune cell analysis batch number and identification information.

[0042] S130. In response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, automatically acquire and display the data content associated with the data input trigger operation to obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0043] Specifically, the interactive interface for initial immune cell COA will have some functional controls, allowing for operations such as data import, modification, editing, calculation, export, and result confirmation.

[0044] Based on the data presented in the COA of immune cells, the data input trigger operation can be triggered for different data inputs, such as flow cytometry, human leukocyte antigen (HLA) reports, cell viability and sterility test reports, etc.

[0045] Different data content can be imported directly or entered in the data entry window. For example, in response to the data input trigger operation on the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation can be entered and displayed as follows:

[0046] In response to the flow cytometry plot input trigger operation in the interactive interface where the initial immune cell COA is located, the corresponding flow cytometry file is obtained from the data storage path associated with the immune cell COA to be generated; the target flow cytometry plot is formatted and cropped in the flow cytometry plot file; the formatted and cropped target flow cytometry plot is imported and displayed in the data display position corresponding to the initial immune cell COA.

[0047] In response to the data input trigger operation on the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation can be input and displayed as follows:

[0048] In response to the HLA report data input trigger operation on the interactive interface where the initial immune cell COA is located, the corresponding HLA report file is obtained from the data storage path associated with the immune cell COA to be generated; the target key information is extracted from the HLA report file, and the target key information is imported and displayed in the data display position corresponding to the initial immune cell COA.

[0049] In response to the data input trigger operation on the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation can also be input and displayed as follows:

[0050] In response to the data entry trigger operation on the interactive interface where the initial immune cell COA is located, the corresponding data entry interface is displayed; in response to the data input operation command on the data entry interface, the target data is obtained and displayed in the corresponding data display position; the data entry interface can be an object information entry window for cell source objects, a sterility report confirmation entry window, or a preset immune cell analysis attribute entry window. The parameters of each data window interface can be set according to the specific content of the input data.

[0051] The technical solution of this embodiment obtains the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the immune cell COA to be generated; based on the immune cell analysis batch number and identification information, the report template of the immune cell COA to be generated is initialized to obtain the initial immune cell COA; in response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation is input and displayed to obtain the target immune cell COA corresponding to the immune cell COA to be generated. The technical solution of this embodiment solves the problems of low efficiency and easy error in manual editing of immune cell COA, simplifies the process of immune cell COA editing and generation, assists users in efficiently completing the immune cell COA editing and generation process, and improves the efficiency and accuracy of quality inspection report generation.

[0052] Figure 2 This is a flowchart illustrating a method for generating immune cell COA according to an embodiment of the present invention. This embodiment belongs to the same inventive concept as the immune cell COA generation method in the above embodiments, and further describes the process of generating immune cell COA. This method can be executed by an immune cell COA generation device, which can be implemented in software and / or hardware and integrated into a computer device with application development capabilities.

[0053] like Figure 2 As shown, the method for generating COA from immune cells in this embodiment includes the following steps:

[0054] S210. Obtain the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated.

[0055] S220. Input the immune cell analysis batch number and the cell source object identification information into the preset information filling position of the preset immune cell COA template to obtain the initial immune cell COA.

[0056] S230. In response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, automatically acquire and display the data content associated with the data input trigger operation.

[0057] S240. In response to the statistical analysis trigger operation of the preset data items in the data content, perform statistical analysis on the preset data items and display the statistical analysis results in the corresponding data display position to obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0058] The process of creating a COA for immune cells requires extensive calculations and statistical analysis. The preset data items can include cell count, cell viability, and other data items. The average value, relative standard deviation, and other indicators of the preset data items can be determined through statistical analysis.

[0059] The calculation functions used for statistical analysis of preset data items can be pre-defined, and each calculation function (calculation program) corresponds to a statistical analysis calculation function.

[0060] Of course, the statistical analysis results can also be displayed in the corresponding data display area to obtain the target immune cell COA corresponding to the immune cell COA to be generated. At this time, the interactive interface where the initial immune cell COA is located becomes a preview interface of the target immune cell COA, and the user can view the immune cell COA after inputting various data contents.

[0061] S250, In response to the report export trigger command, export the COA of the target immune cells in the target format.

[0062] In addition, after the COA content of the target immune cells is integrated, it can be exported in a specified file format, such as PDF file format.

[0063] The technical solution of this embodiment obtains the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the immune cell COA to be generated; inputs the immune cell analysis batch number and the cell source object identification information into the preset information filling position of the preset immune cell COA template to obtain the initial immune cell COA; responds to the data input trigger operation of the interactive interface where the initial immune cell COA is located, automatically obtains and displays the data content associated with the data input trigger operation; responds to the statistical analysis trigger operation of the preset data items in the data content, performs statistical analysis on the preset data items, and displays the statistical analysis results in the corresponding data display position to obtain the target immune cell COA corresponding to the immune cell COA to be generated; responds to the report export trigger command, exports the target immune cell COA in the target format. The technical solution of this embodiment solves the problems of low efficiency and easy error in manual immune cell COA editing, simplifies the process of immune cell COA editing and generation, assists users in efficiently completing the immune cell COA editing and generation process, and improves the efficiency and accuracy of quality inspection report generation.

[0064] In a specific example, the process of generating an immune cell COA mainly consists of two parts: Excel VBA (Visual Basic for Applications) and Python. VBA controls Excel operations and data processing, while Python performs more complex file merging and format conversion. The two share data through file interaction or the clipboard, achieving data integration within the immune cell COA. The overall workflow includes automated data integration, flow cytometry processing and insertion, interactive data entry, HLA data extraction and integration, automated calculations, and one-click generation and export.

[0065] In the Excel VBA section, automated data integration involves VBA calling Python scripts to automatically extract relevant data on immune cells (such as cell count, viability, phenotypic information, etc.) from various experimental data files and populate this data into a preset COA template.

[0066] User interface design in Excel VBA includes creating user interfaces in Excel, such as input boxes, drop-down lists, macro command buttons, etc., for data input and interaction.

[0067] During flow cytometry plot processing and insertion, VBA calls an external program (e.g., "!Flow Cytometry Merge to PNG.exe") to merge and convert the PDF files of the immunological analysis reports generated by the flow cytometer. The processed flow cytometry plots are then cropped to the specified size and inserted into the COA template (the path in the code defaults to the current workbook's path, and the COA filename consists of key information such as the Donor number, product batch number, and product specifications).

[0068] Interactive data entry utilizes VBA-designed interactive forms (such as the Donor Information Entry Form and the Viability / Volume Density Entry Form) to handle data that cannot be automatically retrieved manually, such as donor information and special annotations. These forms provide an intuitive interface and user-friendly interaction to improve the accuracy and efficiency of data entry.

[0069] For HLA data extraction and integration, a Python script is called via VBA to extract key information (such as the genotyping results of six loci, HLA-A / B / C / DRB1 / DQB1 / DPB1) from HLA typing reports from different testing institutions. The extracted HLA data is automatically integrated into the COA template. An error self-checking program is also included; if an error occurs during the insertion of HLA text data, it will redirect to a screenshot of the HLA data section in the inserted typing report.

[0070] In the process of automated calculation and statistical analysis, Excel's in-cell formula function can be used to automate calculations and statistical analyses, including calculating indicators such as total cell count, average viability, and relative standard deviation. Simultaneously, combined with conditional formatting or functions such as IF, Excel can automatically determine whether the tested items meet internal control standards based on the range of actual immune cell quality inspection data (for example, using the IF function to display the "pass" or "fail" result in another cell). This allows quality inspectors to quickly identify which tested items meet the standards and which require further attention or adjustment.

[0071] When generating and exporting with one click, VBA integrates all the above steps to generate a complete COA for immune cells with one click; it also provides an export function to save the generated COA as a PDF or Excel file for easy archiving and printing.

[0072] Furthermore, common errors that may occur during the quality inspection report generation process are automatically handled by embedding an error handling mechanism in the VBA code. This mechanism provides prompts and logs error information when exceptions are encountered, allowing users to track key operations and problems during program execution via dialog boxes.

[0073] In the Python section, the code corresponding to each data item can be packaged into an EXE file. For example, scripts for merging PDF files and converting image formats can be packaged into executable files in EXE format. Performing the above operations does not require setting up a Python runtime environment.

[0074] When performing data scraping and processing, Python programs can be used to automatically scrape relevant data from counting results workbooks and streaming data workbooks, and perform necessary cleaning and formatting.

[0075] When manipulating data source files, you can use the operating system and Python standard library to manage files and directories, such as creating folders, checking if files exist, and searching for files with specific patterns.

[0076] When interacting with VBA, you can communicate with Excel VBA through command-line parameters or file read / write operations to receive input and return processing results.

[0077] PDF processing can use target libraries to merge PDF files generated by flow cytometry and extract pages from PDFs and save them as PNG images.

[0078] Flow cytometry images can be processed using Python scripts to convert the generated PNG format images for use in Excel VBA, where they can be cropped to the appropriate size to ensure they meet the format requirements of the COA report.

[0079] HLA data extraction can utilize Excel VBA combined with Python's image processing capabilities to extract the required information from HLA typing reports of different formats.

[0080] File interaction can be achieved through Python scripts and Excel VBA, allowing processed data to be passed to the COA template of immune cells for subsequent operations.

[0081] One challenge in the interaction between Excel VBA and Python is the complexity of PDF processing. PDF files from different sources may have different formats and encoding methods, leading to compatibility issues during processing. This example uses a library capable of handling PDF files from various sources and incorporates error handling mechanisms to address incompatibility issues.

[0082] The second challenge is the interaction between VBA and Python. Data exchange between Excel VBA and Python requires a reliable and efficient method. Specifically, simple data can be passed via command-line arguments, while for large amounts of data or complex structures, file read / write operations should be considered.

[0083] The third challenge is user-friendliness, requiring the program to be easy to use and understand, especially for non-technical users. This example features an intuitive user interface and provides a user guide that is easy to learn.

[0084] By combining the powerful features of Excel VBA and Python, an efficient, reliable, and user-friendly automated office program for immune cell COA has been developed, which greatly improves the work efficiency of biomedical research and clinical trials.

[0085] Specifically, the detailed operation steps of the automated office program for immune cell COA based on Excel VBA and Python are as follows: Figure 3 As shown.

[0086] 1. Runtime environment ready: Set up the runtime environment and ensure that all necessary software and libraries are installed and configured, including the Excel VBA environment and the Python environment.

[0087] (1) The computer's operating system must be a specified version.

[0088] (2) First, create a new folder named "Mianyi" in the root directory of the C drive of your computer, and then create a new folder named "APP" in the "Mianyi" folder.

[0089] (3) Install Excel and PDF editing software into the path folder "C:\Mianyi\APP"; put the files "!Single Stream to PNG.exe" and "!Stream Merge to PNG.exe" into the path folder "C:\Mianyi\APP" (the files "!Single Stream to PNG.exe" and "!Stream Merge to PNG.exe" are both generated by Python scripts).

[0090] (4) Put the flow cytometry file, HLA file, counting file and COA template corresponding to the sample to be generated into any folder, and pay attention to the naming rules of each file.

[0091] 2. Calling Python programs, such as Figure 4 As shown: Calling a Python script from Excel VBA to start an automated processing flow.

[0092] (1) The process of streaming merging and processing can be found in the following reference. Figure 5 in, Figure 5 Multiple flow cytometry files were displayed. Figure 6 This shows the integrated flow cytometry plots from multiple flow cytometry files.

[0093] The Python program "!Flow Cytometry Merge to PNG.exe" automatically merges PDF files (flow cytometry-A, flow cytometry-B, flow cytometry-C, and flow cytometry-D files) of flow cytometry results with a single click. This does not require the installation of any PDF software and will not cause errors even when multiple folders with different batch numbers exist. It is applicable to Leukopak, PBMC, and pre-screening immunotype products.

[0094] (2) PDF to PNG: By calling the Python program "!StreamingMergetoPNG.exe", the merged flow cytometry PDF file is converted into multiple PNG image files. Previously, when generating COA (Catalogue of Images), the flow cytometry images were usually scaled to 75% or 90% of their original size, resulting in blurry image quality. After optimization, the image quality is clear, and there are no jagged edges even after being enlarged 4 times. Achieving PDF to PNG conversion does not require any PDF software or screenshot software.

[0095] 3. Capture and insert flow cytometry images (results as shown) Figure 6 ): From data source ( Figure 5 The flow cytometry plots are captured from multiple files (as shown) and inserted into the specified location in the COA report.

[0096] (1) Flow cytometry A-plot cropping (Leukocyte subsets): Leukocyte (CD45+), T cells (CD3+), B cells (CD19+), monocytes (CD14+), NKT-like cells (CD3-CD56+) and NK cells (CD3+CD56+).

[0097] (2) Flow cytometry B-plot cropping (Lymphocyte subsets): helper T lymphocytes (CD4+CD8-), cytotoxic T lymphocytes (CD4-CD8+), Tnaive cells (CCR7+CD45RA+), Tcm cells (CCR7+CD45RA-), Tem cells (CCR7-CD45RA-), TemRA cells (CCR7-CD45RA+), Tnaive cells (CCR7+CD45RA+), Tcm cells (CCR7+CD45RA-), Tem cells (CCR7-CD45RA-), and TemRA cells (TemRA cells).

[0098] (3) Flow cytometry C-plot cropping (Treg subset): TemRA cells (CCR7-CD45RA+).

[0099] (4) Flow cytometry D-plot cropping (Erythrocyte subsets): red-white ratio (CD235+ / CD45+).

[0100] 4. Automatically fill in header information: Automatically fill in necessary information in the header of the report, such as report number, batch number, etc. (See reference below.) Figure 7 The header shown.

[0101] (1) Set the header of the COA template: "Report Number" is set to the year + month + serial number of the COA report, "Packaging Number (Specification)" is set to the product item number, and "Batch Number" is set to the batch number of the product.

[0102] (2) Increment or decrement of report number: Click the gray control to decrease the suffix version number; click the red control to increase the suffix version number.

[0103] 5. Extracting HLA Information: Extract key MHC locus information from the HLA high-resolution genotyping report. (See reference...) Figure 8 .

[0104] (1) Parse HLA report: Divide the captured HLA information into two types: First, normal (in the form of numbers followed by ":", such as "01:02,29:02"); Second, abnormal (not in the form of numbers followed by ":", such as garbled text.

[0105] ① This is normal - Insert HLA text information: Insert the captured HLA information as text into the specified cell of the COA template.

[0106] ② Abnormal - Insert HLA area image: Insert a screenshot of the HLA information area into the specified position of the COA template.

[0107] 6. Launch the Donor information entry form, such as... Figure 9 As shown: The DonorInformation interactive form will open automatically, allowing you to enter the Donor's age, gender, nationality, smoking and drinking history, blood type, single-donor collection date, and COA issuance date using button controls.

[0108] The information input controls in the information entry form may include the following controls:

[0109] (1) Age input control: Age input is achieved through a series of radio buttons (OptionButton18 to OptionButton45). Users can select the appropriate age according to the actual situation.

[0110] (2) Gender Input Controls: Gender is entered using two radio buttons (OptionButton1 and OptionButton2), where OptionButton1 represents "Male" and OptionButton2 represents "Female". Statistics show that over 95% of those using the immune cell apheresis device are male. If no selection is made, the default gender is male.

[0111] (3) Nationality input control: The nationality input is implemented through ListBox1. Users can select the corresponding nationality from the drop-down list; according to statistics, more than 90% of the nationalities of immune cell collection are Chinese. If no selection is made, the default is China.

[0112] (4) Smoking and drinking history input control: Two sets of radio buttons (OptionButton9 to OptionButton12) are used to input smoking and drinking history respectively. OptionButton9 and OptionButton11 represent "Yes" and OptionButton10 and OptionButton12 represent "No".

[0113] (5) Blood type input control: Blood type input is achieved through radio buttons in the Frame1 control group. Users can select the corresponding blood type according to the actual situation. For example, four blood type radio buttons are designed: A, B, O and AB.

[0114] (6) Crowd input control: The crowd input is achieved through the radio buttons in the Frame2 control group. Users can select the appropriate crowd according to the actual situation.

[0115] (7) Single-date input control: The single-date input is implemented through ComboBox2. Users can select a date from the drop-down list. If no date is selected, the default date is the day the COA is issued.

[0116] (8) COA output date input control: The COA output date input is implemented through ComboBox3. Users can select a date from the drop-down list. If no date is selected, the default date is the day the COA is output.

[0117] 7. Launch the liveness density input form, such as... Figure 10As shown: The "Cell Viability and Density" interactive form automatically opens, allowing users to input data such as cell viability, cell density, and product volume by clicking button controls. This form provides a series of controls to facilitate data entry and calculation. The entire data entry form is designed to provide a simple and intuitive user interface, enabling users to easily enter data and view calculation results in real time. Furthermore, the use of VBA code ensures data accuracy and consistency, improving work efficiency.

[0118] The viability density input form includes the following controls:

[0119] (1) Cell viability input control: A drop-down menu is designed so that users can quickly enter the viability of the immune cell product by selecting an option from the drop-down list. This method can reduce user input errors and improve the accuracy and efficiency of data entry.

[0120] (2) Cell Density Input Control: Users can input specific cell density values ​​through this control. The control may include a text box or a numeric input box to facilitate the input of corresponding density data. Simultaneously, the program will automatically perform relevant calculations and updates based on the user's input data.

[0121] (3) Immune Cell Analysis Product Volume Input Control: Users can input the specific value of the product volume using this control. Similar to the cell density input control, it may include a text box or numeric input box to receive user input. After the data is entered, the program will perform corresponding calculations to obtain relevant indicators such as viability density.

[0122] 8. Activate the aseptic dialog box, such as... Figure 11 As shown: After the integration of immune cell analysis data is completed, a sterility confirmation pop-up window can be automatically displayed, allowing selection based on the actual completion status of the sterility and mycoplasma test reports.

[0123] The aseptic dialog box can specifically report the following:

[0124] (1) Sterility report has been issued: The system will automatically edit and print the sterility report. Usually, the cycle from the start of quality inspection of immune cell analysis products to the issuance of the sterility test report is 7 days. Therefore, the date of the sterility report will be automatically set to one week after the start date of quality inspection.

[0125] (2) No sterility report issued: For fresh immune cells, collection, quality inspection, and shipment are usually completed on the same day. The system will first display other quality inspection information for the immune cell analysis product. Given that the customer needs to arrange preliminary experiments, only a COA report containing the incomplete sterile mycoplasma testing portion is generated. (The customer will conduct preliminary experiments after receiving the immune product, which gives us time to complete the sterile mycoplasma testing. Therefore, at the time of shipment, only a COA report containing the incomplete sterile mycoplasma testing portion is generated; the complete report will be added after subsequent testing is completed. This ensures both timely delivery of the immune cell analysis product and the integrity and accuracy of the testing work.)

[0126] Figure 12 This is a schematic diagram of an immune cell COA generation device provided in an embodiment of the present invention. This embodiment is applicable to scenarios involving immune cell COA generation, particularly when integrating diverse data content in reports. The immune cell COA generation device can be implemented in software and / or hardware and integrated into a computer terminal device with application development capabilities.

[0127] like Figure 12 As shown, the immune cell COA generation device includes: a cell analysis and identification information acquisition module 310, a cell quality inspection report initialization module 320, and a cell quality inspection report content input module 330.

[0128] The cell analysis identification information acquisition module 310 is used to acquire the immune cell analysis batch number and cell source object identification information corresponding to the immune cell COA to be generated; the cell quality inspection report initialization module 320 is used to initialize the report template of the immune cell COA to be generated according to the immune cell analysis batch number and the identification information to obtain the initial immune cell COA; the cell quality inspection report content input module 330 is used to automatically acquire and display the data content associated with the data input trigger operation in response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, to obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0129] The technical solution of this embodiment obtains the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the immune cell COA to be generated; based on the immune cell analysis batch number and identification information, the report template of the immune cell COA to be generated is initialized to obtain the initial immune cell COA; in response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation is input and displayed to obtain the target immune cell COA corresponding to the immune cell COA to be generated. The technical solution of this embodiment solves the problems of low efficiency and easy error in manual editing of immune cell COA, simplifies the process of immune cell report editing and generation, assists users in efficiently completing the immune cell report editing and generation process, and improves the efficiency and accuracy of report generation.

[0130] In one optional implementation, the cell quality inspection report content input module 330 is specifically used for:

[0131] In response to the flow cytometry cell graph input trigger operation of the interactive interface where the initial immune cell COA is located, the corresponding flow cytometry cell file is obtained from the data storage path associated with the immune cell COA to be generated;

[0132] The target flow cytometry plot is formatted and cropped in the flow cytometry file;

[0133] The target flow cytometry graph, after formatting and cropping, is imported and displayed at the data display position corresponding to the initial immune cell COA.

[0134] In one optional implementation, the cell quality inspection report content input module 330 can also be specifically used for:

[0135] In response to the human leukocyte antigen reporter data input trigger operation of the interactive interface where the initial immune cell COA is located, the corresponding HLA reporter file is obtained from the data storage path associated with the immune cell COA to be generated;

[0136] Extract the target key information from the human leukocyte antigen report file, and import and display the target key information at the data display position corresponding to the initial immune cell COA.

[0137] In one optional implementation, the cell quality inspection report content input module 330 may also be specifically used for:

[0138] The corresponding data entry interface is displayed in response to the data entry trigger operation of the interactive interface where the initial immune cell COA is located.

[0139] In response to the data input operation command of the data input interface, the target input data is obtained and displayed in the corresponding data display position;

[0140] The data entry interface can be the object information entry window for the cell source object, the sterility report confirmation entry window, or the preset immune cell analysis attribute entry window.

[0141] In an optional implementation, the immune cell COA generation device further includes a report export module for:

[0142] After obtaining the target immune cell COA, in response to the report export trigger command, the target immune cell COA is exported in the target format.

[0143] In one optional implementation, the cell quality inspection report initialization module 320 is specifically used for:

[0144] The batch number of the immune cell analysis and the cell source object identification information are input into the preset information filling position of the preset immune cell COA template to obtain the initial immune cell COA.

[0145] In an optional embodiment, the immune cell COA generation device further includes a data computing module for:

[0146] Before obtaining the COA of the target immune cells, in response to the statistical analysis trigger operation of the preset data items in the data content, the preset data items are statistically analyzed, and the statistical analysis results are displayed in the corresponding data display position.

[0147] The immune cell COA generation device provided in the embodiments of the present invention can execute the immune cell COA generation method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of executing the method.

[0148] Figure 13 This is a schematic diagram of the structure of a computer device provided in an embodiment of the present invention. Figure 13 A block diagram of an exemplary computer device 12 suitable for implementing embodiments of the present invention is shown. Figure 13 The computer device 12 shown is merely an example and should not be construed as limiting the functionality or scope of the embodiments of the present invention. The computer device 12 can be any terminal device with computing capabilities, such as intelligent controllers and servers, mobile phones, and other terminal devices.

[0149] like Figure 13As shown, the computer device 12 is represented in the form of a general-purpose computing device. The components of the computer device 12 may include, but are not limited to: one or more processors or processing units 16, system memory 28, and bus 18 connecting different system components (including system memory 28 and processing unit 16).

[0150] Bus 18 represents one or more of several bus architectures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor, or a local bus using any of the various bus architectures. For example, these architectures include, but are not limited to, the Industry Standard Architecture (ISA) bus, the Micro Channel Architecture (MAC) bus, the Enhanced ISA bus, the Video Electronics Standards Association (VESA) local bus, and the Peripheral Component Interconnect (PCI) bus.

[0151] Computer device 12 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by computer device 12, including volatile and non-volatile media, removable and non-removable media.

[0152] System memory 28 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 30 and / or cache memory 32. Computer device 12 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, storage system 34 may be used to read and write non-removable, non-volatile magnetic media (…). Figure 13 Not shown; usually referred to as a "hard drive"). Although Figure 13 As not shown, disk drives for reading and writing to removable non-volatile disks (e.g., "floppy disks") and optical disc drives for reading and writing to removable non-volatile optical discs (e.g., CD-ROMs, DVD-ROMs, or other optical media) may be provided. In these cases, each drive may be connected to bus 18 via one or more data media interfaces. System memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to perform the functions of the embodiments of the present invention.

[0153] A program / utility 40 having a set (at least one) of program modules 42 may be stored, for example, in system memory 28. Such program modules 42 include, but are not limited to, an operating system, one or more application programs, other program modules, and program data. Each or some combination of these examples may include an implementation of a network environment. Program modules 42 typically perform the functions and / or methods described in the embodiments of the present invention.

[0154] Computer device 12 can also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), and with one or more devices that enable a user to interact with the computer device 12, and / or with any device that enables the computer device 12 to communicate with one or more other computing devices (e.g., network card, modem, etc.). This communication can be performed via input / output (I / O) interface 22. Furthermore, computer device 12 can also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN), and / or public networks, such as the Internet) via network adapter 20. As shown, network adapter 20 communicates with other modules of computer device 12 via bus 18. It should be understood that, although... Figure 13 As not shown, other hardware and / or software modules may be used in conjunction with computer device 12, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, R AID systems, tape drives, and data backup storage systems.

[0155] Processing unit 16 executes various functional applications and data processing by running programs stored in system memory 28, such as implementing the immune cell COA generation method provided in this embodiment, which includes:

[0156] Obtain the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated;

[0157] Based on the immune cell analysis batch number and the identification information, the report template of the immune cell COA to be generated is initialized to obtain the initial immune cell COA;

[0158] In response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation is automatically acquired and displayed to obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0159] This invention also provides a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the immune cell COA generation method as provided in any embodiment of this invention, the method comprising:

[0160] Obtain the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated;

[0161] Based on the immune cell analysis batch number and the identification information, the report template of the immune cell COA to be generated is initialized to obtain the initial immune cell COA;

[0162] In response to the data input trigger operation of the interactive interface where the initial immune cell COA is located, the data content associated with the data input trigger operation is automatically acquired and displayed to obtain the target immune cell COA corresponding to the immune cell COA to be generated.

[0163] The computer storage medium of this invention can be any combination of one or more computer-readable media. A computer-readable medium can be a computer-readable signal medium or a computer-readable storage medium. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination thereof. More specific examples of computer-readable storage media (a non-exhaustive list) include: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In this document, a computer-readable storage medium can be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device.

[0164] Computer-readable signal media may include data signals propagated in baseband or as part of a carrier wave, carrying computer-readable program code. Such propagated data signals may take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. Computer-readable signal media may also be any computer-readable medium other than computer-readable storage media, capable of sending, propagating, or transmitting programs for use by or in connection with an instruction execution system, apparatus, or device.

[0165] Program code contained on a computer-readable medium may be transmitted using any suitable medium, including but not limited to: wireless, wire, optical fiber, RF, etc., or any suitable combination thereof.

[0166] Computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof, including object-oriented programming languages ​​such as Java, Smalltalk, Python, and C++, as well as conventional procedural programming languages ​​such as C or similar languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network, including a local area network (LAN) or a wide area network (WAN), or it can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0167] This invention also provides a computer program product, including a computer program that, when executed by a processor, implements the immune cell COA generation method as provided in any embodiment of this application.

[0168] In implementing the computer program product, computer program code for performing the operations of this invention can be written in one or more programming languages ​​or a combination thereof. Programming languages ​​include object-oriented programming languages ​​such as Java, Smalltalk, Python, and C++, as well as conventional procedural programming languages ​​such as C or similar languages. The program code can be executed entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving remote computers, the remote computer can be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or can be connected to an external computer (e.g., via the Internet using an Internet service provider).

[0169] Those skilled in the art will understand that the modules or steps of the present invention described above can be implemented using general-purpose computing devices. They can be centralized on a single computing device or distributed across a network of multiple computing devices. Optionally, they can be implemented using computer-executable program code, thereby allowing them to be stored in a storage device for execution by a computing device, or they can be fabricated as separate integrated circuit modules, or multiple modules or steps can be fabricated as a single integrated circuit module. Thus, the present invention is not limited to any particular combination of hardware and software.

[0170] Note that the above description is merely a preferred embodiment of the present invention and the technical principles employed. Those skilled in the art will understand that the present invention is not limited to the specific embodiments described herein, and various obvious changes, readjustments, and substitutions can be made without departing from the scope of protection of the present invention. Therefore, although the present invention has been described in detail through the above embodiments, the present invention is not limited to the above embodiments, and may include many other equivalent embodiments without departing from the concept of the present invention, the scope of which is determined by the scope of the appended claims.

Claims

1. A method for generating COA in immune cells, characterized in that, include: Obtain the batch number of the immune cell analysis and the identification information of the cell source object corresponding to the COA of the immune cells to be generated. The batch number of the immune cell analysis and the identification information of the cell source object are used to indicate multiple data source files of different formats associated with the COA of the immune cells to be generated. The multiple data source files of different formats include at least flow cytometry files, human leukocyte antigen report files, cell count files and sterility test report files. Based on the immune cell analysis batch number and the identification information, the report template of the immune cell COA to be generated is initialized to obtain the initial immune cell COA; In response to the data input trigger operation on the interactive interface where the initial immune cell COA is located, the system automatically retrieves and displays the data content associated with the data input trigger operation through the interaction between Excel VBA and Python, thereby obtaining the target immune cell COA corresponding to the immune cell COA to be generated. This includes responding to the flow cytometry plot input trigger operation of the interactive interface where the initial immune cell COA is located, obtaining multiple corresponding flow cytometry files from the data storage path associated with the immune cell COA to be generated, merging the multiple flow cytometry files into PDF by calling a format conversion program executed by Python, converting the merged flow cytometry file from PDF format to PNG format for Excel VBA to standardize and crop the target flow cytometry plot, and importing and displaying the standardized and cropped target flow cytometry plot at the data display position corresponding to the initial immune cell COA.

2. The method according to claim 1, characterized in that, The data input trigger operation in response to the interactive interface where the initial immune cell COA is located automatically acquires and displays the data content associated with the data input trigger operation through the interaction between Excel VBA and Python, including: In response to the human leukocyte antigen report data input trigger operation of the interactive interface where the initial immune cell COA is located, the corresponding human leukocyte antigen report file is obtained from the data storage path associated with the immune cell COA to be generated; The human leukocyte antigen report file was parsed using Python to extract key target information, which included HLA-A, HLA-B, HLA-C, HLA-DRB1, HLA-DQB1 and HLA-DPB1 genotyping results. The target key information is imported into the data display position corresponding to the initial immune cell COA using Excel VBA in text or screenshot form. When the extracted target key information is normal, it is imported into the data display position corresponding to the initial immune cell COA in text form. When the extracted target key information is garbled, it is automatically imported into the data display position corresponding to the initial immune cell COA in screenshot form.

3. The method according to claim 1, characterized in that, The data input trigger operation in response to the interactive interface where the initial immune cell COA is located automatically acquires and displays the data content associated with the data input trigger operation through the interaction between Excel VBA and Python, including: In response to the data entry trigger operation of the interactive interface where the initial immune cell COA is located, the corresponding data entry interface is displayed; In response to the data input operation command of the data input interface, the target input data is obtained and displayed in the corresponding data display position; The data entry interface can be the object information entry window for the cell source object, the sterility report confirmation entry window, or the preset immune cell analysis attribute entry window.

4. The method according to claim 1, characterized in that, The method further includes: After obtaining the target immune cell COA, in response to the report export trigger command, the target immune cell COA is exported in the target format.

5. The method according to any one of claims 1-4, characterized in that, The step of initializing the report template for the immune cell COA to be generated based on the immune cell analysis batch number and the cell source object identification information to obtain the initial immune cell COA includes: The batch number of the immune cell analysis and the cell source object identification information are input into the preset information filling position of the preset immune cell COA template to obtain the initial immune cell COA.

6. The method according to any one of claims 1-4, characterized in that, Before obtaining the COA of the target immune cells, the method further includes: In response to a statistical analysis trigger operation on a preset data item in the data content, the preset data item is statistically analyzed, and the statistical analysis results are displayed in the corresponding data display position.

7. An immune cell COA generation device, characterized in that, include: The cell analysis identification information acquisition module is used to acquire the immune cell analysis batch number and cell source object identification information corresponding to the COA of the immune cells to be generated, wherein the immune cell analysis batch number and the cell source object identification information are used to indicate multiple data source files of different formats associated with the COA of the immune cells to be generated; The cell quality inspection report initialization module is used to initialize the report template of the immune cell COA to be generated based on the immune cell analysis batch number and the identification information, so as to obtain the initial immune cell COA; The cell quality inspection report content input module is used to respond to the data input trigger operation of the interactive interface where the initial immune cell COA is located. Through the interaction of Excel VBA and Python, it automatically obtains and displays the data content associated with the data input trigger operation to obtain the target immune cell COA corresponding to the immune cell COA to be generated. This includes responding to the flow cytometry plot input trigger operation of the interactive interface where the initial immune cell COA is located, obtaining multiple corresponding flow cytometry files from the data storage path associated with the immune cell COA to be generated, merging the multiple flow cytometry files into PDF by calling a format conversion program executed by Python, converting the merged flow cytometry file from PDF format to PNG format for Excel VBA to standardize and crop the target flow cytometry plot, and importing and displaying the standardized and cropped target flow cytometry plot at the data display position corresponding to the initial immune cell COA.

8. A computer device, characterized in that, The computer device includes: One or more processors; Memory, used to store one or more programs; When the one or more programs are executed by the one or more processors, the one or more processors implement the immune cell COA generation method as described in any one of claims 1-6.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When executed by a processor, the program implements the method for generating COA of immune cells as described in any one of claims 1-6.

10. A computer program product, comprising a computer program, characterized in that, When the computer program is executed by a processor, it implements the method for generating COA of immune cells as described in any one of claims 1-6.

Images