Excel macro upload data websitepráce
pasar informacion a excel. pasar informacion a excel
Pro pracovní projekt potřebuji zajistit webscrapping jedné webové stránky (nejlépe pomocí Octoparse) vytvoření dvou relačních databází (malé datové sety, jedny jako výsledek webscrappingu, druhé dvě Excel tabulky) pomocí SQL, včetně jednoduché prediktivní analýzy, a grafické zobrazení dashboardu v Power BI. Dat je málo, tedy věřím, že pro zkušeného datového analytika je to práce max. na pár hodin, mně to však velmi pomůže.
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
Jedná se o vytvoření ekonomických posouzení investic do realit. Po vzájemné dohodě dojde k zadání základních parametrů a informací, které je zapotřebí posoudit pomocí ekonomických ukazatelů jako jsou IRR, CASH FLOW, YIELD, ROI, ROE. K tento činnosti je nutné perfektně ovládat Excel a mít vzdělání ekonomického zaměření ideálně se zaměřením na realitní trh a investice na tomto trhu.
Krátkodobá a dlouhodobá půjčovna elektromobilů: - Datábáze vozidel (současná evidence v excelu) - Databáze zákazníků (CRM) - Automatizované vytváření dokumentace: smluv, předávacích protokolů, fakturace, pojistných smluv a jejich následné zálohování. Současně používáme Excel a Word. Cíl je mít centrální přehled a systematičtější postup. Ideálně i jako cloudové řešení.
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
Moodle online learning, PhP. files will be provided
Dobrý den, potřebuji naprogramovat makro dle zadání v Excel příloze. Chtěl bych to rozložit na 2 části. 1: dle zadání v excelu 2: později po domluvě dodělat výstup na tiskárnu etiket
Mám pokračující práci vztahující se k předchozímu projekturemote Upload videos form server to youtube'
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
I require a detailed and accurate excel typist with a strong background in financial data analysis specifically in calculating profit margins. This person should: - Have strong excel typing skills for efficient data entry - Be knowledgeable in financial data analysis - Be able to interpret and analyze profit margins effectively - Have logical data organization skills to improve the overall workflow This role is essential for understanding and monitoring the profit margins of my business. Accurate analysis will aid in making strategic business decisions. Your expertise in handling financial data is highly valuable for this role.
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I am looking for a highly-skilled Wordpress website designer and builder. The purpose of this website is to sell products or services. Design-wise, I'm open to creative interpretation giving you the freedom to design with your professional touch. However, it has to be responsive, and hosted on Bluehost. In terms of structure, it will consist of a Homepage, a Job Board using the WP Job Openings plugin, and 4 subpages for each of our services. To facilitate user engagement and lead generation, the design must incorporate user form fields and an option to subscribe. A blog section for sharing news and updates is also integral to this project. Skills critical for this project include Wordpress, Bluehost, and the ability to design user-friendly interfaces with well-struc...
...expert in Excel data entry to assist me with a project. The job primarily involves: - Text data entry: Entering textual information into Excel. Accuracy is crucial, as even minor errors can greatly affect the output. - Data categorization: Organizing the entered data into different categories within the sheet. The ability to understand and sort data effectively is key. - Basic data visualization: I'd like the data to be presented visually. The freelancer should be able to create and include simple charts or graphs to represent the categorized data effectively. Ideal Skills: - Proficiency in Excel: A deep understanding of Excel and its functions is essential. - Data Entry: Previous experience...
I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.
...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding...
I need a meticulous freelancer to help with my data entry task. The specific requirements are as follows: - The primary task is entering textual information from scanned documents into an Excel sheet. This includes typing out the text exactly as it appears on the scanned document. Applicants should have: - Proficiency in data entry, especially text-based information - A keen eye for detail and accuracy - Experience working with scanned documents - Proficiency with Excel This is a straightforward project, but attention to detail is crucial. I will provide the scanned documents, and I expect the data to be entered accurately and efficiently.
We need a report which works like that: We upload a list of EAN Codes to system. System give us back: - EAN - ASIN - BuyBox Price - Who is a seller - Sells in 30, 60 90 days
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...
...Android along with a corresponding Laravel website. This app will function as an online job and vacancy platform. The app will also need to have a same Laravel admin panel to manage the all Android, IOS apps and website easily. Key Functionalities: - Implement User Registration and Login to enable job seekers and employers to create accounts and access the platform - Job Search and Filtering, enabling users to search for jobs based on different criteria - Apply for Jobs feature allowing job seekers to apply directly for the positions they are interested in Additional Features: - Push Notifications are to be integrated into the app to keep users informed about relevant updates - The app will have a Resume Upload and Storage feature allowing users to upload ...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tracked include the part number, description, supplier information, purchaser details, condition, make, model etc. In the curren...I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to implement basic security requirement such as restricted access to webpages, 2 user roles, keeping data...
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...
The purpose of this project is to create a detailed, technical drawing using SolidWorks 2022. The emphasis of the project is documentation of plastic parts, both on a macro and micro-level. Key Requirements: - Able to generate technical drawings that include overall dimensions, shapes, specific features, and tolerances of plastic parts. - SolidWorks 2022 ONLY!! - Extensive experience and understanding in documentation of manufacturing processes and components - Expertise in rendering intricate details of plastic parts - Must be able to abide by all requirements for precision-driven, technical documentation - Detailed and clear communication The ideal candidate will have a background in mechanical engineering or a related field, as well as experience in creating detailed, techni...
Are you a Vesta Panel expert? Ok Then help me upload a simple 1-page WordPress site to my server & connect to the domain name Hosting is Digital Ocean with Vesta Panel
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.
I have an Excel sheet that requires daily data analysis using statistical methods. Key requirements: - Daily updates: The data in the Excel sheet will need to be analyzed using statistical methods and techniques on a daily basis. - Statistical Analysis: The main focus of the analysis will be on statistical methods. You'll be required to utilize various statistical tools to interpret the data and provide insights.
I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
...mobile app developer who can create a comprehensive social networking application similar to Tiktok that supports both iOS and Android platforms. Key features: 1. Messaging: Implement a robust messaging system that supports real-time communication between users. 2. Photo Sharing: Allow users to upload, share and comment on photos within the app. 3. Event Planning: Enable users to create, discover and RSVP to events within the app. 4. Video Sharing: Implement video sharing functionality for users to upload, view and interact with videos. Ideal skills and experience for this job include: - Proven experience in developing social networking applications - Expertise in iOS and Android app development - Strong understanding of messaging and media sharing functionalities - Ab...
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in...
I am looking for a detail-oriented professional to assist me in transcribing text data from Word Documents into an Excel sheet in alphabetical order. Specifically, you will be: - Handling text data from Word Documents - Accurately typing this data into an Excel sheet - Organizing this data alphabetically to aid in easy referencing Experience with data entry and a strong grasp of Microsoft Word and Excel is mandatory. I expect high attention to detail to ensure accuracy in data transcription and organization. Please submit your proposals detailing your relevant experience.
...between: Abed Tahan, represented by Samira Tahan, hereinafter referred to as "Client", and DINOTECH SOFTWARE SOL, represented by Harshit Sharma, hereinafter referred to as "Developer". WHEREAS, Client desires to have a website developed on the Magento 2 platform, and Developer desires to provide such services. NOW, THEREFORE, in consideration of the mutual covenants contained herein, the parties agree as follows: 1. Services Developer agrees to provide the following services for the Client's website: Magento 2 Site Backups: Regularly upload backups of the Magento 2 website to a test server. Feature Development: Develop any new features requested by the Client. Design Changes: Implement any design changes requested by the Client. ...
Simple concepte with customer account who permit to upload document and put timeline
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
...between: Abed Tahan, represented by Samira Tahan, hereinafter referred to as "Client", and DINOTECH SOFTWARE SOL, represented by Harshit Sharma, hereinafter referred to as "Developer". WHEREAS, Client desires to have a website developed on the Magento 2 platform, and Developer desires to provide such services. NOW, THEREFORE, in consideration of the mutual covenants contained herein, the parties agree as follows: 1. Services Developer agrees to provide the following services for the Client's website: Magento 2 Site Backups: Regularly upload backups of the Magento 2 website to a test server. Feature Development: Develop any new features requested by the Client. Design Changes: Implement any design changes requested by the Client. ...
Develop Website - Description: Create a comprehensive website called with functionalities similar to , incorporating an integrated database where vendors can list their car parts and customers can search for parts using their vehicle's VIN number. Requirements: 1. **Vendor Listing System**: - Implement a user-friendly interface for vendors to register and list their car parts. - Allow vendors to upload images, specify details, and set prices for each listed part. - Ensure secure login and registration functionalities for vendors. 2. **Vehicle Identification via VIN**: - Develop a VIN lookup feature enabling customers to input their vehicle's VIN number and retrieve a list of parts compatible with their vehicle. - Utilize
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...develop a comprehensive mobile application and a supporting website. This application is designed to cater to a diverse audience. The project will include features for content creation, management, and user engagement through intuitive interfaces. 1. Project Objectives: - Develop a dual-platform mobile application compatible with iOS and Android. - Establish a minimalistic website for administrative purposes and to serve as a marketing portal. - Provide a seamless user experience akin to popular media streaming services like Netflix. - Construct a scalable and secure backend architecture utilizing Google Cloud Platform (GCP) or Amazon Web Services (AWS). 2. Administrative Requirements: - Secure admin portal accessible via the website and potentially a mobile inter...
...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...
I'm in need of an Excel expert who can help me perform basic arithmetic operations for financial calculations. The purpose of the sheet is to analyze simple financial data, so you should have a good understanding of basic financial concepts. Key requirements: - Perform basic arithmetic operations in Excel for financial data. - Create standard tables and charts to present the analyzed data in a clear and comprehensible manner. The ideal freelancer for this job will: - Have a strong background in Excel, particularly in handling financial data. - Be able to create visual representations of data using standard tables and charts. - Be able to efficiently and accurately perform basic arithmetic operations in Excel.
