Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2023, 10:09 AM
Oluagbe1 Oluagbe1 is offline Automation of Performance Analysis Windows 10 Automation of Performance Analysis Office 2019
Novice
Automation of Performance Analysis
 
Join Date: Feb 2019
Posts: 8
Oluagbe1 is on a distinguished road
Default Automation of Performance Analysis

Greetings to you.
Please find attached the spreadsheet with 3 sheets.
Sheet one is 1st score book, sheet two is 1st analysis while sheet three is 1st Broadsheet
The problem I am trying to solve is on both sheet two and three.
Now on sheet 2 which is 1st analysis is am trying to populate all the columns and the values to use are all in sheet 1 which is the 1st score book


REGISTERED: to populate this, we will use all students registered for each class i.e (Jss 1, Jss 2, Jss 3) regardless of whether the student took the exam or not. Male, Female and the addition of both gives us the total for that class

PRESENT: Here, we will only capture the students that participated in atleast one exam or more (Male, Female and addition of both gives the total)

ABSENT: Here, we will capture only the students who were registered but did not take any exam (Male, Female and addition gives the total)

No. of student that passed with 50% average including ENGLISH & MATHS: To calculate this, we will use 3 criteria from the sheet one which are; the student must have 50% and above in English, Maths and the total percentage in column “BS” must also be 50% and above.

OTHERS: these are all other student that does not meet the previous criteria.

% PASS: the formula for this is TOTAL of No. of student that passed with 50% average including ENGLISH & MATHS divided by Number PRESENT Multiplied by 100

Please note: the addition of Number PRESENT, Number ABSENT, No. of student that passed with 50% average including ENGLISH & MATHS and OTHERS MUST be equal to Number REGISTERED

When we are done with this 1st part, I will explain the 2nd part so we don't get overwhelmed.

Thank you for assistance.
Attached Files
File Type: xlsx msoff.xlsx (53.8 KB, 3 views)
Reply With Quote
  #2  
Old 11-28-2023, 05:41 PM
zpy2 zpy2 is offline Automation of Performance Analysis Windows 10 Automation of Performance Analysis Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

Can you show some expected result according to your raw datas?
I am not clear about your need.
Reply With Quote
  #3  
Old 11-29-2023, 05:15 AM
p45cal's Avatar
p45cal p45cal is offline Automation of Performance Analysis Windows 10 Automation of Performance Analysis Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

See attached attempt
Quote:
Originally Posted by Oluagbe1 View Post
OTHERS: these are all other student that does not meet the previous criteria.
I don't know which are the previous criteria so I've left that out.

Quote:
Originally Posted by Oluagbe1 View Post
Please note: the addition of Number PRESENT, Number ABSENT, No. of student that passed with 50% average including ENGLISH & MATHS and OTHERS MUST be equal to Number REGISTERED
At first sight, that seems impossible (unless everyone fails)!
Attached Files
File Type: xlsx msofficeforums51696msoff.xlsx (54.2 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
word to pdf conversion performance wtopdf Word 3 11-29-2018 12:05 PM
Solver Add-in to find max performance Solver_Problem Excel 1 03-13-2017 12:24 AM
Automation of Performance Analysis Office '03 + '07-->Performance? markg2 Office 1 08-04-2011 06:09 AM
Project 2007 Macro Performance RMarsh Project 0 07-14-2011 03:32 PM
Performance of MS Office 2007 Eraser Word 0 01-21-2009 06:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft