tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 768276d1644914201-solved-if-a-specific-cell-contains-a-name-count-a-range-of-cells-0-excel-help-
Sheet: Sheet1

 |  |  |  | m3       Monday | m3       Tuesday | m3 Wednesday | m3     Thursday | m3            Friday | m3      Saturday | m3         Sunday |  |  | Total entrays
 | [NAME] |  |  | 2.5 | 3.5 | 1.5 | X | X | X | X |  | [NAME] | 10
 | [NAME] |  |  | X | X | X | 3 | 1 | X | X |  | [NAME] | 23
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | 1.5 | 2.5 | 3 | X | X | X | X
 |  |  |  | X | X | x | x | x | x | x
 | [NAME] |  |  | 2.5 | 1.5 | 2 | 2.5 | 3 | 5 | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | 3.5 | X | X | 3.5 | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | 4 | X | X | X | X | X | X
 | [NAME] |  |  | X | X | 2.5 | X | X | X | X
 | [NAME] |  |  | 1.8 | 4 | 4 | 2 | 2 | 3 | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | 1 | 4 | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | X | 3 | 4 | 3 | 2.5 | X | X
 | [NAME] |  |  | X | X | X | 4 | 1 | 2 | X
 | [NAME] |  |  | X | 2.5 | 2.5 | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | X | X | X | X | 2 | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
Spreadsheet: 747618d1631616811-need-to-get-the-sum-amount-based-on-certain-text-book1
Sheet: Sheet1

 |  |  |  |  |  |  | Expcted Results
 |  | Amount | Remarks |  |  |  | [NAME] | Total
 |  | 870 | Gan082021 |  |  |  | [NAME]
 |  | 935 | Gani082021 |  |  |  | Ram
 |  | 139 | Ram082021 |  |  |  | [NAME]
 |  | 61 | Rams082021 |  |  |  | TOTAL
 |  | 516 | Sams082021
 |  | 693 | SSams0821
 |  | 576 | AGan082021 |  |  |  | If column D contains any letter which is  mentioned in column H (Gan,Ram,[NAME]) then I need to get the total amount against each unique remarks colum. Note : currently I updated the result n column "I: manually
 |  | 224 | ARam082021
 |  | 103 | SSamsd0821
 |  | 588 | SSams0821
 |  | 348 | AGan082021
 |  | 561 | ARam082021
 | TOTAL
Spreadsheet: 01dc6baa-c314-42c5-8c25-7e0cab2f0a07
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | ФОРМА A-S
МЕЖДУНАРОДНАЯ ОРГАНИЗАЦИЯ ГРАЖДАНСКОЙ АВИАЦИИ
ФОРМА ОТЧЕТНОСТИ ПО ВОЗДУШНОМУ ТРАНСПОРТУ
ПЕРЕВОЗКИ КОММЕРЧЕСКИХ АВИАПЕРЕВОЗЧИКОВ
[NAME]
для связи : |  |  | Государство:
Организация:
[NAME].:
Факс:
E-mail: |  |  | Год:
 |  |  | ВСЕ ВИДЫ ПЕРЕВОЗОК |  |  |  | ТОЛЬКО ЧИСТОГРУЗОВЫЕ
 |  |  |  | ([NAME],почтовые и грузовые |  |  |  | ПЕРЕВОЗКИ
 |  |  | [NAME]) |  |  |  | (включенные в графы c и d)
Код | [NAME] | [NAME] |  | Классификация по этапам полета |  |  |  | Классификация по этапам полета
ИКАО |  | измерения | Международные |  | [NAME] |  | Международные |  | [NAME]
 | a | b | c |  | d |  | e |  | f
 | РЕГУЛЯРНЫЕ КОММЕРЧЕСКИЕ ПОЛЕТЫ
