Vba and sql experts in sydneyงาน

Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100

1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง

1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน

ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Server และพิมพ์ใบงานส่งให้ฝ่า...

ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน ...

การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง

...เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ

ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.

Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.

Software and Application OCR Scan or Take Photo of Document OCR TO SQL

รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

Experts required for building an ingenious web application using Angular + Laravel. Your primary task would be the initial creation of the application, yet this could potentially extend to long-term support. Key Responsibilities: - Create a robust, scalable, and highly interactive web application. - Develop efficient and reusable code that drives complex web applications. - Maintain a deep understanding of Angular + Laravel to optimize application capabilities. Ideal Skills & Experience: - Advanced proficiency in Angular + Laravel development. - Proven record of building highly interactive web applications. - Understanding of user roles for a web app is preferable. - Skilled in troubleshooting and improving existing and i...

I'm in need of a skilled Machine Learning Engineer who can develop modules to help analyze the real-time electricity consumption for a variety of devices in our system. Backend: Key Points: - Devices to be analyzed include air conditioners, lights, and simple motors and other simple devices. - The analysis should cover both the collective consumption of groups of devices and the individual consumption patterns of each device. Ideal Experience: - Strong background in Machine Learning, ideally with experience in real-time data analysis. - Previous work in energy consumption analysis or similar fields would be a huge plus. - Proven track record in developing ML models for group and individual level analysis. The...

I need a talented VB.net developer with a strong background in SQL Server. Key Responsibilities: - Develop software applications using VB.net - Efficiently manage databases - Designing, coding, testing, and debugging software applications using VB.NET. - Calling third-party API - Payment gateway integration - Stored Procedure Ideal Candidate: - Proven experience in VB.net development - Strong familiarity with SQL Server - Good problem-solving skills - Ability to work independently and meet deadlines. Please provide relevant work samples in VB.net development and describe your experience with SQL Server.

I need an expert in SQL Server Report Builder 3.0 to help rejuvenate some lab reports. I require some amendments to be made to the current reports I have. Key Tasks: - Altering the way data is presented within the reports - Incorporating new fields to the current reports In the end, I need the same data results but with improved visibility and understanding. Ideal Skills: - Appropriate familiarity with SQL Server Report Builder 3.0 - Strong grasp of data visualization principles - Detail-oriented and precise to ensure report data remains accurate. Individuals that can deliver these changes precisely and quickly are highly preferred.

...automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Features to Include: Advanced User Management: Implement a secure login system with multi-tier user roles and permissions. Dynamic Data Handling: Design the system to manage large volumes of data w...

...digital marketing and ready to take your career to the next level? We're seeking talented individuals to join our dynamic team at zintcs, a leading digital marketing agency in the industry. About Us: At zintcs, we're dedicated to helping businesses thrive in the digital landscape. As a forward-thinking agency, we specialize in providing comprehensive digital marketing solutions tailored to our clients' unique needs. From SEO and social media marketing to email marketing and e-commerce strategies, we leverage cutting-edge techniques to drive results and exceed expectations. Position Available: We are currently hiring for multiple positions within our expert team: Content Marketing Connoisseur: Are you passionate about sto...

I'm looking for a skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.

I'm in need of a Junior Full Stack Engineer who is proficient with Java, with beginner level experience. The primary task will be to work on implementing Go Live for an assigned project. Ideal skills for the job: - Understanding of Java programming language - Ability to work collaboratively on a team - JSON - XML - SQL - Data Mapping Some experience with project implementation is a plus. Dedicated beginners are also welcome to take their first steps in a real project.

Hi Ace Web Experts, I’d like to hire you to add a pick up option to the website

...primarily on data visualization and classification. IDEAL CANDIDATE SHOULD BE: • Proficient in creating visuals using complex data. • Capable of effectively interpreting data from CSV files. • Experienced in performing sophisticated data classification. TASKS DETAILS: • Devise an effective strategy for visualizing extensive information derived from CSV files. • Incorporate classification techniques to understand and categorize the data efficiently. PROJECT OBJECTIVE: The ultimate goal of this project is to successfully classify data and use it for an effective and visually appealing representation. This outcome aids in understanding the meaning and implications of the data better. Only exp...

