Excel if cell contains text then työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

TExt writting Analisis

...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.

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 Respon...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 your ...

...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 should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th ...

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??

...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, have good experience with Python, and can ensure accurate

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...

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.

We are in search of a s...extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need access to final git repository Project Completion: 2 weeks This project is an exciting opportunity to work on a cutting-edge software integration and development. If you have the right skills and enjoy a challenging, innovative project, I'd ...

I need a freelancer to...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 freelancer who is looking for a 5-star review.

I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member li...extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed b...

I have a mix of digital and paper cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - Strong attention to detail and acc...

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.

I require a one-time data scraping project completed on multiple websites. - TASK: The task involves scraping text content from: Google searches: Commercial Real estate agency Saudi Arabia Commercial Real estate agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experience: - Proficiency

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing sour...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

Hi Freelancers, I have a list of art fairs taking place across the world. The job requires you to find additional fairs to add to this list. Please only apply if you have read this and looked at the work sample image below. My current list contains about 210 fairs, basically all the major ones, so your research would be best done on a country-by-country basis. Thanks, B

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I'm in need of a skilled logo designer to create a text-based logo for my brand. Key Points: - You should have a strong background in graphic design with a particular expertise in logo design - Experience with creating text-based logos is a must - Ability to suggest and implement fonts that convey creativity and innovation is highly valued - Strong communication skills to understand and translate my brand values into a visual representation Feel free to include a link to your portfolio showcasing similar work. Looking forward to seeing your creative ideas.

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I'm in need of a data entry clerk who will be working with text data and will organize it by category. The data doesn't require validation or verification, just simple categorization. Ideal candidate should: - Possess excellent attention to detail - Be proficient in data entry - Have experience working with text data - Be able to categorize information effectively This is a fairly straightforward task that requires precision and organization. I'm looking forward to working with someone who is reliable and meticulous in their work.

...maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The ...

...The document is partly in English, partly in Spanish, we were going to translate it all to Spanish but decided Portuguese is better. There is a second proposal of a similar length that includes different accommodation. The proposal has approximately 150 words in it that are different and highlighted in red. The total translation is maximum 1800 words. Specific requirements: - The document contains travel industry content and Colombian-specific destination information. Therefore, it's desirable that the translator has familiarity with these areas and can accurately translate the content without losing its meaning or context. Ideal skills and experience: - Proven experience in translating business documents. - Native Portuguese speaker with a good understanding of both E...

Start your offer with the word in the att...Videos on their sites. Prepare a list with : Name of the company, youtube Channel, Link to the first youtube video you find on the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 hours of starting our...

I'm seeking a skilled Python programmer with OpenCV experience, preferably one who has dealt with table detection from PDF and images before. Th...of OpenCV - Familiarity with table and structure detection Your main task will be to develop a program that can accurately identify table structures within input files. The files will be PDFs or images, or both. You're expected to program a feature that detects these components: - Cell boundaries - Text within the cells - Overall table structure For the sake of this project, merged cells should be discerned as a single entity during the detection process. Your solution should demonstrate precision in merged cell detection. I look forward to bids from those passionate about computer vision tasks and tackling chal...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

Logo Design Contest for Texoma Logistics Innovation Engine Description: We invite talented graphic designers to participate in our contest to redesign the logo for our Texoma Logistics Innovation Engine project. We are looking for a design that simplifies our current logo while retaining a bold and expressive style, suited for a futuristic concept that embodies logistics and innovation. Design Requirements: - Style: Futuristic, yet clean and professional. - Elements to Include: - All four modes of transportation: freight truck, drone, speed train, and cargo ship. - A circular motif. - Color palette: light blue, dark blue, white, and black. - Exclusions: Absolutely NO AI-generated drawings. Original designs only. And please do not give us the exact same design as we before. Final D...

I need a Python Selenium application that can scrape blog posts from Site A and post them on Site B. Key Requirements: - The Python app should be built using Selenium for web scraping and automation. - It should be able to extract blog posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Experience: - Proficient in Python, with experience in building web scrapers. - Strong knowledge of Selenium for web automation. - Previous experience with data extraction and manipulation. - Understanding of web protocols and site structures. - Familiarity with blog post formatting and publishing is a plus.

...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 seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

Hi! See the drawing below for ELAWN MOOSK! This is a funny drawing, of the famous billionaire Elon Musk. For this contest, you should take this ELAWN MOOSK drawing of ELON MUSK as inspiration, and create a drawing in your own style, a similar style like this, that is funny of the celebrity MARK ZUCKERBERG, and the name for this drawing will be MOORK ZUCKABORG use anything that comes to imagination to make fun of him and make a funny drawing. We really like the drawing of Elawn Moosk, but try a few different options. The winner will probably enter more than one drawing. The winner will not only win $250, but they will win the chance to work with our team full time. We hope to see some awesome hilarious entries for this contest and hope to work with a lot of you soon as we may crown more...

Innovation Company Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integr...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Uploading the Image to the Server When a user...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I require the expertise of a translator for the conversion of a concise book from Swedish to English, focusing on Lean Manufacturing and Leadership. It is necessary that the translator is fluent in Swedish to understand the nuances in the original text. The book contains 25,000 words. While AI tools like ChatGPT 4 may serve as an initial guide, it is crucial that the final product is thoroughly revised by a human to ensure no AI remnants remain. I am able to provide guidance on the appropriate technical terminology. Kindly note, consideration will be given solely to experienced translators with a demonstrated portfolio of comparable assignments.

I'm in need of a professional animator to create a series of short, engaging animated videos. The main goal of these videos is to educate the audience on a variety of topics, such as Science, History, and Health and wellness. Sample reference video. Key Responsibilities: - Create visually engaging and informative animated videos - Ensure the content is clear and easy to understand for the intended audience - Develop storyboards and scripts in coordination with me Ideal Skills and Experience: - Proven experience in creating educational animated videos - Strong understanding of the topics mentioned, Science, History, and Health and wellness - Excellent communication skills to work closely with me on content creation - Ability to create content that is both engaging and educational ...