Excel formula 12month rolling returnprá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í.

datae

datae

mise en forme

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

Napraviti Excel VBA program

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 need an Excel-based dashboard to monitor a maximum of seven items across 17 construction contractor packages. Key Data Points: - Budget and expenses - Change orders - Weekly progress reports per contractor - Resource allocation across all packages - Schedule tracking for each contractor package - Quality control measures and results Ideal Skills and Experience: - Expertise in Excel - Experience with data visualization - Familiarity with construction project tracking The dashboard should be easy to use, visually clear, and capable of tracking the aforementioned data points efficiently. Please use charts and graphs for the visualizations. Please use bar and line charts for the visualizations. Please include data filtering features to allow users to view specific subsets o...

I'm seeking an Excel expert with a solid background in accounting to enhance and redesign my current financial dashboard. Your role will involve improving the dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dashboard Ideal S...

I'm looking for a proficient developer to create a WebAp...output of quotes, invoices, and processing of payments. Key Functions Include: - Form entry for data collection and processing information to output on a dashboard - Basic calculation functions, primarily for freight cost estimation - Integration with Excel to allow for variable data changes - Imitation of a sample WebApp we have, with additional custom features Data to be Processed: - Customer details - Job request details - Vendor details Ideal Skills: - Proficiency in WebApp development - Experience with Odoo integration - Familiarity with Excel for variable data input - Understanding of basic freight cost calculations Please provide feedback based on this description. We can further discuss the details in...

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: - Call logging: The tracker should allow for detailed logging of calls made by representatives. - Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: - Proficiency in Excel and data analytics - Experience with creating tracking systems - Understanding of sales and call metrics

...portal.4. Push Notifications● Use push notifications for important updates, reminders for upcoming bookings,special ofers, and guest check-in/out alerts.5. Automated WhatsApp Messages for Easy Check-In● Objective: Automatically send a WhatsApp message to guests before their arrival,ofering an easy check-in option via a secure link. Guests can upload their details anddocuments ahead of time, and in return, receive a QR code for faster check-in at :● Setup in Admin Panel:○ Admins can customize the WhatsApp message template that will be sent toguests ofering easy check-in. This message can include details like check-intime, a link to upload required documents, and additional instructions ifnecessary.● Automated Message Scheduling:○ The system automatically sends a WhatsApp message

Creazione di file in excel con formule, filtri, query, analisi, tabelle e grafici sulla base delle richieste del cliente. Macro VBA all'occorrenza.

I'm looking for a data consultant to help with consolidating and analyzing a large number of Excel spreadsheets. The project involves: - Data Consolidation: Merging data from different spreadsheets into one cohesive dataset. - Pivot Tables: Utilizing pivot tables to summarize and analyze the data. - Lookups: Using lookup functions to cross-reference and find relevant data points. - Splitting of Files: Organizing and splitting data into manageable files. Ideal Skills: - Advanced Excel skills: Proficient in using Excel functions, formulas, and features. - Data Analysis experience: Previous experience in analyzing large datasets. - Attention to Detail: Ability to spot inconsistencies and errors in the data. - Time Management: Capable of working efficiently to meet ...

I'm seeking an expert in Excel who can assist with automating calculations and report generation in my bonus allocation workbook. The project requires the creation of a couple of bar and line charts, as well as help designing a tier-based system reliant on weighted project amounts determined by various financial metrics. Ideal skills and experience include: - Proficiency in Excel with a strong understanding of automation features - Experience with creating and interpreting bar and line charts - Knowledge of financial metrics and their application in project weighting - Ability to design a tier-based system. - Expertise in data visualization techniques The successful freelancer will help streamline my workbook, making it more efficient and user-friendly. The goal is t...

...(no other symbols needed) ### 2. Backtesting Implementation - Use provided logistic regression model - Test on 5 years of historical data - Basic entry rules: - Enter when model predicts high probability of gap fill - Exit when gap fills or at market close - Track simple P&L ### 3. Performance Metrics Provide CSV report with: - Win/Loss ratio - Average profit per trade - Total return - Number of trades - Maximum drawdown ## Requirements - Experience with: - Python - Interactive Brokers API - Basic backtesting - Must use existing model code (will be provided) - Clean, documented code ## Timeline - 1 week - Daily update on progress ## Deliverables Format - Python code files - CSV file with trade results - summary report quantstats...

I'm seeking a personal assistant to help manage the bookkeeping for my stock trading account. Key responsibilities include: - Monitor trading activity for recording - Record and reconcile all transactions - Prepare trading journal and stock charts screenshoots - Ensure accurate and ti...data entry or bookkeeping, and excellent attention to detail. They should also be proficient with reading stocks price candle charts, having basic knowledge of stock trading (not mandatory), and proficient in using numerous tool for Visual illustration of trading journal, Microsoft office software with English language as these tasks may also be required. Candidates should be proficient in using Excel for financial record-keeping. The assistant will be required to handle bookkeeping tasks d...

