List countries world cities excel sheetdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

Rad bi, da mi kdo svetuje. Kako narediti strežnik (kaj sploh potrebujem) , da bo na njega povezano 100-tine (NB-IoT) naprav. Radi bi sami imeli podatke na svojih strežnikih in jih obdelovali. Kako adresiramo NB-IoT naprave, da pošljemo na njih nek podatek? Keri developer board je trenutno najbolje vzet za NB-IoT napravo, ki bo na terenu komunicirala s strežnikom. Rabim Hello World exsample server side in device. Kako se pošle podatek s strežnika na napravo in obratno. Primer1: Naprava na terenu tipa temperaturo in na vsake 10 minut sporoča podatek na strežnik. Primer2: Strežnik pošlje napravi podatek, naj vklopi nek GPIO ali izklopi. Hvala, Lp, Matej

Rad bi izdelal kviz ki bi obsegal razlicna podrocja, za zacetek na primer vprasanja iz racunalnistva, excel-a, podjetnistva,.. V kolikor pa bolje spoznate na kaksno drugo podrocje in se vam zdi da bi bila vprasanja uporabna tudi za ostale, se lahko zmenimo tudi za kaksno drugo podrocje vprsanj. Poleg vprasanja bi bili ponujeni 3-je mozni odgovori, med katerimi bi bil en pravilen. Za vsako podrocje bi imeli vprasanja razlicnih tezavnostnih stopenj, na primer Lahka, Srednje in Tezka. Bonus tocke za: -Vprasanja niso predolga, da ne zahtevajo ravno predolgega branja -Nekaj vprasanj lahko vsebujejo tudi kaksen smesen ali pa nenavaden ponujeno odgovor

need help with spreadsheet formula

I am in need of assistance primarily w...specifically, data entry of invoices. Ideal skills and experience for the job include: - Proficiency in finance and accounting - Experience with data entry - Familiarity with invoice processing Key tasks will include: - Assisting with month-end financial reports - Posting journal entries - Helping with accounts receivable, payable and bank statement reconciliation - Assisting with audits - Balancing sheet reconciliation - Working with the finance team on yearly forecasting efforts - Managing the monthly tracking of our physical inventory - Supporting the payment processing team - Data entry - Conducting credit checks The ideal candidate will be detail-oriented, able to handle data entry tasks efficiently, and comfortable working as part ...

Title: Seeking Talented Artists for Travel Poster Creations Description: We are looking for talented illustrators capable of creating travel posters in retro, modern, or vintage styles. These posters will showcase cities, landscapes, or iconic landmarks, with a focus on design, colors, and the aesthetic characteristic of classic travel posters. Key Requirements: Experience: You have previously created travel posters or similar illustrations (please provide concrete examples in your portfolio). Expected Style: We are looking for designs with clean lines, well-thought-out color palettes, and an atmosphere that evokes wanderlust and the unique visual identity of each destination. Adaptability: Each illustration must be tailored to the specific city or tourist destination. Project Det...

I need an aggregated list from data files in excel/power bi.

I need an aggregated list from data files in power bi

I'm seeking a freelancer to design an Excel reporting template to track our membership enrollments. The template will primarily handle registration data, specifically focusing on membership sign-ups. Key Features: - Automated Calculations: The template should perform relevant computations automatically. - Visual Charts and Graphs: The template must convert data into easy-to-understand visual representations. - Data Filtering and Sorting: The template needs to facilitate easy sorting and filtering of data. Ideal Skills: - Proficiency in Excel, particularly in creating complex templates. - Experience with data visualization - Strong understanding of membership enrollment processes. With this project, I hope to simplify our reporting process and enhance our data interpre...

...here, or where I am cause I'm missing you, are you getting it? Cut me out of the picture like I never fit, you're a shooting star but I forgot to wish, did I ever cheat? Girl I plead the fifth, tried to talk it out, you didn't wanna speak, now our love's in the air and I can barely breathe Maybe one day we'll make it work, but you can't be in love if you've never been hurt, wanna give you the world and never look back, but I gave you my heart and you never came back, so I'm sleeping and I'm dreaming, thinkin bout the times you said you're leaving, now I'm love drunk, not sober, can you wake me up when it's over? When it's over, wake me when it's over, cause I don't wanna be lonely, anymore, anymore When ...

