Import as400 table using excel macro iseries driver jobs

I will design your logo using your name initial FA

I require a proficient expert who can develop an advanced spreadsheet that will import and sort data with specific criteria. The spreadsheet should not only help with the data organization but should also present it visually in the form of sales graphs. The types of data it will handle are: - Customer information - Product information - Sales data - End user usage by the product, shipped through 12 distribution centers As part of the functionality, this data should be sorted by: - Customer - Product information - Sales data - Quantity sold - Region - Weekly sales Ideal skills for this project would be in-depth knowledge of Excel formulas, pivot tables, and chart generation in Excel. Previous experience in developing advanced spreadsheets for data analysis will be ...

I need to correct the import logic in fire base my app is already importing all fire base databases, I just need to be able to modify it at run time and reload the new information whenever I click on each image

I have Endpoint that returns the images in wwwroot based on the names of the images in a table in the database, but it returns only one image and not all the images. I want someone to modify the code to return all the images.

I have a macro that has been put on my desktop from another computer and I need to get it uploaded to word

- DOKUMENT DOWNLOAD: Insert link to dokument for download. Dokument already generated - INVOICE PAGES: edit invoice pages in admin panel; add filters by user, month, invoice status, invoice number. Delete and download invoices. Downloa...view/delete/change invoices - ARTIST REGISTRATION: add page for selecting 4 tariffs; tariff blocks enabled/disabled/adjusted from admin; generate pdf invoices for selected tariff; calculate invoice amount based on selection date; save invoices in admin and user pages; send email to admin and user with invoice; generate Excel/XML files for registrations; generate files 5 days before month-end; no files if no registrations on a day - BANK DATA FILES: on 1 st of each month; generate excel and xml files; with bank data and amount to pay; one f...

Seeking a Professional Freelancer for Data Import on Thailand Directory & Listing Website Hello, I'm the owner of a Directory & Listing Website focused on Thailand. I'm looking to import as many businesses as possible onto the website. For this purpose, I need someone to collect data from Yellow Pages and import it into my website along with information and images. I would like to know from you how many entries you can find and bundle them in a way that they can be professionally imported via a CSV or XML file. After the import, the website should maintain its performance and ensure that images are web-optimized. The website caters to tourists looking for unique experiences in Thailand's hotspots. There are 12 locations frequently visit...

Hi, we have an large Excel file with all of our customers contact details. We group them with tags in several different types - like pharmacy client, personal friends, partners and such kind things. I already wrote an py script wich processes this main excel file and splits the persons in their several categories each one with an own excel file. What i want now is that when someone from our company is writing to an defined mail account wich is an gmail account an message like. Hey Bot, give me please the excel list with friends, the py script should catch the keywords friends and should send the sender back an mail with the excel file wich contains just the friends back to him. last year i already wrote similar thing for an different purpose, this can be...

I am urgently seeking a skilled program developer proficient in creating small programs for managing financial information. The software must print student fee receipts categorized under multiple heads (Tuition fees, Library fees, Transportation fees, Admission fees, Hostel fees, Internship fees, additional fees, Dress fees) directly into Excel. The aim is to simplify our receipt administration process, remove human errors, and save the team's time. Desired skills include: expertise in programming, financial data management experience, and the ability to deliver results quickly.

...screens and all mobiles. • It shall be private (Not accepting new users, only invited ones); limited to invited users. • It must be live linked with other website for live results like api. Components: Index Page: • Header: Info of the logged in users (name, photo …etc) • Main Menu • Body: All matches to predict on (time open/close predictions for each match) Prediction Table Page: • Table show users ranking based on points (will be discussed later) Additional Requirements: • Option to double points for specific matches and users • It is recombed to have normal design (normal colors and related football photo) • No Problem to have English copy, I can edit all words to be Arabia in order to make it easy for the develope...

...of Staff. You will be responsible for handling various administrative tasks, managing schedules, coordinating meetings, and ensuring smooth communication within the team. The ideal candidate should have excellent organizational and multitasking skills, as well as strong attention to detail. Responsibilities include assembling (search and hire) a virtual operations team, organizing company data (excel) and daily file submissions, and overseeing all operations (includes recruitment, HR, scheduling, and live employee updates.) Because this is an important management position, the Chief of Staff will be operating from 8:00AM to 10:00PM EST, Monday to Sunday. Our founders have had previous experiences with different VAs and have come across many challenges thus, we would like to ...

I am in need of assistance to swiftly achieve a task on Power Automate. The task requires expertise in extracting Excel sheets from an email and further extracting data from these sheets through using Power Automate. Thus, an ideal candidate will bear advanced skills and proven experience in Power Automate and Excel data extraction. The success of this project relies on timely completion, therefore priority will be given to applicants who can work efficiently under time constraints. It is a tiny task, and I want you to guide me through the task online (live share screen)

I require a specialist to merge data containing both references and numbers from multiple cells. The key responsibilities will be: - Merging...both references and numbers from multiple cells. The key responsibilities will be: - Merging the cell data, ensuring all relevant references are kept intact and combined into the respective cells. - Arranging the combined data into a reference table, with the option for the data to either be combined into one cell entirely or split across multiple cells as needed. The ideal freelancer for this project should have an extensive understanding of data management, particularly with merging data in cells while maintaining references. Proficiency in Excel is a must. This task requires a high degree of precision; therefore, attention to det...

I'm looking for a skilled JavaScript developer to create a function that can replace an existing Excel macro using Goalseek to calculate equipment rental fees. - Objective: The main goal of this task is to automate the calculation of the monthly rental fee for equipment. The JavaScript function you develop should be able to replace the existing Excel macro that uses Goalseek. - Data Handling: The function should be designed to receive input data manually from the user. This means that the function should be able to take in data directly from the user, process it, and return the calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements su...

I'm seeking a skillful PowerPoint designer to create a creative PowerPoint template for c...Proficiency in creating aesthetically pleasing and readable infographics. Your output will be a versatile template that we can use to represent our company and ideas in an engaging, creative, yet professional manner. I want this to be info graph and photo heavy (creative vs lots of words) This template will be used for different decks. Please include our colours. Slide examples would be Title Slide Table of Contents Company Overview Services Case Studies Recap Clients Thank you This will be delivered via pdf. Logos and colours and fonts will be advised upon hire. Please send links of past jobs and timeframe for completion. Looking for something I can easy change and adjust myself...

- DOKUMENT DOWNLOAD: Insert link to dokument for download. Dokument already generated - INVOICE PAGES: edit invoice pages in admin panel; add filters by user, month, invoice status, invoice number. Delete and download invoices. Dow...view/delete/change invoices - ARTIST REGISTRATION: add page for selecting 4 tariffs; tariff blocks enabled/disabled/adjusted from admin; generate pdf invoices for selected tariff; calculate invoice amount based on selection date; save invoices in admin and user pages; send email to admin and user with invoice; generate Excel/XML files for registrations; generate files 5 days before month-end; no files if no registrations on a day - BANK DATA FILES: on 1 st of each month; generate excel and xml files; with bank data and amount to pay; one f...

I'm in need of a skilled freelancer with a strong background in MS Excel for tasks related to data entry and organization, along with formulas and calculations. Tasks: - Input and organize Excel data which includes text, numbers, and dates/time. - Create and utilize formulas and calculations to streamline data analysis. Output Presentation: - Create clear tables and charts for data visualization. - Compile comprehensive reports and summaries from processed data. The ideal candidate should have a solid understanding of data management techniques and advanced excel formulas. Proven expertise in Excel data analysis will be a great advantage.

...moving out of the platform and wish to retain historical call recordings. Goal is to be able to quickly search and narrow down a result if we get a request for a old call recording. If all the XML data is inside a SQL database than we can write queries to narrow our results and ideally path to the exact MP3 file to play. *** I require a specialist to design, build and implement a system to batch import XML data containing specific call recording metadata into a SQL database. The required data points are: - Caller ID - Call duration - Call start time - Internal employee on call Specialists should possess expert knowledge and experience in handling XML and SQL databases, with an ability to read and interpret XML data structure and write necessary SQL queries/scripts. In add...

I'm in need of a custom solution that will allow me to allocate product codes based on an individual's Date of Birth (DOB). Specifically, here are the key functionalities I'm expecting: - Using date range 'born on or after 1 Aug 2012', the spreadsheet will allocate the product code 'Junior (U12)'. - The solution should also consider instances where the DOB doesn't fall within any particular date range, stamping such instances as 'Date Range Check'. - Besides the 'Junior (U12)' product code, I want the solution to accommodate the allocation of other product codes based on different date ranges. These include: - 'Secondary School (12-16)' Born before 1 Aug 2012 but on or after 1 Aug 2008 - 'Youth ...

...currently using Excel for creating my retail quotation templates. I am looking for a professional who is adept at: 1. Custom Field Incorporation: Please be able to add or remove fields within my current retail quotation template to customize it according to my business needs. 2. Design and Layout Alteration: I want to improve the design and layout of my retail quotation templates. I estimate this to be a significant portion of the project. A strong sense of aesthetics and understanding of UI/UX principles will be beneficial. 3. Branding and Color Scheme Consistency: Please ensure our company's existing color scheme and branding are incorporated seamlessly into the redesigned template. Strong attention to detail will be highly appreciated. Proven experien...

I'm in need of a highly professional JavaScript and CSS expert to design and implement a data table with a broad range of functionalities. These include: - Sorting - Filtering - Pagination - Column resizing - Grouping - Column rearranging - Column hiding/showing Moreover, the table must also include extra features like dynamic totals calculation in the footer. Additionally, the data table should support dynamic cell data visualization. This feature should cover color coding, icon representation, and progress bars depending on the data type, which is to be detected when the data is assigned to the table element along with all the columns and their names. If the columns are resized, reordered, hidden or shown during runtime, these view details should be...

...efficiently under tight deadlines - Strong communication skills and ability to collaborate effectively with team members **Bonus Skills:** - Knowledge of social media platforms and trends - Motion graphics and animation skills - Experience with other creative tools such as Adobe Photoshop or Illustrator **How to Apply:** If you are passionate about video editing and have the skills and experience to excel in this role, we'd love to hear from you! Please submit your resume, portfolio, and a brief cover letter highlighting your relevant experience and why you're the perfect fit for our team. **About Us:** One Stop is a leading short and long form content agency dedicated to creating compelling and impactful video content for brands and businesses. With a focus on creat...

Hi, we have an large Excel file with all of our customers contact details. We group them with tags in several different types - like pharmacy client, personal friends, partners and such kind things. I already wrote an py script wich processes this main excel file and splits the persons in their several categories each one with an own excel file. What i want now is that when someone from our company is writing to an defined mail account wich is an gmail account an message like. Hey Bot, give me please the excel list with friends, the py script should catch the keywords friends and should send the sender back an mail with the excel file wich contains just the friends back to him. last year i already wrote similar thing for an different purpose, this can be...

I need to implement a simple, easy-to-use...the correct column headers in A, B and C. If the spreadsheet fails this validation, it should provide an error message with guidance on how to correct the issue. - Accessibility: The portal should be accessible to anyone, without the need for user accounts. Ideal Skills: - Proficiency in web development with experience in building portals and handling file uploads. - Strong understanding of Excel file structures and the ability to programmatically validate column headers. - Knowledge of front-end development to create a user-friendly experience. - Attention to detail to ensure that the error messages are clear and helpful for the users. Please provide a brief description of your relevant experience and how you would approach thi...

لدي نادي متخصص في لعبة الإسكواش وأحتاج عمل قالب اكسل لحساب مدد بدايات ونهاية الاشتراكات وعدد ساعات التدريب

