tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115374d1311011032-help-to-create-matrix-table-bookarrangement
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  | Week 1 | Table1 | 1 | 2 | 3 | 1 2 3 | 1
 |  | Week 1 | Table2 | 4 | 5 | 6 | 4 5 6 | 2
 |  | Week 1 | Table3 | 7 | 8 | 9 | 7 8 9 | 3
 |  | Week 2 | Table1 | 1 | 4 | 7 | 1 4 7 | 4
 |  | Week 2 | Table2 | 2 | 5 | 8 | 2 5 8 | 5
 |  | Week 2 | Table3 | 3 | 6 | 9 | 3 6 9 | 6
 |  | Week 3 | Table1 | 1 | 5 | 9 | 1 5 9 | 7
 |  | Week 3 | Table2 | 2 | 6 | 7 | 2 6 7 | 8
 |  | Week 3 | Table3 | 3 | 4 | 8 | 3 4 8 | 9
 |  | Week 4 | Table1 | 1 | 6 | 8 | 1 6 8
 |  | Week 4 | Table2 | 2 | 4 | 9 | 2 4 9
 |  | Week 4 | Table3 | 3 | 5 | 7 | 3 5 7
Spreadsheet: 55499d1255614564-help-with-if-formula-or-something-else-draft-1-
Sheet: Sheet1

x |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
x |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | Amare Stoudemire | Amare Stoudemire
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
Spreadsheet: 98512d1297372819-excel-2007-multiple-variable-length-lists-to-1-list-variable-length-lists-to-one-list
Sheet: Sheet1

LISTS GENERATED BY INPUT - LENGTH (NUMBER OF ROWS VARIES BASED ON INPUT) |  |  |  |  |  |  |  |  |  |  |  |  | COMBINED LIST I'D LIKE TO BE AUTOMATICALLY CREATED (NO BLANKS)
LIST 1 |  |  | LIST 2 |  |  | LIST 3 |  |  | LIST 4
X | Y | Z | X | Y | Z | X | Y | Z | X | Y | Z |  | X | Y | Z
L1 R1 | L1 R1 | L1 R1 | [NAME] | [NAME] | [NAME] | L3 R1 | L3 R1 | L3 R1 | [NAME] | [NAME] | [NAME] |  | L1 R1 | L1 R1 | L1 R1
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
L1 R3 | L1 R3 | L1 R3 | L2 R3 | L2 R3 | L2 R3 | L3 R3 | L3 R3 | L3 R3 | [NAME] | [NAME] | [NAME] |  | L1 R3 | L1 R3 | L1 R3
L1 R4 | L1 R4 | L1 R4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | L1 R4 | L1 R4 | L1 R4
 |  |  | [NAME] | [NAME] | [NAME] | L3 R5 | L3 R5 | L3 R5 | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 |  |  | [NAME] | [NAME] | [NAME] | L3 R6 | L3 R6 | L3 R6 | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R7 | L2 R7 | L2 R7 | L3 R7 | L3 R7 | L3 R7 | [NAME] | [NAME] | [NAME] |  | L2 R3 | L2 R3 | L2 R3
 |  |  | [NAME] | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R9 | L2 R9 | L2 R9 |  |  |  | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R10 | L2 R10 | L2 R10 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R11 | L2 R11 | L2 R11 |  |  |  |  |  |  |  | L2 R7 | L2 R7 | L2 R7
 |  |  | L2 R12 | L2 R12 | L2 R12 |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  | L2 R13 | L2 R13 | L2 R13 |  |  |  |  |  |  |  | L2 R9 | L2 R9 | L2 R9
 |  |  |  |  |  |  |  |  |  |  |  |  | L2 R10 | L2 R10 | L2 R10
