tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 141313d1329215525-search-common-values-with-different-physical-locations-ef40_example2
Sheet: Sheet2

 |  |  | Date | [NAME] | PO Number | Description | OGS Job Number | Qty | AN Number | Eng | Comments | Location | OGS Part Number | GRN Number |  | seq
 |  |  | 2011-10-12 00:00:00 | routeco | 114081 | picoview | s14965 | 1 | 1143366 | amcg | no blue | A1 |  | 30957
 |  |  | 2011-10-12 00:00:00 | gas arc | 114119 | changeover | p16347 | 1 | 72397 | ms | no blue | floor |  | 30956
 |  |  | 2011-10-12 00:00:00 | edmundsons | 114256 | enclosures | n15023 | 5 | 150088374 | dw |  | C2 |  | 30955
 |  |  | 2011-10-12 00:00:00 | edmundsons | 114256 | mcb | n15023 | 5 | 150088311 | rg |  | C4 |  | 30954
 |  |  | 2011-10-12 00:00:00 | edmundsons | 14217 | din rail | n14700 | 5 | 150088266 | cm |  | floor |  | 30953
 |  |  | 2011-10-12 00:00:00 | vulcan | 114258 | various nuts | cons | 1300 | 174512 | ad | p/ship | issued |  | 30952
 |  |  | 2011-10-12 00:00:00 | routeco | 114081 | vents | s14965 | 8 | 1871 | amcg |  | D4 |  | 30951
 |  |  | 2011-10-12 00:00:00 | [NAME] | 114227 | labels | a16324 | 1 | 39442 | jd |  | issued  [NAME] |  | 30950
 |  |  | 2011-10-12 00:00:00 | powersolve | 114181 | power supplys and modules | n14700 | 18 | 14498 | cm |  | b2 |  | 30949
 |  |  | 2011-10-12 00:00:00 | vulcan | 114210 | cutting wheel | cons | 2 | 174244 | ad |  | issued |  | 30948
 |  |  | 2011-10-11 00:00:00 | CABLE SYSTEMS | 114174 | HAWKE GLAND KIT | N16229 | 4 | 104550/01 | [NAME] | BACK-ORDER | C2 |  | 30947
Spreadsheet: 97298d1296512986-excel-2007-formula-and-conditional-formatting-for-cell-color-and-data-pull-color_formula_example
Sheet: Sheet1

Random Data | Random Data | Random Data | Random Data | Used Cell | Random Data | Random Data | Random Data | Random Data | Random Data | Random Data | Random Data | Used Cell | Used Cell
 |  |  |  | Snow |  |  |  |  |  |  |  | dry | 12
 |  |  |  | Rain |  |  |  |  |  |  |  | clear | 11
 |  |  |  | Sleet |  |  |  |  |  |  |  | sunny | 5
 |  |  |  | Hail |  |  |  |  |  |  |  | snow | 4
 |  |  |  | Hazey |  |  |  |  |  |  |  | rain | 99
 |  |  |  |  |  |  |  |  |  |  |  | monsoon | 4
 |  |  |  |  |  |  |  |  |  |  |  | cloudy | 22
 |  |  |  |  |  |  |  |  |  |  |  | sleet | 1
 |  |  |  |  |  |  |  |  |  |  |  | hail | 21
 |  |  |  |  |  |  |  |  |  |  |  | Hazey | 44
Spreadsheet: 0af3e029-6f66-4f19-a12c-d5e5fc1c7b2c
Sheet: A

Course color corresponds with term of offering.  RED for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term. Summer School are in BLUE.
 | AOK Designation | CAR Designation | Comment
American Studies
AMST 309 | Arts & Literature-Literature |  | cross-listed with COMM 309
AMST 350 | Arts & Literature-Literature
AMST 351 | Arts & Literature-Literature
AMST 355 | Arts & Literature-Arts
AMST 356 | Arts & Literature-Literature
AMST 357 | Arts & Literature-Literature
AMST 358 | Arts & Literature-Literature
Arabic
ARAB 211-212 | Foreign Language
Archaeology
ARCH 221 | Natural & Math Sciences w/Lab | Experiential-Travel* | * when course travels-the course does not travel for all offerings
ARCH 450 |  | Experiential-Field Study; Capstone | cross-listed with CLAS 450
ARCH 495 |  | Capstone
[NAME]
ARTH 201 | Arts & Literature-Arts
ARTH 202 | Arts & Literature-Arts
ARTH 210 | Arts & Literature-Arts |  | cross-listed with CLAS 210
 | OR [NAME] (as HIST 101) | Non-Western
ARTH 211 | Arts & Literature-Arts | Non-Western | cross-listed with CLAS 211
ARTH 212 | Arts & Literature-Arts |  | cross-listed with CLAS 212
ARTH 213 | Arts & Literature-Arts |  | cross-listed with CLAS 213
ARTH 214 | Arts & Literature-Arts | Experiential-Travel* | cross-listed with CLAS 214  *when the course travels
ARTH 215 | Arts & Literature-Arts
ARTH 216 | Arts & Literature-Arts
ARTH 217 | Arts & Literature-Arts |  | cross-listed with CLAS 217
ARTH 219 | Arts & Literature-Arts
ARTH 222 | Arts & Literature-Arts | Experiential-Travel
ARTH 223 | Arts & Literature-Arts
ARTH 224 | Arts & Literature-Arts
ARTH 225 | Arts & Literature-Arts
ARTH 226 | Arts & Literature-Arts
ARTH 227 | Arts & Literature-Arts | Non-Western
ARTH 228 | Arts & Literature-Arts | Non-Western
ARTH 235 | Arts & Literature-Arts | Non-Western
ARTH 240 | Arts & Literature-Arts
ARTH 305 | Arts & Literature-Arts
ARTH 381 |  | Experiential-Research
ARTH 381 |  | Non-Western | FALL 2012(Coptic Art in Egypt)
ARTH 382 |  | Experiential-Research
ARTH 422 |  | Experiential-Research; Capstone
ARTH 450 |  | Capstone
Arts Management
AMGT 441 |  | Experiential-Internship; Capstone
Astronomy
ASTR 101 | Natural & Mathematical Sciences-Nat Sci w Lab
ASTR 231 | Natural & Mathematical Sciences-Nat Sci w/out Lab
ASTR 232 | Natural & Mathematical Sciences-Nat Sci w/out Lab
Asian Studies
ASTU 230 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 230
ASTU 231 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 231
ASTU 232 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 232
ASTU 233 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 233
ASTU 290 |  | Non-Western | cross-listed with HIST 290
ASTU 292 | Arts & Literature-Arts | Non-Western | cross-listed with FILM 292
ASTU 381 |  |  | J-term travel 2015(Religions in Japanese History)
ASTU 381 | Arts & Literature--Literature | Non-Western | Japanese Literature: [NAME], Sp 2013
ASTU 390 |  | Non-Western
ASTU 401 |  | Capstone
ASTU 450 |  | Experiential-Internship
ASTU 481 |  | Experiential-Research
ASTU 482 |  | Experiential-Research
Spreadsheet: 726763d1617439271-if-today-monday-give-me-previous-week-friday-workday-aligw
Sheet: Sheet1

 |  | 2021-03-27 00:00:00
 |  | 2021-03-28 00:00:00
 |  | 2021-03-29 00:00:00
 |  | 2021-03-30 00:00:00
 |  | 2021-03-31 00:00:00
 |  | 2021-04-01 00:00:00
 |  | 2021-04-02 00:00:00
 |  | 2021-04-03 00:00:00
 |  | 2021-04-04 00:00:00
 |  | 2021-04-05 00:00:00
 |  | 2021-04-06 00:00:00
 |  | 2021-04-07 00:00:00
 |  | 2021-04-08 00:00:00
Spreadsheet: 866688d1713586391-allocate-a-total-to-10-people-based-on-shares-event-split-2024-jt
Sheet: Sheet1

Total
Less 3%
Distributed
50% team allocation
10% event
30% RESORT
10% social fund
Event | Total | 1 | 0.5 | A | B | C | D | E | F | H | I | J | K
x event | 1000 | 6 | 4
y event | 2000 | 5 | 6
a event | 5000 | 6 | 5
Event | Total | 0.5
Spreadsheet: 0f92affa-ea4c-4b88-9294-c33c78e5b60c
Sheet: Age

