tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 786415d1657181450-sum-only-specific-days-example
Sheet: List1

Month | 6
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |  | Desired result |  |  | 5 | 6 | 7
x | 8 | X | X | 8 | X | 8 | 8 |  | 19 |  | 1 | 4 | 7 | 1
 |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 8 | 1
 |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 7 | 6
 |  |  |  |  |  |  |  |  |  |  | 4 | 5 | 4 | 8
 |  |  |  |  |  |  |  |  |  |  | 5 | 1 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  | 6 | 8 | 7 | 1
 |  |  |  |  |  |  |  |  |  |  | 7 | 6 | 3 | 8
Spreadsheet: 774946d1648734550-help-with-sorting-alphabetically-by-row-and-keeping-data-on-other-tabs-saddle-creek-daily-attendance
Sheet: 4th Q

[NAME], 4th Quarter
 |  |  |  |  |  |  |  |  |  | CONFIDENTIAL
Employee Name | Worked Shifts | Excused | Late | Early Out | Call Out | Sick | NCNS | 10/1 | 10/2 | 10/3 | 10/4 | 10/5 | 10/6 | 10/7 | 10/8 | 10/9 | 10/10 | 10/11 | 10/12 | 10/13 | 10/14 | 10/15 | 10/16 | 10/17 | 10/18 | 10/19 | 10/20 | 10/21 | 10/22 | 10/23 | 10/24 | 10/25 | 10/26 | 10/27 | 10/28 | 10/29 | 10/30 | 10/31 | 11/1 | 11/2 | 11/3 | 11/4 | 11/5 | 11/6 | 11/7 | 11/8 | 11/9 | 11/10 | 11/11 | 11/12 | 11/13 | 11/14 | 11/15 | 11/16 | 11/17 | 11/18 | 11/19 | 11/20 | 11/21 | 11/22 | 11/23 | 11/24 | 11/25 | 11/26 | 11/27 | 11/28 | 11/29 | 11/30 | 12/1 | 12/2 | 12/3 | 12/4 | 12/5 | 12/6 | 12/7 | 12/8 | 12/9 | 12/10 | 12/11 | 12/12 | 12/13 | 12/14 | 12/15 | 12/16 | 12/17 | 12/18 | 12/19 | 12/20 | 12/21 | 12/22 | 12/23 | 12/24 | 12/25 | 12/26 | 12/27 | 12/28 | 12/29 | 12/30 | 12/31
Spreadsheet: 683219d1592562909-vlookup-display-multiple-matches-rows-of-results-wip-lookup
Sheet: Search by WIP

Enter WIP Number Here | 55057
WIP NO | SERVICE ADVISOR | TECH | ACCOUNT | TYPE CODE | ALLOWED | TAKEN | RATE | EXT PRICE | INV NO | DATE INV | RTS CODE | SERV CODE | SALETYPE
55057 | 7 | 1 | z2208 | A | 1 | 1 | 68.66 | 68.66 | 8213075 | 2020-06-11 00:00:00 | AIRCON | MOT | E
55057 | 7 | 1 | z2208 | A | 0.5 | 0.5 | 82.03 | 41.02 | 8213075 | 2020-06-11 00:00:00 | PBFC | MOT | E
55057 | 7 | 1 | z2208 | J | 1 | 1 | 45 | 45 | 8213075 | 2020-06-11 00:00:00 | PMOT | MOT | E
55057 | 7 | 1 | z8808 | G | 2 | 2 | 52.2 | 104.4 | 8213072 | 2020-06-11 00:00:00 | PS3 | S01 | E
Spreadsheet: 185786d1349836572-sorting-non-empty-cells-to-bottom-schedule-example
Sheet: 5

2200-0000 |  |  | 0000-0200 |  |  | 0200-0400 |  |  | 0400-0600 |  |  | WEDNESDAY
CHAD |  |  | CHAD |  |  | [NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] |  |  | STEPHANIE |  |  | STEPHANIE
STEPHANIE |  |  | STEPHANIE |  |  | TERI |  |  | TERI
ANGELA H |  |  | ANGELA H
BRANDY |  |  | BRANDY
TERI |  |  | TERI
NICOLE |  |  | NICOLE
0600-0800 |  |  | 0800-1000 |  |  | 1000-1200 |  |  | 1200-1400
 |  |  | VAL
