INTREST CALCULATION CIRCLE

PRINCIPAL RATE TIME SI CI RADIUS

1000 5% 2 100 102.5 5
2000 10% 3 400 420 6
3000 15% 4 900 967.5 7
4000 20% 5 1600 1760 8
5000 25% 6 2500 2812.5 9

C3:G9
CIRCLE
AREA OF CIRCLE
78.5
113.04
153.86
200.96
254.34
 STREAM
ARTS
COMMERCE
ARTS
23
COMMERCE
COMPUTER SCIENCE
SCIENCE
ARTS
COMPUTER SCIENCE
COMMERCE
ARTS
523
COMMERCE

SCIENCE
253
COMMERCE
COMMERCE
COMMERCE
COMMERCE
No. of science students 2
No.of commerce students 8
No. of arts students 3
No. of computer science students 2

No. of valid forms 16

No. of Invalid Forms 3
No. of Available seats 1
Total No of students 19
 MODULE 1 MARKS DETAILS
SUBJECTS
SL NO. NAME TOTAL AVG PERCENT
BASIC WINDOWS WORD EXCEL PPT
CRO01 ROHIT 3 9 9 9 9 39 13 78%
CRO02 AYUSH 8 7 6 7 7 35 11.66667 70%
CRO03 ATUL 5 8 4 8 8 33 11 66%
CRO04 ANSHU 6 5 7 4 5 27 9 54%
CRO05 SHUBHAM 8 5 4 5 8 30 10 60%
CRO06 NUPUR 7 5 5 6 7 30 10 60%
CRO07 ARSH 8 8 8 7 8 39 13 78%
CRO08 MEGHA 5 7 6 5 6 29 9.666667 58%
CRO09 DOLLY 6 4 4 7 8 29 9.666667 58%
CRO10 ANKIT 4 5 8 4 7 28 9.333333 56%
CRO11 PRITY 8 4 8 7 8 35 11.66667 70%
AILS
MAX. MIN PASS GRADE REMARKS
9 3 FAIL B V.GOOD
8 6 PASS B V.GOOD
8 4 FAIL C GOOD
7 4 FAIL D AVERAGE
8 4 FAIL C GOOD
7 5 PASS C GOOD
8 7 PASS B V.GOOD
7 5 FAIL D AVERAGE
8 4 FAIL D AVERAGE
8 4 FAIL D AVERAGE
8 4 FAIL B V.GOOD
 DATE AND TIME
DATE DAY(N) MONTH YEAR DAY © START DATE END DATE
8/2/2014 2 8 2014 Saturday 1/3/2011 3/31/2034
8/3/2014 3 8 2014 Sunday 12/5/2006 6/30/2026
8/4/2014 4 8 2014 Monday 6/12/2013 2/28/2034
8/5/2014 5 8 2014 Tuesday 1/3/2009 10/31/2039
8/6/2014 6 8 2014 Wednesda 3/11/2012 5/31/2024
ATE AND TIME
NO. OF WORKIND DAYS TIME HOUR MINUTE SECOND
8368 04:40:00 PM 16 40 0
7045 05:35:00 PM 17 35 0
7456 01:50:45 PM 13 50 45
11098 07:30:05 AM 7 30 5
4400 08:20:30 PM 20 20 30
 INFORMATION TECHNOLGY
TEXT FOM LEFT INFOR
TEXT FROM RIGHT LGY
TEXT IN UPPER CASE INFORMATION TECHNOLGY
TEXT IN PROPER CASE information technolgy
TECT IN LOWER CASE NFOR
TEXT IN MIDDLE NFORM
LENGTH OF A TEXT 21
 EMPLOYEE DETAILS
