tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702811d1604556802-help-with-fuzzy-lookup-based-on-dates-1-aapl_10_data1-copy
Sheet: All

Date | Price | Quarter | Year | ER Date + 5 | Market [NAME] | P/E | P/S | P/B                               (NTA) | P/E Test | Year | Date | Hi Market Cap | P/E | P/S | P/B                                         (NTA) | Price |  | Date | Low Market Cap | P/E | P/S | P/B                                         (NTA) | Price |  | Year | Hi Price | Hi Market Cap | Hi P/E | Hi P/S | Hi P/B                                         (NTA) |  | Year | Low Price | Low Market Cap | Low P/E | Low P/S | Low P/B                                         (NTA)
 |  |  |  |  |  |  |  |  |  | 1997
 |  |  |  |  |  |  |  |  |  | 1998
 |  |  |  |  |  |  |  |  |  | 1999
 |  |  |  |  |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  | 2001
 |  |  |  |  |  |  |  |  |  | 2002
 |  |  |  |  |  |  |  |  |  | 2003
 |  |  |  |  |  |  |  |  |  | 2004
 |  |  |  |  |  |  |  |  |  | 2005
 |  |  |  |  |  |  |  |  |  | 2006
 |  |  |  |  |  |  |  |  |  | 2007
 |  |  |  |  |  |  |  |  |  | 2008
 |  |  |  |  |  |  |  |  |  | 2009
 |  |  |  |  |  |  |  |  |  | 2010
 |  |  |  |  |  |  |  |  |  | 2011
 |  |  |  |  |  |  |  |  |  | 2012
 |  |  |  |  |  |  |  |  |  | 2013
 |  |  |  |  |  |  |  |  |  | 2014
 |  |  |  |  |  |  |  |  |  | 2015
 |  |  |  |  |  |  |  |  |  | 2016
 |  |  |  |  |  |  |  |  |  | 2017
 |  |  |  |  |  |  |  |  |  | 2018
 |  |  |  |  |  |  |  |  |  | 2019
 |  |  |  |  |  |  |  |  |  | 2020
 |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  | [NAME] of Market Cap | Total
 |  |  |  |  |  |  |  |  |  | Total | #N/A
Spreadsheet: 864628d1711723122-how-to-calculate-best-numbers-3-i-a-certain-rank-or-order-european-championship-ek-2024-invulsheet
Sheet: Blad2

Albanië
België
[NAME]
Duitsland
Engeland
Frankrijk
Georgië
Hongarije
[NAME]
[NAME]
Nederland
Oekraïne
[NAME]
[NAME]
Portugal
Roemenië
Schotland
Servië
Slovenië
Slowakije
Spanje
Tsjechië
Turkije
Zwitserland
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: January

Margin and Sales by Vendor - January 2020
Vendor | Sales | Margin $ | Margin %
Palo Alto Networks | 1 | 1
Netapp Aust | 1 | 1
Gigamon | 1 | 1
Riverbed | 1 | 1
Hewlett Packard Enterprise | 1 | 1
F5 | 1 | 1
Pure Storage | 1 | 1
Arista | 1 | 1
Sophos | 1 | 1
Extreme Networks | 1 | 1
Microsoft | 1 | 1
Nutanix | 1 | 1
Cohesity | 1 | 1
Tenable | 1 | 1
Infoblox | 1 | 1
ForeScout | 1 | 1
Ribbon | 1 | 1
Channel Services | 1 | 1
Cylance | 1 | 1
Symantec | 1 | 1
Amazon Web Services | 1 | 1
Avaya | 1 | 1
CS Vendors | 1 | 1
MobileIron | 1 | 1
Check Point | 1 | 1
AlgoSec | 1 | 1
[NAME] | 1 | 1
Mellanox | 1 | 1
[NAME] | 1 | 1
PlusOptic | 1 | 1
FireEye | 1 | 1
Grand Total
Spreadsheet: 99ae44b0-8fbe-449c-8768-2eb6a7fa8e7d
Sheet: DevelopmentFacility

 | Replacement Development Facility Price Sheet
 | Item Number | Description | SFY2014 | SFY2015 | SFY2016 | SFY2017 | SFY2018 | SFY2019 | SFY2020 | SFY2021 | TOTAL
 | [NAME] | Development Facility
 | DEV.3 | Data Center (Vendor Facility)
 | DEV.4 | Installation/Configuration Costs
 | DEV.4.1 | Facility Build-Out
 | Total by SFY
