tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gstorey__12094__EOL Summary
Sheet: points

AlgonqinCtyGate | East
ANR SE Gath | Central
ANR SE Trans | Central
ANR SW Pool | Central
APC/ANR WillCo | Central
APC/VPC WillCo | Central
Carthage | East
[NAME] | West
[NAME] | Central
ChiPeoplesIntra | Central
CIG Mainline | West
CNG NP TT | East
CNG SP TT | East
COL Mainline | East
COL Onshore | East
Consumers Pwr | Central
Dom SP TT | East
[NAME] | West
EPNG Keystone | West
EPNG [NAME] | West
ExxonKaty | Texas
[NAME] | East
Harper | Central
HeHub | East
[NAME] | East
[NAME] | Central
NBPL/ANR WillCo | Central
NBPL/Nicor | Central
NBPL/Ventura | Central
NGPL AmarilloML | Central
NGPL IA-IL | Central
NGPL LA Intra | Central
NGPL LA Pool | Central
NGPL MidC Intra | Central
NGPL Midcont | Central
NGPL N Shore | Central
NGPL NICOR | Central
NGPL NIPSCO | Central
NGPL S TX Intra | Central
NGPL STX | Central
NGPL TxOk Intra | Central
NGPL TxOkGCPool | Central
NNG Demarc | Central
NNG Ventura | Central
NWPL RkyMtn Pool | West
NWPL SanJuan Pool | West
NWPL Wyoming Pool | West
OGT | Central
Opal | West
PEPL Pool | Central
PG&E CtyGte | West
PG&E Daggett | West
PG&E Topock | West
PGT Malin | West
PGT Malin | West
PGT Stanfield | West
SoCal EHR | West
[NAME] | West
[NAME] | West
SoCal TW Needles | West
[NAME] | West
SONAT Z-0 Tier2 Pool | East
TCO Pool | East
TENN 500 | East
TENN 800 | East
TENN Dracut | East
[NAME] | East
TETCO ELA | East
TETCO M3 | East
TETCO STX | East
TETCO WLA | East
TGT Z-SL | East
Transco St.65 | East
[NAME] NY | East
TranscoZ6NNY | East
Trunkline ELA | Central
Trunkline NTX | Central
Trunkline STX | Central
Trunkline WLA | Central
Waha | Texas
WIC | West
Spreadsheet: 874371d1720964925-calculate-monthly-costs-based-on-start-and-end-dates-calculate-monthly-costs-based-on-start-and-end-dates
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 0.138
 |  |  | 37.5 |  |  |  |  |  | 0.07 | 9096 |  | 189.84
Name | Start Date | End Date | FTE Salary | ACTUAL Hrs | Actual Salary | [NAME] | Project | Actual [NAME] by Project | Pension by Project | NIC | NIC Project | HSF by Project | Total Cost by Project |  | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
Employee A | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 22.5 |  | 3.75 | D05
Employee A | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 22.5 |  | 11.25 | R4401
Employee A | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 22.5 |  | 7.5 | R4402
Employee B | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 37.5 | R62
Employee C | 2024-04-01 00:00:00 | 2024-05-31 00:00:00 | 33366 | 37.5 |  | 37.5 | R36
Employee D | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 15 | U05
Employee D | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 22.5 | U11
Employee E | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 26.25 |  | 18.75 | R36
Employee E | 2024-06-17 00:00:00 | 2025-03-31 00:00:00 | 33366 | 26.25 |  | 7.5 | R76
Employee F | 2024-04-01 00:00:00 | 2024-05-30 00:00:00 | 33366 | 30 |  | 30 | R4105
Employee F | 2024-06-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 30 |  | 7.5 | R4105
Employee F | 2024-06-01 00:00:00 | 2025-03-31 00:00:00 | 33366 | 30 |  | 22.5 | R89
Employee G | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 30 |  | 30 | R21
Employee H | 2024-04-01 00:00:00 | 2024-05-31 00:00:00 | 24790 | 37.5 |  | 37.5 | U11
Employee I | 2024-09-01 00:00:00 | 2025-03-31 00:00:00 | 25584 | 37.5 |  | 37.5 | U11
Employee J | 2024-09-01 00:00:00 | 2025-03-31 00:00:00 | 41511 | 37.5 |  | 37.5 | U11
Spreadsheet: 746424d1630697059-problem-with-number-of-nested-ifs-excel-quitting-calculation-after-45-ertm-sample-_jt
Sheet: Sheet1

