tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682438d1592099065-automating-a-task-book1
Sheet: E

May | E
EU | Stock 1 |  |  |  | Stock 2
Week number / Week ending: | Open | Receipts | Pick | Close | Open | Receipts | Pick | Close | Totals | Returns
(18) .01/05/2020 | 0 |  |  |  | 0
(19). 08/05/2020
(20). 15/05/2020
(21). 22/05/2020
(22). 29/05/2020
 |  |  |  |  |  |  | Inbound | Outbound | Storage | Returns
 |  |  |  |  |  | Total:
 |  |  |  |  |  | Rate: | 14.65 | 94.56 | 864.25 | 9999
 |  |  |  |  |  | Invoice:
US | Stock 1 |  |  |  | Stock 2
Week number / Week ending: | Open | Receipts | Pick | Close | Open | Receipts | Pick | Close | Totals | Returns
(18) .01/05/2020 | 0 |  |  |  | 0
(19). 08/05/2020
(20). 15/05/2020
(21). 22/05/2020
(22). 29/05/2020
 |  |  |  |  |  |  | Inbound | Outbound | Storage | Returns
 |  |  |  |  |  | Total:
 |  |  |  |  |  | Rate: | 24.65 | 104.56 | 874.25 | 11111
 |  |  |  |  |  | Invoice:
Columns C, E, G, and I are where I manually input data
The equation in C24 is what I have in mind, it should be 7 due to the US/ USA issue, but can something like this be scaled up.
Spreadsheet: 6b424c61-471c-41ac-9b8a-1587343f5de8
Sheet: Table 6.3

Monthly Statistical Bulletin
6.3 Terms of trade
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Implicit price deflator for exports of goods and services (a) (b) – index
September | 79.8 | 96.4 | 104.6 | 90 | 93.4
December | 79 | 94.7 | 102.3 | 89.5
March | 82.5 | 99.8 | 95.4 | 90.7
June | 95.2 | 103.5 | 97.2 | 90.7
Annual average | 84.21133486958554 | 98.66203422564234 | 100 | 90.13961970820378
Implicit price deflator for imports of goods and services (a) (b) – index
September | 105.7 | 102 | 98.5 | 99.4 | 106.9
December | 100.9 | 98 | 101 | 100.2
March | 100.4 | 98.4 | 99 | 100.3
June | 101.9 | 98.3 | 101.4 | 100.4
Annual average | 102.0392117565896 | 99.07030247511425 | 100 | 99.9120861243121
Terms of trade (a) (b) (c) – index
September | 75.5 | 94.5 | 106.2 | 90.6 | 87.4
December | 78.3 | 96.6 | 101.3 | 89.3
March | 82.2 | 101.4 | 96.4 | 90.4
June | 93.5 | 105.4 | 95.8 | 90.4
Annual average | 82.52840591366807 | 99.58790047141073 | 100 | 90.21893467027677
(a) Quarterly figures are seasonally adjusted.
(b) Base: 2010-11 = 100.0.
(c) Index of the ratio of the implicit price deflator for exports of goods and services
to the implicit price deflator for imports of goods and services
Source: ABS, Balance of payments and international investment position, Cat. no. 5302.0
http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=5302.0&viewtitle=Balance%20of%20Payments%20and%20International%20Investment%20Position,%20Australia~Dec%202007~Latest~4/03/2008&&tabname=Past%20Future%20Issues&prodno=5302.0&issue=Dec%202007&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | Early March 2013
Spreadsheet: 864105d1711425560-concise-formulas-to-make-excel-file-smaller-sample-results
Sheet: Raw Responses

 |  |  | Basic Info |  |  |  | AS |  |  |  |  |  |  | Sales |  |  |  | Privacy Consent
ID | Submission Date | Month | [NAME] | Contact | Overall Satisfaction | Easy | Promptness | Expertise | Clear | Comments - AS | [NAME] | Suitable | Responsiveness | Expectations | Satisfaction | Comments - Sales | In contact with Sales in the past year? | Data Privacy | Marketing
26 | 2024-03-05 03:16:31 |  | [EMAIL] | 123456789 | 5 | 5 | 5 | 5 | 4 | Great service | 5 | 5 | 5 | 5 | 4 | Good product knowledge | Yes | Yes | Yes
27 | 2024-03-05 03:30:30 |  | [EMAIL] | 123456789 | 5 | 5 | 5 | 5 | 5 | Clear and concise communication | 4 | 5 | 3 | 4 | 5 | Could be more punctual | Yes | Yes | No
28 | 2024-03-05 03:34:40 |  | [EMAIL] | 123456789 | 5 | 5 | 5 | 4 | 5 | Excellent communication | 5 | 5 | 5 | 5 | 4 | Approachable and knowledgeable rep | Yes | Yes | Yes
29 | 2024-03-05 03:38:25 |  | [EMAIL] | 123456789 | 3 | 5 | 3 | 5 | 4 | Response time could be faster | 4 | 5 | 4 | 4 | 3 | More touchpoints and contact would be appreciated | Yes | Yes | No
30 | 2024-04-04 00:00:00 |  | [EMAIL] | 123456789 | 2 | 2 | 3 | 4 | 3 | Response time could be faster | 3 | 2 | 3 | 2 | 4 | Could be more punctual | Yes | Yes | Yes
31 | 2024-04-06 00:00:00 |  | [EMAIL] | 123456789 | 3 | 3 | 3 | 4 | 3 | Unclear communication | 3 | 2 | 4 | 3 | 5 | Approachable and knowledgeable rep | Yes | Yes | Yes
Spreadsheet: 132f810e-9e06-4aea-8d48-3ac4b24002fd
Sheet: 2003-04

Table D2
Intercalating Medical Students
Department | Full Time
Anatomy and Developmental Biology | 64
Anthropology | 13
Biochemistry and Molecular Biology | 17
Biology | 14
CHIME | 17
Human Communication Science | 10
Immunology and Molecular Pathology | 13
Medical Physics | 12
Medicine | 8
Orthopaedics | 10
Pharmacology | 19
Physiology | 57
Primary Care and Population Sciences | 20
Psychology | 25
Surgery | 7
Total
Spreadsheet: 47544d1246571742-counting-non-blank-cells-that-fall-between-cells-with-conditions-between
Sheet: Sheet1

3 |  | EXAMPLE 1
 | X | 1L 1H 22 R 2A 2A | 2009-06-25 00:00:00
 | X | 22b r | 2009-06-25 00:00:00
8 |  | EXAMPLE 44
 | x | Azerbaijan | 2009-06-25 00:00:00
 | x | Russia | 2009-06-25 00:00:00
 | x | USA | 2009-06-25 00:00:00 |  |  | ContaminatedWithExcel | DonkeyOte
 | x | Iran | 2009-06-25 00:00:00 |  | EXAMPLE 1 | 2 | 29
 | x | Georgia | 2009-06-25 00:00:00
 | x | Albania | 2009-06-25 00:00:00
21 |  | EXAMPLE 3
 | x | Venesuela | 2009-06-25 00:00:00
 | x | Aruba | 2009-06-26 00:00:00
 | x | Armenia | 2009-06-27 00:00:00
 | x | Croatia | 2009-06-28 00:00:00
 | x | Hungary | 2009-06-29 00:00:00
 | x | France | 2009-06-30 00:00:00
 | x | Wales | 2009-07-01 00:00:00
 | x | England | 2009-07-02 00:00:00
 | x | Scotland | 2009-07-03 00:00:00
35 |  | EXAMPLE 8
 | x | Bolivia | 2009-07-03 00:00:00
 | x | Mongolia | 2009-07-04 00:00:00
 | x | China | 2009-07-05 00:00:00
 | x | North Ireland | 2009-07-06 00:00:00
 | x | Irak | 2009-07-07 00:00:00
 | x | Syria | 2009-07-08 00:00:00
 | x | Poland | 2009-07-09 00:00:00
 | x | Spain | 2009-07-10 00:00:00
 | x | Portugal | 2009-07-11 00:00:00
46 |  | EXAMPLE 5
Spreadsheet: sara_shackleton__36402__Swap Deal Ticket_Nov12
Sheet: Sheet1

 |  |  |  | Executed Deal Ticket
Enron North America Corp.
 |  |  |  |  |  |  | Deal Number __________ |  | Deal Date_________
Customer Name |  | Contact |  | Financial/Physical |  | Commodity |  | Index | Delivery Point
EDEN S.A. |  | [NAME] |  | Financial |  | Power |  | (*) | Ezeiza
Enron Entity |  | Originator |  |  |  | Transaction Type: |  | Swap
Enron Capital & Trade Resources Corp. |  | [NAME] ([NAME])
 |  |  |  | Currency: | US$ | Broker: | Fee: | Unit of Measure:
 |  |  |  |  |  | - | - | MWh
Financial Reference Start Date | Financial Reference End Date | Quantity | Monthly/Daily |  | Fixed Price / Strike Price |  |  | Option Premium | Origination
February 1st, 2000 | January 31st, 2001 | 66 MW, [NAME] |  |  | $20.90/MWh
Spreadsheet: 835014d1688228291-splitting-name-street-address-state-zip-into-separate-cells-excel_forum_result_fileexample
Sheet: Sheet1

Document | Base Page | Full_Name | ADDRESS_LINE_1 | CITY | STATE | ZIP | Reason
CombinedBox2837_adobeadjustedCropped_OCR_1 | 2 | [NAME] | 8202 Winstead PI Apt 102 | Manassas | VA | 20109-7 | NIXIE
CombinedBox2837_adobeadjustedCropped_OCR_1 | 3
CombinedBox2837_adobeadjustedCropped_OCR_1 | 4 | [NAME] 101 Manassas, VA 20109-7 | 8086 [NAME] | Manassas | VA | 20109-7 | NIXIE
CombinedBox2837_adobeadjustedCropped_OCR_1 | 5
CombinedBox2837_adobeadjustedCropped_OCR_1 | 6 | [NAME] | 8086 [NAME] | Manassas | VA | 201 | NIXIE
CombinedBox2837_adobeadjustedCropped_OCR_1 | 7
CombinedBox2837_adobeadjustedCropped_OCR_1 | 8 | [NAME], VA 20109-7 | 8130 [NAME] | Manassas | VA | 20109-7 | NX XIE
CombinedBox2837_adobeadjustedCropped_OCR_1 | 9
CombinedBox2837_adobeadjustedCropped_OCR_1 | 10 | [NAME] | 8111 Cobden Ct Apt 102 | Manassas | VA | 201 | NIXIE
CombinedBox2837_adobeadjustedCropped_OCR_1 | 11
CombinedBox2837_adobeadjustedCropped_OCR_1 | 12 | [NAME] | 10210 Launch [NAME] 103 | Manassas | VA | 20109-
CombinedBox2837_adobeadjustedCropped_OCR_1 | 13
CombinedBox2837_adobeadjustedCropped_OCR_1 | 14 | [NAME] | 7247 Traphill Way | Gainesville | VA | 20155 | BCr
CombinedBox2837_adobeadjustedCropped_OCR_1 | 15
CombinedBox2837_adobeadjustedCropped_OCR_1 | 16 | [NAME] | 8090 [NAME] | Manassas | VA | 20109-7473 | [NAME] f
CombinedBox2837_adobeadjustedCropped_OCR_1 | 17
CombinedBox2837_adobeadjustedCropped_OCR_1 | 18 | [NAME] 7651 [NAME], VA 20109-7684 |  |  |  |  | NIXIE
CombinedBox2837_adobeadjustedCropped_OCR_1 | 19
CombinedBox2837_adobeadjustedCropped_OCR_1 | 20 | Densley [NAME] I 2995 Myrtlewood Dr |  |  |  |  | RETUR
CombinedBox2837_adobeadjustedCropped_OCR_1 | 21
CombinedBox2837_adobeadjustedCropped_OCR_1 | 22 | Donte Lavae Latimore 3060 Clancy Dr Dumfries, VA 22026 |  |  |  |  | RETURN
CombinedBox2837_adobeadjustedCropped_OCR_1 | 23
CombinedBox2837_adobeadjustedCropped_OCR_1 | 24 | [NAME] 3385 Vineland PI Dumfries, VA 22026 2189 |  |  |  |  | RETUR
Spreadsheet: 38784d1236929036-need-help-with-complex-conditional-counting-from-multiple-columns-please-help-quickly-example-1-
Sheet: Sheet2

0 | 200-300 | 300-400 | 400-500 | 500-600 | 600-700 | 700-800 | 800-900 | 900-1000
AL
FL
IN
MD
MI
NC
NJ
NY
OH
PA
TX
VA
WI
WY
Spreadsheet: 207027d1358350109-need-help-consolidate-data-from-multi-workbooks-with-multi-worksheets-file1
Sheet: Location1

User | Device | Department
[NAME] | [NAME] | Finance
May | Printer | Technology
[NAME] | Printer | Marketing
Kelly | Computer | Logistic
[NAME] | Computer | Sales
[NAME] | Computer | Finance
Spreadsheet: 130658d1322505354-combine-data-from-two-sheets-pt
Sheet: 2

Categories | part | call | price | eta date |  |  |  | Sum of price
ddu | 4x5d4 | 1233232459 | 1210 | 2012-11-01 00:00:00 |  |  |  | Categories | part | call | eta date | Total
aip | 4x5d6 | 123ewew461 | 3 | 2012-11-01 00:00:00 |  |  |  | adu | 4x5d5 | 123460 | 2012-11-01 00:00:00 | 300
dnu | 4x5d1 | 123456 | 232 | 2012-11-01 00:00:00 |  |  |  |  |  | 123we460 | 2012-11-01 00:00:00 | 300
dwu | 4x5d3 | 123wew458 | 7 | 2012-11-01 00:00:00 |  |  |  | adu Total |  |  |  | 600
ais | 4x5d7 | 123462 | 4375 | 2012-11-01 00:00:00 |  |  |  | aip | 4x5d6 | 123461 | 2012-11-01 00:00:00 | 3
adu | 4x5d5 | 123we460 | 300 | 2012-11-01 00:00:00 |  |  |  |  |  | 123ewew461 | 2012-11-01 00:00:00 | 3
zwp | 4x5d10 | 123465 | 35434 | 2012-11-01 00:00:00 |  |  |  | aip Total |  |  |  | 6
dsu | 4x5d2 | 3232 | 565 | 2012-11-01 00:00:00 |  |  |  | ais | 4x5d7 | 123462 | 2012-11-01 00:00:00 | 4450
ddu | 4x5d4 | 123459 | 0 | 2012-11-01 00:00:00 |  |  |  | ais Total |  |  |  | 4450
zsp | 4x5d9 | 123464 | 1 | 2012-11-01 00:00:00 |  |  |  | ddu | 4x5d4 | 123459 | 2012-11-01 00:00:00 | 0
aip | 4x5d6 | 123461 | 3 | 2012-11-01 00:00:00 |  |  |  |  |  | 1233232459 | 2012-11-01 00:00:00 | 1210
dnu | 4x5d1 | 123456 | 4 | 2012-11-01 00:00:00 |  |  |  | ddu Total |  |  |  | 1210
dwu | 4x5d3 | 123458 | 7 | 2012-11-01 00:00:00 |  |  |  | dnu | 4x5d1 | 123456 | 2012-11-01 00:00:00 | 236
ais | 4x5d7 | 123462 | 75 | 2012-11-01 00:00:00 |  |  |  | dnu Total |  |  |  | 236
adu | 4x5d5 | 123460 | 300 | 2012-11-01 00:00:00 |  |  |  | dsu | 4x5d2 | 3232 | 2012-11-01 00:00:00 | 565
zwp | 4x5d10 | 123465 | 334 | 2012-11-01 00:00:00 |  |  |  |  |  | 123457 | 2012-11-01 00:00:00 | 900
[NAME] | 4x5d8 | 123463 | 555 | 2012-11-01 00:00:00 |  |  |  | dsu Total |  |  |  | 1465
dsu | 4x5d2 | 123457 | 900 | 2012-11-01 00:00:00 |  |  |  | dwu | 4x5d3 | 123458 | 2012-11-01 00:00:00 | 7
 |  |  |  |  |  |  |  |  |  | 123wew458 | 2012-11-01 00:00:00 | 7
 |  |  |  |  |  |  |  | dwu Total |  |  |  | 14
 |  |  |  |  |  |  |  | [NAME] | 4x5d8 | 123463 | 2012-11-01 00:00:00 | 555
 |  |  |  |  |  |  |  | zdp Total |  |  |  | 555
 |  |  |  |  |  |  |  | zsp | 4x5d9 | 123464 | 2012-11-01 00:00:00 | 1
 |  |  |  |  |  |  |  | zsp Total |  |  |  | 1
 |  |  |  |  |  |  |  | zwp | 4x5d10 | 123465 | 2012-11-01 00:00:00 | 35768
 |  |  |  |  |  |  |  | zwp Total |  |  |  | 35768
Spreadsheet: f341fd3a-e3da-4710-b1f2-afa5dbe6066e
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
4874 | 7013 | Evgenia | Sukhoruchenkova | RUS | 141 | 00:35:23 | 00:00:35 | 01:15:57 | 00:00:36 | 00:16:31 | 1 | 02:09:04
4874 | 17002 | [NAME] | Lauf | HUN | 143 | [NAME] | 00:00:38 | 01:21:33 | [NAME] | [NAME] | 2 | 02:23:21
Spreadsheet: 87975d1287855721-formula-issue-multiple-rows-referencing-one-row-copying-book-row
Sheet: data

BidItem | Client # A | Client # B | Client # C | Bid Description | Units | Bid Quantity | Bid Total U.P. | Bid Total | #
1001000 | 0100 | 2002 | 002 | PREPARING ROW | STA | 162.3 | 2 | 324.6 | 1 | 2 | 0
1002000 | 0104 | 2001 |  | REMOVING CONC (PAV) | SY | 14888 | 9 | 133992 | 2 | 9 | 0
1003000 | 0104 | 2009 |  | REMOVING CONC (RIPRAP) | SY | 1501 | 3 | 4503 | 3 | 3 | 0
1004000 | 0104 | 2013 |  | REMOVING CONC (FOUNDATIONS) | SY | 3641 | 7 | 25487 | 4 | 7 | 0
Spreadsheet: 177071d1346179143-excel-2010-array-problem-excel-problem
Sheet: Sheet1

 | User Name | Department | Promoted | Department
 | 1234567 | ACE | 12345678 |  |  |  |  | A standard user list that I want to paste into the worksheet
 | 1234567 | ACME | 87654321 |  |  |  |  | User names that will come from another process to identify them
 | 12345678 | FXTX | 53214567 |  |  |  |  | When the user name (red) column I want this to populate with the department from the (blue) column
 | 87654321 | SUBS | 53214567
 | 11223344 | BGM | 53214567
 | 55667788 | PRES
 | 98765432 | PULP
 | 23456789 | POOP
 | 53214567 | SLME
 | 53214567 | FXTX
 | 53214567 | ACE
Spreadsheet: 852837d1702810904-data-relocation-from-worksheet-to-worksheet-example
Sheet: Household

 | Household
Date | Payee | Description | Amount
 | Bertolotti Disposal | Acct. # 11-35740 0    Garbage Service for Dec/Jan. | 58.62
44937 | JS West Propane Gas | Account 122, Grayson Propane Service  November Budget Amount | 1218
44939 | All Clean Pool Service | Dec. Monthly Service Charge | 150
44942 | Verizon | Cell Phone covering   11/26/22 - 12/25/22  Inv. [PHONE] | 185.3
44957 | AT&T (TV) | DirecTV, acct: 264804173 (1/19/23 - 2/18/23) | 88.67
44962 | Walmart | oil & filter for truck, misc groceries | 85.55
44970 | JS West Propane Gas | Account 101022, Grayson Propane Service  Feb. Budget Amount | 404
 |  | Total
Spreadsheet: 869178d1715821609-vllook-up-or-a-similar-function-to-look-up-a-date-range-vllook-up-or-a-similar-function-to-look-up-a-date-range
Sheet: Sheet2

 |  | Receipts
 |  | 4000 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00 | 2024-07-01 00:00:00 | 2024-07-29 00:00:00 | 2024-08-26 00:00:00 | 2024-09-23 00:00:00 | 2024-10-21 00:00:00 | 2024-11-18 00:00:00 | 2024-12-16 00:00:00
 |  | 43500 | 2024-05-27 00:00:00 | 2024-06-24 00:00:00 | 2024-07-22 00:00:00 | 2024-08-19 00:00:00 | 2024-09-16 00:00:00 | 2024-10-14 00:00:00 | 2024-11-11 00:00:00 | 2024-12-09 00:00:00 | 2025-01-06 00:00:00
 |  | 47000 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00 | 2024-07-01 00:00:00 | 2024-07-29 00:00:00 | 2024-08-26 00:00:00 | 2024-09-23 00:00:00 | 2024-10-21 00:00:00 | 2024-11-18 00:00:00 | 2024-12-16 00:00:00
 |  | 3500 | 2024-04-15 00:00:00 | 2024-05-13 00:00:00 | 2024-06-10 00:00:00 | 2024-07-08 00:00:00 | 2024-08-05 00:00:00 | 2024-09-02 00:00:00 | 2024-09-30 00:00:00 | 2024-10-28 00:00:00 | 2024-11-25 00:00:00
 |  | 4250 | 2024-05-06 00:00:00 | 2024-06-03 00:00:00 | 2024-07-01 00:00:00 | 2024-07-29 00:00:00 | 2024-08-26 00:00:00 | 2024-09-23 00:00:00 | 2024-10-21 00:00:00 | 2024-11-18 00:00:00 | 2024-12-16 00:00:00
 |  | 6750 | 2024-05-27 00:00:00 | 2024-06-24 00:00:00 | 2024-07-22 00:00:00 | 2024-08-19 00:00:00 | 2024-09-16 00:00:00 | 2024-10-14 00:00:00 | 2024-11-11 00:00:00 | 2024-12-09 00:00:00 | 2025-01-06 00:00:00
 | Week | 2024-05-13 00:00:00 | 2024-05-20 00:00:00 | 2024-05-27 00:00:00 | 2024-06-03 00:00:00 | 2024-06-10 00:00:00 | 2024-06-17 00:00:00 | 2024-06-24 00:00:00 | 2024-07-01 00:00:00 | 2024-07-08 00:00:00 | 2024-07-15 00:00:00 | 2024-07-22 00:00:00 | 2024-07-29 00:00:00 | 2024-08-05 00:00:00
 |  |  |  |  | 4000 |  |  |  | 4000 |  |  |  | 4000
 |  |  |  | 43500 |  |  |  | 43500 |  |  |  | 43500
 |  |  |  |  | 47000 |  |  |  | 47000 |  |  |  | 47000
 |  |  |  |  |  | 3500 |  |  |  | 3500 |  |  |  | 3500
 |  |  |  | 6750 | 4250 |  |  | 6750 | 4250 |  |  | 6750 | 4250
 | Week | 2024-05-13 00:00:00 | 2024-05-20 00:00:00 | 2024-05-27 00:00:00 | 2024-06-03 00:00:00 | 2024-06-10 00:00:00 | 2024-06-17 00:00:00 | 2024-06-24 00:00:00 | 2024-07-01 00:00:00 | 2024-07-08 00:00:00 | 2024-07-15 00:00:00 | 2024-07-22 00:00:00 | 2024-07-29 00:00:00 | 2024-08-05 00:00:00
 |  | 0 | 0 | 43500 | 0 | 0 | 0 | 43500 | 0 | 0 | 0 | 43500 | 0 | 0
 |  | 0 | 0 | 0 | 47000 | 0 | 0 | 0 | 47000 | 0 | 0 | 0 | 47000 | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 4250 | 0 | 0 | 0 | 4250 | 0 | 0 | 0 | 4250 | 0
 |  | 0 | 0 | 6750 | 0 | 0 | 0 | 6750 | 0 | 0 | 0 | 6750 | 0 | 0
Spreadsheet: 16fd1de0-24df-45b0-862e-ee9dbadbbef9
Sheet: Sheet1

Distribution of polymorphic alleles among A. fumigatus isolates | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Af293 gene | AFUA_2G00910 | AFUA_2G17420 | AFUA_6G07010 | AFUA_3G06170
Isolate | Pfs and [NAME] domain | Pfs and [NAME] domain | RosA | mating types | Isolation site
A1163 | 1 | 1 | 2 | alpha | Clinical, France
Af10 | 2 | 2 |  | HMG | Clinical, USA
Af210 | 2 | 2 |  | alpha | Clinical, UK
Af230 | 2 | 1 |  | alpha | Environmental, Sweden
Af245 | 1 | 2 |  |  | Clinical, UK
Af293 | 2 | 2 | 1 | HMG | Clinical, UK
Af294 | 2 | 2 |  | alpha | Clinical, France
Af65 | 2 | 1 |  |  | Clinical, USA
Af71 | 1 | 1 |  | HMG | Clinical, USA
Af72 | 1 | 1 |  | HMG | Clinical, USA
Af90 | 1 | 1 |  | alpha | Clinical, USA
ATCC13073 | 1 | 1 |  |  | Clinical, USA
WSA-1195 | 1 | 1 | 2 | HMG | Clinical, USA
[NAME] | 1 | 1 |  | HMG | Clinical, USA
WSA-270 | 1 | 1 | 2 | HMG | Clinical, India
WSA-271 | 2 | 1 | 3 |  | Environmental, USA
WSA-419 | 1 | 1 | 1 |  | Environmental, USA
WSA-446 | 1 | 1 | 1 |  | Clinical, USA
WSA-449 | 1 | 1 | 2 | HMG | Clinical, USA
[NAME] | 1 | 1 | 1 |  | Clinical, USA
WSA-622 | 1 | 2 | 1 |  | Environmental, USA
WSA-623 | 2 | 1 | 2 |  | Clinical, USA
Spreadsheet: 119416d1314376200-retrieving-data-based-on-two-criteria-and-two-worksheets-example-spreadsheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | USD | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST
 |  |  |  |  |  |  |  |  |  |  | 2010 JAN | 2010 FEB | 2010 MAR | 2010 Q1 | 2010 APR | 2010 MAY | 2010 JUN | 2010 Q2 | 2010 JUL | 2010 AUG | 2010 SEP | 2010 Q3 | 2010 OCT | 2010 NOV | 2010 DEC | 2010 Q4 | 2010 TOTAL | 2011 JAN | 2011 FEB | 2011 MAR | 2011 APR | 2011 MAY | 2011 JUN | 2011 JUL | 2011 AUG | 2011 SEP | 2011 OCT | 2011 NOV | 2011 DEC | 2011 TOTAL
 |  |  |  |  |  |  |  | A.610070 | N | A.610070-Vacation Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1225 |  |  | 1225 | 5168.97
 |  |  |  |  |  |  |  | A.610080 | N | A.610080-Vacation Expense Transfer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | A.610090 | N | A.610090-Travel Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7445__imball0202
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -194 | -143 |  |  | -1253 | -786
2 | -183 | -143 |  |  | -1189 | -786
3 | -164 | -143 |  |  | -1051 | -786
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
2002-01-31 00:00:00 |  |  |  |  |  |  |  |  | -37194
2002-02-03 00:00:00
CBS Volume
 |  |  | -4229
Spreadsheet: michelle_cash__26474__energy concept payment summary
Sheet: Sheet1

