Vba excel optimizing codeprá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í.

datae

datae

mise en forme

Mám 2 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.

Mám 3 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.

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

I want few methods from objective c to java to be translated.

Napraviti Excel VBA program

...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...

Function is done, amend the label that is stored and the value show. Only with ftp

I'm seeking a skilled interior des...house. The project will involve a full overhaul of the living room, kitchen, and bathroom. Key Tasks: - **Living Room**: I'd like to create an open floor plan with better lighting and new furniture, enhancing the overall aesthetics and functionality. - **Kitchen**: I'm looking for an improved layout, optimizing the space for better practicality and flow. Ideal Skills and Experience: - Proven experience in house replanning or interior design. - Proficiency in creating open floor plans and optimizing space. - Ability to source and recommend new furniture and lighting fixtures. If you have a strong portfolio in similar projects and are confident in your ability to deliver a fresh, modern design that maximizes space and fun...

I am seeking an AI coder for the development of a full-featured online ordering platform that emphasizes on streamlining orders and deliveries. Primarily, the platform should be designed to : - Excel on both desktop and mobile devices ensuring a smooth customer experience on all interfaces. - Prioritize on real-time scheduling functionality that optimizes order fulfilment with exemplary efficiency. -Connect to Service Monster API -Use as payment gateway. Ideal candidates should possess profound expertise in AI coding specifically in enhancing online platform functionalities. Experience with building real-time scheduling systems is critical for this project. Furthermore, a strong background in mobile and desktop compatibility is essential. The aim is to create an ordering

...loading speed on the homepage of my Shopify store. Key responsibilities: - Commence with an thorough review of my Shopify site to identify the elements that are causing slow loading times. I am uncertain about what these might be and would appreciate your expertise on this matter. - Focus your speed improvement strategies on the homepage primarily. This is a crucial gateway for my customers and optimizing its loading speed is significant to reduce the bounce rate. Skills and Experience: - Prior experience with Shopify platform. - Proven record of successful site speed optimization projects. - Proficiency in diagnosing and rectifying site issues that cause slow speeds. - Excellent understanding of handling high resolution images, numerous videos, and heavy scripts or plugi...

I am seeking an experienced RPA Developer to automate tasks relating to Excel and Web interaction. Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink you will open a broswer tab with that link analize the result of the web programming 1 or 2 IF statements Proceed to generate the unatended "clicks" in that web close the tab iterate with the next excel cell (in this case d6) repeat the web process Until Excel's data EOF Everything configurable via external TXT file - name of the excel file - starting cell - basic hyperlink - how to compose the final hyperlink - the IFs statements - the sequence of clicks for each IF condition Immediate offers after posting will be directly ignored as ...

...candidate will be responsible for inputting, updating, and maintaining data accurately and efficiently. - Email and calendar management: Handling and organizing emails and managing calendars, scheduling appointments and meetings. - Customer service and support: Providing excellent customer service, addressing queries and concerns. Software and Tools: - Microsoft Office Suite: Proficiency in Word, Excel, and PowerPoint is required. - Vettrak Student Management System: Experience with this software is beneficial but not mandatory. - Dropbox: Familiarity and experience with file management on Dropbox. - Facebook and Instagram. Ideal Skills and Experience: - Previous experience in administration, data entry, and customer service roles. - Intermediate proficiency in Microsoft Office...

I am in need of a skilled bookkeeping specialist proficient in Tally data entry and Excel data entry and formatting. Key Tasks: - Entering less than 100 entries per week into Tally. - Formatting and managing Excel data. The work will be ongoing, with updates and reports required weekly. Ideal Candidate: - Must possess extensive experience with Tally and Excel. - Proficiency in bookkeeping and data entry. - Ability to handle tasks efficiently and with a high degree of accuracy. - Understanding of financial reports and data reconciliation. The ideal freelancer will be able to deliver clean, well-organized data, and provide timely reports. If you have the skills and experience required, please get in touch.

