Excel vba list web files työt
100 accounts dataentry into excel
...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Completed and running in the hosting server. Recourses : Website is using wordpress . Microsoft 365 suite , hosting ( hostgat...
...records and documentation. Assist with payroll processing and reporting. Liaise with external auditors, tax advisors, and financial institutions as needed. Qualifications: Bachelor’s degree in Accounting, Finance, or a related field (preferred). Proven experience as an accountant, bookkeeper, or in a similar financial role. Proficiency in accounting software (e.g., QuickBooks, Xero) and Microsoft Excel. Strong understanding of accounting principles, practices, and regulations. Excellent organizational, analytical, and problem-solving skills. High level of accuracy and attention to detail. Strong written and verbal communication skills....
I'm looking for a professional who can create a comprehensive spreadsheet for my locksmith business, focusing on financial tracking. The primary purpose of this spreadsheet will be to monitor weekly pay, monthly expenses, and year-t...monthly expenses, and year-to-date totals. Key Requirements: - The spreadsheet should be user-friendly and able to provide rolling totals. - Depending on the final design, the spreadsheet may need to generate reports automatically, so a versatile approach is preferred. - It should be able to accommodate both manual input and potential future automation. Ideal Skills: - Proficiency in Microsoft Excel or Google Sheets. - Experience with financial tracking and report generation. - Previous work with small business or service industry spreadsheets w...
I'm in need of a skilled Excel professional for data analysis. I have a dataset ready for analysis. Please note that the specific type of analysis hasn't been predetermined, so flexibility and expertise in various types of data analysis will be beneficial. Ideal Skills and Experience: - Proficient in Excel - Strong data analysis skills - Experience with various types of data analysis - Able to deliver insightful interpretations of the data
I'm looking for an expert in spreadsheet development to build a custom Excel sheet for tracking progress claims on construction projects. Key Features: - Automatic calculations: The sheet should be able to compute totals, subtotals, and other necessary financial figures without requiring manual input. - Customizable templates: The spreadsheet should be template-based, allowing for easy customization to suit different projects. Ideal Skills: - Proficiency in Excel with a strong understanding of its advanced features (formulas, pivot tables, macros etc.) - Experience in construction project financial tracking would be a significant advantage. - Ability to create user-friendly, customizable templates. - The data in the current pdf spreadsheet does not need to be fully rep...
...running web scraping script or using 3rd party App or platform. 3) It is your job to think, be creative and figure out what website, sources of contact info you will use. Some sources are listed in the link below, but you need to find your own sources. 4) Do not use chatGPT’s fake email address and phone numbers it spit out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the ...
...running web scraping script or using 3rd party App or platform. 3) It is your job to think, be creative and figure out what website, sources of contact info you will use. Some sources are listed in the link below, but you need to find your own sources. 4) Do not use chatGPT’s fake email address and phone numbers it spit out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper column formatting for easy readability purpose, post link to the ...
...of an Excel-Based Budgeting and Monitoring Tool for Construction Projects (WBS-Based) Description: We are seeking an experienced freelancer to create a budgeting and monitoring tool for construction projects, designed exclusively in Microsoft Excel. The tool must be based on a Work Breakdown Structure (WBS) and include task and activity management, rather than focusing solely on resources. Required Skills: • Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. E...
...compile contact information for 382 Conveyancing Solicitors and 313 Probate Solicitors within 25 miles of MK45 1AH. Requirements: - Data scraping expertise - Excel proficiency for data organization Task Breakdown: 1. Gather a list of 382 Conveyancing Solicitors and 313 Probate Solicitors using data scraping techniques. 2. Compile their details (Name, Company Name, Company Address, Phone Number, Email) into a spreadsheet. The email should be sourced from their respective websites. 3. Categorize the solicitors' data based on their type - "Conveyancing", "Probate", or "Conveyancing/Probate" (for duplicates). 4. Organize the entire list by distance from the postcode MK45 1AH. Please note: - The ideal freelancer should have experienc...
I'm looking for an Excel expert to create a comprehensive Excel sheet for my team's workload analysis and look-ahead program. Key Functions: - Workload Distribution: The sheet should help in distributing tasks evenly among team members based on their capacity and skillset. - Progress Tracking: It should allow us to monitor the progress of each task and project. - Deadline Reminders: The sheet should have a mechanism for reminding us of upcoming deadlines. The sheet will be used exclusively by my team members, so it needs to be user-friendly and intuitive. No integration with other software or tools is required. Ideal Skills: - Advanced Excel skills - Experience in creating workload analysis tools - Understanding of project management principles and tasks ...
I'm working on Excel export feature.
Automated Investment Management Tool for Rupeezy Broker (Phase 1: Buy/Sell Automation) Project Description: The objective of this project is to develop an Excel-based or standalone software solution integrating Rupeezy broker APIs. This Phase 1 focuses on automating basic Buy and Sell functionalities, along with real-time reporting, margin trading calculations, and investment tracking. Additionally, the tool will include a feature to automatically calculate target price adjustments based on user-defined profit percentages and margin costs, executing orders daily when conditions are met. Phase 1 Requirements: Core Features API Integration: Integrate Rupeezy broker APIs using: API Documentation GitHub Library Securely connect to the broker's platform for real-time data and o...
I'm seeking a meticulous data entry professional to help with organizing and validating customer data. The data is currently in Excel/CSV files and requires detailed validation for accuracy. Key Responsibilities: - Input, sort, and organize customer data with precision. - Perform detailed validation checks to ensure data accuracy. - Assist with data management and reporting as needed. Ideal Skills: - Exceptional attention to detail and accuracy. - Proficiency with Excel/CSV files. - Experience with data entry and quality control. - Strong administrative support skills. With over 24 years of experience in administrative roles, including expertise as a Steno-Typist, Personal Assistant, and Admin Manager, I am confident this project will be a success. I l...
I'm seeking an expert in Microsoft Excel to create a dynamic and visually appealing sales analysis dashboard for my bicycle business. This tool will help in understanding various performance metrics, and ultimately, in making informed business decisions. Key Features: - Incorporation of specific metrics: Sales trends by month, Profitability by product, and Customer demographics. - Exclusive use of Pie charts for data visualization. - Implementation of advanced data analysis techniques: Forecasting future sales and Seasonal trend analysis. The ideal candidate will have extensive experience in data analysis and visualization using Excel, with a strong understanding of business metrics. Prior experience in creating interactive dashboards will be a significant advantage. P...
I am seeking a skilled data analyst with a strong background in prescriptive analysis, utilizing Excel spreadsheets and SQL databases. The primary focus of this project is to conduct a thorough examination of our data for market research purposes. Key Responsibilities: - Conduct prescriptive data analysis to aid in decision making - Utilize Excel and SQL for data manipulation and examination - Deliver insights that can influence our market strategy Ideal Skills: - Advanced Excel and SQL proficiency - Expertise in prescriptive data analysis - Experience in market research analysis Please include your relevant experience and examples of similar projects in your bid.
I'm in need of an individual who can compile a comprehensive list of IT companies from Europe, Australia, and New Zealand that provide job sponsorships. The data should be sourced from the official government sites of the respective countries, ensuring accuracy and reliability. Please provide the URL from where you extracted the data. Details of the project: - Format: The extracted data should be in an Excel spreadsheet. - Information Required: For each IT company, please include the company name, LinkedIn URL, website, and number of employees. - Categorization: The companies should be categorized by country. Ideal Skills and Experience: - Proficiency in data extraction and Excel. - Familiarity with IT companies and job sponsorships. - Ability to source data f...
I'm seeking a detail-oriented professional to assist with entering customer data from Excel spreadsheets into our database system for my existing business. Key Responsibilities: - Accurately input customer data from Excel into our database system. - Maintain confidentiality and handle sensitive information responsibly. - Ensure data integrity and consistency throughout the process. Ideal Skills and Experience: - Proven experience in data entry, particularly with customer data. - Familiarity with Excel and database systems. - Excellent attention to detail and a commitment to accuracy. - Ability to maintain confidentiality and handle sensitive information responsibly.
I'm seeking a professional for data entry from digital PDF files into our existing business databases. This task primarily involves systematic and accurate inputting of data to ensure our records are current and comprehensive. Ideal skills for this project include: - Proficiency in data entry - Familiarity with handling digital PDF files - Attention to detail to ensure accuracy - Experience with database updates Please, only apply if you have relevant experience.
I'm looking for a data-savvy freelancer to help me gather information on software and AI influencers. The primary task is to find their email addresses, primarily from their personal websites and exact number of subscribers on YouTube. Skills and Experience Needed: - Proficient in web research and data collection - Familiarity with YouTube and other social media platforms - Attention to detail - Ability to present data in a clear and organized manner The data should be presented in a Spreadsheet (Excel/Google Sheets).
I need a proficient Android app developer to create a telecalling application. The app's main function will be for lead generation. Key Features: - Admin Panel: A separate web-based dashboard where I can upload contact details from an Excel sheet. - Click-to-Call Functionality: The app should display contact details for easy dialing. - API Integration: The app must utilize the Gsm (Phone SIM) for calling. - WhatsApp API: To send messages to end users directly from the app. - Feedback Mechanism: Incorporating a call disposition mechanism to capture conversation feedback through predefined options. - Tracking Features: The app should monitor total calls dialed, average talk time, and various call statuses (completed, missed, lead, callback, prospect, etc.) - Reporting: An...
...the top 50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize
I'm in need of a person to create an Excel catalogue for my collection of 78 RPM discs. (had to re post as images and uploads did not come through on prior post) With 203 images to work from, the catalogue will need to encompass several key pieces of information which is available on the image of each disc including the artist, song title, record label, catalogue number, genre, unique identifiers, and any other relevant details observable from the images. The final catalogue will also need to include a condensed size version of each photo. - Artist - Song Title - Record Label (exact wording) - Catalogue Number (if applicable on disk) - Genre (basic classification e.g., Jazz, Blues) - Unique Identifiers (full transcriptions of labels) - Any other information found on each pho...
I'm looking for someone proficient in Microsoft Excel to assist with data entry. The data is mixed - both numeric and text. Key Responsibilities: - Accurately input mixed data into Excel - Perform basic data validation checks to ensure accuracy - Report any discrepancies in the data Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Ability to perform basic data validation checks Experience with data entry and Excel is a must. I look forward to your bids.
I need an expert to help me through some excel questions for about an hour on a zoom call. My main goal for the call is: - Creating new formulas The ideal freelancer for this project should have: - Extensive experience with Excel, particularly with creating mathematical operations - Excellent communication skills for a seamless Zoom interaction - Patience and ability to explain complex concepts in a simple way
I'm seeking an experienced SQL developer to write a MySQL query for me. The task involves combining two data tables based on a specific column, with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the dat...with the aim of generating an output that includes SKU, Product Name, Sales Group, Category, Cost Price, and Sales Price. Key Requirements: - Combine the data based on the item_id column. - Filter the data based on the Sales Group. - Ensure the query is compatible with MyPHPAdmin. - The final output needs to be exportable to Excel. Ideal Skills and Experience: - Proficient in SQL and MySQL. - Prior experience with data integration tasks. - Familiar with MyPHPAdmin and Excel...
I'm looking for someone to manually collect email addresses from various programming sites. Skills & Experience: - Familiarity with programming sites like Stack Overflow, GitHub, and Reddit. - Experience in data collection and research. - Proficient in Excel, CSV and Text file formats. Please note, the specific programming sites and email types will be discussed further. I'm seeking assistance in collecting member emails from specific programming community websites I will provide. Your task will primarily focus on gathering emails of recent members from these sites. You have to manually go to user profile look, for his email if not there search email for same person from his linkedin profile or google or github or twitter etc etc profile. The ideal candidate for...
I'm seeking a skilled professional with deep expertise in dynamic programming and non-linear programming. The primary objective of this project is optimiza...non-linear programming. The primary objective of this project is optimization modeling, specifically targeted at leveraging dynamic programming techniques. Ideal Skills and Experience: - Advanced knowledge in dynamic programming - Advanced knowledge in operations research - Proficient in linear programming - Skilled in dynamic programming - Experienced in non-linear programming - Highly proficient in Excel for modeling and analysis Please note, the focus will be primarily on dynamic programming and non-linear programming. Your ability to apply these techniques to complex optimization problems will be key to the success o...
...including schools, estate agents, accountants, lawyers, and more. While we excel in technical expertise, we are seeking a dynamic and experienced sales partner to join as a co-founder to help us drive growth. The Opportunity: This is a unique chance to become a commission-based co-founder of a promising digital studio. You’ll take charge of sales and client acquisition, while we focus on delivering high-quality technical solutions. Together, we’ll scale the business and share in its success. What You’ll Do: - Develop and execute sales strategies targeting SMEs and specialist industries across the UK. - Identify, prospect, and generate your own leads, turning them into long-term clients. - Communicate the value of our web design and development services...
2d plans with furniture solution for - 75 seats - 100 seats - 125 seats - 150 seats - 175 seats - 200 seats - 225 seats - 250 seats 8 pieces 2d plans (black and white, pdf files)
I need someone to help me with typing some text data from an Excel file. The data is a few pages worth of text. Ultimately, I need the typed data to be compiled into a plain text file. Ideal Skills: - Proficiency in Excel - Fast and accurate typing skills - Attention to detail - Experience with creating plain text files
...an Excel expert to design a shift schedule for my employees. The system needs to accommodate rotating shifts, with 5 working days followed by 2 days off per week. Shifts will alternate weekly between morning and afternoon. And not all the off days occur on the weekends as I need the employees mostly at weekend so arrange the off days along the week and I need more than 6 employees each shift. Key requirements: - Shift Schedule: The schedule should cover 5 days of work and 2 days off each week. - Rotating Shifts: All employees will be on a rotating shift pattern. - Weekly Change: The shifts should change every week. Please note that the schedule does not need to take holidays into account. I will provide the names and details of employees. Ideal candidates should be proficient i...
...an international career. You stay updated on technology trends and terminology. You have excellent proficiency in English and are comfortable using grammar and spell-check tools. You approach tasks methodically and analytically, with an eye for scaling effectively. You are self-reliant and able to work with minimal supervision. You are proficient in spreadsheets, including MS Excel and Google Sheets. You excel in fast-paced, dynamic startup environments and adopt a proactive mindset. It is a plus if you have 2+ years of experience in related fields or hold a degree in Business, Sales, or Marketing. What You Will Do Develop narrative strategies for apps and games. Use LinkedIn and other platforms to generate and qualify sales leads and opportunities. Conduct sear...
Creating a set of variables based on 2 sets of cells. Column A has letters or number in it. Column B has letters or numbers in it. A1 VS B1 would have 2 variable outcomes in column C1 A1 or B1. If colum A and B is increasd to 2 cells then column C would have 4 outcomnes etc. I would also need to be able to pick how many cells in each column are active.
Se creará un sitio web con un hosting administrado por el cliente en php8.0, laravel, mysql6 y bootstrap, en el cual se contenga un login, un crud en El cual se debe adjuntar un Excel y rellenar unos datos adicionales mediante un formulario para formatear los datos que se deben mostrar en un PDF, una vez subido el Excel se va a generar un enlace público para visualizar dicho PDF, se contendra un histórico de Excel subidos en una tabla con buscador. A su vez se precisa de un formulario en el cual se coloque una referencia y se puedan actualizar los estados en el cual se encuentran los pedidos y posteriormente poder ser consultados de manera publica, como en la web de ejemplo:
...portfolio attached in profile. I am professional Structural Engineer with more than 08 years experience. I can design any types of residential and commercial buildings with proper structural analysis, Load calculation report and detailed drawing following by ASCE, ACI, IBC, BNBC codes. I have expertize in different types of professional software like SAFE, ETABS, AUTO CAD, STAAD Pro, SAP 20000, MS EXCEL, MS POWERPOINT etc. I have also expertise at 3D design and 2D draft work of AUTOCAD, SKETCH UP and other relevant softwares. I am able to deliver your project with all the key requirements and your timeframe. I have practical experience in many RCC structures, Steel Structures, Timber structures etc which were delivered to clients with their feedback. My team members are incor...
I need a QGIS plugin that can read addresses from an Excel sheet (addresses in Denmark, Europe), geomap them using a free geomapping service/plugin (already exists) so they show as dots on a map, and group them into custom map layers based on categories in the Excel spreadsheet. Key requirements: 1. Importing addresses from Excel to QGIS 2. Geomapping the addresses so they shown on a map as dots on the map. 3. Organizing the locations/dots into layers, grouped by custom categories in the spreadsheet. 4. Changing the color of the map dots based on info on the spreadsheet.. 5. Adding an infobox in QGIS, so when a dot on the map is clicked, information originally from the spreadsheet pertaining to that address will show in an info-box in QGIS. 6. Ability to mak...
I need an Excel expert to create a formula for me that ranks the numerical values in column F in descending order. The ranking should reset every time the time changes in column B. The formula needs to be inserted in column I. Key Requirements: - The data in column F consists of numerical values that need to be ranked. - The time in column B is in HH:MM format. - The ranking should reset for each unique time in column B. Ideal Skills: - Proficiency in Excel with strong formula skills. - Experience with data analysis and ranking tasks.
...partners have successfully transitioned from residential cleaning to focus on multifamily cleaning—and they’re making more money with fewer hassles! Multifamily clients offer steady, reliable work with fewer complications compared to residential cleaning. ✔️ Training & Certification As a PINCH member, you’ll get access to free training and certification through our online platform, preparing you to excel in the apartment community cleaning space. Once certified, you’ll be equipped to work with top property management companies. Who Are We Looking For? We’re seeking go-getters—independent contractors and cleaning teams who are ready to grow their business and take control of their future. If you’re committed to providing top-tier ...
More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? ASAP
I need approximately 16 pages of data integrated into my existing catalogue, designed in CorelDRAW. The data is available in an Excel file. This project involves adding both text and images, with the images being arranged in separate sections. It is essential that the text formatting is consistent with the style of the existing catalogue. Ideal Skills: - Proficiency in CorelDRAW - Experience with data integration - Attention to detail to ensure consistent formatting Please note: This project is strictly about data integration and following the specified formatting guidelines.
I'm looking for a Python expert to build a script that backtests screener results from over the past 9 years. The objective is to evaluate specific trading strategies, primarily breakout trading using indicator-based breakouts. Requirements: - The script should output results in an Excel file, allowing for the assessment of performance based on preset target/stoploss and max holding period. - It should focus on evaluating breakout trading strategies using indicator-based breakouts. - Prior experience with trading strategy backtesting and data analysis is highly desirable. Please note, the main goal of this project is to understand how effective specific trading strategies have been over the last 9 years. A deep understanding of Python, as well as knowledge of trading strateg...
...schedules and calendars for personal and professional appointments. Preparing coffee/tea and light refreshments as needed. Handling basic Microsoft Office tasks (Word, Excel, PowerPoint) for documentation and presentations. Maintaining and organizing files or records. 4. Errands and Miscellaneous Tasks: Booking appointments (doctor, tuition, repair services, etc.). Managing personal and professional travel arrangements. Assisting in planning family or work-related events. Requirements: Education: Minimum qualification: +2 or any degree. Skills & Experience: Proficiency in basic Microsoft Office applications (Word, Excel, PowerPoint). Strong organizational and multitasking skills. Prior experience as a personal assistant, nanny, or in a simila...
I'm looking for an Excel expert to create a comprehensive tipping calculator for me. The calculator should: - Allow for 5 tippers, with points ranging from 5 down to 1 - Tabulate the points for each selection - Convert these points into odds The data input will be manual, so the interface needs to be user-friendly and intuitive. A key feature will be the use of macros for automation, which will streamline the process and make it more efficient. Ideal skills for this project include: - Advanced Excel proficiency, particularly with Macros - Experience in creating user-friendly spreadsheets - Ability to convert complex requirements into a simple, functional tool.
Job Description for Graphic Designer (2-3 Years of Experience) Job Title: Graphic Designer (Specializing in Social Media Graphics and Cartoon Sketching) Job Overview: We are looking for a versatile and creative Graphic Designer with 2-3 years of experience to join our team. The ideal candidate should excel in creating engaging social media graphics, modifying designs to align with dynamic content requirements, and sketching unique cartoon characters. If you’re passionate about delivering visually compelling designs and bringing ideas to life, we want to hear from you. Responsibilities: Design eye-catching graphics for social media platforms tailored to target audiences and brand guidelines. Modify and adapt existing designs to fit various content needs, ens...
I'm looking for a designer to enhance the readability of our product catalogue and price list, which are 16 and 12 pages respectively. The desired style for the redesign is Classic and elegant, adhering strictly to our brand's design guidelines. Key requirements: - Expertise in product catalog design - Proficient in implementing brand guidelines - Experience in creating classic and elegant designs - Ability to enhance readability in design Please note, the goal is to achieve this at the lowest cost possible.
I need assistance to convert data from 11 Word documents into a Microsoft Excel or CSV file. The data in the Word documents primarily consists of text. The converted data does not require any specific text formatting to be preserved; plain text is fine. I would like the text to be organized in the Excel or CSV file with one paragraph per row. Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in data conversion tasks - Attention to detail for accurate data entry - Able to handle multiple documents efficiently.
Scrapping chain stores: The project: obtain the addresses of the points of sale for each brand in my file (I have 3669, organized and classified in an Excel file). The aim would be to have an Excel file for each brand, showing at least: - Name of the unit (=name of the outlet. Ex: Boulangerie Paul Quimper) - Address of the unit. If other information can be retrieved, it might be interesting to add it, for example:- GPS coordinates to ensure that the mapping will be accurate - Date of creation of the unit (= of the sales outlet) - Referenced website - Google rating, etc. But not necessary. I suppose the best place to find all this information is Google Maps, which will be the most up-to-date source. But maybe URSSAF or would be better sources, you tell me. To put it simply, ...
I'm looking for a professional who can create various types of charts (bar, line, and pie) from my Excel/CSV data files. The delivered charts will be static, so interactivity or animation is not required. Ideal skills and experience for the job: - Proficient in Excel and data visualization - Able to create clear, informative charts - Understands how to translate data into visual representations
