tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9de193b3-10ac-4bb6-9093-9f8042a54e01
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
FSAGA | Test | FSAGA | IgA Salivary, RID | IgA Salivary, RID | Radial Immunodiffusion (RID) | Plastic screw-cap vial: PlScr |  |  | 3 | mL | Submit 3.0 mL of saliva. ([NAME] is not acceptable.)  Refrigerate specimen after collection. | 1.0 mL | Specimens other than	Saliva Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | REFERENCE RANGE:  6.2-14.5 mg/dL Decreased salivary IgA may be present in children with recurrent                                              upper respiratory infection, selective IgA deficiency and occasional  individuals with food allergies.   This assay was performed using a kit labeled "For Research Use  Only" by the kit manufacturer.  The kit's performance characteristics  have been established and validated by FOCUS TECHNOLOGIES  for in-vitro diagnostic use.   Test Performed by Focus Diagnostics 5785 Corporate Avenue Cypress, CA   90630-4750 | Monday and Thursday | 2 days | 8 days | 1 | 82784 |  |  |  |  | Focus Diagnositics, Inc.
FSAGA | [NAME] | SALIVA | Saliva |  |  |  | Refrigerated
FSAGA | Result | Z0593 | IgA Salivary, RID | IgA Salivary, RID | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 779487d1651813693-formula-to-subtact-1st-piece-of-data-in-a-sting-from-last-in-each-data-set-data-string-help
Sheet: Sheet1

Data Set | Answer Im after
150.970001
149.460007 |  |  | Im wanting to subtract the first value in a string from the last bit of data in the string
150.619995 |  |  | Strings vary in length
152.550003 |  |  | The gaps between the strings vary as well
155.089996
152.679993
154.479996
152.229996
153.710007
153.619995
150.190002
150.559998
151.25
152.229996
160.690002
161.240005
161.220001
158.539993
157.449997
161.5
164.009995
164.669998
162.350006
161.110001
160.830002
162.660004
163.539993
161.850006
149.710007
152.860001
150.929993
150.639999
151.649994
160.440002
159.949997
159.720001
160.460007
159.490005
159.210007
158.5
159.190002
157.360001
159.860001
157.070007
158.160004
158.089996
157.679993
152.960007
152.979996
155.910004
161.179993
163.039993
166.979996
166.080002
165.949997
163.690002
167.130005
145.080002
144.949997
146.529999
147.919998
145.309998
146.610001
148.600006
151.149994
149.940002
148.699997
152.559998
153.070007
155.949997
156.600006
155.949997
153.919998
152.490005
154.720001
155
151.429993
152.139999
151.869995
148.690002
144.550003
147.970001
141.800003
136.449997
139.279999
138.289993
134.399994
129.210007
128.300003
133.440002
131.860001
128.889999
130.169998
132.479996
138.399994
140.149994
140.100006
139.649994
Spreadsheet: 100554d1298908184-array-formulas-giving-incorrect-value-sumofmatchingstates
Sheet: Table

