tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 06293158-9fde-46be-865b-06ce93e64894
Sheet: Sheet1

THE UNIVERSITY OF TULSA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
COLLEGE OF ARTS AND SCIENCES | Name____________________________________
Area of Concentration Requirements | Major-Spanish B.A.
 | Spanish majors complete 30 hours at the 3000 and 4000 levels, with
1.        You must have a minimum GPA of 2.2 | a minimum of 15 hours at the 4000 level. The following must be included:
in your area of concentration and a minimum of |  | HR | GR | SM
2.0 TU GPA in order to graduate. | Spanish 3003 Composition in Spanish | _____ | _____ | _____
 | Span 3033 Explication of Hispanic Lit Texts | _____ | _____ | _____
2.        No Pass/D/F or CLEP credit may be | Span 3123 [NAME] to Spanish Linguistics | _____ | _____ | _____
applied toward your Area of Concentration.
 | In addition, majors fulfill a culture requirement component by completing one of the following:
3.    Courses applied to meet Core and General | The Culture of Spain (Span 3013), The Cultures of Latin America (Span 3023),
Curriculum requirements may not also apply in | Spanish Film (Span 3333), the equivalent of one of the above during a study abroad experience,
your Area of Concentration. | or an approved class course offered outside of the Department of Languages
 | in which a significant portion of the coursework is completed in Spanish. Although students
4.   Two thirds of the course work in your | who choose the latter option fulfill the culture requirement, the course itself does not count
Major [NAME] must be at the 3000 or 4000 level. | toward the major. Spanish Education majors take Methods of Teaching Languages (Lang 4003)
 | as part of their major.
5.     Subjects in your Minor Field must be
selected in conjunction with your [NAME] |  | HR | GR | SM
 | ___________________________ | _____ | _____ | _____
6.  No more than 55 hours may be earned in the | ___________________________ | _____ | _____ | _____
Area of Concentration, and no more than 39 of | ___________________________ | _____ | _____ | _____
these may be earned in the major subject. | ___________________________ | _____ | _____ | _____
These totals may be exceeded only by the | ___________________________ | _____ | _____ | _____
number of hours beyond the 124 required for | ___________________________ | _____ | _____ | _____
graduation. | ___________________________ | _____ | _____ | _____
 | Minor - 12 hours with 6 hours at the 3000 or 4000 level.
 | ___________________________ | _____ | _____ | _____
 | ___________________________ | _____ | _____ | _____
 | ___________________________ | _____ | _____ | _____
 | ___________________________ | _____ | _____ | _____
Spreadsheet: 550063d1512074133-tally-up-x-marks-for-roll-sheets-with-names-on-multiple-sheets-master-attendance-sheet-example
Sheet: Wednesday

WEDNESDAY
 |  | 2017-09-20 00:00:00
 | STUDENT NAME | WK1 | WK2 | WK3 | WK4 | WK5 | WK6 | WK7 | WK8 | WK9 | WK10 | WK11 | WK12 | WK13 | WK14 | WK15 | WK16 | WK17
1 | AJAY SMITH | X | X | X |  | X |  | X | X | X | X | X | 4 | 5
 | ALEX YU |  |  |  |  | X
 | ALEXANDRA MCDONALD |  |  |  |  |  |  |  | X | X
 | [NAME] | X |  | X | X |  | X | X |  | X | X | X
 | ANGEL YOU |  |  | X | X |  |  | X | X |  | X | X
 | ANNIE CLARK |  |  |  |  | X | X
 | [NAME] | X |  | X | X | X | X | X | X | X | X | X
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF RESERVE ITEMS
FOR THE YEAR ENDED 12-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065) |  | -100559 |  |  |  |  |  |  |  |  |  |  |  | Reserve for doubtful accounts
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 825905d1681629735-convert-from-a-vertical-list-to-a-horizontal-list-cant-use-transpose-sample-data
Sheet: Sheet1

Student ID | Last Name | First Name | Course
12345 | Smith | [NAME] | English
12345 | Smith | [NAME] | Calculus
12345 | Smith | [NAME] | French I
12345 | Smith | [NAME] | World History
12345 | Smith | [NAME] | Chemistry
12345 | Smith | [NAME] | Physical Education
12345 | Smith | [NAME] | Business 101
205032 | Johnston | [NAME] | English
205032 | Johnston | [NAME] | Algebra I
205032 | Johnston | [NAME] | Chemistry
205032 | Johnston | [NAME] | Spanish II
205032 | Johnston | [NAME] | Physical Education
205032 | Johnston | [NAME] | AP Computer Science
To:
 | Last Name | First Name | Course
12345 | Smith | [NAME] | English | Calculus | French I | World History | Chemistry | Physical Education | Business 101
205032 | Johnston | [NAME] | English | Algebra I | Chemistry | Spanish II | Physical Education | AP Computer Science
Spreadsheet: 134342d1325235377-indirect-vlookup-and-intirect-different-sheets
Sheet: Sheet1

date | name | sg count | tc count
27-12-11 | aaa | 1400 | 12 | 1400 | 12
27-12-11 | bbb | 1263 | 14 | 1263 | 14
27-12-11 | [NAME] | 2685 | 15 | 2685 | 15
27-12-11 | ddd | 3254 | 23 | 3254 | 23
27-12-11 | eee | 4000 | 16 | 4000 | 16
27-12-11 | [NAME] | 3500 | 9 | 3500 | 9
Spreadsheet: 151274d1334847946-excel-2007-nesting-problems-with-if-and-vlookup-currency
Sheet: Sheet1

 |  | Invoice | amount | Curr. | Periode | Exchange rate | Eur Amount
 |  | 1667061 | 3739.24 | CAD | December 2011 | 0.719648 | 2690.93658752
 |  | 1676080 | 3739.24 | CAD | December 2011 | 0.719648 | 2690.93658752
 |  |  |  |  |  |  | 0
 |  |  |  |  |  | Difference | 0
Spreadsheet: daren_farmer__5440__BKRQST72
Sheet: Sheet1

To: | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
From: | Regina Perkins |  |  |  | Department: | Sitara Development
Subject: | New Portfolio Request |  |  |  | Date:
 | This is to notify you that a new [NAME] needs to be set up:
 | COUNTERPARTY | Associated Entity |  | GLOBAL COMMON CODES |  |  | Reporting -Subledger
 | COUNTERPARTY LEGAL NM | COUNTERPARTY LEGAL NM | MSA CO NO | DATA CD | DATA DESC |  | MTM | Prud | Realized
Note 1 | ENA - IM Cleburne | Enron North America Corp. (Duns #1305) | 413 | IMCL
 | Should be included with same Desk Security as Texas Desk
Note 1 | Please set up CPR counterparty as well.
 | Any questions, please contact me
 | [NAME] (x33548)
Spreadsheet: 269402d1381154415-countif-and-adding-a-value-to-a-cell-on-criteria-met-sample_workbook2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | This is the original and only counts the actual number of 10 accumulated hours, not over the number
 |  |  |  |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | expected result 15
 |  |  | OUT |  |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 17:00:00 | OUT | 21:00:00 |  | IN | 12:00:00 | OUT | 21:30:00 |  | IN | 17:00:00 | OUT | 22:00:00 |  | IN | 13:00:00 | OUT | 16:00:00
 |  |  |  |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  | over 10 add 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | expected result 15
 |  |  | OUT |  |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 07:00:00 | OUT | 17:01:00 |  | IN | 17:00:00 | OUT | 21:00:00 |  | IN | 12:00:00 | OUT | 21:30:00 |  | IN | 17:00:00 | OUT | 22:00:00 |  | IN | 13:00:00 | OUT | 16:00:00
Spreadsheet: 292435d1390593831-excel-returning-multiple-values-in-a-single-cell-that-match-criteria-configurable_associated_products
Sheet: import_configurable_products_ex

type | parent_sku | [NAME] | associated | associated
simple | 505 | 505-Small
simple | 505 | 505-Medium
simple | 505 | 505-Large
simple | 505 | 505-XL
simple | 505 | 505-2XL
configurable | 505 | 505 |  | 505-Small,505-Medium,505-Large,505-XL,505-2XL
simple | 541468 | 541468-Small
simple | 541468 | 541468-Medium
simple | 541468 | 541468-Large
simple | 541468 | 541468-XL
simple | 541468 | 541468-2XL
simple | 541468 | 541468-3XL
configurable | 541468 | 541468 |  | 541468-Small,541468-Medium,541468-Large,541468-XL,541468-2XL,541468-3XL
Spreadsheet: 781601d1653430830-better-way-count-text-entries-specific-columns-multiple-sheets-thanks-sample-data-copy
Sheet: Sample1

Product Manager | Category | Country | Tech Feature 1 Status | Feature 1 Shipping | Tech Feature 2 Status | Feature 2 Shipping | Tech Feature 3 Status | Feature 3 Shipping | Tech Feature 4 Status | Feature 4 Shipping | Tech Feature 5 Status | Feature 5 Shipping
Spreadsheet: 4b7f1535-0a5a-4e69-bd78-780abc660251
Sheet: Page1_1

 |  |  | Colorado Department of Education |  |  | Page: 1
 |  |  | Business Rules
School Year: | 2013-14 | Dataset: | Discipline | File Type: | Discipline Incident
Data Element Name | Error/Warning Code | Error Type | Message | Status | Tier | Last Updated User | Last Updated Date
ADMIN_UNIT_CODE | DI001 | Error | Admin Unit/SOP Code must equal '00000'. | Active | 1
[NAME] | DI012 | Error | Behaviors must be a valid code. | Active | 1
DISTRICT_CODE | DI003 | Error | School District/BOCES Code must be a valid code. | Active | 1
INCIDENT_DATE | DI009 | Error | Date of Incident is mandatory. | Active | 1
INCIDENT_DATE | [NAME] | Error | Date of Incident must be a valid date (MMDDYYYY). | Active | 1
INCIDENT_DATE | DI011 | Error | Date of Incident must be between July 1st and June 30th of the current school year. | Active | 1
INCIDENT_IDENTIFIER | DI007 | Error | Incident Identifier is mandatory. | Active | 1
INCIDENT_IDENTIFIER | DI008 | Error | Incident Identifier must be unique. | Active | 1
REPORTED_TO_LAW_ENFORCEMENT | DI014 | Error | Reported to Law Enforcement must be a valid code. | Active | 1
SCHOOL_CODE | [NAME] | Error | School code must be a valid code for the specified school district. If a student is in a program with no School Code please refer to the exception request Instructions document for instructions on how to request an exception. Please upload the Action file first for students in a program. | Active | 1
SERIOUS_BODILY_INJURY | DI015 | Error | Serious Bodily Injury must be a valid code. | Active | 1
WEAPONS | [NAME] | Error | Weapons must be a valid code. | Active | 1
Spreadsheet: 834931d1688157582-rank-function-streamline-process-rank-function
Sheet: Sheet1

 | Existing Data Set (Sample)
 | Q1 | Q2 | Q3 | Q4
2020 | -7156 | 9419 | 6490 | 5116
2021 | 4216 | 2137 | -8701 | 5217
2022 | -4731 | -8062 | 9946 | 1421
2023 | 5158 | 1396
 | SIMPLE RANK Function (same structure)
 | What I would like instead is the following:
 | RANK * | AMOUNT ** | QTR/YEAR ***
 | 1 | 9946 | 2022 - Q3
 | 2 | 9419 | 2020 - Q2
 | 3 | 6490 | 2020 - Q3
 | 4 | 5217 | 2021 - Q4
 | 5 | 5158 | 2023 - Q1
 | 6 | 5116 | 2020 - Q4
 | 7 | 4216 | 2021 - Q1
 | 8 | 2137 | 2021 - Q2 |  | See comments in B38:B40
 | 9 | 1421 | 2022 - Q4
 | 10 | 1396 | 2023 - Q2
 | 11 | -4731 | 2022 - Q1
 | 12 | -7156 | 2020 - Q1
 | 13 | -8062 | 2022 - Q2
 | 14 | -8701 | 2021 - Q3
 | 15 | -- | --
 | 16 | -- | --
 | * Needs to be a formula
 | ** Needs to be the RANK formula (top-down across 16 rows vs. top-down for 4 rows COL B; & 4 rows COL C, etc.)
 | *** Needs to be a lookup formula based on the ranked value
Spreadsheet: 739396d1625672174-configurable-match-from-two-sheets-of-data-configurable-sheet-ans
Sheet: Alpha

Alpha | x | y | z | Sum | 1 | 2 | 3 | 4 | 5
1 | 58 | 39 | 23 | 120 |  | 7 | 5.099019513592784 | 6.6332495807108
2 | 61 | 33 | 21 | 115 | 7 |  | 5.385164807134504 | 9.433981132056603 | 6
3 | 57 | 36 | 19 | 112 | 5.099019513592784 | 5.385164807134504 |  | 10.48808848170152 | 1
4 | 64 | 41 | 25 | 130 | 6.6332495807108 | 9.433981132056603 | 10.48808848170152 |  | 10.04987562112089
5 | 57 | 37 | 19 | 113 | 4.35889894354067 | 6 | 1 | 10.04987562112089
Spreadsheet: kevin_ruscitti__20327__NGPL_StorageE_Test
Sheet: Booking Structure

 | CASH FLOWS: |  |  |  |  | December FOM NGPL/LA Index: |  |  | 2
 |  | Physical Book |  |  |  | Buy December gas (12/4/99), inject & sell in January.
 |  | Financial - Dec
 |  | Financial - Jan |  |  |  | January F4F: | 2.25
 |  | Profit (Should be PV'd).
 | Note:  Need to sell Nymex + Basis + Index (January) to lock in spread.
 | Otherwise, we would be long January physical gas.
 |  |  |  |  |  |  |  | Injection |  | 0 |  |  | 50000
 | SITART Transaction |  | 2.2 |  |  | Gas (NGPL/LA)
 | (Valued against FOM)
 |  |  |  |  |  |  |  | Withdrawal |  | 0 |  |  | 50000
 |  |  |  |  |  |  |  |  |  | TAGG Transaction
Spreadsheet: 5a241b5c-51c4-45b4-9d95-fd5300562249
Sheet: Sheet1

Classified Employee Biweekly Timesheet
Name |  |  |  |  |  |  |  | SUNY ID |  |  |  |  |  | Payroll Use Only Posted::
 |  |  |  |  |  |  |  |  | PAY PERIOD
Phone |  |  |  |  |  |  |  |  | Begin: |  |  |  |  | White = Regular Hours
 |  |  |  |  |  |  |  |  | End: |  |  |  |  | Shaded = Overtime Hours
Date |  | Record DAILY Times in & Out |  |  |  | Total Hours Worked | Comp Time Earned | Paid Over Time | Holiday |  | Enter Time Used Hours |  |  |  |  |  |  | DRL | Payroll Use Only
 |  |  |  |  |  |  |  |  |  |  | Vac | Sick |  | Comp Time | Pers | Holiday
 |  | In | Out | In | Out |  |  |  | Leave | Pay |  | Reg | Family |  |  | Reg | Float
THU
FRI
SAT
SUN
MON
TUE
WED
THU
FRI
SAT
SUN
MON
TUE
WED
 |  |  |  | TOTALS
Signatures signify that this time record represents a correct accounting of time for the specified period.
Employee Signature: |  |  |  |  |  |  |  |  | Supervisor Signature:
Timesheets must be received in the Payroll Office, Doty 318, by close of business on Friday of pay week.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Updated 4/2/2014
Spreadsheet: 738267d1624948959-transposing-data-transposing-data-ans
Sheet: Sheet2

Date | Year
Spreadsheet: 34382d1231598642-how-to-remove-those-0-values-num-sample1
Sheet: Data

Acc | Qty
120422 | 460
120461 | 1180
120461 | 491
120461 | 624
120506 | 852
128008 | 513
140350 | 554
140350 | 231
2084 | 373
2084 | 156
2084 | 197
35915 | 112
35915 | 142
36423 | -246
36423 | 108
36423 | 138
36690 | 1043
36690 | -1043
36690 | 435
36690 | -435
36690 | 552
36690 | -552
36936 | 303
36936 | 126
36936 | 160
37082 | 249
37082 | 104
37082 | 131
37298 | 445
37298 | 185
37298 | 235
37359 | 503
37359 | 222
37359 | 255
37361 | 362
37361 | 149
37361 | 189
37595 | 185
37595 | 78
4080 | 549
4080 | 245
4080 | 279
4386 | 607
4386 | 266
4386 | 304
4989 | 272
4989 | 113
4989 | 144
5396 | 228
5396 | 96
5396 | 121
5511 | 305
5511 | 127
5978 | 229
5978 | 261
61670 | 236
7663 | 1436
7663 | 600
7663 | 761
800392 | 279
800392 | 117
800392 | 148
8629 | 407
8629 | 171
8629 | 215
36690 | 1043
36690 | 435
36690 | 552
140475 | 800
Spreadsheet: 139082d1328063493-help-with-data-extraction-from-a-workbook-data-extraction
Sheet: Sheet1

ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2009 | 28.02.2010 | 0 | 61 | 571.13518
ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.03.2010 | 30.06.2010 | 0 | 61 | 666.79
ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2010 | 30.06.2011 | 0 | 61 | 766.1
ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2011 | 31.12.9999 | 0 | 61 | 872.28
pw6542 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.07.2009 | 28.02.2010 | 0 | 65 | 800.93
pw6543 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.03.2010 | 30.06.2010 | 0 | 65 | 918.87
pw6544 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.07.2010 | 30.06.2011 | 0 | 65 | 1054.94
pw6545 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.07.2011 | 31.12.9999 | 0 | 65 | 1197.82
uuj5442 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2009 | 28.02.2010 | 0 | 62 | 546.86
uuj5443 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.03.2010 | 30.06.2010 | 0 | 62 | 632.35
uuj5444 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2010 | 30.06.2011 | 0 | 62 | 727.4
uuj5445 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2011 | 31.12.9999 | 0 | 62 | 829.93
 |  | Lookup Col A Code | uuj5445
 |  | Lookup Col J Code | 31.12.9999
 |  | Value | 829.93
 |  |  | 829.93
Spreadsheet: 08309c3a-e586-405e-bb2d-a80c26a2801e
Sheet: 6Inter O&M Entry

Intermittent O&M Costs Input
Alternative:
For each component, enter "Y" in the gray area in the year in which replacement, if any, will occur.
 |  |  |  |  |  |  |  | Year O&M Needed?  (Insert Y in year where O&M is needed.)
Component | Unit Cost | Unit | Quantity | Replacement Needed? (Years 1-5) | Replacement Needed? (Years 6-10) | Replacement Needed (Years 11-15) | Replacement Needed? (Years 16-20) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Spreadsheet: e9adab06-c0e5-4555-ba4c-c2c910590676
Sheet: Sheet1

COUNTY SUMMARY/NAMES ON CHECKLIST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2012-11-06 00:00:00 | Republican | Democrat | Undeclared | Total
Belknap County | 15830 | 10329 | 17114 | 43273
Carroll County | 11929 | 7144 | 16105 | 35178
Cheshire County | 13200 | 16840 | 23912 | 53952
Coos County | 5323 | 5984 | 8481 | 19788
Grafton County | 16518 | 18200 | 30015 | 64733
Hillsborough County | 81295 | 73066 | 110065 | 264426
Merrimack County | 31503 | 28767 | 41812 | 102082
Rockingham County | 69405 | 55728 | 87092 | 212225
Strafford County | 21133 | 26716 | 35484 | 83333
Sullivan County | 7539 | 7584 | 11844 | 26967
Totals | 273675 | 250358 | 381924 | 905957
BELKNAP COUNTY/NAMES ON CHECKLIST
 | Republican | Democrat | Undeclared | Total
Alton | 1817 | 669 | 1636 | 4122
Barnstead | 988 | 702 | 1436 | 3126
Belmont | 1801 | 1222 | 1682 | 4705
Center Harbor | 342 | 170 | 333 | 845
Gilford | 2218 | 1343 | 2265 | 5826
Gilmanton | 932 | 537 | 1098 | 2567
Laconia Wd1 | 645 | 351 | 703 | 1699
Laconia Wd2 | 583 | 485 | 510 | 1578
[NAME] | 491 | 489 | 351 | 1331
Laconia Wd4* | 529 | 447 | 659 | 1635
Laconia Wd5 | 415 | 421 | 620 | 1456
Laconia Wd6 | 810 | 539 | 763 | 2112
Meredith | 1803 | 999 | 2182 | 4984
New Hampton | 633 | 387 | 646 | 1666
Sanbornton | 784 | 631 | 852 | 2267
[NAME] | 1039 | 937 | 1378 | 3354
Totals | 15830 | 10329 | 17114 | 43273
CARROLL COUNTY/NAMES ON CHECKLIST
 | Republican | Democrat | Undeclared | Total
Albany | 144 | 137 | 246 | 527
[NAME] | 598 | 470 | 1041 | 2109
[NAME] | 188 | 86 | 257 | 531
Chatham | 81 | 40 | 134 | 255
Conway | 1582 | 1434 | 3251 | 6267
Eaton | 104 | 84 | 149 | 337
[NAME] | 273 | 173 | 568 | 1014
Freedom | 383 | 191 | 569 | 1143
Hale's Location# | 72 | 12 | 43 | 127
Hart's Location | 6 | 10 | 21 | 37
[NAME] | 199 | 188 | 436 | 823
[NAME] | 441 | 367 | 956 | 1764
Moultonborough | 1551 | 564 | 1636 | 3751
Ossipee | 1063 | 516 | 1254 | 2833
Sandwich | 401 | 385 | 353 | 1139
Tamworth | 552 | 479 | 826 | 1857
Tuftonboro | 866 | 282 | 793 | 1941
Wakefield | 1276 | 669 | 1547 | 3492
Wolfeboro | 2149 | 1057 | 2025 | 5231
Totals | 11929 | 7144 | 16105 | 35178
*waiting for correction from clerk
#received correction from clerk |  |  | updated: 11/30/12
Spreadsheet: 83126d1283181914-excel-2007-scheduling-due-dates-issue-scheduling
Sheet: Updated

Retailer | Retailer Type | Region | Address | City/Town | County | Postcode | Owner | Date of Visit | Due Date | Visitor | Priority Code
Shop 1 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2009-09-21 00:00:00 | 2010-09-21 00:00:00 | [NAME] | 1
Shop 2 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | Laurence | 2010-08-21 00:00:00 | 2011-08-21 00:00:00 | [NAME] | 2
Shop 3 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2008-02-21 00:00:00 | 2009-02-21 00:00:00 | [NAME] | 3
Shop 4 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2010-12-21 00:00:00 | 2010-09-01 00:00:00 | [NAME] | 2
Shop 5 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2010-06-21 00:00:00 | 2011-06-21 00:00:00 | [NAME] | 3
Shop 6 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | Greg | 2007-02-21 00:00:00 | 2008-02-21 00:00:00 | [NAME] | 1
Shop 7 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2007-02-21 00:00:00 | 2008-02-21 00:00:00 | [NAME] | 1
Shop 8 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2009-08-21 00:00:00 | 2010-08-21 00:00:00 | [NAME] | 2
Shop 9 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2009-09-21 00:00:00 | 2010-09-21 00:00:00 | [NAME] | 3
Shop 10 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2010-12-21 00:00:00 | 2010-09-01 00:00:00 | [NAME] | 2
Shop 11 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2010-06-21 00:00:00 | 2011-06-21 00:00:00 | [NAME] | 3
Shop 12 | National Account | North East | 123 Test Street | Bedford | Bedfordshire | NE1 1NE | [NAME] | 2007-02-21 00:00:00 | 2008-02-21 00:00:00 | [NAME] | 1
Spreadsheet: ebbadbc7-92ba-4567-98c1-f5eccd330eef
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42772869 | 2014-08-18 06:30:02 | ALLIES | 0 | 0 | 4 | 1605687 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42828561 | 2014-08-22 07:48:10 | ALLIES | 0 | 4 | 6 | 676870 | Carlin | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42856285 | 2014-08-24 06:41:17 | AXIS | 0 | 4 | 6 | 1520724 | [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42913478 | 2014-08-28 06:09:35 | AXIS | 1 | 7 | 5 | 1594070 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42913703 | 2014-08-28 06:32:03 | ALLIES | 1 | 7 | 4 | 1594070 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 72357d1273042913-conditional-formatting-scheduledoc
Sheet: Secondary Worksheet

Row 4 - Source Wksh | loser
Row 5 - Source Wksh | loser
Row 6 - Source Wksh | loser
Row 7 - Source Wksh | winner
Course Name | Course Code | Semester | Category | Site | Min pers | [NAME] | Training days | Start Date | Finish Date | Application Close date | Late Application date | Company X | Company Y | Company Z | Other | Total
loser | My intention is that any outcome that does not conform to the logic statement will return a blank line, which I can then manually go thru and hide.
loser
loser
Course A | 123456 | Autumn | Networks | South | 4 | 8 | 10 | 2010-05-03 00:00:00 | 2010-05-15 00:00:00 | 2010-04-03 00:00:00 | 2010-04-26 00:00:00 | 0 | 4 | 2 | 2 | 8
Course A | 123456 | Winter | Networks | City | 4 | 8 | 10 | 2010-07-28 00:00:00 | 2010-07-15 00:00:00 | 2010-06-28 00:00:00 | 2010-07-21 00:00:00 | 2 | 0 | 4 | 2 | 8
loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser | loser
Course A
loser