tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 146892d1332406101-vlookup-and-hlookup-homework-tutor-requested-hlookup
Sheet: Sheet1

Activity 27
This activity will be using [NAME] function and other functions previously learned. This has 3 parts which has a varying degree of difficulty.
Part [NAME] are going to tell what is the corresponding bonus of a sale made by an employee. It should be that when you enter the sales of the different employees, the Excel will automatically calculate the bonuses earned. Don't forget to write the formula you used in the [NAME] column.
Employee Name | Sales | Bonus | [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bonus Target | 1000 | 2000 | 3000 | 4000 | 5000
Bonus Amount | 50 | 100 | 150 | 200 | 250
Part II. You were asked by your boss to create a simple cashiering system using Excel. The said system will just ask for the [NAME] name, quantity to purchase, and the amount paid. It will then display [NAME] No., [NAME], Total, and Change. The form is already given. Now, enter the appropriate formula to make the system work. Don't forget to place the formula you used the in the "formula used:" box.
Item No.: |  |  |  |  |  | formula used: |  | [enter your formula here]
Enter Item Name:
Item Cost: |  |  |  |  |  | formula used: |  | [enter your formula here]
Enter Quantity:
Total: |  |  |  |  |  | formula used: |  | [enter your formula here]
Enter Amount Paid:
Change: |  |  |  |  |  | formula used: |  | [enter your formula here]
Item No.: | AC-100 | AC-101 | AC-102 | CD-200 | CD-300
Item Name: | Battery | Gear | Widgets | Sling | Scrub
Price: | 17.34 | 23.56 | 78.19 | 32.5 | 16.99
Part III. This part of the activity is somewhat similar to part II, however with some modifications. You will just enter the product name and the rest of the fields will be displayed by Excel to you. The challenge in this activity is that if the you enter a product which does not belong to the given in the table, Excel should not display #N/A but should display Item Not Found.   Hint: You can use Excel Help (press F1) to study the functions below. One among them can help you conquer the challenge.  - ISERR - ISLOGICAL - ISNONTEXT - ISNUMBER - ISREF - ISTEXT - ISNA - ISERROR - ISBLANK
Product name | Shirt | Pants | Socks | Hat
Order No. | 111 | 112 | 113 | 114
Color | Blue | Black | White | Green
Index No. | 1 | 2 | 3 | 4
Enter Product Name:
Order No.:
Color.:
Index No.:
Spreadsheet: john_griffith__15749__10_16_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 63 | 340 | 425 | 40.9 | 51.1 | 1.82 | 2001-10-16 14:52:00
 | HO Z1 | 64 | 825 | 900 | 47.9 | 52.2 | 2.01 | 2001-10-16 14:52:00
 | HO F2 | 65 | 1100 | 1150 | 48.5 | 50.7 | 2.03 | 2001-10-16 14:52:00
 | HO G2 | 65 | 1250 | 1300 | 45.8 | 47.6 | 1.91 | 2001-10-16 14:52:00
 | [NAME] | 63 | 1280 | 1325 | 43.1 | 44.6 | 1.74 | 2001-10-16 14:52:00
 | HO J2 | 62 | 1250 | 1325 | 38.9 | 41.3 | 1.56 | 2001-10-16 14:52:00
 | HO K2 | 62 | 1225 | 1375 | 35.1 | 39.4 | 1.45 | 2001-10-16 14:52:00
 | HO M2 | 61 | 1175 | 1325 | 31.7 | 35.8 | 1.29 | 2001-10-16 14:52:00
 | HO N2 | 60 | 1200 | 1400 | 31.1 | 36.3 | 1.27 | 2001-10-16 14:52:00
 | HO Q2 |  |  |  | 29.1 | 31.4 | 1.2 | 2001-10-12 14:53:00
 | HO U2 |  | \ |  | 28.8 | 34.4 | 1.25 | 2001-10-12 14:53:00
 | [NAME] |  |  |  | 24.3 | 26.8 | 1.08 | 2001-08-20 15:41:00
 | HO X2
 | [NAME]
 | HO F3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: 74669d1275177816-find-most-frequent-minimum-value-and-return-the-name-frequency
Sheet: 2

 | Product |  |  |  | wastage
 | product1 |  |  |  | 10
 | product2 |  |  |  | 58
 | product3 |  |  |  | 72
 | product4 |  |  |  | 6
 | product5 |  |  |  | 8
 | product6 |  |  |  | 48
 | product7 |  |  |  | 26
 | product8 |  |  |  | 24
 | product9 |  |  |  | 14
 | product10 |  |  |  | 13
 | product11 |  |  |  | 26
 | product12 |  |  |  | 57
 | product13 |  |  |  | 24
 | product14 |  |  |  | 26
 | product15 |  |  |  | 27
 | product16 |  |  |  | 25
 | product17 |  |  |  | 65
 | product18 |  |  |  | 35
Spreadsheet: 04ed93d5-1fc4-4acb-91cc-5041ad48b872
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Area |  | Yield |  | Supply |  |  |  |  |  | Use
Year begin. | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
Sept. 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | ------Million acres------ |  | Bu./acre |  |  |  |  |  | ------------------------------------------------------Million bushels-----------------------------------------------
2009/10 | 77.451 | 76.372 | 43.9822317079558 | 138.198 | 3359.011 | 14.5893320473278 | 3511.798332047328 |  | 1751.686 | 110.1778320473275 | 1499.0495 | 3360.913332047327 | 150.885
2010/111 | 77.404 | 76.61 | 43.45621981464561 | 150.885 | 3329.181 | 14.4489862517322 | 3494.514986251732 |  | 1648.043 | 130.1501321115322 | 1501.3088541402 | 3279.501986251732 | 215.013
2011/122 | 74.976 | 73.636 | 41.50187408332881 | 215.013 | 3056.032 | 15 | 3286.045 |  | 1630 | 116.0450000000001 | 1290 | 3036.045 | 250
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  |  | Supply |  |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
2010/11
Sep-Nov |  |  |  | 150.885 | 3329.181 | 3.7391313958929 | 3483.805131395893 |  | 587.6937876060929 |  | 618.0273437897999 | 1205.721131395893 | 2278.084
Dec-Feb |  |  |  | 2278.084 | --- | 4.8747842171721 | 2282.958784217172 |  | 481.1960085889718 |  | 552.9627756282 | 1034.158784217172 | 1248.8
Mar-May |  |  |  | 1248.8 | --- | 2.9332424794659 | 1251.733242479466 |  | 407.9605287787658 |  | 224.4897137007 | 632.4502424794658 | 619.283
Jun-Aug |  |  |  | 619.283 | --- | 2.9018281592013 | 622.1848281592013 |  | 301.3428071377012 |  | 105.8290210215 | 407.1718281592013 | 215.013
Total |  |  |  |  | 3329.181 | 14.4489862517322 | 3494.514986251732 |  | 1778.193132111532 |  | 1501.3088541402 | 3279.501986251732
2011/12
Sep-Nov |  |  |  | 215.013 | 3056.032 | 2.8441205983722 | 3273.889120598372 |  | 479.656604109672 |  | 424.3475164887001 | 904.0041205983721 | 2369.885
Dec-Feb1 |  |  |  | 2369.885 | --- | 2.8346552240622 | 2372.719655224063 |  | 524.1719390846358 |  | 476.2897161394267 | 1000.461655224062 | 1372.258
Total to date1 |  |  |  |  | 3056.032 | 5.6787758224344 | 3061.710775822435 |  | 1003.828543194308 |  | 900.6372326281268 | 1904.465775822435
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2012-04-12 13:57:01.810000
Spreadsheet: 716256d1612123466-have-a-text-value-with-sumifs-forum-excel-31-jan-2021
Sheet: Projection

Note mensuelle: | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes | Notes
 |  |  | FORMULA?? |  |  |  |  |  |  |  |  |  |  |  | *
Sommaire estimé | Mois dernier | Ce mois-ci
Date début
Date fin
Solde de départ (peut modifier si nécessaire) |  |  | 25320
Revenu net
Dépenses
Paiement avancé Dépense |  |  | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350 | -350
Solde final (peut modifier si nécessaire)
Solde de fermeture |  |  | FORMULA??
Tout +/- si besoin pour balancer
Revenus (défilé [NAME]) | Mois dernier | Ce mois-ci |  | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
Autre
Crédit Solidarité Qc
Intérêt Banque
Paye travail
Paye vacance
Remb. Impot Canada
Remb. Impot Québec
[NAME]. prêt fam./ami
Remb. TPS
Retrait placement CÉLI
Retrait placement REER
Dépenses (défilé [NAME]) | Mois dernier | Ce mois-ci |  | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
Assurance auto
Assurance habitation
Autre
Divertissement
[NAME]/chauffage
Épicerie
Essence
Facture médicament
Forfait cellulaire
Impôt retenu Canada
Impôt retenu Québec
Internet
Logement
Paiement avance
Permis conduire
Plaque immatriculation
Prêt famille/amis
[NAME]. Commerçant
Réparation / entretien auto
Restaurant
[NAME] (thérapeute divers)
Transfert cpt. Ép./Inv./Urg.
Vacance/voyage
 | Past | Actual | Past
Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR
FT
PL
UR
Spreadsheet: 865025d1712133433-combine-two-unique-lists-into-one-test1-19-aligw
Sheet: Sheet1

Delivery | Return |  | Delivery | Return |  | GOAL
A | A
B | C |  | B | B |  | B | B
C | F |  | C | C |  | C | C
D | B |  | D | F |  | D | D
E | B |  | E |  |  | E | E
D | A |  |  |  |  | F | F
B | F
E | C
C | B
A | F
C | C
Spreadsheet: 77208d1277732708-formula-calculation-based-on-yes-no-list-quote_analyser2
Sheet: 28-06-10

Job # | Quote Value | Sector | Description | Job Won | Sectors | Job Won
1 | 100 |  |  | Yes | Building | Yes
2 | 100 |  |  |  | Landscaping | No
3 | 100 |  |  | No
4 | 100 |  |  | No
5 | 100
6 | 100
7 | 100 |  |  | Yes
8 | 100
9 | 100
10 | 100
13 | 100
Spreadsheet: 705581d1606205665-employee-monthly-salary-increased-on-their-anniversary-date-accounting
Sheet: Tech Stack

 | Budget Template
 | Department:
 | Tech Stack Budget
 | Instructions - Please update this tab for all current and future software licenses your department utilizes. If a software contract is greater than $5,000 a year, please also add it to the Tech Stack Contracts>$5k tab.  We need to track additional details for licenses greater than $5,000 to ensure that we are appropriately renewing and forecasting for our higher cost tools.
 |  | What the expense will be used for? | If Applicable, $/User |  |  |  |  |  |  |  |  |  |  |  |  | Total Year | Priority "High / Medium / Low"
 | Bill.com | Cloud-based Software that automates financial operations for small and midsize businesses
 | Capshare Inc. | Cloud-based Equity Management Platform
 | Chargify, LLC | Billing and Subscription Management Platform
 | Quickbooks Online | Cloud Based Accounting Software
 | Simple409A | 409A Valuation Consulting Firm
 | [NAME] | Cloud Based Accounting Software
 | SW License 7
 | SW License 8
 | SW License 9
 | SW License 10
 | SW License 11
 | SW License 12
 | SW License 13
 | SW License 14
 | SW License 15
 | SW License 16
 | SW License 17
 | SW License 18
 | SW License 19
 | SW License 20
 | Total Tech Stack
Spreadsheet: 211618d1359838044-return-unique-values-in-list-using-indirect-match-and-index-dependent-lists
Sheet: Day of Week Analysis

Select Menu Item Type | [NAME]
Select Day of Week | Overall
5 Weeks Out | 4 Weeks Out | 3 Weeks Out | 2 Weeks Out | 1 Week Out | Game Day | 1 Week Out | 2 Weeks Out | 3 Weeks Out | 4 Weeks Out | 5 Weeks Out
Spreadsheet: 31433d1227266659-multiple-results-in-sheet-1-one-complex-formula-in-sheet-2-example2
Sheet: Copy of Sheet2

Formula1 | 258552 |  | List of values
Formula2 | 1.474358974358974 |  | 0.1 | 111 |  |  | The formulas shown here are just as an example
Formula3 | 258550.5256410257 |  | 0.2 | 222 |  |  | The real formulas are far more advanced
Formula4 | 1554 |  | 0.3 | 333
Formula5 (sum) | 260104.525646728 |  | 0.4 | 444
 |  |  | 0.5 | 555
 |  |  | 0.6 | 666
 |  |  | 0.7 | 777
 |  |  | 0.8 | 888
 |  |  | 0.9 | 999
 |  |  | 1 | 1110
 |  |  | 1.1 | 1221
 |  |  | 1.2 | 1332
 |  |  | 1.3 | 1443
 |  |  | 1.4 | 1554
 |  |  | 1.5 | 1665
 |  |  | 1.6 | 1776
 |  |  | 1.7 | 1887
 |  |  | 1.8 | 1998
 |  |  | 1.9 | 2109
 |  |  | 2 | 2220
Spreadsheet: fletcher_sturm__11024__VaR Template
Sheet: Fletch

Fletch Sturm VaR Scenarios
 |  |  | 95 | 99 | 10d-99
Portfolio #1
 | a) |  | 83261 | 117561
 | b) |  | 208152 | 293903
 | c) |  | 416305 | 587806
