Excel dashboard add insроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I am in need of a freelancer to assist with manual data input. The task will involve extracting and inputting numerical data from Excel spreadsheets. Ideal Skills: - Proficient in Excel - Attention to detail - Fast and accurate typing skills
...is to create a chat feature that connects to each order we receive on our website (an order means when a customer makes a purchase). Once we have the chat feature connected to the orders, we will create a dashboard for my employees so they can log in to the website. The employee will log in from the website as the client, but they will be assigned a role that allows them to see the dashboard as an employee. I will connect the order with the employee, allowing them to complete the job and communicate with the customer. These are the important aspects. I will show you how the employee dashboard will look and what it will need. There will also be some buttons added, but first, I need someone who is confident they can do the job ( please If you asking more then 400 USD ...
...Vendor/contractor database for outsourced maintenance or repairs. • Assign tasks to staff/vendors and track progress/costs. 8. Advanced Analytics • Occupancy trends, vacancy patterns over time. • Maintenance cost analysis (by property/unit). • Potential for predictive insights (rent forecasting, AI-driven maintenance). 9. Import/Export & Data Migration • CSV/Excel bulk-import for existing records (properties, tenants, etc.). • CSV/Excel export for accounting, sharing with partners, or offline analysis. • Simple data migration tools to ease transition from legacy systems. 10. Security & Compliance • Role-based access control, encrypted credentials, and secure endpoints. • Audit logging (track who edited what ...
I'm looking for someone skilled in Excel to help me with a data transfer task. I need to pull information from one spreadsheet and add it to a column in another. Key Requirements: - Transfer of text data between two simple spreadsheets (comprising simple rows and columns) - Matching of data based on an exact match in a single column Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks
...tu ayuda para implementar el trabajo de un compañero el cual llamo "" donde tiene las formulas que necesito y un diseño basico. Necesito tener un adminsitrador que permita o siguiente: -Registrar nuevos clientes y detectar cuanto se demora en crear el nuevo cliente -Generar proforma de articulos y tiempo que demora en generar la proforma -generar Factura o boleta de venta de articulo -dashboard con las ventas , clientes y proformas/boletas generadas. Te puedo alcanzar mi proyecto comprimido...
EXCEL Manufacturing Product scheduler/run time tracker We are developing a means to schedule components in an integrated excel spreadsheet that includes various production steps: (Functions) Laser, shear, punch, bend, paint, assembly, weld, assembly 2, shipping. To be save on a network-share point so all can access same document. The idea is to have a laptop at each station (listed above) 1a,1st step: Manual enter/copy paste-from engineering Initial step-Enter data (component part number(description)) into the first sequence, list all items from the project that needs to be produced. once entered, you can filter material gauges, material types in order to consolidate production run on the LASER. When running the selected items (check box) we track time to produce on lase...
I need help organizing confidential client data in an Excel spreadsheet. The data is currently in one column and needs to be split into appropriate columns for First Name, Last Name, Phone number, Email, Birthdate, Mortgage start date, mortgage term, and Client Birthday. - Required Skills: Intermediate level Excel proficiency, with experience in using formulas to manipulate data in Excel. - Platform: The session will take place on Microsoft Teams, where I will share my screen. - Data Format: The data is currently organized in an Excel Spreadsheet. Due to the confidential nature of this data, I am unable to share it via email. The ideal freelancer for this job would be able to work swiftly and accurately, ensuring that the data is correctly organized.
I'm in need of a doors and windows-based software that can generate production drawings and quotations based on my cost estimations. I've laid out the algorithm in Excel files, which will be provided for this project. As a developer, your responsibilities will include: - Creating a user-friendly interface (UI) that allows easy access to the software's functions. - Implementing the cost estimation and production drawing generation features. The ideal candidate for this project should have robust experience in: - Java with JavaFX: This is my preferred programming language and framework for this project. - Software development for Windows: The software needs to be compatible with this platform. - UI design: The software should have a simple, intuitive interface. Plea...
I have a small excel file. I need to convert in excel VBA. The project will be completed by Spanish language. The file and more details will be shared via chat box. Thanks!
...demonstrate their previous work with PHP and JavaScript applications, particularly their experience with frontend bug fixing and UI enhancements. About the App (TLDR): A job searching and recruiting application for a niche market of short term contract workers. Based in Ireland. There is a sign up process, Profiles, Chat options etc. Technical: 3 Solutions: App - javascript API - PHP Dashboard - Javascript About the App (public facing version): Are you an hourly worker, struggling to find a job that works for you? Is finding new opportunities based on word of mouth or luck alone? Do you struggle to know where to look? Or are you a business owner desperate to recruit a solid workforce, the beating heart of your company, but you’re chasing your tail trying to find ...
...for a church marriage department. The application will include: - User registration and login system to unlock content. - Features for booking appointments (in-person or virtual). - A resource section providing access to videos and articles. - A forum feature where users can ask and receive answers to questions. - Access to Marriage and Growth classes via Zoom integration. - A user dashboard to view reviews of their counseling sessions. Ideal skills include experience with web development, integration of third-party tools (like Zoom), and building intuitive and secure user dashboards....
I'm seeking a skilled Excel expert to create a reconciliation tool for comparing two payment datasets. The first dataset comes from our internal ledger (Genie Ledger), and the second from our payment provider (Payment Gateway Data). Key Tasks: - Identify important data fields for reconciliation, considering factors like Transaction ID, Amount, Date, Payer Information, Payment Method, and Bank Details. - Develop a tool that compares the two datasets, showing all workings on a dedicated front cover sheet. - Identify any reconciliation discrepancies and highlight them on the front cover sheet. The ideal candidate should have: - Extensive experience in using Microsoft Excel, particularly with macros - Strong analytical skills - Attention to detail and ability to present d...
I require assistance with developing a macro in Excel. The macro needs to interact with local Excel files and perform specific functionality. The details of the functionality will be provided after the initial discussion. Ideal skills and experience for the job include: - Proficiency in Excel, particularly in macro development - Experience with automating tasks in Excel - Ability to understand and implement specific instructions - Good communication skills for discussing project details
I'm looking to develop a multiuser website for collecting school ID card data and capturing photos. Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: ...Key Features: - User Access: The website will be accessed by teachers and administrators. - Photo Capture: Users should be able to upload photos from their devices and also utilize real-time camera capture. The website should NOT include editing tools such as cropping. - Data Collection: ID card data will be uploaded via CSV/Excel files. Ideal Skills: - Full-stack web development - Experience with real-time photo capture integration - Proficiency in handling CSV/Excel uploads - Knowledge in developing multiuser platforms Please provide examples of similar projec...
Presupuesto 8 dólares Hola. Necesito el apoyo para hacer una hoja de cotización funcional en excel, pero con el diseño de imagen corporativa .png / .jpg colocada como fondo. El diseño corporativo de la hoja membretada ya la tenemos y abierto a sugerencias para una mejor solución.
We are looking for...unrelated sites). We will provide: A list of websites you can use to offer links in return (, , etc.). A tracking system for reporting progress. Requirements: - Proven experience with link building and outreach strategies. - Excellent communication and negotiation skills. - Ability to use email tools and outreach platforms effectively. - Familiarity with Google Sheets or Excel for reporting progress. Payment Structure: - $100 for every 50 live and verified links. - Bonuses available for exceptional performance and securing links from high-authority sites (DA 50+). Websites You Can Offer in Exchange:
Usaha kami bergerak dibidang kuliner yang berlokasi di pluit. Kami sedang membutuhkan karyawan tetap untuk membalas chat customer via whatsapp, marketplace dan merekap order yang masuk setiap harinya. Persyaratan karyawan : - Wanita 20-30 tahun - Memiliki pengalaman menjadi admin onlineshop minimal 1 tahun - Rapih, teliti dan cekatan dalam bekerja - Memahami microsoft excel - Bisa menggunakan whatsapp dan marketplace dengan lancar. Untuk selengkapnya akan dijelaskan saat interview *Jam kerja jam 8.30-5 sore. Setelah jam 5 sore tetap harus membalas chat dari rumah.
I'm seeking a beginner-level assistant for my regular work. Your primary tasks will involve conducting research and creating simple PowerPoint presentations on given topics. Key Responsibilities: - Researching topics and creating simple PPTs - Hiring and interviewing team members - Managing existing team and content in excel Skills and Experience: - Strong communication skills English/Hindi - Proficiency in Excel and PPT Ideal Candidate: - A college student with a working computer - Looking for long-term work - Flexible with working hours Please note: - We will connect over a call on Saturdays or Sundays for planning and learning sessions.
...Commute Application. The project includes designing: 1. Customer App: Key Features: Schedule planning for pickup and drop. Real-time tracking of rides. Engaging and interactive interface to communicate with the driver. 2. Driver App: Key Features: Clear guidance for picking up and dropping off customers. Routine tracking and updates. Functional actions based on Business SOPs. 3. Web Backend Dashboard: Key Features: Manage and monitor all rides. Edit and update ride details as needed. Enable seamless coordination between company, transport owners, and drivers. Requirements: Proficiency in Figma for designing intuitive and user-friendly interfaces. Experience in designing mobile apps and web dashboards. Familiarity with best practices for usability and accessibility. Ability to c...
...development, testing, and deployment of features. Core Components: Web-based MIS: Backend: Handle APIs, database queries, and business logic. Frontend: Provide an intuitive interface for data entry, monitoring, and reporting. GIS Module: Geospatial data visualization. Integration of PostGIS for spatial queries. Mobile App: Offline data collection with synchronization. Support for Android and iOS. Dashboard: Real-time analytics and visualizations using libraries like D3.js or Chart.js. Interoperability Layer: Enable integration with external systems Data Storage: PostgreSQL for structured data. PostGIS extension for spatial data. Hosting: Cloud-based for scalability (AWS, Azure, or GCP). Use Docker containers for easy deployment and environment consistency. 2. Data Flow Design Inp...
I need a photo editing website that includes both an Admin Dashboard and a Client Dashboard. Admin Dashboard: - User management: Ability to manage clients - Analytics and reporting: Ability to track usage and engagement Client Dashboard: - Photo upload and download: Clients can upload their photos for editing and download them once they're ready - Order tracking: Clients can track the status of their photo edits The website should also have basic photo editing tools (like crop and resize) and filters and effects. Ideal Skills: - Web development - Dashboard design - Basic photo editing tool integration - User management systems - Analytics and reporting systems The website or web app will not have tools. It is more like an u...
I need an expert in Excel automation and API integration to help me in calculating GHG emissions, specifically Carbon dioxide (CO2). The primary data source for the calculations will be an API, so experience with API integration is crucial. The project involves: - Automating the process in Excel for GHG emissions calculation - Using API for manual data entry - Focusing on Carbon dioxide (CO2) emissions The final output of the project should be in the form of a dashboard visualization. Therefore, experience in creating dashboard visualizations is essential.
I'm looking for help with rewriting and transferring some Excel tables for financial reporting. The tasks are straightforward and primarily involve basic data transfer without the need for specific formulas or calculations. Standard formatting is acceptable, so no specific formatting guidelines need to be followed. Ideal skills for this project: - Proficiency in Excel - Attention to detail - Basic understanding of financial data - Good data transfer skills
...create a SaaS-based task management web application. This app should be built with the MERN stack (MongoDB, , React, Node.js) and include the following key features: - User registration with role-based access - A Kanban board for task visualization - Team collaboration tools such as comments and file sharing - Integration of a subscription and billing system (Stripe) - An analytics dashboard showcasing usage stats The primary goal of this application is to enhance collaboration within teams. Therefore, previous experience with building collaborative tools will be a significant plus. Please note that the development of this application does not need to support specific platforms such as iOS or Android at this stage; a web-based application will suffice for the initial launch. I...
I need my intricate Excel sheet transformed into a PHP web application, complete with a MySQL database. The Excel file consists of 10 interconnected tabs, filled with VBA functions and classes. Key Requirements: - Replicate data calculations and transformations in PHP - Create user input forms and validations - Implement user authentication system with multiple roles - User roles should include: - Admin: Full control and oversight - Editor: Able to modify content - Viewer: Restricted to observation only Ideal Skills: - Proficiency in PHP and MySQL - Extensive experience with Excel VBA - Strong understanding of user authentication systems - Ability to replicate complex data processes in web applications Please only bid if you have a solid portfolio demo...
...addresses. Source of Dataset: The dataset is provided in Excel format. Size: There are 11,817 entries requiring email addresses to be added. Data Type: The emails must be entered into the same spreadsheet. Important Guidelines: All email addresses must be sourced from publicly available information in compliance with GDPR and other applicable data protection regulations. The methodology used to locate these email addresses is at your discretion, provided it adheres to legal and ethical standards. Each email entry should be accompanied by a URL or source reference to verify its public availability. Ideal Candidate: Experience with manual data entry. Proficiency in spreadsheet software (e.g., Excel, Google Sheets). Strong web research...
...graphs, but the values aren't displayed on the graph bars. For better visualisation, I need the numerical values to appear inside the graph bars as text. Add Averages to Reports: In the report section, include an average of the survey results. This should be visible both on screen and in the exported .xlsx file. Skills Required: PHP MySQL JavaScript (for graph enhancements) Experience with data processing and performance optimization Deliverables: Improved CSV import functionality with faster processing and guaranteed file availability. Graphs with displayed values inside bars. Averages displayed in both on-screen reports and exported Excel files. Additional Notes: Please ensure the changes are thoroughly tested before delivery. Let me know if you require access t...
...bazate pe serviciile selectate. Integrare cu gateway-uri de plată (Stripe, PayPal) pentru tranzacții directe pe eduindex.ro. Documente: Încărcarea documentelor importante (ex. contracte, autorizații). Opțiunea de semnare electronică a documentelor și stocarea lor în siguranță. 3. Funcționalități pentru părinți: Dashboard personalizat: Vizualizarea informațiilor copilului (grupă, servicii, prezență). Acces la documente și facturi. Posibilitatea de a efectua plăți direct din dashboard. Comunicare directă: Funcție de mesagerie între părinți și instituții. 4. Integrare cu tema MyListing Pluginul trebuie să utilizeze baza de date și structura existente ale temei pentru gestionarea instituțiilor. Extinderea funcționalităților fără a afecta funcțiile nati...
Delivery Cost Mapping for WooCommerce example below Base Pricing by County and Weight Tier County Light (€) Medium (€) Medium Heavy (€) Heavy (€) Very Heavy (€) Fastway (€) Dublin 20 30 60 80 100 10 Cork 25 35 65 85 105 10 Galway 22 32 62 82 102 10 ... (Repeat for all 26 counties but different pricing per county excel be provided) Fastway Note: If all items are Fastway-eligible, apply a flat €10 delivery rate. Product that this applies too already done (and live like this) SIte already has fastways setup done, plust there is enquiry only about products which can't be ordered on the site. We expanding the setup to have 5 weight classes with each state/county (26 of them) having their own pricing for each weight class. However the surcha...
...data from Excel, specifically bond characteristics. The pages will include: Main, Bonds Selector, Indices, About Us, and an additional Bonds page. A Figma layout is provided and the task is to replicate it accurately. Key Features: - The website does not need to be responsive or mobile-friendly - Users will only view, not interact with or upload, Excel data Design Expectations: - A minimalistic and clean aesthetic, as opposed to modern or overly sleek designs - Corporate and professional styling is not required, but a clear understanding of minimalistic design is crucial Ideal skills for this project include: - Proficiency in front-end web development - Experience with Figma to web replication - Strong understanding of minimalistic design principles - Ability to work wi...
I'm looking for someone to help me with creating a data entry form . The Excel template is provided by me. This will be a simple form that I can add my projects data to a spreadsheet also I can edit the Data. The Excel rows should be added automatically once a new project has been added .
...in office tools such as Word, Excel, Google Sheets, and will also have skills in data security and the use of Adobe InDesign. Responsibilities: - Enter, verify and update data accurately in databases or documents. - Organize and structure files and databases for optimal accessibility. - Use tools such as Microsoft Word, Excel, and Google Sheets for data management. - Respect data security protocols to guarantee the confidentiality and integrity of information. - Create or modify graphic documents and media using Adobe InDesign. - Produce detailed reports and share them with relevant teams. - Collaborate with other departments to ensure smooth data communication. Technical skills: - Advanced knowledge of Microsoft Word, Excel and Go...
Job Summary: We're seeking a talented UI/UX Designer to create an intuitive and engaging dashboard for our tutors. You'll be responsible for the entire design process, from user research to high-fidelity prototypes. Responsibilities: Design user-centered interfaces for our tutor dashboard (web).
Looking for a detail-oriented data entry specialist for product catalog management. (~1,500 products) Key responsibilities: Manual data entry of product information into Excel/Google Sheets Accurately copying product image URLs from provided online sources Following provided guidelines for data organization Requirements: Strong attention to detail Proficiency in Excel/Google Sheets Reliable internet connection Ability to handle repetitive tasks with accuracy We provide full training and ongoing support throughout the project. Part-time/flexible hours available. Please share your relevant experience and availability to get started.
Project Brief: eCommerce Data Analysis and Visualization Objective: To leverage data analytics tools to enhance decision-making, improve sales performance, and optimize customer experience within an eCommerce platform. Key Contributions: Excel: Cleaned, organized, and processed large datasets to ensure accuracy and consistency. Conducted advanced analyses using pivot tables, VLOOKUP, HLOOKUP, and data validation techniques. Developed dynamic dashboards for real-time tracking of sales, inventory, and customer metrics. Power BI: Designed interactive dashboards to visualize KPIs like revenue growth, cart abandonment rates, and customer acquisition. Connected multiple data sources to create unified reports, providing actionable insights for stakeholders. Implemented DAX functions f...
I'm looking for a freelancer to help me link my Excel file containing employee names and shifts to another file. The data is personal and related to roster information. Ideal skills for this job include: - Proficiency in Excel - Experience with data linking - Understanding of personal data handling and privacy - Attention to detail
I'm seeking an Excel specialist to help me create a sophisticated dashboard and tracking tool for compliance data. Key Responsibilities: - Automating processes with macros to streamline compliance tracking - Assisting in the design and development of a user-friendly dashboard - Automated email system which track the due dates and triggers the email to the respective email addresses. Ideal Skills: - Proficiency in Excel with a strong focus on automation - Experienced in complex formula creation and data analysis - Prior experience in designing dashboards and tracking tools - Familiarity with compliance tracking is a plus Please provide examples of previous Excel projects you've completed, particularly those involving dashboard creation...
I'm looking for an expert in data management and Excel/CSV manipulation. The project involves merging multiple CSV files with custom combination rules. Key Responsibilities: - Analyze and understand the structure of the provided CSV files. - Implement custom rules to merge specific data from those files. Ideal Skills: - Proficiency in handling and merging CSV files. - Excellent understanding of Excel and its data manipulation capabilities. - Ability to understand and apply custom rules for data combination. - Strong attention to detail. Experience with data science or data analysis is a plus.
...online advertising, click data, or anti-fraud systems is preferred. - Familiarity with popular automation testing frameworks and tools (e.g., PyTest, Selenium, etc.). - Ability to set up and maintain testing environments, simulate user behavior, and design tests for boundary cases and abnormal scenarios. - **Data Analysis & Problem-Solving Skills** - Proficiency in using tools like SQL and Excel for data extraction and analysis. - Strong logical thinking and analytical skills to quickly identify and report issues discovered during testing. - **Communication & Teamwork** - Excellent communication skills with the ability to collaborate effectively with development, product, and security teams. - Highly self-motivated and responsible, able to perform well and m...
...for each role. 3. **Audit Logs**: - Include detailed logging of all user and admin actions for better traceability and compliance. 4. **User Verification Levels**: - Allow for tiered access based on KYC verification levels, enabling higher transaction limits for verified users. 5. **Performance Analytics Dashboard**: - Provide users with tools to view detailed performance metrics, trading history analysis, and profit/loss summaries. 6. **Social Features**: - Add a public leaderboard or social trading features where users can follow top traders or AI plans. 7. **Mobile Notifications**: - Push notifications for trading events, balance updates, referral bonuses, and system alerts. 8. **Integrated News and Insights**: - Include a newsfeed for market ins...
...simplicity, with clear headings, buttons, and instructions. High Contrast and Accessibility: Use high-contrast color schemes to make the text easy to read. Larger fonts and color-blind friendly palettes are essential. Responsive Layout: Ensure that the design adapts to different screen sizes, including desktop, tablet, and mobile devices. Use flexible grids and fluid images. Backend Features: Admin Dashboard: For managing questions, creating new exams, and monitoring user progress. Question Upload: The backend should allow uploading new questions and answers, including the ability to associate images or scenarios with questions. User Tracking: Track user progress through the exam, time taken per question, and overall exam completion. Timer Management: Allow the timer to be contro...
I'm seeking an Excel specialist to design a financial dashboard for monitoring investments. The dashboard will primarily display financial data and needs to be tailored to track investment metrics. Ideal Skills: - Advanced Excel skills - Data visualization - Financial analysis - Dashboard creation Your proposals should reflect your experience with similar projects.
...can be automated based on the completion of certain actions (e.g., completion of a task or checkpoint). Time Logging and Reporting: Log the time spent on each module for both students and instructors. Provide reports for individual students (time spent on each module, performance metrics). Generate instructor performance reports to see how efficiently they are managing student time. Real-Time Dashboard: A real-time view for instructors showing student progress, time elapsed, and upcoming tasks. Show real-time clock or countdown timer for each task. Automatic Time Calculation: Automatically calculate the total time spent on each student’s module. Include the time spent on various aspects like pre-trip inspection, driving practice, classroom sessions, etc. Notification & ...
I am looking for a skilled developer with proven experience in building complex and interactive admin dashboards, ideally for applications related to transport, logistics, or systems requiring real-time tracking. This project must strictly adhere to the following: Fixed Budget: €500 - €1,000 Deadline: Maximum of 2 weeks. The dashboard will be used to: Monitor real-time activity (drivers, passengers, and trips). Analyze performance using KPIs. Generate detailed historical reports. Provide a user-friendly and ergonomic interface, optimized for desktop and mobile screens. Budget and Deadline (Please Read Carefully): Budget: €500 - €1,000 (Fixed). Deadline: 2 weeks maximum. Applications exceeding the budget or timeline will not be considered. Key Features: Real-...
