Excel vba select indirect rangeроботи
...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) # Прогнозирование ...
...showing only options in searched radius). Each Chef should be indicated by circle or icon, easy to see on the map, availability to zoom in and out while remaining set radius) • Upon pricing the icon (in the bottom instead of (Show Chef’s button) appears small square showing at the left photo of Chef, to the right - type pf kitchen, Price range, Diet type (or spice level) • Under right corner small button select date (upon pressing option to select date from today to 2 weeks in advance) • At the bottom button (Show Chef’s)- refreshing the search Cart • At the top depending to delivery type either: • (Icon, Deliver) or (Pick up, Address) • Potential space for (ex. 6,20€ left for free delivery) • Belo...
Необхідно розробити макрос з перетворенням 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).
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I 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 hope to streamline my data processing task and make it more ef...
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 ...
...Requirements: - The logo should primarily represent elegance, in a way that resonates with the luxury market. - A minimalist approach is crucial, as I prefer a clean, uncluttered design style. - The color palette is strictly gold and black. The designer should have a good understanding of how to use these colors to convey a sense of luxury and refinement. - As the brand will be offering a diverse range of products, the logo must be versatile enough to suit all these different sectors. Ideal Skills and Experience: - Proven experience in graphic design, with a strong portfolio of luxury brand logos. - Excellent understanding of minimalist design principles. - Ability to create a design that is both elegant and versatile. - Strong skills in color theory, particularly with gold and ...
Tool: Figma or Penpot or Any other relevant tool Target User: Recruiters, hiring managers, and team members involved in the hiring process. Overall Style: Adhere to the HeroUI design language, which emphasizes a clean, m...style. Use their theme configuration to maintain consistency throughout the design. ● Be Responsive: While not a primary focus, consider how your layout would adjust to different screen sizes. ● Focus on Usability: Design for a smooth, intuitive user experience. ● Add Some Real Data: Don't just use placeholder text; insert some real-world examples to bring your design to life. ● Component Choice: Select appropriate HeroUI components that fit the design you intend to use, and use them to implement the sections above. Figma UI Kit: HeroUI Figma Kit (Community) ...
...a WordPress website where users can purchase and rent renewable energy products, with real-time availability tracking based on dates. The site should default to French, with English, Spanish, and German available as additional languages, all with full content translation. Key requirements: - Product Variability: Approximately 50 products with different characteristics. Users should be able to select product specifications (Power output, Autonomy time, Mode of mobility) to configure their final product. I'm open to suggestions on how to best implement this. - Video Integration: The site should be completed with videos. These will include tutorials on how to assemble the products and explanations of their features. Videos will need to be provided in both horizontal and verti...
...Firebase via a web interface. (already developed by me). The app that i am requesting will retrieve print parameters from Firebase, including the print parameters like number of copies and whether to print on the front, back, from the backend. 2) The app will handle user login and account management, with a one-time setup for adding printers. Printers will be pre-installed on the desktop. Users will select from a list of printers to associate with their print category (eg: passport photos -> printer1, page printing -> printer2 etc). 3) The app will facilitate printing of photos and PDFs using a pre-selected printer and update the firebase with the print status. User Roles: The app will primarily cater to standard users, so the design should be intuitive and user-friendly. ...
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.
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 flashing device to fix issues on my OnePlus phone. It's primarily for repairing device problems. Ideal skills for this project include: - Proficiency in handling OnePlus devices. - Experience with flashing tools. - Capability to troubleshoot various device issues. Please note that I have not specified the model of the OnePlus device or the exact...OnePlus phone. It's primarily for repairing device problems. Ideal skills for this project include: - Proficiency in handling OnePlus devices. - Experience with flashing tools. - Capability to troubleshoot various device issues. Please note that I have not specified the model of the OnePlus device or the exact problems I'm encountering. Therefore, the freelancer should be adept at dealing with a range of pot...
I'm looking for an experienced backend developer to help complete the MVPs of my AI fitness application. The frontend has been designed using Flutterflow and is ready for backend integration. Key areas to focus on: 1. Nutrition Section: The nutrition segment of the app will need to interface with existing food databases, allowing users to access a wide range of nutritional information. We need to integrate a food scanner with an API. 2. Training Section: This part of the app should support customizable workout routines. A deep understanding of fitness and training programs will be beneficial for creating intuitive and effective routines. 3. Tracker Section: The tracker segment needs to monitor multiple elements. This includes workout progress, nutrition intake, and sleep a...
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 currently includes a login system and a single exercise (dumbbell curls). Below are the required changes and additions: Remove Login System: Simplify the application by removing the login functionality, allowing direct access to the main features. Exercise Selection: Create a dropdown list with 6 standing exercises (e.g., squats, lunges, shoulder presses, etc.). Users should be able to select an exercise from this list to start. Exercise Preview and Timer: Before each exercise begins: Display an animation or image demonstrating the correct form for the exercise. Include a countdown timer (e.g., 5 seconds) before starting the exercise. Exercise Session Features: Start the camera feed after the countdown to track the user’s movements. Implement rep counting for e...
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. Write short yet impactful copy for social med...
...looking for a clean, simple and modern minimalist 6-page WordPress website. Pages: - Home Page: Brief about our services, latest listings - Listings Page: A vehicle-style listing with images, videos, and descriptions. Prices listed but no purchasing capability, just an enquiry form that gets emailed to us. - Listings Overview Page: Latest listings sorted with keyword search and filters (by price range, vehicle type) - Contact Us Page: A form leading to a 'thank you' page, which refreshes to the homepage after 10 seconds. - Terms and Conditions Page: Information only - Pricing Page: Information only with a link to the 'Contact Us' page. All necessary plugins (Elementor Pro, Elements Pro, WooCommerce) are already installed. Ideal skills and experience: - Pro...
...support. 4. Risk and Budget Management Risk matrix (impact vs. probability). Mitigation plans and conditional formatting for high-risk items. Budget tracking: Total budget, expenses, and remaining funds. Visualizations for expenses and trends (charts). 5. Reporting and Analytics Real-time charts for: Task completion rates. Project delays. Resource utilization. Export options for reports (PDF, Excel, Word). Embedded Power BI dashboards. 6. Automation and Notifications Email and Teams notifications for task assignments, deadlines, and approvals. Automated approval workflows for budgets and milestones. 7. Integration Integration with: SharePoint: For document storage and management. Outlook: Sync deadlines with calendars. Microsoft Teams: Embed the app and enable chats. 8. User...
I am looking for a skilled male voice-over artist to breathe life into my YouTube videos with a captivating storytelling voice. The videos will range from 20 to 30 minutes, and the right candidate will help engage my audience through compelling narration. Requirements: - Strong storytelling abilities with a voice that can captivate and engage audiences. - Ability to convey emotions and nuances in the script through tone and inflection. - Proficient in English with excellent pronunciation and enunciation. - Must have high-quality recording equipment to produce clear and professional audio. - Previous experience in voice-over work, preferably with a portfolio or samples of previous storytelling projects. Expectations: - Deliver high-quality voice-over audio files within the agreed-u...
I'm in the process of elevating my event brand, Kiki Disco, and I need your creative expertise. The brand is built around the vibrant and energetic 80's disco scene and I need a series of designs that reflect this. Key elements to incorporate: - Neon lights, Disco balls, Retro patterns: I want these iconic 80's elements to be prominent in the designs. - A range of design formats: This includes posters and flyers, social media graphics, merchandise designs, and individual logo variations. Color scheme: - Bright neon colors: The designs should be bold and eye-catching, using a bright neon color palette typical of the 80's disco scene. Ideal candidates will have: - A strong portfolio in 80's retro design - Experience in creating a variety of promotional mate...
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 looking to create a comprehensive mobile application for an online cosmetics shop tailored for the Armenian market. The app will cater to both male and female customers, featuring a diverse array of cosmetic products. Key Features: - A user-friendly interface with gender selection upon entry. - A well-categorized product range including Face, Body, Cream, Lotion, etc. - A smooth sign-in process, shopping basket, order placement, payment processing, and real-time delivery tracking. - Integration of user reviews and ratings for each product. - A recommendation system for popular items. Payment Methods: - The app should support Credit/Debit Card and Digital Wallets. Ideal Skills and Experience: - Proficient in Android and iOS app development. - Expertise in e-commerce app c...
I'm seeking an expert in antenna design, specifically with experience using PyAEDT software. I need a horn antenna primarily for radar systems, designed to operate within the Ku-band (12-18 GHz) frequency range, and with a linear polarization. Automate the geometry. 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 - Exper...
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...
I'm seeking an expert to calculate the GHG emissions for our jewellery business. Scope of Work: - Evaluate Scope 1 (Direct emissions), Scope 2 (Indirect emissions from purchased electricity), and Scope 3 (Other indirect emissions) - Within Scope 3, focus on 'Purchased goods and services' and 'Employee commuting' categories Standards: - Use the GHG Protocol Corporate Standard for the calculations Ideal Skills: - Proficiency in GHG calculations - Familiarity with the GHG Protocol Corporate Standard - Experience in the jewellery industry is a plus - Strong analytical skills
I'm in search of a professional, charismatic female speaker, based in Indonesia, to help film a series of market review videos. The videos will range in length from 3 to 11 minutes. I will provide the scripts, so your job will be to deliver them in a clear, engaging manner from a professional studio setting. Key Requirements: - Female speaker, based in Indonesia - Access to a professional studio - Experience in video presentation preferred - Ability to adopt a formal and serious tone - Charismatic and engaging presentation style Experience in finance or market analysis is a plus, but not strictly necessary. What is essential is your ability to deliver the scripts in a clear, engaging manner from a professional studio setting. If you can do this while maintaining a formal and ...
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...
I'm seeking a professional photographer/videographer to showcase our products for an online marketplace. The primary focus will be capturing both photos and videos that highlight our product range effectively. Ideal skills and experience for the job include: - Experience in product photography and videography for marketplaces - Proven experience in product photography/videography - Understanding of e-commerce visual requirements - Ability to create engaging content for a marketplace - Proficiency in editing and post-production - Knowledge of best practices for website presentation - Availability of own equipment for work. - A portfolio for photography and videography for marketplaces is a must!
...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 for text extraction from images. Ability to work with Excel files using Python (openpyxl, pandas). Experience with automating image processing tasks. Strong attention to detail and problem-solving skills. Project Details: This is a freelance task-focused project with flexible variations in screenshots. You’ll need to provide code for both cropping and conversion to Excel. So I can ...
...Edition Minecraft mod developer to create an engaging Adventure/Quest mod. Key Features: - New Biomes and Structures: The mod should introduce various new landscapes and build sites to keep players intrigued. - Unique Mobs and NPCs: I want the mod to include different, engaging characters and creatures that will enhance gameplay. - Custom Items and Weapons: The mod should provide players with a range of specially designed items and weapons to aid in their quests. Ideal Skills and Experience: - Proven experience in Minecraft mod development, specifically for the Java Edition. - Strong understanding of creating and implementing unique game features. - Ability to design interesting biomes, structures, mobs, and NPCs. - Experience in designing custom items and weapons for game use...
I'm in need of a talented social media designer with a penchant for minimalist aesthetics. The project involves creating designs for Instagram, as well as for a range of stationary items including business cards, letterheads, and envelopes. Key Responsibilities: - Design engaging Instagram content - Create designs for business cards, letterheads, and envelopes - Develop minimalist style mockups Ideal Skills: - Proficient in social media design - Experience in designing for stationary - Strong understanding of minimalist design principles Please provide examples of previous work that align with this project.
I'm seeking a professional resume writer to help me create a comprehensive resume from scratch. Given that I'm transitioning careers, the resume needs to effectively highlight my skills as a qualified plasterer and my significant sales experience. The purpose of the resume is to apply for a range of jobs across different sectors. Ideal candidates for this project should have: - Extensive experience in resume writing, particularly for career changers. - A deep understanding of various job sectors. - Excellent ability to showcase transferable skills. - Strong writing skills with a knack for creating engaging content. Ive attached an older resume for reference, aqua bird, eveready and snb plastering is no longer relevant. In the 5 years ive been working for myself plas...
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.
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: Ensuring data accuracy with dropdown lists and validati...
I'm in need of a skilled and creative fashion designer to help me design a collection for a fashion show in Hoi An, Vietnam, scheduled for December 2025. Key Responsibilities: - Design a range of modern/elegant pieces, primarily evening wear with some casual and day wear - Use of preferred fabrics including silk, cotton, linen, wool cashmere, and brocade Ideal Candidate: - Proven experience in fashion design, particularly with evening and casual wear - Strong understanding and ability to create modern/elegant styles - Expertise in working with a variety of fabrics, especially silk and brocade - Ability to deliver high-quality, innovative designs suitable for a fashion show I am looking for someone who can blend creativity with a keen understanding of fashion trends to produ...
Project tasks (Shakespeare & Persuasive Writing, Grade 7): Review curriculum. Select Shakespeare passages; craft comprehension/analysis Qs. Write persuasive prompts; plan structure, rubrics. Differentiate tasks. Peer review & revise. Finalize Q bank, rubrics, teacher guide.
...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 to navigate and understand. 3. **Data Analysis:** - Perform in-depth analysis to identi...
I need a skilled video editor to turn my personal phone video recordings into a 5-10 min family memories video, honouring a loved one who has passed away. Key Requirements: - Selecting highlight moments from the provided footage - Adding soft instrumental background music to the video Ideal Skills a...video editor to turn my personal phone video recordings into a 5-10 min family memories video, honouring a loved one who has passed away. Key Requirements: - Selecting highlight moments from the provided footage - Adding soft instrumental background music to the video Ideal Skills and Experience: - Proficient in video editing software - Experience creating emotional, heartfelt videos - Ability to select meaningful moments from footage - Understanding of pacing and timing in relatio...
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.
...choose and once it has calculated their price, they can add it to the shopping cart. Here is an example of something similar: - The app should incorporate a minimum price, maximum price, maximum size, minimum height, etc. - On the admin side, I need the ability to modify the cost per cubic inch. This should be a fixed price, not dependent on volume range or material type. For example, currently my students pay $0.05 per cubic inch and getting that price is the full reason for needing this app. The ideal candidate for this project should have prior experience developing Shopify apps. They should be proficient in Shopify's API, JavaScript, and Liquid, Shopify's templating language. Understanding of e-commerce pricing strategies and the ability to
I'm seeking a mid-level AWS engineer with a strong focus on S3. I've got a range of tasks that I need assistance with, including data storage and retrieval, managing bucket policy and permissions, as well as data backup and recovery. Support for migration of servers from one entity to another Optimise for efficient running and cost savings 5-10 hours/week Key Responsibilities: - Assist with data storage and retrieval on S3 - Manage bucket policy and permissions - Oversee data backup and recovery Additionally, it's crucial that this engineer is well-versed in general security best practices, as there will be specific compliance and security requirements for the S3 setup. Ideal Skills: - Proficiency in AWS, particularly S3 - Experience with data storage and retrie...
We're looking for skilled affiliates with experience to help convert leads for my physical product. The target demographic is specifically within the 41-65 age range. Key Responsibilities: - Utilize your own tactics to drive sales conversion - Target specific demographics within the given age range - Generate valid leads to increase earnings Compensation: - $30 per valid lead, with potential for increase upon bringing in 5 leads Ideal Candidates Should Have: - Proven experience in Marketing - Expertise in targeting specific demographics - Ability to convert leads into sales Don't hesitate to reach out with any questions. Looking forward to working together!
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
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
