Excel vba coding ftp connectionprá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í.

alarm clock using proteus (isis) using MIKROC Pro coding

datae

datae

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

mise en forme

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

Napraviti Excel VBA program

...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 coding of template for QuickCart. This template: template pay in "clean html" and pass the coding for QuickCart 6.2Alternatively. The result is a template for QuickCart 6.2 You can offer a similar custom template.   Thank you for your offer and I apologize for my English

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm in a hurry to develop a photo editor that includes filters, crop and rotate features, and the capacity to adjust brightness and contrast. The product must support JPEG, PNG, and GIF file formats. Since I'm looking to launch this as soon as possible, I need a developer who can jump right in and get moving quickly. Ideal skills for this project include experience in graphic design, coding, and knowledge in image processing and digital image file formats. A solid understanding of user interface design will also be beneficial to create a user-friendly photo editor. Pay attention to detail and time management skills are paramount given the tight deadline.

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

I require an proficient developer to create a script that can send out automated emails through Gmail. This task should be accomplished with an appropriate scripting language for Gmail's...emails. - The notifications will be for scheduled reminders and service status updates. - Targeted audiences are all users and selected groups. Relevant skills include proficiency in JavaScript (as Gmail Scripts commonly employs this language) and familiarity with Gmail's API. Knowledge of handling scheduled tasks and interaction with user databases is also beneficial. In short, I'm looking for a coding and Gmail expert who can automate the process of sending important reminders and status updates to our users. The system should handle all users while also having the option to tar...

...technology, MetaMatch aims to revolutionize fan interaction with sports through the integration of NFTs and real-time event engagement. The logo should encapsulate the essence of blending traditional sports with cutting-edge blockchain technology, appealing to both tech-savvy and sports-loving audiences. Specific Requirements: Concept and Design: The logo must convey a sense of innovation and connection, symbolizing the fusion of real-world sports and blockchain technology. It should be modern, easily recognizable, and scalable for use on various platforms and sizes. Color Scheme: We are looking for a color palette that stands out yet feels intrinsic to both the digital nature of blockchain and the dynamic energy of sports. Suggestions include, but are not limited to, combinat...

...published on a separate WordPress site. Ideal skills for this project include: - Strong understanding of WordPress development - Experience with creating custom plugins - Familiarity with WordPress APIs and data handling - Ability to work with cross-site data transfer The project requires: - Setting up a user-friendly form for registered users on Website A to create posts - Establishing a connection between Website A and Website B for seamless post transfer - Ensuring the posts are published immediately on Website B I'm open to your suggestions for user information that could be included in the post transfer, and I would appreciate your input on best practices for this kind of cross-website integration. Your input on potential security considerations for such integrati...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

I would like to design standard operating procedure (rules of lead engagement) based on large medium and enterprise segments- 1) how should sales consume the leads once a lead is assigned to the sales reps. 2) Define the stage movement timeline from one stage to another in salesforce based on which stage the lead is in. 3) How long to wait to send a follow up email /call after the two way connection has been established. 4) Reason to close or recycle the lead 5) Activities logged in salesforce. etc.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

I have previously worked code in and stored but it stopped working because readyPromise doesn't work and in that case, it can't load sequently and crashes. New Java stuff?? I...sequently and crashes. New Java stuff?? It doesn't recognize readyPromise with var/const only works as await. Async has problems too. Even without Crashing tilesets seem not to load both from ION and Private/Public Domain. Need to solve this ASAP. You need to download files and work within your Domain or IDE or any other way to work directly with CESIUM LIBRARY!!!!! Or I will give you my Domain FTP access to the project folder and you can Upload .js .html files and see RESULTS in this directory as it will load html and js: YOU HAVE TO WORK WITH CESIUM LIBRARY!!

