tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 373615d1422494999-take-corresponding-name-and-points-and-make-a-summary-of-points-sujra-time-sheets-places
Sheet: Senior (Boys)

 | SR Boys Fri. Feb. 28 2015 | Event |  |  |  |  | Event |  |  |  |  | Event |  |  |  |  | Event |  |  |  |  | Event |  |  | All Around Points
# | Contestant | Flags | Place | Points | # | Contestant | Goat Tying | Place | Points | # | Contestant | Ribbion Roping | Place | Points | # | Contestant | Breakaway | Place | Points | # | Contestant | Team Roping | Place | Points | Total:
1 | [NAME] | 10 |  |  | 1 | [NAME] | 1 |  |  | 1 | [NAME] | 5 |  |  | 1 |  |  |  |  | 1
2 | [NAME] | 9 |  |  | 2 | tom | 2 |  |  | 2 | tom | 10 |  |  | 2 |  |  |  |  | 2
3 | cam | 8 |  |  | 3 | [NAME] | 3 |  |  | 3 | [NAME] | 15 |  |  | 3 |  |  |  |  | 3
4 | [NAME] | 7 |  |  | 4 | [NAME] | 4 |  |  | 4 | [NAME] | 20 |  |  | 4 |  |  |  |  | 4
5 | [NAME] | 6 |  |  | 5 | [NAME] | 5 |  |  | 5 | [NAME] | 25 |  |  | 5 |  |  |  |  | 5
6 | [NAME] | 5 |  |  | 6 | [NAME] | 6 |  |  | 6 | [NAME] | 30 |  |  | 6 |  |  |  |  | 6
7 | [NAME] | 4 |  |  | 7 | [NAME] | 7 |  |  | 7 | [NAME] | 35 |  |  | 7 |  |  |  |  | 7
8 | [NAME] | 3 |  |  | 8 | [NAME] | 8 |  |  | 8 | [NAME] | 40 |  |  | 8 |  |  |  |  | 8
9 | [NAME] | 2 |  |  | 9 | cam | 9 |  |  | 9 | cam | 45 |  |  | 9 |  |  |  |  | 9
10 | tom | 1 |  |  | 10 | [NAME] | 10 |  |  | 10 | [NAME] | 50 |  |  | 10 |  |  |  |  | 10
11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11 |  |  |  |  | 11
12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12 |  |  |  |  | 12
13 |  |  |  |  | 13 |  |  |  |  | 13 |  |  |  |  | 13 |  |  |  |  | 13
14 |  |  |  |  | 14 |  |  |  |  | 14 |  |  |  |  | 14 |  |  |  |  | 14
15 |  |  |  |  | 15 |  |  |  |  | 15 |  |  |  |  | 15 |  |  |  |  | 15
16 |  |  |  |  | 16 |  |  |  |  | 16 |  |  |  |  | 16 |  |  |  |  | 16
17 |  |  |  |  | 17 |  |  |  |  | 17 |  |  |  |  | 17 |  |  |  |  | 17
18 |  |  |  |  | 18 |  |  |  |  | 18 |  |  |  |  | 18 |  |  |  |  | 18
19 |  |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | 19 |  |  |  |  | 19
20 |  |  |  |  | 20 |  |  |  |  | 20 |  |  |  |  | 20 |  |  |  |  | 20
21 |  |  |  |  | 21 |  |  |  |  | 21 |  |  |  |  | 21 |  |  |  |  | 21
22 |  |  |  |  | 22 |  |  |  |  | 22 |  |  |  |  | 22 |  |  |  |  | 22
23 |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  | 23 |  |  |  |  | 23
24 |  |  |  |  | 24 |  |  |  |  | 24 |  |  |  |  | 24 |  |  |  |  | 24
25 |  |  |  |  | 25 |  |  |  |  | 25 |  |  |  |  | 25 |  |  |  |  | 25
26 |  |  |  |  | 26 |  |  |  |  | 26 |  |  |  |  | 26 |  |  |  |  | 26
27 |  |  |  |  | 27 |  |  |  |  | 27 |  |  |  |  | 27 |  |  |  |  | 27
28 |  |  |  |  | 28 |  |  |  |  | 28 |  |  |  |  | 28 |  |  |  |  | 28
29 |  |  |  |  | 29 |  |  |  |  | 29 |  |  |  |  | 29 |  |  |  |  | 29
30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 30
Spreadsheet: eric_saibi__9709__010402
Sheet: Four Corners 03

