Synchronize excel sql databasedela

...options trading system implemented through an Excel sheet. This tool will execute real-time data trade operations, following a specific strategy. Ideal Skills and Experience: - Proficient in Python programming - Experience in Stock Market trading systems - Knowledge of Excel VBA and integrating with Python - Understanding of Custom Trading View Indicator strategy The work involves: - Engaging in the end-to-end development of the Excel system. - Coding a Python script to fetch and populate real-time trading data. - Implementing the Custom Trading View Indicator strategy in the Python script. - Testing the system to ensure the accuracy and efficiency of the trading. Please note, I don't have an existing Excel sheet for this trading system. The new ...

I am in need of a freelancer well-acquainted with data entry for translating text data into a usable Excel spreadsheeet. Key Requirements: - Proficiency in text data entry - Experience working with a diverse range of project types - Skilled in Excel, especially formatting and data organization Your task will be to translate the original data (which could be a PDF file, printed hardcopies, handwritten notes, or a different format depending on the project) into neat, easy-to-read Excel spreadsheets. Prior experience with Excel and other similar tasks will be crucial for completing this project accurately and efficiently.

I'm in need of a professional proficient in Excel macros to assist with creating custom formulas specifically for data manipulation. The primary task would be to formulate macros that can effectively merge and separate data. Demonstrable experience in managing large datasets and solid knowledge in automated data manipulation will be essential for successful completion of the project. A background in eliminating duplications or inconsistencies would also be advantageous. I look forward to a hassle-free process and accurate results.

I'm seeking a professional with extensive Excel experience who can help convert data from a spreadsheet into a more user-friendly form. Here are the key elements for this project: - Autofilling: The form should make use of specific criteria for autofilling using text. Your proficiency in creating autofill functionality is crucial. - Conditional Formatting: I require a unique approach to formatting cells containing more than one line of text. Specifically, if a cell has multiple line items, they should be combined in the same cell but placed underneath each other. - File Format: The data to be converted resides in an Excel spreadsheet, therefore your familiarity with Excel is paramount. This task requires not only technical skills in Excel but also an ey...

...you an Microsoft Excel or Libre Calc file of all of the data in its fields that I can work with. Ideal professionals for this task should: - Have proven experience with Quickbooks, especially old/legacy versions - Be familiar with potential issues of opening older Quickbooks files using newer versions - Be able to ensure that data integrity is maintained throughout the process To show you're up for the task, you should: - Provide descriptions of past work where you've tackled similar situations - Provide confidence that you can access and retrieve the data if none of the passwords provided works to open the file. Be prepared to suggest the best and safest method to access this 2009 Quickbooks financial data and provide a Reckon Accounts Pro 2013 file and an Libre Ca...

I am in need of an experienced data entry specialist who can assist me with entering basic data into Excel. The data to be entered will be from handwritten notes. Ideal skills and experience for the job: - Proficient in Excel for basic data entry and formatting - Detail-oriented with high accuracy in entering data - Ability to work with handwritten notes - Good communication skills to clarify data points if needed

More details: ¿Qué tipo de datos desearía cargar desde SQL Server a Sharepoint List? Datos de ventas ¿Con qué frecuencia necesita actualizar los datos en Sharepoint List? Diariamente ¿Desea incluir alguna funcionalidad de automatización o alertas cuando se actualicen los datos? Actualización automática de datos

I am looking for a professional Omniscript developer with a keen eye for aligning with existing designs, to build a single web page. My design is ready and I need you to transform it into reality effectively. Functionalities Included: - The key functionality required is Form submission. Special Features: - Not only should the form be functional but also integrated with a database for maintaining records of submissions. Skills and Experience: - Strong practical experience with Omniscript is mandatory. - Proficiency in working with databases is vital. - A deep understanding of form design and integration is needed. - Previous projects in which you have successfully executed existing designs are valued. Let's build one robust, seamlessly designed, data-integrated page togethe...

I'm in need of someone adept in bookkeeping, expense tracking, and financial reporting. You don't have to have experience in a specific software, but being proficient in tools like QuickBooks, Excel, and Xero would be ideal. I need the Account Assistant to handle: - Bookkeeping - Expense Tracking - Financial Reporting In your proposal, please include: - Details of your past work and experience in similar roles - A detailed project proposal outlining how you'll carry out the tasks I'm excited to hear from you, and start working together on this project.

