Vba excel lock columns refreshing sheetроботи

...("Demo mode activated") async def real(update: Update, context: ContextTypes.DEFAULT_TYPE): context.user_data["mode"] = "real" await update.message.reply_text("Реальный режим активирован.") ("Real mode activated") # Функции для работы с рынком def get_market_data(symbol): bars = bybit.fetch_ohlcv(symbol, timeframe='1m', limit=100) df = (bars, columns=['timestamp', 'open', 'high', 'low', 'close', '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[...

...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) • Below - at the left photo of the Chef, name of the dish. At the right price (ex. 8.80 € ) and quantity with + and -. • Below (Any allergies, comment...

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

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

Hi, I need php script for Convert large svg (drawing) file to pdf-file For printing on A4 pages and a Tile sheet of paper with repeated pages. php script must split my svg (drawing) to A4 pages and give me printable pdf file You can use my svg file here and will see the result I need the same. You have a remember about the scale, if you have a ruler you can look at squares, each square must be 10x10mm, in the example, you can find nine pages. For testing, I attached svg file and result in PDF file.

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

Transfer news websites advertising texts...

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

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

...will potentially lead to regular work in an exciting, leading edge of blockchain development. I am looking for a long term-relationship with a quality dev to build amazing things. Key features of the application will include: - No user signup, the user only enters their chosen name for their entry to the lotto when sending their ticket purchase: The app will lock all of the users' ticket amounts into a smart contract with time lock and paid out at a specific time every week to a randomly chosen address. - Lottery ticket purchase: The app should facilitate easy and secure purchase of lottery tickets. - Prize payout management: This feature should ensure that the prize payouts are managed in a transparent, decentralised and fair manner. - Shows current total prize fu...

...the output. Query : Query the (14) table to retrieve: Parcel geometries (e.g., polygons or points). All associated attributes for each parcel. Save Data to PostgreSQL: Save the data (geometries and attributes) into a PostgreSQL database. Use PostGIS to store geometries properly. Ensure the schema includes: A geometry column for spatial data. Columns for all parcel attributes. Error Handling: Implement error handling for: Invalid responses from the API. Connectivity issues with the database or API. Documentation: Provide clear instructions on: Setting up the PostgreSQL database (including PostGIS). Configuring database connection parameters. Running the script. Document Python dependencies (e.g., requests, psycopg2, geoalchemy2). Deliverables:

I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better formatting and...

I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills

1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.

It is a busy spell for me, and I haven’t got the time to complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of the questions (70+). Look for inspir...

I need assistance with my Excel workbook. - Software: The data is in Excel. - Tabs: The workbook contains 1-5 tabs. - Specific Columns: Only column D is being checked for hidden text. The project involves going through the rows on each tab and widening the rows in column D so all of the wrapped text can be read.

I'm looking for a one-time web scrape of an eBay page containing 5,500 products. The products do not have any variants, which should simplify the task. Data to be scraped: - Product name, price, category, subcategory, brand - Product description and images The final deliverable should be an Excel/CSV file containing all the scraped data. Ideal skills for this project include: - Proficient in web scraping - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!

I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format ...defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Budget is 30 usd it could lead to long term Please feel free to propose what you think wo...

Bir tane makrolu excel programım var. Birçok şey formüllerle ve makrolarla birbirine bağlı. Excel de boyutu yaklaşık 50mb. 35 civarında sayfa var. Bu exceli olduğu gibi c# ile yazılmış bir masaüstü uygulamasına dönüştürmek istiyorum. Bu konuda proje bazlı bir yazılımcı arıyorum. Herhangi bir yerden fiyat almadım. İlgilenen olursa exceli gönderebilirim.

I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.

I'm seeking a professional designer to create a modern-style template for my Mailchimp newsletter. The design should feature three columns and provide flexibility for content placement, including buttons, images, videos, and hyperlinks. Key Responsibilities: - Design a sleek, modern, three-column Mailchimp newsletter template. - Ensuring the design accommodates various content types; buttons, images, videos, and links. - Incorporate my logo into the design. Ideal Expertise: - Proficient in Mailchimp and newsletter design. - Experienced in modern design aesthetics. - Able to integrate branding elements seamlessly. Content Focus: The primary focus of the newsletter will be articles and news updates. The design should support this content type effectively.

I need a skilled HTML coder who can help me enhance the functionality of my HTML code by adding interactive elements. Specifically, I need to incorporate a few columns into my resume maker HTML code. Ideal skills and experience for the job: - Proficiency in HTML coding - Experience with adding interactive elements in HTML - Ability to understand and modify existing code - Attention to detail

I need a Revit model or Telka Structural Designer model of an existing timber frame based on survey data. The model only needs to include basic structural elements. The survey data is in PDF format, and the focus should be on the main beams and columns of the timber frame. Ideal Skills: - Proficiency in Revit - Ability to interpret survey data - Attention to detail Please include samples of similar work in your proposal.

I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments

I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.

...with the private lending or real estate industry, this is a perfect opportunity for you! Key Responsibilities: Content Creation: -Write professional, compelling email copy tailored to real estate investors and borrowers. - Design engaging visuals (images, infographics) to make emails visually appealing and effective. - Create email campaigns focused on: - Case studies of successful deals. - Term sheet offers and financing options. - Educational content (e.g., private lending tips, real estate financing strategies). SendGrid Campaign Management: - Set up and manage email campaigns using SendGrid’s Marketing Campaigns feature. - Create personalized email templates with dynamic fields for recipient-specific details. - Schedule campaigns and set up automated sequences (e.g.,...

La persona deberá automatizar todas las bases de nomina y prestaciones sociales de los colaboradores en excel

I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, th...

I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. T...defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think wo...

I have a set of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creating int...

Emerging Market Bond Data Extraction Project overview Extraction of trading data for sovereign bonds from specified countries over the last 30 trading days, replicating the structure of an example Excel file. Data needs - Data extraction for last 30 trading days of sovereign bonds from Kenya, Burkina Faso, Sao Tome and Principe (São Tomé-et-Príncipe), Ghana, Liberia, Zimbabwe, Peru, El Salvador, Sierra Leone, and Namibia. - Platforms that may be used include Cbonds, Bloomberg, Refinitiv Eikon, or Market Axess, etc... - Specific data columns required: issue (bond name and detail), date, time of last trade, stock exchange, bid, ask, bid ask spread, min, high, close, indicative and indicative type, volume of transactions in monetary units at par, volume o...

I'm looking for a freelancer who can enter data from an Excel sheet into my e-commerce website. This task involves working with electronics products and requires attention to detail and technical understanding. Key Responsibilities: - Enter product data from Excel(upto 5K data) into the website. - Include all necessary product descriptions, focusing on technical specifications and usage instructions. - Upload product images alongside the descriptions.

...this is a perfect opportunity for you! Key Responsibilities: Content Creation: - Write compelling and professional email copy tailored to real estate investors and borrowers. - Design engaging visuals (images, infographics, or graphics) to make emails more appealing and informative. - Create email campaigns that: - Highlight case studies of successful deals. - Showcase financing options and term sheet offers. - Provide educational content (e.g., tips on real estate financing). Email Campaign Management: - Use email marketing platforms (e.g., Mailchimp, MailerLite, SendGrid) to schedule and send campaigns. - Set up automated email sequences (e.g., follow-ups or drip campaigns). - Ensure each email includes clear CTAs (e.g., schedule a call, request more info). Campaign Optimiz...

I need assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so ...assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so some preliminary data processing may be needed. Skills and Experience Required: - Extensive knowledge and experience with Magento is essential. - Proficiency in data processing and Excel is required, as the product information will need to be formatted for Magento. - Attention to detail is critical to ensure all product information is uploaded ...

I'm seeking assistance in creating an Excel spreadsheet dedicated to customer data entry. The primary focus will be on tracking customer contact details. Key Requirements: - Proficient in Microsoft Excel - Experience in data entry - Ability to maintain accuracy and confidentiality Ideal Skills: - Data Management - Attention to Detail - Proficiency in Excel Functions and Formulas

I'm a concert pianist seeking a professional Wix developer to revamp my website. It already exis... with the addition of a Media/Listen page akin to that features my Spotify recordings. Site Sections: - Biography - Concert Schedule - Media/Listen Page - Gallery - Editions - Contact Key Requirements: - Multilingual: English, Portuguese, Spanish - Clean, modern design - Integration of newsletter signup, event booking, and an online store for sheet music or recordings Skills & Experience: - Proficiency in Wix - Web design experience with a modern, clean aesthetic - Multilingual site development - E-commerce integration - Experience with audio embedding from Spotify I will provide all necessary materials. Thank you for your interest.

I have over ten Excel files containing sales figures organized by product. All these files have the same format, making them straightforward to merge. I'm seeking a freelancer who can expertly consolidate these files into one comprehensive total sheet. Ideal Skills: - Proficient in Excel - Data Analysis - Attention to Detail - Experience with Data Consolidation

I'm seeking a detail-oriented freelancer for data entry of a food menu in an Excel sheet. The task involves cataloging items with their name, price, and description. Key responsibilities: - Accurately inputting data into an Excel sheet - Finding and selecting appropriate images from stock photo websites - Ensuring descriptions are correct and relevant Ideal skills: - Proficiency in Excel - Strong attention to detail - Experience with data entry tasks - Ability to source relevant images online We shall be sharing a PDF menu card rest all to be done

I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience in creat...

I need a meticulous professional to assist with data entry from scanned documents. The data consists of both text and numbers, and needs to be accurately transferred into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Prior experience with data entry from scanned documents - Ability to handle mixed data types (text and numbers) - Strong organizational skills

Tengo experiencia en auxiliar administrativo. Recepción de llamadas , emails, asesoría , conocimiento en office , Excel , Word entre otro. Conocimiento en programas de inventario . Resolución de problemas y pqr

I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. T...defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think wo...

I need assistance with an Excel task. The project involves adding rows in Excel based on a specified number in a cell. Key Requirements: - Adding new rows containing specific formulas - Ensuring that the formulas in the new rows reference fixed cells Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in working with Excel formulas - Detail-oriented with a good understanding of fixed cell references in Excel

I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. T...defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what you think wo...

I need a Pyspark code that reads join rules from a txt file and applies them in the main program. The joins will be based on multiple columns, with the rules formatted as column names with conditions. The code should only implement inner joins. Ideal candidates should have comprehensive experience in Pyspark, understand how to manipulate data frames, and can write clean, efficient code.

...seeking a developer to create a dual-platform app (iOS and Android) for controlling smart locks. This app should include essential features like remote locking/unlocking, scheduling access times, and receiving notifications on lock status. Key Features: - Control smart locks: The primary purpose of this app is to manage smart locks. - Multi-platform: The app should be compatible with both iOS and Android. - Essential Lock Control Functionalities: The app should enable users to lock/unlock remotely, schedule access times, and receive notifications on the status of the lock. for example, we need 1. To be able to create a code of x digits to open the locks from/to from/to 2. We need to be notified when a customer makes the 1st access to the room 3. to know i...

I need a professional who can help me send my HTML form data to a Google Sheet via Google Apps Script without messing with my existing HTML form code. Key Requirements: - Expertise in Google Apps Script - Proficient in HTML and JavaScript - Experience in integrating HTML forms with Google Sheets - Ability to work with existing code without disruption Details: - I have a Google Sheet already set up to receive the data - I need all data fields from my HTML form to be sent to the Google Sheet Please ensure that you don't alter my original HTML form code.

...creating compelling social media posts that resonate with target audiences. In addition to my writing expertise, I offer video editing and creation as a secondary skill, allowing clients to develop content from script to screen. My experience spans editing explainer videos, social media content, and ads, allowing for a seamless process that strengthens your brand’s message. As a Virtual Assistant, I excel in efficiently managing administrative tasks, from email management to digital marketing. My expertise in social media marketing is particularly beneficial for managing e-commerce sites and ad campaigns, boosting conversions and brand visibility. I’m committed to delivering exceptional service, ensuring every project meets the highest standards. Let’s collab...

We need to set up a progress plan and resource plan in google sheet. This is quite similar to MS project or Smartsheet, and many other tools. But we need this in google sheet, where we also need to be able to easily see where the resources are, shown as both a timeline / gantt, and in calendar view. This means that we must be able to choose between the project list and the resource list in terms of display, and here we can choose between seeing it as a timeline and a calendar. Need it done asap. See attached screenshots.

...developer to extend this cursor with additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsheet. • Update a different table using simple IF conditions based on the calculated values. • Ensure the solution is optimized fo...