Spreadsheet: 871993d1718363373-summarization-of-data-based-on-date-sample-sheet
Sheet: Books-Indent

HIGH SCHOOL NOTE BOOKS INDENT |  |  |  |  | VI & VII | 14 |  |  | Estimation |  |  |  |  | SRI SARSWATHI HIGH SCHOOL
LONG | Qty. | Rate | Amt. |  | VIII, IX,X | 30 |  |  | Text Books | 42491 | 42491 |  |  | CLASS | SETS
SR | 100 | 34 | 3400 |  |  |  |  |  | Note Books | 34190 | 20000 |  |  | [NAME] | 5
UR | 350 | 34 | 11900 |  |  |  |  |  | Skids | 22160 | 32000 |  |  | CLASS-2 | 5
RB | 35 | 20 | 700 |  |  |  |  |  |  | 98841 | 94491 |  |  | CLASS-3 | 5
 |  |  |  |  |  | CLASS | TB AMT | WB AMT | TOTAL |  |  |  |  | CLASS-4 | 5
 | 485 |  | 16000 |  |  | CLASS-I | 399 | 1048 | 1447 |  |  |  |  | CLASS-5 | 5
 |  |  |  |  |  | CLASS-II | 425 | 1078 | 1503 |  |  |  |  | CLASS-6 | 5
PRIMARY SCHOOL NOTE BOOKS INDENT |  |  |  |  |  | CLASS-III | 750 | 1138 | 1888 |  |  |  |  | CLASS-7 | 5
CROWN | Qty. | Rate | Amt. |  |  | CLASS-IV | 760 | 1163 | 1923 |  |  |  |  | CLASS-8 | 10
BR | 50 | 34 | 1700 |  |  | CLASS-V | 790 | 1228 | 2018 |  |  |  |  | [NAME] | 10
DR | 50 | 34 | 1700 |  |  | CLASS-VI | 850 | 1539 | 2389 |  |  |  |  | TOTAL | 55
SR | 160 | 34 | 5440 |  |  | CLASS-VII | 960 | 1917 | 2877 |  |  |  |  | EMMANUEL EM HS
UR | 150 | 34 | 5100 |  |  | CLASS-VIII | 1300 | 2376 | 3676 |  |  |  |  | CLASS-6 | 5
FR | 125 | 34 | 4250 |  |  | CLASS-IX | 1300 | 3357 | 4657 |  |  |  |  | CLASS-7 | 5
 |  |  |  |  |  | CLASS-X | 1350 |  |  |  |  |  |  | CLASS-8 | 5
 | 535 |  | 18190 |  | 34190 |  |  |  |  |  |  |  |  | [NAME] | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | 19
 |  |  |  |  |  | L.K.G.
Govt. Text Books |  |  |  |  |  | PARTICULARS | QTY | PRICE | Amt. |  |  |  |  | TOTAL SETS | 74
CLASS | Total | 0.05 | Balance |  |  | CYGNET S3 TEXT | 5 | 750 | 3750 |  | 5 SETS COST
[NAME] | 1995 | 100 | 1895 |  |  | CYGNET S3 PC | 5 | 380 | 1900 |  | LKG | 7300 |  | CLASS-6 | 1539
CLASS-2 | 2125 | 108 | 2017 |  |  | SK TELUGU | 5 | 180 | 900 |  | UKG | 9000 |  | CLASS-7 | 1917
CLASS-3 | 3375 | 173 | 3202 |  |  | ART FUN | 5 | 150 | 750 |  | CLASS-I | 5240 |  | CLASS-8 | 2376
CLASS-4 | 3510 | 177 | 3333 |  |  |  |  |  | 7300 |  | CLASS-II | 5390 |  | [NAME] | 3357
CLASS-5 | 3635 | 184 | 3451 |  |  |  |  |  |  |  | CLASS-III | 5690
CLASS-6 | 3425 | 174 | 3251 |  |  | U.K.G. |  |  |  |  | CLASS-IV | 5815
CLASS-7 | 4100 | 207 | 3893 |  |  | PARTICULARS | QTY | PRICE |  |  | CLASS-V | 6140
CLASS-8 | 9096 | 456 | 8640 |  |  | CYGNET S3 TEXT | 5 | 750 | 3750 |  | TOTAL | 44575
[NAME] | 11230 | 567 | 10663 |  |  | CYGNET S3 PC | 5 | 380 | 1900 |  | (-50%) | 22287.5
Total | 42491 | 2146 | 40345 |  |  | SK TELUGU | 5 | 200 | 1000
 |  |  |  |  |  | SK HINDI | 5 | 160 | 800
 |  |  |  |  |  | ART FUN | 5 | 150 | 750 |  |  |  |  | 44575
 |  |  |  |  |  | COPY WRITING | 5 | 160 | 800
