{"id":3301,"date":"2024-11-26T21:07:55","date_gmt":"2024-11-26T21:07:55","guid":{"rendered":"https:\/\/tealspark.pk\/?page_id=3301"},"modified":"2024-11-26T23:06:43","modified_gmt":"2024-11-26T23:06:43","slug":"projects","status":"publish","type":"page","link":"https:\/\/tealspark.pk\/index.php\/projects\/","title":{"rendered":"Projects"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\r\n
\r\n
\r\n <\/div>\r\n <\/div>\r\n
\r\n

Web Scraping Tool for Automated Price Updates<\/h4>\r\n
We developed a web scraping tool that extracts product prices from dynamic websites and updates them in Google Sheets. It runs automatically at set intervals, ensuring real-time price updates without manual effort..
<\/div>\r\n <\/div>\r\n <\/div>\r\n \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\r\n
\r\n
\r\n <\/div>\r\n <\/div>\r\n
\r\n

Excel to Web Form WordPress Plugin<\/h4>\r\n
We developed a powerful WordPress plugin that\u00a0 \u00a0 \u00a0transforms Excel files with complex formulas into\u00a0 \u00a0 interactive web forms. It dynamically calculates real-time scores, stores data in the WordPress dashboard, and syncs with Google Sheets for advanced analysis and report generation. <\/div>\r\n <\/div>\r\n <\/div>\r\n \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\r\n
\r\n
\r\n <\/div>\r\n <\/div>\r\n
\r\n

Order Form- Google Sheets+GMail Integration <\/h4>\r\n
We developed a system with an order form that calculates totals, including tax and discounts, generates PDFs, and sends them to both the admin and customer. It stores data in Excel for further calculations and sets shipment reminders. The system integrates with Google Apps and can run entirely within AppScript without the need for third-party tools. <\/div>\r\n <\/div>\r\n <\/div>\r\n \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\r\n
\r\n
\r\n <\/div>\r\n <\/div>\r\n
\r\n

Dropbox Integration with OAuth Authentication<\/h4>\r\n
Our team developed a Google Spreadsheet tool that connects with Google Drive via voice commands for secure access. It automates file retrieval through voice search and integrates seamlessly with Google Sheets, significantly enhancing productivity by simplifying and streamlining file management tasks. <\/div>\r\n <\/div>\r\n <\/div>\r\n \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\r\n
\r\n
\r\n <\/div>\r\n <\/div>\r\n
\r\n

Automated Data Extraction from Fillable PDFs<\/h4>\r\n
his project automates data collection from fillable PDFs, eliminating manual entry. It processes mileage and time sheet PDFs submitted by multiple users. The program compiles data into a comprehensive mileage and time sheet, enabling easy access to summarized information and serving as a foundation for a dashboard for analysis.\n <\/div>\r\n <\/div>\r\n <\/div>\r\n \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\r\n
\r\n
\r\n <\/div>\r\n <\/div>\r\n
\r\n

Control files in google sheets using Voice Command<\/h4>\r\n
We developed a Google Sheets tool that lets you open files using voice commands. After authorization, simply say the file name, and it will search and open the file from Google Drive. <\/div>\r\n <\/div>\r\n <\/div>\r\n \t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t
<\/div>\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Our Product<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t