tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110760d1307377962-concatenate-a-big-range-of-cells-udf-concatenate-range-at-stated-intervals-concbystep-
Sheet: Sheet1

 |  |  |  |  |  |  | " " separator (space) step 50
2454064.482639 |  |  |  |  |  |  | 2454064.[PHONE].[PHONE].788139
2454064.475694
2454064.46875
2454064.461804
2454064.454859
2454064.447914
2454064.440969
2454064.434024 |  |  |  |  |  |  | ", " separator (comma space) step 10 starting with row 10
2454064.427079 |  |  |  |  |  |  | 2454064.427079, 2454064.357629, 2454064.288179, 2454064.218729, 2454064.149279, 2454064.079829, 2454064.010379, 2454063.940929, 2454063.871479, 2454063.802029
2454064.420134
2454064.413189
2454064.406244
2454064.399299
2454064.392354
2454064.385409
2454064.378464 |  |  |  |  |  |  | "|" separator (pipe) step 20
2454064.371519 |  |  |  |  |  |  | 2454064.482639|2454064.343739|2454064.204839|2454064.065939|2454063.927039
2454064.364574
2454064.357629
2454064.350684
2454064.343739
2454064.336794
2454064.329849
2454064.322904
2454064.315959
2454064.309014
2454064.302069
2454064.295124
2454064.288179
2454064.281234
2454064.274289
2454064.267344
2454064.260399
2454064.253454
2454064.246509
2454064.239564
2454064.232619
2454064.225674
2454064.218729
2454064.211784
2454064.204839
2454064.197894
2454064.190949
2454064.184004
2454064.177059
2454064.170114
2454064.163169
2454064.156224
2454064.149279
2454064.142334
2454064.135389
2454064.128444
2454064.121499
2454064.114554
2454064.107609
2454064.100664
2454064.093719
2454064.086774
2454064.079829
2454064.072884
2454064.065939
2454064.058994
2454064.052049
2454064.045104
2454064.038159
2454064.031214
2454064.024269
2454064.017324
2454064.010379
2454064.003434
2454063.996489
2454063.989544
2454063.982599
2454063.975654
2454063.968709
2454063.961764
2454063.954819
2454063.947874
2454063.940929
2454063.933984
2454063.927039
2454063.920094
2454063.913149
2454063.906204
2454063.899259
2454063.892314
2454063.885369
2454063.878424
2454063.871479
2454063.864534
2454063.857589
2454063.850644
2454063.843699
2454063.836754
2454063.829809
2454063.822864
2454063.815919
2454063.808974
2454063.802029
2454063.795084
2454063.788139
Spreadsheet: 8f90867d-b085-4c4a-b794-2c42c16f357c
Sheet: Sheet1

 | Costs You Will Pay Directly to UWEC:
 |  |  | CIE Program Fee includes: |  | Undergrad | Grad
 |  |  | Tuition/ Fees (WI res, 3 credits) |  | 1088.73 | 1357
 |  |  | Program Fee(room, breakfast, 5 group meals, field trips) |  | 3623 | 3623
 |  |  | CIE Admin fees |  | 150 | 150
 |  |  | CISI Insurance |  | 17 | 17
 |  | TOTAL ESTIMATED COST YOU PAY DIRECTLY TO UWEC*:
 | Total Additional Costs to Expect:
 |  |  | Passport/Photos |  | 170 | 170
 |  |  | Meals not included |  | 200 | 200
 |  |  | Visa reciprocity fee |  | 180 | 180
 |  |  | Personal Expenses |  | 250 | 250
 |  |  | Estimated Round-Trip Airfare |  | 1550 | 1550
 |  |  | MSP to MDZ (Mendoza)
 |  | TOTAL ADDITIONAL COSTS TO EXPECT:
 | TOTAL ESTIMATED COST
 | MN residents add reciprocity
 | updated 4/2/12 lac
Spreadsheet: tracy_geaccone__40244__TW  Cap for Tracy
Sheet: Sheet1

