tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125360d1318980147-excel-2007-vlookup-help-vlookup
Sheet: Sheet1

Row Labels | Vender | Desc | Sum of Qty | Oh Hand
98916 |  | SCOOP-DECAFF COFFEE-1000i
1110-030 |  | PLATE COVER RFR TRAY SNSR
1110-081 |  | METAL FAB LIMITER SWITCH
1110-140 |  | BRACKET DRAIN TANK
1110-144 |  | DRAWER ELECT HIGH VOLT
1110-151 |  | BRIDGE WEB 995 2000
1110-155 |  | BRACKET STM TANK SS
1110-160 |  | PNL REAR SUPPORT ELECT
1110-161 |  | BRKT SUPPORT LOWER CARD
1110-179 |  | BRKT BASE TANK DRAIN VLV
1110-190 |  | PNL SUPP RFR MODULE ASSY
1110-208 |  | BRKT MTG CARD GUIDE 995
1110-226 |  | BRKT MNT HTR STMTNK
1110-227 |  | PNL GAUGE HOT WTR
1110-232 |  | EXTR COLD SINK
1110-247 |  | BRKT RTNR LVL PROBE
1110-254 |  | HOUSING REFRIGERATOR 2002
1110-261 |  | COVER ENCL 2000
1110-262 |  | GRATE DRAIN TRAY 2000 NSF
1110-268 |  | NUT INDICATOR GRIND ADJ
1110-271 |  | PNL GRINDER ADJUSTMENT
1110-276 |  | BRKT DREGS BIN SW 2000
1110-287 |  | NEEDLE PLUNGER MILK VALVE
1110-293 |  | ASSY DREGS BIN DOOR 2000i
Spreadsheet: 157575d1337794847-help-needed-understanding-formulas-commission-tracker
Sheet: Sheet1

 | 2 Yr New Activation | 1Yr/3Mo | Upgrade | Right Wireless | Net | Data | Daily Total |  | Commission (10) | Commission (15) | Commission (20) | Commission (25) | Commision (30)
Quota | 12 |  | 35 | 10 | 1 | 15 |  |  | 0-25 | 26-50 | 51-75 | 76-100 | 101+
1st
2nd |  |  | 3 |  |  | 2 |  |  | 4
3rd |  |  | 1 | 2 |  |  |  |  | 3
4th | 1 |  | 1 | 2 |  | 1 |  |  | 5.5
5th
6th
7th | 1 |  | 2 | 1 |  | 1 |  |  | 5.5
8th | 1 |  | 4 |  |  |  |  |  | 4
9th |  |  | 1 |  |  | 1 |  |  | 1.5
10th | 1 |  | 2 |  |  | 1 |  |  | 1.5 | 2.5
11th |  |  | 4 | 2 |  | 1 |  |  |  | 6.5
12th
13th
14th | 2 |  | 3 |  |  | 1 |  |  |  | 7.5
15th | 1 |  | 2 |  |  | 2 |  |  |  | 6
16th |  | 1 | 3 | 2 |  |  |  |  |  | 2.5 | 3.5
17th |  |  | 2 |  |  | 1 |  |  |  |  | 2.5
18th | 3 | 1 | 2 |  |  | 2 |  |  |  |  | 10
19th |  |  | 1 |  |  |  |  |  |  |  | 1
20th
21st |  |  | 3 |  |  | 1 |  |  |  |  | 3.5
22nd |  |  | 3 |  |  | 2 |  |  |  |  | 4
23rd
24th
25th
26th
27th
28th
29th
30th
31st
Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Total $
Still Need
0.65 | 8 |  | 23 | 7 | 1 | 10 | Total Points | Net Pending
Bonus 1 | Make All Quotas |  | 250
Bonus 2 | Quota+100 Points |  | 250
Spreadsheet: 744231d1629098254-index-and-match-function-for-multiple-rows-exampl
Sheet: Sheet2

WO | Product | Product Group | Test No | Total Qty | Reject Qty | Rework Qty | Rework hour | Reject reason | Rework reason | Yield (%) |  | WO | Product | Product Group | Total Qty | Reject Qty | Rework Qty | Rework hour | Reject reason | Rework reason | Yield (%)
11111 | A-XX | A Code | T8 | 12 | 2 | 0 | 0.5 | Damaged |  |  |  | 11111
11111 | A-XX | A Code | T1 | 12 | 0 | 1 | 0.2 |  | replaced
11111 | A-XX | A Code | T2 | 12 | 3 | 0 | 1 | Not working
11111 | A-XX | A Code | T3 | 12 | 0 | 0 | 0
11111 | A-XX | A Code | T4 | 12 | 0 | 0 | 0
Spreadsheet: 842952d1694944011-keyword-search-for-faqs-spreadsheet-faqs
Sheet: How Do I

How Do I stay awake | Drink coffee and Red Bull
How Do I know that it is going to rain | Look up
How Do I know that the cat is dead? | Ask [NAME]
How Do I stay alive | Keep breathing
How Do I - 5 | Answer Question 5
How Do I - 6 | Answer Question 6
How Do I - 7 | Answer Question 7
How Do I - 8 | Answer Question 8
How Do I - 9 | Answer Question 9
How Do I - 10 | Answer Question 10
Spreadsheet: 550885d1512582846-align-two-tables-by-row-based-on-common-column-sample-alignment
Sheet: Sheet1

 | List number 1 |  |  |  |  |  |  | List Number 2
 | Account | January | feburary | march | april | may |  | Account | January | feburary | march | april | may
 | 30001-702 | 0 | 0 | 0 | 0 | 0 |  | 30001-702 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 30001-703 | 0 | 0 | 0 | 0 | 0
 | 30001-705 | -300 | 0 | 0 | -21100 | -19000 |  | 30001-705 | 0 | 0 | 0 | 0 | 0
 | 30001-708 | -900 | -4400 | -5800 | -4060 | -3100 |  | 30001-708 | 0 | 0 | 0 | 0 | 0
 | 30001-709 | -1000 | -6000 | 0 | 0 | 0 |  | 30001-709 | 0 | 0 | 0 | 0 | 0
 | 30001-710 | -15000 | 0 | -2500 | 0 | -2000
 | 30001-712 | 0 | -2400 | 0 | 0 | 0 |  | 30001-712 | 0 | 0 | 0 | 0 | 0
 | 30002-702 | 0 | 0 | 0 | 0 | 0 |  | 30002-702 | 0 | 0 | 0 | 0 | 0
 | 30002-703 | 0 | 44000 | 75000 | 9000 | 0 |  | 30002-703 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 30002-705 | 0 | 0 | 0 | 0 | 0
 | 30002-708 | 900 | 4400 | 5800 | 4060 | 3100 |  | 30002-708 | 0 | 0 | 0 | 0 | 0
 | 30002-709 | 1000 | 6000 | 0 | 0 | 0 |  | 30002-709 | 0 | 0 | 0 | 0 | 0
 | 30002-710 | 15000 | 0 | 2500 | 0 | 2000 |  | 30002-710 | 0 | 0 | 0 | 0 | 0
 | 30002-712 | 0 | 2400 | 0 | 0 | 0 |  | 30002-712 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 59320d1259801100-making-a-time-sheet-any-one-could-help-studio-session-record-with-time-page
Sheet: Item Form

 |  |  |  |  | Studio Session Record
 |  |  |  |  | Session Record No:
 |  | Client: |  |  | Date:
 |  |  |  |  | P.O. No:
 |  |  |  |  | Personnel:
 |  |  | Identification:
 |  | ProTools: | 7.4
 |  | kHz: | 44.1
 |  | Bit-Rate: | 24
 |  | Qty. | Code | Description |  |  | Unit Cost | Extended Price
 |  |  |  |  |  |  | Total: | 0
 |  | 1
 |  | Authorized By:
 |  | All properties left on our premises are stored at owner's risk.
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 9

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC |  |  |  |  |  | #N/A | 0
CONFLICTS |  |  |  |  |  | #N/A | 0
ID'S |  |  |  |  |  | #N/A | 0
ISA |  |  |  |  |  | #N/A | 0
Spreadsheet: 138550d1327705104-excel-2007-transpose-cant-work-transpose
Sheet: Sheet1

