tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 93437d1293021029-formula-needed-to-fetch-data-from-different-worksheets-and-include-adjacent-cells-copy-of-core-staff-leave-2010
Sheet: JT

JT
HOLIDAYS TAKEN |  |  |  |  | 3 DAY WORKING WEEK FOR THE PERIOD JAN.10 TO APR.10
2010
 |  |  |  |  | THEREFORE HOLIDAY ENTITLEMENT = |  |  |  |  | 5.6 WEEKS X 3 WORKING DAY WEEK / 12 MONTHS X 4 MONTHS |  |  |  |  |  |  |  | 5.5
 |  |  |  |  |  |  |  |  |  | 5.6 WEEKS X 5 WORKING DAY WEEK / 12 MONTHS X 8 MONTHS |  |  |  |  |  |  |  | 18.5
Friday | 1900-05-28 00:00:00 | JT
Friday | 1900-06-11 00:00:00 | JT
Friday | 1900-06-18 00:00:00 | JT
Monday | 1900-06-21 00:00:00 | JT
Tuesday | 1900-07-06 00:00:00 | JT
Friday | 1900-08-27 00:00:00 | JT
Tuesday | 1900-08-31 00:00:00 | JT
Thursday | 1900-10-14 00:00:00 | JT
Friday | 1900-10-15 00:00:00 | JT
Monday | 1900-10-18 00:00:00 | JT
Thursday | 1900-10-28 00:00:00 | JT | SICKNESS TAKEN AS HOLIDAY
Friday | 1900-10-29 00:00:00 | JT | SICKNESS TAKEN AS HOLIDAY
STATUTORY |  | 8
Spreadsheet: 881763d1729922063-how-to-select-data-in-chart-for-certain-columns-only-book2
Sheet: New PORT

S/N | Source | VALUE | Annualized Return | % of Portfolio | LT Interest % | Monthly Interest | Category | Region | Duration | Risk | Column1 | Column2
1 | A |  | 1.6 |  | 0.11 |  | Options | US | Long | High
 | Dividends | 29400 | 0.05 |  | 0.055 |  | Dividends | Germany | Long | Medium
2 | C |  |  |  |  |  | Options | US | Medium | High
3 | D |  | 2 |  | 0.1 |  | Crypto | US | Medium | V High
4 | OA | 54814 | 0.025 |  | 0.025 |  | CPF | Germany | Long | Zero
5 | SA | 266557 | 0.04 |  | 0.04 |  | CPF | Germany | Long | Zero
6 | MA | 71500 | 0.04 |  | 0.04 |  | CPF | Germany | Long | Zero
7 | H | 18077 | 0.018 |  | 0.018 |  | Cash | Germany | Immediate | Zero
9 | J | 47582 |  |  | 0.02 |  | Cash | Germany | Immediate | Zero
10 | K | 20184 | 0.04 |  | 0.0348 |  | Cash | Germany | Immediate | Zero
11 | SRS | 32018 | 0.1 |  | 0.08 |  | SRS | HK | Long | Medium
 | SRS |  | 0.0603 |  | 0.0587 |  | SRS | Germany | Long | Medium
12 | SRS | 32129 | 0.09 |  | 0.016 |  | SRS | World | Long | Low
13 | CPFOA | 47371 | 0.09 |  | 0.0094 |  | CPF | US | Long | Low
14 | CPFOA | 24743 | 0.09 |  | 0.016 |  | CPF | World | Long | Low
 | CPFOA | 303.5 | 0.09 |  | 0.016 |  | CPF | World | Long | Low
15 | R | 30000 | 0.03 |  | 0.03 |  | Endowment | Germany | Long | Low
16 | S | -5000 |  |  |  |  | Options | Germany | Short | Zero
17 | T |  |  |  |  |  | Property | Germany | Long | Zero
 | Net Worth
 | Excluding CPF
 | USD Exchange Rate | 1.35
 | Column1 | Column2 | Column3
 | CPF
 | CPFOA Investing
 | Options
 | Crypto
 | Cash
 | Endowment
 | SRS
 | Dividends
 | Property
 | Total
 | Immediate
 | Short
 | Medium
 | Long
 | RISK
 | Zero
 | Low
 | Medium
 | High
 | V High
 | Region
 | Germany
 | US
I | HK
I | World
I
Total Portfolio Progress |  | 1000
Date | Hundred K (Update Here) | Portfolio | Net Change | % Change (MTM) | % Change (YTD)
2020-12-29 00:00:00 | 921
2021-01-21 00:00:00 | 1060
2021-04-14 00:00:00 | 1160
2021-07-04 00:00:00 | 1140
2021-09-06 00:00:00 | 1290
2021-10-17 00:00:00 | 1313
2021-10-20 00:00:00 | 1388
2021-10-25 00:00:00
2021-10-26 00:00:00 | 1430
 | 452k at 4 Feb
 | [NAME] at 2 Aug
 | 536k at 23 Aug
 | 539k at 2 Sep
 | 550k at 16 Oct
 | [NAME] at 20 Dec
 | 550k at 31 Dec
 | 558k at 9 Feb 2020
 | 604k
 | 633k at 17-May-20
 | 663k at 11-Jun-2020
 | 664k at 11-Jul-2020
 | 727k at 01-Aug-2020
 | [NAME] at 29-Aug-2020
 | 827k at 23-Nov-2020
 | 856k at 29-Nov-2020
 | 921k at 29-Dec-2020
 | 1.06M at 21-Jan-2021-01-21 (includes HDB from this point)
 | 1.16M at 14-Apr-2021
 | 06-Feb-2021 Transferred USD58.1K from IBKR to Crypto
 | 1.14M at 04-July-2021
 | 1.29M at 06-September-2021
 | Sources of income
1 | Work Salary
2 | Rental
3 | Dividends / Interest from CPF and Endowus Funds
4 | Options Active Income
5 | [NAME]
6 | Amazon Active to Passive Income
Spreadsheet: 76cdf67e-a59f-4aa5-9a37-cea71e52034a
Sheet: Identifiable school PD

FY 2015 Integration Revenue Budget Worksheet
District Number: |  |  | District Name:
20% Professional Development
Please list on this worksheet all proposed expenditures for professional development for the district's racially identifiable school(s). No more than 20 percent of the RIS budget may be spent on these costs. See FY15 Budget Guide for details.
Line Item Description | UFARS Code Required |  |  |  | Budgeted Amount | Actual Expenditures | Budget Narrative
Provide a short description of the expenditure. | ORG | PROG | FIN | OBJ | List the total amount budgeted for this line item. | Resubmit form with actual FY15 expenditures by 12/1/15. | Provide a brief description of how these funds will be used to support achievement or integration strategies listed in your plan. List the [NAME] and Activity numbers from your plan in the colum to the right. | Plan Goal & Activity
TOTAL
Notes or Comments:
Spreadsheet: 882183d1730439535-sports-carnival-help-millie0802-swimming-results-v2-spill-2021-aligw
Sheet: Sheet2

 |  | Tibro |  |  |  |  | Coochin |  |  |  |  | Coonowrin
 |  | 8 | 9 | 10 | 11 | 12 | 8 | 9 | 10 | 11 | 12 | 8 | 9 | 10 | 11 | 12
 | 50m [NAME] |  |  |  |  |  |  | 4 | 5 | 7 | 13 |  |  |  | 65
 | 50m Free | 4 |  |  | 45 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | Tibro | Coochin | Coonowrin
 | 50m [NAME] |  |  | 6 |  |  |  |  |  |  |  |  | 4
 | 50m Back |  |  |  |  | 12 |  |  |  |  |  |  |  | 54
 | 25m Free
 | 25m [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
 | 25m Back
Spreadsheet: 106671d1303892894-excel-2007-vlookup-between-max-min-values-new_intervals_2
Sheet: Sheet1

Min | [NAME] |  |  | Calculated Value | Vlookup from [NAME] min values
14001 | 15000 | A |  | 105000
29001 | 30000 | B |  | 89450
44001 | 45000 | A |  | 77000
59001 | 60000 | B |  | 74500
74001 | 75000 | A |  | 62000
89001 | 90000 | C |  | 60300
 |  |  |  | 48000
 |  |  |  | 44700
 |  |  |  | 30500
 |  |  |  | 29500
 |  |  |  | 16900
 |  |  |  | 16100
 |  |  |  | 15300
 |  |  |  | 14500
 |  |  |  |  | Needs to auto populate cells from data A1 to C7
Spreadsheet: 356662d1415181655-column-sort-without-chaning-formulae-jc-booking-september-2014
Sheet: spare

Date |  |  |  |  |  |  |  |  |  |  |  | DAY SHEET
Job No | Due | Contact | Contact No. | Car | Imax | 13 Pax | 20 Pax | 24 Pax | 29 Pax | 44 Pax | FROM | TO | Retn | Price  $ | Dep  $ | Bal | Mode | Pax | Trailer | Con | Bus | Des | Driver
 | 8.45 |  |  |  |  |  |  |  |  |  | \
TOTAL
Spreadsheet: 843296d1695192128-a-doosy-complex-logic-for-filtering-can-you-figure-it-out-copy-of-test-formulas
Sheet: Scratch

Vendor | Library Type | Instrument Types A | Instrument Types B | Instrument Types C | Instrument Types D | Instrument Types ALL | Applications A | Applications B | Applications C | Applications ALL |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument Types ALL HELPER | Applications ALL HELPER
8Dio |  | [NAME] |  |  |  | [NAME]
Cinesamples
Spreadsheet: 28844d1223392316-sumproduct-formula-product-log
Sheet: Product Usage

 | Week 1 | Week 2 | Week 3 | Week 4
product 1 | 10 | 3 | 3 | 10
product 2 | 11 | 4 | 4 | 11
product 3 | 6 | 6 | 5 | 12
product 4 | 5 | 5 | 6 | 9
Total product Sold | 32 | 18 | 18 | 42
Spreadsheet: 0431cea5-98e3-41f0-be04-15087bbad738
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | International Taekwon-Do Federation
 | Individual Application Form - ITF Kids Course
place: | Livingston, Scotland |  |  |  | Country
Candidate ITF online ID Number |  |  |  |  | Association
Candidate:
 | one (1) first name only |  |  |  | Surname |  |  | Mr/Mrs/Miss
Address:
 | street |  |  |  | number | code | city
Date of Birth: |  |  |  |  | Nationality:
 | year | month | day
actual kup or degree:
e.mail:
President:
(NA or AA) | name |  |  |  | surname
e.mail:
date:
 | year | month | day
This is to confirm that the above mention candidate wishes to participate at the ITF Kids course
Sent this application form on or before 15th may, 2013 to [EMAIL]
Spreadsheet: 776449d1649747042-ranking-with-tie-breaker-for-fishing-tournament-winfield-lakes-festival-template-r3-aligw
Sheet: Reference

Rank | Points |  | High Lake Sec1 | High Lake Sec2 | Low Lake Sec1 | Low Lake Sec2 |  | Angler
1 | 1 |  | H1 | H15 | L2 | [NAME] | 1 | [NAME]
2 | 2 |  | H4 | H17 | L3 | [NAME] | 2 | [NAME]
3 | 3 |  | H7 | H18 | [NAME] | L16 | 3 | [NAME]
4 | 4 |  | H8 | H20 | L5 | L17 | 4 | [NAME]
5 | 5 |  | H10 | H21 | L7 | L19 | 5 | [NAME]
6 | 6 |  | H11 | H23 | L9 | [NAME] | 6 | [NAME]
7 | 6 |  | H14 |  | L11 |  | 7 | [NAME]
 |  |  |  |  |  |  | 8 | [NAME]
 |  |  |  |  |  |  | 9 | [NAME]
 |  |  |  |  |  |  | 10 | [NAME]
 |  |  |  |  |  |  | 11 | [NAME]
 |  |  |  |  |  |  | 12 | [NAME]
 |  |  |  |  |  |  | 13 | Scott Field
 |  |  |  |  |  |  | 14 | [NAME]
 |  |  |  |  |  |  | 15 | [NAME]
 |  |  |  |  |  |  | 16 | [NAME]
 |  |  |  |  |  |  | 17 | [NAME]
 |  |  |  |  |  |  | 18 | FFS [NAME]
 |  |  |  |  |  |  | 19 | [NAME]
 |  |  |  |  |  |  | 20 | [NAME]
 |  |  |  |  |  |  | 21 | [NAME]
 |  |  |  |  |  |  | 22 | [NAME]
 |  |  |  |  |  |  | 23 | [NAME]
 |  |  |  |  |  |  | 24 | [NAME]
 |  |  |  |  |  |  | 25 | [NAME]
 |  |  |  |  |  |  | 26 | [NAME]
Spreadsheet: 583227d1532331569-dependent-drop-down-or-vlook-ups-to-be-used-for-multiples-data-interconnected-rough-page-1
Sheet: COLOUR

INITIAL LIST | BRAND LOGO NEON FOR TERRACE |  | URINAL POTS |  | LAPTOP |  | FAKE NOTE DETECTOR MACHINE |  | Q MANAGERS |  | UPS 05KVA
BRAND LOGO NEON FOR TERRACE | KALARTHI ADVERTISING | RED | R K ENTP | WHITE | MAHAVIR ELECTRONICS LTD | PINK | INFRES METHODEX SYSTEM | YELLOW | VISION DISPLAY PVT LTD | BLUE | SERVOKON SYSTEMS PVT LTD | WHITE
URINAL POTS | FUNCTION NEON | BLACK | BLUESTAR POLYMERS | GREEN | AEVA INFOSOLUTION LTD | ORANGE | SHINE INTERNATIONAL | BLUE | ARHAM TRADER | PINK | OFFCON SYSTEMS PVT LTD | GREEN
LAPTOP | BRILLIANT NEON | YELLOW | THE BATH STUDIO LLP | PINK | ALPHA SHOPE | YELLOW | IKON ELECTRONICS | RED | ZAF ENTP | ORANGE | UNITECH POWER SOLUTIONS | RED
FAKE NOTE DETECTOR MACHINE | SIGMA ENTP | BLUE | BATH & CRAFTS | ORANGE | SHYAM INFO SOLUTIONS | BLUE | KNIGHT SUN IMPEX PVT LTD | BLACK | SMARTECH SAFETY SOLUTION | RED | SOCOMEC INNOVATIVE | BLACK
Q MANAGERS | AKSHAR NEON SIGN | PINK | WEST COAST ENTP | YELLOW | EMERGING TECHNO KART | RED | [NAME] | BLUE | ANMOL SALES CORP | BLACK | QUANTAM POWER | YELLOW
UPS 05 KVA | ADGLO NEON SIGN | ORANGE | NATURE CARE SOLUTIONS | BLUE | HINDUSTAN BUSINESS TECHNOLOGIES | BLACK | SU-TAX AUTOMATION | PINK | EURONICS IND LTD | YELLOW | ARZOO ENERGY | BLUE
 | R F SIGNAGES | WHITE | IMPEX SANITATION | RED | CLODTECH COMPUTERS | WHITE | ORBIT ELECTRONICS | WHITE | SCOPE INDUSTRIAL PRODUCTS | WHITE | TIRUPATHI AGENCIES | PINK
 | [NAME] | GREEN | JAI SABHAV IND | BLACK | ALICE COMPUTERS | GREEN | SHREE SWAMI SAMARTH ENTP | GREEN | SIGNTRADE | GREEN | SARVOSTAR INDIA PVT LTD | ORANGE
 | ELITE SIGNS |  | [NAME] |  | PRATHAM INFOTECH |  | [NAME] |  | NEW KANWAL ENGG WORKS |  | SAIKRIPA SALES
 | PAYAL NEON SIGNS |  | RUSHABH ENTP |  | Z-TECH SOLUTIONS |  | SYSTEMATIKS |  | ORCHIDS ENTP |  | BVM TECHNOLOGIES PVT LTD
 | MIHIR NEON SIGNS |  | DIVYANI ENTP |  | NIKHIL COMPUTERS |  | PRIYA ELECTRICALS |  | ORIENTAL ENTP |  | V TECH POWER SYSTEMS
 | [NAME] |  | SENSOWARE PVT LTD |  | GOMAX NETWORKS |  | KRONE ENTP |  | CHARU ENTP |  | POWER ONE MICRO SYSTEMS
 | BRIGHT NEON |  | SHIVLAXMI ENTP |  | SHREE COMPUTERS |  | GANAK DIGITECH |  | J.D ENG WORKS |  | SB POWER CONVERSION
 | NIKI SIGNAGES |  | CHAKRA CERAMICS |  | SVS TECHNOLOGIES |  | MAYANK IMPACT |  | H2 SAFTEY PVT LTD |  | R.D ELECTRIC WORKS
 | SAIFEE SIGNS
 | GLOW SIGN
 | PARTH NEON SIGN
 | BASIC SIGN
 | DIGITAL SIGNAGE
 | S ART
 | TAPAS SIGNAGE
 | TULSI NEON SIGN
 | SIGNAGE WORK SOLUTION
 | PEARL SIGN BOARD
 | [NAME] SIGNS
 | ABSOLUTE NEON SIGNS
Spreadsheet: 475314d1471271660-graph-with-median-and-individual-points-basicwithmedian_2
Sheet: Sheet1

 | value | median
a | 0.666666667
b | 0.764705882
c | 1.282051282
d
e | 0.377777778
f | 0.475
g | 0.593220339
h | 0.935483871
Spreadsheet: 37629d1235663907-summarizing-sales-data-sales-data
Sheet: Sheet1

Date | Dec | Jan | Feb
Open Date | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00
Close Date | 2008-12-31 00:00:00 | 2009-01-31 00:00:00 | 2009-02-28 00:00:00
How many paid in the month | 1 | 5 | 10
How much paid in month
 |  | Sale | Date Sold | Date Paid | Amount
 |  | Sales 1 | 2008-12-15 00:00:00 | 2009-01-26 00:00:00 | 50
 |  | Sales 2 | 2008-01-10 00:00:00 | 2009-02-14 00:00:00 | 100
 |  | Sales 3 | 2008-12-18 00:00:00 | 2008-12-30 00:00:00 | 75
 |  | Sales 4 | 2009-01-22 00:00:00 | 2009-01-03 00:00:00 | 95
 |  | Sales 5 | 2009-01-28 00:00:00
 |  | Sales 6 | 2009-01-29 00:00:00 | 2009-01-31 00:00:00 | 45
 |  | Sales 7 | 2009-02-03 00:00:00 | 2009-02-20 00:00:00 | 60
 |  | Sales 8 | 2009-02-03 00:00:00 | 2009-02-15 00:00:00 | 43
 |  | Sales 9 | 2009-02-11 00:00:00
 |  | Sales 10 | 2009-01-23 00:00:00 | 2009-02-16 00:00:00 | 83
 |  | Sales 11 | 2009-02-02 00:00:00 | 2009-01-18 00:00:00 | 77
 |  | Sales 12 | 2009-02-03 00:00:00 | 2009-01-31 00:00:00 | 64
 |  | Sales 13 | 2009-02-12 00:00:00
 |  | Sales 14 | 2009-01-30 00:00:00 | 2009-02-15 00:00:00 | 140
 |  | Sales 15 | 2009-02-02 00:00:00 | 2009-02-15 00:00:00 | 39
 |  | Sales 16 | 2009-02-03 00:00:00 | 2009-02-16 00:00:00 | 65
 |  | Sales 17 | 2009-02-03 00:00:00
 |  | Sales 18 | 2009-02-10 00:00:00 | 2009-02-15 00:00:00 | 53
 |  | Sales 19 | 2009-02-03 00:00:00 | 2009-02-15 00:00:00 | 67
 |  | Sales 20 | 2009-02-03 00:00:00 | 2009-02-16 00:00:00 | 50
Spreadsheet: 682155d1591930163-help-investment-tracker-with-foreign-currency-excel-spreadsheet-portfolio
Sheet: OPPORTUNISTIC

Industry | Stock | Price | P1 | P1 AUD | P2 | P2 AUD | P3 | P3 AUD | [NAME] | Capital Gains AUD | Currency Gains | Currency Gains AUD | Profit/Loss | Country | Total AUD | Weight
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
Spreadsheet: 764792d1643004714-1-how-to-create-a-list-based-on-user-input-2-previous-values-based-on-the-last-occurance-questions
Sheet: Q1

Name | Profit | Most profitable List | Total Profit |  | USER INPUT: | 5 | PLEASE ENTER A VALUE TO KNOW THE MOST PROFITABLE NAMES
ABC | 100
RST | 50
XYZ | 300
ABC | -50
MNO | 200
RST | 600 |  |  |  | [NAME] needed for G1 such that:
QWE | 150 |  |  |  | if user input is, let's say, 5, then list of top 5 profitable names should appear in Col C along with their respective total profit in Col D
RST | -150 |  |  |  | but if user input is, let's say 7, then top 7 names along with their total profits to appear in Col C & D
LKJ | 300 |  |  |  | The list shd appear such that most profitable name shd be on the top (decending profit)
DFG | -350
UYT | 400
HGY | 100
ZXC | 200
BVC | 50
XYZ | 800
ABC | 200
Spreadsheet: 721950d1614961011-list-only-positive-numbers-out-of-a-table-with-row-column-cross-titles-list-from-a-table
Sheet: Sheet1

OU | BLL | BLTLL | BLD | BLG | BLUK | BLDK | BLDH | BLI | BLFS | BLSP | BLBC | BLTW | BLKK
BLL | 0 | 9195654.280000001 | -24808604.1 | 0 | 373108.48 | 933.34 | -918632.81 | -14348139.22 | -88234.79 | 3931.32 | -123202.3199999999 | 92224.84 | 229800.65
BLTLL | -9195654.29 | 0 | -2309166.63 | 1208732.7 | 88.8 | 0 | 0 | -115984.52 | 0 | 0 | 0 | 0 | 0
BLD | 24808604.10000001 | 2309166.63 | 0 | 0 | 0 | -954389.6200000001 | 0 | 0 | 0 | 1152079.13 | 0 | 0 | 0
BLG | 0 | -1208732.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLUK | -373108.48 | -88.8 | 0 | 0 | 0 | 2307.23 | 0 | 0 | 0 | 0 | 0 | -301077.31 | 0
BLDK | -933.34 | 0 | 954389.62 | 0 | -2307.23 | 0 | -8976.38 | -5370.639999999999 | 0 | 0 | 0 | 0 | 0
BLDH | 918632.81 | 0 | 0 | 0 | 0 | 8976.38 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLI | 14348139.22 | 115984.52 | 0 | 0 | 0 | 5370.64 | 0 | 0 | 1302903.62 | -13152118.81 | 30475.06 | 0 | 0
BLFS | 88234.79 | 0 | 0 | 0 | 0 | 0 | 0 | -1302903.62 | 0 | 0 | 0 | 0 | 0
BLSP | -3931.32 | 0 | -1152079.13 | 0 | 0 | 0 | 0 | 13152118.81 | 0 | 0 | 0 | 0 | 0
BLBC | 123202.3200000001 | 0 | 0 | 0 | 0 | 0 | 0 | -30475.06 | 0 | 0 | 0 | 0 | 0
BLTW | -92224.84 | 0 | 0 | 0 | 301077.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BLKK | -229800.65 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 9195654.28
 |  |  |  | [NAME] | 373108.48
 |  |  |  | [NAME] | 933.34
 |  |  |  | BLL-BLSP | 3931.32
 |  |  |  | BLL-BLTW | 92224.84
 |  |  |  | BLL-BLKK | 229800.65
 |  |  |  | BLTLL-BLG | 1208732.7
 |  |  |  | BLTLL-BLUK | 88.8
 |  |  |  | BLD-BLL | 24808604.1
 |  |  |  | BLD-BLTLL | 2309166.63
 |  |  |  | BLD-BLSP | 1152079.13
 |  |  |  | BLUK-BLDK | 2307.23
 |  |  |  | BLDK-BLD | 954389.62
 |  |  |  | BLDH-BLL | 918632.81
 |  |  |  | BLDH-BLDK | 8976.38
 |  |  |  | BLI-BLL | 14348139.22
 |  |  |  | BLI-BLTLL | 115984.52
 |  |  |  | BLI-BLDK | 5370.64
 |  |  |  | BLI-BLFS | 1302903.62
 |  |  |  | BLI-BLBC | 30475.06
 |  |  |  | BLFS-BLL | 88234.79
 |  |  |  | BLSP-BLI | 13152118.81
 |  |  |  | BLBC-BLL | 123202.32
 |  |  |  | [NAME] | 301077.31
Spreadsheet: ea1b8c87-a417-467d-bc26-3bae8f2cda4c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FX13M | Test | FX13M | Factor [NAME], Qualitative, with [NAME] to Factor [NAME] 1:1 Mix | Factor [NAME], Qual, w/[NAME] 1:1 Mix | Solubility |  |  |  |  |  | Draw one 5 mL lt. blue (sodium citrate) tube. Separate immediately and submit 2 mL platelet-poor plasma, ship frozen.   Note: Critical frozen.  Separate specimens must be submitted when multiple tests are ordered. | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	Serum. Non-frozen or hemolyzed specimens | Factor [NAME], Qualitative:   No Lysis Factor XIII, 1:1 Mix:  Not Applicable   Test Performed by: ARUP Laboratories                              500 [NAME]Salt Lake City, UT 84108 | Sunday through Saturday | 2 - 3 days | 4 - 5 days | 1 | 85291 |  |  |  |  | ARUP Laboratories
FX13M | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
FX13M | Result | Z2637 | Factor [NAME], Qualitative | Factor [NAME], Qualitative | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FX13M | Result | [NAME] | Factor XIII, 1:1 Mix | Factor XIII, 1:1 Mix | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FX13M | [NAME] | F13BO | Factor XIII 1:1, [NAME] Only | Factor XIII 1:1, [NAME] Only | Used for billing purposes only. |  |  |  |  |  | Used for billing purposes only. |  |  |  |  |  |  | 1 | 85291 |  |  | No | No Billing Only
F13BO | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
Spreadsheet: 84009d1284017064-if-statements-for-time-copy-of-time-sheet-for-forum
Sheet: Sheet1

Date | customer/Job | employee | start time | stop time | Actual Time | Billed time | Work Description | Work | Rework | Paid Hours | Still to do | Column13 | Column14 | Column15 | Column16 | Column17 | Column18
 |  |  | 08:00:00 | 19:35:00
 |  |  | 10:00:00 | 12:05:00
Spreadsheet: 164897d1340957092-require-forumla-to-calculate-age-at-date-of-termination-example
Sheet: FAS

Associate LastName | Associate First Name | Associate Planning Organization | Associate Planning Sub-Organization | Job Title | Buffer Resource Available (Y/N) - IF Y - need explanation as to why the buffer was not actioned first | Grade | Race* (US Only) | Gender (M / F) | GLOBAL | Associate Age (Years) | Country | Associate Annual Pay Used for Severance Calc (US $) | Blank 1 | Associate Service (Years) | Blank2 | Severance Payout (US$) | Benefits (US$) | Outplacement (US$) | Total Eligible FAS 112 (US$) | Notice Benefit (US$) | Non-FAS Eligible Benefits (US$) | Overall Total FAS Cost (US$) | RIF Notification Date (DD-MON-YY) | RIF Payment Start Date (DD-MON-YY) | Off Headcount Date (DD-MON-YY) | RIF Payment End Date (DD-MON-YY) | Payback Period in Months | Replacement (Y/N) | Replacement Salary | Initiative | How Severance is Paid | Additional Comments | Treasury Approval Date | Associate Annual Pay Used for Severance Calc (Local Currency) | Local Currency | Currency Exchange Rate | Payroll Termination Code (e.g. ELI,  [NAME]…) | Rationale for Payroll Term Code other then ELI | Name of ERC completing template | Signer | Signer's Title | Weekly Salary | FML Code | GL Code Type | Full Years of Svc | Employee needs to be removed from file | Employee data has changed since being approved by Treasury | On Hold - Not Submitted to Treasury | Weeks of Severance | Submitted By | On Hold Calc | Org type | Notified | Initiative | start date | service date | rehire date | Birth Date
0 | 0 |  |  |  |  | 11 |  |  |  | 38 | UK | 143999.856 |  | 18 |  | #N/A | n/a | 2000 | #N/A | 33230.736 | #N/A | #N/A | TBC | TBC | 2012-08-28 00:00:00 | TBC | #N/A | N |  |  | Payroll |  |  | 79999.92 |  | 1.8 | ELI |  |  |  |  | 1538.46 |  |  | 18 |  |  |  | 36 |  |  |  |  |  | 1993-07-19 00:00:00 | 1993-07-19 00:00:00 |  | 1973-08-29 00:00:00
Spreadsheet: 266306d1379579654-how-many-followup-made-by-a-salesman-between-a-particular-set-of-dates-0a213
Sheet: Sheet1

date | name | age | salesman |  |  | between dates
20130429 | VERMA | 29 | 4840374 |  |  | 20130401 | 20130731
20130429 | RAJAK | 47 | 4840374
20130515 | NEMA | 19 | 4840374 |  |  | salesman |  | Results
20130515 | NEMA | 27 | 4840374 |  |  | 4840374 | 0
20130524 | BABBAR | 37 | 4840374 |  |  | 5842374 | 1
20130608 | THAKUR | 33 | 4840374
20130628 | BHAN | 38 | 4840374
20130715 | KHATRI | 5 | 4840374
20130726 | AGRAWAL | 27 | 4840374
20130810 | WADHAWA | 6 | 4840374
20130911 | BHASIN | 29 | 4840374
20130417 | GOHIYA | 24 | 5842374 |  |  | In this example salesman 4840374 met "nema" more than 1 time but the age dose not match hence they are different people.
20130417 | [NAME] | 26 | 5842374
20130513 | RAJAK | 38 | 5842374
20130715 | KOHLI | 39 | 5842374
20130715 | KOHLI | 39 | 5842374
20130715 | KOHLI | 39 | 5842374
20130717 | KOHLI | 39 | 5842374
20130717 | KOHLI | 39 | 5842374
20130731 | SEN | 24 | 5842374
Spreadsheet: 149586d1334034497-vlookup-based-on-id-and-date-range-vlookup-for-id-and-date-within-a-range
Sheet: Employee Role Master

Emp Id |  |  |  |  | Project Name |  | Starte Date in project | End Date in project
1 |  |  |  |  | Project1 |  | 2012-01-04 00:00:00 | 2012-01-31 00:00:00
2 |  |  |  |  | Project1 |  | 2012-01-01 00:00:00 | 2012-01-31 00:00:00
3 |  |  |  |  | Project1 |  | 2012-01-01 00:00:00 | 2012-01-31 00:00:00
1 |  |  |  |  | Project2 |  | 2012-02-01 00:00:00 | 2012-02-20 00:00:00
2 |  |  |  |  | Project2 |  | 2012-02-01 00:00:00 | 2012-02-28 00:00:00
3 |  |  |  |  | Project2 |  | 2012-02-01 00:00:00 | 2012-02-28 00:00:00
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: Weld

Detail No. | Quantity | [NAME] | Check Material Specs | Check Material Availability | Machninig Allowance | Weld Prep | Weld Time | Clean Up/Sand Blast | Clean Up/Hand Finish | Check Gas Levels | Check Rods Levels | Other | Total Time (hours) | NOTES
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
. |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0