# All-PICKUPS Collector module (Google Sheets)

The spreadsheet module in the Moving Boards USA web application is a tool that allows users to view and filter available movers and brokers. It is an automated and flexible automotive moving management system. Moving Boards USA is a suite of solutions for moving companies and movers in the USA. An easy way to organize all your brokers and connections with other companies in one application. The application provides flexible access to the automation of Moving Estimates from brokers that come to the company's email and are automatically entered into the system according to certain criteria (moving time, moving window, size, price, etc.). Based on this data, a calendar event is automatically created and synchronized with Google Calendar. To the entered estimate with the filled in data, you can add separate contracts, the person responsible for this work, and other additional parameters, and information about this work (Job). A unique combination of Truck Post (information about the location of the vehicle on the road), contracts and moving companies with operators, notifications to the channel and messengers. This allows you to create an end-to-end workspace with all the capabilities of the moving and transportation process.

The module contains various columns of information about each job, such as job number, date of move, departure and destination cities, postal codes, estimated weight, mileage, and price for transportation.

The All-PICKUPS Collector module is a description of the boards (sites with open data) that it collects and stores them in the database. The database is duplicated in parallel to the cloud storage on Google Sheets. It works automatically every 5-10 minutes, or by manual call from the Telegram channel. It is organized in the form of a grid with horizontal rows with numbers 1,2,3...5000, etc. and vertical columns with names taken from open data sites:

1. **Job No.:** This column displays the unique job number assigned to each job posting.
2. **Type:** This column displays the type of move associated with the job posting, such as residential or commercial.
3. **Move Date:** This column displays the date of the move for each job posting.
4. **Win-dw:** This column displays the window date for each job posting, which refers to the range of dates during which the move can take place.
5. **Time:** This column displays the time of day for the move.
6. **1st Avbl Delivery:** This column displays the first available delivery date for the job.
7. **Moving From(City):** This column displays the city from which the job will be moved.
8. **Fm:** This column displays the state abbreviation for the city from which the job will be moved.
9. **From (ZIP):** This column displays the ZIP code for the pickup location.
10. **Moving To(City):** This column displays the city to which the job will be moved.
11. **To**: This column displays the state abbreviation for the city to which the job will be moved.
12. **To (ZIP):** This column displays the ZIP code for the delivery location.
13. **CF**: This column displays the cubic feet required for the move.
14. **Lbs**: This column displays the weight of the items being moved.
15. **Miles**: This column displays the distance between the pickup and delivery locations.
16. **Estimate**: This column displays the estimated cost of the move.
17. **Url**: This column displays the URL of the job posting.
18. **Price Per Transportation:** This column displays the price per transportation.
19. **Profit:** This column displays the profit earned from the job.
20. **Pay for Cubs:** This column displays the payment for cubic feet.
21. **Price /cub:** This column displays the price per cubic feet.
22. **Trip**: This column displays the trip number associated with the job posting.
23. **CHECK**: This column is used to select multiple job postings for editing or deletion.
24. **Book TXT:** This column is used to book the job posting via text message.
25. **Book email:** This column is used to book the job posting via email.
26. **Add to Calendar:** This column is used to add the job posting to a calendar.

Rows and columns intersect to form cells that contain data that was taken from the open data of the All-PICKUPS URL List Collector module. As a rule, columns and rows are filtered, which allows you to change their display according to the specified conditions of the User Filter. Such a filtering system allows users to easily refer to a specific job in the table by specifying its number, e.g. Job No, or other string parameters according to the filtering conditions.

To use the spreadsheet module, users can first scroll through the list of jobs to find the one they are interested in. Alternatively, they can use the filtering and search functions to narrow the list to jobs that meet their specific criteria. The rows and columns intersect to form cells that contain data that was pulled from the open data of the All-PICKUPS URL List Collector module. As a rule, columns and rows are filtered, which allows you to change their display according to the specified conditions of the User Filter. Such a filtering system allows users to easily refer to a specific job in the table by specifying its number, e.g. Job No, or other string parameters according to the filtering conditions.

To filter the data, the user can click on the "Get Data" button at the top of the module and select the necessary filters. For example, they can filter jobs by move date, departure or destination city, estimated weight, or price. After selecting the necessary filters, they can click the "Filter" button to see only those that meet these criteria.

To search for a specific job, the user can enter a keyword or phrase in the search field at the top of the module. The module will then display only those jobs that contain this keyword or phrase in any of the columns.

Once a user has found a job they are interested in, they can click on the job number to view more information about it and check if it is still available for booking. They can also add the task to their calendar, send a booking notification via SMS or email, or mark the task as completed.
