Patents by Inventor Xiao LYU

Xiao LYU has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).

  • Publication number: 20240054284
    Abstract: Implementations of the present disclosure provide a solution for spreadsheet table transformation. In this solution, one or more header areas and a data area of a spreadsheet table are detected. A hierarchical structure of each of the header areas is determined by analysis of cell merging and/or indents in the header area, and/or a function relationship between data items in corresponding cells of the data area. The spreadsheet table can be transformed to a relational table based on recognition of the hierarchical structure of the header area. In this way, by facilitating understanding of header structures based on the header hierarchy, it is possible to achieve automated transformation from spreadsheet tables to relational tables.
    Type: Application
    Filed: October 23, 2023
    Publication date: February 15, 2024
    Inventors: Haoyu Dong, Shi Han, Dongmei Zhang, Jennifer Michelstein Halberstam, Xiao Lyu
  • Patent number: 11836445
    Abstract: A solution for spreadsheet table transformation is provided. In this solution, one or more header areas and a data area of a spreadsheet table are detected. A hierarchical structure of each of the header areas is determined by analysis of cell merging and/or indents in the header area, and/or a function relationship between data items in corresponding cells of the data area. The spreadsheet table can be transformed to a relational table based on recognition of the hierarchical structure of the header area. In this way, by facilitating understanding of header structures based on the header hierarchy, it is possible to achieve automated transformation from spreadsheet tables to relational tables.
    Type: Grant
    Filed: August 8, 2019
    Date of Patent: December 5, 2023
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Haoyu Dong, Shi Han, Dongmei Zhang, Jennifer M. Halberstam, Xiao Lyu
  • Publication number: 20230150847
    Abstract: A pressure balancing system for two sides of an electrodialysis reversal (EDR) film stack includes two source water inlets, an EDR film stack, four pressure sensors, a variable speed pump, a one-way valve, a clean water outlet, a waste water outlet, and a control system module. With the four pressure sensors detecting water pressures at four ports on two sides of the EDR film stack and with the variable speed pump and the control system module adjusting water pressure at the waste water outlet, water pressure at the clean water outlet is equivalent to the water pressure at the waste water outlet. Accordingly, the water pressures on the two sides of the EDR film stack can be balanced, and service life and water purification efficiency of the EDR film stack can be improved.
    Type: Application
    Filed: December 2, 2021
    Publication date: May 18, 2023
    Inventors: ALLEN DING, Xiao-Lyu HAN, EDISON FAN
  • Publication number: 20230145861
    Abstract: A water conditioning system of an electrodialysis reversal (EDR) water purifier includes a first source water inlet, a second source water inlet, an EDR film stack, a first conductive probe, a second conductive probe, a third conductive probe, a fourth conductive probe, a variable speed pump, a one-way valve, a clean water outlet, a waste water outlet, an electrode A, an electrode B, and a control system module. With the four conductive probes detecting conductivity of water flowing through four ports on two sides of the EDR film stack and by sending detected data to the control system module, the control system module adjusts voltages of the electrode A and electrode B accordingly to instantly increase or decrease removal efficiency of the EDR film stack. Thus, the conductivity of the discharged clean water and the quality of the clean water can be stabilized.
    Type: Application
    Filed: November 30, 2021
    Publication date: May 11, 2023
    Inventors: ALLEN DING, XIAO-LYU HAN, EDISON FAN
  • Publication number: 20220366129
    Abstract: A solution for spreadsheet table transformation is provided. In this solution, one or more header areas and a data area of a spreadsheet table are detected. A hierarchical structure of each of the header areas is determined by analysis of cell merging and/or indents in the header area, and/or a function relationship between data items in corresponding cells of the data area. The spreadsheet table can be transformed to a relational table based on recognition of the hierarchical structure of the header area. In this way, by facilitating understanding of header structures based on the header hierarchy, it is possible to achieve automated transformation from spreadsheet tables to relational tables.
    Type: Application
    Filed: August 8, 2019
    Publication date: November 17, 2022
    Inventors: Haoyu DONG, Shi HAN, Dongmei ZHANG, Jennifer M. HALBERSTAM, Xiao LYU