tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 75129d1275654288-copy-formula-minlatongolfeclectic
Sheet: 4

HOLE | PAR | ROUND |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BEST
 |  | 2010-04-03 00:00:00 | 2010-04-10 00:00:00 | 2010-04-17 00:00:00 | 2010-04-24 00:00:00 | 2010-05-01 00:00:00 | 2010-05-08 00:00:00 | 2010-05-15 00:00:00 | 2010-05-22 00:00:00 | 2010-05-29 00:00:00 | 2010-06-05 00:00:00 | 2010-06-12 00:00:00 | 2010-06-19 00:00:00 | 2010-06-26 00:00:00 | 2010-07-03 00:00:00 | 2010-07-10 00:00:00 | 2010-07-17 00:00:00 | 2010-07-24 00:00:00 | 2010-07-31 00:00:00 | 2010-08-07 00:00:00 | 2010-08-14 00:00:00 | 2010-08-21 00:00:00 | 2010-08-28 00:00:00 | 2010-09-04 00:00:00 | 2010-09-11 00:00:00 | 2010-09-18 00:00:00 | 2010-09-25 00:00:00
1 | 5 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
2 | 5 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
3 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
4 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
5 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
6 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
7 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
8 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
9 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
10 | 5 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
11 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
12 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
13 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
14 | 5 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
15 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
16 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
17 | 3 | 4 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
18 | 4 | 5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Spreadsheet: 849427d1699911559-how-do-i-extract-data-from-a-table-where-it-meets-certain-criteria-test-quals-spreadsheet-v2
Sheet: Training Needs

 |  | TODAY |  |  | Required/Planned
 |  | 30 DAYS or EXPIRED
 |  | 60 DAYS
 | Employee Information |  |  | Role Specific Training EXPIRY Dates |  |  |  |  |  |  |  |  |  |  |  |  | Additional Training
 | Name | Band | Attends Construction Sites? | Qual 1 | Qual2 | Qual3 | Qual4 | Qual5 | Qual6 | Qual7 | Qual8 | [NAME] | Qual10 | Qual11 | Qual12 | Qual13 | Qual14 | Qual15
 | [NAME] | Assistant Manager | N | 2024-05-18 00:00:00 | N/A | N/A | N/A | N/A | N/A | 2026-07-10 00:00:00 | N/A | 2024-08-18 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Assistant Manager | N | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2024-05-15 00:00:00 | 2024-05-15 00:00:00 | N/A | 2024-08-05 00:00:00 | N/A | N/A | N/A
 | [NAME] | Manager | Y | 2019-09-30 00:00:00 | N/A |  |  | 2023-02-28 00:00:00 |  |  | N/A | 2024-10-09 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | [NAME] | N | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | 2024-10-09 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Manager | Y | 2023-12-01 00:00:00 | N/A | 2028-01-31 00:00:00 | N/A | 2027-12-31 00:00:00 | 2026-02-17 00:00:00 | 2026-07-10 00:00:00 | N/A | 2023-12-01 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | [NAME] | Assistant Manager | Y | 2024-10-29 00:00:00 | N/A | 2027-12-28 00:00:00 | N/A | 2027-12-31 00:00:00 | 2026-02-16 00:00:00 | 2026-07-10 00:00:00 | N/A | 2024-08-24 00:00:00 | N/A | N/A | N/A | N/A | N/A | N/A
 | 04:18:00
 | Training Needs
 |  |  |  | Due in 60 days or less, or expired, or blank - formulas in yellow spill to the right
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 864206d1711468417-formulas-for-vehicle-service-overview-sheet-vehicle-preventive-maintenance-v-dj
Sheet: Vehicle Service Overview

 | Vehicle Overview
 |  | V1 | [NAME] a vehicle from this dropdown. The rest of this page will automatically update.
 | Vehicle
 | VIN#
 | Today's Date
 | Service Performed | Last Service |  |  | Frequency of Service |  | Next Service Due |  | Comments
 |  | Odometer | Date | Cost | [NAME] | Months | Odometer | Date