LONG/SHORT | STOCK/FUTURES | JANUARY |  |  |  |  |  |  |  |  | LONG |  |  | EMD | 100
 |  | BEGINNING BALANCE: |  |  |  | 10000 |  |  |  |  | SHORT |  |  | ES | 50
 |  |  |  | ENTRY | EXIT | P/L | P/L % |  |  |  | FUTURES |  |  | GC | 100
LONG | FUTURES | NK | 1 | 1100 | 1000 |  |  | JosephTeh |  |  | OPTIONS |  |  | GE | 2500
LONG | FUTURES | NK | 1 | 1100 | 1000 |  |  | JohnTopley |  |  | STOCK |  |  | HE | 40000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HG | 25000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LE | 40000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NK | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NQ | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  | PL | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SI | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | TF | 100
ES |  |  |  |  |  |  |  |  |  |  |  |  |  | YM | 5
NQ |  |  |  |  |  |  |  |  |  |  |  |  |  | ZB | 100
YM |  |  |  |  |  |  |  |  |  |  |  |  |  | ZC | 50
TF |  |  |  |  |  |  |  |  |  |  |  |  |  | ZF | 1000
EMD |  |  |  |  |  |  |  |  |  |  |  |  |  | ZN | 1000
NK |  |  |  |  |  |  |  |  |  |  |  |  |  | ZS | 50
GC |  |  |  |  |  |  |  |  |  |  |  |  |  | ZT | 1000
HG
PL
SI
LE
HE
ZC
ZS
ZW
ZL
ZM
ZO
CL
NG
HO
RB
Spreadsheet: 801311d1666170981-merging-3-sheets-to-one-then-using-filter-function-example-attached-excel-help-3
Sheet: Sheet3

Name | Position | State | Type | Done
CC | EN | VIC | New | No
CB | EN | VIC | Var | Yes
CC | RN | VIC | New | Yes
CD | RN | VIC | New | Yes
CE | EN | VIC | Var | Yes
CF | MR | VIC | Var | No
CG | EN | VIC | New | No
CH | MR | VIC | New | No
CI | RN | ACT | New | Yes
CJ | RN | ACT | Var | Yes
CK | MR | ACT | New | No
CL | RN | ACT | New | Yes
CM | RN | ACT | New | Yes
CN | MR | ACT | New | No
CO | MR | ACT | Var | Yes
CP | RN | ACT | Var | No
CQ | MR | ACT | New | No
CR | EN | NSW | New | No
CS | RN | NSW | New | No
CT | RN | NSW | New | No
Spreadsheet: 220812d1363272258-formatting-display-problem-wip-sales-order-form
Sheet: Sheet1

30 / 32 Blyth Road,   [NAME],   Middlesex,   UB3 1BY |  |  |  |  |  |  | Pro Forma Invoice Number
Telephone:  +44 (0)20 8867-3500       Fax:  +44 (0)20 8573-9090
E-mail:  [EMAIL]
Invoice Address |  |  |  |  | Delivery Address
Customer  Order No. | +WHITE!B15 |  |  |  | Invoice Date
Product Code |  | Description / Information |  |  |  | Qty | Unit Price | Discount | Total
 |  | Carriage
All goods are supplied according to our Terms & Conditions which |  |  |  |  |  | Sub Total
are available on request. |  |  |  |  |  | VAT @ 20%
Please note: goods will only be despatched when payment has |  |  |  |  |  | Total
been received.
This is not a VAT invoice; a VAT invoice will be issued on despatch of the goods.
Bank: |  | National Westminster Bank Plc
 |  | 67 High Street,   Staines
 |  | Middlesex,   TW18 4PU
Account Number: |  | 15754898
Sort Code: |  | 55 - 50 - 39
IBAN: |  | GB48NWBK55503915754898
BIC Code: |  | NWBKGB2L
Spreadsheet: 1605fbcb-85b6-47c2-b6bf-55a3216d7bff
Sheet: Long Term FTR Historical Bids

Long Term FTR Auction Historical Bid Report
WW_FTRLT_ISO_<settlement date>_<version>.CSV
Period Starts <mm/dd/yyyy hh:[NAME]:ss> GMT And Ends <mm/dd/yyyy hh:[NAME]:ss> GMT
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Source Location Information |  |  | Sink Location Information |  |  | Price / Quantity Information
Source Location ID | Source Location Name | Source Location Type | Sink Location ID | Sink Location Name | Sink Location Type | Buy / Sell | Class Type | Bid MW | Bid Price | [NAME] | Masked Customer ID | Auction Name
Number | String | String | Number | String | String | String | String | MW | $/MW | String | Number | String
Spreadsheet: 722426d1615246205-help-with-search-formula-comparing-occurences-on-two-sheets-dgey-
Sheet: On site