[NAME] FOR ALL LISTS (15 ROWS) |  |  |  |  |  |  |  |  |  |  |  |  | L2 R11 | L2 R11 | L2 R11
 |  |  |  |  |  |  |  |  |  |  |  |  | L2 R12 | L2 R12 | L2 R12
 |  |  |  |  |  |  |  |  |  |  |  |  | L2 R13 | L2 R13 | L2 R13
 |  |  |  |  |  |  |  |  |  |  |  |  | L3 R1 | L3 R1 | L3 R1
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | L3 R3 | L3 R3 | L3 R3
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | L3 R5 | L3 R5 | L3 R5
 |  |  |  |  |  |  |  |  |  |  |  |  | L3 R6 | L3 R6 | L3 R6
 |  |  |  |  |  |  |  |  |  |  |  |  | L3 R7 | L3 R7 | L3 R7
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
Spreadsheet: c8afe22b-b925-40db-b976-196da068ce26
Sheet: Sheet5

IACUC Member Training 5/20/2011 thru 5/20/2013
 | First Name | Last Name | Curriculum | Date Completed
1 | [NAME] | [NAME] | Essentials for IACUC Members | 2011-07-20 17:37:14
2 | cesario | bianchi | Essentials for IACUC Members | 2012-01-26 23:22:13
3 | [NAME] | Chung | Essentials for IACUC Members | 2011-12-22 14:42:21
4 | Stephen | Gregory | Essentials for IACUC Members | 2011-11-10 12:01:02
5 | Fusun | [NAME] | Essentials for IACUC Members | 2011-11-13 18:17:42
6 | [NAME] | Hankinson | Essentials for IACUC Members | 2011-01-19 14:13:55
7 | Lara | Helwig | Essentials for IACUC Members | 2012-10-22 09:12:45
8 | [NAME] | Hulsebos | Essentials for IACUC Members | 2006-05-31 12:40:00
9 | [NAME] | Hulsebos | Essentials for IACUC Members | 2011-07-21 19:30:46
10 | [NAME] | [NAME] | Essentials for IACUC Members | 2010-06-08 10:34:47
11 | Roland | Lariviere | Essentials for IACUC Members | 2011-09-01 14:19:14
12 | [NAME] | McBride | Essentials for IACUC Members | 2012-05-06 11:31:11
13 | Peggy | McGill | Essentials for IACUC Members | 2011-06-03 13:53:29
14 | [NAME] | Moore | Essentials for IACUC Members | 2011-07-20 21:54:25
15 | [NAME] | NYIRIMANA | Essentials for IACUC Members | 2011-11-29 04:23:01
16 | j | p | Essentials for IACUC Members | 2011-06-06 08:47:13
17 | bharat | ramratnam | Essentials for IACUC Members | 2011-11-22 12:40:56
18 | [NAME] | Riter | Essentials for IACUC Members | 2011-11-17 11:07:51
19 | [NAME] | Sheff | Essentials for IACUC Members | 2011-09-13 20:48:12
20 | [NAME] | Sousa | Essentials for IACUC Members | 2011-07-26 16:40:06
21 | [NAME] | Stefani | Essentials for IACUC Members | 2012-03-06 12:07:41
22 | [NAME] | Susa | Essentials for IACUC Members | 2011-12-23 20:34:45
23 | [NAME] | Tolbert | Essentials for IACUC Members | 2011-09-16 09:34:11
24 | [NAME] | [NAME] | Essentials for IACUC Members | 2011-08-01 17:06:19
25 | Olivier | [NAME] | Essentials for IACUC Members | 2011-01-03 10:58:23
Spreadsheet: scott_neal__38020__Hot List 0511
Sheet: 2Q Summary

E N R O N   N O R T H   A M E R I C A - H O T  L I S T
2Q 2000
Deals Identified |  | Team |  |  |  | Value
Chicago - Gas |  | East Midstream |  |  |  | 3000
Tenaska - Cleeborne |  | Generation Investments |  |  |  | 19216
West QF's |  | West Midstream |  |  |  | 9100
Other
Great River |  | East Midstream |  |  |  | 727.233
Palm Springs/SSF |  | West Midstream |  |  |  | 580
Wilson Cntr Agency Fee |  | East Midstream |  |  |  | 83
Spreadsheet: 857610d1706589724-find-alfanumeric-values-and-make-a-sum-sum-from-e-xxx
Sheet: Blad1

 | qty | value | value
349220243 | 4 | 10 | 2 |  |  |  |  | Sort out the values and net with items
981734143 | 5 | 20 | 4 |  |  |  |  | that start with an "E" to accumulated sum
473367462 | 6 | 30 | 5 |  |  |  |  | C-column | D-column | C-column | D-column
756295285 | 5 | 40 | 6 |  |  |  |  | EXXXX item | Exxxx item net | All other items with numbers
E1234567 | 9 | 10 | 2
E2345678 | 2 | 20 | 4
E3219876 | 2 | 30 | 5
E2187239 | 7 | 40 | 6
 |  | 1000 | 1000 |  |  |  |  | Values with no numbers or E-xxxx should not be calculated
Spreadsheet: 860479d1708559696-splitting-names-in-a-cell-and-take-corresponding-values-testbook-dj
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total |  | Site | Year | Month | Quarter
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  | site, year, month, quarter, should auto populate |  |  |  |  | The formula in column Q slows down when there's lots of data. It also correctly splits the names which have a , in between them along with the values. but I want the corresponding site name, year, month and quarter to display too.
Red | 2020 | Dec | Q4 | [NAME] | 90 | External
Red | 2020 | Dec | Q1 | [NAME] | 80 | External
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal
Yellow | 2020 | Dec | Q2 | Mark | 60 | External |  |  |  |  |  | 2020 | Dec | Q4 | [NAME] | 100
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal |  |  |  |  | Red | 2020 | Dec | Q4 | [NAME] | 90
Blue | 2020 | Dec | Q4 | Mark | 81 | External |  |  |  |  | Red | 2020 | Dec | Q1 | [NAME] | 80
Green | 2020 | Dec | Q4 | [NAME] | 91 | Internal |  |  |  |  | Yellow | 2020 | Dec | Q1 | [NAME] | 70
Green | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  | Yellow | 2020 | Dec | Q1 | [NAME] | 60
Green | 2023 | Jan | Q1 | [NAME], [NAME] | 2 | Internal |  |  |  |  | Blue | 2020 | Dec | Q1 | [NAME] | 50
 |  |  |  |  |  |  |  |  |  |  | Yellow | 2020 | Dec | Q2 | Mark | 60
 |  |  |  |  |  |  |  |  |  |  | Green | 2020 | Dec | Q2 | [NAME] | 70
 |  |  |  |  |  |  |  |  |  |  | Blue | 2020 | Dec | Q4 | Mark | 81
 |  |  |  |  |  |  |  |  |  |  | Green | 2020 | Dec | Q4 | [NAME] | 91
 |  |  |  |  |  |  |  |  |  |  | Green | 2020 | Dec | Q4 | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  | Green | 2023 | Jan | Q1 | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  | Green | 2023 | Jan | Q1 | [NAME] | 2
Spreadsheet: 885078d1734504494-how-to-return-second-from-last-entry-in-a-column-forum
Sheet: Speckles

Current Sample | White | [NAME] | Nil | Lab Sample | Soluble | Plant Warehouse
New Sample | Off-white | [NAME] | Sand | [NAME] | Insoluble | 74 Warehouse
Not Available |  | Tinotenda | Plant Fibre | [NAME] |  | Plant Processing |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kg |  |  | L
1 |  | Patience | Paper | [NAME] |  | New |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Silicate |  |  | Water
2 |  | Mitchelle | Metal | Innocent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ratio
3 |  | Vincent | Plastic | Mathew |  |  | Certificate of Analysis
4 |  | Agritta | Other | Kavhu
5 |  | Casandra |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3750
6 |  | Day Shift Rep
7 |  | Night Shift Rep |  |  |  |  | Key
8 |  |  |  |  |  |  | Not Acceptable |  |  |  |  | 1 |  | Within Spec |  |  |  |  | 6 | Caution |  |  |  |  |  | 3
9
10 |  |  |  |  |  |  | Date | Time | Supplier | Source | Batch No. | Color | Solubility | Impurities | Density |  | pH | Particle Size Distribution |  |  |  |  |  | Moisture | Personnel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mesh
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g/100ml | g/L |  | Weight  (g) | 14 | 35 | 60 | 14 - 35 | Weight Loss | < 5% | Analyst | Attendant
13 |  |  |  |  |  |  | 1900-08-02 00:00:00 | 1231hrs |  | Plant Processing |  |  | Soluble | Nil | 92.21 |  | 9.81 |  |  |  |  |  |  | 0.0068 | Vincent | -
14 |  |  |  |  |  |  | 2024-08-05 00:00:00 | 1425hrs | - | Plant Processing | New Sample | Purple | Soluble | Nil | 92.376 |  | 9.16 | 50.005 | 0.688 | 28.352 | 20.912 |  |  | 0.0029 | Casandra | Praise
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
18
19
20
21
22
23
24
25
27
28
29
30
31
Spreadsheet: 112692d1308735146-consolidating-values-book1_appsupportkarl
Sheet: Sheet1