State of University | 1st Year Location | 2nd Year Location | 3rd Year Location | 1st Non-Rotational Location | Stats on 1st Non-Rotational Location |  | 3
New Jersey | Canaan, CT | [NAME], NJ | [NAME], NJ | Sandy, UT | Other BD Site | 0 | 3
New Jersey | Holdrege, NE | [NAME], NJ | Sparks, MD | Sparks, MD | Location 3 | 0 | 5
New York | [NAME], NJ | Canaan, CT | [NAME], NJ | [NAME], NJ | Location 1 | 0
Pennsylvania | Canaan, CT | Waltham, MA | Holdrege, NE | Outside BD | Outside BD | 0
Nebraska | Holdrege, NE | [NAME], NJ | Sandy, UT | Sandy, UT | Location 3 | 0
n/a | [NAME], SC | Sandy, UT | 0 | Left Early | n/a | 1
New York | [NAME], NJ | Columbus, NE | Sandy, UT | Canaan, CT | Other BD Site | 0
Utah | Sandy, UT | Holdrege, NE | Treyburn, NC | Treyburn, NC | Location 3 | 0
Iowa | Sandy, UT | [NAME], SC | Canaan, CT | Holdrege, NE | Other BD Site | 0
New York | Canaan, CT | Holdrege, NE | [NAME], NJ | [NAME], NJ | Location 3 | 0
New York | Sandy, UT | Canaan, CT | [NAME], NJ | Canaan, CT | Location 2 | 0
Utah | [NAME], SC | Holdrege, NE | Sandy, UT | Sandy, UT | Location 3 | 1
New York | Canaan, CT | [NAME], NJ | Columbus, NE | [NAME], NJ | Location 2 | 0
Utah | Sandy, UT | [NAME], SC | Waltham, MA | Sandy, UT | Location 1 | 1
New Jersey | Holdrege, NE | Canaan, CT | [NAME], SC | [NAME], NJ | Other BD Site | 1
New Jersey | Columbus, NE | [NAME], NJ | Sandy, UT | [NAME], NJ | Location 2 | 1
New York | Columbus, NE | Canaan, CT | Sandy, UT | Canaan, CT | Location 2 | 0
Colorado | Holdrege, NE | Columbus, NE | [NAME], SC | Holdrege, NE | Location 1 | 0
Illinois | Holdrege, NE | Columbus, NE | [NAME], NJ | St. Louis, MO | Other BD Site | 0
New York | Canaan, CT | Rutherford, NJ | Columbus, NE | Waltham, MA | Other BD Site | 0
Is the first Non-Rotational Location in the same state as the University?
If so, how many are there?
The state (spelled out completely) of each location is in the "Location" Tab
The location list will be a dynamic list.
I would like a formula that can find the state for each 1st Non-Rotational Location shown above and then see if it is the same as the "State of University" of the cell next to it.
If it is a match, it should count it and provide a sum of the total matches.
Spreadsheet: 816983d1675933150-want-to-create-palet-sheets-book1
Sheet: Sheet1

 | number | div by
 | 80 | 7 |  | 11 | 11 | 11 | 11 | 11 | 11 | 3
 | 1250 | 80 |  | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 178 | 50
Spreadsheet: 085706f9-2f83-4c16-9584-4a8ca961dce6
Sheet: Sheet1

Industry Code NAICS (January 20, 2004 Def.) | Industry Code Description | Number of Employees for week including March 12, 2001
325411 | Medicinal & botanical mfg | 370
325412 | Pharmaceutical preparation mfg | 4692
325413 | In-vitro diagnostic substance mfg | 575
325414 | Biological product (exc diagnostic) mfg | 10
333314 | Optical instrument & lens mfg | 1121
334510 | Electromedical apparatus mfg | 1763
334514 | Total [NAME] device mfg | 170
334516 | Analytical laboratory instrument mfg | 908
334517 | Irradiation apparatus mfg | 170
339111 | Laboratory apparatus & furniture mfg | 1107
339112 | Surgical & medical instrument mfg | 2377
339113 | Surgical appliance & supplies mfg | 3514
339114 | Dental equipment & supplies mfg | 1199
339115 | Ophthalmic goods mfg | 1085
532291 | Home health equipment rental | 388
541380 | Testing laboratories | 1371
541710 | R&D in physical, engineering & life sciences | 3129
541910 | Marketing Research and Public Opinion Polling | 1070
541940 | Veterinary services | 2886
 | Total for all Cluster Businesses 2001: | 27905
 | Survey (Spring 2002) Businesse with 10 Plus Employees | 28216
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: BRA

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 71 | 00:01:15.324000 | 2 |  | 1 |  | 00:01:12.099000
2 | [NAME] |  |  | 18 | 71 | 00:01:16.076000 | 1 |  | 2 |  | 00:01:11.918000
3 | [NAME] |  |  | 15 | 71 | 00:01:15.580000 | 3 |  | 3 |  | 00:01:12.283000
4 | [NAME] |  |  | 12 | 71 | 00:01:16.181000 | 5 |  | 4 |  | 00:01:12.591000
5 | [NAME] |  |  | 10 | 71 | 00:01:17.271000 | 7 |  | 5 |  | 00:01:13.068000
6 | [NAME] |  |  | 8 | 70 | 00:01:17.161000 | 8 |  | 6 |  | 00:01:13.298000
7 | [NAME] |  |  | 6 | 70 | 00:01:17.207000 | 6 |  | 7 |  | 00:01:13.050000
8 | [NAME] |  |  | 4 | 70 | 00:01:17.452000 | 11 |  | 8 |  | 00:01:13.584000
9 | [NAME] |  |  | 2 | 70 | 00:01:17.644000 | 16 |  | 9 |  | 00:01:14.129000
10 | [NAME] |  |  | 1 | 70 | 00:01:17.011000 | 15 |  | 10 |  | 00:01:14.053000
11 | [NAME] |  |  | 0 | 70 | 00:01:17.162000 | 13 |  | 11 |  | 00:01:13.804000
12 | Sebastien Buemi |  |  | 0 | 70 | 00:01:17.428000 | 14 |  | 12 |  | 00:01:13.919000
13 | [NAME] |  |  | 0 | 70 | 00:01:17.780000 | 17 |  | 13 |  | 00:01:14.182000
14 | [NAME] |  |  | 0 | 70 | 00:01:16.684000 | 12 |  | 14 |  | 00:01:13.801000
15 | [NAME] |  |  | 0 | 70 | 00:01:16.681000 | 10 |  | 15 |  | 00:01:13.571000
16 | [NAME] |  |  | 0 | 69 | 00:01:18.023000 | 19 |  | 16 |  | 00:01:15.068000
17 | [NAME] |  |  | 0 | 69 | 00:01:18.274000 | 9 |  | 17 |  | 00:01:13.761000
18 | Jarno [NAME] |  |  | 0 | 69 | 00:01:18.596000 | 20 |  | 18 |  | 00:01:15.358000
19 | [NAME] |  |  | 0 | 68 | 00:01:19.902000 | 23 |  | 19 |  | 00:01:17.019000
20 | [NAME] |  |  | 0 | 68 | 00:01:19.649000 | 22 |  | 20 |  | 00:01:16.890000
21 | [NAME] |  |  | - | 61 | 00:01:20.648000 | 21 |  | RET |  | 00:01:16.631000
22 | [NAME] |  |  | - | 46 | 00:01:17.209000 | 4 |  | RET |  | 00:01:12.480000
23 | Pastor Maldonado |  |  | - | 26 | 00:01:19.706000 | 18 |  | RET |  | 00:01:14.625000
24 | [NAME] |  |  | - | 21 | 00:01:21.773000 | 24 |  | RET |  | 00:01:17.060000
Spreadsheet: 130944d1322665593-re-arrange-a-worksheet-range-to-a-pivot-friendly-table-forumquestion-xytabletopivotfriendlytable
Sheet: Sheet1

 | SOURCE TABLE |  |  |  |  |  |  |  |  | DESTINATION TABLE
 | Timestamp | Task | Robb | Sansa | [NAME] | Arya | [NAME] |  |  | Timestamp | Task | Name | Score | Gender | Group | TaskCategory | TaskOther | HelperCell-Name_Task | HelperCell-Name_Date | Helper-Group_Task
 | 2011-11-29 15:45:08 | Task A | 6 | 4 | 5 | 8 | 9 |  |  | 2011-11-29 15:45:08 | Task A | Robb | 6
 | 2011-11-30 14:05:08 | Task B | 8 | 6 | 9 | 8 | 4 |  |  | 2011-11-29 15:45:08 | Task A | Sansa | 4
 | 2011-12-03 15:02:08 | Task A | 5 | 6 | 7 | 9 | 4 |  |  | 2011-11-29 15:45:08 | Task A | [NAME] | 5
 |  |  |  |  |  |  |  |  |  | 2011-11-29 15:45:08 | Task A | Arya | 8
 |  |  |  |  |  |  |  |  |  | 2011-11-29 15:45:08 | Task A | [NAME] | 9
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | Robb | 8
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | Sansa | 6
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | [NAME] | 9
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | Arya | 8
 |  |  |  |  |  |  |  |  |  | 2011-11-30 14:05:08 | Task B | [NAME] | 4
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | Robb | 5
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | Sansa | 6
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | [NAME] | 7
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | Arya | 9
 |  |  |  |  |  |  |  |  |  | 2011-12-03 15:02:08 | Task A | [NAME] | 4
 | SAMPLE DATA BELOW THIS ROW CAN BE IGNORED -- NOT RELEVENT TO QUESTION
 |  |  |  |  |  |  |  |  |  | TOTAL (ALL TASKS) | (Pink cells - dropdown)
 | Name | Gender | Group |  | Task | Category | Other |  |  | Group | KL
 | Robb | M | RR |  | Task A | Blue | UPHP |  |  | TOTAL (By Task):
 | Sansa | F | KL |  | Task B | Red | RUEO |  |  | Group: | RR | Task: | Task B | Total:
 | [NAME] | M | WF |  | Task C | Green | DHFO |  |  | INDIVIDUAL TOTAL (By Task)
 | Arya | F | KL |  | Task D | Blue | NSUU |  |  | Person: | Arya | Task: | Task A | Total:
 | [NAME] | M | WF
 | Jon | M | W |  | Group List
 |  |  |  |  | KL
 |  |  |  |  | RR
 |  |  |  |  | W
 |  |  |  |  | WF
