Excel conditional formatting if cell contains specific textроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
Перекласти 3 сторінки тексту художнього стилю з англійської на українську мову. Необхідний рівень володіння англійською мовою-C1-C2. Translating the text to Ukrainian from original(English). A level of C1 or C2 is required.
I have a text document which I need to be typed up in a PDF format. It will need to be done with comprehensive editing for grammar and spelling. Key Requirements: - Copytyping a text document in PDF format - Comprehensive editing for grammar and spelling Ideal Skills and Experience: - Proficient in typing and formatting text - Strong editing skills - Attention to detail - Experience with PDF editing software
I'm seeking a skilled C# programmer proficient in socket programming to assist with a specific task relating to establishing server connections, sending/receiving data packets, and handling socket errors. Additionally, I need help in creating a small WooCommerce database interface. The specific requirements: - Socket Programming: You will be responsible for establishing a server connection, sending and receiving data packets, and managing socket errors. - WooCommerce Database Interface: We will be integrating a small interface to manage product inventory. In this case, we are looking for basic integration - primarily focused on reading product data. The ideal candidate should have: - Proven experience in C# programming, particularly with a strong understanding of soc...
The objective is to develop an application to manage two devices via WiFi (may be increased in the future) I have two devices: Sauna and red light therapy panel. They all have a touch control panel and can be connected to your cell phone via Bluetooth and Wi-Fi. Many of the providers also offer you the mobile application already developed (as can be seen in the attached images). The idea is to make a similar application from which the two devices can be managed (set time, lighting, power, etc.). And the history of uses/settings is saved. It could also be evaluated to take the code of the two suppliers' applications and combine them into one, strongly separating them within it.
...finalize the code; Preliminary Data Exploration: Explore the data, and provide some basic summary statistics and two or three visualizations. Describe/show something interesting and/or surprising about the data. This exploration should not be exhaustive, just a highlight of a few interesting things about your data set. If you need to reduce the size of your data to fit now is the time to do that. Data Exploration: shall include a bulleted or numbered list of proposed specific data explorations you intend to carry out (include visualization). These insights are things that can be determined by examining the data through statistical analysis or other means. Predictions: shall include a prediction component (supervised learning) - include clustering, decision tree logisti...
I'm in need of a Virtual Admin Assistant to help me manage my daily work. Our dailly working time is : 10 - 7pm. We are in retail industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with tas...
I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the rig...
...backlinks and providing recommendations for improving backlink profile. Prioritized Pages: - Homepage: A thorough evaluation to ensure it's optimized for key search terms and user experience. - Product Pages: Individual assessment of these pages to enhance visibility and conversion rates. - Blog Section: Reviewing the blog content for SEO best practices, including keyword usage and internal linking. Specific SEO Techniques Used: - Keyword Research and Optimization: Assessing the effectiveness of current keyword strategy and suggesting improvements. - Link Building: Reviewing current backlink profile and suggesting additions/removals. - Content Creation: Evaluating the quality and relevance of the existing content, and providing guidance on future content creation strategie...
I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and effic...
I'm in need of a seasoned Mechanical Engineer with specific expertise in heat transfer, fluid dynamics, and thermodynamic cycle analysis to assist in the development of a revolutionary solar thermal engine patent prototype. Key Requirements: - Conducting in-depth thermodynamic cycle analysis for the solar thermal engine. - Designing the engine layout and key components to optimize its performance. - Understanding and managing the behaviors of steam vapor and condensate. - Proficiency in analyzing fluid flow, power, and pressure drop. - Knowledge of steam hammer and heat pipe behavior for this application. - Experience with developing engines within the 1-5 kW power output range is essential. Ideal Skills: - Proficiency in CAD software, such as SolidWorks. - Experi...
I'm in need of experienced interior design rendering artists for residential projects. The focus will be on various areas throughout the entire home - particularly the living room, bedroom, and kitchen. - The Job: You'll need to create high-quality renderings based on my specific design ideas. I have no preference for a particular style or theme; it's more crucial that you're proficient in capturing and translating my vision accurately. - Skills Needed: You should have extensive experience in interior design rendering, with an eye for detail and a knack for understanding client's needs. Proficiency in a variety of rendering software is a plus. Please showcase related projects in your portfolio when applying.
Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!
We require a professional logo that will serve as the identity of our brand to include our business name: Tan Your Way Wellness Spa. Key requirements: - The logo should reflect a professional tone, considering it's for a brand identity. It needs to communicate reliability, credibility and expertise. - Please note that we do not have specific colours in mind for the logo. Feel free to suggest a color scheme that aligns with a professional image. - The design should be versatile and adaptable for use across different mediums, such as print, digital, and social media. Ideal Skills and Experience: - Experience in designing logos for brand identity. - Understanding of colour psychology and its application in creating professional and trustworthy visuals. - Proficiency in creat...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transf...entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciate...
...data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around a circuit using the least amount of power in a given time, by calculating the forces acting on the vehicle at any point. The forces have been identified to be: Drag, Rolling resistance, Incline, Wind & Motor thrust. Rolling resistance, wind (set to 0 in data should be okay to plug values in later) and incline forces have been resolved in an excel file for every data point (every metre). Drag and motor thrust which de...
I'm in need of a skilled circuit board designer that can create the and design the Greber file for me, I need to send the files to the manufacturing compony. My project contains few components only. SAM D11C 14-pin chip, 3 LEDS, Battery holder, and a reset switch. The "j2" pads are for programming the chip, Gnd, power, and clock. The 2 antennas traces are connected to analog pins A2 and A4. LEDs are connected to digital pins 24,25,31. the reset button to RST pin of course. For the 4 programming pads. Gnd and Power goes to Gnd and VDD pins in the chip, For the clock, I'm not shire which pins. layout size : 10 cm by 5.398 cm
... - **Purpose**: The primary aim of the deployment is for text ebedding (vector db) and generation. - **Requirements**: Specifically, I'm looking for functionality related to Language modeling and retrieval augment generation in the LLM applications. - mongoDB should be set up runining a .sh file - docker-compose deploy of the app Essential skills for this project include a strong background in Python programming and experience with deploying applications on different operating systems. Previous work in natural language processing (NLP) or machine learning operations (MLOps) will also be a strong advantage. Your understanding of text generation and the specific functionalities mentioned will be key to the success of this project. If this sounds like a ta...
As a freelancer, I am looking for opportunities in the educational field, as well as content creation tasks. I...educational background or experience in tutoring, training, or curriculum development - Creativity for content creation - Strong communication and teaching skills - Ability to work independently and meet deadlines The tasks may include: - Tutoring students on specific subjects or skills - Developing engaging and informative training materials - Creating educational content for a variety of platforms - Collaborating with other professionals to enhance learning experiences - Adapting to the needs of different clients and learners If you are in need of a freelance professional who can provide high-quality educational and content creation services, I am ready to coll...
I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints
...Google Analytics account, I need a professional who can seamlessly integrate it with my Shopify store. While I'm not currently interested in tracking specific customer actions, I'd appreciate it if the setup can be done in a way that makes it easy to add such tracking in the future. The ideal candidate for this project should have: - Extensive experience in setting up Google Analytics on Shopify platforms. - A deep understanding of website traffic analysis, customer behavior tracking, and marketing strategies. - A track record of successful installations that have significantly improved clients' understanding of their websites and customer base. If you're confident in your ability to deliver a comprehensive setup that aligns with my needs and b...
I am in need of an expert who can proficiently help me flatten specific curved surfaces of a 3D construction using Fusion. Key Requirements: - Experience in working with Fusion software is crucial. - The project involves simple curvature surfaces, so familiarity with 3D manipulation, specifically in flattening, is ideal. - Precision is a must as only specific sections of the 3D construction need to be flattened, not the entire construction. Looking forward to working with someone who is meticulous and skilled at navigating Fusion's model manipulation.
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transf...entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciate...
...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...
I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.
I'm looking for a skilled professional who can help me identify a profitable SaaS on Flippa and manage the acquisition process on my behalf. Key Responsibilities: - Research: Conduct thorough research to identify a SaaS that meets my specific criteria, including high revenue potential, established user base, and a scalable business model. - Negotiation: Handle all communications and negotiations with the seller. Strong and persuasive negotiation skills are essential to optimize the deal and secure the best possible terms within my budget. Desired Skills and Experience: - Extensive experience and a proven track record in SaaS acquisition and negotiation. - Strong analytical and research skills to identify potentially profitable businesses. - Excellent communication skills, par...
...an expert in AI voice technology who can help me bring my novel to life via an audiobook. The audiobook is on a larger scale, clocking in at about 12 hours, so durability and attention to details are crucial. Your task will involve incorporating a wide range of AI voices (more than four) to deliver a more engaging and dynamic listening experience. Furthermore, I want certain voices to have specific accents to align with the unique characters featured throughout the novel. While the accents aren't currently decided, your input and expertise here would be appreciated. The ideal candidate for this project: - Is proficient in AI voice technology, preferably with a portfolio featuring multiple voice characters. - Has a keen ear for voices and accents, ensuring that eac...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
I'm struggling with QuickBooks Snappt, needing help with troubleshooting issues related to printing PDFs. Additionally, I'd like to streamline my paystub downloading process to avoid the need for printing, looking to have them saved directly as PDFs. Key Respo...for a solution that will download paystubs directly as PDFs, without the need for printing. This should enhance efficiency and save time in the long run. Ideal Skills and Experience: - Proficiency in QuickBooks: Experience with QuickBooks, especially Snappt, is fundamental for this project. - Troubleshooting Abilities: A proven track record of resolving technical issues related to printing and formatting PDFs. - Automation Expertise: Skilled in developing software or scripts for automating processes, in this case...
I'm in a situation where I need assistance in creating an XML file and validating it with an XSD file. I am trying to work with and XSD files but hitting roadblocks. The result I'm seeking is an XML file which encapsulates transaction data. This specific data will be gathered from a database, making database management skills essential for this project. Key things I require guidance on include: - XML element creation for transactional data pieces - Using a database for XML data source - Validating the XML with an XSD file The successful freelancer for this project will need a high degree of proficiency with XML and XSD files. They will need the ability to explain complex concepts in an easy-to-understand manner as this project is about learning these skills for me. A s...
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I'm currently experiencing a specific issue with my CyberPanel upgrade on my Vultr Hosting. I'm in need of a talented individual who can help me resolve this issue while keeping me updated on the progress. Key Requirements: - Proficient in CyberPanel and Vultr Hosting - Experience in troubleshooting and fixing package dependency errors - Ability to communicate effectively through the Freelancer.com messaging system Please reach out if you feel you have the right experience and skills to resolve this issue promptly.
I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.
We're a dynamic agency specializing in helping businesses stand out on YouTube....strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply you...
I'm seeking a skilled developer to create a comprehensive priest booking platform that will enable users to book priests for religious services and schedule events at specific temples or with particular priests. Key Features: - User Registration and Login: The platform should provide a seamless registration and login process to users. - Search and Filter for Priests: Users should be able to easily search and filter for priests based on location, preferred language, and availability. - Booking and Scheduling System: An efficient booking and scheduling system is required. This should allow users to select their preferred date and time for the service or event, receive confirmation and reminder notifications, and make payments online. Ideal Skills and Experience: - Proficiency...
...Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question shou...
We need the following features: 1. Login/ registration 2. Stripe integration 3. Place and orde...need the following features: 1. Login/ registration 2. Stripe integration 3. Place and order 4. After placing order, user can upload files to start project 5. Admin receives files from order. 6. Email notification about order progress to user and admin 7. Admin uploads final report pdf to order and marks complete 8. User can download report from order page. End of flow. More details: What specific features would you like to include in the SaaS dashboard? User management, Payment processing, Upload and download files How do you envision the user interface of the SaaS dashboard? Modern and intuitive design What level of user access control do you need? Basic (e.g., admin and user r...
I'm searching for an expert with suitable knowledge and experience in drafting music performance contracts. This contract will not only cover domestic perfo...Providing in-depth detailing about live performances. - Drafting a comprehensive music contract that protects the rights and interests of the artist. Ideal skills for the job: - Contract law experience, especially in the music industry. - Specific experience in drafting contracts for live performances. - Solid understanding of international law related to performance contracts. - Strong communication skills to convey contract details effectively. Experience working with artists on an international level would be a significant advantage. Please, only bid if you fulfil all these requirements. Your bid will not be...
Hey mate - like the project that you did before for me I now need, urgently, 2 more cards: THE MOUSE IS OUT AUGUST 6 and THE IS NOT THE FUNHOUSE Can you do this ASAP??
...write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities,
...Slingshot models. These elements will make our site more dynamic and customer-friendly. - **UI Improvements**: I'm open to your suggestions on how to improve the user interface. This could involve optimizing the navigation menu, ensuring consistent branding elements throughout the website, and enhancing the overall visual design and aesthetics. - **SEO Optimization**: While I haven't provided specific requirements for SEO, any suggestions or implemented techniques that can improve search engine visibility would be highly appreciated. Ideal candidates for this project should have: - Proficient in web development, UX/UI design, and SEO optimization. - Experience in incorporating interactive elements (such as chatbots, maps, sliders) into websites. - Strong attention to...
I'm looking for a skilled graphic designer to help me design a modern, sleek logo for my brand. You must have experience in modern logo design and be able to follow a specific color palette which will be provided. Key requirements are: - Extensive experience in logo design - Proficiency in modern design concepts - Ability to follow specific color palettes This project offers the opportunity to express creativity within the given constraints. I welcome portfolios showcasing similar work.
I'm in need of a skilled developer who can create algorithms and data structures to solve a specific problem related to numerical data analysis. Key Responsibilities: - Develop algorithms to process and analyze numerical data efficiently. - Implement new functionality to enhance data processing capabilities. - Solve the specific problem we're facing with the data through the algorithms you create. Ideal Candidate: - Proficiency in algorithms and data structures. - Prior experience in creating solutions for numerical data analysis. - Strong analytical and problem-solving skills. - Familiarity with relevant programming languages and data processing tools.
I'm in search of a diligent and detail-oriented individual to assist me on a part...cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flexible hours. If you're a self-starter with a strong work ethic and you're comfortable working remo...
