Excel vba project planprá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.
...cloudové služby, virtuální technologie a síťové protokoly? Pak hledáme přesně tebe! Náplň práce a požadavky: - Navrhuješ, instaluješ a konfiguruješ servery, síťová zařízení a firewally. - Proaktivně spravuješ a udržuješ naše serverové, síťové a firewall systémy. - Administruješ a podporuješ technologií Microsoft a VMWare. - Vyvíjíš a implementuješ projektové plány, hodnocení rizik a contingency plan. - Navrhuješ a implementuješ monitorovací, správcovské a reportingové funkce. - Zajišťuješ trvalou ...
Par hodin prace s kontingencnimi tabulkami ve dvou souborech Excel.
...learndash data which is the LMS plugin, and we have online classes, so some users have made progress in their courses it must be the same on the staging site… Here’s a list of the tables from the database of the live site, I think we need them, but please feel free to migrate anything else if we need it to have all the data required from the live site. Another thing, it’s good to prepare a whole plan of the migration process, because when you want to start, we need to put the live site on maintenance mode until migration is done, and we don’t want to keep it long under maintenance for the client u know… Tables from database that required to be migrated. wp_learndash_pro_quiz_category wp_learndash_pro_quiz_form wp_learndash_pro_quiz_lock wp_learn...
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í.
...existing materiáls or co-creating materials for topics - in polish language. Current materials are in the Czech language. - listening to calls for understanding issues and incorporating specific situations into training - provide training topics for smaller groups with several reps - length is 3hrs per training Communication during preparation will ideally be in Czech or English. We plan the project for several months but depend on the lecturer abilities to have even more and longer cooperation with us — the range of dozens of hours of collaboration. We require experience with processing of creation of materials and professional management of soft skills training. Experience is necessary. Participants are demanding on practical leadership and expertis...
El plan (profesional) seria para un inversionista.
To je projekat koji govori o tome šta je biznis plan, čemu sve služi i ko ga koristi.
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
nasmnkandkasmdjomdlsdslls,sdlsjdlmdla;d;dmlamdlasdmdmoijdaskdasdnklasnkakasn
...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...
Jedna se o webovy portal s video obsahem dostupnym po z...zarizeni. Obsah by se mel nacitat dynamicky z databaze. Web ma obsahovat menu (kategorie a subkategorie), staticke texty, texty vkladane pres redakcni system, prohlizeni obrazku, vyhledavani, filtrovani, sdileni na socialni site, spousteni videi, diskuzni forum, platba za obsah (kartou, paypal atd.), uzivatelsky login vice urovni, registrace uzivatelu a souvisejici administraci/redakcni system. Plan je, ze se portal bude dale rozvijet, cili mame zajem o dlouhodobou spolupraci. Soucasne zadani je pouze pro verzi 1.0. Cenu prosim rozdelte na programovani (pro tech 20 stranek), cenu za hodinu nad ramec zadani a cenu za graficky navrh. Nejdulezitejsim kriteriem jsou reference s ukazkou kvality grafickeho zpracovani a pot...
Dobry den chtel bych napsat podnikatelsky plan ktery bych pak poslal na e-mail.
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: - Expertise in MS Power Automate, API integration, and AI-oriente...- 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...
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I need someone skilled in search engine optimization, particularly for Google, to enhance the visibility of my study abroad website. I'm targeting a diverse spectrum of users, from high-school students to college students, to professionals who may be interested in international education opportunities. Here's what the project involves: - Developing and implementing effective SEO strategies to improve organic search rankings. Your detailed plan should target high-quality keywords that reflect our audience's inquiries. - Increasing website traffic is another goal. Your method should draw more visitors, specifically from our target audience. - Improving conversion rates. I'm interested not only in attracting more visitors but also in making s...
** for whom the specified budget is not suitable, please do not respond to the project ** * Set up link personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, mon...
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred
I am looking for a skilled PHP developer to create a website that can check the validity of RDP login credentials. The website should: - Allow users to input RDP username and password - Perform a check on this data - Display the results directly on the website Key Requirements: - Create a user-friendly interface - Implement a robust RDP username & password checkin...Display the results directly on the website Key Requirements: - Create a user-friendly interface - Implement a robust RDP username & password checking system - Ensure that results are displayed accurately Ideal Skills: - Proficient in PHP - Experience working with RDP protocols - Strong understanding of web development and user interface design Please let me know your related experience and how you plan to a...
...establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability to work with various digital file formats. - Att...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to d...
I'm looking for a skilled developer to create a secure web-based platform. The platform ...assessments. - The questionnaires will contain both multiple-choice and open-ended questions. -Reports need to be automated in PDF format -i want to know what software you plan to use fir the user interface and the back end data collection Ideal Skills: - Proficiency in web development, especially in creating secure platforms. - Experience in designing and developing survey and assessment tools. - Familiarity with encryption and secure data storage practices. - Ability to create a user-friendly interface for easy questionnaire creation and response submission. If you have the right skills and experience for this project, please reach out. I'm looking forward to discussing...
...Media Management: Our target audience largely consists of people interested in movies and streaming, so a strong presence on social media will be critical. - Content Creation: We need engaging and informative content that can attract and retain our target audience. - SEO Optimization: It's essential that our online presence is optimized for search engines to ensure visibility. - Email Marketing: We plan to use email campaigns to keep our audience engaged and drive conversions. - Paid Advertising: Knowledge of running successful paid advertising campaigns is vital. Ideal Skills and Experience: - Proven experience in social media management, content creation, SEO optimization, and email marketing. - A solid background in digital marketing with a focus on startups, movies, ...
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
...express themselves and share their love for a particular idol. - Idol Badges: Users can set their favorite idol badges in their profile, which will be displayed next to their names. - News Feed: This will be a key component of the app, where users can see updates and posts from other fans. - Direct Messaging: Instant communication between users will keep the community alive, whether users want to plan events or simply chat. You should be proficient in developing secure messaging systems. - Blog: Allowing fans to blog about their idols can help to spark active discussions and attract new users. Ideal candidates should have proven experience in creating similar apps, and be up-to-date with the features that create an engaging and safe space in social media. A sense of enthusiasm a...
I am looking for a qualified and experienced Landscape Architect, or Civil Engineer, preferably with specific experience in the design of golf courses, to develop a master plan for my over 100-acre golf course. The purpose of this project includes: - Improving the playability and functionality of the course - - Enhancement of the aesthetics and landscaping - An aim to increase the potential for revenue I'm particularly interested in a specific route or course layout, that is both challenging and enjoyable for players at different skill levels. In addition to the above, the successful candidate should possess a deep understanding of landscape aesthetics as well. Let's make this course not only functional but visually appealing. If you think you're up fo...
...DESK) Our primary goal is to optimize the site's core vitals in 5 out of 6 Core Vitals test. Key Requirements: - Page load speed optimization - Mobile responsiveness enhancement - Core Vitals performance improvement The ideal candidate for this project will have: - Prior experience in website optimization - A strong understanding of Core Web Vitals metrics - Proven ability to enhance mobile responsiveness - Experience in page load speed optimization Your role will be to thoroughly analyze the website and provide a detailed optimization plan. You should then implement the necessary changes to meet the core vitals requirements. A successful outcome will not only improve the user experience but also aid in the site's overall performance. Please note that whi...
This is an APP just for GitHub: Stressing over shipping bugs to prod? Automate your code-freeze periods and prevent merges during critical times We only have 56 installs on GitHub, not any paid plan yet. We are looking for affordable SEO services Thank you
As I plan on launching a website dedicated to reading the Quran, I'm in need of a UX/UI designer who could understand the significance of the Quran for Muslims and deliver an engaging and user-friendly design. Key Requirements: - User-centered Design: The website should be designed with the user's experience as the focal point. - Search Functionality: Must include a search bar for easy and quick access to specific chapters or verses. - Audio Recitation: An audio feature for recitation is essential to enhance the user's experience of reading the Quran. Ideal Skills: - Proficient in UX/UI Design: Experience in creating engaging, user-friendly interfaces. - Understanding of Muslim Culture: Knowledge of Islamic values and practices would be beneficial. - Exper...
I'm in need of a capable and experienced freelancer to create an interactive brochure. The main purpose of this brochure is to provide ed...main purpose of this brochure is to provide educational content, similar to the example in the link provided above. I'm open to your suggestions on ways to improve this, so please feel free to share your ideas. What I'm looking for in a successful freelancer's application is a detailed project proposal. This should outline your plan for developing the brochure, and include relevant past work and experience that demonstrates your ability to work on a project of this nature. Please note that this project has the potential for ongoing work and further projects. Ref URL :
I'm looking for a Shopify expert to help me with the setup of my online store. Key Requirements: - I already have a domain name, so you won't have to worry about that part. - The primary goal of this store is to sell physical goods, so the design and layout should be optimized for showcasing and selling products. Skills/Experience Needed: - Prior experience with setting up Shopi...Needed: - Prior experience with setting up Shopify stores, especially stores aimed at selling physical goods, is a must. - Familiarity with best practices for e-commerce stores, including design and user experience. - The ability to help me with integrating a payment gateway and setting up shipping methods is a big plus. Please let me know about your previous experience and how you plan to ap...
I'm seeking a skilled IT Project Manager to assist with various tasks throughout the project lifecycle, on multiple concurrent projects. Key Responsibilities: - Project Planning and Scheduling: Your role will involve creating a project plan and timeline, ensuring all tasks are scheduled effectively. - Team Coordination and Communication: Overseeing a small team on each project, you will be responsible for coordinating efforts, facilitating clear communication, and fostering a collaborative environment. - Methodology Implementation: Implementing and adapting project management methodologies as needed to ensure project success. Ideal candidates should have: - Proven experience in IT project management - Strong skills in ...
I'm in need of a skilled PHP/MySQL programmer to help me resolve issues with my legacy application. While the data in the current database isn't critical and can be easily recreated, the s...similar issues in the future. Ideal skills: - Proficient in PHP and MySQL - Experience in working with and debugging legacy applications - Understanding of database management from webpages - Ability to optimize systems for future stability - Strong communication skills to explain technical issues clearly The project is on a debugging and optimization basis, so the work required should be based on the identified issues. Please bid with your experience in similar projects and how you plan to approach this task. I have fully documented both the module, as well as exactly where a...
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.
I am looking for a professional to amplify m...those capable of projecting our message of high-quality and reliability convincingly. Ideal Candidate: - Solid background in B2B digital marketing and outreach - Proven track record of growing an audience on social media - Excellent communication and writing skills - Understanding of Business Executives’ engagement on social media - Commitment to meet project deadlines Responsibilities: - Create and execute a strategic social media plan - Generate sharable content and improve engagement - Monitor, track, and analyze performance metrics - Identify trends and insights and adjust strategies as needed Unleash your skills to bring our brand closer to business executives while highlighting the high quality and reliabi...
Hi 5 Website work - We wanted to redevelop 3 existing Static HTML+PHP websites, and 2 new Wordpress website. I'm looking for a professional web designer to develop a unique, modern w...Policy, Offers & Coupon (Admin Panel), Pricing > Blog setup, Configure-Google Mgr., Social Media Pixel & other, Chat, Google Analytics b. English Website c. Email & SMS reg validation code d. Responsive website with 25 to 30 pages max Need experienced developer with proven experience/projects. Looking for someone reliable and responsible. Expecting web designer to work on Concept Design, Layout Plan, Designing, Development and Host & Testing. Send us samples of similar website work you have done. Selection is based on the Quality work with Lowest Price Quote. Looking forw...
I need a PHP expert to integrate PayPal into my website for one-time payments. The system should ideally support multiple international currencies. Key requirements: - Integration with PayPal: The freel...ideally support multiple international currencies. Key requirements: - Integration with PayPal: The freelancer should have extensive experience with integrating PayPal into websites. - PHP expertise: The project requires a solid understanding of PHP to ensure the integration is smooth and effective. - International currency support: The ideal candidate will have experience in configuring PayPal to support multiple international currencies, as this is a key requirement for the project. Please share your relevant experience and a clear plan on how you intend t...
I need a script that can bypass security measures on my website which uses Cloudflare. This is not for any malicious intent, but for testing and troubleshooting purposes. Key Points: - The script should be specifically designed for websites - The main purpose is to bypass Cloudflare security measures - I didn't specify the customization level, as I'm open to options that mig...customization level, as I'm open to options that might suit my needs better Ideal Skills: - Familiarity with Cloudflare security measures and how to bypass them - Ability to create a script that can seamlessly integrate with any website - Experience working with security testing tools or scripts Please provide a proposal that outlines your experience in this area and how you plan to approach...
I am in need of expert help to scrape text data from specified websites. After the data has been collected, the next step is to clean the data, ensuring that it is in the appropriate forma...step is to clean the data, ensuring that it is in the appropriate format for use. The final output should be managed and stored in a Database Management System. The ideal freelancer for this project should have: - Proven experience in web scraping, specifically text data from websites - Advanced skills in data cleaning to ensure the data is usable and well-structured - Capabilities to manage and store the cleaned data into a Database Management System Please provide any relevant examples of previous work in web scraping and data cleaning and provide details about how you plan to carry ...
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with ...
Company Description: We are a start-up in the technology sector dedicated to developing software solutions. Our flagship product is a sophisticated ticket management system, built with cutting-edge technologies and integrated artificial intelligence. We plan to expand our product offerings in the future. Project Description: We are looking for an experienced web developer to design and develop the corporate website for our company. This will be the first point of contact for potential clients and should reflect the innovation and efficiency of our solutions. The website must be visually striking, high-performing, and user-friendly. Responsibilities: Design and develop a responsive, optimized website accessible on all devices. Integrate a section for our ticket management s...
