tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4677edef-da5d-437c-922e-969fd2e84d61
Sheet: Sheet1

#20202 8" Gate Valves #0512-1240 6/18/04 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
rev 6/24/04 ecb
Vendor | National Waterworks | Mountain States Pipe | Hughes Supply | Ferguson Enterprises
Responded by | [NAME] | [NAME] | [NAME] | [NAME]
Price each | 563.12 | 508.95 | 495 | 451
Qty | 8 | 8 | 8 | 8
Total | 4504.96 | 4071.6 | 3960 | 3608
Make | Mueller #A2360-23 8" | Mueller #A2360-23 | US Pipe #[NAME] | Clow #6100
Leadtime | In stock | 1-2 weeks | In stock | In stock
Meet spec? | Yes | Yes | Yes | Yes
[NAME]? | No | Yes | Yes | No
Comments
Spreadsheet: 779159d1651605560-formula-to-assist-in-populating-cells-between-2-worksheets-for-help
Sheet: DO NOT MODIFY Data

Admin Manager | Course Cap | Instructor | Type | Total Lines | Hrs | AY Stipend | Course # and name | Accounts | SHP | SHP Item Type | Tuition Amt | Tuition Item Type2 | Stipend Acct. | Stipend Amt. | Notes
 |  | FA & SP: Justin St. Juliana | [NAME] | 3 | 15 | 30088 | BioEE 1610 (Ecology): ECOLOGY AND THE ENVIRONMENT | 1923104 | 1920 | 58019270001 | 10400 | 58010030002 | 1923104 | 1684.03 | 2 Endowed 3 State
Adrienne Mason (asm324) | F 325; S 325 | FA & Sp Gilbert/Helmann; [NAME]; [NAME] | End TA | 12 | 15 | 30088 | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY | A814150 | 1920 | 51018170003 | 10400 | 51018130005 | A814150 | 1684.03 | 6 F/6 S
[NAME] (glr5) | F 361; S 361 | FA: Huffaker /Kemphues   SP: [NAME] | [NAME] | 16 | 15 | 30088 | BioMG 1350 (MBG): INTRODUCTORY BIOLOGY: CELL AND DEVELOPMENTAL BIOLOGY | 1923104 | 1920 | 58019270001 | 10400 | 58010030002 | 1923104 | 1684.03 | 8F/8S          Verify budget increase for 1 TA 19-20 on 1923104
[NAME] (jeh46) | F 279; S 279 | FA & SP: Justin St. Juliana | End TA | 2 | 15 | 30088 | End BioEE 1610 (Ecology): ECOLOGY AND THE ENVIRONMENT | A814150 | 1920 | 51018170003 | 10400 | 58010030002 | A814150 | 1684.03 | 5 total Sp/Fall
[NAME] ([NAME]) | F 240 | Turgeon | [NAME] | 4 | 15 | 30088 | BioG 1140 (Plant Bio): FOUNDATIONS OF BIOLOGY (FALL) | 1923104 | 1920 | 58019270001 | 10400 | 58010030002 | 1923104 | 1684.03 | Fall only. 4 total
Adrienne Mason (asm324) |  | Campbell - dc78 | [NAME] | 8 | 20 | 40117 | BioG 1445: INTRODUCTION TO COMPARATIVE ANATOMY AND PHYSIOLOGY | 1803002 | 1920 | 58018070001 | 10400 | 58010030002 | 1803002 | 2245.35 | 10 total. 4 TA's from OUB; 1 from CAS?
Adrienne Mason (asm324) | F 432; S 432 | Sarvary | [NAME] | 24 | 20 | 40117 | BioG 1500: INVESTIGATIVE BIOLOGY LABORATORY (AY) | 1923105 | 1920 | 58019270000 | 10400 | 58010030002 | 1923105 | 2245.35 | 24 semesters 12F/12S
 |  | Campbell - dc78 | End TA | 2 | 20 | 40117 | End BioG 1445: INTRODUCTION TO COMPARATIVE ANATOMY AND PHYSIOLOGY | A824150 | 1920 | 5101827000 | 10400 | 51018230000 | A824150 | 2245.35
