tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2004__American Public Energy Agency
Sheet: Sheet1

Customer Name | Customer | Allocation | Sp. GL Ind. | Reference | Document header text | XREF 1 | XREF 2 | XREF 3 | Company code | Invoice # | Invoice Date | Net Due Date | Delivery Period | Posting date | Document type | Currency | Current | 1 To 30 | 31 To 60 | 61 To 90 | 91 To 120 | Over 120 | On Account | Total Amt | Text
American Public Energy Agency | 3000002715 | 020169013SFI |  | 020169013SFI-1 |  | K HUNTLEY | F | 2002-01 | 364 | 100005373 | 2002-01-03 00:00:00 | 2002-01-09 00:00:00 | N/A | 2002-01-01 00:00:00 | XN | USD | 0 | 0 | 0 | 0 | 0 | 39060 | 0 | 39060 | *020169013SFI-1 K Huntley
American Public Energy Agency | 3000002715 | 01113536SFI |  | 01113536SFI-1 |  | N SUMMERS | F | 2001-11 | 364 | 100253853 | 2001-11-02 00:00:00 | 2001-12-26 00:00:00 | N/A | 2001-12-01 00:00:00 | XN | USD | 0 | 0 | 0 | 0 | 0 | 121275 | 0 | 121275 | *01113536SFI-1 N Summers
Company code | [NAME] | Vendor | Total Amt | Document header text | Invoice # | Invoice Date | Net Due Date | Posting date | Currency | Text | XREF 3
364 | American Public Energy Agency | 3000004138 | 6595.87 |  | 1700001763 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | USD | 140063 | 2000-00
364 | American Public Energy Agency | 3000004138 | 1698.04 |  | 1700001762 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | USD | 9999                  S | 2000-00
Spreadsheet: 798917d1664811941-what-formula-to-use-for-summary-data-ot-2-
Sheet: Summary

 | 95A
Spreadsheet: 463417d1464529126-conditional-formatting-duplicates-any-order-double-numbers-comparison
Sheet: Sheet1

x | zbor | newdoverman | compare | y
001 |  |  |  | 204
002 |  |  |  | 402
003 |  |  |  | 606
222 |  |  |  | 661
005 |  |  |  | 900
006 |  |  |  | 222
007 |  |  |  | 841
008 |  |  |  | 785
009 |  |  |  | 931
011 |  |  |  | 010
022 |  |  |  | 100
033 |  |  |  | 391
044 |  |  |  | 971
055 |  |  |  | 008
066 |  |  |  | 961
077 |  |  |  | 254
088 |  |  |  | 001
099 |  |  |  | 686
112 |  |  |  | 673
113 |  |  |  | 101
114 |  |  |  | 534
115 |  |  |  | 921
116 |  |  |  | 810
117 |  |  |  | 918
118 |  |  |  | 298
119 |  |  |  | 280
122 |  |  |  | 181
133 |  |  |  | 880
144 |  |  |  | 253
155 |  |  |  | 729
166 |  |  |  | 461
177 |  |  |  | 892
188 |  |  |  | 029
199 |  |  |  | 731
223 |  |  |  | 236
224 |  |  |  | 002
225 |  |  |  | 000
226 |  |  |  | 409
227 |  |  |  | 073
228 |  |  |  | 473
229 |  |  |  | 256
233 |  |  |  | 381
244 |  |  |  | 552
255 |  |  |  | 799
266 |  |  |  | 706
277 |  |  |  | 174
288 |  |  |  | 926
299 |  |  |  | 413
334 |  |  |  | 985
335 |  |  |  | 606
336 |  |  |  | 454
337 |  |  |  | 610
338 |  |  |  | 355
339 |  |  |  | 918
344 |  |  |  | 911
355 |  |  |  | 009
366 |  |  |  | 263
377 |  |  |  | 001
388 |  |  |  | 684
399 |  |  |  | 822
445 |  |  |  | 679
446 |  |  |  | 450
447 |  |  |  | 170
448 |  |  |  | 694
449 |  |  |  | 242
455 |  |  |  | 072
466 |  |  |  | 480
477 |  |  |  | 839
488 |  |  |  | 724
499 |  |  |  | 316
556 |  |  |  | 503
557 |  |  |  | 307
558 |  |  |  | 230
559 |  |  |  | 621
566 |  |  |  | 042
577 |  |  |  | 123
588 |  |  |  | 386
599 |  |  |  | 879
667 |  |  |  | 440
668 |  |  |  | 857
669 |  |  |  | 798
677 |  |  |  | 795
688 |  |  |  | 732
699 |  |  |  | 075
778 |  |  |  | 412
779 |  |  |  | 065
788 |  |  |  | 684
799 |  |  |  | 915
889 |  |  |  | 183
899 |  |  |  | 688
012 |  |  |  | 762
013 |  |  |  | 148
014 |  |  |  | 431
015 |  |  |  | 133
016 |  |  |  | 340
017 |  |  |  | 787
018 |  |  |  | 604
019 |  |  |  | 139
023 |  |  |  | 776
024 |  |  |  | 895
025 |  |  |  | 507
026 |  |  |  | 587
027 |  |  |  | 750
028 |  |  |  | 652
029 |  |  |  | 469
034 |  |  |  | 596
035 |  |  |  | 578
036 |  |  |  | 895
037 |  |  |  | 104
038 |  |  |  | 303
039 |  |  |  | 155
045 |  |  |  | 304
046 |  |  |  | 318
047 |  |  |  | 013
048
049
056
057
058
059
067
068
069
078
079
089
123
124
125
126
127
128
129
134
135
136
137
138
139
145
146
147
148
149
156
157
158
159
167
168
169
178
179
189
234
235
236
237
238
239
245
246
247
248
249
256
257
258
259
267
268
269
278
279
289
345
346
347
348
349
356
357
358
359
367
368
369
378
379
389
456
457
458
459
467
468
469
478
479
489
567
568
569
578
579
589
678
679
689
789
Spreadsheet: a47a13cd-12d7-4cfe-891a-1a7d7e15aa7a
Sheet: Statistics

