tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 887467d1737698707-slicer-example1
Sheet: RESULT

Company Name | C | UNIT | 35 |  | 00 | 35 | 40 | 41 | 45 | 46 | 47 | 51 | 55 | 58 | 75
 |  | Supply |  |  | A | B | C | NEW
 |  | Handling
 |  | Fabrication
Unit | Company Name | Sum of Stage 1 | Sum of Stage 2 | Sum of Stage 3
00 | A | 31.319 | 31.319 | 31.319
35 | A | 720.9550000000002 | 720.9550000000002 | 720.9550000000002
35 | B | 317.898 | 317.898 | 317.898
40 | A | 536.2200000000001 | 536.2200000000001 | 536.2200000000001
41 | A | 56.99500000000001 | 56.99500000000001 | 56.99500000000001
41 | B | 64.84099999999998 | 64.84099999999998 | 64.84099999999998
45 | A | 1129.522 | 1129.522 | 1129.522
45 | B | 276.328 | 276.328 | 276.328
46 | A | 78.18399999999998 | 78.18399999999998 | 78.18399999999998
46 | B | 3.27 | 3.27 | 3.27
47 | A | 193.3300000000001 | 193.3300000000001 | 193.3300000000001
47 | B | 58.105 | 58.105 | 58.105
51 | A | 15911.88100000006 | 15911.88100000006 | 15911.88100000006
51 | B | 6050.338 | 6050.338 | 6050.338
51 | C | 0 | 0 | 0
51 | NEW | 1434.467 | 1434.467 | 1434.467
55 | A | 1849.978999999997 | 1849.978999999997 | 1849.978999999997
55 | B | 281.934 | 281.934 | 281.934
55 | C | 0 | 0 | 0
58 | A | 85.05699999999997 | 85.05699999999997 | 85.05699999999997
58 | B | 1.699 | 1.699 | 1.699
75 | A | 1997.449999999997 | 1997.449999999997 | 1997.449999999997
75 | B | 264.593 | 264.593 | 264.593
Grand Total |  | 31344.36500000006 | 31344.36500000006 | 31344.36500000006
Spreadsheet: 00acdfd3-70f8-4bf8-bcdd-93a4cad77018
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | [NAME] №1
 |  |  |  | ПРИМЕРЕН  ОБРАЗЕЦ
[NAME] за пощенски запис за плащане на задължения към централния бюджет, НОИ и НЗОК от физическо лице.
ОБРАЗЕЦ НА ПОЩЕНСКИ ЗАПИС ЗА ПЛАЩАНЕ КЪМ БЮДЖЕТА
 | Обр. 702
 | “БЪЛГАРСКИ ПОЩИ”- ЕАД
 | Записът е за  …….…..лв.……ст
 | …………………………………………….
 | ( [NAME])
 | Н-к пощ.станция:……………………
 | (подпис и печат)
 | Цена за превод:……………………
 | Цена за банков превод:……………
 | [NAME] услуги:……………. |  |  |  |  | Изх. [NAME]                 Контролен печат
 | №…………..          Дата: ………………г.         Касиер:……………         Контрольор: ………………
