Sql forms data entrymunkák
I am in need of a freelancer to help with copy typing from online databases. - I need the data to be copied accurately from these online databases to a specific format. - The entries are in text format, so you would need to have good typing skills and attention to detail. Ideal Skills: - Proficient in typing and data entry - Experience with online databases - Detail-oriented and accurate in data entry.
...professional who can transfer my Firebase data to a SQL database in real-time, and keep it updated on a daily basis. Key Requirements: - Migrate Firebase data, including user, product, and transaction data, to an SQL database in real-time. This will involve setting up the necessary infrastructure and ensuring that the data is transferred and stored correctly. - Implement an update mechanism to sync the Firebase and SQL databases daily. This is crucial for maintaining the integrity and consistency of the data across both platforms. - Ensure that the migration and updating processes are efficient and do not cause any disruptions to the functionality of the databases. Ideal Skills and Experience: - Extensive experience with Firebase...
Job Title: Festival Event Planner Location: Asheville, NC Job Type: Temporary Contract Description: HauntFest, LLC is a dynamic event management company specializing in organizing unique and engaging festivals and events. Our team is passionate about creating memo... If you're ready to take on the challenge of planning an unforgettable spooky festival in Asheville, we want to hear from you! Please submit your application with resume, cover letter, and/or portfolio showcasing your relevant experience and creative vision. More Details: Apply Now! HauntFest, LLC @
...design and build a basic data warehouse utilizing MS SQL Server's various services such as SSIS, SSAS, and SSRS. This includes analyzing and reporting on large sets of data while integrating and transforming data from different sources. Key specific requirements include: - Creating a basic data warehouse structure. This should involve a few tables and relationships. - Using SSIS (Integration Services) for transferring and integrating data. - Implementing SSAS (Analysis Services) for performing advanced analytics. - Utilizing SSRS (Reporting Services) for generating comprehensive reports. The ideal freelancer for this gig should have: - Proficiency in MS SQL Server, specifically in SSIS, SSAS, and SSRS. - Experience in designing an...
I am seeking a professional with proficiency in MS SQL Server’s SSIS (Integration Services), SSAS (Analysis Services), and SSRS (Reporting Services) to create a basic level, sample case for using data warehousing. Specific Goals: - Develop a data warehouse for analyzing business data. - The case should familiarize the users with the concept, rather than providing an advanced level of expertise. In SSIS Integration section, the following concepts are to be included: - Data Extraction - Data Transformation - Data Loading The ideal candidate will have a solid understanding of data warehousing and extensive experience with MS SQL Server’s services. A knack for simplifying complex information and a background in tra...
...specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimization, while significantly improving the speed and usability of my perso...
I'm looking for a data entry professional to help me with extracting specific information from various PDF files. Your main task will be to accurately input data from my PDF files into a specified template that I will provide. Key Project Details: - Data Entry: Extracting specific information from PDF files - Accuracy: Precision is crucial for this task - Timing: While speed is important, accuracy is the top priority Ideal Skills: - Experience in data entry, particularly from PDF files - Attention to detail and commitment to accuracy - Ability to work with provided templates - Good communication skills - you may need to ask for clarification on certain data points If you've got a proven track record in data en...
...proficient understanding of SQL databases to help resolve an issue that's negatively affecting my website's performance. The problem is specific to the updating of posts; every time an update is made it takes exceedingly long, undermining efficiency and productivity. We've identified that it's related to wordpress WPML plugin's SQL queries. To solve this issue, I'm specifically looking for a professional who can optimize our database. Familiarity and experience with the WPML plugin is a must. Additionally, we've made several modifications to our database structure and queries which include tables, SQL, and indexes modifications. Skills Required: - WordPress development - SQL database optimization - Experience with WPML pl...
I'm seeking an expert web developer who can build an informational website aimed at the general public. Your duties will not stop at designing a user-friendly layou... - Modern and industry-appropriate web design - ("Manageable" "original" design with WordPress CMS infrastructure) - 15-20 service page landing page design - Compatibility regulations with mobile devices - On-site search engine optimization - Search Console registration - Google Analytics record - Social media links - Conversion-focused communication links - Modern and easy to fill out contact forms - Live support application customer communication module - Standard privacy and security practices - Production and updating of SEO compatible content - 1 year maintenance, security, updates, backup...
I am seeking an experienced video editor who can manage the task of turning my YouTube REACTION videos, which are typically over 1 hour long, into compelling shorts/reels. This is a long term position for the ri...video content. - Ability to work within strict timeframes. - Keen attention to detail. - Strong understanding of YouTube's shorts/reels formats and regulations. Your role will be instrumental in repurposing our educational material into an engaging, digestible format. Please provide examples of your previous work, specifically showcasing your aptitude for turning long duration videos into short forms. I need ONE example completed before I can hire you (& that will be paid for once you are hired). The link to the first video is here:
...clean and minimalist design and a penchant for detail. Please note that this is NOT a one time development and there is NO fixed scope of work here. Looking to engage someone on a "as and when needed" basis and not for a specific project I require consistent work on various tasks such as: - Creation of new web pages - Designing unique and appealing web pages - Developing and managing online forms - Consistent backend maintenance Frequent tasks in backend maintenance will involve, but not limited to, the following: - Managing plugin updates - Implementing security updates for website security - Handling content management duties - Monitoring website performance and security The ideal candidate is one well-versed with WordPress and has a proven background in web de...
I'm seeking a proficient freelancer with a strong knack for vehicle modelling to assist me with my current project. Specifically, I'm focusing on modelling a utility trailer, and I anticipate a high level of detail to ensure that the 3D stills closely resemble the vehicle. I won't need textures at this stage, as I'll incorporate them later myself. Instead, I simply require the gro...what I need for this project. The ideal freelancer for this task should be well-experienced in 3D modelling, particularly in designing the intricate details of vehicle interiors. They must pay high attention to detail to ensure that the vehicle model closely mirrors the original plans. Your ability to deliver high-quality work, especially when it involves replicating existing designs in mod...
A hero banner image for our homepage. Requirements: - Use the image of the bay as the background or ...from the brand, off-white is probably fine, see for colors - Container edges have shadow effect so it looks like it's sitting above the background photo - Container is a display for 3 roll-on product images with the words "For Targeted Relief" in Raleway font either below it or above the product images. - This is the most important factor in determining the winning entry. - Deliverables: raw files with background photo, visual container, product photos, and tagline all on separate layers. The .png and .webp files at 72dpi, 1800 pixels wide, and height anywhere from 400-600 pixels, height is up to you based on space you need for your design. ...
I am looking for a talented professional who can convert my existing 6-10 page PSD design into a fully functional WordPress website. Key Responsibilities: - Utilize my PSD design to create a visually appealing, user-friendly WordPress site. - Integrate a contact form into the website. - Ensure website content blocks...Responsibilities: - Utilize my PSD design to create a visually appealing, user-friendly WordPress site. - Integrate a contact form into the website. - Ensure website content blocks and images are easily editable for the end user. Ideal Candidate: An experienced developer with a strong background in PSD to WordPress conversions, and expertise in creating editable content blocks and integrating contact forms. Proficiency in modern WordPress and web development standar...
I'm looking for a Python expert with solid experience in SQL to complete an assignment for me. This project requires: - Thorough understanding of Python - Strong skills in SQL - Ability to focus on details and meet deadlines I'm trying to connect to a database but it's not connecting to my users. My code isn't getting any errors tho Your task will be to apply your Python and SQL knowledge to complete specific tasks provided in the assignment. Eagerness to share ideas and take project direction positively will be ideal. Your experience in Python and SQL will be a deciding factor. I am looking forward to seeing your smart solutions and getting the assignment done to my satisfaction.
I am in need of an experienced and proficient WordPress developer. The layout for a temp site is ready and needs to be replicated. This project calls for the inclusion of specific features like: • A booking page The contact form should be designed for scheduling appointments and should be able to collect: • Name • Email • Phone number The ideal freelanc...for the inclusion of specific features like: • A booking page The contact form should be designed for scheduling appointments and should be able to collect: • Name • Email • Phone number The ideal freelancer for this project should have good command over WordPress and experience in building websites with appointment scheduling features. Skills in creating effective and user-friendly cont...
I am in need of an English writer who is adaptable in producing various forms of content. As the type and purpose of the content are broad and not yet strictly defined, flexibility and a wide range of writing abilities are key. Ideal Skills: * Exceptional written English skills * Ability to adapt to different writing styles and tones * Capable of creating engaging content for different purposes * Proficient in research Experience: Ideally, freelancers should have: * Proven experience in writing diverse content such as blog posts, articles, and copywriting * A diverse portfolio showcasing versatility Application: Since the necessary information for applicants wasn't specified, it would be beneficial if freelancers include: * Previous work samples * Relevant experience * Deta...
Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...
...need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong un...
I need an expert in Microsoft Excel to create a functional, cleanly-designed household income and expenditure sheet from scratch. This task involves: - Data entry: This household finance sheet should allow for comprehensive tracking of earnings and spendings. - Formulas and calculations: The spreadsheet should automatically compute totals thereby providing a real-time, holistic view of my financial landscape. - Formatting and design: The sheet should be intuitively organized and visually appealing for ease of use. I haven't decided on a specific template yet, so there's an opportunity to be creative and propose a clear, easy-to-understand format. The sheet should have a basic level of detail, categorizing different types of income and expenditure, but without the...
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
I'm seeking a freelancer proficient in working with Timeslips legal software to assist with preparing billing and invoicing tasks. Key Requirements: - Data Entry: You'll be expected to handle the data entry and billing activities using Timeslips. - Invoice Generation: You will not need to customize the automated invoice generation, as we will not be using this feature. Ideal Skills and Experience: - Prior experience with Timeslips or similar legal software. - Strong understanding of billing and invoicing processes. - Proficiency in data entry with an eye for detail. Please include any relevant experience you have with Timeslips in your bid.
I need comprehensive market research conducted for my upcoming valet trash company. - **Industry Focus**: Valet...cities. Prior experience in the waste management industry would be an added advantage. Your research should cover the following aspects: - Market size and growth potential for valet trash services in the specified cities. - Detailed analysis of the key competitors A, B, and C, and their market share. - Consumer trends and preferences in regards to waste management services. - Potential barriers to entry or risks associated with entering the valet trash market in these cities. Please make sure to outline the methodology you plan to use for the research in your bid. It is crucial that the information provided is accurate, relevant, and can be used to inform our business...
...required, as the site should be fully manageable through the Divi Builder post-launch. - Custom Booking Form: Integration of a custom booking form similar to that on [Maid in Victoria](), using Gravity Forms with icon-based inputs for beds and baths, avoiding traditional dropdowns. Project Deadline: The website must be completed and delivered within one week. Budget: We have allocated $250 for this project. Ideal Candidate: - You must have proven experience with WordPress, particularly with the Divi Builder and Gravity Forms. - A portfolio that includes previous work with Divi and custom form implementations is essential. - You should be able to work efficiently under tight deadlines and produce a quality product with minimal need for revisions. Ask for
I need an experienced database developer to create a highly functional Access database. Required functionality: - Robust data entry and retrieval system - Capable of generating custom reports and analyses - Seamlessly integrated with other software The database will store: - Customer information - Product inventory - Sales transactions Expectations: - Development of significantly more than 10 tables - Efficient organizing and handling of these tables The ideal candidate should possess significant experience working on Access Database creation, be able to confidently handle extensive data and complex systems integration. Expertise in table management and data analysis would be an added benefit.
I'm seeking a skilled developer to create interactive inspection forms for my business. Key functionalities needed: - Ability to collect and record property information - An inspection checklist for effective recording and tracking - Section for maintenance recommendations - Capacity to upload multiple photos per form The ideal candidate for this project should be comfortable working with form-building software and have knowledge of incorporating photo upload features into a digital fillable form. Your experience and understanding of my needs are vital in achieving an efficient and effective solution.
Position: Remote Data Entry Specialist Schedule: Monday - Friday Working Hours: 3:00 am - 11:00 am CET (Central European Time) (Converts to: | 6:30 am - 2:30 pm India ST, | 9:00 am - 5:00 pm China ST, | 11:00 am - 7:00 pm Australian EST, | 1:00 pm - 9:00 pm New Zealand ST, | 3:00 pm - 11:00 pm Tahiti time) Requirements: - Attention to Detail: Spotting errors is your superpower! - Professionalism: We take our work seriously. - Remote Work Experience: Navigate virtual waters like a pro. - Dependability: We count on you to stick to schedules and meet deadlines. Responsibilities: - Data Entry: Accurate and efficient input of information. - Data Management: Ensure data consistency and integrity. - Communication: Collaborate with the team remotely...
I'm in need of a skilled and capable data entry freelancer. Your main task will be focused on: - Product Catalog Data Entry: You will be required to accurately and efficiently enter product details, descriptions, specifications, and images into our web-based system. Ideal Skills and Experience: - Detail-oriented with strong organizational skills. - Experience in eCommerce product data entry. - High-speed internet access. - Excellent knowledge and understanding of online data entry processes. - Strong computer and typing skills. Your commitment to meticulous data entry is of utmost importance as the information directly impacts our online product catalog. Experience in this line of work is highly preferred.
I'm in need of a freelancer to assist with data entry tasks. The project involves entering text data from an online source into a Google Spreadsheet. Here's an overview of the requirements: - The data is available on a single website, but will require multiple searches, clicks, etc, and is not able to be scripted. - The volume of data is moderate, roughly about 300 entries. - The length of each data piece is short, requiring less than 10 characters per entry. Ideal candidates for this project should have: - Excellent attention to detail to ensure accurate data entry. - Proficiency in English to understand and input the text data appropriately. - Experience with data entry tasks, particularly fr...
Position: Remote Data Entry Specialist Schedule: Monday - Friday Working Hours: 11:00 am - 7:00 pm CET (Central European Time) (Converts to: 10:00 am - 6:00 pm WAT/WEST | 12:00 pm - 8:00 pm EAT/EEST) Requirements: - Attention to Detail: Spotting errors is your superpower! - Professionalism: We take our work seriously. - Remote Work Experience: Navigate virtual waters like a pro. - Dependability: We count on you to stick to schedules and meet deadlines. Responsibilities: - Data Entry: Accurate and efficient input of information. - Data Management: Ensure data consistency and integrity. - Communication: Collaborate with the team remotely. Duration: Indefinite. How to Apply: Prove your attention to detail by a) stating your time zone at the start...
I need an AI language generation model that can create a completely new language based on user prompts. - The language must be highly realistic and usable. - The prompts can range from textual descriptions to linguistic parameters and even cultural or historical contexts. - The AI should be able to deliver the generated language in both written and spoken forms. (For written, the language should be per the prompt. Either Latinbased or an entirely new script or derived from existing scripts) The ideal freelancer for this job should have advanced knowledge in AI, Natural Language Processing, linguistics, and machine learning. Experience in creating language models or AI generators is a huge plus. The ability to deliver a highly realistic and usable language with written and spoke...
I need a proficient Apache Airflow and SQL consultant to provide expert-level support, specifically focused on complex query formation. - Specific Project Tasks - Implementing Apache Airflow - Creating complex SQL queries - Handling financial transaction data The ideal collaborator should have: - Proven experience working with Apache Airflow - Proficient in SQL, with an emphasis on generating complex queries - Prior experience managing financial transaction data is highly desirable. The objective is to streamline the handling, management, and processing of large volumes of financial transaction data, ensuring efficient and accurate results.
I'm on the hunt for an expert with extensive experience in transferring data from Excel to Word. I have an excel file with 210 opponents of my football team, every opponent has it's own worksheet. In this file there is the name, city, maybe a remark about the name, the first season we played against them, the last season we played against them and the aggegare score (number of times played, won, drawn, lost, points, goals scored, goals conceded) both home and away. See the sample file as attached. The goal of this project is to have these 210 opponents in the Word file I attached. As you can see I have down the first two opponents already so you know what this project is about. Key Responsibilities: - Transfer data from one Excel file to Word meticulously Id...
I'm in need of a professional to create a website that serves as an informational hub for my business. The target audience for this site will be primarily business professionals, so it's essential that the design and functionality are catered towards this demographic. Key Features: - The website should in...easily get in touch with us. This is crucial for us to build and maintain relationships with potential clients and partners. Ideal Skills and Experience: - Proven experience with designing and developing websites focused on the business sector - Strong understanding of user experience and design principles that appeal to business professionals - Proficiency in implementing and customizing contact forms - Excellent communication skills and a track record of deliveri...
I am in need of a comprehensive school examination system. - The system should cater to three primary user groups: students, teachers, and administrators. It's crucial that the system is user-friendly for all these categories. - Key features should include online examination capabilities, a question bank, and an automated grading system. To apply for this project, kindly include your past work in similar systems. Your previous experience in this area will be a significant asset. Thank you
Kérjük, regisztráljon vagy jelentkezzen be a részletek megtekintéséhez!
I am looking for a virtual assistant who is ready to work on a basis of undefined tasks. You should have a high-performance Windows system to collaborate effectively on various projects. Although the specific tasks have not been completely outlined, you should be prepared to handle potential responsibilities such as: - Email management - Calendar organization - Data entry Furthermore, there may be instances where research tasks will be needed. However, these assignments are not confirmed as of this moment. The hours per week required for this collaboration are not defined at this time. Therefore, flexibility is preferred. Ideal skills and experience: - Strong knowledge of Windows systems - Experience as a virtual assistant or in a similar role - Strong organizational sk...
I'm seeking a freelancer skilled in data entry to assist in inputting plain text files and formatting the entered data as a list. Strong detail-orientation, precise data input skills, and familiarity with working with plain text files are necessary for this project. A successful completion of this project would involve: - Accurate data input from plain text files - Careful formatting of the entered data as a list - Efficiency and attention to detail Your proven track record in similar data entry projects could make you a great fit for this job.
I'm looking for a skilled web developer to create a professional, informational website. Key Points: - The website's main purpose is to disseminate information so I need it to be visually appealing and easy to navigate as it's targeted at professionals. - The site should include a contact form to make it easy for visitors to reach out to me. Ideal ...information so I need it to be visually appealing and easy to navigate as it's targeted at professionals. - The site should include a contact form to make it easy for visitors to reach out to me. Ideal skills and experience: - Proven track record in developing informational websites. - User interface design to ensure the website is both professional and user-friendly. - Proficiency in creating contact forms that ...
I'm in need of a diligent and detail-oriented freelancer who can handle various data types including text, numbers, and images. The scope of work includes: - Inputting data provided through both uploaded files and manual entry - Demonstrating great accuracy and attention to detail while performing this task - Ensuring high quality through thorough review and correction of work as necessary The desired format for the output will be discussed as per project requirements. Ideal skills for this job: - Prior experience in data entry roles - Proficiency in handling different data types - Exceptional attention to detail - Familiarity with various data entry software tools will be a plus. We need a well organised person to help ad...
I need a freelancer to assist me in entering text data from less than 100 pages of handwritten notes. - Data Type: The data is exclusively text-based. - Data Provision: I will provide you with the handwritten notes. - Data Volume: It's less than 100 pages that need to be transcribed. The ideal candidate for this project will have a good command of English, excellent typing and transcription skills, as well as a keen eye for detail. Experience in data entry, especially handwritten text, would be a plus.
I'm setting up a short-term project that requires versatile data entry specialists. Your main tasks will be: - Entering both text and numerical data accurately. - Handling no more than 100 data entries. The deliverable format: - Send the final work in an Excel Spreadsheet, ensuring the data is clean and organized. Desired skills and experience: - Proven track record in data entry; any previous experience working with Excel Spreadsheets is a plus. - Attention to detail, accuracy, and confidentiality. - Quick turnaround time due to the small volume of data. Bid if you're ready for this quick, but important task.
I am seeking a highly organized and detail-oriented freelancer who can beautifully manage the task of entering a significant amount of data ranging from text documents, spreadsheets, to data from forms. The volume of the data will fall approximately between 100 to 500 pages/rows which will require meticulous attention. Skills and Experience needed: - Proven experience in Data Entry - Proficiency in dealing with multiple types of data - Accuracy and fast typing skills - Basic comprehension of PDF format The final delivery file should be precisely formatted in PDF and needs to mirror the original data seamlessly. Only bid if you possess the right skills to perform this task efficiently and meet the quality standards.
I need a reliable and accurate data entry specialist. Key Requirements: - Proficiency in data entry - Attention to detail - Accuracy and reliability If you have a penchant for precision and are looking for a straightforward data entry project, this task might be a good fit for you.
I'm in need of a skilled SQL developer to assist with the creation of 2 stored procedures in MySQL. These procedures are essential for managing calibration data in our system and compare new data with the calibration data. Key Objectives: - Develop a stored procedure to generate a calibration table (avg + stdev) - Implement another procedure for creating a score table, which will be linked to the calibration data Calibration Table Requirements: - The calibration table should include the following columns: ID, Value, CalibratedValue, StandardDeviation. These columns are critical for our system's calibration functionality. Score Table - This table will check the difference from new data to calibration data Ideal Candidate: - Pro...
I'm urgently seeking a WordPress specialist to address some key issues on my website. These include ...contact form that aligns with specific requirements. These requirements will be shared with the chosen freelancer. - Integrating Google Analytics to allow for a better understanding of website traffic and user behavior. Ideal candidates will have: - Extensive experience in WordPress, with a proven track record of resolving plugin conflicts. - Proficiency in setting up and customizing contact forms in WordPress to meet client specifications. - A good understanding of Google Analytics and the ability to integrate it seamlessly into a WordPress website. Please only bid on this project if you can start immediately and have the necessary skills and experience to deliver on thes...
...business. This dashboard will need to integrate data from our MySQL orders and stocks, and it will determine the shipment location based on certain criteria. Key Requirements: - Develop a live dashboard: The end goal is to have a dynamic, real-time dashboard that displays relevant information from our orders and stocks. - Implement shipment logic: The dashboard needs to determine the shipment location based on the stock availability. If an item is not in stock at either of our regional warehouses (Belmont and Richmond), the order should be fulfilled from our India warehouse. Ideal Candidate: - Proficient in Power BI: You should have a solid understanding of Power BI and previous experience in creating live dashboards. - Skilled in SQL: Knowledge of SQL is cruci...
...system must meticulously analyze the entire content of each document to ensure accuracy. You can expect to interact with an SQL database for fetching and storing research documents. Ideal skills for the job: • Expertise in programming with C# and .Net • Experience working with SQL databases • Familiarity with blockchain technology • Knowledge in document analysis and parsing Encouraged but not required: prior experience in developing similar plagiarism detection systems. Your primary task: • Create a reliable system to analyze and flag duplicate content in research papers from the entire text, not just specific sections. • Ensure the system efficiently interacts with an SQL database for the save and retrieve process. Achieving t...
I'm looking for a WordPress developer to create 2 custom pages First o...coding for a custom comparison form that displays a table for each query. - The comparison table should include listing details - the comparison table will include filters Second one is a statistic page that will show graphs based on filters choose by user, and will be based on listings Ideal Skills and Experience: - Proficient in WordPress development, with experience creating custom pages and forms. - Strong understanding of PHP, HTML, CSS and JavaScript for the coding of the comparison form. - Familiarity with mylisting theme Please bid with your final price. No placeholders. Please make sure to understand the request before bidding I don't want to create a website using builders but two speci...