Name | Date on site
user 1 | 2021-02-08 00:00:00
user 1 | 2021-01-15 00:00:00
user 1 | 2021-02-08 00:00:00
user 1 | 2021-01-29 00:00:00
user 1 | 2021-01-29 00:00:00
user 1 | 2021-01-26 00:00:00
user 1 | 2021-01-27 00:00:00
user 1 | 2021-02-04 00:00:00
user 1 | 2021-02-06 00:00:00
user 2 | 2021-01-16 00:00:00
user 2 | 2021-02-11 00:00:00
user 2 | 2021-02-13 00:00:00
user 2 | 2021-02-14 00:00:00
user 2 | 2021-02-15 00:00:00
user 2 | 2021-03-02 00:00:00
user 2 | 2021-01-27 00:00:00
user 2 | 2021-02-03 00:00:00
user 2 | 2021-02-17 00:00:00
user 3 | 2021-02-24 00:00:00
user 3 | 2021-03-03 00:00:00
user 3 | 2021-02-26 00:00:00
user 3 | 2021-02-01 00:00:00
user 3 | 2021-02-02 00:00:00
user 3 | 2021-02-02 00:00:00
user 3 | 2021-02-03 00:00:00
user 3 | 2021-02-04 00:00:00
user 4 | 2021-02-02 00:00:00
user 4 | 2021-02-05 00:00:00
user 4 | 2021-01-15 00:00:00
user 4 | 2021-02-05 00:00:00
user 4 | 2021-02-08 00:00:00
user 4 | 2021-02-12 00:00:00
user 4 | 2021-02-26 00:00:00
user 4 | 2021-01-29 00:00:00
user 4 | 2021-02-26 00:00:00
user 4 | 2021-01-29 00:00:00
user 5 | 2021-02-10 00:00:00
user 5 | 2020-12-31 00:00:00
user 5 | 2021-01-01 00:00:00
user 5 | 2021-01-15 00:00:00
user 5 | 2021-01-15 00:00:00
user 5 | 2021-01-18 00:00:00
user 5 | 2021-01-19 00:00:00
user 5 | 2021-01-21 00:00:00
user 5 | 2021-01-22 00:00:00
user 5 | 2021-01-25 00:00:00
user 6 | 2021-01-18 00:00:00
Spreadsheet: 715003d1611504033-formula-for-closing-balance-copie-de-forum-excel-24-jan-2021-aligw
Sheet: Projection

 | Last month | This month | [NAME] | février-2020 | mars-2020 | avril-2020 | mai-2020 | juin-2020 | juillet-2020 | août-2020 | septembre-2020 | octobre-2020 | novembre-2020 | décembre-2020 | janvier-2021 | février-2021 | mars-2021 | avril-2021 | mai-2021 | juin-2021 | juillet-2021 | août-2021 | septembre-2021 | octobre-2021 | novembre-2021 | décembre-2021 | janvier-2022 | [NAME] | mars-2022 | avril-2022 | mai-2022 | juin-2022 | juillet-2022 | août-2022 | septembre-2022 | octobre-2022 | novembre-2022 | décembre-2022
First date |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Last date |  |  | 2020-01-31 00:00:00 | 2020-02-29 00:00:00 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-31 00:00:00 | 2020-09-30 00:00:00 | 2020-10-31 00:00:00 | 2020-11-30 00:00:00 | 2020-12-31 00:00:00 | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00
Épargne et inv.  (défilé [NAME]) | Last month | This month | 2020-01-01 00:00:00
AR |  |  |  |  |  |  |  |  |  |  |  |  |  | 100
FT |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
PL
UR
 | Last month is now | This month is now
 | December 2020 | January 2021
 | but it will update | but it will update
 | as months go by | as months go by
