tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25406__VisuPro DataBases for Ewb1_5s
Sheet: ErStat

VisuPro - Turbine type: Ewb1.5s |  |  | 2001-02-28 00:00:00
File Name: |  | ErStat.db
Table Description: |  | Fault Statistics
Field | Field | Field | Field | Field
Number | Name | Description | Type | Size
1 | Index | Autoincrement | [NAME]
2 | [NAME] | Plant number | Alpha | 10
3 | Datum | Date | Date
4 | Uhrzeit | Time | Time
5 | Fehler-Nummer | Fault number | [NAME]
6 | Fehlertext | Fault description | Alpha | 40
7 | Anzahl | Number of points | [NAME]
8 | Ausfallzeit | Downtime | Alpha | 12
9 | [NAME] | Active | Logical (T/F)
Spreadsheet: 843156d1695103083-issue-with-dependent-combo-box-when-one-content-list-is-shorter-than-others-sample-combo-box-issue
Sheet: Formula

Assignee | Priority | Phase |  | Criteria | Dev | App Link | Content
 |  |  |  |  | 1 | 10 |  |  |  |  |  |  | For query:
Assignee B | Low | Close
Assignee C | Medium | Design
Assignee D | 0 | Rollout |  |  |  |  |  |  |  |  |  |  | For query:
Assignee E |  | Test
Assignee F |  | 0
Assignee G
Assignee H
Assignee I
Assignee J
Spreadsheet: 673759d1587523531-advanced-filter-to-extracted-data-for-a-date-range-advanced-filter-by-date
Sheet: Extracted Data

Stock No. | Invoice | Type | Code | Description | Date | Value |  |  |  |  |  |  |  |  |  |  | Code | Date | Value
MAJGXXMTKGKU43229 | 17315 | Replenishment | ABL-1 | Shirt B M | 2020-03-11 00:00:00 | 11842 |  |  |  |  |  |  |  |  |  |  | ABL-1 | 2020-03-08 00:00:00 | 84877
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-03-11 00:00:00
Spreadsheet: 103600d1301345602-list-matching-values-example
Sheet: Sheet1

Name | Location | ID | Code |  | A Serise
Person 1 | Here | 1 | A1 |  | Person 1 | Here | 1 | A1
Person 2 | Here | 2 | A2 |  | Person 2 | Here | 2 | A2
Person 3 | Here | 3 | A3 |  | Person 3 | Here | 3 | A3
Person 4 | Here | 4 | A4 |  | Person 4 | Here | 4 | A4
Person 5 | Here | 5 | A5 |  | Person 5 | Here | 5 | A5
Person 6 | Here | 6 | A6 |  | Person 6 | Here | 6 | A6
Person 7 | Here | 7 | A7 |  | Person 7 | Here | 7 | A7
Person 8 | Here | 8 | A8 |  | Person 8 | Here | 8 | A8
Person 9 | Here | 9 | A9 |  | Person 9 | Here | 9 | A9
Person 10 | Here | 10 | A10 |  | Person 10 | Here | 10 | A10
Person 11 | Here | 11 | A11 |  | Person 11 | Here | 11 | A11
Person 12 | Here | 12 | A12 |  | Person 12 | Here | 12 | A12
Person 13 | Here | 13 | A13 |  | Person 13 | Here | 13 | A13
Person 14 | Here | 14 | A14 |  | Person 14 | Here | 14 | A14
Person 15 | Here | 15 | A15 |  | Person 15 | Here | 15 | A15
Person 16 | There | 16 | B1
Person 17 | There | 17 | B2 |  | B Serise
Person 18 | There | 18 | B3 |  | Person 16 | There | 16 | B1
Person 19 | There | 19 | B4 |  | Person 17 | There | 17 | B2
Person 20 | There | 20 | B5 |  | Person 18 | There | 18 | B3
Person 21 | There | 21 | B6 |  | Person 19 | There | 19 | B4
Person 22 | There | 22 | B7 |  | Person 20 | There | 20 | B5
Person 23 | There | 23 | B8 |  | Person 21 | There | 21 | B6
Person 24 | There | 24 | B9 |  | Person 22 | There | 22 | B7
Person 25 | There | 25 | B10 |  | Person 23 | There | 23 | B8
Person 26 | There | 26 | B11 |  | Person 24 | There | 24 | B9
Person 27 | There | 27 | B12 |  | Person 25 | There | 25 | B10
Person 28 | There | 28 | B13 |  | Person 26 | There | 26 | B11
Person 29 | There | 29 | B14 |  | Person 27 | There | 27 | B12
Person 30 | There | 30 | B15 |  | Person 28 | There | 28 | B13
 |  |  |  |  | Person 29 | There | 29 | B14
 |  |  |  |  | Person 30 | There | 30 | B15
