tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 214906d1361184980-using-text-forumlas-accounts-test-sheet
Sheet: October

 |  | KEY: |  | CREDIT ACCOUNTS: |  |  |  |  |  |  | KEY:
 |  | Credit Account | ACC | TPS = |  | NET PURCHACED  TOTAL = |  |  |  |  | Credit Account | ACC |  | NET SALES TOTAL =
 |  | CASH | CASH | OTHER 1 = |  | VAT PAID OUT = |  |  |  |  | CASH | CASH |  | VAT RECEIVED =
 |  | CHEQUE | CHQ | OTHER 2 = |  |  |  |  |  |  | CHEQUE | CHQ |  | TOTAL AMOUNT OF JOBS =
 |  | CARD | CARD | OTHER 3 = |  |  |  |  |  |  | CARD | CARD
 | PURCHASE LEDGER | BANK CREDIT | BACS |  |  |  |  |  |  | SALES LEDGER | BANK CREDIT | BACS |  | MONTH NET PROFIT =
DATE | DESCRIPTION OF TRANSACTION | INVOICE NO or REF | OUTGOING ££ | VAT % | OUTGOING ££ | PAYMENT | CREDIT |  | DATE | DESCRIPTION OF TRANSACTION | INVOICE NO or REF | INCOME ££ | VAT % | INCOME ££ | PAYMENT
 |  |  | NET | PAID | GROSS | METHOD | ACCOUNT |  |  |  |  | NET |  | GROSS | METHOD
Spreadsheet: 808467d1670487489-application-of-vlookup-formula-with-specific-condition-excel-forum-8-12
Sheet: Sheet1

[NAME] | Created at | array table | values of array table | 2020-12-28 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-01 00:00:00
A | 2020-12-28 00:00:00 | D | 1
B | 2020-12-28 00:00:00 | B | 5
C | 2020-12-28 00:00:00 | C | 7
D | 2020-12-28 00:00:00 | A | 2
E | 2020-12-29 00:00:00 | B | 2
F | 2020-12-29 00:00:00 | J | 3
G | 2020-12-29 00:00:00 | I | 1
H | 2020-12-29 00:00:00 | A | 5
I | 2020-12-30 00:00:00 | H | 1
J | 2020-12-30 00:00:00 | D | 6
K | 2020-12-30 00:00:00 | B | 6
L | 2020-12-30 00:00:00 | C | 6
M | 2020-12-31 00:00:00 | N | 5
N | 2020-12-31 00:00:00 | M | 6
O | 2020-12-31 00:00:00 | F | 6
P | 2020-12-31 00:00:00 | A | 7
Spreadsheet: mary_fischer__25638__31U
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031U
COMPANY NAME   Limbach Mgmt Company
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
Cash surrender value of Life insurance policies |  | 193801 |  |  |  |  |  |  |  |  |  |  |  | -193801
Country club deposit |  | 15000 |  |  |  |  |  |  |  |  |  |  |  | -15000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 34064d1231179013-excel-2007-forcing-a-state-change-dvdjworkbook
Sheet: Quote Sheet

Qty |  |  |  | Item No. |  |  |  | Item Description |  |  |  |  |  |  |  |  | £ / Piece |  |  | £ / Total |  | Manual Override |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O / R |  | Act
80000 |  |  |  | 1230 | 03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plain Stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Battery Qty/Price
 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Print Code
Spreadsheet: 713033d1610534803-formula-to-find-exact-latest-grade-result-latest-grade-support
Sheet: Sheet1

Serial Number | Grade Average | year | latest Grade
Z10029668 | 2003.00000.180VSC00.00000.0000 | 2003
Z17477668 | 2007.00000.180VSC00.00000.0000 | 2007
Z04967668 | 2017.14330.1802T031.N1802.4942 | 2017
[NAME] |  | Update in WD Needed
ZZ036F668 | 2014.00000.180VSC00.00000.0000 | 2014
Z09273668 | 2005.00000.262VSC00.00000.0000 | 2005
[NAME] | 2008.00000.621SSC00.00000.0000 | 2008
ZZ02ZA668 | 2011.00000.180VSC00.00000.0000 | 2011
[NAME] |  | Update in WD Needed
[NAME] | 2009.00000.623SSC00.00000.0000 | 2009
ZZ0199668 | 2007.00000.180VSC00.00000.0000 | 2007
ZZ0199668 | 2016.00000.180VSC00.00000.0000 | 2016
ZZ0199668 |  | Update in WD Needed
ZZ0341668 | 2017.00000.640VSC00.00000.0000 | 2017
ZZ0341668 | 2010.00000.262VSC00.00000.0000 | 2010
Spreadsheet: 554f0739-59da-48af-abb5-0f226bb3bfa9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
264083 | 75017 | Mark | Phillips | IRL | 113 | 00:20:10 | 00:02:55 | 00:40:26 | 00:02:25 | 00:20:53 | 1 | 1:26:50
264083 | 75427 | [NAME] | [NAME] | IRL | 112 | 00:17:39 | 00:03:01 | 00:43:48 | 00:02:24 | 00:22:14 | 2 | 1:29:06
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  | -33275
2 |  |  |  |  |  | -32525
3 |  |  |  |  |  | -32436
4 |  |  |  |  |  | -8093
5
6 |  |  |  |  |  | -791
7
8
9
10
11 |  |  |  |  |  | -38245
12 |  |  |  |  |  | -30926
13 |  |  |  |  |  | -22893
14 |  |  |  |  |  | -31770
15 |  |  |  |  |  | -20252
16 |  |  |  |  |  | -21892
17 |  |  |  |  |  | -20839
18 |  |  |  |  |  | -29544
19 |  |  |  |  |  | -22158
20 |  |  |  |  |  | -15402
21 |  |  |  |  |  | -30336
22 |  |  |  |  |  | -28076
23 |  |  |  |  |  | -27998
24 |  |  |  |  |  | -28157
25 |  |  |  |  |  | -27306
26 |  |  |  |  |  | -9140
27 |  |  |  |  |  | -22101
28 |  |  |  |  |  | -3824
29 |  |  |  |  |  | -38277
30 |  |  |  |  |  | -37396
31 |  |  |  |  |  | -5579
index
2001-12-31 00:00:00 |  |  |  |  | 417969.39
2001-12-31 00:00:00
CBS Volume
 |  |  | 5124
Spreadsheet: 713640d1610856120-sum-row-until-other-row-is-certain-condition-sum-until-1-ans
Sheet: Blad1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ARRAY | Normal
 |  |  |  |  | wissel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | formula | formula
 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  | wissel |  |  |  | wissel
 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  |  | wissel
 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  | The sum of the last cell in the sheet until there is in the row above = wissel Change "wissel" change the som! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From last cell in sheet
Spreadsheet: 125868d1319304344-count-if-example
Sheet: June 2010

 | Date
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-113,147

 |  |  |  |  |  |  |  | 9-113   9-147
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 812446d1673162122-dynamic-reference-to-worksheet-with-index-and-aggregate-functions-dynamic-worksheet-reference-question-ans
Sheet: REPORT BY POTTER

 |  |  | Enter Month below | Enter Potter's Name Below
 |  |  | JANUARY | [NAME] |  |  | IFERROR(INDEX(JANUARY!B$1:B$186,AGGREGATE(15,6,ROW($D$1:$D$194)/(JANUARY!$B$1:$B$186='REPORT BY [NAME]))),"")
 |  |  |  |  |  | Sales this month |  |  |  |  |  |  |  |  |  | Validation list
 |  |  | Potter | [NAME] | Date Sold |  |  | This formula entered in the green cells works perfectly to draw info from the "January" tab based on input in the blue cell.  How do I modify it so that the output changes according to the month entered in the yellow cell D2?    THANK YOU!! |  |  |  |  |  |  |  | JANUARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | APRIL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JULY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AUGUST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEPTEMBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCTOBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOVEMBER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DECEMBER
 |  |  | [NAME] column  F for date and G for number.
 |  |  | Validation done for [NAME] for selection.
Spreadsheet: 819207d1677296360-check-and-advise-next-document-sequence-number-document-control-revision-number-test
Sheet: Sheet1

 | Checking for previous revision and prompt next revision no.
 | No. | Document No. | Revision No.
 | 1 | ABC-123 | A
 | 2 | DEF-456 | A
 | 3 | GHI-789 | A
 | 4 | GHI-789 | B
 | 5 | ABC-123 | B
 | 6 | ABC-123 | C
 | 7 | JKL-012 | <Check and Prompt next Sequence No.> | = A (Document JKL-012 does not exist in previous entries from 1 to 6, therefore revision number should start as A.)
 | 8 | ABC-123 | <Check and Prompt next Sequence No.> | = D (Document ABC-123 exists and the previous entry was revision C, so next should be D.)
 | 9 | DEF-456 | <Check and Prompt next Sequence No.> | = C (Document DEF-456 exists and the previous entry was revision B, so next should be C.)
 | 10 | GHI-789 | <Check and Prompt next Sequence No.> | = C (Document GHI-789 exists and the previous entry was revision B, so next should be C.)
 | 11 | XYZ-123 | <Check and Prompt next Sequence No.> | = A (Document XYZ-123 does not exist in previous entries from 1 to 6, therefore revision number should start as A.)
 | 12
 | 13
 | 14
 | 15
Spreadsheet: daren_farmer__5611__buydef
Sheet: Sheet1

BUYBACK & DEFICIENCY DEALS
 |  |  |  | Buyback | Type
Counterparty | Undertake | Sale | Swing | K # | of deal | Term | [NAME] | VM
AirProducts, Inc. | 414092 | 414025 | 414090 | 96023739 | Deficiency | 10/00-9/01 | 1418
BASF Corporation | 133000 | 120266 | 122310 | 96022419 | Buyback | 11/1/99-10/31/01 | 1437
Bayer Corporation | 455603 | 455565 |  | 96022013 | Buyback | November | 1550/8056 | Fred
Bayer Corporation | 504469 | 504383 |  | 96022013 | Buyback | December | 1550/8056 | Fred
Beaumont Methanol Limited Partnership | 451912 | 451899 | 451907 | 96019675 | Deficiency | November | 1428 | [NAME]
[NAME] | 139070 | 139066 | 139068 | 96018826 | Buyback | 1/1/00-12/31/00 | 8216 | Fred
Enron Methanol Co | 139058 | 139055 | 139057 | 96018827 | Buyback | 1/1/00-12/31/00 | 8291 | Fred
Equistar Chemicals LP | 246625 |  | 244614 | 96000240 | Buyback | 1/99-1/01 | 1384 | [NAME]
Equistar Chemicals LP | 246633 |  | 244612 | 96000240 | Buyback | 1/99-1/01 | 1553 | [NAME]
Equistar Chemicals LP | 246408 |  | 244610 | 96000240 | Buyback | 1/99-1/01 | 1373 | [NAME]
Equistar Chemicals LP | 246629 |  | 644603 | 96000240 | Buyback | 1/99-1/01 | 1552 | [NAME]
Equistar Chemicals LP | 259397 |  |  | 96000240 | Buyback | 1/99-1/01 | 1062 | [NAME]
Equistar Chemicals LP | 246408 |  | 244610 | 96000240 | Buyback | 6/00-1/01 | 1062 | [NAME]
Global Octanes Texas LP | 373580 | 276461 | 373590 | 96019673 | Deficiency | 9/00-8/01 | 1528 | Thu
Lyondell-Citgo | 147729 | 147092 |  | 96008792 | Buyback | 2/1/00-12/31/00 | 1063
Lyondell-Citgo | 147729 | 451952 |  | 96008792 | Buyback | November | 1063
Marathon-Ashland | 455698 | 454365 |  | 96019644 | Buyback | November | 1431
Marathon-Ashland |  | 454436 |  | 96019644 | Buyback | 12/00-11/01 | 1431
Mobil Oil Corp. | 451658 | 451679 | 413351 | 96001534 | Buyback | November | 1040
Petrofina Gas Pipeline | 455545 | 455500 |  | 96019331 | Buyback | 11/00-3/01 | 1484
Petrofina Gas Pipeline | 473226 | 455500 |  | 96019331 | Buyback | 12/00-3/01 | 1484
Rohm & Haas | 455683 | 454406 |  | 96019546 | Buyback | November | 1506 | Thu
Rohm & Haas | 506606 | 506590 |  | 96019546 | Buyback | December | 1506 | Thu
Temple-Inland Forest Products | N/A | 93218 | N/A | 96001360 |  | 7/99 - 1/01 | 1020
Union Carbide | 63576 | 15765 | 34825 | 96019676 | Deficiency | 2/1/99-12/31/01 | 1308 | [NAME]….ENA
Union Carbide | 63573 |  | 34832 | 96019676 | Deficiency | 1/1/00-12/31/01 | 1332 | Fred….ENA
Union Carbide |  | 452807 |  | 96019676 | Deficiency | November | 1332 | Fred….ENA
Union Carbide |  | 498238 |  | 96019676 | Deficiency | December | 1332 | Fred….ENA
Valero Marketing & Supply | 478227 | 454447 |  | 96023591 | Buyback | 11/00-4/01 | 1394
Valero Marketing & Supply | 478229 | 454452 |  | 96023591 | Buyback | 11/00-4/01 | 1233
Valero Marketing & Supply | 478230 | 454455 |  | 96023591 | Buyback | 11/00-4/01 | 8018
 |  |  |  |  |  |  |  |  | ENA
 |  |  |  |  |  |  |  |  | ENA
Spreadsheet: 00cbc685-0a22-436c-b5bb-8afbb9a59c42
Sheet: Sheet1

Courses offered in Madrid: Universidad [NAME]
Course Tilte | in Spanish | In English | Spanish credit | Last offered |  | Loyola Equivalent | Approval
HISTORY
Contemporary History of Spain | X |  |  |  | S 11 | [NAME] | Dr. [NAME]
Comparative Cultural Studies: Europe and the US |  | X | 5 | [NAME] |  | [NAME] | Dr. [NAME]
Current European History |  | X |  |  | S 11 | [NAME] | Dr. [NAME]
History of Spain (part I Fall; Part II Spring) | X |  |  | F 10 | F11/S 12 | [NAME] | Dr. [NAME]
SOCIOLOGY
Comparative Cultural Studies: Spain and other countries |  | X | 5 |  | S11 | SC*3 | Dr. [NAME] 10/6/11
POLITICAL SCIENCE
International issues from a Spanish perspective |  | x | 5 |  | S12 | PS*3/ML*3 | Dr. [NAME]/Dr. Beitter 9/11
Political Geography of Europe |  | X | 5 |  | S11 | PS*3/ML*3 | Dr. [NAME]/Dr. Beitter 9/11
Economia Politica Internacional | X |  |  |  | S12 | PS*3
[NAME] in the [NAME] of Madrid |  | X | 5 |  | S11 | ML*3 if comparative | Dr. [NAME]
Estudios Regionales III | X |  | 3 |  | S12 | PS*3
Political system and Politics in Spain |  | X | 5 |  | S12 | PS*3
SPANISH
Introduction to International Mediation | X |  | 3 |  | S11 | ML*3/SN*3 TBC | Dr. [NAME]
Intermediate Spanish in the Dept. of Modern Lang. | X |  | 4.5 |  | S12 | SN 100 | Dr. [NAME] 11/15/11
Enfoques econimocos para relaciones Internacionales | X |  | 7.5 |  | S12 | SN*3 TBC
Spreadsheet: 42402d1240984175-excel-enquiry-over-multiple-sheets-sample-1
Sheet: Wyoming

 |  |  |  |  |  | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Total |  | Operation | Project | Process | Category | Object | Component | Code
 | Data group 1
 |  | Data group 1 sub 1
 |  |  | Data line 1 |  |  | 124 | 165 | 66 | 147 | 502 |  | 15 | 14 | 11 | 11 | 10 | 11 | [PHONE]
 |  |  | Data line 2 |  |  | 15 | 101 | 113 | 3 | 232 |  | 15 | 14 | 11 | 11 | 11 | 12 | [PHONE]
 |  |  | Data line 3 |  |  | 63 | 43 | 151 | 122 | 379 |  | 15 | 14 | 11 | 11 | 10 | 12 | [PHONE]
 |  | Data group 1 sub 2 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 138 | 18 | 93 | 50 | 299 |  | 15 | 14 | 12 | 11 | 11 | 12 | [PHONE]
 |  |  | Data line 2 |  |  | 26 | 11 | 60 | 132 | 229 |  | 15 | 14 | 12 | 11 | 13 | 14 | [PHONE]
 |  |  | Data line 3 |  |  | 67 | 131 | 29 | 51 | 278 |  | 15 | 14 | 12 | 13 | 15 | 16 | [PHONE]
 | Data group 2 |  |  |  |  |  |  |  |  | 0
 |  | Data group 2 sub 1 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 8 | 90 | 83 | 59 | 240 |  | 15 | 14 | 11 | 12 | 11 | 12 | [PHONE]
 |  |  | Data line 2 |  |  | 140 | 38 | 89 | 6 | 273 |  | 15 | 14 | 12 | 12 | 13 | 14 | [PHONE]
 |  |  | Data line 3 |  |  | 161 | 88 | 36 | 105 | 390 |  | 15 | 14 | 13 | 12 | 15 | 13 | [PHONE]
 |  | Data group 2 sub 2 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 96 | 79 | 69 | 39 | 283 |  | 15 | 14 | 15 | 11 | 13 | 14 | [PHONE]
 |  |  | Data line 2 |  |  | 16 | 104 | 48 | 114 | 282 |  | 15 | 14 | 16 | 12 | 15 | 16 | [PHONE]
 |  |  | Data line 3 |  |  | 25 | 111 | 75 | 44 | 255 |  | 15 | 14 | 16 | 13 | 11 | 12 | [PHONE]
 | Data group 3 |  |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 108 | 116 | 98 | 143 | 465 |  | 15 | 13 | 12 | 13 | 15 | 16 | [PHONE]
 |  |  | Data line 2 |  |  | 30 | 82 | 102 | 156 | 370 |  | 15 | 13 | 12 | 12 | 11 | 12 | [PHONE]
 |  |  | Data line 3 |  |  | 24 | 145 | 123 | 72 | 364 |  | 15 | 13 | 12 | 11 | 13 | 14 | [PHONE]
 | Data group 4 |  |  |  |  |  |  |  |  | 0
 |  | Data group 4 sub 1 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 5 | 129 | 135 | 107 | 376 |  | 15 | 14 | 13 | 12 | 13 | 14 | [PHONE]
 |  |  | Data line 2 |  |  | 40 | 120 | 76 | 45 | 281 |  | 15 | 14 | 13 | 12 | 15 | 16 | [PHONE]
 |  |  | Data line 3 |  |  | 57 | 112 | 150 | 118 | 437 |  | 15 | 14 | 13 | 13 | 11 | 12 | [PHONE]
 |  |  | Overhead 4 |  |  | 134 | 126 | 103 | 149 | 512 |  | 15 | 14 | 13 | 11 | 13 | 14 | [PHONE]
 |  | Data group 4 sub 2 |  |  |  |  |  |  |  | 0
 |  |  | Data line 1 |  |  | 35 | 49 | 61 | 87 | 232 |  | 15 | 15 | 13 | 14 | 11 | 12 | [PHONE]
 |  |  | Data line 2 |  |  | 97 | 34 | 109 | 20 | 260 |  | 15 | 15 | 13 | 16 | 13 | 14 | [PHONE]
 |  |  | Data line 3 |  |  | 99 | 28 | 164 | 33 | 324 |  | 15 | 15 | 13 | 16 | 15 | 16 | [PHONE]
 |  |  | Data line 4 |  |  | 41 | 148 | 117 | 4 | 310 |  | 15 | 15 | 13 | 11 | 11 | 12 | [PHONE]
 |  |  | Data line 5 |  |  | 100 | 14 | 136 | 92 | 342 |  | 15 | 15 | 13 | 12 | 13 | 14 | [PHONE]
 |  |  | Data line 6 |  |  | 141 | 62 | 22 | 46 | 271 |  | 15 | 15 | 13 | 15 | 15 | 14 | [PHONE]
Spreadsheet: 848230d1698997718-formula-to-determine-if-a-text-ar-to-be-added-sample2
Sheet: Sheet1

 |  |  | S/No | Date | CAR Number | Expected Result | [NAME] | Changes using Table 2 |  | S/No | Imp Date | CAR Number1 |  | Imp Date | CAR Number1 | CAR Number2
 |  |  | 1 | 2023-12-12 00:00:00 | 7 | 07 AR |  |  |  | 1 | 2023-11-03 00:00:00 | 9 |  | 2023-11-03 00:00:00 | 9 | T9
 |  |  | 2 | 2023-10-02 00:00:00 | T7 | 07 |  |  |  | 2 | 2023-11-03 00:00:00 | T9 |  | 2023-11-03 00:00:00 | 7 | T7
 |  |  | 3 | 2023-10-15 00:00:00 | 7 | 07 |  |  |  | 3 | 2023-11-03 00:00:00 | 7 |  | 2023-12-12 00:00:00 | 10 | T10
 |  |  | 4 | 2023-11-03 00:00:00 | 7 | 07 AR |  |  |  | 4 | 2023-11-03 00:00:00 | T7 |  | 2023-12-10 00:00:00 | 23 | T23
 |  |  | 5 | 2023-11-03 00:00:00 | T7 | 07 AR |  |  |  | 5 | 2023-12-12 00:00:00 | 10
 |  |  | 6 | 2023-10-07 00:00:00 | 9 | 09 |  |  |  | 6 | 2023-12-12 00:00:00 | T10
 |  |  | 7 | 2023-10-04 00:00:00 | T9 | 09 |  |  |  | 7 | 2023-12-10 00:00:00 | 23
 |  |  | 8 | 2023-11-05 00:00:00 | T10 | 10 |  |  |  | 8 | 2023-12-10 00:00:00 | T23
 |  |  | 9 | 2023-12-01 00:00:00 | T7 | 07 AR
 |  |  | 10 | 2023-12-12 00:00:00 | 9 | 09 AR
 |  |  | 11 | 2023-11-03 00:00:00 | 23 | 23
 |  |  | 12 | 2024-01-01 00:00:00 | 23 | 23 AR
 |  |  | 13 | 2023-12-13 00:00:00 | 10 | 10 AR
 |  |  | 14 | 2023-12-14 00:00:00 | T10 | 10 AR
 |  |  | 15 | 2023-11-03 00:00:00 | T10 | 10
 |  |  | 16 | 2023-12-04 00:00:00 | 5 | 05
Spreadsheet: 734954d1622620829-combine-several-cells-in-one-cell-with-a-specified-condition-data
Sheet: Sheet1

Data |  |  |  | Expected Result
Code | Name | Sale |  | Code | Name | Sale
1 | A | 100 |  | 1 | A B C | 100 200 300
1 | B | 200 |  | 2 | D E | 400 500
1 | C | 300 |  | 3 | F G H I | 600 700 800 900
2 | D | 400
2 | E | 500
3 | F | 600 |  |  |  | Please without VBA & Helper coloumn
3 | G | 700
3 | H | 800
3 | I | 900
Spreadsheet: 227926d1365889853-fun-help-with-projecting-mlb-season-final-standing-etc-braves-2013
Sheet: Sheet1

 |  | games played | won | lost | percentage | on pace for
 |  |  | 1 | 0
 |  |  | 2 | 0
 |  |  | 2 | 1
 |  |  | 3 | 1
 |  |  | 4 | 1
 |  |  | 5 | 1
 |  |  | 6 | 1
 |  |  | 7 | 1
 |  |  | 8 | 1
 |  |  | 9 | 1
 |  |  | 10 | 1
Spreadsheet: 741510d1627073630-lookup-match-with-multiple-criteria-help-car-repair-tracking
Sheet: Data

Name | Car Model | 2021-05-03 00:00:00 | 2021-05-10 00:00:00 | 2021-05-17 00:00:00 | 2021-05-24 00:00:00 | 2021-05-31 00:00:00 | 2021-06-07 00:00:00 | 2021-06-14 00:00:00 | 2021-06-21 00:00:00 | 2021-06-28 00:00:00
Al | Model 3 | g | y | r | r
Al | Model S | g | g | g | g
Al | Yugo | y | r | r | r
[NAME] | Beetle | y | y | r | r | g | g | g
[NAME] | Bus | g | g | g | g | g | g | r
[NAME] | Golf | g | g | g | g | g | y | r
[NAME] | Mustang | g | g | y | y | y | y | y | r
[NAME] | F150 | g | g | g | g | g | g | g | g
[NAME] | Fusion | g | g | g | g | g | g | r | r
[NAME] | Vantage | r | r | r | r | g | g | g | g
[NAME] | DB11 | g | g | g | g | g | g | g | g
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 8b

Product1 | USD | EUR3 | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 143 | 5 | 17 | 19 | 3 | 5 | 1 | 193
Cap/Floor | 192 | 14 | 1 | 1 | 0 | 1 | 8 | 217
Debt Option | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Exotic | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fixed-Fixed | 1 | 8 | 0 | 0 | 0 | 0 | 2 | 11
Fixed-Float | 18017 | 3275 | 3305 | 573 | 588 | 946 | 2235 | 28938
FRA | 201 | 915 | 13 | 0 | 61 | 0 | 84 | 1274
Inflation | 121 | 29 | 44 | 0 | 3 | 0 | 0 | 197
OIS | 72 | 114 | 11 | 0 | 32 | 16 | 182 | 427
Swaption | 643 | 209 | 68 | 59 | 21 | 2 | 71 | 1073
TOTAL | 19390 | 4569 | 3459 | 652 | 708 | 970 | 2583 | 32330
Spreadsheet: 726585d1617303768-sumifs-issue-template-etaf
Sheet: AUG

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-08-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 0
Spreadsheet: 137139d1326973930-updating-another-spreadsheet-based-on-certain-information-and-certain-conditions-timetable
Sheet: Sheet1

WEEK 1 | MONDAY 23 APR | TUESDAY 24 APR | WEDNESDAY 25 APR | THURSDAY 26 APR | FRIDAY 27 APR
 | 10.00-11.00 Introduction to the Business | 10.00-11.30 Volunteering | 10.00-12.30 Using the Phones | 10.00-12.30 Introduction to the Department 1 | 10.00-12.30 Work Shadowing
10AM - 12.30PM
 | [NAME] | [NAME] | [NAME] | Heads of Department
 | 11.00-11.45 Health & Safety 1 | 11.45-12.30 Health & Safety 3
 | [NAME] | [NAME]
 | 12.15-12.30 Risk Assessment 1
 | [NAME]
LUNCH 12.30 - 1.30
 | 1.30-1.45 Introduction to IT | 1.30-4.00 Using the Services | 1.30-4.00 Using the Database | 1.30-4.00 Introduction to the Department 2 | 1.30-4.00 Work Shadowing
1.30PM - 4.00PM
 | [NAME] | [NAME] | [NAME] | Heads of Department
 | 1.45-2.30 Health & Safety 2
 | [NAME]
 | 2.45-4.00 Risk Assessment 2
 | [NAME]