VAL |  |  | [NAME] |  |  | VAL |  |  | VAL
[NAME] |  |  | CHERYL |  |  | JESSICA |  |  | JESSICA
CHERYL |  |  | RHONDA |  |  | [NAME] |  |  | [NAME]
RHONDA |  |  | CINDY |  |  | CHERYL |  |  | CHERYL
TERI |  |  |  |  |  | RHONDA |  |  | RHONDA
CINDY |  |  |  |  |  | CINDY |  |  | CINDY
 |  |  |  |  |  | LACY |  |  | LACY
 |  |  |  |  |  |  |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY
1400-1600 |  |  | 1600-1800 |  |  | 1800-2000 |  |  | 2000-2200
 |  |  |  |  |  |  |  |  | CHAD
VAL |  |  | CHAD |  |  | CHAD |  |  | CHRISTY
[NAME] |  |  | JESSICA |  |  | JESSICA |  |  | [NAME]
CHERYL |  |  | ANGELA H |  |  | ANGELA H |  |  | STEPHANIE
RHONDA |  |  | BRANDY |  |  | BRANDY |  |  | ANGELA H
CINDY |  |  | LACY |  |  | LACY |  |  | BRANDY
LACY |  |  | NICOLE |  |  | NICOLE |  |  | DEBBIE
KAY |  |  | MARK |  |  | MARK |  |  | NICOLE
 |  |  | KAY |  |  | KAY |  |  | MARK
 |  |  |  |  |  |  |  |  | KAY
Spreadsheet: darron_c_giron__8010__EMW0831a
Sheet: MEH

 | ENRON MIDWEST DESK - PHYSICAL |  |  |  |  |  |  |  | [NAME] | $ | Volume | Variance Impact
 |  |  |  |  |  |  |  |  | West to West:
 |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
 | THIRD PARTY SALES |  | TOTAL $'s | MMBTU | WASP |  |  | THIRD PARTY PURCHASES |  | TOTAL $'s | MMBTU | WACOG
1 | Sales |  | 2361181 | 521017 |  |  | 6 | Purchases |  | 460042 | 105406
 | AFFILIATE & |  |  | TOTAL |  |  |  | AFFILIATE & |  |  | TOTAL
 | INTERDESK SALES |  | TOTAL $'s | MMBTU | AVG PRICE |  |  | INTERDESK PURCHASES |  | TOTAL $'s | MMBTU | AVG PRICE
3 | BUG Desk |  |  |  |  |  | 8 | BUG Desk
3 | Central |  | 144760 | 34944 |  |  | 8 | Central |  | 1636384 | 373239
3 | ECT |  |  |  |  |  | 8 | ECT
3 | SITHE |  |  |  |  |  | 8 | SITHE
1 | HPLR-Texas Desk |  |  |  |  |  | 6 | HPLR-Texas Desk
1 | LGM-LRC |  |  |  |  |  | 6 | LGM-LRC
3 | Market East |  |  |  |  |  | 8 | Northeast
3 | Northeast |  |  |  |  |  | 16 | CPR Pipeline Exchange
16 | CPR Pipeline Exchange |  |  |  |  |  | 18
17 | Storage Desk |  |  |  |  |  | 8 | Texas-ECT
3 | Texas-ECT |  |  |  |  |  | 15 | CPR Cash Out
14 | CPR Cash Out |  |  |  |  |  |  | CPR Fuels
10 | CPR Fuels |  |  |  |  |  | 13 | CPR Imbalance
13 | CPR Imbalance |  |  |  |  |  | 6 | Ontario
3 | Ontario |  |  |  |  |  | 18 | CPR Storage
17 | CPR Storage |  |  |  |  |  |  | Transport Book
 | Transport Book |  |  |  |  |  |  | Gross Affilliate Purchases
 | [NAME] Sales |  |  |  |  |  |  | TOTAL PURCHASES
 | TOTAL SALES
 |  |  | 0 |  |  |  |  | This line is used exclusively for calculating Unaccounted For
31 | PHYSICAL MTM VALUE |  | 0 |  |  |  |  | Long Term Firm WACOG
30 | PROMPT MONTH VALUE |  | 0
31 | PHYSICAL REVERSAL |  | 0
Spreadsheet: 826352d1681955536-sum-ifs-become-value-test
Sheet: Sheet1

Financing LTV
 | Open |  |  | Financing Limit
Bank | Company | Property Value | Sinking Fund/FD | TL | OD | Trade
Public Bank - JB Branch | GSP
Public Bank
 |  |  | E4 | SUMIFS('https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!$G$4:$G$79,'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!$B$4:$B$79,A4,'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!$C$4:$C$79,$E$3,'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!$E$4:$E$79,B2)
 |  |  | F4 | 'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!G4+'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!G5
 |  |  | G4 | 'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!G6+'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!G7+'https://geshen.sharepoint.com/sites/group-reporting/Shared Documents/Financing Register/2023/[03. Mac''23 - Financing Register.xlsx]GSP'!G8
Without formula
 | Open |  |  | Financing Limit
Bank | Company | Property Value | Sinking Fund/FD | TL | OD | Trade
Public Bank - JB Branch | GSP |  |  | #[NAME]! | 1500000 | 2500000
Public Bank
Spreadsheet: 144184d1330769520-pivot-table-help-copy-of-pivot-table-help
Sheet: PIVOT

 | a SHEET 1 | a SHEET 2 | b SHEET 1 | b SHEET 2 | c SHEET 1 | c SHEET 2 | d SHEET 1 | d SHEET 2 | e SHEET 1 | e SHEET 2
1 | X | X | X | X | X | X | X | X
2 | X | X | X | X | X | X | X | X
3 | X | X | X | X |  | X
4 | X | X | X | X | X | X
5 | X | X | X | X | X | X
6 | X | X | X | X | X | X | X | X
7 | X | X |  | X
8 | X | X | X | X | X | X |  | X
9 |  | X |  | X |  | X
 | Sheet1 | sheet2 | Sheet1 | sheet2 | Sheet1 | sheet2 | Sheet1 | sheet2 | Sheet1 | sheet2
 | a | a | b | b | c | c | d | d | e | e
1
2
3
4
5
6
7
8
9
Spreadsheet: 35584d1233176106-complex-formula-if-statement-formula-helpv2
Sheet: Sheet1

 |  | Cummulative Total for the Year | Current Month Total
 | Inputs | 1200 | 600
 | Band | Lower Band Tonnage | Higher Band Tonnage
 | 1 | 0 | 499
 | 2 | 500 | 999
 | 3 | 1000 | 1499
 | 4 | 1500 | 1999
 | 4 | 2000 | >2000
 | Calculations | Results | Expected
 | Band 1 |  | 0
 | Band 2 |  | 0
 | Band 3 |  | 299
 | Band 4 |  | 301
 | Band 5 |  | 0
Spreadsheet: 37580d1235622526-complex-if-condition-complex-status
Sheet: Sheet2

[NAME] | need | status | [NAME]
iso | iso/qms | Completed | 9103
it tools | advance | Planned | P903
process trg | 0 | NA | 0
[NAME] | SOFT SKILL | NA | 0
Spreadsheet: 60106d1260630331-filter-book11
Sheet: Sheet1

 |  |  |  |  | 12
 |  |  |  |  | 13
 |  |  |  |  | 14
 |  |  |  |  | 15
 |  |  |  |  | 16
 |  |  |  |  | 17
 |  |  |  |  | 18
 |  |  |  |  |  | 012-013-014-015-016-017-018-112-113-114 115-116-117-118-122-123-124-125-126-127 128-129-133-134-135-136-137-138-139-144 145-146-147-148-149-155-156-157-158-159 166-167-168-169-177-178-179-188-189
 |  |  |  |  | 5
 |  |  |  |  | 6
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  |  | 015-016-017-018-115-116-117-118-125-126 127-128-135-136-137-138-145-146-147-148 155-156-157-158-159-166-167-168-169-177 178-179-188-189
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 8
 |  |  |  |  | 9
 |  |  |  |  | 7
 |  |  |  |  | 0
 |  |  |  |  |  | 115-116-125-126-155-156-166
