Databases Projects

Spread Sheet expert

Seeking a spreadsheet expert to finalize a social media content calendar template. Project initiated; requires completion of structure, formulas, and automation (scheduling, content status, character limits, posting times, duplicate detection, and summary metrics). Deliverables: polished, user-friendly template with clear sheets for monthly planning, content bank, captions, hashtags, platform-specific fields, and dashboard with KPIs. Clean, well-documented formulas and lightweight scripts for scheduling and reminders. Timely delivery and test examples required.

Very Simple Spreadsheet Project!

This is an easy one. All you have to do is copy information from an auction results website into a google spreadsheet. There are 19 auctions, with around 100 cars in each sale. It's a few hours work.

VERCEL MONGODB

I need an expert for a very quick job - I need someone to add customer login info into our admin system.

Data Scraping / Data Mining

I want data for UK Metal companies. Emails/phone numbers. Can you data scrape the member lists from the following: 1. https://www.mpma.org.uk/category/suppliers/ 2. https://galvanizing.org.uk/galvanizers-association-members/uk-and-irish-members/ 3. https://www.castmetalsfederation.com/cmf-members/supplier-search 4. https://alfed.org.uk/members/members-directory/ 5. https://thecbm.co.uk/our-members/member-directory/

Create excel tabel

Create an excel table of client who fail to attend their appointment, the contact attempts we have made and if they have successfully attended or not. columns Name Reference WNB date contact 1 email AND whatsapp date - go orange when 1 day after wnb date to indicate this is due. Contact 2 email (4 days after contact 1) - go orange to indicate due Contact 3 phone (4 days after contact 2) - go orange to indicate due contact 4 email (4 days after contact 3) - go orange to indicate due Taks to dentist ((4 days after contact 4) - go orange to indicate due) Dentist response: (low/high risk) Known safeguarding concern: no/yes - if yes go red WNB champion tasked (low risk) date: go pink Safeguard lead tasked on date (high risk): Safeguard lead response (go orange 4 days after notification date) refer go red /no-refer - go pink OUTCOME reason for WNB Rebooked date: Appt attended (go orange on rebooked date) yes/no - if yes and no in known safeguarding concern than hide entire row.

Excel sheet count objects, total items etc.

I need someone to refine this excel spreadsheet in terms of: For each floor, basement, ground ,first, second, mezzanine and third floor In the row - PASS, FAIL, ENABLE count the quantity from the floor. In the row - YES NO count the YES and NO separately In the row - Replace luminaire, Replace indicator count the required replacement e.g. 7 Replace Luminaire, 4 Replace Indicator. Format the worksheet so that it can be copied and pasted into a word document as a JPEG or whatever you think is best. Please also refine the report in terms of look and appearance to your professional ability. This is urgent please I need to issue the report tomorrow. Many Thanks

opportunity

MySQL database needs to handle non-English characters

