Excel automation step stepprá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.
I need 3D scanned models in any of the following formats: Autodesk Alias (*.wire) AutoCAD DWG File...CATProduct, *.CATPart) DXF Files (*.dxf) FBX (*.fbx) IGES (*ige, *iges, *igs) NX (*prt) OBJ (*.obj) Parasolid Binary Files (*.x_b) Parasolid Text Files (*.x_t) Pro/ENGINEER and Creo Parametric Files (*.asm, *.prt) Pro/ENGINEER Granite Files (*.g) Pro/ENGINEER Neutral Files(*.neu) Rhino Files (*.3dm) SAT/SMT Files (*.sab, *.sat, *.smb, *.smt) SolidWorks Files (*.prt, *.asm, *.sldprt, *.sldasm) STEP Files (*.ste, *.step, *.stp) STL Files (*.stl) SketchUp Files (*.skp) 3D scanning models of the following models required Models Hero Splendor Honda Activa Hero HF Deluxe Honda CB Shine Bajaj Pulsar Hero Glamour TVS XL Moped Hero Passion TVS Jupiter Bajaj Platina Royal enfield 35...
Položka Cena Tvorba výkresové dokumentace ................ Kč bez DPH / za 1 součást V ceně má být zahrnuta tvorba níže uvedených výstupů pro každou součást : tvorba modelu - step soubor tvorba 3D pdf souboru (pro prezentaci součásti) tvorba výkresové dokumentace - pdf, dxf soubor (pro některé součásti více výkresů, např. obráběcí, slévarenský) modifikace popisového pole výkresů (1 pole pro všechny výkresy) kontrola nového výkresu - srovnání se starým výkresem + doplnění informací neb...
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í.
...Na každém vygenerovaném PDF bude umístěn vygenerovaný QR kód včetně jeho alfanumerické alternativy, kdy po jeho načtení (např. mobilním telefonem nebo zadáním alfanumerického kódu do formuláře, který je také potřeba vytvořit) a potvrzení dojde ke změně stavu objednávky. Možno využít např. tohoto modulu nebo vlastního řešení: Nutno generovat QR pro každý produkt individuálně (po jeho zaplacení) na zasílané PDF. U každého QR kódu bude jeho doba platnosti (např. 12 měsíců) po který jej lze "uplatnit" - toto bychom měli mít možnost u každého produktu v adminis...
Mladá rozvíjející se společnost (Simple Step s.r.o.) hledá pro externí spolupráci headhunters pro oblast práva.
I AM LOOKING FOR A CAD DESIGNER TO CREATE A LIGHT WEIGHT YET TRENDY PROTECTIVE CASE THAT SLIPS RIGHT OVER THE LATEST IPAD PRO. HERE IS A LINK FOR THE SPECIFICATIONS FOR THE IPAD PRO. PLEASE REFER TO SIZE AND WEIGHT SPECIFICATIONS FOR DESIGNING GUIDELINES. FORMATTING FOR THE CAD FILE MUST BE IN .STEP, .STP, .STL, .OBJ
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
...this project includes the setup of a new GTM container, implementation of the necessary data layers on our website, and the definition of variables and event triggers. We will also set up and configure Google Ads Conversion Tags within GTM to ensure that all conversions from Google Ads are accurately tracked. This includes mapping out the user journey from ad click to purchase, ensuring that each step is properly tagged for conversion tracking. The project recipient is required to handle all aspects of the setup, ensuring that we can effectively monitor our e-commerce environment, track and optimize our Google Ads conversions, and refine our customer engagement strategies accordingly. This comprehensive tracking setup will enable us to better understand the effectiveness of our a...
Currently in need of a talented C++ software engineer. Due to insufficient details given, I am looking for a professional who is adaptable and capable of various types of software development. Ideal Skills and Experience: - Profici...details given, I am looking for a professional who is adaptable and capable of various types of software development. Ideal Skills and Experience: - Proficiency in C++ - Experience in desktop applications, embedded systems, and game development - Ability to implement features such as data encryption, user authentication, and file management - Capability to create software for data analysis, automation, or simulation Your ability to adapt to potential project needs will be highly valued. Please include your relevant experiences and adaptability whil...
...full-stack JavaScript developer to help construct a remarkable web application. While I don't necessarily have a preference for the specific platform, I'd appreciate it if the developer can provide recommendations and explain their platform choice, whether it's React.js and Node.js, or Angular.js and , or Vue.js and Django. Your role will encompass both front-end and back-end development. To excel in this job, you need to have: • A strong grasp of full-stack JavaScript development • A robust knowledge of various frameworks • Experience in building web applications • Excellent problem-solving abilities and detail-orientated approach • Strong communication skills to ensure clear discussion of the project details and progress This project...
As your client, I'm looking for a specialist having a proficient knowledge of Microsoft Excel to achieve a simple data manipulation project. The task involves predictive analysis of data, heavily leveraging date and time functions. Key Responsibilities: - Manipulating data using simple Excel functions. - Predictive analysis using Excel based on the manipulated data. Ideal Candidate: - Sufficient proficiency in Microsoft Excel, with specialised expertise in date and time functions. - Strong attention to detail and accuracy in data entry and analysis. - Superior skills in organising and ability to handle increasing complexity when required.
I am looking to streamline a workflow using PowerApps and PowerApps. The current process involves manual data entry and multiple data sources, . Specifics: - Simple form development: The PowerApps should ideally support the current data input requirements. - Workflow automation: flow should be integrated to handle creating folder and subfolder. Skills and Experience: - Proficiency in PowerApps and flow - Experience in developing automation for complex workflows
I'm seeking for an expert in Excel VBA with strong debugging and troubleshooting skills along with the ability to optimize the performance of existing macros. The key responsibilities would be: - Debugging and troubleshooting my created Excel VBA Macros - Enhancing the efficiency and performance of these Macros - Inclusion of new features as required - And finally be able to explain the code for each module. What I'd really value is a clear and concise explanation of what each module does, and this requirement would be fulfilled best by providing detailed comments in the code. This project is perfect for anyone with a deep understanding of Excel VBA, Macro functionality, and a passion for clear and enlightening code documentation.
I have some rough sketches of a mechanical device that I'm working on and need help refining them into detailed CAD drawings (step files) and PDF that can be issued to a machine shop so that they can manufacture. There are 3x crossovers required to be drawn up, which have common threads. They are: 2-3/8" EUE Male x 1.5" UNF Female 2-3/8" EUE Male x 1-1/4" UNF Female 1.0" UNF Female x M24 2.0P Male Key requirements: - Length of the crossovers is flexible, and they will also need a small bore drilled through them, which I can detail. - You'll be working mostly from my rough sketches but are also welcome to suggest any necessary adjustments for the sake of precision and functionality. The threads are relatively common and can be googled easily, but ...
I'm seeking a qualified automation developer to create an automation framework in Java, specially tailored for the execution of functional tests snd regressiontests. This project requires: - Fluency in Java language programming, with demonstrable experience in developing automated frameworks. - A strong background in software testing, particularly in thetesting area. - A deep understanding of scalable systems, capable of growing to meet increasing needs. With your expertise in this domain, you should facilitate the task of creating, implementing and scaling functional tests. Please ensure your work is properly documented for future maintenance and scaling. It is crucial for me that the framework can be effortlessly scaled and served according to the evolving requiremen...
I'm in need of an expert who can proficiently convert a 12-page Excel document into an editable PDF while maintaining its original layout. Key requirements: - Preserve the current layout of the Excel document in the converted PDF. - Ensure the PDF is editable not a read-only. - Important: There are links and media embedded in the Excel document that must remain functional in the PDF. Ideal skills to have: - Strong experience with Excel and PDF conversions. - Attention to details especially concerning layout preservation and media functionality. - Excellent communication skills to address any clarifications promptly. This project requires specific expertise, and the exact replication of the Excel layout is critical. If you feel suited for this ...
I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table. Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.
I'm looking for a skilled professional to create a...Google ad campaign aimed to increase enrollment for our Data Analytics and PLC Automation courses at our Jaipur center - www.seldomindia.com. Target Audience: - Working professionals - College students Value Proposition: Our course offers: - Enhanced career opportunities - Practical skills with real-world applications - Expert-led training leveraging industry experience The ideal freelancer for this role should have a proven record in creating successful Facebook ad campaigns, specifically in the education sector. Understanding and experience in effectively targeting both working professionals and college students would be a significant advantage. Knowledge of education pertaining to data analytics and PLC automation...
I am looking for a freelancer with extensive experience in operating and managing Trengo, to optimize our platform in the following areas: - Inbox Management - Workflow Automation - Reporting and Analytics - Website Automation - Chatbot Prioritization of these tasks will be in the order they are listed. The freelancer should understand the importance of a well-organized inbox, effective workflow automation systems, insightful reporting and analytic tools, seamless website automation, and an efficient chatbot. By executing this project, I am aiming to achieve the following objectives: - Increase Response Time - Streamline Customer Communication - Enhance Customer Satisfaction - Increase Efficiency I am looking for a freelancer who is driven by these same...
...provider of digital solutions in the field of Automation (including Robotic Process Automation) and AI, with a focus in the Finance & Accounting domain. We are looking for a freelance Sales Development Specialist to support our team in accelerating our business growth by generating high quality leads. Responsibilities: • Proactively identify and engage potential clients and key decision-makers across targeted industries in Singapore. • Execute outbound marketing campaigns to generate leads, utilizing multiple channels such as cold emails, phone calls, and social media. • Establish initial contact with prospects and maintain engagement to cultivate business opportunities. • Assess the needs of potential clients, focusing on business automation...
I'm seeking an experienced Azure Data Engineer to step in and effectively collaborate with my remote team. Given the lack of a specific task or main goal, your expertise, adaptiveness, and versatility will come in handy. Key responsibilities may likely include: - • Ideal candidates should have strong experience with Azure Databricks and Data factory. • Conducting data analysis - Data integration - Data processing - Possibly executing ETL processes - Maybe venturing into data modelling, optimization, and pipeline development. • Efficient communication and collaboration capabilities are needed for this remote role. • I look forward to working with an adaptable professional who can confidently handle diverse tasks in Azure data engineering. • Desig...
I'm in need of a professional developer who can create a web-based part navigation system for my business. The site should be user-friendly and similar to a few examples I can provide for reference. Key Features: - Search Function: The website should have an easy-to-use search function that allows u...c=TOYOTA00&ssd=%24%2AKwHh1cTP4ruKk-bk467w57mtjYqU5ern5vTb6KCmlYGdmZuY3crmjKKmopOFnI3L1tzh6JKYkpyPlvTq2Kjwofbp8I_1pqb78ejkqa2nvLPK_7qwu7H26eP59ezt_PHo9-Xi4uD1pqbxvfDv9uLjkOS5t7qurKO9t5Ku9ennuuny9-Xg4Obmuqa08_C8oPHo9fXaxcqSn_f48_C4tKi-uPGZ5OaegPiQwtzfmIr3-PPwo7Sovrjx6uTshPD596ji8bfw7_ThrwAAAABNkruS%24&vid=0&cid=1&uid=29070&q= The Wire Frame and navigation will be designed by us. The PDF along with Excel files with reference and page number will be provides...
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 tr...
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 Native developer to step in and add additional functionality to fix this issue. Main requirements: - Excellent 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...
...client details - develop a record card system for each visitor and customer.. We will have user registration and login, and a seamless online ordering system for our product. Key Requirements: - User Registration and Login: The website should allow for a clear and secure user registration process, and a login portal for returning users. Ideally, we would like to make use of intelligent ‘multi-step’ forms - with 1 sign-up question at a time, and we will have Different Access Levels: I require different access levels for clients and multi-user / admins. Admins should have the ability to manage the product catalog and edit other site content. - Payment Gateway Integration: The website must integrate a secure payment gateway to facilitate online transactions for our p...
I need a professional d...as source: The data should be scraped from various websites, so a good understanding of web scraping is crucial. - Weekly updates: The extraction will need to be performed every week, so the ability to automate or efficiently manage unique scraping is essential. Ideal Skills and Experience: - Web scraping: Proficiency with tools and techniques for web scraping, especially for textual data. - Automation: Experience with automating scraping processes for repeated extraction. - Accuracy and reliability: The extracted data must be complete and accurate, ensuring a reliable and consistent output every week. I'm looking for someone who can handle this task efficiently, ensuring that the extracted data is complete, accurate, and delivered consistently on ...
I am in need of a dedicated, smart, and detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis o...detail-oriented Virtual Assistant to help me for 10-20 hours per week with specific emphasis on data entry and analysis. Key tasks will include: - Data input - Data categorizing and sorting - Providing analytical summaries of data - Exploring trends and patterns - Collaborative problem-solving based on findings The ideal candidate should have strong experience with data entry, analysis, and Microsoft Excel, along with solid administrative skills. Attention to detail, strong organizational skills, and the ability to work independently are crucial for this role. If you're versatile, motivated, and have an analytical mind, I would love to have ...
Anda bisa bekerja kapan saja dan di mana saja! Bigo Live sedang mencari freelancer untuk menjadi affiliator yang bertugas membagikan link unduhan Bigo Live di platform online dan sosial media. Tanggung jawab Anda termasuk membagikan link, menciptakan caption kreatif, Gaji pokok $10 dengan bonus hingga puluhan juta Rupiah untuk setiap klik dan unduhan yang dihasilkan. Kualifikasi: -Pen...unduhan Bigo Live di platform online dan sosial media. Tanggung jawab Anda termasuk membagikan link, menciptakan caption kreatif, Gaji pokok $10 dengan bonus hingga puluhan juta Rupiah untuk setiap klik dan unduhan yang dihasilkan. Kualifikasi: -Pengalaman dalam pemasaran afiliasi atau promosi online -Kemampuan komunikasi yang baik dan orientasi pada target. - Bisa mengoperasikan Google Sheet/ ...
I need a skilled freelancer to convert several Excel spreadsheets into interactive PDF files, preserving the original Excel formatting. The converted PDF files should retain all functionality, including interactive components such as forms or clickable links. Ideal Skills: - Proficiency in Excel - Expertise in PDF conversion with interactive elements - Exceptional attention to detail to ensure formatting preservation Experience Required: - Extensive experience in converting Excel to interactive PDFs - Proven track record of working with similar projects from the past - Familiarity with handling complex Excel formatting.
I'm on the lookout for proficient freelancers who excel in web development, app creation, and video editing. This is a great opportunity for those who are able to deliver top-notch results efficiently and at a reasonable cost. What I'm Looking For: - Web Development: The primary focus is on creating an e-commerce website. Ideal candidates should possess a strong foundation in e-commerce website development and a keen eye for design. - App Creation: I'm seeking app developers with a proven track record. Your ability to develop seamless, user-friendly apps that deliver a great user experience is essential. - Video Editing: Skilled video editors with experience in producing high-quality, professional results. In Your Application: I'm most interested in your exper...
I am looking for a data scraper to extract information from the JazzCash agent locator list available on their website (). Key Requirements: - I need the data to be delivered in an Excel spreadsheet format. - The specific details that I require for each Jazz locator are the Name and Address, along with the Services offered. - The scraping needs to be done only once; it will not be recurring. Ideal Skills and Experience: - Proficiency in web scraping, particularly using tools like Python's Beautiful Soup or Scrapy. - Experience in extracting data from websites with dynamic content. - Strong attention to detail to ensure accurate data extraction. - Previous experience with similar data scraping projects will be an advantage. I am particularly interested
...existing application and website, and I'm in need of a skilled Figma & UIUX specialist to help with this. Here's a breakdown of what I am looking for: - Wireframing and Prototyping: You should be able to create detailed wireframes and interactive prototypes of the existing application and website. This will help us visualize the improvements and changes that need to be made. - Visual Design: The next step will be to incorporate the wireframes into a visually appealing design. You should have a strong sense of aesthetics and be able to create a design that is not only visually appealing but also functional and user-friendly. - User Research and Testing: It's essential to conduct user research and testing to ensure that the changes being made are actually impr...
I am seeking a proficient Zoho developer to implement workflow automation into my current Zoho CRM. The key tasks for this project: * Designing and implementing a seamless workflow automation within the existing Zoho CRM to streamline business operations. Skills & Experience: * Comprehensive Zoho developer experience is paramount. * Proven record of successful implementation of workflow automation. * Proficiency in CRM Development is beneficial. In your application, please include a detail of your Zoho developer experience to demonstrate your capacity to complete this project. Please do not include past work or detailed project proposals, as I am particularly interested in your prior hands-on experience. Your expertise in Zoho is what will distinguish you i...
I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.
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 Native developer to step in and add additional functionality to fix this issue. Main requirements: - Excellent 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...
I need an experienced professional in MES and SCADA systems to consult with and possibly hire for further tasks. Your primary responsibilities will be system integration, troubleshooting, maintenance, and creating new systems. Your main...I need someone who can demonstrate their experience in this field with a portfolio. It's a plus if you have experience in the following: - PLC programming - HMI design - Robotic integration - SCADA and DSC - Drives implementation - CAD for industrial automation - Hydraulic and Pneumatic systems expertise - Experience with Industrial Switchgear and Solutions - Assistance with Automation & Control Panel Manufacturing - Support with Vfd Panel Supply, and Industrial Panel Manufacture - Contribution to Industrial Au...
I am looking to create an Excel tool that will streamline our disbursement process. The tool needs to handle data entry automation, calculation of disbursement amounts, and generation of disbursement reports. Key Features: - Data Entry Automation: This will help us input information quickly and without errors. The tool should automate data entry to reduce human error and increase efficiency. - Calculation of Disbursement Amounts: Once the data is entered, the tool should automatically calculate the disbursement amounts based on predefined criteria. This will help us ensure that the amounts are accurate and consistent. - Generation of Disbursement Reports: After the calculations are done, the tool should be able to generate reports in a clear and user-friendly forma...
...full-stack JavaScript developer to help construct a remarkable web application. While I don't necessarily have a preference for the specific platform, I'd appreciate it if the developer can provide recommendations and explain their platform choice, whether it's React.js and Node.js, or Angular.js and , or Vue.js and Django. Your role will encompass both front-end and back-end development. To excel in this job, you need to have: • A strong grasp of full-stack JavaScript development • A robust knowledge of various frameworks • Experience in building web applications • Excellent problem-solving abilities and detail-orientated approach • Strong communication skills to ensure clear discussion of the project details and progress This project...
Requirements: It is required to create a comment system like the one on the following website http...comments shows the icons of each option you have selected, The idea is to make everything the same but with a different appearance. The system must work in WordPress and must be worked on until it is 100% functional. My website is made with Wordpress + Elementor. STEP 2: After having the system completed in its entirety, some comments that are in a json must be imported; they must go to each of the fragrances, which are more than 50k. And now the new comments should be added as normal without accepting the old ones. STEP 3 : You must tell me your prices and time, do not ask me my budget, just tell me when you charge and the time it will take and if you are 100% sure ...
I'm currently in need of a competent individual proficient in data entry tasks. The ideal candidate must have strong experience and skills in managing and operating data with Excel Spreadsheets. Your task revolves primarily around: - Data entry into an Excel Spreadsheet Experience with Excel Spreadsheets is a must for this project. Perfect attention to detail and accuracy are vital. Applicants should be able to work autonomously and deliver high-quality results. Please note that the type of data to be handled has not been specified; it may include text, numerical, or image data.
...enhance our customer segmentation strategies. As such, the project will require a deep understanding of customer behavior and sales patterns. - **Data Type**: The data provided for this project is structured, primarily in Excel and CSV files. Your ability to effectively manipulate and analyze this data will be crucial. Ideal Skills and Experience: - Proficiency in Azure and strong experience in running ML models on the platform - Proven track record in customer segmentation and sales data analysis - Ability to work with and manipulate structured data effectively, particularly in Excel and CSV formats I'm looking for someone with a solid understanding of sales data and a keen eye for customer segmentation. If you're confident in your ML skills and Azure proficie...
