tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0d2603a3-9f96-43e7-9bc7-5d47a2cf9923
Sheet: Cash Flow

Lockheed [NAME]
Consolidated Statements of Cash Flows
(unaudited; in millions)
 | Quarters Ended
 | March 30, 2014 |  | March 31, 2013
Operating activities
Net earnings | 933 |  | 761
Adjustments to reconcile net earnings to net cash provided by operating activities:
Depreciation and amortization | 237 |  | 232
Stock-based compensation | 48 |  | 53
Special item - severance charges | 0 |  | 30
Changes in operating assets and liabilities:
Receivables, net | -423 |  | -384
Inventories, net | 29 |  | 43
Accounts payable | 545 |  | 83
Customer advances and amounts in excess of costs incurred | -152 |  | -98
Postretirement benefit plans | 320 |  | 493
Income taxes | 584 |  | 862
Other, net | -21 |  | 10
Net cash provided by operating [NAME] | 2100 |  | 2085
Investing activities
Capital expenditures | -103 |  | -106
Other, net | -23 |  | -42
Net cash used for investing activities | -126 |  | -148
Financing activities
Repurchases of common stock | -1106 |  | -461
Proceeds from stock option exercises | 197 |  | 55
Dividends paid | -444 |  | -371
Other, net | 26 |  | 7
Net cash used for financing activities | -1327 |  | -770
Net change in cash and cash equivalents | 647 |  | 1167
Cash and cash equivalents at beginning of period | 2617 |  | 1898
Cash and cash equivalents at end of period | 3264 |  | 3065
1  The Corporation received net tax refunds of approximately $200 million during the first quarter of 2014 compared to net tax refunds of $540 million during
the first quarter of 2013.
Spreadsheet: 874730d1721261838-excel-formula-for-changing-cell-colour-when-date-inputted-is-getting-closer-for-maisiegm
Sheet: Sheet1