...and company communications. Skills and Qualifications * Good communication and writing skills, with the ability to convey information clearly and concisely. * Proven experience in mortgage advising, banking, or a related sales /operations environment. * Strong organizational skills with meticulous attention to detail. * Proficiency in using CRM software and office applications (e.g., MS Office, Excel). * Bachelor’s degree in Finance, Business Administration, or a related field. * Strong networking and relationship-building skills...

I am looking for a skilled professional Vietnam speakers all over the world who can write and understand Vietnamese . All Vietnamese Countries Needed..!!!

Dashboard Creation We are seeking a highly skilled and experienced Excel Expert to create professional and visually appealing KPI Dashboards in Excel. The ideal candidate should have extensive knowledge of advanced Excel functionalities and a strong ability to translate data into actionable insights. Proficiency in Google Sheets is a plus. Key Responsibilities: Design and develop customized KPI Dashboards in Microsoft Excel based on business requirements. Collaborate with stakeholders to identify key performance indicators and define dashboard objectives. Use advanced Excel formulas, functions, and tools (e.g., VLOOKUP, INDEX-MATCH, SUMIFS, Pivot Tables, etc.) to process, analyze, and visualize data effectively. Create dynamic and interactive dashboards ...

...some work done. Getting a new CRM . I need insightly crm setup. I need the crm connected to my website. The CRM is insightly crm. 1. I use 3 types of categories in the CRM. Leads, Pipeline, and Customers. 2. Perfexcrm is installed on aws i need it removed. 3. Leads and Pipelines are in the same type. 4. Customers business name. Managers come and go, so Business names. 5. I have my own provided excel sheet, items in my leads and customers. 6. I have built a form for new leads. I need it to import all new leads I enter with phone form. 7. I need for all new customers to be added to customers not leads from website. 8. I need a to setup tabs, to send commands to your system. Like grade of each lead or send emails. Or other commands. 9. Need to setup templets for emai...

As a business owner, I am seeking a seasoned digital marketer with a strong background in social media advertisement to enhance my Facebook and Instagram ads. The primary aim of these ads is to increase our sales. Target Audience: - The ads should be specifically tailored to appeal to middle-aged adults (25+). in jordan , even i want to target jordanian people in GCC countries. Platform Focus: - The ads will be run on both Facebook and Instagram, so an understanding of the nuances and best practices for each platform is crucial. Ideal Skills: - Proven experience in managing and optimizing social media ads, particularly on Facebook and Instagram. - Excellent understanding of the middle-aged adult demographic. - Strong analytical skills to assess ad performance and make necessary ...

I'm looking for a professional who can design a template for certificates for business communications. The ideal candidate should have expertise in Microsoft Word and Excel, particularly in mail merge functions. Key Requirements: - Design a professional certificate template with space for date and signature. - Assistance with mail merge from Excel to Word. - Ensure dates are formatted correctly into UK format. I have some knowledge on how to do this but I'm currently having difficulty getting the dates into the correct format. Your expertise and assistance would be greatly appreciated.

...Description: We are seeking a skilled freelancer to enhance and optimize our current spreadsheet system for tracking class data. Our goal is to make the system more insightful, visually engaging, and actionable for our business planning. Current Setup: We use spreadsheets to track class data, including the category of the class, the instructor, and the location. Each year has its own dedicated sheet. A summary sheet aggregates data from the yearly sheets, providing total counts for the year. Scope of Work: We’d like to expand the capabilities of this system by introducing new graphs, charts, and insights, including: Graphs and Charts: A graph showing the number of classes taught at each location, broken down by year and month. A chart summarizing how many classes e...

We are looking for a remote marketing specialist to promote our platform dedicated to the massage and spa industry in ARGENTINA. Ideal candidates should: - Have experience in marketing and promotion (preferably in the massage/spa sector). - (of course) speaks Spanish :) - Be fluent in English (essential). - Knowledge about other Spanish-speaking countries in South America will be an additional advantage. Join us to help grow an innovative platform! Competitive pay. Flexible hours.

