Importing excel access vba jobs

I am looking for assistance in automating the process of generating metrics to minimize human interaction and increase efficiency. My current approach involves the use of Excel Query, but I am open to exploring other Excel-based solutions if they offer better automation.

I'm in need of a hardware support expert for my RFID Card Reader project, which utilizes Arduino and GSM Modules. The data logs from the project need to be saved on Firestore. Key Responsibilities: - Setting up the RFID Card Reader - Integrating the Ar...Modules - Ensuring seamless logging of data to Firestore - Troubleshooting any hardware-related issues Ideal Skills: - Extensive experience with Arduino and GSM modules - Prior work with RFID Card Readers - Proficient in setting up and using Firestore - Strong problem-solving skills Please note, I will provide the RFID Card Reader, Arduino and GSM Module. However, the ideal candidate should have access to additional hardware for troubleshooting and testing purposes. Only apply if you have considerable experience with this t...

I'm encountering login issues with the Magento Admin. Specifically, I receive a message that I don't understand. This is preventing me from accessing the admin panel and managing my store. I need a Magento expert to help deci...is preventing me from accessing the admin panel and managing my store. I need a Magento expert to help decipher the message and fix the issue as soon as possible. Ideal candidates should have a deep understanding of Magento, experience troubleshooting admin access problems, and an ability to communicate technical issues in simple terms. I also would like to be able to fix such items myself in future so I will need to understand where the issue is coming from and how exactly this can be fixed. I need this asap since I can't access m...

Transcribe and translate live Hindi videos from streaming platforms Detailed requirement document: Skills and experience required: - Using ML and AI tools like HuggingFace and ChatGPT - Familiarity with streaming platforms and ability to navigate and access videos for transcription - Progrogramming to add stream to ML models - AWS Transcribe and other AWS tools to run applications. examples of live streaming videos : and You can use already existing models like this: AWS trascribe Google streaming speech recognition or train existing models to get better results. Detailed

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

Project Overview We want to create a complete mechanical design for a mini tractor utilizing a 7 HP diesel engine. The project deliverables will include conceptual sketches, 3D CAD models, engineering drawings, bill of materials (BOM), and detailed instructions for fabrication....consolidated list of materials, standard parts, fasteners, bearings, etc. Provide potential vendor/supplier references (if known). Assembly Instructions Outline step-by-step assembly instructions (text + diagrams/screenshots). Include notes on safety, best practices, and recommended tools. Deliverables (Milestone 4) Detailed 2D Fabrication Drawings (PDF + native CAD format). Complete BOM (Excel or CSV) with part numbers, material specs, approximate costs. Assembly & Fabrication Guide (PDF/Word)...

I am seeking a seasoned software...reservations, guest management, and billing. Key Features: - **Room Reservations**: A user-friendly interface for booking, checking availability, and processing payments. - **Guest Management**: Tools for tracking guest information, preferences, and feedback. - **Billing**: An efficient system for handling invoices, payments, and financial reporting. User Access: The system should be accessible to both Admin and staff. It should have different access levels to ensure data security and operational efficiency. The ideal candidate should have: - Proven experience in software development, particularly in creating management software. - Familiarity with hotel operations will be a significant advantage. - Excellent skills in creating intuitive ...

I'm seeking a skilled ethical hacker to conduct security testing due to unauthorized access to my accounts or systems. Key Responsibilities: - Conduct thorough security testing on my systems to identify vulnerabilities - Provide detailed reports on findings - Suggest and implement security measures Ideal Skills: - Proven experience in ethical hacking and security testing - Proficient in identifying and addressing system vulnerabilities - Excellent reporting and communication skills Please note: The specific systems or accounts that are of concern have not yet been identified, but the problem seems widespread. Therefore, a comprehensive and proactive approach to security is required.

...create a taxi application for my company, similar to Uber. The app must be compatible with both iOS and Android platforms and include the following features: Key Features: Real-Time Driver Tracking: Customers should be able to track their assigned drivers live on the map. In-App Payments: A secure, user-friendly payment system that supports multiple payment methods. Ride History: Users should have access to a detailed record of their past rides, including receipts. Customer Tracking: Essential for monitoring customer patterns to enhance service delivery. User Roles: Riders: A straightforward interface for booking rides, tracking drivers, and making payments. Drivers: A dedicated interface for receiving and managing ride requests efficiently. Admins: A robust backend system for ...

