tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75198d1275730704-if-formula-ifelse-v2
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Helper |  |  |  |  |  |  | February | 2
 |  |  |  |  |  | IDEA ADVANCE PLANNING TOOL |  |  |  |  |  |  |  |  |  |  |  | Column | month | week | next ordering date |  |  |  | March | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | June | 1 | 1st july |  |  |  | April | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | June2 | June | 2 | 3nd july |  |  |  | May
 |  |  |  |  |  | Select Month |  | June |  |  |  |  |  |  |  |  |  | [NAME] | June | 3 | 8th july |  |  |  | June
 |  |  |  |  |  | Select Week |  | 4 |  |  |  |  |  |  |  |  |  | June4 | June | 4 | 2010-07-06 00:00:00 |  |  |  | July
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
 |  |  |  |  |  | next ordering date |  | 2010-07-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | November
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | December
Spreadsheet: 868528d1715248095-very-complicated-sum-function-testing-ans3
Sheet: Sheet1

EVENT 1 |  | Total of | AR | APC |  | STATE 1 |  | STATE 2 |  | STATE 3 |  | STATE 4 |  | STATE 5 |  | STATE 6 |  | AP1 |  | AP2 |  | AP3 |  | AP4 |  | AR1 |  | AR2 |  | AR3 |  | AR4 |  | AR5 |  | AR6 |  | AR7 |  | AR8 |  | AR9 |  | AR10 |  | AR11 |  | AR12 |  | AR13 |  | AR14
 |  | best six | current |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | River City Classic |  | Mooloolabah
 |  | AR points | RANK | Oct |  | April |  | March |  | March |  | April |  | May |  | June |  | Oct |  | May |  | Sept |  | Nov |  | June |  | July |  | June |  |  |  | Sept |  | Sept |  | April |  | May
 | Weighting                  No of players/teams |  |  | 1 |  | 0.5 | NO | 0.5 | 8 | 0.5 | 5 | 0.5 |  | 0.5 |  | 0.5 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25
Last Name | Full Name |  |  | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts
 | =F7+J7+P7+T7+V7+AF7 |  |  |  |  | NO EVENT |  |  |  | SmallEvent |  | SmallEvent
NAME | FULL NAME |  |  |  | 100 |  | 300 |  | 400 |  | 200 | 1 | 250 |  | 300 |  | 100 | 1 | 750 |  | 500 |  | 400 |  |  |  | 250 |  | 100 |  | 300
NAME | FULL NAME | 1500 |  |  | 300 |  | 100 |  | 200 |  | 100 | 1 | 300 |  |  |  |  | 2 | 300 |  | 300 |  | 300 |  |  |  | 100 |  | 100 |  | 100
NAME | FULL NAME | 750 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 750
NAME | FULL NAME | 600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 600
NAME | FULL NAME | 500 |  |  |  |  |  | 1 | 500
NAME | FULL NAME | 500 |  |  |  |  |  | 1 | 500
 |  |  |  |  | 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 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49
 |  | =BYROW(IF($F$5:$BB$5="Pts",$F$7:$BB$12,0),LAMBDA(a,TAKE(a,1,1)+SUM(Drop(LARGE(Take(a,1,13),,1),ROW($1:$2)))))
