Excel create database summary table jobs

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...

...date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL -> PHPMyAdmin. Here, you can directly view and edit the data in your tables and ensure that all date and time values are correctly for...

I am looking for a skilled Elasticsearch expert to help with data indexing and analysis for a large dataset. The data to be indexed is primarily textual and it is sourced from database entries. Experience with database management and textual data analysis is a crucial requirement for this project. The primary tasks include: - Analyzing and indexing a large dataset from database entries - Setting up Elasticsearch for efficient data analysis - Implementing indexing strategies for textual data Proficiency in Elasticsearch, data indexing, and database management is benefit for this project. Familiarity with handling large datasets and textual data is a must.

Flutter version: 3.22 We want to add our own Sqlite database to assets: assets/ name of table: kids Database included id – name – surname I can send my database. We need a file () that shows database information after clicking a button.

I'm seeking a data entry specialist with a knack for precision to type data from PDFs into an online database. Key Requirements: - As a data entry specialist, you will be responsible for the accurate and timely entry of data from PDFs into our online database. - The data format should match the original PDFs, with no specific validation rules needed. - The ideal candidate will be detail-oriented, with a proven track record of data entry. If you're someone who enjoys working with data and has an eye for detail, this could be an ideal project for you.

I'm seeking an experienced graphic designer who can create a stand-up banner and table cloth designs based on an existing PSD template. The project involves: - Designing a large stand-up banner and table cloth (8ft x 4ft) - Adhering to the provided PSD template style The final deliverables should be: - High-quality and print-ready designs - Utilizing the existing template while introducing new and creative elements - Designs should be suitable for a large format and visual from a distance As I'm not familiar with the printing terminology, I'll need you to ensure the design includes what is needed for a professional print job. Ideal skills and experience for this job include: - Proficiency in Adobe Photoshop/Illustrator - Experience in large format ...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

Description: I require a one-time conversion of my QuickBooks accounts into the iBRXL format, specifically at a summary level. Although I already have the accounts in iBRXL format, there are errors in the current version due to software issues, necessitating resubmission. Requirements: Convert QuickBooks account data to iBRXL format Ensure data is at a summary level Correct any existing errors from the previous software conversion Provide a final, error-free iBRXL file ready for submission Ideal Skills and Experience: Proficiency in QuickBooks and iBRXL format Strong attention to detail and accuracy Experience in data conversion and error correction Ability to deliver a high-quality, error-free file promptly If you have the expertise to perform this conversion and correct t...

Just create 2 api to pass value. WOrk with ftp only. Simple work

I'm in need of a professional who can assist in documenting the Microsoft Teams Enterprise Voice solution. The main objective of this documentati...documentation on complete set up of Microsoft Teams to use as Enterprise Voice solution (EV) - help with documenting EV solution. You will assist in formulating a MS Word document containing summary, hardware and software requirements, recommendation, architecture , license etc - in summary, if we want to set up Teams as EV, what I will need and how do I present it to manager with all details and recommendation? Thanks Other: support until task is completed Ideal Skills: - Strong understanding of Microsoft Teams Enterprise Voice solution - Experience in documenting technical solutions - Ability to create user-frie...

I need my accounts from QuickBooks converted into iBRXL format. This is a one-time job and I only need the data at a summary level. I already have the accounts in iBXRL but there are some errors in the software used that mean they have to be resubmitted.

I'm looking for a skilled developer to create a sophisticated web application for my restaurant. The app will need to be compatible with desktops, mobile phones, and tablets. The main functionalities I need are: Develop a Restaurent app to host multiple restaurents Please provide estimated budget - Table Reservation: A feature that allows customers to book a table in advance. This should be user-friendly, ensuring a smooth reservation process. - Menu Recommendation: An AI module that can recommend dishes to customers based on their preferences and previous orders. - Order Taking: The web app should facilitate online ordering, ensuring a seamless experience for customers. - Onboard restaurents - Data fetch from Toasts and other POS - Predictive Cost of good so...

...and expertise Integration with for website building and design Using 's: About page template Team member template Services: Detailed descriptions of IT services offered, including: IT Consulting Microsoft Premier Support CSp Support Service pricing and packages Integration with for website building and design Using 's: Services page template Pricing table template Resources: Blog for company news, industry insights, and thought leadership Case studies and success stories Whitepapers and e-books Integration with for website building and design Using 's: Blog template Resource page template Contact: Contact form and email address Phone number and physical address Social media links (setup and integration with social media accounts)

I am...creating a compelling business plan specifically designed to appeal to investors. The main portion I need assistance with is constructing a persuasive and highly informative Executive Summary. Ideal skills for this job would include: - A deep understanding of what investors are looking for. - Extensive experience in crafting business plans, particularly the Executive Summary section. - The ability to interpret and present my business concept in a convincing manner. When submitting your bid, please include examples of business plans you've created to attract investors, especially any portions of an Executive Summary you've written. Your understanding of the investor viewpoint and your ability to communicate that effectively in a business plan will b...

I'm looking for a skilled WordPress developer who can create a custom plugin for me. This is the basic summary: A wordpress plugin interface in which users of the website can enter one prompt, and it will automatically generate the “results” from three different providers (e.g. Chat GPT, Claude, Llama). The “results” from each will be displayed all on one page with a smooth UX for a user to easily distinguish between the three. Message me for more/full details!

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals.

Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.

I need some to create a letter head and upon completion i need editable word file and print ready file

... and will have a particular focus on energy efficiency. Key Responsibilities: - Full Exterior and Interior Design: This car needs to be visually appealing, and project a modern, sleek, and commercial image. - Mechanical and Electrical System Design: We need a team with a strong focus on engineering, able to create systems that are energy efficient and innovative. - Innovations: This is an important aspect of the project. We're looking for a team that can bring fresh ideas to the table, with a particular interest in self-driving capability, voice control assistant, wireless charging, advanced safety features, and an innovative AutoCharging system using the car's tire motor. Ideal freelancers for this project should have experience in: - Industrial design and 3D ...

...producer who can create a highly complex and experimental beat for my upcoming EDM trap dubstep song. The beats should be energetic and upbeat, delivering a blend of intensity and rhythm that will captivate my listeners. Key Requirements: - The beats should be crafted using electronic effects and samples, reflecting a modern and edgy sound. This element is crucial to the overall vibe of the track. - The beat structure should be highly complex and experimental, pushing the boundaries of conventional EDM trap dubstep beats. I'm looking for something that stands out and excites. Ideal Skills and Experience: - Proven experience in producing EDM trap dubstep music with a portfolio of energetic, experimental, and upbeat tracks. - Proficient in using electronic effects and sampl...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implem...

...automate a complex process. As of now, I manually gather numerical data from a variety of unstructured sources like images, text, and PDFs. This data includes formulas and is stored both on my local computer and the web. At present, I get ChatGPT to convert this data into a table which I then paste into excel. I do calculations in excel to find out what percent each ingredient is of a total formula. Then I create a new entry into a table in Airtable and paste this data into a different table in Airtable which references the first table. I need someone to automate this data extraction process, calculations and entry into two separate Airtable tables so I can do it repeatedly myself. I work in a standardised operating environment for work s...

...Description: We are seeking a talented designer to create a visually stunning, engaging, and informative page that highlights our distinctive vanilla cultivation and preparation process. The page should take viewers on an immersive journey through our vanilla's lifecycle, from the lush fields of Maroantsetra, Madagascar to the final crafting of our premium product. The designer should use the attached infographic, process flow diagram, and vanilla cut styling guide as visual references to creat our own infographic ou design steps shaping the page's content and design. These resources provide comprehensive details on our process, including key steps, techniques, timing, and quality control measures. Project Goal: The ultimate goal is to create a page that educa...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...

...content is primarily parents. Key Responsibilities: - Create engaging social media content and marketing videos - Ensure the content aligns with the brand's goals of awareness, sales, and education - Tailor the content to appeal to parents specifically - Edit and enhance existing video materials as necessary Ideal Skills and Experience: - Demonstrable experience in creating diverse and engaging social media content and marketing videos - Proficiency in video editing software - Understanding of effective content strategy and its applications across different platforms - Knowledge of the parent audience and how to cater to their needs and preferences I'm looking for someone who can bring creativity, originality, and technical expertise to the table to help grow ...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

I am searching for a proficient web developer who also has experience managing eCommerce platforms such as Flipkart and Amazon. The primary task is creating a website from scratch intended for product sales, with clear and appealing design, optimised for conversions and customer ease of use. Key Tasks: - Design and construct a new website for product sales from scratch. - Optimize for user-friendly navigation, SEO, and product presentation. The ideal freelancer for this job will have: - Proven experience in creating successful eCommerce websites. - Strong knowledge of site design, user experience, and SEO principles. - Previous experience managing Flipkart or Amazon product listings is beneficial. - Understanding of inventory management on eCommerce platforms. Make your bid if you ar...

Task 1: Write dynamic programming and recursive programs for a given problem obtained from 4 practical task selection test. • Implement a recursive program to solve the given problem. • Analyze time complexity of the recursive program (brute force) and dynamic programming approach using Big O and Omega notations. • Implement a dynamic programming approach by defining a table to store previously calculated values and using them to compute the next value in the sequence. Write recursive solution. • Test both programs for different input sizes and compare their performance. Task 2: Parallelize the algorithms for the second and third recursive equations obtained from the 1 practical selection test, and also parallelize second and third algorithms obtained from th...

I'm looking for a skilled developer to create a robust mobile application that offers real-time translation capabilities and includes an AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Nativ...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I need you to go into my Clickfunnels account and make a simple video landing page. However i need to have a purchase button that drops down at a particular time point in my video. You must have extensive experience in Clickfunnels because i will utilize you in the future for more complicated pages within Clickfunnels

I am in need of a skilled web developer to create a web application to display my events and deadlines. I'm looking for a monthly view for a personal user experience. The project will require a developer who's experienced in creating user-friendly, visually appealing web applications. Key requirements: - A monthly calendar view, that is easily navigable and intuitive for personal use - Ability to clearly display a range of different events and deadlines - A clean and modern design that is mobile responsive, as most of my users will be accessing the app on their phones - Some experience with event scheduling software would be a plus I appreciate any insights or ideas that you can bring to the table. I'm looking forward to seeing your proposals.

