tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40298__8_27_O&M_as submitted
Sheet: NNG commercial-O&M

DIRECT  O & M COSTS
2002 - 2004 PLAN
NORTHERN NATURAL GAS COMPANY-COMMERCIAL
( $ In Millions)
 |  |  |  | 2000 Actuals |  |  |  |  |  |  |  |  |  | Restated 2001 Plan |  |  |  |  |  |  |  |  |  | 2001 2nd Current Estimate |  |  |  |  |  |  |  |  |  | 2002 Plan
 |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  |  |  | Project
 |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Gross O&M
 |  |  |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | Gross |  | Capital |  | Capital |  | Allocations |  | Net |  | % O(U)
Department |  |  |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | O & M |  | O & M |  | O & M |  | In/(Out) |  | O & M |  | 2000 Plan
NNG-Direct |  |  |  |  |  |  |  |  |  |  |  | 13.9
Revenue [NAME] |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0.9 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  | 0.9 |  | 1.6
ETS Support |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0.3 |  |  |  |  |  |  |  |  |  | 0.3 |  |  |  |  |  |  |  |  |  | 0.4
Aviation |  |  |  |  |  |  |  |  |  |  |  | 1.7 |  | 1.7 |  |  |  |  |  |  |  |  |  | 1.2 |  |  |  |  |  |  |  |  |  | 0.2
Total Direct
Depreciation Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.9
* For companies outside of ETS
NOTE:   This schedule should include those costs that roll into O & M, according to the heirarchies you established in SAP, and payroll taxes.
Spreadsheet: 1f7df3c1-ca37-4456-b394-b5b43ffa6166
Sheet: ACRL3

ACRL Statistics Questions 44-56, 2009-2010
Question | Measure | Total FY10 | Notes
— | Electronic books | — | —
Question 44 | Number of electronic books | 50098 | Includes government publications.
Question 45 | Expenditures for electronic books | 2970.75 | Encyclopedia of Ocean Sciences, 2nd. [NAME].
Question 46 | Are the above expenditures reported in Canadian dollars? | N | —
Question 49 | Number of sessions (logins) to databases or services | 353305
Question 49a | Number of resources for which you are reporting | 130
Question 50 | Number of searches (queries) in databases or services | 1063618
Question 50a | Number of resources for which you are reporting | 142 | —
Question 51 | Number of full-text article requests | 442066 | Footnote: "Includes full-text article requests from individual e-journals, e-journals in packages, and e-journal content available in full-text aggregator databases."
Question 51a | Number of resources for which you are reporting | 15193 | Footnote: "Number of resources interpreted as unique e-journal titles."
Question 52 | Number of virtual visits | —
Question 52a | Number of virtual visits to library's Website | NA/UA | Homepage visits only; does not include visits to sub-pages.
Question 52c | Excludes virtual visits from inside the library | N | —
Question 55 | Direct cost of digital collections construction and management | — | —
Question 55b | Direct cost of equipment, software, or contracted services | — | —
 | Cost of DigitalCommons (BePress) | 12699.5 | Provided by Acquisitions.
Question 56 | [NAME] held collectively | 0 | Not applicable.
Spreadsheet: a7d03eef-c0a9-402f-b1fc-ea559ecd5865
Sheet: Table S1

Table S1  Transcriptomic sequencing results.
 | Number of reads | Number of mapped reads | Number of mapped genes | # mapped/ # total
Low N | 21265929 | 9713354 | 4204
 | 16585211 | 7862427 | 4178
 | 17023451 | 7967082 | 4171
Low P | 17363994 | 8522522 | 4173
 | 20184291 | 10623671 | 4164
 | 17938546 | 9010415 | 4136
HMWDOM | 13993702 | 7008696 | 4127
 | 12393729 | 5531386 | 4084
 | 15095239 | 6044402 | 4099
HMWDOM +N | 16520845 | 7360858 | 4109
 | 28014796 | 15418655 | 4201
 | 23553764 | 14281952 | 4164
HMWDOM +P | 14448116 | 6033677 | 4103
 | 15194664 | 6511955 | 4133
 | 13084268 | 6592727 | 4142
Control | 13055201 | 6793715 | 4132
 | 12967695 | 8018073 | 4126
 | 13277124 | 7250475 | 4129
