tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 455842d1460532021-take-monday-value-if-not-zero-and-blank-then-next-new-date-values-take-monday-value-if-not-then-next-new-date-values
Sheet: monday and friday values

2013-09-01 00:00:00 | Sunday |  |  | Monday Dates |  |  | Saturday Dates
2013-09-02 00:00:00 | Monday | 27.13888888888889 |  | 2013-09-02 00:00:00 | 27.14 |  | 2013-09-07 00:00:00 | 26.37
2013-09-03 00:00:00 | Tuesday | 27.46111111111111 |  |  | 26.08 |  |  | 25.58
2013-09-04 00:00:00 | Wednesday | 28.11111111111111 |  |  | 25.44 |  |  | 25.98
2013-09-05 00:00:00 | Thursday | 26.84722222222222 |  |  | 25.4 |  |  | 25.4
2013-09-06 00:00:00 | Friday | 26.92222222222222 |  |  | 25.97 |  |  | 25.97
2013-09-07 00:00:00 | Saturday | 26.36944444444444
2013-09-08 00:00:00 | Sunday | 0 |  | Take Monday value if not (Zero and Blank) then next new date values
2013-09-09 00:00:00 | Monday
2013-09-10 00:00:00 | Tuesday |  |  | Hello Friends
2013-09-11 00:00:00 | Wednesday | 26.08055555555556
2013-09-12 00:00:00 | Thursday | 25.75277777777778 |  | Please find the attached file (Take Monday value if not then next new date values.xlsx)
2013-09-13 00:00:00 | Friday | 25.58333333333333
2013-09-14 00:00:00 | Saturday |  |  | I need to plot the values for Monday if it is zero or blank then look for next new Tuesday then Wednesday upto Saturday in light yellow cells by formula.
2013-09-15 00:00:00 | Sunday
2013-09-16 00:00:00 | Monday |  |  | Similarly the need to plot the values for Saturday if it is zero or blank then look for previous old Friday then Thursday upto Monday.
2013-09-17 00:00:00 | Tuesday | 25.44444444444444
2013-09-18 00:00:00 | Wednesday | 25.37777777777778 |  | I try to used the combination of `IF' and `VLOOKUP' but it is much complicated.
2013-09-19 00:00:00 | Thursday | 25.79166666666667
2013-09-20 00:00:00 | Friday | 25.98055555555555 |  | Is there any simple shortcuts.
2013-09-21 00:00:00 | Saturday | 0
2013-09-22 00:00:00 | Sunday |  |  | thanks in advance
2013-09-23 00:00:00 | Monday
2013-09-24 00:00:00 | Tuesday
2013-09-25 00:00:00 | Wednesday
2013-09-26 00:00:00 | Thursday | 25.4
2013-09-27 00:00:00 | Friday
2013-09-28 00:00:00 | Saturday | 0
2013-09-29 00:00:00 | Sunday
2013-09-30 00:00:00 | Monday | 25.96666666666667
Spreadsheet: 769303d1645458862-combine-if-function-and-sum-countif-indirect-testing
Sheet: Sheet1

NAME | DATE | [NAME] |  |  |  | NAME | NORMAL DAYS | WEEKEND DAYS | Holly days
RAMI | 2022-01-01 00:00:00 |  |  |  |  | RAMI |  |  |  |  | RAMI | 2022-01-01 00:00:00
NASSIM | 2022-01-02 00:00:00 |  |  |  |  | NASSIM |  |  |  |  | NASSIM | 2022-01-02 00:00:00
 |  |  |  |  |  | FARID |  |  |  |  | FARID | 2022-01-03 00:00:00
 |  |  |  |  |  | KARIM |  |  |  |  | KARIM | 2022-01-04 00:00:00
 |  |  |  |  |  | KHALED |  |  |  |  | KHALED | 2022-01-05 00:00:00
 |  |  |  |  |  | NIHAL |  |  |  |  | NIHAL | 2022-01-06 00:00:00
 |  |  |  |  |  | DJAMAL |  |  |  |  | DJAMAL | 2022-01-07 00:00:00
 |  |  |  |  |  | ALI |  |  |  |  | ALI | 2022-01-08 00:00:00
 |  |  |  |  |  | [NAME] |  |  |  |  | [NAME] | 2022-01-09 00:00:00