Experiments Statistics
Entity | Counts
Experiments | 3290
Records in experiment-2-gene | 407000
Antibodies | 1796
Antigens (Baits) | 1083
Antibodies with redundent antigen targets | 419
Antigenes used in more than one experiments | 25
Records in antibody-2-gene (ab2gene) | 315245
Total Gene products | 11485
Gene products recovered in 1 antibody IP (non-reciprocal) | 3666
Gene products recovered in 2-4 antibodies (low reciprocal occurences) | 3271
Gene products recovered in 5-10 antibodies | 1708
Gene products recovered in 10-20 antibodies | 931
Gene products recovered in  >20 antibodies | 1909
Non-specific proteins (Blacklist) | 290
Spreadsheet: drew_fossum__8711__redrock n
Sheet: INPUT SHEET

[NAME]
Project Name | Mainline Expansion |  |  |  | NOT TO BE FILED
 | Amount
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
Capital   Investments
Compression   Facilities |  |  |  |  |  |  |  | 0
Town Border Stations
Main Line Extension | 93300000
Pipeline  Tie Over
Branch Line Loops
Total Additions
Less: Plant Retired | -30800000
Months in Service Year 1 | 12
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
O&M Costs | -739000
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10
Revenues
Ad Valorem Tax Rate | 0.016
 |  |  |  |  | Total Revenues
 |  |  |  |  | Total O&M Costs
Spreadsheet: 33cb6234-729f-4ffa-863a-ee5f80e51ee5
Sheet: Sheet1

Last updated: 9/29/14
Student October Valid Code Combinations |  |  | Valid Combinations for BOCES
Attendance/Residence Code | Public School Finance Act Funding Status Code |  | Attendance/Residence Code | Public School Finance Act Funding Status Code
01 | 80, 81, 82, 83, 84, 85, 86, 87, 89, 91, 92, 94, 95, 96 |  | 02 | 87
02 | 80, 81, 82, 83, 84, 85, 86, 87, 89, 91, 92, 94, 95, 96 |  | 04 | 87
03 | 80, 81, 82, 83, 84, 85, 86, 87, 91, 92, 94, 95, 96
04 | 80, 81, 82, 83, 84, 85, 86, 87, 89, 91, 92, 94, 95, 96
05 | 80, 82, 86, 87 |  | Valid Combinations for CPP
08 | 80, 82, 86 |  | Grade Level | Public School Finance Act Funding Status Code
24 | 80, 82, 86, 91, 92, 94, 95 |  | 004 | 81, 83, 89
27 | 80, 81, 82, 83, 84, 86, 89, 91, 92, 94, 95
28 | 80, 82, 86, 91, 92, 94, 95
29 | 80, 82, 86,91, 92, 94, 95 |  | Valid Combinations for On-Line Funding
30 | 80, 81, 82, 83, 84, 86, 89, 91, 92, 94, 95 |  | Grade Level | Public School Finance Act Funding Status Code
31 | 80, 81, 82, 83, 84, 86, 89, 91, 92, 94, 95 |  | 006-007 | 94, 95, 96
33 | 92 |  | 010 | 91, 92,94, 96
Grade Level | Public School Finance Act Funding Status Code |  | 020 - 120 | 91, 92, 94, 95, 96
004 | 81, 83, 84, 86, 87, 89
006 | 82, 85, 86, 87, 94, 95, 96
007 | 81, 82, 83, 85, 86, 87, 94, 95, 96
Spreadsheet: kay_mann__19218__Schedule
Sheet: Sheet1

 |  | 2001-02-21 00:00:00 | 2001-02-22 00:00:00 | 2001-02-23 00:00:00 | 2001-02-26 00:00:00 | 2001-02-27 00:00:00 | 2001-02-28 00:00:00 | 2001-03-01 00:00:00 | 2001-03-02 00:00:00 | 2001-03-05 00:00:00 | 2001-03-06 00:00:00 | 2001-03-07 00:00:00 | 2001-03-08 00:00:00 | 2001-03-09 00:00:00
 | [NAME]
 | H Freedman
 | L Henneberry
 | S Losi | OK | OK | OK | OK | OK | OK | OK | OK | No | No | No | No | No
 | L Mahon
 | [NAME]
 | J Mesko
 | J Rolfes
 | R White
Spreadsheet: 25249d1216390892-advanced-filter-question-copy1-2-tool
Sheet: Sheet1

 |  |  |  |  | TOOL
INPUTS
AD |  |  |  | 100 |  | B | Br
B | S | BR | QT | ab | cd | ef | gh | hj | jk | lo | pi | pr | hr | hc | ar | ac | le | lc | ad | ac | lr | lc
BR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
Spreadsheet: 877943d1724871245-i-need-help-with-a-formula-for-inventory-management-sample2-pivot
Sheet: Form Input

Timestamp | [NAME] | Inventory Action | Job Name | PVC - 4" [10 ft Length]
8/27/2024 8:27:38 | george | Checking Out | shop | 1
8/27/2024 8:26:38 | george | Checking Out | Shop | 2
8/27/2024 8:33:43 | george | Checking In | shop | 1
8/27/2024 9:29:21 | george | Checking Out | shop
8/27/2024 9:37:46 | george | Checking In | shop
Spreadsheet: 878704d1725960407-excel-time-sheet-needs-to-work-out-hours-but-take-off-30-mins-if-a-break-was-taken-gss-labour-sheet
Sheet: Weekly

Attention: - SUTTI / MARTIN / DANNY |  |  |  | Date-: Sat 7th Sept 2024
[NAME] To :-  AHLMARK SHIPPING (UK) Ltd
Vessel / Job =
*- Crane Driver Always No.1 - If No Crane Driver Ordered Leave No.1 Empty
Men | Name | Start | Finish | Break | Total Hrs | O/T Hrs | [NAME]
1
2 | J SYLVESTER | 05:00:00 | 19:00:00 | Y | 13.5 | 02:00:00
3 | M [NAME] | 06:00:00 | 14:30:00 |  | 8.5
4 | T SMITH | 06:00:00 | 14:30:00 |  | 8.5
5 | E GRAY | 06:00:00 | 14:30:00 |  | 8.5
6 | N PARKER | 06:00:00 | 14:30:00 |  | 8.5
7 | J SAINSBURY | 06:00:00 | 14:30:00 |  | 8.5
8 | L ZEIMSKI | 06:00:00 | 14:30:00 |  | 8.5
9 | N SHIPLEY | 06:00:00 | 14:30:00 |  | 8.5
10 | S NICHOLLS | 06:00:00 | 14:30:00 |  | 8.5
11 |  |  |  |  | 0
12 |  |  |  |  | 0
13 |  |  |  |  | 0
14 |  |  |  |  | 0
15 |  |  |  |  | 0
16 |  |  |  |  | 0
17 |  |  |  |  | 0
18 |  |  |  |  | 0
19 |  |  |  |  | 0
20 |  |  |  |  | 0
21 |  |  |  |  | 0
22 |  |  |  |  | 0
 | Goole Men Travel | 2
 |  |  |  | Total Hrs | 81.5
 | Costs For Invoicing | Normal Hrs | Over Time
 | [NAME] | 0 | 0 | 0
 | Stevedores | 1518.345 | 1.787499999999999 | 28286.76735
 | Travel | 2 |  | 20
