Sum multiple data multiple cells excel jobs
...Work on summaries at your own pace. Competitive Pay: Earn 3 dollars per completed chapter summary. Ideal Candidate: Medical student with a solid foundation in gynecology. Strong reading comprehension and summarizing skills. Ability to identify key points and translate them into clear, concise language. Excellent writing and editing skills. Quick Screening Process: Rapid Knowledge Check: A few multiple-choice questions to assess your understanding of core gynecological concepts. Summarization Challenge: Summarize a short excerpt from a medical text on a gynecological topic. Ready to Ace Your Exams (and Help Others Do the Same)? Submit your resume or portfolio and complete the short screening process. Let's create valuable study resources for fellow medical students! Chang...
...warehouse management systems built by our tech team. Our goal is to move to ERPNext because it's easier to scale there. And also to be able to have our accounting team work there. The goal is separated on multiple phases but the first one and the most important is to build our dashboard on ERPNext by copy pasting what we have in the in-house built dashboard and creating DocTypes. After that, we'll create a new request for the other phases. Key features: - Custom field creation: The ability to create custom fields tailored to our specific needs. The system should allow for various data types, validation rules, and labels. - Custom form creation: The option to design custom forms with the ability to drag and drop fields where needed. The form should be easily m...
I'm currently using Outlook as my email provider for a single domain. I'm looking for an expert to help configure my DNS settings to SETUP multiple third party mail services. 1. Domain is registered on godaddy. 2. Currently we are using brevo and teh same is configured in DNS goodaddy 3. We are not able to use godaddy mail services after coniguring brevo 4. We would like to setup sendgrid mail services which mean we should able to use all the mail services we need some one who can help us configure these services on godaddy on single domain
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm looking for an experienced Java developer to help me with my test cases. The primary focus of these tests is Integration testing for multiple components. Ideal skills and experiences: - Java programming - Expertise in Mockito/Power Mockito - Experience in integration testing - Ability to work with existing test cases and refactor them.
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I'm seeking an architect with exceptional 3D design skills to create a modern interior design for multiple rooms. Key Project Details: - Interior Design: The design should be focused on the interior of the space. - Modern Style: The preferred design style is modern, so the ability to translate this into 3D designs is crucial. - Multiple Rooms: You will be designing for more than 6 rooms, so experience in large scale interior design projects is beneficial. Desired Skills: - Proven experience in 3D interior design, particularly for large projects - A strong portfolio showcasing modern designs - Excellent communication skills to understand and translate my vision - Proficiency in relevant software for creating 3D models and renderings I'm looking for someone who can...
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
Project Description: We are seeking an experienced Google Ads expert to manage and optimize multiple Google Ads accounts targeting the niche of dog owners. The selected freelancer will be responsible for managing 10 different Google Ads accounts and optimizing a total of 15 different campaigns over the course of one month. Responsibilities: Account Management: Manage and oversee 10 Google Ads accounts effectively. Campaign Optimization: Optimize a total of 15 campaigns within the dog owners niche to improve performance and ROI. Keyword Research: Conduct thorough keyword research to identify high-performing keywords relevant to the niche. Ad Copy Optimization: Continuously optimize ad copies to improve click-through rates and conversions. Bid Management: Monitor and adjust bidding...
I'm launching a brand new Arabic podcast focusing on news and current affairs. My vision is to build a strong online presence across multiple platforms, including YouTube, Facebook, Twitter, and TikTok. I aim for this project to be the first successful podcast of its kind, connecting the community from New York to Egypt. Key Requirements: - Arabic fluency and understanding of cultural nuances - Proficiency in audio production and recording - Experience in podcasting or radio production - Social media management or marketing skills - Ability to create engaging content for different social media platforms - Knowledge of current affairs and news reporting - Familiarity with the podcast landscape and trends Your role will be to help me: - Develop a podcast format that will resona...
...developer who can create a comprehensive boat booking software. This solution should be able to handle both online and offline bookings, streamlining our operations and ensuring a seamless booking experience for our customers. Essential Features: - Calendar integration: This is pivotal for tracking bookings, availability, and scheduling maintenance. Previous experience in integrating software with multiple calendar platforms is beneficial. - Payment processing: The software should be able to accept, process, and track payments in a secure manner. Experience in payment gateway integration is a plus. - Customer notification system: It should be capable of updating customers on booking status, payments, and upcoming trips. Experience with automated messaging systems and customer c...
I'm in need of a talented developer to design and establish a platform that connects volunteers with nursing homes. The features do include: - User profiles which will consi...communication. The user roles on the platform are divided into two categories: - Volunteers who will utilize this platform to seek service opportunities in nursing homes. - Administrators in charge of monitoring and managing the platform. The ideal freelancer for this project should have experience in web development with a focus on user interface design and backend functionality. Balancing the needs of multiple user roles, putting together a powerful search system, and establishing a secure messaging protocol are crucial aspects of this project. Prior experience in building similar platforms will be...
I'm in need of a creative graphic designer who can combine two distinct team logos into a single modern and innovative design. The resulting logo should stand out and...out and be memorable, yet still reflect the essence of the two original logos. Key Deliverables: - A single, distinct logo that combines the essence of two original logos - The design should be modern and innovative - The logo should be suitable for a special event, so it must be engaging and appealing Ideal Skills and Experience: - Proven experience in logo design, especially in combining multiple elements into a single design - Strong understanding of modern design trends - Experience in creating logos for special events or unique purposes - Good communication skills to understand the client's visio...
I'm in need of a skilled developer to add a custom feature to Invoice Ninja. The following required features need to be developed: 1. Receipt on top of payments module - int...CSS can be given. CSS can also be hard coded, only used for RTL. but should only be enabled if user selected either Hebrew or Arabic as language. 3. Expenses sub category - expenses add a sub category (now only category exists), also define how much % of the expense is approved. For example, in some countries if you report car gas expense, only 45% will be acknowledged as expense from the total sum. so 45% from the total expense should go into the reporting. The ideal candidate will be an individual or team with extensive experience in Invoice Ninja, PHP, Laravel, CSS, HTML and proficient in creating c...
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
I am embarking on an exciting venture of starting an Arabic podcast with a focus on 'News and Current Affairs.' My vision is to build a robust online presence through multiple platforms, namely YouTube, Facebook, Twitter, and TikTok. Your Tasks: - Helping start and build the podcast - Utilizing these platforms for maximized reach and engagement - Developing a strategy for weekly interaction with my audience The ideal freelance partner for this project will have: - Proven experience in starting and promoting podcasts - Deep understanding of the mentioned social media platforms, especially in relation to the Arabic-speaking demographic - Experience in fostering viewer/listener interaction - Interest or background in news and current affairs would be a bonus. Project su...
...sample post OR reels for Expathy and submit it between 20th of May- 26th of May. Colors: Green (#012b28) Yellow (#ebb42c) We are looking for an experienced social media expert who can manage and promote EXPATHY across Facebook, Twitter, and LinkedIn. Key Responsibilities: - Content creation - Design via Adobe programs such as graphic designs and video content - Management: Posting content multiple times a week across all platforms - Making collaborations Ideal Candidate: - Proficiency in managing Facebook, Twitter, and LinkedIn - Demonstrable experience in social media marketing - Ability to create and curate engaging content - Strong analytical skills to assess the performance of the social media accounts - Excellent communication and organizational skills The project w...
I am in need of a professional web developer who can create a comprehensive coaching platform for me. The website should have the following features: - Batch Management: I need to be able to create multiple batches for different subjects or courses. - Video Lecture Upload: I should be able to upload video lectures for students to watch online. - PDF Upload: I should be able to upload PDF files for students to view or download. - Test/Quiz Management: I need a feature where I can create and manage online tests or quizzes for the students. In addition, the website should have stringent access control measures. Specifically, the following measures need to be implemented: - Password Protection: The website should require a password for users to access the content. - User Login and Re...
As part of my project, I'm searching for an exceptionally creative and experienced designer who can design a more interactive element for multiple choice questions or quizzes. The overall objective is to increase user engagement in a fun and education-forward way. Key Responsibilities: • Create a design with interactive elements including both animations and sound effects. • Design needs to be appropriate and appealing towards a broad age group, ranging from children to adults. Ideal Candidate Skills: • Proficient with user interface and user experience design. • Knowledge of how to blend animations and sound effects into the design while keeping it user-friendly. • Previous experience designing interactive quizzes or educational tools will be a big...
...user-friendly navigation. The project involves creating an e-commerce website primarily hosting catalogues and products. Ideal Qualifications: - Experience in designing e-commerce platforms - Proficient with responsive design - Skilled in creating customizable layouts - Outstanding ability in designing user-friendly navigation Deliverable specifics: - The website must be responsive across multiple devices - Users must be able to customize the site layout to their personal preferences - Navigation of the website should be intuitive and effortless for users Branding: - Specific colors and branding elements will be provided to ensure that the site aligns with our brand identity. Having a strong knowledge in e-commerce website design, alongside a flexible working style, woul...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, ...
What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help
...documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurate...
We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...
I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes
I'm seeking a skilled Unity developer who can work on the development of a tower defense strategy game. The core mechanics of the game are ready. Your only job will be syncing the data across all clients in a match. Skills requirements: - Expertise in Unity game development - Experience in Photon Engine - Knowledge about Github will be a bonus In this project: - You will create a connection between multiple clients for multiplayer gameplay - Sync the data across all clients (Don't bid if you have no idea about Unity or Photon. AI proposals will be discarded too)
I'm seeking a skilled developer to create a trading bot for me. The bot should be compatible with TradingView and be able to implement multiple trading strategies, including trend following, mean reversion, and breakout. The bot should primarily use moving averages, RSI (Relative Strength Index), and Bollinger Bands as technical indicators. Key responsibilities include: - Developing a bot compatible with TradingView - Implementing the specified trading strategies (trend following, mean reversion, breakout) - Incorporating the key technical indicators (moving average, RSI, Bollinger Bands) into the bot's strategy Ideal Skills and Experience: - Proficiency in TradingView platform - Strong understanding of various trading strategies (trend following, mean reversion, breako...
...of the project is the ability to handle WebSocket connections seamlessly. This will include both the initial handshake and the ongoing management of WebSocket connections. - Protocol Flexibility: The completed reverse proxy should be able to support multiple protocols. This is necessary for the project's success, as it will be used in a diverse network environment. Ideal Skills and Experience: - Proficient in reverse proxy development - Experience with WebSocket protocols - Strong understanding of traffic management - Familiarity with multiple network protocols - Ability to code efficiently and with scalability in mind This project will require a developer with a strong background in network programming and reverse proxy development. If you have the skills and exper...
...Android platforms. Key Features: - The app should collect information from various automobile insurance companies in one location which will help users to compare and choose the best option. - The ability to generate quotes from multiple insurance companies is a must. - It should also support claim reporting and policy management functionalities. Ideal Candidate: - Experience in developing insurance related mobile applications is desirable. - Must have previous experience creating apps for both iOS and Android. - Knowledge in integrating third-party APIs to fetch data. - An understanding of the insurance industry's standards and requirements is highly beneficial. I encourage interested and eligible freelancers with a proven track record to place their bid. Your pro...
I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.
I'm in need of a talented graphic designer to create a minimalist design for my brand. Key Requirements: - Proficient in creating minimalist designs - Able to translate ideas into a simple yet powerful design - Experience in perfect shape I'm looking for a creative individual who can deliver a final design without the need for multiple iterations.
I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is sp...
I'm in need of an intricate financial model designed for a residential property that focuses on calculating equity investments. Specifically, I want: - Informative analytics on 'Return on Equity', to evaluate potential profits over time. - An illustration of 'Cash Flow Distribution', to comprehend the income dispersions. - Analysis on 'Equity Multiple', to understand the total cash received against the total equity invested. Ideal freelancers will have a strong background in financial modelling, specifically pertaining to property investments. Understanding of debt financing, equity investments and capability in generating these specific outputs is critical.
I'm in need of a skilled and versatile graphic designer who can handle multiple types of design work. Key Requirements: - Logo Design: I need a distinctive logo that helps establish my brand identity. - Print Design: The designer should be able to create visually appealing designs for various print materials. - Social Media Graphics: I require attractive and engaging social media graphics that can boost my online presence. The project has three distinct purposes: - Branding and Identity: The designer should be able to capture the essence of my brand in their designs. - Marketing and Promotion: The graphics should be able to effectively market and promote my business. - Communication and Information: The designs should be able to effectively communicate information about my p...
I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.
I am looking for a creative and experienced soft toy designer. My primary focus is on creating toys for children aged 3-8. The specific range of the toys wasn't selected so open to stuffed animals, plush dolls, and custom characters. Key Requirements: - Able to work with multiple materials including cotton, synthetic fibers, and natural fibers. - Experience in designing soft toys specifically for children aged 3-8. - Ability to design a wide range of toys from stuffed animals to custom characters. Skills and Experience: - Experience in toy design. - Understanding of child safety standards for toys. - Strong creativity and imagination. - Knowledge of materials and production processes. Looking forward to transforming your creativity into an engaging and safe toy for chil...
...in need of a full-fledged ready made e-commerce marketplace that supports multiple vendors, with an emphasis on vendor dashboards. Here's a breakdown of the key components and features I'm looking for: - **Purpose**: The platform will be primarily for selling products. It will be app-oriented, with main categories dedicated to specific apps, and subcategories under each app to organize products effectively. - **Vendor Dashboards**: Critical for vendors to manage their products, sales, discounts, wallet, delivery options, and other details effectively.. - **API Integration**: I need a sophisticated API to allow for seamless integration with different systems and services, allowing for extended functionality and data exchange. Payment integration with all major ...
I'm in need of an expert developer to establish a pop-up chatbot for my PHP project, and an admin's data analytic dashboard. Chatbot Requirements: - Interactive conversation capabilities: Enable human-like engagement with users. - Natural language processing: Understand and respond accurately to user inquiries. - Integration with existing database: The bot should pull information from our present database to answer user questions. Admin's Dashboard Requirements: - Data visualization: Clear, intuitive graphical representation of data is required. - Data filtering: The dashboard should feature tools for sorting through data effectively. - Registered User Counts: Display the number of registered users on our platform. - Service Booking R...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
...existing web crawler code to include specific features I require. This includes the ability to extract and filter data from multiple websites. - **Data Management:** I expect the total scale of the data to be relatively small, so the freelancer should have experience handling data sets of this size. - **Data Analysis:** After the information is extracted, I intend to use it primarily for data analysis. The freelancer should have a good understanding of how to structure data for this purpose. Ideal Skills & Experience: - Proven experience in customizing web crawlers and managing data. - Proficient in data analysis and structuring for insights. - Familiarity with handling small scale data sets. - Strong comm...
I'm in search of a talented graphic designer to create a combination text and icon-based logo for my food and beverage business. Resonating with the simplicity and recognizability of McDonald's logo is key in this project. Key Responsibilities: - Design an eye-catching combination logo - Proffer multiple design concepts for selection - Refine and ultimately finalize the selected concept Ideal Candidate: - Exceptional skills in graphic design - Previous work in food and beverage branding - Portfolio reflecting a keen sense of balance, simpleness, boldness and safe-color toolkit, implying a McDonald's esthetic. Revise design iterations till satisfaction. Your expertise in making a design that's simple yet bold, like that of McDonald's, will be invaluabl...
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I'm looking for a skilled casino games developer based in Jaipur, India. I have a preference for face-to-face communication, so I'd prefer to work with someone in my local area. The games I'm looking to develop include Slot machines, Poker games, and Roule...skilled casino games developer based in Jaipur, India. I have a preference for face-to-face communication, so I'd prefer to work with someone in my local area. The games I'm looking to develop include Slot machines, Poker games, and Roulette games. Key Requirements: - Proficiency in developing casino games, specifically Slot machines, Poker games, and Roulette games - Experience in developing for multiple platforms (Mobile devices, Desktop, Web browsers) - Ability to communicate effectively and work ef...
I require the immediate assistance of a skilled graphic artist to cre...will be used on my van's design, so experience in creating graphics that can be applied to a vehicle is a great advantage. I need these graphics as soon as possible, hence I'm looking for a responsive and efficient professional who can deliver quality work swiftly. Ideal Skills: - Proficient in graphic design tools like Adobe Photoshop or Illustrator. - Experience with creating graphics for multiple social media platforms. - Prior experience with vehicle graphics a plus. If you can deliver high-quality work promptly and have the skills necessary for this job, I'd love to hear from you. See sample attached ...using the TESLA VAN here ... NO WINDOWS IN YOUR DESIGN PLEASE !!!!!!!!!!!!!!!!!!!!...