tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59a02d70-d777-4820-a50d-a27fa15a6b8d
Sheet: Nijvdal 03 juni

[NAME] HEREN TE NIJVERDAL 03 JUNI 2012
BAAN 1 wedstrijd 4 niv. 11, 10, 9, 8 V |  |  |  |  |  |  | Supervisor: |  | BAAN 2 wedstrijd 4 niv 7, 6 V en 8, 7 en 6 K
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Invaller: | [NAME] (waar mogelijk)
Godfried Nankoe |  |  |  |  |  |  | VLOER |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | Juryvergadering: 08.50 uur
Arno Pluk |  |  |  |  |  |  | PAARD-VOLTIGE |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | RINGEN |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | Ciska Fonville
[NAME] |  |  |  |  |  |  | SPRONG |  | Annelies Moltzer
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | BRUG |  | [NAME]
[NAME] |  |  |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | REKSTOK |  | [NAME]
Gé Meijer |  |  |  |  |  |  |  |  | [NAME]
[NAME] HEREN TE NIJVERDAL 03 JUNI 2012
Supervisor: |  | Baan 1 wedstrijd 5 niv. 7, 6, 5 en 4 K
VLOER |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Godfried Nankoe
PAARD-VOLTIGE |  | [NAME]
 |  | [NAME]
 |  | Arno Pluk
 |  | [NAME]
RINGEN |  | [NAME]
 |  | [NAME]
 |  | Ciska Foncille
 |  | Annelies Moltzer
SPRONG |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
BRUG |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
REKSTOK |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Gé Meijer
Spreadsheet: 154962d1336630376-reduce-points-through-average-pivot
Sheet: Sheet1

2012-07-05 00:01:00 | 3.3 |  |  | DATES | AVERAGE
2012-07-05 00:01:00 | 3.31 |  |  | 2012-07-05 00:01:00 | 3.322
2012-07-05 00:01:00 | 3.33 |  |  | 2012-07-05 00:02:00 | 3.345
2012-07-05 00:01:00 | 3.33
2012-07-05 00:01:00 | 3.33
2012-07-05 00:01:00 | 3.31
2012-07-05 00:02:00 | 3.34
2012-07-05 00:02:00 | 3.37
2012-07-05 00:02:00 | 3.36
2012-07-05 00:02:00 | 3.34
2012-07-05 00:02:00 | 3.34
2012-07-05 00:02:00 | 3.32 |  |  | Row Labels | Sum of 3.3
 |  |  |  | 2012-07-05 00:01:00 | 16.61
 |  |  |  | 2012-07-05 00:02:00 | 20.07
 |  |  |  | Grand Total | 36.68
Spreadsheet: 685774d1594192475-split-5-parameters-separated-by-and-into-series-of-columns-5-parameter-test
Sheet: Result

Product
101
102
103
Product | 1.1 | 1.2 | 1.3 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 3.3 | 4.1 | 4.2 | 4.3 | 5.1 | 5.2 | 5.3
101 | 0219A | 0219B | 0219C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
102 | 0220A | 0220B | 0220C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
103 | 0221A | 0221B | 0221C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
Spreadsheet: 723693d1615838919-take-multiple-data-points-from-a-row-by-searching-on-the-first-column-row_array_issue
Sheet: Sheet1

 | Selected Date | 2021-03-10 00:00:00
 |  | Fred | [NAME] | Rebecca | [NAME] | An Ni | Juan | Olive | Vince
 | 2021-03-08 00:00:00 | 0 | 121 | 0 | 0 | 0 | 0 | 0 | 8
 | 2021-03-09 00:00:00 | 0 | 63 | 0 | 0 | 0 | 0 | 58 | 91
 | 2021-03-10 00:00:00 | 0 | 27 | 0 | 0 | 0 | 26 | 22 | 26
 | 2021-03-11 00:00:00 | 0 | 59 | 0 | 0 | 0 | 64 | 27 | 40
 | 2021-03-12 00:00:00 | 0 | 43 | 0 | 0 | 41 | 11 | 12 | 48
 | Ideal Outcome | Fred | 0
 |  | [NAME] | 27
 |  | Rebecca | 0
 |  | [NAME] | 0
 |  | An Ni | 0
 |  | Juan | 26
 |  | Olive | 22
 |  | Vince | 26
