Excel macros scriptsprá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
...features including user registration and login, order tracking, payment gateway, inventory management, a seller app, a delivery agent app, an iOS app, an Android app, and a web app. The solution must provide a smooth and seamless experience for both customers and my team. - **Platform/Framework**: While I'm open to suggestions, I'm considering using scripts from Envato or Code Canyon as a base for this project. Any framework compatible with these scripts would be acceptable. - **Timeline**: I don't have a strict deadline for this project, but I'd appreciate if the work could be done as efficiently as possible without compromising quality. Ideal skills for this job include: - Proficiency in the selected platform/framework - Experience in integrating ...
I'm seeking a talented designer to create a distinctive and functional outfit for women's competitive tennis. SINGLET AND SKIRT Key Points: - The outfit will consist of a singlet and skirt. The specific fabric for the outfit is yet to be decided. - It shoul...appealing, suitable for the competitive tennis environment. Requirements: - Strong design skills, particularly in sportswear. - Experience in creating custom clothing for sports. - Knowledge of functional and performance-enhancing fabrics. - A keen eye for fashion and current trends in sportswear. Your task is to develop a unique and high-performing outfit that will help a female tennis player excel in competitive play. The successful design should not only enhance performance but also make a distinct fashion sta...
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
I'm seeking an expert to boost the loading speed on the homepage of my Shopify store. Key responsibilities: - Commence with an thorough review of my Sh...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 plugins, as these elements could be one of the probable reasons for the current speed issues. Please mull over the above points before placing your bid. Looking forward to boosting my Shopify store's performance w...
I'm in need of a comprehensive AI bookkeeping script that can handle various crucial functions for my clients. We are a bookkeeping firm and handle 50+ clients....user-friendly and intuitive interface is essential for this project. The system should be easy to understand and navigate for users with different levels of technical knowledge. Ideal Skills and Experience: - Extensive experience with AI and machine learning for financial applications. - Proficiency in QuickBooks integration and banking platforms. - Strong background in creating complex financial scripts with robust features. - Prior experience with user interface design and a good understanding of user experience principles. - Ability to create scalable, secure, and reliable systems that can handle large volumes of ...
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 ...
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.
...company. The website will contain information about our company and the product we rent out to other professionals. We want a clean, modern, buisness website. based on a CSS framework. We are not looking for a web content management system like wordpress. I need the design to be programmed on our server including the needed .css files, javascripts. We will be adding the texts, images and special scripts later on. - The design should be unique and original. So no basic wordpress deisgn; - There are no high resolution photo's; - We want clear and ordered script - The design and colours should be based on our logo; - The website will have a menu with 2 or 3 submenu's; - The website will be rich of information/photos of our products and events; - There will be no webshop...
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.
...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 in need of an intermediate-level PostgreSQL developer to convert MySQL scripts into PostgreSQL. The tasks I need completed include: - Converting existing MySQL scripts to PostgreSQL. Expect to handle scripts that are between 100 and 500 lines. - Ensuring that the converted scripts work correctly and efficiently. Ideal candidates will have a solid background in both MySQL and PostgreSQL, with a focus on performance optimization. Proficiency in debugging and problem-solving is highly preferred. Please submit your bid if you can confidently translate these scripts while ensuring full functionality and optimized performance. Your experience and portfolio will be a decisive factor in this project, as I place a great importance on proven skills.
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...
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.
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 in ...
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'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...
I'm looking for a skilled ...of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in finance or trading would be beneficial. This project requires a freelancer who is detail-oriented, with a keen eye for market trends, and can create a reliable and efficient script that aligns with my specific requirements. I'm open to discussing and incorporating any additional insight...
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?
My Excel file is very heavy and unorganized. I want it to get cleaned and effecient
I’m looking for a freelancer proficient in Excel who can create a dynamic tool for my restaurant business that helps in managing my food costs and menu pricing calculations. Key responsibilities include: 1. Cost Analysis: Crafting a spreadsheet that can factor-in: - Food cost percentage - Gross profit margin - Break-even analysis 2. Menu Pricing: The spreadsheet should provide calculations on: - Menu item profitability - Menu item pricing based on the desired profit margin Ideal candidates are detailed-oriented and have substantial knowledge in cost analysis and pricing strategy in the restaurant industry. Excel expertise including functions and formulas is paramount. Past experience in successfully building such tools will be a definitive plus.
I need a simplistic, one-page website linked to a database. This page will have limited content, including a logo and a 'check authenticity' button. The database will be provided in an Excel sheet format, and must be integrated seamlessly into the page. Key Requirements: - Develop a one-page website - Integrate an Excel database for product authentication - Provide a clean, simplistic design Ideal Skills and Experience: - Experience in web development, particularly one-page websites - Proficiency in database integration, specifically Excel - Ability to create clean and minimalist designs - Strong understanding of web security and authentication processes
I'm seeking an expert in data analysis to help with profiling and analyzing our financial data. The ideal professional will have the following experience and skills: - Proficient in financial data analysis - Able to generate comprehensive analytical reports - Experienced in Excel for data presentation
I need an experienced PHP developer to help with customizing a PHP script. The specific details of the modifications are: - User Authentication: Implement an effective user authentication system. - Database Integration: Ensure sea...database. - UI/UX Enhancements: Enhance the user interface and user experience of the script. Please note that the specific PHP script has not been disclosed, and further details regarding the script's functionalities have not been provided. The successful freelancer will need to be able to navigate and modify PHP scripts efficiently and have a good understanding of user authentication, database integration, and UI/UX principles. Your expertise in PHP and familiarity with various scripts and their modification will be crucial in ensuring ...
I am in need of a proficiently experienced VSL scriptwriter. Our objective is undefined for now, as the topic, time length, and target audience of the Video Sales Letter (VSL) was not specified. Requirements: - Extensive experience in ...audience of the Video Sales Letter (VSL) was not specified. Requirements: - Extensive experience in video sales letter scripting, preferably in a formal and professional tone - Proven ability to convey complex ideas in a clear, concise, and engaging manner - Capabilities to script content that's no longer than 5 minutes. Ideal Skills and Experience: - Proven experience in writing high-quality VSL scripts. - Versatile writing skill able to adapt to different topics and audiences. - Strong research skills to gather credible information on ...
summarize in a specific table in Excel
Hi Ravi Ranjan K.,I have a task of import of purchase excel to tally prime for now .
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
I am currently using ZOHO Books and am looking to migrate to Odoo Accounting. I need an Excel expert to help with the migration process. Key Tasks: - Migrate complete set of invoices and bills from ZOHO Books to Odoo Accounting. - Transfer all customer and vendor details accurately to Odoo. - Ensure that financial reports are maintained and migrated correctly. Ideal Candidate: - Proficient in both ZOHO Books and Odoo Accounting software. - Excellent experience in data migration and Excel. - Familiar with maintaining and handling large databases. - Detail oriented, ensuring data integrity throughout the process. This is a large scale project as my current ZOHO Books database exceeds 1000 records. I need someone who can efficiently and effectively handle the migration proc...
I am looking for a video editor to edit our existing UGC footage into high-converting direct response video ads, for use across Facebook, Instagram and Tik Tok. I am looking for you to provide creative strategy / script ideation with customer research + direct resp...Instagram and Tik Tok. I am looking for you to provide creative strategy / script ideation with customer research + direct response video editing (and sometimes using AI voiceovers). Ideally we set up a process of 3-4 new videos per week. In summary, you need to: - Edit existing footage to create high converting video ads - Do audience research and craft scripts for creative video concepts tailored to our customers - Create new video scripts/ideas weekly Please provide some examples of the most recent videos ...
Answer the attached question correctly, and briefly explain. using principles of subnetting. I'm looking for an expert in networking who can provide correct answer and clear and concise explanation of the attached question. Answer the attached questions, the provide table of the subnets Accepted file format Excel or Word
I'm in need of a professional to write concise yet comprehensive reports. Details regarding the purpose and type of reports were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. T...were not specified. Ideally, the freelancer should be adept in creating performance analysis, expense tracking, project updates, financial, sales, and progress reports as all these may be requested. The frequency of generating these reports is also yet to be confirmed, so preparedness to deliver on a daily, weekly, or monthly basis is essential. Superior skills in data analysis, proficiency in excel or other relevant software and report writing is a must fo...
I am seeking a skilled freelancer with proficiency in Excel, especially in performing statistical analysis using frequency distribution and creating informative visualizations. To get specific, the scope of work involves: - Converting my Excel sheet data into meaningful insights via statistical analysis - there is 12 workbook, represent date palm trees five varites. - each tree has branches which is recorded in the cell. -some trees did not produce - need a colorfull charts that represent branches . IF BRANCH IS 0 MAY BE WE COLOR RED. IF ONE WE GIVE OTHER COLOR, IF 10 MAY BE GREEN. - NEED TO HAVE THE SUM OF BRANCHES TOTAL NUMBER IN EACH WORK BOOK - BRANCHES MAY PRODUCE 4 KILO OR 5 KILO: NEED TO HAVE A FORMULA THAT I CAN CHANGE AND KNOW THE TOTAL PRODUCTION OF EACH WORKBOOK...
