tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 838350d1690948100-calculation-returning-an-error-test-46-
Sheet: Sheet2

 |  | 0 | MAKE A CHOICE
 |  | 08:00:00 | Deployment | CAIN
 |  | 06:00:00 | Redeployment | Kuwait
 |  | 05:00:00 | In-Country | Indianapolis
 |  | 04:00:00 |  | Indianapolis Airport
 |  | 03:00:00 |  | [NAME] CRC
 |  | 02:00:00 |  | Iraq
 |  | 01:00:00 |  | BWI
 |  | :15 |  | Maine
 |  | :30 |  | Bulgaria
 |  | :45 |  | Ireland
 |  | 01:15:00 |  | Germany
 |  | 01:30:00 |  | Qatar
 |  | 01:45:00 |  | New Hampshire
 |  | 02:15:00 |  | Afghanistan
 |  | 02:30:00
 |  | 02:45:00
 |  | 03:15:00
 |  | 03:30:00
 |  | 03:45:00
 |  | 04:15:00
 |  | 04:30:00
 |  | 04:45:00
 |  | 05:15:00
 |  | 05:30:00
 |  | 05:45:00
 |  | 06:15:00
 |  | 06:30:00
 |  | 06:45:00
 |  | 07:00:00
 |  | 07:15:00
 |  | 07:30:00
 |  | 07:45:00
 |  | 08:00:00
 |  | 08:15:00
 |  | 08:30:00
 |  | 08:45:00
 |  | 09:00:00
 |  | 09:15:00
 |  | 09:30:00
 |  | 09:45:00
 |  | 10:00:00
 |  | 10:15:00
 |  | 10:30:00
 |  | 10:45:00
 |  | 11:00:00
 |  | 11:15:00
 |  | 11:30:00
 |  | 11:45:00
 |  | 12:00:00
 |  | 12:15:00
 |  | 12:30:00
 |  | 12:45:00
Spreadsheet: 127870d1320659569-graphs-prototype-graphs-ks4-and-5-v1
Sheet: Sheet1

Name | Gender | Target Grade | SEN |  | Task 1 | Task 2 | Task 3 | Task 4 | Task 5 | Task 6 | Task 7 | Task 8 | Task 9 | Task 10
bob | male |  |  | Current grade | B | A | A | B | B | D | C | A | B | C | Average grade
 |  |  |  | Effort Grade | 1 | 2 | 2 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | Average Effort |  |  | B | B | D | B | C | D | B | C | C
[NAME] | female |  |  | Current grade | D | U | B | U | B | C | A | B | A | A | Average grade |  |  | C | C | U | E | A | D
 |  |  |  | Effort Grade | 3 | 4 | 2 | 4 | 2 | 3 | 1 | 2 | 1 | 1 | Average Effort
[NAME] | female |  |  | Current grade | C | C | C | C | C | C | C | C | C | C | Average grade
 |  |  |  | Effort Grade | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | Average Effort
bob | male |  |  | Current grade | A | B | A | B | A | B | C | B | A | A | Average grade
 |  |  |  | Effort Grade | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | Average Effort
bob | male |  |  | Current grade | U | U | U | C | C | B | B | A | A | B | Average grade
 |  |  |  | Effort Grade | 4 | 4 | 4 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | Average Effort
bob | male |  |  | Current grade | D | D | D | C | A | A | A | A | A | B | Average grade
 |  |  |  | Effort Grade | 3 | 3 | 3 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | Average Effort
[NAME] | female |  |  | Current grade | U | U | U | U | U | U | U | U | U | U | Average grade
 |  |  |  | Effort Grade | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | Average Effort
[NAME] | female |  |  | Current grade | E | E | E | E | E | E | E | E | E | E | Average grade
 |  |  |  | Effort Grade | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Average Effort
bob | male |  |  | Current grade | D | C | D | C | C | D | B | C | B | D | Average grade
 |  |  |  | Effort Grade | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 2 | 1 | 3 | Average Effort
bob | male |  |  | Current grade | D | D | D | D | D | C | C | C | E | D | Average grade
 |  |  |  | Effort Grade | 3 | 3 | 3 | 3 | 3 | 1 | 2 | 1 | 3 | 3 | Average Effort
[NAME] | female |  |  | Current grade | A | A | A | A | A | A | A | A | A | A | Average grade
 |  |  |  | Effort Grade | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | Average Effort
bob | male |  |  | Current grade | B | B | B | B | B | B | B | B | B | A | Average grade
 |  |  |  | Effort Grade | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | Average Effort
bob | male |  |  | Current grade | C | C | C | C | C | D | D | D | D | A | Average grade
 |  |  |  | Effort Grade | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | Average Effort
[NAME] | female |  |  | Current grade | U | U | U | U | D | D | A | A | A | A | Average grade
 |  |  |  | Effort Grade | 4 | 4 | 4 | 4 | 3 | 3 | 1 | 1 | 1 | 1 | Average Effort
bob | male |  |  | Current grade | U | C | C | C | C | C | C | B | B | A | Average grade
 |  |  |  | Effort Grade | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | Average Effort
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | average male grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average female grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | average class grade
Spreadsheet: benjamin_rogers__1327__site_visit_schedule_112100
Sheet: Bidders

E2 [NAME]
 | [NAME] | Lincoln | Wheatland | [NAME] | Pastoria
AES |  |  |  | X | X
AEP |  |  |  | X | X
Allegheny | X | X | X | X
[NAME] | X |  | X
Calpine |  | X |  | X | X
Cinergy | X | X | X
DPL |  |  | X
Duke | X | X | X
Dynegy | X | X | X |  | X
Edison Mission |  |  |  |  | X
El Paso |  |  |  | X
Intergen |  |  |  |  | X
LG&E | X |  | X
NRG | X | X | X | X | X
PECO |  | X |  | X
PSE&G | X | X | X
Pinnacle West |  |  |  | X | X
Southern |  | X | X | X | X
TOTAL: | 8 | 9 | 10 | 9 | 9
Spreadsheet: 982fa568-017f-4877-97f8-d0766e3e179d
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
FFTIC | Test | FFTIC | Ticlopidine, Serum/Plasma | Ticlopidine | Gas Chromatography (GC) | Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and freeze immediately. Send 2 mL  of serum frozen in a plastic vial. Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum).   [NAME] blood in a purple-top (EDTA) tube(s). ([NAME] tube  is not acceptable.) Spin down and freeze immediately. Send  2 mL of EDTA plasma frozen in a plastic vial. Note:	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma). | 0.5 mL | Specimens other than	Serum, plasma Anticoagulants other than	Plain red-top, EDTA Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Reporting limit determined each analysis   [NAME]    Synonym(s): [NAME] state peak plasma levels from patients on a 250 mg    twice daily regimen:  0.22 - 2.1 mcg/mL (mean of 0.99) at 2    hours post dose.    Test Performed by: NMS Labs                                       3701 Welsh Road                                       PO Box 433A                                       Willow Grove, PA 19090-0437 | Tuesday, Thursday | 3 days | 5 - 9 days | 1 | 82491 |  |  |  |  | NMS Labs
FFTIC | [NAME] | VARIES | Varies |  |  |  | Frozen | 90 days
FFTIC | Result | Z1475 | Ticlopidine | Ticlopidine | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 11003-1
FFTIC | Result | Z1340 | Reporting Limit | Reporting Limit | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 843941d1695755295-filling-blanks-within-range-using-formula-export-template
Sheet: Current

 |  | Current Date