Sheet1 |  |  |  |  | Shhet2
[NAME] | PCname1 |  |  |  | [NAME] | PCname1 | PCname2
[NAME] | PCname2 |  |  |  | [NAME] | PCname3
[NAME] | PCname3 |  |  |  | [NAME] | PCname121 | Pcname 55 | PCname434 | PCname2 | Pcname 755
[NAME] | PCname121
[NAME] | Pcname 55
[NAME] | PCname434
[NAME] | PCname2
[NAME] | Pcname 755
Spreadsheet: 31168d1226967718-vlookup-with-text-and-number-as-identifier-problem-with-vlookup
Sheet: 3Q

AccountID | Client Type
125
200
10001
10003
10004
10005
10006
10011
10012
10013
10014
16101
16102
16103
16104
16106
16107
16108
16124
16201
16202
16205
16206
16207
16701
16702
16801
16802
16803
16804
18000
18001
20165
24025
24100
24120
24123
24124
24125
24151
24153
24155
24156
24200
25023
25040
25050
25127
25260
25290
25454
25455
25492
25496
25561
25610
25811
25856
25900
25986
30856
30856
34315
44248
44953
44963
46452
46453
47306
47334
47345
50110
50634
53219
56020
56525
56532
60011
60752
60754
60758
63092
63126
63140
63140
63253
63253
63329
70720
80029
80039
80098
80143
80148
84012
84014
84237
84251
84428
84724
85232
85264
85279
85371
86027
86031
86096
86231
86247
86247
86263
86264
86265
86266
86268
86269
86271
86272
86276
86277
86279
86438
87145
87316
87344
88125
88202
88259
88318
89020
92253
110016
110030
110030
120310
120317
120320
120320
120324
130504
130505
130506
130507
130510
130518
130523
140701
160126
160134
160176
160183
160184
160185
160186
900029
900033
900049
900053
900055
900056
900057
900058
900059
900060
900060
900067
900068
900069
42159001
50175001
50580001
50904001
50905001
Spreadsheet: 790519d1659760112-cumipmt-and-cumprinc-formulas-need-help-loan-calculation
Sheet: corrected

 |  |  |  |  |  |  |  |  |  |  |  | Proof of Concept
 | Calculation | From month | Till month | Months | Annual rate | Loan amount | Interest | Principal | Total payments | Monthly payment |  | monthly PMT
 | Year 1 - 3 | 1 | 36 |  | 0.095 | 8400000
 | Year 4 - 5 |  | 60 |  | 0.075
 | Year 6 and more |  | 180 |  | 0.05
 |  |  |  |  |  | Total |  |  |  |  |  |  | interest+principal
Spreadsheet: mary_fischer__25635__31R
Sheet: E5.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031R
COMPANY NAME    Limbach Company Holding Company
ANALYSIS OF GOODWILL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-5
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  |  |  |  |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | AMORTIZATION |  | BALANCE |  |  |  |  |  | OTHER |  |  |  | BALANCE
 |  | PERIOD (Yrs.) |  | DR. (CR.) |  | ADDITIONS |  | AMORTIZATION** |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Goodwill* |  |  |  |  |  |  |  |  | ** |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0344 | Same signs as Hyperion