Owner Name |  | Arizona Public Services
Station Name |  | Four Corners Power Station
Unit Name |  | Four Corners 03
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 253 MW
Start Date |  | 2002-01-04 00:00:00
End Date |  | 2002-01-13 00:00:00
Comments |  | Reliability work.
SIC |  | 4911
Plant ID |  | 1523368
Unit ID |  | 1007554
Outage ID |  | 19374
Spreadsheet: 288899d1389338009-text-to-raw-in-address-test
Sheet: Sheet1

SALARY -2009-10
SR.NO. | Code No. | NAME | ADDRESS
518 | 1121 | Patel Divyesh Kantibhai | B/38, [NAME],
 |  |  | Near Gazera Circle, |  | Restult which I want
 |  |  | [NAME],[NAME]
519 | 1122 | [NAME] | 304, [NAME],[NAME],
 |  |  | [NAME], |  | Restult which I want
 |  |  | Amroli,[NAME]
520 | 1123 | Adani Sanjay Vinubhai | [NAME] [NAME],[NAME], Varachha Road,[NAME]
521 | 1124 | [NAME] | [NAME],[NAME], Puna Simada Road,[NAME]
522 | 1125 | Valand Manish Dineshbhai | A/76, Om [NAME],[NAME],[NAME],[NAME] |  | Data which I want to split like above
523 | 1126 | [NAME] | B/98, [NAME],[NAME],[NAME], [NAME],[NAME]
524 | 1127 | [NAME] [NAME] | 56,Mahadev Nagar-2,Nana Varachha,Ta: Choryasi.,Surat,
525 | 1128 | Nakrani [NAME] | 254,Bhigarath Society - I,L.H.Road,[NAME] ,Varachha.,Surat
526 | 1130 | Khatra Tejash Vinubhai | B-302,Harekrishna Appt,Hirabaug,Beside P.P.Savani School,Varachha,[NAME]
Spreadsheet: 840970d1693237288-how-to-make-a-condicional-formating-for-this-88-aligw
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  |  | the conditional formating must read the date in "M8"
 |  |  |  |  |  |  |  |  |  | JANUARY |  | JANUARY
 |  |  |  |  |  |  |  |  |  | FEBRUARY |  | FEBRUARY
 |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  | APRIL |  | APRHIL
 |  |  |  |  |  |  |  |  |  | MAY |  | MAY
 |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  | JULY |  | JULY
 |  |  |  |  |  |  |  |  |  | AUGUST |  | AGOST
 |  |  |  |  |  |  |  |  |  | SEPTEMBER |  | SETEMBER
 |  |  |  |  |  |  |  |  |  | OCTOBER |  | OCTOBER
 |  |  |  |  |  |  |  |  |  | NOVEMBER |  | NOVEMBER
 |  |  |  |  |  |  |  |  |  | DECEMBER |  | [NAME]
Spreadsheet: 116184d1311657277-excel-claim-sorting-claims-sorting-tracker-cst-1-
Sheet: Claims Sorted

2011-08-01 00:00:00 | 2012-07-31 00:00:00
Serial | Date | Paid | Oustanding | Total | Title
7 | 2011-12-30 00:00:00 | 15 | 353 | 368 | MD
0 |  | 0 | 0 | 0 | 0 |  |  | 2011-08-01 00:00:00 |  |  |  |  | Do not delete
0 |  | 0 | 0 | 0 | 0 |  |  | 2011-08-01 00:00:00 | To | 2012-07-31 00:00:00 |  |  | 0 | 12
0 |  | 0 | 0 | 0 | 0 |  |  | 2010-08-01 00:00:00 | To | 2011-07-31 00:00:00 |  |  | -12 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | 2009-08-01 00:00:00 | To | 2010-07-31 00:00:00 |  |  | -24 | -12
0 |  | 0 | 0 | 0 | 0 |  |  | 2008-08-01 00:00:00 | To | 2009-07-31 00:00:00 |  |  | -36 | -24
0 |  | 0 | 0 | 0 | 0 |  |  | 2007-08-01 00:00:00 | To | 2008-07-31 00:00:00 |  |  | -48 | -36
0 |  | 0 | 0 | 0 | 0 |  |  | 2006-08-01 00:00:00 | To | 2007-07-31 00:00:00 |  |  | -60 | -48
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | Note: | Select the date from Cell A1
0 |  | 0 | 0 | 0 | 0 |  |  |  | Copy paste the formula in A3:F3 below
0 |  | 0 | 0 | 0 | 0 |  |  |  | Hide column M:O
0 |  | 0 | 0 | 0 | 0 |  |  |  | there is similar formula in A3&C3:F3
0 |  | 0 | 0 | 0 | 0 |  |  |  | There is separate formula in B3
0 |  | 0 | 0 | 0 | 0 |  |  |  | These are array formulas and should be confirmed throgh Ctrl+Shift+Enter
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Alya

 |  | Total Revenue
 |  | Clinics Fee
 |  | Lab Fee
 |  | Net
 |  | Dr. Percentage 7.5%
 |  | % | Target
 |  | 0.075 | 18000 | 25000
 |  | 0.1 | 25001 | 35000
 |  | 0.125 | 35001 | 45000
 |  |  |  |  | Doctor [NAME] ……………
Spreadsheet: 747207d1631281174-race-position-tracker-calc-ahead-and-behind-relative-to-own-position-race-position-tracker-calc-1-
Sheet: Sheet1 (2)

Lap = | 74
Position | Car | Gap | Diff | AB | AB Should Be
1 | 99
2 | 14 | 10
3 | 22 | 4
4 | 01 | 12
5 | 66 | 5
6 | 11 | 12
7 | 44 | 20
8 | 77 | 2
9 | 653 | 3
10 | 666 | 8 |  |  | -13
11 | 172 | 24 |  |  | -37
12 | 171 | 1L |  |  | -1L
13 | 12 | 2L |  |  | -3L
14 | 67 | 3L |  |  | -6L
Spreadsheet: 688918d1596022570-averageif-array-for-multiple-variables-excelforumexample
Sheet: Competition Table

Location Name | Delegate Rate? | Is Hotel? | RoomCapacity | Hourly Cost | Library 1 | [NAME] | Library 3
Location 1 | No | No | 100 | 15 | 2.9 | 55.6 | 19
Location 2 | Yes | Yes | 4.5 | 12.5 | 56.1 | 2.7 | 52.9
Location 3 | Yes | Yes | 34 | 50 | 2.2 | 54.3 | 16.7
Location 4 | No | No | 14 | 20 | 0.9 | 41 | 17.6
Location 5 | Yes | No | 10 | 8.100000000000001 | 1.2 | 53.6 | 17
Location 6 | Yes | No | 135 | 85 | 6.2 | 53.7 | 13.9
Location 7 | No | Yes | 16 | 25 | 5.9 | 56.9 | 20.3
Location 8 | Yes | No | 35 | 68.3 | 3.7 | 53.4 | 16.8
Location 9 | No | No | 22 | 5 | 3.9 | 51.2 | 14.6
Location 10 | No | Yes | 60 | 23.33 | 3.9 | 51.3 | 14.7
Location 11 | Yes | Yes | 24 | 78.84 | 13.9 | 67.1 | 30.6
Location 12 | No | Yes | 40 | 55 | 12.6 | 41.4 | 11.9
Location 13 | Yes | No | 50.5 | 22.5 | 0.8 | 40.8 | 17.5
Location 14 | Yes | No | 60 | 77.69999999999999 | 22.2 | 73.3 | 36.6
Location 15 | Yes | Yes | 130 | 390 | 11.6 | 59.2 | 18.6
Location 16 | Yes | Yes | 9 | 15.04 | 15.2 | 62.8 | 9.1
Location 17 | No | Yes | 40 | 28.13 | 3.9 | 54.5 | 17.9
Location 18 | No | Yes | 10 | 16.25 | 6.6 | 61.5 | 24.9
Location 19 | No | No | 24 | 1.75 | 3.6 | 54.8 | 18.2
Location 20 | No | No | 0 | 11 | 3.8 | 40 | 20.4
Spreadsheet: d771f579-54d0-404d-bb98-7c700bfcff8d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VID2 | Test | VID2 | Additional Testing Virus Ident | Additional Testing Virus Ident |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87253 |  |  |  |  | Rochester
VID2 | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 163210d1340222545-changing-three-columns-of-data-in-to-a-table-in-excel-2007-2012-06-20-pivot-table-oeldere-
Sheet: Blad1

 |  |  |  |  |  |  |  | Number | Type | Data
 |  |  |  |  |  |  |  | A | b | c
 |  |  |  |  |  |  |  | B | s | x
 |  |  |  |  |  |  |  | C | r | c
 |  |  |  |  |  |  |  | D | f | x
 | Count Data | Kolomlabels
 | Rijlabels | c | x | Eindtotaal
 | b | 1 |  | 1
 | f |  | 1 | 1
 | r | 1 |  | 1
 | s |  | 1 | 1
 | Eindtotaal | 2 | 2 | 4
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 13c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 1867767 | - | 229797
Europe | - | 853443 | - | 114273
North America/Asia | - | 1014324 | - | 115524
Index | 2756949 | 8103022 | 1375592 | 2544971
Asia | - | 186172 | - | 42129
Europe | 1319117 | 3908966 | 431011 | 1035993
North America | 1414452 | 3562126 | 932465 | 1400594
Other | 23380 | 445758 | 12116 | 66255
Other | - | 579132 | - | 284626
Exotic/Total Return Swap | - | 54585 | - | 38686
Swaptions | - | 524547 | - | 245940
TOTAL | 2756949 | 10549921 | 1375592 | 3059394
Spreadsheet: 68679d1d-6391-4c9b-a111-ebd085c0ddbd
Sheet: 18

 |  | Broker** |  | Non-Broker |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Swap* | CFD
 | Dividend
 | Equity Swap
 | Portfolio
 | [NAME]
Option | Accumulator/Decumulator
 | Vanilla (put/call)
 | [NAME]
Forward | Vanilla
Exotic
Structured Products
TOTAL |  | N/A**** | N/A | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, July 31 monthly snapshot, by product, participant type, and cleared status (millions of USD).
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
****N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 708945fc-5940-4c64-aadc-2773388f7aee
Sheet: Sheet1

Unnamed: 0 | KRASIMIRA STHEREVA SIMEONOVA | Unnamed: 2 | Unnamed: 3
Date of birth | 1955-04-15 | Velingrad | Bulgaria
Profession | Physician;
Languages | English;Russian;Romanian;
Научни звания
Marital status | married
Political force | GERB 39.70%
Constituency | 13-ПАЗАРДЖИК
Member of the previos NA
E-mail | [EMAIL]
Website
Spreadsheet: 176236d1345780230-help-with-report-totals-required-pt-count-or-countif
Sheet: Sheet1

Category |  | Cat | Tot
SEC |  | ADM |  | <<[NAME]
ADM |  | PRT
PRT |  | SEC |  |  | VVV Pivot Table Answer
PRT |  |  |  |  | Row Labels | Count of Category
PRT |  |  |  |  | ADM | 109
PRT |  |  |  |  | PRT | 82
SEC |  |  |  |  | SEC | 101
SEC |  |  |  |  | Grand Total | 292
ADM
ADM
ADM
ADM
ADM
ADM
PRT
PRT
SEC
ADM
SEC
SEC
SEC
ADM
ADM
PRT
SEC
ADM
SEC
ADM
PRT
ADM
SEC
SEC
SEC
PRT
SEC
PRT
PRT
SEC
SEC
SEC
ADM
ADM
SEC
ADM
PRT
SEC
PRT
PRT
SEC
PRT
SEC
SEC
ADM
ADM
ADM
PRT
ADM
ADM
SEC
ADM
SEC
ADM
ADM
SEC
ADM
PRT
PRT
ADM
PRT
ADM
ADM
SEC
SEC
PRT
ADM
ADM
SEC
PRT
SEC
ADM
SEC
ADM
PRT
SEC
SEC
SEC
SEC
SEC
PRT
ADM
SEC
ADM
PRT
ADM
SEC
PRT
SEC
SEC
ADM
SEC
ADM
PRT
SEC
PRT
SEC
PRT
ADM
PRT
PRT
ADM
SEC
SEC
SEC
PRT
PRT
SEC
ADM
ADM
SEC
PRT
ADM
ADM
SEC
ADM
PRT
ADM
SEC
SEC
SEC
ADM
SEC
ADM
ADM
ADM
ADM
PRT
PRT
ADM
PRT
ADM
PRT
SEC
SEC
PRT
PRT
ADM
ADM
PRT
ADM
PRT
SEC
PRT
PRT
PRT
ADM
PRT
SEC
ADM
PRT
ADM
SEC
ADM
SEC
ADM
ADM
ADM
PRT
ADM
PRT
PRT
PRT
ADM
SEC
ADM
PRT
SEC
PRT
PRT
ADM
SEC
ADM
ADM
PRT
ADM
ADM
SEC
ADM
SEC
ADM
ADM
SEC
ADM
SEC
PRT
PRT
SEC
PRT
PRT
PRT
SEC
PRT
SEC
SEC
ADM
ADM
SEC
ADM
SEC
ADM
SEC
ADM
SEC
SEC
ADM
ADM
ADM
PRT
SEC
PRT
ADM
ADM
ADM
SEC
ADM
ADM
ADM
SEC
PRT
SEC
PRT
SEC
SEC
ADM
PRT
SEC
ADM
SEC
SEC
SEC
ADM
SEC
PRT
PRT
SEC
ADM
PRT
SEC
PRT
ADM
SEC
SEC
PRT
PRT
PRT
PRT
PRT
SEC
SEC
SEC
SEC
ADM
ADM
ADM
SEC
PRT
PRT
SEC
ADM
ADM
PRT
ADM
PRT
SEC
ADM
ADM
ADM
PRT
ADM
PRT
SEC
SEC
SEC
ADM
ADM
SEC
PRT
ADM
SEC
ADM
ADM
ADM
SEC
Spreadsheet: 847834d1698680279-using-hlookup-based-on-another-hlookup-sample-204-aligw
Sheet: Companionship planting

 |  | Vegetable / Cereal |  |  | Companionship planting
 |  | Common name |  | Scientific name
 |  | Portuguese | English |  |  | Açafrão-da-terra | Acelga | Agrião (terra) | Agrião-de-água | Aipo / Salsão | Alcachofra | Alcaravia | Alface | Alfafa / Luzerna
 | 1
Spreadsheet: 854400d1704293523-sum-with-index-match-holiday_test-sheet
Sheet: Feb

 | FEBRUARY
Area | Name | 2024-02-01 00:00:00 | 2024-02-02 00:00:00 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | 2024-02-06 00:00:00 | 2024-02-07 00:00:00 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 | 2024-02-10 00:00:00 | 2024-02-11 00:00:00 | 2024-02-12 00:00:00 | 2024-02-13 00:00:00 | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | 2024-02-16 00:00:00 | 2024-02-17 00:00:00 | 2024-02-18 00:00:00 | 2024-02-19 00:00:00 | 2024-02-20 00:00:00 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | 2024-02-24 00:00:00 | 2024-02-25 00:00:00 | 2024-02-26 00:00:00 | 2024-02-27 00:00:00 | 2024-02-28 00:00:00 | 2024-02-29 00:00:00 |  |  | Total A/L
1 | Adam |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A/L | A/L
1 | [NAME] |  |  |  |  |  | A/L
2 | [NAME]
2 | Debs
2 | Elaine |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A/L | A/L |  |  | A/L | A/L
3 | [NAME]
3 | George
3 | Helen |  |  |  |  |  |  |  |  | a/l |  |  |  | A/L | A/L
5 | Ian
Spreadsheet: 733283d1621486262-help-formula-s-to-stock-among-shares-kd-copy
Sheet: Summary

Sr. No | ScripName | Date
1 |  | 2021-04-05 00:00:00
2 |  | 2021-04-05 00:00:00
3 |  | 2021-04-06 00:00:00
4 |  | 2021-04-06 00:00:00
5 |  | 2021-04-06 00:00:00
6 |  | 2021-04-07 00:00:00
7 |  | 2021-04-07 00:00:00
8 |  | 2021-04-07 00:00:00
9 |  | 2021-04-08 00:00:00
10 |  | 2021-04-08 00:00:00
11 |  | 2021-04-08 00:00:00
12 |  | 2021-04-08 00:00:00
13 |  | 2021-04-08 00:00:00
14 |  | 2021-04-08 00:00:00
15 |  | 2021-04-08 00:00:00
16 |  | 2021-04-08 00:00:00
17 |  | 2021-04-08 00:00:00
18 |  | 2021-04-08 00:00:00
19 |  | 2021-04-08 00:00:00
20 |  | 2021-04-08 00:00:00
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
Spreadsheet: 88213d1288105811-excel-2007-conditional-formatting-order-book1_jollywood
Sheet: Sheet1

Other Notes and [NAME]: |  |  |  |  | My Notes to You @ Excel Help Forum
Indexed Life: |  |  |  |  | <---Choose policy type from List
 |  |  | 0.5 |  | <---These cells have three formatting options: 1) Percentage 2) Accounting 3) Text I want the cells in D3:E16 to be formatted accordingly.  The basis for the formatting will be based on the text in cells A3:[NAME]. (see chart below for specs) (example) A1:C1 = "Bonus:"    then D1:E1 should be formatted as a %. etc.
 |  |  | 101
 |  |  | 0.2
 |  |  | 0.1
 |  |  | 104
 |  |  | 105
 |  |  | 106
 |  |  | 107
 |  |  | 108
 |  |  | 109
 |  |  | 110
 |  |  | 111
 |  |  | 112
 |  |  | 113
Fields w/ this text, format accordingly. |  |  |  |  | My Problem
Accounting | Percentage | Text |  |  | The text in cells A3:C16 can change over time.  Once an entry is made and a formatting option is set, choosing a different option with a different formatting spec will not allow the data in D3:E16 to change to the new formatting option.  How can I get this to work?
Annual Premium: | Annual Fee: | Benefit Period:
Benefit Amount: | Bonus: | Elimination Period:
Bonus Amount: | [NAME]: | Mode:
Daily Facility Care Amount: | Minimum Fixed Rate: | Optional Benefits:
Daily Home & Community Care Amount: | Participation Rate: | Payment Period:
Death Benefit: | Rider Fee: | Premium Period:
International Coverage Lifetime Benefit: |  | Rider:
Maximum Lifetime Benefit: |  | Term Payout Option:
Monthly Benefit: |  | Term Period:
Payment Amount:
Payment:
Premium:
Spreadsheet: 719858d1613849013-select-two-numbers-appearance-count-them-and-put-the-count-on-another-sheet-countifs-or-sumproduct
Sheet: Sheet1

Num1 |  |  | Num2 |  | Looking for |  | SumProduct | [NAME]
 |  |  |  |  | 2 | 3
 |  |  |  |  | Two formulas seem to work in H1 and I1.
 |  |  |  |  | Press F9 to recalculate the A and D columns and see H1 and I1 change.
Spreadsheet: 708762d1608016601-combine-data-feom-2-rows-in-2-comlumns-into-one-row-and-column-d-and-p
Sheet: Summary

Summary
Month | Day out
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Total
Total
Spreadsheet: jeff_dasovich__14019__2000 BUDGET 6-12
Sheet: Sheet1

