Odbc driver as400 excel vbapráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
I'm searching for a proficient developer to create a trading bot that operates on the Dhan platform. This bot must be integrated with Excel. Key Features: - It should have the functionality to automate trades based on calculations of quantities on a predefined Stop Loss (SL). - Its operation will involve using fixed quantities for all trades, regardless of SL level. Ideal Skills: - Experience in bot creation. - Knowledgeable about the Dhan trading platform and Microsoft Excel. - Strong understanding of trading algorithms and risk management. Your bid will be more competitive if you have previously done similar projects and can show a portfolio or examples of your work.
I need a diligent individual to assist in typing handwritten notes into a Google Excel sheet. The notes consist of text data only. I expect the job to be done meticulously and with a high level of accuracy. KEY REQUIREMENTS: - Proficiency in typing and data entry - Experience with Google Sheets - Strong attention to detail - Ability to decipher unclear handwriting - Good judgement in making best guesses when handwriting is ambiguous The freelancer is expected to: - Review the handwritten notes and type the corresponding text into the Google Excel sheet - Exercise good judgement in cases where handwriting is unclear, making the best guess possible - Keep the formatting consistent and accurate. Please reach out if you have any further questions.
I am seeking an experienced data entry specialist to assist me with both digital and manual input into Microsoft Excel. The ideal freelancer will provide assistance with data extraction, cleaning, and verification to ensure accuracy and consistency of the data. Skills and experience required: - Proficient in digital and manual data entry - Expert in Microsoft Excel - Experience in data extraction, cleaning, and verification - Strong attention to detail - Ability to handle large amounts of data. The primary objective of this project is to manage and organize data efficiently. I'm expecting a high level of precision on the data entered. The candidate should be able to demonstrate experience in handling both digital and manual data entry jobs.
...library of automation tools. These tools will be designed to handle a wide range of tasks from data analysis to report generation and workflow management. The goal is to fully automate these processes to boost our operational & technical efficiency. project SOW: 1- build excel sheet list of company support of oil & gas upstream automation processes. first from UAE local company than find global company (list include: company name & type of tools service & description service tools & contact (website) 2- check the attachment excel, you will find the overall job & activity in oil company & type of tools need & find more activity + tools support. 3- find company build dashboard can service all tools depende of division & find solution to ...
I'm looking for a professional who can effectively transcribe text data from documents and PDFs into a Google Excel sheet. The project requirements are as follows: - Expert skills in typing and data entry. Accuracy is paramount. - Proficiency in Google Sheets is a must. - A keen eye for detail to ensure the data is inputted correctly. - Knowledge of PDF documents to navigate and extract data. Due to a lack of structure details for the Excel sheet, I would need someone who can come up with an efficient layout that will make data referencing easy. The project presents an opportunity for those with data entry and organization skills. Any previous experience in similar projects will be a plus. Please place your bids with a brief description of how you plan to approach thi...
Job: Change field names in vb source code according to Excel table (from/to)
Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.
Challenging opportunity for a skilled Excel Specialist. The details of the tasks are undefined due to insufficient information from the client. Candidate must be proficient in: - Data organization - Formula creation - Data analysis The size of the dataset is unknown and could range from small to large. You are expected to be able to handle any data size comfortably. While the type of analysis isn't specified, you should be skilled in: - Statistical analysis - Trend analysis - Financial analysis In summary, I need an Excel maestro who can confidently navigate any project, no matter how ambiguous. Your expertise, flexibility and adaptability will be essential for this project's success.
Need someone who can create a complete video course for teaching excel from beginner level to expert level. Videos can be short as 2 minutes each to 8 minutes maximum. Need high quality videos showing right from how to open an excel sheet on a computer to on how to write real tome formulas.
I am looking for a proficient Excel expert who is highly experienced in financial data analysis. You will primarily be tasked with conducting comprehensive revenue and expense analysis. The ensuing breakdown of financial information will allow us to understand and evaluate our company's financial health. Ideal Skills and Experience: - Deep understanding of Excel, particularly in data analysis - Expertise in Financial analysis, specifically revenue and expense analysis is a must - Excellent in applying Excel for financial forecasting - Capacity to design efficient spreadsheets that emphasizes readability and ease of use - Fluency in formulating functions to automate data computations.
As a business owner, I need a proficient and efficient freelancer who can manage my company's financial data in Excel format. Key responsibilities: - Accurately entering, managing, and updating Income and Expense statements daily. - Ensuring data is correct, up-to-date, and accessible. Ideal skills: - Proficiency with Microsoft Excel - Strong attention to detail - Experience with financial data management Please note, this role requires daily work and a consistent, reliable, and professional approach. Experience in financial data entry is preferred but not mandatory.
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a p...
I am on the lookout for a skilled freelancer who can efficiently add new functionalities to .sdi files. The main goal is to enable updating drivers, specifically for graphics, audio, and network components. - The job primarily involves the addition of new functionality, with a focus on driver updates within the .sdi file. - You will need strong knowledge of the .sdi filetype and have experience in working with driver updates. - I require prompt task completion with minimal error, so prior experience with similar projects is preferable. Ideal Skills: - Expertise in working with .sdi files - Technical knowledge of Graphics, Audio, and Network drivers - Experience with updating drivers through .sdi files. I look forward to working together on this task.
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I'm need of an expert in Excel, particularly with a strength in creating complex calculation systems, for the task of data keeping. Key Tasks: - Understand and implement a data structure for holding financial data - Build a system for complex calculations within the excel sheet Qualities Needed: - Proficiency in Excel - Experience dealing with financial data - Ability to design and incorporate complex formulas for calculations - Analytical thinking The Excel sheet will specifically monitor and report Budget versus Actuals, so experience in handling these aspects are an added advantage. The goal is to have a seamless, reliable system for my financial data.
I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.
I'm seeking an experienced Brawl Stars coach who can help me elevate my gameplay to the next level. Having played on both Android and iOS platforms, I've developed a decent understanding of the game but I want to push my skills further to become a formidable competitor. **What I'm Looking For:** - **Expertise in Brawl Stars:** Someone who has a track record of high achievement in the game and can provide proof of their skills. - **Coaching Ability:** Not just a great player, but someone who can teach. You should be able to analyze my gameplay and offer actionable advice. - **Focus Areas:** Since I'm looking to generally improve my gameplay, having a broad understanding of key strategies, character usage, and gameplay mechanics is essential. **Expected Outcomes:** - ...
...approaching their designated stop. These notifications should be timely and reliable. - **Multi-Bus Tracking**: The app should allow parents to track not just one, but multiple buses. This is especially helpful for parents with multiple children attending different schools or taking different buses. -** show pickup time and drop of time in the morning and evening on driver account, parent account and admin -** qr code for every passenger so driver can scan ant the app records drop off time and pick up automaticly Ideal Skills: - Proficiency in mobile app development for both iOS and Android platforms. - Prior experience with GPS tracking applications. - Knowledge of integrating real-time tracking systems. - UI/UX design experience to ensure the app is user-friendly and ...
...bid, read carefully. Do not ask me about my budget during the chat because I have already indicated the budget if you can't help or if you think the budget is too little, save some time for both of us I want to have a website made by a freelancer. the website is intended to track and register passengers and drivers. the database must have the following users. -Administrator -Driver -Parents what should the driver be able to do? 1. register 2. Scan passenger in and out using a QR code 3. be able to record comments for each passenger per day if necessary 4. being able to see each passenger monthly report of where they got in/out and at what time. 5. Be able to create a QR code for every name. Drivers must be able to clock in and clock out while driving. what shoul...
I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.
I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly
I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cle...some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry a...
...to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. This project is very large, so I would like to start with a very high-level review of my concept: Current job and price is for 1) The review of a 2-page outline of my development project, up to (6) PDF and/or Excel documents that are currently in use, and (1) Excel-Based production tracker that attempts t...
Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown i...
I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.
The Doordash driver app called Dasher requires a zip code for registration. Right now, in most states, a large portion of drivers are placed on a waiting list because there are more drivers than needed. I need to find several zip codes (5 - 10) for the Dasher application that, when entered, would prevent new drivers from being waitlisted (that is, they would be taken to the next page, and not to the page with a message that they have been added to the waitlist).
Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations
I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.
I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.
I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key to the s...
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...
Necesito un excel simplificado y parametrizado (formulado) para comparar si vale la pena comprar o alquilar una propiedad, según gastos y costo de oportunidad.
I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.
I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...