Tract Number | Total Population | Under 5 | 5 to 17 | 18 to 24 | 25 to 34 | 35 to 44 | 45 to 54 | 55 to 64 | 65 to 74 | 75 to 84 | 85+ | 65+
3521 | 3042 | 69 | 151 | 572 | 807 | 505 | 365 | 226 | 175 | 140 | 32 | 347
3522 | 2021 | 74 | 166 | 193 | 445 | 288 | 228 | 168 | 229 | 180 | 50 | 459
3523 | 2229 | 105 | 215 | 323 | 706 | 346 | 211 | 109 | 108 | 89 | 17 | 214
3524 | 1942 | 153 | 451 | 251 | 366 | 309 | 200 | 126 | 49 | 29 | 8 | 86
3525 | 3312 | 158 | 533 | 527 | 789 | 515 | 406 | 171 | 108 | 82 | 23 | 213
3526 | 2652 | 120 | 412 | 358 | 668 | 392 | 265 | 158 | 153 | 107 | 19 | 279
3527 | 2407 | 137 | 339 | 305 | 544 | 359 | 250 | 162 | 180 | 92 | 39 | 311
3528 | 2385 | 89 | 322 | 315 | 607 | 405 | 273 | 160 | 99 | 90 | 25 | 214
3529 | 2553 | 113 | 205 | 199 | 809 | 404 | 398 | 211 | 120 | 75 | 19 | 214
3530 | 3706 | 152 | 309 | 430 | 1078 | 593 | 472 | 300 | 205 | 129 | 38 | 372
3531 | 8064 | 206 | 327 | 4699 | 1933 | 363 | 229 | 141 | 84 | 66 | 16 | 166
3532 | 3143 | 132 | 334 | 408 | 862 | 500 | 389 | 224 | 151 | 109 | 34 | 294
3533 | 3636 | 163 | 378 | 328 | 1063 | 614 | 537 | 277 | 147 | 90 | 39 | 276
3534 | 2430 | 153 | 353 | 307 | 616 | 403 | 272 | 176 | 82 | 51 | 17 | 150
3535 | 2599 | 126 | 293 | 338 | 693 | 382 | 328 | 189 | 134 | 92 | 24 | 250
3536 | 4742 | 112 | 259 | 1460 | 1493 | 476 | 486 | 267 | 100 | 62 | 27 | 189
3537 | 5246 | 88 | 211 | 2377 | 1073 | 534 | 405 | 234 | 144 | 105 | 75 | 324
3538 | 4636 | 144 | 194 | 508 | 1816 | 785 | 522 | 311 | 169 | 126 | 61 | 356
3539 | 5923 | 123 | 139 | 3790 | 1176 | 290 | 162 | 102 | 64 | 58 | 19 | 141
3540 | 4649 | 104 | 148 | 1508 | 1150 | 579 | 485 | 329 | 191 | 119 | 36 | 346
3541 | 2704 | 65 | 140 | 165 | 673 | 358 | 384 | 403 | 279 | 173 | 64 | 516
3542 | 3063 | 141 | 359 | 138 | 426 | 417 | 542 | 452 | 279 | 214 | 95 | 588
3543 | 3266 | 168 | 446 | 234 | 635 | 520 | 446 | 282 | 222 | 208 | 105 | 535
3544 | 1714 | 101 | 196 | 96 | 350 | 321 | 297 | 153 | 104 | 70 | 26 | 200
3545 | 2405 | 110 | 180 | 183 | 699 | 379 | 324 | 281 | 152 | 76 | 21 | 249
3546 | 4409 | 295 | 613 | 395 | 894 | 758 | 596 | 342 | 223 | 201 | 92 | 516
3547 | 2481 | 130 | 218 | 211 | 710 | 416 | 329 | 199 | 136 | 97 | 35 | 268
3548 | 2049 | 105 | 190 | 199 | 595 | 351 | 279 | 144 | 97 | 63 | 26 | 186
3549 | 5235 | 379 | 986 | 447 | 909 | 1000 | 715 | 346 | 269 | 143 | 41 | 453
3550 | 2712 | 110 | 255 | 208 | 617 | 380 | 349 | 223 | 234 | 226 | 110 | 570
Citywide | 101355 | 4125 | 9322 | 21472 | 25202 | 13942 | 11144 | 6866 | 4687 | 3362 | 9282 | 17331
Spreadsheet: 8f3a0040-0f65-4989-844d-d2e33e62e732
Sheet: Table 8.3