PROFESSIONAL SERVICES | FIRM | PROPOSED BUDGET
Legal Support | [NAME] and Others
Electric
--  PG&E GRC Phase II |  | 50000
--  Post Freeze |  | 50000
--  Asset Valuation |  | 20000
--  RAP/PX Credit  99 |  | 40000
--  ATCP  99 |  | 10000
--  RCS  Long-run marginal costs |  | 20000
--  Market Structure |  | 75000
--  Service Fees |  | 10000
--  Continued Implementation Issues |  | 30000
--  Fed Procurement (i.e. military bases) |  | 20000
--  [NAME]. |  | 20000
--  New Cases |  | 180000
Total Electric
Gas
--  Natural Gas Strategy |  | 50000
--  Natural Gas Implementation |  | 50000
--  Enron Gas  Misc. |  | 20000
--  New Cases |  | 50000
Total Gas
Combined Gas & Electric
--  PG&E PBR for Gas and Electric |  | 50000
--  OII on Distribution/Interconnection Rules |  | 75000
--  Advice Letter Protests |  | 50000
--  Affiliate (penalties, complaints) |  | 20000
--  Federal Legislative Matters |  | 5000
--  New Cases |  | 50000
Total Combined G&E
Total CPUC Legal
Legislative -- Legal Assistance
--  Total |  | 180000
Total Legal
Consultant Support | MRW and Others
--  PG&E GRC Phases II |  | 20000
--  Post Freeze |  | 25000
--  PG&E PBR |  | 20000
--  ATCP  99 |  | 10000
--  Retained Assets |  | 20000
--  RCS |  | 15000
--  RAP 99 |  | 10000
--  Gas Restructuring Amount |  | 25000
--  [NAME] |  | 30000
--  Market Structure |  | 30000
--  Service Fees |  | 5000
--  CEC Assistance |  | 10000
--  New Cases |  | 60000
Total Consultant
Lobbying
--  Legislative | Governmental Advocates | 95000
--  Other Legislative | To be determined | 60000
--  CEC | To be determined | 10000
Total Lobbying
Other Outside Expenses | [NAME] CPA and Others | 10000
[NAME] | To be determined | 15000
TOTAL PROFESSIONAL SVCS | Subtotal (200-249)
DONATIONS AND CONTRIBUTIONS | CATEGORY | PROPOSED BUDGET
Legislative/Other Support
--  Total | Legislative, Other Races | 175000
PR/Image Building | Sponsorships, Charities | 75000
TOTAL DONATIONS/CONTRIBUTIONS | Subtotal (154-155)
OTHER EXPENSES |  | REVISED BUDGET
General Business Expense, Entertainment, Training (050-099) |  | 135000
Office Supplies, Utilities, Postage (160-175) |  | 70000
Memberships and Coalitions (157)
 | State Net | 1500
 | AB1890 Implementation Group | 5000
 | IEP | 5000
 | AAMP | 25000
 | CalTax | 5000
 | [NAME] | 5000
 | CA Manufacturers Association | 6500
 | New Enron Coalitions | 25000
 | Other Memberships | 12000
Total Memberships/Coalitions
Rents (250-299) |  | 130000
TOTAL OTHER EXPENSES | Subtotal (Various Accounts)
 | TOTAL CALIFORNIA
Spreadsheet: 693253d1598885292-a-leaderboard-but-with-multiple-entries-sample-formula-kraser-
Sheet: Sheet1

Name | Prize
Adam | Apple |  |  | [NAME] for green cells |  |  |  |  | How it should read
[NAME] | Orange
[NAME] | [NAME]
Adam | Apple |  |  |  | Who won the most |  |  |  | Who won the most
[NAME] | Apple |  |  |  | Apple | Orange | [NAME] |  | Apple | Orange | [NAME]
[NAME] | Apple |  |  |  |  |  |  |  | Adam | [NAME] | [NAME]
Adam | Orange
[NAME] | Orange
Adam | Apple |  |  |  | Apple | Orange | [NAME] |  | Apple | Orange | [NAME]
[NAME] | Apple |  |  | 1st |  |  |  |  | Adam | [NAME] | [NAME]
[NAME] | [NAME] |  |  | 2nd |  |  |  |  | [NAME] | Adam | [NAME]
[NAME] | [NAME] |  |  | 3rd |  |  |  |  | [NAME]
[NAME] | Apple
Spreadsheet: 0dfe5c9e-f7aa-452e-9fd0-3d6dc310bfbd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GLBF | Test | GLBF | Glucose, Body Fluid | Glucose, BF | Photometric, [NAME] | Plastic vial: PlV |  |  | 1 | mL | Container/Tube: Sterile container [NAME]: 1 mL Collection Instructions: Centrifuge to remove any cellular material. Additional Information:  1. Indicate specimen source. 2. For spinal fluid glucose, see test GLSF/152 Glucose, [NAME]. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Spinal fluid | Not applicable | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82945 |  |  |  |  | Rochester
GLBF | [NAME] | BODYFL | Body Fluid |  |  |  | Refrigerated | 7 days
GLBF | Order Question | FLD12 | [NAME] |  | Plain Text
GLBF | Result | GL_BF | Glucose, BF | Glucose, BF | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2344-0
GLBF | Result | FLD12 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14725-6