tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116784d1312169796-match-index-data-replace-demo
Sheet: 4-2

 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Mr A | B | 指 | 指 | B | B | B | B | B | 指 | 指 | B | B | B | B | B | 指 | 指 | 指 | B | B | B | B | 出 | 出 | 指 | B | B | B | B | 指 | 指
 | Mr B | B | 指 | 指 | B | B | B | B | B | 指 | 指 | B | B | B | B | B | 指 | 指 | 指 | B | B | B | B | B | B | 指 | B | B | B | B | 指 | 指
 | Mr C | 指 | ｇ | D | E | 指 | ｇ | G | 指 | 指 | G | ｇ | D | E | 指 | ｇ | G | ｇ | D | E | 指 | ｇ | G | 指 | 指 | ｇ | G | D | E | 指 | G | D | 1
 | Mr D | ｇ | Q | G | D | E | 指 | 指 | ｇ | G | D | E | 指 | ｇ | G | 指 | 指 | G | Q | D | E | 指 | 指 | G | D | E | 指 | G | D | E | 指 | 指 | 0.9545454545454546
 | Mr E | Q | D | E | 指 | 指 | G | ｇ | D | E | 指 | 指 | Q | G | D | E | 指 | 指 | G | Q | D | E | 指 | ｇ | G | 指 | D | E | 指 | 指 | G | ｇ | 0.9545454545454546
 | Mr F | 指 | G | ｇ | G | Q | D | E | 指 | ｇ | Q | D | E | 指 | ｇ | G | Q | D | E | 指 | ｇ | G | 指 | D | E | 指 | ｇ | Q | 指 | 指 | ｇ | G | 1.045454545454545
 | Mr G | D | E | 指 | ｇ | G | 指 | Q | Q | D | E | 指 | G | Q | 指 | D | E | 指 | ｇ | G | 指 | 指 | ｇ | Q | Q | D | E | 指 | ｇ | G | D | E | 1.045454545454545
 | Mr H | G | 指 | Q | 指 | D | E | 指 | G | Q | 指 | Q | ｇ | D | E | 指 | ｇ | Q | 指 | ｇ | Q | D | E | 指 | 指 | G | Q | ｇ | Q | D | E | 指 | 1
 | Mr I | E | 指 | 指 | Q | ｇ | Q | D | E | 指 | ｇ | G | 指 | 指 | Q | Q | D | E | 指 | 指 | G | Q | Q | 指 | ｇ | Q | 指 | 指 | G | Q | Q | Q | 0.9545454545454546
 | Mr J | 指 |  |  |  | 指 |  |  | 指 |  |  |  | 指 |  |  | 指 |  |  |  |  |  |  | D | E | 指 |  |  |  |  |  |  |  | 0.09090909090909091
 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3 | 5 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5741935483870968
Spreadsheet: 275055d1383319671-daily-tracking-weekkeys
Sheet: Year

[NAME] out counts
# | Address | CITY | Unit | Tenant | Lease Start | Lease Ends | TAA | Owner | January | Febuary | March | April | May | June | July | August | [NAME] | October | November | December | Year
612 | [NAME] | K
614 | [NAME] | K
625 | Brook | K | B
625 | Brook | K | C
1220 | [NAME] | CC
805 | Sissom | K | 1
1609 | Poage | K | B
1611 | Poage | K
512 | Blake | K
103 | White Wing | CC | A
722 | Sutton | K | A
301 | North Dr | CC | B
917 | [NAME] | CC | B
917 | [NAME] | CC | C
917 | [NAME] | CC | D
211 | Erby | CC | D
1904 | [NAME] | K | D
1906 | [NAME] | K | C
1102 | Eastside Dr | K | A
1006 | Eastside Dr | K | B
1006 | Eastside Dr | K | D
133 | [NAME] | CC | B
5808 | Greengate | K | A
3403 | Toledo | K | B
3403 | Toledo | K | C
3008 | Chaucer | K | A
3008 | Chaucer | K | B
4505 | Westcliff | K | C
3802 | Charolais | K | C
3414 | [NAME] | K | C
1103 | Covey | K | A
3207 | Toledo | K | A
1007 | Circle M | K | B
1007 | Circle M | K | C
1218 | Royal Crest | K
3402 | [NAME] | K | D
3408 | [NAME] | K | C
4404 | [NAME] | K | B
4410 | [NAME] | K | B
3802 | [NAME] | K | A
3802 | [NAME] | K | B
3301 | Toledo | K | C
2404 | Skylark | K
1408 | Dugger Circle | K | B
3406 | Toledo | K | A
3407 | [NAME] | K | A
927 | [NAME] | K
2911 | Cantabrian | K | D
4408 | [NAME] Dr | K | A
3408 | [NAME] | K | A
3408 | [NAME] | K | D
4300 | [NAME] | K | D
2600 | Edfield | K | B
1312 | Saddle | K
BR = # [NAME]
BA = # Bathrooms
GAR = Garage, CP = Carport
UTIL = Utilities Paid (W = Water, N = None)
CH = Central Heat
Spreadsheet: 349108d1412203951-calculate-formula-only-on-third-instance-or-more-of-customer-set-result
Sheet: Sheet1

Customer | year
a | 1
a | 2
a | 3 |  | SHOW RESULT
b | 1
b | 2
c | 1
c | 2
c | 3
c | 4 |  | SHOW RESULT
d | 1
d | 2
d | 3 |  | SHOW RESULT
e | 1
e | 1
Spreadsheet: 817821d1676461921-need-to-count-how-many-times-a-group-of-numbers-occur-in-a-line-excel-problem-formula-required
Sheet: Sheet1

 | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI
 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | 1 | 1 | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | 1 | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | 1 | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | 2 | W | W |  |  | W | W | 2 | 2 | 2 |  |  | W | W | W | W | W |  |  | W | 1 | W | 2 | 2
 | W | W | W | W | W |  |  | W | 1 | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | 2 | W | W |  |  | W | 2 | 2 | W | W |  |  | W | 2 | W | W | W |  |  | W | 2 | 2 | 2 | W
 | 1 | 1 | 1 | 1 | 1 |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | 5 | 5 | 5 | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | 2 | 2 | 2 | W |  |  | 1 | W | W | W | W |  |  | W | W | W | W | W |  |  | W | W | W | W | W
 | W | W | W | 0.5 | W |  |  | W | W | W | 2 | 2 |  |  | 2 | 2 | 2 | 2 | 2 |  |  | W | W | W | W | W
 | W | W | W | W | W |  |  | W | W | W | 2 | W |  |  | 1 | 1 | W | W | W |  |  | W | W | W | W | W
Problem - Need to know how to write a formula to count how many times 2 occurs  in a group, example line 10  there are 3 groups of 2, line 13 there are 4 groups of 2 etc.
Spreadsheet: 698293d1601907139-conditional-formatting-for-overdue-date-on-specific-cells-project_plan-working-
Sheet: Project_Plan

 | Project Planner
 | Start Date | 2020-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Today |  |  |  | % Complete |  |  |  | % Complete (beyond plan) |  |  |  |  | Overdue
 |  |  |  |  |  |  |  |  |  |  |  |  | Plan Duration |  |  |  | Actual Duration |  |  |  | Actual Duration (beyond plan)
 | TASK NAME | START | FINISH | ACT. START | ACT. FINISH | Status | % COMPLETE | PLAN DURATION | ACTUAL DURATION
 | ABC Tasks | 2020-10-01 00:00:00 |  | 2020-10-03 00:00:00 |  | Complete | 1 | 5 | 6
 | IP Connectivity | 2020-10-03 00:00:00 |  | 2020-10-03 00:00:00 |  | Overdue | 0.5 | 1 | 2
 | Gateway | 2020-10-06 00:00:00 |  | 2020-10-06 00:00:00 |  | In Progress | 0.35 | 1 | 1
 | Electrum | 2020-10-07 00:00:00 |  | 2020-10-07 00:00:00 |  | In Progress | 0.5 | 2 | 2
 | Gateway | 2020-10-08 00:00:00 |  | 2020-10-08 00:00:00 |  | In Progress | 0.9 | 15 | 13
 | Commercials | 2020-10-09 00:00:00 |  | 2020-10-09 00:00:00 |  | In Progress | 0.8 | 7 | 7
 | Test connectivity | 2020-10-10 00:00:00 |  | 2020-10-10 00:00:00 |  | In Progress | 0.5 | 1 | 1
 | Integration | 2020-10-11 00:00:00 |  | 2020-10-11 00:00:00 |  | In Progress | 0.6 | 7 | 7
 | Subscriber Create Trigger | 2020-10-12 00:00:00 |  | 2020-10-12 00:00:00 |  | In Progress | 0.75 | 1 | 1
 | AAT SMS | 2020-10-13 00:00:00 |  | 2020-10-13 00:00:00 |  | In Progress | 0.6 | 5 | 8
 | Request Quote | 2020-10-14 00:00:00 |  | 2020-10-14 00:00:00 |  | In Progress | 0.9 | 1 | 2
 | SMS-Out | 2020-10-15 00:00:00 |  | 2020-10-15 00:00:00 |  | Open | 0 | 1 | 1
 | USSD | 2020-10-16 00:00:00 |  | 2020-10-16 00:00:00 |  | In Progress | 0.5 | 11 | 11
 | Build MVNO | 2020-10-17 00:00:00 |  | 2020-10-17 00:00:00 |  | Open | 0 | 12 | 12
 | Create/Rename VN | 2020-10-18 00:00:00 |  | 2020-10-18 00:00:00 |  | In Progress | 0.5 | 5 | 5
 |  |  |  |  |  | FORMULA FOR STATUS
 |  |  |  |  |  | IF(COUNTBLANK(D9),"",IF((H9=100),"Complete",IF((D9<TODAY()),"Overdue",IF(H9>0.1,"In Progress",IF(H9=0,"Open")))))
