tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744172d1629038606-calculate-the-number-of-unique-names-based-on-category-and-code-8help15
Sheet: Sheet1

 | Code | Name1 | category1 | [NAME] | category2
 | 1 | Rayhen | the masses | Rayhen | the masses | Code | Party member | the masses | other
 | 1 | Abdulla | Party member | Rayhen | the masses | 1 | 2 | 1 | 1
 | 1 | Rayhen | the masses | [NAME] | Party member | 2 | 2 | 1 | 2
 | 1 | Abdulla | Party member | Abdulla | Party member
 | 1 | Syed | other | Syed | other
 | 2 | Rayhen | the masses | [NAME] | Party member
 | 2 | [NAME] | Party member | Syed | other
 | 2 | [NAME] | Party member | Abdulla | Party member
 | 2 | Syed | other | Rayhen | the masses
 | 2 | Mitra | other | Mitra | other
Spreadsheet: 785286d1656327172-get-data-from-multiple-criteria-of-single-column-sample-27062022
Sheet: Sheet1

DataTable |  |  |  |  |  |  |  |  | RESULT
 | Product Code | 985 | 501 | 751 | 598 |  |  |  |  | 2022-03-18 00:00:00
Date | Branch | Escalate | Priority | Advanced | Urgent |  |  |  | Branch | SEV 1 | SEV 2
2022-06-23 00:00:00 | GLD 5 | 150 | 115 | 80 | 566.1538461538462 |  |  |  | GLD 5
2022-06-23 00:00:00 | MAK 2 | 350 | 315 | 280 | 1550.769230769231 |  |  |  | MAK 2
2022-06-23 00:00:00 | XDC 6 | 400 | 365 | 330 | 1796.923076923077 |  |  |  | XDC 6
2022-06-23 00:00:00 | CFR 4 | 428 | 393 | 358 | 1934.769230769231 |  |  |  | CFR 4
2021-04-25 00:00:00 | GLD 5 | 218 | 183 | 148 | 900.9230769230769
2021-04-25 00:00:00 | MAK 2 | 418 | 383 | 348 | 1885.538461538461
2021-04-25 00:00:00 | XDC 6 | 468 | 433 | 398 | 2131.692307692308
2021-04-25 00:00:00 | CFR 4 | 496 | 461 | 426 | 2269.538461538461
2022-03-18 00:00:00 | GLD 5 | 286 | 251 | 216 | 1235.692307692308
2022-03-18 00:00:00 | MAK 2 | 486 | 451 | 416 | 2220.307692307692
2022-03-18 00:00:00 | XDC 6 | 536 | 501 | 466 | 2466.461538461539
2022-03-18 00:00:00 | CFR 4 | 564 | 529 | 494 | 2604.307692307692
 |  |  |  |  |  |  | Severity | Product Code
 |  |  |  |  |  |  | SEV 1 | 501
 |  |  |  |  |  |  | SEV 1 | 598
 |  |  |  |  |  |  | SEV 2 | 985
 |  |  |  |  |  |  | SEV 2 | 751
Spreadsheet: 673884d1587576126-count-with-multiple-criterias-count-examples
Sheet: Sheet1

 |  |  |  | Keep in mind that the names change so I can't use a static name as an option.
Group | People | Country |  | How many people in each group for each country? |  |  |  | The results should be the following
AEBC | Neo | Brazil
AEBC | Meleesa | Brazil |  |  | Brazil | USA |  |  | Brazil | USA
AEBC | [NAME] | USA |  | AEBC |  |  |  | AEBC | 2 | 1
CVBG | Amanda | Brazil |  | CVBG |  |  |  | CVBG | 1 | 2
CVBG | [NAME] | USA
CVBG | [NAME] | USA
Spreadsheet: 723223d1615563537-count-duplicate-values-in-the-same-cell-and-in-a-range-example-1-2-1-
Sheet: Sheet2

 | SITE | TOTAL CHARGABLE (£) | TOTAL NON-CHARGABLE (£) | NO. DAYS CHARGABLE | NO. DAYS NON-CHARGABLE | [NAME] PLOTS (YES) | NON-CHARGABLE PLOTS (NO) | TOTAL NO. OF PLOTS | AVERAGE CHARGABLE PLOTS (£) | AVERAGE NON-CHARGABLE PLOTS (£) | AVERAGE DAYS - CHARGABLE PLOTS | AVERAGE DAYS - NON-CHARGABLE PLOTS
 | Gipping [NAME]
 | Colne Meadows
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Walker

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 704914d1605803804-microsoft-excel-remove-duplicate-from-each-entry-each-cell-data
Sheet: Sheet1

 | Now | Needed like that
