Excel vba as400 iseries access jobs
...existing Excel VBA project that interfaces with AutoCAD 2020. I'm looking for an experienced VBA developer to update the current functionality. Key Requirements: - This project involves updating an existing Excel VBA tool that works with AutoCAD 2020. The tool is currently used to generate data in Excel extracted in AutoCAD drawings what can be easy changed and send back to the relevant Drawings. You will be required to maintain the current functionality while also enhancing its capabilities. - The existing tool is aimed at automating the process of generating Excel data from AutoCAD drawings based on. The updated version should be user-friendly, and should ideally also allow for some form of automation of repetitive tasks within A...
I need someone to consolidate data from multiple Excel sheets. The data in these sheets consists of both text and numeric values. The goal is to bring all this data together into a single sheet, while handling duplicates in a distinct manner. Key elements of the project include: - Merging text and numeric data from several Excel sheets into one - Handling duplicate entries by marking them without removing - Organizing the data by grouping it as per the provided sheets separately Ideal candidates should have: - Proficiency in Excel and experience working with data consolidation - Understanding of handling and marking duplicate entries if any - Ability to accurately organize and group data Your task will be to create a consolidated view of text and numeric data from t...
Hi Work-Nix Solutions, I would like to work with you again please on refining the great Excel-spreadsheet that you have helped me to build.
I'm in need of an Excel developer who can aid me in analyzing data, creating advanced formulas and functions, and programming macros. With your expertise, the primary goal is to develop an Excel file that will be used to generate various reports. Ideal Skills and Experiences: - Proficient in Excel data analysis and manipulation - Experienced in creating advanced formulas and functions - Able to implement macro programming - Adept in generating insightful reports from complex data Our goal is to provide you with an exportable dashboard in Excel, a tool that will efficiently display opportunity details per property and provide a dedicated area for your notes. Opportunities that meet the threshold should display the value. The dashboard should be sortable a...
...their performance using advanced reports. Key Features: - **Ad Placement and Scheduling:** - The primary function of the ads manager will be to place and schedule ads on my website without any hitches. This should be user-friendly and efficient. User Authentication: - **Social Media Login:** - I'd prefer user authentication to be through social media login, making it convenient for users to access the ads manager without the need for remembering yet another set of login details. Reporting and Analytics: - **Advanced Level:** - The reporting and analytics generated by this tool should be comprehensive and insightful. It should be able to track conversions and provide a detailed ROI analysis. Ideal Skills: - Proficient in web development. - Experience in creating ad ...
I'm looking for a professional who can deploy IT policies with Microsoft...Clear Desk & Clear Screen Policy 2 Acceptable Use Of IT Assest Policy 3 Procedure Of User Access Management 4 Procudure Of Third Party Security 5 Vulnerability Management Process 6 Password Policy 7 Management Review Process 8 Mobile Usage & Electronic Media Policy 9 Teleworking Policy 10 Archival, Retention and Disposal Policy 11 Data Protection Policy 12 Information Continuity and Application Security Measure 13 System Configuration Standard IT Procudure Documents 1 Approved Software List 2 Asset Inventory 3 Deploying Anti Virus for Desktop 4 Workstation End Point Protection Standard 5 Firewall Configuration Stud 6 Patch Management 7 System Configuration Standard 8 User ID ...
Please Sign Up or Login to see details.
I am in need of a Senior Financial Analyst to assist with our company's financial modeling, forecasting, and data analysis and reporting. The ideal candidate must be familiar with various financial concepts, data analysis, and proficient in the use of Microsoft Excel, Tableau, and QuickBooks. Key Responsibilities: - Develop and maintain financial models for our operations and future forecasts - Analyze and interpret financial data - Prepare regular reports on financial performance - Utilize Microsoft Excel, Tableau, and QuickBooks for data management and analysis. The candidate must have significant experience in financial modeling and data analysis, preferably in a senior role. The ability to communicate complex financial information in a clear, concise manner is hig...
I'm seeking an expert in Windows Server licensing to clarify some key points. - I have a single Windows Server, specifically Windows Server 2019 or 2022. - 5000 user accounts will need to access this server concurrently and they will use web application on Blazor Server. - I need advice on the appropriate licensing model to accommodate this level of usage. Ideal candidates for this project are professionals with: - Profound knowledge of Windows Server licensing, preferably Windows Server 2019 or 2022 - Experience with large-scale user access scenarios and concurrent usage. - Ability to explain complex licensing models in simple, user-friendly terms. What is cheapest model for me to utilize. People will connect to app using Chrome browser and will login on app.
I'm currently experiencing issues with my Spring Security implementation, primarily related to authorization and access control errors. Key Requirements: - I'm looking to implement a role-based access control system for my endpoints. This means that different users will have access to different endpoints depending on their assigned role. Ideal Candidate: - Proficiency in Spring Security - Experience in fixing authorization and access control errors - Strong understanding of role-based access control systems - Knowledge of best practices for security implementations - Ability to implement hard-coded user roles in the application
I'm in search of an individual who is both tech-savvy and creative, capable of designing and editing an Excel-based yearly budget tracker for my department. This document must not only be functional, but visually appealing, making use of our company's branding and in a way that ensures user-friendliness. Key Requirements: - Creating a Comprehensive Tracker: I need a budget tracker that can calculate data and maintain it in a clear and organized manner, reflecting both incoming and outgoing finances. - Visual Appeal: This tracker should not be a typical, boring spreadsheet. It should feature vibrant colors and bold fonts, while still maintaining a clean and simplistic design. Additionally, it should incorporate our company's logo and color scheme to ensure it's o...
...Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core requirements, I am open to suggestions and m...
I'm in need of a tool that can effortlessly upload text information from an Excel document to a website form on a daily basis. The tool should also facilitate the mapping of Excel columns to the corresponding fields in the website form through a user-friendly interface. Key requirements include: - Daily automated upload of data from Excel to the website form - A straightforward, user-friendly interface for mapping Excel columns to website form fields - Accurate and efficient transfer of text information - A secure and reliable tool that ensures data integrity Ideal candidates for this project should have: - A strong background in web development with experience in form automation - Proficiency in Excel, including working with data extraction and ma...
...inputting it into an Excel spreadsheet. The key aspects of the project are: - **Data Extraction:** This involves comprehensively retrieving data from various websites. Some sites may have more complex structures, requiring the freelancer to navigate and extract data accurately. - **Excel Formatting:** The extracted data needs to be entered neatly into an Excel spreadsheet. - **Advanced Level Detail:** The data extracted should be detailed and comprehensive, including historical data and analytics where relevant. The ideal freelancer should have experience in web scraping and data entry, as well as a good understanding of Excel. They should be meticulous, capable of handling potentially complex website structures, and able to work with a high level of det...
I'm looking for a SEO specialist to help me to improve the traffic on my website. The focus is on local search engine optimization / onpage-seo. ## Note: - I need only an instruction excel - list. The language of the page is in german, but an online translation tool can be used. - No Plugin will be used, but other proven SEO - Tools are possible. Key Responsibilities: - On-page SEO analysis to identify the status of the page (one page, homepage) - You will send me your seo recommendations for onpage optimations - You will use a seo tool (we discuss which one is best) - I only need a written instructionfile what should be done at page, - start asap - Time: 2 hours a week for one month Ideal Candidate: - experience with on-page SEO for websites - Strong analytical skills ...
Hi Nadia A. The project is: Research and identify qualified 1,000 sign manufacturers /stores /sellers /suppliers (that sell signs) across Germany. Compile the leads data into a Excel format.
I'm in the health and care industry, concentrating on ensuring my clients have access to proper diet for their well-being. This is where your expertise in nutrition, meal planning, and dietary restrictions comes in. Key Responsibilities: - Nutrition Education: You are expected to provide insights to our clients on the importance of good nutrition. - Meal Planning: Create meal plans for clients that cater to their health needs. - Dietary Restrictions: Skill in addressing dietary restrictions such as diabetic diets is crucial. Ideal Skills and Experience: - Proven experience in the health and care industry, with a focus on nutrition and dietetics. - Strong knowledge of different dietary requirements including diabetic, gluten-free, vegan diets. - Excellent communication skills ...
As a client, I hold a ready-to-launch ott App, specifically designed for movie streaming. I require an efficient freelancer to facilitate the process of uploading and publishing this app on the Apple App Store. All necessary files and account access will be provided. Ideal Skills and Experience: - Proven experience with uploading and publishing apps on the Apple App Store - Familiarity with Apple's App Store Connect and its requirements - Experience in troubleshooting any potential issues during the upload process - Familiarity with entertainment apps, particularly ones offering movie streaming While the app has already been fully developed and is ready for upload, a basic understanding of app functionality could be beneficial in ensuring a smooth transition on to the Apple A...
...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong organizational and data handling skills. - Ex...
I have a list of 2060 SKUs in an Excel sheet that I need corresponding images scraped from Website A. Each image should be saved with the SKU number as the filename (e.g., for SKU 32440). Key Requirements: - Scrape images from Website A for 2060 SKUs - Save each image as a high-resolution jpg with the SKU number as the filename Delivery: - I will provide you with the Excel sheet containing the list of SKUs via email. - You should deliver the images in a compressed file with 2060 images, each named according to the corresponding SKU. Ideal Skills and Experience: - Experience in web scraping, particularly image scraping - Proficient in Excel for managing SKU lists - Ability to deliver high-resolution images - Attention to detail to ensure correct matching of SKUs an...
As a dedicated entrepreneur, I am excited to bring my ideas to life through a web application. I'm seeking an innovative developer for the task with experience in: - Making some edits to an already-built Bubble app. And edit some of teh existing UI/UX issues. - User Authentication mechanism: It's vital to ensure only registered users access the application. - Audit the app for security vulnerabilities and fix them. Key outputs: - A web application with user authentication. - Custom API workflows to streamline processes. We have a designer and SEO expert on board but are open to creative feedback to generate a visually appealing and user-friendly web application. An affinity for detail-oriented and creative design would be a significant plus. Just so you know, thi...
ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)
i want to be data entry job use word, pdf , excel , PowerPoint , and any type of graphic design work . i have 3 years teaching experience with data collection , data entry , and graphics design . i have fully and wonderful experience in Microsoft office , excel, PowerPoint , photoshop , illustrator, CorelDRAW, filora
We are seeking a skilled animator to create a high-quality medical training video, blending real patient footage with detailed animations. This 1-minute introductory video will address common mistakes in vascular access procedures, demonstrating the 'how' and 'why' behind each step. It will feature a mix of live footage and animations, covering crucial aspects like line cleaning, drying, and flushing techniques. The video will conclude with a call to action, encouraging viewers to sign up for a comprehensive training course. If successful, this project will expand into a full series of training videos, offering extensive content and interactive elements for healthcare professionals.
I am looking for a proficient data analyst who can access, clean, and analyze large volumes of customer data. Ideally, the freelancer should have a background in big data, business intelligence, and data visualization, and previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visua...
For this project, we need to consolidate customer data from multiple Excel files into one Excel sheet using macros. This will allow us to manage our data more efficiently. Key tasks include: - Creating a macro that can extract and merge customer data across several Excel files. - Managing the data in a way that it is grouped by Customer ID. Skills and Experience: - Extensive knowledge in Excel and proficiency in creating macros. - Prior work experience with data consolidation projects. - Exceptional attention to detail. - Ability to organize data effectively. - Knowledge of data management according to customer demographics.
My Wo...urgent issue that needs to be resolved within the next 24 hours. Key Tasks: - Investigate the issue: Identify the root cause of the redirect and provide a detailed explanation of it. - Fix the redirection: Modify the link to correctly direct users to the intended phone number without any detours. - Testing: Ensure the link functions as intended across different devices and browsers. I have full access to the website's hosting and admin panel, making it easier for you to troubleshoot the problem. Ideal Skills and Experience: - Extensive experience with WordPress and website development. - Proficient in debugging and troubleshooting website issues. - Strong knowledge of URL redirection and fixing related problems. - Ability to work under tight deadlines and deliver re...
...data from Excel Sheets. The goal of this task is to determine if the presented ad spend had a significant impact on total sales or sales in our stores. The data spans from May 2016 to May 2024. Key Requirements: - Compile ad spend data from Google Ads and Facebook Ads, and sales data from Excel Sheets. - Perform trend analysis on the data sets to determine if any discernable impact exists between the ad spend and sales. - The focus should be on whether ad spend, regardless of platform, led to a measurable and discernable difference in sales. Ideal Skills: - Strong data analysis and interpretation skills. - Proficiency in working with ad spend and sales data. - Experience with trend analysis and correlation studies. - Proficient in Google Ads, Facebook Ads, and...
...user-friendly system for uploading, managing, and accessing organizational documents. - Employee directory: A comprehensive, searchable directory that includes key information and contact details. - News and announcements: A platform for posting and sharing company updates and important news. - Custom features for onboarding and pre-onboarding: An interactive area where new and potential employees can access relevant resources and information. The project involves moderate customization with the addition of some unique features. Experience in building SharePoint Online intranets and expertise in customizing SharePoint solutions is highly desirable. A keen eye for UI/UX design and the ability to create a user-friendly experience is also essential. If you have a proven track rec...
I'm on the lookout for a developer who can assist me in testing the roles and endpoints within my system. Specifics: - The system consists of three primary roles...endpoints, your primary focus will be on testing a single endpoint. This endpoint remains undisclosed here, but will be shared with you upon selection. The project has an urgent requirement. I'd appreciate it if the work could be completed ASAP. The ideal candidate for this project: - Should have a comprehensive understanding of role-based access control (RBAC) in web applications. - Proficiency in endpoint testing, particularly in the context of role-based access. - Proven experience in web application security and testing will be a definite plus. Please share your relevant experience and approac...
Hi, i am looking for help with a solidwork project. I want to build tuned pipe , expansion chamber for dirt bike. I do know all my dimensions lenght and diameters. I want to be able to draw a line wich will be my centerline and then on this line i want customize every lenght and diameter of each section. Then had radius in sections. ...adjustable point to be able to adjust length and diameter for each my subsection. Because each pipe is build with many differents cones -Each section/cone needs to be customable on the amount of flat pattern needed. Each flat pettern are to be angle from both edges Steel plate thischness will be 1mm All dimensions are to be outside diameter. I want to be able to enter all my dimensions and length on an excel sheet(edit table) that will be included in ...
I'm looking for a skilled developer to update our Android platform APK for NFC access control on a custom-made board. Now we need to make it Cross platform and utilize the NFC CARD EMULATION system on the mobile device The Application is already developed and i have the source codes so i would like to work on it and not created from the scratch. The android version is located in the Andorid Store under the name of "PELEKIS NFC access control" Key Requirements: - The APK should be compatible with both Android and iOS platforms. - The main purpose of this APK is to facilitate NFC access control on a custom board, made specifically for this purpose. - The specific functionality required for this project is read/write capabilities. Ideal Skills: - Prof...
Translation of two files, from English to Hebrew. File #1 contains 8 rows of text in Excel format, 119 English words. File #2 contains 85 rows of text in Excel format, 2,035 English words.
I have a registered domain with OVH hosting and need an expert to set up professional email accounts using Gmail. Here are the project details: - **Initial Setup**: I need the freelancer to set up between 1 email account. The ideal candidate for this project should have a strong background in email management, domain hosting, ...with OVH hosting and need an expert to set up professional email accounts using Gmail. Here are the project details: - **Initial Setup**: I need the freelancer to set up between 1 email account. The ideal candidate for this project should have a strong background in email management, domain hosting, and Gmail. Experience with OVH hosting would be an added advantage. Please ensure that you have access to all necessary tools and can complete the setup ef...
I require a Python script that can scrape specific data and images from the top 10 property websites in the UK. The script should be able to: - Extract property prices - Obtain property descriptions - Retrieve contact information for listings - Retrieve the property images I have a list of the top 10 property we...that helps the project to success. Skills and experience needed for this project: - Proficiency in Python programming - Prior experience with web scraping, particularly from dynamic websites - Ability to work with and manipulate large amounts of data - Understanding of property listing sites and their structures would be a plus Your solution should output all the data in an organized and easy-to-access format. Please highlight any similar projects you've worked ...
...administration, and data isolation. Key Requirements: - Implement a robust user authentication system, ensuring that only authorized users have access to the system. - Develop a seamless tenant administration system, allowing me to manage different tenants within the application. - Ensure data isolation is maintained between tenants, guaranteeing that each tenant's data is secure and isolated from others. - Integrate DNS functionality within the application, allowing me to manage DNS, configure DNS records and resolve DNS queries. Ideal Skills: - Proven experience in developing multi-tenant .NET applications. - Strong understanding of user authentication and access control mechanisms. - Proficient in DNS management and configuration within a .NET environment. - Ex...
We have a list of around 4,795 energy consultants. This list contains the name of the consultant, the company name they work for, contact information including general email address, telephone number, website, and address. However, we need you to find out the personal corporate email address of each consultant, and insert it into Column K in the Excel sheet. Check the attached file. Time : 48 Hours Budget 50$ Lowest Bidder will win Milestone Payment : no advance milestone payment. After Completed work get payment. Thanks
..."About Us" page, and an introduction. MAIN SECTION OF THE BROCHURE: 01. 31 SERVICE PAGES: Each of these pages presents a specific IT service of our company. 02. 8 CATEGORY PAGES: These pages group various services under thematic focuses. 03. INDEX PAGE: A comprehensive table of contents listing all services, categories, and the additional service page, 04 facilitating easy navigation and quick access within the brochure. 04. INTRODUCTION: A brief introduction to the brochure, outlining its purpose and providing context for the content. 05. "ABOUT US" PAGE: This page provides an overview of our company, mission, vision, and values. 06. COVER PAGE: The front cover of the brochure, designed to attract attention and provide a professional first impression. 07. B...
...credentials securely in a database, with password hashing and salting for security. -Allow user to make remember me so they don’t have to login each time. **2. User Login:** - User enters their username and password on the login page. - The system checks the provided credentials against the database records. - If the credentials are valid, the user is granted access to their account. **3. User Home Page:** - Upon successful login, the user have access to calendar. **4. Availability Calendar:** - On the user's home page, display a calendar where users can set their availability. - Users can click on specific dates and indicate their availability (e.g., available, unavailable). - Store the user's availability information in the database. **5. Notificatio...
I'm seeking a freelancer to correct the date format in my Excel sheet that is currently not displaying correctly. Key Requirements: - The Excel sheet must display dates in the format DD/MM/YYYY. Additional Details: - The corrected date format is only required on specific sheets within the same workbook, not all sheets. Ideal Skills & Experience: - Proficiency in Excel and its date formatting functions - Experience with correcting date format issues in Excel - Attention to detail to ensure all specified sheets are updated correctly.
I need a freelancer to search List of Medical centers & Hospitals in Australia. Currently we have a list of centers & hospitals but need to search & add about 3000 more which are not included there (Including the contact details). We need a complete file with accurate detils & milestone will not be released until the work is checked. All centers should be added as per the state. Please quote with the time period & the exact fees you will charge for this. Ongoing work for successful candidate.
3-4h live support needed via teams. The request has to be fulfilled this week. I'm in need of a professional who can assist me with creating workflow automations and integrating with Microsoft applications. We will organise a teams sessions and go through the desired customizations , all the work is done via remote access. I have a Microsoft environment comprising of SharePoint, Outlook, Teams, Word, Excel, and PowerPoint. Some tasks need to be automated such as document approval , collaborations and other SharePoint settings. Ideally, you should be highly proficient in Power Automate (Microsoft's workflow automation tool) and have strong experience in integrating various Microsoft applications. A background in SharePoint, Outlook, Teams, and the Office suite is...
I have a basic school project that requires inputting provided data into Microsoft Excel. Here are the specifics: - You will be provided with a simple dataset. - The main objective of the project is to input data from this dataset accurately based on the given instructions. The ideal freelancer for this project would be someone who is: - Proficient in Microsoft Excel. - Detail-oriented to ensure accurate data input. - Able to follow provided instructions carefully.
**Project Objective:** We are looking to automate the management of absences within our company using VBA Excel. The goal is to simplify and optimize absence tracking, reporting, and data analysis to save time and improve accuracy. **Project Description:** The project involves developing an automated solution in Microsoft Excel that includes: 1. **Absence Data Entry:** - Interactive forms for entering absences (sickness, vacations, authorized absences, etc.) - Data validation to ensure accuracy and consistency. 2. **Automatic Absence Calculation:** - Automatic calculation of absence days per employee. - Tracking different types of absences and their quotas (paid leave, sick days, etc.). 3. **Report Generation:** - Creation of weekly, monthly, and ann...
...The app should specifically be developed for Android devices. - Comprehensive Information: The app should provide detailed information on all family planning methods, including effectiveness, usage instructions, and potential side effects. - Side Effects and Management: Users should be able to access information on the potential side effects of various family planning methods, as well as guidance on how to manage these effects. - Referral Service: The app should offer users options to find and access family planning services through a referral system. User Interaction: - The app should present information in a variety of formats to cater to different learning preferences. This includes: - Articles or Guides: Users should be able to read through comprehensive articles on...
I have a Microsoft Excel assignment that needs expert handling. My needs include: - Data analysis: I want to make sense of my data, and uncover any hidden trends or correlations. - Formula creation: I require the creation of Excel formulas to automate data processing tasks. - Graphs and charts: I need insightful visuals to represent my data. This will aid me in understanding and communicating it more effectively. While it's unfortunate I could not provide more detailed information, it's vital that the freelancer can work with a certain degree of ambiguity. Expertise in Excel-based data analysis, formula creation, and chart and graph creation are essential. An ability to uncover data insights, no matter how small the dataset, will be highly beneficial.
I'm looking for a skilled Laravel developer to integrate a live chat widget into my existing website. I will provide the necessary tag code and you will need to access my SFTP Server to complete the task. Key responsibilities: - Integrate a live chat widget to the HubSpot platform on my website. Requirements: - Expertise in Laravel PHP framework. - Experience with integrating live chat widgets. - Prior experience working with SFTP Servers. - Proficient in working with HubSpot platform. Your role will be crucial in enhancing the user experience on my website and providing a seamless live chat functionality for my visitors.
I need help with a data entry task that involves copying and pasting data from PDF documents into an Excel spreadsheet. Key points: - The task involves strictly copy and paste work, no data cleaning or formatting is required. - The primary source of data is PDF documents, so proficiency in extracting data from PDFs is a plus. - The data should be accurately transferred into an Excel spreadsheet. Ideal Freelancer: - Proficient in PDF data extraction and Excel. - Attention to detail is crucial. - Previous data entry experience is preferred.
I am in need of an expert who can successfully appeal and reinstate my closed Transferwise accounts. Some of them were closed due to my cryptocurrency trading activities, but others were shut down without any clear reason. I am willing to pay $50 per account for the appeal process, and an additional $100 for each account that successfully gets reinstated. Ideal Skills ...specific information or evidence that should be included in the appeal, as I'm not sure about the reasons for account closure or the exact requirements of Transferwise. Therefore, I would need you to take the lead on this, and potentially seek information directly from me or Transferwise if needed. The ultimate goal of this project is to achieve either full reinstatement of the accounts or partial access wi...
