Excel macro inventory systemprá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í.
Potřeboval bych vypracovat projekt, jehož zadání je v příloze. V případě zájmu Vám k tomu pošlu další data, na ceně se dohodneme.
Nástroj pro efektivní řízení IT a jednotlivých zdrojů v IT. Jedná se o ucelený soubor kontrolních a dokumentačních nástrojů. Základní moduly jsou: - IT Test - IT Overview - Registr rizik - KPI - KGI - Katalog služeb - Aktiva - Smlouvy - Systémy - GDPR
Pro účel vyúčtování potřebuje naše firma macro, které bude kontrolovat platby a jejich zdroje. Macro by také mělo identifikovat transakce, které buď nejsou spojené s žádným prodejem, nebo jsou nějakým jiným způsobem problematické. V příloze je vzor zdrojových souborů: report z našeho systému, výpis transakcí z paypalu, výpis transakcí z bankovního účtu. V případě zájmu/ dotazů mne neváhejte kontaktovat. Strobl
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
Nastavení vytvořených Facebook účtu podle parametrů zadaných v excelu - změna jména, skrytí privatních informací (skrýt zeď pouze přátelé, skrýt kamarády pouze pro přátelů), pohlaví, pohlaví a nastavení nějakých like stránek z Czech Republic. atd. Já pošlu Excel po dohodnutí se na zakázce. První zadání je úprava 300 FB účtů.
...OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices&quo...
I am looking for a skilled Django developer to help me build a simple CRUD system. This system needs to primarily manage employees and facilitate the transfer of their personal details with basic report within the organization. Key Features: - Employee Management: The system should allow me to add, edit, and delete employee information. - Information Transfer: This is a key feature, so I need to be able to easily transfer employee personal details within the organization. see the attached file for more details Please reach out if you have the necessary skills and experience for this project.
...looking for a detail-oriented individual to assist with a data entry project. The task involves entering a variety of data types including numeric, text, and alphanumeric, into an Excel file. Key Details: - You will be working with a spreadsheet that has more than 10 columns. - I require the data to be formatted in a specific way: - Color coding: Certain cells should be filled with specific colors. - Conditional formatting: Cells should be formatted based on specific criteria. - Data validation rules: Certain cells should only accept specific types of data. Skills required: - Proficiency in Excel, including experience with conditional formatting, data validation, and color coding. - Strong attention to detail to ensure accurate data entry. - Efficient and r...
...who can create a comprehensive, user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system should...
I'm looking for an Arduino expert to setup an Opta PLC that can effe...setup an Opta PLC that can effectively monitor temperature readings. The system should be able to: - Receive inputs from different temperature sensors and digital inputs. - Monitor a vast range of temperatures from below freezing to above 90°F. - Send email notifications of temperature readings and changes every hour for remote monitoring. The perfect freelancer for this project is experienced in programming Arduino Opta PLCs, utilizing sensors, particularly those for temperature, and setting up efficient email notification systems. Beside technical proficiency, good understanding of thermodynamics would be a plus, but is not a requirement. The end-goal is an efficient and reliable remote temperature ...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. Looking forward to your proposals!
...recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for managing and sending out newsletters. - Strong understanding of the freelance industry and the needs of experienced freelancers. This is a long-term project, so I'm looking for a ...
I need assistance with submitting customs declarations in Northern Ireland using the Trader Support Service (TSS) system. - Familiarize with TSS System: Understanding of the TSS system is necessary as the project requires comprehensive usage of it. I have access to the system but I need someone who can efficiently navigate it and complete the task accurately. - Document Preparation: Although the document needs to be prepared on the TSS system, any other necessary paperwork to supplement the TSS filing will be required. So, proficiency in documentation is important. - Experience: Having prior experience in customs declarations and familiarity with Northern Ireland's regulations would be ideal. Your responsibility will be to ensure the TSS filing f...
I'm encountering issues converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet platforms...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, you...understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financia...
...knowledgeable in ReactJS and NestJs to expand my existing CRUD application. Here are the features I need: 1. Buying and Renting Functionalities: The app should handle not only cars but also apartments. The interface needs to cater to both clients and admin. The system currently only has admin view on the frontend, views for the customer should be implemented. Im open to discuss how to best implement this. 2. Advanced Audit Functionality: I want to ensure system integrity through audit trails. Capability to track one critical element of the system and to record login/logout sessions is a must. 3. Google Maps Implementation: I'm open to suggestions on how this could enhance the app and the user experience. Experience in online marketplace development and audi...
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing ...tasks as assigned by the CEO. QUALIFICATIONS: Proven experience as a Virtual Assistant or in a similar administrative role. Excellent written and verbal communication skills. Strong organizational and time-management abilities. High level of professionalism and confidentiality. Ability to work independently and handle multiple tasks simultaneously. Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint) and Google ...
...try-inventory/id1162606257 Summary of the "Keep Fresh" Grocery Expiry App Project Project Overview "Keep Fresh" is a mobile application designed to help users track the expiry dates of their groceries. The app provides a simple and user-friendly interface for adding grocery items, viewing current inventory, and receiving notifications before items expire. The goal is to create a useful tool with AI features to help enhance user experience Key Features - Using Flutter + Gemini-API User Authentication: Sign in and create new accounts Edit profile and preferences Pantry Management: Display a list of scanned groceries Add new items via a plus button, redirecting to the camera for scanning food receipts or item barcodes Edit and delete existing items Ove...
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I need a professional to assist in implementing and customizing an Odoo POS system. While I didn't specify any particular customizations or features, I'm open to suggestions that can improve the POS system for my business. Your expertise in Odoo POS will be crucial in ensuring a seamless implementation and customization process.
I need a knowledgeable freelancer to set up the infrastructure for an OCI data warehouse on Oracle Cloud. This platform will be used for data analysis, reporting, and data storage. The scope of...Oracle Cloud. This platform will be used for data analysis, reporting, and data storage. The scope of the job will include: - Configuring the Oracle Cloud to host the OCI data warehouse - Ensuring the system can handle storing and managing customer information, sales data, and inventory data A background in cloud computing, notably with Oracle Cloud and data warehouses, will be instrumental to the success of this project. Experience in handling similar types of data is a plus. This job requires someone who understands the nuances of OCI data warehousing and can deliver a reliable, ...
I'm looking for a freelancer to conduct market research to determine the best selling aftermarket products in the motorcycle industry: specifically, my target segments are in the super sport, sport, sport touring and cruiser Japanese motorcycles (Honda, Suzuki, Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would i...Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would include Amazon and Ebay but open to other possibilities too). I wanted to limit the types of products to: (1) Brackets (2) Protective engine covers (3) Levers (brake, clutch, etc..) (4) Air intake components (air intake box or air inlet ductings). The project consists of 2 parts and thinking it would be in Excel format (but op...
...- Customer Reviews: The site should allow users to leave reviews and these reviews should be incentivized - users should earn credit when they write a review or share their experience on Instagram. - Inventory Management: I need a system that allows me to easily manage inventory and stock. - User Photo Upload: I want to enable users to upload their own photos at a specific segment on the website. - International Shipping with Tracking Number: As an E-commerce site, it's important that the website supports international shipping with tracking to ensure customer satisfaction. - User Credit System: The website should have a feature that allows users to accumulate credit in their account for activities such as writing reviews or sharing on social media. - Us...
Description: We are currently seeking a dynamic and motivated freelance cold caller to join our team and assist in prequalifying low-income prospects for our revolutionary no-cost health benefits program. This is an excellent opportunity for individuals who are skilled in high-volume cold calling and have a passion for help...management. Benefits: -Daily and Weekly Bonuses based on production!!! -Competitive compensation based on performance and call volume. -Opportunity to make a meaningful impact by helping low-income individuals access essential healthcare services. -Potential for growth and advancement within the company based on performance. If you are passionate about making a difference and have the skills to excel in a fast-paced cold calling environment, we want to hear...
I'm in need of a distinctive, yet friendly and approachable female voiceover artist who can bring to life our company’s phone system in English. Your voice will provide the first interaction many customers have with our company, so it must be warm, welcoming and easily understood. Attributes required: - Fluent English Speaker - Female artist - Able to convey a friendly and approachable tone - Previous experience preferred in similar assignments The deadline for completion is flexible, however my preference would be for it to be completed promptly. Please submit a short sample of your voice work as part of your proposal.
...Developer to automate tasks relating to a list of codes (stored in a txt file, excel file, etc) and Web interaction, for a demostration of micro RPA possibilities Basically you will take 1 data from 1 excel cell (example cell d5) with that data you will create an hyperlink the link will be a fixed text + the code taken from excel you will open a broswer tab with that link IF one text is present in the resulting html response, you will close the tab, and repeat the process with the next data from the file If another text is present, you will "click" 3 or 4 following buttons Iterate with the next data from the excel file Until Excel's data EOF Everything configurable via external TXT file - name of the excel file or txt file - starti...
We are an Ecommerce company dealing with variety products and we are looking for a ...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
Hello there, We will translate your Excel file (Magic Jackpot Ads (Slots)) into Hungarian. Thank you!
...that will serve as a tour guide for travel groups. Key Features: - It should be compatible with both iOS and Android devices. - The primary feature should be the ability for a tour guide to speak to the clients in real-time, providing live, interactive commentary throughout the tour. - The app should support live chat for clients to ask questions to the tour guide. - Smartphone-based tour guide system: One simple app for both speaker and listeners. Works on any device that is connected to the internet via WIFI or mobile data like 3G, 4G or 5G. Ideal Candidate: - Proficient with app development for both iOS and Android. - Experienced in integrating real-time communication features in apps. - Knowledgeable in creating audio broadcasting applications. Please let me know about y...
I'm in need of an experienced graphic designer to create a captivating, illustrative logo that stands out and reflects the essence of my brand. This design is crucia...primary use has not been defined yet; it could range from web applications to print materials or product packaging. - Deliverables include the original vector files and high-resolution PNGs. - Must be available for a brief consultation before starting and open to revisions, if necessary. **Timeline:** - Complete within 2 days from project start. This project is ideal for creative freelancers who excel under pressure and have a knack for delivering high-quality work promptly. Your contribution will play a pivotal role in the launch of my new product, and I'm excited to see how your creativity will help brin...
...operations support assistant to aid me in daily tasks. Key Responsibilities: - Spreadsheet Management: You will be tasked with keeping our Excel sheets organized and updated to ensure seamless operations. - Report Generation: You will also be responsible for generating reports for our activities. These reports must be clear, concise, and error-free. - Daily Calls: You will make regular teams calls within the operations team. - Research & Analysis: The role will also require you to conduct research and analysis on various topics as needed. Your Excel Skills: I need a candidate who is proficient in Excel. An intermediate level of understanding and experience in Excel is a requirement for this role. You need to have a personal computer and a data speed ...
I'm searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate shoul...
...automated document verification system focused on improving the document management process of educational or related institutions. The system needs to handle verification processes for transcripts, certificates, and IDs. Key Features: - Real-time Verification: It is imperative that the system can verify documents immediately upon submission. - Secure Storage: Verified documents should be stored securely, ensuring confidentiality and data protection. - User-friendly Interface: The system should have an intuitive and simple-to-use design to allow effective handling of documents. Integration: - The system should be capable of API integration for seamless incorporation into existing structures. Ideally, the developer should have a strong background in...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
We are an Ecommerce company dealing with variety products and we are looking for a ...Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain Write text for the posts Edit Pictures and videos in Canva or Capcut The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications and sales skills Can work on Excel Have sufficient experience in Social Media Ads and ...
...descriptions, pricing, and images. - Implement live chat support: I would like to have live chat support functionality on the front page. This will require integrating a suitable chat support system and customizing it to fit the overall design of the site. Ideal skills and experience for the job include: - Proficiency in WordPress: You should have extensive experience in working with WordPress, particularly in the e-commerce context. - E-commerce design: A proven track record in designing e-commerce sites with a modern aesthetic is highly desirable. - Product uploading: Experience in uploading and managing a large inventory of products on e-commerce platforms. - Live chat support integration: Previous experience with implementing live chat support systems on websites will...
More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.
...lead should include the following: • Company Name • Company Address • Company Phone Number • Owner's Name • Contact Email • LinkedIn URL (if available) 4. Target Titles: The contact should hold one of the following titles: • CEO • Chief Executive Officer • Owner or Managing Partner • Founder • Chief Financial Officer (CFO) • Board of Directors • Pharmacist • Manager • Director Deliverables • An Excel spreadsheet with the collected data points for 2,000 contacts. • Ensure that there are at least 1,400 unique companies represented in the list. Quality Assurance • Perform regular reviews of the data to ensure completeness and accuracy. • Use tools to remove duplicate entries and ens...
...an exciting opportunity to advance your career in the IT industry amid the remarkable growth of the US job market. As part of our prominent company, you'll contribute to cutting-edge projects that shape the future, positioning yourself at the forefront of innovation. With comprehensive support programs, we ensure a seamless transition into our team, empowering you to hit the ground running and excel in your role. What You Bring: - Over 8 years of experience as a Python Developer, specializing in web API development, data analytics, and machine learning. - Proficiency in Python and related frameworks/libraries such as Django, Flask, NumPy, Pandas, and scikit-learn. - Strong communication and collaboration skills, with the ability to work independently and solve complex probl...