Spreadsheet: 64188d1265068928-pivot-table-on-a-formatted-date-returns-date-to-origin-code-excellforum_pivottable_problem
Sheet: Sheet2

Date | cl-cl |  |  |  |  |  |  |  |  |  |  | Date | Day of week | cl-cl
04/22 | 0.05000000000001137 |  |  |  |  |  |  | 2 | No of positve outcomes |  |  | 04/22 | Thursday | 0.4500000000000028 |  |  |  |  |  |  | 1 | No of positve outcomes where it’s a particular day of the week
 | 0.4500000000000028 |  |  |  |  |  |  | 0 | No of negative outcomes |  |  |  | Thursday Total |  |  |  |  |  |  |  | 0 | No of negative outcomes where it’s a particular day of the week
04/22 Total |  |  |  |  |  |  |  |  |  |  |  | 04/22 Total
Grand Total |  |  |  |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: 836671d1689585586-using-index-formula-to-summarise-training-database-index-1-
Sheet: IR

CÔNG TY TNHH GE-SHEN VIỆT NAM |  |  |  |  |  |  |  |  |  | Form  :  HR-F02
GE-SHEN (VIETNAM) CO., LTD. |  |  |  |  |  |  |  |  |  | Rev    :  C
GHI CHÉP ĐÀO TẠO CÁ NHÂN/ NHÓM
GROUP / INDIVIDUAL TRAINING RECORD
Emp. No.: | 105320 |  |  |  |  |  | Name:
Dept: |  |  |  |  |  |  | Position:
Date Joined: |  |  |  |  |  |  | Year:
TT No. | Int/ Ext | Date |  |  | Time |  |  | Khóa đào tạo Training Course | Trained by | Ghi chú Remarks
1 |  |  |  |  |  |  |  |  |  |  |  | B7 | manually key in
2 |  |  |  |  |  |  |  |  |  |  |  | B8 | [NAME] in Employee name sheet, Column C
3 |  |  |  |  |  |  |  |  |  |  |  | B9 | [NAME] in Employee name sheet, Column E
4 |  |  |  |  |  |  |  |  |  |  |  | H7 | [NAME] in Employee name sheet, Column B
5 |  |  |  |  |  |  |  |  |  |  |  | H8 | [NAME] in Employee name sheet, Column D
6 |  |  |  |  |  |  |  |  |  |  |  | H9 | is it possible to tabulate data below base on year, i.e. if I keyed in 2022, the data will be show for year 2022 only, then if I change the year for 2023, it will tabulate the data for 2023
7 |  |  |  |  |  |  |  |  |  |  |  | B13 | list of training attended by by [NAME], lookup value in Database, Column D
8 |  |  |  |  |  |  |  |  |  |  |  | C13 | start date for 1st list training attended by by [NAME], lookup value in Database, Column E
9 |  |  |  |  |  |  |  |  |  |  |  | B14 to G42 | Other list of training attended by B7
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 864711d1711806063-hierarchy-and-dependency-project-selection
Sheet: Sheet1

