Excel database form bookงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถแก้ใขข้อมูลทั่วไปของนักศึกษาได้ เช่น เกรดเฉลี่ย รายวิชาที่เคยเรียน อาจารย์ที่ปรึกษา 1.3 สามารถอัพเดทหรือแก้ใขข้อมูลทั่วไป 1.3.1 สามารถอัพเดทหรือแก้ใขกิจกรรมหรือข้อมูลข่าวสารได้ 1.3.2 สามารถอัพเดทหรือแก้ใขข้อมูลทั่วไปเกี่ยวกับคณะได้ เช่น แผนการศึกษา ค่าเทอม 1.3.3 สามารถอัพเดทหรือแก้ใขข้อมูลการติดต่อได้ 1.3.4 สามารถอัพเดทหรือแก้ใขระบบหนังสืออิเล็กทรอนิกส์ (E-Book) ได้ 1.3.5 สามารถอัพเดทหรือแก้ใขระบบบริจาคเงินได้ 1.4 สามารถสืบค้นข้อมูลนักศึกษา/บัณฑิตได้ 1.4.1 แสดงรายชื่อนักศึกษา/บัณฑิตจากการค้นหา โดยข้อมูลที่แสดง ได้แก่ - รหัสนักศึกษา - ชื่อ-นามสกุล - สาขาที่ศึกษา - ปีการศึกษาที่เ...
...สามารถ 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. มีระบบ...
ทำ 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
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unl...
Here's the next book. Please accept it and I'll set up the payments and send you some information.
...mobile. Our audience falls within the young adults and working professionals demographics, so it's crucial that the site is fully optimized for mobile viewing. - Easy to update: I need to be able to easily change things on the website in the future. - URL parameters: The website is highly transactional, I need to be able to handle URL parameteres in order to be able to tell the sources people use to book our tour Ideal skills and experience: - Proven track record of successful web design and branding projects - Proficiency in UX/UI design - Experience in optimizing websites for speed and mobile responsiveness - Understanding of design principles and branding - Strong familiarity with target audience centered design. Please include examples of your previous work in your p...
I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in da...
WordPress & Database Speed Optimization required : 1- Database optimization as one of my plugins is sending queries to DB - some time causing connection Error - or unreachable host Error. 2- Without CDN if possible 3- Including Premium plugin - I have 10 web booster Pro subscription. - If required. 4- Automatic Photo Optimization 5- Permanent solution. 6-Minification - if required. Urgent start up required, who is free and can finish asap.
I'm looking for a skilled data analyst to help me with a comprehensive statistica...comprehensive statistical analysis of a survey I conducted with roughly 100 participants. Key Requirements: - Proficiency in Descriptive, Inferential, and Correlation data analysis techniques - Experience in interpreting survey data to identify trends and patterns - Ability to test hypotheses and make inferences - Knowledge of how to determine relationships between variables - Excellent skills in Excel and/or other statistical software or python for data manipulation and analysis Ideal Candidates: - A data analyst with a proven track record of handling survey data - Someone who can derive meaningful insights from the data - Excellent communication skills to explain the results in a clear and...
I am in need of a detail-oriented individual to help with a data entry project. This i...detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Ex...
...the aesthetic of DC Comics. Key Tasks: - Develop detailed depictions of well-known DC Comics characters - Batman, Wonder Woman, Superman, Tim Drake, Michael Holt, Vic Stone, Dr. Fate The Spectre, among others. - Be innovative and bring to life an entirely different plot, not adhering to any particular DC Comics series or storyline in terms of events. Ideal Candidate: - Proven experience in comic book or graphic novel artwork. - Familiarity with DC Comics' artistic style and character design. - Ability to deliver high-quality graphics while respecting copyright and intellectual property rights. - Exceptional creativity and innovation, ensuring the originality of the plot. Immerse yourself in a distinct project that requires a balance of adhering to the traditional DC Com...
Please fix my task that we spoke about
I'm in need of a detail-oriented editor and designer to polish and enhance my children's book. Key Requirements: - Proofreading and Grammar Correction: The text should be meticulously checked for errors and polished for clarity. - Formatting and Layout Design: I'm looking for someone who can enhance the book's layout, making it more engaging and appealing for young readers. The primary goal of this project is to enhance the readability and coherency of the book, making it more enjoyable and impactful for its target audience. Ideal candidates for this project will have: - Prior experience with editing children's books or similar texts. - A strong eye for detail and a knack for creative design. - Excellent English skills and a keen understanding of ...
I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and integrated. Please bid wit...
Hi Arif -- I have a really quick job -- you created a logo for me awhile ago -- I need the logo updated so it has a 2" round edge, and the dates are 2019-2023 (from 2022), and the "Information Security Book" is changed to "Cybersecurity Book." I also need another logo, that says "#1 HOT NEW RELEASE" and "Information Security Book 2019-2022 is replaced by "November 2023" But, I need these logos TODAY. Can you deliver on that? Should be quick changes.
...a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of ...
I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic f...
I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. Experience in mergers...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.
I have a complete book manuscript that I need help with. My main issue is with the headers and footers. Key Tasks: - Formatting: I require assistance in formatting the headers and footers of my book. I want each chapter to have its own unique header and footer. Skills Needed: - Proficiency in Microsoft Word is an absolute must to undertake this project. Experience with long-form documents in Word would be a plus. - Understanding of book formatting, particularly when it comes to headers and footers. - Good organizational skills to keep track of the different headers and footers for each chapter. I'm looking for someone who can give me a polished, professional final product. The ideal candidate should have previous experience in book formatting...
I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.
...seeking a professional designer who can craft a realistic and inspirational book cover for me. The design should: - Evoke a sense of inspiration in potential readers. - Have a realistic visual style, not abstract nor minimalistic. - Integrate specific elements into the design, such as depictions of potentially active people and money symbols. Ideal Skills and Experience: - Proficiency in graphic design, particularly in creating realistic artwork. - Proven experience in book cover design. - Ability to infuse storytelling into design. - Ability to effectively incorporate specific design elements. - Knowledge of visual design principles that create inspiration and aspiration. Please include previous examples of book cover designs, particularly those of a similar re...
...goal is to make the content searchable, enhance its readability, and store it as HTML in a knowledge database. The PDF contains footnotes that should also appear as superscript in the text in the HTML. The content of the footnotes should appear at the end of the HTML, preferably as a link to the referenced footnote in the text. Please also note that umlauts should be displayed correctly in the HTML. Your responsibilities will include: - Converting the entire journal and Book to HTML format while applying consistent styling - Ensure that the HTML results in consistently formatted, easy to read and searchable continuous text - Provide the HTML so that it can be imported into a knowledge database. -A programme or script that can also be used to convert the journal ...
The winner will be paid the $50 prize and selected to illustrate a 32-page children's picture book for an additional $1,500. May involve single-action animation for e-books. Will be published through Amazon KDP with a trim size of 8.5" x 11." I was going to do 11" x 8.5" but heard this isn't an option with KDP. My book is aimed at children ages 5 to 8 years old. I don't have a specific visual style in mind so for this contest, submit a book cover illustration using the story details below. A.I. GENERATED IMAGES WILL BE REJECTED. Story Details: The the story takes place in a world population with anthropomorphic tools (i.e., no people). When a storm blows a tree down trapping the mayor and town council in the town hall, everyone trie...
My Drupal site is a single module site that has a single form page. it requires the module to be upgraded to Drupal 10. I also envision minor design updates on the aesthetics, but not an entire makeover. The site only has ONE custom module that is a form which requires porting over to the new drupal 10 site. The form updates a db table, but that table will remain the same and the same existing queries can be used. The theme can the default one. -**Design Updates**: A few enhancements to the website's look are needed, making it simple yet appealing. Full understanding of Drupal 6 and 10 is crucial. The freelancer should also have prior experience in site upgrades. you must have a good understanding of english. I am expecting a reasonable quote for the simple ...
I'm currently seeking a skilled database specialist who can write sql query and can give me ai free report around the entity relationship diagram and normalisation. I need a 2000-word report + 15-20 slides presentation Objective: This assignment aims to enhance your understanding of database design through the practical application of Entity-Relationship Diagrams (ERD) and normalization techniques. You will work in groups to design a database system that is both efficient and scalable, addressing a real-world problem scenario provided below. Assignment Scenario: Your team has been tasked with designing a database system for one of the scenarios listed according to your group number; if you are in group N, you must choose scenario N. For example, Group 10...
I need help with my accounting and auditing tasks, including bookkeeping, financial statements preparation, and internal control evaluation. I'd like to include 1 year of financial data in the statements. I require a professional with the following skills: - Proficiency in QuickBooks, Xero, and Excel spreadsheets - Experience in bookkeeping - Preparing financial statements - Evaluating internal controls Your role will be crucial in ensuring that my financial records are accurate and compliant with accounting standards.