Updated: | 2001-11-27 00:00:00 |  |  |  |  | TW
Capital Budget 2001
Through Month of |  | OCTOBER
Project in Budget | Status | Budget $ |  | Work Order $'s | Comm | Actuals | $'s Est Needed to [NAME] | JAN | FEB | MAR | APR | MAY | JUN | JULY | AUG | SEP | OCT | NOV | DEC | TOTAL | Over/(Under) WO | Over/(Under) Budget
Business Development
New Rates & Revenue |  | 0 | 3
FERC 637 | Available | 127000 | 2/3
GISB Ver 1.5 |  | 0 | 1 | 0
GISB Imbalance Trading |  | 0 | 3 | 0
New Contract Cap/Rel System
C.006360 | A |  |  | 327880 |  |  |  |  |  |  |  |  |  |  |  |  | 102904 | 224976
C.006361 | A |  |  | 42120 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 14040 | 28080
Total |  | 370000
Cross Contract Ranking |  | 0 | 3 | 0
TW Flow Direction | Available | 50000
[NAME]  C.000691        Liccardo | F | 73000 | 2 | 73000 | 5222 |  |  | 18932 | 21698 | 17250 | 991 | 82 | 742 | 141 | 213 | 4094 | 0 |  | 8857
EDI Upload Carryover C.006244      Liccardo | A | 90000 | 1 | 90000 |  |  |  | 542 | 320 | 5959 | 734 | 2582 | 415 | 1054 | 435 | 421 | 5226 |  | 72312
Market Intelligence  C.005451                Zhou | A | 40000 |  | 38594 |  |  |  |  | 787 | 5106 | 1548 | 10272 | 8509 | 2543 | 3945 | 3909 | 330 | 1645
Marketing DataMart for Reporting | Available | 20000
MFE Enhancements | Available | 20000
Environmnetal Auditing & Permitting(cancelled) |  | 0 | 4
Enterprise Data Logger(CANCELLED) |  | 0 | 4
PILARS - O&E C.006929 |  | 72600 | 4 | 72600 |  |  |  |  |  |  |  |  |  |  |  |  | 11322 | 30641 | 30637
Web Interface Project O&E(cancelled) |  | 0 | 4
Engine/Compressor Health(cancelled) |  | 0 | 4
PDMS | COMMITTED | 67400 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67400
Blankets
Infra Desktop B.060002.GS.MKSV Steward | A | 20000 |  | 20000 | 1820 |  |  |  |  |  |  |  |  | 5540 | 0 | 0 | 0 | 14460
Blanket Gas Control B.060002.GS.GC  [NAME] | A | 10000 |  | 10000 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 10000
O&E Desktop  B.06002.GB.HOPS | A | 17000 |  | 17000 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 8500 | 8500
Field Desktop B.060001.BC       Rich | A | 200000 |  | 200000 |  |  |  |  | -2365 |  |  | 3940 |  |  | 0 |  |  | 45000 | 153423
TOTAL CAPITAL
Available funds
 |  |  | 1 | EDI Upload Cap Rel C6244 is being funded by GISB Ver 1.5 Dollars
 |  |  | 2 | Cap Analysis C.000691 is being funded by Replace Contract System
 |  |  | 3 | $100.000 Dollars to fund New Rates and Revenue system moved to NNG
 |  |  | 4 | Dollars to fund new O&E project
Status
A - Active
F - Finished
H - Hold
C - Cancelled
Spreadsheet: 153780d1336052308-excel-2007-index-match-and-a-lot-of-ifs-and-duplicates-scoretest_dip11-4-
Sheet: Sheet2

Actor | ID
Actor1 | 1
Actor2 | 10
Actor3 | 11
Actor4 | 12
Actor5 | 13
Actor6 | 14
Actor7 | 15
Actor8 | 16
Actor9 | 17
Actor10 | 18
Actor11 | 19
Actor12 | 20
Actor13 | 21
Actor14 | 22
Actor15 | 23
Actor16 | 24
Actor17 | 25
Actor18 | 26
Actor19 | 27
Actor20 | 28
Actor21 | 29
Actor22 | 30
Actor23 | 31
Actor24 | 32
Actor25 | 33
Actor26 | 34
Actor27 | 35
Actor28 | 36
Actor29 | 38
Actor30 | 39
Actor31 | 41
Actor32 | 42
Actor33 | 43
Actor34 | 45
Actor35 | 48
Actor36 | 51
Actor37 | 53
Actor38 | 56
Actor39 | 73
Actor40 | 77
Actor41 | 78
Actor42 | 80
Actor43 | 88
Actor44 | 89
Actor45 | 90
Actor46 | 99
Spreadsheet: 473998d1470568419-formula-for-top-5-values-with-countif-sample-gk
Sheet: Data