Spreadsheet: 770744d1646238501-manipulating-text-string-data-into-separate-columns-formatting-text-into-new-columns-2-aligw
Sheet: Sheet1

\ |  |  |  | Ideal Output |  |  |  |  |  |  | AliGW
Data
1 bed, 1 bath, 600 sq ft
1200
1 bed, 1 bath, 7,223 sq ft |  |  |  | 1 bed | 1 bath | 7223
1 bed, 1 bath, 10,602 sq ft |  |  |  | 1 bed | 1 bath | 10602
square feet
availibilityMay 30
1 bed, 1 bath, 740 – 750 sq ft |  |  |  | 1 bed | 1 bath | 740 | 750
Studio, 1 bath, 425 sq ft |  |  |  | Studio | 1 bath | 425
1 bed, 1 bath, 780 - 1,123 sq ft |  |  |  | 1 bed | 1 bath | 780 | 1123
Spreadsheet: 15d7f45c-57a8-42aa-932c-25e41d0f059d
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (11 [NAME]):
 | 5 Labortechnische Geräte 5.4 Labortechnik und [NAME] 5.4.7 Laboreinrichtungen 5.4.7.7 Reinstwassergewinnungsanlagen
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | Adrona | Lettland | Latvija, Riga | 1006 | A1.131
2 | Labconco Corporation | USA | Kansas City | MO 64034 | B2.125
3 | membraPure GmbH | Deutschland | Hennigsdorf | 16761 | A1.213
4 | Merck Millipore | Deutschland | Darmstadt | 64293 | A1.408
5 | Siemens AG, I IA WT HUB EUR | Deutschland | Barsbüttel | 22885 | B1.417
6 | Telstar Technologies S.L. | Spanien | Terrassa, Barcelona | 08227 | B2.205
7 | Thermo Scientific | Deutschland | Dreieich | 63303 | B1.101/202
8 | VWS Deutschland GmbH ELGA LabWater | Deutschland | Celle | 29227 | B1.340
9 | [NAME] GmbH | Deutschland | Leverkusen | 51381 | B1.217
10 | YL Instrument Co., Ltd. | Korea, Republik | Anyang, 431-836 |  | A1.428
11 | Zefa-Laborservice GmbH | Deutschland | [NAME] | 85630 | B1.121/220
Spreadsheet: 01eea043-9c93-451e-b4b5-019b2d951560
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6345.0 Labour Price Index, Australia
 | Ordinary Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Quarterly Index Numbers)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ; |  |  | Original | A2635529C | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Victoria ;  Private and Public ;  All industries ; |  |  | Original | A2644839C | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Queensland ;  Private and Public ;  All industries ; |  |  | Original | A2636859L | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  South Australia ;  Private and Public ;  All industries ; |  |  | Original | A2646169R | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Western Australia ;  Private and Public ;  All industries ; |  |  | Original | A2643509V | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Tasmania ;  Private and Public ;  All industries ; |  |  | Original | A2638189X | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Northern Territory ;  Private and Public ;  All industries ; |  |  | Original | A2642179W | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  Private and Public ;  All industries ; |  |  | Original | A2640849K | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
Quarterly Index ;  Ordinary time hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ; |  |  | Original | A2639519W | 1997-09-01 00:00:00 | 2010-06-01 00:00:00 | 52 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 821358d1678655303-filtering-data-filtering-data
Sheet: Sheet1

Names | Notes | Communications Systems II | Computer Architecture | Energy Conversion II | Industerial Management | Numerical Analysis | Electronic Instrumentation | English Language III | Antennas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Output
Student 1 |  |  | P1 | P1 | P2 | P1 | P1 | P3 | P2 |  |  | Student 1 | Industerial Management, English Language III,[NAME]
Student 2 |  |  |  |  |  |  |  |  |  |  |  | Student 3 | Numerical Analysis
Student 3 |  |  |  | P1 |  | P2 |  |  | P1 |  |  | Student 4 | Communications Systems II,Numerical Analysis
Student 4 |  | P3 |  | P1 |  | P3 | P1 |  | P1
 |  | English Language III | Antennas
Student 3
Student 4 |  | Numerical Analysis
Spreadsheet: 295cc2bb-2155-45ca-a367-45d6f50d4a13
Sheet: Sheet1

Table S1. Genotyping methods for CUL5 SNPs* | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
SNP | dbSNP# | Location | chr. Position& | Method | ABI order # | Forward [NAME] | Reverse PCR Primer | FAM Taqman Probe | VIC [NAME]
1 | rs11212484 | Intron | 107389600 | ABD$ | C__1345221_10
2 | rs3908130 | Intron | 107392976 | ABD | C__7487129_10
3 | rs10890800 | Intron | 107409856 | ABD | C__1345238_10
4 | rs7103534 | Intron | 107416862 | in-house |  | CCAAATCCCTTCTAAATTTGACTCTT | TAACAGGGAATGGTGTGGTAAAAG | CTAGGGAATTAcCTAACTC | TAGGGAATTAtCTAACTCC
5 | rs7117111 | Exon | 107422297 | ABD &  in-house | C__1345246_10 | CATCAGGCTTTAAAAGAAGATATTCTTGA | TTAAAACAAGTCTAAAATAAGCATGTAGAACTTAC | ATTAAGCAaGCACAGGC | TAAGCAgGCACAGGC
6 | rs11212495 | Intron | 104585640 | in-house |  | TTCAGAATCATTTTACTTAGGCAATCTTC | CCATCTGGGAGATTTGGTCCTT | AGTTGAACATaCCTTGTTAG | TTGAACATgCCTTGTTAG
7 | rs12421527 | Intron | 107427722 | ABD | C__1345251_10
8 | rs10890803 | Intron | 107432363 | ABD | C__1345257_10
9 | rs12793438 | Intron | 107436273 | ABD | C__1345259_10
10 | rs3858396 | Intron | 104599127 | in-house |  | TGTGGAGTAAAAATGAGCAACATCA | CTCTATTTCCCTCCCCGTTTTG | CCTTCCCtCCTGCAT | TTCCCgCCTGCATT
11 | rs10890804 | Intron | 107446413 | ABD | C__1345275_10
12 | rs15677 | 3'UTR | 107482699 | ABD | C___445622_10
*primers and probes are in 5'->3' direction
& based on chromosome (Chr.) assembly NT_033899.7;
$[NAME]: ABI TaqMan Assay-by-demand reagent.
Spreadsheet: 329624d1404370960-check-the-data-from-two-sheet-and-result-on-third-sheet-data_24062014
Sheet: PF

Emp. No. | Sub Type | First Name | Last Name | DOB | % | Sex (M/F) | Relation
4 | EPF | SUBARNA | BHATTACHARYA | 13.11.1973 | 100 | F | WIFE
9 | EPF | MEHBUBA | BEGUM | 10.10.1973 | 100 | F | WIFE
9 | EPF | SHIRIN | SULTANA | 28.02.1995 | 100 | F | DAUGHTER
9 | EPF | SK MAHMOOD | ELAHI | 16.04.1956 | 100 | M | SON
11 | EPF | SOMALI | SARKAR | 09.11.1979 | 100 | F | SPOUSE
14 | EPF | MOUSUMI | SENGUPTA | 31.08.1967 | 100 | F | WIFE
15 | EPF | ALO | DUTTA | 01.09.1968 | 100 | F | WIFE
16 | EPF | SUCHISMITA | NAG | 21.03.1964 | 100 | F | WIFE
17 | EPF | MADHURI | SINGH | 01.03.1976 | 100 | F | WIFE
17 | EPF | ANIKET | SINGH | 03.09.2001 |  | M | SON
18 | EPF | EDITH | D'SA | 29.09.1971 | 100 | F | WIFE
23 | EPF | N. | SHYAMALA |  | 100 | F | WIFE
27 | EPF | SHRABASTI | GHATAK |  | 50 | F | DAUGHTER
27 | EPF | SHARMISTHA | GHATAK | 15.08.1993 | 50 | F | DAUGHTER
337 | PF | KAKALI | DAS | 01.01.1973 | 100 | F | SPOUSE
1021 | EPF | NUPUR | MUKHERJEE(CHAKRABORTY) | 18.09.1959 | 100 | F | WIFE
1030 | EPF | GANESH | CHANDRA NATH | 16.01.1949 | 100 | M | SPOUSE
1041 | EPF | [NAME] | SUR ROY | 05.04.1999 | 50 | F | DAUGHTER
1041 | EPF | BRATATI | SUR ROY | 05.02.1968 | 50 | F | WIFE
1080 | EPF | SUPARNA | SENGUPTA | 21.02.1966 | 75 | F | WIFE
1080 | EPF | SOHAM | SENGUPTA | 01.09.1989 | 25 | M | SON
1081 | EPF | DEBJANI | RAY | 11.07.1966 | 100 | F | SPOUSE
1106 | EPF | SUNITA | LAHIRI | 13.07.1968 | 50 | F | WIFE
1106 | EPF | RAJASHMAN | LAHIRI | 10.09.1994 | 50 | M | SON
1112 | EPF | BHASWATI | BOSE | 13.10.1969 | 75 | F | WIFE
1112 | EPF | CHIRANJIT | BOSE | 21.09.1990 | 25 | M | SON
1115 | EPF | RITA | CHAKRABARTY | 22.12.1964 | 50 | F | SPOUSE
1115 | EPF | SOHAM | CHAKRABARTY | 16.11.1992 | 50 | M | CHILD
1122 | EPF | PAPIA | GHOSH | 21.09.1966 | 100 | F | WIFE
Spreadsheet: 854221d1704184399-calculating-manhours-according-date-period-manhours
Sheet: Sheet1

