tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 886927d1737031712-data-transfer-from-different-sheets-to-one-main-sheet-tabs-merged-2025-01alexf
Sheet: db

ShNo | nextSheet? | Sheet | Row | Data 1 | Data 2 | Data 3 | next…
1 | 0
Spreadsheet: 681057d1591332979-complicated-formula-needed-to-find-value-in-a-range-with-multiple-variables-consolidated-rules-sample-file-
Sheet: Calcultor Current

 |  |  |  |  |  | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
2020-01-01 00:00:00 |  |  |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00
 |  |  |  |  | Event Guests | 10 | 15 | 10 | 10 | 12 | 14 | 15
 |  |  |  |  | Total Guests | 80 | 86 | 85 | 86 | 86 | 86 | 86
 |  |  |  |  | Occupied rooms | 80 | 80 | 80 | 80 | 80 | 80 | 80
Business name 1
Department | Status | Unit of Measure | Shift | Code | Position | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
 | Active | n/a | n/a | 10a | Night Auditor
 | Active | Event Guests | Shift 1 | 12b | Planner
 | Active | Event Guests | Shift 2 | 12b | Planner
 | Active | Event Guests | Shift 3 | 12b | Planner
 | Inactive | n/a | n/a | 61a | Manager
 | Active | Total Guests | Shift 1 | 51a | Receptionist
 | Active | Total Guests | Shift 2 | 51a | Receptionist
 | Active | Total Guests | Shift 3 | 51a | Receptionist
 | Inactive | n/a | n/a | 31a | Engineer
 | Active | Occupied rooms | n/a | 40a | [NAME]
 | Active | Occupied rooms | n/a | 40b | Server
 |  |  |  |  |  | *** I started to attempt a formula in cell G22 but gave up. :(
Spreadsheet: 705862d1606337821-if-formula-with-limiting-choices-ef1417_gv-south-phase-1-worksheet
Sheet: Spreadsheet

GARDEN VIEW - VINTAGE HEIGHTS - BUYERS WORKSHEET - PHASE 1
Client Name:  Roman & Lesli Knezovich |  |  |  | Lot
Phone:
[NAME]:
Model/Site Selection
Model |  | Garden Beauty - 3 bed
Lot Choice |  | B3L9
Foundation
Basement |  | Yes
Finished Basement |  | Yes
Add 3rd Stall |  | Yes
Allowances
Appliances |  |  |  | 4000 | Incl.
Flooring |  |  |  |  | Incl.
Lighting |  |  |  |  | Incl.
Sod and Sprinklers |  |  |  |  | Incl.
Options
4 Yr Warranty |  | Included |  |  | Incl.
Fireplace |  | Yes
(If Yes) Fireplace Style |  | Add for Stone Surround
Add Cable & Phone |  | No
Add Wood Steps to Deck | 68 | No
Add'l Disc Lights @$68 |  | 0
Smart Home Elec. Package |  | Smart Home Bronze
Total
Purchaser |  |  |  | Date
Purchaser |  |  |  | Date
Spreadsheet: 454902d1460025086-formula-for-lookup-for-left-side-lookup-flat-details
Sheet: Sheet1

Flat | Value | Booking Date
A701 | 100000
B401 | 20000
B601 | 40000
B701 | 60000
A801 | 80000
A601 | 100000
B501 | 120000
B801 | 140000
A401 | 160000 |  | 2016-02-05 00:00:00
A501 | 180000
A901 | 200000
B1001 | 220000 |  | 2015-12-10 00:00:00
B901 | 240000 |  | 2015-12-10 00:00:00
A301 | 260000
A1001 | 280000
Spreadsheet: 758778d1639062023-summing-data-with-criteria-q1-till-q2-till-q3-etc-summing-with-diferent-month
Sheet: Data

Order | Shuttle | Item | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 |  | Q1 | till Q2 | till Q3 | till Q4 | only [NAME] till April | full 1 year
1 | Jakarta | Things 1 | 5 | 4 | 10 | 2 | 12 | 6 | 3 | 8 | 4 | 1 | 2 | 5 |  | ? | ? | ? | ? | ? | ?
2 | Bangkok | Things 1 | 6 | 6 | 12 | 3 | 23 | 7 | 3 | 9 | 5 | 2 | 3 | 6
3 | Hanoi | Things 1 | 7 | 4 | 5 | 41 | 4 | 8 | 3 | 7 | 6 | 3 | 4 | 7
4 | USA | Things 1 | 2 | 2 | 14 | 2 | 5 | 4 | 5 | 7 | 8 | 6 | 5 | 4
5 | China | Things 1 | 6 | 3 | 12 | 2 | 6 | 5 | 6 | 7 | 9 | 7 | 8 | 5
1 | Jakarta | Things 2 | 5 | 7 | 5 | 5 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4
2 | Bangkok | Things 2 | 6 | 8 | 6 | 5 | 10 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | Hanoi | Things 2 | 7 | 3 | 4 | 5 | 10 | 4 | 4 | 4 | 4 | 4 | 4 | 4
4 | USA | Things 2 | 3 | 6 | 4 | 5 | 10 | 4 | 6 | 6 | 6 | 4 | 4 | 4
5 | China | Things 2 | 4 | 8 | 4 | 5 | 10 | 4 | 4 | 8 | 8 | 8 | 8 | 4
1 | Jakarta | Things 3 | 6 | 9 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
2 | Bangkok | Things 3 | 6 | 3 | 12 | 14 | 14 | 14 | 14 | 12 | 12 | 9 | 9 | 9
3 | Hanoi | Things 3 | 6 | 3 | 5 | 12 | 6 | 12 | 5 | 12 | 8 | 12 | 12 | 12
4 | USA | Things 3 | 8 | 4 | 5 | 12 | 6 | 12 | 5 | 12 | 8 | 6 | 6 | 6
5 | China | Things 3 | 9 | 5 | 5 | 12 | 12 | 12 | 12 | 12 | 14 | 14 | 12 | 12
Spreadsheet: 58504d1258733587-pulling-data-with-duplicate-rankings-example
Sheet: Sheet1

 |  |  |  |  | Ranking
 |  |  | Rejection Reasons |  | [NAME] | Aug'09 | [NAME] | Oct'09 | Nov'09 | Dec'09 | Jan'10 | Feb'10 | Mar'10 | Apr'10 | May'10 | Jun'10
 |  |  | Price Issue |  | 1
 |  |  | Not Necessary/ Not Interested |  | 3
 |  |  | Lost to A |  | 4
 |  |  | Lost to ABC |  | 4
 |  |  | Signed at Event/ Talk |  | 2
 |  |  | Did not provide any reason |  | 1
 |  |  | Past EDD - Client has delivered |  | 4
 |  |  | Totally uncontactable |  | 4
 |  |  | Doctor does not recommend UCB banking |  | 4
 |  |  | Doctor supports A and recommend them |  | 4
 |  |  | Unsubscribe from SMS blast list |  | 4
 |  |  | Signed as LMC |  | 4
 |  |  | Duplicate due to LMC |  | 4
 |  |  | Duplicate Lead |  | 4
 |  | Ranking | Rejection Reasons
 | 1 | 1st |  |  | Did not provide any reason
 | 2 | 2nd
 | 3 | 3rd
Spreadsheet: 705230d1605952660-outputting-values-to-new-column-based-on-id-and-if-condition-sampx
Sheet: Sheet1

ID: |  |  | Type |  |  |  |  | Delivery: | Relation: | Expected Value:
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | RRRT |  |  |  |  | RRR |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -/-/-/-/-
1130 |  |  | FFFT |  |  |  |  | RRR |  | -/-/-/-/-
11344 |  |  | AAAT |  |  |  |  | RRR | CCCR | TPAR
11344 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | TPAR
11454 |  |  | TTTT |  |  |  |  |  | CCCR | No Scenarios
11454 |  |  | AAAT |  |  |  |  | AAA | CCCR | No Scenarios
11454 |  |  | AAAT |  |  |  |  | AAA |  | No Scenarios
11454 |  |  | AAAT |  |  |  |  | RRR |  | No Scenarios
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | AAA | CCCR | CCCR/ CCCR
11556 |  |  | IIIT |  |  |  |  | RRR | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ CCCR
11556 |  |  | FFFT |  |  |  |  | ZZZ w/o I | IIIR | CCCR/ CCCR
11556 |  |  | AAAT |  |  |  |  | ZZZ w/o I | CCCR | CCCR/ CCCR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | CCCR | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR
1158 |  |  | FFFT |  |  |  |  | ABC w/ I | VVVR | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB | VVVR | VVVR
1158 |  |  | FFFT |  |  |  |  | RRR | CCCR | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I |  | VVVR
1158 |  |  | IIIT |  |  |  |  | ZZZ w/o I | DHR | VVVR
1158 |  |  | IIIT |  |  |  |  | BBB |  | VVVR
10975 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | TPAR
10975 |  |  | FFFT |  |  |  |  | RRR | CCCR | TPAR
1407 |  |  | FFFT |  |  |  |  | CD w/o Z | TPAR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | TPAR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | ZZZ w/o I | CCCR | No Scenarios
1407 |  |  | FFFT |  |  |  |  | FFF | CCCR | No Scenarios
1161 |  |  | FFFT |  |  |  |  | ABC w/ I |  | -
1161 |  |  | FFFT |  |  |  |  | RRR |  | -
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | CCCR | CCCR/ TPAR/ DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | TPAR | CCCR/ TPAR/ DPAC
99999 |  |  | FFFT |  |  |  |  | ABC w/ I | DPAC | CCCR/ TPAR/ DPAC
Spreadsheet: 19f771e9-7a95-4dd9-b461-3b97d6d97c05
Sheet: 9a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 7045935 | 15759141 | 22805076
 | FRA | 31057334 | 19801351 | 50858684
 | Exotic |  | 3648459 | 3648459
 | Inflation |  | 2687572 | 2687572
 | IRS- [NAME] | 111782659 | 99616613 | 211399272
 | OIS | 19407305 | 18797294 | 38204598
 | VNS | <10,000 |  | <10,000
 | Zero Coupon | 218581 |  | 218581
With Optionality | Callable Swap |  | 812271 | 812271
 | Cap/Floor |  | 10461795 | 10461795
 | Debt Option |  | 297540 | 297540
 | Exotic Option |  | 1449169 | 1449169
 | Swaption |  | 27774980 | 27774980
Cross-Currency | Exotic |  | 91609 | 91609
 | Swap |  | 16482643 | 16482643
TOTAL |  | 169511814 | 217680436 | 387192250
Estimated gross notional amount outstanding, January 4 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 91663d1291319609-linking-multiple-tabs-to-one-main-data-sheet-indirectreferences
Sheet: Main Spreadsheet

 | Project Name | Director | Project code | Budget | Budget spent YTD | Time RAG | Cost RAG | Benefit RAG
Project data 1
Project data 2
Project data 3
Project data 4
Project data 5
Spreadsheet: 0517df54-0c30-4745-b7b0-d9d9e78c2682
Sheet: Table III.5

Table III.5 الجدول
Terrestrial areas protected to total surface area (% and sq.km)
[NAME] المساحة (بالنسبة المئوية وكلم مربع)
 | 2000 |  | 2005 |  | 2006 |  | 2007 |  | 2008 |  | 2009 |  | 2010
 | sq.km | % | sq.km | % | sq.km | % | sq.km | % | sq.km | % | sq.km | % | sq.km | %
Bahrain | 9 | 1.4 | 9 | 1.4 | 9 | 1.4 | 9 | 1.4 | 9 | 1.4 | 9 | 1.4 | 9 | 1.4 | البحرين
Egypt | 42257 | 4.3 | 57986 | 5.9 | 57986 | 5.9 | 57986 | 5.9 | 57986 | 5.9 | 149,176* | 14.9* | 149,176* | 14.9* | مصر
Iraq | 232 | 0.1 | 232 | 0.1 | 232 | 0.1 | 232 | 0.1 | 232 | 0.1 | 232 | 0.1 | 232 | 0.1 | العراق
Jordan | 1683 | 1.9 | 1691 | 1.9 | 1691 | 1.9 | 1691 | 1.9 | 1691 | 1.9 | 1691 | 1.9 | 1712 | 1.9 | الأردن
Kuwait | 276 | 1.6 | 276 | 1.6 | 276 | 1.6 | 276 | 1.6 | 276 | 1.6 | 276 | 1.6 | 276 | 1.6 | الكويت
Lebanon | 49 | 0.5 | 49 | 0.5 | 49 | 0.5 | 49 | 0.5 | 49 | 0.5 | 49 | 0.5 | 49 | 0.5 | لبنان
Oman | 33138 | 10.7 | 33138 | 10.7 | 33138 | 10.7 | 33138 | 10.7 | 33138 | 10.7 | 33138 | 10.7 | 33138 | 10.7 | عمان
Palestine** | 515 | 8.6 | 515 | 8.6 | 515 | 8.6 | 515 | 8.6 | 515 | 8.6 | 515 | 8.6 | 515 | 8.6 | فلسطين
Qatar | 263 | 2.3 | 285 | 2.5 | 285 | 2.5 | 285 | 2.5 | 285 | 2.5 | 285 | 2.5 | 285 | 2.5 | قطر
Saudi Arabia | 604590 | 31.3 | 604590 | 31.3 | 604590 | 31.3 | 604590 | 31.3 | 604590 | 31.3 | 604590 | 31.3 | 604590 | 31.3 | المملكة العربية السعودية
The Sudan | 105412 | 4.2 | 105412 | 4.2 | 105416 | 4.2 | 105416 | 4.2 | 105416 | 4.2 | 105416 | 4.2 | 105416 | 4.2 | السودان
Syrian Arab Republic | 603 | 0.3 | 1203 | 0.6 | 1203 | 0.6 | 1203 | 0.6 | 1203 | 0.6 | 1203 | 0.6 | 1204 | 0.6 | الجمهورية العربية السورية
United Arab Emirates | 215 | 0.3 | 3981 | 5.6 | 3981 | 5.6 | 3981 | 5.6 | 3981 | 5.6 | 3981 | 5.6 | 3981 | 5.6 | الإمارات العربية المتحدة
Yemen | 2374 | 0.5 | 2374 | 0.5 | 2374 | 0.5 | 2374 | 0.5 | 2374 | 0.5 | 2374 | 0.5 | 2374 | 0.5 | اليمن
ESCWA | 791616 | 10.8 | 811741 | 11.1 | 811745 | 11.1 | 811745 | 11.1 | 811745 | 11.1 | 902935 | 12.3 | 902957 | 12.3 | [NAME]
Source: | MDG Database, accessed on 13 July 2011.
 | * | CAPMAS reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.  Year 2010 is estimated by ESCWA to be the same as 2009.
 | ** | PCBS reply to ESCWA on the preliminary tables for the Compendium of Environment Statistics 2010-2011.
Spreadsheet: 778391d1651047111-find-last-value-vertically-based-on-other-criteria-multiple-column-array-lastcolumnvaluebasedoncondition-aligw
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 |  | 1
10 | 5 | 1 | 14 | 10 |  | 2
20 | 9 | 2 | 5 | 0 |  | 3
13 | 0 | 0 | 9 | 0 |  | 4
 |  |  |  |  |  | 5
Spreadsheet: 808528d1670507627-if-error-formular-does-not-work-grade-676-mpyaa
Sheet: WAVULANA 5 BORA NA 5 DUNI (2)

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA  MUHULA WA PILI DARASA LA V NOVEMBA,2022
[NAME] BORA
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
H.WAVULANA 5 DUNI
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 24833b3b-adff-4409-8e5b-7977ab342e21
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GAL3 | Test | GAL3 | Galectin-3, Serum | Galectin-3, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum, [NAME] |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL | 0.2 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | < 18 years: Not established > or =18 years: < or =22.1 ng/mL | Tuesday, Thursday, Sunday | 1 day | 3 days | 1 | 82777 |  |  |  |  | Rochester
GAL3 | [NAME] | SRED | Serum Red |  |  |  | Frozen | 365 days
GAL3 | Result | 86202 | Galectin-3, S | Galectin-3, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 77284d1277793959-standard-deviation-standard-deviation
Sheet: Sheet1

 |  | P |  |  |  |  |  |  |  |  |  |  | (P-Average) |  | ^2
 | 1 | 144.61 |  |  |  | 20912.0521 |  |  |  |  |  |  | 1.59899999999999 |  | 2.556800999999966
 | 2 | 146 |  |  |  | 21316 |  |  |  |  |  |  | 2.988999999999976 |  | 8.934120999999855
 | 3 | 144.05 |  |  |  | 20750.4025 |  |  |  |  |  |  | 1.038999999999987 |  | 1.079520999999974
 | 4 | 142.9 |  |  |  | 20420.41 |  |  |  |  |  |  | -0.1110000000000184 |  | 0.01232100000000409
 | 5 | 141.05 |  |  |  | 19895.1025 |  |  |  |  |  |  | -1.961000000000013 |  | 3.84552100000005
 | 6 | 142.1 |  |  |  | 20192.41 |  |  |  |  |  |  | -0.9110000000000298 |  | 0.8299210000000543
 | 7 | 144.6 |  |  |  | 20909.16 |  |  |  |  |  |  | 1.58899999999997 |  | 2.524920999999905
 | 8 | 143 |  |  |  | 20449 |  |  |  |  |  |  | -0.0110000000000241 |  | 0.0001210000000005302
 | 9 | 141.25 |  |  |  | 19951.5625 |  | SD |  |  |  |  | -1.761000000000024 |  | 3.101121000000085
 | 10 | 140.55 |  |  |  | 19754.3025 |  | 1.701202221958818 |  |  |  |  | -2.461000000000013 |  | 6.056521000000063
 | Average | 143.011 |  |  |  |  |  |  |  |  |  |  |  |  | Sum
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28.94088999999996
 |  |  |  |  |  |  | SQRT((1/10)*SUM(E4:E13)-C15*C15)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | /10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2.894088999999996
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sqrt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.701202221959516
Spreadsheet: 771112d1646416387-expected-output-based-on-2-criteria-and-header-sample-workbook-with-expected-outcome
Sheet: Expected Output

 | Expected Outcome 1 |  |  |  |  |  | Criteria 1 (Category) | All
 | Category | Activity | Performer Name |  |  |  | [NAME] (Month Status Yes/No) | Yes
 |  |  |  |  |  |  | [NAME] (Month header) | [NAME] (Yes/No)
 | Expected Outcome 2 (If [NAME] = All then expected output will be as below with [NAME] as Yes)
 | Category | Activity | Performer Name
Spreadsheet: 781844d1653577285-vlookup-help-to-reference-two-columns-for-lookup-book1
Sheet: Sheet1

ackley | [NAME] |  |  |  |  |  | ackley | [NAME] | y
adriance | ellen |  |  |  |  |  | adriance | ellen | a
adriance | [NAME] |  |  |  |  |  | adriance | [NAME] | b
Spreadsheet: 781417d1653314486-how-to-do-a-better-sales-forecast-sales-forecast
Sheet: Sheet1 (2)

Dates | Number of Orders | Total Sales | Days | Running DOW Average | Running Forecast | Forecast | Lower Confidence Bound | Upper Confidence Bound | Day's Event |  |  |  |  |  |  |  |  |  |  |  |  | Days | Average of Total Sales | Average of Running DOW Average | Average of Running Forecast | Average of Forecast
2022-05-01 00:00:00 | 18 | 20010 |  |  |  |  |  |  | Weekday |  |  |  |  |  |  |  |  |  |  |  |  | Saturday | 43573.25 | 48917.33333333334 | 39830.38239957921 | 61944.66726102103
 | 37 | 56159 |  |  |  |  |  |  | Weekday |  |  |  |  |  |  |  |  |  |  |  |  | Sunday | 45493.16666666666 | 41805.64583333333 | 65565.89447016743 | 98094.4780460912
 |  |  |  |  |  |  |  |  | Closed for Eid-Ul-Fitr |  |  |  |  |  |  |  |  |  |  |  |  | Monday | 41090.67333333333 | 45680.01166666667 | 38824.57792163844 | 55762.4067007335
 | 24 | 28686 |  |  |  |  |  |  | Day after Eid |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday | 46335 | 52680.25 | 41556.22025736308 | 70823.64440051228
 | 44 | 62762.4 |  |  |  |  |  |  | Last day of the week |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | 39455 | 35865.33333333334 | 36279.18952161993 | 52190.59977241134
 | 39 | 56708.12 |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  | Thursday | 63904.45 | 63523.76666666666 | 49277.48948546217 | 73969.44352883473
 | 46 | 59605.5 |  |  |  |  |  |  | Weekend |  |  |  |  |  |  |  |  |  |  |  |  | Friday | 59824.06 | 58785.41333333333 | 47066.70174765709 | 69298.18203854814
 | 62 | 92442.5 |  |  |  |  |  |  | Weekday |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 47870.94 | 49247.46541666667 | 45881.1691691513 | 69932.19839080244
 | 25 | 32600.4 |  |  |  |  |  |  | Weekday
 | 39 | 61892 |  |  |  |  |  |  | Weekday
 | 41 | 50224 |  |  |  |  |  |  | Weekday
 | 37 | 65046.5 |  |  |  |  |  |  | Last day of the week
 | 41 | 62940 |  |  |  |  |  |  | Weekend
 | 19 | 27541 |  |  |  |  | 27541 | 27541 | Weekend
 | 16 | 24027 |  |  |  |  |  |  | Weekday
 | 28 | 34512.62 |  |  |  |  |  |  | Weekday
 | 19 | 30778 |  |  |  |  |  |  | Weekday
 |  |  |  |  |  |  |  |  | Weekday
 |  |  |  |  |  |  |  |  | Last day of the week
 |  |  |  |  |  |  |  |  | Weekend
 |  |  |  |  |  |  |  |  | Weekend
Spreadsheet: 455226d1460159540-years-included-in-range-tempdaterangecalc
Sheet: Sheet1

Employee | Hire Date | Release Date | Years of Service |  | KEY | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | 2002-01-01 00:00:00 | 2003-01-01 00:00:00 | 2004-01-01 00:00:00 | 2005-01-01 00:00:00 | 2006-01-01 00:00:00 | 2007-01-01 00:00:00 | 2008-01-01 00:00:00 | 2009-01-01 00:00:00 | 2010-01-01 00:00:00 | 2011-01-01 00:00:00 | 2012-01-01 00:00:00 | 2013-01-01 00:00:00 | 2014-01-01 00:00:00 | 2015-01-01 00:00:00 | 2016-01-01 00:00:00 | 2017-01-01 00:00:00 | 2018-01-01 00:00:00 | 2019-01-01 00:00:00 | 2020-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00
Strunk {labor}, Victor | 2000-04-18 00:00:00 | 2000-10-11 00:00:00 |  |  | UNHAPPY
Patton, Trish | 2000-08-08 00:00:00 | 2003-12-24 00:00:00 |  |  | OTHER EMPLOYMENT
Lavell, Marcus J | 2000-10-09 00:00:00 | 2003-12-31 00:00:00 |  |  | LIFE CHOICE
Mays, [NAME] | 2001-02-02 00:00:00 | 2003-12-31 00:00:00 |  |  | [NAME]
Schwartz, [NAME] R | 2001-03-27 00:00:00 | 2003-12-31 00:00:00 |  |  | HEALTH (TO INCLUDE DEATH)
Lucas, Adam | 2001-04-02 00:00:00 | 2004-01-01 00:00:00 |  |  | TERMINATED
Vasey, [NAME] | 2001-06-01 00:00:00 | 2016-04-08 00:00:00
Vega, [NAME] | 2001-10-31 00:00:00 | 2003-12-31 00:00:00
Hannan, [NAME] | 2002-05-13 00:00:00 | 2003-10-23 00:00:00
Frigault, [NAME] | 2002-07-15 00:00:00 | 2003-12-31 00:00:00
[NAME], [NAME] | 2002-11-11 00:00:00 | 2006-07-12 00:00:00
McCall, [NAME] | 2002-11-19 00:00:00 | 2004-12-21 00:00:00
[NAME], [NAME] | 2003-01-13 00:00:00 | 2003-12-31 00:00:00
Repnik, [NAME] | 2003-01-13 00:00:00 | 2005-11-15 00:00:00
[NAME], [NAME] | 2003-03-04 00:00:00 | 2003-12-31 00:00:00
Mumma, Scott | 2003-04-21 00:00:00 | 2014-03-19 00:00:00
Perkins, [NAME] | 2003-04-21 00:00:00 | 2003-12-31 00:00:00
Burton, [NAME] | 2003-07-31 00:00:00 | 2003-12-31 00:00:00
Eichsteadt, Adrienne | 2003-07-31 00:00:00 | 2004-01-01 00:00:00
Sanchez, Justin | 2003-07-31 00:00:00 | 2003-12-31 00:00:00
[NAME], [NAME] | 2003-07-31 00:00:00 | 2003-12-31 00:00:00
Dinsdale, Julie | 2003-09-11 00:00:00 | 2004-02-10 00:00:00
[NAME], [NAME] | 2003-09-11 00:00:00 | 2003-12-31 00:00:00
Barrow, [NAME] | 2003-10-27 00:00:00 | 2016-04-08 00:00:00
Bump, Gracen | 2003-11-03 00:00:00 | 2005-07-11 00:00:00
[NAME], [NAME] D | 2003-11-13 00:00:00 | 2003-12-31 00:00:00
Hawkins, [NAME] | 2004-02-11 00:00:00 | 2004-12-17 00:00:00
Barrow, [NAME] | 2004-02-14 00:00:00 | 2005-12-02 00:00:00
Martin, [NAME] | 2004-02-16 00:00:00 | 2004-12-17 00:00:00
Spreadsheet: 235496d1368521066-conditional-formatting-help-me-please-288-conditional-formatting-help-me-please
Sheet: Sheet1

 | 28 | 38.9 |  | 15.45 | 52.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 42 | 87.88 |  | 77.9 | 208.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 56 | 99.3 | 0 | 0 | 0 | 6324 | 0 | 0 | 0 | 0 | 0 | 624 | 0
 | 70 | 130.89 |  | 75.5 | 188.87 | 634 | 0 | 3246 | 0 | 0 | 0 | 0 | 0
 | 84 | 65.8 | 0 | 53.15 | 80.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 98 | 20.7 | 0 | 0 | 0 | 0 | 63 | 236 | 0 | 236 | 0 | 34 | 0
 | 112 | 57.8 | 37.8 | 0 | 12.3 | 0 | 0 | 0 | 23 | 0 | 0 | 0 | 0
 | 126 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7356
 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2346 | 6 | 0
 | 154 | 4.45 | 0 | 0 | 0 | 324 | 0 | 236 | 36 | 0 | 0 | 0 | 0
 | 168 | 203.53 |  | 0 | 121.54 | 0 | 0 | 0 | 0 | 236 | 0 | 0 | 0
 | 182 | 0 | 32.5 | 0 | 0 | 0 | 0 | 0 | 2346 | 0 | 2346 | 0 | 0
 | 196 | 0 | 0 | 0 | 40.8 | 0 | 0 | 234 | 0 | 0 | 234 | 0 | 6
 | 210 |  |  | 33.8 |  | 234 |  |  | 234 | 324324 |  | 6
 | 224 | 22.85 |  | 23.5 | 15.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 238 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 6236 | 0 | 0
 | 252 | 18.55 |  | 0 | 89.91 | 6234 | 6234 | 6 | 0 | 23 | 0 | 6 | 0
 | 266 | 25.61 | 0 | 15.99 | 0 | 0 | 346 | 346 | 0 | 0 | 2346 | 0 | 375673
 | 280 | 0 | 0 | 22.15 | 14.5 | 0 | 0 | 0 | 0 | 63 | 0 | 0 | 0
 | 294 | 46.35 |  | 0 | 38.15 | 0 | 0 | 634 | 0 | 2345 | 2346 | 0 | 0
 | 308 | 21.3 | 489 | 15.15 | 566 | 76 | 2342 | 53 | 567 | 567 | 3567 | 56 | 86