Capturing data excelprá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í.
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
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and...
...Conversion of 24V input to 12V and 5V outputs. MOSFETs: 5 MOSFETs for 24V, 7A control. 4 MOSFETs for 12V, 5A control. Communication: USB Type-C for robust serial communication. Inputs and Outputs: 2 analog inputs. 1 One Wire communication interface. Additional pins for digital input/output as required. Deliverables: Complete PCB design files ready for manufacturing, including gerber files. Schematic capturing and PCB layout. BOM (Bill of Materials) with sourcing options. Documentation for assembly, testing, and troubleshooting. Qualifications: Proven track record with PCB design for power-intensive and multi-function projects. Proficient with voltage regulation techniques in PCB designs. Familiarity with RP2040 microchip and serial communication protocols. Proficient in electro...
...project, I am seeking a skilled Python developer with experience in using Playwright to develop a set of flexible data scraper tools. These tools will be deployed to capture data and screenshots from a variety of popularly visited websites such as e-commerce platforms, directories, social media and news sites which includes but not limited to eBay and clinicaltrials.gov. Key functionalities should include: - Capturing various data types such as product details, pricing information, ratings, reviews, and any other elements visible in a full-page screenshot. - Organizing the captured data and screenshots in a clear, easy-to-navigate folder structure. - Being adaptive enough to scrape data from a widely diverse set of websites. To be successfu...
...- Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high analytical skills Please provide ...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
Es ist eine Aufgabe die in Excel gemacht werden muss, bzw Excel Solver bis 10.05
La tarea sera la gestión completa de cuentas para los anfitriones de distintas pl...de propiedades. Necesitamos especialistas en atención al cliente que puedan encargarse de las tareas administrativas y la gestión de cuentas. Los requisitos para el solicitante incluyen gran atención a los detalles, título universitario, acceso al correo electrónico y conocimiento del uso de un dispositivo (computadora o teléfono), herramientas de software básicas (Microsoft Office - Word y Excel). Necesitamos miembros rápidos, precisos y especializados. Es obligatorio aprobar una prueba corta/terminar una tarea, que podría durar entre 2 y 4 horas, con posibilidad de extenderse hasta 1 semana, si el candidato está inv...
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My expectat...
We're on the hunt for an experienced mobile app developer to create an innovative software for iOS and Android devices. A central feature of the app is its ability to let users upload a home photo and modify the driveway with custom colors and textures of our products. Key Features Required: - Photo capturing capability via device camera - Feature to apply our product colors and textures to the driveway area in the photo - Predefined color and texture options along with color picker tool for customizations Ideal Skills: - Proven experience in mobile app development, with a focus on photo editing features. - Proficiency in iOS and Android platforms - Ability to integrate color picking tools and texture mapping features. Our primary goal is to boost our custom product sa...
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and dat...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
K zobrazení podrobností se zaregistrujte nebo přihlaste.
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex ...
I'm hosting a corporate event that is estimated to last for 2 hours, and we need a skilled and professional photographer who can capture networking shots during the event. Ideal Skills and Experience: - Proven experience in corporate event photography - Adept at capturing the essence of networking events - Efficient, discreet, and able to work under tight schedules - A strong portfolio showcasing a wide range of photography techniques This job is perfect for someone who can masterfully capture candid moments and interactions during a business networking event.
I need a seasoned videographer to create a high-quality and comprehensive 2-hour documentation video capturing all aspects of a dance recital. This video will not only serve as a historical record, but also provide insightful visuals of both the solo and group performances. Key Responsibilities: - Capturing all dance sequences, laying greater emphasis on solo and group performances. - Manipulate and edit film pieces in a way that is invisible to the audience. - Use expertise in visual editing to craft a dynamic and cohesive narrative. Ideal Experience and Skills: - Previous experience videographing dance recitals or similar stage performances. - Proficiency in digital editing systems and packages (like Avid Media Composer, Lightworks, Premiere, After Effects and Final Cut...
Looking for a talented drone cinematographer to capture an enchanting natural landscape. The footage will be used for commercial purposes, making it crucial to create a vibrant, and colorful visual experience that embodies the pure beaut...footage will be used for commercial purposes, making it crucial to create a vibrant, and colorful visual experience that embodies the pure beauty of nature. Key requirements: - Exceptional skills in drone operations, focusing on outdoor and nature cinematography - Proven experience in capturing vibrant and lively aesthetics through drone footage - Strong knowledge of editing and post-production process The right candidate will have experience with commercial projects, an eye for detail and a knack for capturing the vibrant hues of natu...
I'm looking for a talented designer who can give my cur...designer who can give my current logo a fresh and modern facelift while maintaining its key elements. Here are some specifics: - We want to keep the existing color scheme, typography, and icon/image. These elements are essential to our brand identity. - The new logo should convey professionalism and elegance as key messages. - We're looking for a design that is both minimalist and modern, capturing the essence of class. An ideal candidate for this project would be a designer with a keen eye for both classic and modern design aesthetics. You should have experience in logo redesigns and be able to maintain a brand's core identity while giving it a fresh look. Your portfolio should showcase a mix of minimal, c...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budg...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've wor...
I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...
I'm in search of a skilled drone operator with experience in film production. The work involves capturing footage in natural landscapes with a high-resolution drone camera. Key requirements: - Experience in film production: The ideal candidate must have a background in operating drones for film production, understanding shot composition and movement. - Strong drone control: The landscapes can be challenging, so a high level of drone control and precision is crucial. - High-resolution camera experience: The drone needs to have a high-resolution camera, which the operator must be familiar with using to capture cinematic quality footage. Please provide examples of your previous work in film production if possible.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
I'm seeking a talented graphic designer to create a bi-fold brochure targeting business professionals. The style should be creative and modern, capturing their attention and succinctly conveying the content. Key Requirements: - Design a creative and modern bi-fold brochure - Targeting business professionals - High-quality, professional design Ideal Skills and Experience: - Proven track record in designing brochures - Understanding of business professional audience - Strong design skills with a modern touch
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized d...
I require a unique Twitch stream overlay capturing the essence of a thunderstorm. Key features of the project include: - Thunder/Lightning/Storm theme: I want an overlay that portrays a thunderstorm, emanating high energy and excitement in sync with my stream's content. An energetic, electrifying context to resonate with my audience. - Alerts for Follows/Donates/Subscribes: Integrate a system that displays custom alerts, catering to followers, donating viewers, and subscribers. These alerts should be dynamic and storm-themed, synchronized with the overlay. - Starting/Ending screens: To maintain viewer engagement, I need well-designed starting and ending screens that set the tone at the start and wrap up the stream elegantly. Screens should blend into the overarching sto...
I require a unique Twitch stream overlay capturing the essence of a thunderstorm. Key features of the project include: - Thunder/Lightning/Storm theme: I want an overlay that portrays a thunderstorm, emanating high energy and excitement in sync with my stream's content. An energetic, electrifying context to resonate with my audience. - Alerts for Follows/Donates/Subscribes: Integrate a system that displays custom alerts, catering to followers, donating viewers, and subscribers. These alerts should be dynamic and storm-themed, synchronized with the overlay. - Starting/Ending screens: To maintain viewer engagement, I need well-designed starting and ending screens that set the tone at the start and wrap up the stream elegantly. Screens should blend into the overarching sto...
I would like de...Let's Make Cyprus Green, an environmental NGO dedicated to creating a cleaner and greener Cyprus for all. Let's add a splash of color to your day while making a positive impact on our planet. Join us in painting a brighter future, one face at a time! Thank you for your support! --------------------- SIGN 2: Smile for the Camera! Please be aware that this event is being photographed! We'll be capturing all the fun moments and memories throughout the day to share on our social media channels (@letsmakecyprusgreen). By participating, you consent to having your photo taken and shared. Let's showcase the joy and excitement of our event with the world! If you have any concerns about being photographed, please let our team know. Thank you for be...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and ...
...central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP servers and familiar with Filezilla - Experience with network security and data ...
...Mandatory Skillset:Seeking a skilled SSAS Developer to contribute to our team's success. Responsibilities include designing, developing, and maintaining SQL Server Analysis Services solutions for business intelligence and data analytics requirements. Tasks involve creating data models and developing multidimensional cubes. Key skills required: expertise in MS SQL Server Analysis Services (SSAS) Tabular and Multidimensional. Proficiency in TSQL for writing performant queries is essential. Experience with data visualization and reporting tools is highly valued. Additional knowledge of Excel and .Net development is advantageous. Strong problem-solving abilities, excellent communication skills, and a collaborative mindset are desired traits. Developer has t...
...professional data entry specialist to input information from various sources into an Excel spreadsheet. This project involves a mid-range volume of entries, approximately between 1000 and 5000. Key requirements: - Skilled in data entry, particularly in an Excel environment. - Ability to maintain high accuracy and consistency throughout the project. - Previous experience in handling medium to large data volumes. - Understanding of basic statistical analysis for post-entry work. Once the data is entered, I require basic statistical analysis to be performed. This will involve simple calculations and organization of the data in a meaningful way. Ideal Skills: - Proficiency in Microsoft Excel - Attention to detail - Basic statistic...
