Excel vba automatically run scriptроботи

Using this Google Sheet: Need a python script that will run daily on an Ubuntu server which takes the items on the iPhone Used tab of this sheet and uploads them into 2 mysql database tables. The first table will be called item_prices with the following columns: model, capacity, carrier, swap, grade_a, grade_b, grade_c, grade_d, doa. Using this row as an example: iPhone 16 Pro Max 256GB Unlocked $925 $915 $895 $715 $335 $200 The data in each column would be as follows: model (char): iPhone 16 Pro Max capacity (char): 256GB carrier (char): Unlocked swap (smallint): 925 grade_a (smallint): 915 grade_b (smallint): 895 grade_c (smallint): 715 grade_d (smallint): 335 doa (smallint): 200 The

I need a professional to automate my FME workflow, focused on integrating data from various spreadsheets into a cohesive dataset. The primary type of data is tabular, and the main goal of this project revolves around efficient data integration. Ideal Skills: - Proficiency in FME (Feature Manipulation Engine) - Extensive experience with tabular data - Compete...Knowledge of ETL (Extract, Transform, Load) processes - Proficiency in scripting languages such as Python or R Experience: - Prior work with FME workflow automation - Proven track record of successful data integration projects - Experience in handling large sets of tabular data from spreadsheets. The final integrated dataset should be provided in CSV format. The workflow should include **using Excel** to address data incons...

...expert in Smart Sheets and Excel to help with project management, focusing on sales data analysis. The ideal candidate will have experience with task assignment and tracking functionalities, as well as setting up automated reporting systems. Key Responsibilities: - Utilize Smart Sheets and Excel for effective project management. - Analyze sales data to inform project progress and strategies. - Set up systems for task assignment and tracking. - Implement automated reporting to streamline project updates. - Ensure seamless integration of Smart Sheets and Excel with CRM systems. - Create visually engaging dashboards for sales data visualization. - Develop custom reports based on specific project needs and metrics. Skills Required: - Proficiency in Smart Sheets and ...

I'm seeking a Python developer to modify my existing Telegram bot. The task involves creating a code that automatically uploads products from AliExpress to my Telegram channel every 15 minutes. Each post should include an image, product title, details, price, and my affiliate link. Key Requirements: - Modify an existing basic Telegram bot - Use of AliExpress API for product sourcing - Schedule posts at 15-minute intervals Ideal Skills: - Proficient in Python - Experience with Telegram bot development - Familiar with AliExpress API - Knowledge in scheduling tasks in Python

I'm looking for an Excel wizard to create a single-sheet, all-inclusive spreadsheet for tracking packing efficiency. The sheet should be able to calculate how many boxes are packed per hour based on inputted data. Key Features: - The spreadsheet will need to incorporate different box types and their worth. For example, "1.5 ctn worth 1 box" and "dishpack ctn worth 3 box". - It should be able to generate the total number of boxes packed per hour based on how many of each box type is packed. - Conditional Formatting will be used for clarity. The ideal freelancer for this project should have extensive experience with Excel, particularly with creating sophisticated formulas and using Conditional Formatting. A good understanding of logistics and packin...

I need help updating my weekly Profit and Loss statement. The process is quite nuanced, and I will need to communicate with you regularly. The task involves gathering data from various sources. Data Sources: - Internal...with you regularly. The task involves gathering data from various sources. Data Sources: - Internal company databases - External financial portals - Spreadsheets from different departments Data Format: - Primarily in Excel spreadsheets Your Tasks: - Data entry and consolidation - Data analysis and interpretation Once you become proficient and knowledgeable about the process, it should take no more than 2 hours per week. However, I need assistance every week. Ideal candidates should be experienced with data analysis, have a keen eye for detail, and be proficient...

I'm seeking an expert in Excel automation who can help streamline my inventory management process. Key Requirements: - When a dropdown in a specific cell is selected, the corresponding entire row should be moved from the current sheet to a designated other sheet. - The automation should be seamless and efficient to ensure smooth operation of the inventory tracking process. Ideal Skills: - Proficient in Excel, including knowledge of advanced functions and capabilities. - Experienced in automating tasks within Excel. - Familiar with inventory management systems or processes.

