Data excel sheet phpJobb

Job Description: Excel Advanced Formula Specialist Job Overview: We are seeking an Excel Advanced Formula Specialist to join our team. The ideal candidate will have expertise in advanced Excel formulas, functions, data analysis, automation, and reporting. This role involves developing complex formulas, optimizing spreadsheets, and ensuring efficient data handling for business decision-making. Key Responsibilities: Develop and implement advanced Excel formulas (e.g., INDEX-MATCH, VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, IFERROR, INDIRECT, OFFSET, ARRAYFORMULA). Create and manage pivot tables, charts, and dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, structu...

I'm seeking help with automating my Excel spreadsheet. I've done considerable work already and have an instruction document to guide us. - Task: Spreadsheet automation - Software: Microsoft Excel - Assistance: Determining the type of automation needed (potentially macro creation, formulas and functions, or data import/export) Your expertise in Excel and experience with spreadsheet automation will be crucial. I'm open to a call if further clarification is needed. Please provide a time estimate and cost for this task in your proposal.

I need help with managing and analyzing Excel spreadsheets. The tasks will primarily involve data entry, analysis, and possibly creating charts or graphs to visually represent the data. Ideal skills and experience: - Proficient in Microsoft Excel - Experience with data analysis and visualization - Attention to detail - Good organizational skills

I'm looking for an Excel expert who can design a custom spreadsheet and dashboard template for tracking the completed yearly contract requirements of approximately 1,200 healthcare providers. Currently, we track completion of quarterly training completions, submission of required quality reporting documents, and important contact information which is updated and confirmed quarterly. Key Requirements: - The spreadsheet will be used internally to monitor the completion of specific trainings and the submission of quarterly documents. - It must also track current contact information (email, phone, point of contact, etc.) for each provider. - The dashboard will need to be user-friendly for both internal team and external stakeholders. - Include data visualization features s...

...analytics dashboard that processes revenue and expense data for mobile applications. Project Overview: - Dashboard processes CSV revenue files and Excel expense files - Combines data to gen erate comprehensive reports - Uses React.js with Material UI for frontend - Handles multiple file formats and data transformations Technical Requirements: 1. Strong experience with:   - React.js   - Material UI (MUI)   - Excel/CSV file processing (, Papa Parse)   - JavaScript/ES6+   - Git version control 2. Must be able to:   - Understand existing codebase   - Debug data processing issues   - Add new features   - Optimize performance   - Handle file validati...

I'm looking for an Excel expert who can design a custom spreadsheet and dashboard template for tracking the completed yearly contract requirements of approximately 1,200 healthcare providers. Currently, we track completion of quarterly training completions, submission of required quality reporting documents, and important contact information which is updated and confirmed quarterly. Key Requirements: - The spreadsheet will be used internally to monitor the completion of specific trainings and the submission of quarterly documents. - It must also track current contact information (email, phone, point of contact, etc.) for each provider. - The dashboard will need to be user-friendly for both internal team and external stakeholders. - Include data visualization features s...

...Dashboard) Description: I need a custom web-based tool that integrates with the Facebook Ads Library API and TikTok Ads Library API to collect ad data and display it on a dashboard. The tool should allow me to apply filters such as: • Keyword/Term Search • Landing Page URL • Date Range • Ad Type (Image, Video, Carousel, etc.) • Language • Country Key Features: 1. API Integration: Fetch real-time ad data from Facebook & TikTok Ads Libraries. 2. Dashboard UI: A clean, user-friendly interface to view and filter data. 3. Filtering System: Apply advanced filters to find specific ads. 4. Data Export: Ability to download filtered data in CSV/Excel. 5. Ad Preview: Show ad creatives, captions, and engagement...

Wir sind eine gemeinnützige Organisation. Wir bieten Sprachklassen für geflüchtete Frauen an mit paralleler Kinderbetreuung. Für die Verwaltung unserer Klassen und unserer Finanzen arbeiten wir mit Excel. Wir suchen jemanden, der uns bei dieser Arbeit (vornehmlich Excel und Google Sheets) unterstützen kann. Bitte nur Bewerber aus Deutschland

...seeking a web scraping expert to extract data from the Accredia database and organize the results in an Excel file. Key tasks: - Scrape data on all Italian companies certified UNI/PdR 125:2022, categorized by region. - For each company, extract the following information: - Company name - VAT number - Region - Address - Number of employees, divided by gender if available - Certification date - Certifying body - The data needs to be sourced from: - The final Excel (XLSX) file should have a separate sheet for each region, with companies organized by number of employees. Requirements: - Proficiency in using Selenium for web scraping. - Ability to ensure data accuracy and quality through cross-referencing

I am a college professor seeking assistance in verifying the completion of 17 Python coding assignm...seeking assistance in verifying the completion of 17 Python coding assignments submitted by my students. Each assignment contains 6 problems and is housed in Python/Jupyter notebooks. Your task will be to check that each student has completed each problem. Requirements: - Indicate the file name and the corresponding completion status (6 problems per assignment) on a separate sheet in an Excel spreadsheet. - The Excel report should indicate whether each assignment has been completed or not. - No specific comments are required, just a confirmation of completion. - The results can be organized in any order. Ideal Skills: - Familiarity with Python and Jupyter Notebooks i...

I'm seeking a skilled data analyst with experience in MySQL and Power BI to create a tailored report for me. The report needs to pull data from a local MySQL database and present it in Power BI or alternative tool.. Key Requirements: - Extract bespoke data from a local MySQL database. - Create a report with this data. Report could be in Power BI, excel or other I am open to suggestions. - Include summary statistics in the report. Ideal Skills: - Strong proficiency in MySQL. - Extensive experience with Power BI. - Excellent data analysis skills. - Ability to understand and work with bespoke data. I have attached a mock up of roughly how I would like the report to look. The database is a horseracing database. The way it would work is ...

I have onedrive business and i want to make able to login with email to sheet It show error that it is not enabled external sharing I want to fix the issue

I need a skilled After Effects professional to duplicate a template for me. The source template...which can easily be replicated. Key Requirements: - Duplication of a general video template in Adobe After Effects - Addition of "comps" to facilitate bulk video downloads based on an Excel sheet Data Specifications: - The Excel sheet contains both text and images - Text from the Excel sheet needs to be incorporated into the videos as text overlays and in the intro/outro text blocks Ideal Skills and Experience: - Proficiency in Adobe After Effects - Experience with video template duplication - Familiarity with creating "comps" for bulk video production - Ability to integrate both text and images from an Excel she...

Excel Healthcare Ltd are looking for a third party company to help us create our Amazon store. If you are a company that has experience in this field, please get in contact with us today.

I'm seeking an Excel expert to assist with transferring data from Excel to MS Project template

I'm seeking a talented Laravel PHP developer to assist in the development of my application. The specifics of the application have not yet been determined, so a flexible and versatile developer is preferred. Ideal Skills: - Proficient in Laravel and PHP - Experience in developing custom applications - Ability to work with unstructured requirements Experience with third-party services is not a necessity, but is a plus. Key Responsibilities: - Collaborate on the design and development of a custom application - Provide expert insight on the capabilities of Laravel and PHP - Adapt to changing requirements and contribute to the application vision

...mayoría) con 3 o 4 opciones de respuesta. Posibilidad de modificar el número de preguntas y el tiempo disponible. Sección de retroalimentación al final con respuestas correctas, consejos y análisis del desempeño. Fórmula de puntuación configurable (para definir cómo se valoran aciertos, errores, etc.). ✅ Gestión de Contenido Base de datos de preguntas cargada desde un archivo Excel estructurado, con información como: ID, pregunta, tema, subepígrafe, normativa asociada. Opciones de respuesta y respuesta correcta. Tipo de pregunta (fácil, media, difícil). Si la pregunta es oficial o no. Retroalimentación detallada. ✅ Pla...