Hi HIRE SEO EXPERTS, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am looking for a skilled and experienced Full stack developer with Hands-on experience in Java Hands-on experience in Angular/ REACT Hands on experience on AWS RDS/AWS S3/Oracle/AWS Athena/ SQL In-depth knowledge in Core Java, Spring framework and RESTful API Services, Apache Camel, CI/CD Jenkins, Containerization Experience with AWS Cloud and its services like EC2, Athena, Lambda, S3, SQS and Cloud Formation Experience in writing JUnit test cases Problem-solving abilities

...advertising platforms, website activity, CRM, and Marketing Automation Platforms (MAP) to provide a unified view of marketing performance. We require a highly skilled and efficient Data Engineer or Architect who can handle data export processes, model and create tables and entity relationships, and develop an efficient and scalable database within a tight one-month deadline. ### Responsibilities: - Data Integration: connect and streamline data from multiple sources including ad platforms (like Google Ads, Facebook), website analytics tools (e.g., Google Analytics), CRM systems (e.g., Salesforce), and MAPs (e.g., HubSpot). - **Accelerated Database Design:** Design and implement a robust and scalable database that supp...

...am in need of a comprehensive marketing strategy that will focus on increasing brand awareness for my accounting firm based in Sydney. The strategy will primarily involve Google Ads and lead generation. Key Responsibilities: - Creating and implementing a multichannel marketing plan aimed at enhancing brand awareness for my firm. - Designing and managing Google Ads campaigns on both Search and Display Networks. - Generating leads from small businesses, individual service seekers, and corporations in Sydney. Skills Required: - Proven experience in developing and executing successful marketing campaigns, particularly in the B2B and professional services space. - Proficiency in Google ...

For this role, I'm urgently seeking an experienced Java Developer, though a specialization in Java SE, Java EE, or JavaFX is not necessary. At this time, a broad understanding of Java, rather than specific Java skills, is most crucial. Key Requirements: - Proven Java development experience is vital, as it'll aid in current project requirements. - Knowledge of specific APIs or libraries to extend capabilities and integrate systems. When applying, kindly provide the following: - A summary of your Java developer experience - Articulate your knowledge and usage of specific APIs or libraries. Looking forward to connecting with experienced and knowledgeable Java experts for a swift project execution.

I'm seeking an experienced .NET developer with over 4 years of expertise in C# programming and SQL databases. Key Responsibilities: - Enhancing existing software application - Adding new functionalities The ideal candidate should possess: - Strong experience in C# programming - Solid knowledge and practical experience with SQL databases Be ready to dive into the project and help us bring significant functionality enhancements to our existing software. Your experience and skills in C# and SQL will be invaluable in this task.

I'm in need of a talented UI designer to craft an engaging and functional design for both web and mobile platforms. The completion timeline is within a month. While the precise components weren't specified, demonstrating past experience with creating a variety of UI elements, such as buttons, navigation menus, and forms, will be highly valuable for this project. Looking forward to your creative designs! Ideal Skills: - UI design experts with experience in both web and mobile platforms - Ability to deliver high-quality work within a month - Broad experience in crafting various UI elements - Highly creative and innovative design approach.

...the value of a MySQL db and results appear 3 to a page using Pagination. I'd like the script modified to filter results. There should be a drop down box on the page with the selections of the drop down corresponding to the table column and when selected only the rows with the value of the column appear while still only displaying 3 to a page with page back and forward controls. In the below example of a db table the drop down box would contain the selections 1, 2 and 3. When the used selects 1 then the page output would only display Bob, Jane and Sarah. This is an already existing page with css in the output. Name Address. number ------------------------------------------------------ bob brisbane. ...

...unique e-commerce shopping cart and accompanying admin panel. Key Responsibilities Include: - Constructing a product catalog and search functionality to allow customers to easily browse and locate items. - Integrating an 'Add to cart and checkout' feature ensuring a simple and smooth transaction process. - Developing order management and inventory tracking system within the admin panel to help me keep track of orders and product stocks. Skills and Experience Required: - Proficient in PHP programming - Experience in developing e-commerce websites - Solid understanding of databases and SQL - Familiarity with different payment solutions Although there is no specific requirement for paymen...

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