I need a freelancer to assist with a small project focused on gathering and entering data from various research sites. The task primarily involves collecting textual information from these sites. Ideal Skills: - Excellent attention to detail - Proficiency in data entry - Familiarity with research websites The process will...research websites The process will involve: - Simple text extraction from identified research projects across several different websites. Your role will be crucial in helping me compile this information accurately and efficiently. The estimated volume of data collection is medium (101-500 entries). Please enter the collected data into a spreadsheet format. Please enter the collected data into an Excel spreadsheet. The expected time frame for this project ...

I'm in need of a skilled WordPress developer who can create a custom plugin for me. This plugin should replicate the functionality of importing an Elementor kit, which is usually exported from Elementor's tools, dynamically. Key Requirements: - The plugin must automatically integrate with our website builder. - It should support automatic imports triggered by specific events, with the first event being the activation of the plugin. - The plugin needs to be robust, with good error logging and debugging capabilities. I've tried using the Elementor API, but it doesn't provide the necessary functionalities. While wp-cli can import the kit, it cannot do so dynamically from a plugin. This is where I need your expertise. The ideal candidate will have extensive experie...

I need a Python program that will analyze my Excel data for me. The file has 10,000 rows and 40 columns. The program should: - Examine a specific range within column B and extract all numerical values from the text of each line. - Create a new Excel sheet where these numerical values are inserted into one or several columns adjacent to column B. - Retain all other columns from the original sheet in the new one. Additionally, all numerical values need to be converted to decimals before being inserted into the new sheet. The ideal freelancer for this project should have: - Expertise in Python programming, particularly with data analysis and Excel manipulation. - Experience in writing Python scripts for Excel. - Ability to convert numerical values into decimal...

I'm seeking an expert with experience in Tradingview and Pinescript to help me extract the source code from an Invite-only Tradingview script. My primary goal is to study the code for learning purposes, particularly focusing on understanding custom indicators and signals. Key Responsibilities: - Use appropriate tools (like Chrome debugger) or something else ( I DO NOT KNOW) to extract the source code from the private script - Provide the unmodified source code and, if possible, a brief explanation of the key components Ideal Skills: - Proficient in Javascript and Pinescript - Familiar with Tradingview platform and its functionalities - Previous experience in decompiling or extracting source code from private scripts is a plus - Ability to explain complex code in simple...

...professional typist who can accurately transcribe my handwritten notes into an Excel spreadsheet. This will involve using specific formulas within the spreadsheet. Ideal Skills and Experience: - Proficient in Excel, with a solid understanding of how to use formulas - Exceptional typing skills - Detail-oriented and capable of accurately transcribing handwritten notes - Previous experience with data entry - Ability to maintain confidentiality and handle sensitive information with discretion The typist should use SUM and AVERAGE formulas in the spreadsheet. The project involves less than 50 handwritten notes. The handwritten notes follow a specific structure. The handwritten notes do not require any specific formatting in the Excel spreadsheet. The project needs to b...