...create a taxi application for my company, similar to Uber. The app must be compatible with both iOS and Android platforms and include the following features: Key Features: Real-Time Driver Tracking: Customers should be able to track their assigned drivers live on the map. In-App Payments: A secure, user-friendly payment system that supports multiple payment methods. Ride History: Users should have access to a detailed record of their past rides, including receipts. Customer Tracking: Essential for monitoring customer patterns to enhance service delivery. User Roles: Riders: A straightforward interface for booking rides, tracking drivers, and making payments. Drivers: A dedicated interface for receiving and managing ride requests efficiently. Admins: A robust backend system for ...

I'm seeking a skilled software developer to create a tailored softw...Letter, Acceptance Letter, Engagement Letter, Management Representation Letter, NOC of previous auditor, Staff KYC, Etc. - Robust reporting and analytics capabilities - Automation of email notifications, data entry, scheduling, and other statutory records Integration: - Seamless integration with Excel sheets for reporting and analytics Ideal Skills & Experience: - Proficient in software development with a focus on analytics - Experience with task automation software - Strong understanding of Excel and data integration - Excellent communication skills for understanding office needs This project will significantly enhance our office efficiency and data management, making it a crucial investment fo...

Please Sign Up or Login to see details.

...Discounts, coupons, and reward programs. 4. Payment System • Integration with CardPointe, Stripe, and Dejavoo iPospays. • Secure online payments with tipping functionality. • Escrow system for payments until service completion. 5. Business Management Tools • Salon dashboard for managing appointments, services, staff, and inventory. • Inventory management with auto re-order alerts. • Employee access controls with custom levels. • Automated payroll calculation based on hours, tips, and commissions. 6. Customer Experience • Advanced search for services by location, reviews, or availability. • Favorites and wishlists for customers. • Service review and rating system. 7. Marketing & Promotions • Loyalty programs with redee...

Subscribers access pages on my site via the following process: 1/ They login via the script. This runs the script which enters a session cookie into the file. The session duration is set to 60 minutes. 2/ They try to access the page (for example). This has the following line - <!--#include file=""--> - in the code which checks the attached file to see if the user has a valid session and that a valid subscription type. All files cited above are available in the attachment. Here is what I am looking for: 1/ I have had this process for many years. It may be efficient or there may be better methods available. Can you update this process as appropriate? 2/ The new pages on my site are now created using php code

I'm seeking a developer to enhance my web app, , by adding a video history page (). This page should record which vid...page should record which videos have been added or removed, and when. Key Requirements: - The history data should be organized by user actions (i.e., grouped by 'add' or 'remove'). - For each video entry in the history, it should display the video title and the time of the action. - Access to this history page should be restricted to administrators only. Ideal Skills: - Proficiency in web development and familiarity with the tech stack used in the existing web app. - Experience with implementing user-specific access controls. - Ability to create a user-friendly, intuitive interface for the history page.

I'm in need of a proficient MS Excel professional who can assist me with complex formulas and functions, as well as creating charts and visuals. The primary goal of these tasks is to aid in financial modeling using sales data. Key Responsibilities: - Apply complex Excel formulas and functions for financial modeling. - Create detailed and informative charts and visuals based on sales data. Ideal Skills: - Advanced expertise in MS Excel. - Proficient in financial modeling and data interpretation. - Capable of creating professional charts and visuals.

I'm seeking to buy old Google Play consoles (2023 and earlier) for the purpose of launching new apps. Key details: - Budget: $800 for consoles with live app, $400 for those withou...to buy old Google Play consoles (2023 and earlier) for the purpose of launching new apps. Key details: - Budget: $800 for consoles with live app, $400 for those without - I'm a consistent buyer and can purchase as many consoles as you have - There's no specific regional preference as to where the consoles are registered, any region will do Ideal candidates for this project are those who have access to multiple old Google Play consoles. Experience in sourcing tech products, particularly gaming or app-related consoles, would be advantageous. Please feel free to reach out if you have con...

