tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: lynn_blair__24313__2002 IGNACIO_LA PLATA BUDGET
Sheet: Attch#1

[NAME]
2002 O&M BUDGET
ATTACHMENT #1
 |  |  |  |  |  |  |  | SALARIES AND WAGES - 000 |  |  |  |  | EMPLOYEE EXPENSES - 050
 |  |  |  |  |  | SALARIES | TAXES/BENEFITS | TOTAL | 2001 EMPL | STAFF ADDS | 2002 EMPL |  | SMNR/SCHL | DUES | BUSINESS | TOTAL
 | LA PLATA "A" COMPRESSOR STATION |  |  |  |  | 75318 | 23514 |  | 2 | 0 | 2 |  | 0 | 0 | 13305
 |  | COLORADO PIPELINE |  |  |  | 19936 | 6223 |  | 0.6 | 0 | 0.6 |  | 0 | 0 | 3326
 |  | NEW MEXICO PIPELINE |  |  |  | 15508 | 4842 |  | 0.4 | 0 | 0.4 |  | 0 | 0 | 2217
 |  |  | TOTAL
 |  |  |  |  |  |  | COMPANY EQUIP USE - 100 |  |  |  | SUPPLIES AND EXPENSES - 150
 |  |  |  |  |  | NUMBER | EXPENSE | POOL CAR | TOTAL |  | CHEMICALS | ELECT POWER | OTHERS | ENVIRON | TOTAL
 | LA PLATA "A" COMPRESSOR STATION |  |  |  |  | 0 | 22175 | 0 |  |  | 2217 | 11087 | 44349 | 5543
 |  | COLORADO PIPELINE |  |  |  | 0 | 8870 | 0 |  |  | 0 | 2217 | 26609 | 0
 |  | NEW MEXICO PIPELINE |  |  |  | 0 | 2217 | 0 |  |  | 0 | 2217 | 22175 | 0
 |  |  | TOTAL
 |  |  |  |  |  | OUTSIDE SERVICES - 200 |  |  |  |  | RENTS - 250
 |  |  |  |  |  | CNTRCTS | TMPRR | OTHERS | TOTAL |  | EQP | WRHS | OTHERS | TOTAL
 | LA PLATA "A" COMPRESSOR STATION |  |  |  |  | 0 | 0 | 35479 |  |  | 0 | 0 | 5543
 |  | COLORADO PIPELINE |  |  |  | 0 | 0 | 24392 |  |  | 0 | 0 | 1108
 |  | NEW MEXICO PIPELINE |  |  |  | 0 | 0 | 19957 |  |  | 0 | 0 | 1108
 |  |  | TOTAL
 |  |  |  |  |  | COMPUTER SERVICES - 600 |  |  |  |  | TOTAL | TOTAL | BUDGET
 |  |  |  |  |  | PC'S | CMNCTN | TOTAL |  |  | P/R | NON P/R | TOTAL
 | LA PLATA "A" COMPRESSOR STATION |  |  |  |  | 0 | 8870
 |  | COLORADO PIPELINE |  |  |  | 0 | 3328
 |  | NEW MEXICO PIPELINE |  |  |  | 0 | 2217
 |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | SUMMARY
 |  |  |  |  |  | NUMBER OF |  |  | SALARIES | EMPLOYEE | COMPANY | SUPPLIES | OUTSIDE |  | COMPUTER | TOTAL
 |  | GROSS |  |  |  | EMPLOYEES | TAXES/BENEFITS |  | & WAGES | EXPENSES | EQP USE | EXPENSES | SERVICES | RENTS | SERVICES | NON P/R | TOTAL
 | LA PLATA "A" COMPRESSOR |  |  |  |  | 2
 | COLORADO PIPELINE |  |  |  |  | 0.6
 | NEW MEXICO PIPELINE |  |  |  |  | 0.4
 | TOTAL GROSS