Spreadsheet: daren_farmer__5329__SDSNOM
Sheet: Sheet1

SDSNOM.xls |  | Via Fax:  (713) 646-3239
TO:   [NAME], [NAME], [NAME]/HPL
FROM:   [NAME] (Previously TUFCO)
SUBJECT:   Gas Sales and Purchase Contract between TXU Fuels and SDS
Nomination of Estimated Monthly Quantity
 |  | Date |  | Estimated |  | Estimated
Nomination Month |  | Nominated |  | Daily Quantity |  | Monthly Quantity
 |  |  |  | MMBtu |  | MMBtu
2000
January
February
March
April
May
June |  | 2000-05-23 00:00:00 |  | 35000
July |  | 2000-06-23 00:00:00 |  | 35000
August
September
October
November
December
 |  |  |  |  | Total
Note:  Please advise immediately should you have any questions concerning the above.
C:      R. Skerik
[NAME]
G. Green
M. Jones
Spreadsheet: 781656d1653469541-tree-network-test_finding_route_node
Sheet: Sheet2

Node | Node | Length |  | route |  | Route No | Last | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv | Next_Prv
1 | 2 | 19 |  |  |  | 1
2 | 3 | 11
2 | 10 | 10
5 | 10 | 14
6 | 10 | 8
7 | 10 | 11
 |  |  |  |  | Route
 |  |  |  |  | 1 |  | Node | Node | Length
 |  |  |  |  |  | 1
 |  |  |  |  | Route
 |  |  |  |  | 2 |  | Node | Node | Length
 |  |  |  |  | Route
 |  |  |  |  | 3 |  | Node | Node | Length
 |  |  |  |  | Route
 |  |  |  |  | 4 |  | Node | Node | Length
 |  |  |  |  | Route
 |  |  |  |  | 5 |  | Node | Node | Length
Spreadsheet: vkaminski__40969__Benz_Curve
Sheet: benz_utilization

