tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794234d1661952701-vlookup-with-multiple-conditions-template-mock
Sheet: Panels

# | FB density | Panel Material Gauge | Material | COVER Metal Weight Per SQFT | Powder | Price per [NAME] | LBS Needed | QTY OF PANELS | SQ/FT Total | BEND ALLOWANCE | WIDTH BENDS |  | WIDTH FLAT DIM |  | LENGTH BENDS | FLAT DIM | SHEETS NEEDED | SHEETS NEEDED | Material Needed |  | SHEET SQ/FT | MATERIAL PRICE (ENTER IF NOT STOCK) |  |  |  | SOLID MATERIAL NEEDED | MATERIAL PRICE (ENTER IF NOT STOCK) | PART NUMBER |  | PART NUMBER | Panel W | Panel L | Total Weight | Panel Thickness | A60 | A60 | A60 | G90 | G90 | G90 | 3003 H14 | 3003 H14 | 3003 H14 | Cost Details
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KNP-FLAT | KNP-4 SIDED | V-GROOVE | KNP-FLAT | KNP-4 SIDED | V-GROOVE | KNP-FLAT | KNP-4 SIDED | V-GROOVE | Materials |  |  |  | Shop Labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perf | Solid | FB | Powder | Shear&Brake | [NAME] | Paint Line | [NAME].Parts | Shipping |  | shop labor/panel |  |  | SELL
1 | 2.25
 | 2.25
 | 2.25
 | 2.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Fiber Weight
 | 2.25
 | 2.25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Metal Weight
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 | 2.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MATERIALS:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SHOP L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: afb2fe78-a487-44f1-96a7-de7645ed8f25
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FCRTG | Test | FCRTG | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	NA Thawing:	Warm OK, Cold OK Lipemia:	NA Icterus:	NA Other:	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.    Test Performed by:	Viracor-IBT Technologies 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FCRTG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCRTG | Result | FCRTG | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0e1801ae-dbfe-4701-86c6-f5f5f2b8dbd1
Sheet: Sheet1

OPERATING | FY2012 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Reserve | Beginning | Ending
Fund Balance | 441305 | 433409
 | FY2012 | FY2012 | FY2011 | FY2012 | FY2012 | FY2011
 | Annual Budget | Annual Budget | Revenues this time | Actual Revenue | Actual Expenses | Expenses this time | Net | Net
 | Revenue | Expenses | last year | to date | to date | last year | This Year | Last Year
Membership activities
Administration |  | 229109 |  |  | 228017 | 227711
Membership Promotion |  | 2000 |  |  | 2457 | 2595
Governance Support |  | 8900 |  |  | 9655 | 10240
Dues | 188884 | 3905 | 187898 | 179766 | 3321 | 3416
MW & Annual Conference | 0 | 6300 | 0 | 0 | 3694 | 9902
External Relations | 13500 | 20712 | 13500 | 13500 | 19843 | 20329
Technology Grants | 0 | 1000 | 0 | 0 | 0 | 0
50th Anniversary | 0 | 0 | 0 | 0 | 0 | 0
Friends of LITA (LITA Now) | 100 | 0 | 0 | 575 | 16 | 0
Subtotal | 202484 | 271926 | 201398 | 193841 | 267003 | 274193 | -73162 | -72795
Publications
ITAL | 57338 | 62533 | 54227 | 23964 | 31937 | 60769 | -7973 | -6542
Classified ads | 10000 | 2100 | 16586 | 14288 | 1783 | 1794 | 12505 | 14792
Nonperiodical Pubs. | 2000 | 1755 | 2793 | 1741 | 1723 | 1865 | 18 | 928
Subtotal | 69338 | 66388 | 73606 | 39993 | 35443 | 64428 | 4550 | 9178
Education
Pre-conferences | 15900 | 13754 | 11755 | 41923 | 21290 | 7796 | 20633 | 3959
MW Workshop | 14870 | 11192 | 21290 | 3770 | 4011 | 13499 | -241 | 7791
Forum | 117400 | 110012 | 129423 | 117658 | 100707 | 110790 | 16951 | 18633
Institutes | 22800 | 14508 | 3500 | 0 | 247 | 1957 | -247 | 1543
Web CE-1 (courses) | 27000 | 11883 | 22925 | 28385 | 7908 | 4717 | 20477 | 18208
Web CE-2 (webinars) | 15000 | 6467 | 854 | 4228 | 1087 | 1454 | 3141 | -600
Subtotal | 212970 | 167816 | 189747 | 195964 | 135250 | 140213 | 60714 | 49534
TOTAL | 484792 | 506130 | 464751 | 429798 | 437696 | 478834 | -7898 | -14083
ENDOWMENT | FY2012
 | actual to date