Spreadsheet: 48527d1247743497-lookup-nutritional_content
Sheet: Reference_Sheet

 |  |  | Measure | Weight (g) | Protein (g) | Fat (g) | Carbs (g) | Calories
Egg (white) |  |  | 2 med | 62 | 7 | 0 |  | 32
Egg (yolk) |  |  | 2 med | 34 | 5 | 10 |  | 116
[NAME] |  |  |  | 227 | 40 | 14 |  | 286
[NAME] |  |  |  | 227 | 44 | 9 |  | 257
Rump Steak
Lean Steak Mince
[NAME] |  |  |  | 227 | 38 | 1 |  | 370
[NAME] |  |  |  | 227 | 37 | 2 |  | 298
Tuna (tinned in water) |  |  |  | 227 | 63 | 1.5 |  | 288
Wholemeal Bread |  |  |  | 23 | 3 | 0.4 | 10 | 56
Oats (cooked weight) |  |  |  | 236 | 5 | 2 | 23 | 130
[NAME] |  |  |  | 151 | 2 | 0 | 29 | 124
Pear |  |  |  | 180 | 1 | 1 | 24 | 70
Walnut |  |  |  | 100 | 21 | 60 | 1 | 628
[NAME] |  |  |  | 16 | 4 | 8 | 2 | 96
[NAME] (cooked weight) |  |  |  | 150 | 4 | 1 | 38 | 177
Broccoli (cooked weight) |  |  |  | 150 | 5 | 4 | 2 | 64
Spinach (cooked weight) |  |  |  | 100 | 3 | 0 | 3 | 24
Apple |  |  |  | 150 | 0 |  | 18 | 110
Grapefruit |  |  |  | 285 | 1 |  | 14 | 55
Pineapple |  |  |  | 140 | 1 |  | 19 | 75
Asparagus |  |  |  | 175 | 4 |  | 6 | 135
Carrots |  |  |  | 145 | 1 |  | 10 | 45
Tomato |  |  |  | 150 | 2 |  | 7 | 35
[NAME] |  |  |  | 207 | 1 |  | 7 | 30
Spreadsheet: 0b2d4855-4159-4f4a-a677-96c454fdc2b6
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
 | 5671.0 Lending Finance, Australia
 | TABLE 27. LEASE FINANCE COMMITMENTS, Summary:Australia ($000)
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
Total lease finance commitments ; |  |  | Original | A2414208C | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Seasonally Adjusted | A2414207A | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Trend | A2414206X | 1975-10-01 00:00:00 | 2012-12-01 00:00:00 | 447 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 736765d1623851828-countif-a-and-b-are-both-present-table
Sheet: Revised Table

 |  |  | [NAME] | Manager | Learning Curve Family
 |  |  |  |  |  |  |  | count number of employees who are trained in both 'I11' AND 'J11'.
 |  |  |  |  |  |  |  | Training 1 | Training 2 |  | Results
 |  |  |  |  |  |  |  | pick | mech pick
Spreadsheet: 98130c5b-3d59-40ab-abb0-028c585af7a6
Sheet: ER - Schedule 4

Kraft Foods Inc. and Subsidiaries
Reconciliation of GAAP to Non-GAAP Information
Operating Income
For the Three Months Ended March 31,
($ in millions, except percentages) ([NAME])
 |  |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) |  | Underlying (Non-GAAP)
2011
 | Operating Income |  | 1646 |  | 104 |  | 0 |  | 1750
 | Operating Income Margin |  | 0.131 |  |  |  |  |  | 0.139
2010
 | Operating Income |  | 1206 |  | 43 |  | 260 |  | 1509
 | Operating Income Margin |  | 0.107 |  |  |  |  |  | 0.133
 | (1) Integration Program costs are defined as the costs associated with combining the Kraft Foods and Cadbury businesses,
 | and are separate from those costs associated with the acquisition.
 | (2) Acquisition-related costs include transaction advisory fees, U.K. stamp taxes and the impact
 | of the Cadbury inventory revaluation.
Spreadsheet: 744758d1629443289-start-index-match-from-a-specific-cell-reference-example-list
Sheet: Sheet1

 |  |  |  |  |  |  | Given |  | Desired
 |  | Player 1 |  |  |  |  | Player 1 |  | Y |  |  |  |  | Col C consists of a list of duplicated names.
 |  | Player 2 |  |  |  |  | Player 2 |  | N |  |  |  |  | 'Y' in col E starts at a specific point in the list, when col D has a value.
 |  | Player 3 |  |  |  |  | Player 3 |  | Y |  |  |  |  | Require a formula which finds the first cell value in col D, then index/matches to give col J
 |  | Player 4 |  |  |  |  | Player 4 |  | N
 |  | Player 5 |  |  |  |  | Player 5 |  | Y
 |  | Player 2
 |  | Player 3
 |  | Player 4
 |  | Player 5
 |  | Player 1
 |  | Player 5
 |  | Player 4
 |  | Player 3
 |  | Player 2
 |  | Player 1
 |  | Player 5
 |  | Player 2
 |  | Player 3
 |  | Player 4
 |  | Player 5
 |  | Player 1
 |  | Player 5
 |  | Player 4
 |  | Player 3
 |  | Player 2
 |  | Player 1
 |  | Player 4
 |  | Player 5
 |  | Player 1 | 142 | Y
 |  | Player 2 | 154 | N
 |  | Player 3 | 160 | Y
 |  | Player 4 | 166 | N
 |  | Player 5 | 172 | Y
Spreadsheet: 96900d1296152297-formula-to-add-data-in-one-column-if-the-critera-in-2-other-columns-match-fte-calculations
Sheet: Service Activity Info

Service Activity | [NAME] | Benchmark Hours | Coverage Number | Number Expected for Year | Percent Expected to Cover | Total Hours Required for Service Activity |  |  |  | Benchmark Hours Chart
Prenatal Screening | PHN |  | 1000 | 800 |  |  |  |  |  | Activity | Benchmark Hours
Postpartum Phone Call | PHI |  | 500 | 340 |  |  |  |  |  | Prenatal Screening | 0.5
In-Depth Assessment | RN |  | 1500 | 1260 |  |  |  |  |  | Postpartum Phone Call | 0.5
Postpartum Home Visit | PHN |  | 4800 | 3540 |  |  |  |  |  | Postpartum Home Visit | 2.5
 |  |  |  |  |  |  |  |  |  | In-Depth Assessment | 3.5
 |  |  |  | Total Activity Hours
 | Total Hours by Activity |  |  | Total Hours by [NAME] |  |  |  | Total Hours for each activilty by Discipline
Spreadsheet: 128523d1321024885-working-out-a-tariff-from-a-date-and-time-peak-time_daddy
Sheet: Sheet3

