Systems and methods for electronically generating submittal registers
A system and method for generating a submittal register for various construction projects or other items is disclosed. Among other things, the system and method include inputting the construction project specifications in a file format, such as PDF, into a web application interface to convert the same to a text file, applying an algorithm to the text file, identifying all required submittals into a spreadsheet, running a quality control check of the generated spreadsheet, applying an analysis program to the spreadsheet, generating final submittal register by the program, and delivering the final submittal register.
1. A method for generating a submittal register, comprising:
receiving a plurality of documents as first files for a construction project in a first file format, wherein the first file format for each of the plurality of documents comprises a file extension selected from a group consisting of: .ai; .bmp; .gif; .ico; .jpeg; .jpg; .png; .ps; .psd; .svg; ods; .xlr; ,xls; ,xlsx; .doc; .docx; .odt; tif; tiff; .pdf; .rft; .tex; .txt; .wks; and .wpd;
converting each of the plurality of documents to a first file converted format, and saving a second file comprising the first file converted format for each of the plurality of documents;
applying a processing program to the second file of each of the plurality of documents;
generating the submittal register as a second file format based on the applied processing program to the second file of each of the plurality of documents, the generated submittal register including a plurality of elements of information for each of the plurality of documents;
permitting access to a user to provide edits or modifications to the generated submittal register;
generating a log comprising any access to the generated submittal register or submitting of edits or modifications to the generated submittal register; and
presenting a final submittal register;
wherein the applying the processing program to the second file includes applying an algorithm to identify one or more selected from a group consisting of summary text in the second file, one or more submittal categories for submittal information in the second file, and a submittal description in the second file; and associating at least two selected from a group consisting of the submittal categories, the summary text, and the submittal description with one another; wherein at least one of the associated submittal categories, the summary text, or the submittal description is searchable.
2. The method of claim 1 , wherein the presenting the final submittal register further includes: presenting the final submittal register on a display coupled to a processing device.
3. The method of claim 1 , wherein the presenting the final submittal register further includes: producing a printed copy of the final submittal register.
4. The method of claim 1 , wherein the plurality of documents are received via a web application interface.
5. The method of claim 1 , wherein the first file converted format is a text format.
6. The method of claim 1 , wherein the second file format is a spreadsheet format.
7. The method of claim 1 , wherein the first files include image data in the first file format, the method further comprising:
identifying words and symbols in the image data; and
associating one identified word selected from the identified words with one symbol selected from the identified symbols.
8. The method of claim 1 , wherein the applying the algorithm to identify one or more selected from a group consisting of summary text in the second file, one or more submittal categories for submittal information includes applying natural language processing.
9. A system for generating a submittal register for use in organizing and associating elements of multiple disparate documents for cross-document component interactive association, the system comprising:
a server on a network;
a processor accessible via the server; and
a database accessible via the processor;
the server, processor, and database being interoperably configured to:
receive a plurality of documents as first files for a construction project in a first file format, wherein the first file format for each of the plurality of documents comprises a file extension selected from a group consisting of: .ai; .bmp; .gif; .ico; .jpeg; .jpg; .png; .ps; .psd; .svg; .ods; .xlr; xls; ,xlsx; .doc; .docx; .odt; .tif; .tiff; .pdf; .rft; .tex; .txt; .wks; and .wpd;
convert each of the plurality of documents to a first file converted format, and save a second file comprising the first file converted format for each of the plurality of documents;
apply a processing program to the second file of each of the plurality of documents;
generate the submittal register as a second file format based on the applied processing program to the second file of each of the plurality of documents, the generated submittal register including a plurality of elements of information for each of the plurality of documents;
permit access to a user to provide edits or modifications to the generated submittal register;
generate a log comprising any access to the generated submittal register or submitting of edits or modifications to the generated submittal register; and
present a final submittal register;
wherein the applying the processing program to the second file includes applying an algorithm to identify one or more selected from a group consisting of summary text in the second file, one or more submittal categories for submittal information in the second file, and a submittal description in the second file; and
associate at least two selected from a group consisting of the submittal categories, the summary text, and the submittal description with one another;
wherein at least one of the associated submittal categories, the summary text, or the submittal description is searchable.
10. The system of claim 9 , wherein the presenting the final submittal register further includes presenting the final submittal register on a display coupled to the processor.
11. The system of claim 9 , wherein the presenting the final submittal register further includes producing a printed copy of the final submittal register.
12. The system of claim 9 , wherein the plurality of documents are received by the system via a web application interface.
13. The system of claim 9 , wherein the first file converted format is a text format.
14. The system of claim 9 , wherein the second file format is a spreadsheet format.
15. The system of claim 9 , wherein the first files include image data in the first file format, the system further configured to:
Identify words and symbols in the image data; and
associate one identified word selected from the identified words with one symbol selected from the identified symbols.
16. The system of claim 9 , wherein the applying an algorithm to identify one or more selected from a group consisting of summary text in the second file, one or more submittal categories for submittal information further includes applying natural language processing.
17. A computer program product comprising a non-transitory computer usable medium having control logic stored therein to generate a submittal register for use in organizing and associating elements of multiple disparate documents for cross-document component interactive association, the control logic causing the computer to:
receive a plurality of documents as first files for a construction project in a first file format, wherein the first file format for each of the plurality of documents comprises a file extension selected from a group consisting of: .ai; .bmp; .gif; .ico; .jpeg; .jpg; .png; .ps; .psd; .svg; .ods; .xlr; ,xis; ,xlsx; .doc; .docx; .odt; .tif; .tiff; .pdf; .rft; .tex; .txt; .wks; and .wpd;
convert each of the plurality of documents to a first file converted format, and save a second file comprising the first file converted format for each of the plurality of documents;
apply a processing program to the second file of each of the plurality of documents;
generate the submittal register as a second file format based on the applied processing program to the second file of each of the plurality of documents, the generated submittal register including a plurality of elements of information for each of the plurality of documents;
permit access to a user to provide edits or modifications to the generated submittal register;
generate a log comprising any access to the generated submittal register or submitting of edits or modifications to the generated submittal register; and
present a final submittal register;
wherein the applying the processing program to the second file includes applying an algorithm to identify one or more selected from a group consisting of summary text in the second file, one or more submittal categories for submittal information in the second file, and a submittal description in the second file; and
associate at least two selected from a group consisting of the submittal categories, the summary text, and the submittal description with one another;
wherein at least one of the associated submittal categories, the summary text, or the submittal description is searchable.
18. The computer program product of claim 17 , wherein the presenting the final submittal register further includes presenting the final submittal register on a display coupled to the processor.
19. The computer program product of claim 17 , wherein the presenting the final submittal register further includes producing a printed copy of the final submittal register.
20. The computer program product of claim 17 , wherein the first files include image data in the first file format, the control logic further causing the computer to:
Identify words and symbols in the image data;
associate one identified word selected from the identified words with one respective symbol selected from the identified symbols.