Fund Balance | 121084
Revenues | 7996
Expenses | 777
Net Revenue/Expense | 7219
Ending Net Asset Balance | 128303
Interest/Dividends | 3990
Spreadsheet: 187275d1350397108-how-to-return-a-value-from-mutliple-tabs-with-data-sets-salary-1
Sheet: Calucation

Employee | Office | Step | Grade | Amount | Hours worked | Taxes/Benefits | Total Salary
[NAME] | Springfield | 11 | 2
[NAME] | Orlando | 12 | 1
 |  |  |  | Trying to get Column E to meet these inputs
 |  |  |  | ie Cell E-4 would equal Location 7  tab C-13
 |  |  |  | Cell E-5 would equal Location 2 tab Cell B-14
 |  |  |  | The values in Column B,C,D will change frequently.
Spreadsheet: 813992d1674094327-selecting-the-nearest-static-location-weather-station-for-a-list-of-gps-tracker-points-gps_weather_sample_data
Sheet: Gibraltar Weather

Station name | Latitude | Longitude | dt_iso | Date_Time | T_Min (C) | [NAME] (C) | Pressure (hPa) | Humidity (%) | Wind_Speed (m/s) | Wind_Deg (˚) | [NAME]) | Clouds (%)
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 06:00:00 +0000 UTC |  | 18.81 | 20 | 1014 | 82 | 4.6 | 230 |  | 40
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 07:00:00 +0000 UTC |  | 18.94 | 20 | 1014 | 77 | 5.1 | 240 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 08:00:00 +0000 UTC |  | 19.28 | 21 | 1014 | 73 | 5.7 | 240 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 09:00:00 +0000 UTC |  | 19.6 | 22 | 1014 | 68 | 4.1 | 250 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 10:00:00 +0000 UTC |  | 20.11 | 23 | 1014 | 69 | 5.1 | 260 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 11:00:00 +0000 UTC |  | 20.61 | 24 | 1015 | 64 | 5.1 | 250 |  | 40
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 12:00:00 +0000 UTC |  | 20.93 | 24 | 1015 | 64 | 6.2 | 260 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 13:00:00 +0000 UTC |  | 21.17 | 25 | 1014 | 57 | 5.1 | 230 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 14:00:00 +0000 UTC |  | 21.32 | 25 | 1014 | 61 | 5.1 | 230 |  | 20
Gibraltar | 36.140751 | -5.353585 | 2020-06-05 15:00:00 +0000 UTC |  | 21.36 | 26 | 1014 | 54 | 4.6 | 230 |  | 20
Spreadsheet: 767133d1644311315-convert-columns-to-rows-keeping-first-column-identifier-sample-2
Sheet: Sheet3

Name | ID | In | Out | In2 | Out3 | In4 | Out5 | In6 | Out7 | In8 | Out9 | In10 | Out11 |  | Name | ID | In | Out
AINSWORTH, NICOLE |  | 2021-08-30 07:00:00 | 2021-08-30 15:00:00 | 2021-08-31 07:00:00 | 2021-08-31 15:00:00 | 2021-09-01 07:00:00 | 2021-09-01 15:00:00 | 2021-09-02 07:00:00 | 2021-09-02 15:00:00 | 2021-09-03 07:00:00 | 2021-09-03 15:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
ALLEN, DARELENE |  | 2021-08-30 15:00:00 | 2021-08-30 23:00:00 | 2021-08-31 15:23:00 | 2021-08-31 23:00:00 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
BEERENS, LIAM |  | 2021-08-30 00:00:00 | 2021-08-30 00:00:00 | 2021-08-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-01 15:00:00 | 2021-09-01 23:00:00 | 2021-09-02 15:00:00 | 2021-09-02 23:00:00 | 2021-09-03 00:00:00 | 2021-09-03 00:00:00 | 2021-09-04 00:00:00 | 2021-09-04 00:00:00
Spreadsheet: 275904d1383678061-how-to-combine-a-sum-with-an-if-function-how-to-combine
Sheet: Sheet1

93 | 144
96 | 94
55 | 187
1938 | 870
 | 2
40 | 57
48 | 0
24 | 48
61 | 1
24 | 29
73 | 10
22 | 8
Spreadsheet: 272927d1382548629-formula-to-pull-a-name-from-a-list-given-a-certain-entry-example-template-jacc
Sheet: Datavalidation

Business Initiative
Data Deduplication - STO
Network Storage (SAN/NAS/Hybrid) - STO
SAN - STO
[NAME]
Storage Infrastructure/Hardware - STO
Storage Management - STO
Storage Virtualization - STO
Software Defined Networking/Virtualization - NET
Telecom - NET
Unified Communications - NET
WAN - NET
Wireless - NET
Network Security - NET
Email & Web Security - SEC
Virtualization Security - SEC
Wireless - SEC
Network Security - SEC
Security General - SEC
Systems & Asset Management - DC & VIRT
Server Virtualization - DC & VIRT
Backup - STO
Big Data - STO
[NAME]
Disaster Recovery - STO
Remote Storage - STO
Storage for Virtual Environments - STO
Application Performance Management - NET
[NAME]
[NAME]
Collaboration - NET
Consumer Mobile Applications - NET
Data Center Networking - NET
Network Infrastructure - NET
Network Management - NET
Networking General - NET
Identity and Access Management - SEC
Platform Security - SEC
Security Managemet/SIM - SEC
Threat Management - SEC
Windows Security - SEC
Compliance Risk and Governanace - SEC
Mobile Devices/BYOD - NET
Mobile Infrastructure  and Device Management - NET
Mobile Security - NET
Encryption - SEC
Application Security - SEC
Cloud Computing- Security
Data Protection - SEC
CIO General - CIO
[NAME]
Healthcare - CIO
ITSM - CIO
Outsourcing - CIO
Data Governance - ENTAPP
Supply Chain Management - ENTAPP
ERP/Financials - ENTAPP
SQL Server - ENTAPP
Big Data - ENTAPP
Customer Experience Management - ENTAPP
[NAME] VIRT
Exchange/Collaboration - DC & VIRT
Exchange/Collaboration - DC & VIRT
Application Virtualization - DC & VIRT
Consumer Driven Cloud Storage - DC & VIRT
Vmware - DC & VIRT
Desktop Management - DC & VIRT
Client OS - DC & VIRT
Desktop Virtualization - DC & VIRT
Domino - DC & VIRT
iSeries/400 - DC & VIRT
Linux - DC & VIRT
Mainframe - DC & VIRT
Server OS - DC & VIRT
Data Center Virtualization General - DC & VIRT
Data Center Hardware - DC & VIRT
Data Center Infrastructure and Design - DC & VIRT
Disaster Recovery - DC & VIRT
SOA - ENTAPP
Application Integration - ENTAPP
Project and Portfolio Management - ENTAPP
Application Modernization/Infrastructure - ENTAPP
ALM - ENTAPP
Application Security - ENTAPP
Java - ENTAPP
SAP - ENTAPP
Mobile Applications and Development - ENTAPP
Call Center - ENTAPP
CRM - ENTAPP
Data Integration - ENTAPP
[NAME]
Databases - ENTAPP
Oracle - ENTAPP
Servers & Hardware (for Software Vendors) - ENTAPP
Business Process Management - ENTAPP
Data Warehousing - ENTAPP
HR - ENTAPP
Corporate Performance Management - ENTAPP
Business Analytics - ENTAPP
Content Management/Records Management/E-Discovery - ENTAPP
Collaboration - ENTAPP
Windows Development - ENTAPP
Spreadsheet: 68983d1269514525-auto-sorting-formula-amendments-auto-sorting
Sheet: Sheet1

 |  | DATA | FORMULA 1 | RESULT
 |  | DEVID | 2 | AAA
 |  | MICHLE | 9 | DEVID
 |  | VERGHESE | 13 | FARNANDAS
 |  | RAJU | 11 | #N/A
 |  | FARNANDAS | 3 | #N/A
 |  | FARNANDAS | 3 | ISSAC
 |  | FARNANDAS | 3 | #N/A
 |  | RAJA | 10 | KAMRAN
 |  | KAMRAN | 8 | MICHLE
 |  | ZZZ | 14 | RAJA
 |  | AAA | 1 | RAJU
 |  | TARIQ | 12 | TARIQ
 |  | ISSAC | 6 | VERGHESE
 |  | ISSAC | 6 | ZZZ
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Royals

Kansas City Royals | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Kansas City Royals | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods |  |  |  |  |  |  |  | Division Winner | 1
Personnel |  |  |  |  |  |  |  | LCS Winner | 1
Hood, [NAME] | ML | ML | ML | ML | ML | ML |  | World Series Winner | 2
Portillo, Adys | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | Income
[NAME] | ML | ML | ML | ML | ML | ML |  | From Athletics | -3.6
[NAME] | ML | ML | ML | ML | ML | ML |  | From Cardinals |  | -0.1
[NAME], Lars | ML | ML | ML | ML | ML | ML |  | From [NAME] | -0.6
Andrus, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
Bard, [NAME] | ML | ML | ML | ML | ML | ML |  | Penny, [NAME] | 6.8
Cleto, Maikel | ML | ML | ML | ML | ML | ML |  | Rincon, [NAME] | 2.1 | 2.1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Athletics | 5
[NAME], Neftali | ML | ML | ML | ML | ML | ML |  | To Rockies |  | 1.1
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | To Twins | 3.2
Gimenez, [NAME] | ML | ML | ML | ML | ML | ML
Lillibridge, Brent | ML | ML | ML | ML | ML | ML
[NAME], Che-Hsuan | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Nunez, Efrain | ML | ML | ML | ML | ML | ML
Osuna, [NAME] | ML | ML | ML | ML | ML | ML
Rogers, [NAME] | ML | ML | ML | ML | ML | ML
Sumoza, [NAME] | ML | ML | ML | ML | ML | ML
Teagarden, [NAME] | ML | ML | ML | ML | ML | ML
Thompson, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Walden, Jordan | ML | ML | ML | ML | ML | ML
Withrow, [NAME] | ML | ML | ML | ML | ML | ML
Pujols, [NAME] | 26 | 26 | 26
Rodriguez, Alex | 17 | 17
[NAME], [NAME] | 5.6
McCann, [NAME] | 5 | A3
Baldelli, Rocco | 3.2 | 3.2 | 3.2 | 3.2
Hamels, Cole | 3 | A2 | A3
Lester, [NAME] | 3 | A2 | A3
Liriano, [NAME] | 3 | A2 | A3
Upton, B.J. | 3 | A2 | A3
Howry, [NAME] | 2.9
[NAME], [NAME] | 2.7
Franklin, [NAME] | 2.1
Hermida, [NAME] | 2.1 | A2 | A3
Reyes, [NAME] | 1.8 | A2 | A3
Igawa, Kei | 0.8 | 0.8 | 0.8
Braun, [NAME] | 0.7 | A1 | A2 | A3
Lindstrom, [NAME] | 0.7 | A1 | A2 | A3
Butler, [NAME] | 0.7 | A1 | A2 | A3
Pedroia, Dustin | 0.7 | A1 | A2 | A3
Barmes, Clint | 0.5 | A
Chamberlain, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Jones, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Spreadsheet: 745964d1630414109-separate-specific-data-from-a-column-book1
Sheet: Sheet1

Data | Result
ONLINE H6663238076 R ACTIVO PTY L | R ACTIVO PTY L
ACCOUNT FEES A.K.F. ACTIVO PTY L | A.K.F. ACTIVO PTY L
[PHONE] AMEX GR 22.42 ACTIVO PTY LTD | ACTIVO PTY LTD
FLEXIPAY 30/06 21:22SUNSHINE FRU 21C DEVONSHIRE RD | SUNSHINE FRU
V6964 29/06 PREMIER FRUITS PTY L FOOTSCRAY [PHONE] | PREMIER FRUITS PTY L FOOTSCRAY
INTERNET TRANSFER 033 KKS EGG | KKS EGG
INTERNET TRANSFER 755 zyaj | zyaj
V9429 29/06 NATIONAL STORAGE BRISBANE [PHONE] | NATIONAL STORAGE BRISBANE
[PHONE] AMEX GR 17.29 ACTIVO PTY LTD | ACTIVO PTY LTD
MRS HARPINDER KAUR G pizza zone | MRS HARPINDER KAUR G pizza zone
FLEXIPAY 29/06 21:24SUNSHINE FRU 21C DEVONSHIRE RD | SUNSHINE FRU
V6964 28/06 SMP*Emilios [NAME] [PHONE] | SMP*Emilios [NAME]
INTERNET BPAY COVAU PTY LTD 11348042 | COVAU PTY LTD
V6964 28/06 COOLIBAH HERBS PEARCEDALE [PHONE] | [NAME]
ONLINE W8563276784 R ACTIVO PTY L | R ACTIVO PTY L
NABATM CSH 28th07:54SUNSHINE | SUNSHINE
HILAL THAYYIL J5377274282 Loan repay | HILAL THAYYIL
[PHONE] AMEX GR 6.06 ACTIVO PTY LTD | ACTIVO PTY LTD
[PHONE] AMEX GR 17.89 ACTIVO PTY LTD | ACTIVO PTY LTD
THUAN AN 0077 0838 CBA ACTIVO PTY LTD | CBA ACTIVO PTY LTD
FLEXIPAY 28/06 21:32SUNSHINE FRU 21C DEVONSHIRE RD | SUNSHINE FRU
INTERNET TRANSFER 4380 WISE G | WISE G
HILAL THAYYIL N0830248999 Loan repay | HILAL THAYYIL
FLEXIPAY 27/06 21:41SUNSHINE FRU 21C DEVONSHIRE RD | SUNSHINE FRU
HILAL THAYYIL J5577477984 Loan repay | HILAL THAYYIL
HILAL [NAME] repay | HILAL THAYYIL
MVP TRUCK BODIES A6047258084 Activo group | Activo group
V9429 26/06 PAYPAL *EBAY AU [PHONE] [PHONE] | EBAY AU
V9429 26/06 PAYPAL *MALLONTRADI EB [PHONE] [PHONE] | MALLONTRADI EB
GADDE PTY LTD Dum [NAME] 6 inv clr | GADDE PTY LTD Dum [NAME] 6 inv clr
Spreadsheet: 709047d1608139372-progress-bar-in-each-cell-based-on-values-progress-bar-v1
Sheet: main

Serial Number | Date | Status | Progress bar
N119178025 |  | Wait for Dispatch to Service
N119178081 |  | In Quarantine
NL16362157 |  | In transit to Company
NL16015026 |  | Wait for Dispatch to Client
NL16089199 |  | Returned to client
NL16163372 |  | Returned to client
Spreadsheet: 812005d1672911985-conference-room-conference-room-reservations
Sheet: Availability

Conference Room Avaliablity Table
Reference Start Date |  |  | 2023-01-02 00:00:00 |  | Display Date |  |  |  |  | 1
Reference Start Time |  |  | 09:00:00 |  | Time Step |  |  | 60 |  | 0
No | Room | Room Number
1 | Conference Room | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Available
2 | Conference Room | 5
3 | Conference Room | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Available
4 | Conference Room | 8
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Double Reservation
6
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Need help showing the ideal results as per the below (name to display and double booking). Thank you.
8
9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ideal Results: Jan 2, 2023
11
12
13
14
15
16
17
18
19
20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ideal Results: Jan 3, 2023
22
23
24
25
26
27
28
29
30
31
32
33
34
35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ideal Results: Jan 4, 2023
Spreadsheet: 57277d1257383898-creating-a-report-from-a-table-pivot-table-with-dynamic-input-range
Sheet: Sheet1

AcctNum | AcctDescr | Year | Month | Scenario | Amount
10110 | Food | 2009 | 1 | Actuals | 500 |  | Year | 2009
10115 | Travel | 2009 | 1 | Actuals | 1100 |  | Month | 2
10110 | Food | 2009 | 2 | Actuals | 1500
10115 | Travel | 2009 | 2 | Actuals | 2100 |  | Total |  | Scenario
10133 | Gifts | 2009 | 2 | Actuals | 2200 |  | AcctNum | AcctDescr | Actuals | Budgets
10110 | Food | 2009 | 1 | Budgets | 1500 |  | 10110 | Food | 1500 | 2500
10115 | Travel | 2009 | 1 | Budgets | 900 |  | 10115 | Travel | 2100 | 1900
10133 | Gifts | 2009 | 1 | Budgets | 1200 |  | 10133 | Gifts | 2200
10110 | Food | 2009 | 2 | Budgets | 2500 |  | Grand Total |  | 5800 | 4400
10115 | Travel | 2009 | 2 | Budgets | 1900
10133 | Gifts | 2009 | 1 | Budgets | 700 |  | Data range (ie pivot source) defined as name: data
10133 | Gifts | 2009 | 2 | Budgets | 2200
 |  |  |  |  |  |  | Will expand automatically when more rows are added
Spreadsheet: gerald_nemec__11390__GasSolutions
Sheet: FD Costs

EOC HOUSTON TECHNICAL SERVICES
PROJECT COST ESTIMATE
 |  |  | CUSTOMER COMPANY NAME: |  | Houston Pipe Line Co.
 |  |  | PROJECT NAME: |  | Gas Solutions Longview Plant: [NAME] addition to Texoma 30"
 |  |  |  |  |  | line (3080) at station 9761+66 in Gregg County, TX.
 |  |  | W.O. NUMBER: |  | estimate
 |  |  | PROJECT ENGINEER: |  | [NAME] |  |  | File Name:  GasSolutions
 |  |  | REVISION NUMBER:
FIELD DIRECT COSTS
[NAME] |  |  |  | EST.   QTY. | EST. UNIT | W.O.A.             UNIT              COST | W.O.A        COST        ESTIMATE           (TAP & RISER) | W.O.A.             COST   ESTIMATE (METER) | W.O.A.             COST   ESTIMATE (TOTAL)
CONSTRUCTION SUPPORT:
 | SURVEY (Preliminary and As-Built) |  |  |  | Day | 750
 | FIELD INSPECTION :
 |  | - Construction - 1 Chief Insp. |  |  | Days | 330
 |  | - Construction - 1 Craft Insp. |  |  | Days | 295
 |  | - Contruction Management |  |  | Days | 480
 | X-RAY |  |  |  | Days | 550
 | VACUM TRUCK SERVICE |  |  |  | Hours | 40
 | HOT-TAP SERVICE |  |  |  | Lot | 875
CONSTR. SUPPORT TOTAL
CONTRACT INSTALLATION:
 | LABOR:  Install site w/ culvert, tap, meter & fence
 |  | [NAME] rig |  |  | Hrs. | 42
 |  | Wldr. Helper |  |  | Hrs. | 15
 |  | [NAME] |  | 10 | Hrs. | 18
 |  | [NAME] (2) |  | 20 | Hrs. | 16
 | EQUIPMENT:  Prepare site & handle material
 |  | R/T hoe w/ truck, trailer & operator |  |  | Hrs. | 65
 |  | [NAME] tools |  | 10 | Hrs. | 17
 |  | [NAME] |  |  | Hrs. | 15
 | Instalation:  Insturment / Electrical |  |  |  | Lot | 1500
 | Transportation |  |  |  | Lot | 700
 | SITE PREPERATION
 |  | Fence |  |  | Lot | 500
CONTRACT INSTALL. TOTAL
FIELD DIRECT COSTS SUB-TOTAL
TOTAL INSTALLED COST (Labor + Materials)