tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 799330d1665048308-calculating-working-days-times-between-2-dates-inbox2
Sheet: New

Date Received | First Response Date | Working Hours to respond (not including weekends and public holidays) | Hours to respond (not including weekends and public holidays) | Date completed | Working Hours to complete (not including weekends and public holidays) | Hours to complete (not including weekends and public holidays)
2022-12-23 00:00:00 | 2022-12-28 00:00:00
2022-10-03 09:00:00 | 2022-10-04 09:00:00 |  |  | 2022-07-05 16:00:00
2022-10-03 07:00:00 | 2022-10-03 09:00:00 |  |  | 2022-07-05 16:00:00
2022-10-03 09:00:00 | 2022-10-05 09:00:00 |  |  | 2022-07-05 16:00:00
2022-07-03 00:00:00
2022-07-22 00:00:00
2022-07-22 00:00:00
2022-08-02 00:00:00
2022-08-02 00:00:00
2022-08-05 00:00:00
2022-08-07 00:00:00
2022-08-08 00:00:00
2022-09-01 00:00:00
2022-09-10 00:00:00
02:19:00
Spreadsheet: 81995d1282073316-filter-and-sum-like-part-numbers-demo-sheet
Sheet: Simplified

Part Number | Description | Quantity
10001 | Assembly 1 | 1
10001 | Assembly 2 | 1
10133 | Assembly 3 | 1
10150 | Assembly 4 | 1
10164 | Assembly 5 | 1
10003 | Part 1 | 2
10013 | Part 10 | 2
10014 | Part 11 | 4
10015 | Part 12 | 2
10016 | Part 13 | 8
10017 | Part 14 | 8
10018 | Part 15 | 8
10019 | Part 16 | 4
10020 | Part 17 | 12
10021 | Part 18 | 20
10022 | Part 19 | 4
10004 | Part 2 | 2
10023 | Part 20 | 40
10024 | Part 21 | 40
10025 | Part 22 | 8
10027 | Part 23 | 55
10028 | Part 24 | 110
10029 | Part 25 | 220
10030 | Part 26 | 220
10031 | Part 27 | 220
10032 | Part 28 | 220
10034 | Part 29 | 2
10005 | Part 3 | 4
10035 | Part 30 | 2
10036 | Part 31 | 24
10037 | Part 32 | 24
10038 | Part 33 | 24
10039 | Part 34 | 24
10040 | Part 35 | 220
10042 | Part 36 | 8
10043 | Part 37 | 8
10044 | Part 38 | 8
10046 | Part 39 | 24
10006 | Part 4 | 4
10047 | Part 40 | 48
10048 | Part 41 | 110
10049 | Part 42 | 110
10050 | Part 43 | 110
10051 | Part 44 | 110
10052 | Part 45 | 110
10053 | Part 46 | 24
10054 | Part 47 | 24
10056 | Part 48 | 4
10057 | Part 49 | 4
10007 | Part 5 | 2
10058 | Part 50 | 4
10059 | Part 51 | 4
10060 | Part 52 | 16
10062 | Part 53 | 4
10063 | Part 54 | 4
10064 | Part 55 | 4
10065 | Part 56 | 4
10066 | Part 57 | 16
10067 | Part 58 | 2
10068 | Part 59 | 6
10008 | Part 6 | 6
10069 | Part 60 | 3
10070 | Part 61 | 2
10071 | Part 62 | 2
10072 | Part 63 | 2
10073 | Part 64 | 4
10074 | Part 65 | 2
10075 | Part 66 | 55
10076 | Part 67 | 110
10134 | Part 68 | 6
10135 | Part 69 | 48
10009 | Part 7 | 3
10136 | Part 70 | 48
10137 | Part 71 | 48
10138 | Part 72 | 48
10139 | Part 73 | 5
10140 | Part 74 | 2
10141 | Part 75 | 3
10142 | Part 76 | 13
10143 | Part 77 | 13
10144 | Part 78 | 3
10145 | Part 79 | 4
10011 | Part 8 | 2
10146 | Part 80 | 2
10147 | Part 81 | 5
10148 | Part 82 | 5
10149 | Part 83 | 4
10151 | Part 85 | 2
10152 | Part 86 | 3
10153 | Part 87 | 4
10154 | Part 88 | 2
10155 | Part 89 | 1
10012 | Part 9 | 2
10002 | Sub Assembly 1 | 1
10010 | Sub Assembly 10 | 1
10026 | Sub Assembly 11 | 88
10010 | Sub Assembly 2 | 1
10026 | Sub Assembly 3 | 55
10033 | Sub Assembly 4 | 2
10041 | Sub Assembly 5 | 8
10045 | Sub Assembly 6 | 24
10055 | Sub Assembly 7 | 4
10061 | Sub Assembly 8 | 4
10002 | Sub Assembly 9 | 1
Spreadsheet: 103027d1300880893-excel-2007-formula-to-match-person-using-multiple-criteria-search-with-multiple-criteria
Sheet: Data

Supplier | Country | MA
Ana | Germany | [NAME]
Elfi | Germany | [NAME]
Bea | Germany | [NAME]
Bea | Spain | Daan
Dolores | Spain | Daan
Ana | Spain | Daan
Caty | Spain | Daan
Caty | Greece | Tino
Doloros | Greece | Tino
Elfi | Greece | Tino
Spreadsheet: tracy_geaccone__40492__OM Schedule - IT 1
Sheet: Variance to Plan

DIRECT O&M VARIANCE
2001 PLAN vs. 2002 PLAN
 |  |  | 2001 RESTATED PLAN | 2001 ADJUSTED FOR 2002 BUDGET CHANGES (1)
2001 PLAN -  NET |  |  | 25.3 | 25.7
Variances:
SAN Monthly Fee |  |  | 2.8 | 2.8
O&E Support - Transfer of Funds |  |  | 0.7 | 0.3
EPSC |  |  | 0.9 | 0.9
New License Fees |  |  | 0.5 | 0.5
Software Maintenance Fees* |  |  | 0.1 | 0.1
2002  PLAN - NET
*  Offset in Operations
(1)  2001 Adjusted for $.4 O&E Support;  Offset Should be Reflected in Operations 2002 Plan.
Spreadsheet: 87a87efa-6ae1-4f82-8e12-09e1f897e6c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | br. Indeksa | prezime i ime | predavanja | [NAME] | 1. kolokvijum | ispit | ukupni bodovi | [NAME]
 | 2011/0243 | [NAME] |  |  | 21.7 |  | / | /
 | 2011/0195 | Ђорђевић Јулија |  |  | 12,8, 24,5 |  | / | /
 | 2011/0017 | Зековић Јана |  |  | 8,5, 20,4 |  | / | /
 | 2011/0124 | Златковић Маја |  |  | 17.2 |  | / | /
 | 2011/0148 | [NAME] |  |  | 18, 23,8 |  | / | /
 | 2011/0164 | [NAME] |  |  | 12,8,24,4 |  | / | /
 | 2011/0234 | Костадинов Лидија |  |  | 16.1 |  | / | /
 | 2011/0266 | Красић Исидора |  |  | 13,7,25,8 |  | / | /
 | 2011/0031 | [NAME] |  |  | 12,9,26,2 |  | / | /
 | 2011/0231 | Митровић Никола |  |  | 14, 23,8 |  | / | /
 | 2011/0215 | Новаковић Милица |  |  | 12, 19,3 |  | / | /
 | 2011/0273 | [NAME] |  |  | 13,8, 25 |  | / | /
 | 2011/0246 | Петровић Раде |  |  | 12,5, 21,5 |  | / | /
 | 2011/0258 | Радошевић Мирјана |  |  | 10,7,23,3 |  | / | /
 | 2011/0233 | Славковић Милица |  |  | 15.6 |  | / | /
 | 2011/0253 | Стаменковић Софија |  |  | 12,4 25,3 |  | / | /
 | 2010/0243 | [NAME] |  |  | 8,5,19,1 |  | / | /
 | 2009/0310 | [NAME] |  |  | 13,3,15,5 |  | / | /
 |  |  |  |  |  |  | / | /
 |  |  |  |  |  |  | / | /
 |  |  |  |  |  |  | / | /