Experienced MySQL/WordPress developer needed to fix character encoding issues in a 391MB production database. Greek characters currently display as "???" due to charset/collation issue following DDoS attack some years ago. Tasks: analyze database config, convert tables and fields to proper UTF-8/utf8mb4 without data loss, correct connection settings, verify restored Greek text, and provide a safe migration plan for a staging environment. Expertise with backups, SQL conversions and WordPress charset nuances essential. (I'll shortly be setting up a WordPress staging site and it seems a suitable time to fix the database problem.) Nigel Howarth

Data scrape

data scrape numerous business catagories. business name telephone number email addresses of owners/directors/marketing/and generic. this will be in sunnyvale california and i will pinpoint the location on the maps then please go out a five mile radius. i will upload the types of businesses. I would like a price for 500leads and a price for 750 please. If using google maps i would like you to start at the location below and go outwards from there on a 5 mile radius if using linkden check the areas a five mile covers. Bay Area Estate Attorneys, P.C. 440 N Wolfe Rd, Sunnyvale, CA 94085, United States

Resuscitate my website and make a Plugin work properly

Revive and secure my website: investigate and resolve CPU overload and suspicious activity, harden security, remove malware and optimize performance. Diagnose and fix the Simple Quiz plugin so it reliably generates and prints certificates for users who achieve a specified score. Provide thorough testing, clear documentation of fixes and recommendations to prevent recurrence. Experienced developers only; timely, professional delivery with attention to stability and data integrity.

Mac & Microsoft 365 SharePoint Consultant Required – London NW10

We are looking for an experienced Apple Mac and Microsoft 365 consultant to help us organise and improve our company filing system and resolve some Mac-related issues. This project requires someone with strong experience in SharePoint, OneDrive, Microsoft 365 permissions, and Apple Mac environments. The successful freelancer must be able to attend our office in London NW10 for an onsite visit. Scope of work: 1. SharePoint setup and organisation Review our current SharePoint setup and recommend improvements Create a simple, user-friendly SharePoint landing page Design a clear company filing structure that staff can easily understand and follow Organise folders/documents in a logical way Set up correct user permissions and access levels 2. Confidential folders and permissions Create restricted areas for confidential information Ensure sensitive folders are only accessible by myself and authorised management users Make sure general staff only have access to the information they need 3. Easy desktop folder access We want staff to access files in a familiar “old-school Windows folder style” rather than needing to use the SharePoint website. The freelancer should: - Configure SharePoint/OneDrive syncing correctly - Set up folders so users can access files through Finder on Mac (and ideally similar access for Windows users if required) - Make the system simple and easy for non-technical staff to use 4. Mac troubleshooting We also need assistance with: Troubleshooting issues on a manager’s Mac laptop

opportunity

Data Scrape to Database

Hi, This project has a couple of layers: 1. Create a process that, using a link to an Amazon Page, scrape the product description, pricing and photos associated 2. Imort the above into a database that you would create 3. The database will have user defined fields for myself to update, mainly tick boxes, but some free text 4. The database should allow for export to Excel and also sortation within the data base the second layer is: 1. Using the scraped data create draft products within Ebay or similar 2. OPnce uploaded to Ebay or similar the databsed entry needs to be auto updated Thanks

IBM FileNet Expert — Scoping & Solution Architecture

We're looking for an IBM FileNet Expert to help scope a FileNet implementation, migration, modernization, or support project. This is a discovery and scoping-focused engagement: you'll join client calls to understand business and technical context, ask the right questions to clarify the current FileNet environment and future-state goals, and help define effort, risk, dependencies, and delivery approach. If you can walk into a client conversation and quickly translate ambiguous business needs into a clear technical scope, this is built for that. What You'll Do - Join client calls to understand business and technical context around the FileNet environment - Help scope the full FileNet project, including effort estimation, risks, dependencies, and required skill sets - Ask relevant technical questions to clarify the current FileNet environment and future-state goals - Provide recommendations on the best delivery approach and next steps - Assess technical requirements during client-facing discovery calls - Identify project risks, dependencies, and an appropriate delivery approach - Translate business needs into clear, actionable technical requirements What You Bring - Strong hands-on experience with IBM FileNet - Experience scoping FileNet implementation, migration, modernization, or support projects - Ability to assess technical requirements during client-facing discovery calls - Experience identifying project risks, dependencies, and delivery approach - Strong understanding of enterprise content management systems - Ability to translate business needs into technical requirements - Experience working with enterprise architecture or solution architecture teams

opportunity

Need IT support cover

Seeking experienced IT support coverage for a nine-day period from Thursday, 30th July to Tuesday, 11th August 2026. Duties include troubleshooting hardware and software issues, remote and onsite assistance as needed, system monitoring, incident resolution, user support, routine maintenance, and clear documentation of actions and outcomes. Candidate must demonstrate strong communication, reliability, and proficiency with common OS, networking, and ticketing systems. Timely, professional service and availability across the specified dates are essential.

opportunity

Compliant Rota

I need to build a staff Rota that encompasses a firm set of rules and demonstrates compliance with the rules. The rota needs to be a rolling rota, with shifts allocated fairly

opportunity

Scraping data from the internet

I am looking for an experienced web scraping professional to extract structured data from a UK school directory site. The target website is the Independent Schools Council (ISC) directory. An example of the exact page structure can be found here: https://www.isc.co.uk/schools/england/berkshire/newbury/cheam-school/ There are approximately 1,600 similar school profile pages across this directory structure. Please note that the exact number is unverified, so your initial task will involve crawling/mapping the total number of profile URLs to confirm the final scope. Data Requirements: I need the following data points for each school: - School Name - Postcode - Total Size (Number of pupils) - Total number of Day Boys (this is the number in brackets) - Total number of Boarding Boys (this is the number in brackets) - Total number of Day Girls (this is the number in brackets) - Total number of Boarding Girls (this is the number in brackets) - Boarding fees per term (lowest number) - Boarding fees per term (Highest number) - Day fees per term (lowest number) - Day fees per term (Highest number) Deliverables: A clean, well-formatted Excel (.xlsx) file. Each school should be a row, and each data point listed above should be a clearly labelled column. Ability to handle missing data fields gracefully without breaking the spreadsheet structure (some schools may not list all fields). Good communication skills to confirm the final page count before executing the full script. Many thanks

opportunity

Excel automate, Power Query, data mapping, dashboard development

I am looking for an experienced Excel and Power Query specialist to complete a multi-level governance and assurance system for a health and social care organisation. The organisation has five service divisions. The workbooks, registers and overall structure have already been designed; I am not looking for someone to start again. I need someone who can review the existing files, improve the formulas and functionality, make the registers smarter and create reliable connections across the system. The required reporting flow is: Service/Practice Observation → Regional Governance → Divisional Governance → Group Governance/Master Dashboard Each division requires its own governance workbook and dashboard. Service and regional information must feed into the relevant divisional workbook, with key information from all five divisions feeding into one Group-level Master Dashboard. Smart governance registers The project includes a suite of existing registers covering areas such as: Risk Safeguarding Incidents and serious incidents Complaints and compliments GDPR and data breaches Restrictive practice Governance actions Service user feedback Audits and improvement Regulatory actions Training and workforce compliance The exact number of files will be confirmed with the successful freelancer following an initial review. The registers need to become functional, consistent and easy to use, rather than simply formatted spreadsheets. Depending on the register, this may include: Unique reference numbers Automated status calculations Open, closed and overdue indicators Due-date and review alerts Automated risk ratings and RAG indicators Dropdown lists and controlled data entry Conditional formatting Automated totals and summary metrics Monthly, quarterly and annual reporting Filtering by service, region, division, category, status and reporting period Identification of themes, recurring issues and required escalations Formula protection without restricting data entry Summary pages or dashboards Connections to the appropriate regional, divisional and Group dashboards The registers will remain the source of truth for individual records. Only relevant totals, themes, trends, risk ratings and outstanding actions should feed into higher-level dashboards. Main requirements The successful freelancer will be required to: Review and inventory the existing workbooks and registers Produce a clear data map showing how information should move through the system Make the registers smarter, more automated and easier to maintain Add, correct and protect formulas across multiple files and tabs Standardise dropdowns, identifiers, categories and reporting periods where required Create calculated metrics, alerts and RAG indicators Link Practice Observation data to Regional Governance workbooks Link Regional Governance workbooks to the relevant Divisional Governance workbook Complete dashboards for each of the five divisions Link all five Divisional Governance workbooks to the Group Master Dashboard Link relevant register data to the correct reporting level Use Power Query or another reliable Excel-based method where appropriate Ensure files work reliably within Microsoft 365/SharePoint Reduce the risk of broken links when files are moved, updated or refreshed Test the complete data flow from source registers through to the Master Dashboard Ensure the system is straightforward for managers with varying levels of Excel experience Deliverables Smart, functioning governance registers Functional Practice Observation templates Regional Governance and Assurance workbooks Five Divisional Governance workbooks and dashboards One Group Governance workbook and Master Dashboard Reliable connections between all relevant files Working formulas, validation, dropdowns, alerts and RAG ratings A complete data map/data dictionary Testing of the full reporting flow Simple refresh and maintenance instructions Final handover and correction of any errors identified during testing Confidentiality The work relates to confidential organisational systems. A Non-Disclosure Agreement must be signed before any files are shared. Anonymised or test data will be used wherever possible. Please include in your proposal: Your experience of creating smart Excel registers and trackers Your experience of linking Excel files stored within SharePoint/Microsoft 365 Your Power Query experience How you would minimise broken connections How you would approach mapping and testing this system Examples of comparable work What you can deliver within the approximate £1,000 budget