Please Sign and E-Mail Back To:                                                                     [EMAIL]; [EMAIL]; [NAME] |  |  |  | Total | 28306.76735
Signed:
Spreadsheet: 0a0fbe0a-6c9f-47e7-9fa4-ebc6d91b3cf0
Sheet: Provider Training

PROVIDER TRAINING
List each training separately using the same title as the corresponding training form provided for inclusion in the management plan.
Travel and transportation costs for daycare home providers are not allowable administrative costs to CACFP.
Date(s) of Training | Provider Training Title and Description | Cost Facility Rental | Cost Training Supplies | Cost Equipment | Cost Registation Fees | Cost  Milage | Cost Lodging | Cost Meals | Cost Other | Total Cost Provider Training | % Allocated to CACFP | Total Cost to CACFP
 |  | 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 | 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 |  | 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 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Total Provider Training
Spreadsheet: e54904e3-6734-4ffb-96f6-a8c18b36bd34
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 859219001694 | My Destiny Place | Let Us Entertain You / Never Give Up | 2011-04-19 | DVD | Children | 9.95 | Y | Available
Taseis | 859219001595 | My Destiny Place | Imagine This / Believe In You | 2011-04-19 | DVD | Children | 9.95 | Y | Available
Taseis | 859219001793 | My Destiny Place | Practice, Practice, Practice! [NAME] | 2011-06-21 | DVD | Children | 9.95 | Y | Available
Spreadsheet: 267652d1380131136-how-to-calculate-what-week-in-a-program-and-a-look-up-to-return-a-value-based-on-week-vlookup-for-karryan
Sheet: Data File

Start Date | Week in  Program | Location | ID | JOB [NAME] | Hours
2013-09-09 00:00:00 | 3 | 04522 | SO00297 |  | 3.5 | Sample of what I'd like returned based on today's date 9/23.  Report is sent in every Friday for update the following week.
2013-09-16 00:00:00 | 2 | 04522 | SO00297 |  | 0
2013-09-09 00:00:00 | 3 | 03022 | EB00510 |  | 3.5
2013-09-09 00:00:00 | 3 | 07432 | MY00142 |  | 3.5
2013-09-09 00:00:00 | 3 | 00322 | JM00232 |  | 3.5
2013-09-09 00:00:00 | 3 | 02122 | DI00103 |  | 3.5
2013-09-09 00:00:00 | 3 | 04342 | SP01347 |  | 3.5
2013-09-09 00:00:00 | 3 | 04962 | AA00895 |  | 3.5
2013-09-09 00:00:00 | 3 | 01452 | RM01205 |  | 3.5
2013-09-09 00:00:00 | 3 | 01652 | NZ00033 |  | 3.5
2013-09-16 00:00:00 | 2 | 08152 | JI00091 |  | 0
2013-09-16 00:00:00 | 2 | 01062 | YG00076 |  | 0
2013-09-16 00:00:00 | 2 | 05522 | RB1045 |  | 0
2013-09-16 00:00:00 | 2 | 05162 | MK00863 |  | 0
2013-09-16 00:00:00 | 2 | 04762 | MO00371 |  | 0
2013-09-16 00:00:00 | 2 | 04592 | GH00351 |  | 0
2013-09-23 00:00:00 | 1 | 04242 | KJ00348 |  | 0
2013-09-23 00:00:00 | 1 | 09432 | XL00050 |  | 0
2013-09-23 00:00:00 | 1 | 00842 | SG01016 |  | 0
2013-09-23 00:00:00 | 1 | 06742 | SS01753 |  | 0
2013-09-23 00:00:00 | 1 | 09522 | PN00191 |  | 0
Spreadsheet: 648141d1572893100-same-if-function-on-1-page-test_2-week_positioncontrol-copy
Sheet: S2

 | 1. Sun | 1. Mon | 1. Tue | 1. Wed | 1. Thu | 1. Fri | 1. Sat | 1. Sun | 1. Mon | 1. Tue | 1. Wed | 1. Thu | 1. Fri | 1. Sat
 | PM Employees
Spreadsheet: 846261d1697534212-vlookup-with-multiple-conditions-example-issue
Sheet: Sections