Spreadsheet: scott_neal__38687__East
Sheet: East - Trading

 | East Gas - Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  | ADJUSTED |  | Costs
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  | 2002 |  | per
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  | Plan |  | Employee
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  | 220000
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | 25000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 25000
ENAOUTSV | Outside Services |  |  |  |  |  |  |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  |  |  |  |  |  |  | 20000
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0 |  |  | 500
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0 |  |  | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0 |  |  | 100000
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0 |  |  | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 1 |  |  | 25000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 3571654.51 | Associate | 89100 | 0 |  |  | 3571655
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 2
 |  |  |  |  |  |  |  | Director | 143000 | 4
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | [NAME] |  |  |  |  |  | Vice President
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Director
 | [NAME] |  |  |  |  |  | Manager
 | [NAME] |  |  |  |  |  | Manager
 | [NAME] |  |  |  |  |  | Analyst
Spreadsheet: 2475fe32-946d-468b-9899-079fca3985af
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Bilag 8
Alle priser skal afgives i danske kr. [NAME]. moms, men inkl. [NAME], og omfatter alle udgifter og omkostninger forbundet med produkterne og leverancerne.  [NAME] felter SKAL udfyldes.
Standardsække, 1 farve
Udvendigt tryk   Standard sække | Specifikationer | Antal | [NAME] pr. 1000 stk | [NAME]
1 farve | 160 liter 2 lag - 1150x750x250 mm - RESTAFFALD - "Nordforbrænding" | 65000 |  | Ukonditionsmæssigt
1 farve | 125 liter, 2 lag - 750x950x250 mm - RESTAFFALD - "Nordforbrænding" | 510000 |  | Ukonditionsmæssigt
1 farve | 110 liter, 2 lag - 700x950x250mm - RESTAFFALD - "Nordforbrænding" | 1600000 |  | Ukonditionsmæssigt
1 farve | 110 liter, 2 lag - 700x950x250mm - RESTAFFALD - "Forsyning Helsingør" | 960000 |  | Ukonditionsmæssigt
1 farve | 45 liter, 2 lag - 600x660x230 mm - RESTAFALD - "Nordforbrænding" | 835000 |  | Ukonditionsmæssigt
1 farve | 110 liter 2 lag - 700x950x250 mm - HAVEAFFALD - "Nordforbrænding" | 46000 |  | Ukonditionsmæssigt
Standardsække, 2 farver
Udvendigt tryk   Standard sække | Specifikationer | Antal | [NAME] pr. 1000 stk | [NAME]
2 farver | 160 liter 2 lag - 1150x750x250 mm - RESTAFFALD - "Nordforbrænding" | 65000 |  | Ukonditionsmæssigt
2 farver | 125 liter, 2 lag - 750x950x250 mm - RESTAFFALD - "Nordforbrænding" | 510000 |  | Ukonditionsmæssigt
2 farver | 110 liter, 2 lag - 700x950x250mm - RESTAFFALD - "Nordforbrænding" | 1600000 |  | Ukonditionsmæssigt
2 farver | 110 liter, 2 lag - 700x950x250mm - RESTAFFALD - "Forsyning Helsingør" | 960000 |  | Ukonditionsmæssigt
2 farver | 45 liter, 2 lag - 600x660x230 mm - RESTAFALD - "Nordforbrænding" | 835000 |  | Ukonditionsmæssigt
2 farver | 110 liter 2 lag - 700x950x250 mm - HAVEAFFALD - "Nordforbrænding" | 46000 |  | Ukonditionsmæssigt
 | Særlige sække
 | Særlig sække/tryk/indpakning | Antal | [NAME] pr. 1000 stk | [NAME]
 | 110 liter, 2 lag 700x950x250mm m. tryk "ekstra"  1 farve: sort+raster  Pakning i 4 stk. pakninger | 10000 |  | Ukonditionsmæssigt
 | 110 liter, 2 lag 700x950x250mm m. særtryk, [NAME](2 farver: sort+rød) | 15000 |  | Ukonditionsmæssigt
 | 240 liter, 2 lag (870x1200x350) skaktsæk [NAME] | 3000 |  | Ukonditionsmæssigt
 | 110 liter, 2 lag 700x950x250mm "m. tryk ekstra Allerød" | 10000 |  | Ukonditionsmæssigt
 | 110 liter, 2 lag 700x950x250mm "m. tryk ekstra Hørsholm" | 20000 |  | Ukonditionsmæssigt
 | 110 liter, 2 lag 700x950x250mm "m. tryk ekstra Rudersdal" | 5000 |  | Ukonditionsmæssigt
 | 125 liter, 2 lag -750x950x250 mm Standardsæk Standard Tryk | 10000 |  | Ukonditionsmæssigt
 | Total |  |  | 0
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Britador Primario - Mina 1

 |  | CENTROS DE CUSTOS
 |  | BRITADOR PRIMARIO - MINA 1
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-09-01 00:00:00 | Combustivel | 54546 | 2784.4 | PowerFloot
 |  | 2020-09-01 00:00:00 | Combustivel | 54546 | 3860.4 | [NAME]
 |  | 2021-02-09 00:00:00 | Combustivel | 55568 | 2308.26 | Compressor
