tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 109110d1306025321-mirroring-a-single-table-across-worksheets-5-3-1
Sheet: Week 4

[NAME] 5/3/1 |  |  |  |  |  |  | Weight | Reps <12 | 1RM | 5RM | 90% 1RM
Linear Pre-Periodization |  |  |  |  |  | OHP | 100 | 5 | 112.5112511251125 | 100 | 100
 |  |  |  |  |  | Deadlift | 360 | 3 | 381.1944091486658 | 338.8055908513342 | 345
 |  |  |  |  |  | Bench | 95 | 3 | 100.5929690808979 | 89.40703091910207 | 90
 |  |  |  |  |  | Squat | 260 | 3 | 275.3070732740364 | 244.6929267259636 | 250
 |  |  |  |  |  | Set Interval | 0.125 | Generally 10-15%
Day | Exercise | Reps | Weight |  | Day | Exercise | Reps | Weight |  | Day | Exercise | Reps | Weight
Friday | Deadlift | 5 | 165 |  | Sunday | Bench | 5 | 45 |  | [NAME] | Squat | 5 | 120
 |  | 5 | 195 |  |  |  | 5 | 55 |  |  |  | 5 | 145
 |  | 3 | 230 |  |  |  | 3 | 60 |  |  |  | 3 | 165
 |  | 5 | 260 |  |  |  | 5 | 70 |  |  |  | 5 | 190
 |  | 3 | 295 |  |  |  | 3 | 75 |  |  |  | 3 | 215
 |  | 1+ | 330 |  |  |  | 1+ | 85 |  |  |  | 1+ | 240
 | Romanian Deadlift | 12 | 185 |  |  | Pullups | 14 | BW |  |  | [NAME] | 15 | 290
 |  | 12 | 185 |  |  |  | 13 | BW |  |  |  | 15 | 290
 |  | 12 | 185 |  |  |  | 12 | BW |  |  |  | 15 | 290
 |  | 12 | 185 |  |  |  | 11 | BW |  |  |  | 15 | 290
 |  | 12 | 185 |  |  |  | 9 | BW |  |  |  | 15 | 290
 | Hanging Leg Raise/Decline Situps | 15 | BW |  |  | Skulls | 12 | 0 |  |  | Hanging Leg Raise/Decline Situps | 10 | BW
 |  | 15 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 15 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 15 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
 |  | 15 | BW |  |  |  | 12 | 0 |  |  |  | 10 | BW
Spreadsheet: 695632d1600318048-data-from-different-sheet-populating-into-summary-sheet-when-new-sheets-are-created-example1
Sheet: Summary

Childs Name | Childs Date of Birth | [NAME] |  |  | Childrent list |  | Child code - not name of child
 |  |  |  |  |  |  | Make sure every new sheet would follow this list order
Spreadsheet: 0c0709b1-8c74-4603-bfd0-f37719ac4f67
Sheet: Sheet1

Public School Support Personnel By Employment Status For IUs 2009-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Personnel Count | Employment Status
Intermediate Units | Full-Time | Part-Time | Total
Allegheny IU 3 | 271 | 10 | 281
Appalachia IU 8 | 206 | 2 | 208
ARIN IU 28 | 89 | 26 | 115
Beaver Valley IU 27 | 67 | 0 | 67
Berks County IU 14 | 464 | 422 | 886
Blast IU 17 | 64 | 13 | 77
Bucks County IU 22 | 640 | 236 | 876
Capital Area IU 15 | 195 | 19 | 214
Carbon-Lehigh IU 21 | 418 | 75 | 493
Central IU 10 | 61 | 4 | 65
Central Susquehanna IU 16 | 447 | 58 | 505
Chester County IU 24 | 591 | 83 | 674
Colonial IU 20 | 504 | 107 | 611
Delaware County IU 25 | 408 | 109 | 517
Intermediate Unit 1 | 266 | 28 | 294
Lancaster-Lebanon IU 13 | 541 | 162 | 703
Lincoln IU 12 | 786 | 269 | 1055
Luzerne IU 18 | 100 | 9 | 109
Midwestern IU 4 | 228 | 8 | 236
Montgomery County IU 23 | 186 | 5 | 191
Northeastern Educational IU 19 | 153 | 11 | 164
Northwest Tri-County IU 5 | 103 | 27 | 130
Riverview IU 6 | 66 | 27 | 93
Schuylkill IU 29 | 117 | 101 | 218
[NAME] 9 | 73 | 19 | 92
[NAME] | 54 | 9 | 63
Westmoreland IU 7 | 170 | 0 | 170
Total | 7268 | 1839 | 9107
Spreadsheet: 761719d1641176297-dynamic-dropdown-in-excel-dnamic-dropdown_upd
Sheet: CoCo