EMPLOYEE ID EMPLOYEE NAME D.O.B DEPARTMENT DESIGNATION D.O.J D.O.R
E001 RIYA 1/1/1960 MARKETING SALES ENGINNER 1/1/2006 1/31/2020
E002 DIYA 1/2/1960 PRODUCTIN ACCOUNTANT 1/2/2006 1/31/2020
E003 PIYA 1/3/1960 FINANCE ENGINNER 1/3/2006 1/31/2020
E004 ZIYA 1/4/1960 MARKETING ACCOUNTANT 1/4/2006 1/31/2020
E005 AYUSH 1/5/1960 PRODUCTIN SALES ENGINNER 1/5/2006 1/31/2020
E006 ATUL 1/6/1960 FINANCE ACCOUNTANT 1/6/2006 1/31/2020
E007 ARSH 1/7/1960 MARKETING ENGINNER 1/7/2006 1/31/2020
E008 ROHIT 1/8/1960 PRODUCTIN ACCOUNTANT 1/8/2006 1/31/2020
E009 SHUBHAM 1/9/1960 FINANCE SALES ENGINNER 1/9/2006 1/31/2020
E010 ANKIT 1/10/1960 MARKETING ACCOUNTANT 1/10/2006 1/31/2020
E011 NIRU 1/11/1960 PRODUCTIN ENGINNER 1/11/2006 1/31/2020
E012 ANSHU 1/12/1960 FINANCE ACCOUNTANT 1/12/2006 1/31/2020
E013 DOLLY 1/13/1960 MARKETING SALES ENGINNER 1/13/2006 1/31/2020
E014 MESSI 1/14/1960 PRODUCTIN ACCOUNTANT 1/14/2006 1/31/2020
E015 RONALDO 1/15/1960 FINANCE ENGINNER 1/15/2006 1/31/2020
E016 PELE 1/16/1960 MARKETING ACCOUNTANT 1/16/2006 1/31/2020
E017 ANSHU 1/17/1960 PRODUCTIN SALES ENGINNER 1/17/2006 1/31/2020
E018 RIYA 1/18/1960 FINANCE ACCOUNTANT 1/18/2006 1/31/2020
E019 DIYA 1/19/1960 MARKETING ENGINNER 1/19/2006 1/31/2020
E020 PIYA 1/20/1960 PRODUCTIN ACCOUNTANT 1/20/2006 1/31/2020
E021 ZIYA 1/21/1960 FINANCE SALES ENGINNER 1/21/2006 1/31/2020
E022 AYUSH 1/22/1960 MARKETING ACCOUNTANT 1/22/2006 1/31/2020
E023 ATUL 1/23/1960 PRODUCTIN ENGINNER 1/23/2006 1/31/2020
E024 ARSH 1/24/1960 FINANCE ACCOUNTANT 1/24/2006 1/31/2020
E025 ROHIT 1/25/1960 MARKETING SALES ENGINNER 1/25/2006 1/31/2020
E026 SHUBHAM 1/26/1960 PRODUCTIN ACCOUNTANT 1/26/2006 1/31/2020
E027 ANKIT 1/27/1960 FINANCE ENGINNER 1/27/2006 1/31/2020
E028 NIRU 1/28/1960 MARKETING ACCOUNTANT 1/28/2006 1/31/2020
E029 ANSHU 1/29/1960 PRODUCTIN SALES ENGINNER 1/29/2006 1/31/2020
E030 DOLLY 1/30/1960 FINANCE ACCOUNTANT 1/30/2006 1/31/2020
E031 MESSI 1/31/1960 MARKETING ENGINNER 1/31/2006 1/31/2020
E032 RONALDO 2/1/1960 PRODUCTIN ACCOUNTANT 2/1/2006 2/29/2020
E033 PELE 2/2/1960 FINANCE SALES ENGINNER 2/2/2006 2/29/2020
E034 ANSHU 2/3/1960 MARKETING ACCOUNTANT 2/3/2006 2/29/2020
E035 RIYA 2/4/1960 PRODUCTIN ENGINNER 2/4/2006 2/29/2020
E036 DIYA 2/5/1960 FINANCE ACCOUNTANT 2/5/2006 2/29/2020
E037 PIYA 2/6/1960 MARKETING SALES ENGINNER 2/6/2006 2/29/2020
E038 ZIYA 2/7/1960 PRODUCTIN ACCOUNTANT 2/7/2006 2/29/2020
E039 AYUSH 2/8/1960 FINANCE ENGINNER 2/8/2006 2/29/2020
E040 ATUL 2/9/1960 MARKETING ACCOUNTANT 2/9/2006 2/29/2020
E041 ARSH 2/10/1960 PRODUCTIN SALES ENGINNER 2/10/2006 2/29/2020
E042 ROHIT 2/11/1960 FINANCE ACCOUNTANT 2/11/2006 2/29/2020
E043 SHUBHAM 2/12/1960 MARKETING ENGINNER 2/12/2006 2/29/2020
E044 ANKIT 2/13/1960 PRODUCTIN ACCOUNTANT 2/13/2006 2/29/2020
E045 NIRU 2/14/1960 FINANCE SALES ENGINNER 2/14/2006 2/29/2020
E046 ANSHU 2/15/1960 MARKETING ACCOUNTANT 2/15/2006 2/29/2020
E047 DOLLY 2/16/1960 PRODUCTIN ENGINNER 2/16/2006 2/29/2020
E048 MESSI 2/17/1960 FINANCE ACCOUNTANT 2/17/2006 2/29/2020
E049 DOLLY 2/18/1960 FINANCE SALES ENGINNER 2/18/2006 2/29/2020
E050 MESSI 2/19/1960 FINANCE ACCOUNTANT 2/19/2006 2/29/2020
SALARY CONTACT NO. ADDRESS
50100 9999527841 RANCHI
50150 9999527842 JHARKHAND
50200 9999527843 DELHI
50250 9999527844 UP
50300 9999527845 HARYANA
50350 9999527846 UP
50400 9999527847 MUMBAI
50450 9999527848 UDAIPUR
50500 9999527849 KERELA
50550 9999527850 BANGLORE
50600 9999527851 RANCHI
50650 9999527852 JHARKHAND
50700 9999527853 DELHI
50750 9999527854 UP
50800 9999527855 HARYANA
50850 9999527856 UP
50900 9999527857 MUMBAI
50950 9999527858 UDAIPUR
51000 9999527859 KERELA
51050 9999527860 BANGLORE
51100 9999527861 RANCHI
51150 9999527862 JHARKHAND
51200 9999527863 DELHI
51250 9999527864 UP
51300 9999527865 HARYANA
51350 9999527866 UP
51400 9999527867 MUMBAI
51450 9999527868 UDAIPUR
51500 9999527869 KERELA
51550 9999527870 BANGLORE
51600 9999527871 RANCHI
51650 9999527872 JHARKHAND
51700 9999527873 DELHI
51750 9999527874 UP
51800 9999527875 HARYANA
51850 9999527876 UP
51900 9999527877 MUMBAI
51950 9999527878 UDAIPUR
52000 9999527879 KERELA
52050 9999527880 BANGLORE
52100 9999527881 RANCHI
52150 9999527882 JHARKHAND
52200 9999527883 DELHI
52250 9999527884 UP
52300 9999527885 HARYANA
52350 9999527886 UP
52400 9999527887 MUMBAI
52450 9999527888 UDAIPUR
52500 9999527889 KERELA
52550 9999527890 BANGLORE
 CALCULATION
