tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4980390b-52d6-4132-92c5-641303194150
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | VIRAL HEPATITIS PROGRAM
 |  | Contact: | [NAME] [PHONE]
 |  |  | FAX:  [PHONE]
 |  | Hepatitis B Vaccine Order Form |  |  | February 2010
 |  | This is not a VFC order form
Name of Person Requesting the [NAME]
Agency Affiliation
Phone Number
Fax Number
Please complete the number of doses you are requesting for each of the listed vaccines. While you will be provided with vaccines free-of-charge, the actual cost of vaccine is provided for your information.
Type | Brand | Number of Doses Requested | Federal Cost | Private Sector Costs | ORDERS SHOULD BE LIMITED TO A 30-60 DAY SUPPLY.
Hepatitis A- Adult | [NAME] |  | 20.59/dose | 63.10/dose
Hepatitis B – Adult | [NAME] |  | 26.70/dose | 52.50/dose | ORDERS WILL BE PLACED THE 1ST WEEK OF EACH MONTH.
Twinrix | [NAME] |  | 41.50/dose | 89.85/dose
Please provide the following information for shipping
Name of Agency
Name of Program/Contact Person
Address
City |  |  | State |  | ZIP
At this time, the Colorado Department of Public Health and Environment is only able to distribute vaccine to providers that serve the highest risk patients.  The criteria for high risk are described below.
Risk Criteria |  |  | Hepatitis A Vaccine |  | Hepatitis B Vaccine
contact to a hepatitis A case |  |  | X
injecting drug users |  |  | X |  | X
men who have sex with men |  |  | X |  | X
persons with more than one sex partner in the previous 6 months |  |  | X |  | X
persons with recently acquired sexually-transmitted disease |  |  | X |  | X
all clients in an STD clinic |  |  | X |  | X
sex partners of a person with hepatitis B infection |  |  |  |  | X
household contacts of persons with hepatitis B infection |  |  |  |  | X
history of incarceration |  |  |  |  | X
HIV+ Individuals |  |  | X |  | X
Clients of institutions for the developmentally disabled |  |  |  |  | X
Individuals born in an endemic part of the world |  |  |  |  | X
American Indian and Alaskan Natives |  |  | X |  | X
[NAME] can only be administered under the supervision of a licensed physician.  Below, please provide the name and signature of the supervising physician. By signing this form, the physician agrees that the vaccine will be administered only to clients that meet the CDPHE criteria for "high risk" and that the vaccine will be administered in accordance with federal guidelines for federally purchased vaccine. In addition, the agency must complete a "Vaccine Accountability Form".
Physician Name: |  |  |  | license #
Physician Signature:
Spreadsheet: 717093d1612470928-return-latest-value-balance-between-two-dates-forum-excel-4-f-v-2021
Sheet: Épargne Inv.

 | Date | Description | Compte | Solde relevé |  | Compte | Profit /perte (12 mois A.F.) | Solde fermeture
 | 2020-01-01 00:00:00 | Solde départ | Chèque | 1000 |  | Chèque
 | 2020-01-31 00:00:00 | Solde de fermeture | Chèque | 1200 |  | A
 | 2020-02-29 00:00:00 | Solde de fermeture | Chèque | 1100 |  | B
 | 2020-03-31 00:00:00 | Solde de fermeture | Chèque | 900 |  | C
 | 2020-04-30 00:00:00 | Solde de fermeture | Chèque | 1250 |  | D
 | 2020-05-31 00:00:00 | Solde de fermeture | Chèque | 1400
 | 2020-06-30 00:00:00 | Solde de fermeture | Chèque | 1100
 | 2020-07-31 00:00:00 | Solde de fermeture | Chèque | 1300
 | 2020-08-31 00:00:00 | Solde de fermeture | Chèque | 1150
 | 2020-09-30 00:00:00 | Solde de fermeture | Chèque | 1000
 | 2020-10-31 00:00:00 | Solde de fermeture | Chèque | 800
 | 2020-11-30 00:00:00 | Solde de fermeture | Chèque | 600
 | 2020-12-31 00:00:00 | Solde de fermeture | Chèque | 500
 | Date | Description | Compte | Solde [NAME] | Montant | Profit / perte | Solde  fermeture
 | 2020-01-01 00:00:00 |  | A | 1000 | 200
 | 2020-01-01 00:00:00 |  | B | 1500 | 500
 | 2020-01-14 00:00:00 |  | C |  | 300
 | 2020-02-13 00:00:00 |  | A |  | 350
 | 2020-02-27 00:00:00 |  | B |  | 1014
 | 2020-02-27 00:00:00 |  | C |  | 100
 | 2020-03-03 00:00:00 |  | A |  | 1026
 | 2020-03-03 00:00:00 |  | D |  | 550
 | 2020-06-30 00:00:00 |  | C | 500
 | 2020-12-31 00:00:00 |  | D | 600
Spreadsheet: 73656d1274284777-match-value-that-is-closest-in-value-and-also-fulfills-other-criteria-problem1
Sheet: Sheet 2

 | Items to be matched | items to match with |  | Items to be matched | items to match with | Desired outcome
 | Size in Mil$ | Size in Mil$ | Us Based | Industry code | Industry code | Match
item 1 |  | 77.027 | 0 |  |  | # N/A
item 2 | 98.741 |  | 0 |  |  | # N/A
item 3 |  | 99.05 | 0 |  |  | # N/A
item 4 |  | 833.354 | 0 |  |  | # N/A
item 5 |  | 103 | 1 |  |  | # N/A
item 6 |  | 72 | 1 |  |  | # N/A
item 7 |  | 2473.63 | 0 |  |  | # N/A
I want to match [NAME] to the item that is closest in value
Spreadsheet: 783402d1654783700-demand-plan-basis-on-90-warehouse-utilization-book1-azii-
Sheet: Sheet1

Opening (Jun-1st) | Demand Plan | DN Forecast | Closing Stock | Days
1219.15 | 2300 | 1395.5 | 2123.65 | 24.98411764705882
1952.6 | 2399.3 | 1446.6 | 2905.3 | 45.87315789473683
2575.65 | 2799.3 | 2216.5 | 3158.450000000001 | 32.11983050847459
782.4499999999999 | 1199.3 | 1238.65 | 743.0999999999999 | 26.22705882352941
1096.8 | 2099.3 | 358.2 | 2837.900000000001 | 30.9589090909091
2003.75 | 0 | 793.3 | 1210.45 | 0
2389.75 | 8799.3 | 3273.5 | 7915.549999999999 | 50.52478723404255
10248.7 | 7732.633333333333 | 11070.95 | 6910.383333333333 | 40.6493137254902
 | Utilization % | Opening | Demand Plan | DN Forecast | Closing Stock | Days
 | 0.9143102324686979 | 0 | 2300 | 600 | 1700 | 50.99999999999999
 | 1.121758946107785 | 658.3499999999999 | 2399.3 | 958.3499999999999 | 2099.3 | 69.97666666666667
 | 0.8417798756695987 | 114 | 2799.3 | 814 | 2099.3 | 69.97666666666667
 | 0.8285220639092542 | 560.65 | 1199.3 | 1060.65 | 699.2999999999997 | 69.92999999999998
 | 0.726142031746032 | 0 | 2099.3 | 0 | 2099.3 | 69.97666666666667
 | 0.5443005967319169 | 6.75 | 0 | 0 | 6.75 | 0
 | 1.710254476731718 | 30 | 8799.3 | 1830 | 6999.299999999999 | 69.993
 | 0.801076877037893 | 0 | 7732.633333333333 | 1200 | 6532.633333333333 | 69.9925
Spreadsheet: 712743d1610389189-array-formula-to-return-column-name-if-row-contains-yes-help
Sheet: List of Items

 | Toys
ID Number | Car | Truck | Doll | Playhouse | Books | Lego | Jenga | Ludo |  | Count | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8
ID1001 | Yes |  |  | Yes | Yes | Yes |  | Yes
ID1001 | Yes |  |  | Yes | Yes | Yes |  | Yes
ID1002 |  | Yes | Yes |  |  |  | Yes
ID1002 |  | Yes | Yes |  |  |  | Yes
Spreadsheet: 230792d1366879387-drop-down-list-using-multiple-worksheets-0sor
Sheet: KPI's

