tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329911d1404455871-validation-list-based-on-another-cell-formula-only-issuexcel_formula-added
Sheet: Static Data

STATIC DATA
REGIONS |  | CITY
ANZ | APAC | Auckland | New Zealand | c5:c13
ASEAN | APAC | Sydney | Australia
HKT | APAC | Melbourne | Australia
INDIA | APAC | Delhi | India
KOREA | APAC | Mumbai | India
 |  | Seoul | Korea
 |  | Hong Kong | Hong Kong
 |  | Singapore | Singapore
 |  | Kuala Lumpur | Malaysia
SUB REGIONS
Malaysia | ASEAN
Singapore | ASEAN
Australia | ANZ
New Zealand | ANZ
India | INDIA
Hong Kong | HKT
Korea | KOREA
Spreadsheet: 141387d1329242048-lookup-or-if-min-min-or-lookup
Sheet: Sheet1

 |  |  | Aldi | per KG |  |  | Jumbo | per KG |  |  | [NAME] | per KG |  |  | Market
 |  | Cheapest |  | p/ Liter | QTY | Brand |  | p/ Liter | QTY | Brand |  | p/ Liter | QTY | Brand |  | notes
Can/Bottles
 | Broth (Beef) | none
 | Broth (Chicken) | Jumbo |  |  |  |  | 0.79 | 2.323529411764706 | 340ml | Bleech
 | [NAME] | none |  |  |  |  | 0.97
 | Corn | Jumbo | 1 | 2.857142857142857 | 350gr |  | 0.42 | 1.4 | 300ml | ES | 0.99 | 2.911764705882353 | 340gr | AH Bio/Puur
 | Corn Beef | Jumbo | 2.5 | 11.73708920187793 | 213gr |  | 0.97 | 3.233333333333333 | [NAME] | Lybies
 | Fruit Cocktail | AH |  |  |  |  | 0.89 | 1.78 | 500ml | Falani-fresh line | 0.99 | 1.207317073170732 | [NAME] | ES
Spreadsheet: 681372d1591534075-reopened-lining-up-row-of-numbers-with-column-of-numbers-using-index-match-vlookup-question-maxifs-answer
Sheet: Sheet1

LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2 |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
1 | 3 |  |  |  |  |  |  |  | 3 |  |  |  | 3
1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
1 | 5
1 | 6 |  |  |  |  |  |  |  |  |  |  | 6
1 | 7 |  |  |  |  |  |  |  |  |  | 7
1 | 8
1 | 9
1 | 10
 |  |  |  |  |  |  |  |  | VLOOKUPS
LIST 1 | LIST 2 | LIST 3 | LIST 4 | LIST 5 | LIST 6 | LIST 7 | LIST 8 | LIST 9 | LIST 10 | LIST 11 | LIST 12 | LIST 13 | LIST 14 | LIST 15 | LIST 16
1 | 1 | 3 | 2 | 7 | 6 | 3 | 2 | 4
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
Spreadsheet: 881838d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills
Sheet: Card & Debt 2023

 | Card & Debt Management
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | House |  |  |  |  |  |  |  |  |  |  | 947.47 | 0 | 947.47 | 947.47 | Total Remaining |  |  | House Total estimate Jan 23 £18000
 | Card | Item | Cost
 | G sant | Rug | 350 | 0 | 0 | 0 | 0 | 0 | 150 | 150 | 50 | 0 | 0 | 0 | 0
 | [NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | jacks |  | 0 | 0 | 0 | 0 | 0 | 0 | 400 | 100 | 100 | 100 | 0 | 50 | 100
 | gavs |  | 0 | 0 | 0 | 0 | 0 | 0 | 90 | 125 | 185 | 90 | 0 | 145 | 100
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | virgin | Sofa | 4150 | 0 | 0 | 0 | 0 | 0 | 140 | 120 | 270 | 500 | 0 | 640.47 | 600
 | gavs | dog trainer | 90 | 0 | 0 | 0 | 0 | 0 | 0 | 25 | 65 | 0 | 0 | 0 | 0
 | nan/dad | boiler | 1400 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] from kl |  | 295 | 0 | 0 | 0 | 0 | 0 | 90 | 75 | 85 | 40 | 0 | 5 | 0
 | Second Hol |  | 437.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 107 | 0 | 107 | 147.47
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other |  |  |  |  |  |  |  |  |  | £100 don’t pay off credit card, leave in bills
 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  | santander pot
 | Card | Item | Cost |  |  |  |  |  |  |  | 150 leave in bills |  |  |  |  | Total Remaining
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | costco | 50
 | [NAME] | fuel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | wetherby | 30
