Write code transfer data sql server excelроботи
...an already existing data import script (see ). The steps needed to import the data consist of: - Setup the necessary tables for the import to work (I already provide you with the postgres init script, see ) - Downloading/fetching the large ±24GB .JSONL data dump - Importing and converting this single .JSONL-dump into two postgres tables running in a docker container Requirements: - The resulting tables should be exactly the same as when you run the original import script. - The import time should be significantly reduced compared to the import time of the original import script using the same hardware requirements. - It should be easy to run everything: clearly document how to run it How you achieve this is completely up to you (Bash + SQL, pure ...
I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dyna...
El objetivo principal del Dashboard es monitorear el avance y control de la etapa de preparación de diversas obras públicas, incluyendo el seguimiento de entregables, plazos, presupuesto, riesgos y adquisición de recursos, todo ello en EXCEL. El Dashboard es clave para controlar los avances de múltiples obras, asegurando que el presupuesto no se exceda, que los plazos se respeten y que los recursos (personales y materiales) estén disponibles a tiempo. La toma de decisiones debe ser ágil y basada en datos claros, por lo que los indicadores y las alertas deben estar configurados para resaltar cualquier problema (retrasos, sobrecostos, falta de recursos). Cuento con el alcance y datos claves que deberia tener el dashboard. Contactarme al +*5*1...
Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.
I'm currently developing an iOS app that leverages the Screentime API and Family Controls. This app involves tracking usage, implementing parental controls, and setting up app restrictions. I'm seeking a seasoned Swift developer who can help troubleshoot coding issues and assist with the setup of specific code segments on a pay-per-query basis. Key Areas of Focus: - Usage tracking: I need guidance on how to implement this feature and help troubleshooting any issues that arise. - Parental controls: I require assistance with feature implementation and bug fixing. - App restrictions: I'm looking for an expert to help optimize performance and address any potential coding issues. Ideal Candidate: - You must be an expert in Swift, with extensive experience in Xcode and iO...
...labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be accurate and verified. • We ex...
I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly
I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.
I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable
I'm seeking a skilled professional to assist me with my Coinbase Wallet. I have Bitcoin (BTC) in my account, and I need to transfer it all to another wallet I will provide. Key Tasks: - Assist with the API setup for automated transactions - Ensure a smooth and secure transfer of funds - Provide guidance on best practices for crypto transactions Ideal Experience: - Extensive knowledge of Coinbase Wallet - Proven experience with Bitcoin transactions - API setup and automation expertise - Strong emphasis on security and best practices in crypto management
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...
I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.
I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Ability to create...
I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.
I'm looking for an Excel expert who can help me automate my spreadsheets to reduce manual data entry, specifically dealing with financial data. The ideal freelancer for this job should have extensive experience in Excel, particularly in spreadsheet automation. Skills in handling financial data and creating efficient solutions to streamline processes are a plus. Please include your relevant experience in your bid.
I need a compelling write-up for my MLK event. The write-up should be engaging and appropriately capture the essence of the event. The ideal freelancer for this task should have proficient writing skills, with a knack for creating captivating content. Experience in event write-ups and a strong understanding of the significance of MLK events will be an advantage.
I'm in need of a skilled developer to write some basic Deluge code for my Zoho CRM. The tasks are varied and include finding records in lookup fields, performing calculations on multiple related modules, and automating workflows. Ideal candidates should have: - Proficiency in Deluge scripting. - Extensive experience with Zoho CRM. - Strong problem-solving skills. - Ability to write clean and efficient code. Please note, this project is primarily focused on writing new code, rather than debugging existing code.
...efficiency and productivity. - Facilitate improved tracking and reporting of our financials through Zoho Books. - Optimize our project management processes through Zoho Projects. Data Migration: - I have existing data from excel on customers and past histrorical data that needs to be migrated from another accounting software to Zoho Books. This includes financial records, customer data, and project history. Ideal Skills: - Proven experience in Zoho One implementation and integration. - Proficiency in Zoho CRM, Zoho Books, and Zoho Projects. - Strong understanding of financial tracking and reporting. - Experience in data migration from accounting software. - Excellent project management skills. I am looking for a professional who can help us...
ChatBot Nicolas F. has sent a quote Script to send btc Quote amount: $20.00 USD Valid Until: 25 Feb 2025
I'm looking for an experienced data analyst who excels in working with Excel spreadsheets. Your primary tasks will involve: - Data entry and formatting: I have a substantial amount of data that needs to be inputted and formatted correctly in Excel. - Data analysis: Once the data is properly formatted, you'll be responsible for analyzing it in Excel. The ideal candidate will have: - Proficiency in Excel, including advanced functions and formulas - Strong skills in statistical analysis - Attention to detail to ensure data accuracy - Ability to meet deadlines If you're up for the challenge, I'd love to hear from you!
I need a straightforward Excel sheet that helps me calculate my monthly expenses. I want to be able to input daily amounts and have them total automatically. Expenses to Track: - Material - Invoices - Tools - Gas - Other - W9 - Cash - Cows Key Requirements: - The Excel sheet should be organized for daily entries with a monthly total - No charts or visual aids are required, just a simple, functional design Ideal skills for this project include: - Proficiency in Excel - Experience in creating user-friendly spreadsheets - Ability to understand and cater to specific data tracking needs
...by connecting multiple data sources, deploying AI-powered agents, and scaling operations efficiently. This platform allows businesses to automate complex tasks, integrate various databases, and manage AI-driven workflows seamlessly. 2. Key Features & Functionalities A. Workflow Creation & Management Drag-and-drop or code-based workflow creation Pre-built workflow templates Support for multiple data sources (SQL, NoSQL, APIs, CSV, JSON, etc.) Event-driven triggers for automation Conditional logic and branching B. AI Agent Deployment AI-powered decision-making capabilities Natural Language Processing (NLP) integration Machine Learning (ML) model integration Custom agent scripting Real-time monitoring and logging C. Database & API Connectivity Secur...
I need expert assistance to set up and manage my MySQL database on a Windows server. Specific Tasks: - I have MySQL installed. I have several very large files I want to import, but MySQL is telling me they are to large - Database Optimization: Once imported I want the database set up in a certain way - Generally need advice on how to update the database - Report generation: I need specific reports generated . I'm not sure the best tool to do this but maybe excel? I'd like to form an ongoing relationship with an expert to help me develop the database and reports over time.
I'm seeking an experienced data engineer for a project focused on building and managing a data warehouse using Amazon Redshift. Key Responsibilities: - Design and implement a comprehensive data warehouse on Amazon Redshift. - Work on optimizing the performance of the warehouse. - Able to potentially integrate various data sources in the future. Ideal Skills: - Proficient in Amazon Redshift. - Strong background in data warehousing concepts. - Experience with performance tuning of data warehouses. - Knowledge of various data source types (Relational databases, NoSQL databases, CSV/Excel files). Please note that the integration of diverse data sources is a potential future requirement, so having the skills and experience ...
...platforms. Here are the job details: Project Requirements: Creation of the Token on the Solana Network: Development of a custom SPL (Solana standard) token. Initial configuration of the token, including issuance and total supply. Custom Smart Contracts: Implementation of smart contracts that include specific functionalities, such as: Restricting the sale of the token for a period of 90 days. Transfer control with custom rules. Integration with Wallets and DEX: Integration of the token with popular wallets, such as Phantom, Solflare and other compatible wallets. Addition of the token to decentralized exchanges, such as Uniswap (if using a bridge to Ethereum) or PancakeSwap (if using a bridge to BSC). Ensure token compatibility and functionality on DEXs for exchanges and future...
I'm seeking a seasoned ghostwriter to help me pen my life story, focusing on my unique journey with mental health disabilities, autism, cPTSD, my time in the military, experiences with homelessness, and my journey through marriage. Key Aspects: - This is a biography project, detailing my personal experiences and struggles. - The book should encapsulate the depth of these experiences, their nuances, and their impact on my life. - It should be written in an engaging, relatable manner that resonates with readers. Ideal Skills and Experience: - Proven experience in ghostwriting, particularly in the biography genre. - Empathy and understanding of mental health issues. - Ability to translate complex life experiences into compelling narrative. - Military background or understanding prefer...
I'm currently facing an issue with my Windows Server 2022. I am unable to access the server with my user credentials, encountering a message indicating that the number of connections to this computer is limited when trying to connect via Remote Desktop. The message error is: the number of connections to this computer is limited and all connection are in use right now. The ideal freelancer for this job should have: - Proficiency in Windows Server 2022 troubleshooting. - Experience with Remote Desktop Protocol (RDP). - A strong understanding of server connection limitations. - Ability to provide a swift resolution to restore access.
I'm looking for an experienced app developer to create a decentralized wallet app for both iOS and Android platforms. The app should support cryptocurrency storage, peer-to-peer transfers, and transaction history. It should be compatible with Bitcoin, Ethereum, and USDT. Key Requirements: - Proven experience in developing de...platforms. The app should support cryptocurrency storage, peer-to-peer transfers, and transaction history. It should be compatible with Bitcoin, Ethereum, and USDT. Key Requirements: - Proven experience in developing decentralized wallet apps - Proficiency in iOS and Android app development - Understanding of cryptocurrency and blockchain technology - Ability to implement secure peer-to-peer transfer features - Skills in creating comprehensive transacti...
I need assistance with combining 1-2 Excel documents for the purpose of archiving. Ideal Skills and Experience: - Proficiency in Excel - Attention to detail - Data management skills
I need a comprehensive Excel-based ERP application that focuses primarily on Financial Management. This mini-ERP should help me manage my processes, see projections, and calculate finances seamlessly. Key features of this Excel Dashboard should include: - Real-time tracking of income, expenses, and cash flow. - Advanced income and expense categorization and tracking (e.g., specific projects, departments). - Trend analysis and forecasting capabilities. - Automatic bank reconciliation with accounting records. I require a professional who has: - Proficient Excel skills and experience in creating ERP applications. - Strong understanding of financial management principles. - Ability to incorporate advanced tracking and forecasting features. Please note, while Financial ...
Buscamos un par freelancers para la creación de una base de datos de clientes potenciales. El trabajo consiste en: Extraer información de clientes desde una plataforma específica. Investigar y encontrar el correo de la persona de contacto. Si no se encuentra el correo de la persona, buscar el correo general de la empresa. Organizar la información en un Excel compartido Se paga €2 a €3 la hora. Y se requiere poder empezar directamente.
We are looking for an experienced WordPress developer to create a website template for our airport transfer company. The template should be built exclusively using the Gutenberg editor and Kadence Blocks plugin, ensuring a clean and efficient design. We will handle the insertion of all content, including text and images, after the template is completed. Required Pages: Home - About Us - Services - Contact - FAQ - Blog Home Page Sections: 1- Hero Image 2- Why Choose Us? (4 icons) 3- Our Fleet (4 vehicles) 4- How It Works (4 steps) 5- Our Best Services (3 columns) 6- Blog Articles (3 posts) 7- Testimonials The template must be fully responsive and optimized for SEO. Design should be clean, modern, and user-friendly. No additional plugins or custom coding should be used; the design...
I need a comprehensive HTML help file for our bespoke software application. It should include a complete description of the code and its workings, detailed on a function-by-function basis. Ideal skills: - Proficient in HTML - Experience with technical writing and creating in-depth help files - An understanding of software code and the ability to explain it in an accessible way
...I'm pleased to share the quotation for the in-place upgrade of your Domain Controller (DC) and Remote Desktop Services (RDS) Server from Windows Server 2012 to Windows Server 2025. This upgrade will ensure your infrastructure stays current, secure, and fully supported. Scope of Services: Pre-upgrade assessment to verify system compatibility and readiness for the upgrade. Full system backup to ensure the protection of data and configurations before upgrading. In-place upgrade of the Domain Controller (DC) and RDS from Windows Server 2012 to Windows Server 2025. Installation and configuration of Remote Desktop Services Client Access Licenses (RDS CALs) for Windows Server 2025. Post-upgrade validation to ensure all services are funct...
...proficient Excel macro developer who can automate a series of tasks for me. The primary objectives include: - Data Cleaning: Streamlining and organizing data to enhance its quality and usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases...
I'm looking for a professional who can help me transfer my Wix website design to WordPress. The goal is to maintain the same design from Wix on the new platform. Key Requirements: - Expertise in both Wix and WordPress - Ability to replicate a design precisely - Experience in selecting appropriate WordPress themes
Need to Transfer the Website and make some changes and making all the Mails Id HTML WEBSITE DESIGN WORDPRESS
...base de datos. - Definir el stack tecnológico ### **Requisitos:** - Experiencia 7+años en diseño y desarrollo de bases de datos, preferentemente para e-commerce o marketplaces. - debe demostrar su experiencia - Sólidos conocimientos en bases de datos relacionales (SQL) y no relacionales (NoSQL). - Competencia en herramientas de modelado de datos como Lucidchart, ER/Studio o similares. - Experiencia con sistemas de gestión de bases de datos (DBMS) como MySQL, PostgreSQL, MongoDB. - Familiaridad con entornos de desarrollo como SQL Developer, DBeaver, etc. - Alta capacidad para la resolución de problemas y atención al detalle. - Excelente comunicación y habilidades interpersonales. - Conocimiento del mercado automotriz...
I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue ...
I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data valida...
I need a freelancer who can help me to create a bill from an Excel sheet and convert it into both an Excel file and a PDF. Ideal skills and experience for the job: - Proficiency with Excel - Experience with creating bills - Knowledge of PDF conversion - Attention to detail - Ability to meet deadlines
I need a skilled freelancer to assist in customising my mobile app source code. The app is designed for both iOS and Android platforms. The specific tasks involve identifying and fixing bugs along with implementing improvements to enhance the app's overall performance and user experience. Ideal candidates should have: - Extensive experience in mobile app code customisation - Proficiency in both iOS and Android platforms - Strong debugging and problem-solving skills - Ability to implement improvements based on user feedback and performance metrics
Project Overview We are seeking an experienced PHP developer to complete essential bug fixes, feature implementations, and integrations for and MappingCrimesJr. Our system is a crime mapping and analytics platform that provides users with real-time crime data. This project will be a fixed contract for $1,000 over 1 month. We require strong PHP, MySQL, JavaScript, and API integration experience, with a preference for developers experienced in security and crime-related data applications. --- Project Scope & Deliverables 1. Bug Fixes (High Priority) ✅ Fix CSV Upload Failure – Ensure crime articles are properly uploaded and stored via CSV. ✅ Fix Crime Category Assignment – Ensure crime reports are correctly classified. ✅ Fix Location Parsing – Ensur...
I need a freelancer to migrate my website from Squarespace to WordPress. The primary goal of this move is to achieve improved design flexibility. At this stage, I'm not looking for ...website from Squarespace to WordPress. The primary goal of this move is to achieve improved design flexibility. At this stage, I'm not looking for any specific design changes on WordPress, just a basic transfer. I'll select the theme later. I have the export file form squarespace. The content that needs to be transferred includes: - Text and pages - Images and galleries Ideal candidates for this project should have: - Proven experience in website migration, specifically from Squarespace to WordPress - Understanding of both Squarespace and WordPress platforms - Ability to handle cont...
I have a WhatsApp chatbot and CRM script from CODE CANYON. I need a tech-savvy assistant who will help me with the following: -WHATSAPP API - API CONFIGURATIONS - HANDLUNG BUGS
...(Generative Adversarial Networks). Expertise in image segmentation, style transfer, and object detection. Cloud Technologies and Scalability: Hosting experience on AWS, Google Cloud, or Azure. Utilizing cloud-based GPUs (e.g., NVIDIA Tesla or A100). Building scalable systems with Docker and Kubernetes. 2. Project Management and Communication Familiarity with project management tools like Jira, Trello, or Asana. Regular communication (weekly meetings and progress reports). Code sharing through GitHub or GitLab. System Features User Panel: User login and registration. Image upload with drag-and-drop functionality. Real-time preview and editing. AI-Powered Features: Background removal. Model styling and outfit changing (style transfer). Image filters and enhancemen...
Hello! I just need simple excel sheet work in under 5 hours!
I need a server application that processes images of documents automatically captured from both mobile and desktop client applications. This application will classify, read data from and verify the authenticity of various documents, including Driving Licenses, Passports, and Identity Cards. Key Features: - Image processing and classification - Data extraction from documents (e.g. names, surnames, ID numbers) - Authenticity verification through image comparison with trained models of real and fake documents Ideal Skills and Experience: - Proficiency in server application development - Experience with API integration - Knowledge in image processing and machine learning - Skills in developing client-server applications for both mobile and desktop platforms...
Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work
