Xls postgres jobs

I'm looking for a skilled developer to create a Windows-based application. This app should allow users to upload multiple Excel files, locate a specific product SKU within these files, extract its price, and compare it with prices from other uploaded files to identify the lowest priced supplier. Key Features: - Ability to load multiple .xlsx, .xls, and .csv Excel files. - Search for specific SKU within the loaded files. - Extract product prices. - Compare prices across different files. - Identify and display the lowest priced supplier. Ideal Skills: - Proficiency in Windows application development. - Experience working with Excel files and data extraction. - Knowledge in price comparison algorithms. - Strong problem-solving skills. - Excellent attention to detail.

...an admin. - Create a seating chart with the guestlist. Skills and expectations. - Designs will be provided by us. - Companies or individuals should be able to deliver the entire project end to end. - We would expect daily sync meetings and regular commits to github. - During development, work should be added to a stage site so that we can test and provide feedback. - Tech stack: python, JS, Postgres, FastAPI, React, Typescript, CSS, HTML - Good attention to detail. Front end needs to reflect the designs....

...OpenAI, Perplexity, OpenAI APIs & Open Source LLM's - Python scripting and automation tasks - Contributing to web development projects using NextJS, Javascript, and ReactJS - Working with several Node libraries, and Node JS in general - Ensuring production-ready deployments - Handling API integrations, Github workflows, and Linux administration - Managing databases such as MongoDB, PineCone, and Postgres - Web Scraping technologies like requests, bs4, hidden json api's, cookie-based scraping, browser automation, concurrent futures, asyncio etc. Ideal Candidate: - Comfortable dedicating 10 hours a day working from home - Able to handle multiple projects simultaneously - Eager to learn new skills alongside me - Willing to take on personal tech support tasks Compensa...

I am looking for a Power BI professional who can help me visualize some data for my existing business. The data will be provided in XLS and CSV formats once the contract is approved. Key Requirements: - Data Cleaning: Before visualizing, the data will need to be cleaned. - Data Merging: Similar data sets will need to be merged. - Building Relationships: You will need to establish relationships within the data sets. - Visualization: I need the data to be visualized into bar graphs in Power BI. - Deliverables: The final deliverable will be a .pbix file. Timeline: - I need this task completed ASAP, with a deadline of 22 October 2024. Please highlight your relevant experience in your application.

...expertise in Kotlin and Spring Boot to join our team on a freelance basis. You will be working on the backend of an e-commerce application, ensuring it is robust, scalable, and efficient. If you have hands-on experience with Kotlin and Spring Boot, we want to hear from you! Requirements: Strong proficiency in Kotlin and Spring Boot Experience building and maintaining RESTful APIs Familiarity with Postgres Knowledge of SQL and database design Experience with cloud platforms like AWS or Google Cloud (preferred) Familiarity with version control systems like Git Project Scope: Develop and maintain backend services for an e-commerce platform Build and optimize RESTful APIs using Kotlin and Spring Boot Integrate PostGIS for geospatial data features Ensure code quality, scalability, ...

I need a Python script that can modify specific values in different types of files - 2 types of PDFs, 2 types of CSVs, XLS files, and a TXT file - without altering the overall structure of these files. Modifications: - Change specific text values - Update numerical data Identification of Values: The script should locate the values to be changed by their position in the file. Handling Multiple Sections: The script should modify all sections or sheets in the file. Ideal skills for this project include: - Proficiency in Python - Experience with file manipulation (PDFs, CSVs, XLS, TXT) - Strong problem-solving skills Please let me know if you can assist with this. I can provide sample files for your reference. Thank you.

I need a professional web developer to develop a website for me. Show me your experience on the technoloies that I mentioned. Quote your price and time. Note: I don't want to use Shopify, Fouresquare, Wix!

I'm looking for a professional who can develop a comprehensive testing suite for my Python and Postgres projects. The suite should include a variety of tests to ensure the robustness and reliability of the code. Key Aspects: - The testing suite should be created using the PyTest framework. - It should encompass all types of tests: unit tests, integration tests, and performance tests. Skills and Experience Needed: - Proficiency in Python and PostgreSQL. - Extensive experience with PyTest. - Previous work in designing and implementing testing suites. - Knowledge of various types of testing including unit, integration, and performance tests.

...and Server Actions - Ability to work efficiently and deliver high-quality results in a fast-paced environment - Excellent communication skills and fluency in English - Availability during one of these time slots (Pacific Standard Time): - 6:00 PM to 2:00 AM PST, or - 7:00 AM to 2:00 PM PST ## Project Tech Stack: - Frontend: 14, Shadcn/ui - Backend: API routes, Prisma, Neon (Postgres) - Authentication: v5 (Next Auth) - Payment Processing: Stripe - Email: Resend, React Email - Development Tools: V0 by Vercel, Cursor AI (with Cursor composer) - Boilerplate: Next SaaS Stripe Starter (based on Taxonomy by shadcn) ## Communication and Collaboration: - Clear, prompt, and professional communication is crucial - Regular check-ins and updates are expected - Must be comfortable

...and Server Actions - Ability to work efficiently and deliver high-quality results in a fast-paced environment - Excellent communication skills and fluency in English - Availability during one of these time slots (Pacific Standard Time): - 6:00 PM to 2:00 AM PST, or - 7:00 AM to 2:00 PM PST ## Project Tech Stack: - Frontend: 14, Shadcn/ui - Backend: API routes, Prisma, Neon (Postgres) - Authentication: v5 (Next Auth) - Payment Processing: Stripe - Email: Resend, React Email - Development Tools: V0 by Vercel, Cursor AI (with Cursor composer) - Boilerplate: Next SaaS Stripe Starter (based on Taxonomy by shadcn) ## Communication and Collaboration: - Clear, prompt, and professional communication is crucial - Regular check-ins and updates are expected - Must be comfortable

...expertise in Kotlin and Spring Boot to join our team on a freelance basis. You will be working on the backend of an e-commerce application, ensuring it is robust, scalable, and efficient. If you have hands-on experience with Kotlin and Spring Boot, we want to hear from you! Requirements: Strong proficiency in Kotlin and Spring Boot Experience building and maintaining RESTful APIs Familiarity with Postgres Knowledge of SQL and database design Experience with cloud platforms like AWS or Google Cloud (preferred) Familiarity with version control systems like Git Project Scope: Develop and maintain backend services for an e-commerce platform Build and optimize RESTful APIs using Kotlin and Spring Boot Integrate PostGIS for geospatial data features Ensure code quality, scalability, ...

...AM to 2:00 PM PST ## Communication and Collaboration - Clear, prompt, and professional communication is crucial - Regular check-ins and updates are expected - Must be comfortable with screen sharing and voice calls when needed - Strong communication skills will be a key factor in determining long-term collaboration ## Tech Stack - 14, React, TypeScript - Prisma ORM, Neon (Serverless Postgres) - v5, Resend & React Email - Shadcn/ui, Tailwind CSS - Stripe integration - Cursor AI Composer, V0 by Vercel ## Current Project State - Frontend UI designed and implemented using V0 - Basic functionality implemented - Backend and API integrations (Stripe, Cents CRM) need completion ## Project Scope - Complete backend integration with Stripe and Cents CRM - Finalize user authenticat...

I'm in need of a professional who can assist with cleaning and preparing a mixed dataset in an XLS. - Data Handling: The dataset is a mix of text and numerical data, requiring meticulous attention to detail and proficient data handling skills. - Common Issues: The dataset has several common issues, including missing values, duplicate entries, and inconsistent formatting. - Data Scraping: The freelancer will also be responsible for scraping data from various resources, predominantly websites and APIs. Ideal candidates should have extensive experience in data cleaning, and dataset preparation in Excel. Proficiency in data scraping from websites and APIs is essential. Previous experience with handling mixed data will be a significant advantage. Please provide examples of similar...

I'm looking for an expert in EKS to deploy a self-hosted Temporal EKS cluster with Postgres RDS. The project also includes setting up TLS and Azure AD for Single Sign-On (SSO). Key requirements: - Extensive experience with EKS is a must. - Proficient knowledge of setting up and configuring Postgres RDS. - Experience with deploying Temporal on EKS. - Familiarity with TLS setup for secure communication. - Expertise in implementing Azure AD for SSO. The ideal freelancer for this project would have a strong background in Kubernetes and EKS, with a proven track record of deploying secure, self-hosted clusters. Excellent skills in database management and SSO implementation are also crucial.

I'm in need of a proficient web scraper who can extract product information from a specified website and deliver it in an XLS format. Key requirements: - Scrape product information from a designated website - Deliver the data in an XLS format Ideal skills and experience: - Proficiency in web scraping - Familiarity with data extraction from e-commerce and manufacturer websites - Experience in delivering data in XLS format

I'm dealing with a persistent high CPU usage issue attributed to Postgresql on my Linux Centos system. This problem is occurring constantly, not just during peak traffic times or specific queries. I've already attempted adjusting the server settings, but unfortunately, I haven't seen any improvement. Ideal Skills: - Extensive experience with Linux Centos - Deep understanding of MariaDB - Strong troubleshooting skills I need someone who can thoroughly diagnose and resolve this CPU problem. Please, only experts with proven skills in this area should apply.

I need a Java function that replicates the 'ExceltoPDF' functionality from the ILOvePDF portal. The function should handle XLS, XLSX, and CSV formats, preserving the formatting and layout from the original Excel file as closely as possible. Key Requirements: - Convert each sheet in a multi-sheet Excel file into a separate PDF - Maintain the output format similar to the ILOvePDF portal - Support for Excel file formats: XLS, XLSX, and CSV - Create a CDK to include this package - Create separate package for integration tests Ideal Skills and Experience: - Proficiency in Java - Extensive experience with Excel file handling and PDF generation - Familiarity with the ILOvePDF portal's conversion process - Attention to detail for preserving formatting and layout.

...backend and React for the frontend interface of the Trello Power-Up. You will also be responsible for implementing payment processing with Stripe and user authentication with Auth0. Responsibilities: Develop the Trello Power-Up: Create a Power-Up using React that allows users to upload Excel files and convert the data into Trello cards. Ensure compatibility with multiple Excel formats (e.g., .xlsx, .xls, .csv) using libraries like SheetJS. Implement functionality to map Excel columns to Trello card attributes (e.g., title, description, labels, due dates, etc.). Integrate User Authentication and Role Management: Set up user authentication and role management using Auth0 to differentiate free and premium users. Free users will have limited file uploads (e.g., 3 files per month),...

...Cloud. They need to be successfully deployed in Google Cloud. - Database - Cloud SQL managed database - Postgres 14 - Global external Application Load balancer - Front end protocol HTTP, backend session affinity GENERATED_COOKIE - Managed Instance template - Debian 11 - Startup script gsutil cp -r gs://cloud-training/cepf/cepf020/ . apt-get install zip unzip wget python3-venv -y unzip cd flask_cloudsql_example/sqlalchemy wget -O cloud_sql_proxy chmod +x cloud_sql_proxy export INSTANCE_HOST='' export DB_PORT='5432' export DB_USER='postgres' export DB_PASS='postgres' export DB_NAME='cepf-db' CONNECTION_NAME=$(gcloud sql instances describe cepf-instance --format="value(connectionName)")

We are seeking skilled Database Administrators (DBAs) to support our database systems, focusing on Oracle V11, Postgres v9, and MS SQL Server v12, with a strong emphasis on AWS RDS experience. The ideal candidates will provide ongoing database management and optimization, ensuring the reliability and performance of our systems. Location India (preferred) Time Commitment Initial Onboarding: 1-2 weeks to familiarize with our systems Ongoing Support: 4-8 hours per week ADHOC Requests: 2-4 hours, 1-3 times per month (estimate) CANDIDATE 1 AWS RDS experience (Preferred) Oracle v11 + CANDIDATE 2 AWS RDS experience (Mandatory) Postgres v9 + MS SQL v12 + Specific Tasks: General understanding of the number of databases and their purpose. How to access the da...

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, i...

...- Conducting web research on various topics (e.g. vacation targets, parking spaces,...) - E-Mail / Whatsapp communications (e.g. to request bookings or discuss discounts for an event) - Gathering informations in Lists like XLS or To Do Lists (Microsoft ToDo or Google Tasks) - What I need in the next 7 days: Some party arrangements like designing table card with names, which are easily printable on A4 paper. Your requirements:: - Very good web research skills - Proficiency in English - Smart use of common AI tools such as ChatGPT - Very good knowledge of MS Office (XLS, Word, PPT) and willigness to use Microsoft ToDo, Google Tasks and WhatsApp Since it is private, the budget is limited but in case of good quality, I would recommend you to other colleagues of mine who wou...

I am seeking a skilled developer to help build my website based on a Figma design. The project involves the creation of a job board, messaging system, dashboards, visual analytics, and user authentication features like login and password recov...features like login and password recovery. Key Requirements: - Convert Figma design into a functional site - Implement core functionalities: - Job board - Messaging - Dashboards - Visual analytics - User authentication (login, forgot password, etc.) - Set up multiple user roles and permissions Ideally, your team will also have backend developers experienced with Postgres/SQL to assist with API development. Strong knowledge of and backend database integration is a must. Familiarity with Figma is preferred.

I'm looking for an experienced WooCommerce professional to assist with bulk uploading physical products into my online store. The products will have variations, primarily in terms of size and color. All product images are prepared and ready for upload. Ideal skills for the job: - Extensive experience with WooCommerce - Proficiency in working with XLS files - Familiarity with bulk product upload processes - Attention to detail, particularly with product variations and image uploads I need someone who can handle this task efficiently, ensuring all products are correctly uploaded with their respective variations and images.

I'm looking for a PHP developer to create a web-based Sales Force support application. This app will cater to doctors as clients and is primarily focused on client management. We already have registrations in xls file and date have to be integrated in this app.

I want a quote for an Android and iOS app for a canteen. The canteen customer will have a login and will be able to see a calendar with three dish choices for each day (meat, fish and vegetarian). Each dish will have a title, description, photo and price. And you can purchase this menu up to 24 hours before the meal. In the shopping cart, you can buy several days' menus at once. The payment sy...payment system to integrate will be Multibanco and MBWay - The admin will have a login that will allow him to approve or register each customer, place the dishes for each day and will have a list where he can see the confirmed purchases for each day. The list will have a filter where you can export the list of dishes purchased for that day via csv or xls.

I need an experienced Odoo and PostgreSQL professional to set up a new Odoo database for me on an Ubuntu server. The current setup is throwing a database creation error. Key Requirements: - Troubleshoot the existing error: "FATAL: no entry for host "[local]", user "odoo17", database "postgres", SSL off" - Set up a new Odoo database - Ensure proper configuration of PostgreSQL (any version from 12 to 14 is acceptable) - Verify overall Odoo and PostgreSQL configuration Ideal Skills: - Extensive experience with Odoo - Proficient in PostgreSQL setup and configuration - Strong troubleshooting skills - Familiar with Ubuntu server management - Excellent understanding of database management and configuration

I'm seeking a skilled full-stack developer experienced with or React and Supabase or Postgres (or any alternative), and it would be better if it were written in Typescript, to create a simple single-page application. The project is an MVP and must comply with the proposed mockup The project will connect with a Supabase or Postgres database and will involve creating a user data display chart using a library like Recharts. Key Features: - User Data Chart: The chart will display user statistics. - User Registration: The forms will include a user registration feature. - Data Submission: Another form will be dedicated to data submission. - Repeated Graphics Elements: The project will include a small number of repeated graphics elements, primarily buttons and accordions. ...

Write "I have experience with meltano" if you know it. I'm looking for an experienced data engineer to help automate my ETL pipeline using dbt and Airflow, with Meltano and Postgres. Key Requirements: - Expertise in data engineering, specifically in data warehousing. - Proven experience with dbt, Airflow, Meltano, and Postgres. - Ability to ensure high data accuracy. This project focuses on creating a robust, on-premises data warehousing solution. The ideal freelancer will have a strong background in data engineering and a proven track record of creating and automating ETL pipelines. Your expertise will be crucial in ensuring the accuracy of the data, which is my main priority for this project.

Can you advise and setup 1) Scripting the environment onto a new machine 2) Backup of file system and Sql Server, Mysql and Postgres databases 3) How to apply the latest security patches/updates to the environment. Including what your created and the databases I will do the CI/CD pipeline for the applications Will test this on a new machine that the whole process works

We need a hybrid app (for both web and mobile) to enable our sales engineers to create lighting plans while on-site at a customer's premises. Key features: Users will select luminaires from our available product range. The app should allow users to upload floorplans and place symbols on them, representing the positions of selected lights. Dif...information such as the light's name, description, SKU, and quantity. Users must be able to assign lights to specific rooms within the table. The app should provide the functionality to take photos, attach them to the floorplan or specific rooms, and include notes. Users should be able to manage multi-story buildings by adding floors and uploading additional floorplans. The final output will be an XLS file containing all the ...

...If you love to create problems to every solution. If you do not know what WooCommerce is. If you do not know how to work with CSS, XLS. If you never work with file where you have hundred columns with multiple data set. If you do not like to analise data and rather you think that always better before you familarise with data. If you want to tell as what we need rather than do what is in specification. BID if you: You like to find solution and you enjoy intelectualy demending work. Feel confident in everyday promting CHAT GPT. You understand CRYPTOGRAPHY on level enough good that you can ENCRYPT and CRYPT data. You know waht fromat tile are... XLS / ODS / CSS. You keep information 100% Confidential and agree to sign NDA. You can propose better solution than i...

I'm lo...me. The app will fetch data from a server using Elasticsearch and present it to users through an advanced search interface. Key Requirements: - Proficiency in Ruby on Rails with proven experience in developing web apps. - Familiarity with Hotwire and Stimulus for creating reactive user interfaces. - Experience with TailWind for responsive and aesthetically pleasing UI design. - Knowledge of Postgres for database management. - Expertise in API integration and development. The app should feature: - An advanced filter system for the search interface, going beyond a simple search bar. - Filters based on categories. Ideal candidate would have a strong background in full-stack development, with a keen eye for detail and a passion for creating user-friendly, efficient we...

My project is currently mid-development and requires an experienced freelancer proficient in server setup, code review, and API development. The project utilizes async FastAPI with Pydantic for data validation and Postgres as the database. Key Responsibilities: - Set up and configure the server on IONOS Plesk - Conduct thorough code review and improvements - Develop additional APIs for the admin panel and front-end Ideal Skills: - Extensive experience with FastAPI, Pydantic, and Postgres - Proficiency in Docker and Nginx - Strong skills in server setup and configuration - Excellent code review and improvement capabilities - API development experience This will be a long-term project requiring consistent collaboration and progressive improvements and additions to the system...

I need SCRAP whole website I need data in XLS. ALL DATA! According to every reviewed webiste witch one have at last one review. I need at last Columns: DOMAIN NAME / LINK TO TRUSPILOT DOMAIN/ HOW MANY REVIEWS? / TOTAL RANK / ALL REVIEWES COLLECTED IN SYPARATED FORUM AS NAME NICK REVIEW ETC

I'm in need of a skilled web developer to create a company information ATS through web pages. This ATS will be key in communicating our brand and services to potential clients and partners. Key requirements include: - Developing a clean, user-friendly interface - Incorporating essential pages of HR Module of ATS . Typically this inhouse ATS development with laravel and postgres SQL with min level . We already have model . Need someone who can develop pages with clean workflow and incorporating AI/ML with resume parsing as well. This ATS will be hosted in our local server and we do have other modules to develop. Company looking for suitable developer on this project and high chances to become permanent software solutions vendor upon the successful deployment of this project...

I'm looking for a freelancer who can identify and gathe...companies. These companies are primarily Architects, Engineers, or General Contractors. The information needed for each company includes: - Company type - Main office location - Website Please note that I'm only interested in the basic information and not the detailed services or specialties of these companies. You are free to use ChatGPT or other AI tools to assist in this task. Format - XLS - per the attached based upon the column headings. I have provided sample data within the Ideal skills for this job include data collection, web research, and familiarity with AI tools. Experience in the construction or design industries would be a plus. Wish me a happy birthday to show that you read this or at least ...

...in the process of developing a cloud-based Minimum Viable Product (MVP) and am seeking a skilled Backend Developer to develop a robust backend for managing CT scan uploads, AI processing, and data storage. Key Responsibilities: - Set up a reliable Cloud Storage Service, particularly using AWS S3. - On AWS, set up and configure the backend using Python/Django or Node.js, integrating with a Postgres database. -Implement user authentication and secure access to XNAT using OAuth or similar. - Create API endpoints for managing CT scan uploads, interactions with XNAT, and storing data in the database. - Optimize for scalability, preparing for future expansion where multiple hospitals can use the platform. Optional -Integrate with 3D Slicer to handle medical imaging data, f...

I am seeking an expert to resolve an issue I'm experiencing with my Nextcloud and Postgres setup in Docker. The error occurs during the database initialization process. The error message reads: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for table oc_migrations. I have already attempted some troubleshooting, specifically checking user permissions, but the problem persists. Ideal Skills: - Proficiency in Docker, Nextcloud, and Postgres - Strong ability in troubleshooting database issues - Experience in managing user permissions in Postgres Please provide your strategy for diagnosing and fixing the issue in your proposal.

...parents can enter their child’s details, and an automated process for sending confirmation emails and generating documents. Below are the key requirements: Key Features: - A user-friendly, drag-and-drop form builder for creating customized user and admin forms - An automated email system sending out registration confirmations and event notifications - The ability to generate reports in PDF and XLS formats - Inclusion of custom fields in forms - A terms page with a privacy checkbox - A survey creation tool - An anonymous feedback form Presentation (Main Page): - The homepage will introduce the club and its activities. This is a simple static page. 2. Student Registration Page: - A form where parents can enter essential information such as: First Nam...

I'm looking for an experienced API developer to help me fetch data from an API and save it to a CSV file. - Data Type: The specific data type to be fetched from the API has not been determined yet, so flexibility and adaptability are key. - Data Format: The fetched data needs to be put into a CSV format. - Data Fetch Frequency: This is yet to be decided, but it could range from real-time to daily. Ideal Skills: - Proficiency in working with APIs - Strong programming skills (Python, JavaScript, etc.) - Experience in data manipulation and CSV file creation Please provide examples of similar projects you've worked on in the past. Thank you.

I'm in need of a Postgres expert who can help me recover my Postgres database from Docker. The selected freelancer will also need to create a DB dump for future use. Ideal Skills: - Extensive experience with PostgreSQL. - Proficient in Docker. - Skilled in creating database dumps. Experience in troubleshooting Docker-related issues will be highly valued.

I have backups of the docker volumes. my primary docker machine is corrupted. so if i put these volumes directly to the machine this is not being detected by the containers are they have created their own volumes new. this is because the docker volumes are named with random strings. i want someone to help me get this docker containers linked to the volumes or take the volumes and give me the postgres db dump so that i can re import these data. there are 2 such db to be extracted. Key Details: - I currently have access to the Docker volumes. - The PostgreSQL version is not specified, but the freelancer should be comfortable working with multiple versions. - The Docker container is currently in a running state. Ideal Skills: - Extensive experience with PostgreSQL. - Proficient in Do...

I need a freelancer to parse my timeclock data from an xls file downloaded from the Microsoft Shifts application. Tasks: -Summarize daily and for the specified period: -Summarize total hours worked -Calculate and summarize total regular hours worked -Calculate and summarize overtime -List days in period that were not worked The output should be formatted as: - Tables - By employee The analysis should be conducted on a: - Specified date range Ideal candidates should be proficient in Excel, have experience with data analysis, and can present data in a clear and organized manner.

Requirement Document: Vehicle Tracking and Trip Management System Overview This document outlines the core features and entities required for a Vehicle Tracking and Trip Management System, aimed at enabling business owners to manage their fleet, track vehicle movements, and schedule trips effectively. The system is divided into two main parts: Admin (Mobile + Web) and Driver (Mobile), with a strong preference for cross-platform development. Core Features 1. Vehicle Tracking & Trip Status ○ Description: Business owners can track vehicles in real-time and monitor the status of each trip (e.g., in-progress, completed). ○ Platform: Admin (Mobile + Web). ○ User Interaction: Business owners view vehicle locations and trip statuses on the dashboard. 2. Driver Updates ○ Description: Drivers c...

...concerning cash flow. I am encountering inconsistencies with my SUMPRODUCT formula across different sheets. The key requirements for this job include: - Skill in Excel, particularly with debugging formulas. - Experience with financial statements and trackers. - Ability to identify and rectify issues with data inputs across multiple sheets. Input will be financial statements in Microsoft Excel format (XLS/XLSX). The output expected is to debug formulas that are not working. I am using SUMPRODUCT, which works for a few financial statements but not for a few institutions. I suspect these are data type errors (number formats). I need help resolving these. I do not need any new automation or formulas to be created. If you can help optimise the workflow, I will understand and pay for...

I am experiencing high write IOPS on one of my AWS Aurora Postgres instances, and I need help resolving this issue. Despite having an index on a specific query, this instance is utilizing between 18,000 to 25,000 write IOPS with a response time of 163 milliseconds. Key Points: - The queries running on this instance are primarily read-heavy. - My biggest concern is the query execution time. - There have been no recent changes to the database configuration or schema Your expertise in AWS Aurora, Postgres, database optimization, and performance tuning will be crucial for this project. I am aiming for a significant reduction in write IOPS and an overall improvement in query execution time.

...looking for an experienced Full Stack Developer to help with task-based enhancements on my existing platform. The platform is built with React on the front-end and Node.js on the back-end, with a Postgres database. You will be required to add and modify existing code, enhance features, and improve security. Key Enhancements: - Data Analytics: Specifically focusing on performance metrics. - Security: Implementing data encryption and conducting regular security audits. - General Features: Enhancing and adding new features to the platform. Ideal Skills: - Extensive experience with React, Node.js, and Postgres. - Strong knowledge in full stack development. - Proficiency in data analytics and visualization tools. - Solid understanding of security measures and protocols. - Exp...

Search: The script could be set to search the web for example rental car websites in Greece, or hotels in greece using a search engine API maybe (like Google Search API & Bing API or Google M...want to be able to give me a specific link and search again. Web Scraping: Once it finds the list of potential rental car websites, the script can visit each URL and scrape contact information, such as links, emails, phone numbers, city, adress. Data Extraction: Using techniques such as regular expressions, the script can identify and extract emails and phone numbers from the HTML content to an xls. Storing the Data: Instead of storing the data in an Excel file, the script can output the contact information directly in the console or save it in a database, text file, or any other form...

I have several BI files with queries from an E-SUS application that were originally designed for Postgres. I need these queries and data manipulation scripts adjusted to work in an Oracle environment instead. Specifics: - You will be adapting data manipulation scripts and making specific adjustments to queries so they can interact with an Oracle database. - The scripts do not include any particular data types or functions specific to Postgres, so your focus will primarily be on the adaptation of the queries and scripts. Please note that while some basic indexing is used in the current Postgres queries, no extensive indexing or performance optimization techniques have been implemented. Your task will also involve ensuring that the adapted scripts maintain an acceptabl...