tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gstorey__12048__NOV00
Sheet: Table1

NATURAL GAS EXPORTS - SUMMARY |  |  |  |  |  |  |  | Table 1
EXPORTATION DE GAZ NATUREL - SOMMAIRE
 |  | - - - - - - -Month/Mois- - - - - - |  | Variation |  | - - - - - - - Cumulative to date - - - - - - |  | Variation
 |  | 1999-11-01 00:00:00 | 2000-11-01 00:00:00 | % Change |  | 1999/11-1999/11 | 2000/11-2000/11 | % Change
Volume (Millions M3) | Long-term / Long terme | 2038.4 | 1974.4 | -0.031 |  | 2038.4 | 1974.4 | -0.031
 | Short-term / Court terme | 6191 | 7235.2 | 0.169 |  | 6191 | 7235.2 | 0.169
 | Total | 8229.4 | 9209.5 | 0.119 |  | 8229.4 | 9209.5 | 0.119
Revenue/Recettes (Millions $[NAME]) | Long-term / Long terme | 305.3 | 467.8 | 0.532 |  | 305.3 | 467.8 | 0.532
 | Short-term / Court terme | 887.6 | 1883.2 | 1.122 |  | 887.6 | 1883.2 | 1.122
 | Total | 1193 | 2351 | 0.971 |  | 1193 | 2351 | 0.971
Avg. price/Prix moyen ($CDN/GJ) | Long-term / Long terme | 3.95 | 6.26 | 0.583 |  | 3.95 | 6.26 | 0.583
 | Short-term / Court terme | 3.78 | 6.86 | 0.815 |  | 3.78 | 6.86 | 0.815
 | Total | 3.82 | 6.73 | 0.761 |  | 3.82 | 6.73 | 0.761
Volume (BCF) | Long-term / Long terme | 72 | 69.7 | -0.031 |  | 72 | 69.7 | -0.031
 | Short-term / Court terme | 218.5 | 255.4 | 0.169 |  | 218.5 | 255.4 | 0.169
 | Total | 290.5 | 325.1 | 0.119 |  | 290.5 | 325.1 | 0.119
Revenue/Recettes (Millions $US) | Long-term / Long terme | 208.1 | 303.3 | 0.458 |  | 208.1 | 303.3 | 0.458
 | Short-term / Court terme | 604.9 | 1221.1 | 1.019 |  | 604.9 | 1221.1 | 1.019
 | Total | 813 | 1524.4 | 0.875 |  | 813 | 1524.4 | 0.875
Avg. price/Prix moyen ($US/MMBTU) | Long-term / Long terme | 2.89 | 4.36 | 0.506 |  | 2.89 | 4.36 | 0.506
 | Short-term / Court terme | 2.76 | 4.77 | 0.727 |  | 2.76 | 4.77 | 0.727
 | Total | 2.8 | 4.68 | 0.675 |  | 2.8 | 4.68 | 0.675
Spreadsheet: 116731d1312082136-conditional-format-question-conditional-format
Sheet: Sheet1