i have a form created with HTML and PHP. user has to fill in information and when press submit, it should insert infos in database. But sometimes it doesn't it just clear or keep loading. maybe connection is not good everytime. So i need someone to adjust it to upload data in realtime. as soon as user finished typing in 1 field, it should store data. when uploading, it should show loading icon near input field. if succeed, green vink icon. if not, red cross icon. when user finish, user can click submit button which will echo all data stored in mysql database on same page in lightbox. image attached. Budget is $35. if you want more, please do NOT bid. budget is $35

More details: What is the desired color scheme for the HTML emails? Vibrant colors What type of data is being displayed in the emails? Graphs and charts How sophisticated should the timeline image design be? Moderate complexity with some unique elements

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I'm seeking a smart freelancer based in the USA who is having a local cell phone connection and are capable of making calls to gather information.

...can convert my current pinescript strategy into Python code. This strategy uses supertrend and SMA on daily and weekly timeframes. Key Elements of the Project: - The conversion will enable backtesting of multiple stocks in batches. - The intended outcome is to accurately analyze the performance of the strategy across different stocks. Required Knowledge & Skills: - Deep understanding of Python coding and algorithm optimization. - Understanding of financial indicators especially the supertrend and SMA. - Experience in handling financial data for backtesting, including historical stock prices, volume data, and multi timeframe. Note that the exact rules for the long and short entries will be provided once you're selected for this project. Familiarity with Pinescript is ...

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

...goal is to analyze the conversion of reactants, product yield, and overall reactor efficiency, focusing on temperature and pressure as critical parameters. Key Project Deliverables: - Establish the PFR model in Matlab. - Integrate temperature and pressure variables using 2-D pseudo homogeneous model. - Calculate reactant conversion, yield, and efficiency. Ideal Candidate: - Proficient in Matlab coding. - Solid background in chemical engineering, specifically reactor design and modeling. - Understanding of PFR kinetics and mass-energy balances. - Ability to interpret simulation results for optimization. I am eager to collaborate closely with someone who is detail-oriented and committed to delivering accurate and insightful outcomes from this modeling exercise. If you have the ...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for ...

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

My WordPress site hosted on AWS is currently down due to a database connection issue. Key requirements: - **Database Connection Issue**: The site is throwing an 'Error establishing a database connection' message. I believe this is related to database connection details in the WordPress configuration file. If you are experienced with AWS and WordPress, this could be a quick fix. - **Backup Restoration**: I have a recent backup of the site. However, I'm not confident about the database connection details in the configuration file. Restoring the backup and ensuring the database connection works correctly is crucial. - **AWS and WordPress Expertise**: Ideal candidates should have experience with both AWS and WordPress. Familiarity wi...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

I'm in need of a proficient expert who has hands-on experience with the Hestia Web Panel, VPS servers, and FileZilla. I own a VPS web server which I am having difficulties connecting to via FTP. The ideal freelancer for this task should have knowledge of: - Hestia Web Panel, and its API and configurations - How to effectively troubleshoot VPS servers - FTP access through FileZilla With this project, I need: - Full diagnosis and resolution of the FTP connection issue - Restoring the connection between the Hestia Web Panel and the VPS server via FTP - Ensuring there's seamless access to the VPS server Note, I can access the VPS server through SSH, thus you should also be comfortable working with SSH connections. Your expertise in resol...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

Website is maintenance mode, No ssh to run command, only ftp

When button clicked, the field of another table will changed to required. Only FTP no cpanel

I'm looking for an experienced Shopify developer who can create a bilingual (English and Spanish) online store for us. In addition to the design and development, I need the freelancer to provide all the translations for the content. The site should allow users to choose their preferred ...to the design and development, I need the freelancer to provide all the translations for the content. The site should allow users to choose their preferred language. Here are more details: - Fluent in English and Spanish, with excellent translation skills. - Proven experience in developing Shopify stores. - Proficient in HTML, CSS, and JavaScript to customize design elements. - Experience in coding for user-friendly UI/UX. - Ability to work independently and deliver the project within the a...

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.