tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 62342d1263313064-search-function-returning-cell-id-translationslibrary-new_compiled
Sheet: Common words-phrases

English | French | German | Italian | Spanish | Japanese | Portuguese | Brazilian Portuguese | Swedish | Dutch | Flemish | Greek | Korean | Traditional Chinese/Mandarin (Taiwan) | Cantonese (Hong Kong) | [NAME] (Mainland China) | Russian | Polish | Turkish
OK | OK | Ok |  |  |  |  |  |  |  |  | Εντάξει | 확인 |  | 確認 | 确认
Back | Retour | [NAME] | Indietro | Atrás | 戻る |  | Voltar | Bakåt | Terug |  | Πίσω |  |  | 返回 | 返回 | Назад |  | [NAME]
Do not know | Je ne sais pas | Ich weiß nicht |  |  | わからない
Not appliable | Sans objet | nicht zutreffend | Non applicabile | No es aplicable |  | Não aplicável | [NAME]
Does not apply. | Ne s'applique pas. | [NAME]. | Non è pertinente. | No es pertinente. |  |  |  |  |  |  | Δεν ισχύει.
Help | Aide | Hilfe | Aiuto | Ayuda |  |  | Ajuda | Hjälp | Help |  | Βοήθεια |  |  | 求助（Help） | 求助（Help）
Next | Suivant | [NAME] | Avanti | Siguiente | 次へ |  | Seguinte | Nästa | Volgende |  | Συνέχεια |  |  | 下一步（Next） | 下一步（Next） | [NAME] |  | İleri
Other | Autre | Andere | Altro | Otro | 기타 |  | Outra | Annat | Overige |  | [NAME] | その他 | 其他 | 其他 | 其他
Submit | Soumettre | Abschicken | Invia | Enviar | 提出 |  | Enviar | Avsluta | Verzenden |  | Υποβολή |  |  | 提交 | 提交 | Подтвердить |  | Gönder
Please Specify | Veuillez préciser | Bitte angeben | Si prega di specificare | Por favor, especifique | 具体的に |  | especificar
Spreadsheet: 854648d1704450363-formula-to-tell-me-how-many-more-or-less-are-needed-forum-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REQUIRED
 |  |  |  | F2F | Pre-Bookable | Total |  | F2F needed to be added | Pre-Bookable to be added |  |  |  |  |  |  | Face 2 Face |  | Pre-Bookable
 |  | 2024-01-15 00:00:00 |  | 89 | 79 |  |  |  |  |  |  |  |  |  |  | 90 |  | 60
 |  | 2024-01-16 00:00:00 |  | 92 | 56
 |  | 2024-01-17 00:00:00 |  | 90 | 54
 |  | 2024-01-18 00:00:00 |  | 92 | 16
 |  | 2024-01-19 00:00:00 |  | 88 | 8
 |  | 2024-01-22 00:00:00 |  | 76 | 25
 |  | 2024-01-23 00:00:00 |  | 79 | 15
 |  | 2024-01-24 00:00:00 |  | 80 | 24
 |  | 2024-01-25 00:00:00 |  | 77 | 15
 |  | 2024-01-26 00:00:00 |  | 48 | 16
 |  | 2024-01-29 00:00:00 |  | 103 | 39
 |  | 2024-01-30 00:00:00 |  | 73 | 26
 |  | 2024-01-31 00:00:00 |  | 101 | 29
 |  | 2024-02-01 00:00:00 |  | 32 | 15
 |  | 2024-02-02 00:00:00 |  | 75 | 31
Spreadsheet: 887719d1738054115-unique-list-navin_unique-list_20250128
Sheet: Sheet1

Unique List | CONCOTENATE Formula | Dependant Value | Sector 1 | Sector 2 | Sector 3 | Sector 4 | Sector 5 | Sector 6 | Sector 7 | Sector 8 | Sector 9 | Sector 10 | Sector 11 | Sector 12
 |  |  | Agri | Chemicals | Small Caps
 |  |  | ETF | Services | Paper | General Insurance | Banks | Rating Agency | Broking | Exchanges
 |  |  | ALL
 |  |  | Banks | NBFC | Insurance | Financial Services | IT | Metals | Minerals | Travel | Consumer Staples | QSR | Retail | Cement
 |  |  | Auto
 |  |  | Auto | Auto Ancs
 |  |  | Auto | Auto Ancs | AMC | Insurance | Rating Agency
 |  |  | Auto Ancs | Construction | [NAME]
 |  |  | Auto Ancs | Metals
 |  |  | Auto | Auto Ancs | Telecom
 |  |  | Auto Ancs | Media | Mid Caps | Agri Chemicals
 |  |  | Auto Ancs | Infra | Construction | Agri Chemicals
 |  |  | Auto | Auto Ancs | Banks | NBFC | Cement
 |  |  | Auto | Auto Ancs | Banks | NBFC | Cement | Real Estate
 |  |  | Auto | Auto Ancs | Consumer Durables | EMS | Insurance
 |  |  | Auto | Auto Ancs | Sugar | Aviation
 |  |  | Auto | Auto Ancs | Logistics
 |  |  | Auto | Auto Ancs | Logistics | [NAME] | Consumer Durables | Services
 | In cell [NAME], I want a formula for getting a unique list for the range D3:Z500, excluding the empty cells and sorted alphabetically
Spreadsheet: 64213d1265108046-generating-a-dynamic-list-using-lookup-book1
Sheet: Sheet4

Row Labels | Count of test
11 | 3
2GH | 1
RT62 | 1
7GA | 1
AB71 | 1
8IC | 1
AH10 | 1
12 | 1
0GH | 1
AA1 | 1
15 | 2
3GH | 1
YBU1 | 1
4NU | 1
BR51 | 1
16 | 4
2GK | 1
VA7 | 1
8QV | 1
KK77 | 1
8UH | 1
VV46 | 1
9GS | 1
SY98 | 1
(blank)
(blank)
(blank)
Grand Total | 10
Spreadsheet: 169755d1343051276-formula-across-multiple-sheets-salary-july-2012
Sheet: Jul

Sr. No. | Name | Designation | CTC | P.M. Salary | Ac/No. | Pay | Hold
1 | [NAME] | RM | 120000 |  | xxx3833 |  | 0
2 | [NAME] | RM | 120000 |  | [NAME] |  | 5000
3 | Zee | Sr. RM | 240000 |  | xxx6698 |  | 20000
4 | Stanley | Team Leader | 360000 |  | xxx6871 |  | 0
5 | Nargis | RM | 120000 |  | xxx3581 |  | 10000
6 | Leah | Sr. RM | 180000 |  | xxx9989 |  | 5000
7 | [NAME] | RM | 120000 |  | xxx1211 |  | 0
8 | Jake | RM | 120000 |  | xxx2252 |  | 10000
9 | Nysa | Sr. RM | 240000 |  | xxx2284 |  | 0
10 | [NAME] | Manager | 420000 |  | xxx6458 |  | 0
 | New Joinees |  |  | Resigned
 |  | [NAME] is not being paid for past consecutive 3 months, hence her name should be highligted in this month so that I  can remove her from July's salary sheet.
 |  | or it is even OK if it gets highlighted in previous month  - 3rd occasion of occurrence when the salary is on Hold
Spreadsheet: 148163d1333194244-drop-down-boxes-with-if-statement-and-vlookup-pricebook
Sheet: Analysis

Code | Description | Framework | GM% | GH | GM% | Blank | GM % | JI | GM%
32360 | Product 1234 | 400 | 0.68176 | 0 | #N/A | 400 | 0 | 153.22376 | 0.1692150094737266
32379 | Product 1235 | 0 | #N/A | 0 | #N/A | 410 | 0 | 153.22376 | 0.1692150094737266
32395 | Product 1236 | 0 | #N/A | 0 | #N/A | 425 | 0 | 153.22376 | 0.1692150094737266
51322 | Product 1237 | 0 | #N/A | 0 | #N/A | 430 | 0 | 176.79896 | 0.2799957646809687
Spreadsheet: 48289d1247523092-transposing-a-table-book10
Sheet: Sheet1