My project is about creating a compelling and successful Instagram fundraiser. The campaign is designed to raise money for a specific family in need. The idea is to collaborate with Instagram celebrities who can help convey the personal stories and testimonies of this family to a wide audience. - The ideal candidate: Someone with a strong background in social media marketing, especially on Instagram, and with experience handling fundraising or charity campaigns. Knowledge in storytelling and content creation will be exceptional. He has relationships with Instagram celebrities, or is able to reach them or contact them, with the aim of pushing them to publish advertisements about the donation campaign, especially through the “Story” feature.

Project Description: We are looking for an experienced Wordpress developer to create a high-quality course details page for our Excel Mastery course at Metaverse Learn. The course details page should be designed to match the example provided here: Here is our current course details page : Requirements: - The course details page should be visually appealing, user-friendly, and mobile-responsive. - It should include all necessary elements such as course overview, curriculum, instructor details, testimonials, FAQs, and enrollment options etc. Basically all the elements on our existing course details page. - The page layout should be customizable and designed as a template so that it can be replicated

...horizontal and vertical. As the size changes, the price will increase. The original photo must reach us. Min. We should be able to get up to 25 megabytes, max. It could be 50mb. We also have the split canvas (multiple canvas painting) option. If the split canvas distracts you too much, we can add it after the site is finished. In addition, for the sale of archive images, a structure like the "Table Categories" on is needed. THIS will be a ready-made product sale, a simple add to cart structure will be sufficient. 2. Structure My second target product will be poster printing. We will use the following structure here. The main idea is that the customer can enter the size he wants and the price will increase as the size increases

Metaverse Learn is seeking an experienced and creative designer to craft a high-quality, trendy image ad for our Excel Mastery course. This ad will be posted on Instagram, Facebook, and LinkedIn to attract aspiring Excel wizards! Project Details: - Design an eye-catching image ad for our Excel Mastery course. - Must be suitable for Instagram, Facebook, and LinkedIn platforms. - Incorporate the Metaverse Learn logo and course details. - Ensure the ad reflects the professionalism and quality of our brand. - Trendy and modern design style preferred. - Final open file/project files (Photoshop file) must be provided upon completion. Requirements: - Experience in designing social media ads, preferably for educational or online courses. - Proficiency in graphic design too...

I need a reliable system that automates a process, doing a couple of specific tasks: 1. Reading specific data captured in Excel files. 2. Automatically sending texts via SMS when there's a data match in a particular column of the Excel file. This task will require programming skills, particularly with Excel and automation tools API. Experience with SMS gateway integration is a huge plus. You will be required to advise on appropriate SMS gateways if you have prior experience. The matching data column in the Excel file should be the trigger initiating the text sending automation. The target of this automation is to streamline and expedite our communication process, reducing manual effort involved in sending periodic SMS updates. If you have past experie...

I need a proficient Excel specialist to provide immediate support with data analysis, automation, and formula creation. Your expertise is essential in transforming a specific data format from '111111111111' to '' in Excel. I just need for someone to show me how to do it so I can replace it in my Excel database

WHAT’S NEEDED: Uccello Designs is looking for a freelancer to input data from the provided PDF’s into the provided Microsoft Excel sheet. WHAT’S PROVIDED: We have designed the sheet to include all relevant headings that are important to the data entry project. Within each PDF are multiple files that need extracted and added to the sheet. ABOUT THE PROJECT: These documents cover our customers registering the products they have purchased. The 3 products are the Uccello Kettle, Muggi and Uccello Grip Mat. With the excel doc there are 2 tabs, one is solely for the Uccello Kettle and the second is called the accessory registration tab where we ask that you include the Muggi and Grip Mat. NON-DISCLOSURE AGREEMENT: The information that you are being provided is ...

Require a form that submits the form data in a mySQL database table. Once the form is completed and submitted it should email the user a PDF certificate that includes all the information submitted in the form. The certificate should also display the end of warranty date which is one year from the purchased date entered in the form. If possible the emailed pdf should have a QR code that contains all the information submitted in the form.

I'm seeking an experienced developer who can help me to summarize Master Services Agreements and SOWs using ChatGPT or Copilot. While I don't have a library or API preference, I expect the summarization to be a high-level summary, capturing the most important intentions and obligations in these documents. I should be able to re-run and add new contracts at any point without having to re-run everything. I am looking for the end result to be a matrix of contracts down the left and key legal agreements along the top with the answers for each contract populated inside the table. Ideal Skills: - Proficiency in Python - Extensive experience with Natural Language Processing - Familiarity with text summarization techniques - Prior experience with Open AI's GPT chat ...

I'm looking for a freelancer with a strong comprehension of formal, strict language and knowledge in copyright law. The project's objective is to draft compelling copyright notices explicitly for m...draft compelling copyright notices explicitly for my business partners. The ideal candidate should possess: - Exceptional writing abilities - Familiarity with copyright laws and documentation - Experience in developing policies or legal documents with a formal and strict tone - Proficiency in Excel for organization and template creation Your tasks include: - Understanding my business and its partners - Writing strict and formal copyright notices - Organizing these notices in a user-friendly Excel format Quality, accuracy, and adherence to the formal tone are key...

I'm looking for a skilled Magento 2 developer to assist in successfully imp...CONFIGUARABLE products into an existing Magento 2 site. All I require is a few examples successfully imported so that I can then replicate the process with the full site products. I have no issue importing simple products but for some reason when I try to import configurable products they simply do not work how they are expected too. I will supply a CSV containing the sample data and I will identify the configurable product names etc on the document. You will be required to create a standard configurable products import sheet and successfully import them into our website ensuring that they AUTOMATICALLY are displayed and working as expected with no further action necessary by you/us ...

I have text data stored in a MySQL database that needs to be cleaned and formatted in Excel. Key Tasks: - Identify and correct errors in the data - Eliminate irrelevant information - Standardize data for consistency - Ensure data integrity and quality Key Skills: - Proficiency in MySQL database management - Strong experience in data cleaning and manipulation - Expertise in Excel for data formatting - Attention to detail for identifying anomalies and inconsistencies - Ability to ensure data quality and integrity We need a freelancer with a keen eye for detail and strong data management skills to take on this task. A background in data science or analysis would be highly beneficial. Please include examples of similar projects you have completed in your application.

Rebuild the Castle Farm store using the Flex 2.0 template and import all Shogun pages into the theme. This includes: Refreshing the homepage Adding a video block Reviewing and optimizing the store images Tabbed Description on product page Bullet list below the Add to cart button on product page. Updated product thumbnail position (left).

I am looking to develop an automated Excel Workbook specialized in the area of cost reporting. Key components I need are: - Calculation Formulas: Enable the workbook to calculate various financial metrics automatically. Should include revenue, expenses, and profit calculations. - Analytical Charts: The workbook should be able to visually represent the data and calculations such as revenue, expense, and profit trend lines. - Advanced Analysis: In addition to basic calculation formulas, the workbook should be able to analyze profit margins and handle cost variance analysis. It should have the functionality to run scenario analysis based on different inputs. Ideal candidates should have strong skills and experience in advanced Excel, particularly in creating automated workbo...

As a healthcare company, we are in need of a financially savvy individual for financial forecasting, budgeting and planning tasks. Your tasks will likely involve: Project Overview The purpose of this project is to develop a financial model that compares the pro... such as machine costs, consumable prices, and operating expenses Determine the potential profit margins for both leasing and selling scenarios Provide recommendations based on the financial analysis findings Project Scope The project will include the following activities: Data gathering and analysis of machine costs, consumable prices, and operating expenses Development of a financial model using Microsoft Exce Testing and validation of the model to ensure accuracy Creation of a report summarizing the findings and recom...

I am in need of an expert researcher to build an email list composed exclusively of Tax Advisers, Tax Advisors and Tax and Audit Firms operating within Germany. The primary purpose of this email list is for im...service offerings. Ideal Skills: - Proficient in online research - Proven experience in data collection and management - Background in marketing or business development preferable - Excellent proficiency in English and some understanding of German language would be beneficial. Outcome: - An accurate email list with verifiable contacts - Must be formatted in a clear, organized manner (Excel CSV preferred) This is a venture that requires a good understanding of the targeted industry. With your expertise, we hope to successfully reach out to our prospective clients. ...