YEAR | MONTH | PARTNAME | SRCCoCo | TARGCoCo | ERP
2021 | Oct | IF1222_FM | 620662_2025 | LB_017F | BH |  |  |  |  |  |  |  | [NAME]
2021 | Oct | IF1222_FM | 370251_9001 | LB_9008 | BH
2021 | Oct | IF1222_FM | CHIADJ_9001 | LB_9008 | BH
2021 | Oct | [NAME] | CL044 | [NAME] | [NAME]
2021 | Oct | [NAME] | HSR02 | LB_T005 | [NAME]
2021 | Oct | 1C_LB_U005_FM | PR_OG00000153 | LB_U654 | 1C
2021 | Oct | 1C_LB_U125_FM | T810 | LB_T810 | 1C
2021 | Oct | 1C_LB_U005_FM | FSB_1 | LB_U317 | 1C
2021 | Oct | MC_SAP_FM | 6211 | LB_6210 | DS
2021 | Oct | [NAME] | 5500 | LB_5500 | DS
2021 | Oct | MC_SAP_FM | 6210 | LB_6210 | DS
2021 | Oct | [NAME] | 3000 | LB_3000 | DS
2021 | Oct | [NAME] | 215740_2505 | LB_1625 | BH
2021 | Oct | [NAME] | 520848_9001 | LB_9008 | BH
2021 | Oct | [NAME] | 89901000_1030 | LB_1030 | BH
2021 | Oct | PASCAL_ES_FM | LB_LH05 | LB_LH05 | Pascal
2021 | Oct | DTS_100173_FM | ADNUS | LB_T005 | [NAME]
2021 | Oct | DTS_100173_FM | OGI42 | LB_H002 | [NAME]
2021 | Oct | DTS_100173_FM | XXX88 | LB_H002 | [NAME]
2021 | Oct | DTS_100173_FM | N83 | LB_H002 | [NAME]
2021 | Oct | DTS_100173_FM | GHS1 | LB_H002 | [NAME]
2021 | Oct | MC_SAP_FM | 6070 | LB_607X | DS
2021 | Oct | MC_SAP_FM | 5024 | LB_502X | DS
2021 | Oct | MC_SAP_FM | 5260 | LB_5260 | DS
2021 | Oct | [NAME] | 7140 | LB_7140 | DS
2021 | Oct | MC_SAP_FM | 6047 | LB_6040 | DS
2021 | Oct | [NAME] | 5040 | LB_5040 | DS
2021 | Oct | [NAME] | 6080 | LB_6080 | DS
Spreadsheet: 788256d1658351806-trying-to-use-vlookup-to-pull-data-from-one-workbook-to-another-excelforumhelp-1-
Sheet: Sheet1

 | Entity | Invoice | Payment Type | Payment Account | Payment Reference | Payment Date | Property Expense Acct | Original Amount | Amount Paid | Subtotals per Vendor | Invoice | Purpose | Date Incurred | Proof of Payment | Reference Draw #:
 | 100 Eleventh Avenue Condo | 7611-110917 | Check | 779630AP | 613 | 2017-11-27 00:00:00 | C177-000-00-12 |  |  |  | Y | Neet to understand purpose - filming construction site? | 2017-10-30 00:00:00 |  | 36
 | 76 Eleventh Funding, LLC | 2 | Electronic | 779630AP | W30217-2 | 2017-03-02 00:00:00 | C177-000-00-12 |  | 3829 |  | N | Is this an intercompany funding account or truly an expense?  If an expense, we need invoices and an understanding of the purpose
 | 76 Eleventh Funding, LLC |  | Electronic | 779630AP | [NAME] | 2017-05-04 00:00:00 | C177-000-00-12 |  | 21000 |  | N
 | 76 Eleventh Funding, LLC |  | Electronic | 779630AP | WT217-2 | 2017-03-02 00:00:00 | C177-000-00-12 |  | 938418.15 |  | N
 | 76 Eleventh Funding, LLC |  | Electronic | 779630AP | WT5417 | 2017-05-04 00:00:00 | C177-000-00-12 |  | -21000 |  | N
 | 76 Eleventh Funding, LLC |  | Electronic | 779630AP | WT5417 | 2017-05-04 00:00:00 | C177-000-00-12 |  | -942247.15 |  | N
 | 76 Eleventh Funding, LLC |  | Electronic | 779630AP | [NAME] | 2017-05-04 00:00:00 | C177-000-00-12 |  | 117002.94 |  | N