Spreadsheet: 349371d1412288296-need-formula-to-copy-data-from-sheet-2-onto-sheet-1-every-9th-row
Sheet: Sheet2

 |  | 967
 |  | 790
 |  | 407
 |  | 592
 |  | 333
 |  | 882
 |  | 27
 |  | 86
 |  | 910
 |  | 577
 |  | 261
 |  | 752
 |  | 568
 |  | 741
 |  | 221
 |  | 535
 |  | 213
 |  | 694
 |  | 216
 |  | 662
 |  | 509
 |  | 661
 |  | 935
 |  | 777
 |  | 331
 |  | 355
 |  | 77
 |  | 209
 |  | 421
 |  | 420
 |  | 439
 |  | 816
 |  | 616
 |  | 286
 |  | 450
 |  | 542
 |  | 379
 |  | 610
 |  | 523
 |  | 56
 |  | 252
 |  | 669
 |  | 301
 |  | 705
 |  | 504
 |  | 480
 |  | 504
 |  | 808
 |  | 470
 |  | 846
 |  | 557
 |  | 864
 |  | 187
 |  | 98
 |  | 699
 |  | 176
 |  | 476
 |  | 459
 |  | 548
 |  | 167
 |  | 549
 |  | 67
 |  | 94
 |  | 255
 |  | 939
 |  | 415
 |  | 733
 |  | 41
 |  | 34
 |  | 326
 |  | 818
 |  | 634
 |  | 560
 |  | 978
 |  | 951
 |  | 126
 |  | 502
 |  | 550
 |  | 459
 |  | 536
 |  | 332
 |  | 673
 |  | 272
 |  | 482
 |  | 452
 |  | 54
 |  | 715
 |  | 656
 |  | 923
 |  | 991
 |  | 795
 |  | 278
 |  | 500
 |  | 599
 |  | 358
 |  | 502
 |  | 47
 |  | 299
 |  | 250
 |  | 868
 |  | 307
 |  | 171
 |  | 868
 |  | 345
 |  | 519
 |  | 860
 |  | 729
 |  | 396
 |  | 142
 |  | 127
 |  | 209
 |  | 163
 |  | 472
 |  | 285
 |  | 51
 |  | 693
 |  | 721
 |  | 330
 |  | 830
 |  | 128
 |  | 483
 |  | 298
 |  | 407
 |  | 589
 |  | 798
 |  | 3
 |  | 228
 |  | 873
 |  | 626
 |  | 487
 |  | 238
 |  | 452
 |  | 1000
 |  | 956
 |  | 757
 |  | 957
 |  | 882
 |  | 567
 |  | 915
 |  | 766
 |  | 884
 |  | 785
 |  | 531
 |  | 424
 |  | 187
 |  | 539
 |  | 251
 |  | 921
 |  | 294
 |  | 126
 |  | 314
 |  | 613
 |  | 666
 |  | 635
 |  | 506
 |  | 906
 |  | 978
 |  | 694
 |  | 46
 |  | 452
 |  | 515
 |  | 287
 |  | 425
 |  | 775
 |  | 931
 |  | 991
 |  | 561
 |  | 744
 |  | 413
 |  | 858
 |  | 848
 |  | 102
 |  | 691
 |  | 405
 |  | 622
 |  | 205
Spreadsheet: 752493d1634805147-partial-text-frequency-counting-in-reports-forum-sample-adenoma
Sheet: Sheet1

number | Report | Amount of adenomas | Amount of no adenomas
1 | Colonoscopy: biopsy performed 50 cm from anus. No polyp or adenoma. Tubulovillieus adenoma in biopsy 2. Biopsy 3 hyperplastic polyp. No adenoma.
2 | Fragemented hyperplastic polyp. No adenoma.
3 | Villieus adenoma in 1. No polyp. Biopsy 2 no polyp or adenoma. Biopsy 3 no adenoma or polyp
4 | I:  Tubular adenoma low grade dysplasia  II: biopsy 75 cm from anus: tubular adenoma low grade dysplasia III:  Tubular adenoma low grade dysplasia  IV:  Tubular adenoma low grade dysplasia  V: biopsy 60 cm from anus. No polyp or adenoma. VI: biopsy 50 cm from anus. hyperplastic polyp no adenoma.
5 | sessile laesion. 50 cm from anus
6 | [NAME] from anus. Adenocarcinoma, no other polyps
7 | I:  Tubular adenoma low grade dysplasia  II: no polyp or adenoma III:  adenoma undefined IV: hyper plastic polyp, no adenoma
8 | tubulovillieus adenoma in 1. Hyperplastic polyp in 2, no adenoma. No polyp or adenoma in 4.
9 | Infectious activity in 1
10 | I:  [NAME] biopsy coecum: tubulovillieus adenoma with low grade dysplasia. II: Polypectomy: tubular adenoma low [NAME]. Diamiter polyp 0,5 cm  III: Polypectomy 80 cm from anus. Tubulovilieus adenoma low [NAME]; diameter polyp 1,5cm. IV:  [NAME] membrane: No abnormalities (no polyp or adenoma)
Spreadsheet: 207152-looking-for-right-formulas-to-link-data-example
Sheet: Job 1

 |  | Sub |  | Date |  | Ticket # | FT/GAL |  | INSPECTIONS |  |  |  | DATE |  | Con.# | Job #:
