Excel macro sort functionprá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í.
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
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
...avšak nelze zadat podmínka u jednotlivých pavouků dle obsahu stránky,tak aby stahoval data pouze některá data. Umožňuje omezovat pouze dle url ale potřeba je dle obsahu. Tedy možnost zadat pokud např id, či div obsahuje nějaké slovo stahni pokud ne - nestahuj. Např. pouze chceme získat všechny košile, víme, že se slovo shirts vyskytuje v drobečkové navigaci,atd.., tedy Zadání: Vytovřit software z Portia, Frotnera připadně potřebné, tak aby bylo možné: 1. zadat web ze kterého chceme data získavat 2. Výběr potřebných dat = Portia 4. Definice zdrojů dat - dle obsahu, viz již uvedené příklady. 5. Sběr dat 6
...avšak nelze zadat podmínka u jednotlivých pavouků dle obsahu stránky,tak aby stahoval data pouze některá data. Umožňuje omezovat pouze dle url ale potřeba je dle obsahu. Tedy možnost zadat pokud např id, či div obsahuje nějaké slovo stahni pokud ne - nestahuj. Např. pouze chceme získat všechny košile, víme, že se slovo shirts vyskytuje v drobečkové navigaci,atd.., tedy Zadání: Vytovřit software z Portia, Frotnera připadně potřebné, tak aby bylo možné: 1. zadat web ze kterého chceme data získavat 2. Výběr potřebných dat = Portia 4. Definice zdrojů dat - dle obsahu, viz již uvedené příklady. 5. Sběr dat 6
Hello, Your Request I create a simple application that will communicate with the server. Function application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (applications are minimized, but still sends location information) - Shut down button (Applications will be turned off) The application therefore has access to the Internet and GPS. nothing more
I need a program that will notify you when the sound pops authenticate using captcha systems. One of the boot program, which must function at the server
I'm seeking a data aggregator for a unique AI training project. Key Tasks: - Gathering text content from official website/source of the particular product/entity. - Focusing specifically on product descriptions, specifications, price and other attributes. Ideal Skills: - Basic searching skills - Able to follow given format of data collection - MS Excel or Google Sheets This project requires precision, and the information gathered will contribute to an AI's learning process. Accuracy in aggregation is, therefore, key.
I need help from an Excel specialist who can help me identify who has opened a shared Excel document that is located on Onedrive. I am trying to see when an employee accessed it last. - You'll need to create a solution that can track and log users who access the file. - The document is accessed by 2-5 people. - It would be beneficial if you could also provide a report or dashboard that can show this access data in a clear and concise manner. Please provide examples of similar work you've done in the past, and any relevant experience that you have.
Um Trabalho, que foi nescessario fazer uma contagem de pessoas e lugares influentes, e Tambem somar e totalizar, contagem de votos e estimativa de média e total de pessoas e votos. Dando atratividade a alguns nomes mais influentes
I have an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention to detail to ensure the documen...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
...my WordPress site with the Ultimate Member plugin. I want to implement a feature that allows users to be sorted by their distance from a specified location using Google API. Here's a more detailed description of what I need: - **Location Search:** This feature should enable users to input a location, and the system should sort users based on their distance from this point. - **Radius and Distance:** I don't have a specific radius in mind - the system should simply sort by closest proximity regardless of distance. - **Presentation:** The sorted users should be displayed in a list view. This is the primary way users should be able to see their matches. The ideal freelancer for this job should have: - **Experience with Ultimate Member Plugin:** A mastery of thi...
I'm developing a portfolio website using a WordPress template and WooCommerce. The primary focus of this project is to enhance the existing website to function effectively as a portfolio. Key Features: - **Service Listings**: The main aspect of the website is to present my services, so ensuring that these are well-organized, visually appealing, and easy to update is crucial. External Integrations: - **Social Media Platforms**: I'd like seamless integration with social media platforms to increase the site's visibility and user engagement. - **Email Marketing Tools**: Integration with email marketing tools to help me stay connected with my clients and potentially attract new business. - **Payment Gateways**: Ensuring secure and user-friendly payment gateways for pot...
I need a skilled and experienced fabricator to create a steel enclosure panel for me. - Material: The enclosure panel should be made from steel. - Function: The primary function of this panel will be to serve as an electrical housing. - Finish: The enclosure panel should be finished with a powder coating. The ideal freelancer for this task should have a solid understanding of metal fabrication, particularly working with steel, and experience in creating custom electrical housings. It is important that they are able to adhere to the specified finish requirements, in this case, a powder coating.
I am seeking a proficient VBA developer to help me create a set of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be ...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, with each answer corresponding to the respective question. The number of columns for answers ...
I'm currently dealing with a complex land issue. It involves an inherited piece of real estate for which there are no existing records. This has created an urgent need for a reliable professional who has valuable contacts in the Prime Minister's establishment. The core objective of this project will be to sort out this missing land issue. To dive a bit deeper into the problem: - The land was inherited, however, the records are lost. - Previous attempts to address this issue via the local land registry haven't yielded any success. For this project, the ideal candidate should have: - Experience in dealing with land record issues. - Strong contacts within the Prime Minister's establishment. - A proven ability to navigate and resolve complex property issues. - Exc...
I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks... and interpreting data. - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...
I'm looking for a skilled professional who can create more than 10 bar charts for a PowerPoint presentation. Requirements: - Proficiency in Microsoft Excel - Experience in visualizing survey results - Strong understanding of chart design principles The charts will need to visually represent survey data in a way that's engaging and easy to understand. Your role will be crucial in transforming raw data into meaningful insights. Please include relevant experience in your bid, and share any similar projects you’ve worked on in the past.
I'm in need of a professional with expertise in wired/wireless networking to help me fix my setup for my business. The main function of the network will be for business use, the system should be able to sustain between 10 to 20 devices without any connectivity issues. This includes but is not limited to PCs, printers, and other essential business equipment. Key skills and experience needed: - Proficiency in troubleshooting and fixing networks - Experience in setting up networks for business environment - Ability to troubleshoot and resolve network issues. The freelancer should be prepared to complete it efficiently and effectively.
I am in need of a freelancer who can swiftly handle two data entry projects. The tasks involved include: 1. Updating Gas Station Addresses: - The spreadsheet requires updating existing address data for about 80 gas stations based in Jamaica. - I have a specific format that I require this in, which I will share...creation of a comprehensive list of car makes and models, supplemented with brief, succinct descriptions of each car. - I have a list in word document, there may be some duplicates and there could also be more that I have not considered The successful freelancer need not have to be a subject matter expert, but should be able to undertake data entry tasks with accuracy and speed. Experience with Excel data manipulation and a keen eye for detail are ideal for...
I need help with a moderately complex data cleaning project. My spreadsheet data has missing elements that need addressing. What this entails: - Locating and dealing with missing data in the spreadsheets - Proposing solutions to prevent future missing data The perfect candidate would proficient in Excel or similar spreadsheet software, and have a keen eye for detail. Past experience with data cleaning would be advantageous.
I'm seeking a skilled individual to automate a series of tasks on Microsoft Excel, Sharepoint, Microsoft Teams and Email, using Pulover Macro and AHK where needed. Requirements include: - Automating a series of tasks in Microsoft Excel. This includes data manipulation, data analysis and reporting. The process is already mapped out and can be shared with you. - Using Pulover Macro and AHK, as well as VBA to facilitate the automation process. - Ensuring the automation process involves uploading files to Sharepoint, sending messages on Teams, and emails. The key deliverable for you is not just the completion of the automation process, but a clear and concise explanation of each step once the task is finished. This will be crucial for future troubleshooting ...
I'm seeking an experienced engineer/product designer that could build a 3-wheel E-Bike controller. This E-Bike controlle...controller must include a system that allows for the continuous tracking of a Lithium-ion battery usage. - LCD Display: The controller should be equipped with an LCD display that visualizes the battery status and speed settings. It is essential the freelancer working on this project has experience in product design and engineering, with a strong familiarity in Lithium-ion batteries and how they function within e-bikes. Knowledge of LCD functionality is also necessary. Your attention to detail and careful consideration of safety and functionality will be critical for this project. Your prime consideration should be to make the controller user-friendly yet h...
I'm seeking a developer to create an escort site in Spanish. The primary function of the site would be to present escort profiles to users. Key Features: - Escort Profiles: The site should display profiles of escorts. - Gallery of Photos and Videos: Each profile should include a gallery of photos and videos of the escort. - Detailed Service Descriptions: Alongside the visual content, detailed descriptions of the services offered by each escort should be included. - User Ratings and Reviews: The site must allow users to rate and review the escorts, providing feedback for other visitors. Additional Portfolio Information: - Age and Nationality: I'd like users to see the age and nationality of each escort. - Availability: Information on the availability schedule of each esc...
I have a list of contacts in an excel file, and I need someone to find their email addresses. - The main task will be to locate and verify the email addresses of these contacts. It is crucial that the emails provided are accurate. - The purpose of this exercise is for personalized outreach to these individuals and not for mass email marketing or research purposes. The ideal freelancer for this job is someone with excellent research skills, an ability to meticulously verify information, and experience in email marketing or personalized outreach. A high level of proficiency with Excel is also required. Files: There are lots of entries that need to be completed. you will need to add the email address of
We are looking for a highly skilled Technical Support Specialist to join our team remotely. As a Technical Support Specialist, you will be responsible for providing excellent customer service and technical assistance to our clients. Your main duties will include troubleshooting hardware and software issues, managing device configurations, and providing account support. To excel in this role, you should have a strong technical background, excellent problem-solving skills, and the ability to communicate effectively with customers. Skills required: - Technical troubleshooting - Device management - Account support - Customer service - Communication skills
I need an Excel sheet that can help me analyze customer information for trends and patterns. This will involve: - Basic Formulas and Functions: The data room should have basic formulas and functions that allow for the easy manipulation and analysis of customer data. - Data Room Design: The sheet should be designed to be user-friendly and intuitive, making it easy for me to analyze the data without getting lost in the spreadsheet. - Data Analysis: The main goal of this project is to analyze the customer data for trends. So, the ideal freelancer will have experience with data analysis and the ability to create custom formulas to uncover patterns. - Attention to Detail: Accuracy is key in this project. I need someone who is meticulous and can ensure that all the data is entered cor...
I'm seeking a WordPress and Elementor expert to analyze and resolve speed performance issues that are affecting my entire website. Despite my own efforts, which included installing a caching plugin, image optimization, and minimizing JavaScript and CSS files, my website remains slow. Ideal ca...modification - Advanced knowledge and skill in caching - Familiarity with image, JavaScript and CSS file optimization techniques Your main tasks would be to: - Identify and fix the underlying cause of the slow loading times throughout the site - Conduct a thorough check and resolve any issues of the theme and cache deployment - Provide recommendations for maintaining optimal site speed. Be able to sort out the 'First Contentful Paint 4.8 s Largest Contentful Paint 5.1 s Total B...
I am looking for a skilled Alteryx expert who can take on a project involving data blending from complex Excel spreadsheets. The project specifically involves: - Utilizing Alteryx for blending data from multiple sheets in Excel - Handling complex data structures within the Excel spreadsheets, including nested tables and formulas. Ideal candidates will have: - Proven experience with Alteryx, particularly in handling data blending tasks - Strong understanding of complex data structures, like those found in nested tables and formulas in Excel This project requires a high level of attention to detail and proficiency in data manipulation, so please only apply if you have the necessary expertise.
I need to make a project for the university, on the subject Basics of computer graphics. The task is to implement a simple graphics card (gpu). And also implement the model visualization function. In the file student/, implement the function izg_enqueue - the functionality of the video card implemented by you. In the student/ file, you implement the prepareModel, drawModel_vertexShader, and drawModel_fragmentShader functions. These functions are used to process the loaded model file into the graphics card memory and command buffer. In addition, the folder contains the file student/ - it contains declarations of structures and constants. The project is written on Linux, but is also suitable for Windows in Visual Studio and CMake. The task consists in adding gpu
I'm in need of a talented system developer who can design a web-based system with an emphasis on data management and analytics. The primary function of this system will be to handle and analyze customer data. Key responsibilities include: - Building a system with robust data management capabilities - Integrating analytics measures to interpret customer data - Ensuring the system is web-based and user-friendly Ideal candidates should have: - In-depth knowledge of server-side logic - Proven experience in web-based system development - Strong problem-solving skills - Experience with data management, particularly customer data analysis From this project, I expect a system that can effectively manage and interpret customer data, providing insights that drive decision-making. Ple...
I'm looking for a skilled Python developer to build a custom forum platform with a rest API integration. Key Features: - User registration and login - Discussion threads - In-forum search function - PayPal functionality Design Preferences: - The user interface should be customizable with various themes. Experience and Skills: - Proven python programming skills - Experience in creating custom forum platforms - Familiarity with rest APIs and PayPal integration - Knowledge in design and UX for optimum customization capabilities This project requires a systematic and detail-oriented approach. I expect clean and efficient codes to ensure the platform's smooth operation.
...years of technical business or functional analyst experience and demonstrated ability to see a project through from beginning to end including creation of business requirements and formal documentation during the solution development life cycle required Strong emotional intelligence (EQ) and interpersonal skills required Experience with workflow design required Proficient in Microsoft Word, Excel, PowerPoint, Project, and Visio preferred Supervisory Responsibilities: None Travel: Up to 20%, to include overnight stays, may include an annual software user conference Physical Requirements: This role frequently communicates with others, must be able to exchange accurate information in these situations This role routinely uses standard office equipment such as computers, p...
I'm in need of a savvy professional who appreciates the finer details of Major League Baseball (MLB). You'll be tasked with compiling a comprehensive sprea...should cover designated players and/or teams - the specifics of which I'll supply once you're on board. 3. Additional Factors: In keeping with the finer details, the spreadsheet should also cover the Date of Game, Team A vs Team B data, analysis on which pitcher is better, and predictions on which team will win. The ideal candidate will have a strong background in data manipulation, particularly in Excel or similar tools. But more than just your average data enthusiast, I'm specifically looking for someone with a deep understanding of baseball. If you can hit a home run with MLB stats and predictions, ...
I need a freelancer proficient with both Excel and Photoshop for two primary tasks. Excel Work: - Conduct data analysis and create visualizations, leveraging skills in updating and organizing data Photoshop Work: - Provide graphic design and photo editing services Ideal candidate should have solid experience in both platforms and a keen eye for details. Understanding my needs in data management and visual design will be a key success factor.
I'm currently dealing with an issue in my iOS React Native application. The change mode callback isn't triggering properly. I am looking for a seasoned React Nativ...knowledge in React Native specifically for iOS - Proven experience in debugging and enhancing callback functions - History of adding new features to existing code You can expect to: - Diagnose the issue where the change mode callback isn't triggering properly - Add additional functionality to the callback, ensuring its functionality - Enhance the overall performance of the change mode callback function. Your strong understanding of callbacks in React Native will be instrumental for this task. This is a focused task targeting an urgent issue, and I appreciate timely resolution. I'm looking forward t...
I need the online / offline sync to work seamlessly. We have a react native app using mongodb realm. There was an instance where a few records where created and then after pressing home those records vanished. They weren't synced to mongodb and where no longer present in the app. There is no delete functionality in the app. There is a function which checks for online status using netinfo and then when online will re start the sync session with mongodb. There is a frontend indicator which shows the realm connection status and the network connection status. At the time of this error it was reported the indicator which shows realm is connected was flashing both offline and online rapidly which may be the cause of what happened. i think the issue resides in Providers > RealmSu...
...seeking an experienced developer to address two issues with the SMS and email functions on my website: - **SMS Function Fix**: Currently, the SMS function is not sending messages as intended. The developer should investigate the root cause and implement a solution that ensures smooth and timely delivery of SMS notifications. - **Email Function Fix**: The website's email function is also currently failing to send emails. The successful candidate will need to identify the source of this problem and implement the necessary changes to ensure that emails can be sent successfully. Ideal candidates should have: - Proven experience in troubleshooting and resolving SMS and email function issues on websites - Strong understanding of backend development, ...