Spreadsheet: 61589d1262526555-two-y-axis-both-using-same-data-series-frost-20iwi-20graphsv1-1-
Sheet: 3- extruded

 | WDR Zone 1 |  | WDR Zone 2 |  | WDR Zone 3 |  | WDR Zone 4
 | Cambridge | London | Grendon Underwood | Wallingford | [NAME] | [NAME] | [NAME] | Rawtenstall
None | 0 | 13.11 | 78.84 | 50.16 | 54.39 | 50.7 | 54.45 | 51.2
WF | 71.28 | 51.04 | 100.08 | 67.55 | 102.61 | 82.17 | 65.96 | 94.21
MW | 70.99 | 51.03 | 100.55 | 68.06 | 102.42 | 80.39 | 66.39 | 92.67
EPS | 72.78 | 51.54 | 102 | 68.45 | 104.79 | 91.13 | 67.66 | 97.62
PF | 75.73 | 53.18 | 104.18 | 69.78 | 107.35 | 93.23 | 69.68 | 99.54
extruded brick wf: 370 |  | 370 is 100%
Extruded brick free water saturation (Wf) |  |  |  | 370 | kg/m3
75% of Wf Fmax |  |  |  | 277.5 | kg/m3
 |  |  |  | 185
 |  |  |  | 92.5
Spreadsheet: 2b11c850-ce10-477c-8b36-1c2f5fdf89b0
Sheet: I

Course color corresponds with term of offering.  RED for fall semester, PURPLE for J-term, GREEN for both fall and J-term.
 | AOK Designation | CAR Designation | Comment
International Studies
INST 245 | Social Sciences OR | Non-Western | cross-listed with EVST 245
 | Natural & Mathematical Sciences-Nat Sci w Lab
INST 251 | Social Sciences
INST 261 | Social Sciences | Experiential -Travel* | * when course travels-the course does not travel for all offerings
INST 270 | Social Sciences
INST 321 | Social Sciences |  | cross-listed with PSCI 321
INST 335 |  | Experiential-Travel
INST 391-392 |  | Experiential-Research
INST 422 |  | Capstone; Experiential-Research
INST 448-449 |  | Capstone
INST 452-453 |  | Capstone
INST 483-484 |  | Capstone
INST 487-488 |  | Experiential-Research
INST 493-494 |  | Capstone; Experiential-Research
INST 496-498 |  | Capstone; Experiential-Research
Spreadsheet: 716477d1612224977-annual-due-date-conditional-formatting-icon-sets-project-management-eba
Sheet: Commenced-ACR

