Here's a deal. I've an Excel Macro written by a freelancer. It simply takes Excel Spreadsheet and converts data from Horizontal to Vertical (similar to Transpose). However, we added a couple of more columns in spreadsheet which changes the 'if loop' logic to a little bit (Changes STEP 7 to STEP 9 in Excel, changes title of Columns from B:Y to B:Z, fo...
You will have 2 tasks: There are...There are 6400 products which you need to fix names of. 1. Remove Quantity from all the product names. 2. Find full forms of whatever is written and get the actual name of the product or brand. Please check excel file attached, check both sheets "actual" is what you will get and "Fixed" is what you need to deliver
Create a VBA application in Excel to help automate the business or organisational process you have decided to address, which must: 1. Have a graphical user interface within Excel such that a person who is familiar with Excel, but has no knowledge of VBA, can successfully operate your VBA application. 2. Demonstrate the key programming skills expected
hello all I want someone to extract the url of all cities in a website. I can provide links to all the countries. you will have to scrape the data which ...of all cities in a website. I can provide links to all the countries. you will have to scrape the data which can be one or two levels deep. the url should be written to a excel or csv file.
...training is provided. You would have: • Tracked daily orders into an Excel file • Reply customer service enquiries • Made our customers smile • Must be able to read Traditional Chinese and English • Must be able to listen Cantonese and English Qualifications: • Excellent written and verbal English communication skills are a must • At leas...
Need more room on project quotes to explain What my price includes and does not include I have written in red on the PDF what I need changed I have uploaded the excel file so it should be easy to edit.
Goal: we want to have a dataset of the best 750 restaurants in Amsterdam. This must be written in Python 3+ and the output should be a dataframe (or similar). 1. Go to: [log masuk untuk melihat URL] a. If you scroll down you will see the rankings. In total there are 3604 restaurants in this
...data file attached. It is for a industrial professional survey. I would also like you to take screenshot of each step so that I can replicate the procedure myself. The coding and description of variables are in the excel file. You only have to perform Structural equation modeling and run the tests, give the results to me. No writing or written report
...research advanced use of Excel data entry online advertising performance marketing It's an advantage if you know: basic HTML and scripting knowledge WP knowledge affiliate marketing knowledge If you've read the description, answer with 11%2= and mention your weekly availability as well. Initial test task: refer to the attached file and write down what
...many excel files. Each excel file will be named after the person whose writing style samples it contain. Internally each file will contain two rows and multiple columns - One row will contain the date and the other row would contain a multi-line written comment that was made by that person on that date. b) The second Input would be an excel file...
Script or program to record redirected urls into Excel/csv and capture basic web CSS elements I would like to have it running locally on Win10 machine/internet access without any additional software installed. Also capable to do the same with google sheets online (nice to have feature but not a must) If you have good ideas like an app or so let me
...and distribute incoming mail. • Filing and file maintenance. • Client reminder calls for upcoming appointments. • Maintain inventory of office and household supplies and prepare orders for replacement materials. • Maintenance of various electronic office databases. • Customer service, in person and in written communication. • Assist with general offic...
build a macro which will copy data from one excel workbook to another. for each row in one excel file the macro should create two lines in the other excel workbook. in the column A of the new file CA should be written in the first line and SL in the second one. also in column E should be filled with text "y" as many as rows
Using Machine Learning to Predict Car Accident Risk. I need a program with GUI written in Python using Machine Learning and Neural Networks to predict car accident. The data will be on excel file (day,time,vehicle,sex,weather etc. about 30-50 conditions). The program must compare several models and as a result to export on map and on plots prediction
...offers which are Powerpoint slides researches and reports Excel files Preparing Oral Presentation and the title is ( How Can We Help You ? ) please I need the the file to be in PSD so I can edit the text later to my language ( Arabic) .. Note that might help : My home language is written from right to left ( not sure if this helpful when you do the
...something you are skilled enough to do. You should be good at Statistical Analysis, and either JMP or Excel should be used. All formulas and equations should be written in a Word file. I want to separate files; 1 in Word (The report) and the other in JMP or Excel (The calculations and graphs) The actual report will be uploaded later this week, and I will post
...a collection of Excel spreadsheets that contain details about the performance of the investment funds of each insurance company. This is the web page: [log masuk untuk melihat URL] I would like a python script to extract the prices of all the funds, for all the insurance companies, and save them to a CSV file. The input to the
Need freelancer to convert PDF documents to Excel file. Each PDF document will have multiple choice questions that need to be converted into Excel. Check attached files for sample. Formulas, whereever present, should be written in MathJax code. Refer this link for MathJax: [log masuk untuk melihat URL]
...of our largest clients. This position will also assist with daily customer service related functions on an as needed basis. Essential Functions: Creation and uploading of Excel files. Data entry to update various databases. Updating product files when there are changes. Request virtual images from vendors. Request quotes as needed. Work directly with
...period: Immediate to 30 Days Job role and responsibility: • Transcribe the Audio File in to text • Good communication skills (written, spoken & read) in Tamil and English is a must • Proficient computer literacy skills and good working knowledge of MS Word and Excel • Detail-oriented, organized, and ability to work independently • Excellent an...
I have this project that I need to build a News scraper and export to excel The excel file needs to have the following items from the news You can search for articles with any combination of the following criteria: Keyword or phrase. Eg: find all articles containing the word 'Microsoft'. Date published. Eg: find all articles published yesterday
...from scratch into a Microsoft doc file, please don not use excel. So you will need to create a new Microsoft word doc and click insert table. From there you must copy and paste all the correct labels, headings and figures. Please make the tables look similar to the pdf design. I will know if the tables are not written from new because it will not convert
...you a simpler, quicker. There would be 200 Ikea products which I would like you to write. They are in 1 single Excel sheet. There would be 7 columns to fill up. The first column is the title of the product. 1.) The title should be written in a way that is descriptive with keywords and adjectives that help customers search for it, and get attracted to
NOTE: This macro must be written for the Excel Personal File. If you do not know what this means, please do not bid. My accounting system is MYOB. From this system, I intend to export a sales file covering a number of weeks. Usually 4 but can be more or less I have a spreadsheet that functions as a MASTER sheet. It contains item codes in the Rows
Hello, I need some work for excel to be done. We have inventory lists in excel that is large file. We would like to be able to scan barcode and check if such an entry already exists. If it exists this entry should be marked green. if not than it should be written in a special column . Text in barcode are only numbers. We need some kind of function to
We are looking to get 10 Unique Guest Post Articles with Follow Links written by the awarded freelancer. You don't need to write an article, but we would like you to communicate with a blog/magazine about the terms so that we have that information. Please offer us, if you can, to write content as well. We can consider that as an option. Follow links
I have an excel file that I need to be converted into google sheets. The excel has some macros in it that grabs the data online so I want that macros should also work in google sheets. I know google sheets uses java script to write the code in [log masuk untuk melihat URL] the whole code needs to be re written in google sheets. Attached is the file. Let me know i...
I want a software that can run "free chrome extension". It shoul..."free chrome extension". It should be able to connect to the URL list one by one. And it should be extract to excel file, the information it take from chrome extension. I will tell the details to the person I decided to work with. (can be written software with c#, visual studio, etc.)
...Other Project related details [log masuk untuk melihat URL] to locally saved excel sheet which contains the test details [log masuk untuk melihat URL] to the locally saved different word document. There can be word doc from 10-15 so for every doc file path there should be a text box where I can place the path also along side every doc file there should be an option to put a...
...teaser headlines written for them. They must be max 80 characters long. As such, you will be writing 80 headlines. You must pay special attention to the Rev Content compliance guidelines, which are enclosed at the end of this sheet. These headlines must then be presented in a single excel workbook / csv file which contains the image file name, and your
Hello, Firstly, will be go to the web site pages from the list in the excel file. Then will be learned the price, stock and cargo information of the products on these pages. This information will be written to the columns specified in the excel file. I will report the details to the person I will be worked. Have a nice working day .
...website. The data is updated every minute and the chart has to show the progress real time. Much like stock data. 1. The site is built with wix. 2. Data currently is written into an excel file on hard drive. 3. So i need someone to come up with how to connect the data on hard drive (e.g. put it into a cloud, google drive, etc) and display that data in a
...in a txt file the script will go to each url and scrape certain information from those pages. (I will use scrapebox to get the list of urls) The script must have the following features: 1. Allow me to enter in multiple footprints to scrape multiple items from the url 2. Enter the scraped data into a csv file that can be imported into excel. (each
Hi, I have a VBA code written in excel file (macro). It performs the calculations. I will provide you the code and I need someone to provide detailed description for each line of the code. (eg. how code works, what each line does, what each line means etc.)
A Stored Procedure is written to map data from one table to another. Attached is the SP in txt file format. List of Variables are provided in excel sheet. Read the SP and see how if each field mapped in the excel sheet is coded correct or not. If coded correctly change the row color to green if not mapped correctly changed the color to Red
I am using Office 360 (Excel) and I have a csv file with the following headers (and corresponding data): First Name,Last Name,Address,City,State,ZIP,Phone,Home Owner,Source The printing company I am using requires the following headers: Record Id,Salutation,First Name,Middle Name,Last Name,Name Suffix,Title,Business,Address 1,Address 2,City,State
...trying to get a program, or scraper, written, that will allow me to see what products are being purchased at any particular shopify store that I'm monitoring throughout the day. I have multiple sites I'm looking at, so it would have to monitor multiple sites checkouts. I want to be able to get the data in a excel file If this is possible, please let
...to save all the links(URLs) which are displayed in any excel sheet or a word [log masuk untuk melihat URL] should be done using Selenium Webdriver and the code should be written in Python version 3 and above. The second part of the project is to make a web crawler which will surf all the websites from the file (where you had saved all the links) and download all the
I need certain quite simple VBA macros written, which mainly do copy/pasting from excel file to another excel file, number searching, etc, quite simple operations. I will be available online as you work, so you'll receive all guidance real time. Project starts asap.
...providing a low-level SEO service. If the client is happy with your work we are very interested to include you into our list of preferred linguistic suppliers. The current file contains 44 key phrases in the area of website content. The task consists in providing synonyms of these phrases and searching for a range of results via the Google Keyword
...VBSCRIPT as the programming language in a .vbs file to extract various details of a complete directory of dozens of Excel .xlsx files each with multiple Worksheet Tabs in every Excel file each containing multiple Column Name Headers into a single CSV file with a single row for each of the unique Excel .xlsx Worksheet Tabs in the Workbook and all the
This project involves programatically populating an Excel spreadsheet. The solution must be a console application written in C# that reads the data from an input file, opens and populates a Excel template file I have provided, and then saves the results in another Excel file. The template file contains a significant number of fields, but I on...
Scan bar code on a mobile device ( Zebra MC40 Android ) , add time and date ans sedn two fields to an excel file via usb . Everyday when data is scanned excel has to updated . Option to dele data from the scanner when we want . Software to be written in Visual studio / Xamarin Forms
NOTE: The code needs to be written INSIDE ACCESS (In VBA). I have stored client information in an MS Access database, and would now like to populate a PDF FORM from MS Access and send it to my clients and ask them to update their contact information. When they send me the updated file, I want to be able to update the data in my database as well. So