[Show all top banners]

aalukojhol
Replies to this thread:

More by aalukojhol
What people are reading
Subscribers
:: Subscribe
Back to: Kurakani General Discussion Refresh page to view new replies
 Please Help on Excel or Google spreadsheet
[VIEWED 1668 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 30 days
Recommended Popular Threads Controvertial Threads
What stocks to buy -- Any recommendation
ट्रंप २०२०
हाकिमनी संग- आज सुक्रबार -३
श्राद्द
सान भिनाजु लाई अझै पैसो कमाउने आइडिया
आयाहूआस्का
दलित जगारण मोर्चा
Sajha Chat
मलाई ब्रेड खायो कि सारै पाद आउछ..
साम्राज्ञीले दुर्ब्यबहार भयो, भन्दा भुवन केसिलाइ किन रिस उठ्यो ??
सोनीकाले त बेज्जत गरिन त ( viewers discretion)
Nas!!! this one's for you
Help Aryan fight brain cancer!
Face mask नपाइने भए bra तथा underwear ले काम चलाउन अनुरोध
what benefit/financial aid/discount GC holder can get for education(Master's in computer science)
अमेरिकन citizenship
If pedophilia is a disability
श्रीमती मार्न परे नेपाल जानु !!
Visit Reeyas Kitchen for Nepali Food Recipes
महानायक
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