Dates
2024-09-27 00:00:00
2025-02-16 00:00:00
2024-10-06 00:00:00
2024-11-22 00:00:00
2025-03-07 00:00:00
2025-01-31 00:00:00
2025-03-05 00:00:00
2024-08-02 00:00:00
2024-09-01 00:00:00
2024-09-25 00:00:00
2024-11-03 00:00:00
2024-12-25 00:00:00
2025-01-19 00:00:00
2024-11-19 00:00:00
2025-02-28 00:00:00
2024-11-18 00:00:00
2024-12-13 00:00:00
2024-11-07 00:00:00
2024-10-13 00:00:00
2024-12-06 00:00:00
2024-09-12 00:00:00
2024-08-02 00:00:00
2024-09-24 00:00:00
2025-01-19 00:00:00
2024-08-04 00:00:00
2024-12-11 00:00:00
2024-11-18 00:00:00
2024-09-12 00:00:00
2024-12-29 00:00:00
2024-09-12 00:00:00
2024-07-26 00:00:00
2024-09-03 00:00:00
2024-09-03 00:00:00
2024-12-20 00:00:00
2024-10-03 00:00:00
2025-03-17 00:00:00
2025-01-12 00:00:00
2025-02-17 00:00:00
2024-12-05 00:00:00
2024-10-09 00:00:00
2024-12-04 00:00:00
2024-09-14 00:00:00
2024-10-05 00:00:00
2024-09-27 00:00:00
2024-12-22 00:00:00
2024-11-17 00:00:00
2024-12-18 00:00:00
2024-07-26 00:00:00
2024-09-25 00:00:00
2024-10-29 00:00:00
2024-11-17 00:00:00
2025-02-22 00:00:00
2025-02-22 00:00:00
2025-01-28 00:00:00
2025-02-20 00:00:00
2024-12-04 00:00:00
2024-09-19 00:00:00
2024-08-23 00:00:00
2024-10-09 00:00:00
2024-12-21 00:00:00
2024-10-06 00:00:00
2025-02-16 00:00:00
2024-12-02 00:00:00
2024-12-26 00:00:00
2025-01-09 00:00:00
2024-09-25 00:00:00
2025-01-28 00:00:00
2024-09-14 00:00:00
2024-11-15 00:00:00
2024-12-14 00:00:00
2024-12-28 00:00:00
2024-09-04 00:00:00
2025-02-16 00:00:00
2025-02-18 00:00:00
2024-10-23 00:00:00
2024-12-12 00:00:00
2024-12-16 00:00:00
2025-03-16 00:00:00
2024-08-06 00:00:00
2024-12-28 00:00:00
2024-07-19 00:00:00
2025-02-10 00:00:00
2025-01-31 00:00:00
2024-08-08 00:00:00
2024-10-14 00:00:00
2024-11-03 00:00:00
2024-11-14 00:00:00
2024-09-03 00:00:00
2024-08-27 00:00:00
2024-10-20 00:00:00
2024-08-14 00:00:00
2024-09-26 00:00:00
2024-11-25 00:00:00
2024-09-10 00:00:00
2025-01-09 00:00:00
2025-01-29 00:00:00
2024-12-27 00:00:00
2025-01-31 00:00:00
2025-03-08 00:00:00
Spreadsheet: 876681d1723406599-i-want-condition-based-relative-date-if-condition-is-in-a-range-then-first-date-and-last-under-work-1
Sheet: TEST

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 |  | 1234 |  | CL
PK | NM | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 | 2024-01-08 00:00:00 | 2024-01-09 00:00:00 | 2024-01-10 00:00:00 | 2024-01-11 00:00:00
1233 | AB | P | CL | P | P | P | P | P | P | P | P | kk
1234 | AC | P | P | CL | LL | LL | P | P | CL | CL | CL | P
1235 | AB | CL | P | CL | P | P | P | P | P | P | LL | kk
1236 | AC | P | P | P | P | P | P | P | P | P | AL | kk
1237 | AB | jj | P | LL | LL | LL | CL | LL | LL | P | P | kk
1238 | AC | P | P | P | P | P | P | P | P | P | P | P
1239 | AB | P | P | P | P | P | P | P | P | P | P | P
 |  |  |  |  |  | I want this out put only |  |  | where condition meet, display the relative date if condition is in range then first date (result in one column) and last date (result  in second column) where conditon meet
 |  |  |  |  |  | 2024-01-03 00:00:00 | 2024-01-03 00:00:00
 |  |  |  |  |  | 2024-01-08 00:00:00 | 2024-01-10 00:00:00
Spreadsheet: 788014d1658225343-creating-automatic-list-of-active-employees-sheet1
Sheet: Sheet1

 | Employees | Resignation Date |  | Expected Results
 | Emp01 |  |  | Emp01
 | Emp02 | 2022-05-01 00:00:00 |  | Emp03
 | Emp03 |  |  | [NAME]
 | [NAME] |  |  | Emp06
 | Emp05 | 2022-07-01 00:00:00 |  | Emp07
 | Emp06 |  |  | Emp08
 | Emp07 |  |  | Emp10
 | Emp08
 | Emp09 | 2022-10-25 00:00:00
 | Emp10
Spreadsheet: 878345d1725425882-how-do-i-convert-this-table-with-a-range-of-values-into-individual-rows-aeroexcel-age-next-birthday-2-spill-365-aligw
Sheet: Sheet1

AGE |  |  | $
1 | to | 18 | 348 |  |  | 348
19 | to | 20 | 357 |  | 2 | 348
21 | to | 25 | 342 |  | 3 | 348
 |  |  |  |  | 4 | 348
 |  |  |  |  | 5 | 348
 |  |  |  |  | 6 | 348
 |  |  |  |  | 7 | 348
 |  |  |  |  | 8 | 348
 |  |  |  |  | 9 | 348
 |  |  |  |  | 10 | 348
 |  |  |  |  | 11 | 348
 |  |  |  |  | 12 | 348
 |  |  |  |  | 13 | 348
 |  |  |  |  | 14 | 348
 |  |  |  |  | 15 | 348
 |  |  |  |  | 16 | 348
 |  |  |  |  | 17 | 348
 |  |  |  |  | 18 | 348
 |  |  |  |  | 19 | 357
 |  |  |  |  | 20 | 357
 |  |  |  |  | 21 | 342
 |  |  |  |  | 22 | 342
 |  |  |  |  | 23 | 342
 |  |  |  |  | 24 | 342
 |  |  |  |  | 25 | 342
Spreadsheet: 438413d1451982624-another-simple-question-re-index-match-sample1
Sheet: MASTERLIST

CITY/MUNICIPALITY | BARANGAY | BARANGAY ID | SET | HOUSEHOLD ID | HOUSEHOLD MEMBER ID / ENTRY ID | LAST NAME | FIRST NAME | MIDDLE NAME | GRANTEE | GENDER | AGE | PREGNANT | DOMINANT HEALTH ID | DOMINANT NAME OF HEALTH CENTER | DOMINANT SCHOOL ID | DOMINANT NAME OF SCHOOL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pregnancy N/A | Miscarriage | Delivered
ANGELES CITY | [NAME] | 35401002 | 1 | [PHONE]-00641 | 1353096 | CALUGAY | [NAME] | PELAYO |  | M | 3 |  | 5409 | DALANGUIRING Barangay Health Station | 10202 | DALANGUIRING INTEGRATED SCHOOL
ANGELES CITY | PAMPANG | 35401017 | 1 | [PHONE]-00322 | 1359612 | MOLIDO JR | JENNIFER | IGNACIO |  | M | 33 | YES | 5442 | SAWAT BHC
Spreadsheet: 72012d1272678071-array-formula-respective-stock-symbols-dr_forumsample
Sheet: Sheet1

Account | ACCTDEMO
Symbol | LAST | BID | ASK | DATA | QTY | DESTIN | Side
T | 26.21 | 26.09 | 26.58 | 0 | 100 |  | S
T | 26.21 | 26.09 | 26.58 | 0 | 100 |  | S
T | 26.21 | 26.09 | 26.58 | 0 | 100 |  | S
T | 26.21 | 26.09 | 26.58 | 0 | 100 |  | S
T | 26.21 | 26.09 | 26.58 | 0 | 100 |  | S
Totals | 13105 | 13045 | 13290 |  | 500
Spreadsheet: 790769d1659983268-return-row-value-with-reference-to-separate-worksheets-column-value-show-value-of-row-with-ref-to-column-value
Sheet: Result

ID# | Value1 | Value2 | Value3 | Report |  | ID# = | Show the row value of worksheet Source$A:$A has N
2326558 | 22.908 | 31.681 | 22.94 | Report |  | Value1 = | Show the row value of worksheet Source$A:$A has N
2326580 | 22.486 | 30.422 | 23.642 | Normal |  | Value2 = | Show the row value of worksheet Source$A:$A has N
 |  |  |  |  |  | Value3 = | Show the row value of worksheet Source$A:$A has N
 |  |  |  |  |  | Report = | Show the row value of worksheet Source$A:$A has N where if columns F, H and J has 'Normal' show 'Normal' else show <>'Normal'
Spreadsheet: 201643d1356053641-autopopulate-sheets-within-one-workbook-based-on-condition-registration
Sheet: Registration

First Name | Last Name | Class 1 | Class 2 | Phone | [NAME] | Address
A | [NAME] | English | Math | [PHONE] | [EMAIL] | 111
B | Billy | Math | Science | 222-222-22222 | [EMAIL] | 222
C | [NAME] | Science | History | [PHONE] | [EMAIL] | 333
D | [NAME] | Math | English | [PHONE] | [EMAIL] | 444
Spreadsheet: 168751d1342557192-formula-for-extracting-data-from-one-workbook-to-another-book2
Sheet: Sheet1

 | first | last | position | Salary
bobdoe | bob | doe | manager | 25000
johnfree | [NAME] | free | cashier | 19000
franblue | fran | blue | server | 20000
stewdark | stew | dark | host | 17000
[NAME] | lance | [NAME] | server | 20000
Spreadsheet: 1347931b-32bd-4089-aea1-5e0c8e5a3a8c
Sheet: SUMMARY

 | Table 1: Annual cases of bacterial meningitis and septicaemia by country and type (2011/12)
 |  | Meningococcal meningitis & septicaemia |  | Pneumococcal meningitis | Haemophilus influenzae meningitis | TB meningitis | Other causes | Neonatal Group B Streptococcal septicaemia* | Total
 |  | All | [NAME]
 | England
 | Wales
 | Scotland*
 | Northern Ireland
 | Total UK |  |  |  |  |  |  | 274
 | * Scottish data is for calendar year 2012 because epidemiological data was unavailable
 | Table 2: Annual cases of bacterial meningitis and septicaemia by country and type to represent the burden of uncontrolled disease
 |  | Meningococcal meningitis & septicaemia |  | Pneumococcal meningitis | Haemophilus influenzae meningitis | TB meningitis | Other causes | Neonatal Group B Streptococcal septicaemia** | Total
 |  | All | [NAME]
 | England
 | Wales
 | Scotland*
 | Northern Ireland
 | Total UK |  |  |  |  |  |  | 274
 | * Scottish data is for calendar years 2000 - 2012 because epidemiological data was unavailable
Spreadsheet: 017447e7-0862-4cf4-a5b2-8cbdfd765c4e
Sheet: Invsigtns, Exams, and Commts

 |  | Pre-Sentence Investigation Reports (I.C. 19-2524) |  |  | Designated Examinations  by Ordering County |  |  |  |  | Civil Commitments (I.C. 66-329)  by Ordering County
 |  | Monthly | [NAME] |  | Monthly County Total | Monthly Regional Total | [NAME] | [NAME] |  | Monthly County Total | Monthly Regional Total | [NAME] | [NAME]
Region 1 | Benewah | 12 | 44 |  | 2 |  | 3 |  |  |  |  | 1
 | [NAME] |  |  |  | 5 |  | 25 |  |  | 5 |  | 35
 | Boundary
 | Kootenai |  |  |  | 40 |  | 209 |  |  | 3 |  | 42
 | Shoshone |  |  |  | 3 |  | 9 |  |  | 3 |  | 6
Region 2 | Clearwater | 11 | 43 |  |  |  | 4 |  |  |  |  | 3
 | Idaho |  |  |  |  |  | 3 |  |  |  |  | 2
 | Latah |  |  |  | 9 |  | 25 |  |  | 1 |  | 5
 | Lewis |  |  |  |  |  | 2 |  |  |  |  | 2
 | Nez Perce |  |  |  | 8 |  | 54 |  |  | 3 |  | 19
Region 3 | Adams | 16 | 108 |  |  |  | 5 |  |  | 1 |  | 2
 | Canyon |  |  |  | 49 |  | 328
 | Gem |  |  |  | 3 |  | 17 |  |  |  |  | 2
 | Owyhee |  |  |  | 1 |  | 12 |  |  |  |  | 3
 | Payette |  |  |  | 4 |  | 17 |  |  | 2 |  | 5
 | Washington |  |  |  | 1 |  | 16 |  |  |  |  | 2
Region 4 | [NAME] | 18 | 149 |  | 137 |  | 738 |  |  | 28 |  | 155
 | Boise |  |  |  |  |  | 2 |  |  | 2 |  | 8
 | Elmore |  |  |  | 3 |  | 27 |  |  |  |  | 6
 | Valley |  |  |  | 2 |  | 5 |  |  |  |  | 1
Region 5 | Blaine | 12 | 54 |  | 2 |  | 15 |  |  |  |  | 2
 | [NAME] |  |  |  |  |  | 1
 | Cassia |  |  |  | 7 |  | 18 |  |  |  |  | 1
 | Gooding |  |  |  | 3 |  | 12 |  |  |  |  | 4
 | [NAME] |  |  |  | 3 |  | 12 |  |  |  |  | 2
 | Lincoln |  |  |  | 2 |  | 7
 | Minidoka |  |  |  | 8 |  | 14 |  |  | 1 |  | 2
 | [NAME] |  |  |  | 30 |  | 149 |  |  | 1 |  | 12
Region 6 | Bannock | 14 | 67 |  | 11 |  | 96 |  |  | 3 |  | 42
 | Bear Lake
 | [NAME]
 | Franklin |  |  |  |  |  | 6 |  |  |  |  | 2
 | Oneida |  |  |  |  |  | 1
 | Power |  |  |  | 1 |  | 4 |  |  |  |  | 1
Region 7 | Bingham | 27 | 109 |  | 10 |  | 42 |  |  | 3 |  | 16
 | [NAME] |  |  |  | 11 |  | 87 |  |  | 8 |  | 56
 | [NAME]
 | [NAME]
 | Custer
 | Fremont |  |  |  | 1 |  | 5
 | [NAME] |  |  |  | 2 |  | 12 |  |  | 1 |  | 2
 | Lemhi |  |  |  |  |  | 8 |  |  |  |  | 3
 | [NAME] |  |  |  | 2 |  | 16 |  |  | 1 |  | 4
 | Teton |  |  |  | 1 |  | 3 |  |  |  |  | 1
Unknown |  |  |  |  |  |  | 5
Statewide
 |  | October 192524 | FY 192524
 |  | 2 | 22
 |  | 4 | 12
 |  | 10 | 67
 |  | 17 | 85
 |  | 7 | 33
 |  | 8 | 45
 |  | 13 | 63
 |  | 61 | 327
Spreadsheet: 780189d1652342188-lookup-between-dates-and-return-value-formula-help-formula-help-required
Sheet: Sheet1

Dates | Volume
2022-04-25 00:00:00 | 61
2022-04-27 00:00:00 | 68 |  |  |  | Lookup Date | Result Expected
2022-05-02 00:00:00 | 63 |  |  |  | 2022-04-26 00:00:00 | 61
2022-05-04 00:00:00 | 90
2022-05-09 00:00:00 | 61
2022-05-11 00:00:00 | 75
2022-05-16 00:00:00 | 75
2022-05-18 00:00:00 | 57
2022-05-23 00:00:00 | 90
2022-05-25 00:00:00 | 60
2022-06-01 00:00:00 | 63
2022-06-03 00:00:00 | 70
2022-06-10 00:00:00 | 91
2022-06-12 00:00:00 | 85
2022-06-19 00:00:00 | 91
2022-06-21 00:00:00 | 70
2022-06-28 00:00:00 | 59
2022-06-30 00:00:00 | 86
Spreadsheet: 881411d1729505677-excel-conditional-formatting-formula-for-date-formula
Sheet: Sheet1

Report Name | Report Cut off Time | 2024-10-01 00:00:00 | 2024-10-02 00:00:00 | 2024-10-03 00:00:00
Report 1 | Day-2 |  |  |  |  |  | Equal to 3 days
Report 2 | Day-2 |  |  |  |  |  | Greater than 3 days
Report 3 | Day-2 |  |  |  |  |  | Equal to less than 2 days
Report 4 | Day-2 |  | 2024-10-03 00:00:00
Report 5 | Day-2
Report 6 | Day-2 | 2024-10-06 00:00:00
Report 7 | Day-2 | 2024-10-06 00:00:00
Report 8 | Day-2 | 2024-10-06 00:00:00
Spreadsheet: 206283d1358137239-can-this-method-of-ranking-be-modified-to-be-more-effective-ranking_example
Sheet: Sheet1

 |  |  | 2012 |  | 2011 |  | 2010 |  | 2009
 |  |  | Championship Cup |  | Challenge Cup |  | Championship Cup |  | Challenge Cup
 | Total |  | (3x at 100%) |  | (2x at 75%) |  | (3x at 50%) |  | (2x at 25%)
Rank | Points | Competitor | Place | Points | Place | Points | Place | Points | Place | Points
1 |  | Smith | 2 |  | 1 |  | 2 |  | 4
2 |  | Cleaver | 5 |  | 2 |  | 1 |  | 1
3 |  | Hobbs | 4 |  | 3 |  | 5 |  | 7
4 |  | Jenkins | 3 |  | 6 |  | 7 |  | 3
5 |  | Wang | 6 |  | 7 |  | 3 |  | 2
6 |  | Paroski | 1 |  | 5 |  | 4
7 |  | Staverton | 7 |  | 4 |  |  |  | 5
8 |  | Laroue | 10 |  |  |  | 6 |  | 6
9 |  | Hasewinkel | 9 |  |  |  | 9 |  | 8
10 |  | [NAME] | 12 |  |  |  | 8
11 |  | Vallois | 11 |  |  |  | 10
12 |  | Collier | 13 |  |  |  | 11
13 |  | [NAME] | 8
14 |  | [NAME] | 14
Spreadsheet: 267027d1379915424-matching-or-vlookup-example2
Sheet: Sheet1

Last | First | Dob | Vuid |  |  | Last | First | Dob | VUID
AABERG | [NAME] | 1956 | 4564654654 |  |  | Abeldano | [NAME] | 1995-05-19 00:00:00
AABERG | [NAME] | 1950 | 56465465 |  |  | Abeldano | Klarysa | 1995-04-22 00:00:00
[NAME] | KAZUKO | 1936 | 545644564 |  |  | Aberman | Mauricio | 1994-11-02 00:00:00
Abeldano | Klarysa | 1995-04-22 00:00:00 | 654654 |  |  | Abrams | [NAME] | 1995-08-25 00:00:00
ABAD | [NAME] | 1969 | 4654654 |  |  | [NAME] | Salvador | 1995-05-19 00:00:00
Abrams | [NAME] | 1975 | 564654465 |  |  | [NAME] | [NAME] | 1995-08-01 00:00:00
ABAD | MARYANN | 1975 | 5465465465 |  |  | Abundis | [NAME] | 1992-07-11 00:00:00
ABAD | MARIA | 1962 | 65789798 |  |  | Acevedo | Genaro | 1994-11-15 00:00:00
Acevedo | Genaro | 1968 | 5646487 |  |  | Acevedo | [NAME] | 1995-07-14 00:00:00
ABAD | DAISY | 1988 | 5487897 |  |  | [NAME] | Alexandra | 1995-09-09 00:00:00
ABAD | MARILU | 1960 | 56489789 |  |  | Acosta | Ventura | 1995-04-17 00:00:00
ABAD | ROXANA | 1982 | 5468789 |  |  | Acosta | Michelle | 1990-04-12 00:00:00
ABAD | ELODIA | 1945 | 5465487 |  |  | Acosta | Kassandra | 1995-04-28 00:00:00
ABAD | [NAME] | 1970 | 54654789 |  |  | Acosta | [NAME] | 1995-02-24 00:00:00
Acosta | [NAME] | 1994-10-27 00:00:00 | 56489765 |  |  | Acosta | [NAME] | 1994-10-27 00:00:00
ABAD | GLORIA | 1962 | 54687654 |  |  | Acosta | Samantha | 1995-08-03 00:00:00
ABAD | JAIME | 1978 | 54654876546 |  |  | [NAME] | Anna | 1995-05-13 00:00:00
ABAD | ADELA | 1987 | 6548765465 |  |  | Adame | San Juanita | 1994-01-04 00:00:00
ABAD | ARMANDO | 1982 | 54657865 |  |  | Adame | Naelee | 1995-05-09 00:00:00
Adame | San Juanita | 1994-01-04 00:00:00 | 65468765 |  |  | Adams | Tatyana | 1995-06-01 00:00:00
Adame | Naelee | 1995-05-09 00:00:00 | 6546578654 |  |  | Adams | [NAME] | 1993-10-15 00:00:00
Spreadsheet: 0ffbbf19-3513-43d9-b6f7-ba180395f4c9
Sheet: 1 | Statistics

 |  |  |  |  | --> Return to first page
Statistics
 |  |  |  |  | Previous |  | Current
 |  |  |  |  | Month |  | Month
Number of MRWs only on SpringerReference |  |  |  |  | 19 |  | 27
Total number of MRWs on SpringerReference |  |  |  |  | 184 |  | 193
Articles unique to SpringerReference |  |  |  |  | 12001 |  | 19918
New articles on SpringerReference (month) |  |  |  |  | 659
New articles on SpringerReference (cumulative starting August 2011) |  |  |  |  | 28895
Total number of articles on SpringerReference |  |  |  |  | 242388 |  | 251152
Number of updates (month) |  |  |  |  | 447
Total number of updates (cumulative starting August 2011) |  |  |  |  | 5527
--> Return to first page
Spreadsheet: 265398d1379243523-want-convert-time-from-1217-50-into-12-17-30-decimal-minutes
Sheet: Sheet1

time in seconds | convert by x by 1440 to decimal minutes |  | your actual decimal minutes | difference
00:00:49 |  |  | 0.83229767337
00:00:50 |  |  | 0.83229767337 |  | closest
your actual values | converted
1229.832297673373
1230.302362435849
1230.766919244578
1231.225472819629
1231.677538314649
1232.122642068583
1232.560322328929
Spreadsheet: 761520d1640974512-populate-based-on-criteria-buy-and-hold
Sheet: Sheet1

 | BUY AND HOLD VS TRADING
 |  |  |  |  |  | Fee >> | 1 |  |  |  | Buy% | Sell%
 | Date | Price | % Difference | Buy | Sell | Profit | Total Fees | Total Profit
 | 1996-05-09 00:00:00 | 23.200001
 | 1996-05-10 00:00:00 | 24
 | 1996-05-13 00:00:00 | 23.9
 | 1996-05-14 00:00:00 | 23.6
 | 1996-05-15 00:00:00 | 23.200001
 | 1996-05-16 00:00:00 | 22.6
 | 1996-05-17 00:00:00 | 22.799999
 | 1996-05-20 00:00:00 | 22.5
 | 1996-05-21 00:00:00 | 30
 | 1996-05-22 00:00:00 | 29.5
 | 1996-05-23 00:00:00 | 22.1
 | 1996-05-24 00:00:00 | 21.6
 | 1996-05-28 00:00:00 | 21.200001
 | 1996-05-29 00:00:00 | 20.799999
 | 1996-05-30 00:00:00 | 20.5
 | 1996-05-31 00:00:00 | 20.4
 | 1996-06-03 00:00:00 | 20.1
 | 1996-06-04 00:00:00 | 21.4
Spreadsheet: 48358d1247582432-changing-a-cell-reference-jan
Sheet: Budget

Budget | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
Sales of Item 1 | 6 | 15 | 9 | 6
Sales of Item 2 | 9 | 2 | 45 | 8
Costs | 4 | 3 | 4 | 8
Expense Other | 9 | 10 | 12
Spreadsheet: 154432d1336423099-more-than-one-countif-jrios_sample_05may12_01
Sheet: Jan-4

DSI North Operations Log
Opener |  |  |  |  |  |  |  | Day of the Week |  | Thursday
Closer |  |  |  |  |  |  |  | Date
Routes |  | Driver |  | Assistant |  | Stops / Pieces | Door | Carpet | Phone | Area
Zip Codes
98001 | 98001 | 98002 | 98002 | 98002 | 98002 | 98002 | 98003
 |  |  |  |  |  |  |  |  | 98001 |  |  |  | 98001
 |  |  |  |  | 98003
 |  |  |  |  |  |  |  |  | 98001
Spreadsheet: 158376d1338206224-depentent-fropdown-list-with-some-specifice-features-essameldin_dep_drop_down_list_28may12_01
Sheet: Sheet1

Tool Type | Tool No. | Bottom Connection | Top Connection | Pressure Rating | Cert. Date | Comments
[NAME] | MWS 38634
GREASE INJECTION HEAD
LUBRICATOR 5-1/8"
BOP 5-1/8"
LUBRICATOR 3"
BOP 3"
PRESSURE TEST CAP | AWS 44196
INTEGRAL PUMP IN SUB
INJECTION SUB 5 3/4" - 4 OTIS PIN / COLLAR
Test [NAME]
Test Plug
QTS SUB
Test Stump
Blind Flange
X.O.
X.O.
Spreadsheet: 841062d1693317213-help-needed-for-a-formula-to-calculate-multiple-texts-in-the-same-cells-test-worksheet-5
Sheet: Warehouse (Physical inventory)

Column 1 | Column 2 | In charge | City | Countries | Parts (Year 2023) | Parts (Year 2024) | Parts (Year 2025) | Parts (Year 2026)
 |  |  |  | Hongkong | Dell.2555.SA [NAME] | Dell.15150.SG CZT.1321519.DD FF.1552.SS
 |  |  |  | India | Dell.2555.SA CZT.6623.134.SS FF.1552.SS | Dell.2555.SA CZT.6623.134.SS FF.1552.SS
 |  |  |  | Japan | Dell.15150.SG CZT.1321519.DD FF.1552.SS | Dell.285.SA.555 CZT.1321519.DD.00 FF.08484.TZD
 |  |  |  | Macau | Dell.285.SA.555 CZT.1321519.DD.00 FF.08484.TZD | Dell.285.SA.555 CZT.1321519.DD.00 FF.08484.TZD
Spreadsheet: 741808d1627367174-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting-sv-booking-sheet-27-july-2021-ans3
Sheet: Availability Calendar (2021)

 |  |  |  | =IF($C8<>"",IF(SUMPRODUCT(('Room Reservation'!$K$9:$K$1181=E$7)*('Room Reservation'!$B$9:$B$1181=$C8))>0,10,1-SUMPRODUCT(('Room Reservation'!$K$9:$K$1181<=E$7)*('Room Reservation'!$L$9:$L$1181>=E$7+1)*('Room Reservation'!$B$9:$B$1181=$C8))),"") |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #1
 |  |  |  | VILLA AVAILABILITY TABLE FOR PERIOD: |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 0.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #2
 |  |  |  | -1 | Available |  | 0 | Not Available |  |  | >=1 | Double Reservation |  |  |  | First day of CheckIn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #3
 |  | Enter Date here |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Villa #4
 |  | 2021-07-01 00:00:00 |  | 0
No | Room Type | Room Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unbooked Days
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
No | Room Type | Room Number
1 | Standard | 1
2 | Standard | 2
3 | Standard | 3
4 | Standard | 4
5 | Standard | 5
Spreadsheet: 112159d1308298461-vertical-line-alignment-with-x-axis-780404
Sheet: Graph

 |  | 41
MIN | MIN
MAX | MAX
MEAN | MEAN
 |  | Val
 | 1307738985 | 0
 |  | 600000000
 | 11.4
Spreadsheet: 676640d1588906569-vlookup-using-range-of-dates-vlookup-using-range-of-dates
Sheet: Sheet1

Authorizations |  |  |  | Sessions
Auth Number | Start Date | End Date |  | Patient | Session Date | Auth Number | Manual Result
1538632650 | 2020-05-18 00:00:00 | 2020-07-14 00:00:00 |  | [NAME] | 2020-07-20 00:00:00 |  | 1538618597
1538632666 | 2020-07-15 00:00:00 | 2020-08-29 00:00:00 |  | [NAME] | 2020-05-20 00:00:00 |  | 1538632650
1537340792 | 2020-08-30 00:00:00 | 2020-09-30 00:00:00 |  | [NAME] | 2020-08-29 00:00:00 |  | 1538632666
 |  |  |  | [NAME] | 2020-10-15 00:00:00 |  | NA or blank
 |  |  |  | [NAME] | 2020-01-21 00:00:00 |  | NA or blank
 |  |  |  | [NAME] | 2020-05-18 00:00:00 |  | 1538632650
 |  |  |  | [NAME] | 2020-06-01 00:00:00 |  | 1538632650
I need a formula to look up the Auth Number in the Authorizations table using the Session Date.