Size | Material | Length ([NAME]) | Weight (kg)
100x100x10 | RSA | 1000
100x100x10 | RSA | 1000
100x100x10 | RSA | 1000
100x100x10 | SHS | 1000
100x100x10 | SHS | 1000
Spreadsheet: 0fb7e9cc-8e01-430a-a940-c73492e37235
Sheet: Collection Roles

Collection Roles
Use this template to define the collection roles using existing Data Pipeline roles or custom roles if needed
ID | Role | Applies to Collection | Responsibility
1 | CDE Data Governor | N
2 | CDE Admin | Y | Can see and edit LEA data, can upload vendor file
3 | CDE Collection Steward | Y | Can see LEA data.
4 | [NAME] | Y | Can edit and approve data, can upload READ file
5 | [NAME] | Y | LEA collection coordinator  responsible for editing data and uploading READ file
6 | [NAME] | Y | Can view LEA data.
Spreadsheet: 80447d1280670126-automatic-updating-sample-workbook-complete-
Sheet: Sheet1

BDE PERSTAT
Spreadsheet: 52526d1252345487-excel-not-working-correctly-lsakjfbsaflkjalfbads
Sheet: Sheet1

LOYALTY PROGRAM STRATEGY
Value of Customer Without Rewards
Average Ticket Size | 20
Average Customer Visits | 6
Total
Value of Customer With Rewards
Rewards will increase the average spending by 25% and visits by 20%
Average Ticket Size
Average Customer Visits
Total
Increase Per Customer
Strategy: Branding Qualified Customers
Number of Customers Per Month | 1500
Percent of Customer Who Qualify For Rewards | 0.4
New Branded Customers
New Revenue From One Extra Visit Per Month
Spreadsheet: 544348d1508863636-format-time-excel-formatting
Sheet: Sheet1

#Pipe - Time (DD.MM.YYYY) | Pipe - Time (HHMMSS.ss) | Pipe - Easting | Pipe - Northing | Pipe - KP | Rov - Distance to Runline | Pipe - Depth | LeftSeabedOuter - Depth | RightSeabedOuter - Depth
23.10.2017 | 161036 | 442017.367 | 6073629.449 | 2.473 | -0.495 | 33.09 | 33.24 | 33.47
23.10.2017 | 161022 | 442016.558 | 6073630.044 | 2.474 | -0.377 | 33.71 | 33.267 | 33.46
23.10.2017 | 161008 | 442015.748 | 6073630.639 | 2.475 | -0.209 | 33.79 | 33.3 | 33.47
23.10.2017 | 161059 | 442015.038 | 6073631.37 | 2.476 | -0.11 | 33.558 | 33.287 | 33.421
23.10.2017 | 161051 | 442014.297 | 6073632.058 | 2.477 | -0.092 | 33.6 | 33.3 | 33.423
23.10.2017 | 161041 | 442013.556 | 6073632.746 | 2.478 | -0.016 | 33.644 | 33.31 | 33.274
23.10.2017 | 161028 | 442012.815 | 6073633.435 | 2.479 | 0.318 | 33.687 | 33.322 | 33.4
23.10.2017 | 161002 | 442012.075 | 6073634.124 | 2.48 | 0.479 | 33.732 | 33.4 | 33.296
23.10.2017 | 161032 | 442011.335 | 6073634.815 | 2.481 | 0.67 | 33.777 | 33.3 | 33.038
23.10.2017 | 161002 | 442010.596 | 6073635.506 | 2.482 | 0.235 | 33.824 | 33.251 | 33.19
23.10.2017 | 161030 | 442009.858 | 6073636.198 | 2.483 | 0.486 | 33.871 | 33.33 | 33.08
23.10.2017 | 161022 | 442009.119 | 6073636.889 | 2.484 | 0.703 | 33.918 | 33.364 | 33.225
23.10.2017 | 161016 | 442008.38 | 6073637.581 | 2.485 | 0.925 | 33.966 | 33.347 | 33.25
23.10.2017 | 161006 | 442007.642 | 6073638.273 | 2.486 | 1.142 | 34.014 | 33.37 | 33.347
23.10.2017 | 161039 | 442006.904 | 6073638.965 | 2.487 | 1.72 | 34.062 | 33.377 | 33.341
23.10.2017 | 161028 | 442006.165 | 6073639.656 | 2.488 | 2.058 | 34.111 | 33.36 | 33.42
23.10.2017 | 161019 | 442005.425 | 6073640.347 | 2.489 | 2.119 | 34.16 | 33.32 | 33.38
23.10.2017 | 161013 | 442004.685 | 6073641.036 | 2.49 | 2.237 | 34.208 | 33.297 | 33.391
23.10.2017 | 161007 | 442003.944 | 6073641.724 | 2.491 | 2.269 | 34.256 | 33.27 | 33.375
23.10.2017 | 161001 | 442003.202 | 6073642.412 | 2.492 | 2.373 | 34.303 | 33.29 | 33.44
23.10.2017 | 161050 | 442002.459 | 6073643.097 | 2.493 | 2.412 | 34.35 | 33.36 | 33.4
23.10.2017 | 161041 | 442001.715 | 6073643.782 | 2.494 | 2.435 | 34.396 | 33.35 | 33.47
23.10.2017 | 161033 | 442000.97 | 6073644.465 | 2.495 | 2.499 | 34.442 | 33.377 | 33.51
23.10.2017 | 161026 | 442000.224 | 6073645.147 | 2.496 | 2.625 | 34.487 | 33.4 | 33.499
23.10.2017 | 161018 | 441999.478 | 6073645.828 | 2.497 | 2.669 | 34.53 | 33.37 | 33.51
23.10.2017 | 161002 | 441998.73 | 6073646.507 | 2.498 | 2.64 | 34.572 | 33.38 | 33.51
23.10.2017 | 161038 | 441997.981 | 6073647.185 | 2.499 | 2.624 | 34.613 | 33.39 | 33.51
23.10.2017 | 161022 | 441997.41 | 6073647.701 | 2.5 | 2.861 | 34.643 | 33.405 | 33.49
23.10.2017 | 161015 | 441996.719 | 6073648.323 | 2.501 | 2.907 | 34.677 | 33.44 | 33.482
Spreadsheet: 234669d1368161041-stop-insert-row-from-changing-functions-new-register
Sheet: Transmittal All (2)