1010 | 1.   Самолето-километры | 000
1020 | 2.   Отправления воздушных судов | число
1030 | 3.   [NAME] часов | число
1040 | 4.   [NAME] пассажиров | число |  |  |  |  | - - |  | - -
1050 | 5.   [NAME] тонн груза | число
1060 | 6.   Выполненные пассажиро-километры | 000 |  |  |  |  | - - |  | - -
1070 | 7.   Располагаемые кресло-километры | 000 |  |  |  |  | - - |  | - -
1080 | 8.   Коэффициент пассажирской загрузки | % |  |  |  |  | - - |  | - -
1091 | 9.   Выполненные тонно-километры                                       .     a)  пассажиры ([NAME]) | 000 |  |  |  |  | - - |  | - -
1092 | b)  груз (включая срочный груз) | 000
1093 | c)  почта | 000
1094 | d) итого (9a- 9c) | 000
1100 | 10.   Располагаемые тонно-километры | 000
1110 | 11.  Коэффициент коммерческой загрузки | %
2010 | НЕРЕГУЛЯРНЫЕ КОММЕРЧЕСКИЕ ПОЛЕТЫ                12.  Самолето-километры | 000
2020 | 13.  Отправления воздушных судов | число
2030 | 14.  [NAME] часов | число
2040 | 15.  [NAME] пассажиров | число |  |  |  |  | - - |  | - -
2050 | 16.  [NAME] тонн груза | число
2060 | 17.  Выполненные пассажиро-километры | 000 |  |  |  |  | - - |  | - -
2070 | 18.  Располагаемые кресло-километры | 000 |  |  |  |  | - - |  | - -
2091 | 19.  Выполненные тонно-километры                                       .     a)  пассажиры ([NAME]) | 000 |  |  |  |  | - - |  | - -
2092 | b)  грузы (вкл. срочные) | 000
2093 | c)  почта | 000
2094 | d)  итого (19a - 19c) | 000
2100 | 20.  Располагаемые тонно-километры | 000
3020 | КОММЕРЧЕСКИЕ ПОЛЕТЫ АВИАТАКСИ                                      21.   Отправления воздушных судов | число
3030 | 22.   [NAME] часов | число
2330 | НЕКОММЕРЧЕСКИЕ ПОЛЕТЫ 21. [NAME] часов | число
Примечания (включая [NAME] [NAME] от инструкции по заполнению формы):
Spreadsheet: 826688d1682165184-copy-data-from-one-workbook-to-another-workbook-automatically-master-test-small-1-
Sheet: Day 3

MECH JUMPER TEST |  |  | DATE | 2023-03-26 00:00:00
 |  | SAP # | AMPS
 |  | 33413 | 111
 |  | 33435 | 222
 |  | 33472 | 333
 |  | 33337 | 444
 |  | 33629 | 555
 |  | 33336 | 666
 |  | 33360 | 777
 |  | 12345 | 11
Spreadsheet: 219127d1362672012-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 27

Admission and Discharges
2013
Date: | 2013-01-27 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
 | How many admits: 0001-0200: | 0 | How many  From ED | How many inpt | Total # Admits |  |  | How many d/c: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 0 | 0 | 0 | 0 |  |  | How many d/c: 0201-0400: | 0 | 0
 | How many admits: 0401-0600: | 0 | How many  From CDU | How many obs |  |  |  | How many d/c: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many d/c: 0601-0800: | 0
 | How many admits: 0801-1000: | 0 | How many from ASU |  |  |  |  | How many d/c: 0801-1000: | 0
 | How many admits: 1001-1200: | 0 | 0 |  |  |  |  | How many d/c: 1001-1200: | 0
 | How many admits: 1201-1400: | 0 | How many from OR |  |  |  |  | How many d/c: 1201-1400: | 0
 | How many admits: 1401-1600: | 0 | 0 |  |  |  |  | How many d/c: 1401-1600: | 0
 | How many admits: 1601-1800: | 0 | How many from CV |  |  |  |  | How many d/c: 1601-1800: | 0
 | How many admits: 1801-2000: | 0 | 0 |  |  |  |  | How many d/c: 1801-2000: | 0
 | How many admits: 2001-2200: | 0 | How many DA |  |  |  |  | How many d/c: 2001-2200: | 0
 | How many admits: 2201-2400: | 0 | 0 |  |  |  |  | How many d/c: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #
 | Maloney