8.3 Unemployment rates
 |  |  |  |  |  | Months (a)
 | Annual average (a) (b) |  |  |  |  | 2013
Country | 2009 | 2010 | 2011 | 2012 |  | June | July | Aug | Sep
Australia | 5.600000000000001 | 5.2 | 5.100000000000001 | 5.2 |  | 5.7 | 5.7 | 5.8 | 5.600000000000001
Canada | 8.3 | 8 | 7.5 | 7.2 |  | 7.100000000000001 | 7.2 | 7.100000000000001 | 6.9
France | 9.5 | 9.700000000000001 | 9.6 | 10.2 |  | 10.9 | 11 | 11 | 11.1
Germany | 7.8 | 7.100000000000001 | 6 | 5.5 |  | 5.3 | 5.3 | 5.3 | 5.2
Italy | 7.8 | 8.4 | 8.4 | 10.7 |  | 12.1 | 12.1 | 12.4 | 12.5
Japan | 5.100000000000001 | 5.100000000000001 | 4.600000000000001 | 4.4 |  | 3.9 | 3.8 | 4.1 | 4
New Zealand (c) | 6.100000000000001 | 6.5 | 6.5 | 6.9 |  | 6.4
United Kingdom | 7.600000000000001 | 7.8 | 8 | 7.9 |  | 7.7 | 7.600000000000001
United States | 9.3 | 9.6 | 9 | 8.1 |  | 7.600000000000001 | 7.4 | 7.3 | 7.2
OECD average | 8.1 | 8.3 | 8 | 8 |  | 8 | 7.9 | 7.9 | 7.9
G7 average | 8.03 | 8.19 | 7.68 | 7.42 |  | 7.2 | 7.100000000000001 | 7.2 | 7.100000000000001
Euro-zone average | 9.6 | 10.15 | 10.13 | 11.35 |  | 12.1 | 12.1 | 12.2 | 12.2
(a) Unemployment as a percentage of labour force.
(b) Years shown are calendar years.
(c) Data only available quarterly. Relevant data not yet available.
(d) Monthly data seasonally adjusted
Note: Unemployment rates shown above have been adjusted as necessary by the OECD
to conform to international definitions and to ensure consistency over time. |  |  |  |  |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  |  |  |  |  | Early January 2014
Source: Datastream
Spreadsheet: 848941d1699539336-list-missing-numbers-in-range-not-as-an-array-forumla-list-missing-numbers-in-range
Sheet: Sheet1

 | Production Task # |  | Production Line 1 | Production Line 2 | Production Line 3
 | 1 |  | 1
 | 2 |  | 2 | 3 | 7
 | 3 |  | 5 | 4 | 8
 | 4 |  | 10 |  | 9
 | 5 |  | 12 | 14 | 11
 | 6 |  | 13 |  | 19
 | 7 |  | 15
 | 8 |  | 16 | 18
 | 9 |  | 17
 | 10 |  | 20
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 10efd884-dea8-4f9e-a150-a6c901a0c9d2
Sheet: ethnic

AY07-08 | AY08-09 | [NAME] | AY10-11 | AY11-12
2007 | 2008 | 2009 | 2010 | 2011
 |  |  |  |  |  | White |  | White
 |  |  |  |  |  | Hispanic |  | Hispanic
 |  |  |  |  | B | African American |  | African American
 |  |  |  |  |  | Asian |  | Asian
 |  |  |  |  |  | Native American |  | Native American
 |  |  |  |  |  | Filipino |  | Filipino
 |  |  |  |  |  | Pacific Islander |  | Pacific Islander
 |  |  |  |  |  | Multi-Race |  | Multi-Race
 |  |  |  |  |  | Unknown |  | Unknown
Spreadsheet: 61700d1262633584-vlookup-reporting-n-a-in-some-instances-and-not-in-others-for-same-information-sample-workbook
Sheet: Sheet1