I am looking for a professional with expertise in Power Automate to help me extract data from two sources: an auction website and a real estate website (Zillow or ). The final output should be an Excel spreadsheet containing the extracted data as described below. Key Tasks: Auction Website (Grey Columns) Extract all the data from the grey columns (as per the attached example) on the Atlantic County and Cape May County auction websites. The data should be saved in an Excel spreadsheet. Each county’s data should be saved on a separate tab or a separate file. Real Estate Website (Purple Columns) For each property listed on the auction website, match its address with the details available on either Zillow or Realtor.com. Extract all the columns in purple (as per the attache...

...server_input_bitrate server_memory_usage server_online_streams server_opened_files server_output_bitrate server_scheduler_load server_started_at server_total_clients   available raw Stats - stream-directly provided from flussonic stream_bitrate stream_bytes_in stream_bytes_out stream_client_count stream_online_clients stream_retry_count stream_out_bandwidth Available raw Stats - session- using a script to convert API output to metric for anything that is not in the above lists. We need to use this method session_bytes_transferred   •    2.  sessions_count To get a dashboard for: Report network consumption zerolatency base GB Per account Possible to manage sub-account And for each, we need to have it Origin Amount data t...

...automated video creation scripts. The goal is to create marketing videos using various templates, where data from a .txt file is used to generate videos. Each template should have its own script for simplicity. Key Requirements: Expertise in Python and MoviePy Ability to create video slideshows from images in a folder Integration of text overlays, transitions, and background music into the videos Familiarity with video editing and template creation Proficiency in custom animation effects within MoviePy Details: The process should be as simple as running the script for each template. Each template script should adhere to existing branding and style guidelines. A sharp eye for detail and the ability to follow guidelines is essential. Prior experience in creating ma...

formatoExcel={ 'A':{'encabezado':'Contacto', 'patron':[]}, 'B':{'encabezado':'Fecha', 'patron':[]}, 'C':{'encabezado':'Hora', 'patron':[]}, 'D':{'encabezado':'Mensaje', 'patron':[]}, 'E':{'encabezado':'Es renta', 'patron':['(rent(a|o)|for rent)']}, 'F':{'encabezado':'Es venta', 'patron':['(ven(ta|do)|for sale)']}, 'G':{'encabezado':'Es Demanda', 'patron':patronesDemanda}, ...

I need a Python expert to help create a script for me. Please go through the file attached for job description

I have a pre-made script initially designed for writing services. The script currently includes predefined forms for collecting client information, which need to be removed. Instead, I need a custom form builder feature that allows the admin to create and manage custom fields for each service. The collected details should be viewable on both the admin dashboard and the Chartered Accountant dashboard. Project Requirements: 1. Remove Predefined Forms Completely remove the existing predefined forms from the script. 2. Implement a Custom Form Builder 2. Integrate conditional logic to show or hide fields based on previous responses. 3. Enable custom validation rules for each form field (e.g., regex patterns, range checks). Admin should have the ability to: Create service-s...

...intuitive interface and robust features make it suitable for beginners and professionals alike. Why Website Speed Matters 1. Improved User Experience: Faster websites reduce bounce rates. 2. SEO Benefits: Speed is a Google ranking factor. 3. Increased Conversions: Quick-loading websites improve customer retention and sales. --- Key Features of WP Rocket 1. Page Caching WP Rocket automatically enables page caching upon activation, reducing server load and ensuring faster page load times. 2. GZIP Compression It compresses web files, reducing file size and improving load times without compromising quality. 3. Database Optimization WP Rocket cleans up unnecessary data like old drafts, revisions, and spam comments, enhancing database performance. 4. Lazy Loading for ...

1. Add SMS alerts sent to 512-636-3628 and 512-626-9167 2. "Avoid fetching duplicated tweets. Scrap only new tweets since last time scrapped to avoid fetching" 3. "Create a script for it so as soon it removes the script running , script will auto rerun it "

I need a freelancer to create a tailored open sales and quote report for me. This report should combine both sales and quote data, and be delivered in an Excel spreadsheet. Key elements to be included in the report: - Customer details (name and state) - Product details - Pricing and totals - Expected order date - sales person estimate chance of closing quote An ideal candidate for this project would be someone with strong skills in data analysis and Excel, as well as experience in sales and quote reporting. Please create a custom layout that is easy to navigate. Please use a tabular format for the layout. Include options to filter by date. Exclude visual elements like charts and graphs. The report should be grouped by chronological order.

I'm looking for a skilled Python developer who can help create a script for NBA 2K on Windows. The primary objective of this script is to identify the release green cue for shooting without the meter. Key Requirements: - Proficient in Python, with experience in game scripting preferred. - Familiar with NBA 2K gameplay mechanics. - Excellent understanding of time-based analysis methods. The ideal freelancer will have a keen interest in basketball gaming and an ability to translate that into a practical, effective script.

I'm looking for an Excel template that can comprehensively record and track class-wise fees. The template needs to encapsulate the following aspects: - Fee Receival Details: The template should allow me to log the date and mode of payment (cash or online), the amount and balance, as well as class and student information for each fee received. - Expense Tracking: It should also track our expenses, including supplies and materials, salaries and wages, as well as maintenance and utilities. - Pending Fees: The template needs to show pending fees month-wise and class-wise. - Master Sheet: The master sheet should provide an overall report, class-wise dues, and breakdowns for total dues and total paid, as well as payments made via cash and online. Ideal skills for this project i...

I'm looking for a simple Google script that will: - Duplicate data from Sheet 1 to Sheet 2. - Compare the data and export unique text values to Tab 1 and Tab 3 in a table format. - Integrate with ChatGPT to rewrite existing titles and descriptions. The script will need to run daily. The ideal freelancer for this project should have strong experience with Google scripts and API integrations, particularly with ChatGPT.

I need a bot designed to execute market orders automatically on Uniswap. This bot should be capable of executing trades in response to real-time price changes on Dexscreener. Key Requirements: - The bot should be designed to automatically execute market orders on Uniswap. - It needs to operate using data from Dexscreener. - It should be able to monitor price changes and respond accordingly. Ideal Skills and Experience: - Proven experience in developing trading bots, particularly for decentralized exchanges. - Familiarity with Dexscreener and its API. - Expertise in implementing market order strategies. - Strong programming skills, preferably in Python or JavaScript. Please provide examples of relevant projects you've completed in your bid.

...empresarial. Experience with Microsoft Teams for communication is preferred. The assistant will use Microsoft Teams for communication. The assistant should have advanced skills with Microsoft Teams. An expert level of familiarity with accounting principles is expected. The assistant will generate a daily summary report from the verified payments. The assistant should be proficient in Microsoft Excel. An expert level of familiarity with accounting principles is expected....

I need a form that saves data from a form in a excel database

...will specifically appeal to potential investors. Ideal skills and experience for the job: - Proficiency in graphic design software (e.g., Adobe Illustrator, Photoshop). - Previous experience creating infographics, especially for investment purposes, would be highly beneficial. - Strong ability to translate complex data into visually appealing and easy-to-understand graphics. - Familiarity with Excel and the ability to work with data from this software. - Excellent understanding of minimalistic design principles. - Expertise in data visualization techniques to represent complex revenue data effectively. Please use our corporate colors for the infographic. The infographic should include charts to present the data. The final deliverable should be in PDF format and include an edita...

I'm seeking an Excel expert to update a commercial real estate model. The updates primarily involve financial projections, and the tweaking of formulas and calculations. Key Tasks: - Adjust financial projections to reflect new market conditions - Review and correct formulas and calculations as necessary - Ensure the model is compatible with a customized company template The most critical financial metric that needs to be accurately assessed in this model is the land acquisition and lending criteria. Ideal Skills: - Extensive experience with Excel, particularly in financial modeling - Understanding of commercial real estate metrics and valuations - Ability to work with and adapt to a specific company template - Strong attention to detail to ensure all calculations an...

I need help analyzing a dataset in Excel. The project involves answering five simple questions using charts. You will need to provide the raw data file with all formulas, pivots, etc. Key tasks: - Use charts for data visualization - Focus on comparing different categories - Create a comprehensive and insightful analysis Ideal skills and experience: - Proficient in Excel with strong data analysis skills - Able to create clear and informative charts - Good understanding of category comparisons in data

ho bisogno di uno script in php per poter utilizzare l'api browse di ebay lo script deve restituirmi l'elenco di prodotti passando una variabile con il testo da cercare

...experienced freelancer who has a wealth of knowledge with PDF documents and office softwares such as Word and Excel. Here's what I need from you: Task 1 - Our current proposals we send out to clients were created in Indesign however they do not work with our CRM system, so therefore we need to create these same designs in word which will work with our CRM system. Converting the PDF documents into a word document could be one easy fix, or redesigning the original design into Word would be another option. I will leave that to your expertise. Task 2 - We currently send out a form which was created in Word to our clients to fill and send it back. We need to redesign this form in Excel, we need it to look luxury and high quality (similar to proposal documents) The fo...

...second. The expected cash flows during operation are 30,000 PLN in the first year and 40,000 PLN in the second, followed by a sale of the factory for 1.2 million PLN at the end of the second year. Your deliverable will be a detailed IRR calculation in an Excel spreadsheet, as well as a report justifying the investment based on your analysis. You will need to consider the appropriate discount rate, with WACC at 12% and CAPM at 14%. Ideal candidates will have: - Strong background in finance and investment analysis - Proficiency in Excel for complex calculations - Ability to present findings in a clear, concise manner. Zadanie nr 5 - IRR Inwestor zamierza wybudować fabrykę. Wyda na ten cel 1 mln zł, przy czym tylko 30% środków będzie pochodziło z kapitału wł...

...and a knack for storytelling through visuals. Key Details: - Animation Style: The project is specifically geared towards a cartoon-style animation. Previous experience or a portfolio showcasing similar work would be highly advantageous. - Script: I have a complete script ready for the animation. This will be provided in its entirety. - Duration: The animation will need to cover a timeframe of approximately 10 to 15 minutes. Ideal Skills: - Proficiency in 2D animation software - Prior experience with cartoon-style animation - Ability to translate a script into engaging visuals - Attention to detail and commitment to quality - Skill in designing unique and expressive cartoon characters. - Ability to sync animated characters' movements with voice-overs. The ta...

I'm looking for an Excel wizard who can create an efficient drop-down menu tool for me. This tool will be used for data selection, with over 50 options in the drop-down menu. The project involves: - Designing a user-friendly drop-down menu with more than 50 options for data selection. - Implementing a reset button that restores default selections when clicked. Ideal skills for this project include advanced Excel knowledge, particularly in creating drop-down menus and implementing macro buttons. Experience in creating user-friendly Excel tools is a plus. The drop-down menu should include additional features to enhance functionality.

I would like a pivot points script on Tradingview. Standard pivot points I want a code that by default displays: monthly pivot points weekly pivot points daily pivot points and for each: R1, R2, Pivot, S1, S2. (other desactivate) for the monthly I want by default large lines like undescore for the weekly, lines like the dash spaced by the width of a dash for the daily small dashes. in fact, exactly like Prorealtime. By default the resistances in red, and the supports in green. The pivot would be in black if the theme is light, and white in dark mode. the colors and types of lines must be modifiable. The pivot types must be able to be disabled to have for example only the monthly and weekly, or the monthly and daily, etc... The default calculation must be from 00:00 to 23:59 but we...

...textile weaving sector to develop a comprehensive Excel sheet for production planning and lead time management. Key Requirements: - Expertise in resource allocation, inventory management, and scheduling within the textile industry - Ability to create an Excel sheet that generates daily production reports, inventory status reports, and lead time analysis reports - Proficiency in incorporating automatic calculations, data visualization (charts/graphs), and customizable templates into the Excel sheet Your experience in the textile weaving field will be crucial in tailoring this Excel sheet to meet the specific needs of our production line. This project would ideally suit a freelancer who can combine their industry knowledge with advanced Excel skills to...

Project Details I am seeking a talented freelancer with strong web scraping skills, preferably in Python, to assist with a project involving two specific websites initially. There is potential for more sites in the future. I will provide the specific data fields that need to be extracted. Key Requirements: - Proficiency in web scraping and/or Python. - Familiarity with MS SQL Server databa...like to be able to manage the code with your ongoing assistance. You will be responsible for providing the source code, documentation, and deployment information, and will be available to assist with deployment. I would appreciate a step-by-step walkthrough of the code so that I can fully understand it. The extracted data should be delivered and stored in an MS SQL database. I can supply the DB s...

I need a skilled freelancer to create a PDF legal contract using our Excel template. The document should incorporate our branding elements, specifically the logo and color scheme. Excel doc proposed template PDF original template

Check the attached document for a better overview of the project info! We are seeking an experienced UiPath freelancer to develop workflows for extracting data from Excel, PDF, Word, and Email files, converting it into structured formats (e.g., JSON, CSV, XML). This project serves as the foundation for a broader workflow automation initiative. If successful, there will be opportunities for ongoing development work to expand and enhance the system. Provided Tools We will supply: UiPath Pro License: For workflow development. UiPath Document Understanding: For advanced OCR and document processing. Proposal Submission Guidelines Freelancers are invited to submit proposals incorporating an hourly rate for the project. Along with your hourly rate, please provide the following details fo...

Necesito un bot para automatizar el poner reseñas de Google Maps. Cogería los datos desde una lista de excel, el nombre de la empresa, el texto para la reseña y la valoración en estrellas.

I have a Playwright script that works perfectly on my local machine, but I'm running into timeout issues when running it on Google Cloud Run. The timeout consistently occurs while the script is attempting to navigate pages. The ideal freelancer for this project should have: - Extensive experience with Playwright and Google Cloud Run. - Proven track record in debugging and optimizing scripts for cloud environments. I need this issue resolved as soon as possible, so prompt communication and a quick turnaround are appreciated.

Let me be clear from the start and to avoid embarresment and waste time NO ASIANS NO ASIAN ACCENT NATURAL ENGLISH OR AMERICAN/CANADA I am looking for a telemarketer with a great track record at getting app...free for 45 days by simply clicking here. We are currently running a xmas special where they can try for free for 45 days. However once they are on the trial follow up calls will be required to make sure they are trying it, what they like etc and try to get them to subscribe. Our prices are very competitive and should be a no brainer. I can discuss info to help you formulate a script. Please respond with any questions. The leads I can supply have already been Mailed by Mailchimp recently. I would prefer to have a zoom call to hear your voice and discuss in more depth.

...screenwriter to help me craft a compelling film script in the drama genre. The film's central narrative revolves the complexities of love and relationships, and the intended mood is bittersweet. WWII era. Ideal candidates for this project should: - Have a strong background in screenwriting, particularly in the drama genre. - Demonstrate a deep understanding of and ability to portray the nuances of love and relationships. - Be skilled in creating a bittersweet tone without veering into overly tragic territory. - Possess knowledge of the WWII era to ensure historical accuracy. Please include samples of your previous work, ideally within this genre and mood, in your application. I'm looking forward to your creative proposals. The script should be format...

I need to create a m3u with a list of channels (urls). Some of them has security tokens that change every day, i need a way to automatically detect the new url and add to the m3u

I recommend having OCR Sk...recommend having OCR Skills as its a reasonable amount of data Convert 12 PDF bank statements into a single CSV file. The details to be included in the CSV are: Date, Description, and Amount. Spreadsheet and first statement of 12 attached. IMPORTANT 1. Electronic Deposits and Credits would go under the DEPOSITS column in Excel for the amount 2. Electronic Payments, Service Charges, Other withdrawals and Checks paid would go under WITHDRAWELS column in excel for the amount Ideal Skills: - Proficiency in OCR, data entry and PDF to CSV conversion - Attention to detail to ensure accurate data transcription - Experience with handling financial documents Please note, there is no need for categorization of transactions. All 12 statements are i...

Regular excel reporting project ( weekly basis payment). Details discussed via PMB.

ONLY WHO IS ABLE NOW. I enter an appointment into the system in Zoho crm and have to automatically view it in the calendar I don't understand why it doesn't work for me

...startup and need a comprehensive financial model in Excel for the next 5 years. The model should incorporate all the classic components typical of standard financial models, including charts for key metrics. Key aspects to include: - Revenue and expenses - Churn rate - Growth (sales, clients, turnover, profit) - Discounted cash flow - anything else typical being part of financial models for startups I will provide basic data for calculations. If anything is missing or unclear, you're expected to reach out and ask for additional input. The model should account for 3 revenue streams, which I'll detail. Ideal candidates should have: - Strong background in finance and financial modeling - Experience with SaaS businesses - Proficiency in Excel - Ability to communic...

As discussed, I'll do the conversion from PDF to Excel for the file you have shared.