1 | 3330 N KINGSHIGHWAYBLVD APT 511BLVD APT 511 | 3330 N KINGSHIGHWAY BLVD APT 511
2 | 1342 MONTCLAIR AVEAPT 217APT 217APT 217 | 1342 MONTCLAIR AVE APT 217 APT
3 | 3330 N KINGSHIGHWAYBLVD APT 402BLVD APT 402BLBLVD APT 402 | 3330 N KINGSHIGHWAYBLVD APT 402 BLVD
4 | 4333 NEBRASKA AVEAPT B107APT B107APT B107 | 4333 NEBRASKA AVE APT B107
5 | 4535 PENNSYLVANIA AVEFL 2FL 2FL 2 | 4535 PENNSYLVANIA AVE FL 2FL
6 | 300 S GRAND BLVDAPT 1212APT 1212APT 1212 | 300 S GRAND BLVD APT 1212
7 | 4310 SAINT FERDINANDAVE APT 607AVE APT 607 | 4310 SAINT FERDINAND AVE APT 607
8 | 310 S GRAND BLVDAPT 1007APT 1007APT 1007 | 310 S GRAND BLVD APT 1007
9 | 11020 DUNKLIN DRAPT 212APT 212APT 212APT 212 | 11020 DUNKLIN DR APT 212
10 | 5521 WATERMAN BLVDAPT EAPT EAPT EAPT EAPT E | 5521 WATERMAN BLVD APT EAPT
11 | 310 S GRAND BLVDAPT 2612APT 2612APT 2612APT 2612 | 310 S GRAND BLVD APT 2612
12 | 9905 HOBBITS GLEN CTAPT CAPT CAPT C | 9905 HOBBITS GLEN CTAPT
13 | 4838 ANDERSON AVEAPT 1EAPT 1EAPT 1EAPT 1E | 4838 ANDERSON AVE APT 1E
Spreadsheet: 91884d1291588564-summarising-data-using-combo-box-example-2-
Sheet: AUDI

Manufacturer | Fuel Type |  | Model
AUDI | Petrol | AUDIPetrol | R8
AUDI | Petrol | AUDIPetrol | R8
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | RS6
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | R8
AUDI | Petrol | AUDIPetrol | R8
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | A8
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | Q7
Spreadsheet: 870427d1716942093-how-to-return-data-into-email-text-using-index-function-auto-send-sample
Sheet: Sheet1

 |  |  |  |  |  | [NAME]
 |  |  | -Delivery Number - |  |  | [NAME],
 |  |  |  |  |  | WTS shipped and delivered |  | units of product on |  | to xyz. | If you have any immediate questions, please call or send me an email.
 |  |  |  |  |  | Thanks,
 |  |  |  |  |  | [NAME]
 |  |  | -Delivery Number - |  |  | [NAME],
 |  |  |  |  |  | WTS shipped and delivered |  | units of product on |  | to xyz. | If you have any immediate questions, please call or send me an email.
 |  |  |  |  |  | Thanks,
 |  |  |  |  |  | [NAME]
 |  |  | -Delivery Number - |  |  | [NAME],
 |  |  |  |  |  | WTS shipped and delivered |  | units of product on |  | to xyz. | If you have any immediate questions, please call or send me an email.
 |  |  |  |  |  | Thanks,
 |  |  |  |  |  | [NAME]
Spreadsheet: 328523d1403934058-how-to-link-drop-down-list-to-table-groups-tracker-by-month
Sheet: Nov