DATE | UTILIZATION | BENZ_PRC |  |  |  |  | UTILIZATION_BENZ
1993_QTR-1 | 0.7572743729647481 | 0.898921581297836 |  | CORREL
1993_QTR-2 | 0.7721198459218658 | 0.8185068711497868 |  |  |  |  | Regression Statistics
1993_QTR-3 | 0.7173614771831768 | 0.7725556082080444 |  |  |  |  | Multiple R | 0.4575400647576888
1993_QTR-4 | 0.762990544142389 | 0.7266043452663019 |  |  |  |  | R Square | 0.2093429108584701
1994_QTR-1 | 0.7371549548341751 | 0.9420008903057195 |  |  |  |  | Adjusted R Square | 0.1838378434668078
1994_QTR-2 | 0.8220158501155762 | 0.9017935352316949 |  |  |  |  | Standard Error | 0.0365542048877416
1994_QTR-3 | 0.8257654810681874 | 1.054007093726217 |  |  |  |  | Observations | 33
1994_QTR-4 | 0.7991789610089901 | 0.9621045678427318
1995_QTR-1 | 0.8753261111335643 | 0.9333850285041428 |  |  |  |  | ANOVA
1995_QTR-2 | 0.7784622652386218 | 0.7725556082080444 |  |  |  |  |  | df | SS | MS | F | [NAME]
1995_QTR-3 | 0.7939994951540196 | 0.637573773316676 |  |  |  |  | Regression | 1 | 0.01096747029272306 | 0.01096747029272306 | 8.207894832965836 | 0.007423901624148212
1995_QTR-4 | 0.7588358150157578 | 0.7696836542741855 |  |  |  |  | Residual | 31 | 0.04142250674422476 | 0.001336209894974992
1996_QTR-1 | 0.7605327285662468 | 0.8012751475466333 |  |  |  |  | Total | 32 | 0.05238997703694782
1996_QTR-2 | 0.690065327330251 | 0.8299946868852224
1996_QTR-3 | 0.729870532111581 | 0.8500983644222346 |  |  |  |  |  | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
1996_QTR-4 | 0.74636142823243 | 0.9836442223466736 |  |  |  |  | Intercept | 0.6970964477203712 | 0.03080905186307301 | 22.62635185329719 | 7.798956663325699e-21 | 0.6342609371299724 | 0.7599319583107699 | 0.6342609371299724 | 0.7599319583107699
1997_QTR-1 | 0.7622222778050375 | 0.9132813509671305 |  |  |  |  | X Variable 1 | 0.098063470903706 | 0.03422877599026265 | 2.864942378646638 | 0.007423901624149425 | 0.02825338308304154 | 0.1678735587243705 | 0.02825338308304154 | 0.1678735587243705
1997_QTR-2 | 0.8016326964646967 | 0.7754275621419032
1997_QTR-3 | 0.7400230950484111 | 0.7984031936127745
1997_QTR-4 | 0.8148771387632607 | 0.9707204296443085
1998_QTR-1 | 0.805899100791756 | 0.6677292896221945
1998_QTR-2 | 0.7673400316696857 | 0.637573773316676
1998_QTR-3 | 0.7453355861112508 | 0.6203420497135226
1998_QTR-4 | 0.7816500066394215 | 0.682089059291489
1999_QTR-1 | 0.7729766133986018 | 0.6619853817544766
1999_QTR-2 | 0.8023881888801411 | 0.67921710535763
1999_QTR-3 | 0.8237661712394195 | 0.9122761495612641
1999_QTR-4 | 0.8127091886283203 | 1.012220199046601
2000_QTR-1 | 0.8361076374772112 | 1.221585623295899
2000_QTR-2 | 0.8568708500839601 | 1.349674786275022
2000_QTR-3 | 0.8153188270292075 | 1.261505765447522
2000_QTR-4 | 0.7832326472534727 | 1.195020049407704
2001_QTR-1 | 0.804496403746572 | 1.048837611703302
2001_QTR-2 | 0.8247527703536217
2001_QTR-3 | 0.8174261089875376
2001_QTR-4 | 0.8081713550058316
Spreadsheet: 111763d1308070034-excel-graph-wont-show-negative-numbers-breakeven2
Sheet: Sheet1

Units | Cost | Revenue | Profit
1 | 163 | 0
2 | 163 | 0
3 | 163 | 0
4 | 1716 | 0
5 | 1716 | 0
6 | 1716 | 0
7 | 1716 | 720
8 | 1716 | 900
9 | 1716 | 1260
10 | 1716 | 1980
11 | 3000 | 2700
12 | 3000 | 3780
13 | 3000 | 5210
14 | 3000 | 6815
15 | 3000 | 7955
16 | 3000 | 9345
17 | 3000 | 11165
Spreadsheet: 725431d1616674131-help-looking-to-sum-columns-based-on-a-start-and-end-date-cmf
Sheet: Sheet1 (2)

