tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1b9f30e1-4502-4a95-9d4f-ce4afbf3ad29
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: |  |  | 2012-08-07 09:36:16.560000
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 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.466 | 101.341 | 101.216 | 100.841
3.75 | 101.318 | 101.193 | 101.068 | 100.693 |  | Note: | Refer To Price [NAME]
3.625 | 100.906 | 100.781 | 100.656 | 100.281 |  |  | For all Price Adjs
3.5 | 100.256 | 100.131 | 100.006 | 99.381
3.375 | 99.365 | 99.24 | 99.115 | 98.49
3.25 | 98.401 | 98.276 | 98.151 | 97.526
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 101.996 | 101.871 | 101.746 | 101.371
3.25 | 101.569 | 101.444 | 101.319 | 100.944
3.125 | 101.269 | 101.144 | 101.019 | 100.644
3 | 100.918 | 100.793 | 100.668 | 100.293
2.875 | 100.308 | 100.183 | 100.058 | 99.433
2.75 | 99.649 | 99.524 | 99.399 | 98.774
 |  |  |  |  |  | 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 | 2012-08-21 09:36:16.560000
30 DAY | 2012-09-05 09:36:16.560000
45 DAY | 2012-09-20 09:36:16.560000
60 DAY | 2012-10-05 09:36:16.560000
90 DAY | 2012-11-04 09:36:16.560000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 845356d1696889208-open-office-rotate-name-in-column-list-to-bottom-when-used-in-another-column-ot-rotating-list
Sheet: Sheet1

Opening | Base: | Assignment |  |  | FT Staff List | PRN
2023-01-01 00:00:00 | South |  |  |  | Employee 1 | PRN 1
2023-01-02 00:00:00 | West |  |  |  | Employee 2 | PRN2
2023-01-04 00:00:00 | West |  |  |  | Employee 3 | PRN3
2023-01-05 00:00:00 | West |  |  |  | Employee 4 | PRN4
2023-01-20 00:00:00 | North |  |  |  | Employee 5 | PRN5
2023-01-21 00:00:00 | North |  |  |  | Employee 6 | PRN6
2023-01-22 00:00:00 | West |  |  |  | Employee 7 | PRN7
2023-01-28 00:00:00 | West |  |  |  | Employee 8
2023-01-13 00:00:00 | North |  |  |  | Employee 9
2023-01-15 00:00:00 | South |  |  |  | Employee 10
2023-01-20 00:00:00 | South |  |  |  | Employee 11
 |  |  |  |  | Employee 12
 |  |  |  |  | Employee 13
 |  |  |  |  | Employee 14
 |  |  |  |  | Employee 15
 |  |  |  |  | Employee 16
 |  |  |  |  | Employee 17
 |  |  |  |  | Employee 18
 |  |  |  |  | Employee 19
 |  |  |  |  | Employee 20
 |  |  |  |  | Employee 21
Spreadsheet: 0938da54-7c45-4181-ac3f-87d503feeb93
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-01-12 09:43:17.700000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.318 | 101.318 | 101.193 | 100.693 |  | and are added to price quote
5.125 | 100.77 | 100.77 | 100.645 | 100.145
5 | 100.402 | 100.402 | 100.277 | 99.777 |  | Note: | Refer To Price [NAME]
4.875 | 99.556 | 99.556 | 99.431 | 98.931 |  |  | For all Price Adjs
4.75 | 99.04299999999999 | 99.04299999999999 | 98.91799999999999
4.625 | 97.899 | 97.899 | 97.774
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.75 | 101.75 | 101.75 | 101.625 | 101.125
4.625 | 100.93 | 100.93 | 100.805 | 100.305
4.5 | 100.743 | 100.743 | 100.618 | 100.118
4.375 | 100.471 | 100.471 | 100.346 | 99.84599999999999
4.25 | 99.99799999999999 | 99.99799999999999 | 99.87299999999999
 |  |  |  |  |  | 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: |  |  | 2011-01-12 09:43:17.700000
 |  |  |  |  |  | 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-01-26 09:43:17.700000
30 DAY | 2011-02-10 09:43:17.700000
45 DAY | 2011-02-25 09:43:17.700000
60 DAY | 2011-03-12 09:43:17.700000
90 DAY | 2011-04-11 09:43:17.700000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 87589d1287481046-sort-order-ranking-for-miltiple-columns-of-data-sample
Sheet: Sheet1

42 | 7 | 20 | 5 | 452 | 1
31 | 8 | 20 | 4 | 394 | 2
19 | 14 | 2 | 17 | 112 | 3
9 | 19 | 3 | 15 | 85 | 4
16 | 16 | 13 | 10 | 73 | 5
55 | 2 | 13 | 12 | 58 | 6
28 | 10 | 6 | 13 | 22 | 7
10 | 18 | 1 | 18 | 19 | 8
22 | 13 | 3 | 16 | 17 | 9
18 | 15 | 5 | 14 | 15 | 10
51 | 3 | 17 | 7 | 12 | 11
29 | 9 | 19 | 6 | 11 | 12
22 | 12 | 15 | 8 | 10 | 13
93 | 1 | 88 | 1 | 7 | 14
27 | 11 | 13 | 11 | 7 | 15
10 | 17 | 1 | 19 | 6 | 16
44 | 6 | 15 | 9 | 5 | 17
50 | 4 | 39 | 2 | 4 | 18
47 | 5 | 21 | 3 | 2 | 19
7 | 20 | 0 | 20 | 1 | 20
Spreadsheet: 158071d1337968615-error-of-n-a-when-summing-up-columns-using-index-and-match-for-multiple-worksheets-sales-report
Sheet: all 

CT User | Rank | Reg | BO | Name | Title | Score | Exist | Rank | NEW | Rank | Referrals | Rank | New Lines | Rank | Flights | Rank
SJUDGE |  | NE | 22 | SJUDGE | PB/C
MBOT |  | NE | 55 | MBOT | PB/C
DCATE |  | NE | 66 | DCATE | PB/C
DTABOT |  | NE | 56 | DTABOT | PB2
Spreadsheet: b88c7609-0c84-4255-96a0-88177e1871ef
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
9861 | Test | 9861 | Luxol Fast Blue/Cresyl Violet (LFB/CV) Stain for [NAME] and Nerve Cells | Luxol Fast Blue/Cresyl Violet ST | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Thursday 7 a.m. | 3 days/Paraffin 2 days, Fixative 3 days | 7 days | 1 | 88313 |  |  |  |  | Rochester
9861 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9861 | Result | 9861 | Luxol Fast Blue/Cresyl Violet ST | Luxol Fast Blue/Cresyl Violet ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10825-8
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -48871 | -49601
2 | -49187 | -48829
3 | -103126 | -102275
4 | -123391 | -123241
5 | -36313 | -35878
6 | -49883 | -49878
7 | -66975 | -66878
8 | -71064 | -70456
9 | -40759 | -40774
10 | -6061 | -6000
11
12 | -34067 | -35000
13 | -34846 | -35000
14 | -34680 | -35000
15 | -20312 | -20000
16 | -29600 | -29500
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -33241.41
2002-01-16 00:00:00
CBS Volume
 |  |  | -18079
Spreadsheet: 100359d1298724181-how-to-make-a-variable-range-in-formula-example
Sheet: Sheet1

Data A Entry
Num | Detail 1 | [NAME] 2 | Detail 3 | [NAME] 4 | Detail 5 | [NAME] 6
A1 | x | 1 | y | 2
A2 | y | 4
A3 | y | 1 | z | 5
A4 | x | 3 | y | 4 | z | 2
Data B Entry
Num | Detail 1 | [NAME] 2 | Detail 3 | [NAME] 4 | Detail 5 | [NAME] 6
B1 | A2 |  | m | 3 | n | 2
B2 | A1 |  | n | 3
B3 | A1 |  | m | 1
B4 | A4 |  | n | 2 | m | 4
B5 | A3 |  | n | 5
Summary from data entry
Data B | B1 | B2 | B3 | B4 | B5
Data A | A2 | A1 | A1 | A4 | A3
x |  | 1 | 1 | 3
y | 4 | 2 | 2 | 4 | 1
z |  |  |  | 2 | 5
m | 3 |  | 1 | 4
n | 2 | 3 |  | 2 | 5
Spreadsheet: 741356d1626985071-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-extract-values-kvs-mod
Sheet: OUTPUT

 |  |  |  | Section I |  |  | Section II |  |  | Section III
S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | NOTE
 |  |  |  |  |  |  |  |  |  |  |  |  | Further sections can be extended without change of formula
Spreadsheet: 145066d1331292815-date-problems-server-back-up
Sheet: Back-Up Dates

 |  |  | SERVER BACK UP DATES
 | Monday |  |  | 1st Week |  |  | 1st Day Of Month
 | Tuesday |  |  | 2nd Week
 | Wedneday |  |  | 3rd Week
 | Thursday |  |  | 4th Week
 | Friday
 | Saturday
 | Sunday
Spreadsheet: 881775d1729943407-data-driven-from-prime-data-to-abstract-as-requires-requet-formula
Sheet: Abs

This is the master data -(A)
Item No | Description of work | BOQ QTY | Qty | Perday Output | Actual Duration | Rounded Duration | Planned Start | Planned Finish | Bricks | Cement | Fine Sand | Mason | Helper | W-Helper | Stone aggregate 20mm | Stone aggregate 10mm | Sand | Mixer | Vibrator
1 | [NAME] 1:4 | 35 | M3 | 10 |  |  | 2024-10-16 00:00:00
2 | [NAME] 1:6 | 75 | M3 | 20 |  |  | 2024-10-19 00:00:00
3 | RCC 1:2:4 | 55 | M3 | 25 |  |  | 2024-10-22 00:00:00
 | Work Items | Qty |  | One Day Output |  |  | Start | Finish | Material Constant For 1 Unit of the work Items
Total Quantity Statement Drived from Above Given data (B)
 |  |  |  |  |  |  |  |  | Bricks | Cement | Fine Sand | Mason | Helper | W-Helper | Stone aggregate 20mm | Stone aggregate 10mm | Sand | Mixer | Vibrator
 |  |  |  |  |  |  |  | Total Qty
Material Requirement Date wise as described as per above data( C )
Sl.No. | Material Description |  |  |  |  | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00
1 | Bricks | For Item -1 |  |  |  |  |  | 4940 | 4940
2 | Bricks | For Item -2
Lookup the Start Date and  Duration of the activity  Consumed Quantity of that period to be ABSTRACTED  As per timeline Direct Formula by skipping Step B and Step C
Sl.No. | Material Description | 2024-10-15 00:00:00 | 2024-10-16 00:00:00 | 2024-10-17 00:00:00 | 2024-10-18 00:00:00 | 2024-10-19 00:00:00 | 2024-10-20 00:00:00 | 2024-10-21 00:00:00 | 2024-10-22 00:00:00 | 2024-10-23 00:00:00 | 2024-10-24 00:00:00 | 2024-10-25 00:00:00 | 2024-10-26 00:00:00 | 2024-10-27 00:00:00 | 2024-10-28 00:00:00
1 | Bricks
2 | Cement
3 | Fine Sand
4 | Mason
5 | Helper
6 | W-Helper
7 | Stone aggregate 20mm
8 | Stone aggregate 10mm
9 | Sand
10 | Mixer
11 | Vibrator
Spreadsheet: 871902d1718291023-highlight-next-odd-number-months-in-range-dates
Sheet: Sheet1

 | DATES
 | 2024-06-02 00:00:00
 | 2024-06-10 00:00:00
 | 2024-06-20 00:00:00
 | 2024-06-29 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-16 00:00:00
 | 2024-07-25 00:00:00
 | 2024-08-01 00:00:00
 | 2024-08-10 00:00:00
 | 2024-08-19 00:00:00
 | 2024-08-26 00:00:00
 | 2024-09-04 00:00:00
 | 2024-09-14 00:00:00
 | 2024-09-20 00:00:00
 | 2024-09-27 00:00:00
 | 2024-10-06 00:00:00
 | 2024-10-14 00:00:00
 | 2024-10-20 00:00:00
 | 2024-10-26 00:00:00
 | 2024-11-05 00:00:00
 | 2024-11-15 00:00:00
 | 2024-11-23 00:00:00
 | 2024-12-03 00:00:00
 | 2024-12-13 00:00:00
 | 2024-12-22 00:00:00
 | 2025-01-01 00:00:00
 | 2025-01-07 00:00:00
 | 2025-01-17 00:00:00
 | 2025-01-24 00:00:00
 | 2025-02-01 00:00:00
 | 2025-02-11 00:00:00
 | 2025-02-18 00:00:00
