Excel vba select range with variable number of rowsроботи

...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 : return data = calculate_indicators(data) # Прогнозирование ...

...Cocina logo on top of the screen, to the right Search bar (Search dish or kitchen), to the right cart, to the right Sign Up, Log In • Below scrollable left to right bar with Icons and type of kitchen below (Indian, Chinese, Mexican, Italian, Ukrainian, Japanese, Korean,) • Below option to choose (Top Chef ON/OFF), Chose diet type ((Vegetarian, Vegan, Gluten Free, Paleo, Keto, Halal, Kosher, Whole 30, low FODMAP, Dairy Free), Filter to choose type of dish Soup, Fish, Meat, Chicken, Salads, Mains, Deserts, Pastry, Sides, etc.). • Below First row Header (Popular Local Chefs) Scrolling to the right each profile clear picture of the dish with face of the Chef (if applicable (Must Have header), below full name of...

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

I need to make a page like the example (attached video), where there will be a button with a suggestion to switch to another browser. When clicked, call a dialog box (system window) and redirect the user to the selected browser. If possible, make it so that only chrome was from the options. Target audience - Android, iPhone is not considered now We want to place a link to the page in tiktok, but need to redirect the user to a third-party browser and do it with a dialog box, other methods as far as I know do not work I found a ready-made solution builder that has such a built-in function. We need to make a similar one only for our site. Tiktok account for testing links is available. If you need I can give a link to this ready-made solution (you can see it on the video).

Мета: Професійне візуалізування квартири площею 71 квадратний метр із двома кімнатами, збільшення реалізму та якості порівняно з існуючою моєю роботою. Поточний стан: Одна кімната вже була візуалізована з матеріалами та освітленням. Однак, бажається більш реалістичне та високоякісне оформлення. Для довідки надано зразок цієї кімнати (мій зразок дитячої кімнати1 та мій зразок дитячої кімнати2) Додаткові довідкові матеріали включають фотографію іншої кімнати (бажаний рівень якості) та фактичну кімнату і основний файл ( та Sketchup+Vray+5+Interior+) Оригінальний файл SketchUp (квартира) буде доступний під час співбесіди. Вимоги: Коригування матеріалів: Детально налаштувати всі матеріали. Наразі я використовую V-Ray 6. Скріншоти всіхваших налаштувань V-Ray потрібно надати. Налаштування осв...

To launch a new product, there is a need to develop a hot water boiler with a capacity of 100, 200, 300 kW. The boiler should run on solid fuel (firewood, coal) and be able to install a burner. Для запуску в виробництво, нового продукту, є потреба розробки водогрійного котла, з потужністю 100, 200, 300 кВт.. Робота котла на твердому паливі (дрова, вугілля) та можливість встановлення пальника.

Вітаємо, Samiullah K.! Я звернув увагу на ваш профіль і хотів би запропонувати вам свій проект. Ми можемо обговорити деталі в чаті.

Need to change the "Shipping City" field widget from a List to a Text field, under the field, display Help text. After writing the name of the city, compare the name and display the corresponding list of departments in the "delivery offices" field.

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

...допомогою оброблення mouse enter/mouse leave - це дасть змогу одночасно кастамізувати ефект. Графік має масштабуватися - параметр який відповідає за масштаб з можливістю зміни масштабу динамічно. Графік має бути responsive. Може розміщуватися декілька екземплярів графіків на одній сторінці. Вхідні данні: interface Item { title: string; xValue: number; yValue: number; xValueShow: string | number; yValueShow: string | number; extra: any; children: Item[]; }; Вхідні данні - масив екземплярів типу Item. Приклад: Дивись файл Приклад рендеру: // Рендер

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

I need to create a database of Ukrainian: - real estate agencies offering foreign property, - investment / financial firms offering foreign investment property. Database must be devided in two parts: 1. Company from Kyjev 2. Company form other parts of Ukaraine. Database scope: Name of company, Town, Email address, Web site ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Мені потрібно створити базу даних української мови: - агентства нерухомості, що пропонують іноземну власність, - інвестиційні / фінансові фірми, що пропонують іноземну інвестиційну нерухомість. База даних повинна бути розділена на дві частини: 1. Компанія з Києва 2. Фірма утворює інші частини Укарайна. Обсяг бази даних: Назва компанії, місто, адреса електронної...

Transfer news websites advertising texts...

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

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

Перекласти 3 сторінки тексту художнього стилю з англійської на українську мову. Необхідний рівень володіння англійською мовою-C1-C2. Translating the text to Ukrainian from original(English). A level of C1 or C2 is required.

We need to make online store like: , Without content. Also useful filters for specific product characteristics. need online chat Потрібно зробити інтернет магазин на зразок: Без наповнення. Також потрібні фільтри товару за певними характеристиками, онлайн чат

...Components: - The video should incorporate interviews with the scientist's colleagues and family members, so the ability to coordinate and conduct these interviews is crucial. - You'll need to sift through and select appropriate archival footage and photos to include in the video, so experience with archival research is a plus. - The video will also require narration with background music, so a good ear for pacing and sound is important. Skills and Experience Required: - Proven experience in video editing and production, ideally in a documentary style. - Strong communication skills for conducting interviews. - Experience with archival research and sourcing footage and photos. - Ability to coordinate with music and narration. Please i...

Development Scope: 3 Projects 1. Advertising Platform Develop an advertising platform equipped with multiple simple 2D games that end within 30 seconds. Budget: $350 2. Cosmetics Shopping Mall Solution Only developers with pre-existing source code for a cosmetics shopping mall solution may apply. Budget: $350 3. Translation Platform Service Develop a translation platform service delivered as a plugin, API, or widget. Budget: $350 Participation Requirements: 1. Minimum of 5 years of development experience. Only teams with extensive experience should apply. 2. Teams must be capable of handling development, design, screen planning, and UI/UX. 3. As the client does not speak English, only developers comfortable using t...

This is for a charity, health, activism, journalism & science website I need someone to copy 300 articles from Wordpress To Wix. As well as build a navigation menu identical to the one on WP Make sure all of the hyperlinks, keywords and images are transferred over coherently & that all of the articles are in the same order and set to the same date of publishing as WP if possible.

I am in need of a meticulous data entry specialist to convert text data from various digital files, primarily PDFs and Word documents, into an Excel spreadsheet. Key Requirements: - Proficient in data entry with a keen eye for detail - Able to accurately transcribe text data from digital files into an Excel format Ideal Skills: - Excellent command of English for comprehension and transcription - Previous experience with data entry from PDFs and Word documents - High level of proficiency in Excel

I'm looking for a data entry expert to help with Excel data entry and formatting customer information. Key Responsibilities: - Entering customer information into Excel - Formatting data for consistency Ideal Skills: - Proficiency in Excel - Experience in data entry and formatting - Attention to detail and ability to meet deadlines Please reach out if you're interested.

"Enhance an Existing Excel Workbook with Creative Design & Marketing Skills Looking for a professional to refine an Excel workbook with existing formulas, functions, and macros. The task involves improving its visual appeal and overall presentation (logo included) without disrupting the calculations. Estimated time: 2-2.5 hours. Task Instructions for Excel Workbook Enhancement Aesthetic Improvement: Enhance the visual appeal of the workbook, making it more professional and polished. Remove unnecessary areas that do not add value for marketing purposes. Workbook Flow: Organize the pages to ensure logical progression and easy navigation. Improve readability and ensure a cohesive structure. Content Review: The workbook contains real data...

We have 2 logos: - Ninja Academy Logo - Forever Young Lifestyle Logo ... Ninja Academy Logo will be placed on the left sleeve Forever Young Lifestyle on the right sleeve ... Both logos can also be placed in front or on the back of the shirt. ... Look at our previous designs and propose something new and better.

...innovative application that connects users with qualified tradespeople in real-time. The app should feature: - Separate registration processes for customers and tradespeople, with the app being free for customers and implementing a monthly fee for tradespeople. - A map displaying the nearest tradespeople upon a customer's selection of a trade service. - A rating system akin to Uber's, appearing when a customer clicks on a nearby tradesperson. - An eye-catching orange and grey color scheme. The user registration process should include: - Email verification - Phone number verification Skills and Experience: - Proficient in cross-platform app development for both the Apple Store and Google Store - Experience with real-time tracking features i...

I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.

...experienced developer to create a WHMCS provisioning module that automates the selling, creation, and activation of IPTV service accounts through a provided API. Key Responsibilities: - Build a WHMCS module enabling clients to select from various IPTV service options, such as country selection, service duration (monthly or annually), and channel package selection, during the purchase process. - Implement automation for account creation on the IPTV server as soon as payment is confirmed in WHMCS. - Ensure immediate activation of the IPTV service account upon successful payment. Module Features: - The module should allow for service customization at the point of purchase. - Seamless interaction with the IPTV API for automated account creation. Deliver...

Project Overview: The goal of this project is to develop an advanced content creation tool that can perform a range of tasks. These tasks include: Writing Posts, Paragraphs, or Articles Designing Survey Questionnaires Designing Posts or Banners Creating Survey Results Presentations from Data Retouching Images (Single or Multiple) Building Simple Landing Pages We are seeking an experienced OpenAI developer to help us build a custom content writing tool tailored to the specific writing styles of multiple clients. This tool will leverage OpenAI's language models (such as GPT-4) to generate content that aligns with the unique preferences, tone, and voice of each client. The vision is to create a system where users can select a client from...

Improvement of a Scraper Bot for Collecting Ads from a Thai Classifieds Website with Database Integration and Image Handling The bot is already mostly functional, but it requires some final adjustments and additions. Due to lack of time, I’m looking for someone to complete the project without charging "millions of dollars." What has been done: The bot connects to the database and successfully retrieves the structure of categories and subcategories (first and second levels). The JSON file with ad links is generated and added to the database correctly. CSS classes for identifying data have been initially configured, but they need to be thoroughly reviewed and verified. What needs to be done: Verify the CSS classes and ensure that al...

I'm facing an issue with my WooCommerce store where none of my product variations or attributes are showing to customers, neither in the frontend nor in the backend for variable products. - All color variations are correctly set up in the WooCommerce product settings, yet they are not displaying. - When attempting to view or edit these variations, an error message appears stating "please select an option", even when no options are visibly available. I'm looking for a qualified WooCommerce expert who can troubleshoot and resolve this issue. Experience with WooCommerce and understanding of product variations is a must. Please provide examples of similar issues you've resolved in the past.

...firmware engineer to design an STM8 board that interfaces with a GPS and a speaker. The primary function of this project is to have the speaker announce pre-recorded messages at specific locations. Key project requirements: - Design of the STM8 board hardware. - Firmware development for the STM8 board. - Interface design for the GPS and speaker. - Implementation of internal storage for pre-recorded messages. Ideal candidates for this project should have extensive experience in hardware design and firmware development specifically with STM8 boards. Familiarity with GPS integration and audio output systems is a plus. Your ability to design for internal storage will also be critical to the success of this project. Please provide examples ...

...The app should be engaging, interactive, and educational, targeting key areas of mechatronics. Key Requirements: - The app must be available across multiple platforms: iOS, Android, and Web. - It should cover a broad range of mechatronics disciplines, including electrical/electronics, mechanical, computer, controls, and automation. - The app should incorporate game-like elements to make learning fun and engaging for teens. Ideal Skills and Experience: - Proven experience in app development, particularly educational or game-based apps. - Strong understanding of mechatronics principles and the ability to translate this knowledge into engaging app content. - Previous work with multi-platform apps, with a portfolio of successful iOS, Androi...

I require a talented web developer to fine-tune my unfinished WordPress site. Key Areas of Improvement: - Design/Layout: Customizing the theme and enhancing visual aesthetics to create a more appealing and user-friendly interface. - Functionality/Features: Troubleshooting and improving certain plugins/add-ons, as well as refining forms and interactive elements for seamless functionality. - Content/SEO: Optimizing the site’s content and SEO parameters for better visibility and reach. Ideal Skills: - Proficiency in WordPress with a strong focus on theme customization. - Extensive experience with WordPress plugins and interactive elements. - Strong understanding of SEO principles and content optimization. - A keen eye for design and visual elements.

I need a designer to create a set of 20 jean buttons and rivets, as well as 20 simple leather patch designs for the back of jeans. The designs should be made according to a range of requested colors and styles. Basically add my logo in the button and make suggested color. Key Tasks: - Design wp jean buttons and rivets. - Create 20 simple leather patch designs for the back of jeans. - Prepare a PDF guide/manual with all designs, each with a serial number for factory replication. Ideal Skills: - Strong graphic design skills - Experience in fashion accessories design - Proficiency in creating detailed design manuals - Ability to work with a diverse color palette The color palette for the buttons and rivets will be several diff...

More details: Is this project for business or personal use? Personal What information should successful freelancers include in their application? Experience How soon do you need your project completed? Within a month

I'm seeking a professional who already have a prof...Creation: Help refine our initial game concept into a compelling and engaging play-to-earn game. - Technical Development: Oversee the technical development of the game and its native cryptocurrency. - Marketing Strategy: Devise an effective marketing strategy to promote the game pre-launch and throughout its lifecycle. - Deposit, withdraw and rankings features. Ideal Skills and Experience: - Proven experience in game development, particularly in the play-to-earn sector. - Deep understanding of the Solana blockchain and its capabilities. - Strong background in cryptocurrency development. - Excellent marketing skills, with a proven track record of successful game launches. - Innovative thinking and ability...

I'm in need of a dynamic and energetic video editor for my YouTube channel. Channel will be focusing on reviews, advice, business and behind the scenes. Looking for someone I can slowly grow with! @AndreiRoman Key Responsibilities: - Edit videos to reflect a dynamic, fast-paced style - Incorporate text overlays and annotations at relevant points - Select and integrate appropriate background music and sound effects - Utilize transitions and visual effects to maintain viewer engagement The ideal candidate would be a skilled video editor with a good understanding of YouTube's format and viewer expectations. Experience with product review and unboxing content is a plus. A keen sense for energetic pacing and the ability to keep the content...

hat website - Make sure all the buttons have a radius of 2 - Make sure you include tags on thumbnails such as (New In, Sale, Limited Edition) - Pop ups should be designed with discount code sent to user once they sign up to newsletter - The categories (which will also be part of the filter) that will be required are: silhouette - [ ] A-frame - [ ] n-frame - [ ] Bucket hat - [ ] Flat visor - [ ] Black hat - [ ] Trucker hat Visor style - [ ] Flat visor - [ ] Curved visor - [ ] None (beanies and buckets fall under this category) colour - [ ] Black - [ ] Blue - [ ] Red - [ ] Cream - [ ] White - [ ] Pink - [ ] Brown Shop by team - [ ] Hull Scorpions I will attached a reference for the filter dropdown Reference filter: HOME PAGE:

I'm looking for a freelance video and photo editor who can create and implement a plan for my personal vlogs. The job will involve editing videos, photos, and crafting engaging posts. Key Responsi...for a freelance video and photo editor who can create and implement a plan for my personal vlogs. The job will involve editing videos, photos, and crafting engaging posts. Key Responsibilities: - Edit 5-10 photos and 5 videos (range from 5 to 20 minutes each) monthly - Schedule posts on YouTube, TikTok, and Instagram - Write casual and friendly copy for all posts Ideal Candidate: - Experienced in video editing with minimal editing - Skilled in crafting engaging social media posts - Able to understand and replicate a casual and friendly tone - Prior experience with v...

I'm in the process of starting a cleaning service business and need a WordPress expert to help me design a professional and corporate styled website. Key Features: - Custom WordPress Design: I want a modern, sleek, and professional looking site that reflects the corporate nature of my business. - Client Portal: This portal should include functionalities such as appointment booking, invoice management, and service requests. - Employee Portal: Although I have not fully decided on the functionalities for this portal, it will likely include aspects of job scheduling and timesheet management. Ideally, the freelancer for this project should have extensive experience with WordPress and WordPress theme customization. A portfolio of similar corporate projec...

Android iOS both development Phone Zio sensor specific movement detection or volume button or power button Automatic push notification to designated members when pressed Members who receive push notifications must take action App payment Promotional reward function Visit path number of visits SNS sharing login Condições de elegibilidade para participação no desenvolvimento 1 Mais de 5 anos de experiência em desenvolvimento / Deve ser uma equipe com ampla experiência em desenvolvimento 2 Somente equipes capazes de projetar e desenvolver telas e UIUX como equipe de desenvolvimento 3 O cliente não fala inglês, portanto é utilizado tradutor apenas para desenvolvedores que não tenham problemas de comunicaç...

I'm see...a talented architect to design a series of 4-5 traditional style houses, all within a square footage range of 800-1,200 sq ft. The designs should follow the same format but with varying sizes, and if possible, I would also appreciate a comprehensive list of materials needed for each house. In addition, I need these houses to be created in 3D for marketing purposes, and expertly placed on each lot, taking into account the best fit for each space. Ideal skills and experience for this job include: - Proficiency in architectural design, particularly in traditional styles - Experience in creating 3D models for marketing - Ability to assess and determine optimal lot placements - Knowledge in material estimation and list creation - Strong unde...

...Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will be available IMMEDIATELY without delay and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify and Wordpress - Familiarity with app development for Shopify & plugins for wordpress - Store setup and configuration - INSTANT communication availability (as we have only teamwork-based tasks, not work-at-your-own-pace). Only individual freelancers please, no teams/agencies. In order to separate spammers from real candidates, if you agree with this statement please write it on top of your bid: "I am available to immediately and have X hours left available TODAY!" - where "...

Hi I made them as per our conversation.

Project Description: We are Knallfrosch, a company specializing in unforgettable event experiences for children and families. Our goal is to refresh our logo with a modern and captivating design that reflects our creativity, playfulness, and professionalism. We are seeking a talented designer to help us create a new logo that: Offers a fresh and modern look. Can be inspired by our current logo, but new creative approaches are also welcome. Captures the essence of our brand—vibrant, joyful, and family-friendly. Key Details: Color Palette: Feel free to experiment, but designs should maintain a warm, inviting tone. Typography: Should be clean and easily readable across various platforms. Style: Versatile enough to work on digital media, print materials, and merchandise. ...

I'm in need of a professional who can assist with registering both my trademark name and logo in the UK. This is crucial as my product, which falls under the 'pharmaceutical , medical devices , cosmetics , food supplements' category, is sold internationally. Key Responsibilities: - Assist in the registration of my trademark name and logo in the UK. - Ensure the trademark registration process is compliant with international standards. Ideal Skills: - Proven experience in trademark registration, particularly in the UK. - Knowledge of international trademark laws. - Strong attention to detail to ensure all aspects of the trademark are correctly registered.

I'm seeking a highly skilled Facebook Ads expert to boost my sales for a range of physical products targeted at young adults (18-35). Ideal Skills: - Proven experience in eCommerce Facebook Ads - Expertise in targeting and engaging with the young adult demographic - Strong analytical skills to assess campaign performance and optimize accordingly - Creative approach to ad design and copywriting Your primary objective will be to drive sales through effective ad campaigns. If you can demonstrate a track record of successful Facebook Ads campaigns, particularly with physical products aimed at a younger audience, I would love to hear from you.

I'm looking for a talented 3D animator to create an educational animation depicting what Mars might look like in the future, particularly if humans were to colonize it. Key Focus Areas: - Housing: Visualizing various li...Conceptualizing communal areas on a colonized Mars. - Future Technologies: Integrating advanced tech into the animation. Depicing how humans live and thrive on the planet Style: The animation should have a 'futuristic' tone. It needs to push the boundaries of current day visuals, showing a Mars that is not only colonized but thriving. Ideal Skills: - Proficient in 3D animation software. - Experience with creating educational content. - Ability to conceptualize and visualize futuristic scenarios. Please provide examples of your prev...

Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.

I'm seeking a proficient Python developer with experience in trading platform integration, data analysis, and backtesting. The project requires the development of a system that: - Retrieves and processes news sentiment from - Gathers alt rank from - Forecasts prices using Google Times Series Foundation Model The system needs to be compatible with the Jesse trading platform, able to perform both backtesting and live trading. Each news article will be classified as positive, negative, or neutral, and the task will involve calculating an indicator value as a rolling sentiment score within a specified window, with a range from -10 to 10. Key project requirements include: - Full integration with data APIs from and - Real-time updates