tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 846180d1697467633-listng-team-wise-names-from-a-list-pete_uk-solution
Sheet: Sheet1

Sno | Name | Department | Designation | Category | Team
1 | Naveena | Administration | Accountant | A | IPL-D
2 | Nandini | Housekeeping | Supervisor - Housekeeping | B | IPL-C
3 | Satish | Operations | Supervisor - Operations | D | IPL-B
4 | Sunil | Inpark Sales | Assistant Manager - Revenue Operations | D | IPL-A
5 | Basavaraj | Inpark Sales | Executive - Inpark Sales | E | IPL-C
6 | Manjunath | Maintenance | Manager - Maintenance | F | IPL-D
7 | Devaraju | Maintenance | Assistant Manager - Maintenance | G | IPL-C
8 | Girish | Maintenance | Assistant Manager - Stores | G | IPL-B
9 | Madhu | Maintenance | Executive - Maintenance | G | IPL-B
10 | Raju | Maintenance | Executive - Maintenance | G | IPL-A
11 | Ravikiran | Maintenance | Assistant Manager -Maintenance | G | IPL-A
12 | Meghana | Marketing | Digital Marketing Specialist | H | IPL-D
13 | Veena | Operations | Assistant Manager-Snow Park Operations | I | IPL-A
14 | [NAME] (FnB) | Restaurant | Assistant [NAME] | J | IPL-B
15 | Venkatesh H P | Restaurant | Executive - F & B | J | IPL-C
16 | Venkatesh B | Sales | Area Sales Manager (Off: [PHONE]) | K | IPL-D
Use this formula in cell G2:
=F2&"_"&COUNTIF(F$2:F2,F2)
Copy down to the bottom of your table. Then you can use this formula in cell I4:
=IFERROR(INDEX($B:$B,MATCH(I$3&"_"&ROWS($1:1),$G:$G,0)),"")
Copy across and down as required.
Hope this helps.
[NAME]
Spreadsheet: 698923d1602251927-trying-to-generate-a-report-based-on-time-sheet-groups-by-earn-codes-time-sample
Sheet: Sheet2

UserId | Period | Name | EarnCode | Total Hours |  |  |  | Code
10 | 1/5/2018-1/18/2018 | [NAME] | Regular | 31.88 |  |  |  | Regular
16 | 1/5/2018-1/18/2018 | [NAME] | Regular | 32.63
20 | 1/5/2018-1/18/2018 | Goege Fly | Regular | 68.9
5 | 1/5/2018-1/18/2018 | [NAME] | Regular | 39.35
6 | 1/5/2018-1/18/2018 | [NAME] | Regular | 63.13
8 | 1/5/2018-1/18/2018 | [NAME] | Regular | 67.67
10 | 1/19/2018-2/1/2018 | [NAME] | Regular | 31.92
16 | 1/19/2018-2/1/2018 | [NAME] | Regular | 62.45
20 | 1/19/2018-2/1/2018 | Goege Fly | Regular | 79.32
21 | 1/19/2018-2/1/2018 | [NAME] | Regular | 7.57
5 | 1/19/2018-2/1/2018 | [NAME] | Regular | 37.73
6 | 1/19/2018-2/1/2018 | [NAME] | Regular | 75.17999999999999
8 | 1/19/2018-2/1/2018 | [NAME] | Regular | 76.48
Spreadsheet: 57619d1257842779-macro-for-auto-report-in-excell-general-ledger
Sheet: 1001

 | BANK - 1001
 | DATE | A/C NAME | A/C NO | REF# | PARTICULARS | DR. | CR. | DR./ CR. | BALANCE |  |  |  |  | BANK | 1001
 | Opening Balance |  |  |  |  |  |  | - | 0 |  |  |  |  | CASH | 1002
 | 2009-11-01 00:00:00 | BANK | 1001 | 4588 | CASH RECEIVED FROM DEVID | 500 |  | Dr. | 500 |  |  |  |  | LOAN | 1003
 | 2009-11-03 00:00:00 | BANK | 1001 | 4590 | PAID TO MICHLE |  | 50 | Cr. | -50 |  |  |  |  | SALARIES | 1004
 | 2009-11-05 00:00:00 | BANK | 1001 | 4592 | WDRL PETTY CASH |  | 100 | Cr. | -100 |  |  |  |  | PETROL | 1005
 | 2009-11-12 00:00:00 | BANK | 1001 | 4599 | CHQ # 405 |  | 500 | Cr. | -500 |  |  |  |  | MAINT | 1006
 |  |  |  |  |  |  |  | - | 0
 |  |  |  |  | TOTAL | 500 | 650 | Cr. | -150
