Excel database programmingงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
I am looking for a highly skilled developer to create an AI image generator capable of creating images for clothing items. The aim is to provide unique designs for various clothing items including T-shirts, Hoodies, and sweaters. The AI should...generated designs should span multiple themes including Abstract, Cartoon characters, Nature patterns, and more. Key project requirements are: - The AI should generate images on T-shirts, Hoodies, and sweaters. - A vast array of style/theme options must be incorporated. - The image resolution must be high (300 dpi), formatted as PNG. Ideal candidates should have experience in AI programming, graphic design, and an understanding of clothing design. Poting your previous works related to AI image generation will be a plus in thi...
I'm in need of an exceptionally experienced Unity Developer who can aid in crafting an action game for the PC platform. Key responsibilities will include: - Collaborating in the design & development of...Key responsibilities will include: - Collaborating in the design & development of the game mechanics and user interface - Debugging and optimizing for compatibility and performance on PC - Implementing innovative and immersive gameplay features Ideal Candidate Skills: - Expertise in Unity game development - Proven history of developing action games - Strong grasp on C# and object-oriented programming - Familiarity with PC game development and compatibility optimization Applicants, please share your relevant portfolio pieces and prior experiences pertaining to actio...
I'm in need of a software programmer who is proficient in Python, Java, and C++ to develop a small-scale software program primarily aimed at automating a specific task. The task itself is relatively simple, but the automation of it is critical to increase efficiency. Key aspects of the project: - The software program must be designed to automate a specific task. It's crucial that the programmer fully understands the task at hand to ensure a seamless integration of automation. - The scope of the project is small-scale, so the focus is on developing a functional, efficient automation solution. - Proficiency in Python, Java, and C++ is non-negotiable. The software is expected to be developed using these languages. Ideal skills and experience: - Proficiency in Python, Java, and C...
I am seeking an entity with expertise in ESP32 programming, specifically having an in-depth understanding of RTKLIB's implementation and RTCM conversion. The task includes: - Coding, making the ESP32 project work in coordination with the RTKLIB to function optimally - RTCM (Radio Technical Commission for Maritime Services) code conversion is needed. Particularly converting RTCM messages 1005, 1077, 1087 to 1006, 1004, 1012 and adding 1033 - The ideal candidate for this project needs to be familiar with the RTK rtcm and how to utilize the 'TADJ = 1' variable in the RTKLIB to enhance positioning accuracy and aid in correcting transmission errors. If you have the skillset, including an understanding of sensor data processing and receiver clock adjustments, please a...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR and Good review, Dont expect more I am not big fish...
...created to scrape coins from my Telegram group via API integration but currently, it isn't purchasing as expected. Specifically, I'd require someone who could: - Identify and fix the issues that prevent it from purchasing and selling the scraped coins. - Make sure the bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot&...
...created to scrape coins from my Telegram group via API integration but currently, it isn't purchasing as expected. Specifically, I'd require someone who could: - Identify and fix the issues that prevent it from purchasing and selling the scraped coins. - Make sure the bot interacts properly with the Latoken cryptocurrency exchange. This task would suit someone with a strong background in bot programming, API operations, web scraping, and experience dealing with cryptocurrency exchanges, particularly Latoken. Knowledge of crypto trading bots' operational peculiarities would be a major plus. Your task would be to get it back to working condition, ensuring all functions operate as they should. This job will evolve into continuous maintenance and development of bot&...
Good evening, I need help with a Python assignment and I also need programming tutorials in java, Python, mvc, php, Javascript, mysql, jQuery, html, css, asp.net, c#. The tutorials would be in Spanish. I need them as soon as possible.
I'm seeking a proficient individual for constructing an Access database for my project. The principal requirements include: - Experience with Access, as that's the selected database management system. - Expertise in data storage and retrieval is essential. - The database will be storing textual and numerical data. Experience in handling these types of data is crucial. Ideal skills would include an in-depth understanding of Access, database design, data storage/retrieval techniques and knowledge in handling both textual and numerical data. This should make for a streamlined and efficient process. I'm excited for us to kickstart this project together!
I'm looking for a skilled data scientist to assist with a project that involves detailed statistical analysis and modeling using R. The eventual goal is to present these findings in a comprehensive yet accessible manner through data visualizations. Ideal Skills & Experience: - Proficiency in R programming - Strong statistical modeling background - Experience with data visualization techniques - Ability to create detailed reports - A firm grasp of accounting principles would be a plus, but not required. This project will require someone who can take raw data and transform it into valuable insights, with the ability to convey these insights in an engaging, comprehensible manner. If you are comfortable with both the technical and reporting aspects of data science, I would...
...details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver accurate results within a set timeframe. -Project Length: Short-term, estimated completion within one week. ( MAX 80 AUD as a test round, if the work is good, Larger jobs will come) Application Instructions: Please message me with the keyword "VSL" at the beginning of your application to confirm that you have fully read and understood the job desc...
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.
** Please do not apply. If you don’t meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The G...the ability to distinguish and identify Ontario/Canadian Grant opportunities • Ability to work effectively under pressure; • Excellent writing and verbal skills; • Be highly organized with the ability to implement systems and follow-up processes; • Proficiency in research, interpreting, and analyzing diverse data; • Excellent Computer skills (Microsoft Office Word, Access, PowerPoint and Excel),...
I'm looking for an experienced developer to build a custom photo editor for my web application. This feature-rich editor should include: - A diverse range of filters for users to enhance their images. - Capabilities to allow cropping and resizing of images promptly and comfortably. - A user-...users to enhance their images. - Capabilities to allow cropping and resizing of images promptly and comfortably. - A user-friendly option to add creative text overlays. The photo editor should be compatible with both web and windows platform. The ideal freelancer will have strong experience in building custom features, particularly those involving image editing. Proficiency in a variety of programming languages, especially the ones that are most suitable for this type of project, is hi...
We are in search of an intermediate level Java developer with in-depth knowledge on multi-threading. The main task presents a for loop which needs to be ...of an intermediate level Java developer with in-depth knowledge on multi-threading. The main task presents a for loop which needs to be partitioned between n number of threads. Your skills and experience should include: - Solid understanding of Java programming language - Hands-on experience with multi-threading in Java - Proven experience with running Java applications with multiple threads To ensure your competency for the task, applicants should provide documentation of past work specifically highlighting instances with similar programming challenges. Join us in this interesting endeavor, let's make the code mo...
I'm on the lookout for a skilled Flutter developer to create a cross-platform (iOS and Android) restaurant application w...browse various menu categories and individual meal descriptions. - Online Ordering: Requisite infrastructure for placing orders online, including a secure payment process system. - Reservation System: Must include a highly-efficient table reservation system with instant confirmation. Ideal Skill set: - Extensive knowledge and experience with Flutter app development - Strong fluency in Dart programming language - Proficiency in implementing secure online payment gateways - Previous experience with restaurant or similar e-commerce applications is a plus In your bid, please furnish samples of your previous work and estimated timeline for the completion o...
I'm seeking a professional able to create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formulas and visual repre...
The database is on the National Environmental Agency's website, and it includes all of the applications submitted for environmental permits. Here is a link to the database: Please go over all of the records, and filter ones that match all criteria: 1. EIA Screening Application/Statement or EIA Scoping Application/Statement and 2. The application is for an activity in the sea Start a new spreadsheet, and for every such record, meeting the above criteria, add a row to the spreadsheet including: date of the record, screening/scoping, title of the application (translated to English), a url linking to the application on the NEA website. In addition, download the screening/scoping report document, translate it to English with Google translate
We would like to hire a freelancer expert in development of Postgres Database and Synchronization of Data from our Headquarter to our Multiple Area Office (10 No.) and to Multiple Local PC (Around 300 Nos.) locations available in Network.
We have attached the details we need to sync our data from Headquarter to Area Office and than to local PCs and back again. for RFID based application.
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.
I'm looking for a skilled Python developer with experience in GPU programming using CUDA to assist in a project that involves image processing and data analysis. - I have a python code and I need to modify it to work with GPU the code takes an image changes its pixels one by one and each pixel change calculates new image hashes if images hash satisfies some specs it save image and code ends. this is whole python code is doing now. it is a 40 lines code. very simple for someone who knows how to code on cuda.
...open water, and marathon swimming - Write engaging, informative blogs on all aspects of swimming (mostly related to our Swimming Adventures) - Ensure content accuracy - Engage with swimmers by addressing common concerns and questions - Their proven swimming background - Excellent writing and communication skills - Proficient in research and fact-checking - Familiarity with skills, training, programming, swimming destinations, open water safety, coaching qualifications, swimmers needs - Ability to translate sport science jargon into layperson terms With content expected each week, the right freelancer must be reliable and able to manage regular deadlines, while maintaining a high standard of quality in every piece. Could be fortnightly of course also for the right candidate. S...
...scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. * Attention to detail to ensure accuracy of the scraped data. * An understanding of URL patterns would be adva...
I am seeking a skilled developer fluent in Solidity to develop a web3 smart contract using the Base Sepolia Test Net. Your task will involve: - Developing web3 integration - Designing the simplest UI possible Ideal candidates should have previous experience with Ethereum blockchain technology, Solidity programming distinct to the Base Sepolia Test Net, and the creation of adaptable user interfaces. A background in web3 integration is highly desired. Please provide samples of smart contracts you've developed or relevant project references in your bid.
...potential security breaches. - Log Gathering: I'll need the app to effectively and securely gather logs from IoT devices. - Access Control Management: It should have the ability to manage and control access to the security system. Logging Mechanism: - The application should be able to log activities from sensors and smart home devices effectively. Ideal skills and experience: - Strong Python programming skills, coupled with experience in security applications. - Proficiency in designing and implementing robust intrusion detection systems. - Prior work on IoT device integration and data gathering. - Experience in access control management is a plus. - Understanding of secure logging mechanisms. In your bid, please include examples of similar projects you've complete...