For loop in excel formuladela

I'm looking for a Python expert who is able to automate the trading process for me. This script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the...

I'm looking for a skilled individual to assist with entering financial data from various Excel spreadsheets into a master spreadsheet. The data will need to be organized chronologically, by date. Key Requirements: - Proficiency in Excel, including experience with formulas and data manipulation. - Previous experience with financial data is preferred. - Attention to detail is crucial to ensure accuracy in data entry. - Ability to meet deadlines and work independently.

I'm looking for an Excel expert to create a simple yet effective budgeting template for me. The template should allow a beginner Excel user to input their actual numbers and see them calculated as percentages of their total budget each month. Key Features: - 6 Categories: Necessities (The Four Walls/The Basics), Giving/Gifts, Savings, Investing, Play/Have Fun, Growth/Education. The target % for each category are: Necessities (50%), and then 10% for each of the other categories. - Conditional Formatting: Some cells will be locked to protect the formulas, while others should allow the user to add rows for expenses not initially included in the spreadsheet. These added rows should automatically factor into the percentage calculat...

...customized Excel sheet system for tracking and managing the expiry dates of Approved Training Organizations (ATOs) and Post Holder certificates. This system will provide automated calculations, reminders, and color-coded notifications to enhance efficiency and ensure timely renewals. Scope of Work: 1. Sheet 1: ATO Expiry Tracker • Structure: The sheet will include three sections: • Pilots • Flight Dispatchers • ATC • Columns: Each section will include the following columns: • ATO Name • Approval Number • Initial Date of Issue • Renewal Date (input field) • Expiry Date (automatically calculated as 5 years from the renewal date) • Features: • Automatic calculation of the expiry date by adding 5 years ...

I'm in need of a senior Machine Learning engineer with significant experience in detecting fraud in banking transaction history files, primarily in Excel format. This project may require some anomaly detection expertise. Ideal Skills: - Proficient in machine learning techniques, with a focus on supervised and unsupervised learning. - Extensive experience in fraud detection within banking transactions. - Strong skills in data analysis and anomaly detection. - Proficient in handling and analyzing data from Excel. - Excellent communication skills for providing insights and updates. The project is flexible, and I'm open to your professional guidance on the best techniques and methods to employ. Please get ...

Seeking a full-time member to join our team. We're a real estate photography agency based in New York. The job will start with a 3-week trial period at 48 hrs/week. If we find during that period that you are a good fit for the role, this could become a long-term position. Our budget for the job is $2/hr USD. Requirements -- Available Mon - Sat, 9am - 7pm NYC time -- Great visual eye -- Attention to detail -- Fluent in English -- Great communication (verbal and written) -- Patience -- Experience with Google Docs, Google Calendar, & Microsoft Excel preferred -- Content writing experience is a plus. -- Newsletter management is a plus. Roles & Responsibilities -- Quality check photos and provide feedback to photo editor. -- Schedule photogr...

I need a professional with deep expertise in SPSS to assist with my data analysis. The specifics of the project will be clarified later, but I am looking for someone who has experience with various types of data (survey, experimental, observational) and is proficient in understanding and manipulating data from different formats (Excel, CSV, SPSS). Key Skills: - Proficient in SPSS - Experience with various data types - Able to work with different data formats - Strong analytical skills - Detail-oriented Please feel free to reach out if you have the necessary skills and experience. You are required to do spss analysis? It’s total 65 data.  When are able to start ? How many hours it’s required? May you specify what to include n not...

I'm in need of a detail-oriented individual who can assist in gathering comprehensive information on the accounting and legal industry in New South Wales, Australia. This includes professionals such as accountants, lawyers, and their respective firms, in addition to private equity firms. Your primary responsibility will be to collect contact details including: - Company name - LinkedIn profile - Email address - Phone number - Website You will be using platforms such as Google, LinkedIn, and industry organisations like the Law Society of New South Wales and Chartered Accountants Australia and New Zealand. Ideal Skills: - Proficiency in online research - Exceptional attention to detail - Prior experience in data collection is a plus Data Fo...

I need assistance with data input. The data is mixed (text and numerical) and currently stored in Excel/CSV files. The expected volume of data entries is between 1,000 to 10,000. Ideal skills and experience for the job: - Proficiency in Excel and CSV files - Attention to detail to ensure accurate data input - Experience with handling mixed data (text and numerical) - Ability to complete tasks within a set timeframe

