tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b760df06-266e-43c0-87f4-e8c587ac5459
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
35847497 | 2013-05-08 15:13:01 | AXIS | 1 | 5 | 4 | 1204546 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
35847831 | 2013-05-08 15:42:31 | ALLIES | 1 | 5 | 3 | 1204546 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
35860427 | 2013-05-09 12:10:21 | AXIS | 0 | 2 | 7 | 828272 | hester24 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
35860685 | 2013-05-09 12:30:33 | ALLIES | 1 | 7 | 3 | 828272 | hester24 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
35864443 | 2013-05-09 18:36:29 | AXIS | 0 | 6 | 7 | 578329 | Valentin de Ramillies | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
35864890 | 2013-05-09 19:05:54 | ALLIES | 1 | 7 | 5 | 578329 | Valentin de Ramillies | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
35910660 | 2013-05-12 18:25:00 | AXIS | 1 | 5 | 3 | 752090 | lespieuch | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
35910974 | 2013-05-12 18:54:03 | ALLIES | 1 | 5 | 4 | 752090 | lespieuch | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
Spreadsheet: 769077d1645280459-30-day-moving-total-starting-with-today-sums-based-on-dates-and-weeknumbers-barksato-
Sheet: PersonOnsite_data

Present Exported Data |  | Location Name: | Site1 |  |  | Client Name: | Acme
week# | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 7 | 7 | 7 | 7
date | 02/19/22 | 02/18/22 | 02/17/22 | 02/16/22 | 02/15/22 | 02/14/22 | 02/13/22 | 02/12/22 | 02/11/22 | 02/10/22 | 02/09/22
Person 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1
Person 2 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1
Person 3 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Person 4 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1
Person 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1
Person 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | 0 | 94819 | 0 | 41820
Cross-Currency Fixed-Fixed | 0 | 3030 | 0 | 3310
Cross-Currency Fixed-Float | 0 | 17273 | 0 | 12979
TOTAL | -
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: MX55 TYK

 |  |  |  |  | MX55 TYK
Registration number : | MX55 TYK |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | IVECO |  | 2010-06-10 00:00:00 | 12 Months | 2011-06-01 00:00:00 | 200 | LGV
Specification : | DAILY 35 C12 |  | 2011-05-31 00:00:00 | 12 Months | 2012-06-01 00:00:00 | 210 | LGV
Type : | LWB PICK UP
1st Registered : | 03.11.05
Engine : | 2300 cc
[NAME] : | unkown
Back To Index
Spreadsheet: jonathan_mckay__16900__Area Managers
Sheet: Huntington

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Huntington Hills Community Association |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 1360.84
 | February | 0 | 993.74
 | March | 0 | 1076.87
 | April | 0 | 844.05
 | May | 0 | 234.9
 | June | 0 | 130.76
 | July | 0 | 46.54
 | August | 0 | 97.83
 | September | 0 | 574.36
 | October | 0 | 769.04
 | November | 0 | 1024.75
 | December | 0 | 1180.09
 | TOTAL:
Spreadsheet: dana_davis__4474__CANADA - 46L - A
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 46L
COMPANY NAME:  SUNDANCE ECT CANADA ACCOUNTING ENTITY
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 3 MONTHS ENDED 3-31-2000
PREPARED BY:  ROSALYN LUM
EXTENSION: [PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-99 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 698104d1601746999-criteria-based-ranking-test
Sheet: Test

 |  |  |  |  |  |  |  | 2020-04-15 00:00:00
Item | Price | Category | Date | Except | Rank | Desired Rank
CTR_01 | 3.5 | Urgent | 2020-04-06 00:00:00 | [NAME] |  | 1
[NAME] | 3.2 | Not Urgent | 2020-04-05 00:00:00 |  |  |  |  |  |  | * Rank 1 is to be given for XXX & YYY items (in col. E), then ranking is to be done of only urgent item based on there price and date
CTR_03 | 3.44 | Not Urgent | 2020-04-06 00:00:00
CTR_08 | 3.5 | Urgent | 2020-05-11 00:00:00 | [NAME] |  | 2
CTR_18 | 3.44 | Urgent | 2020-04-21 00:00:00 |  |  | 3
CTR_06 | 3.41 | Urgent | 2020-04-21 00:00:00 |  |  | 4
CTR_07 | 3.2 | Urgent | 2020-04-06 00:00:00
CTR_17 | 3.2 | Urgent | 2020-04-20 00:00:00 |  |  | 5
CTR_09 | 3 | Not Urgent | 2020-04-12 00:00:00
CTR_10 | 2.1 | Not Urgent | 2020-04-06 00:00:00 | YYY |  | 1
CTR_11 | 3.4 | Not Urgent | 2020-05-14 00:00:00
CTR_12 | 3.2 | Not Urgent | 2020-04-15 00:00:00
CTR_13 | 3.44 | Not Urgent | 2020-04-16 00:00:00
CTR_14 | 3 | Not Urgent | 2020-04-17 00:00:00
CTR_15 | 2.1 | Not Urgent | 2020-04-18 00:00:00
CTR_16 | 3.4 | Not Urgent | 2020-04-19 00:00:00
CTR_04 | 3 | Urgent | 2020-04-06 00:00:00
CTR_19 | 3 | Urgent | 2020-04-06 00:00:00
CTR_05 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 6
CTR_20 | 2.1 | Urgent | 2020-04-23 00:00:00 |  |  | 6
Spreadsheet: 883824d1732548525-array-formula-to-exclude-aggregate-if-value-in-col-g-is-one-of-two-values-array-formula
Sheet: HR Report

Start Date | 2024-10-01 00:00:00
End Date | 2024-12-31 00:00:00
DSR REF No. | Date Received | DSR Type | Requester | Location
Spreadsheet: 7616e380-dcd8-4b88-85de-cb1d01d83ef9
Sheet: Net Rev Q1 2011

GAAP to Non-GAAP Reconciliation
Net Revenues to Organic Net Revenues
For the Three Months Ended March 31,
($ in millions, except percentages) ([NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  | % Change
 | As Reported (GAAP) |  | Impact of [NAME] (1) |  | Impact of Acquisitions (2) |  | Impact of Accounting Calendar Changes |  | Impact of Currency |  | Organic (Non-GAAP) (3) |  |  | As Reported (GAAP) |  | Organic (Non-GAAP) (3)
2011
Kraft Foods Europe | 3016 |  | 0 |  | -201 |  | 0 |  | 12
2010
Kraft Foods Europe | 2709 |  | 0 |  | 0 |  | 0 |  | 0
(1)  Impact of divestitures includes Starbucks CPG business.
(2)  Impact of acquisitions reflects the incremental January 2011 operating results from our Cadbury acquisition.
(3)  Organic net revenues and corresponding growth ratios exclude the impacts of acquisitions, divestitures (including the Starbucks CPG business), currency and
and accounting calendar changes.
Spreadsheet: 722485d1615294595-formulas-stopped-working-in-two-columns-when-nothing-has-changed-test-file-sanitised
Sheet: Statistics

Dummy data
Product
NOODP004
Time Period | Quantity | Weeks in Store | Storage Cost | Product | Avg Total
WK1
WK2
WK6
WK8
WK9
Year to Date
Spreadsheet: 68d3df89-2f6f-4dd4-805d-c899e2037cc1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Table S11. [NAME] Used in This Study
ID | population
NA06994 | CEU
NA07000 | CEU
NA07034 | CEU
NA07055 | CEU
NA07345 | CEU
NA07357 | CEU
NA11829 | CEU
NA11831 | CEU
NA11832 | CEU
NA11839 | CEU
NA11840 | CEU
NA11881 | CEU
NA11882 | CEU
NA11992 | CEU
NA11994 | CEU
NA11995 | CEU
NA12004 | CEU
NA12005 | CEU
NA12006 | CEU
NA12043 | CEU
NA12057 | CEU
NA12144 | CEU
NA12145 | CEU
NA12146 | CEU
NA12154 | CEU
NA12156 | CEU
NA12234 | CEU
NA12717 | CEU
NA12751 | CEU
NA12760 | CEU
NA12761 | CEU
NA12762 | CEU
NA12763 | CEU
NA12812 | CEU
NA12813 | CEU
NA12814 | CEU
NA12815 | CEU
NA12872 | CEU
NA12873 | CEU
NA12874 | CEU
NA12875 | CEU
NA12891 | CEU
NA12892 | CEU
NA18501 | YRI
NA18505 | YRI
NA18508 | YRI
NA18516 | YRI
NA18517 | YRI
NA18522 | YRI
NA18523 | YRI
NA18852 | YRI
NA18855 | YRI
NA18859 | YRI
NA18862 | YRI
NA18871 | YRI
NA18912 | YRI
NA19093 | YRI
NA19098 | YRI
NA19099 | YRI
NA19102 | YRI
NA19116 | YRI
NA19119 | YRI
NA19127 | YRI
NA19128 | YRI
NA19131 | YRI
NA19137 | YRI
[NAME] | YRI
NA19140 | YRI
NA19141 | YRI
NA19143 | YRI
NA19144 | YRI
NA19152 | YRI
NA19153 | YRI
NA19159 | YRI
NA19160 | YRI
NA19171 | YRI
NA19200 | YRI
NA19201 | YRI
NA19203 | YRI
NA19206 | YRI
NA19207 | YRI
NA19209 | YRI
NA19210 | YRI
NA19222 | YRI
NA19223 | YRI
NA19239 | YRI
Spreadsheet: 471031d1468846364-automate-column-row-cell-copy-pasting-sample
Sheet: Sheet1

Before |  |  |  |  | After
Test1 | Word1 | Word2 | Word3 |  | Test1 | Word1
Test2 | Word4 | Word5 | Word6 |  | Test1 | Word2
Test3 | Word7 | Word8 | Word9 |  | Test1 | Word3
 |  |  |  |  | Test2 | Word4
 |  |  |  |  | Test2 | Word5
 |  |  |  |  | Test2 | Word6
 |  |  |  |  | Test3 | Word7
 |  |  |  |  | Test3 | Word8
 |  |  |  |  | Test3 | Word9
Spreadsheet: 841690d1693859892-excel-formula-for-producing-student-report-student-progress-report
Sheet: Progress Report

 | Kindly asking for excel formula to produce academic progress report as shown on the desired solution using information on database sheet
 | ACADEMIC PROGRESS REPORT
 | Desired solution
 | Select student I.D on Cell B8
 | BHA234 | Name
 |  | Class
 | END OF SECOND TERM 2023
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 |  | 53 | 97 | A | Excellent performance | [NAME]
 | Accounting | 60 | 80 | A | This is good performance. | [NAME]
 | Agriculture | 66 | 49 | D | Work hard | [NAME]
 | Biology | 62 | 90 | A | This is a splendiferous performance | [NAME]
 | B.Studies | 54 | 70 | B | Work hard | A. Mpala
 | English | 66 | 86 | A | A hardworking student | [NAME]
 | Geography | 61 | 93 | A | Good work | A. Mpala
 | FRS | 70 | 98 | A | Excellent work | [NAME]
 | Woodwork | 50 | 80 | A | Best student | [NAME]
 | Number of subjects recorded: |  |  | Passed : | 8
Spreadsheet: 66167d1266873637-find-employee-who-worked-more-than-x-hours-dummy
Sheet: Sheet1

employee | date | shift type | hrs worked
tom | 2001-01-01 00:00:00 | A | 5
[NAME] | 2002-01-01 00:00:00 | A | 5
jenny | 2002-01-01 00:00:00 | A | 5
kenny | 2003-01-01 00:00:00 | F | 4
tom | 2004-01-01 00:00:00 | F | 4
jenny | 2005-01-01 00:00:00 | B | 2
jenny | 2007-01-01 00:00:00 | C | 3
jenny | 2009-01-01 00:00:00 | C | 3
kenny | 2012-01-01 00:00:00 | A | 5
kenny | 2014-01-01 00:00:00 | D | 5.5
tom | 2014-01-01 00:00:00 | D | 5.5
jenny | 2015-01-01 00:00:00 | A | 5
[NAME] | 2017-01-01 00:00:00 | E | 3.5
[NAME] | 2020-01-01 00:00:00 | E | 3.5
 |  |  |  |  | how do I find out at once (at glance) which employee worked more than 10 hours?
Spreadsheet: 692814d1598584387-certain-cells-are-not-displaying-the-data-phonelist-ver-2-test
Sheet: Directory

DIRECTORY
 | # | Name | WORK PHONE |  | # | Name | WORK PHONE
 | 1
 | # | Name | Phone |  | # | Name | Phone
Spreadsheet: 833623d1687152653-working-days-excluding-weekends-and-uk-bank-holidays-pq-bank-holidays-uk-aligw
Sheet: Bank Holidays 2023-25

Date | Day of the week | Bank holiday
2023-01-02 00:00:00 | Monday | New Year’s Day (substitute day)
2023-04-07 00:00:00 | Friday | Good Friday
2023-04-10 00:00:00 | Monday | Easter Monday
2023-05-01 00:00:00 | Monday | Early May bank holiday
2023-05-08 00:00:00 | Monday | Bank holiday for the coronation of King [NAME]
2023-05-29 00:00:00 | Monday | Spring bank holiday
2023-08-28 00:00:00 | Monday | Summer bank holiday
2023-12-25 00:00:00 | Monday | Christmas Day
2023-12-26 00:00:00 | Tuesday | Boxing Day
2024-01-01 00:00:00 | Monday | New Year’s Day
2024-03-29 00:00:00 | Friday | Good Friday
2024-04-01 00:00:00 | Monday | Easter Monday
2024-05-06 00:00:00 | Monday | Early May bank holiday
2024-05-27 00:00:00 | Monday | Spring bank holiday
2024-08-26 00:00:00 | Monday | Summer bank holiday
2024-12-25 00:00:00 | Wednesday | Christmas Day
2024-12-26 00:00:00 | Thursday | Boxing Day
2025-01-01 00:00:00 | Wednesday | New Year’s Day
2025-04-18 00:00:00 | Friday | Good Friday
2025-04-21 00:00:00 | Monday | Easter Monday
2025-05-05 00:00:00 | Monday | Early May bank holiday
2025-05-26 00:00:00 | Monday | Spring bank holiday
2025-08-25 00:00:00 | Monday | Summer bank holiday
2025-12-25 00:00:00 | Thursday | Christmas Day
2025-12-26 00:00:00 | Friday | Boxing Day
Spreadsheet: 116213d1311682293-selective-columns-shendish-manor
Sheet: Mt

[NAME]. T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 138219d1327574798-excel-2007-pivot-chart-cant-filter-values-sample
Sheet: Summary Report

Region | UK
 | Values
Month | Idle assets | Und. Repair | Awaiting for deployment | Awaiting for destruction | To be - sold | Unknwn. location
January | 1000
February | 1600
March | 436
April | 475
May | 436
June | 647
July | 473
August | 360
September | 754
October | 360 | 113 | 100 | 19 | 120 | 150
November | 754
December | 1050
Spreadsheet: 67365d1268000754-finding-equation-and-trendline-from-two-variant-table-720807-interpolation
Sheet: Sheet1

 | Strength
Surface Roughness | 300 | 400 | 500 | 600 | 700 | 800 | 1000
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
5 | 1 | 0.99 | 0.985 | 0.98 | 0.975 | 0.972 | 0.97
10 | 0.97 | 0.96 | 0.95 | 0.94 | 0.935 | 0.937 | 0.93
20 | 0.93 | 0.92 | 0.91 | 0.9 | 0.89 | 0.885 | 0.88
30 | 0.91 | 0.9 | 0.88 | 0.86 | 0.84 | 0.82 | 0.78
50 | 0.8 | 0.76 | 0.67 | 0.61 | 0.56 | 0.51 | 0.43
Strength | 550
Surface State | 15
Modulus | 0.9249999999999999
Spreadsheet: 710076d1608711505-populate-a-named-range-by-looking-up-a-pivot-table-pivottest
Sheet: Data

Consequence | Severity Description | Severity Number
Consequence1 | Very High | 5
Consequence1 | High | 4
Consequence1 | Medium | 3
Consequence1 | Low | 2
Consequence1 | Very Low | 1
Consequence2 | Very High | 5
Consequence2 | High | 4
Consequence2 | Medium | 3
Consequence2 | Low | 2
Consequence2 | Very Low | 1
Consequence3 | Very High | 5
Consequence3 | High | 4
Consequence3 | Medium | 3
Consequence3 | Low | 2
Consequence3 | Very Low | 1
Consequence4 | Very High | 5
Consequence4 | High | 4
Consequence4 | Medium | 3
Consequence4 | Low | 2
Consequence4 | Very Low | 1
Consequence5 | Very High | 5
Consequence5 | High | 4
Consequence5 | Medium | 3
Consequence5 | Low | 2
Consequence5 | Very Low | 1
Spreadsheet: 706665d1606825955-sorting-a-list-accordiong-to-total-value-and-variance-book1-1-
Sheet: Sheet1

 | C | 4 | 4 | 4 | 12
 | D | 4 | 4 | 4 | 12
 | E | 4 | 4 | 4 | 12
 | F | 4 | 4 | 4 | 12
 | G | 4 | 4 | 4 | 12
 | H | 4 | 4 | 4 | 12
 | I | 4 | 4 | 4 | 12
 | J | 4 | 4 | 4 | 12
 | K | 4 | 4 | 4 | 12
 | L | 4 | 4 | 4 | 12
 | M | 4 | 4 | 4 | 12
 | Q | 4 | 4 | 4 | 12
 | R | 4 | 4 | 4 | 12
 | X | 4 | 4 | 4 | 12
 | Y | 4 | 4 | 4 | 12
 | B | 5 | 4 | 3 | 12
 | N | 5 | 4 | 3 | 12
 | O | 5 | 3 | 4 | 12
 | P | 4 | 5 | 3 | 12
 | S | 5 | 4 | 3 | 12
 | T | 5 | 3 | 4 | 12
 | U | 5 | 3 | 4 | 12
 | V | 3 | 5 | 4 | 12
 | W | 4 | 5 | 3 | 12
 | Z | 5 | 4 | 3 | 12
 | A | 4 | 5 | 3 | 12
Spreadsheet: 870456d1716970348-simplifying-excel-equation-simple-test
Sheet: Rules

Branches List | Dimensions |  | Min Qty
Branch 1 | -1.00 to -6.00 |  | 2
Branch 2 |  |  | 2
Branch 3 |  |  | 2
Branch 4 |  |  | 2
Branch 5 |  |  | 2
Branch 6 |  |  | 2
Branch 7 |  |  | 2
Branch 8 |  |  | 2
Branch 9 |  |  | 2
Branch 10 |  |  | 2
Branch 11 |  |  | 2
Branch 12 |  |  | 2
Branch 13 |  |  | 2
Branch 14 |  |  | 2
Branch 15 |  |  | 2
Branch 16 |  |  | 2
Branch 17 |  |  | 2
Branch 18 |  |  | 2
Branch 19 |  |  | 2
Branch 20 |  |  | 2
Branch 21 |  |  | 2
Branch 22 |  |  | 2
Branch 23 |  |  | 2
Branch 24 |  |  | 2
Branch 25 |  |  | 2
Branch 26 |  |  | 2
Branch 27 |  |  | 2
Branch 28 |  |  | 2
Branch 29 |  |  | 2
Branch 30 |  |  | 2
Branch 31 |  |  | 2
Branch 32 |  |  | 2
Branch 33 |  |  | 2
Branch 34 |  |  | 2
Branch 35 |  |  | 2
Branch 36 |  |  | 2
Branch 37 | -1.00 to -5.00 |  | 1
Branch 38 |  |  | 1
Branch 39 |  |  | 1
Branch 40 |  |  | 1
Branch 41 |  |  | 1
Branch 42 |  |  | 1
Branch 43 |  |  | 1
Branch 44 |  |  | 1
Branch 45 |  |  | 1
Branch 46 |  |  | 1
Branch 47 |  |  | 1
Branch 48 |  |  | 1
Branch 49 |  |  | 1
Branch 50 |  |  | 1
Branch 51 |  |  | 1
Branch 52 |  |  | 1
Branch 53 |  |  | 1
Branch 54 |  |  | 1
Branch 55 |  |  | 1
Branch 56 |  |  | 1
Branch 57 |  |  | 1
Branch 58 |  |  | 1
Branch 59 |  |  | 1
Branch 60 |  |  | 1
Branch 61 |  |  | 1
Branch 62 |  |  | 1
Branch 63 |  |  | 1
Branch 64 |  |  | 1
Branch 65 |  |  | 0
Spreadsheet: 850637d1701049188-kind-of-reverse-index-match-mosom-8
Sheet: Sheet1

 |  |  |  |  | Role 1 | Role 2 | Role 3 | Role 4 | Role 5
Topic 1 | Module 1 | Area 1 | Focus 1 |  | Yes | Yes | Yes | Yes | No |  |  |  |  | Scenario 1
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | Yes | No | No |  |  |  |  | When I select in a new cell from a drop down list of all "text fields":
Topic 1 | Module 1 | Area 1 |  |  | No | Yes | No | No | Yes |  |  |  |  | eg | text field 5
Topic 1 | Module 1 | Area 2 | Focus 1 |  | Yes | Yes | No | No | Yes
Topic 1 | Module 1 | Area 2 | Focus 2 |  | No | N/A | Yes | Yes | No |  |  |  |  | It will display next to it the leading row part and the column heading, with cell spacers:
Topic 1 | Module 1 | Summary |  |  | text field 1 | text field 2 | text field 3 | text field 4 | text field 5 |  |  |  |  | eg | Topic 1 | Module 1 | Summary |  | Role 5
Topic 1 | Module 2 | Area 1 | Focus 1 |  | Yes | No | No | Yes | Yes
Topic 1 | Module 2 | Area 1 | Focus 2 |  | N/A | No | Yes | Yes | Yes |  |  |  |  | So it will look like this:
Topic 1 | Module 2 | Area 2 | Focus 1 |  | N/A | Yes | Yes | Yes | No |  |  |  |  |  | text field 5
Topic 1 | Module 2 | Area 3 | Focus 1 |  | No | Yes | Yes | Yes | No
Topic 1 | Module 2 | Area 3 | Focus 2 |  | Yes | N/A | Yes | No | Yes
Topic 1 | Module 2 | Summary |  |  | text field 6 | text field 7 | text field 8 |  | text field 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | List all text fields and the info, as above
 |  |  |  |  |  |  |  |  |  |  |  |  |  | eg | text field 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text field 10
Spreadsheet: 232158d1367343093-sumif-help-clean
Sheet: Yearly Calender 

 | Schedule Net Working Days
 | Month |  |  | Week Days | Net Days | Holiday | Holiday |  | Date
 | 2013-01-01 00:00:00 |  |  |  |  |  | New Years Day |  | 2013-01-01 00:00:00
 | 2013-02-01 00:00:00 |  |  |  |  |  | Family Day |  | 2013-02-18 00:00:00
 | 2013-03-01 00:00:00 |  |  |  |  |  | Good Friday |  | 2013-03-29 00:00:00
 | 2013-04-01 00:00:00 |  |  |  |  |  | [NAME] |  | 2013-05-20 00:00:00
 | 2013-05-01 00:00:00 |  |  |  |  |  | Canada Day |  | 2013-07-01 00:00:00
 | 2013-06-01 00:00:00 |  |  |  |  |  | Labour Day |  | 2013-09-02 00:00:00
 | 2013-07-01 00:00:00 |  |  |  |  |  | Thanksgiving |  | 2013-10-14 00:00:00
 | 2013-08-01 00:00:00 |  |  |  |  |  | Christmas Day |  | 2013-12-25 00:00:00
 | 2013-09-01 00:00:00 |  |  |  |  |  | Boxing Day |  | 2013-12-26 00:00:00
 | 2013-10-01 00:00:00 |  |  |  |  |  | New Years Day |  | 2014-01-01 00:00:00
 | 2013-11-01 00:00:00 |  |  |  |  |  | Family Day |  | 2014-02-17 00:00:00
 | 2013-12-01 00:00:00 |  |  |  |  |  | Good Friday |  | 2014-04-18 00:00:00
 | 2014-01-01 00:00:00 |  |  |  |  |  | Easter Monday |  | 2014-04-21 00:00:00
 | 2014-02-01 00:00:00 |  |  |  |  |  | [NAME] |  | 2014-05-19 00:00:00
 | 2014-03-01 00:00:00 |  |  |  |  |  | Canada Day |  | 2014-07-01 00:00:00
 | 2014-04-01 00:00:00 |  |  |  |  |  | Labour Day |  | 2014-09-01 00:00:00
 | 2014-05-01 00:00:00 |  |  |  |  |  | Thanksgiving |  | 2014-10-13 00:00:00
 | 2014-06-01 00:00:00 |  |  |  |  |  | Christmas Day |  | 2014-12-25 00:00:00
 | 2014-07-01 00:00:00 |  |  |  |  |  | Boxing Day |  | 2014-12-26 00:00:00
 | 2014-08-01 00:00:00 |  |  |  |  |  | New Years Day
 | 2014-09-01 00:00:00 |  |  |  |  |  | Family Day
 | 2014-10-01 00:00:00 |  |  |  |  |  | Good Friday
 | 2014-11-01 00:00:00 |  |  |  |  |  | Easter Monday
 | 2014-12-01 00:00:00 |  |  |  |  |  | [NAME]
 | 2015-01-01 00:00:00 |  |  |  |  |  | Canada Day
 | 2015-02-01 00:00:00 |  |  |  |  |  | Labour Day
 | 2015-03-01 00:00:00 |  |  |  |  |  | Thanksgiving
 | 2015-04-01 00:00:00 |  |  |  |  |  | Christmas Day
 | 2015-05-01 00:00:00 |  |  |  |  |  | Boxing Day
 | 2015-06-01 00:00:00
 | 2015-07-01 00:00:00
 | 2015-08-01 00:00:00
 | 2015-09-01 00:00:00
 | 2015-10-01 00:00:00
 | 2015-11-01 00:00:00
 | 2015-12-01 00:00:00
 | 2016-01-01 00:00:00
Spreadsheet: 823848d1680173419-selecting-specific-time-values-time-before
Sheet: Sheet1

 |  | Date | C/I | C/O | Actual | Scheduled | Night
 |  | 1 | 10:00:00 | 19:00:00
 |  | 2
 |  | 3 | 22:00:00 | 06:00:00
 |  | 4 | 23:35:00 | 08:00:00
 |  | 5
 |  | 6
 |  | 7 | 16:00:00 | 00:33:00
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | Total