Useful excel macro automation people työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
Looking for an innovative thinker to solve the challenge of automatically filling a single-page form on a local host, where .exe files cannot be run. The databas...files cannot be run. The database to work with can be either online or local (not the local host of the form), and the database type may vary (MySQL, SQLite, PostgreSQL, etc). Key Responsibilities: - Conceptualize and suggest potential solutions for the auto-fill issue - Design and implement a solution that does not require .exe or batch files Ideal Skills & Experience: - Expertise in form automation - Understanding of various database types - Experience with local and online database handling - Problem-solving and innovative thinking capabilities are crucial. Write strawberry in your response so I know you ...
I'm urgently seeking experienced assistance with Juro document implementation. Key tasks include: - Contract generation - Document automation - Electronic signatures The specific help I require entails all aspects of Juro document handling -- document creation, template customization, and careful editing/review. The ideal freelancer would be someone who has in-depth knowledge and hands-on experience of Juro's formatting and structures. Strong proficiency in contract law and document automation is greatly valued. Because of the urgent nature of this project, I'd prefer a freelancer who can start immediately and push for quick, but quality, completion. Efficiency, timeliness, and attention to detail will be key for this project.
I am looking for a skilled Python programmer to assist with various tasks. Experience with data analysis and visualization, web scraping and automation, as well as Python application development would be preferred. The purpose of this project is not specified, so a versatile skill set is required. Proficiency in Python, Django, and Flask would be advantageous.
...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...
I'm looking for a skilled CRM developer who can make some strategic adjustments to our CRM system. The goal is to enhance the platform with new features, optimize existing ones, and refine the user interface. Key Tasks: - Add new features: The new functionalities we're looking to introduce revolve around advanced reporting and analytics, and task automation. - Improve existing features: Your expertise in CRM development will be pivotal in refining the current features to make them more efficient and user-friendly. - Customization of user interface: A customized user interface is essential for a better user experience. The ideal candidate should have: - Proven experience in CRM development - Proficiency in integrating third-party software - Strong background in creating v...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...
I'm looking for a video editor to collaborate on a YouTube series, where we would conduct weekly interviews with everyday people. Each week, we uncover the unique stories and experiences of different individuals, bringing their perspectives into the public eye and bring 3,4,5 or 6 3 minute interviews together into one show called HOT LINE. The show is filmed like a chat show one interviewer interviewing someone for 3/6 mins, then the next, next interview. The interviewer will have a research assistant that has control of a giant tv screen behing the interview. The research assistant will take calls from people, pop up zoom meetings, show social media feeds and pop up relevent content about the interview to make the interview exciting and sticky and interactive. I have...
I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...
I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.
Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus
I'm looking for an experienced photo editor who can create a composite photo with a casual/business style, featuring...for an experienced photo editor who can create a composite photo with a casual/business style, featuring a background that gives the impression of an office environment or a photo backdrop. Requirements: - The photo should have a casual/business style to it. - The background should evoke an office environment or a photo-like backdrop. - The composite photo should seamlessly blend 20 additional people into the scene. Ideal Skills and Experience: - Proficiency in photo editing and compositing. - Ability to blend subjects into a background realistically. - Experience working on casual style photos. Would like a quote and turn around time. Would also like to see...
I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.
...the configuration works perfectly on a Windows environment but throws an error when we move it to the AWS pipeline. This issue is restricting our ability to run tests efficiently and impacting our CI/CD process. Key requirements: - Configure Serenity setup for an AWS pipeline - Troubleshoot and resolve the error that's disrupting the pipeline - Ensure the solution is robust and will enable the automation of our web application testing Ideal skills and experience: - Proficient in setting up Serenity for AWS and CI/CD - Strong troubleshooting skills - Experience in web application testing - AWS pipeline configuration expertise would be a big plus. We have a testing issue with configuration. its runs well on windows, but when move to AWS pipeline we have the next error. ne...
I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...
I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web brows...through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are you the ...
I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skill...sent to the relevant address based on the campaign. • I have a list of ASM email addresses from a Company. I'd like to trigger emails to each of the ASMs on the list. (Campaign wise)" 8. Download Reports: • Include Camp Details Entry Date: This option focuses on the purpose of having the date - to track when the camp details were entered. • To select Date Range • To Select HQ Wise ...
I'm in need of a proficient Smartsheet expert to assist me in recommending and developing multiple program and project plans. I want to work with expert on a shared screen to help me to learn as we go. I need someone fluent in English - I have a little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the ...
*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. - Visu...
I'm in need of an experienced sales agent who will work as a representative for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with indiv...for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with individual clients - Providing expert advice on travel solutions You're a great fit if you: - From Taiwan - Have prior experience in sales, especially in the field of consulting - Understand the travel solutions market - Excel at building customer relationships over diverse clientele. I look forward to boosting my travel consultancy service s...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
...should demonstrate a history of creating videos for properties that are engaging and informative. - Ability to showcase property features: You should be able to highlight the best aspects of a property and create engaging content that will appeal to potential buyers. - Understanding of neighborhood information: You must be able to provide information about the surrounding neighborhood that will be useful to homebuyers. - Knowledge of video editing: A good understanding of video editing software is important for creating a polished final product. - Understands the target audience: You should be able to create videos that will appeal to homebuyers specifically. This means understanding what they look for in a real estate video and tailoring the content to meet their needs. Please...
I am looking for an experienced Scala developer to implement a specific functionality in a data processing environment. The aim is to process text data more efficiently. Key Requirements: - Deep knowledge of Scala and spark - Proven experience in data processing, notably with excel, json and text data - Ability to deliver clean and efficient code The ideal candidate should be able to show previous projects where they successfully implemented or improved similar functionalities.
I'm looking to revamp my current Shopify store to create a better user experience and enhance its branding. The ideal candidate should have: - Experience in Shopify store redesign - A strong design portfolio demonstrating pre...experience and conversion rate optimization - Knowledge of e-commerce branding Skills required: - Shopify store design - E-commerce brand development - User experience design - Conversion rate optimization. 1. Upgrading to a premium theme. 2. Incorporate sales-boosting apps. 3. Optimize for Google search. 4. Analyze competitors. 5. Eye catchy banner and Call To Action (CTA) 5. Implement email automation. 6. Choose high-converting & best selling products. 7. Make it desktop and mobile responsive. 8. Optimize product listings. 9. Craft compellin...
I need an expert to conduct a color analysis on an apparel website. Your task involves studying product images and employing Adobe Illustrator's eye dropper tool to identify the hexcodes for each. Main objectives include: - Identifying hexcodes for main colors using Adobe Illustrator - Organizing the hexcodes by clothing type - Completing the provided Excel Sheet Your role is critical as the information will be utilized in color trend analysis for apparel. Therefore, a proven background in graphic design, color profiling, knowledge of Adobe Illustrator and an eye for fashion would be ideal. My budget for this project is 100 USD. Please, proficient users of the English language only for accurate communication.
...an online system to replace the use of Excel sheets for data storage and calculations. The system will need to have: - Data Entry and Storage: It should be able to handle both numerical and textual data effectively and efficiently. - Automated Calculations: The system should be designed to automatically handle basic calculations such as summations and subtractions. To ensure the system is user-friendly and can handle our basic data management needs, you must have a solid understanding of relational databases and be proficient in web application development. Experience in designing systems with automated calculations is a big plus. A keen eye for user experience and the ability to follow design guidelines is also appreciated. We have an example excel sheet that can be s...
...inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software operates smoothly in real-world scenarios. Key Features and Requirements: - Streamlining Inventory Tracking: Automatic updati...
I am looking for an experienced freelancer capable of creating a simple web scraping tool, able to extract text content, images, and links from a specific url (you just need to do one single url and I take it from there). The extracted information should be in a python dictionary and saved to pkl Skills: - Experience in web scraping - Proficient in handling js and automation This is a very simple project for the right individual. I need all the visible info and images (no maps) plus the info in the JS that must be reached by clicking a button. This is a couple of hours of work max, and needs to be done in Python and for today. I will provide the URL when I make sure you can handle the job. Thanks
Hola .Necesitaria extraer un excell y que se me guardara en una carpeta todos los días . El excell se encuentra en un programa llamado Mulsesoft
...client profiles Creating and managing client and user profiles, including assigning users to clients or groups In essence, the app should allow for the creation of client profiles with customizable fields. JSON data received from devices in alarm states should be stored in Firebase, linked to client profiles via device ID, and trigger alarm notifications on the user's app until acknowledged. To excel in this project, you should possess: Strong proficiency in Firebase and Flutterflow, along with cloud functions Previous experience in building intuitive and responsive mobile applications Attention to detail, particularly in implementing a reliable alarm system Effective communication skills to understand and execute project requirements Note that user registration and authen...
I require a professional web scraper to collect both text (data points) and images from a long list of web pages about hotels and destinations. - The project involves saving the actual images of ...long list of web pages about hotels and destinations. - The project involves saving the actual images of destinations/hotels —not just their URLs—from every webpage. - As for the text content, I'm particularly interested in several points - The extracted data and saved images should be meticulously organized in an Excel sheet for easy review and reference. Ideally, I'm seeking someone with an extensive background in web scraping and data extraction. Being proficient in Excel would be a significant plus. Accuracy, attention to details, and reliability are...
...fixed duties with fixed employees…this helps the manager to enter the data quickly…. Restaurant duties are different – there will be 4 shifts. And 3 halls. Each hall has maximum number of duties…..waiters need to assigned to those duties….and cleaning boys need to be assigned to cleaning duties…..see the “Floor Staff” sheet in the attached excel file. Summary report for floor staff….with total man hours, ots etc….refer the “Floor Staff” sheet in the attached excel file. Need to send sms to present employees and owner on submitting the duty roster. Note: these are tentative requirements as we discuss and develop we get good shape. Ideal Skills and Experience: - Proven experience in web develop...
I need a sophisticated Excel spreadsheet designed and developed for tracking key performance aspects of my dumper truck and excavator rental company. The spreadsheet needs to be well-organized, easy to navigate, and detail-oriented, focusing on the following elements: - Expenses: Detailed tracking of an array of expenses. The ability to enter itemized costs is a must, and other daily expenses (office, car fuel..). Also monthly expenses like rent, salaries, bonuses and truck or excavator maintenance ect. - Income: This should include a breakdown of different revenue sources. - Employee tracking: A system to input and manage each employee's work hours. - Machine rental: Documentation of the equipment rented, including the duration of rental. - Fuel consumption: Dedicated sectio...
MY DESCRIPTION We've deployed a robust business process management microservice application and are having problems with crashing pods. Need an expert to review our implementation/deployment/architecture and recommend solutions to remediate this issue and prevent it from...needs: Identifying root causes of POD failure, was it caused by the code, kubernetes resources limits, nodes architecture, etc. Monitoring POD resources, capturing Memory/CPU usage and analyzing usage patterns, deciding the best resource allocations. Sizing nodes based on IPAS usage patterns. Analyze network issues between different PODs and in/to external integrations. IPAS is our Process Automation Suite. It's used by quite a few clients, but this client in particular has massive volumes and its havi...
I'm looking for a freelancer who can build a dynamic Excel line chart that tracks and compares the performance of two teams over time. - **Metrics:** The chart should reflect team scores. - **Updates:** I need the chart updated within a 10-hour timeframe, to capture the latest performance data. Ideal Skills: - Proficiency in Excel and creating dynamic charts. - Understanding of data visualization and performance tracking. - Ability to automate data updates for real-time reporting.
I'm looking for a skilled Excel expert who can help me create a comprehensive food costing spreadsheet. In particular, I would like the following sections: - **Ingredients Cost**: where I can enter the prices of all the ingredients I use in my recipes. - **Recipe Costing**: a section where I can input my recipes and the spreadsheet automatically calculates the total cost of each recipe based on the ingredients. - **Menu Pricing**: a feature where I can input the recipes from my menu and the spreadsheet automatically calculates a profitable price based on the recipe costs. - Inventory management: - **Track Inventory Levels**: a feature that keeps an eye on my ingredient stock levels. - **Predict Future Inventory Needs**: an analysis that could help me foresee when I&#...
I'm looking to automate the appointment booking process for VFS Global on both web and mobile platforms. The goal is to provide a seamless and efficient solution for scheduling appointments for customers who need to use VFS Global services. Key Requirements: - Compatibility with both web and mobile platforms. - Full automation of the appointment scheduling process. - The system should allow customers to either choose specific time slots or have time slots auto-assigned based on availability. - Reminder system to reduce the occurrence of no-shows. - Efficient management of customer information. Ideal Skills: - Experience in developing and deploying appointment booking systems, particularly for dual web and mobile platforms. - Proficiency in automating system processes. - Stron...
...incorporate in the logo - Let us help you clear your slate. Description of the organization and its target audience: Dusty Slate Consulting is a consulting firm that specializes in, Prototype Development, Secure software concepts. Business process optimizations, Security Analysis, penetration testing, and custom application development. We also specialize in systems integration and robotic process automation. If you have an idea that you cannot get made, we can make it happen. My target audience are companies that have ideas but lack the inventive resources to make the ideas happen, as well as small time inventors that need a leg up in getting a prototype built, or help getting it manufactured. Industry Software Development Software Security Prototype Development Patent Ass...
...Python mentor proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience worki...
...intelligent process automation in the specific sector of Risk Management Framework. Key Requirements: - Prior experience with UiPath development and implementations in a high-risk environment. - Sound understanding of risk management frameworks and their applications. Your main task will be designing and implementing a complex, intelligent process automation system that aligns with high-risk standards. The system should effectively streamline risk management processes, and ensure data security and accuracy in all stages. Skills and Experience Needed: - Proven track record of developing high-risk intelligent process automation. - Extensive experience in the risk management sector, specifically Risk Management Framework. - Proficiency in UiPath development, ensuri...