Payroll Department | Position
500150 | Lifeguard
303050 | Snack Bar Attendant
301150 | Restaurant 1 - Server
301150 | Restaurant 1 - Server
301120 | Restaurant 1 Manager
500150 | Lifeguard
301150 | Restaurant 1 - Server
301050 | Restaurant 2 - Server
653050 | Nail Technician
202050 | Public Area Attendant
500150 | Lifeguard
500150 | Lifeguard
701050 | Front Desk Agent
301151 | Restaurant 1 Host
303050 | Snack Bar Attendant
301151 | Restaurant 1 Host
303050 | Snack Bar Attendant
500150 | Lifeguard
652050 | Massage Therapist
601050 | [NAME]
500150 | Lifeguard
500150 | Lifeguard
400150 | Sales Coordinator
203050 | [NAME]
500150 | Lifeguard
500150 | Lifeguard
500150 | Lifeguard
500150 | Lifeguard
201055 | #N/A
500150 | Lifeguard
701050 | Front Desk Agent
304050 | [NAME]
500150 | Lifeguard
500150 | Lifeguard
302165 | Restaurant 1 Dishwasher
202050 | #N/A
208055 | #N/A
500150 | Lifeguard
201050 | #N/A
500150 | Lifeguard
202050 | #N/A
500150 | Lifeguard
304050 | [NAME]
301151 | Restaurant 1 Host
500150 | Lifeguard
208050 | #N/A
500150 | Lifeguard
701020 | Guest Services Manager
304050 | [NAME]
200111 | #N/A
301150 | Restaurant 1 - Server
303050 | Snack Bar Attendant
301150 | Restaurant 1 - Server
301150 | Restaurant 1 - Server
303050 | Snack Bar Attendant
500150 | Lifeguard
500150 | Lifeguard
307055 | [NAME]
201050 | #N/A
500150 | Lifeguard
304050 | [NAME]
601050 | [NAME]
208050 | #N/A
201050 | #N/A
301050 | #N/A
351056 | Restaurant 2 Bartender
201050 | #N/A
701053 | Bell Staff
500150 | Lifeguard
701051 | Night Auditor
201050 | #N/A
201050 | #N/A
601050 | [NAME]
500150 | Lifeguard
750110 | Experience Coordinator
208050 | #N/A
500150 | Lifeguard
208050 | #N/A
751050 | Cub Club Guide
108550 | #N/A
307055 | [NAME]
654050 | Esthetician
203050 | #N/A
201050 | #N/A
301151 | #N/A
500150 | Lifeguard
500140 | Aquatics Supervisor
351056 | Restaurant 2 Bartender
304050 | #N/A
301150 | #N/A
601050 | [NAME]
202050 | #N/A
351056 | Restaurant 2 Bartender
500150 | Lifeguard
301150 | #N/A
201055 | #N/A
303050 | #N/A
500150 | Lifeguard
601050 | [NAME]
304050 | #N/A
500150 | Lifeguard
500150 | Lifeguard
500150 | Lifeguard
500150 | Lifeguard
500150 | Lifeguard
301150 | #N/A
303050 | #N/A
108020 | #N/A
201050 | #N/A
302160 | #N/A
500150 | Lifeguard
601040 | [NAME]
400120 | #N/A
500150 | Lifeguard
500150 | Lifeguard
500150 | Lifeguard
201050 | #N/A
500150 | Lifeguard
208030 | #N/A
208050 | #N/A
301150 | #N/A
201050 | #N/A
500150 | #N/A
500150 | #N/A
500150 | #N/A
201050 | #N/A
500150 | #N/A
208050 | #N/A
303050 | #N/A
601050 | [NAME]
701050 | Front Desk Agent
500150 | #N/A
651050 | AVEDA Advisor
Spreadsheet: 771381d1646647668-multiple-if-and-or-statements-for-calculator-spreadsheet-sample-spreadsheet-calculator
Sheet: Calculator

 | Employee Name | [NAME]
 | Employee Number | 100
 | Employee Classification | Personnel Level 9
 | Project Name | Project Code | Project Value | Team Size | Complexity | % Maxiumum Eligibility
 | Project Example 1 | XR1 | 40000000 | Large | Medium | 0.3
 | Project Example 2 | XR2 | 20000000 | Medium | Medium | 0.25
 | Project Example 3 | XR3 | 3000000 | Small | Low | 0.1
