Methods and systems for processing products listed in a landscaping project

A computer algorithm comprising program code stored in a non-transitory computer-readable medium, the program code are executable by at least a processor in a server for processing products listed in a landscaping project, the computer algorithm, comprising:

• a collector code section, executable to perform:
• collecting and capturing from a client device, open format raw data of a material list in a received file;
• and
• translating the captured open format raw data of the material list into text format data;
• a builder code section, executable to perform:
• mapping the text format data to a master product database to generate a matched material list with associated procurement information for each item on the matched material list;
• a smart spreadsheet code section, executable to perform:
• generating a smart spreadsheet, comprising an array of smart cells, wherein the itemized plant names or landscaping supplies are displayed as contents in a designated column or row of the smart cells, and the associated procurement information is displayed in respective smart cells arranged in row or column corresponding to each respective plant name or landscape supply, wherein at least one smart cell in the array that corresponds to a particular itemized plant name or landscaping supply is configured to display a match indicator that indicates a degree of matching of its content to a target value;
• an interactive tool code section, executable to perform:
• when a degree of matching of the content indicates less than the target value, adjusting the match indicator corresponding to the at least one smart cell to a desired range value for another search of a substitute in the master product database;
• forwarding to the client device, the smart spreadsheet for user's selections or modifications to the contents in the smart cells according to user's preference;
• in response to a user's preference input from the user device to modify the content of at least one smart cell, updating the spread sheet;
• and
• displaying on the user device, a total cost estimate for bidding or for procurement of at least a portion of the products for the landscaping project.