Text mining excel vbaроботи

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

Перекласти 3 сторінки тексту художнього стилю з англійської на українську мову. Необхідний рівень володіння англійською мовою-C1-C2. Translating the text to Ukrainian from original(English). A level of C1 or C2 is required.

I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. Note: I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical skills to effectively assess the website's current performance and make data-...

Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.

I'm looking for a freelancer to manage our inventory data in Excel. - Responsibilities: - Tracking inventory levels - Managing the reordering process - Generating reports on inventory trends - Current Inventory Data Storage: - The inventory data is currently stored in an Excel spreadsheet. - Specific Data Fields: - Product names and descriptions - Quantity in stock - Reorder levels Ideal Skills and Experience: - Proficiency in Excel - Experience in inventory management - Attention to detail - Ability to generate clear reports - Strong communication skills Your job will be to update this data weekly, ensure that it's accurate and up-to-date, and generate insightful inventory trend reports.

...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handling skills. - Ex...

I need a modern, sleek text-based logo designed for my online presence. Here's a bit more about the project: - I'm looking for a design that is striking and easy to remember, in line with current design trends. The logo should be clean and minimalistic, with a text-based focus. - It's important that the logo is versatile and can be used across a range of online platforms - from websites to social media. Ideal freelancers for this job should have: - Proven experience in creating modern, text-based logos. - A strong portfolio that demonstrates a clean, minimalistic design aesthetic. - A good understanding of branding and how to create a logo that is both memorable and versatile for online use.

I'm seeking an experienced Python developer who can help me with a project involving parsing a set of mixed data structures from text files. The data is not overly complex, but it does contain a variety of structures. The size of the files is less than 1 GB. Your responsibilities will predominantly include: - Developing a Python script to parse the text data - Converting the parsed data into JSON format Ideal skills for this task include: - Strong Python programming skills - Experience in parsing text data - Background in working with JSON data - Ability to handle mixed data structures - Understanding of efficient file handling methods, for processing less than 1GB of data If you have a proven track record in similar projects and can showcase a deep understandi...

I need a freelancer who possesses exceptional skills in data entry and Excel for my project. Your primary role will be - Typing data from my files into a structured Excel spreadsheet. - Applying data functions and formulas. An in-depth knowledge of Excel functions is crucial as you will need to implement them to maintain the structure and manipulate the data that will be transferred to the Excel spreadsheet. A knack for accuracy is also crucial as I strive to maintain the highest data integrity.

I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure correct matching of SKUs an...

I need a proficient data scraper to help in generating Instagram leads. The focus will be on the extraction of Instagram usernames from the followers of a specific account, which I will provide. The successful freelancer should demonstrate advanced web scraping skills with a trac...successful freelancer should demonstrate advanced web scraping skills with a track record of similar projects. Attention to detail, ensuring accuracy, and maintaining a high level of confidentiality are desired traits essential for this project. Key responsibilities: - Scraping Instagram usernames - Ensuring high data accuracy - Ensure no duplication of leads Ideal Skills: - Web Scraping - Data Mining - Instagram API - Strong Attention to Detail - A strong understanding of privacy and confidentiality p...

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

I'm looking for an experienced app developer who can create an app using OCR technology. This app must be programmed to convert handwritten notes into editable typed text. The primary goal is to aid users in organizing their notes and enhancing productivity. Key requirements: - The app should be developed for both iOS and Android platforms. - The OCR technology implemented must be robust and accurate in converting a variety of handwriting styles. - The converted text must be editable, allowing users to further organize and work with the notes. - Consideration for user-friendly interface design is highly valued. Ideal candidate: - Proficient in app development for both iOS and Android. - Experienced in implementing OCR technology in previous projects. - Skilled in desi...

i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora

...be a U.S. Citizen Minimum 5-10 years experience Possess a solid understanding of object-oriented software Ability to learn desktop software development or web development technologies, tools and methodologies Possess a solid understanding of applicable development platforms such as Microsoft Stack or AWS Knowledge of building applications and user interfaces (e.g. Javascript, HTML/CSS, XML, C#, VBA and VB.NET) and/or databases (e.g. SQL) is desirable Proficient in all MS Office applications Demonstrated ability to creatively solve technical challenges Possess excellent communication and collaboration skills Salary Range: $98,000 - $125,000/Year, DOE Education A bachelor’s degree in computer science (or other relevant concentration) required. An additional three years of...

For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.

I'm seeking a skilled individual who will actively generate leads and close sales for my upcoming event in the mining sector. Your target audience will include mining professionals, mining equipment manufacturers, and investors in this industry. - Sales Experience: An understanding of navigating the mining industry is crucial. Having experience selling to similar audience before. - Lead Generation: In addition to closing sales, a robust system for generating leads is vital - Relationship Building: A portion of your role will be to establish and maintain relationships, ensuring long term success. Your pay will consist of a fixed salary plus commission. Positively, the more active and successful you are, the higher your earnings.

...data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and correlation studies. - Proficient in Google Ads, Facebook Ads, and...

Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. ...adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be included in ...

...based on assumptions - Balance Sheet Projections:Project key items like working capital, fixed assets, debt, and equity based on historical ratios and expected changes. - Cash Flow Projections:Derive operating cash flow from projected income statements and balance sheet changes. Estimate capital expenditures and financing activities. - Dynamic Model: - Create a dynamic model in Excel, ensuring that changes in assumptions automatically update all related financial statements. - Assumptions Tab: - Develop a separate tab to document key assumptions, ( also can use screenshots with source link) including revenue growth rates, cost inflation, capital expenditure plans etc. 3. DCF Analysis: - Free Cash Flow (FCF) Calculation: Calculate FCF - Discount Ra...

I'm looking for a skilled and reliable data entry specialist to assist with a record keeping project. The task involves transcribing handwritten notes into digital format. Key Responsibilities: - Transcribing handwritten text notes into digital format while maintaining accuracy and attention to detail. - Ensuring the data is organized and stored appropriately for efficient record keeping purposes. Ideal Skills and Experience: - Proficient in data entry with a preference for experience in transcribing handwritten text. - Attention to detail and accuracy in transcribing to ensure the data is correctly entered. - Familiarity with record keeping practices is a plus. The role needs someone who is detail-oriented, reliable, and able to work efficiently. The goal is to smoo...

Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

Búsqueda/Recopilación de Datos: Búsqueda de Correos Electrónicos para Empresas Tecnológicas - Estoy buscando un freelancer que pueda ayudarme a recopilar direcciones de correo electrónico de una lista de empresas. - El propósito de este proyecto es recolectar datos para fines de investigación. - El freelancer ideal debería tener experiencia en recopilación de datos y ser competente a la hora de realizar investigaciones en línea. - El proyecto requiere recopilar un número sustancial de direcciones de correo electrónico de una muestra de aproximadamente 4800 empresas. - La atención al detalle y la precisión son cruciales en este proyecto para garantizar la validez de las direcciones de co...

We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks

I'm in search for an experienced Java programmer with a clear understanding of the .mp4 standard to build a code that encapsulates a data stream in a previously recorded video. Specific knowledge of Ffmpeg is needed. The task at hand mainly revolves around end-processing, as the text file needs to be submerged after the final video compression. The text file will be in the .srt format, and no encryption or compression will be required for this item. Ideal candidate should be familiar with handling these types of video data stream manipulations.

I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.

As a business owner, I'm in urgent need of someone who's an expert in copy-pasting tasks. The job involves transferring text data into a Word document, with no specific format or structure requirement. Skill and experience requirements: - Proficient in Word processing and data entry - Attention to detail - Quick turnaround time If this sounds like something you can do, feel free to place your bid.

I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.

...live support needed via teams. The request has to be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is a big pl...

As someone with an upcoming software development project, I am currently...upcoming software development project, I am currently in search of experienced IIT graduates competent in technical research and software development tasks. The ideal candidates will have proficiency in: - Java - Python - JavaScript - Up-to-date knowledge of the latest technologies Additionally, experience in the following areas is highly desirable: - Web development - Machine learning - Data mining With these skills and knowledge, the candidates will greatly contribute to the success of this software development project by providing valuable insights and effective solutions. Should you be an IIT graduate with these skills and experiences, please bid appropriately, and let's work together on this ex...

I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.

**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...

I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will be highly beneficial.

I have a project that involves working with text data, conducting visualization operations, and integrating these into a mobile application. Key responsibilities: - Working with text data: You should be experienced in handling unstructured text data, understanding its nuances, and transforming it for visualization purposes. - Data Visualization Proficiency: Your responsibilities include creating clear and meaningful visual representation of the data. This includes the ability to create graphs, charts, and other visual tools that can help users easily comprehend the data. - Mobile Application Integration: The end goal is to embed these visualizations effectively into a mobile application. This requires an understanding of the nuances of mobile UI/UX design and opti...

I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.

I'm in need of a Power BI expert to create a comprehensive dashboard for our recruitment department. The dashboard will pull data from our existing Excel spreadsheets and update daily. Key Features Required: - Job Status: This will give us a clear overview of the number of open positions, positions in the interview stage, and positions that have been filled. - Recruitment Pipeline: Visual representation of where in the recruitment process our candidates are, from application to hire. - Applicant Information: A detailed breakdown of our applicants, their demographics, and the source from which they applied. - Application Source: Analysis of the effectiveness of our recruitment sources. - Time to Hire: Ideally, a calculation of the time it takes to move a candidate from applicat...

I am in need of a diligent professional who can assist in extracting text data from PDF files and accurately inputting the information into an Excel spreadsheet. The job calls for attention to detail and excellent data entry skills. Essential Skills and Experience: - Proficiency in Data Entry - Expertise in Excel Your responsibilities will include: - Accurately converting text data from PDF files into Excel - Ensuring data integrity through careful data entry - Delivering the project on time Ideal candidates would have prior experience in handling similar tasks. Your accuracy and commitment to the task at hand will be pivotal to the outcome of this project. Looking forward to receiving your bids.

I am in need of a skilled Excel professional who can create a comprehensive Excel dashboard focused on data analysis. The dashboard will integrate with various Excel files to provide real-time data updates. Key Requirements: - Create an Excel dashboard that primarily focuses on data analysis - Integrate the dashboard with multiple Excel files - Ensure that the data updates are in real-time Ideal Skills: - Proficiency in Excel - Experience in creating complex and dynamic dashboards - Knowledge of data analysis techniques - Familiarity with real-time data integration This project is ideal for an Excel expert who can not only design a visually appealing dashboard but also ensure that it is highly functional for data analysis purposes.

...a project of enhancing the visual appeal of an existing Excel spreadsheet. This entails more than just a simple makeover, but applies a professional visual identity to the spreadsheet. The spreadsheet is a database to show service times and the parts required for that service. I need it to be easy to read and professional. You can use our logo. Key Responsibilities: - I would like customized fonts and formatting integrated throughout. This isn't limited to a specific area, so use your judgment to decide what gets modified. It's essential that the spreadsheet no longer resembles a generic 'Excel' one. - I want the spreadsheet to look and feel intuitive, maintaining the professional aesthetic. Preferred Skills: - Mastery of Excel and its vari...

We seek an Excel expert with experience in developing Bill of Materials (BOM) and Inventory management solutions tailored for small home businesses. The focus is on simplicity and functionality without the need for a commercial product presentation. **Key Features Needed:** - A user-friendly Excel workbook that manages electronic components, their stock levels, and inventory updates post-sales efficiently. - BOM creation from inventory items with an ability to incorporate "other costs" into each assembly. - Stock purchase entries should automatically update inventory quantities and costs. - Detailed sales tracking with automatic inventory quantity adjustments. - Low stock level notifications via highlighted rows in the spreadsheet. - The system should allow ea...

I'm seeking an individual who is well-versed with Excel for data entry tasks. This primarily involves typing and organizing data. Here's what you'll be doing: - Typing out data and organizing it in Excel spreadsheets - Ensuring accuracy and efficiency in data entry Applications should include: - Examples of past work, particularly those related to data entry and Excel Ideal freelancers for this job are those who: - Have prior experience in data entry - Are proficient in using Excel - Possess strong attention to detail, ensuring accuracy in their work.

...developing and maintaining desktop applications using ElectronJS, building and managing user interfaces with ReactJS, and implementing OpenCV and TensorFlow. Additionally, the role requires the ability to read and manipulate Excel files using ExcelJS. The candidate should be proficient in JavaScript and have a strong understanding of its ecosystem. They should possess extensive experience with ElectronJS for building cross-platform desktop applications. Familiarity with OpenCV and TensorFlow is essential, as is experience with ExcelJS or similar libraries for handling Excel files. This project aims to develop a desktop application using that allows users to create custom OMR (Optical Mark Recognition) sheets with questions and multiple-choice options. The applicatio...

I am looking to automate certain repetitive tasks that are currently performed in Excel using Power Automate. - Main Objective: The chief goal of this project is to automate data comparison tasks. This will greatly improve productivity and minimize errors that may come with manual comparison. - Ideal Experience: The ideal freelancer for this task should have extensive experience in Excel and Power Automate and should have successfully completed similar jobs in the past. A strong understanding of data comparison techniques and working with excel spreadsheets will be highly beneficial. - Skill Set: Key skills required include Excel, Power Automate, and a good understanding of data processing and workflow automation.

I'm in need of a skilled individual who can scrape data from various websites for the purpose of lead generation. The data should be delivered in Excel or CSV format. Key Requirements: - Proficient in web scraping - Experience with lead generation - Ability to deliver data in Excel/CSV Ideal Skills: - Proficiency in Python/R for web scraping - Previous experience in similar projects - Strong understanding of lead generation techniques If you have experience in web scraping and lead generation, I'd love to hear from you.

...skilled freelancer to assist with a project that involves reading text from PDF files and answering questions based on the content. This task must be completed without using any external libraries. The ideal candidate should have strong programming skills and experience with text processing and file handling. Project Details: Objective: Extract text from provided PDF files and answer specific questions based on the content. Requirements: No use of external libraries for PDF reading and text extraction. Write custom code to parse and process the PDF files. Develop a method to accurately answer questions using the extracted text. Deliverables: Custom code/script for reading text from PDF files. A function or method to process the text an...