Stats | Inbound Calls | Viewings Booked | Clearances Booked | Clearances Completed
September 2013 | 6 | 5 | 6 | 5
Year to Date | 48 | 47 | 6 | 5
Breakdown | Calls to Viewings | Viewings to Booked Clearances | Booked to Completed Clearances | Call to Completed Clearance Percentage
September 2013 | 0.8333333333333334 | 1.2 | 0.8333333333333334 | 0.8333333333333334
Year to Date | 0.9791666666666666 | 0.1276595744680851 | 0.8333333333333334 | 0.1041666666666667
Spreadsheet: 524803d1498326525-need-execel-to-do-math-and-spit-out-data-second-attempt
Sheet: Working

1st | ZIP | CRRT | Rate Category | Total Walk Seq. | Total Residential | Total Possible | %
 | 92543 | C006 | WS | 366 | 366 |  | 1
 | 92543 | C012 | WS | 1262 | 1262 |  | 1
 | 92543 | C015 | WS | 909 | 909 |  | 1
 | 92543 | C084 | WS | 413 | 413 |  | 1
 | 92545 | C079 | WS | 940 | 940 |  | 1
 | 92582 | C017 | WS | 1157 | 1157 |  | 1
 | 92543 | C012 | WS | 1262 | 1262 |  | 1
 | 92543 | C015 | WS | 909 | 909 |  | 1
 | 92543 | C084 | WS | 413 | 413 |  | 1
 | 92543 | C084 | WS | 413 | 413 |  | 1
 | 92545 | C079 | WS | 940 | 940 |  | 1
 | 92582 | C017 | WS | 1157 | 1157 |  | 1
 | 92543 | C012 | WS | 1262 | 1262 |  | 1
 | 92543 | C015 | WS | 909 | 909 |  | 1
Spreadsheet: 876812d1723538476-multiple-criteria-mutiple-criterias
Sheet: Sheet1

 |  |  |  | Value
Items | [NAME] |  | Probability (%) | 0 to 1.49 | 1.50 to 1.99 | 2.00 to 2.49 | 2.50 to 2.99
A | 10 | 12.5 | 70.00-100.00 | 1 | 0 | 0 | 0
B | 12.51 | 15 | 65.00-69.99 | 1 | 1 | 0 | 0
C | 15.01 | 17 | 60.00-64.99 | 1 | 1 | 0.5 | 0
D | 17.01 | 20 | 55.00-59.99 | 1 | 1 | 0.5 | 0.5
E | 20.01 | 25 | 50.00-54.99 | 1 | 1 | 0.5 | 0.5
Expected result/answer:
Size | 20.01
Probability (%) | 0.5
Value | 2.99
Answer
Size | 19
Probability (%) | 0.56
Value | 1.3
Answer
Size | 16
Probability (%) | 0.59
Value | 1.6
Answer | 0 | Zero because the range below 60%
Spreadsheet: 71388d1272046496-vlookup-to-create-a-calendar-test1
Sheet: 2010

Transmit date | Person
2010-05-03 00:00:00 | Peter - 3020
2010-05-03 00:00:00 | [NAME]
2010-05-03 00:00:00 | Scott - 9123
2010-05-04 00:00:00 | [NAME]
2010-05-04 00:00:00 | Paul - 9033/2039
2010-05-04 00:00:00 | Johnson - 2822
2010-05-04 00:00:00 | Laura - 3922
2010-05-07 00:00:00 | Isabelle - 1213
2010-05-10 00:00:00 | [NAME]
2010-05-10 00:00:00 | Lois - 2833
Spreadsheet: 600094d1543461222-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T2 Producing

