Sql bak excel työt
I need assistance with a simple data entry project. The assignment involves collecting specific data from an unspecified type of directory and transferring it onto Excel. need it done quickly.
I am in need of an Excel database and estimating tool. This tool will be specially designed for engineering applications, and must be packed with specific features including: • A data entry form: To facilitate the input of data into the database. Freelancers with praiseworthy data organization skills are ideal for this task. • Calculation functions: I’m not looking for anything overly complicated. Simple arithmetic calculations will suffice. Excel experts who can craft an easy-to-use, yet efficient calculation function are what I need. Capability to calculate engineering, installation, and management time based on material used from database. We also need to be able to add items to the database easily at any time. In summary, I am searching for Excel...
I'm seeking skilled programmers with expertise in surveillance systems, specifically smart home security cameras. I'm trying to gain remote access to an existing set up for surveillance purposes. The ideal freelancer for this job will excel in: - Understanding of surveillance technology - Proficiency in ethical hacking - Familiarity with smart home security cameras software and firmware - Proven experience in creating secure remote access points. Please bid, keeping in mind the sensitive nature of the project and the need for absolute client confidentiality.
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
PLEASE REED THE INFO ON TH...SPECIALLY THE WORD AND CHECK WHAT NEEDS TO BE DONE ON THE EXCEL I'm seeking assistance from an Excel expert, well-versed in all versions - 2019, 2016, Online/365. I need comprehensive help with: - Data analysis: Moderate complexity data needs to be properly scrutinized for decision-making. - Spreadsheet formatting: I require a user-friendly, organized layout. - Formula creation: Specific formulas need crafting to meet my project requirements. The right candidate should have strong analytical skills, a meticulous approach to tasks, and a solid background in Excel. Your expertise in working with moderately complex datasets and creating tailored formulas will be a key determinant for success in this project. Conceptual knowledge in a...
Calculate the Hours worked on a daily, weekly and monthly basis based off an excel sheet with the daily activity. We are looking for presentation, accuracy, winner will be used for additional projects as well.
...existing R 4.3 code into a Tableau Prep workflow. I have written a substantial set of R code for data cleaning and transformation. I now need to reproduce this process in Tableau Prep so that it can be run independently by someone without access to R. The process takes as inputs a number of separate excel workbooks. The existing R code cleans and transforms them (including new variable calculations, aggregation and summaries, and adding data scaffolding), and outputs a single multi-sheet excel workbook for further use in a Tableau dashboard. The existing R code uses tidyverse packages, and is modular and well-documented. For this project, we need to develop a new Tableau Prep workflow that should replicate the data cleaning process that I have written in R. Skills and...
I require a well-experienced Python (Django) developer to work o...well-experienced Python (Django) developer to work on creating a RESTful API for our Warehouse Management System (WMS) and Enterprise Resource Management (ERM). Strong working experience in the following areas is critical to meet the KPIs of this project: • Inventory management • Order management • Reporting and analytics Having these functionalities will allow the seamless flow of data into our SQL database from the API connection into our WMS (Logiwa). Interested freelancers must demonstrate experience in designing APIs with Python (Django), as well as have a deep understanding of Inventory and Order Management, and Reporting and Analytics. Start your proposal with 'Python API Expert' as ...
I'm looking for a skilled freelancer who can assist me w...assist me with data extraction from the TradingView website, specifically concerning: - Cryptocurrency names - Relative Strength Index (RSI) - Ultimate Oscillator (UO) Key tasks and requirements include: - Data should be extracted accurately and consistently on a daily basis. - Data should be delivered in an organized Excel spreadsheet. - Regular retrieval and updates of the gathered data are essential. It's critical to bring profound knowledge and experience in data mining, Excel, and ideally a solid understanding of financial instruments such as Cryptocurrencies, RSI, and UO indicators. Commitment to meticulous work and the ability to deliver results consistently each day will be key to the successful ...
I am in need of a professional well-versed in both accounting knowledge and Excel skills. The focus of this project involves updating numerous (>10) Excel worksheets with actuals extracted from a Xero enterprise report. This initially one-off endeavour might lead to potential further collaborations. The specific task details: - Update Excel worksheets with data from an enterprise report in Xero. - Prepare a comparison table outlining key budget v actual variances. Pertinent skills and experience: - Solid understanding of accounting. - Advanced proficiency in Excel. - Familiarity with Xero enterprise reports. This task is designated as a one-off project but might lead to more potential work given satisfactory completion.
I am in need of a skilled financial analyst who can build a comprehensive Excel forecast for a new venture over a three-year span. The model will be intercepting the following data points: - Yearly revenue projections - Expense projections (both itemized and summarized) - Profit calculations The successful candidate should have significant prior experience in financial forecasting and analysis, in-depth knowledge of Microsoft Excel, and a keen attention to detail. The ability to interpret and utilize provided data effectively will be key for this project.
I'm searching for an experienced Full Stack Front End Developer, capable of transforming...transforming my vision into a user-friendly and responsive web application. Key Responsibilities: - To execute Front End Development tasks Required technology competencies: - Solid Experience in MVC 5 Razor Views, Web API, .Net 6, C#, Web Forms - Proficient in Typescript, JQuery - Proficient in Telerik Controls (Ajax and Kendo UI) - Solid understanding of HTML/CSS, SASS - Proficient with , SQL Server This is a part of a larger accounting type application. We need help with redesigning some of the areas of the application. Looking forward to working with a versatile developer proficient in these technologies and can deliver a product that performs seamlessly, ensuring a great user exp...
Seeking help with text data entry in Arabic. Using a spreadsheet format, freelancers will be conducting extensive data entry tasks. Although the platform requires Arabic language skills, only a basic understanding is required for this project. Relevant previous experience and a keen eye for detail are preferred. Proficient use of spreadsheet software like Excel is crucial.
I am seeking an expert in financial excel modeling Key Project Objective: • To analyze the difference between my company's actual, budget & LY. Data Provided: • I will provide the company trial balance Required Skills: • Proficient in Excel • A sound understanding of Financial Statements • Experience in conducting Variance Analysis • Attention to detail
Experienced Amazon Listing Specialist Needed Responsibilities: Take my excel file, review, make correct for posting on advise where to upload so I keep my 160 other listings advise where images go. see where they are on excel. not sure on the new amazon where they go. - You will be in charge of updating Amazon with over 40 new products. These products fall within similar categories. Skills and Experience: - Proven track record in Amazon listing setup, with emphasis on products within similar categories. When you are finished, supply file for upload and advise on images. .
I require expert assistance in Excel data analysis. Specifically, the tasks include: - Data analysis - Creation of spreadsheets - Generation of charts and graphs - Identification of trends Speed is of the essence, hence completion ASAP is a must. Ideal candidates should have proven experience in Excel data analysis and visualization, with strong critical thinking skills for trends identification.
I require: - Laravel, PHP, and SQL for finishing my remaining payment task. - I need Firebase real-time data updates to my existing SQL database for managing IOT devices. - Experience in payment gateway integrations is also necessary. I will use PayPal integration and with visa or any credit card system. Ideal skills: - Strong expertise in Laravel, PHP, Firebase, and MQTT - Proven experience in implementing real-time data updates using Firebase - Experience with credit card and PayPal payment gateways. I'm hoping to get my web application running smoothly with real-time updates and seamless transactions through both credit card payments and PayPal.
I hope to engage an Excel user who can construct an easy-to-use formula for automatically duplicating rows based on a stated quantity in a selective column. Here's what I need: - A formula that reads a specific column and replicates the entire row underneath based on the quantity listed in that column. Ideal Candidate Characteristics: - Has basic knowledge or is at least a beginner level with Excel to create such a formula confidently. - Experience with Excel formulas is a must. You should be able to present verifiable examples of your prior work where you successfully developed Excel formulas. Please include your previous experience with Excel formulas in your proposal. If possible, providing an example of a similar work where you successfully...
I am looking for an Account manager who's proficient in data analysis through excel. Your task will be twofold: 1. Data Analysis: - Analyse sales data with a focus on product usage and customer complaints. - Interpret customer feedback to understand their primary concerns. 2. Reporting Insights: - Identify trends and patterns in the data; review these observations against sales and customer feedback. - Highlight areas that require improvements, based on your analysis. Ideal Skills and Experience: - Excel proficiency with a solid understanding of data analysis. - Experience in sales and account management. - Strong analytical skills with an eye for spotting trends and patterns. - Ability to synthesize complex data into actionable insights.
I'm looking for a skilled blog site developer who can build a platform focused on providing informative content. This project involves not only writing engaging blog posts but also presenting...informative content. This project involves not only writing engaging blog posts but also presenting data tables effectively throughout the content. Key project requirements: - Creation of a comments section for each post to facilitate audience engagement. - - - Capability to convert provided Excel spreadsheet data into intuitive tables to be incorporated within the blog posts. Your relevant experience in blog site development and data management would be beneficial for this job. Knowledge in manipulating Excel data for web display is a must. Connect with me if you have the righ...
...database to store data for sports volunteers. The primary purpose of this database is to keep track of critical volunteer nomination details such as: - Personal information (name, contact details, rugby club) - Skills and experience - Volunteer categories (National and Hampshire) - Volunteer nomination data - Nomination score - Nomination winners Ideal skills for this role would be proficiency in SQL and an understanding of data confidentiality and encryption. Experience in creating relational databases is necessary, and a background in handling volunteer databases or similar projects is highly preferred. Efficient data organisation is crucial, as quick access to specific volunteer details is required. Future modifications should also be easy to accommodate such as reports and f...
I am in need of a website developer skilled in ASP.NET MVC with SQL. This website should be versatile, supporting both mobile and desktop view. Key functionalities required are: - User login and registration system - E-commerce capabilities suitable for a corporate atmosphere The design should be professional and corporate tailored. The target users are businesses seeking services. Thus, the platform should offer a user-friendly experience and interface for a professional audience. Understanding of corporate branding and UX design would be a definite advantage as the design needs to align with business professionals. Freelancers with prior experience in creating E-commerce sites on ASP.NET MVC platform with SQL for businesses are highly preferred.
I'm seeking an individual with strong skills in Microsoft Excel, specifically in creating pivot tables and graph visualizations. For this project, the data to be incorporated is relatively simple, including only a few variables. These are the reports and graphics I need. If you are able to create 5–10-page PowerPoint with your findings and graphics, that would be an added plus. 1. Forms submitted by user – graph with count of who has a zero total count grouped by department 2. Forms submitted by user – graph with count of who has a zero total count grouped by security group 3. User access log – graph with count of who has never logged in or over 200 days of not logging in by department 4. User access log – graph with count of who has never lo...
...- Stable Position: We offer a secure position with a good base salary and opportunities for increasing remuneration. - Expert Guidance: As experts in creating and monetizing YouTube channels, we provide guidance and support to help you thrive in your role. - Comfort and Support: We prioritize the comfort and well-being of our freelancers, ensuring you have the resources and support you need to excel. About Us: We are a team of seasoned professionals dedicated to creating and monetizing successful YouTube channels. As we focus on content creation, we need a reliable editor to join our team and take charge of the channel's editing needs. Responsibilities: - Editing videos to ensure high-quality content consistent with our channel's style and branding. - Incorporating gr...
I require a highly skilled Excel expert Skills and Experience: - GPA calculation - conditional formatting - Goal seek analysis and sparkline - 3-D pie chart - Absolute vs relative cell reference - Function PMT
I'm in need of a proficient Excel user who is well-versed in creating, managing, and troubleshooting financial calculations via Excel formulas. While prior formatting requirements are unspecified at this point, adaptability and a strong understanding of Excel's user interface will be inherent to success in the project. Ideal Skills: * Proficiency in Excel * Good understanding of financial calculations * High attention to detail * Strong communication ability Experience in financial analysis or similar field would be beneficial. Extensive knowledge of Excel including, but not limited to, the usage of formulas and functions specifically focused on financial calculations is essential for success in this project. No specific formatting requirements are ...
I am in the hunt for a skilled Python & SQL specialist who can help with optimizing my database. The exact type of database is yet to be specified. I am not experiencing specific performance issues at this time. However, I am looking to proactively improve its efficiency. The ideal candidate should have: - Proven experience in database management and optimization using Python and SQL. - Expert understanding of various databases and how to best optimize them. - An analytical mindset to manage and prevent possible future challenges. Experience with both MySQL, PostgreSQL, and Oracle would be advantageous, as I have yet to decide the final database type. Your input will be expected. Please include your approach to this project, relevant experiences, and results achieved...
...transfer the data to Excel. The PDF tables are consistent across all pages, maintaining a fixed column structure which you need to duplicate in the Excel spreadsheets. The data you will be working with is primarily text-based as opposed to numerical. Necessary Skills and Experience: - Excellent attention to detail - Proficiency in optical character recognition (OCR) processing - Experience with data scraping or extraction - Valuable skills in MS Excel - Familiarity or experience with PDF data extraction software Swift and accurate execution is essential for the successful completion of this project. Please only apply if you are comfortable handling a high volume of pages and can ensure that no data is lost or incorrectly transcribed in the transition from PDF ...
I am in need of a seasoned professional for my database migration project. My existing database resides on SQL Server 2022 and I am aiming to migrate it to Oracle 19c. - The size of my SQL Server database is small, amounting to under 1 GB, but there are around 450 procedures and functions which have to be migrated - Experience with handling similar sized databases and an in-depth understanding of SQL Server 2022 and Oracle 19c is a must. - Proficiency in SQL and database migrations are critical, along with a problem-solving attitude. - The freelancer must ensure smooth transition with no data loss and optimal functionality post migration. - An established process, clear communication and deadline adherence are necessary. This is a challenging role requiring hi...
1) We hade a PsgSQL database with ticker financhial data. We need to create another streaming data table with 1 min aggregated data for each transaction. 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
I'm in need of an expert data scraper to pull detailed information on driving instructors based across the entire UK. The data to be gathered include: - Driving instructor or school name - Location: Not just city but postcode as well - Contact info: Either email address or contact number, whatever's available Once you have all this information, I need it compiled in an organized manner on an Excel Spreadsheet. It is important that I get data from driving instructors spread across the UK so I can have a comprehensive database. For this job, you need to have good attention to detail and previous experience in data scraping is key. Knowledge about UK geography will be useful too.
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 Bot check: write price for each part from 1-5
1) We hade a PsgSQL database with ticker financhial data. We need to create another streaming data table with 1 min aggregated data for each transaction. 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
VIP is a software system current in production running in Azure and built on .NET Framework 4.8 platform using C#, ASPNET MVC, AngularJS, OpenTok Video Comm Components (Vonage) and Syncfusion UI Components. It is running on top of a SQL Server DB (created via EntityFrameWork CodeFirst) for persistence with ties to Twilio for SMS and SendGrid for email communication. There is also a WebAPI project that is part of the solution that may need to be enhanced for this migration effort. The initial groundwork was done by another developer who was unable to complete the work. I need a good development team (2-3 developers) with excellent communication skills who are willing to build upon the the infrastructure already created and complete the migration of the application to .NET Core (C#...
We need to complete excel list using a Data Scrapper. Please see the exmple with a total of 1284 companies. You can find this information scrapping cnpj (vat id). In several sites : ; ;;
I'm seeking a precise, detail-oriented data entry operator to handle text-only data. i. **Data Type & Volume**: The project involves working with less than...operator to handle text-only data. i. **Data Type & Volume**: The project involves working with less than 10,000 words of text data. ii. **Data Source**: These data are contained in digital files which will be provided. To ensure a smooth operation, excellent command of the English language is mandatory as you will be dealing with text data. Proficiency in Microsoft Office, particularly Word and Excel for entry tasks, will be priceless. Ideally, prior experience in data entry roles will be beneficial. Please be ready to demonstrate your ability to handle tasks efficiently without errors. Accuracy and attention...
I require assistance with my Excel spreadsheet to modify existing formulas. As part of the specification, the contractor should: - Have sound knowledge and expertise in handling Excel formulas and calculations. - Be able to understand and modify existing formulas as I don't have specific information on where exactly the formula modifications are required. - Strong analytical skills would be ideal for this task. Please note that this project doesn't involve creation of new formulas and I solely require making changes to those that already exist within the spreadsheet.
I require a Python specialist to assist in data analysis, visualization and data web scraping and automation tasks. Should be proficient in JavaScript and SQL for smooth operation. Expect to handle text, numerical, and image data with finesse. Key Skills and Experience: - Expert in Python - Proficient in JavaScript and SQL - Prior experience in data analysis and visualization - Proven ability in web scraping and automation - Capable of working with text, numerical, and image data. We need to scrab below site.
I'm in need of an advanced Excel 2010 expert who can assist me in creating a spreadsheet that performs automated data comparison between two databases. Key Responsibilities and Functions: - The first sheet of the database will be used as the updating information sheet when a comparison is done with the second sheet. - Comparisons will involve both dates and text data. - When a match is found, the program must be configured to ignore that item and proceed to the next. - For startup phase, I require the comparison to be done monthly. However, I'll need flexibility to increase this frequency to weekly. Ideal freelancer for this project: - Expert level knowledge in Excel 2010 and its functionalities. - Experience in handling and manipulating large data. - Proven tra...
I'm in need of someone who can manipulate an Excel spreadsheet I've been working on. Specifically, I currently have the empty cells highlighted in purple using conditional formatting and I want these cells to automatically change to green as soon as some text (typically a name) is entered into these blank cells. This rule should apply to the entire sheet, not just specific columns or selected ranges. What I expect: - Excel professionals, with great expertise in conditional formatting and automation. - Prompt and efficient in completion. - Strong attention to detail. - Good communication skills to clarify any uncertainties.
I'm in need of someone who can manipulate an Excel spreadsheet I've been working on. Specifically, I currently have the empty cells highlighted in purple using conditional formatting and I want these cells to automatically change to green as soon as some text (typically a name) is entered into these blank cells. This rule should apply to the entire sheet, not just specific columns or selected ranges. What I expect: - Excel professionals, with great expertise in conditional formatting and automation. - Prompt and efficient in completion. - Strong attention to detail. - Good communication skills to clarify any uncertainties.
I require a very detailed Excel workbook created. Here's what you'd need to know: - The workbook should have more than 20 tabs. - Each tab would contain data in the form of both text and numbers. The specific nature of this data will be provided once the project commences. - There's no need for additional analysis like charting or reports. The ideal freelancer would have a strong understanding of Excel and be able to deliver work efficiently without compromising on organization and detail. Experience in data entry and management is paramount.
I'm in need of a proficient social media agency to handle the management of my Instagram and TikTok platforms. Considering my target audience comprises the savvy teenagers and young adult demographic, the selected agency should excel in: - Content Creation: Engage and captivate my audience with fresh, creative, and relatable content. - Social Media Management: Stay on top of trends in effectively managing and growing my brand's presence on both platforms. The ideal team would be experienced in connecting with teenagers and young adults on social media, and understand their interests, memes, and lingo. Creativity, current with trends and an ability to interpret my brand's voice into engaging content are a must.
I'm urgently in need of a web scraping expert who can deliver 200-300 data entries in an Excel sheet. While specific websites are not listed, the target data includes the names, emails, and cities of companies. Ideal candidates should exhibit: - Proficiency in web scraping tools and techniques - Strong proficiency in Excel - Attention to detail and accuracy Although past work and detailed project proposals aren't specifically required, evidence of related experience or similar completed projects is beneficial. This task is time-sensitive and needs completion as soon as possible. Please only apply if you're able to fulfill the obligations within a short timeline.
I need an expert in Excel and business resiliency management. The task involves developing a concise, user-friendly Excel template for various aspects of business resiliency management. Key Features Needed: - Risk assessment - Business impact analysis - Crisis management plan Ideal Organization: - User input tables for easy data entry - Coherent charts and graphs for visual representation - Summary sections for quick overviews This is a fast-paced project so I would ideally prefer someone who can make this a priority and deliver as soon as possible. Ideal Skills and Experience: - Proficiency in Excel including Charts, Graphs, and Data Validation - Experience or theoretical knowledge in Risk Management, Business Impact Analysis, and Crisis Management Plan...
...crud operations. A file server where users can upload download and delete files. Once user login successfully they should be able to see 2 tabs on a web page, one for employee data, they should be able to perform the CRUD operations. Another tab for file server where user can downloaduploaddelete a file. Tech Stack - HTML/CSS/JavaScript for frontend. - Angular or React for frontend framework - SQL as DB - JWT for handling user authentication and authorization - A file server running locally on windows machine User Scenario 1. User should be able to access the home page and able to register themselves and should be able to login based on credential validation 2. Upon successful login, user should be able to manage employee and access file server (files), as shown in page-2 3...
You will extract pages from large PDF and make smaller ones, then name them and save to a folder. You will get an Excel with URL and page numbers in a PDF to extract. These are financial documents and you will be getting the presentations out of them. You have to: - Have Acrobat pro etc to edit PDFs - Experience doing accurate work by following an Excel sheet with to dos. Flexible hours and no crazy deadlines. You have to be 100% perfect though.
I need consultation and advise on sql server speed when hosted on cloud using linux ubuntu. The problem is that the transaction of the data is very slow when the database is hosted on cloud.
For this bespoke venture, I'm searching for a talented programmer who is proficient in either Python or C++. batch understanding is a must! The primary task involves: - Developing a new API key login system with a focus on implementing access control and permissions. This calls for deep understanding of SQL and batch. Ideal skills/experience include:- Hands-on experience in SQL, batch, and either Python or C++ for backend programming. - Demonstrated skills in developing and maintaining API key login systems. - Proven knowledge in creating permission-based access controls within systems.