Spreadsheet: f2dbecdb-ecc9-47b6-9318-0fd39ef3e67c
Sheet: Sheet1

2562 642 Ócsa–Újhartyán | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
(Érvényes: 2011. december 11-től)
 |  |  |  |  | 642
Km | Km | Km | Km | VOLÁNBUSZ Zrt. | 4
 |  |  |  |  | I
0 | .. | 0 | .. | Ócsa, vá. | 14:05:00
0.4 | .. | S | .. | Ócsa, Bolyai J. Gimnázium | 14:06:00
1 | .. | S | .. | Ócsa, [NAME] templom | 14:07:00
1.3 | .. | S | .. | Ócsa, vh. | 14:08:00
3 | .. | 1.4 | .. | Ócsa, [NAME] | 14:13:00
12.3 | .. | .. | .. | Inárcsi elág. (M5-ös út) | 14:22:00
12.7 | .. | .. | .. | Inárcs, Iskola u. | 14:25:00
13.6 | .. | .. | .. | Inárcs, Bajcsy Zs. u. 51. | 14:26:00
14.2 | .. | .. | .. | Inárcs, [NAME]. | 14:27:00
14.9 | .. | .. | .. | Inárcs, új iskola | 14:28:00
15.6 | .. | .. | .. | Kakucs, Ságvári u. | 14:29:00
16.4 | .. | .. | .. | Kakucs, Bem u. | 14:30:00
17 | .. | .. | .. | Kakucs, Sastelep u. | 14:31:00
17.9 | .. | .. | .. | Kakucs, aut. ford. | 14:32:00
20 | .. | .. | .. | Újhartyán, dabasi elág. | 14:35:00
20.5 | .. | .. | .. | Újhartyán, sz. vend. | 14:36:00
21.1 | .. | .. | .. | Újhartyán, [NAME] tere | 14:37:00
21.6 | .. | .. | .. | Újhartyán, szervíz bej. út | 14:38:00
21.9 | .. | .. | .. | Újhartyán, szervíz | 14:39:00
[NAME]:
I | tanítási napokon
S | a járat nem érinti a megállóhelyet, [NAME]
Spreadsheet: 761529d1640992302-conditional-formatting-based-on-sum-of-values-with-the-same-entries-in-another-column-book
Sheet: Sheet1

ID | Name | Account | Team | Role | Norm/Rec/OT | 1/1/2022 | 1/2/2022 | 1/3/2022 | 1/4/2022 | 1/5/2022 | 1/6/2022 | 1/7/2022 | 1/8/2022 | 1/9/2022 | 1/10/2022 | 1/11/2022 | 1/12/2022 | 1/13/2022 | 1/14/2022 | 1/15/2022 | 1/16/2022 | 1/17/2022 | 1/18/2022 | 1/19/2022 | 1/20/2022 | 1/21/2022 | 1/22/2022 | 1/23/2022 | 1/24/2022 | 1/25/2022 | 1/26/2022 | 1/27/2022 | 1/28/2022 | 1/29/2022 | [NAME] | 1/31/2022
1 | [NAME] |  | Team 1 |  | Norm | Absent |  | 4 |  |  | 4
 | [NAME] |  | Team 2 |  | Norm | Absent |  | 3 |  |  | 4
 | [NAME] |  | Team 1 |  | Norm |  |  | 4 |  |  | 3
 | [NAME] |  | Team 1 |  | OT |  |  | 2 |  |  | 4
 | [NAME] |  | Team 2 |  | Norm |  |  | 4 |  |  | 3
 | [NAME] |  | Team 1 |  | Norm |  |  |  | 4
 | [NAME] |  | Team 3 |  | Norm |  |  |  |  |  |  | 7
 | [NAME] |  | Team 2 |  | Norm |  |  |  | 3
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  | 9
 |  |  |  |  | 10
 |  |  |  |  | 11
 |  |  |  |  | 12
 |  |  |  |  | 13
Spreadsheet: CharReport_Demo
Sheet: May

Customer Characteristics Report
 |  | Amount funded: | Total $ Funded: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
May |  | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Customer Name | Date | Dealer | Approved By | Tier | [NAME] | [NAME] | S-Yield | Amt Fin | FICO Primary | Term | [NAME] | Year of Vehicle | Make | Model | Payment | Down Payment | Trade | Rebate | LTV % line 3 | LTV % line 5 | PTI | DTI | FICO - Co | Discount | Part Points | Part $ | Rent/Own | Time @ Res in Years | Time @ Job Primary | Time @ Job CO | Age Primary | Age    CO | Warranty | GAP | Within Program | Comments
Spreadsheet: 219569d1362787773-staff-scheduler-cant-quite-get-it-right-schedule-helpsol1
Sheet: Dining Services Schedule Master

 |  |  |  | Schedule
 |  |  | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat |  | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Week 1 Totals | Week 2 Totals
 | Leadership | Status | 2013-03-03 00:00:00
 | Leader 1 | Exempt | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | COOKS
 | Cook1 | F/T
 | Cook2 | P/T
 | Cook3 | P/T
 | AIDES
 | Aide1 | F/T
 | Aide2 | P/T
 | Aide3 | F/T
 | Aide4 | PRN
 |  | Schedules |  |  |  |  |  |  | TTL Hours | M |  |  | Events and Activities
 |  | Position # | 1 | AM COOK |  | 06:00:00 | - | 02:30:00 |  | x
 |  | Position # | 2 | [NAME] |  | 11:00:00 | - | 07:30:00 |  | x
 |  | Position # | 3 | AM AIDE 1 |  | 07:00:00 | - | 03:30:00 |  | x
 |  | Position # | 4 | AM AIDE 2 |  |  | - |  |  | x
 |  | Position # | 5 | PM AIDE 1 |  | 08:00:00 | - | 04:00:00 |  | x
 |  | Position # | 6 | PM AIDE 2 |  | 04:00:00 | - | 08:00:00
 |  | Position # | 7 | LEGACY 1 |  | 07:00:00 | - | 03:30:00 |  | x
 |  | Position # | 8 | LEGACY 2 |  | 10:00:00 | - | 07:00:00
 |  |  | *Schedules will be updated and hours allocated based on campus census…hours and schedules are subject to change without notice
Spreadsheet: john_lavorato__16504__FundTrades
Sheet: Work-in-Progress

Name | Under Mgt | Style | Status
AIG Intl Asset Mgt | $100-200mm | Relative value & spreads, no directional plays, will do physical commodity | ISDA sent in Feb 00, under negotiation, pending resolution of margining arrangement, can't accept l/c's
[NAME] | $170-200mm | Global Macro, active Natgas trader | ISDA sent in Feb 00, under negotiation, pending resolution of margining arrangement, can't accept l/c's, need cash only. Negotiations ung up on this point, but cleared no that Enron will post cash.
Campbell | $500mm+ | CTA, system trader, no discretion, has been futures only | Need "A" rating for trading partner. Wants to execute Natgas through us. Sent draft of our docs with type of l/c we can post. Under negotiation
Durkee Capital | $250mm+ | CTA, absolute return & overlay, no discretion, system trader | Looking to include natgas in his model. Appears to have good fit, needs people resource to complete analysis. Can execute OTC. Pending completion of his analysis of natgas fit. Provided historical data for his use.
Global Advisors | $80-120mm | Global Macro, active energy trader, including physical | Recently set up, wants to establish trading partnership with us. Docs under preparation pending receipt of their financials.
[NAME] | $300-500 | Global Macro, not active in energies, but considering | Was looking at setting up docs, but recent fund withdrawals led to cut back on traders, unlikely for time being
[NAME] | $1 billion+ | Global Macro, relative value & spreads, doen't like directional, some physical | 2 year plus long credit and doc negotiation. Needed "A" rating, but recently made acception for Enron. Major road block cleared and expect docs ot be completed in the next month
Lawhill Capital | $25-50mm | Global Macro, Enron was small initial investor backing [NAME] | ISDA under final stages of negotiation, was held up by departure of in house FD this summer.
Moore Capital | $2-3 billion | Global Macro, mainly crude oil markets, but some interest in natgas | Approaching cautiously. Has reputation for picking off market makers. Seems willing to work differently with us, hasn't been focussing on natgas this year and ISDA doc negotiations have languished. Still pursuing.
Omega Advisors | $500mm+ | Global Macro, equity oriented, emerging markets | Was trading with us in 1998-99, but commodity trader left and no one took over. Big hit on emerging market made them risk adverse. Will pursue later this year for update.
Soros Fund Mgt | $3 billion+ | Global Macro, will trade all commodities, value & directional | Had dialogue started early in 2000, but has failed to generate momentum to start ISDA negotiations. [NAME] has been hit with withdrawals and moved to more conservative approach, not surre of continued commitment to commodities.
Spreadsheet: 825794d1681525328-why-im-getting-all-100-investment_sample-renhoek84-
Sheet: sample

market | Financial Services
Row Labels | Count of country_code | Average of seed | Min of seed | [NAME] of seed
BRA | 1 | 2000000 | 2000000 | 2000000
ITA | 1 | 1287243 | 1287243 | 1287243
IND | 3 | 1266666.666666667 | 0 | 3000000
DEU | 3 | 1111412 | 0 | 3161435
CHE | 2 | 1010176 | 1000000 | 1020352
NULL | 12 | 807291.6666666666 | 0 | 3770000
GBR | 6 | 664772 | 0 | 3351100
JPN | 2 | 598083 | 0 | 1196166
LTU | 1 | 539800 | 539800 | 539800
FRA | 3 | 490612.6666666667 | 0 | 1323515
CAN | 1 | 400000 | 400000 | 400000
USA | 65 | 345168.5076923077 | 0 | 4400000
SGP | 1 | 300000 | 300000 | 300000
RUS | 5 | 189191.6 | 0 | 500000
HKG | 1 | 41250 | 41250 | 41250
BWA | 1 | 20352 | 20352 | 20352
ARG | 1 | 0 | 0 | 0
CHN | 2 | 0 | 0 | 0
ESP | 1 | 0 | 0 | 0
LVA | 1 | 0 | 0 | 0
POL | 1 | 0 | 0 | 0
Grand Total | 114 | 469028.7719298246 | 0 | 4400000
market | Financial Services
Row Labels | Count of country_code
USA | 0.5701754385964912
NULL | 0.1052631578947368
GBR | 0.05263157894736842
RUS | 0.04385964912280702
FRA | 0.02631578947368421
DEU | 0.02631578947368421
IND | 0.02631578947368421
CHN | 0.01754385964912281
CHE | 0.01754385964912281
JPN | 0.01754385964912281
POL | 0.008771929824561403
LVA | 0.008771929824561403
SGP | 0.008771929824561403
CAN | 0.008771929824561403
BWA | 0.008771929824561403
ITA | 0.008771929824561403
BRA | 0.008771929824561403
ESP | 0.008771929824561403
ARG | 0.008771929824561403
LTU | 0.008771929824561403
HKG | 0.008771929824561403
Grand Total | 1
market | Financial Services
Row Labels | Sum of equity_crowdfunding
ARG | 0
BRA | 0
BWA | 0
CAN | 0
CHE | 0
CHN | 0
DEU | 0
ESP | 0
FRA | 1
GBR | 0
HKG | 0
IND | 0
ITA | 0
JPN | 0
LTU | 0
LVA | 0
NULL | 0
POL | 0
RUS | 0
SGP | 0
USA | 0
Grand Total | 1
market | Financial Services
 | Column Labels
Values | ARG | BRA | BWA | CAN | CHE | CHN | DEU | ESP | FRA | GBR | HKG | IND | ITA | JPN | LTU | LVA | NULL | POL | RUS | SGP | USA | Grand Total |  | Financial Services | Percent USA
Count of seed | 1 | 1 | 1 | 1 | 2 | 2 | 3 | 1 | 3 | 6 | 1 | 3 | 1 | 2 | 1 | 1 | 12 | 1 | 5 | 1 | 65 | 114
Sum of venture | 4000000 | 14300000 | 0 | 13000000 | 0 | 14000000 | 0 | 0 | 7476573 | 23150000 | 0 | 0 | 0 | 3300000 | 0 | 6200000 | 13770000 | 1000000 | 17000000 | 0 | 265331541 | 382528114
Sum of equity_crowdfunding | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 398097 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 398097
Sum of undisclosed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 2000000 | 0 | 34185000 | 36195000
Sum of debt_financing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14983424 | 1000000 | 0 | 0 | 0 | 0 | 0 | 0 | 42750 | 0 | 0 | 0 | 63000000 | 79026174
Sum of private_equity | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150000 | 167000000 | 167150000
Sum of convertible_note | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 218f663f-ce0c-4580-a65e-8f7f8d2973f8
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Religion
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 220995d1363345977-shift-horizontal-range-of-text-based-on-a-parameter-copy-formula-down-across-shift-date-example
Sheet: Shift Date Example

 |  |  | 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 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00
 | Original Source Date
 |  | PO1 | 27 | 28 | 29 | 30 | 31 | [NAME] |  |  | pac | 10 | 10 | 10 | 10
 |  | PO2 | 54 | 56 | 58 | 60 | 62 |  |  | [NAME] |  |  | PAC | 20 | 20
 |  |  | 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 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00
 | Shifted Date
 |  | PO1 |  |  | 27 | 28 | 29 | 30 | 31 | [NAME] |  |  | pac | 10 | 10
 |  | PO2 |  |  | 54 | 56 | 58 | 60 | 62 |  |  | [NAME] |  |  | PAC
 |  | Month Delay Parameter | 2 | enter this number and it will shift the row "x" columns to the right
 |  |  |  | User must be able to enter different numbers and see the effect (delay) by number of months
 |  |  |  | Example: if we delay raising a Purchase Order by 2-months it delays PPAC date and PAC date by 2-months.
Spreadsheet: 814459d1674409602-copy-project-data-to-respective-tabs-excel-example
Sheet: C

Project | Data field 1 | Data field 2 | Data field 3 | Data field 4 | Data field 5
C | 8105 | 7907 | 4673 | 595 | 2459
C | 5274 | 2412 | 5285 | 5238 | 580
C | 9146 | 7062 | 9859 | 2551 | 4902
Spreadsheet: 875924d1722533490-single-list-according-to-designated-data-unique-list-according-designated-data-danilo-flaiban-
Sheet: Plan1

Filial | PURCHASES | Prf-Numero Parcela | Tp | Natureza | Data de Emissao | Data de Vencto | [NAME] | VALUE | TAXES | COUNTS | HISTORIC | BANK
01 | KJLKLKLÇKÇ | 1 | 1 | 1 | 1 | 1 | 1 | 1020 |  | CREDITO CC | SDFGHSDFGHS | DFB
02 | FUKLFGJHLGHKLG | 1 | 1 | 1 | 1 | 1 | 1 | 1100.52 |  | CREDITO CC | SDFGHSDFGHS | DFB
01 | ~UJLÇ~UÇ | 1 | 1 | 1 | 1 | 1 | 1 | 563.2 |  | DOC | SDFGHSDFGHS | DFB
01 | ~IKÇO~UIOT | 1 | 1 | 1 | 1 | 1 | 1 | 1606 |  | CONCESSIONARIAS | SDFGHSDFGHS | DFB
01 | YUILÇ~L~L | 1 | 1 | 1 | 1 | 1 | 1 | 1412 |  | BOLETOS ITAÚ | SDFGHSDFGHS | DFB
01 | ~JHKLÇ | 1 | 1 | 1 | 1 | 1 | 1 | 280 |  | BOLETOS ITAÚ | SDFGHSDFGHS | DFB
01 | IKLO~U | 1 | 1 | 1 | 1 | 1 | 1 | 857.38 |  | BOLETOS ITAÚ | SDFGHSDFGHS | DFB
01 | SDFGH | 1 | 1 | 1 | 1 | 1 | 1 | 790 |  | BOLETOS ITAÚ | SDFGHSDFGHS | DFB
01 | FGHKU | 1 | 1 | 1 | 1 | 1 | 1 | 8100 |  | BOLETOS ITAÚ | SDFGHSDFGHS | DFB
06 | YULYUIÇYIO | 1 | 1 | 1 | 1 | 1 | 1 | 487.44 |  | BOLETOS ITAÚ | SDFGHSDFGHS | DFB
01 | DFHDJ | 1 | 1 | 1 | 1 | 1 | 1 | 4750 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
01 | UIOLÇ | 1 | 1 | 1 | 1 | 1 | 1 | 36877.74 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
01 | 003722-01-BELENUS | 1 | 1 | 1 | 1 | 1 | 1 | 9375.95 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
01 | RTYIRGJHD | 1 | 1 | 1 | 1 | 1 | 1 | 754.8 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
01 | RUJRJUI | 1 | 1 | 1 | 1 | 1 | 1 | 37500 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
01 | RTYUSDFG | 1 | 1 | 1 | 1 | 1 | 1 | 900 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
02 | GIHLGHKÇHK | 1 | 1 | 1 | 1 | 1 | 1 | 1680 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
02 | DGNXCVNCVHK | 1 | 1 | 1 | 1 | 1 | 1 | 400.8 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
05 | 003654-01-O COLIGADO | 1 | 1 | 1 | 1 | 1 | 1 | 313.5 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
05 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 387.54 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
05 | SEDTUYIK | 1 | 1 | 1 | 1 | 1 | 1 | 1025 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
07 | DFGHSDFHBSDXCVB | 1 | 1 | 1 | 1 | 1 | 1 | 3903.2 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
07 | SDFGUHDFGNVCHK | 1 | 1 | 1 | 1 | 1 | 1 | 280 |  | BOLETOS DIVERSOS | SDFGHSDFGHS | DFB
01 | FVGHJFGH | 1 | 1 | 1 | 1 | 1 | 1 | 3014.55 |  | [NAME] | SDFGHSDFGHS | DFB
01 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1266298.15 |  | TRIBUTOS | SDFGHSDFGHS | DFB
01 | SDHY | 1 | 1 | 1 | 1 | 1 | 1 | 468323.19 |  | TRIBUTOS | SDFGHSDFGHS | DFB
07 | ~JK.ÇYHI06 | 1 | 1 | 1 | 1 | 1 | 1 | 552.61 |  | TRIBUTOS | SDFGHSDFGHS | DFB
 | TOTAL DE PAGAMENTOS
 |  |  |  |  |  |  | This Formula |  | Return This Sequence
 |  |  |  |  |  |  |  |  | CREDITO CC
 |  |  |  |  |  |  |  |  | DOC
 |  |  |  |  |  |  |  |  | CONCESSIONARIAS
 |  |  |  |  |  |  |  |  | BOLETOS ITAÚ
 |  |  |  |  |  |  |  |  | BOLETOS DIVERSOS
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | TRIBUTOS
Spreadsheet: 85e34ee8-602c-4867-8f66-44cbe65b0c45
Sheet: Sheet1

Phone # | Job Title | Employee Name | Program
2632 | OAII/Transporter | [NAME] | Nespelem
2684 | Support Specialist | [NAME] | Nespelem
7415/7438 | Youth Coordinator | [NAME] | Omak
2290/2291 | OA II/Receptionist | [NAME] | Nespelem
7419 | Social Worker II | [NAME] | Omak
2775 | Social Worker II | [NAME] | Nespelem
2628 | Social Worker II | [NAME] | Nespelem
2685 | Social Worker II | [NAME] | Nespelem
722-6181 x306 | Youth Coordinator (Assistant) | [NAME] | Inchelium
7600 | Youth & Family Coordinator | [NAME] | Inchelium
2689 | Audit/Fraud Investigator | [NAME] | Nespelem
2676 | Office Assistant III | [NAME] | Nespelem
2686 | Support Specialist | Clarice Kuehne | Nespelem
2199 | Youth Coordinator | [NAME] | [NAME]
2674 | OA III/Data Entry | [NAME] | Nespelem
2687 | Building Maintenance Supervisor | [NAME] "Doc" Mellon | Nespelem
7415/7438 | Youth Coordinator (Assistant) | [NAME] | Omak
7405 | Support Specialist | [NAME] | Omak
7414 | Social Worker II | [NAME] | Omak
2371 | Youth Coordinator | [NAME] | Nespelem
2627 | Office Administrator | [NAME] | Nespelem
7403 | OA II/Receptionist | [NAME] | Omak
2673 | Training & Development Specialist | [NAME] | Nespelem
2371 | Youth Coordinator (Assistant) | Virginia Redstar | Nespelem
2621 | Program Manager II | [NAME] | Nespelem
2681 | Youth Office Asst.II | [NAME] | Nespelem
7043 | Support Specialist | [NAME] | Inchelium
2679 | Office Assistant III | [NAME] | Nespelem
2688 | Support Specialist | [NAME] | Nespelem
7423 | Social Worker II | [NAME] | Omak
2675 | Accountant Technician | [NAME] | Nespelem
2683 | Social Worker I | [NAME] | Nespelem
2199 | Youth Coordinator (Assistant) | [NAME] | [NAME]
7404 | Support Specialist | [NAME] | Omak
2682 | Social Worker II | Issac Wak Wak | Nespelem
2623 | OA II/Transporter | [NAME] | Nespelem
722-6181 x306 | Youth Coordinator | [NAME] | Inchelium
Spreadsheet: 747322d1631383218-how-to-fix-time-calculation-eftimecard
Sheet: Week 1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total duration
 | Person 1 |  |  |  |  |  | Minute | Person 2
 | 1 | 2021-05-01 00:00:00 | 07:02:00 | 09:02:00 |  |  |  | 1 | 2021-05-04 00:00:00 | 08:27:00 | 11:21:00
 | 2 | 2021-05-02 00:00:00 | 07:34:00 | 09:36:00 |  |  |  | 2 |  |  |  |  |  |  |  | Total Shifts
 | 3 | 2021-05-03 00:00:00 | 19:35:00 | 23:37:00 |  |  |  | 3
 | 4 | 2021-05-04 00:00:00 | 06:28:00 | 07:31:00 |  |  |  | 4
 | 5 | 2021-05-05 00:00:00 | 18:00:00 | 22:59:00 |  |  |  | 5
 | 6 | 2021-05-06 00:00:00 | 09:23:00 | 12:28:00
 | 7 | 2021-05-07 00:00:00 | 21:44:00 | 23:44:00
 | 8 | 2021-05-08 00:00:00 | 06:00:00 | 10:30:00
 | 9 | 2021-05-09 00:00:00 | 09:02:00 | 23:02:00
 | 10
 | 11
 | 12
 | 13
 | 14
Spreadsheet: 149376d1333899877-complex-if-statement-example-5
Sheet: Sheet4

 |  |  | [NAME] |  |  | Home | Away
 | Over |  |  |  | Current Score | 1 | 0 |  | 14 |  | 27
 | Under |  |  |  | Final Score | 5 | 0
 |  |  | Asian Handicap IP
Spreadsheet: 769375d1645518121-time-difference-between-two-dates-but-subtracting-sum-of-inbetween-rows-in-adjacent-column-pseudo
Sheet: Sheet1

START DATE | END DATE | DURATION (s) | EQUIPMENT | REASON | Time between failures (h)
2022-02-14 08:10:00 | 2022-02-14 08:20:00 | 600 | Machine | Unplanned stop
2022-02-14 07:40:00 | 2022-02-14 07:55:00 | 900 | Machine | Unplanned stop
2022-02-14 06:00:00 | 2022-02-14 06:10:00 | 600 | Floor | Cleaning
2022-02-14 00:00:00 | 2022-02-14 06:00:00 | 21600 | NaN | Holiday
2022-02-13 15:00:00 | 2022-02-14 00:00:00 | 32400 | NaN | Holiday
2022-02-13 06:00:00 | 2022-02-13 15:00:00 | 32400 | NaN | Holiday
2022-02-13 00:00:00 | 2022-02-13 06:00:00 | 21600 | NaN | Holiday
2022-02-12 15:00:00 | 2022-02-13 00:00:00 | 32400 | NaN | Holiday
2022-02-12 06:00:00 | 2022-02-12 15:00:00 | 32400 | NaN | Holiday
2022-02-12 00:00:00 | 2022-02-12 06:00:00 | 21600 | NaN | Holiday
2022-02-11 15:00:00 | 2022-02-12 00:00:00 | 32400 | NaN | Holiday
2022-02-11 14:42:00 | 2022-02-11 15:00:00 | 1080 | Machine | Unplanned stop
2022-02-11 13:50:00 | 2022-02-11 14:20:00 | 1800 | NaN | Preparation
2022-02-11 12:20:00 | 2022-02-11 13:00:00 | 2400 | Floor | Cleaning
2022-02-11 10:20:00 | 2022-02-11 11:30:00 | 4200 | Machine | Unplanned stop
2022-02-11 06:00:00 | 2022-02-11 06:10:00 | 600 | Machine | Unplanned stop
2022-02-11 00:00:00 | 2022-02-11 06:00:00 | 21600 | Floor | Holiday
2022-02-10 08:00:00 | 2022-02-10 08:15:00 | 900 | NaN | Cleaning
2022-02-10 00:00:00 | 2022-02-10 06:00:00 | 21600 | NaN | Holiday
2022-02-09 14:00:00 | 2022-02-09 14:30:00 | 1800 | Line | Visit
2022-02-09 13:50:00 | 2022-02-09 13:58:00 | 480 | NaN | Other
2022-02-09 10:40:00 | 2022-02-09 11:00:00 | 1200 | Machine | Unplanned stop
Spreadsheet: 772529d1647346044-array-formula-in-place-of-vlookup-testsheet-2-
Sheet: Sheet1

ID | Wk1 | Wk2 |  | ID | Week
1 |  |  |  | 1 | Wk1
2 |  |  |  | 2 | Wk1
3 |  |  |  | 3 | Wk1
4 |  |  |  | 4 | Wk1
5 |  |  |  | 5 | Wk1
 |  |  |  | 1 | Wk2
 |  |  |  | 2 | Wk2
 |  |  |  | 3 | Wk2
 |  |  |  | 4 | Wk2
 |  |  |  | 5 | Wk2