ITALY EXTRAS | Sant | bistro |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | arnolfo |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME]
 |  | phevos
 |  | airport
 |  |  | 0
 |  |  | 0
 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 | TAKE OFF EACH MONTH AND PUT ONTO RECEIPTS WHERE POSSIBLE TO PAY OFF SANTANDER
 | Playstation
 | 42.46 | cheques | [NAME]
 | 250 | playstation | half
 | 28.44 | [NAME] | gavin
 | 150
Spreadsheet: mark_taylor__24799__Europe - ticker layout
Sheet: Swiss Power

Ticker Item | Update Frequency | Source | Input Responsibility | Ticker Text | Layout concept for Linked Page |  |  |  | Contact(s)
1 | Daily | exchange (public domain) | Swiss Power Desk | Swiss Power Update | SWEP (Swiss Electricity Price Index) | 28.10.99:  33,1858 CHF/MWh |  |  | [NAME],  [NAME]
 |  |  |  | " | CEPI (Central European Power Index) | 29.10.99:  20,6679 EUR/MWh
2 | Hourly | Internal:  [NAME] (Daily temp feed.) - confirm original source | < TBD > | Swiss Weather | Zurich current temp. | 10 | degrees C
3
Spreadsheet: 693885d1599204294-sum-of-multiple-cells-based-on-name-in-another-cell-on-the-same-row-book7x
Sheet: Sheet1

Name | $[NAME] |  |  |  |  | Name | Total
Name1 | 100 |  | Name1 |  |  | Name1 | 400
Name3 | 50 |  | [NAME] |  |  | Name3 | 350
[NAME] | 300 |  | Name3 |  |  | [NAME] | 350
Name1 | 200
Name3 | 100 |  | [NAME] |  |  | PQ Solution
Name1 | 100
Name3 | 200
[NAME] | 50
Raw Data
Spreadsheet: 743759d1628701534-conditional-format-shading-on-variable-cf-on-games
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Want
 | Multi-Game Tracker |  |  |  |  | Task 1 # | Task 2 # |  |  | Multi-Game Tracker |  |  |  |  | Task 1 # | Task 2 #
 | Game |  |  |  | Type | H | XBH |  |  | Game |  |  |  | Type | H | XBH
 | 1 | 2 | 1 |  | Amount | 6 | 3 |  |  | 1 | 2 | 1 |  | Amount | 6 | 3
 | 2 | 3 | 3 |  |  |  |  |  |  | 2 | 3 | 3
 | 3 | 1 | 1 |  | # Games | 3 |  |  |  | 3 | 1 | 1 |  | # [NAME]: | 3
 | 4 |  |  |  |  |  |  |  |  | 4
 | 5 |  |  |  |  |  |  |  |  | 5
 | 6 |  |  |  |  |  |  |  |  | 6
 | Total: |  |  |  |  |  |  |  |  | Total:
 | Left: |  |  |  |  |  |  |  |  | Left:
Spreadsheet: benjamin_rogers__1232__Combine-Cycle model
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
After Tax Free Cash Flow:
Net Income + Depreciation
- Principal Payments
- CapEx or Working Capital Needs |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Free Cash Flow to Equity
NPV @ 12%
Spreadsheet: 682524d1592173399-vlookup-with-wildcard-not-working-example1750-1-
Sheet: SHEET1

DATE | Description | Money in | Money Out | MONEY IN REASON | NEW FORMULA | PREVIOUS FORMULA (WHICH WORKS)
2020-03-30 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 200
2020-03-20 00:00:00 | CARD PAYMENT TO WILKO RETAIL LIMITED,1.50 GBP, RATE 1.00/GBP ON 18-03-2020 |  | 1.5
2020-03-19 00:00:00 | CARD PAYMENT TO SELCO TRADING CTR,64.56 GBP, RATE 1.00/GBP ON 17-03-2020 |  | 50
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO THAMES WATER REF 123456789, MANDATE NO 0080 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO MORTGAGES 999999A, MANDATE NO 0085 |  | 150
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO BG SERVICES REF 987654159D, MANDATE NO 0079 |  | 30
2020-03-16 00:00:00 | DIRECT DEBIT PAYMENT TO REF GHTY7415, MANDATE NO 0059 |  | 300
2020-03-11 00:00:00 | ARRANGED OVERDRAFT USAGE FEE |  | 20
2020-02-19 00:00:00 | FASTER PAYMENTS RECEIPT RAJ | 3000
2020-02-19 00:00:00 | MAINTAINING THE ACCOUNT - MONTHLY FEE |  | 5
 | CARD PAYMENT TO THAMES WATER,17.76 GBP, RATE 1.00/GBP ON 23-03-2020 |  | 17.76
 | CARD PAYMENT TO THAMES WATER,73.78 GBP, RATE 1.00/GBP ON 22-01-2020 |  | 73.78
 | CARD PAYMENT TO THAMES WATER,618.49 GBP, RATE 1.00/GBP ON 15-01-2020 |  | 618.49
 | CARD PAYMENT TO THAMES WATER,16.35 GBP, RATE 1.00/GBP ON 07-11-2019 |  | 16.35
 | CARD PAYMENT TO VIRGIN MEDIA PYMTS,89.98 GBP, RATE 1.00/GBP ON 24-09-2019 |  | 89.98
Spreadsheet: 101576d1299683250-calculate-age-in-months-excel
Sheet: Sheet2

 |  | Todays Date | Due Date | How Old in months
 |  | 2011-03-09 00:00:00 | 2011-05-04 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-05-04 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-05-08 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-05-08 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-04-01 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-04-01 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-03-23 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-04-15 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-04-29 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-04-29 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-04-28 00:00:00
 |  | 2011-03-09 00:00:00 | 2011-01-01 00:00:00
Spreadsheet: 689822d1596677798-conditional-formatting-formula-for-multiple-conditions-matching-ninja_beth
Sheet: Sheet1

Person | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 | Date of Test
Person A | x |  |  |  |  | 2020-07-01 00:00:00
Person B |  | x |  |  |  | 2020-07-03 00:00:00 |  | We are testing these employees for Covid-19.  Some employees work in multiple departments.
Person C |  |  | x | x |  | 2020-07-07 00:00:00
Person D |  |  |  |  | x | 2020-07-08 00:00:00 |  | We want to know, if there has been a  test in the same department within the last 14 days.
Person E |  |  |  |  |  | 2020-07-10 00:00:00
Person F | x |  | x | x |  | 2020-07-11 00:00:00 |  | We want to highlight the location if there is an instance that matches the location, but only in the last 14 days.
Person G |  |  | x |  |  | 2020-07-14 00:00:00
Person H |  |  | x |  | x | 2020-07-14 00:00:00 |  | I have highlighted what I want it to look like.
Person I |  |  |  |  |  | 2020-07-16 00:00:00
Person J |  | x |  |  | x | 2020-07-19 00:00:00
Expected
Person | Location 1 | Location 2 | Location 3 | Location 4 | Location 5
Person A | x
Person B |  | x
Person C |  |  | x | x
Person D |  |  |  |  | x
Person E
Person F | x |  | x | x
Person G |  |  | x
Person H |  |  | x |  | x
Person I
Person J |  | x |  |  | x
Spreadsheet: joe_parks__14610__POSTIONTRAX_NOV
Sheet: J-V_SWAP

 | SELL |  |  |  | BUY
BEGINNING |  |  |  |  |  |  |  |  |  |  | MTM
 | 107 | 3.17 |  |  | 107 | 3.185 |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  |  |  |  |  |  |  | NEW DEALS
 |  |  |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  | 7.5
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 680970d1591280423-return-unique-values-from-list-as-a-comma-separated-string-example_list_to_unique_string
Sheet: Sheet1