Name | ActTyp | Project No | Short Text | Date | Number | Project sub |  |  |  |  |  |  |  | Project No | (All)
[NAME] | SITE02 | EH3-000979-Tonstad G5 Dismantling |  | mars | 4 | WORKSHOP |  |  |  |  |  |  |  | want to choose project sub as well
[NAME] | SITE02 | EH3-001034-Vittingfoss G4 |  | mars | 4 | WORKSHOP |  |  |  |  |  |  |  | Sum of Number |  |  | Date
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 3.5 | WORKSHOP |  |  |  |  |  |  |  | Name | Short Text | ActTyp | mars
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 4 | WORKSHOP |  |  |  |  |  |  |  | [NAME] |  | SITE02 | 60.5
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 3.5 | WORKSHOP |  |  |  |  |  |  |  | Olufsen Bj#rn |  | COMM01 | 46.5
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 4 | WORKSHOP |  |  |  |  |  |  |  | Grand Total |  |  | 107
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 3 | WORKSHOP
[NAME] | SITE02 | EH3-000979-Tonstad G5 Dismantling |  | mars | 4.5 | WORKSHOP
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 3.5 | WORKSHOP
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 3.5 | WORKSHOP
[NAME] | SITE02 | EH3-000979-Tonstad G5 Dismantling |  | mars | 3.5 | WORKSHOP
[NAME] | SITE02 | IH3-000053-Kolsi |  | mars | 3 | 090
[NAME] | SITE02 | EH3-000979-Tonstad G5 Dismantling |  | mars | 4.5 | WORKSHOP
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 3.5 | WORKSHOP
[NAME] | SITE02 | IH3-000053-Kolsi |  | mars | 4 | 090
[NAME] | SITE02 | EH3-001043-Kobbelv G1 – Rotor failure |  | mars | 4.5 | WORKSHOP
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 1 | WA2
[NAME] | COMM01 | EH3-001034-Vittingfoss G4 |  | mars | 4 | 090
[NAME] | COMM01 | IH3-000053-Kolsi |  | mars | 1 | 090
[NAME] | COMM01 | EH3-001034-Vittingfoss G4 |  | mars | 4.5 | 090
[NAME] | COMM01 | EH3-001034-Vittingfoss G4 |  | mars | 1 | 090
[NAME] | COMM01 | EH3-001034-Vittingfoss G4 |  | mars | 3.5 | 090
[NAME] | COMM01 | EH3-001034-Vittingfoss G4 |  | mars | 3 | 090
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 5.5 | WA2
[NAME] | COMM01 | IH3-000053-Kolsi |  | mars | 2 | 090
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 2 | WA2
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 3 | WA2
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 5.5 | WA2
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 3 | WA2
[NAME] | COMM01 | EH3-000820-Kvilldal G1-G4 Generator Refurbishment |  | mars | 7.5 | WA2
Spreadsheet: 289188d1389445200-raffle-numbers-in-excel-raffle-bud117
Sheet: Raffle

Winning Numbers | 1 | 5 | 9 | 12 |  |  | Match | Prize
 |  |  |  |  |  |  | 4 | Prize 1
 |  |  |  |  |  |  | 3 | Prize 2
 |  |  |  |  |  |  | 2 | Prize 3
 |  |  |  |  |  |  | 1 | Prize 4
Person | 1st No | 2nd No | 3rd No | 4th No | Match | Prize
1 | 1 | 5 | 9 | 12
2 | 2 | 7 | 13 | 15
3 | 3 | 8 | 16 | 19
4 | 4 | 11 | 22 | 23
5 | 5 | 10 | 12 | 20
6 | 6 | 7 | 10 | 15
7 | 7 | 14 | 16 | 22
8 | 8 | 13 | 17 | 20
9 | 9 | 20 | 21 | 24
10 | 1 | 5 | 9 | 15
Spreadsheet: 53597d1253551121-conditional-formula-to-concatenate-names-book2
Sheet: Sheet1

