Spreadsheet: 871993d1718363373-summarization-of-data-based-on-date-sample-sheet
Sheet: BOOKS-RATE-LIST

CLASS - I |  |  |  |  | CLASS - II |  |  |  |  |  | CLASS - V
PARTICULARS | QTY | PRICE | AMT |  | PARTICULARS | QTY | PRICE | AMT |  |  | PARTICULARS | QTY | PRICE | AMT
TEXT BOOKS | 1 | 400 | 400 |  | TEXT BOOKS | 1 | 425 | 425 |  |  | TEXT BOOKS | 1 | 790 | 790
SK HINDI | 1 | 160 | 160 |  | SK HINDI | 1 | 160 | 160 |  |  | SK HINDI | 1 | 190 | 190
ENG.GRAMMAR | 1 | 200 | 200 |  | ENG.GRAMMAR | 1 | 210 | 210 |  |  | ENG.GRAMMAR | 1 | 290 | 290
GK | 1 | 180 | 180 |  | GK | 1 | 200 | 200 |  |  | GK | 1 | 240 | 240
ART FUN | 1 | 150 | 150 |  | ART FUN | 1 | 150 | 150 |  |  | ART FUN | 1 | 150 | 150
ENG COPY | 1 | 160 | 160 |  | ENG COPY | 1 | 160 | 160 |  |  | ENG COPY | 1 | 160 | 160
HIN [NAME] | 1 | 99 | 99 |  | HIN [NAME] | 1 | 99 | 99 |  |  | HIN [NAME] | 1 | 99 | 99
[NAME] | 1 | 99 | 99 |  | [NAME] | 1 | 99 | 99 |  |  | [NAME] | 1 | 99 | 99
 |  | 1048 |  |  |  |  | 1078 |  |  |  |  |  | 1228
TOTAL |  |  | 1448 |  | TOTAL |  |  | 1503 |  |  | TOTAL |  |  | 2018
FR | 3 | 40 | 120 |  | FR | 3 | 40 | 120 |  |  | FR | 2 | 40 | 80
SR | 2 | 40 | 80 |  | SR | 2 | 40 | 80 |  |  | SR | 5 | 40 | 200
DR | 1 | 40 | 40 |  | DR | 1 | 40 | 40 |  |  | UR | 3 | 40 | 120
UR | 3 | 40 | 120 |  | UR | 3 | 40 | 120 |  |  | BR | 1 | 40 | 40
BR | 1 | 40 | 40 |  | BR | 1 | 40 | 40 |  |  | DIARY | 1 | 100 | 100
DIARY | 1 | 100 | 100 |  | DIARY | 1 | 100 | 100 |  |  | TOTAL |  |  | 540
TOTAL |  |  | 500 |  | TOTAL |  |  | 500 |  |  | GRAND TOTAL |  |  | 2558
GRAND TOTAL |  |  | 1948 |  | GRAND TOTAL |  |  | 2003
CLASS - III |  |  |  |  | CLASS - IV
PARTICULARS | QTY | PRICE | AMT |  | PARTICULARS | QTY | PRICE | AMT
TEXT BOOKS | 1 | 750 | 750 |  | TEXT BOOKS | 1 | 760 | 760
SK HINDI | 1 | 160 | 160 |  | SK HINDI | 1 | 160 | 160
ENG.GRAMMAR | 1 | 250 | 250 |  | ENG.GRAMMAR | 1 | 265 | 265
GK | 1 | 220 | 220 |  | GK | 1 | 230 | 230
ART FUN | 1 | 150 | 150 |  | ART FUN | 1 | 150 | 150
ENG COPY | 1 | 160 | 160 |  | ENG COPY | 1 | 160 | 160
HIN [NAME] | 1 | 99 | 99 |  | HIN [NAME] | 1 | 99 | 99
[NAME] | 1 | 99 | 99 |  | [NAME] | 1 | 99 | 99
WB TOTAL |  | 1138 |  |  |  |  | 1163
 |  |  |  |  | TOTAL |  |  | 1923
