tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2bbf9d95-742d-4b05-a659-c2e1a8f8dc0d
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
SALCT | Test | SALCT | Cortisol, Saliva | Cortisol, Saliva | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Varies: Var |  |  |  | Varies | Container/Tube: SARSTEDT [NAME] (Supply T514) [NAME]: 1.5 mL Collection Instructions: 1. Do not brush teeth before collecting specimen. 2. Do not eat or drink for 15 minutes prior to specimen collection. 3. Collect specimen between 11 p.m. and midnight, and record collection time. 4. To use the [NAME]: a. Remove top cap of container to expose swab. [NAME] swab directly into mouth by tipping container so swab falls into mouth. Do not touch swab with fingers. [NAME] swab in mouth for approximately 2 minutes. Roll swab in mouth, do not chew swab. d. Place swab back into its container without touching, and replace the cap. e. Record collection time, and send appropriately labeled [NAME] to laboratory. Additional Information: 1. Reference values are also available for 8 a.m. (7 a.m.-9 a.m.) and 4 p.m. (3 p.m.-5 p.m.) collections, however, 11 p.m. to midnight collection is preferred. 2. Indicate collection time. 3. If multiple specimens are collected, submit each vial under a separate order. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.6 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | 7 a.m.-9 a.m.: 100-750 ng/dL 3 p.m.-5 p.m.: <401 ng/dL 11 p.m.-midnight: <100 ng/dL | Monday, Wednesday, Friday; 1 p.m. | 2 days | 4 days | 1 | 82533 |  |  |  |  | Rochester
SALCT | [NAME] | SALIVA | Saliva |  |  |  | Refrigerated | 7 days
SALCT | Order Question | COLT3 | Collection Time in Military Time |  | Plain Text
SALCT | Result | 84225 | Cortisol, Saliva | Cortisol, Saliva | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 2142-8
SALCT | Result | 23612 | AM Cortisol | AM Cortisol | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | In Process
SALCT | Result | 23613 | PM Cortisol | PM Cortisol | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | In Process
SALCT | Result | 23614 | [NAME] | [NAME] | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 552572d1513657151-extracting-value-from-next-column-if-current-column-is-blank-extracting-value-from-next-column-if-current-column-is-blank
Sheet: Sheet1

Product | Ingredients (%) |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost of Ingredient ($)
 | Sugar | Spice | Salt | Pepper | Tomato | [NAME] | Apple | Orange | Grapes | Melon | Guava | [NAME] | Total (%) |  | Sugar | 1
A | 90 |  |  |  | 5 |  |  | 5 |  |  |  |  |  |  | Spice | 2
B |  | 85 |  | 10 |  | 5 |  |  |  |  |  |  |  |  | Salt | 3
C | 30 |  | 20 |  |  |  |  |  | 10 |  |  | 40 |  |  | Pepper | 4
D |  | 40 | 20 |  | 10 |  |  |  |  |  |  | 30 |  |  | Tomato | 5
E | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 6
F | 50 |  |  |  |  | 30 |  |  | 10 |  | 10 |  |  |  | Apple | 7
G | 30 |  | 30 |  | 40 |  |  |  |  |  |  |  |  |  | Orange | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grapes | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Melon | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guava | 11
Product | G | << Drop down list of the products in Column A |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 12
Ingredient 1
Ingredient 2
Ingredient 3
Ingredient 4
Ingredient 5
Spreadsheet: 438071d1451731715-caculate-rank-for-every-grade-based-on-criteria-rank
Sheet: Sheet1