Last | First | Last2 | First2
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] and [NAME]
Barone, Sr. | [NAME] | Barone | Juliann
Barone, Sr. | [NAME] | Barone | Juliann
Barone | [NAME] | Barone | [NAME] | [NAME] and [NAME]
Barone | [NAME] | Barone | [NAME]
[NAME] | [NAME] | Kolodziej | Ellen | [NAME] and [NAME]
[NAME], Jr. | [NAME] | [NAME] | [NAME]
Batchelor | [NAME] | Batchelor | Christine
Bauer | [NAME] | Bauer | [NAME]
BEAUSANG | [NAME] | Critchell | [NAME]
Becker | [NAME] | Becker | [NAME]
[NAME] | [NAME]
Behrenshauser | [NAME] | Behrenshauser | [NAME]
Bell | [NAME]
Bell | [NAME]
Bell | [NAME] | Bell | [NAME]
Bellucci | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME]
[NAME] | Jo | Kellogg | Molly
Bent | [NAME] | Bent | [NAME]
Berry | [NAME]
Bertolino | [NAME] | Bertolino | Dawn
Bertolino | [NAME] | Bertolino | Dawn
Betegh | [NAME]
Bevilacqua | [NAME] | Bevilacqua | [NAME]
Bevilacqua | [NAME] | Bevilacqua | [NAME]
Beyer | [NAME] | Beyer | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Billbrough Jr. | [NAME] | Billbrough | [NAME]
Billbrough Jr. | [NAME] | Billbrough | [NAME]
Billbrough, Jr. | [NAME] | Billbrough | [NAME]
Black | [NAME] | Black | [NAME]
Blackson | [NAME]
Blasi | [NAME] | Blasi | [NAME]
Blasi | [NAME] | Blasi | [NAME]
[NAME] | [NAME]
Spreadsheet: 296043d1391948412-returning-the-next-specified-value-in-a-range-book1-9-
Sheet: Sheet1

Product | Values |  |  |  | Income | Profit
Product AAA |  |  |  | Product AAA
Profit | 100 |  |  | Product BBB
Income | 200 |  |  | Product CCC
Product BBB
Profit | 50
Income | 75
Product CCC
Profit | 150
Income | 300
Spreadsheet: 843171d1695115250-stacking-dynamic-data-from-multiple-columns-to-one-lambda
Sheet: SAE RS

 |  |  |  | Test | Mid-term | Final | Final Mark (100%)
 |  |  | Assignment ID | 321 | 322 | 323
 |  |  | Total Point | 40 | 50 | 10
 |  |  |  |  |  |  |  |  | Student ID | Assign. ID | Points | Total Points
Student ID |  | Family Name | First Name
1 | S001 |  |  | 32 | 46.25 | 1
2 | S002 |  |  | 32 | 47.5 | 2
3 | S003 |  |  | 32 | 47.5 | 3
4 | S004 |  |  | 32 | 47.5 | 4
5 | S005 |  |  | 32 | 47.5 | 5
6 | S006 |  |  | 32 | 47.5 | 6
7 | S007 |  |  | 32 | 47.5 | 7
8 | S008 |  |  | 32 | 47.5 | 8
9 | S009 |  |  | 32 | 47.5 | 9
10 | S010 |  |  | 32 | 47.5 | 10
11 | S011 |  |  | 33.6 | 50 | 1
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: 757199d1638112892-income-tax-calculation-formula-turkey-income-tax-rates-2021-tms-v2
Sheet: Combo (v2)

Income Tax Calculator (2021)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income | 24000
24000 | 15 | 0 | 0 |  |  |  |  |  | TMS correction
53000 | 20 | 3600 | 24000 |  |  |  |  |  | Income Tax |  |  | =INDEX($G$3:$G$7,IFERROR(MATCH($K$2,$A$3:$A$7,1)+1,1))
190000 | 27 | 9400 | 53000
650000 | 35 | 30190 | 130000 |  |  |  |  |  | unadjusted version of formula
more than 650000 | 40 | 212190 | 65000 |  |  |  |  |  |  |  |  | =MATCH($K$2,$A$3:$A$7,1)+1
 |  |  |  |  |  |  |  |  |  |  |  | =MATCH($K$2-0.1,$A$3:$A$7,1)+1
Income Tax Calculator (2021) |  |  |  |  |  |  |  |  |  |  |  | =IFERROR(MATCH($K$2-0.1,$A$3:$A$7,1)+1,1)
Areas | Rates | Fixed Amount | Fixed Amount For | Rate Calculation 1 | Rate Calculation 2 | Total |  |  | Income
0 | 0.15 | 0 | 0 |  |  |  |  |  | [NAME] correction
24001 | 0.2 | 3600 | 24000 |  |  |  |  |  | Income Tax |  |  | =INDEX($G$11:$G$15,IFERROR(MATCH($K$10,$A$12:$A$15,1)+1,1))
53001 | 0.27 | 9400 | 53000
190001 | 0.35 | 30190 | 190000
650001 | 0.4 | 212190 | 650000 |  |  |  |  |  |  |  |  | MATCH($K$10,$A$12:$A$15,1)
Tax Calculation Breakdown by Bracket
Taxable Income Over... | ...And Up To… | Tax Rate | Tax |  |  |  |  |  | Taxable Income
0 |  | 0.15
24000 |  | 0.2 |  |  |  |  |  |  | Tax Total
53000 |  | 0.27
190000 |  | 0.35
650000 |  | 0.4
 |  |  |  | Total
Spreadsheet: 70417d1271175281-sort-array-depending-on-2nd-column-sort_example
Sheet: Folha2

COD | EXP |  |  | SORT
14/0430
14/0431
14/0432 | YES
14/0433
14/0434 | YES
14/0435
14/0436
14/0437
14/0438
14/0439
14/0440
14/0441
14/0442
14/0443
14/0444
14/0445
14/0446
14/0447
14/0448 | YES
14/0449 | YES
13/0450 | YES
15/0451
15/0452
15/0453 | YES
15/0454
15/0455
15/0456
15/0457
15/0458
15/0459
15/0460
15/0461
15/0462
15/0463
15/0464
15/0465
15/0466
15/0467 | YES
15/0468
14/0505 | YES
14/0508
14/0509
15/0510
15/0511
13/0525 | YES
13/0526
13/0527
14/0528 | YES
14/0529 | YES
13/0530 | YES
13/0531 | YES
13/0532 | YES
14/0543
15/0544
14/0546
14/0547 | CANCEL
14/0548
14/0549 | YES
14/0550 | YES
14/0551
14/0553
14/0554
15/0555
15/0556 | CANCEL
14/0557
14/0558
15/0560
15/0561
14/0564 | YES
14/0565
14/0566
13/0568 | YES
14/0569
14/0570
13/0571 | YES
14/0572 | YES
13/0573 | YES
13/0574 | YES
13/0575 | YES
14/0576 | YES
14/0578 | YES
14/0579 | YES
14/0580 | YES
14/0581 | YES
14/0582 | YES
14/0583 | YES
14/0584
14/0585
14/0586
14/0587
14/0594 | YES
14/0595 | YES
14/0596 | YES
14/0599 | YES
14/0600 | YES
14/0601 | YES
14/0607 | YES
14/0608 | YES
14/0609 | YES
Spreadsheet: 29799d1224882880-adding-a-number-to-deg-min-dec-abcd
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Time between plots
 |  |  | Latitude DD° MM' SS" | [NAME]° MM' SS" | Latitude DDD MM.MMM | [NAME]
 | Date | Time |  |  |  |  | Distance | Speed | Course