Spreadsheet: 272573d1382435010-struggling-sum-of-number-of-rows-which-meet-criteria-across-columns-tyseley
Sheet: Sheet1

Item | Des | Decis 1 | [NAME] | Status
Change | Another test | Approved |  | Open
Change | this test | Approved |  | Open |  |  |  | Summary
Change | a test | Deferred |  | Open
Change | 1 test | More Information |  | Open |  |  |  | Open |  | Approved
Change | 2 test | More Information |  | Closed |  |  |  |  |  | Deferred
Change | 3 test | More Information |  | Closed |  |  |  |  |  | More Information
Change | 4 test | Deferred |  | Closed
Change | 5 test | Approved |  | Closed |  |  |  | Closed |  | Approved
Change | 5 test | Approved |  | open |  |  |  |  |  | Deferred
 |  |  |  |  |  |  |  |  |  | More Information
Spreadsheet: 271911d1382105028-sum-values-from-different-sheets-to-summary-sheet-sum-values
Sheet: Qtr2

Our Global Company
[NAME], Second Quarter
Sales Group: | Consulting: | Marketing: | Outsourcing: | Bundling:
Northeast | 7960.583683717317 | 6744.831889614043 | 7715.559226405216 | 1626.545594536557
Southeast | 5981.532337592055 | 1696.339967277454 | 257.1809732440888 | 9190.687745293577
Northwest | 5985.782235980599 | 7206.436031429522 | 5489.276957566261 | 4887.198949876776
Southwest | 104.7841999444898 | 8156.340924178176 | 6435.619786126505 | 1659.258387054967
TOTAL
Spreadsheet: 479173d1473260589-issue-with-formatting-date-column-with-data-extract-from-sql-server-weird-date-format
Sheet: Sheet2

DateModified
2016-03-29 13:14:21
2015-12-10 11:19:13.0000000
2015-12-03 10:42:09.0000000
2015-11-19 10:44:14.0000000
2016-03-24 12:00:46.0000000
2016-05-19 13:57:30.0000000
2016-06-17 11:28:56.0000000
2016-08-04 11:27:38.0000000
2016-03-29 13:14:18.0000000
2016-03-29 13:14:00.0000000
2015-11-16 07:00:55.0000000
2016-04-07 14:18:47.0000000
2016-01-28 11:04:08.0000000
2016-07-14 11:10:02.0000000
2016-03-10 12:01:49.0000000
2015-12-03 10:42:18.0000000
2016-05-18 09:31:48.0000000
2016-06-06 09:47:31.0000000
2015-11-19 10:44:05.0000000
2016-03-10 12:01:25.0000000
2016-01-14 11:33:31.0000000
2016-07-14 11:09:35.0000000
2016-06-10 09:25:07.0000000
2016-01-21 11:14:14.0000000
2016-06-06 09:47:13.0000000
2015-12-03 10:42:10.0000000
2016-06-06 09:46:22.0000000
2016-08-04 11:26:49.0000000
2016-06-06 09:47:25.0000000
2016-07-07 12:13:20.0000000
2016-01-28 11:04:09.0000000
2016-05-12 11:25:06.0000000
2016-04-07 14:18:38.0000000
2016-07-14 11:09:55.0000000
2016-03-29 13:17:22.0000000
2016-01-14 11:33:35.0000000
2016-08-04 11:26:34.0000000
2016-05-18 09:33:08.0000000
2016-06-17 11:27:40.0000000
2016-01-28 11:04:14.0000000
2015-11-25 10:48:20.0000000
2016-06-17 11:26:44.0000000
2016-08-04 11:27:44.0000000
2016-05-26 13:59:18.0000000
2016-06-30 13:12:37.0000000
2016-08-04 11:26:42.0000000
2015-12-23 15:26:54.0000000
2016-06-06 09:46:11.0000000
2015-11-17 16:12:11.0000000
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: EOL Support