[NAME] се от подателя | ПОЩЕНСКИ  ЗАПИС ЗА ПЛАЩАНЕ КЪМ БЮДЖЕТА за  283 лв.  20 ст.
 | [NAME]: ДВЕСТА ОСЕМДЕСЕТ И ТРИ ЛЕВА И ДВАДЕСЕТ СТОТИНКИ …………..............……………………………………………………………………………..
 |  |  | ПОЛУЧАТЕЛ: ТД на НАП [NAME] град офис Благоевград
 | Пощенски код              Банка РАЙФАЙЗЕНБАНК АД         BIC  RZBBBGSF
 | IBAN на сметка   BG10RZBB91558120002006     Вид плащане 111111
 | [NAME] за плащане  [NAME] към централния бюджет, НОИ и НЗОК
 | ([NAME], осигуровка - ДОО, НЗОК, [NAME],УчПФ, ГВРС, лихва и др.)
 | период за който се плаща от [NAME]
 | № |  |  | декларация,    РА, |  | други
 | нак. [NAME] ,      авансова вноска ;
 |  |  | [NAME]: гр.(с.) ………………………….. обл ……………………………. |  | БЛАГОЕВГРАД
 | Пощенски код |  | общ   Ул. |  | "КИРИЛ И МЕТОДИЙ"№30
 |  | ИВАН ИВАНОВ ИВАНОВ
 | (Трите имена на физическото лице или [NAME] на юридическото лице, ЕТ)
 | ЕГН (ЛНЧ)   [PHONE]     БУЛСТАТ………………..
 | №
 |  |  | ПОТВЪРДИТЕЛНО за  283 лв.  20 ст.
 |  |  | [NAME]: ДВЕСТА ОСЕМДЕСЕТ И ТРИ ЛЕВА И ДВАДЕСЕТ СТОТИНКИ …………..............……………………………………………………………………………..
 |  |  | ТД на НАП [NAME] град офис Благоевград
 | Изх.клеймо |  | [NAME] АД        BIC RZBBBGSF
 | IBAN на сметка   BG10RZBB91558120002006     Вид плащане 111111
 | [NAME]: гр.(с.) …………………………... обл ……………………  общ…………………….. |  | СОФИЯ
 | Ул. | "КИРИЛ И МЕТОДИЙ"№30
 |  | ИВАН ИВАНОВ ИВАНОВ
 | (Трите имена на физическото лице или [NAME] на юридическото лице, ЕТ)
 | ЕГН (ЛНЧ) [PHONE]  БУЛСТАТ….............……………………
 | [NAME] за плащане Задължения към централния бюджет, НОИ и НЗОК
 | ([NAME], осигуровка - ДОО, НЗОК, [NAME],УчПФ, ГВРС, лихва и др.)
 | период за който се плаща от [NAME]
 | № |  |  | декларация,    РА, |  | други
 | нак. [NAME] ,      авансова вноска ;
Разписка за машинна обработка
Spreadsheet: tracy_geaccone__40324__3rd CE supplement
Sheet: Upside_Downside

(In Millions)
Upsides / Downsides
 |  |  |  | Probability |  | Quarter | IBIT |  | Net Income |  | Funds Flow |  | Obligations
[NAME] loads |  |  |  |  |  | Q3/Q4
Power Costs (plant operations/market price) |  |  |  |  |  | Q3/Q4
FAS 133 |  |  |  |  |  | Q3/Q4
TOLI income |  |  |  | Dependant on market |  | Q3/Q4
Storm outages |  |  |  | $3 mm up or down |  | Q4
Trading reserves |  |  |  |  |  | Q3/Q4
Pelton/Round Butte Sale (move to Q1 2002) |  |  |  |  |  | Q4 | 8.3
Accounting changes and rate case implementation
to be reviewed by AA&Co.
Total
Please list items that could materially affect your current estimate.
Note:  Q3 and Q4 include $5.2 mm for goodwill transfer to ENA, assumed effective 7/1
Spreadsheet: 26261d1218237605-formula-to-put-a-cell-highlighed-book2-1-
Sheet: Sheet2

Export Load Report (actual) Melbourne - West Swanson 08/08/08 12:09 (Local Time)
Vsl | Voy | Container | Line | POL | POD | POD2 | Dest | F/E | Size | ISO Code | WT | Commodity | Description | Temp | Haz | Vent | Seal | Shipper | CAN | Booking ref | Intended Position | Actual Stow position | Received | Loaded | [NAME] | Customs Status
 |  | CRXU1587539 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1021
 |  | DFSU2099848 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | CMAU1101915 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | GESU2781714 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | UESU2369779 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1021
 |  | TTNU1830422 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | CLHU2689040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1021
 |  | ECMU1363564 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | ECMU1449760 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | CLHU2753936 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | TCKU2771306 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | ECMU1228570 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | ECMU1763344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1015
 |  | IPXU3881842 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1122
 |  | CRLU3167348 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM1029
 |  | ZCSU6009690
Spreadsheet: john_forney__15504__200107
Sheet: TECO-BRAZOS

EPMI-TECO-SVCE - BRAZOS SINK
 |  | Deal Number | Total
Static Scheduling | Reliant Energy HL&P
 | Texas New Mexico Power
 | [NAME]
 | [NAME] | 670794
Unplanned Losses | American Electric Power Services Corp | 670799
 | [NAME] | 670808
 | [NAME] | 670809
 | Bryan Texas Utilities | 670810
 | City of Denton Municipal Utilities | 670813
 | City of Garland | 670820
 | City Public Services | 670821
 | Farmer's Electric Cooperative
 | Grayson-Collin Electric Cooperative
 | Greenville Electric Utility System
 | Lower Colorado River Authority | 670822
 | Magic Valley Electric Cooperative
 | Public Utilities Board of Brownsville
 | Reliant Energy HL&P | 670825
 | Rio Grande Electric Cooperative
 | South Texas Electric Cooperative | 670827
 | Southwest Electric Service Company
 | Texas Municipal Power | 670829
 | Texas New Mexico Power | 670830
 | Tex-La Electric Cooperative
 | TXU Electric Services | 670832
The TECO deals with a BRAZOS (BEC) sink need to have
an offset annuity put in to keep TECO book flat
password for Totals sheet = ercot
 | Counterparty Name
 | TXU Electric Services
 | Texas New Mexico Power
 | Reliant Energy HL&P
 | City Public Services
 | American Electric Power Services Corp
 | Lower Colorado River Authority
 | American Electric Power Services Corp
 | [NAME]
 | [NAME]
 | Texas Municipal Power
 | South Texas Electric Cooperative
 | South Texas Electric Cooperative
 | Public Utilities Board of Brownsville
 | Southwest Electric Service Company
 | Farmer's Electric Cooperative
 | TXU Electric Services
 | TXU Electric Services
 | Tex-La Electric Cooperative
 | Magic Valley Electric Cooperative
 | South Texas Electric Cooperative
 | TXU Electric Services
 | City of Garland
 | Rio Grande Elerctic Cooperative
 | Grayson-Collin Electric Cooperative
 | Bryan Texas Utilities
 | City of Denton Municipal Utilities
 | Grrenville Electric Utiliy System
Spreadsheet: 130359d1322219963-help-needed-with-correct-formatting-across-muliple-sheets-and-data-sets-testing-fac
Sheet: FAC Tracker

FAC# | Location | Owner | Group | Approver | Description | Date Entered
1234 | A1 | xx | Group 1 | yy | zz | 2009-09-07 00:00:00
2345 | D6 | xx | Group 1 | yy | zz | 2004-10-08 00:00:00
3456 | B8 | xx | Group 2 | yy | zz | 2006-10-08 00:00:00
4567 | C7 | xx | Group 3 | yy | zz | 2003-07-07 00:00:00
Spreadsheet: 26048d1217936438-retreiving-data-from-vlookup-mikes-vlookup-part-3
Sheet: More Examples

 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  | 1 | Col 2 Line 1 | Col 3 Line 1 | Col 4 Line 1 | Col 5 Line 1 | Col 6 Line 1 | Col 7 Line 1