Spreadsheet: 30407d1225909099-tracking-man-days-over-months-book4
Sheet: LOOKUP TABLE

 | Project Type | Days Required Per Week
 | 1 | 3
 | 2 | 1
 | 3 | 2
 | 4 | 2
 | 5 | 5
 | 6 | 4
 | 7 | 5
 | 8 | 4
 | 9 | 5
 | 10 | 5
 | 11 | 3
 | 12 | 1
 | 13 | 1
 | 14 | 1
 | 15 | 2
 | * FIGURES ARE APPROXIMATE
Spreadsheet: benjamin_rogers__906__BR New York Ticker 10_01
Sheet: SPREADS

 | Nymex Bid | Nymex Offer | Nymex Delta |  | [NAME] | [NAME] | PJM Delta | HR Bid | HR Offer | HR Delta |  | NEPOOL Bid | NEPOOL Offer | NEPOOL Delta | HR Bid | HR Offer | HR Delta |  |  |  |  |  | PJM Close | NY Zone A Close | [NAME] | NY Zone J Close | NEPOOL Close | Nymex Close |  |  | PJM Close | NY Zone A Close | [NAME] | NY Zone J Close | NEPOOL Close | Nymex Close
Sep-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep-01 |  |  |  |  |  |  |  | Sep-01
Oct-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct-01 |  |  |  |  |  |  |  | Oct-01
Q4-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4-01 |  |  |  |  |  |  |  | Q4-01
Jan-Feb 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan-Feb 02 |  |  |  |  |  |  |  | Jan-Feb 02
[NAME] 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 02 |  |  |  |  |  |  |  | [NAME] 02
May-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May-02 |  |  |  |  |  |  |  | May-02
Jun-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun-02 |  |  |  |  |  |  |  | Jun-02
Jul-Aug 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul-Aug 02 |  |  |  |  |  |  |  | Jul-Aug 02
Sep-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep-02 |  |  |  |  |  |  |  | Sep-02
Q4-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q4-02 |  |  |  |  |  |  |  | Q4-02
Jan-Dec 02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan-Dec 02 |  |  |  |  |  |  |  | Jan-Dec 02
Nov-Mar |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov-Mar |  |  |  |  |  |  |  | Nov-Mar
 | NY Zone A Bid | NY Zone A Offer | NY Zone A Delta | HR Bid | HR Offer | HR Delta |  | [NAME] | [NAME] | NY Zone G Delta | HR Bid | HR Offer | HR Delta |  | NY Zone J Bid | NY Zone J Offer | [NAME] J Delta | HR Bid | HR Offer | HR Delta
Next Day
Next Next Day
Next Week
[NAME]
[NAME] 02
May-02
Jun-02
Jul-Aug 02
Sep-02
Q4-02
Jan-Dec 02
 | Zone A - PJM Bid | Zone A - PJM Offer | Zone A - PJM Delta |  | [NAME] A Bid | [NAME] A Offer | [NAME] A Delta |  | Zone J - Zone G Bid | Zone J - Zone G Offer | Zone J - Zone G Delta |  | [NAME] Bid | [NAME] Offer | [NAME] Delta
Sep-01
Oct-01
Q4-01
Jan-Feb 02
[NAME] 02
May-02
Jun-02
Jul-Aug 02
Sep-02
Q4-02
Jan-Dec 02
Spreadsheet: 148024d1333105386-excel-2007-3-way-lookup-index-match
Sheet: Sheet2

Date | 2012-01-01 00:00:00
Spreadsheet: 227172b9-ed9d-4812-9ae4-3a69bdd4b94f
Sheet: Publishers (Fiction)