Well/Water: |  |  |  |  |  |  |  |  | Rough Grade: |  |  |  |  |  |  | Operator:
Septic/Sewer: |  |  |  |  |  |  |  |  | Open Hole: |  |  |  |  |  |  | Address:
Saw Cutting: |  |  |  |  |  |  |  |  | Lateral: |  |  |  |  |  |  | Building:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bld. SF
Month | Date | Loads | Product | Gross | Tare | Deduct | Net | [NAME] | Landfill | Driver | Truck # | Driver Tic. # | Dump Fee | DF $/Ton | Tic. $/Load | Total @ | Total $/Ton | L.F. Ticket # | CK
Spreadsheet: 873668d1720181150-if-function-with-sumifs-if-statement-and-sumif-actual-and-forecast
Sheet: Result

 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | YTD Total
Financial Year |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL | FORECAST
Cost 1
Cost 2
Cost 3
Cost 4
Cost 5
Cost 6
Cost 7
Cost 8
Cost 9
Total
Exepected Results
 | ACTUAL | ACTUAL | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | FORECAST | Total
Cost 1 | 10000 |  | 0 |  | 18000 |  | 25000 |  | 25000
Cost 2
Cost 3
Cost 4
Cost 5 |  | 28000 |  |  | 12000 |  |  | 63000
Cost 6
Cost 7
Cost 8
Cost 9
Total
HI team
Could someone please assist to help me pull through the actual or forecast for specific  month on my expected result-so at any time when the actual or forecast changes by moving the cell from the source data my result tab will update
On the if statement formular my value if criteria should only pick the sum of forecast for specific month if it is not actual.
Actual spend todate
Forecast remaining to spend
Spreadsheet: 37093d1235050095-calculating-sum-of-relative-cells-meds
Sheet: Sheet2

ID | SUM fddd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 808523d1670506929-formula-to-extend-to-next-day-in-an-excel-table-table-extend-formula-ans
Sheet: Sheet1

Date | Total Required | Total installed up to date | in percent | up to 26-Oct-22 | 27/10/2022 | 28/10/2022 | 28/10/2023 | 28-10-2024
Item1 |  |  |  | 289066 | 0 |  |  | 100 |  | Last column I added for test purpose
Item2 | 57325.19 |  |  | 57164.25 | 7.53 | 15.06 | 20.25 | 200
Item3 | 58591.63 |  |  | 48480.47 | 0 |  |  | 300
Item4 | 145002.12 |  |  | 144780.06 | 0 |  |  | 400
Item5 | 162708.72 |  |  | 123461.49 | 1136.1 | 1216.3 | 1234 | 500
Item6 |  |  |  | 21486 | 0 |  |  | 600
Item7 | 144926.7 |  |  | 142176.7 | 331.28 |  | 123.45 | 700
Item8 | 37852.11 |  |  | 19023.71 | 0 |  |  | 800
Item9 | 23832.43 |  |  | 12463.03 | 137.66 | 181.2 | 234.56 | 900
Total |  |  |  |  |  |  | 1987.56 | 1000
 |  | This is the current [NAME] in Col C
 |  | =SUM(Table1[@[up to 26-Oct-22]:[28/10/2022]]) |  |  |  |  | This does not gets inclued
 |  |  |  |  |  |  | in the SUM Function
 |  |  |  |  |  |  | in Column C