EOL Support | ok
Becker | [NAME] | Admin, Sr
Cannon | Lydia | Admin, Sr
[NAME] | [NAME] | Admin, Sr
[NAME] | [NAME] | Analyst
Renaud | [NAME] | Analyst
[NAME] | [NAME] | Director
Puthigai | Savita | Director
Shults | [NAME] | Director
Shah | [NAME] | Director
Jafry | [NAME] | Director
[NAME] | [NAME] | Manager
[NAME] | [NAME] | Manager
Diamond | [NAME] | Manager
[NAME] | [NAME] | Manager
[NAME] | [NAME] | Manager
Lees | [NAME] | Manager
[NAME] | Maria | Manager
Mandola | Teresa | Manager
Moorer | Torrey | Manager
Alon | Heather | Spec
Hernandez | Lorie | Spec
Heuertz | Kelly | Spec
[NAME] | [NAME] | Spec
[NAME] | Adam | Spec
Motsinger | [NAME] | Spec
Oberai | Rickwinder | Spec
Walker | [NAME] | Spec
Boudreau | [NAME] | Sr. Spec
Gray | [NAME] | Sr. Spec
[NAME] | Dawn | Sr. Spec
Merdith | [NAME] | Sr. Spec
Moore | [NAME] | Sr. Spec
Sever | [NAME] | Sr. Spec
Sweitzer | Tara | Sr. Spec
[NAME] | Sunil | Staff
[NAME] | [NAME] | Staff
[NAME] | Claudia | Staff
Deluca | [NAME] | Staff
George | Fraisy | Staff
Guillory | [NAME] | Staff
[NAME] | Cecil | Staff
[NAME] | Stephen | Staff
O'Day | [NAME] | Staff
Forster | [NAME] | VP
Total |  | 44
Spreadsheet: 77538d1277993678-monthly-template-book1
Sheet: Data

NPS Officer | Licence type | [NAME] | NPS number | Advertising | Days | KPI | Time recording | Time (hrs) | hours | Minutes
[NAME] | Full | A | 1 | no | 92 | PASS | 2900 | 48.33333333333334 | 48 | 19.8
[NAME] | Full | B | 2 | no | 120 | PASS | 2425 | 40.41666666666666 | 40 | 24.6
[NAME] | Full | C | 3 | no | 164 | FAIL | 3110 | 51.83333333333334 | 51 | 49.8
[NAME] | Full | D | 4 | no | 177 | FAIL | 2397.5 | 39.95833333333334 | 39 | 57
[NAME] | Full | E | 5 | no | 178 | FAIL | 2397.5 | 39.95833333333334 | 39 | 57
[NAME] | Full | F | 6 | no | 174 | FAIL | 3515 | 58.58333333333334 | 58 | 34.8
[NAME] | Full | G | 7 | no | 90 | PASS | 4877 | 81.28333333333333 | 81 | 16.8
[NAME] | Full | H | 8 | no | 91 | PASS | 4385 | 73.08333333333333 | 73 | 4.8
[NAME] | Full | I | 9 | no | 91 | PASS | 5619 | 93.65 | 93 | 39
[NAME] | Full | J | 10 | yes | 120 | PASS | 4500 | 75 | 75 | #N/A | How do I get this to be 00?
[NAME] | Full | K | 11 | no | 119 | PASS | 3120 | 52 | 52 | #N/A | How do I get this to be 00?
[NAME] | Full | L | 12 | no | 50 | PASS | 2400 | 40 | 40 | #N/A | How do I get this to be 00?
[NAME] | Hydropower | M | 13 | yes | 129 | PASS | 3500 | 58.33333333333334 | 58 | 19.8
[NAME] | Hydropower | N | 14 | yes | 129 | PASS | 3500 | 58.33333333333334 | 58 | 19.8
[NAME] | Pre-app | O | 15 | no |  |  | 285 | 4.75 | 4 | 3 | Not correct should be 45
[NAME] | Withdrawn | P | 16 | no |  | 0 | 760 | 12.66666666666667 | 12 | 39.6
[NAME] | Pre-app | Q | 17 | no |  |  | 195 | 3.25 | 3 | 3 | Not correct should be 45
Spreadsheet: 66192d1266889964-hlookup-and-multi-culumn-data-retrieval-test-sheet
Sheet: Sheet2

Daily Retail Department Invoice Verification Log |  |  |  |  | Date: | 2010-01-01 00:00:00
Form 10-LV | Dept # | Whse # | Register # | Retail $ | Register # | Retail $ | Employee Signature
Grocery | 301 | CPS | 1 | 2 | 2 | 3
 |  | 7 | 3 | 4 | 4 | 5
 |  | 29 | 5 | 6 | 6 | 7
 |  | 35 | 7 | 8 | 8 | 9
 |  | 37 | 9 | 10 | 10 | 11
 |  | 39 | 11 | 12 | 12 | 13
 |  | Firms | 13 | 14 | 14 | 15
 |  | Extra | 15 | 16 | 16 | 17
 | 302 | CPS | 17 | 18 | 18 | 19
 |  | 29 | 19 | 20 | 20 | 21
 |  | 35 | 21 | 22 | 22 | 23
 |  | 37 | 23 | 24 | 24 | 25
 |  | Firms | 25 | 26 | 26 | 27
 |  | Extra | 27 | 28 | 28 | 29
 | 313 | CPS | 29 | 30 | 30 | 31
 |  | 7 | 31 | 32 | 32 | 33
 |  | 29 | 33 | 34 | 34 | 35
 |  | 35 | 35 | 36 | 36 | 37
 |  | Firms | 37 | 38 | 38 | 39
 |  | Extra | 39 | 40 | 40 | 41
 | 318 | 37 | 41 | 42 | 42 | 43
 |  | Firms | 43 | 44 | 44 | 45
 |  | Extra | 45 | 46 | 46 | 47
 | 327 | 35 | 47 | 48 | 48 | 49
 |  | Firms | 49 | 50 | 50 | 51
 |  | Extra | 51 | 52 | 52 | 53
 | 335 | 35 | 53 | 54 | 54 | 55
 |  | 39 | 55 | 56 | 56 | 57
 |  | Firms | 57 | 58 | 58 | 59
 |  | Extra | 59 | 60 | 60 | 61
 | 338 | CPS | 61 | 62 | 62 | 63
 |  | 35 | 63 | 64 | 64 | 65
 |  | Firms | 65 | 66 | 66 | 67
 |  | Extra | 67 | 68 | 68 | 69
Liquor | 303 | 29 | 69 | 70 | 70 | 71
 |  | Firms | 71 | 72 | 72 | 73
 |  | Extra | 73 | 74 | 74 | 75
 | 305 | 29 | 75 | 76 | 76 | 77
 |  | Firms | 77 | 78 | 78 | 79
 |  | Extra | 79 | 80 | 80 | 81
 | 308 | 29 | 81 | 82 | 82 | 83
 |  | Firms | 83 | 84 | 84 | 85
 |  | Extra | 85 | 86 | 86 | 87
Dairy | 314 | 7 | 87 | 88 | 88 | 89
 |  | 34 | 89 | 90 | 90 | 91
 |  | 44 | 91 | 92 | 92 | 93
 |  | Firms | 93 | 94 | 94 | 95
 |  | Extra | 95 | 96 | 96 | 97
 | 323 | 7 | 97 | 98 | 98 | 99
 |  | 34 | 99 | 100 | 100 | 101
 |  | 44 | 101 | 102 | 102 | 103
 |  | Firms | 103 | 104 | 104 | 105
 |  | Extra | 105 | 106 | 106 | 107
 | 324 | 34 | 107 | 108 | 108 | 109
 |  | Firms | 109 | 110 | 110 | 111
 |  | Extra | 111 | 112 | 112 | 113
 | 325 | 34 | 113 | 114 | 114 | 115
 |  | 35 | 115 | 116 | 116 | 117
 |  | Firms | 117 | 118 | 118 | 119
 |  | Extra | 119 | 120 | 120 | 121
DAILY RETAIL DEPT Invoice Verification |  |  |  | Date: |  | Date: | 2010-01-01 00:00:00
Form 10 Supp. | Dept # | Whse # | Register # | Retail $ | Register # | Retail $ | Employee Signature
Frozen | 317 | 32 | 121 | 122 | 122 | 123
 |  | 33 | 123 | 124 | 124 | 125
 |  | Firms | 125 | 126 | 126 | 127
 |  | Extra | 127 | 128 | 127 | 129
GM | 311 | CPS | 129 | 130 | 130 | 131
 |  | 37 | 131 | 132 | 132 | 133
 |  | 39 | 133 | 134 | 134 | 135
 |  | Firms | 135 | 136 | 136 | 137
 |  | Extra | 137 | 138 | 138 | 139
 | 312 | CPS | 139 | 140 | 140 | 141
 |  | 35 | 141 | 142 | 142 | 143
 |  | 37 | 143 | 144 | 144 | 145
 |  | 39 | 145 | 146 | 146 | 147
 |  | Firms | 147 | 148 | 148 | 149
 |  | Extra | 149 | 150 | 150 | 151
 | 322 | 39 | 151 | 152 | 152 | 153
 |  | 38 | 153 | 154 | 154 | 155
 |  | Firms | 155 | 156 | 156 | 157
 |  | Extra | 157 | 158 | 158 | 159
Spreadsheet: 169875d1343080429-index-and-match-help-lifting-lug-spreadsheet-help-oeldere-
Sheet: WorkSheet

Hoop Stress (psi) Sn: | 5750 |  |  |  |  |  |  | Lug Heights |  |  |  |  |  |  |  |  | Gusset and plate thickness
Allowable shell stress (psi) S: | 5312.5 |  |  |  |  |  |  | Required lug height at the lug (in) hL: | 0.1295299334750684 |  |  |  |  |  |  |  | Required thickness of gusset and baseplate from shear (in) tgs: | 0.001953125
 |  |  |  |  |  |  |  | Required lug height between the lugs (in) hb: | 0.2151059930250529 |  |  |  |  |  |  |  | Required thickness of gusset and baseplate from bending (in) tgb: | 0.00224609375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required thickness of gusset and baseplate from crushing (in) tgc: | 0.002083333333333333
 |  |  |  |  |  |  |  | Required lug height (in) hr: | 0.2151059930250529 |  |  |  |  |  |  |  | Required thickness of gusset and baseplate for lateral stability (in) tgl: | 0.375
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Required gusset and baseplate thickness (in) tg: | 0.375
Spreadsheet: a88b4b77-c1b8-48a5-928b-7c185d3bf6dd
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
TBGI | Test | TBGI | Thyroxine-Binding Globulin (TBG), Serum | Thyroxine Binding Globulin, S | Solid-Phase Chemiluminescent Assay | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.35 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males: 12-26 mcg/mL Females: 11-27 mcg/mL | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 84442 |  |  |  |  | Rochester
TBGI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TBGI | Result | TBGI | Thyroxine Binding Globulin, S | Thyroxine Binding Globulin, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3021-3
Spreadsheet: 493883d1481927877-filtering-combined-items-within-a-given-set-of-rows-in-pivot-table-sample-workbook-
Sheet: Source Table

EMP NAME | DATE | DESCR | HOURS | RATE | AMT | DESCR 2 | All Breaks | Paid | ADJ HOURS | Average Pay | PAY PERIOD
[NAME] | 2012-07-02 00:00:00 | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 | Hourly | 0 | 0.28 | 9.24 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-03 00:00:00 | Hourly | 9 | 8 | 64 |  | 1.33 |  |  | 9.34419817470665
[NAME] | 2012-07-05 00:00:00 | Hourly | 2 | 0.28 | 10.08 |  | 0 |  |  | 0
[NAME] 2 | 2012-07-02 00:00:00 | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] 2 | 2012-07-02 00:00:00 | Hourly | 0 | 0.28 | 12.6 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 | Piece Rate | 0 | 0.28 | 8.4 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Hourly | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 | Piece Rate | 0 | 0.28 | 12.6 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Salary | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 | Piece Rate | 0 | 0.28 | 8.96 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Salary | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 | Salary | 0 | 0.28 | 10.36 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Piece Rate | 8 | 8 | 64 |  | 0.33 |  |  | 8.34419817470665
[NAME] | 2012-07-02 00:00:00 | Piece Rate | 0 | 0.28 | 7.28 |  | 0 |  |  | 0
[NAME] | 2012-07-02 00:00:00 | Salary | 0 | 0.28 | 10.36 |  | 0 |  |  | 0
[NAME] | 2012-07-04 00:00:00 | Salary | 0 | 0.28 | 10.36 |  | 0 |  |  | 0
Spreadsheet: 215806d1361489721-sorting-multiple-columns-site-g-roster
Sheet: Calculation Page

 | DAY | NIGHT | ON CALL | MALE | FEMALE |  |  |  | NOTE: Do not edit this page, this page is strictly for calculating the values on the Main PERSTAT Page only
