tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 886179d1736208261-index-match-problem-for-same-values-consumable-usage-2025
Sheet: MONTHLY SUMMARY

 | Number of weeks | 5 | 4 | 4 | 4 | 5 | 4 | 5 | 4 | 4 | 5 | 4 | 3
 | Month no. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
StockCode | Description | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2025 | Monthly average
9901061 | PART 7 | 1699.26 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1699.26 | 1699.26
9901069 | PART 9 | 447.17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 447.17 | 447.17
9901100 | PART 23 | 324.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 324.75 | 324.75
9902049 | PART 39 | 115.56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 115.56 | 115.56
9902060 | PART 46 | 59.36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 59.36 | 59.36
9902066 | PART 50 | 310 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 310 | 310
9904013 | PART 55 | 27.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27.8 | 27.8
9905015 | PART 67 | 17.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17.77 | 17.77
9905037 | PART 74 | 5.39 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.39 | 5.39
9905042 | PART 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
9905060 | PART 76 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
9905080 | PART 77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
9905088 | PART 78 | 10.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.6 | 10.6
9906000 | PART 79 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
9906005 | PART 80 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
9906043 | PART 81 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
9906055 | PART 82 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #[NAME]!
 |  | 12160.01 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12160.01
 |  | 12472.03 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12472.03
 |  |  |  |  |  |  |  |  |  |  |  |  |  | -312.0200000000059
Spreadsheet: 725322d1616617736-formula-to-look-into-column-b-and-e-and-place-1-or-0-into-column-f-sample_1_1_1
Sheet: Sheet1

Where | Area | Date | Date-1 | Names | Outcome | Test | 0
CSC | NFFIBD |  | 1999 | [NAME], [NAME], A. | 1
LS | FF | 1999 | 1999 | [NAME], [NAME], A. | 1
3CC | NFFIBD |  | 1999 | [NAME], [NAME], A. | 1
RLC | NFFIBD |  | 1999 | Bon, Jr., [NAME] | 0
AHPC | NFFIBD |  | 1999 | Bon, Jr., [NAME] | 0
JPMCC | NFFIBD |  | 1999 | Bon, Jr., [NAME] | 0
CTC | NFFIBD |  | 1999 | Ber, Mar, K. | 0
LMC | NFF | 1999 | 1999 | Ber, Mar, K. | 0
MMM | NFFIBD |  | 1999 | Ber, Mar, K. | 0
CC | NFF | 1999 | 1999 | Ber, Mar, K. | 0
USGC | NFF | 1999 | 1999 | Barno [NAME] | 0
CkC | NFF |  | 1999 | [NAME], [NAME], A. | 1
LS | FF | 1999 | 1999 | [NAME], [NAME], A. | 1
CkC | Nff |  | 1999 | [NAME], [NAME], A. | 0
Spreadsheet: 7de0b396-f5a7-463b-9df8-20a97aea86ad
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261657 | 40922 | Francesc | Sola Garcia | ESP | 51 | 00:12:19 | 00:03:08 | 00:41:20 | 00:00:00 | 00:16:37 | 1 | 01:13:23
261657 | 49381 | Norberto | [NAME] | ESP | 52 | 00:24:20 | 00:05:06 | 00:46:11 | 00:00:00 | 00:19:40 | 2 | 01:35:16
Spreadsheet: 683251d1592577707-lookup-if-cell-contains-targeted-text-lookup-if-contains-date-purlo-
Sheet: Sheet1

Criteria1 | Criteria2 |  |  |  |  |  |  | Criteria1 | Criteria2
2019-01-01 00:00:00 | Text1 | Name1, Surname1, Middlename1 |  |  |  | Name1, Surname1 | Value1 | 2019-01-01 00:00:00 | Text1
2019-01-02 00:00:00 | Text2 | [NAME], Surname2 |  |  |  | [NAME], Surname2 | Value2 | 2019-01-10 00:00:00 | Text1
2019-01-03 00:00:00 | Text3 | Name3, Surname3, Middlename3 |  |  |  | Name3, Surname3 | Value3 | 2020-02-03 00:00:00 | Text3
2019-01-04 00:00:00 | Text4 | Name4, Surname4 |  |  |  | Name4, Surname4 | Value4 | 2019-01-01 00:00:00 | Text4
2019-01-05 00:00:00 | Text5 | Name5, Surname5, Middlename5 |  |  |  | Name5, Surname5 | Value5 | 2020-01-05 00:00:00 | Text5
 |  | Find with condition if A:A is +/- 30 as H:H
 |  | And has same "Criteria2"
Spreadsheet: 738814d1625243777-formula-for-separating-multiplication-into-multiplier-and-multiplicand-multi
Sheet: multi

 | Multiplication (text) |  |  |  |  |  | Multiplier | Multiplicand
 |  |  |  |  |  |  | 1 | 298015.5
 | 1 x 298 015,50 zł |  |  |  |  |  | 1 | 295009.5
 |  |  |  |  |  |  | 0 | 0
 | 1 x 295 009,50 zł |  |  |  |  |  | 2 | 147901.2
 |  |  |  |  |  |  | 1 | 346011.6
 | 0 x 0,00 zł |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 4 | 88325
 | 2 x 147 901,20 zł |  |  |  |  |  | 3 | 120568.1
 | 1 x 346 011,60 zł
 | 0 x 0,00 zł
 | 4 x 88 325,00 zł
 | 3 x 120 568,10 zł
Spreadsheet: 855303d1704911757-help-specific-hour-slot-8pm-to-8am-is-giving-me-headaches-livro2
Sheet: Folha1

 | Start | End | desired result
 | 20:00:00 | 02:00:00 | 06:00:00
 | 19:00:00 | 02:00:00 | 06:00:00
 | 20:00:00 | 1900-01-01 00:00:00 | 04:00:00
 | 22:00:00 | 08:00:00 | 10:00:00
 | 22:00:00 | 09:00:00 | 10:00:00
 | 09:00:00 | 11:00:00 | 00:00:00
 | 08:00:00 | 09:00:00 | 00:00:00
 | 07:00:00 | 08:00:00 | 00:00:00
 | 17:00:00 | 21:00:00 | 01:00:00
 | 05:00:00 | 11:00:00 | 03:00:00
Spreadsheet: b3e2c70d-d314-44f8-9142-adde8a1280fd
Sheet: Sheet1

2012       ALL STAR EVENTS SCHEDULE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
SATURDAY [NAME] 11
TIME | 8UG | 9UG | 10UG | 12UG | 14UG | 8UB | 9UB | 10UB | 11UB | 12UB | 13UB | 14UB | TIME
10:00AM | HIT 7 | RUN 2 |  |  |  | HIT 6 |  | HIT 4 | RUN 2 | HIT 3 |  |  | 10:00AM
 |  | R FIELD |  |  |  |  |  |  | L FIELD
10:30AM |  |  |  |  |  |  | RUN 2 |  |  |  |  |  | 10:30AM
 |  |  |  |  |  |  | R FIELD
11:00AM |  | HIT 7 | RUN 2 |  | THROW 5 |  |  |  | HIT 4 |  | RUN 2 | THROW 2 | 11:00AM
 |  |  | R FIELD |  |  |  |  |  |  |  | L-FIELD
11:30AM | LUNCH |  |  | RUN 2 |  |  |  | LUNCH |  | RUN 2 |  |  | 11:30AM
 |  |  |  | R FIELD |  |  |  |  |  | L FIELD
12:00PM |  | LUNCH | HIT 7 |  | RUN 2 | LUNCH | HIT 6 |  |  | LUNCH | HIT 3 | RUN 2 | 12:00PM
 |  |  |  |  | R FIELD |  |  |  |  |  |  | L FIELD
12:30PM |  |  |  | LUNCH | LUNCH |  |  | RUN 2 |  |  |  |  | 12:30PM
 |  |  |  |  |  |  |  | R FIELD
1:00PM | RUN 7 |  | LUNCH |  | HIT 6 | RUN 2 |  |  | LUNCH | THROW 2 | LUNCH | LUNCH | 1:00PM
 |  |  |  |  |  | R FIELD
1:30PM |  | THROW 5 |  | HIT 6 |  |  | LUNCH | THROW 4 |  |  | THROW 2 | HIT 3 | 1:30PM
2:00PM | THROW 5 |  |  |  |  | THROW 4 |  |  | THROW 2 |  |  |  | 2:00PM
2:30PM |  |  | THROW 4 |  |  |  | THROW 5 |  |  |  |  |  | 2:30PM
3:00PM |  |  |  | THROW 4 |  |  |  |  |  |  |  |  | 3:00PM
3:30PM |  |  |  |  |  |  |  |  |  |  |  |  | 3:30PM
PLEASE NOTE: Field # is posted with each event. (Ex: Hit 7 - means your hitting will be Field 7)
Run 2 |  |  | Run 2 |  |  | WE NEED | FOUR | PITCHING | MACHINES
R Field | 65 ft |  | L Field | 85ft
Spreadsheet: 836657d1689568453-sum-up-until-a-blank-cell-appears-summations-update
Sheet: Sheet1

 |  |  | IF(A19<>0,SUM(INDIRECT("C"& ROW(C19) & ":C" & MATCH(TRUE,INDEX($A20:$A$100<>"",0),0)+ROW(A18))),"")
 |  |  | IF(A19<>0,SUM(INDIRECT("C"& ROW(C19) & ":C" & MATCH(TRUE,INDEX($A20:$A$100="",0),0)+ROW(A18))),"")
 |  |  | [NAME]  in D19
What I currently have
Room # | Room Name | Individual Size | Group size |  |  |  |  | Room # | Room Name | Individual Size | Group size
1-a | KITCHEN LEVEL 1 | 1300.888888888888 |  |  |  |  |  | 1-a | KITCHEN LEVEL 1 | 1300.888888888888
1-b | KITCHEN LEVEL 2 | 405.555555555555 |  |  |  |  |  | 1-b | KITCHEN LEVEL 2 | 405.555555555555
1-c | KITCHEN LEVEL 3 | 833.3333333333352 |  |  |  |  |  | 1-c | KITCHEN LEVEL 3 | 833.3333333333352
1-04 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  |  | 1-04 | PROGRAM LEVEL 1 | 309.9999999999972
 | PROGRAM LEVEL 1 | 309.9999999999972 |  |  |  |  |  |  | PROGRAM LEVEL 1 | 309.9999999999972
1-d | PROGRAM LEVEL 2 | 1379.999999999999 |  |  |  |  |  | 1-d | PROGRAM LEVEL 2 | 1379.999999999999
1-e | PROGRAM LEVEL 3 | 309.9999999999997 |  |  |  |  |  | 1-e | PROGRAM LEVEL 3 | 309.9999999999997
1-f | LOBBY LEVEL 1 | 613.3333333333319 |  |  |  |  |  | 1-f | LOBBY LEVEL 1 | 613.3333333333319
1-g | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  | 1-g | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
1-h | LOBBY LEVEL 2 | 275.555555555558 |  | This last part generates an #N/A |  |  |  | 1-h | LOBBY LEVEL 2 | 275.555555555558 |  | #N/A goes away if there is another row with info
 | LOBBY LEVEL 2 | 275.555555555558 |  |  |  |  |  |  | LOBBY LEVEL 2 | 275.555555555558
 |  |  |  |  |  |  |  | Test |  |  |  | but still shows up
Spreadsheet: 0adbf952-a572-40f0-818d-803a0670a417
Sheet: Sheet1

STATE OF CALIFORNIA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
HOTEL/MOTEL TRANSIENT OCCUPANCY TAX WAIVER
EXEMPTION CERTIFICATE FOR STATE AGENCIES
TD.236 (NEW 9-91)
HOTEL/MOTEL OPERATOR:   RETAIN THIS WAIVER FOR YOUR FILES TO SUBORDINATE YOUR REPORTS. |  |  |  |  |  |  |  |  |  | DATE
 |  |  | PARTICIPATION BY OPERATIONS IS STRICTLY VOLUNTARY
 | HOTEL/MOTEL NAME
TO:
 | HOTEL/MOTEL ADDRESS (Number, Street, City, State, ZIP Code)
 | This is to certify that I, the undersigned traveler, am a representative or employee of the State agency
 | indicated below; that the charges for the occupancy at the above establishment on the dates set forth
 | below have been, or will be paid for by the State of California; and that such charges are incurred in
 | the performance of my official duties as a representative or employee of the State of California.
OCCUPANCY DATE(S) |  |  |  |  |  |  |  |  |  | AMOUNT PAID
STATE AGENCY NAME
HEADQUARTERS ADDRESS
TRAVELER'S NAME (Printed or Typed)
 | I hereby declare under the penalty of perjury that the foregoing statements are true and correct.
EXECUTED AT:  (City) |  |  |  |  |  | TRAVELER'S SIGNATURE |  |  |  | DATE SIGNED
 |  |  |  | , CALIFORNIA
 |  |  |  |  |  |  |  |  |  | 92 64268
Spreadsheet: 141437d1329260729-need-help-with-multiple-criteria-h-vlookup-sample-census-data2
Sheet: Sheet1

Census | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00 | 2012-03-01 00:00:00
Facility | Category 1 | Category 2 | Category 3 | Category 1 | Category 2 | Category 3
Site A | 0 | 0 | 0 | 12 | 1 | 0
Site B | na | na | na | 20 | na | 1
Site C | 61.95714285714286 | 12.10780669144981 | 7.24390243902439 | 40 | 15 | 0
choose from drop downs |  |  |  |  |  |  |  | list of dates
Site C |  |  |  |  |  |  |  | 2012-02-01 00:00:00
2012-03-01 00:00:00 |  |  |  |  |  |  |  | 2012-03-01 00:00:00
Category 1 | 40 |  |  |  |  |  |  | 2012-04-01 00:00:00
 |  |  |  |  |  |  |  | 2012-05-01 00:00:00
 |  |  |  |  |  |  |  | 2012-06-01 00:00:00
 |  |  |  |  |  |  |  | 2012-07-01 00:00:00
 |  |  |  |  |  |  |  | 2012-08-01 00:00:00
 |  |  |  |  |  |  |  | 2012-09-01 00:00:00
 |  |  |  |  |  |  |  | 2012-10-01 00:00:00
 |  |  |  |  |  |  |  | 2012-11-01 00:00:00
 |  |  |  |  |  |  |  | 2012-12-01 00:00:00
 |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  | 2013-02-01 00:00:00
 |  |  |  |  |  |  |  | 2013-03-01 00:00:00
 |  |  |  |  |  |  |  | 2013-04-01 00:00:00
 |  |  |  |  |  |  |  | 2013-05-01 00:00:00
 |  |  |  |  |  |  |  | 2013-06-01 00:00:00
Spreadsheet: kevin_hyatt__19646__EP2002 Alternative Power Track Follow-up
Sheet: Sheet1

Alternative Power Track
Committee: | [NAME], AmerenEnergy Marketing |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], Brubaker & Associates, Inc. |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], Pearl Street |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], DTE Energy |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], Mariah Energy Corp. |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], E-Source |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], Primen |  |  |  | [EMAIL] |  | [PHONE]
 | [NAME], Enron Transportation Svcs. |  |  |  | [EMAIL] |  | [PHONE]
Session A - Integration of Alternative Power with Traditional Supply - Side Resources
 | Chair: | [NAME], Primen
Session B - Energy Storage - Case Studies
 | Chair: | [NAME], Pearl Street
Session C - Distributed Generation - Case Studies
 | Chair: | [NAME], AmerenEnergy Marketing
Session D - Renewables - Case Studies
 | Chair: | [NAME], Enron Transportation Svcs. |  |  | Alternate: | [NAME], E-Source
Session E - Projecting The Future
 | Chair: | (Open) - [NAME] [NAME] to discuss. |  |  | Alternate: | [NAME], Mariah Energy
Follow-Up | Session | Date | Time Slot | Topic | Speaker | Title | Company | Phone # | Status:
[NAME] | A | Mar 19 | 2:00 - 4:00pm | Interconnection |  |  | Mariah Energy
[NAME] | A | Mar 19 | 2:00 - 4:00pm | MicroGrid Design |  |  | DTE
Pollock | A | Mar 19 | 2:00 - 4:00pm | Renewable Energy Trading
Wicker | A | Mar 19 | 2:00 - 4:00pm | Taking Aggregated DG to Market |  |  | (Port. [NAME], CMS, 6th D, Silicon Engy.)
Wicker | A | Mar 19 | 2:00 - 4:00pm | BIPV (Potential)
??? | B | Mar 20 | 10 - 11:30am | Regenerating Fuel Cells | [NAME] |  | Sumitomo Elec.
Wiese | B | Mar 20 | 10 - 11:30am | CAES |  |  | Alabama Elec.
[NAME] | B | Mar 20 | 10 - 11:30am | [NAME] (Taum Sauk) |  |  | AmerenUE
Wiese | B | Mar 20 | 10 - 11:30am | Battery Storage (Alternate) |  |  | Sandia Labs
[NAME] | C | Mar 20 | 2:00 - 4:00pm | Business Model Approach to DG |  |  | DTE
[NAME] | C | Mar 20 | 2:00 - 4:00pm | Value of DG, [NAME] |  |  | IL Muni Elec.
Wicker | C | Mar 20 | 2:00 - 4:00pm | NYPA Case Study | [NAME] |  | NYPA
[NAME] | C | Mar 20 | 2:00 - 4:00pm | [NAME]. In Real Estate |  |  | Real Energy
Wicker | D | Mar 21 | 10 - 11:30am | [NAME] will coordinate, talk to [NAME] (Chair) |  |  | (4) - Excel, Capstone, E-Source, [NAME], Mercury Elec., [NAME]
Wicker | D | Mar 21 | 10 - 11:30am
Wicker | D | Mar 21 | 10 - 11:30am
Wicker | D | Mar 21 | 10 - 11:30am
[NAME] | E | Mar 21 | 2:00 - 4:00pm | Hydrogen Economy |  |  | Plug Power
Wicker | E | Mar 21 | 2:00 - 4:00pm | Policy |  |  | [NAME]
[NAME] | E | Mar 21 | 2:00 - 4:00pm | Central Station Power |  |  | ABEC
[NAME] | E | Mar 21 | 2:00 - 4:00pm | BPA (Alternatate) |  |  | [NAME]
 |  |  |  | Richard & Bill to discuss Chair & Paul Liddy participation
Spreadsheet: 53556d1253524127-how-to-check-column-for-unique-entries-and-add-one-further-condition-names-a-b-sample-1-
Sheet: Sheet1

Surname | Forename | Name | Type | Party ID | Reason | Site
Mitchell | [NAME] | [NAME] | A |  | S | Ellacombe
Mitchell | [NAME] | [NAME] | A |  | S | Ellacombe
[NAME] | [NAME] | [NAME] | A |  |  | [NAME] |  | Count of Type | Type
[NAME] | [NAME] | [NAME] | A |  |  | [NAME] |  | Name | A | B | Grand Total
[NAME] | [NAME] | [NAME] | A |  |  | [NAME] |  | [NAME] |  | 13 | 13
[NAME] | [NAME] | [NAME] | A |  |  | [NAME] |  | [NAME] | 3 | 1 | 4
[NAME] | [NAME] | [NAME] | A |  |  | [NAME] |  | [NAME] |  | 25 | 25
[NAME] | [NAME] | [NAME] | A |  |  | Upton |  | [NAME] | 6 |  | 6
[NAME] | [NAME] | [NAME] | A |  |  | Upton |  | [NAME] | 4 |  | 4
[NAME] | [NAME] | [NAME] | A |  |  | Upton |  | Grand Total | 13 | 39 | 52
[NAME] | [NAME] | [NAME] | B |  | S | Upton
Eales | [NAME] | [NAME] | B |  |  | Ellacombe
Eales | [NAME] | [NAME] | B |  |  | Ellacombe |  | [NAME]
Eales | [NAME] | [NAME] | B |  |  | Ellacombe |  | 5
Eales | [NAME] | [NAME] | B |  |  | Ellacombe
Eales | [NAME] | [NAME] | B |  |  | Ellacombe
Eales | [NAME] | [NAME] | B |  |  | Ellacombe
Eales | [NAME] | [NAME] | B |  | S | Ellacombe
Eales | [NAME] | [NAME] | B |  |  | Ellacombe
Eales | [NAME] | [NAME] | B |  |  | Ellacombe
Eales | [NAME] | [NAME] | B |  | S | [NAME]
Eales | [NAME] | [NAME] | B |  | S | [NAME]
Eales | [NAME] | [NAME] | B |  |  | [NAME]
Eales | [NAME] | [NAME] | B |  | S | [NAME]
[NAME] | Holly | [NAME] | B |  | S | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | Holly | [NAME] | B |  |  | [NAME]
Mitchell | [NAME] | [NAME] | A |  |  | Ellacombe
Mitchell | [NAME] | [NAME] | A |  |  | Ellacombe
[NAME] | Holly | [NAME] | B |  |  | [NAME]
[NAME] | [NAME] | [NAME] | A |  |  | [NAME]
Spreadsheet: 3e0495be-c307-4df7-8b49-b8ca0ae395a8
Sheet: NEW REF-BEFORE ELECT-quick fix

NEW REFERENDUM GROWTH - BEFORE ELECTION
NOVEMBER 2010 FORECAST - CSA
 |  | STATEWIDE
 |  | REVENUE | EQC AID | TBRA | [NAME] | % AID
ANNUAL NEW $
 | FY 2005 | 73753541 | 20826745 | 63120 | 52863676 | 0.282
 | FY 2006 | 19063404 | 7819335 | 59032 | 11185037 | 0.41
 | FY 2007 | 66630511 | 12964843 | 640526 | 53025142 | 0.195
 | FY 2008 | 63015627 | 14070581 |  | 48945046 | 0.164
 | FY 2009 | 166761998.9999999 | 14544353.96000002 |  | 152217645.0399999 | 0.087
 | FY 2010 | 71257559 | 2399838 |  | 68857721 | 0.034
 | FY 2011e | 34400000 | 3739000 |  | 30661000 | 0.109
 | FY 2012e | 67002000 | 2158000 |  | 64844000 | 0.032
 | FY 2013e | 81723000 | 1842000 |  | 79881000 | 0.023
CUMMULATIVE NEW $
 | FY 2009 | 0 | 0 |  | 0 | 0.076
 | FY 2010 | 0 | 0 |  | 0 | 0.039
 | FY 2011e | 34400000 | 3739000 |  | 30661000 | 0.125
 | FY 2012e | 101402000 | 5897000 |  | 95505000 | 0.035
 | FY 2013e | 183125000 | 7739000 |  | 175386000 | 0.025
ANNUAL NEW $
Est for Nov10
 | FY 2012e | 35000000 |  |  |  | 0.1
 | FY 2013e | 50000000 |  |  |  | 0.03
 | FY 2014e | 50000000 |  |  |  | 0.03
 | FY 2015e | 50000000 |  |  |  | 0.03
CUMMULATIVE NEW $
Est for Nov10
 | FY 2012e |  |  |  |  | 0.125
 | FY 2013e |  |  |  |  | 0.035
 | FY 2014e |  |  |  |  | 0.025
 | FY 2015e |  |  |  |  | 0.025
Spreadsheet: 120959d1315676183-excel-2007-distinguish-between-text-and-numbers-then-move-text-number-worksheet-2-
Sheet: Desired Format

Property Name
Amount
JACLIN CORP 25-1 | 4731
BELL 20-1 | 11994
DAVIS BROS 8-3 ALT | 8051
LA MINERALS 7-8 ALT | 3268
DAVIS BROS 32-1
8396
HODDE 22-5 ALT
5248
DAVIS BROS 20A-1
5825
SWIM 21-1 ALT
7299
DAVIS BROS 29-12 ALT
14454
STEWART HARRISON 20-2 ALT
7353
DAVIS BROS 26A-3 ALT
7363
DAVIS LUMBER 10-5 ALT
11291
T K GIDDENS ET AL 12-2 ALT
4596
DAVIS HEIRS 12-2 ALT
6553
[NAME] HARRISON 30-5 ALT
14674
[NAME] HARRISON 30-6 ALT
14738
PATTERSON ESTATE 5-ALT
4845
ARLISS BARR 12-2 ALT
4684
[NAME]
1545
EDWIN SOUR ET AL 7-3 ALT
1367
[NAME] HARRISON 30-7 ALT
20241
DAVIS BROS 17B-1 ALT
6756
DAVIS BROS 18A-1 ALT
6953
[NAME] 12-3 ALT
6055
[NAME] HARRISON 30-3 ALT
19109
DAVIS HEIRS 19-1 ALT
1531
DAVIS BROS J-12 ALT
1719
CAUSEY 14-2 ALT
2701
MCCONNELL ESTATE 15-2 ALT
5912
MCCONNELL ESTATE 14-3 ALT
8868
LA MINERALS 18-2 ALT
4740
LA MINERALS 18-3 ALT
7234
DAKIN 21-4 ALT
4409
DAVIS BROS 30-8 ALT
13017
OXFORD 3 ALT
5583
WEYERHAEUSER 11-2 ALT
6417
DAVIS BROS G-4 ALT
2159
T K GIDDENS ET AL 12-4 ALT
4726
DAVIS BROS 14C-1 ALT
5120
SIMONTON ETAL 12-2 ALT
5115
PATTERSON ESTATE 6-ALT
439
MCCONNELL ESTATE 14-4 ALT
8715
ARLISS BARR 18-2 ALT
6551
DAVIS BROS Q-8 ALT
6092
DAVIS BROS 8-2 ALT
4965
LA MINERALS 18A-2 ALT
4982
ANADARKO ET AL 20-1 ALT
7295
OXFORD 5 ALT
9801
DAVIS BROS 13-6 ALT
4995
DAVIS BROS 13-5 ALT
7802
LA MINERALS 7-5 ALT
9643
LA MINERALS 7-6 ALT
10493
DAVIS BROS 28-7 ALT
8882
DAVIS BROS 13-4 ALT
6908
DAVIS BROS 28-8 ALT
6284
LA MINERALS 7-7 ALT
8081
DAVIS BROS 17 C-1 ALT
2852
WILLAMETTE 1-2 ALT
5442
DAVIS LUMBER 11-4 ALT
9765
DAVIS BROS 19A-1 ALT
10628
EWING 19-1 ALT
1049
ARLISS BARR 12-3 ALT
2824
STEWART HARRISON 20-1 ALT
9596
STEWART HARRISON 34-2
358
Spreadsheet: 797475d1663915998-identify-a-text-based-on-number-bigger-than-zero-identify-a-text-based-on-number-bigger-than-0
Sheet: 21 09 2022 Sampling bulanan Rin

Unit | ECO 2 AD | ECO 3 AD | ECO 5 AD | ECO 7 AD | MICRO 100 | HD | THIS IS THE EXACT POINT I WANT
GA01 | 0 | 12030 | 0 | 0 | 0 |  | ECO 3 AD
GA02 | 373.3 | 11743.6 | 57672.9 | 104993.9 | 0 |  | ECO 2 AD, ECO 3 AD, ECO 5 AD, ECO 7 AD
GA03 | 0 | 17010 | 58620 | 101580 | 0 |  | ECO 3 AD, ECO 5 AD, ECO 7 AD
GA04 | 0 | 15932.5 | 43108.7 | 96283.8 | 454.5 |  | ECO 3 AD, ECO 5 AD, ECO 7 AD, MICRO 100
GA05 | 0 | 15270 | 57540 | 106440 | 0 |  | ECO 3 AD, ECO 5 AD, ECO 7 AD
GA06 | 0 | 19910 | 7920 | 0 | 0 |  | ECO 3 AD, ECO 5 AD
GA07 | 363 | 19053.2 | 50850.6 | 101782.8 | 0 |  | ECO 2 AD, ECO 3 AD, ECO 5 AD, ECO 7 AD
GA08 | 0 | 20220 | 55440 | 89820 | 0 |  | ECO 3 AD, ECO 5 AD, ECO 7 AD,
 |  |  |  |  |  | STILL GOT THE "," MARK IF THE NUMBER WAS ZERO | THE TEXT SHOULD'NT HAVE "," IF THE NUMBER WAS ZERO
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: February

Name | Site |  |  | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 888531d1739035481-update-needed-to-formula-to-only-show-data-for-month-example
Sheet: February

 | Note: Rep names must be entered in exactly as they are shown in the survey report. Enter the supervisor name in the green boxes.
 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | Raymi [NAME]
 | [NAME]
 | Ricardo Herrera
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 |  |  |  | Team Score
 | [NAME]
 | [NAME]
 | Alexis Jaimes
 | [NAME]
 | Alexis Jaimes
 |  |  |  | Team Score
 | Sup 5
 |  |  |  | Team Score
 | Sup 6
 |  |  |  | DRG Score
 |  |  |  | Updated 11.15.24
Spreadsheet: 745808d1630243340-asset-allocation-to-a-date-period-excel-forum
Sheet: Company assignment

Code | Asset name | Company | Allocation from | Allocation until | date it should be / not available.
123456 | Big Car | Company 1 | 2020-01-01 00:00:00 |  | 2021-01-31 00:00:00
123456 | Big Car | Company 2 | 2021-02-01 00:00:00
654321 | Small Car | Company 1 | 2020-01-01 00:00:00 |  | 2020-01-31 00:00:00
654321 | Small Car | Company 3 | 2021-07-01 00:00:00
654321 | Small Car | Company 2 | 2020-02-01 00:00:00 |  | 31.06.2021