2
15
24
41

BY OPERATORS BY FUNCTION

EX: = B5+B6+B7 =SUM(L5:L7)

MIXED FUNCTION: =SUM(B5:B7)+B8-L8+MAX(L5:L7)

INFORMATION
INFORMATION TECHNOLOGY
TECHNOLOGY CENTER,
CENTRE, JAMSHEDPUR BRA
BR
 25
15
BY FUNCTION
24
64

BY
OPERATORS

BY FUNCTION
MIXED CALCULATION

=SUM(L5:L7)

R,
E, JAMSHEDPUR BRANCH OF CIRC OF ICAI
ION
 TAX INVOICE
Invoice No.
Invoice Date
State Code
Client Id
Ignte MindZ Pvt Ltd (iso certified)
79,Sidco Industrial estate(P,O), Kurichi (9658741232), CBE, TN Terms of Payment 15 days credit
India - 647027
Contact No. 988323232, 044-44567200
Email : majeethaCCBC@gmail.com
Web : www.catalystk.com/
GST Tin :- 32AASPB697E121

To
Ravi Kumar,
#3, Venkatachalapathy 2nd Stree, Chennai, India - 600030
Contact: 99542813512

SN Description HSN/SAQTY
Code
1 0.5VA CONSTANT 12345676 3
2mp hd bulet ir
hlk vision
range 20mtrs
moodel:DS2C\AcOtyw

