tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215521d1361396971-extracting-and-transferring-rows-and-transosing-info-into-a-new-sheet-template-_animal-numbers
Sheet: Dr ABC

 | F12-001
Date approved | 2012-01-01 00:00:00 | Document changes in animal numbers over the course of the experiment - enter zero if there no animals were ordered on
Protocol expiry date | 2013-01-01 00:00:00 | this protocol.
Animal species | beef
Number approved | 100 | Please provide comments on any transfers out of the protocol (mortalities must be recorded in the transfer out columns too)
Date of 1st animal order | 2012-03-10 00:00:00 | The numbers must not be increased beyond the approved number without an amendment.
Anticipated exp end date | 2012-10-10 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 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 | Cum total
Initial number ordered | 80 |  |  |  | 0 | 10 | 0
Dates for subsequent orders |  |  |  |  | 2012-04-15 00:00:00 | 2012-05-10 00:00:00
Transfers out |  |  |  |  | 3 | 10
Spreadsheet: jonathan_mckay__16916__CODA - Sell
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Canada Olympic Development Association |  |  |  |  | Deal Date: |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: |  |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: |  |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Sell |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January |  | 5911
 | February |  | 4230
 | March |  | 3979
 | April |  | 2580
 | May |  | 1996
 | June |  | 907
 | July |  | 989
 | August |  | 1094
 | September |  | 2054
 | October |  | 3441
 | November |  | 4879
 | December |  | 5347
 | TOTAL:
Spreadsheet: 723879d1615926355-vlookup-result-rounding-result-in-error-depositslip_sample
Sheet: Deposit Form

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | version 1.3 - 03.03.21 |  |  | Plant Description |  |  | Account Description | Account | Transaction |  | Cost Center Name | CC Descr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select… |  |  | Select… |  |  |  | Select…
 | Finance Department |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: |  |  |  |  |  |  |  |  |  | ANIMAL SERVICES
 | Deposit Transmittal Slip |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepared By: |  |  |  |  |  |  |  |  |  | BUSINESS LICENSE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MARINA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POLICE DEPARTMENT
 | HEADER INFO |  |  |  |  |  |  |  |  |  |  |  |  | DCR INFO (FINANCE ENTRY) |  |  |  |  |  |  |  |  |  |  |  |  |  | REC - COMMUNITY CENTER
 | 1. | Department |  |  | BUSINESS LICENSE |  |  |  |  |  |  |  |  |  | DCR Date |  |  |  |  |  |  |  |  |  |  |  |  | REC - WATER PARK
 | 2. | Total Deposit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REC - WORTH SHAW
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CASH BAG |  |  |  |  |  |  |  |  |  |  |  |  |  | SENIOR CENTER
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. | Cash Bag ID
 | 4. DEPOSIT LINE ITEMS
 | Trx Code |  | Code Type |  |  |  |  |  | GL Account |  |  |  | Description |  |  |  |  |  |  |  |  |  | Amount
 |  |  | BUSINESS LICENSES
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 |  |  | Select…
 | DETAILS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. DEPOSIT BREAKDOWN
 |  |  |  | From |  | To |  |  |  |  |  |  |  |  |  |  |  |  | Type |  | Qty |  | Extended Amt
 | Receipt Date(s) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ones (1)
 | Receipt Num(s) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fives (5)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tens (10)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Twenties (20)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fifties (50)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hundreds (100)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cash
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Checks
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Credit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL DEPOSIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YOU ARE OFF BY
Spreadsheet: 730779d1619922794-find-the-percentage-a-cell-is-in-a-time-range-and-the-average-time-within-each-5x20-strategy
Sheet: RESULTS

 | TIME TRADED %
 | 6:00-8:59
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-14:59
 | 15:00-16:00
 | GAIN/LOSS
 | Trading Days Span | 53
 | Trading Days
 | Trading Days %
 | Total Wins
 | Total Points /share
 | Average Points /share |  |  | Excluding top 2 and bottom 2
 | Win/Loss % |  |  | Note, this is Win % on days there was a 5x20 strategy win
 | ENTRY REASON %
 | PM CONSOLIDATION
 | R2G
 | MOMO
 | CONSOLIDATION
 | PMH
 | BO
 | HIGHS %
 | Entry-High Ave |  |  | Percentage High above Entry
 | High-Close Ave |  |  | Percentage High above Close
Spreadsheet: 55590d1255693844-excel-2007-vertical-to-horizontal-conversion-vlookup-performance-ordersubmit-copy
Sheet: Step2

1
OrderID | Item1 | Item2 | Item3 | Item4 | Item5 | Item6 | Item7 | Item8 | Item9 | Item10 | Item11 | Item12 | Item13 | Item14 | Item15 | Item16 | Item17 | Item18 | Item19 | Item20 |  | Invoice 1 | Invoice 2 | Invoice 3 | Invoice 4 | Invoice 5 | Invoice 6 | Invoice 7 | Invoice 8 | Invoice 9 | Invoice 10 | Invoice 11 | Invoice 12 | Invoice 13 | Invoice 14 | Invoice 15 | Invoice 16 | Invoice 17 | Invoice 18 | Invoice 19 | Invoice 20 | TOTAL INV
Spreadsheet: 155385d1336783996-managing-three-variables-example
Sheet: Sheet1

MPG | 3 | 3.1 | 3.2 | 3.3 | 3.4 | 3.5 | 3.6 | 3.7 | 3.8 | 3.9 | 4
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Weekly | Yearly | 26 MPG, $3.00
250
275
300
325
350
Spreadsheet: 670205d1585782052-updating-a-formula-for-text-split-textfunctions
Sheet: Sheet2

 | 1st String | 2nd String | [NAME] | [NAME]
Find position of first space
Find position of second space
Find position of third space
Find position of fourth space
Find position of fifth space
Find position of sixth space
Find position of seventh space
Find position of eigth space
Find position of nineth space
Find position of tenth space
Find position of eleventh space
 | LEFT(A17,B2) | MID(A17,B2+1,B3-(B2+1)) | MID(A17,B3+1,B4-(B3+1)) | MID(A17,B4+1,B7-(B4+1)) | MID(A17,B7+1,B8-(B7+1)) | MID(A17,B7+1,B8-(B7+1)) | RIGHT(TRIM(A17),5)
[NAME] 18794 [NAME] Northville Michigan 48168
[NAME] 620 Slayton Street Grand Haven Michigan 12345
[NAME] 5353 North Silver Pines Drive Bellaire Michigan 56789
[NAME] 5353 North Silver Pines Drive Apt 1 Bellaire Michigan 56789
Banston D. Banks 374 River Woods Dr. [NAME] 48433
Spreadsheet: andy_zipper__742__10_29_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 |  |  |  |  |  | 27.1 | 2001-10-25 14:38:00
 | NG Z1 | 330 | 62.5 | 63.5 | 84.6 | 86 | 17.7 | 2001-10-29 14:38:00
 | NG F2 | 340 | 87.5 | 89 | 81.8 | 83.2 | 17.63 | 2001-10-29 14:38:00
 | NG G2 | 340 | 101.5 | 102 | 76.1 | 76.5 | 16.31 | 2001-10-29 14:38:00
 | NG H2 | 335 | 101 | 102 | 67.5 | 68.1 | 14.28 | 2001-10-29 14:38:00
 | NG J2 | 325 | 85 | 88 | 52.7 | 54.6 | 10.96 | 2001-10-29 14:38:00
 | NG K2 | 325 | 85 | 89 | 48.1 | 50.4 | 10.06 | 2001-10-29 14:38:00
 | NG M2 | 330 | 91 | 93 | 46.8 | 47.9 | 9.82 | 2001-10-29 14:38:00
 | NG N2 | 340 | 100 | 101 | 47.1 | 47.6 | 10.12 | 2001-10-29 14:38:00
 | NG Q2 | 340 | 104 | 108 | 46.3 | 48.1 | 10.09 | 2001-10-29 14:38:00
 | NG U2 | 340 | 109 | 113 | 46.1 | 47.9 | 10.05 | 2001-10-29 14:38:00
 | NG V2 | 340 | 114 | 120 | 46.3 | 48.8 | 10.16 | 2001-10-29 14:38:00
 | [NAME] | 375 | 135 | 142 | 46.2 | 48.6 | 11.18 | 2001-10-29 14:38:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: michelle_cash__26508__Mariner events
Sheet: Sheet1

Details of Events on | 2001-08-23 00:00:00
9:45 AM Thursday, August 23
Meeting between [NAME] and Hoynes. | Discuss termination plans. | Hoynes
 | Prepared script. | Cash
 | In a reserved room at The Double Tree prior to Board meeting. | [NAME]
 | Security near room during discussion. | [NAME]
 | Consultant prepared to meet with employee regarding | [NAME]
 | checklist of items to be turned in and payments.
 | (see checklist attached) | [NAME]
10:00 AM Thursday, August 23
Mariner Board Meeting in Double Tree Hotel
 | Vote on terminations
 | Prepared script for board to instruct employees of confidentiality,
 | meet with Consultants to return company property,
 | discuss/receive payments due to them.
 | 4 reserved rooms/ 4 consultants/ 4 security
 | Reserve room for board meeting
 | Advise cabs of availability for transport of employees home
 | 2 uniformed security in hotel and on floor of board meeting starting
 | 09:30:00
 | Secure leased automobiles until decisions by employees.
 | Ensure checks and all payments have been made correctly.
10:00 AM Thursday, August 23
Mariner Office Building on Highway 6 | Dismiss Administrative Assistants for rest of the day.
 | Prepare script for discussions with admin. staff.
 | Disconnect phone service. (Cell and office)
 | IT secure hdwe, software, operating systems, and network.
 | Decode security badge to disallow entrance on floor.
 | Locksmiths re-key locks and file drawers.
 | Prepare announcement for all employee meeting at 1:30 PM
 | Secure building floors 10, 13, 14 and monitor ingress and egress
 | ensuring no entrance by terminated people
 | Prepare personal belongings in offices and courier to respective homes.
 | Advise payroll in preparation of checks
 | [NAME] cash position for making cash payments.
 | Terminate signature authority.
1:00 PM Thursday, August 23, 2001
Mariner Office Building  on Highway 6 | Dismiss office personnel to attend all employee meeting at Westlake Club.
 | Maintain floor security during employee meeting
 | Note will not be returning after meeting. Office closed.
1:30 PM Thursday, August 23, 2001
Westlake Club | All employee meeting
 | Who will lead meeting?
 | Prepare Q and A for meeting leader
 | Secure room for meeting
 | Security assistance. How Many?
 | Retention plans and Severance plan
Follow up items after August 23, 2001
 | Assume auto leases or deliver autos based on employee decision
 | Monitor confidentiality
 | Pay security, locksmiths, consultants
 | Assist with additional organizational changes
 | Follow-up all-employee meeting.
Spreadsheet: 267208d1380012832-vlookup-function-0a215_a
Sheet: Burgess, Tristan

Burgess, Tristan
Umpire | Player | Team | Position | Votes | Team Margin | K | H | D | CP | UP | DE% | CLG | M | CM | M50 | HO | CLR | CC | ST | R50 | FF | FA | T | 0.01 | Bo | [NAME] | G | B | GA | G% | TG% | DT
Spreadsheet: phillip_m_love__30141__200001_OA
Sheet: EAST-CON-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM) / LRC
REGION: EAST
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL INTRA-MTH
FT-East
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 49057d1248342127-keeping-track-of-payments-test
Sheet: Labour

Price's
Plot/Type | [NAME] | Removal of | Joists 1st | Roof | Low Level | 1st Fix | External | 2nd Fix | Final
 |  | Joists | floor |  | Levels |  | doors
 |  | 130 | 470 | 1100 | 340 |  | 130 | 830
 | 170 |  | 360 | 940 | 80 | 920 | 130 | 870 | 200
 |  | 130 |  | 1220 | 570 | 740 | 130 | 700 | 150
 |  |  |  | 7
Spreadsheet: 839449d1691995653-need-de-normalize-the-raw-data-into-many-rows-but-less-column-version-need_denormalize_rawdata_into_duplicate_way-1
Sheet: Output

 | custno | custtype | product_1 | qty_1 | price_1 | country_1 | city_1 | location_1
A000001 | 100001 | B | Banana03 | 200 | 5.5 | USA | New York | NY221
A000001 | 100001 | B | Banana03 | 200 | 5.5 | UK | London | [NAME]
A000001 | 100001 | B | Banana03 | 200 | 5.5 | Japan | Tokyo | TY950
A000001 | 100001 | B | Apple02 | 140 | 9.6 | USA | New York | NY221
A000001 | 100001 | B | Apple02 | 140 | 9.6 | UK | London | [NAME]
A000001 | 100001 | B | Apple02 | 140 | 9.6 | Japan | Tokyo | TY950
A000001 | 100001 | B | Orange01 | 120 | 8.7 | USA | New York | NY221
A000001 | 100001 | B | Orange01 | 120 | 8.7 | UK | London | [NAME]
A000001 | 100001 | B | Orange01 | 120 | 8.7 | Japan | Tokyo | TY950
A000002 | 100002 | A | Apple02 | 110 | 9.6 | Japan | Osaka | OK910
A000002 | 100002 | A | Apple02 | 110 | 9.6 | Deutschland | Berlin | BE312
A000002 | 100002 | A | Apple02 | 110 | 9.6 | Nederland | Amsterdam | [NAME]
A000002 | 100002 | A | Apple02 | 110 | 9.6 | France | Paris | PS532
A000002 | 100002 | A | Banana01 | 70 | 5.8 | Japan | Osaka | OK910
A000002 | 100002 | A | Banana01 | 70 | 5.8 | Deutschland | Berlin | BE312
A000002 | 100002 | A | Banana01 | 70 | 5.8 | Nederland | Amsterdam | [NAME]
A000002 | 100002 | A | Banana01 | 70 | 5.8 | France | Paris | PS532
Spreadsheet: 631609d1562749681-distance-between-coordinates-shown-in-a-sorted-list-xlf_1282014c
Sheet: Source Data

Location ID | Coordinate X | Coordinate Y
PG343 | 646860 | 248249
PL122 | 646860 | 248249
[NAME] | 647150 | 249980
KO420 | 665069 | 259111
OL942 | 656550 | 256150
PY492 | 643443 | 237911
PT940 | 643443 | 237911
HY675 | 655820 | 257720
[NAME] | 656260 | 249240
KH387 | 648322 | 246675
UB482 | 655642 | 247923
HF029 | 653510 | 246900
RH392 | 653510 | 246900
LN392 | 671310 | 243990
ES492 | 650560 | 236088
NJ111 | 656622 | 232628
LK392 | 656622 | 232628
KL329 | 635070 | 236500
GF329 | 635070 | 236500
DF392 | 633251 | 239845
DR029 | 638611 | 263271
SD932 | 637023 | 261981
WE942 | 637023 | 261981
DE902 | 668849 | 245006
[NAME] | 665580 | 258800
RH992 | 665580 | 258800
LR012 | 645850 | 249150
[NAME] | 665470 | 258450
OR654 | 668855 | 245017
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 |  | -756
500046 | -1951 |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -6459 | -11159
500528
500529
500619
INDEX
2001-12-31 00:00:00 |  |  | -538712.04
2002-01-03 00:00:00
CBS Volume
 |  |  | -37276
Spreadsheet: 108151d1305223772-using-match-with-dates-example
Sheet: Alfa

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
Dates | 2011-04-16 22:32:24 | 2011-04-17 04:47:21 | 2011-04-17 11:01:21 | 2011-04-17 17:30:21 | 2011-04-18 02:00:21 | 2011-04-18 09:38:21 | 2011-04-18 16:14:21 | 2011-04-19 08:51:23 | 2011-04-19 19:54:23 | 2011-04-20 00:53:23
Spreadsheet: 493095d1481496330-excel-project-storing-data-and-generating-reports-sending-emails-automaticly-sample_proj
Sheet: worn

Associate | Figure 1 10AM | Figure 1 11AM | Total
[NAME] | 55 | 30
Erline Paylor | 54 | 26
[NAME] | 10 | 3
Gigi Slay | 40 | 0
Spreadsheet: 760223d1640084320-suming-values-based-of-multiple-column-categories-and-comparing-month-to-month-calc-based-off-moving-categories-month-on-month
Sheet: Sheet1

 | DATA SET |  |  |  |  |  |  |  |  | OUTPUT
 | Period | Value | Name | Category | YN | Change | Value2 |  | 1 | A | C | A
 | 1 | 16 | [NAME] | A |  |  |  |  |  | to | to | to
 | 1 | 37 | [NAME] | A |  |  |  |  | 2 | C | A | B
 | 1 | 41 | [NAME] | B |  |  |  |  |  |  |  |  | <---Automate
 | 1 | 74 | [NAME] | B
 | 1 | 85 | [NAME] | C
 | 1 | 44 | [NAME] | C |  |  |  |  |  | Sum of Value2 | Change
 | 1 | 65 | [NAME] | C |  |  |  |  |  | Category |  | A | B | C
 | 1 | 42 | Zac | A |  |  |  |  |  | A | 0 |  | 42 | 37
 | 2 | 98 | [NAME] | A |  |  |  |  |  | B | 0
 | 2 | 54 | [NAME] | C |  |  |  |  |  | C | 0 | 129
 | 2 | 12 | [NAME] | B |  |  |  |  |  | Grand Total | 0 | 129 | 42 | 37
 | 2 | 9 | [NAME] | B
 | 2 | 45 | [NAME] | A
 | 2 | 8 | [NAME] | A
 | 2 | 34 | [NAME] | C
 | 2 | 30 | Zac | B
Spreadsheet: 744128d1628976301-conditional-formatting-cell-if-value-exists-on-another-table-with-the-same-column-header-mismatch-finder-v3-081321-help-1-
Sheet: Data Worksheet

Animal | Vegetable | Soda | Mineral |  |  |  |  |  | formula test
Moose | Squash | Silver | Dog
Potato | Celery | Pepsi | [NAME]
syrup | Platinum | Gold | Coke
[NAME] | Lead | [NAME] | horse
Spreadsheet: 761009d1640600575-ranking-with-sumproduct-sumproduct
Sheet: Plan2

Quality |  |  | Ranking with 2 criteria (accuracy and number of evaluations
Ranking | Membro | TOTAL ACCURACY | Evaluations
 | Agent 1 | 1 | 10
 | Agent 2 | 1 | 8
 | Agent 3 | 0.902 | 15
Satisfaction |  |  | Ranking with 3 criteria (total satisfaction, number of surveys received and calls answered)
Ranking | Membro | Total SAT | Surveys | Answered
 | Agent 6 | 1 | 10 | 268
 | Agent 11 | 1 | 8 | 293
 | Agent 8 | 1 | 6 | 330
 | Agent 2 | 1 | 4 | 223
 | Agent 1 | 1 | 2 | 210
 | Agent 10 | 0.8888888888888888 | 8 | 170
 | Agent 4 | 0.8571428571428571 | 6 | 275
 | Agent 5 | 0.8333333333333334 | 5 | 312
 | Agent 7 | 0.8125 | 13 | 277
 | Agent 9 | 0.6666666666666666 | 4 | 220
 | Agent 3 | 0.5 | 3 | 270
Spreadsheet: 683059d1592470033-adding-number-of-yes-cells-for-rows-of-the-same-date-example
Sheet: Input

TODAY | X | Y | Z | A? | B?
2020-06-18 00:00:00 | YES | NO | YES | NO | YES
2020-06-18 00:00:00 | YES | YES | YES | YES | NO
2020-06-18 00:00:00 | NO | YES | NO | YES | NO
2020-06-19 00:00:00 | NO | NO | YES | YES | NO
2020-06-19 00:00:00 | YES | NO | NO | NO | NO
Spreadsheet: 11288d26-b539-4904-8073-14d1fa8c21d9
Sheet: Sheet1

STATE OBLIGATIONS FOR LOCAL HIGHWAYS - 1996  1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
RECEIPTS AND DISBURSEMENTS FOR DEBT SERVICE
OCTOBER 1997 |  | (THOUSANDS OF DOLLARS) |  |  |  |  |  |  |  |  | "TABLE SB-3L
 | BALANCE | RECEIPTS |  |  |  |  | DISBURSEMENTS
 | IN SINKING |  |  |  |  |  | INTEREST AND ADMINISTRATION |  |  |  | BALANCE
 | FUND OR | HIGHWAY- | NET |  |  |  |  |  |  |  | IN SINKING
STATE | DEBT RESERVE | USER | EARNINGS | OTHER | PROCEEDS OF | TOTAL |  | ADMINISTRATION, | NET | TOTAL | FUND OR
 | BEGINNING | REVENUES | FROM | INCOME | SALE OF BONDS | RECEIPTS | INTEREST | PAYING AGENT | REDEMPTION | DISBURSEMENTS | DEBT RESERVE
 | OF YEAR |  | INVESTMENTS |  |  |  |  | FEES ETC. |  |  | END OF YEAR
Alaska | 0 | 0 | 0 | 208 | 0 | 208 | 36 | 0 | 172 | 208 | 0
Dist. of Col. | 0 | 24982 | 0 | 0 | 38733 | 63715 | 11403 | 0 | 52312 | 63715 | 0
Florida | 11748 | 9448 | 823 | 12401 | 0 | 22672 | 3735 | 14 | 17920 | 21669 | 12751
Louisiana | 0 | 772 | 0 | 0 | 0 | 772 | 332 | 0 | 440 | 772 | 0
Maryland | 6505 | 5604 | 309 | 0 | 0 | 5913 | 1057 | 0 | 4950 | 6007 | 6411
Massachusetts | 0 | 1331 | 0 | 0 | 0 | 1331 | 1331 | 0 | 0 | 1331 | 0
Michigan | 0 | 14561.7706557377 | 0 | 0 | 0 | 14561.7706557377 | 2268.36493852459 | 0.4057172131147541 | 12293 | 14561.7706557377 | 0
Mississippi | 1584 | 3410 | 0 | 0 | 0 | 3410 | 531 | 3 | 3000 | 3534 | 1460
New Jersey | 0 | 11032 | 0 | 0 | 100000 | 111032 | 7027 | 0 | 104005 | 111032 | 0
New York | 122003 | 22608 | 0 | 0 | 0 | 22608 | 56461 | 0 | 30930 | 87391 | 57220
Washington | 0 | 26616 | 0 | 0 | 7274 | 33890 | 9297 | 93 | 24500 | 33890 | 0
Total | 141840 | 120364.7706557377 | 1132 | 12609 | 146007 | 280112.7706557377 | 93478.3649385246 | 110.4057172131148 | 250522 | 344110.7706557377 | 77842
1/  This table shows the receipts and disbursements for the debt service of State obligations issued to fund State expenditures on local highways, or State transfers to local governments for highways.
Amounts shown are included in the totals on Table SB-3.  Only includes States with outstanding obligations for local roads.  See Table SB-1 for general note on SB series.   This table is  compiled from
reports of State authorities.
Spreadsheet: 676203d1588701085-countif-varying-range-data-1-
Sheet: Info

Week |  |  |  |  | Result
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | YES
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | YES
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
17 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | YES
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
18 |  |  |  |  | NO
19 |  |  |  |  | YES
19 |  |  |  |  | NO
19 |  |  |  |  | YES
19 |  |  |  |  | NO
19 |  |  |  |  | YES
19 |  |  |  |  | YES
Spreadsheet: 808453d1670476936-task-required-based-on-frequency-occurrence-hd
Sheet: Sheet1

Room | Start date | End date | Cleaning dates
1 | 2022-12-10 00:00:00 | 2022-12-13 00:00:00
2 | 2022-12-10 00:00:00 | 2022-12-14 00:00:00
3 | 2022-12-12 00:00:00 | 2023-01-12 00:00:00 |  | 2022-12-24 00:00:00 | 2023-01-01 00:00:00 | 2023-01-09 00:00:00
4