I need an Electrical Contractor or equivalent experienced in 3 phase, commericial electrical work as well as 24v occupancy sensor work and in-conduit wiring to generate an extremely detailed electrical take-off from blueprints which I will provide in PDF format. I need the result to be an excel spreadsheet with columns for "Item" "Quantity" "Description" "Location" etc. It needs to include the lengths of conduit by type/size as well as wire as well every box, conduit elbo, panel, service entrance item, light, switch, etc. The take-off needs to formatted as such that I can send it to various electrical supply houses for material pricing. Take-off is ONLY needed for electrical sheets, E001, E101, E211, E212, E221, E222, E231, E511, E601 ...

I'm in need of an Excel list containing at least 5,000 UK-based healthcare and wellness companies, specifically hospitals and clinics, fitness centers and gyms, as well as wellness spas and retreats. Key Requirements: - The list should include the business name and address for each company - The data should be delivered in .xlsx format Ideal Skills and Experience: - Proficient in data mining and Excel - Previous experience in compiling business lists - Understanding of the healthcare and wellness sector is a plus.

I'm looking for a Virtual Assistant to help me with an important task involving my sales leads. Key Responsibilities: - Gather and compile all provided Excel files containing sales leads into a single, comprehensive Excel sheet. - Organize the leads in alphabetical order from A-Z. - Identify duplicate entries and highlight them in yellow for easy identification. Duplicates can be same address, or company name, or phone number etc. - Ensure that the final document is clean, organized, and easy to read. Ideal Skills: - Proficient in Microsoft Excel or similar spreadsheet software. - Detail-oriented to ensure duplicates are marked accurately and the final document is neat. - Good organizational skills to compile and sort the leads effectively. Please...

I'm looking for a skilled team to develop a robust taxi booking application akin to the Uber platform. The app needs to be compatible across iOS, Android, and Web platforms, ensuring a seamless user experience regardless of device. Key Features: - Real-time GPS tracki...with different commission rates or marketing materials. 3. Provide Ongoing Training: Host webinars or share best practices with affiliates to improve their conversion rates. --- Step 6: Scale the Program 1. Expand to Partner Apps: Integrate with ride-related apps or services (e.g., navigation or trip-planning apps). 2. Launch Regional Campaigns: Target affiliates and users in specific cities to grow app adoption. 3. Encourage Sub-Affiliates: Allow top affiliates to recruit others for additional inc...

I'm looking for a professional to clean my email list of 30,000 contacts, remove duplicates, and segment the list based on purchase history. The cleaned list should ideally have an open rate of about 20% on Mailchimp. Key Requirements: - Remove both identical email addresses and same contact information with different emails. - Segment the list based on purchase history. Your expertise should improve my deliverability and ultimately increase my open rates. Experience with Mailchimp is essential.

I want to learn how to earn well in the freelancing world specifically in the proofreading and editing niche. Ideal Skills and Experience: - Expertise in proofreading and editing - Proven track record in freelancing - Excellent teaching and communication skills

I'...vertical line on the chart to identify a particular price bar. When I place a vertical line on the chart, I want the script to extract the following information and send it to an Excel sheet: 1. The date of the price bar 2. The time of the price bar 3. The price (it should consider the high price of the bar if I use a green vertical line, or the low price of the bar if I use a red vertical line) The exact specifications of the project, including the precise format for the data, can be found in the attached document. Key requirements: - Expertise in TradingView and its scripting language - Proficiency in Excel and data formatting - Attention to detail Placing a bid on this project confirms that you have read and understood all the details in the attached...

I'm looking for a skilled data manager to assist in consolidating financial data. Key Responsibilities: - Extract financial data from multiple Excel financial statements - Compile the data into a single Excel sheet Ideal Candidate: - Proficient in Excel - Experience with financial data - Detail-oriented and able to ensure data accuracy

