LibreOffice-Suite-Calc/C3/Advanced-Formatting-and-Protection/Khasi

Time	Narration
00:00	Ngi pdiang sngewbha ia phi sha ka Spoken Tutorial halor ka Advanced Formatting and Protection in LibreOffice Calc.
00:07	Ha kane ka jinghikai , ngin pule shaphang kumno ban Password protect ia ka spreadsheet Ban iada da kaba buh password ia kawei ka sheet lane ka tab ha ka spreadsheet Ban shna ia ki ranges na ka bynta ka database Ban pyndonkam ia ka opshon Subtotal bad Ban validate ia ki cell
00:25	Hangne ngi pyndonkam da ka Ubuntu Linux version 10.04 bad LibreOffice Suite version 3.3.4.
00:35	To ngin plié ia ka “Personal-Finance-Tracker.ods”.
00:40	Nyngkong eh ngin pule kumno ban password protect  ia kane ka file.
00:44	Kane ka opshon ka pynthikna ba tang ki briew kiba tip ia ka password kin lah ban plié ia kane ka file.
00:51	Na ka Main menu, nion  File bad Save As
00:55	Ka Save dialog-box ka paw
00:58	Nangta, buh dak ha ka 'Save with password'  box
01:03	Nangata sa nion Save.
01:06	Namar ba ngi pyndonkam da ka opshon Save As , ngi lah ban save ia ka kum kawei pat ka file lane shu bujli ia kajuh ka file
01:15	Hangne, to ngin bujli ia ka file
01:18	Nion Yes.
01:20	Nangta , sa pyndap ka password
01:23	Bad sa pyndap biang ia ka password ha ka Confirm box bad sa nion  OK.
01:30	Nangta , khang noh ia ka "Personal-Finance-Tracker.ods".
01:36	Mynta, to ngin plié biang ia ka file bad peit kaei kaba jia
01:41	Ka Enter Password dialog-box ka paw.!
01:45	To ngin pyndap ia ka password ba bakla hangne.
01:48	Nion OK
01:50	Ngi ioh kawei ka khubor kaba ong ba ka password ka bakla.
01:56	Mynta, type ia ka password kaba dei.
01:59	Ka file ka plie
02:01	Kumno ngi weng iaka password opshon? Ka long kaba suk bha
02:07	Ngi shu weng ia u dak ba la ai ha ka opshon Save with password
02:10	Sa shisien, namar ba ngi pyndonkam da ka opshon Save , ngi lah ban save ia ka kum kawei pat ka file lane shu bujli ia kajuh ka file
02:18	Hangne, to ngin bujli ia ka file.
02:21	Nion Yes
02:23	To ngin close bad openia kane file
02:27	Phim donkam ia ka password ban plié ia ka file.
02:31	To ngin pule kumno ban password protect ia kawei kawei ka sheet na kane ka file.
02:37	Na ka menu bar, nion ha Tools > Protect Document bad Sheet.
02:44	Ka “Protect Sheet” dialog-box ka paw.
02:47	Ban iada ia ka sheet, nyngkong eh weng lane uncheck ia ki opshon “Select Locked cells” bad “Select Unlocked cells”.
02:56	Mynta ha ka bynta “Password” to ngin pyndap “abc”, ha ki dak rit bad ngin pyndap biang ia ka password ha ka jaka “Confirm”.
03:07	Nion OK.
03:08	Mynta, to ngin pyrshang ban jied bad pynkylla ia ki data ha ka cell.
03:15	Ngim lah ban jied ia kano kano ka cell
03:18	Ia ka sheet ym lah ban pynkylla.
03:22	Ka long kumno pat bad kiwei kiwei ki sheet?
03:24	To ngin nion ha Sheet2.
03:27	To ngin jied ia ka cell bad pyrshang ban edit ia ka
03:30	Ka Calc ka ailad ban edit lane pynkylla ia ki cell ha kiwei pat ki sheet.
03:35	To ngin phai biang sha ka sheet ba nyngkong.
03:38	Mynta to ngin un-protect noh ia ka sheet
03:41	Kane ka suk bha.
03:43	Na ka Menu Bar, nion ha “Tools” > “Protect Document” bad “Sheet”.
03:49	Ka dialog box kaba pan iaka password ka paw
03:53	Pyndap “abc” ha ki dak rit ha ka bad sa nion OK.
03:59	Ngi la lah ban jied biang ia ki cells
04:03	To ngin pule shaphang ki Ranges.
04:06	Phi lah ban batai ia ki range jong ki cell ha ka spreadsheet bad pyndonkam ia ka ha ka database.
04:12	Each row in this database range corresponds to a database record and Man kawei pa kawei ka row ha kane ka database range  ka iadei bad ka database record bad
04:17	Man kawei pa kawei ka cell ha ka row ka iadei bad ka database field
04:22	Phi lah ban pynbeit ryntih, ban kyllum lang, ban wad bad leh ia ki jingkhein jingkdiah ha ka range kumba phi kwah ha kano kano ka database.
04:30	To ngin shna ia ka database ha ka “Personal-Finance-Tracker.ods” bad pynbeit ryntih ia ka data.
04:38	Nyngkong eh, jied ia ki item kiba ngi donkam ha ka database.
04:43	To ngin jied ryngkat ia baroh ki data hapoh ka heading “SN” haduh "Account". Ngi la dep pule lypa kumno ban jied ia ki data.
04:53	Mynta , to ngin ai kyrteng ia ka database jong ngi.
04:56	Na ka Menu bar, nion Data bad nangta sa nion ha Define Range.
05:02	Ha ka “Name” field, type “dtbs” kaba dei ka kyrteng lyngkot jong ka database.
05:08	Nion Ok
05:10	Sa shisien, na ka Menu bar, nion Data bad Select Range.
05:15	Peit bha ba ha ka “Select Database Range” dialog-box kaba paw, ka kyrteng “dtbs” la pyni kum ka database
05:24	Nion ha u OK button
05:27	Mynta to ngin pynbeit ryntih ia ka data ha kane ka database.
05:31	Na ka Menu Bar, nion Data bad Sort.
05:35	Ha ka Sort dialog-box kaba paw, nion ha “Sort by” field badjied “SN”.
05:42	Nangta, na ka liang kamon, jied “Descending”.
05:47	Hapoh ka “Then by” field kaba nyngkong, nion ha u drop down bad jied “Cost”.
05:54	Sa shisien, naka liang ka mon, jied “Descending”.
05:58	Ha ka “Then by” field kaba ar, nion ha ka drop-down, jied “Spent”  bad nangta sa jied biang “Descending”.
06:07	Nion Ok.
06:09	Ka data hapoh ka heading “SN”  la pynbeit ryntih na ba heh sha ba rit
06:15	Ha kajuh ka rukom, ngi lah ban leh ia kiwei kiwei ki operation ha ka database ruh.
06:21	To ngin nion CTRL+Z  keys ban weng ia baroh ki jingpynkylla ba la leh ban pynbeit ryntih bad ioh biang ia ka data barim
06:28	Mynta , to ngin pule kumno ban pyndonkam ia ka opshon “Subtotal”  hapoh Calc
06:34	Ka opshon “Subtotal”, ka khein lang lane calculate ia ka grand total jong ki data hapoh ki heading bapher bapher, da kaba pyndonkam ia ki mathematical function kiba ngi kwah.
06:43	To ngin jied ia ka subtotal jong ki data hapoh ka heading “Cost”.
06:49	Nyngkong , to ngin pyndam ia ka entry ha ka row number 8.
06:53	Jied lut ryngkat ia baroh ki data hapoh SN haduh ACCOUNT.
06:59	Nangta, na ka Menu Bar, nion Data bad Subtotals.
07:04	Ha ka Subtotals dialog-box kaba paw, na ka “Group by” field, to ngin jied “SN”.
07:11	Kane ka kyllum lang ia ki data da ka Serial Number.
07:15	Nangta, ha ka “Calculate subtotals for” field, nion ha ka “Cost” option.
07:21	Kane kan sa khein lang ia ka total jong baroh ki entry kiba don hapoh jong ka,
07:26	Hapoh jong ka “Use function” field , jied “Sum”  bad nion OK
07:33	Peit bha ba ka “Grand total” jong baroh ki entry, hapoh ka heading “Costs” la pyni ha ka spreadsheet.
07:41	Ha ka liang kadiang jong ka Sheet. Don lai tylli ki tab ba thymmai, “1”, ”2”bad “3”.
07:47	Kine ki tab ki ai ia 3 tylli ki view kiba pher jong ka data.
07:52	To ngin nion ha tab 1.
07:54	Peit bha ba tang ka grand total jong ka data hapoh “Costs” la pyni
08:00	Nion ha tab “2”
08:02	Ka data hapoh “Costs” bad kumjuh ka grand total la pyni.
08:08	Mynta , nion ha tab “3”
08:11	Ngi ioh iaka detailed view jong ka sheet ryngkat bad ka grand total jong ka data hapoh “Costs”.
08:18	To ngin khang noh ia kane ka file.
08:21	Ka dialogue box ryngkat ka message Save or Discard changes ka paw.
08:26	Nion Discard.
08:28	Mynta, to ngin plié biang ia ka file.
08:31	Mynta , to ngin pule shaphang ka opshon “Validity” ha LibreOffice Calc.
08:37	Ka “Validity” opshon ka pynshisha ia ka data ha ka spreadsheet.
08:41	Ia kane la leh da kaba pynthikna ia ki “Validation rules” naka bynta ki cell ba la dep jied ha ka spreadsheet.
08:49	Kum ka nuksa, ha ka “Personal-Finance-Tracker.ods”, ngi lah ban pynthikna iaka rukom siew na ka bynta ki item ba la dep thied da ka pyndonkam ka Validation.
08:59	Mynta, to ngin pyndam lane delete ia ka heading “Date” bad baroh kiba don hapoh jong ka
09:04	To ngin ai da kawei ka heading na ka bynta “Mode of Payment” kum “M-O-P”, mar bud jong ka heading “Received”.
09:12	Hapoh jong ka heading “M-O-P”, ia ki cell lah ban pyndonkam ban pyni ia ka rukom siew naka bynta ki data entry kiba hap hapoh ka heading “Items”
09:21	Kita ki long ”Salary”, ”Electricity Bills” bad kiwei kiwei pat.
09:27	Mynta, to ngin nion ha ka cell bathylli kaba don hapoh jong ka heading ”M-O-P”.
09:33	Kane kan don ia ka rukom siew na ka bynta ka “Salary”
09:38	Mynta, na ka Menu Bar, nion “Data” bad “Validity”.
09:43	Ka Validity dialog box ka paw
09:47	To ngin nion ha ka “Criteria” tab
09:50	Na ka “Allow” field drop-down, nion “List”
09:55	Ka “Entries” box ka mih .
09:58	To ngin pyndap ia ki opshon kiban sa paw haba pynshisha ia ka cell ba la dep jied
10:05	To ngin type ia ka rukom siew kaba nynkong kum “In Cash” bad nangta sa nion ia u Enter key na ka keyboard,
10:13	Mynta to ngin type ia ka rukom siew kaba ar kum “Demand Draft”.
10:19	Nion Ok.
10:21	Ki cell ba la dep jied la pynshisha.
10:25	Mynta , nion ia u down-arrow uba paw hajan.
10:30	Hato phi iohi ia ki opshon kiba ngi la dep pyndap kum Mode of Payments ha ka Entries box?
10:36	Ban pynshisha ia ki cell ba hapoh, nyngkong eh nion ha ka Format Paintbrush opshon ha ka toolbar
10:43	Nangta, jied ia ki cell ba hapoh jong ka cell ba la dep pynshisha da kaba nion ia u mouse button na ka liang kadiang bad nangta sa drag sha ki cell
10:53	Mynta, pyllait noh ia u mouse button.
10:57	Baroh ki cell ba la dep jied la pynshisha ha ka juh ka rukom.
11:09	Mynta, nion ha ka cell kaba hapoh jong ka heading “M-O-P” bad nangta sa nion ha u down-arrow.
11:17	Baroh artylli ki opshon naka bynta ka rukom siew la pyni.
11:21	To ngin jied ia ka In Cash opshon
11:25	Ha kajuh ka rukom, phi lah ban jied “Cash” lane “Demand Draft”  ha kawei pa kawei ka cell ba la dep pynshisha katkum ka rukom siew ba la buh
11:36	Bad da kane, ngi la poi shaba kut jong ka Spoken Tutorial halor ka LibreOffice Calc.
11:42	Ban batai kyllum, ngi la dep pule shaphang kumno ban Password protect ia ka spreadsheet Ban iada da kaba buh password ia kawei ka sheet lane ka tab ha ka spreadsheet Kumno Ban shna ia ki ranges na ka bynta ka database Kumno Ban pyndonkam ia ka opshon Subtotal bad Kumno Ban validate ia ki cell
12:01	Peit ia ka video ba la ai ha ka link ba don harum
12:04	Ka kyllum lang ia Ka Spoken Tutorial project.
12:07	Lada phim don iaka bandwidth kaba biang phi lah ban shu download bad peit ia ka
12:11	Ka Kynhun jong ka Spoken Tutorial Project
12:13	*Ka pynlong ia ki workshop da kaba pyndonkam da ki spoken tutorials.
12:17	*Ka ai sertiphikate sha kito kiba pass ha ka online test.
12:20	Na ka bynta ki jingtip ba kham bniah sngewbha thoh sha contact at spoken hyphen tutorial dot org.
12:27	Ka Spoken Tutorial projek kadei shi bynta jong ka Talk to a Teacher project.
12:31	Ia kane la kyrshan da ka National Mission on Education lyngba ka ICT, MHRD, Sorkar India.
12:39	Shibun ki jingtip halor kane ka mission ki don ha
12:42	spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
12:50	Ia kane ka jinghikai la pynkylla sha ka ktien Khasi da I Meboreen Mary. Khublei shibun iaka jingiasnohkti lang jong phi.

Contributors and Content Editors

Meboreen Mary, PoojaMoolya, Pratik kamble