PROJECT NUMBER:
PROJECT NAME:
 |  |  |  |  |  | A.B.N. 81 010 761 378
 |  |  |  |  | REVISION DATES
[NAME]
 |  | HARDCOPIES
 |  | SOFTCOPIES
 |  | HARDCOPIES
 |  | SOFTCOPIES
 |  | HARDCOPIES
 |  | SOFTCOPIES
[NAME] | SOFTCOPY
# = Number of copies | D = AUTOCAD DRAWING FORMAT (.DWG)
 | E = EMAIL
 | P = PDF FORMAT |  |  |  | REVISION HISTORY
 | U = UPLOAD
DRAWING TITLE | NUMBER | CURRENT STATUS
 | M13666-H-L00-101
SPECIFICATIONS / CERTIFICATE / OTHER | NUMBER | CURRENT STATUS
Spreadsheet: 845713d1697104398-index-of-non-empty-cells-match-input-with-pool-of-texts-or-word-bank-excelforum3
Sheet: Sheet1

 |  | Companies | Emps | Hrs. |  |  |  |  |  | Company List name | Word Bank
 |  | Company1 | 1 | 348 |  |  |  |  |  | Company1 | Company   1 | Company1 | 1 -Company 1 | Company 1- | 1 -Company
 |  | Company-2 | 1 | 299 |  |  |  |  |  | Company2 | Company 2 | Company-2
 |  | Company   1 | 3 | 884 |  |  |  |  |  | Company3 | 3- Company3 | Company-3
 |  | Company4- | 3 | 936 |  |  |  |  |  | Company4 | Company4- | Company4 | [NAME]
 |  | Company1 | 64 | 5421
 |  | Company3
 |  | Company4 | 5 | 1058
 |  | 1 -Company 1 | 1 | 966
 |  | Company 1- | 1 | 314
 |  | [NAME] | 64 | 14416
 |  | Company2 | 8 | 2444
 |  | 1 -Company | 1 | 216
 |  | 3- Company3
 |  | Company-3
 |  | Company 2 | 10 | 999
 |  |  |  |  |  | Required Output Table
 |  |  |  |  |  | Companies | Emps | Total Hrs. |  |  |  |  |  | Emps | Hrs.
 |  |  |  |  |  | Company1 |  |  |  |  |  |  | Company1 | 71 | 8149
 |  |  |  |  |  | Company2 |  |  |  |  |  |  | Company2 | 19 | 3742
 |  |  |  |  |  | Company4 |  |  |  |  |  |  | Company3 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | Company4 | 72 | 16410