Manpower |  |  |  |  |  | Manhours
 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  |  | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00
1 | 12 | 12 |  |  |  | 1 |  |  |  |  |  | Start Date
2 | 12 | 45 |  |  |  | 2 |  |  |  |  |  | 2024-01-01 00:00:00
3 | 12 | 67 |  |  |  | 3 |  |  |  |  |  | End Date
4 | 14 |  |  |  |  | 4 |  |  |  |  |  | 2024-02-12 00:00:00
5 | 15 |  |  |  |  | 5 |  |  |  |  |  | Total Manhours
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
9 |  |  |  |  |  | 9
10 |  |  |  |  |  | 10
11 |  |  |  |  |  | 11
12 |  |  |  |  |  | 12
13 |  |  |  |  |  | 13
14 |  |  |  |  |  | 14
15 |  |  |  |  |  | 15
16 |  |  |  |  |  | 16
17 |  |  |  |  |  | 17
18 |  |  |  |  |  | 18
19 |  |  |  |  |  | 19
20 |  |  |  |  |  | 20
21 |  |  |  |  |  | 21
22 |  |  |  |  |  | 22
23 |  |  |  |  |  | 23
24 |  |  |  |  |  | 24
25 |  |  |  |  |  | 25
26 |  |  |  |  |  | 26
27 |  |  |  |  |  | 27
28 |  |  |  |  |  | 28
29 |  |  |  |  |  | 29
30 |  |  |  |  |  | 30
31 |  |  |  |  |  | 31
Spreadsheet: 851923d1702044093-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: Indigo

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  | INDIGO | For production quote- [NAME]
Spreadsheet: 489415d1479238716-horizontal-list-of-ids-and-data-needs-to-be-vertically-stacked-in-their-own-individual-row-newdoverman-results-19-and-20-posting
Sheet: Sheet1

A2
B2
[NAME]
D2
Spreadsheet: 865794d1712770278-totalling-column-data-based-upon-heading-book1
Sheet: Sheet1

 |  | Fred | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Total over all events
 |  | Team A | Team B | Team A | Team A | Team B | Team C
 | Event 1 | 20 |  |  |  | 10
 | Event 2 | 20 |  |  |  | 10 | 20
 | Event 3 | 20 | 5 |  | 15 | 10 | 20 | Team A
 | Event 4 |  | 5 | 10 | 15 | 10 |  | 200
 | Event 5 |  | 5 | 10 | 15 | 10 |  | Team B
 | Event 6 |  | 5 | 10 | 15 | 10 |  | 90
 | Event 7 |  | 5 | 10 | 15 |  |  | Team C
 | Event 8 |  | 5 | 10 | 15 |  |  | 40
Spreadsheet: 837688d1690358674-calculating-values-between-date-ranges-excel-date-forum-request
Sheet: Training View

 |  | Training Impact | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
 |  | Skill | M01 | M02 | M03 | M04 | M05 | M06 | M07 | M08 | M09 | M10 | M11 | M12
 |  | AMS CLINICAL TEAM LEADER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AMS CORE | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AMS CHAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AMS CRM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AMS CRM - CLINICAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AMS PRE AUTH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | AMS TEAM LEADER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM CHO | 5 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM CLINICAL TEAM LEADER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM CORE | 0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM CORE CHAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM CRM - CLINICAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM CRM FTQ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM ESC CRM | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM PRE AUTH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM PRE AUTH SPEC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM SPEC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | BM TEAM LEADER | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 44266d1242901374-from-a-value-select-a-range-then-find-the-specify-the-highest-figure-book1
Sheet: Sheet1

Reading | Amount | Begin | End | This gives location (Reading number) where range needs to begin selection. | [NAME] needed to find where end point is reached in the [NAME], starting from the begin point. | With the Begin point and the End point to select a range, the highest figure then needs to be found within.
 |  |  |  |  | Figures are manually inputted for explanation
1 | 98.27 | 99.15 | 98.11999999999999 |  | 12 | 101.57
2 | 99.06 | 99.59 | 98.91 |  | 13 | 101.57
3 | 98.96 | 99.29 | 98.80999999999999 |  | 13 | 101.57
4 | 98.95 | 99.31 | 98.8 |  | 13 | 101.57
5 | 98.8322 | 99.25 | 98.6822 |  | 13 | 101.57
6 | 97.79 | 98.04 | 97.64 |  | 7 | 99.06
7 | 96.44 | 97.12 | 96.28999999999999 |  | 15 | 101.57
8 | 99.69 | 100.31 | 99.53999999999999 |  | 14 | 101.57
9 | 101.04 | 101.32 | 100.89 |  | N/A | N/A
10 | 101.57 | 101.52 | 100.7 |  | N/A | N/A
 | 100.22
 | 99.1
 | 98.09
 | 99.01
 | 96.24
Spreadsheet: 151882d1335175055-excel-2007-list-tasks-between-two-dates-date-lookup
Sheet: Sheet1

Data |  |  |  |  |  |  |  | Result
Task | Start_Date | End_Date | Wrk_dys |  |  |  |  | Date | Task
Task_1 | 2012-04-23 00:00:00 | 2012-04-27 00:00:00 | 4 |  |  |  |  | 2012-04-23 00:00:00 | Task_1
Task_2 | 2012-04-28 00:00:00 | 2012-05-08 00:00:00 | 7 |  |  |  |  | 2012-04-24 00:00:00 | Task_1
Task_3 | 2012-05-08 00:00:00 | 2012-05-24 00:00:00 | 12 |  |  |  |  | 2012-04-25 00:00:00 | Task_1
 |  |  |  |  |  |  |  | 2012-04-26 00:00:00 | Task_1
 |  |  |  |  |  |  |  | 2012-04-27 00:00:00 | Task_1
 |  |  |  |  |  |  |  | 2012-04-28 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-04-29 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-04-30 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-02 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-03 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-04 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-05 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-06 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-07 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | Task_2
 |  |  |  |  |  |  |  | 2012-05-09 00:00:00
 |  |  |  |  |  |  |  | 2012-05-10 00:00:00
 |  |  |  |  |  |  |  | 2012-05-11 00:00:00
 |  |  |  |  |  |  |  | 2012-05-12 00:00:00
 |  |  |  |  |  |  |  | 2012-05-13 00:00:00
 |  |  |  |  |  |  |  | 2012-05-14 00:00:00
 |  |  |  |  |  |  |  | 2012-05-15 00:00:00
 |  |  |  |  |  |  |  | 2012-05-16 00:00:00
 |  |  |  |  |  |  |  | 2012-05-17 00:00:00
 |  |  |  |  |  |  |  | 2012-05-18 00:00:00
 |  |  |  |  |  |  |  | 2012-05-19 00:00:00
 |  |  |  |  |  |  |  | 2012-05-20 00:00:00
 |  |  |  |  |  |  |  | 2012-05-21 00:00:00
 |  |  |  |  |  |  |  | 2012-05-22 00:00:00
 |  |  |  |  |  |  |  | 2012-05-23 00:00:00
 |  |  |  |  |  |  |  | 2012-05-24 00:00:00