Spreadsheet: 680742d1591176229-risk-assessment-matrix-riskassessment
Sheet: Screen4

Risk Assessment
RISK SCORE |  |  |  |  |  | 2
MITIGATION SCORE (out of 100) |  |  |  |  |  | 69 |  |  |  | MITIGATION SCORE
 |  |  |  |  |  |  |  |  |  | 76-100 | 51-75 | 26-50 | 0-25
 |  |  |  |  |  |  |  | RISK SCORE |  | 76 | 51 | 26 | 0
 | LOW |  |  |  |  |  |  | VERY LOW RISK | 0 | VERY LOW | VERY LOW | LOW | MODERATE |  | KEY
 |  |  |  |  |  |  |  | LOW RISK | 1 | VERY LOW | LOW | LOW | MODERATE |  | VERY LOW | Overall risk is consdiered very low
 |  |  |  |  |  |  |  | MODERATE RISK | 2 | LOW | LOW | MODERATE | VERY HIGH |  | LOW | Overall risk is low, however recommend checking…
 |  |  |  |  |  |  |  | HIGH RISK | 3 | MODERATE | MODERATE | VERY HIGH | VERY HIGH |  | MODERATE | Overall risk is moderate, recommend  significant efforts to improve mitigation measures or reduce risk…
 |  |  |  |  |  |  |  | VERY HIGH RISK | 4 | VERY HIGH | VERY HIGH | VERY HIGH | VERY HIGH |  | VERY HIGH | Overall risk of transmission is considered very high
Spreadsheet: michelle_lokay__26732__mojavesch
Sheet: Sheet1

Mojave Topock
Daily [NAME]
September 2000
 | mmbtus
2000-09-01 00:00:00 | 79695
2000-09-02 00:00:00 | 65000
2000-09-03 00:00:00 | 80460
2000-09-04 00:00:00 | 77839
2000-09-05 00:00:00 | 62960
2000-09-06 00:00:00 | 66375
2000-09-07 00:00:00 | 49549
2000-09-08 00:00:00 | 65000
2000-09-09 00:00:00 | 58825
2000-09-10 00:00:00 | 58486
2000-09-11 00:00:00 | 61151
2000-09-12 00:00:00 | 53431
2000-09-13 00:00:00 | 53921
2000-09-14 00:00:00 | 55000
2000-09-15 00:00:00 | 55000
2000-09-16 00:00:00 | 55000
2000-09-17 00:00:00 | 55000
2000-09-18 00:00:00 | 55000
2000-09-19 00:00:00 | 55000
2000-09-20 00:00:00 | 55000
2000-09-21 00:00:00 | 39000
2000-09-22 00:00:00 | 45650
2000-09-23 00:00:00 | 54000
2000-09-24 00:00:00 | 54000
2000-09-25 00:00:00 | 54000
2000-09-26 00:00:00 | 39000
2000-09-27 00:00:00 | 56111
2000-09-28 00:00:00 | 16748
2000-09-29 00:00:00 | 42570
2000-09-30 00:00:00 | 43795
Spreadsheet: 267288d1380035065-index-match-offset-sample
Sheet: Sheet1

Project # | Completion Date |  |  | Completion Date
123456 | 2013-09-20 00:00:00 | Project# | 123456 | 2013-09-20 00:00:00
Activity 1 | 2013-09-15 00:00:00 | Activity | Activity 1
Activity 2 | 2013-09-16 00:00:00
Activity 3 | 2013-09-17 00:00:00
Activity 4 | 2013-09-18 00:00:00
Activity 5 | 2013-09-19 00:00:00
Activity 6 | 2013-09-20 00:00:00
123457 | 2013-09-23 00:00:00
Activity 3 | 2013-09-21 00:00:00
Activity 4 | 2013-09-22 00:00:00
Activity 5 | 2013-09-23 00:00:00
123458 | 2013-09-12 00:00:00
Activity 1 | 2013-09-10 00:00:00
Activity 3 | 2013-09-11 00:00:00
Activity 5 | 2013-09-12 00:00:00
Spreadsheet: 881248d1729238973-email-alert-if-date-exceed-due-date-and-status-cell-open-maaxtestbook1
Sheet: Master

Part Number | Description | Rev | Qty X | Order Date | Reference 2 | Qty | X Required | Due Date |  | X Complete | X Date Complete | X submitted Date | X Accepted Date | Notes | Status | Rem 1 Date | Rem 2 Date | Rem 3 Date | Owned By | [NAME]
12345 | part | 1 | 24 | 2024-10-01 00:00:00 | REF123 | 1 | Yes | 2025-01-01 00:00:00 |  | N |  |  |  | NA | Open | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2024-12-16 00:00:00 | [EMAIL] | [EMAIL]
Spreadsheet: 801576d1666261778-if-cell_1-x-from-list-1-then-cell_2-x-expanded-from-list-2-doc_register_003
Sheet: Register

 | Group |  | Document Type |  | Numerical Identifier | Document Number | Document Title | Date Released | Next Scheduled Review | DAYS
 | A |  | AA
 | A |  | BB
 | A |  | CC
 | A |  | DD
 | A |  | EE
 | A |  | FF
 | A |  | GG
 | A |  | HH
 | A |  | JJ
 | A
 | A |  | AA
 |  |  | AA
 | A
 | A |  | AA
 | B |  | AA
 | B |  | BB
 | B |  | AA
Spreadsheet: 685632d1594119797-list-most-frequently-occurring-strings-n-most-repetitive-words-in-a-sheet-range-sample2
Sheet: ResultSheet

 |  | For the range --> TargetSheet!$A$1:$ZZ$1000 |  |  |  |  | For the range --> TargetSheet!$A$1:$F$1000
 |  | As you can see no data is shown probably because of pivotTable. |  |  |  |  | In this case data is shown.
 |  |  | 1 |  |  |  |  | 2
Spreadsheet: 137842d1327406486-ytd-average-required-excel-prob
Sheet: Sheet1

 |  | HQ | STOKIST | SALE | OCT | NOV | DEC | JAN | FEB | [NAME] | OCT-MARCH | OCT-MARCH
 |  |  |  |  | VALUE | VALUE | VALUE | VALUE | VALUE | VALUE | TOTAL | YPM
 |  | ASANSOL | B.K.MEDICAL AGENCY | PRI | 64104 |  | 23996
 |  |  |  | SEC
 |  |  | HINDUSTAN DISTRIBUTOR | PRI |  | 14517 | 33414
 |  |  |  | SEC
 |  | ASANSOL TOTAL |  | PRI
 |  |  |  | SEC
 |  | BURDWAN | CHOWDHURY AGENCY | PRI |  |  | 19546
 |  |  |  | SEC |  |  | 6587
 |  |  | JASHODA PHARMACY | PRI | 76195 |  | 14517
 |  |  |  | SEC
 |  | BURDWAN TOTAL |  | PRI
 |  |  |  | SEC
Spreadsheet: 671260d1586331961-update-defining-exact-length-of-string-for-istext-within-aggregate-function-00-wages-template-for-tests
Sheet: 04 THURSDAY

DAY: |  | THURSDAY |  | DATE:
No. |  | NAME |  |  |  | FROM | TO | Wh | VL | SL | OT | F/L | Hr | F/L | Hr | F/L | Hr | F/L | Hr | JOBS | Hr | GR/WS | Hr | CHECK |  | JOBS BREAKDOWN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
12 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | [NAME] |  |  | GROUPAGE
11 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | DRIVERS |  |  | DRIVERS
14 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | PART TIMERS |  |  | PART TIMERS
33 | O |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - |  | WELDERS |  |  | WELDERS
37 | W
27 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS
53 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
54 | W
50 | W |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
30 | P
31 | P
32 | P
51 | P
52 | P
55 | P
15 | P
23 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REPAIRS MT
26 | P |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JOBS | HR | WD | PT | DR
6 | D
10 | D
47 | D
[NAME] |  |  |  |  | GROUPAGE |  |  | IDLE TIME |  |  |  |  | JOBS |  |  |  | REPAIRS MT |  |  |  | WORKSHOP WS
JOBS |  |  | HR |  | JOBS | HR |  | JOBS |  |  | HR |  | JOBS |  | HR |  | JOBS |  | HR |  | JOBS |  | HR
TOTAL |  |  |  |  | TOTAL |  |  | TOTAL |  |  |  |  | TOTAL |  |  |  | TOTAL |  |  |  | TOTAL
 |  |  |  |  | Hours Calculator |  |  |  |  |  |  |  |  |  |  | TOTAL 2 |  |  |  |  | TOTAL 1
Spreadsheet: 742127d1627548600-get-calculations-to-spill-along-with-the-filtered-or-uniqued-data-samplez
Sheet: Main Sheet

 | SIT. |  | Check | CURRENT | Balance |  |  |  |  |  | FLEET | Code | LOC
AAB111 |  |  |  |  |  |  |  |  |  |  | BHF321 | 21
ADB153 |  |  |  | CLD589 |  |  |  |  |  |  | CLD589 | 84
ACF458 |  |  |  | CFY414 |  |  |  |  |  |  | CFY414 | 95
BND225 |  |  |  | EFS309 |  |  |  |  |  |  | EFS309 | 11
BHF321
BGH854
CLD589
CFY414
DDE220
EFS309
0
Spreadsheet: 5d425d25-b09b-4f7e-887a-2389d4677b23
Sheet: Sheet1

DO NOT CHANGE | Unnamed: 1
AFC EAST | NFC EAST
bills | redskins
dolphins | giants
patriots | [NAME]
jets | cowboys
AFC NORTH | NFC NORTH
bengals | bears
browns | lions
ravens | packers
steelers | vikings
AFC SOUTH | NFC SOUTH
colts | buccaneers
texans | saints
[NAME] | falcons
titans | panthers
AFC WEST | NFC WEST
broncos | 49ers
chiefs | rams
raiders | seahawks
chargers | cardinals
DO NOT CHANGE
Spreadsheet: 39711d1237997837-data-validation-throwing-me-a-delimited-error-sampledelim
Sheet: Sheet2

 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 11
 | 22
 | 33
 | 44
 | 55
 | 66
 | 77
 | 88
 | 99
 | 111
 | 222
 | 333
 | 444
 | 555
 | 666
 | 777
 | 888
 | 999
 | 1111
 | 222
 | 3333
 | 4444
 | 5555
 | 6666
 | 7777
 | 8888
 | 9999
 | 11111
 | 22222
 | 33333
 | 44444
 | 55555
 | 66666
 | 77777
 | 88888
Spreadsheet: benjamin_rogers__1166__Contacts
Sheet: Sheet1

Origination
QF Restructuring / East Coast Power
 | Extension | Cellular | Fax
Duran, [NAME] | x37364 | [PHONE] | 646.8717
[NAME] | (212)702.3938 | [PHONE] | [PHONE]
*[NAME] | (212)702.3906 | [PHONE] | [PHONE]
Marks, [NAME] | x37212 | [PHONE] | 646.8717
**Lydecker, [NAME] | x33504 | [PHONE] | 646.8553
Alford, [NAME] | x35109 | [PHONE]
[NAME], [NAME]/Assistant | X39582 |  | 646.8717
*Mont, [NAME] / Assistant | (212)702.3940
**Mitchell, [NAME] / Assistant | x33500
IPP Merchant Services /Power Plant Development |  |  |  | Generation Transaction Development
 | Extension | Cellular | Fax |  | Extension | Cellular | Fax
[NAME], [NAME] | [NAME] | [PHONE] | 646.3421 | Suffield, [NAME] | x58286 | [PHONE] | 646.8717
Generation |  |  |  | Kelemen, [NAME] | x39579 | [PHONE] | 646.8717
[NAME], [NAME] | x36173 | [PHONE] | 646.3421 | Adams, [NAME] | [NAME] |  | 646.8717
Spears, Clay | x30442 | [PHONE] | 646.3421 | Bersiani, [NAME] | x57664 | [PHONE]
[NAME], [NAME] | x57219 | [PHONE] | 646.3421 | [NAME], [NAME] | x39943 |  | 646.8717
Mitro, Fred | x35406 | [PHONE] | 646.3421 | Hill, [NAME] | x36027 |  | 646.8717
Virgo, [NAME] | x35353 | [PHONE] | 646.3037 | Hoff, [NAME] | x57368 |  | 646.8717
[NAME], [NAME] | x34205 | [PHONE] | 646.3037 | Hoover, [NAME] | x34307 | [PHONE] | 646.8717
*Black, [NAME] | x34750 | [PHONE] | 646.4940 | House, [NAME] | x37558 | [PHONE] | 646.8717
Moore, [NAME] | x35774 | [PHONE] | 646.3421 | Keeney, [NAME] | [NAME] |  | 646.8717
[NAME], [NAME] | x34321 |  |  | King, [NAME] | x37810 | [PHONE] | 646.8717
IPP | Extension | Cellular | Fax | Landry, Chad | x39837 |  | 646.8717
Healy, Scott | x37639 | [PHONE] | 646.4940 | [NAME], Clement | x39446 |  | 646.8717
*Swank, [NAME] | x37194 | [PHONE] | 646.3421 | Rogers, [NAME] | x37998 |  | 646.8717
*[NAME]/Assistant | x30497 |  |  | Tennant, Tina/Assistant | x58487 |  | 646.8717
 |  |  |  | [NAME], [NAME]
 |  |  |  | Vasquez, Miguel | x33910 |  | 646.8717
Spreadsheet: 37207d1235144950-help-master-sheet-to-sub-cat-sheets-issuetracker-1
Sheet: Code Sheet

Committees | Areas
Standard | [NAME]
Global | Associate Entrance
Housek/Fitness | Associate Ladies' LR
F&B | Associate Men's LR
Recovery | B1 Level
 | Balcony Room
 | Ball Room
 | Ball Room Foyer
 | Ball Room Restroom
 | [NAME]
 | [NAME]
 | Business Center
 | [NAME]
 | Compactor Area
 | East Side Exterior
 | Empl. Cafeteria
 | Executive Offices
 | Exercise Room
 | Fairfax Lounge
 | Front Desk Area
 | Front Entrance
 | Front Lobby
 | Front Ramp
 | Garage
 | Hunt Room
 | [NAME]
 | [NAME]
 | Laundry
 | Loading Dock
 | [NAME] Room
 | [NAME] Room
 | North Side Exterior
 | Whitehall Room
 | 2nd [NAME] Room
 | 2nd [NAME]
 | 1st Floor
 | 2nd Floor
 | 3rd Floor
 | 4th Floor
 | 5th Floor
 | 6th Floor
 | 7th Floor
 | 8th Floor
