Excel daily inventory sheet jobs

...document formatting on a daily basis. - The data set for analysis falls within a medium range, with 100-1000 rows. This will require a keen eye for detail and a good understanding of data analysis techniques. - You'll also be responsible for formatting and editing my Word documents. This involves ensuring that the content is clear, well-structured, and aesthetically pleasing. I'm looking for a diligent professional who can provide me with daily updates on the data analysis. The ideal candidate should have: - Proficiency in Microsoft Excel and Word. - Previous experience in data analysis, particularly with medium-sized data sets. - Strong attention to detail and a good eye for formatting. - Excellent communication skills, as you will be required to prov...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will be key t...

I'm looking for an expert to develop a Bollinger Band Contraction Screener for Nifty 500 stocks. The screener should: - Analyze daily data from the last year. - Prioritize contraction/expansion patterns in Bollinger Band. Ideal candidate would be someone with relevant experience in financial market analysis tools, specifically in Bollinger Band analysis.

...links of competitors as examples and ideas of how other companies have done their websites. The WordPress theme I have chosen is “RENOVATE” from Theme Forrest. JOB REQUIREMENTS: 1. Install “Renovate Theme” and create the site structure and framework. 2. Work with me daily until the project is complete. (Constant Communication) SKILLS: • WordPress Expert • Revolution Slider • Permalinks • SEO – Search Engine Optimization • Photoshop for fast loading and high-quality images and video editing experience TIMELINE: I want this built preferably in 3 days with a max of 7 days. CONTENT AND PHOTOS: I will work with you to provide ALL content and photos

I'm seeking a professional who can revamp our operational management, training and supply chain management. - **Inventory Management**: - We're currently grappling with inventory inaccuracies, stockouts, and overstocking. I need someone who can help fine-tune our inventory management process, ensuring that we strike the right balance between overstocking and stockouts. - **Quality Control**: - We're facing challenges with defective products, inconsistent product standards, and supplier quality issues. The ideal candidate will be able to improve our quality control process, ensuring that our products consistently meet high standards. - **Production Efficiency**: - I require someone who can also streamline our production processes to enhance ov...

...thumbnails for a daily basis. The ideal candidate will have experience in both photo-based and typography-based designs. Key Requirements: - Daily creation of YouTube thumbnails - Design style: Bold and vibrant - Design types: Photo-based and Typography-based Ideal Skills: - Proficiency in graphic design software - Experience in creating engaging and click-worthy thumbnails - Strong understanding of YouTube design trends - Ability to work on a daily basis and deliver high-quality designs promptly The selected freelancer will need to understand the importance of creating eye-catching thumbnails that can entice viewers to click on my videos. A successful candidate will be able to maintain a consistent design style across all thumbnails while keeping them fresh ...

I'm seeking a meticulous data entry professional who can convert physical documents filled with text data into an Excel spreadsheet. Key Requirements: - Conversion of physical text data documents into an Excel spreadsheet - High level of accuracy and attention to detail to ensure the data is entered correctly - Ability to maintain data confidentiality - Must be able to meet deadlines Ideal Skills: - Proficient in data entry and managing data using Excel - Excellent attention to detail to ensure the accuracy of the entered data - Previous experience in handling sensitive or confidential information - Ability to meet deadlines and ensure timely delivery of the project - Strong communication skills to provide updates on the progress of the project

I am currently struggling with a specific issue in my App Sheet. The drop-down functionality isn't functioning as expected - it's not populating the correct values. I need assistance in making it work properly. The ideal candidate for this job would be an expert in App Sheet, with experience working with drop-down functionalities and troubleshooting them. Knowledge in data entry forms and calculations and formulas is a plus. To summarise, your job would be to: - Troubleshoot and fix the drop-down functionality in my App Sheet - Ensure correct values are populating in the drop-down list - Optimize for future efficiency and user experience. Please, only apply if you can demonstrate relevant past work in this area. We will collaborate closely to ensure the...

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