I'm in search of a skilled Python PHP developer with experience in backend development. If you have a good grasp of Python and backend systems, this project is for you. Essential skills and experience: - Proficiency in Python PHP - Proficiency in Firebase MySQL - Experience in developing real-time features like live chat and notifications Ideal candidates will have: - Strong communicat...Experience in developing real-time features like live chat and notifications Ideal candidates will have: - Strong communication skills - Experience in developing and maintaining a reliable backend system - A keen eye for detail and the ability to troubleshoot and solve problems quickly If you think you're a good fit for this project, please get in touch. I'm excited to see what you can b...

...power electronics product for industrial use. The current stage of development is in the prototype phase. For this project, I need a skilled professional who can help me with the following: - PCB Prototyping: I require assistance with the creation of the PCB for this new product. This includes the manufacturing of the board itself. - Creation of Test Plans: I need an expert who can help me create comprehensive test plans for this new product. This includes both hardware and software testing. Experience in creating test plans for electronics, would be highly beneficial. - Final Testing & Validation: Once the PCBs are produced and the test plans are in place, I would need a professional who can assist me in the final testing and validation of this new product. This include...

...in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Exc...

...alia, provide a brief about all the issues you wish to discuss in the body of the essay. •This is your roadmap to the essay. It tells the examiner where you are going and how you plan to get there. of essay: •Discuss all issues you have already identified in the introduction. •You should divide the body of the essay into sections, and, possibly, subsections. : •This should be a summary of the conclusions on issues you have discussed in the body of the essay. your discussion with: •Academic authorities – i.e. books & peer reviewed papers (at least 7 references). Support your discussion also with cases. A variety of sources should be used. discipline: •Writing a good essay involves knowing what to include and what to leave. •All sourc...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm looking for a skilled graphic designer who can help me create a logo for my brand. There are a few things I need to be considered in this project. - Logo Design: I'm looking for a logo that truly represents the essence of my brand. The design should be creative and memorable, while also being versatile enough to be used across various platforms. - Branding Elements: I'm in need of a complete branding design, which includes a color scheme and the selection of fonts. The branding elements should complement the logo and create a cohesive and consistent visual identity for my brand. I am open to suggestions regarding the logo design, and would appreciate a designer who can bring fresh and innovative ideas to the table. Ideal candidates for this projec...

...complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PHP file should be able to successfully communicate with the MySQL ...

We are seeking a talented animator to create a captivating 1-minute video showcasing our innovative transportation solution. This project involves animating a shuttle moving through a tube, aiming to revolutionize how people and goods travel. The animation will serve as an introduction to our invention to the general public, highlighting its unique features and benefits. *Requirements:* - Experience in creating engaging animations, preferably with a portfolio showcasing similar projects. - Proficiency in Blender, as the models for the shuttle and environment are pre-designed and available in Blender format. - Ability to convey the concept of futuristic transportation vividly and convincingly to a general audience. - Creativity in animation to ensure the final video is intriguing a...

I'm in need of a talented financial analyst to create a robust underwriting model for a multi-family property. Key Requirements: - Develop a comprehensive underwriting model for a multi-family property that will assist in calculating the internal rate of return (IRR) and equity multiple. - This model should also include waterfall projections that cover profit splits, with and without preferred returns. Additionally, I require a clear, user-friendly format that is easy to understand for someone without an extensive financial background. The ideal candidate for this project should have a strong background in finance, specifically in multi-family real estate. In summary, the main deliverables for this project are: - Underwriting model for a multi-family property - ...

I'm in need of a realistic apparel print for tee shirts, featuring a unique scene. The artwork should be in portrait style and include a group of animals - specifically a shark, tiger, golden bear, black knight and rainbow umbrella. This group will be depicted at a table, enjoying cigars and sipping glasses of scotch. The background for this scene should resemble a men's club, giving the impression of a sophisticated and exclusive setting. Key requirements: - Realistic artwork style - Unique and engaging animal choices - Men's club background

We are a curly hair ecommerce in Italy and we are looking for a AR beauty experience professional to create this type of videos We need Someone to add in our team who brings unique set of skills and idea to the table. We only have products pictures so the animate of the product will be recreated from a 'fake 3d' of the .png image You must find the video to use free from copyright

I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets API - Web development (specifically embedding ...

I'm in need of a skilled photographer with their own studio or location to take professional photos of a variety of home decor items for my ecommerce website. Requirements: - The products that need to be photographed include bedsheets, pillow cases, cushion covers, table covers, and mats. - The photography should be done in a studio setting. - The photos will require color correction, but background removal is not necessary. Ideal skills and experience for this job include: - Prior experience with product photography - Proficiency in studio photography - Strong understanding and experience in color correction techniques - An understanding of e-commerce photography standards - Attention to detail and creative flair for achieving appealing product shots. This project is...