I have an Excel file containing a lot of anchor texts. The anchor words are separated in columns by their categories. Each column has its category name. I want these links to be in different sheets by their categories, Means you have to create sheets by category names. Then convert the anchor text to simple text and then to its URL. Means Column ‘A’
We have a spreadsheet that needs to be optimised and verified for the best solution, possibly using Excel Solver. Please see the attached for reference, there are 10 input variables (Rows 2-11) and 10 output variables (Rows 138-147). The input is subjected to 1 initial Vlookup (Rows 37-51) and 3 Multiplier matrices (Rows 66-75, 90-99 & 114-123). Our
..., I like working with you so much that I would like to offer 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
...requirements". For more details, please read on, or watch my short screencast: [log ind for at se URL] (Password: "bonuspoints") I am looking for someone who can "translate" an Excel spreadsheet into a web application. Responsive design, simple layout. Something similar to [log ind for at se URL] (simple, clean UI, works on desktop and mobile). Please
...a inventory system using c#. I am operating a small powder shop. We have 300 types of powder. Totally 3000 goods in our stock. 1) I want to make a open stock check every month. I have about 300 types of goods, and totally 3000 goods. All the weight of the goods will set to zero every month by hand. Then, you need to write a c# program, the staff put
I have 3 excel files with trial balances from a company. The file 2016 and 2017 have the monthly trial balances, one after the other, from January to December. the file 2018 have the monthly trial balances for 9 month (Jan to Spetember). I need to have on one sheet with the following collums: 1. account number; collum B; 2. Account descriptiion, collum
...following; A. The software takes input of an excel file (template excel sample can be agreed upon). The excel file will have multiple rows and data within 4-5 columns. Each row will contain unique data. B. Based on the information within columns in excel file, the software generates a barcode and a QR code C. Then the software puts relevant barcode and
Hi, I have an excel spreadsheet that does some calculation for me and outputs 48 different data points (single row, 48 columms). I need to write a macro that can create 1000 runs of this so that I can get 1000 rows, 48 columns. This will be a quick job for someone who can turn it around in a couple of hours today. I know that this can be done
Hello - I have a simple contest for Excel Masters for a spreadsheet: Period Flow thru Worksheet: Criteria 1: Column I “Actual”: Match (sumifs) column C with “Sales Tab” column b “restaurant_id” Criteria 2: sales tab “business date” (column C) with calendar tab “date” (column A) Criteria 3: Period Flow Thru W...
...(Hint: Look at the copy-write date on the footer of the website. If it's a couple years old then it might need to be updated.) 4. USE MICROSOFT EXCEL OR BEST WAY TO WRITE DOWN A.) BUSINESS NAME B.) WEB ADDRESS C.) PHONE NUMBER D.) EMAIL (IF PROVIDED) EXAMPLES OF BUSINESS WEBSITES THAT NEEDS TO BE REDESIGNED OR UPDATED: COFFEE SHOP: [log ind for at se URL]
1. Sourcing the CSV and Excel files from Emails with attachments, FTP/SFTP and Web-based Portal (using Selenium) 2. Parsing, Cleaning & Processing these Files 3. Mapping these Files with the DB fields. 4. Calculations & Derivations 5. DB Insertion 6. Batch Processing/Scheduling and preparing Progress Dashboard Note: a. All the requirements are ready
...web scrape all of the products on an e-commerce website: http://www.superbalist.com. (40k+ products) I would require the following information in excel format: A. Product title B. Brand name C. List Price D. Sales Price E. Product description F. Product images (main image and other images available) G. Product category (incl. child categories)
I need a statistic in Excel which shows the following attributes: Username + Follower Number (sorted by follower Number, from high to low). This for total of 8 Instagram accounts A Account 24400 Followers B Account 30500 Followers C Account 171000 Followers D Account 89100 Followers E Account 26300 Followers F Account 18100 Followers G+H Account
...policy administration. 19. Familiarity with Microsoft Office Applications, Microsoft Word, Excel, PowerPoint, Outlook, office 365. 20. CCTV installation , DVR backup. 21. Respond to and resolve help desk requests. 22. Day to day backup. 23. Knowledge of C panal, WHM,FTP. 24. Knowledge of payroll softwate and attendance machine. 25. Vendor management
...front of the products and shelves - Importer's detail as per label on packaging The job will require you to visit the following retail outlets around Bangkok: - 7-Eleven - Big C - Tops Market - Central Food Hall - Foodland Supermarket - Villa Market - Gourmet Market - Emporium You will be required to go to the shelves where the following product categories
...Microsoft Excel which helps nest lengths of tubes for laser cutting. I have attached a template. It does not need to stay in the same format. Refering to the attached, the green cells are inputs, and the yellow are outputs Column A is the part numbers of the part which need to be cut Column B is the quanity of tubes to be cut Column C is the length
I will provide data set (100+ values) in excel (attached) and I need you to provide formula in excel that calculates with distribution function that is based on that data. Tasks: 1) finding proper distribution and its parameters from the data (doesn’t need to be normal distribution) 2) do formula f(X) that returns value from cumulative distribution
I would like to web scrape all of the products on an e-commerce website: http://www.superbalist.com. I would require the following information in excel format: A. Product title B. Brand name C. List Price D. Sales Price E. Product description F. Product images (main image and other images available) G. Product category (incl. child categories) Please
...file. So when we click the driver in dash board we can see everything about the driver. b. Vehicle needs to be linked to the vehicle file so that we can see vehicle details. c. Vehicle Reg and make should be showing in dashboard [log ind for at se URL] needs to have a link in dashboard so when we click we can see pa file e. Add upload photo for PA file and that needs
I want a software that can run "free chrome extension". It should be a...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.)
...explain it in complete depth : 1. I need a interface where I should be able to give the following data: [log ind for at se URL] Name & Other Project related details [log ind for at se URL] to locally saved excel sheet which contains the test details [log ind for at se URL] to the locally saved different word document. There can be word doc from 10-15 so for every doc file path there ...
1-The PDF and Excel reports written in FoxPro 9 for on-line System takes very long time to print and sometimes when you select many reports, it prints only 4. One option is to redo the PDF reports to use iText library for C# in order to generate the PDFs. About the excel reports one should remove the Excel automation and instead use C# to directly
...worksheets in an Excel file, installed in a Windows PC. 2. Transmit the information from each individual worksheet to an Iphone App, installed in several different Iphones. 3. Displays the information in the Iphone App in different sheets/pages. Pre-requisites: a. No information will be transmitted back from the Iphone App to the Excel file. b. Every
...multiple ASIN numbers in an excel or CSV file at the same time with billing address information to pay it automatically, you should notice before purchasing we need to check two conditions include of price and availability. Conditions : If the price for either of the items is less than (%15 cheaper) with the value of excel and also the product is still
...multiple ASIN numbers in an excel or CSV file at the same time with billing address information to pay it automatically, you should notice before purchasing we need to check two conditions such as it's price and availability. *Conditions: If the price for either of the items is less than (%15 cheaper) with the value of provided excel (work as a database)
This is for personal use. The platform already offers all of the code in various languages (Java, C# Python etc) - just need to put it all together for use in excel 7
...in the background process even if it is killed by the user. 5. The Application should have a user screen with following options: a. User login with password b. Settings c. statistics 6. User should be able to create his own account in which his data will stored onwards. 7. Following option should be present under the setting tab a. Magnetic
...sudah ada dan menyusun kaidah keuangan, dengan mengikuti permintaan klien yang dihasilkan dari diskusi dan hasil menata ulang model sesuai dengan kaidah keuangan yang berlaku. C. LINGKUP PEKERJAAN a. Menata Ulang model biaya Proyek (biaya operasi dan pengeluaran modal) yang sudah ada berdasarkan bagan akun yang telah ditetapkan dan sesuai dengan kaidah
...manager of companies in USA & CANADA. We would like an excel spreadsheet of CEO, CFO $ PROCUREMENT /PURCHASING MANAGER emails of USA & CANADA COMPANIES. The worksheet should include the following columns for data entry Column A: COMPANY NAME Column B: CEO FIRST & LAST NAMES Column C: CEO EMAIL Column D: CFO FIRST & LAST NAMES ColumnE:CFO
...3 or more years of continuous experience) Recent experience preparing S corporation, C corporation, and Partnership tax returns (must have 2 or more years of experience A Bachelor’s degree supported by relevant work experience Proficiency in Microsoft Word and Excel; Google Drive, ShareFile, QuickBooks, and tax preparation software (UltraTax CS is a
I am an individual who wants to develop a prototype app from an Excel which uses a VBA uder-defined function. I have no plans to make this commerical yet, I just want to see what is possible and at what price. The minimum viable app will be called "Mr Simple" and will need to work on Android and iOS entirely offline and the app must be capable of
...types: (WANT EXCEL FORMULAS - NOT A MACRO) (1) if, ", APT - extract ", APT and everything to the right until the next comma including the next comma - output results in columns C & D per example in attached file. (2) if, " STE - extract " STE and everything to the right until the next comma including the next comma - output results in columns C &...
...to a proffesional, c) Set turns of client to a proffesional d) Visualization of all turns on a calendar (between dates) e) Add Notes to turns, f) Send mails to pacient and client once a turn has been set, g) Calculation of hour and minute of turn according to country where client resides. h) Exportation of calendar to an excel file All the data
Two .dat files. Both .dat contains only numbers and text, maybe separator as well. All the numbers are messed up/rle/compressed in hex/binary. The original data should be in excel format given from the data at the last few lines. Item should be on its own data. Slk are multiple .slk compressed into one. I need it within a week. 50usd.
I need a professional programmer who is fast in coding and give it to me within in the shortest time. The application must be coded By C#.net and work very fast.
...his/her work and can delivery the high quality work in a timely . I have about 15 K apartment [log ind for at se URL] work will involve copy paste of the data into excel Spreadsheet . I'm willing to pay 0.006 c Per entry/row. see sample attached. You probably need have technical knowledge how to work it efficiency . know how to use Ip address and must have good
...Amount - 5 INR per question or 35$ for the whole assignment let me know if you are interested, I will share the excel format in which questions are required. Columns of excel file are as follows : Question | Option A| Option B| Option C| Option D| Correct Option| Easy or medium or Difficult| Justification for correct answer Please respond back fast
I would like to have excel document coded to export the data from the data entry excel sheet to the corresponsing microsoft publisher template. I would like to fill in an excel sheet then populate multiple Microsoft publisher templates. Each cell in excel would populate to a different template based on information in those cells. I would have a cell
...CAD 16) Google Adwods 17) Accounting 18) Language Tanslators (French, Spanish, Sweden, [log ind for at se URL], Dutch,German, Indonesian, Italian,Norwegian,Turkish) 19) C Programming and C++ Programming 20) SQL and MYSQL Programming 21) Microsoft Access Developer 22) Delphi Programming 25) Ruby2Rail 26) HTML 27) Google Sheets 28) MS Project 29)
...repeat. c. When done, if it could generate a report letting me know which files cannot be opened either without password, or with the “new password”. d. NOTE: if file is opened/being used by someone, skip and note it as “used by” so I know someone was using that file The file types are for PDFs and MS Word, and MS Excel. The Word and Excel have va...
Hello. My name is Rajesh and I’m keen to get some analysis work done in some customer data. Basically we have c.17,000 order records from 2012 to Aug 2018. I am keen to extract and present the following information: 1. Year on year retention 2. LTV (AOV x frequency x retention 3. Cohort analysis - identifying customers by spend (seeing who most
NEED TO ENTER THE 2-LETTER STATE CODE IN A FIELD ON EXCEL. THERE ARE TOTAL 3 EXCEL FILES FOR TOTAL APPROX 3300 RECORDS. 1. GO TO COLUMN [C], 2. FIND THE STATE IN THE ADDRESS, 3. WRITE THE STATE IN COLUMN [D] = USE THE 2-LETTER CODE FOR THE STATE [EXAMPLE: TX = TE. 4. IF [C] DOES NOT SHOW A STATE THEN WRITE "XX" IN COLUMN [D].
Find websites which run their affiliate programs, as well as affiliate integrators, such as CJ.com. Should have: [log ind for at se URL] Name, 2...business sector [log ind for at se URL] [log ind for at se URL] address, [log ind for at se URL] [log ind for at se URL] of affiliate remuneration: a) PPC - Pay per Click b)PPA -Pay per Action (or per Acquisition) c) PPL:-Pay per Lead and ente...
If [log ind for at se URL] = 8 And [log ind for at se URL] ..."HH:mm:ss") End If End If End If i found this code on internet, but it does not work on excel table.. i want to update timestamp on a particular cell (cell A) based on changes that happens on (Cell B) which is based on formula which is on (Cell C) i want to link entire table cell with static time stamp.
...Studying all the contents of the Test (Please see Excel File Attached). No Spanish needed, base your estimates in number of words per document. Make sure to complete Column C (Number of Pages) on the first tab (Document Information) very accurately, the links to each document are included in the excel file. Your estimate for each cell in Column B (Words
Need to punch 7 columns in an excel sheet from the scanned copies of the DD and Aadhaar Number. Below are the details of the columns to be filled from the scanned copies: a. Aadhaar Number b. Name as per Aadhaar c. DD Number d. DD Date e. DD Amount f. Bank Name on DD g. Branch Name on DD Total of 50000 such entries are required to be done in next 7
...requerimiento es fundamental. 1) Excel expert 2) Espanol nativo 3) Creacion de catalogo Que informacion debo incluir en mi respuesta para aplicar a este trabajo? Aplicaciones deben incluir las respuestas a los puntos A, B, C y D. A) Cantidad de productos que has creado con planillas NIS: INDICAR NUMERO B) Excel experiencia y habilidades: 1) Basica
...experienced SEO 2. ABSOLUTELY NO BLACKHAT OR GREY HAT METHODS, ONLY WHITE HAT METHODS. 3. Complete On Page And Off Page SEO 4. Specific keywords will be provided. 5. Weekly excel progress report 6. No use of automated software or bots 7. Search Engine guidelines must be followed and should not be compromised. 8. No black hat and other unethical SEO Spam