Problem Area | FullDate | Region
Cash Management | 2016-04-01 00:00:00 | Midwest
Store Manager | 2016-04-01 00:00:00 | South
Complaints on Employees | 2016-04-01 00:00:00 | Midwest
Inquiry | 2016-04-01 00:00:00 | Midwest
UHHT | 2016-04-01 00:00:00 | Midwest
Ingenico Payment Terminal | 2016-04-01 00:00:00 | Midwest
Ingenico Payment Terminal | 2016-04-01 00:00:00 | Midwest
STOREnet PC | 2016-04-01 00:00:00 | Midwest
Software | 2016-04-01 00:00:00 | Midwest
NA | 2016-04-01 00:00:00 | South
NA | 2016-04-01 00:00:00 | South
STOREnet PC | 2016-04-01 00:00:00 | South
None | 2016-04-01 00:00:00 | South
NA | 2016-04-02 00:00:00 | South
Coolers | 2016-04-02 00:00:00 | South
NA | 2016-04-02 00:00:00 | Midwest
Complaints on Employees | 2016-04-02 00:00:00 | Midwest
UHHT | 2016-04-02 00:00:00 | Midwest
Software | 2016-04-02 00:00:00 | South
Complaints on Employees | 2016-04-02 00:00:00 | South
Complaints on Employees | 2016-04-02 00:00:00 | South
IBM 742 | 2016-04-02 00:00:00 | South
Software | 2016-04-02 00:00:00 | South
Sensitive HR issues | 2016-04-02 00:00:00 | South
Desired Behaviors Analysis | 2016-04-02 00:00:00 | South
Promotions | 2016-04-02 00:00:00 | South
Store Manager | 2016-04-02 00:00:00 | South
Ingenico Payment Terminal | 2016-04-03 00:00:00 | South
Ingenico Payment Terminal | 2016-04-03 00:00:00 | South
Spreadsheet: 107674d1304795357-adding-different-parts-of-a-growing-array-sample
Sheet: Sheet1

Month | Residual Earned |  |  | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
1 | 0.3 |  |  | 10
2 | 0.25
3 | 0.14 |  |  |  | 3.6 | 4.2 | 4.8 | 5.399999999999999 | 6 | 6.6 | 7.199999999999999 | 7.8 | 8.4 | 9 | 9.6 | 10.2 | 10.8 | 11.4 | 12 | 12.6 | 13.2 | 13.8 | 14.4 | 15 | 15.6 | 16.2 | 16.8
4 | 0.08 |  |  | 2.5 | 3 | 3.5 | 4 | 4.5 | 5 | 5.5 | 6 | 6.5 | 7 | 7.5 | 8 | 8.5 | 9 | 9.5 | 10 | 10.5 | 11 | 11.5 | 12 | 12.5 | 13 | 13.5 | 14
5 | 0.05 |  |  | 1.4 | 1.68 | 1.96 | 2.24 | 2.52 | 2.8 | 3.08 | 3.36 | 3.640000000000001 | 3.92 | 4.2 | 4.48 | 4.760000000000001 | 5.040000000000001 | 5.32 | 5.600000000000001 | 5.880000000000001 | 6.16 | 6.44 | 6.720000000000001 | 7.000000000000001 | 7.280000000000001 | 7.56 | 7.840000000000001
6 | 0.04 |  |  | 0.8 | 0.96 | 1.12 | 1.28 | 1.44 | 1.6 | 1.76 | 1.92 | 2.08 | 2.24 | 2.4 | 2.56 | 2.72 | 2.88 | 3.04 | 3.2 | 3.36 | 3.52 | 3.68 | 3.84 | 4 | 4.16 | 4.32 | 4.48
7 | 0.03 |  |  | 0.5 | 0.6000000000000001 | 0.7000000000000001 | 0.8 | 0.9 | 1 | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 | 1.9 | 2 | 2.1 | 2.2 | 2.3 | 2.4 | 2.5 | 2.6 | 2.7 | 2.8
8 | 0.03 |  |  | 0.4 | 0.48 | 0.56 | 0.64 | 0.72 | 0.8 | 0.88 | 0.96 | 1.04 | 1.12 | 1.2 | 1.28 | 1.36 | 1.44 | 1.52 | 1.6 | 1.68 | 1.76 | 1.84 | 1.92 | 2 | 2.08 | 2.16 | 2.24
9 | 0.03 |  |  | 0.3 | 0.36 | 0.42 | 0.48 | 0.54 | 0.6 | 0.6599999999999999 | 0.72 | 0.78 | 0.84 | 0.8999999999999999 | 0.96 | 1.02 | 1.08 | 1.14 | 1.2 | 1.26 | 1.32 | 1.38 | 1.44 | 1.5 | 1.56 | 1.62 | 1.68
10 | 0.02 |  |  | 0.3 | 0.36 | 0.42 | 0.48 | 0.54 | 0.6 | 0.6599999999999999 | 0.72 | 0.78 | 0.84 | 0.8999999999999999 | 0.96 | 1.02 | 1.08 | 1.14 | 1.2 | 1.26 | 1.32 | 1.38 | 1.44 | 1.5 | 1.56 | 1.62 | 1.68
11 | 0.02 |  |  | 0.3 | 0.36 | 0.42 | 0.48 | 0.54 | 0.6 | 0.6599999999999999 | 0.72 | 0.78 | 0.84 | 0.8999999999999999 | 0.96 | 1.02 | 1.08 | 1.14 | 1.2 | 1.26 | 1.32 | 1.38 | 1.44 | 1.5 | 1.56 | 1.62 | 1.68
12 | 0.01 |  |  | 0.2 | 0.24 | 0.28 | 0.32 | 0.36 | 0.4 | 0.44 | 0.48 | 0.52 | 0.56 | 0.6 | 0.64 | 0.68 | 0.72 | 0.76 | 0.8 | 0.84 | 0.88 | 0.92 | 0.96 | 1 | 1.04 | 1.08 | 1.12
 |  |  |  | 0.2 | 0.24 | 0.28 | 0.32 | 0.36 | 0.4 | 0.44 | 0.48 | 0.52 | 0.56 | 0.6 | 0.64 | 0.68 | 0.72 | 0.76 | 0.8 | 0.84 | 0.88 | 0.92 | 0.96 | 1 | 1.04 | 1.08 | 1.12
 |  |  |  | 0.1 | 0.12 | 0.14 | 0.16 | 0.18 | 0.2 | 0.22 | 0.24 | 0.26 | 0.28 | 0.3 | 0.32 | 0.34 | 0.36 | 0.38 | 0.4 | 0.42 | 0.44 | 0.46 | 0.48 | 0.5 | 0.52 | 0.54 | 0.56
 |  |  | Total
 |  |  | Revenue
Spreadsheet: 79bd8667-ffd6-427a-8afc-3cec525825f5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7608 | 25773 | [NAME] | Landier | FRA | 26 | [NAME] | 00:01:12 | 00:27:32 | 00:00:00 | 00:00:00 | 1 | 01:02:10
7608 | 53761 | [NAME] | Johnston | USA | 24 | 00:19:38 | 00:01:04 | 00:30:11 | 00:00:00 | 00:00:00 | 2 | 01:02:23
7608 | 13651 | Martin | Falch | AUT | 27 | 00:21:09 | 00:01:04 | 00:30:31 | 00:00:00 | 00:00:00 | 3 | 01:04:58
7608 | 56294 | Alessandro | Colombo | ITA | 21 | 00:23:56 | 00:00:41 | 00:28:51 | 00:00:00 | 00:00:00 | 4 | [NAME]
7608 | 41160 | Adrian | Howden | GBR | 22 | 00:22:53 | 00:00:58 | 00:35:12 | 00:00:00 | 00:00:00 | 5 | 01:11:56
7608 | 63078 | Vincent | Hurtelle | FRA | 23 | 00:24:30 | 00:01:00 | 00:34:49 | 00:00:00 | 00:00:00 | 6 | 01:15:54
Spreadsheet: 769099d1645289133-how-many-unique-areas-have-been-visited-by-vehicle-in-date-range-report
Sheet: Report

