tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115db11d-64e9-4090-9735-993affb9ff7f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 38. LEASE FINANCE COMMITMENTS, By Purpose: State (ACT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1 . . . [NAME] ; |  |  | Original | A2413863F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413864J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413865K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413866L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413868T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413869V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413870C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413871F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413872J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413873K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413874L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413875R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413876T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413877V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413878W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 853373d1703245431-group-by-id-and-sort-by-highest-first-and-export-thebest-from-each-group-christest
Sheet: Sheet2

ID
Spreadsheet: 717854d1612881966-vlookup-to-look-up-value-based-on-accoun-number-use-vlookup-with-match-for-period
Sheet: Sheet1

6213100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3/2021
6213110
6213115
6213120
6213200
6213210
6213290
6213300
6213801
6213310
6213315
6213350
6213352
6213359
6213400
6213975
6213410
6213415
6213420
Spreadsheet: 143276d1330345777-looking-up-multiple-variables-in-a-table-and-giving-the-results-disc-calc
Sheet: Sheet1

 | Base Discount |  |  |  | Incumbent |  |  |  | DR sub 1,000 |  |  |  | DR over 1,000
 | P | G | S | R | P | G | S | R | P | G | S | R | P | G | S | R
0 | 0.3 | 0.25 | 0.2 | 0.15
1-24% | 0.3 | 0.25 | 0.2 | 0.15
25%-34% | 0.3 | 0.25 | 0.2 | 0.15
35%-44% | 0.25 | 0.2 | 0.15 | 0.15
45%-64% | 0.2 | 0.15 | 0.1 | 0.1
65%-84% | 0.15 | 0.1 | 0.05 | 0.05
 | Pricing Type | DR sub 1,000
 | Partner Status | R
 | Discount Level | 35%-44%
 | Discount Levels |  | Pricing Type
 | [NAME] |  | (blank) |  |  | (blank)
 | 1-24% |  | Base |  |  | R
 | 25%-34% |  | Incumbent |  |  | S
 | 35%-44% |  | DR sub 1,000 |  |  | G
 | 45%-64% |  | DR over 1,000 |  |  | P
 | 65%-84%
Spreadsheet: 868927d1715628291-generate-list-based-on-multiple-criteria-one-of-which-is-to-lookup-within-a-table-example5
Sheet: Mapping

 | TITLE
 | ADVANCED PRACTICE REGISTERED NURSE | NP
 | CERTIFIED PHYSICIAN ASSISTANT | PA
 | MEDICAL DIRECTOR | MD
 | ADVANCED REGISTERED NURSE PRACTITIONER | NP
 | NURSE PRACTITIONER | NP
 | PHYSICIAN | MD
 | [NAME] | [NAME]
 | REGIONAL NURSE PRACTITIONER | NP
 | REGIONAL MEDICAL DIRECTOR | MD
 | MD | MD
 | ON CALL PHYSICIAN ASSISTANT | PA
 | ARNP | NP
 | PA | PA
 | REGIONAL NP | NP
 | PHYSICIAN ASSISTANT | PA
 | MEDICAL ASSISTANT | NP
 | LEAD NURSE PRACTITIONER | NP
 | FLOAT NURSE PRACTITIONER | NP
 | LICENSED CLINICAL SOCIAL WORKER | [NAME]
 | NURSE PRACTITIONERS | NP
 | ON CALL NP | NP
 | ON CALL NURSE PRACTITIONER | NP
 | SCRIBE | NP
 | CERTIFIED PHYSICAN ASSISTANT | PA
 | ADVANCED REGISTERED NURSE PRACTIONER | NP
 | ADVANCED PRACTISED REGISTERED NURSE | NP
 | NURSE PRACTIONER | NP
Spreadsheet: 695091d1600044681-need-help-to-insert-a-value-after-multiple-occurrences-of-a-value-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Tq
 |  |  |  |  |  |  | DA
 |  |  |  |  |  |  | WA
 |  |  |  |  |  |  | CH
 |  |  |  |  |  |  | CH | <-- enter value of 1 here as "CH" above equals "CH" above that
 |  |  |  |  |  |  | KA
 |  |  |  |  |  |  | BA
 |  |  |  |  |  |  | ST
 |  |  |  |  |  |  | NW
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | NY | <-- enter value of 1 as "NY" above equals "NY" above that and also "NY" above that
 |  |  |  |  |  |  | CA
 |  |  |  |  |  |  | NO
 |  |  |  |  |  |  | GN
 |  |  |  |  |  |  | OA
 |  |  |  |  |  |  | BU
 |  |  |  |  |  |  | IN
 |  |  |  |  |  | 2009.4.14 | CI
 |  |  |  |  |  | 2009.5.1 | CI | <--- nothing should appear here as the numbers in G20 and G19 are different
 |  |  |  |  |  | 2009.5.1 | CI | <-- enter value of 1 as "NY" above equals "NY" above that and also "NY" above that AND number is G21 equals number in G20 but not number in G19
 |  |  |  |  |  |  | TE
 |  |  |  |  |  |  | AR
 |  |  |  |  |  |  | PH
 |  |  |  |  |  |  | AT
 |  |  |  |  |  |  | AT | <-- enter value of 1 as "AT" above equals "AT" above that
 |  |  |  |  |  |  | MI
 |  |  |  |  |  |  | NY
 |  |  |  |  |  |  | TA
 |  |  |  |  |  |  | TA | <-- enter value of 1 as "TA" above equals "TA" above that
 |  |  |  |  |  |  | DE
 |  |  |  |  |  |  | SE
 |  |  |  |  |  |  | JA
 |  |  |  |  |  |  | JA | <-- enter value of 1 as "JA" above equals "JA" above that
 |  |  |  |  |  |  | SF
 |  |  |  |  |  |  | SF | <-- enter value of 1 as "SF" above equals "SF" above that
 |  |  |  |  |  |  | CL
 |  |  |  |  |  |  | CL | <-- enter value of 1 as "CL" above equals "CL" above that
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI
 |  |  |  |  |  |  | PI | <-- enter value of 1 as "PI" above equals "PI" above that and also "PI" above that
Spreadsheet: 692913d1598630799-recommending-gross-profit-and-amount-project-costing-model
Sheet: Sheet1

Line Item | UOM | Qty | Cost | Total | Reference | Comments
Materials | Each | 1 | 20000 |  | Please list part number(s) | Total BOM cost.
Materials (out of spec) | Each | 1 | 2250 |  | Please list part number(s)
Build Labour | Hour | 100 | 40 |  |  | Includes picking, build, calibration, testing and packing.
Documentation / Project Management | Hour | 150 | 40 |  |  | Info taken from Project Timesheets (T:\Drawings).
Intertek Approval | Each | 1 | 2500
3rd Party FAT approval | Each | 1 | 1000
Equipment | Each | 1 | 50 |  |  | Any specialist equipment purchased.
Transit / Delivery | Each | 1 | 1000
Commissioning costs | Each | 1 | 1000
Agent Commission | Each | 1 | 1000
 |  |  | TOTAL:
 |  |  | SELL PRICE: | 50000
 |  |  | GP MARGIN:
 |  |  | GP MARGIN %
 |  |  | TARGET GP %
 |  |  | GP MATERIALS ONLY MARGIN:
 |  |  | GP MATERIALS ONLY MARGIN %
Spreadsheet: 214782d1361120757-look-up-in-a-range-based-on-value-entered-and-the-get-the-value-and-the-header-samplelookup
Sheet: Sheet1

 |  |  | india | japan | china | russia | usa |  |  | 1995
 |  | 1992 |  | 42
 |  | 1993 | 23
 |  | 1994 |  |  | 16
 |  | 1995 |  |  |  | 20
 |  | 1996 |  |  |  |  | 28
 |  | 1997 | 14
 |  | 1998 |  |  | 44
 |  | 1999 |  | 15
 |  | 2000 |  |  |  | 55
 |  | 2001 | 12
 |  | 2002 |  |  |  |  | 98
 |  | 2003 |  | 67
 |  | 2004 |  |  |  |  | 67
 |  | 2005 |  |  | 12
Spreadsheet: jonathan_mckay__16915__SMED - Buy
Sheet: Enron Direct Deal Sheet

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | ECC |  |  |  |  | Deal Date: |  |  |  |  |  |  | 3 | March
Originator: | [NAME] |  |  |  |  | Deal ID #: |  |  |  |  |  |  | 4 | April
 | SMED |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-11-01 00:00:00 |  |  |  |  | Unit of Measure: |  | GJ |  |  |  |  | 6 | June
Deal End Date: | 2002-10-31 00:00:00 |  |  |  |  | Volume (Monthly/Daily): |  | Monthly |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  |  | Price: |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  |  | Buy/Sell: |  | Buy |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Rate 11 Fuel | Rate 13 Fuel | Rate 11 Total |  | Rate 13 Total
 | January |  | 20561
 | February |  | 14732
 | March |  | 15987
 | April |  | 13745
 | May |  | 8875
 | June |  | 5802
 | July |  | 4656
 | August |  | 4738
 | September |  | 9274
 | October |  | 10858
 | November |  | 17394
 | December |  | 19515
 | TOTAL:
Spreadsheet: 825605d1681414981-excel-formula-for-overtime-after-40-hours-per-week-excel-help
Sheet: Sheet1

Reload
Employee | Unit | Date | Rate | Hours worked | Reg hours | OT after 40 Hours | OT Wages | Wages
WEEK 1
Lana | RELOAD | 2023-03-27 00:00:00 | 21 | 12
Lana | RELOAD | 2023-03-28 00:00:00 | 21 | 12
Lana | RELOAD | 2023-03-29 00:00:00 | 21 | 12
Lana | RELOAD | 2023-03-30 00:00:00 | 21 | 12
Lana | RELOAD | 2023-03-31 00:00:00 | 21 | 12
WEEK 2
Lana | RELOAD | 2023-04-03 00:00:00 | 21 | 12
Lana | RELOAD | 2023-04-04 00:00:00 | 21 | 12
Lana | RELOAD | 2023-04-05 00:00:00 | 21 | 12
Lana | RELOAD | 2023-04-06 00:00:00 | 21 | 12
Lana | RELOAD | 2023-04-07 00:00:00 | 21 | 12
Lana |  | Totals |  |  | ?? | ??
 |  |  |  |  | Above s/b 80 | Above s/b 40
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: summary

TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES |  |  |  |  |  | index
 |  |  |  |  |  | SJ
Positive=due [NAME] |  | Negative = due operator |  |  |  | AVG
 |  |  |  |  |  | NTXPH
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
[NAME] |  |  |  | Volumetric | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME] | [NAME] and Maljamar
SoCal |  |  |  | Volumetric | [NAME]
EPFS / PG&E TX |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
NNG |  |  |  | Dollar Valued | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
Amoco |  |  |  | Volumetric | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Hansford
Lonestar |  |  |  | Volumetric | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
El Paso |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
TransColorado |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | balance is cashed out monthly
[NAME] |  |  |  | Dollar Valued | [NAME] | cashed out monthly
Receivable imbalances
Operator | Dollars | Volume | Date | Imbal Type | MS rep | Comments
Citizens Communications |  |  |  | Dollar Valued | [NAME]
North Star Steel |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Continental |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: stacey_white__39183__DPR and Recon
Sheet: Recon

Reconciliation of Form A to DPR
 |  | As of 11/30/01
Total MTM per Form A: |  | 809377276
Reconciling Items:
East Schedule C | -91388134
West Schedule C | -325347096
East Schedule B (Asian Option) | -732655
Negotiated Third Party Deals
Killed Cross Commodity Deals | -6182178
Transactions with EES, Inc. | 176664336
Total Reconciling Items:
Total Reconciled Form A MTM:
Other
Total MTM per DPR: |  | 619096604.5300207
Spreadsheet: 835331d1688502926-index-small-failed-to-replicate-example-index-small-forumexcel
Sheet: Sheet2

 | Movie | [NAME] | Actor | Release |  | INDEX-SMALL |  |  | INDEX-AGGREGATE
 | Prisoners | Thriller | [NAME] | 2013 |  | [NAME] | Action |  | [NAME] | Action
 | The [NAME] | Mystery | Christian Bale | 2006 |  | Actor | [NAME] |  | Actor | [NAME]
 | Logan | Action | [NAME] | 2017 |  | Movie |  |  | Movie
 | The Dark Knight | Action | Christian Bale | 2008
 | Inception | Action | [NAME] | 2010
 | Public Enemies | Action | [NAME] | 2009
 | The Machinist | Thriller | Christian Bale | 2004
 | The Tourist | Action | [NAME] | 2010
 | Catch Me If You Can | Thriller | [NAME] | 2002
 | The Wolverine | Action | [NAME] | 2013
 | Shutter Island | Thriller | [NAME] | 2010
 | Secret Window | Thriller | [NAME] | 2004
 | Real Steel | Action | [NAME] | 2011
 | The Dark Knight Rises | Thriller | Christian Bale | 2012
 | The Ninth Gate | Thriller | [NAME] | 1999
 | The Departed | Thriller | [NAME] | 2006