I'm in need of a designer who can create a visually appealing design for a stainless steel water bottle will be used by nurses. The look should be bright and colorful, suiting the bottle for everyday use. Key Requirements: - Design for everyday use: The design should be vibrant and visually striking, perfect for everyday use. It should be able to stand out and add a touch of fun to daily activities. - Stainless Steel Material: The water bottle will be made of stainless steel, so the design should be suitable for this material. It should be able to be applied to the steel surface without any issues. - Bright and Colorful: The style of design I'm looking for is bright and colorful. The aim is for the design to be visually appealing and eye-catching. This project requires...

I'm in need of a WhatsApp bulk messaging service that can handle sending more than 10,0000 messages daily, featuring a mix of text, images, pdf and videos. Additionally, the software should include a robust contact list management feature, allowing me to import and export contacts with ease. Ideal skills for this job include: - Proficiency in WhatsApp API usage - Experience in developing bulk messaging software - Strong understanding of handling media content (text, images, videos) via WhatsApp - Expertise in contact list management functionality Please note that the ability to handle large volumes of messages and diverse media types is crucial. Kindly provide examples of your previous work in this area.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I'm launching a supply chain start up and require a web app specifically designed for inventory management. The chosen freelancer should have extensive experience in the following: - Crafting web apps targeting supply chain management. - Designing a user-friendly interface, specifically a table view with detailed entries. - Integrating key details on the inventory table view, initially, the product name will be included. The prime objective is to achieve an effective inventory management mechanism through this web app. If you've had previous experience in this specific field and understand the ins and outs of inventory management in a supply chain context, your skills will be highly valued.

I'm launching a supply chain start up and require a web app specifically designed for inventory management. The chosen freelancer should have extensive experience in the following: - Crafting web apps targeting supply chain management. - Designing a user-friendly interface, specifically a table view with detailed entries. - Integrating key details on the inventory table view, initially, the product name will be included. The prime objective is to achieve an effective inventory management mechanism through this web app. If you've had previous experience in this specific field and understand the ins and outs of inventory management in a supply chain context, your skills will be highly valued.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document da...

I'm looking for a skilled operations management professional to assist me with a report that focuses on inventory management, supply chain management, and operations management. The main goal of this project is to: - Conduct a detailed analysis of inventory management and forecasting. - Utilize historic sales data and inventory turnover rate data to inform the report. - Provide insights into my current operations and identify areas where improvements can be made. Ideal candidates should have a strong background in operations management, with specific experience in inventory management and forecasting. Experience in supply chain management would be a plus. The ability to analyze data and present findings in a clear and concise manner is essential.

We have existing wordpress woocommerce and C# MSSQL inventory win application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need to work on remote zoom or ultraviewer ples...

Hello, i liked your work you did a few years ago for a christmas flyer. We need a concert flyer including a program sheet (on the backside) for our school orchestra's summer concert. Style: Clipart black-and-white/gray objects like dance foot prints and simple fonts. The goal is to copy the flyer on colored paper using a photocopier to keep costs low. The concert information is located on the back. Are you in? I would need it within the week.

I'm needing a data entry professional for a key analytical project. I have a database of records that needs to be analyzed. Although the complexity of analysis wasn't defined, at least the capacity for basic statistical calculations would be required. The freelancer should have the skills and experience to: - Enter, organize, and manage data - Conduct undefined level of data analysis - Work with database records Please bid if you understand and perfectly align with the project requirements.

We are in search of an innovative Virtual Assistant who can assist us in managing job postings and messaging on LinkedIn. Your role will be vital in helping us with daily job post and messaging. Key Responsibilities: - Job Posting: You will be tasked with ensuring our job posts are accurately displayed on LinkedIn, targeting potential candidates. - Messaging: Crafting and sending out one time messages to applicants Requirements: - No prior experience in specific industries is needed, anyone can apply for this role especially those who are starting out as freelancers. This position is crucial for maintaining our professional presence on LinkedIn and potentially expanding our network. If you're proactive, organized, and have a knack for networking, I'd love to hear from ...