2024-25 |  | [NAME],VSP |  |  |  |  |  |  | 9000
LONG
SR | 120 |  |  |  |  | CLASS - I
UR | 500 |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
ROUGH | 45 |  |  |  |  | SK HINDI | 5 | 160 | 800
TOT | 665 |  |  |  |  | ENG.GRAMMAR | 5 | 200 | 1000
CROWN |  |  |  |  |  | GK | 5 | 180 | 900
BR | 50 |  |  |  |  | ART FUN | 5 | 150 | 750
DR | 50 |  |  |  |  | ENG COPY | 5 | 160 | 800
SR | 200 |  |  |  |  | HIN [NAME] | 5 | 99 | 495
UR | 200 |  |  |  |  | [NAME] | 5 | 99 | 495
FR | 150 |  |  |  |  |  |  | 1048 | 5240
CR | 15 |  |  |  |  | CLASS - II
TOT | 665 |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 5 | 160 | 800
 |  |  |  |  |  | ENG.GRAMMAR | 5 | 210 | 1050
 |  |  |  |  |  | GK | 5 | 200 | 1000
 |  |  |  |  |  | ART FUN | 5 | 150 | 750
 |  |  |  |  |  | ENG COPY | 5 | 160 | 800
 |  |  |  |  |  | HIN [NAME] | 5 | 99 | 495
 |  |  |  |  |  | [NAME] | 5 | 99 | 495
 |  |  |  |  |  |  |  | 1078 | 5390
 |  |  |  |  |  | CLASS - III
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 5 | 160 | 800
 |  |  |  |  |  | ENG.GRAMMAR | 5 | 250 | 1250
 |  |  |  |  |  | GK | 5 | 220 | 1100
 |  |  |  |  |  | ART FUN | 5 | 150 | 750
 |  |  |  |  |  | ENG COPY | 5 | 160 | 800
 |  |  |  |  |  | HIN [NAME] | 5 | 99 | 495
 |  |  |  |  |  | [NAME] | 5 | 99 | 495
 |  |  |  |  |  |  |  | 1138 | 5690
 |  |  |  |  |  | CLASS - IV
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 5 | 160 | 800
 |  |  |  |  |  | ENG.GRAMMAR | 5 | 265 | 1325
 |  |  |  |  |  | GK | 5 | 230 | 1150
 |  |  |  |  |  | ART FUN | 5 | 150 | 750
 |  |  |  |  |  | ENG COPY | 5 | 160 | 800
 |  |  |  |  |  | HIN [NAME] | 5 | 99 | 495
 |  |  |  |  |  | [NAME] | 5 | 99 | 495
 |  |  |  |  |  |  |  | 1163 | 5815
 |  |  |  |  |  | CLASS - V
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 5 | 190 | 950
 |  |  |  |  |  | ENG.GRAMMAR | 5 | 290 | 1450
 |  |  |  |  |  | GK | 5 | 240 | 1200
 |  |  |  |  |  | ART FUN | 5 | 150 | 750
 |  |  |  |  |  | ENG COPY | 5 | 160 | 800
 |  |  |  |  |  | HIN [NAME] | 5 | 99 | 495
 |  |  |  |  |  | [NAME] | 5 | 99 | 495
 |  |  |  |  |  |  |  | 1228 | 6140
 |  |  |  |  |  | 2nd Indent
 |  |  |  |  |  | CLASS - I
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 3 | 160 | 480
 |  |  |  |  |  | ENG.GRAMMAR | 3 | 200 | 600
 |  |  |  |  |  | GK | 3 | 180 | 540
 |  |  |  |  |  | ART FUN | 3 | 150 | 450
 |  |  |  |  |  | ENG COPY | 3 | 160 | 480
 |  |  |  |  |  | HIN [NAME] | 3 | 99 | 297
 |  |  |  |  |  | [NAME] | 3 | 99 | 297
 |  |  |  |  |  |  |  |  | 3144
 |  |  |  |  |  | CLASS - III
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 3 | 160 | 480
 |  |  |  |  |  | ENG.GRAMMAR | 3 | 250 | 750
 |  |  |  |  |  | GK | 3 | 220 | 660
 |  |  |  |  |  | ART FUN | 3 | 150 | 450
 |  |  |  |  |  | ENG COPY | 3 | 160 | 480
 |  |  |  |  |  | HIN [NAME] | 3 | 99 | 297
 |  |  |  |  |  | [NAME] | 3 | 99 | 297
 |  |  |  |  |  |  |  |  | 3414
 |  |  |  |  |  | CLASS - IV |  |  |  |  | Consoldated Data
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT |  | CLASS-I | 3144
 |  |  |  |  |  | SK HINDI | 1 | 160 | 160 |  | CLASS-III | 3414
 |  |  |  |  |  | ENG.GRAMMAR | 1 | 265 | 265 |  | CLASS-IV | 1163
 |  |  |  |  |  | GK | 1 | 230 | 230 |  | TOTAL | 7721
 |  |  |  |  |  | ART FUN | 1 | 150 | 150 |  | (-50%) | 3860.5
 |  |  |  |  |  | ENG COPY | 1 | 160 | 160
 |  |  |  |  |  | HIN [NAME] | 1 | 99 | 99
 |  |  |  |  |  | [NAME] | 1 | 99 | 99
 |  |  |  |  |  |  |  |  | 1163 |  | Returns
 |  |  |  |  |  |  |  |  |  |  | Class-1 Print CW-3 | 480
 |  |  |  |  |  | 3rd Indent |  |  |  |  | Class-3 Print CW-3 | 480
 |  |  |  |  |  |  |  |  |  |  | Class-4 Print CW-1 | 160
 |  |  |  |  |  | CLASS - I |  |  |  |  |  | 1120
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT |  | (-50%) | 560
 |  |  |  |  |  | SK HINDI | 1 | 160 | 160
 |  |  |  |  |  | ENG.GRAMMAR | 1 | 200 | 200
 |  |  |  |  |  | GK | 1 | 180 | 180
 |  |  |  |  |  | ART FUN | 1 | 150 | 150
 |  |  |  |  |  | ENG LUCIDA CW | 3 | 160 | 480
 |  |  |  |  |  |  |  |  | 1170
 |  |  |  |  |  | CLASS - III
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | ENG LUCIDA CW | 3 | 160 | 480
 |  |  |  |  |  |  |  |  | 480
 |  |  |  |  |  |  |  |  |  |  | Consoldated Data
 |  |  |  |  |  | CLASS - IV |  |  |  |  | UKG | 6070
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT |  | CLASS-I | 1170
 |  |  |  |  |  | SK HINDI | 1 | 160 | 160 |  | CLASS-III | 480
 |  |  |  |  |  | ENG.GRAMMAR | 1 | 265 | 265 |  | CLASS-IV | 1323
 |  |  |  |  |  | GK | 1 | 230 | 230 |  | TOTAL | 9043
 |  |  |  |  |  | ART FUN | 1 | 150 | 150 |  | (-50%) | 4521.5
 |  |  |  |  |  | ENG LUCIDA CW | 2 | 160 | 320
 |  |  |  |  |  | HIN [NAME] | 1 | 99 | 99 |  |  | 4521.5
 |  |  |  |  |  | [NAME] | 1 | 99 | 99 |  | Returns | 560
 |  |  |  |  |  |  |  |  | 1323 |  | Payable | 3961.5
 |  |  |  |  |  | U.K.G.
 |  |  |  |  |  | PARTICULARS | QTY | PRICE
 |  |  |  |  |  | CYGNET S3 TEXT | 3 | 750 | 2250
 |  |  |  |  |  | CYGNET S3 PC | 3 | 380 | 1140
 |  |  |  |  |  | SK TELUGU | 4 | 200 | 800
 |  |  |  |  |  | SK HINDI | 4 | 160 | 640
 |  |  |  |  |  | ART FUN | 4 | 150 | 600
 |  |  |  |  |  | LUCIDA CW-0 | 4 | 160 | 640
 |  |  |  |  |  |  |  |  | 6070
 |  |  |  |  |  | 4th Indent
 |  |  |  |  |  | L.K.G.
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | Amt.
 |  |  |  |  |  | CYGNET S3 TEXT | 5 | 750 | 3750
 |  |  |  |  |  | SK TELUGU | 5 | 180 | 900
 |  |  |  |  |  | ART FUN | 5 | 150 | 750
 |  |  |  |  |  |  |  |  | 5400
 |  |  |  |  |  |  |  | (-50%) | 2700
 |  |  |  |  |  | CLASS - I
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 1 | 160 | 160
 |  |  |  |  |  | ENG.GRAMMAR | 1 | 200 | 200
 |  |  |  |  |  | GK | 1 | 180 | 180
 |  |  |  |  |  | ART FUN | 1 | 150 | 150
 |  |  |  |  |  | ENG LUCIDA CW | 1 | 160 | 160
 |  |  |  |  |  |  |  |  | 850
 |  |  |  |  |  |  |  | (-50%) | 425
 |  |  |  |  |  |  | Total |  | 3125
 |  |  |  |  |  | QUESTION PAPERS INDENT
 |  |  |  |  |  | NURSERY | 5 SETS | ALL
 |  |  |  |  |  | LKG | 5 SETS | ALL
 |  |  |  |  |  | UKG | 5 SETS | ALL
 |  |  |  |  |  | CLASS
 |  |  |  |  |  | CLASS-I | 12 SETS
 |  |  |  |  |  | CLASS-II | 5 SETS
 |  |  |  |  |  | CLASS-III | 10 SETS
 |  |  |  |  |  | CLASS-IV | 10 SETS
 |  |  |  |  |  | CLASS-V | 6 SETS
 |  |  |  |  |  | SUBJECTS FOR CLASS-I TO CLASS-V
 |  |  |  |  |  | HINDI
 |  |  |  |  |  | G.K.
 |  |  |  |  |  | ENG.GRAMMAR
 |  |  |  |  |  | 5th Indent
 |  |  |  |  |  | L.K.G.
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | Amt.
 |  |  |  |  |  | CYGNET S3 TEXT | 3 | 750 | 2250
 |  |  |  |  |  | CYGNET S3 PC | 3 | 380 | 1140
 |  |  |  |  |  | TELUGU BHARATHI | 3 | 200 | 600
 |  |  |  |  |  |  |  |  | 3990
 |  |  |  |  |  |  |  | (-50%) | 1995
 |  |  |  |  |  | CLASS - I
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 1 | 160 | 160
 |  |  |  |  |  | ENG.GRAMMAR | 1 | 200 | 200
 |  |  |  |  |  | GK | 1 | 180 | 180
 |  |  |  |  |  | ART FUN | 1 | 150 | 150
 |  |  |  |  |  | ENG LUCIDA CW | 1 | 160 | 160
 |  |  |  |  |  |  |  |  | 850
 |  |  |  |  |  |  |  | (-50%) | 425
 |  |  |  |  |  |  | Total |  | 3125
 |  |  |  |  |  | CLASS - I
 |  |  |  |  |  | PARTICULARS | QTY | PRICE | AMT
 |  |  |  |  |  | SK HINDI | 1 | 160 | 160
 |  |  |  |  |  | ENG.GRAMMAR | 1 | 200 | 200
 |  |  |  |  |  | GK | 1 | 180 | 180
 |  |  |  |  |  | ART FUN | 1 | 150 | 150
 |  |  |  |  |  | ENG LUCIDA CW | 1 | 160 | 160
 |  |  |  |  |  |  |  |  | 850
 |  |  |  |  |  |  |  | (-50%) | 425
 |  |  |  |  |  |  | Total |  | 3125