I am looking for an expert in RFID technology and .NET programming to integrate the RFID into our current weighbridge system. Key Details: - 3rd Party System was developed using .NET and it does support API or external interface connections. - The task will involve programming to fully integrate the system with RFID technology. Skills and Experience: - Proficiency in .NET programming & SQL Database - Previous experience with RFID technology - Knowledge of API integration - Experience with weighbridge systems would be a huge advantage. Your role will be to ensure the smooth functioning of the weighbridge system post-integration and provide us with a user-friendly, effective RFID solution.

• Experience with Testing tools Experienced using SQL Advanced experience developing test metrics and reports Experience with Automated Testing Five (5) • years of Testing experience in a Software Development Lifecycle environment Five (5) • SQL and PLSQL Programming in SQL Server ETL and Data warehouse process Informatica 10 • 20 Informatica Data Quality Profiles , Score Cards SQL Server RDBMS SQL Server Analytics Services SSAS SQL Server Reporting Services SSRS Tableau Reporting BMC Control M Scheduler Tool Data Analysis Data Profiling Application Life Cycle Management Complete Testing process SDLC, Agile Process, SAFE and Kanban methodologies, TFS Tool Good Communication Skills and...

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation thr...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create u...

I am seeking bridge design experts to present a functional geometric bridge proposal. The primary purpose of the project is functionality over aesthetics. This bridge should be designed specifically for vehicular traffic, and it's crucial it accommodates both light vehicles like cars and motorbikes as well as heavy vehicles such as trucks and buses. The proposed design should factor in strength, durability, and traffic flow for effective usage. Ideal Skills: - Degree in Civil or Structural Engineering - Experience in bridge design and functionality - Knowledge in geometric designs - Proficient in design software - Understands load calculations for different vehicle types. Views of the three-dimensional mo...

I'm in need of an expert who can help in developing a relational database using SQL and Python. The project will primarily revolve around database management. Consequently, I would appreciate assistance in the following tasks: - Designing a new relational database, ensuring it's optimized for efficiency and performance. - Implementing data import and export capabilities for seamless data movement. - Developing queries to support the database's functionality and ease of use. The ideal candidate for this project should have a strong background in both SQL and Python, with a specific focus on database development. Experience with optimizing databases for performance and some knowledge of data ...

...looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a...

Need advanced SQL including stored procedures, functions, based on existing SQL code. Need c# coding with dojo -Ideal Skills/experience * c# with dojo * MS SQL Server proficient. * Expert in advanced SQL features like stored procedures, functions. * complex SQL queries. * generating SQL reports from tables.

I am in need of an expert Power BI developer who can help me integrate AI features into my existing project. Specifically, I'm looking to incorporate Natural Language Processing, Machine Learning Models, and Predictive Analytics functionalities. Key Requirements: - Proven experience in implementing AI features in Power BI is a must. - Strong background in Natural Language Processing, Machine Learning Models, and Predictive Analytics. - Proficient in working with SQL databases and Online APIs for data integration. - Ability to deliver a dashboard with basic filtering and sorting capabilities. Your main tasks will include: - Integrating the AI functionalities into the Power BI project. - Ensuring seamless communicat...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

...expertise and empowering users with valuable insights to navigate the world of investments. Now, I need someone with backend wizardry to help bring Arthwise to life! This isn't your typical job post – it's more of a collaborative side hustle. We'll be building something together that has the potential to change the game in the finance world. What I'm Looking For: Someone who's passionate about building scalable applications. Experience with backend development, RESTful APIs, and microservices. Familiarity with database management (SQL/NOSQL) and cloud services. A creative problem solver with a knack for turning ideas into reality. What You'll Do: Set up the backend architecture. Implement core and adva...

...specialized in Java, JavaScript, and PL-SQL, as well as familiar with Oracle Database, PL-SQL Developer, Oracle SQL Developer, Eclipse. The project involves writing comprehensive tests for a range of technologies including: - Java and JavaScript. - Spring Framework. - Oracle Database. - XML and JSON. - Junit. - Eclipse/Intellij. - PL-SQL Developer. - Utilizing Github and other version control tools. The ideal candidate must have a deep understanding and practical experience with these technologies. The project has an urgent timeline, so the selected candidate must be able to work under pressure and deliver high-quality results quickly. Ideal Skills: - Proficient in Java, Spring Framework, Oracle, XML...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

Hi HIRE SEO EXPERTS, I noticed your profile and would like to offer you my project. We can discuss any details over chat.