I-9 |  | Term |  | Course Counts |  |  | Open | [NAME] | Filled
Y |  | F |  | BioEE 1610 (Ecology): ECOLOGY AND THE ENVIRONMENT |  |  |  | 3
N |  | S |  | End BioEE 1610 (Ecology): ECOLOGY AND THE ENVIRONMENT |  |  |  | 2
M |  | AY |  | BioG 1140 (Plant Bio): FOUNDATIONS OF BIOLOGY (FALL) |  |  |  | 4
 |  |  |  | BioG 1440 (NBB): INTRODUCTORY BIOLOGY: COMPARATIVE PHYSIOLOGY |  |  |  | 12
 |  |  |  | BioMG 1350 (MBG): INTRODUCTORY BIOLOGY: CELL AND DEVELOPMENTAL BIOLOGY |  |  |  | 16
 |  |  |  | BioG 1500: INVESTIGATIVE BIOLOGY LABORATORY (AY) |  |  |  | 24
 |  |  |  | BioG 1445: INTRODUCTION TO COMPARATIVE ANATOMY AND PHYSIOLOGY |  |  |  | 8
 |  |  |  | End BioG 1445: INTRODUCTION TO COMPARATIVE ANATOMY AND PHYSIOLOGY |  |  |  | 2
 |  |  |  |  |  | Totals
Spreadsheet: 143246d1330328624-link-template-cell-to-workbook-excel-stumper
Sheet: Invoice

Invoice
 |  |  |  |  | Date:
 |  |  |  |  | Time
Name
Address
Phone #
E-mail
 | Price | Quantity | Serv. chrg. | Addtl. Equip. | Total
 | 7 | 50 | 0 | 0
 |  |  |  |  |  | Tax 3%
 |  |  |  |  |  | Total
Memo :
Spreadsheet: 052c3ddf-7624-400b-8d94-5066754d3191
Sheet: Table

#4  Awards | MSJC AWARDS
Awards | AY 07-08 | AY 08-09 | AY 09-10 | AY 10-11 | AY 11-12
click here for graph | AA/AS | AA/AS | AA/AS | AA/AS | AA/AS
Total
Gender | AA/AS | AA/AS | AA/AS | AA/AS | AA/AS | AY11-12  + 3 terms | AA/AS Gap
Female |  |  |  |  |  | 0.5975131876412961
Male |  |  |  |  |  | 0.3934438583270535
Unknown |  |  |  |  |  | 0.00904295403165034
click here for graph
Ethnicity | AA/AS | AA/AS | AA/AS | AA/AS | AA/AS |  | AA/AS Gap
White |  |  |  |  |  | 0.41
Hispanic
African American |  |  |  |  |  | 0.07
Asian |  |  |  |  |  | 0.03
Native American |  |  |  |  |  | 0.01
Filipino |  |  |  |  |  | 0.03
Pacific Islander |  |  |  |  |  | 0.01
Multi-Race |  |  |  |  |  | 0.08
Unknown |  |  |  |  |  | 0.05
click here for graph
Age | AA/AS | AA/AS | AA/AS | AA/AS | AA/AS |  | AA/AS Gap
<18 |  |  |  |  |  | 0.009118311981914092
18 & 19 |  |  |  |  |  | 0.1340617935192163
20 to 24 |  |  |  |  |  | 0.424717407686511
25 to 29 |  |  |  |  |  | 0.1455162019593067
30 to 34 |  |  |  |  |  | 0.08327053504144687
35 to 39 |  |  |  |  |  | 0.06111529766390354
40 to 49 |  |  |  |  |  | 0.09005275056518462
50 + |  |  |  |  |  | 0.05199698568198945
Unknown |  |  |  |  |  | 0
click here for graph
 | AA/AS | AA/AS | AA/AS | AA/AS | AA/AS
DSPS
Spreadsheet: 66808d1267503887-calculating-percentages-excel-file
Sheet: Sheet1

2010-02-01 00:00:00 | -1
2010-02-02 00:00:00 | 1
2010-02-03 00:00:00 | 1
2010-02-04 00:00:00 | -1
2010-02-05 00:00:00
2010-02-06 00:00:00 | 1
2010-02-07 00:00:00 | -1
2010-02-08 00:00:00
2010-02-09 00:00:00 | -1
2010-02-10 00:00:00 | 1
2010-02-11 00:00:00 | 1
2010-02-12 00:00:00
2010-02-13 00:00:00
2010-02-14 00:00:00
2010-02-15 00:00:00 | 1
2010-02-16 00:00:00
2010-02-17 00:00:00
2010-02-18 00:00:00 | 1
2010-02-19 00:00:00 | -1
2010-02-20 00:00:00
2010-02-21 00:00:00 | 1
2010-02-22 00:00:00 | 1
2010-02-23 00:00:00
2010-02-24 00:00:00
2010-02-25 00:00:00 | -1
2010-02-26 00:00:00 | 1
2010-02-27 00:00:00 | -1
2010-02-28 00:00:00 | -1
Spreadsheet: 227308d1365671524-change-value-in-list-sample
Sheet: Feuil1