Spreadsheet: 270904d1381743337-filter-table-for-duplicate-entries-with-exemption-rule-0a230
Sheet: Sheet1

 | ValveNo | Supplier | filter
 | HV1000
 | HV1000 | DELETED
 | HV1001
 | HV1001
 | HV1002
 | HV1003
 | XV1002
 | XV1010
 | XV1011
 | XV1011 | DELETED
 | XV1012
 | XV1013
 | XV1013
 |  |  |  |  | Objective:
 |  |  |  |  | Filter valves to display duplicate enties. Values with a matching suppler of "DELETED" are exempt.
 |  |  |  |  |  | Example: Both of HV1001 (in B5 and [NAME]) should be listed.
 |  |  |  |  |  | Example: Neither of HV1000 (in B3 and B4) should be listed because the HV1000 in B4 is "DELETED".
 |  |  |  |  | Design Restrictions:
 |  |  |  |  | Non-VBA solutions preferred.
 |  |  |  |  | Use of "dummy" column(s) is perfectly acceptable.
Spreadsheet: 841118d1693364729-identifying-data-entries-based-on-multiple-criteria-and-ignoring-duplicates-earlier-entries-preppy_prince-identifying-data-entries-based-on-multiple-criteria-and-ignoring-duplicates-earli
Sheet: Sheet1

CUSTOMER ID | STORE | PURCHASE ITEM | PURCHASE DATE (DD/MM/YYYY) |  | STORE | NEW CUSTOMERS
A12345 | North | Fruit | 2023-06-07 00:00:00 |  | East
A12346 | South | Vegetables | 2023-06-05 00:00:00 |  | North
A12347 | East | Meat | 2023-08-18 00:00:00 |  | South
A12346 | South | Fruit | 2023-07-12 00:00:00
A12348 | North | Fruit | 2023-08-21 00:00:00
A12349 | North | Vegetables | 2023-08-09 00:00:00
A12345 | North | Meat | 2023-08-08 00:00:00
A12346 | South | Meat | 2023-08-15 00:00:00
A12347 | East | Vegetables | 2023-08-29 00:00:00
Spreadsheet: 862477d1710195762-exclude-holidays-in-total-holiday-sample
Sheet: Feb

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 2017-02-01 00:00:00 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 40240d1238547988-looking-for-a-more-memory-efficient-way-promotions
Sheet: Clerk

Assistant to clerk promotions |  |  |  | 2009 |  |  | Pay period | 7
Employee # | Name | Week 1 total | Week 1 clerk | Week 1 % | Week 2 total | Week 2 clerk | Week 2 % | Over
103000808 | [NAME] | 43.67 | 0 | 0 | 45.45 | 9.379999999999999 | 0.2063806380638064 | No
119000061 | DION PHANEUF | 40 | 0 | 0 | 40 | 0 | 0 | No
103000051 | ADRIAN AUCOIN | 35.49 | 35.49 | 1 | 39.75 | 31.84 | 0.8010062893081761 | Both
106001280 | MIKE CAMMALLERI | 32.97 | 32.97 | 1 | 30.66 | 8.76 | 0.2857142857142857 | Week 1
116000153 | DARRYL SUTTER | 40 | 0 | 0 | 40 | 0 | 0 | No
103000132 | [NAME] | 40 | 0 | 0 | 40 | 0 | 0 | No
106000743 | DAYMOND LANGKOW | 34.81 | 0 | 0 | 21.76 | 0 | 0 | No
115000120 | CRAIG CONROY | 32.09 | 0 | 0 | 40 | 0 | 0 | No
103000329 | RENE BOURQUE | 38.52 | 0 | 0 | 39.3 | 0 | 0 | No
177000676 | TODD BERTUZZI | 30.57 | 0 | 0 | 23.68 | 0 | 0 | No
106000597 | [NAME] | 40 | 0 | 0 | 40 | 0 | 0 | No
123000155 | [NAME] | 25.96 | 0 | 0 | 60 | 0 | 0 | No
177000173 | [NAME] | 53.34999999999999 | 0 | 0 | 33.43 | 31.43 | 0.9401734968591086 | Week 2
177000100 | ROBYN REGEHR | 41.89 | 0 | 0 | 33.75 | 0 | 0 | No
0 |  | 0 | 0 | 0 | 0 | 0 | 0 | No
0 |  | 0 | 0 | 0 | 0 | 0 | 0 | No
0 |  | 0 | 0 | 0 | 0 | 0 | 0 | No
0 |  | 0 | 0 | 0 | 0 | 0 | 0 | No
0 |  | 0 | 0 | 0 | 0 | 0 | 0 | No
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 10 Feb 20 - 15 Feb 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-02-10 00:00:00 | 2020-02-11 00:00:00 | 2020-02-12 00:00:00 | 2020-02-13 00:00:00 | 2020-02-14 00:00:00 | 2020-02-15 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 10/02/2020 - 15/02/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | [NAME] | ✓ |  | 0.2 | 0.8 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ✓
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | N/A |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  |  | ❌
 | ✓ | ✓ | ✓ | AWAY | ✓ |  |  | 1 |  |  | ❌
 | [NAME] | ✓ | ✓ | [NAME] | ✓ |  | 0.4 | 0.6 |  |  | ❌
