tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135607d1326137316-league-table-ranking-epl-table
Sheet: Sheet1

Rank | POS | CLUB | P | W | D | L | GF | GA | [NAME] | PTS | Tie Breaker | RANK [NAME] |  | POS | CLUB | P | W | D | L | GF | GA | [NAME] | PTS
3 | 3 | Arsenal | 1 | 1 |  |  | 2 | 0 | 2 | 3 | 3.002002 | 3.002002019999999 |  | 1 | Liverpool | 1 | 1 | 0 | 0 | 5 | 0 | 5 | 3
2 | 2 | Bburn | 1 | 1 |  |  | 3 | 1 | 2 | 3 | 3.002003 | 3.002003019 |  | 2 | Bburn | 1 | 1 | 0 | 0 | 3 | 1 | 2 | 3
7 | 7 | Bol Wand | 0 |  |  |  |  |  | 0 | 0 | 0 | 1.8e-08 |  | 3 | Arsenal | 1 | 1 | 0 | 0 | 2 | 0 | 2 | 3
5 | 5 | Chelsea | 1 |  | 1 |  | 1 | 1 | 0 | 1 | 1.000001 | 1.000001017 |  | 3 | Wolves | 1 | 1 | 0 | 0 | 2 | 0 | 2 | 3
8 | 7 | Everton | 0 |  |  |  |  |  | 0 | 0 | 0 | 1.6e-08 |  | 5 | Chelsea | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1
9 | 7 | Fulham | 0 |  |  |  |  |  | 0 | 0 | 0 | 1.5e-08 |  | 5 | Man City | 1 | 0 | 1 | 0 | 1 | 1 | 0 | 1
1 | 1 | Liverpool | 1 | 1 |  |  | 5 | 0 | 5 | 3 | 3.005005 | 3.005005014 |  | 7 | Bol Wand | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
6 | 5 | Man City | 1 |  | 1 |  | 1 | 1 | 0 | 1 | 1.000001 | 1.000001013 |  | 7 | Everton | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 | 7 | Man Utd | 0 |  |  |  |  |  | 0 | 0 | 0 | 1.2e-08 |  | 7 | Fulham | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 | 7 | New Utd | 0 |  |  |  |  |  | 0 | 0 | 0 | 1.1e-08 |  | 7 | Man Utd | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 | 7 | Norw City | 0 |  |  |  |  |  | 0 | 0 | 0 | 1e-08 |  | 7 | New Utd | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 | 7 | QPR | 0 |  |  |  |  |  | 0 | 0 | 0 | 9e-09 |  | 7 | Norw City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 | 7 | Spurs | 0 |  |  |  |  |  | 0 | 0 | 0 | 8e-09 |  | 7 | QPR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 | 7 | Sto City | 0 |  |  |  |  |  | 0 | 0 | 0 | 7e-09 |  | 7 | Spurs | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
16 | 7 | Sunderland | 0 |  |  |  |  |  | 0 | 0 | 0 | 6e-09 |  | 7 | Sto City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
17 | 7 | Swa City | 0 |  |  |  |  |  | 0 | 0 | 0 | 5e-09 |  | 7 | Sunderland | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
18 | 7 | Villa | 0 |  |  |  |  |  | 0 | 0 | 0 | 4e-09 |  | 7 | Swa City | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
19 | 7 | WBA | 0 |  |  |  |  |  | 0 | 0 | 0 | 3e-09 |  | 7 | Villa | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
20 | 7 | [NAME] | 0 |  |  |  |  |  | 0 | 0 | 0 | 2e-09 |  | 7 | WBA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 3 | Wolves | 1 | 1 |  |  | 2 | 0 | 2 | 3 | 3.002002 | 3.002002001 |  | 7 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 154904d1336594418-analyse-date-frequency-cross-referencing-multiple-date-ranges-pastrentalsummarydataexamples
Sheet: Explanation

 |  | Column Name | Column Name Explanation | [NAME]
A | 1 | ID | Rental ID
B | 2 | Date | Contract Date
C | 3 | Tenant | [NAME]
D | 4 | [NAME] | Tenant Email
E | 5 | Address | Tenant Address
F | 6 | Phone | [NAME]
G | 7 | Phone2 | Tenant other Phone
H | 8 | Property | Property
I | 9 | Persons | Persons
J | 10 | DateIn | [NAME]
K | 11 | DateOut | Departure Date
L | 12 | Days | Days of stay | IF (ClientRate=0, Days=0, DateOut-DateIn)
M | 13 | ClientRate | Client Rate
N | 14 | ClientTax | Client Tax 12%
O | 15 | Security | Client Security Deposit
P | 16 | cc | Client Credit Card
Q | 17 | ccTotal | Amount to be paid with credit card | Default=TotalAmount
R | 18 | ccAmount | 5% on ccTotal | ccTotal * 5%
S | 19 | DepositDue | Deposit Due Date | IF ( ContractDate + 7 > BalanceDue ," ", IF (( DateIn - ContractDate ) > 45, ContractDate + 7," " ))
T | 20 | DepositAmount | Deposit Amount
U | 21 | BalanceDue | Balance Due Date | IF( ClientRate = 0," ", IF( ISBLANK(DateIn)," ", IF ( DateIn - ContractDate < 7, DateIn, IF( DateIn - Contract Date < 45, ContractDate + 7, IF (AND ( DateIn > DATEVALUE("12/14/2004"), DateIn < DATEVALUE("01/02/2005")), DateIn - 60, DateIn - 45)))))
V | 22 | TotalAmount | Total Amount
W | 23 | Sub | Total Amount - Security Deposit
X | 24 | Agent | Agent
Y | 25 | AgentRate | Agent Rate (Default=Client Rate)
Z | 26 | AgentTax | Agent Tax 12%
AA | 27 | AgentTaxAmount | Agent Tax Amount
AB | 28 | AgentComm | AgentComm
AC | 29 | AgentCommAmount | AgentCommAmount
AD | 30 | AgentMG | AgentMG
AE | 31 | AgentMGAmount | AgentMGAmount
AF | 32 | AgentDeposit | AgentDeposit
AG | 33 | AgentBalance | AgentBalance
AH | 34 | AgentTotal | AgentTotal
AI | 35 | Outside |  | HO kept money, commission needs to be entered in budget
AJ | 36 | OutsideRate | OutsideRate
AK | 37 | OutsideComm | OutsideComm
AL | 38 | OutsideCommAmount | OutsideCommAmount
 |  |  |  | IF(OR(H306="Alcazar",H306="Bella Vista",H306="Caribe 1",H306="Caribe 2",H306="Caribe 3",H306="Caribe 4",H306="Caribe 5",H306="Caribe 6",H306="Caribe 7",H306="Caribbean Dream",H306="Cascada",H306="ChacHa 602",H306="Estefania",H306="Foto",H306="Green 15",H306="KinBe 321",H306="Linda",H306="Mayab 01",H306="Mayab 01",H306="Mayab 02",H306="Mayab 03",H306="Mayab 12",H306="Mayab 21",H306="Mayab 22",H306="Mayab 24",H306="Mayamar A3",H306="Mayamar A5",H306="Mayamar D5",H306="Santuario",H306="Sol y Luna",H306="Soleil Maya",H306="XamanHa 7004",H306="XamanHa 7016",H306="XamanHa 7115",H306="XamanHa [NAME] 7211"),"Maid","")
Spreadsheet: 216140d1361617370-fantasy-nascar-team-point-tracker-nascar
Sheet: Nascar

Driver 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 | 31 | 32 | 33 | 34 | 35 | 36 | Total Driver Score
[NAME] | 95 | 95 | 95 | 45 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 410
[NAME] |  | 90 | 100 | 65 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 315
[NAME] | 55 |  | 80 | 90 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 265
A.J [NAME] |  |  | 110 | 40 | 110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 260
[NAME] |  |  | 90 | 50 | 75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 215
[NAME] |  | 80 | 85 |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 265
[NAME] |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70
[NAME] |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
In/Out Pole | 10 | 10 | 30 | 20 | 10
Bonus Points |  |  | 25 | 25 | 100
Totals | 160 | 275 | 685 | 335 | 610 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Grand Total | 160 | 435 | 1120 | 1455 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065 | 2065
Team Ranking | 72 | 73 | 45 | 36
Finished | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th
Points | 110 | 100 | 95 | 90 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40 | 35
 | 110 | 100 | 95 | 90 | 85 | 80 | 75 | 70 | 65 | 60 | 55 | 50 | 45 | 40 | 35
8 Drivers | 250 |  | 7 Drivers | 100 |  | 6 Drivers | 50 |  | 5 Drivers | 25
 |  | 1
Spreadsheet: 697025d1601110864-sum-data-but-separate-the-positive-and-negative-balance-sample1
Sheet: Sheet1

USER | Value
A | 1
B | -1 |  | Table 1 details entry for Deposit and [NAME]
C | 2
D | -2 |  | Needed a formula that works out the total owe and total deposit
E | 3 |  | [NAME]
F | -3 |  | So it would be |  |  | Then | wk9128
G | 4 |  | A |  |  | Holding |  |  | Hoping a formula to achive this value without step 2
A | -4 |  | B |  |  | Lending |  |  | Hoping a formula to achive this value without step 2
B | 3 |  | C
C | 7 |  | D
D | -5 |  | E
E | 4 |  | F
F | 2 |  | G
G | 5
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: Table of Contents

CFTC Swaps Report
2013-01-23 00:00:00
Table of Contents
All Swaps
1. Gross Notional Outstanding by Cleared Status
2. Gross Notional Outstanding by Participant Type
3. Net Notional Outstanding by Cleared Status
4. Net Notional Outstanding by Participant Type
5. Transaction Ticket Volume by Cleared Status
6. Transaction Ticket Volume by Participant Type
7. Transaction Dollar Volume by Cleared Status
8. Transaction Dollar Volume by Participant Type
Swaps by Asset Class
Interest Rate Swaps
9a. Gross Notional Outstanding -  Product Type and Cleared Status
9b. Gross Notional Outstanding - Cleared - Supermajor Currency
9c. Gross Notional Outstanding - Cleared - Major Currency
9d. Gross Notional Outstanding - Cleared - Tenor
10a. Net Notional Outstanding - Product Type and Cleared Status
10b. Net Notional Outstanding - Cleared - Supermajor Currency
10c. Net Notional Outstanding - Cleared - Major Currency
10d. Net Notional Outstanding - Cleared - Tenor
11a. Transaction Ticket Volume - Product Type and Cleared Status
11b. Transaction Ticket Volume - Cleared - Supermajor Currency
11c. Transaction Ticket Volume - Cleared - Major Currency
11d. Transaction Ticket Volume - Cleared - Tenor
12a. Transaction Dollar Volume - Product Type and Cleared Status
12b. Transaction Dollar Volume - Cleared - Supermajor Currency
12c. Transaction Dollar Volume - Cleared - Major Currency
12d. Transaction Dollar Volume - Cleared - Tenor
Credit Default Swaps
13a. Gross Notional Outstanding - Product and Participant Type
13b. Gross Notional Outstanding - Product Type and Grade
14a. Net Notional Outstanding - Product and Participant Type
14b. Net Notional Outstanding - Product Type and Grade
15a. Transaction Ticket Volume - Product and Participant Type
15b. Transaction Ticket Volume - Product Type and Grade
16a. Transaction Dollar Volume - Product and Participant Type
16b. Transaction Dollar Volume - Product Type and Grade
Equity Swaps
17. Gross Notional Outstanding
18. Net Notional Outstanding
19. Transaction Ticket Volume
20. Transaction Dollar Volume
Other Commodity Swaps
21. Gross Notional Outstanding
22. Net Notional Outstanding
23. Transaction Ticket Volume
24. Transaction Dollar Volume
Spreadsheet: 727000d1617643998-extract-talk-time-to-mobile-phones-mobile-call-analysis-and-report
Sheet: Call Report

Caller Number | Extension | Total Talk Time to Mobile Numbers
200 | Reception (RIK)
201 | Reception (KGN)
202 | Attendance Officer
204 | SMS Adminstrator (STJ)
206 | Accounts Manager (DAT)
207 | Payroll Manager (RUY)
209 | The Hub
211 | Nurse (HAN)
212 | Counsellor (BMO)
216 | Boardroom
217 | SLT Room
218 | Reception Room
219 | HOH 1
220 | HOH 2
221 | HOH3/Tui Room
222 | [NAME] (KIN)
240 | Groundsman (HIK)
249 | SLT Cordless
250 | [NAME]'s PA (HFT)
251 | [NAME])
252 | Deputy [NAME] (THP)
253 | Deputy [NAME] (MGY)
254 | Deputy [NAME] (AUS)
257 | Visual Art
261 | ESOL
263 | Food Technology
265 | Wharenui
267 | Māori Student Mentor (HWR)
269 | Music
270 | Property Manager (ROF)
271 | Performing Arts
274 | Gymnasium
275 | Science
276 | SEU1
277 | Library
280 | ICT (RUJ)
281 | ICT (DEV)
282 | SEU (SUA)
283 | Technology
285 | SLC 1
289 | Social Science
290 | Science
291 | Mathematics
292 | English
293 | Career Education 1
294 | Career Education 2
295 | SLC 2
296 | International Student Manager ([NAME])
299 | Absentees
310 | Career Education Reception (MLT)
315 | Gateway (HAS)
316 | Career LOL (BUR)
326 | [NAME] (EDS)
340 | Languages
350 | International Student Director (FCA)
361 | Horticulture/Agriculture
470 | Sports Co-ordinator (HOB)
2102093500 | [NAME] (EDS)
2102061500 | Groundsman (HIK)
210375500 | Gateway (HAS)
210384500 | Deputy [NAME] (MGY)
210574500 | ICT (DEV)
212764500 | [NAME] (KIN)
21743500 | International Student Manager ([NAME])
21874500 | Property Manager (ROF)
21930500 | International Student Director (FCA)
275226500 | Sports Co-ordinator (HOB)
275331500 | ICT (RUJ)
275739500 | Deputy [NAME] (THP)
275739500 | Deputy [NAME] (AUS)
276015500 | Counsellor (BMO)
21837500 | Principal (LDL)
Spreadsheet: 709074d1608145634-extract-the-number-from-the-left-cell-to-matching-word-sample1
Sheet: Test

 | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name | Number | Name
 | 100000 | BAT-Bulk | 100 | ABC | 120000 | CAT | 400 | ABC | 103000 | BAT-Bulk | 50 | ABC | 100400 | BAT-Bulk | 200 | ABC | 100600 | RAT-Bulk | 100 | ABC
Question | Extract the number from the left cell to matching word '[NAME]'
 | 100000 | 103000 | 100400
Spreadsheet: 736977d1623998382-solved-find-most-recent-valid-cell-and-return-its-value-example2
Sheet: Grades 3 & 4

Date | Unit No. | No. Lessons | Unit Title | Pages | Notes
2021-04-22 00:00:00 |  |  | Introduction
2021-04-29 00:00:00 |  |  |  |  | Cancelled
2021-05-06 00:00:00 |  |  | Hello! | 2-3
2021-05-13 00:00:00
2021-05-20 00:00:00 |  |  | Hello! | 4-5
2021-05-27 00:00:00 |  |  | How are you? | 6-7
2021-06-03 00:00:00 |  |  | How are you? | 8-9
2021-06-10 00:00:00 |  |  | How many? | 10-11
2021-06-17 00:00:00 |  |  | How many? | 11-12
2021-06-24 00:00:00 |  |  | How many? | 12-13
2021-07-01 00:00:00 |  |  | How many? | 14-15
2021-07-08 00:00:00 |  |  | I like blue. | 15-16
2021-07-15 00:00:00 |  |  | I like blue. | 16-17
2021-09-02 00:00:00 |  |  | I like blue. | 18-19
2021-09-09 00:00:00 |  |  | I like blue. | 18-19
2021-09-16 00:00:00 |  |  | I like blue. | 20-21
2021-09-23 00:00:00 |  |  |  |  | Cancelled
2021-09-30 00:00:00 |  |  | What do you like? | 20-21
2021-10-07 00:00:00 |  |  | What do you like? | 22-23
Spreadsheet: 677287d1589288585-summing-according-to-text-summing-according-to-text
Sheet: Sheet1

Source Data |  |  | Required Results
AAA | 100 |  | AAA
BBB | 200 |  | BBB
CCC | 300 |  | CCC
DDD | 400 |  | DDD
 |  |  | Total
Spreadsheet: d0bc46ac-79aa-4507-8b2e-4ec19c483106
Sheet: 훈제연어다이꽁마끼

STANDARD RECIPECARD
메뉴명 : 훈제연어산마 다이꽁마끼  기미스
사진
재        료 | 식재료 | 수량 | 비고 | 식재료 | 수량 | 비고
 | 훈제연어 | 40 | g
 | 무우 | 40 | g
 | 재렴 | 10 | g
 | 산마 | 40 | g
 | 당근 | 40 | g
 | 계란 | 2 | 개
 | 환만식초 | 20 | cc
 | [NAME] | 20 | g
조  리  방  법 | 1
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: Detroit