Spreadsheet: 05a62d02-e6c7-41c7-85d2-2fe9f9d8647b
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
 | 6345.0 Labour Price Index, Australia
 | Total Hourly Rates of Pay Excluding Bonuses: Public Sector by State, Original (Financial Year Index Numbers for year ended June quarter)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248268T | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Victoria ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248345K | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Queensland ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248422C | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  South Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248499A | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Western Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248576V | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Tasmania ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248653L | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Northern Territory ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248730F | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australian Capital Territory ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248807T | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
Financial Year Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  All industries ;  Public ;  All occupations ; |  |  | Original | A2248200W | 1998-06-01 00:00:00 | 2009-06-01 00:00:00 | 12 | Index Numbers | INDEX | Annual | 6
© Commonwealth of Australia  2009
Spreadsheet: 683063d1592471238-reference-problem-test2
Sheet: Assumptions

 |  |  | 0.4 | 0.3 | 0.3 | 0.27 | 0.4 | 0.4 | 0.27
 | # | Prcs | ΧΑΑ | [NAME] | ΠΑΡΑΓΩΓΑ | [NAME] | ΚΥΠΡΟΣ | Αμ. ΔΙΑΧ | Ομόλογα  πρωτογενή  αγορα
 | 1 | ΔΗΛΟ |  |  |  |  |  |  |  |  |  |  |  | $A$2:INDEX($A:$A,COUNTA($A:$A))
 |  | ΟΕΤΕ
 |  | ΤΑΜ.
 |  | 2330
 |  | 2350
 |  | 2400
 |  | 2420
 |  | ΙΝΕΤ
 |  | 3120
 |  | 3940
 |  | ΚΟΙΝΟ
 |  | [NAME]
 |  | 2402
 |  | 2422
 |  | ΔΡRΒ
 |  | ΚΟΙΝΟ2
 |  | 4300
 |  | VΙRΤUΟUS
 |  | 139Α
 |  | [NAME]
 |  | [NAME]
 |  | ΙΟLCΕΣ1
 |  | FΕLLΑSG
 |  | GΜΤRΑDΕ
 |  | GΜΤRΑDΕ2
 |  | JΚΤRΑDΕ
 |  | ΖΒΤRΑDΕ
 |  | ΡΕCUΝΙΑS
 |  | ΧΑRΑΧ
 |  | ΧΑRΑΧ2
 |  | 2331
 |  | 2401
 |  | 2421
 |  | 3121
 |  | 3941
 |  | ΚΟΙΝΟ1
 |  | ΕΧ1
 |  | ΕΠΡΑ
 |  | ΕΝDCLΙΕΝΤS
 |  | 101Ξ
 |  | [NAME]
 |  | ΣΕΛΑ
 |  | ΚΟΡΠ
 |  | ΟΤΕ SΟΡ
 |  | 2332
 |  | 2352
 |  | 4100
 |  | ΕFSW
 |  | GΑΜΜ
 |  | GΜΤRΑDΕ1
 |  | SΚGΤRΑDΕ
 |  | ΧΑRΑΧ1
 |  | ΧΑRΑΧ3
 |  | 2351
 |  | 9991
Spreadsheet: 175142d1345420099-referencing-a-different-workbook-updated-w-workbooks-book2-of-2-for-vlookup
Sheet: Sheet1

DCPI | UNIT BALANCE:
7802 | 500
7803 | 1000
7804 | 1500
7805 | 100
7806 | 0
7807 | 1500
1234 | 826.666666666667
1235 | 843.809523809524
1236 | 860.952380952381
1237 | 878.095238095238
1238 | 895.238095238095
8163 | 912.380952380953
8164 | 929.52380952381
8165 | 946.666666666667
8166 | 963.809523809524
8167 | 980.952380952381
8168 | 998.095238095238
8169 | 1015.2380952381
8170 | 1032.38095238095
8171 | 1049.52380952381
8172 | 1066.66666666667
8173 | 1083.80952380952
8174 | 1100.95238095238
Spreadsheet: 67772d1268307082-excel-fuction-help-required-in-attendance-sheet-721159_nonstopleo
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | CL | A | L | Dates when employee is not present are required
Furqan | P | A | cl | P | CL | P | 2 | 1 | 0 | 2 | 3 | 5
[NAME] | P | L | P | A | P | L | 0 | 1 | 2 | 2 | 4 | 6
Anser | A | P | P | A | A | L | 0 | 3 | 1 | 1 | 4 | 5 | 6
Zeeshan | P | P | A | P | L | P | 0 | 1 | 1 | 3 | 5
[NAME] | P | L | A | P | L | P | 0 | 1 | 2 | 2 | 3 | 5
[NAME] | A | P | P | A | P | L | 0 | 2 | 1 | 1 | 4 | 6
Arslan | A | P | L | P | A | P | 0 | 2 | 1 | 1 | 3 | 5
Spreadsheet: 27605d1220986434-counting-cells-in-a-row-that-are-less-than-0-test
Sheet: BSBS_RMBS_Survey

0.00253033778764476 | 0.009472847687011012 | 0.00418014521237841 | -0.01576786013789736 | -0.02599827482217104 | -0.02640106922451961 | -0.007238844493756304 | -0.005158710184943629 | 0.009034406170268194 | -0.001130542001571156 | -0.006469868218163338 | -0.006864449322897575 | 0.01226160656568775 | 0.03011866035128448 | 0.03336443647086001 | 5
-0.005121239340913197 | -0.002372449317468906 | -0.002117779000007074 | -0.001513217137930241 | 0.016275496289513 | 0.01160048224529739 | 0.009184348846602842 | 0.01038161664892803 | 0.006698296514278822 | 0.004868059283725444 | 0.004195927917519274 | 0.0006735040632066998 | -0.002282442090020951 | 0.002437684175255293 | 0.01412346823886841 | 4
0.0126408740481108 | 0.01592330473734043 | 0.01666128221088077 | 0.01776050171592318 | 0.03639039722061309 | 0.03211219594485099 | 0.03012911556876856 | 0.03182771487956775 | 0.02853483851141098 | 0.02713727939410769 | 0.02692840184538555 | 0.02379661594634229 | 0.02123528257935493 | 0.02652567703324019 | 0.03895047160453396 | 0
Spreadsheet: 38574d1236724037-semi-random-name-placement-example1
Sheet: Sheet1

Names | Local | Remote
[NAME] | [NAME] | [NAME]
[NAME] | Jessica | [NAME]
[NAME]
[NAME]
[NAME]
 | Total per week |  | 2 | 3 |  | 2 | 3 |  | 2 | 3 |  | 1 | 2
 | Needed | week1 | Local | Remote | week2 | Local | Remote | week3 | Local | Remote | week4 | Local | Remote
[NAME] | 5
[NAME] | 5
[NAME] | 3
[NAME] | 3
[NAME] | 2
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: May - Inv

 | Month | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
 | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day
Child's Name | Parent's Name | Address
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 759517d1639584252-sum-column-based-on-values-in-2-other-columns-audits-master
Sheet: DC 21 Audits Master

[NAME] | Errors | Cases |  |  |  | [NAME] | Cases without errors
[NAME] |  | 144 |  |  |  | [NAME]
[NAME] | 1 | 182 |  |  |  | [NAME]
Luc | 1 | 187 |  |  |  | Luc
[NAME] |  | 265 |  |  |  | [NAME]
[NAME] |  | 226 |  |  |  | Brae
Brae |  | 241 |  |  |  | [NAME]
[NAME] |  | 90 |  |  |  | [NAME]
[NAME] | 1 | 150 |  |  |  | Ry
[NAME] | 0 | 100 |  |  |  | [NAME]
[NAME] | 0 | 80 |  |  |  | Will
Ry | 0 | 60 |  |  |  | Jo
[NAME] | 1 | 40 |  |  |  | [NAME]
Will | 1 | 880 |  |  |  | [NAME]
Will |  | 100 |  |  |  | [NAME]
Jo | 1 | 220 |  |  |  | JR
[NAME] | 0 | 233
[NAME] | 1 | 80
[NAME] | 1 | 232
[NAME] | 1 | 234
Will |  | 259
JR |  | 191
Ry |  | 191
Spreadsheet: 51625d1251273925-variable-commission-rates-commission-structures-complex-vs-simple-tiers-
Sheet: Sheet1

Commission Structure - No Salary or Benefits
 | [NAME] | [NAME] | Differential
Tier 1 Commissions | 0 | 0.15 | 0.15 |  | COMPLEX
Tier 2 Commissions | 80001 | 0.2 | 0.05000000000000002 |  | The complex tier pays the commission/percentage based
Tier 3 Commissions | 150001 | 0.22 | 0.01999999999999999 |  | on each tier range, so the first portion is always paid at the
Tier 4 Commissions | 400001 | 0.25 | 0.03 |  | first tier, the second portion at the second tier, etc. Then the
Tier 5 Commissions | 750001 | 0.3 | 0.04999999999999999 |  | tiered payment values are added.
 |  |  |  |  | This structure always pays MORE than "Simple" if the differential
 |  |  |  |  | values are decreasing, always pays LESS than "Simple"
 | Sales | [NAME] | Basic Tier |  | if the differential values are increasing.
Sales Person 1 | 33000 | 4950 | 4950
[NAME] | 135000 | 22999.95 | 27000 |  | SIMPLE
[NAME] 3 | 190000 | 34799.93000000001 | 41800 |  | The simple tier takes the grand total and applies the appropriate
[NAME] | 425000 | 87249.90000000001 | 106250 |  | percentage for that amount to the entire total.
Sales Person 5 | 1000000 | 243499.85 | 300000
Sales Person 6 |  | 0 | 0 |  | This structure always pays MORE than "Complex" if the differential
[NAME] |  | 0 | 0 |  | values are increasing, always pays LESS than "Complex"
[NAME] 8 |  | 0 | 0 |  | if the differential values are dencreasing.