...extrusion. -Ladder: ¼” x 1” flat bar, custom bent to fit guide rails with felt lining to prevent scratching; treads are ½” diameter rods threaded on ends with acorn nuts. -Ladder Rail: 1.5” diameter round antique brass with mounting brackets (refer to 05500-4 Bourbon Ladder). Plans (24x36” Sheets): -Sheet 1: Architectural floor plan and reflected ceiling plan. -Sheet 2: Left and right side elevations and section cuts. -Sheet 3: Enlarged details of metal framing connections showing material thickness. -Sheet 4: Electric lighting adjustments: existing soffit light circuits tied to new edge lighting around glass shelves + low-voltage transformer. Title Block Information Project: Bar Entry Bourbon Rack Location: Sea P...

Seeking a full-time member to ...48 hrs/week. If we find during that period that you are a good fit for the role, this could become a long-term position. Our budget for the job is $2/hr USD. Requirements -- Available Mon - Sat, 9am - 7pm NYC time -- Great visual eye -- Attention to detail -- Fluent in English -- Great communication (verbal and written) -- Patience -- Experience with Google Docs, Google Calendar, & Microsoft Excel preferred -- Content writing experience is a plus. -- Newsletter management is a plus. Roles & Responsibilities -- Quality check photos and provide feedback to photo editor. -- Schedule photography appointments with clients and photographers. -- Respond to customer inquiries via email promptly. -- Send lead generation messages. -- Online resear...

I'm looking for a digital illustration that depicts a beer bottle in the style of a Corona bottle. The cap should be separated from the bottle. Key Requirements: - The label on the bottle should only contain the text "brewery co." a..."classic beer". - There should be a kind of light golden aura around the bottle. This illustration is intended for a jean, so the background should be as minimal as possible, ideally just the illustration itself. Ideal Skills and Experience: - Proven experience in creating digital illustrations, particularly of product designs. - Ability to create detailed and accurate representations of real-world objects. - Prior work with apparel designs is a plus. - Strong understanding of color and light, particularly the ability to...

I'm in need of an Excel spreadsheet designed to meticulously track my sales team's performance, both weekly and monthly, as well as year-to-date (YTD). The primary focus will be on sales performance metrics. Key Requirements: - The spreadsheet needs to be capable of tracking various sales performance metrics - It should be able to capture data on a weekly, monthly, and year-to-date basis - It should be user-friendly and easy to update Ideal Skills and Experience: - Proficiency in Microsoft Excel - Experience in designing sales tracking spreadsheets - Understanding of sales performance metrics - Ability to create user-friendly and easy-to-navigate spreadsheets I appreciate your bids and look forward to working with a professional who can help me with this project...

I'm seeking a talented videographer or content creator based in Thailand to shoot footage for a YouTube travel vlog. Key Responsibilities: - Capture high-quality video content featuring Thailand's stunning beaches and islands, as well as its bustling cities and urban areas. - Create engaging and visually appealing travel vlog content. Ideal Skills: - Proven experience in videography and video editing. - Ability to create compelling travel vlog content. - Knowledge of Thailand's picturesque locations. - Good understanding of YouTube's content requirements and audience preferences. Please note that while this role does not require voice narration, a good sense of timing for background music is essential. I look forward to seeing your bids and hopefully working t...

It is a local project. I'm looking for a talented content creator who can help me turn my travel experiences in Thailand into a captivating vlog-style video for my YouTube channel. The content will predominantly feature the beautiful beaches and vibrant cities of Thailand. Key Responsibilities: - Edit and enhance raw footage to create a compelling and engaging travel vlog. - Incorporate visual effects, sound effects, and music to enhance viewer experience. - Create a narrative that captures the essence of each location. - Optimize video for YouTube in terms of format, length, and SEO. Ideal Skills: - Proficient in video editing software such as Adobe Premiere Pro, Final Cut Pro, or similar. - Experience in creating travel vlogs or similar content. - Strong storytelling skills...

I'm looking for a financial tracking solution that automatically links and consolidates my expenses from my credit cards and bank accounts in both Argentina and the USA into a single Excel sheet or similar. Key Requirements: - Automatic linkage of all my checking, credit card and savings accounts. - Consolidation of expenses into a clear, comprehensible format. - Support for specific banks from Argentina and the USA. Ideal Skills and Experience: - Proficient in financial software and Excel. - Experience with linking bank accounts and credit cards for expense tracking. - Knowledge of specific Argentine and USA banks. - Ability to present data in a comprehensible format.

