As400 vba open excel jobs

...service portfolio for Bongo Water. This project is open-ended and can include product design, website creation, and marketing campaigns. Key areas of focus: - Product Design: Creative and functional design to set our product apart. - Website Creation: User-friendly, informative and engaging sites that reflect our brand. - Marketing Campaign: Innovative strategies to boost our brand visibility, engage customers and drive sales. Ideal skills for this project: - Strong background in product design - Proven experience in website creation - Expertise in developing and implementing successful marketing campaigns - Creativity and ability to think outside the box - Excellent communication skills - Ability to work collaboratively and take feedback I am open to suggestions and w...

Generate Leads of driving Schools in USA Deliver in Excel Sheet

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

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

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

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

...my channel. Creativity: Developing engaging and attention-grabbing content to promote the channel (e.g., posts, short descriptions, hashtags). Targeting: Focusing on audiences interested in my channel’s content (post-apocalyptic movies, zombies, survival, horror, and film-related topics). What I Offer: A long-term collaboration if the results meet expectations. Compensation to be discussed – I’m open to specific budget proposals. What I Am NOT Looking For: SEO, thumbnails, or technical optimization. I’m only interested in promotion and audience outreach. About the Channel: My YouTube channel focuses on film rankings and reviews, particularly on post-apocalyptic, zombie, survival, horror movies, and the latest film releases. If you have experience in suc...

I'm seeking a proficient web developer to create a sleek, professional corporate website for my IT company. Key Requirements: - The site should encompass key pages such as About Us, Services, and Contact Us. - The design should be modern, intuitive, and user-friendly, appealing to potential clients and partners in the tech industry. There's flexibility in design as I'm open to suggestions. Ideally, you'd have a strong portfolio showcasing your ability to blend creativity with functionality. I look forward to your proposals.

...along with timestamps. 4. Excel/CSV Export • Download grid-based data as Excel or CSV files. 5. Compressed File Processing • Automatically extract files when compressed files are uploaded to the server. 6. Selective Export • Export visible data on the grid as Excel or CSV. • Options to export only selected data. Automated Process Workflow 1. Data Upload and Email Attachment Saving • Store data through email attachments and file uploads. 2. Analysis and Data Extraction of Saved Files • Automatically analyze saved files using OCR and GPT. 3. HomeTax/WiTax Filing • Automate the filing process using browser automation. 4. Dispatch of Filing Results • Automatically send PDF filing results to customer email and KakaoTalk messages...

...Responsibilities: Upload new products to the seller account. Create replenishment shipments as needed. Analyze return reasons and determine necessary actions to prevent future returns. Dispute returns with Takealot if they are a result of a Takealot error. Compare shipment sent items with purchase invoices to ensure accuracy. Requirements: Basic proficiency in English and Urdu is mandatory. Familiarity with Excel is important. Previous experience with e-commerce platforms such as , Amazon, or similar is a plus but not required. A willingness to find and watch instructional YouTube videos to enhance learning about e-commerce practices. Additional Notes: You will be granted access to my PC via TeamViewer to explore the seller portal and learn. We are looking for individuals wh...

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

Job Description: I am planning to host a Lichess.org-like website targeting an Indian audience. I am looking for a DevOps and VPS expert who can handle the end-to-...built on Scala). Good understanding of databases & caching (Lila Chess uses Redis and MySQL). Familiarity with architecture is a plus. Deliverables: Fully functional CI/CD pipeline in Azure DevOps. Configured VPS with the required environment. Deployed & running Lila Chess instance. Performance-tested & optimized deployment. Step-by-step documentation for future maintenance. ? Budget: Open for discussion based on experience. ⏳ Timeline: ASAP – Preferably within a few weeks. If you have experience in DevOps, Azure, Docker, VPS management, and CI/CD, please apply with your relevant experience and previ...

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

