As400 add records vba excel jobs

...quiz generation, AI-generated visuals for each question, and content optimization for YouTube. The project consists of multiple quiz categories, with a structured automation system to generate videos at scale. Project Scope: ? Quiz & Video Automation Create 5 master video templates for different sports categories. After template setup, remaining videos will be generated automatically from an Excel database. ? AI-Generated Visuals One AI-generated image per question to visually enhance quizzes. Each quiz contains 50 questions, requiring 50 unique images per video. ? YouTube Content Optimization Write video descriptions, hashtags, and metadata to optimize reach. Ensure consistent formatting for all uploads. ? Quiz Categories & Timeline International Soccer Teams (211 d...

I have a significant project involving over 1000 mechanical pipes. I am seeking an expert in Navisworks with over 5 years of experience who has worked on similar projects - preferably in mining or LNG. The task involves integrating inspection data from multiple Excel CSV files into the Navis drawing. Key Responsibilities: - Reflect the inspection data over the Navis drawing. - Update Navis drawings from 3D scans. - Previous experience with data modeling. The purpose of this integration is to enable different teams to use the drawing with data to extract specific details for various purposes, including: - Maintenance schedules - Compliance reports - Performance metrics - Pipe condition and defect Reports - Clash detection and inspection report Ideal Skills and Experience: - Exper...

I'm looking for a skilled accountant for my coffee exporting company. Your responsibilities will include: - Bookkeeping: Keeping accurate and up-to-date financial records of our transactions. - Tax Preparation: Ensuring compliance with tax regulations and preparing necessary documents for tax filing. - Financial Planning: Assisting in budgeting, forecasting, and strategic financial planning to help the business grow. As we're a coffee exporter, experience in trade and export accounting will be a plus. Since we currently do not use any accounting software, I would appreciate someone who can set up an efficient system for us, possibly recommending and implementing software like QuickBooks or Xero. Ideal skills and experience: - Proven experience as an accountant - Knowle...

...industry/niche. Develop a list of target criteria based on geography, company size, industry segment, etc. Data Collection and Verification: Gather essential contact details including full name, job title, email address, phone number, company name, and website. Verify the accuracy of all data collected to ensure high-quality leads. Database Creation: Organize the collected information into an Excel spreadsheet or Google Sheet with clear, standardized fields for easy filtering and analysis. Update and maintain the database throughout the project as new leads are identified. Tools and Methods: Utilize lead generation tools, CRM systems, and platforms such as LinkedIn, industry directories, and online business databases. Employ effective research techniques and adhere to ethical ...

...layout, header/footer, font style, spacing, etc.). Implement a solution (such as a macro or easy-to-use tool) that allows me to apply this template automatically with just one click to any document. Provide clear instructions on how to use the template or macro so I can apply it efficiently to new documents. Skills Needed: Expertise in Microsoft Word, including templates and macros. Familiarity with VBA (Visual Basic for Applications) for automating tasks (if applicable). Ability to create reusable templates that are easy to implement. Strong attention to detail and an understanding of formatting best practices. Additional Information: The template should work with Microsoft Word 2016 or later. It should be easy to update or adjust settings in case my formatting needs change in...

"Seeking an expert Excel developer to create a comprehensive 5 years business plan and management tool for my organization, a Data Centre services company preparing for IPO within 5 years. Project Requirements: 1. Daily organizational health dashboard 2. Department-specific input pages (Sales, Purchase, Accounts & Finance, HR, Logistics) 3. Real-time P&L updates reflecting daily entries 4. Automatic HR expense integration (salaries, incentives) with instant P&L impact 5. Weekly performance data and ratios for investors and banks Key Features: • User-friendly interface for daily data entry • Robust data validation and error-checking • Automated calculations and report generation in various formats • Year-on-Year comparison for important parameters...

I'm in need of a field verification executiv...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be between 1-5 per day. Verification reports can be provided in the local language of the ver...

...Apple, Samsung, Sony), Product Name (specific model name), Release Date (official launch date in India), and Price (current price in INR). The freelancer must source data from authentic and updated sources such as official brand websites, e-commerce platforms (Amazon, Flipkart, Croma), and reputable tech review sites, ensuring accuracy and completeness. The final dataset should be delivered in an Excel or CSV format with all categories properly sorted in chronological order. Preference will be given to freelancers with experience in data collection, data scraping, or market research, especially in consumer electronics. Interested applicants should provide an estimated completion time and, if possible, a sample dataset for review. Include products released in the last 2 years. En...

...Analytics? Healthcare predictive analytics involves using data, statistical algorithms, and machine learning techniques to analyze historical and real-time healthcare data to predict future outcomes. It helps healthcare providers make proactive decisions, improve patient care, and optimize resource allocation. Key Components of Predictive Analytics in Healthcare Data Collection – Gathering patient records, lab results, wearable device data, and clinical notes. Data Processing – Cleaning, structuring, and integrating different datasets. Predictive Modeling – Using AI/ML models, statistical techniques, and pattern recognition to make forecasts. Decision Support – Providing actionable insights for healthcare providers. Applications of Predictive Analytics in...

I'm urgently seeking an expert raw PHP developer for short term 30 days project. T...existing PHP reporting panel with SQL-Server database at our Nikaton, Dhaka, Bangladesh office. Freelancer have to work in our physical office . It's not a remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP and MS-SQL Server. - Excellent problem-solving skills for bug fixing and performance optimization - Familiarity with creating user-defined filters, customizable layouts, and export options Freelancers who are able to start tom...

I am in urgent need of an expert freelancer skilled in data copying. The task involves extracting text data from an online database and transferring it into an Excel spreadsheet. Ideal Skills and Experience: - Proficient in data copying and extraction - Experienced with online databases - Highly skilled in Excel - Detail-oriented and able to maintain data integrity throughout the process

...Spruce, and Care Patron ? Job Description: ? Project Overview: I need a fully automated telehealth system that runs 24/7 with minimal manual intervention. The system must handle patient intake, eligibility screening, payments, and records management using Microsoft 365, Power Automate, Spruce, and Care Patron. ? Key Features: ✅ Automated patient intake forms & consents ✅ Eligibility screening & decision-making (Pass/Fail system) ✅ Secure patient payments processing ✅ Automated patient notifications & scheduling ✅ Integration with Care Patron for secure patient records storage ? Deliverables: ✅ Step 1: Patient Intake Form (Microsoft Forms & Microsoft 365) Patients click the embedded form link on my website. They fill out intake details, sign consents, an...

... This role focuses on outbound calling and lead qualification to build a robust pipeline of prospective students. Responsibilities: 1. Conduct outbound calls to potential students, providing information about our university programs and addressing their inquiries. 2. Qualify leads based on pre-defined criteria, identifying students who are a good fit for our programs. 3. Maintain accurate records of all calls and lead information in our CRM system. 4. Schedule appointments for admissions counselors to follow up with qualified leads. 5. Meet or exceed weekly/monthly lead generation targets. 6. Stay up-to-date on our university's programs, admission requirements, and financial aid options. 7. Adhere to all university policies and procedures regarding student recruitmen...

...access an Excel sheet on Google Drive and display specific information from the sheet to users on request. Key Requirements: - The bot will retrieve and display share market data from an Excel sheet. - The bot should have 5 buttons, each providing different functionalities relating to stock data. - The bot should both read and update the Excel sheet with new information. Functionality of the 5 Telegram Buttons: 1. Name of Stock Purchased by Mutual Funds as on Date 2. Fundamental Stock for Wealth Creation 3. Bullish Momentum Stock- For Intraday, Swing Or Call Option Strategy 4. Bearish Momentum Stock - For Intraday or Put Option Strategy 5. Stock where Highest Delivery was taken Ideal Skills and Experience: - Proficiency in creating Telegram bots - Experience wit...

I need a skilled freelancer who can efficiently extract social media content from various sources including websites, social media profiles, and directories or databases. The extracted data should be delivered in Excel/CSV format. Ideal Skills and Experience: - Proficiency in data extraction and mining - Familiarity with social media platforms - Experience with web scraping - Ability to deliver data in specified formats

I'm looking for a skilled data scraper who can extract emails, phone numbers, and addresses from business directories. The final product should be delivered in an Excel spreadsheet. Key Requirements: - Proficient in using web scraping tools. - Experience with extracting data from business directories. - Attention to detail to ensure data accuracy. - Ability to deliver in an Excel format. Please include samples of similar work in your proposal.

PM me and i will send existing project let me know if you can do it before you can place your bid I have an existing C# project that needs to be modified by adding functionalities for 'Products' and 'Orders'. Your main task will be creating new Web API methods for each of these entities. All repository operations should utilize in-memory storage instead of the database. Specific Tasks: - Implement methods for create, update, delete, get by id and get a list (with filters). - The filters for the 'get a list' method should include: By date, By product name or order status, By user. - Follow the existing project's convention for naming the new Web API methods. Key Skills and Experience: - Proficient in C# and Web API - Experience with in-memory storage - ...

Please note that the Budget is fixed - Need very beginner skills users only - budget is a...improvement suggestions 2) Answer on your own for about 80 questions 3) Compile your answers in Excel worksheet and format as required. -this is a simple task and will require up to 5 sessions of 2 hours each via chat -Project budget is fixed and it is not by hour -Need users with beginner skills only -Please note no place holder bid - what you bid will be your final price for this task I'm looking for beginner users of social media apps to provide feedback on a new app. The primary focus is on user experience. You will need to compile your observations and feedback in an Excel spreadsheet. Ideal Skills and Experience: - Familiarity with a variety of social media apps - Basic ...

...travel data from a PDF into an organized Excel spreadsheet. The source material is PDF travel packages Responsibilities: Thoroughly review the provided PDF document. Extract data related to meet the required specifications. ( Name of hotel, travel date, Beds, flights etc..) Organize the data into a well-structured Excel spreadsheet with appropriate headings and formatting for easy search and reference. In Color Ensure accuracy of all data entries and correct formatting to maintain data integrity. Deliver a clean, searchable Excel file that categorizes different types of Hotels, rooms, according to size, type, type, and other relevant criteria. Requirements: Proven experience in data extraction and management. Strong proficiency in Microsoft Excel with ...

Please Sign Up or Login to see details.

...Specialist with experience in piping engineering to assist in converting technical data from a PDF into an organized Excel spreadsheet. The source material is the "TROUVAY & CAUVIN – PIPING EQUIPMENT 2001" book, which includes detailed specifications of pipes and pipe fittings. Responsibilities: Thoroughly review the provided PDF document. Extract data related to pipes and pipe fittings, including dimensions, weights, and specifications. Organize the data into a well-structured Excel spreadsheet with appropriate headings and formatting for easy search and reference. Ensure accuracy of all data entries and correct formatting to maintain data integrity. Deliver a clean, searchable Excel file that categorizes different types of pipes and fittings ...

Task for UiPath Developer We are currently using UiPath for automation and need a developer to enhance workflow efficiency and ensure proper job handling. Scope of Work: 1. Prevent Unnecessary Execution: After completing the scraping process for a specific date, write "Done" in the corresponding Excel sheet. Ensure the process does not continue running when there are no new tasks. 2. Automate Video Upload & Processing: After uploading a video to YouTube, take the video file and upload it to for automatic processing and splitting into clips. 3. Upload Clips as Shorts: Once completes processing, upload the generated clips as YouTube Shorts and TikTok videos. Additional Information: A detailed video explanation of all tasks will be provided for clarity...

I need a professional to assist me with Microsoft Word, Excel, and PowerPoint. Key Responsibilities: - Document Creation and Formatting: Creating well-structured documents in Word with a professional touch. - Presentation Design and Enhancements: Transforming my ideas into compelling PowerPoint presentations. Ideal Skills: - Proficiency in Microsoft Word, Excel, and PowerPoint - Excellent document design and formatting skills - Strong presentation design abilities - Attention to detail - Good communication skills Note: I am open to suggestions and further enhancements based on your expertise.

I'm in need of an Excel expert who can help me create dynamic data connections using VLOOKUP and HLOOKUP. Key tasks include: - Using lookup and reference formulas to establish these connections - Assisting with the necessary formula setup Ideal skills include: - Proficiency in Excel, particularly with VLOOKUP and HLOOKUP - Experience in creating dynamic data connections - Strong problem-solving abilities to troubleshoot any issues that arise Ensure the data connections update automatically. Please include additional data processing as part of the project requirements. part numbers

Please Sign Up or Login to see details.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I am in need of a dedicated and enthusiastic Talent Acquisition Specialist to spearhead our recruitment initiatives and assist in identifying top-tier ...from candidate sourcing to conducting interviews and facilitating onboarding. Key Responsibilities: - Formulate and implement effective recruitment strategies. - Identify potential candidates using job boards, social media, and professional networking. - Screen resumes, conduct interviews, and assess candidates. - Partner with hiring managers to clearly define job requirements. - Keep meticulous records in the Applicant Tracking System (ATS). Ideal Skills and Experience: - Demonstrated experience in recruitment or talent acquisition. - Excellent communication and interpersonal abilities. - Proficient with ATS and various recruitm...

Certainly! Here's an updated version of your description, now including both Excel data clearing and technical support for mobile and laptop devices: --- **Excel Data Clearing & Technical Support for Mobile and Laptop Devices:** Are you struggling with messy Excel data or facing technical issues with your mobile or laptop? I’m here to help! With a strong background in both data management and technical support, I offer comprehensive services to ensure your technology is running smoothly and your data is organized perfectly. **Excel Data Clearing Services:** - Removing duplicates and irrelevant data. - Correcting formatting errors (dates, numbers, text). - Standardizing data entries (addresses, names, product codes). - Identifying and fixing m...

I'm seeking a project manager with expertise in performance tracking to help me customize a scorecard template I have for tracking the performance of individual project managers. The template currently tracks all projects per project manager for the current year. Key Responsibilities: - Adjust the layout/design of the existing template t...Responsibilities: - Adjust the layout/design of the existing template to better suit our needs - Ensure the scorecard effectively tracks key performance indicators: task completion rate, time management, and quality of work Ideal Skills and Experience: - Previous experience in project management - Strong skills in data analysis and performance tracking - Proficient in design/layout adjustments of Excel or similar templates - Excellent atte...

I need to create a CRM to manage drivers, trucks and services (trips). Currently we manage everything on spreadsheets. Core Features: Database Management Store, add, remove, and edit records for: Drivers (personal details, license, certifications, documents) Trucks (model, plate number, maintenance records, documents) Services (Trips) (routes, assigned driver & truck, client, pricing) Clients (contact details, service history, payment status) Service (Trip) Management Add new trips and assign: Driver Truck Client Set trip price and payment terms Payment Tracking Client Payments: Full and partial payment tracking Payment status indicators (Paid, Pending, Overdue, partial) Driver Payments Track payments to drivers (e.g., per trip, weekly/monthly salary) ...

I am looking for a data entry operator who can efficiently handle text data sourced from online forms. The data will need to be entered into Excel spreadsheets. The ideal freelancer for this job should: - Have excellent attention to detail - Be proficient in data entry - Have experience working with Excel - Be able to work independently and meet deadlines - Possess fast and accurate typing skills Please bid if you're skilled and experienced in this type of work. The expected weekly volume of forms to be processed is between 100 and 500.

I'm looking for a professional who can help me develop a market risk model monitoring dashboard. This dashboard will primarily be used by our Fund Manager to keep tabs on our public, privet funds. Key Features of the Dashboard: - Monitor key metrics such as VaR (Value at Risk), Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and li... Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and limit checking. - Include any breaches in predefined risk thresholds. Ideal Skills and Experience: - Strong background in finance and risk management. - Proven experience in developing dashboards. - Prior work with public and privet funds is a plus. The dashboard should be developed using Excel...

For some reason, I'm unable to download the last 10 years of OHLC Nifty 50 data from my Fyers account. I need a professional to access my Windows computer, troubleshoot the issue, and download the data in Excel format. Key Requirements: - You must be able to remotely access a Windows computer - Proficient in using Fyers and troubleshooting data download issues - Able to download data in Excel format Ideal Skills: - Experience with financial data and stock market - Proficiency in using Excel - Good troubleshooting skills

Looking to Setup WhatsApp Business API for our e-commerce platform. Want to send notification , receive photo video with data from the vehicle info ,record data in excel, find info using number plate finder api, and generate QR and provide delivery tracking. Also need to send invoice and Any one already worked on WhatsApp Business API and understand it at deeper level should only bid for this project.

Please Sign Up or Login to see details.

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: * Call logging: The tracker should allow for detailed logging of calls made by representatives. * Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: * Proficiency in Excel and data analytics * Experience with creating tracking systems * Understanding of sales and call metrics

I am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology ...am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology company, be it a startup, medium-sized company, or a large corporation. Skills and Tools: The ideal role for me would require proficiency in Python and SQL, as well as experience with Tableau and Excel, and PowerBI. I am looking for a freelancer who is well-acquainted with the tech job market, has great networking skills, and can help me land a position that matches my skills and as...

I need a spreadsheet expert to help me analyze data related to divorces. The primary purpose of this project is data analysis. Ideal skills and experience for the job: - Proficiency in Excel or similar spreadsheet software - Experience with data analysis - Ability to identify trends, patterns and insights from data - Strong attention to detail

I need an Excel-based dashboard to monitor a maximum of seven items across 17 construction contractor packages. Key Data Points: - Budget and expenses - Change orders - Weekly progress reports per contractor - Resource allocation across all packages - Schedule tracking for each contractor package - Quality control measures and results Ideal Skills and Experience: - Expertise in Excel - Experience with data visualization - Familiarity with construction project tracking The dashboard should be easy to use, visually clear, and capable of tracking the aforementioned data points efficiently. Please use charts and graphs for the visualizations. Please use bar and line charts for the visualizations. Please include data filtering features to allow users to view specific subsets o...

I'm seeking an Excel expert with a solid background in accounting to enhance and redesign my current financial dashboard. Your role will involve improving the dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dashboard ...

I'm looking for a proficient developer to create a WebAp...output of quotes, invoices, and processing of payments. Key Functions Include: - Form entry for data collection and processing information to output on a dashboard - Basic calculation functions, primarily for freight cost estimation - Integration with Excel to allow for variable data changes - Imitation of a sample WebApp we have, with additional custom features Data to be Processed: - Customer details - Job request details - Vendor details Ideal Skills: - Proficiency in WebApp development - Experience with Odoo integration - Familiarity with Excel for variable data input - Understanding of basic freight cost calculations Please provide feedback based on this description. We can further discuss the details in...

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: - Call logging: The tracker should allow for detailed logging of calls made by representatives. - Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: - Proficiency in Excel and data analytics - Experience with creating tracking systems - Understanding of sales and call metrics

Hi Issak S., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

Hi issaksatta, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...intuitive dashboard that displays key metrics such as:○ Current check-ins and check-outs○ Vacant rooms for the day○ Upcoming bookings○ Recent cafe orders and reservations○ New Inquiry tabB. Booking Management● Check-In and Check-Out:○ Allow staff to check guests in and out.○ View details of the guests for easy access.● Vacant Rooms:○ Show available rooms for the day and future dates.● Add Booking:○ Quick access to add new bookings with guest details, room selection, andpayment options. WhatsApp integration for Booking details and payment links● Calendar View:○ Interactive calendar to view and manage all bookings, with color-coded statuses(confirmed, pending, canceled).C. Payment and QR Code Access● Payment Shortcut:○ Generate and display a QR code for customers to make pay...

I'm seeking a seasoned developer to create a comprehensive POS system for my pet shop. This system should seamlessly integrate our physical store sales, online WooCommerce transactions, and meticulous inventory management. It must also track detailed customer and pet information, including annual vaccination records. Key Features: - Multi-Platform Support: The system should cater to both our physical shop and online WooCommerce store. - Detailed Sales and Accounting: It should generate sales reports, handle tax calculations, and manage invoicing. - Customer Interaction: The system must send vaccination reminders via WhatsApp and Email, keeping our customers informed and engaged. - Staff Collaboration: It should allow detailed customer notes to be visible to all staff, e...

I'm looking for a data consultant to help with consolidating and analyzing a large number of Excel spreadsheets. The project involves: - Data Consolidation: Merging data from different spreadsheets into one cohesive dataset. - Pivot Tables: Utilizing pivot tables to summarize and analyze the data. - Lookups: Using lookup functions to cross-reference and find relevant data points. - Splitting of Files: Organizing and splitting data into manageable files. Ideal Skills: - Advanced Excel skills: Proficient in using Excel functions, formulas, and features. - Data Analysis experience: Previous experience in analyzing large datasets. - Attention to Detail: Ability to spot inconsistencies and errors in the data. - Time Management: Capable of working efficiently to meet ...

I'm seeking an expert in Excel who can assist with automating calculations and report generation in my bonus allocation workbook. The project requires the creation of a couple of bar and line charts, as well as help designing a tier-based system reliant on weighted project amounts determined by various financial metrics. Ideal skills and experience include: - Proficiency in Excel with a strong understanding of automation features - Experience with creating and interpreting bar and line charts - Knowledge of financial metrics and their application in project weighting - Ability to design a tier-based system. - Expertise in data visualization techniques The successful freelancer will help streamline my workbook, making it more efficient and user-friendly. The goal is t...

I'm seeking a personal assistant to help manage the bookkeeping for my stock trading account. Key responsibilities include: - Monitor trading activity for recording - Record and reconcile all transactions - Prepare trading journal and stock charts screenshoots - Ensure accurate and ti...data entry or bookkeeping, and excellent attention to detail. They should also be proficient with reading stocks price candle charts, having basic knowledge of stock trading (not mandatory), and proficient in using numerous tool for Visual illustration of trading journal, Microsoft office software with English language as these tasks may also be required. Candidates should be proficient in using Excel for financial record-keeping. The assistant will be required to handle bookkeeping tasks d...

I'm looking for a ChatGPT specialist who can integrate this AI tool into Excel for generating reports based on hospital data. The ideal freelancer for this job should have: - Proficiency in Excel and ChatGPT - Skills in AI integration - Report generation expertise Please note that the specifics of the report content have yet to be determined, so flexibility and creativity will be key to this project.