Copy a structured catalog of spare parts from a website to Excel

A person is needed (logistician, customs broker, or foreign economic activity specialist) who will take on an unconventional task in Poland: to find an active customs agency that agrees to open an export declaration (EX1) for a Ukrainian individual entrepreneur. Our situation (Input data): The goods are physically located in a warehouse in Warsaw and are already fully cleared in the EU (in free circulation, import taxes have been paid by the previous logistics operator). The commercial invoice is issued by a non-resident company (Hong Kong, without a European EORI). The buyer and the final owner of the goods is a Ukrainian individual entrepreneur. The previous supplier from Hong Kong will not provide an import declaration (SAD) and will not participate in the export clearance. We already have: a commercial invoice for our individual entrepreneur, MSDS and CE certificates for all models. What exactly needs to be done by the executor: Process Polish customs agencies/brokers (or use own contacts). Find an agency that agrees to conduct export clearance under the indirect representation procedure (przedstawicielstwo pośrednie), where our Ukrainian individual entrepreneur will act as the Exporter. Arrange for the issuance of a Polish EORI number for our individual entrepreneur (if necessary) and open EX1 with only the invoice, packing list, and European status of the goods (without an import declaration from the Chinese). Possible nuances Many brokers are afraid to work without the initial import document (SAD) from the supplier and refuse immediately. It is necessary to look for higher-level agencies or brokers with experience working with non-resident warehouses who are willing to take responsibility for indirect representation. Criteria for task completion: A successful agreement with a specific Polish customs agency that has confirmed in writing its readiness to take this case under the described conditions, stated the cost, and with which the clearance process can begin.

We specialize in obtaining grants for existing companies that plan investments. We came up with the idea of creating/connecting available AI models to search for companies that are planning or are already in the process of investing and to offer them grants for this purpose (we mainly deal with grants for the purchase of machinery and equipment). The AI would search available websites and registries to find investors. Then, it would also handle the automation of mailing to these companies and would filter out companies that: - fit into the lead categories (I think, 5-6 parameters); - replied to the email and are interested in the grant; Of course, additional suggestions are welcome; I am also considering Voice Calling and SMS sending. I would like to emphasize that I am not only interested in finding LARGE or very LARGE companies, but also smaller ones, for example, employing 8-50 people. And not just large cities, but also smaller towns. Sample target for testing: SUBCARPATHIAN For micro, small, and medium-sized enterprises (SMEs) and large enterprises from the Subcarpathian Voivodeship that belong to the security and defense industry. An enterprise from the security and defense industry is understood as an enterprise that: develops or manufactures products, technologies, or systems intended for military applications, related to national security, critical infrastructure protection, or citizen safety or provides services supporting security and defense systems (e.g., in the field of cybersecurity) or conducts research and development in the area of military technologies and security systems and which achieves a significant share of revenue from the sale of products, technologies, systems, or services in the area of security and defense, i.e., above 5% of total net revenue (cumulatively over the last 3 closed accounting periods). Support available for companies that conduct business in an organized and continuous manner in the Subcarpathian Voivodeship for a period of no less than 24 months counting back from the date of the call for applications. We have proposals for websites to search. Ultimately, the program would prepare a daily summary of such investors for us. Can someone help us with this? I read that it is possible, but I don't have time to deal with it myself :)

We are looking for a person who will conduct initial and full phone interviews for the position of "Solar Power Plant Installer." We have a candidate database (this includes advertising on social media to find people, as well as job postings on job search platforms), and these individuals need to be qualified, contacted, and assessed based on our criteria to determine how suitable they are for us and whether they are ready for our conditions. We clearly understand what kind of people we need and have well-defined payment conditions for them. You will need to familiarize yourself with these conditions and qualify candidates accordingly, as well as format information for each candidate in a specific way for the convenient reception of potential candidates who have already gone through the interview and your qualifications. Regarding payment conditions, we are open to considering your reasonable options. Thank you, I look forward to your responses.

It is necessary to compile an up-to-date database of potential partners and clients from Google Maps (Heating equipment stores, plumbing, installation companies) in Ukraine for further cold calls. Requirements for the result: 1. Company name / store or contact person. 2. City 3. Current phone number 4. Website / social media (if available) 5. Category (Heating, installation company, wholesale base) 6. Link to Google Maps Selection criteria: Companies specializing in the sale of heating equipment, boilers, heat pumps, water supply, and related products. Duplicates and closed companies must be filtered out.

A specialist is needed to collect and structure a current database of potential partners for the partnerships department's further work.What needs to be doneCollect contacts of companies and specialists who work with clients interested in international investments, relocation, purchasing real estate abroad, starting a business, and capital preservation.The database must be provided in Google Sheets or Excel format.Categories for collection1. Legal companies international law; immigration law; corporate law; tax law; company registration abroad; investor support.2. Financial companies and consultants financial consultants; investment consultants; wealth management; auditors; accounting firms; tax consultants.3. Business clubs and business communities business clubs; entrepreneurial communities; investor clubs; closed business communities.4. Agricultural sector agricultural consulting companies; agricultural associations; agricultural clubs; agricultural sector companies.GeographyUkraine (priority), Ukrainian companies that have opened offices in other countriesInformation to be collectedFor each company: Company name; Website; Contact person (owner, director, partner, department head); Position; Phone; Email; Telegram (if available); Instagram (if available); LinkedIn (if available); Short note about the company's activities.ImportantCurrent contacts of decision-makers are needed.Preference is given to direct contacts of owners, directors, company partners, and department heads.Contacts like info - are not consideredScope of workIt is necessary to collect a minimum of: 100 legal companies; 100 financial companies and consultants; 50 business clubs and communities; 50 agricultural sector companies.In total: at least 300 contacts.In response to the project, please indicate: cost of work; completion time; examples of similar projects (if available).