No. | Ref. | Details | Annual Report  Due Date | Assigned to
1 | [NAME] | Caloundra, Queensland |  | <-------- | need to be updated every year | 2021-04-14 00:00:00
2 | [NAME] | Greenbank, Queensland |  | <-------- | need to be updated every year | 2021-12-06 00:00:00
3 | [NAME] | Ipswich Queensland |  | <-------- | need to be updated every year | 2021-09-23 00:00:00
4 | [NAME] | Springfield, Queensland |  | <-------- | need to be updated every year | 2021-01-16 00:00:00
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: Summary

Summary - Operations & Maintenance Cost Estimate
 |  |  |  |  |  |  |  |  |  | MW
Expenses before Commercial Operation:
 |  |  |  | US $
O&M Pre-Mobilization / Mobilization Expenses
 | Pre-Mobilization Expenses
 | Mobilization Payroll and Burden
 | Mobilization Operating Expenses
 | Mobilization Procurement Expenses
 | Total O&M Pre-Mobilization / Mobilization Expenses |  |  |  |  | per kW
 | Housing Colony Mobilization Expenses
 | Commercial Office Mobilization Expenses
 | Owners' Engineer Expenses
 | Initial Operating Spares |  |  |  |  | per kW
 | O&M Mobilization Period Fee |  |  | 40000 |  | per kW
 | Total |  |  |  |  | per kW
 | Owner's Engineer Estimate |  |  | NA
Expenses during Commercial Operation:
 |  |  |  | Annual US $
O&M Expenses |  |  |  |  | Fixed ($/kw-yr) | Variable ($/mWh)
 | Payroll and Burden
 | Administration & Operations Expenses |  |  |  |  |  |  |  | chemical estimate
 | Chemicals |  |  |  |  |  |  |  | 49991 | demin water costs from model |  |  |  |  | (installed RO + MB)
 | [NAME] (excl. GT Scheduled Maint. Program) |  |  |  |  |  |  |  |  | 76 lbs/hr/SCR x # SCR units x annual # hrs x $0.18/lb |  |  |  |  | (19% ammonia)
 | Sustaining Capital Expenses |  |  |  |  |  |  |  |  | # gts x $2000/yr/gt |  | (gt soap)
 |  |  |  |  |  |  |  |  | 36274 | Cooling tower treatment per model
 | Total O&M Expenses (ex GT Scheduled Maint.) |  |  |  |  |  |  |  |  | Annual Maint estimate ($000)
 |  |  |  |  |  |  |  | FOM |  | VOM
 |  |  |  |  |  |  |  |  | gt
SCR Catalyst Replacement Annual Accrual |  |  |  |  |  |  |  | 12500 | controls
GT Scheduled Major [NAME] |  | Term total |  |  |  |  |  | 20000 | cooling sys | 80000
 |  | $/fired hr/GT |  |  |  |  |  |  | scr
 |  |  |  |  |  |  |  | 40000 | electircal
 |  |  |  |  | FOM | VOM |  | 6500 | bop
Total Plant O&M Expenses (excluding fee) |  |  |  |  |  |  |  | 10000 | paint
Housing Colony Operating Expenses
Commercial Office Expenses
Average Annual Operating Expenses (excluding Fee and G&A)
 |  |  |  |  | ($/kw-yr) | $/mWhr |  | 35000 | test gases
 |  |  |  |  |  |  |  | 25000 | oils, grease
O&M Annual Fee |  |  |  | 100000 |  |  |  | 35000 | shop supplies
 |  |  |  |  |  |  |  | 10000 | tools
 |  |  |  |  |  |  |  |  | compressors
Spreadsheet: jason_wolfe__13460__Points for Enron
Sheet: Sheet1

 |  |  | Zone
