Excel vba return data sheetsроботи

...'volume']) return df def calculate_indicators(df): # Индикаторы для анализа df['SMA'] = df['close'].rolling(window=20).mean() df['EMA_9'] = df['close'].ewm(span=9, adjust=False).mean() df['EMA_21'] = df['close'].ewm(span=21, adjust=False).mean() df['ATR'] = (df['high'], df['low'], df['close'], timeperiod=14) return df def predict_price(df): model = LinearRegression() X = (range(len(df))).reshape(-1, 1) y = df['close'].values (X, y) predicted_price = ([[len(df) + 1]])[0] return predicted_price async def scalping_strategy(symbol): data = get_market_data(symbol) if : retu...

Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.

Табличка буде використовуватись для аналізу конкурентів ринку. Вона має бути зручною для ведення, зі зрозумілим звітом у вигляді графіків на основному дашборді. Показників в різних категоріях які вона має рахувати більше 30, терміни, фінанси, порівняння, відсотки, категорії, середні значення. Чекаю Ваших пропозицій стосовно вартості

Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.

Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.

Transfer news websites advertising texts...

Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией

Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.

I'm looking for a freelancer who can meticulously extract a large mixed data (numerical and text) table from a statistical website and transfer it into Excel without missing any details. The ideal candidate should ensure that the data is formatted in Excel in the exact same way as it appears on the website. Skills and Experience: - Proficient in data extraction and Excel - Attention to detail to ensure no information is missed - Ability to format data in Excel as per the client's request

...and Google Sheets API to help automate some tasks. Key Requirements: - Task Automation: Primarily focusing on automating data processing tasks. - Data Transformation & Formatting: This will involve manipulating data into a suitable format for analysis. - Develop an automation script using Python   - Utilize the Google Sheets API to synchronize data for our Django website  Ideal Skills:  - Proficient in Python   - Extensive experience with the Google Sheets API  - Strong background in automation and scripting  - Understanding of data synchronization processes  - Skill in Django is bonus  Ideal Skills: - Proficiency in Django and Python: Essential for creating effective aut...

I need a skille...need a skilled Python programmer who can help in extracting table data from PDFs and converting it into an Excel file. The tables in the PDFs have varying structures, so your ability to handle different table layouts is essential. Key requirements: - Extract tables from multiple PDFs - Convert the data into a well-structured Excel file with 4 different formats across 2 sheets - Ensure the data is accurately represented as mixed data (both numeric and text) Ideal Skills: - Proficiency in Python, with experience in data manipulation using Pandas DataFrame - Excellent attention to detail for accurate data extraction and conversion - Prior experience in handling PDFs and Excel files With your expertise,...

I'm seeking a seasoned Business Analyst with 3-6 years of experience, particularly in the retail sector. This remote, 3-month project entails developing and implementing brand marketing strategies to boost our brand visibility. Key Responsibilitie...case studies - Monitor and assess the impact of marketing initiatives - Analyze competitors' operations and identify their strengths and weaknesses. Desired Skills: - Strong analytical capabilities - Excellent marketing knowledge - Superb communication skills - A touch of sales experience. Ideal candidates will possess a BCA, MCA, B.E. or a relevant degree. Experience with tools like Microsoft Excel, Google Analytics, and Salesforce is a plus. Though not mandatory, a primary objective of enhancing brand recognition would be ...

Require an existing WordPress shipping plu...plugin to be optimised/fixed. The plugin connects to a carrier's API and returns several rates based on the weight and dimensions of the order etc. The plugin has been newly created but is currently not integrating with the API correctly, resulting in the API blocking the plugin for several hours. So in other words, the plugin works for a few uses at the cart and checkout pages but is then fails to return results for a few hours. The API has documentation and is widely used by other plugins and tools etc. While not a requirement, it would be desirable to share access to the existing plugin files (and future versions) via Github. Post completion, an going relationship to maintain and improve the plugin is planned. Happy to answer...