Condition | Values
New | 1
Old | 2
New | 3
New | 4
Old | 4
New | 4
New | 3
New | 6
New | 7
New | 8
New | 8
 | Desired result: |  | 1, 3, 4, 6, 7, 8
Spreadsheet: 120657d1315429030-month-look-up-in-reverse-order-book1
Sheet: Sheet1

 | Month | 6
 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
Sales | 144 | 144 | 144 | 144 | 144 | 144 | 144 | 200 | 200 | 200 | 200 | 200
Variable | 23 | 23 | 23 | 23 | 23 | 23 | 23 | 50 | 50 | 50 | 50 | 50
 | Current month | Prior month
Spreadsheet: 539656d1506323578-extracting-values-to-new-tab-book2
Sheet: Sheet2

Parameter 1 | Parameter 2 | Parameter 3 | Parameter 4 | Parameter 5
Spreadsheet: 01fb1f93-59a2-475e-b90a-a338338b72df
Sheet: K-12; 7 day week

Grade Group - K-12 |  |  | Menu Name:
 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  |  |  |  |  | Weekly Requirement Met True/False or Yes/No |  |  | Decimal Equivalents
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/8 Cup | 0.125
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/4 Cup | 0.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/8 Cup | 0.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1/2 Cup | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5/8 Cup | 0.625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/4 Cup | 0.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7/8 Cup | 0.875
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Cup | 1
Grains (1 Oz Eq per day)  (12.5-14 Oz Eq per week) |  | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq | Oz Eq WGR | Total OzEq Grain | Total OzEq WGR | % WGR | ≥ 50% Yes/ No | Wkly Grain Total (Grain + M/MA)
Daily Req Met Y/N
M/MA (NOT required) (Counts toward weekly grain total) |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | OzEq M/MA |  | Total OzEq M/MA
Fruit & Veg (1/2 cup per day) (3 1/2 cups per week) |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Cups of Fruit/Veg |  | Total Cups F&V
Daily Req Met Y/N
[NAME] (1 Cup per day) (7 cups per week) (White Skim or 1%; [NAME]) |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Cups of Milk |  | Total Cups of Milk
Daily Req Met Y/N
Spreadsheet: 287720e0-d6bb-4204-ab9e-2f13f8affc69
Sheet: Sheet1

CPM Worker Status Form
Camp/ Program Name:
Dates of CPM:
Primary Contact Name:
[NAME] [NAME]:
Primary Contact Phone #:
 | First Name | Last Name | Type | [NAME] | [NAME] | [NAME] | [NAME] | System Waiver | Child Protection Training | Staff & Vol Contract
- | First | Example | Volunteer- CPM | X | X | X | X | X | X | X
- | Second | Example | Volunteer- CPM /TAMIU Student | X | X | X | X | X | X | X
- | Third | Example | Employee-Service Contract | - | X | X | X | X | X | X
- | Fourth | Example | Employee- Independent Contract | - | X | X | X | X | X | X
- | Fifth | Example | Employee- CPM (HR) | - | X | X | X | X | X | X
- | Sixth | Example | Employee- TAMIU Employee | - | X | - | - | - | X | X
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
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Completed ELECTRONIC roster must be submitted to CE 2 weeks prior to the start of camp or program.
All Original Forms must be delivered to the Office of Continuing Education.
Any changes to roster must be submited via email to [EMAIL].
Keep copies of all documents until camp has been cleared at the end of fiscal year.
Spreadsheet: 134867d1325687116-excel-2007-conditional-formatting-excel-export-test-sheet2
Sheet: Sheet1