Spreadsheet: 598705d1542663664-formula-comes-back-with-zeros-if-blank-i-dont-want-zeros-excel-forum
Sheet: Start here

 |  | P1
 | Paste here
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
41
 |  | P2
 | Paste here
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
41
 |  | P3
 | Paste here
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
41
 |  | P4
 | Paste here
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
41
 |  | P5
 | Paste here
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
41
 |  | P6
 | Paste here
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
41
 |  | P7
 | Paste here
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
41
 | P1
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
41
 | P2
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
41
 | P3
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
41
 | P4
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
41
 | P5
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
41
 | P6
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
41
 | P7
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
41
Spreadsheet: 740703d1626472548-grouping-of-child-parts-and-sun-in-parent-in-hierarchy-multilevel-summing-sublevels-kapil-d-
Sheet: Sheet1

 | Sr No | Level 1 | Level2 | Level3 | Level 4 | Recived Data | Result |  | Level1 | Level2 | Level3 | Level4 |  | Result from Excel | Description | [NAME] as
 | 1 | K |  |  |  |  |  |  |  |  |  |  |  |  | Level 1 = additional of all level 2 qty only
 | 2 |  | A |  |  | 1 |  |  |  |  |  |  |  | 1 | Level 2 Qty | Level 4 : | Level 4 Contains child  item M and N with there quantity
 | 3 |  | B |  |  | 1 |  |  |  |  |  |  |  | 1 | Level 2 Qty | Level 3 : | Level 3 - Qty  of Q is sum  Qty  of M and N in Level 4 (Childs )
 | 4 |  | C |  |  |  |  |  |  |  |  |  |  |  | Level 2 Cost - Addition of all Level 3 qty | Level 2 : | Level 2 - Qty  of C is sum of P and Q in level 3 (Childs )
 | 5 |  |  | P |  | 3 |  |  |  |  |  |  |  | 3 |  | Level 1: | Top item k is sum of  all A to F Qty
 | 6 |  |  | Q |  |  |  |  |  |  |  |  |  |  | Level 3 Qty -Addition of Level 4 Qty
 | 7 |  |  |  | M | 2 |  |  |  |  |  |  |  | 2 |  | Remarks | [NAME]  of each level in the tree /Hierarchy
 | 8 |  |  |  | N | 3 |  |  |  |  |  |  |  | 3 |  |  | Should Not include blank as it appears in Pie charts graphs
 | 9 |  | D |  |  | 1 |  |  |  |  |  |  |  | 1 | Level 2 Qty |  | Can it possible to get pivot table report in hierarchy to connect in power view
 | 10 |  | E |  |  | 2 |  |  |  |  |  |  |  | 2 | Level 2 Qty
 | 11 |  | F |  |  | 1 |  |  |  |  |  |  |  | 1 | Level 2 Qty
Spreadsheet: 835282d1688480549-creating-a-variable-location-and-shipping-kg-formula-book8
Sheet: Sheet1

0.5 | 1 | 1.5 | 2 |  | >2 | [NAME]
12.03 | 16.15 | 20.28 | 24.41 | NZ | 2.8 | 3.7
24.99 | 35.07 | 45.14 | 55.22
21.12 | 30.81 | 40.53 | 50.26
26.61 | 37.33 | 48.06 | 58.78
27.41 | 38.46 | 49.51 | 60.56
Spreadsheet: 134267d1325158474-pivot-field-names-view-example
Sheet: Tab1

Row Labels | Country | Sum of Amount
v0001 | australia | 1294008
 | media | 2675
 | na | 2755
 | testcampaign | 10682
v0001 Total |  | 1310120
v0002 | brazil | 213662
 | canada | 160104
 | denmark | 114253
 | germany | 220116
 | greece | 151965
 | media | 2619
 | na | 2725
 | none | 8370
 | norway | 130912
 | sweden | 243071
 | testcampaign | 2668
 | (blank) | 3460
v0002 Total |  | 1253925
v0003 | greece | 850798
 | media | 2658
 | netherlands | 203708
 | norway | 248651
 | sweden | 261846
v0003 Total |  | 1567661
Grand Total |  | 4131706
Spreadsheet: 814363d1674313310-attendance-tracker-ref-errors-employee-attendance-test-2
Sheet: Time Off Balances

Team Member | Vacation Days | WIX Days
[NAME] | 14 | 0
[NAME] | 15 | 1
[NAME] | 15 | 1
[NAME] | 10 | 1
[NAME] | 9 | 1
Ulises Quinones | 10 | 1
[NAME] | 10 | 1
[NAME] | 15 | 1
[NAME] | 15 | 1
[NAME] | 10 | 0
[NAME] | 10 | 1
[NAME] | 10 | 1
[NAME] | 10 | 1
[NAME] | 5 | 1
Spreadsheet: 121965d1316528891-excel-calendar-finding-closest-date-and-then-matching-text-project-calender-and-dates-
Sheet: Project dates and tasks