create a very basic website in wordpress using avada or elementor something.. must have a professional look... u must develop on ur own server first, once everythin is working, i will give u server access Design is key u must have API C# Webservice knowledge for a minor integration

...Monitoring client activity and ensuring they have the tools and resources they need for success. We offer: High Commissions – Earn lucrative payouts based on your referred clients’ trading activity. Exclusive Support – Access a dedicated IB portal with real-time tracking of referrals, commissions, and performance. Marketing Tools – We provide banners, promotional content, and other materials to help you effectively market the broker. Top-Tier Trading Conditions – A reliable and well-established broker with excellent trading terms and customer support. Educational Resources – Gain access to comprehensive educational content that you can share with your clients. Requirements: A strong network of traders or individuals interested in fore...

I'm looking for a skilled app developer to create a cricket scoring application that works on iOS, Android, and Web platforms. This app should be able to provide live scoring, track player statistics and generate match summaries. Key Requirements: - Cross-platfor...- Cross-platform app development experience, particularly with iOS and Android - Proficiency in web app development - Previous experience with sports scoring applications would be a plus - Strong skills in implementing real-time features like live scoring - Ability to create user-friendly interfaces The app should have user authentication, but only for admins or scorers. This will be a closed access app for general users. The ideal candidate would be able to deliver a high-quality, functional app that meets these ...

I'm looking for a concept design expert to help me convert my garage into a...house. Garage dimensions are 6m x 6m Key Requirements - Garage: - Garage design should reflect a modern style - The converted garage should feature an open concept living area and two bedrooms - The exterior finish of the design will be brick - 2 levels with internal staircase 2nd Floor Requirements - This is a completely separate level with no connectivity to downstairs - External staircase access - No rendering needed of this design The final deliverable should be a rendered picture of the final design (Garage only) Ideal candidates should have a strong background in architectural design, 3D rendering and a good understanding of modern design aesthetics. Previous experience with similar projects ...

I'm looking for an experienced Amibroker specialist who can help me create a custom indicator. I want you to code an exploration that finds all stocks that have not closed below the 20 day simple moving average (SMA) over the past 4 weeks. Make the SMA duration (default 20 days) and number of weeks (default 4 weeks) easily alterable in case I want to change ...for: - Current closing price (box coloured green if positive, red if closed down for the day) - Number of days the stock has closed above the SMA - Percentage price change in the last month (box coloured green if positive, red if negative), a column for the stocks’ sector and a column for the stocks’ industry. - Market cap of stock - Sector name of stock - Industry name of stock I have access to a No...

I'm looking for a Shopify expert to set up a basic Shopify store for me. The store should feature 5 physical products and include a related products section. Key Requirements: - Experience with Shopify store setup - Ability to integrate a related products section - Knowledge of and access to free Shopify themes - Able to design a simple, user-friendly interface Please note that the store will exclusively sell physical goods. I do not need any specific features beyond what has been outlined. The ideal candidate will be able to provide a seamless, efficient setup that meets these requirements.

...and lessons, so experience in developing e-learning platforms or similar is a plus. Website Features: - User Registration: The site needs to have a secure and user-friendly registration system. Ideally, the developer would have experience implementing similar systems in the past. - Downloadable Resources: There will be materials for users to download. This feature should be easy to navigate and access for all users. Ideal Skills and Experience: - Proficient in web development languages (HTML, CSS, JavaScript, etc.) - Prior experience creating educational or e-learning websites - Knowledge in implementing user registration systems - Ability to design a site with accessible downloadable resources - Understanding of creating a site with a focus on delivering courses and lessons T...

Generate Leads of driving Schools in USA Deliver in Excel Sheet

I need an Excel expert who can help me analyze our sales data and identify trends. The main objective is to leverage Excel formulas and tools for data analysis. I have a considerable amount of sales data that needs to be examined. The ideal candidate for this project should be proficient in Excel, with a strong background in data analysis. Experience with analyzing sales data specifically will be a plus. Key tasks will include: - Utilizing Excel's advanced features for data analysis - Identifying and interpreting trends within the sales data - Providing clear, concise insights based on the analysis Please bid if you can help me find trends in my sales data using Excel.

