tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 59783d1260339024-formula-for-alert-or-message-test-name
Sheet: Sheet1

 |  | COMPANY | [NAME]
 |  |  |  |  | operator | XYZ
 |  | COMPANY | OPERATOR
 |  | [NAME] | MICHLE
 |  | [NAME] | [NAME]
 |  | [NAME] | ABC
 |  | [NAME] | XYZ
 |  | ABS CARS CO | CHRISTINA
 |  | ABS CARS CO | JOY
 |  | ABS CARS CO | ANNA
 |  | ABS CARS CO | MATHEW
Spreadsheet: 92251d1291873599-automatically-adjusting-a-formula-for-new-data-dashboard12810
Sheet: Wk Trend By Priority

Priority | 3/8-3/14 | 3/15-3/21 | 3/22-3/28 | 3/29-4/4 | 4/5-4/11 | 4/12-4/18 | 4/13-4/25 | 4/26-5/2 | 5/3-5/9 | 5/10-5/16 | 5/17-5/23 | 5/24-5/30 | 5/31-6/6 | 5/31-6/7 | 5/31-6/8
P 0
P 1 | 162 | 152 | 167 | 177 | 152 | 166 | 154 | 194 | 190 | 170 | 163
P 2 | 199 | 173 | 185 | 216 | 171 | 214 | 267 | 254 | 253 | 259 | 265
P 3 | 101 | 104 | 88 | 98 | 104 | 71 | 51 | 92 | 114 | 124 | 153
P 4
P 5 | 12 | 19 | 40 | 17 | 17 | 24 | 15 | 8 | 29 | 20 | 30
P 6 | 25 | 23 | 14 | 35 | 36 | 13 | 9 | 7 | 9 | 10 | 22
P 7 | 7 | 5 | 7 | 11 | 6 | 1 | 4 | 9 | 4 | 12 | 6
Grand Total
This chart represents the tickets that were opened in a given week broken down by priority.
Spreadsheet: 758526d1638919545-attendance-spreadsheet-assistance-employee-attendance-record1
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee Name | Start Date | End Date | Type of Leave | Days | Roll Off Date | Level of PDA | Comments
 | [NAME] | 2021-12-12 00:00:00 | 2021-12-13 00:00:00 | Call out
 | Employee 2
 | Employee 3
 | Employee 5
 | Employee 4
 | Employee 1
 | Employee 4
 | Employee 4
 | Employee 4
 | Employee 2
 | Employee 5
 | Employee 2
 | Employee 5
 | Employee 3
 | Employee 3
 | Employee 1
 | Employee 1
 | Employee 2
 | Employee 5
 | Employee 1
 | Employee 1
 | Employee 2
 | Employee 5
Spreadsheet: 703491d1605020308-vlookup-2-criteria-other-solution-sample_excel
Sheet: Indi 1

Name | Number
A | 1
B | 2
C | 1
D | 1
E | 1
F | 1
G | 2
H | 2
I | 2
J | 1
K | 1
L | 1
M | 1
N | 1
O | 2
O | 1
P | 1
Q | 2
R | 1
S | 1
Spreadsheet: 865566d1712640638-splitting-a-long-field-into-two-without-chopping-words-split-address-aligw
Sheet: Sheet1

Full Street Address |  |  |  |  | IS |  |  | SHOULD BE
 |  |  |  |  | First 20 | Next 20 |  | First 20 | Next 20
123 Main St |  |  |  |  |  |  |  | 123 Main St
123 Wilderun Court Unit B |  |  |  |  | 123 Wilderun Court | Unit B |  | 123 Wilderun Court | Unit B
815 N Diamond Blvd Suite C-98.B |  |  |  |  | 815 N Diamond Blvd | Suite C-98.B |  | 815 N Diamond Blvd | Suite C-98.B
621 Robertson Blvd |  |  |  |  | 621 Robertson Blvd |  |  | 621 Robertson Blvd
2625 NE Hatchers Pass Rd, PMB 151 |  |  |  |  | 2625 NE Hatchers | Pass Rd, PMB 151 |  | 2625 NE Hatchers | Pass Rd, PMB 151
Spreadsheet: 2b618db9-f98e-4e5e-b90e-d14a267a1849
Sheet: Fund 51 Income

FPP Food Service Fund Discussion
2014-02-28 00:00:00
 |  |  |  |  |  | Enterprise Fund | Adjustments | Special Revenue
 |  |  |  |  |  | Statement of Revenues, Expenses, and Changes in Net Position | During the Fiscal Year | Statement of Revenues, [NAME] and Changes in Fund Balances
Operating Revenues/Revenues
 | Student lunches |  |  |  |  | 1593635
 | Federal school breakfast and lunch programs |  |  |  |  |  |  | 2642092
 | USDA Foods program |  |  |  |  |  |  | 314856
 | Summer food service program |  |  |  |  |  |  | 66802
 | Fresh fruits and vegetables program |  |  |  |  |  |  | 21120
 | State match |  |  |  |  |  |  | 74091
 | Interest on Investment |  |  |  |  |  |  | 291
Total Operating Revenues/Revenues
Operating Expenses/Expenditures
 | Salaries and benefits |  |  |  |  | 1979414 | -37249
 | Purchased services |  |  |  |  | 80629
 | Material and supplies |  |  |  |  | 2606061
 | Indirect costs |  |  |  |  | 79827
 | Equipment |  |  |  |  | 0 | 59949
 | Depreciation |  |  |  |  | 32814 | -32814
Total Operating Expenses/Expenditures
Income (loss) form Operations/Excess of Revenues
 | over (under) expenditures
Non-operating Revenues (Expenses)
 | Federal school breakfast and lunch programs |  |  |  |  | 2642092
 | USDA Foods program |  |  |  |  | 314856
 | Summer food service program |  |  |  |  | 66802
 | Fresh fruits and vegetables program |  |  |  |  | 21120
 | State match |  |  |  |  | 74091
 | Interest on Investment |  |  |  |  | 291
 | (Loss) on disposal of capital assets |  |  |  |  | -262
Total Non-operating revenues (expenses) |  |  |  |  |  |  |  | 0
Other Financing Sources (Uses)
 | (Loss) on disposal of equipment |  |  |  |  |  |  | -262
 | Contributed Capital |  |  |  |  | 0 | 0
 | Transfers In |  |  |  |  | 0 |  | 0
Change in Net Position/Net Change in Fund Balances
Net Position Beginning of Year/Beginning Fund Balance
 | as restated |  |  |  |  | 1203541
Net Position Ending of Year/Ending Fund Balance
Spreadsheet: 116803d1312193716-need-to-take-the-data-as-per-the-value-of-the-range-sample
Sheet: Sheet1

Data
S.No | Client | Volume
1 | ABC | 15
2 | DEF | 20
3 | GHI | 35
4 | JKL | 50
5 | MNO | 12
Result should be
0-20 | 21 - 40 | >40
ABC | GHI | JKL
DEF
MNO
Spreadsheet: 268388d1380615681-formula-the-change-the-time-book1
Sheet: Sheet1

2013-10-01 00:00:00 | 00:08:00
2013-10-01 00:00:00 | 00:20:00
2013-10-01 00:00:00 | 00:40:00
2013-09-30 00:00:00 | 16:24:00 | should be | 21:24:00
2013-09-30 00:00:00 | 20:16:00 | should be | 21:16:00
2013-10-01 00:00:00 | 00:00:00
2013-10-01 00:00:00 | 00:01:00
2013-10-01 00:00:00 | 00:01:00
2013-10-01 00:00:00 | 00:02:00
2013-10-01 00:00:00 | 01:54:00
2013-09-30 00:00:00 | 17:02:00 | should be | 21:02:00
2013-09-30 00:00:00 | 18:53:00 | should be | 21:53:00
2013-09-30 00:00:00 | 19:27:00 | should be | 21:27:00
2013-09-30 00:00:00 | 20:33:00 | should be | 21:33:00
2013-09-30 00:00:00 | 20:35:00 | should be | 21:35:00
2013-09-30 00:00:00 | 20:41:00 | should be | 21:41:00
2013-10-01 00:00:00 | 22:30:00
2013-10-01 00:00:00 | 22:33:00
2013-10-01 00:00:00 | 23:12:00
2013-10-01 00:00:00 | 23:17:00
2013-10-01 00:00:00 | 23:42:00
2013-10-01 00:00:00 | 23:59:00
Spreadsheet: vkaminski__40792__PnmaRegas021800
Sheet: Depn&Tax

Depreciation and Taxes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Book Depreciation
Beginning Balance
Current Year Depreciation
Ending Balance
Tax Depreciation
Beginning Balance
Current Year Depreciation
Ending Balance
Panama Book Income Tax
EBITDA
Less: Interest Expense on Debt
Less: Withholding Tax on Interest
Less: License Tax
Less: Book Depreciation
Current Year Taxable Income Before NOL
Less: NOL Carryforward
Current Year Taxable Income
Panama Income Tax Rate
Total Panama Income Tax
NOL Carryforward Calculation
Beginning NOL |  |  |  | 0
Expirations |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Available
Lmt: 20% of Total NOLs
Lmt: 50% of Taxable Income
Utilized (Maximum of Lmts) |  |  |  | 0
Additions
Ending NOL
Panama Cash Income Tax
EBITDA
Less: Interest Expense on Debt
Less: Withholding Tax on Interest
Less: License Tax
Less: Tax Depreciation
Current Year Taxable Income Before NOL
Less: NOL Carryforward
Current Year Taxable Income
Panama Income Tax Rate
Total Panama Income Tax
NOL Carryforward Calculation
Beginning NOL |  |  |  | 0
Expirations |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Available
Lmt: 20% of Total NOLs
Lmt: 50% of Taxable Income
Utilized (Maximum of Lmts) |  |  |  | 0
Additions
Ending NOL
Panama Taxes on Dividends
Annual Dividends
W/H Tax on Dividends Applicable
Less:  Complementary Tax Credit
W/H Tax on Dividends Payable
Panama Book Income
Min Divs Before Complem. Taxes
Dividends Subject to Complem. Tax
Complementary Tax Rate
Total Complementary Tax
Total Panama Taxes on Dividends
License Tax
Net Assets
License Tax Applicable
Limit on License Tax |  |  |  | 20
License Tax Payable
Spreadsheet: da3721d5-1817-45c5-bb06-c4d106446866
Sheet: Table 10

Table 10
[NAME] (1,000 tons)
Week ending 11/15/2014 | Corn | Wheat | Soybeans | Other | Total
Mississippi River
Rock Island, IL (L15) |  | 0 |  | 0
Winfield, MO (L25) |  | 0
Alton, IL (L26) |  | 0
Granite City, IL (L27)
Illinois River (L8) |  | 0 |  | 0
Ohio River (L52) |  |  |  |  |  | n/a
Arkansas River (L1)
Weekly total - 2014
Weekly total - 2013
2014 YTD1
2013 YTD
2014 as % of 2013 YTD
Last 4 weeks as % of 20132
Total 2013
1 Weekly total, YTD (year-to-date) and calendar year total includes Miss/27, [NAME], and Ark/1; "Other" refers to oats, barley, sorghum, and rye.
2 As a percent of same period in 2013.
Note:  Total may not add exactly, due to rounding
Source:  U.S. Army Corps of Engineers
Spreadsheet: 677731d1589487918-transposing-vertical-data-to-horizontal-data-without-pivot-table-examplefile
Sheet: Sheet1

PN | Qty | Price |  | ItemNum | qty_0 | qty_1 | qty_2 | qty_3 | qty_4 | price_0 | price_1 | price_2 | price_3 | price_4
B1000-001 | 1 | 21 |  | B1000-001
B1000-001 | 2 | 22 |  | B1000-002
B1000-001 | 3 | 23 |  | B1000-003
B1000-001 | 4 | 24
B1000-001 | 5 | 25
B1000-002 | 6 | 26
B1000-002 | 7 | 27
B1000-002 | 8 | 28
B1000-002 | 9 | 29
B1000-003 | 10 | 30
B1000-003 | 11 | 31
B1000-003 | 12 | 32
B1000-003 | 13 | 33
B1000-003 | 14 | 34
Spreadsheet: 730293d1619632886-trying-to-create-a-rating-system-based-on-certain-criteria-scorecard-formula
Sheet: Sheet1

 |  | Negative Impact Items
Appraiser | Accepted | Declined (10%) | ReqRev (15%) | Other (5%) | TAT (70%) | Score
Jones, [NAME] | 14 | 1 | 2 | 0 | 5
Smith, Mary | 13 | 7 | 8 | 2 | 12
Spreadsheet: 754838d1636541561-help-with-conditional-formatting-and-time-value-template
Sheet: Mon, 01 Nov - _All times are UK

[All times are UK local - Local Time @ Target is UTC +2]
 |  |  |  |  |  | Criteria | Count
 |  |  |  |  |  | Wildlife
 |  |  |  |  |  | Cyclist
 |  |  |  |  |  | Walkers
 |  |  |  |  |  | Runners
 |  |  |  |  |  | Unknown
 |  |  |  |  |  | Other
Date | Time (Raw) | Time | Time UTC +2 | Country | Site | Location | Camera # | Weather | Day/Night | Alarm Type | Total Events | Car | Type | IN/OUT | Description | Action | Check
 |  | 2021-05-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Check All Detectors
 |  | 2021-11-01 02:17:11 |  |  |  |  |  |  |  |  |  |  | Movement |  | Vines
 |  | 2021-11-01 04:17:58 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 04:51:41 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Boar
 |  | 2021-11-01 05:49:51 |  |  |  |  |  |  |  |  |  |  |  |  | Cyclist
 |  | 2021-11-01 05:54:47 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Vehicle - Staff
 |  | 2021-11-01 05:58:18 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Fox
 |  | 2021-11-01 07:20:03 |  |  |  |  |  |  |  |  |  |  | Movement |  | Estate Staff
 |  | 2021-11-01 08:53:48 |  |  |  |  |  |  |  |  |  |  |  |  | Cyclist
 |  | 2021-11-01 08:53:50 |  |  |  |  |  |  |  |  |  |  |  |  | Runners
 |  | 2021-11-01 10:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Walkers
 |  | 2021-11-01 10:06:13 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 11:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Cyclist
 |  | 2021-11-01 11:10:46 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Deer
 |  | 2021-11-01 12:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Check All Detectors
 |  | 2021-11-01 12:02:35 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Vehicle - Other
 |  | 2021-11-01 13:17:30 |  |  |  |  |  |  |  |  |  |  |  |  | Walkers
 |  | 2021-11-01 15:43:20 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 17:16:30 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
 |  | 2021-11-01 17:18:37 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Deer
 |  | 2021-11-01 18:00:51 |  |  |  |  |  |  |  |  |  |  |  |  | Runners
 |  | 2021-11-01 18:05:08 |  |  |  |  |  |  |  |  |  |  |  |  | Walkers
 |  | 2021-11-01 19:16:54 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Fox
 |  | 2021-11-01 19:31:42 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Fox
 |  | 2021-11-01 19:58:57 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Unknown
 |  | 2021-11-06 22:28:34 |  |  |  |  |  |  |  |  |  |  | Wildlife |  | Boar
 |  | 2021-11-06 23:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | Unknown
 |  | 2021-11-06 23:14:16 |  |  |  |  |  |  |  |  |  |  | Vehicle |  | Stop & Go
Spreadsheet: 758644d1638979729-extracting-same-cell-data-from-multiple-worksheets-variation-tracker-rev-2-
Sheet: Additional Works Summary Sheet

Project Name
Project Number
EOL Forecast Dated
Ref | Description of Works | Date | Quotation Value £ | Estimated Value/Achieved value  % | Estimated Value/Achieved value  £ | Add to forecast (Y) | Staff | Labour | Plant | Permanent Materials | Temporary Materials | Sub-Contractors | Overhead and Profit | Total
 |  |  |  | 0.8
 |  |  |  | 0
TOTAL
Spreadsheet: 807204d1669802763-creating-a-shipping-calculator-with-several-factors-kalk-frakt
Sheet: Sheet1

input |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping | [NAME]
 | Length | 1.2 | m | Input length |  |  |  |  |  |  |  |  |  |  |  |  | Base price | 32.5
 | Height | 1.2 | m | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Price range 0-20.5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price range 21-50kg | 11
 | Area |  | m² | LxH |  |  |  |  |  |  |  |  |  |  |  |  | Price range 50-100kg | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra cost, over 1.2m | 200
 | Weight |  | [NAME] | Area*5kg + 5kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight | [NAME]
 | Shipping cost |  | USD | Base price + weight of product * price range (Here it needs to lookup the price from the correct range, in this case 0-20.5kg price) + Lookup if the input height or length is above 1.2m ( If it is, add the additional cost) |  |  |  |  |  |  |  |  |  |  |  |  | std | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | area | 5
Spreadsheet: 820409d1678095855-auto-return-values-based-on-a-date-i-input-book3
Sheet: Sheet1

 | ACCOUNTS by AREA
 | INPUT FROM PIVOT |  |  | TO ENTER IN NEXT TABLE -->
 | AREA | Accounts |  |  | % of Total | 2023-02-01 00:00:00 |  | FIX NAME |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 | India | 38 | 1 | Asia |  |  |  |  |  | 3
 | Laos | 48 |  | Bali |  |  |  |  |  | 2
 | Thailand | 69 |  | India |  |  |  |  |  | 38
 | Vietnam | 98 |  | Laos |  |  |  |  |  | 48
 | Asia | 3 |  | Thailand |  |  |  |  |  | 69
 | Bali | 2 |  | Vietnam |  |  |  |  |  | 98
 |  |  |  | TOTAL |  |  |  | TOTAL
 | ACCOUNTS by BRAND
 |  |  |  |  |  |  |  |  | Lookup date in this table and returns values in the corresponding month
Spreadsheet: 694738d1599768036-highlighting-cells-book4
Sheet: Sheet1

Visit Date | +45 days | Customer Visit |  | Job Date | Customer Job
2020-09-01 13:00:09 |  | Customer 1 |  | 2020-09-01 00:00:00 | Customer 15
2020-09-01 13:43:52 |  | Customer 2 |  | 2020-09-01 00:00:00 | Customer 3
2020-09-01 13:47:09 |  | Customer 3 |  | 2020-09-01 00:00:00 | Customer 1
2020-09-01 14:09:08 |  | Customer 4 |  | 2020-09-02 00:00:00 | Customer 11
2020-09-01 14:24:17 |  | Customer 5 |  | 2020-09-02 00:00:00 | Customer 9
2020-09-01 14:47:53 |  | Customer 6 |  | 2020-09-02 00:00:00 | Customer 20
2020-09-01 15:02:13 |  | Customer 7 |  | 2020-09-02 00:00:00 | Customer 13
2020-09-01 15:16:17 |  | Customer 8 |  | 2020-09-03 00:00:00 | Customer 5
2020-09-02 09:56:29 |  | Customer 9
2020-09-02 10:16:55 |  | Customer 10
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Eskom- Collection - Station Sup

Status : Notification to Delivery (Logistics: 14 day Cycle time)
Notification to Delivery  (Status) : |  |  |  |  |  |  | Eskom Station -   Notification to Delivery  (Status) :
Power Station | Region | Shipment Status | Delivery Note | Eskom Customer PO | Eskom Notified - Collection: GE Facility ( No of days taken) | Eskom Station - Delivery to station ( No of days taken) | Late | On Time | Grand Total
Tutuka | UK | Delivered | 80584246 | 4502846364 | 48 | 53 | 1 |  | 1
Tutuka | UK | Delivered | 80584492 | 4502883250 | 48 | 53 | 1 |  | 1
Tutuka | UK | Delivered | 80585541 | 4502733614 | 43 | 48 | 1 |  | 1
Tutuka | UK | Delivered | 80585542 | 4502883279 | 43 | 48 | 1 |  | 1
Tutuka | UK | Delivered | 80592612 | 4502887026 | 9 | 14 |  | 1 | 1
Tutuka | UK | Delivered | 80592876 | 4502883815 | 9 | 14 |  | 1 | 1
Tutuka | UK | Delivered | 80596567 | 4502917525 | 22 | 30 | 1 |  | 1
Tutuka | UK | Delivered | 80596844 | 4502883297 | 17 | 25 | 1 |  | 1
Tutuka | UK | Delivered | 80598048 | 3070325287 | 23 | 30 | 1 |  | 1
Tutuka | UK | Delivered | 80598306 | 4502946355 | 18 | 25 | 1 |  | 1
Tutuka | UK | Delivered | 80598675 | 4502883250 | 18 | 25 | 1 |  | 1
Tutuka | UK | Delivered | 80599910 | 4502946910 | 12 | 22 | 1 |  | 1
Tutuka | UK | Delivered | 80600705 | 4502918764 | 22 | 34 | 1 |  | 1
Tutuka | UK | Delivered | 80600787 | 4502918764 | 17 | 29 | 1 |  | 1
Tutuka | UK | Delivered | 80602218 | 4502956817 | 12 | 23 | 1 |  | 1
Tutuka | UK | Delivered | 80602216 | 4502922039 | 12 | 23 | 1 |  | 1
Tutuka | UK | Delivered | 80602521 | 4502934622 | 12 | 23 | 1 |  | 1
Tutuka | UK | Delivered | 80602805 | 4502921198 | 15 | 11 |  | 1 | 1
Tutuka | UK | Delivered | 80603542 | 4502961008 | 7 | 15 | 1 |  | 1
Tutuka | UK | Delivered | 80603716 | 4502952308 | 7 | 15 | 1 |  | 1
Tutuka | UK | Delivered | 80604471 | 4502914444 | 15 | 23 | 1 |  | 1
Tutuka | UK | Delivered | 80606585 | 4502961008 | 13 | 21 | 1 |  | 1
Tutuka | UK | Delivered | 80606668 | 4502932956 | 13 | 21 | 1 |  | 1
Tutuka | UK | Delivered | 80606948 | 4502955371 | 7 | 15 | 1 |  | 1
Tutuka | UK | Delivered | 80607264 | 4502852772 | 4 | 12 |  | 1 | 1
Tutuka | UK | Eskom : Await Transport PO | 80608968 | 4502883297 | 3 | 3 |  | 1 | 1
Tutuka | UK | Eskom : Await Transport PO | 80609019 | 4502969680 | 3 | 3 |  | 1 | 1
Grand Total |  |  |  |  |  |  | 21 | 6 | 27
Spreadsheet: 864185d1711463974-trying-to-extract-year-and-day-out-of-a-table-monthdaylisting-etaf
Sheet: Sheet1

Month | Day | Year
1 | 1 | 1850
2 | 2 | 1851 |  |  | Enter Month |  | 5 |  | # of Occurrences |  |  |  | Desired Results
3 | 3 | 1852
4 | 4 | 1853 |  |  | Occurences | Month | Day | Year |  |  |  |  | Month | Day | Year
5 | 5 | 1854 |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 1854 |  |  | 5 | 1854
6 | 6 | 1855 |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 1903 |  | 5 | 5 | 1903
7 | 7 | 1856 |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 1907 |  | 5 | 7 | 1907
8 | 8 | 1857 |  |  |  |  |  |  |  |  |  |  | 5 | 7 | 1926 |  | 5 | 7 | 1926
9 | 9 | 1858 |  |  |  |  |  |  |  |  |  |  | 5 | 8 | 1926 |  | 5 | 8 | 1926
10 | 10 | 1900 |  |  |  |  |  |  |  |  |  |  | 5 | 12 | 1961 |  | 5 | 12 | 1961
11 | 11 | 1901
12 | 12 | 1902
5 | 5 | 1903
6 | 6 | 1904
7 | 7 | 1905
4 | 8 | 1906
5 | 7 | 1907
6 | 6 | 1925
5 | 7 | 1926
5 | 8 | 1926
7 | 9 | 1958
8 | 10 | 1959
9 | 11 | 1960
5 | 12 | 1961
Spreadsheet: 784041d1655376823-vertical-summary-of-horizontal-data-how-test
Sheet: Sheet1

Current Format
 | Bids & tenders | Business Development Offshore | CEO & CFO | Commercial | Finance | HR | Health & Safety | IT | Operations
 | Month Ending | Month Ending | Month Ending | Month Ending | Month Ending | Month Ending | Month Ending | Month Ending | Month Ending
 | 31/05/2022 | 31/05/2022 | 31/05/2022 | 31/05/2022 | 31/05/2022 | 31/05/2022 | 31/05/2022 | 31/05/2022 | 31/05/2022
 | Actual YTD | Actual YTD | Actual YTD | Actual YTD | Actual YTD | Actual YTD | Actual YTD | Actual YTD | Actual YTD
BCV | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Variations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Accrued Income Movement | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Project Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Non Project Revenue | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Sales | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Installation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Salaried | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Subsistence | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Unallocated Labour
Labour | 0 | 0 | 242.51 | 0 | 626.84 | 0 | 656.3 | 0 | 0
Total Unallocated Labour | 0 | 0 | 242.51 | 0 | 626.84 | 0 | 656.3 | 0 | 0
Preferred Format
 | Labour
Bids & tenders
Business Development Offshore
CEO & CFO
Commercial
Finance
HR
Health & Safety
IT
Operations
Spreadsheet: 740650d1626438644-sum-of-values-in-a-column-between-2-dates-as-shown-in-required-data-required
Sheet: Sheet2

 | From Date | 2021-07-01 00:00:00 |  | To Date | 2021-07-14 00:00:00 |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-02 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-10 00:00:00
 | Total Revenue |  |  |  |  | I want Total Revenue, Total Cost between date selected in "From Date" to "To date" from "Sheet1" |  |  | 2021-07-03 00:00:00
 | Total Cost |  |  |  |  |  |  |  | 2021-07-09 00:00:00
 | Total Margin |  |  |  |  |  |  |  | 2021-07-04 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-05 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-06 00:00:00
 | Result Required |  |  |  |  |  |  |  | 2021-07-07 00:00:00
 | Total Revenue | 14134480 |  |  |  |  |  |  | 2021-07-08 00:00:00
 | Total Cost | 14367512 |  |  |  |  |  |  | 2021-07-11 00:00:00
 | Total Margin | 1029066 |  |  |  |  |  |  | 2021-07-12 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-13 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-14 00:00:00
 |  |  |  |  |  |  |  |  | 2021-07-15 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-27 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-28 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-29 00:00:00
 |  |  |  |  |  |  |  |  | 2021-06-30 00:00:00
Spreadsheet: 686456d1594643876-monthly-training-data-book2
Sheet: Sheet1

Title in English | Language | Team A | Trainer | Planned date 2020 | Performed date 2020 | Team B | Trainer | Planned date 2020 | Performed date 2020 | Team C | Trainer | Planned date 2020 | Performed date 2020 | Team D | Trainer | Planned date 2020 | Performed date 2020
Training-1 | EN |  | Person-A | 2020-11-20 00:00:00 |  |  |  |  |  |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  | Person-A | 2020-07-20 00:00:00 | 2020-07-12 00:00:00
Training-2 | EN |  |  |  |  |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  |  |  |  |  | Person-C | 2020-07-20 00:00:00 | 2020-07-12 00:00:00
Training-3 | EN |  | Person-B | 2020-07-20 00:00:00 | 2020-07-12 00:00:00 |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  | Person-A | 2020-02-02 00:00:00 | 2020-03-03 00:00:00
Training-4 | EN
Training-5 | EN |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00 |  |  |  |  |  | Person-E | 2020-07-30 00:00:00 | 2020-07-30 00:00:00 |  | Person X | 2020-04-10 00:00:00 | 2020-06-10 00:00:00
 |  |  |  |  |  |  | Training for | 2020-07-01 00:00:00
 |  |  |  | Sr No. | Training Title | Team Name | Performed Date | Trainer Name
Spreadsheet: 0a33889b-cb11-42e7-8f4b-0f70aa455288
Sheet: Sheet1

Unnamed: 0 | 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 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Form:  C-150
UDOT CULVERT INSPECTION FORM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | State Route:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference Post:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PIN / Project:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inspector:
Circular |  |  |  | Arch |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Contractor:
Location | Drainage |  |  | Pipe Type |  |  | Physical Characteristics |  |  |  |  | Manual / Visual Inspection |  |  |  |  |  |  |  | Comments
Route / R.P. or Alignment | Cross [NAME] | Irrigation | Storm Drain | Circular | Arch | [NAME] | [NAME]. (in) | Length (ft) | Rise    (R)       (in) | Span    (S)       (in) | Material (CMP, HDPE, PVC, RCP) | Abrasions | [NAME]. | Coating Damage | Dents | [NAME] | [NAME] | Alignment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Horizontal | Vertical