Spreadsheet: 230721d1366846471-combining-two-tabes-solution
Sheet: Sheet1

ID2 | ID | PRODUCT
4 | 1 | A
5 | 2 | B
6 | 3 | C
ID2 | ROLE
4 | Role1
4 | Role2
5 | Role1
5 | Role2
ID | PRODUCT | ID2 | ROLE
Spreadsheet: 726757d1617432809-search-a-string-of-text-for-values-from-a-list-and-return-adjacent-value-search-aligw-help
Sheet: Sheet1

 |  | Search Value | Return Value
 |  | 523089 | [NAME]
 |  | 675041 | Colored Printing Paper
 |  | 197901 | Seal Cutters
 |  | 575034 | Divider Tabs
 |  | LPS400 | [NAME]
 |  | 01192903 | [NAME]
 |  | TK51338404T | Chain With Hook
 |  | TK51338554T | Chain With Hook
 |  | 930248 | X-Acto Knife
 |  | 10961871 | Alchemy Wax
Spreadsheet: kevin_hyatt__19594__TW01DEAL
Sheet: #3@15.50

 |  | TW - OPERATION SUN DEVIL Package #3
 |  |  |  |  |  |  |  | TENASKA |  | NNG/TW
 |  |  |  |  | VOLUME | PRICE | TOTAL GAINS | CASH FLOW |  | CASHFLOW
 |  | JANUARY  2001 NYMEX PRICE: |  |  |  | 9.57
 |  | JANUARY 2001 PERMIAN BASIS PRICE: |  |  |  | 0.26
 |  | PHYSICAL PREMIUM / DISCOUNT: |  |  |  | 0.05
 |  | PERMIAN FIXED PRICE: |  |  | 5332
 |  | FUEL RATE PERMIAN TO TW/HALEY: |  |  | 0.0129
 |  | DEMAND:
 |  | COMMODITY: |  |  |  | 0.006
 |  | TW/NNG HALEY PRICE
 |  | TW FUEL
 |  | TW DEMAND |  |  |  | 0.3519
 |  | TW COMMODITY: |  |  |  | 0.0318
 |  | CALIFORNIA PRICE |  |  | 5000 | 15.5
 |  | CASH FLOW BEFORE SHARING:
 |  | TENASKA SHARE @ 8%
 |  | NNG/TW SHARE @ 92%
 |  | PAYMENT TRANSFER THRU SWAP
 |  | NET CASH
 |  | PERMIAN POOL VOLUME |  |  |  | 5332
 |  | TW / HALEY
 |  | VOLUME AT THE BORDER |  |  |  | 5000
Spreadsheet: monika_causholli__28193__Price Forecast
Sheet: Containerboard

[NAME] |  | $
Firm/Analyst | Units | 2000 | 1Q01 | 2Q01 | 3Q01 | 4Q01 | 2001E | 1Q02 | 2Q02 | 3Q02 | 4Q02 | 2002E | 2003E |  | Date |  | Notes
[NAME] | $/sh. [NAME] |  |  |  |  |  | 425 |  |  |  |  | 430 |  |  | 2001-09-05 00:00:00
CIBC Securities (Liner) | $/sh. [NAME] | 470 |  |  |  |  | 435 |  |  |  |  | 440 |  |  | 2001-08-13 00:00:00
CS First Boston - Liner | $/sh. [NAME] | 467 |  | 445 | 428 | 410 | 436q | 413 |  |  |  | 438q |  |  | 2001-10-01 00:00:00 |  | 2001E decreased from 440 to 436. 2002E decreased from 442 to 438.
CS First Boston - Bleached paperboard | $/sh. [NAME] | 867 |  |  |  |  | 856 |  |  |  |  | 847 |  |  | 2001-08-23 00:00:00
CS First Boston - Recycled Paperboard | $/sh. [NAME] | 585 |  |  |  |  | 589 |  |  |  |  | 589 |  |  | 2001-08-23 00:00:00
Deutsche Bank - Liner East | $/sh. [NAME] | 468 | 460 | 452 | 440 | 420 | 443q | 405 | 425 | 440 | 465 | 434q | 495 |  | 2001-09-25 00:00:00 |  | 2002E decreased from 455-434
Deutsche Bank - Medium | $/sh. [NAME] | 446 | 425 | 408 | 395 | 375 | 401q | 365 | 390 | 410 | 435 | 400q | 465 |  | 2001-09-25 00:00:00 |  | 2001E decreased from 403-401 - 2002E decreased from 420 to 400
Deutsche Bank - Bleached Paperboard | $/sh. [NAME] | 870 | 89 | 875 | 85 | 840 | [NAME] | 820 | 820 | 830 | 850 | 830q | 875 |  | 2001-09-25 00:00:00 |  | 2001E decreased by $1/sh. Ton - 2002E decreased from 850 to 830
First Associate Investment Inc. | $/sh. [NAME]
Goldman Sachs - Liner | $/sh. [NAME] | 460 |  |  |  |  | 450 |  |  |  |  |  |  |  | 2001-03-15 00:00:00
Goldman Sachs - Corrugated Boxes | $/sh. [NAME] | 810 |  |  |  |  | 825 |  |  |  |  |  |  |  | 2001-03-15 00:00:00
JP Morgan | $/sh. [NAME] | 468 |  |  |  |  | 450 |  |  |  |  | 475 |  |  | 2001-09-27 00:00:00
Lehman Brothers - Liner | $/sh. [NAME] | 455 |  |  |  |  | 421 |  |  |  |  | 478 | 540 |  | 2001-07-16 00:00:00
Lehman Brothers - Coverted Boxes | $/sh. [NAME] | 758 |  |  |  |  | 739 |  |  |  |  | 764 | 873 |  | 2001-07-16 00:00:00
[NAME] | $/sh. [NAME]
[NAME] | $/sh. [NAME]
Merrill Lynch - Liner | $/sh. [NAME] | 471 |  |  |  |  | 448 |  |  |  |  | 470 |  |  | 2001-08-01 00:00:00
Morgan Stanley | $/sh. [NAME]
National Bank of Canada - Linerboard | $/sh. [NAME] | 470 |  | 447 | 432 |  | 440 |  |  |  |  | 400
National Bank of Canada - Medium | $/sh. [NAME] | 447 |  | 403 | 390 |  | 400 |  |  |  |  | 365
PPW | $/sh. [NAME] |  |  |  |  |  | 448 |  |  |  |  | 470 |  |  | 2001-08-23 00:00:00
Salomon Smith Barney - Liner | $/sh. [NAME] | 464 |  |  |  |  | 435 |  |  |  |  | 430 | 490 |  | 2001-08-16 00:00:00
Scotiabank | $/sh. [NAME]
TD Securities | $/sh. [NAME]
Spreadsheet: 708499d1607879319-value-based-from-date-range-based-on-criteria-of-date-that-is-latest-in-fiscal-year-model
Sheet: Sheet1

Date | Liquid and Semi Liquid |  |  |  |  |  |  | Fiscal Year Start | Fiscal Year end | Latest Liquid and Semiliquid
2021-01-31 00:00:00 | 1 |  |  |  |  |  |  | 2020-04-01 00:00:00 |  | 2 | These value will come with formula
2021-02-28 00:00:00 | 2 | This is latest date so 2 should appear in Cell K2 |  |  |  |  |  |  |  | 9 | These value will come with formula
2021-04-30 00:00:00 | 3
2021-05-31 00:00:00 | 4
2021-06-30 00:00:00 | 5
2021-07-31 00:00:00 | 6
2021-08-31 00:00:00 | 7 |  |  |  |  |  |  | In yellow highlighted cell, That value is required from column B which is the value for latest date of corresponding Fiscal Year
2021-09-30 00:00:00 | 8
2021-10-31 00:00:00 | 9 | This is latest date so 9 should appear in Cell K3
Spreadsheet: 105197d1302627299-transfer-data-from-master-sheet-to-different-sheets-sample
Sheet: Tech Test

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
[NAME] | 80 | 85 | 90 | 95
[NAME] | 95 | 80