tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 802239d1666716002-lookup-cell-value-on-different-sheet-cash-flow-analysis
Sheet: 546 Maple

 | Rental Property Cash Flow Analysis
 | 546 Maple Ave. Miamisburg, OH 45342
 | 320 Glenside Zillow Link
 | Monthly Operating Income | Bank Loan | [NAME] | Cash
 | Number of Units | 2 | 2 | 2
 | Average Monthly Rent per Unit | 800 | 800 | 800
 | Total Rental Income
 | % Vacancy and Credit Losses | 0 | 0 | 0
 | Total Vacancy Loss
 | Other Monthly Income (laundry, vending, parking, etc.) | 0 | 0 | 0
 | Gross Monthly Operating Income
 | Monthly Operating Expenses
 | Property Management Fees | 0 | 0 | 0
 | Repairs and Maintenance
 | Real Estate Taxes | 217 | 217 | 217
 | Rental Property Insurance
 | Homeowners/Property Association Fees | 0 | 0 | 0
 | Replacement Reserve | 50 | 50 | 50
 | Utilities | 0 | 0 | 0
 | - Water and Sewer
 | - Gas and Electricity
 | - Garbage
 | - Cable, Phone, Internet
 | Pest Control | 0 | 0 | 0
 | Accounting and Legal |  | 100 | 100
 | Advertising
 | Monthly Operating Expenses
 | Net Operating Income (NOI)
 | Total Annual Operating Income
 | Total Annual Operating Expense
 | Annual Net Operating Income
 | Capitalization Rate and Valuation
 | Desired Capitalization Rate | 0.08 | 0.08 | 0.08
 | Property Valuation (Offer Price)
 | Actual Purchase Price |  | 219999 | 219999
 | Actual Capitalization Rate
 | Loan Information
 | Down Payment
 | Loan Amount |  |  | 0
 | Acquisition Costs and Loan Fees
 | Length of Mortgage (years) | 30 | 30 | 0
 | Annual Interest Rate | 0.08 | 0.05 | 0
 | Initial Investment
 | Monthly Mortgage Payment (PI)
 | Annual Interest
 | Annual Principal
 | Total Annual Debt Service
 | Cash Flow and ROI
 | Total Monthly Cash Flow (before taxes)
 | Total Annual Cash Flow (before taxes)
 | Cash on Cash Return (ROI)
 | Note: This spreadsheet should only be used for informational and educational purposes. Please verify
 | calculations and seek professional assistance before making financial decisions.
Spreadsheet: 249617d1373562530-grouping-of-record-data-arranging-4-
Sheet: EXCEPTED RESULT

No | Name | P_NAME | ELTN | GROUP Name (expected) | formula result | T/F
786003444 | ANSHIP PR | DANI PING | OTR | HIPP PR
786003444 | ANSHIP PR | LIYAKA | SIGN | HIPP PR
786003444 | ANSHIP PR | RAVATIN | SIGN | HIPP PR
786003444 | ANSHIP PR | SAIKUM | RECT | HIPP PR
786003444 | ANSHIP PR | SEVANTVORA | OTR | HIPP PR
786003444 | ANSHIP PR | SHADO SAD | SIGN | HIPP PR
786003444 | ANSHIP PR | SHAPAN | SIGN | HIPP PR
786003444 | ANSHIP PR | UMENOD BHAI | SIGN | HIPP PR
786003443 | HIPP PR | DANI PING | OTR | HIPP PR
786003443 | HIPP PR | LIYAKA | SIGN | HIPP PR
786003443 | HIPP PR | RAVATIN | SIGN | HIPP PR
786003443 | HIPP PR | SAIKUM | RECT | HIPP PR
786003443 | HIPP PR | SEVANTVORA | OTR | HIPP PR
786003443 | HIPP PR | SHADO SAD | SIGN | HIPP PR
786003443 | HIPP PR | SHAPAN | SIGN | HIPP PR
786003443 | HIPP PR | UMENOD BHAI | SIGN | HIPP PR
786002707 | DIGY LOW PR | GRAW HESH | RECT | BAGABRO  PR
786002707 | DIGY LOW PR | RAWA INIT | HOLD | BAGABRO  PR
786002491 | ARC MALABS PR | AMATH | RECT | REGAHA PR
786002491 | ARC MALABS PR | [NAME] | BENO | REGAHA PR
786002491 | ARC MALABS PR | DIN MARA | RECT | REGAHA PR
786002491 | ARC MALABS PR | MAJA JA | RECT | REGAHA PR
786002491 | ARC MALABS PR | RAKAUMAR IMA | RECT | REGAHA PR
786002440 | BAGABRO  PR | GAYA BRO PLE | BENO | BAGABRO  PR
786002440 | BAGABRO  PR | GRAW HESH | RECT | BAGABRO  PR
786002440 | BAGABRO  PR | OMI BAGAD | RECT | BAGABRO  PR
786002440 | BAGABRO  PR | RAWAL MAR | RECT | BAGABRO  PR
786001674 | REGAHA PR | AEON GANIC | BENO | REGAHA PR
786001674 | REGAHA PR | AMATH | RECT | REGAHA PR
786001674 | REGAHA PR | MAJA JA | RECT | REGAHA PR
786001674 | REGAHA PR | MANAN ARAYA | RECT | REGAHA PR
Spreadsheet: 529891d1501058086-statutory-redundancy-pay-out-uk-statutory-redundancy-payout
Sheet: Sheet1

Hi All,
I have a spreadsheet containing over 2000 rows of data. I need to calculate UK statutory redundancy pay based on following rules.
The current rules state the maximum that can be paid caps out at 20 years’ service and a [NAME] payout of £14,670 (£15,000 for Northern Ireland).
The weekly pay is capped at £489 per week (for Northern Ireland its £500 per week)
The rules also count on following age basis:
0.5 weeks’ pay for each full year of service when under age 22
1.0 weeks’ pay for each full year of service between age 22 – 41
1.5 weeks’ pay for each full year of service from age 41 or older
In addition to above we should count full years so if someone has 3.5 years’ service, only 3 years should be count. There is no rounding up.
Could someone help please?
I tried to attach spreadsheet but for some reason it wouldn't work for me. I will try again but I have pasted below the table that I am looking to use
Name Age Annual Pay Stat Weekly Rate Redundancy Effective Date Redundancy Payment
O 57 22260 428 31/12/2016
P 61 22382 430 31/12/2016
Q 54 22740 437 31/12/2016
R 52 23090 444 31/12/2016
S 57 23304 448 31/12/2016
T 38 29740 572 31/12/2016
When you copy and paste above data into spreadsheet it will appear in columns. I know its not ideal to paste data here I am unable to my spreadsheet.
Thanks for your help.
[NAME]
Spreadsheet: 137222d1327004468-calculation-based-on-cell-colour-change-orders-sheet-example_reply2
Sheet: Stock Received

STYLE | STYLE NO | COLOR | XS_28 | S_30 | M_32 | L_34 | [NAME] | XXL_38 | TOTAL
UCPJ | ANDERSON-130 | BLUE ASTER | 10 | 10 | 10 | 10 | 10 | 10
UCPJ | ANDERSON-130 | Peacoat | 10 | 10 | 10 | 10 | 10 | 10
UCHZ | BURTON-981 | Peacoat | 10 | 10 | 10 | 10 | 10 | 10
UCHZ | COLIN-885 | WATERFALL | 10 | 10 | 10 | 10 | 10 | 10
UCHZ | COLIN-885 | White | 10 | 10 | 10 | 10 | 10 | 10
UCJK | RANDEL-950 | RUDE WINE | 10 | 10 | 10 | 10 | 10 | 10
UCJK | RANDEL-950 | TWILIGHT BLUE | 10 | 10 | 10 | 10 | 10 | 10
UCJK | STEPHENS-937 | BLACK | 10 | 10 | 10 | 10 | 10 | 10
UCJK | STEPHENS-937 | BLUE ASTER | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 890097d1741272319-return-values-in-array-that-fit-within-multiple-ranges-sample-data
Sheet: Sheet1

 | Well Yield (gpm) | 2000
 | Minimum Well Yield (gpm) | Maximum Well Yield (gpm) | [NAME] of [NAME] (in) | Optimum Size of Well Casing (in) | Smallest Size of Well Casing (in)
 | 0 | 100 | 4 | 6 | 5
 | 75 | 175 | 5 | 8 | 6
 | 150 | 350 | 6 | 10 | 8
 | 300 | 700 | 8 | 12 | 10
 | 500 | 1000 | 10 | 14 | 12
 | 800 | 1800 | 12 | 16 | 14
 | 1200 | 3000 | 14 | 20 | 16
 | 2000 | 3800 | 16 | 24 | 20
 | 3000 | 6000 | 20 | 30 | 24
 |  | [NAME] | Expected Values
 | Smallest Size of Well Casing (in) |  | 16
 | Optimum Size of Well Casing (in) |  | 24
Spreadsheet: 1045fb04-de3d-40d2-954a-1785ae435e12
Sheet: DropDown Lists

Sem1 |  | [NAME] |  |  | OChem 1 |  |  |  | Notes |  | Sem2 |  | Objective
AP |  | Identify Linear Algebra Course |  |  | WHICH? |  |  |  | [W] |  | ? |  | ?
Tr |  | [NAME]: Math 0280 |  |  | 0310 |  |  |  | [G] |  | F 09 |  | Industry
F 09 |  | [NAME]: Math 1180 |  |  | 0730 |  |  |  | [I] |  | Spr 10 |  | Grad School
Spr 10 |  | [NAME] Math 1185 |  |  |  |  |  |  | [R] |  | F 10 |  | Med School
Sum 10 |  |  |  |  | Human Phys |  |  |  | [R/F] |  | Spr 11 |  | Law School
F 10 |  | DiffEqn |  |  | Identify Human Phys Course |  |  |  | [R/D-] |  | F 11 |  | Business School
Spr 11 |  | Identify Diff Eqn Course |  |  | BioSc 1250 |  |  |  | [R/D] |  | Spr 12 |  | Government
Sum 11 |  | [NAME]: Math 0290 |  |  | NroSci 1250 |  |  |  | [R/D+] |  | F 12 |  | Other
F 11 |  | [NAME]: Math 1270 |  |  | BioSc 1070 |  |  |  | [R/C-] |  | Spr 13
Spr 12 |  |  |  |  | NroSci 1070 |  |  |  | [F] |  | F 13 |  | Identify Concentration
Sum 12 |  | Phys 1 |  |  | Nur 0012 |  |  |  | [D-] |  | Spr 14 |  | BioMechanics
F 12 |  | Identify Phys 1 Course |  |  |  |  |  |  | [D] |  | F 14 |  | BioSignals & Imaging
Spr 13 |  | Phys 0174 |  |  | Stats |  |  |  | [D+] |  | Spr 15 |  | Cellular Engineering
Sum 13 |  | Phys 0475 |  |  | Identify Statistics Course |  |  |  | [C-] |  | F 15 |  | Medical Device Engineering
F 13 |  |  |  |  | Stats: Engr 0020 |  |  |  |  |  | Spr 16
Spr 14 |  | Phys 2 |  |  | Stats: Stat 1000 |  |  |  |  |  | F 16
Sum 14 |  | Identify Phys 2 Course |  |  |  |  |  |  |  |  | Spr 17 |  | Req : BioEng 1631 & (1632 or 1633)
F 14 |  | Phys 0175 |  |  | Fresh 1 |  |  |  |  |  | F 17 |  | Req : Open - suggestions on conc web page
Spr 15 |  | Phys 0476 |  |  | Identify Fresh Engr 1 Course |  |  |  |  |  | Spr 18 |  | Req : Chem 0320 & (BioSc 1000, BioSc 1810 or Chem 1810)
Sum 15 |  |  |  |  | Engr 0011 |  |  |  |  |  | F 18 |  | Req : (MEMS 0024 or IE 1051) & (IE 1039, BUSERV 1985 or BUSMKT 1431)
F 15 |  | Chem 1 |  |  | [NAME] |  |  |  |  |  | Spr 19
Spr 16 |  | Identify Chem 1 Course |  |  | Engr 0015 |  |  |  |  |  |  |  | Identify Imaging Course
Sum 16 |  | Chem 0110 |  |  |  |  |  |  |  |  |  |  | BioEng 1005
F 16 |  | Chem 0410 |  |  | Fresh 2 |  |  |  |  |  |  |  | BioEng 1330
Spr 17 |  | Chem 0710 |  |  | Identify Fresh Engr 2 Course |  |  |  |  |  |  |  | BioEng 1383
Sum 17 |  | Chem 0760 |  |  | Engr 0012 |  |  |  |  |  |  |  | BioEng 2505
F 17 |  | Chem 0960 |  |  | Engr 0712 |  |  |  |  |  |  |  | BioEng 2630
Spr 18 |  |  |  |  | Engr 0715 |  |  |  |  |  |  |  | PSY 1471
Sum 18 |  | Chem 2 |  |  | Engr 0016 |  |  |  |  |  |  |  | CMU BioSc 03-315
F 18 |  | Identify Chem 2 Course |  |  |  |  |  |  |  |  |  |  | CMU BioSc 03-534
Spr 19 |  | Chem 0120 |  |  |  |  |  |  |  |  |  |  | CMU Biomed 42-431
Sum 19 |  | Chem 0420 |  |  |  |  |  |  |  |  |  |  | CMU Biomed 42-640
 |  | Chem 0720 |  |  |  |  |  |  |  |  |  |  | CMU Psych 85-429
 |  | Chem 0770
 |  | Chem 0970
Spreadsheet: susan_pereira__39448__ENRON
Sheet: ENRON

 | VARIBUS CORPORATION |  |  |  |  |  |  |  | FEBRUARY 28, 1999 |  |  |  |  |  |  | {SERVICES}PSNU~QAGQ
 | P.O. BOX 61000
 | NEW ORLEANS, LA 70161 |  |  |  |  |  | INVOICE NUMBER |  |  |  |  | 99-02-04
 | PH# (504)576-4152
 | IN ACCOUNT WITH
 | ENRON CAPITAL & TRADE RESOURCE CORP. |  |  |  |  |  |  |  | AMOUNT
 | Attn: ALICIA JONES
 | 1400 SMITH, SUITE 3722A
 | Houston, Texas 77002
 |  |  |  |  |  | PER
MMBTU'S |  |  | [NAME] |  |  | MMBTU |  |  |  |  |  | AMOUNT
23534 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 706.02
 |  |  | GSU at [NAME] in
 |  |  | Jan 1999
 |  |  | (Via  LRC )
742000 |  |  | Natural Gas Transported to |  |  | 0.03 |  |  |  |  |  | 22260
 |  |  | GSU at [NAME] in
 |  |  | Jan 1999
 |  |  | (Via  TETCO )
 |  |  | Contact Person
 |  |  | Accounting Question
 |  |  | [NAME]Ph# (504)576-4152
 |  |  | Operational Questions
 |  |  | [NAME] Ph# (281)297-3553
 |  |  |  | TOTAL AMOUNT DUE
 | PLEASE REMIT TO:
 | VARIBUS
 | P.O. BOX 61000
 | NEW  ORLEANS, LA.   70161
 | Attn: [NAME]
Spreadsheet: 264b650c-ef43-4b03-ad6a-567153a7645f
Sheet: Table1_AsProbeSets

Additional File 5: Genes with enriched transcription factor binding sites
[NAME] | [NAME] | Transcription Factor(s) Predicted to Regulate Gene | Transcription Factor(s) TRANSFAC Accession Number
CHAD | chondroadherin | Sp1, ZF5 | [NAME], M00716
DR1 | down-regulator of transcription 1, TBP-binding (negative cofactor 2) | E2F | M00803
[NAME] | [NAME] homolog 1 (Drosophila) | Sp1, ZF5 | [NAME], M00716
G3BP2 | GTPase activating protein (SH3 domain) binding protein 2 | E2F | M00803
HSD17B8 | hydroxysteroid (17-beta) dehydrogenase 8 | Sp1 | [NAME]
KRT16 | keratin 16 | Sp1 | [NAME]
[NAME] | low density lipoprotein receptor-related protein 11 | [NAME] | M01111
METTL1 | methyltransferase like 1 | E2F | M00803
NRG4 | [NAME] 4 | Oct-1 | M00138
PGRMC1 | progesterone receptor membrane component 1 | E2F | M00803
ST3GAL1 | ST3 beta-galactoside alpha-2,3-sialyltransferase 1 | Sp1, ZF5 | [NAME], M00716
[NAME] | tubulointerstitial nephritis antigen-like 1 | Sp1, ZF5 | [NAME], M00716
TMSB10 | thymosin beta 10 | E2F | M00803
Spreadsheet: b91cba6f-609f-43f5-bdd8-71f3e2dbfa5d
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 14998303524 | Bingo | Hog Life | 2005-07-12 | Compact Disc | Black Gospel | 13.99 | Y | Available
Spreadsheet: 746665d1630941495-calculate-number-of-nights-excel-forum-number-of-nights
Sheet: Number of Nights (2)

Calculate the number of nights correctly while identifying different nights on previous dates
 |  | Raw Data |  |  |  |  |  |  |  | [NAME]
 |  | [NAME] | Departure Date | Name | Location | Type | House or Hotel | # of Rooms | Rooms | No. of nights
 | 1 | 2022-08-20 00:00:00 | 2022-08-22 00:00:00 | House | New York | NewHome | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 4 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00 | House | Philadephia | PhiliHouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 5 | 2022-08-24 00:00:00 | 2022-08-25 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 6 | 2022-08-25 00:00:00 | 2022-08-26 00:00:00 | Hotel Awesomesauce | Baltimore | Hotel Awesomesauce | Hotel | 1 | Zimmerkategorie: 2x Classic Doppelzimmer Breakfast
 | 7 | 2022-08-26 00:00:00 | 2022-08-27 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 9 | 2022-08-28 00:00:00 | 2022-08-29 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 11 | 2022-08-30 00:00:00 | 2022-08-31 00:00:00 | House | Baltimore | Baltimouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 12 | 2022-08-31 00:00:00 | 2022-09-01 00:00:00 | House | Baltimore | [NAME] | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 14 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | House | Washington | DCPlaza | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 15 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | House | Philadephia | HeatHouse | House | 1 | Roomcategory: 2x [NAME] with Breakfast
 | 16 | 2022-09-04 00:00:00 | 2022-09-08 00:00:00 | House | New York |  | House
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
Spreadsheet: 35228d1232758195-automatic-adding-and-subtraction-entire-rows-excelforumautoupdate
Sheet: Promotions

ID | PromoCode | PromoDate | PromoDetails | [NAME] | RedeemedToday | RedeemedDate | Notes | Cost OfProduct | ProfitPerOffer | PromoName
1 | a1 | 2008-06-09 00:00:00 | hi there | 10 | 3 | 39629 |  | 300 | 200 | one
2 | a2 | 2008-06-03 00:00:00 | aloha | 300 |  | 39626 |  | 150 | 10 | two
3 | a3 | 2008-07-02 00:00:00 | [NAME] | 10 | 1 |  |  | 0.5 | 4.5 | three
4 | a4 | 2008-07-02 00:00:00 | ert | 100 | 1 |  |  | 110 | 50 | four
5 | test | 2008-07-24 00:00:00 | asd | 2 | 1 | 39653 | asda | 5 | 1 | test
6 | asdas | 2008-07-24 00:00:00 |  | 5 |  |  |  |  |  | asdda
7 |  |  |  | 5
Spreadsheet: 867060d1713960871-power-query-extract-data-from-worksheet-sample-1-
Sheet: Query

No | Type / Category | Description  (as per LM, LP or other equipment certification where available) | Make & Model | Serial No | Equipment ID | Hirer  Company (Trade Partner / Vendor) | Owner of Equipment | Date first mobilized | Last Date on site | Current Status | Statutory Registration No. (LM, LP, AR, etc) | Certification [NAME] | Inspection / Serviving Frequency | Last Inspection / Servicing Date | Next Inspection / Servicing Due Date | PIC | Remarks | Source Table
1 | MEWP - Scissor Lift | LP - 979447N | DINGLI JCPT0708DCS | SL-0882 | GP210915-29 | [NAME] | Galmon | 44649 |  | Active (In Use) | LP - 979447N | 45520 | Monthly | 45383 | 45413 | Kalana |  | Schneider
2 | MEWP - Scissor Lift | LP - 979448V | DINGLI JCPT0708DCS | SL-0883 | GP210915-30 | [NAME] | Galmon | 44649 |  | Active (In Use) | LP - 979448V | 45527 | Monthly | 45383 | 45413 | Kalana |  | Schneider
3 | MEWP - Scissor Lift | LP - 949450P | DINGLI JCPT0708DCS | SL-0885 | GP210915-32 | [NAME] | Galmon | 44649 |  | Active (In Use) | LP - 949450P | 45557 | Monthly | 45383 | 45413 | Kalana |  | Schneider
4 | MEWP - Scissor Lift | LP - 995750L | DINGLI [NAME] | SL-0910 | GP220506-07 | [NAME] | Galmon | 44768 |  | Active (In Use) | LP - 995750L | 45516 | Monthly | 45383 | 45413 | Kalana |  | Schneider
5 | Tower Light - Diesel Powered | LP - 995751X | DINGLI [NAME] | SL-0911 | GP220506-08 | [NAME] | Galmon | 44768 |  | Active (In Use) | LP - 995751X | 45516 | Monthly | 45383 | 45413 | Kalana |  | Schneider
1 | MEWP - Scissor Lift | 803 Lifting Platform-Hydraulic Working Platform | [NAME] GS-1930 | GS30D-22493 | SL9485 | Tech Onshore MEP | TOM/Averasia | 44289 |  | Active (In Use) | LP802522A | 45383 | Monthly | 45383 | 45413 | Linesh |  | Tech
2 | MEWP - Scissor Lift | 803 Lifting Platform-Hydraulic Working Platform | [NAME] GS-1930 | 1930E-364 | SL1930 | Tech Onshore MEP | Nortek/TOM/Averasia | 45237 |  | Active (In Use) | LP1061748B | 45481 | Monthly | 45383 | 45413 | Linesh |  | Tech
3 | Air Compressor - Electric | TESTING ONLY | AMAX | A223313 | AR01 | Tech Onshore MEP | Nortek/TOM/ | 29/09/2022 |  | Active (In Use) | AR373337K | 30/01/2025 | Monthly | 45383 | 45413 | Linesh |  | Tech
1 | Excavator | Hydraulic Excavator With Load Radius Indicator | KOBELCO SK135SR & JAPAN | YY06-16894 | EX-022L | Plantwerkz Pte Ltd | Plantwerkz Pte Ltd |  |  | Active (In Use) | LM988177A | 45608 | Monthly | 45383 | 45413 | [NAME] |  | Plantwerkz
2 | Excavator | Hydraulic Excavator For Lifting | YANMAR ViO35-6B & JAPAN | 61134 | - | Plantwerkz Pte Ltd | Plantwerkz Pte Ltd |  |  | Active (In Use) | LM438228B | 45608 | Monthly | 45383 | 45413 | [NAME] |  | Plantwerkz
Spreadsheet: 061dc10a-db5c-4d21-a04c-6e1869578c41
Sheet: BL_SHORTFALL

[NAME] Customer Report |  |  |  |  |  |  |  |  |  |  | [NAME] Customer Report
BL_SHORTFALL_<customer id>_<invoicedate>00_<version>.CSV |  |  |  |  |  |  |  |  |  |  | BL_SHORTFALL_<customer id>_<invoicedate>00_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
ISO Charge Remittance Total (A) | UNSEC MMP Pool ISO Remittance Total (B) | UNSEC MMP Pool ISO Remittance Total Reduction (C) | UNSEC MMP ISO Remittance Total Reduction (D=(A/B)*C) | UNSEC NMMP Pool ISO Remittance Total (E) | UNSEC NMMP Pool ISO Remittance Total Reduction (F) | UNSEC NMMP ISO Remittance Total Reduction (G=(A/E)*F) | Pool ISO Remittance Total (H) | Pool ISO Remittance Total Reduction (I) | ISO Remittance Total Reduction (J=((A-(D+G))/H)*I) | Transmission Remittance Total (K) | UNSEC MMP Pool Transmission Remittance Total (L) | UNSEC MMP Pool Transmission Remittance Total Reduction (M) | UNSEC MMP Transmission Remittance Total Reduction (N=(K/L)*M) | UNSEC NMMP Pool Transmission Remittance Total (O) | UNSEC NMMP Pool Transmission Remittance Total Reduction (P) | UNSEC NMMP Transmission Remittance Total Reduction (Q=(K/O)*P) | Pool Transmission Remittance Total (R) | Pool Transmission Remittance Total Reduction (S) | Transmission Remittance Total Reduction (T=((K-(N+Q))/R)*S) | Remittance Total (U) | Pool Remittance Total (V) | Pool Excess Transmission Remittance Total Reduction (W) | Excess Transmission Remittance Total Reduction (X=(U/V)*W) | Total Remittance Reduction (Y=D+G+J+N+Q+T+X)
$ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $ | $
Spreadsheet: 162495d1339934542-separating-first-and-last-names-without-text-to-columns-name-splitter
Sheet: Sheet1

[NAME] dawson
[NAME]
russel dawson
russe dawson
russ dawson
russellina [NAME]
rus dawson
Spreadsheet: 25645d1217028148-creating-headers-within-a-date-range-test
Sheet: Sheet4

Start: | 2007-10-01 00:00:00 |  | Date:
End: | 2008-03-29 00:00:00 |  | Text:
 |  |  |  | Change the text format
 |  |  |  | Copy the formulas right
Spreadsheet: 774796d1648658847-lookup-multiple-values-for-same-critera-concat-results-lookup_help
Sheet: Sheet1

 | Data Set |  |  | Summary
 | Project | Product |  | Project | Needed Product(s)
 | Project Echo | Battery |  |  | Battery, [NAME]
 | Project Sierra | Motherboard |  | Project Sierra
 | Project Golf | Monitor |  | Project Golf | Monitor, CPU
 | [NAME] | Battery |  | [NAME]
 | Project Echo | Motherboard |  | Project Tango
 | Project Golf | CPU |  | Project Lima
 | Project Tango | Battery
 | Project Lima | CPU
Spreadsheet: 555171d1515466420-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: Tournament 6

 |  |  | Tournament 6
 |  |  |  |  |  |  | Player | Points | Low Score
 |  |  | Player | Score
 |  | x | x | x
Spreadsheet: 829525d1684293161-output-only-if-criteria-is-y-book2
Sheet: Worksheet

Show in Output report | Department | Position | Head Count
Y | Executive  Crew | Employee 1 | 1
Y | Executive  Crew | Employee 2 | 1
Y | Executive  Crew | Employee 3 | 1
Y | Executive  Crew | Employee 4 | 1
Y | Guest Service Crew Front Office | Employee 5 | 1
N | Guest Service Crew Front Office | Employee 6 | 1
N | Guest Service Crew Front Office | Employee 7 | 1
N | Executive  Crew | Employee 8 | 1
N | Guest Service Crew Culinary | Employee 9 | 1
Y | Guest Service Crew Culinary | Employee 10 | 1
Y | Guest Service Crew Culinary | Employee 11 | 1
Y | Guest Service Crew Culinary | Employee 12 | 1
OUTPUT
ONLY The above departments/positions with Y
Spreadsheet: 0b7fc49d-01c3-4804-a8b2-98ae9aae09e9
Sheet: Page 1

 | GMS Application Preparation Worksheet
First Choice College | First Choice College |  |  |  |  |  |  |  |  | Intended Major
Short -Term Goal | Short-Term Goal
Long-Term Goal | Long-Term Goal
 | Honors & Awards |  | 10 |  | 11 |  | 12 |  | Type* |  | Description of Award
 | Example:  Who's Who Among High School Students |  | 2010-06-05 00:00:00 |  |  |  |  |  | Academic |  | One of only 5% of the students from the nation's 24,000 high school who were honored.
 | Unpaid Work & Community Service (Organizaton Name) |  | Dates |  | # of Hours |  | Description of Activities
 | Paid Employment (Employer Name) |  | Dates |  | # of Hours |  | Position/Description of Activities
 | *Type = Academic, Athletic, Artistic, Community Service, Employment, Extracurricular, Other
Spreadsheet: 355860d1414815085-help-very-difficult-spreadsheet-calculations-and-filtering-pre-work
Sheet: Assignment 3

Assignment 3 - Responses to Unemployment Claims
When an employee leaves the company, they may file a claim for unemployment benefits with the State's Department of Labor (DOL).  Elegibility for benefits is determined by the DOL using claims information provided by the employee and employment/termination information from the former  employer.
Using the employee data sheet, complete the following  for HR's response to unemployment claims:
I. | Employee #: | 222-000
 | Date of Hire
 | Date of Termination
 | Job Title
 | Grade
 | Reason for Termination
 | Did this employee termination occur due to Voluntary or Involuntary reasons?
 | What other information would be of importance in responding to this claim and who would you want to interview for details about this termination?
II. | Employee #: | 109-155
 | Date of Hire
 | Date of Termination
 | Job Title
 | Grade
 | Reason for Termination
 | This employee was terminated for releasing phone calls.
 | What other information would be of importance in responding to this claim and who would you want to interview for details about this termination?
 | Based on the reason for termination, what company and/or department policies and codes would be useful in making our case to the DOL?
Spreadsheet: 885157d1734592135-help-with-dynamic-calendar_incorrect-event-text-color-dynamic-event-and-holiday-calendar-in-excel-test-2-jt-1-
Sheet: Holiday Calendar

 |  |  |  |  |  |  |  |  | April |  |  |  |  |  | 2025
 | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CF formula: =IsCurrentMonth=FALSE, applies to: =$[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CF formula: =TEXT(E7,"mmmm")<>Selected_Month, applies to: =$B$8:$AC$10,$B$12:$AC$14,$B$16:$AC$18,$B$20:$AC$22,$B$24:$AC$26,$B$28:$M$30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CF formula: =MATCH(B7,List!$J$3:$J$161,0)>0, applies to: =$[NAME]
 | Notes |  | :