Activity log macros excel jobs
i have a few functions that need to be done. you will have to load a excel doc to get everything to work but most aren't horrible.
I'm looking for an expert in data entry to help me with a particular task. - This will include rearranging the columns or just retyping into a new speadsheet. Super easy, I just don't have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary informatio...have the time. Using the Fedex Fissler spreadsheet information, and inputting only the necessary information in the format provided on the second spreadsheet called Fissler Spreadsheet corrected. We only need to capture; Name, Address, city, state, zip, service type and actual weight. This project requires a meticulous eye for detail and an ability to work efficiently with data. Experience with Excel or Google Sheets is a must. Please get in touch if this sounds like a job you...
I am in need of a freelancer who can help me gather contact details from a couple of websites and organize them neatly in an Excel sheet. Key Details: - Websites: I have a couple of websites I need information from. The information is public and doesn't require any special access. - Information Needed: I'm interested in contact details such as phone numbers and email addresses. - Excel Organization: I want the contact details to be listed in a single list without any specific categorization. Skills and Experience: - Web Scrapping: You should have experience in web scrapping to efficiently extract the contact information required. - Data Entry: Proficient in Excel and attentive to detail to ensure the information is accurately documented. - Proficient in ...
I'm in need of an experienced Excel programmer to create a customized program for data analysis. The primary purpose of the program is to assist in data analysis. Thus, it should help in organizing and interpreting large sets of data. The program will need to handle data from two main sources: - Text files (CSV, TXT) - Manual input The ideal freelancer for this job should have a strong background in Excel programming and data analysis, with specific experience in handling various data types and creating efficient, user-friendly Excel programs. Key Skills: - Proficient in Excel programming - Skilled in data analysis - Experience working with text files and manual input - Ability to create user-friendly applications - Understanding of data organiza...
...another account in Zerodha. Functionality – 1) Login: Take credentials from excel like username, password ,API key , secret code, totp key and totp from authenticator for all accounts (master and child both) (basically after generating token) - all these on a single click on starting python file. 2) Order Punch: Copy all orders including NRML (SL-M , SL – limit) and MIS (SL-M , SL – limit) GTT, and trades (only completed- not rejected) from the main account to child accounts 3) Order Modification: If we cancel/modify any order on price and quantity, the cancellation/modify should also be cancelled/modified in all accounts 4) Primary account selection : Should have functionality of changing the primary account in excel , we can have predefined criteria for...
I have a challenging case study that requires a thorough analysis of sales data and survey data. I'm looking for an expert who is well-versed in Excel to help me with this task. Key tasks and requirements: - You'll need to perform trend analysis on the sales data. - You'll also be required to visualize the sales and survey data. This will include a detailed geographical analysis. - The data visualization should be able to provide clear insights and comparisons between different variables. Ideal Skills & Experience: - Proficiency in Excel, including advanced data analysis features. - Experience with trend analysis and data visualization. - Previous experience with geographical analysis is a plus.
I have a photo that contains a mix of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and the ability to accurately represent this ...
I have a typing speed tester project developed in Python and I am looking for a skilled developer to make some improvements. Specifically, I'm looking for two main sets of enhancements: - Database Functionality: I want to add a database to the project to enhance its functionality. The database should support: - User Registration and Login: The project should allow users to register and log in to the platform. - Storing User Typing Speed Records: The database should be capable of storing user typing speed records for future reference and analysis. - Leaderboard for Top Typists: It should also support the creation of a leaderboard displaying the top typists based on their performance. - Graphical User Interface (GUI) Improvements: I want the developer to enhance the GU...
I am in need of an expert SharePoint consultant who can assist me in setting up a three-tier SharePoint 2019 server. I am migrating from a previous version and require professional guidance in choosing the best server configuration for my needs. Primary tasks include: - Set up a three-tier SharePoint 2019 server - Assist in migrating my current data - Optimise the...Expertise in SharePoint 2019 - Experience in server setup and data migration - Knowledge in document management systems - Excellent communication and consultancy skills Your responsibility would be to guide me throughout the process, ensuring a smooth transition while minimising data loss. Your expert advice will also aid me in optimising the new server for document management purposes. One Time Activity & Access t...
I require an Excel expert to help me create and modify spreadsheets. Specifically, I need assistance in incorporating certain functions and features in the spreadsheet, as well as handling various types of data. Key Requirements: - Spreadsheet Creation and Modification: I need someone who is proficient in Excel and can help me set up and adjust spreadsheets to my specifications. - Data Visualization: The ability to create charts, graphs, and other visual representations of the data is crucial for my project. - Automated Reports: I'm seeking assistance in automating certain processes in my spreadsheet to generate reports efficiently. - Conditional Formatting: I will also need help with setting up conditional formatting in the spreadsheet. Data Types: - The spreadsheet w...
I'm on the hunt for a creative designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-...designer to craft a minimalist logo and packaging design for my organic product brand. Here's what's important for this role: - A knack for creating sleek, minimalistic design; simplicity is key. - Experience in creating memorable logos. - Capability to develop eye-catching, yet minimalist packaging. - Proven track record – please include examples of your past work in your application. If you excel in minimalist design and have a passion for creating str...
I'm seeking an experienced developer capable of creating a Telegram bot that exclusively supports the Ethereum cryptocurrency. The bot should be able to execute and log user commands regarding their Ethereum holdings. Essential features include: - Checking balances - Sending Ethereum - Receiving Ethereum Additionally, I need a Php admin dashboard that includes: - Robust user management capabilities - Detailed transaction logs - Sending message to bot users - Interaction with specific users through admin Ideal candidates will have extensive experience working with Ethereum, Telegram bots, and Php programming. Knowledge of cryptocurrency transaction procedures is also indispensable. Preferably, your portfolio should include similar projects for review.
I need assistance in setting up a mail merge (publipostage) in Excel to report information from the Excel sheet into a Word template. Key requirements: - Excel Data Analysis: You should have experience in data analysis using Excel. - Mail Merge: Proficiency in creating mail merge documents in Excel advanced - Word Template Populating: Understanding of how to populate Word templates with data from Excel. It's important that only the text information from the Excel file should be included in the Word template. Ideal skills and experience: - Proficiency in Excel and Word - Experience in data analysis - Familiarity with mail merge functionality - Previous experience in setting up similar Excel-Word integrations. Please...
Hi everybody, We need a full time data organizer who will be putting out bank statements into a proper excel format (which we will give). Please note that you will 70-90% of monthly work and you can keep taking other projects as well but we will give you full time pay of USD 500 and you have to remain available to us We have access to Able2Extract and can provide you a proper converted excel statement. However, in some cases, bank statements could be a scanned copy and hence you may need to manually enter data. This is a full time job and budget is reasonably fixed. Require an excel expert pro as there has to be a lot of data shuffling and data organizing into different folders. Need someone who can start immediately Thak you.
...looking for an experienced Native Android developer to help me with a specific task. Key Requirements: - Add a button to a fragment: The button should open a new activity. - Create a new fragment: This new fragment should consist of a list view. - Populate list view dynamically from an API call: The data from the API will be used to populate the list view. - Each item in the list view should link out to URLs provided in the API. Ideal Skills: - Proficient in Native Android development. - Experience with creating and populating list views. - Knowledge of handling API calls and parsing data. - Understanding of fragment and activity lifecycle. - Capable of creating responsive and efficient UI. - No react native, node.js, no flutter, Please note: - The API may provide a va...
I am looking for someone to assist me with data entry and related tasks in Excel and Word. I need some typing, copy and paste type of data, that needs to be entered in systematic way. Skills and Experience: - working in Excel/Word - Attention to detail - Experience with data entry or typing - Ability to follow instructions and work independently Preferred Format or Template: While I don't have a specific format or template in mind, I have a rough idea of how I would like the data to be arranged. I am open to suggestions and willing to collaborate on finding the most useful format for the data. If you have experience in data entry and are comfortable working with Excel and Word, please submit your proposal and include any relevant experience. Thank you!
I'm in need of an experienced Android app developer to build a group app focused on task management. The primary feature of this application should enable logging work tasks. This project ...developer to build a group app focused on task management. The primary feature of this application should enable logging work tasks. This project demands a deep understanding of task management systems and ability to embed this within an Android app environment. Ideal skills include: - Proficiency in Android app development - Experience with task management systems - Demonstrated ability to integrate log work functionality into mobile applications Your main role will be about crafting an app that excels in the way it handles work task management for groups. Let's bring this proje...
I'm looking for an Excel expert to create a robust three-level lookup function that can handle text data. The primary goal of this function is to facilitate data analysis, and it needs to be followed by basic arithmetic operations based on the result of the lookups. Key requirements: - The Excel function should have a three-level lookup that can handle text data. - The primary goal of the function is data analysis. - After the lookup, basic arithmetic operations should be performed based on the result. - The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup...
With this project, my primary goal is to enhance the user experience on my website. I believe our site navigation could use some definite improvements, especially by facilitating easier accessibility to our critical pages. I'm seeki...to our critical pages. I'm seeking a freelancer with a strong background in UX/UI design and extensive experience in website navigation optimization. Expectations include: - Carefully studying our current site navigation and proposing actionable revisions - Developing and implementing a strategy for improving accessibility to vital pages - Monitoring and reporting the changes' impact on user activity Understanding of UX principles and proficiency in using UX design tools is crucial for this project. Previous experience with similar pro...
... This security should apply to data in motion and the rest. 1.1 use of SSL certificates 1.2 controlled user and administration access to the Loan System Management administration page and hosting environment. 1.3 Backup 1.4 Other security features – please propose. 2. Audit trail – the customer portal must have record all user transactions or activities and allow for retrieval when necessary (activity history). 3. Scalable – they customer portal must be scalable to accommodate new products that may be introduced. 4. Integration – the client portal must have the capability to integrate with USSD solution and Loan Management System. 5. Platform – the client portal should be able to run on any smartphone, tablet, laptop or computer. The solutions should...
I have a task that requires merging data from two Microsoft Excel documents. Both documents contain contact information, but I need an expert to copy email addresses and phone numbers into the original document that includes names. This will create a comprehensive list of 900 contacts. I need US-based freelancers. Specifically, I'm looking for a professional who: - Is an expert in data entry - Has English as their first language for accuracy in handling personal contact information - Can handle the merging process efficiently and with high attention to detail - Can organize the merged data alphabetically based on names It's crucial that you're able to respect the confidentiality of the personal contact information in the documents. Experience in handling sensitive ...
...proficient Excel programmer who can assist with both data analysis and process automation. The project entails: - Data Analysis: Proficiency in sorting, filtering, and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Ski...
I'm looking for a skilled individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in ha...individual to assist with a less than ten PDF documents data entry project. Key Responsibilities: - Copy typing of content from PDFs - Extraction of specific data points - Validation for accuracy and completeness This role will suit someone with proven expertise in data entry and validation. The ideal candidate is detail-oriented and proficient in handling PDF documents. Experience with Microsoft Excel...
I need to scrape data from the website Transfermarkt.com. For specific football clubs and seasons, i need all arrivals and departures, including their name, age, position, transfer fee and sending/receiving club. I only need a generic code, where i can manually insert the club and year myself. I want the data to be transferred and appended in one excel file
I manage 4 Magento websites on a VPS. Unfortunately, the CPU usage spikes to 100% when there's activity on the backend. I need a professional to optimize the performance and reduce the CPU usage. Key tasks include: - Identifying the root cause of the high CPU usage during backend activity - Implementing optimization strategies to improve overall performance - Applying necessary configurations in Magento or server side to lessen CPU load Ideal candidates should: - Have extensive experience with Magento - Be proficient in server management and optimization - Have a history of identifying and resolving issues related to high CPU usage - Be able to provide recommendations to prevent future performance issues
...Technology. This website is primarily aimed at professionals who are looking to enhance their skills and knowledge or stay updated on the latest industry trends. Key Features: - Online Course Delivery: The website should allow for easy navigation of different courses and provide high-quality video and written content. - User Registration and Authentication: Users should be able to create accounts, log in and access course materials. - Interactive Elements: Interactive quizzes, assignments or discussion forums can be good additions to the website to enhance user engagement. - Payment Gateway Integration: A system should be implemented for users to purchase courses online. - User Progress Tracking: The website should have features that allow users to track their progress through c...
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
I am seeking an expert in SQL Server replication. The project involves replicating our business data to facilitate efficient data distribution. The replication has been set up. The snapshot working but Data not delivering to the subscriber. Log reader fails after 10 mins - Key Expertise Required: - Proficient with SQL Server - Extensive experience with data replication - Profound understanding of business data - Knowledge in data distribution strategies
I'm in need of a data entry freelancer with a good command of Microsoft Excel. The task involves inputting data into a spreadsheet. The data is simple and involves just a few columns. This is an ideal project for a freelancer who is available to work from home. Ideal skills for this job include: - Proficiency in Microsoft Excel - Attention to detail - Ability to maintain accuracy while working with data Please note that I don't require any specific software knowledge other than Microsoft Excel. Looking forward to working together.
I need a freelance expert to assist in calculating heat loss and heat gain through an Excel spreadsheet. Key Responsibilities: - Conduct heat loss and heat gain calculations just for the packaged plantroom. - based on the gains find the required fan flow rate to offset those gains Must be done on excel Skills and Experience: - Proficiency in Excel is a must. - Previous experience in heat loss and heat gain calculations for commercial buildings. - Knowledge of HVAC systems and how to optimize them is highly preferred. I can provide the equipment in the plantroom and the internal and external design conditions
I'm seeking an experienced professional who excels in sophisticated data analysis, chart creation and process automation using Excel. You'll need to leverage data visualization techniques to deliver insightful dashboards, with a key focus on developing pie charts for clear, concise, and impactful data representation. Your responsibilities will include: - Analyzing and interpreting complex data sets - Crafting well-structured and insightful pie charts - Automating repetitive processes to improve productivity Core competencies required for this role include a strong background in Excel and data analytics, proficiency in dashboard creation, a keen understanding of automation processes, and the ability to logically interpret and visualize data.
I am currently looking for talented Excel, VBA, and Macros developers who can assist in editing four planning files and managing their data in one main Excel file. The duties you'll be executing are as follows: Automating data entry: This will streamline the process of inputting inventory data, making it quick and efficient. Creating formulas and calculations: To aid in the management and manipulation of our inventory data. Generating reports from the data: We need detailed, clear reports to help analyze and evaluate our inventory. You should also know how to: Use Conditional formatting Work with Data validation Create and manage Pivot tables Set up an interactive Dashboard Knowledge and experience working with ‘Inventory data’ and project sch...
...workforce. Key Responsibilities: - Develop a structured sales training program encompassing various selling techniques, customer service, and product knowledge reinforcement. - Create engaging and interactive product training sessions that educate employees about our offerings, benefits, and unique selling points. - Implement a series of on-the-job training modules that help employees grasp and excel in their roles, while aligning their efforts with organizational goals. Ideal Candidate: - Experience in designing and delivering comprehensive sales and product training programs. - Proven track record in conducting engaging and effective online and offline training sessions. - A solid understanding of adult learning principles, particularly in a corporate setting. - Excellent com...
...videos and user interactivity. Key features: - **Streaming Videos**: Your primary task will be to implement a robust streaming system. This includes ensuring that the videos are accessible to users in a smooth and seamless manner. - **User Registration and Login**: The duplicate site should offer a secure, user-friendly registration and login process. Users should be able to create accounts and log in to access content. - **Design and Layout** The website will be a carbon copy of the original website - just streaming under a new URL Content Management: - **Automatic Sync**: The duplicate site should be able to automatically pull in content updates from the original website. This is imperative for keeping the content on the duplicate site up-to-date. Ideal skills for this jo...
...scalable server-side applications. 2. Implement robust APIs for seamless communication with the Flutter client. 3. Integrate third-party services to enhance platform features. 4. Manage data storage solutions and optimize database performance. 5. Ensure server-side code is optimized for performance and reliability. 6. Implement security measures to protect user data. Requirements: To excel in this role, you should: 1. Have proven backend development experience. 2. Be proficient in backend programming languages like Python, Node.js, or Java. 3. Have familiarity with web frameworks such as Django, Flask, or Spring Boot. 4. Understand RESTful API design principles. 5. Have experience with database management systems like PostgreSQL or MySQL. 6. Be comfortable...
? Seeking Participants for a Focus Group Survey and WhatsApp Activity! ? Are you a user of Associates Management Software? We're looking for participants to join our upcoming focus group survey and 5-day WhatsApp group activity! Activities: -Focus Group Survey: Participate in a 2-hour online focus group session to share your insights and experiences with Associates Management Software. -WhatsApp Group Activity: Engage in daily 10-minute discussions on WhatsApp over 5 days. Requirements: Current user of Associates Management Software (examples include): -SAP SuccessFactors -Oracle HCM Cloud -Workday HCM -BambooHR -Namely -ADP Workforce Now -Paycor -Zenefits -Able to commit to the full duration of both activities. -Must have access to WhatsApp. Benefits: Comp...
I am in need of a skilled professional, capable of reorganizing my database of approximately 1,000 customers. To be specific: - The Excel database contains the following data field: Name, Email, Phone number, Address, City, and Country. - The organization should be done alphabetically by name. - The new Excel template format should have each field in a separate column. For this job, it'll be ideal if you possess exceptional Excel and data organization skills and have prior experience in Database Management. Efficiency in Excel, coupled with keen attention to detail, will aid in the successful completion of this task. Anyone with a seasoned approach to the task will be greatly appreciated.
I'm seeking a freelancer who can develop an automated system in Excel to manage backorders. This system must create new data for efficient backorder handling. Specific requirements include: • Creation of an automation tool that handles numeric values, text strings, and dates and times. • The system should adequately track product lead times and inventory levels, despite not automatically generating reports. Please note, having prior experience in backorder management and Excel automation will be advantageous for this project. The ideal freelancer should have strong data handling capabilities and excellent knowledge of Excel. Proven experience in similar projects is preferred.
I need an experienced freelancer to create a chart with interest rat...freelancer to create a chart with interest rates in Canada for every month between January 2015 and the current month. Key Requirements: - The chart should accurately reflect the fluctuation in interest rates over the specified time period. - The format must be an excel which is easy to read and interpret. - No additional analytics features such as trend lines or forecasts are necessary, the primary focus is to clearly display interest rates by month. Ideal Skills: - Research historical interest rates in canada - Proficient in Excel and creating line graphs. - Strong understanding of financial data, specifically interest rates. - Eye for detail and ability to ensure the data is clearly presented for ea...
...after work first stage completion Specific features needed: - SMS notifications: The addon should be able to send SMS notifications to users for various events such as job application updates, interview requests, and job offers. - Login OTP: The addon should also include a Login OTP feature for added security. Users will receive a one-time password via SMS that they will need to enter in order to log in to their account. Addon developent for a Job Portal, Laravel & Api expert needed Modules/Controllers will be developed: User Management Module: -User registration and login functionality using zender or whatsapp, twilio, nexmo for otp( email and social login already available). -User profile management export function with search and sort. Package Management Module: -Allo...
I'm in need of a skilled web developer who can help me create an adult website that's bold, edgy, and engaging. Key Functionalities: - Membership System: The website should have a membership system that allows users to create accounts, log in, and manage their profiles. - Video Streaming: I aim to have a video streaming feature on the site to host and stream adult content. - Live Chat: The website should feature live chat capabilities to enable users to interact in real-time. Target Audience: - Straight Adults: The website targets straight adult individuals looking for adult content. - LGBTQ+ Community: The site should cater to the LGBTQ+ community and provide content that is relevant and inclusive. - Fetish Enthusiasts: The audience also includes individuals interested...
I need an experienced freelancer who can convert Excel data to 2D DWG files on an urgent basis. Key Requirements: - Utilize the Excel data to create 2D contour plots, specifically representing the height distribution on a bridge surface and the riverbed levels. - Create these contour plots in a DWG format. - Accuracy and precision are crucial for this project. Ideal Skills and Experience: - Proficiency in AutoCAD for DWG creation. - Prior experience with data visualization from Excel. - Immediate availability to start and complete the project as soon as possible. Please include any relevant portfolio items or examples of similar projects you've done in the past. I am looking for a quick turnaround without compromising on quality.
I need someone to add a total of 50 bookmarks to my Word document. Essential Requirements: - Add 50 bookmarks to the document - create a excel; audit xls with 50 rows listing the bookmark name and the section text name (we use that as quality control and testing)
I am seeking a skilled social media manager to handle activity on my Facebook, Instagram, Twitter, TikTok, and Youtube platforms. The specific duties will include: • Managing and scheduling posts • Engaging with followers • Running ad campaigns • Monitoring analytics The main objective of this role is to drive traffic to my website. The ideal candidate should have a substantial experience in social media management, and a proven track record of using social media to increase website traffic. Knowledge in SEO, and first-rate communication skills are also necessary. Please include examples of your past work in your proposal.
...trust. - Details of available charters: thorough descriptions of our offerings, including prices, duration, amenities, etc. - Photo and video galleries: visual proof of the amazing experiences our services provide. - Integration of an online booking calendar: a user-friendly system allowing customers to schedule charters smoothly. Ideal Skills: - Experience in creating engaging tourism or outdoor activity websites. - Expertise in integrating booking systems into a website. - Knowledge of best SEO practices, to ensure our business appears in relevant searches. - Excellent graphical and UI design skills, to make the website visually appealing and intuitive to navigate. Take this opportunity to showcase your creative flair by building an attractive and functional website that wil...
I'm seeking a proficient freelancer who can handle all aspects of setting up, running, and ensuring the success of my Shopify dropshipping account. My business focuses on a specific nich...SEO: I prefer to attract customers to my store through organic SEO strategies. Practical knowledge of SEO tools and techniques is a must. 3. Social Media Proficiency: In addition to SEO, I'd like to integrate targeted advertising on Facebook and Instagram into my marketing strategy. Ideally, the freelancer should have a track record of optimizing Shopify stores for effective dropshipping. To excel in this task, the freelancer should possess excellent SEO skills, social media advertising knowledge, and a clear understanding of dropshipping mechanics. Your bids should reflect your compet...
I'm looking for an expert with exceptional skills in Microsoft Access/Database, Excel, and VBA coding. The main focus of the project is on Access/Database, the specific tasks include: - Data Entry - Query Building - Database Design Ideally, I need someone who can efficiently handle a database containing 10-20 tables. You should be detail-oriented, experienced in managing medium-sized databases, and proficient in maximizing the functionality of Access. Excel expertise and VBA coding skills will also be highly valuable in this project. ONLY ACCEPT TASK IF YOU CAN DELIVER WITHIN 3 HOURS
I'm in need of an experienced data analyst who can help me merge and clean up my Excel database. - Database Type: It is an Excel database that's in need of expert merging and clean-up. - Number of Files: The project revolves around a single Excel file with 4 sheets - Data Type: The data in question falls under the category of customer data. We have exported 4 databases from all our software. Basically we want all the duplicates to be deleted and the final file to be clean and able to be uploaded to mailchimp