Spreadsheet: 839331d1691842096-duplicate-finder-through-formula-dup-entry-checker
Sheet: Sheet1

1-Jul-23 to 12-Aug-23
Date | Particulars |  | Vch Type | Vch No. | Debit | Credit
2023-07-01 00:00:00 | Dr | Opening Balance |  |  | 1556500
2023-07-05 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1641 |  | 750000
 |  | 3311 crdb dep indian sweets ref fh06931688540700 on 05/07/23
2023-07-05 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1643 |  | 900000
 |  | 3311 crdb dep indian sweets ref fh834471688026878 on 29/06/23 |  |  |  |  | READ
2023-07-06 00:00:00 | Cr | SALES | Sales | 27955 | 1035000
2023-07-13 00:00:00 | Cr | SALES | Sales | 28905 | 954000
2023-07-13 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1700 |  | 1000000
 |  | 3311 crdb dep indian sweets ref fh618851689142231 on 12/07/23
2023-07-18 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1753 |  | 600000
 |  | 3311 crdb dep pradip tank ref fh320191689575093 on 17/0723
2023-07-19 00:00:00 | Cr | SALES | Sales | 29958 | 1210000
2023-07-19 00:00:00 | Cr | SALES | Sales | 29960 | 42000
2023-07-24 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1797 |  | 700000
 |  | 3311 crdb dep indian sweets ref ab16901826174262698228 on 24/07/23
2023-08-01 00:00:00 | Cr | SALES | Sales | 31548 | 1030000
2023-08-07 00:00:00 | Cr | SALES | Sales | 32510 | 1862000
2023-08-07 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1946 |  | 900000
 |  | 3311 crdb dep indian sweets ref fh834471688026878 on 29/06/23 |  |  |  |  | READ
2023-08-07 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1947 |  | 1000000
 |  | 3311 crdb dep indian sweets ref fh662661691389256 on 07/08/23
2023-08-09 00:00:00 | Dr | BANK TO HO BANK ACCOUNT | Journal | 1975 |  | 1500000
 |  | 3311 crdb dep deo ref ab16915630886492237918 on 09/08/23
2023-08-12 00:00:00 | Cr | BANK TO HO BANK ACCOUNT | Journal | 2004 | 900000
 |  | reversal of duplicate slip worth 900,000 recorded in august
8589500 |  |  |  |  |  | 7350000
 | Dr | Closing Balance |  |  |  | 1239500
8589500 |  |  |  |  |  | 8589500
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -26876 | -73521
9238 | -15884 | -18500 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1687406 | -1905117
58710 | -109839 | -83624
60921 | -859175 | -818175
78026 | 55779 | 44878
500084 | -38035 | -56807
500085 | -272916 | -95000
500097 | -14758
INDEX
2001-01-31 00:00:00 |  |  | 1219422.02
2001-02-19 00:00:00
Spreadsheet: 788485d1658496155-extracting-top-values-with-indexing-function-ranking
Sheet: Sheet1

Name | Value
Name1 | 1 |  | Rank | Value | Name
[NAME] | 2 |  | 1
Name3 | 3 |  | 2
Name4 | 4 |  | 3
Name5 | 5 |  | 4
Name6 | 6 |  | 5
Name7 | 7
Name8 | 8
Name9 | 9
Name10 | 10
Name11 | 11
Name12 | 12
Name13 | 13
Name14 | 14
Name15 | 16
[NAME] | 16
Name17 | 17
Spreadsheet: 749241d1632635631-need-formula-to-transpose-non-zero-data-test
Sheet: Sheet1

