tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135790d1326231786-formula-countif-multiple-ranges-with-one-criteria-test-worksheet
Sheet: Admin.

Approved
Denied
Inpatient
Outpatient
Psychiatric Unit
Inpatient Rehabilitation
Skilled Nursing Unit
Other (i.e. Physician Services, DME)
Medical/Surgical Acute Care Hospital/Services - No Documentation Provided or Insufficient Documentation in the Medical Record
Medical/Surgical Acute Care Hospital/Services - Incorrect MS-DRG or Other Coding Error
Medical/Surgical Acute Care Hospital/Services - Incorrect APC or Other Outpatient Coding Error
Medical/Surgical Acute Care Hospital/Services - Short Stay Medically Unnecessary
Medical/Surgical Acute Care Hospital/Services - Medically Unnecessary Inpatient Stay Longer than 3 days
Medical/Surgical Acute Care Hospital/Services - Other Medically Unnecessary
Medical/Surgical Acute Care Hospital/Services - All Other
Inpatient Rehabilitation Hospital/Unit - No Documentation Provided or Insufficient Documentation
Inpatient Rehabilitation Hospital/Unit - Incorrect CMG or Other Coding Error
Inpatient Rehabilitation Hospital/Unit - Outpatient Coding Error
Inpatient Rehabilitation Hospital/Unit - All Joint Patients; Medically Unnecessary
Inpatient Rehabilitation Hospital/Unit - Other Medically Unnecessary
Inpatient Rehabilitation Hospital/Unit - All Other
Psychiatric Services Hospital/Unit - No Documentation Provided or Insufficient Documentation
Psychiatric Services Hospital/Unit - Incorrect MS-DRG or Other Coding Error
Psychiatric Services Hospital/Unit - Outpatient Coding Error
Psychiatric Services Hospital/Unit - Medically Unnecessary
Psychiatric Services Hospital/Unit - All Other
Long Term Care Hospital/Unit - No Documentation Provided or Insufficient Documentation
Long Term Care Hospital/Unit - Incorrect MS-DRG or Other Coding Error
Long Term Care Hospital/Unit - Medically Unnecessary
Long Term Care Hospital/Unit - All Other.
Upheld
Overturned_in_Provider_Favor
Pending
No reason yet provided by entity overturning the appeal.
The RACs have not provided accurate justification for reopening a claim after a certain period of time.
Care provided was found to be medically necessary.
All Other.
Yes
No
Inpatient
Outpatient
Billing Error
Inpatient Discharge Disposition
Incorrect MS-DRG
Outpatient Coding Error
All Other
Spreadsheet: 799970d1665420068-cell-value-dependent-on-2-other-cells-metadata-example
Sheet: Deliverables

Document Reference | Title | Existing NG DWG Ref_Rev | WP | WP/DISC | G35 Part B Ref
WOO-GTX0013-AU-DW-XXXX | Example Drawing Title1 | 60110802000006_G | WP02 | ELECTRICAL
WOO-GTX0013-AU-DW-XXXX | Example Drawing Title2 | 60110802000003x2_K | WP05 | INSTRUMENT AND SOFTWARE
WOO-GTX0013-AU-DW-XXXX | Example Drawing Title3 | 60110802000003x2_K | WP01 | CIVIL
Spreadsheet: 825127d1681138048-calculate-percentage-but-anything-in-na-field-master-audit-worksheet-brookieou-
Sheet: Sheet1

Facility: |  | Audit Date:
Auditor:
Objective:
Process & Methodology:
Task | Column1 | Compliant | Non-Compliant | N/A | Notes
 |  | x
 |  | x
 |  |  |  |  | X
 |  | X
 |  | X
 |  | X
 |  | X
 |  |  | X
Total
 | Percent Compliant
Pass/Fail |  |  | Non-Compliant findings must be corrected.
Follow-up Date:
Follow-up Pass/Fail:
Auditor:
Spreadsheet: monika_causholli__28171__CASH COST ANALYSIS
Sheet: by region

Source: Jacobs-Sirrine
Last Updated: 08/08/01
Maintained by: M.Causholli/EIM Fundamentals |  |  |  |  |  |  |  |  |  |  | Cash Costs
Location: O://Industrial Markets/Fundamentals/paper/Pulp/Cash Cost Analysis |  |  |  |  |  |  |  |  |  |  | $US/ADMT
 |  |  |  |  |  |  |  | FOB-Mill | Delivered to Europe |  |  | Europe | Delivered to US |  |  |  | US | Del. To Korea | Del to China
 |  |  |  |  |  | Brazil |  |  | Belgium | Germany | Italy | Average | Georgia | Chicago | New York | S.Francisco | Average
 |  |  |  |  |  | BHKP(Eucalyptus) | 2000_Q1 | 194 | 273 | 239 | 277 |  | 292 | 316 | 266 | 292 |  | 367 | 296
 |  |  |  |  |  |  | 2000_Q2 | 209 | 287 | 255 | 291 |  | 307 | 331 | 281 | 307 |  | 381 | 311
 |  |  |  |  |  |  | 2000_Q3 | 209 | 288 | 255 | 292 |  | 308 | 332 | 282 | 308 |  | 382 | 312
 |  |  |  |  |  |  | 2000_Q4 | 191 | 270 | 236 | 274 |  | 288 | 312 | 262 | 288 |  | 364 | 292
 |  |  |  |  |  |  | 2001_Q1 | 189 | 268 | 234 | 272 |  | 286 | 310 | 260 | 286 |  | 362 | 290
 |  |  |  |  |  |  | Average
 |  |  |  |  |  | Indonesia
 |  |  |  |  |  | BHKP( Mixed Tropical hardwood) | 2000_Q1 | 206 | 321 | 296 | 306 |  | 339 | 340 | 313 | 275 |  | 236 | 246
 |  |  |  |  |  |  | 2000_Q2 | 215 | 329 | 305 | 315 |  | 348 | 349 | 322 | 284 |  | 245 | 255
 |  |  |  |  |  |  | 2000_Q3 | 208 | 323 | 297 | 308 |  | 340 | 341 | 314 | 276 |  | 238 | 247
 |  |  |  |  |  |  | 2000_Q4 | 192 | 307 | 282 | 292 |  | 325 | 326 | 299 | 261 |  | 222 | 232
 |  |  |  |  |  |  | 2001_Q1 | 182 | 297 | 272 | 282 |  | 315 | 316 | 289 | 251 |  | 212 | 222
 |  |  |  |  |  |  | Average
 |  |  |  |  |  | Russia
 |  |  |  |  |  | BHKP | 2000_Q1 | 266 | 377 |  | 386 |  |  |  |  |  |  | 421
 |  |  |  |  |  |  | 2000_Q2 | 281 | 392 |  | 401 |  |  |  |  |  |  | 436
 |  |  |  |  |  |  | 2000_Q3 | 291 | 402 |  | 411 |  |  |  |  |  |  | 446
 |  |  |  |  |  |  | 2000_Q4 | 292 | 403 |  | 412 |  |  |  |  |  |  | 447
 |  |  |  |  |  |  | 2001_Q1 | 297 | 408 |  | 417 |  |  |  |  |  |  | 452
 |  |  |  |  |  |  | Average
 |  |  |  |  |  | Russia
 |  |  |  |  |  | BSKP | 2000_Q1 | 298 | 403 |  | 410 |  |  |  |  |  |  | 446
 |  |  |  |  |  |  | 2000_Q2 | 285 | 390 |  | 397 |  |  |  |  |  |  | 432
 |  |  |  |  |  |  | 2000_Q3 | 305 | 410 |  | 417 |  |  |  |  |  |  | 453
 |  |  |  |  |  |  | 2000_Q4 | 290 | 395 |  | 402 |  |  |  |  |  |  | 438
 |  |  |  |  |  |  | 2001_Q1 | 295 | 400 |  | 407 |  |  |  |  |  |  | 443
 |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  | Source: Jacobs-Sirrine
 |  |  |  |  |  |  |  | Last Updated: 08/08/01
 |  |  |  |  |  |  |  | Maintained by: M.Causholli/EIM Fundamentals
 |  |  |  |  |  |  |  | Location: O://Industrial Markets/Fundamentals/paper/Pulp/Cash Cost Analysis
Spreadsheet: 184444d1349268846-how-to-count-and-average-groups-that-contain-a-specific-digit-865294
Sheet: Sheet1

Data | Helper column | 0 | << Value to group
1
4 |  |  |  | 2
5 |  |  |  | 6
0 |  |  |  | 0 |  |  |  | Data example (not entire column): 1-4-5-0-0-0-3-4-0-0-5-7-0-0-0-0-0-0-8-2.....
0 |  |  |  | 0
0 |  |  |  | 0 |  |  |  | Operations I'd like to perform: These should be done separately please.
3 |  |  |  | 0
4 |  |  |  | 0 |  |  |  | 1) Count the number of groups of zeros (in this case there are 3).
0 |  |  |  | 0
0 |  |  |  | 0 |  |  |  | 2) Count the number of zeros within each group (in this case 3, 2, 6).
5 |  |  |  | 0
7 |  |  |  | 0 |  |  |  | 3) Average of the groups of zeros...to single decimal place (in this case [3+2+6 =1] /2 = 3.6).
0 |  |  |  | 0
0 |  |  |  | 0
0 |  |  |  | 0
0 |  |  |  | 0
0 |  |  |  | 0
0 |  |  |  | 0
8 |  |  |  | 0
2 |  |  |  | 0
Spreadsheet: 90216d1289964786-2-way-lookup-from-a-basic-table-in-excel-offset-overview
Sheet: Sheet1

Offset Function (Dynamic Data Lookup)
Offset allows you to create a function that is [NAME].  Often this is used with a lookup to move the "pointer" to different data depending on what you choose for options |  |  |  |  | User Data
 | User Lookup |  |  |  | User | Typing Speed WPM | Job Role | Pay Grade
Select a user: | [NAME] |  |  |  | Jake | 15 | Analyst | 26
 | WPM | Role | Pay Grade |  | [NAME] | 45 | Metrics | 15
 |  |  |  |  | [NAME] | 90 | Data Entry | 19
 | =OFFSET(F85,MATCH($B$86,$F$86:$F$88,0),1)
 | Note that [NAME] is just returning how many ROWS to move down "offset", making this function dynamic based on a cell value The last "1" just moves the column over 1.  A match function can be done here but as you see the offset value moves when copying over the formula to differnt columns above
Advanced Offset with column/Row
 | User Lookup
Select a user: | [NAME]
 | Typing Speed WPM | Job Role | Pay Grade
 | Inorder for the second match to work on columns, the column name and lookup name need to be the same.
Spreadsheet: 114315d1310071261-comparing-two-column-while-retaining-data-from-a-third-example-2
Sheet: Sheet1 (2)

a | 122 | r
r | 324 | t
c | 897 | y
y | 5645 | u
e | 822 | i
f | 113 | o
p | 368 | p
 | 125 | z
 | 327 | w
 | 900 | q
Spreadsheet: 740656d1626440850-help-calculating-approvals-for-a-specific-item-based-on-dates-or-no-dates-book2
Sheet: Sheet1

 |  |  | I need to a formula that will look at A-I in Column H and if there is a Date in Column I, that it comes back with "approved", if no date then it comes back with "not approved.
 |  | A |  |  |  |  | A | 2021-01-01 00:00:00
 |  | B |  |  |  |  | B
 |  | C |  |  |  |  | C | 2021-01-01 00:00:00
 |  | D |  |  |  |  | D | 2021-01-01 00:00:00
 |  | F |  |  |  |  | F
 |  | G |  |  |  |  | G | 2021-01-01 00:00:00
 |  | H |  |  |  |  | H | 2021-01-01 00:00:00
 |  | I |  |  |  |  | I | 2021-01-01 00:00:00
Spreadsheet: 163216d1340224094-changing-three-columns-of-data-in-to-a-table-in-excel-2007-sample-book1
Sheet: Sheet1

Well Number | Formation | Code
1 | x | A1
1 | y | A2
1 | z | A3
2 | x | A4
2 | z | A5
I want This
Formation Code | X | Y | Z
Well Number
1 | A1
1 |  | A2
1 |  |  | A3
2 | A4
2 |  |  | A5
Spreadsheet: 35268d1232826831-input-automatic-calculation-669619-evaluate-formulas
Sheet: Specs

Spec | Expression  (no equals sign, operators used correctly) | Eval Test (x=1) | << Verifies that the expression is well-formed
A1A-1 | 1E-07*x^3 - 1E-04*x^2 - 0.013*x + 20.07 | 20.0569001
A2A-N | 1E-07*x^3 - 0.0001*x^2 - 0.0041*x + 19.906 | 19.9018001
A3A-P1 | 1E-07*x^3 - 1E-04*x^2 - 0.086*x + 20.1 | 20.0139001
B3A | -9E-08*x^3 + 3E-05*x^2 - 0.0312*x + 19.997 | 19.96582991
B1N-0 | -1E-07*x^3 + 6E-05*x^2 - 0.0344*x + 20.015 | 19.9806599
B5k - 0 | -3E-05*x^2 + 0.804*x - 0.187 | 0.61697
Test1 | 3x^2 | #N/A | << Bad expression (no * between 3 and x)
Test2 | log(x)+sin(x) | 0.8414709848078965 | << Other functions are fine
Spreadsheet: 175809d1345648443-formula-to-insert-the-number-of-hours-per-month-book1-modified-by-tigeravatar-
Sheet: Sheet1

 | 4.33 |  | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
Hours/week | start | end
32 | 2011-05-31 00:00:00 | 04/07/2012
38 | 2011-06-28 00:00:00 | 04/19/2012
32 | 2011-08-23 00:00:00 | 08/08/2012
32 | 2011-11-01 00:00:00 | 08/08/2012
40 | 2011-08-08 00:00:00 | 01/03/2013
40 | 2012-01-10 00:00:00 | 10/16/2012
Spreadsheet: 36579d1234455214-conditional-formatting-golf-league
Sheet: Sheet1

Player | Quota | Week 1 | Quota | Week 2 | Quota | Week 3 | Quota | Week 4 | Quota | Week 5 | Quota | Week 6 | Quota | Week 7 | Quota | Week 8 | Quota | Week 9 | Quota | Week 10 | Quota | Week 11 | Quota | Week 12 | Quota | Week 13 | Quota | Week 14 | Quota | Week 15 | Quota | Week 16 | Quota
Kremel | 23 | 32 | 27 | 25 | 26
Crank | 22
Sweet | 22
[NAME] | 20
T. Hennecke | 19
Scherbarth | 19
Jambois | 19
March | 18
Shaw | 17
Ga. Schroeder | 17
Gr. Schroeder | 17
Kinney | 17
[NAME] | 16
Wilson | 15
Stelter | 15
Kral | 15
Boney | 13
[NAME] | 13
Langley | 11
Hepner | 8
Spreadsheet: 456c1b44-1e25-40c4-9c6a-a83bb744b539
Sheet: Sheet1

Lecture | Description | Assigned to HG | Delivered by HG | Completed by AS | Upload link
 |  |  |  |  | 0.5 hour debit
1
1.1 | Intro to HEP & detectors | Y
1.2 | Units definitions radiation sources | Y | (2 hours- paid) (6 hours -paid)
1.3 | Interactions of radiation with matter | Y | Y (4.5 hours- paid) |  | http://indico.cern.ch/getFile.py/access?contribId=5&resId=0&materialId=slides&confId=48823
2
2.1 | General Characteristics of gas detectors |  | electronics (2.5 hour -paid) general characteristics (3 hours - paid)
2.2 | Transport Parameters of operational gas mixtures | http://hep.princeton.edu/~mcdonald/examples/detectors/sharma_98.pdf | Y (3.5 hours -paid)
2.3 | Wire based Detectors | Books + Riegler + http://www.gsr.unito.it/trasparenze2008/Sauli1.pdf | (5.5 hours) Paid
3
3.1 | Aging and Long Term Operation |  | (4 hours-paid)
3.2 | Micropattern Detectors for tracking | cdsweb.cern.ch/record/480402/files/open-2000-344.doc ; http://www.gsr.unito.it/trasparenze2008/Sauli2.pdf | (6 hours) Paid
3.3 | Resistive Plate Chambers | http://arxiv.org/PS_cache/hep-ex/pdf/0204/0204005v1.pdf
 |  | www.slac.stanford.edu/cgi-wrap/getdoc/slac-pub-10183.pdf
4
4.1 | Measurement of energy, momentum, TOF
4.2 | HEP Dectector Design |  | (3.5 hours)
4.3 | Applications outside HEP |  | (3.5 hours)
Spreadsheet: 32a40a9f-79f5-4a56-8484-9cb5c224e9d7
Sheet: Sheet1

2015-2016 Class Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected. | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
English
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 34787d1232130590-values-formula-copy-of-new-order-entry-in-progress-2-
Sheet: P.O.

 |  |  |  |  |  |  | Purchase Order No.: | 0
 |  |  |  |  |  |  | Date: | 1900-01-01 00:00:00
 |  |  |  |  |  |  | Job No.: | 0
TO: | [NAME], Inc.
 | Telefax - 878-4455 |  |  |  |  |  | Ship To: | 0
 | 1070 Disher Dr. |  |  |  |  |  | Lot #: | 0
 | Waterville, OH 43566 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Req. By: |  | N/A
Buyer: |  | 0 |  |  |  |  | [NAME] To: | Thermeq Co.
Ship Via: |  | Best Way |  |  |  |  |  | 1070 Disher Dr.
F.O.B. Point: |  | Prepay & Add |  |  |  |  |  | Waterville, OH  43566
Terms: |  | Net 30
B/M | Item | Drawing |  |  |  |  | Date | Unit
Sect. | No. | No. | Qty. | Unit | Stock No./Description |  | Req'd. | Price | Total
 | 1 |  | 1 | Lot | Beams and/or Posts |  | 1900-01-01 00:00:00 |  | #N/A
 |  |  |  |  | Per Thermeq Ref. No. | 0
 |  |  |  |  | 0
 |  | PLEASE ACKNOWLEDGE.  __________________________
1.  Please reference purchase order number on all related correspondence, shipping papers, and invoices. |  |  |  |  |  |  |  | TOTAL: | #N/A
2.  [NAME] is to entered in accordance with prices, delivery and specifications shown above.
3.  Notify us immediately if you are unable to ship as specified.
4. This order will be governed and executed under Thermeq's general conditions of purchase.
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Authorized By
Spreadsheet: 791284d1660239871-consolidate-duplicate-rows-into-unique-rows-to-provide-to-excel-forum
Sheet: first formual

Column1 | Column2 |  |  | Lead name | Custom
Color | Lead name |  |  | [NAME] | White ; Red; Purple; Pink
White | [NAME] |  |  | Nathan | Black ; Yellow
Red | [NAME]
Purple | [NAME]
Pink | [NAME]
Black | Nathan
Yellow | Nathan
Spreadsheet: 124629d1318516656-approximate-break-even-point-with-lookup-analyse
Sheet: Uren allocatie

[NAME] uren | [NAME] teksten | Week nr (teksten) | Linkbuild uren | [NAME] linkbuilding | Week nr (linkbuilding)
74 | KLOKKEN-EXPERT | 17 | 74 | KLOKKEN-EXPERT | 21 |  | FOTOSTUDIO-EXPERT
132 | KLOKKEN-EXPERT | 18 | 74 | KLOKKEN-EXPERT | 22
132 | KLOKKEN-EXPERT | 19 | 70 | KLOKKEN-EXPERT | 23
132 | KLOKKEN-EXPERT | 20 | 52 | KLOKKEN-EXPERT | 24
66 | KLOKKEN-EXPERT | 21 | 53 | KLOKKEN-EXPERT | 25
66 | KLOKKEN-EXPERT | 22 | 70 | KLOKKEN-EXPERT | 26
48 | KLOKKEN-EXPERT | 23 | 40 | KLOKKEN-EXPERT | 27
12 | KLOKKEN-EXPERT | 24 | 8 | KLOKKEN-EXPERT | 28
25 | FOTOSTUDIO-EXPERT | 40 |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT |  |  |  |  | NVT
 | NVT |  |  | NVT |  |  |  |  | BRIEVENBUS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | EXPERT-SHOPS
 | NVT |  |  | NVT |  |  |  |  | FERNGLAS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | FOTOSTUDIO-EXPERT
 | NVT |  |  | NVT |  |  |  |  | GLOBUS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | KAPSTOK-EXPERT
 | NVT |  |  | NVT |  |  |  |  | KINDERBOEK-EXPERT
 | NVT |  |  | NVT |  |  |  |  | KLOKKEN-EXPERT
 | NVT |  |  | NVT |  |  |  |  | MICROSCOOP-EXPERT
 | NVT |  |  | NVT |  |  |  |  | MUURBEUGEL-EXPERT
 | NVT |  |  | NVT |  |  |  |  | PRODUCTGROEPEN
 | NVT |  |  | NVT |  |  |  |  | REKENMACHINE-EXPERT
 | NVT |  |  | NVT |  |  |  |  | STROPDAS-EXPERT
 | NVT |  |  | NVT |  |  |  |  | TELESCOOP-EXPERT
 | NVT |  |  | NVT |  |  |  |  | TELESCOPEPLANET
 | NVT |  |  | NVT |  |  |  |  | VERREKIJKER-EXPERT
 | NVT |  |  | NVT |  |  |  |  | VITRINEKAST-EXPERT
 | NVT |  |  | NVT |  |  |  |  | WEERSTATIONEXPERT
 | NVT |  |  | NVT |  |  |  |  | WERELDBOL-EXPERT
 | NVT |  |  | NVT |  |  |  |  | WIELERSPORT-EXPERT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
 | NVT |  |  | NVT
Spreadsheet: 98144d1297181031-n-a-to-0-solution-holiday-register
Sheet: Sheet1

DATE | [NAME] |  |  |  | ALLOWANCE | DAYS OFF(HIDDEN) | REMAINING |  | DAYS OFF | SICK DAYS (HIDDEN) | SICK DAYS | UNPAID DAYS (HIDDEN) | UNPAID DAYS |  |  |  | CODES | FIGURES
2011-01-01 00:00:00 |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  | HH | 1
2011-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WH | 0.5
2011-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HW | 0.5
2011-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BH | 1
2011-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UL | 1
2011-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SK | 1
2011-01-07 00:00:00
2011-01-08 00:00:00
2011-01-09 00:00:00
Spreadsheet: 762986d1641925466-determining-after-summation-of-how-many-cells-a-certain-value-is-reached-example2567
Sheet: Tabelle1

