tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705006d1605845753-formula-to-best-pull-in-values-from-a-chart-and-if-there-are-values-in-a-specific-column-att-summary
Sheet: Sheet6

Program & Site | Service Description (Code) | Attendance Type Option
Fairfield | Community Integration Training (Daily) (055 ) | Present - Remote
Fairfield | [NAME] (102 ) | Not Billable
[NAME] | Transportation per Trip (880 ) | AM Transportation
[NAME] | Transportation per Trip (880 ) | PM Transportation
[NAME] | Transportation per Trip (880 ) | Round Trip
Santa Rosa | Adult Day Program (510 ) | Absent
Santa Rosa | Adult Day Program (510 ) | Present - Remote
Vacaville | Adult Day Program (510 ) | Absent
Vacaville | Adult Day Program (510 ) | Present - Remote
Vacaville | Transportation per Trip (880 ) | Absent
Vacaville | Transportation per Trip (880 ) | Present - Remote
Grand Total
Spreadsheet: 781823d1653572656-pulling-data-from-one-tab-to-another-using-index-followup-requiredtraining2022-test-1-aligw
Sheet: Records

[NAME] | FullName | Supervisor | Division | MaxOfClassDate | ClassName | Frequency | ClassType
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2019-12-09 00:00:00 | Class1 | Annual | Annual
003 | Employee, Mister | Supervisor, [NAME] | Manager, [NAME] | 2019-05-08 00:00:00 | Class2 | Annual | Annual
004 | Employee, [NAME] | Supervisor, [NAME] | Manager, [NAME] | 2020-12-03 00:00:00 | Class1 | Annual | Annual
004 | Employee, [NAME] | Supervisor, [NAME] | Manager, [NAME] | 2018-05-24 00:00:00 | Class2 | Annual | Annual
005 | Employee, Junior | Supervisor, [NAME] | Manager, [NAME] | 2022-01-01 00:00:00 | Class1 | Annual | Annual
005 | Employee, Junior | Supervisor, [NAME] | Manager, [NAME] | 2022-02-02 00:00:00 | Class2 | Annual | Annual
Spreadsheet: 125981d1319455973-formula-or-macros-to-remove-double-spacing-and-special-character-example
Sheet: Sheet1

unclean data | desired result
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME]  [NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] O' reily | [NAME] O' reily
[NAME]   [NAME] | [NAME]
Spreadsheet: 675848d1588523007-pull-column-values-from-another-sheet-that-are-in-the-current-sheet-sample_miss-val
Sheet: Sheet A

VALUE A | VALUE B | VALUE C
 | B1 | C1
 | B2 | C2
 | B3 | [NAME]
 | B4 | C4
 | B5 | C5
 | B6 | C6
 | B7 | C7
 | B8 | C8
 | B9 | C9
 | B11
 | B13
 | B12
Spreadsheet: 39d056bb-bea2-4c47-8690-96d1344cdfc2
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 78. Value of Building Approved, Chain Volume Measures, Original - South Australia
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 ;  South Australia ;  Total houses ;  New ; |  |  | Original | A590507C | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total other residential building ;  New ; |  |  | Original | A590508F | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  New ; |  |  | Original | A590509J | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590510T | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590511V | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590512W | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  South Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590513X | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: a5495fb1-28a1-42b2-b601-18c219ed99a5
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
BWOR | Test | BWOR | Blood Worm, IgE | Blood Worm, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BWOR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BWOR | Result | BWOR | Blood Worm, IgE | Blood Worm, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6047-5
Spreadsheet: 140e5b47-59ff-4f99-96da-8ad6c33396f0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
Count of no_peserta
[NAME] | Total
[NAME] (Konselor) | 2
[NAME] | 35
Pemasaran | 8
[NAME] | 1
[NAME] | 1
[NAME] | 1
[NAME] | 3
Teknik Sepeda Motor | 2
Grand Total | 53
Spreadsheet: 778348d1651012997-apply-variable-compounding-interest-between-two-dates-not-sum-var-cmpnd-ror
Sheet: Sheet1