Century Park, Jakarta - Groups Tracker
Group Name | Sales | Event | [NAME] | Departure Date | Total Room | Rate Offered | Rate Accepted | Cut Off Date | Inclusions | Total Revenue | Status | Comments
Trilogy Music Indonesia | [NAME] | Unknown | 2014-11-03 00:00:00 | 2014-11-11 00:00:00 | 35 | 1000000 | 1000000 | 2014-10-03 00:00:00 | 2 Breakfast |  | Tentative | Wait Payment |  | Please Select
[NAME] Indonesia | Vera | Unknown | 2014-11-03 00:00:00 | 2014-11-07 00:00:00 | 60 | 1200000 | 1200000 | 2014-10-03 00:00:00 | 2 Breakfast |  | Tentative | Wait Payment |  | Tentative
Rama Tour Group | [NAME] | Unknown | 2014-11-05 00:00:00 | 2014-11-07 00:00:00 | 100 | 1010000 | 1010000 | 2014-10-10 00:00:00 | 2 Breakfast |  | Tentative | NO MOP |  | Approved
[NAME] | [NAME] | Unknown | 2014-11-10 00:00:00 | 2014-11-13 00:00:00 | 210 | 875000 | 875000 | 2014-09-26 00:00:00 | 2 Breakfast |  | Tentative | Wait Payment |  | Not Approved
PP Muhammadiyah | Vera | Unknown | 2014-11-20 00:00:00 | 2014-11-23 00:00:00 | 297 | 1200000 | 1200000 | 2014-09-26 00:00:00 | 2 Breakfast |  | Tentative | NO MOP |  | Confirm
UNEP - KLH | Ichsan | Unknown | 2014-11-24 00:00:00 | 2014-11-27 00:00:00 | 150 | 1200000 | 1200000 | 2014-10-17 00:00:00 | 2 Breakfast |  | Tentative | NO MOP |  | Guarantee
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cancel
Spreadsheet: 878515d1725622077-desk-booking-tool-for-locating-people-davidgr-desk-booking-tool-1-spill-365-aligw
Sheet: Sheet2

 | Where are they on 1/1/24?
person1 |  |  | INDEX($A$1:$A$7,MATCH($A2,CELL("address",INDIRECT(ADDRESS(1,MATCH(DATE("2024","1","1"),$1:$1,0),1,1,"Sheet1")))&":"&CELL("address",INDIRECT(ADDRESS(7,MATCH(DATE("2024","1","1"),$1:$1,0),1,1,"Sheet1")))),1)
person2 | [NAME]
person3 | desk4
person4 | desk3
person5 | desk5
person6 | [NAME]
 | desk1
person2 | [NAME]
person3 | desk4
person4 | desk3
person5 | desk5
person6 | [NAME]
Spreadsheet: 780370d1652427495-search-from-filtered-row-returning-values-of-not-blank-cell-test_book1
Sheet: MASTER

NAME | Basket | Shoping Date | Apples | Oranges | Bananas | Mango | Pineapple | Guava
Adam | 1 |  | 1 |  | 3 |  | 2
Boy | 2 |  |  | 4 | 2 | 7 |  | 6
[NAME] | 3 | 2021-01-01 00:00:00 | 1 |  | 1 |  | 1 | 1
[NAME] | 4 |  | 2 | 5 | 4 |  | 4
[NAME] | 5 |  | 2 |  |  |  |  | 9
[NAME] | 6
Spreadsheet: 834216d1687528488-help-to-create-table-based-on-drop-down-list-selection-dynamic-table-example
Sheet: Sheet1

Product | Low | Med | High |  |  |  |  |  | Condition | Low
Product 1 | 50 | 25 | 10
Product 2 |  | 25 | 25 |  |  |  |  |  | Product | Allocation
Product 3 | 50 | 25 | 10
Product 4 |  | 25 | 10
Product 5 |  |  | 25
Product 6 |  |  | 20
Spreadsheet: 51222d1250764537-dynamic-sorting-keepting-data-integrity-problem-new-microsoft-excel-worksheet
Sheet: Solution

DATA SET ORIGINAL | OUR DATA | OTHER MAPPED DATA | EXAMPLE OF LETTER | Number
A | A | A IS A LETTER | ARM | 1
B | B | B IS A LETTER | BRAKE | 2
C | C | C IS A LETTER | CAT | 3
D | D | D IS A LETTER | DOG | 4
E | E | E IS A LETTER | EGG | 5
F | F | F IS A LETTER | FAR | 6
Spreadsheet: 67355d1267987126-sum-help-example
Sheet: Sheet1

