Excel vba string functionsprá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í.
...není UART bootloader dostupný. Bohužel ostatní piny jsou plně využité. Komunikace s PC je přes FTDI chip a USB jako standardní virtual Com port. Funkce bude standardní. Po restartu bootloader čeká na příkaz a pokud nepříjde (do cca 5s) jde rovnou na aplikaci. Pokud přijde čeká na poslání dat nového FW a po uspěšném zapsaní skočí na aplikaci. Je dán komunikační protokol, data jsou posílána jako string o pevné délce 19bytů - první dva byty jsou moje hlavička, pak je 16bytů dat a jeden byte jako konec. Uživatelskou aplikaci pro PC píšu já sám v Lazarus/Pascal, takže detaily posíl&a...
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
Zdravim :o) Potrebujem preklady textov z SK/Cz do Rustiny U prekladov ide o XML, jednoduche.. priklad: <string name="">Vyberte slovo stejného, nebo podobného významu. Příklad: Primitivní, naivní, jednoduchý, hrubý je správná odpověď [b]primitivní[/b].</string> <string name="">Skvěle! Pokračujte</string> <string name="">Toto není správně</string> <string name="">Informace</string> <string name="">Vyberte si svůj trénink</string> Prvý dokument ma 231 takýchto riadkov....
...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...
...mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria: General appearance and manufacturability of parts Quality and c...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I'm looking for an experienced app developer who can customize the WoWonder Mobile Apps. Specifically, I need the "Users Nearby" feature to be revamped. Instead of ...Key Requirements: - Transform the "Users Nearby" feature into a real-time map display via Google Maps - Integrate user profile previews on the map The ideal candidate would have: - Proficiency in WoWonder Mobile Apps - Extensive experience with Google Maps API - Prior experience with real-time map integration - Strong understanding of user data handling - Ability to implement interactive map functions Please note that communication and collaboration skills are also important, as I'm looking for someone who can not only deliver on the technical requirements but also work closely with me t...
I'm in search of a talented Angular developer with a keen eye for design for my corporate website. Key Responsibilities: - Designing the webpage layout with a corporate audience in mind - Implementing responsive design to ensure the site functions flawlessly across various devices Ideal candidates should have: - A strong portfolio showcasing their exceptional skills in both Angular and design - Proven experience in creating responsive websites
I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...
I'm in need of a Point of Sale (POS) interface that works on both Android and iOS devices. The main functionality requirement for this interface is barcode scanning. Additionally, I need this POS interface to support multiple user profiles, each with their unique access levels. Key Project Requirements: - Develop a Point of Sale interface that functions on Android and iOS platforms. - Implement barcode scanning capabilities within the interface. - Create a multi-user system with different access levels for each user. I'm looking for a developer with experience in: - Android and iOS development - Barcode scanning integration - User management systems
I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...
I'm urgently requiring a skilled professional to assist with three key HR functions in my growing small business. These include: - Hiring and Recruitment: Expertise in this area is especially critical as choosing the right candidates is the backbone for a successful venture. - Training and Development: Your role would be to design and implement development strategies to nurture employee skills and maximize their job performance. - Performance Management: To ensure alignment with business goals, you would be in-charge of setting up a performance management system and spearheading the process. It is paramount for the ideal hire to have experience with implementing such functions within a smaller organization, understanding the unique challenges and opportunities that com...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing value...(e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsoft Fabric and Excel (VBA) • ...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...
I'm looking for a web designer/developer to redesign an IT company's website. The current site has plenty of content but has become disorganized and hard to navigate. The key details of this project are: - We would like to keep the same color scheme. - Modern and slick design, but we should still be able to display lots of ...mobile responsiveness: The new website must be highly responsive on all mobile devices. - An organized navigation that is less confusing then the current is a major focus for this project as well. The current site is www.rivell.com. The most creative/functional submission will be rewarded and expected to work with us on edits and changes that we feel are necessary to keep/enhance the current functions of the site. This not only for design, but a...
I'm seeking professional he...making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to understand that the scope of the project is conversion and compatibility, rather than development or adjustment of any specific function. Therefore, a strong understanding of technical requirements between Windows 8.1 and ...
I'm seeking a skilled and experienced individual to craft a concise and compelling pitch deck. The purpose of this pitch deck is to secure funding for my project. Key Sections: - Market Analysis: You'll need to conduct comprehensive market research and present it in a succinct, engaging way. - Business Model: I need a clear, concise explanation of how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project bri...
... It’s a brand-new company that is starting from scratch. Stage of the business: Our company has crafted a highly interesting app that offers different options to both customers and prospective drivers. We have reached the second stage of the recruiting process and company branding. The app is ready to hit the market soon. Materials: We will explain how the app functions, with videos, literature, and detailed context. Objectives to achieve Create a formal presentation on the application’s appeal to prospective drivers and passengers. Provide an objective assessment of the application, covering both its strengths and weaknesses in depth. We plan to promote you in a high-level and exclusive way, giving you the resources needed to achieve ...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
I'm looking for an experienced developer to work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - ...
I'm in need of a freelance writer to craft an engaging, informative article on boardrooms. The key aim is to provide general information for the public. Key Requirements: - The article should cover a detailed explanation of the full function of a boardroom. - It must...making complex concepts easily understandable. - I will need a turnaround time of 4 days. - Needs to be between 1,500 and 1,800 words - Must use 3 to 5 references in the article that will be provided upon awarding of the project. Ideal Skills and Experience: - Proven experience in creating engaging, informative articles. - Good understanding of business terminologies, specifically boardroom functions. - Ability to simplify complex concepts for a general audience. - Timely delivery and open to feedback for poss...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I need a freelancer to correct the layout of my website...and development - Previous experience in correcting website layouts - Attention to detail and ability to follow specific instructions - Excellent communication and ability to work collaboratively - Familiarity with HTML, CSS, and any other relevant programming languages Your responsibilities will include: - Adjusting the layout of the homepage to ensure that the website looks professional and functions seamlessly - Following Google Business account guidelines to link our website with our Google Business account - Making small corrections and adjustments to perfect the layout I'll provide you with more specific details once we start working together. I look forward to receiving your proposals and discussing the project ...
Develop a WeChat/Alipay app for a large-scale event in Hong Kong, you need to use it on WeChat/Alipay. It can be used by people in Hong Kong, Macau and China. The functions are mainly used to view event information, videos, reminder functions, mini games, contact customer service, and connect Department external website
...should be smooth and seamless, using the provided SDK and API keys. The primary goal is to ensure that the payment gateway functions properly and securely, without any errors, and provides a flawless user experience. Requirements: Proven experience in integrating payment gateways, preferably with Tap or similar services. Proficiency in the programming languages and frameworks used in my application (please specify if it's for Android, iOS, or a cross-platform framework). Strong understanding of API integration and handling secure data transactions. Ability to implement the payment gateway according to the documentation provided by Tap. Ensure the application functions correctly with the new payment gateway, including thorough testing in both sandbox and production e...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is ...
I'm in need of an experienced Reddit virtual assistant who can successfully engage user interaction in a fun and engaging way. Your tasks will include: - Regularly posting relevant, funny and general content with a kn...driving discussions on said topics to boost community interaction. It would be ideal if your skills and experience have a touch of wittiness, understanding of meme culture, and overall, a strong grasp of sparking interesting conversations within the Reddit platform. Prior experience in user engagement and community management on Reddit is also highly valued. Knowledge on how Reddit operates and functions is critical, so previous experience in posting and interacting on the platform will put you at an advantage. The aim is to create a dynamic and interactive Re...
I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...
I need a skilled developer to create custom functionality for my WordPress site using JavaScript. This new feature will be integrated into a specific existing page on my website. I need a site, showing the villas and providing the same experience for visitors. This site has many villas and features, including filters, maps, and search functions. It has 120 villas. I need the search filters and map filter search the same as reference site. The site has a big map showing areas like North, West, etc. When you click on an area, it should display the villas in that region. If you can make a similar map feature, that would be great. Let me know if you can do this.
Hello, I need a skilled website developer to create a site offering dual functionality of IFSC and Pincode lookup. The features required are: - Pincode lookup: Displaying detailed area information related to the entered Pincode. - IFSC lookup: Displaying bank details related to the entered IFSC code. This job is ideal for someone experienced in incorporating interactive lookup functions into website design. An understanding of banking data and geographical area details would also be advantageous. Please only apply if you can demonstrate prior, similar projects in your portfolio. Domain Name & Hosting is already available. The main goal is to monetize this site and generate good revenue through advertisements and other means. Thank you -D
Project Description: We seek a highly skilled software developer to compile the ARM64 code from GitHub, based on Golang 'go'. Your role is crucial in ensuring the Velociraptor server operates flawlessly on the Odroid N2+ platform (4GB RAM) by creating an installer or Debian package (.deb) that functions flawlessly on Debian Ubuntu 20.04 (MATE Desktop). The ARM64 code is available online, and we wish to have it as a package so the user can run it and go through the setup of the velociraptor server seamlessly on the N2+, use the local webserver to create agents (sensors as MSI or exes) and analyse/collect remote endpoints using the open source tool on the box. This project involves adapting the Velociraptor software, an open-source security tool , to work seamlessly
I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of arrival (ETA)...
I have an existing MERN stack project where I need assistance with CRUD operations specifically on MongoDB. Your tasks will include: - Creating, reading and updating data in the existing MongoDB database - Integrating these functions into the existing MERN Stack structure Ideal candidates will have: - Previous extensive experience in MongoDB - Proficiency in MERN Stack - Knowledge in handling CRUD operations The applicant will be favored if they provide a detailed project proposal that not only outlines their approach to the tasks at hand, but also any challenges they might foresee and how they plan on mitigating them.