Start Date | End Date | Principal | Final Amount
2020-06-12 00:00:00 | 2021-06-15 00:00:00 | 1000
 |  | 2018-06-01 00:00:00 | 0.008743
 |  | 2018-09-01 00:00:00 | 0.00984
 |  | 2018-12-01 00:00:00 | 0.010961
 |  | 2019-03-01 00:00:00 | 0.007353
 |  | 2019-06-01 00:00:00 | 0.004657
 |  | 2019-09-01 00:00:00 | 0.002313 | Manual Calculation applying compounding interest to Principal between Start and End Dates
 |  | 2019-12-01 00:00:00 | 0.00289 |  |  | Qtrly | Same?
 |  | 2020-03-01 00:00:00 | 0.000288
 |  | 2020-06-01 00:00:00 | -0.002887
 |  | 2020-09-01 00:00:00 | -0.002304
 |  | 2020-12-01 00:00:00 | 0
 |  | 2021-03-01 00:00:00 | -0.00029
 |  | 2021-06-01 00:00:00 | 0.002597
 |  | 2021-09-01 00:00:00 | 0.005729
Spreadsheet: 844565d1696342494-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-2024
Sheet: 1

Name | lbs | oz | Oz (total) | Points
 | 9999999
 | 4325
 | 643463
 | 1 | 6
 | 6346634
 | 1 | 5
 | 634643
 | 657
 | 754
 | 1 | 4
 | 1 | 3
 | 0 | 0
 | dnf
Spreadsheet: fc3d0c6c-7593-4f57-9563-3600ffc50e17
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Falls mehr in die Verkehrsinfrastruktur investiert wird, wo soll der Schwerpunkt der [NAME] liegen?
 | Stadt/Land
Antwort
[NAME]
Strasseninfrastruktur
Neutral / Weiss nicht
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 869029d1715701954-help-modelling-a-fee-with-a-cap-and-collar-with-a-deferred-element-simple-performance-fee-1-
Sheet: Sheet1

Fee Projections
 |  | Q3-24 | Q4-24 | Q1-25 | Q2-25 | 12m Total
Base fees |  |  |  |  |  |  |  |  | Fee/Q | 0.48
Success fees |  | 0.4864020000000001 | 1.80943 | 0 | 0
Gross fees
Increase to floor
[NAME] fees in excess of cap
Unwind deferred fees |  | 0
Net fees
Deferred fee balance
 |  | Q3-24 | Q4-24 | Q1-25 | Q2-25 | 12m Total