Calendar Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Open Orders (Backlog) | 50000 | 54000 | 51000 | 48000 | 57000 | 46000 | 45000 | 30000 | 31000 | 29000 | 28000 | 25000 | - | - | - | - | - | - | - | -
Capacity (how many orders can be processed in this week) | 8000 | 7500 | 9000 | 9800 | 7000 | 11000 | 10000 | 10650 | 12100 | 9000 | 9000 | 9000 | 8900 | 7000 | 6800 | 8700 | 7500 | 8970 | 8605 | 5840
Weeks required to process open orders | 5.79
[NAME] sum without exceeding Backlog
Amount of weeks required to reach this sum | 5
Remaining difference
What portion of the next week is needed to cover the remaining difference?
total week required
Spreadsheet: c72c4f1e-7714-4195-8150-368c22038c7b
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
FBDP | Test | FBDP | Bordetella pertussis IgG Antibodies, MAID | Bordetella pertussis IgG Antibodies | Multi-Analyte Immunodetection (MAID) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Draw blood in a red top tube. (Serum gel is acceptable.) Send 1 mL of serum refrigerate in plastic vial. | 0.25 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference Ranges:     PT IgG       <45 IU/mL     FHA IgG    <90 IU/mL Levels of antibodies recognizing pertussis toxin (PT) and filamentous hemagglutinin antigen (FHA) are typically increased following either vaccination or natural exposure to Bordetella pertussis. Increased levels of FHA IgG alone may represent crossreactive antibodies induced by infection with other Bordetella species, Mycoplasma pneumoniae, Chlamydia pneumoniae, or nonencapsulated Haemophilus influenzae.   Test Performed by: Focus Diagnostics, Inc                              5785 Corporate Ave.                              Cypress, CA 90630 | Monday through Friday | 1 - 4 days | 3 - 8 days | 2 | 86615 |  |  |  |  | Focus Diagnositics, Inc.
FBDP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FBDP | Result | Z0564 | PT IgG | PT IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FBDP | Result | Z0565 | FHA IgG | FHA IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 33193 | 30049 | 10503 | 10000 | 23795 | 25000
2 | 33037 | 33666 | 10371 | 10000 | 24097 | 25000
3 | 32947 | 33000 | 10032 | 10000 | 24103 | 24718
4 | 32790 | 33000 | 10136 | 10000 | 23821 | 24718 | 212
5 | 32630 | 33000 | 10383 | 10000 | 24847 | 24718
6 | 32514 | 33000 | 10151 | 10000 | 24836 | 25666
7 | 32413 | 33000 | 8698 | 10000 | 24612 | 25666
8 | 32007 | 33000 | 9376 | 10000 | 24321 | 25666
9 | 32107 | 33000 | 9984 | 10000 | 23481 | 25666
10 | 32027 | 33000 | 10120 | 10000 | 24602 | 25666
11 | 31888 | 33000 | 10053 | 10000 | 23838 | 25666
12 | 31809 | 33000 | 10157 | 10000 | 24848 | 25666
13 | 31071 | 33000 | 10407 | 10000 | 24581 | 25666
14 | 31384 | 33000 | 10166 | 10000 | 24323 | 25666
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -341459.71
2001-02-14 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 217749d1362167733-help-with-vlookup-book1
Sheet: Sheet2

Cst id | Product
822805 | 123
822805 | 456
822805 | 789
822807 | 123
822808 | 456
822808 | 789
822811 | 456
822812 | 123
822812 | 789
822813 | 123
822814 | 123
822814 | 456
822814 | 789
822816 | 123
822816 | 789
822818 | 456
822818 | 789
822819 | 789
822822 | 123
822822 | 456
822822 | 789
822823 | 789
822825 | 123
822827 | 123
822827 | 456
Spreadsheet: 826435d1682009446-can-this-be-done-without-a-macro-delete-rows-based-on-comparison-with-a-tables-contents-sorter
Sheet: What the result would look like

Grade | Color
Spreadsheet: 860472d1708547420-i-need-help-for-the-formula-time-sheet
Sheet: PAY SHEET

 |  |  |  |  |  |  |  | START DATE | END DATE | PAY DATE
 |  |  |  |  |  |  |  | 2024-02-05 00:00:00
 |  |  | Testing
 |  | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 |  | 2024-02-05 00:00:00
 | TIME ON | 06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EMPLOYEE NAME
 | TIME OFF | 16:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RATE | HOURS |  | PAY
 | TIME ON |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 | TIME OFF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REG
 | OT ON | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT
 | OT OFF | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOUBLE
 | DBL ON | 05:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOL
 | DBL OFF | 09:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PTO
 | HOL ON | 05:00:00
 | HOL OFF | 09:00:00
 | PTO ON | 9:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | PTO OFF | 18:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
REGULAR
OVERTIME
OFF