Publisher (Fiction) | Titles | Percentage
[NAME] | 30
AmazonCrossing | 29
Europa Editions | 15
American University at Cairo | 12
FSG | 10
Other Press | 10
Glagoslav Publications | 9
Seagull Books | 9
Open Letter | 8
Atria | 7
New Directions | 7
Houghton [NAME] | 6
Knopf | 6
Minotaur | 6
Vertical | 6
Archipelago | 5
[NAME] | 5
Northwestern University Press | 5
Pegasus | 5
Penguin | 5
Viking | 5
Bitter Lemon | 4
Columbia University Press | 4
Graywolf | 4
Grove | 4
[NAME] | 4
K A Nitz | 4
Melville House | 4
Pantheon | 4
[NAME] | 4
[NAME] | 4
Texas Tech University Press | 4
Tin House | 4
[NAME] | 4
Akashic Books | 3
Black Cat | 3
CreateSpace | 3
Glas | 3
HarperCollins | 3
Le French | 3
Soho Press | 3
St. Martin's | 3
Talonbooks | 3
Abacus | 2
[NAME] | 2
Counterpoint | 2
Garnet Publishing | 2
Hanging Loose Press | 2
[NAME] | 2
Indiana University Press | 2
Interlink | 2
Kurodahan Press | 2
New Press | 2
New York Review Books | 2
Overlook | 2
Riverhead | 2
Seven Stories Press | 2
[NAME] | 2
Skyscape | 2
Syracuse University Press | 2
Thames River Press | 2
University of Nebraska | 2
Wakefield Press | 2
Yale University Press | 2
[NAME] | 1
[NAME] | 1
Antibookclub | 1
Arcade | 1
Atlantic Monthly | 1
Autumn Hill | 1
Bellevue Literary Press | 1
Biblioasis | 1
Black Square Editions | 1
Bloomsbury | 1
Canongate | 1
Chelsea Editions | 1
City Lights | 1
Clockroot | 1
Contra Mundum Press | 1
Cosmos Publishing | 1
Cubanabooks | 1
[NAME] | 1
Doubleday | 1
[NAME] | 1
[NAME] | 1
Enigma Books | 1
Feminist Press | 1
Free Press | 1
[NAME] | 1
Haikasoru | 1
Hyperion | 1
Karolinum Press | 1
Light Messages | 1
Little, [NAME] | 1
Long River Press | 1
[NAME]'s Books | 1
Metropolitan | 1
MIT | 1
Mulholland Books | 1
[NAME] | 1
New Europe | 1
Nightboat Books | 1
Northern Illinois University Press | 1
Norvik Press | 1
Oneworld | 1
Owl Canyon Press | 1
Pella Publishing | 1
Penlight | 1
[NAME] | 1
Phoenix | 1
PM Press | 1
Real World Press | 1
Simon & Schuster | 1
[NAME] | 1
Stork Press | 1
Troubador | 1
Twisted Spoon Press | 1
University of Arizona Press | 1
University of Minnesota Press | 1
University of Virginia Press | 1
University of Western Australia | 1
University of Wisconsin | 1
Verso | 1
Vintage | 1
W.W. Norton | 1
White Pine | 1
Spreadsheet: 149150d1333722732-timesheet-overtime-calculation-timesheet-template
Sheet: Sheet1

 |  |  |  |  |  |  |  | TIMESHEET
EMPLOYEE: |  |  |  |  |  | PERIOD COVERED: |  | TO
 | DAY |  | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00
 | DATE |  | 2012-03-18 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-24 00:00:00
 | TIME IN |  | 08:05:00
 | TIME OUT |  | 11:38:00
 | TIME IN |  | 12:15:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FOR FINANCE USE ONLY
 | TIME OUT |  | 17:16:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS
 | REGULAR HRS |  | 7.99992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | OVERTIME HRS |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00
 |  |  | 2012-03-25 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | 2012-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | half-day
 |  | EMPLOYEE SIGNATURE |  |  | DATE |  | SUPERVISOR SIGNATURE |  | DATE |  |  |  |  |  | DATE
 | Goal of this timesheet:
 | Capture as much information as possible so that we can determine actual COGS, Indirect Production and R&D costs for future budgeting needs as well as for figuring out what real costs are between species and by tech.
 | Track good use of time, use electronically (each employee maintains their own workbook with a tab for each pay period), so that accounting can do calculations based on time usage
 | How to achieve this goal:
 | Activities separated, need to determine what activities we want to capture (the more info the better within reason, need to capture time spent to do recoveries versus fill tubes, do Inventory, etc)
 | Three separate lines to capture species by activity
 | Time in motion study once quarterly for two weeks to track exact behavior
Spreadsheet: 152865d1335556414-excel-2007-how-to-get-a-drop-down-menu-choice-to-change-adjacent-cells-example-price-list-for-excel-question
Sheet: Sheet1

Name | Product Code | MSRP | GBV Cost x .56 | Margin | Dealer Price | Dealer Margin | Retail
VS Single Tank  1 collector | EWRA1ST | 3000
VS Single Tank 2 collector | EWRA2ST | 3500
Teckmar | Product Code | MSRP | GBV Cost x .56 | Margin | Dealer Price | Dealer Margin | Retail
TK 1 collector | EWRA1 | 300
TK 2 collectors | EWRA2 | 400
TK 3 collectors | EWRA3 | 500
TK 4 collectors | EWRA4 | 600
Linesets | Product Code | MSRP | GBV Cost x .56 | Margin | Dealer Price | Dealer Margin | Retail
50' asphalt | LSBCu-50AR | 500
75' asphalt | LSBCu-75AR | 800
SSHardware | Product Code | MSRP | GBV Cost x .56 | Margin | Dealer Price | Dealer Margin | Retail
SS 1 collector | MH-H-USG-C1 | 100
SS 2 collectors | MH-H-USG-C2 | 200
SS 3 collectors | MH-H-USG-C3 | 300
SS 4 collectors | MH-H-USG-C4 | 400
Assesories | Product Code | MSRP | GBV Cost x .56 | Margin | Dealer Price | Dealer Margin | Retail
Thermosiphon loop kit | EP-TK | 80
Expansion tank | KAA098 | 200
Charging kit | CS-ACP | 400
80 solar storage tank | XAA116 | 1000
120 solar storage tank | XAA115 | 2000
EnerWorks Value System | Product Code | MSRP | GBV Cost x .56 | Margin | Dealer Price | Dealer Margin | Retail
TK 1 collector |  |  |  |  |  |  |  | I would like to choose one of the options and have all the details appear in these cells as they do in the above ones.
SS 1 collector
50' asphalt
thermosiphon kit | EP-TK | 80
Total
Spreadsheet: 0aa5de48-2d90-4c01-b181-121fae0bc019
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
1996-02-20 00:00:00
[NAME]
 | Republican |  |  |  | Democratic |  |  |  | Libertarian
Cheshire County | Regular | Absentee | Total |  | Regular | Absentee | Total |  | Regular | Absentee | Total
Alstead | 272 | 8 | 280 |  | 157 | 7 | 164 |  | 0 | 1 | 1
Chesterfield | 577 | 28 | 605 |  | 266 | 7 | 273 |  | 2 | 0 | 2
Dublin | 396 | 35 | 431 |  | 139 | 6 | 145 |  | 2 | 0 | 2
[NAME] | 335 | 22 | 357 |  | 120 | 6 | 126 |  | 5 | 0 | 5
Gilsum | 107 | 2 | 109 |  | 68 | 1 | 69 |  | 4 | 0 | 4
Harrisville | 176 | 5 | 181 |  | 132 | 2 | 134 |  | 1 | 0 | 1
Hinsdale | 373 | 5 | 378 |  | 220 | 1 | 221 |  | 0 | 0 | 0
[NAME] | 839 | 55 | 894 |  | 444 | 17 | 461 |  | 7 | 0 | 7
[NAME] | 479 | 28 | 507 |  | 475 | 12 | 487 |  | 0 | 0 | 0
[NAME] | 566 | 21 | 587 |  | 566 | 16 | 582 |  | 2 | 0 | 2
[NAME] 3 | 642 | 37 | 679 |  | 516 | 13 | 529 |  | 0 | 0 | 0
[NAME] | 694 | 33 | 727 |  | 514 | 9 | 523 |  | 2 | 0 | 2
[NAME] | 832 | 49 | 881 |  | 526 | 21 | 547 |  | 6 | 0 | 6
Marlborough | 314 | 24 | 338 |  | 191 | 6 | 197 |  | 2 | 0 | 2
Marlow | 111 | 6 | 117 |  | 56 | 1 | 57 |  | 2 | 0 | 2
[NAME] | 111 | 4 | 115 |  | 96 | 3 | 99 |  | 0 | 0 | 0
Richmond | 182 | 9 | 191 |  | 71 | 0 | 71 |  | 6 | 0 | 6
Rindge | 784 | 56 | 840 |  | 226 | 7 | 233 |  | 7 | 1 | 8
Roxbury | 31 | 0 | 31 |  | 36 | 2 | 38 |  | 0 | 0 | 0
Stoddard | 157 | 10 | 167 |  | 88 | 3 | 91 |  | 1 | 0 | 1
[NAME] | 109 | 4 | 113 |  | 58 | 1 | 59 |  | 3 | 0 | 3
[NAME] | 146 | 7 | 153 |  | 66 | 0 | 66 |  | 0 | 0 | 0
Swanzey | 999 | 36 | 1035 |  | 528 | 5 | 533 |  | 4 | 0 | 4
Troy | 263 | 7 | 270 |  | 194 | 2 | 196 |  | 3 | 0 | 3
Walpole | 645 | 34 | 679 |  | 328 | 6 | 334 |  | 1 | 0 | 1
Westmoreland | 272 | 16 | 288 |  | 137 | 10 | 147 |  | 4 | 0 | 4
Winchester | 368 | 17 | 385 |  | 272 | 8 | 280 |  | 5 | 0 | 5
Totals | 10780 | 558 | 11338 |  | 6490 | 172 | 6662 |  | 69 | 2 | 71
| Belknap and Carroll Counties | Coos County | Grafton County | Hillsborough County | Merrimack County| Rockingham County | [NAME] and [NAME] Back to HOMEPAGE
Spreadsheet: 05dbc9c9-c4a6-47e5-ab37-7f4aec422476
Sheet: Sheet1