Spreadsheet: 808173d1670335946-multiple-replace-of-partial-texts-sample
Sheet: Sample

Input | Output |  | Replace | WITH
XX FIAT | AA FIAT |  | XX | AA
XX GM | [NAME] |  | YY | BB
[NAME] | [NAME] |  | ZZ | CC
YY FIAT | BB FIAT
YY GM | BB GM
YY HONDA | [NAME]
FIAT ZZ | FIAT CC
GM ZZ | GM CC
HONDA ZZ | HONDA CC
Spreadsheet: 161931d1339675048-auto-sort-when-measure-changes-copy-of-book1
Sheet: Sheet4

 |  |  | I2 |  |  | <-----Select from Dropdown
 |  | Benchmark:
 |  | Best Value
 |  | Benchmark
 |  | Superior:
 |  | Improved:
 |  | Conformance:
 |  | Non Conformance:
 |  | data type:
 |  | In Year: 2012
Hide them |  |  | All Companies | Non Conformance |  | 3 | Down | ▼
 |  | Rank | Centre | Assessment |  | Value | Trend
 | 1 | 1 | Company 4 | Superior |  | 94 | Up | ▲
 | 2 | 1 | Company 14 | Superior |  | 94 | Up | ▲
 | 3 | 3 | Company 11 | Superior |  | 91 | Up | ▲
 | 4 | 4 | Company 15 | Superior |  | 89 | Up | ▲
 | 5 | 5 | Company 30 | Superior |  | 85 | Up | ▲
 | 6 | 6 | Company 16 | Superior |  | 81 | Up | ▲
 | 7 | 7 | Company 2 | Superior |  | 80 | Down | ▼
 | 8 | 8 | Company 25 | Superior |  | 79 | Up | ▲
 | 9 | 9 | Company 8 | Superior |  | 78 | Up | ▲
 | 10 | 10 | Company 13 | Improved |  | 71 | Down | ▼
 | 11 | 11 | Company 10 | Improved |  | 64 | Up | ▲
 | 12 | 12 | Company 23 | Improved |  | 62 | No Change | ►
 | 13 | 13 | Company 32 | Improved |  | 59 | Up | ▲
 | 14 | 14 | Company 1 | Improved |  | 51 | Down | ▼
 | 15 | 14 | Company 18 | Improved |  | 51 | Up | ▲
 | 16 | 16 | Company 27 | Improved |  | 50 | Up | ▲
 | 17 | 17 | Company 26 | Conformance |  | 46 | Down | ▼
 | 18 | 18 | Company 28 | Conformance |  | 45 | Up | ▲
 | 19 | 19 | Company 21 | Conformance |  | 43 | Down | ▼
 | 20 | 20 | Company 5 | Conformance |  | 41 | Down | ▼
 | 21 | 21 | Company 9 | Conformance |  | 38 | Down | ▼
 | 22 | 21 | Company 29 | Conformance |  | 38 | Up | ▲
 | 23 | 23 | Company 24 | Conformance |  | 36 | Down | ▼
 | 24 | 24 | Company 19 | Conformance |  | 33 | Down | ▼
 | 25 | 25 | Company 22 | Conformance |  | 32 | Down | ▼
 | 26 | 26 | Company 7 | Conformance |  | 31 | Down | ▼
 | 27 | 27 | Company 6 | Conformance |  | 29 | Down | ▼
 | 28 | 28 | Company 31 | Conformance |  | 25 | Down | ▼
 | 29 | 29 | Company 3 | Non Conformance |  | 17 | Down | ▼
 | 30 | 29 | Company 17 | Non Conformance |  | 17 | Down | ▼
 | 31 | 31 | Company 12 | Non Conformance |  | 15 | Down | ▼
 | 32 | 32 | Company 20 | Non Conformance |  | 7 | Down | ▼