Start Date | 2020-05-01 00:00:00
End Date | 2020-07-01 00:00:00
 |  | Totals | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00
A |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
B |  |  | 2 | 3 | 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
C |  |  | 3 | 4 | 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
D |  |  | 4 | 5 | 6 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
E |  |  | 5 | 6 | 7 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
F |  |  | 6 | 7 | 8 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
G |  |  | 7 | 8 | 9 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
H |  |  | 8 | 9 | 10 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
I |  |  | 9 | 10 | 11 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
J |  |  | 10 | 11 | 12 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
K |  |  | 11 | 12 | 13 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11
L |  |  | 12 | 13 | 14 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12
M |  |  | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
N |  |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
O |  |  | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
 |  |  | I am trying to get a  total in Col C for Figures based on months chosen between columns  B4 and B5
Spreadsheet: 86523d1286482285-excel-2007-combining-data-from-multiple-excel-files-sample
Sheet: week 1

Service Center: | XXXX | XXXX
Year: | 2010
Period: | week 1
Category Y
Y
 | Level | Price | VAT | QTY | Less | Total | Amount | Sub VAT | Total Amount |  | A | B | C | D | E
** | 0 | 5 |  |  |  | 0 | 0 |  | 0 |  |  | 50 | 90
** | 1 | 10 |  |  |  | 0 | 0 |  | 0 |  | 303 | 3 | 108 | 8
** | 2 | 15 |  |  |  | 0 | 0 |  | 0 |  | 41 | 2547 | 711 | 106 | 2
** | 3 | 20 |  |  |  | 0 | 0 |  | 0 |  | 2 | 217 | 15 | 157
Total |  |  |  | 0 | 0 | 0 |  |  | 0
Category Z
Z |  |  |  |  |  |  |  |  |  |  | F |  |  | F total | G |  |  |  |  |  |  |  | G total
 | Level | Price | VAT | QTY | Less | Total | Amount | Sub VAT | Total Amount |  | F1 | F2 | F3 |  | [NAME] | G2 | G3 | G4 | G5 | G6 | G7 | G8
** | 0 | 5 |  |  |  | 0 | 0 |  | 0 |  | 5 | 5 | 5 | 15 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
** | 1 | 10 |  |  |  | 0 | 0 |  | 0 |  | 6 | 6 | 6 | 18 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 16
** | 2 | 15 |  |  |  | 0 | 0 |  | 0 |  | 7 | 7 | 7 | 21 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 24
** | 3 | 20 |  |  |  | 0 | 0 |  | 0 |  | 8 | 8 | 8 | 24 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 32
Total |  |  |  | 0 | 0 | 0 |  |  | 0
Total |  |  |  | 0 | 0 | 0 |  |  | 0
Spreadsheet: 769369d1645513755-transposing-decimal-data-set-to-a-row-column-timetable-transposing-decimal-data-ans
Sheet: Sheet1

6.39
6.57
6.75
6.93
7.11
7.29
7.47
7.65
7.83
8.01000000000001
8.19000000000001
8.37000000000001
8.55000000000001
8.73000000000001
8.91000000000001
9.09000000000001
9.27000000000001
9.45000000000001
9.63000000000001
9.81000000000001
9.99000000000001
10.17
10.35
10.53
10.71
10.89
11.07
11.25
11.43
11.61
Spreadsheet: 185428d1349710206-count-multiple-criteria-in-a-single-cell-vacationhelp
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation Days: |  |  | 10 | Sick Days: |  | 6
 | 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 | VA | VB | SA | SB | LL | LE | H | T | U | E | J | B
January
Notes:
February
Notes:
March
Notes:
April
Notes:
May
Notes:
June
Notes:
July
Notes:
August
Notes:
September
Notes:
October
Notes:
November
Notes:
December
Notes:
Vacation Days Remaining: |  |  |  |  |  |  |  |  |  |  |  | Sick Days Remaining: |  |  |  |  |  |  |  |  |  | TOTALS:
VA = Full Day Vacation, VB = Half Day Vacation, SA = Full Day Sick, SB = Half Day Sick, LL = Long Lunch, LE = Leave Early, H = Holiday, T = Tardy, U = Unexcused, E = Excused, J = Jury Duty, B = Berevement
Spreadsheet: 221300d1363458496-attemepting-to-link-and-automate-multiple-data-points-individual-rep-kpi-report-2013-example
Sheet: Joe

 | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jan-Jun Total
Results | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team
[NAME]
Act Rev
% to Goal
AB Goal
Act AB
% to Goal
[NAME]
Act Conv
% to Goal
Activity | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jan-Jun Total
Dial p/hr Goal |  | 8 |  |  | 8 |  |  | 7 |  |  | 7 |  |  | 7 |  |  | 7
Act Dial p/hr
% to Goal
Dial Total Goal
Act Total Dials
% to Goal
[NAME] Goal |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00 |  |  | 1:55:00
Act Avg Call Time
% to Goal
Drivers | Jan |  |  | Feb |  |  | Mar |  |  | Apr |  |  | May |  |  | Jun |  |  | Jan-Jun Total
OP Days |  | 20 |  |  | 21 |  |  | 21 |  |  | 21 |  |  | 22 |  |  | 21
FTE Count |  | 7.89 |  |  | 8.17 |  |  | 8.17 |  |  | 8.23 |  |  | 8.56 |  |  | 8.9
Man Hours
 | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jul-Dec Total
Results | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team |  | Rep | Team
[NAME]
Act Rev
% to Goal
AB Goal
Act AB
% to Goal
[NAME]
Act Conv
% to Goal
Activity | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jul-Dec Total
Dial p/hr Goal | 7 | 7
Act Dial p/hr
% to Goal
Dial Total Goal
Act Total Dials
% to Goal
[NAME] Goal | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00 |  | 1:55:00 | 1:55:00
Act Avg Call Time
% to Goal
Drivers | Jul |  |  | Aug |  |  | Sep |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jul-Dec Total
OP Days
FTE Count |  | 9.81
Man Hours
 | 2012 Total |  |  |  |  |  |  |  |  | 2012 Total |  |  |  |  |  | Drivers |  |  | 2012 Total
Results | Rep | Team |  |  |  |  | Activity |  |  | Rep | Team |  |  |  |  | OP Days
[NAME] |  |  |  |  |  |  | Dial p/hr Goal |  |  |  |  |  |  |  |  | FTE Count
Act Rev |  |  |  |  |  |  | Act Dial p/hr |  |  |  |  |  |  |  |  | Man Hours
% to Goal |  |  |  |  |  |  | % to Goal
AB Goal |  |  |  |  |  |  | Dial Total Goal
Act AB |  |  |  |  |  |  | Act Total Dials
% to Goal |  |  |  |  |  |  | % to Goal
[NAME] |  |  |  |  |  |  | [NAME] Goal |  |  | 1:55:00 | 1:55:00
Act Conv |  |  |  |  |  |  | Act Avg Call Time
% to Goal |  |  |  |  |  |  | % to Goal
Spreadsheet: shelley_corman__38758__Total throughput
Sheet: TW THRUPUTVOL

[NAME]
 |  | THROUGHPUT
YEAR | AREA | Volume
1999 | California | 298585905
1999
1999 Total
2000 | California | 339717516
2000
2000 Total
2001 | California | 262422374
2001
2001 Total |  | 493369000
Spreadsheet: 75298d1275893801-excel-2007-compressing-a-multiple-line-table-into-one-line-bok1
Sheet: Data

Customer | apples | pears | bananas | tomatoes | other
1823 |  |  |  |  | x
1823 |  |  |  | x
1823 |  |  | x
1823 |  | x
1823 | x
1621 |  |  |  |  | x
1688 |  |  |  |  | x
1688 |  | x