I... EDM, wire cutting machine and other processing procedures and processing technology. I did the work is the main transmission design, structure design, mechanical design, sheet metal design, product design. Familiar with the national drawing standard projection rules, three view and tagging, view and way of expression, tolerance and fit, safety.
Operating Theatre Scheduling Problem(手术室调度问题)
Hello, I'm creating a VBA macro to search on 40-50 websites (fill search field, click search) and import results in my excel file. my macro is working for one website but i would like to work in 1 click for all websites My goals is to put a partnumber in a search field in my excel then click on a button and all data to be shown in another page.
...not automatically update so I currently have a Word based VBA macro which does this for single file the when the code runs – it also applies a standard font to all the text. Then it saves the file and closes it. All I require to do is automate this by replicate this code within VBA Excel for all Word files in a selectable folder. Typically 100 Word
Hello, I have a table in sheet 1 and want in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is
I want to extract certain set of rows(lets say rows 10-30) from same sheet(lets say sheet "income statement") present in multiple excel files to create a data dump in an automated manner. Also i want to shape the data in a particular way ( basically pivoting and transposing on certain columns). I want to use powerquery (and probably M, if required)
I need someone to create an Excel staff training database. I have been following a tutorial ([login to view URL]) Please see video for the functionality i am looking for [login to view URL] I have already created a workbook and a User Form in Visual Basic, but i cant program
I need a skilled Python coder to code a multithreaded Python script that will access an external URL I will provide via a HTTP/CONNECT proxy and parse and save the displayed IPs from the external URL to a specific file on my server. I need someone will very good web scraping experience . Script must be multithreaded and very fast
I have a list of 73 hotels in Greece (list has already the names), I need to fill up the list with the following info: - web page link - [login to view URL] link - [login to view URL] rate - booking number of reviews - address - phone number - email - google maps link - proximity to the sea ( by the sea, up to 1km, no) - View (see view, other, no) - stars rating ( if available)
I need help reformatting Excel tables and graphs. The Print Area selection and Print commands cause the program to freeze. Please do not respond unless you are an expert in graphs. Being an expert in VBA and macros is not relevant to this particular project. I won't select a contractor for one week for this project due to travel.
I need to extract data from a platform, place it in a database and send automated sms When a user finishes filling out a form of a platform, I want that information to be extracted and placed in a database and after an SMS message is sent to the user offering my products. Probably you have to unlock capcha and other securities I need a 100% serious
Hello, I'm creating a VBA macro to search on 40-50 websites (fill search field, click search) and import results in my excel file. my macro is working for one website but i would like to work in 1 click for all websites My goals is to put a partnumber in a search field in my excel then click on a button and all data to be shown in another page
I've got Excel VBA code to web scrape. I now need to use proxies and speed up the process. Should be easy for someone who's done this before. So I just need the Excel VBA code snippet to use proxies. The proxy list can be in an excel file as attached. I've attached a file to explain. 1 - get url 2 - get proxy from list 3 - use proxy to get data ...
I will make payment on hourly scheme ONLY through the website. No direct payments will be made including through paypal or some other similar option. The data can contain upto 4000 rows and has two columns – date and value. Input date I1 has to be validated and the user should be prompted to enter the date in the range or exit the program without crashing. First purchase of quantity I2 will...
I am looking for some help with a MS Excel productivity spreadsheet for our Onion Packhouse Specifically to transfer data from one sheet to the next using VBA etc I would like the some of the data from sheet 1 to be automatically be transferred to sheet 2 so sheet 1 remains clear for daily entry only and sheet 2 keeps a running total of productivity
Automatically move photo attachments to Dropbox folder (or create folder if doesn't exist) if it matches google sheet. Will be based on addresses.
Looking to have someone develop code which will extract both meetings and emails from exchange online across and organisation and put the results into an Azure database. The database will be built separately, I am looking for someone to write the code to add a new row in that table for each email and meeting which comes in. The deployment should be
We are using Google Sheet as a CRM to manager some trasport services. Each line of the sheet is the service, while the columns are all the data involved: Service ID, customer email, name, addresses, date and times, driver details, etc. We need the option, for each line (not batch, but e.g. possibile selecting the Service ID), to send some emails following
I have data in excel with two columns date and value. I need to do a what if analysis. That needs to accept some variables. I will enter a date, initial quantity, a percentage difference when that action needs to be repeated, a factor that multiplies the initial quantity. I need to know what is the average price on each of the entry dates and what
Create a python script to use it in command line to extract data. we need extract all lines from big file by using an input file. the scritpt must work like this in command line : /[login to view URL] input-file big-file > output-file - We need the project for today
I want a twilio interface that uses classic vba from access and excel 1. a table, xl sheet with a list of phone number 2. i click on a p;hone number, the prompt is phone ot text (i can do all the vba interfaces, i need the twilio rest api done) 3. if it is a call, the call flow .. calls me, when i answer, connect the call to the client 4. when i
Hi, I need someone to help with the creation of 5 spreadsheets. I attach one template for reference. I need this for: English Premier League English Championship Italian Serie A Spanish La Liga German Bundesliga I need to pull in fixtures from the below link to my spreadsheet. This file will need to be filtered depending on the Spreadsheet template being used. [login to view URL] For example,...
Looking for someone to build a mobile application that will read from and write to an excel document that is located on our desktop, or other specified location. I would like for this program to allow me to take pictures with my phone and add several columns to an excel document that will be used for advertising and marketing.
I have inventory excel sheet that only require you to search for products online and find their dimensions (weight/width/length/height) and copy them into the right column. Rest assure I have designed a random check on products to see if the dimensions been inserted correctly. Only and only then I will pay. I will also need it ASAP so please in your
I am looking for a creative graphic designer to create a one page sell sheet for a product I am selling. I have all the texts written for the sell sheet but I need someone who can add designs to the sheet and give it a professional appearance. If you think you can take on this project, send me a reply and I can provide more information. Thanks.
Will provide links of a directory site from where you will have to get the specified data. Links will be provided to the selected freelancers. Need to finish this in 12 hours. No escrow. Payment will be only after finishing the task. US$ 15 maximum.
I have an access based contacts database that comprises UI as well. I need a VBA / MS Access expert to analyze/optimize the VBA codes in the DB. Also, there is a functionality that has to be updated, which can trigger the change in DB structure and source code accordingly. This functionality shows if a postcard was sent to the selected manager’s contacts
we want to extract email, Names, Phone number, fax, address from an online directory and put it in a excel sheet. the Job Consist of giving the freelance a list of more than website that are an online directory and the scope of work consite of extracting all the data of name, phone, fax and email address and put it in an excel sheet sow e can use it
Need a work report sheet in pdf. The report will contains the patrol details of my employee with location and timings. Time Period Aug 20 to Sept 20. Mostly copy, paste and edit work. Pretty simple. Please Note: I want exact same design, colour, fonts, front size. EXACT SAME. So kindly check the attachment before bidding. Thanks I need the report