Delete rows in excel vba based on criteriapráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu
Znalost JavaSE/EE a relačních databází. Angular znát není třeba, stačí vůle se ho naučit. Min. 3 roky zkušenost s komerčním vývojem. Znalost automatických testů. Dovednost domluvit se s kolegy anglicky (min B1). Java, Spring, Maven, Hibernate, RabbitMQ, Angular 2, JSP + další webové technologie, Relační databáze + SQL, JavaScript, jQuery, REST, XML a XSLT, JUnit / TestNG, Mockito nebo PowerMock, GIT, základy linuxového skriptování (Bash), Google Analytics / Google Tag Manager, testování zabezpečení webu
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Vytváříme personalizované dřevěné předměty a potřebujeme zvýšit povědomí o značce, o produktech, zvýšit followers.
Hledáme specialistu na správu PPC kampaně v Google Adwords a Seznamu a copywriting reklamních textů na Facebooku a Instagramu, který má zkušenost v oblasti stomatologie, popřípadě zdravotnictví. Odměna dohodou. Česky jazyk - rodilý mluvčí.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
Zdravím, měl bych nabídku na dlouhodobější projekt (vývoj standalone aplikace, ne webové) a v případě zájmu pošli více informací.
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
...social media manager who can help me in creating and scheduling 200 posts for LinkedIn, Facebook, and Instagram. The posts will aim to target the Saudi market, focusing on Saudi public holidays, patriotism, and more. The requirements for this job are as follows: - Create 200 posts: The posts should be engaging, creative, and tailored for a Saudi audience. They should include high-quality, royalty-free stock photos and be bilingual in both English and Arabic. - Schedule posts: Utilizing Odoo Social Marketing, the successful candidate will be responsible for scheduling these posts for optimal times to reach the target audience. - Target Saudi Market: Understanding the Saudi culture and market is crucial. The posts should resonate with the local audience, focusing ...
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!
I have a project that 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 appreciated. Let me know if you've done similar jobs in the past.
...The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Proficiency in React - Previous experience in building CRUD applications - Understanding of user access control and reporting functionalities - Ability to work with provided APIs - Deadline-oriented with excellent communication. If you're confident in your React skills, have experience in similar p...
I am looking for an experienced developer to create a user-fri...clothing, and the AI will combine these to create a natural, realistic image of the person in the clothing. Key Features: - User-friendly image uploading: The primary focus of the first version of the web app is to allow easy image upload for users. - Basic options to select the type of clothing fit: Users should be able to provide basic inputs related to the clothing, such as size or fit, before the AI generates the final image. Ideal Skills: - Proficiency in AI image processing and manipulation - Web development experience, particularly in user-friendly interfaces - Understanding of e-commerce and virtual try-on technology is a plus The final image should be a natural looking photo of the p...
I'm looking for a talented developer to build a web-based POS system with a focus on insightful daily sales reporting. Key Features: - Web-based POS system: The system should be accessible through the website itself, offering an intuitive interface for easy use. - Daily Sales Reporting: It's crucial that the system provides detailed and comprehensive daily sales reports. These reports should be easy to read and interpret. - Customization: The system should allow for future customization and integration of additional features, as the business grows. Ideal Skills: - Proven experience in developing POS systems, particularly web-based. - Strong understanding of sales reporting and data analysis. - Ability to create user-friendly interfaces. Plea...
I have a project that 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 appreciated. Let me know if you've done similar jobs in the past.
...the inclusion and exclusion criteria and providing a document containing the output. The details of the literature search can be found in the following link. The candidate performing the job should be skilled in performing medical literature database searches, able to collate the results and write an academic document containing citations style of Vancouver Style. There is no restriction on the number of words. Requirements: - Conduct a thorough search on PubMed focusing on Medical Informatics - Provide a detailed summary of abstracts found in the search - Ensure the search is comprehensive and up-to-date Ideal Skills: - Proficiency in using PubMed - Knowledge and understanding of Medical Informatics - Ability to summarize and r...
...expertise in automation to develop a system that streamlines the process from transport 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 a...
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 comm...
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.
We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth...
Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code
I'm looking for a talented 2D animator who can create 3 engaging and entertaining videos, each lasting between 45-60 seconds. The primary goal of these videos is to captivate and entertain the audience. Key Responsibilities: - Develop 3 separate videos in a minimalist animation style - Ensure the videos are engaging and entertaining throughout - Incorporate the ready-made script seamlessly Ideal Freelancer: - Proven experience in 2D animation and motion graphics - Capable of creating entertaining and engaging content - Proficient in working with ready-made scripts - Prior experience with minimalist animation is a plus Brief Documents for 3 Video's Below: Video 1 - Annuity Payout Options: Video
...quiz website in 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...
I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing ...
...data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in table visible) MS Access (local file) Administrator must be able to see and edit all after importing with an interface you will create in Microsoft Access (locally) Administrator must be...
Description: I have a collection of sofa images taken in a factory setting that need to be placed in new backgrounds such as houses, and compiled into a PDF catalogue for virtual display. Tasks: Replace the factory background of each sofa image with a house background. Ensure proper lighting and perspective adjustments for realistic integration. Create a visually appealing PDF catalogue showcasing the sofas in different house settings. Provide high-quality images for virtual display. Deliverables: Edited sofa images in new house backgrounds. PDF catalogue file with all the sofa designs. High-resolution images optimized for virtual display. Criteria for Selection: Experience with background replacement and catalogue design. Portfolio showcasing simil...
...assistance in two primary areas to rectify an unexpected issue with a stolen phone and compromised Gmail account. - Bypass Google's second verification: My Gmail account is currently secure with two-step SMS verification. However, the difficulty is that I don't possess access to the phone where the verification code is sent via SMS. Thus, I need assistance in circumventing this verification to recover my Gmail account. - Remote data wipe: Since my phone has been stolen, I wish to delete all data stored on it remotely. I'm looking for a professional with understanding in Google’s verification systems and proficient knowledge in remotely wiping data from an Android device. Privacy and accuracy are paramount in this ta...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including 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 t...
...valuable insights from businesses operating in the HOREKA segment. We have compiled a list of companies that fit our target criteria, and we require your expertise to conduct telephone surveys with support by email /whatsapp/social media reach with the business owners or top management personnel of these organizations. The survey will consist of a maximum of 5 questions, covering both general information about the company and specific inquiries related to the service we intend to offer. To ensure the accuracy and reliability of the data collected, we request that you obtain call recordings for all survey interactions conducted or responses in written format with the top management personnel. Additionally, we would appreciate your flexibility in terms of sch...
Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.
I'm in need of a simple Android application that's centered around offline data storage. Consider it an offline simplified Instagram app: Dashboard gallery - has a + button that creates a post (see screenshot) - displays rows of 5 thumbnails (similar to Instagram) (see screenshot) Post A post can take 3 forms: - static weight text (ie. 71.3, ^0.5 - where the latter is the weight gained compared to the previous logged weight) (see screenshot) - a photo (see screenshot) - date (ie May 19) (see screenshot) Post interaction - Posts can be deleted or be created Gallery conditions - Displays rows of 5 thumbnails (see screenshot) - If it is the first post of the day, the gallery adds a thumbnail of today's date before adding the actual post (see screenshot)...
I'm looking for an experienced developer to create a new cryptocurrency based on the Bitcoin blockchain platform. The ideal candidate should have a strong understanding of blockchain technology and the ability to develop a secure, scalable, and fast transaction processing system. Key features and functionalities: - Secure transactions: The new cryptocurrency should prioritize and ensure secure transactions to protect the interests of users. - Scalability: The network should be designed to handle a growing number of transactions without compromising its performance. - Fast Transaction Processing: To enhance user experience, the new cryptocurrency should be capable of processing transactions quickly and efficiently. Kindly note that I have no specific design or branding ...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experien...
I need a talented designer who can help me create a visually appealing home page on Shopify. My key focus is to showcase my brand identity. Required Skills & Experience: - Proficient in Shopify - Excellent design skills - Experience in creating a brand-centric homepage - Understanding of user experience principles I have a mockup created in Canva. I need it designed in Shopify for the home page Please include "I am a shopify expert and can do this" to be considered.
I'm in need of a User-Generated Content (UGC) creator who is skilled in creating engaging short video clips and stories/reels for Instagram. Here's what I'm looking for: - Based in Indonesia - Intermediate level of expertise - Strong proficiency in the creation of short videos and Instagram reels/stories - Ability to plan, execute and deliver content consistently - Knowledge of Instagram trends locally and globally - Can Promote Digital Product Taking these into account, freelancers with a track record of creating attractive UGC, especially in the context of Instagram are welcome to bid. Previous work samples will be highly appreciated. Become a part of my project and let's elevate our Instagram presence together.
...concentrate on appealing aesthetics but also functionality. Desirable Website Features: - User-Friendly Interface: EduConnect boasts an intuitive and easy-to-navigate interface, allowing users to find and enroll in courses effortlessly for physical classes. - Extensive Course Catalog: Our platform offers a wide range of courses across various disciplines, including technology, business, arts, science, and more. Each course is meticulously crafted to meet the highest educational standards, ensuring that learners receive the best possible education. - Detailed Teacher Profiles: EduConnect showcases comprehensive profiles of all our instructors. - Course Institute Centers: We only provide information on physical institute centers where certain courses may be avai...
I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new
I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar pro...
We have print data for packaging but in the wrong format. It's a PDF and all single elements needed to create the new print data are delivered. We need someone who can build this 1:1 If there are questions - just let us know.
Buscamos una persona española que ayude a limpiar los datos de un CRM nuevo, subir datos de excel, validarlos o buscar nuevos con herramientas de Marketing.