2013-03-15 00:00:00 | 2013-04-12 00:00:00 | 28 |  |  | B1-A1
2013-03-28 00:00:00 | 2013-04-19 00:00:00 | 22 |  |  | B2-A2
 | 2013-04-19 00:00:00 | 41383 |  |  | B3-A2
2013-03-12 00:00:00 | 2013-04-12 00:00:00 | 31 |  |  | B4-A4
2013-03-19 00:00:00 | 2013-04-12 00:00:00 | 24 |  |  | B5-A5
2013-04-08 00:00:00 | 2013-05-03 00:00:00 | 25 | Should be |  | B6-A6
 | 2013-05-17 00:00:00 | 41411 |  |  | B7-A6
 | 2013-05-03 00:00:00 | 41397 |  |  | B8-A6
 | 2013-05-17 00:00:00 | 41411 |  |  | B9-A6
2013-04-09 00:00:00 | 2013-05-17 00:00:00 | 38 |  |  | B10-A10
2013-03-25 00:00:00 | 2013-04-16 00:00:00 | 22 |  |  | B11-A11
 | 2013-05-03 00:00:00 | 41397 |  |  | B12-A11
2013-04-02 00:00:00 | 2013-05-03 00:00:00 | 31 |  |  | B13-A13
2013-03-27 00:00:00 | 2013-04-26 00:00:00 | 30 |  |  | B14-A14
2013-03-19 00:00:00 | 2013-04-19 00:00:00 | 31 |  |  | B15-A15
Spreadsheet: 174753d1345172018-inventory-shipping-management-problem-dealing-with-2-data-sets-plantshipsample
Sheet: manufacturing

Manufacture Date | Quantity | Plant | Broken %
2012-01-01 00:00:00 | 40000 | p1 | 0.04
2012-01-14 00:00:00 | 20000 | p3 | 0.05
2012-02-22 00:00:00 | 15000 | p1 | 0.04
2012-03-29 00:00:00 | 30000 | p2 | 0.05
2012-04-02 00:00:00 | 40000 | p2 | 0.035
2012-04-14 00:00:00 | 13000 | p3 | 0.041
2012-05-15 00:00:00 | 10000 | p1 | 0.042
2012-05-29 00:00:00 | 6000 | p3 | 0.021
2012-07-23 00:00:00 | 15000 | p1 | 0.031
Spreadsheet: 705521d1606162947-need-help-please-in-distributing-a-number-across-a-date-in-multiple-cells-distribute-number
Sheet: Actual Data 1

DATE | Order_date
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200901
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200902
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
 | 20200903
Spreadsheet: 708023d1607589493-how-to-report-the-top-20-and-bottom-20-of-a-data-table-report-with-2-conditions-dashboard
Sheet: ALGERIA

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 824293d1680467225-data-flow-from-main-sheet-to-another-tab-data-flow-from-main-sheet-to-other-tab-according-to-the-name-of-the-tab-1-
Sheet: Hold

SR NO | ORDER DATE | AGEING | ORDER STATUS | CLIENT NAME | COUNTRY | CATEGORY | QTY | TOTAL order received | BALANCE order TO SOURCE | DELHI | CHD | CHENNAI | DLC | MUM CNF | PSK | TOTAL order received | BALANCE order TO SOURCE
Spreadsheet: 0da08eb6-5db5-4e89-99d6-1f9e8c0ce885
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-13 09:29:49.690000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.489 | 101.364 | 101.239 | 100.864 |  | and are added to price quote
4.625 | 100.547 | 100.422 | 100.297 | 99.922
4.5 | 100.076 | 99.951 | 99.826 | 99.451 |  | Note: | Refer To Price [NAME]
4.375 | 99.466 | 99.341 | 99.216 | 98.841 |  |  | For all Price Adjs
4.25 | 98.373 | 98.248 | 98.123
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.548 | 101.423 | 101.298 | 100.923
4 | 101.228 | 101.103 | 100.978 | 100.603
3.875 | 100.835 | 100.71 | 100.585 | 100.21
3.75 | 100.264 | 100.139 | 100.014 | 99.639
3.625 | 99.167 | 99.042 | 98.917
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-06-27 09:29:49.690000
30 DAY | 2011-07-12 09:29:49.690000
45 DAY | 2011-07-27 09:29:49.690000
60 DAY | 2011-08-11 09:29:49.690000
90 DAY | 2011-09-10 09:29:49.690000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 133453d1324402596-adding-up-numbers-in-a-column-based-on-what-is-in-another-column-in-the-same-row-sumifplastic
Sheet: Sheet1

Type | B | C | D | Amt |  | Type | Total
Plastic |  |  |  | 55 |  | Plastic |  | <<Look at this formula
Wood |  |  |  | 44 |  | Wood
Metal |  |  |  | 66 |  | Metal
Plastic |  |  |  | 88
Wood |  |  |  | 77
Spreadsheet: john_griffith__16163__1_28_02GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HU G2 | 58 | 70 | 150 | 36.3 | 53.3 | 1.61 | 2002-01-25 15:08:00
 | [NAME] | 59 | 610 | 710 | 46.9 | 54.6 | 1.88 | 2002-01-28 10:36:00
 | [NAME] | 66 | 950 | 1050 | 46.4 | 51.3 | 2.03 | 2002-01-28 10:36:00
 | [NAME] | 67 | 1160 | 1260 | 44.9 | 48.8 | 1.97 | 2002-01-28 10:36:00
 | [NAME] | 67 | 1310 | 1410 | 43.4 | 46.7 | 1.9 | 2002-01-28 10:36:00
 | HU N2 | 66 | 1380 | 1470 | 41.9 | 44.7 | 1.8 | 2002-01-28 10:36:00
 | [NAME] | 65 | 1410 | 1510 | 39.7 | 42.6 | 1.68 | 2002-01-28 10:36:00
 | HU U2 | 63 | 1410 | 1550 | 37.9 | 41.7 | 1.58 | 2002-01-28 10:36:00
 | [NAME] | 60 | 1400 | 1525 | 37.2 | 40.6 | 1.47 | 2002-01-28 10:36:00
 | [NAME] | 59 | 1400 | 1550 | 35.7 | 39.5 | 1.39 | 2002-01-28 10:36:00
 | [NAME] |  |  |  | 35.4 | 40.3 | 1.4 | 2001-11-29 15:00:00
 | HU F3 |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU H3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 811603d1672682811-vstack-function-with-named-ranges-in-a-range-book1
Sheet: Sheet1

[NAME] |  |  | Ranges
 |  |  | Range1 |  |  |  |  | Range1 |  |  | Range2 |  |  | Range3 |  |  |  |  | Range2
 |  |  | Range2 |  |  |  |  | A | B |  | C | D |  | G | H |  |  |  | Range3
 |  |  | Range1 |  |  |  |  |  |  |  | E | F |  | I | J
 |  |  | Range3
Spreadsheet: 877071d1723739473-how-do-i-reference-the-results-of-formulas-multiple-cells-cell-1-or-cell-2-or-cell-3-amateurexceller-submission-for-question
Sheet: Solution

Project EVM Calculations
Total Approved Project Budget = BAC | Value of Deliverables Planned by this Point = PV | Value of [NAME] by this Point | Actual Costs Incurred to Date = AC | Estimate to Completion (Time) = ETC
Budget at Completion (BAC) | Planned Value (PV) | Earned Value (EV) | Actual Cost (AC) | Estimate to Completion = ETC
1000000 | 1100000 | 500000 | 600000 | 500000
EVM Calculations | [NAME] | Result |  | Interpretation
Cost Variance (CV) | CV = EV-AC |  |  | Positive:  Under Budget Negative:  Over Budget
Cost Performance  Index (CPI) | CPI = EV/AC |  |  | CPI > 1 More Productive than Expected CPI < 1 Less Productive than Expected
Variance at Completion (VAC) | VAC = BAC-EAC |  |  | Difference Between BAC and Final Projected Costs
Estimate at Completion (EAC) | EAC = BAC/CPI |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + ETC (ETC is Estimated) |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + (BAC-EV) |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + (BAC-EV)/(CPI*SPI) |  |  | Project Cost if Current Trend Unchanged
Remaining Work | Remaining Work = BAC - EV
Remaining Budget | Remaining Budget = BAC-AC
To-Complete Performance Index | TCPI = (BAC – EV) / (BAC – AC) |  |  | TCPI > 1 Over Budget   TCPI < 1 Under Budget
[NAME] (SV) | SV = EV-PV |  |  | Positive:  Ahead of Schedule Negative:  Behind Schedule
Schedule Performance Index (SPI) | SPI = EV/PV |  |  | SPI > 1 Ahead of Schedule SPI < 1 Behind Schedule
Spreadsheet: 248bf35d-2e93-49eb-9856-01487b7c784f
Sheet: Sheet1

