tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 490102d1479675281-time-formats-and-time-data-problem-rota-sample-for-forum
Sheet: Sheet1

BAR ROTA |  | Week Starting: |  |  |  |  |  | SAMPLE: Opening
Name | Role | Wage |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Cost p.w. | Cost p.a.
 |  |  |  | 12 - 1am | Hours | 12 - 1am | Hours | 12 - 1am | Hours | 12 - 1am | Hours | 12-2.30am | Hours | 10-2.30am | Hours | 10 - 1am | Hours | Hours
Manager 1 | GM | 20000 | Start | 12:00:00 |  |  |  | 12:00:00 |  |  |  | 12:00:00 |  | 21:00:00
 |  |  | Finish | 1900-01-01 01:30:00 |  |  |  | 1900-01-01 01:30:00 |  |  |  | 1900-01-01 03:00:00 |  | 1900-01-01 03:00:00 |  |  |  |  | [NAME]
Manager 2 | GM | 20000 | Start |  |  | 12:00:00 |  |  |  | 12:00:00 |  |  |  | 10:00:00 |  | 10:00:00
 |  |  | Finish |  |  | 1900-01-01 01:30:00 |  |  |  | 1900-01-01 01:30:00 |  |  |  | 21:00:00 |  | 20:00:00 |  |  | [NAME]
Supervisor | DM | 7.9 | Start |  |  | 17:30:00 |  |  |  |  |  | 16:00:00 |  | 19:00:00 |  | 16:00:00
 |  |  | Finish |  |  | 1900-01-01 01:30:00 |  |  |  |  |  | 1900-01-01 03:00:00 |  | 1900-01-01 03:00:00 |  | 1900-01-01 01:30:00 |  |  |  | 0
One or Two? | BS | 6.9 | Start | 17:30:00 |  |  |  | 17:30:00 |  |  |  | 17:30:00 |  | 10:00:00 |  | 12:00:00
 |  |  | Finish | 1900-01-01 01:30:00 |  |  |  | 1900-01-01 01:30:00 |  |  |  | 1900-01-01 01:30:00 |  | 19:00:00 |  | 20:00:00 |  |  |  | 0
 | BS | 6.9 | Start | 12:00:00
 |  |  | Finish |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Headchef 25(+gp bonuses)-27k | 11 | Start
 |  |  | Finish |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | CdP | 8.5 | Start
 |  |  | Finish |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
x2 with tips | KP | 7.2 | Start
 |  |  | Finish |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: e5533742-5f43-481e-8b32-68ceab193052
Sheet: N2.  Summary for Consumers

Exhibit N2:  Rate Filing Summary for Consumers
Overview
[NAME]:
[NAME]):
Market Segment:
Rate Effective Date:
Approved Average Annual Rate Change:
Requested Average Annual Rate Change:
Requested Average Annual Rate Change excluding any Benefit Changes:
Number of Members Impacted on a Annual Basis:
Key Information to Support the Rate Change
Expected Percentage to be spent on claims:
Expected Percentage to be spent on administrative expenses:
Expected Percentage to be spent on contribution to surplus/profit or other items:
The company expects its annual medical costs to change:
Benefit Changes:
Insurer's Past Annual Rate Changes: | Proposed | Approved
2009-07-01 00:00:00
2010-01-01 00:00:00
2010-07-01 00:00:00
2011-01-01 00:00:00
2011-07-01 00:00:00
2012-01-01 00:00:00
Spreadsheet: c2577904-ce00-4c8d-a915-b3185e7c37c5
Sheet: Sheet1

Release: House Price Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=171
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-23 4:10 PM CDT
 | Real-Time | Period
Name: | Start | End
House Price Index | 2008-05-22 00:00:00 | Current
Link:
http://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index.aspx | 2008-05-22 00:00:00 | Current
Source:
Federal Housing Finance Agency | 2008-05-22 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2008-05-22 00:00:00
2008-08-26 00:00:00
2008-11-25 00:00:00
2009-02-24 00:00:00
2009-05-27 00:00:00
2009-08-25 00:00:00
2009-11-24 00:00:00
2010-02-25 00:00:00
2010-05-25 00:00:00
2010-08-25 00:00:00
2010-11-24 00:00:00
2011-02-24 00:00:00
2011-05-25 00:00:00
2011-08-24 00:00:00
2011-11-29 00:00:00
2012-02-23 00:00:00
2012-05-23 00:00:00
2012-06-21 00:00:00
2012-07-24 00:00:00
2012-08-23 00:00:00
2012-09-25 00:00:00
2012-10-24 00:00:00
2012-11-27 00:00:00
2012-12-20 00:00:00
2013-01-23 00:00:00
2013-02-26 00:00:00
2013-03-21 00:00:00
2013-04-23 00:00:00
2013-05-23 00:00:00
2013-06-25 00:00:00
2013-07-23 00:00:00
2013-08-22 00:00:00
2013-09-24 00:00:00
2013-10-23 00:00:00
2013-11-26 00:00:00
2013-12-24 00:00:00
2014-01-23 00:00:00
2014-02-25 00:00:00
2014-03-25 00:00:00
2014-04-22 00:00:00
Spreadsheet: mary_fischer__25814__2 EES Cons 1CE 2CE variance analysis
Sheet: RETAIL4

EES - RETAIL 4
Analysis of 1st CE to 2nd CE Variances
For the Tax Year 2001.
(in millions)
DR/(CR)
(Income)/Loss
 | 1CE | 2CE | [NAME] |  | Reasons for variance
Net Income Before Tax | -169 | -189
Permanent Differences
Dividends | 0 | 0
Equity Earnings | 0 | 0
Foreign Operations | 56 | 77 |  |  | Canada $12 m increase
Foreign Taxes | 0 | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
[NAME] | -7 | -7
Other - Mapping Issues | 1 | 0
Other - Business Exp @ 50% | -4 | -4
Total Permanent Differences
Temporary Differences
Depreciation, Depletion, & Amort. | -4 | -2
Partnership Equity | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Price Risk Management | 194 | 57 |  |  | moved to WHSEES4
Regulatory Contingencies | 0 | 0
Computer Development Costs | 16 | 16
Investments in Subs | -46 | -46
Project Development | 42 | 37
Employee Fringe Benefits | -11 | -16
Contingency Provision | 0 | 0
Other - FAS 140 Monetization of Warrants | 82 | 50
Other - Percentage of Completion | 0 | 0
Other - Bad Debt Expense | -1 | 1
Total Temporary Differences
Total State Taxable Income
Current State Tax Exp/(Bene) | 0 | 1
Total Federal Taxable (Income)/Loss
Current Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal - NOL Prior Year Payment | -79 | -79
Other State | 1 | 1
Other Foreign | 8 | 0
Total Current Tax Expense (Benefit)
Deferred Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal - Return to Accrual | 0 | 0
Other Federal - NOL Prior Year Payment | 79 | 79
Other State - Return to Accrual | 0 | 0
Other State | 5 | 5
Other Foreign | 10 | 27
Total Deferred Tax Expense (Benefit)
Total Tax Expense (Benefit)
Net (Income) / Loss
Effective Rate
Spreadsheet: 95559d1295141003-need-solution-to-pull-data-from-sheet1-to-sheet2-if-value-0-mafiawars
Sheet: Sheet1

Giftable: | (Multiple Items)
 |  |  |  |  | GIFTABLE ITEMS - ATTACK |  | Amount
Sum of Giftable: |  |  |  |  | Weapons:
Top Weapons | Total
40mm Bunker Buster | 10
Executive Decision | 5 |  |  |  | Armor:
New Years Resolution | 29
Grand Total | 44
 |  |  |  |  | Vehicles:
Giftable: | 22
 |  |  |  |  | Animals:
Sum of Giftable:
[NAME] | Total
[NAME] and [NAME] | 22
Grand Total | 22
Spreadsheet: 720157d1614038829-need-to-extract-data-and-skip-blanks-machine-shop-schedules-excel-forum-2_22_2021
Sheet: AA-1 Plating Cost Calculator

 |  |  |  |  | PURCHASE ORDER ENTRY (Do not populate gray cells)
CNC / LASER ENTRY (Do not populate gray cells) |  |  |  |  | PO SUBTOTAL |  |  | Expedite: NEXT DAY $ 285
 |  |  |  |  | PO WASTE FEE (5% of SUBTTL) |  |  | Expedite: SAME DAY $ 350
P/N | L (IN) | W (IN) | REV | QTY | Total Dimensions | Cost per Part | Total QTY Cost
P/N 2
P/N 7
P/N 8
P/N 12
Spreadsheet: 845362d1696895333-assistance-in-updating-formula-showing-value-error-2024-financial-year-planner-and-budget-fortnightly-with-or-without-gst-second-value-error
Sheet: Table of Contents

[NAME] Personal Fortnightly Budget for the 2024 Financial Year
 | 'Table of Contents'!A1
 | 'How to use this Spreadsheet'!A5
 | 'Notices of Copyright Plagiarism'!A5
 | 'NDIS Payments'!A5
 | 'Income, Cash, or Debit Expenses'!B7
 | 'Income, Cash, or Debit Expenses'!A5
 | 'C''link Repayments'!A5
 | 'Home and Utilities'!A5
 | 'Insurance and Financial'!A5
 | 'Emergency Fund'!A5
 | 'Life Savings'!A5
 | 'Debts - Including Credit Cards'!A5
 | 'Personal, Other'!A5
 | Children!A5
 | Miscellaneous!A5
 | 'Assistance Dogs Aus (Savings)'!A5
 | 'Christmas Club'!A5
 | 'Debts - Excluding Credit Cards'!A5
 | 'Transport and Auto'!A5
 | 'Commonwealth Bank of Australia'!A5
 | PCCU!A5
 | 'QANTAS Money'!A5
 | 'Summary (Totals)'!A5
 | 'Records of Payments,Other Notes'!A5
 | 'Fees and [NAME] List'!A5
 | 'Streaming Services Subscription'!A5
 | 'ANZ QANTAS Visa C C Purchases'!A5
 | 'C C Purchases'!A5
 | cashmeresyrups.com.au!A5
 | 'QANTAS Money C C Purchases'!A5
 | Personal!A5
 | 'Bupa N-E Ambulance Insurance'!A5
 | '[NAME] Insurance'!A5
 | 'Pharmaceutical Expenses'!A5
 | Electricity!A5
 | 'Telstra Services'!A5
 | 'Debts - M E Adair'!A5
 | 'Debts - J E Adair'!A5
 | 'Debts - ATO HELP'!A5
 | 'Debts - ATO SFSS'!A5
 | 'CBA Funds'!A5
 | 'Christmas Club Funds'!A5
 | 'Debts - mybudget.com.au'!A5
 | 'Emergency Funds'!A5
 | 'Life Savings Funds'!A5
 | 'Assistance Dogs Australia'!A5
 | 'Assistance Dogs Aus (Savings 1)'!A5
 | 'Junction Housing Expenses'!A5
 | 'PCCU Funds'!A5
 | 'QANTAS Money Funds'!A5
 | 'Xtra Credit Card Payments'!A5
 | 'Tuition Fees (J Grieger)'!A5
 | 'Tuition Fees (Larkins B)'!A5
 | 'Tuition Fees (Francesca H-T)'!A5
 | 'Tuition Fees ([NAME] Moraa)'!A5
 | 'Tuition Fees (J [NAME]
 | 'Tuition Fees (and Extras)'!A5
 | 'tafeSA or University Fees'!A5
 | 'Mediation Institute Australia'!A5
 | AOFM!A5
 | '[NAME] Services'!A5
 | 'Friends With Benefits (FWB)'!A5
 | '[NAME]
 | 'startingfresh.com.au (Tanya J)'!A5
 | 'Lay-By List'!A5
 | '[NAME] Press'!A5
 | 'Savings (Money in Jar at home)'!A5
 | 'V-lookup Function'!A5
 | 'Income & Cash or [NAME] (2)'!A5
 | 'Home and Utilities (Leap Year)'!A5
 | 'Income & Cash or [NAME] (3)'!A5
 | 'Pharmaceuticals List (2)'!A5
