Excel web query logging일자리
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
I'm seeking an expert to convert my current web app into a locally hosted Angular app. This project also involves creating custom-built connectors for orchestration software that links the local app to AWS. Key Requirements: - Development of a local version of the web app with full data synchronization capabilities with AWS. - Implementing automated backups and error logging features in the orchestration software. - Creating custom-built connectors for AWS interaction. Ideal Skills: - Proven experience with Angular and web app development. - Strong background in AWS and creating custom connectors. - Proficient in implementing data synchronization, automated backups, and error logging. - Knowledge in user authentication, data visualization, and fil...
...Microsoft documents (Word, PowerPoint, Excel) and export them correctly to accessible PDFs. Use Adobe Acrobat and accessibility tools to add tags, alt text, and fix reading order. Conduct accessibility checks and resolve issues flagged by tools like Adobe Accessibility Checker and Microsoft Accessibility Checker. Key Requirements: Proficiency in Adobe InDesign, Acrobat Pro, and Microsoft Office tools. Strong knowledge of WCAG 2.1 standards and document accessibility principles. Familiarity with assistive technologies such as screen readers (e.g., JAWS, NVDA). Proven experience in document accessibility remediation. Detail-oriented with the ability to deliver compliant, user-friendly documents. Bonus Skills: Experience with HTML accessibility for web-related projects. Kno...
...consolidate it into a data source - preferably Microsoft Azure - for real-time PowerBI dashboards and reports. There are about 9 fields from Autotask, 3 from Quickbooks Online, and 4 fields from Excel which I need to have all in one place for analysis. Key Responsibilities: - Consolidate data from diverse sources, including Excel files, Google Sheets, Autotask, and Quickbooks Online. - Focus on Financial and Sales data primarily. - Ensure the data is clean, well-structured, and ready for analysis. Ideal Skills: - Proven experience with data consolidation from multiple sources. - Strong proficiency in Excel and working with Google Sheets. - Familiarity with Autotask and Quickbooks Online is a plus. - Expertise in preparing data for analysis in Power BI. I have f...
I'm in need of a Python backend developer, preferably a fresher, w...Django framework. Key Responsibilities: - API Development: Building, testing, and maintaining APIs to support various applications and services. - Database Management: Overseeing the interaction with our SQL databases, ensuring data integrity and optimizing performance. Ideal Skills: - Proficiency in Python, particularly in a backend context. - Familiarity with SQL databases, including basic query writing and database design. - Prior experience or knowledge of the Django framework. - Understanding of API structures and principles. This is a great opportunity for a fresher looking to kickstart their career in backend development. If you have a passion for coding and a keen interest in Python, I would love to...
...remote job. MS-SQL database expertise is required. The office hours are from 9 A.M. to 6 P.M., and lunch is complimentary. The project involves: - Implementing new features. - Bug fixing. - Performance optimization. The new features to be added include: - Customizable reports. The level of customization for the reports includes: - User-defined filters - Customizable layouts - Export options (PDF, Excel) Ideal candidates should have: - Extensive experience in raw PHP - Proven track record in developing reporting panels - Ability to work under pressure and meet deadlines - Excellent problem-solving skills for bug fixing and performance optimization - Experience in implementing new features in a timely manner - Skills in developing customizable reports - Familiarity with creatin...
...Handle video page loading failures with refresh capability Log videos without CC to Implement robust error handling for large-scale processing Design for resilience against YouTube UI updates Project Parameters: Budget: $50 Timeline: 1-2 days Deliverable: Fully functional Python application Required Skills: Python programming Experience with web scraping Knowledge of YouTube API or similar video platform integration Error handling and logging implementation Data extraction and file management Desired Programming Language: Python C# (preferred) Or whatever is best for this type of work * Do not bid if you have under 3 reviews, you will be ignored * Need Source Code when Job is Complete, After any Bug fixes, and Updates * Milestone release upon completion of project &...
I'm looking for a skilled SQL developer to create a query for data retrieval from my MySQL database. Ideal candidates for this project should: - Have extensive experience working with MySQL databases - Possess a strong understanding of SQL syntax and functions - Be capable of writing efficient and effective data retrieval queries.
I need an Excel report that handles financial data, including expense tracking, revenue generation, and profit and loss analysis. The report needs to have interactive features such as pivot tables and interactive charts. Ideal Skills: - Proficiency in Excel, particularly with pivot tables and creating interactive charts - Experience working with financial data - Ability to create comprehensive and easy-to-understand Excel reports
I'm looking for someone to complete an excel spreadsheet with financial data sourced from various company websites. This project will primarily involve researching and collecting data related to property purchase prices, monthly rent amounts, lease start dates, and lease lengths. Ideal candidates for this project should: - Have experience with data collection and Excel - Be detail-oriented and able to work independently - Have a basic understanding of financial metrics and real estate - Be able to source reliable data from company websites Please provide examples of similar projects you have done in the past.
Requirement for Formatting Output Using Microsoft Copilot in Word or Excel We are using Microsoft Copilot in Word and Excel, where we provide a document with a specific format as input. When we give prompts, such as "Create a new website" or "Suggest a laptop for purchase," Copilot generates content correctly based on the prompt. However, the output does not retain the same format as the input document. Our requirement is that the output should match the exact format of the input document, including colors, fonts, bold, italic, and other formatting. Currently, we must make additional adjustments to achieve the desired format, which is time-consuming. We discussed this with Microsoft, and they suggested that we could add agents to address this issue. We ...
...and Documentation: 1. Refactor code for maintainability and scalability 2. Implement comprehensive error logging and monitoring 3. Provide detailed documentation for all new and existing features 4. Document deployment process and any necessary Google Cloud Run configurations 7. Database Optimization: 1. Review and optimize MongoDB Atlas queries and indexes 2. Implement efficient data models for game-specific requirements 3. Set up proper backup and recovery procedures Required Skills: - Strong experience with React, Express, and Vite - Proficiency in Telegram Bot API integration - Experience with TON blockchain and cryptocurrency transactions - Knowledge of best practices in web security and performance optimization - Familiarity with admin panel development an...
I'm looking for an experienced data analyst or Excel specialist to create a dynamic spreadsheet for me. I have sales data from 5 stores, and I want a spreadsheet that I can upload weekly sales into. This spreadsheet should calculate: - Weekly and monthly running totals for items sold per store - Total sales across all 5 locations The data points I have include: 1. Date of sale 2. Item 3. Transaction number 4. Price sold at 5. Store # If a customer buys 3 of the same item, it will give me 3 separate lines of data (i.e., all sales listed are quantity of 1). I will be uploading my data weekly through a CSV file into Microsoft Excel. The spreadsheet needs to be able to generate the following reports: - Weekly total sales - Monthly total sales - Item-wise sales per store...
I need assistance with finding product codes (SKU and size in either US or EUR and link for a proof) for 4100 EANs. The data should be sourced from Google or 1 another website , VERY easy because 2 /3 brand only Key Requirements: - Data processing and research skills - Experience with Excel/CSV - Ability to follow a specific format for data input I will provide the EANs in a spreadsheet (Excel/CSV) and I already have a format for the SKU and size. This is a straightforward project that requires basic data input and online research. Please be prepared to work meticulously and efficiently.
I'm looking for a research assistant who can help me collect and analyze both quantitative and qualitative data fo...research assistant who can help me collect and analyze both quantitative and qualitative data for an academic project. Key Responsibilities: - Data Collection: Gather both quantitative and qualitative data relevant to the research. - Data Formatting: Organize and prepare the collected data in Excel/CSV files and Word documents. - Data Analysis: Analyze the data to extract meaningful insights. Ideal Skills: - Proficient in data collection and analysis - Experienced in academic research - Skilled in using Excel and Word - Capable of working with both quantitative and qualitative data. Please, only apply if you're experienced in academic research da...
Key features of your custom CRM 1. User management: • Role-based access for administrators, team members and other user groups. • Secure login and tracking of user activity. 2. Leads and Opportunities Tracking: • Centralized dashb...to assign tasks and leads to team members. 3. Workflow Automation: • Automate repetitive tasks like follow-ups, reminders, and approvals. 4. Communication: • Integration with email, messaging or telephony systems for seamless communication. • Notification system for important updates. 5. Reporting and Analysis: • Customizable dashboards to track key metrics. • Exportable reports (PDF, Excel) for performance reviews. Depict corporate structure: Main business can have multiple subsidiaries, and eac...
...g., inventory_data, sales_data, item_details). -Ensure the datasets are organized and optimized for analytics. Python Automation: Develop Python scripts to: - Extract data from the SQL database. - Load data into BigQuery, ensuring incremental updates and handling duplicates. - Schedule the scripts to run multiple times a day using a task scheduler (e.g., cron or similar). Error Handling and Logging: - Add error-handling mechanisms in the scripts to handle failed transfers and log success/error details for every execution. Documentation and Guidance: - Provide clear instructions for running and maintaining the scripts. - Minimal guidance to help me perform small tasks like testing queries or troubleshooting basic issues in BigQuery if needed. Requirements: - Strong experience ...
I'm looking for a skilled Visual Basic programmer who can help me develop an Excel macro. This macro needs to automate data entry tasks in a spreadsheet. Key Responsibilities: - Develop an Excel macro using Visual Basic. - The macro should be capable of automating repetitive data entry tasks. - Ensure the macro is user-friendly and efficient. Ideal Skills: - Proficiency in Visual Basic, particularly in creating Excel macros. - Experience with data entry automation. - Excellent problem-solving skills and attention to detail.
I'm looking for a professional to compile an extensive list of exhibitors from the Fitur trade show. This list will need to be more than 200 exhibitors and should include: - Company name and contact details - Product or service offerings - Booth number and location The final data should be delivered in a Spreadsheet (Excel/CSV) format. Ideal skills for this job include: - Attention to detail: It's crucial that the information recorded is accurate. - Proficiency in Excel: The final product should be well organized and easy to understand. - Research skills: You may need to look beyond the official exhibitor list to get a comprehensive view. Experience in data compilation and familiarity with trade shows will be an added advantage.
I'm in need of a freelancer who can compile a list of exhibitors from Fitur 2025. This list should be formatted in Excel and include: - Company Name - Exhibitor's Country - Email - Phone Number Please note that this list should be sourced from other trusted sources, not the event's official website or a public directory.
as discussed in the chat section
1. Project Overview: SkyGuide is a web app designed to assist flight attendants and pilots by providing easy access to their union contracts. Users input questions and receive AI-generated responses based on their specific contract details. The app is near completion and will be prepared for alpha testing and promotion by March 1st, 2025. 2. Objectives: Fix existing errors and issues in the app. Implement the ability for the app to correctly call the appropriate OpenAI assistant based on the user's airline and workgroup. Ensure seamless user signup, subscription handling, and integration between Stripe and Supabase. Finalize all features and functionality to prepare for alpha testing. 3. Target Audience: Flight attendants and pilots from various airlines. Users interes...
I need a dashboard that visualizes and organizes the errors found in the List 1 and List 2 tabs of my Excel file. The goal is to track missing or blank cells within the data. The dashboard should include charts and graphs to clearly display the error data. Additionally, it should feature a mini database section with filters, showcasing the missing data headers and cell references for quick identification and navigation.
I'm looking for an expert in Tableau, specifically for creating interactive dashboards. The data will primarily come from Excel/CSV files, so proficiency with these sources is essential. Ideal Skills: - Extensive experience with Tableau - Proficient in working with Excel/CSV files - Ability to design interactive charts and graphs The dashboard should feature interactive charts and graphs. I'm not looking for a static, one-dimensional dashboard; I need something that can engage users and allow them to explore the data on their own. If you have a proven track record of creating such dashboards and can deliver a high-quality, user-friendly product, I would love to hear from you. My cost is 10USD
...Details: Error Message: PHP Notice – yiibaseErrorException: Undefined variable: where Code Snippet:: PHP $connection = Yii::$app->getDb(); $command = $connection->createCommand("SELECT id FROM product $where"); $result = $command->queryAll(); Potential Causes: Missing Variable Definition: The $where variable might not be properly defined or assigned a value before it's used in the SQL query. Configuration Issue: The migration from cPanel to DirectAdmin might have caused configuration changes that affect how variables are handled within the application. Technical Skills Required: Proficiency in PHP 7 development Experience with the framework Understanding of database queries and variable scoping in PHP Project Deliverables: A fully func...
We are seeking a skilled freelancer to help transfer and configure macros from one computer to another. The macros are fully operational on the original machine, and we need assistance ensuring they work seamlessly on the new setup. Ideal skills and experience for the job include: - Proficiency in Excel, specifically with macro creation and implementation. - Experience with data manipulation, report generation and task automation. - Ability to troubleshoot and optimize existing macros for efficiency.
I need assistance converting text and numbers from an unstructured PDF into an MS Excel spreadsheet. Key Requirements: - Convert text and numbers from PDF to Excel - Data is unstructured, so adaptability is key - High level of accuracy required, with manual verification Ideal Skills and Experience: - Data entry experience - Proficient in MS Excel - Detail-oriented - Able to manually verify data for high accuracy
I'm seeking a skilled data entry professional with experience in data clean...The job will primarily involve cleaning mixed data (text and numbers) sourced from our database. Key Responsibilities: - Identify and rectify inconsistencies within the data - Ensure data integrity and accuracy - Prepare cleaned data for further analysis Ideal Skills: - Proficiency in data cleaning techniques - Experience working with mixed data types - Familiarity with database navigation and Excel/CSV files - Attention to detail and strong problem-solving skills Experience Requirement: Prior experience in data cleaning and verification, particularly with mixed data from a database, is highly desirable. Understanding of common data issues and how to resolve them quickly will be key to your succes...
We we forced to udpate our server form centos7 to alvaviva that has a more recent version of mysql, now one main pure php file we have are throwing some errors. We need someone to update it. No logic changes needed just syntax and maybe some database access query.
I need a professional who can help me consolidate numbers from an existing Excel file and distribute targets based on specific priorities. Key Tasks: - Data consolidation from the provided Excel file - Distribution of targets with a focus on specific categories Ideal Skills: - Proficiency in Excel - Experience in data analysis - Ability to follow precise instructions and prioritize tasks accordingly Please note, the rules for data consolidation have not yet been determined and will need to be discussed.
I'm looking for a proficient Data Analyst to assist with generating reports based on our sales data. Key Responsibilities: - Analyze sales data to create comprehensive reports Ideal Skills: - Proficiency in Excel is a must - Previous experience with sales data is preferred - Strong analytical skills - Excellent report writing abilities
My Elasticsearch setup is currently experiencing critical health issues, particularly with the cluster. I am in need of a seasoned network administrator who can diagnose and rectify these issues, as well as optimize the overall performance of Elasticsearch. Key Requirements: - Expertise in Elasticsearch version 7.x - Proven track record in network administration - Ability to enhance search query speeds - Skills in solving cluster health and indexing problems Your timely intervention can help restore my Elasticsearch to optimal health and performance.
I need a freelancer to convert 49 pages of a PDF file into an Excel sheet. The PDF contains mixed data - both text and numeric information. Key Requirements: - Experience with data entry and Excel - Ability to understand and implement custom formatting - Attention to detail to ensure accuracy The Excel sheet needs to be formatted according to specific, custom requirements. This may involve detailed cell formatting, such as merged cells and specific alignments. Please note that this project does not require maintaining the original PDF formatting, but rather creating a unique, custom layout in Excel. Ideal candidates should have strong Excel skills, experience with custom formatting, and a meticulous approach to ensuring data accuracy.
...structured assessment design. Enable customizable question generation based on: Subject/topic selection Difficulty level (Easy, Medium, Hard) Question types (MCQs, Short, Long, Case-based, etc.) Implement automated question paper generation in: PDF format for printing Word format for editing Develop a user-friendly admin panel to manage generated questions and papers. Ensure error handling, API logging, and efficient processing for optimal performance. Requirements: Strong expertise in PHP CodeIgniter framework. Experience with Azure OpenAI API and OpenAI PHP Client. Familiarity with Bloom’s Taxonomy, CO-PO mapping, and question frameworks. Ability to generate structured documents (PDF & Word) dynamically. Strong understanding of REST APIs and JSON data handling....
extract data from web ejar SA, and put it into excel sheet
I need an application for Breast Cancer Patients In The Radiology Department, where they undergo eight different tests. I want the pateint information the has been inter be able to save then in excel The program should help schedule these tests based on the following basic information: • Patient name • Patient age • Patient file number • Referral date to mammogram • Treating doctor’s name • Patient’s phone number • Treating doctor’s email • A field from which I can send an email from my personal email The first procedure is the mammogram date. The mammogram should be scheduled within 48 hours from the referral date, taking into consideration that the appointment should fall between Sunday and Thursday. The result field is ...
I'm looking for a skilled Excel expert or data analyst to create a dynamic Excel sheet for me. This sheet should generate random pairings between individuals, taking into account specific conditions (cannot be from the same cohort year and cannot be repeat matches). Key Project Details: - Number of Individuals: Between 50 and 100 - Pairing Frequency: 3 times a year - Information to Include: - Cohort year - Full name - Email address - Previous matches Ideal Skills and Experience: - Advanced Excel skills - Data analysis experience - Understanding of creating dynamic and interactive spreadsheets - Prior experience with similar projects will be an advantage. This project will help to facilitate interactions between individuals in a controlled and fai...
...information (e.g., social media links, addresses). • Ensure data accuracy and relevancy. Qualifications: • Proven experience in market research or business consultancy in UAE • Familiarity with African business networks or diaspora communities, especially in UAE. • Strong organizational and analytical skills. Deliverables: • A comprehensive and well-organized directory in an editable format (e.g., Excel, Google Sheets). • A short summary report of the research process and insights gained during the project. Additional Information: • Preference will be given to candidates familiar with Dubai’s African community or with access to existing networks. • Please include examples of previous relevant projects or research in your proposal. ...
Necesito modificar un Excel para que se vea bien y sea funcional que los requisitos que se han puesto funcionen
I want to know the address OR pin of every residence or hotel or public facility in Georgetown GUYANA with a domestic swimming pool for pool surfing plies sales purposes
I need a query function that handles total event duration data. The function should be able to process numerical data representing event durations. The example sheet contains the data and i want a sum(v) in the query function in the cell A8 error message : Impossible d'analyser la chaîne de requête pour Le paramètre 2 de la fonction QUERY : AVG_SUM_ONLY_NUMERIC
I'm in need of a proficient Excel expert who can develop a macros solution for me. This will primarily be used for automating data formatting and report generation tasks in Excel. Key Requirements: - Expertise in Excel macros - Ability to automate data formatting tasks - Experience in creating macros for report generation - Proficient in handling Excel files The ideal freelancer for this project should have a deep understanding of Excel and experience in creating and implementing macros. The goal is to streamline my workflow and make data handling more efficient.
I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry
We are looking for a development partner to build a Guard Tour Tracking App with the following key features: Real-Time GPS Tracking: The app should enable security personnel to be tracked in real-time. Checkpoint Scanning & Task Logging: Each checkpoint should have designated tasks that guards can log, such as temperature readings and door status. Incident Reporting: An intuitive interface for guards and supervisors to report incidents quickly and efficiently. Temperature Logs: Track and store temperature data for specific locations (e.g., trailers and checkpoints), with easy querying for audits and reports. Trailer Check-In & Out: A system to manage trailer entries and exits, including regular temperature readings every 2 hours. Rearranging Trailer Order: Ability to sort t...
...at trade shows happening in the Dubai World Trade Center, specifically focusing on the Food and Beverage sector. Gulfood 2025 Dubai International Boat Show 2025 worldofcoffeedubai 2025 go on abaove website click EXHIBITOR LIST Key Deliverables: - An Excel spreadsheet containing the following fields: - Company names - Contact persons - Company addresses - Email and WhatsApp numbers of owners - Locations - Sector - Manual verification of the authenticity of the collected data. Ideal Skills and Experience: - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks. To get awarded for this project, you need to extract at least 100 emails from a single website mentioned in the examples. Please note, I am...
I have over 10 Excel files containing customer contact details that need to be consolidated into a PostgreSQL database. The good news is that all these files have a consistent format, which should make the task easier. Key Requirements: - Expertise in PostgreSQL - Proficient in Excel - Experience with data consolidation - removing duplications Please ensure to deliver a clean, organized database that accurately reflects the data from the Excel files.
...names of few companies + 1 link containing lists of other companies. For each company, gather the following information (where available): Company Name Key People (CEO, Founder, Marketing Head, Sales Head, or equivalent) Job Titles Contact Details (email addresses, phone numbers) LinkedIn Profile URLs (if available) Organize the data into a structured Google Sheet or Excel file. Requirements: - Experience in data scraping, web research, or lead generation. - Attention to detail and accuracy in collecting and entering data. - Ability to use professional tools like LinkedIn, email finders, or other research methods to locate information. - Familiarity with verifying email addresses to ensure they are active and bounce-free....
I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry
