[Show all top banners]

aalukojhol
Replies to this thread:

More by aalukojhol
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Refresh page to view new replies
 Please Help on Excel or Google spreadsheet
[VIEWED 4318 TIMES]
SAVE! for ease of future access.
Posted on 06-02-16 3:19 PM     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 



Hello all, I am trying to implement google spreadsheet in a project, I need your help if you have knowledge about it

The spreadsheet I will collect from students will look like this, I need formula which will calculate the workload automatically, if the workload is as below

Work load

Chemistry I = 6      physics I = 7     Biology I = 5

Chemistry II = 8    Physics II = 8     Biology II = 6

Chemistry III = 9  Physics III = 10     Biology III =8



What I am trying to achieve is that I will send google forms and student will response me back on what classes they are taking this semester. It will be saved into my google spreadsheet automatically once they submit the form. I want to give work load number of each subject as above. How do spreadsheet or excel can automatically calculate the workload above? What kind of logic should it use? I was thinking something like below


First give value to each subject of column A

If column A = chemistry I, value = 6, if column A = chemistry II, value = 8 ……… if column B = physics I, value = 7 …………., If column C = Biology I, value = ……. And so on

whenever a student submit the google form, then add values of column A , column B and  column C and put it in column D. 

I know it might be doable, but I don’t have any experience

using logical formulas on spreadsheets, any ideas friends? It will mean a lot to me, thanks in advance

 


 
Posted on 06-02-16 3:55 PM     [Snapshot: 28]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

#1. Prepare a mapping sheet with Subjectname and their weight
#2 on column D, use Vlookup with previously created mapping table and columns A,B&C and add them together. There you go
 
Posted on 06-02-16 7:12 PM     [Snapshot: 105]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

Thank you SajhaMitra, it worked, I watched some youtube videos and learnt how to map datas and its awesome, thank you for your suggestion
.
 
Posted on 06-03-16 12:27 AM     [Snapshot: 216]     Reply [Subscribe]
Login in to Rate this Post:     0       ?    
 

EDX has Excel class started on May 30th, it may help you to advance.
 


Please Log in! to be able to reply! If you don't have a login, please register here.

YOU CAN ALSO



IN ORDER TO POST!




Within last 365 days
Recommended Popular Threads Controvertial Threads
श्राद्द
TPS Re-registration
सेक्सी कविता - पार्ट २
What are your first memories of when Nepal Television Began?
पाप न साप घोप्टो पारि थाप !!
पुलिसनी संग - आज शनिवार - अन्तिम भाग
निगुरो थाहा छ ??
ChatSansar.com Naya Nepal Chat
Lets play Antakshari...........
What Happened to Dual Citizenship Bill
Basnet or Basnyat ??
Sajha has turned into MAGATs nest
NRN card pros and cons?
is Rato Bangala school cheating?
मेरो अम्रिका यात्रा -२
Do nepalese really need TPS?
कता जादै छ नेपाली समाज ??
susta manasthiti lai ke bhanchan english ma?
कृष्ण नै अन्तिम सत्य
Nas and The Bokas: Coming to a Night Club near you
Nas and The Bokas: Coming to a Night Club near you
राजदरबार हत्या काण्ड बारे....
Mr. Dipak Gyawali-ji Talk is Cheap. US sends $ 200 million to Nepal every year.
Harvard Nepali Students Association Blame Israel for hamas terrorist attacks
TPS Update : Jajarkot earthquake
is Rato Bangala school cheating?
NOTE: The opinions here represent the opinions of the individual posters, and not of Sajha.com. It is not possible for sajha.com to monitor all the postings, since sajha.com merely seeks to provide a cyber location for discussing ideas and concerns related to Nepal and the Nepalis. Please send an email to admin@sajha.com using a valid email address if you want any posting to be considered for deletion. Your request will be handled on a one to one basis. Sajha.com is a service please don't abuse it. - Thanks.

Sajha.com Privacy Policy

Like us in Facebook!

↑ Back to Top
free counters