1 | 2006-05-11 00:00:00 | 01:58:00 | 12° 32’ 28 S | 141° 31’ 12 E | 12° 32.467' S | 141° 31.200' E | 0.84 | 3.14 | 24.82
2 | 2006-05-11 00:00:00 | 02:14:00 | 12° 31’ 43 S | 141° 31’ 33 E | 12° 31.717' S | 141° 31.550' E | 0.09 | 0.38 | 26.02 | 00:16:00
3 | 2006-05-11 00:00:00 | 02:28:00 | 12° 31’ 38 S | 141° 31’ 36 E | 12° 31.633' S | 141° 31.600' E | 0.75 | 3.21 | 204.67 | 00:14:00
4 | 2006-05-11 00:00:00 | 02:42:00 | 12° 32’ 19 S | 141° 31’ 16 E | 12° 32.317' S | 141° 31.267' E | 0.71 | 3.05 | 206.02 | 00:14:00
5 | 2006-05-11 00:00:00 | 02:56:00 | 12° 32’ 57 S | 141° 30’ 57 E | 12° 32.950' S | 141° 30.950' E | 0.26 | 1.13 | 242.88 | 00:14:00
6 | 2006-05-11 00:00:00 | 03:10:00 | 12° 33’ 04 S | 141° 30’ 43 E | 12° 33.067' S | 141° 30.717' E | 0.71 | 2.65 | 37.49 | 00:14:00
7 | 2006-05-11 00:00:00 | 03:26:00 | 12° 32’ 31 S | 141° 31’ 09 E | 12° 32.517' S | 141° 31.150' E | 0.71 | 3.05 | 26.02 | 00:16:00
8 | 2006-05-11 00:00:00 | 03:40:00 | 12° 31’ 52 S | 141° 31’ 28 E | 12° 31.867' S | 141° 31.467' E | 0.57 | 2.45 | 11.82 | 00:14:00
9 | 2006-05-11 00:00:00 | 03:54:00 | 12° 31’ 19 S | 141° 31’ 36 E | 12° 31.317' S | 141° 31.600' E | 0.7 | 2.99 | 192.94 | 00:14:00
10 | 2006-05-11 00:00:00 | 04:08:00 | 12° 31’ 59 S | 141° 31’ 26 E | 12° 31.983' S | 141° 31.433' E | 0.75 | 3.21 | 204.67 | 00:14:00
11 | 2006-05-11 00:00:00 | 04:22:00 | 12° 32’ 40 S | 141° 31’ 07 E | 12° 32.667' S | 141° 31.117' E | 0.68 | 2.54 | 207.5 | 00:14:00
12 | 2006-05-11 00:00:00 | 04:38:00 | 12° 33’ 16 S | 141° 30’ 47 E | 12° 33.267' S | 141° 30.783' E | 0.53 | 2.29 | 12.69 | 00:16:00
Spreadsheet: 726516d1617282488-sum-if-issue-question-excel-new-1-april
Sheet: Blad1

 | Verkoopprijs |  |  |  |  |  |  |  |  | Inkoopprijs
Cat | Service | Aantal | Prijs per stuk ex. Btw | Prijs per stuk incl. Btw | BTW % | Totaal bedrag exclusief BTW | BTW bedrag | Totaal bedrag inclusief btw |  | Service | Aantal | Prijs per stuk ex. Btw | Prijs per stuk incl. Btw | BTW % | Totaal bedrag exclusief BTW | BTW bedrag | Totaal bedrag inclusief btw
Food | 3-gangen menu | 5 | 91.74311926605503 | 100 | 0.09 | 458.7155963302752 | 41.28440366972484 | 500 |  | 3-gangen menu | 5 | 87.15596330275228 | 95 | 0.09 | 435.7798165137614 | 475
Drank | Wijn | 10 | 41.32231404958678 | 50 | 0.21 | 413.2231404958678 | 86.7768595041322 | 500 |  | Wijn | 10 | 37.1900826446281 | 45 | 0.21 | 371.900826446281 | 450
Bezorging | [NAME] | 60 | 10 | 12.1 | 0.21 | 600 | 126 | 726 |  | [NAME] | 60 | 0 | 0 | 0.21 | 0 | 0
Commissie | Bezorgingskosten Randstad | 40 | 12 | 14.52 | 0.21 | 480 | 100.8 | 580.8 |  | Bezorgingskosten Randstad | 40 | 0 | 0 | 0.21 | 0 | 0
Giftcard | Giftcard | 10 | 100 | 100 | 0 | 1000 | 0 | 1000 |  | Giftcard | 10 | 0 | 0 | 0 | 0 | 0
Drank | Wijn | 10 | 82.64462809917356 | 100 | 0.21 | 826.4462809917356 | 173.5537190082644 | 1000 |  | Wijn | 10 | 74.3801652892562 | 90 | 0.21 | 743.801652892562 | 900
Overige | Services | 10 | 17.5 | 21.175 | 0.21 | 175 | 36.75000000000001 | 211.75 |  | Services | 10 | 14.46280991735537 | 17.5 | 0.21 | 144.6280991735537 | 175
 | Totale kosten |  |  |  |  | 3953.385017817879 | 565.1649821821213 | 4518.55 |  | Totale kosten |  |  |  |  | 1696.110395026158 | 2000
 |  |  |  |  |  |  |  |  |  | Marge analyse
 |  |  |  |  |  |  |  |  |  | Categorie | verkoopprijs ex. | inkoopprijs ex. | absolute marge | marge %
 |  |  |  |  |  |  |  |  |  | Food | 458.7155963302752 | 435.7798165137614 | 22.93577981651373 | 0.05263157894736836
 |  |  |  |  |  |  |  |  |  | Bezorging | 600 | 0 | 600 | nvt
 |  |  |  |  |  |  |  |  |  | Commissie | 826.4462809917356 | 0 | 826.4462809917356 | nvt
 |  |  |  |  |  |  |  |  |  | Giftcard | 1000 | 0 | 1000 | nvt
 |  |  |  |  |  |  |  |  |  | Overige | 175 | 144.6280991735537 | 30.37190082644628 | 0.21
 |  |  |  |  |  |  |  |  |  | Drank | 1239.669421487603 | 1115.702479338843 | 0 | 0
 |  |  |  |  |  |  |  |  |  | Totaal | 3060.161877322011 | 580.4079156873152 | 2479.753961634696
Spreadsheet: 714135d1611110227-help-with-index-and-match-stratplandata
Sheet: Goals

GoalID | Perspective | Goal
FG01 | Financial | Manage Budgets
FG02 | Financial | Manage Costs
FG03 | Financial | Manage Spending
FG04 | Financial | Meet Specifications
CG01 | Customer | Meet Regulatory Compliance
CG02 | Customer | Improve Communication
CG03 | Customer | Increase Quality
CG04 | Customer | Evolve Product Ownership
CG05 | Customer | Evolve Capabilities
CG06 | Customer | Improve Partnerships
[NAME] | Customer | Optimize Value
CG08 | Customer | Improve Responsiveness
CG09 | Customer | Increase Transparency
CG10 | Customer | Decrease Hassles
CG11 | Customer | Promote Purpose
OG01 | Operations | Simplify Processes
OG02 | Operations | Reduce Risk
OG03 | Operations | [NAME]
OG04 | Operations | Integrate Teams
OG05 | Operations | Connect Staff
OG06 | Operations | Reduce Costs
OG07 | Operations | Improve Work Quality
OG08 | Operations | Improve Communication
OG09 | Operations | Reduce Anxiety
OG10 | Operations | Provide Fun
OG11 | Operations | Provide Rewards
OG12 | Operations | Expand Network
OG13 | Operations | Ensure Reputational Assurance
OG14 | Operations | Promote Staff Marketability
OG15 | Operations | Promote Social Responsibility
OG16 | Operations | Provide Growth and Development
AG01 | Architecture | Increase Innovation
AG02 | Architecture | Improve Stability
AG03 | Architecture | Modernize Codebase
AG04 | Architecture | Evolve Microservices
AG05 | Architecture | Evolve Dev-Opps
AG06 | Architecture | Establish Delivery Cycles
AG07 | Architecture | Improve Documentation
AG08 | Architecture | Develop Maturity Roadmap
AG09 | Architecture | Improve IT Governance
AG10 | Architecture | Adopt Web-based Capabilities
AG11 | Architecture | Improve Processes
TG01 | Transformation | Develop Business Agility
TG02 | Transformation | Develop Resource Agility
TG03 | Transformation | Develop Shared Ownership
TG04 | Transformation | Develop Project Management Capabilities
TG05 | Transformation | Develop Business Analysis Capabilities
TG06 | Transformation | Develop Servant Leadership Capabilities
TG07 | Transformation | Develop Cross-Functional Partnerships
TG08 | Transformation | Promote Higher Purpose / Value-Add Culture
TG09 | Transformation | Drive Goals and Objectives
TG10 | Transformation | Provide Learning and Succession Plans
TG11 | Transformation | Promote Functional Convergance
TG12 | Transformation | Develop Business Strategy Plans
TG13 | Transformation | Evolve Shared Services
[NAME] | Transformation | Develop Governance Model
TG15 | Transformation | Develop Business Relationship Management
Spreadsheet: 604323d1546517271-need-help-with-separating-data-on-a-pivot-report-book3
Sheet: Assumptions

 | ID | Options | Cost per unit | Assumption
 | 1 | Unable to sell stock | 75
 | 2 | Unable to transport stock | 50
 | 3 | New buyer for stock | 25
 | 4 | Compensation Scheme | 25
 | 5 | Assumption 5 | 75
 | 6 | Assumption 6 | 75
 | 7 | Assumption 7 | 30
 | 8 | Assumption 8 | 0.2
 | 9 | Assumption 9 | 80
 | 10 | Assumption 10 | 80
 | 11 | Assumption 11 | 85
 | 12 | Assumption 12 | 90
 | 13 | Assumption 13 | 90
 | 14 | Assumption 14 | 90
 | 15 | Assumption 15 | 95
 | 16 | Assumption 16 | 100
 | 17 | Assumption 17 | 100
 | 18 | Assumption 18 | 90