ORDER NUMBER | CUSTOMER | CTY | FROM | INCO | PORT OF DESTINATION | MODE OF TRANSPORT | PGI | LD | ETD | ETA | BL | DOC REQ | RECEIVED | Forwarder | Comments | PO NUMBER | Data
 |  | BRAZIL | HV | CPT | SANTOS | air | 2011-12-12 00:00:00 | 2012-01-05 00:00:00 |  |  |  |  |  | CLEVE |  |  | SEA
 |  |  |  |  |  | Sea |  |  |  |  |  |  |  |  |  |  | AIR
 |  |  |  |  |  | AIR |  | 2012-01-05 00:00:00 |  |  |  |  |  |  |  |  | ROAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PICK-UP
 | [NAME] BEFORE DOC REQUESTS
 | BRAZIL ORDERS: DRAFT BL IS REQUESTED PLEASE REMIND FORWARDERS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Answer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You don't need the IF in the condition - lets say we are talking about Cells C2 and D2 being empty - then the condition would be
 |  |  |  |  |  |  | Sea | =IF(G2="SEA"; (I2<=TODAY()-6)) |  |  |  |  |  |  | =AND(isblank(c2),isblank(d2))
 |  |  |  |  |  |  | Air | =IF(G2="Air"; (I2<=TODAY());"no")
 |  |  |  |  |  |  | Road |  |  |  |  |  |  |  | IF both C2 and D2 are blank, the condition is true, so the conditional formatting kicks in.
 |  |  |  |  |  |  | Pickup
Spreadsheet: 84164d1284149973-repeating-data-across-worksheets-book1
Sheet: Sheet1

45 | 14 | 10 | 48 | 11 | 97 | 38 | 5 | 71 | 34 | 14 | 38
9 | 73 | 28 | 98 | 12 | 91 | 36 | 39 | 27 | 29 | 53 | 30
71 | 84 | 35 | 19 | 24 | 21 | 79 | 27 | 72 | 77 | 40 | 49
9 | 8 | 91 | 22 | 82 | 16 | 5 | 84 | 9 | 10 | 13 | 12
98 | 41 | 1 | 44 | 83 | 29 | 47 | 44 | 11 | 66 | 92 | 78
Spreadsheet: 47747d1246927721-nested-if-statement-to-recognize-root-codes-sumif_halp
Sheet: Actuals

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | 01 | GJ | 1/2/2009 |  | 300 |  | 110
01 | 02 | GJ | 3/2/2009 |  | 500 |  | 210
01 | 03 | GJ | 1/2/2009 |  | 100 |  | 120
01 | 04 | GJ | 1/2/2009 |  | 400 |  | 120
01 | 05 | GJ | 1/2/2009 |  | 300 |  | 110
01 | 06 | GJ | 1/2/2009 |  | 200 |  | 130
01 | 07 | GJ | 4/2/2009 |  | 5000 |  | 310
01 | 08 | GJ | 1/2/2009 |  | 2342 |  | 220
01 | 09 | GJ | 1/2/2009 |  | 352 |  | 220
01 | 10 | GJ | 1/2/2009 |  | 5235 |  | 210
01 | 11 | GJ | 1/2/2009 |  | 6346 |  | 240
01 | 12 | GJ | 1/2/2009 |  | 345 |  | 240
01 | 13 | GJ | 3/2/2009 |  | 345 |  | 250
01 | 14 | GJ | 1/2/2009 |  | 345 |  | 210
01 | 15 | GJ | 1/2/2009 |  | 234 |  | 240
01 | 16 | GJ | 1/2/2009 |  | 5436 |  | 210
01 | 17 | GJ | 1/2/2009 |  | 234 |  | 220
01 | 18 | GJ | 1/2/2009 |  | 23564 |  | 340
01 | 19 | GJ | 1/2/2009 |  | 25324 |  | 350
01 | 20 | GJ | 4/2/2009 |  | 53253 |  | 320
01 | 21 | GJ | 1/2/2009 |  | 53 |  | 310
01 | 22 | GJ | 1/2/2009 |  | 352 |  | 320
01 | 23 | GJ | 1/2/2009 |  | 53256 |  | 310
01 | 24 | GJ | 1/2/2009 |  | 6342 |  | 310
01 | 25 | GJ | 1/2/2009 |  | 234 |  | 110
01 | 26 | GJ | 1/2/2009 |  | 5 |  | 130
01 | 27 | GJ | 1/2/2009 |  | 24 |  | 120
01 | 28 | GJ | 1/2/2009 |  | 234235 |  | 110
01 | 29 | GJ | 1/2/2009 |  | 254352 |  | 130
01 | 30 | GJ | 1/2/2009 |  | 5235 |  | 120
01 | 31 | GJ | 1/2/2009 |  | 23525 |  | 120
01 | 32 | GJ | 1/2/2009 |  | 534 |  | 110
Spreadsheet: 856523d1705737357-date-challenge-transform-effective-date-range-to-day-time-series-date-challenge-transform-to-time-series
Sheet: Sheet1