580 | #N/A | RANGELY CITY GATE | GR | Rio Blanco Co, CO
581 | #N/A | ANIMAS AIR PARK | MO | La Plata Co, CO
582 | #N/A | PLYMOUTH LNG BOIL OFF | 26 | NWP use | NWP use
583 | #N/A | JACKSON POOL | 26 | [NAME], WA | Logical
584 | #N/A | [NAME] STATION | 9 | [NAME], OR
586 | #N/A | [NAME] CONSTRAINT | 10 | [NAME], WA | Throughput
587 | #N/A | PLYMOUTH NORTH CONSTRAINT PT | 26 | [NAME], WA | Throughput
588 | #N/A | PLYMOUTH SOUTH CONSTRAINT PT | 26 | [NAME], WA | Throughput
590 | #N/A | KITTITAS | 10 | Kittitas, WA
591 | #N/A | WASHOUGAL NORTH CONSTR. | 26 | [NAME], OR
593 | #N/A | BLANCO VAL VERDE | MO | San Juan Co, NM
594 | #N/A | BLANCO BLOOMFIELD | MO | San Juan Co, NM
595 | #N/A | PARACHUTE DELIVERY | PL | [NAME], CO
596 | #N/A | HILGARD FARM TAP | 24 | Union, OR
597 | #N/A | BASIN FROZEN FOODS | 20 | [NAME], WA
598 | #N/A | COTTONWOOD GULCH | MO | La Plata Co, CO
599 | #N/A | FLORIDA RIVER | MO | La Plata Co, CO
600 | #N/A | BLANCO-KUTZ PLANT | MO | San Juan Co, NM
601 | #N/A | BLANCO-TRANSCOLORADO | MO | San Juan Co, NM
602 | #N/A | HATCH GULCH | PL | Rio Blanco Co, CO
603 | #N/A | [NAME] | - | NWP use | NWP use
604 | #N/A | NORTHEND BALANCING | - | NWP use | NWP use
605 | #N/A | NORTHEND BALANCING RECEIPT | - | NWP use | NWP use
606 | #N/A | MIDSECTION BALANCING | - | NWP use | NWP use
607 | #N/A | [NAME] DELIVERY | - | NWP use | NWP use
608 | #N/A | NOVELTY HILL M/S | 30 | King County, WA
611 | #N/A | NORTH DOUGLAS RECEIPT (2001) | GR | Rio Blanco Co, CO
612 | #N/A | FOUNDATION CREEK PLANT (2001) | GR | Rio Blanco Co, CO
613 | #N/A | NORTH DOUGLAS EMERGENCY FUEL | GR | Rio Blanco Co, CO
615 | #N/A | PIERCE POWER | 30 | [NAME], WA
616 | #N/A | ELMORE DELIVERY M/S | 24 | Elmore, ID
617 | #N/A | ELMORE IN-LINE TRANSFER REC | 24 | NWP use | NWP use
618 | #N/A | GOLDENDALE ENERGY DELIVERY | 26 | Klickikat Co, WA
619 | #N/A | GOLDENDALE IN-LINE TRANS REC |  | NWP use | NWP use
620 | #N/A | DEER ISLAND RECEIPT | 26 | [NAME], WA
621 | #N/A | CLEAR CREEK - NWP RECEIPT | KM | Uinta Co, WY
622 | #N/A | CLEAR CREEK - NWP DELIVERY | KM | Uinta Co, WY
623 | #N/A | BENTON PUD | 10 | [NAME], WA
Spreadsheet: 205297d1357776125-a-cell-reference-and-a-data-validation-list-in-same-cell-example-1-validate-reference
Sheet: Sheet1

the drop boxes in Column "F" have a reference to "C8" to change all products in one click.
Then you can use these to change each one indivually if needed by using the "F" column selections.
Then if you want to go back to the one selection to start again you can click on "C8" and start again.
but the reference dissappears if you change one of these ones.
How to keep the reference in these boxes or another solution???
 | SELECT GRADE FOR ALL
 | standard |  |  |  | (selects the type of all selections below)