Spreadsheet: 491663d1480591429-amend-formula-to-check-if-cell-a2-has-data-entered-example
Sheet: Report

Task ID | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 | Data 6 | Data 7 | Data 8 | Data 9 | Data 10 | Data 11 | Data 12 | Data 13 | Data 14 | Data 15 | Data 16 | Data 17 | Data 18 | Data 19 | Data 20
1111 |  |  | Hold |  |  |  |  |  |  | 2016-05-08 00:00:00
2222 |  |  | Hold |  |  |  |  |  |  | 2016-12-02 00:00:00
3333 |  |  | Client Hold |  |  |  |  |  |  | 2016-05-08 00:00:00
4444 |  |  | Client Hold |  |  |  |  |  |  | 2016-12-02 00:00:00
5555 |  |  | Open |  |  |  |  |  |  | 2016-05-08 00:00:00
6666 |  |  | Open |  |  |  |  |  |  | 2016-12-02 00:00:00
Spreadsheet: 165992d1341420194-search-values-in-data-table-that-are-greater-than-cell-value-sambuka_premier-quick-help-3-_04jul1_01
Sheet: Quick Search

 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Product: |  |  |  |  |  | [NAME]: | Malbec
Country: |  |  |  |  |  | Vendor:
Region: |  |  |  |  |  | BTG Min: | 10 |  | Need to have filtered by greater than / equal to in column G
Appellation: |  |  |  |  |  | BTG Max: | 25 |  | Need to have filtered by less than / equal to in column G
Spreadsheet: 48945d1248233879-excel-2007-automaticly-select-data-to-go-to-different-worksheets-purchasing
Sheet: PO #

PO # | Vendor | Description | Department | Requisitioner | Date
150000 |  |  | Acid Unloading
 |  |  | General Plant
 |  |  | Lab
 |  |  | Lab
 |  |  | Maintenance
 |  |  | [NAME] |  |  |  |  |  | Acid Unloading
 |  |  |  |  |  |  |  |  | Administation
 |  |  |  |  |  |  |  |  | F.I.P.
 |  |  |  |  |  |  |  |  | General Plant
 |  |  |  |  |  |  |  |  | Grounds
 |  |  | Security |  |  |  |  |  | Lab
 |  |  |  |  |  |  |  |  | Maintenance
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Rolling Stock |  |  |  |  |  | Rolling Stock
 |  |  |  |  |  |  |  |  | Safety
 |  |  |  |  |  |  |  |  | Security
 |  |  | Safety
1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 131546d1323143951-august-1-to-january-8-date-switch-excelforum-sample
Sheet: Sheet1

Value | 2011-12-08 00:00:00 | 2011-12-09 00:00:00
 | 12 | 48
 | 34 | 72
 | 543 | 56
 | 67 | 98
 | 98 | 1
 | 0 | 0
 | 42 | 45
 | 2 | 890
 | 17 | 1234
 | 0 | 0
 | 67 | 543
 | 65 | 34
 | 34 | 32
 | 98 | 6
 | 1000 | 18
Mean
Median
Std Deviation
Increased
Decreased