...can see that there are 7 quantities (2+2+2+1) required on 5973, 5974, 5986, 6393. So, if there're 7 QTYRQRD while 5 FONHAND, we're short by 2. I want you to write a custom Macro or a custom excel function which does that for me. What I want Excel to do is, sort the QTYREQRD by DATE, and allocate them by First Come First Serve. For example that we
I have an Outlook Add-in which is pretty straight forward coding wise, not large, written in VB6. It used to work fine years ago however with 2013 and upwards it is not being loaded. It can be selected via the Addin Browse but when Outlook starts it is being kicked to the - Inactive Application Add-ins Need this fixed within a few hours please.
...reworded so it's our own. 2. We'll also want a better layout/design for these. That means after reworking the text, figuring out how to layout the pictures with that content, extracting headings, ensuring it works for SEO and reads well on Mobile. Overall, there needs to be more variation so it's more fun to read. This page, for example, is a good start
Core responsibility is to provide the data and analytics capabilities of our clients by developing methodologies for extracting, integrating and transforming data so we can convert raw data into insights. Looking for someone who understands business intelligence and analytics so that they can select, configure and implement solutions. Our clients
...see file timesheet report_2018-0805_thru... That file is that copied on to file Construction Tsheets-CRM Transformation and we press CTRL->L for a built in macro to transform into file After Macro Construction Tsheets-CRM Transformation. We need to have the original file timesheet report first mentioned..... have a daily over 8 hours overtime calculation
Looking for an experienced developer to extract data from Airbnb. It is a one time project for a duration of less than a week. We will provide the Python script for extracting the required data, the developer needs to customize Parse function as per requirements. Knowledge of HTML, CSS will be useful
...wanting to build a budget based app that helps me track my practise,the information and produce built must remain Intellectual Property (IP) Agreement ,i have built a excel macro as a prototype their are a number of macros ,but would like some help CC+ Software or program into a live app ,or iPhone, Mobile App Development, iPad, Objective C, Android
...following: English must be your first language or you must possess an English writing qualification. Be experienced in interviewing clients on the phone and have expertise in extracting vital employment and career information. Previous experience in writing first-class resumes, cover letters and LinkedIn profiles. This is a contract opportunity paid on
We are a small manufacturer who wishes to automate our project management tasks of up to 50 orders ...are a small manufacturer who wishes to automate our project management tasks of up to 50 orders at any given time in various stages of completion. Avoid duplication of client data while managing up to 10 team members and tie into Quickbooks Accounting
Project is about extracting data from 1000 universities for an application. Suitable details will be provided.
Combining several files with certain layout (the data will keep adding every month until 1 full year ) do data processing by macro , presenting summary using pivot and chart
looking for some to make a webscraping bot(Web scraping, web harvesting, or web data extraction is data scraping used for extracting data from internet been able scrape info for different targets . While web scraping can be done manually by a software user, the term typically refers to automated processes implemented using a bot or web crawler.
I have a text file with E - Mails, 230 thousands lines. E - mails are in html format with headers. What I want is: extracting headers from messages, extracting address from where it's from and extracting text from html body (including links). As an output, CSV file with columns: address, text. Number of raws is number of all the emails in the document
Process daily store sale summary report from text file format into excel database. Based on the excel database stored data, able to search data to analyze sales data by each category by day, by week, by month and generate report and charts. Report need to be intelligent to show where the sales are good and weak. Need report for ordering item based
...some data has been exported to a .SIM file from an Energy Modeling program. I need to have the .SIM file parsed and *some* of that data exported in a format that can easily be imported to a MySQL database table. I have sample .SIM files, an Excel spreadsheet with a macro that currently parses the .SIM file to populate cells in itself, and a macro to pull
Hi Anastas Nice that we can continue the job here :-) Just a bru...project: I need to integrate a bookingcalender into WooCommerce. The booking plugin needs to be customized with a plugin that you make. The calendar needs to syncrinize with Outlook. You need to choose the right booking plugin for the task. Please see attached files. Regards Anders
I am trying to develop data extraction utility. I need to outsource the project to a competent guy who can fetch data from pdf. I need code files of the project. Attaching a Document explaining the project in brief: [login to view URL] Attaching Sample PDF: [login to view URL]
quote for the next 3 pages (content crawling and extracting) is: [login to view URL] -- Large 2gbp/month ( from foundation * 2 gbp = 120 GBP ) [login to view URL] -- Middle -- 60 GBP (total) from foundation [login to view URL] -- Small -- 20
...3) ensure that data imported from source CSV's is fully loaded before running excel functions 4) provide notes so I can then make minor adjustments in the future if the base files change What the scripts need to do: A) import data from 2 CSV files. Must be stable for up to 100,000 rows of data and up to 20 columns of data. The CSV data is basic inventor...
Needing a quick macro developed that will use one source of data and compare it to an Excel workbook with multiple sheets. It will identify matches within these sheets and change the matching text in GREEN and the non-matching text in RED. Must be able to accept uploaded information, not cut and paste.
Hi all, currently working on a project where I am providing some fabrication drawings for precast concrete noise wall panels. The works consists of the following: 1) extracting the information from structural drawings provided (in dwg & pdf format) 2) reproducing all the information on a fabrication/workshop drawing to enable precasting 3) I will produce
...those graphs are taking the information from the same file with all the data by day included in the same sheet. I need to have a button that says "Weekly" and move all the information of the graphs from Daily to Weekly, of curse summarizing and combining the daily data into weekly data. another button with "Monthly" another with "Quarterly" and...
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates. State your approach to this task and I will hire you.
Hello, I am based in Switzerland and I work in Market Research/Data Analysis. I need 2 separate projects completed. Here I will focus on the first of these projects, relating to what is mentioned in the subject line: "Web Scraping with Sentiment Analysis" It first concerns web scraping. I would like a program for Python that scrapes the web, all
I have a VBA Macro for scraping data off of a website. The issue is that it comes with duplicates in the excel sheet. I have tried to adjust wait time but this is on and off - works/doesn't work. Need a permanent solution for this so that the VBA just gets the data without duplicates.
click each link and indicate in column 'i' with an 'x' if link is leads to photo. If error occurs and link cannot be followed then leave column 'i' blank. Link is in column 'h' EXAMPLE in file: row numbers 228,645 & 228,644
We will provide a set of input files in a folder. Each of the input files need to be read from the folder and based on logic, needs to be converted into another format (excel sheets)
I need to build a bot or software that can help me automatically extract active members from any telegram group and automatically ...bot or software that can help me automatically extract active members from any telegram group and automatically Add them to any telegram group or telegram channel ... Extracting and adding up to 20000 members per day
We use the following macro for gathering information from invoices on spreadsheets and compiling them into a larger database type spreadsheet. The Macro has been working fine for years but has stopped working in our last update (running office 365). Macro gets stuck on this Err5 With Application ChDrive (Left([login to view URL], 1)) Hopefully
Attached is a spreadsheet that has readings from the new data site. Every site can have up to 3 sensors (identified by a sensor #) connected to a base (identified by a base #). I need a blank spreadsheet where the user can input the following: Input: Base #, Sensor # (or all sensors connected to that base), Date (single date).
...writer preferably from Asia who knows about Outlook. We are running our blog from last 3 years and it is related to Microsoft Outlook & the issues faced during installation, setup, etc. We pay $30 per 1000 words article to our writer and he has to write 4 blog articles per week. To ensure you have the Outlook knowledge, I need you to write a small sample
...accelerometer and GPS sensors to acquire contextual data. After data acquisition phase, the data analysis phase follows to detect activity based on artificial intelligence techniques including machine learning and neural networks. The third phase will be training and testing data and be extracting analytical results. After detecting the type of the