Spreadsheet: 240436d1370326644-print-sheet-calculator-papercalc-v5
Sheet: Quote

 |  |  |  |  |  |  |  |  |  | Size | Height | [NAME]
 | Paper Product | Height | [NAME] |  |  |  |  | Quantity |  | Custom
 | Custom |  |  |  |  |  |  | 10 | Input Quantity | DL | 99 | 210
 |  | 120 | 100 |  |  |  |  |  |  | DLE | 110 | 220
Set | Bleed | 3 |  |  |  |  |  |  |  | F4 | 210 | 330
 | New dimensions |  |  |  |  |  |  |  |  | RA0 | 841 | 189
 | Gutter? |  |  |  |  |  |  |  |  | RA1 | 610 | 860
 | Total required Area |  |  |  |  |  |  |  |  | RA2 | 430 | 610
 |  |  |  |  |  |  |  |  |  | RA3 | 305 | 430
 |  | Landscape |  |  | Portrait |  |  |  |  | RA4 | 215 | 305
 | Paper Source | Height | [NAME] |  | Height | [NAME] |  | Required |  | SRA0 | 900 | 280
 | SRA3 |  |  |  |  |  |  |  | Answer | SRA1 | 640 | 900
Set | [NAME] | 5 |  |  |  |  |  |  |  | SRA2 | 450 | 640
 | Effective edge |  |  |  |  |  |  |  |  | SRA3 | 320 | 450
 | Total usable area |  |  |  |  |  |  |  |  | SRA4 | 225 | 320
 |  |  |  |  |  |  |  |  |  | A3+ | 329 | 483
 | Theoritical pieces per Sheet
 | [NAME] |  |  |  |  |  |  |  |  | Paper Source | Height | [NAME]
 | Actual Maximum per sheet |  |  |  |  |  |  |  |  | SRA3 | 320 | 450
 |  |  |  |  |  |  |  |  |  | A3 | 297 | 420
 | Best Solution |  |  |  |  |  |  |  |  | A4 | 210 | 297
Spreadsheet: 03948d8c-ae6c-4baa-8ddc-0f30f4918171
Sheet: Asset Detail