2 100KVA NANTECH SERVO VOLTAGE STABIIZER 12345678 1

2mp hd bullet ir
hik vision
Range 20mtrs
oodel: DS2C1\AcOtyw

Amount in words
Indian Rupees - Thirty Five Thousand Eight Hundred Only Sub Total
CGST 9 TAX (9%)
SGST 9 TAX (9%)
 Round off
Total Amount
Amount Paid
Balance amount

Declaration
1. Payment Terms Against Delivery
2. GST Applicable per HSN traffic code
3. Offer Validity 30 days from the date of offer
TAX INVOICE
INV/19-20167
10/9/2019

32106

15 days credit

Price Tax Total

6,779.66 18% 20,338.98

10,000 18% 10,000.00

: 30,338.98
CGST 9 TAX (9%) : 2,730.51
SGST 9 TAX (9%) : 2,730.51
Round off : 0.00
Total Amount : 35,800.00
Amount Paid : 5,000.00
Balance amount : 30,800.00

For Ignite MindZ Pvt Ltd isn Certified

Authorised Signatory
 TAX INVOICE
TechGuruPlus
OKHLA INDUSTRIAL AREA, PHASE -1
NEW DELHI - 110020,NCONTACT :- 9876543210
GST Tin No. 07PTAFF9867H1Z4
Bill To Place of Supply
NAZIM KHAN NAZIM KHAN
D-122, Lajpat Nagar D-122, Lajpat Nagar
New Delhi- 110015 New Delhi-110015
GST Tin No. 07PTAFF9867H1Z4
Description of service HSN CODE QTY Units

DECRIPTION
LED Lights 85013410 50 pcs
Bulbs 85013420 20 Dozens

Total

Less Discount 20%

Taxable Value

Add CGGST 12%

ADD SGST 6%

TOTAL
Amount Chargeable (in words)
Sixty Seven Thousand and Twenty Four Only
Company's PAN : APKFD3720Z

Note - Please make cheques in favour of ''TechGuruPlus''

us
ASE -1
- 9876543210
67H1Z4
Invoice
Dated

3567/2017-18
###

RATE AMOUNT

500 25000
2300 46000

71000

14200

56800

12% 6816
6% 3408

67024

For TechGuruPlus

Authorised Signature
SMALLEST AND LARGEST
Enter First No: 25
Enter Second No: 46
Enter Third No: 85

LargesT No 85
Smallest No 85
 XYZ SHOPPING MALL

SL.NO PRODUCT DISCRIPTION QTY PRICE/P DISCOUNT AMT

1 SHIRT 2 1600 160 3040
2 T-SHIRT 5 800 200 3800
3 PANT 8 2200 880 16720
4 TIE 3 800 120 2280
5 SOCKS 6 300 180 1620
6 WATCH 2 4500 450 8550
7 BELT 7 1200 840 7560
8 KURTA 2 700 70 1330
9 LUNGI 3 70 10.5 199.5
10 SANDO 5 280 140 1260
TOTAL 46359.5
VAT(12.5%) 5794.938
PAYABLE AMT 52154.44
OFFER PAY
QTY AMT DISCOUNT

15 15000 25%
10 10000 15%
5 5000 10%
<5 <5000 5%

160
TAX CALCULATION
INCOME 450000
TAX 20000
<=2500000 0%
>=2500000&<=500000 10%
>=500000&<=1000000 20%
>=1000000 30%
PROPERT VALUE COMMISSION DATA
100,000.00 7,000.00 250,000.00
200,000.00 14,000.00
300,000.00 21,000.00
400,000.00 28,000.00 0

ANS 63000
900000
300000
49000
PRODUCT RATE/WEIGHT(65/KG)
APPLE 12
ORANGE 10
MANGO 15
APPLE 25
ORANGE 32
MANGO 12
MANGO 41
APPLE 20
MANGO 25
APPLE 36
ORANGE 24
TOTAL AMOUNT(APPLE) 6045 93
TOTAL AMOUNT(ORANGE) 5265 81
TOTAL AMOUNT(MANGO) 5265 81