Sold For | Listing fee | Final Fee | Other fees | Date Paid | PROFIT | %PROFIT |  | Profit of actual item sales
140 | 1.1 | 14.1 |  | 2010-03-06 00:00:00 | 124.8 | 0.8914285714285715 |  | I want this to be the total of colum F But only including rows when the "Sold For" has a value so in this instance it would be 123.70, which is the sum of line 3and 5 since 4 has no value
0 | 5 | 10 | 21 | 2010-03-06 00:00:00 | -36 | #N/A
15 | 1 | 14.1 | 1 | 2010-03-06 00:00:00 | -1.1 | -0.0733333333333333
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
 |  |  |  |  | 0 | #N/A
Spreadsheet: 699897d1602815074-formula-help-countifs-sumproduct-excel-help
Sheet: AFTER

 |  | LEGEND: W = Work, Wn = hours worked (ex. W10 is 10 hour work day), R = Daily Test, E = Weekly Test, T = Pre Employment Test |  |  |  |  |  | APPLE | [NAME] | CHARLIE | DELTA | EDWARD | FRANKLIN
 |  |  |  |  |  |  | QTY | 4 | 2 | 3 | 1 | 4 | 1
 |  |  |  |  |  |  | ADJ | U | X |  | U | X | Y
Date | DAY | PLACE | Notes |  | T | W | ID | S1 | S2 | S3 | [NAME] | S5 | S6
2020-11-04 00:00:00 | 1 | [NAME] | finish driveway |  | 7 |  |  | T |  | W10,R |  | W11 | W11
 | 2 | [NAME] | finish driveway |  | 0 |  |  |  | W11 |  | W
 | 3 | [NAME] | frame house |  | 2 | 4 |  |  |  | T |  | W10
 | 4 | [NAME] | frame house |  | 7 |  |  | W10,E | W11,T |  |  |  | T
 |  | [NAME] | [NAME] steps |  | 3 |  |  | W10 | W11,T | W10,R
TOTALS: |  |  | Total WORK DAYS |  |  |  |  | # of 10 Hr Days |  |  | # of 11 Hr Days
 |  |  | Total TESTS |  | #
Spreadsheet: 747223d1631292756-if-statement-help-needed-vendor-test
Sheet: Sheet1

 | Vendor Number: | 01-0001008
 | Vendor Number: | 01-0001015
 | Vendor Number: | 01-0001017
 | Vendor Number: | 01-0001019
 | Vendor Number: | 01-0001027
 | Vendor Number: | 01-0001037
 | Vendor Number: | 01-0001043
 | Vendor Number: | 01-0001044
 | Vendor Number: | 01-0001046
 | Vendor Number: | 01-0001049
 | Vendor Number: | 01-0001067
 | Vendor Number: | 01-0001068
 | Vendor Number: | 01-0001069
 | Vendor Number: | 01-0001070
 | Vendor Number: | 01-0001073
 | Vendor Number: | 01-0001081
 | Vendor Number: | 01-0001098
 | Vendor Number: | 01-0001102
 | Vendor Number: | 01-0001104
 | Vendor Number: | 01-0001106
 | Vendor Number: | 01-0001108
 | Vendor Number: | 01-0001113
 | Vendor Number: | 01-0001120
 | Vendor Number: | 01-0001130
 | Vendor Number: | 01-0001131
 | Vendor Number: | 01-0001141
 | Vendor Number: | 01-0001144
 | Vendor Number: | 01-0001147
 | Vendor Number: | 01-0001453
 | Vendor Number: | 01-0001457
 | Vendor Number: | 01-0001459
 | Vendor Number: | 01-0001462
 | Vendor Number: | 01-0001464
 | Vendor Number: | 01-0001466
 | Vendor Number: | 01-0001639
 | Vendor Number: | 01-0001755
 | Vendor Number: | 01-0001776
 | Vendor Number: | 01-0001896
 | Vendor Number: | 01-0001903
 | Vendor Number: | 01-0001921
 | Vendor Number: | 01-0003202
 | Vendor Number: | 01-0003976
 | Vendor Number: | 01-0004770
 | Vendor Number: | 01-0004929
 | Vendor Number: | 01-0006436
 | Vendor Number: | 01-0008186
 | Vendor Number: | 01-0008354
 | Vendor Number: | 01-0010440
 | Vendor Number: | 01-0010728
 | Vendor Number: | 01-0010732
 | Vendor Number: | 01-0010887
 | Vendor Number: | 01-0010975
 | Vendor Number: | 01-0011015
 | Vendor Number: | 01-0011024
 | Vendor Number: | 01-0011039
 | Vendor Number: | 01-0011045
 | Vendor Number: | 01-0011069
 | Vendor Number: | 01-BGL1001