Weekly Number of DO per vehicle
From | To | 11/17055 | 1/63335 | 1/64134 | 1/67031 | 11/69228 | 13/51504 | 13/51623 | 13/51814 | 13/54318 | 13/807714 | 13/80774 | 13/80857 | 15/70824 | 2/98435 | 3/15531 | 8/12539
2021-11-01 00:00:00
Monthly
In below table I would like to count no of area delivered by each vehicle on the specific date
 | To | 11/17055 | 1/63335 | 1/64134 | 1/67031 | 11/69228 | 13/51504 | 13/51623 | 13/51814 | 13/54318 | 13/807714 | 13/80774 | 13/80857 | 15/70824 | 2/98435 | 3/15531 | 8/12539
 | 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-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-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-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-27 00:00:00
 | 2021-11-28 00:00:00
 | 2021-11-29 00:00:00
 | 2021-11-30 00:00:00
Spreadsheet: 91489d1291216229-sort-filter-lookup-problem-sort
Sheet: Sheet1

 | Looks at 1st collum
 |  | Looks at second column
 |  |  | If there are more than one the same, add up those figures
1 | Fridge | 654 | 889
1 | Fridge | 235
1 | Bed | 458
1 | Shoes | 654
1 | Shoes | 235
1 | Skirt | 489
1 | Skirt | 247
2 | Fridge | 521
2 | Fridge | 258
2 | Bed | 645
2 | Shoes | 465
3 | Shoes | 156
3 | Skirt | 456
3 | Skirt | 546
4 | Fridge | 554
4 | Fridge | 645
4 | Bed | 546
5 | Shoes | 123
5 | Shoes | 897
5 | Skirt | 546
6 | Skirt | 458
6 | Fridge | 984
6 | Fridge | 214
Spreadsheet: 0791d3d9-ae77-4c49-bd54-8b3347914f8a
Sheet: 1995-96

Table N
Students Domiciled within the UK by Method of Study
Country/Region | Undergraduate |  |  | Graduate |  |  | Total
 | Full Time | Part Time | Total | Full Time | Part Time | Total
England
Greater London | 2872 | 47 |  | 872 | 599
South East | 2230 | 25 |  | 473 | 291
South West | 593 | 4 |  | 113 | 31
North and Yorkshire | 318 | 5 |  | 67 | 25
North West | 286 | 5 |  | 86 | 13
Midlands | 578 | 10 |  | 147 | 44
East Anglia | 276 | 2 |  | 72 | 34
Not Known | 0 | 0 |  | 2 | 2
Subtotal
Northern Ireland | 28 | 0 |  | 7 | 4
Scotland | 76 | 0 |  | 48 | 10
Wales | 177 | 0 |  | 43 | 12
Channel Isles and Isle of Man | 16 | 0 |  | 3 | 1
Not Known | 10 | 23 |  | 4 | 5
Total
This table is concerned with students whose domicile at the time of application is within the UK irrespective of nationality.
The sum of Tables N and O is equivalent to the total number of students attending UCL.
Spreadsheet: 728888d1618767117-dragging-down-formulaa-drag-formula
Sheet: Drag

[NAME] | bbb | aabrt | bbbtrt | aa | b |  |  |  |  |  |  | COUNTIF($A$1:$F$1,"abc*") + COUNTIF($A$1:$F$1,"aaa*") + COUNTIF($A$1:$F$1,"bbb*")
[NAME] | aaa | bbb | aaa | aaa
Spreadsheet: 684791d1593537327-create-2d-matrix-of-values-from-data-in-3-columns-using-lookups-matrix-lookup
Sheet: F2021

 |  |  |  | FY21 | FY21 | FY 21 | FY21 |  | FY22
 | Est. Revenue | Fiscal Year | Fiscal Quarter | Q1 | Q2 | Q3 | Q4 | Total | Q1 | Q2 | Q3 | Q4 | Total
 | 25000 | FY21 | Q1
 | 26500 | FY21 | Q2
 | 28000 | FY21 | Q3
 | 29500 | FY21 | Q4
 | 31000 | FY22 | Q2
 | 32500 | FY22 | Q4
 | 34000 | FY22 | Q3
 | 35500 | FY21 | Q1
 | 37000 | FY22 | Q1
 | 38500 | FY22 | Q4
 | 40000 | FY22 | Q2
 |  | FY21 |  |  |  | FY21 Total | FY22 |  |  |  | FY22 Total
 |  | Q1 | Q2 | Q3 | Q4 |  | Q1 | Q2 | Q3 | Q4
 | Sum of Est. Revenue | 60500 | 26500 | 28000 | 29500 | 144500 | 37000 | 71000 | 34000 | 71000 | 213000
