Excel macro web crawling 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.

File Attached

Offline typing job,data entry job

I am looking for a freelancer who can help me export 70,000 leads from based on my search criteria in the next 12 hours. The desired format for the exported leads is Excel. Skills and Experience: - Experience with exporting leads from - Proficiency in Excel - Strong knowledge of industry-specific criteria for leads - Ability to work quickly and meet tight deadlines Start your proposal with "Apollo". So I can understand that you have read the project description.

[UiPath] RPA that extract all functions and VBA from one excel file(xlsm) [UiPath] 1. From one excel file, extract all functions to txt file. ( ) <sheetname> <cellPotision> <function> <sheetname> <cellPotision> <function> <sheetname> <cellPotision> <function> <sheetname> <cellPotision> <function> 2. From one excel file, extract all VBA code( ) If it is possible , to complete in 29 Sep. all vba code

Creat an Excel file with editable sheet

...portal with subscription based login for users only quote as we need experienced person only. 1. Need a web portal 2. User can register for free or paid plan via login, create new password/forget password and then upload insurance policy pdfs/images 3. Our Tool in portal should connect with open ai and it will fetch required pre fixed information like policyholder name, date of expiry, premium paid etc etc from pdf and it can be downloaded in excel (Currently we run step 3 in streamlit via our tool developed in python, but now want in our server) 4. User should be able to now view this data in dashboard, edit/ modify dashboard data 5. Data can be exported or imported as well in excel for a particular period wise. Example Oct to March 2023 6. Data should be sa...

...items, such as: Various revenue streams (Yellow Machine Rental, , Telescopic Manitou Revenue, etc.) Detailed operating costs (Salaries, Equipment Rentals, R&D, etc.) Asset management (Depreciation, asset acquisition, etc.) 3. Enable scenario testing and sensitivity analysis within the model. Scope of Work: 1. Model Development: Construct a dynamic financial model in Excel based on the provided business case study details. Include formulas and macros for easy updates and scenario testing. 2. Analysis: Develop base-case, best-case, and worst-case scenarios. Highlight key financial metrics (e.g., NPV, IRR, break-even analysis). Required Expertise: 1. Strong background in financial modeling, preferably with prior experience...

I am looking for an Excel expert who can assist me with creating conditional formatting for a GANT CHART. The desired outcome for the GANT CHART is to track days between start and stop days. Specific Requirements: - I will provide a specific format or template for the GANT CHART - The conditional formatting required is of intermediate complexity Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of conditional formatting - Previous experience creating GANT CHARTS and tracking resource allocation - Attention to detail and ability to accurately reflect project milestones in the GANT CHART

Data Entry - I am looking for someone who spe...another. - The project requires the use of specific software, namely Microsoft Excel. - The main task will involve converting data into the desired format using Microsoft Excel. - Attention to detail and accuracy are crucial for this project. - The candidate should be proficient in using Microsoft Excel and have a good understanding of data manipulation and formatting. - Prior experience in data entry and data conversion projects is preferred. - The project can be completed remotely, so strong communication and time management skills are essential. - The candidate should be able to meet deadlines and deliver high-quality work. - If you have experience in data conversion and are proficient in using Microsoft Excel,...

Hello, we have products at excel form with name, description, price and discount price. we have also a form at excel for invoicing these products. we need: 1) add QR code to each product at excel 2) when insert manual an order to excel , print for each product a QR sticker with name, qr code and discounted price. 3) need scan qr codes from mobile and auto add them excel invoice form. so means first we add manually the order and auto print for each product a qr sticker for order preparation. after order is ready , when we do packing we will scan the qr codes by mobile and auto add them to excel for invoicing.

I am looking for a freelancer who can upgrade and enhance the existing Interactive Broker API for Excel Sheet with Order Conditioning to submit bracket order trades. The upgrade should include additional order conditioning functions for bracket orders as (PriceCondition,ExecutionCondition and TimeCondition). I am aiming to achieve this upgrade and improvement within a month or so at most. Word document attached contains full details of what is required with target solution. This requires a few additional macro's to be written to the existing file only...no major code re-work required.

We are looking for someone who will write a python code that will allow us to count the number of ads on a job employment website and will capture the ad content (job requirement, working hours, etc) - dynamic content (javascript). The data should be available in an excel file, the code should allow this for a longer period of time. We are conducting scientific research, so if you have a background in this, it is an advantage :)

I have a PDF file that contains tables and charts, which I need to convert into Excel data. The file is quite large, with more than 50 pages. I have specific formatting requirements for the Excel data and will provide the necessary guidelines. Skills and experience required for this project: - Experience in converting PDF files to Excel data - Proficiency in handling tables and charts in Excel - Attention to detail to ensure accurate data conversion - Ability to follow formatting guidelines provided by the client