I am aiming to establish a comprehensive database of 10,000 small businesses in home services across the US's major cities. The target includes plumbing services, cleaning services, roofing, HVAC, handyman, fencing, landscaping, and water heaters businesses. The purpose of this database is for a cold calling campaign. 1 New York 8,550,405 2 Los Angeles 3,971,883 3 Chicago 2,720,546 4 Houston 2,296,224 5 Philadelphia 1,567,442 6 Phoenix 1,563,025 7 San Antonio 1,469,845 8 San Diego 1,394,928 9 Dallas 1,300,092 10 San Jose 1,026,908 11 Austin 931,830 12 Jacksonville 868,031 13 San Francisco 864,816 14 Indianapolis 853,173 15 Columbus 850,106 16 Fort Worth 833,319 17 Charlotte 827,097 18 Seattle 684,451 19 Denver 682,545 20 El Paso 681,124 21 Detroit 677,116 22 Washington ...

I am in search of a seasoned data analyst who will perform a comprehensive analysis on a large Excel dataset, with more than 10,000 rows. The range of tasks to be undertaken includes: - Data Cleaning: Ensuring the data quality, eliminating any errors or redundancies. - Data Visualization: Creating intuitive charts and graphs to illustrate the data trends and patterns. - Statistical Analysis: Implementing statistical methods like Regression Analysis, Time Series Analysis, and Hypothesis Testing to interpret the data and draw conclusions. This demands a great deal of experience in Excel, data cleaning, statistical analysis, as well as in working with large datasets. A solid understanding of regression analysis, time series analysis, and hypothesis testing is strongly requir...

I'd like to request a quote for "$50 GPS Mapping for MHJ excel file attached". My budget is $30 - 250AUD.

I require an expert in Excel macros that can help me with a specific task. I have numerous .dl files from which I need certain sections of text extracted. Here's what I need: - Development of a reliable Excel macro that can accurately identify and extract the necessary data from .dl files. - The macro should be robust enough to handle any inconsistencies or errors within the .dl files. In the event of an issue, rather than stopping entirely or skipping the file, the macro should create a log file noting the inconsistency or error for later review. Ideal skills: - Experience in Excel macro development - Familiarity with .dl file structure - Attention to detail - Problem-solving skills, particularly regarding file inconsistencies or errors - A background in da...

Hello, 1: you will create aspx webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store tho...webpage, and load data from mssql table to gridview with paging. 2: when user check some checkboxes, and enter value in textboxes and click on a button, it will store those values in session and save in database table. 3: when user enter some values in page 1 or anyother page and go to next page like page#2 and come back to page#1, the values he entered must show and not loss. Note: has the gridlayout. ischecked and grosspremium are editable checkbox and textbox I included the vb code as well in endorsements-vb The datasource contains 86 rows and attached as excel.

...si/COBISS/bibliografije/ Your job is to find a contact email address or/and online form for authors to submit a book proposal for each of the publishers on the list. Most of them have an online form. Get the www link. For each of them, get a contact email address. If there is no email address for authors, get some other general contact email address of the press. You will submit an Excel file with three columns: name of the publisher, email, www link with a form (if there is an online form). In this list I provided, for some publushers there are two names (left and right) or more than two names (one left and several right). In these cases of multiple names, you just need to do it for one name/publisher, not more. If one of the few names has a word “press” in it,...

I have python script to copy title and keywords from excel sheet to image metadata , I need to add category to subject filed and price to comment filed so excel sheet will be title , keywords , category , price , data will be copied to image metadata

We have a quick project for a Google Sheets / Excel Expert We have a Google Sheet that we need to filter and match customer names up to a sales rep. Essentially it needs to work like this: - Master customer data will go in sheet 1. This contains a list of customer names in column 1, and the corresponding sales rep in column 2. - Each week, we create a new sheet with payment data. - The payment data contains the payment and customer name. - we need the filter to match the customer name in the new sheet with the rep and insert the sales rep name in a new column. This will probably need to be done with a scrip - we need a proficient and experienced person to do this. If you have the experience, please message and I'll give you a loom video explaining fully and showing the do...

I am urgently in need of an expert to assist me with a set of complex electrical circuit problems. Your task would be to: - Solve higher order ODE circuit problems - Assist with convolution problems - Tackle Laplace transfer issues The successful accomplishment of this project will result in: - Finding the transfer function - Analyzing the frequency response - S...Analyzing the frequency response - Solving for the circuit variables This project requires a great understanding of electrical engineering principles, particularly, higher order ODE, convolution problems, and Laplace transfer. Proficiency in complex problem-solving under limited time conditions is an added advantage. I need this job completed ASAP. If this sounds like the kind of project that you'd excel at, pleas...