Forward Capacity Market Net Supply Credit Detail Report
SD_FCMNSCDTL_<customer id>_<settlement_date>_<version>.CSV
<[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Resource ID | Resource Name | Asset ID | Asset Name | Asset Type | Customer ID | Customer Name | Ownership Share
Number | String | Number | String | String | Number | String | %
Spreadsheet: 771588d1646747712-differences-between-values-it
Sheet: Filled vacancies

Filled vacancies
Region | 2016 | 2017 | 2018 | 2019 | 2020
North | 3276 | 3354 | 4056 | 4758 | 4056
West | 16766.4 | 17165.6 | 20758.4 | 24351.2 | 20758.4
South | 9668.4 | 9898.6 | 11970.4 | 14042.2 | 11970.4
East | 7349.999999999999 | 7524.999999999999 | 9100 | 10675 | 9100
Central | 4939.2 | 5056.8 | 6115.2 | 7173.599999999999 | 6115.2
TOTAL
Spreadsheet: 716405d1612197081-sum-values-with-criteria-sample
Sheet: PAYDAY 29th Apr

Week: | Hours: | Pay: | Notes: |  |  | Break Down: |  |  |  |  |  |  | WEEKLY PAY:
BASE PAY: |  | 1000 |  |  |  |  |  |  |  |  |  |  | 461.54
 |  |  |  |  |  | Natwest:
 |  |  |  |  |  | Entertainment:
 |  |  |  |  |  | Car:
[NAME]: |  | 0 |  |  |  | Loan:
 |  |  |  |  |  | Phone:
Est Tax: |  |  |  |  |  | Credit Improver:
Est NI: |  |  |  |  |  | Credit Card:
Total: |  |  |  |  |  | Total:
Total Est Pay Before Tax: |  |  |  |  |  | Monzo:
Total Est Pay After Tax: |  |  |  |  |  | Predicted: |  |  | Actual:
Actual Pay: |  |  |  |  |  | Amount L/O |  |  | Amount L/O
 |  |  |  |  |  | Days till next pay | 28 |  | Days till next pay | 28
Deductions: |  |  |  |  |  | Budget |  |  | Budget
Rent
Fuel |  | 40
Car Insurance |  | 181.68
Phone |  | 56.45
Loan |  | 130.08
Spotify |  | 4.99
Credit Improver |  | 12
Credit Card
Other
 |  |  |  |  |  | NI Calculator:
Budget:
 |  |  |  |  |  | PA: | 793.02
Total: |  |  |  |  |  | BT - PA:
Total Est Left On 28th May: |  |  |  |  |  | Total:
Total Acc Left On 28th May:
 |  |  |  |  |  | Tax Calculator:
 |  |  |  |  |  | PA: | 1046.65
 |  |  |  |  |  | BT - PA:
 |  |  |  |  |  | Est Tax:
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -48871 | -49601
2 | -49187 | -48829
3 | -103126 | -102275
4 | -123391 | -123241
5 | -36313 | -35878
6 | -49883 | -49878
7 | -66975 | -66878
8 | -71064 | -70456
9 | -40759 | -40774
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | -33241.41
2002-01-09 00:00:00
CBS Volume
 |  |  | -18079
Spreadsheet: 166255d1341509161-help-with-my-fantasy-result-prediction-spreadsheet-it-cant-work-out-0-0-scorelines-srs-result-predictor
Sheet: Results

Pos | Name | Pts |  | League name [NAME] | Pts | Pos
Spreadsheet: 737466d1624434254-how-to-extract-data-from-one-worksheet-into-another-excel-forum-workbook
Sheet: Worksheet 1

Worksheet 1
CompanyName | FirstName | Surname | JobTitle | [NAME] | Area | FileName | Verification
McDonalds | [NAME] | Smith | Director | [EMAIL] | North | ExcelWorkbook1
McDonalds | [NAME] | Jones | Director | [EMAIL] | North | ExcelWorkbook2
McDonalds | [NAME] | Greeb | Director | [EMAIL] | North | ExcelWorkbook3
Spreadsheet: 74eed2b4-f1aa-4998-8a1d-86d1ee82e1a0
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
[NAME] | Test | [NAME] | Cultivated Wheat, IgE | Cultivated Wheat, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top		 Acceptable: Serum gel				 Specimen Volume: 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
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
[NAME] | Result | [NAME] | Cultivated Wheat, IgE | Cultivated Wheat, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6277-8 | Triticum aestivum pollen Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: larry_campbell__20973__TOPOCK LATERAL SAMPLING
Sheet: PIGGING INFORMATION

 |  | FACILITY | FACILITY |  | VOLUME | VOLUME
DATE | TIME | INJECTION POINT | RECOVERY POINT | PIPELINE SOLVENT | INJECTED  (GAL) | RECOVERED (GAL)
1999-06-26 00:00:00 | 05:20:00 | PG&E M/S | GOLDEN SHORES | WATER | 500 | 0
1999-06-26 00:00:00 |  | PG&E M/S | GOLDEN SHORES | WATER | 1000 | <1
1999-06-26 00:00:00 |  | PG&E M/S | GOLDEN SHORES | WATER | 1000 | 1102
 |  |  |  |  | 2500 | 1102
1999-06-27 00:00:00 | 05:00:00 | PG&E M/S | GOLDEN SHORES | WATER | 2500 | 2572
1999-06-27 00:00:00 | 11:15:00 | PG&E M/S | GOLDEN SHORES | WATER | 1000 | 850
1999-06-27 00:00:00 | 14:30:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 0
1999-06-27 00:00:00 | 16:45:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 0
 |  |  |  |  | 4500 | 3422
1999-06-28 00:00:00 | 05:15:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 1324
1999-06-28 00:00:00 | 13:30:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 200
1999-06-28 00:00:00 | 16:28:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 2041
 |  |  |  |  | 3000 | 3565
1999-06-29 00:00:00 | 05:30:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 300
1999-06-29 00:00:00 | 08:30:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 306
1999-06-29 00:00:00 |  | PG&E M/S | GOLDEN SHORES | DRY | 0 | 0
1999-06-29 00:00:00 | 15:00:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 991
1999-06-29 00:00:00 | 17:01:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1000 | 490
 |  |  |  |  | 3000 | 2087
1999-06-30 00:00:00 | 07:15:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 100
1999-06-30 00:00:00 | 09:35:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 663
1999-06-30 00:00:00 | 12:30:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 20
1999-06-30 00:00:00 | 13:50:00 | PG&E M/S | GOLDEN SHORES | DIESEL | 1500 | 490
1999-06-30 00:00:00 | 18:30:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 195
1999-06-30 00:00:00 | 22:00:00 | PG&E M/S | GOLDEN SHORES | DRY | 0 | 430
1999-06-30 00:00:00 |  | GOLDEN SHORES | PG&E M/S | DRY | 0 | 7
 |  |  |  |  | 1500 | 1905
 |  |  |  | TOTALS | 14,500 GALLONS | 12,081 GALLONS
Spreadsheet: 883984d1732814887-predictive-scoring-formula-that-stabilises-over-time-performance-scoring-sheet-
Sheet: Sheet1

Team A |  | Team B |  | Winning margin
Defensive rating | Attacking rating | Defensive rating | Attacking rating | Predicted margin | Actual margin | Prediction quality
42.39999999999999 | 40 | 41.4 | 34.3 | 3.849999999999991 | -1
50.1 | 50.4 | 39.3 | 37.5 | 5 | 0
42.7 | 36.65000000000001 | 50.55 | 50.7 | 5 | 5
40.2 | 36.5 | 38.15000000000001 | 34.75 | 2.92499999999999 | 2
Spreadsheet: 868574d1715272297-records-processed-on-time-dates
Sheet: Sheet1

Record # | Date Received | Due Date | Date processed
1 | 2024-01-03 00:00:00 | 2024-01-06 00:00:00 | 2024-01-06 00:00:00
2 | 2024-01-10 00:00:00 | 2024-01-12 00:00:00 | 2024-01-12 00:00:00
3 | 2024-01-10 00:00:00 | 2024-01-15 00:00:00 | 2024-01-06 00:00:00
4 | 2024-01-14 00:00:00 | 2024-01-20 00:00:00 | 2024-01-19 00:00:00
5 | 2024-01-25 00:00:00 | 2024-01-29 00:00:00 | 2024-01-28 00:00:00
6 | 2024-02-04 00:00:00 | 2024-02-08 00:00:00 | 2024-02-06 00:00:00
7 | 2024-02-07 00:00:00 | 2024-02-13 00:00:00 | 2024-02-13 00:00:00
 | Month | 2024-01-24 00:00:00 | 2024-02-24 00:00:00
 | Records Received
 | Records processed on time
Spreadsheet: 143364d1330381793-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (9) Heat Treat

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | Heat Treat
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
1 | overhead lights out | mason storage area | complete
2 | window on crane needs replacing (poor visibility) | 509 Gantry | complete
3
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Overall housekeeping good; walkway needs to be marked near offices
ESCORT: | [NAME]
Spreadsheet: 114906d1310578675-finding-the-hidden-words-in-strings-of-letters-sumproduct
Sheet: Prova

 |  |  |  | FIRST | SECOND | THIRD | (…)
YDHEIHGKCEWEC |  | SUN | 3 | A5 | A7
RIGJSTARSDSFDH |  | MOON | 2 | A7 | A10
JDSUNDHXSUNFL |  | STAR | 3 | A4 | A7 | A11
HFYEIDGSKQWK |  | ARIZONA | 1 | A11
STARCBVNZTMOONWRSUNH |  | PIPPO | 3 | A8 | A12
DASFRERPIPPOTYBJHX
[NAME] |  |  |  | FIRST | SECOND | THIRD | (…)
LKJHMOONDFJHU |  | SUN | 3 | S3 | S5
testSTARIZONAtest |  | MOON | 2 | [NAME] | S7
DASFRERPIPPOTYBJHXPIPPO |  | STAR | 3 | S2 | S5 | S9
 |  | ARIZONA | 1 | S9
 |  | PIPPO | 3 | S6 | S10
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 102067 | 101181
2 | 100541 | 99669
3 | 113331 | 113022
4 | 75301 | 74820
5 | 74993 | 74822
6 | 77697 | 78322
7 | 83890 | 83066
8 | 85931 | 84822
9 | 85552 | 84822
10 | 84996 | 84822
11 | 94818 | 94822
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 8908.65
2001-12-11 00:00:00
CBS Volume
 |  |  | -51521
Spreadsheet: 767294d1644397728-merge-two-sheets-in-a-third-one-sheet1-sheet2
Sheet: A+B

 | title2 | title3
a | 1 | blue
b | 2 | green
c | 3 | yellow
d | 4 | blue
e | 5 | white
f | 6 | black
g | 7 | yellow
h | 8 | red
Spreadsheet: 273089d1382608459-how-to-count-only-full-months-between-two-dates-antalmaaneder
Sheet: Ark1

 |  |  | ok
2012-04-16 00:00:00 | 2012-10-22 00:00:00 |  |  | 16-Apr-12 to 22-Oct-12 => 5
2012-04-01 00:00:00 | 2012-04-21 00:00:00 |  |  | 1-Apr-12 to 21-Apr-12 => 0
2012-04-01 00:00:00 | 2013-03-31 00:00:00 |  |  | 1-Apr-12 to 31-Mar-13 => 12
2012-04-01 00:00:00 | 2012-09-12 00:00:00 |  |  | 1-Apr-12 to 14-Sep-12 => 5
2012-06-10 00:00:00 | 2013-03-31 00:00:00 |  |  | 10-Jun-12 to 31-Mar-13 => 9
2012-09-03 00:00:00 | 2013-03-31 00:00:00 |  |  | 3-Sep-12 to 31-Mar-13 => 6
2012-04-01 00:00:00 | 2012-10-08 00:00:00 |  |  | 1-Apr-12 to 8-Oct-12 => 6
2012-04-01 00:00:00 | 2012-09-02 00:00:00 |  |  | 1-Apr-12 to 2-Sep-12 => 5
2012-04-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 1-Apr-12 to 31-Dec-12 returns -3 (should be 9 not -3)
2012-06-25 00:00:00 | 2012-12-31 00:00:00 |  |  | 25-Jun-12 to 31-Dec-12 returns -6 (should be 6 not -6)
2012-04-01 00:00:00 | 2012-12-31 00:00:00 |  |  | 1-Apr-12 to 31-Dec-12 returns-3 (should be 9 not -3)
2012-05-15 00:00:00 | 2012-12-31 00:00:00 |  |  | 15-May-12 to 31-Dec-12 returns -5 (should be 7 not -5)
2012-09-16 00:00:00 | 2012-12-31 00:00:00 |  |  | 16-Sep-12 to 31-Dec-12 returns -9 (should be 3 not -9)
2012-12-24 00:00:00 | 2013-03-31 00:00:00 |  |  | 24-Dec-12 to 31-Mar-13 returns 15 (should be 3 not 15)
2012-12-02 00:00:00 | 2013-03-31 00:00:00 |  |  | 2-Dec-12 31-Mar-13 returns 15 (should be 3 not 15)