[Show all top banners]

Replies to this thread:

More by aalukojhol
What people are reading
:: Subscribe
Back to: Kurakani General Discussion Refresh page to view new replies
 Please Help on Excel or Google spreadsheet
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.



Within last 7 days
Recommended Popular Threads Controvertial Threads
which stock to buy
❤️ चिक्नी चमेली ❤️
प्रियंका कार्की फोटो अबलम भाग २ , ३ जून २०१६ copyright @पुन्टर
Buying land in kathmandu
Face mask नपाइने भए bra तथा underwear ले काम चलाउन अनुरोध
प्ब्जी गेमप्ले
भीष्मजी की श्रीमती
स्कूलमा पढेका कथा - भुतको शिकार, शिशिर बसन्तको कथा देखि टाउकोको मोल सम्म
एक नयाँ सूरुवात जिन्दगीको
आहा! कती मिठो गीत्!
के इतिहास दोरिदै छ नेपालमा ? बिपी र राजा महेन्द्र
Breaking...... Kulman
म को हुँ ।।।
TPS holder are the one who took Trump to Court? Why are they crying now?
Simple Yet Deep Question
हामी थुक्छु एस्तो मान पदवी!!,
3 japanese car brand only fool will buy
खाडिबाट फर्केका राजनीतिमा लाग्नु पर्यो |
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