Red Wings
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | [NAME] | L | 32 | 188 | 65 | 65 | 65 | 65 | 65 | 25 | 25 | 25 | 65 | 55 | 65 | 65
G | [NAME] | L | 37 | 188 | 55 | 55 | 45 | 45 | 45 | 25 | 25 | 25 | 55 | 45 | 45 | 55
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | [NAME] | R | 19 | 188 | 100 | 85 | 100 | 65 | 65 | 35 | 85 | 85 | 100 | 35 | 85 | 45
C | [NAME] | L | 91 | 196 | 85 | 65 | 65 | 65 | 65 | 55 | 85 | 65 | 65 | 35 | 85 | 55
C | [NAME] | R | 23 | 196 | 55 | 55 | 55 | 55 | 45 | 45 | 55 | 45 | 65 | 25 | 45 | 35
C | [NAME] | L | 55 | 228 | 55 | 55 | 55 | 65 | 55 | 35 | 45 | 65 | 55 | 35 | 45 | 65
C | [NAME] | R | 15 | 172 | 55 | 55 | 55 | 45 | 45 | 45 | 45 | 65 | 45 | 85 | 45 | 45
C | [NAME] | L | 13 | 180 | 65 | 55 | 45 | 45 | 55 | 35 | 55 | 55 | 55 | 85 | 55 | 55
LW | [NAME] | L | 21 | 196 | 65 | 65 | 65 | 65 | 55 | 45 | 65 | 65 | 55 | 55 | 65 | 45
LW | Dallas Drake | L | 28 | 172 | 65 | 65 | 55 | 65 | 55 | 45 | 55 | 55 | 65 | 35 | 55 | 55
LW | [NAME] | L | 25 | 212 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 65 | 45 | 35 | 55 | 25
LW | [NAME] | L | 11 | 188 | 45 | 45 | 55 | 55 | 45 | 65 | 45 | 45 | 55 | 35 | 45 | 55
LW | [NAME] | L | 17 | 188 | 45 | 45 | 55 | 55 | 55 | 65 | 55 | 55 | 55 | 35 | 55 | 65
RW | [NAME] | R | 22 | 180 | 85 | 65 | 65 | 45 | 85 | 45 | 85 | 85 | 65 | 35 | 65 | 55
RW | [NAME] | R | 26 | 188 | 45 | 45 | 65 | 55 | 55 | 55 | 55 | 65 | 55 | 45 | 45 | 45
RW | [NAME] | L | 24 | 228 | 65 | 55 | 55 | 55 | 55 | 65 | 45 | 45 | 65 | 45 | 55 | 85
RW | [NAME] | R | 14 | 196 | 45 | 45 | 45 | 35 | 45 | 55 | 45 | 45 | 35 | 65 | 45 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 3 | 212 | 65 | 55 | 65 | 65 | 65 | 55 | 65 | 35 | 65 | 45 | 55 | 65
D | [NAME] | L | 33 | 188 | 55 | 55 | 55 | 65 | 65 | 55 | 55 | 35 | 65 | 45 | 55 | 55
D | Nicklas Lidstrom | L | 5 | 180 | 65 | 55 | 55 | 65 | 65 | 55 | 65 | 35 | 65 | 45 | 65 | 35
D | [NAME] | L | 4 | 188 | 55 | 55 | 55 | 65 | 55 | 55 | 55 | 35 | 55 | 25 | 55 | 35
D | [NAME] | L | 2 | 204 | 55 | 45 | 45 | 65 | 45 | 65 | 35 | 25 | 55 | 35 | 55 | 55
D | [NAME] | L | 77 | 212 | 100 | 85 | 65 | 55 | 65 | 45 | 100 | 35 | 85 | 35 | 85 | 55
D | [NAME] | L | 8 | 204 | 55 | 55 | 45 | 55 | 45 | 65 | 45 | 35 | 55 | 45 | 55 | 55
D | [NAME] | R | 16 | 188 | 55 | 55 | 45 | 65 | 55 | 65 | 55 | 35 | 65 | 45 | 55 | 55
Spreadsheet: 155098d1336668321-change-values-based-on-value-in-combo-box-testrun-spreadsheet
Sheet: Query

COLOR | NUMBER | LETTER
white | 1 | a
black | 2 | b |  | number:
grey | 3 | c |  | letter:
yellow | 4 | d
 |  |  | color: | grey
Spreadsheet: richard_sanders__31687__Shanghai Volume Dispute
Sheet: Sheet1