Course | Project 1 Nov 11 |  | Project 2 Feb 12 |  | Project 3 Feb 12 |  | Project 4 July 12 |  | Project 5 July Aug 12 |  | Project 6 July 13 |  | Project 7 July 14
Task 1 | 2011-11-02 00:00:00 | Task 1 Project 1 | 2012-07-03 00:00:00 | Task 1 Project 1 | 2012-07-03 00:00:00 | Task 1 Project 3
Task 2 | 2011-12-21 00:00:00 | Task 2 Project 1 | 2012-10-09 00:00:00 | Task 2 Project 2 | 2012-09-25 00:00:00 | Task 2 Project 3
Task 3 | 2012-12-03 00:00:00 | Task 3 Project 1
Task 4
Task 5
Task 6
Task 7
Task 8
Task 9
Task report | 2013-01-15 00:00:00 | TR - Project 1 | 2013-01-30 00:00:00 | TR - Project 2
Task submission | 2013-01-30 00:00:00 | TS - Project 1 | 2013-02-20 00:00:00 | TS - Project 2
Pre-meeting catch up  1 | 2011-12-01 00:00:00 | PMC 1 - Project 1 |  |  | 2012-03-02 00:00:00 | PMC 1 -Project 3
Pre-meeting catch up 2 | 2013-01-15 00:00:00 | PMC 2 - Project 1 |  |  | 2012-04-17 00:00:00 | PMC2 - Project 3
Pre-meeting catch up 3 | 2012-03-16 00:00:00 | PMC 3 - Project 1
Pre-meeting catch up 4
Pre-meeting catch up 5
Pre-meeting catch up 6
Pre-meeting catch up 7
Pre-meeting catch up 8
Spreadsheet: 33b2cc9f-b76f-490b-a1cd-c9c322fd5be9
Sheet: REACH

Risk Reduction, Education, and Community Health (REACH) Program
1725 W. 17th Street, Suite 101B
Santa Ana, CA 92706
Main Phone Line: (714) 834-7926
Toll Free: (800) 33-REACH
Main Fax: (714) 834-8235
Name and Title | Role | Contact Email | Contact Phone Number | Fax Number
Christina Weckerly Ramirez, Service Chief | Supervises REACH Programs | [EMAIL] | (714) 834-8348 | N/A
[NAME], Case Manager | Case Manager | [EMAIL] | (714) 834-7721 | N/A
[NAME], Case Manager | Case Manager | [EMAIL] | (714) 834-8639 | N/A
[NAME], Case Manager | Case Manager | [EMAIL] | (714) 834-7913 | N/A
Front Office | Transportation Appointments | N/A | 7148347926 | N/A
Case Managers or [NAME] | Medical Detox Intake or Questions | N/A | 7148347926 | N/A
Spreadsheet: phillip_platter__31378__RT-STCA August
Sheet: Aug16

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | PRICE | MARKET | PRICE | FEES | CONG | A_S CHARGE | BASIS | FERC ADJ | ENPOWER DEALS | TMM | LINE LOSSES | P_L | FILE SOURCE | TAG NO
2001-08-16 00:00:00 |  |  | 1 | 6 |  | SP15 | CORAL | 100 |  |  | 24 | STCALI | 32 |  |  |  |  |  |  | 733669,733672 | 1 |  |  | P:\RealTime\INCREMENT\Windows2000\[AUG TRADING.xls]AugTRD16
2001-08-16 00:00:00 |  |  | 23 | 24 |  | SP15 | RELIANT | 50 |  |  | 38 | STCALI | 32 |  |  |  |  |  |  | 736051, 733672 | 1 |  |  | P:\RealTime\INCREMENT\Windows2000\[AUG TRADING.xls]AugTRD16
2001-08-16 00:00:00 |  |  | 23 | 23 |  | SP15 | NEVI | 25 |  |  | 36 | STCALI | 32 |  |  |  |  |  |  | 736051, 733672 | 1 |  |  | P:\RealTime\INCREMENT\Windows2000\[AUG TRADING.xls]AugTRD16
2001-08-16 00:00:00 |  |  | 24 | 24 |  | SP15 | NEVI | 35 |  |  | 36 | STCALI | 32 |  |  |  |  |  |  | 736051, 733672 | 1 |  |  | P:\RealTime\INCREMENT\Windows2000\[AUG TRADING.xls]AugTRD16
2001-08-16 00:00:00 |  |  | 23 | 23 |  | SP15 | MIRANT | 25 |  |  | 40 | STCALI | 32 |  |  |  |  |  |  | 736054, 733672 | 1 |  |  | P:\RealTime\INCREMENT\Windows2000\[AUG TRADING.xls]AugTRD16
2001-08-16 00:00:00 |  |  | 24 | 24 |  | SP15 | MIRANT | 15 |  |  | 40 | STCALI | 32 |  |  |  |  |  |  | 736054, 733672 | 1 |  |  | P:\RealTime\INCREMENT\Windows2000\[AUG TRADING.xls]AugTRD16
Spreadsheet: 153721d1336029266-excel-2007-help-with-counting-totals-from-different-columns-example
Sheet: Sheet1

 | total ex vat | type | no of discounts | total value
bob | 3 | credit
bob | 3 | discount | 3 | 9
tom | 4 | credit
viv | 6 | discount | 3 | 18
lou | 1 | credit
[NAME] | 6 | discount | 4 | 24
lou | 12 | credit
[NAME] | 1 | discount | 10 | 10
Spreadsheet: a97c1025-8279-4345-beb9-f1ca3c325835
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
FCLNE | Test | FCLNE | Anti-Phosphatidylcholine Ab | Anti-Phosphatidylcholine Panel | Enzyme-Linked Immunosorbent Assay (ELISA) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 3 mL serum refrigerated in plastic vial(s). Required:  Collection date | 0.25 mL | Specimens other than	Serum Anticoagulants other than	Plain red-top Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icteric	NA | Reference values:  < 12.0 U/mL   Anti-Phosphatidylcholine IgG: Negative:  Less than to 12 Equivocal:  12 - 18 Positive:  Greater than 18   Anti-Phosphatidylcholine IgM: Negative:  Less than to 12 Equivocal:  12 - 18 Positive:  Greater than 18   Anti-Phosphatidylcholine IgA: Negative:  Less than to 12 Equivocal:  12 - 18 Positive:  Greater than 18   Test Performed by: Cambridge Biomedical Inc.                                       1320 Soldiers Field Road                                       Boston, MA 02135 | Wednesday | 1 - 14 days | 9 - 16 days | 3 | 83520 |  |  |  |  | Cambridge Biomedical Inc.
FCLNE | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
FCLNE | Result | [NAME] | Anti-phosphatidylcholine IgG | Anti-phosphatidylcholine IgG | Alphanumeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 13076-5
FCLNE | Result | [NAME] | Anti-Phosphatidylcholine IgM | Anti-Phosphatidylcholine IgM | Alphanumeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 13077-3
FCLNE | Result | Z0141 | Anti-Phosphatidylcholine IgA | Anti-Phosphatidylcholine IgA | Alphanumeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 13078-1
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: June

Margin and Sales by Vendor - June 2020
Vendor | Sales | Margin $ | Margin %
F5 | 1 | 1
Palo Alto Networks | 1 | 1
Tenable | 1 | 1
Broadcom Solutions | 1 | 1
Netapp Aust | 1 | 1
Hewlett Packard Enterprise | 1 | 1
Riverbed | 1 | 1
Pure Storage | 1 | 1
Sophos | 1 | 1
Extreme Networks | 1 | 1
ForeScout | 1 | 1
FireEye | 1 | 1
Gigamon | 1 | 1
Cohesity | 1 | 1
CS Vendors | 1 | 1
Mellanox | 1 | 1
Microsoft | 1 | 1
Channel Services | 1 | 1
Ribbon | 1 | 1
Infoblox | 1 | 1
Cylance | 1 | 1
Arista | 1 | 1
Avaya | 1 | 1
[NAME] | 1 | 1
Nutanix | 1 | 1
Amazon Web Services | 1 | 1
AlgoSec | 1 | 1
MobileIron | 1 | 1
Check Point | 1 | 1
Symantec | 1 | 1
[NAME] | 1 | 1
[NAME] | 1 | 1
BitTitan | 1 | 1
Unify | 1 | 1
Grand Total
Spreadsheet: 6ff21a7a-1e04-4c02-807d-8dd14a5d518c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Page 1
ABSTRACT OF ASSESSMENT FOR 2009
ALL VALUES REPORTED ARE TO BE AFTER BOARD OF REVIEW ACTION
 | DALLAS COUNTY |  | City/County
AGRICULTURAL REALTY
(Do Not Include Dwellings)
Column 1 | Column 2 | Column 3 | Column 4 | Column 5
Townships | Number of | Actual Value | Actual Value of | Total Actual Value
and Unincorporated | Agricultural | of Land Only | Structures (Do not | of Land and Structures
Areas | Acres |  | include dwellings) | (Col. 3 Plus Col. 4)
BOONE | 8390.33 | 3050070 | 680590 | 3730660
[NAME] | 19437.35 | 8994080 | 3210630 | 12204710
ADAMS | 20665.89 | 8920840 | 2088920 | 11009760
UNION | 19471.82 | 8211310 | 1838840 | 10050150
WALNUT | 11316.28 | 8776680 | 1615470 | 10392150
ADEL | 15913.95 | 10526570 | 1533520 | 12060090
COLFAX | 21925.2 | 14197420 | 2082940 | 16280360
LINN | 21070.95 | 12068280 | 2603750 | 14672030
GRANT | 19664.28 | 13148350 | 2605230 | 15753580
SUGAR GROVE | 20654.08 | 16262680 | 1609250 | 17871930
WASHINGTON | 21805.21 | 15895610 | 5330930 | 21226540
LINCOLN | 22680.29 | 17783370 | 3736100 | 21519470
DES MOINES | 16267.96 | 10410550 | 1003560 | 11414110
BEAVER | 21410.44 | 14311020 | 2010510 | 16321530
SPRING VALLEY | 17969.58 | 11705050 | 1412230 | 13117280
DALLAS | 21750.29 | 16359830 | 2753670 | 19113500
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Townships Totals | 300393.9 | 190621710 | 36116140 | 226737850
Cities
[NAME] | 351.09 | 116640 | 24130 | 140770
DE SOTO | 565.98 | 247790 | 27050 | 274840
DEXTER | 1106.87 | 589840 | 143600 | 733440
REDFIELD | 236.75 | 117130 |  | 117130
WAUKEE | 4584.29 | 3206290 | 416080 | 3622370
LINDEN | 360.29 | 289560 | 7940 | 297500
ADEL | 784.33 | 431410 | 19890 | 451300
DALLAS CENTER | 2448.96 | 1950180 | 4437240 | 6387420
GRANGER | 375.57 | 268520 | 9820 | 278340
MINBURN | 29.25 | 25400 | 9710 | 35110
WOODWARD | 992.9 | 729400 | 29620 | 759020
BOUTON | 4.48 | 3890 | 358500 | 362390
DAWSON | 210.25 | 132020 | 19030 | 151050
PERRY | 564.18 | 459910 | 143510 | 603420
WEST DES MOINES | 2507.02 | 1413610 | 127360 | 1540970
CLIVE | 415.2 | 220280 | 22440 | 242720
URBANDALE | 2573.88 | 1322650 | 173630 | 1496280
GRIMES | 904.05 | 721610 | 50980 | 772590
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Cities Totals | 19015.34 | 12246130 | 6020530 | 18266660
County Totals | 319409.24 | 202867840 | 42136670 | 245004510
Spreadsheet: 786781d1657441645-count-excel-cells-based-on-two-colums-and-date-being-specific-day-of-week-2022-07-10-oeldere-kbr0125-book1-4-
Sheet: Sheet1

