tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 230017d1366658748-returning-row-data-dependant-on-two-drop-down-lists-car-stats
Sheet: Ark1

 | Brand | Model | Hp | Torque | Engine |  |  |  | Brand
 | Opel | Corsa |  |  |  |  |  |  | Ford
 |  |  |  |  |  |  |  |  | Opel
 |  |  |  |  |  |  |  |  | VW
 |  |  |  |  |  |  |  |  | Seat
 |  |  |  |  |  |  |  |  | Models | HP | Torque | Engine
 |  |  |  |  |  |  |  |  | Ford
 |  |  |  |  |  |  |  |  | Focus | 125 | 250 | 2.0
 |  |  |  |  |  |  |  |  | Escort | 100 | 200 | 1.6
 |  |  |  |  |  |  |  |  | Opel
 |  |  |  |  |  |  |  |  | insignia | 175 | 350 | 2.5
 |  |  |  |  |  |  |  |  | Corsa | 150 | 275 | 2.0
 |  |  |  |  |  |  |  |  | VW
 |  |  |  |  |  |  |  |  | Polo | 69 | 150 | 1.0
 |  |  |  |  |  |  |  |  | Golf | 70 | 160 | 1.2
 |  |  |  |  |  |  |  |  | [NAME] | 90 | 200 | 1.6
 |  |  |  |  |  |  |  |  | Ibiza | 120 | 300 | 2.0
Spreadsheet: 264481d1378899753-is-there-a-way-to-get-multiple-table-formats-to-sort-together-table-example
Sheet: Method 1

Green H1 | [NAME] | Green H3 | Blue H1 | Blue H2 | Blue H3 | Orange H1 | Orange H2 | Orange H3
a | c | 1 | a | c | 1 | a | c | 1
b | c | 2 | b | c | 2 | b | c | 2
a | d | 3 | a | d | 3 | a | d | 3
b | d | 4 | b | d | 4 | b | d | 4
Spreadsheet: 197838d1354571357-how-do-you-use-a-name-names-to-generate-a-number-seatplan
Sheet: Table Plan

 | 1 | 1 |  | Cam | 215
 | 1 | 2 |  | Quinn | 205
 | 1 | 3 |  | [NAME] | 210
 | 1 | 4 |  | [NAME] | 185 |  |  |  |  |  |  |  |  | Select names from the dropdown
 | 1 | 5 |  | [NAME] | 200 |  |  |  |  |  |  |  |  | lists in column E, to fill the seats
 | 1 | 6 |  | [NAME] | 125 |  |  |  |  |  |  |  |  | at the tables
 | 1 | 7 |  | Fran | 130
 | 1 | 8 |  | [NAME] | 175 | 1445 |  |  |  |  |  |  |  | Based on technique shown here:
 | 2 | 1 |  | Pia | 130 |  |  |  |  |  |  |  |  | http://www.contextures.com/xlDataVal03.html
 | 2 | 2 |  | Herb | 174
 | 2 | 3 |  | [NAME] | 155
 | 2 | 4 |  | [NAME] | 165
 | 2 | 5 |  | [NAME] | 175
 | 2 | 6 |  | [NAME] | 135
 | 2 | 7 |  | [NAME] | 110
 | 2 | 8 |  | Ian | 160 | 1204
 | 3 | 1 |  | Ona | 112
 | 3 | 2 |  | [NAME] | 115
 | 3 | 3 |  | Sue | 122
 | 3 | 4 |  | [NAME] | 168
 | 3 | 5 |  | Una | 124
 | 3 | 6 |  | Val | 125
 | 3 | 7 |  | [NAME] | 160
 | 3 | 8 |  | [NAME] | 180 | 1106
Spreadsheet: 819211d1677300033-sort-mixed-data-from-1-sheet-to-other-tabs-bol
Sheet: Mar

Name | date | del/pic | AM/PM | BOL | on/off
[NAME] | 2023-03-09 00:00:00 | del | am | 57 | on
peggy | 2023-03-09 00:00:00 | pic | am | 58 | off
peggy | 2023-03-12 00:00:00 | pic | am | 59 | off
[NAME] | 2023-03-13 00:00:00 | del | pm | 60 | on
Spreadsheet: 676499d1588844168-conditional-formatting-of-due-date-scheduletemplate-etaf-list-calc-
Sheet: LIST

MONTH NO. | MONTH | time card due dates |  | Day Clac | Month Calc | Date Not Weekend | Day Not Weekend | If Holiday |  | 2020 |  | TEST CUREENT
1 | JANUARY | 2020-01-16 00:00:00
2 | FEBRUARY | 2020-01-31 00:00:00
3 | [NAME] | 2020-02-14 00:00:00
4 | APRIL | 2020-02-28 00:00:00
5 | MAY | 2020-03-13 00:00:00
6 | [NAME] | 2020-03-31 00:00:00
7 | JULY | 2020-04-16 00:00:00
8 | AUGUST | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | why 1st NOT April
9 | SEPTEMBER | 2020-05-15 00:00:00
10 | OCTOBER | 2020-05-29 00:00:00
11 | NOVEMBER | 2020-06-16 00:00:00
12 | DECEMBER | 2020-06-30 00:00:00
 |  | 2020-07-16 00:00:00
 |  | 2020-07-31 00:00:00
 |  | 2020-08-14 00:00:00
 |  | 2020-08-28 00:00:00 |  |  |  |  |  |  |  |  |  |  | Why 28th - says 31 on calendar
 |  | 2020-09-16 00:00:00
 |  | 2020-09-30 00:00:00
 |  | 2020-10-16 00:00:00
 |  | 2020-10-30 00:00:00
 |  | 2020-11-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | Why 13th - says 16 on calendar
 |  | 2020-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | NOT A HOLIDAY
 |  | 2020-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  | NOT A HOLIDAY
 |  | 2020-12-31 00:00:00
Spreadsheet: 555148d1515457125-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-2-
Sheet: Tournament 5

 |  |  | Tournament 5
 |  |  |  |  |  |  | Player
 |  |  | Player | Score |  |  | Low Score
 |  | x | x | x
Spreadsheet: 0ca2d36a-314a-4d50-b2dd-898833674ade
Sheet: Resident

FY14 FRINGE BENEFIT WORKSHEET - Resident
Name:
PGY Level: |  | Select a value from Chart A
Medical Benefits? |  | Select a value from Chart B
 |  |  |  |  |  |  |  | Chart A | Eff 10/1/11
Description | Object Code | Factor | [NAME] | Annual | Monthly |  |  | PGY Level | [NAME]
 |  |  |  |  |  |  |  | 1 | 46984
Salary | 1901 |  | =INDEX(I7:J15,MATCH(B3,I7:I15,0),2) |  |  |  |  | 2 | 48622
 |  |  |  |  |  |  |  | 3 | 50203
BENEFITS |  |  |  |  |  |  |  | 4 | 51306
 |  |  |  |  |  |  |  | 5 | 53427
Social Security1 | 1902 |  |  |  |  |  |  | 6 | 54551
 |  |  |  |  |  |  |  | 7 | 55676
Medicare | 1903 |  |  |  |  |  |  | 8 | 56801
 |  |  |  |  |  |  |  | 9
Health Insurance | 1904 | See Chart B |  |  |  |  |  | Chart B
 |  |  |  |  |  |  |  | Health Ins | [NAME]
Total Benefits |  |  |  |  |  |  |  | Ee Only
TOTAL COMPENSATION |  |  |  |  |  |  |  | Ee and Child
 |  |  |  | Benefits as % of Salary = |  |  |  | Ee and Spouse
NOTES: |  |  |  |  |  |  |  | Family
Spreadsheet: 02ac0233-8961-4ac9-9a13-db05238529b1
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
 | 5609.0 Housing Finance, Australia
 | TABLE 9a. HOUSING FINANCE COMMITMENTS (Owner Occupation), By Type of Buyer and Loan: Australia, Original
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
First home buyers - Dwellings financed (no.) ; |  |  | Original | A2412824W | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Number | FLOW | Month | 1
First home buyers - % of all dwellings financed ; |  |  | Original | A2412836F | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Percent | DERIVED | Month | 1
First home buyers - Average loan size ($000) ; |  |  | Original | A2412825X | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | $'000 | DERIVED | Month | 1
Non-first home buyers - Dwellings financed (no.) ; |  |  | Original | A2412827C | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Number | FLOW | Month | 1
Non-first home buyers - % of all dwellings financed ; |  |  | Original | A2416246C | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Percent | DERIVED | Month | 1
Non-first home buyers - Average loan size ($000) ; |  |  | Original | A2412826A | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | $'000 | DERIVED | Month | 1
Fixed rate - Dwellings financed (no.) ; |  |  | Original | A2412828F | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Number | FLOW | Month | 1
Fixed loans - % of all dwellings financed ; |  |  | Original | A2412837J | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Percent | DERIVED | Month | 1
Fixed rate - Average loan size ($000) ; |  |  | Original | A2412829J | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | $'000 | DERIVED | Month | 1
Secured revolving loans - Dwellings financed (no.) ; |  |  | Original | A2412830T | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Number | FLOW | Month | 1
Secured revolving loans - % of all dwellings financed ; |  |  | Original | A2412838K | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Percent | DERIVED | Month | 1
Secured revolving loans - Average loan size ($000) ; |  |  | Original | A2412831V | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | $'000 | DERIVED | Month | 1
Other loans -  Dwellings financed (no.) ; |  |  | Original | A2412832W | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Number | FLOW | Month | 1
Other loans - % of all dwellings financed ; |  |  | Original | A2412839L | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | Percent | DERIVED | Month | 1
Other loans - Average loan size ($000) ; |  |  | Original | A2412833X | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | $'000 | DERIVED | Month | 1
ALL FINANCE - Average loan size ($000) ; |  |  | Original | A2412834A | 1975-10-01 00:00:00 | 2010-01-01 00:00:00 | 412 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 167867d1342123733-find-cusomer-name-sample-3-
Sheet: Sheet1

xyz ltd |  |  | Row Labels
abc corporation |  |  | abc corporation
rj textiles |  |  | DN & sons
[NAME] |  |  | [NAME]
rj textiles |  |  | rj textiles
xyz ltd |  |  | RN Fabrica
xyz ltd |  |  | xyz ltd
abc corporation
DN & sons
[NAME]
DN & sons
abc corporation
RN Fabrica
abc corporation
rj textiles
[NAME]
RN Fabrica
Spreadsheet: 57939d1258147911-conditional-formatting-dates-fiwp-schedule-finish-dates
Sheet: Sheet1

[NAME] SCHEDULE FINISH DATES
[NAME] # | [NAME] | FINISH DATE
25A-F138-26-01 | 25A Pump Skid Cable Tray | 2010-01-15 00:00:00
25A-F138-26-02 | 25A Settler Cable Tray | 2010-11-22 00:00:00
25A-F138-26-03 | 25A Junction Box | 2010-01-15 00:00:00
25A-F138-27-01 | 25A Lighting and Power | 2009-11-27 00:00:00
25A-F138-27-02 | 25A Lighting and Power | 2009-11-27 00:00:00
25A-F138-28-01 | 25A EHT 1st Stage Mixer | 2010-03-06 00:00:00
25A-F138-28-02 | 25A EHT Overflow Drum | 2010-03-06 00:00:00
25A-F138-28-03 | 25A EHT 1st Stage Pumps | 2010-03-06 00:00:00
25A-F138-28-04 | 25A EHT Skid Install | 2010-03-26 00:00:00
25A-F138-28-05 | 25A EHT Power and Control | 2010-04-05 00:00:00
25B-F138-26-01 | 25B Pump Skid Cable Tray | 2009-12-12 00:00:00
25B-F138-26-02 | 25B Settler Cable Tray | 2009-12-19 00:00:00
25B-F138-26-03 | 25B Junction Box | 2010-01-13 00:00:00
25B-F138-27-01 | 25B Lighting and Power | 2009-12-10 00:00:00
25B-F138-28-03 | 25B EHT 2nd Stage Pumps | 2010-02-23 00:00:00
25B-F138-28-01 | 25B EHT 2nd Stage Mixer | 2010-02-23 00:00:00
25B-F138-28-02 | 25B 2nd Stage Overflow Drum | 2010-02-23 00:00:00
25B-F138-28-06 | 25B EHT Terminations | 2010-03-10 00:00:00
25E-F138-31-01 | 25E Electrical Terminations | 2010-02-13 00:00:00
25E-F138-12-01 | 25E EHT Mod Interconnect | 2009-11-29 00:00:00
Spreadsheet: 593945d1539424734-function-to-return-true-na-false-when-value-doesnt-match-equipment_updated
Sheet: After

Equipment | Old ID Number | New ID Number | Reason | Different equipment  for same id
A5678 | - | 89 | Equipment Arrival | NA
A1234 | - | 86 | Equipment Arrival | NA
A5678 | 89 |  | Maintenance | False
A1234 | 89 |  | Maintenance | True
Spreadsheet: 706640d1606816534-how-to-add-positive-and-negative-numbers-based-on-the-text-on-another-cell-help
Sheet: Sheet1

 | Total POSITIVE numbers on Column "I" | Total NEGATIVE numbers on Column "I" |  | Transaction
 | (always related to rows with "OUT") | (always related to rows with "Trade") |  | Finals (2) - Comments(0) - Attachments(0) |  |  |  |  | Transforms Column "I" into numbers
Finals (2) - Comments(0) - Attachments(0) | 297609.5 | -240257.42 |  | Trade - apple
Finals (4) - LSN - Comments(0) - Attachments(0) | 78515.11 | -64238.99 |  | Trade - pie |  | (240,257.42) USD |  |  | -240257.42
Finals (4) - Z - Comments(0) - Attachments(0) | 180138.64 | -190973.93 |  | Trade - burger
Transaction 190 - Comments(0) - Attachments(0) | 0 | 0 |  | Trade - banana
 |  |  |  | OUT - john
 |  |  |  | Invoice - Ref M2910
 |  |  |  | OUT- adam |  | 297,609.50 USD |  |  | 297609.5
 |  |  |  | OUT - peter
 |  |  |  | OUT - kate
 |  |  |  | Invoice - Ref N/A
 |  |  |  | Finals (4) - LSN - Comments(0) - Attachments(0)
 |  |  |  | Trade - cookie |  | (64,238.99) USD |  |  | -64238.99
 |  |  |  | OUT - helena |  | 78,515.11 USD |  |  | 78515.11
 |  |  |  | Finals (4) - Z - Comments(0) - Attachments(0)
 |  |  |  | Trade - drinks |  | (190,973.93) USD |  |  | -190973.93
 |  |  |  | OUT - james |  | 180,138.64 USD |  |  | 180138.64
 |  |  |  | OUT - mike
 |  |  |  | Invoice - Ref M290
 |  |  |  | OUT - tressa
 |  |  |  | Invoice - Ref M290H
 |  |  |  | OUT - patty |  | 40,681.66 USD |  |  | 40681.66
 |  |  |  | OUT - simon
 |  |  |  | Invoice - Ref M3059
 |  |  |  | Transaction 190 - Comments(0) - Attachments(0)
 |  |  |  | Trade - meat
 |  |  |  | BUY - happy bar
 |  |  |  | Note -  Ref IDJK
 |  |  |  | OUT - sofia
 |  |  |  | Invoice  P-95.00 %
 |  |  |  | Invoice  - SUM(CASH)
Spreadsheet: 140665d1328854550-splitting-amount-into-individual-cells-starting-from-the-right-copy-of-copy-of-sample-2
Sheet: Sheet1

 |  | 9 | 8 | 7 | 6 | 5 | 4 | 1 | 2 | 0 | 0 |  | 98765412
1 | 6 | 7 | 8 | 9 | 8 | 7 | 4 | 5 | 6 | 0 | 0 |  | 1678987456
 |  |  |  |  |  |  |  |  | 1 | 0 | 0 |  | 1
 |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 0 |  | 100
 |  | 1 | 0 | 0 | 0 | 0 | 6 | 7 | 1 | 0 | 0 |  | 10000671
Spreadsheet: a787b76f-3f21-400a-af5e-2dd6beddca3c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2611 | 6385 | Satomi | Okochi | JPN | 0 | 00:21:49 | 00:00:00 | 01:19:23 | 00:00:00 | 00:45:23 | 1 | 02:26:37
2611 | 6744 | [NAME] | Langit | PHI | 0 | 00:21:51 | 00:00:00 | 01:19:28 | 00:00:00 | [NAME] | 2 | 02:30:08
2611 | 6742 | [NAME] | Lucas | PHI | 0 | 00:24:22 | 00:00:00 | [NAME] | 00:00:00 | 00:49:16 | 3 | 02:38:47
Spreadsheet: 1233f657-1000-48b8-9295-26a085ba1286
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Cuadro 4.1.09
[NAME]
[NAME] a nivel nacional por año, según fuente de abastecimiento de agua, 2002, 2005-2007
Fuente de abastecimiento de agua | CENSO 2002 | ENHOGAR 2005 | ENHOGAR 2006 | ENHOGAR 2007 | ENIGH 2007
Total | 100 | 100.414957791763 | 100.2440146555333 | 99.96116096454897 | 99.99999999999999
Del acueducto, dentro vivienda | 36 | 42.42472935183535 | 49.94876818402239 | 41.87501623530328 | 44.8
Del acueducto, en patio [NAME] | 25 | 27.75059191890928 | 28.73788886714106 | 31.8025502205071 | 28.4
Del acueducto, llave pública | 18 | 7.329158938298347 | 1.406467889007954 | 6.570165419935017 | 2.4
Manantial, río, arroyo | 5 | 3.896868668718376 | 1.246089058394257 | 3.549519141736934 | 6
Pozo | 7 | 6.441049968397793 | 4.054528956524021 | 6.680146507377745 | 9.3
Lluvia | 1 | 1.60483172604181 | 0.4693521864789202 | 1.232081462258264 | 1
Camión tanque | 7 | 7.689964737609259 | 7.98339261383377 | 6.605610753259408 | 6.1
De la llave/cisterna del vecino | … | … | 4.925538919168466 | 0.861036696394382 | …
Agua de funditas plásticas | … | … | 0.03663432616572667 | … | …
Agua de botellones (procesada) | … | … | 0.08629028708794771 | … | …
Otro | 1 | 3.2777624819528 | 1.349063367708755 | 0.7850345277768249 | 2
Fuente: Censo Nacional de Población y Vivienda 2002
Encuesta de Hogar de Propósitos Múltiples 2005-2006-2007
Encuesta Nacional de Ingresos y Gastos de los Hogares 2007
Spreadsheet: 85909d1285903260-double-lookup-closest-match-lookupthenclosestvalue
Sheet: Sheet2

1759 | 170 | 171 | 166 | 188 | 175
1287 | 155 | 144 | 171 | 166 | 170
1496 | 159 | 165 | 169 | 177 | 180
1355 | 158 | 160 | 165 | 168 | 172
1133 | 155 | 160 | 170 | 175 | 182
Spreadsheet: 117606d1312910036-lookup-multiple-values-of-a-single-cell-and-return-sum-of-results-objectives-sample-sheet
Sheet: Requirements

 | CODE |  | STATUS
 | RQ0001 | Requirement 01 | 1
 | RQ0002 | Requirement 02 | 0
 | RQ0003 | Requirement 03 | 1
 | RQ0004 | Requirement 04 | 0
 | RQ0005 | Requirement 05 | 0
 | RQ0006 | Requirement 06 | 1
 | RQ0007 | Requirement 07 | 0
 | RQ0008 | Requirement 08 | 1
 | RQ0009 | Requirement 09 | 1
 | RQ0010 | Requirement 10 | 1
 | RQ0011 | Requirement 11 | 0
 | RQ0012 | Requirement 12 | 0
 | RQ0013 | Requirement 13 | 1
 | RQ0014 | Requirement 14 | 1
 | RQ0015 | Requirement 15 | 0
Spreadsheet: 781444d1653328020-filter-only-unique-values-filter-only-unique
Sheet: DATA

From here we read the data. |  |  |  | This is what must be showed.
Date | Serial number | Reason for return |  | Date | Serial number | Reason for return
2022-04-20 00:00:00 | NL17314620 | Door issue |  | 2022-04-20 00:00:00 | NL17314620 | Door issue
2022-04-20 00:00:00 | NL17016595 | Door issue |  | 2022-04-20 00:00:00 | N119229362 | Door issue
2022-04-20 00:00:00 |  | LCD issue
2022-04-20 00:00:00 | N119229362 | Door issue
2022-04-20 00:00:00 | NL17146177 | Keypad issue
2022-04-20 00:00:00 | NL16277129 | Housing issue
2022-04-20 00:00:00 |  | Door issue
If there is an empty row in the serial number it means that there is a multiple reason for return. This row plus the row above where there is the serial should not be considered.
Spreadsheet: 879427d1726923845-mixed-up-data-mix-test
Sheet: Sheet1

Store_
4203
 |  | Selling Price | Cost |  | Selling Price | Cost
96047 | Battery | 4419.33 | 3145.89
25 | Tire Accessories
26 | Tire Labor
96806 | FLUIDS AND OILS
Spreadsheet: joe_parks__14531__Cornhusker contacts3
Sheet: Sheet1

Apache |  |  |  |  | [NAME]
[NAME] |  | [PHONE] |  |  | EB 2483A |  | [PHONE] fax
 |  | [PHONE] fax
[NAME]) |  |  |  |  | Mirant (Agent for Brazos)
[NAME] |  | [PHONE] |  |  | [NAME] |  | [PHONE]
 |  | [PHONE] fax |  |  |  |  | [PHONE] pgr
[NAME] Smiron(rep) |  | [PHONE] |  |  | [NAME] |  | [PHONE]
[NAME]
[NAME] |  | [PHONE]
[NAME] |  | [PHONE]
 |  | [PHONE] fax
[NAME] (Agent for Apache)
[NAME] |  | [PHONE]
 |  | 281-665-7521pgr
[NAME] |  | [PHONE]
 |  | [PHONE] fax
White Pine Energy
[NAME]--Director of Asset Mgmt
 |  | [PHONE] |  | [PHONE]
 |  | [PHONE] fax
 |  | [PHONE] cell
[NAME]--Tenaska IV
[NAME] |  | [PHONE]
[NAME] |  | same
 |  | [PHONE] fax
Spreadsheet: 786325d1657115920-adding-leading-zero-leading-0
Sheet: Sheet1

SEC ID | Adding [NAME]
263494
265274
454492
560399
798059
23135106
25537101
36752103
53807103
60505104
67901108
Spreadsheet: 818362d1676767750-dynamic-formula-to-copy-the-data-from-one-sheet-to-another-in-a-table-example-02
Sheet: Sheet - 02

Use single dynamic formulae to bring the values in respective fields using Sheet - 01 Sheet table. The fields in below table is in same sequence as table in Sheet - 01 Sheet
Employee ID | Business | Hire Date | [NAME] | Personnel Subarea | Operating Region | Business Unit | Cost Center | Company Code | Company_Code_Desc | Primary_Industry_Desc
199034590
199034589
199034591
199034594
199034596
199034599
199056767
Use single dynamic formulae to bring the values in respective fields using Sheet - 01 Sheet table. The fields in below table is in different sequence than table in Sheet - 01 Sheet. Don't rearrange the fields in below table.
Employee ID | Primary_Industry_Desc | Business Unit | Personnel Subarea | Business | Company_Code_Desc | Cost Center | [NAME] | Hire Date | Operating Region | Company Code
199034590
199034589
199034591
199034594
199034596
199034599
199056767
Spreadsheet: eric_saibi__9730__011002R
Sheet: Colstrip 03

Owner Name |  | PPL Montana LLC
Station Name |  | Colstrip Power Station
Unit Name |  | Colstrip 03
NERC Region |  | WSCC
State |  | MT
Fuel Type |  | Coal
Capacity |  | 778 MW
Start Date |  | 2002-01-05 00:00:00
End Date |  | 2002-01-12 00:00:00
Prv. Start Date |  | 2002-01-05 00:00:00
Prv. End Date |  | 2002-01-10 00:00:00
Comments |  | Generator problem
SIC |  | 4931
Plant ID |  | 1015370
Unit ID |  | 1007494
Outage ID |  | 19382
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Safety Assumptions

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Safety Assumptions
 | Value of Avoided Injuries and Fatalities | 2012 $ | 2013 $*
 | AIS Level 1  - Minor | 27300
 | AIS Level 2  - Moderate | 427700
 | AIS Level 3  - Serious | 955500
 | AIS Level 4  - Severe | 2420600
 | AIS Level 5  - Critical | 5396300
 | AIS Level 6  - Unsurvivable | 9100000
 | * Values Inflated to 2013 dollars using the BLS Consumer Price Index (CPI-U)
 | Source: Department of Transportation, Guidance on Treatment of the Economic Value of a Statistical Life in U.S. Department of Transportation Analyses (2013)
 | Value of Property Damage Only Crashes | 2010 $ | 2013 $*
 | Property Damages Only (PDO) Crashes | 3206
 | Source: National Highway Traffic Safety Administration, The Economic Impact of Motor Vehicle Crashes (2000)
 | Distribution of Severity-Unknown Injuries
 | No Injury | 0.2154
 | AIS Level 1  - Minor | 0.6273
 | AIS Level 2  - Moderate | 0.104
 | AIS Level 3  - Serious | 0.0386
 | AIS Level 4  - Severe | 0.0044
 | AIS Level 5  - Critical | 0.0103
 | AIS Level 6  - Unsurvivable | 0
 | Expected Value of Avoided Injury (2013 $)
 | Source:  National Highway Traffic Safety Administration (2011)