I'm looking for a professional Excel expert who can help me format a spreadsheet containing contact details into a user-friendly, easily sorted and searchable data reference guide. This is a single spreadsheet with 15 columns within 11 headings and about 13 rows of data entry. Specific formatting and ease of search and sort are key. Ideal Skills and Experience: - Proficient in Excel with advanced formatting skills - Experience in creating searchable databases - Strong attention to detail - Ability to understand and implement a specific project vision

I'm looking for an expert in Smart Sheets with experience in healthcare quality systems. The project involves building sheets, reports and dashboards that track operational metrics within a cloud-based quality managemen...reports - Strong understanding of operational metrics in healthcare The ideal candidate should have a keen eye for detail and a strong background in data analysis, as well as the ability to present complex data in a clear and concise manner. I am looking for someone who can deliver high-quality work on time and can communicate effectively throughout the project. We need to date a mesh inputs from Excel Given security issues and access issues the bill will have to be done with me in real time sharing screens. I’m looking for someone to help walk me thr...

I need a comprehensive Smartsheet dashboard for monitoring daily hospital operations. This dashboard should cater to all units in the hospital, inc...ideal candidate will have experience with Smartsheet and data visualization tools like Tableau. Key requirements include: - Integrating various data sources: Excel/CSV files, Online Smartsheet forms, and a Database - Creating dynamic views for different operations teams - Designing the dashboard for ease of use and comprehension Skills and experience needed: - expert Proficiency in Smartsheet - Experience with data manipulation and visualization - Ability to design user-friendly dashboards - Understanding of hospital operations would be a plus I want the dashboad in smartsheet to be similar to to the dashboard we are using in ex...

I'm seeking a freelancer to help me gather email addresses from Google My Business profiles, specifically targeting restaurants in a giv...given city. Key Tasks: - Search for 'Restaurants' in the specified city on Google Maps. - Visit each restaurant's Google My Business profile and subsequently their website. - Collect email addresses from these sources. Requirements: - Deliver a list of 1000 targeted emails in a Google Sheet. - Only include restaurants that meet the criterion of having a minimum number of reviews. Ideal Candidate: - Experience in data collection and research. - Familiarity with Google Maps and Google My Business. - Able to deliver a well-organized Google Sheet. Please bid for the project with the understanding that I need 10...