Holiday Inn Express Toronto East | 140 | 50 Estate Drive | Toronto | ON | [PHONE]
Holiday Inn Express Toronto Downtown | 196 | 111 Lombard Street | Toronto | ON | [PHONE]
Holiday [NAME] North York | 163 | 30 Norfinch Drive | Toronto | ON | [PHONE]
Holiday Inn Express Hotel & Suites | 116 | 1325 Seymour Street | North Bay | ON | [PHONE]
Spreadsheet: 40667d1239058900-is-there-any-option-for-dedcting-same-like-consolidate-consolidation
Sheet: Sheet3

2118-02-04 00:00:00 |  | values generated by consolidation |  | values copied from your sheet "dif"
202 |  | 2 |  | 2
204 |  | 2 |  | 2
206 |  | -25 |  | -25
208 |  | 125 |  | 125
210 |  | 100 |  | 100
212 |  | 200 |  | 200
214 |  | -2 |  | -2
216 |  | 0 |  | 0
218 |  | -240 |  | -240
220 |  | 0 |  | 0
222 |  | 27 |  | 27
224 |  | 11 |  | 11
226 |  | -2 |  | -2
228 |  | 0 |  | 0
230 |  | -301 |  | -301
232 |  | 0 |  | 0
234 |  | 0 |  | 0
236 |  | 80 |  | 80
238 |  | 3 |  | 3
240 |  | 0 |  | 0
242 |  | -100 |  | -100
244 |  | -27 |  | -27
246 |  | 0 |  | 0
248 |  | -2 |  | -2
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: Professions

None
Case Manager
Dental Hygienist |  | Profession: | None
Dentist
Medical Director
Nurse
Nurse Practitioner
Occupational Therapist
Other
Pharmacist
Pharmacy Technician
Physical Therapist
Physician
Physician Assistant
[NAME]
Count
Spreadsheet: 792757d1661151310-how-many-times-a-value-occurs-in-a-time-range-test-excel-forum
Sheet: Sheet1

[NAME] | Data | Recurent - 6 or more than 6 orders in January - June 2022 | Ideal - 2 or more than 2 orders in June 2022
[EMAIL] | 2022-01-06 00:00:00
[EMAIL] | 2022-05-04 00:00:00
[EMAIL] | 2022-05-03 00:00:00
[EMAIL] | 2022-05-03 00:00:00
[EMAIL] | 2022-05-03 00:00:00
[EMAIL] | 2022-05-05 00:00:00
[EMAIL] | 2022-05-04 00:00:00
[EMAIL] | 2022-05-04 00:00:00
[EMAIL] | 2022-05-04 00:00:00
[EMAIL] | 2022-05-03 00:00:00
[EMAIL] | 2022-06-28 00:00:00
[EMAIL] | 2022-06-17 00:00:00
Spreadsheet: 267201d1380008712-vlookup-function-0a215
Sheet: Armstrong, Jason

[NAME], [NAME]
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: 699359d1602563082-trying-to-return-a-large-range-of-vlookup-based-on-dates-new-budget-sheet-2-
Sheet: PP Bills

 |  | Pay Day
PP 21
 |  |  |  |  | EXPECTED RESULTS BELOW
Bills from the 20th |  |  |  |  | 21 | 0 | Citi CC (3588):
 |  |  |  |  | 21 | 0 | Chase Freedom CC (9486):
 |  |  |  |  | 21 | 50.5 | Xfinity Internet: | (6307 Discover) Auto
 |  |  |  |  | 29 | 140 | Rocky Power: | (Main Chase Checking) Auto
 |  |  |  |  | 29 | 5.35 | Apple Music: | (6307 Discover) Auto
 |  |  |  |  | 30 | 140 | Koda School: | [NAME]
