tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885293d1734771247-convert-a-mmult-to-byrow-lambda-playedbefore-countpairs-lambda-function-step-by-step-
Sheet: Helper Functions

EQUALSλ: |  | BEGINSλ: |  | BETWEENλ:
=LAMBDA(field,criteria,[case_sensitive], |  | =LAMBDA(field,criteria,[case_sensitive], |  | =LAMBDA(field,[value1],[value2],[inclusive],
IF( |  | IF( |  | LET(
AND(ISBLANK(criteria)), |  | AND(ISBLANK(criteria)), |  | incId, IF(ISOMITTED(inclusive),3,inclusive),
IF({1},1,field), |  | IF({1},1,field), |  | CHOOSE(
LET( |  | LET( |  | 1+ISBLANK(value1)+2*ISBLANK(value2),
crit, SORT(TOROW(criteria,1),,,1), |  | crit, TOROW(criteria,1), |  | CHOOSE(
CHOOSE( |  | array, LEFT(field,[NAME])), |  | 1+incId,
1+(COLUMNS(crit)=1)+2*AND(case_sensitive), |  | CHOOSE( |  | (field>value1)*(field<value2),
ISNUMBER(XMATCH(field,crit,,2)), |  | 1+(COLUMNS(crit)=1)+2*AND(case_sensitive), |  | (field>=value1)*(field<value2),
field=crit, |  | BYROW(array=crit,OR), |  | (field>value1)*(field<=value2),
BYROW(EXACT(field,crit),OR), |  | array=crit, |  | (field>=value1)*(field<=value2)
EXACT(field,crit) |  | [NAME],crit),OR), |  | ),
) |  | EXACT(array,crit) |  | IF(incId>1, field<=value2, field<[NAME]),
) |  | ) |  | IF(MOD(incId,2), field>=value1, field>value1),
) |  | ) |  | IF({1},1,field)
) |  | ) |  | )
 |  | ) |  | )
 |  |  |  | )
CONTAINSλ: |  | ENDSλ: |  | [inclusive]:
 |  |  |  | 0 - greater than value1 and less than value2
=LAMBDA(field,criteria,[case_sensitive], |  | =LAMBDA(field,criteria,[case_sensitive], |  | 1 - greater than or equal to value1 and less than value2
IF( |  | IF( |  | 2 - greater than value1 and less than or equal to value2
AND(ISBLANK(criteria)), |  | AND(ISBLANK(criteria)), |  | 3 - greater than or equal to value1 and less than or equal to [NAME] (default)
IF({1},1,field), |  | IF({1},1,field),
LET( |  | LET(
crit, TOROW(criteria,1), |  | crit, TOROW(criteria,1),
CHOOSE( |  | array, RIGHT(field,LEN(crit)),
1+(COLUMNS(crit)=1)+2*AND(case_sensitive), |  | CHOOSE(
BYROW(ISNUMBER(SEARCH(crit,field)),OR), |  | 1+(COLUMNS(crit)=1)+2*AND(case_sensitive),
ISNUMBER(SEARCH(crit,field)), |  | BYROW(array=crit,OR),
BYROW(ISNUMBER(FIND(crit,field)),OR), |  | array=crit,
ISNUMBER(FIND(crit,field)) |  | [NAME],crit),OR),
) |  | EXACT(array,crit)
) |  | )
) |  | )
) |  | )
 |  | )
[case_sensitive]:
FALSE or 0 - not case-sensitive (default)
TRUE or 1 - case-sensitive
Spreadsheet: chris_stokley__3993__Closing 061901 mkt cert Nov
Sheet: Nov Debtor

 | Certification for Market Settlement June 19, 2001
 | For the Trade Month of November 2000
ISO Creditors to whom amounts are Owed
# | Customer Name | Trade Month |  |  | Amount Owed | % of total owed to Creditors
 | Total Due to 59 SCs (Creditors) |  |  |  | 498463066.47
Amounts owed by [NAME] that remain unpaid:
# | Customer Name | Date | Inv # | Type | Unpaid Balance | % of total due from Debtors
2769 | California Power Exchange | 2001-02-14 00:00:00 | 14006 | Mkt | 93414.8
1243 | California Power Exchange | 2001-01-26 00:00:00 | 13881 | Mkt | 507530033.34
 | Total Due From SCs (Debtors)
 | Summary of activity for Trade Month of November 2000:
 | Due from SCs
 | Preliminary Invoices |  |  |  | 669272884
 | Final Invoices
 | Total Invoiced
 | Collected 2/1/01 |  |  |  | 2983589.97
 | Collected 2/9/01 |  |  |  | 144397659.3
 | Collected 2/22/01 |  |  |  | 62787.65
 | Collected 3/5/01 |  |  |  | 352934.19
 | Total Collected
 | Applied against Nov-00 Market AP 2/22/01 |  |  |  | 16925215.71
 | Cancelled invoice 2/22/01
 | Total Adjustments
 | Balance Due from SCs
 | Due to SCs
 | Preliminary Invoices |  |  |  | 669155560.78
 | Final Invoices |  |  |  | 17546615.96
 | Total Invoiced
 | Paid 2/1/01 |  |  |  | 12113244.29
 | Paid 2/9/01 |  |  |  | 149333046.54
 | Paid 2/22/01 |  |  |  | 62787.65
 | Paid 3/7/01 |  |  |  | 352693.64
 | [NAME] |  |  |  | 5209.76
 | Total Paid
 | Applied against Oct-00 Market AR 2/1/01 |  |  |  | 957235.81
 | Applied against Nov-00 GMC 2/1/01 |  |  |  | 443900.1
 | Applied against Nov-00 Market AR 2/22/01 |  |  |  | 16925215.71
 | Applied against Dec-00 GMC 3/7/01 |  |  |  | 240.55
 | Applied against Dec-00 Market AR 4/27/01 |  |  |  | 2463.45
 | Applied against Jan-01 GMC 4/27/01 |  |  |  | 4918.46
 | Applied against Jan-01 Market AP 5/17/01 |  |  |  | 7683.69
 | Applied against Mar-01 Market AR 5/31/01 |  |  |  | 1321875.76
 | FERC ordered reduction 5/31/01 |  |  |  | 6708594.86
 | Total Adjustments
 | Balance Due to SCs
Spreadsheet: 878673d1725912328-formulas-not-working-in-table-spill-error-book1
Sheet: Projects

Award Number | [NAME] | Project Number | Project Name | Project Start Date | Project End Date |  |  | Award 10 | Award 11 | Award 12 | Award 13 | Award 14 | [NAME] | Award 3 | [NAME] | Award 5 | Award 6 | Award 7 | Award 8 | Award 9
1 | Award 1 | [NAME] |  | 2022-01-01 00:00:00 | 2024-12-31 00:00:00
1 | Award 1 | G2 |  | 2022-01-01 00:00:00 | 2024-12-31 00:00:00 |  | Project G2 | Project G22 | Project G25 |  |  |  | Project G4 | Project G6 | Project G10 | Project G12 | Project G14 | Project [NAME] |  | Project G19
2 | [NAME] | G3 |  | 2023-05-01 00:00:00 | 2026-04-30 00:00:00 |  |  | Project G23 | Project G26 |  |  |  |  | Project G7 |  |  |  |  |  | Project G20
2 | [NAME] | G4 |  | 2023-05-01 00:00:00 | 2026-04-30 00:00:00 |  |  |  | Project G27 |  |  |  |  | Project G8
3 | Award 3 | G5 |  | 2023-04-15 00:00:00 | 2026-03-31 00:00:00
3 | Award 3 | G6 |  | 2023-04-15 00:00:00 | 2026-03-31 00:00:00
3 | Award 3 | G7 |  | 2024-08-01 00:00:00 | 2025-07-31 00:00:00
3 | Award 3 | G8 |  | 2024-08-01 00:00:00 | 2025-07-31 00:00:00
4 | [NAME] | G9 |  | 2023-05-10 00:00:00 | 2023-08-14 00:00:00
4 | [NAME] | G10 |  | 2023-05-10 00:00:00 | 2023-08-14 00:00:00
5 | Award 5 | G11 |  | 2023-08-01 00:00:00 | 2028-07-31 00:00:00
5 | Award 5 | G12 |  | 2023-08-01 00:00:00 | 2028-07-31 00:00:00
6 | Award 6 | G13 |  | 2023-10-01 00:00:00 | 2025-06-30 00:00:00
6 | Award 6 | G14 |  | 2023-10-01 00:00:00 | 2025-06-30 00:00:00
7 | Award 7 | [NAME] |  | 2024-05-01 00:00:00 | 2025-04-30 00:00:00
7 | Award 7 | [NAME] |  | 2024-05-01 00:00:00 | 2025-04-30 00:00:00
8 | Award 8 | G17 |  | 2024-04-01 00:00:00 | 2027-03-31 00:00:00
9 | Award 9 | G18 |  | 2017-10-01 00:00:00 | 2023-09-30 00:00:00
9 | Award 9 | G19 |  | 2017-10-01 00:00:00 | 2023-09-30 00:00:00
9 | Award 9 | G20 |  | 2017-10-01 00:00:00 | 2023-09-30 00:00:00
10 | Award 10 | G21 |  | 2018-05-01 00:00:00 | 2023-04-30 00:00:00
10 | Award 10 | G22 |  | 2018-05-01 00:00:00 | 2023-04-30 00:00:00
10 | Award 10 | G23 |  | 2018-05-01 00:00:00 | 2023-04-30 00:00:00
11 | Award 11 | [NAME] |  | 2019-06-01 00:00:00 | 2026-05-31 00:00:00
11 | Award 11 | G25 |  | 2019-06-01 00:00:00 | 2026-05-31 00:00:00
11 | Award 11 | G26 |  | 2019-06-01 00:00:00 | 2026-05-31 00:00:00
11 | Award 11 | G27 |  | 2019-06-01 00:00:00 | 2023-05-31 00:00:00
12 | Award 12 | G28 |  | 2014-09-01 00:00:00 | 2018-07-02 00:00:00
13 | Award 13 | G29 |  | 2016-10-11 00:00:00 | 2049-12-31 00:00:00
14 | Award 14 | G30 |  | 2023-07-01 00:00:00 | 2024-10-01 00:00:00
Spreadsheet: 216246d1361657695-lookup-function-with-with-three-conditions-two-are-fixed-and-the-third-is-variable-and-c-three-condition-lookup-02232013
Sheet: Sheet1

Lookup function with with three conditions.  Two are fixed and the third is variable and conditioned.
Step One:  TWO Cell Exact Match.  [NAME] formula in yellow highlighted cells in Table 1 column A and B items for an exact match to items within Table 2 column I and J.
Step Two: Conditional Lookup.  Then enter soonest the time from column K exceeding or equalling column C time but by not more than one minute.
Use the N:7 Cell as I may need to change the time number from time to time.
Enter Zero (0) if there is no match meeting these conditions.
Any way to do this without decending sort, or with standard non array formula?
Table 1 |  |  |  |  |  |  | Table 2 |  |  |  |  | Time Condition
Asset | Location | Time | Manual Result | Excel [NAME] and Result |  |  | Asset | Location | Time |  |  | 00:01:00
J | AA | 2013-02-15 14:29:00 | 00:00:00 |  |  |  | D | AA | 2013-02-15 15:49:02
I | CC | 2013-02-15 14:22:00 | 00:00:00 |  |  |  | B | BB | 2013-02-15 10:32:53
H | BB | 2013-02-15 08:45:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 09:02:45
F | CC | 2013-02-15 10:34:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 09:02:28
E | BB | 2013-02-15 10:28:00 | 00:00:00 |  |  |  | H | BB | 2013-02-15 08:41:42
D | AA | 2013-02-15 15:49:00 | 2013-02-15 15:49:02 |  |  |  | H | BB | 2013-02-15 08:39:56
C | CC | 2013-02-15 12:35:00 | 00:00:00 |  |  |  |  |  | 2013-02-15 08:39:13
B | BB | 2013-02-15 10:32:00 | 2013-02-15 10:32:53 |  |  |  | J | AA | 2013-02-15 08:30:17
A | AA | 2013-02-15 09:02:00 | 00:00:00 |  |  |  | J | AA | 2013-02-15 08:29:39
 |  | 2013-02-15 08:32:00 | 00:00:00 |  |  |  | C | CC | 2013-02-15 08:27:11
F | CC | 2013-02-15 08:27:00 | 00:00:00 |  |  |  | F | CC | 2013-02-15 08:26:50
I | CC | 2013-02-15 10:32:00 | 00:00:00 |  |  |  | D | AA | 2013-02-15 08:25:52
F | BB | 2013-02-15 11:32:00 | 00:00:00 |  |  |  | J | AA | 2013-02-15 08:19:26
 |  | 2013-02-15 08:11:30 | 2013-02-15 08:12:31 |  |  |  |  |  | 2013-02-15 08:12:31
H | BB | 2013-02-15 09:02:26 | 2013-02-15 09:02:28 |  |  |  | C | CC | 2013-02-15 08:11:10
J | AA | 2013-02-15 08:29:39 | 2013-02-15 08:30:17 |  |  |  | F | CC | 2013-02-15 08:06:45
H | AA | 2013-02-15 08:29:39 | 00:00:00 |  |  |  | B | BB | 2013-02-15 08:03:13
 |  |  |  |  |  |  | B | BB | 2013-02-15 08:00:52
Spreadsheet: 852234d1702322057-calculating-the-number-of-ot-hours-between-two-times-from-times-that-cross-midnight-time-sheet-calculator
Sheet: Monthly Timesheet

 |  | OVERTIME SUMMARY/ SOMMAIRE DES HEURES SUPPLÉMENTAIRES
 |  | PRE-APPROVAL / PRÉ-APPROBATION
 |  | Name / Nom: | [NAME]
 |  | Department / Département:
 |  | Year / Année | Month / Mois | Start Date | Weekend / Fin de semaine
 |  | 2023 | November | 3 | Sat & Sun
 |  | Daily Start Time / Début de journée | Normal workday (including lunch period) / Journée de travail normale (pause-repas incluse) |  | Statutory Holiday
 |  | 09:00:00 | 8
 | DAY / JOUR | DATE | EVENT or CORE & OT JUSTIFICATION ÉVÉNEMENT OU GÉNÉRAL & JUSTIFICATION du TS | OT  CODE TS | OT description Description TS | START DÉBUT | END FIN | MEAL(S) REPAS | REG HOURS / HEURES NORMALES | OT  TS
 |  |  | Event that cross over midnight  (Start time 6:00 a.m., end time 03:00 a.m.) Currently I can only put midnight at the latest end time | 260 |  | 06:00:00 | 1900-01-01 00:00:00 | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5 |  |  |  | Logical test | Value if true | Value if false = OR function
 |  |  |  |  |  |  |  | 0.5 |  |  |  | OR(H13="",I13="") | "" | OR(Something is True, Something else is True) |  |  |  | Value if True |  |  | Value if False
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  | OR(WEEKDAY(C13)=1,WEEKDAY(C13)=7) |  |  |  | ((SUM(-H13,I13)*24)-J13) |  |  | IF(AND(H13<>"",I13<>""),((IF(H13<$C$10,MIN($C$10-H13,I13-H13),0)+IF(I13>$C$10+TIME($D$10,($D$10-INT($D$10))*60,0),MIN((I13-$C$10-TIME($D$10,($D$10-INT($D$10))*60,0)),(I13-H13)),0))*24),"")
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  | with holiday argument:
 |  |  |  |  |  |  |  | 0.5 |  |  |  |  |  | [NAME]))
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  | Monthly OT Total / Total TS mensuel
Spreadsheet: andy_zipper__755__10_23_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 270 | 21 | 24 | 107.5 | 122.9 | 19.55 | 2001-10-23 11:24:00
 | NG Z1 | 295 | 56 | 59 | 77.3 | 81.4 | 14.72 | 2001-10-23 11:24:00
 | NG F2 | 315 | 80 | 83 | 76.9 | 79.8 | 15.52 | 2001-10-23 11:24:00
 | NG G2 | 315 | 91 | 96 | 71.4 | 75.4 | 14.54 | 2001-10-23 11:24:00
 | NG H2 | 315 | 91 | 96 | 63.1 | 66.6 | 12.84 | 2001-10-23 11:24:00
 | NG J2 | 300 | 78 | 82 | 51.4 | 54.1 | 9.95 | 2001-10-23 11:24:00
 | NG K2 | 305 | 81 | 85 | 48.1 | 50.5 | 9.45 | 2001-10-23 11:24:00
 | NG M2 | 310 | 87 | 91.5 | 47 | 49.5 | 9.4 | 2001-10-23 11:24:00
 | NG N2 | 315 | 91 | 96 | 45.7 | 48.3 | 9.31 | 2001-10-23 11:24:00
 | NG Q2 | 320 | 99 | 104 | 46.4 | 48.8 | 9.58 | 2001-10-23 11:24:00
 | NG U2 | 320 | 104 | 110 | 46.4 | 49.1 | 9.61 | 2001-10-23 11:24:00
 | NG V2 | 325 | 109 | 116 | 45.9 | 48.9 | 9.69 | 2001-10-23 11:24:00
 | [NAME] |  |  |  |  |  | 10.12 | 2001-10-18 10:52:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 781826d1653574126-count-of-certain-text-based-on-value-on-another-cell-test
Sheet: Data

Project | Assigned to | Status
ABC report | [NAME] | In Progress
XYZ Project | [NAME] | Complete
ABC Presentation | [NAME] | In Progress
Costings report | [NAME] | Not started
AAA Report | [NAME] | In Progress
Pricing report | [NAME] | In Progress
Spreadsheet: 796087d1663092153-spill-range-with-countifs-of-unique-rows-countifs_unique
Sheet: Sheet1

Date_1 | Date_2 | Date_3 |  |  | Date_1 | Date_2 | Date_3 |  |  | COUNTIFS |  | COUNTIFS |  | COUNTIFS
2019-07-30 00:00:00 | 2019-06-25 00:00:00 | 2019-08-01 09:44:12 |  |  |  | 2019-06-25 00:00:00 | 2019-08-01 09:44:12
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 1 |  | #[NAME]! | 1
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-08-01 00:00:00 | 2019-07-08 00:00:00 | 2019-08-01 12:19:15 |  |  | 1 |  | #[NAME]! | 1
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-08-22 00:00:00 | 2019-07-31 00:00:00 | 2019-09-20 06:54:36 |  |  | 1 |  | #[NAME]! | 1
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-09-03 00:00:00 | 2019-08-07 00:00:00 | 2019-09-05 12:57:23 |  |  | 1 |  | #[NAME]! | 1
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  | 2019-09-05 00:00:00 | 2019-08-13 00:00:00 | 2019-09-05 09:55:58 |  |  | 1 |  | #[NAME]! | 1
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  |  |  |  |  |  | 1 |  | #N/A | 1
2019-08-09 00:00:00 | 2019-07-01 00:00:00 | 2019-10-03 13:39:20 |  |  |  |  |  |  |  | 1 |  | #N/A | 1
2019-08-01 00:00:00 | 2019-07-08 00:00:00 | 2019-08-01 12:19:15 |  |  |  |  |  |  |  | 2 |  | #N/A | 2
2019-08-01 00:00:00 | 2019-07-08 00:00:00 | 2019-08-01 12:19:15 |  |  |  |  |  |  |  | 2 |  | #N/A | 2
2019-08-22 00:00:00 | 2019-07-31 00:00:00 | 2019-09-20 06:54:36 |  |  |  |  |  |  |  | 2 |  | #N/A | 2
2019-09-03 00:00:00 | 2019-08-07 00:00:00 | 2019-09-05 12:57:23 |  |  |  |  |  |  |  | 3 |  | #N/A | 3
2019-09-05 00:00:00 | 2019-08-13 00:00:00 | 2019-09-05 09:55:58 |  |  |  |  |  |  |  | 4 |  | #N/A | 4
2019-09-05 00:00:00 | 2019-08-13 00:00:00 | 2019-09-05 09:55:58 |  |  |  |  |  |  |  | 4 |  | #N/A | 4
Spreadsheet: 682878d1592376360-how-to-align-matching-series-with-data-with-multiple-columns-in-excel-test-align
Sheet: Sheet1

 | subject_dtx | data | Subject_nrsa | data | Subject_fgsds | data | Subject_edss | data |  | subject_dtx | data | Subject_nrsa | data | Subject_fgsds | data | Subject_edss | data
 | Alpha | 21 | Alpha | 3 | Echo | 87 | Foxtrot | 34 |  | Alpha | 21 | Alpha | 3 |  |  |  |  |  | Alpha
 | [NAME] | 44 | [NAME] | 45 | India | 43 | Hotel | 41 |  | [NAME] | 44 | [NAME] | 45 |  |  |  |  |  | [NAME]
 | [NAME] | 1 | November | 52 | Lima | 55 | [NAME] | 11 |  | [NAME] | 1 |  |  |  |  |  |  |  | [NAME]
 | Golf | 23 | Sierra | 87 | Papa | 40 | Lima | 98 |  |  |  |  |  |  |  |  |  |  | Delta
 | Zulu | 43 | Tango | 786 | Romeo | 89 | [NAME] | 45 |  |  |  |  |  | Echo | 87 |  |  |  | Echo
 |  |  | Yankee | 34 |  |  | Papa | 23 |  |  |  |  |  |  |  | Foxtrot | 34 |  | Foxtrot
 |  |  |  |  |  |  | Quebec | 21 |  | Golf | 23 |  |  |  |  |  |  |  | Golf
 |  |  |  |  |  |  | Zulu | 67 |  |  |  |  |  |  |  | Hotel | 41 |  | Hotel
 |  |  |  |  |  |  |  |  |  |  |  |  |  | India | 43 |  |  |  | India
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 11 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kilo
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lima | 55 | Lima | 98 |  | Lima
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | November | 52 |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Papa | 40 | Papa | 23 |  | Papa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quebec | 21 |  | Quebec
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Romeo | 89 |  |  |  | Romeo
 |  |  |  |  |  |  |  |  |  |  |  | Sierra | 87 |  |  |  |  |  | Sierra
 |  |  |  |  |  |  |  |  |  |  |  | Tango | 786 |  |  |  |  |  | Tango
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Uniform
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Victor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Whiskey
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X-ray
 |  |  |  |  |  |  |  |  |  |  |  | Yankee | 34 |  |  |  |  |  | Yankee
 |  |  |  |  |  |  |  |  |  | Zulu | 43 |  |  |  |  | Zulu | 67 |  | Zulu
