Excel data connection as400 jobs

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I'm looking for a developer to create a VPN application that will run on both IOS and Android. This application should support both SoftEther VPN Protocol and OpenVPN. Key features to be included: -Protocols: Support both SoftEther VPN Protocol and OpenVPN. - Data encryption: An essential feature for securing users' data - Kill switch: A crucial function that ensures users' internet traffic is cut off should the VPN connection fail - Multi-location support: The VPN should offer various server locations for users to connect to securely The ideal candidate should have experience in developing applications for both IOS and Android, as well as prior experience in VPN development. A strong understanding of network security concepts and protocols is a must. ...

I am currently experiencing payment processing errors with my PayPal plugin. All of my sales are automatically cancelled and I am not being notified. -Ideal Skills/ Experience: * Proven experience in troubleshooting PayPal plugin problems * Comprehensive understanding of payment processing * Ability to identify and solve connection issues. Let's collaborate to sort this out promptly to resume normal business operations.

I'm seeking to build a website catering to pickup soccer enthusiasts. The central functionalities I wish to incorporate include: 1. User profiles: This is a pivotal feature through which players can create and manage their profiles. Skilled in form design and data management would make for a perfect fit. 2. Messaging system: An integrated messaging system will permit players to converse, coordinate, and plan games. Experience in developing seamless communication tools is beneficial. 3. Game scheduling/calendar: A calendar feature for easy game scheduling is crucial. I expect your prowess in creating intuitive date-time functionalities to shine through here. 4. Field locator/map: Leveraging mapping APIs to find nearby playing fields will be a valuable element. The ideal cand...

I'm seeking a skilled video editor who can rework my 1-2 hour wedding reception video. The previous editor's work is not satisfactory to me. Key requirements: - Improve transition effects: The...beauty and emotions of the event in a professional manner. Ideal skills and experience: - Proven experience in video editing, particularly with wedding videos - Proficiency in transition effects, color grading, and audio enhancement - A good eye for song selection that enhances the overall video - Strong knowledge of cinematic editing styles - An understanding of the aesthetics and emotional connection needed for wedding videos. If you're confident in your abilities to transform this video into a professional, visually stunning, and emotionally engaging piece, I look for...

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow...

I'm seeking expert to assist in configuring a Site-to-Site VPN on my Zyxel USG Flex 50, ensuring secure and reliable communication between our networks. Key Tasks: - connect to a already existing site - configure usg flex to not use dhcp and other option. just need vpn. i have a box behind Ideal Skills and Experience: - Proficient with Zyxel USG series - experience in VPN connection

