Excel macro copy data excel paste internet explorerer jobs
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. THE JOB DESCRIPTIONS & REQUIREMENTS: - Conduct research on the provided [individual(s) or Party(s)] in all local and national news media and social media in both the native language and English. - Significant news in the last 10 years, eg, Merger & acquisition, New business/project announcement / new joint-venture - Changes in organization structure, including changes of shareholders, board of directors, key executives, etc. - Major ...
Example link: I require the capture/ext...numerical values (table comprises of twelve events, seven results per event) from PDF file as quoted above. There will be 1,000s of unique PDF's, so my guess is I'd copy/paste relevant addresses into an Excel file and a Python script would run from there (?). To my knowledge, PDF file is always four pages in length, relevant table to scrape is always located on page2. Required data is always located in the same position/same column in PDF files. (Possible) example output in CSV/Excel could look like: date | 1H | 21,114,900 | 291,000 | 719,400 | 119,200 | 71,000 | 17,900 | 12,600 That output line (above) would have twelve lines of data per daily PDF file (1H, 2H, 3H etc)
I have a set of very clear and easy to read handwritten notes that I need to be converted into digital format through copy typing. Key requirements and details: - The notes are legible and are not expected to be challenging to interpret. - The final deliverable should be a well-organized, accurate digital document mirroring the handwritten notes. Ideal Skills and Experience: - Proficient in copy typing - Meticulous and detail-oriented - Familiarity with handwritten notes is a plus
I am in need of an experienced copywriter to c...is aimed at medical students and its main intent is to speed up the process of writing their research articles. The task demands: - A deep understanding of both medical field and research methodology - Prior experience in writing sales copy that resonates with students' needs and academic interests - Excellent persuasive writing skills to make an impact on the audience The ultimate goal is to bring out the benefits of utilizing research methodology in medical studies, thereby encouraging medical students to improve their research-writing speed. The copy needs to be informative, persuasive and engaging. Ideal Skills: - Medical and academic copywriting - Outstanding persuasion techniques - In-depth understanding of...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
I'm in need of a macro for MS Word that can automate repetitive tasks. - The ideal trigger for this macro would be a custom button integrated into the ribbon. - The macro should be designed to work solely within Word - The key goal is to automating tasks that I frequently perform. I'm looking for a professional who's experienced in creating MS Word macros. The ability to understand the nuances of my workflow and translate that into an efficient and reliable macro is crucial.
Hi, I am looking for a person to do a data entry job. I will provide a group of 80 files. The job comprises of 3 tasks : For each file: 1. Replace the logo 2. Replace text 3. Create prompt for the text, copy paste from chatgpt Finish!
...blockchain confirmations is appreciated. since it is flash btc it must be visible in BTC wallet address for 365 days. There will be no transaction fee while sending from "flash s/w" to "btc wallet" as it will be no confirmations. There will be no limitation for daily transfer for usdt It can’t be tracked as fake transaction. should take normal time to send btc one wallet to another wallet in normal internet connection. 2) These usdt will disappear after 365 days. (negotiable) Note:- There should be some option to select diff timing starting from 10 days upto 365 days based on user input 3) There should be an option to select which crypto currency end-user want to flash. (USDT, BTC and TRX) Compatible with all USDT networks (TRC20 , ERC20 , BEP20 , B...
...Project Overview: The task involves extending the existing deep linking feature from the storagethemesdefaultpartials partial to the homepage () of the website. Currently, deep linking functionality is available only for logged-in users, and the objective is to make it accessible for both logged-in and non-logged-in users on the homepage. ##Scope of Work: Code Replication: Copy the existing deep linking code from storage/themes/default/partials/ to storage/themes/default/index.php. Adjustment for User Authentication: Modify the copied code to accommodate both logged-in and non-logged-in users on the homepage. Integration Testing: Ensure the functionality works seamlessly for both scenarios: For logged-in users: Ensure the deep linking feature remains intact
I am looking to create an Excel tool that will streamline our disbursement process. The tool needs to handle data entry automation, calculation of disbursement amounts, and generation of disbursement reports. Key Features: - Data Entry Automation: This will help us input information quickly and without errors. The tool should automate data entry to reduce human error and increase efficiency. - Calculation of Disbursement Amounts: Once the data is entered, the tool should automatically calculate the disbursement amounts based on predefined criteria. This will help us ensure that the amounts are accurate and consistent. - Generation of Disbursement Reports: After the calculations are done, the tool should be able to generate reports in a clear and user-...
I'm in need of an experienced data scraper to scrape and collect text data from multiple websites including social media platforms. It's a high-volume job with an emphasis on accuracy and efficiency. Ideal Skills and Experience: - Proficiency in data scraping tools and software - Experience with scraping text data from multiple sources - Familiarity with various types of websites and social media platforms - Fast turnaround time, without compromising the quality of work - Attention to detail is paramount - Previous experience in similar projects would be a plus Please bear in mind, I need someone capable of navigating multiple websites for meaningful extraction, we're not just talking surface-level data scraping. This project requires dep...
...full-stack JavaScript developer to help construct a remarkable web application. While I don't necessarily have a preference for the specific platform, I'd appreciate it if the developer can provide recommendations and explain their platform choice, whether it's React.js and Node.js, or Angular.js and , or Vue.js and Django. Your role will encompass both front-end and back-end development. To excel in this job, you need to have: • A strong grasp of full-stack JavaScript development • A robust knowledge of various frameworks • Experience in building web applications • Excellent problem-solving abilities and detail-orientated approach • Strong communication skills to ensure clear discussion of the project details and progress This project...
...structured sales data. Key Project Details: - **Cloud Platform**: The ideal candidate should have proficiency in Azure to run machine learning models effectively. - **Primary Goal**: The primary purpose of this data analysis is to enhance our customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data analysis - Ability t...
I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks
This project requires a freelancer with advanced skills in Excel. I am outsourcing tasks revolving data management. Key Aspects include: - Advanced manipulation of Excel functions - Complex calculations - Refined data analysis When applying, please focus on: - Your practical experience with similar tasks Having realized the depth of this project, it's pivotal that you have an advanced understanding of Excel. Ideally, your background should perfectly align with data management, advanced calculations, and analytical tasks. Demonstrating this through past projects and describing your specific insights gained from those experiences will be a big plus.
I need business idea suggestion, I want to start an internet agency business, I'm thinking of starting SEO agency, but wondering if there are better industries out there. E.g. good thing about SEO, is there is standard operating procedure I can buy and give freelancer to do work according to procedure, you can charge $1k + per month, clients usually pay for 6 months of work so reoccurring revenue, high margin, big market size, not too specialised like law or finance, industry that a non professional can start. I need business ideas that have similar or better advantages to this. Thanks.
...project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is paramount to ensure that the information captured is both precise and aligned with our needs. Content Creation with AI Tools: With the basic ...
I need a copywriter to craft engaging, memorable copy that will increase awareness of my brand among professionals aged 35-54. This is a radio type of copy, but will be used for social media posts and email campaigns. Key Requirements: - Experience in crafting copy for radio is a plus. - Proven ability to write compelling, high-performing social media posts and email campaigns. - Understanding of the 35-54 age group, able to tailor the content to suit their tastes and interests. - Portfolio demonstrating successful work on brand awareness campaigns. The successful candidate will be able to create copy that not only raises brand awareness but also drives engagement and interest among the target demographic.
I'm looking for a creative and talented designer to create a unique logo for my business. Key Requirements: Name of Business is : Finish Line Professional Detail Products Group - Logo : ( open to creativeness, vintage, modern, minimalist, clean, crisp, readable) - Need a label For Quick Shine Interior Detailer Matte Finish Quick Drying Fresh Scented #13780 Must have Logo Below is a Copy of my current logo and label that i am trying to update
I am seeking a versatile copywriter who can leverage both ChatGPT and SURFERSEO to produce effective copy. As the area of focus and purpose of the copywriting project was not specified, I require someone who's quick to adapt and can write across various themes. We need proffesional who can write with prompts for service businesses commercial, and transactional SEO content. Ideal experience and skills: • Proven expertise in using chatgpt • Proficient with SURFERSEO use • Versatility in writing styles - professional, casual or humorous • Flexibility to write for varied subject areas • Quick in understanding and implementing briefs without explicit direction Write to me if you possess the key abilities: versatility, quick adaptability, proven experience...
...coordination. This position is largely marketing based with project management as an autonomous, hands-on role. Working with our Managing Director, you will be self-motivated, with the confidence to follow-up quickly and avoid delays, and turn a small idea into strategic content. –––– Content: - Create written copy for blogs, social media, email nurture campaigns and email campaigns from ideation - Provide support to the wider team on copywriting Digital: - Change page content and data as directed - Support the Marketing Manager with console, analytics and lead strategies - Confidently utilise AI (AgentGPT and ChatGPT) to support content generation - Actively review incoming Google Alerts, news articles and LinkedIn accounts to keep on top of ...
I need a professional to extract Pine Script code from a private TradingView script that I have. - I need the entire source code extracted - The script includes multiple indicators and strategies - I need a functional copy of the extracted Pine Script code Ideally, you should have: - Prior experience working with TradingView and Pine Script - Capable of handling private or invite-only scripts - Understanding of various technical indicators such as Moving Average, RSI, and Bollinger Bands. Please note that the extracted code should be fully functional and operational.
I require an Excel specialist proficient in creating dynamic and functional spreadsheets. This project involves designing a new Excel sheet that handles both numerical and text data. You would need to: - Set up the sheet, capable of performing multiple features such as automated calculations and conditional formatting rules. - Configure simple calculations for GP indicators basing on specific cost prices. - Ensure the spreadsheet can efficiently process a mix of numeric and text data. Strong skills in Excel and data management are essential for this project. Familiarity with advanced Excel functions and an ability to provide quick, efficient solutions to data processing problems would also be very beneficial. A good understanding o...
I'm seeking a professional with a strong background in Excel to develop a keyword search tool for an Excel database. This tool will primarily be used for filtering data and linking to articles hosted on a network. Key Requirements: - Experience creating and managing Excel databases - Proficiency in implementing keyword search tools in Excel I would like the sheet to have a Main/Search Page and another page for the database. I want to be able to add new entries to the database section and have them be searchable on the main page. I want to be able to create new searchable keywords on the database page and have them populate and be searchable on the main page. I would like to be able to enter multiple search terms into the search box to narrow the r...
We need Hubspot expertise! We need help marketing our new app! Please use the images and copy below to draft a 1-Page Hubspot website. Just a screenshot that shows the site in the context of the Hubspot editor is fine. If you win, we'll ask you to copy/paste it into our Hubspot environment (along with build out a couple more pages). Many thanks. Images Please use these images and gifs: I attached a couple below. Homepage Educating the next generation of STEM experts [Schedule a Demo] - Learn to program alongside AI. - Low stakes exercises. Emphasis on daily exercises. - Project-based exercises, automatically graded. - STEM is essential for our future workforce! Science, Technology, Engineering
...IMMEDIATELY! - Extract data in a specified format. - Transfer data from the price listing PDF to an Excel spreadsheet. - Input details such as SKU, Name, Description, Brand, Cost Price, Length, Width, Height, and Weight, which are highlighted in blue. - If any title or heading is not mentioned in the details provided in item #3, add it to columns U-Z. - Ensure all data is formatted correctly, with names in proper case and prices as numerical values. I'm in need of a proficient data entry freelancer to help convert a scanned image PDF to an Excel spreadsheet. Key Details: - The PDF contains less than 50 pages. - The data in the PDF is in the form of scanned images, making it crucial that the freelancer has experience in...
Hi I am looking to add more writers to my team. I need people who are interested in long term work. Hiring at this time for next 4 months. $2.5 per 500 words which will be revised after one month performance. No software please. No copy hits. No AI. Need people who are in it for long term. No milestones. Check my reviews to be sure you will be paid for original work. Need people to start right away. Regards M
...background in WordPress and plugin development. Ideal candidates should have experience creating plugins with similar functionalities. They must understand the crucial aspects of user engagement and UX design. Knowledge of financial systems would be a distinct advantage. The process goes like this: 1. A jotform is being filled up with the loan request information 2. All loans are added to a searchable data base on the site that allows lenders to login, and choose a loan that they like to send a bid on. When the lender choose a loan, they are going to enter their loan offer Loan to Value, Pre Payment Penalty, Rate, Origination and other loan costs. 3. A borrower will then be able to login and see all of the offers in a sortable table and pick the best 3 options - these options wi...
...I'm looking for in a freelancer to bring this vision to life: - A skilled interior designer with experience in autocad planning, sketchup and vray 3d design, 3d rendors , photoshop rendors, minimalist and ergonomic workspace layouts, who can incorporate light color schemes and natural elements, etc - A technology consultant who can implement a robust digital infrastructure, including high-speed internet, smart devices, and software subscriptions. - An acoustic engineer to ensure a variety of sound-managed areas for different working styles, from quiet zones to collaborative and networking spaces. - A business strategist to help design flexible membership plans and community engagement programs that foster a sense of ownership. - A recreational specialist who can create a ho...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
Looking for 4x South African round the clock customer service / call Center VA’s They will just need a headset (we can buy), Fast internet connection (we will supplement), and a working laptop/computer to do the job. HubSpot Experience Preferred Need to cover all hours of the day and the weekends. This is a remote position for a US Based Company 1st - VA to work 7a-3p CST weekdays, 2nd - VA to work 3p - 11p CST weekdays, 3rd - VA to work 11p-7a weekdays, and 4th - VA to work weekends, take calls for both days Option 1 - 2x VAs to work part time, where one does all day Saturday and one does all day Sunday. Option 2 – 2x VAs to work 7-3, 3-11, 11-7p CST to rotate weekends and have every 3rd weekend and get paid extra for each of those weekends. Duties: (1) a...
...preferably not have their own business, as this is a company position. Other Marketing tasks will include: the internet for social media content, asking installers/techs for content by text/email, social media calendar 3. Following up and asking for reviews 4. Researching things for instance all opportunities for community involvement, making FOI requests to municipalities to find orphan gens 5. Manually doing the cloverleaf handwritten (by robot) card after each install and service call in a neighborhood. 6. Manually sending birthday, customer anniversary, holiday cards, etc. to customers 7. Helping gather marketing report data Why Join Us? • Be part of a team that values innovation and dynamic growth. • Enjoy the flexibility of remote ...
I'm desperately seeking the services of a highly experienced cybersecurity expert. I've been encountering multiple issues with my phone and internet provider for over a year now. Here's my predicament: - I've been noticing strange devices connected to my internet, far exceeding the number of devices I own. I recently discovered twenty-three odd devices linked to my account. - In addition, the apps on my phone are shuffled and changed around - without me initiating such changes. - Adding fuel to fire, I received a breach of security letter from AT&T, making me seriously concerned about the security of my digital spaces. The successful candidate should have substantial experience in handling such cybersecurity issues, demonstrating robust track r...
I'm in need of a reliable freelancer to assist with a data entry task. Though I didn't specify the details in the questionnaire, the project involves entering data into a specific are preferred Key Project Details: - Fast and accurate data entry skills. - Fast Copy paste - Basic English - Ability to follow specific formatting instructions.
I'm seeking a detail-oriented Virtual Assistant to assist with data entry tasks, focusing on website data editing and publishing. No specific knowledge or expertise is required for these tasks, making this project an excellent opportunity for beginners and experienced freelancers. Skills and Experience Required: - Strong attention to detail - Excellent organizational skills - Proficient in website data editing and publishing - Reliable internet connection for efficient online work The ideal candidate will have experience in similar data entry projects, although it is not a requirement. This project is an opportunity for long-term collaboration for the right candidate. Do you think you could be the person I am looking for? Then don't hesitate...
I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation
I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!
...Please submit salary requirements. How To Apply: Must complete online job assessment in link below: (Takes about 25 minutes total with breaks in between, at end you receive copy of results) Candidates who do not complete the online assessment will not be considered. Requirements * College education. Law degree preferred. * Must be able to successfully complete a background check. * Must be able to provide references. * Must complete the online job assessment Technology: * Must have reliable internet *Must have reliable computer * Well-versed in E-mail, Word, Excel, Adobe PDF, and Gmail applications. Experience with Clio software is a plus. *Once hired must be ok with software installed on the computer to protect our confidential information
For my project, I need a freelancer with strong skills in data scraping and extraction, particularly with textual content and figures, from a specified public website - Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indica...
...coded for them to select the ones that are relevant to them. Most importantly I need logic in the interface to go through conditions. For example: “Do you rent or own?”. If they own ask them how much they pay for mortgage, home insurance and taxes. If they rent ask them How much and ask if utilities are included. They should be able to pick from a list of utilities like: electricity, water, internet etc. Utilities that are included should not be taken into account in the next section. In the last section they should be able to add any expenses that are important to them as well as select from a list of frequent ones. (See a picture of the UI example below) At the end I need to determine if there’s a surplus after all these expenses. Salary - expenses...
I need an efficient and experienced professional who has a good understanding of Google Sheets and data analysis and entry. Specifically, I need: - Creation of PLP by Copying-Paste Data entry. - Searching a Google sheet for specific products that should be on that PLP - Manually adding each product to that specific PLP based on the results from the sheet A full and detailed brief is available.
IMPORTANT!!!!!!!! ***DO NOT SUBMIT ORIGINAL IDEAS - I NEED EXACT REPLICAS OF INCLUDED FILES*** I need a well-experienced graphic designer to replicate a logo with the exact same graphics and colors as I lost the artwork files when my hard drive was stolen. It is not a terribly creative job, I simply need someone with the technical ability to copy the two main logos I have provided. - Camp Logo will be printed on tshirts, shorts and other clothing - I have included the visuals that I need replicated - Camp Vega - or the camp spot and type in Vega -
I'm looking to build a dynamic, modern Shopify website for my dropshipping business. This website primarily needs to cater to children and their parents, making it interactive and engaging is key. this would be my ideal site , can you copy sections etc and we get our own ali express drop shipped items Please check reference and let me know if you can do simialr in shopify and adding items from ali express . Key requirements: - The website will majorly feature toys, hence category system should be optimized for it. - The design preference is modern. The website should reflect a clean, intuitive and user-friendly interface that appeals to children and parents. - It should have all the essential features of a dropshipping business
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accuratel...
I'm seeking a developer to help me create a system that can archive web-based content, including text and images, for offline viewing. Key Requirements: - Archive text...archive process: The content will require archiving only once, as it won't be updated frequently. Ideal Skills: - Proficient in web scraping: Ability to extract and save content from websites. - Experience with archiving systems: Previous work on systems that save web content for offline use. - Knowledge of offline storage: Understanding of how to save and retrieve content without requiring an internet connection. This project is ideal for someone who is looking to work on a one-time archiving system, and who has a background in web scraping and offline content storage. Please detail your relevant exper...
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...
...next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces). ii. It uses a “What is your current yearly revenue” number and pulls against an array (worksheet) – For the 8 other reports, it pulls data from the column in the array to produce reports. iii. Update – to be able to select multiple outsourced professionals Field b. Customer EBITDA and P&L – Som...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.