tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09135a11-430e-465a-a0a8-b61557105561
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 33. LEASE FINANCE COMMITMENTS, By Purpose: State (QLD), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413943F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413944J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413945K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413946L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413947R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413948T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413949V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413950C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413951F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413952J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413953K | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413954L | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413955R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413956T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413957V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413958W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 845722d1697106523-issue-with-doc-with-data-validation-lists-fine-on-one-computer-faulty-on-others-cost-sheet-23
Sheet: Calculator for Bleed

 |  |  |  |  | JUST 3% |  |  | Plus 20mm and 3%
 |  | [NAME] | Height |  | [NAME] | Height |  | [NAME] | Height
 |  | 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
Spreadsheet: 66230d1266934431-retrieve-a-set-of-values-between-two-numbers-rangeret
Sheet: btwn ist last inst

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 8 | 10 | 11 | 13 | 13 | 13 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27
1-1 | 2-1 | 3-1 | 4-1 | 5-1 | 6-1 | 7-1 | 8-1 | 8-2 | 10-1 | 11-1 | 13-1 | 13-2 | 13-3 | 15-1 | 16-1 | 17-1 | 18-1 | 19-1 | 20-1 | 21-1 | 22-1 | 23-1 | 24-1 | 25-1 | 26-1 | 27-1
1 | 8
1-1 | 8-2
2-1 | 3-1 | 4-1 | 5-1 | 6-1 | 7-1 | 8-1
2 | 3 | 4 | 5 | 6 | 7 | 8
Spreadsheet: 37707d1235738136-vlookup-closest-match-vlookup
Sheet: Sheet1

0.0196078431372549 | 50 |  | 5.67 |  | 0.001
0.02439024390243903 | 40
0.02941176470588235 | 33
0.03448275862068965 | 28
0.03846153846153846 | 25
0.04347826086956522 | 22
0.04761904761904762 | 20
0.05263157894736842 | 18
0.05882352941176471 | 16
0.06666666666666667 | 14
0.07692307692307693 | 12
0.08333333333333333 | 11
0.09090909090909091 | 10
0.1 | 9
0.1111111111111111 | 8
0.1176470588235294 | 7.5
0.125 | 7
0.1333333333333333 | 6.5
0.1428571428571428 | 6
0.1538461538461539 | 5.5
0.1666666666666667 | 5
0.1818181818181818 | 4.5
0.2 | 4
0.2222222222222222 | 3.5
0.2307692307692307 | 3.333333333333333
0.25 | 3
0.2666666666666667 | 2.75
0.2857142857142857 | 2.5
0.2941176470588235 | 2.4
0.3076923076923077 | 2.25
0.3333333333333333 | 2
0.3478260869565217 | 1.875
0.3636363636363636 | 1.75
0.3809523809523809 | 1.625
0.4 | 1.5
0.4210526315789473 | 1.375
0.4444444444444444 | 1.25
0.4545454545454545 | 1.2
0.4761904761904762 | 1.1
0.5 | 1
0.5454545454545454 | 0.8333333333333334
0.5789473684210527 | 0.7272727272727273
0.6000000000000001 | 0.6666666666666666
0.6190476190476191 | 0.6153846153846154
0.6363636363636364 | 0.5714285714285714
0.6521739130434783 | 0.5333333333333333
0.6666666666666666 | 0.5
0.6923076923076923 | 0.4444444444444444
0.7142857142857143 | 0.4
0.7272727272727273 | 0.375
0.7333333333333333 | 0.3636363636363636
0.75 | 0.3333333333333333
0.7692307692307692 | 0.3
0.7777777777777779 | 0.2857142857142857
0.8 | 0.25
0.8181818181818181 | 0.2222222222222222
0.8333333333333334 | 0.2
0.8571428571428571 | 0.1666666666666667
0.875 | 0.1428571428571428
0.8888888888888888 | 0.125
0.8999999999999999 | 0.1111111111111111
0.9090909090909091 | 0.1
0.9230769230769231 | 0.08333333333333333
0.9333333333333333 | 0.07142857142857142
0.9411764705882353 | 0.0625
0.9473684210526315 | 0.05555555555555555
0.9523809523809523 | 0.05
0.9615384615384615 | 0.04
0.9705882352941176 | 0.0303030303030303
0.9756097560975611 | 0.025
0.9803921568627451 | 0.02
0.9850746268656717 | 0.01515151515151515
0.9900990099009901 | 0.01
0.9933774834437087 | 0.006666666666666667
0.9950248756218907 | 0.005
0.9960159362549801 | 0.004
0.9966777408637874 | 0.003333333333333334
0.9975062344139651 | 0.0025
0.998003992015968 | 0.002
0.9986684420772303 | 0.001333333333333333
0.9990009990009991 | 0.001
Spreadsheet: 4eccc1fa-2c63-4edd-8805-18edeaafa29d
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/05/2013 | Rifle | Ohio State | 12:00 AM | W, 4657-4648
10/13/2013 | Rifle | at Nebraska* | 12:00 AM | W, 4656-4650
10/26/2013 | Rifle | Army* | 12:00 AM | W, 4695-4669
11/02/2013 | Rifle | Mississippi* | 12:00 AM | W, 4681-4614
11/03/2013 | Rifle | Akron | 12:00 AM | W, 4690-4605
11/16/2013 | Rifle | at Navy* | 12:00 AM | W, 4678-4627
01/19/2014 | Rifle | [NAME]* | 12:00 AM | W, 4707-4604
01/24/2014 | Rifle | at Withrow Invitational (Murray, Ky.) | 12:00 AM | First Place, 4710
01/25/2014 | Rifle | at Memphis* | 12:00 AM | W, 4690-4655
02/06/2014 | Rifle | Alaska-Fairbanks | 12:00 AM | W, 4709-4680
02/08/2014 | Rifle | Kentucky* | 12:00 AM | W, 4702-4688
[NAME] | Rifle | [NAME] (Murray, Ky.) | 12:00 AM | 4691
03/01/2014 | Rifle | GARC Championships (Oxford, Miss.) | 12:00 AM | First, 2337
03/02/2014 | Rifle | GARC Championships (Oxford, Miss.) | 12:00 AM | First, 4700
03/14/2014 | Rifle | [NAME] (Murray, Ky.) | 12:00 AM | All Day
03/15/2014 | Rifle | [NAME] (Murray, Ky.) | 12:00 AM | All Day
Spreadsheet: 13adbbb3-cb4f-4301-a102-4a3d168afd60
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
8778 | 21827 | Nadia | Glarey | ITA | 103 | [NAME] | 00:01:03 | [NAME] | 00:02:15 | [NAME] | 1 | 01:14:24
8778 | 46530 | Yulia | Gudalova | RUS | 104 | 00:22:27 | 00:00:35 | 00:35:52 | [NAME] | 00:23:17 | 2 | 01:23:42
Spreadsheet: 112613d1308683327-need-help-to-consolidate-and-print-from-multiple-sheets-df-pullsheet
Sheet: BEVERAGE

BEVERAGE SERVICE | ✓
Basic Bar Setups |  | 2
Stainless shaker (w/ strainer, glass, and jigger) | 3
ice scoop | 3
bar spoon | 2
speed pourers | 30
bar picks | 2
silver pitcher | 2
6" revere bowl
10" revere bowl
olives | 2
cherries | 2
cranberry juice | 4
bitters | 2
onions | 2
rose's lime juice | 2
grenadine | 2
vermouth, dry | 2
vermouth, sweet | 2
sweet-n-sour mix | 2
bloody mary mix | 2
margarita mix | 2
Special Bar Items
simple syrup
muddler
Plastic Straws |  |  | Type: |  | Unwrapped
margarita salt dispenser |  |  |  |  | Wrapped
margarita salt |  |  |  |  | Red Giant
bar blender |  |  |  |  | Black Jumbo
plastic pitcher
glass pitcher |  |  | Type: |  | [NAME]
 |  |  |  |  | [NAME]
12" revere bowl |  |  |  |  | Full-Size
punch bowl, large (with tray)
punch bowl, small (with tray)
punch ladle, sp
champagne bucket, large
champagne bucket, small
Coffee/Tea Service
teapot, sp
tea strainer
electric tea kettle
coffee server, sp
9x13 or 8x12 tray
creamer, sp
sugar, sp
creamer, glass
sugar, glass
50 c. samovar (with tray) | 2
25 c. samovar (with tray)
2 oz. sterno holder, sp | 2
2 oz. sterno | 10
sign, "coffee"
sign, "decaf"
sign, "hot water"
air pot, ss
milk pitcher, ss
coffee maker, 12 c. w/ cord
coffee maker, medium
coffee maker, large
espresso maker (PODS?)
Spreadsheet: 0379aabb-4050-4575-ab84-9539cd987155
Sheet: TA Plan

Site Id# | Site Id# Photos | CCC | FCD | City | 303d | Jurisdiction | Creek | From | To | Notes | Creek Group
Unincorporated Contra Costa County
Region 2:  San Francisco Bay
CCC-SF01 | CCC01 | X | X |  |  | Pacheco | [NAME] | Center Ave | 100 yds South towards 2nd Street | Homeless & Steep Banks | Friends of the Creeks
CCC-SF02 | CCC02 | X | X |  |  | Rodeo | Rodeo Creek | 7th Street | 100 yds North to 4th Street | [NAME] | Friends of Rodeo Creek
CCC-SF03 | CCC03 | X | X |  |  | North Richmond | Wildcat Creek | Giaramita Street | 100 yrds UpS | Behind [NAME] | the Watershed Project
CCC-SF04 | CCC04 | X | X |  | X | El Sobrante | San Pablo Creek | Appian Way (Begin under east side of bridge) | 100 yds UpS towards Private Property sign | Homeless (need to include/clean under bridge to have 100 yds.) | High Schoolers Making Waves w/SPAWNERS
Unincorporated Contra Costa County
Region 5:  Central Valley
CCC-CV01 | CCC05 |  | X |  | X | unincorporated Oakley | Marsh Creek | South of Delta Rd. | 100 yds Ups towards Wastewater Treatment Plant | A lot of trash from fishing activities | Friends of Marsh Creek
Contra Costa County Flood Control District
Region 2: San Francisco Bay
FCD-SF01 | FCD01 | X | X |  |  | Bay Point | Riverside Ditch | [NAME] | 100 yds South | Easy Access
FCD-SF02 | FCD02 |  | X | X |  | Concord | Pine Creek | South edge of 1st east side flap gate upstream from end of lined channel | 100 yds UpS towards Willow pass pedestrian overpass | Concrete lined; Access at SE corner Waterworld Parking lot
Site Id# | Site Id# Photos | CCC | FCD | City | 303(d) | Jurisdiction | Creek | From | To | Notes | Creek Group
FCD-SF03 | FCD03 | X | X |  |  | North Richmond | Wildcat Creek | Richmond Parkway Bridge | 100 yrds DS towards Staging Area | Wide w/lots of trash | the Watershed Project
FCD-SF04 | FCD04 | X | X |  | X | North Richmond | San Pablo Creek | 3rd Street; South of Parr Blvd | 100 yds UpS | Roadside trash from 3rd Street
Contra Costa County Flood Control District
Region 5:  Central Valley
FCD-CV01 | [NAME] |  | X | X | X | Brentwood | Line E | North of Grant street @ Cesar Chavez | 100 yds downstreem towards Bosk Ave. | Great hotspot
FCD-CV02 | FCD06 |  | X | X | X | Brentwood | Line E (Part 2) | Lower Marsh Creek | South of Grant Street @ Souith edge of concrete apron | 100 yds downstreem towards 'old' Hwy 4 | Trash evident and adjacent park
Spreadsheet: 118946d1314108754-comparing-data-values-in-a-spreadsheet-and-transferring-a-row-of-data-2nd-attempt
Sheet: Sheet1

353681041979766 |  |  |  |  |  | 359424016951336 | RG75 | V2.3 | 2009-11-13 00:00:00
353681041979790 |  |  |  |  |  | 359424016794421 | RG76 | V2.3 | 2009-11-14 00:00:00
353681041979808 |  |  |  |  |  | 359424016795931 | RG77 | V2.3 | 2009-11-15 00:00:00
353681041979832 |  |  |  |  |  | 359424016955741 | RG78 | V2.3 | 2009-11-16 00:00:00
353681041980061 |  |  |  |  |  | 359424016966201 | RG79 | V2.3 | 2009-11-17 00:00:00
353681041980582 |  |  |  |  |  | 359424016948738 | RG80 | V2.3 | 2009-11-18 00:00:00
353681041981150 |  |  |  |  |  | 359424016965070 | RG81 | V2.3 | 2009-11-19 00:00:00
353681044158855 |  |  |  |  |  | 359424016794371 | RG82 | V2.3 | 2009-11-20 00:00:00
353681044166023 |  |  |  |  |  | 359424016798083 | RG83 | V2.3 | 2009-11-21 00:00:00
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 61566 | 59996
2 | 49101 | 48215
3 | 47890 | 47831
4 | 48669 | 48279
5 | 59532 | 55693
6 | 59879 | 59675
7 | 54025 | 54498
8 | 52716 | 54046
9 | 41062 | 40500
10 | 41041 | 39057
11 | 46428 | 46600
12 | 60865 | 62094
13 | 67308 | 68120
14 | 58840 | 58055
15 | 62475 | 60592
16 | 63508 | 64128
17 | 58596 | 61513
18 | 71871 | 72615
19 | 48147 | 48683
20 | 42100 | 50253
21 | 42960 | 40867
22 | 53191 | 52563
23 | 54652 | 68370
24 | 52249 | 64632
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | 817965.6
2001-06-24 00:00:00
Spreadsheet: 0800b23e-0b13-4cb9-9f8f-f4b208a5cfbf
Sheet: Families

Tract Number | All Families(1) | Average Family Size | Married Couples w/ Own Children(2) | Single Parent [NAME] w/ Own Children(2) | Married Couples -  w/o [NAME]) | All Other Families | All Non-Family HHs(3) | HHs w/ Children as % All HHs(4)
3521.01 | 339 | 2.37 | 58 | 27 | 181 | 73 | 630 | 0.097
3521.02 | 463 | 2.46 | 94 | 24 | 273 | 72 | 769 | 0.101
3522 | 316 | 2.72 | 74 | 40 | 153 | 49 | 757 | 0.116
3523 | 689 | 2.61 | 180 | 76 | 342 | 91 | 1086 | 0.152
3524 | 490 | 3.3 | 104 | 162 | 109 | 115 | 301 | 0.391
3525 | 458 | 3.06 | 113 | 90 | 171 | 84 | 749 | 0.186
3526 | 480 | 2.85 | 95 | 77 | 213 | 95 | 537 | 0.187
3527 | 413 | 2.85 | 90 | 113 | 119 | 91 | 564 | 0.233
3528 | 393 | 2.87 | 85 | 57 | 173 | 78 | 506 | 0.175
3529 | 511 | 2.61 | 139 | 41 | 278 | 53 | 822 | 0.14
3530 | 567 | 2.66 | 133 | 88 | 274 | 72 | 1339 | 0.12
3531.01 | 258 | 2.86 | 52 | 62 | 86 | 58 | 704 | 0.123
3531.02 | 108 | 2.46 | 28 | 4 | 65 | 11 | 205 | 0.105
3532 | 624 | 2.72 | 161 | 99 | 280 | 84 | 988 | 0.174
3533 | 688 | 2.73 | 205 | 89 | 325 | 69 | 932 | 0.188
3534 | 594 | 2.96 | 194 | 101 | 189 | 110 | 641 | 0.256
3535 | 465 | 2.85 | 124 | 69 | 192 | 80 | 806 | 0.165
3536 | 579 | 2.61 | 159 | 59 | 322 | 39 | 907 | 0.151
3537 | 497 | 2.47 | 121 | 35 | 304 | 37 | 1340 | 0.087
3538 | 715 | 2.42 | 151 | 45 | 461 | 58 | 2023 | 0.074
3539 | 422 | 2.66 | 155 | 43 | 198 | 26 | 1031 | 0.138
3540 | 508 | 2.48 | 109 | 39 | 322 | 38 | 1454 | 0.082
3541 | 517 | 2.41 | 92 | 25 | 361 | 39 | 1004 | 0.08
3542 | 766 | 2.81 | 259 | 53 | 399 | 55 | 525 | 0.249
3543 | 745 | 2.9 | 217 | 120 | 287 | 121 | 806 | 0.233
3544 | 387 | 2.8 | 141 | 46 | 162 | 38 | 372 | 0.256
3545 | 462 | 2.53 | 127 | 33 | 272 | 30 | 756 | 0.131
3546 | 1018 | 2.97 | 354 | 170 | 355 | 139 | 1060 | 0.265
3547 | 495 | 2.71 | 155 | 38 | 235 | 67 | 650 | 0.175
3548 | 415 | 2.64 | 112 | 35 | 217 | 51 | 498 | 0.166
3549 | 1481 | 3.04 | 436 | 278 | 475 | 292 | 1071 | 0.306
3550 | 557 | 2.8 | 159 | 58 | 253 | 87 | 779 | 0.177
Citywide | 17420 | 2.76 | 4676 | 2296 | 8046 | 2402 | 26612 | 0.169
Spreadsheet: 740011d1626138379-assign-unique-project-code-project-id-challenge
Sheet: Diana

Company Name | Dupe Count | Assigned Code |  |  | Expected Code
ABC |  |  |  |  | ABC00
ABCD |  |  |  |  | ABCD0
ACBDE |  |  |  |  | ABCDE
ABCDE |  |  |  |  | ABCD1
dfsdsdf |  |  |  |  | DFSDS
sdfsdf |  |  |  |  | SDFSD
sdfsdf |  |  |  |  | SDFS0
sdfsdf |  |  |  |  | SDFS1
sdfsdf |  |  |  |  | SDFS2
sdfdfsf |  |  |  |  | SDFDF
ddddd |  |  |  |  | DDDDD
sss99 |  |  |  |  | SSS99
ddddd99 |  |  |  |  | [NAME]
sd99 |  |  |  |  | SD990
sdfsdf |  |  |  |  | SDFS3
gg |  |  |  |  | GG000
gs |  |  |  |  | [NAME]
sdfdsfsfsdf |  |  |  |  | SDFDS
SD99 |  |  |  |  | SD991
Spreadsheet: 808374d1670433167-vlookup-depend-on-dropdown-list-in-another-column-car-parked-testt
Sheet: main data

CP Card | ORDER NUMBER | ITEM CODE | Quantity | EXPIRY DATE | CUSTOMER | [NAME] | Minimum DATE | Date Added | Planning ETA | Comments | Order In RP? | L code | [NAME]
CP150 | ORD72998077000118510902 | LWBAVVT385-[PHONE] | 1 | 2023-10-01 00:00:00 | CV INDIA |  |  | 2022-07-25 00:00:00
CP039 | ORDR0538191800118638703 | LBIOFSH686+0525 | 1 | 2023-10-01 00:00:00 | CV HONG KONG |  |  | 2022-07-26 00:00:00
 | ORD73042669800118720308 | LWBXTRC687+[PHONE] | 1 | 2023-11-01 00:00:00 | TIEDRA |  |  | 2022-07-27 00:00:00
 | ORD73040293400118724179 | LWBXTRC687+[PHONE] | 1 | 2024/02 | TIEDRA |  |  | 2022-07-28 00:00:00
 | ORD73036256300118724179 | LWBXTRC687+[PHONE] | 1 | 2023/10 | TIEDRA |  |  | 2022-07-28 00:00:00
CP010 | ORDR0563187300118746560 | LBIOFSH686+0525 | 117 | 2023/10 | CV HONG KONG |  |  | 2022-08-05 00:00:00
 | ORDR0570645600118755756 | TDIAGBT187+[PHONE] | 1 | 2024/01 | [NAME] |  |  | 2022-08-08 00:00:00
 | ORDR0570645600118747483 | TDIAGBT187+[PHONE] | 1 | 2023/09 | [NAME] |  |  | 2022-08-08 00:00:00
 | ORD22BT572758900118763991 | TDAVVTT185+[PHONE] | 1 | 2023/09 | BELGIUM |  |  | 2022-08-08 00:00:00
 | ORDR0571007600118773373 | TDIAGBT187-[PHONE] | 2 | 2023/10 | CVI HUNGARY |  |  | 2022-08-09 00:00:00
CP043 | ORDR0570566100118760626 | TDMYDTCK86-[PHONE] | 1 | 2023/09 | CV IBERIA |  |  | 2022-08-09 00:00:00
 | ORD73045254200118773455 | TDIAGBT187-[PHONE] | 1 | 2023/12 | CV INDIA |  |  | 2022-08-09 00:00:00
 | ORD73055401100118831082 | LWBXTRC687-[PHONE] | 1 | 2023/12 | TIEDRA |  |  | 2022-08-22 00:00:00
 | ORDR0574694000118830852 | TDIAGBT187-[PHONE] | 1 | 2024/01 | [NAME] |  |  | 2022-08-22 00:00:00
CP198 | ORDR0574695700118800354 | TDMYDTCK86-[PHONE] | 4 | 2023/09 | CV IBERIA |  |  | 2022-08-23 00:00:00
[NAME] | ORDR0574513800118812227 | TEU55UA188+0800 | 4 | 2023/09 | CVI HUNGARY |  |  | 2022-08-27 00:00:00
 | ORD12161679800118876129 | LICMNVS684-0900 | 17 | 2024/07 | DUBAI |  |  | 2022-09-04 00:00:00
 | ORD73069428000118898268 | LWBXTRC387-[PHONE] | 1 | 2023/10 | TIEDRA |  |  | 2022-09-05 00:00:00
