Membuat dokumen list kertas A3 Membuat template dokumen laporan harian Menggunakan kertas ncr Membuat template dokumen laporan mingguan kertas legal Membuat tenplate dokumen laporan bulanan / rekap kertas legal Membuat template dokumen RAP Membuat template curva s Intinya membuat template dokumen Antara sheet dan sheet terhubung antara 1 dan lainnya menggunakan rumus atau vba dan menggunakan pivot
WORK SCOPE: To extract business data from Google Map (*Please zoom map up to 20m for larger data extraction) FORMAT TO SAVE LIST: CSV or EXCEL LIST OF DATA FIELDS REQUIRED: Business Name Address City State Zip Phone Fax (if available) Email id (if available) Website URL (if available) COUNTRY: Malaysia KEYWORDS/TARGET LOCATION: (The list below shows the industrial area name. Please extract the business data from each industrial area) Axis Industrial Park , 42450 Shah Alam , Selangor Bandar Teknologi Kajang , 43500 Semenyih , Selangor Bukit Kemuning Industrial Park , 42450 Shah Alam , Selangor Cempaka Emas Industrial Park , 42000 Pelabuhan Klang , Selangor Elite Industrial Park , 40400 Shah Alam , Selangor Hicom Glenmarie Industrial , 40000 Shah Alam...
Melakukan sejumlah pekerjaan Excel Mampu mengoperasikan Ms Excel Mampu mengoperasikan Ms Word Mampu mengoperasikan Adobe Photoshop ++Design Grafis,membuat logo pada Adobe Photoshop dan Corel Draw ++mengoperasikan Ms Excel dan menguasai VBA project dan formula pada excel.
Membuat aplikasi VBA- excell untuk tracking portofolio saham dengan ketentuan sbb: 1. Menggunakan Real time data (1-5 min) 2. Update data saham secara otomatis ke portofolio saham 3. Dapat melakukan penambahan dan pengurangan transaksi saham pada portfolio 4. Dapat melaklukan sorting berdasarkan Nama saham, keuntungan (jumlah atau %), berdasarkan tanggal masuk 5. Record data tiap transaksi pada portofolio
From Excel VBA, we need to call the Keepa API to get data about a specific ASIN. Specifically, the data items will be in a nested JSON response in the Stats data. You will need to pass the Amazon ASIN as a variable to Keepa. It is likely that you will use Python to achieve this, but we are open to other methods. It must be possible to convert the JSON response into a data dictionary, from which we can assign certain items to Excel variables. For example, we want the average selling price over the last 180 days. Your code must then pass this data back to Excel VBA, where we will take over with our code. We have had a lot of time wasters on , so please read the very short specification attached. You will know what VBA, Python, JSON, ...
I am looking for someone to design a web scraper to be used on . The webscaper will scrape of this website for various information including the images of the vehicle, text information, and most importantly: the selling price of the vehicle from the live auction. This is very important!! . This information will then be displayed and searchable on my website!
...of excel with VBA macros and experience in web scraping. I need data scraped from two different websites 3 pages from each site. There will be four sheets in total in the excel file with the scraped data, two macros for each sheet. Each macro will have a toggle feature, one feature will apply a single refresh to the data and the other feature will refresh the page every 30 seconds subject to the time taken to load the data. All odds must
Hi all I require someone to develop my inventory / purchasing requirements. I have attached the document requirements, the example of the tool that i would like developed along with the data to populate. Please read the requirements and look at the demo model i'm looking to develop. If you have the expertise in VBA and formulas etc please apply. Thanks
Hello, I have an excel sheet of thousands of products. The problem is that the data are like this: sku description 1234 description1234 description1235 row 1 description1235 row 2 1235 description1235 row 3 So the function needs to do the following: Get the sku. Concatenate the strings (they contain html) on the description1235 cells so that all description cells are merged into one that corresponds to the respective sku. Thus the file would look like this: sku description 1234 description1234 1235 description1235 row 1 + description1235 row 2 + description1235 row 3 I am attaching a demo of how the excel file is made. Please read the project description before bidding...
Hello We are looking for someone who is well versed with Excel VBA and is willing to work on a hourly basis. The work is divided into 2 parts. 1. We have a few existing macro’s that needs updating monthly. We will be giving them the data based on which the macro will need to be modified. 2 We tend to build newer macro’s often. The requirement will be for 8-12 hours a month. Please share your terms and proposal for the same. Regards
I have a VBA excel investment tracking system written by a Freelancer several years ago. I suddeny started getting error messages when I split a contribution that totals do not match yet they do match. I have included a sample program and a snip it of the error message. I need someone to figure out what is wrong and correct it. This may require some back and forth for me to make sure you understand issue. Knowledge of Finance and Investing is very helpful
Hi, I have MS Form response sheet. I want someone to develop a tool using Excel VBA. We can link the response sheet directly or we should be able to copy paste the survey response to the input sheet . Output sheet should be complete analysis dashboard. I have prepared the entire workbook for reference.
Scrape a website with 180K listings for 5 fields of a website that uses cloudfare to block scraping. attached a ppt of the desired fields and a list of the same website pages to scrape individually. note: WIll ONLY pay once FULL JOB is DONE. and the list is validated
Web Scrape, Data Mine, extracting, collecting and organizing into Excel Spreadsheet specific info from , for research/project purposes. Please see attachments for more details/information/samples/examples and final spreadsheet example output expected from chosen-selected project coder: 1. Word Document, outlining the specifics for this project and its details 2. TXT file with page one results from URL in Word Document, for me to manually copy/paste results info spreadsheet to demonstrate expected deliverable (a .xlsx spreadsheet for Excel 2016, 8 columns and per todays results about 9,000 + rows of data 3. Sample Spreadsheet - demonstrating what the goals/objectives of this project should result in 4. 1 PDF file with 5 images/jpgs of search results for PAGE 1 onl...
Looking for an highly experienced to scrape for the all US therapists. Scroll down so you can see all US states. Limited Budget. Fields details can be provided with sample records to right candidates. Only experienced, No newbies. Write word US at the starting of proposal. Place your actual bid amount to scrape whole USA.
I need help to create a macro that can loop through a list of IDs and create a copy of a template sheet for each one. Details: - Sheet1 is a template that contains lookups to the data based on the first ID - Sheet2 contains a list of IDs (90) - The macro should copy the template and create a sheet for each ID. The end result will be a new workbook that contains 90 sheets. Looking for someone who can do this within 24 hours
The job is to do a one-time scrape of the attached webshop. Check link in the attachment. Information about the data needed is also in the .pdf I also need the image of each product. Just the main image. Note: After login then other prices are shown. When we start I´ll send you the login/user. If you can grab the exact QTY from the code then perfect. Thats it!
We are building a UAE- based ecommerce platform, for which we require data to be scraped from different websites and also create an automated tool using python to generate the required large amount of data from the website. We are looking for an experienced Web scraper who can scrape data from 4 major websites efficiently. This project needs an expert who can start working immediately & aggressively to deliver results within 2-4 days. Skills & Requirements: Expertise in Python or any other programming language Excellent technical abilities Can Inspect Web pages Can study website traffic patterns Can organize site data into spreadsheets
...need to create VBA code in order to save on an MS Access database some structured data by extracting them from a list of multiple files on XLS format accordigly to specific criterias. I also need to setup a macro for data entry and save to database. All requirements and informations are explained on file. file shows data workflow from import to export and the whole saving process to database. Sample and development files will be sent during project discussion. Default password for access to password protected files is "123". We need to create the code for below files. : MS Access Database file : MS Excel Database (Access DB is copied on this file) MOVI_DB_Builder_v1 file : File which contains VBA to import and
I have a Word document in a report format with several heading, subheadings and sections. I need to use a program which can copy the data from a Word document and paste in an Excel file in a given format. This has to be done through a program (VBA, or C/Python Script) Let me know if you think you can do it, and also tell me what tool/method you would like to use to accomplish this. Will share Excel/Word document and detailed instructions with shortlisted candidate. Please tell in your proposal how you would like to do this task and your similar past experience.
The data is very sensitive and you will have to work on my computer via teamviewer/ anydesk etc. You are required to sign an NDA website does NOT have captcha. You will login to the website Do a 3 tier nested search based on some data entered at the start of the run or in mysql If all matches are found, you will edit the record with pre defined data from mysql A log will be kept of what was done with an option to reverse the process
Hi, I am looking for a freelancer who has experience in excel VBA, Mysql and understands soccer results. I need some additional codes to my current macro to scrape some additional data from ;2 and insert it into excel into two columns: AE and AF. The information to be scraped will be information from the both teams to score market (highest odds). I will also need someone who has the ability to install MySql and link it to my excel soccer results and extract the latest soccer results and add to my MySql database with an additional macro to upload the data. Please see attached files. Thanks
I'm trying to match two columns of names. Some name does not have a match due to an additional letter, names, hyphens, accent, etc. I'm trying to create a macro that can match these names using 70-90% similarity, rather than exact match. All names in the tab DART should have a match.
Modify a VBA so the OneDrive path is working as well. See atached, folder "", when "" file open, it kicks a macro and pick up data from CSV. This work fine when run locally. However, we have migrated to OneDrive and the path of the active workbook (with https) is not working anymore
Hello, I just need someone to go through the code with me and explain line by line what the code means and how it works. I need to make modifications to the code so I need to understand the VBA perfectly. See attached excel file "Oil Compliance report data"
I found a website with a lot of photos, I wish to bulk download and save the images into my hard drive. Video Explaining: I only need to save the thumbnail images and not the larger headshot images. Desired Programming Language: Python C# * I'm looking for the best deal possible, please be very competitive. * Milestone release upon completion of the project & is bug-free. * Need Source Code when Job is Complete, After any Bug fixes, and Updates * Please post "I've read everything" when applying to be considered, too many bots applying.
We are looking for a rated developer who can deliver quick work. Script to scrape list of 70k records hourly. 500 results per page. We will need a reports page with charts, data filters and comparisons Php
I have source data which needs to be transformed to certain format subject to certain conditions etc.
...WordPress site that, currently, is using a static self-hosted copy of an external database export (imported as ACF custom post type entries) to search and then show/plot results using FacetWP. Since then, the external database has provided API documentation that will provide search results via JSON. I need a quote to have either: (1) a WordPress plugin that will establish a cron job to regularly scrape the entire external database (via API) and replace the local copy (ACF-defined custom post type) or (2) code updates to integrate with the existing FacetWP search/display functionality to provide "live" search/display results. The current functionality is here: Due to the state government nature of the project, only US-based developers can be considered
Looking for Excel VBA expert to automate tasks in an Excel file. The Excel should be easy to use with simple instructions and also user input section for user to input everything in one go to generate output. This is simple task for an Excel VBA expert Requirements: -Expert in Excel VBA, macros -Experience in doing complicated bug-free automated Excel spreadsheets -ability to consistently deliver high quality work.
1. I need someone who could get all the products information I request to my host, all the products information is from another website 2. Need to add different privilege for different user 3. I could provide the code , and you just make some changes and then upload to the host 4. Price increase need to sync automatically 5. Node.js is request
I am looking for programmers to scrape non-proprietary data (meta data and PDF documents) from government web sites. The salient requirements are – 1. Ability to take turn-key project: own data-scraping, not just write program. 2. New data keeps coming in, so ability to handle incremental data is must. 3. Initial proof of concept will be on local server – we will give you remote access to our server. 4. Final product to be delivered on AWS – meta data will be stored in Aurora and documents on S3. 5. Ability to parse PDF documents and apply proximity logic to identify meta data. 6. Data is huge – about 5 million records – so we need to run parallel services – probably 100+. 7. For running pa...
I have a url where you will see around 5k properties. I need about 10 fields of data from each property and the images around 10 to be downloaded into a folder. Note: Should be done in the next 8 hours, don't ask me for budget its fixed in the project posted.
I need some basic edits to an existing VBA maco, probably 4-6 hrs max. With an option to pick up new projects afterwards. Must be co-working on a shared session, I only operate that way