4 | Col 4 Line 4 | Col 7 Line 4 |  |  |  | 2 | Col 2 Line 2 | Col 3 Line 2 | Col 4 Line 2 | Col 5 Line 2 | Col 6 Line 2 | Col 7 Line 2
 |  |  |  |  |  | 3 | Col 2 Line 3 | Col 3 Line 3 | Col 4 Line 3 | Col 5 Line 3 | Col 6 Line 3 | Col 7 Line 3
 |  |  |  |  |  | 4 | Col 2 Line 4 | Col 3 Line 4 | Col 4 Line 4 | Col 5 Line 4 | Col 6 Line 4 | Col 7 Line 4
 |  |  |  |  |  | 5 | Col 2 Line 5 | Col 3 Line 5 | Col 4 Line 5 | Col 5 Line 5 | Col 6 Line 5 | Col 7 Line 5
 |  |  |  |  |  | 6 | Col 2 Line 6 | Col 3 Line 6 | Col 4 Line 6 | Col 5 Line 6 | Col 6 Line 6 | Col 7 Line 6
 |  |  |  |  |  | 7 | Col 2 Line 7 | Col 3 Line 7 | Col 4 Line 7 | Col 5 Line 7 | Col 6 Line 7 | Col 7 Line 7
 |  |  |  |  |  | 8 | Col 2 Line 8 | Col 3 Line 8 | Col 4 Line 8 | Col 5 Line 8 | Col 6 Line 8 | Col 7 Line 8
 |  |  |  |  |  | 9 | Col 2 Line 9 | Col 3 Line 9 | Col 4 Line 9 | Col 5 Line 9 | Col 6 Line 9 | Col 7 Line 9
 |  |  |  |  |  | 10 | Col 2 Line 10 | Col 3 Line 10 | Col 4 Line 10 | Col 5 Line 10 | Col 6 Line 10 | Col 7 Line 10
Spreadsheet: 880329d1727964090-trying-to-create-an-excel-doc-thatll-allow-me-to-schedule-people-on-projects-availability
Sheet: Pivot

Sum of Hours | Column Labels
Row Labels | 2024-10-07 00:00:00 | 2024-10-14 00:00:00 | 2024-11-04 00:00:00 | 2024-12-09 00:00:00 | 2024-12-23 00:00:00 | Grand Total
[NAME]
Stat Holiday |  | 7.5 |  |  | 15 | 22.5
Vacation |  |  |  | 37.5 |  | 37.5
Nia
Project ZYX |  |  | 20 |  |  | 20
Stat Holiday |  | 7.5 |  |  | 15 | 22.5
Sky
Project ABC | 37.5 |  |  |  |  | 37.5
Stat Holiday |  | 7.5 |  |  | 15 | 22.5
Grand Total | 37.5 | 22.5 | 20 | 37.5 | 45 | 162.5
Spreadsheet: 676285d1588734730-linking-two-cells-to-return-values-in-columns-2312-daily-production-report
Sheet: Daily Report

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weeknum | Date | Month | Year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  |  |  |  |  |  |  |  |  | Daily Production Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  | Week | Date | Shift
 |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-24 00:00:00 | 1st Shift
 |  |  |  |  |  |  |  |  |  |  | Department | Machine | Issue | Action | Downtime | Date
Spreadsheet: 60d00134-9014-4674-8cdd-70a7b6a69a7c
Sheet: EPS Contribution

Rent-A-Center, Inc.
Proforma Diluted EPS Quarterly Contribution 2009 - Q1 2012
 |  | 1Q |  |  | 2Q |  |  | 3Q |  |  | 4Q |  |  | Annual |  | STORES BY SEGMENT
Year |  | Diluted EPS | % of Total |  | Diluted EPS | % of Total |  | Diluted EPS | % of Total |  | Diluted EPS | % of Total |  | Diluted EPS |  | CORE US (1)(2) | RACA | MEX | CAN | TOTAL
2009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2989 | 82 | 0 | 18
2010 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2985 | 384 | 5 | 18
2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2994 | 750 | 52 | 28
2012 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 |  | 2983 | 763 | 57 | 30
(1) Primarily includes rent-to-own stores in the U.S. & Puerto Rico and GIN/Home Choice
(2) Exludes Financial Services (2009 - 353; 2010 - 111)
Spreadsheet: 815349d1674896730-sumif-formula-example
Sheet: Sheet3

List of all Green Bonds issued | Lead Manager / Underwriter | Amount Issued
ID | LEAD_MGR | AMT_ISSUED
051595BB Muni | MORGAN STANLEY & CO LLC | $                       45’000’000.00
02765UJU Muni | BANK OF AMERICA MERRILL | $                         1’840’000.00
02765UKL Muni | BANK OF AMERICA MERRILL | $                             330’000.00
[NAME] | BANK OF AMERICA MERRILL | $                         1’265’000.00
[NAME] | BANK OF AMERICA MERRILL | $                         1’685’000.00
02765UKP Muni | BANK OF AMERICA MERRILL | $                         1’750’000.00
[NAME] | BANK OF AMERICA MERRILL | $                             595’000.00
02765UKT Muni | BANK OF AMERICA MERRILL | $                             630’000.00
02765UKU Muni | BANK OF AMERICA MERRILL | $                             675’000.00
02765UKV Muni | BANK OF AMERICA MERRILL | $                         1’035’000.00
Spreadsheet: 467316d1466659777-data-categorized-by-month-in-pivot-table-tick-multiple-boxes-responses-in-one-cell-copy-of-summerproject_excel_help
Sheet: Sheet1

# | While completing your activities, were they… | The activities were ____ to do. | Which three activities did you like the most? | Which three activities did you like the least? | What is your age group? | Comments
1 | Very enjoyable | Too difficult | A, B, D | E, F, G | 18 to 24 |  |  | 18 to 24
2 | Enjoyable | Difficult | C, E, F | A, B, D | 25 to 36 |  |  | 25 to 36
3 | Alright | Somewhat easy | G, C, A |  | 37 to 45 | Great fun! |  | 37 to 45
4 | Not so enjoyable | Easy | D, E, G | E, A, F | 45 to 64 |  |  | 45 to 64
5 | Not enjoyable | Too easy | C, A, D |  | 65+ | You could have done this better. |  | 65+
6 | Abstained | Abstained | D, A, C | A, B, E | 18 to 24
 |  | 18 to 24
 |  | Activity | Most Popular | Least Popular
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | I
Spreadsheet: 843807d1695653127-creating-calendar-from-data-within-summary-page-of-workbook-rb-example
Sheet: 1

 |  |  |  |  |  | LODESTONE
 | [NAME]
 | PROJECT: |  | toilets |  | PROJECT NO: | 111
 | DATE to CLAIM RETENTION: |  | 2024-01-24 00:00:00
 |  |  |  |  |  |  | Agreed Final Account | 100
 |  |  |  |  |  |  | Amount paid to date | 90
 |  |  |  |  |  |  | Retention held on LPLL
 | [NAME]
 | Agreed Final Account |  | Sub Contractor | Paid to Date | Retention owed to SC | %
 | 0 | 1 |  | 0
 | 0 | 2 |  | 0
 |  | 3 |  | 0
 |  | 4 |  | 0
 |  | 5 |  | 0
 |  | 6 |  | 0
 |  | 7 |  | 0
 |  | 8 |  | 0
 |  | 9 |  | 0
 |  | 10 |  | 0
 |  | 11 |  | 0
 |  | 12 |  | 0
 |  | 13 |  | 0
 |  | 14 |  | 0
 |  |  | Totals
 |  |  |  |  |  |  | Sub Total
 | Less Provisions etc. |  |  |  |  |  |  | 0
 | [NAME] to LPLL
Spreadsheet: 762366d1641513904-sumif-for-multiple-columns-sumif
Sheet: Sheet4