Spreadsheet: 861190d1709137019-taking-weekly-data-and-converting-to-monthly-formula-query-2
Sheet: Weekly Forecast

 | Opening Cash |  | Cash Flow Summary - Weekly
 | 3573315.55
 | Minimum Cash Balance
 | 100000
 | Week ending |  | 2023-09-03 00:00:00 | 2023-09-10 00:00:00 | 2023-09-17 00:00:00 | 2023-09-24 00:00:00 | 2023-10-01 00:00:00 | 2023-10-08 00:00:00 | 2023-10-15 00:00:00 | 2023-10-22 00:00:00 | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | 2023-11-12 00:00:00 | 2023-11-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Cash balance at beginning of week
 | Helper
 | Cash Receipts
 | Deposit
 | Reg Fees
 | Advanced Fees
 | Sales Ledger
 | Donation
 | Commercial Activities
 | Trips
 | Commem
 | Investment Income
 | Childcare
 | Intercompany
 | Total Cash Receipts
 | Cash paid out
 | Council Tax
 | Bank Charges
 | Travel
 | TV
 | Management Fees
 | IT
 | Phone
 | Lease
 | Marketing
 | Subscription
 | Adhoc
 | VAT
 | Cleaning Contract
 | Purchase Ledger
 | Insurance
 | Credit Card
 | Loan
 | Water Rates
 | Energy
 | Gas
 | Pension
 | Payroll
 | INLAND
 | Capital Projects
 | Catering
 | Total Cash Paid Out
 | Cash balance at end of week
Spreadsheet: 107547d1304684931-text-format-date-book1_bengtla
Sheet: Sheet1

Mar 30, 1998 2:58:06 PM | 1998-03-30 00:00:00 |  | 1998-03-30 00:00:00
Mar 30, 1998 2:58:06 PM | 1998-03-30 00:00:00 |  | 1998-03-30 00:00:00
[NAME] 2:58:06 PM | 1998-03-01 00:00:00 |  | 1998-03-01 00:00:00
May 14, 2004 3:23:31 PM | 2004-05-14 00:00:00 |  | 2004-05-14 00:00:00
Nov 4, 2009 10:09:54 AM | 2009-11-04 00:00:00 |  | 2009-11-04 00:00:00
Feb 20, 1998 1:46:00 PM | 1998-02-20 00:00:00 |  | 1998-02-20 00:00:00
Feb  20,  1998   1:46:00 PM | 2019-02-02 00:00:00 |  | 1998-02-20 00:00:00
Feb 20, 1998 1:46:00 PM | 1998-02-20 00:00:00 |  | 1998-02-20 00:00:00
Feb 20, 1998 1:46:00 PM | 1998-02-20 00:00:00 |  | 1998-02-20 00:00:00
Spreadsheet: 161042d1339381414-comparing-two-columns-from-separate-worksheets-alcharbonneau_solution
Sheet: Sheet2

Header
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | #N/A
Spreadsheet: 22520d1211462490-name-boxes-catg2
Sheet: Catg

Catg 1 | Catg 2 |  | Lists
Fruits | Apple |  |  |  | Fruits | Vegetables | Colors
 |  |  | Fruits |  | Apple | Potato | Pink
 |  |  | Vegetables |  | [NAME] | Pea | Blue
 |  |  | Colors |  | Pear | Carrot | Red
Spreadsheet: 39799d1238078758-copy-select-rows-on-2-sheets-to-a-3rd-sheet-book1
Sheet: FEB

Description | Date | Amount | Category
Chase | 2009-02-01 00:00:00 | 500 | mortgage
Kroger | 2009-02-12 00:00:00 | 75 | grocery
Shell | 2009-02-13 00:00:00 | 50 | gasoline
Racetrac | 2009-02-27 00:00:00 | 30 | gasoline
Spreadsheet: 880394d1728056134-drop-down-list-small-problem-categories-kawola223-
Sheet: Arkusz1

works well (I select a category and then the appropriate product) |  |  |  |  |  |  |  |  | I have a problem here
 |  |  |  |  |  |  |  |  |  |  | Cat | Product | Status
Cat1 |  | Cat1 | Product 1 cat1 |  | Drop down list 1 : | Cat1 |  |  | Cat1 |  | Cat1 | Product 1 cat1 | 0 |  | Choose1 : | Cat4
Cat2 |  | Cat1 | Product 2 cat1 |  | Drop down list 2: | Product 1 cat4 |  |  | Cat2 |  | Cat1 | Product 2 cat1 | 1 |  | Choose2: | Product 2 cat4 | <-- | after selecting the category above I want to display only those products (from the selected category) with status 1 and I don't know how to do it
Cat3 |  | Cat1 | Product 3 cat1 |  |  |  |  |  | Cat3 |  | Cat1 | Product 3 cat1 | 0
Cat4 |  | Cat1 | Product 4 cat1 |  |  |  |  |  | Cat4 |  | Cat1 | Product 4 cat1 | 0
 |  | Cat2 | Product 1 cat2 |  |  |  |  |  |  |  | Cat2 | Product 1 cat2 | 1 |  | Cat1 | Product 2 cat1
 |  | Cat2 | Product 2 cat2 |  |  |  |  |  |  |  | Cat2 | Product 2 cat2 | 1 |  | Cat2 | Product 1 cat2
 |  | Cat2 | Product 3 cat2 |  |  |  |  |  |  |  | Cat2 | Product 3 cat2 | 1 |  | Cat3 | Product 2 cat3
 |  | Cat2 | Product 4 cat2 |  |  |  |  |  |  |  | Cat2 | Product 4 cat2 | 1 |  | Cat4 | Product 3 cat4
 |  | Cat2 | Product 5 cat2 |  |  |  |  |  |  |  | Cat2 | Product 5 cat2 | 0
 |  | Cat2 | Product 6 cat2 |  |  |  |  |  |  |  | Cat2 | Product 6 cat2 | 0
 |  | Cat2 | Product 7 cat2 |  |  |  |  |  |  |  | Cat2 | Product 7 cat2 | 0
 |  | Cat3 | Product 1 cat3 |  |  |  |  |  |  |  | Cat3 | Product 1 cat3 | 1
 |  | Cat3 | Product 2 cat3 |  |  |  |  |  |  |  | Cat3 | Product 2 cat3 | 1
 |  | Cat3 | Product 3 cat3 |  |  |  |  |  |  |  | Cat3 | Product 3 cat3 | 1
 |  | Cat3 | Product 4 cat3 |  |  |  |  |  |  |  | Cat3 | Product 4 cat3 | 1
 |  | Cat3 | Product 5 cat3 |  |  |  |  |  |  |  | Cat3 | Product 5 cat3 | 0
 |  | Cat3 | Product 6 cat3 |  |  |  |  |  |  |  | Cat3 | Product 6 cat3 | 0
 |  | Cat3 | Product 7 cat3 |  |  |  |  |  |  |  | Cat3 | Product 7 cat3 | 0
 |  | Cat3 | Product 8 cat3 |  |  |  |  |  |  |  | Cat3 | Product 8 cat3 | 0
 |  | Cat4 | Product 1 cat4 |  |  |  |  |  |  |  | Cat4 | Product 1 cat4 | 1
 |  | Cat4 | Product 2 cat4 |  |  |  |  |  |  |  | Cat4 | Product 2 cat4 | 1
 |  | Cat4 | Product 3 cat4 |  |  |  |  |  |  |  | Cat4 | Product 3 cat4 | 1
 |  | Cat4 | Product 4 cat4 |  |  |  |  |  |  |  | Cat4 | Product 4 cat4 | 0
 |  | Cat4 | Product 5 cat4 |  |  |  |  |  |  |  | Cat4 | Product 5 cat4 | 0