**MUST TIE TO HYPERION ACCOUNT 1418 | Reverse signs from Hyperion
Spreadsheet: 215927d1361544186-how-to-open-the-hyperlink-formulas-sheet-and-hide-all-sheets-except-clicking-hyperlink-bom-sheets
Sheet: FNSBDRKSC

 | Run Date:-01.02.2013
 | 2013-02-01 00:00:00
 | Part Code | Part name | Unit | Qty | Rate | Amount
 | HFNSBDRKSCRBRD | HF DAWN SPOKE DRK [NAME] Red | PC | 1 | 22614.38 | 22614.38
 | 0005Z-AAH-H100 | ENGINE ASSY. (KICK) | PC | 1 | 6225.46 | 6225.46
 | 11191-GW8-6810 | GASKET CRANK CASE | PC | 1 | 19.16 | 19.16
 | 11394-GW8-6810 | GASKET R CRANK CASE COVER | PC | 1 | 16.59 | 16.59
 | 1132A-KST-9400 | PLATE OIL SEPARATE SUB. ASSY. | PC | 1 | 50.14 | 50.14
 | [PHONE] | CLAMPER OVER FLOW PIPE | PC | 1 | 0.44 | 0.44
 | 90031-GF6-0000 | BOLT A CYL STUD 6x198x7 | PC | 2 | 12.95 | 25.9
 | 90032-GF6-0000 | BOLT B CYL STUD 6X205.5X7 | PC | 2 | 12.95 | 25.9
 | [PHONE] | DRAIN COCK PACKING | PC | 1 | 0.54 | 0.54
 | 90701-GF6-0000 | PIN DOWEL SPECIAL 8X14 | PC | 2 | 0.86 | 1.72
 | 90702-GB6-9100 | PIN DOWEL 8X12 | PC | 4 | 0.8 | 3.2
 | 90703-HC4-0000 | DOWEL PIN 10X14 | PC | 2 | 1.1 | 2.2
 | [PHONE] | PLUG RUBBER 19 MM | PC | 1 | 1.24 | 1.24
 | [PHONE] | OIL SEAL 13.8X24X5 | PC | 1 | 3.01 | 3.01
 | [PHONE] | O RING 13.8X2.5 | PC | 1 | 1.13 | 1.13
 | 91303-GF6-0000 | PACKING RUBBER 16 MM | PC | 1 | 4.72 | 4.72
 | [PHONE] | O-RING 6X1.7 | PC | 2 | 0.33 | 0.66
 | 91356-KGH-9010 | O-RING 30 MM | PC | 1 | 0.67 | 0.67
 | 92800-12000-00 | DRAIN PLUG BOLT | PC | 1 | 4.24 | 4.24
 | 96001-06028-00 | BOLT FLANGE SH.6X28 | PC | 2 | 0.95 | 1.9
 | 96001-06032-00 | BOLT FLANGE SH 6X32 | PC | 1 | 1.04 | 1.04
 | 96001-06040-00 | BOLT FLANGE SH.6X40 | PC | 5 | 1.13 | 5.65
 | 96001-06050-00 | BOLT FLANGE SH.6X50 | PC | 1 | 1.53 | 1.53
 | 96001-06060-00 | BOLT FLANGE SH.6X60 | PC | 2 | 1.67 | 3.34
 | 96001-06065-00 | BOLT FLANGE SH.6X65 | PC | 6 | 1.7 | 10.2
 | 96001-06070-00 | BOLT FLANGE SH 6X70 | PC | 1 | 1.76 | 1.76
 | 96001-06080-00 | BOLT FLANGE SH.6X80 | PC | 1 | 2.59 | 2.59
 | 11330-AAH-H000 | COVER COMP R CRANK CASE | PC | 1 | 276.54 | 276.54
Spreadsheet: 846126d1697439335-excel-formula-with-multiple-conditions-example_20231016
Sheet: Blad2

 |  |  |  |  |  |  |  |  | Column1 | Column2 | Date on site | Column1_accounted for condition
 |  |  |  |  |  |  |  |  | 1.1 | PIPE BLK
 |  |  |  |  |  |  |  |  | 1.2 | PIPE GAL
 |  |  |  |  |  |  |  |  | 1.3 | RHS PTD
 |  |  |  |  |  |  |  |  | 1.3 | RHS BLK
 |  |  |  |  |  |  |  |  | 1.4 | RHS GAL
 |  |  |  |  |  |  |  |  | 1.5 | C/RAIL BLACK
 |  |  |  |  |  |  |  |  | 1.6 | C/RAIL GAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell you want to show result in:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Formulatext
 |  |  | D23 | E23 |  |  | H23
 |  |  | C/RAIL BLACK |  |  |  | 22.34
Spreadsheet: 181262d1347978104-copy-speciffic-rows-from-workbook-with-vba-or-formula-0a1_f_target_0
Sheet: Sheet1

 |  |  |  |  |  |  |  | IF formula
 |  |  |  |  | <- should not be displayed |  |  | Lookup formula
 |  |  |  |  | <- should not be displayed