Spreadsheet: 455927d1460566569-scheduling-independent-variables-160405_schedule_r2
Sheet: MINE SCHEDULE

 | KRAKATOA : LONG-TERM MINE SCHEDULE
 | STAGE |  | LENSE | ID | TOTAL TIME (d) | CHECK (d) | YEAR 0 |  |  |  |  |  |  |  |  |  |  |  | YEAR 1 |  |  |  |  |  |  |  |  |  |  |  | YEAR 2 |  |  |  |  |  |  |  |  |  |  |  | YEAR 3
 |  |  |  |  |  |  | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | PRIMARY - ACCESS |  | MAIN & HW | PORTAL RAMP
 |  |  |  | CROSS-CUT
 |  |  |  | MAIN RAMP
 |  |  | MAIN | 1230 ACCESS
 |  |  |  | 1200 ACCESS
 |  |  |  | 1170 ACCESS
 |  |  |  | 1150 ACCESS
 | SECONDARY - DRIFT & STOPE & RETREAT |  | MAIN | 1230 LEVEL
 |  |  |  | 1200 LEVEL
 |  |  |  | 1170 LEVEL
 |  |  |  | 1150 LEVEL
 |  |  |  |  |  | TOTAL
Spreadsheet: 769631d1645623543-if-and-formula-help-excel-forum-1
Sheet: Sheet1

 |  |  | Price | Quantity | Total Excluding Transport | Transport Cost |  |  |  |  |  |  | 0 | 50 | 10
 |  |  | 33.29 | 1 |  |  |  |  |  |  |  |  | 51 | 150 | 20
 |  |  | 41.5 | 1 |  |  |  |  |  |  |  |  | 151 | 1000 | 40
 |  |  | 42 | 1 |  |  |  |  |  |  |  |  | 1001 | 2000 | 70
 |  |  | 33 | 40
 |  |  | 39 | 10
Spreadsheet: kate_symes__18562__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
 | 2001-01-23 00:00:00 |  | 281.71 | 13600 | 186.9 | 3680
 | 2001-01-22 00:00:00 |  | 320.08 | 14960 | 201.71 | 5240
 | 2001-01-21 00:00:00 |  |  |  |  |  | 235 | 29400
 | 2001-01-20 00:00:00 |  | 506.48 | 4320 | 236.31 | 8400
 | 2001-01-19 00:00:00 |  | 505.66 | 4384 | 247.42 | 5032
 | 2001-01-18 00:00:00 |  | 429.29 | 7920 | 278.82 | 6440
 | 2001-01-17 00:00:00 |  | 252.4 | 8000 | 204.13 | 4600
 | 2001-01-16 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-15 00:00:00 |  | 186.75 | 10720 | 158.7 | 4400
 | 2001-01-14 00:00:00 |  |  |  |  |  | 151.53 | 9000
 | 2001-01-13 00:00:00 |  | 171.82 | 18176 | 152.53 | 3400
 | 2001-01-12 00:00:00 |  | 178.58 | 15056 | 158.12 | 3400
 | 2001-01-11 00:00:00 |  | 178.58 | 15056 | 158.12 | 3400
 | 2001-01-10 00:00:00 |  | 176.02 | 12720 | 158.32 | 3800
 | 2001-01-09 00:00:00 |  | 171.72 | 13856 | 156.09 | 2200
 | 2001-01-08 00:00:00 |  | 159.12 | 13120 | 151.13 | 1600
 | 2001-01-07 00:00:00 |  |  |  |  |  | 150 | 4200
 | 2001-01-06 00:00:00 |  | 152.46 | 10720 | 150.55 | 1520
 | 2001-01-05 00:00:00 |  | 152.46 | 10720 | 150.55 | 1520
 | 2001-01-04 00:00:00 |  | 161.59 | 12320 | 155.14 | 2920
 | 2001-01-03 00:00:00 |  | 175.15 | 2720 | 170 | 1000
 | 2001-01-02 00:00:00 |  | 165.38 | 4240 | 155.83 | 720