Spreadsheet: 709313d1608244013-formula-to-highlight-duplicate-name-cells-in-multiple-rows-and-mult-columns-based-on-date-duplicate-name-finder
Sheet: Sheet1

 | date | crew member 1 | crew member 2 | crew member 3 | crew member 4 | crew member 5
 | 2020-09-28 00:00:00 | fred | bob | [NAME] | [NAME]
 | 2020-09-28 00:00:00 | shannon | jill | ed
 | 2020-09-28 00:00:00 | emily | [NAME] | fred
 | 2020-09-28 00:00:00 | [NAME] | [NAME] | [NAME]
 | 2020-09-29 00:00:00 | fred | bob | ed
 | 2020-09-29 00:00:00 | shannon | [NAME] | [NAME]
 | 2020-09-29 00:00:00 | [NAME] | emily | fred
 | 2020-09-30 00:00:00 | ed | emily | [NAME]
 | 2020-10-01 00:00:00 | ed | [NAME] | [NAME]
 | 2020-10-01 00:00:00 | shannon | jill | ed
 | 2020-10-01 00:00:00 | bob | fred | [NAME]
 | 2020-10-01 00:00:00 | jill | [NAME] | shannon
Spreadsheet: 750755d1633619341-petty-cash-daily-report-working-sheet
Sheet: Report 2-Oct 

 | Statement for: | 1 | 2021-10-01 00:00:00 |  | Current Date | Opening Balance
 |  |  |  |  |  | Closing Balance
 |  |  |  |  | Total Todate | Cash In
 |  |  |  |  |  | Cash Out
 | DATE | TYPE | [NAME] | Invoice Ref | CASH IN | CASH OUT | BALANCE
 |  |  | Opening Balance
Spreadsheet: 125730d1319202126-lookup-into-range-planmatch
Sheet: Sheet1

Plan A |  |  |  |  |  |  |  |  |  |  |  |  | Plan B
 | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 | Col 10 | Col 11 |  |  | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 | Col 10 | Col 11