header | header | header | header | header
D1 | F1 | H1 | CS ABS | AA1 |  |  |  | Example  of what it should look like
D3 | F3 | H3 | CS ABS | AA3
D4 | F4 | H4 | CS ABS | AA4
D5 | F5 | H5 | CS ABS | AA5
D6 | F6 | H6 | CS ABS | AA6
D8 | F8 | H8 | CS ABS | AA8
D9 | F9 | H9 | CS ABS | AA9
D10 | [NAME] | H10 | CS ABS | AA10
Spreadsheet: 845764d1697120482-sumproduct-with-multiple-criteria-and-table-proof-of-concept_revenue
Sheet: Sheet1

 |  |  |  | ITEM |  | VALUE/ |  |  |  | VALUE/ |  |  |  |  |  |  | SCENARIO
allocation type | allocation type | allocation type | category | [NAME] | NO. UNITS | UNIT | NSA/UNIT | CAP RATE | GFA/UNIT | UNIT | comment |  | NSA | GFA | VALUE |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 1 | 1 | REVENUE | 4B HOUSE - N | 8 | 10000 | 250 | 1 |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1
 | 2 | 2 | REVENUE | 4B DUAL OCCUPANCY - N | 16 | 10000 | 210 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0
 | 3 | 3 | REVENUE | 4B HOUSE - S | 8 | 10000 | 250 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0
 | 4 | 4 | REVENUE | 4B DUAL OCCUPANCY - S | 16 | 10000 | 210 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 1
 | 5 | 5 | REVENUE
 | 6 | 6 | REVENUE
 | 7 | 7 | REVENUE
 | 8 | 8 | REVENUE
 | 9 | 9 | REVENUE
 | 10 | 10 | REVENUE
 |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | COMMENT
 |  |  |  |  | NSA | NSA | NSA | NSA | NSA | NSA | NSA | NSA
 |  | want to skip this step
 |  |  |  | total
 |  | outcome wanted
 |  | all | acquisition | Legals and establisment fees
 |  |  | acquisition | Stamp Duty - North
 |  |  | acquisition | Stamp Duty - South
 |  |  | acquisition | Land Purchase - North
 |  |  | acquisition | Land Purchase - South
 |  |  | acquisition | Consultant Fees
 |  |  | acquisition | Valuation
Spreadsheet: 844854d1696507025-finding-text-from-one-tab-and-entering-a-yes-in-another-tab-sample-data
Sheet: Template (Draft)

Colleague/Employee ID | Driver/FLT | [NAME]/FLT (Date)
 | YES
Spreadsheet: 722515d1615304730-calculate-total-values-between-dates-where-rate-changed-mid-month-salariescost
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Network days
 |  |  |  | Effective | Salary |  |  |  |  |  | 2021-04-01 00:00:00
 |  |  | Employee 1 | 2021-04-01 00:00:00 | 500 |  |  |  |  | Salaries
 |  |  | Employee 1 | 2021-04-12 00:00:00
 |  |  | Employee 2 | 2020-04-01 00:00:00 | 500
 |  |  | Employee 2 | 2021-04-12 00:00:00 | 800
 |  |  | Employee 3 | 2021-05-10 00:00:00 | 1000
 |  |  | Employee 4 | 2021-06-22 00:00:00 | 700
Spreadsheet: 00b12add-23e4-44eb-a62b-922c9ae726ea
Sheet: Sheet1

Title | Creator/Author | Publication Date | OSTI Identifier | Report Number(s) | DOE Contract Number | Other Number(s) | Resource Type | Specific Type | Coverage | Resource Relation | Research Org. | Sponsoring Org. | Subject | Related Subject | Description/Abstract | Publisher | Country of Publication | Language | Format | Availability | Rights | System Entry Date | Full Text | Bibliographic Citation | DOI | Dataset Content Type
Spreadsheet: 102126d1300159651-sumif-vlookup-index-copy-of-data
Sheet: Sheet1