Spreadsheet: 220294d1363113811-populating-data-into-a-summary-tab-using-multiple-data-tabs-formulahelp1
Sheet: Summary

 |  |  |  | 202 | 204 | 52 | 20 | Total
 |  |  | BCB
 |  |  | MCM
 |  |  | AET
 |  |  | UHC
 |  |  | WCM
 |  |  | COM
 |  |  | CIG
 |  |  | AFH
 |  |  | UNA
 |  |  | AIS
 |  |  | MMM
 |  |  | OFN
 |  |  | SSB
 |  |  | SPB
 |  |  | MHMO
 |  |  | MPPO
 |  |  | MAID
 |  |  | PHCS
 |  |  | CTM
 |  |  | MPN
 |  |  | MSI
 |  |  | EHI
 |  |  | BSI
 |  |  | RMI
 |  |  | USI
 |  |  | OHP
 |  |  | MAM
 |  |  | WHO
 |  |  | MVP
 |  |  | CVI
 |  |  | HUI
 |  |  | NCI
 |  |  | HIP
 |  |  | VIS
 |  |  | AMI
 |  |  | JHP
 |  |  | PIC
 |  |  | HNI
Spreadsheet: chris_germany__2314__2001new02
Sheet: CGAS

 | Citygate | Pool |  | 456379 |  |  |  |  |  | Deal 597193 less Storage |  |  |  |  |  |  | IF On |  |  |  | 563831 / 563837 |  |  | Deal 549411
 | Deal | Deal |  | Storage | Storage |  | CES | ENA |  | Actuals |  |  |  |  | Adjusted |  | Deal |  | [NAME] |  | Undertakes |  |  | Citygate |  | Per Jeff's Sheet
 | 597193 | 597332 |  | Gross | Net |  | Transport | Transport |  | From ENA |  | FOM | 3rd Party | Spot Deals | FOM |  |  |  | [NAME] SALES |  | [NAME] |  | Gas Daily | Price |  | COH-Stor | COH | Buy/(Sell)
1 | 72496 | 21066 |  | 51899 |  |  | 140099 |  |  |  |  | 25038 |  |  |  |  |  |  |  |  |  |  | 6.095 |  |  | 50765 | 7282 | ??
 | 104663 |  |  | 84751 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.13 |  |  | 82932 | 7282 | -566
 | 83817 |  |  | 63472 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.885 |  |  | 62086 | 7282 | -566
 | 59870 |  |  | 38991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.885 |  |  | 38139 | 7282 | -566
 | 67399 |  |  | 46688 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.885 |  |  | 45668 | 7282 | -566
 | 76710 |  |  | 56207 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.1 |  |  | 54979 | 7282 | -566
 | 79906 |  |  | 59476 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.855
 |  |  |  | 1448997
Spreadsheet: 796600d1663395901-adding-years-and-months-in-decimal-format-adding-years-and-months-in-decimal-format
Sheet: Sheet1

1.1 | 2.11 | 4 | 4 years | Yellow column is the answer |  |  |  |  |  | 1
3.6 | 14.3 | 17.9 | 17 years 9 months |  |  |  |  |  |  | 2
2.5 | 2.8 | 5.1 | 5 years 1 month |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 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
Spreadsheet: 841026d1693292435-finding-the-largest-value-and-naming-the-cell-teams
Sheet: Team 1

 | Event 1 | Event 2 | Event 3 | Event 4 | Event 5 | Event 6 | Total
Judge 1
Judge 2
Judge 3
Judge 4 |  |  |  |  |  | 11
Judge 5
Judge 6
Total
Spreadsheet: 197355d1354306376-new-excel-user-need-help-creating-list-that-populates-different-information-calendar-sample
Sheet: Jan

 |  |  |  |  |  |  |  |  | Select Year: | 2013
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | Sample text.
 |  |  | Notes: