Excel macros spreadsheet macroprá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í.
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
I'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.
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)
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 right p...
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...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
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 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...
Para crear un documento de Excel con macros, la persona que lo va a desarrollar necesitará conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y ob...
I need a comprehensive spreadsheet created that will contain the match results and contestant statistics for the Survivor Greece television program episodes that aired in the years 2019, 2021, and 2022. I can provide one source of the episodes but you are free to use any other you like. Key Requirements: - The data should be presented in a tabular format. - The matches results should be included. - the results of the matches should be presented in order for each day. - Contestant statistics such as wins, losses, eliminations, and other relevant information should also be covered. - Please ensure that the data from each year is kept separate. Key Skills & Experience: - Proficiency in data entry and organization, with a keen eye for detail. - Experience with creating spreadshee...
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: De...
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 hel...
...that can convert a Marathi excel sheet to English. The application should have the following features and capabilities: - Upload functionality: Users should be able to upload Marathi excel sheets into the application. - Conversion: The application should accurately convert the Marathi data (including names, addresses, phone numbers, gender) to English without any loss of information. - Download functionality: The application should allow users to download the converted English excel sheet. - Volume handling: The Marathi excel sheets may contain around 2000 records, so the application needs to handle this volume efficiently. Ideal skills and experience for this job would include: - Strong proficiency in PHP and web application development. - Experience with...
...and enhance overall quality. - Video Call Backgrounds: Design custom backgrounds for video calls that reflect our corporate identity. - Word Templates and Project Proposals: Create templates for documents and proposals that are user-friendly and visually aligned with our brand. - PowerPoint Templates: Design templates for presentations that are both professional and creative. - Invoice Templates (Excel): Develop invoice templates that are clear, professional, and include custom fields as per our requirements. - Social Media Profile and Cover Photos: Design attractive profile and cover images for our social media that maintain visual coherence. - Corporate Email Signature Design: Create an email signature that elegantly incorporates our logo and contact details. - Corporate Mug De...
...material is in Excel format and contains over 10,000 words. Ideal Skills and Expertise: - Fluent in both English and German - Proven experience in translation, particularly related to technical or software content - Proficient in working with Excel files Please note that the translation must be accurate and precise to ensure that the technical terms are properly translated. Your familiarity with accounting and POS software terminology is highly desirable. The software is up to 90% translated, we need translator for correction and addition. ......................... Ich suche einen erfahrenen Übersetzer, um einen großen Umfang an Inhalten von Arabisch ins Deutsche zu übersetzen. Die Inhalte beziehen sich auf Buchhaltung und POS-Software. Das Ausgangsmate...
Recopilar información de indicadores de turismo y su disponibilidad en la red. Trabajo de documentación y búsqueda.
I am in need of a ...transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in the Excel spreadsheets. The data you will be working with is primarily text-based as opposed to numerical. Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Please only apply if you are comfortable handling a high volume of pages and can ensure that no data is lost or incorrectly transcribed in the trans...
I'm in need of an experienced data entry specialist to input text-based data from typed documents into an Excel spreadsheet. I have a series of typed documents that need to be transferred into Excel. The data consists entirely of text, with no specific formatting required. It's important that the freelancer pays close attention to detail in order to ensure the accuracy of the data entry. Ideal Skills and Experience: - Proficiency in Microsoft Excel - Strong attention to detail - Previous experience in data entry - Time management skills to meet deadlines - Ability to do research - Fluency in English
they closed it? collect information from a directory for our event, which lists approximately 2590 partners. The information must be obtained from subpages 1. Logo (embedded in excel and folder) 2. Company Name 3. Stand number/code 4. "Why Visit Our Stand" Section 5. Brands 6. Description 7. Company Activity 8. categories 9. Regions 10. Gallery (embedded in excel and folder) 11. Follow us section (social media links) 12. Website 13. Email(s) 14. Company Address 15. Company phone number
We are seeking a skilled Android developer to integrate an Excel import feature into our existing app, "Fuel Injection MSI CRDI Charts" (). Scope of Work: Develop a function to import data from Excel files (.xls or .xlsx) into the app. The import functionality should be similar to the existing "Fuel Injection Price List" section within the app. Ensure data integrity and proper handling of potential errors during import. Implement appropriate user interface elements for file selection and import initiation. Skills Required: Android development expertise (Java/Kotlin) Experience with data parsing and Excel file handling libraries Understanding of user interface design principles for Android Strong problem-solving
I'm in need of a proficient Excel specialist to help me with data analysis and entry. The task involves handling mixed data (both numeric and text) and providing valuable insights from analysis. This is a remote role, so email will be our preferred mode of communication. Ideal Skills and Experience: - Advanced Excel proficiency - Previous experience with data analysis and data entry - Ability to work with mixed data types - Strong analytical skills - Excellent communication through email
I'm in need of a custom bill format in Excel that incorporates my company's logo and branding. The bill should have automated calculations for the ease of use. Key Requirements: - A customized Excel bill format with a professional finish - Integration of the company's logo and branding into the bill - Automation of calculations within the bill Ideal Skills: - Proficiency in Excel, including advanced formula creation - Experience in design, particularly in creating professional, branded documents - Understanding of automated calculations and their implementation within Excel Upon completion, I expect to receive the Excel file with the custom bill template.
I'm looking for a professional who can assist in converting screenshots, which already depict data set in tables, into Excel tables. The purpose of this task is to better analyze the data, which is purely textual in nature. The ideal freelancer for this job would be experienced in data entry, with a particular emphasis on Excel, and have an eye for detail to ensure all data is transferred accurately. There's no requirement for interpretation or analysis, I simply need the information from the images moved into an Excel format. Attached is a sample of the screenshot.
I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This
I need a proficient freelancer to help convert my Excel files, containing both numerical and textual data, into Word documents. The aim of this conversion is to ease the process of creating reports. The data should be precisely formatted into tables in the Word documents for a cleaner presentation. The ideal candidate would require: - Excellent skills in Microsoft Excel and Word. - Proficiency in data conversion and formatting. - Attention to detail to maintain data integrity. - High regard for timeliness and efficiency. Understanding the importance of report creation in business communication, this work must be meticulously done, reflecting professionalism in every converted document.
I'm keen on gathering a customized list of up to 50 nano or micro influencers who are distinguished in the pet food product niche. The preferred influencers are mainly thos...or YouTube. To attract quality bids, freelancers should possess: - Expertise in Social Media and YouTube data gathering. - A strong understanding of the pet products industry. - Ability to identify key influencers in the pet products niche. - Tracking and reporting capabilities. Freelancers with current experience in influencer research will be given priority. The deliverable is a Report (Excel format preferably) that includes: - Full Name of the nano/micro Influencer - Profile Link - Username - Channel Name - Channel Type (IG, FB, YT, etc) - Email (must be current and valid) - Engagement Ratio - So...
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 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 ...