Source data:
 | Dep time | Arr time | Day | Effective | Elapsed Time | Flight No
 | 18-30 | 20-30 | 5 | 16.04-10.05 | 02-00 | AB-352
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982
Desired output:
 |  | Arr time | Day | Effective | Elapsed Time | Flight No | Date
 | 18-30 | 20-30 | 5 | 16.04-10.05 | 02-00 | AB-352 | 2024-04-19 00:00:00
 | 18-30 | 20-30 | 5 | 16.04-10.05 | 02-00 | AB-352 | 2024-04-26 00:00:00
 | 18-30 | 20-30 | 5 | 16.04-10.05 | 02-00 | AB-352 | 2024-05-03 00:00:00
 | 18-30 | 20-30 | 5 | 16.04-10.05 | 02-00 | AB-352 | 2024-05-10 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-02 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-04 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-05 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-07 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-09 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-11 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-12 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-14 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-16 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-18 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-19 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-21 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-23 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-25 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-26 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-28 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2024-12-30 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2025-01-01 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2025-01-02 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2025-01-04 00:00:00
 | 07-40 | 09-20 | 1346 | 01.12-06.01 | 02-00 | CD-982 | 2025-01-06 00:00:00
Spreadsheet: 775655d1649246490-concatenatex-and-bulleted-list-bam-example
Sheet: Base Data

Area | Task | Month Due
Documentation | Do doc task A | 2022-04-30 00:00:00
Documentation | Do doc task A | 2022-04-30 00:00:00
Documentation | Do doc task B | 2022-04-30 00:00:00
Documentation | Do doc task C | 2022-04-30 00:00:00
Documentation | Do doc task D | 2022-05-31 00:00:00
Documentation | Do doc task E | 2022-05-31 00:00:00
Documentation | Do doc task F | 2022-05-31 00:00:00
Documentation | Do doc task G | 2022-05-31 00:00:00
Security | Do security task 1 | 2022-04-30 00:00:00
Security | Do security task 1 | 2022-04-30 00:00:00
Security | Do security task 2 | 2022-04-30 00:00:00
Security | Do security task 3 | 2022-04-30 00:00:00
Software | Do software task 1 | 2022-04-30 00:00:00
Software | Do software task 2 | 2022-06-30 00:00:00
Software | Do software task 3 | 2022-06-30 00:00:00
Software | Do software task 4 | 2022-06-30 00:00:00
Software | Do software task 5 | 2022-06-30 00:00:00
Software | Do software task 5 | 2022-05-31 00:00:00
Spreadsheet: 737401d1624395207-help-with-index-and-match-functions-that-act-dynamically-example
Sheet: Protocol Build & Maintenance

 | PROTOCOL "BUILD" COSTS
 | Minimum Protocols Required for Prescriptions Renewals |  |  |  | 250
 | Hours PER PROTOCOL saved in Achieving Clinical Consensus |  |  |  | 10
 | Hours PER PROTOCOL for Site IT Staff to Build |  |  |  | 10
 | Total Hours to Build Minimum Set of Refill Protocols
 | Cost Per IT Hour |  |  |  | 100
 | Total Cost to Build Minimum Set of Refill Protocols
 | [NAME] COSTS
 | Minimum Protocols Required for Prescriptions Renewals
 | Hours of IT Maintenance Annually PER PROTOCOL |  |  |  | 10
 | Total Annual Hours to Maintain Minimum Set of Refill Protocols
 | Cost Per IT Hour
 | Total Cost to Build Minimum Set of Refill Protocols
 | First-Year Cost to Build and Maintain Protocols
 | Ongoing Annual Cost to Maintain Protocols