I am looking for a freelancer to create an advanced dashboard example ...advanced dashboard example for me. The dashboard should include charts and graphs. Here are the specific requirements for the project: - The dashboard should have 40 functional choices of reports. - I am open to using sample data for the dashboard. - The dashboard should be connected to a form or Excel to automatically sync with the data. Ideal skills and experience for this project include: - Proficiency in creating advanced dashboards with charts and graphs. - Experience in working with forms or Excel to sync data. - Strong attention to detail and ability to create visually appealing reports. If you have any relevant experience and are confident in your ability to complete this project, please subm...

Tool should fetch data from public website with a standard view and show us the changes that has happened in last 24 hrs for input file. The output will be in excel file with highlighting of data in columns about what has changed in past 24 hrs

I am looking for an experienced video editor to put together a promotional video. I have the footage already that needs to be edited. The final video should be under 5 minutes in length. The end goal is to create a highly engaging and creative video that will promote my product or service in a compelling way. The video ...engaging and creative video that will promote my product or service in a compelling way. The video editor must have experience working with similar projects in the past and be able to pull together something extraordinary from the footage provided. A strong eye for detail and prowess with editing software such as Adobe Premiere or Final Cut Pro are essential. If this sounds like something you'd excel at, please feel free to contact me and we can discuss this p...

jasper report for excel, we need to get data from SQL

I'm operating Microsoft Excel for Mac, version 16.77.1, Office Home & Student 2021 I'm looking for an interactive annual calendar to predict and track my pay. I work a rotating day and night shift schedule with different pay component. Base pay, Shift differential, Shift turn over, overtime, 3 different holiday pay types. each days pay can consist of one or more of these components. these pay rates change annually on February 1. I'm open to the format but i envision a calendar with the months placed vertically and each months dates placed horizontal below each month. Below the dates for each month a horizontal line that auto fills with my schedule with the ability to add and edit to calculate the projected pay for each period. A column to the right of the ...

I am looking for a skilled Excel expert to develop a linear timber cutting list optimizer. The desired output format for the cutting list is an Excel spreadsheet. Specific requirements for the cutting pattern have not been provided, so the freelancer should be able to work with specific dimensions or be open to any pattern. The project involves working with more than 7 different timber lengths. I should be able to import a cutting list as per attached into the optimizer spreadsheet. I will specify the timber lengths we have in stock, for example 2.4m, 3.6m, 4.2m, 4.8m, etc. The optimizer should provide me with a cutting list, using the stocked timber sizes specified, utilizing materials in a most cost effective way. (Less wastages) Waste should be indicated in %. Ide...

Project Description: I am looking for a freelancer who can create two graphs in Excel with two different y axes. The data that will be plotted on the graphs is numerical data. Graph Type: I prefer the graphs to be line graphs, which will effectively represent the data. Interactivity: The graphs do not need to be interactive. Ideal Skills and Experience: - Proficiency in Excel and data visualization - Strong understanding of graphing and charting techniques - Ability to create line graphs with multiple y axes - Attention to detail to ensure accurate representation of data Please provide examples of previous work in Excel graphing and data visualization when applying for the job.

I am looking for a talented graphic designer who specializes in logo design. Specific Type of Graphics Design: - Logo design Design Elements or Themes: - I have specific ideas in mind for the design elements and themes. Number of Design Variations: - I need more than 7 design variations for the logo. Ideal Skills and Experience: - Strong portfolio showcasing expertise in logo design. - Proficiency in graphic design software. - Ability to bring creative ideas to life based on specific client requirements. - Attention to detail and ability to meet Lodeadlines. - Strong communication skills to understand and incorporate client feedback. If you are a skilled graphic designer with experience in logo design and the ability to bring my specific ideas to life, I would love to work with you...

FOR US AND CANADA BASED FREELANCERS I am in need of a data analyst for my construction/landscaping company. The ideal candidate will have experience in analyzing sales data, as well as the ability to work with a medium-sized dataset of 500-5000 entries. Skills and experience required for this project include: - Proficiency in data analysis tools and software - Strong analytical sk...detail - Ability to generate insights and recommendations based on the data - Experience in the construction or landscaping industry is a plus, but not required As the client, I am open to suggestions and recommendations from the data analyst. The goal of this project is to gain insights into our sales data and make informed decisions to improve our business performance. Program to be used: ...

