tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116422d1311815994-sumproduct-match-index-absence
Sheet: Sheet1

Absence Data |  |  |  |  |  | Current Employees
Employee Number | Duration | Start date | End Date | Occurence |  | Employee | Monitor Start Date | Monitor End Date | 2 Occurences trigger end date | 4 or more days trigger end date
7776 | 1 | 2011-02-01 00:00:00 | 2011-02-01 00:00:00 | 1 |  | 7776 | 2011-01-01 00:00:00 | 2011-03-31 00:00:00
7776 | 2 | 2011-02-07 00:00:00 | 2011-02-08 00:00:00 | 2 |  | 7777 | 2011-03-01 00:00:00 | 2011-05-31 00:00:00
7777 | 5 | 2011-05-03 00:00:00 | 2011-05-09 00:00:00 | 1 |  | 7778
7778 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1 |  | 7779
7779 | 2 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 1 |  | 7780 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00
7779 | 2 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2 |  | 7781
7779 | 3 | 2011-02-05 00:00:00 | 2011-02-09 00:00:00 | 3 |  | 7782
7780 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1 |  | 7784
7781 | 5 | 2011-06-06 00:00:00 | 2011-06-12 00:00:00 | 1 |  | 7785
7781 | 13 | 2011-06-13 00:00:00 | 2011-06-29 00:00:00 | 2 |  | 7786
7782 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1
7783 | 2 | 2011-05-03 00:00:00 | 2011-05-04 00:00:00 | 1
7784 | 7 | 2011-06-02 00:00:00 | 2011-06-10 00:00:00 | 1
7784 | 4 | 2011-06-11 00:00:00 | 2011-06-16 00:00:00 | 2
7784 | 9 | 2011-06-20 00:00:00 | 2011-06-30 00:00:00 | 3
7785 | 2 | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 1
7785 | 2 | 2011-02-03 00:00:00 | 2011-02-04 00:00:00 | 2
7785 | 1 | 2011-02-06 00:00:00 | 2011-02-07 00:00:00 | 3
7786 | 4 | 2011-06-06 00:00:00 | 2011-06-09 00:00:00 | 1
Spreadsheet: 163365d1340286284-please-help-formula-problem-countif-sumproduct-dcount-none-of-it-is-working-sampledb
Sheet: Sheet1

Current Stage | Date Issued
S2 | 2011-12-02 00:00:00
WL
S1 | 2011-05-08 00:00:00
S1 | 2011-10-26 00:00:00
ABC | 2012-02-14 00:00:00
ABCExt | 2012-05-16 00:00:00
WL
ABC | 2012-02-14 00:00:00
ABCExt | 2012-05-16 00:00:00
S1 | 2011-12-11 00:00:00
ABC | 2012-02-14 00:00:00
ABCExt | 2012-05-16 00:00:00
S1 | 2011-12-11 00:00:00
ABC | 2012-02-14 00:00:00
S1 | 2011-12-11 00:00:00
Spreadsheet: louise_kitchen__23976__Schedule D_927
Sheet: Schedule D

Schedule D
Second Quarter 2001 |  |  |  |  |  |  |  |  |  |  |  | Exchange Rate |  |  | 1.5773
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | http://finance.yahoo.com/m5?a=1&s=USD&t=CAD&c=0
Item: |  | 2000-10-18 00:00:00 |  | 2000-11-06 00:00:00 |  | 2001-06-30 00:00:00 |  | 2001-09-28 00:00:00
Alberta PPA - Sundance 3 |  |  |  |  |  | 98.9 |  |  | (1)
Alberta PPA - Sundance 4 |  |  |  |  |  | 98.9 |  |  | (1)
Power Books
Other |  | 56 |  | 56 |  | 56 |  | 56
[NAME] Book |  |  |  |  |  | 7.9 |  | 7.9
Alamac |  |  |  |  |  | 7.3 |  | 7.3
Reserve for COF Rediscounting |  |  |  |  |  | 12.4
Office of the Chair
Total Schedule D
1)  $149 million Canadian dollars converted at 1.577 Canadian $ to US $. (Spot rate as of 9/27)
Spreadsheet: 526194d1499180114-cell-formating-from-another-sheet-weld-map-test
Sheet: Weld Map

 |  |  |  | PROJECT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A. SHEET #
 |  |  |  | SPREAD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STATION |  | 34175 |  | TO
PIPE SIZE |  |  |  | WALL |  |  |  | GRADE |  |  |  | INSPECTOR |  |  |  |  |  |  |  |  |  | TOTAL
REMARKS
X-RAY STATION
Joint No.
Heat No.
Pipe Length
Wall Thickness
[NAME]
Total Length
X-RAY STATION
Joint No.
Heat No.
Pipe Length
Wall Thickness
[NAME]
Total Length
X-RAY STATION
Joint No.
Heat No.
Pipe Length
Wall Thickness
[NAME]
Total Length
Spreadsheet: 679777d1590617799-unhiding-rows-based-on-a-specific-word-question
Sheet: Sheet1

Enter your Name:
Name | DOB | Title | City | Sales
[NAME] | 1952-05-30 00:00:00 | Manager | NYC | 52423
[NAME] | 1983-04-25 00:00:00 | Assistant | Miami | 15962
[NAME] | 2000-12-25 00:00:00 | Student | Las Vegas | 24522
[NAME] | 1983-04-25 00:00:00 | Assistant | Miami | 168523
What I am looking for is for the columns from A6-A9 to be hidden. Then, when someone enters a name on B2 the row related to that name would appear
For example: If I would write [NAME] on B2 then the rows A7 and A9 would unhide.
Spreadsheet: 848008d1698829944-calculating-principal-and-interest-and-amount-remaining-sample-data
Sheet: Sheet1

 |  | loan amount | 4000 |  |  | account number | repayment date | repayment amount | amount remaining | Principal | Interest
 |  | term in month | 24 |  |  | 123 | 2022-06-01 00:00:00 | 93.29 | 4000
 |  | repyament freq | forthnightly |  |  | 123 | 2022-06-15 00:00:00 | 93.29
 |  | repayment amount | 93.29 |  |  | 123 | 2022-06-29 00:00:00 | 93.29
 |  | annual interest rate | 0.12 |  |  | 123 | 2022-07-13 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-07-27 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-08-10 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-08-24 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-09-07 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-09-21 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-10-05 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-10-19 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-11-02 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-11-16 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-11-30 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-12-14 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2022-12-28 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-01-11 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-01-25 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-02-08 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-02-22 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-03-08 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-03-22 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-04-05 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-04-19 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-05-03 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-05-17 00:00:00 | 93.29
 |  |  |  |  |  | 123 | 2023-05-31 00:00:00 | 93.29
Spreadsheet: 696986d1601060049-unable-to-find-the-correct-sumproduct-formula-with-multiple-criteria-sample-sheet-1-
Sheet: Sheet1

Online Daily Orders
Total Boxes |  | Qty | Indian Tonic Water | Grapefruit Tonic Water | Elderflower Tonic Water | [NAME] | Club Soda | Tonic Mix Pack | Variety Pack | Other
 |  |  | Quantities
6 PACK
12 PACK
18 PACK
24 PACK
S.No | Order ID |  |  | Customer Name |  |  | Price | Details | Pack Size | Indian Tonic Water | Grapefruit Tonic Water | Elderflower Tonic Water | [NAME] | Club Soda | Tonic Mix Pack | Variety Pack | Other
 | [PHONE]-2341923 |  |  | [NAME] |  | [NAME] | 990 | JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN
 | [PHONE]-8517964 |  |  | [NAME] prabhu [NAME] |  | VP6 | 495 | JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN
 | [PHONE]-5026723 |  |  | SHIVANGI CHATURVEDI |  | OTHER12 | 990 | JFTW06-MFN,JFTW06-MFN,JFGP06-MFN,JFTW06-MFN,JFTW06-MFN,JFGP06-MFN,JFTW06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFTW06-MFN |  |  |  |  |  |  |  |  | ?
 | [PHONE]-0490717 |  |  | [NAME] boulain |  | TW6 | 480 | JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN
 | [PHONE]-8218717 |  |  | KABIR talwar |  | GA12 | 969 | JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS,JFGA12-MFNS
 | [PHONE]-9475514 |  |  | AMIT DOL |  | CS6 | 450 | JFCS06-MFN,JFCS06-MFN,JFCS06-MFN,JFCS06-MFN,JFCS06-MFN,JFCS06-MFN
 | [PHONE]-8009155 |  |  | Aishwarya Namjoshi |  | GP6 | 510 | JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN
 | [PHONE]-9350725 |  |  | Amit Singh |  | VP24 | 1880 | JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN,JFVP12-MFN
 | [PHONE]-8627524 |  |  | Ankur Motiwal |  | GP6 | 510 | JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN
 | [PHONE]-0156333 |  |  | R RAVI PRAKASH |  | CS6 | 450 | JFCS06-MFN,JFCS06-MFN,JFCS06-MFN,JFCS06-MFN,JFCS06-MFN,JFCS06-MFN
 | [PHONE]-4922765 |  |  | [NAME] |  | GA6 | 510 | JFGA06-MFN,JFGA06-MFN,JFGA06-MFN,JFGA06-MFN,JFGA06-MFN,JFGA06-MFN
 | [PHONE]-9020313 |  |  | [NAME] |  | TW6 | 480 | JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN
 | [PHONE]-0089156 |  |  | [NAME] |  | VP6 | 495 | JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN
 | [PHONE]-6069912 |  |  | P.S.DAS |  | VP6 | 495 | JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN
 | [PHONE]-0002742 |  |  | Ankur Suhag |  | TW6 | 480 | JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN,JFTW06-MFN
 | [PHONE]-9425923 |  |  | Viral Chopra |  | GP6 | 510 | JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN,JFGP06-MFN
 | [PHONE]-4109906 |  |  | Cupela Consulting |  | VP6 | 495 | JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN,JFVP06-MFN
Spreadsheet: 169586d1342969424-how-to-apply-countif-formula-when-data-are-on-different-sheets-book1
Sheet: May

 |  |  |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
S.no | Employee Name | SID | Process | 2012-05-01 00:00:00 | 2012-05-02 00:00:00 | 2012-05-03 00:00:00 | 2012-05-04 00:00:00 | 2012-05-05 00:00:00 | 2012-05-06 00:00:00 | 2012-05-07 00:00:00 | 2012-05-08 00:00:00 | 2012-05-09 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00 | 2012-05-12 00:00:00 | 2012-05-13 00:00:00 | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00 | 2012-05-19 00:00:00 | 2012-05-20 00:00:00 | 2012-05-21 00:00:00 | 2012-05-22 00:00:00 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-26 00:00:00 | 2012-05-27 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: daren_farmer__5095__Tufco_May01
Sheet: Sheet2

 | [NAME] | WAGNER BROWN
 |  | 016-88968-301
 |  | 0-60,000 on this contract
 |  | PGE |  | LS |  | HPL |  |  |  | 930000
 |  |  |  |  |  | Lone Star | WGR Hdr | Tail Gate | Texoma | TOTAL
 |  |  |  |  |  | 67 | 17806000 | 4132 | 686 (71)
 |  |  |  |  |  |  |  |  |  | wbtotal
1 |  | 44681 |  |  |  | 0 |  | 0 | 0
2 |  | 32689 |  |  |  | 0 |  | 0 | 0
3 |  | 32584 |  |  |  | 0 |  | 0 | 0
4 |  | 27790 |  |  |  | 0 |  | 0 | 0
5 |  | 4947 |  |  |  | 0 |  | 0 | 0
6 |  | 18599 |  |  |  | 0 |  | 0 | 0
7 |  | 30748 |  |  |  | 0 |  | 0 | 0
8 |  | 36708 |  |  |  | 0 |  | 0 | 0
9 |  | 58612 |  |  |  | 0 |  | 0 | 0
10 |  | 61618 |  |  |  | 0 |  | 0 | 0
11 |  | 32917 |  |  |  | 0 |  | 0 | 0
12 |  | 22176 |  |  |  | 0 |  | 0 | 0
13 |  | 55040 |  |  |  | 0 |  | 0 | 0
14 |  | 41202 |  |  |  | 0 |  | 0 | 0
15 |  | 428 |  |  |  | 0 |  | 0 | 0
16 |  | 39264 |  |  |  | 0 |  | 0 | 0
17 |  | 28911 |  |  |  | 0 |  | 0 | 0
18 |  | 18197 |  |  |  | 0 |  | 0 | 0
19 |  | 29838 |  |  |  | 0 |  | 0 | 0
20 |  | 30786 |  |  |  | 0 |  | 0 | 0
21 |  | 0 |  |  |  | 0 |  | 0 | 0
22 |  | 27119 |  |  |  | 0 |  | 0 | 0
23 |  | 59043 |  |  |  | 0 |  | 0 | 0
24 |  | 33750 |  |  |  | 0 |  | 0 | 0
25 |  | 122 |  |  |  | 0 |  | 0 | 0
26 |  | 23 |  |  |  | 0 |  | 0 | 0
27 |  | 46421 |  |  |  | 0 |  | 0 | 0
28 |  | 60193 |  |  |  | 0 |  | 0 | 0
29 |  | 60000 |  |  |  | 0 |  | 0 | 0
30 |  | 0 |  |  |  | 0 |  | 0 | 0
31 |  | 0 |  |  |  | 0 |  | 0 | 0
Spreadsheet: 231005d1366917551-copy-data-based-on-selection-in-drop-down-control-sample-3-
Sheet: Input

 |  |  |  |  |  | Input Measured Values In Orange
 |  |  |  |  |  |  |  |  | 123456
 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3
 |  |  | ARM |  | Travel | Travel 2 |  |  |  |  | Result | Result 2 | Result 3 | Summary Data
 |  |  |  |  |  |  |  |  |  | 2
 | Calculated |  |  |  |  |  |  |  |  | 3
 | Measured |  | 111 |  | 52 | 48 |  |  |  | 4
 | Displacement Difference |  |  |  |  |  |  |  |  | 5
 | % Difference |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  | 18