...SCRIPT to scrape a news website in Traditional Chinese Characters. The script should assist my client by providing daily updates relevant to my client's business. It should scrape the website once a day, extracting headlines and summaries from the articles. Please provide all source code. Ideal Skills and Experience: - Proficiency in Python and web scraping - Familiarity with news websites - Understanding of Traditional Chinese Characters or ability to use google translate to understand the website's source and content. - Experience with data organization in Excel linked in python (recommend Pandas) - Ability to create efficient and reliable scripts on time and on budget. - Ensure you can handle this project BEFORE accepting it. We will have...

I'm looking for a skilled professional to transform my Excel, Word, and PDF tables/documents into interactive, fillable forms. The final product should be user-friendly, secure, and compatible across multiple platforms. Key requirements: - **Multi-Platform Compatibility**: The forms should work on a variety of platforms based on user abilities and available software. Key formats include PDF, Google Forms, Microsoft Word, and Excel. - **User-Friendly Design**: The forms need to be intuitive, ensuring users can confidently interact with them without the risk of accidental deletions or errors. - **Advanced Functionality**: Users should be able to add fields, with the forms incorporating features such as summing and copying fields for reuse in other fo...

I need an expert in optical safety standards to help me determine the maximum safe power for a 940nm laser with a 5mm (configurable) angle of .01degree(configurable) beam diameter, when viewed directly by the eye at distances of 1 cm, 5 cm, and 10 cm(configurable...). The laser operates intermittently, turning on every 200ms for a period of 1ms. During this 1ms period, the laser is modulated at 38kHz with a 30% duty cycle. Give a excel sheet with formula The primary application for this laser is in a consumer product, so it is crucial to ensure that the power specifications are within safe limits for end users. - An understanding of the FDA regulations and IEC 60825-1 is critical, as the product must comply with these safety sta...

I'm looking for a skilled professional to transform my Excel, Word, and PDF tables/documents into interactive, fillable forms. The final product should be user-friendly, secure, and compatible across multiple platforms. Key requirements: - **Multi-Platform Compatibility**: The forms should work on a variety of platforms based on user abilities and available software. Key formats include PDF, Google Forms, Microsoft Word, and Excel. - **User-Friendly Design**: The forms need to be intuitive, ensuring users can confidently interact with them without the risk of accidental deletions or errors. - **Advanced Functionality**: Users should be able to add fields, with the forms incorporating features such as summing and copying fields for reuse in other fo...

I have an Excel spreadsheet containing QR codes that need to be placed on Avery labels. Ideal Skills: - Proficiency in Excel - Familiarity with Avery label templates - Attention to detail to ensure correct placement of QR codes on labels Please, only bid if you have experience with this kind of task and can deliver it in a timely manner.

I have a large text file that cont...mixed data types. The data is structured in fixed-width columns and includes headers and labels to identify the data columns. The task is to extract this data and convert it into several Excel files, sorted by year. given size of file it can not be converted in notepad hence needs someone who can detail with large file size conversion Ideal Skills and Experience: - Proficient in data extraction and Excel - Familiar with handling large datasets - Able to work with mixed data types - Attention to detail to ensure accuracy in data conversion Please convert the data into CSV file format. The data should be organized within the Excel files by creating completely separate files for each year. Pleas...

...WebScrapping to get prices from URLs and save in an Excel. • I need to get 03 kind of prices from these URLs: o o o • The prices are: o Precio Lista (549) o Precio (449) o Tarjeta Oh (429) o Regular (399) o Online (349) o Tarjetas Interbank(335.01) o Normal (1,699) o Internet (1,499) o Tarjeta Ripley (1,399) • I Will send an Excel with information to search and you Will do a WebScrapping to get the products and its prices and print the lower Price. • Only choose this one that have the same as Product Name. • Only Choose the links with the 03 better prices. • Only print, the lower Price in the URL (Example: Tarjeta Ripley) Input Example:

I'm looking for a reliable data entry professional who can help transfer specific Excel data into a SaaS platform. Ideal Skills and Experience: - Proficiency in Excel - Experience with data entry into SaaS platforms - Familiarity with stock managements - Attention to detail and ability to maintain data accuracy

I'm looking for a skilled typographer to create a complete font based on five existing letters from my collection. Key Requirements: - Develop the rest of the alphabet (all caps) based on the style cues from the provided letters: R, O, B, U, K. - The font should be designed for use primarily in all Microsoft apps (Word Excel etc).. Ideal Skills: - Experience in font creation and typography. - Strong understanding of modern and sleek design principles. - Ability to replicate and adapt design cues consistently across a full alphabet. Please provide an .otf file once completed so I can install the font on my computer.