I need assistance in entering mixed data, which is currently stored in digital files, into MS Word. Requirements: - Proficient in MS Word and data entry - Able to work with mixed data (text and numeric) - Experience handling digital files, particularly text files The data is sourced from various digital files including Excel, PDF and text files. Your role would primarily involve transcribing this into MS Word, so attention to detail and accuracy is crucial.

...english. With experience as a small business owner, self-employed or freelance. An empathetic person, capable of understanding the commercial needs of a businessman. We are looking for an extroverted and eloquent person, with the ability to "make friends even with stones". Once you contact our client profile, you only have to show them our service and how it will help them commercially (% savings on return logistics). We carry out the sale and closing of the sale. Our client profile is a chinese or hong kong company that sells on Alibaba, Aliexpress and/or Temu. Objective: term 1 month, extendable to more months depending on objectives met 85 euros / client that hires our annual services (for each signed and paid contract) The sales commission is recurring as long a...

I need a freelancer to help with data scraping and organizing the information into an Excel file. The data source will be various databases. - Scope of Work: - Scraping email addresses and names/contact information from databases. - Organizing the data into an Excel file with separate columns for each data type. Ideal Skills: - Proficient in data scraping techniques. - Excel expertise, specifically in organizing and formatting data into separate columns. - Attention to detail to ensure data accuracy. - Previous experience with data scraping from databases is a plus.

I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Creativity for flexible design

Project Title: Data Entry and Administrative Support Needed Project Description: Update a large database with accuracy and efficiency. Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Wri...

I am an eBay seller seeking assistance to enhance my Boost Space automation with Google Sheets. The primary goal is to streamline my shipping purchasing and automate my accounting updates while ensuring my data is properly formatted. Key Responsibilities: - Integrate Boost Space with Integromat and Google Sheets - Connect various shipping platforms, primarily eBay and possibly Pirate Ship - Update my spreadsheets with order numbers and formatting dates to a U.S. style date format Ideal Skills: - Proficient in Boost Space and eBay shipping processes - Extensive experience with Integromat and Google Sheets - Strong understanding of eBay and Pirate Ship integration - Excellent attention to detail for data formatting and accuracy Your expertise will help ...

...Description: We require a robust and scalable Project Management System built on Microsoft Power Apps. The system should allow users to manage projects, tasks, risks, budgets, and reports efficiently. The application will integrate with Microsoft tools like SharePoint, Power Automate, and Teams for seamless collaboration and automation. Project Goals: Centralized management of projects, tasks, and related data. Improved collaboration among team members. Automation of workflows for task assignments, approvals, and notifications. Advanced reporting and analytics for project tracking and decision-making. Core Features: 1. Dashboard Overview of all projects. Visual status indicators (e.g., progress bars, charts). Quick filters (by priority, status, department). 2. Project Manageme...

I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.

I'm seeking an expert in antenna design, specifically with experience using PyAEDT software. I need a horn ante... Tune the result with different flare design configuration. Give a report for multifare design. Key Requirements: - Design of a horn antenna using PyAEDT and AEDT - Targeting the Ku-band 13.4-13.8 GHz - Linear polarization -Size 75x75x60 including flange - Multiflare configuration - Starting circular waveguide aperture is 8.1mm -Gain 20 dB -beamwdith 3dB +-45 @ 13.6 Ghz polarization Linear return loss less than -20 dB Ideal Skills: - Proficient in antenna design - Familiar with radar systems requirements - Experienced in using PyAEDT - Knowledgeable in Ku-band specifications - Able to design for linear polarization -Multiflare design can be controlled thorugh c...

I'm looking to develop a mobile-based, Android-compatible, interactive word puzzle game. Key Features: - A grid where players can input letters to form words. - An intuitive interface allowing players to easily move letters within the grid. - A feature to return letters to their original position. Ideal Skills: - Proficient in Android game development. - Experience in creating interactive puzzle games. - Strong understanding of user interface (UI) and user experience (UX) design principles. Please provide examples of similar games you've developed in your bid.