I need a minimal working example of PPPOS in IDF framework v4.4.7. The requeriments are: - Minimal example with SIM800L modem. - Create and configure esp_netif for PPP (create the driver, and task to receive data from modem and send to esp_netif) - Configure the modem via AT commands (PPP conection ATD*99#) - After succesfull connection, make a http request for testing. The most important thing: DO NOT USE esp_modem component. The example must do not use any component, simply the esp_netif API.

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to...

...guiding users through the process in an intuitive, engaging way - Draw all steps, Incorporate high-quality images, illustrations, and/or animations to richly visualize each step and bring our process to life - Design infographics or interactive elements to explain key concepts like curing, conditioning, and grading - Utilize images of our vanilla terroir, farmers, and facilities to forge a deeper connection with our origin and story 2. Written Content: - Craft clear, concise, and evocative copy to accompany the visuals and narrate the vanilla's journey - Highlight key points of differentiation, such as our origin, traditional techniques, and quality control processes - Emphasize our commitment to sustainability, fair trade, and community support 3. Brand Alignment: - En...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria fo...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I'm looking for a skilled professional to set up a site-to-site VPN connection to my Azure cloud infrastructure. This setup is crucial for our business, as we have a hybrid network environment, comprising both on-premises and cloud-based resources. Key Responsibilities: - Establishing a secure and efficient site-to-site VPN connection from our on-premises network to Azure - Ensuring that both our servers and workstations can securely and seamlessly communicate with Azure resources through the VPN Skills/Experience Needed: - Proficiency in network security and VPN setups - Specific experience with establishing site-to-site VPN connections to Azure will be highly valued - Ability to configure and troubleshoot VPN connections for both servers and workstations - Strong und...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

...as follow, Home Page: Presentation of Equità Ltda. Links to the main areas of the site (Equita Club Deals, Equità Bio Casa Imobiliária, Equità Construction Products and Services). Equita Club Deals (private P2P functionality): Login/Register Projects page Investor dashboards Access to documents and contracts Equità Bio Casa Imobiliária: Property listings (template creation and eventual API connection to partner real estate brokearage platform) Property details Contact form Equità Construction Products and Services: Product catalog (API connnected to dropshipping platform) Service forms About Us: Company history Team Blog: Articles on the real estate and construction market Contact: Contact form Contact information Location ...

...is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and log...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

...site are hosted and the site is complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with ...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work...

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

...Programmer has to use our web app url as attached in WebView framework of android. We need to provide link for camera and upload from gallary feature from many pages of our web app. kindly let us know how will programmer provide it?. 2. We only need use camera and file upload from mobile gallary into our webserver file folder via ftp and related data entry in sql server database. we will provide necessary tables, fields, data types, views and database connection strings to programmer. We will provide the design which wil integrate with our MobileERP Software with its internal structures like DID. 3. Our following applications will us above camera and upload features with GPS Location storage in sql server database. a. When employee entering attendance when on sit...

In this engaging task, I'm looking to hire a skilled music producer to merge two songs I have, creating a seamless transition. The desired outcome is a final product that smoothly flows from one song to another, maintaining the integrity and flow of each. Key Responsibilities: - Merging two songs into one cohesive MP3 file - Achieving a seamless t...merging - Proficient in relevant music production software - Creates high-quality MP3 formats - Strong attention to detail to maintain the integrity of the original songs - Evidence of previous similar work would be a significant advantage Please note, there's no need to emphasize any particular sections from either song. The focus here is on the seamless transition. Beautiful and harmonious connection is the key. Let's...

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

Copy Paste Instagram Outreach text and get paid 5$ per booked meeting and 50$ per closed clients. No skill needed just a laptop and an Internet connection, We will teach you everything. PS: Our most recent hire made 350$ this week

I am looking f...a social networking application geared towards professionals. Key Features: - User Registration and Profile Creation - Messaging System - Networking and Connection Building Features - News Feed for Professional Updates - Job Listing and Recruitment Section - In-App Search and Filter Functions - Notification System - Integration with Existing Social Media Platforms Skills and Experience: - Proficient in mobile app development - Previous experience in creating social networking applications - Strong understanding of user experience and design principles - Ability to integrate various APIs - Familiarity with data security and privacy standards This is a unique project and I am looking for a freelancer who can bring creativity and innovat...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, bu...

Hello, I need complet the Amazon categories catalogue excel in french

I'm seeking a WHMCS module that facilitates direct connection between my .in domain registry and WHMCS. It's built on the Neustar toolkit for registrars. For reference, I've included a link to an existing module developed by another party: I'm looking for a similar module without licensing restrictions and at a more affordable rate than the one listed.

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

...website demos. - Maintain accurate records of appointments scheduled. - Requirements: - Excellent communication skills, both verbal and written. - Comfortable making outbound calls and engaging with potential clients. - Ability to effectively follow a provided script while adapting to conversation flow. - Experience in appointment setting or sales is a plus but not required. - Reliable internet connection and access to a quiet workspace. - Compensation: - Base pay $2 - $5 based on experience - $50 compensation for each successfully scheduled appointment that results in a closed deal. - Payment will be made upon successful completion of the scheduled Zoom call and subsequent deal closure. Additional Information: - Training on the dialer, script, and lead list will be provided...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...professional to connect my Unicorn 5.31 to an Akta machine and ensure it's functioning properly. Additionally, Fermworks needs to be activated and integrated to work with Labview to run a bioreactor. Key responsibilities: - Connect Unicorn 5.31 to Akta machine - Verify that the connection is functioning correctly - Ensure the automation process is smooth and operational - Provide any necessary troubleshooting or support post-implementation -Ensure Fermworks and Labview are activated properly and the connection is functioning correctly with the bioreactor. -No additional purchases of software. - Familiarity with VMware as a couple programs are located on these virtual machines. Ideal proposals should include: - Experience in connecting different machines - Proven ...

...seeking a skilled C# programmer proficient in socket programming to assist with a specific task relating to establishing server connections, sending/receiving data packets, and handling socket errors. Additionally, I need help in creating a small WooCommerce database interface. The specific requirements: - Socket Programming: You will be responsible for establishing a server connection, sending and receiving data packets, and managing socket errors. - WooCommerce Database Interface: We will be integrating a small interface to manage product inventory. In this case, we are looking for basic integration - primarily focused on reading product data. The ideal candidate should have: - Proven experience in C# programming, particularly with a strong understandin...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm looking for an artist who can create a biomechanical logo for my band, "Endjin". The look I'm aiming for is dark and intense to create a strong connection with our audience. Key elements include: - A modern style that stands out, with a hint of edginess. - The colour scheme should involve metallic silver and black. It's important that the silver is shiny and vibrant to draw the audience's eye. - Ideally, you'll have experience designing for bands or other music-related industries, but this isn't a deal breaker. What's important is your ability to create a unique, eye-catching design that matches the intensity of our music. Skills required: Logo Design, Photoshop, Illustrator, Graphic Design. Your portfolio should demonstrate your kn...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. P...

... WebSocket Connection: - Establish a connection to a specified WebSocket server. - Maintain the connection and handle reconnections as necessary. 2. Receive Notifications: - Listen for incoming messages/notifications from the WebSocket server. - Process the incoming messages and trigger a push notification on the device. 3. Push Notifications: - Display push notifications on the device when a message is received via WebSocket. - Ensure that notifications appear even if the app is closed or running in the background. - Handle user interaction with the push notification (click/tap). 4. Notification Handling: - When the user clicks on a push notification, the app should be launched (if not already running) or brought to the foreground. - P...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accu...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

I am looking for a professional with experience in AWS API Gateway, Python, and possibly other related technologies to troubleshoot and fix a persistent connection issue I'm facing. Requirements include: - In-depth knowledge of AWS API Gateway, for REST API specifically - Solid experience with Python, as my backend system is built using this language The issue I'm having involves regular 'connection refused' errors when trying to fetch data from the API. This has been an ongoing issue, and I need an expert who can identify the root cause and implement a solution to ensure reliable, uninterrupted connectivity. It would be beneficial if you have experience in troubleshooting and resolving similar API Gateway issues in the past. A proactive approa...