Name: | Field | Original Tbl.
ABC | A
ABC | B
ABC | E |  | If all names are filled as in A2:A14
ABC | C |  | what will be the correct formula to return them in A19:A24 ?
ABC | D |  | after typing them in A19:A24, I managed to return the ppropriate fields in range B19:F24.
DEF | D |  | No Helper column nor VBA if possible
DEF | C
GHI | B
JKL | F
MNO | A
MNO | C
MNO | G
PQR | D
 |  |  |  |  |  |  |  | Hand typed Requested Tbl.
Name: | Field | Field | Field | Field | Field |  |  | Name: | Field | Field | Field | Field | Field
ABC | A | B | E | C | D |  |  | ABC | A | B | E | C | D
DEF | D | C |  |  |  |  |  | DEF | D | C
GHI | B |  |  |  |  |  |  | GHI | B
JKL | F |  |  |  |  |  |  | JKL | F
MNO | A | C | G |  |  |  |  | MNO | A | C | G
PQR | D |  |  |  |  |  |  | PQR | D
Hand typed Names
Spreadsheet: 69721d1270318797-sorting-and-coloring-cells-formula-or-macro-help-needed-help
Sheet: Sheet1

- | B | Time | Assignment
z | B3 | 2010-03-23 13:47:24 | ITRMP |  |  | B1 | B2 | B3
 | B3 | 2010-03-26 14:04:11 | ITRMP |  | ITRMP(days) | 1 | 2 | 3
z | B3 | 2010-03-26 14:35:19 | ITRMP |  | OOR(days) | 2 | 3 | 4
z | B3 | 2010-03-26 14:35:45 | ITRMP |  | FCO(days) | 3 | 4 | 5
 | B3 | 2010-03-26 14:48:56 | ITRMP
 | B3 | 2010-03-29 15:07:48 | ITRMP |  | All rows except those labeled "z" in A column, if B1 is on the list it has to be colored red as in this example, B2 yellow, and B3 white.
 | B3 | 2010-03-29 15:08:15 | ITRMP |  | Other thing needed is that by that table on the right if ITRMP for B1 exceeds 1 day from the time stated in C column till today it needs to be copied  to some cell for me to have it sorted out.
 | B3 | 2010-03-30 08:04:18 | ITRMP
 | B3 | 2010-03-30 08:04:38 | ITRMP
z | B3 | 2010-03-30 13:38:50 | ITRMP |  | Same goes for B2 if it exceeds 2 days, B3, 3 days.
z | B3 | 2010-03-30 13:39:19 | ITRMP |  | OOR and FCO, the same rule applies for them too.
 | B3 | 2010-03-30 13:40:33 | ITRMP
 | B3 | 2010-03-30 13:41:06 | ITRMP
 | B1 | 2010-03-30 15:02:31 | ITRMP
 | B3 | 2010-03-31 07:12:51 | ITRMP
 | B3 | 2010-03-31 07:14:34 | ITRMP
z | B3 | 2010-03-31 10:16:21 | ITRMP
z | B3 | 2010-03-31 10:21:43 | ITRMP
 | B3 | 2010-03-31 12:20:48 | OOR
 | B3 | 2010-03-31 13:59:00 | FCO
 | B3 | 2010-03-31 14:07:40 | ITRMP
 | B3 | 2010-03-31 15:02:17 | FCO
 | B3 | 2010-03-31 16:07:26 | ITRMP
 | B3 | 2010-03-31 16:07:53 | ITRMP
 | B3 | 2010-03-31 16:08:28 | ITRMP
 | B3 | 2010-03-31 16:09:06 | ITRMP
z | B3 | 2010-03-31 20:55:00 | OOR
 | B3 | 2010-04-01 07:58:06 | OOR
 | B3 | 2010-04-01 09:10:52 | FCO
 | B2 | 2010-04-01 10:28:13 | FCO
z | B3 | 2010-04-01 14:39:38 | ITRMP
z | B3 | 2010-04-01 14:40:56 | ITRMP
 | B2 | 2010-04-01 14:51:29 | FCO
 | B3 | 2010-04-01 15:01:26 | ITRMP
 | B3 | 2010-04-01 15:02:02 | ITRMP
 | B3 | 2010-04-01 18:02:22 | FCO
 | B3 | 2010-04-01 18:02:45 | FCO
z | B3 | 2010-04-02 07:52:33 | ITRMP
z | B3 | 2010-04-02 07:52:59 | ITRMP
Spreadsheet: 269829d1381301915-excel-conditional-functions-engineering-model-model
Sheet: Technical Analysis

 | Model for Midas Gold Pty Ltd Mine Lift Project - Technical Analysis
7 | Passengers
Accel. Speed (m/s/s) | Decel. Speed (m/s/s) | [NAME] of Cage (m) | [NAME] (m²) | Cost of Steel Mesh ($) | [NAME] (kg) | Passenger Mass (kg) | Total Mass (kg) | Distance to Accelerate (m) | Distance to Decelerate (m) | Distance at Top Speed (m) | Time at Top Speed (s) | Time Accelerating (s) | Time Decelerating (s) | Travel Time per Trip (s) | Entry/Exit Time  (mins) | # [NAME] | Total Time (mins) | Force Gravity (N) | Force Acceleration (N) | Total Force (N) | Torque (N.m) | Revolutions per Second (rev/s) | Radians per Second (rad/s) | Required Output (kW) | Winch Required | Winch Cost
19.6 | 4.9
10 | 2.5
8 | 2
6 | 1.5
4 | 1
2 | 0.5
1 | 0.25
10 | Passengers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W50 (35kW) | W80 (56kW) | W100 (70kW) | W150 (105kW) | W200 (140kW) | TOO MUCH
Spreadsheet: 79768d1279966626-unique-values-and-summing-using-pivot-table-demo
Sheet: AllInvoices

 | Current Vat Rate |  | 1.15 | =15% |  | TOTALS | Total Selling Inc VAT |  | 1773.22 |  | Todays Date
 | Old VAT Rate |  | 1.175 | =17.5% |  |  | Total Selling Ex VAT |  | 1509.12 |  | 2010-07-24 11:01:20
 | VAT RATE Change 1 |  | 1.2 | =20% |  |  | Vat Total |  | 264.1
 | VAT RATE Change 2 |  |  |  |  |  | No of Invoices |  | 10 | [NAME]
 |  |  | Sum of filtered data |  |  |  | Check | OK |  | 491.3
 |  |  | 1773.22 |  | 10 | Invoices
 | NOTE STARTING INVOICE NO 453 14/09/05
 | Invoice Number | Customer | Date | Month | Year | Total Selling Price Amount | Selling Value Ex Vat | [NAME] | Paid | Amount Owed | Time Owed
 | 1 | Customer A | 2005-09-01 00:00:00 | Sept | 2005 | 100 | 85.1063829787234 | 14.8936170212766 | No | 100 | [NAME], 10 Mths, 23 Dys
 | 2 | Customer B | 2008-09-01 00:00:00 | Sept | 2008 | 146.87 | 124.9957446808511 | 21.87425531914894 | Yes
 | 3 | Customer A | 2010-03-01 00:00:00 | Mar | 2010 | 35.24 | 29.99148936170213 | 5.248510638297873 | No | 35.24 | 0 Yrs, 4 Mths, 23 Dys
 | 4 | Fred | 2005-09-01 00:00:00 | Sept | 2005 | 17.63 | 15.00425531914894 | 2.625744680851064 | Yes
 | 5 | [NAME] | 2006-06-15 00:00:00 | Jun | 2006 | 99.88 | 85.00425531914892 | 14.87574468085107 | Yes
 | 6 | Customer A | 2005-10-22 00:00:00 | Oct | 2005 | 124.55 | 106 | 18.55 | Yes
 | 7 | Customer C | 2008-02-21 00:00:00 | Feb | 2008 | 121.06 | 103.0297872340425 | 18.03021276595746 | No | 121.06 | [NAME], 5 Mths, 3 Dys
 | 8 | Fred | 2011-10-21 00:00:00 | Oct | 2011 | 746.12 | 634.9957446808511 | 111.1242553191489 | Yes
 | 9 | [NAME] | 2005-10-01 00:00:00 | Oct | 2005 | 235 | 200 | 35 | No | 235 | [NAME], 9 Mths, 23 Dys
 | 10 | Fred | 2005-10-01 00:00:00 | Oct | 2005 | 146.87 | 124.9957446808511 | 21.87425531914894 | Yes
 |  | Input Value | Input Value |  |  | Input Value | VAT level (Variable calculated) |  | Select Value
 |  | Use  these colms only to input values…all others self generate
Spreadsheet: 238961d1369769945-advanced-conditinal-formatting-colour-scales
Sheet: Sheet1

191
231
231
271
271
-124.5
-98.29
-48.29
-8.29
-8.29
31.71
5.09
92.59
192.59
242.59
282.59
282.59
322.59
322.59
410.09
360.09
410.09
450.09
450.09
490.09
490.09
577.59
677.59
727.59
767.59
767.59
Spreadsheet: john_griffith__16048__2_6_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 20 | 120 | 128 | 50.8 | 54.2 | 0.66 | 2002-02-06 14:43:00
 | CL J2 | 20 | 235 | 245 | 46.4 | 48.4 | 0.6 | 2002-02-06 14:43:00
 | CL K2 | 20.5 | 315 | 322 | 44.4 | 45.3 | 0.58 | 2002-02-06 14:43:00
 | CL M2 | 20.5 | 370 | 380 | 44 | 45.2 | 0.57 | 2002-02-06 14:43:00
 | CL N2 | 20.5 | 420 | 430 | 43.6 | 44.6 | 0.57 | 2002-02-06 14:43:00
 | CL Q2 | 20.5 | 440 | 460 | 41.3 | 43.2 | 0.54 | 2002-02-06 14:43:00
 | CL U2 | 20.5 | 460 | 480 | 40 | 41.7 | 0.53 | 2002-02-06 14:43:00
 | [NAME] | 20.5 | 470 | 490 | 37.8 | 39.5 | 0.5 | 2002-02-06 14:43:00
 | CL X2 | 20.5 | 480 | 500 | 36.4 | 37.9 | 0.48 | 2002-02-06 14:43:00
 | [NAME] | 20.5 | 485 | 505 | 35 | 36.5 | 0.46 | 2002-02-06 14:43:00
 | CL F3 | 20.5 | 490 | 510 | 33.7 | 35.1 | 0.44 | 2002-02-06 14:43:00
 | CL G3 | 20.5 | 495 | 515 | 32.7 | 34 | 0.43 | 2002-02-06 14:43:00
 | CL M3 | 21 | 535 | 545 | 30.2 | 30.8 | 0.4 | 2002-02-06 14:43:00
 | CL Z3 | 21 | 540 | 565 | 26.5 | 27.7 | 0.36 | 2002-02-06 14:43:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 859604d1707930746-combining-unique-value-search-within-a-countif-search-forum-example-3
Sheet: Sheet1

Part Number | Person dealing | 1st Sent Date | 1st Due Date | 2nd person dealing | Final Letters Sent Date | Response Date (+15 working day) | Responses Closing Date | Open / Closed |  | Total open cases (some cases appear on more than one row) | Open cases with no initials in column B | Open cases with initials in column B but no initials in column E | Open cases awaiting with a date in column C less than 20 days prior to today | Open cases with a date more than 20 days after column G date, with no initials in column E | Open cases with an initial in column E | Open cases at appeal
2961-1-70 | TC | 2024-02-13 00:00:00 |  | NG | 2023-11-30 00:00:00 |  | 2023-12-21 00:00:00 | Open
1824-1-14 | AM | 2023-10-30 00:00:00 |  | NC | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open |  | Correct | Should be 1. | Should be 2. | Should be 2. | Should be 2. | Should be 6. | Correct
1824-1-14 | AM | 2023-10-31 00:00:00 |  | NC | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open
2562-1-100 | NG | 2024-02-13 00:00:00 |  | NG | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open |  |  | Equations for columns L to P counts all rows, rather than unique part numbers.
2562-1-100 | NG | 2024-02-13 00:00:00 |  | NG | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open |  |  | Some part numbers have 2 or more lines but should only be counted once e.g., rows 3 & 4 should count as 1.
2888-0-31 |  | 2023-10-31 00:00:00 |  | TP | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open
2888-0-31 |  | 2023-10-31 00:00:00 |  | TP | 2023-11-29 00:00:00 |  | 2023-12-20 00:00:00 | Open
1326-0-15 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1326-0-15 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1326-0-15 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1797-1-57 | IH |  |  |  | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
1797-1-57 | IH |  |  |  | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
1838-1-60 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
1838-1-60 |  |  |  |  | 2023-11-28 00:00:00 |  |  | Closed
2956-1-18 | IH |  |  | IH | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
2956-1-18 | IH |  |  | IH | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
2956-1-19 | IH |  |  | IH | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Open
2959-0-176 |  |  |  |  | 2023-11-28 00:00:00 |  | 2023-12-19 00:00:00 | Closed
0505-0-4 | IH |  |  |  | 2023-11-27 00:00:00 |  | 2023-12-18 00:00:00 | Open
1122-2-1 |  |  |  |  |  |  |  | Appeal
1122-2-1 |  |  |  |  |  |  |  | Appeal
Spreadsheet: 7f4f71ab-4fec-4148-9937-9f21486049fa
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 121425979 | 69829195 | 191255173
FRA | 46223808 | 8022894 | 54246702
OIS | 29704099 | 10141427 | 39845526
Swaption | 0 | 19627039 | 19627039
OTHER* | 6345344 | 24195941 | 30541286
TOTAL | 203699230 | 131816496 | 335515726
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 745592d1630035203-calculate-an-agents-split-based-on-certain-criteria-commission-sheet-sample
Sheet: NextHome

Rentals |  |  |  |  |  |  |  |  | 2021 | 2022 | 2023 | 2024
Address | Price | Commission | Office | Agent | Date | Paid | Agent
Rental Address 1 | 2000 |  |  | 500 | 2021-06-25 00:00:00 | Y | ME |  | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 2023-01-01 00:00:00 | 2024-01-01 00:00:00
Rental Address 2 | 1950 |  |  | 500 | 2021-07-01 00:00:00 | Y | GS
Rental Address 3 | 2500 |  |  | 500 | 2021-07-10 00:00:00 | N | DF |  | Total Commission Earned |  | Net
Rental Address 4 | 2150 |  |  | 500 | 2021-07-11 00:00:00 | C | GS
Rental Address 5 | 1800 |  |  | 500 | 2021-07-22 00:00:00 | C | GS |  | Total Pending
Rental Address 6 | 2200 |  |  | 500 | 2021-07-15 00:00:00 | C | PE |  | Total in Contract
Rental Address 7 | 2100 |  |  | 500 | 2021-08-01 00:00:00 | Y | GS |  | Total Received
Rental Address 8 | 1800 |  |  | 500 | 2021-08-15 00:00:00 | N | GS
Rental Address 9 | 2600 | 1400 |  | 500 | 2021-08-20 00:00:00 | N | PE
 | 0
 | 0
 | 0 |  |  |  |  |  |  |  | AGENT SCORECARD
 | 0 |  |  |  |  |  |  |  | Agent Name |  | Split A | [NAME] | [NAME] | Total Received
 | 0 |  |  |  |  |  |  |  | PE |  | 0.8
 | 0 |  |  |  |  |  |  |  | GS |  | 0.7
 | 0 |  |  |  |  |  |  |  | ME |  | 0.75
 |  |  |  |  |  |  |  |  | DF |  | 0.6
Sales
Address | Price | Commission | Office | Agent | Date | Paid | Agent
Sale Address 1 | 2500000 |  |  | 0 | 2021-06-25 00:00:00 | Y | ME
Sale Address 2 | 1050000 |  |  | 0 | 2021-07-01 00:00:00 | Y | GS
Sale Address 3 | 950000 |  |  | 0 | 2021-07-10 00:00:00 | N | DF
Sale Address 4 | 750000 |  |  | 0 | 2021-07-11 00:00:00 | C | GS
Sale Address 5 | 600000 |  |  | 0 | 2021-07-15 00:00:00 | Y | PE
 | 0 |  |  | 0
 | 0 |  |  | 0
 | 0 |  |  | 0
Commercial - Lease |  |  |  |  |  |  |  |  | Total
Address | Price | Commission | Net | Excl | Date | Paid
 | 0 |  |  | 0
 | 0 |  |  | 0
 | 0 |  |  | 0
 |  |  |  |  |  |  |  | 0.35
Spreadsheet: eric_saibi__9980__112001R
Sheet: Cooper Nuclear 01

Owner Name |  | Nebraska Public Power
Station Name |  | Cooper Nuclear Power Station
Unit Name |  | Cooper 01
NERC Region |  | MAPP
State |  | NE
Fuel Type |  | Nuclear
Capacity |  | 836 MW
Start Date |  | 2001-11-03 00:00:00
End Date |  | 2001-12-14 00:00:00
Prv. Start Date |  | 2001-11-03 00:00:00
Prv. End Date |  | 2001-12-02 00:00:00
Comments |  | Refuel
SIC |  | 4911
Plant ID |  | 1014366
Unit ID |  | 1008642
Outage ID |  | 7457
Spreadsheet: 36338d1234222639-simpler-way-to-record-the-outcomes-of-matches-newman100_2
Sheet: Sheet1

 | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10 |  |  | Points | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10
Team 1 |  | 1,2 | 3,2 | 1,4 | 1,5 | 1,6 | 1,7 | 1,8 | 1,9 | 1,10 |  | Team 1 | 9 |  | A | H | A | A | A | A | A | A | A
Team 2 | 2,1 |  | 2,3 | 2,4 | 2,5 | 2,6 | 2,7 | 2,8 | 2,9 | 2,10 |  | Team 2 | 11 | H |  | A | A | A | A | A | A | A | A
Team 3 | 3,2 | 3,3 |  | 3,5 | 3,6 | 3,7 | 3,8 | 3,9 | 3,10 | 3,11 |  | Team 3 | 13 | H | D |  | A | A | A | A | A | A | A
Team 4 | 3,5 | 3,6 | 3,7 |  | 3,9 | 5,10 | 3,11 | 3,12 | 3,13 | 3,14 |  | Team 4 | 12 | A | A | A |  | A | A | A | A | A | A
Team 5 | 5,1 | 5,2 | 5,3 | 5,4 |  | 5,6 | 5,7 | 5,8 | 5,9 | 5,10 |  | Team 5 | 29 | H | H | H | H |  | A | A | A | A | A
Team 6 | 6,2 | 6,3 | 6,4 | 6,5 | 6,6 |  | 6,8 | 6,9 | 6,10 | 6,11 |  | Team 6 | 34 | H | H | H | H | D |  | A | A | A | A
Team 7 | 4,3 | 4,4 | 4,5 | 4,6 | 4,7 | 4,8 |  | 4,10 | 4,11 | 4,12 |  | Team 7 | 27 | H | D | A | A | A | A |  | A | A | A
Team 8 | 7,1 | 7,2 | 7,3 | 7,4 | 7,5 | 7,6 | 7,7 |  | 7,9 | 7,10 |  | Team 8 | 46 | H | H | H | H | H | H | D |  | A | A
Team 9 | 5,1 | 5,2 | 5,3 | 5,4 | 5,5 | 5,6 | 5,7 | 5,8 |  | 5,10 |  | Team 9 | 40 | H | H | H | H | D | A | A | A |  | A
Team 10 | 2,8 | 8,3 | 8,4 | 8,5 | 8,6 | 8,7 | 8,8 | 8,9 | 8,10 |  |  | Team 10 | 43 | A | H | H | H | H | H | D | A | A
 | Goals for | Goals Against
Team 1 | 35 | 90 | -55
Team 2 | 45 | 95 | -50
Team 3 | 61 | 104 | -43
Team 4 | 70 | 128 | -58
Team 5 | 99 | 89 | 10
Team 6 | 116 | 98 | 18
Team 7 | 106 | 106 | 0
Team 8 | 144 | 84 | 60
Team 9 | 135 | 85 | 50
Team 10 | 164 | 96 | 68
Spreadsheet: 713122d1610559851-combining-vlookup-with-function-to-determine-if-a-date-falls-between-two-dates-excel-data-cleaned-2-
Sheet: Transactions

Account # | Transaction Date | Place for the formula to go
3138374 | 2014-08-31 00:00:00
3173029 | 2016-12-31 00:00:00
3195133 | 2016-12-25 00:00:00
3290431 | 2020-12-29 00:00:00
3166079 | 2017-12-08 00:00:00
3138375 | 2014-08-31 00:00:00
3138375 | 2014-11-30 00:00:00
232084 | 2020-12-10 00:00:00
3041901 | 2014-06-30 00:00:00
218863 | 2014-04-30 00:00:00
81730 | 2014-09-15 00:00:00
102324 | 2014-09-15 00:00:00
5224 | 2014-06-14 00:00:00
3170458 | 2016-03-31 00:00:00
3194526 | 2016-10-11 00:00:00
2754820 | 2019-01-16 00:00:00
2710599 | 2014-08-31 00:00:00
41221 | 2017-08-25 00:00:00
2806881 | 2018-11-26 00:00:00
3170261 | 2016-12-13 00:00:00
50916 | 2018-01-16 00:00:00
90092 | 2019-10-17 00:00:00
2906063 | 2018-01-16 00:00:00
3082339 | 2017-01-17 00:00:00
3082340 | 2017-01-17 00:00:00
3196690 | 2019-12-31 00:00:00
97209 | 2020-08-27 00:00:00
3290431 | 2020-12-29 00:00:00
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Gas Risk

 | Gas Risk
 | 2002 Plan
 |  |  |  |  |  |  |  | Energy Operations
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % of | 2002 |  | Per HC | New HC | Adj Comp |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Total Exp | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 1905755.25
 | Analyst & Associate | 0 |  |  |  |  | 1552884.48
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 535354.5036
ENAEMPEX | Employee Expense |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 0
ENAOUTSV | Outside Services | 0 |  |  |  |  | 71517.19679999999 | Total |  |  |  |  | 36500125
ENASUPP | Supplies Expense |  |  |  |  |  | 79585.32960000001
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 37500 |  |  |  | 1.25
ENARENT | Rent |  |  |  |  |  | 378977.76 | Admins | 52500
ENATECH | Technology |  |  | 145000 |  |  | 81209.52 | Staff | 56250
ENATRANS | Transportation |  |  |  |  |  |  | Associate | 75000
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analysts | 60000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Specialist | 65000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Sr Specialist | 82500
 |  |  |  |  |  |  |  | Managers | 100000
 | Headcount |  |  | 114 |  |  | 39 | Directors | 145000
 |  |  |  |  |  |  |  | Sr Director | 175000
 | A&A Headcount |  |  | 4 |  |  | 0 | Vice President | 237500
 |  |  |  |  |  |  |  | [NAME] | 312500 | 0
 | Total Headcount |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 |  |  |  |  |  |  | Based on information from ENW accounting.
Spreadsheet: 866589d1713512698-formula-required-for-combine-10-unique-digits-from-bottom-to-top-10-digit-from-formula
Sheet: Sheet1

SINGLE [NAME]
2
4
9
2
4
6
2
2
4
6
1
3
8
2
0
1
9
1
6
8
2
4
3
8
0
6
7
4
9
9
5
2
2
3
7
7
7
6
0
1
8
5
6
4
8
6
3
8
9
6
1
7
2
6
9
7
2
5
2
7
4
7
6
1
8
8
0
2
3
7
1
6
0
5
3
5
8
3
1
5
1
1
0
7
8
9
6
7
6
6
3
8
9
1
1
3
6
9
8
4
5
7
5
6
8
2
2
6
6
9
4
1
6
2
0
0
8
3
5
4
2
0
9
7
3
3
8
4
 | 4837902561
 |  | I want to this result from formula