I need a skilled professional to configure our ADAuditPlus software to perform a daily file audit for specific file types. Key Requirements: - The audit should focus on 'Documents' exclusively. - The reports should be generated daily. Additional Needs: - Real-time alerts are necessary for unauthorized access attempts, file deletions, and permission changes. Ideal Skills: - Proficiency in managing ADAuditPlus. - Strong knowledge of file auditing. - Experience in setting up and managing real-time alerts. - Familiarity with managing alerts for unauthorized access attempts, file deletions, and permission changes.

...product details and order history. The bespoke API features we're aiming for include: - Retrieving product details - Updating product details - Retrieval of order history We prefer a direct integration approach between Shopify and Power Apps, without any middle tier third-party service involvement. Specific data elements targeted for retrieval or updating via the API include: - Price changes - Inventory levels - Product descriptions Ideal Freelancers for this project should hold the following skills and experience: - Proven expertise in API development and integration - Extensive experience with both Shopify and Power Apps platforms - Solid understanding and proficiency in handling data types specified. Your bid should reflect your proficiency and experience in deliv...

I am looking for a freelancer to assist with typing content from scanned images into a PDF file. The content includes non-text elements, specifically images or charts. The project's main goal is to create a readable and professional PDF document. Key Requirements: - Proficiency in Copy Typing - Experience in handling scanned images - Ability to maintain the original format of the content - Attention to detail for accuracy - Familiarity with creating PDF documents Your work will play a crucial role in making this content accessible digitally. Please bid if you are confident in your ability to deliver a high-quality and accurate PDF document based on the scanned images provided.

I need someone to scrape data from google, instagram, linkedin and other platforms for my digital marketing agency and sending them mail campaigns and book meetings for the company. I am looking for someone on a monthly retainer. I need them to send at least 1000 mails daily and at least 1000 DMs on instagram

I have a PDF document that needs to be converted into a Microsoft Excel spreadsheet. The data in the document isn't complex, but it needs to be accurately typed into the spreadsheet. Key Requirements: - Convert a PDF document into Microsoft Excel format. - Ensure the data is typed accurately. Ideal Freelancer: - Proficient in typing and has excellent attention to detail. - Previous experience with data entry and copy typing. - Familiarity with Microsoft Excel.

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible changes...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.

...which includes website and apps for both Android and iOS. The portal should be able to efficiently enhance productivity and streamline business processes. Crucial components to be developed include: - Customer Relationship Management (CRM) with key features such as contact management, sales forecasting, and lead management. - Enterprise Resource Planning (ERP) with essential functions such as inventory management, order management, and supply chain management. - Financial and taxation modules. - Human resources and marketing modules. - Service and productivity modules. An ideal person for this job should have: - Proven experience in creating and managing business portals with similar components. - Proficiency in various programming languages for website and apps development...

I'm looking for a skilled individual who can manage our TIKTOK account to increase brand awareness. please start with checking Key Responsibilities: - Creating entertaining content on a daily basis - Monitoring and engaging with the audience - Ensuring brand consistency in all posts Ideal Skills and Experience: - Proven experience in managing TIKTOK accounts - Strong understanding of social media and content creation - Creative mindset with a knack for entertaining content - Ability to analyze and interpret data to optimize content strategy - Excellent communication and engagement skills to interact with our audience. Please share your relevant experience and the strategies you'd utilize to boost our brand's presence on TIKTOK.

I've a set of handwritten documents that need to be transcribed into a sheet - with a high emphasis on word-for-word accuracy. Key Requirements: - Source Material: Handwritten Documents - Accuracy: It is critical that the transcribed text is an exact replica of the source. - Formatting: The transcribed content has to be neatly structured within a standard table format. Ideal Freelancer: - Proficient in data entry, with exceptional attention to detail. - Experience in transcribing handwritten text. - Skilled in working with spreadsheet applications. - Ability to maintain high levels of accuracy and consistency throughout the task. If you're confident in your typing abilities and can meet the accuracy and formatting requirements, this could be a straightforward project fo...

I'm in need of a fitness expert who can develop a comprehensive personal training program sheet for my clients. The ideal candidate would have a strong understanding of exercise physiology and program design, as well as extensive experience in personal training. The program should cater for three main fitness goals: - Weight loss - Muscle building - Endurance training It should also cater to two levels of fitness experience: - Beginners - Intermediate The training frequency may vary, though it typically falls between 3-5 days a week. I need the program to be versatile and adjustable according to the individual's schedule. Include - Nutrition - Graph for progress (weight, fat percentage, habit tracking, calories/steps calculator) whether fitness watch can be attached...

I'm seeking a computer science tutor to guide me through QuickBooks and Excel. - Topics include QuickBooks, Excel, data structures, algorithms and programming languages. - Primarily need help with data entry and organization in QuickBooks and Excel. - Additionally, assistance with Formulas and Functions in Excel is required. Ideal candidate should have: - Proficiency in QuickBooks, Excel and knowledge of data structures and algorithms. - Strong background in programming languages. - Experience in tutoring or teaching will be a plus. Please note that the volume of entries or rows of data is minimal, less than 100. Looking forward to your proposals!

I'm urgently in need of a developer proficient in Amazon Seller Partner (SP) API with a specific focus in data retrieval. This expert should be able to: - Extract order details - Retrieve product inventory - Generate sales reports Due to the urgency of the tasks, I need this project to be conducted as soon as possible. Interested freelancers should have a strong API skills and experience using Amazon SP API.

Are you looking to master SQL, Excel, or Python? Look no further! With years of experience in data analysis and programming, I offer comprehensive tutoring services tailored to your learning needs. **What I Offer:** 1. **SQL Mastery:** From basic queries to advanced database management, I'll guide you through understanding SQL syntax, optimizing queries, and database design. 2. **Excel Expertise:** Whether you're a beginner or looking to enhance your Excel skills, I'll cover everything from formulas and functions to data visualization and automation. 3. **Python Proficiency:** Dive into the world of Python programming with personalized lessons covering fundamental concepts, data manipulation, scripting, and more. **Why Choose Me?** - **Tailored App...

I am looking to have a discounted cash flow model created in Excel for property valuation analysis This task should not take long to complete as all data and parameters are given Key Requirements: - Input Data: The project will require the use of the property data, - Model Parameters:DCF model will be for 10 years - Excel Model: The freelancer is expected to use the document provided and complete the rest of the remaining data. They will then be required to fill this in the Key Assumptions (Sheet 1) The ideal candidate for this project will have: - Proficiency in financial modeling, specifically in creating discounted cash flow analyses. - Expertise with Excel and a strong understanding of property investment principles. - Clear communication skills, as they...

...sequence of "AAA" substring images they wish to view—either the first, second, or third occurrence. The program will enable users to assess the quality of the Part B images and proceed to update both the Part A image and its associated Part B images by selecting and clicking "Next". This iterative process will continue until all images have been reviewed. Subsequently, the program will generate an Excel sheet containing the user's quality assessments in the third column. Overall, the program aims to streamline the evaluation process, allowing users to conveniently navigate and assess image associations while providing a comprehensive overview of their quality assessments for further analysis. - Using Python and CherryPy to develop the tool - ...

I'm seeking an experienced PowerApps developer to assist in creating a system for daily information management. - Data Formatting: The information will consist mainly of text fields, numeric data, images or multimedia, and a predefined set of choices. - User Interface: The system should offer a user-friendly interface for data entry and management. - Data Storage: The daily information should be saved to a centralized excel or table, allowing all authorized users to access the data at any time. The ideal candidate for this project would have prior experience in PowerApps development, particularly in creating systems for data management and user input. Experience with integrating PowerApps with Excel or other databases would be highly valuable.

I'm looking for a capable designer who can create a modern ...must be modern in style - The final deliverable should be in a word or excel format to allow for editing Content: - The title card should include the song title and artist in the right portion - A photo element should also be incorporated for visual appeal in the left portion. I'd like a card similar to the one you see here. It's exactly 18cm wide x 12cm high. However, the photo portion should be smaller, as the text does not contain the Artist, which I need. I have attached some examples here. Photos # 4 5 and 6 are from my actual machine. I need to edit and make 100 of these. There should be 22 columns on the right side for the Number Title and Artist text. Ideally, I would like to fit 2 to a...

