Module ftp vba excelprá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.
...In individual branches and mention and incorporate the methodology of work (not the solution; the solution is the subject of another assignment). Form of text output: - Module name: XY - Methodology of work of our company - Content (as determined by headings and numbering of individual categories) - Name and number audit subcategories + describe the text theoretically. Here is an example of the form of work of one developed module for strategy: Approximate word range for one module = 2000-5000 words Required scope of work = 10,000 - 20,000 words Required developed modules: 1. graphic design development networks Více o zdrojovém textuPro
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.
Dobrý den, máme shop s bateriemi, adaptéry a klávesnicemi. Běží na Prestashopu. Každý produkt v eshopu má několik stovek kompatibilit. Potřebujeme vytvořit XML feed, který bude generovat názvy v kombinaci s každou kompatibilitou. Příklad: NABÍJEČKA NA NOTEBOOK ACER 19V 3.42A (5.5X1.7) Kompatibility v databázi: Acer Aspire 1200, Acer Aspire 1200X, Acer Aspire 1200XV, Acer Aspire 1202, Acer Aspire 1202X, Acer Aspire 1203X, Acer Aspire 1203XC, Acer Aspire 1203XV, Acer Aspire 1360, Acer Aspire 1410 Výsledek v XML exportu: NABÍJEČKA NA NOTEBOOK Acer Aspire 1200 NABÍJEČKA NA NOTEBOOK Acer Aspire 1200X NABÍJEČKA NA NOTEBOOK Acer Aspire 1200XV NABÍJEČKA N...
Aby-Ball Galerie in myaby App-System.
Dobry den Fando. Chtel bych se vas zeptat jestli by ste byl schopny udelat jedny web stranky. responsive a multi language a currency. Nechci zadny wordpres. Ale admin back end bych chtel treba cakephp nebo nakej framework to by bylo na vas. Stranky by porovnavaly ceny video her z vice online obchodu. Data feed jako cena her je prostrednictvim ftp nebo http ve vice formatech . nevim ktery je lepsi tak mozna mi s tim poradite. A nektere obchodi maji data feed via API. navrch vzchledu stranky bych mel. takze design by ste delat nemusel. Procte takovy klon stranek
Poptáváme kompletní výrobu nového webu místo stávajícího: Pokud budeme s prací spokojeni, využili bychom služby pro dvě další stránky. Web bude umísten na stávajícím FTP. Hlavní konkurence: Požadavky: 1) 2-3 různé návrhy designů - Každý design Mobile friendly nebo verze mobile/desktop, jednoduchá orientace, jiné než stávající barevné schéma než na současném webu (bez růžové). Pozitivní, veselý, dávající pocit luxusní služby. 2) Založené na php CMS jako je Wordpress / Joomla / Drupal ... 3) Uživatelsk&aacut...
Poptáváme kompletní výrobu nového webu místo stávajícího: Pokud budeme s prací spokojeni, využili bychom služby pro dvě další stránky. Web bude umísten na stávajícím FTP. Hlavní konkurence: Požadavky: 1) 2-3 různé návrhy designů - Každý design Mobile friendly nebo verze mobile/desktop, jednoduchá orientace, jiné než stávající barevné schéma než na současném webu (bez růžové). Pozitivní, veselý, dávající pocit luxusní služby. 2) Založené na php CMS jako je Wordpress / Joomla / Drupal ... 3) Uživatelsk&aacut...
Dobrý den morff, všiml jsem si vašeho profilu. Mám aktuálně jednorázový úkol. Mohlo by to být pro Vás na chvilku.. s uváděnými zkušenostmi. Zaplatím rychle. Po...všiml jsem si vašeho profilu. Mám aktuálně jednorázový úkol. Mohlo by to být pro Vás na chvilku.. s uváděnými zkušenostmi. Zaplatím rychle. Potřebuji vytvořit propojení databáze nových objednávek z Woocommerce do již existující webové aplikaci na správu registrovaných klientů pro potřeby jedné konference. Vše je připravené - front end - wordpress web - i web...
Potřebuji vytvořit propojení databáze nových objednávek z Woocommerce do již existující webové aplikaci na správu registrovaných klientů pro potřeby jedné konference. Vše je připravené - front end - wordpress web - i webové aplikace - dáme Vám přístup do ftp obou webů - mělo by jít jen o správné provázání, pokud máte zkušenosti s databázemi, měla by to být otázka pár hodin práce. Potřebujeme pomoci ihned - zadání Vám pošleme obratem.
Potřebuji vytvořit propojení databáze nových objednávek z Woocommerce do již existující webové aplikaci na správu registrovaných klientů pro potřeby jedné konference. Vše je připravené - front end - wordpress web - i webové aplikace - dáme Vám přístup do ftp obou webů - mělo by jít jen o správné provázání, pokud máte zkušenosti s databázemi, měla by to být otázka pár hodin práce. Potřebujeme pomoci ihned - zadání Vám pošleme obratem.
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
...vytvořená na míru našim potřebám, a úpravy jejích stávajících funkcí, - práci na vývoji nových funkcí (např. s cílem usnadnění administrativní práce v nadaci a tím dosažení významných finančních úspor). Hledaný programátor by měl mít: - perfektní znalost MS Access (tabulky, dotazy, formuláře, reporty), - znalost MySQL, - znalost základů relačních databází, - perfektní znalost programování ve VBA (Visual Basic for Application). Nabízíme: - Možnost komunikace s autorem databáze. - K dispozici bude dok...
I'm looking for a proficient Excel expert who can help me with importing data from an existing Excel file into a mark sheet template. Key Tasks: - Import data from an existing Excel file into a new mark sheet - Perform data cleaning post-import The ideal candidate should have: - Proficiency in Excel, specifically in importing data - Experience in data cleaning and manipulation - Attention to detail to ensure data accuracy Feel free to reach out if you have any questions. I look forward to your bids.
Part time Bookkeeper needed for work in Orange County CA. You can work from home but may be needed for face to face meetings. Job duties to include reconciling bank statements, extensive use of excel spread sheets for tracking data, business and task management. Candidate should be able to use property management software to enter data, pay bills, generate reports.
...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...
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.
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...
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 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...
I'm in need of a well-experienced web developer to craft an intuitive school fees management system. This system needs to be accessible both on web and mobile platforms, ensuring comprehensive accessibility and usability. Key Features: - The system should allow for ease in Student Registration. - There should be a function for efficient Fee Collection. - A robust Payment Tracking module to ensure the accurate monitoring of all school fee payments. Ideal Skills and Experience: - A demonstrable record of developing web systems, specifically with a focus on finance or fee tracking modules. - Experience in creating responsive designs that work seamlessly across both mobile and desktop environments. - Great understanding of user experience, ensuring the interface is user-friendly ...
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.
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 creating dynamic das...
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.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
...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. Magento 2 Upgrades: Perform upgrades to the latest versions of Magento 2. ERP Sync Module: Develop a custom ERP synchronization module. As an alternative to expedite the process, utilize a pre-built module until the custom one is complete. Payment Gateway Integration: Set up Areeba Payment Gateway and potentially integrate other payment gateways. Data Entry: Assist with data entry for product images and specifications. Website Maintenance: Perform ongoing maintenance and upgrades to the website. New Feature De...
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
...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. Magento 2 Upgrades: Perform upgrades to the latest versions of Magento 2. ERP Sync Module: Develop a custom ERP synchronization module. As an alternative to expedite the process, utilize a pre-built module until the custom one is complete. Payment Gateway Integration: Set up Areeba Payment Gateway and potentially integrate other payment gateways. Data Entry: Assist with data entry for product images and specifications. Website Maintenance: Perform ongoing maintenance and upgrades to the website. New Feature De...
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
...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.
Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...
I'm in need of a professional data entry specialist to assist with entering numerical data into an Excel spreadsheet. The aim of this task is to organize the data in a clear, tabular format that can be easily read and interpreted. Skills & Experience: - Proficient in Excel - Strong attention to detail - Experience with numerical data entry The project demands precision in inputting the data, so only those who display meticulous attention to detail will be considered. An understanding of how to organize data in a tabular format is crucial. Please ensure you have relevant examples of similar tasks in your portfolio. Deliverables: - An Excel sheet filled with the provided numerical data, organized in a tabular format.
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
As a thriving startup, we are in need of a highly skilled Android Developer with proficiency in XML and Jetpack Compose to join our team. Primary Task: - Migrate a module written in XML to Jetpack compose : 4 screens + Business logic Skills and Experience needed: - Deep understanding and expertise in Android app development - Hands-on experience with XML Schemas; familiarity with XML Parsing and XML Web Services will be considered a plus - In-depth knowledge of Jetpack Compose, especially its UI toolkit Overall, we're seeking a developer who is deeply committed to enhancing the user experience through thoughtful and efficient app development. If you've mastered XML and Jetpack Compose and have a knack for Android development, this project is perfect for you. Don�...
...hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
