Vba dashboard excelpráce
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.
Potřebuji vytvořit dashboard pro meho chatbota vytvoreneho v html css js a logika v pythonu. Chci ten dashboard mit jako webovou applikaci
potřebuji dashboard pro mého chatbota, lidé si přes toto rozhraní mohou psát s lidma na stránce, chci aby to bylo na webové aplikaci a aby se tam mohli přihlásit.
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.
Analyzujeme pro účel včasné detekce nozokomiálních infekcí pacientů nestrukturovaná data zdravotní dokumentace. V kombinaci s daty strukturovanými provádíme hloubkové analýzy těchto informací a jejich vazeb. Jako jeden z nástrojů využíváme Watson Explorer. Pro účely jednodušší práce uživatelů tvoříme nový rozcestník, dashboard. jeho grafická podoba je vytvořena. Nyní hledáme konzultanta který vytvoří funkční propojení frontendu a aplikace.
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
Hledáme vývojáře který je schopný vytvořit android aplikaci která bude umět : Krokoměr, automatickou inicializaci (kolo,běh,chůze,auto), počítání kalorií daného uživatele, všechny hodnoty bude vracet v grafické podobě. Možnost počítání formou start a stop na začátku a konci jakékoliv aktivity viz. Výše (běh,kolo). Skica : -login (zatím jen staticky později se nápoji na server) - dashboard steps - grafy aktivit - možnost Play a stop (manuální měření)
...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...
Sháníme programátora na dokončení rozdělaného projektu. Kód velmi čistě psaný, neměl by tvořit problémy na pochopení. Stručné info níže. ** Product Statement ** Jedná se o jakýsi systém klubové základny. Jednoduše bych to popsal jako velmi jednoduchou sociální síť, něco ve stylu začínajícího Linkedinu, pro business účely. ** Sekce (stručně) ** - Dashboard (pouze určité info, stěžejní statistiky) - Přátelé / spojení (seznam lidí se kterými si můžeš psát přes Messanger - s ostatními to nepůjde) - přátele nepůjde přidávat, pouze ...
Hledám freelancera, který udělá aplikaci odesílající GPS souřadnice. Aplikace se bude do budoucna rozšiřovat, takže neuzavřít si žádné cesty. Workflow: -> Přihlášení uživatele oproti serverovému API nebo registrace (Odkaz na www stránky) -> Dashboard s ikonama (Zatím zde bude pouze sledování polohy) -> Při odchodu z aplikace musí posílat data na pozadí. Pokud ji uživatel nevypne v menu aplikace. Ve sledování polohy: -> Tlačítko začít sledovat X Ukoncit sledování -> Odesílá data na server pomocí get požadavku. Při zapnutí sledování...
...že se bude chatovat online a v jiném grafickém rozhraní. Po ukončení live instance, se celá komunikace pod daným číslem instance nebo identifikátorem uloží opět v položce zprávy. – Popř. využijeme 1.6 - Struktura webu, umožní vytváření editaci textových stránek/podstránek portálu ( články, FAQ, atď ) 2. Front end ( webová stránka ) - Dashboard - - Přehled nových poptávek ( z pohledu nabízejícího ) - Přehled nových nabídek ( z pohledu poptávájíciho ) - Zprávy 2.2 - Profil uživatele Zde uživatel bude moci přidávat své reference, infor...
I need virtual assistant, easy work just copy paste. More discusse with freelance chat...
I am looking for original, high-resolution images, uniquely taken within the USA. The required subject matter includes both niche and ordinary topics, a list of which follows: - Car details: Buttons, dashboard warning signs, and in-car graphics. - Product labeling: Recycling, dietary, disposal instructions, and quality symbols. - Traffic and safety: Parking and directional traffic signs, and safety signs. - Clothing: Labels and washing instructions. - Everyday life: Brand names and apps on products in real life situations. Please be mindful that these photos are specifically required in pristine quality and should not be found anywhere on the internet nor take as screenshots from mobile devices. Speed is also essential, as I need the project completed as soon as possible. ...
...charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. -...
I'm seeking a skilled Python programmer to develop a software module that can retrieve and process data from an Excel file. This bespoke software needs to display the data like a railway station scroller, strictly text-based. Key functionalities required include: * Picking data: The tool should extract data from the Excel file and output each row sequentially. * Sorting: While the display should be row by row, the order should be according to a certain criterion, instead of the original Excel sequence. Ideal Python programmer would bring: * Proficiency in Python programming, particularly in handling excel files and data sorting. * Previous experience or knowledge of creating text-based scrollers would be a plus. * Understanding of data presentation and...
My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.
Se necesita desarrollar una aplicacion movil para android y iphone en flutter que funcione como billetera virtual para un negocio. La billetera debe de considerar las siguientes caracteristicas: * Registro de usuarios. * C...titulares. * Recarga por medio de tarjeta de credito o debito (Se proporcionara detalla de la pasarela de pago y documentacion). * Recarga Manual por pago en efectivo. * Manejo de saldos. * La interfaz debe de ser sencilla y amigable. * Descarga de saldos por concepto. * Debe de tener una parte para el cliente final y una para el administrador. * Debe contar con un portal web para cliente y un dashboard de adiministrador tambien. * De preferencia si la aplicacion es en Flutter, aunque lo dejamos a discresion de ustedes. * El Codigo fuentes es propiedad de usua...
...in gathering emails of a list of companies I already have at hand. The job entails the following: - Extracting emails of the listed companies. Key job requirements include: - Proven experience in web scraping, data mining and Excel - High attention to detail and accuracy - Familiarity with email gathering processes The purpose of these emails is for sales and marketing purposes; thus, discretion and adherence to GDPR and other privacy laws are of utmost importance. The list I'll provide is in Excel format, therefore a good understanding and efficiency in Excel would be greatly beneficial. Please note that the turnaround time for this project is also very crucial, so your ability to work effectively within a given time frame is key. Please only bid if ...
I'm looking to build a comprehensive eCommerce dashboard for my brand, similar to examples provided (Meteorik, Databox, lifetimely & beprofit, report-pundit). Offering a deep understanding of eCommerce analytics, a right candidate should deliver a dashboard that intelligently aggregates and visualizes data from various sources, aiming to provide tangible insights for business performance. Key Capabilities to Include: - Profit & Loss Tracking: The dashboard should cover advanced metrics such as Revenue, Cost of Goods Sold, ad spend, Roas, Shipping cost, and True Profit after tax. ( All advance metrics on examples given ) - Key Performance Indicators: Significant focus should be placed on KPIs such as Visitor Conversion Rate, Average Order Value, Custom...
...and AI who can develop an advanced dashboard for managing energy and predictive maintenance of HVAC systems and allot the complaint to the technician team member and group Features Required: * Real-time energy monitoring to ensure operations are optimized for energy consumption. * Predictive maintenance alerts to facilitate timely intervention and avoid expensive breakdowns. * Historical data analysis for deriving insights that contribute to efficiency. AI Analysis: * Anomaly detection to instantaneously identify issues outside the expected parameters. * Fault diagnosis to pinpoint areas requiring attention and rectify them swiftly. * Energy efficiency optimization to minimize energy waste and maximize cost savings. Compatible Data Sources: * The dashboard should be co...
I have a registration system where players sign up for a sports event. These entries are in Wordpress and when they register the data gets pushed to a different system. There are about 200 records that did not sync and I need someone to manually go through and resync these. I'll provide an Excel file of the records that need to be resynced. To do this: 1. Login to Wordpress 2. Go to: Forms > Entries > Choose 'Spring 2024 Flag Football Registration' 3. Search for the players last name 4. Hover over their entry and click 'Resend' 5. Wait for it to process, then do the next one 6. Here is a video of the process: 7. You need to wait for each to finish to start the next, but you can 'resync' multiple at a time
We're on the lookout for self-motivated sales reps ready to roll up their sleeves and boost their earnings with our natural herbal products. With a proven track record and satisfied customers, our products offer a lucrative opportunity for those willing to put in the effort. Responsibilities: Drive sales of our natural herbal products to prospective cus...profit-sharing opportunity. As you contribute to our products' success, you'll share in the profits generated. If you're hungry for success and eager to boost your earnings through hard work, this is the opportunity for you! Join us in spreading the benefits of our natural herbal products far and wide. Ready to seize this opportunity? Submit your application detailing your drive and determination to excel in...
Hello, I have around 400 Postcodes in the UK, and out of those 300 are already done, so you need to search for the remaining postcodes on a website, I will provide you with all the ...remaining postcodes on a website, I will provide you with all the details along with a video tutorial + other details I will provide through WhatsApp messaging and calls. You will know about taking screenshots, I have a free Chrome tool, and I will provide it. it's a Very Urgent Project, so if you can start work Immediately and finish within the next 24 hours, then only apply. You should know the Excel and web-based copy/paste knowledge. This is a challenging job, and who can handle the pressure, the right candidate can get regular work. Hindi-speaking people will get preference. Happy B...
I'm in need of a proficient individual with strong data extraction skills and a good knowledge of Excel. The task is focused on extracting both text and image data from 1-2 websites. It is essential for the freelancer to have capabilities in: • Website data extraction • Handling of both text and image data • Organizing and managing the extracted data in Excel. An eye for detail and a knack for organization would be key for this project. Experience in similar projects is also a great advantage. This task requires utmost accuracy and adherence to deadlines, thus a freelancer with a track record for prompt delivery would be ideal.
...größter Bedeutung. Die Website muss robuste Sicherheitsmaßnahmen implementieren, um Benutzerdaten und finanzielle Transaktionen zu schützen. 6. **Benutzerfreundlichkeit und ansprechendes Design**: Die Website sollte benutzerfreundlich gestaltet sein und über ein ansprechendes Design verfügen, das sowohl auf Desktop- als auch auf mobilen Geräten gut funktioniert. 7. **Verwaltungstools**: Admin-Dashboard zur Überwachung und Verwaltung von Benutzerkonten, Spielen, Einsätzen usw. 8. **Kundensupport**: Ein Kundensupport-System sollte implementiert werden, um Benutzern bei Fragen oder Problemen zu helfen. Bitte geben Sie in Ihrer Bewerbung an, welche Erfahrung Sie in der Entwicklung von Glücksspiel-Websites und der Integration von...
I need an expert to assist with converting PDF and Excel files into IIF to incorporate into my QuickBooks accounting software. This integration will be key in the transparency and efficiency of my financial transactions. Key responsibilities: - Convert files from PDF and Excel to IIF. - Ensure compatible formatting with QuickBooks. - Sort IIF files by transaction type for easy navigation and organization. Skills and experience: - Proficient in QuickBooks and IIF format. - Accurate data entry. - Deep understanding of accounting principles and financial data organization.
...indicated period. Interface System is a webapp based on a linux server Interface framework has to be scaleable, meaning it should be possible to add new menu sections in future Framework has to be adaptive for mobile and desktop. Control panel User needs to enter his username and password to login. When logging in a control panel becomes available for user. Menu has following sections: - Dashboard. Displays general statistics (we don’t do it at this stage. I may ask for it later) - Accounts. Adding and managing exchange accounts via API - Bots. Section that allows you to add subsections with bots with different strategies (we do only one at this stage) - - Pump detector. A bot that executes the strategy described above. - Settings. Access and security settings like cha...
I'm looking for a skilled individual with a keen eye for detail to create an Excel spreadsheet. This sheet will be handling different insurance companies' appetite guidelines, which are broken down by state. For example, I need to know which carriers write workers compensation in New Jersey Key Requirements are: - Excellent knowledge of Microsoft Excel for data organization and management. In your application, please include your asking price for this fixed rate project. Previous experience in the insurance field or with similar projects would be a plus but isn't a necessity. Looking forward to finding the best fit for this data-driven venture.
If you know how to code a javascript or python script to get a few pieces of information from Google, then this is easy for you. Here's all we need in this small project: 1. For a particular google search ON MAPs, the program would output the web URL, and name and send that to excel (or a csv) - other fields would be provided to include as well. 2. It should let me pick 1-50 entries. 3. It should work from within the browser (NO API calls necessary). that's it! Thanks for your bid
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel functions are automated, and feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freel...
Hello there is a free publicly accessible Google spreadsheet with 185 lines and 21 columns. Copy and download is disable. I need someone who is still able to copy the data into an excel spreadsheet or otherwise manually "copy" all data into an excel spreedsheet thanks I offer the link to the website after receiving bids Generic bids are ignored. Therefore pls write "i understand its a download disables google spreadsheet."
I'm looking for a skilled data science trainer who can introduce my large team to the foundational aspects of the field. Key Responsibilities: • Deliver beginner level lectures on data science • Train over 10 team members • Cover areas inclusive of Data Analysis, Machine Learning, and Predictive Modelling Ideal Candidate: • Ex...Machine Learning, and Predictive Modelling Ideal Candidate: • Expertise in data science education • Ability to conduct engaging, accessible training sessions • In-depth knowledge of Data Analysis, Machine Learning, Predictive Modelling • Experience in training larger groups The objective of this training is to equip my team with basic data science capabilities. Thus, patient trainers who excel in bre...
I need a skilled and creative freelancer to create 100 different invoices for me in Excel. Each invoice must have its own distinct company design and company logo. Here are the specifics of the project: - I am giving you complete creative freedom to design each invoice. Let your mind run wild! - The invoices should include placeholder information whilst also leaving some areas blank. This will provide a more customizable experience. Ideal skill set includes: - Proficiency in Excel - Graphic design inclination - Creative thinking - Attention to detail Looking forward to seeing your brilliant designs shine on each invoice.
I'm looking for an expert PHP developer with proficiency in Codigniter to modify and enhance an existing script I bought from CodeCanyon. Task Details: • Modify existing func...functionality and add new features to the script. • Add three new fields to the signup window code and sync it with the mySQL database. These fields should include text fields and dropdown menus. • Create a report based on data from one table in the mySQL database. • Implement a feature to export the report data to Excel. Ideal Skills and Experience: • PHP and Codigniter expertise • Experience with SQL database manipulation • Knowledge in report generation and data exporting to Excel • Proficient in UI design with a focus on text fields and drop...
I'm in need of a developer to build a simple CRUD website. A few specifics about my requirements: 1. The website should interact with an Excel file; enabling data extraction and modification directly from and to the file and Display the records in a grid or tabular format. 2. Search option to look for connection details with Applicant ID. 3. Add a date picker to filter via date range via date of application. 4. Option to view/edit electricity connection application requests. a. Refer dataset for the data attributes. b. Could be on same or different page. 5. Data Validation. a. Should not be allowed to change some data and put validations on a few fields. Nothing complex. 6. Create a visualization graph e.g., bar or line chart for number of connection requests in every month. Th...
I require a freelancer who is proficient in extracting specific data points from a PDF document and translating it into a structured Excel or CSV file. The data is presented within paragraphs. Key Tasks: 1. Extract the following elements from the PDF: Names, dates, numerical values, lead location, phone number, email, US dollar value, status, date added. 2. Organise these elements in a structured format in an Excel or CSV file. Skills Required: - Attention to detail - Proficiency in data extraction - Strong knowledge of Excel or similar data management software - Ability to interpret information from paragraphs. Freelancer should assure accuracy as the correctness of extracted data is essential.
...information. -Ensure all guest details, including name, email, phone number, reservation number, booking period, and payment information, are promptly forwarded for record-keeping and follow-up purposes. Requirements: -Strong attention to detail and accuracy in task execution. -College degree or equivalent qualification preferred. -Proficiency in basic software tools, including Microsoft Office (Word & Excel). -Ability to operate electronic devices (computer or phone) proficiently. -Fast-paced and adaptable to changing priorities. -Ability to commit to 10-30 hours per week, approximately 2-4 hours per day. -Willingness to undergo a short trial test or task, lasting 2-4 hours, with the possibility of extension up to one week if necessary. Duration: The duration of the jo...
I am presently working on an extensive project involving several excel spreadsheets. These spreadsheets contain sentences for a book and I require a freelancer to help me color code the cells based on different categories. The color will represent different aspects of each category. The color coding will include: - More than 10 different categories - Existing color suggestions that need refining - Categorization that's based on multiple factors, going beyond the book chapters The ideal freelancer for this job should possess a good understanding of Excel and have a knack for good organization and attention to detail. Strong collaboration and communication skills are key, as I'll need to discuss and finalize the color scheme and the factors affecting categorization...
I'm in need of a proficient Excel expert who can proficiently apply formulas to my dataset. Here's what you'll be taking on: - Add 'Sum', 'Average' and 'Count' functions to the given data set. Your expertise in implementing these formulas will be highly valuable. - The dataset needs to be sorted based on validity. I'm not entirely certain whether ascending or descending order would work best, so I'm open to your professional advice. - Prioritization should be given to the most recent entries. They should appear at the top of the dataset after sorting. To succeed in this task, you must possess advanced understanding of Excel functionality and a keen eye for detail. An ability to work independently, make efficient decisi...
Need nay type of data entry work
Hello, I and creating a 3-year business plan. I have the first-year projection but I need to calculate the subsequent years, both 2 and 3. I need to add 15% each year which I am using year one as a basis to calculate and add 15 percent each year.
...as app’s functionality, it must have the following key features: - Online payment system - A real-time schedule availability tool - Service selection options For comprehensive management and to improve user experience, User and provider apps along with a management dashboard are required. Additional features for user and provider apps should include: - Push notifications - Rating and review system to ensure feedback and constant improvement - Appointment reminders to minimize no-shows and last-minute cancellations. To excel at this job, you need: - Strong experience in mobile app development across both iOS and Android platforms. - Experience integrating online payment systems. - Familiarity with developing real-time scheduling tools. - Track record of creati...
...validate data from an excel file to a database. This function should be equipped with the following features: 1. Data Type Validation 2. Data Format Validation This task requires proficiency in database structures, data validation methods, and experience working with Excel file manipulation. The ideal candidate, consequently, should be able to display capabilities in these areas. Their experience in similar projects would be a bonus. Here is the main flow: 1. User upload excel file 2. System will check and validate the data 3. System saves record into multiple tables in a database 2 types of excel files involved. Please check attachments. 3 types of data will be stored into database 1. User profile 2. User farm 3. User plant Detailed flow: 1. User u...
I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functions like automa...