Export spreadsheet quality center jobs
I'm looking for a skilled web data researcher with expertise in the technology industry to find resumes across all levels of experience. Key Points: - The focus will be on the technology industry, so...familiarity with this field is highly preferable. - I'm interested in resumes spanning from entry to mid levels, so the ability to identify and gather a wide range of profiles is essential. - The final deliverable should be a spreadsheet, for easy and organized review of the collected resumes. Ideal Skills and Experience: - Previous experience as a web data researcher, particularly with resume or profile identification. - Substantial knowledge of the technology industry and its various job roles. - Proficiency in compiling data in a clear, organized manner, preferably in...
I'm looking for a proficient person that can go into links and write emails and phone numbers. There are 15,000 Records to revise. Work needs to start asap and be completed with a good team. This is not a one person ...Currently, I'm using Excel spreadsheets, which is proving inefficient. I require an effective solution to input data and offer functionality that makes the information more accessible. Your Tasks: Go into profile and extract email, phone number , link in the bio and also any nics in the bio Required Skills and Experience: - Understanding of search functionalities - Data Entry - Knowledge in data export would be a plus. You should have a strong track record of creating functional, efficient databases and exhibit a keen eye for detail to ensure accurac...
I'm in need of a unique logo for an apron design. I'd like a caricature of the chef placed at the center of the logo. This caricature should be styled to represent a 'King of Fire'. Alongside this image, I'd like the words "King of Fire" in english and Turkish to be incorporated as part of the design. The color scheme I'm looking for is warm tones including red, orange, and yellow. The objective here is to create a logo that's bold and vibrant, in line with the theme of fire. Specific elements related to cooking that I'd like incorporated in the logo include a chef's hat, flames or fire, turkish flag on the t-shirt or top, tongs and a charcoal bbq. Your ideal skills and experience for this job include: - Proficiency in creati...
...Experience with similar projects will be highly valued. I am implementing an automated sales recovery process designed to engage potential customers who have shown interest but did not complete their purchase. This includes scenarios such as cart abandonment, failed payment attempts, or unpaid invoices generated. The objective is to capture these instances in real-time and integrate them into our call center workflow through the IPBOX platform. IPBOX will utilize this data to populate its calling list and initiate a customer re-engagement protocol via phone calls. Here is the API documentation for IPBOX, which outlines the method to insert a new prospect into the specified batch for follow-up: Enclosed is
I'm in urgent need of someone who can scrape a website for me. So the intent is that we open the first page, and set a filter, and then go to each profile and open the websites/social profiles to see if they have any emails addresses. Output is a spreadsheet with rank, name, socials, website, email address. Skills required: - Web scraping - Ability to deliver results in a timely manner
...precision and detail? We're in search of a freelancer who can provide high-quality leads specifically tailored to our requirements. Project Details: Target Location: Brisbane, QLD, Australia Industry: Commercial window tinting Lead Criteria: Business name Phone number Email address Physical address Geographical Range: Within a 50km radius of Brisbane, QLD 250 leads required Requirements: Accuracy: We require active and accurate leads that meet the specified criteria. Delivery Format: Leads must be supplied in an Excel spreadsheet for easy integration into our systems. Timeliness: Prompt delivery of leads is crucial for our business operations. How to Apply: If you're confident in your ability to deliver high-quality leads meeting the outlined criteria...
I need help browsing the web for text data and organizing it in Excel. - The text data is to be organized in Excel by name and other relevant information. - No specific Excel functions or formulas need to be used, you will simply need to look at the page and type the information into the spreadsheet. Ideal skills: - Proficiency in web browsing - Be very quick - Strong attention to detail - Familiarity with Excel - Time management skills The task is straightforward, but attention to detail, accuracy, and the ability to work efficiently are crucial. Please submit your daily rate.
I have a spreadsheet with approx 1600 rows. One of the cells on each row has a block of text content that I would like rewritten using ChatGPT. There are also 2 other cells in the spreadsheet that contain a few words that needs to be included in the new text output. You can either do this manually, or a better way would be to use the ChatGPT API to complete this task (in a matter of minutes!) I know this can easily be done via the API and how quickly it can complete this task, but I just do not know how to do it, so please bid accordingly.
I'm currently working on a financial analysis project through Microsoft Excel and require assistance with data structuring specifically for pivot tables. I aim to feed this data into a comprehensive dashboard. The Excel spreadsheet encompasses multiple periods of financial data. Key Aspects: - Data included in the pivot tables are dates of financial periods, types of financial information, and identifiers such as multiple General Ledger accounts, categories and subcategories. - The task involves transforming this spreadsheet data into an appropriate format suitable for creating a pivot table and consequent dashboard. Skills and Experience: - Proficiency in Microsoft Excel, particularly in the handling of complex data and pivot tables. - Experience in financial data a...
I require a Power Bi expert to assist with transferring and analyzing our sales data, currently stored in a spreadsheet format (CSV, Excel). The main element I need to focus on within the analysis is the sales trends over time. The ideal candidate would have: - Strong skills in data transfer and analysis in Power BI - Experience dealing with sales data - A keen eye to identify and present trends over time effectively. To confirm, your task will involve: - Transferring sales data from a CSV/Excel file to Power BI - Conducting detailed analysis focusing on sales trends over time - Presenting these findings in a useful and understandable format.
I need an Excel sheet that will empower me to manage my call center effectively by providing me with real-time insights into the number of agents needed per hour. Key Requirements: - The sheet should offer a graphical representation of the data, enabling me to quickly understand the changes in agent demand. - It must calculate and display the total call duration per agent,hourly agent demand, and the average wait time for callers. Data should be updated on a daily basis to ensure the most current and accurate information is available. Ideal Skills: - Proficiency in Excel and ability to create dynamic tables and graphs. - Experience in designing forecasting models would be a plus. - Strong understanding of call center operations and key metrics. The ideal freelancer ...
I'm in need of an experienced data entry freelancer for an offline project. The data is alphanumeric in nature and needs to be carefully collated into a spreadsheet. The ideal freelancer for this project would possess the following skills: - Expertise in Spreadsheet software like Excel - High attention to detail - Experience in handling alphanumeric data - Proven ability in offline data entry This is a great chance to show off your data entry skills while helping us to preserve vital alphanumeric data. An eye for detail and accuracy is critical for success in this role.
I need a professional to transcribe a scan of a very clear handwritten sign-in sheet in PDF format into a digital spreadsheet. This is a task i require completed immediately. Pls only apply if you're able to to start and complete this task asap!! - The information fields you will be working with are: names, phone numbers and postal codes. - Your role will require keen attention to detail to ensure that no data is lost or inputted incorrectly. Ideal skills and experience: - Proficient in data entry - Previous work involving transcribing handwritten documents - High degree of accuracy and attention to detail One example is attached i have about 200+ pages that need to be transcribed.
I need someone to create a simple data table search and display function for me. The search form will be inside of a page. The search function will read from a specific spreadsheet with organization names and URLs but it will also have keywords and categories that it needs to search. Example: search term: Fatherhood Display: Organizations, categories, URLs with the term "fatherhood" or a category. The results will simply display below the search form in a row: ORG NAME URL. CONTACT INFO (if any) See the attached spreadsheet. I DO NOT want a listing directory with individual pages for listings. All this is should be a search box, and display results statically beneath. I can create a screenshot of necessary. Also it needs to match the CSS of the rest...
...can utilize libraries such as HTML/CSS/JavaScript/Bootstrap to implement the design. The pages for which we require a mockup design for responsiveness are as follows: Homepage About Us Mission and Vision Quality & Environment and OHS Certificates Board of Directors Products and Services (Homepage) Product Groups Sub-Product Groups Product Industries (Homepage) Industry Blog (Homepage) Blog News and Announcements (Homepage) News References Projects (Homepage) Project Happy Customers (Homepage) Contact Us (Homepage) Human Resources Job Opportunities HR Application Form GDPR Download Center We welcome creative ideas for the design, however, we prefer not to make significant changes to the existing structure. When applying, please provide examples of your previous simil...
...offer service contracts to these individuals. Key tasks will include: - Identifying owners of heat pumps within my designated location - Collecting relevant contact data, including names, addresses, phone numbers, and email addresses - Organising this data into a clear and easy-to-understand spreadsheet Prospective freelancers should have proven experience in data collection and research, with an eye for detail and a meticulous approach to their work. Familiarity with Google Sheets or other spreadsheet software is a must, as the data will need to be formatted cohesively and accurately for future use. Previous work in the renewable energies sector, particularly with heat pumps, will be greatly advantageous. A strong understanding of data privacy protocols is also essent...
...research purposes. Your main task will involve extracting the following data: - Member's name - Current job title - Date of group membership - Page URL Key Project Requirements: - All data must be scraped without violating Facebook's terms of service. - Information needs to be organized according to the date of joining the group. - Extracted data should be handed over in the form of an Excel spreadsheet. Skills and Experience: - You need to have proven experience in data scraping, particularly from social media sites like Facebook. - Good knowledge of Excel is required. - Familiarity with the Facebook platform and its data privacy regulations is a big advantage. - Attention to detail and accuracy are critical for this project. Please only apply if you can meet...
I'm re-designing my bedroom, and I need help with execution / working drawings to give my contractor. I have the following already: 1 - I have generated a layout plan of the room using an App, and I can export a rough 3D version as well - so I'll share these with you. You would need to know how to open DXF and OBJ format files (or at least refer to PDFs of the existing layout). 2 - I have Pinterest images for references of the exact design I want for everything (for the wardrobe, for the bed, for the book shelf, etc). You won't have to design anything yourself. What I need your help with is to generate the exact set of working drawings, using 1 and 2 above. I need to show exact measurements (in 2D and 3D) that I can give my carpenter and light contractor for ex...
Following are the requirements of task to be fulfilled. 1- Task is to visit the both locations physically and Take 5 to 6 geotagged photos of with name board captured and from outside the building. 2- Get the verification form filled, signed and stamped by the HR of both locations and also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If the companies does not found on given address than take the 7 to 8 geotagged photos of exact address with right left name boards photos and make a small few seconds video of address . Also get the details of any nearby business ( Name of person, Business name and Contact
Hello! I have integrated a Custom Post Type with a ACF. The idea of this ACF is that when I choose certain options, it will trigger an WpAllExport job, and once the job is finished it should send ...with a ACF. The idea of this ACF is that when I choose certain options, it will trigger an WpAllExport job, and once the job is finished it should send an email to the user that requested that file. This is happening in a Wordpress backend Admin, so we already know who the user is because it is logged-in. There are going to be 10 different options, and user can choose which wpallexport job to export. In the code the jobs need to be identified by job name, not by id. They will have unique names. For this task a Ihave a budget of 70usd. Don't bit with bots I will automatically dro...
I'm seeking a proficient Magento expert to assist with product exports from my eCommerce store. Main Tasks: - Export our extensive range of products into a CSV (Comma Separated Values) file. Skillset: - Solid understanding of Magento - Expertise in module development - Knowledge of performance optimization - Mastery of both theme customization and product exporting Please note the selected freelancer will not be required to deal with specific structures or field inclusions. Only applications demonstrating relevant experience will be considered.
...am planning to open in Bangalore. Key Focus Areas: - Market Research: Specifically, I'm interested in research about potential customer demographics in Bangalore. - Financial Planning: I need a detailed, well-researched financial plan that accounts for all potential costs and earnings. - Service or Program Development: I'd like support in developing the suite of services to be offered at the center. Ideal Skills: - Extensive experience in business plan creation - Understanding of the healthcare industry, particularly postpartum care - Expertise in market research and analysis in the Indian demographic - Experience or knowledge of financial planning, and a strong ability to translate this knowledge into a detailed financial model. By combining these skills and kn...
...parameters such as job title and location. Key Responsibilities: Review and refine existing Python code for web crawling to ensure robust and efficient data extraction. Develop and implement a user-friendly GUI that allows users to input search criteria easily. Ensure the application can parse and extract data accurately from various webpage structures. Output the extracted data into a structured spreadsheet format. Test the application to ensure its reliability and accuracy under different use cases. Requirements: Strong experience in Python and familiar with libraries like BeautifulSoup, Scrapy, or similar for web scraping. Proficiency in GUI frameworks such as Tkinter, PyQt, or others. Experience in handling data extraction and manipulation, and proficient in working with s...
...dynamic team of Call Center Agents (hybrid positions) to join our growing agency and connect with homeowners on behalf of our worldwide network of real estate agents. This is your chance to: - Make a difference in the real estate industry! - Work remotely from the comfort of your home (calm environment with stable internet required). - Enjoy a flexible schedule - starting from 4 hours per day up to 8 hours per day, 6 days a week. - Build a rewarding career with opportunities for growth. Responsibilities: - You will be contacting homeowners to discuss their property and gauge their interest in selling. - Excellent communication and interpersonal skills are key! - Proficiency in the English language at a professional level is a must. Qualifications: - Previous call center...
I'm planning to set up a new educational training center that will cater to students, as well as working professionals. The main focus of the center will be on providing high-quality, intensive training programs spanning a week. Subjects and Skills: - The center will offer courses on preparing for TOFEL and IELTS exams. - In addition, we'll also provide PMP training, time management, and contracts. Key Requirements: - I'm seeking a business planner who can help me structure a comprehensive plan for this new venture. This includes a detailed revenue model, market analysis, competitor research, and a clear marketing strategy. - Experience in the educational sector or with training centers is a plus, as it will help in creating a more effective an...
As an entrepreneur managing an export business in India, I'm seeking a skilled and experienced website developer to create a high-quality site that will be the foundation of my business operations. Key Features: - Product Catalog: The website should have a user-friendly product catalog showcasing our range of export goods. This is vital to enable our B2B clients to browse and select products efficiently. - Shopping Cart: A shopping cart feature is essential to facilitate seamless transactions for our clients. It should allow for easy addition, removal, and payment processing. - Live Chat Support: The website should include a live chat support system to provide real-time assistance to our customers. This feature will be crucial for addressing any queries or concer...
I require the attached logo to be redrawn in a high image quality. I need two versions black on white and white on black. I need the two versions saved in AI, EPS, High RES PDF, High RES JPG and PNG
I'm seeking a skilled 3D designer to create a highly detailed and accurate 3D drawing from a 2D drawing. The main purpose of this 3D drawing is for manufacturing. There are around 20 drawings and i would like to get a quote for 1 drawing Key Requirements: - The 3D model must be highly detailed with precise dimensions. This level of detail is critical for its intended use in manufacturing. - The final deliverable should be in the Solid works or CAD. Ideal Skills and Experience: - Strong proficiency in 3D modeling software. - Experience in creating 3D models for manufacturing. - Attention to detail and ability to accurately translate 2D drawings into 3D models. - Familiarity with the STL file format or CAD If you have a portfolio or past projects that demonstrate your ability to meet...
I'm in need of a creative, efficient graphic designer for a T-shirt design project. The goal is to create a minimalist, text-based design for the reception staff at our sports center. Key Project Details: - The design should be minimalist in style, focusing on simplicity and clarity. - It needs to be text-based, reflecting the name or slogan of our sports center. - The primary audience for the T-shirts will be reception staff and also gym coaches so the design should be appropriate for this demographic. Ideal Skills & Experience: - Proven experience in graphic design, especially for apparel. - Proficiency in creating minimalist designs. - Familiarity with text-based logo and T-shirt design. - Understanding of target audience. If you're confident in your a...
...Hero Section on our website. This project needs to be completed quickly, most preferably by someone who has an in-depth understanding of WordPress design, layout modification, and the potential to add more balanced content for an engaging user experience. Budget is 3500 INR and turnaround 24 hours. Potentially more design work if the task is done right. Specifically, potential freelancers should center around these key elements: - Bring fresh design ideas for layout modification. - Able to select a dynamic and visually appealing background image. - Integrate relevant, engaging, and value-added content into the design. The ideal freelancer for this task should showcase: - A solid portfolio of past work especially in WordPress and website design. - Capacity to work quickly and...
...of an experienced Software Tester to evaluate the quality of a mobile application on both iOS and Android platforms. The main focus of the testing should be on Functional, Usability, and Performance aspects. Key Responsibilities: - Perform detailed Functional Testing to ensure that the mobile app meets all specified requirements and functions correctly. - Conduct Usability Testing to assess the user-friendliness of the app and identify any areas for improvement. - Carry out Performance Testing to evaluate the speed, responsiveness, and stability of the mobile application. Ideal Skills and Experience: - Proven experience in testing mobile applications, preferably on both Android and iOS platforms. - Strong understanding of software Quality Assurance processes and methodol...
Project Deadline: 1 Day Project Budget: $45 Project Level: Standard Project Type: PHP Project Overview We are looking a simple but well written PHP script that uses the Google Places API to allow a user to search for a term, and then display the list of results on screen & allow a user to download the results in a CSV File Script will be using the following Google Places API Additional Technical Information Results must be limited to top 50 records. Script must be written for PHP 8.2 & above 5* FEEDBACK WILL BE LEFT FOR YOU
I need help with data entry and specifically, the task involves copying and pasting printed text from PDF files. Freelancers applying for this project should have - • Strong attention to detail • Basic typing and computer skills • Proficiency in PDF and spreadsheet software. Experience with data transcription from PDFs and a fast turnaround time will certainly give contenders an edge. Please reach out if you meet the above requirements and are ready for a detailed discussion about the scope of work.
I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.
I require an expert in Excel financial calculations to design a spreadsheet to calculate commission on sales. The main purpose is to drive commission payments based on a tiered structure. It will be used to manage commission payments linked to sales figures above a specified target. Ideal Skills: - Extensive experience in Excel spreadsheet design, particularly with financial calculations - Experience in tiered commission structure calculations - Strong understanding of financial data management. Responsibilities: - Design and implement Excel spreadsheet for commission calculations - Ensure accuracy of calculations based on the tiered commission structure.
Hi Ishaq. Can you have a look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a n...look at this app for us. We want to convert it from a commend line batch file to a GUI app in Python. We had one of our team build the app in C# a few years ago, but he has left and we have the source code. The app will extract an image from an excel spread sheet based on the column ref and put the image into a nominated directory with the imaged named as per another column in the source excel spreadsheet. I can send yu a full demo of the app. r...
...by approaching various local stores, targeting local chains, niche shops, and mom and pop establishments. This project requires excellent communication and sales skills, with a particular focus on sales pitching. Key Tasks: - Visiting targeted businesses in the local area - Presenting captivating sales pitches Essential Information to Share: - Range of services our off-shore customer support center provides - Relevant testimonials from our satisfied customers - Key benefits of our offshore customer support This project is most suitable for someone who has a knack for networking, an assertive personality, and previous experience in the sales field. If you are able to demonstrate excellent persuasion skills, a confident demeanor, and you're looking for an opportunity to d...
...PHOTO PROVIDED AS AN EXAMPLE - GREEN, PURPLE AND PINK WILL ALSO HAVE THE SAME EFFECT ***** OPTION 2: *****DESIGN CAN HAVE A BACKGROUND AND WE CAN PRINT ON METALLIC/FOIL LABEL**** BOTTLE WILL BE THE SAME COLOR AS THE DESIGN OF THE BACKGROUND (meaning, if gold bottle, then gold label with foil effect.. if pink bottle, then pink label with foil effect.***** "GLITTER SUNSCREEN" should be front and center and the focal point. 3d Models/renderings/design/images of your design will help in our decision making process. Purple - Sugar Sparkle Green - Fragrance Free Gold - Birthday Cake Pink - Pink Lemonade Product will be printed using offset printing and on bottles that have a metallic/pearlescent effect. If you're ready to bring your creative skills out and help r...
I am in search of a designer skilled in creating visuals similar to the ones in the attached photos. I need someone who can effectively bring my idea to life through compelling and innovative designs. If you have experience in producing high-quality, creative graphics, please reach out to discuss this project further.
The primary goal of this project is to generate leads in the professional services sector, particularly for businesses geared towards knowledge sharing. This may include training centers, consu...Experienced in telemarketing and lead generation - Familiarity with the professional services sector - Great interpersonal and communication skills - Ability to convincingly sell and spread awareness about our services Experience: - Proven record of successful lead generation - Previous work in the professional services industry is a plus - Experience in phone sales and familiarity with call center work - Understanding of CRM systems We are looking for results-driven professionals who can help us grow in this sector and we believe that telemarketing is an essential strategy to achieve ...
...detail-oriented individual to conduct targeted web research. The task involves searching a specific website, using geolocation as the primary criterion, and collating the data of various companies into the excel spreadsheet I will provide. Key Tasks: - Browse the provided website and search explicitly based on geolocation. - The geolocations of interest are predetermined and are stated within my excel sheet. Data Collection: - Oddly, I do not require some common fields like company name, address, or phone number. - Ensure accuracy and completeness of data collated into the excel spreadsheet. Ideal Skills and Experience: - Proficiency in advanced web research and data entry. - Working knowledge of geolocation-based search - Attention to detail and a keen eye for accur...
I'm seeking a skilled professional to help with a critical issue in my Google Merchant Center. The situation involves disapproval of my new spare parts listings due to preemptive item disapproval, primarily concerning the prices. Key Responsibilities: - Address and resolve the price-related disapprovals in Google Merchant Center - Ensure product compliance with Google's policies - Help in preventing future disapprovals Ideal Candidate: - Previous experience in managing Google Merchant Center disapprovals - Proficient in Google Merchant Center policies and practices - Ability to dissect and address preemptive item disapproval issues, particularly related to pricing - A keen eye for detail to ensure the accuracy and relevance of the product listings P...
Hello, I am looking for an experienced MS Excel programmer to enhance and automate an existing Excel spreadsheet. The primary goal is to streamline the workflow by automating calculations and consolidating rows based on unique identifiers. Project Objectives: Automate complex calculations to increase efficiency. Consolidate multiple rows based on specific unique identifiers. Ensure data integrity and accuracy throughout the spreadsheet. Requirements: Proven experience with advanced Excel functions, including macros and VBA. Ability to troubleshoot and optimize existing Excel formulas. Strong attention to detail and a commitment to delivering precise and reliable results. Please provide your rates, availability, and examples of similar projects you have completed. I am loo...
...focus on core functionalities with the potential to integrate AI features in future updates based on user feedback and demand. Core Functionalities: Camera Integration: Users should be able to access the smartphone camera to take pictures of receipts. Data Storage: Extracted data should be organized and stored in an online spreadsheet service. Image Storage: Images of the receipts should be stored in an online file storage service with references noted in the spreadsheet. User Authentication: Implement secure user authentication to allow users to access their data securely across devices. UI/UX: Design a user-friendly interface that is intuitive and easy to navigate for users with varying levels of tech-savviness. The design should be responsive and follow current best p...
I'm in need of high-quality, carefully sourced leads of home sellers and owners in the Greater Toronto Area. The primary goal of this project is lead generation to expand clientele. The information I need for these leads includes: • Contact Information: Names, addresses, phone numbers, etc. • Property Details: Specifics about the property they own, including size, location, and any other pertinent details. Ideal candidates for this task will have experience in real estate lead sourcing, with a special focus on the Toronto area. Knowing the local market and having the ability to accurately pinpoint leads matching my needs is crucial. The leads should be provided in an easy-to-use Excel spreadsheet. Proficiency in data entry and knowledge of Excel is expecte...
I am in need of an analyst to crunch numbers from 74 survey responses provided in an Excel spreadsheet. The core goal of this project is to calculate statistical measures. However, I have not specified which statistical measures should be calculated. Therefore, I am looking for someone with the expertise to suggest and calculate the most suitable measures. The ideal candidate will have a strong knowledge of statistics, keens insights to guide decision-making, and proficiency in Excel.
Hello, we are working now on script/macros to be uploaded in Confluence, that will do following: 1. Call to Jira issues according to JQL format request (filter request) 2. Take data from pre-defined fields of each Jira issue 3. Create a report on the confluence page in form of table. This is for Data Center Confluence. We have developed the script attached (authotification tokens and some details were deleted due to confidential information), but it didn't work both on the cloud and data center versions. We don't know why. We suspect it may be connected to CORS configuration. So the applicant needs to be familiar with such issues. We will not provide access to the actual system, but can share screen, if required. We are looking for a consultation - t...