Spreadsheet: 12370d15-4f88-48a5-bb7e-cbe78e94707a
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2012/13 |  |  |  | 2011/12 |  |  |  | 2012/13 |  |  |  | 2011/12
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 14 |  | 8208 |  | 12.4 |  | 9343 |  | 15.9 |  | 2285 |  | 19 |  | 2041
September | 13.8 |  | 9192 |  | 13.7 |  | 10310 |  | 17.4 |  | 1496 |  | 17.8 |  | 2197
October | 13.9 |  | 11773 |  | 14.1 |  | 8703 |  | 16.4 |  | 1907 |  | 16.5 |  | 3074
November | 14 |  | 12784 |  | 13.9 |  | 7205 |  | 16 |  | 2988 |  | 16.9 |  | 4410
December | 14.2 | 1/ |  |  | 13.8 |  | 9947 |  | 16.1 | 1/ |  |  | 16.6 |  | 5007
January |  |  |  |  | 13.6 |  | 9491 |  |  |  |  |  | 16.7 |  | 5896
February |  |  |  |  | 13.2 |  | 9926 |  |  |  |  |  | 16 |  | 3712
March |  |  |  |  | 13 |  | 10050 |  |  |  |  |  | 16 |  | 4733
April |  |  |  |  | 13.2 |  | 9432 |  |  |  |  |  | 15.8 |  | 3904
May |  |  |  |  | 13.3 |  | 9698 |  |  |  |  |  | 16.3 |  | 3262
June |  |  |  |  | 13.5 |  | 7129 |  |  |  |  |  | 15.4 |  | 3395
July |  |  |  |  | 13.5 |  | 7492 |  |  |  |  |  | 16 |  | 2707
Average to date 2/ | 13.98 |  |  |  |  |  |  |  | 16.36
Season-average farm price | 14.2 | 3/ |  |  | 13.4 |  |  |  | 16.5 | 3/ 4/ |  |  | 16.5
Average marketings |  |  | 10489.25 |  |  |  | 9060.5 |  |  |  | 2169 |  |  |  | 3694.833333333333
Total volume marketed |  |  | 41957 |  |  |  | 108726 |  |  |  | 8676 |  |  |  | 44338
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
4/ The medium/short-grain season-average- farm price ([NAME]) largely reflects rice that is marketed through
price pools in California. The pool price is not final until all the rice in the pool is marketed for the crop year.
Therefore, [NAME] forecasts based on the average of NASS monthly prices and the final price may differ.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated January 11, 2013.
Spreadsheet: 766443d1643896388-match-the-position-of-two-equal-items-so-that-they-sit-in-the-same-row-matching_rows
Sheet: Sheet2

 | List of Foods |  |  | List of Foods selected
 | anise |  |  | ginger
 | basil |  |  | coriander
 | caraway |  |  | lavender
 | coriander |  |  | parsley
 | chamomile |  |  | cayenne pepper
 | daikon
 | dill
 | fennel
 | lavender
 | marjoram
 | oregano
 | parsley
 | rosemary
 | thyme
 | jalapeño
 | habanero
 | paprika
 | tabasco pepper
 | cayenne pepper
 | ginger
 | parsnip
 | rutabaga
 | ginger
 | coriander
 | lavender
 | parsley
 | cayenne pepper
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T28

Boeing Tour - AM |  |  |  |  | 2009-06-04 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 836194d1689164745-how-would-i-sort-months-12
Sheet: Sheet1

Return Date | Month & Year | Borrowed Items |  | Month & Year | (All)
 |  | Pencil
 |  | Pencil |  | Row Labels
 |  | Pencil |  | Eraser
 |  | Paper |  | Paper
 |  | Paper |  | Pencil
2023-06-01 00:00:00 |  | Eraser |  | Grand Total
2023-12-01 00:00:00 |  | Eraser
2023-09-01 00:00:00 |  | Eraser
Spreadsheet: robin_rodrigue__33258__HS_STORAGE
Sheet: Diff

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | .
TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total ECT
To: | Order
FT - CENTRAL
Gas Daily | 1 |  | NGPRICE | P
Basis - Notional | 3 |  | NGLTX | P
Basis - Equivalent | 4 |  | NGFPL | P
Price | 5 |  | NGFPL | D
TOTAL:
Basis Roll-off
Spreadsheet: 49226d1248458022-excel-2007-invoice-numbering-new-invoice-for-editing2
Sheet: Invoice

Online Tyres
www.onlinetyres.ie
Ph: [PHONE]
email: [EMAIL]
INVOICE TO: |  | ACCOUNT NO: |  | INVOICE NO: | Next invoice no OT0012
 |  |  |  | DATE:
 | QUANTITY ORDERED | PRODUCT NUMBER | [NAME] | UNIT COST PRICE | UNIT COST PRICE
 | 1
 | VAT RATE |  |  | NET AMOUNT
 | 0.215
 |  |  |  | VAT AMOUNT
 |  |  |  | AMOUNT DUE