Spreadsheet: 487657d1478184298-formula-that-changes-with-filtered-lists-simplepivottable
Sheet: PivotTable

Location | (All)
Date of Survey | (All)
[NAME] | Count of Totals
1 | 3
2 | 1
3 | 2
4 | 1
5 | 1
6 | 4
7 | 6
8 | 20
0 - Extremely Dissatisfied | 1
9 - Extremely Satisfied | 129
(blank) | 145
Grand Total | 313
Spreadsheet: 789088d1658903697-merge-and-sum-unique-values-linked-to-repetitive-id-book1
Sheet: Sheet2

EE ID | Cost Center | Amount Paid
123456 | 987654 | 5600
123456 | 653214 | 2000
132646 | 321004 | 1100
236789 | 324567 | 6600
236789 | 324568 | 2900
231678 | 987654 | 500
Spreadsheet: 104803d1302264285-help-with-define-name-and-auto-updating-graphs-names1
Sheet: 4C

Month | Count
2009-02-01 00:00:00
2009-03-01 00:00:00 | 1 |  | Sum | Mean
2009-04-01 00:00:00 | 4
2009-05-01 00:00:00 | 3
2009-06-01 00:00:00 | 2
2009-07-01 00:00:00
2009-08-01 00:00:00 | 2
2009-09-01 00:00:00 | 3
2009-10-01 00:00:00 | 1
2009-11-01 00:00:00
2009-12-01 00:00:00
2010-01-01 00:00:00
2010-02-01 00:00:00 | 1
2010-03-01 00:00:00
2010-04-01 00:00:00 | 1
2010-05-01 00:00:00 | 1
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00 | 1
2010-10-01 00:00:00
2010-11-01 00:00:00 | 1
2010-12-01 00:00:00
2011-01-01 00:00:00 | 2
2011-02-01 00:00:00
2011-03-01 00:00:00
Spreadsheet: 06a9e42a-ea73-4541-9c54-a857c9ef13cf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Costa Rica Hotel Phone |  | (506) 2479-1600  / Skype: nayarahotel
 | USA |  | [PHONE]
 | USA TOLL FREE Number |  | [PHONE]
 | Reservation E mail |  | [EMAIL]
 | Fax number |  | (506)2479-1601
 | Web Side |  | www.arenalnayara.com
 | Please complete  the details below :
 | Full Name
 |  |  |  |  |  |  | Hotel Confirmation Number
 | E mail :
 |  |  |  |  |  |  | Number   Of  Pax
 | Phone Number
 | Arrival Information
 | Pick Up Place  :
 | Pick Up Time : |  |  |  |  | Date
 |  |  |  |  |  |  | Day | Month | Year
 | Flight Arrival Time
 | Rate |  |  |  |  |  | Fligh Number |  | Airline
 | Departure Details
 | [NAME] :
 | Pick Up Time  : |  |  |  |  | Date
 |  |  |  |  |  |  | Day | Month | Year
 | Flight Departure  Time
 | Rate |  |  |  |  |  | Fligh Number |  | Airline
 | Notes or Comments
 | Driving distance from SJO  [NAME] takes Around 2 hours and 45 minute
 | Driving distance from LIR  Liberia International Airport takes arround 3 Hours
 | Credit Card Information / This form Will be used to hold & gurantee your reservation .
 | I hereby accept the conditions described above and authorize to charge my credit card a 100% of  the total invoiced rack amount for
 | not show or cancell my reservation within the last 24 hours  before pick up  , even if i have not signed the original payment form or voucher
 | I further akcnowledge that i have understood  the terms and conditions applicable to my transfer  reservation
 | If the credit card is rejected the reservation will be canceled or useless
 |  |  |  |  |  |  | Cancelations or Modification most be done
 | Card Number # |  |  |  |  |  | 24 Hours before the pick up time
 | Expiration date
 |  | month | year |  | Security Code
 |  |  |  |  |  |  | This form will be used to hold & gurantee your reservation .
 | Card holder name
Spreadsheet: 106480d1303761478-multiple-conditions-in-an-if-statement-titleexample
Sheet: Sheet1

Title | Revenue | Percentage | Correct Answer |  |  |  | Title | Revenue A | Revenue B | Percentage
CEO | 27459 |  | 0.35 |  |  |  | CMO | 0 | 19999 | 0.2
COO | 74125 |  | 0.41 |  |  |  | CMO | 20000 | 24999 | 0.26
CMO | 24998 |  | 0.26 |  |  |  | CMO | 25000 | 29999 | 0.29
 |  |  |  |  |  |  | CMO | 30000 | 39000 | 0.32
 |  |  |  |  |  |  | CMO | 40000 | 49999 | 0.35
 |  |  |  |  |  |  | CMO | 50000 | + | 0.38
 |  |  |  |  |  |  | COO | 0 | 19999 | 0.23
 |  |  |  |  |  |  | COO | 20000 | 24999 | 0.29
 |  |  |  |  |  |  | COO | 25000 | 29999 | 0.32
 |  |  |  |  |  |  | COO | 30000 | 39000 | 0.35
 |  |  |  |  |  |  | COO | 40000 | 49999 | 0.38
 |  |  |  |  |  |  | COO | 50000 | + | 0.41
 |  |  |  |  |  |  | CEO | 0 | 19999 | 0.26
 |  |  |  |  |  |  | CEO | 20000 | 24999 | 0.31
 |  |  |  |  |  |  | CEO | 25000 | 29999 | 0.35
 |  |  |  |  |  |  | CEO | 30000 | 39000 | 0.38
 |  |  |  |  |  |  | CEO | 40000 | 49999 | 0.42
 |  |  |  |  |  |  | CEO | 50000 | + | 0.45
Spreadsheet: 77867d1278368225-non-constant-arrays-scratch
Sheet: Projected Risk

Projected Product Risk Matrix
 |  | Milestone | 0 | 1 | 2 | 3 | 4 | 5
Components | 6 | Date | 2010-07-01 00:00:00 | 2010-07-02 00:00:00 | 2010-07-03 00:00:00 | 2010-07-04 00:00:00 | 2010-07-05 00:00:00 | 2010-07-06 00:00:00
 | Sub-parts | Critical Level | Initial Risk Level | Risk Reduction
Component 1 | 5 |  |  |  |  |  |  |  |  | [NAME]
A |  | 4 | 50 |  |  |  | 0.99
B |  | 6 | 85 | 0.25
C |  | 8 | 85 |  | 0.8
D |  | 8 | 60 |  |  | 0.35 |  | 0.35
E |  | 10 | 78 |  |  |  |  | 1
Component 2 | 3
A |  | 4 | 50 | 0.75 |  |  |  | 0.15
B |  | 8 | 85 |  | 0.35 |  | 0.55
C |  | 6 | 70 |  |  | 0.22 | 0.55
Spreadsheet: 133800d1324640656-count-max-contiguous-blank-cells-help-1-
Sheet: Sheet1

Employee | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | [NAME] contiguos absence days count |  |  |  | Employee | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00
A | x |  | x |  |  |  | x | x | x |  |  | 3 |  | 3 |  | A |  | 1 |  | 1 | 2 | 3 |  |  |  | 1 | 2
B |  |  |  | x | x |  |  |  |  | x | x | 4 |  | 4 |  | B | 1 | 2 | 3 |  |  | 1 | 2 | 3 | 4
C | x | x | x | x |  |  |  | x | x | x | x | 3 |  | 3 |  | C |  |  |  |  | 1 | 2 | 3
D | x |  | x |  | x | x | x |  |  | x | x | 2 |  | 2 |  | D |  | 1 |  | 1 |  |  |  | 1 | 2
 | x: present
 | I would like to count MAX contiguos days which employee was absent (contiguos blank cells) (no VBA)
Spreadsheet: 758175d1638721514-copying-cell-to-another-worksheet-on-condition-omiting-empty-cells-example
Sheet: Input

 | Header |  | Header | Header
 | Header | Header | Header | Header
 | Header | Header | Header | Header
 | Header | Header | Header | Header
 | Header | Header | Header | Header
Nr. | Text | Yes | No | To Do | Check
1 | Text 1 |  |  | yes
 | Text 2 |  |  | yes
 | Text 3 |  |  | yes
 | Text 4 |  |  | yes
 | Text 5 |  |  | no
 | Text 6 |  |  | no
 | Text 7 |  |  | no
 | Text 8 |  |  | no
 | Text 9 |  |  | no
 | Text 10 |  |  | yes
 | Text 11 |  |  | no
 | Text 12 |  |  | no
 | Text 13 |  |  | no
 | Text 14 |  |  | no
 | Text 15 |  |  | yes
 | Text 16 |  |  | no
 | Text 17 |  |  | no
 | Text 18 |  |  | no
 | Text 19 |  |  | no
 | Text 20 |  |  | no
 | Text 21 |  |  | no
 | Text 22 |  |  | no
 | Text 23 |  |  | no
 | Text 24 |  |  | no
 | Text 25 |  |  | yes
Spreadsheet: 872695d1719056110-getting-data-from-one-workbook-to-another-croy79-ghm-team-v2-aligw
Sheet: Day 1

 | 2007 |  |  | 2008 |  |  | 2009 |  |  | 2010
 | Girls | Boys |  | Girls | Boys |  | Girls | Boys |  | Girls | Boys
200 | Amber Welch | Trae Gibbons |  | [NAME] | Kruez Turner |  | [NAME] | [NAME] |  | [NAME] | [NAME]
 | [NAME] | Elijah Tonissoo |  | [NAME] | [NAME] |  | Nailani Jones | [NAME] |  | Ella Crossley | [NAME]
1500 | Amber Welch | Elijah Tonissoo |  | [NAME] | [NAME] |  | [NAME] | Romen O'Day
 | Jayda Francisco | Trae Gibbons |  | [NAME] | [NAME] |  | Nailani Jones | [NAME]
 |  |  |  | [NAME] | [NAME] |  | [NAME] | Eli Pearce
High | Annabell M-C | Trae Gibbons |  | [NAME] | [NAME] |  | Layla Nania | [NAME]
 | Amber Welch | Elijah Tonissoo |  | [NAME] | Kruez Turner |  | [NAME] | Nate Moldre
 | Jayda Francisco | [NAME] |  | [NAME] | [NAME] |  | Nailani Jones | Tighe Mackle
Shot | Annabell M-C | [NAME] |  | Ella Sluga | Milan [NAME] |  | [NAME] | [NAME]
 | [NAME] | Trae Gibbons |  | [NAME] | [NAME] |  | Nailani Jones | Tighe Mackle
 | Jorden Bloomfield | [NAME] |  | Tahlia Jorgensen | [NAME] |  | [NAME] | [NAME]
 | 2010
 | Girls | Boys
Long | [NAME] | [NAME]
 | [NAME] | [NAME]
Spreadsheet: 876199d1722875697-placing-team-to-game-dates-book-5
Sheet: Team-Course Schedule

2025-05-27 00:00:00
Teams | Week 1 | HCP | Place |  |  | HCP | Place |  |  | HCP | Place |  |  | HCP | Place |  |  | HCP | Place
1 | [NAME] |  |  |  | [NAME] |  |  |  | Barb Tamp |  |  |  | [NAME] |  |  |  | [NAME]
1 | [NAME] |  |  | 10 | [NAME] |  |  | 9 | [NAME] |  |  | 8 | Shelly Early |  |  | 7 | [NAME] | Baxter
 | VS | HCP |  |  | VS | HCP | Place |  | VS | HCP | Place |  | VS | HCP | Place |  | VS | HCP | Place
6 | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Afera Quick |  |  |  | [NAME]
6 | [NAME] |  |  | 2 | Nate Late |  |  | 3 | Mac Long |  |  | 4 | [NAME] |  |  | 5 | [NAME]
 | Team-Course Schedule