I need a Power Automate routine to automate my workflow. The project involves: - Processing a column of account numbers (numeric data) from Excel. - Executing a series of Chrome keystrokes based on the cell values. (Changing a single setting within the account's profile) - Primarily using the keystrokes for navigation and clicking. - Interacting with a web application.

I need Odoo developer for the implementation purpose. the scope will be to create the product list by importing the data from excel sheet. We are having 3 warehouse and 2 shops and will assistance to setup the operations

I'm looking for someone to convert my line graph images into text data in Excel. The task involves extracting data from multiple series on the graphs. Key Requirements: - Conversion of line graphs into Excel - Extraction of data points for each series - Identification and recording of axis labels and titles Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Experience with data extraction from graphical images

Elaborar un listado de excel con la información suministrada que sea editable para futuras actualizaciones. Creación de plantilla para carga masiva de los productos en MercadoLibre, y apoyo para la carga en su tienda.

I need an experienced professional to help me with my project- Fix Export From PowerApps to Excel. You have to fix the power automate flow to generate a excel file of data

I am seeking a Microsoft Excel professional with strong data analysis and visualization skills who resides in the Eastern Massachusetts area because I would like to sit down in person to explain my project in detail. Key Responsibilities: - Utilize Excel for comprehensive data analysis. - Create sophisticated pivot tables to visualize data. Ideal Skills and Experience: - Advanced proficiency in Microsoft Excel. - Extensive experience in data analysis and visualization. - Proven ability to create and interpret pivot tables.

I require assistance in managing data from a trading bot. The bot sends notifications via a mobile app in JSON format whenever there's liquidity. Tasks: - Each message from the bot needs to be transferred into an Excel file. - Some messages will require data processing and transformation before they can be saved into the Excel file. - The format of the data in the Excel file is provided in the attached image. Ideal Skills: - Experience with data processing, specifically with JSON. - Proficient in Microsoft Excel. - Familiarity with trading bots is a plus. - Able to work with mobile app notifications. I am looking for someone who can help me accumulate and analyze this data in a tabular view for bet...

Melehorias tratadas em relação ao projeto inicial Excel x cnab Banrisul

I am in need of a commercial real estate cash flow financial model for a multi-tenanted office building. The tenants are primarily corporate offices. The project involves creating a 10-year cash flow proforma, including debt service, and IRR using information from an existing rent roll. Skills and experience that would be ideal for this job include: - Expertise in financial modeling, specifically for real estate - Proficiency in Excel or similar software - Experience dealing with commercial property cash flow analysis - Understanding of corporate office lease terms - Ability to interpret and utilize detailed rent roll data The rent roll includes: - Tenant names - Lease start and end dates - Square footage - Annual Rent - Rent PSF Freelan...

...experiencia en telemarketing para vender por teléfono nuestros planes de suscripción muy competitivos. Somos un portal inmobiliario. El trabajo consiste en realizar llamadas masivas para captar nuevos clientes para nuestros planes de suscripción dirigidos a profesionales inmobiliarios y particulares. Lo que ofrecemos: • Centralita con número español para realizar llamadas, WhatsApp, correos. • Excel en la nube con bases de datos actualizadas para facilitar la captación. • Formación inicial y soporte. • Comisiones Altas Condiciones: • De Lunes a Viernes, entre las 9:00 am y las 9:00 pm. Hora España, horarios a convenir, pero con un compromiso diario, Disponibilidad mínima recomendada:...

I'm seeking a programmer with expertise in Microsoft Graph to support our team. We require assistance with troubleshooting, configurations, and other related tasks involving Excel Workbooks and MS Word documents. Key Responsibilities: - Interacting with Excel Workbooks and MS Word documents - Primarily integrating these with SharePoint Ideal Skills: - Proven experience with Microsoft Graph - Proficiency in Excel and Word - SharePoint integration knowledge - Strong troubleshooting abilities - Excellent configuration skills - Experience with REST APIs and how they interact with Microsoft Graph - Familiarity with Azure Active Directory and its integration with Microsoft Graph The project should be completed within immediate. The primary focus will be...

CeSim experience better I've been appointed as the Director of Strategy for Mobile Inc., and I need a comprehensive report of about 3100 words, plus appendices, detailing the strategic direction for the company over the next four years. Key elements of the project: - Using the provided guidelines, the strategy should focus on specific areas of the business. - The strategy should be based solely on the provided data and should adhere to a specific report format. The report will need to include: - An analysis of the areas of market expansion, product development, and cost reduction. - A detailed, data-driven strategy that I can present to the board of directors. - A comprehensive analysis of competitors and their strategies. - A SWOT analysis to identify the company&#...

Planilla excel para llevar control de ventas, despachos, stock

...count system for supervisors. - Online Work Assignment: Allow for the assignment of tasks to supervisors via the platform. - Stock Management: The system should track remaining stock and ready stock details. - Financial Management: Manage payments, bills, and ledger entries. - Customer Interaction: Auto-reminders for customers, alongside daily updates on payments and products. - Admin and Supervisor Access: The system should offer login access for one Admin and three supervisors. - Inventory Alerts: Implement low stock alerts and reorder point notifications. - Payroll Export: Allow export of payroll data in various formats like CSV or Excel. - User Permissions: Define different levels of access and permissions for various user roles. - Ba...

I'm looking for someone who can extract customer information from Excel sheets. The focus here is on accuracy and attention to detail, as the extracted data will be crucial for our upcoming campaigns. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Prior experience in data extraction Please ensure your bid reflects your ability to deliver this project promptly and accurately. Thank you.

I want a dashboard in excel with the analysis of chosen shares. It is a simple job, should not take more than one hour.

My current Excel file is cumbersome and disorganized. I primarily use this file for data analysis, utilizing charts, graphs, formulas, and calculations. The data is spread across multiple sheets, but not in a clear or efficient manner. I'm seeking a professional with extensive experience in Excel, particularly with data analysis. The ideal freelancer should be adept at organizing data, optimizing spreadsheets, and improving file efficiency. The goal is to transform this heavy, unorganized file into a clean, streamlined tool that will facilitate my data analysis tasks.

I'm seeking a detail-oriented freelancer to assist with cleaning and validating my mixed data sets, primarily found in Excel/CSV files. Key Responsibilities: - Cleaning and validating mixed data (text and numerical) - Ensuring data integrity and accuracy - Removing duplicate records to maintain data uniqueness - Identifying and managing missing values appropriately Ideal Skills: - Proficiency in Excel - Strong attention to detail - Experience with data cleaning and validation The data set size is small, consisting of up to 1000 rows.

I'm creating a beginner-friendly Excel 2019 tutorial on macOS and need someone to assist with screen recording basic tasks (like formulas and formatting). The tasks are straightforward and follow a simple script. Ideal skills and experience for the job: - Proficiency in using Excel 2019 on macOS - Experience with screen recording - Ability to follow a script closely - Attention to detail

I'm looking for an experienced VBA programmer to enhance my existing sports web scraper. This tool needs to be updated to collect odds from the correct score market for soccer fixtures on reputable betting websites, specifically William Hill and Ladbrokes. Key Requirements: - Modify the current web scraper to extract specific data from the correct score market. - Capture and distribute odds data into an Excel table. - Enhance web scraper to handle dynamically loaded content on betting websites. - Implement robust error handling and logging mechanisms. Ideal Skills: - Proficiency in VBA for web scraping. - Familiarity with soccer betting markets. - Experience in data distribution to Excel. Please note, the primary focus of this projec...

I'm looking for a data entry specialist to help me input a variety of mixed data (text and numeric) into an Excel spreadsheet. Key Requirements: - Experience with data entry, specifically using Excel. - Ability to accurately input data from manual sources. - Attention to detail to ensure the mixed data is entered correctly. Your role will primarily involve: - Receiving and interpreting mixed data from manual inputs. - Accurately entering this data into a pre-formatted Excel spreadsheet. - Ensuring the final spreadsheet is clear, well-organized, and devoid of errors. - Performing data validation to ensure the accuracy and completeness of entered data. - Identifying and rectifying any inconsistencies or errors in the data entries. - Formatting the s...

I'm in need of three high-level, modern and clean styled Excel templates: a Quotation, an Invoice, and a Receipt. The design needs to be professional and sleek. Details: - The header of each document should include my company logo, the document title, and my contact information. - Each document should also have designated sections for Payment Terms, Notes/Comments, and Terms and Conditions. Ideal skills for this job include: - Proficiency in Excel - Graphic design experience with a focus on clean, modern aesthetics - Understanding of standard business document formats Please ensure these templates are easily editable.

I'm looking for someone with strong Python and MySQL skills who can parse the data from sql query itself to excel file. The project involves: - Extracting data from a MySQL query - Outputting the final data as a .xlsx file - package all the code to a small UI program to run more such files. Ideal candidates have: - Proven experience with Python and MySQL - Ability to parse and manipulate data effectively - Prior experience working with .xlsx files Please include relevant examples of your work with SQL and Python in your proposal. The output should follow a defined template which will be provided. The UI program should have a simple click-to-run interface. The UI program should include a simple file selection interface for uploading and processing file...

...seeking a skilled video editor with proficiency in Adobe Premiere Pro to edit a series of educational lessons filmed on location. The ideal candidate will have a keen eye for detail and a commitment to quality. Responsibilities: Clip Editing: Review the provided footage and trim the beginning and end of each lesson where the subject pauses or the camera is adjusting. Logo Placement: Add the corresponding subject logo to the bottom left corner of each video. Color Grading and Audio: Ensure the color grading is consistent and visually appealing, and that the audio is clear and free of distractions. File Management: Download the raw footage from Google Drive (files will revert to 1080p upon download) and adhere to the provided Excel spreadsheet for naming ...

I'm in need of a professional skilled in data entry, particularly automated data entry to assist me with extracting text data from Excel sheets. Ideal skills for this job include: - Proficiency in Excel - Experience with automated data entry - Attention to detail - Ability to work independently and meet deadlines

Experienced Telemarketer Needed for Commercial Insurance Campaign I work with commercial insurance brokers and am seeking a skilled telemarketer to call businesses on behalf of my clients. The role involves introducing my client to decision-makers and effectively presenting their unique selling points (USPs). You will be responsible for collecting key information, such as renewal dates, current broker, current insurer, and premium details, as well as accurately recording conversation details for future reference. If a prospect’s renewal date falls within 4 to 12 weeks and they express genuine interest in exploring other broker options, you will book an appointment for my client. For prospects with renewal dates outside the 4 to 12-week crit...

I'm in need of an Excel and VBA specialist who can create a formula for me. This formula should enable my Excel to send automatic emails through Outlook when specific cell values change. Key Requirements: - Expertise in Excel and VBA programming. - Experience with Outlook email automation. - Ability to understand and implement specific project requirements. The automatic email should include any comments or notes that I specify. Please only apply if you have relevant experience and can deliver quality work in a timely manner. Thanks!

...personalized talking notes for our advocates in areas of heightened complexity Building near-real time closed loop with members. based on monitoring the effectiveness of areas Design, develop, and implement AI models using Generative AI techniques (such as GANs, VAEs, transformers) to create innovative solutions. Fine-tune and optimize AI models for performance, scalability, and accuracy in various applications. Collect, preprocess, and clean large datasets required for training Generative AI models. Implement data augmentation and synthetic data generation techniques to improve model performance. Collaborate with software engineers and data scientists to integrate AI models into existing business systems and products. Ensure seamless deployment...

I'm seeking a data specialist with expertise in residential property records. The primary focus will be on collecting and compiling ownership history of these properties. We have a massive sql database with MLS records, but ownership names is not part of our current data feed and we need to match up not only CURRENT owners of property, but we also need to match up previous owners of property. We aren't really looking for an API, we already use API's for this task. We really need to aggregate the data and host it in our own SQL database so that users of our products have the ability to query as they see fit. Please only reach out if you are a data expert and understand how to aggregate transactional and ownership data for the whole count...

Anu, here's another Python project for you. I would like the same process you did before and the same layout on excel. I need to do a python search for: keywords "hard money lenders investors" "construction loans investors" "fix and flip investors loans" "hard money direct lenders" These are all related to the real estate market, but please do NOT use keyword "real estate loans" as that is mostly banks. We are looking for the small investors.

I'm seeking a proficient data analyst and Excel specialist to conduct statistical analysis on our data and generate comprehensive reports in Excel for our stakeholders. Key Responsibilities: - Conduct in-depth statistical analyses on provided datasets - Generate detailed reports in Excel for stakeholder presentations Ideal Candidates Should Possess: - Advanced knowledge and experience in statistical analysis - Proficiency in Excel, including advanced features - Experience in creating stakeholder-ready reports

Help Japanese Influencers Expand Their Social Media Presence in English-Speaking Countries ☆ Actively Hiring Overseas Residents! ☆ To support business expansion, we are actively hiring people both in Japan and in the following countries: • Singapore • Taiwan • Thailand • Malaysia • Philippines • Vietnam • European countries 【Job Description】 We are looking for individuals to assist in the management of the following social media platforms for Japanese influencers, aiming to help them expand globally and drive traffic to their fan sites: • X (formerly Twitter) • Threads • Instagram • YouTube • TikTok Don’t worry if you lack experience—we’ll provide traini...