I need a Google Sheet set up for my business to help with financial tracking and inventory management. - Financial Tracking: The sheet should help me keep track of expenses, income, and budgeting. - Inventory Management: I need to update stock levels in real-time, so I can keep track of what I have on hand. - Generate monthly financial reports automatically. - Add sections to track different income sources. - Include predefined categories for common expenses. - Create a balance sheet to summarize assets, liabilities, and equity. - Include a cash flow projection to predict future financial health. - Summarize financials in a yearly overview sheet. - Add alerts for upcoming due payments or invoice deadlines. - Section to track any loans, debts, and repayment sch...

...deadlines. So my budget is $5/video (5-20min long), $5/5 short 2-3 min videos,, we will need more than 500 such a video work, so I hope you can be working for a long-term with us. Budget is not negotiable, until we get enough customers to our website and/or monetized our YouTube channel by that mean I will need at least 1M subs and/or 1M views in each of the video ---- Please check in this google sheet, if you have no past work review, please send me draft version of unmade video edited video according to the step in tab 'Standard Guideline', if you can do it accordingly, then I will send award to you for the rest of the other videos : ;

I have attached an Excel spreadsheet. There are 5 tabs. The first tab (called "Config & Matrix") needs to calculate predicted construction completion dates for plot/construction stage combinations (the current predicted construction dates (highlighted in yellow) just contain basic formulas). The formulas that you create will need to take into account the data on the "Project Setup+Management", "Contract Manager Portal" and "Site User Portal" tabs. The "Resource Data! tab can be ignored. If you look at each tab, you will see I have included cell descriptions and example entries. I have also attached a diagram to help you understand how the "Config & matrix" tab needs to calculate both the plot/stage dates...

Necesito poner la información que hay en un sitio web e incorporarla a un excel. El trabajo es sacar la información de tiendas y ponerla en un excel. Hay un total de 750 tiendas que hay que recopilar la información. El sitio donde hay que coger la información es el siguiente:

I'm looking for a skilled Python developer who can create a script for me, which I can run on my local machine. The main aim of this script is to automate the process of generating Excel reports. Key Tasks: - The script should automate the generation of reports, saving me the time and effort of doing this manually. Ideal Skills: - Proficiency in Python is a must. - Prior experience in creating automation scripts would be highly beneficial. - Familiarity with Excel and its Python libraries (like pandas or openpyxl) is preferred. I would like to work with someone who can deliver a robust and efficient script that meets these requirements.

Automated Expense Tracking Dashboard This Google Sheets-based "501 Expense Report" is an automated financial tracking system designed for seamless expense management and collaboration. The sheet integrates Google Forms for effortless data entry, ensuring real-time updates and accuracy in expense tracking. Key Features: ✅ Google Forms Integration ? The sheet is linked to Google Forms, allowing users to submit expenses directly from a form. Each submission is automatically recorded and categorized in the sheet. Reduces manual data entry, improving efficiency and accuracy. ✅ Automated Data Processing & Visualization ? Real-time updates: New expense entries reflect instantly on the dashboard. Dynamic dropdown (Month Selection) enables ...

I'm seeking an experienced UiPath developer to help me automate complex data entry tasks. The automation will primarily involve: We will be having more than 100 Invoice formats. The system should automatically read these formats and write into excel csv file. Ideally, the freelancer should have extensive experience with UiPath, a deep understanding of data manipulation processes, and a proven track record of automating tasks across web-based applications and database systems. Proficiency in these areas will be crucial for the successful completion of this project. The estimated volume of data for automation is medium. The system should support template-based extraction for data extraction. The automation should run hourly. The system should log ...

Made the upgrade in Westia server the PHP and CRM

Upgrade Crm and PHP

