Help with the Excel formula

It is necessary to conduct sourcing and create a preliminary register (Google Spreadsheet) of relevant candidates for labor and technical specialties (welders, assemblers, builders, warehouse workers) who are ready for contract work/relocation. Sourcing regions: Central Asian countries (Uzbekistan, Kyrgyzstan, Tajikistan, etc.) India, Syria, etc.................. What is included in the task (final result): Search and initial verification of candidates' profiles based on specified criteria (work experience, availability of documents, readiness to relocate). Filling out the final table (Full Name/ID, specialty, experience, country, contact status, availability of video confirmation of skills if available). Initial surveying of 10–15 candidates regarding relevance and profile compliance. Requirements for the performer: Availability of tools/access to local sourcing channels or databases in the specified regions. Understanding of the specifics of labor specialties (blue-collar workers). Ability to structure data and maintain operational reporting. Conditions for execution: The scope of the test task and a detailed checklist/profile of candidates will be provided after discussing the details in private messages. We are ready to consider a regular volume of tasks based on the results of this project. Please indicate in your bid: Your experience in sourcing in the specified regions. Estimated time for collecting a database of 10–20 verified profiles.

Project Description:We are looking for a cold calling specialist with fluent Italian language skills to complete a test/short-term project.What needs to be done:Make exactly 100 targeted (at least 2 minutes of conversation) outbound calls to potential clients in Italian.Deadline: exactly 3–5 days from the start of the project.Present the company's product/ecosystem (Fintech / AI Crypto solutions) using a prepared script and materials.Handle basic objections and record interested candidates/investors.Fill out a brief report on the results of the calls (CRM / Google Sheets).Final Goal: Engage the potential client and send a registration link to the client.Requirements for the performer:Fluent spoken Italian language (C1/C2 / Native).Experience in telemarketing, cold sales, or call centers (experience in crypto/finance will be a plus).Clear speech, confidence on the phone, ability to handle objections.Availability of a quality headset, quiet workspace, and stable internet.Criteria for successful results: Completion of exactly 100 calls (of 2 minutes) within 3–5 days with the provision of a report/recordings of calls and transfer of contacts of interested clients.

Looking for a tender specialist (Prozorro) in the textile sector — bed linen, towels. For a one-time paid consultation

Sales Manager (1-Month Project) A virtual reality club in Odessa is looking for a competent manager. The main task: to fill the club with guests, communicate with potential clients, and provide consultations on the company's services. What you will do: collect a client database based on specified criteria; conduct phone negotiations with potential clients; present the company's services; record the results of communications; work according to the provided algorithm and achieve set goals.Who we are looking for: a person with proficient Ukrainian oral and written communication skills; with experience or good skills in phone sales; able to learn quickly and understand new information; responsible, proactive, and results-oriented; availability of autonomous power supply or backup power source.What we offer: clear tasks and training before starting work; support at all stages of the project; timely payment. If you are interested in participating in the project, please send a brief information about yourself, share your sales experience (if any), and indicate a convenient way to contact you. We will discuss all details about the company, working conditions, and payment during a personal interview.

Budget: 2000 UAH Deadline: 7 days Project Description A consultation is needed from an accountant or tax consultant with practical experience in e-commerce, international purchases, agency or commission models. I am planning to launch a personal buyer service that helps clients purchase goods from the USA. Working Model: the client sends a link to the product; verification and final calculation are conducted; the client pays for the order; the product is purchased; international delivery is organized; the service receives a reward for its services. After selecting a performer, a detailed description of the business model and business processes will be provided.Need Help Determining Which legal model is most suitable for such a service. Whether it is advisable to use an agency agreement, commission agreement, or another model. What will be considered income for tax purposes: the total amount received from the client; or only the commission reward. What documents need to be prepared for legal operation: public offer; contracts; acts; reports; other documents. How to properly organize the receipt of funds from clients according to the chosen legal model. Whether a cash register (RRO/PRRO) is needed and under what conditions. What risks exist in such a working model and how to minimize them. What taxation system and form of activity do you recommend specifically for such a business. How to properly structure the work if the actual organizer of the project cannot be registered as an individual entrepreneur (FOP), and the business is planned to be launched under another person.Work Format Familiarization with the description of the business model. If necessary — clarification of details in chat or a short phone consultation. Preparation of a written conclusion with recommendations.Work Result After the consultation is completed, a written document must be provided, containing: the recommended legal working model; the recommended taxation system; a scheme of cash flow between the client, service, and suppliers; determination of which amounts are income for tax purposes; a list of necessary contracts and documents; recommendations for receiving payments; a response regarding the necessity of using a cash register (RRO/PRRO); main legal and tax risks; a step-by-step launch plan.Will Be an Advantage Practical experience with: e-commerce; international purchases; personal buyer services; agency or commission agreements; forwarding companies; international trade.Request in Response Please briefly indicate: whether you have had similar projects; which business models you have worked with; what result of the consultation you provide; estimated completion times.