TOTAL |  |  | 1888 |  | FR | 2 | 40 | 80
FR | 2 | 40 | 80 |  | SR | 5 | 40 | 200
SR | 5 | 40 | 200 |  | UR | 3 | 40 | 120
UR | 3 | 40 | 120 |  | BR | 1 | 40 | 40
BR | 1 | 40 | 40 |  | DIARY | 1 | 100 | 100
DIARY | 1 | 100 | 75 |  | TOTAL |  |  | 540
TOTAL |  |  | 515 |  | GRAND TOTAL |  |  | 2463
GRAND TOTAL |  |  | 2403
CLASS - VI |  |  |  |  | CLASS - VII |  |  |  |  |  | CLASS - X
PARTICULARS | QTY | PRICE | AMT |  | PARTICULARS | QTY | PRICE | AMT |  |  | PARTICULARS | QTY | PRICE | AMT
GOVT.TB | 1 | 650 | 650 |  | GOVT.TB | 1 | 800 | 800 |  |  | GOVT.TB | 1 | 1350 | 1350
TELUGU | 1 | 243 | 243 |  | TELUGU | 1 | 288 | 288 |  |  | TELUGU | 1 | 702 | 702
HINDI | 1 | 288 | 288 |  | HINDI | 1 | 324 | 324 |  |  | HINDI | 1 | 693 | 693
ENGLISH | 1 | 423 | 423 |  | ENGLISH | 1 | 495 | 495 |  |  | ENGLISH | 1 | 963 | 963
SCIENCE | 1 | 279 | 279 |  | SCIENCE | 1 | 360 | 360 |  |  | PHYSICS | 1 | 603 | 603
SOCIAL (MAT) | 1 | 306 | 306 |  | SOCIAL (MAT) | 1 | 450 | 450 |  |  | BIOLOGY | 1 | 315 | 315
MAP POINTING | 1 | 63 | 63 |  | MAP POINTING | 1 | 72 | 72 |  |  | HISTORY | 1 | 531 | 531
SCIENCE DRAWING | 1 | 63 | 63 |  | SCIENCE DRAWING | 1 | 81 | 81 |  |  | GEOGRAHY | 1 | 69 | 69
 |  |  |  |  |  |  |  | 0 |  |  | [NAME] | 1 | 69 | 69
WB TOTAL |  | 1665 |  |  | WB TOTAL |  | 2070 |  |  |  | CIVICS | 1 | 69 | 69
TOTAL |  |  | 2315 |  | TOTAL |  |  | 2870 |  |  | MAP POINTING | 1 | 72 | 72
SR | 10 | 40 | 400 |  | SR | 10 | 40 | 400 |  |  | CHE. DRAWING | 1 | 72 | 72
UR | 3 | 40 | 120 |  | UR | 3 | 40 | 120 |  |  | PHY. DRAWING | 1 | 72 | 72
ROUGH | 1 | 30 | 30 |  | ROUGH | 1 | 30 | 30 |  |  | NS DRAWING | 1 | 72 | 72
DIARY | 1 | 100 | 100 |  | DIARY | 1 | 100 | 100 |  |  | WB TOTAL |  | 4302
TOTAL |  |  | 650 |  | TOTAL |  |  | 650 |  |  | GRAND TOTAL |  |  | 5508
GRAND TOTAL |  |  | 2965 |  | GRAND TOTAL |  |  | 3520 |  |  | UR | 20 | 40 | 800
 |  |  |  |  |  |  |  |  |  |  | ROUGH | 1 | 30 | 30
 |  |  |  |  |  |  |  |  |  |  | DIARY | 1 | 100 | 100
CLASS - VIII |  |  |  |  | CLASS - IX |  |  |  |  |  | TOTAL |  |  | 930
PARTICULARS | QTY | PRICE | AMT |  | PARTICULARS | QTY | PRICE | AMT |  |  | GRAND TOTAL |  |  | 6438
GOVT.TB | 1 | 1150 | 1150 |  | GOVT.TB | 1 | 1150 | 1150
TELUGU | 1 | 450 | 450 |  | TELUGU | 1 | 738 | 738
HINDI | 1 | 315 | 315 |  | HINDI | 1 | 459 | 459
ENGLISH | 1 | 441 | 441 |  | ENGLISH | 1 | 774 | 774
PHYSICS | 1 | 297 | 297 |  | PHYSICS | 1 | 369 | 369
BIOLOGY | 1 | 243 | 243 |  | BIOLOGY | 1 | 153 | 153
CIVICS | 1 | 234 | 234 |  | CIVICS | 1 | 288 | 288
GEOGRAPHY | 1 | 153 | 153 |  | GEOGRAPHY | 1 | 225 | 225
HISTORY | 1 | 243 | 243 |  | HISTORY | 1 | 198 | 198
MAP POINTING | 1 | 72 | 72 |  | [NAME] | 1 | 153 | 153 |  |  | CLASS | TBOOKS | WBOOKS | NBOOKS | TOTAL
PS DRAWING | 1 | 72 | 72 |  | MAP POINTING | 1 | 63 | 63 |  |  | VI | 650 | 1665 | 650 | 2965
NS DRAWING | 1 | 72 | 72 |  | PS DRAWING | 1 | 45 | 45 |  |  | VII | 800 | 2070 | 650 | 3520
WB TOTAL |  | 2592 |  |  | NS DRAWING | 1 | 45 | 45 |  |  | VIII | 1150 | 2592 | 930 | 4672
TOTAL |  |  | 3742 |  | WB TOTAL |  | 3510 |  |  |  | IX | 1150 | 3510 | 930 | 5590
UR | 20 | 40 | 800 |  | TOTAL |  |  | 4660 |  |  | X | 1350 | 4302 | 930 | 6582
ROUGH | 1 | 30 | 30 |  | UR | 20 | 40 | 800
DIARY | 1 | 100 | 100 |  | ROUGH | 1 | 30 | 30
TOTAL |  |  | 930 |  | DIARY | 1 | 100 | 100
GRAND TOTAL |  |  | 4672 |  | TOTAL |  |  | 930
 |  |  |  |  | GRAND TOTAL |  |  | 5590