I am in need of a skilled Bookkeeper with a sound understanding of quotes, POs, and invoices. I require 2 hours of these services everyday to maintain and organize my financial records. I currently manage my accounts using Excel, so ability to work with it effectively is key. Key Tasks: - Maintain financial transactions - Manage and update financial records Ideal Skills: - Proven track record in bookkeeping - Familiarity with technology sector taxes - Proficient in Excel - Great attention to detail and accuracy. Experience working in a similar role within the technology sector would be highly beneficial. If you have the necessary skills and experience, I look forward to receiving your proposal.

Changes to excel

I need an expert in SQL, Python, Tableau to undertake data analysis project on less than 1GB of categorical data. The main requirements of the job include: - Proficiency in Python, SQL, Jupyter, Spyder, and Tableau recommended - Strong background in data analysis, regression, and machine learning - Experience working with categorical data specifically - See for details The chosen freelancer should be able to analyze and interpret the data in a way that can drive actionable insights. While the data set is not overly large, accuracy and attention to detail are paramount. Previous experience working on similar projects is highly desirable.

Se dedesa crear una pagina front + backend para asistente interno. En el front end se cargaran diferentes archivos (TXT, PDF, WORD, EXCEL en lo posible) con lo que llamaremos BASES DE CONOCIMIENTO pueden ser listas de precios, condiciones comerciales, etc con los que CHATGPT se puede conectar y consutlar via API y responder a los usuarios. Se aceptan sugerencias para este desarrollo o similar. Si tienen algo parecido para testear con gusto lo haremos. Se debe poder replicar en otras webs para armar diferentes chats con bases de conocimiento especificos.

...to monitor our stock levels and analyze our order trends effectively. Ideally, freelancers would have prior experience in web application development, with a particular emphasis on order and inventory management solutions. Some knowledge of CSV file manipulation and report generation would be a definite plus. Major Task which we need to accomplish with this system. 1- Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/not avaiable, when avaiable with dates) etc. 3- Genarate procurement orders sheet to market 4- Genarate adress sheet to feed into shipping software 5- Upload shipping software sheet into system. 6- generate order sheet with tracking number to feed into external system. 7- Should be able to view pending, fullfillment orders on ...

Enterprise Data Architect Level III Clearance: TS (preferred) Software: Databrink and Palantir Timeframe: 40hrs / week - 3 month contract with possible extension Purpose of the Job: The Enterprise Data Architect is responsible for setting the strategy for the EPMs’s data architecture and providing technical architecture direction for delivery of the target state. This person is an integral member of the Enterprise Architecture Team and will be responsible for the design and implementation of the enterprise-wide data strategy, ensuring the strategy supports the current and future business needs. They will apply their knowledge of good architecture practice, architecture documentation and data technologies to comprehensively capture the bank’s current state holistic data ar...

Enterprise Data Architect Level III Clearance: TS (preferred) Purpose of the Job: The Enterprise Data Architect is responsible for setting the strategy for the EPMs’s data architecture and providing technical architecture direction for delivery of the target state. This person is an integral member of the Enterprise Architecture Team and will be responsible for the design and implementation of the enterprise-wide data strategy, ensuring the strategy supports the current and future business needs. They will apply their knowledge of good architecture practice, architecture documentation and data technologies to comprehensively capture the bank’s current state holistic data architecture and oversee target state design and implementation. The role will involve collaborating with...

Consolidated Sales Calendar report put in excel spread sheet.

More details: Small Business Beauty Salon excel program required Inventory management: Track products in stock, Set reorder points for products, Generate purchase orders Point of Sale (POS): Cash, Credit/Debit cards, Mobile payments for Retail products [GST&PST] and services Daily Reports: Sales report, Inventory report, Employee productivity report Client management: History records or services done with client details and specification Employee management: Information; Timesheets; Vacation Payroll: Run semi-monthly payroll with hourly rate vs commission rate [Canadian payroll information] Salon supplies: Calculate and track supplies used during services to add to POS on checkout Schedule: Appointment schedule for clients with ability to send reminders.

...skilled professional to create an Excel workbook that provides user-specific access control. Unfortunately, I am unable to provide specifics about the type of access control, so flexibility and adaptability will be crucial for this project. Freelancers interested in this project should: - Demonstrate proven experience in Excel, particularly working with workbook-level protections and user access controls. - Have a strong background in data analysis, as this will be a key function of the workbook. Primary responsibilities will include: - Developing a user-friendly Excel workbook with user-specific access. - Incorporating data analysis functions into the workbook to streamline and enhance my workflow. Please remember to include your relevant experience in Excel...

*** PLEASE DO NOT ASK "WHAT IS YOUR BUDGET" YOUR BID A...selection must compare Invoice Details with PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet showing duplicate entries highlighted Key Tasks: - Correct SQL query to eliminate duplicate entries Seeking someone proficient in MySQL database design and query optimization. Previous experience with troubleshooting and resolving simila...

I'm in need of an expert in data visualization to assist me with setting up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone who enjoys working with data, has a keen ...

I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.

Need someone who can analize data from a excel and contact customer with missing data

Task list 1) We hade a PsgSQL database with ticker data. We need to create another streaming data table with 1 min aggregate. Data table should update constantly, ideally each time ticker dateable is added with data 2) We need to write ports to the SQL data table to allow LAN connection to SQL from local network (other virtual machines connected by VM Oracle). Including Python connection 3) We need to write ports to the SQL data table to allow internet connection 4) We need instrument to add historical 1 min data to the database created on stage 1 5) We need Python script that will connect to 1 min data base and get top 5 instilments by price change from all instruments present in 1 min database Conditions: We do have a budget limit which is set ...

I'm in need of an experienced Ukrainian-speaking freelancer, thoroughly well-versed in Git, GitHub, PHP 7+ (preferably Laravel 9+), SQL - with ample experience in MySQL, MariaDB. A solid understanding of HTML, CSS, and JS and familiarity with known frameworks like Vue, Svetle etc. is a must. And other related stuff such as package managers (composer, npm), cli tools (ssh, rsync) etc. Common external API's like Google maps, Stripe, PayPal etc. No time limit is imposed for the project's completion, hence, a focus on quality and attention to detail will be greatly appreciated. I pay per task and looking for a constant collaboration. The perfect candidate is proficient in both front-end and back-end development, with stellar problem-solving skills. The website is alr...

I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Excel and have a str...

I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.

(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appreciated.

I am looking for an expert in .NET Core application development to Integrate Hangfire into a .NET Core web application for background job scheduling, focusing on configuring Hangfire with SQL Server, setting up dependency injection for job and CSV generation services, and defining job logic for various recurring tasks. This task includes implementing a secure Hangfire Dashboard for job monitoring and management, and creating specific recurring jobs (e.g., monthly, hourly) with logic tailored to business needs, such as generating CSV files. Ensure the solution encompasses database setup instructions for Hangfire, adherence to best practices in job scheduling, and thorough testing of job configurations and executions.

I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this s...Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to automate this process. Ideal Skills: - Proficiency in data analysis and automation - Experience in project management and time tracking - Excel expertise - Strong problem-solving skills and attention to detail. Looking forward to seeing your proposals!

the .db database is for an android app for my personel usage. The APP crash when i click on some records. And I can't delete those records by DB browser. I will give you the error records ID. And you just delete them. The app is in chinese language.

For my non-profit, I would like to build a thorough and searchable database that reflects candidates and their voting records on environmental issues. This database will cover candidates from all political parties to provide an unbiased perspective. I intend for this tool to aid voters in making an informed decision about who aligns most with their viewpoints. Key features should include: - A profile for each candidate which will house details on their voting record and policy positions related to the environment. Preferred skills and experience: - Database development and management - Excellent understanding of politics, particularly environmental policies - Strong research skills to ensure accuracy and comprehensiveness of all data - Ability to present data in a...

More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.

am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...

As per requirement, I will deliver the required district's School details in Excel format

...project, I need a skilled professional to create and deploy a unitary contact database. This system will be the hub for all contact information streaming from various sources such as VoIP, O365, WhatsApp, HubSpot, and Sigparser. Key Requirements: - Integration with Various Platforms: You should possess extensive knowledge in integrating various platforms into a central database. Experience with VoIP, O365, WhatsApp, is a must, experience with HubSpot and Sigparser will be highly valued. - Contact Syncing: The database should have the capability to sync contact details across all integrated platforms promptly and accurately. - CRM Integration: An essential part of this project is effectively linking the database with customer relationship management (CR...

I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in ...number appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentation - A...

...build a business intelligence tool. This BI tool will interact with an SQL Server as its data source. Notably, your role will entail: - Creating a data visualization feature to help in making graphical representations of information and data for better understanding. - Building interactive dashboards that allow users to interact with data to gain insights. - Developing a feature for customizable reports to allow users to vary parameters such as inputs, time period and type of data view. Furthermore, the BI tool should incorporate three user roles: Administrator, Analyst and Viewer. For successful project completion, you should demonstrate proficiency in business intelligence concepts, C#, CSS, HTML, and experience in SQL Server integration. Past work with similar pr...

I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while al...- Image replacements: Replace existing images with those I will provide. Skills and Experience: - Proven experience in managing Canva design projects - Excellent eye for detail - Strong graphic design skills - Good understanding of fonts, colors and layouts - Excellent communication skills to understand and translate my vision into the project design If this sounds like a project you can excel at, I invite you to place your bid. I look forward to seeing your ama...

I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to he...

I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.