I’m looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has:  Name  Contact number (with country code)  Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent successfully and which weren’t. How...

Bullet Points: Copywriting Skills: I have extensive experience in writing articles, product descriptions, website copy, and other forms of content. SEO Copywriting: I am proficient in creating SEO-friendly content that helps improve search engine rankings. Engaging and Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong background...

...& OCR Data Extraction Description: We are looking for a Python developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR ...

I need an expert in Google Sheets to create a comprehensive inventory management system for tracking used cars. The system should include functionalities for vehicle tracking, sales management, and reporting and analytics. Key Requirements: - Design a user-friendly Google Sheets system for tracking used cars - Implement functionalities for sales management and reporting/analytics - Ensure the system is secure and only accessible by the Admin and verified users Ideal Skills: - Proficient in Google Sheets with a track record of creating complex spreadsheets - Experience in inventory management systems, particularly for vehicles - Strong understanding of sales management and analytics - Excellent attention to detail and ability to create user-friendly interfaces

We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.

...an intuitive user interface with the following features: Real-Time Audio Capture: The app will capture audio from the device's microphone as the user speaks or makes sounds. Real-Time Playback: The captured audio will be played back in real time. Noise Cancellation: The app will have a button ("Noise Cancel") that will send the captured audio to the RNNoise C library for noise cancellation and return the processed, denoised audio for real-time playback. Customization: Users should be able to adjust a slider to change the "column" (likely related to audio parameters like volume or noise cancellation intensity) during real-time audio capture. Offline Functionality: The entire app, including noise cancellation, must function completely offline without the n...

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuri...

...Sales and Marketing Data **Description:** We are seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy...

I need a Word document transposed into an Excel file. Key Points: - The original document contains text only. - Text organization within the Excel file is not uniform. It varies and will need to be explained. Ideal Skills: - Proficient in Microsoft Excel and Word. - Good understanding of data transposition. - Detail-oriented to ensure accurate transfer of content.

...someone with strong Google Sheets skills to create a team-wide KPI tracking document tailored to our needs. The document should compile data from different tabs/sheets into a "master" document for our weekly meetings. Key Requirements: - The sheet should automatically add new weekly KPIs to the top of each page. - There must be an input field for setting and distributing new KPIs to team members. - The KPIs will mainly come from manual inputs by team members. KPI Categories: - We're tracking various metrics such as outreach calls, follow-ups, face-to-face meetings, quotes, invoiced sales, and new customers. Setting New KPIs: - New weekly KPIs for each team member will be set manually in a designated field. Ideal Skills and Experience: - Proficien...

I need a comprehensive Excel spreadsheet containing the top 5,000 accounts. The data should include: - Number of followers - Social handle - URL link The accounts should be ranked by the number of followers. The ideal freelancer for this project should have experience in api data collection and Excel, with a proven track record of working with social media data. Attention to detail is crucial, as is the ability to source information from reliable platforms. Please do not submit junk data, or data you have not reviewed yourself. Send an excel file or google sheet document link. Thanks

...network's efficiency. The perfect candidate will have: - Proven experience with Mighty Networks or similar platforms - Expertise in digital marketing, especially in ad creation and optimization - Strong communication skills for effective member engagement - Ability to manage administrative tasks with attention to detail I am excited to work with someone who is as passionate about helping others excel in their personal and professional lives as I am. Let's make this network a thriving community together!...

I need a freelancer to help me gather real estate property addresses from public companies' websi...addresses from public companies' websites. I will provide the list with 25 public companies with the URL to their properties. Save the list of properties for each public company in a separate Excel to avoid confusion. Please compile the data in a Microsoft Excel spreadsheet, and ensure to include the following fields for each property address: - Street Address - Address 2 (optional) - City - ZIP/Postal Code - Name (if applicable) - State - Country I will provide a sample template to help. Ideal skills and experience for this job include: - Proficiency in web research - Familiarity with Microsoft Excel - Attention to detail - Understanding...