Spreadsheet: 52e52413-afb3-4b5b-92f6-2a63b92806f9
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 82. Value of Building Approved, Chain Volume Measures, Original - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total houses ;  New ; |  |  | Original | A590547W | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total other residential building ;  New ; |  |  | Original | A590548X | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A590549A | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590550K | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590551L | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590552R | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590553T | 1985-09-01 00:00:00 | 2009-03-01 00:00:00 | 95 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 5383c266-1d31-4bf9-96e2-ea452706138b
Sheet: MARKET

 |  |  | Nombre / | Numero |  |  | Nombre / | Numero
 |  |  | Area | Red |  |  | Area | Red
 |  |  | Beam Oeste | GLA-0 |  |  | Argentina | GLA-527
 |  |  | Beam Sur | GLA-1 |  |  | Aruba / Curacao | GLA-xxx
 |  |  | Beam PR | GLA-2 |  |  | Barbados | GLA-xxx
 |  |  |  |  |  |  | Chile | GLA-514
 |  |  | Puerto Rico | GLA-512 |  |  | Colombia | GLA-xxx
 |  |  |  | GLA-513 |  |  | Ecuador | GLA-xxx
 |  |  | Chile | GLA-514 |  |  | El Caribe Regional | GLA-xxx
 |  |  | Peru | GLA-515 |  |  | Peru | GLA-515
 |  |  |  | GLA-516 |  |  | Puerto Rico | GLA-512
 |  |  |  | GLA-517 |  |  | Trinidad / Tobago | GLA-xxx
 |  |  |  | GLA-518 |  |  | Uruguay | GLA-xxx
 |  |  |  | GLA-519 |  |  | Venezuela | GLA-xxx
 |  |  |  | [NAME] |  |  | Virgin Islands | GLA-528
 |  |  |  | GLA-521
 |  |  |  | GLA-522
 |  |  |  | GLA-523
 |  |  |  | GLA-524
 |  |  |  | GLA-525
 |  |  |  | [NAME]
 |  |  | Argentina | GLA-527
 |  |  | Virgin Islands | GLA-528
 |  |  |  | GLA-529
 |  |  |  | GLA-530
 |  |  |  | GLA-531
 |  |  |  | GLA-532
 |  |  |  | GLA-533
 |  |  |  | [NAME]
 |  |  |  | GLA-535
 |  |  |  | GLA-536
 |  |  |  | GLA-537
 |  |  |  | GLA-538
 |  |  |  | GLA-539
 |  |  |  | GLA-540
 |  |  |  | GLA-541
 |  |  |  | GLA-542
 |  |  |  | GLA-543
 |  |  |  | GLA-544
 |  |  |  | [NAME]
 |  |  |  | GLA-546
 |  |  |  | GLA-547
 |  |  | Hybrid | GLA-40966
 |  |  | Hybrid | GLA-40967
 |  |  | Hybrid | GLA-40968
 |  |  | Hybrid | GLA-40973
Spreadsheet: 865005d1712123429-maybe-a-vlookup-or-something-close-help
Sheet: Sheet1

 | TAB 1 |  |  |  | TAB 2
 | Employee | Monday |  |  |  | Search Each Type of area for employee name
 | [NAME] |  |  |  |  | Monday
 | [NAME] |  |  |  | Ice Station 1 | [NAME]
 | [NAME] |  |  |  | Ice Station 2 | [NAME]
 | [NAME]
 | [NAME] |  |  |  | Dry Station 1 | [NAME]
 | [NAME] |  |  |  | Dry Station 2 | [NAME]
 |  |  |  |  | Totes Station 1 | [NAME]
 |  |  |  |  | Totes Station 2 | [NAME]
Spreadsheet: 849812d1700194386-zero-days-formula-support-required-zero-days-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zero Days tracker
 |  |  | 1 | 2 | 3 | 4 | 5 | 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 | Requried output
 |  | A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0
 |  | C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | D | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 |  | E | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Spreadsheet: 763298d1642096206-simplify-this-spreadsheet-into-formulas-test_no-solver
Sheet: Sheet1

Input 1 = | 70.2
Input 2 = | 10
 |  |  |  |  |  |  | 80 | Size |  | Quantity
 |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 0
 | 1
 | 2
 | 3
 | 4
20 | 5
Size | 6
 | 7
Quantity | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20