HHB
BRAVO
CHARLIE
CPN
NATO
USAF
CIVILIANS
243 ENG DET |  |  |  |  |  |  |  |  |  |  |  |  |  | LTC
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MAJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CPT
NIGHT SHIFT |  |  |  | DAY SHIFT |  |  |  |  |  |  |  |  |  | 1LT
 | Males | Females |  |  | Males | Females |  |  |  |  |  |  |  | 2LT
HHB |  |  |  | HHB |  |  |  |  |  |  |  |  |  | WO1
BRAVO |  |  |  | BRAVO |  |  |  |  |  |  |  |  |  | CW2
CHARLIE |  |  |  | CHARLIE |  |  |  |  |  |  |  |  |  | CW3
TOTAL: |  |  |  | TOTAL: |  |  |  |  |  |  |  |  |  | CW4
NOTE: HHB numbers include all attached personnel from NATO, JPN, ENG, CIVs and USAF |  |  |  | NOTE: HHB numbers include all attached personnel from NATO, JPN, ENG, CIVs and USAF |  |  |  |  |  |  |  |  |  | CW5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CSM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SGM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1SG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | MSG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SFC
HHB RANK BREAKDOWN |  |  |  |  |  |  | BRAVO RANK BREAKDOWN |  |  |  |  |  |  | SSG
Officers |  | NCOS |  | Soldiers |  |  | Officers |  | NCOS |  | Soldiers |  |  | SGT
LTC |  | CSM |  | SPC |  |  | LTC |  | CSM |  | SPC |  |  | CPL
MAJ |  | SGM |  | PFC |  |  | MAJ |  | SGM |  | PFC |  |  | SPC
CPT |  | 1SG |  | PV2 |  |  | CPT |  | 1SG |  | PV2 |  |  | PFC
1LT |  | MSG |  | PVT |  |  | 1LT |  | MSG |  | PVT |  |  | PV2
2LT |  | SFC |  |  |  |  | 2LT |  | SFC |  |  |  |  | PVT
WO1 |  | SSG |  |  |  |  | WO1 |  | SSG
CW2 |  | SGT |  |  |  |  | CW2 |  | SGT
CW3 |  | CPL |  |  |  |  | CW3 |  | CPL
CW4 |  |  |  |  |  |  | CW4
CW5 |  |  |  |  |  |  | CW5
TOTAL: |  | TOTAL: |  | TOTAL: |  |  | TOTAL: |  | TOTAL: |  | TOTAL:
Note: HHB numbers DO NOT reflect the civilians
 |  |  |  |  |  |  | CHARLIE RANK BREAKDOWN
 |  |  |  |  |  |  | Officers |  | NCOS |  | Soldiers
 |  |  |  |  |  |  | LTC |  | CSM |  | SPC
 |  |  |  |  |  |  | MAJ |  | SGM |  | PFC
 |  |  |  |  |  |  | CPT |  | 1SG |  | PV2
 |  |  |  |  |  |  | 1LT |  | MSG |  | PVT
 |  |  |  |  |  |  | 2LT |  | SFC
 |  |  |  |  |  |  | WO1 |  | SSG
 |  |  |  |  |  |  | CW2 |  | SGT
 |  |  |  |  |  |  | CW3 |  | CPL
 |  |  |  |  |  |  | CW4
 |  |  |  |  |  |  | CW5
 |  |  |  |  |  |  | TOTAL: |  | TOTAL: |  | TOTAL:
Spreadsheet: 49726d1249046333-how-to-recalculate-with-drop-down-menu-part-2-dependentdropboxes
Sheet: Sheet1

Option 2 |  | this is the drop down made from sheet 2
 |  | Cell A1 has been named "Choice"
 |  | on Sheet2, each of the colored ranges has been given names that MATCH the options in the drop box (minus the spaces)