...freelancer who can create an excel sheet for me to collect surveys from multiple team members and collate the data. The project requires the following: Survey Questions: - The excel sheet should include multiple choice questions for the survey. As per the attached file, the drop down has the options to answer. I need to collect input from 6 managers and average the results into a single ranked sheet. A + = 5 point A =/- = 2 points a - = 0 points For reference this youtube shows you the manual process Number of Team Members: - Less than 10 team members will be providing input for the survey. Collated Data Format: - The desired format for the collated data is summary tables. Ideal Skills and Experience: - Proficiency in Excel and data analysis. -

I am looking for a freelancer who can help me with a project to write a simple flow in Power Automate. The goal is to send an email with attachments from OneDrive whenever a new row is added to an Excel spreadsheet. Email Service Provider: Outlook Requirements: - Experience with Power Automate and OneDrive integration - Proficiency in working with Excel spreadsheets and manipulating data - Familiarity with Outlook email service provider Task: - Set up a flow in Power Automate to monitor the Excel spreadsheet for new row additions - When a new row is added, extract the relevant data and send an email with attachments from OneDrive using Outlook Please provide examples of previous projects or relevant experience in your proposal.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

Graph exchange rates for a time period

...preparing shipping labels for an online e-commerce business. Tasks: Responsibilities include reading emails, preparing shipping labels, saving them as PDF files, and subsequently sending the PDF files back to us. Our in-office staff will then print the PDF files and fulfill the orders. The primary software required for preparing shipping labels is stamps.com. Software/Tools: Excel Word High speed internet Computer with windows 10 or newer. Requirements: Attention to detail Strong work ethics Daily availability, with the ability to work a minimum of 4 hours per day. Extended hours may be necessary when required. Salary: Compensation is $0.5 per shipping label. Estimated hourly rate is $10. The quantity of labels needed for printing varies, typically ra...

I am looking for a Python developer who can help me extract HTML table data into an Excel (xlsx) file. Specific requirements for the project include: - I have a specific website or HTML page in mind from which I need to extract the table data. - The complexity of the table data is simple, with few columns and no nested tables. - I need the Python script to be reusable for future data extraction tasks, as I plan to use it for similar tasks in the future. Ideal skills and experience for the job: - Proficiency in Python 3.9. - Experience with web scraping and extracting data from HTML tables. - Knowledge of working with Excel files (xlsx) using Python libraries. - Strong attention to detail and ability to handle different data types. If you have the necessary skills...

I am looking for an experienced Excel freelancer to construct a spreadsheet for me for budgeting, data analysis, and project management purposes. The spreadsheet must have reports that need to be reported, when they need to be reported, and how many. I will also provide any specific formulas and calculations that need to be included in the spreadsheet. My spreadsheet will be of basic complexity, requiring only simple formulas to complete. If you have the experience necessary for this project, I am eager to work with you on bringing it to life!

This job is basically for data entry pretty straight forward. information will be gathered from the internet and put into excel file. Your assistance will be required to fill out forms also and verify client information

Job Title: Excel and Power Query Automation Expert Description: Are you an Excel and Power Query wizard? I'm seeking an expert to collaborate with me on revolutionizing how we manage complex datasets. In this role, you will tackle the challenge of working with a diverse dataset consisting of 12 distinct clusters, each with its unique set of targets. Your primary responsibility will be to design and implement cumulative calculation methodologies for these sectors. Moreover, you'll have the chance to share your expertise and guide me through the process. If you possess a sharp analytical mind, mastery in Excel and Power Query, and a genuine passion for optimizing data-driven workflows, I encourage you to submit your proposal. Qualifications: To excel i...

$30 Job PERFECTION NEEDED: (XLSX Excel Work-organize records to one XLSX) I will provide you several XSLX files with total up to 30k (one line records) NOTE: These records will already be associated to one header You will organize these records into one XLSX document ---------- 1st step: put all on data one XLSX document 2nd step: highlight any duplicates in the company column (in green), send me this document for adjustment, I will return to you. 3rd step: sort this list by company name column Job is complete

Subject: Creative and Critical Thinking Assignment Topic: online scams OR plastic bags (articles given) Deadline: 4-6 days Desired Length: 5-10 pages word count: 900-1100 (for the application only part II) I am looking for a skilled freelancer who can assist me with a creative and critical t...assignment - Attention to detail and adherence to the specified length (5-10 pages) If you have a passion for [subject chosen by the client] and are able to meet the deadline of within a week, I would love to hear from you. Please provide samples of your previous work related to creative and critical thinking assignments. Looking forward to collaborating with a talented freelancer who can help me excel in this assignment. SUGGESTED OUTLINE UPLOADED IN FILES WITH STEPS AND PARTS OF THE ...