ENERGY CONCEPT PAYMENTS
Date of Payment |  |  | Amount
1995-03-01 00:00:00 |  |  | 100000
1996-03-01 00:00:00 |  |  | 237500
1996-03-01 00:00:00 |  |  | 100000
1996-03-01 00:00:00 |  |  | 15000
1996-03-01 00:00:00 |  |  | 25000
1996-03-01 00:00:00 |  |  | 25000
1996-05-01 00:00:00 |  |  | 25000
1996-05-01 00:00:00 |  |  | 25000
1996-11-01 00:00:00 |  |  | 25000
1996-11-01 00:00:00 |  |  | 12500
1996-11-01 00:00:00 |  |  | 12500
1997-01-01 00:00:00 |  |  | 12500
1997-01-01 00:00:00 |  |  | 12500
1997-01-01 00:00:00 |  |  | 25000
1997-03-01 00:00:00 |  |  | 18750
1997-03-01 00:00:00 |  |  | 18750
1997-03-01 00:00:00 |  |  | 162500
1998-07-01 00:00:00 |  |  | 1000000
1998-07-01 00:00:00 |  |  | 687500
1998-07-01 00:00:00 |  |  | 1212500
1998-07-01 00:00:00 |  |  | 202989
1999-05-01 00:00:00 |  |  | 1000000
1999-05-01 00:00:00 |  |  | 834653
1999-05-01 00:00:00 |  |  | 1733333
2000-04-01 00:00:00 |  |  | 1844290
2000-04-01 00:00:00 |  |  | 2100077
Spreadsheet: 838099d1690715243-user-choice-consolidation-with-hierarchy-applied-result-and-then-given-a-number-dif
Sheet: Sheet1

USERS | User Name
1 | Name
2 | Name
3 | Name
4 | Name
5 | Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RESULT
User choises |  | Difficulty |  |  |  |  | Importance |  |  |  |  | Frequency |  |  |  |  |  | Diff | Imp | [NAME] | Cat
 | Task 1 | Mod | Very | Very | Mod |  | Mod |  |  | Very | Not | Mod | Mod | Inf | Very | Very
 | Task 2 | Not |  |  |  |  |  |  |  |  |  | Mod | Inf | Very
 | Task 3 |  | Very | Mod | Mod |  |  |  |  |  |  | Mod | Inf
 | Task 4
Spreadsheet: 816547d1675693107-extract-highest-values-and-other-details-in-diffrent-tables-book2
Sheet: Sheet2

 | Emp Name | 2001 | 2002 |  |  | Top1 | Top2 | Top3 |  |  |  | Objective is find top 3 values in 3 tables
 | Chakrapani | 100 | 387 |  | Employee Name | xxxx | xxxx | xxx |  |  |  | Followed by year and employee name
 | Minakshi | 569 | 998 |  | Year | xxxx | xxxx | xxx
 | Poornima | 721 | 280 |  | Highest Revenue |  |  |  |  |  |  | Range Names
 |  |  |  |  |  |  |  |  |  |  |  | Table1 |  | B1:D4
 | Emp Name | 2001 | 2002 |  |  |  |  |  |  |  |  | Table2 |  | B6:D10
 | Asha | 40 | 827 |  |  |  |  |  |  |  |  | Table3 |  | B13:D19
 | Kamakshi | 497 | 800
 | Maryam | 198 | 997 |  |  | =index((EMP_1,EMP_2,EMP_3), match(G4, |  |  |  |  |  | YEARDATA |  | C2:D2
 | Shreya | 87 | 825 |  |  | =INDEX((EMP_1,EMP_2,EMP_3),MATCH(G4,(REV_1,REV_2,REV_3),0))
 |  |  |  |  |  | INDEX((EMP_1,EMP_2,EMP_3),MATCH(G4,(REV_1,REV_2,REV_3),0)) |  |  |  |  |  | EMP_1 |  | B2:B4
 |  |  |  |  |  |  |  |  |  |  |  | EMP_2 |  | B7:B10
 | Emp Name | 2001 | 2002 |  |  |  |  |  |  |  |  | EMP_3 |  | B14:B19
 | Ananda | 652 | 616
 | [NAME] | 267 | 507 |  |  | =sumproduct((rev_1=G4),(rev_2=G4),(rev_3=G4)
 | Ninad | 27 | 135 |  |  |  |  |  |  |  |  | REV_1 |  | C2:D4
 | Sandeep | 40 | 790 |  |  |  |  |  |  |  |  | REV_2 |  | C7:D10
 | [NAME] | 651 | 511 |  |  |  |  |  |  |  |  | REV_3 |  | C14:[NAME]
 | Aparna | 268 | 589
 |  |  |  |  |  |  |  |  |  |  |  | FULL_DATA |  | B1:[NAME]