CP042 | ORD22BT574945200118814226 | TDMYDTCK86-[PHONE] | 8 | 2023/09 | BELGIUM |  |  | 2022-09-06 00:00:00
 | ORD73069425400118876088 | LWBXTRC687-[PHONE] | 1 | 2023/12 | TIEDRA |  |  | 2022-09-06 00:00:00
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 12. Structures

 | FY 2012 Federal Real Property Charts
 | Structures†
 | Agency | Owned Structure Assets** | Owned Annual Operating Costs** | Leased Structure Assets | Lease Annual Costs*
 | Agriculture | 17673 | 260742783.07 | 153 | 518786.42
 | Air Force*** | 69614 | 1559683433.929 | 3441 | 113042341.096
 | Army*** | 165667 | 1256061020.982 | 5183 | 55730579.208
 | Commerce | 112 | 28996855 | 735 | 3102244.92
 | Corps of Engineers*** | 3481 | 721635307 | 13 | 163249
 | Defense/WHS*** | 542 | 1984582.573 | 0 | 0
 | Energy | 7582 | 311111098 | 2 | 50764
 | Environmental Protection Agency | 100 | 550580.7599999998 | 3 | 5805000
 | General Services Administration | 184 | 14640593.01 | 125 | 8988325
 | Health and Human Services | 84 | 23281635.88 | 1 | 0
 | Homeland Security | 18623 | 233231622.45 | 1325 | 13097320.87
 | Interior | 75083 | 985385530.598 | 14 | 350089.9
 | Justice | 384 | 1523150 | 1 | 507351
 | Labor | 1542 | 845465.98 | 53 | 112810.94
 | National Aeronautics And Space Administration | 2351 | 131909951 | 5 | 1561992
 | National Science Foundation | 216 | 8346948 | 0 | 0
 | Navy*** | 59170 | 2161971599.104 | 5307 | 213132865.949
 | State | 1080 | 22486979.86 | 291 | 10888503.29
 | State (USAID) | 2 | 123582.32 | 4 | 131985.36
 | Transportation | 42612 | 59113425.63 | 217 | 2325375
 | Veterans Affairs | 2887 | 14464013.47 | 4 | 165868.68
 | Total | 468989 | 7798090158.616 | 16877 | 429675452.633
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | *Includes operations and maintenance costs and rent
 | **includes federal government owned, foreign government owned, museum trust, state government owned
 | *** Department of Defense
Spreadsheet: a5cfad8c-a22b-40f9-b0e4-099598679935
Sheet: Tariff 9

1
 | •
 | •
 | •
 | •
 | •
 |  |  |  | @
 |  |  |  |  |  |  | False
 |  |  | False
 |  | Signature |  |  |  |  |  |  |  |  |  |  |  |  | Date
 | 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
1
2
3
4
5
6
7
Spreadsheet: 731244d1620244048-conditional-formatting-using-a-date-to-colour-the-cell-pseudo-traffic-light-formatting-heidiv-
Sheet: Sheet1

Vehicle | Make of Vehicle | Reg | Driver | Road Tax | MOT
 |  |  |  | Expires | Expires
 |  |  |  | 31.10.2021 | 30.06.2021
 |  |  |  | 03.05.2021 | 01.05.2021
 |  |  |  | 31.05.2021 | 04.11.2021
 |  |  |  | 01.12.2021 | 21.05.2021
 |  |  |  | 30.11.2021 | 12.11.2021
 |  |  |  | 15.05.2021 | 11.06.2021
 |  |  |  | 30.06.2021 | 12.11.2021
 |  |  |  | 30.11.2021 | 20.11.2021
 |  |  |  | 01.11.2021 | 22.11.2021
 |  |  |  | 31.12.2021 | 09.12.2021
 |  |  |  | 31.01.2022 | 10.05.2022
 |  |  |  | 31.01.2022 | 17.02.2022
 |  |  |  | I need the date cells in each column to colour green if the date is 3 months or more in the future, orange if it is 2 months or less, and red if it's within one month of today. | Example is above.
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 9912
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Sithe
Aruba
Northeast | 0 |  | 0 |  | 0 | 0
East- EGM
East-LRC
FT-East
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Denver
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0