...management - Working within GHL webpage editing, our site and materials, updating and optimization for SEO - GHL memberships, and community building and maintenance -CRM optimization and management -Bot and AP intergration Ideally you are in a time zone we can both work at the same time If you are representing or working for an agency, please do not apply. experience with the coaching training world and or real estate agents, is appreciated but not critical our budget is $2.00 to $5.00 CDN (freelancer does nto give me the ability to change their setting. To see if you are actually reading the description, in your application please confirm what time zone you are in, that you are willing to work within our budget and that you are not working for or representing a freelancer agen...

...execution. Development Steps Designing and Drawing via CAD: Create a detailed blueprint and 3D model of the robot's structure. Building a Mockup: Construct a prototype for testing physical features and user interactions. Programming: Implement AI algorithms for speech recognition, screen analysis, and autonomous decision-making. Testing and Finalizing: Test the robot’s functionality in various real-world scenarios, refine its performance, and prepare for manufacturing....

I need an Excel expert to elevate my sales data spreadsheet into a high-end, professional looking document, perfect for data presentation. Key Requirements: - Extensive experience with Excel and data visualization. - Ability to incorporate company branding seamlessly into the spreadsheet. - Understanding of the principles of professional, high-quality design. Important Elements: - Integrate company logo and color scheme. - Create a visually appealing layout that enhances data presentation. Ideal Skills: - Excel - Data Visualization - Graphic Design in Excel - Branding Please note, this project is not about altering the underlying data, but about making the spreadsheet visually impressive and suitable for professional use.

We’re running into a problem with provider blocks in our business. What we’d like to do is identify the countries of users’ IPs when they log in to our site. If their IP is from a country on our blacklist, we want to automatically redirect their traffic through a proxy or a similar solution that changes their IP to one from whitelisted regions like South Africa, Colombia, Finland, or others. Basically, we need a way to make sure all traffic from blacklisted countries goes through trusted IPs. We’re open to your suggestions on how to best handle this. I'm looking for a professional who can assist me in setting up a proxy solution to redirect traffic. The main purpose of this project is to bypass certain restrictions. Skills Needed: - Exp...

...create a comprehensive Excel spreadsheet template with macros, active control options, and bar charts for my company, Measurement Solutions, Inc., an industrial distributor specializing in measurement equipment. This template will be used for quoting custom gages. The project will involve: - Creating macros to automate calculations, generate custom quotes, and handle data validation and cleanup. - Designing the template to input various types of data including customer information, product specifications, pricing details, and delivery information. - Incorporating bar charts for price/time comparisons. Ideal skills for this job include: - Advanced Excel expertise, particularly in creating and implementing macros. - Experience with data validation and cleanup in Excel...

Puede usar chatgpt sin abusar. De ello Descripción del proyecto: Tengo un documento en Word que estoy convirtiendo en un Ebook, pero necesita varias mejoras para que quede profesional. Las tareas que necesito que realices son las siguientes: Correcciones: Ortografía y gramática. Redacción y estilo para mejorar la claridad y presentación. Estructura general del texto. Índice: Crear un índice nuevo. El índice debe incluir solo las especialidades y las enfermedades en orden alfabético, sin repetir la especialidad encima de cada enfermedad. Enumeración: Las enfermedades están actualmente enumeradas, pero el formato no es estético. Necesito que cada enfermedad tenga una enumeración clara, organizada y...

I'm seeking an experienced data collector to compile an exhaustive list of all commercial real estate agents located in Düsseldorf and within a 30km radius. These agents should be dealing specifically with store or warehouse properties. The data must be organized in an Excel spreadsheet with the following columns: - Company - Phone - Email - Website - Address Accuracy and precision are paramount. The details must be correctly and meticulously recorded. The data should be sourced primarily from online directories, although any reliable source will be considered. The final step of the project will involve verifying the gathered information to ensure its correctness and reliability. Ideal skills for this job include: - Proficient in data collection and analysis -...

We are part of a global network providing drug testing services, with a presence in multiple countries. Our client requires us to conduct drug testing in New Liskeard Crescent, Ottawa, Ontario K2J 0N3 Canada. This testing is part of a pre-employment background check for new hires. As a certified company, we do not require you to have any prior licenses or experience. We will provide comprehensive training, necessary supplies, and tools. Responsibilities: - Collect urine samples from the client's residence or office, or arrange to rent a meeting room for the session. Meeting room rental costs will be covered by us. - Perform the testing hygienically following our guidelines. - Send the test results to us. We will compensate you for each test conducted.

I have a picture of an Excel template that I need replicated. The template primarily consists of tables and is primarily text-based. I also need specific text formatting including bold and italics, as well as colored text. Ideal skills for this project: - Proficiency in Microsoft Excel - Attention to detail for accurate replication - Ability to format text according to specifications

Connects freelancers with clients in need of various services such as writing, design, development, marketing, and more. Global Reach: Offers opportunities for freelancers from around the world to find projects and work remotely. Flexible Work: Allows freelancers to choose their own schedules, set rates, and work on projects that align with their skills and interests. Payment Security: Offers secure payment systems, with options for hourly or fixed-price contracts. Project Variety: Covers a broad range of industries and sectors, providing freelancers with diverse work opportunities. Profile Building: Freelancers can create detailed profiles showcasing their skills, past work, and reviews from clients. Client Interaction: Facilitates communication between freelancers and client...

Connects freelancers with clients in need of various services such as writing, design, development, marketing, and more. Global Reach: Offers opportunities for freelancers from around the world to find projects and work remotely. Flexible Work: Allows freelancers to choose their own schedules, set rates, and work on projects that align with their skills and interests. Payment Security: Offers secure payment systems, with options for hourly or fixed-price contracts. Project Variety: Covers a broad range of industries and sectors, providing freelancers with diverse work opportunities. Profile Building: Freelancers can create detailed profiles showcasing their skills, past work, and reviews from clients. Client Interaction: Facilitates communication between freelancers and client...