Spreadsheet: 270956d1381766195-how-to-tackle-multiple-conditions-date-range-destinations-and-type-of-load-with-vlookup-tarrif-charges
Sheet: RR Data Oct 2013

THIS IS TO CERTIFY THAT THE FOLLOWING SERVICE TAX CHARGES WERE COLLECTED FOR THE MONTH OCT' 2013
S. No. | Rake No. | From Stn. | To Stn. | Inv. No. | RR No. | RR Date | No. of wgns | No. of [NAME] loaded | Actual Qty. Loaded | Charged Qty. | Basic Rate Charged | Rly Freight Paid | Service Tax | Edu. Cess | Higher Edu. Cess | Total Service Tax Paid | [NAME] PMT | Calc. Freight | Final Rate PMT | 0.15 | 0.05 | 2-Point surchg. 5% | 0.03708
1 | 1 | NDL | SGWF | 1 | 212000052 | 2013-10-01 00:00:00 | 10 | 13120 |  | 657 |  | 425946 | 14786 | 296 | 148
2 | 1 | NDL | SGWF | 2 | 212000053 | 2013-10-01 00:00:00 | 6 | 7848 |  | 393 | 524.9 | 256356 | 8899 | 178 | 89
3 | 1 | NDL | SGWF | 3 | 212000054 | 2013-10-01 00:00:00 | 4 | 5152 |  | 258 | 524.9 | 173533 | 6024 | 120 | 60
4 | 1 | NDL | SGWF | 4 | 212000055 | 2013-10-01 00:00:00 | 4 | 5272 |  | 264 | 524.9 | 169590 | 5887 | 118 | 59
5 | 1 | NDL | SGWF | 5 | 212000056 | 2013-10-01 00:00:00 | 4 | 5212 |  | 261 | 524.9 | 171562 | 5955 | 119 | 60
6 | 1 | NDL | SGWF | 6 | 212000057 | 2013-10-01 00:00:00 | 1 | 1318 |  | 66 | 524.9 | 173533 | 6024 | 120 | 60
7 | 1 | NDL | SGWF | 7 | 212000058 | 2013-10-01 00:00:00 | 4 | 5152 |  | 258 | 524.9 | 41412 | 1438 | 29 | 14
8 | 1 | NDL | SGWF | 8 | 212000059 | 2013-10-01 00:00:00 | 1 | 1318 |  | 66 | 524.9 | 43384 | 1506 | 30 | 15
9 | 1 | NDL | SGWF | 9 | 212000060 | 2013-10-01 00:00:00 | 4 | 5072 |  | 255 | 524.9 | 173533 | 6024 | 120 | 60
10 | 1 | NDL | SGWF | 10 | 212000061 | 2013-10-01 00:00:00 | 3 | 3954 |  | 198 | 524.9 | 130150 | 4518 | 90 | 45
11 | 2 | PNM | KUL | 1 | 212000560 | 2013-10-02 00:00:00 | 22 | 27936 |  | 1399 | 1172.4 | 2143262 | 74399 | 1488 | 744
12 | 2 | PNM | TIR | 1 | 212000561 | 2013-10-02 00:00:00 | 20 | 25260 |  | 1265 | 1117.1 | 1846587 | 64100 | 1282 | 641
13 | 3 | NDL | MYP | 1 | 212000062 | 2013-10-04 00:00:00 | 40 | 50460 |  | 2527 | 894.5 | 2830646 | 98260 | 1965 | 983
14 | 4 | PNM | NGSM | 1 | 212000562 | 2013-10-05 00:00:00 | 42 | 54636 |  | 2736 | 1117.1 | 3827438 | 132861 | 2657 | 1329
15 | 5 | PNM | DD | 1 | 212000563 | 2013-10-06 00:00:00 | 42 | 54696 |  | 2739 | 837.8 | 2873627 | 99752 | 1995 | 998
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
Spreadsheet: 485631d1476982349-count-if-ryan-project-1
Sheet: Oct 4 

Category # | What Happened | My Conclusion | Report # | Firm Name | Stock Symbol | What Issue | Trade Date
1 | insert explation here | what I think | [NAME] | Firm E | QWA | RWNA | 2015-10-04 00:00:00
2 | insert explation here | what I think | de159 | Firm B | KMN | Other | 2015-10-04 00:00:00
Spreadsheet: 82581d1282652590-excel-2007-vlookup-formula-for-more-than-one-sheet-and-if-function-workbook-1
Sheet: Subcontractors

Project A
Subcontractors | Subcontractors Code | Filed in
Tanmiya Realty Development Co. | [NAME] | Filed in Gravity Tower - Tanmiya File No. 01
[NAME] | EmadGT10 | Filed in Gravity Tower - Tanmiya File No. 01
Al-Mashaer Company | MashaerGT10 | Filed in Gravity Tower - Tanmiya File No. 01
OBD10 | OBDGT10 | Filed in Gravity Tower - OBD File No. 01 | Filed in Gravity Tower - Interim Payments File No. 02
[NAME] Establishment | HusseinMoradGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Al-Raed International Company | RaedGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
[NAME]. Gen. [NAME]. & Cont | [NAME] | Filed in Gravity Tower - Subcontractors' File No. 01
National Cleaning Company | NationalGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
[NAME] | SadakaGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Tekneen Building Maintenance Services Company | TekneenGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
[NAME] Gen. [NAME]. Company | MuhalhelGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
National Montreal Company | NationalMontrealGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
White Shadow Company | WhiteGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Eng. [NAME] | AmjadGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | [NAME] | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | NasserGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | IbrahimGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | MohammadTaherGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Eng. [NAME] | AhmadTaherGT10 | Filed in Gravity Tower - Site Correspondences's File No. 01
Media Corner Company | MediaGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
PROEX | PROEXGT10 | Filed in Gravity Tower - Subcontractors' File No. 01
Project B
AATC | AATCBK | Filed in Bank File No. 01
[NAME] | AbbarBK | Filed in Bank File No. 01
OBD | OBDBK | Filed in Bank File No. 01
Spreadsheet: 759765d1639711108-multi-criteria-lookup-help-xlookup-miketomei-multiple-criteria-lookup
Sheet: Sheet1

 | Fred | Fred | Jessica | Jessica | [NAME] | [NAME] |  |  | Criteria 1 | [NAME] | Criteria 3 | [NAME] | Result
 | Project 1 | Project 1 | Project 1 | Project 1 | Project 2 | Project 2 |  |  | Fred | Project 1 | Hours | Task 1
 | Hours | Cost | Hours | Cost | Hours | Cost
Task 1 | 2.5 | 150 | 19 | 3500 | 18 | 6400
Task 2 | 6 | 400 | 2 | 230 | 5.5 | 675
Task 3 | 9 | 1200 | 32 | 9500 | 1 | 75
Spreadsheet: 647926d1572752640-sorting-using-formula-sort
Sheet: Sheet1

 |  | 10 B
Sl | Item | Name | Position
1 | MAPPILAPPATTU (GIRLS) | FATHIMA BINSHIYA KT | 1
2 | MAPPILAPPATTU (BOYS) | DAVOOD IBRAHIM. [NAME] | 1
3 | MONO ACT (GIRLS) | FATHIMA RASMIYA P | 2
4 | VANCHIPATTU | DEVIKA.P | 2
5 | NADANPATTU | DEVIKA.P | 1
6 | NADANPATTU | JISHNA BUDHINI A | 2
7 | KATHAPRASANGAM | DEVIKA.P | 1
8 | PADYAM CHOLLAL - URDU | FATHIMA RASMIYA P | 1
9 | CHITHRA RACHANA - PENCIL | ABHIJITH E | 1
10 | CHITHRA RACHANA - PENCIL | MISHAL ALI KP | 3
11 | CHITHRA RACHANA - WATER COLOUR | ABHIJITH E | 1
12 | CHITHRA RACHANA - WATER COLOUR | MISHAL ALI KP | 3
13 | CHITHRA RACHANA - OIL COLOUR | ABHIJITH E | 2
14 | CARTOON | [NAME] | 1
15 | CARTOON | MISHAL ALI KP | 2
16 | CARTOON | MOHAMED NIHAD M | 3
17 | KAVITHARACHANA - MALAYALAM | RAGITHA RAJAN K | 2
18 | UPANYASAM - MALAYALAM | AMRUTHA. N.K | 1
19 | UPANYASAM - MALAYALAM | MUFEEDA K | 2
20 | SANGHA NRUTHAM (GIRLS) | ARYARAJ.P K | 1
21 | NADAKAM | FATHIMA BINSHIYA KT | 3