Bills up to the 3rd, excluding the 3rd |  |  |  |  | 1 | 1300 | Mortgage (3755): | ([NAME]) Auto
Spreadsheet: 840008d1692359288-conditional-formatting-with-currency-or-numbers-eh_reveneue-1-aligw
Sheet: Sheet1

Revenue
No
No
No
100000
6000
No
Unsure
Unsure
Unsure
Unsure
Unsure
Unsure
Unsure
Spreadsheet: 25578d1216935092-excel-2007-alpha-sort-columns-when-linked-cells-are-sorted-client-review-chart
Sheet: Check-In Worksheet

Check-In Worksheet
 | Week of: ___________________ |  |  |  | Less Than 30 Days |  |  | From 61 - 90 Days
 |  |  |  |  | From 31- 60 Days |  |  | More than 90 Days
 | Client Name |  | Intake Data | Monday |  | Tuesday | Wednesday |  | Thursday |  | Friday |  |  |  | Days Here
 |  |  |  | AM | PM | AM | AM | PM | AM |  | AM
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
26
Spreadsheet: 849349d1699879692-how-do-i-sum-the-quantity-of-a-column-from-another-sheet-using-1-criteria-excel20
Sheet: Sheet1

 |  | Data set A |  |  | Data set B
 |  |  |  |  |  | Quantity | Model
 | Blue |  |  |  | Blue | 10 | EST
 | Red |  |  |  | Blue | 8 | EST
 | Yellow |  |  |  | Blue | 1
 | Black |  |  |  | Red | 1 | XOM
 |  |  |  |  | Red | 2 | EST
 |  |  |  |  | Yellow | 5 | XL
 |  |  |  |  | Black | 9 | XL
Spreadsheet: 823509d1679995467-complex-split-formula-to-split-column-to-different-columns-sample-split
Sheet: sample (2)

POGB0006075-MB2 |  | MB2
POGB0006106-MB2 |  | MB2
[NAME] |  | MB1
POGB0005754-MB2 |  | MB2
POGB0005847-MB2 |  | MB2
POGB0006120-MB2 |  | MB2
POGB0006110-MB2 |  | MB2
POTR0004601-MB1 .POTR0004724-MB1 ,POTR0004723-MB1 .POTR0004719-MB1 ,POTR0004721-MB1 .POTR0004720-MB1 .POT [NAME] |  | MB1 .POTR0004724 | MB1 ,POTR0004723 | [NAME] | MB1 ,POTR0004721 | MB1 .POTR0004720 | MB1 .POT [NAME] | MB1.POTR0004671 | MB1
POGB0005983-MB2,POGB0005893-MB2,POGB0005975-MB2.POGB0005968-MB2.PO GB0005970-MB2.POGB0005961-MB2.POG B0005969-MB2.POGB0005965-MB2.POGB 0005966-MB2.POGB0005964-MB2.POGB0 005967-MB2.POGB0005963-MB2.POGB0005948-MB2 |  | MB2,POGB0005893 | MB2,POGB0005975 | MB2.POGB0005968 | MB2.PO GB0005970 | MB2.POGB0005961 | MB2.POG B0005969 | MB2.POGB0005965 | MB2.POGB 0005966 | MB2.POGB0005964 | MB2.POGB0 005967 | MB2.POGB0005963 | MB2.POGB0005948 | MB2
POGB0006088-MB2 |  | MB2
POTR0004774-MB1 |  | MB1
POTR0004741-MB1 |  | MB1
POGB0006072-MB2 |  | MB2
POGB0005755-MB2 |  | MB2
POTR0004789-MB1 |  | MB1
POTR0004790-MB1 |  | MB1
POGB0006086-MB2 |  | MB2
POGB0006113-MB2 |  | MB2
POTR0004556-MB1 |  | MB1
[NAME] |  | MB1
POTR0004684-MB1 |  | MB1
POTR0004755-MB1 |  | MB1
POTR0004797-MB1 |  | MB1
POTR0004646-MB1 |  | MB1
POTR0004822-MB1 |  | MB1
POGB0006129-MB2.POGB0006130-MB2 |  | MB2.POGB0006130 | MB2
POTR0004823-MB1 |  | MB1
[NAME] |  | MB1
POTR0004836-MB1 |  | MB1
[NAME] |  | MB1
POGB0006285-MB2 |  | MB2
POGB0006277-MB2 |  | MB2