Excel code vbs vba data baseprá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.
Conditions: We require and are looking for a freelacer who is able to communicate on a regular daily basis. We are looking for someone who has extensive experience in copywriting, where it is possible to document previous assignments and work. The required respondent should be able to 100% complete the set dates and form of assignment. We require 1x preliminary revision of the work and 3x total revision of the completed work. About us: We are an advertising agency together with a video and graphic studio, which focuses on medium and large companies. Form of audit and brochure: Technically describe how a particular industry works, list the subcategories that may be audited for the proper functioning of the brand or project. In individual branches and mention and incorporate the methodolo...
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í.
Mám 2 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.
Mám 3 programy (kódy pro mikroprocesor STELLARIS) a potřeboval bych jejich jednoduchou úpravu, podle zadání. Více info pošlu do zprávy.
MAKE A 3D VIDEO ,FOR APPS AND CONSOLE. BASE A IDEA I HAVE OF Machu Picchu LOCATED IN LIMA ,PERU
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
You develop customizations of the ticketing system OTRS and other Perl applications including testing and bug fixing. Moreover you are participating in data base development in SQL. As a developer you actively participate in an agile development process („Scrum“). Your profile You have a degree in computer science, business or media informatics or comparable areas with several years of experience in Perl development. Good knowledge in database programming (MySQL) are part of your skill set as well as a basic knowledge of Linux. Ideally you are familiar with the ticketing system OTRS. Moreover, you are a team player with excellent analytic and conceptual skills in combination with good language skills in English and ideally German. What we offer Innovativ...
I want few methods from objective c to java to be translated.
...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...
For my project, I need a freelancer with strong skills in data scraping and extraction, particularly with textual content and figures, from a specified public website - Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indica...
...recently cloned a code from a GitHub repository that uses Python for data analysis. I am seeking a Python expert who, after testing the code to ensure it operates correctly, can guide me on how to run it smoothly and effectively. Specifically, I am struggling with: - Algorithm implementation. The successful candidate should have in-depth experience with Python, especially around data analysis, and possess the ability to explain complex coding and algorithm structures in a simple, palatable manner. It would be highly advantageous if the candidate has prior experience with teaching or coaching on code implementation. Mastery in explaining data analysis algorithms is a must. In your proposal, please share instances where you helped others und...
Somos una empresa dedicada a ofrecer un servicio audiovisual de alta calidad. Contamos con nuestro innovador servicio de tours utilizando un dron FPV (Vista en Primera Persona), el cual proporciona una experiencia inmersiva tanto dent...servicio audiovisual de alta calidad. Contamos con nuestro innovador servicio de tours utilizando un dron FPV (Vista en Primera Persona), el cual proporciona una experiencia inmersiva tanto dentro como fuera de su local. Nuestra trabajo garantiza una experiencia única para nuestros clientes, permitiéndoles explorar su entorno de una manera completamente nueva y emocionante. Ofrecemos nuestro producto base, un video tipo institucional (recorriendo el lugar) con tomas internas y externas con algunas fotografías aéreas del...
I need a skilled designer to create minimalist artist sketchpad front (and back) covers. The desired colour scheme is a stark white base with subtle, artistic splashes of colour. Key requirements: - Design 4 minimalist, modern & professional looking sketch book covers incorporating our brand logo (choose from attached) - Avoid adding pictures or paintings as illustrations - Incorporate a white base with artistic, splashes of colour. - Design is for an A4 sketch pad but must be scalable for different paper sizes Skills/experience: - Proficient in graphic design and illustration - Prior experience with book or art supplies cover design - Familiarity with minimalist design principles and aesthetics - Ability to create visually appealing splashes of colour. - Evidence of ...
I'm in need of an application that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accuratel...
I'm in need of a proficient social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attention-to-detail...
...level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces). ii. It uses a “What is your current yearly revenue” number and pulls against an array (worksheet) – For the 8 other reports, it pulls data from the column in the array to produce reports. b. Customer EBITDA and P&L – Some data from the array is utilized here, and this being a customer input screen, ...
We are urgently looking for a few cold callers to join one of the fastest growing agencies in the mortgage/real estate industry This is a commission based job for the first few weeks, if you are good and are able to generate us deals consistently, you will be given a base salary as well Requirements: YOU MUST HAVE LITTLE TO NO ACCENT Must be able to stay consistent Must be able to dial for 1-3 hours daily 5 days a week Job Description: - A list and script will be provided to you as well as the software to make calls - You only need to work for 1-3 hours daily - We will train you 1 on 1 to make you the best cold caller there is - You will need to book prospects in for a meeting to speak to our sales team About us: Diamond Equity is one of the fastest growing agencies in the mo...
I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messagin...Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendly, reliable, and able to handle the company's internal resources efficiently. The Most important thing is the BOT must be PRIVATE and the only method to subscribe to BOT channel is by OTP sent to the registered e-mail in my company domain. The email list will be provided by excel sheet to you. The second MOST important thing is that the bot channel must be un...
...a consultant with expertise in executive compensation. Key responsibilities will include: - Evaluating our current compensation structure for the CEO and CFO, specifically base salaries and bonuses and stock / stock options - Providing strategic advice on how to optimize our compensation package, potentially incorporating stock options - Drawing on experience with comparative executive compensation from similar companies in the medical device space. The ideal candidate will have an extensive background in executive compensation and a track record in the healthcare industry. Specialized knowledge in base salaries, bonus structures, and stock options is considered a top asset. A robust understanding of compensation trends along with innovative strategies to attra...
I'm a professional hair stylist specializing in hair cutting, styling and healthy haircare. I'm seeking someone who can help me establish connections with salons, and book me for hair shows and events. Key Responsibilities: - Finding and reaching out to individuals to secure bookings. - Booking me for hair sho...events. Key Responsibilities: - Finding and reaching out to individuals to secure bookings. - Booking me for hair shows and events. Ideal Skills: - Excellent networking and communication skills. - Experience in sales or event management is a plus. - Familiarity with the beauty or fashion industry. I'm currently relying on word-of-mouth referrals but looking to significantly expand my client base. It's crucial that you're able to effectively pit...
You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.
I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as...
I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure the tool remains...
I have a database with 200,000 SKU's from retail sales, un...SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will...
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
I'm seeking a seasoned Instagram manager who is adept at increasing followers and engagement while drawing attention to my interior design services. I'd like you to: - Focus on growing my follower base dramatically. - Stimulate and interact with my audience, resulting in higher engagement. - Convert this increased visibility and engagement into actual business. Ideal candidates should have: - Extensive experience in managing social media, particularly Instagram, for businesses. - A track record of building followers and promoting engagement. - Knowledge of the interior design industry or a willingness to research and learn. - Skills in presenting services attractively to professionals and parents. - Expertise in turning social media engagement into real-world business. ...
...Specifications: + All designs must include the following information on the packaging: ------- 12oz (340g) ------- 100% Roasted Coffee ------- Manufactured by: Roastify LLC ------- Bend, OR 97702 + Designs must all be unique with minimal duplicated content. + Designs must be created in our designer () + All designs must begin from our base template to ensure compliance with our app. To upload base template go to file -> open -> choose the file you download below (). Project Deliverables: + 20-30 unique and varied designs that integrate all necessary content. + JSON files should be downloaded from the designer studio and uploaded as final deliverable. + JPG file of design also uploaded with corresponding name as part of deliverable. +
...skilled designer to create a professional A4/3 size real estate flyer. This flyer will be divided into 3 equal parts for easy printing, where each part carries the same design. The focus of the flyer will be on promoting MY REAL ESTATE SERVICES , ASKING PEOPLE TO SCAN THE QR CODE OR GOTO WEBSITE AND CALL ME FOR FREE PROPERTY APPRAISAL, and including my contact information and a provided QR code. Key Requirements: - Design a professional real estate flyer with a clear and visually appealing layout. - Incorporate a QR code and my contact information in a seamless and effective manner. - Include an image of me in the design. The deliverable for this project is a PDF file of the final design. Ideal Skills and Experience: - Proven experience in designing real estate ...
...an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharashtra, Telangana, Haryana, and Delhi), Google, and Justdial. Here's what I am looking for: Details to Scrape: - Name - Mobile Numbers - Locality - City - Address - Pincode Platforms: - RERA Websites (Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivere...
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of spec...
...Sparklayer: - "Quick Buy" Page: This will substitute our current List view, enabling clients to quickly see prices and make bulk orders without navigating through individual product pages. (example is visible in another installed theme) - 'Unit Cost' Display on Product Page: Prices need to be shown in kilograms and automatically sync with Shopify's unit pricing, factoring in base price and dynamic calculations. (example code: ) Ideal candidate should have: - Proven experience with Shopify theme customization - Knowledge of B2B eCommerce solutions - Familiarity with Sparklayer integration - Fluency in JavaScript, HTML/CSS, and Liquid - Ability to implement mobile-responsive design features - Experience in dynamic pricing display Specifics: - Cu...
I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.
I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeepi...
I need an Excel expert to help me document my financial data in a specific text-based format. Key Requirements: - Organizing and documenting financial data in Excel - Following a specific text-based format provided by me Ideal Skills and Experience: - Proven experience in working with financial data - Proficiency in Excel, including advanced functions for data organization - Excellent attention to detail and ability to follow specific instructions accurately and efficiently.
...14 and could use a seasoned consultant to guide me through the process. Here's what you should expect from this project: - **Consultation:** - I'm looking for someone who is very familiar with Next.js. Your role will be to guide me through the conversion process and answer any queries I may have. - **Primary Goal:** - The primary goal of this work is to help me translate a react code base into nextjs app (14.0) route. - **Specific Assistance:** - Though I have a good grasp of , I might need assistance in mapping react components into the app. This is an essential part of the conversion that I might need help with. Your expertise in , particularly in to mapping react components, will be vital for this project. A good consultant should be able ...
Estoy buscando un experto en procesamiento de textos y formato de PDF que pueda convertir mi documento de Word en un libro-manual en PDF de aspecto profesional. El proyecto implica: - Ajustar el formato del documento, incluido el estilo y tamaño de fuente, los márgenes y espacios de la página, y la adición de encabezados y pies de página. - Creación de un índice en base al contenido del documento. - Inserción de imágenes relevantes cuando corresponda para dividir el texto y mejorar la comprensión del buscando un experto en procesamiento de textos y formato de PDF que pueda convertir mi documento de Word en un libro-manual en PDF de aspecto profesional. El proyecto implica: -Ayudarnos a crear un cover para la pri...
Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.
I have a backend code for a pre-existing fully function website and mobile app. The backend code is currently all written in php. I need someone to convert this existing php code into fully functional python code which I can deploy.
I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligator...should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project i...
I'm in search of a tech-savvy Sales Executive with 3-5 years of experience, who can help me expand my customer base. Job Title: Sales Executive Company: IT & HealthCare Pro Location: Worldwide (Remote) About Us: IT & HealthCare Pro is a dynamic StartUp, an innovative IT company specializing in providing cutting-edge solutions tailored to streamline the rapid delivery of software. We believe in everything as a code, continuous security, continuous integration, continuous delivery, continuous monitoring, continuous and Learning a focus on delivering high-quality IT services and products, we strive to empower organizations to streamline their operations and enhance repetitive tasks in automation. Job Description: We are seeking a motivated and results-driven Sal...
I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.