Name | Grade | Marks | Rank
Name 1 | First | 397
Name 10 | First | 325
Name 100 | First | 434
Name 101 | First | 453
Name 102 | First | 309
Name 103 | First | 300
Name 118 | First | 300
Name 119 | First | 506
Name 12 | First | 461
Name 120 | First | 309
Name 121 | First | 485
Name 122 | First | 303
Name 123 | First | 300
Name 124 | First | 332
Name 125 | First | 343
Name 126 | First | 313
Name 127 | First | 377
Name 128 | First | 392
Name 129 | First | 393
Name 13 | First | 465
Name 130 | First | 400
Name 131 | First | 593
Name 132 | First | 302
Name 133 | First | 390
Name 134 | First | 470
Name 135 | First | 318
Name 136 | First | 339
Name 137 | First | 374
Name 138 | First | 303
Name 139 | First | 368
Name 14 | First | 571
Name 140 | First | 311
Name 141 | First | 448
Name 142 | First | 318
Name 143 | First | 484
Name 144 | First | 541
Name 145 | First | 305
Name 146 | First | 302
Name 147 | First | 440
Name 148 | First | 448
Name 149 | First | 311
Name 15 | First | 331
Name 150 | First | 310
Name 151 | First | 322
Name 152 | First | 329
Name 153 | First | 470
Name 154 | First | 309
Name 155 | First | 311
Name 156 | First | 341
Name 157 | First | 307
Name 158 | First | 423
Name 159 | First | 300
Name 16 | First | 303
Name 160 | First | 444
Name 161 | First | 476
Name 162 | First | 388
Name 163 | First | 434
Name 164 | First | 538
Name 165 | First | 337
Name 166 | First | 330
Name 167 | First | 321
Name 168 | First | 315
Name 169 | First | 391
Name 17 | First | 408
Name 170 | First | 302
Name 171 | First | 450
Name 172 | First | 394
Name 173 | First | 450
Name 174 | First | 322
Name 175 | First | 436
Name 176 | First | 409
Name 177 | First | 309
Name 178 | First | 322
Name 296 | Third | 398
Name 297 | Third | 339
Name 298 | Third | 530
Name 299 | Third | 309
Name 300 | Third | 330
Name 301 | Third | 427
Name 302 | Third | 493
Name 303 | Third | 330
Name 304 | Third | 318
Name 305 | Third | 428
Name 306 | Third | 329
Name 320 | Third | 340
Name 321 | Third | 494
Name 322 | Third | 443
Name 323 | Third | 348
Name 324 | Third | 310
Name 325 | Third | 311
Name 326 | Third | 441
Name 327 | Third | 541
Name 328 | Third | 359
Name 329 | Third | 304
Name 348 | Third | 351
Name 349 | Third | 303
Name 350 | Third | 383
Name 351 | Third | 308
Name 352 | Third | 351
Name 353 | Third | 307
Name 354 | Third | 551
Name 1343 | Second | 397
Name 1344 | Second | 397
Name 1345 | Second | 397
Name 1346 | Second | 397
Name 1347 | Second | 397
Name 1348 | Second | 397
Name 1349 | Second | 397
Name 1350 | Second | 397
Name 1351 | Second | 397
Name 1352 | Second | 397
Name 1353 | Second | 397
Name 1354 | Second | 397
Name 1355 | Second | 397
Name 1356 | Second | 397
Name 1357 | Second | 397
Name 1358 | Second | 397
Name 1359 | Second | 397
Name 1360 | Second | 397
Name 1361 | Second | 397
Name 1362 | Second | 397
Name 1363 | Second | 397
Name 1364 | Second | 397
Name 1365 | Second | 397
Name 1366 | Second | 397
Name 1367 | Second | 397
Name 1368 | Second | 397
Spreadsheet: 821534d1678782231-lookup-different-ranges-based-on-chosen-category-sample
Sheet: Sheet6

Catageory | Start Date | Day / Week Number | 7 day range
7 day range | 2023-03-09 00:00:00 | 7 range
14 day range | 2023-03-09 00:00:00 | 14 range
 |  |  | 14 day range
Spreadsheet: 106205d1303389823-simultaneous-updating-worksheets-overdue-ageing-1-
Sheet: EAST

NAME OF THE COMPANY |  |  | ABC & CO
 |  |  | EAST ZONE