Spreadsheet: 38996d1237221793-lookup-reference-help-large
Sheet: Sheet1

2009-05-01 00:00:00 | 2009-04-01 00:00:00 | 2009-03-01 00:00:00 | 2009-02-01 00:00:00 | 2009-01-01 00:00:00
100 | 125 | 150 | 135 | 95 |  | 150
95 | 150 | 124 | 124 | 75 |  | 150
90 | 175 | 98 | 113 | 55 |  | 175
200 | 200 | 200 | 102 | 35 |  | 200
80 | 225 | 46 | 91 | 15 |  | 225
75 | 250 | 20 | 80 | -5 |  | 250
70 | 275 | 275 | 69 | -25 |  | 275
65 | 300 | -32 | 58 | -45 |  | 300
Spreadsheet: 62818d1263830707-hide-rows-depending-on-data-but-merge-other-data-test-2-
Sheet: Pivot

Row Labels
Esp Ltd
[NAME] 120VAN 1000KG
GU58LHD
CARRY OUT 20,000 SERVICE 219.9
CARRY OUT NEXT SERVICE
Mr A J [NAME]
Peugeot 207 5Dr HAT 1.6 HDi 90
GP57BMO
CARRY OUT 12,000 MILE SERVICE
CUSTOMER WAITING 11.30AM
Mr Cox
PEUGEOT 107
LB56PNN
CARRY OUT 30.000 SERVICE
CUSTOMER WAITING 9.30AM
MOT TEST
Oil top up - Mobil 10W40.
Mr [NAME]
Peugeot 106 QS
D16WRH
CUSTOMER WAITING 3.00
MOT TEST AT REDUCED RATE
OSR TYRE ROTAION INCORRECT,
Mr I Aitken
Peugeot 407 5Dr SW 2.0 HDi 136
GP54PYA
[NAME]
MOT TEST
Mr K Bull
207 5Dr HAT 1.4 75 M:play
GU08HBL
ADVISE CAR MAY BE DROPPED OFF
INVESTIGATE INTERMITTANTLY WHE
Mr N Humphrey
206 Quicksilver
GV53UJA
Investigate knocking noise fro
Mr R Smith
Peugeot 407 2.0D
HK55UJF
CUSTOMER WAITING 10.30AM
MOT TEST
Mr [NAME]
Peugeot 307 S Estate
CK52NDD
CUSTOMER WAITING 09.00AM
REPLACE WORN ALTERNATOR BELT
[NAME]
207 SW SPT HDI 90
GY59ULN
[NAME] Peugeot First Servic
CUSTOMER WAITING 3.00PM
[NAME]
PEUGEOT 307
GX05CWJ
CUSTOMER WAITING 3:30
Investigate rear bulb out.
Investigate washers don't work
Mrs J [NAME]
206
HK55ZNT
Carry out level 3 'P' Service
COLLECTION AND DELIVERY
MOT TEST
Oil top up - Mobil 10W40.
Mrs J King
Peugeot 206 LX 1.4 5 Dr
[NAME]
Carry out level 1 'P' Service
COLLECTION AND DELIVERY FROM H
MOT TEST
Oil top up - Mobil 10W40.
[NAME]
Peugeot 307S 1.6 16V Tiptronic
KW07DZC
ADVISE ***********************
CUSTOMER WAITING 10.00AM
Hire car at reduced rate
INVESTIGATE VERY STICKY CHANGI
Notes - Old job card m
Oil top up - Mobil 10W40.
[NAME]
PEUGEOT 206 SW PETROL INPORT N
GX54BYT
ADVISE ***********************
Carry out level 1 'P' Service
CUSTOMER WAITING 11:00
Oil top up - Mobil 10W40.
Mrs N Morris
107 Urban Semi-Auto
GP06UNB
Carry out level 3 'P' Service
COLLECTION AND DELIVERY
Grand Total
Spreadsheet: 823024d1679656383-retrieving-value-from-adjacent-table-based-on-value-within-table-eflookup
Sheet: Sheet1