Total | Tea | Coffee | Hot Chocolate | Milkshake | Water
Option 1 |  |  |  |  |  |  | is there anyway that I can show the total row for all three choices from the drop down menu
Option 2 |  |  |  |  |  |  | the total row comes from sheet 3 rows C9 to G9?
Option 3 |  |  |  |  |  |  | but I still need to show the detail of one drop down  - see tables above in pink
 | Grand Total | Temperature | Flavor | Sweetness
Option 1 |  |  |  |  |  |  | is there anyway that I can show the data for all three choices from the drop down menu
Option 2 |  |  |  |  |  |  | the data comes from sheets 3, 4, 5 and 6
Option 3 |  |  |  |  |  |  | but I still need to show the detail of one drop down  - see tables above in pink
Spreadsheet: 44164d1242813728-index-match-formula-using-range-name-684423-index-match-formula-using-range-name
Sheet: Sheet2

 |  | MyTable
 |  |  |  |  | Value A
 |  |  | 10 | 20 | 30 | 40 | 50
 |  | 1 | 1.5 | 2.5 | 3.5 | 4.5 | 5.5
 |  | 2 | 2 | 3 | 4 | 5 | 6
 | Value B | 3 | 2.5 | 3.5 | 4.5 | 5.5 | 6.5
 |  | 4 | 3 | 4 | 5 | 6 | 7
 |  | 5 | 3.5 | 4.5 | 5.5 | 6.5 | 7.5
Spreadsheet: 377558d1424056728-autocomplete-and-autolookup-as-i-type-plus-copy-data-full-kids-ministry-roll-test
Sheet: 2015 - Creche

2015 | Creche/Explorers
HOLIDAYS
Date: | 2015-01-04 00:00:00 | 2015-01-11 00:00:00 | 2015-01-18 00:00:00 | 2015-01-25 00:00:00 | 2015-04-03 00:00:00 | 2015-04-05 00:00:00 | 2015-04-12 00:00:00 | 2015-04-19 00:00:00
LEADERS & HELPERS
Visitors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
TERM 1
Date: | 2015-02-01 00:00:00 | 2015-02-08 00:00:00 | 2015-02-15 00:00:00 | 2015-02-22 00:00:00 | 2015-03-01 00:00:00 | 2015-03-08 00:00:00 | 2015-03-15 00:00:00 | 2015-03-22 00:00:00 | 2015-03-29 00:00:00 |  |  | Vistors
LEADERS & HELPERS |  |  |  |  |  |  |  |  |  |  |  | Name |  | Date | Details
Visitors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
TERM 2
Date: | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2015-03-31 00:00:00 | 2013-04-07 00:00:00
LEADERS & HELPERS
Visitors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
TERM 3
Date: | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2015-03-31 00:00:00 | 2013-04-07 00:00:00
LEADERS & HELPERS
Visitors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
TERM 4
Date: | 2013-02-03 00:00:00 | 2013-02-10 00:00:00 | 2013-02-17 00:00:00 | 2013-02-24 00:00:00 | 2013-03-03 00:00:00 | 2013-03-10 00:00:00 | 2013-03-17 00:00:00 | 2013-03-24 00:00:00 | 2015-03-31 00:00:00 | 2013-04-07 00:00:00
LEADERS & HELPERS
Visitors | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL
Spreadsheet: 734418d1622144585-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: nl (2)

Project | datum | vertrek | via | aankomst | Tijd | wie nederland | wie Duitsland | [NAME] | nummer | telefoon | tropcos | beg NL | Beg D
5258 |  |  | waldseite sud |  |  | [NAME] | nl
5259 |  |  | waldseite sud |  |  | [NAME] | nl
5259 |  |  | waldseite sud |  |  |  | nl
5259 |  |  | waldseite sud
5259 |  |  | waldseite sud |  |  | [NAME]
5260 |  |  |  |  |  | [NAME]
5260 |  |  |  |  |  |  | nl
5258 |  |  | waldseite sud |  |  | [NAME] | nl
5259 |  |  |  |  |  | [NAME] | nl
5259 |  |  | waldseite sud |  |  |  | nl
5259 |  |  | waldseite sud
5259 |  |  | waldseite sud |  |  | [NAME]
5260 |  |  |  |  |  | [NAME]
5260 |  |  |  |  |  |  | nl