Spreadsheet: 128697d1321219464-vlookup-in-different-coumns-hooves-world-racing-syndicate-1
Sheet: LEADERBOARD

POS | MEMBERS |  |  |  | TOTAL
49 | [NAME]
7 | [NAME]
45 | [NAME]
62
27 | [NAME]
51 | [NAME]
36 | [NAME]
11 | [NAME]
17 | [NAME]
56 | [NAME]
37 | [NAME]
34 | [NAME]
32 | J T Patryck Voie
59 | [NAME] Condely
26 | [NAME]
42 | [NAME]
15 | [NAME]
20 | [NAME]
38 | [NAME]
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | Anne-Rita le Riche
5 | [NAME]
6 | [NAME]
8 | [NAME]
9 | [NAME]
10 | Carola Larsson
12 | Chezza Goodgirl
13 | [NAME]
14 | [NAME]
16 | [NAME]
18 | [NAME]
19 | Dante Love Dancel Lara
21 | [NAME]
22 | Deb Mclean
23 | [NAME]
24 | Doreen Laws Hart
25 | [NAME]
28 | [NAME]
29 | [NAME]
30 | [NAME]
31 | [NAME]
33 | [NAME]
35 | Jane-Marie Nash
39 | Jen Rayoso
40 | [NAME]
41 | [NAME]
43 | [NAME]
44 | [NAME]
46 | [NAME]
47 | [NAME]
48 | [NAME]
50 | [NAME]
52 | [NAME]
53 | [NAME]
54 | [NAME]
55 | [NAME] [NAME]
57 | [NAME]
58 | [NAME]
60 | [NAME]
61 | [NAME]
63 | [NAME]
64 | [NAME]
Spreadsheet: 105756d1303042937-excel-2003-dynamic-table-somethingalongtheselines
Sheet: Sheet1

ref | desc | qty |  |  | ref | desc | qty
a | b | e |  |  | a | b | e
 |  | f |  |  | a | b | f
 | c | g |  |  | a | c | g
 |  | h |  |  | a | c | h
 |  | i |  |  | a | c | i
 |  | j |  |  | a | c | j
 | d | k |  |  | a | d | k
 |  | l |  |  | a | d | l
x | v | m |  |  | x | v | m
 |  | g |  |  | x | v | g
 |  | h |  |  | x | v | h
Spreadsheet: 34294d1231453425-vlookup-problem-108b
Sheet: 108-5

901-1038-001 | 2009-01-05 06:07:00 | 48 |  |  |  |  |  | IEC108-5
901-1038-001 | 2009-01-05 06:32:11 | 48
901-1038-001 | 2009-01-05 06:57:22 | 48
901-1038-001 | 2009-01-05 07:22:33 | 48
901-1038-001 | 2009-01-05 07:47:44 | 48
901-1038-001 | 2009-01-05 08:22:55 | 48
901-1038-001 | 2009-01-05 08:48:06 | 48
901-1038-001 | 2009-01-05 09:13:17 | 48
901-1038-001 | 2009-01-05 09:38:28 | 48
901-1038-001 | 2009-01-05 10:03:39 | 48
901-1047-001 | 2009-01-05 10:28:50 | 72
Spreadsheet: 782181d1653885557-aged-debtor-report-formatting-question-aged-debtor-formatting
Sheet: Original