Airline | To | Sched. |  |  | Airline | To | To2 | First Flight | Last Flight
American Airlines | Doha | 11:00:00 |  |  |  | Doha | West Palm Beach, FL | 11:00:00 | 14:00:00
American Airlines | [NAME] | 11:10:00
American Airlines | Miami, FL | 11:15:00
American Airlines | Indianapolis, IN | 11:15:00
American Airlines | London | 11:20:00
American Airlines | Columbus, OH | 12:00:00
American Airlines | Cleveland, OH | 12:00:00
American Airlines | Boston, MA | 12:05:00
American Airlines | Worcester, [NAME] | 12:10:00
American Airlines | Boston, MA | 12:10:00
American Airlines | Norfolk, VA | 12:20:00
American Airlines | Jacksonville, FL | 12:20:00
American Airlines | Salt Lake City, UT | 12:27:00
American Airlines | Orlando, FL | 12:30:00
American Airlines | Miami, FL | 12:37:00
American Airlines | West Palm Beach, FL | 12:40:00
American Airlines | [NAME] | 12:41:00
American Airlines | Boston, MA | 13:05:00
American Airlines | Orlando, FL | 13:14:00
American Airlines | Boston, MA | 13:20:00
American Airlines | Tampa, FL | 13:28:00
American Airlines | Syracuse, NY | 13:30:00
American Airlines | San Francisco, CA | 13:30:00
American Airlines | Miami, FL | 13:40:00
American Airlines | Atlanta, GA | 13:40:00
American Airlines | Burlington, VT | 13:44:00
American Airlines | Buffalo, NY | 13:44:00
American Airlines | San Antonio, TX | 13:45:00
American Airlines | Tokyo | 13:45:00
American Airlines | Phoenix, AZ | 13:55:00
American Airlines | West Palm Beach, FL | 14:00:00
Spreadsheet: 62592d1263502218-value-ranges-book2
Sheet: Sheet1

 | enter number
 | 444 | 218.18 | VLOOKUP
 |  | 218.18 | INDEX + MATCH |  |  | 0 | 356
 |  | 218.18 | LOOKUP |  |  | 56 | 245.45
 |  | 218.18 | INDEX + COUNTIF |  |  | 276 | 218.18
 |  |  |  |  |  | 1101 | 190.9
 |  |  |  |  |  | 2201 | 163.63
Spreadsheet: 841915d1694034175-cumulative-fica-calculation-using-a-threshold-of-current-fica-cap-fica-formula
Sheet: Sheet1

 |  | H | I | J | K | L | M | N | O | P | Q | R | S
 | 19 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333 | 27583.33333333333
 | 20
 |  | H20
 |  | =+MIN(H19,167700)*0.062
 |  | I20-S20
 |  | =+MIN(SUM($H19:[NAME]:I19),167700)*6.2%
 |  | ROW 19 IS MONTHLY SALARY
 |  | ROW 20 IS FICA TAX ON MONTH;LY SALARY
 |  | FICA SALARY CAP IS $167,700
 |  | WHEN SALARY CAP IS REACHED IT SHOULD SHOW ZERO FICA AS WELL AS ANY PARTIAL FICA UP TO THE $167,700 THRESHOLD
 |  | I CANNOT ADD ADDITIONAL ROWS TO SHOW CUMULATIVE SALARY SO THE FORMULA NEEDS TO BE WRITTEN FROM ROW 19 ONLY
Spreadsheet: 870163d1716723649-is-there-a-way-to-simplify-this-formula-excel-help-with-formulas-
Sheet: Results

Week Commencing | Contract | Contract % | Days Worked | Days Lost | Daily Average m3 | Reasons for Days Lost | Reasons for Days Lost | Contract Profit | Profit per Machine | Daily Average Profit | Contract Notes
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Week Number |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
 |  |  |  | 0 | 0 | N/A | N/A | 0 | 0 | 0
Spreadsheet: bac34afd-cb44-43cc-8cea-3b88ee899bca
Sheet: Sheet1

[NAME] neve: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  |  | Ezer Ft
 | Előző               ……………… év | A hitelkérelem benyújtásának éve | …………..év | …………..év | …………..év
