Excel automation examplesdela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

...existing dashboard, that are already captured in the App, for better administration. The App does not have any e-commerce, it aligns customers with individuals within a geolocation to preform the task The ideal candidate should have significant experience in cross-platform app development, a strong grasp of Ul/UX design, and a proven track record in enhancing app performance. Please share examples of previous work and outline your approach to this project in your bid....

Prosimo, vpišite se ali se prijavite za več podrobnosti.

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...students. - Target the graduate level: While the paper should provide a comprehensive understanding of the subject, it should avoid delving into unnecessary complexity. The ideal writer will be able to strike a balance between thoroughness and readability. - Engagement: The paper should be engaging and able to maintain the audience's interest throughout. This may include using case studies or examples to illustrate the concepts in a real-world context. The writer should ideally have: - A solid background in corporate finance: Experience or education in corporate finance is essential to ensure the paper is accurate and informative. - Previous experience in academic writing: Experience in writing for a graduate-level audience, and an understanding of how to structure and pres...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I'm looking for an experienced QA Automation Engineer for solving some issues we have in a complex Jmeter script which we are using in our performance/load tests. This is a 1 week job at most and payment will be fixed at $500. Our JMeter script is not a simple one, so if you are not a real expert in JMeter please do not apply. You will fail to do the project. If you are an expert using JMeter for really complex projects, please apply by simply answering the below questions: 1- Tell us why you consider yourself a JMeter expert. 2- What were the most complex 2 projects that you did JMeter tests for and what made them complex. Please type "I can do it" at top of your reply so that I know you actually read the description.

I'm looking for an experienced web developer with strong WordPress and Elementor skills to update our corporate website. The main focus of this project is to add a blog/news section and a careers section to our site. In addition to these main tasks, there are various other content updates required. Key tasks involve: - Designing an...testimonials. - Updating text and images across the site and adding new pages as needed. Ideal candidates should have: - Proven experience with WordPress and Elementor. - A strong portfolio demonstrating success with similar projects. - A keen eye for design, layout, and user experience. - Strong communication skills to understand our needs and provide updates throughout the project. Please include examples of your work and your hourly rate in...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I am in search of a skilled shoe designer with a keen interest and experience in designing sneakers and sports shoes of premium quality. This project focuses specifically on the male consumer market, so an understanding of the preferences and aesthetics of men's athletic footwear is a must. Key Requirements: - ...Experience: - Prior experience in designing men's athletic shoes or sneakers. - A good knowledge of sneaker cultures and trends. - Proficiency in design software. Some of the References Designs like RedTape are preferable. If your experience matches these requirements and you have a passion for creating innovative and appealing shoe designs, I'd love to hear more about your ideas and see some examples of your previous work. Let's create some exceptio...

I'm currently in the process of building ...impactful. Design Style: - I'm looking for a bold and modern design style for the website. The overall appearance should be visually striking and should reflect a modern aesthetic. Ideal Candidate: - Strong experience with WIX: Proficient in working with WIX to build user-friendly and visually appealing websites. - Analyses current Portfolio Trends - Portfolio of Past Work: I would like to see examples of your past work - Design Sensibility: A good eye for design and the ability to translate a bold and modern aesthetic into a website. - Attention to Detail: An eye for detail is crucial in ensuring a polished final product. If you're confident you can help me create a professional and engaging portfolio website on WIX, I...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I'm looking for a skilled software developer who can create a custom, user-friendly test taking software for my extensive question bank. Key Features: - The software should support multiple choice questions only. - I need th...breakdown by question. Ideal Skills and Experience: - Proficient in software development, specifically in creating educational software. - Experience with creating user-friendly interfaces and interactive features. - Strong understanding of database management to handle a large question bank. - Familiarity with constructing detailed result summaries based on user performance. Please provide examples of similar projects you've completed. I'm open to suggestions on how to make the software more efficient and effective for our users, so feel ...

I'm looking for a skilled Python developer to create a security application with robust intrusion detection capabilities. Key Features: - Intrusion Detection: The application must be able to detect and alert me about any potential security breaches. - Log Gathering: I'll need the app to effec...effectively. Ideal skills and experience: - Strong Python programming skills, coupled with experience in security applications. - Proficiency in designing and implementing robust intrusion detection systems. - Prior work on IoT device integration and data gathering. - Experience in access control management is a plus. - Understanding of secure logging mechanisms. In your bid, please include examples of similar projects you've completed and let me know how you plan to tack...

...Implement caching, lazy loading, and other performance enhancements using WP Rocket to improve site speed and overall user experience. • Collaborate with the team to achieve speed scores of 95+ on Google PageSpeed Insights and GTmetrix, focusing on performance, engagement, accessibility, and best practices. 4. Integration and Testing: • Integrate WooCommerce with Klaviyo for seamless email marketing automation, ensuring a cohesive customer experience across all touchpoints. • Transfer settings and configurations from Google Analytics, Google Search Console, and Google Tag Manager to the new WordPress/WooCommerce site for accurate tracking and analytics. • Perform thorough testing of all site functionalities, including Google Merchant Feed file integration, to ...

I am in need of someone with expertise in updating tasks in a digital planner. I would need the freelancer to: - Automate the initial task in bucket 1 to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, a...- Automate the initial task in bucket 1 to re-appear after completion - After bucket 1's task has been completed, automate a new task in bucket two, -Once bucket 2's task is complete, automate a new task in bucket 3, and so on. I specifically require these tasks to be automated using Power Automate. The ideal freelancer will have experience in digital task management, Power Automate and task automation. This should allow for a smooth update of tasks in my planner with...

I am in need of an experienced expert to design a dehumidification system for my entire household. Energy efficiency, noise level, and capacity are critical factors for this design. Essential Skills and Experience: - Experience in Environmental Systems Design, specifically for dehumidification or similar indoor regulation systems - Familiarity with designing complex resident...specifically for dehumidification or similar indoor regulation systems - Familiarity with designing complex residential systems - Strong emphasis on energy-efficient design strategies - Understanding of noise level control within system design - Experience with different dehumidification system capacities Potential applicants are kindly asked to highlight their experience and give relevant examples of prev...

I require a 3D model to be made of a mixed-use building, a mall with an apartment building. When it come's to details, it is simple since the overall shape is more important. (Not for commercial use). Examples will be attached for the desired outcome. Task Requirement: 1. Create a 3D model for Apartment + Mall (they're together) Only Outside! Zero interior required 2. Create the landscape on (simple, you can add/change components after discussion) 3. Create a simple Render for them. Will be Given 2D floor plans for: 2 Different apartment floors 2 Different Floor's for Mall 1 Top View Plan Ideal Skills: - Experience in a 3D modeling software (Sketchup or 3ds Max) - Experience in rendering modern architectural designs

I'm looking for a talented graphic designer to help me create engaging and entertaining PowerPoint presentations and infographics. Here are the details: - **Task**: Your main responsibility will be to transform my ideas and content into visually appealing presentations and infographics. - **Objective**: These designs should be aimed at entertainin...infographics that are engaging and visually appealing - Ability to work creatively without specific brand guidelines - Good communication skills to understand my needs and ideas, as well as provide suggestions and explanations for your design choices. If you have a creative edge and you're confident in your ability to create stunning, entertaining designs, I'd love to hear from you. Please provide examples of your prev...

...Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scripting using excel Macros Other Functions: • The Quality Engineer IV participates in the development and implementation of procedures for maintaining and or enhancing the integrity of Santander-s system application • Ensuring the existence of development and service standards • Ensuring that requirements are clearly defined and testable ...

...candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS ...

I am in need of a bilingual static responsive website that will be solely one page in length. The site will be designed in both English and French, and should be optimized for basic SEO. Note : have the content ready. website is based on AI and design should ... and should be optimized for basic SEO. Note : have the content ready. website is based on AI and design should be reflecting the same. Key Requirements: - Programming Languages: HTML, CSS, JavaScript - SEO Optimization: Basic SEO optimization is required, please include the best practices for this in your plan. When applying, please include: - Past Work: I would like to see examples of your previous projects, especially those related to single page websites. I am looking forward to your applications.

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

...also crucial. I look forward to reviewing your proposals and past design work. I NEED A PRO GFX EDITOR TO MAKE ME A LOGO/INTRODUCTION FOR MY TWITCH/TIKTOK I NEED A ANIMATION OF A CUBE FORMING TOGETHER LIKE THE 'TRANSFORMERS' FILM IM NEW TO STREAMING SO I NEED A INTRO/OUTRO/ LOGO ETC ALL THAT GOOD STUFF BUT IM NOT OVERPAYING!HAS TO BE APPEALING TO GAMING AUDIENCE AND GENERAL PUBLIC SOME EXAMPLES... THE CHANNEL NAME IS CALLED FLUKEY so the animation needs to evolve around the word 'fluke' so maybe a rolling dice cube style?...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

More details: What is the intended purpose of the device? Power automation What specific functions or tasks should the device be able to automate? power grid line control Do you have any specific requirements or features in mind for the power grid line control functionality? Real-time monitoring, Remote control. Develop a hardware prototype for detecting illegal electrical current tapping and automatically shutting off power to prevent hazards.

I need an experienced WordPress developer to build a real estate website similar to www.squareyards.com. It must have a clean, minimalist design. Key features to include: - Property search functionality - MLS integration - Mortgage calculator functionality - Property listing Page - Project page - Blog section Ideal candida...Property listing Page - Project page - Blog section Ideal candidates should have previous experience in real estate website development, strong knowledge of WordPress and the ability to adhere to design guidelines. Proven experience working with MLS and mortgage calculator integrations is a must. A keen familiarity with clean and minimalist web design principles is also preferred. Please include examples of similarly complex websites you've worked on in...

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

...requirements are as follows: - The color scheme should predominantly be a mix of deep blue and black, with the option of using midnight blue as well. - The art deco style should be based on geometric shapes, symmetry, and abstract motifs. Please ensure that the design is sophisticated and not cartoonish or childish. - The font used in the logo should be simple and elegant. I have attached several examples of logos that I find visually appealing in this regard for reference. need to be in also in pdf, vector. Ideal Skills for this project: - Experience in designing art deco style logos - Proficiency in using a color palette of deep blue, black, and midnight blue - Ability to create a design that is both sophisticated and visually appealing - Strong typography skills for creating...

I'm looking for a skilled developer to create a comprehensive, easy-to-use ERP software tailored to the gold and diamond jewellery industry. This system will be integrated with e-commerce and feature several additional modules. Key features required: - Inventory Management: The system should efficiently track our jewellery stock levels. - Sal...to customers. - Mobile Application: Developing a mobile application for store management and billing. The ideal candidate should have experience in: - ERP system development. - E-commerce software development. - Creating mobile applications. - Working with CRM, Credit, and Finance Management systems. - Integrating WhatsApp features into applications. - Developing POS software. Please provide examples of previous similar projects you ...

I'm needing help with a GSAP animation project where a single element is not rotating as intended. Key Points: - Issue Description: The current animation is not rotating the designated element. It's likely a bug or misalignment in the code causing the rotation to fail. - Expertise Needed: You should have a strong understanding of GSAP and prior...identifying the root cause of the rotation issue. - Implementing the necessary fixes to ensure the element rotates smoothly and correctly. - Conducting thorough testing to guarantee the animation works as expected across different devices and browsers. Looking for a professional who can swiftly address this problem and deliver a polished, fully functioning GSAP animation. Please include relevant examples of your previous GSAP wo...

I'm looking for a developer to create a simple starter trading script. This is can be based on another script and does not need to be written from scratch. Develop a simple script that buys a particular cryptocurrency when it drops...don't want the script to run on a server like AWS that I'd have to manage and continually monitor for uptime, etc. The script should allow for easy parameter adjustments. Considerations for adding various cryptocurrencies such as Litecoin, Dogecoin, etc. Preferably, the script should be hosted on a cloud platform to alleviate personal management responsibilities. How to Apply: Please provide examples of previous cryptocurrency trading scripts you've developed, along with your approach to meeting the outlined requirements. Lookin...

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I'm seeking a Shopify expert who can help me create a remarkable online store that will feature electronics and home decor products. My target audience includes young adults, parents, and tech enthusiasts. To make the shopping experience top-notch, I'd like the following feat...choices. - Wishlist: It would be great if customers could add products to a wishlist for future purchase or for sharing with friends and family. - Customer Reviews: Creating a space for honest product reviews from my shoppers will be key to building trust and driving sales. The ideal candidate should have proven experience in designing and developing successful Shopify stores and be able to provide examples of previous work. A good understanding of e-commerce, user experience, and SEO will be cruci...

I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: - Refactoring and enhancing the UI of my Android app - Improving the layout and design, including color scheme and branding, typography and font styles, iconography and visual elements - Ensuring a smooth navi...Enhancing user interaction and feedback Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of previous...

I am looking for an experienced Android developer to help with a couple of key issues in my app. The primary focus should be on UI improvements. Key Tasks: - Refactoring and enhancing the UI of my Android app - Improving the layout and design, including color scheme and branding, typography and font styles, iconography and visual elements - Ensuring a smooth navi...Enhancing user interaction and feedback Other requirements: - The app's token refresh mechanism must be revised and optimized - You should be able to ignore battery optimization permission I would ideally like a freelancer who is experienced with Java, Android Studio and UI/UX principles. Experience with token refresh mechanisms and battery optimization is also highly desirable. Please provide examples of previous...

I need an expert windows application developer who can do automation

Project Description: We are seeking a highly skilled High-Performance Computing (HPC) Engineer with expertise in shell scripting and workflow automation to assist in the evaluation and enhancement of the Parallel Works platform. The successful candidate will need to execute various tasks involving cloud cluster management, running pre-installed workflows, and handling both basic and advanced system integrations. Experience with MPI (Message Passing Interface), Singularity containers, and batch scripting is crucial.

I have a series of technical books written in English that I need to have translated into Arabic and Somali. Ideal Skills and Experience: - Proficiency in English and both Arabic and Somali languages - Proven experience in translating technical content - Strong understanding of technical terminology - Attention to detail and accuracy...books written in English that I need to have translated into Arabic and Somali. Ideal Skills and Experience: - Proficiency in English and both Arabic and Somali languages - Proven experience in translating technical content - Strong understanding of technical terminology - Attention to detail and accuracy in translation - Previous experience with book translations is a plus Please provide examples of your previous translation work in your...

...and client user interface, with the following functionalities: 1. Recruitment and Applicant Tracking: Streamline the recruitment process, from job posting to candidate selection, with robust applicant tracking capabilities. 2. Employee Onboarding and Offboarding: Simplify the onboarding and offboarding processes for new and departing employees, ensuring a seamless transition. 3. LLM-Based AI Automation System: Develop an AI-powered system to schedule and conduct initial screening phone calls and first-round interviews with candidates. The system should generate comprehensive reports based on the conversation. 4. Payroll and Accounting Tool: Integrate a payroll and accounting tool to automate payroll processing and manage financial transactions efficiently. 5. Performance Manageme...

Project Description: We are seeking a highly skilled High-Performance Computing (HPC) Engineer with expertise in shell scripting and workflow automation to assist in the evaluation and enhancement of the Parallel Works platform. The successful candidate will need to execute various tasks involving cloud cluster management, running pre-installed workflows, and handling both basic and advanced system integrations. Experience with MPI (Message Passing Interface), Singularity containers, and batch scripting is crucial.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

...quick to design in Canva or photoshop. Canva is a must though as this is where we keep all of our designs. Please take a look at our site We use printify to upload designs, please look we have bags, tumblers, blankets, wallets and we stay within those categoies with new designs... the summer is coming for the USA so we can do a Faith Beach collection. Please see some examples of bags below. Pay attention to colors, these colors sell, dont be afraid to use the exact colors from the images. Pay attention to the fonts as well, use the fonts you see in the images, also use the silly phrases if you see one... for example "Beach Bum" If we are doing a christian collection and are doing a product giveaway for a beach collection you may want to use "Bible & Beac...

I'm a business owner in need of a professional with proven experience in managing Google AdWords campaigns, particularly those aimed at generating leads. My business specializes in dry vent air duct cleaning services, and I have a website already set up. Key objectives and requirements: - Your main goal will be to significantly boost the...campaigns. - An understanding of the preferences and behaviors of homeowners, and how to tailor ad campaigns to appeal to them. - Experience in local SEO and targeting, as well as a clear understanding of how to efficiently manage a campaign focused on a specific geographical area. I am looking for an individual or agency who can deliver measurable results in terms of lead generation. Please provide examples of similar work you have done in...

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...