Portfolio #2 |  |  | 492083 | 675387 |  |  | Gas Shorts are driving risk
 |  |  | 632595 | 906235 |  |  | Gas alone w/o power
Portfolio #2a |  |  | 361103 | 501913 |  |  | 20,000/day
Portfolio #3 |  |  | 274451 | 377110
Portfolio #4 |  |  | 195842 | 274774
Portfolio #5 |  |  | 1293548 | 1815823
500 N-Q02 Cin
30K/d J-V02 NX |  |  |  | -400000 | -427937
NG-R4 |  |  | 0.6 | 0.6 | 0.6
Combined
Spreadsheet: 069c49e2-b5a3-40ef-a6b7-787538c3a79b
Sheet: Sheet1

Table 1--U.S. cotton supply and use estimates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  |  | 2011/12
Item | 2010/11 |  | Feb. |  | Mar. |  | Apr.
 | Million acres
Upland:
Planted | 10.77 |  | 14.426 |  | 14.426 |  | 14.426
Harvested | 10.497 |  | 9.444 |  | 9.444 |  | 9.444
 | Pounds
Yield/harvested acre | 805 |  | 754 |  | 754 |  | 747
 | Million 480-lb. [NAME]
Beginning stocks | 2.929 |  | 2.572 |  | 2.572 |  | 2.572
Production | 17.6 |  | 14.828 |  | 14.828 |  | 14.704
Total supply   1/ | 20.531 |  | 17.405 |  | 17.415 |  | 17.291
[NAME] use | 3.874 |  | 3.475 |  | 3.375 |  | 3.373
Exports | 13.881 |  | 10.35 |  | 10.35 |  | 10.75
Total use | 17.755 |  | 13.825 |  | 13.725 |  | 14.123
Ending stocks  2/ | 2.572 |  | 3.596 |  | 3.701 |  | 3.198
 | Percent
Stocks-to-use ratio | 14.5 |  | 26 |  | 27 |  | 22.6
 | 1,000 acres
Extra-long staple:
Planted | 204.2 |  | 306.4 |  | 306.4 |  | 306.4
Harvested | 201.7 |  | 303.9 |  | 303.9 |  | 303.9
 | Pounds
Yield/harvested acre | 1200 |  | 1336 |  | 1336 |  | 1345
 | 1,000 480-lb. [NAME]
Beginning stocks | 18 |  | 28 |  | 28 |  | 28
Production | 504 |  | 846 |  | 846 |  | 851
Total supply   1/ | 529 |  | 879 |  | 874 |  | 879
[NAME] use | 26 |  | 25 |  | 25 |  | 27
Exports | 495 |  | 650 |  | 650 |  | 650
Total use | 521 |  | 675 |  | 675 |  | 677
Ending stocks  2/ | 28 |  | 204 |  | 199 |  | 202
 | Percent
Stocks-to-use ratio | 5.4 |  | 30.2 | 30.2 | 29.4 |  | 29.9
1/ Includes imports.  2/ Includes unaccounted.
Last update:  04/11/12.
Sources: USDA, World Agricultural Outlook Board; and USDC,
U.S. Census Bureau.
Spreadsheet: 116753d1312114188-nested-if-function-the-consultant
Sheet: Sheet1

Gender | Aggregate |  | Male Target-> | 106 | Female Target-> | 100
male | 23
female | 3
male | 35
female | 54543
male | 33
female | 3
male | 234
female | 233
male | 22
female | 56
male | 567
female | 5688
male | 356
Spreadsheet: 64458d1265303251-crosschecking-data-datacomparison
Sheet: Sheet2

Product | Price | Check
Prod1x | 1 | Product Missing
Prod2 | 2 | Good
Prod3 | 3 | Price Different
Prod4 | 4 | Good
Prod5 | 44 | Price Different
Prod6 | 6 | Good
Prod7 | 7 | Good
Prod8 | 8 | Product Missing
Prod9 | 9 | Good
Prod10 | 10 | Good
Prod11 | 11 | Good
Prod12 | 12 | Good
Prod13 | 13 | Good
Prod14 | 14 | Good
Prod15 | 15 | Good
Prod16 | 16 | Good
Spreadsheet: 106530d1303810918-multiple-if-match-data-across-sheets-copy-of-mis-format
Sheet: Database

UCC | Cust ID | Account number | Client Name | RM Name | [NAME] | ZH Name
3 | 1 | 45 | #N/A |  |  |  |  |  |  | 0
4 | 2 | 46 | #N/A
5 | 3 | 47 | 0
6 | 4 | 48 | #N/A
Spreadsheet: 745348d1629881654-budget-and-cash-flow-formula-test-repeat-fixed-cost
Sheet: Ark1

 |  |  |  |  |  | Year | Year | Year | Year | Year | Total
 | Acquisition Year | Product Lifetime | Cost |  |  | 1 | 2 | 3 | 4 | 5
 | 2 | 3 | 999 |  | Row 1 |  |  |  |  |  |  | Writes data according to the ACQUISITION YEAR
 | 3 | 3 | 0 |  | Row 2 |  |  |  |  |  |  | Writes data according to the PRODUCT LIFETIME
 | 4 | 1 | 0 |  |  |  |  |  |  |  |  | How do i merge the two statements?
 | 5 | 3 | 0
 | 5 | 1 | 0
 | Total
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 7185 | 955 | 13407 | 1041
OTHER* | 45 | 681 | 13 | 389
TOTAL | 7230 | 1636 | 13420 | 1430
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 879425d1726919395-dept-and-date-to-auto-calculate-based-on-todays-date-book1-6-
Sheet: Days safe per dept

 |  | Shift
 | Dept | 1 | 2 | 3
 | Grocery
 | Deli
 | Meat
 | Freezer
 | Produce
 | Shift is Q | equal [NAME] | then R | ,
Spreadsheet: 9660fb95-f505-46a5-b3f2-829392dedbcd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LYSO | Test | LYSO | Lysozyme, IgE | Lysozyme, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
LYSO | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LYSO | Result | LYSO | Lysozyme, IgE | Lysozyme, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 11182-3 | Lysozyme Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 53960d1253886807-transferring-data-from-many-sheets-to-a-single-sheet-mohit-bank-sample
Sheet: Citi 018

Citibank xxxxxxxxxxxxxxx018
Clearing Dt | Issue Dt | Dr/Cr | Particulars | Chq No | Deposits | Withdrawal | Balance | Remarks
 |  |  | Opening |  |  |  | 94462.69
2009-06-27 00:00:00 | 2009-06-27 00:00:00 | Cr | Royal Securities | 000821 |  | 8000 | 86462.69
2009-06-27 00:00:00 | 2009-06-27 00:00:00 | Cr | Star enterprises | 000816 |  | 3321 | 83141.69
2009-06-28 00:00:00 | 2009-06-27 00:00:00 | Cr | ABC Ltd. |  |  | 2500 | 80641.69
2009-06-29 00:00:00 | 2009-06-28 00:00:00 | Dr | RTGS RAVI ROAD LINES INDIA PVT LTD SHO |  | 100000 |  | 180641.69
2009-06-29 00:00:00 | 2009-06-29 00:00:00 | Cr | Express Station |  |  | 146000 | 34641.69
2009-06-29 00:00:00 | 2009-06-29 00:00:00 | Cr | G.G. Service Station | 000825 |  | 19636 | 15005.69
2009-06-29 00:00:00 | 2009-06-29 00:00:00 | Cr | C.Cantt | 000823 |  | 25000 | -9994.309999999998
2009-06-30 00:00:00 | 2009-06-28 00:00:00 | Dr | XYZ Corp |  | 34000 |  | 24005.69
2009-06-30 00:00:00 | 2009-06-28 00:00:00 | Cr | Battery Supplier |  |  | 180 | 23825.69
2009-06-30 00:00:00 | 2009-06-28 00:00:00 | Cr | NEFT/PK Enterprises |  |  | 15000 | 8825.690000000002
2009-06-30 00:00:00 | 2009-06-29 00:00:00 | Cr | Baby Seats Mfg. |  |  | 15000 | -6174.309999999998
2009-07-01 00:00:00 | 2009-06-30 00:00:00 | Dr | Cash Manpada |  | 80000 |  | 73825.69
2009-07-02 00:00:00 | 2009-06-29 00:00:00 | Cr | Arihant Tyres | 000822 |  | 74500 | -674.3099999999977
2009-07-02 00:00:00 | 2009-06-30 00:00:00 | Dr | FTD From 831.210.20 To 656.200.811 |  | 50528 |  | 49853.69
2009-07-02 00:00:00 | 2009-06-30 00:00:00 | Cr | Contra |  |  | 500000 | -450146.31
2009-07-03 00:00:00 | 2009-06-30 00:00:00 | Dr | RTGS RAVI ROAD LINES INDIA PVT LTD SHO |  | 375000 |  | -75146.31
2009-07-03 00:00:00 | 2009-07-01 00:00:00 | Cr | Arihant Tyres |  |  | 21000 | -96146.31
2009-07-03 00:00:00 | 2009-07-01 00:00:00 | Cr | ABC Ltd. |  |  | 25000 | -121146.31
2009-07-03 00:00:00 | 2009-07-03 00:00:00 | Dr |  |  | 250000 |  | 128853.69
2009-07-04 00:00:00 | 2009-07-02 00:00:00 | Cr | [NAME] |  |  |  | 128853.69
 |  |  |  |  |  |  | 128853.69
 |  |  |  |  |  |  | 128853.69
 |  |  |  |  |  |  | 128853.69