PRODUCT |  |  | CODE |  | SELECT GRADE
 |  |  |  |  |  | (Change according to C8 and then upgrade/downgrade each product indivdually if needed)
 |  |  |  |  |  | (Change according to C8 and then upgrade/downgrade each product indivdually if needed)
 |  |  |  |  |  | (Change according to C8 and then upgrade/downgrade each product indivdually if needed)
There is around 20 options like above in my real sheet.
Spreadsheet: 92286d1291903798-delivering-data-based-on-a-table-disk-2010
Sheet: Fielding

Pos | Value | Display
2 | 9 | 4
2 | 8 | 2
2 | 6 | -2
2 | 5 | -4
3 | 5 | 4
3 | 4 | 2
3 | 2 | -2
3 | 0 | -4
4 | 9 | 4
4 | 8 | 2
4 | 6 | -2
4 | 5 | -4
5 | 6 | 4
5 | 5 | 2
5 | 3 | -2
5 | 2 | -4
6 | 10 | 4
6 | 9 | 2
6 | 7 | -2
6 | 6 | -4
7 | 3 | 4
7 | 2 | 2
7 | 0 | -2
7 | 0 | -4
Spreadsheet: 864562d1711690418-calculate-elapsed-time-in-days-hours-and-minutes-excluding-weekends-and-holidays-time-calculator
Sheet: Time

DATE | TIME | DATE | TIME | TOTAL |  | Output |  | Net Working days | Net Working hours
2024-02-05 00:00:00 | 09:50:00 | 2024-03-07 00:00:00 | 16:35:00 | 22d 5h 45m
2024-02-05 00:00:00 | 09:47:00 | 2024-02-05 00:00:00 | 14:00:00 | 3h 13m
2024-02-05 00:00:00 | 09:47:00 | 2024-02-05 00:00:00 | 11:54:00 | 2h 7m
2024-02-05 00:00:00 | 13:44:00 | 2024-02-05 00:00:00 | 15:45:00 | 2h 1m
 |  |  |  |  | 5:00 PM | Start of Work Hours
 |  |  |  |  | 8:00 AM | End of Work Hours
 |  |  |  |  | 12:00:00 | [NAME]
 |  |  |  |  | 13:00:00