[NAME] | Department | Date/Time of Sale | Day | Name of Day |  | Monday - Friday Install |  | Saturday - Install |  | Any Day - General
[NAME] | Install | 2022-06-20 09:56:47 |  |  |  | [NAME] | Fred | [NAME] | Fred | [NAME] | Fred
[NAME] | General | 2022-06-25 08:57:09 |  |  |  | 1 | 2 | 0 | 1 | 1 | 2
Fred | Install | 2022-06-25 20:20:32
Fred | Install | 2022-06-24 17:51:27
Fred | Install | 2022-06-20 20:20:32
Fred | General | 2022-06-23 17:51:27
[NAME] | Install
Fred | General | 2022-06-21 17:51:27
 |  |  |  |  |  |  | Aantal van Day | Kolomlabels
 |  |  |  |  |  |  | Rijlabels | Monday-Friday | Weekend | Eindtotaal
 |  |  |  |  |  |  | General | 2 | 1 | 3
 |  |  |  |  |  |  | [NAME] |  | 1 | 1
 |  |  |  |  |  |  | Fred | 2 |  | 2
 |  |  |  |  |  |  | Install | 3 | 2 | 5
 |  |  |  |  |  |  | [NAME] | 1 | 1 | 2
 |  |  |  |  |  |  | Fred | 2 | 1 | 3
 |  |  |  |  |  |  | Eindtotaal | 5 | 3 | 8
Spreadsheet: 721712d1614829483-look-up-dates-and-quanities-from-a-table-inventory-multiple-rec-dates-bvj-
Sheet: IncomingShipments2

 | PO Units | [NAME]
 |  | 3/3/2021 | 3/4/2021 | 3/9/2021 | 3/17/2021 | 3/18/2021 | 3/24/2021 | 4/8/2021 | 4/14/2021 | 4/20/2021 | 5/20/2021 | 6/20/2021 | 7/20/2021
 | Model #
 | LD-DXL10 |  |  |  |  |  |  | 24 |  |  | 78 |  | 50
 | LD-DXL10QS | 25 |  |  |  | 120 |  | 30 | 150 | 150 | 48 |  | 46
 | LD-DXL10-KR19
 | LD-DXL12QS | 180 |  |  |  | 20 |  | 6 |  | 200 |  | 48 | 200
 | LD-DXL14 |  |  |  |  |  |  | 32 |  |  | 10 | 45 | 30
 | LD-DXL14-KR19 |  |  |  |  |  |  | 24 |  |  |  | 29 | 20
 | LD-DXL16QS |  |  |  |  |  |  | 24 |  |  | 20
 | LD-DXL18 | 11 |  |  |  |  |  | 5 |  | 10 | 24 | 20 | 12
 | LD-DXL18-KR19 |  |  |  | 9 | 4 |  |  |  | 12 | 2 |  | 10
 | LD-DXL22QS |  |  |  |  | 12 |  |  |  |  |  | 26 | 12
 | LD-DXL24 |  |  |  |  |  |  | 6 |  |  | 10 | 40 | 24
 | LD-DXL420 |  |  |  |  |  |  |  |  |  | 7 |  | 1
 | LD-DXL428 |  |  |  |  |  |  |  |  |  | 1 | 12 | 4
 | LD-DXL436 |  |  | 6
 | LD-DXL6 | 18 |  |  | 18 | 90 |  |  |  | 48 | 120 |  | 42
 | LD-DXL60-10QS | 18 |  |  |  |  |  | 12 | 6 |  |  |  | 10
 | LD-DXL60-10QS-KR19 |  |  |  |  |  |  |  |  |  |  | 2
 | LD-DXL60-14QS | 70 |  |  |  | 60 |  | 4 | 48 | 12 | 28
 | LD-DXL60-14QS-KR19 |  |  |  |  |  |  |  |  |  | 4 |  | 10
 | LD-DXL6QS | 96 |  |  | 48 | 60 |  |  |  | 60 | 48 | 252 | 48
 | LD-DXLI10 |  |  |  |  |  |  |  |  | 160
 | LD-DXLI10QS | 34 |  |  | 2 | 6 |  |  | 240 | 272 | 100 | 196 | 200
 | LD-DXLI8 |  |  |  |  |  |  | 240 |  | 120 | 90
Spreadsheet: 849347d1699879022-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments-_v3
Sheet: Payment forecast 

 |  |  | Purchase  Month |  |  |  |  |  |  |  | Credit Terms |  |  | Item | Payment Month
 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 60 days | 30 days | Due Now |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00
 |  |  |  |  |  |  |  | 50000 |  |  | 0.25 | 0.6 | 0.15 | Stock & Purchase - PT A |  |  |  |  |  |  | ??? | ????
 |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.5 | 0.3 | Stock & Purchase - PT B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11250 | 76875 | 181875 | 216250 | 147500