Hey Guys, I am looking for a skilled developer to create a software that can accurately "read" changing numbers on a screen and extract them in real-time onto an Excel spreadsheet. It should be able to Read Numbers from Different Websites. For example: The Price of A Stock on Yahoo Finance. Everytime the Number Changes (And that could be 100 Times in One Minute), the Software should put this Number in a excel spreadsheet, for each Change a new Row. A Simple List is fine, the devlopment of the Excel Spreadsheet is my Task. Operating System: Preferrably Mac, if you are Sure you can do it on Windows but can't do it on Mac, its also Okay, but be aware that i will favor Developers who can do it on Mac. Data Extraction Frequency: Real-time (Skills and Expe...

Hola, tengo muchos ppt en español y quiero pasarlos a otros idiomas. Necesito una app que descargue la información en una excel, luego yo traducir esa información en el idioma deseado y que la app vuelva a cargar la nueva información en mismo lugar de la ppt. Especificaciones: * Hay que entender que los traductores cuando le pasa las mismas frases pueden devolverte traducciones ligeramente diferentes. Imagínate 10 frases idénticas distribuidas en 10 registros de excel, si le doy a traducir, lo mas seguro que no me traduzca las 10 frases de la misma forma, tendrán ligeras variaciones. Y esto no puede suceder. 1º La ppt * Tendrá muchas diapositivas * Una diapositiva puede tener un cuadro de texto o much...

Need an expert for Excel to automate it

...freelancer who can help me find and aggregate Instagram profiles that contain certain keywords and a specific URL in their bio or profile. Specific Requirements: - The freelancer should be able to search for multiple keywords in the Instagram profiles. - The number of Instagram profiles to be aggregated is not fixed, and I am open to aggregating as many profiles as are found. - OUtput should an Excel file containing: Instagram profile name, user handle, description, website, phone number, number of followers, followed, number of posts. Skills and Experience: - Experience in data collection and aggregation from social media platforms, specifically Instagram. - Proficiency in using Instagram search and filtering techniques to find profiles based on specific criteria. - Attention...

I am looking as a client who can give me with Excel data cleaning, specifically for a dataset that has medium size, with 1000-5000 rows. I have specific instructions on how the data should be cleaned. Skills and Experience: - Strong proficiency in Excel and data cleaning techniques - Experience in converting PDF files to Excel - Knowledge of Power BI development and data visualization - Attention to detail and ability to follow specific instructions for data cleaning

I am looking to implement a fractional inventory system in Shopify that will help me better track and manage my inventory. Currently, I am using a manual system or an Excel spreadsheet to manage my inventory but I want to move towards a more efficient software based solution. My primary goal for implementing such a system is to reduce storage costs, improve order accuracy, and increase inventory turnover. On average, I have between 100-500 stock keeping units in my inventory and I want to be able to track inventory quantity and offer discounts to customers when they order more.

Data Scraping Project: Scraping Product Information from Website A Skills and Experience: - Proficient in web scraping techniques and tools - Experience in scraping data from e-commerce websites - Strong knowledge of HTML, CSS, and JavaScript - Expertise in data extraction and manipulation - Familiarity with Excel and data formatting Project Details: - I am looking for a skilled freelancer who can scrape product information from Website A. - The data to be scraped includes details such as product name, price, description, and image URL. - The scraped data should be delivered in an Excel spreadsheet format. - The freelancer should ensure the accuracy and completeness of the scraped data. - It is essential to handle any potential website structure changes and adjust th...

...Collaborate with team members and supervisors to clarify data entry requirements and resolve any issues. Qualifications: High school diploma or equivalent; relevant coursework or certifications in data entry or related fields is a plus. Proven experience in data entry or a related role is preferred. Strong computer skills, including proficiency in data entry software and Microsoft Office Suite (e.g., Excel, Word). Excellent attention to detail and accuracy. Strong organizational and time management skills. Ability to work independently and remotely with minimal supervision. Strong written and verbal communication skills. A commitment to maintaining confidentiality and data security. Familiarity with data entry best practices and quality control processes is a plus. Reliable int...

I am looking for an experienced macro coder to automate data analysis tasks for our existing business using MS Excel. The ideal candidate should have expertise in MS Excel and macro coding. The main tasks for this project include: - Developing a macro to automate data analysis processes - Implementing the macro in MS Excel - Ensuring the macro effectively analyzes and processes data - Providing documentation and instructions for using the macro efficiently Skills and Experience Required: - Proficiency in MS Excel and macro coding - Strong understanding of data analysis techniques - Experience in developing macros for business purposes - Attention to detail and ability to accurately analyze data If you have th...

I need some sort of python code or api code to download Salesforce reports to an excel file in shared folder. Users dont want to manually download every day, hence we were asked to build some batch program to download the reports automatically to an excel file.