First name | Surname | ID number | Institution | Department | Email address | Assignment: Professionalism | Assignment: Budget/Cash Flow (In Class) | Attendance: Attendance | Assignment: Term 2 Festival Assets | Assignment: Clearance Game | Assignment: Film Critic Assignment | Assignment: T2 Production Binder | Assignment: Documentary Assignment | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 100 | 62.5 | 100 | 100 | 100 | 100 | 95.2 | 82 | 84.43
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 80 | - | 71.43 | - | 100 | 100 | 90.4 | - | 38.7
Muxin | [NAME] |  |  |  | [EMAIL] | 100 | 100 | 85.71 | 100 | 100 | 100 | 95.2 | 87 | 95.25
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 100 | 100 | 100 | 100 | 100 | 100 | 95.2 | 92 | 97.68
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 95 | 62.5 | 78.57 | - | 100 | 100 | 71.4 | 89 | 74.62
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 100 | 62.5 | 85.71 | 100 | 100 | 100 | 90.4 | 91 | 84.08
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 100 | 87.5 | 100 | 100 | 100 | 100 | 90.4 | 92 | 93.21
Yichao | Fu |  |  |  | [EMAIL] | 100 | 100 | 92.86 | 50 | 100 | 100 | 95.2 | 82 | 92.47
Junjie (Riol) | He |  |  |  | [EMAIL] | 100 | 62.5 | 100 | 100 | 100 | 100 | 95.2 | 87 | 85.43
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 100 | 75 | 85.71 | 100 | 100 | 100 | 90.4 | 87 | 87.03
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 100 | 87.5 | 92.86 | 100 | 100 | 100 | 95.2 | 91 | 93.02
[NAME]) | [NAME] |  |  |  | [NAME] | 100 | 75 | 64.29 | 100 | 100 | 100 | - | 87 | 71.33
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 100 | 93.7 | 92.86 | 100 | 100 | 100 | 76.1 | 91 | 92.01
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 95 | 62.5 | 85.71 | - | 100 | 100 | 52.3 | - | 54.67
[NAME]) | [NAME] |  |  |  | [EMAIL] | 95 | 62.5 | 71.43 | - | 100 | 100 | 66.6 | 82 | 71.78
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 95 | 62.5 | 78.57 | - | 100 | 100 | 71.4 | 91 | 75.02
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 100 | 87.5 | 100 | 100 | 100 | 100 | 66.6 | 87 | 88.64
[NAME]） | Xiao |  |  |  | [EMAIL] | 100 | 62.5 | 78.57 | 100 | 100 | 100 | 85.7 | 87 | 81.86
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 95 | 62.5 | 92.86 | 100 | 100 | 100 | 61.9 | 87 | 79.22
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 100 | 87.5 | 85.71 | 75 | 100 | 50 | 95.2 | 87 | 87.75
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 100 | 100 | 100 | 100 | 100 | 100 | 90.4 | 92 | 96.96
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 100 | 75 | 100 | 100 | 100 | 100 | 92.8 | 82 | 87.82
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 100 | 62.5 | 100 | 100 | 100 | 100 | 90.4 | 92 | 85.71
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 100 | 75 | 85.71 | 100 | 100 | 100 | 95.2 | 92 | 88.75
Spreadsheet: 818809d1677066556-hour-computation-hour-computation
Sheet: Sheet1

 | Start | 22:00:00 | 21:00:00 | 23:00:00 | 18:00:00 | 21:00:00 |  | 20:00:00
 | End | 06:00:00 | 07:00:00 | 05:00:00 | 04:00:00 |  | 06:00:00 | 02:00:00
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 115729d1311256219-displaying-a-column-of-data-based-on-drop-down-entry-transferringcolumnsofdata
Sheet: Sheet2

ColA
 | 1
 | 2 |  | 1
 | 3 |  | 2
 | 4 |  | 3
 | 5 |  | 4
 | 6 |  | 5
 | 7 |  | 6
 | 8 |  | 7
 | 9 |  | 8
 | 10 |  | 9
 | 11 |  | 10
 | 12 |  | 11
 | 13 |  | 12
 | 14 |  | 13
 | 15 |  | 14
 | 16 |  | 15
 | 17 |  | 16
 | 18 |  | 17
 | 19 |  | 18
 | 20 |  | 19
 |  |  | 20
Spreadsheet: 842502d1694567511-if-and-return-value-based-on-2-sets-of-conditions-sample-2-1
Sheet: SPS Template

Account Manager | Rep | Agreement Date | Company | Maricopa | YCO | Yuma | MCO | SAN DIEGO | ORANGE | NEW/RENEW | Total
 |  |  |  |  |  |  | I need a formula to pull all the $ from the first tab (2023 Spons Sales) into the blue table above
 |  |  |  | 1000 | Yuma
 |  |  |  | 1500 | Maricopa
 |  |  |  | 3500 | Maricopa
 |  |  |  | 3000 | SAN DIEGO
 |  |  |  | 4500 | Maricopa
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 2200 | SAN DIEGO
 |  |  |  | 5012 | SAN DIEGO
 |  |  |  | 3000 | Maricopa
 |  |  |  | 1500 | SAN DIEGO
 |  |  |  | 3000 | Maricopa
 |  |  |  | 6000 | Maricopa
 |  |  |  | 7000 | Maricopa
 |  |  |  | 3000 | Maricopa
 |  |  |  | 4000 | Maricopa
 |  |  |  | 2120 | SAN DIEGO
 |  |  |  | 3000 | SAN DIEGO
 |  |  |  | 1500 | SAN DIEGO
 |  |  |  | 3600 | Maricopa
 |  |  |  | 4000 | ORANGE
 |  |  |  | 1500 | ORANGE
 |  |  |  | 1500 | SAN DIEGO
 |  |  |  | 4500 | Maricopa
 |  |  |  | 600 | SAN DIEGO
 |  |  |  | 0
 |  |  |  | 1500 | Maricopa
 |  |  |  | 1000 | ORANGE
 |  |  |  | 2000 | SAN DIEGO
Spreadsheet: 831652d1685800883-getting-minimum-value-from-b-column-each-at-column-c-minimum-value-2-
Sheet: Sheet1

 | Data |  | Data | Output
 | B-14 |  | B-14 | 14
 | Bh-66/67/90 |  | Bh-66/67/90 | 66
 | S-33 /34 |  | S-33 /34 | 33
 | A-91 /92/109 |  | A-91 /92/109 | 91
 | A-105 /106/107 |  | A-105 /106/107 | 105
 | [NAME] /123/186 |  | [NAME] /123/186 | 122
 | M-192 /189 |  | M-192 /189 | 189
 | M-44 |  | M-44 | 44
 | P-63 /64 |  | P-63 /64 | 63
 | Ma-143 /144/152/153 |  | Ma-143 /144/152/153 | 143
 | F-143 /137/140 |  | F-143 /137/140 | 137
 | Ch-160 /145 |  | Ch-160 /145 | 145
 | M-97 |  | M-97 | 97
Spreadsheet: 828622d1683643695-while-using-xlookup-the-first-2-lines-work-than-it-stops-testboox
Sheet: samengevoegd

Eind-Datum en tijd | electricityIn | electricityInLow | electricityOut | electricityOutLow | solarIn | solarOut
2022-01-01 01:00:00
2022-01-01 02:00:00
2022-01-01 03:00:00
2022-01-01 04:00:00
2022-01-01 05:00:00
2022-01-01 06:00:00
2022-01-01 07:00:00
2022-01-01 08:00:00
2022-01-01 09:00:00
2022-01-01 10:00:00
2022-01-01 11:00:00
2022-01-01 12:00:00
2022-01-01 13:00:00
2022-01-01 14:00:00
2022-01-01 15:00:00
2022-01-01 16:00:00
2022-01-01 17:00:00
2022-01-01 18:00:00
2022-01-01 19:00:00
2022-01-01 20:00:00
2022-01-01 21:00:00
2022-01-01 22:00:00
2022-01-01 23:00:00
2022-01-02 00:00:00
2022-01-02 01:00:00
2022-01-02 02:00:00
2022-01-02 03:00:00
2022-01-02 04:00:00
2022-01-02 05:00:00
2022-01-02 06:00:00
2022-01-02 07:00:00
Spreadsheet: 859284d1707730031-conference-room-calendar-untitled-spreadsheettest-version-3-aligw
Sheet: Calendar

 | 2024-02-01 00:00:00
 | Sunday |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  |  |  | dt | s
 |  |  |  |  |  | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 3 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 2024-02-08 14:00:00 | R1 | 45329 | 0.3541666666666667 | 0.375 | CVSP | MEETING WITH THE POD
 |  |  |  |  |  |  |  |  |  |  |  | 2024-02-07 09:00:00 | R1 | 45329 | 0.375 | 0.416666666666667 | RSPM | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 2024-02-07 08:30:00 | R1 | 45329 | 0.5625 | 0.604166666666667 | RSPM | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | 2024-02-08 10:00:00 | R1 | 45329 | 0.583333333333333 | 0.625 | CVSP | MEETING WITH THE POD
 |  |  |  |  |  |  |  |  |  |  |  | 2024-02-07 13:30:00 | R1 | 45330 | 0.416666666666667 | 0.458333333333333 | RYR | MEETING WITH THE POD
 | 4 |  | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 10 |  |  |  | 00:00:00 | R1 | 45330 | 0.583333333333333 | 0.625 | CVSP | MEETING WITH THE POD
 |  |  |  |  | • R1 01:30PM to 02:30PM - RSPM MANCOM MEETING | • R1 02:00PM to 03:00PM - CVSP MEETING WITH THE POD |  |  |  |  |  | ff
 |  |  |  |  | • R1 10:00AM to 11:00AM - RYR MEETING WITH THE POD |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | R1 | 45329 | 0.375 | 0.416666666666667 | RSPM | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | R1 | 45329 | 0.5625 | 0.604166666666667 | RSPM | [NAME]
 | 11 |  | 2024-02-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 17 |  |  |  | R1 | 45330 | 0.416666666666667 | 0.458333333333333 | RYR | MEETING WITH THE POD
 |  |  |  |  |  |  |  |  |  |  |  | f
 |  |  |  |  |  |  |  |  |  |  |  |  | 45329 | 0.375 | 0.416666666666667 | RSPM | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | R1 | 45329 | 0.5625 | 0.604166666666667 | RSPM | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | R1 | 45330 | 0.416666666666667 | 0.458333333333333 | RYR | MEETING WITH THE POD
 | 18 |  | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 24
 | 25 |  | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00
 | As of