ROW 1 | 1000 | 3144 | 1001 | 3187 | 3186 | 3191 | 3193 | 1005 | 3081 | 3083 | 1065 |  | ROW 1 | 1000 | 2000 | 1001 | 2001 | 1002 | 1003 | 1005 | 1065 | 1066 | 1067 | 2043
ROW 2 | 3142 | 3190 | 3188 | 1003 | 1010 | 3148 | 3189 | 1039 | 1041 | 3085 | 1066 |  | ROW 2 | 1006 | 1007 | 1008 | 1009 | 2330 | 1011 | 1012 | 2011 | 1071 | 2044 | 1068
ROW 3 | 1042 | 1007 | 1014 | 1006 | 1008 | 1002 | 1025 | 1013 | 3158 | 1071 | 3084 |  | ROW 3 | 1010 | 2019 | 2347 | 1015 | 2005 | 1016 | 2006 | 1017 | 1018 | 1077 | 1078
ROW 4 | 1026 | 3162 | 1037 | 1020 | 3155 | 1036 | 3171 | 1009 | 3159 | 3164 | 3163 |  | ROW 4 | 1014 | 2323 | 1020 | 1021 | 1022 | 1023 | 1024 | 2008 | 1025 | 1074 | 2047
ROW 5 | 3145 | 1028 | 3167 | 1022 | 1033 | 3170 | 3141 | 3182 | 1030 | 3161 | 1094 |  | ROW 5 | 2026 | 1027 | 1028 | 2010 | 1013 | 1029 | 2012 | 1039 | 2024 | 2049 | 1085
ROW 6 | 1031 | 3166 | 1027 | 3178 | 3180 | 1021 | 3172 | 3146 | 3156 | 1040 | 3069 |  | ROW 6 | 2013 | 2014 | 1032 | 1033 | 2272 | 1034 | 2023 | 1030 | 2332 | 2054 | 2061
ROW 7 | 1019 | 3183 | 3192 | 3185 | 1016 | 3153 | 1032 | 3150 | 3074 | 3075 | 1077 |  | ROW 7 | 1031 | 2273 | 1036 | 2017 | 1037 | 1035 | 1040 | 2022 | 1041 | 1090 | 2312
ROW 8 | 1046 | 3168 | 1034 | 3181 | 1038 | 3177 | 1029 | 1044 | 3149 | 3070 | 1085 |  | ROW 8 | 1042 | 2020 | 2043 | 2309 | 1044 | 2021 | 1038 | 1045 | 2274 | 1094 | 2064
ROW 9 | 1056 | 3184 | 3176 | 1023 | 3175 | 1015 | 3152 | 1043 | 1011 | 1012 | 1095 |  | ROW 9 | 1046 | 2019 | 1047 | 2313 | 1049 | 1050 | 1051 | 1052 | 1053 | 2066 | 2329
ROW 10 | 1307 | 1047 | 1052 | 1051 | 1059 | 1306 | 1050 | 1049 | 1054 | 1018 | 1096 |  | ROW 10 | 1056 | 2026 | 1057 | 2027 | 2275 | 1058 | 2269 | 1059 | 2334 | 1101 | 1102
ROW 11 | 3140 | 1024 | 1060 | 1057 | 1062 | 1061 | 3147 | 3154 | 1045 | 1035 | 3071 |  | ROW 11 | 1307 | 1060 | 2031 | 1062 | 1306 | 2033 | 1062 | 1054 | 1106 | 1100 | 1107
ROW 12 | 1053 | 3165 | 3179 | 1063 | 1058 | 1064 | 1038 | 3160 | 1017 | 3068 | 1106 |  | ROW 12 | 2308 | 2276 | 1063 | 2039 | 1064 | 1308 | 2034 | 2270 | 2078 | 2277 | 2082
Match Plan A
 | Col 1 | Col 2 | Col 3 | Col 4 | Col 5 | Col 6 | Col 7 | Col 8 | Col 9 | Col 10 | Col 11