PÉNZBEVÉTELEK
Igényelt mikrohitel felvét
Saját tõke betét vagy [NAME]
[NAME] nettó pénz bevételei
Egyéb pénz bevételek
Vissza nem térítendő támogatás
[NAME]
Értékesítésre felszámított ÁFA
ÁFA visszaigénylés
Bevételek összesen | 0 | 0 | 0 | 0 | 0
PÉNZ KIADÁSOK
Beruházás (eszközbeszerzés)
Anyag v. áru [NAME]
[NAME] kiadások
Bérek és fizetések
Bérek és fizetések [NAME]
[NAME] jellegû kifizetések
Mûködési, üzemeltetési kiadások
Bank-, kamat költség
Egyéb hitel tõketörlesztés (élő hitel)
Egyéb hitel kamat befizetése (élő hitel)
[NAME] kifizetések
[NAME] adó
[NAME] felszámított ([NAME], levonható) ÁFA
Költségvetésbe befizetendõ ÁFA
Társasági adó / SZJA fizetés
Fizetendõ osztalék, részesedés
Kiadások összesen | 0 | 0 | 0 | 0 | 0
PÉNZESZKÖZ TÖBBLET / HIÁNY | 0 | 0 | 0 | 0 | 0
MIKROHITEL ADÓSSÁGSZOLGÁLAT
Mikrohitel tõketörlesztés
Mkrohitel kamatfizetések
[NAME] | 0 | 0 | 0 | 0 | 0
EGYENLEG | 0 | 0 | 0 | 0 | 0
Spreadsheet: robin_rodrigue__33215__IMCan_Gas_Bench
Sheet: GRMS Detail

EFF_DT | [NAME] | BENCHMARK_ID | BOOK_ID | BOOK_TYPE_CD | [NAME] | [NAME] | TO_DATE(TO_CHAR(REF_DT,'MM-YYYY'),'MM-YYYY') | [NAME]) | Benchmark Position | Benchmark Conversion | [NAME] | PV in CE | Benchmark in CE | Risk Type | REPORTING REGION | DATE BUCKET | DATE BUCKET | DATE BUCKET | DATE BUCKET | DATE BUCKET | [NAME] | 12 Month Key | Price [NAME] | [NAME]
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-GDL | M | G | [NAME] | 2000-07-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-GDL | M | G | NG | 2000-08-01 00:00:00 | -4207200
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-GDL | M | G | NGMR-AECO/C | 2000-07-01 00:00:00 | 3527053
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PHY | M | P | GDP-HEHUB | 2000-08-01 00:00:00 | 120000
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PHY | M | P | GDP-NTHWST/CANB | 2000-08-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PHY | M | P | IF-NTHWST/CANBR | 2000-08-01 00:00:00 | -276518
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PHY | M | P | NG | 2000-08-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PRC | P |  | GDP-CHI.GATE | 2000-08-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PRC | P |  | GDP-ELPO/SANJUA | 2000-12-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PRC | P |  | GDP-MALIN-CTYGA | 2000-11-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PRC | P |  | GDP-NTHWST/CANB | 2000-08-01 00:00:00 | 0
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PRC | P |  | IF-NWPL-ROCK/CA | 2000-10-01 00:00:00 | 155000
2000-07-18 00:00:00 | POS-GAS-TRD | NG-NYMEX | IMCAN-ERMS-XL-PRC | P |  | STATION2/US$ | 2000-08-01 00:00:00 | -218782
Spreadsheet: 878273d1725351313-formula-to-extract-information-book1
Sheet: Data Page

City | Code
Sydney | HOM1
Sydney | HOM2
Sydney | HOM3
Sydney | HOM4
Paris | MHG1
Paris | MHG2
Paris | [NAME]
Paris | MHG4
Delhi | NUG1
Delhi | NUG2
Delhi | NUG3
Spreadsheet: 453950d1459533090-help-with-functions-for-a-novice-excel-user-sales-brackets
Sheet: Data

 |  |  |  |  |  |  |  |  | Some other number |  | Sales Amount | Stars
Spreadsheet: 163026d1340165488-automatic-addition-of-numbers-help-sevendaypay
Sheet: Sheet1

Date | Amt
 |  |  | <<Simply select all the yellow cells and double click the lower right corner of C8