Existing Facilities Program Lighting Form: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
[NAME]
Applicant Name:
Facility Name: |  |  |  |  |  |  | INSTRUCTIONS
Date: |  |  |  |  |  |  | Use one line for each fixture type in a room or area.
 |  |  |  |  | PRE-INSTALLATION |  |  |  |  | POST-INSTALLATION
Line Item | Building | Floor | Area Description | Usage Group ID | [NAME]. No. | Pre Fixt Code | Pre Watts / Fixt | [NAME] | Existing Control | Post Fixt No. | Post Fixt Code | Post Watts/ Fixt | Post kW / Space | Proposed Control | kW Saved | Baseline Annual Hours | Proposed Annual Hours | Annual kWh Saved
Integer line number | Building Address | Floor fixture is on | Description of location that matches site map | Descriptive name for the usage group | # of existing fixtures | Code from Wattage Table | Watts/Fixt from Wattage Table | (Pre Watts/Fixt) * (Pre Fixt No.) | Pre-installation control device | Number of fixtures after retrofit | Code from Wattage Table | Watts/Fixt from Wattage Table | (Post Watts/Fixt) * (Post Fixt No.) | Post-installation control device | Pre kW/Space - Post kW/Space | Existing annual hours for the usage group | Proposed annual hours for the usage group | (PreFixt #*PreWatts/Fixt * Baseline Hrs) - (PostFixt#*PostWatts/Fixt * Proposed Hours)
Ex. | 485 7th Ave, Suite 1006 | 10 | Men's Room | Restroom w/control | 3 | F44ILL | 112 | 0.336 | Light Switch | 3 | F42ILL | 59 | 0.177 | Motion Sensor | 0.159 | 3000 | 2000 | 654
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
59
60
61
62
63
64
65
66
67
68
69
70
 |  |  |  | Total Pre Fixt. |  |  | Total Pre kW |  | Total Post Fixt. |  |  | Total Post kW |  | Total kW Saved |  | Total Annual kWh Saved
Spreadsheet: 733949d1621929649-copy-and-transpose-formula-auto-reformat
Sheet: Sheet1