ROW 1 | match | no match | match | no match | no match
ROW 2
ROW 3
ROW 4
ROW 5
ROW 6
ROW 7
ROW 8
ROW 9
ROW 10
ROW 11
Spreadsheet: 875019d1721569672-how-to-create-a-shortcut-to-transform-the-green-conditional-formatting-in-1-mpp-post-dif-position
Sheet: Statistiques

 | Position Per Discipline | Étiquettes de colonnes |  |  |  |  |  |  |  |  |  | Q1 2025 |  |  | Q2 2025 |  |  | Q3 2025 |  |  | Q4 2025 |  |  | Q1 2026 |  |  | Q2 2026 |  |  | Q3 2026 |  |  | Q4 2026 |  |  | Q1 2027 |  |  | Q2 2027 |  |  | Q3 2027 |  |  | Q4 2027 |  |  | Q1 2028 |  |  | Q2 2028 |  |  | Q3 2028
 | Étiquettes de lignes | Construction | Drilling | Engineering | Field Ops | HSE | Interfaces | PCM | Project | Quality | Total général | 39 | 39 | 40 | 117 | 133 | 139 | 140 | 140 | 158 | 158 | 163 | 185 | 191 | 190 | 199 | 202 | 199 | 196 | 196 | 187 | 191 | 190 | 187 | 187 | 187 | 187 | 187 | 187 | 187 | 184 | 187 | 187 | 183 | 183 | 183 | 123 | 123 | 55 | 55 | 55 | 45 | 45 | 45
 | CPF | 1 |  | 27 | 33 | 11 | 1 | 14 | 21 | 18 | 126
 | DRL |  | 1 |  |  |  |  |  |  |  | 1
 | EWI |  |  | 3 |  | 5 | 1 | 2 | 7 | 5 | 23
 | EXP |  |  |  | 19 |  |  |  |  |  | 19
 | NWP |  |  | 11 |  | 5 | 1 | 11 | 19 | 5 | 52
 | PMT |  |  |  | 1 | 7 | 4 | 10 | 7 | 2 | 31
 | Total général | 1 | 1 | 41 | 53 | 28 | 7 | 37 | 54 | 30 | 252
 | Position Per localisation | Étiquettes de colonnes
 | Étiquettes de lignes | EPC- CPF Offices | EPC- NWP Offices | ME + Site | ME base | NA | Site | TBD | Total général
 | CPF | 58 |  |  |  | 34 | 34 |  | 126
 | DRL |  |  |  | 1 |  |  |  | 1
 | EWI |  |  | 2 |  |  | 20 | 1 | 23
 | EXP |  |  |  | 14 | 3 |  | 2 | 19
 | NWP |  | 19 | 1 | 1 | 10 | 21 |  | 52
 | PMT | 1 |  |  | 5 | 1 | 4 | 20 | 31
 | Total général | 59 | 19 | 3 | 21 | 48 | 79 | 23 | 252
 | Headcount per Discipline | Étiquettes de colonnes
 | Étiquettes de lignes | Construction | Drilling | Engineering | Field Ops | HSE | Interfaces | PCM | Project | Quality | Total général
 | CPF | 1 |  | 32 | 53 | 21 | 1 | 18 | 37 | 30 | 193
 | DRL |  | 1 |  |  |  |  |  |  |  | 1
 | EWI |  |  | 5 |  | 10 | 1 | 3 | 12 | 9 | 40
 | EXP |  |  |  | 19 |  |  |  |  |  | 19
 | NWP |  |  | 12 |  | 10 | 1 | 15 | 36 | 9 | 83
 | PMT |  |  |  | 1 | 10 | 4 | 10 | 8 | 2 | 35
 | Total général | 1 | 1 | 49 | 73 | 51 | 7 | 46 | 93 | 50 | 371
 | Headcount per Localisation | Étiquettes de colonnes
 | Étiquettes de lignes | EPC- CPF Offices | EPC- NWP Offices | ME + Site | ME base | NA | Site | TBD | Total général
 | CPF | 59 |  |  |  | 68 | 66 |  | 193
 | DRL |  |  |  | 1 |  |  |  | 1
 | EWI |  |  | 2 |  |  | 37 | 1 | 40
 | EXP |  |  |  | 14 | 3 |  | 2 | 19
 | NWP |  | 20 | 1 | 1 | 20 | 41 |  | 83
 | PMT | 1 |  |  | 5 | 2 | 7 | 20 | 35
 | Total général | 60 | 20 | 3 | 21 | 93 | 151 | 23 | 371
Spreadsheet: 871611d1718041876-if-statement-where-a-specific-word-is-needed-and-a-amount-is-entered-into-another-cell-market-tracker-template
Sheet: Proposals 24

New Client
2024 Proposals Date | Status Win/Loss | Client | New / Exist | Project | Total Submitted | Total Won Fee | Arch | MEP | Structural | Civil | Permitting | Const. [NAME] | Suveys | Signage | [NAME] SOW | Sub Consultants | Reimbursable | Construction | Notes
2024 Proposals
2024-01-23 00:00:00 | LOST | Client ABC | Status | Project Description |  |  | 22340 | 6000 | 6800 |  | 5000 | 5000
2024-04-15 00:00:00 | Status | Client DEF | Existing | Project Description |  |  | 26700 | 15650 |  |  |  |  |  |  | 15980
2024-05-12 00:00:00 | WIN | Client GHI | Status | Project Description |  |  | 2494 | 14000 | 5000 |  | 2500 | 36800
2024-05-22 00:00:00 | Client Reviewing | Client JKL | Status | Project Description |  |  |  | 26700 | 19000 |  | 4000 | 1000
2024-06-01 00:00:00 | LOST | Client MNO | Status | Project Description |  |  | 750 |  |  |  | 200
2024-06-10 00:00:00 | WIN | Client PQR | Status | Project Description |  |  |  |  |  | 85000 | 15000 | 7500 | 24000 |  | 2500
Spreadsheet: cara_semperger__1438__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (18)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | DAILY DEAL= 4 ALL HOURS (WE BUY)
 |  |  |  |  | Mid Columbia Paths
2001-11-18 00:00:00
 | ALL HOURS
 | DAY | 2 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 20 | CHPD GEN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 4 | GEN MIDC | X | PGE | ENRON | AIRPROD | X | PSEI-LOAD
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD