tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: david_delainey__8069__LI34400A
Sheet: Sheet1

UNIT # | ASSIGNMENT/RESERVATION | COMMITMENT | FUTURE COMMITMENT | READY to SHIP DATE | UNIT LOCATION/ NOTES
 |  |  | PROBABILITY
1 | PESCO (West Coast) |  | 0.75 | 2000-07-08 00:00:00 | in-storage
2 | North Carolina |  | 0.75 | 2000-07-26 00:00:00 | in paint facility
3 | North Carolina |  | 0.75 | 2000-08-15 00:00:00 | finished testing moving to final paint facility
4 | PESCO (West Coast) |  | 0.75 | 2000-07-09 00:00:00 | in-storage
5 | PESCO (West Coast) |  | 0.75 | 2000-07-10 00:00:00 | in-storage
6 | PESCO (West Coast) |  | 0.75 | 2000-07-21 00:00:00 | in paint facility
7 | Florida |  | 0.1 | 2000-06-29 00:00:00 | in-storage
8 | Florida |  | 0.1 | 2000-06-30 00:00:00 | in-storage
9 | City of Austin | 1 |  | 2000-08-19 00:00:00 | on assembly line "D"
10 | City of Austin | 1 |  | 2000-09-01 00:00:00 | on assembly line "C"
11 | City of Austin | 1 |  | 2000-09-06 00:00:00 | on assembly line "B"
12 | City of Austin | 1 |  | 2000-09-14 00:00:00 | on assembly line "A"
13 | ESA |  | 0.75 | 2000-09-21 00:00:00 | on skid assembly line
14 | ESA |  | 0.75 | 2000-09-28 00:00:00 | on skid assembly line
15 | ESA |  | 0.75 | 2000-10-25 00:00:00 | on skid assembly line
16 | ESA |  | 0.75 | 2000-11-01 00:00:00 | on skid assembly line
17 | Florida |  | 0.1 | 2000-11-13 00:00:00 | in fabrication at sub-vendors
18 | Florida |  | 0.1 | 2000-11-20 00:00:00 | in fabrication at sub-vendors
19 | Florida |  | 0.1 | 2000-11-27 00:00:00 | in fabrication at sub-vendors
20 | Florida |  | 0.1 | 2000-12-10 00:00:00 | in fabrication at sub-vendors
21 | Las Vegas |  | 0.25 | 2001-01-05 00:00:00 | not started yet
22 | Las Vegas |  | 0.25 | 2001-01-12 00:00:00 | not started yet
23 | Las Vegas |  | 0.25 | 2001-01-20 00:00:00 | not started yet
24 | Las Vegas |  | 0.25 | 2001-03-13 00:00:00 | not started yet
Spreadsheet: 268796d1380828890-formula-help-coupon-a6
Sheet: Sheet1

Column
A | B | C | D | E | F | G | H | I | J
4
5
6 |  |  |  |  | FURLEY  APARTMENTS
7 | Building # | 1 |  |  |  |  |  | Coupon # | 2
8 | Apartment # | 2 |  | Building | Apartment | Month | Rent
9 | Month # | 1 |  | 1 | 2 | January | 700
10
11
 |  | [NAME]
 |  | E9 |  | =C7
 |  | F9 |  | =C8
 |  | G9 |  | =Choose(C9,"January","February", - - ->, "December")
 |  | H9 |  | =IF(C8>10,IF(OR(C9=7,C9=12),425,850),IF(OR(C9=7,C9=12),350,700))
 |  | J7 |  | =C7*C8*C9
Spreadsheet: 709996d1608656646-how-to-increment-with-the-ability-to-reset-1994_image_inventory_sample-2
Sheet: Sheet1

serial | frame # | description | date captured | month processed
19940000_0001 | 3 | missing |  | 4
19940000_0002 | 4 | sign, Permanent Entrance Around Corner |  | 4
19940000_0003 | 5 | sign, Permanent Entrance Around Corner |  | 4
19940206_0004 | 6 | rails, sunset, [NAME] | 1994-02-06 00:00:00 | 4
19940206_0005 | 7 | rails, sunset, [NAME] | 1994-02-06 00:00:00 | 4
19940206_0006 | 8 | rails, sunset, [NAME] | 1994-02-06 00:00:00 | 4
19940306_0007 | 9 | B&O, 315 south of Wilmington | 1994-03-06 00:00:00 | 4
19940306_0008 | 10 | view of brick platform with passing train, Midland City | 1994-03-06 00:00:00 | 4
19940306_0009 | 11 | view of brick platform with passing train, Midland City | 1994-03-06 00:00:00 | 4
19940306_0010 | 12 | view of brick platform with passing train, Midland City | 1994-03-06 00:00:00 | 4
19940306_0011 | 13 | view of brick platform with passing train, Midland City | 1994-03-06 00:00:00 | 4
19940306_0012 | 14 | 315 switching Midland City | 1994-03-06 00:00:00 | 4
19940306_0013 | 15 | stop signs, boys | 1994-03-06 00:00:00 | 4
19940306_0014 | 16 | stop signs | 1994-03-06 00:00:00 | 4
19940306_0015 | 17 | stop signs | 1994-03-06 00:00:00 | 4
19940306_0016 | 18 | three windows, white frame building | 1994-03-06 00:00:00 | 4
19940306_0017 | 19 | three windows, white frame building | 1994-03-06 00:00:00 | 4
19940306_0018 | 20 | three windows, white frame building | 1994-03-06 00:00:00 | 4
19940306_0019 | 21 | two windows, white frame building | 1994-03-06 00:00:00 | 4
19940306_0020 | 22 | two windows, white frame building | 1994-03-06 00:00:00 | 4
19940306_0021 | 23 | N&W 429 east of Peebles | 1994-03-06 00:00:00 | 4
19940306_0022 | 24 | N&W 429 east of Seaman | 1994-03-06 00:00:00 | 4
19940306_0023 | 25 | N&W 429 east of Seaman | 1994-03-06 00:00:00 | 4
19940306_0024 | 26 | N&W 429 east of Seaman | 1994-03-06 00:00:00 | 4
19940306_0025 | 27 | N&W 429 east of Seaman | 1994-03-06 00:00:00 | 4
19940306_0026 | 28 | N&W 429 east of Seaman | 1994-03-06 00:00:00 | 4
19940306_0027 | 29 | N&W 429 Mount Zion | 1994-03-06 00:00:00 | 4
19940306_0028 | 30 | N&W 429 Mount Zion | 1994-03-06 00:00:00 | 4
19940306_0029 | 31 | blank |  | 4
19940313_0030 | 32 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940313_0031 | 33 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940313_0032 | 34 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940313_0033 | 35 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940313_0034 | 36 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940313_0035 | 37 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940313_0036 | 38 | urban scene, furniture at [NAME] | 1994-03-13 00:00:00 | 4
19940206_0037 | 1 | mailbox embedded in tree trunk | 1994-02-06 00:00:00 | 4
19940206_0038 | 2 | mailbox embedded in tree trunk | 1994-02-06 00:00:00 | 4
19940206_0039 | 3 | [NAME] | 1994-02-06 00:00:00 | 4
19940206_0040 | 4 | [NAME] | 1994-02-06 00:00:00 | 4
19940206_0041 | 5 | [NAME] | 1994-02-06 00:00:00 | 4
Spreadsheet: 710795d1609256908-filter-data-on-sheet1-and-show-visible-filter-data-on-sheet-2-in-colmn-a-example2
Sheet: Sheet1

 | GROUP | TYPE | CTS | TYPE | State | AN
 | Apple | PT | 3 | c | AL |  |  |  | Apple | PT | 3 | c | AL | Free1
 | Apple | PT | 3 | c | TX
 | Apple | PT | 3 | c | La
 | Grapes | Dev | 1 | c | La
 | Grapes | Dev | 1 | c | AL |  |  |  | Orange | Dev | 1 | c | AL | Free2
 | Grapes | Dev | 1 | c | OH
Spreadsheet: jay_reitmeyer__13532__ENRON2001
Sheet: 5-01 #7010

 | MPC May 2001 Gas Transportation Invoice
Enron Gas Marketing, Inc
1200 17th Street - Suite 2750
Denver, CO  80202
Attention: [NAME]
Customer ID # 7010
Account # | 100737-6
Interruptible Transportation Charges
 |  | Quantity | Rate | Charge
Commodity Charge |  | 167251 | 0.15
Interruptible Storage Charges
Commodity Charges |  | Quantity | Rate | Charge
Injection Charge |  | 167251 | 0.023
Withdrawal Charge |  | 0 | 0.023
Capacity Charge |  | 167251 | 0.022
Canadian Montana Pipeline Charge
 |  | Quantity | Rate | Charge
 |  | 0 | 0.008
Total Transportation Invoice
Entered:______________ |  |  | Approved:_______________
Spreadsheet: 4425b950-1a9c-4927-9688-b67e1e68486b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7490 | 57739 | Atushi | [NAME] | JPN | 0 | 00:10:20 | [NAME] | 01:03:54 | 00:00:40 | 00:41:48 | 1 | 01:57:22
7490 | 57740 | Shuma | Tanada | JPN | 0 | 00:10:49 | 00:00:41 | 01:05:05 | 00:00:43 | 00:43:07 | 2 | 02:00:26
7490 | 57741 | [NAME] | [NAME] | JPN | 0 | 00:10:37 | 00:00:56 | 01:14:11 | 00:00:35 | 00:41:48 | 3 | 02:08:08
7490 | 57742 | Yusuke | Kobayashi | JPN | 0 | 00:10:52 | 00:00:43 | 01:14:06 | 00:00:46 | 00:45:16 | 4 | 02:11:44
7490 | 57743 | Taihei | Terakawa | JPN | 0 | 00:10:12 | 00:00:38 | 01:31:38 | 00:00:45 | 00:44:58 | 5 | 02:28:11
Spreadsheet: 878562d1725656119-conditional-formatting-or-pivot-table-sample-workbook-tryingmybest123-
Sheet: May

Weekly / Monthly Spend Tracker - Total Controllable Expenses
Operating Supplies |  |  | Repair & Maintenance |  |  | Contracted Services / Other |  |  | Utilities |  |  | Week Of | SUMMARY
 |  |  |  |  |  |  |  |  | (not included in SUMMARY) |  |  |  | Total Controllable Expenses
Budget | Actual | [NAME] | Budget | Actual | [NAME] | Budget | Actual | [NAME] | Budget | Actual | [NAME] |  | Budget | Actual | [NAME]
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-05-01 00:00:00
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-05-05 00:00:00
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-05-12 00:00:00
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-05-19 00:00:00
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-05-26 00:00:00
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | **MONTH**
Vendor |  | Material |  | GL |  | Amount | PO # | PO Date | ETA | Delivered | Received | Invoiced | Invoice # | Status | Date Paid
 |  |  |  | Repair & Maintenance |  | 1000 |  |  | 2024-05-01 00:00:00
 |  |  |  | Operating Supplies |  | 2000 |  |  | 2024-05-02 00:00:00
 |  |  |  | Contracted Services / Other |  | 3000 |  |  | 2024-05-03 00:00:00
 |  |  |  | Operating Supplies |  | 4000 |  |  | 2024-05-04 00:00:00
 |  |  |  | Repair & Maintenance |  | 5000 |  |  | 2024-05-05 00:00:00
 |  |  |  | Contracted Services / Other |  | 6000 |  |  | 2024-05-06 00:00:00
 |  |  |  | Operating Supplies |  | 7000 |  |  | 2024-05-07 00:00:00
 |  |  |  | Repair & Maintenance |  | 8000 |  |  | 2024-05-08 00:00:00
 |  |  |  | Contracted Services / Other |  | 9000 |  |  | 2024-05-09 00:00:00
 |  |  |  | Operating Supplies |  | 10000 |  |  | 2024-05-10 00:00:00
 |  |  |  | Repair & Maintenance |  | 11000 |  |  | 2024-05-11 00:00:00
 |  |  |  | Contracted Services / Other |  | 12000 |  |  | 2024-05-12 00:00:00
 |  |  |  | Operating Supplies |  | 13000 |  |  | 2024-05-13 00:00:00
 |  |  |  | Repair & Maintenance |  | 14000 |  |  | 2024-05-14 00:00:00
 |  |  |  | Contracted Services / Other |  | 15000 |  |  | 2024-05-15 00:00:00 | 2024-06-01 00:00:00
Spreadsheet: 145452d1331585542-excel-2007-referening-from-one-workbook-to-another-formula-inside-turnover1
Sheet: Inside Turnover

 | Memphis LRC |  |  | Last Injury | 2012-03-06 00:00:00 | 6 | Service - Cost Control - Asset Utilization - Safety - People
Date |  |  | 2012-03-12 00:00:00 | Shift
HHP | 0 | LHP | 0 | STRG | 0 |  | Total | 0
Track | Position | L / H  HP | Unit | Pred'd out | Ready | FX/SV | Notes | Assigned Employee
1 | E
 | M
 | W
2 | E
 | M
 | W
3 | E
 | M
 | W
4 | E
 | M
 | W
5 | Wash
 | F / TRK
 | Wheel Mach.
 | JT
 | BTS
 | D/T
 | LB
 | OWH
 | W&D
 | RUNAROUND TRACK
 | 1
 | 2
 | 3
 | 4
 | 5
 | Released |  |  | Shopped |  |  | Units Coming
 | OUTSIDE TRACKS
1 | E - 1
 | E - 1
 | W - 1
 | W - 1
2 | E - 1
 | E - 1
 | W - 1
 | W - 1
3 | E - 1
 | E - 1
 | W - 1
 | W - 1
4 | E - 1
 | E - 1
 | W - 1
 | W - 1
5 | E - 1
 | E - 1
 | W - 1
 | W - 1
Spreadsheet: 81482d1281637779-sum-values-from-a-certain-date-onwards-sumif
Sheet: Sheet3

 | SALES
 | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-04 00:00:00 | 2010-04-05 00:00:00 | 2010-04-06 00:00:00 | 2010-04-07 00:00:00 | 2010-04-08 00:00:00 | 2010-04-09 00:00:00 | 2010-04-10 00:00:00 | 2010-04-11 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00 | 2010-04-24 00:00:00 | 2010-04-25 00:00:00 | 2010-04-26 00:00:00 | 2010-04-27 00:00:00 | 2010-04-28 00:00:00 | 2010-04-29 00:00:00 | 2010-04-30 00:00:00 | [NAME] on Date | Promo Qty | Unit Sold after Promo | FORMULA SOLUTION
C055816 | 2 | 0 | 3 | 1 | 23 | 200 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 0 | 0 | 0 | 7 | 6 | 0 | 3 | 4 | 5 | 2 | 0 | 7 | 0 |  | 200
B055821 | 2 | 200 | 0 | 0 | 4 | 0 | 2 | 0 | 0 | 3 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 8 | 0 | 2 | 5 | 0 | 0 | 0 | 8 | 0 | 7 | 0
B558260 | 2 | 2 | 0 | 4 | 0 | 56 | 0 | 2 | 0 | 300 | 0 | 7 | 6 | 0 | 6 | 0 | 7 | 0 | 6 | 2 | 0 | 0 | 0 | 5 | 6 | 0 | 7 | 8 | 7 | 0 |  | 300
A005831 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 6 | 0 | 67 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 100 | 7 | 0 | 0 | 7 | 8 | 7 | 9 |  | 100
B105584 | 0 | 2 | 0 | 0 | 5 | 4 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 300 | 0 | 0 | 0 | 2 | 3 | 0 | 8 | 0 | 0 | 8 | 7 | 0 |  | 300
Spreadsheet: 97ededa0-332d-488d-b828-6ce2ed336243
Sheet: Sheet1

2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | [NAME] | Unnamed: 5 | Lowrey 305
 |  |  |  | EDU 6519 Teaching and Learning
Date |  | Class # |  | Class Topic |  | Next weeks Assignment
2014-05-27 00:00:00 |  | # 1 |  | Overview and Class Expectations SLLA Teaching and Learning Test
2014-06-03 00:00:00 |  | # 2 |  | Standard II Lecture/Elements Discussion
2014-06-10 00:00:00 |  | # 3 |  | Curriculum Lecture/Discussion
2014-06-17 00:00:00 |  | # 4 |  | Test on Classes 1-3                       Instruction Lecture/Discussion
2014-06-24 00:00:00 |  | # 5 |  | Instructional Lecture Discussion            Instructional Evaluation                   Lecture /Discussion
2014-07-01 00:00:00 |  | # 6 |  | Assessment Lecture                      Supervision of Instruction Lecture
2014-07-08 00:00:00 |  | # 7 |  | Test on Classes 4-6                      Final Project Discussion
2014-07-15 00:00:00 |  | # 8 |  | Final Project Discussion
2014-07-22 00:00:00 |  | # 9 |  | Final Project Presentation
2014-07-29 00:00:00 |  | # 10 |  | Comprehensive Final Exam
Spreadsheet: 4e8dc5a0-f0e0-4813-8279-2b9c647c7de9
Sheet: Form 7 Debt

 |  |  |  |  | *  -  Type - use codes 1-11 |  |  | 6  -  Medium-Term Financing - Lease Purchase
 |  |  |  |  | 1  -  General Obligation Bonds |  |  | 7  -  Capital Leases
ALL EXISTING OR PROPOSED |  |  |  |  | 2  -  G. O. Revenue Supported Bonds |  |  | 8  -  Special Assessment Bonds
 |  |  |  |  | 3  -  G. O. Special Assessment Bonds |  |  | 9  -  Mortgages
 |  |  |  |  | 4  -  Revenue Bonds |  |  | 10 -  Other (Specify Type)
 |  |  |  |  | 5  -  Medium-Term Financing |  |  | 11 -  Proposed (Specify Type)
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11)
 |  | Number |  |  |  |  |  | REQUIREMENTS FOR FISCAL |  | (9) + (10)
 |  | of |  |  |  |  | BEGINNING
 |  | Months | ORIGINAL |  | FINAL |  | OUTSTANDING
NAME OF LOAN | Type | of | AMOUNT OF | ISSUE | PAYMENT | INTEREST | BALANCE | INTEREST | PRINCIPAL
List and Subtotal By Fund | * | TERM | ISSUE | DATE | DATE | RATE |  | PAYABLE | PAYABLE | TOTAL
FUND:
TOTAL ALL DEBT SERVICE
Form 7 INDEBTEDNESS
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 4

TABLE 4
USE A SEPARATE SHEET FOR METRO & COUNTY
COMPANIES NEW TO THE AREA WITHIN THE LAST THREE YEARS
COMPANIES THAT HAVE EXPANDED IN THE AREA WITHIN THE LAST TWO YEARS
PROVIDE SEPARATE TABLES FOR EACH:
50 OR MORE EMPLOYEES FOR AREAS LESS THAN 1 MILLION
100 OR MORE EMPLOYEES FOR AREAS OVER 1 MILLION
LIST ALL WITH 50 OR MORE EMPLOYEES
Type & Year | Company | Location |  | Product/Service | Function 1 | SIC | Year | Employment | Union Affiliation
 |  | City | County |  |  | Code 2 | Established
New to the Area
Last Year
Two Years Ago
Three Years Ago
Expansions/New Facilities
Last Year
Two Years Ago
Downsizing/Closing/Layoff
Last Year
Two Years Ago
1  Headquarters, regional office, back office, distribution center, branch manufacturing plant, branch assembly plant, R & D Center
2  Two Digit SIC Code
Spreadsheet: 169907d1343102067-updating-values-from-two-sheets-no-particular-order-fruit-example
Sheet: Sheet1

Sheet 1
Apple | 1 |  | I would like to to update sheet 2's Fruit numbers with the respective fruit numbers from sheet 1. Please.. It would be so much help, thank you!
Orange | 2
[NAME] | 3
Grape | 4
Peach | 5
Sheet 2
 | Fruit | Number
Group1 | Orange | 6
 | Grape | 7
 | [NAME] | 8
Group2 | Peach | 9
 | Apple | 0
Sheet 3 | [NAME] this is what I want it to look like
 | Fruit | Number
Group1 | Orange | 2
 | Grape | 4
 | [NAME] | 3
Group2 | Peach | 5
 | Apple | 1
Spreadsheet: 677956d1589622006-autofill-downwards-in-a-sequential-manner-but-only-where-an-adjacent-cell-has-content-autofill-query
Sheet: After (desired result)

ITEM |  | QTY | UNIT | RATE | TOTAL
1 | ITEM 1 - WALL WORKS
 | General Allowance - No Detail
1.1 | General Allowance to fire rate gap between slab edge &_x000D_glazing across L1,2 & 3 in lift lobby | 10 | lm | 300
2 | ITEM 2 - INSTALL FIRE SUPPRESSION SYSTEM
 | New Drencher Service - S & I:
2.1 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
2.2 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
2.3 | Allowance for patching upto 20lm ceilings | 20 | m | 60
2.4 | Allowance for painting works | 20 | m | 10
3 | ITEM 3 - FIRE ENGINEERING FOR LINK_x000D_BRIDGE OPENINGS
 | New Drencher Service - S & I:
3.1 | Allowance for extension of new drencher service to L1_x000D_& 2 openings extended from mains water service | 1 | Item | 40000
3.2 | Allowance for provision of access equipment & EWP | 1 | Item | 900
 | BWICS - Allowance (TBC):
3.3 | Allowance for patching upto 20lm ceilings | 20 | m | 60
3.4 | Allowance for painting works | 20 | m | 10
4 | ITEM 4 - SMOKE CURTAIN
 | Signage - S & I:
4.1 | Allowance for signage "WARNING -DROPPING FIRE CURTAIN" | 1 | Item | 250
 | Fire Services - Allow to:
4.2 | Site Establishment & Travel | 1 | Item |  | INCL
4.3 | Reposition single smoke detector | 2 | no | 500
 | Ceiling Makegood - Allowance:
4.4 | Allowance to patch & paint Ceilings | 1 | Item | 500
5 | ITEM 5 - INFRARED SMOKE DETECTOR
 | Walls & Ceilings - Allow to:
5.1 | Allowance to open ceiling to enable works | 2 | hrs | 50
5.2 | Install New smoke detector | 3 | m2 | 500
5.3 | Allowance to makegood ceiling area including painting | 1 | Item | 600
6 | ITEM 6 - SLAB IMPROVEMENTS
 | Fire separation between slabs - Allow to:
6.1 | Allowance post-tension survey | 4 | items | 400
6.2 | Specialised Labour allowance. | 16 | hrs | 120
6.3 | Misc Materials | 1 | Item | 150
 | Subtotal
Spreadsheet: 749252d1632646851-counting-details-from-multiple-sheets-file
Sheet: Vehicle Two

Log
SR.# | DATE | SALES EXECUTIVE |  | [NAME] | [NAME] | [NAME] | Ashraf [NAME] | [NAME] | [NAME] | [NAME]. [NAME] | [NAME]
1 | 2021-09-02 00:00:00 | Savanna
2 | 2021-09-02 00:00:00 | Krystin
3 | 2021-09-04 00:00:00 | [NAME]
4 | 2021-09-04 00:00:00 | Isobel
5 | 2021-09-04 00:00:00 | [NAME]
6 | 2021-09-04 00:00:00 | Savanna
7 | 2021-09-05 00:00:00 | Krystin
8 | 2021-09-06 00:00:00 | [NAME]
9 | 2021-09-06 00:00:00 | Isobel
10 | 2021-09-07 00:00:00 | [NAME]
11 | 2021-09-09 00:00:00 | Savanna
12 | 2021-09-09 00:00:00 | Krystin
13 | 2021-09-12 00:00:00 | [NAME]
14 | 2021-09-12 00:00:00 | Isobel
15 | 2021-09-13 00:00:00 | [NAME]
16 | 2021-09-13 00:00:00 | Savanna
17 | 2021-09-14 00:00:00 | Krystin
18 | 2021-09-15 00:00:00 | [NAME]
19 | 2021-09-20 00:00:00 | Isobel
20 | 2021-09-20 00:00:00 | [NAME]
21 | 2012-09-21 00:00:00 | Savanna
22 | 2021-09-21 00:00:00 | [NAME]
23 | 2021-09-23 00:00:00 | Isobel
24 | 2021-09-23 00:00:00 | [NAME]
25 | 2021-09-25 00:00:00 | Savanna
Spreadsheet: 822606d1679435643-replace-multiple-values-in-power-query-sample-replace-values
Sheet: Spec_source (2)

Specimen_Source
URINE
URINE
BLOOD
BLOOD
[NAME]
Axilla
SKIN
SKIN
SKIN
SKIN
SKIN
SKIN
OTHER
OTHER
SKIN
SKIN
BLOOD
SKIN
SKIN
SKIN
SKIN
SKIN
WOUND
BLOOD
Wound
SKIN
SKIN
BLOOD
SKIN
[NAME]
OTHER
[NAME]
[NAME]
OTHER
Axilla
Axilla
[NAME]
OTHER
Axilla
Axilla
SKIN
SKIN
SKIN
SKIN
Axilla
Axilla
OTHER
SKIN
WOUND
WOUND
SKIN
SKIN
SKIN
BLOOD
BLOOD
[NAME]
RESPIRATORY
URINE
OTHER
Bile
OTHER
SKIN
OTHER
SKIN
Spreadsheet: 146564d1332257040-conditional-format-cell-based-on-value-of-cells-in-range-example
Sheet: Sheet1

11111 | d | e | f | g | h | r | t
12111 | m | n | g | t | f
12311 | w | e | r | t | y
12341 | d | s | a | z | c | y | t | o | p | q | e
12345 | f | t | y | u | i
Spreadsheet: 77931d1278423747-excel-2007-excel-formulae-wbds-new
Sheet: Business Done

Hart Hotels |  |  |  |  | Week Ending:
WBDS |  |  |  |  | Period:
 |  |  |  |  | Week In Period:
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
 | Gross | [NAME] | Gross | [NAME] | Gross | [NAME] | Gross | [NAME] | Gross | [NAME] | Gross | [NAME] | Gross | [NAME]
Accommodation Income
 | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100 |  | 100
[NAME]
U Drive
Rack
Private
Easybreaks
Internet
Other Package
Total Nett Accommodation
VAT
Food Income
[NAME]
[NAME]
Dinner - Resident
Dinner - Non Resident
Coffee Shop
Bar food
Other Food
Total Nett Food
VAT
Liquor Income
Bar 1
Bar 2
Bar 3
Bar 4
Bar 5
Restaurant Liquor
Restaurant Wine
Bar Wine
Night Porter
Total Nett Liquor
VAT
Misc Income
Postcards
Gifts
Sweets
Newspapers
Flowers
Coke Machine
Pool Table
Other Misc
Total Nett Accommodation
VAT
Total Nett Business Done
VAT
Spreadsheet: 742025d1627481690-help-with-spill-error-example
Sheet: MNTH1 Quote

 | Class | Country |  |  |  | Days to Quote |  |  |  |  |  |  | Product
 | Casualty | United Kingdom |  |  |  | 0.5315358564839698
 | EIL | United Kingdom |  |  |  | 0.008943668981373776
 | EIL | United Kingdom |  |  |  | 7.559901736109168
 | EIL | United Kingdom |  |  |  | 6.235619317129022
 | Casualty | United Kingdom |  |  |  | 12.93724417823978
 | Casualty | United Kingdom |  |  |  | 6.378840775461867
 | EIL | United Kingdom |  |  |  | 4.403819166662288
 | Casualty | United Kingdom |  |  |  | 11.1964310069452
 | Casualty | United Kingdom |  |  |  | 11.23218995370553
 | Casualty | United Kingdom |  |  |  | 35.94215783564869
 | EIL | Ireland |  |  |  | 31.60086947916716
 | EIL | United Kingdom |  |  |  | 55.51537072916835
 | Casualty | United Kingdom |  |  |  | 57.30889674767968
Spreadsheet: 769408d1645526498-if-and-function-gives-value-error-counting-not-summing-aligw
Sheet: Sheet1

Region | Client type | Ranking
EMEA | B | 4
APAC | A | 7
APAC | A | 7
APAC | A | 10
EMEA | A | 7
EMEA | C | -1
EMEA | A | 9
EMEA | A | 9
EMEA | A | 10
EMEA | B | 8
EMEA | B | 9
EMEA | A | 8
EMEA | B | -1
AMERICAS | A | 10
APAC | D | 10
EMEA | A | 8
EMEA | E | -1
APAC | A | -1
APAC | F | 8
APAC | A | 8
 |  |  |  |  |  |  |  |  |  |  | "A"
 |  |  |  |  |  |  |  |  |  | >8
 |  |  |  |  |  |  |  |  |  | 7, 8
Spreadsheet: 840865d1693074505-calculate-of-months-each-year-in-a-date-range-forum
Sheet: Sheet1

Start | End | # of Months | # of Months Each Year
Date | Date | to Forecast | 2023
2024-04-30 00:00:00 | 2024-04-30 00:00:00 |  |  | 1
2024-04-30 00:00:00 | 2024-04-30 00:00:00 |  |  | 1
2024-04-30 00:00:00 | 2024-04-30 00:00:00 |  |  | 1
2023-07-31 00:00:00 | 2024-04-30 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
2023-07-31 00:00:00 | 2026-10-31 00:00:00
Spreadsheet: 738273d1624953198-transposing-data-book1
Sheet: Transposed

Date | Year | Quarter | Conversion Currency | Currency Value
2016-01-01 00:00:00 |  |  | AUDCAD Curncy | 1.0117
2016-01-01 00:00:00 |  |  | AUDCLP Curncy | 515.673
2016-01-01 00:00:00 |  |  | AUDCZK Curncy | 18.1714
2016-01-01 00:00:00 |  |  | AUDDKK Curncy | 5.013
2016-01-01 00:00:00 |  |  | AUDHUF Curncy | 211.757
2016-01-01 00:00:00 |  |  | AUDILS Curncy | 2.8311
2016-01-01 00:00:00 |  |  | AUDJPY Curncy | 88.085
2016-01-01 00:00:00 |  |  | AUDKRW Curncy | 855.6085
2016-01-01 00:00:00 |  |  | AUDMXN Curncy | 12.6062
2016-01-01 00:00:00 |  |  | AUDNZD Curncy | 1.0615
2016-01-01 00:00:00 |  |  | AUDNOK Curncy | 6.47467
2016-01-01 00:00:00 |  |  | AUDPLN Curncy | 2.8803
2016-01-01 00:00:00 |  |  | AUDSEK Curncy | 6.1776
2016-01-01 00:00:00 |  |  | AUDCHF Curncy | 0.7307
2016-01-01 00:00:00 |  |  | AUDTRY Curncy | 2.1262
2016-01-01 00:00:00 |  |  | AUDGBP Curncy | 0.4952
2016-01-01 00:00:00 |  |  | AUDUSD Curncy | 0.7303
2016-01-01 00:00:00 |  |  | AUDEUR Curncy | 0.6726