...edit/update content. Guidance on maintaining the site post-handover. Scope: Homepage and up to [insert number] additional pages (e.g., About Us, Services, Contact). Integration of basic features such as a contact form, social media links, and Google Maps. Optional: E-commerce capabilities (quote this separately if relevant). Support: Provide an initial set of templates or content placeholders. Be open to up to three rounds of revisions during the design process to ensure it meets our expectations. Colors and Branding: Use our company colors: Green (#009639) and Red (#FF0000). Incorporate our logo (to be provided). What We’re Looking For: A professional, modern design that reflects our brand. Easy-to-manage backend with detailed handover documentation. Timely delivery and...

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

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

We are seeking a skilled developer to create an engaging gambling website themed around Counter-Strike. The site will feature the following components: Features: House Games: Case Opening and Case Battles: Players can open cases and compete in case battles to win prizes. Horizontal Roulette: A roulette game similar to case opening, using colors (Red, Black, Green) instead of numbers. Upgrader: Players choose to multiply their balance by a selected multiplier, adding excitement and risk. Esports and Sports Betting: A dedicated section for betting on sports and esports, with a strong emphasis on Counter-Strike matches and tournaments. Crypto Integration: The platform will support cryptocurrency payments, ensuring fast, secure, and decentralized transactions. Experienc...

Troubleshoot open vpn and upgrade alamlinux kernel to stable version 5

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

...dashboards. Integrates state management to synchronize app restrictions with the backend. Error handling with contextual guides for user assistance. Integration: Communication between the Swift backend and React Native frontend is established via a bridging module (AppBlockerBridge). State synchronization ensures real-time updates between the two environments. Primary User Journeys: Personal Users: Open the app and select apps to restrict. Set a restriction duration or use NFC to unlock apps on demand. Review restriction history and adjust app selections. Business Users: Access the dashboard to view analytics and employee profiles. Add or remove employees and enforce restrictions on company-provided devices. Monitor app usage trends and generate productivity insights. Goals: I...

A web-based Customer Record Lookup tool our staff to use, could be built on a CRM platform, but is very simple. The application consists of two main interfaces: Admin Interface: - User management functionality (add/edit/delete users) - CSV file upload for customer reco...on readability - Color-coded search results for quick identification - Design with optimized layouts for desktop / laptop use Files Provided 'Customer ' - This is the export from our ERP. - File will be uploaded to the app you develop weekly by our staff. - New data will replace old data (removing any data not overwritten by new file). 'THCSD Customer Account ' - This is an excel based solution that we created internally. - Use this as a reference for front-end Column Names and Data View of e...

i have the excel file you need to analyse the data and I want to you create advanced PowerPoint presentation presentation it need to be present to the big forums, primarily aimed to the top management. The presentation should reflect a professional and corporate style, with clear, concise content and well-structured slides. Ideal Skills and Experience: - Proficiency in PowerPoint - Experience in designing corporate presentations - Excellent understanding of corporate language and presentation etiquette - Ability to condense complex information into clear, digestible content - Creative approach to maintaining viewer engagement within a professional context.

I'm looking for a seasoned developer to create an MLM Binary System for both web and mobile platforms. The system should include features for: - Commission Calculation: The system should be able to accurately calculate commissions based on the MLM binary structure. - Genealogy Tree: A visual representation of the net...the structure. Ideal candidates should have extensive experience in MLM software development and be proficient in both web and mobile development. Knowledge of user-friendly UI/UX design principles would be beneficial, as the system should be intuitive and easy to navigate for all users. Please note, I have not specified a preferred programming language or framework for this project, so I am open to suggestions based on what you believe would be most suitable...

...press environment, I offer the following services: - Typing and document formatting using Microsoft Word - Data organization and spreadsheet creation in Microsoft Excel - Desktop publishing with Adobe PageMaker - Image editing and design with Adobe Photoshop I am dedicated, detail-oriented, and committed to delivering high-quality work that meets your specific needs. Ideal projects would involve typing, document creation and formatting, spreadsheet management, desktop publishing, or image editing. Skills and Experience: - Fluent in English with excellent typing speed (40 WPM) - Profound knowledge of Microsoft Office Suite (Word, Excel) - Proficient with Adobe PageMaker and Photoshop - A proven track record of 10 years in computer work related to printing press operation...

The project involves creating a mobile application for both Android and iOS platforms. The primary function of this app is to enable users to capture multiple photos in a single session, tag them with product SKU and quantity, and subsequently export this data into Excel and PDF formats. The app should also support date-wise search functionality to track the captured data over time. Key features include: - A user-friendly interface for capturing and tagging photos - Seamless integration with Excel and PDF for data export - Date-wise search capability Ideal candidates for this project should have: - Previous experience in mobile application development, particularly for Android and iOS - A strong understanding of data export functionalities - Excellent UI/UX design skills...

I need a master Excel spreadsheet designed and populated with data from financial documents I will provide. This will include a master page produced from all the data on the separate tabs. - Data Types: The project primarily involves working with financial data, specifically tracking revenue and expenses. - Update Frequency: The data will need to be updated monthly. Ideal skills for this job include advanced Excel proficiency, experience with financial data, and the ability to create clear and comprehensive master spreadsheets. Please provide examples of similar projects you've completed in the past. Each sheet will total and feed into the master page. I would like reports ideally that can be run on total expenses or revenue in a time period as well as ratios to be ...

I'm seeking an expert excel/vba programmer. I'm using an existing vba macro excel program that needs to be upgraded. It was created to automate the process of building a single inventory list from multiple vendors feeds. The website is now using the Shopify platform and requires data to be imported into different column names and for more columns added. Summary of work required: 1. Need to change the import process to a single form, where feed can be added, vendor profile selected, map file column names to names in the program, save profile and import feed. 2. Adjust Export functionality to use similar template with different columns for different export options. 3. Data in compiled list needs to be read only unless enabled for in-line editing ...

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

I'm looking to create a Store Finder App. The specifics of the project are quite flexible, and I'm open to suggestions. However, the ideal candidate should have a proven track record in developing location-based apps, preferably with a focus on store navigation. Key points to consider: - The type of stores the app should locate is currently undecided. However, it would be beneficial to have options for various types of stores such as grocery, clothing, and electronics. - The platform for the app hasn't been finalized yet. A cross-platform app that works on both iOS and Android would be ideal. - As for features, while the app should definitely include basic navigation, the inclusion of user reviews, ratings, and store contact information would greatly enhance the app...

Budget $25 I'm looking for a Python expert who can write a script for me. The script will open a list of URLs from an Excel spreadsheet and check for specific content. Requirements: - The script needs to check for text on the URLs. - If the content exists, it should create a new column in the spreadsheet with the status of each URL. Skills required: - Proficiency in Python programming. - Experience with working on Excel files. - Knowledge in web scraping techniques. - Ability to understand and implement URL content checking. Please only apply if you can demonstrate your ability to complete this task successfully -

I'm seeking assistance in extracting numerical data from individual stock pages on a website and storing it in an Excel file in a specific format for multiple stocks. This needs to be done monthly. - Data Points: The data points to be extracted include various metrics like annual sales, operating profit margin (OPM), net profit, and others. - Excel Formatting: The extracted data needs to be stored in a particular format in Excel. Ideal Skills: - Proficiency in Excel - Experience with web data extraction - Attention to detail to ensure data is accurately captured and formatted. Please note, I need this to be set up for monthly updates.

I'm looking to establish a solar energy panel company in Romania, focused on a 1 hectare plot capable of generating 1 MW of energy. I need expert guidance on the technical specifications and installation processes, as well as assistance with market ana...identify potential customers and competitors - Development of a pricing strategy - Creation of revenue projections and financial models Ideal skills and experience: - Extensive knowledge and experience in solar energy systems - Strong background in business planning and financial modelling - Proven experience in market analysis - Preferably based in or has deep knowledge of the Romanian market I'm open to suggestions on potential buyers for the generated energy. Your expertise in this area will be beneficial for the succ...

Python Developer: Screenshot Cropping & OCR to Excel Description: Seeking a Python developer to automate data extraction from screenshots with two key tasks: Screenshot Cropping: Crop images to isolate data below column headers. Handle minor variations across screenshots. OCR & Excel Conversion: Use OCR (e.g., Tesseract) to extract text from cropped areas. Save data to Excel in structured columns. Requirements: Proficient in Python (Pillow, OpenCV, pytesseract). Experience with OCR and Excel handling (openpyxl, pandas). Strong problem-solving skills and attention to detail. Deliverables: Scripts for cropping and OCR-to-Excel conversion, reusable and future-proof. Notes: Focused on screenshots only—no web scraping (e.g., Selenium). Prov...

...creative designer to craft a unique, artistic and abstract wine label for a Bordeaux bottle. The label size will be 90mm x 120mm. Key Elements: - The design should incorporate graphited scuffing and scribbles on an old-looking parchment paper. This will give the label a vintage feel, reminiscent of the timeless elegance of Bordeaux wines. - As the chosen style is 'Artistic and Abstract', I'm open to creative interpretations and innovative design elements that can enhance the overall aesthetic of the label. Color Scheme: - The color palette should consist of muted earth tones. These colors will not only reflect the natural beauty of the vineyard but also complement the old parchment paper theme. Ideal Skills & Experience: - Proven experience in crea...

I need a comprehensive, user-friendly sales report spreadsheet designed for monthly data tracking. Key Data: - Revenue: The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Re...The primary focus of the report - Sales Rep Tracking: This includes new business, contract renewals, and lost business Required Functionalities: - Automated Calculations: To reduce manual input and errors - Data Visualization: Charts and graphs to provide visual insights into the data - Summary Sheet: A separate sheet that auto-populates with a summary of all data Ideal Skills: - Proficiency in Excel or Google Sheets - Experience with sales reporting - Skills in data visualization and analytics I plan to update this spreadsheet on a mont...

I'm in need of an Administration Assistant with excellent document formatting skills. The primary task will be formatting policy documents to ensure they are consistent, aligned, and visually appealing. Key Requirements: - Proven experience with Microsoft Word and Excel. - Ability to work quickly without sacrificing quality. - Previous experience formatting policy documents is a plus. - Must provide government-issued photo ID and sign a Non-Disclosure Agreement (NDA). - Long-term work opportunity available for the right candidate. - No pay for work that is of poor quality Important Aspects of Formatting: - Consistent font styles and sizes - Use of headers and footers - Optimal spacing and alignment - Creation of 'beautiful' documents Aesthetic Elements Considered ...

...to the Shopify platform. The site primarily sells engineered products, so experience with e-commerce and this type of product is a plus. Key tasks: - Site Migration: Transfer existing site content to Shopify. - Theme Recommendation: Provide advice on the best Shopify theme for the site, considering both functionality and design. - Redesign: Implement a full redesign of the site on Shopify. I'm open to creative, user-friendly solutions. - Feature Implementation: Integrate essential features into the new site, particularly live chat support. Ideal skills and experience: - Extensive knowledge of Shopify platform - E-commerce website design and migration experience - Ability to recommend and implement quality themes - Experience with integrating customer support features, par...

...conjunction with the door lock, the user has to unlock the door first to close the lid. (2. technology search) The technology I am looking for is a control mechanism for the charging port lid lock in electric vehicles. The specific requirements for this technology are as follows: ①When the lid is closed: 　　→The lid locks in conjunction with the vehicle's door lock. ②When the lid is open: 　　→The lid remains open until external charging starts, even if the vehicle's door is locked. Once external charging begins, the lid locks, and it unlocks again when the external charging is complete. Please search for this technology. <<NOTICE>> The target car brands in this search are limited to US, European, Chinese, and South Korean brands. <Req...

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

...tools such as SmartScout and Keepa (training provided if needed). Enter brand and product data into a basic spreadsheet with accuracy and consistency. Follow clear guidelines to meet weekly and monthly sourcing targets. Requirements: Familiarity with SmartScout and Keepa is a plus but not required; training will be provided. Strong attention to detail and accuracy in data entry. Basic knowledge of Excel or Google Sheets. Ability to work independently and meet deadlines. A positive attitude and willingness to learn new skills. What We Offer: Flexible working hours. Competitive pay structure. Weekly and monthly performance bonuses for meeting targets. Hands-on training and support to ensure your success. A straightforward workflow with no direct communication with suppliers or br...

1. Please fix the Stock Performance tab with Top 20 & Bottom 20. 2. Commodities & Chart_All_Commodities, I changed the commodity on a few of them including Antimony, Germanium, Gallium, Platinum & Niobium. This seems to work on the Commodities tab, but I have to manually update the Chart_All_Commodites Tab + others mentioned in Skype too, thanks

I'm looking for an expert who can transform my Excel sheet into a web-based calculator. The calculator needs to handle basic arithmetic operations like addition, subtraction, multiplication, and division. Key Features: - Data Input Options: The calculator should incorporate user-friendly data input options such as dropdowns and checkboxes. - Graphical Representation: A vital part of the project is the ability to visually represent results graphically. Ideal Skills: - Proficient in Excel and web development - Experience creating interactive web-based calculators - Ability to integrate graphical representations into a web platform Please provide examples of similar projects you have completed.

I need a Windows compatible screen recording software that captures video with audio and saves it as an mp4. Key Features: - The software should record audio along with the screen video. - The primary use of these recordings is for troubleshooting or support, so reliability and clarity are key. - Free and open source software Ideal Skills: - Proficient in Windows software development. - Experienced in creating multimedia applications. - Understands the requirements for support-focused video clarity.

...need a professional to identify and correct any errors. Scope of Work: Review the entire Excel model for accuracy and logic in calculations. Verify key outputs (e.g., working capital changes, depreciation, FCF, OFCF and amortization schedules). Identify and fix formula errors, inconsistencies, or logical flaws. Provide a brief explanation of any changes made to help me understand the corrections. Expected Time Commitment: The work should take no more than 2-3 hours to complete for an experienced professional. Deadline: I need the edited version delivered within 6 hours of awarding the project. Please only bid if you can meet this deadline. Requirements: Expertise in financial modeling and Excel. Attention to detail and the ability to explain corrections clearly. Stron...

Hello, There is a website that has specific listings (around 1900) I need it extracted manually and then input in an Excel sheet (Number > price) I need the work to be finished in the next 2-3 hours max If you can start and finish it within the above time, type RED at the beginning of your proposal. A proposal without it will be ignored.

I'm seeking help with my introductory statistics homework, specifically focusing on data analysis and interpretation. The assignment has to have shown work in a word doc and excel sheet. I can show examples of this. Key Requirements: - Proficient in handling mixed data (both quantitative and qualitative) - Skilled in data analysis and interpretation - Strong understanding of introductory statistics principles Ideal Freelancers: - Have a solid background in statistics, particularly at the introductory level. - Experienced in analyzing mixed data sets. - Can provide clear explanations and guidance on data analysis techniques.

I'm seeking an expert to automate the process of extracting both text data and tabular data from a variety of PDF files into separate sheets in Excel corresponding to each PDF. The PDFs are inconsistent in their structure and layout, which adds a layer of complexity to the task. Key Requirements: - Can use excel, Adobe, Python Please provide examples of previous similar projects you have successfully completed.

Please Sign Up or Login to see details.

I need to have files like the one labeled Spikes converted to Sp...column is the condition. My brute force idea is to do a loop counting spikes until the next 10 s limit is reached, then zero the count and start counting again. Be sure if two spikes are separated by more than 10 s that you save a 0 in each row without a spike. I forgot to mention that the two columns of data in Excel (Condition and Time) were originally in another spreadsheet (ClampFit Events) and I copied and pasted them into Excel. So you don’t have to read them from and Excel file. Instead you can just copy and paste them into a MatLab data array and then write code in MatLab to detect how many spikes/events occur for every 10 s (10000 ms). It would be best if you then save the final resul...