Spreadsheet: 92460d1292008751-multiple-vlookup-values-sample
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | [NAME]
 |  | Monday |  |  |  |  |  |  | text | 0:20:00
 |  | 2011-01-03 00:00:00
 | Scheduled | 05:00:00 | 13:00:00
 | Worked | 05:00:00 | 13:00:00
 | Late/Absent | 0:00:00
 |  | Text
 | Schedled | 14:00:00 | 17:00:00
 | Worked | 14:00:00 | 17:00:00
 | Late/Absent
 |  | 0
 |  | Paid Break Time Taken | Extra Paid Break Time Allowed
 |  | 2:30:00 | 0:20:00
 |  | Total Allowed | Excess
Spreadsheet: 98539d1297394875-check-if-a-background-color-exists-yellow_test-1-
Sheet: Sheet5

Sheet5 |  | There are | 0 |  | Unanswered Questions |  |  |  | Return to Index
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
1 | + | 1 | = | 2 |  |  | 1 | + | 1 | = | 2
 |  | Fill In The Blank |  |  |  |  |  |  | Fill In The Blank
Spreadsheet: 742114d1627544091-my-index-match-is-broken-planning-file-excel-test
Sheet: Dashboard

Week Number |  | 32 |  |  |  |  |  |  |  |  | Flea = 30 Days Supply | 30
 |  |  |  |  |  |  | WHAT IT SHOULD SHOW |  |  |  | [NAME] = 120 Day Supply | 90
Item Code | Product Name | Lead Time | Weeks Cover | New Order Due | Stock Hold Cover | Av. Expected Weekly Sales | Av. Expected Weekly Sales | MOQ | Case QTY | Valid
 |  | 10 | 4 |  |  |  | 1 | 150 | 1
 |  | 10 | 4 |  |  |  | 1 | 150 | 1
 |  | 10 | 4 |  |  |  | 6 | 150 | 1
 |  | 10 | 4 |  |  |  | 2 | 150 | 1
 |  | 10 | 4 |  |  |  | 6 | 150 | 1
 |  | 10 | 4 |  |  |  | 7 | 150 | 1
 |  | 10 | 4 |  |  |  | 12 | 150 | 1
 |  | 10 | 4 |  |  |  | 1 | 150 | 1
 |  | 10 | 4 |  |  |  | 1 | 150 | 1
 |  | 10 | 4 |  |  |  | 6 | 150 | 1
 |  | 10 | 4 |  |  |  | 2 | 150 | 1
 |  | 10 | 4 |  |  |  | 6 | 150 | 1
 |  | 10 | 4 |  |  |  | 11 | 150 | 1
 |  | 10 | 4 |  |  |  | 8 | 150 | 1
 |  | 10 | 4 |  |  |  | 20 | 150 | 1
 |  | 10 | 4 |  |  |  | 23 | 150 | 1
Spreadsheet: 69678d1270230816-counting-within-a-qtr-in-a-fiscal-year-book2
Sheet: Sheet1