Spreadsheet: 54516d1254499448-excel-2007-pool-league-average-scores-rail-runners
Sheet: Sheet1

Week | Date | Name | Game 1 | Game 2 | Game 3 | Total | Average
1 | 2009-09-17 00:00:00 | [NAME] | 10 | 10 | 6 | 26 | 8.666666666666666
 |  | [NAME] | 6 | 10 | 10 | 26 | 8.666666666666666
 |  | Leonard | 10 | 10 | 10 | 30 | 10
 |  | [NAME] | 10 | 7 | 10 | 27 | 9
 |  | [NAME] | 10 | 10 | 7 | 27 | 9
2 | 2009-09-24 00:00:00 | [NAME] | 10 | 10 | 10 | 30
 |  | [NAME] | 10 | 8 | 6 | 24
 |  | Leonard | 10 | 10 | 4 | 24
 |  | [NAME] | 10 | 10 | 4 | 24
 |  | [NAME] | 10 | 10 | 6 | 26
3 | 2009-10-01 00:00:00 | [NAME] | 10 | 10 | 10 | 30
 |  | [NAME] | 7 | 10 | 7 | 24
 |  | Leonard | 10 | 6 | 10 | 26
 |  | [NAME] | 5 | 10 | 10 | 25
 |  | [NAME] | 10 | 6 | 10 | 26
4 | 2009-10-08 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
5 | 2009-10-15 00:00:00 | [NAME]
 |  | [NAME]
 |  | Leonard
 |  | [NAME]
 |  | [NAME]
6 | 2009-10-22 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
7 | 2009-10-29 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
8 | 2009-11-05 00:00:00 | Leonard
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 756538d1637619052-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: November 22

 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED
 | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 | 2021-11-14 00:00:00 | 2021-11-15 00:00:00 | 2021-11-16 00:00:00 | 2021-11-17 00:00:00 | 2021-11-18 00:00:00 | 2021-11-19 00:00:00 | 2021-11-20 00:00:00 | 2021-11-21 00:00:00 | 2021-11-22 00:00:00 | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | 2021-11-25 00:00:00 | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED
 | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 | 2021-11-14 00:00:00 | 2021-11-15 00:00:00 | 2021-11-16 00:00:00 | 2021-11-17 00:00:00 | 2021-11-18 00:00:00 | 2021-11-19 00:00:00 | 2021-11-20 00:00:00 | 2021-11-21 00:00:00 | 2021-11-22 00:00:00 | 2021-11-23 00:00:00 | 2021-11-24 00:00:00 | 2021-11-25 00:00:00 | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 859599d1707927650-by-group-subtotal-groupby-sample-data-gk-
Sheet: Result

 |  | Account Name | Site | Core | Spend
 | ABC123 | The ABC Company | North | Non-Core | 6066.76
 | ABC123 | The ABC Company | North | Core | 69.41999999999999
 | Subtotal North |  |  |  | 6136.180000000001
 | ABC123 | The ABC Company | South | Non-Core | 38.51000000000001
 | ABC123 | The ABC Company | South | Core | 476.71
 | Subtotal South |  |  |  | 515.22
 | ABC123 | The ABC Company | East | Non-Core | 387.64
 | ABC123 | The ABC Company | East | Core | 85.61
 | Subtotal East |  |  |  | 473.25
 | ABC123 | The ABC Company | West | Core | 162.17
 | ABC123 | The ABC Company | West | Non-Core | 266.86
 | Subtotal West |  |  |  | 429.0300000000001
 | Grand Total |  |  |  | 7553.680000000005
Spreadsheet: 74646d1275149546-changing-columns-to-rows-without-copy-and-paste-consolidatecounties
Sheet: Sheet1

Vendor # | [NAME] | County | State
22213 | [NAME] | Montgomery | MD
13432 | [NAME] | [NAME] | MD
23421 | [NAME] | [NAME] | MD
21312 | [NAME] | Arlington | VA
22213 | [NAME] | [NAME] | VA
13432 | [NAME] | Fairfax | VA
23421 | [NAME] | [NAME] | VA
13432 | [NAME] | Montgomery | MD
 |  |  |  |  |  | Press Alt-F8 and select CONSOLIDATE from the macro list