Database website using excel jobs
I'm a university student seeking a mentor to help me navigate my data module. The focus is primarily on using Excel functions to sort numerical data. Key Responsibilities: - Interpret and explain the tutorials provided - Help me understand and apply Excel functions to sort numerical data - Provide guidance on data analysis techniques Ideal Skills: - Proficient in Excel - Strong understanding of data analysis - Previous experience tutoring or mentoring university students Looking forward to your bids.
...manual data entry. Usability & Documentation: The model should be user-friendly, with clear documentation explaining the assumptions, methodology, and structure used. Expertise Required: Subject Matter Expertise: A solid understanding of the cattle export industry, supply chain management, logistics, and market dynamics. Financial Modeling Skills: Expertise in building detailed financial models in Excel or other modeling software. The ability to manipulate existing models, apply new metrics, and forecast financial outcomes accurately. Financial Analysis & Ratios: Strong ability to calculate and interpret financial ratios, assess the financial health of businesses, and conduct thorough financial analysis. Experience with Scenario Analysis & Sensitivity Testing: Abilit...
I'm in need of a skilled software engineer who can help me fix my JSON parser (implemented in Excel/VBA). The parser is encountering crashes and unexpected behavior when dealing with a new format of JSON. Key Requirements: - Diagnose and fix bugs in the JSON parser - Ensure the parser can handle the new JSON format Ideal Skills: - Proficient in debugging software - Experienced with JSON data and parsers - Familiar with the specific issues of crashes or unexpected behavior
I'm looking for an experienced Excel macro developer to create a macro that will import data from a specific TXT file on my computer and format it to match my PDF example. I currently pull the data from an IBM and it is saved on my windows computer as "AP Data." I then need to be able to open an excel workbook and run a macro that will import "AP Data" and format it so it matches the PDF example identically. All numbers in the excel worksheet after import need to be formatted as accounting so something that appears on the PDF Example as 7.50- will change to (7.50). The print area needs to match the PDF example. There are page numbers at the top right of each page and that needs to be how it prints in excel. Below is th...
I'm looking for a professional with expertise in Bartender Software. I need to create barcodes pulling from specific fields in a Master data spreadsheet. The spreadsheet is located in Egnyte and is co-edited using Microsoft Excel Online. The fields I am interested in include GTIN, Catalog Number, Lot Number, Serial Number, Expiration Date, and Quantity. This data needs to be pulled from filtered data based on a blank Allocation column (see attached spreadsheet) Ideal skills and experience for the job: - Proficiency with Bartender Software. - Experience in barcode generation and software integration. - Attention to detail to ensure accurate data pull for barcode creation. Please reach out if you have the necessary skills and experience.
Core Features & Modules 1. User Roles & Access Control • Admin (Owner): Full control over system functions. • Staff (Employees): Can add expenses, view their reimbursements, and check vehicle file status. 2. Vehicle File Management • Ability to create a new file for each vehicle clearance using: o Chassis Number / File Number (Unique Identifier) o Client Name o Vehicle Details o Status: Pending, In Progress, Cleared o Total Expenses Incurred • Staff members can only add expenses if the file is active. • Admin has access to re-open a file in case a staff member forgot to add an expense. 3. Expense Tracking & Reimbursement • Staff members can log daily expenses for each file by selecting: o Chassis/File Number o Expense Type (Custom Duty, Po...
I'm seeking for a professional who can help me extract contact information from customer accounts on the website www.food-service.de. Key Requirements: - Extracting contact information from customer accounts on the website - Delivering the extracted data in an Excel spreadsheet Ideal Skills and Experience: - Proficient in data extraction and web scraping - Excellent attention to detail to ensure all relevant contact information is extracted - Experience with delivering data in Excel format Please provide a concise proposal detailing your experience and approach to this project. Show me scraping first 50 details like name,mail,contact number with your term project.
I am in need of a skilled female Indian professional with expertise in Tally and Excel to assist with data entry and recording. The primary focus will be on tracking expense and income. Key Responsibilities: - Accurate data entry of expenses and income into Tally and Excel - General assistance and guidance in categorizing data Ideal Candidate: - Proficient in Tally and Excel - Excellent attention to detail - Able to provide guidance in data categorization - Female Indian professional
I am looking for a freelancer who can provide me with an email list of AirBnB, VRBO (Vacation Rentals by Owner), and other short term vacation rental hosts in North Carolina, South Carolina, Alabama, and Georgia. in the form of an Excel spreadsheet. All hosts are acceptable and there are no specific criteria for inclusion in the list. The ideal candidate should have experience in data mining and compiling email lists. Attention to detail is crucial to ensure that the list is accurate and up-to-date. The list should contain the following: Name, phone number, and email address, and should all be valid and up to date information. We will need around 1000 leads to start.
I'm seeking a professional ...in one location, and we also have to be about to seperate all material and labor $ so we can add sales tax to Material, and or to Labor and show that on the proposal. (many of our jobs are Sales tax exempt on Material and Labor is usually not taxed.. but sometimes is. Key Requirements: - Expertise in cost estimation for materials and labor. - Proficiency in spreadsheet software, particularly Excel. - Ability to present a detailed breakdown of costs clearly and concisely. Your experience in creating or modifying estimating spreadsheets will be crucial for this project. We currently have a spreadsheet but think it could be modified so it it is easier to update material costs, add materials and create "kits" We will provide our existing ...
I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.
I'm seeking assistance with a data entry task involving daily stock prices. Key Responsibilities: - Copy stock prices from the NSE website and Investing.com. - Paste the information accurately into an Excel file. Ideal Skills: - Proficient in Excel. - Detail-oriented to ensure data accuracy. - Familiarity with stock market terminology is a plus. Experience: - Previous data entry experience, particularly with financial data, will be highly regarded.
We are a local plastering and drylining company in Cannock, Staffs WS11 7LG, currently in need of a qualified freelance Quantity Surveyor (QS). The ideal c...of a qualified freelance Quantity Surveyor (QS). The ideal candidate will be responsible for conducting take-offs for both dry lining and plastering. Key Responsibilities: - Regularly attending our office once or twice a week (local to Cannock is a must) - Conducting accurate take-offs for both dry lining and plastering - Delivering take-offs in digital format (Excel files) Skills and Experience: - Proficient in Excel - Prior experience as a QS in the plastering and drylining industry - Able to conduct both dry lining and plastering take-offs - Local to Cannock and able to attend our office regularly Ma...
I'm seeking a proficient Excel developer to create a quotations maker for me. The quotations should be generated in an Excel format. Key requirements: - The quotations maker needs to have a customer database integration. - The customer database will require manual entry. Ideal skills and experience for the job: - Extensive knowledge and experience in Excel. - Previous experience in developing similar quotation makers. - Understanding of customer database integration in Excel.
A lot of this issuer benefit is throughout the other documents. and in the "web Illustration" forwarded.
...have been awarding projects for 10+ years. The chosen freelancer will receive positive feedback score and prompt payment. ----------------- About the task ----------------------- Build an AI-enabled application which 1. Recognizes the correct column header and places the correct data in the correct column a. Excel b. Text c. Word document d. PDF 2. Recognizes hand-writing upload from 1. Image files (JPG, GIF or PNG) 2. PDF files 3. Compiles the data into a correct Excel sheet (for students, parent and teacher) 4. Uploads the data into our web application called Kontakkt Please read the attached project file carefully, which explains the output tasks We will provide the winning bidder with a live user account to login to Kontakkt, with data already inside there ...
I'm looking for an expert in Excel and VBA to help me create a custom workbook. The primary purpose of this workbook is to manage and collate employee time entries. Key Requirements: - Design a workbook tailored for tracking employee time. - Implement VBA code to hide and unhide specific worksheets based on user access. - The VBA code should allow each user to only access the worksheets I define. Ideal Skills: - Proficiency in Excel and VBA. - Experience in designing custom workbooks. - Knowledge in user-specific worksheet management through VBA.
I need assistance with entering numerical data sourced from online databases into an Excel Spreadsheet. Ideal Skills: - Proficiency in Excel - Experience with data entry - Familiarity with online databases Requirements: - Accuracy in data entry - Ability to follow instructions - Attention to detail
I need a skilled app developer to create a robust Android-only application for handling Excel formulas and performing calculations on financial data. Key Features: - The app should generate insightful reports and visualizations from financial data. - Ability to create and edit Excel formulas. - Perform complex calculations with ease. Ideal Candidate: - Proficient in Android app development. - Experienced with financial data processing. - Skills in creating data visualization tools. - Familiarity with Excel and its formulas.
I need an expert in either VBA or Python who can help me search, validate, and compare alphanumeric data in multiple cells in Excel. The results should be shared in another cell indicating whether the data is 'Matched' or 'Not Matched'. Key Requirements: - Proficient in either VBA or Python - Expertise in Excel data manipulation - Ability to implement custom logic for data validation and comparison - Capable of creating clear output in Excel Data Validation: - The data will need to be checked for specific patterns. - The patterns are not standard and will require custom logic to identify. Ideal Skills: - Strong experience with Excel's VBA or Python integration - Excellent problem-solving skills for creating custom data validation logic - At...
I need an Excel guru to analyze my bank statement urgently. - Primary Data: The data to be analyzed is my bank statement. - Specific Analysis Required: I need help categorizing my expenses, as well as summarizing my income vs. my debits. - Categorization Method: All expenses should be categorized by merchant name. Ideal candidates for this project should have strong Excel skills, be able to work quickly and efficiently, and have experience in data analysis and expense categorization. Please apply if you can help me with this task urgently.
...essential features for efficient lab operations, such as patient management, medical device connectivity, invoicing, contracts, online booking, user roles and permissions, and detailed medical reports. --- ? Detailed Software Requirements: 1️⃣ Patient Management & Online Booking Patient registration system with full medical history and previous test records. Online appointment booking via website or mobile app with confirmation notifications. Advanced patient search by name, phone number, or ID. 2️⃣ LIS Integration for Device Connectivity Direct connection with laboratory instruments via standard protocols (HL7, RS232, TCP/IP). Automated result retrieval to minimize manual entry errors. Review system before finalizing and releasing results. 3️⃣ Billing & Con...
New Junior level freelancer from Pakistan or india of laravel. I need at low budget. I am looking for a junior level Laravel developer to help me with a new project. The tasks will involve bug fixing and potentially database management. The ideal candidate should have a good understanding of backend development and be able to work with existing code. Experience with web application and API development would be beneficial. Please note this is a junior level position, suitable for someone looking to gain more experience in Laravel development.
I'm looking to work with an experienced Excel specialist who can help me with advanced functions and automation, specifically with sales data. - I need assistance with VLOOKUP and HLOOKUP, PivotTables, as well as Macros and VBA. - The primary goal of the project is to identify trends within the sales data. - I also expect engaging charts, graphs, and summary tables to be created to represent the data visually. - Accuracy and attention to detail are crucial for this project. Ideal candidates for this project should have extensive experience with Excel and data analysis, as well as a keen eye for detail. Skills in creating visually appealing and informative charts and graphs will also be highly valued.
Configuration and integration of Sportspress on WordPress 1 - General configuration of Sportspress - Set up and configure the Sportspress plugin. - Check compatibility with SmartMag theme and other installed plugins. - Activate and optimize performance to avoid site slowdowns. - Develop the player profile using PHP or Python to ensure the site's scalability and avoid any future issues. ________________________________________ 2 - Match sheet configuration - Automatic link between match sheets and player records. - Checks the correct operation of the statistics recorded in the player files. - Automatic synchronization of match data (goals, assists, cards, minutes played, etc.). ________________________________________ 3 - Creating and managing player files Information to be dis...
I'm seeking a skilled Excel VBA developer to create a utility that interfaces with both Serial Communication and IP data, sending the parsed information directly to specific columns in an Excel worksheet for further processing. Key Requirements: - The data being received is mixed, comprising both numeric and text elements. - A significant portion of the project involves data visualization, so experience in working with graphical representations of data in Excel is a must. - The selected freelancer will need to program the utility so that it reflects the parsed data in specific columns of the worksheet. Ideal Skills: - Proficiency in Excel VBA - Experience with data parsing from Serial and IP sources - Strong understanding of data visualization techniqu...
I'm seeking an experienced Data Analyst Trainer to join Xoon Infotech. If you're passionate about teaching and have expertise in SQL, Power BI, Tableau, Python, Machine Learning, R, and Advanced Excel, I’d love to hear from you! Key Requirements: ✅ Extensive experience in Data Analytics, Business Intelligence, or Data Science ✅ Proficiency in SQL, Power BI, Python, R, and Machine Learning ✅ Previous corporate or online training experience preferred ✅ Ability to conduct live online sessions and guide advanced-level students on real-world projects ✅ Excellent communication and mentoring skills What We Offer: ? Competitive Compensation – Get paid per session/hour ? Flexible Schedule – for weekdays and weekend batch ? Engaged Learners – Work with moti...
I'm looking for a simple IMEI database with HTML code that I can use for tracking devices. Key Requirements: - The database should allow me to search by IMEI number. The project will involve creating a basic IMEI database that is user-friendly and efficient for tracking device. I get text or excel file with IMEI and its unlocking code. I just want to upload so user just type in imei on page and can get code from that file,
I'm seeking an Excel expert to analyze my sales data. Deadline ASAP Budget is 20AUD
Hello Sophia, Attached is a Excel for translation into Ukrainian. SLA - March 11th. Thank you, G
Job Title: Freelance Data Analyst (Advanced Excel & Power BI Expert) Job Description: We are looking for a skilled freelance data analyst with strong expertise in advanced Excel, data management, dashboard creation, and Power BI. The ideal candidate should be able to analyze complex datasets, generate insights, and build interactive dashboards to support business decision-making. Key Responsibilities: Manage and clean large datasets efficiently. Develop and automate dashboards in Excel & Power BI. Perform data analysis to derive actionable insights. Create visual reports and interactive dashboards for stakeholders. Ensure data accuracy and integrity. Requirements: Proficiency in advanced Excel (PivotTables, VLOOKUP, Power Query, Macros, etc.). Experi...
I have a project that involves cleaning mixed data in Excel. Key Tasks: - Remove duplicates - Handle missing values - Standardize formats Ideal Skills: - Proficient in Excel - Experienced in data cleaning - Attention to detail and ability to follow specific instructions
I'm looking for an Excel expert who can make some changes to an Excel file. The task must be completed today.
...Italian. In addition, I have 2 files of phrases (totaling 188 phrases) that need to be translated, though audio is not required for these. Key Requirements: - Utilize an online voice synthesizer as per the attached instructions or any alternative that produces equivalent output. - Deliver the .mp3 files as 3 individual ZIP files, corresponding to each word list. Ideal Skills: - Proficient in Excel - Strong attention to detail (ensuring all output files are consistent in volume) - Familiarity with the Italian language (not compulsory, but preferred) - Native or advanced proficiency in simplified Chinese or Arabic (a plus, as we can discuss extending the project to include these languages) Additional Information: - A female voice should be used for female-specific words, and a ...
I'm seeking an experienced Excel professional to assist me in creating a dynamic table that will track employee data. Key Requirements: - The table should allow for filtering and sorting of data to facilitate easy navigation and analysis. - Data will be entered manually, so the structure needs to accommodate ease of input and maintenance. Ideal Skills: - Advanced Excel skills, particularly with creating dynamic tables. - Experience with data management, preferably with employee data. - Good communication skills to understand and meet project specifications.
Steps: 1. Go to 2. An Excel sheet with specified columns will be shared with you 3. Search database by state and compile information such as company, contact, url, email address, etc.
...proficient Excel developer to transform an open-source R-Script used for calculating Scope 1, 2, and 3 emissions of buildings into a user-friendly Excel tool. Our clients struggle with R, so it is crucial that the Excel tool has the same functionalities and is easy to use. Key Requirements: - Excel tool must accommodate both numerical and categorical data inputs. - The tool must include the three calculators for Scope 1, 2 and 3 emissions. - Consistency with R-output is vital; the XLS output must match the R-output exactly (see tables 1 to 6). - The interface should be detailed and similar to the R-Script output layout. - Front-end with input and output, backend with calc and datasheets - No VBA/macros, only formulas, VBAs are blocked Ideal Skills and Exper...
0x4752ba5DBc23f44D87826276BF6Fd6b1C372aD24 0x8C2aCd31ab4dB493D11a79C4EA05316da2215932 0x6814acc39d3fBFC0581c0bC8aB6942e8B6b0D43d
Aufgabenbeschreibung: Excel mit VBA-Makros (Datenbank für Venture Capital, Private Equity und private Investoren mit Makros) ? Projektziel: Erstellung einer Excel-Datenbank mit VBA-Makros, die Venture Capital (VC)-Geber, Private Equity (PE)-Geber und private Investoren verwaltet. Die Dateneingabe erfolgt ausschließlich über benutzerfreundliche Eingabemasken. Die Datenbank enthält eine automatische Suchfunktion mit scrollbarer Liste, eine Investitions- und Dealverwaltung, eine Dokumentation der Kommunikation mit Kapitalgebern sowie ein Reporting mit Diagrammen. ? 1. Tabellenstruktur & Funktionen Blatt Funktion Blatt 1: Eingabemaske für Kapitalgeber (VC, PE, Privatperson) Erfassung neuer Kapitalgeber mit Deduplizierung & ID-Vergabe Blatt 2: E...
Project Overview We need a database specialist to help us implement an efficient archiving solution for our AWS RDS MySQL database. The goal is to archive older data from several related tables to archive tables while maintaining data integrity and minimizing downtime. Current Situation We have several interconnected MySQL tables that need archiving (packages, package_histories, cod_histories, rider_tasks, rider_packages) Data volume: ~500K rows in packages table and ~1.5M rows in history tables Current process: We manually select rows, insert them into archive tables (x_{table_name}), then delete from source tables Foreign key constraints are causing long deletion times We have a specific deletion sequence: package_histories → cod_histories → rider_packages &...
? 1. Core Features (CS-Cart Standard) ✅ Multi-vendor management with a separate dashboard for each seller. ✅ Product listing with images, descriptions, and variations (sizes, colors, etc.). ✅ Integrated payment methods (Stripe, PayPal). ✅ Order and shipping management with tracking functionality. ✅ Admin panel to monitor sales, orders, customers, and vendors. ✅ Automatic commission calculation for vendors. ✅ Return and refund policies with manual request submission by customers. ✅ Email notifications for orders, payments, and returns. ? 2. Essential Customizations for the MVP ? 2.1 Payment Management and Fund Hold ? Objective: Hold payments for 14 days after delivery confirmation to prevent fraud and disputes. ? Requirements: ✅ Integration with Stripe Connect or PayPal Adaptive Payments t...
...looking for a professional who can assist me in generating customer invoices in pdf format in bulk using a Microsoft Word 365 template and data from Excel spreadsheets. Your task will involve: - Utilizing a provided Word template to create invoices - Pulling customer contact details, an itemized list of purchases, payment terms and conditions, and a QR code of my company from Excel spreadsheets Ideal candidates should be proficient in Microsoft Word 365 and Excel, with experience in bulk document creation. Attention to detail is crucial to ensure all invoices are accurate and correctly formatted. The deliverable expected is a macro enabled excel which can take the input data from an excel, take the invoice template in the word format and shou...
I need a professional to generate customer invoices in bulk based on a Word template and data in a single Excel sheet. The generated invoices should be in PDF format. Key Requirements: - Proficiency in Microsoft Word and Excel, specifically Office 365 - Experience in bulk invoice generation - Ability to follow a Word template precisely - Skills in converting Word documents to PDF The data is organized in a single sheet with all the necessary information. The ideal freelancer for this project should be detail-oriented to ensure each invoice is correctly generated without errors.
I am looking for a skilled developer to create a professional at-home salon booking platform. The platform must include mobile app for customers and professionals along with website to book services. core features are: - Appointment scheduling: A user-friendly interface for both customers and salon professionals to schedule appointments seamlessly. - Payment processing: A secure and efficient payment gateway for transaction handling. - Rating and Review System: A transparent system for customers to review services and service providers, fostering trust and quality assurance. - Services Listing: A comprehensive section where salon services/packages will be listed. - Reward System: An engaging reward system to incentivize repeat customers and referrals along with coins reward syst...
' STRATA COLLECTIONS VERIFICATION TOOL ' This Excel workbook serves as a central verification tool for collections across multiple systems ' Structure and key formulas provided below '============================================== ' WORKSHEET: Import_Controls '============================================== ' Purpose: Tracks import status from multiple systems and standardizes data ' Key components: ' Import Status Tracking Table ' Columns: System_Name | Last_Import_Date | Records_Imported | Exceptions_Found | Status ' Data Source Configuration Table ' Columns: System_Name | Report_Type | Standard_Headers | Column_Mapping ' Import Instructions (Protected cells) ' Step-by-step guide on extractin...
I need someone to reproduce safety documents into an Excel Spreadsheet or Word. The reproduced documents should incorporate safety protocols and procedures. Ideal Skills: - Proficiency in Excel - Attention to detail - Understanding of safety protocols and procedures Please note, it is important that the reproduced documents are accurate and comprehensive in their representation of the original safety documents. I have attached only 3 pages of pics of the doc I require to be reproduced, in total the doc is 8-10 pages.
...Design a unified database structure integrating land records, deeds, and spatial data. • Ensure compliance with ISO 19152:2012, implementing LADM-compliant structures. 2.2. Data Migration & Integration Extensive dataset migration is required to consolidate multiple land records, valuation data, cadastral maps, and scanned documents into a unified system. The migration will include data validation, OCR processing, and integration with modern GIS and database management systems. Subcontractors must migrate and integrate the following datasets: A. Database Records (to be migrated into PostgreSQL/PostGIS) • MS Access Databases: o Deed Processing Database (~10MB, ~10,462 records) o Sales Evidence Database (~21MB, ~31,820 records) o Property Ta...
I'm looking for a reliable freelancer to help me with a data entry project for 600 clinics. The task involves entering specific contact details into an Excel spreadsheet. Data Entry Requirements: - Inputting the phone numbers and email addresses of the clinics. Ideal Skills: - Proficiency in Excel - Attention to detail - Previous data entry experience - Ability to maintain confidentiality and handle sensitive information responsibly. I expect the work to be done accurately and within a reasonable timeframe. Please include your estimated time for completion in your bid.
I'm looking for an experienced data engineer to extract specific information from the ASIC website and create a comprehensive Excel database. Data to be extracted includes: - Type of appointment - Date of appointment - State - Company name - Administration company - Administrator - Contact person - Email address The ideal freelancer for this project should have: - Proficiency in web scraping - Experience with data extraction from ASIC - Excellent skills in Excel and database creation - Attention to detail to ensure all relevant data is captured - Ability to deliver the project within the stipulated time frame.
I'm looking for an experienced developer to help me create an option screener using the Angel One API. I've gathered a lot of information (including resources from ChatGPT) but I need someone to assist me in completing this task. Key Requirements: - The screener should filter based on several parameters: Date, Index/Stock, Strick Price, Implied Volatility (IV), Price-to-Coverage Ratio (PCR), Delta, Open Interest (OI), Premium, Days To Expiry, and P&L. - The screener should focus specifically on Implied Volatility (IV), which is a crucial data point for the options market. - The output of the screener needs to include Strike Price, Open Interest (OI), and Delta. Ideal Skills: - Proficiency in working with the Angel One API. - Deep understanding of options trading and ...