Code | Key | Amt |  |  | Existing formula (SUM IF only on Col B which gives DR - 300 CR - 300 total)
CO_1234 | DR | 50
CO_1234 | CR | 80
CO_ABCD | DR | 250
CO_ABCD | CR | 220
 |  |  |  |  | Expected Result( SUM on Col A for each company code (DR +CR)
 |  |  |  |  | CO_1234 - Total CR-DR = 130
 |  |  |  |  | CO_ABCD - Total CR-DR = 470
Spreadsheet: 783560d1654906215-match-job-numbers-and-count-line-items-mins-per-line-item
Sheet: Job Times

Ref Number | Transaction Date | Total Hours | Start Time | End Time | Number of Line Items | Mins per Line
JS00207629 | 2022-05-16 00:00:00 | 0.8 | 06:14:00 | 07:02:00
JS00208541 | 2022-05-16 00:00:00 | 3.483 | 09:15:00 | 12:44:00
JS00208605 | 2022-05-18 00:00:00 | 1.25 | 07:05:00 | 08:20:00
JS00208654 | 2022-05-16 00:00:00 | 1.45 | 11:08:00 | 12:35:00
JS00208775 | 2022-05-17 00:00:00 | 0.5 | 07:36:00 | 08:06:00
JS00208833 | 2022-05-17 00:00:00 | 1.967 | 06:07:00 | 08:05:00
JS00208868 | 2022-05-16 00:00:00 | 0.883 | 07:38:00 | 08:31:00
JS00208869 | 2022-05-16 00:00:00 | 0.983 | 09:39:00 | 10:38:00
JS00208870 | 2022-05-17 00:00:00 | 1.367 | 10:06:00 | 11:28:00
JS00208881 | 2022-05-17 00:00:00 | 0.117 | 14:10:00 | 14:17:00
JS00208883 | 2022-05-16 00:00:00 | 0.483 | 08:31:00 | 09:00:00
JS00208886 | 2022-05-16 00:00:00 | 1.917 | 15:05:00 | 17:00:00
JS00208888 | 2022-05-16 00:00:00 | 0.567 | 07:04:00 | 07:38:00
JS00208891 | 2022-05-17 00:00:00 | 0.317 | 08:06:00 | 08:25:00
JS00208894 | 2022-05-16 00:00:00 | 1.85 | 07:02:00 | 08:53:00
JS00208895 | 2022-05-17 00:00:00 | 0.083 | 10:01:00 | 10:06:00
JS00208896 | 2022-05-17 00:00:00 | 0.65 | 09:19:00 | 09:58:00
JS00208897 | 2022-05-17 00:00:00 | 0.3 | 08:42:00 | 09:00:00
JS00208899 | 2022-05-17 00:00:00 | 0.417 | 12:08:00 | 12:33:00
JS00208903 | 2022-05-16 00:00:00 | 0.617 | 13:31:00 | 14:08:00
JS00208904 | 2022-05-18 00:00:00 | 1.733 | 06:07:00 | 07:51:00
JS00208910 | 2022-05-16 00:00:00 | 0.483 | 09:10:00 | 09:39:00
JS00208913 | 2022-05-17 00:00:00 | 0.167 | 09:05:00 | 09:15:00
JS00208915 | 2022-05-16 00:00:00 | 0.95 | 14:08:00 | 15:05:00
JS00208917 | 2022-05-17 00:00:00 | 0.367 | 10:45:00 | 11:07:00
JS00208934 | 2022-05-18 00:00:00 | 1.567 | 12:26:00 | 14:00:00
JS00208964 | 2022-05-17 00:00:00 | 0.95 | 13:03:00 | 14:00:00
JS00208967 | 2022-05-18 00:00:00 | 0.5 | 11:13:00 | 11:43:00
JS00208968 | 2022-05-18 00:00:00 | 0.35 | 11:13:00 | 11:34:00
JS00208969 | 2022-05-18 00:00:00 | 0.367 | 11:45:00 | 12:07:00
JS00208970 | 2022-05-18 00:00:00 | 1.083 | 09:40:00 | 10:45:00
[NAME] | 2022-05-18 00:00:00 | 0.15 | 11:21:00 | 11:30:00
JS00208973 | 2022-05-18 00:00:00 | 0.35 | 09:10:00 | 09:31:00
JS00208974 | 2022-05-17 00:00:00 | 1.783 | 14:25:00 | 16:12:00
JS00208977 | 2022-05-18 00:00:00 | 0.75 | 13:15:00 | 14:00:00
JS00208989 | 2022-05-19 00:00:00 | 3.233 | 07:23:00 | 10:37:00
JS00208995 | 2022-05-19 00:00:00 | 1.65 | 07:21:00 | 09:00:00
JS00208997 | 2022-05-19 00:00:00 | 1.783 | 07:13:00 | 09:00:00
JW00007821 | 2022-05-16 00:00:00 | 2.983 | 06:01:00 | 09:00:00
JW00007822 | 2022-05-17 00:00:00 | 0.633 | 10:52:00 | 11:30:00
Spreadsheet: 732442d1620959750-formula-to-look-for-a-value-in-a-column-and-return-the-value-of-another-cell-in-that-row-building-maintenance-record-test
Sheet: A313 

Assessment: |  | 313
Address: |  | Lot 144 Adam Street
 |  | Number 23
Purpose: |  | Vacant Block - House Removed
[NAME]: |  | 45
Asset Number: |  | 31
Maintenance Code: |  | BM04
Date Purchased: |  | 1993-12-06 00:00:00
Structure
Walls
Roofing
Summary
 |  | Notes
Date | Work Request | Description | Action Taken | Photo's
Spreadsheet: 704498d1605602607-retrieving-missing-values-from-a-list-list-example-excel
Sheet: Sheet1

 |  |  | List A |  |  | List B |  | List C
 |  |  | [NAME] |  |  | [NAME]
 |  |  | [NAME] |  |  | Lucas
 |  |  | [NAME] |  |  | [NAME]
 |  |  | Zlatan |  |  | [NAME]
 |  |  | [NAME] |  |  | Patrik
 |  |  | [NAME] |  |  | Patrik Junior
 |  |  | Lucas |  |  | [NAME]
 |  |  | Maria |  |  | Lennart
 |  |  | [NAME] |  |  | Kennet
 |  |  | [NAME]
 |  |  | Patrik
 |  |  | Patrik Junior
Spreadsheet: 774264d1648337222-copy-from-multiple-rows-and-paste-in-one-column-trans
Sheet: Sheet1

 |  |  |  |  |  | Year | 2000
 |  |  |  |  |  | Make | ac
 |  |  |  |  |  | Model | Cabriolet
 |  |  |  |  |  | Trim | Convertible
 |  |  |  |  |  | Year | 2000
 |  |  |  |  |  | Make | ac
 |  |  |  |  |  | Model
Year | Make | Model | Trim |  |  | Trim | NULL
2000 | ac | Cabriolet | Convertible |  |  | Year | 2000
2000 | ac |  | NULL |  |  | Make | ac
2000 | ac | 212 | Roadster |  |  | Model | 212
2000 | ac | MK IV | Roadster |  |  | Trim | Roadster
2000 | acura |  | Coupe |  |  | Year | 2000
2000 | acura |  | Coupe |  |  | Make | ac
2000 | acura |  | SUV |  |  | Model | MK IV
 |  |  |  |  |  | Trim | Roadster
 |  |  |  |  |  | Year | 2000
 |  |  |  |  |  | Make | acura
 |  |  |  |  |  | Model
 |  |  |  |  |  | Trim | Coupe
 |  |  |  |  |  | Year | 2000
 |  |  |  |  |  | Make | acura
 |  |  |  |  |  | Model
 |  |  |  |  |  | Trim | Coupe
 |  |  |  |  |  | Year | 2000
 |  |  |  |  |  | Make | acura
 |  |  |  |  |  | Model
 |  |  |  |  |  | Trim | SUV
Spreadsheet: 807968d1670199124-dynamic-dependent-dropdown-list-in-excel-categories-tms-v2
Sheet: Sheet1

 | STEP 1
 | Categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prep
 | Cat 1 | << 1. Up to 10 but not necessarily 10 (and with blanks) |  |  |  |  | << 2. Categories reorganized to remove blanks
 | Cat 2
 | Cat 3
 | Cat 4 |  |  |  |  |  |  |  | Cat 1 | << 3. Dropdown on only available categories, without blanks
 | Cat 5
 | Cat 6
 | Cat 7
 | STEP 2 | << Up to 16 but not necessarily 16 (and with blanks). Each associated with a Category
 | Sub Categories | Associated Cat
1 | Sub 1 | Cat 1 | << Using categories dropdown previously created to associate category to each sub
 | Sub 2 | Cat 4
 | Sub 3 | Cat 6
 | Sub4 | Cat 4 |  | Cat Dropdown
 | Sub 5 | Cat 2 |  | Cat 1
 | Sub 6 | Cat 3
 |  |  |  | [NAME]??
 | Sub7 | Cat 1
 | Sub 8 | Cat 7
 | Sub 9 | Cat 5
 | Sub 10 | Cat 6
 | Sub 11 | Cat 7
 | Sub 12 | Cat 5
 | Sub 13 | Cat 3
Spreadsheet: 826468d1682021797-sum-if-dates-are-in-current-month-sum-month-etaf
Sheet: Sheet1

Begin | End | Total
2023-07-01 00:00:00 | 01/13/2023 | 631.23
2023-02-02 00:00:00 | 02/08/2023 | 143.22
2023-10-02 00:00:00 | 02/23/2023 | 365.74
02/28/2023 | 03/02/2023 | 397.98
2023-03-03 00:00:00 | 03/30/2023 | 934.32
03/16/2023 | 04/02/2023 | 654.02
03/15/2023 | 03/26/2023 | 905.45
03/28/2023 | 04/10/2023 | 905.45 |  |  |  | 654.02
2023-04-04 00:00:00 | 04/17/2023 | 654.02 |  |  |  | 452.72
2023-12-04 00:00:00 | 04/18/2023 | 452.72 |  |  |  | 398.44
04/20/2023 | 04/26/2023 | 398.44 |  |  |  |  | target
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: NS Steel

 | North Star Steel
 | POI 500383 - North Start Steel IC
Day | Measured | Scheduled
1 | -2001 | -2139
2 | -79 | -2139
3 | -553 | -2453
4 | -1052 | -2453
5 | -1743 | -2453
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | -394456
2001-08-05 00:00:00
CBS Volume
 |  |  | -67276
Spreadsheet: afe84835-8f75-4bbc-bbc5-9abe71c318b4
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
CVID | Test | CVID | Common Variable Immunodeficiency Confirmation Flow Panel | CVID Confirmation Flow Panel | Fluorescent Flow Cytometry |  |  |  |  |  | Specimens are recommended to arrive within 24 hours of draw. Specimens must be received in the laboratory Monday through Friday (by 4 p.m. on Friday). No weekend processing. Draw and package specimen as close to shipping time as possible. Ship specimen overnight.   Container/Tube: Lavender top (EDTA) [NAME]: < or =14 years: 4 mL >14 years: 10 mL Collection Instructions: Send specimen in original tube. Do not aliquot. Additional Information: Ordering physician name and phone number are required. | < or =14 years: 3 mL >14 years: | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | %CD19+TACI+: >3.4%  %CD19+BAFF-R+: >90.2% Reference values apply to all ages. | Specimens are required to be received in the lab weekdays and by 4 pm on Friday. No weekend processing. | 3 days | 4 days |  | Profile |  |  |  |  | Rochester
CVID | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 48 hours
CVID | Result | 28113 | CD19+ TACI+ % of CD19 B cells | CD19+ TACI+ % of CD19 B cells | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
CVID | Result | 28121 | [NAME] of CD19 B cells | [NAME] of CD19 B cells | Alphanumeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | In Process
CVID | Result | 28124 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69052-9