Spreadsheet: 538297d1505501249-figure-gradation-figure-gradation
Sheet: Sheet1

32427.22 |  | Total Qty.
30349.6
25906.53 |  | Avg. Of Top [20%]
24613.42
22524.85 |  | Avg. Of Medium [30%]
22032.84
21978.23 |  | Avg. Of Bottom [50%]
14547.73
14338.12
13633.5
13238.04
12320.55
12248.12
11999.27
11188.6
10871.45
10585.2
10486.4
9816.09
9750.49
9717.23
9232.72
8998.79
8920.65
8687.53
8629.08
8576.1
8529.33
8410.44
8092.39
7306.12
6433.02
6395.58
5916.84
5892.87
5621.15
5606.63
5416.76
5177.2
5014.15
4874.6
4869.75
4812.87
4790.76
4658.45
4608.66
4527.6
4417.22
4388.68
4386.12
4320
4313.18
4152
4140.43
3862.1
3856.03
3712.94
3507.94
3496.65
3465.5
3373.88
3328.8
3317.79
3195.6
3191.9
3020.93
2765.49
2677.04
2665.55
2598.25
2590.21
2470.7
2436.2
2383.48
2308.76
2298.6
2239.02
2214.73
2175.79
2148.62
2146.5
2143.05
2109.07
2103.09
2090.78
2056.35
2027.92
2005.35
1987.4
1973.75
1910.65
1881.84
1792.2
1774.76
1750
1742.4
1725.1
1705.05
1698.75
1645.83
1598.47
1598
1556.44
1553.15
1540.49
1530.3
1482.35
1482.2
1450.25
1414.2
1412.37
1408.26
1378.05
1304.55
1288.8
1247.84
1237.67
1215.07
1208.06
1179.44
1166.7
1165.8
1152.53
1151.85
1127.95
1116.12
1104.2
1098.05
1095.01
1081.55
1080.03
1070.05
1069.43
1059.35
1049.9
1040.75
1037.21
1028.86
976.15
958.28
948.25
938.25
934.29
911.6
890.3
887.98
877.35
789.6
777.91
767.07
755.7
753.15
751.8
747.6
741.75
731.09
728.83
716.96
705.02
700.8
689.4
659.4
658.58
656
625.8
619.96
611.03
607.42
598.53
596.1
591.55
579.86
577.58
568.58
567.58
562.5
554.45
552.6
549.45
540.95
533.48
523.22
521.18
518.64
512.95
510.6
500.36
498.22
495.61
492.6
490.3
485.35
472.55
464.6
458.52
451.2
444.2
444.15
440.8
437.4
436.28
427.95
425
424.73
422.55
421.77
421.4
419.85
413.49
412.35
410.2
408.05
405.78
402.97
396
392.85
392.34
375
369.8
368.4
364.4
361.2
354.15
350
345.9
344.85
342.2
336.45
334.68
334.23
324.86
321.89
319.2
317.55
308.35
302.18
299.65
298.93
290.25
289.54
286.8
286.4
285.6
285.4
279.2
276.08
274.45
273.1
272.25
270.15
270.13
258.84
254.4
249.8
246.36
243.3
241.23
239.07
238.5
235.41
231.65
227
226.7
225
224.52
219.44
217.5
216.15
215.2
215.1
206.1
204.75
202.28
195.85
195.4
192
189.75
188.9
182.4
179.14
174
172.64
168.4
167.4
163.5
163.2
156.2
154.43
153.12
151.7
150.6
150
148.72
144.68
143.3
142.52
140.85
140
134.1
131.6
126.8
125
124.1
122.77
120.6
120
117.6
114.15
113.1
112.5
112.5
111.06
107.5
106.35
105
105
102.42
100.9
94.7
94.46
90.22
90.2
90
87.75
87.62
85.4
84
83.95
82.72
82.5
81.2
73.12
72.8
71.63
70.5
70
68.7
68.25
61.8
61.02
60.9
60.75
60.15
60
59.7
56.96
54.75
54.75
52.5
50.4
48
44.1
40
37.5
31.05
30
30
30
28.3
24.3
24.3
21.97
14.14
6.6
6.6
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
-375.45