REGION | DOI |  |  | Q1 | Q2 | Q3 | Q4
R1 | 2005-07-01 00:00:00 |  | R1 | 2 | 4 | 2 | 7
R1 | 2005-08-01 00:00:00 |  | R2 | 2 | 4 | 2 | 2
R1 | 2005-10-01 00:00:00 |  | R3 | 2 | 3 | 2 | 4
R1 | 2005-11-01 00:00:00
R1 | 2005-12-01 00:00:00
R1 | 2005-12-21 00:00:00
R1 | 2006-02-16 00:00:00
R1 | 2006-03-11 00:00:00
R1 | 2006-05-11 00:00:00
R1 | 2006-06-02 00:00:00
R1 | 2006-06-07 00:00:00
R1 | 2006-06-16 00:00:00
R1 | 2006-06-24 00:00:00
R1 | 2006-06-24 00:00:00
R1 | 2006-06-26 00:00:00
R2 | 2005-07-01 00:00:00
R2 | 2005-08-01 00:00:00
R2 | 2005-10-01 00:00:00
R2 | 2005-11-01 00:00:00
R2 | 2005-12-01 00:00:00
R2 | 2005-12-21 00:00:00
R2 | 2006-03-10 00:00:00
R2 | 2006-06-21 00:00:00
R2 | 2006-06-30 00:00:00
R3 | 2005-07-01 00:00:00
R3 | 2005-10-01 00:00:00
R3 | 2005-11-01 00:00:00
R3 | 2005-12-01 00:00:00
R3 | 2006-02-02 00:00:00
R3 | 2006-04-03 00:00:00
R3 | 2006-04-29 00:00:00
R3 | 2006-05-02 00:00:00
R3 | 2006-05-20 00:00:00
Spreadsheet: 274651d1383170557-function-vlookup-but-need-index-match-vat-v2
Sheet: Sheet1

Products | Unit Cost | [NAME] | Vat % | Total Per Unit |  |  |  |  |  |  | [NAME] | [NAME]
Panasonic MP-BDT230EB | 84.99 | 2 |  |  |  |  |  |  |  |  | 2 | 0.2
Panasonic Wireless Speaker SC-NE3EBK | 139.99 | 1 |  |  |  |  |  |  |  |  | 3 | 0.15
LG Music in Style ND4520 | 79.97 | 3 |  |  |  |  |  |  |  |  | 1 | 0
Bosu | 64.99 | 2
Spreadsheet: 674217d1587723459-dynamic-array-formula-query-dates-financial-year-sample
Sheet: Sheet1

Dates
 |  |  |  | Period Number |  |  | 2 | 3 | 4 | 5 | 6 | …
 |  |  |  | Date |  |  | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | …
 |  |  |  | Calendar Yr |  |  | 2020 | 2020 | 2020 | 2020 | 2020 | …
Description | Range Name | Value |  | [NAME] |  |  | 5 | 6 | 7 | 8 | 9 | …
 |  |  |  | Financial Yr |  |  | 2020 | 2020 | 2021 | 2021 | 2021 | … | 2022 | 2023
Number of periods in model | sModelTerm | 6 |  | [NAME] |  |  | 11 | 12 | 1 | 2 | 3 | …
Model start date | sStartDate | 2020-04-30 00:00:00 |  | Model Year |  |  | 1 | 1 | 1 | 1 | 1 | …
 |  |  |  | Multiply by 1 |  |  | 1 | 1 | 1 | 1 | 1 | …
 |  |  |  | Financial Model Year |  |  |  |  |  |  |  | …
 |  |  |  |  |  |  |  |  |  |  |  | …
 |  |  |  | Desired values |  | 1 | 1 | 1 | 2 | 2 | 2 | … | 3 | 4
Spreadsheet: 142936d1330095614-auto-filter-using-macro-auto-filter-name-doc
Sheet: Starters

First Name | Last Name | Job Title | Company | Parent Co. | Office Location | Manager's Name | Temp/Perm | Leave Date | Comments
[NAME] | Coulbeck | Resourcing Coordinator | CPS | BB | South Mimms | [NAME] | Permanant | 2011-11-07 00:00:00
[NAME] | [NAME] | [NAME] | CPS | BB | Leatherhead | [NAME] | Permanant | 2011-11-07 00:00:00
Lauren | Whitlock | Network Operator | CPS | BB | Godstone | [NAME] | Permanant | 2011-11-07 00:00:00
[NAME] | MacFarlane | ISU Operative | CPS |  | Leatherhead | [NAME] | Temporary | 2011-11-07 00:00:00
[NAME] | Baguely | Engineer | CPS | Atkins | [NAME] | [NAME] | Permanant | 2011-11-14 00:00:00
[NAME] | Humble | [NAME] | CPS | BB | Leatherhead | [NAME] | Permanant | 2011-11-14 00:00:00
Helen | Dordoy | Tunnel Operations Administrator | CPS | BB | [NAME] | [NAME] | Permanant | 2011-11-01 00:00:00
[NAME] | Mealand | Network Operations Controller | CPS | BB | South Mimms | [NAME] | Temporary | 2011-11-21 00:00:00
Spreadsheet: 196214d1353921612-numeric-value-returned-by-if-statement-not-treated-as-number-in-other-formulas-1971-set
Sheet: Validation

[NAME]:
Abreviation | Description | Grade
0 | Have | 0
AU | Authentic | 0
PR | Poor | 1
FR | Fair | 1.5
[NAME] | Good | 2
GD+ | Good+ | 2.5
VG | Very Good | 3
VG+ | Very Good+ | 3.5
VG/EX | Very Good/Excellent | 4
VG/EX+ | Very Good/Excellent+ | 4.5
EX | Excellent | 5
EX+ | Excellent+ | 5.5
EX/MT | Excellent/Mint | 6
EX/MT+ | Excellent/Mint+ | 6.5
NM | Near Mint | 7
NM+ | Near Mint+ | 7.5
NM/MT | Near Mint/Mint | 8
NM/MT+ | Near Mint/Mint+ | 8.5
MT | Mint | 9
MT+ | Mint+ | 9.5
GEM | [NAME] | 10
Qualifiers
Abreviation | Description
OC | Off-Center
MC | Miscut
MK | Marked
PD | Print Defect
ST | Stained
OF | Out of Focus
TR | [NAME]
CR | Recolored
OA | Other Alteration
Card Graders
PSA | Professional Sports Authenticator
BGS | Beckett Grading Services
BVG | [NAME]
BCCG | Beckett Collector's Club Grading
SGC | Sportscard Guaranty Company
GAI | Global Authority Inc
OTHER | Miscellaneous/Other
Spreadsheet: john_arnold__15362__STOR9809
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9809
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2000-12-08 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 611 | 570
(TX, LA, OK, KS, MS)
Market Area - East |  | 1495 | 1385
Market Area - West |  | 323 | 316
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 107179d1304414391-excel-2007-counting-cells-colorindex
Sheet: Sheet1

Colour Index | Colour | Count
1 |  | 13
2 |  | 23
3 |  | 14
4 |  | 17
5 |  | 14
6 |  | 9
7 |  | 18
8 |  | 10
9 |  | 13
10 |  | 22
11 |  | 15
12 |  | 16
13 |  | 14
14 |  | 16
15 |  | 10
16 |  | 17
17 |  | 13
18 |  | 20
19 |  | 19
20 |  | 10
21 |  | 15
22 |  | 15
23 |  | 11
24 |  | 10
25 |  | 13
26 |  | 15
27 |  | 17
28 |  | 15
29 |  | 11
30 |  | 11
31 |  | 19
32 |  | 18
33 |  | 19
34 |  | 11
35 |  | 10
36 |  | 14
37 |  | 18
38 |  | 16
39 |  | 12
40 |  | 11
41 |  | 13
42 |  | 15
43 |  | 14
44 |  | 14
45 |  | 15
46 |  | 19
47 |  | 14
48 |  | 14
49 |  | 13
50 |  | 10
51 |  | 12
52 |  | 14
53 |  | 10
54 |  | 18
55 |  | 8
56 |  | 13
Spreadsheet: 100323d1298683933-using-exact-with-isnumber-isnumber-with-exact
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | aa
yes | aa
yes | aa
yes | aag
no | aa
no | aa
yes | cc
yes | cc
yes | cc
yes | dd
yes | dd
no | dd
no | ee
no | ee
no | df
no | dg
no | dh
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: Moffett 2 DX56 NWV

 |  |  |  |  | DX56 NWV
Registration number : | DX56 NWV |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : |  |  | 2007-01-29 00:00:00 | 12 Months | 2008-02-01 00:00:00 | 165
Specification : |  |  | 2008-01-31 00:00:00 | 12 Months | 2009-02-01 00:00:00 | 165
Type : |  |  | 2009-01-30 00:00:00 | 12 Months | 2010-02-01 00:00:00 | 165
1st Registered : |  |  | 2010-01-29 00:00:00 | 12 Months | 2011-02-01 00:00:00 | 165
Engine : |  |  | 2011-01-31 00:00:00 | 12 Months | 2012-02-01 00:00:00 | 165
[NAME] : |  |  | 2012-01-31 00:00:00 | 12 Months | 2013-02-01 00:00:00 | 165
Back To Index