Rolling return formula excel vba functionprá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í.
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
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
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ů.
Hello, Your Request I create a simple application that will communicate with the server. Function application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (applications are minimized, but still sends location information) - Shut down button (Applications will be turned off) The application therefore has access to the Internet and GPS. nothing more
I need a program that will notify you when the sound pops authenticate using captcha systems. One of the boot program, which must function at the server
I have a trading tracker built in Google Sheets, originally using the Google Finance function. However, since the Egyptian stock market is not supported by Google Finance, I need a freelancer to help me fetch real-time stock prices and populate them into my Google Spreadsheet. Project Scope: - Data Retrieval: Fetch and update the closing prices of specific stocks that I have already purchased. - Update Frequency: Prices should be updated only when the sheet is open (no need for historical data storage). - Commission Calculation (Future Scope): If this works well, I’d like to add a feature to apply a commission percentage on transactions, which activates only when I sell. The commission should be a separate value and should update the gain/loss accordingly. Technica...
...imported and executed within the ECA module. Requirements The BPMN model should include the following steps: 1. Trigger: The workflow is initiated by a Webform submission. 2. Data Processing: • Generate an automatic product title (e.g., based on form input). • Create an automatically incrementing unique SKU (e.g., SKU0001, SKU0002, etc.). • Calculate the product price based on a predefined formula (formula will be provided). 3. Product & Variation Creation in Drupal Commerce: • The product should be created with the generated SKU, title, and calculated price. • A default product variation should be assigned. 4. Reference Linking: • The created product must include a reference back to the original Webform submission. Technical Re...
...website should have a dedicated section where all reports can be uploaded from the backend via an Excel file. The reports should be searchable and filterable based on industry, category, region, and publication date. ✅ Blog/Insights Section: A space for industry insights and market updates. ✅ User Registration & Subscription (Optional): If possible, include report previews, login for subscribers, and payment integration for premium content. ✅ SEO Optimization: The site should be search engine optimized for better visibility. ✅ Contact Forms & Lead Generation: Well-structured forms for inquiries and consultation requests. Deliverables: Fully functional responsive website Backend Excel upload feature for reports SEO-friendly structure Post-launch support f...
I'm looking for a professional to assist me with uploading products to my WordPress website. - Quantity: There are between 1-100 products. - Variations: The products come with variations such as size and color. - Images: I have standard-resolution images ready for these products. Ideal candidates ...for a professional to assist me with uploading products to my WordPress website. - Quantity: There are between 1-100 products. - Variations: The products come with variations such as size and color. - Images: I have standard-resolution images ready for these products. Ideal candidates for this project should have: - Proven experience with WordPress product uploads. - Proficiency in handling Excel files. - Familiarity with product variations. - Attention to detail to ensure ac...
I need an Excel list containing all the companies attending an upcoming exhibition. The list should include the following details for each company: - Company Name - Booth Number - Contact Information (whatever is available, website should be enough) - Company Description (in a brief summary) - Country Ideal candidates for this project should be familiar with data collection and Excel. Attention to detail is crucial, as the information needs to be accurate and well-organized. Experience with similar tasks is a plus.
...providing them access to electronic PCB circuits data, chat-based technical support, and a library of pre-recorded training videos. Key Features: - Primary focus on Community Forum-style chat support: The app should incorporate a community forum-style chat feature where users can discuss, troubleshoot, and learn together. This is a critical aspect of the app. - User profiles and messaging: The chat function should allow for user identities through profiles and facilitate one-on-one communication via messaging. - Threaded discussions: The chat should be able to support threaded discussions, allowing users to follow conversations more easily. Ideal Skills: - Experience in app development, particularly with chat functionality. - Understanding of user interface design for communi...
I'm looking to create a workflow on that automates a TikTok search based on a keyword I enter into Slack. The goal is to identify the top 100 profiles based on follower count. Key Requirements: - The automation should trigger a TikTok search when I add a keyword in Slack. - It should return detailed information on the top 100 profiles, including: - Profile name - Follower count - Content category - Total Likes - Bio - Profile URL - The retrieved data should be formatted neatly in Google Sheets or airtable Ideal Skills: - Proficiency in - Experience with Slack and TikTok integrations - Ability to format and organize data in Google Sheets - Understanding of social media metrics and profile analysis Note: A keen interest in social media and its various content
I need assistance in converting a multi-tab Excel file into a detailed table for record-keeping purposes. The data should be organized in the table by category. Key details: - The table should only contain raw data, with no specific calculations or summaries needed. - The ideal freelancer for this project should have strong Excel skills and experience in data organization.
I need 40 thousand companies name and Email. This should be only from list of region i provide and the companies should be manufacturer. This is on urgent basis The data should be provided in an Excel file format. Focus on manufacturers in the Technology industry. The data should be delivered within 2 days. Please include the following details: Email and company name. No Please include the following additional details for each company: None. The data should be collected from: any site. Ensure all email addresses are verified for authenticity and validity. None. Please ensure the emails are specific to the Manufacturing department.. # PROVIDE ME SAMPLE OF 3000 FIRST PLEASE PROVIDE ME SAMPLE OF 2000 first of this particular data this is urgent project.
K zobrazení podrobností se zaregistrujte nebo přihlaste.
...skills for various projects. Translation: Professional translation services for documents and content. Medical Writing: Assistance with healthcare-related content and research. Data Entry: Accurate and efficient data management. Diet & Public Health Research: Creating reports and articles related to diet and health. PowerPoint Presentations: Creating professional and engaging presentations. Excel Work: Data analysis, charts, and spreadsheet management. Requirements: Strong attention to detail. Relevant experience in any of the above-mentioned fields. Ability to meet deadlines. Deliverables: High-quality, error-free work. Submission within the agreed timeline. Budget: Flexible, depending on the project scope and quality. These projects are long-term, requirin...
I need someone to analyze my order data. I have it in an Excel/CSV file and it contains data for up to six months. Specifically, I want to know: - How many orders were placed on each weekday (Monday, Tuesday, Wednesday, Thursday and Friday) in February and March, and so on for the following months. The final analysis should be provided to me in another Excel/CSV file. Ideal skills for this job include: - Proficiency in data analysis, particularly using Excel - Understanding of order data and e-commerce metrics - Experience in creating clear, concise data reports. Please make sure that your Excel skills are top-notch, as this is the format I want to receive the final results in.
Auto bids will be ignored and reported. If you are bidding on this project, give a brief plan on how you will make it work and what you need from us. Setup a tesla fleet API server which can 1. listen to live fleet data and write this data to a db. 2. Send commands back to tesla 3. get and write charging data to a db 4. setup virtual keys 5. create an api for us to call these function via api from other servers Must be done with Golang Preference is to not use dockers
I possess a survey dataset centered on tea consumption and I am seeking a skilled data analyst to assist with its evaluation. The ultimate goal is to gain insights that will enhance the data-driven nature of an article I am crafting base...article I am crafting based on these findings. Key Responsibilities: - Identify correlations between different age groups and their tea consumption habits. - Extract significant insights and trends from the dataset. - Create visual representations (graphs, charts, etc.) to support the article. - Summarize findings in a clear, concise manner. Ideal Skills: - Proficiency in data analysis tools (Excel, Python, R, etc.). - Strong statistical acumen to detect meaningful patterns. - Excellent ability to present findings in a clear and visually appeali...
...should come in an Excel spreadsheet format. Key Components of the Project: - Inventory Report: This should detail our current stock levels, any shortages or surpluses, and projected needs based on current production rates. - Production Metrics: The report should include total units produced, production efficiency, and downtime causes. This will help us pinpoint areas for improvement and better understand our overall productivity. - Provide batch tracking information to trace inventory items through their production stages. - Include inventory turnover rate to assess how effectively inventory is being managed over time. - Include cost analysis regarding holding and ordering inventory to optimize financial efficiency. Ideal skills for this project include: - Proficiency in Ex...
I am looking for someone who can help me acquire over 100,000 mixed signatures (both verified and unverified) for my e-sign petitions. The primary aim of these petitions is to campaign for the return of a beloved radio host to our local station. Key requirements: - Experience in acquiring online signatures from various demographics - Ability to source both verified and unverified signatures - Strong understanding of the political landscape and public sentiment towards media personalities - Excellent communication skills to liaise with potential signatories Your role will be crucial in helping to amplify our cause and generate the necessary support to influence our local radio station. Any location is acceptable for the signatures, so a broad outreach strategy will be beneficial. L...
...endorsements from other users. These endorsements should be easy to give and receive, promoting engagement on the site. - CV Creation: The platform will include a CV builder for job seekers. This feature should be user-friendly and support various formatting options. - Job Posting and Searching: Employers will have the ability to post jobs, while job seekers can search for opportunities. The job search function should include filters to streamline the process. - Subscription Models: Various subscription models will be integrated into the platform. These should offer different levels of access and features. - Chat Functionality: A built-in chat feature will enable communication between users. This should be secure and easy to use. Ideal Skills: - Web Development: Extensive experi...
I need to convert data from XML to Excel. I've got an example XML file that can be used as a reference for the conversion. Ideal Skills: - XML - Excel - Data Conversion - Attention to Detail Please ensure that the conversion is precise and matches the structure of the example XML.
I am looking for a sports analytics expert with MLB betting experience to build an automated predictive model for home run predictions. The model should analyze MLB player & pitcher data and return the best home run picks daily. Scope of Work: ✅ Data Collection (Automated Scraping/API Calls) Pull pitcher and batter data from Gameday Insights, Baseball Reference, RotoWire. Scrape pitcher HR tendencies, batter vs. pitch mix performance, weather conditions. ✅ Feature Engineering & Data Processing Process & weight variables (e.g., HR rate, lineup position, pitcher HR tendencies). Develop a scalable feature selection method. ✅ ML Model Development Build ML algorithm (Logistic Regression, XGBoost, or Random Forest). Tune hyperparameters for highest success rate. ✅ Daily Pr...
I'm looking to have two modern, E-commerce and a portfolio websites designed and developed for Ajinkya Lawns and Innovative Designers & Engineers Association, respectively. Website Goals: - The primary goal of both websites is to function as a comprehensive e-commerce platform where users can browse, shop and interact. Portfolio Website Elements: - The portfolio website needs to showcase our work and credibility. It should include: - Image galleries: These will showcase our past projects and designs. - Client testimonials: A section dedicated to our satisfied clients' feedback. - Detailed service descriptions: Comprehensive descriptions of the services we offer. Design Style: - Both websites should embody a sleek, modern design style. I am interested in a...
I'm an e-commerce seller seeking a proficient Excel specialist who can create formulas and automate processes for my inventory tracking. Key Responsibilities: - Develop Excel formulas and automate processes to enhance efficiency - Create inventory level alerts to prevent stock shortages - Conduct sales tracking and analysis to inform business decisions Skills & Experience: - Advanced Excel skills with a focus on automation - Previous experience in e-commerce inventory management - Proficient in sales tracking and data analysis.
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
...expectations. • Provide timely and well-documented cost breakdowns for bids, proposals, and budget planning. Qualifications & Skills • Experience in material takeoffs and cost estimation in [industry, e.g., construction, manufacturing, engineering]. • Strong understanding of engineering drawings, blueprints, and CAD models. • Proficiency in estimation software (such as Bluebeam, PlanSwift, Excel, or industry-specific tools). • Ability to work with engineers, architects, and project managers to refine estimates. • Strong analytical skills with attention to detail. • Excellent communication and negotiation skills for working with vendors and suppliers. • Ability to manage multiple projects and meet tight deadlines. Preferred Qua...
I am seeking an Excel expert who can create a master Excel file and a child file with limited columns. The key requirement is that both files need to be synchronized, ensuring that any changes made in one file are automatically reflected in the other. Key Tasks: - Create a master Excel file with specified columns (details will be provided) - Create a child Excel file with limited columns - Set up synchronization between the two files - Use IF formula where necessary to ensure smooth functionality Ideal Skills: - Proficient in Microsoft Excel - Experience with IF formula and other Excel functions - Ability to create and manage linked files - Detail-oriented to ensure accurate synchronization The synchronization should be triggered ...
...designed a proof of concept app that has a large potential market. The app connects to a peripheral device via BLE and receives data from the peripheral device The app works perfectly with one peripheral, which i had a freelance developer work on the necessary ble code using the initial ble device i had. Now I'm facing issues when I try and connect a different ble device, which performs the same function and output, however is not relaying data to the app. I need an experienced developer to assist me in diagnosing the issue and modifying the BLE service code accordingly to enable data reception from the new device. I am wanting the app users to be able to receive the data from the same make / model of the ble peripheral device Key Requirements: - Extensive experience ...
I am seeking a skilled WordPress developer to upgrade my existing website. The project involves enhancing the site's design, improving functionality, and ensuring responsiveness across devices. Familiarity with the latest WordPress plugins, firebase, GTM and themes is essential. The ideal candidate should have a keen eye for deta...link to the store visit history page that shows the visitors of a specific store. 3. add graphical elements like a bar chart on the store visit history page to show the first 10 store visits per day. it should be related to the filter. 4. add a category statics page with a date filter and it should have charts like bar, pie and others. 5. detect user city and country from IP. 6. export data as Excel from the store visit history page. my website is c...
Swayze is an exciting new startup that helps restaurants get more customers through Instagram with zero upfront cost. Restaurants offer perks (like free drinks or discounts), and in return, customers promote them on social media. It’s a win-win for restaurants and influencers. We’re currently looking for motivated Sales Representatives to help bring local restaurants onto our platform! This is a commission-based opportunity where you can earn $100 to $300 per acquired restaurant, with no limit on earnings. You’ll be responsible for identifying and approaching restaurant owners/managers, explaining how Swayze can help them grow their business, and closing deals. The job is simple and flexible: - Earn $100-$300 per restaurant you sign up - The more restaurants you...
For openwrt there is the addon travelmate which works very well. There yo...accessed is very simple, there is only one button to then go to the internet. It's free internet, no username, no password. only the button has to be pressed. I just have no idea about HTML etc. The hotspot uses NoDogSplash Captive Portal, which is very simple. The URL on the login button looks like this: (null) What I need: a fully function auto login script Information I have for you: 1. The HTML page downloaded as .zip 2. Example scripts that run on github: 3. Openwrt travelmate info
I'm in need of an Access database designed specifically for reporting and analyzing opera...storage and retrieval while also providing general reporting capabilities. Key requirements include: - Development of custom reports tailored to my operational data needs, specifically Profit and Loss Statements on a per operating unit and collective/all units basis. - Creation of user-friendly dashboards for easy data visualization. - Implementation of automated data import processes involving excel and/or cvs file uploads. Ideal candidates for this project should have: - Extensive experience with Microsoft Access database development. - Strong skills in data analysis and reporting. - Prior experience in designing dashboards and custom reports. - Knowledge of automating data imports i...
Excel Spreadsheet Template Development I'm in need of someone who can create me an Excel Spreadsheet template that's comprehensive and easy-to-use template for managing sales quotas. I need the design to be clear, neat, and extremely user-friendly. This template will be used to track the performance of 8 customers across 2 product lines throughout the year. What I need: - Develop an Excel spreadsheet to manage sales quotas for 8 customers, each with quotas for 2 product lines (Product A and Product B). - Track year-to-date performance revenue and percentages for each customer. - Integrate monthly forecasts, qualified pipeline, and renewals for each customer. - Ensure the spreadsheet is simple to use, allowing for easy addition or removal of customers and da...
I am looking for an expert in Excel/Google Sheets who can assist in creating a comprehensive Talent Acquisition dashboard. The dashboard should track key metrics such as Time to Hire, Candidate Sources, and Cost per Hire. Key Deliverables: - A Talent Acquisition dashboard in Excel/Google Sheets - Templates for monthly reports, including Hiring Summary Reports, Candidate Pipeline Reports, and Diversity and Inclusion Reports - Recommendations on collaborative tools suitable for a start-up function within our organization Ideal Skills & Experience: - Proficient in Excel/Google Sheets with advanced data visualization skills - Experience in Talent Acquisition and understanding of key hiring metrics - Ability to create clear and concise reporting templates - Kn...
I'm seeking a professional to review and optimize the VB code in my Excel file, which has been modified over the past 20 years. The primary goal is to streamline the code for future users. The code has sections that handle macros and automation scripts. These scripts involve data import, formatting, and report generation. Ideal skills and experience for the job: - Proficient in Visual Basic for Applications (VBA) - Extensive experience with Excel - Previous experience in code optimization for performance - Excellent problem-solving skills, particularly with macros and automation scripts - Ability to simplify complex code for future understanding
I'm looking for a Telegram bot that primarily handles user interaction. This bot will provide a safeguarding function, but I haven't specified the exact features yet. The ideal freelancer for this project should possess: - Strong experience in developing interactive Telegram bots. - Proven track record of implementing safeguarding features in bots. - Ability to design and create a bot that can provide customer support, run games or quizzes, or conduct surveys or polls. - Excellent understanding of user moderation, spam filtering, and automated warning systems. Your creativity and problem-solving skills will be key in developing a bot that can effectively interact with users while also ensuring a safe and secure environment. Please include examples of your previous work ...
I need assistance with integrating my Excel spreadsheet with an API and webhooks to fetch customer data from external sources. I am not quite sure which API service to use, so your expertise in identifying the appropriate REST, SOAP, or GraphQL API will be crucial. Key Requirements: - Understand and implement API integration in Excel - Expertise in identifying suitable API services - Experience in working with webhooks - Proficient in Excel I am looking for someone who can automate the process of fetching this data, allowing for a seamless and efficient workflow. Your experience with manipulating Excel for data processing tasks will be a significant advantage for this project. Please provide examples of similar projects you've completed in your bid.