...for a freelancer talented in conceiving, creating and managing Instagram reels. I aim to engage with my audience daily, bringing the elegance of real estate to their screens each day. Key Responsibilities: - Developing Instagram reels content on a daily basis - Content should be engaging and relatable, set to amplify daily engagement with the audience - My focus is property-tour based reels Ideal Candidate: - Exceptional ability to create compeling, high quality reels daily - Experience in real estate or related field is a plus - Proven track record of improving Instagram engagement using reels - Must be punctual and meet deadlines as content needs to be delivered daily. This is an excellent opportunity for freelancers looking to showcase the...

I'm looking for an expert in both hotel inventory management and revenue management to boost our hotel's performance. Key tasks would include the following: - Oversee and optimize our inventory management process - Assist in strategizing to increase hotel occupancy rates - Maximize revenue per available room (RevPAR) - Implement revenue management strategies Ideally, you should have a strong understanding of hotel revenue management principles and strategies. Experience with data analysis and pricing strategy is also beneficial, as we have access to important data such as: - Historical booking data: An understanding of past performance could help inform our future strategies. - Competitor pricing information: Aware of our competitor's tactics, you'll b...

...but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in t...

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

As a budding R&B/hip-hop artist, I'm looking for an experienced individual to guide me through the next steps of my music career. I've officially released close to 50 songs, but they haven't gained the traction I was hoping for. In particular, I need help with: - **Social Media Promotion**: I'm active on Instagram, Facebook, and TikTok, posting daily. However, I believe there is still untapped potential in promoting my music on these platforms. I'm looking for strategies to increase my engagement, reach a wider audience, and eventually go viral. - **Artist Branding**: I understand the importance of having a unique and consistent brand as an artist, but I'm struggling to define mine. I need guidance on how to create a strong personal brand that res...

I am in need of an excellently crafted web form that can carry out addition calculations. The main purpose of this form is to accurately calculate the cost of chosen servi...system should be able to add up the costs of selected services. - Data entry: Your form would need to support product selection-based data entries. - User interface: the form should be easy to navigate, with clear instructions for inputting service choices. Ideal Candidate: - Proven experience in designing excel forms with integrated calculation logic. - Ability to design a user friendly interface. - Eye for detail, as the calculator must produce very accurate results. - Strong knowledge of Excel features and data calculation techniques. - Excellent communication skills to understand requirements and del...

I need a Google App script that can scan a specific folder on my Google Drive for files and process them. The processing should involve an api that will skip tracing by first name and last name, if that returns no results then by company name, or if that returns no results then by property address to find the email. Once the email is located append it to the row in column AW. Once completed, prefix “processed_” to the file name. Api to use: skip force Key Requirements: - The script should be able to scan a specified Google Drive folder for files. - When a file is found, the script should process it by skip tracing. This involves cross-referencing the information in the file with first names and last names, company names or property addresses. - The script should be able to...

Hello. I have a written song draft and would like to have someone to sing it and record it in acoustic version, either accompanied by piano or a guitar. Some parts perhaps need modification, so it would be ideal to work with someone who has experience in this domain. The output does not need to be high production, but still a good demo. ...record it in acoustic version, either accompanied by piano or a guitar. Some parts perhaps need modification, so it would be ideal to work with someone who has experience in this domain. The output does not need to be high production, but still a good demo. The lyric are in Croatian, therefore it needs to be someone from the surrounding countries or living abroad but speaking the languages. The sheet music is in the attachment and a sample of s...

I'm seeking a proficient Excel expert who can assist me with enhancing my current study time tracker. I need the following features to be incorporated: - Auto-calculation of total study hours: I'd like for this to be automatically summed up based on the inputs provided. - Auto-calculation of average study hours per day: This should also be done automatically, providing me with a clear view of my daily commitment. - Study hours per subject: I require a part of the spreadsheet to allocate study hours to specific topics that I am learning. The spreadsheet will be utilized for tracking my study progress across different subjects. It should allow for easy input of study hours and materials covered. I will provide the current version of the spreadsheet to the chosen ...

...task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to move the data from the Excel files in the &...