I'm looking for a ChatGPT specialist who can integrate this AI tool into Excel for generating reports based on hospital data. The ideal freelancer for this job should have: - Proficiency in Excel and ChatGPT - Skills in AI integration - Report generation expertise Please note that the specifics of the report content have yet to be determined, so flexibility and creativity will be key to this project.

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

Project Overview I am looking for a freelancer to develop a simple flight tracking web application where I can input flight details, view a list of upcoming flights, and receive email notifications for flights scheduled in the next 7 days. Core Features (MVP) Flight Data Entry A form to manually enter flight details, including: Filekey (Unique ID) Airline Name Quantity of Tickets First Flight Date Return Flight Date Departure Airport Arrival Airport Upcoming Flights List Display flights sorted by upcoming departure dates. Filter for flights departing within the next 7 days. Email Notifications Automatic email reminders for flights (e.g., 3 days before departure). Basic email template for notifications. Database for Flight Storage Store flight details in a simple database (MySQL, ...

I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.

I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...

I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency

I'm seeking a product development expert to create an innovative, environmentally-friendly skincare herbal product formula for women in Pakistan. The product should address common skincare concerns and be suitable for the local climate and skin types. Key Responsibilities: - Research and propose unique skincare product ideas. - Conceptualize the product in various forms (e.g. creams, scrubs, serums). - Ensure the product is made from sustainable, herbal ingredients. Ideal Skills: - Extensive knowledge of skincare and herbal ingredients. - Experience in product development and market research. - Understanding of environmental sustainability in product design.

I need a professional photo editor to create a composite image from several photos of two people and their cats. The end result should have all subjects look...two people and their cats. The end result should have all subjects looking at the camera. I will supply the complete set of raw files. The jpegs attached are just a sample. Requirements: - Combine multiple images into a single composite photo with a consistent background across all subjects - Perform medium retouching on the people and cats, including skin smoothing and detailed adjustments - Return the layered Photoshop file Skills and Experience: - Proficient in Adobe Photoshop - Extensive experience with photo manipulation and composite creation - High-level retouching skills - Previous work with pet and family photos...

I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.

I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.

I have 35 pages of handwritten documents that need to be typed in xl. The specific requirements, such as document format and font style, can be budget is $10 if you think this is good for you then you are welcome. Otherwise please do not be on this project.

I'm in need of some assistance with my business tax return. Specifically, I need help with the verification of my business address. - The verification document required is a letter from my accountant. Ideal skills and experience for the job include: - Must be ACCA registered - Expertise in business tax preparation - Familiarity with business address verification processes - Strong communication skills, particularly with accountants

I'm seeking a professional for data entry, specifically focused on numeric data. The data will be sourced from various digital documents and should be entered into either Excel or Google Sheets. Ideal Skills: - Proficient in Excel or Google Sheets - Attention to detail - Experience in data entry, particularly with numeric data - Ability to maintain confidentiality and handle sensitive information responsibly.

I'm seeking an experienced data analyst and Power BI expert to design an engaging and insightful dashboard for tracking both project progress and financial metrics in the construction industry. Key Features: - The dashboard should track project-related metrics such as completion percentage, milestones achieved, and tasks overdue. - Financial metrics shou...percentage, milestones achieved, and tasks overdue. - Financial metrics should include revenue forecasts, expense categorization, and project rating. Ideal Skills: - Proficient in Power BI - Strong background in project management tracking and financial reporting - Experience in the construction industry is a plus - Excellent data visualization skills The dashboard should integrate data from Excel/CSV files. start propos...

I need a data entry/web/Instagram scraping specialist who can help me categorize the 2600 businesses I follow on Instagram. The businesses primarily belong to the fields of architecture, construction, and development, with specific focus on: - Architects - Builders - Developers - Project ...construction, and development, with specific focus on: - Architects - Builders - Developers - Project Managers - Landscape Architects The categorization should include the following fields: - Company Name - Website - State - Profession - Do they follow me back A good command of English is essential for this task, as is the ability to follow clear instructions and input data accurately into an Excel spreadsheet. Experience in data entry, web scraping, and social media analysis would be highly b...

I need a sample CBOT for Ctrader with a written tutorial on how to acquire bullish and bearish divergences data from my RSI indicator. The indicator is already set up, so the job will be primarily focused on programming the CBOT and writing the tutorial. I need it to detect and return last divergence condition only and if better I can choose timeframe on cbot for the indicator Ideal Skills: - Ctrader platform proficiency - CBOT programming experience - Technical writing skills Please provide a sample of your previous work with CBOT and written tutorials if available.

I'm seeking a proficient Excel user for data entry and analysis. Skills and Experience: - Proficient in Excel with experience in using Pivot tables, Formulas and calculations, Charts and graphs - Attention to detail for accurate data entry - Ability to analyze data and generate reports if needed Please note that the specific type of data and primary goal for this project have not been specified. The successful freelancer will need to be flexible and adaptable to different types of data and tasks.

...Art game. The macro needs to control a player and manage various tasks, including mining, fighting spiders, and handling mine collapses. Key Features of the Macro: - Control a player near the screen center - Mine a rock wall with varied inputs - Move to the side and repeat mining - Return to the original position after a few cycles - Handle random events like spiders appearing or mines collapsing - If a spider appears, swap weapons and attack it - If a mine collapses, quickly head to the exit, re-enter and return to original position - Implement dynamic movement patterns to avoid detection from anti-cheat systems/game Admins lurking. Detection Methods: - Use pixel color detection to identify events Additional Requirements: - The macro needs to run in the background, all...

...import Flask, jsonify import app = Flask(__name__) # Database connection db = ( host="localhost", user="root", password="password", database="your_database" ) @("/products", methods=["GET"]) def get_products(): cursor = (dictionary=True) ("SELECT * FROM products") products = () return jsonify(products) if __name__ == "__main__": (debug=True) 3. Display Data on Your Website Use frontend technologies (HTML, CSS, JavaScript) to display the product data. Example: html Copy <div id="products"> <!-- Products will be dynamically loaded here --> </div> <script> fetch("/products") .then(response => ()) ...

I need an annual Profit and Loss statement prepared for an SBA loan application. It will be in Excel format. Key Tasks: - Prepare the P&L statement in Excel - Follow a standard template or best practices, as I don't have a specific template - Cover the statement for the entire year Skills and Experience: - Proficiency in Excel - Experience in preparing Profit and Loss statements - Familiarity with SBA loan requirements - Ability to suggest and implement standard templates or best practices.

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I'm seeking assistance in improving the organization of my Excel sheet which records staff daily work activities. The primary focus will be on refining the data layout for better clarity and accessibility. I need to separate outreach calls vs in-person assistance/community events. I started formula to total based on week and the month. Ideal Skills: - Proficiency in Excel, particularly in data sorting and filtering. - Experience with creating organized data layouts. Although I don't have specific formulas in mind, I would appreciate a professional with knowledge of various Excel functions who can suggest and implement suitable ones to enhance the functionality of the sheet.

...data should include: - Company name and its corresponding LinkedIn page URL - Work email addresses of facility managers and office managers (London-based) - LinkedIn profile URLs of the aforementioned managers - The source link for each piece of data An Excel template will be provided for you to input the data. The ideal freelancer for this project should be: - Detail-oriented and able to follow instructions accurately - Proficient in data collection and research - Familiar with LinkedIn and its functionality - Able to work with Excel Please note, I only require work emails, not personal ones. The companies should be in the legal industry. Budget: Flat rate 5 NZD per 100 companies (100 office managers & 100 facility managers) Time: 2 days Please start your bid...

I'm seeking a Zapier expert to help automate a process involving email tracking and website verification. I receive emails with car VINs (Vehicle Identification Numbers) and need to check their status on our website. Key Tasks: - Read incoming emails on Gmail to extract VINs from plain text - Navigate our custom HTML/CSS website to find the corresponding VIN page - Use Zapier to return the link to the VIN page and its availability status (available or sold) Ideal Skills: - Proficiency in Zapier - Experience with Gmail - Familiarity with navigating custom HTML/CSS websites - Strong problem-solving skills This project will streamline a crucial part of my workflow, so I appreciate your expertise in making this as efficient as possible.

I'm seeking a skilled CGI professional to create a realistic Instagram reel featuring a banner tied to a rolling down to unveil a message on the Sydney Harbour Bridge. The banner will promote an AI service, Sophiie (logo provided), which answers calls on behalf of the user. it will be a video. similar like this I have attached a screenshot. the banner unrolls from the side of building

...URL] --- 11. Fix Footer Buttons in Pop-ups Issue: The "Update" and "Cancel" buttons are difficult to find because they are not fixed. Request: Implement a sticky footer so the buttons remain visible at all times. Page: [Specify the relevant URL] --- 12. Display Loading Spinner After Clicking Update Button Issue: Users are unsure whether the update is processing. Request: Display a rolling spinner when the "Update" button is clicked. Page: [Specify the relevant URL] --- 13. SNS Settings – New Rule Implementation Request: Implement the following rule: If a user selects "I don't use SNS", mark the SNS entry as complete, and award 50 points if other non-SNS fields are completed. If a user selects "I use SN...