Spreadsheet: 272315d1382355570-master-list-in-excel-book1-9-_21-10-13
Sheet: ALI

No. | PERSON IN CHARGE | FILE REFERENCE
1 | ALI | ALI.1101
2 | ALI | ALI.1102
3 | ALI | ALI.1103
4 | ALI | ALI.1104
5 | ALI | ALI.1105
6 | ALI | ALI.1106
Spreadsheet: 212579-need-help-auto-generate-columns-stafprofile
Sheet: con

Name
 | ***
Spreadsheet: 698173d1601827258-inventory-cost-calculation-fifo-easy-finaly-3-_error-tacir-
Sheet: Fifo

Date | Item.Code | Type | Note | Purchase | Cost / Unit - Manual | Sale | Cumulative purchase Quantity  irrespective Of [NAME] code | Balance | Cucmulative sales quantity irrespective of item.code | TransactionType | Movement | Total Cost irrespective of item code (works) | Total Cost based on FIFO / item code (problem) | Cumulative purchase Cost irrespective of item.code | ESQty | ESCost | cpq.item | csq.item | excess | cpc.item
2013-01-01 00:00:00 | product1 | 1 |  | 2 | 1.75
2013-01-15 00:00:00 | product2 | 1 |  | 2 | 1.5
2013-01-31 00:00:00 | product2 | 1 |  | 2 | 2
2013-01-31 00:00:00 | product2 | 2 |  |  |  | 1
2013-01-31 00:00:00 | product2 | 2 |  |  |  | 1
2013-01-31 00:00:00 | product2 | 2 |  |  |  | 1
2013-01-31 00:00:00 | product1 |  |  |  |  | 1
 |  |  |  |  |  | Firs in First Out
 |  |  |  |  | Purchase
 |  |  |  |  | Product2 | Price | Cost Total
 |  |  |  |  | 2 | 1.5
 |  |  |  |  | 2 | 2
 |  |  |  |  | Sale | Buy Price | Buy Total
 |  |  |  |  | 1 | 1.5 |  | True
 |  |  |  |  | 1 | 1.5 |  | True
 |  |  |  |  | 1 | 2 |  | False
 |  |  |  |  |  | Total | 5 |  | 4,5 False
 |  |  |  |  |  |  |  |  | 5 True
 |  |  |  |  | Product2,  3 units sold
 |  |  |  |  | sales cost of three items, 5
 |  |  |  |  | the calculation according to the lines is wrong
Spreadsheet: 715928d1611929308-how-to-create-a-dynamic-drop-down-list-from-multiple-values-280121
Sheet: Sheet3

PartyName | Invoices
ABC Industries
Ponink Ltd.
Royters Alif
Onily Arc Traders
Rev Inc.
Qwup Alf Company
XYZ Company
Spreadsheet: 777726d1650564772-reverse-matrix-lookup-return-array-of-matching-values-in-column-reverse-lookup-from-matrix
Sheet: Sheet1

Product | FIRST SALE | part 1 | part 2 | part 3 | part 4 |  |  | PARTS | MIN | MAX
1111 | 2022-01-01 00:00:00 | A | B | C |  |  |  | A | 2022-01-01 00:00:00 | 2022-05-01 00:00:00
2222 | 2022-02-01 00:00:00 | A | G | H | I |  |  | B | 2022-01-01 00:00:00 | 2022-05-01 00:00:00
3333 | 2022-03-01 00:00:00 | D | E | F |  |  |  | C | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
4444 | 2022-04-01 00:00:00 | F | I | K |  |  |  | D | 2022-03-01 00:00:00 | 2022-03-01 00:00:00
5555 | 2022-05-01 00:00:00 | A | B | E |  |  |  | E | 2022-03-01 00:00:00 | 2022-05-01 00:00:00
 |  |  |  |  |  |  |  | F | 2022-03-01 00:00:00 | 2022-04-01 00:00:00
 |  |  |  |  |  |  |  | G | 2022-02-01 00:00:00 | 2022-02-01 00:00:00
 |  |  |  |  |  |  |  | H | 2022-02-01 00:00:00 | 2022-02-01 00:00:00
 |  |  |  |  |  |  |  | I | 2022-02-01 00:00:00 | 2022-04-01 00:00:00
TABLE 1 |  |  |  |  |  |  |  | TABLE 2