Access excel vbaprá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.
We run an app that needs a new FE in React or Vue.js The new UX has been prepared including a styleguide in Adobe XD. We are using REST API between FE and BE. We will be doing BE with our own team. We estimate this to 20-30 MD, about 200 hours. We will not consider any offers until we can review your code. Then we will provide access to the current application, user manuals and access to the new UX to prepare your estimate. We prefer someone for full time, but you can do this as a side job, however we expect 20h/week as a minimum commitment.
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
...Potřebujeme: - dlouhodobou spolupráci, - stálou údržbu databáze, která je 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...
Hello, Your Request I create a simple application that will communicate with the server. Function application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (application...application is simple. - User logs (as opposed to server notified) - Key track position (at adjustable intervals Applications sent by gps coordinates to server. I make API that assumes the dates and stored in the database) - START background (applications are minimized, but still sends location information) - Shut down button (Applications will be turned off) The application therefore has access to the Internet and GPS. no...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I am seeking a proficient Google Sheets expert to construct a live dashboard/leaderboard that visually represents daily sales tallies completed by individual sales reps. Key specifications: - Data to be pulled from a Master Google Sheet. - Incorporation of both total sales and individual rep sales. - The dashboard should display sales data for the current day while maintaining access to historical data. - Historical sales data should be visualized through a bar graph. Skills & Experience: - Attention to detail - Time management and delivery on tight deadlines - Proficiency in Google Sheets - Experience in creating dashboards. - Familiarity with data visualization and report generation - Strong analytical skills and precision Your ability to deliver this project efficientl...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
...particularly leveraging AWS WAF, AWS IP Reputation, and AWS CloudTrail. Key Responsibilities: - Implement rigorous access control policies to ensure only authorized personnel can access our resources. - Configure and fine-tune AWS WAF to establish robust web application firewall rules, block specified IP addresses, and provide protection against DDoS attacks. - Set up and monitor AWS IP Reputation, ensuring that any malicious IP addresses are effectively blocked from our system. Skills and Experience: - Proven experience in implementing AWS security measures, particularly with AWS WAF, AWS IP Reputation, and AWS CloudTrail. - Strong understanding of encryption protocols and access control policies within AWS. - Experience with monitoring and logging tools to ensu...
I need a professional with experience in Odoo to implement accounting reports in Odoo saas~16.3+e (Enterprise Edition). The reports should be exportable as XLSX or CSV files. Required R...Display existing inventory as of a specific date. Price and cost information. 3-Sales Tax Display total sales within a specified time period. Consider both taxed and untaxed sales. Additional Features: *Ability to specify dates for the report results. Example: For the "Inventory Summary FEB 2024" report, be able to search for results for January or other previous months. Access and Meeting: Upon project acceptance, access to our Odoo system will be provided. A video call will be required for a brief orientation on how to obtain the reports Examples of the reports are attached a...
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I'm looking for a proficient professional who can create a report in Microsoft Access from a MySQL database. The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work wit...
I need a word document translated from English to Simplified Chinese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
The ideal candidate will possess a comprehensive grasp of the intricate regulations surrounding the legal rights of individuals implicated in drug-related DUI charges, coupled w...the preference for blood over urine as the primary evidence in this context is pivotal, especially given the reliance on a faint immunoassay line for a substance consumed two days prior. Will be their defense during the lawsuit for my cicil right violations. Furthermore, uncertainty persists regarding the potentiality of a secondary mandatory test, with a hindrance named LIMS impeding the MRO's access. In any event, the decision to engage with the media on this narrative is clear. Please furnish a detailed account of your experience in the pharmaceutical domain and a summary of pertinent qualificati...
...not apply. We are only seeking to work with one to three people maximum and agencies should not apply. Key Responsibilities: Design and develop a user-friendly mobile application for iOS and Android platforms. Implement AI and NLP (Natural Language Processing) features for online interaction with users with future development for offline interactions. Integrate selective caching for offline access to critical conversation threads. Work with RESTful APIs for server-side features and NMEA (National Marine Electronics Association) data integration. Develop and manage a comprehensive database to handle user profiles, chat histories, and app analytics. Collaborate with UI/UX designers to ensure the app is intuitive and engaging. Ensure the application is compliant with all releva...
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - Expertise in Amazon SEO and PPC ads, with a specific focus on product listing optimization. - Experience ...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
For the described functionality, I will bill a total of 48 hours, amounting to $960 USD. Initially, I will bill for 24 hours. Upon completion of the work, I will bill the remaining 24 hours. Date of completion:- 24...contextually appropriate prompts & responses. Module 2: Quick Search IPC, Scopes The functionality for identifying IPC codes and defining scopes must be quick, efficient, and precise. Module 3: Document In-depth Analysis This module offers detailed feedback on patent drafts and drawings, addressing all patentability criteria effectively. User History Access A robust system for tracking and retrieving past submissions and work history to facilitate easy access for users. This feature will ensure that users can review and continue their previous work withou...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm looking to hire an experienced web developer to create a website that caters to professionals. The main goal of this website is to provide information, so it will not require e-commerce capabilities. Key Features: - User Registration and Login: The website should have a user registration and login system to allow professionals to create their accounts and access specific content. - Search Functionality: A robust search functionality is crucial to help users easily find the information they are looking for. Target Audience: The target audience for this website is professionals. It is vital that the design and functionality of the website can cater to the needs and expectations of this demographic. Ideal Skills and Experience: - Proficient in web development and design, w...
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
I am seeking a developer to create an in-depth offline property abbreviation dictionary portal, accessible as a desktop or mobile application, allowing users to easily search and access property-related abbreviations and their full meanings without requiring an internet connection." Key requirements: ▪︎ The website should provide comprehensive word definitions ▪︎ Include abbreviations and provide their full definitions ▪︎ Both word definitions and abbreviations must be thoroughly explained Ideal Skills: ▪︎ Proficiency in website development ▪︎ Experience in creating educational resources or similar platforms ▪︎ Excellent command of the English language ▪︎ Attention to detail, ensuring accuracy and completeness of every word definition and abbreviation. Through this platf...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...
2 excel files with VBA macro as per customer requirement
...executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the company to gauge activeness, e.g., staff working at the premise, loading/unloading of goods, etc. REQUIREMENTS: • Must be living in (or nearby) Av. Mariscal Nieto, Lima, Peru. • Has a camera or phone/tablet of quality with a camera, internet access • Must be available during business hours (9 AM - 4 PM) on working days Please see the attached file for the site visit guidelines. You are only required to deliver the pictures, video & observations and are not expected to put together a report like the Sample Report. Note: Milestone will be released the following week after the site...
Project Brief: Dental Lab Websi...clients to pay for their orders online, with support for major credit cards and digital wallets. Responsive Design: A mobile-friendly website layout that adjusts seamlessly across various devices and screen sizes. SEO and Content Strategy: Implementation of SEO best practices to improve search engine rankings, along with engaging content that positions us as industry experts. Customer Support: Easy access to customer support, including live chat, phone, and email contact options. Deliverables: A fully functional prototype of the website for initial review. Integration of all specified features post-approval of the prototype. Testing and quality assurance to ensure a bug-free user experience. Deployment of the website on a secure and reliable hosting...
I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...
I'm looking for freelancers to help me secure backlinks from guest posts. If you have access to website DA 60+ in Ahrefs, you can quote your price per guest post. Look, I already have contributors working on it, so, don't just quote in a silly manner, reasonable prices will be accepted. Criteria: -60+ DA in Ahrefs -Must be indexed by Google, only pay for indexed posts. Thank you.
...Your expertise in Social Sciences is of essence and shall be fundamental in this project. - I require assistance in extracting relevant studies from top-tier UK or USA journals. Familiarity and access to vast academic journals are absolutely necessary. - I'm focused on qualitative research and expect appropriate methodologies to be applied in this study. -I require that the writer must not use AI generated text or sources. AI sometimes CREATES references that do not exist! Only true writers may apply please. Skills required: - Extensive experience in Social Sciences. - Should have privileged access to premium academic journals in UK and USA - Familiarity with qualitative research methodologies. - An ability to synthesize complex concepts and give an in-depth unders...
...registration, subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enable different access levels (Project team, Donors and trading partners) for viewing, analysis and with rights editing mem...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research would...
Creating...proficiency will let you deliver a platform that not only meets our audience's needs but also reflects our commitment to quality service. Experience in building dynamic, interactive web pages is extremely valuable for this project. We will start with one project and see how quickly it can be done, for what cost, and what quality. You must be able to navigate our existing domain and ensure we can access and modify our pages later on, and duplicate where needed. A note: our old webpage still exists - but the pages attached to it no longer work or aren't applicable, many were compromised by malware, and the person who built it all out is gone and nowhere to be found. That said, the brand theme is there and is a good guide to get an idea of what we're doi...
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a talented machine learning expert to create a model to predict cancer - related proteins within Protein-Protein Interaction networks. Key Requirements: - No Data Availability: You will be responsible for sourcing a suitable dataset for this project. The dataset should be substantial, relevant to healthcare, and ap...and Evaluating a Strategy. - Evaluation of the Model - Making predictions on a New Test Set Ideal Candidate: - Strong Machine Learning Skills: You should have a proven track record in creating predictive analysis models. - Healthcare Industry Knowledge: Little experience in working with healthcare datasets would be a significant advantage. - Data Sourcing Ability: Being able to identify and access appropriate datasets is crucial for the success o...
I currently have a website set up. Users are able to register/login and are redirected to a My account page. On this My Account Page I need users to be able to upload Pics/videos add a short description and submit. Once submitted I need the posts to go to a user specific "My Documents" page that only the user and admin can access.
I'm in need of a skillful designer to create a basic online portal, web or app, where my small hotel's rooms can be monitored and rented out. Key requirements: - Designing the platform to be responsive, enabling users to access and interact with it from various devices. - Tenant will only request for booking and Booking should confirm only by landlord. After confirmation tenant should be able to book. -Calendar Integration: A feature that enables tracking of room occupancy to prevent double booking. - Implementing an inventory management system that will enable me to monitor the availability of items in rooms at the hotel. - Including a functionality to monitor any defects that might occur in the rooms. - Inventory Maintenance: A system to monitor room conditions, track ...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I'm seeking a skilled Laravel developer to resolve a stubborn issue we are encountering on our video subscription website. Subscribed users are currently unable to access any videos on the site, and we need this fixed urgently. Key tasks: - Identification and resolution of the subscription issue preventing user access to all videos - Ensuring that only subscribed users have uninterrupted, total access to our video content. Ideal experience and skills: - Extensive background in working with Laravel - Proficient at troubleshooting and resolving subscription and accessibility issues - Prior work with video streaming platforms would be a strong advantage. Your main duty will be to restore functionality swiftly, ensuring our subscribed users' seamless intera...
...will present additional products or offers with a one-click option. This feature is particularly tailored for customers who choose cash on delivery as their payment method. 5). Order Bump Feature: The ability to offer additional products or services at the checkout page with a checkbox for customers to easily add them to their order. 6). Access Control (Blacklist/Whitelist from Certain Countries): Implementation of access control to restrict or allow access to the website based on specified countries. This can include both blacklisting and whitelisting. 7). Support Google/Meta/Snapchat/TikTok Pixels: Integration with various tracking pixels (Google, Meta/Facebook, Snapchat, TikTok) for marketing and analytics purposes. 8). Support WhatsApp Messages or SMS After Purc...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