...Change the field “Nombre de la empresa (opcional)” to “DNI/RUC” and make it mandatory. • Reorder the address-related fields to follow this sequence: Departamento (Department), Provincia (Province), Distrito (District), Dirección completa (Full Address, with an example as a placeholder). A detailed Excel file with the list of departments, provinces, and districts in Peru will be provided. 2. Shipping configuration: • Adjust shipping rates based on the provided list of Peruvian locations in Excel. • For destinations within the Department of Lima and the Province of Lima: • Calculate shipping costs using the provided price table. • For destinations outside the Department of Lima and the Province of Lima: • Di...

...Alipay Miniapps. The existing web app is built in ReactJS and its key features include: - 'Rent Battery' button - Payment integration via WeChat Pay / Alipay - User history tracking - Location mapping via API (using JSON lat long) - Feedback submission via camera or photos sent through API - Authentication via Google and Apple ID (to be replaced with WeChat and Alipay ID) The goal is to have users return with the same profile, which is crucial for this project. No new features are needed for the WeChat mini-app, just a straight replication of the current web app. At this moment, I do not have the WeChat Mini Program developer account set up. If you have experience in this area and can assist, that would be a bonus. Ideal skills and experience for this job include: -...

...which changes every month. All sheets linked by employee ID. - The summary and allocation detailed report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in da...

...Provide weekly reports with insights and recommendations for improvement. Requirements Proven experience as a Virtual Assistant or similar role. Strong research and content curation skills. Excellent written English with attention to detail and grammar. Experience with social media platforms (LinkedIn, Twitter, Reddit, Instagram, etc.). Familiarity with tools like Substack, Buffer, Canva, and Google Sheets. Ability to work independently and meet deadlines consistently. Preferred Skills Knowledge of remote work or career development trends. Experience managing or engaging in online communities (e.g., Reddit, Facebook groups). Basic graphic design skills using Canva or similar tools. Hours & Compensation Weekly Hours: ~10–15 hours per week. Hourly Rate: based on experien...

I need some expert guidance with Excel formulas for a cap table. The focus will be on equity allocation. I have created the excel file and entered the different rounds but I need help with some of the formulas. Key Requirements: - Formulas to effectively distribute equity among stakeholders - Representative display of shareholder names, number of shares held and percentage ownership Ideal Skills and Experience: - Strong proficiency in Excel, particularly with complex formulas - Experience with cap tables and understanding of equity allocation - Ability to present data in a clear and comprehensible manner

I need a methodical ...and detail-oriented freelancer to assist with data entry from supplied aerial site images. Specific Tasks: - Using Google Maps to obtain GPS coordinates for 96 marked building locations on the aerial images. - Pasting these coordinates into a provided Excel spreadsheet template. - Manually verifying each entry to ensure accuracy. Automation is not an option for this task. Example provided for the Excel spreadsheet. Please note, only the GPS coordinates are required from Google Maps, with the building locations indicated by outlines on the aerial images. Ideal Skills: - Proficiency in using Google Maps - Excellent attention to detail - Ability to work methodically and systematically - Competency in Excel - Previous experience with simi...

...Provide weekly reports with insights and recommendations for improvement. Requirements Proven experience as a Virtual Assistant or similar role. Strong research and content curation skills. Excellent written English with attention to detail and grammar. Experience with social media platforms (LinkedIn, Twitter, Reddit, Instagram, etc.). Familiarity with tools like Substack, Buffer, Canva, and Google Sheets. Ability to work independently and meet deadlines consistently. Preferred Skills Knowledge of remote work or career development trends. Experience managing or engaging in online communities (e.g., Reddit, Facebook groups). Basic graphic design skills using Canva or similar tools. Hours & Compensation Weekly Hours: ~10–15 hours per week. Hourly Rate: based on experien...

I am looking for a skilled VB.NET developer to assist in resolving issues (now and ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net w...ongoing) that we are trying to send live. You need vb.net skills and experience with ms office object model though vb.net we also need an installer so we can push updates to clients. Key Requirements: - Develop a VB.NET application that can scan and read content from Excel and Word documents. - Implement functionality for the app to interpret different types of content such as text, tables, and charts. Ideal Skills: - Proficiency in VB.NET - Experience in developing applications for document scanning and reading - Familiarity with Excel and Word document structures -in...

...freelancer to help gather data ( or share already researched data) on international students currently attending U.S. universities. The data should be comprehensive and cover a range of details about each student. Key Data Points Needed: - Student First Name - Student Last Name - Current U.S. City - Student University Email - Student Personal Email - Student Home Country - U.S. University Name - Degree Pursuing (Bachelor's, Master's) The ideal candidate will have: - Experience in data collection and research - Access to verified data - Ability to deliver in a clear and organized way Important Note: The home country of the student must not be the USA. I am open to data from any other region, and I will need this data r...

I work with a boutique venture capital firm specializing in acquiring and scaling online businesses, including content websites, SaaS companies, social media accounts, and mobile apps. They are committed to innovation, data-driven decision-making, and fostering entrepreneurship. I have been tasked to hire a PART TIME, motivated and analytical Venture Capital Intern to join our dynamic team. This paid internship offers hands-on experience in sourcing, analyzing, and evaluating potential business acquisitions. The role is ideal for individuals passionate about online businesses, financial and market analysis. As an intern, you will play a key role in the acquisition process by identifying opportunities, conducting in-depth research, and providing actionable insights to help drive ...

I am seeking a resourceful and proactive virtual assistant who is proficient in managing Google Sheets and Docs, creating content with Canva and Squarespace, as well as using LLMs like OpenAI and Claude. Key Responsibilities: - Managing Google Sheets and Docs: This includes data entry and organization, creating and maintaining templates, and conducting data analysis and reporting. - Content Creation: Design marketing materials and assist with website design and updates using Canva and Squarespace. Ideal Skills and Experience: - Proficiency in Google Sheets and Docs - Experience with Canva and Squarespace - Familiarity with LLMs like OpenAI and Claude - Strong English speaking skills - Smart, resourceful and proactive attitude I value trust and reliabi...

...plans and elevations for our first conceptual meeting with the client, with a strong emphasis on landscaping and outdoor features. The ideal freelancer will have a keen eye for design and a solid understanding of Revit, as well as experience in creating visually appealing and functional commercial planning drawings. Key Tasks: - Finalize the presentation of drawing plans and elevations and create sheets for all levels and a couple of shots for the elevations, including color schemes, grids ... etc. - Integrate walkways with kerbstone, 2 drop-off areas for both the commercials retail area and the hall, and outdoor seating and tables for the restaurant with some shades. - Add greenery and flowers to the terraces on the elevation - Design a landscape for the outdoor walkway areas...

I have a project that involves transferring data from PDF documents into an Excel spreadsheet. The documents are about 100 pages long and contain a mix of text and numbers. The successful freelancer will need to: - Accurately input this information into Excel in both alphabetical and numerical order. - Use a pre-existing template, with potential for adding or deleting columns based on predefined rules or guidelines. Ideal candidates will have strong attention to detail, experience with data entry and proficiency in Excel. Prior experience dealing with PDF to Excel data transfer will be highly regarded.

I'm seeking an expert who can build a comprehensive reporting dashboard using data from Google Sheets. The data primarily includes product purchase information and investment returns. Key Requirements: - Building a dashboard that tracks return on investment and profit over time. - Utilizing bar charts, line charts and other charts as appropriate for visual representation of the data. Ideal Skills: - Proficiency in Google Sheets and Reporting. The use of Looker Studio or other interfaces will be considered. - Strong experience in data visualization and dashboard creation. - Ability to derive and display meaningful insights from data. Detailed requirements and link to example of source data are contained in the pdf.