Spreadsheet: 804064d1667864658-find-last-date-that-corresponds-to-a-value-0-find-last-date-with-value-greater-than-zero
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2022 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00
 |  |  | Expenses | 5 | 7 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 6 | 0 | 0
 |  |  | [NAME]
 |  |  | Goal:  find formula that results in 2/1/2023 (the last date with an Expenses entry that's > 0)
 |  |  | I would like a formula that looks at all of the dates and expenses, ignoring the "Total 2022" column, and provides me with the last date that has a corresponding expense that's greater than zero
Spreadsheet: 73982d1274561286-trouble-with-laying-out-data-set-dataset_rev2
Sheet: Dept2

Year | Forecast Month | Revenue Category | [NAME] | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2010 | Jan | Complete |  | 20 | aa
2010 | Jan | Live |  | 40 | bb
2010 | Jan | Booked on |  | 60 | cc
2010 | Jan | High Prob |  | 80 | dd
2010 | Jan | Indentified |  | 100 | ee
2010 | Jan | Blue Sky |  | 120 | ff
2011 | Jan | Complete |  | 10000 | abc1
2011 | Jan | Live |  | 20000 | abc2
2011 | Jan | Booked on |  | 30000 | abc3
2011 | Jan | High Prob |  | 40000 | abc4
2011 | Jan | Indentified |  | 50000 | [NAME]
2011 | Jan | Blue Sky |  | 60000 | abc6 |  |  |  |  |  |  |  | testB
 | Each department has a sheet similar to this in there revenue spreadsheets which capture the different parameters  from a detailed sheet.
Spreadsheet: 290032d1389779962-table-formatting-and-conditionnal-formatting-table-formatting-and-conditional-formatting
Sheet: Sheet1

Amount | 31-60 days | > 181 days
25016.08 | 0 | 25016.08
15816.02 | 0 | 7240.75
11214.58 | 0 | 11214.58
30021.63 | 7714.87 | 0
7435.81 | 0 | 6870.16
8802.62 | 0 | 0
5835.15 | 0 | 5835.15
5584.36 | 0 | 5584.36
8125.44 | 1173.6 | 479.33
8801.5 | 0 | 0
4758.5 | 0 | 0
4111.35 | 290 | 3821.35
3622.93 | 0 | 2911.29
Spreadsheet: 84280d1284327418-calculate-working-days-raveepoojari
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Original | New | Years |  |  | Combined
Staff id | Staff name | Basic | Overtime | Allowance | Total Salary | Join Date | Provision calculation date | Total working  Days | Gratuity Prvn |  |  | Gratuity Prvn |  | Gratuity Prvn
1 | a | 600 |  | 600 |  | 2000-07-29 00:00:00 | 2010-07-31 00:00:00
2 | b | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
3 | c | 600 |  | 600 |  | 2005-08-21 00:00:00 | 2010-07-31 00:00:00
4 | d | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
5 | e | 600 |  | 600 |  | 2001-07-29 00:00:00 | 2010-07-31 00:00:00
6 | f | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
7 | g | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
8 | h | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
9 | i | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
10 | j | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
11 | k | 600 |  | 600 |  | 2007-09-01 00:00:00 | 2010-07-31 00:00:00
12 | l | 600 |  | 600 |  | 2007-12-08 00:00:00 | 2010-07-31 00:00:00
13 | m | 600 |  | 600 |  | 2007-12-08 00:00:00 | 2010-07-31 00:00:00
14 | n | 600 |  | 600 |  | 2007-12-08 00:00:00 | 2010-07-31 00:00:00
15 | o | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
16 | p | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
17 | q | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
18 | r | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
19 | s | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
20 | t | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
21 | u | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
22 | v | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
23 | w | 600 |  | 600 |  | 2007-07-29 00:00:00 | 2010-07-31 00:00:00
24 | x | 600 |  | 600 |  | 2007-08-21 00:00:00 | 2010-07-31 00:00:00
25 | y | 600 |  | 600 |  | 2007-09-01 00:00:00 | 2010-07-31 00:00:00
26 | z | 600 |  | 600 |  | 2007-12-08 00:00:00 | 2010-07-31 00:00:00
Spreadsheet: 116674d1311975639-selective-columns-priors-hall
Sheet: Card Order

1 | 4 | 10 |  | PAR | SSS
2 | 4 | 6 |  |  | 72
3 | 5 | 14
4 | 4 | 2
5 | 3 | 16
6 | 5 | 12
7 | 4 | 4
8 | 3 | 18
9 | 4 | 8
10 | 4 | 1
11 | 4 | 7
12 | 3 | 13
13 | 5 | 17
14 | 4 | 3
15 | 3 | 9
16 | 4 | 11
17 | 4 | 5
18 | 5 | 15
Spreadsheet: 762002d1641340309-offset-not-working-offset
Sheet: Sheet1

Loan |  |  |  | Balance
 | Today
 |  |  | Current Item Number:
 |  | Invoice Details
Item Number | Date | Details | Debit | Credit | Balance
1 | 2020-08-09 00:00:00 | Trailer | 1585.22
 | 2020-12-01 00:00:00 | Cash payment |  | 300
 | 2021-02-04 00:00:00 | 4 in 1 [NAME] repairs | 340.5
 | 2021-04-09 00:00:00 | Payment |  | 250
 | 2021-12-28 00:00:00 | Payment |  | 100
 | 2021-12-30 00:00:00 | Payment |  | 100