ST | Date | Receipt | Invoice | Debit | Credit | Cumulative Balance
ST001 | 2021-01-01 00:00:00 | 7 | 2 | 0 | 0 | 0
ST001 | 2021-01-25 00:00:00 | 0 | January |  | 185503.5 | -185503.5
ST001 | 2021-01-26 00:00:00 | 16 | 5 | 6581 |  | -178922.5
ST001 | 2021-01-26 00:00:00 | 17 | 5 | 5793 |  | -173129.5
ST001 | 2021-01-26 00:00:00 | 18 | 5 | 4461 |  | -168668.5
ST001 | 2021-01-26 00:00:00 | 19 | 5 | 7913 |  | -160755.5
ST001 | 2021-01-26 00:00:00 | 20 | 5 | 4953 |  | -155802.5
ST001 | 2021-01-26 00:00:00 | 21 | 5 | 4043 |  | -151759.5
ST001 | 2021-01-26 00:00:00 | 22 | 5 | 4584 |  | -147175.5
ST001 | 2021-01-26 00:00:00 | 23 | 5 | 11043 |  | -136132.5
ST001 | 2021-01-26 00:00:00 | 24 | 5 | 3399 |  | -132733.5
ST001 | 2021-01-26 00:00:00 | 25 | 5 | 4580 |  | -128153.5
ST001 | 2021-01-26 00:00:00 | 26 | 5 | 11134 |  | -117019.5
ST001 | 2021-01-26 00:00:00 | 27 | 5 | 4107 |  | -112912.5
ST001 | 2021-01-26 00:00:00 | 28 | 5 | 4359 |  | -108553.5
ST001 | 2021-01-26 00:00:00 | 29 | 5 | 7929 |  | -100624.5
ST001 | 2021-01-26 00:00:00 | 30 | 5 | 10480 |  | -90144.5
ST001 | 2021-01-26 00:00:00 | 31 | 5 | 9370 |  | -80774.5
ST002 | 2021-01-01 00:00:00 | 2 | 2 |  |  | -1983.41
ST002 |  | 0 | January
ST002 | 2021-02-25 00:00:00 | 0 | february |  |  | -5950.23
ST002 | 2021-03-25 00:00:00 | 0 | march |  |  | -7933.64
ST002 | 2021-03-31 00:00:00 | 136 | 136 |  |  | -2.273736754432321e-13
ST002 | 2021-04-25 00:00:00 | 0 | April |  |  | -30183.13
ST003 | 2021-01-01 00:00:00 | 1 | 1 |  |  | -4054.46
ST003 |  | 0 | January
ST003 | 2021-02-25 00:00:00 | 0 | february |  |  | -12163.26
ST003 | 2021-03-25 00:00:00 | 0 | March |  |  | -16217.66
ST003 | 2021-03-31 00:00:00 | 140 | 140 |  |  | -0.06000000000040018
Spreadsheet: 107924d1305059029-vlookup-across-multiple-sheets-copy-of-vlookup-across-multiple-sheets-2
Sheet: Others vs Main

On Others But  Not on Main
UniqueID | Ref | Words
Spreadsheet: 456931d1461134513-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-b
Sheet: MON - HOSPITAL

DATE/DAY |  |  |  |  |  |  |  | DATE/DAY |  |  |  |  |  |  |  | Vegetables
TOTAL MEALS |  |  |  | Total |  | FROZENS | TOTAL | TOTAL MEALS |  |  |  |  |  | FROZENS |  | Corn |  | Chaffey | No Corn
BOTTOM |  |  |  |  |  |  |  | BOTTOM |  |  |  |  |  |  |  | Beans |  | Cocking | No Corn
TOTAL MEALS |  |  |  |  |  |  | 7 | TOTAL MEALS |  |  |  |  |  | 7 |  | Mash Potato |  | M Wilson | No Corn
TOMATO SOUP |  |  |  |  |  |  | 5 | SOUP |  |  |  |  |  |  |  | Pasta
ROAST BEEF & GRAVY |  |  |  |  |  |  |  | ROAST BEEF & GRAVY |  |  |  |  |  |  |  | Sweets
CHICKEN & POTATO PIE |  |  |  |  |  |  |  | CHICKEN & POTATO PIE |  |  |  |  |  |  |  | [NAME] |  | Cull | Fruit & Custard
SWEETS | DIABETIC |  |  |  |  |  |  | SWEETS | DIABETIC |  |  |  |  |  |  |  |  | Cull | No Corn
YOGHURT | JELLY |  |  |  |  |  |  | YOGHURT | JELLY |  |  |  |  |  |  |  |  | Wells | No Corn
APPLE JUICE | ORANGE JUICE |  |  |  |  |  |  |  | ORANGE JUICE |  |  |  |  |  |  | Soup
LANGLANDS |  | NO CORN (QUICHE) |  |  |  |  |  |  |  |  |  |  |  |  |  | Tomato |  | White | 7 Frozen Meals
LANGLANDS |  | NO CORN (BEEF)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Denson | No Mash
MIDDLE |  |  |  |  |  |  |  | MIDDLE
TOTAL MEALS |  |  |  |  |  |  | 7 | TOTAL MEALS |  |  |  |  |  | 7
TOMATO SOUP |  |  |  |  |  | 5 |  | SOUP |  |  |  |  |  |  |  |  |  | Cocking | Jelly - No Fruit or [NAME]
ROAST BEEF & GRAVY
CHICKEN & POTATO PIE
SWEETS | DIABETIC |  |  |  |  |  |  |  | DIABETIC
YOGHURT | JELLY |  |  |  |  |  |  |  | JELLY
APPLE JUICE | ORANGE JUICE |  |  |  |  |  |  |  | ORANGE JUICE
WHITE |  | 7 FROZEN MEALS (NO JUICE OR SW)  (Meals without Corn or Mushroom Please)
MUGIVEN |  | NO PINE OR CITRUS JELLY
TOP |  |  |  |  |  |  |  | TOP
TOTAL MEALS |  |  |  |  |  |  |  | TOTAL MEALS
TOMATO SOUP |  |  |  |  |  |  |  | SOUP
ROAST BEEF & GRAVY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEEF
CHICKEN & POTATO PIE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUICHE
SWEETS | DIABETIC |  |  |  |  |  |  |  | DIABETIC |  |  |  |  |  | [NAME]
YOGHURT | JELLY |  |  |  |  |  |  |  | JELLY |  |  |  |  |  | YOGH
APPLE JUICE | ORANGE JUICE |  |  |  |  |  |  |  | ORANGE JUICE
BARNIER |  | QUICHE MASH ONLY
COCKING |  | NO CORN (BEEF), NO CITRUS JELLY
CHAFFEY |  | NO CORN (BEEF)
DENSON |  | NO MASH (BEEF)
Spreadsheet: 152124d1335269463-count-c6-n6-minusing-if-a-ws-or-hs-are-in-those-cells-register-test-1
Sheet: 1

WEEK COMMENCING |  |  | 2012-04-16 00:00:00
Name | REFERENCE | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY |  | TOTAL SESSION      2 sessions for each half day max 14 but total days will be a max of 7 | TOTAL DAY  max of 7 (goes up in whole numbers) if attend 1/2 day, this is counted as 1, if attends both AM and PM this is counted as 1 | Sessions without HS or WS  max 14 | F Team  max 7
 |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 |  | ws |  | 1 | 1 | 1 | 1 | 1 | 1 | HS |  | HS |  | HS |  | 10 | 7 | 6 | 3
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 8 | 4
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 10 | 5
 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 2 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |  | 0 |  | 4 | 2
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 10 | 5
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 10 | 5
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 10 | 5
 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 2 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 |  | 0 |  | 4 | 2
 |  | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 8 | 4
 |  |  |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 2 | 1
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 10 | 5
 |  | HS | HS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 |  | 0 |  | 10 | 5
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 |  | 0 |  | 8 | 4
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
Total Sessions |  | 9 | 8 | 12 | 12 | 12 | 12 | 11 | 11 | 10 | 9 | 1 |  | 1 |  | 108 | 56
Number of Sessions |  | 7 | 7 | 12 | 12 | 12 | 12 | 11 | 11 | 9 | 9 | 0 |  | 0 |  | 102
Number of HS Sessions |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |  | 1 |  | 5
Number of WS  Sessions |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 1
Total Sessions |  | 9 | 8 | 12 | 12 | 12 | 12 | 11 | 11 | 10 | 9 | 1 |  | 1 |  | 108 | 0
KEY:
0 | DOES NOT ATTEND SERVICE
1 | DOES ATTEND SERVICE
HS | Home Support - IS SUPPORTED AT HOME BY STAFF FROM DAY SERVICE
WS | [NAME], Supported by Staff out in the community,  NO support given at home or in DTS
Spreadsheet: 267342d1380049562-returning-matching-keywords-file1_error
Sheet: Sheet1

Title | Result | [NAME] |  |  | Keyword
CEO | 1 |  |  |  | Chief
CEO | 1 |  |  |  | Vice
CEO | 1 |  |  |  | Director
Chief Executive Officer | 1 |  |  |  | Manager
Director | 1 |  |  |  | General
Director | 1 |  |  |  | CEO
Director | 1 |  |  |  | CFO
Executive | False |  |  |  | COO
Managing Director | 1 |  |  |  | CTO
Owner | False
Senior Partner | False