Edge Protection [NAME] |  |  | 10/02/2020 - 15/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 10/02/2020 - 15/02/2020
Blum |  |  | ✓ |  |  |  |  |  |  | Dameon | ✓
Komatsu |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Bascik |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
47 Link Drive |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
Spreadsheet: 356457d1415116585-excel-sorting-excel-help-ndm-v2
Sheet: Sheet2

2014-10-21 00:00:00 |  | [PHONE] Nissan Auto Loan | 350
2014-10-01 00:00:00 |  | [PHONE] WF HOME MTG AUTO PAY | 1300
2014-10-17 00:00:00 |  | 071729 INTERNET TRANSFER TO STATEMENT SAVING 1557981 ON 10/17/14 AT 0:16 | 100
2014-10-20 00:00:00 |  | 080522 INTERNET TRANSFER TO STATEMENT SAVING 1557981 ON 10/17/14 AT 19:33 | 2100
2014-10-27 00:00:00 |  | 111337 WITHDRAWAL 123 LOBDELL HWY. PORT ALLEN LA 054699 00020117 | 61.75
2014-10-31 00:00:00 |  | 177867 INTERNET TRANSFER TO STATEMENT SAVING 1557981 ON 10/31/14 AT 0:43 | 100
2014-10-27 00:00:00 |  | 293459 WITHDRAWAL 222 HWY 415 PORT ALLEN LA 053186 00014330 | 42.5
Spreadsheet: 875607d1722216516-how-to-keep-a-drop-down-table-list-from-changing-excel-drop-down-list
Sheet: Inputs

 | HOLD Property Analysis Worksheet - 30 Year
 | Prepared By
 | Client Name
 | Property Address | 3255 Warrensville Center Road
 | Fix drop downs again
 | Units | Length | [NAME] | Square Feet
 | 101
 | 102
 | 103
 | 104
 | 201
 | 202
 | 203
 | 204
 | [NAME]
 | Total Building Apartment Interiors |  |  | 0
 | Rooms
 | Common Area 1st Floor
 | Common Area 2nd Floor
 | Garage
 | Living Room
 | Dining Room
 | Kitchen
 | Bedroom 1
 | Bedroom 2
 | Bathroom
 | Room Measurements | Length | [NAME] | Total Sq Ft | Lineal Feet
 | Living Room | 20 | 10 | 200 | 60
 | Kitchen | 12 | 12 | 144 | 48
 | Bathroom | 9 | 10 | 90 | 38
 | Master [NAME] | 9 | 10 | 90 | 38
 | 2nd Bedroom | 9 | 10 | 90 | 38
 | 3rd Bedroom | 9 | 10 | 90 | 38
 | 4th Bedroom | 9 | 10 | 90 | 38
 | Basement | 9 | 10 | 90 | 38
 | Hallways | 9 | 10 | 90 | 38
 | Ceiling Height | 7
 | Totals |  |  | 974 | 374
 | Cabinets
 | Cabinet wall to wall width | 7.166666666666667 | 2 | 14.33333333333333
 | Building Square Feet