tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879630d1727200533-dept-and-date-to-auto-calculate-based-on-todays-date-example
Sheet: Example Info

 |  |  |  | Date |  |  |  |  |  |  |  |  |  |  |  | Shift | Dept
 |  |  |  | 2024-02-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-02-11 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Meat
 |  |  |  | 2024-02-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Produce
 |  |  |  | 2024-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Produce
 |  |  |  | 2024-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Produce
 |  |  |  | 2024-03-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Meat
 |  |  |  | 2024-03-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-03-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-04-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-04-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Produce
 |  |  |  | 2024-04-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-04-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Deli
 |  |  |  | 2024-05-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-06-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Produce
 |  |  |  | 2024-06-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Produce
 |  |  |  | 2024-06-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-06-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-06-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 3 | Freezer
 |  |  |  | 2024-07-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Freezer
 |  |  |  | 2024-08-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Produce
 |  |  |  | 2024-08-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 1 | Grocery
 |  |  |  | 2024-08-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
 |  |  |  | 2024-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Meat
 |  |  |  | 2024-09-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2 | Deli
Spreadsheet: 0ef497e4-d97b-4535-b82f-b4f91f5ca987
Sheet: 1.3 Labour force

1.3 Labour force
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Labour force (a) – '000
July | 11622.6093304 | 11815.6753784 | 11975.8025777 | 12159.3629505 | 12332.7782618
August | 11654.4144742 | 11835.3267059 | 11989.3874235 | 12164.2878566 | 12343.1210017
September | 11686.6365407 | 11851.620421 | 12005.7394592 | 12170.5161397 | 12351.277561
October | 11715.870802 | 11863.0854323 | 12024.3396726 | 12179.2179674 | 12357.6503071
November | 11739.610681 | 11869.7094246 | 12044.1310591 | 12191.7476754
December | 11756.3143841 | 11876.4737199 | 12064.6432474 | 12207.1531182
January | 11766.5032604 | 11887.305268 | 12084.8228211 | 12224.3350733
February | 11770.9166039 | 11903.3227616 | 12105.3082862 | 12243.0483463
March | 11772.4430215 | 11921.0481752 | 12124.5070008 | 12264.1063259
April | 11775.9484038 | 11937.5794433 | 12140.0889279 | 12285.7715862
May | 11783.9749437 | 11951.6910115 | 12149.4143385 | 12305.0896997
June | 11797.760047 | 11963.9595263 | 12154.9163783 | 12320.4757353
Annual average | 11736.91687439167 | 11889.73310566667 | 12071.92509935833 | 12226.259372875
Participation rate (a) – per cent
July | 65.3157267 | 65.3852953 | 65.1158988 | 64.9297 | 64.6727634
August | 65.4206158 | 65.4085959 | 65.096957 | 64.8620486 | 64.6370791
September | 65.5259945 | 65.4109666 | 65.0909127 | 64.7988864 | 64.5991335
October | 65.6115799 | 65.3831025 | 65.0949189 | 64.7466898 | 64.5673985
November | 65.6622747 | 65.3238404 | 65.1031296 | 64.7137125
December | 65.6687531 | 65.2601635 | 65.1127507 | 64.6958758
January | 65.6350036 | 65.2150853 | 65.1183687 | 64.6878188
February | 65.5675183 | 65.1975297 | 65.1246784 | 64.6880608
March | 65.4851841 | 65.1917218 | 65.1250277 | 64.7005786
April | 65.4168708 | 65.1838098 | 65.1087657 | 64.7164011
May | 65.3766904 | 65.1670103 | 65.0624684 | 64.7198578
June | 65.3697861 | 65.1425989 | 64.9985091 | 64.7032417
Annual average | 65.5046665 | 65.27247666666666 | 65.09603214166667 | 64.74690599166667
(a) Monthly figures are trend. Annual figures are from the original series.
 |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-12-11 00:00:00
Spreadsheet: 697339d1601311956-rolling-formula-to-calculate-nets-book3
Sheet: Sheet1

ESRId | ESRNo | Customer | Engineer | Project | AgilePN | ItemDescription | Source | Destination | ItemCategory | ToWH | MfgPN | Vendor | ReqType | Material Need by Date | TotalReqQty | QtyIssued | OpenBal | Available Inv (Origin) | Net Inv (Origin) | [NAME] | Net Inv (Alt) | Item Availability | ReqBy | ReqDate | PMGroup | PjM Comment | BuyerComments | GatingPO | ETA | GatingPO Qty | ETAStatus | Status | CreatedDate | CreatedUser | ModifiedDate | ModifiedUser | LastTicketNo | JobNo
 |  |  |  |  | SC-00629-001 |  | 10TW01 |  |  |  |  |  |  | 2020-09-28 00:00:00 | 340 | 0 | 340
 |  |  |  |  | SC-00629-001 |  | 10TW01 |  |  |  |  |  |  | 2020-09-28 00:00:00 | 340 | 0 | 340 |  |  | -67
 |  |  |  |  | SC-00629-001 |  | 10TE02 |  |  |  |  |  |  | 2020-10-07 00:00:00 | 150 | 0 | 150
 |  |  |  |  | SC-00629-001 |  | 10TE02 |  |  |  |  |  |  | 2020-10-27 00:00:00 | 510 | 0 | 510
 |  |  |  |  | SC-00629-001 |  | 10TE02 |  |  |  |  |  |  | 2020-12-15 00:00:00 | 816 | 0 | 816
 |  |  |  |  | SC-00629-001 |  | 10TE02 |  |  |  |  |  |  | 2020-12-15 00:00:00 | 840 | 0 | 840
 |  |  |  |  | CA-02050-003 |  | 10TE02 |  |  |  |  |  |  | 2021-01-04 00:00:00 | 3 | 0 | 3
 |  |  |  |  | CA-02050-003 |  | 10TE02 |  |  |  |  |  |  | 2021-01-04 00:00:00 | 40 | 0 | 40
 |  |  |  |  | CA-02050-003 |  | 10TE02 |  |  |  |  |  |  | 2021-01-04 00:00:00 | 98 | 0 | 98
 |  |  |  |  | CA-02050-003 |  | 10TE02 |  |  |  |  |  |  | 2021-01-04 00:00:00 | 98 | 0 | 98 |  |  | -3
Spreadsheet: 757670d1638387609-remove-alphabets-from-number-string-in-a-cell-sample-1-
Sheet: Summary

 |  |  | Part | Part.1
Part |  |  | 101 | 101
101A |  |  | 102 | 102
102E |  |  | 103 | 103
103C |  |  | 104 | 104
104 |  |  | 105 | 105
105 |  |  | 106 | 106
106F |  |  | 101 | 101
101D |  |  | 102 | 102
102A
Spreadsheet: 114762d1310484059-how-to-relocate-multiple-cells-farmaddresslisttransposed
Sheet: Raw data

[NAME] | [NAME] | 1234 Old County Rd, Blank, TX  12345 | (503) 555-5555 | [EMAIL]
1234 Old County Rd, Blank, TX  12345 | [NAME] | 4444 Block rd, Blank, TX  12545 | (503) 555-5555 | [EMAIL]
(503) 555-5555 | tom black | 37111 state st, juniper, mo, 33344 | [PHONE] | [EMAIL]
[EMAIL] | [NAME] | 4444 Block rd, Blank, TX  12545 | (503) 555-5555 | [EMAIL]
[NAME] | Fred | 4444 Block rd, Blank, TX  12545 | (503) 555-5555 | [EMAIL]
4444 Block rd, Blank, TX  12545 | [NAME] | 4444 Block rd, Blank, TX  12545 | (503) 555-5555 | [EMAIL]
(503) 555-5555 | 0 | 0 | 0 | 0
[EMAIL] | 0 | 0 | 0 | 0
tom black | 0 | 0 | 0 | 0
37111 state st, juniper, mo, 33344
[PHONE]
[EMAIL]
[NAME]
4444 Block rd, Blank, TX  12545
(503) 555-5555
[EMAIL]
Fred
4444 Block rd, Blank, TX  12545
(503) 555-5555
[EMAIL]
[NAME]
4444 Block rd, Blank, TX  12545
(503) 555-5555
[EMAIL]
Spreadsheet: 144231d1330808651-vlookup-command-to-highlight-cell-in-table-0136
Sheet: Blood Sugar

Name | Wake-Up | Breakfast | Mid-Morning | Lunch | Mid-Afternoon | Evening | Mid-Evening | Night |  | Min Value | [NAME] | Median | IQR 1 | IQR 2 | [NAME]
[NAME] | 3.8 | 3.83 | 3.7 | 4.2 | 3.55 | 3.95 | 4.2 | 3.95 |  | 3.55 | 4.2 | 3.89 | 3.775 | 4.0125 | 0.2375000000000003
[NAME] | 4.3 | 4.8 | 4.2 | 4.9 | 4.1 | 5 | 5.23 | 4.75 |  | 4.1 | 5.23 | 4.775 | 4.275 | 4.925000000000001 | 0.6500000000000004
Anne | 4 | 4.2 | 3.6 | 3.9 | 3.4 | 4.2 | 4.35 | 4.15 |  | 3.4 | 4.35 | 4.075 | 3.825 | 4.2 | 0.375
[NAME] | 5.6 | 6.3 | 5.7 | 6.1 | 5.6 | 6.3 | 6.25 | 6.15 |  | 5.6 | 6.3 | 6.125 | 5.675 | 6.2625 | 0.5875000000000004
[NAME] | 4.8 | 4.9 | 4.5 | 5.2 | 4.9 | 5.6 | 5.45 | 5.35 |  | 4.5 | 5.6 | 5.050000000000001 | 4.875 | 5.375 | 0.5
Natasha | 5.1 | 5.3 | 5.05 | 5.3 | 4.95 | 5.25 | 5.35 | 5.15 |  | 4.95 | 5.35 | 5.2 | 5.087499999999999 | 5.3 | 0.2125000000000004
Safe
Dangerous
Part 5
User | [NAME]
Time Period | Mid-Evening
Result | 5.45
match for result | 8
Spreadsheet: 189820d1351369461-help-with-spreadsheets-connection-sample
Sheet: INVENTORY

 |  |  | 130 | 64.55000000000001 |  |  | 104 |  |  |  |  |  | 156
 |  |  | 52 | 0 |  |  | 26 |  |  |  |  |  | 39
 |  |  | 104 | 0 |  |  |  |  |  |  |  |  | 0
 |  |  | 78 | 0 |  |  |  |  |  |  |  |  | 130
 |  |  | 182 | 241.36 |  |  |  |  |  |  |  |  | 182
 |  |  | 208 | 89.12 |  |  | 52 |  |  |  |  |  | 156
 |  |  | 0 | 0 |  |  | 363 |  |  |  |  |  | 598
 |  |  | 104 | 48.56 |  |  | 133 |  |  |  |  |  | 0
Spreadsheet: 871695d1718114438-linking-contents-of-another-worksheet-based-on-pivot-values-example-workbook
Sheet: Data

 | Order | Value £
 | 1 | 100
 | 2 | 200
 | 3 | 300
 | 4 | 400
 | 5 | 500
 | 6 | 600
 | 7 | 700
 | 8 | 800
 | 9 | 900
 | 10 | 1000
 | 11 | 1100
Spreadsheet: 1e06dc08-476e-47bc-a6d1-312c2a510b41
Sheet: $Ranges$

13 | worksheet | range | cell | usage | reference | row | column | rows | columns
 | [NAME] | MonthSelected | D7 | HorizontalTable | =Performance Framework!R7C4:R7C4 | 7 | 4 | 1 | 1
 | [NAME] | NRMPF1 | D4 | FixedTable | =Performance Framework!R4C4:[NAME] | 4 | 4 | 4 | 4
 | [NAME] | NRMPF2 | [NAME] | FixedTable | =Performance Framework!R4C12:R8C25 | 4 | 12 | 5 | 14
 | [NAME] | NRMPF3 | D11 | FixedTable | =[NAME]:R12C25 | 11 | 4 | 2 | 22
 | [NAME] | NRMPF4 | A20 | HorizontalTable | =Performance Framework!R20C1:R20C34 | 20 | 1 | 1 | 34
 | [NAME] | NRMPF5 | A29 | FixedTable | =[NAME]:R33C34 | 29 | 1 | 5 | 34
 | [NAME] | NRMPF6 | A36 | HorizontalTable | =Performance Framework!R36C1:R36C34 | 36 | 1 | 1 | 34
 | [NAME] | NRMPF7 | A47 | FixedTable | =Performance Framework!R47C1:R51C34 | 47 | 1 | 5 | 34
 | [NAME] | NRMPF8 | A58 | FixedTable | =Performance Framework!R58C1:R97C55 | 58 | 1 | 40 | 55
 | [NAME] | PRs | H6 | HorizontalTable | =Performance Framework!R6C8:R6C8 | 6 | 8 | 1 | 1
 | [NAME] | YearSelected | D6 | HorizontalTable | =Performance Framework!R6C4:[NAME] | 6 | 4 | 1 | 1
 | Target assumptions | NewRange9 | A1 | HorizontalTable | =Target assumptions!R1C1:R5C18 | 1 | 1 | 5 | 18
 | Target assumptions | NRMPF9 | A1 | HorizontalTable | =Target assumptions!R1C1:R5C18 | 1 | 1 | 5 | 18
Spreadsheet: 167299d1341946610-vlookup-help-book2
Sheet: Sheet1

Size | Type | CXLIST
2L | COLA
12 pack 12oz | COLA
2L | COLA
12 pack 12oz | COLA
12 pack 12oz | COLA
2L | COLA
20oz | COLA
2L | LEMON LIME
20oz | LEMON LIME
2L | LEMON LIME
2L | COLA
12 pack 12oz | LEMON LIME
12 pack 12oz | COLA
2L | COLA
20oz | COLA
20oz | COLA
12 pack 12oz | COLA
12 pack 12oz | LEMON LIME
2L | LEMON LIME
20oz | COLA
2L | GINGER
20oz | LEMON LIME
20oz | COLA
12 pack 12oz | COLA
12 pack 12oz | COLA
2L | COLA
2L | LEMON LIME
2L | COLA
6 pack 16.9 oz | COLA
1.25L | COLA
2L | ROOT BEER
2L | COLA
12 pack 12oz | COLA
20 pack 12oz | COLA
Spreadsheet: 59479d1259964634-vlookups-linking-together-newer-copy
Sheet: Sheet1

Date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
Quote |  |  |  |  |  |  |  |  |  |  |  | 81105
AGL ref |  |  |  |  |  |  |  |  |  |  |  | 10/1105/09
Shipper ref
Shipper short code |  |  |  |  |  |  |  |  |  |  |  | Client 1
Shipper
Contact |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Consignee |  |  |  |  |  |  |  |  |  |  |  | a
Notify
Loading cargo at
Collection date |  |  |  |  |  |  |  |  |  |  |  | 2009-11-30 00:00:00
Collection time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 | hrs
Haulage by
Shipping line
Departure airport
[NAME] airport
Final destination
Flight number
ETS
Connecting airport
ETS
ETA
Time |  |  |  |  |  |  |  |  |  |  |  | 18:45:00 | hrs
Freight charges payable
Other charges payable
Declared value of goods
Amount of insurance
Shipping marks &/or case numbers
Number and kind of packages
Dimensions |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
 |  |  |  |  |  |  |  |  |  |  |  |  | cms
Total number of items
Gross weight |  |  |  |  |  |  |  |  |  |  |  |  | kgs
Chargeable weight |  |  |  |  |  |  |  |  |  |  |  |  | kgs
Cube |  |  |  |  |  |  |  |  |  |  |  |  | m³
Booking ref
MAWB no
Booking confirmation date
Invoice date
Spreadsheet: 328705d1404035624-index-match-if-function-wonder-why-excel-kept-refer-to-the-wrong-want-formula-error-dgk-3
Sheet: BySea

 | JOB NO.
 | SHIPPER/CONSIGNEE
 | POL
 | POD
 | Itemizing Services |  | Unit Selling Price | Qty LCL | Qty 20' | Qty 40' | Total Amount of Billing |  |  | Notes
 |  |  |  |  |  |  | LCL | 20' | 40'
 | Ocean Freight |  |  |  |  |  |  |  |  | SEA FREIGHT CURRENCY
 | Port Charges at Port Klang |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | THC |  |  |  |  |  |  |  |  | AS PER RECEIPT.
 | EDI/IID
 | BL/DO
 | Container Cleaning Fee |  |  | 2 | 3 | 9
 | Container Cleaning Fee
 | Custom Clearance Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | SMK |  |  |  |  | 1
 | [NAME]
 | CFS/Warehouse Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | Storage
 | Heavy Lifting (3Tons & Above)
 | Transportation |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | Haulage
 | Side Loader
 | Depot Gate Charges
 | Accessories Charges |  | Unit S.Rate | LCL | 20' | 40' | LCL | 20' | 40'
 | [NAME]
 | [NAME] Hired
 | Overtime (Min 2hrs)
 | Overtime on Weekends
 | Marine Insurance
 | Insurance Stamping Fee
Spreadsheet: 88964d1288772404-extract-from-previous-row-when-time-is-greater-than-last_batch_before
Sheet: Sheet1

EK-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-19 17:50:00 | 2010-10-19 00:00:00 |  |  | 2010-10-19 00:00:00 | EK-01
EK-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-19 18:00:00 | - |  |  | 2010-10-20 00:00:00 | EL-02
EK-03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-19 18:17:00 | -
EL-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-20 17:30:00 | -
EL-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-20 17:55:00 | 2010-10-20 00:00:00
EL-03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-20 18:22:00 | -
Spreadsheet: 132098d1323472767-lookup-returning-values-but-shifts-one-spot-down-r_data
Sheet: Sheet2

ARI | 5 | 7
ATL | 7 | 5
BAL | 9 | 3
BUF | 5 | 7
CAR | 4 | 8
CHI | 7 | 5
CIN | 7 | 5
CLE | 4 | 9
DAL | 7 | 5
DEN | 7 | 5
DET | 7 | 5
GB | 12 | 0
HOU | 9 | 3
IND | 0 | 12
JAC | 3 | 9
KC | 5 | 7
MIA | 4 | 8
MIN | 2 | 10
NE | 9 | 3
NO | 9 | 3
NYG | 6 | 6
NYJ | 7 | 5
OAK | 7 | 5
PHI | 4 | 8
PIT | 10 | 3
SD | 5 | 7
SEA | 5 | 7
SF | 10 | 2
STL | 2 | 10
TB | 4 | 8
TEN | 7 | 5
WAS | 4 | 8
Spreadsheet: 734648d1622331481-counting-data-based-on-a-custom-format-timeeditef
Sheet: Data

 |  |  |  |  |  |  |  |  |  | Weekly Total
 | 1 | 2021-05-16 00:00:00 | 09:30:00 | 22:30:00
 | 2 | 2021-05-17 00:00:00 | 07:15:00 | 09:15:00 |  |  |  |  |  | Total Shifts
 | 3 | 2021-05-17 00:00:00 | 20:03:00 | 23:04:00
 | 4 | 2021-05-18 00:00:00 | 05:24:00 | 06:24:00
 | 5 | 2021-05-18 00:00:00 | 20:45:00 | 23:45:00 |  |  |  |  | 2 | Total Edited
 | 6 | 2021-05-19 00:00:00 | 07:16:00 | 09:16:00
 | 7 | 2021-05-19 00:00:00 | 20:11:00 | 23:12:00
 | 8 | 2021-05-20 00:00:00 | 07:30:00 | 09:29:00
 | 9 | 2021-05-20 00:00:00 | 21:06:00 | 23:59:00
 | 10 | 2021-05-21 00:00:00 | 00:00:00 | 00:06:00
 | 11 | 2021-05-21 00:00:00 | 07:56:00 | 09:56:00
 | 12 | 2021-05-22 00:00:00 | 08:56:00 | 11:56:00
 | 13 | 2021-05-22 00:00:00 | 20:30:00 | 23:30:00
Spreadsheet: 62320d1263297234-if-with-vlookup-customer_management_list1
Sheet: 001

Arranged |  |  |  | Received |  | Job Number
Time
Customer |  |  | Site Address |  |  | Customer Order No
 |  |  |  |  |  | Customer Contact
 |  |  |  |  |  | Site Contact
 |  |  |  |  |  | Site Contact Number
 |  |  |  |  |  | New Customer |  | Yes / No
 |  |  |  |  |  | Job Complete
Job Description (Detailed For Invoice)
Additional Works Descrition (please mark N/A if extra works not carried out)
Labour
Date |  | Operative Initials |  | Hours |  | Mileage | Expenses | [NAME]
Qty | Material Descritpion |  |  |  |  | Supplier | Stock | Cost each | Total
 | mark N/A if material has not been used |  |  |  |  |  |  | £ | £
Any additional materials please mark PTO and detail on the reverse of this sheet
Invoice No - |  |  | /
Terms |  | Days |  | Your Ref
 |  |  |  | Customer Contact
Date |  |  |  | Job Complete
Site
Description
QTY |  | COST BREAKDOWN |  |  |  |  |  | UNIT COST | TOTAL COST
 |  | A statement will not be issued, please pay on invoice
VAT NUMBER - 886 3072 95 |  |  |  | VAT |  |  |  | SUB TOTAL
Please note : Unless stated otherwise on this invoice, payment needs to reach us within the specified terms as detailed above. All goods shall remain the property of Pulse Electrical (Dundee) Ltd, until all payment has been received in full. |  |  |  |  |  |  |  | VAT
 |  |  |  |  |  |  |  | TOTAL
To pay electronically |  | Bank Account Number |  |  |  | Sort Code
Please use our invoice number above as the payment reference
Labour Costs
[NAME] |  |  |  |  |  |  | Job Number
Week No | Hours | Journeyman | Mileage | Expenses | Rate | Total |  | /
1 | 1 | bm | 5 | 5
Total
Apprentice Hours
Week No | Hours | Apprentice | Mileage | Expenses | Rate | Total
1 | 1 | NG | 6 | 5
Total
Plant |  |  |  |  |  |  | Job No
Wholesaler | Qty | Pink copy no | Description |  |  | cost excl vat |  | [NAME] % | Total
 | 1 |  |  |  |  | 100
Total Plant Cost Transferred
Material Costs
Stock materials to be detailed stock in wholesaler column
Wholesaler | Qty | Pink copy no | Description |  |  | cost excl vat |  | [NAME] % | Total
HH | 1 | 129/1987 | Stuff |  |  | 10
Total Material Cost Transferred
Spreadsheet: 775121d1648826366-calculation-incorrect-when-multiplying-multiple-cells-excel-help
Sheet: Sheet6

660
1110
920
170
210
310
670
2590
1460
520
380
290
190
270
130
1520
660
620
270
230
140
660
510
320
910
380
440
380
360
440
450
770
480
570
430
340
440
560
540
322 | 8.34 | 12.927 | 0.3
Spreadsheet: 835337d1688521860-use-of-indirect-i-think-11-for-test-hd
Sheet: Summary

Round 1
Time Slot
Attendees
Job satisfaction
Action points
Round 2
Time Slot
Attendees
Job satisfaction
Key action points
Spreadsheet: 084cc67d-9ce4-472c-bbdc-d8120361cae7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | STATE OF MARYLAND EXPENSE ACCOUNT | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Use for reimbursement effective January 1, 2014
 |  |  |  | 56.0 ¢ per mile
Department
Unit  or   Division
Agency    Code |  |  | Employee Social Security No.
Employee   Name
and    Address
Assigned   Office   Location     (City) |  |  |  | One Way Commute Miles
For   Period    Beginning |  |  |  | And Ending
Date
Day | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | TOTALS
Hotel |  |  |  |  |  |  |  | 0
Breakfast |  |  |  |  |  |  |  | 0
Lunch |  |  |  |  |  |  |  | 0
Dinner |  |  |  |  |  |  |  | 0
Telephone |  |  |  |  |  |  |  | 0
Fare (Indicate below) |  |  |  |  |  |  |  | 0
Taxi |  |  |  |  |  |  |  | 0
Bridge or Road Tolls |  |  |  |  |  |  |  | 0
Mileage * (See Below) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Parking |  |  |  |  |  |  |  | 0
Registration Fee |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Method of Travel
 |  |  |  |  |  | (Specify)
Purpose of Travel:
Date | Time |  |  |  |  |  | Total | Total | Reimb.
Day | Start | End | TERRITORY COVERED INCURRING ABOVE EXPENSES |  |  |  | [NAME] | Commute Miles | [NAME]*
Sunday |  |  |  |  |  |  |  |  | 0.0
Monday |  |  |  |  |  |  |  |  | 0.0
Tuesday |  |  |  |  |  |  |  |  | 0.0
Wednesday |  |  |  |  |  |  |  |  | 0.0
Thursday |  |  |  |  |  |  |  |  | 0.0
Friday |  |  |  |  |  |  |  |  | 0.0
Saturday |  |  |  |  |  |  |  |  | 0.0
*Compute equal to total miles less total commute miles, if applicable.
 |  |  |  |  |  | Date
Certified just and correct and payment not received
 |  |  |  | (Signature of employee)
Approved by |  |  |  |  | Approved by
 |  | Immediate Supervisor |  |  |  |  | Authorized Signature
 |  |  |  |  | Title
COTGAD - X-5  (3/92)
Spreadsheet: 105007d1302505159-populating-fields-by-using-only-the-month-name-number-dates
Sheet: Sheet1

 | 3 |  |  |  | 1 | JANUARY
 |  |  |  |  | 2 | FEBRUARY
 |  |  |  |  | 3 | [NAME]
 |  |  |  |  | 4 | APRIL
 |  |  |  |  | 5 | MAY
 |  |  |  |  | 6 | [NAME]
 |  |  |  |  | 7 | JULY
 | 3 |  |  |  | 8 | AUGUST
 |  |  |  |  | 9 | SEPTEMBER
 |  |  |  |  | 10 | OCTOBER
 |  |  |  |  | 11 | NOVEMBER
 |  |  |  |  | 12 | DECEMBER