2023-09-26 00:00:00 |  | Last Updated
Activity Name | Import Column | Activity ID | Project ID | WBS Level | WBS Calculator | Index | Project ID2
 | Buliding
 | P1.4
 | P.1.2
 | P1.3
 | P1.4
 | Activity | 1 | Project 1
 | Activity | 2 | Project 1
 | Activity | 3 | Project 1
 | Activity | 4 | Project 1
 | P1.4
 | P.1.2
 | P1.3
 | P1.4
 | Activity | 5 | Project 1
 | Activity | 6 | Project 1
 | P1.4
 | Activity | 7 | Project 1
 | Activity | 8 | Project 1
 | Activity | 9 | Project 1
 | Activity | 10 | Project 1
 | Activity | 11 | Project 1
 | Activity | 12 | Project 1
 | Activity | 13 | Project 1
 | Activity | 14 | Project 1
 | Activity | 15 | Project 1
 | P1.4
 | P.1.2
 | P1.3
 | P1.4
 | Activity | 16 | Project 1
 | Activity | 17 | Project 1
 | Activity | 18 | Project 1
 | Activity | 19 | Project 1
 | Activity | 20 | Project 1
 | Activity | 21 | Project 1
 | Activity | 22 | Project 1
 | Activity | 23 | Project 1
 | P.1.2
 | Activity | 24 | Project 1
 | Activity | 25 | Project 1
 | Activity | 26 | Project 1
 | Activity | 27 | Project 1
 | Activity | 28 | Project 1
 | Activity | 29 | Project 1
 | Annex
 | P1.4
 | P.1.2
 | Activity | 30 | Project 2
 | P1.4
 | P.1.2
 | P1.3
 | Activity | 31 | Project 2
 | Activity | 32 | Project 2
 | Activity | 33 | Project 2
 | Activity | 34 | Project 2
 | Activity | 35 | Project 2
 | Activity | 36 | Project 2
 | P1.4
 | P.1.2
 | P1.3
 | P1.4
 | P1.5
 | Activity | 37 | Project 2
 | P1.5
 | Activity | 38 | Project 2
 | Activity | 39 | Project 2
 | P1.4
 | P1.5
 | Activity | 40 | Project 2
 | P1.5
 | Activity | 41 | Project 2
 | Activity | 42 | Project 2
 | Activity | 39 | Project 2
 | P1.4
 | P.1.2
 | P1.3
 | P1.4
 | P1.5
 | P1.6
 | P1.7
 | Activity | 39 | Project 2
 | P1.7
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | P1.6
 | P1.7
 | Activity | 39 | Project 2
 | P1.7
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | P1.6
 | P1.7
 | Activity | 39 | Project 2
 | P1.7
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | P.1.2
 | P1.3
 | P1.4
 | P1.5
 | Activity | 39 | Project 2
 | P1.5
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | P.1.2
 | P1.3
 | P1.4
 | Activity | 39 | Project 2
 | P1.4
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | Activity | 39 | Project 2
 | Shed
 | P1.4
 | P.1.2
 | P1.3
 | P1.4
 | P1.5
 | Activity | 39 | Project 3
Spreadsheet: 762107d1641398850-need-formula-that-satisfies-3-criteria-for-text-in-a-cell-example2552
Sheet: Sheet1

 |  |  | DESIRED RESULT
1PR | BWGG | INSERT FORMULA | G |  |  | CRITERIA
NR | OWGR | INSERT FORMULA |  |  |  | 1. Col A must contain  "1PR"
NR | BPWO | INSERT FORMULA |  |  |  | 2. Col B must contain any of the same Letters twice any any order
1PR | PWWG | INSERT FORMULA | W |  |  | 3. Which ever letter appears twice in the cell in Col A, that letter must be displayed in Col C, where the formula is inserted
1PR | YPWW | INSERT FORMULA | W
1PR | PROP | INSERT FORMULA | P
1PR | RPBB | INSERT FORMULA | B
1PR | OROW | INSERT FORMULA | O
ALL | RRRR | INSERT FORMULA
1PR | YOWO | INSERT FORMULA | O
2PR | GRGR | INSERT FORMULA
NR | BYWO | INSERT FORMULA
Spreadsheet: ec93e61e-43ed-42c7-b4c3-7cb79a48c047
Sheet: Sheet1

Governor and Lt. Governor (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Downloaded at 6/19/2013 4:45:05 AM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
Precinct | DuWayne Hendrickson & Dana Brandenburg | [NAME] | Tim Mathern & [NAME] | TOTALS
Precinct 1001 | 3 | 77 | 20 | 100
Precinct 1002 | 2 | 73 | 14 | 89
Precinct 1003 | 4 | 168 | 23 | 195
Precinct 1004 | 0 | 63 | 8 | 71
Precinct 1005 | 0 | 52 | 15 | 67
Precinct 1006 | 1 | 83 | 17 | 101
Precinct 1007 | 3 | 89 | 36 | 128
Precinct 1008 | 1 | 72 | 28 | 101
Precinct 1009 | 4 | 241 | 67 | 312
Precinct 1010 | 10 | 795 | 177 | 982
TOTAL | 28 | 1713 | 405 | 2146
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 44419d1243017383-excel-2007-want-to-make-a-order-list-order-list
Sheet: Product1

Product | Weight | Price | Quantity
a | 1 | 12 | 30
b | 2 | 1 | 0
c | 3 | 1 | 0
d | 4 | 1 | 2
g | 5 | 7 | 0
e | 1 | 1 | 0
f | 2 | 131 | 1
Spreadsheet: 775987d1649427633-big-cleaning-data-excelforum_merge_subst
Sheet: Formulas

Wrong Addresses: | Formula 1/5 | Formula 2/5 | [NAME] 3/5 | [NAME] 4/5 | Formula 5/5
Str. Exampl~e Park-Avenue Nr.[A3-5]/C
Ṧtr. Exămple Park-Avenue Nr.A3-5/C
Str. Example 	Park-Avenue Nr.A3-5/	C
Str. Example Park-Avenue №A3-5/C
Str. example PARK-AveNue nr.A3-5/c
Str. Example Park-Avenue numa3-5/C
Ṧțr. ExâMple *?	^PaRK-ave>nue nra3-5/c
//Str/.Example///Park-Avenue/Nr.A3-5/C
-Str .  -  -  -/-    -..--Example Park- [NAME] -5/C
Str.Example.Park-Avenue.Nr.A3-5/C
Str. Example Park-Avenue Nr.A3-5/C, Bloc C, Aprt. 6
Str. Example Park-Avenue Nr.A 3 -5/ C, Bl. C,      Ap. 6 .
Str; Example Park-Avenue, Nr.A 3 -5/ C, Bl.C, Ap.6
...Str...Example    Park---Avenue;;; Nr.A3----5/// C,,, [NAME].C, Ap.6,,,,
///Str/ .  -  -  -.-    -..--Example;Park- -Avenue Nr…A3-5/C--- Bloc C   Ap. 6///
Example Park-Avenue Nr.A3-5/C
Ps. Example Park-Avenue Nr.A3-5/C
Str. Aleea Example Park-Avenue Nr.A3-5/C
Strada B-dul. Example Park-Avenue Nr.A3-5/C
Str. Example Park-Avenue, army-cap. Nr.A3-5/C
Str. Example Park-Avenue- Nr.A3-5/C
Str. Example Park-Avenue TR Nr.A3-5/C
Str. Example Park-Avenue Junior Nr.A3-5/C
gnr-maj. Example Park-Avenue TR Senior, doc. . Nr.A3-5/C
Str. Example pizdet Park-Avenue Nr.A3-5/C
Str. Example pizda matii Park-Avenue Nr.A3-5/C
Wrong | Step 1 | Step 2 | Step 3 | Step 4 | Step 5
Spreadsheet: 299552d1393232667-copy-and-paste-columns-to-another-sheet-based-on-a-criteria-sample
Sheet: Sheet1

Employee | Project | Activity | Iteration | Area Path | 2/17/2014 | 2/18/2014 | 2/19/2014 | 2/20/2014 | 2/21/2014 | 2/22/2014 | 2/23/2014 | 2/17/2014 To 2/23/2014 | 2/24/2014 | 2/25/2014 | 2/26/2014 | 2/27/2014 | 2/28/2014 | 2014-01-03 00:00:00 | 2014-02-03 00:00:00 | 2/24/2014 To 3/2/2014
[NAME] | Google | Test Cases | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Google | Test Cases | N/A | N/A | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Google | Test Cases | N/A | N/A | 0 | 0 | 3 | 0 | 0 | 4 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Yahoo | Test Cases | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 6 | 2 | 0 | 0 | 5 | 0 | 0 | 7 | 14
[NAME] | Yahoo | Design | N/A | N/A | 0 | 2 | 0 | 0 | 2 | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Yahoo | Design | N/A | N/A | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 2
[NAME] | Yahoo | Design | N/A | N/A | 0 | 0 | 0 | 3 | 0 | 0 | 4 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Yahoo | Analysis | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | Yahoo | Analysis | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 4
[NAME] | Yahoo | Analysis | N/A | N/A | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 3 | 0 | 0 | 0 | 3
[NAME] | MSN | Analysis | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | MSN | Analysis | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Toby | MSN | Development | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 4 | 0 | 0 | 3 | 0 | 4 | 1 | 0 | 8
Toby | MSN | Development | N/A | N/A | 0 | 3 | 1 | 1 | 0 | 0 | 0 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 2
Toby | MSN | Development | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Toby | MSN | Development | N/A | N/A | 0 | 1 | 2 | 3 | 4 | 0 | 0 | 10 | 0 | 0 | 0 | 4 | 0 | 0 | 0 | 4
Toby | Bing | Development | N/A | N/A | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 5 | 7
Toby | Bing | Bugs | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 1 | 0 | 3 | 0 | 4
Toby | Bing | Bugs | N/A | N/A | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Toby | Bing | Bugs | N/A | N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 472945d1469883069-pivot-table-pivot-example
Sheet: Pivot Example

Count of size | Column Labels |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Count of size | Column Labels
Row Labels | L | M | S | XS | Grand Total |  |  |  |  |  |  |  |  |  |  |  | Row Labels | 2 | 3 | 9 | 9.5 | 10 | 10.5 | 11 | 11.5 | 12 | 38 | 42 | Grand Total
15686.00.07 |  | 1 | 1 | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  | 22039 |  |  | 1 | 1 | 1 |  | 1 |  | 1 |  |  | 5
1730J 100 |  | 1 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 27679 |  |  |  | 1 |  |  |  |  |  |  |  | 1
17783.00.12 | 1 | 1 | 1 |  | 3 |  |  |  |  |  |  |  |  |  |  |  | 43765 | 1 | 1 |  |  |  |  |  |  |  |  |  | 2
17785.00.13 | 1 | 1 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 43865 |  |  |  |  |  | 1 | 1 | 1 | 1 |  |  | 4
17786.00.10 | 1 | 1 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 43881 |  |  |  |  |  | 1 | 1 |  |  |  |  | 2
30458.00.06 | 1 | 1 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 47423 |  |  |  |  |  |  |  |  |  | 1 | 1 | 2
31751.00.05 |  | 1 | 1 | 1 | 3 |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 1 | 1 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 1 | 1 | 16
31855.00.04 |  |  | 1 |  | 1
Grand Total | 4 | 7 | 4 | 2 | 17
Spreadsheet: 25721d1217259471-counting-tabulated-data-tqm
Sheet: RAG

 |  | Output File |  |  |  |  |  |  |  |  |  | Data File
 |  | Start Date | 2008-04-01 00:00:00 |  |  |  |  |  |  |  |  | [NAME] | Project Start | Project Status
 |  |  | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | Total |  |  |  | Green | 2008-04-07 00:00:00 | Active
 |  | RED |  |  |  |  |  | 0 |  |  |  | Green | 2008-04-04 00:00:00 | Active
 |  | AMBER |  |  |  |  |  | 0 |  |  |  | Green | 2008-04-04 00:00:00 | Closed
 |  | GREEN |  |  |  |  |  | 0 |  |  |  | Amber | 2004-08-07 00:00:00 | Active
 |  |  |  |  |  |  |  | 0 |  |  |  | Green | 2008-07-07 00:00:00 | Closed
 |  |  |  |  |  |  |  |  |  |  |  | Green | 2008-07-07 00:00:00 | Closed
 |  | The columns above should sum the data file on the right. |  |  |  |  |  |  |  |  |  | Red | 2008-08-07 00:00:00 | Active
 |  | I require the COUNT of the projects that are Active, and allocate to the start month. |  |  |  |  |  |  |  |  |  | Red | 2008-07-07 00:00:00 | Active
 |  | Desired output below. |  |  |  |  |  |  |  |  |  | Amber | 2008-07-07 00:00:00 | Active
 |  |  |  |  |  |  |  |  |  |  |  | Green | 2008-07-07 00:00:00 | Active
 |  | Desired Output |  |  |  |  |  |  |  |  |  | Green | 2008-06-14 00:00:00 | Active
 |  | Start Date | 2008-04-01 00:00:00
 |  |  | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | Total
 |  | RED | 0 | 0 | 0 | 1 | 1 | 2
 |  | AMBER | 0 | 0 | 0 | 1 | 1 | 2
 |  | GREEN | 2 | 0 | 1 | 1 | 0 | 4
 |  |  |  |  |  |  |  | 0
Spreadsheet: 887290d1737526812-schedule-calendar-cover-school-copy-of-absence-timetable-v1
Sheet: Ma

Period | Time | Monday | Tuesday | Wednesday | Thursday | Friday
Registration | 0735-0800 |  |  |  |  | Dept. Meeting
Period 1 | 0800 -0830 | Noah D. 3.1 (Maths) | Noah D. 3.1 (Maths) | Noah D. 3.1 (Maths) | Noah D. 3.1 (Maths) | Dept. Meeting
 | 0830-0900 | Noah D. 3.1 (Maths) | Noah D. 3.1 (Maths) | Noah D. 3.1 (Maths) | Noah D. 3.1 (Maths)
Period 2 | 0900-0930 |  |  | Year 3 Planning |  | [NAME]
 | 0930-1000 |  |  | Year 3 Planning |  | [NAME]
Period 3 | 1000-1030 | Morning Break | Morning Break | Morning Break | Duty ([NAME], Position 1) | Morning Break
 | 1030-1100 |  |  | [NAME]
Period 4 | 1100-1130 |  |  | [NAME]
 | 1130-1200 | Noah D. 3.1 (Phonics) | Noah D. 3.1 (Phonics) | Noah D. 3.1 (Phonics) | Noah D. 3.1 (Speech) | Noah D. 3.1 (Phonics)
Period 5 | 1200-1230 |  | Duty (Infant Hall Path)
 | 1230-1300 | [NAME] (Math) | [NAME] (Lit/IC) | [NAME] (Lit/IC) | [NAME] (PE) | [NAME] (Lit/IC)
Period 6 | 1300-1330 | [NAME] (Lit/IPC) |  |  | Duty (Main 2)
 | 1330-1400 | [NAME] (Lit/IPC) | [NAME] (Lit/IPC) | [NAME] (Lit/IPC) | [NAME] (Lit/IPC) | [NAME] (Lit/IPC)
Period 7 | 1400-1430 |  | [NAME] (Lit/IPC) | [NAME] (Lit/IPC) | [NAME] (Lit/IPC) | [NAME] (Lit/IPC)
 | 1430-1500
 | 1500-1515 | Bus Loading/Dismissal
Spreadsheet: 4956f00e-ebd5-4d4d-b711-4070a1a70556
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: |  |  | 2014-02-14 09:26:10.200000
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 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.449 | 102.324 | 102.199 | 101.824
4.5 | 101.548 | 101.423 | 101.298 | 100.923 |  | Note: | Refer To Price [NAME]
4.375 | 100.606 | 100.481 | 100.356 | 99.981 |  |  | For all Price Adjs
4.25 | 99.888 | 99.763 | 99.638 | 99.013
4.125 | 99.089 | 98.964 | 98.839 | 98.214
4 | 98.103 | 97.978 | 97.853 | 97.228
3.875 | 97.072 | 96.947 | 96.822 | 96.197
3.75 | 96.197 | 96.072 | 95.947 | 95.322
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.69 | 102.565 | 102.44 | 102.065
3.75 | 102.436 | 102.311 | 102.186 | 101.811
3.625 | 102.036 | 101.911 | 101.786 | 101.411
3.5 | 101.462 | 101.337 | 101.212 | 100.587
3.375 | 100.708 | 100.583 | 100.458 | 99.833
3.25 | 99.906 | 99.781 | 99.656 | 99.031 |  | 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 | 2014-02-28 09:26:10.200000
30 DAY | 2014-03-15 09:26:10.200000
45 DAY | 2014-03-30 09:26:10.200000
60 DAY | 2014-04-14 09:26:10.200000
90 DAY | 2014-05-14 09:26:10.200000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 707403d1607248830-flight-time-calculating-number-of-minutes-required-by-a-date-to-remain-current-updated-flight-time-ans
Sheet: Steve

[NAME]
Date | Minutes | Notes
 | 50
2020-09-20 00:00:00 | 30
2020-09-30 00:00:00 | 30
2020-10-05 00:00:00 | 30
2020-10-10 00:00:00 | 20 | Solo sunrise morning flight around Beggarwood
Total
DATE | MTS remaining
 |  | 90 days from 20 sep 2020
Spreadsheet: 743800d1628733074-conditional-function-with-arrays-issue-to-solve-a-problem-conditional-function-problem-josephteh
Sheet: example (2)

 | Table 1 : Main data |  |  |  |  | Table 2 : Sequence of the work |  |  |  |  |  |  |  |  | Table 3 : Total number of worker per month
 | Code Activity | Activity | Code  Worker | Worker | Number of Worker | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00
 | A1 | Lunch room | W4 | Painter | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |  | W1
 | A1 |  | W1 | Labourer | 3 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |  | [NAME]
 | A1 |  | W3 | Electrician | 2 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |  | W3
 | A2 | Bathroom | [NAME] | Plumber | 2 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 |  | W4
 | A2 |  | W1 | Labourer | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 |  | W5
 | A2 |  | [NAME] | Builder | 3 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0
 | A3 | Lockers | W1 | Labourer | 3 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0
 | A3 |  | [NAME] | Builder | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0
 | A4 | Kitchen | W3 | Electrician | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0
 | A4 |  | W4 | Painter | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0
 | A5 | Main room | W3 | Electrician | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 | A5 |  | W1 | Labourer | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 | A5 |  | W4 | Painter | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 | A5 |  | [NAME] | Builder | 5 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0