tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 39

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
39 | 2007-02-16 00:00:00 | 8 | 0.39 | 1.8 | 0.7 | 1.8 | 2.8 |  |  |  | 0.5 |  | 2.276839915321233 | 1.7 | 0 | 5 |  |  |  |  | 0.3
Well #39 | 2013-10-11 00:00:00 | 3.6 | 0.96 | 3.97 | 1.58 | 1.8 | <0.1 |  |  | 5.3 | 2.2 |  | 1.1 | 0.2 | 0.03 | 4.4 |  | <0.10 | <0.02 |  | -5.6
Well - 39 | 2014-02-05 00:00:00 | 7.8 | 0.65 | 2.95 | 1.21 | 2 | 3.6 |  |  | 0.8 | 1.8 |  | 1.4 | 2.8 | 0.03 | 4.6 |  | <0.10 | <0.02 |  | 0.4
Well 39 | 2015-04-02 00:00:00 | 7.8 | 0.56 | 3.14 | 1.26 | 1.8 | 3.5 |  |  | 0.5 | 1.4 |  | 1.2 | 2.5 | <0.05 | 4.1 |  | <0.10 | <0.02 |  | 0.5
Well 39 | 2016-04-04 00:00:00 | 7.92 | 0.613 | 3.72 | 1.5 | 1.93 | 3.644792582527376 | 3.644792582527376 | 0 | 0.556 | 1.6618 | 390.4 | 1.19 | 2.37 | 0.03 | 5.06657 | 0.007 | 0 | 0 | 0
W39 | 2018-05-29 00:00:00 | 7.97 | 0.43 | 2.43 | 1 | 1.85 |  | 3.598833026936296 | 0 | 0.346 | 0.417 | 275.2 |  |  | 0.028 | 2.187 | 0.012 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments: Cl low 2018, Alk low 2013
Spreadsheet: 154025d1336152729-return-yes-no-late-from-multiple-tick-or-cross-sample
Sheet: Sheet1

 | Extract from Rental Manager
 | Rent amount |  | 900 |  |  | in a hidden data sheet |  |  |  | Arrears options
 |  |  |  |  |  |  | data |  |  | YES
 | Payment History |  | Amount | Paid |  |  | a |  |  | NO
 | September 2011 |  |  | a |  |  | r |  |  | LATE
 | October 2011 |  |  | a |  |  | s
 | November 2011 |  |  | a
 | December 2011 |  |  | a |  | this is on a different sheet within the same work book
 | January 2012 |  |  | a
 | Februrary 2012 |  |  | a |  |  |  | Monthly rent |  | Arrears | Amount
 | March 2012 |  |  | r |  | Property 1 |  | 850 |  | NO | 0
 | April 2012 |  |  | r |  | Property 2 |  | 475 |  | LATE | 475
 | May 2012 |  |  | s |  | Property 3 |  | 1300 |  | NO | 0
 | June 2012 |  |  | s |  | Property 4 |  | 900 |  | YES | 1800
 | July 2012 |  |  | s |  | etc |  | 850 |  | NO | 0
 | August 2012 |  |  | s |  | etc |  | 800 |  | NO | 0
 | I need the formula to auto fill the boxes I have highlighted red, from the fact that the 2 'x' have been applied to the paid column
 | if only 1 'x' then it returns late and does not fill red
 | is this possible
Spreadsheet: mary_fischer__25624__31X
Sheet: E3.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF INVESTMENT IN UNCONSOLIDATED AFFILIATES, PARTNERSHIPS & JOINT VENTURES
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-3
 |  | CURRENT |  | BEGINNING BALANCE |  | EQUITY EARNINGS |  | CASH ACTIVITY - PAID / (RECEIVED) |  |  |  |  |  | NON-CASH ACTIVITY |  |  |  | ENDING BALANCE
NAME OF PARTNERSHIP , |  | % |  | @ 12/31/2000 |  | IN |  |  |  |  |  |  |  |  |  |  |  | @ 12/31/2001
SUBSIDIARY OR JOINT VENTURE |  | OWNED |  | DR / (CR) |  | UNCONSOL. SUB |  | ADVANCES |  | DISTRIBUTIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | DR / (CR) |  | COMMENTS
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
 |  |  |  | * |  | ** |  |  |  |  |  |  |  |  |  |  |  | *
Total Investment
*  MUST TIE TO HYPERION TOT_INVEST_SUBS |  |  | Asset/Expense Accts:  DR/(CR)
** MUST TIE TO HYPERION TOT_EQEARN_OTH |  |  | Income Accts:  (DR)/CR |  |  | Reverse signs from Hyperion
 |  |  |  |  |  | Credit Positive Liability
 |  |  |  |  |  | Debit Negative Liability
Spreadsheet: 36699d1234552419-using-list-function-with-hiding-irrelevant-outputs-monthly-models-3
Sheet: Staff Number Calculation

 | Select Year | Annualized Year
Branch 26 | AS IS
Work Items | Transactions Received to be Processed | Est. Processing (Min Time in Hours) - YTD | Est. Processing (Max Time in Hours) - YTD | Est. Processing (Average Time in Hours) - YTD | Est. Min FTEs Required 2008 | Est. [NAME] 2008 | Est. Average FTEs Required 2008
A | 8899 | 482.0291666666666 | 741.5833333333334 | 611.80625 | 5.806705817396979 | 8.933393565226122 | 7.37004969131155
B | 60.77 | 18.747545 | 32.43092333333333 | 25.58923416666666 | 0.2258400240927571 | 0.3906751794408473 | 0.3082576017668022
C | 3813 | 518.6474375 | 765.6980625 | 642.1727500000001 | 6.247823369974403 | 9.223888721578076 | 7.735856045776241
 | 12772.77
Output | Monthly volumes, just for NBVC's view | Est. Processing (Min Time in Hours) - YTD | Est. Processing (Max Time in Hours) - YTD | Est. Processing (Average Time in Hours) - YTD | Est. Min FTEs Required 2008 | Est. [NAME] 2008 | Est. Average FTEs Required 2008
Total Staff Required (Annualized Year) | 855.69 | 84.95201243055556 | 128.3093599305556 | 106.6306861805555 | 1.023364100955345 | 1.545663122187087 | 1.284513611571216
 | 600.1600000000001
 | 638.62
 | 1147.51
 | 1339.09
 | 1201.34
 | 1237.59
 | 1062.75
 | 1393.93
 | 1220.26
 | 1081.75
 | 994.08
Just for validation---------> | 12772.77
 |  | 138.3541666666667
 |  | 0.6
 |  | 83.01249999999999 |  | Notes:
 |  |  |  | If Annualized Year option = [NAME] to '[NAME] '!B4, '[NAME] '!C4 & '[NAME] '!E4
 |  |  |  | If 1st Quarter  option = [NAME] to '[NAME] '!B9:D9, + '[NAME] '!B14:D14, + '[NAME] '!B19:[NAME]
For Calculation Purposes Only |  |  |  | If 2nd Quarter  option = '[NAME] '!B23:D23, + '[NAME] '!B28:D28, + '[NAME] '!B33:D33
Year | Number of Months |  |  | likewise 3rd and 4th Quarter
Month by Month | 1 |  |  | If monthly option selected = [NAME] to monthly totals in [NAME] worksheet e.g.,
First Quarter only | 3 |  |  | [NAME] to '[NAME] '!B9:D9, + Refer to '[NAME] '!B14:D14, + Refer to '[NAME] '!B19:[NAME] and so on
Second Quarter only | 3
Third Quarter only | 3
Fourth Quarter only | 3
Annualized Year | 12
Month | Numerically | Weeks |  | Numerically | Weeks
0 | 1 | 0 |  | 0 | 0
April | 4 | 17.14285714285714 |  | 1 | 4.428571428571429
August | 8 | 34.71428571428571 |  | 2 | 8.428571428571429
December | 12 | 52.14285714285714 |  | 3 | 12.85714285714286
February | 2 | 8.428571428571429 |  | 4 | 17.14285714285714
January | 1 | 4.428571428571429 |  | 5 | 21.57142857142857
July | 7 | 30.28571428571428 |  | 6 | 25.85714285714285
June | 6 | 25.85714285714285 |  | 7 | 30.28571428571428
March | 3 | 12.85714285714286 |  | 8 | 34.71428571428571
May | 5 | 21.57142857142857 |  | 9 | 39
November | 11 | 47.71428571428571 |  | 10 | 43.42857142857142
October | 10 | 43.42857142857142 |  | 11 | 47.71428571428571
September | 9 | 38.99999999999999 |  | 12 | 52.14285714285714
Spreadsheet: 151734d1335095757-error-message-the-pivottable-field-is-not-valid-3ak
Sheet: Sheet1

1071-218-XSV  -402 |  | 1
1071-218-UL   -402B
1071-218-UL   -402C
1071-218-UL   -402D
1071-218-XY   -402
1071-218-XSV  -404A |  | 3
1071-218-XSV  -404B
1071-218-UL   -404B
1071-218-UL   -404C
1071-218-UL   -404D
1071-218-XY   -404
1071-218-XSV  -423A |  | 3
1071-218-XSV  -423B
1071-218-UL   -423B
1071-218-UL   -423C
1071-218-UL   -423D
1071-218-XY   -423
1071-218-XSV  -693A |  | 6
1071-218-XSV  -693B
1071-218-UL   -693B
1071-218-UL   -693C
1071-218-UL   -693D
1071-218-XY   -693
1071-218-XSV  -786A |  | 6
1071-218-XSV  -786B
1071-218-UL   -786B
1071-218-UL   -786C
1071-218-UL   -786D
1071-218-XY   -786
1071-218-XSV  -001A |  | 9
1071-218-XSV  -001B
1071-218-UL   -001A
1071-218-XY   -001
Spreadsheet: 754249d1636043825-add-a-cell-to-a-formula-nascondere
Sheet: Foglio1

 | 100
gen | 0 | 0 |  | 50 |  |  | =IF(AND(B3=0,C3=0),"",SUM(B1,D3,E3))
feb | 0 | 0 |  | 85
[NAME] | 0 | 0
apr | 0 | 0
mag | 0 | 0
[NAME] | 0 | 0
lug | 0 | 0
ago | 0 | 0
set | 0 | 0
ott | 0 | 0
nov | 0 | 0
dic | 0 | 0
Spreadsheet: 75330d1275920478-auto-rank-sort-wc-master-v3
Sheet: Leage Table

 | WC 2010
 | Position | Name | Score | Day 1 rank | Day 2 rank | Day 3
 | 1 |  |  | 11 | 10 | 1 | 1 | 1
 | 2 |  |  | 4 | 4 | 2 | 2 | 3
 | 3 |  |  | 5 | 5 | 4 | 5 | 3
 | 4 |  |  | 1 | 1 | 3 | 4 | 2
 | 5 |  |  | 8 | 5 | 11 | 11 | 6
 | 6 |  |  | 7 | 8 | 8 | 11 | 12
 | 7 |  |  | 11 | 12 | 4 | 3 | 5
 | 8 |  |  | 2 | 2 | 7 | 7 | 8
 | 9 |  |  | 11 | 12 | 8 | 8 | 10
 | 10 |  |  | 2 | 2 | 11 | 11 | 12
 | 11 |  |  | 5 | 5 | 6 | 5 | 7
 | 12 |  |  | 8 | 10 | 11 | 11 | 12
 |  |  |  | 10 | 8 | 10 | 10 | 9
 |  |  |  | 11 | 12 | 11 | 8 | 10
 |  |  |  | 11 | 12 | 11 | 11 | 12
Spreadsheet: 329709d1404389029-look-up-with-multiple-values-project-hours
Sheet: Sheet1

ID | Name | Project ID | Hours
1111 | Arun | 144451 | 190 |  | I have used array formula..
1111 | Arun | 144452 | 25 |  | so use ctrl + shift + enter to enter formula..
1111 | Arun | 144453 | 25 |  | don't use only enter…
2222 | Arjun | 1333321 | 10
2222 | Arjun | 1555521 | 50 |  | waiting for *
3333 | Raju | 1777721 | 120
Spreadsheet: 440230d1452703184-vacation-tracking-from-an-anniversary-date-from-year-to-year-vacation-tracking-2015
Sheet: November

Employee Absence Schedule
November | Dates of Absence
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | Total Hours
A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
G |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | 8
K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
L |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
M |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.58 | 8 | 8 | 8 |  |  | H
N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
O |  |  |  |  | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
Spreadsheet: 138000d1327473748-sum-cell-based-on-criteria-countif-formula-assistance-test-1-copyvlady2
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | A |  | X
 |  |  | A | B |  | A | B
 |  | x |  |  |  |  | B
 |  | y
 |  | z |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | Y
 |  |  |  |  |  | A | B
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
Spreadsheet: 119477d1314438092-using-if-with-multiple-criteria-book1-12-1-
Sheet: Sheet1

Customer Name | Ageing days | Amount |  | 30 | 60 | 90 | 180 | e307
A | 365 | 5000 |  |  |  |  |  | 5000
B | 190 | 20000 |  |  |  |  |  | 20000
C | 25 | 12000 |  | 12000 | 0 | 0 | 0 | 0
D | 61 | 44000 |  |  |  | 44000 | 0 | 0
E | 125 | 10000 |  |  |  |  | 10000 | 0
Customer Name | Ageing days | Amount | 30 | 60 | 90 | 120 | 150 | 180 | other
A | 365 | 5000 |  |  |  |  |  |  | 5000
B | 190 | 20000 |  |  |  |  |  |  | 20000
C | 25 | 12000 | 12000
D | 61 | 44000 |  |  | 44000
E | 125 | 10000 |  |  |  |  | 10000
Spreadsheet: 374a3b0b-147f-45a4-821d-a97912cf24f5
Sheet: Brotherhood

OALM_ID | Title | First_Name | Middle_Name | Last_Name | Suffix | Nickname | Street_Address_1 | Street_Address_2 | City | State | [NAME] | [NAME] | Phone_Extension | Phone_Type | Email_Address | [NAME] | Gender | Unit_Type | Unit_Number | Chapter | BSA Person ID | Ordeal_Date | Ordeal_Council | Brotherhood_Date | Dues_Year | Reporting_Chapter
Spreadsheet: 119786d1314738663-lookup-question-testing-ground
Sheet: Availability