I'm in need of a skilled web designer to give my ecommerce website a modern and responsive makeover. The designer must be able to deliver a fresh and easy-to-navigate user interface. Although I've not specified any particular areas for redesign, potential areas to focus on could be: - Revamping the homepage layout - Improving product pages for a more engaging product presentation - Optimizing the checkout process for a seamless user experience I won't be able to provide an exact number of products on the site as that detail was skipped, but the designer should be prepared to handle a flexible number of products. Additional features or functionalities were not specified, however, innovation is encouraged. Proposals suggesting interesting functionalities such as p...

I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.

...looking to employ an experienced Google Ads professional who can completely revamp my existing Google Ads campaign with the finest expertise. Being given no specific parameters, you will require a comprehensive investigation and understanding of the project in-hand. Your tasks will include, but not be limited to: - Evaluating and amending the ad copy - Tweaking targeting options where necessary - Optimizing ad extensions - Suggesting necessary improvements You are also expected to make boundary-pushing changes as per your creative liberty while keeping up with the campaign's KPIs and other industry standards. The ideal freelancer would be someone who possesses: - Proven experience in Google Ads campaign management - A strong understanding of targeting and ad extensions ...

...can export the text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized final results. There will be 901 rows of Ex...

...diligent freelancer with strong attention to detail and experience with Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of accuracy and organisation. - Good leve...

As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to w...

I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus

I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful completion o...

I'm in need of a sophisticated chatbot solution. This chatbot should have the capability to interact with and analyse documents uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap, I'm seek...

...is 'Standard Definition (SD)', so the optimizations and improvements should be focused on this specific resolution. - The main focus for this project is on speed. While maintaining a balance between speed and image quality is important, the primary goal is to significantly speed up the image generation process. Ideal Candidate: - A proven track record in AI image generation, particularly in optimizing the process for speed. - Proficiency with AI image generation tools and techniques. - Strong understanding of the trade-offs between speed, quality, and cost in AI image generation. - Excellent problem-solving and analytical skills. If you have experience in AI image generation and optimization, especially in improving speed without compromising quality, I'd love t...

...urgent time-frame. The tasks include: - Feature Development: Your primary responsibility will be to create and implement new features to meet our exact needs. Specific features will be disclosed upon hire. - Performance Optimization: Secondary tasks include reviewing existing code to identify areas for optimization and overall performance enhancement. The ideal candidate for this project will have extensive experience in Laravel development, with a strong track record in both creating new features and optimizing existing ones. Familiarity with user interface design, payment processing infrastructure, or user registration/authentication systems would be a plus, but is not required. Please contact me with your resume and relevant work samples. Your proven history with La...

...real-world - a spectacular railway route nested in a British countryside landscape. - ACCURACY: A high level of accuracy is paramount. Familiarity with British topography and structures are desirable. If you have previous experience with railway environment designs, that's a plus. - SKILLS: Proficiency in Unreal Engine and mastery over creating real-world replicas is a must. Experience with optimizing landscapes for real-time games will be highly beneficial. Your ultimate objective will be to breathe life into this virtual route, doing justice to its real-world charm and grandeur. The railway line, signals, landscape with LiDar data will already be in and you will be responsible for the scenery aspect to bring the route alive. We will provide you access to our version ...

...objectives of each. Writing keyword rich, SEO friendly blog posts between 500-750 words for the StratDev SEO team to publish externally (also known as guest posts) on high traffic blog channels, optimized for keyword usage, and SEO Best practices. Creating “spin-off” blog posts, based on existing internal content, optimized for external posting and traffic acquisition towards the source content. Optimizing existing blog content before posting for maximum SEO efficacy (backlink addition,keyword inclusion, page titles, meta descriptions, headings, alt tags, anchor text, etc.) Press release writing and optimizations Formulating blog topic ideas by researching trending topics within a client’s industry, as well as blog creation based on pre-selected topics. Other re...