Base fees |  | 0.48 | 0.48 | 0.48 | 0.48 | 1.92
Success fees |  | 0.4864020000000001 | 1.80943 | 0 | 0 | 2.295832
Gross fees |  | 0.966402 | 2.28943 | 0.48 | 0.48 | 4.215832000000001
Increase to floor |  | 0 | 0 | 0.37 | 0.37
[NAME] fees in excess of cap |  | -0.966402 | -2.28943 | -0.48 | -0.48
Unwind deferred fees |  | 0 | 0.966402 | 2.28943 | 0.48
Net fees |  | 0 | 0.966402 | 2.65943 | 0.85 | 4.475832
Deferred fee balance |  | 0.966402 | 2.28943 | 0.48 | 0.48
Spreadsheet: 886555d1736588890-formola-required-to-return-text-excel-forum
Sheet: Sheet1

 |  |  |  | Total : | RQ ST H |  | Reason Desciption
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 0
 |  |  |  |  | 83.07692307692308
 |  |  |  | Total :
 |  |  |  |  | 24
 |  |  |  |  | 6
 |  |  |  |  | 15
 |  |  |  | Total :
 |  |  |  |  | 8.0256
 |  |  |  |  | 0
 |  |  |  |  | 9.6
 |  |  |  |  | 96 |  | Financial Audit
 |  |  |  |  | 86.4
 |  |  |  | Total :
 |  |  |  |  | 17.45454545454545
 |  |  |  |  | 61.44 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 48 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 144
 |  |  |  | Total :
 |  |  |  |  | 30.83636363636364 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  |  | 0
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 27.2
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  |  | 0
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  |  | 0
 |  |  |  | Total :
 |  |  |  |  | 0
 |  |  |  |  | 38.21176470588235
 |  |  |  | Total :
 |  |  |  |  | 90.496
 |  |  |  | Total :
 |  |  |  |  | 83.9513043478261
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 48.16
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 60
 |  |  |  | Total :
 |  |  |  |  | 48
 |  |  |  |  | 48.8
 |  |  |  | Total :
 |  |  |  |  | 0 |  | All plant washing cleaning (Financial Audit
Spreadsheet: 833343d1686916099-overtime-for-sunday-only-after-a-certain-number-of-hours-worked-query-on-formula
Sheet: Hours 

[NAME]
2023-05-01 00:00:00 | Employee Code | Employee Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours worked | Required Hours | Overtime 1.5/ Short Time | Sunday |  |  | Helper to get column where targer is met.
 | 1 | EMPLOYEE 1 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 5 | 0 | 0 | 0 | 0 | 9 |  | 117
 | 2 | EMPLOYEE 2 | 9 | 9 | 0 | 0 | 0 | 0 | 0 | 9 | 9 | 5 | 5 | 5 | 5 | 8 | 8 | 8 | 8 | 8 | 0 | 8 | 8 |  | 100
 | 3 | EMPLOYEE 3 | 9 | 9 | 9 | 9 | 9 | 9 |  |  | 9 | 9 | 9 | 9 | 9 | 9 |  |  |  | 9 | 9 | 9 | 5 |  | 117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is an Array formula.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It must be entered with
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ctrl+Shift+Enter
Spreadsheet: 269523d1381185366-rating-total-ratings
Sheet: Sheet2

 | Player Name | Team | Rating Total
1 | Player1 | Team1 | -4
2 | Player2 | Team1
3 | Player3 | Team1
4 | Player4 | Team1
5 | Player5 | Team1
6 | Player6 | Team1
7 | Player7 | Team1
8 | Player8 | Team1
9 | Player9 | Team1
10 | Player10 | Team1
11 | Player11 | Team1
12 | Player12 | Team2
13 | Player13 | Team2
14 | Player14 | Team2
15 | Player15 | Team2
16 | Player16 | Team2
17 | Player17 | Team2
18 | Player18 | Team2
19 | Player19 | Team2
20 | Player20 | Team2
21 | Player21 | Team2
22 | Player22 | Team2
23 | Player23 | Team3
24 | Player24 | Team3
25 | Player25 | Team3
26 | Player26 | Team3
27 | Player27 | Team3
28 | Player28 | Team3
29 | Player29 | Team3
Spreadsheet: ad62b25a-3a41-4945-b78c-c72127492c7f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38708216 | 2013-11-25 22:44:34 | ALLIES | 0 | 3 | 6 | 635250 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38708493 | 2013-11-25 23:13:29 | AXIS | 0 | 5 | 6 | 635250 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38762740 | 2013-11-29 22:44:27 | ALLIES | 1 | 6 | 5 | 205567 | lenaianel | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38763335 | 2013-11-29 23:19:24 | AXIS | 0 | 5 | 6 | 205567 | lenaianel | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
38809308 | 2013-12-03 00:53:04 | ALLIES | 0 | 5 | 6 | 475647 | Steelie | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38863985 | 2013-12-07 01:23:34 | ALLIES | 1 | 6 | 3 | 760708 | borderbattles | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
Spreadsheet: 888817d1739397200-sorting-dates-1900-datesort
Sheet: Sheet1

 |  | 18 Nov 1800 | 1800-11-18 |  | 18 Nov 1800 |  |  |  |  | Column1 | Column2
 |  |  |  |  | Nov 1800 |  |  |  |  | Jan | 01
 |  |  |  |  | 1800 |  | #N/A |  |  | Feb | 02
 |  |  |  |  |  |  | #N/A |  |  | Mar | 03
 |  |  |  |  |  |  | #N/A |  |  | Apr | 04
 |  |  |  |  |  |  | #N/A |  |  | May | 05
 |  |  |  |  |  |  | #N/A |  |  | Jun | 06
 |  |  |  |  |  |  | #N/A |  |  | Jul | 07
 |  |  |  |  |  |  | #N/A |  |  | Aug | 08
 |  |  |  |  |  |  | #N/A |  |  | Sep | 09
 |  |  |  |  |  |  | #N/A |  |  | Oct | 10
 |  |  |  |  |  |  | 1 |  |  | Nov | 11
 |  |  |  |  |  |  | #N/A |  |  | Dec | 12
Spreadsheet: 793249d1661363787-creating-a-results-list-of-multiple-races-finn-resultaten-2022-hd
Sheet: 31 juli

 |  | Place | 1e wedstrijd | 2e wedstrijd | 3e wedstrijd |  |  | Place | sailnumber | points | points overall | count
 |  | 1 | 148 | 148 | 148 |  |  | 1 |  | 3 | 9
 |  | 2 | 85 | 113 | 151 |  |  | 2 | 151 | 10 | 8
 |  | 3 | 222 | 222 | 13 |  |  | 3 | 222 | 10 | 7
 |  | 4 | 151 | 151 | 222 |  |  | 4 | 113 | 14 | 6
 |  | 5 | 13 | 19 | 19 |  |  | 5 | 13 | 16 | 5
 |  | 6 | 113 | 85 | 113 |  |  | 6 | 85 | 16 | 4
 |  | 7 | 145 | 145 | 145 |  |  | 7 | 19 | 19 | 3
 |  | 8 | 47 | 13 | 85 |  |  | 8 | 145 | 21 | 2
 |  | 9 | 19 | 47 | 47 |  |  | 9 | 47 | 26 | 1
 |  |  |  |  |  |  |  |  | #REF! | #REF!
Spreadsheet: 192533d1352451807-lists-to-multiple-sheets-data-test
Sheet: Data

Job | Postcode | Tech 1 | Tech 2 | [NAME] | Departure
Jonos | W5 3LD | [NAME] |  | 03/10/2012 13:00 | 03/10/2012 16:00
BLUE ANCHOR | KT20 5SL | [NAME] | [NAME] | 04/10/2012 10:00 | 04/10/2012 11:30
Goat | SW11 1EQ | [NAME] |  | 04/10/2012 12:20 | 04/10/2012 13:00
ROYAL OAK | BR6 6BJ | [NAME] |  | 01/10/2012 09:15 | 01/10/2012 11:15
Pheasant | TN25 4QH | [NAME] |  | 01/10/2012 13:45 | 01/10/2012 14:25
RED BARN | DA7 6HG | [NAME] |  | 01/10/2012 15:30 | 01/10/2012 16:00
Spreadsheet: 827158d1682516129-divide-points-by-rank-divide-points-test-answer6
Sheet: Sheet1

 | Points | Rank 1 | Player # | Rating | Rank | Score
 | 100 | 0.3 | 6 | 93
 |  |  | 11 | 93 | 1 | 22.72727272727273
 | Players |  | 12 | 90 | 3 | 15.90909090909091
 |  |  | 4 | 89 | 4 | 13.63636363636364
 |  |  | 10 | 87 | 5 | 9.090909090909092
 |  |  | 3 | 85 | 6 | 4.545454545454546
 |  |  | 8 | 85 | 6 | 4.545454545454546
 |  |  | 1 | 84 | 8 | 2.272727272727273
 |  |  | 5 | 84 | 8 | 2.272727272727273
 |  |  | 13 | 84 | 8 | 2.272727272727273
Spreadsheet: 840511d1692790462-table-to-work-out-take-home-pay-from-total-commission-comms-summary-aligw
Sheet: Sheet1

 | Month | Comms
 | 1 | 12000 |  | Manual input rows in Green
 | 2 | 13000
 | 3 | 20000
 | Total |  |  | The bottom table is all calculated from C10 (£45000)
 | 0-15000
 | 15001-35000 | 2000
 | 35000+ | 2000
 | [NAME] | 4750
Spreadsheet: 760870d1640497794-dropdown-list-and-vlookup-sample
Sheet: Sheet1

 | list |  |  |  |  |  |  |  |  |  | a | b | c | d | e | f
 | 1
1 |  |  | a | b | c | d | e | f | IF B2-1
2 |  |  | 2a | 2b | 2c | 2d | 2e | 2f | IF B2-2
3 |  |  | 3a | 3b | 3c | 3d | 3e | 3f | IF B2-3
4 |  |  | 4a | 4b | 4c | 4d | 4e | 4f | IF B2-4
5 |  |  | 5a | 5b | 5c | 5d | 5e | 5f | IF B2-5
6 |  |  | 6a | 6b | 6c | 6d | 6e | 6f | IF B2-6
Spreadsheet: 861282d1709205207-formula-error-formula-error-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | AliGW
 | 10000 |  |  |  |  | 10000 | 1514
 |  |  |  |  |  |  | 1106
 |  |  |  |  |  |  | 647
 |  |  |  |  |  |  | 776
 |  |  |  |  |  |  | 1945
 |  |  |  |  |  |  | 642
 |  |  |  |  |  |  | 623
 |  |  |  |  |  |  | 1469
 |  |  |  |  |  |  | 1798
 |  |  |  |  |  |  | 989
 |  |  |  |  |  |  | 1646
 |  |  |  |  |  |  | 1053
 |  |  |  |  |  |  | 898
 |  |  |  |  |  |  | 1392
 |  |  |  |  |  |  | 1986
 |  |  |  |  |  |  | 875
 |  |  |  |  |  |  | 1674
 |  |  |  |  |  |  | 1673
 |  |  |  |  |  |  | 1051
 |  |  |  |  |  |  | 1715
 |  |  |  |  |  |  | 519
 |  |  |  |  |  |  | 1515
 |  |  |  |  |  |  | 1503
 |  |  |  |  |  |  | 1109
 |  |  |  |  |  |  | 522
 |  |  |  |  |  |  | 1317
Spreadsheet: 42718d1241289796-solved-ignore-text-but-calculate-numbers-in-cells-jacks-gardening
Sheet: Sheet1

JACKS GARDENING                                                                                  PO BOX 1234                                                                                                                    ANYWHERE, WORLD |  |  | INVOICE # | 22009
 |  |  | SERVICE MONTH | YEAR
 |  |  | NOTE
[NAME]                                                                                          122333 S. ATKINS                                                                                           ANYWHERE, WORLD
QTY | [NAME] |  | UNIT PRICE | TOTAL
1 | LABOR (per hour)                                                             $50.00 |  |  | #N/A
 |  |  | SUBTOTAL | #N/A
 |  |  | TAX
 |  |  | TOTAL
1
2
3
4
5
6
7
8
9 | LABOR (per hour)                                                             $50.00
10
 |  |  | JANUARY | 2009
 |  |  | FEBRUARY | 2010
 |  |  | [NAME] | 2011
 |  |  | APRIL | 2012
 |  |  | MAY | 2013
 |  |  | [NAME] | 2014
 |  |  | JULY | 2015
 |  |  | AUGUST | 2016
THANK YOU |  |  | SEPTEMBER | 2017
THANK YOU FOR YOUR PAYMENT |  |  | OCTOBER | 2018
HAVE A GREAT HOLIDAY |  |  | NOVEMBER | 2019
PLEASE PAY PROMPTLY |  |  | DECEMBER | 2020
TO AVOID SERVICE INTERUPTION,                                                                          PLEASE PAY PROMPTLY
Spreadsheet: 453117d1459175229-new-to-index-index-formula-not-working-aprils-traveler-print
Sheet: Sheet1

 |  | WO# | 71807-01
Row | Pn# | Step # | Op Description | Machine | Vendor | Operation
Spreadsheet: 817453d1676241389-truncated-cone-volume-formula-in-excel-truncated-cone-volume
Sheet: Sheet1

H | R | r | V | Web
12 | 0.13 | 0.04 |  | 0.29 | wrong
 |  |  |  | 0.2978 | correct
 |  |  |  | 0.2978 | rounded
H | height
R | base radius
r | top radius
V | volume
Web | Web calc results
 |  |  |  | Ref: https://www.omnicalculator.com/math/truncated-cone-volume
Spreadsheet: 770135d1645822840-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: Calculation

 | Selected Information (Form Controls) |  |  |  |  |  |  |  |  |  |  | Calculation for scrolling table
 |  | Selected Type | 1
 |  | Selected Year | 1 |  |  |  |  |  |  |  |  |  | Bug
 |  | Selected Bug | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | Type
 |  |  |  |  |  |  |  |  |  |  |  |  | Year
 | For Drop_down selections |  | 7 |  |  | Types data |  |  |  |  |  |  |  |  |  |  | difference from  previous year
 | Year | Type | Values |  |  |  | gram_positive |  |  |  |  | Nr. | Type | isolates_tested | isolates_susceptible | %susceptibility | Δ% susceptibility
 | 2018 | gram_negative | isolates_tested |  |  | Amikacin-Citrobacter freundii | Ampicillin-Enterococcus spp.
 | 2019 | gram_positive | isolates_susceptible |  |  | Amikacin-Klebsiella pneumoniae | Group A Strep-Penicillin
 | 2020 |  | %susceptibility |  |  | Amikacin-Proteus mirabilis | Group B Strep-Penicillin
 |  |  |  |  |  | [NAME] cloacae complex | Linezolid-MRSA
 |  |  |  |  |  | [NAME] morganii | Penicillin-Staphylococcus aureus
 |  |  |  |  |  | [NAME] coli | Linezolid-MSSA
 |  |  |  |  |  | Ertapenem-Acinetobacter baumannii | Penicillin-MRSA
 |  |  |  |  |  | Ertapenem-E. coli | Penicillin-MSSA
 |  |  |  |  |  | Tobramycin-Klebsiella aerogenes
 |  |  |  |  |  | Imipenem-Citrobacter freundii
 |  |  |  |  |  | Meripenem-Citrobacter freundii
 |  |  |  |  |  | Amikacin-E. coli
 |  |  |  |  |  |  |  |  |  |  |  |  | Calculations for headers
 |  |  |  |  |  |  |  |  |  |  |  |  | Hospital Numbers
 |  |  |  |  |  |  |  |  |  |  |  |  | isolate_hospital_n | `=sum of unique values  for each "type",  "year" and "bug" | *** one result from the data is that the isolates_hospital_n  sum for Citrobacter Freundii bug is 13 and not 39. and for MSSA is 66 and not 132.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | *** This should be 160. Different hospitals have exact  test numbers for the same bug and year. Check the blue cells in the data sheet.
Spreadsheet: 858950d1707419225-dynamic-unpivot-array-based-on-condition-dynamic-unpivot-array-based-on-condition-excelforum
Sheet: Sheet1

 | Activity Name | Type of Units | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00
 | Activity 1 | Planned Units | 4 | 5 | 3
 | Activity 2 | Planned Units |  | 2 | 5 | 7
 | Activity 3 | Planned Units | 2 |  | 5 | 6
 | Activity Name | Type of Units | Date | Units
 |  | Planned Units | 2024-01-01 00:00:00 | 4
 | Activity 1 | Planned Units | 2024-01-08 00:00:00 | 5
 | Activity 1 | Planned Units | 2024-01-15 00:00:00 | 3
 | Activity 2 | Planned Units | 2024-01-08 00:00:00 | 2
 | Activity 2 | Planned Units | 2024-01-15 00:00:00 | 5
 | Activity 2 | Planned Units | 2024-01-22 00:00:00 | 7
 | Activity 3 | Planned Units | 2024-01-01 00:00:00 | 2
 | Activity 3 | Planned Units | 2024-01-15 00:00:00 | 5
 | Activity 3 | Planned Units | 2024-01-22 00:00:00 | 6
Spreadsheet: f122604b-7afd-42dc-b019-684c7847e786
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
RNAP | Test | RNAP | RNA Polymerase III Antibodies, IgG, Serum | RNA Polymerase [NAME], IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum, [NAME] |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Cold OK; Warm reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <20.0 U (negative) 20.0-39.9 U (weak positive) 40.0-80.0 U (moderate positive) >80.0 U (strong positive) | Wednesday; Evening | 1 day | 7 days | 1 | 83520 |  |  |  |  | Rochester
RNAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
RNAP | Result | RNAP | RNA Polymerase [NAME], IgG, S | RNA Polymerase [NAME], IgG, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | In Process