Es un cuestionario médico en español que hay que responder unas 14 preguntas SI/NO y en base a respuestas y breve algoritmo, dar respuestas de texto que ya se las pasaría. El algoritmo lo tengo en excel. Lleva texto adicional sobre instrucciones, definición, aclaraciones, etc. No es complejo. Me interesa el frontend y paso un enlace de Medcalc, el cual es similar a lo que quiero ( ) y una foto de ejemplo. Paso un borrador en excel, al cual le falta texto…, y paso el algoritmo en pdf. Entiendo que el backend sería fácil para Uds. y el frontend ya me diran, y me gustaría ver un demo. IMPORTANTE: el objetivo es añadir este cuestionario a mi página web ( ) en alguna sección. Es en Wordpress y me...

I'm seeking a skilled professional to implement a design using an existing HTML template. The job involves connecting some pure PHP APIs. Ideal Skills and Experience: - Expertise in PHP, MySQL, and HTML - Experience in implementing designs using HTML templates - Proficient with connecting PHP APIs - Good communications and able to FOLLOW INSTRUCTIONS in a sequence. This is the template that will be implemented following a design I will provide.

Opis po polsku: (poniżej English): Czy da się stworzyć aplikację i w jakiej cenie która będzie automatycznie przeglądać określoną stronę www (lista/baza stron mogę znajdować sie w jakiejś bazie), następnie odnajdzie na tej stronie formularz i wypełni go oraz wyśle wg określonej treści? Schemat działania byłby taki: 1. Pobierz adres www z bazy, list np. csv lub google sheet 2. Wejdź na dany adres 3. Przeszukaj stronę 4. Znajdź formularz kontaktowy 5. Wypełnij formularz, wyślij wiadomość (dobrze będzie poradzi sobie jeżeli są zabezpieczenia na stronie np. recaptcha) 6. Jeżeli nie da się wysłać formularza zwróć informacje do bazy np. oznacz adres mailowy jakimś znakiem. Jeżeli byłaby to baza w google sheets to można oznaczyć statusami (do wysłania, wysłane, brak możliwoś...

I need an online software automate to convert data in some documents. the project is divided in 2 phases. first has to be ready the first phase and then the 2nd phase. Phase 1: Document Generation Extracted data is required to generate: • Share Certificate- Contains 9 fields from the extracted data. • Share Ledger- Contains 12 fields of which 9 fields are in the same as the Share Certificate. • Data extraction from agreements • Excel formatting or a structured table. • Automatic document generation (Share Certificate & Share Ledger in PDF) • Automatic Document Filing • Automatic emailing of Specific Documents Two level logins A. Mester login B. User login • Upload folders of the documents &bul...

I need a method or script to send bulk SMS messages from a phone number located in another country. The phone can be accessed through Google Messages for Web. The phone numbers list where we have to send the message are listed in an Excel sheet. The ideal solution should be easy to use and not overly complicated. Key Requirements: - A simple method or script to send SMS in bulk. - The solution should not be overly complex or difficult to use.

...Description: We are looking for a talented and motivated MERN Stack Developer who has a strong foundation in PHP and DevOps practices. This role requires someone with a full-stack development background, capable of building dynamic and high-performance web applications. The ideal candidate will have experience working with the MERN stack (MongoDB, , React, Node.js) along with PHP-based frameworks, and also a deep understanding of DevOps processes for smooth deployment and scalability. Key Responsibilities: - Design, develop, and maintain web applications using the MERN stack (MongoDB, , React.js, Node.js). - Build and maintain back-end services using PHP and popular PHP frameworks like Laravel or Symfony. - Develop efficient and reusable front-end compone...

I'm looking for a skilled professional who can automate the trend analysis of stock data in Excel, using Python or other suitable tools. Key Tasks: - Automate data analysis in Excel - Sheet1 data automate copy sheet 2 every minute -Sheet 1 data copy every minute to sheet 2(column F of sheet1) and sheet 4 (column O of sheet 4) as per upload sheet

System Overview The System is a comprehensive data collection and analytics platform built around EasyForms, enabling seamless data entry, integration, and visualization. It consists of three main components: MOBILE APP (Flutter) – A mobile app for field data collection, supporting offline mode, GPS tracking, QR code scanning, and file uploads. Users can register farms, fill forms, and sync data with the system when online. CONNECTOR (Laravel) – A middleware that integrates various data sources into EasyForms. It supports: API uploads to connect external websites. Live database connections for seamless data transfer. File uploads (CSV, Excel, SQL, WHONET/FTP) with field mapping. Dashboard for monitoring connection status and...

I'm in need of a dedicated intermediate-level PHP developer to help with my personal website, RCS. The project involves fixing bugs and enhancing website functionalities. Key Responsibilities: - Troubleshoot and fix both minor and major bugs, encompassing design and code-related issues. - Complete outstanding functionalities such as generating and processing letters within the website. Ideal Candidate: - Must possess intermediate PHP development and debugging skills. - Strong problem-solving skills and meticulous attention to detail. - Only individual freelancers will be considered; companies and agencies need not apply. - Preference will be given to full-time freelancers who can provide the best value within my limited budget. If you're interested and meet the ...

...deadlines. So my budget is $5/video (5-20min long), $5/5 short 2-3 min videos,, we will need more than 500 such a video work, so I hope you can be working for a long-term with us. Budget is not negotiable, until we get enough customers to our website and/or monetized our YouTube channel by that mean I will need at least 1M subs and/or 1M views in each of the video ---- Please check in this google sheet, if you have no past work review, please send me draft version of unmade video edited video according to the step in tab 'Standard Guideline', if you can do it accordingly, then I will send award to you for the rest of the other videos : ;

I'm looking for an Excel expert to help me set up a task tracking sheet in Excel 2010. The sheet will be used to track team assignments and should include color coding based on team members. Ideal candidates will have: - Proficiency in Excel 2010 - Experience with creating task tracking systems - Ability to work with Arabic language settings - Creativity in color coding systems The final product should be a functional and visually clear task tracker.

...Google Sheet set up with drop down lists that are based on a Xero template. The sheet needs drop down boxes that automatically select other information for other columns that usually stays the same. Requirements: - Use of existing data from Xero that includes products and prices. - Creation of drop-down lists that include product details, service details and expense categories. - Auto-filling of columns based on drop-down selections, specifically pricing details and product descriptions. - No need for calculations or formulas to be triggered by drop-down selections, only static data. Ideal Skills and Experience: - Proficient in Google Sheets and familiar with Xero. - Experience in creating automated spreadsheets with drop down lists and static data. ...

I have an Excel file containing 248 medical records. I need a freelancer to compute and add three new columns: BMI, BMI Category, and bp_category (blood pressure). Your Responsibilities: - Use the existing weight and height data to calculate BMI. - Research and apply the standard BMI categories. - Utilize the systolic and diastolic blood pressure data to create the bp_category. - Ensure the output file is in Excel (.xlsx) format. Ideal Skills and Experience: - Proficiency in Excel. - Understanding of health metrics and categories. - Experience with data analysis. - Ability to deliver high-quality work promptly. I am looking for a quick turnaround on this task. The successful completion of this project could lead to further opportunities.

Need a create dashboard for KPI MM

De un archivo pdf de buena calidad con 10 - 14 hojas que este en una carpeta llamada pdf y se tiene que extraer solo las tablas y pasarlas a otra carpeta llamada procesadas a un archivo Excel con el nombre de la primera hoja 1.- Scripts en Python pdf a excel 2.- pdf en la carpeta llamada pdf 3.- extraer las tablas y hacer un archivo Excel con nombre de la primera hoja del pdf en la carpeta procesadas Si requieres el archivo para poder ver mejor el detalle mándame un mensaje. Puede ser otro lenguaje de programación y también Google sheets

I need a Python script that can transform data from one Excel sheet with multiple rows into another Excel sheet. The output should create one individual sheet per row. There is a certain format in the output excel sheet. Key requirements: - The ideal candidate should have extensive experience with Python and Excel. - Knowledge of data manipulation and organization is crucial. - able to work immediately with tight deadline

I'm looking for a skilled professional to design a Gable roof for my residential home. The selected material for the roof is metal sheets, so experience with this material is a plus. Key Requirements: - Expertise in designing Gable roofs - Experience with metal sheet roofing - Ability to design for residential scale - Understanding of structural integrity and aesthetics Please provide examples of similar projects you've completed in the past.

I need a scenario that will trigger when a new file is added to my FTP ser...information from a CSV spreadsheet, relay it to a ChatGPT assistant, and then take the assistant's output to create a new Google Sheet or Doc. Key Requirements: - The CSV file contains all the information that needs to be processed. - The scenario must be able to relay all data from the spreadsheet to ChatGPT. - The output from ChatGPT should be organized into a new Google Sheet or Doc each time. Ideal Skills: - Proficient experience with - Familiarity with webhooks option - Knowledge of parsing CSV files - Experience with Google Sheets and Docs - Understanding of how to interface with ChatGPT assistant via make Timeframe: 24 hours. The new Google Sheet or Doc can use a stan...

...com/file/d/1A6BnYNNk-pR9HeawJBsy3pfRXI84j3-v/view?usp=sharing 4 Then you must put some sort of introduction clips to hook the user, check the note F below. Ex: 5 """Find the most suitable vibe trending copy righted free music in youtube/google, if you still can not, then copy paste the transcript from the Google Sheet, then ask chatgpt as follow ""According to the video transcript below, what is the best fit trending free copy righted music in capcut ?"", then paste the transcript below it." 6 For short videos, you must insert the thumbnail in the video for at least 1s somewhere you think most suitable --------- Budget is $5 for 5 short videos with length 2mins videos and $5 for 1 long videos with length

I need a freelancer to create 5 reports in an MS Access Database as per pdf and implement a data entry option as per excel. database, pdf and excel sheets are attached

I am seeking a data expert with strong experience in exploratory data analysis (EDA) and predictive modelling. The primary goal of this project is to identify key patterns in my data. Ideal Skills: - Expertise in EDA and predictive modelling - Proficiency with data analysis software (e.g., Python, R, Excel) - Strong statistical background - Excellent problem-solving skills - Ability to interpret complex data sets Please note that some details about the data types and visualization methods have not been determined yet. Flexibility and adaptability will be key in this project.

I have a corporate profile document for an incubator center that needs to be filled out. The document is in both Arabic and English. The task involves: - Filling out sections related to financial projections, balance sheet, and marketing plan - Completing both the English and Arabic versions, although assistance with just the English version is acceptable if you can do it professionally. - Using a provided template to ensure consistency and professionalism. Please note: - The document requires in-depth financial information, so expertise in finance is essential. - Experience in completing similar corporate documents is a must; bids from freelancers without this background will not be considered. - Understanding of both the Arabic and English versions of the document will be advan...

...EXPERT EXCEL EXPERT Please do not bid if you're not a genuine expert that can import thousands of products every week. Tasks and Responsibilities: - Be super organized. We will be sending you documents: please sort them in a way that will make it easy for you to revert to these documents whenever needed. We use Office 365 / OneDrive to organize our documents. - You will be importing using excel or CSV or, if you're a true expert: you may even use XML. You will need to maintain these files. If we find out that an attribute was not defined, we want to make sure it will be easy for you to add the attribute and reimport the products adequately. Note: in some cases, product assets/attributes are contained in 3 files: PIES - ACES - Digital asset. You may n...