Spreadsheet: 6fa52a8b-fe3f-43d1-875c-f0e65ae5452f
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
BGRS | Test | BGRS | Barley Grass, IgE | Barley Grass, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BGRS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BGRS | Result | BGRS | Barley Grass, IgE | Barley Grass, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6037-6 | [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 599999d1543415176-pto-tracking-pto-track-etaf
Sheet: Sheet1

Num | Name | Hire Date | today | year fract | Hours Earnt
 |  | 2018-01-01 00:00:00
 |  | 2017-01-01 00:00:00
 |  | 2017-11-29 00:00:00
 |  | 2016-11-29 00:00:00
 |  | 2015-11-29 00:00:00
 |  | 2014-11-29 00:00:00
 |  | 2013-11-29 00:00:00
 |  | 2000-11-29 00:00:00
 | A2 is employee number, B2 employee name, C2 Hire Date, D2 TODAY(), E2 =INT(YEARFRAC(C2,D2)). The columns to follow I would like to have a formula that accrues the hours.
 | My companies policy is one year after your hire date, you get 40 hours, 2 years 80 hours, and 5 years 120 hours.
 |  |  |  | years | Hours
 |  |  |  | 0 | 0
 |  |  |  | 1 | 40
 |  |  |  | 2 | 80
 |  |  |  | 5 | 120
Spreadsheet: 695412d1600195783-auto-fill-formula-probability-work-sheet-v3-forum
Sheet: probability work sheet csv

Common | 15 min
Elongated | 30 min
Extra Elongated | 45 min
Super Elongated | 60  min
Morning Session | Blank Slate | Scenario | Scenario 0 | Scenario 1
8:00 AM
08:15:00 |  |  | Elongated
8:30 AM |  |  | Elongated
08:45:00 |  |  |  | Super Elongated
9:00 AM |  |  |  | Super Elongated
09:15:00 |  |  | Common | Super Elongated
9:30 AM |  |  |  | Super Elongated
09:45:00 |  |  |  | Common
10:00 AM |  | IPF BLOCK | IPF BLOCK | IPF BLOCK
10:15:00 |  | IPF BLOCK | IPF BLOCK | IPF BLOCK
10:30:00 |  |  | Extra Elongated
10:45:00 |  |  | Extra Elongated
11:00:00 |  |  | Extra Elongated
11:15:00
11:30:00 |  |  | SDA | SDA
11:45:00 |  |  | SDA | SDA
Open Slots
Blocked slots
Open Access Available
Potential Elongated VT (rounded down)
Consecutive blank cells
Spreadsheet: elizabeth_sager__9545__East Power Summary(1)1
Sheet: East Power - December

East Power Summary
Positions by Counterparty
 |  | Peak / | 2001-12-27 00:00:00 |  |  | 2001-12-28 00:00:00 |  |  | 2001-12-31 00:00:00 |  |  | Total
Counterparty | Region | [NAME] | Sales | Purchases | Net Cash | Sales | Purchases | Net Cash | Sales | Purchases | Net Cash | Sales | Purchases | Net Cash
VEPCO | PJM | Peak
VEPCO | PJM | [NAME]
VEPCO | ENTERGY | Peak
VEPCO | CINERGY | Peak
VEPCO | NEPOOL | Peak
VEPCO | Total
SELECT | PJM | Peak
SELECT | CINERGY | Peak
SELECT | NEPOOL | Peak
SELECT | NEPOOL | [NAME]
SELECT | Total
GPU | PJM | Peak
GPU | PJM | [NAME]
GPU | Total
HQ | PJM | Peak
HQ | NEPOOL | Peak
HQ | NEPOOL | [NAME]
HQ | Total
LEM | SOCO | Peak
LEM | SOCO | [NAME]
LEM | CINERGY | Peak
LEM | Total
BECO | NEPOOL | Peak
CMPC | NEPOOL | Peak
AMEREN | COMED | Peak
AMEREN | TVA | Peak
AMEREN | ENTERGY | Peak
AMEREN | CINERGY | Peak
AMEREN | Total
CARGILL | COMED | Peak
CARGILL | SOCO | Peak | 0 | 0 |  | 0 | 0 |  | 0 | 0
CARGILL | SOCO | [NAME]
CARGILL | CINERGY | Peak
CARGILL | ENTERGY | Peak
CARGILL | ENTERGY | [NAME]
CARGILL | Total
CP&L | TVA | Peak
CP&L | ENTERGY | Peak
CP&L | CINERGY | Peak
CP&L | Total
FE | CINERGY | Peak
WABASH | CINERGY | Peak
IP&L | CINERGY | [NAME]
Total
Total PJM
Total NEPOOL
Total Other w/ [NAME] and Wabash
Total Value
Total Other w/out [NAME] and Wabash
Total PJM, NEPOOL and Other w/out [NAME] and Wabash
Spreadsheet: 135991d1326357962-excel-2007-want-to-use-sumproduct-with-min-function-sumprduct-and-min-max
Sheet: Report 1 (2)

 | Service Type |  | Serv1
 | From Date |  | 2011-01-01 00:00:00
 | To Date |  | 2011-12-31 00:00:00
 |  |  |  | No of Apps | Maximum Days taken for an application | Minimum Days taken for an application | Average Days taken by App
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
Spreadsheet: 871746d1718174074-how-to-use-excel-solver-to-solve-subset-sum-problem-excel-solver
Sheet: Sheet1

322224
932878
694500
15000000
250350
3109275.23
66165724
4500000
43354023.82
2715000
500000
937500
32664.99
403277.58
307243.13
140630.85
198997.5
237963.6
238043.63
354720.6
190455
253125
451178.93
146306.25
203416.31
45562.5
262417.13
224841.15
223224.38
473447.82
237621.15
4157812.5
53145
1389420
10416667.5
13260000
7500000
51161.81
5576420.47
304201.72
41402183
Spreadsheet: 695092d1600046871-if-statement-with-multiple-conditions-book1-1-
Sheet: Sheet1

 |  | With lookup table | Without lookup table |  |  |  |  |  | LOOKUP TABLE
 |  |  |  |  |  |  |  |  |  | Rate
 |  |  |  |  |  |  |  |  | Amount | 0.01 | 0.025 | 0.05 | 0.075 | 0.1 | 0.125 | 0.15 | 0.175
Amount | Rate | Com % | Com % |  |  |  |  |  | 1 | 0.04
100 |  |  |  |  |  |  |  |  | 50001 | 0.03
 |  |  |  |  |  |  |  |  | 250001 | 0.02
 |  |  |  |  |  |  |  |  | 500001 | 0.01
One thing though, as per the formula, when the Rate=0 and Amount=0 it will still show value in commission column (E.g 4%) and for that matter, if Rate=0 and only [NAME] is mentioned it will also show the value in commission column.
How can we restrict it in a way that if any or both of the columns i.e. [NAME] and Amount are blank, the commission column should not be populated
Spreadsheet: 849332d1699859693-how-to-add-a-formula-to-a-column-ctrl-enter
Sheet: Sheet1

Name | Pkt | Amount
A | #1 | 1 |  |  |  | A |  |  | *how do I add a Round(,2) to all?
B | #2 | 2 |  |  |  | Total
C | #3 | 3 |  |  |  | #3
D | #2 | 4
E | #1 | 5
A | #3 | 6
B | #3 | 7
C | #2 | 8
D | #1 | 9
E | #2 | 10
Spreadsheet: 809546d1671138935-match-copy-cell-to-current-month-column-example1
Sheet: Sheet2

 |  |  |  | MTD | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | YTD
 |  |  | Data Set 1
 |  |  |  |  |  |  |  | B3 is current date
 |  |  |  |  |  |  |  | B4 is blank, enter any date to change date in B5
 |  |  |  |  |  |  |  | B5 will display date in B4 or if blank date in B3
 |  |  |  |  |  |  |  | B6 shows month from date in B5
 |  |  |  |  |  |  |  | B7 is user data to copy
 |  |  |  |  |  |  |  | I'm looking for a formula for D7:O7 that will return the value in [NAME] based on the month in B6, so if B6="Feb" then E7="70" or if B6="Aug" then K7="70", but at the same time not affecting other cells in range D7:O7
Spreadsheet: 794156d1661905497-i-want-to-convert-columns-to-row-in-excel-excel-help-v1-hd
Sheet: Sheet1

Group A
Year-Month | 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
1951-01 | 0 | 0 | 0 | 35 | 0 | 100 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 2 | 0 | 0 | 0 | 0 | 85 | 60 | 0 | 0 | 19 | 41 | 55
1951-02 | 23 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 52 | 17 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 6 | 0 | -99999 | M | -99999
1951-03 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 10 | 0 | 20 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1951-04
1951-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4.5 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1951-06 | 0 | 0 | 0 | 0 | 0.6 | 0 | 0 | 0 | 0 | 0 | 0 | 1.1 | 0.3 | 2.6 | 0 | 0 | 0 | 0 | 0 | 4.5 | 0.6 | 1.8 | 9.5 | 3.1 | 0 | 0 | 0 | 0 | 0 | 0 | -99999
1951-07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 0 | 0 | 11 | 3 | 0 | 0 | 6.5 | 0 | 0 | 0 | 0
1951-08 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1951-09 | 0 | 0 | 0 | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -99999
1951-10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1951-11 | 0 | 0 | 31.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12.7 | 6.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 23.3 | 77.5 | -99999
1951-12 | 0 | 0 | 0 | 19.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9.5 | 0 | 14.9 | 0 | 0 | 0 | 16.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 72.4 | 0 | 0 | 16.8
 |  |  |  |  |  |  |  |  | Note;
Group B |  |  |  |  |  |  |  |  |  | I want to convert columes (Data in group A) to row (Data in group B)
Date | Data
 |  |  |  |  |  |  |  |  |  | Note: -9999 and M: indicate No Relevant Data and they can be dropped
 |  |  |  |  |  |  |  |  |  |  | NA: mean No Data and I want to leave as blank in group B
 |  |  |  |  |  |  |  |  |  | Thanks you<3
Spreadsheet: 677486d1589374306-multiple-fields-pulling-into-a-summary-form-draft-order-and-spreadsheet-auto-pop_help
Sheet: Roster

 |  | Team Name | [NAME]
 |  |  | [NAME] (Simple) | [NAME] (Millions) |  | Full Contract
 |  | 2020 MAX CAP SPACE | 330 |  |  | 1000000000
 |  | AVG TEAM SALARY
 |  | CURRENT SALARY  TTL
 |  | CAP Under/(Over)
 |  | 1000000 | Salary
# | [NAME] | Player Name | [NAME] (Simple) | [NAME] (Millions) | Years | Full Contract
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
Spreadsheet: 161835d1339647567-convert-vertical-data-to-horizontal-sample
Sheet: Sheet1

Account ID | Product | Total
2395380 | Chicken | 2.34 |  |  |  | Account ID | Chicken | Tomato | Beef | Jar | [NAME] | Pasta
2395380 | Tomato | 0.8 |  |  |  | 2395380 | 2.34 | 0.8 | 0.2 | 13 | 0
2395380 | Beef | 0.2 |  |  |  | 2460127 | 1 |  |  | 13
2395380 | Jar | 13 |  |  |  | 2461125 |  |  | 13
2460127 | Chicken | 1 |  |  |  | 2461126 |  | 4.3 | 0.1 | 5.4 | 14.8 | 20.58
2460127 | Jar | 13
2461125 | Beef | 13
2461126 | Tomato | 4.3
2461126 | Pasta | 20.58 |  |  | Sum of Total | Column Labels
2461126 | Beef | 0.1 |  |  | Row Labels | Beef | Chicken | Jar | Pasta | [NAME] | Tomato | Grand Total
2461126 | Jar | 5.4 |  |  | 2395380 | 0.2 | 2.34 | 13 |  |  | 0.8 | 16.34
2461126 | [NAME] | 14.8 |  |  | 2460127 |  | 1 | 13 |  |  |  | 14
 |  |  |  |  | 2461125 | 13 |  |  |  |  |  | 13
 |  |  |  |  | 2461126 | 0.1 |  | 5.4 | 20.58 | 14.8 | 4.3 | 45.17999999999999
 |  |  |  |  | Grand Total | 13.3 | 3.34 | 31.4 | 20.58 | 14.8 | 5.1 | 88.52
Spreadsheet: louise_kitchen__24216__PR 2002 Plan 091301
Sheet: Allocations

 | % | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | Total
EGM | 0.2
EIM | 0.2
ENW | 0.2
EEOS | 0.05
EEOS | 0.05
 |  | Total budget
 |  | I/C billings
 |  | Net PR budget
Spreadsheet: 465603d1465799299-convert-montly-colum-data-into-single-column-yearly-data-into-single-column
Sheet: Sheet1

Days | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1 | 0 | 0 | 9 | 13 | 0 | 0 | 40 | 5 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 0 | 0 | 0 | 0 | 3 | 0 | 12 | 0 | 0 | 0 | 0 | 0
12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0
16 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0
17 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 0 | 0 | 0 | 0 | 0
18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0
20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
26 | 0 | 0 | 0 | 0 | 0 | 0 | 90 | 0 | 0 | 0 | 0 | 0
27 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
29 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
30 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
31 | 0 |  | 0 |  | 0 |  | 0 | 0 |  | 0 |  | 0
Spreadsheet: 881449d1729524667-index-match-formula-for-multiple-criteria-mdyas-product
Sheet: Lookup

 |  | Make | Product
 |  | E&E Solutions Pvt. Ltd | Ultrasonic Flow meter
 | Make
 | Product
 | Application
 | Model
 | Type
 | [NAME]
 | [NAME]
 | Output
 | Installation
 | Power supply
 | Pressure rating
 | Process temperature
 | Electrode material
 | Lining material
 | Body material
 | protection
 | Price
 | Feature
Spreadsheet: 157558d1337790200-aligning-rows-according-to-data-in-colomns-so-that-2-values-are-the-same-testfile
Sheet: Sheet1

Current Month |  |  |  |  | Previous Month
Policy Number | Premium | Comm |  |  | Policy Number | Total Commission Premium | Comm
333034679 | 1062.46 | 163.94 |  |  | 333034679 | 1062.46 | 163.94
557100721 | 566.54 | 71.03 |  |  | 444231477 | 509.12 | 77.17
557017378 | 1251.83 | 156.69 |  |  | 555294583 | 1005.25 | 138.12
557045421 | 509.26 | 63.87 |  |  | 555767005 | 281.4 | 35.39
557047844 | 554.33 | 69.5 |  |  | 555903309 | 922.37 | 185.35
556973544 | 163.85 | 33.13 |  |  | 555909320 | 285.89 | 35.95
556993665 | 561.07 | 76.73 |  |  | 555939362 | 347.92 | 48.66
557047437 | 506.2 | 67.06 |  |  | 556006087 | 405.06 | 54.33
557045492 | 1036.39 | 138.67 |  |  | 556102175 | 742.62 | 119.71
557047054 | 708.23 | 88.93 |  |  | 556159926 | 522.42 | 65.51
556973784 | 41.54 | 5.41 |  |  | 556247910 | 1070.29 | 147.35
557090113 | 389.43 | 53.13 |  |  | 556321356 | 956.52 | 129.4
557029244 | 0 | 0 |  |  | 556346258 | 855.49 | 107.14
557036064 | 545.49 | 68.39 |  |  | 556478156 | 694.8 | 96.69
557015713 | 136.52 | 30.49 |  |  | 556494802 | 516.49 | 64.77
Spreadsheet: 147593d1332873848-excel-2008-help-with-vacation-accrual-experiment-team-pto_2012
Sheet: employee 1

 | NAME |  | HIRE DATE |  | BYWU term 10
 | Employee 1 |  | 2001-09-17 00:00:00 |  | 9/17/11–9/17/12
VACATION
ALLOTTED: | 45 | TAKEN: | 22.5 | REMAINING: | 22.5 |  | Time taken not to exceed 150
DATE: | 2012-01-19 00:00:00 | 2012-01-20 00:00:00 | 2012-03-05 00:00:00
HOURS: | 7.5 | 7.5 | 7.5
DATE:
HOURS:
DATE:
HOURS:
SICK
ALLOTTED: | 75 | TAKEN: | 17.5 | REMAINING: | 57.5
DATE: | 2012-01-23 00:00:00 | 2012-02-17 00:00:00 | 2012-03-19 00:00:00
HOURS: | 7.5 | 2.5 | 7.5
DATE:
HOURS:
PERSONAL / BEREAVEMENT / JURY DUTY |  |  |  |  |  |  |  |  | UNITED WAY
ALLOTTED: | 15 | TAKEN: | 0 | REMAINING: | 15 |  |  |  | ALLOTTED: | 7.5
DATE: |  |  |  |  |  |  |  |  | DATE:
HOURS: |  |  |  |  |  |  |  |  | HOURS:
FLEX |  |  |  |  |  |  | NOTES
ALLOTTED: | 10 | TAKEN: | 2 | REMAINING: | 8 |  | Any details to note on the employee's PTO for the year can go in this field.
DATE: | 2012-03-01 00:00:00
HOURS: | 2
TENURE RECOGNITION - BYWU
ALLOTTED: | 37.5 | TAKEN: | 0 | REMAINING: | 37.5 |  | Y.T.D. TOTAL PTO HOURS (All time EXCEPT Flex)
DATE: |  |  |  |  |  |  |  | 180 | 40 | 140
HOURS: |  |  |  |  |  |  |  | ALLOTTED | TAKEN | REMAINING
Spreadsheet: 88045d1287949494-sumproduct-formula-with-a-minimum-value-needed-weaponmaster-working-out
Sheet: Weapons Calc

 |  |  |  |  |  |  |  | defend |  |  |  | attack
 |  |  |  |  | MOB Size | 1 |  | 17.2 | 1 | 17 |  | 24.12 | 0 | 0
 |  |  | Items Owned |  |  |  |  | 16.18 | 0 | 0 |  | 22.14 | 0 | 0
 | Defence | Attack | Purchased |  | Defense | 17 |  | 15.02 | 1 | 0 |  | 20.17 | 1 | 20
SHANK | 0 | 1 |  |  | Attack | 20 |  | 14.22 | 0 | 0 |  | 18.16 | 0 | 0
BRASS KNUCKLES | 2 | 1 |  |  |  |  |  | 12.24 | 0 | 0 |  | 15.12 | 0 | 0
SAT NIGHT SPECIAL | 1 | 2 |  |  | Current Upkeep | 550 |  | 12.15 | 0 | 0 |  | 10.08 | 0 | 0
GERMAN STILETTO KNIFE | 2 | 3 |  |  | Required MAX Upkeep for your mob |  |  | 9.08 | 0 | 0 |  | 8.09 | 0 | 0
9mm Handgun | 2 | 3 |  |  |  |  |  | 8.1 | 0 | 0 |  | 7.03 | 0 | 0
chainsaw | 6 | 5 |  |  | Your current MOB Cheapest DEF | 12 |  | 6.05 | 0 | 0 |  | 5.06 | 0 | 0
Molotov Cocktail | 3 | 7 |  |  | Your current MOB Cheapest ATT | 12 |  | 4.01 | 1 | 0 |  | 5.03 | 0 | 0
Galesi Model 503 | 9 | 8 |  |  |  |  |  | 3.07 | 0 | 0 |  | 3.02 | 0 | 0
kevlar Vest | 4 | 1 | 1 |  | Cheapest paying DEF/ATT | 16 |  | 3.05 | 0 | 0 |  | 3.02 | 0 | 0
.57 Magnum | 3 | 5 |  |  | Cheapest Paying ATT | 0 |  | 2.03 | 0 | 0 |  | 2.15 | 1 | 0
Grenade | 8 | 10 |  |  |  |  |  | 2.03 | 0 | 0 |  | 2.01 | 0 | 0
AK-47 | 12 | 15 |  |  |  |  |  | 2.01 | 0 | 0 |  | 1.04 | 1 | 0
[NAME] | 16 | 18 |  |  |  |  |  | 1.02 | 0 | 0 |  | 1.02 | 0 | 0
RPG | 14 | 22 |  |  |  |  |  | 0.01 | 0 | 0 |  | 1 | 0 | 0
[NAME] | 15 | 2 | 1 |  | Most expensive Strongest DEF | 32
[NAME] | 12 | 24 |  |  | Most Exepnsive Strongest ATT | 26
.338 [NAME] | 17 | 20 | 1
Total Weapons Purchased |  |  | 3
Weapon Costs |  | hourly
 | £ or $ | upkeep | Defence | Attack
SHANK | 400 | 0 | 0 | 1
BRASS KNUCKLES | 800 | 0 | 2 | 1
SAT NIGHT SPECIAL | 1000 | 0 | 1 | 2
GERMAN STILETTO KNIFE | 2000 | 0 | 2 | 3
9mm Handgun | 2500 | 0 | 2 | 3
chainsaw | 10000 | 0 | 6 | 5
Molotov Cocktail | 4000 | 0 | 3 | 7
Galesi Model 503 | 6500 | 0 | 9 | 8
kevlar Vest | 8000 | 0 | 4 | 1
.57 Magnum | 10000 | 0 | 3 | 5
Grenade | 10000 | 0 | 8 | 10
AK-47 | 20000 | 100 | 12 | 15
[NAME] | 100000 | 250 | 16 | 18
RPG | 200000 | 500 | 14 | 22
[NAME] | 25000 | 200 | 15 | 2
[NAME] | 300000 | 750 | 12 | 24
.338 [NAME] | 350000 | 350 | 17 | 20
Spreadsheet: 282802d1386600340-printing-from-a-list-tanknamehelpdoc
Sheet: Sheet1

A1-NE-H
A1-N-L
A1-NW-H
C1-SW-H2
C1-SW-H1
C1-E-H
C1-NE-L
ER5-N-L5
ER4-N-L4
ER3-N-L3
ER2-N-L2
ER1-N-L1
G1-SW-H2
G1-SW-H1
[NAME]
[NAME]
JR5-N-L5
JR4-N-L4
JR3-N-L3
JR2-N-L2
JR1-N-L1
MR1-N-L1
MR2-N-L2
MR3-N-L3
MR4-N-L4
MR5-N-L5
OR5-N-L5
OR4-N-L4
OR3-N-L3
OR2-N-L2
OR1-N-L1
QR5-N-L5
QR4-N-L4
QR3-N-L3
QR2-N-L2
QR1-N-L1
AA2-S-L
AA2-N-H
BB3-SE-H
BB3-W-H
BB3-N-L
BB2-SE-H
BB2-S-L
BB1-SE-L
BB1-SW-H
BB1-W-H
BB1-NW-L
BB1-NE-L
[NAME]
CC1-SW-H
CC1-W-H
[NAME]
CC1-NW-L
CC3-SE-H
CC3-W-H
CC3-N-L
RR1-NE-L
R1-SE-L
R1-SW-H
R1-W-H
R1-NW-L
R1-NE-L
TR1-SW-L1
TR1-SW-L2
T1-NW-L
T1-N-L
Y1-SE-L
Y1-S-H
Y1-SW-H
AA4-SE-L
AA4-S-H - A
AA4-SW-H
Spreadsheet: 881846d1730081936-help-with-a-dependent-data-validation-drop-down-copy-example-v2-lindsey-owen-
Sheet: Orderbook

Category |  | Types |  |  |  |  |  | Model |  |  | Description
Machine |  | Machine | Option | Software | Misc | Del/Com/Serv |  | MachineMachine 1 | MachineMachine 2 |  | MachineMachine 1ABC 1  5
Option |  | Machine 1 | Machine 1 | Software | Misc | Del/Com/Serv |  | ABC 1  5 | ABC 1 2 |  | ABC 1  5 - S1
Software |  | Machine 2 | Machine 2 |  |  |  |  | ABC 1  7 | ABC 1 3 |  | ABC 1  5 - F1
Misc |  | Machine 3 | Machine 3 |  |  |  |  | ABC 1  9 | ABC 1 3 -1 |  | ABC 1  5 - S2
Del/Com/Serv |  |  |  |  |  |  |  | ABC 1  11 | ABC 1 3 SS |  | ABC 1  5 - L1
Choice | Choice | Choice | Choice
Machine | Machine 1 | ABC 1  5 | ABC 1  5 - S1
Spreadsheet: 876265d1722951475-work-record-sheet-work-record-sheet
Sheet: Sheet1

 |  | M | [NAME] | W | Th | F | Sa | Su | M | [NAME] | W | Th | F | Sa | Su | Total Days | Totals Needed
 | J Bloggs | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 14
 | J Smith | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 7
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 | 1 |  | 4