Aged Debtor Report
 |  | Debtor ABC1 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-24 00:00:00 |  | 35 | 41 | 1
 |  | Inv-002 | 2022-05-26 00:00:00 |  | 21 | 37 | 28
 |  | Inv-003 | 2022-05-29 00:00:00 |  | 27 | 3 | 22
 |  |  | TOTALS
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-22 00:00:00 |  | 44 | 17 | 50
 |  | Inv-002 | 2022-05-27 00:00:00 |  | 3 | 15 | 15
 |  |  | TOTALS
 |  | Debtor ABC3 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-27 00:00:00 |  | 12 | 36 | 8
 |  |  | TOTALS
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-27 00:00:00 |  | 40 | 41 | 29
 |  | Inv-002 | 2022-05-24 00:00:00 |  | 31 | 27 | 50
 |  |  | TOTALS
 |  | Debtor ABC5 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-22 00:00:00 |  | 15 | 23 | 16
 |  | Inv-002 | 2022-05-29 00:00:00 |  | 43 | 48 | 9
 |  | Inv-003 | 2022-05-23 00:00:00 |  | 23 | 20 | 18
 |  |  | TOTALS
 |  | Debtor ABC6 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-26 00:00:00 |  | 45 | 50 | 43
 |  | Inv-002 | 2022-05-23 00:00:00 |  | 1 | 47 | 24
 |  |  | TOTALS
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-22 00:00:00 |  | 19 | 35 | 32
 |  | Inv-002 | 2022-05-28 00:00:00 |  | 46 | 20 | 42
 |  | Inv-003 | 2022-05-29 00:00:00 |  | 3 | 45 | 4
 |  |  | TOTALS
 |  | Debtor ABC8 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-27 00:00:00 |  | 19 | 32 | 49
 |  |  | TOTALS
 |  | Debtor ABC9 | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-23 00:00:00 |  | 10 | 39 | 3
 |  | Inv-002 | 2022-05-25 00:00:00 |  | 24 | 39 | 34
 |  | Inv-003 | 2022-05-26 00:00:00 |  | 41 | 15 | 21
 |  |  | TOTALS
 |  | [NAME] | Date | Total | Period 1 | Period 2 | Period 3
 |  | Inv-001 | 2022-05-25 00:00:00 |  | 4 | 4 | 42
 |  | Inv-002 | 2022-05-27 00:00:00 |  | 35 | 28 | 23
 |  | Inv-003 | 2022-05-27 00:00:00 |  | 13 | 44 | 34
 |  | Inv-004 | 2022-05-25 00:00:00 |  | 10 | 39 | 3
 |  | Inv-005 | 2022-05-27 00:00:00 |  | 24 | 39 | 34
 |  | Inv-006 | 2022-05-27 00:00:00 |  | 41 | 15 | 21
 |  | Inv-007 | 2022-05-25 00:00:00 |  | 75 | 93 | 58
 |  | Inv-008 | 2022-05-27 00:00:00 |  | 45 | 50 | 43
 |  | Inv-009 | 2022-05-27 00:00:00 |  | 1 | 47 | 24
 |  | Inv-010 | 2022-05-25 00:00:00 |  | 46 | 97 | 67
 |  | Inv-011 | 2022-05-27 00:00:00 |  | 41 | 15 | 21
 |  | Inv-012 | 2022-05-27 00:00:00 |  | 75 | 93 | 58
 |  |  | TOTALS
Spreadsheet: 94535d1294328518-excel-2007-whole-and-not-whole-number-in-if-statement-questionxls
Sheet: Sheet1

 |  | Time Started | Time Ended
 |  | 08:05:00 | 14:25:00 | << THIS IS THE ONLY DATA THAT I NEED TO COMPLETE
 | Minutes available on the hour |  |  | BASIS 1 | BASIS 2 | BASIS 3 |  |  | MY FORMULA
 | 60 | 08:00:00 | 09:00:00 | 54.99999999999996 | 54.99999999999996 | -5.000000000000036 |  |  | 54.99999999999996
 | 45 | 09:00:00 | 10:00:00 | 45.00000000000002 | 60.00000000000003 | 15.00000000000003 |  |  | 60.00000000000003 | <<<-- WHY THIS IS 60 INSTEAD OF 45 ;(
 | 30 | 10:00:00 | 11:00:00 | 29.99999999999973 | 59.99999999999947 | 29.99999999999947 |  |  | 59.99999999999947
 | 30 | 11:00:00 | 12:00:00 | 30.00000000000025 | 60.0000000000005 | 30.0000000000005 |  |  | 60.0000000000005
 | 60 | 12:00:00 | 13:00:00 | 59.99999999999994 | 59.99999999999994 | 0 |  |  | 59.99999999999994
 | 60 | 13:00:00 | 14:00:00 | 60.00000000000011 | 60.00000000000011 | 0 |  |  | 60.00000000000011
 | 45 | 14:00:00 | 15:00:00 | 18.74999999999993 | 24.99999999999991 | -20.00000000000009 |  |  | 24.99999999999991 | <<<<--- CAN SOMEONE TELL ME WHY THIS IS "E12" INSTEAD OF "F12" (SOLVED BY ADDING “=0”)
 | 60 | 15:00:00 | 16:00:00 | 0 | 0 | -60 |  |  | 0
 | 60 | 16:00:00 | 17:00:00 | 0 | 0 | -60 |  |  | 0