1 | 53885.04 | 2009-07-30 00:00:00 | 60 Years Old | 2010-07-01 00:00:00 |  |  |  |  |  | 0.03 | 12
2 |  | 2010-07-30 00:00:00 | 61 Years Old | 2011-07-01 00:00:00 |  |  | 7368
3 | 57301.56 | 2011-07-30 00:00:00 | 62 Years Old | 2012-07-01 00:00:00 | 1812
4 |  | 2012-07-30 00:00:00 | 63 Years Old | 2013-07-01 00:00:00
5 |  | 2013-07-30 00:00:00 | 64 Years Old | 2014-07-01 00:00:00
6 |  | 2014-07-30 00:00:00 | 65 Years Old | 2015-07-01 00:00:00
7 |  | 2015-07-30 00:00:00 | 66 Years Old | 2016-07-01 00:00:00
8 |  | 2016-07-30 00:00:00 | 67 Years Old | 2017-07-01 00:00:00
9 |  | 2017-07-30 00:00:00 | 68 Years Old | 2018-07-01 00:00:00
10 |  | 2018-07-30 00:00:00 | 69 Years Old | 2019-07-01 00:00:00
11 |  | 2019-07-30 00:00:00 | 70 Years Old | 2020-07-01 00:00:00 |  | 6000
12 |  | 2020-07-30 00:00:00 | 71 Years Old | 2021-07-01 00:00:00 |  | 6000
13 |  | 2021-07-30 00:00:00 | 72 Years Old | 2022-07-01 00:00:00 |  | 6000
14 |  | 2022-07-30 00:00:00 | 73 Years Old | 2023-07-01 00:00:00 |  | 6000
15 |  | 2023-07-30 00:00:00 | 74 Years Old | 2024-07-01 00:00:00 |  | 6000
16 |  | 2024-07-30 00:00:00 | 75 Years Old | 2025-07-01 00:00:00 |  | 6000
17 |  | 2025-07-30 00:00:00 | 76 Years Old | 2026-07-01 00:00:00 |  | 6000
18 |  | 2026-07-30 00:00:00 | 77 Years Old | 2027-07-01 00:00:00 |  | 6000
19 |  | 2027-07-30 00:00:00 | 78 Years Old | 2028-07-01 00:00:00 |  | 6000
20 |  | 2028-07-30 00:00:00 | 79 Years Old | 2029-07-01 00:00:00 |  | 6000
21 |  | 2029-07-30 00:00:00 | 80 Years Old | 2030-07-01 00:00:00 |  | 6000
22 |  | 1930-07-30 00:00:00 | 81 Years Old | 2031-07-01 00:00:00 |  | 6000
23 |  | 1931-07-30 00:00:00 | 82 Years Old | 2032-07-01 00:00:00 |  | 6000
24 |  | 1932-07-30 00:00:00 | 83 Years Old | 2033-07-01 00:00:00 |  | 6000
25 |  | 1933-07-30 00:00:00 | 84 Years Old | 2034-07-01 00:00:00 |  | 6000
Spreadsheet: 816728d1675794674-conditional-formatting-based-on-two-cells-matching-using-a-different-range-year-planner-annual-leave-planner
Sheet: Annual leave

 | No. of days worked: | Start date: | End date: | Calculated entitlement:
 |  |  |  |  |  |  | LEAVE CALCULATOR:
 |  |  |  |  |  |  | Year start: | 2023
 |  |  |  |  |  |  | Year end:
 |  |  |  |  |  |  | Number of days in year:
 |  |  |  |  |  |  | Current entitlement: |  | 20
 |  |  |  |  |  |  | Round up/down by: |  | 0.5
 |  |  |  |  |  | INSTRUCTION FOR THIS TAB:
 |  |  |  |  |  | When starting a planner for a new annual leave year, first change the year in the green cell next to 'Year start'.
 |  |  |  |  |  | If the entitlement for apprentices changes, you can amend it in the green cell next to 'Current entitlement'.
 |  |  |  |  |  | The entitlement is calculate pro-rata based on the start and end date of the apprentice, while calculating the total number of days that apprentice works in the annual leave year you've specified.
 |  |  |  |  |  | The calculation is always rounded up to the nearest 1/2 day. e.g. If the calculation works out that the apprentice has 18.4 days of annual leave, it will be rounded up to 18.5.
 |  |  |  |  |  | The data in the columns on the left are dynamic so you don't need to amend them. They will update based on the information you put in green cells of the 'Planner' tab.
Spreadsheet: errol_mclaughlin_jr__10064__Bkrqs775
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request # 775
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [NAME] | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
LT-PLANT-HDG | Long Term Plant Hedge | X |  |  | =P | DESK | X |  |  |  |  | NG/MMBTU/USD | [NAME] | MTM | [NAME] | ASAP
FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
trohaue | [NAME] |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JV
emclaug |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JV
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JV
kloibl |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JV
bbajwa |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JV
 |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact me:
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
Spreadsheet: 845234d1696754208-help-with-count-unique-date-time-within-a-range-1-month-unique-datetime-count
Sheet: Sheet1

 | SAMPLE DATA |  |  |  | TODAY |  |  | SHOULD OUTPUT
 | date / time | [NAME] | data2 |  |  |  |  | Unique Time Stamp
 | 2023-12-01 01:00:00 | 123 | 0 |  |  |  |  | 5 | data row
 | 13/1/2023 11:02:00 AM | abc | Apple |  | Between | And
 | 13/1/2023 11:02:00 AM | def | Detergent |  | 13/1/2023 1:00:00 AM | 13/2/2023 1:00:00 AM |  | date/time | [NAME] | data2
 | 13/1/2023 11:50:00 AM | ghi | Grape |  |  |  |  | 13/1/2023 11:02:00 AM | abc | Apple
 | 13/1/2023 11:50:00 AM | jkl | Juice |  |  |  |  | 13/1/2023 11:02:00 AM | def | Detergent
 | 15/1/2023 2:02:00 AM | mno | Melon |  |  |  |  | 13/1/2023 11:50:00 AM | ghi | Grape
 | 15/1/2023 2:02:00 AM | pqr | Rocket |  |  |  |  | 13/1/2023 11:50:00 AM | jkl | Juice
 | 31/1/2023 5:45:00 PM | stu | Toad |  |  |  |  | 15/1/2023 2:02:00 AM | mno | Melon
 | 2023-09-02 01:55:00 | vwx | Water |  |  |  |  | 15/1/2023 2:02:00 AM | pqr | Rocket
 | 29/2/2023 5:45:00 PM | yz | Zippo |  |  |  |  | 31/1/2023 5:45:00 PM | stu | Toad
 |  |  |  |  |  |  |  | 2023-09-02 01:55:00 | vwx | Water
 |  |  |  |  |  |  |  | Unique Time Stamp
 |  |  |  |  |  |  |  |  | data row
 |  |  |  |  |  |  |  | date/time | [NAME] | data2
Spreadsheet: 544689d1509002787-formula-required-to-extrapolate-values-test-excel-forum
Sheet: Sample

 |  | DATE | 2017-05-01 00:00:00 | 2017-05-02 00:00:00 | 2017-05-03 00:00:00 | 2017-05-04 00:00:00 | 2017-05-05 00:00:00 | 2017-05-06 00:00:00 | 2017-05-07 00:00:00 | 2017-05-08 00:00:00 | 2017-05-09 00:00:00 | 2017-05-10 00:00:00 | 2017-05-11 00:00:00 | 2017-05-12 00:00:00 | 2017-05-13 00:00:00 | 2017-05-14 00:00:00 | 2017-05-15 00:00:00 | 2017-05-16 00:00:00 | 2017-05-17 00:00:00 | 2017-05-18 00:00:00 | 2017-05-19 00:00:00 | 2017-05-20 00:00:00 | 2017-05-21 00:00:00 | 2017-05-22 00:00:00 | 2017-05-23 00:00:00 | 2017-05-24 00:00:00 | 2017-05-25 00:00:00 | 2017-05-26 00:00:00 | 2017-05-27 00:00:00 | 2017-05-28 00:00:00 | 2017-05-29 00:00:00 | 2017-05-30 00:00:00 | 2017-05-31 00:00:00 | 2017-06-01 00:00:00 | 2017-06-02 00:00:00 | 2017-06-03 00:00:00 | 2017-06-04 00:00:00 | 2017-06-05 00:00:00 | 2017-06-06 00:00:00 | 2017-06-07 00:00:00 | 2017-06-08 00:00:00 | 2017-06-09 00:00:00 | TOTAL
 |  | Order No==> |  |  |  |  | 2017/0171 |  |  | 2017/0172 |  |  | 2017/0173 |  | 2017/0174 & 0175 |  | 2017/0176 |  |  | 2017/0177 | 2017/0178 | 2017/0179 |  | 2017/0180 |  |  | 2017/0181 | 2017/0182 | 2017/0183 | 2017/0184 | 2017/0185 |  |  | 2017/0186 | 2017/0187 | 2017/0188 | 2017/0189 | 2017/0190 |  |  | 2017/0191
 |  | USA |  |  |  |  | 1600 |  |  |  |  |  |  |  | 1300 |  | 1700 |  |  | 800 |  |  |  | 1100 |  |  | 1900 |  | 750 |  | 650 |  |  | 500 | 500 | 1000 |  | 1300 |  |  | 650
 |  | UK |  |  |  |  |  |  |  |  |  |  |  |  | 400 |  |  |  |  |  |  |  |  | 500 |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  | 850
 |  | CAN |  |  |  |  | 500 |  |  |  |  |  |  |  | 500 |  |  |  |  | 500 |  |  |  | 1500 |  |  | 350 |  | 500 |  |  |  |  | 550 |  |  |  |  |  |  | 350
 |  | SWZ |  |  |  |  | 500 |  |  |  |  |  | 950 |  |  |  |  |  |  | 800 |  |  |  | 1000 |  |  |  |  | 500 |  |  |  |  |  |  | 800
 |  | DEN
 |  | BEL |  |  |  |  |  |  |  | 850 |  |  |  |  |  |  | 400
 |  | ITL |  |  |  |  | 1850 |  |  |  |  |  | 1550 |  | 300 |  |  |  |  | 1600 |  |  |  |  |  |  |  |  |  | 1400 |  |  |  | 1200 |  |  |  | 850 |  |  | 1300
 |  | TOTAL
 |  |  |  | [NAME] (Required Results) thru formulas in Cells F20:H26
 |  |  |  | Country | Order No | Order Date | Order QTY
 |  |  |  | USA
 |  |  |  | UK
 |  |  |  | CAN
 |  |  |  | SWZ
 |  |  |  | DEN
 |  |  |  | BEL
 |  |  |  | ITL
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: NB-Cheque

1-001 National Bank - Cheque
Date | Ref. | Details | Debit |  | Date | Ref. | Details | Credit
2008-12-08 00:00:00 | 3-501 | Income - StudyLink | 184.17 |  | 2008-12-01 00:00:00 | 3-001 | Balance b/f | 967.17
2008-12-16 00:00:00 | 3-501 | Income - StudyLink | 184.17 |  | 2008-12-08 00:00:00 | 2-001 | National Bank - Visa | 10
2008-12-23 00:00:00 | 3-501 | Income - StudyLink | 184.17 |  |  | 4-001 | Grocery | 30.26
 |  |  |  |  | 2008-12-10 00:00:00 | 4-002 | Genesis - Power | 35
 |  |  |  |  | 2008-12-11 00:00:00 | 2-501 | Loan - J Mugot | 50
 |  |  |  |  | 2008-12-12 00:00:00 | 4-001 | Grocery | 22.45
 |  |  |  |  | 2008-12-15 00:00:00 | 4-001 | Grocery | 13.23
 |  |  |  |  | 2008-12-16 00:00:00 | 2-001 | National Bank - Visa | 10
 |  |  |  |  | 2008-12-17 00:00:00 | 4-002 | Genesis - Power | 35
 |  |  |  |  |  | 4-001 | Grocery | 13.8
 |  |  |  |  | 2008-12-19 00:00:00 | 2-501 | Loan - J Mugot | 50
 |  |  |  |  | 2008-12-19 00:00:00 | 4-001 | Grocery | 13.43
 |  |  |  |  | 2008-12-22 00:00:00 | 4-001 | Grocery | 25.7
 |  |  |  |  | 2008-12-23 00:00:00 | 2-001 | National Bank - Visa | 10
 |  |  |  |  |  | 4-001 | Grocery | 12.49
 |  |  |  |  | 2008-12-24 00:00:00 | 4-002 | Genesis - Power | 35
 |  |  |  |  |  | 4-003 | Petrol | 20
 |  |  |  |  | 2008-12-25 00:00:00 | 2-501 | Loan - J Mugot | 50
 |  |  |  |  | 2008-12-27 00:00:00 | 4-001 | Grocery | 6.89
 |  | Total | 552.51 |  |  |  | Total | 1410.42
 |  | Balance |  |  |  |  | Balance | 857.9100000000001
Spreadsheet: 65118d1265847665-vlookup-with-potential-for-multiple-matches-mail-test
Sheet: Team R

Emp Name | ID | CN 1 | CN 2 | CN 3 | CN 4 | CN 5
 | LD0P | #N/A | #N/A | #N/A | #N/A | #N/A
 | MKNB | should equal Mail! [NAME] | should equal Mail! C5
 | MMFV
 | [NAME]
 | LWWB
 | DZ8L
 | MQFR
 | L7C6
 | LTKP
 | MP3V
 | MDNY
 | [NAME]
 | [NAME]
 | LLPX
 | LS9H
 | MX5M
 | L3NM
 | LXCR
 | MP43
 | MQSY
 | LPC1
 | L4RF
 | MKPM
 | MS9D
 | MRGP
 | MKM8
 | MGFN
 | LTHS
 | L79Y
 | LXLT
 | L069
 | MTK8
 | MX5N
Spreadsheet: e83083d5-5e1b-4ad9-87d3-638b858da112
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
42452234 | 2014-07-25 22:24:00 | AXIS | 1 | 4 | 3 | 418850 | SIR B LAW | 6151 | western | 1944-07-21 | 1944-07-21 | [NAME] | [NAME]
42452428 | 2014-07-25 22:48:16 | ALLIES | 1 | 6 | 2 | 1604880 | 22lecruel | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
42452722 | 2014-07-25 23:16:38 | AXIS | 0 | 3 | 6 | 1604880 | 22lecruel | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 840156d1692505130-put-equal-greater-and-nearest-value-and-get-the-reference-document-for-the-bunch-of-data-customer-order-vs-job-order
Sheet: Sheet1

Model Number | Customer Order1 | Due Date Day | Orig Qty | Qty Accum | Job Accum Qty | Reference |  |  | Model Number | Order | Orig Qty | Accum
AJA16 | 462-8-87 | 2023-08-21 00:00:00 | 27750 | 27750 | 110988 | On Hand |  |  | AJA16 | On Hand Stock | 110988 | 110988
AJA16 | 462-8-88 | 2023-08-28 00:00:00 | 16279 | 44029 | 110988 | On Hand |  |  | AJA16 | Job1 | 123000 | 233988
AJA16 | 462-8-89 | 2023-09-04 00:00:00 | 38000 | 82029 | 110988 | On Hand |  |  | AJA16 | Job2 | 152004 | 385992
AJA16 | 462-8-90 | 2023-09-11 00:00:00 | 38000 | 120029 | 233988 | Job1 |  |  | AJA16 | Job3 | 152004 | 537996
AJA16 | 462-8-91 | 2023-09-18 00:00:00 | 38000 | 158029 | 233988 | Job1 |  |  | AJA16 | Job4 | 152004 | 690000
AJA16 | 462-8-92 | 2023-09-25 00:00:00 | 38000 | 196029 | 233988 | Job1 |  |  | AAB0015-0 | On Hand Stock | 60 | 60
AJA16 | 462-8-93 | 2023-10-02 00:00:00 | 38000 | 234029 | 385992 | Job2 |  |  | AAB0015-0 | PLN   6 | 3950 | 4010
AJA16 | 462-8-94 | 2023-10-09 00:00:00 | 38000 | 272029 | 385992 | Job2 |  |  | AAB0015-0 | PLN   7 | 6000 | 10010
AJA16 | 462-8-95 | 2023-10-16 00:00:00 | 38000 | 310029 | 385992 | Job2 |  |  | AAB0015-0 | PLN   8 | 6000 | 16010
AJA16 | 462-8-96 | 2023-10-23 00:00:00 | 38000 | 348029 | 385992 | Job2
AJA16 | 462-8-97 | 2023-10-30 00:00:00 | 38000 | 386029 | 537996 | Job3
AJA16 | 462-8-98 | 2023-11-06 00:00:00 | 36000 | 422029 | 537996 | Job3
AJA16 | 462-8-99 | 2023-11-13 00:00:00 | 36000 | 458029 | 537996 | Job3
AJA16 | 62-8-100 | 2023-11-20 00:00:00 | 36000 | 494029 | 537996 | Job3
AJA16 | 62-8-101 | 2023-11-27 00:00:00 | 36000 | 530029 | 537996 | Job3
AJA16 | 62-8-102 | 2023-12-04 00:00:00 | 35000 | 565029 | 690000 | Job4
AJA16 | 62-8-103 | 2023-12-11 00:00:00 | 35000 | 600029 | 690000 | Job4
AJA16 | 62-8-104 | 2023-12-18 00:00:00 | 35000 | 635029 | 690000 | Job4
AJA16 | 62-8-105 | 2023-12-25 00:00:00 | 35000 | 670029 | 690000 | Job4
AJA16 | 62-8-106 | 2024-01-01 00:00:00 | 35000 | 705029
AJA16 | 62-8-107 | 2024-01-08 00:00:00 | 35000 | 740029
AJA16 | 62-8-108 | 2024-01-15 00:00:00 | 35000 | 775029
AAB0015-0 | 351 | 2023-10-20 00:00:00 | 4000 |  | 4010 | PLN6
AAB0015-0 | 355 | 2023-11-17 00:00:00 | 3000 |  | 10010 | PLN7
AAB0015-0 | 365 | 2023-11-17 00:00:00 | 3000 |  | 10010 | PLN7
AAB0015-0 | 389 | 2023-12-08 00:00:00 | 3000 |  | 16010 | PLN8
AAB0015-0 | 392 | 2023-12-08 00:00:00 | 3000 |  | 16010 | PLN8
Spreadsheet: 112566d1308672165-help-with-timesheets-and-time-formats-timesheet
Sheet: ts

 | Pay Period: |  |  | to
WEEK1
Day | Date | Morning |  | Afternoon |  | Evening |  | TIL taken | TOTAL HRS | Leave
 |  | Start | Finish | Start | Finish | Start | Finish
Monday | 2011-05-02 00:00:00 | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Tuesday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Wednesday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Thursday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Friday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Saturday
Sunday
 |  |  |  |  |  | Week 1 totals
WEEK 2
Day | Date | Start | Finish | Start | Finish | Start | Finish | TIL taken | TOTAL HRS | Leave
Monday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Tuesday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Wednesday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Thursday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Friday |  | 08:30:00 | 13:00:00 | 13:30:00 | 17:00:00
Saturday
Sunday
 |  |  |  |  |  | Week 2 totals
 |  |  |  |  |  | Total of Actual Hours Worked
 |  |  |  |  |  | Total Hours to be paid |  |  | 76
 |  |  |  |  |  | Ordinary Hours to be paid
 |  |  |  |  |  | Hours in Lieu Taken & Paid
 |  |  |  |  |  | Hours in [NAME]
 |  |  |  |  |  | Hours in Lieu Remaining
SIGNED:  …………………………………………………….……..…..   DATE:     ………………...….
APPROVED: ………………....………………………………………..    DATE:     .……………………
Spreadsheet: 143971d1330643302-vertical-expanding-scatter-graph-inclinometer-graphs
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  | Depth
 |  |  |  |  |  |  |  |  |  |  |  | 0.5
Spreadsheet: 398195d1433031477-index-match-with-multiple-criteria-exact-for-text-and-greater-than-value-for-number-excel-help
Sheet: Sheet1

 |  | Origin | Destination | Weight | Cost |  |  | Origin | Destination | Weight | Cost
 |  | A | B | 0.5 | 1 |  |  | A | B | 1.2
 |  | A | B | 1 | 2 |  |  | A | C | 0.3
 |  | A | B | 1.5 | 3
 |  | A | C | 0.5 | 10
 |  | A | C | 1 | 20
 |  | A | C | 1.5 | 30
Spreadsheet: 85882d1285883028-sum-a-range-based-on-information-from-two-different-columns-test
Sheet: Sheet1

From | To | Distance |  | From | To | Distance
A | B | 308.8 |  | A | F
B | C | 1009.1 |  | F | K
C | D | 1080.8
D | E | 2079.8
E | F | 759.9
F | G | 1092.4
G | H | 516.1
H | I | 712.6
I | J | 813.8
J | K | 381.4
Spreadsheet: 538561d1505714572-multi-page-order-sheet-with-summary-page-oeldere-multi-page-
Sheet: Engineered

Item # | [NAME] | Description
0132-0001 |  | MICROLLAM 2.0E;1-3/4" x 5-1/2"
0132-0002 |  | MICROLLAM 2.0E;1-3/4" x 7-1/4"
0132-0003 |  | MICROLLAM 2.0E;1-3/4" x 9-1/4"
0132-0004 |  | MICROLLAM 2.0E;1-3/4" x 9-1/2"
0132-0006 |  | MICROLLAM 2.0E;1-3/4" x 11-7/8"
0132-0007 |  | MICROLLAM 2.0E;1-3/4" x 14"
0132-0008 |  | MICROLLAM 2.0E;1-3/4" x 16"
0132-0009 |  | MICROLLAM 2.0E;1-3/4" x 18-3/4"
0133-0003 |  | PARALLAM 3 1/2" X 3;1/2" 1.8E
0133-0004 |  | PARALLAM 1.8E;5 1/4" X 3-1/2"
0133-0005 |  | PARALLAM 3 1/2" X 7";1.8E
0133-0006 |  | PARALLAM 3-1/2 x;9-1/4"  2.2E
0133-0007 |  | PARALLAM 3 1/2" X 9;1/2" 2.2E
0133-0008 |  | PARALLAM 3 1/2" X 11;7/8" 2.2E
0133-0009 |  | PARALLAM 3 1/2" X 14";2.2E
0133-0010 |  | PARALLAM 3 1/2" X 16";2.2E
0133-0012 |  | PARALLAM 1.8E;5 1/4" X 5 1/4"
0133-0013 |  | PARALLAM 1.8E;5 1/4" X 7"
0133-0014 |  | PARALLAM 2.2E;5 1/4" X 9-1/4"
0133-0015 |  | PARALLAM 2.2E;5 1/4" X 9 1/2"
0133-0016 |  | PARALLAM 2.2E;5 1/4" X 11 7/8"
0133-0017 |  | PARALLAM 2.2E;5 1/4" X 14"
0133-0018 |  | PARALLAM 2.2E;5 1/4" X 16"
0133-0019 |  | PARALLAM 2.2E;5 1/4" X 19"
0133-0020 |  | PARALLAM 7 x  7";1.8E
0133-0021 |  | PARALLAM 7 x  9-1/4";2.2E
0133-0022 |  | PARALLAM 7" X 9 1/2";2.2E
0133-0023 |  | PARALLAM 7" X 11 7/8";2.2E
0133-0024 |  | PARALLAM 7" X 14" 2.2E;
0133-0025 |  | PARALLAM 7" X 16" 2.2E;
0133-0026 |  | PARALLAM 7" X 19" 2.2E;
0133-0027 |  | PARALLAM 3-1/2" x 11-1/4;2.2E
0133-0028 |  | PARALLAM 2.2E;5 1/4" X 11-1/4"
0133-0029 |  | PARALLAM 7" x 11-1/4";2.2E
0134-0008 |  | RIMBOARD 1-1/4"x9-1/2";x16'
0134-0009 |  | RIMBOARD 1-1/4"x11-7/8";x16'
0134-0010 |  | RIMBOARD 1-1/4"x14"x16';1.3E
0134-0011 |  | RIMBOARD 1-1/4"x16"x16';1.3E
0134-0012 |  | RIMBOARD 1-1/8"x9-1/2";x12' ILEVEL
0134-0013 |  | RIMBOARD 1-1/8"x11-7/8";x12' ILEVEL
0134-0014 |  | RIMBOARD 1-1/8"x14";x12' ILEVEL
0134-0015 |  | RIMBOARD 1-1/8"x16"x12';ILEVEL
0135-0003 |  | TIMBERSTRAND 3 1/2" X 9;1/2"
0135-0004 |  | TIMBERSTRAND 3 1/2" X;11 7/8"
0135-0006 |  | TIMBERSTRAND 1 3/4" X 9;1/2"
0135-0007 |  | TIMBERSTRAND 1 3/4" X;11 7/8"
0135-0017 |  | SIMPSON SHEAR BRACE;24" X 12' SB2412
0135-0018 |  | SIMPSON SHEAR BRACE;18" X 12' SB1812
0135-0020 |  | SIMPSON SHEAR BRACE;24" X 20' SB2420
0136-0004 |  | TJI 230 9 1/2";
0136-0005 |  | TJI 230 11 7/8";
0136-0006 |  | TJI 230 14";
0136-0011 |  | TJI 360 9 1/2";
0136-0012 |  | TJI 360 11-7/8";
0136-0018 |  | TJI 560 9 1/2";
0136-0019 |  | TJI 560 11-7/8";
0136-0020 |  | [NAME] 14";
0136-0022 |  | [NAME] 16"PRO
0136-0026 |  | TJI 230 16";
Spreadsheet: 170044d1343145831-looking-to-get-rows-in-order-top-8-then-alphabetical-copycopy
Sheet: Tues-21-08-12

sold
Totals
Totals
Page Totals
 | 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 |  | 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 |  | 0
Page Totals
 | 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 |  | 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 |  | 0
 | 0 |  | 0 |  | 0
Page Totals
Other Grand Totals
Spreadsheet: 826692d1682169838-data-formatting-example-a
Sheet: Required Result

ARTA1 | STORE NO. 1 | STORE NO. 2
ARTA2 | STORE No.5 | STORE No.6 | STORE No.7 | STORE No.8 | STORE No.9 | STORE No.1 | STORE No.2 | STORE No.3
ARTA3 | STORE No.14 | STORE No.15 | STORE No.16 | STORE No.17 | STORE No.18 | STORE No.19 | STORE No.20 | STORE No.5 | STORE No.6 | STORE No.7
Spreadsheet: 97333d1296556299-how-to-prevent-date-format-change-book1_rowrow
Sheet: Sheet1

ID | Fruit | Colour | Condition | Date | helper Column
2 | orange | orange | rotten | 2010-08-22 00:00:00 | Aug
4 | lime | green | good | 2007-01-20 00:00:00 | Jan
1 | apple | red | ripe | 2011-01-17 00:00:00 | Jan
5 | grapes | green | good | 2011-01-23 00:00:00 | Jan
3 | papaya | orange | bad | 2008-03-02 00:00:00 | Mar
Spreadsheet: 86691d1286645188-excel-2007-using-indirect-index-and-random-number-to-harvest-data-from-worksheets-book1
Sheet: Sheet2

 | random number | index number | Data | Data 2 | Return
 |  | 1 | [NAME] | * | i
 |  | 2 | [NAME] | ** | j
 |  | 3 | [NAME] | *** | k
 |  | 1 | [NAME] | * | l
 |  | 2 | [NAME] | ** | m
 |  | 3 | [NAME] | *** | n
Spreadsheet: 489919d1479491698-excel-sheet-macro-aa-sj
Sheet: Raw Data

Clients | Visits
ABC | 2
CDE | 2
XYZ | 0
DEF | 5
ZZZ | 15 | Omitted in Final Report
ABC | 15
YYY | 22 | Omitted in Final report
CDE | 25
XYZ | 0
DEF | 45