Odbc connection string iseries server vba excel jobs

I am facing an issue on my Windows system where the internet disconnects every time I connect to my OpenVPN. This issue is significantly impacting my ab...OpenVPN. This issue is significantly impacting my ability to work remotely and access the resources I need. Key Points: - The issue started occurring when I began using OpenVPN. - I work on my system and the VPN is a critical part of my workflow. - The problem is specific to my Windows operating system. I am looking for a professional who has: - Profound experience with troubleshooting VPN connection issues, especially with OpenVPN. - Strong knowledge of Windows operating system networking and its interaction with VPNs. - Excellent communication skills and can guide me through the troubleshooting process in a clear and understan...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm in need of someone adept at PHP and SOAP. My development site is currently returning a warning message: "Attempt to read property "Invoice_Number" on string." I've set up a dev SOAP server for you to carry out the work. At this point, I'm uncertain if I'm attempting to access the "Invoice_Number" property on a string. There are also no other error messages accompanying this issue. Key tasks: - Identify the cause of the "Invoice_Number" warning - Fix the PHP SOAP warning Ideal skills: - Proficiency in PHP - Experience dealing with SOAP - Ability to troubleshoot and resolve such issues promptly

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

...VPN/Internet gateway solution. This project involves building server software capable of authenticating client connections and providing access to the internet. Requirements: Master's degree or PhD in Computer Science, Cybersecurity, or a related field Extensive experience in internet security, privacy, and VPN technologies Strong proficiency in server-side software development Familiarity with OpenWrt and router firmware development (preferred) Passion for internet security and privacy Responsibilities: Develop robust Wireguard exit nodes and VPN server software Ensure seamless integration with existing client software and VPN router firmware Implement secure authentication mechanisms for client connections Design scalable server architecture for hos...

...technology, MetaMatch aims to revolutionize fan interaction with sports through the integration of NFTs and real-time event engagement. The logo should encapsulate the essence of blending traditional sports with cutting-edge blockchain technology, appealing to both tech-savvy and sports-loving audiences. Specific Requirements: Concept and Design: The logo must convey a sense of innovation and connection, symbolizing the fusion of real-world sports and blockchain technology. It should be modern, easily recognizable, and scalable for use on various platforms and sizes. Color Scheme: We are looking for a color palette that stands out yet feels intrinsic to both the digital nature of blockchain and the dynamic energy of sports. Suggestions include, but are not limited to, combinat...

...published on a separate WordPress site. Ideal skills for this project include: - Strong understanding of WordPress development - Experience with creating custom plugins - Familiarity with WordPress APIs and data handling - Ability to work with cross-site data transfer The project requires: - Setting up a user-friendly form for registered users on Website A to create posts - Establishing a connection between Website A and Website B for seamless post transfer - Ensuring the posts are published immediately on Website B I'm open to your suggestions for user information that could be included in the post transfer, and I would appreciate your input on best practices for this kind of cross-website integration. Your input on potential security considerations for such integrati...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

...*** I'm facing significant challenges with my WooCommerce website's performance. Here's what I'm experiencing: - Slow page loading - High server load - Database query delays Although I’m already employing caching plugins and techniques for performance optimization, the difficulties persist. My WooCommerce site is hosted on a VPS/Dedicated hosting package. I'm in need of a WooCommerce expert who has significant experience in performance optimization, handling high server loads, and reducing database query delays. The ideal candidate should have: - Proven experience in troubleshooting and improving WooCommerce site performance - Strong knowledge of server management, particularly VPS/Dedicated hosting - Expertise in database managem...

I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

...js application. These include improper error handling, server banner disclosure, and misconfigured CORS. Requirements: - Identify and rectify improper error handling, ensuring that user-friendly error messages are displayed and errors are logged for debugging purposes. - Address server banner disclosure, to enhance the security of the application. - Modify CORS configuration to prevent misconfigurations and enhance security measures. I am looking for an expert who is well-versed in AWS, particularly in working with applications. The ideal freelancer for this job should have: - A thorough understanding of AWS services and its integration with Next.js. - Proficiency in addressing security vulnerabilities, in particular server banner disclosure and CORS misconfig...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for ...

My WordPress site hosted on AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity wi...

I am looking for an experienced developer that have worked on the signal messenger app to rebrand the app change icons and colours. We need installation on our amazon instance signal server and included all required backed services database etc. and publish application with custom icon colours and icons markets google and apple. you can look signal application

We are currently struggling with our WordPress site which is plagued by slow loading times, frequent server crashes and persistent error messages. Given the criticality of the platform, We need an expert who is adept in Internet Information Services (IIS) server management running WordPress environment and troubleshooting it at server level. To be successful in this role, you should demonstrate the following: - In-depth knowledge of IIS servers and WordPress operations - Proven experience in diagnosing and resolving server and website errors - Proficiency in optimizing WordPress sites for enhanced performance Please note, no recent changes or updates have been made to the website or server configuration that could be contributing to these issue. I...

