tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 760960d1640570244-formula-to-textjoin-if-column-contains-the-same-values-excel-problem
Sheet: Sheet1

PROBLEM |  |  |  |  | DESIRED OUTPUT |  |  |  |  |  | train | location
Train | Count FTS | Location |  |  | Train | Locations |  |  |  |  | [NAME]
MAN1 | 2 | DEIGHTON |  |  | MAN1 | DEIGHTON, MIRFIELD, MORLEY, BATLEY, DEWSBURY, COTINGLEY, RAVENTHPE |  |  |  |  | CLE4
MAN1 | 2 | MIRFIELD |  |  | [NAME] | MANCR VIC, MANCROXRD |  |  |  |  | YRK4
MAN1 | 2 | MORLEY |  |  | CLE4 | MANCROXRD, MANCR VIC
MAN1 | 2 | BATLEY |  |  | YRK4 | DARLINGTN, CHESTERLS, NOALLERTN, DURHAM
MAN1 | 2 | DEWSBURY
MAN1 | 2 | COTINGLEY
MAN1 | 2 | RAVENTHPE
[NAME] | 2 | MANCR VIC
[NAME] | 2 | MANCROXRD
CLE4 | 2 | MANCROXRD
CLE4 | 2 | MANCR VIC
YRK4 | 2 | DARLINGTN
YRK4 | 2 | CHESTERLS
YRK4 | 2 | NOALLERTN
YRK4 | 2 | DURHAM
SHF6 | 0 | LEEDS WJ
SHF6 | 0 | MIRFLDEJN
SHF6 | 0 | THORNH JN
SHF6 | 0 | WHITEHLJN
SHF6 | 0 | BRADLEY J
SHF6 | 0 | LEEDS
SHF6 | 0 | HUDDFIELD
 |  |  |  | I really need help on a formula please.
 |  |  |  | In the attached sheet, columns A-C show data we receive about train services failing to stop at certain stations.
 |  |  |  | The list represents these, where:
 |  |  |  | If Column B is > 0, then a train has failed to stop at the station named in Column C.
 |  |  |  | Each station where a service has failed to stop is recorded on separate rows.
 |  |  |  | If the value in Column B=0 for any of these stations, these are not stations where the train has failed to stop, so can be ignored.
 |  |  |  | As an example, service MAN1 failed to stop at DEIGHTON, MIRFIELD, MORLEY, BATLEY, DEWSBURY, COTINGLEY, RAVENTHPE, and CLE4 failed to stop at MANCROXRD, MANCR VIC. As the listed stations for SHF6 have a value of 0 in Column B, these can be ignored.
 |  |  |  | Basically, I need two formulas that:
 |  |  |  | 1) List each train service individually
 |  |  |  | 2) TEXTJOIN all the stations that that train service has failed to stop at, crucially providing that the value in Column B for that station is >0.
 |  |  |  | The desired output is shown in Columns F-G.
 |  |  |  | Any help greatly appreciated (but please, no macros).
Spreadsheet: 181813d1348159756-creating-a-list-from-particular-conditional-formatted-cells-cond_format
Sheet: Sheet1

6
10
12
18
23
29
 |  |  |  | yesterday's list | two days prior
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 7b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 1158481 | 9331747 | 2264088 | 2049088 | 354516 | 145106 | 247725 | 15550751
Fixed-Float | 77157350 | 85537450 | 15584218 | 19346686 | 5008940 | 4634221 | 12907492 | 220176357
FRA | 26083635 | 17296401 | 8534240 | 25254 | 293180 | 57394 | 3787041 | 56077145
OIS | 20320948 | 6279712 | 5876092 | 153578 | 1424001 | 689448 | 866357 | 35610136
Swaption | 8638182 | 7752168 | 1306535 | 2610246 | 343831 | 16046 | 286336 | 20953344
OTHER* | 6261913 | 10719368 | 1126808 | 320579 | 185446 | 37088 | 255994 | 18907196
TOTAL | 139620509 | 136916846 | 34691981 | 24505431 | 7609914 | 5579303 | 18350945 | 367274929
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -132997 | -79207 | -39109 | -92874
2 | -112568 | -53005 | -40001 | -99950
3 | -144086 | -117734 | -40000 | -65000
4 | -151514 | -150002 | -55771 | -56162
5 | -151656 | -150001 | -55077 | -56162
6 | -153786 | -150001 | -52179 | -56162
7 | -138012 | -58418 | -1800 | -79718
8 | -144923 | -82115 | -48170 | -109950
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-07-31 00:00:00 |  |  | 460835.37
 |  |  |  | 2001-08-08 00:00:00
 | CBS Volume
 |  |  |  | 111236
Spreadsheet: 881141d1729073918-generating-number-sequence-based-on-column-sequence
Sheet: Sheet1

 | A | B | C | D | E |  | SEQUENCE
 | 2 |  | 1
 | 1
 |  |  | 1
 | 4
 |  |  |  | 3 | 2
 |  |  |  |  | 3
Spreadsheet: 827495d1682743247-conditionally-skip-or-continue-auto-numbering-numbering-sheet
Sheet: Test

Client | Study Type | Doc # | Rev. | Lot # | Record # | Description | Comments | Date Initiated | Status | Date Closed/ Voided
Client 7 | Study C | 1558 | 0 | lot 2 |  |  |  | 2021-08-29 00:00:00 |  | 2021-08-31 00:00:00
Client 7 | Study C | 1558 | 1 | lot 3 |  |  |  | 2021-04-30 00:00:00 |  | 2021-12-16 00:00:00
Client 7 | Study C | 1558 | 1 | lot 3 |  |  |  | 2021-04-30 00:00:00 |  | 2021-12-16 00:00:00
Client 2 | Study C | 13032 | 2 | lot 4 |  | expected outcome: 01 |  | 2021-12-10 00:00:00 |  | 2021-12-17 00:00:00
Client 2 | Study C | 13032 | 2 | lot 4 |  | expected outcome: 02 |  | 2021-05-04 00:00:00 |  | 2021-11-22 00:00:00
Client 2 | Study C | 13032 | 2 | lot 4 |  | expected outcome: 03 |  | 2022-02-18 00:00:00 |  | 2022-02-20 00:00:00
Client 2 | Study C | 13032 | 2 | lot 5 |  | expected outcome: blank | void skip number | 2022-02-18 00:00:00 |  | 2022-02-20 00:00:00
Client 2 | Study C | 13032 | 2 | lot 5 |  | expected outcome: 04 | void continue number | 2022-02-19 00:00:00 |  | 2022-02-20 00:00:00
Client 2 | Study C | 13032 | 2 | lot 5 |  | expected outcome: 05 |  | 2022-02-20 00:00:00 |  | 2022-03-05 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2022-02-25 00:00:00 |  | 2022-03-02 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-08-19 00:00:00 |  | 2022-03-08 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-08-18 00:00:00 |  | 2022-03-03 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-08-18 00:00:00 |  | 2022-04-01 00:00:00
Client 3 | Study A1 | 5080 | 3 | lot 100 |  |  |  | 2021-11-10 00:00:00 |  | 2022-03-02 00:00:00
 |  |  |  |  |  |  | /
Spreadsheet: 1b07022f-abef-4a72-a50d-eb37505025d7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 42. OPERATING LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), Original (Number: $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413806K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413807L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413808R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413809T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413810A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413811C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413812F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413813J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413814K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413815L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413816R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 690620d1597201076-countifs-how-to-segregate-from-total-into-a-month-data
Sheet: Sheet1

Contract |  |  |  | Monthly Recurring Revenue (MRR)
Start Date | End Date | Length(mth) | Total | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Total
2018-05-15 00:00:00 | 2020-02-17 00:00:00 |  | 3000
2018-11-14 00:00:00 | 2021-01-01 00:00:00 |  | 2000
2018-02-20 00:00:00 | 2021-01-01 00:00:00 |  | 4000
2018-02-23 00:00:00 | 2019-05-23 00:00:00 |  | 60000
2018-03-30 00:00:00 | 2025-01-01 00:00:00 |  | 2000
2018-04-02 00:00:00 | 2020-08-13 00:00:00 |  | 30000
2018-04-10 00:00:00 | 2019-10-10 00:00:00 |  | 70000
Spreadsheet: 273567d1382757243-help-without-a-pivot-table-formula_m2som
Sheet: Sheet1

Date | CD Code | Describtion
2013-10-23 00:00:00 | 2-08-21-10-04701 | O-RING, 4-1/2" [NAME], SIZE: 56.74MM X 3.53MM
2013-10-23 00:00:00 | 2-08-21-52-56790 | CIRCLIP, INTERNAL T/S MX5456 HAMMER
2013-10-24 00:00:00 | 2-08-21-03-15093 | 10MM SPHERICAL S/DIAROC HD
2013-10-24 00:00:00 | 2-08-21-03-15092 | 12MM SPHERICAL S/DIAROC HD
2013-10-24 00:00:00 | 2-08-21-35-07749 | CUP, GRINDING 16MM SPHERICAL S/DIAROC HD
2013-10-24 00:00:00 | 2-07-22-38-07147 | AMC GROUND-STABILISER 25 LTR
2013-10-24 00:00:00 | 2-07-22-38-07147 | AMC GROUND-STABILISER 25 LTR
2013-10-24 00:00:00 | 2-08-22-39-02707 | ROCK DRILL / HAMMER OIL 320 - 209LTR DRUM
2013-10-24 00:00:00 | 2-08-22-39-02707 | ROCK DRILL / HAMMER OIL 320 - 209LTR DRUM
2013-10-25 00:00:00 | 2-08-21-03-34311 | EXHAUST FOOT VALVE T/S DRILL BIT
2013-10-25 00:00:00 | 2-08-21-52-58952 | FOOT VALVE, QL60
2013-10-25 00:00:00 | 2-08-21-04-12598 | SAMPLE TUBE, SMALL BORE T/S MINCON MX5456 HAMMER
2013-10-25 00:00:00 | 2-08-22-39-02707 | ROCK DRILL / HAMMER OIL 320 - 209LTR DRUM
2013-10-25 00:00:00 | 2-08-21-04-12598 | SAMPLE TUBE, SMALL BORE T/S MINCON MX5456 HAMMER
2013-10-25 00:00:00 | 2-07-22-38-02337 | AMC SUPER-FOAM 25LTR CUBE
2013-10-25 00:00:00 | 2-08-21-37-58510 | TUBE, INNER T/S SUB, DIG-OUT 115ARDX
Date | 2013-10-25 00:00:00
Date | CD Code | Describtion
Spreadsheet: 215550d1361405974-if-at-least-one-number-fails-the-rest-of-the-field-must-be-failed-book1-27-
Sheet: Sheet1

 | SO number | SO/LI number | Revision
 | 789 | 10 | 1
 | 789 | 20 | 0
 | 789 | 30 | 0
 | 564 | 10 | 0
 | 564 | 20 | 0
 | 564 | 30 | 0
 | 564 | 40 | 0
 | 321 | 10 | 1
 | 321 | 20 | 0
 | 321 | 30 | 0
Expected outcome |  |  |  |  |  | [NAME]
no of passed items (unique so numbers) |  |  | 1 |  |  |  | <---array formula
no of failed items(unique so numbers) |  |  | 2 |  |  |  | <---array formula
Total no of unique items |  |  | 3 |  |  |  | <---regular formula
Spreadsheet: 154365d1336401234-merging-spreadsheets-based-on-variable-index-sampledatahelpwithmerge
Sheet: DATA TO MERGE

CASE ID | VAR E | VAR F
 | [NAME] | median income
1 | 22207 | 55000
2 | 22212 | 53000
3 | 22213 | 51000
4 | 22246 | 49000
5 | 22208 | 47000
6 | 22222 | 45000
7 | 22200 | 43000
8 | 22201 | 41000
9 | 22202 | 39000
19 | 22204 | 37000
Spreadsheet: 89690d1289443483-macro-to-copy-and-paste-from-sheet-2-to-3-based-on-a-checkbox-selection-in-sheet-1-sample-1_b
Sheet: Sheet3

Yellow Cards per Gameday pro Spieltag
 | FCB
1. Spieltag | 0
2. Spieltag | 4
3. Spieltag | 0
4. Spieltag | 0
5. Spieltag | 0
6. Spieltag | 3
7. Spieltag | 0
8. Spieltag | 5
9. Spieltag | 0
10. Spieltag | 0
11. Spieltag | 2
12. Spieltag | 0
13. Spieltag | 0
14. Spieltag | 0
15. Spieltag | 0
16. Spieltag | 0
17. Spieltag | 0
Spreadsheet: jeff_dasovich__14091__Scores99
Sheet: Total

 |  | Prior Rank | New Rank | Total | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 | Wk 7 | Wk 8 | Wk 9 | Wk 10 | Wk 11 | Wk 12 | Wk 13 | Wk 14 | Wk 15 | Wk 16 | Wk 17
 | [NAME]* | T  2 | 1 |  | 74 | 84 | 93
 | Helmet* | 1 | 2 |  | 68 | 93 | 82
 | JAM* | T14 | T 3 |  | 55 | 86 | 95
 | Prentice* | T11 | T 3 |  | 58 | 86 | 92
 | Narvco* | T  5 | 5 |  | 55 | 99 | 81
 | [NAME]* | 10 | 6 |  | 63 | 82 | 88
 | Barrie* | T  7 | T 7 |  | 63 | 95 | 73
 | Mickey* | T  2 | T 7 |  | 57 | 93 | 81
 | [NAME]* | 4 | 9 |  | 59 | 96 | 74
 | [NAME]* | T  7 | 10 |  | 58 | 93 | 76
 | [NAME]* | T  5 | 11 |  | 73 | 81 | 72
 | Eldon* | T14 | 12 |  | 65 | 76 | 84
 | [NAME]* | 9 | 13 |  | 62 | 87 | 75
 | Carlton* | T11 | 14 |  | 69 | 75 | 77
 | WAM | 13 | 15 |  | 66 | 77 | 75
 | Mike&Lisa* | 16 | 16 |  | 55 | 82 | 80
 | Cameron* | 17 | 17 |  | 64 | 71 | 78
 | Cary* | 18 | 18 |  | 52 | 77 | 80
 | Growney* | 19 | 19 |  | 35 | 89 | 84
 | Dennis* | 20 | 20 |  | 35 | 88 | 81
Spreadsheet: 680553d1591088085-formula-management-migration-progress-formula-excel_formula_progress
Sheet: Sheet1

 | AS-IS |  |  |  |  |  | TO BE
Chassis | HOST_BY | App | Status_App | Progress |  | Chassis | Status_App | Progress
BL13 | ABC101 | APP1 | [NAME] |  |  | BL13 | [NAME]
BL22 | ABC201 | APP1 | PoC2 |  |  | BL22 | [NAME]
BL13 | ABC101 | APP2 | PoC |  |  | ABC101 | [NAME]
BL22 | ABC104 | APP2 | [NAME] |  |  | ABC103 | [NAME] | 1
BL22 | ABC201 | APP2 | PoC2 |  |  | ABC104 | [NAME] | 0.5
BL13 | ABC101 | APP3 | [NAME] |  |  | ABC201 | [NAME] | 0
BL22 | ABC104 | APP3 | PoC |  |  | ABC203 | [NAME] | 1
BL13 | ABC101 | [NAME] | [NAME] |  |  | APP1 | [NAME] | 0.5
BL13 | ABC103 | APP5 | [NAME] |  |  | APP2 | [NAME] | 0.33
BL13 | ABC103 | APP6 | [NAME] |  |  | APP3 | [NAME] | 0.5
BL13 | ABC103 | APP7 | [NAME] |  |  | [NAME] | [NAME] | 1
BL13-BL22 | ABC103*-203 | APP8 | [NAME] |  |  | APP5 | [NAME] | 1
BL13-BL22 | ABC103-203* | APP8 | [NAME] |  |  | APP6 | [NAME] | 1
 |  |  |  |  |  | APP7 | [NAME] | 1
 |  |  |  |  |  | APP8 | [NAME] | 1
Spreadsheet: 44726d1243496825-excel-2007-turn-sheet-of-values-into-a-percentage-of-a-column-of-values-dummy
Sheet: Sheet2

 | Total Files | Mercedes
1981
1982
1984 | 15 | 0/15
1985 | 6 | 0/6
1986 | 41 | 0.07317073170731707
1987 | 115 | 5/115
1988 | 260 | 2/260
1989 | 112 | 2/112
1990 | 334 | 4/334
1991 | 493 | 3/493
1992 | 362 | 4/362
Spreadsheet: 713972d1611045716-lookup-for-4-criteria-and-retrieve-the-nearest-match-book1
Sheet: Sheet1

 |  |  |  |  | L 5 times more important than H, which is 5 times more important than W
 |  |  |  |  | L | H | W
 |  |  |  |  | 1 | 5 | 25
 | L | H | W |  | Examples | L | H | W | Best Option
Option 1 | 0 | 1200 | 2300 |  | 1
Option 2 | 0 | 1500 | 2300 |  | 2
Option 3 | 0 | 1800 | 2300 |  | 3
Option 4 | 30 | 1200 | 2300 |  | 4
Option 5 | 30 | 1500 | 2300 |  | 5
Option 6 | 30 | 1500 | 2300 |  | 6
Option 7 | 30 | 1800 | 2300 |  | 7
Option 8 | 30 | 1800 | 2300 |  | 8
Option 9 | 30 | 2100 | 2300 |  | 9
Option 10 | 30 | 2100 | 2300 |  | 10
Option 11 | 30 | 2400 | 2300 |  | 11
Option 12 | 30 | 2400 | 2300 |  | 12
Option 13 | 60 | 900 | 2300 |  | 13
Option 14 | 60 | 1200 | 2300 |  | 14
Option 15 | 60 | 1200 | 2300 |  | 15
Option 16 | 60 | 1400 | 2300
Option 17 | 60 | 1500 | 2300
Option 18 | 60 | 1500 | 2300
Option 19 | 60 | 1600 | 2300
Option 20 | 60 | 1600 | 2300
Option 21 | 60 | 1700 | 2300
Option 22 | 60 | 1800 | 2300
Option 23 | 60 | 1800 | 2300
Option 24 | 60 | 2100 | 2300
Option 25 | 60 | 2100 | 2300
Option 26 | 60 | 2400 | 2300
Option 27 | 60 | 2400 | 2300
Option 28 | 120 | 900 | 2300
Option 29 | 120 | 900 | 2300
Option 30 | 120 | 1200 | 2300
Option 31 | 120 | 1200 | 2300
Option 32 | 120 | 1500 | 2300
Option 33 | 120 | 1500 | 2300
Option 34 | 120 | 1800 | 2300
Option 35 | 120 | 1800 | 2300
Option 36 | 120 | 2100 | 2300
Option 37 | 120 | 2100 | 2300
Option 38 | 120 | 2400 | 2300
Option 39 | 120 | 2400 | 2300
Spreadsheet: 882769d1731234537-attendance-formula-attendance-formula
Sheet: Sheet1

09:46:00
09:00:00
09:14:00
09:15:00
09:16:00
09:20:00
Spreadsheet: 84351d1284398438-360-review-results-formatting-copy-of-work
Sheet: Sheet2

Answers for Problem 1 |  | 1
Manager | Position | Always | Never | Normally | Rarely | [NAME] | Grand Total
[NAME] | Employee |  |  |  | 1 |  | 1
 | Manager |  |  |  |  | 1 | 1
 | Peer | 1 |  |  |  |  | 1
[NAME] |  | 1 |  |  | 1 | 1 | 3
[NAME] | Employee |  | 1 |  |  |  | 1
 | Manager |  |  | 1 |  |  | 1
 | Peer |  | 1 |  |  |  | 1
[NAME] |  |  | 2 | 1 |  |  | 3
[NAME] | Employee |  | 1 |  |  |  | 1
 | Manager | 1 |  |  |  |  | 1
 | Peer |  |  | 1 |  |  | 1
[NAME] |  | 1 | 1 | 1 |  |  | 3
[NAME] | Manager |  |  |  | 1 |  | 1
 | Peer | 1 |  | 1 |  |  | 2
[NAME] |  | 1 |  | 1 | 1 |  | 3
Grand Total |  | 3 | 3 | 3 | 2 | 1 | 12
Spreadsheet: 600752d1543938842-if-nested-formula-with-match-criteria-match-formula
Sheet: Sheet1 (2)

Product Line | Discount % (calc.) | Sum of Quantity | Sum of Total List Price (converted) | Sum of Total Booking (converted) | Sum of Total Cost | Net Revenue | Calculated Margin % | Standard Partner Target Margin | Matching
Synoptix | 0 | 1 | 19400 | 19400 | 7760 |  |  | 0.6
Spreadsheet: 167802d1342106506-count-non-blank-cells-in-a-column-test
Sheet: Sheet7

Test
533713
274445
239720
198829
492390
875176
729277
736238
940590
459269
818368
704161
838671
224881
716041
936325
352601
628816
113755
697501
722584
327175
847519
255564
125815
698933
913620
267570
735159
562536
906522
404678
252134
890336
132561
165103
788970
309094
795748
796555
837229
269962
862860
818278
236843
582699
854959
141961
769835
823724
561189
614320
400605
669188
181900
109191
Spreadsheet: 57d53a04-c744-4352-9ccc-0918337a168b
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38788607 | 2013-12-01 18:18:02 | AXIS | 0 | 7 | 10 | 249959 | NAPOLEON71 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 873647d1720150129-adding-a-border-to-a-dynamic-range-of-cells-dv1651st-and-border-to-dynamic-range-of-cells
Sheet: Sheet1

 |  |  | 2 | 3 | 4 |  |  | 2 | 3 | 4
 |  |  | 3 | 5 | 7 |  |  | 3 | 5 | 7
 |  |  | 4 | 7 | 10 |  |  | 4 | 7 | 10
 |  |  | 5 | 9 | 13 |  |  | 5 | 9 | 13
 |  |  | 6 | 11 | 16 |  |  | 6 | 11 | 16
 |  |  | 7 | 13 | 19 |  |  | 7 | 13 | 19
 |  |  | 8 | 15 | 22 |  |  | 8 | 15 | 22
 |  |  | 9 | 17 | 25 |  |  | 9 | 17 | 25
 |  |  | 10 | 19 | 28 |  |  | 10 | 19 | 28
 |  |  | 11 | 21 | 31 |  |  | 11 | 21 | 31
 |  |  | 12 | 23 | 34 |  |  | 12 | 23 | 34 |  | row count | 15
 |  |  | 13 | 25 | 37 |  |  | 13 | 25 | 37
 |  |  | 14 | 27 | 40 |  |  | 14 | 27 | 40
 |  |  | 15 | 29 | 43 |  |  | 15 | 29 | 43
Spreadsheet: 7b0bd934-3b68-48a7-9f03-bca595f5db77
Sheet: Sheet1

2009-09-24 00:00:00 | Unnamed: 1
CROADS-CP v2.52
Created by [NAME] and [NAME]
Sustainability Institute
http://www.climateinteractive.org/simulations/C-ROADS
Scenarios
BAU | [NAME] emissions and other well mixed GHG emissions follow A1FI; deforestation continues
Kyoto | Projections based on Kyoto Protocol commitments, i.e., percent reduction of 1990 levels between 2008 and 2012 (-8% for EU, 0% for Russia, -6% for Canada and for Japan, and -8% for Australia), which cap at 2012 levels; BAU emissions if no commitment
Kyoto v2 | Projections based on Kyoto Protocol commitments, i.e., percent reduction of 1990 levels between 2008 and 2012 (-8% for EU, 0% for Russia, -6% for Canada and for Japan, and -8% for Australia), and then resume to BAU growth rates; BAU emissions if no commitment
Current Proposals March 2009 | Outlined in "Proposals - Mar09" worksheet
Current Proposals - Conservative | Outlined in "Conservative Sep09" worksheet
Current Proposals - Optimistic | Outlined in "Optimistic Sep09" worksheet
2 Degree Pathway | All countries reduce CO2 emissions to 50% below 2005 levels by 2050; deforestation falls to 50% below current levels by 2050; afforestation index equals 0.5; other well mixed GHGs (N2O, CH4, PFCs, SF6, and HFCs) follow comparable change as that for FF CO2.  CFCs and other ozone depleting substances follow Montreal Protocol.
80% Reduction | All countries reduce CO2 emissions to 80% below 2005 levels by 2050; deforestation falls to 80% below current levels by 2050; afforestation index equals 0.8; other well mixed GHGs (N2O, CH4, PFCs, SF6, and HFCs) follow comparable change as that for FF CO2.  CFCs and other ozone depleting substances follow Montreal Protocol.
Reference of Historical Data
CO2 FF data | Carbon Dioxide Information Analysis Center, downloaded at http://cdiac.ornl.gov/ftp/ndp030/CSV-FILES/nation.1751_2005.csv; yearly value for each economic region is the sum of yearly values for individual nations.    Marland, G., [NAME], and [NAME]
CO2 Land Use data | Historical national CO2 land use emissions obtained from Carbon Dioxide Information Analysis Center, downloaded at http://cdiac.ornl.gov/ftp/trends/landuse/houghton/Global_land-use_flux-1850_2005.xls; yearly value for each economic region is the sum of ye
Population and GDP data | Historical Statistics for the World Economy:  1-2006 AD (Copyright Angus Maddison)
Spreadsheet: 841635d1693821651-index-match-formula-230904-study-plan-grade-3-1-
Sheet: Weekly Plan

ST. MARY’S CATHOLIC HIGH SCHOOL, FUJAIRAH
STUDY PLAN – WEEK No. |  |  | 2
CLASS: GRADE 3                                                                                                      SECTION: A, B, C, D, E
DATE |  | DAY |  | SUBJECT | PORTION
2023-09-02 00:00:00 | Plan | SATURDAY
 |  | SUNDAY
 |  | MONDAY
 |  | TUESDAY
 |  | WEDNESDAY
Spreadsheet: mark_guzman__24567__feb7_requests
Sheet: Sheet1

Summary: Transmission for Feb 7, 2001
Non-Firm: POR: BC/AB border, POD: BC/US border
MW acquired
 | OASIS request
HE (PPT) | 349377 | 349381 | 349382
1 | 100 | 50
2 | 100 | 50
3 | 100 | 50
4 | 100 | 50
5 | 100 | 50
23 |  |  | 50
24 |  |  | 50
Other details - C$
Cost | 6.4
Losses - BC | 0.0644 | Probably better off supplying losses ( eg deliver less than the transmission amount to BC) vs. purchasing from BC (purchasing likely costs > $18/MWh)
Losses - AB | 0.133 | (multiplied by the Pool Price - at C$90/MWh approx. C$12/MWh)
Cost - AB | 2.38
Spreadsheet: 375472d1423198139-complicated-if-statement-banksample
Sheet: Checking

Date | Type | Debit | Credit | Balance
2014-12-31 00:00:00 | WITHDRAW | -10 |  | 100 |  | <-- Cell to display [NAME]
 | (POS 1231 1340 319625 Marianos FRESH WHEATON IL)
2014-12-31 00:00:00 | WITHDRAW | -10 |  | 90 |  | <-- Cell to display [NAME]
 | (POS 1231 1035 319132 475 S SCHMALE ROAD CAROL STREAM IL)
2014-12-31 00:00:00 | DB DEBIT | -10 |  | 80 |  | <-- Cell to display [NAME]
 | (STARBUCKS #02352 WH Wheaton IL 12-30-14 887876)
 | INDEX('Lookup Table'!B:B,MATCH("*"&MID(A1,LEN(LEFT(A1,22)),LEN(A1)),'Lookup Table'!A:A,0))
Spreadsheet: 693142d1598796626-how-to-write-formula-for-column-hurdle-query-sample0830
Sheet: Sheet3

 | Name | Code | Name | Code | Name | Code |  | Name | Code
 | Adam1 | A | Adam6 | F | Adam11 | K |  | Adam7 | G
 | Adam2 | B | Adam7 | G | [NAME] | L
 | Adam3 | C | Adam8 | H | [NAME] | M
 | Adam4 | D | Adam9 | I | Adam14 | N
 | Adam5 | E | Adam10 | J | Adam15 | O
 |  |  |  |  |  |  |  | I2 cell name
 |  |  |  |  |  |  |  | I3 cell Let user input name
 |  |  |  |  |  |  |  | [NAME] a formula to find out the result
 |  |  |  |  |  |  |  | The name is in the B, D, F column
 |  |  |  |  |  |  |  | The CODE to be queried is in column C, E, G
Spreadsheet: 820300d1678002681-sort-mixed-data-from-1-sheet-to-other-tabs-bol-a
Sheet: Mar

helper | Name | date | del/pic | AM/PM | BOL | on/off
 | [NAME] | 00:00:00 | 2023-03-09 00:00:00 | del | am | 57
ggy44994 | peggy | 00:00:00 | 2023-03-09 00:00:00 | pic | am | 58
[NAME] | peggy | 00:00:00 | 2023-03-12 00:00:00 | pic | am | 59
arl44998 | [NAME] | 00:00:00 | 2023-03-13 00:00:00 | del | pm | 60