Excel macro powershellpráce
Potřebovala bych sestavit v Excel nebo v jiném programu algoritmy na manuální zadání nebo načtení přes SD kartu 8mi výstupů z měření na váze Tanita (množství tuku, viscerální tuk, metabolický věk, množství vody, ...) tak, aby se tyto hodnoty převedly do grafické analýzy v podobě grafů, "koláčů" či obrázků zatížení tuku na těle (podobně jak výstup z GMON tanita nebo InBody softwaru). Účel je pro použití pro výstup pro klienty výživového poradce a pro ios systém (MacBook Air). Hledám cenově dostupnou varientu, klidně pro cenovou efektivitu jen v Excelu, ale zajímaly by mě mož...
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
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
I am looking for an expert to help me automate my lead tracking and follow-ups. Currently, I am primarily working with contact information stored in Excel. Key Requirements: - Experience with lead data management - Proficiency in Excel - Skills in automation tools and scripts The ideal freelancer for this project should be able to streamline my lead management process, making it more efficient and less time-consuming. Prior experience with CRM software is a plus, though not a necessity. Your understanding of tracking systems and automation will be crucial for the success of this project.
Recreate pages 3,6,7,8,9,10,11,12,16,18,20,21,33,34,35,36 33,34,35,36 Charts need to be in excel Use new poerpoint template Thanks!
I'm in need of an experienced Google Sheets or Excel developer who can create complex data transformation formulas for my financial models. Key Requirements: - Expertise in creating complex data transformation formulas in Google Sheets or Excel. - Ability to develop comprehensive financial models that include cash flow projections, profit and loss statements, and balance sheets. Ideal Skills: - Proficient in data analysis and automating tasks with scripts. - Deep understanding of financial modeling and statistical analysis. - Excellent problem-solving skills and attention to detail. Please only apply if you have extensive experience in creating complex formulas and financial models.
Traducción de strings de texto al Francés y Holandés. Actualmente el archivo se encuentra con traducciones realizadas al Español, Inglés y Chino. Líneas de texto: 714 Formato: Archivo excel* *Entregar en mismo formato. Deadline: 30/12/2024
I'm looking for a freelancer who can create a detailed, category-wise breakdown of my monthly expenses from my Excel data. Key Requirements: - The report should be organized employee-wise - A clear, concise, and professional presentation of the data Ideal Skills: - Proficiency in Excel and AI - Attention to detail - Ability to present data in a clear and concise manner
I'm seeking assistance in compiling data for my SEO agency's prospecting lists. Requirements: - Gather company names and their respective contact details. - Specifically, I need: Email addresses, First Name, Company name, and Monthly Website Traffic. - Organize the data into an Excel spreadsheet. Ideal skills: - Proficient in data entry. - Familiarity with SEO metrics is a plus. - Excellent attention to detail.
I'm seeking assistance in compiling data for my SEO agency's prospecting lists. Requirements: - Gather company names and their respective contact details. - Specifically, I need: Email addresses, First Name, Company name, and Monthly Website Traffic. - Organize the data into an Excel spreadsheet. Ideal skills: - Proficient in data entry. - Familiarity with SEO metrics is a plus. - Excellent attention to detail.
...numbers it spit out. Those are not correct. I will randomly pick some data and call them to verify the quality of your data collection. 5) No duplicate contact is allowed. Daily update is required. Finding the URL, writing script or using any other form of tools, platform, VPN, are your responsibilities. I will NOT provide anything. 6) Populate the Excel sheet, remove duplicate, clean it up with proper formatting, post link to the populated Excel sheet. Do not send me junk or screen shot. I do not want to see email in phone column or vice versa. Email is the most important field. a) Milestone 1-DFW-USA: From the 22 US Universities, collect 50 professors / Instructors and 700 students (BS, MS, and Ph.D.) contacts from each department or school of i) En...
I'm experiencing various issues with approximately 5 short Microsoft Power Automate flows. These flows primarily handle file processing and management for PDF, Excel, and Word files. Key Requirements: - Troubleshoot and fix various issues with the flows - Ensure accurate and efficient file processing Ideal Skills and Experience: - Expertise in Microsoft Power Automate - Proficient in handling PDF, Excel, and Word files - Strong problem-solving skills to identify and rectify errors in the flows
I require a configurable trigger in MacroDroid to delete all my macros on a specific date and time. Example:- - The macros will be installed on January 1st and need to be deleted on January 3rd onwards. - The deletion should occur whenever a user tries to run or enable a macro, followed by displaying an error message. - The delete date must be changeable. Skills in MacroDroid and understanding of app-triggered automation are crucial for this project.
I have an Excel file containing 7000 client information, and I need assistance in restructuring this data into a more organized format. Key Tasks: - Splitting the complete address field into separate components: Street Address, City, State, and ZIP Code. - Extracting and restructuring additional data fields including Phone numbers, Email addresses, and Customer names. - Ensuring all data is organized and presented in a clear and concise manner within an Excel file. - Ensuring there is no duplicate data Ideal Skills and Experience: - Proficiency in Excel with extensive experience in data manipulation. - Attention to detail to ensure data is accurately split and reorganized. - Strong understanding of data structuring and data management principles.
I am looking for a data entry expert who can help me transfer mixed data from my scanned documents into an Excel spreadsheet. Key responsibilities: - Accurately inputting mixed data (both text and numerical) from scanned documents into an Excel spreadsheet - Ensuring the data is organised and formatted correctly in the spreadsheet Ideal skills and experience: - Proficiency in Excel - Previous experience in data entry - High attention to detail to ensure accuracy - Ability to work with mixed data types - Experience working with scanned documents
I'm seeking a professional who can create a detailed profit and loss spreadsheet for my house rentals. The spreads...be able to project future income, expenses and profits based on past data. - Tracking of specific financial metrics. I want to monitor my net profit margin and cash flow using this spreadsheet. Input data will be manually entered, so the spreadsheet needs to be user-friendly and simple to update. Ideal skills and experience for this job include: - Advanced spreadsheet skills, particularly in Excel or Google Sheets. - Previous experience in creating financial analysis spreadsheets. - Knowledge of real estate income and expense categories. I am looking for a freelancer who can deliver a high-quality, detailed and user-friendly spreadsheet that meets all of the ...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some parts of the sheet.
...50 municipalities (by population) to see if each website has a business directory. c) If a municipality website does have a business directory, scrape/download the business directory for businesses’ contact details. As an example, the City of Mississauga in the province of Ontario has an online directory that lists 14,481 businesses in Mississauga, and allows users to download the list as an Excel file (I have already downloaded info for all of these businesses): Note: some municipality websites don’t have business directories. That’s fine - I just want you to check the top 50 municipality websites and determine which ones do have business directories. So to summarize the
I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant. Key Requirements: - Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1. - The macro should prompt for confirmation before updating Tab 2. - All fields in Tab 1 should be completed before the update. - The macro should not overwrite existing rows in Tab 2. Ideal Skills: - Proficient in VBA programming. - Excellent understanding of Excel macros. - Able to create intuitive and user-friendly macros. This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the ...
Hello I need an experienced WordPress developer who can assist me with importing custom attribute variations into my WP site using the WP All Import plugin. I have a standardized Excel file ready, but I am struggling with mapping the data to the appropriate WP All Import fields. Key Requirements: - Extensive experience with WordPress and WP All Import plugin - Proficiency in mapping Excel data to WP All Import fields - Ability to work under tight deadlines I would like to have this issue resolved as soon as possible, preferably today or tomorrow. Your quick response and expertise will be highly appreciated. I have later more Projects similiar to that. Thank You
...various websites. This task will involve gathering Sec 10q and 10k reports for 80 companies for 12 years Ideal skills for this project: - Proficiency in web scraping tools and software - Experience in gathering financial data - Ability to compile data into a clear and usable format - Attention to detail and strong analytical skills Pull the reports and save them as is in three formats HTML Excel Pdf For example Apache company: I will give the list of companies and the freelancer can get the reports back and mark them on a spread sheet. Please specify the budget you are looking at. I will go with the best skills and best price The work can be done manually or by scripting but need it done in 3 days max or it
I need an excel worksheet created for use below is needs for the project -Current Excel and Useable in 365 - Formulated, Formatted, Automated Use of the Workbook- Project Management Request, Project and Task Tracking , Master Log for ease of viewing all project details Job Posting: Excel Workbook Developer for Project Management & Task Tracking Project Overview: We need an experienced Excel developer to create a workbook for managing projects, tasks, and work orders, with automation features like email notifications and dynamic dashboards. The workbook should be easy to use and compatible with Excel 365 for sharing and collaboration. Key Features: 1. Master Project Template: • A template for setting up new projects, which automatically...
I'm seeking a skilled developer for a comprehensive web and app project focusing on real-time stock tracking. The platform should offer: - Live price updates - Customizable watchlists - Stock alerts and notifications - An array of advanced features I...accounts Ideal candidates should have considerable experience in financial app development and a keen understanding of stock market dynamics. Two-factor authentication is preferred for user authentication. The app needs to support iOS, Android, and Web. Skills & Experience Required: - Extensive Financial App Development - Understanding of Stock Market Dynamics - Proficiency in PHP, Python, MySQL, Excel, Power BI, etc - Software Architecture and Testing Skills - Familiarity with Blockchain and AI - Design and Editing Skil...
I'm looking for someone to research and gather comprehensive information about art schools in Singapore. Do use the excel provided. Ideal skills for this job include: - Strong research skills - Ability to synthesize and present information clearly - Familiarity with the art education sector will be a plus
...sponsorships, or affiliate marketing. 3. E-commerce: Create and sell handmade or curated products on Etsy or Shopify. Drop-ship products using platforms like AliExpress. 4. Online Tutoring: Offer to teach a subject or skill (e.g., language, coding, cooking). Use platforms like Preply or Teachable. --- Phase 3: Financial Management 1. Track Income & Expenses: Use simple tools like Excel or apps like Mint to manage finances. 2. Reinvest Earnings: Allocate a portion of your profits to marketing, tools, or expanding services. 3. Savings & Growth: Start saving for future investments, such as opening a small business. --- Expected Outcomes 1. Short-Term: Earn $200-$500 monthly through local services within 1-2 months. Build a small client base...
Sólo necesito configurar un Excel que se me ha desconfigurado una parte. Ofrecerías este servicio a particular?
I've got a drawing for a commercial building and I need an estimate of the concrete quantity and the amount of rebar needed. The estimate should be basic and approximate quantities. Please deliver this in an Excel spreadsheet. Ideal Skills: - Experience in construction quantity surveying - Proficiency in structural analysis - Skilled in using Excel for data presentation
I'm looking for an Excel expert to help me prepare a monthly work schedule for my employees. Key Requirements: - Incorporate a 6 workdays, 1 weekend pattern into the schedule, with a custom shift rotation - Include employee names and shift times in the schedule - Potentially include holidays, workdays, weekends and days off Ideal Skills: - Proficient in Microsoft Excel - Previous experience in creating work schedules - Ability to understand and implement custom work patterns - Attention to detail
...Specialists for Middle Eastern Clients Project Description: We are a digital agency searching for experienced and creative Social Media Marketing (SMM) specialists to manage and grow our clients’ presence across various platforms. Our clients are primarily small and medium-sized businesses targeting Middle Eastern markets, requiring multilingual content in Arabic and English. The ideal partner will excel in crafting culturally relevant, engaging strategies tailored to the region, managing campaigns from ideation to reporting, and driving measurable results. Project Scope: Key Responsibilities: 1. Social Media Strategy Development: • Research target audiences and develop tailored social media strategies. • Identify the most effective platforms for the clie...
I'm in need of an Excel expert who can help me set up a formula for tracking my income. Ideal skills and experience for the job: - Proficiency in Excel, particularly with creating and customizing formulas - Experience in financial calculations - Prior experience in income tracking setup preferred The project involves setting up a formula in an Excel spreadsheet that can assist with financial calculations related to income monitoring. Please bid if you have the required expertise and experience.
I'm looking for an Excel expert to help me prepare a monthly work schedule for my employees. Key Requirements: - Incorporate a 6 workdays, 1 weekend pattern into the schedule, with a custom shift rotation - Include employee names and shift times in the schedule - Potentially include holidays, workdays, weekends and days off Ideal Skills: - Proficient in Microsoft Excel - Previous experience in creating work schedules - Ability to understand and implement custom work patterns - Attention to detail
I'm looking for a proficient data extractor who can download all questions and responses from a website. The link will be provided in chat for safety. Requirements: - Download all data without any filters - Format the data into an Excel file - Provide the completed Excel file via a cloud storage link (e.g., Google Drive) Ideal Skills: - Experience with data scraping and Excel - Familiarity with cloud storage services - Attention to detail to ensure all data is accurately captured and formatted.
...Title: Seeking Creative and Multilingual CMS-Based Website Development Providers Project Description: We are a digital agency looking for highly creative and reliable outsourcing partners to handle small, standard website projects. These websites will be built using a CMS (e.g., WordPress) and cater to multilingual audiences, primarily targeting Middle Eastern markets. The ideal provider should excel in front-end development (HTML, CSS, JavaScript) and CMS customization, while ensuring that websites are visually engaging, user-friendly, and culturally adapted for Arabic (RTL) and English (LTR). Project Scope: Typical Website Structure: Our projects typically include the following pages: 1. Home Page: Creative, visually appealing, and engaging. 2. About Us: Highlighting t...
Looking for a full sta...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (no paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Recourses : Website is using wordpress . Microsoft suite , hosting . Send me the Vidoe , steps and method you ...
I require an expert in Google Sheets or Excel to assist me with complex formulas and functions, specifically for advanced financial modeling with financial data. Ideal Skills and Experience: - Proficient with Google Sheets and Excel - Expertise in complex formulas and functions - Experience in advanced financial modeling - Familiar with handling financial data
I'm seeking a freelancer to provide 2000 verified email leads from restaurants across the USA. The leads should be top-level contacts, one per restaurant. Your work should be delivered in an Excel spreadsheet. Ideal candidates for this project will be skilled in data sourcing, lead generation, and Excel. Previous experience in the restaurant industry or with B2B lead generation is a plus. Please note: All leads must be verified and legitimate. Quality over quantity is key.
We are seeking a freelancer to develop an interactive Power BI dashboard that will serve as a Progress Report and Overall Status Report for quarry and crusher operations. The primary objective is to create a dashboard that seamlessly integrates with Excel as the data source and automatically updates daily to provide real-time insights. The freelancer will need to set up a system where data entries in Excel synchronize directly with Power BI without manual intervention, ensuring accuracy and efficiency. The dashboard must include sections to represent data for two distinct product categories: Aggregate Production and Rock Production. For each product, the dashboard should display three key metrics: For The Day (FTD), For The Month (FTM), and cumulative values up to a select...
...highly proficient in Excel and has a solid understanding of basic math. The project involves organizing a set of simple numerical data according to various metrics. I have provided a sample dataset along with a detailed list of requirements for this task. While the work is straightforward for someone experienced in Excel and able to follow directions, attention to detail is essential. If this initial project is completed successfully, I have several additional datasets that will require similar organization. One of the key requirements is that the Excel file must be dynamically formulated. Any edits or additions to the data should automatically update the corresponding metrics and visualizations across various tabs. I have already created the foundation for the ...
I'm in need of an Excel expert who can create a formula for me to match multiple criteria across several sheets in a workbook. The criteria involve both text and numerical values. Key requirements for the task: - The formula should be able to match text values and numerical values - The formula should retrieve specific data based on the matched criteria - The data retrieval should be from multiple sheets in the same workbook Ideal skills for this project: - Proficiency in Excel - Experience with formula creation - Understanding of data retrieval techniques in Excel
...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...