Spreadsheet: 75808d1276378000-using-now-if-function-together-book1
Sheet: Sheet1

Time | Date | CONCATENATE Function to merge A+B | Now Function
15:30:00 | 2010-06-12 00:00:00 | 0.645833333333333 40341 | X
12:00:00 | 2010-06-28 00:00:00 | 0.5 40357 | X
18:00:00 | 2010-07-03 00:00:00 | 0.75 40362 | X
22:30:00 | 2010-07-12 00:00:00 | 0.9375 40371 | X
Spreadsheet: 803757d1667666266-need-an-alternative-to-vlookup-that-returns-all-values-found-spa-lista-de-estabelecimentos-dsavrlvt-29_07_2022
Sheet: Secção III

 |  |  | [NAME]. 1069/2009 [NAME] / Combustão
NCV (Approval Number) | Nome (Name) | Concelho (Municipality) | Categoria (Category) | Atividade (Activity) | Espécies / Produtos (Species / Products) | [NAME] (Associated Activities)
 | CIMPOR - INDÚSTRIA DE CIMENTOS, S.A. - Centro de Produção de Alhandra | Vila [NAME] | 1 / 2 / 3 | Unidade de Co-incineração(CoIP) | MBM
 | SECIL - Companhia Geral de Cal e Cimento, S.A. | Setúbal | 1 / 2 / 3 | Unidade de Co-incineração(CoIP) | MBM
 | VALORSUL - Valorização Tratamento Resíduos Sólidos das [NAME] e Oeste | Loures | 1 / 2 / 3 | Unidade de Incineração(INCP) | RAW
 | ITS - Industria [NAME], S.A. | Coruche | 1 | Unidade de Combustão(COMB) |  | I(STORP), IV(PROCP), II(STORP*)
 | Ambimed - Gestão Ambiental, Lda | Chamusca | 1 / 2 / 3 | Unidade de Incineração(INCP) | RAW, RAW, RAW
 | CFS - Complexo Funebre de Setúbal, Lda | Setúbal | 1 | Unidade de Incineração(INCP) | Pet | XIII(TRANS)
 | [NAME] | Chamusca | 1 / 2 / 3 | Unidade de Incineração(INCP) | RAW
 | [NAME], Lda. | Sintra | 1 | Unidade de Incineração(INCP) | RAW | I(STORP), [NAME]) | Não existe na coluna D da folha "SPA"
 | [NAME] | Cascais | 1 | Unidade de Incineração(INCP) | CAD | I(STORP), [NAME]) | Não existe na coluna D da folha "SPA"
 |  |  | Atividades:
 |  |  | Unidade de Incineração
 |  |  | Unidade de Co-incineração (CoIP)
 |  |  | Unidade de Combustão (COMB)
Spreadsheet: 846221d1697499690-combine-3-data-sets-with-different-number-of-items-test
Sheet: Ark1

Set 1 |  |  | Set 2 |  |  | Set 3 |  |  | Combined
Item | Value |  | Item | Value |  | Item | Value |  | Item | Set 1 | Set 2 | Set 3
A | 2 |  | B | 43 |  | B | 66 |  | A | 2 | 1 | 8
B | 4 |  | A | 1 |  | A | 8 |  | B | 4 | 43 | 66
C | 23 |  | D | 23 |  | C | 77 |  | C | 23 | 0 | 77
D | 13 |  | E | 4 |  | D | 11 |  | D | 13 | 23 | 11
E | 4 |  | F | 23 |  | P | 5 |  | E | 4 | 4 | 0
 |  |  | G | 3 |  |  |  |  | F | 0 | 23 | 0
 |  |  |  |  |  |  |  |  | G | 0 | 3 | 0
 |  |  |  |  |  |  |  |  | P | 0 | 0 | 5
 |  |  |  |  |  |  |  |  |  | 2 | 1 | 8
 |  |  |  |  |  |  |  |  | B | 4 | 43 | 66
 |  |  |  |  |  |  |  |  | C | 23 | 0 | 77
 |  |  |  |  |  |  |  |  | D | 13 | 23 | 11
 |  |  |  |  |  |  |  |  | E | 4 | 4 | 0
 |  |  |  |  |  |  |  |  | F | 0 | 23 | 0
 |  |  |  |  |  |  |  |  | G | 0 | 3 | 0
 |  |  |  |  |  |  |  |  | P | 0 | 0 | 5
Spreadsheet: dutch_quigley__9180__enron delta breakdown  11-30
Sheet: Sheet1

ENRON position breakdown (11-30-01)
Month | Futures | Options Delta | Overall Delta
F02 | -1821 |  | 577
G02 | 46 |  | -833
H02 | -1134 |  | 0
[NAME] | 2598 |  | -314
K02 | -555 |  | 446
M02 | -2537 |  | -2456
N02 | -11 |  | -4
Q02 | -585 |  | -611
U02 | -1440 |  | -1235
[NAME] | 103 |  | -521
H03 | 443 |  | -30
K03 | -212 |  | -212
M03 | 460 |  | 440
U03 | -54 |  | -48
V03 | 1860 |  | 1860
Z03 | 1523 |  | 1437
G04 | 1409 |  | 1409
H04 | 125 |  | -2
 |  | Overall:
Spreadsheet: 849507d1699961357-confuse-with-formula-test
Sheet: pull data

 |  |  | 9841153389
 |  |  |  |  |  | Enter The Number
S.No | Submission ID | Respondent ID | Submitted at | Agent Name | [NAME] / சைக்கிள் பாய்பெயர் | Mobile / ஏஜென்ட் மொபைல் எண் | Shop Name / கடையின் பெயர் | Shop Address / கடையின் முகவரி | சாலை/தெரு | பகுதி/ஏரியா | அஞ்சல் குறியீடு (Pincode) | கடையின் மொபைல் எண் | Shop Category / கடையின் வகை | வகையை உள்ளீடுக | Shop Photo / கடையின் புகைப்படம்
Spreadsheet: 58405d1258647469-if-and-vlookup-matchdropdown
Sheet: Sheet2

FRUITS | APPLE | FRUITS_1 | FRUITS
FRUITS | MANGO | FRUITS_2 | VEGETABLES
FRUITS | BANANA | FRUITS_3 | ITEMS
VEGETABLES | CARROT | VEGETABLES_1
VEGETABLES | RADISH | VEGETABLES_2
VEGETABLES | PUMPKIN | VEGETABLES_3
ITEMS | BOOKS | ITEMS_1
ITEMS | TABLES | ITEMS_2
ITEMS | CHAIRS | ITEMS_3
FRUITS | pears | FRUITS_4
FRUITS | lemons | FRUITS_5
FRUITS | peach | FRUITS_6
VEGETABLES | marrow | VEGETABLES_4
items | CAR | items_4