Month | SEC [NAME] | Value | [NAME] | [NAME] | Price | Value | Date Billed | Due Date | Payments Made | Date Paid
May | 2900 | 12093.12 | 3974 | 4062 | 4.08 | 16572.96 | 2000-09-22 00:00:00 | 2000-10-02 00:00:00 | 12093.12 | 2000-10-16 00:00:00
June | 3610 | 19865.32 | 4520 | 4624 | 5.38 | 24877.12 | 2000-09-22 00:00:00 | 2000-10-02 00:00:00
July | 4067 | 22380.13 | 3883 | 3974 | 5.38 | 21380.12 | 2000-09-22 00:00:00 | 2000-10-02 00:00:00
August | 2715 | 13067.64 | 8315 | 8504 | 4.86 | 41329.44 | 2000-09-22 00:00:00 | 2000-10-02 00:00:00
September | 3652 | 21067.64 | 6443 | 6587 | 5.64 | 37150.68 | 2000-10-13 00:00:00 | 2000-10-23 00:00:00 | 21067.64 | 2000-10-31 00:00:00
October | ? |  |  | 296 | 6.3 | 1864.8
Random Payment |  |  |  |  |  |  |  |  | 3202.61 | 2000-11-20 00:00:00
 |  |  |  |  |  |  |  | Amount Due  (Value - Payments Made)
Spreadsheet: 6deec353-9aee-4727-8f37-2145a11f87c3
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
FPRK4 | Test | FPRK4 | Pork IgG4 | Pork IgG4 | Enzyme immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Draw blood in a plain, red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <0.15 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG4 tests has not been clearly established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food related complaints, and to evaluate food allergic patients prior to food challenges. The presence of food-specific IgG4 alone cannot be taken as evidence of food allergy and only indicated immunologic sensitization to the food allergen in question.    Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr.  			Lee's Summit, MO 64086 | Monday, Wednesday, Friday | 2 - 3 days | 4 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FPRK4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FPRK4 | Result | FPRK4 | Pork IgG4 | Pork IgG4 | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 678393d1589866162-matching-values-in-two-columns-clearing-eftpos-transactions
Sheet: Clearing - Eftpos Transact

Clearing - Eftpos Transactions
Date | Type | Transaction | Reference | Debit | Credit
2019-06-30 00:00:00 |  | Opening Balance |  | 972.4
2019-07-01 00:00:00 | INV | Daily totals - '-' | INV-0286 | 4215.5
2019-07-01 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1132
2019-07-02 00:00:00 | INV | Daily totals - '-' | INV-0287 | 3178.2
2019-07-02 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 4215.5
2019-07-03 00:00:00 | INV | Daily totals - '-' | INV-0288 | 1457.6
2019-07-03 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 3178.2
2019-07-04 00:00:00 | INV | Daily totals - '-' | INV-0289 | 2073.2
2019-07-04 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1457.6
2019-07-05 00:00:00 | INV | Daily totals - '-' | INV-0290 | 1611.6
2019-07-05 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 2073.2
2019-07-08 00:00:00 | INV | Daily totals - '-' | INV-0291 | 1892.5
2019-07-08 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1611.6
2019-07-09 00:00:00 | INV | Daily totals - '-' | INV-0292 | 1426
2019-07-09 00:00:00 | PAY | EFTPOS - EFTPOS | MERCHANT [NAME] |  | 1892.5
Total |  |  |  | 15854.6 | 15560.6
 |  | Closing Balance |  | 2910.15
Spreadsheet: 680142d1590804236-calculating-corrected-time-based-on-time-zone-timezone-r1-
Sheet: Example

Incident # | Date & Time Reported Pacific | Time Zone | Corrected Date/Time | forum  solution |  |  |  |  |  | 0
1 | 2020-05-26 13:00:00 | West | 2020-05-27 13:00:00
2 | 2020-05-27 15:00:00 | Central | 2020-05-28 17:00:00
3 | 2020-05-28 16:00:00 | East | 2020-05-29 19:00:00
 |  |  |  |  |  |  |  |  |  | named cells:  1 hour =1/24 day
 |  |  |  |  |  |  |  |  | How do we calculate corrected time in the highlighted column based on time zone in column C and Date & Time in Column B?
Spreadsheet: 819161d1677255038-generate-table-from-table-with-random-in-mind-test
Sheet: Sheet1

Article | Amount |  | Document | A | B | C | D | E
A | 20 |  | 1
B | 30 |  | 2
C | 25 |  | 3
D | 15 |  | 4
E | 10 |  | 5
Spreadsheet: 189440d1351190037-need-to-know-where-to-begin-in-creating-a-nutritional-spreadsheet-ingredients_example
Sheet: ingredients

ingredient name | fat | protein | carbs | energy
dog meat (100 grams) | 30 | 40 | 50 | 800
grass (150 pieces) | 5 | 10 | 7 | 100
sugar (100 grams) | 0 | 0 | 100 | 700
etc
etc
etc