Invioce No
Invioce 1
Invioce 2
Invioce 3
Invioce 4
Invioce 5
Invioce 6
Invioce 7
Invioce 8
Invioce 9
Invioce 10
Invioce 1
Invioce 12
Invioce 13
Invioce 14
Invioce 1
Invioce 16
Invioce 17
Invioce 18
Invioce 19
Invioce 20
Invioce 2
Invioce 22
Invioce 23
Invioce 24
Invioce 25
Invioce 26
Invioce 2
Invioce 28
Invioce 29
Invioce 30
Invioce 31
Invioce 32
Invioce 3
Invioce 34
Invioce 35
Invioce 16
Invioce 37
Invioce 38
Invioce 39
Spreadsheet: louise_kitchen__23137__cost allocation
Sheet: Sheet1

BUDGET 2002 RATE AND CURRENCY COST ALLOCATION
Rate & Currency Cost Allocation
Direct | 4732094
Indirect costs | 3682500 | used 2001 estimate w) 5% escalotor
Total
 |  |  | 2nd Qtr | July | August |  | Average |  | Tier 1 Cost Alloc |  | Tier 2: Cost Allocations | Tier 2 Cost Allocation |  | TOTAL % OF ALLOCATED COST |  | Total Direct Cost Allocated | Total Indirect Cost Allocated |  | BUDGET 2002
 |  |  | (Absolute %) | (Absolute %) | (Absolute %) |  | Absolute % |  | (70% on Drift %s ABS) |  | (30% on FX trade count) | 30% on FX trade count |  |  |  |  | Est based upon 8/01 YTD w) 105% escalator
 |  |  |  |  |  |  |  |  |  |  | FX Trade Count
Company Code
EBS |  |  | 0.0002671237908678321 | 0.00552682075511762 | 0.008528715282873457
EEL |  |  | 0.2549833044408994 | 0.2651658382399938 | 0.2804216364282229
EES |  |  | 0.0873852167125976 | 0.1262301555174119 | 0.2137846343338654
EGM |  |  | 0.02162314934107166 | 0.06143357289849913 | 0.02920504269779405
EIM |  |  | 0.01370677359890024 | 0.02195826933503492 | 0.03432478955419653
ENA |  |  | 0.6042703071678616 | 0.5021450893924669 | 0.4178934290251035
NOR |  |  | 0.01776412494780173 | 0.01754025386147568 | 0.01584175267794434
Grand Total
Spreadsheet: 215230d1361310288-create-top-ten-list-based-on-number-of-classes-currently-overdue-desired-result
Sheet: Overdue

Overdue Top Ten
RANK | CCODE | TITLE | QUANTITY
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 168892d1342622444-excel-2007-retrieving-data-from-import-test
Sheet: IEX

From: 07/18/12                       IEX TotalView                                 Summary
To: 07/18/12                   Results Techonologies                               Daily
Shift:  0 All Day                Time Utilization Report                          Page:   1
MU: 750 GALAX SXM
Time Zone: US/Eastern
Report Across Agent Moves: No  Report Agent Moves: No
Include Codes: ALL
Sort By Exception Code Group: Yes
Show Exception Code Group Totals For Selected Exception Codes: Yes
Show Exception Code Details: Yes
Duration               Duration
Exception Code             HH:MM  Percent         HH:MM  Percent
Summary Data For: Date: 07/18/12
Total Agents:  119
Planned                   898:45   87.75%
Aux 2                                        34:40    3.38%
Lunch                                        59:00    5.76%
Open Time                                   805:05   78.61%
Un-Planned                  0:12    0.02%
Aux 3                                         0:12    0.02%
Absent P                   24:00    2.34%
Leave Of Absence                              8:00    0.78%
Paid Time Off                                 8:00    0.78%
Unpaid Time Off                               8:00    0.78%
Absent UP                  67:33    6.60%
Leave Early                                   7:03    0.69%
Tardy/Late - Call In                          0:30    0.05%
Tardy/Late - No Call                          4:00    0.39%
Termed                                       16:00    1.56%
Unplanned Absent                             40:00    3.91%
Work Types                 12:30    1.22%
Off Line Support                             12:30    1.22%
Hours Perspective          21:10    2.07%
Overtime                                     21:10    2.07%
Total                    1024:10
Spreadsheet: 73138d1273779019-index-and-match-benefits
Sheet: NCOS Fees

Code | Procedure | Fee
0150 | Limited Exam | 73
0210 | FMX | 0
0220 | X-ray PA | 43
0240 | Occlusal | 72
0330 | Panorex | 111
0350 | Photos | 41
3410 | Apicoectomy | 559
3421 | [NAME] | 559
3450 | Root Amputation | 234
4210 | Gingivectomy | 528
4249 | [NAME] | 578
4263 | [NAME] w/tooth | 375
4272 | Vestibuloplasty | 1476
4274 | Wedge Resection | 330
4342 | Root Planning | 515
7953 | Graft w/Ext. | 386
6010 | Implant | 2399
6095 | Repair of Abutment | 242
6100 | Implant Removal | 303
7140 | Routine Extraction | 213
7210 | Surgical Extraction | 303
7220 | Soft Tissue Ext. | 387
7230 | Partial [NAME]. | 465
7240 | [NAME]. | 582
7241 | Difficult Ext. | 610
7261 | Sinus Closure | 1236
7270 | Stabilization | 373
7280 | Surgical exposure  unerupted tooth | 697
7283 | Placement of device to aid in eruption | 115
7285 | Biopsy, Hard Tissue | 402
7286 | Biopsy, [NAME] | 445
7310 | Alveoloplasty w/ext 4 or more | 354
7311 | Alveoloplasty w/ext 1 - 3 teeth | 354
7320 | Alveoleplasty 4 or more | 435
7321 | Alveoleplasty 1-3 teeth | 395
7450 | Removal of Cyst/Tumor up to 1.25 cm | 713
7451 | Removal of Cyst/Tumor greater than 1.25 cm | 924
7461 | Marssupialation | 695
7471 | Removal exostosis | 827
7472 | Tori Palatal Excision | 942
7473 | Tori Quad Excision | 709
7485 | Tuberosity | 800
7510 | I & D | 376
7530 | [NAME] | 286
7540 | [NAME] | 385
7870 | Arthocentesis | 677
7950 | [NAME] | 390
7951 | Sinus Augmentation | 1873
7953 | Bone Graft Extensive | 390
7970 | Ex Hyperplastic Tissue | 453
9110 | Emergency Exam Pain | 77
9120 | Section Partial | 371
9210 | LA w/o [NAME] | 56
9220 | GA 30 min | 395
9221 | GA add 15 min | 157
9230 | Nitrous | 103
9241 | IV Sedation 30 min | 374
9242 | IV Sedation 15 min | 122
9310 | Consult/TMJ | 155
9610 | Theraputic Injection | 56
Spreadsheet: 85479d1285598808-getting-pivot-table-to-give-monthly-average-pivottableaverage
Sheet: Sheet1

Category | Date | Value |  |  |  | Data
A | 2010-01-02 00:00:00 | 37 |  | Category | Date | Sum of Value | Average of Value
A | 2010-01-03 00:00:00 | 33 |  | A | Jan | 105 | 35
B | 2010-01-04 00:00:00 | 35 |  |  | Feb | 73 | 36.5
C | 2010-01-05 00:00:00 | 34 |  |  | Mar | 108 | 36
A | 2010-01-06 00:00:00 | 35 |  |  | Apr | 35 | 35
B | 2010-01-07 00:00:00 | 33 |  |  | May | 70 | 35
C | 2010-02-12 00:00:00 | 33 |  | A Total |  | 391 | 35.54545454545455 | <---- Would like Monthly Average
A | 2010-02-13 00:00:00 | 37 |  | B | Jan | 68 | 34
B | 2010-02-14 00:00:00 | 38 |  |  | Feb | 74 | 37
C | 2010-02-15 00:00:00 | 34 |  |  | Mar | 71 | 35.5
A | 2010-02-16 00:00:00 | 36 |  |  | Apr | 37 | 37
B | 2010-02-17 00:00:00 | 36 |  |  | May | 72 | 36
C | 2010-02-18 00:00:00 | 36 |  | B Total |  | 322 | 35.77777777777778
A | 2010-03-26 00:00:00 | 34 |  | C | Jan | 34 | 34
B | 2010-03-27 00:00:00 | 33 |  |  | Feb | 103 | 34.33333333333334
C | 2010-03-28 00:00:00 | 33 |  |  | Mar | 33 | 33
A | 2010-03-29 00:00:00 | 37 |  |  | Apr | 36 | 36
A | 2010-03-30 00:00:00 | 37 |  |  | May | 105 | 35
B | 2010-03-31 00:00:00 | 38 |  | C Total |  | 311 | 34.55555555555556
C | 2010-04-01 00:00:00 | 36 |  | Grand Total |  | 1024 | 35.31034482758621
A | 2010-04-02 00:00:00 | 35
B | 2010-04-03 00:00:00 | 37
C | 2010-05-09 00:00:00 | 37
A | 2010-05-10 00:00:00 | 37
B | 2010-05-11 00:00:00 | 36
C | 2010-05-12 00:00:00 | 34
A | 2010-05-13 00:00:00 | 33
B | 2010-05-14 00:00:00 | 36
C | 2010-05-15 00:00:00 | 34
Spreadsheet: 734497d1622206945-help-with-conditional-vlookup-formula-workbook
Sheet: Sheet1

FILL THIS OUT
Provider | ABC | or | NEW |  |  |  |  |  |  |  | for NEW ONLY |  | for ABC ONLY
Primary KPI | Familiarity |  |  |  |  |  |  |  |  | reference cells
Secondary KPI | Affinity |  |  |  |  |  |  |  |  | Affinity | Like itLike it | Love itLove it | Like it | Love it
Other KPIs | Purchase Intent |  |  |  |  |  |  |  |  | Awareness | Selected
 |  |  |  |  |  |  |  |  |  | CTA | Somewhat likely | Very likely
 |  |  |  |  |  |  |  |  |  | Consideration | Somewhat likely | Very likely
 |  |  |  |  |  |  |  |  |  | Purchase Intent | Somewhat likely | Very likely
 |  |  |  |  |  |  |  |  |  | Familiarity | Extremely familiar | Very familiar
calculated formulas
Primary KPI Value
Secondary KPI Value
Other KPIs
Spreadsheet: 238139d1369408743-use-value-multiple-times-before-hiding-it-in-a-drop-down-list-validationlist
Sheet: Datavalidation

Validation | helper column |  |  |  |  |  | names left: |  | Original List Names (each x3) | helper column
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
Adam |  |  |  |  |  |  |  |  | Adam
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | Adam
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Adam
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 37777d1235780229-count-the-occurence-of-a-value-across-multiple-worksheets-example1-a
Sheet: 1704

RANK | NAME | WORK UNIT
1 | id magna | [NAME]
2 | risus nunc | sagittis ultrices
3 | mauris suspendisse | [NAME]
4 | vestibulum nisl | in ultricies
5 | tortor vitae | ipsum convallis
6 | tortor vitae | hendrerit turpis
7 | est nec | sapien vivamus
8 | suscipit vehicula | urna euismod
Spreadsheet: 5ca22c18-3781-4eee-afb2-becd8033d933
Sheet: Affordability-Financial Aid

Achieve 2015
Affordability
Maintain tuition and fees at less than half of the comparable cost of attending Virginia’s public four-year institutions, and increase the annual number of students who receive financial assistance through grants and scholarships by 36,000.
 | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2011-2012 | 2012-2013 | 2013-2014 | 2014-2015 |  | Grant & Scholarship Recipients
Grant & Scholarship Recipients | 53917 | 62996 | 83056 | 96557 |  |  |  |  |  | College | 2007-2008 | 2008-2009 | 2009-2010 | 2010-2011 | 2012-2013 | 2013-2014 | 2014-2015
 |  |  |  |  |  |  |  |  |  | MECC | 2460 | 2473 | 2693 | 3120
 | 87000 | 87000 | 87000 | 87000 | 87000 | 87000 | 87000 | 87000
Spreadsheet: 699e7748-a7ed-444a-835b-270252f16907
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
35867943 | 2013-05-09 22:44:13 | ALLIES | 1 | 7 | 4 | 1229610 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
35868226 | 2013-05-09 23:05:03 | AXIS | 0 | 6 | 7 | 1229610 | [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
35919248 | 2013-05-13 04:57:02 | ALLIES | 1 | 7 | 2 | 1273928 | *[NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35919516 | 2013-05-13 05:26:45 | AXIS | 0 | 5 | 6 | 1326694 | player1326694 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
35919694 | 2013-05-13 05:40:00 | ALLIES | 1 | 6 | 4 | 1326694 | player1326694 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
35919832 | 2013-05-13 06:03:09 | ALLIES | 1 | 7 | 4 | 154281 | Mr [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35920062 | 2013-05-13 06:20:00 | AXIS | 0 | 2 | 7 | 154281 | Mr [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
35920218 | 2013-05-13 06:33:10 | ALLIES | 0 | 1 | 6 | 154281 | Mr [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
35920298 | 2013-05-13 06:47:04 | AXIS | 0 | 3 | 6 | 154281 | Mr [NAME] | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: 43077d1241679805-spreadsheet-data-to-chart-graph-help-data-to-chart-graph-help-lizzy-project1
Sheet: Pivot Data

Sum of Hours Spent
Age | Sex | Total
20-30 | F | 4.25
 | M | 4.75
20-30 Total |  | 9
30-40 | F | 5.25
 | M | 2
30-40 Total |  | 7.25
40-50 | F | 5.5
 | M | 5
40-50 Total |  | 10.5
50+ | F | 39.75
 | M | 16.25
50+ Total |  | 56
Under 20 | F | 0.5
 | M | 0.25
Under 20 Total |  | 0.75
Grand Total |  | 83.5
Spreadsheet: 104361d1302008116-comparing-tables-looking-for-diferences-book1_xanduba
Sheet: Sheet1

exams done: |  |  |  |  | exams paid: |  |  |  |  | exams not paid: |  |  |  | exams paid in error:
2011-01-01 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-01 00:00:00 | 2000111 | [NAME]
2011-01-01 00:00:00 | 2001122 | [NAME] |  |  | 2011-01-02 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-01 00:00:00 | 2001122 | [NAME]
2011-01-01 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-02 00:00:00 | 2929292 | [NAME] |  |  | 2011-01-01 00:00:00 | 2000111 | [NAME]
2011-01-02 00:00:00 | 2000111 | [NAME] |  |  | 2011-01-03 00:00:00 | 2001122 | Russian Troll
2011-01-02 00:00:00 | 2929292 | [NAME] |  |  | 2011-01-03 00:00:00 | 4823111 | [NAME] |  |  |  |  |  |  | 2011-01-03 00:00:00 | 4823111 | [NAME]
2011-01-03 00:00:00 | 2000111 | [NAME] |  |  |  |  |  |  |  | 2011-01-03 00:00:00 | 2000111 | [NAME]
2011-01-03 00:00:00 | 2001122 | Russian Troll