...Python and Arduino (C++) code. The main task is to correct the Arduino code I already have. Currently, I am sending in string containing 80 characters or so like (<4, 100, 30, 200, 15, 100, 15, 20, 10>), from Python to arduino, however arduino is receiving 0 as the values for the ending like like (<4, 100, 30, 200, 15, 100, 0, 0, 0>). In the serial monitor it does receive the correct values. Here's what the job requires: - Review and correct the current Arduino code - Arduino MUST receive the correct values sent from Python - Adequate understanding of Python as values are sent from Python - Ability to provide suggestions for improvements would be a plus Ideal skills and experience: - Strong proficiency in Python and Arduino (C++) code - P...

...C/C++ and code optimization, I'm seeking a professional to assist in optimizing my C++ based Acap application. Key tasks: - Dockerfile Configuration: This includes setting up the Dockerfile to ensure the application runs optimally within a Docker container. - Code Optimization: I need someone with experience in C++ to analyze, refactor and optimize the application's codebase to improve its performance. - Debugging: Identifying and resolving issues in the application that may be affecting its efficiency. Ideal skills: - Proficiency in Docker: You should be familiar with setting up Docker containers and optimizing them for C++ applications. - C/C++ Proficiency: A strong background in C++ is crucial for analyzing and optimizing the codebase....

I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.

Hi there, My name is Baldev, I am a full-stack certified Magento 2 developer with 5+ years, I specialize in optimizing Magento 2 stores plagued by performance issues, database errors, and configuration conflicts. With extensive experience, I'll swiftly identify bottlenecks causing slow performance, rectify database errors, and resolve configuration conflicts for seamless operation. My approach involves meticulous analysis and targeted solutions to ensure optimal performance. Past projects demonstrate my proficiency in Magento 2 optimization, database management, and problem-solving. Trust me to elevate your store's performance and stability, providing tangible results. Let's collaborate to restore your Magento 2 store to its peak efficiency and functionality. More...

As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling...

I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases

I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...

I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data i...

I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specific...

"I want to create a simple Python project that can scan grocery items and provide information about them, such as protein, calories, added sugar, and other nutritional facts."

...Fixing database errors: We are experiencing database errors that need to be addressed promptly to ensure smooth operations. - Resolving configuration conflicts: There are conflicts in the configuration which need to be resolved to avoid further complications. Ideal skills for this project include: - Prior experience with Magento 2: You should have a solid background in working with Magento 2 and optimizing its performance. - Database Management: Strong experience in managing large databases on Magento 2 and resolving database-related issues. - Problem-solving skills: Ability to effectively identify and resolve issues related to website performance and configuration. Please provide examples of relevant work you have completed on Magento 2 in the past, and your approach to addres...

I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...

In order to effectively drive my ongoing project, I'm in need of someone skilled at gathering specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal ca...specific data and preparing it into a highly organized spreadsheet. The data needed include: - Name - Email - Job/Business - Phone number(Whats app) of (NRI) Non Resident Indians in UAE The ideal candidate for this task should demonstrate: - Proficiency in data collection, and data management. - High level of accuracy and attention to detail. - Proven experience in sourcing data and utilizing Excel or similar spreadsheet software. Looking forward to advancing my project with ...

I need someone to transcribe the content of the picture to a excel as the same way. I have 100 picutures like this one. How much for this job?

I'm in need of a highly skilled Laravel developer with a strong background in backend development. Your key resp...authorization packages We're looking for an Expert level Laravel developer who can hit the ground running. You should be comfortable working with Laravel's backend functionalities and have a keen eye for efficiency and security. Skills and Experience: - Proven experience in Laravel backend development - Expertise in integrating authentication and authorization packages - Proficiency in developing and optimizing APIs - Previous experience with API development tools is a plus Your work will be crucial in ensuring our systems run smoothly, securely, and efficiently. A strong grasp of Laravel's backend architecture and experience with authentication a...