Day/Time | JM | MS | AR | KC | MP | BW | ST
Mon AM
Mon PM |  |  | X
Mon Eve |  |  | X | X
Tue AM | X
Tue PM |  |  | X
[NAME] | X |  | X | X
Wed AM | X |  |  |  | X | X
Wed PM |  |  | X | X
Wed Eve | X |  | X
Thu AM |  |  |  |  | X | X
Thu PM |  |  | X | X
[NAME] |  |  | X
Fri AM |  |  |  |  | X | X
Fri PM |  |  | X
Fri Eve |  |  | X
Sat AM
Sat PM
[NAME]
Spreadsheet: c08a861b-6323-41b9-bc2d-cb9ea777e794
Sheet: Energy

 | 2. Energy |  |  |  |  | Comments |  | Click here to return to Summary page
 | A) Computer Monitors | 1 Pt for every 33% |  | 3
 | Total # Monitors | 0 |  |  |  |  |  | If a practice doesn't apply to you type N/A in green cell.
 | Total # Monitors on 15 min timers for stand-by/sleep mode | 0
 | B) Equipment Inventory | No point value
 | # Multi-function Copiers | 0
 | # Desk-side Printers | 0
 | # Fax Machines | 0
 | # Scanners | 0
 | Total Green IT Points
 | C) Is your Copier Energy Star rated? | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | D) Do you have any standalone machines including desk-side printers, fax machines, or scanners?                                               If yes, 3 points will be deducted. | 3 Pts, Enter "YES" or "NO" in cell below this one. |  | 3 |  |  |  | FILL IN THE GREEN CELLS ONLY
 |  | YES |  |  |  |  |  | CALCULATIONS ARE DONE AUTOMATICALLY
 | E) Compact fluorescent light bulbs are in all floor and desk lamps with screw-in bulbs. | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 3
 |  | NO
 | F) Computers shut down completely at night | 1 Pt for every 33% |  | 3
 | Total # Computers | 0
 | Total # Computers turned off at night | 0
 | G) Office has installed power strips that are turned off when staff leaves office for the day (for small appliances too) | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | H) Light | 8  Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 | 1. Natural Light is used | NO
 | 2. Light sensors are used | NO
 | 3. Lights are turned off when not in use | NO |  | 2
 | 4. Signs are posted on/near switches | NO |  | 2
 | 5. Number of light switches | 0
 | I)Thermostat settings are regulated    68° or below in winter& 75° or above in sum | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  | NO
 | J) Windows are shut at night and during cold weather | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  | NO
 | K) Refrigerator Temperature is 37° F and freezer is 3-5°F | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  | NO
 | L) Signs are posted about turning off appliances | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 |  | NO
 | Total Energy Points
Spreadsheet: 135242d1325877250-repeated-values-conditional-formatting
Sheet: Sheet3

2011-01-20 00:00:00 | 501182 | 0-12-508 | [NAME] for 020 and 220 | 5.58
2012-01-05 00:00:00 | 5059035 | 1 618 596 265 | Bosch 10.0 x 210mm SDS-Plus Masonry | 2.62
2012-01-05 00:00:00 | 3053501 | 100mm x 4mm | Round Wire Nails - Galvanised (25kg) | 35.96
2012-01-05 00:00:00 | 5059035 | 1 618 596 265 | Bosch 10.0 x 210mm SDS-Plus Masonry | 2.62
2011-02-20 00:00:00 | 501182 | 0-12-508 | [NAME] for 020 and 220 | 6
Spreadsheet: 880583d1728396625-filter-functions-with-combobox-example-rev-1-
Sheet: Raw

Company | Month | Level | Partcipant | Training Topic | Department | Training hours | Amount | Result | Accomplish Status | Training Type | Skill Type
A | Jan | Manager | [NAME] | Excel | GA | 6 | 50 | Passed |  | External | A |  |  |  |  |  |  | Topics | Dept | Company | Month
A | Jan | Staff | [NAME] | Excel | HR | 6 | 50 | Passed |  | External | A |  |  |  |  |  |  | Excel | GA | A | Jan
A | Feb | Staff | Marlyn | Excel | HR | 6 | 50 | Passed |  | External | A | Cell link Topics | 4 |  |  |  |  | Powerpoint | HR | B | Feb
B | Feb | Manager | [NAME] | Excel | Sales | 6 | 55 | Passed |  | External | D | Cell link Dept | 6 |  |  |  |  | Power BI | Sales | C | Mar
B | Mar | Manager | [NAME] | Powerpoint | Sales | 5 | 30 | Not Passed |  | Internal | B | Cell link Company | 4 |  |  |  |  | ALL | Finance | ALL | Apr
B | Mar | Staff | Cathy | Powerpoint | Finance | 5 | 30 | Passed |  | Internal | B | Cell link month | 4 |  |  |  |  |  | Logistics |  | ALL
C | Mar | Staff | [NAME] | Power BI | Finance | 7 | 60 | Not Passed |  | External | C |  | Topics |  |  |  |  |  | ALL
C | Mar | Staff | Michelle | Powerpoint | Logistics | 5 | 50 | Passed |  | Internal | B
C | Apr | Staff | Michelle | Excel | Logistics | 6 | 60 | Passed |  | External | D
 |  |  |  |  |  |  |  |  |  |  |  |  | Dept
 | Total Employee
 | Total Accomplished Participant
 | Total Topics |  |  |  |  |  |  |  |  |  |  |  | Company
 | Total Training Hours
 | Total Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  | Total Participant accomplished
 | Dept | Jan | Feb | Mar | Apr
 | GA
 | HR
 | Sales
 | Finance
 | Logistics
 |  | Total Participant accomplished
 | Training Type | Jan | Feb | Mar | Apr
 | External
 | Internal
 |  | Total Participant accomplished
 | Status | Jan | Feb | Mar | Apr
 | Accomplish
 | Not Accomplish
 |  | Total Participant accomplished
 | Level | Jan | Feb | Mar | Apr
 | Staff
 | Manager
 |  | Total Expense
 | Dept | Jan | Feb | Mar | Apr
 | GA
 | HR
 | Sales
 | Finance
 | Logistics
 |  | Total Participant accomplished skill type C
 | Dept | Jan | Feb | Mar | Apr
 | GA
 | HR
 | Sales
 | Finance
 | Logistics
Spreadsheet: 480645d1474011596-comparing-2-workbooks-looking-for-differences-in-quatities-example1
Sheet: Sheet2

File Name | Quantity | Mass
Washer DIN  125A(    M5) | 36 | 0
Washer DIN  127B(    M5) | 36 | 0
[NAME]) | 36 | 0
Nut DIN  934(    M6 A2) | 32 | 0
[NAME](    M4x_8 ) | 26 | 0
Washer DIN  125A(    M8) | 16 | 0
Washer DIN  125A(    M6) | 16 | 0
[NAME](  M6x20) | 16 | 0.01
[NAME]912(M6x30 A2) | 16 | 0.01
[NAME](  [NAME]) | 16 | 0.01
[NAME](    M5x12) | 10 | 0
Nut DIN  934(    M8) | 8 | 0.01
[NAME]  912(M8x70 A2) | 8 | 0.03
[NAME]. 35(M10x80) | 8 | 0.06
Spreadsheet: 140036d1328603450-nested-if-statement-with-multiple-tests-0101
Sheet: Boat Details

Boat Rental
Boat Name | Website | [NAME] | # of People |  |  |  | Taxes & Fees
 |  |  | Underway | [NAME] | 4 Day | 5 Day | Sales Tax | Insurance | Fees | Fuel | 4 Day | 5 Day
The Expedition | www.lakepowell.com | Bullfrog & Wahweap | 12 | 6 | 2880 | 3600 | 0.1445 | 0 | 0 | 0 | 3296.16 | 4120.2
The Voyager | www.lakepowell.com | Bullfrog & Wahweap | 12 | 8 | 2973 | 3717 | 0.1445 | 0 | 0 | 0 | 3402.5985 | 4254.1065
The Voyager XL | www.lakepowell.com | Bullfrog | 12 | 10 | 3223 | 4029 | 0.1445 | 0 | 0 | 0 | 3688.7235 | 4611.1905
The Adventurer | www.lakepowell.com | Bullfrog & Wahweap | 12 | 12 | 4133 | 5167 | 0.1445 | 0 | 0 | 0 | 4730.2185 | 5913.6315
The Navigator* | www.lakepowell.com | Wahweap | 12 | 14 | 4127 | 5158 | 0.1445 | 0 | 0 | 0 | 4723.3515 | 5903.331
The Discovery* | www.lakepowell.com | Bullfrog & Wahweap | 12 | 16 | 5267 | 6583 | 0.1445 | 0 | 0 | 0 | 6028.0815 | 7534.2435
*Will require additional boat to carry anyone over the 12 mark.
Spreadsheet: 827540d1682807737-xlookup-return-value-if-it-is-in-a-list-of-ranges-trip-example-copy
Sheet: Sheet2

 | First Trip | Date | [NAME]. | Last Trip | Date |  | Trip # | [NAME]'s test
Oshkosh | 89 | 1997-08-07 00:00:00 | Plane | 98 | 1997-08-08 00:00:00 |  | 276
Ripon | 201 | 1998-08-13 00:00:00 | Train | 210 | 1998-08-15 00:00:00 |  | 255
Green Bay | 275 | 1999-08-12 00:00:00 | Automobile | 279 | 1999-08-14 00:00:00 |  | 205
Plover | 1030 | 2004-08-12 00:00:00 | Plane | 1042 | 2004-08-14 00:00:00 |  | 1406
Waupaca | 1401 | 2005-08-11 00:00:00 | Train | 1407 | 2005-08-12 00:00:00 |  | 102
Milwaukee | 1722 | 2006-07-24 00:00:00 | Automobile | 1729 | 2006-07-29 00:00:00 |  | 1035
 |  |  |  |  |  |  | 1500
 |  |  |  |  |  |  | 1725
 |  |  |  |  |  |  | 1501
 |  |  |  |  |  |  | 75
 |  |  |  |  |  |  | 250
 |  |  |  |  |  |  | 1036
 |  |  |  |  |  |  | 91
 |  |  |  |  |  |  | 1201
 |  |  |  |  |  |  | 76
 |  |  |  |  |  |  | 900
 |  |  |  |  |  |  | 1405
 |  |  |  |  |  |  | 1726
 |  |  |  |  |  |  | 901
 |  |  |  |  |  |  | 101
 |  |  |  |  |  |  | 277
 |  |  |  |  |  |  | 92
 |  |  |  |  |  |  | 206
 |  |  |  |  |  |  | 1202
Spreadsheet: 785740d1656668484-i-want-to-return-multiple-values-against-a-series-of-values-sample-for-forum
Sheet: Returned Values

Identification Digit | Lender | Lender | Lender | Lender
1 | BBC | ABC | CBC
2 | ABC
3 | BBC | CBC | DBC | ABC
4 | DEF | ABC
5 | MNO | JKL | GHI
6 | PQR
7 | STU
Spreadsheet: 762241d1641468050-left-function-and-numbers-sample
Sheet: Sheet1

 |  | Test for > 0 | Test for <= 360 | Combined testing for [NAME] and 360
240 |  |  |  |  | ------> | Works as expected
280 |  |  |  |  | ------> | Works as expected
310 |  |  |  |  | ------> | Works as expected
360 |  |  |  |  | ------> | Works as expected
365 |  |  |  |  | ------> | Works as expected
240/40 |  |  |  |  | ------> | Not getting expected result for testing between 1 and 360
280/40 |  |  |  |  | ------> | Not getting expected result for testing between 1 and 360
310/40 |  |  |  |  | ------> | Not getting expected result for testing between 1 and 360
360/40 |  |  |  |  | ------> | Not getting expected result for testing between 1 and 360
365/40 |  |  |  |  | ------> | Not getting expected result for testing between 1 and 360
 |  |  | Why is this column always returning false!
Spreadsheet: 203031d1356890762-7-day-work-schedule-help-schedexp
Sheet: Sheet3

2012-12-05 00:00:00
Spreadsheet: 153894d1336087592-problem-with-chart-where-horizongal-axis-is-a-time-series-marketshare
Sheet: Should be like this