NOTE:  DOES NOT INCLUDE 15% OPERATOR'S DIRECT EMPLOYEE LABOR COSTS (OVERHEAD)
TRANSWESTERN OPERATIONS (LA PLATA "A" STATION) 95.0% OF GROSS  $ 235,030
TRANSWESTERN OPERATIONS (IGNACIO P/L'S COLORADO/NEW MEXICO) 82.60% OF GROSS  $ 139,153
TOTAL TRANSWESTERN OPERATIONS  $ 374,183
NORTHWEST PIPELINE (LA PLATA "A" STATION) 5.0% OF GROSS  $ 12,370
NORTHWEST PIPELINE (IGNACIO P/L'S COLORADO/NEW MEXICO) 17.40% OF GROSS  $ 29,314
TOTAL NORTHWEST PIPELINE  $ 41,684
Spreadsheet: 143724d1330538038-excel-2007-accounting-for-blank-cells-in-if-functions-qual-surv-sample-forum
Sheet: Sheet1

Survey - None | Complete - No Issues | Complete - With Issues | [NAME] and Organized | Console/Roll-in/Imaging cab | CCTV  Operational | Intercom Operational | In-Rm Microphone Operational | Documentation Organized
 |  |  | Y | N/A | N/A | N/A | N/A | Y
 |  |  | Y | N/A | N/A | N/A | N/A | Y
 |  |  | Y | N/A | N/A | N/A | N/A | Y
Spreadsheet: holden_salisbury__12308__Pac_july_tran_v2
Sheet: Sheet1

 | Data |  |  |  |  | PAC INVOICE
Act Date | Sum of Gross MW | Average of Price | Sum of Total Amt |  |  | Path |  |  | MW's |  | $
2001-07-01 00:00:00 | -852 | 1.431666692097982 | -3526.68 |  |  | MDGT/REDB
2001-07-02 00:00:00 | -721 | 3.213529447667739 | -2768.24 |  |  |  | HOURLY |  | 2430 | NF | 14191.2
2001-07-03 00:00:00 | -612 | 1.241428571428572 | -3545.88 |  |  |  | DAILY |  | 4440 | NF | 37665
2001-07-04 00:00:00 | -702 | 2.1725 | -3377.28 |  |  |  |  | SUB TOTAL |  |  | 51856.2
2001-07-05 00:00:00 | -612 | 1.448333333333333 | -2851.68 |  |  | PACW/BPAT
2001-07-06 00:00:00 | -548 | 1.959 | -2458.72 |  |  |  | HOURLY |  | 4136 | NF | 24154.2
2001-07-07 00:00:00 | -548 | 1.959 | -2458.72 |  |  |  | DAILY |  | 7440 | F | 20250
2001-07-08 00:00:00 | -852 | 1.718 | -3176.28 |  |  |  |  | SUB TOTAL |  |  | 44404.24
2001-07-09 00:00:00 | -612 | 1.431666666666667 | -3176.28
2001-07-10 00:00:00 | -548 | 1.959 | -2802.52 |  |  |  |  | TOTAL
2001-07-11 00:00:00 | -548 | 1.959 | -2802.52
2001-07-12 00:00:00 | -548 | 1.375 | -2055
2001-07-13 00:00:00 | -548 | 1.959 | -2802.52
2001-07-14 00:00:00 | -548 | 1.959 | -2802.52
2001-07-15 00:00:00 | -660 | 0.55 | -2410.8
2001-07-16 00:00:00 | -548 | 1.959 | -1763.32
2001-07-17 00:00:00 | -420 | 1.75 | -1010.4
2001-07-18 00:00:00 | -420 | 1.65 | -1010.4
2001-07-19 00:00:00 | -420 | 1.527777777777778 | -1010.4
2001-07-20 00:00:00 | -420 | 1.527777777777778 | -1010.4
2001-07-21 00:00:00 | -420 | 1.527777777777778 | -1010.4
2001-07-22 00:00:00 | -660 | 1.527777777777778 | -2410.8
2001-07-23 00:00:00 | -548 | 1.959 | -1763.32
2001-07-24 00:00:00 | -548 | 1.780909090909091 | -3152.92
2001-07-25 00:00:00 | -548 | 1.861666666666667 | -3152.92
2001-07-26 00:00:00 | -548 | 1.780909090909091 | -3152.92
2001-07-27 00:00:00 | -548 | 1.780909090909091 | -3152.92
2001-07-28 00:00:00 | -548 | 1.780909090909091 | -3152.92
2001-07-29 00:00:00 | -660 | 0.55 | -30859.01
2001-07-30 00:00:00 | -548 | 1.959 | -1757.92
2001-07-31 00:00:00 | -550 | 1.399285714285714 | -26288.35
Grand Total | -17813 | 1.78149305820465 | -128674.96
 |  | ST W SERV | ST W HOURLY | ST SW
EPMI MW |  | 10648 | 165 | 6870
EPMI $ |  | 39252.32 | 963.6 | 67560
PAC MW |  | 11411 | 165 | 6870
PAC $ |  | 43440.64 | 963.6 | 51856.2
[NAME]
LOSSES
ANCILLARY |  | 0 | 0 | 0
TOTAL ANNUITY
Deal numbers truing up transmission |  | 740406.1 | 741715.1 | Adjusted price of deal 700182 to reflect true up.
Spreadsheet: 888466d1738947727-pulldown-list-na-dude-expenses
Sheet: 2025

 | Variable Cost 2025 (Credit Cards) |  |  |  | Hydro |  | Fixed Costs |  |  |  | DDSB Pay
 | # | Months | CIBC | RBC | [NAME] |  |  | Paid Off | Mortgage |  | # | 1st | 2nd | Total
 | 1 | January | 4694.5 | 81.84 | 82.54 |  |  | 235 | Taxes |  | 1 | 2100.64 | 2329.34
 |  | February |  |  |  |  |  | 726.49 | Condo Fees
 |  | March |  |  |  |  |  | 29.04 | OTIP Insurance
 |  | April |  |  |  |  |  | 169.02 | NLSC
 |  | May |  |  |  |  |  |  | Hydro (average)
 |  | June |  |  |  |  | Monthly
 |  | July |  |  |  |  | Yearly
 |  | August
 |  | September |  |  |  |  | Other Fixed Costs (piad on CC)
 |  | October |  |  |  |  | Paid on CIBC credit card under "Variable Cost" | 62.15 | Internet
 |  | November |  |  |  |  |  | 226 | Cell Phones
 |  | December |  |  |  |  |  |  | Insurance
 | Variable Cost |  |  |  |  |  |  | 400 | Gas |  | Total Pay
 | Average |  |  |  |  |  |  | 400 | Eating Out
 | Total Credit Card Spend |  |  |  |  |  |  | 200 | TTC
 | Variable Cost minus "Other Fixed Costs (piad on CC)" |  |  | Fixed Costs | Cash Spending |  | Monthly
 |  |  |  |  |  |  | Yearly
 |  |  | 2024 Total Expenditure |  | 70000 |  | One Time Pay | 275.88 | Life Insurance
 |  |  | 2025 Total Expenditure |  |  |  |  | 229.9 | Life insurance
 |  |  | Diffrence (2024 - 2025): |  |  |  | Yearly
 |  |  |  |  |  |  | Total Yearly
 |  |  |  |  |  |  | Fixed Monthly |  | January
 |  |  | Diffrence (Pay - Expenditure): |  |  |  | Variable Monthly
 |  |  | 2025 Montly Expenditure |  |  |  | Total Monthly
Spreadsheet: 86d895c3-1a8b-4c5a-a4d7-e154c34aa02f
Sheet: 4.2 MV sales

4.2 Motor vehicle sales
Month | 2010-11 | 2011-12 | 2012-13 | 2013-14 | 2014-15
Total vehicle sales (a)
July | 85865 | 85506 | 93432 | 94456 | 93066
August | 85190 | 86031 | 94456 | 94378 | 93103
September | 84714 | 86366 | 95350 | 94390 | 93105
October | 84531 | 86510 | 95981 | 94384 | 93080
November | 84599 | 86573 | 96186 | 94277
December | 84749 | 86865 | 95944 | 93980
January | 84816 | 87573 | 95488 | 93505
February | 84707 | 88599 | 95111 | 93000
March | 84555 | 89661 | 94927 | 92633
April | 84483 | 90633 | 94866 | 92496
May | 84579 | 91562 | 94776 | 92638
June | 84962 | 92464 | 94605 | 92913
Annual (c) | 1000642 | 1060055 | 1137889 | 1122467
This month compared to same month in previous year - per cent change (a)
July | 12.93568328291464 | -0.4180981773714552 | 9.269524945617851 | 1.095984245226475 | -1.471584653171847
August | 9.94244121518726 | 0.987205071017725 | 9.792981599655938 | -0.08257813161683747 | -1.350950433363708
September | 7.208484142853528 | 1.950090894067096 | 10.40224162286085 | -1.006816990036707 | -1.361373026803687
October | 4.881074977976848 | 2.341152949805397 | 10.9478672985782 | -1.663870974463696 | -1.381590100016952
November | 2.898462586357887 | 2.333360914431613 | 11.10392385616763 | -1.984696317551411
December | 1.185586704236115 | 2.496784622827408 | 10.4518505727278 | -2.047027432669057
January | -0.3325538490464048 | 3.250565930956423 | 9.03817386637434 | -2.076700737265416
February | -1.702369624248613 | 4.594661598215024 | 7.349970089955869 | -2.219511938682171
March | -2.685065831875518 | 6.038673053042398 | 5.873233624429797 | -2.416593803659654
April | -3.13248867740641 | 7.2795710379603 | 4.670484260699745 | -2.498260704572766
May | -2.893259394482141 | 8.256186523841617 | 3.5101898167362 | -2.255845361694944
June | -1.871058649603844 | 8.82982980626633 | 2.315495760512199 | -1.788488980497859
Annual (c) | -1.246554482355693 | 5.937488132618859 | 7.34244921254086 | -1.355316731245315
(a) Monthly figures (including the graph) are calculated on the trend series. Annual figures are calculated on the original series. |  |  |  |  |  |  |  | Update xx
(b) The statistics are based on the VFACTS series produced by the Federal Chamber of Automotive Industries (FCAI). VFACTS reports the numbers of new motor vehicle sales by dealers and direct sales by manufacturers throughout Australia.
(c) 12 months ended June.
 |  |  |  |  |  |  |  | Update
Source: ABS, Sales of New Motor vehicles, Australia, Cat. no. 9314.0 |  |  |  |  |  |  |  | 2014-12-15 00:00:00
Spreadsheet: sally_beck__35449__key indiv
Sheet: Sheet1

 |  | Key Individuals listing
 |  | EES and Global Services Operations
1 | Sr Director | [NAME] O'neil |  | Settlements
2 | Sr Director | [NAME] |  | Settlements
3 | Sr Director | [NAME] |  | Risk
4 | Sr Director | [NAME] |  | Settlements
5 | Director | [NAME] |  | Strategic Systems
6 | Director | [NAME] |  | Deal Capture
7 | Director | [NAME] |  | Settlements
8 | Director | Lymann Wilkes |  | Global Sites Data
9 | Director | [NAME] |  | Power Risk
10 | Manager | [NAME] |  | Gas Risk
11 | Manager | [NAME] |  | DSM Risk
12 | Manager | [NAME] |  | Settlements
13 | Manager | [NAME] |  | [NAME]
14 | Manager | [NAME] |  | Settlements/PG&E
15 | Manager | [NAME] |  | Gas Swat team
16 | Manager | [NAME] |  | Data Capture |  | (transfering to EES)
17 | Manager | [NAME] |  | Deal Capture
18 | Manager | [NAME] |  | Global Counterparty
19 | Manager | [NAME] |  | Global Counterparty
20 | Manager | [NAME] |  | Contracts
21 | Manager | [NAME] |  | Contracts
22 | Manager | [NAME] |  | DPR
23 | Manager | [NAME] |  | Risktrac Data
24 | Associate | [NAME] |  | Volume Management
25 | Associate | [NAME] |  | Risk
26 | Sr Specialist | [NAME] |  | Global Sites data
27 | Sr Specialist | [NAME] |  | New Markets
28 | Sr Specialist | [NAME] |  | Contracts
29 | Sr Specialist | Adarsh Vakharia |  | Merchant Portfolio
30 | Sr Specialist | [NAME] |  | Power Risk
31 | Sr Specialist | [NAME] |  | Gas Risk
32 | Sr Specialist | [NAME] |  | Risk
33 | Specialist | [NAME] |  | Customer Enrollment
34 | Specialist | [NAME] |  | Settlements
35 | Specialist | Bernice Rodriguez |  | Global Counterparty
36 | Specialist | [NAME] |  | Global Rates
37 | Specialist | [NAME] |  | Deal capture
38 | Specialist | Pam Carter |  | Volume Management
39 | Specialist | [NAME] |  | Risktrac Data
40 | Staff | [NAME] |  | Global Counterparty
41 | Staff | [NAME] |  | Global Counterparty
42 | Staff | [NAME] |  | Contracts
43 | Staff | [NAME] |  | Contracts
 | Total staff 288
Spreadsheet: 801119d1666091702-add-word-or-between-the-two-words-adding-word-or-between-the-two-words
Sheet: Sheet2

1 | T9626263 | OR | T9626263ORP2437263ORP7499729ORT0227709ORZ3090777ORS4962293ORP4392209ORT7026263ORT0249939ORS6022997ORS6622409ORZ9067042ORZ2623706ORP0243624ORS6707226ORP7329060ORT9326999ORZ9393470ORP0766034ORP9493666OR
2 | P2437263
3 | P7499729
4 | T0227709
5 | Z3090777
6 | S4962293
7 | P4392209
8 | T7026263
9 | [NAME]
10 | S6022997
11 | S6622409
12 | Z9067042
13 | Z2623706
14 | P0243624
15 | S6707226
16 | P7329060
17 | T9326999
18 | Z9393470
19 | P0766034
20 | P9493666
Spreadsheet: 787650d1657903982-list-required-fields-in-column-based-on-drop-down-value-list-required-fields
Sheet: Expected

Mat.Type
[NAME] | If I select [NAME]
 | MARA-MBRSH | MARA-MTART | MARA-MAKTX | MARA-MEINS | MARA-MATKL | MARA-SPART | MARA-MTPOS_MARA | MARC-WERKS | MVKE-VKORG | MVKE-VTWEG | MVKE-DWERK | MVKE-KTGRM | MVKE-MTPOS | MVKE-MVGR1 | MARC-MTVFP | MARA-TRAGR | MARC-LADGR | MARC-PRCTR | [NAME] | MARC-DISMM | MARC-DISPO | MARC-DISLS | MARC-FHORI | PROP-PRMOD | MARC-FEVOR | MBEW-BKLAS | MBEW-STPRS | MBEW-HKMAT
 | Industry sector | Material Type | Material Description | Base Unit | Material Group | Division | GenItemCatGroup | Plant | Sales Org. | Distr.Channel | Deliver.Plant | Acct asgnmt grp | Item cat.group | Brand | Availability Check | Trans. Group | Loading Group | Profit Center | Export/Import group | MRP Type | MRP controller | Lot size | SchedMargin key | Forecast model | Prodn Superv. | Valuation Class | Standard price | Material origin
ERSA | If I select ERSA
 | MARA-MBRSH | MARA-MTART | MARA-MAKTX | MARA-MEINS | MARA-MATKL | MARA-SPART | MARA-MTPOS_MARA | MARC-DISMM | MARC-DISPO | MARC-DISLS | MARC-FHORI
 | Industry sector | Material Type | Material Description | Base Unit | Material Group | Division | GenItemCatGroup | MRP Type | MRP controller | Lot size | SchedMargin key
 |  | MARA-MTART | MARA-MAKTX | MARA-MEINS | MARA-MATKL | MARA-SPART | MARA-MTPOS_MARA | MARC-WERKS | MVKE-VKORG | MVKE-VTWEG | MVKE-DWERK | MVKE-KTGRM | MVKE-MTPOS | MVKE-MVGR1 | MARC-MTVFP | MARA-TRAGR | MARC-LADGR | MARC-PRCTR | [NAME] | MARC-DISMM | MARC-DISPO | MARC-DISLS | MARC-FHORI | PROP-PRMOD | MARC-FEVOR | MBEW-BKLAS | MBEW-STPRS | MBEW-HKMAT
 | Industry sector | Material Type | Material Description | Base Unit | Material Group | Division | GenItemCatGroup | Plant | Sales Org. | Distr.Channel | Deliver.Plant | Acct asgnmt grp | Item cat.group | Brand | Availability Check | Trans. Group | Loading Group | Profit Center | Export/Import group | MRP Type | MRP controller | Lot size | SchedMargin key | Forecast model | Prodn Superv. | Valuation Class | Standard price | Material origin
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 12c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency TOTAL | 6531 | 1497 | 8872 | 4872 | 24478 | 19226 | 14880 | 455
Spreadsheet: 65030d1265805474-auto-update-or-resync-values-in-data-validated-lists-elec-toolkit-v6
Sheet: Motor Calcs (Generic)

 |  |  |  |  | 3 Ph Motor |  |  | 1 Ph Motor
 | No. Motor Poles | 4 |  | Voltage | 400 | V | Voltage | 230 | V
 | Motor Speed | 1500 | rpm | Power | 0.5 | KW | Power | 0.25 | KW
 |  |  |  | FL Current |  | A | Current |  | A
 |  | Optional Motor Data |  | Power Factor | 0.78 | Auto Selected from tables | Power Factor | 0.9 | Manually Entered
 | Mass for Fly Wheel |  | Kg | Motor Efficiency | 75 | Auto Selected from tables | Motor Efficiency | 1 | Manually Entered
 | Outer Radius |  | m | Apparent Power | 0.641025641025641 | KVA | Apparent Power | 0.2777777777777778 | KVA
 | [NAME] |  | m | Motor Torque | 3.183333333333333 | Nm | Current = | 1.207729468599034 | Amps
 | Moment of Inertia | 0 | Kgm2 | FL Current = | 1.233654421345354 | Amps
 |  | Pump Data
 | Flow | 30 | l/s
 | Head | 12 | m
 | Pump Effy | 75 | %
 | Motor Effy | 85 | %
 | Power at Shaft | 4.707192 | KW
 | Power at Motor | 5.537872941176471 | KW
 |  |  |  |  | Cable Sizing Wizard (Calculated in accordance with BS7671:2008)
 |  |  |  |  |  |  |  | Results
 |  |  |  |  |  |  | Cable Size |  | mm2
 |  |  |  | Supply Voltage | 400 | V | Cable Makeup
 |  |  |  | Design Current Ib | 100 | A | Cable Rating (lt) |  | A
 |  |  |  |  |  |  | Min. Cable Capacity (lz) |  | A
 |  |  |  | Type of Cable | Single-core 70°C thermoplastic non-arm Cu Table 4D1 |  | Sep. [NAME] |  | mm2
 |  |  |  | Instalation Method Selection (Step 1) | Cable tray, ladder system, cleats, wire mesh tray |  | Device (ln/lr) |  | A
 |  |  |  | Instalation Method Selection (Step 2) | 33 - Spaced from a wall |  | Voltage Drop |  | V
 |  |  |  | Configuration | Horizontal flat spaced |  | [NAME] for Voltage Drop |  | m
 |  |  |  |  |  |  | Zs at Load End |  | Ω
 |  |  |  | Neutral Conductor Sizing Method |  |  | [NAME] |  | Ω
 |  |  |  |  |  |  | Earth Fault Current |  | KA
 |  |  |  |  |  |  | Earth Fault Discon. Time |  | s
 |  |  |  |  |  |  | Min. Phase Fault Current |  | KA
 |  |  |  |  |  |  | PSCC |  | KA
 |  |  |  | Length of cable | 100 | m | Icu |  | KA
 |  |  |  | Permissible Volt Drop | 30 | %
 |  |  |  | [NAME] | 12 | mV/a/m
 |  |  |  | Single or [NAME] | Single
 |  |  |  | CPD type | BS88
 |  |  |  | CPD Rating (In) | 40 | A
 |  |  |  | Ambient/ground temperature rating factor (Ca) | 1 | Tables 4B1 - 4B2
 |  |  |  | Thermal insulation rating factor ([NAME]) | 0.8
 |  |  |  | CPD/installation condition rating factor (Cc) | 0.725
Spreadsheet: darrell_schoolcraft__7332__2002 SJ Outages
Sheet: August - September

SAN JUAN AREA ANNUAL OUTAGE MEETING SUMMARY
MARCH 7, 2002
August, 2002 |  |  |  |  | September 2002
 |  |  | Affected Vol. |  |  |  | Affected Vol.
 | Date | Location | (MMcf/d) |  | Date | Location | (MMcf/d)
TW | None Scheduled |  |  |  | None Scheduled
 |  |  |  |  | Possible LaPlata & Bisti L/R |  | 705/850
El Paso | 1 - 5 | Pecos River PLC | 250 |  | 10 | Rio Vista ESD | 150
 | 5 or 8 | Laguna ESD | 80 |  | 11 | Rio Vista DOT | 100
 | 14 | Navajo ESD | 280 |  | 14 | [NAME] | 650
 | 11 - 16 | Navajo 2C Hot Gas Path | 230 |  | 15 | Caprock Piping | 80
 | 19 - 31 | Flagstaff Maint. | 80
WFS | None Scheduled |  |  |  | 10 - 11 | [NAME] | 30
PNM | 31 | Rio Puerco | 20 |  | 5 | [NAME] | 20
 |  |  |  |  | 26 | [NAME] | 20
EPFS | None Scheduled |  |  |  | None Scheduled
Burlington | None Scheduled |  |  |  | None Scheduled
Spreadsheet: 812926d1673457954-how-to-compare-and-extract-one-cell-in-a-bunch-of-matching-cells-example
Sheet: Sheet1

Invoice # | Name | Amount Billed | Cost Per Shipment | Desired outcome
1 | Freight: | 0
1 | Freight: | 0
1 | Freight: | 0
2 | Freight: | 300.01 |  | 300.01
2 | Freight: | 300.01
2 | Freight: | 300.01
2 | Freight: | 300.01
3 | Freight: | 0 |  | 0
3 | Freight: | 0
3 | Freight: | 0
3 | Freight: | 0
4 | Freight: | 200.51 |  | 200.51
5 | Freight: | 223.88 |  | 223.88
5 | Freight: | 223.88
5 | Freight: | 223.88
6 | Freight: | 0 |  | 0
6 | Freight: | 0
6 | Freight: | 0
6 | Freight: | 0
6 | Freight: | 0
6 | Freight: | 0
6 | Freight: | 0
6 | Freight: | 0
Spreadsheet: 197504d1354395702-adding-days-hours-and-minutes-to-calculate-time-of-end-of-auction-121201-sampledata-forum
Sheet: Sheet1

Time Left | Status of Bid | Current Bid | Address
2 days 0 hr 2 min | property may be occupied | NA | 28230 Pasadena Drive
2 days 3 hr 48 min | property may be occupied | NA | 6221 SW 63 Court
2 days 0 hr 49 min | property may be occupied |  | 5239 Sw 149th Ave
2 days 0 hr 49 min | property may be occupied | 84000 | 1327 Flaxwood Avenue
2 days 2 hr 6 min | Starting Bid: $90,000 | 90000 | 1529 SW 10th Street
2 days 2 hr 58 min | property may be occupied | 66000 | 4015 Forecast Drive
2 days 2 hr 59 min | property may be occupied | NA | 500 Holly Street
2 days 3 hr 10 min | property may be occupied | NA | 3332 [NAME]
2 days 3 hr 20 min | property may be occupied | NA | 402 [NAME]
2 days 3 hr 48 min | property may be occupied | NA | 6221 SW 63 Court
2 days 3 hr 49 min | property may be occupied | 95000 | 13958 East Pointe Court
Spreadsheet: 786646d1657319623-conditional-formatting-to-highlight-column-that-has-matching-on-at-least-4-rows-stock-short-term-comparison-19
Sheet: Sheet1

 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 1 | 2 | 2 | 4 | 4 | 2
all | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 1 | 2 | 2 | 4 | 4 | 5 | 6 | 4
[NAME]) | 0 | 0 | 0 | 0 | 0 | 4 | 2 | 1 | 2 | 2 | 4 | 4 | 7 | 6 | 6
all(s/fexp) | 2 | 0 | 4 | 0 | 1 | 5 | 3 | 3 | 4 | 4 | 5 | 7 | 9 | 9 | 10
all(s/fexp) | 3 | 0 | 5 | 1 | 1 | 6 | 3 | 4 | 4 | 5 | 8 | 9 | 12 | 15 | 15
all(s/fexp) | 4 | 0 | 6 | 1 | 2 | 7 | 4 | 6 | 4 | 7 | 11 | 14 | 18 | 22 | 22
Spreadsheet: 538595d1505737251-when-sorting-a-table-the-sort-isnt-holding-example
Sheet: Data Summary

Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 | Total score | Average score /10 | footprint score /100 |  | Total Score | Average Score /10 | Average Footprint/100 | Footprint rank | Total Score | Average Score /10 | Average Footprint/100 | Footprint rank |  | Total score | Average score /10 | footprint score /100 |  | Total score | Average score /10 | footprint score /100 |  | Total score | Average score /10 | footprint score /100 |  | Total score | Average score /10 | footprint score /100
Spreadsheet: 871651d1718075064-column-months-with-dates-worksheet
Sheet: Sheet1

COD | NAME | FIRST_DATE | LAST_DATE | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
1001 | A | 2024-01-01 00:00:00 | 2024-03-01 00:00:00
1001 | B | 2024-05-01 00:00:00 | 2024-08-01 00:00:00
Spreadsheet: 765570d1643389147-search-string-of-characters-sample_new-proof-of-concept
Sheet: Sample

Column A | Name | Column B | Column C |  |  | solution 1 | solution 2 | solution 3
Data | dfasdf asdfasdf, sadfasdf | Data | Data
Data | [EMAIL] | Data | Data
Data | asdfasdf-asdfasdf | Data | Data
Data | sadfsdf.sdfsdfsd.sfdsdf | Data | Data
Data | sdfsdfsdfsdf/asdfasdfasd | Data | Data
Data | asdas asdasdas | Data | Data
Data | zczxczxc | Data | Data
Data | dfsgsdfg | Data | Data
Data | sdfgsdfg/sdfgsdfg | Data | Data
Data | sdfgsdfg/sdfgsdfg | Data | Data
Data | sdfgsdfg sdfgsdf | Data | Data
CONDITIONAL FORMATTING APPLIED TO RANGE ONLY