Data Array: |  |  |  |  |  |  |  | Desired Look:
Counter | Alpha | Beta | Gamma | Delta | Epsilon | Zeta |  |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | Name 1 | 1 | Name 2 | 2 | Name 3 | 3 | Name 4 | 4 | Name 5 | 5
1 | 0 | 0 | 10 | 10 | 0 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gamma | 10 | Alpha | 20 |  |  | Beta | 50 | Alpha | 20
2 | 20 | 0 | 0 | 0 | 0 | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delta | 10 | Zeta | 20 |  |  | Gamma | 10 | Delta | 60
3 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zeta | 50 |  |  |  |  | Epsilon | 10
4 | 0 | 50 | 10 | 0 | 10 | 0
5 | 20 | 0 | 0 | 60 | 0 | 0
Spreadsheet: 123346d1317591514-excel-2007-calculating-bonus-formula-orders
Sheet: October

September Phone
 |  |  |  |  |  |  |  |  | Amt$ till 30K | Amt$ till 50K
Date | Order # | Amount | Item # | Qty | Type | Payment | $20 Bonus
2011-09-28 00:00:00 | 3873 |  | D250RTC | 1 | Phone | Recv'd | 20
 |  |  |  |  |  |  |  |  | Bonus | Bonus |  | $20 Bonus
Total
September Online
Date | Order # | Amount | Item # | Qty | Type | Payment | $20 Bonus
2011-10-02 00:00:00 | 3961 | 2327 | [NAME] | 1 | Online | Recv'd | 20
Total
Spreadsheet: 762260d1641476204-modify-existing-if-and-iferror-formula-permit-register-example-6-1-22
Sheet: Quotes

ABC Job Number | Address | Description | Client
 | Address 27 | Description 27 | Client 27
ABC-21028 | Address 28 | Description 28 | Client 28
ABC-21029 | Address 29 | Description 29 | Client 29
ABC-21030 | Address 30 | Description 30 | Client 30
Spreadsheet: 330068d1404503613-problem-with-indirect-when-i-try-to-link-data-to-multiple-worksheets-indirect-statements-nc
Sheet: Driver from factory (2)

 |  |  |  |  |  | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
Visitor Roaming
 |  |  |  |  |  | 111 | 122 | 133 | 144 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
 |  |  |  |  |  | 112 | 123 | 134 | 145 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
 |  |  |  |  |  | 113 | 124 | 135 | 146 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
 |  |  |  |  |  | 114 | 125 | 136 | 147 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
Indirect method | _http://office.microsoft.com/en-us/excel-help/indirect-HP005209139.aspx
If statements | I
Choose statements
_http://office.microsoft.com/en-us/excel-help/indirect-HP005209139.aspx
Spreadsheet: c2d7d932-2dc7-4c4e-ae84-0a65c5ff363c
Sheet: Area 1

Location | Title | Name | Mobile | Address | CRCs | CRC Mobile
Area 1 | Area Manager | Don Parsons | 07736 722 495 | c/o RFU
 |  |  |  | Rugby House
 |  |  |  | 200 Whitton Road
 |  |  |  | [NAME]
 |  |  |  | TW2 7BA
Cornwall | RDO | [NAME] | 07764 960 380 | PO Box 297 | [NAME] | 07809 512 135
 |  |  |  | Penzance | [NAME] | 07711 385923
 |  |  |  | TR18 9EA
 |  |  |  | Couriers to:
 |  |  |  | Kenidjack Farm
 |  |  |  | St. Just
 |  |  |  | Penwith
 |  |  |  | Cornwall TR19 7QW
Somerset | RDO | [NAME] | 07889 601 018 | Coombe Dingle Sports Complex | [NAME] | 07885 974425
 |  |  |  | [NAME] | [NAME] | 07711 385928
 |  |  |  | [NAME]
 |  |  |  | Bristol, BS9 2BJ
Devon & Somerset | RDO | [NAME] | 07590 890 824 | 27 Exe View | [NAME] | 07711 385925
 |  |  |  | Exminster | [NAME] | 07711 385922
 |  |  |  | [NAME] | [NAME] | 07711 385927
 |  |  |  | EX6 8AL
[NAME] | RDO | [NAME] | 07764 960 390 | Kingsbridge Community College | [NAME] | 07734 967746
 |  |  |  | Balkwill Road | [NAME] | 07711 385926
 |  |  |  | Kingsbridge
 |  |  |  | [NAME] TQ7 1PL
Dorset | RDO | [NAME] | 07739 583 536 | Marise | [NAME] | 07711 385912
 |  |  |  | [NAME] | [NAME] | 07764 336705
 |  |  |  | Dorchester
 |  |  |  | Dorset
 |  |  |  | DT2 9LZ
Wiltshire | RDO | [NAME] | 07568 127 789 | 1 Lancaster Square | [NAME] | 07734 967745
 |  |  |  | [NAME] | [NAME] | 07711 385908
 |  |  |  | Chippenham
 |  |  |  | Wiltshire
 |  |  |  | SN15 4AD
Bristol & District | RDO | [NAME] | 07809 199 944 | University Playing Fields | [NAME] | 07970 235204
 |  |  |  | [NAME] | [NAME] | 07718 706589
 |  |  |  | [NAME] | [NAME] | 07711 385924
 |  |  |  | [NAME]
 |  |  |  | [NAME] 2BJ
Cheltenham & Stroud | RDO | [NAME] | 07715 856 666 | c/o RFU | [NAME] | 07711 385920
 |  |  |  | Rugby House | [NAME] | 07711 385921
 |  |  |  | 200 Whitton Road
 |  |  |  | Twickenham TW2 7BA
Gloucester & Forest of Dean | RDO | [NAME] | 07545 920 992 | Forest E-ACT Academy | [NAME] | 07715 856 673
 |  |  |  | [NAME] | [NAME] | 07718 706 591
 |  |  |  | Cinderford
 |  |  |  | Gloucestershire
 |  |  |  | GL14 2AZ
Area 1 | URDO | [NAME] | 07912 541 858 | c/o RFU
 |  |  |  | Rugby House
 |  |  |  | 200 Whitton Road
 |  |  |  | Twickenham TW2 7BA
Area 1 | WRDO | [NAME] | 07850 982 229 | c/o RFU
 |  |  |  | Rugby House
 |  |  |  | 200 Whitton Road
 |  |  |  | Twickenham TW2 7BA
Spreadsheet: vkaminski__40641__Dec2299
Sheet: Sheet2

Pricing Model for Bermudan Deal
 | Valuation Date
 |  |  | Strike | Maturity | Exercise Restriction | Exercise Frequency (times per year) | Years to Maturity | Years to first Exercise
 | Enron long 5-year put, [NAME] exercise |  | 56.125 | 2004-06-29 00:00:00 | 2000-06-30 00:00:00 | 2
 | LJM long 2.5 year put | Low Strike |  | 2002-01-14 00:00:00
 | Enron long 2.5 year put | High Strike | 65
 | LJM long call | Low Strike | 65
 | Enron long call | High Strike | 81
 |  | Quantity | RTHM Price | RTHM Volatility | Dividend | Interest rate | Steps | Do Risk (Yes=1)
 |  | 5393258 | 27 | 0.7 | 0 |  | 301 | 0
 | Option value per share
 | Option value
Spreadsheet: 64584d1265391159-adding-a-new-row-every-other-row-thank-you-pmts
Sheet: Sheet1

 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
Teacher | Student | Theme 1 | Theme 2 | Theme 3 | Theme 4 | Theme 5 | Theme 6
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
gg | gg | gg | gg | gg | gg | gg | gg
 | Benchmark | 53 | 65 | 78 | 85 | 90 | 94
Spreadsheet: 677193d1589232757-searching-for-a-value-and-returning-multiple-results-test-followup-report
Sheet: Followup List

Pt Identifier | Appointment
Bob128 | 2020-01-05 00:00:00
Suzie557 | 2020-01-02 00:00:00
[NAME] | 2020-01-14 00:00:00
Suzie557 | 2020-04-04 00:00:00
Mary357 | 2020-03-25 00:00:00
[NAME] | 2020-02-28 00:00:00
Thien41578 | 2020-03-09 00:00:00
Mary357 | 2020-03-21 00:00:00
Bob128 | 2020-03-25 00:00:00
Thien41578 | 2020-03-20 00:00:00
Suzie557 | 2020-03-27 00:00:00
Spreadsheet: 135150d1325846692-filtering-the-contents-of-a-dropdwon-list-filteredvalidation
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W1
 | Results table |  |  |  |  |  |  |  | Archive table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Item | Code |  |  |  |  |  |  | Item | Code
 | Toaster | T1 |  |  |  |  |  |  | Toaster | T1
 | [NAME] | W1 |  |  |  |  |  |  | House | H1
 | Eggs | EGG002 |  |  |  |  |  |  | [NAME] | W1
 |  |  |  |  |  |  |  |  | Eggs | EGG001
 |  |  |  |  |  |  |  |  | Milk | M1
 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Toaster | T2
 |  |  |  |  |  |  |  |  | Eggs | EGG002
 |  |  |  |  |  |  |  |  | Milk | M2
Spreadsheet: 85959d1285944603-excel-2007-how-to-apply-if-circumstances-dummy-workbook-1
Sheet: Choice B

72.75
 | Weight |  |  |  |  |  |  |  |  |  |  | [NAME]
 | holes |  | 0 |  |  |  |  |  |  |  |  | 1.45
 | cuts* |  | 0
 | laser* |  | 0
 | grooves* |  | 0
 | twists* |  | 0
 | Customized Orders
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 1 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 8
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 2 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 12
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 3 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 12
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 4 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 12
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 5 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 15
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 6 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 8
 | "Larger" sizes
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 1 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 2 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 3 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 35
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | total | [NAME] | TOTAL
 |  | Option 4 |  | Cost | LABOR |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: Replace Costs-Results 16-20

Table 5.2.6.  Replacement Costs (Years 16 to 20)
 |  |  |  | EPA Discount Rate:
 |  |  |  | Present Value of Replacement Costs in Year:
Component | Unit Cost | Unit | Quantity | 16 | 17 | 18 | 19 | 20
 |  |  | Total Present Value of Replacement Costs (Years 16 to 20):
 |  |  |  |  |  |  | Total Present Value of Replacement Costs (Life of Project):
Spreadsheet: 762493d1641577292-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Denver_P8

Denver DC
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
[NAME] | [NAME] | 3347312 | CSS |  | Y | 2
COS
Ft. Collins | [NAME] |  | RSS |  | Yes | 2 | 3
 | Tanette  Bultman-Faul |  | CSS |  | Yes | 2 | Couldn’t find receipt for
 | [NAME] |  | CSS |  | Yes | 2
 | Heather Sutherland |  | RSS |  | Yes | 2 | 3
 | [NAME] |  | RSR |  | Yes | 3
 | [NAME] |  | CSS |  | Yes | 2
Albuquerque Zone
Pagosa Springs | [NAME] | 80064815 | RSA | XL | Yes | T, W
Albuquerque | [NAME] | 80067359 | Merch | L | Yes | In ABQ
Alamogordo | [NAME] | Unknown | RSA | L | Yes | In ABQ
Gallup | [NAME] | Unknown | RSA | L | Yes | In ABQ
Spreadsheet: 727933d1618221702-index-match-formula-for-current-liabilities-and-current-assets-current-liabilities-and-current-assets
Sheet: Trial Balance

Category | Debit | Credit
Propert. Plant and Equipment | 476104.88
Intangible Assets | 0
Inventory | 347
Trade and Other Receivables | 3230
Cash & Cash Equivalent | -165135.46
Share Capital |  | 300916.42
[NAME] |  | 18930
Revaluation Reserve |  | 0
Long Term Loan |  | 0
Trade and Other Payables |  | -5300
Taxation |  | 0
Spreadsheet: 676799d1588971698-extract-info-from-workbook-and-make-a-list-search-for-extra
Sheet: Report

 | Report
 | Search value: | Extra | Total
 | Item | % | Total | Sum
 | Coffee Day 2 | 1 | 648 |  |  | I'd like to find all the items with the word in C5 in the comment section in all tabs.
 | Snacks | 0.5 | 912 |  |  | The % needs to be extracted from the comment cell and multiplied with the total from that item.
 | Tent Day 3 | 1 | 100
 | Type P | 0.5 | 967 |  |  | If [NAME] would be changed into Sponsor, the items with Sponsor would appear in with list instead.
 | Day 3 | 0.1 | 5100
 | [NAME] | 0.1 | 154
Spreadsheet: 165721d1341325909-can-a-repeated-date-trigger-a-formula-to-run-sample-airframe-doc
Sheet: Log

 | G-BSGL |  |  |  |  |  | AIRCRAFT (frame) LOG |  |  |  |  | Total
Brought forward
402 days, 21:20:00 | No. | Flight Time |  | Total Since Manufacture |  | Engine Cycles
Date | of Flights | Hours | Minutes | Hours | Minutes |  | Particulars of Maintenanceor work carried out.
 | 2