Spreadsheet: 91733d1291397861-combine-totals-book1
Sheet: Sheet2

User Name | labpc1 | labpc2 | labpc3 | labpc4 | labpc5 | [NAME] | labpc7 | labpc8 | labpc9 | labpc10
user1 | 1
user1 | 1
user1 |  |  |  |  |  |  |  |  | 1
user1 |  | 1
user1 Count | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
user2 |  |  |  | 1
user2 |  |  |  |  |  | 1
user2 |  | 1
user2 Count | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0
user3 |  | 1
user3 |  |  |  |  |  |  |  |  |  | 1
user3 | 1
user3 Count | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
user4 |  |  | 1
user4 Count | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Count | 3 | 3 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 1
Spreadsheet: eac682f0-9eac-4c67-b5e4-269abe90ce19
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40876944 | 2014-04-06 23:22:42 | ALLIES | 1 | 5 | 2 | 1444429 | michelecannone | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40877366 | 2014-04-06 23:46:28 | AXIS | 1 | 5 | 3 | 1444429 | michelecannone | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
40950431 | 2014-04-12 05:04:51 | AXIS | 1 | 5 | 3 | 181733 | deepnet | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40950670 | 2014-04-12 05:38:33 | ALLIES | 0 | 4 | 5 | 181733 | deepnet | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40981491 | 2014-04-14 04:09:59 | AXIS | 1 | 7 | 3 | 1502391 | Benaiah3 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40981734 | 2014-04-14 04:41:27 | ALLIES | 0 | 6 | 7 | 1502391 | Benaiah3 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
41018476 | 2014-04-16 18:39:09 | AXIS | 1 | 6 | 2 | 1478478 | ze phénix | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
41018717 | 2014-04-16 19:10:28 | ALLIES | 1 | 6 | 2 | 1478478 | ze phénix | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
Spreadsheet: 086181d4-bb08-40cc-a165-d2737e7ebab2
Sheet: ACCESS

Field Descriptions | Tab-Delimited Field Headings (Detailed Summaries) | Excel Field Headings (All Group Only)
School year in which the data was reported (13-14 means the 2013/2014 school year) | dataYear | Data Year
District County Number (where district office is located) | DistrictCountyNumber | District County Number
District County Name (where district office is located) | DistrictCountyName | District County Name
District Number | districtNumber | District Number
District Type | districtType | District Type
District Name | districtName | District Name
School Number | schoolNumber | School Number
School Name | schoolName | School Name
Service Cooperative Region Number | ECSUNumber | ECSU Number
Economic Development Region | EconomicDevelopmentRegion | Eco Dev Rgn
Name of the test | testname | Test Name
Date which testing began | testDate | Test Date
Grade | grade | Grade
Subject | subject | Subject
reportOrder - The report order aids in sorting and selecting certain groups of results | reportOrder | Report Order
reportCategory - The broader category of the results | reportCategory | Report Category
reportDescription - The detailed description of the Group (see Subgroups tab) | ReportDescription | Report Description
An indicator (Y/N) showing if the results for this group were filtered | filtered | Filtered
Count of students with valid test scores | CountTested | Count Tested
Count of students proficient | countProficient | Count  Proficient
Count of students not proficient | countNotProficient | Count  Not Proficient
Percent of students proficient | percentProficient | Percent  Proficient
Percent of students not proficient | percentNotProficient | Percent  Not Proficient
Count of students in Achievement Level 1 (Profiency Level Score 1.0 to 1.9) | countLevel1 | Count Level 1
Count of students in Achievement Level 2 (Profiency Level Score 2.0 to 2.9) | countLevel2 | Count Level 2
Count of students in Achievement Level 3 (Profiency Level Score 3.0 to 3.9) | countLevel3 | Count Level 3
Count of students in Achievement Level 4 (Profiency Level Score 4.0 to 4.9) | countLevel4 | Count Level 4
Count of students in Achievement Level 5 (Profiency Level Score 5.0 to 5.9) | countLevel5 | Count Level 5
Count of students in Achievement Level 6 (Profiency Level Score  6.0) | countLevel6 | Count Level 6
Percent of students in Achievement Level 1 | percentLevel1 | Percent Level 1
Percent of students in Achievement Level 2 | percentLevel2 | Percent Level 2
Percent of students in Achievement Level 3 | percentLevel3 | Percent Level 3
Spreadsheet: 47294d1246315033-combining-two-worksheets-into-one-example
Sheet: Two month total

Name | Money Owed
[NAME] | 1000
[NAME] | 500
Emma | 687
Jacci | 5844
[NAME] | 5446
Davey | 1000
Janice | 500
[NAME] | 15
[NAME] | 5545
[NAME] | 1200
Total | 21737
Spreadsheet: 877474d1724311657-redundancy-calc-with-a-difference-a-formula-question-thenewunion-redundancy-calc-with-a-difference-v2-365-aligw
Sheet: Sheet1

 | Redundancy Calc with a difference
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1 | 1.5 | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks
 | Empl 001 | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  |  |  |  |  |  | Correct |  | I edited the formula in Column I, changing the number in min to 23 and it seems to work (that may have "broken" the 2 x non working examples)
 | Empl 002 | 1974-03-22 00:00:00 | 2008-01-04 00:00:00 | 2024-10-31 00:00:00 |  |  |  |  |  |  |  |  | Correct |  | I edited the formula in Column I, changing the number to 23 and it worls
 | Empl 003 | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  |  |  |  |  | Incorrect |  | I would expect 1 x 1 Week and 3 x 1.5 for a total of 5.5
 | Empl 004 | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  |  |  |  |  |  | Incorrect |  | I would expect 2 x 1 Week and 14 x 1.5 for a total of 23
 |  | 0.5 week’s pay for each full year worked when you’re under 22
 |  | 1 week’s pay for each full year worked when you’re between 22 and 41
 |  | 1.5 week’s pay for each full year worked when you’re 41 or older
Spreadsheet: 029f3a6d-898b-4432-93ed-e1e1dd62c514
Sheet: Sheet1

1938 - 26th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Bressoux, Liège, Belgium |  |  |  |  | 1938-09-11 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | POL | Janusz | [NAME]. Antoni | Janik | Franz. | SP-BCU L.O.P.P. | Trojan/Bulgaria | 1692 | 1900-01-01 13:47:00
2 | BEL | Thonnard | ([NAME].) | Schueren | ([NAME]) | S 11 |  | 1463 | 1900-01-01 09:55:00
3 | POL | [NAME] | L. | [NAME] |  | SP-ANA Warzawa II |  | 1444 | 1900-01-01 09:33:00
4 | FRA | [NAME] | [NAME] | [NAME] | P. | F-AOJY  [NAME] | Rumania | 1406 | 1900-01-01 09:25:00
5 | POL | Koblanski | . | [NAME] | M. | SP-AMY  Polonia II |  | 1369 | 1900-01-01 09:45:00
6 | BEL | Demuyter | Ernest | Hoffmans | [NAME] | OO-BFM Belgica | Karpathian Mountains/Rumania | 1336 | 1900-01-01 07:35:00
7 | BEL | [NAME] | [NAME] | [NAME] | [NAME] | Wallonie |  | 1026 | 1900-01-01 06:00:00
8 | FRA | Crombez | [NAME] | [NAME] |  | [NAME] |  | 905 | 23:50:00
9 | SUI | Tilgenkamp | Dr. E. | Schaetti | N. | HB-BIA  Zürich III | Raasdorf/Vienna/Austria | 841 | 1900-01-01 00:50:00
Spreadsheet: 752029d1634542354-excel-reporting-on-daily-and-monthly-basis-categorically-1
Sheet: Timesheet

Monthly Timesheet
[NAME] |  | 9
Total Standard hrs / Week |  | 54
Start Week Containing |  | 2021-11-01 00:00:00
Week Ending |  | Thursday
Labor | Category | Project |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Hrs | [NAME] | [NAME] | Payable Hrs
aa | Mason | Warqa |  |  |  | 9 | 9
bb | Mason | Warqa |  |  |  |  |  | 8 | 10
cc | Mason | Dubai Hills |  |  |  |  | 8 | 1
dd | Plumber | Dubai Hills |  |  |  |  | 9 |  | 9
ee | Carpentar | Marina |  |  |  |  | 5 | 7
Total Hours:
 |  | Regular Hours:
 |  | OT Hours:
Note: Use increments of 0.25 (15 minutes) when recording hours.
Employee Signature |  |  | Date
Supervisor Signature |  |  | Date
[NAME]: [Name]
Spreadsheet: 456678d1460991952-change-row-and-cell-colours-depending-upon-certain-values-case-tracker-template
Sheet: On going Cases

From | First Name | Middle Initial | Last Name | Reference | Meeting Date | Lender | DIP Completed | FMA Completed | Offered Date | Time Since Offer | Report Sent | Added to TP and Factfind Done | Submitted | Fee | Fee Rec'd | Proc Fee | Notes
A | [NAME] | A | [NAME] | 80364177 | 2015-09-21 00:00:00 | Natwest | 2015-09-01 00:00:00 | 2015-11-01 00:00:00 | 2015-11-15 00:00:00 |  | 2015-10-29 00:00:00 | 2016-03-15 00:00:00 | 2016-04-04 00:00:00 | 250 | 2015-11-06 00:00:00 | 228.48
B | [NAME] | B | [NAME] | 10/51821469 | 2016-02-01 00:00:00 | Halifax | 2015-09-27 00:00:00 | 2015-11-01 00:00:00 | 2016-02-01 00:00:00 |  | 2015-10-29 00:00:00 | 2015-10-27 00:00:00 | 2016-04-05 00:00:00 | 395 |  | 255.15
C | Margery | C | [NAME] | 123546 | 2015-10-13 00:00:00 | Natwest | 2015-10-25 00:00:00 | 2015-11-17 00:00:00 | 2016-03-01 00:00:00 |  |  |  | 2016-04-06 00:00:00
B | Dawn | D | [NAME] | 85464874 | 2016-05-03 00:00:00 | Halifax | 2015-10-19 00:00:00 | 2015-12-01 00:00:00 | 2016-03-11 00:00:00 |  |  |  | 2016-04-07 00:00:00
B | [NAME] | E | Gray | 80993726 | 2016-01-11 00:00:00 | Natwest | 2016-01-07 00:00:00 | 2016-02-12 00:00:00 | 2016-04-04 00:00:00
B | Stuart | F | Leach | 1278946749 | 2016-04-01 00:00:00 | Natwest | 2016-01-13 00:00:00 | 2016-03-01 00:00:00 | 2016-04-15 00:00:00
B | [NAME] | G | Boyle | 10/52031218-7 | 2016-01-18 00:00:00 | Halifax | 2016-01-21 00:00:00 | 2016-04-01 00:00:00 | 2016-04-12 00:00:00 |  | Needs Checking |  |  | 250
 |  |  |  |  |  |  |  |  |  |  |  |  | Total |  | Total
Spreadsheet: 699645d1602688933-lookup-of-a-barcode-and-if-present-load-value-from-one-list-and-if-not-from-another-barcode-assign-test
Sheet: barcodes

barcode | action | location to store keep tube | location to store dispose tube
200605497
200592986
200605403
200605507
200605445
200594693
200594915
200594666
Spreadsheet: 009c2977-66af-47f7-88a2-8ef25b6cfbde
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Model | Date From | Date to | Model | Service Intervals (miles / months)
 | Car range
 | Pride | 1991 | 2000 | All | 6000 / 6
 |  | 2000 | on | All | 9000 / 12
 | Picanto | 2004 | on | All | 10000 / 12
 |  | 2012 | on | All | 10000 / 12
 | Rio | 2001 | 2005 | All | 10000 / 12
 |  | 2005 | on | All | 10000 / 12
 |  | 2010 | on | Diesel | 12500 / 12
 |  | 2012 | on | All | 10000 / 12
 | Cerato | 2004 | on | All | 10000 /12
 | cee'd | 2007 | on | Petrol | 10000 / 12
 |  | 2010 | on | Petrol | 12500 / 12
 |  | 2007 | on | Diesel | 12500 / 12
 |  | 2010 | on | Diesel | 20000 / 12
 | Mentor | 1994 | 1998 | All | 6000 / 6
 | Mentor II / Shuma | 1998 | 2001 | All | 9000 / 12
 | New Mentor | 2001 | on | All | 10000 / 12
 | Shuma II | 2002 | on | All | 10000 / 12
 | Clarus | 1998 | 2001 | All | 9000 / 12
 | Magentis | 2001 | 2006 | All | 10000 / 12
 |  | 2006 | on | All | 10000 / 12
 |  | 2009 | on | Diesel | 12500 / 12
 | Recreational vehicles
 | [NAME] | 2000 | 2002 | All | 9000 / 12
 |  | 2002 | 2006 | Petrol | 10000 / 12
 |  | 2002 | 2006 | Diesel | 10000 / 12
 |  | 2006 | on | All | 10000 / 12
 |  | 2009 | on | Petrol (1.6) | 10000 / 12
 |  | 2011 | on | Diesell (1.6) | 10000 / 12
 | Sportage | 1995 | 1998 | All | 6000 / 6
 |  | 1999 | 2005 | Facelift | 9000 / 12
 |  | 2005 | on | All | 10000 / 12
 |  | 2008 | on | Diesel | 12500 / 12
 |  | 2011 | on | Petrol 2.0 | 20000 / 12
 |  | 2011 | on | Diesel 2.0 | 20000 / 12
 |  | 2011 | on | Petrol 1.6 | 20000 / 12
 |  | 2011 | on | Diesel 1.7 | 20000 / 12
 | Sorento | 2003 | 2006 | All | 10000 / 12
 |  | 2006 | 2010 | All | 10000 / 12
 |  | 2010 | on | Petrol | 10000 / 12
 |  | 2010 | on | Diesel | 12500 / 12
 | Sedona | 1999 | 2001 | Diesel | 6000 / 12
 |  | 1999 | 2001 | Petrol | 9000 / 12
 |  | 2001 | 2006 | Diesel | 10000 / 12
 |  | 2001 | 2006 | Petrol | 10000 / 12
 |  | 2006 | on | All | 10000 / 12
 |  | 2010 | on | Diesel (2.2) | 10000 / 12
 | Soul | 2009 | on | Petrol | 10000 / 12
 |  | 2009 | on | Diesel | 12500 / 12
 | Venga | 2010 | on | Petrol | 12500 / 12
 |  | 2010 | on | Diesel | 20000 / 12
 | Note:  Dates refer to vehicle model year, not date of registration
Spreadsheet: 129232d1321508114-vertical-horizontal-reference-for-a-cell-vlookup-create-list-array
Sheet: Results

Account Code | Transaction Code | Amount | helper | helper
 |  |  |  |  |  | Note: array formula is used in column D & E and should be confirmed though Ctrl+Shift+Enter instead of Just Enter
 |  |  |  |  |  | Hide column D & E