DETAILS OF AGE-WISE DEBTORS REPORT AS ON |  |  | 2011-04-15 00:00:00
Name of the Party | Party Status | Invoice Date | Invoice No. | Credit Period | Due Date | Delay (Days) | Invoice Amount | Outstanding Invoice Amount (Rs.) | < 0 | <0 - 30> | <31 - 60> | <61 - 90> | <91 - 120> | <121 - 150> | <151 - 180> | > 180 Days
ZIP ACIDS | DIRECT PARTY | 2011-01-03 00:00:00 | 461 | 60 | 2011-03-04 00:00:00 | 42 | 35726 | 35726 | 0 | 0 | 35726 | 0 | 0 | 0 | 0 | 0
RAINT O PLASTCIS | DEALER | 2011-01-31 00:00:00 | 510 | 60 | 2011-04-01 00:00:00 | 14 | 751680 | 53222 | 0 | 53222 | 0 | 0 | 0 | 0 | 0 | 0
PESTICIDE KEEPER | DEALER | 2011-02-19 00:00:00 | 551 | 60 | 2011-04-20 00:00:00 | -5 | 102720 | 17124 | 17124 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OVERDUE AS ON DATE |  |  |  |  |  |  | 890126 | 106072 | 17124 | 53222 | 35726 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 2089bd8b-d1f5-4213-a7e4-3069fd8e8422
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  |  |  | Sustainability Assessment
 |  |  |  |  | Oregon Institute of Technology
 |  |  |  |  | [NAME], OR
 |  |  |  |  | [NAME], Assistant Professor, Natural Sciences
 |  |  |  |  | Sustainability Coordinator
 |  |  |  |  | and
 |  |  |  |  | Whitney Medina
 |  |  |  |  | Student, Renewable Energy Engineering
 |  |  |  |  | Oregon Institute of Technology
 |  |  |  |  | 3201 Campus Dr.   [NAME], OR   97601
 |  |  |  |  | [EMAIL] and [EMAIL]
 |  |  |  |  | Goal Tracking Legend
 |  |  |  |  | 0 | nothing done
 |  |  |  |  | 1 | in initial steps
 |  |  |  |  | 2 | in progress
 |  |  |  |  | 3 | near completion
 |  |  |  |  | 4 | goal met
 |  |  |  |  | 5 | goal met beyond expectation
 |  |  |  |  | 6 | on going
 |  |  |  |  | 7 | goal eliminated or no longer relevant
 |  |  |  |  | 8 | action taken in direction counter to goal achievement
 |  |  |  |  | Short Term Goals to be completed by 2010.
 |  |  |  |  | Long Term Goals to be completed by 2016.
Spreadsheet: 159836d1338867125-formula-needed-to-compare-cells-in-two-columns-enrolementgtcapacity
Sheet: Sheet1

Capacity | [NAME] | Test
33 | 33
30 | 21
30 | 10
25 | 5
25 | 21
30 | 14
15 | 4
25 | 7
25 | 6
15 | 4
15 | 10
25 | 8
25 | 13
25 | 10
1 | 1
25 | 21
Spreadsheet: 486997d1477841977-locate-last-5-record-and-then-average-it-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Total | Average
10 | 0 | 10 | 20 | 30 | 0 | 0 | 10
10 | 10 | 20 | 20 | 20 | 20 | 20 | 20
Spreadsheet: 586635d1534490448-select-rows-between-blank-rows-using-power-query-sample
Sheet: Sheet1

Order Details
Unit | StartDate | EndDate | Geo | Place | Amount | Rate | TotalCost | Source | ConlineID | Guide
Placement 1 | 2018-08-02 00:00:00 | 2018-08-31 00:00:00 | attached [NAME] (15-24 visitors) | Place | 1000 | 8 | 1800 | Source | 12345 | Guide
Placement 1 | 2018-08-02 00:00:00 | 2018-08-31 00:00:00 | attached [NAME] (8-14 visitors) | Place | 1000 | 8 | 1200 | Source | 12345 | Guide
Placement 2 | 2018-08-02 00:00:00 | 2018-08-31 00:00:00 | attached [NAME] (8-14 visitors) | Place | 1000 | 9 | 600.003 | Source | 56789 | Guide
Placement 2 | 2018-08-02 00:00:00 | 2018-08-31 00:00:00 | attached [NAME] (15-24 visitors) | Place | 1000 | 9 | 900 | Source | 56789 | Guide
Placement 2 | 2018-08-02 00:00:00 | 2018-08-31 00:00:00 | attached [NAME] (25+ visitors) | Place | 1000 | 9 | 900 | Source | 56789 | Guide
Placement 2
Size | Text | Url | Site | ID | Color | BGColor | Upload | Source | Desc | StartDate | EndDate | Rot | Notes
100x50 | Text | URL | Site.com | 123 | white | #3a83db | house |  | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 50
100x50 | Text | URL | Site.com | 123 | white | #3a83db | house |  | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 50
100x50 | Text | URL | Site.com | 123 | White | #3a83db | house |  | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 100 | Notes
Placement 1
Size | Click URL | ID Col | Source | Method | Desc Spot | StartDate | EndDate | Rot | Notes
1x1 | Site.com | 456 |  | Upload | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 100
1x1 | Site.com | 456 |  | Upload | [NAME] | 2018-08-02 00:00:00 | 2018-10-31 00:00:00 | 100
FOR INTERNAL USE ONLY
Spreadsheet: 33949d1230911426-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-revised
Sheet: 410 a Elig&Cov

 |  | Eligibiltiy and Coverage
 |  | Name of Employee | Date of Birth | Date of Hire | Date of Termination | Hours Worked | Date of Entry | OYFDOH | MON | JJ | Year | DOE | Anniv | D1 | D2 | D3 |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOEIWKIECP | Eligible for Plan
 | 1 | [NAME] | 1980-07-20 00:00:00 | 2005-08-07 00:00:00 |  | 1000 | 1900-01-01 00:00:00 | 2006-08-07 00:00:00 | 8 | 1 | 2007 |  | 2006-08-07 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2007-01-01 00:00:00 | 3200 | 2080 | eligible
 | 1 | [NAME] | 1977-06-07 00:00:00 | 2005-01-02 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-01-02 00:00:00 | 1 | 7 | 2006 |  | 2006-01-02 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | [NAME] | 1973-03-05 00:00:00 | 2005-06-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-06-01 00:00:00 | 6 | 7 | 2006 |  | 2006-06-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | [NAME] | 1976-03-05 00:00:00 | 2005-03-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-03-01 00:00:00 | 3 | 7 | 2006 |  | 2006-03-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | Richland | 1970-03-05 00:00:00 | 2004-08-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2005-08-01 00:00:00 | 8 | 1 | 2006 |  | 2005-08-01 00:00:00 | 2005-01-01 00:00:00 | 2005-07-01 00:00:00 | 2006-01-01 00:00:00 | 2006-01-01 00:00:00
 | 1 | Rolette | 1969-03-05 00:00:00 | 2005-06-01 00:00:00 | 1900-01-01 00:00:00 | 1000 | 1900-01-01 00:00:00 | 2006-06-01 00:00:00 | 6 | 7 | 2006 |  | 2006-06-01 00:00:00 | 2006-01-01 00:00:00 | 2006-07-01 00:00:00 | 2007-01-01 00:00:00 | 2006-07-01 00:00:00
 | 1 | Sargent | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | [NAME] | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Sioux | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Slope | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | [NAME] | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Steele | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Stutsman | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Towner | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0 | 1900-01-01 00:00:00
 | 1 | Traill |  |  |  | 0
Total Ees | 15
 |  | Date of Hire plus one year nearest date of either July 1 or January 1
 |  | For example [NAME] 1, 2004 Date of Enty will be January 1 2006
 |  | For example DOH June 1, 2005 Date of Entry will be July 1 2006
Spreadsheet: a9ef5ef5-6744-4eca-8802-a7faf06f1353
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259846 | 73625 | [NAME] | Kerner | GER | 104 | 00:18:24 | 00:01:06 | [NAME] | [NAME] | 00:22:27 | 1 | 01:38:42
259846 | 30361 | Mario | Siller | AUT | 108 | 00:14:55 | 00:01:00 | 01:00:45 | [NAME] | 00:25:22 | 2 | 01:42:41
259846 | 78388 | [NAME] | Clement | FRA | 110 | 00:17:01 | 00:01:06 | 01:00:28 | 00:00:43 | 00:25:49 | 3 | 01:45:10
259846 | 24623 | Michal | Pilousek | CZE | 106 | 00:21:03 | 00:01:14 | 01:01:41 | 00:00:56 | 00:24:18 | 4 | 01:49:14
259846 | 77961 | [NAME] | [NAME] | AUT | 109 | [NAME] | 00:01:10 | [NAME] | 00:00:47 | 00:26:54 | 5 | 01:51:30
Spreadsheet: 89238d1288981387-excel-2007-trying-to-write-an-if-and-or-formula-gain-example
Sheet: Sheet1

Dept | WO | Ser # | Folder | Code | Desc | Act Code | Posted | Gained | Result
North GA Svc | NM100015871 | 560-06-A01686 | Repair Field | 109 | Lift | [NAME] | 0.5 | 0 | 0
North GA Svc | NM100015871 | 560-06-A01686 | Scheduled Maintenance | 919 | Scheduled Maintenance | Performed (SM Only) | 1.2 | 0 | 0
North GA Svc | NM100015872 | 560-06-A01690 | Repair Field | 109 | Lift | [NAME] | 0.5 | 0 | 1
North GA Svc | NM100015872 | 560-06-A01690 | Scheduled Maintenance | 919 | Scheduled Maintenance | Performed (SM Only) | 0.8 | 0.4 | 1
North GA Svc | NM100015873 | 560-06-A01693 | Repair Field | 109 | Lift | [NAME] | 0.5 | 0 | 0
North GA Svc | NM100015873 | 560-06-A01693 | Scheduled Maintenance | 919 | Scheduled Maintenance | Performed (SM Only) | 1.2 | 0 | 0
Spreadsheet: 97623d1296749661-looking-for-formula-that-will-catch-special-rule-abuse-for-the-same-id-copy-of-2011_02_03_reply
Sheet: Sheet1 (4)

ID | date | SLED |  | check
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-14 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-17 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-31 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-28 00:00:00 | 2012-02-20 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-21 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-02-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
Spreadsheet: 753208d1635297000-quarterly-report-using-pivot-tables-indexing_status
Sheet: Status

Reception |  |  | Analyze |  |  | Waiting for info |  |  | Process |  |  | Validate by [NAME] |  |  | Approve |  |  | To be completed |  |  | Completed
File # | Date |  | File # | Start date |  | File # | Since |  | File # | Start date |  | File # | Start date |  | File # | Start date |  | File # | Since |  | File # | On
Spreadsheet: 875890d1722517616-send-calculated-value-of-a-cell-to-another-cell-with-formula-in-excel-example-sheet
Sheet: Sheet1

 | Raise (%) | 0.07 | [NAME] in %
 | Starting month | 5 | [NAME] in Starting Month
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | Salary | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000 | 10000
 |  | [NAME] is raised @7% from the m/o May. I need to automatically update the salary from the relative month
Spreadsheet: 692257d1598238727-help-to-create-formula-with-multiple-if-statements-milkychips-answer
Sheet: Sheet1

Wy | My | Answer
1.65 | 1.77 |  |  | If A is blank and B is blank then C = blank
1.38 | 0.97 |  |  | If A is blank and B is not blank then USE 100% of B
2.23 | 2.17 |  |  | If A is not blank and B is blank then USE 100% of A
1.93 | 1.35 |  |  | If A is not blank and B is not blank then USE 70% of A and 30% of B
0.4 | 0.43
0.37
0.58 | 0.66
1.04
2.02
 | 2.6
Spreadsheet: 50a7d6da-0994-45ef-83a9-f5a0645520f7
Sheet: Report

Project Name |  |  |  |  | Sponsor
Project Manager |  |  |  |  | Date Updated
ID | Description | Current % Complete | Previous % Complete | Start | Finish | Status | Comments
1
Spreadsheet: 154653d1336503682-formula-to-find-values-in-table-various-locations-sample
Sheet: Sheet2

[NAME]
 | Group | PPL | Date | 2012-05-14 00:00:00 | 2012-05-15 00:00:00 | 2012-05-16 00:00:00 | 2012-05-17 00:00:00 | 2012-05-18 00:00:00
 | A | 11 | 14 | 07:00 - 09:00 2hrs |  |  |  |  |  |  | Group # | Session Date | Session Times
 | B | 12 | 15 |  | 07:00 - 09:00 2hrs |  |  |  |  |  | A | 2012-05-14 00:00:00 | 07:00 - 09:00 2hrs
 | C | 12 | 16 |  |  | 07:00 - 09:00 2hrs |  |  |  |  | B | 2012-05-15 00:00:00 | 07:00 - 09:00 2hrs
 | D | 6 | 18 |  |  |  |  | 07:00 - 09:00 2hrs |  |  | C | 2012-05-16 00:00:00 | 07:00 - 09:00 2hrs
 | E | 11 | 14 | 10:00 - 12:00 2hrs |  |  |  |  |  |  | D | 2012-05-18 00:00:00 | 07:00 - 09:00 2hrs
 | F | 11 | 15 |  | 10:00 - 12:00 2hrs |  |  |  |  |  | E
 | G | 10 | 16 |  |  | 10:00 - 12:00 2hrs |  |  |  |  | F
 | H | 11 | 14 | 14:00 - 16:00 2 hrs |  |  |  |  |  |  | G
 | I | 11 | 15 |  | 14:00 - 16:00 2 hrs |  |  |  |  |  | H
 | J | 11 | 16 |  |  | 14:00 - 16:00 2 hrs |  |  |  |  | I
 | K | 11 | 17 |  |  |  | 17:00 - 19:00 2 hrs |  |  |  | J
 | L | 11 | 18 |  |  |  |  | 14:00 - 16:00 2 hrs |  |  | K
 | M | 11 | 14 | 17:00 - 19:00 2 hrs |  |  |  |  |  |  | L
 | N | 11 | 15 |  | 17:00 - 19:00 2 hrs |  |  |  |  |  | M
 | O | 7 | 16 |  |  | 17:00 - 19:00 2 hrs |  |  |  |  | N
 | P | 3 | 17 |  |  |  | 22:00 - 00:00 2 hrs |  |  |  | O
 | Q | 2 | 16 |  |  | 22:00 - 00:00 2 hrs |  |  |  |  | P
 |  |  |  |  |  |  |  |  |  |  | Q
Spreadsheet: 790326d1659640264-find-the-subtotal-groups-that-sum-to-zero-and-marks-them-for-delete-sumif-example
Sheet: Working for small set

Invoice # | Customer # | Customer Name | Amount | Match?
AJUST CUSTOMER DEPOSITS | 99999 |  | 32.8
[NAME] | 99999 |  | -175901.4
 | 99999 Total
35718 | 1019 | DEN HARTOG INDUSTRIES, INC. | -17965
35284 | 1019 | DEN HARTOG INDUSTRIES, INC. | -17965
35811 | 1019 | DEN HARTOG INDUSTRIES, INC. | 35930
35427 | 1019 | DEN HARTOG INDUSTRIES, INC. | -83000
35664 | 1019 | DEN HARTOG INDUSTRIES, INC. | -249000
36262 | 1019 | DEN HARTOG INDUSTRIES, INC. | -415000
 | 1019 Total
34720 | 1093 | AMERI-KART CORP. | -164320
35390 | 1093 | AMERI-KART CORP. | -205400
35552 | 1093 | AMERI-KART CORP. | 369720
 | 1093 Total
36366 | 1116 | ASSMANN CORPORATION OF AMERICA | -6765
 | 1116 Total
Spreadsheet: 883628d1732266903-remove-shading-from-a-surface-chart-copy-of-bubble_chart_data-003-
Sheet: Sheet1

Category | X-axis Value | Y-axis Value | Bubble Size
Journals Posted | 4.6 |  | 42989 |  |  | Attempted to order in month end process order (Journals posted first, then recs, then reports etc…
Recs Processed | 4 |  | 24733
Reports Produced | 4.6 |  | 15344
[NAME] | 4 |  | 2844 |  |  | Location of bubbles determined by X/Y axis values, KPI stat determines bubble size
Month Ends closed | 3.6 |  | 20000 | Placeholder |  | [NAME] currently formula driven but is not very dynamic so will likely require manual bubble location in X/Y column when updated
OIM Open Items Cleared | 4.5 |  | 20000 | Placeholder
 | Example
Spreadsheet: 809925d1671441388-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-gk-no-blanks-v1-3-
Sheet: SOA MO 10

Verklaring van aktiwiteite
 | [NAME]
Inkomste:
 |  | Naskoolsentrum** Nie na bank |  | 500
 | 40102 | Hendrik/Nellie |  | 20500
 | 40103 | Mienie |  | 2200
 | 40104 | Kaye |  | 1200
 | 40105 | Thanks to the Lord |  | 6400
 | 40106 | Anoniem |  | 2000
 | 40107 | Ob pmt tiende |  | 1400
 | 40108 | English service |  | 500
 | 40110 | Free Plate |  | 200
 | 40400 | Offers Sondag 01 |  | 1670
 | 40401 | Offers Sondag 02 |  | 1580
 | 40402 | Offers Sondag 03 |  | 1640
 | 40403 | Offers Sondag 04 |  | 3360
 | 40404 | Offers Sondag 05 |  | 2100
 | 46000 | Verf fonds |  | 34000
 |  | [NAME]:
Uitgawes:
 |  | Distrik Tiendes |  | 1000
 | 500100 | [NAME] Ds [NAME] |  | 7000
 | 500101 | [NAME] Ds Pieter** |  | 4300
 | 500102 | Lone (Tuinier)(Eric) |  | 2000
 | 500103 | Lone (Skoonmaker) |  | 1000
 | 500300 | Elektrisiteit |  | 800
 | 500301 | [NAME] (W&L) STADSRAAD) |  | 3000
 | 500400 | Kruideniersware |  | 1005
 | 500800 | [NAME] |  | 714.54
 |  | [NAME]:
 | Netto: inkomste wins / (verlies)
 | Kontant Einde van Periode