I'm looking to create a web app focused on real-time crypto trading. This app needs to be integrated with prominent trading platforms like Binance and Coinbase. A critical aspect of this project is implementing secure user access - I require Two-Factor Authentication for all users. Ideal Skills: - Extensive experience in web app development - Familiarity with crypto trading platforms, particularly Binance and Coinbase - Proficiency in implementing Two-Factor Authentication Please bid if you possess the necessary skills and experience.

I'm looking for an Excel expert to create an energy dashboard for me. The dashboard will need to display: - Electricity consumption - Renewable energy production - Water consumption - BTU consumption The data will be sourced from CSV files, and I would like the visualizations to consist of line charts. Ideal skills and experience for this job include: - Proficiency in Excel, particularly with data visualization - Experience in creating dashboards - Ability to work with CSV files - Understanding of energy data would be advantageous

...Issues: Investigate and fix the recurring scan_dir_push: open directory maildrop: Permission denied error. Ensure proper permissions and ownership settings for all required directories, including /var/spool/postfix/maildrop. Verify the integrity of Postfix configuration files and adjust as necessary to meet standard practices. Set Up Gmail Integration: Configure email rerouting to allow Gmail access and management of mail accounts hosted on our Plesk server. Ensure proper SPF, DKIM, and DMARC records are set up for secure and reliable email delivery. Test and verify email sending and receiving via Gmail for all specified domains. Test and Verify: Conduct thorough testing to ensure the mail server operates without errors. Provide detailed documentation of all changes and configu...

I'm looking for a professional to create a Gantt Chart in Excel for our project. The chart should include all project milestones, and be formatted using our company branding colors. Ideal Skills: - Proficiency in Excel - Experience with project management tools - Attention to detail Please note, the level of detail for task descriptions hasn't been specified yet, so some flexibility may be required.

... reflecting the brand’s identity. - Keep all text, shapes, and visual elements simple, bold, and clear. 5. **Functional and Technical Details** - Focus on practical elements such as durable materials suitable for food handling and daily use in supermarkets. - Ensure the foldable shelf is seamlessly integrated into the design and can withstand regular use. - Maintain easy access for staff by keeping shelves open and uncluttered. --- ### **Deliverables** - Two design options showcasing different approaches to the cart’s refinement. - Front, side, and top views for each design. - Clear placement of branding and text elements. - Visual representation of the foldable shelf in use. --- **Additional Notes:** The goal is to achieve a p...

I need a modern styled Excel spreadsheet quote template. The template should incorporate: - My company name - My company logo - My company stamp The design should be sleek and professional, in line with a contemporary business aesthetic. The ideal freelancer for this project will have strong skills in Excel and graphic design, with a keen understanding of modern design principles.

...attractive commission structures and growth incentives that are designed to reward our Channel Partners for their efforts and achievements. Training & Support: We provide in-depth onboarding sessions, product training, and continuous technical support to ensure that you are equipped to succeed in selling our solutions. Marketing & Lead Generation Assistance: As a Channel Partner, you will have access to a variety of marketing materials, promotional campaigns, and lead support to enhance your efforts in acquiring new clients. Flexible Business Model: Work independently while leveraging our proven expertise, allowing you to build your business and achieve your goals at your own pace. Growing Market Demand: With the increasing adoption of ERP solutions across various industr...

I'm in need of a Spring Boot specialist to assist me with migrating a small web application project from Spring Boot 1.5 to version 2.7. This project involves a professional collaboration, hence I can't share the code directly. We will be migrating the project together. Key Project Details: - The web application makes use of several components including Security, Data access (JPA/Hibernate), and REST API. - It is built using Spring Boot and Java. - There are several custom configurations and libraries in use, which adds to the complexity of the migration. Ideal Candidate: - Extensive experience with Spring Boot, particularly versions 1.5 and 2.7. - Strong understanding of web application development. - Proficiency in Java, JPA/Hibernate, and REST API. - Previous experien...

I'm experiencing file loading errors with Emlid Flow. ...seems to display hundreds of kilometers away. This is primarily with surveying data files from various devices including Trimble, Topcon, and Leica. I need a professional who can help troubleshoot these issues, train me on proper software and RX device usage, and assist with file imports in the future. Key Skills and Experience: - Deep understanding of Emlid Flow and RX devices - Proficient in importing and troubleshooting surveying data files - Experience with data from Trimble, Topcon, and Leica - Excellent training skills - Capable of creating aesthetically pleasing as-builts I want to understand why my data isn't displaying correctly and how to resolve these issues in the future. I'd also like to learn how...

...Implement event tracking to monitor user interactions with specific products. Define and track conversions to monitor sales originating from various channels and campaigns. Develop advanced segments to analyze specific user groups or behavior patterns. Configure multi-channel funnels to assess the contribution of different marketing channels to sales. Design custom reports and dashboards for quick access to key data views such as sales trends, marketing effectiveness, and user behavior analysis. Requirements: Profound knowledge of Google Ads and Google Analytics. Expertise in Google Tag Manager and its application across multiple platforms. Strong analytical and problem-solving skills, capable of managing complex configuration issues independently. Experience in optimizing Google...

I need to migrate my Windows Server 2019 Active Directory to a Synology Active Directory. The task includes transferring less than 50 user accounts along with their data and permissions. The project also involves removing the Windows Server from the network after successful migration. Key Requirements: - Migrate user accounts, data, and permissions - Ensure seamless transitio...accounts, data, and permissions - Ensure seamless transition for all users - Remove Windows Server from the network post-migration Ideal Skills: - Expertise in Windows Server and Synology Active Directory - Experience in data migration - Network management skills Please note, there's no specific software or service that relies on the Windows Active Directory except for logging into the domain to access...

...spreadsheet-like format. • Includes filtering and search functionality. • Editable Cells: • Customer data and analysis results can be edited in real-time. • Edit Logs: • Automatically save all modification history. • Logs include data before and after modification, along with timestamps. 4. Excel/CSV Export • Download grid-based data as Excel or CSV files. 5. Compressed File Processing • Automatically extract files when compressed files are uploaded to the server. 6. Selective Export • Export visible data on the grid as Excel or CSV. • Options to export only selected data. Automated Process Workflow 1. Data Upload and Email Attachment Saving • Store data through email attachments and file uploads. 2. Analysis...

...actions to prevent future returns. Dispute returns with Takealot if they are a result of a Takealot error. Compare shipment sent items with purchase invoices to ensure accuracy. Requirements: Basic proficiency in English and Urdu is mandatory. Familiarity with Excel is important. Previous experience with e-commerce platforms such as , Amazon, or similar is a plus but not required. A willingness to find and watch instructional YouTube videos to enhance learning about e-commerce practices. Additional Notes: You will be granted access to my PC via TeamViewer to explore the seller portal and learn. We are looking for individuals who can pick things up quickly and are keen to develop their skills as they work with us. If you're ready to dive into the world of e-commer...

I'm looking for an experienced Excel user to assist with creating a formula that sums a range of cells based on text matching criteria. Key Requirements: - Proficient in Excel with a strong understanding of creating and modifying formulas - Experience with conditional summing based on specific criteria - Ability to interpret and implement text matching criteria for the sum If you have the exemplary skills and experience for this task, please place your bid.

...management, attendance tracking, billing, and more. Project Overview Technology Stack** • Front-end: React and • Mobile App: Flutter (Android and iOS) • Backend: PHP (Laravel framework) • Database: MySQL Deliverables 1. Main Application Account • Dashboard • Customizable with widgets and graphical elements. • Client Account Management • Create, suspend, delete client accounts. • Access Control • Give access rights to certain features. • Billing with Deposits and Discounts • Implement basic functionality between super-admin and client accounts. • Website with Login • Basic login functionality. 2. Clients (Nursery Owners) • Dashboard • Customizable with widgets and graphical elements. • D...

I'm excited to present a lucrative franchise opportunity with ProfitPowerB and TechClouderPB1, two innovative tech solutions designed to drive business success. As a franchise partner, you will leverage state-of-the-art business tools and ERP systems that empower businesses to grow, streamline processes, and enhance profitability. Key Aspects of the Opportunity: - Access to cutting-edge technology and business solutions - Comprehensive marketing support to boost your franchise visibility and reach - Utilization of advanced ERP software with features for inventory management, CRM, and financial reporting Ideal Skills and Experience: - Passion for entrepreneurship and technology - Previous experience in franchise management or marketing would be advantageous - Strong understand...