Arrival/Departure date time UTC | Arrival/Departure time UTC | Handling category | Operator Name
2011-01-01 10:50:00 | 10:50:00 | Tariff C | Airline4
2011-01-01 12:13:00 | 12:13:00 | Tariff C | Airline8
2011-01-02 12:40:00 | 12:40:00 | Tariff B | Airline4
2011-01-02 14:07:00 | 14:07:00 | Tariff B | Airline3
2011-01-02 14:30:00 | 14:30:00 | Tariff C | Airline3
2011-01-02 15:40:00 | 15:40:00 | Tariff B | Airline2
2011-01-02 16:01:00 | 16:01:00 | Tariff B | Airline5
2011-01-02 16:29:00 | 16:29:00 | Tariff C | Airline5
2011-01-02 16:32:00 | 16:32:00 | Tariff C | Airline4
2011-01-02 20:28:00 | 20:28:00 | Tariff C | Airline6
2011-01-02 20:56:00 | 20:56:00 | Tariff C | Airline5
2011-01-03 12:00:00 | 12:00:00 | Tariff B | Airline5
2011-01-03 12:03:00 | 12:03:00 | Tariff B | Airline1
2011-01-03 13:17:00 | 13:17:00 | Tariff C | Airline7
2011-01-03 13:59:00 | 13:59:00 | Tariff C | Airline4
2011-01-03 15:17:00 | 15:17:00 | Tariff C | Airline7
2011-01-03 19:39:00 | 19:39:00 | Tariff B | Airline8
2011-01-03 20:04:00 | 20:04:00 | Tariff B | Airline7
2011-01-03 20:38:00 | 20:38:00 | Tariff C | Airline7
2011-01-04 10:06:00 | 10:06:00 | Tariff C | Airline5
2011-01-04 10:28:00 | 10:28:00 | Tariff B | Airline4
2011-01-04 10:39:00 | 10:39:00 | Tariff B | Airline10
2011-01-04 13:58:00 | 13:58:00 | Tariff C | Airline8
2011-01-04 14:54:00 | 14:54:00 | Tariff C | Airline10
2011-01-04 14:57:00 | 14:57:00 | Tariff C | Airline10
2011-01-04 15:24:00 | 15:24:00 | Tariff B | Airline3
2011-01-04 16:44:00 | 16:44:00 | Tariff B | Airline4
2011-01-04 20:04:00 | 20:04:00 | Tariff C | Airline7
2011-01-04 20:22:00 | 20:22:00 | Tariff C | Airline7
2011-01-05 09:31:00 | 09:31:00 | Tariff C | Airline9
2011-01-05 11:44:00 | 11:44:00 | Tariff B | Airline9
2011-01-05 14:32:00 | 14:32:00 | Tariff B | Airline9
2011-01-05 16:05:00 | 16:05:00 | Tariff C | Airline4
2011-01-05 16:40:00 | 16:40:00 | Tariff C | Airline1
2011-01-06 07:05:00 | 07:05:00 | Tariff C | Airline5
2011-01-06 09:48:00 | 09:48:00 | Tariff B | Airline2
2011-01-06 11:13:00 | 11:13:00 | Tariff B | Airline10
2011-01-06 11:33:00 | 11:33:00 | Tariff C | Airline6
2011-01-06 14:52:00 | 14:52:00 | Tariff C | Airline7
2011-01-06 14:58:00 | 14:58:00 | Tariff B | Airline3
2011-01-06 15:33:00 | 15:33:00 | Tariff B | Airline5
Spreadsheet: ae65e5c1-286f-4267-8e5c-9e67629c78d3
Sheet: Sheet1

State Auditor (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 7/25/2014 5:17:15 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
District | [NAME] | [NAME] R ([NAME]) [NAME] | TOTALS
District 01 | 1562 | 4340 | 5902
District 02 | 1760 | 4240 | 6000
District 03 | 2246 | 3381 | 5627
District 04 | 2751 | 2696 | 5447
District 05 | 2386 | 4170 | 6556
District 06 | 1951 | 4111 | 6062
District 07 | 2158 | 3759 | 5917
District 08 | 3030 | 5780 | 8810
District 09 | 3048 | 1274 | 4322
District 10 | 1948 | 3230 | 5178
District 11 | 2998 | 3158 | 6156
District 12 | 2123 | 3297 | 5420
District 13 | 3445 | 4717 | 8162
District 14 | 2166 | 4201 | 6367
District 15 | 2130 | 3094 | 5224
District 16 | 2080 | 2838 | 4918
District 17 | 2888 | 4547 | 7435
District 18 | 2558 | 2244 | 4802
District 19 | 1604 | 2991 | 4595
District 20 | 2452 | 3485 | 5937
District 21 | 2878 | 2304 | 5182
District 22 | 3338 | 5646 | 8984
District 23 | 2611 | 2920 | 5531
District 24 | 2691 | 3682 | 6373
District 25 | 2123 | 3389 | 5512
District 26 | 2524 | 3354 | 5878
District 27 | 4099 | 5241 | 9340
District 28 | 1758 | 4480 | 6238
District 29 | 1965 | 3817 | 5782
District 30 | 2656 | 4490 | 7146
District 31 | 2613 | 3680 | 6293
District 32 | 2664 | 3936 | 6600
District 33 | 2356 | 4771 | 7127
District 34 | 3114 | 3994 | 7108
District 35 | 2682 | 4584 | 7266
District 36 | 1959 | 4197 | 6156
District 37 | 2501 | 4050 | 6551
District 38 | 1861 | 3491 | 5352
District 39 | 1778 | 4945 | 6723
District 40 | 1511 | 2431 | 3942
District 41 | 2553 | 4293 | 6846
District 42 | 2683 | 2983 | 5666
District 43 | 2436 | 3163 | 5599
District 44 | 2993 | 3738 | 6731
District 45 | 2398 | 3610 | 6008
District 46 | 2931 | 4407 | 7338
District 47 | 3309 | 6748 | 10057
TOTAL | 116269 | 179897 | 296166
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 823729d1680113529-partial-transpose-data-tabel-transpose
Sheet: Sheet1

TABEL 1
Timestamp | Username | Name | Town | Person 1 | Person 1 Answer | Person 2 | Person 2 Answer
2023-03-27 00:00:00 | testing1 | [NAME] | New York | [NAME] | Yes | [NAME] | Yes
2023-03-27 00:00:00 | testing2 | [NAME] | Seattle | Adrian | No
2023-03-27 00:00:00 | testing3 | [NAME] | Los Angeles | [NAME] | Yes | Felix | No
TABEL 2
Timestamp | Username | Name | Town | Person | Answer
2023-03-27 00:00:00 | testing1 | [NAME] | New York | [NAME] | Yes
2023-03-27 00:00:00 | testing1 | [NAME] | New York | [NAME] | Yes
2023-03-27 00:00:00 | testing2 | [NAME] | Seattle | Adrian | No
2023-03-27 00:00:00 | testing3 | [NAME] | Los Angeles | [NAME] | Yes
2023-03-27 00:00:00 | testing3 | [NAME] | Los Angeles | Felix | No
Spreadsheet: 705016d1605855765-count-individual-entries-with-2-criteria-test-indiv
Sheet: test

 |  |  | F formula | G formula
B101AAA | 2019-11-20 00:00:00 | AAA |  |  | 2020-10-01 00:00:00 | 2020-01-01 00:00:00 | ILO
B102AAA | 2002-10-01 00:00:00 | BBB
B103AAA | 2020-02-03 00:00:00 | [NAME]
B104AAA | 2020-02-04 00:00:00 | XSR
B105AAA | 2020-01-02 00:00:00 | BHY
B106AAA | 2020-05-03 00:00:00 | THM
B107AAA | 2020-06-08 00:00:00 | AAA
B108AAA | 2020-01-01 00:00:00 | BBB
B109AAA | 2020-02-02 00:00:00 | CCC
B110AAA | 2020-10-09 00:00:00 | ILO
B101AAA | 2020-02-04 00:00:00 | MMM
B102AAA | 2020-01-02 00:00:00 | ILO
B103AAA | 2020-05-03 00:00:00 | SER
B104AAA | 2020-06-08 00:00:00 | CVT
B105AAA | 2020-01-01 00:00:00 | MNY
B106AAA | 2020-02-02 00:00:00 | CVT
B107AAA | 2020-02-03 00:00:00 | TTT
B108AAA | 2020-10-10 00:00:00 | BHU
B109AAA | 2020-10-12 00:00:00 | MMM
B110AAA | 2020-10-11 00:00:00 | TGY
B101AAA | 2020-10-13 00:00:00 | ILO
B102AAA | 2020-10-14 00:00:00 | XSR
B101AAA | 2020-10-15 00:00:00 | [NAME]
B104AAA | 2020-10-16 00:00:00 | XSR
B105AAA | 2020-10-17 00:00:00 | BHY
B106AAA | 2020-10-18 00:00:00 | THM
B101AAA | 2020-10-19 00:00:00 | ILO
B108AAA | 2020-10-20 00:00:00 | BBB
B109AAA | 2020-10-21 00:00:00 | CCC
B110AAA | 2020-10-22 00:00:00 | TTT
 |  |  |  |  |  |  |  | oct2020 ilo 2
Spreadsheet: 5f675d18-7489-4a7d-a2bd-dc1592a3a7bc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4758 | 9829 | Inna | [NAME] | RUS | 31 | 00:16:47 | 00:03:08 | 01:09:25 | 00:00:45 | 00:36:29 | 1 | 02:06:35
4758 | 31426 | Yelena | Seleznyova | RUS | 0 | 00:16:57 | 00:02:56 | 01:09:25 | [NAME] | 00:37:13 | 2 | 02:07:08
4758 | 9856 | Mriya | Guz | RUS | 0 | [NAME] | 00:03:08 | 01:09:21 | 00:00:41 | 00:38:37 | 3 | 02:08:36
4758 | 9853 | Natalia | [NAME] | RUS | 0 | 00:16:50 | 00:03:01 | 01:09:26 | 00:00:43 | 00:39:15 | 4 | 02:09:16
4758 | 17986 | [NAME] | Ushakova | RUS | 34 | 00:16:57 | 00:03:01 | 01:07:22 | 00:00:41 | 00:41:29 | 5 | 02:09:30
4758 | 75637 | [NAME] | Polyanskaya | RUS | 33 | 00:16:49 | 00:03:14 | 01:09:17 | 00:00:43 | 00:00:00 | DNF | 00:00:00
4758 | 6799 | Tania | Mak So Ning | HKG | 32 | 00:18:05 | [NAME] | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 79396d1279660944-how-to-deal-with-a-non-linear-calibration-curve-scratch
Sheet: Sheet1

 |  |  | [NAME] | x2 | x | b
Actual | Measured |  | 0.00733170264589861 | 0.01406761683586838 | 0.9739034348544495 | -0.008442054418780875 | << This is a single array formula
0 | 0
2 | 2 |  | Measured | Predicted
4 | 3.5 |  | 0 | -0.008442054418780875 | << These values are tabulated using the coefficients above
6 | 5 |  | 1 | 0.9868606999174356
8 | 6 |  | 2 | 2.054288903800781
10 | 7 |  | 3 | 3.237832773106645
 |  |  | 4 | 4.581482523710422
 |  |  | 5 | 6.129228371487502
 |  |  | 6 | 7.925060532313278
 |  |  | 7 | 10.01296922206314
Spreadsheet: 885846d1735724155-clarification-needed-for-excel-expert-practice-tasks-excelexpert_1-3b
Sheet: Store Inventory List

[NAME] House Store Inventory |  |  |  |  | 
TOTAL ESTIMATED VALUE OF ALL ITEMS: |  |  |  |  |  | INVENTORY DATE:
 | LOCATION: |  |  |  |  | Store Manager:
 |  |  |  |  |  | Manager's Phone:
 | ADDRESS: |  |  |  |  | Store Phone:
 |  |  |  |  |  | Emergency Contact Phone:
Item # | Category | Description | [NAME] model | Qty | Buy Date | Buy Location | Price | Current Value | Notes | Photo?
1 | Ski Gear | ASH-1002 |  | 10 |  |  | 45.78
 | Ski Apparel | ASH-1462 |  | 16 |  |  | 4.7
 | [NAME] | ASH-1744 |  | 7 |  |  | 29.98
 | Helmets | ASH-1790 |  | 6 |  |  | 156.31
 | Books & Training | ASH-2044 |  | 1 |  |  | 34.73