Hour 1 | 0.23
Hour 2 | 0.17
Hour 3 | 0.11
Hour 4 | 0.22
Hour 5 | 0.13
Hour 6 | 0.19
Hour 7 | 0.07
Hour 8 | 0.07
Hour 9 | 0.12
Hour 10 | 0.34
Hour 11 | 34.69
Hour 12 | 0.13
Hour 13 | 11.42
Hour 14 | 105.32
Hour 15 | 368.91
Hour 16 | 580.85
Hour 17 | 416.35
Hour 18 | 335.97
Hour 19 | 288.48
Hour 20 | 18.82
Hour 21 | 209.5
Hour 22 | 84.51
Hour 23 | 66.75
Hour 24 | 33.21
Hour 25 | 29.63
Hour 26 | 21.52
Hour 27 | 2.55
Hour 28 | 0.03
Hour 29 | 0.03
Hour 30 | 0.03
Hour 31 | 0.02
Hour 32 | 7.63
Hour 33 | 3.27
Hour 34 | 1.06
Hour 35 | 0.84
Hour 36 | 14.7
Hour 37 | 2.72
Hour 38 | 7.31
Hour 39 | 3.63
Hour 40 | 21.45
Hour 41 | 14.05
Hour 42 | 1.6
Hour 43 | 31.57
Hour 44 | 20.16
Hour 45 | 66.54
Hour 46 | 20.76
Hour 47 | 8.31
Hour 48 | 31.65
Hour 49 | 51.27
Hour 50 | 24.13
Hour 51 | 0.06
Hour 52 | 0.12
Hour 53 | 0.05
Hour 54 | 0.06
Hour 55 | 0.12
Hour 56 | 9.22
Hour 57 | 4.76
Hour 58 | 3.87
Hour 59 | 9.09
Hour 60 | 2.95
Hour 61 | 0.43
Hour 62 | 2
Hour 63 | 5.59
Hour 64 | 7.4
Hour 65 | 77.79
Hour 66 | 2.85
Hour 67 | 14.72
Hour 68 | 226.71
Hour 69 | 161.35
Hour 70 | 13.23
Hour 71 | 18.05
Hour 72 | 20.24
Hour 73 | 67.89
Hour 74 | 0.4
Hour 75 | 0.11
Hour 76 | 0.08
Hour 77 | 0.04
Hour 78 | 0.22
Hour 79 | 0.08
Hour 80 | 11.88
Hour 81 | 8.26
Hour 82 | 16.96
Hour 83 | 2.79
Hour 84 | 0.24
Hour 85 | 11.04
Hour 86 | 7.64
Hour 87 | 23.6
Hour 88 | 64.35
Hour 89 | 400.21
Hour 90 | 95.3
Hour 91 | 52.34
Hour 92 | 68.15
Hour 93 | 58.08
Hour 94 | 97.58
Hour 95 | 48.65
Hour 96 | 33.85
Hour 97 | 44.49
Hour 98 | 0.11
Hour 99 | 0.05
Hour 100 | 0.08
Hour 101 | 0.04
Hour 102 | 0.04
Hour 103 | 0.13
Hour 104 | 0.25
Hour 105 | 0.59
Hour 106 | 3.55
Hour 107 | 0.06
Hour 108 | 0.03
Hour 109 | 16.25
Hour 110 | 15.68
Hour 111 | 5.55
Hour 112 | 8.13
Hour 113 | 37.1
Hour 114 | 12.31
Hour 115 | 24.79
Hour 116 | 56.72
Hour 117 | 71.42
Hour 118 | 47.74
Hour 119 | 76.88
Hour 120 | 19.56
Hour 121 | 23.25
Hour 122 | 0.07
Hour 123 | 0.06
Hour 124 | 0.1
Hour 125 | 0.07
Hour 126 | 0.08
Hour 127 | 0.05
Hour 128 | 6.7