I'm looking for a skilled Excel expert to create formulas for data analysis. The focus will be on descriptive statistics, specifically calculating the mean and median from my dataset. Ideal skills for the project: - Advanced Excel knowledge - Data analysis expertise - Familiarity with descriptive statistics

...allows non-technical users to make changes easily. Functionality: Clean, responsive design optimized for desktop and mobile. SEO-friendly structure for high visibility on search engines. Secure and fast hosting setup (recommendation or assistance with an Australian hosting provider preferred). Deliverables: Fully functioning website using our . domain. User accounts with full administrative access and training on how to edit/update content. Guidance on maintaining the site post-handover. Scope: Homepage and up to [insert number] additional pages (e.g., About Us, Services, Contact). Integration of basic features such as a contact form, social media links, and Google Maps. Optional: E-commerce capabilities (quote this separately if relevant). Support: Provide an initial set of ...

I am seeking a Wordpress expert to diagnose and fix issues on my Wordpress site hosted on a WAMP server running Windows Server 2002. You will access the server via my PC. I have tried .htacess and many more file settings. But did not work. Problem 1: going to Problem2: Enfold Theme: Button Link to - not working.

Project Title: Design and Engineering for Low Current Systems at Hotel in Saudi Arabia Project Description: We are seeking an experienced professional or team to provide Design and Engineering Services for the Low Current Systems of a Hotel in Saudi Arabia. This project requires expertise in creating detailed designs and layouts for the following systems: 1. CCTV Systems 2. Access Control Systems 3. Public Address Systems 4. Fire Alarm Systems 5. Audio/Video Systems 6. Conference Systems 7. Data Scope of Work: • System Design: Create comprehensive designs and system schematics tailored to the hotel's requirements. • Specifications and BOQ: Develop detailed technical specifications and Bill of Quantities (BOQ) for procurement and installation. • Compliance and ...

I'm seeking brilliant minds for a thrilling task that tests intelligence and problem-solving abilities to the max! If you are an analytical thinker with exceptional cognitive skills and a strong desire to succeed, this is your chance. Your task will be to excel in Cognitive Aptitude Analysis, demonstrating your reasoning and critical thinking abilities; proving your Mathematics Mastery through complex numerical challenges; showcasing your English Proficiency with advanced comprehension and communication skills; and leveraging AI & Machine Learning in Education to transform contemporary learning strategies. - Task: Completing a trial exam + five challenging online exams in Mathematics and English - Difficulty: Questions rated 10/10 - Time: Extremely limited - Integrity: Che...

My AWS EC2 hosted WordPress site is down and I can't access the instance via SSH. I need help to get the site back up and running, and a backup of the site and database taken for safety. - The main issue: The site is not loading at all. - Recent changes: There have been no changes made recently to the AWS instance or WordPress configuration. - SSH access: I cannot access the AWS EC2 instance at all. Skills Needed: - AWS EC2 - WordPress - Database Management - Site Backup - Troubleshooting Ideal Freelancer: - Someone with deep expertise in AWS and WordPress, capable of diagnosing and fixing issues quickly. - A professional who understands the importance of backups and can safely create a backup of my site and database. - A reliable communicator who can keep me u...

I'm looking for a freelancer who can assist me with my sales data. The tasks primarily involve data entry, data cleaning, and data analysis. The dataset is relatively small, with less than 1,000 rows. Ideal skills for this project: - Proficient in Microsoft Excel - Experience in data entry - Strong data cleaning skills - Capable of performing data analysis Please bid if you have the required skills and experience. Thank you!

1). I have a trading backtesting software, wherein I need to change n number of parameters for different instruments and different trade times and run the backtest. 2). Any parameter if I need to change, I spend lot of time in changing those parameters for all; quite a repetitive task. 3). It would have been great if the whole portfolio could be exported in excel format, so that changes could be done via batch edit much faster and imported back. 4). Unfortunately presently export import is via some port file, which is encoded/encrypted and can't be read or batch edited. Requesting any developer to help with this and also some additional features later. Thank you