Job Title: Sales Outreacher Company: KT Studio About Us: KT Studio specializes in growing personal brands and businesses, focusing on YouTubers and influencers aiming to enhance their growth and efficiency. Role: Sales Outreacher...outliers) Experience: 1 month to 2 years (training provided for beginners) Application Process: If you are driven by success and ready to seize this exciting opportunity, send a DM with the word "outreacher" along with your cover letter and resume showcasing your sales experience and why you are the perfect fit for this role. Highlight any achievements or skills that demonstrate your ability to excel in sales and client relations. We are seeking a standout candidate to join our elite team, and exceptional performers will enjoy a rewarding career...

I require an accomplished IT trainer proficient in implementing training in multiple areas - programming languages, networking, cybersecurity, Java full stack developer coursework, Python full stack developer coursework, Java Testing, Python testing, SAP, Devops, Power bi, Data science and Excel. The preferred programming languages for the training leverage are Java, Python, and SAP. I have a preference for trainers with recognized qualifications or certifications, demonstrating their competence in the field. Proven experience in delivering engaging and effective IT training is essential.

I am seeking an Excel expert capable of calculating First in First out (FIFO) for tech stocks that I own. Your responsibilities will include: - Taking provided data including purchase date, purchase price, stock ticker symbol, stock splits, the number of shares purchased, the number of shares sold and the respective dates - Arranging and analyzing these data accurately in an Excel document utilizing the FIFO methodology - Assessing if the stock sale is subject to tax due to the tax exemption for holding the stock for longer than 3 years The ideal freelancer would have: - Extensive experience with Excel - Familiarity with the FIFO method - Strong understanding of tech stocks This job will require attention to detail and precision. It's crucial the final produ...

I'm in need of a skilled copy typer to assist me with converting a variety of documents into a digital format. The documents I need typed are a mixture of printed and scanned materials. Key Requirements: - Copy typing experience, particularly with printed and scanned documents - Accurate replication of the original content - Ability to match formatting to the original document Copy required in excel

I'm urgently in need of a proficient freelancer who can help with a crucial data entry task. Unfortunately, I skipped some questions, so I'll provide more context. The task is a one-time project, but the data type to be entered is not fixed yet, it could be either numerical data, textual data or a mix of both. Ideal Skills Needed: - Efficient in Excel Data Entry - Experience with Online Form Filling - Proficient in Copy-Pasting Data This project requires some urgency so a quick turn around will be highly appreciated.

I'm in need of an expert in data entry, particularly in Microsoft Excel. The task revolves around basic data entry, which includes names, email addresses, and other related simple information. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Previous experience in basic data entry - Strong attention to detail - Ability to handle repetitive tasks accurately and efficiently Your primary responsibility will be to accurately transcribe and input the data provided into the Excel spreadsheet. Your attention to detail will be crucial, as even small errors could have significant repercussions. Please make sure you are comfortable with the given task before placing a bid.

I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.

We are seeking to develop an MVP for a SaaS product that leverages AI technologies to transcribe, rephrase, recreate, and translate videos. This platform will enable users to upload videos, extract and edit transcriptions, rephrase content to target specific audiences, synchronize the original audio with new lip movements in the video, and convert audio and subtitles into other languages.

I'm looking for an experienced Wordpress developer with hands-on experience building an e-commerce platform for my business using the Woodmart theme. Anyone can bid on this project. If you have experience with Woodmart themes and e-commerce and can import products to your website, I wouldn't be interested in his career. You can bid by using the words "woodmart-import" at the top of your offer. I don't have a lot of money right now, but since I'm still doing this, I'll pay you $10 a week. When I start this and other websites, I will increase my budget and he will be the project manager for my website. Now my website has some bugs that need to be fixed. Start working with me today. If you need a lot of money, don't bid. T...