Data
Name | Grade |  | Name | Result Combined |  |  |  | Count of Grade | Grade
[NAME] | A |  | [NAME] | B,B |  |  |  | Name | A | B | C | Grand Total
[NAME] | B |  | [NAME] | A,A,A |  |  |  | [NAME] | 3 |  |  | 3 |  | [NAME] | A,A,A,
Raka | C |  | Raka | C,B |  |  |  | [NAME] |  | 1 | 1 | 2 |  | [NAME] | B,C,
Lew | A |  | Lew | A,C |  |  |  | Lew | 1 |  | 1 | 2 |  | Lew | A,C,
[NAME] | B |  | [NAME] | B,C |  |  |  | [NAME] |  | 2 |  | 2 |  | [NAME] | B,B,
Ray | C |  | Ray | C |  |  |  | Raka |  | 1 | 1 | 2 |  | Raka | B,C,
[NAME] | A |  |  |  |  |  |  | Ray |  |  | 1 | 1 |  | Ray | C,
[NAME] | B |  |  |  |  |  |  | Grand Total | 4 | 4 | 4 | 12
Raka | B
Lew | C
[NAME] | C
[NAME] | A
Spreadsheet: sally_beck__33996__MgmtSum-Q201-Global-0420
Sheet: Mgmt Summary

ENRON GLOBAL MARKETS
2nd QUARTER 2001 EARNINGS ESTIMATE
Results based on activity through April 20, 2001
 |  | Plan |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Margin | Expenses(1) | EBT |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expenses | Expenses | Total
Crude & Products
Coal
Vessel Trading
Emissions
Weather
Global Risk Markets
Financial Trading
Freight Markets
LNG
Puerto Rico
Finance and Structuring |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Office of the Chairman
Overview |  | 3903 | 0 |  |  | 0 |  | 0 |  |  |  | 0 | 0 |  |  |  |  | 0
Total Commercial
Group Support Cost |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 |  |  |  |  | 0 |  | 0
Support Cost Allocated to Teams |  | 0 |  |  |  | 0 |  | 0 |  |  | 0 | 0 |  |  |  |  |  | 0
Other Interest Related Charges |  |  | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  |  |  | 0 |  | 0
Capital Charge Offset |  | 0 |  |  |  | 0 | 0 | 0 |  |  |  | 0 | 0 |  |  |  |  |  | 0 | 0
Global Markets EBIT
 |  |  |  |  |  | Other Expenses:
Interest Expense/(Income) |  | 0 | 308 |  |  |  |  |  |  |  | 0 | 308 | 0 |  |  |  |  | 0 |  | 0
Global Markets Pre-tax Income
 |  |  |  | MPR Change:
(1) Includes direct and allocated expenses
Spreadsheet: 3a73e4c1-94c3-4b0f-9193-4deb80526dcd
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259393 | 24353 | Julia | Hector | GBR | 652 | 00:13:59 | 00:00:58 | 00:36:03 | 00:00:00 | 00:25:01 | 1 | 01:15:59
259393 | 9419 | [NAME] | Read | GBR | 655 | 00:16:43 | 00:00:58 | 00:35:36 | 00:00:00 | 00:25:01 | 2 | 01:18:17
259393 | 11582 | Elaine | Scott | GBR | 656 | 00:16:52 | 00:01:18 | 00:36:33 | 00:00:00 | 00:29:38 | 3 | 01:24:20
259393 | 56438 | Christine | O Reilly | GBR | 654 | 00:16:21 | 00:01:05 | 00:42:27 | 00:00:00 | [NAME] | 4 | [NAME]
259393 | 72890 | [NAME] (sue ) | Graves | GBR | 651 | 00:18:49 | 00:00:49 | 00:43:26 | 00:00:00 | 00:28:50 | 5 | 01:31:52
259393 | 72891 | [NAME] | Jones | GBR | 653 | 00:22:36 | 00:01:14 | 00:46:02 | 00:00:00 | 00:38:35 | 6 | 01:48:26
Spreadsheet: 804475d1668096942-compare-two-tables-and-find-average-book3-4-
Sheet: Sheet1

Table 1 |  |  |  |  | Table 2 |  |  |  |  | Desired Result Table
Last Name | First Name | Dept | Rank |  | Last Name | First Name | Dept | Rank |  | Last Name | First Name | Dept | Rank
[NAME] | [NAME] | Tax | 10 |  | [NAME] | [NAME] | Tax | 9 |  |  | [NAME] | Tax | 9.5
Blair | Felix | Legal | 9 |  | Blair | Felix | Legal | 8 |  | Blair | Felix | Legal | 8.5
We | Jing | Tax | 5 |  | Wun | [NAME] | Tax | 3 |  | We | Jing | Tax | 5
Wick | [NAME] | IT | 10 |  | Wick | [NAME] | IT | 10 |  | Wick | [NAME] | IT | 10
 |  |  |  |  | Val | Vikrish | IT | 8 |  | Wun | [NAME] | Tax | 3
 |  |  |  |  |  |  |  |  |  | Val | Vikrish | IT | 8
Spreadsheet: 691990d1598001856-countif-with-age-calculation-based-on-dates-age-groups
Sheet: Sheet1

Date of birth | Date survey |  |  |  | Age group | # of children in age group
2017-09-27 | 2020-07-12 |  |  |  | > 0 & < 1
2017-07-17 | 2020-07-11 |  |  |  | => 1 & < 2
2016-11-12 | 2020-07-11 |  |  |  | => 2 & < 3
2017-12-19 | 2020-07-11 |  |  |  | => 3 & < 4
2019-04-21 | 2020-07-11 |  |  |  | => 4 & < 5
2018-11-06 | 2020-07-11
2016-01-05 | 2020-07-11
2018-06-17 | 2020-07-11
2019-07-28 | 2020-07-11
2020-04-18 | 2020-07-11
2015-08-25 | 2020-07-11
2018-02-03 | 2020-07-12
2017-08-15 | 2020-07-12
2017-12-21 | 2020-07-15
2015-12-10 | 2020-07-15
2017-04-18 | 2020-07-15
2020-07-14 | 2020-07-14
2018-04-14 | 2020-07-14
2018-04-04 | 2018-04-28
2018-06-06 | 2020-07-14
2019-07-31 | 2020-07-15
2020-02-04 | 2020-07-15
Spreadsheet: 695696d1600349621-count-a-unique-number-based-on-2-other-criteria-s-test
Sheet: Sheet1

68931921 | 405 N/L PLATINUM ATLAS | 13334501 | 2020-09-09 00:00:00 | 15:31:21 | ISS-SO | -240 | 895 | [NAME] | AFIN3538 | 129 | 20001101 |  | Aug
68931920 | 405 COV PLATINUM ATLAS | 13334301 | 2020-09-09 00:00:00 | 15:31:21 | ISS-SO | -160 | 280 | [NAME] | 3538 | 129 | 20001001 |  | Aug
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-15 00:00:00 | 08:39:04 | ISS-SO | -60 | 97 | [NAME] | AFIN | 130 | 30001001 |  | Aug
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-15 00:00:00 | 08:39:04 | ISS-SO | -60 | 100 | [NAME] | AFIN | 130 | 30001001 |  | Aug
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-16 00:00:00 | 10:58:51 | ISS-SO | -100 | 137 | [NAME] | AFIN | 136 | 30001001 |  | Sep
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-16 00:00:00 | 10:58:51 | ISS-SO | -100 | 140 | [NAME] | AFIN | 136 | 30001001 |  | Sep
43023506 | BMW WINDOW ROLLER | 43023506 | 2020-09-16 00:00:00 | 10:59:00 | ISS-SO | -10000 | 156619 | [NAME] | 3602 | 135 | 20001201 |  | Sep
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-16 00:00:00 | 10:59:08 | ISS-SO | -60 | 37 | [NAME] | AFIN | 134 | 30001001 |  | Sep
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-16 00:00:00 | 10:59:08 | ISS-SO | -60 | 40 | [NAME] | AFIN | 134 | 30001001 |  | Sep
72400101 | MAG LH  B/WARE MOULD | MAG005VM | 2020-09-16 00:00:00 | 0.457731481 | ISS-SO | -60 | 37 | [NAME] | AFIN | 134 | 30001001 |  | Sep
72400102 | MAG RH  B/WARE MOULD | MAG006VM | 2020-09-16 00:00:00 | 0.457731481 | ISS-SO | -60 | 40 | [NAME] | AFIN | 134 | 30001001 |  | Sep
 | SEP
30001001
20001001
20001101
20001201
Spreadsheet: 795006d1662461716-right-forumla-in-vlookup-error-urmarire-porci-2022
Sheet: FEBRUARIE

 | 7 morti
NR. CRT | DATA | NR. CAPETE | GREUTATE VIU | [NAME] | LOT | GREUTATE CARCASA CALAFAT | GREUTATE CARCASA DTS | GREUTATE CARCASA CU CAP | GREUTATE ORGANE
1 | 2022-02-02 00:00:00 | 5 | 490 |  |  | 78 | 310 |  | 10.2
2 | 2022-02-04 00:00:00 | 7 | 698 |  |  |  |  |  | 15
3 | 2022-02-07 00:00:00 | 5 | 497 |  |  |  |  |  | 11
4 | 2022-02-09 00:00:00 | 4 | 398 |  |  | 307 | 0 |  | 11
5 | 2022-02-10 00:00:00 | 6 | 601 |  |  | 0 | 463 |  | 14
6 | 2022-02-12 00:00:00 | 8 | 805 |  |  |  | 465 |  | 20.5
7 | 2022-02-14 00:00:00 | 7 | 708 |  |  | 78 | 529 |  | 20
8 | 2022-02-16 00:00:00 | 7 | 702 |  |  |  |  |  | 21
9 | 2022-02-18 00:00:00 | 8 | 805 |  |  |  | 310 |  | 25.2
10 | 2022-02-22 00:00:00 | 5 | 504 |  |  |  |  |  | 15.2
11 | 2022-02-24 00:00:00 | 8 | 806 |  |  |  |  |  | 25.7
12 | 2022-02-26 00:00:00 | 4 | 405 |  |  | 315 |  |  | 11
Total
Spreadsheet: 765021d1643126271-table-search-for-codes-glass-size-search
Sheet: Glass Sizes

Prefix | Code | [NAME] | [NAME] |  | Prefix | Code | [NAME] | [NAME]
BDL | 3(66/98) |  |  |  | BDR | 33 (78/60)
BDL | 33 (78/60) |  |  |  | BDR | 34 (94/60)
BDL | 34 (94/60) |  |  |  | BDR | 35 (114/60)
BDL | 35 (114/60) |  |  |  | BDR | 81 (78/75)
BDL | 81 (78/75) |  |  |  | BDR | 82 (78/95)
BDL | 82 (78/95) |  |  |  | BDR | 85 (94/75)
BDL | 85 (94/75) |  |  |  | BDR | 86 (94/95)
BDL | 86 (94/95) |  |  |  | BDR | 86 (94/95)
BDL | 89 (114/75) |  |  |  | BDR | 89 (114/75)
BDL | 90 (114/95) |  |  |  | BDR | 93 (134/75)
BDL | 93 (134/75) |  |  |  | BDR | 94 (134/95)
BDL | 94 (134/95)
Spreadsheet: 103927d1301578698-compare-two-worksheet-and-copy-the-diffrences-on-a-new-row-in-sheet-1-sample-for-assitans
Sheet: Sheet 2

toh_ordernr | too_op | too_radnr | too_ben | too_datum_start_pl | too_datum_start_av | too_datum_slut_pl | too_datum_slut_av | too_status | pg_nr | "left"(TORDER_HUVUD.toh_ordernr,5) | TORDER_OPERATION.too_datum_slut_av-TORDER_OPERATION.too_datum_slut_pl | kor_pos | k_namn | kor_artnr | Pos | Description
35020-10 |  |  | xxx |  |  |  |  |  |  | 35020 |  |  | Kalle 1
35020-11 |  |  | xxx |  |  |  |  |  |  | 35020 |  |  | Kalle 1
35020-12 |  |  | xxx |  |  |  |  |  |  | 35020 |  |  | Kalle 1
35132-1 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-2 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-3 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-4 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-5 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-6 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-7 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-8 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-9 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-10 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-11 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]
35132-12 |  |  | xxx |  |  |  |  |  |  | 35132 |  |  | [NAME]