I'm in need of a proficient expert who has hands-on experience with the Hestia Web Panel, VPS servers, and FileZilla. I own a VPS web server which I am having difficulties connecting to via FTP. The ideal freelancer for this task should have knowledge of: - Hestia Web Panel, and its API and configurations - How to effectively troubleshoot VPS servers - FTP access through FileZilla With this project, I need: - Full diagnosis and resolution of the FTP connection issue - Restoring the connection between the Hestia Web Panel and the VPS server via FTP - Ensuring there's seamless access to the VPS server Note, I can access the VPS server through SSH, thus you should also be comfortable working with SSH connections. Your expertise in resol...

I'm in need of an expert developer with a keen understanding of PHP, Heroku, and Shopify. This project entails the deployment of a Heroku server where my API key will be secure and stored in an environment variable. You'll also need to utilize this Heroku-based API key on my Shopify platform to access and display user data through API calls. Ideal Skillset and Experience Required: - Proficiency in PHP - Expertise in deploying and managing Heroku servers - Understands how to secure API keys on Heroku - Experience with Shopify API integration and displaying data.

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

Design and implement one page website. The website shall have a design similar to the included "reference ". Please also notice the "reference ...or bootstrap + jQuery. The website shall have a small database usage feature, in which every time the page is loaded, a new row is added to "leads" table with the following information: 1) Visitor's browser agent string, 2) Visitor's IP address, 3) 0 or 1 depending whether user is using a mobile device, 4) User's name, email, phone number and message if they fill up the contact form and click the "Send" button. Note: In case user send the form multiple times, then this data is overwritten in the same table row. After I accept your bid, you will get server access to the server...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a series of PDFs with text that needs to be typed into an Excel sheet. The data is mainly textual in nature. Key Requirements: - Data Entry: You'll be responsible for accurately inputting the text from PDFs into the corresponding cells in Excel. Ideal Skills: - Proficiency in Excel: You should be comfortable using Excel and have experience with data entry. - Typing Skills: Fast and accurate typing skills are essential. - Attention to Detail: The data needs to be entered accurately to ensure the integrity of the information. - Familiarity with PDFs: Experience working with PDFs is beneficial. Please note, there are no specific formatting requirements beyond accurate data entry.

I'm looking for an experienced Android developer to create a tablet version of my product catalog app. Key Features: - Offline Functionality: The app should be able to work without an internet connection, allowing users to access product information at all times. - Tablet-Optimized UI: The UI should be designed to provide an amazing experience on tablet screens, making use of the extra real estate and ensuring smooth navigation. - Multi-language Support: The app should support multiple languages, allowing users from different regions to easily understand and interact with the catalog. Ideal Skills: - Proficient in Android development, particularly for tablets - Experience with implementing offline functionality in Android apps - Strong UI/UX design skills, especially for tab...

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

I'm seeking a talented lyricist to create a rap verse in Hindi that directly incorporates and celebrates Pune-specific local dialect and slang. This rap verse should revolve around personal stories, creating a sincere and personal connection to both myself and the audience. Key Requirements: - Proficiency in Hindi language and familiarity with Pune dialect. - Proven ability to write engaging, personal, and relatable rap lyrics. - Strong understanding of the hip-hop/rap industry. - Adherence to deadlines while maintaining quality and authenticity of work. Please share your previous works and experiences in this field which relates to these requirements.

My web-based application is facing a critical issue that needs urgent fixing. The specific problem is functional, as the application is currently unable to connect to the database, which is affecting the user profile loading feature. This is a high priority task that needs immediate attention. Key Tasks: - Fix the database connection issue - Ensure the application can load user profiles seamlessly Ideal Freelancer: - Proficient in web-based application development - Experienced with database connectivity issues - Able to work under pressure and deliver quick results - Strong problem-solving skills and attention to detail.

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

I have 3 construction programs currently in Excel that I need to be converted into Microsoft Project. The programs are primarily focused on project scheduling and do not require resource management features. Key requirements: - Convert 3 construction programs from Excel to Microsoft Project - Create interactive Gantt charts with dependencies - No need for resource management features, just the scheduling aspect Ideal skills/experience for this project: - Proficiency in Microsoft Project - Experience in project scheduling and Gantt chart creation - Previous work in construction or similar industries would be beneficial Feel free to ask me if you need any further details.

...PHP frameworks like Laravel, CodeIgniter, and Symfony. This ensures it can be integrated easily into existing projects built on these frameworks (not obfuscating 1 by 1 every php file) - Advanced Obfuscation Techniques: I require the tool to support variable renaming. This feature is crucial for enhancing code security by making it harder for potential attackers to interpret the code's logic. - String Encoding: The obfuscator should encode only critical strings. By encoding these strings, the tool can add an extra layer of security to the application without impacting its functionality. Ideal Skills: - Proficient in PHP and familiar with various PHP frameworks. - Experience in developing obfuscators or similar security tools. - Knowledge of encryption and encoding techniq...

I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...

I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Past work How soon do you need your project completed? ASAP

I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...

...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...

need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.