Dashboard excel macrosprá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.

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.

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í.

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.

datae

datae

mise en forme

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

Napraviti Excel VBA program

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í)

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 require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.

Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+s...image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be created even if the brochure /excel or images (provided twice by us)has got duplicates 4) If the images are not clear as per the 900 X 700... YOU shall consider the image from the website. we will share you the link for your understanding if you require the a...

I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.

I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...

Se debe crear una hoja de vida de los clientes de ARH Soluciones a través de un dashboard así: Debe tener un inicio de sesión con seguridad básica: Login y contraseña Debe tener un CRUD de usuarios que tendrán permiso de admin: Documento, que a la vez será el usuario, contraseña, nombres, apellidos, cargo y rol dentro del sistema. Debe tener un CRUD de Clientes: Documento, Nombre, Dirección, Nombre del administrador, teléfono del admin, Nombres del Coordinador, teléfono del coordinador, zona, tickets asignados, guardas de seguridad asignados, teléfono de los guardas, turnos asignados. Debe tener un CRUD de Tickets que permita ingresar los tickets de soporte generados al cliente: como se supone que ...

...sets with inconsistencies or tend to be unreliable. Enhancements and overall App should be fine tuned for improved responsiveness, and a better customer experience. - Soften existing UI found within Communications: Modify the content being sent within email communications, with consistent interface populated with the appropriate details drawn from the App. - Admin Dashboard - surface additional details in the existing dashboard, that are already captured in the App, for better administration. The App does not have any e-commerce, it aligns customers with individuals within a geolocation to preform the task The ideal candidate should have significant experience in cross-platform app development, a strong grasp of Ul/UX design, and a proven track record in enhancing...

...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant app...research, and the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...

I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...

...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...

Looking for a Figma Designer for a dashboard. This project will require an overall layout with individual sections so do not bid by a per page but rather the main design and then a few pages within. Will discuss in PM.

...Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and Quick Learner Selenium Automation Unix Finance Domain Knowledge Automation Scripting using excel Macros Other Functions: • The Quality Engineer IV participates in the development and implementation of procedures for maintaining and or enhancing the integrity of Santander-s system application • Ensuring the existence of development and service standards • Ensuring that requirements are clearly defined and testable • Responsible for the creation and ex...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...

I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes...- Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Excel, as long as it's accessible online. As a freelancer, you should have experience in developing similar solutions and a deep understanding of stock management ...

I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the final product is user-friendly and has a clean, professional appearance.

I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks

I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm searching for a tutor skilled in Power BI to deepen my knowledge in dashboard creation, data modeling, and data analysis. Your rich experience in the finance, marketing, or healthcare industry will give a practical edge to my learning. My main objective is to master the tools required for analyzing business data.

tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...

I'm looking for a talented individual to build a data dashboard that will display our procurement spend data in a user-friendly and visually appealing way. Key Requirements: - Display Procurement Spend Data: The primary focus of this dashboard is to showcase our procurement spend data, broken down by different categories. - Manual Data Update: The dashboard should be updated by uploading files manually. Ideal Skills and Experience: - Prior Experience: I'm looking for someone who has previously built data dashboards, preferably ones that deal with procurement or financial data. - Data Visualization: Understanding of how to best present data in a simple, yet informative manner. - Tableau or Similar Tool Proficiency: Experience with tools such as Tableau tha...

Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirements: Image links should open the respective product images...

Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm

...present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (provided for you attached excel document) - your statistical analyses on other separate tabs a Word doc or PDF with... - insights and f...

I need an experienced freelancer to assist me in typing data from handwritten notes into an Excel sheet. Key Requirements: - Previous Experience: Please include details of your previous work in this area - Handwriting Deciphering: Due to the nature of the data being handwritten, you'll need to have good skills in deciphering handwriting - Accuracy: It's crucial that the information is entered into the Excel sheet with the highest level of accuracy Looking forward to your application.

I have a number of scanned documents that contain financial figures. I need someone to accurately type these into an Excel sheet for further analysis. Key Requirements: - Experience with data typing and analysis in Excel, particularly financial data. - Attention to detail is paramount; precision in typing is crucial for the accuracy of the analysis. - Proficiency in English is a must, as the data will be in English and will need to be accurately transcribed. The ideal candidate should have prior experience in financial data entry and analysis, and comfortable working with scanned documents. Your work will be the foundation for subsequent data analysis, so precision and attention to detail is key.

...you just have to add some PHP/MySQL code to make the pages work with the database. You also need to create the DB, table and records. Though most have been created already. You would need to double check them though. I also need the web services to connect the DB to our mobile app. Technical details: Admin Panel ----------------------------- Common Pages --------------- 1) Login/Logout 2) Dashboard (4 Boxes total count) + I might add a few. Listing Fields admin -------------- 1) Gender (Edit/add) 2) Brands (Edit/add) 3) Clothing sizes (Edit/add) 4) Shoe sizes (Edit/add) 5) Colors (Edit/add) 6) Conditions (Edit) 7) Mom sizes (Edit/add) Members & Products -------------- 1) list all members 2) View single member (function to make in-active) - This page has many vie...

I am seeking an teacher well versed in Excel 2021 to create a comprehensive intermediate-level course. This course will total between 12-15 hours and will be delivered through both video lectures and interactive exercises and quizzes. Here's an overview of the specific topics the course must cover. • Formulas and Functions • Data Analysis and Visualization • Pivot Tables and Charts • Advanced Functions • Named Ranges • Tables • Charts and Slicers The ideal freelancer for this project will possess strong instructional skills, extensive experience with Excel 2021, and a knack for making complex concepts easy to grasp.

I need assistance with a small-scale copy and paste data entry task. The data is less than 1,000 rows and is in a spreadsheet format. Ideal Skills and Experience: - Proficiency in spreadsheet software such as Excel or Google Sheets - Attention to detail to ensure accurate data entry - Efficiency in copy and paste tasks to complete the job promptly This is Medium Task for 1 day Max and will be Fixed Price of 800RS. We have to Refer the Raw File and Practice test for the Students and will it in the correct format in the Practice Bulk upload

...Once login credentials are checked they move onto the admin dashboard Admin will have a navigation at the top listing showing log out Admin users will have the ability to add users to the system, info that they can add should be Patient number Patient first name Patient last name Parents first name Parents last name Assigned Doctor Notes from doctor Date of birth Parents contact number Parent email Next appointment date Medication needed Patient / kid user Should arrive at the login page Once logged in should have a dashboard page listing Navigation should allow them to enter a games page, info page listed at the top A welcome card welcoming the firstname + lastname on the dashboard page Info page should list the deta...

I have a project where I need you to work with numbers in an Excel sheet. Ideal Expertise: - Proficiency in data entry - Strong knowledge of Excel - Attention to detail - Ability to maintain accuracy and consistency in data entry - Proven experience in similar projects - Able to meet deadlines Please let me know if this is something you can assist with.

Desenvolvi uma planilha de excel mas estou a necessitar de ajuda para criar duas novas formulas.