tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 116029d1311522312-selective-columns-handicap-template-midshires
Sheet: rd

[NAME]. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 113055d1308993743-split-rows-equally-in-columns-mi
Sheet: Sheet1

WWW.SIM-STOX.CO.UK F2 MEETING INFO CREATOR
PASTE BOOKING LIST HERE
Name | Number | Grade |  | Total drivers
BigDave | 606 | white
JayJay | 747 | white |  | No. Heats
[NAME] | D06 | white |  | Format
Kane-429 | 429 | white
sivvy632 | 632 | white |  | Heat 1 | 606 | D06 | 632 | 246 | 552 | 23 | 249 | 24 | 688
Southwell | 177 | white
Stox246 | 246 | white
ryan48 | 48 | yellow |  | Heat 2 | 747 | 429 | 177 | 48 | 12 | 979 | 62 | 277 | h84
[NAME] | H552 | yellow
craig12 | 12 | blue
Martin23 | 23 | blue
CooksterNI979 | NI979 | red
Jack-249 | 249 | red
lithgow62 | 62 | red
Rich24 | 24 | red
Southy277 | 277 | red
fordy688 | 688 | superstar
Peter84 | H84 | superstar
Spreadsheet: 789412d1659088210-tools-book-out-and-returned-summary-sheet-for-stores-available-dropdown-only
Sheet: Tools

 | Tools Stock Control Sheet |  |  |  |  |  |  |  |  | Tools Issue/Return Sheet
 | Code | Description | Category | Condition | Product Type | QTY | Unit Price | Availibility |  | Date | Code | Description | Status | Issued to/ Returned By | Condition |  | MAX(IF( | MAXIFS(
 |  |  | Tools | new | Electrical | 1 |  |  |  | 2022-07-15 00:00:00 | ID 001 |  | Issued | [NAME] | new
 |  |  |  |  |  |  |  |  |  | 2022-07-16 00:00:00 | ID 001 |  | Returned | [NAME] | new |  |  | IF(B4=0,"",IFERROR(INDEX($N$4:$N$70,MATCH(      MAXIFS($K$4:$K$70,$L$4:$L$70,B4),$K$4:$K$70,0)),"Available"))
 |  |  |  |  |  |  |  |  |  | 2022-07-17 00:00:00 | ID 001 |  | Issued | [NAME] | new
 |  |  |  |  |  |  |  |  |  | 2022-07-20 00:00:00 | ID 001 |  | Returned | [NAME] | Good |  | IF(B4=0,"",IFERROR(INDEX($N$4:$N$70,MATCH(     MAX(IF($L$4:$L$70=B4,$K$4:$K$70)),$K$4:$K$70,0)),"Available"))
 |  |  |  |  |  |  |  |  |  | 2022-07-29 00:00:00 | ID 001 |  | Issued
 |  |  |  |  |  |  |  |  |  | 2022-08-01 00:00:00 | PSD 001 |  | Issued
 |  |  |  |  |  |  |  |  |  | 2022-08-02 00:00:00 | PG 001 |  | Lost
 |  |  |  |  |  |  |  |  |  | 2022-08-03 00:00:00 | ID 001 |  | Returned
Spreadsheet: 221650d1363631930-formula-that-will-take-data-from-multiple-cells-and-put-it-into-other-cells-at-once-example-for-forum
Sheet: Sheet1

Product | Product Number | Product Status | 2011 Financials | 2012 Financials | 2013 Financials
ItemA12 | A1230 | Active | 6789.34 | 9654.32 | 10876.54
ItemB12 | B1230 | Active | 4865.23 | 5678.98 | 7654.32
ItemC12 | C1230 | Not Active | 1234.56 | 987.45 | 654.34
ItemD12 | D1230 | Not Active | 867.34 | 654.54 | 456.76
ItemE12 | E1230 | Active | 7654.34 | 8764.23 | 9876.56
Spreadsheet: 734134d1622005125-formula-to-find-unique-values-example
Sheet: Sheet1

field number | count |  |  |  | Requirement
A | 9 |  |  |  |  | How to get what is the value of this
A | 9 |  |  |  | A | 9
C | 4 |  |  |  | B | 6
A | 9 |  |  |  | C | 4
B | 6 |  |  |  | D | 3
B | 6 |  |  |  | E | 7
C | 4 |  |  |  | H | 10 | which formula can be used to get tis values?
B | 6
B | 6
D | 3
D | 3
E | 7
E | 7
E | 7
H | 10
A | 9
C | 4
D | 3
Spreadsheet: 815284d1674846006-take-the-qty-out-of-stock-vehicle-parts-pricing-3-
Sheet: #61

 |  |  | Stock Codes
Date | Veh # | [NAME] | Part # | Description | Quantity | Product Cost | Total | In [NAME]
2023-01-25 00:00:00 | #61 |  | 14C24 |  | 1 |  |  | Pansie
2023-01-25 00:00:00 | #61 |  | 14C18 |  | 1 |  |  | Pansie
 |  |  |  |  |  | Total
 |  |  |  |  |  | F
Spreadsheet: 37109d1235060074-solved-create-subset-table-dayly-weekly
Sheet: Weeklies

Date | Data 1 | Data 2 | Data 3 | Data 4
2009-01-12 00:00:00 | 10 | 1 | 2 | 10 |  | Start date Monday
2009-01-19 00:00:00 | 45 | 15 | 16 | 80 |  | 2nd Monday
2009-01-26 00:00:00 | 80 | 29 | 30 | 150 |  | 3rd Monday
2009-02-02 00:00:00 | 115 | 43 | 44 | 220 |  | 4th Monday
2009-02-09 00:00:00 | 150 | 57 | 58 | 290 |  | etc.
2009-02-16 00:00:00 | 185 | 71 | 72 | 360
2009-02-23 00:00:00 | 220 | 85 | 86 | 430
This is the type of table I would like to extract from the Daylies, |  |  |  |  |  |  |  |  |  | Calculated
just the data of the Mondays.
Daylies |  |  |  | Weeklies
A6 … G6 |  | ---> |  | A2 … G2
A13 … G13 |  |  |  | A3 … G3
A20 … G20 |  |  |  | A4 … G4
A27 … G27 |  |  |  | A5 … G5
etc. |  |  |  | etc.
Spreadsheet: 0f5d1feb-673f-48ff-af58-740d1807e773
Sheet: 1.9

Table 1.9: Population etimates by age groups, nationality, residence and sex in Saudi Arabia,  2012
 | Nationals |  | Non- Nationals |  | Urban |  | Rural |  | Total
Age group | Male | Female | Male | Female | Male | Female | Male | Female | Male | Female | Both sexes
0-4 | 1290219 | 1231306 | 343353 | 302813 |  |  |  |  | 1633572 | 1534119 | 3167691
5-9 | 1184814 | 1144678 | 328976 | 293853 |  |  |  |  | 1513790 | 1438531 | 2952321
10-14 | 1106916 | 1096559 | 293349 | 250925 |  |  |  |  | 1400265 | 1347484 | 2747749
15-19 | 1051136 | 1061359 | 221554 | 188768 |  |  |  |  | 1272690 | 1250127 | 2522817
20-24 | 971139 | 991133 | 234608 | 170771 |  |  |  |  | 1205747 | 1161904 | 2367651
25-29 | 863610 | 882549 | 543710 | 241322 |  |  |  |  | 1407320 | 1123871 | 2531191
30-34 | 753964 | 767433 | 1075634 | 380246 |  |  |  |  | 1829598 | 1147679 | 2977277
35-39 | 639047 | 643315 | 1166987 | 420329 |  |  |  |  | 1806034 | 1063644 | 2869678
40-44 | 532292 | 528691 | 924450 | 257148 |  |  |  |  | 1456742 | 785839 | 2242581
45-49 | 434203 | 421291 | 656805 | 104564 |  |  |  |  | 1091008 | 525855 | 1616863
50-54 | 344661 | 328928 | 406116 | 63143 |  |  |  |  | 750777 | 392071 | 1142848
55-59 | 257770 | 246462 | 226221 | 43773 |  |  |  |  | 483991 | 290235 | 774226
60-64 | 186814 | 181009 | 94582 | 23596 |  |  |  |  | 281396 | 204605 | 486001
65-69 | 132435 | 133762 | 34054 | 14436 |  |  |  |  | 166489 | 148198 | 314687
70-74 | 89262 | 93724 | 14997 | 8981 |  |  |  |  | 104259 | 102705 | 206964
75+ | 124115 | 123852 | 16043 | 11340 |  |  |  |  | 140158 | 135192 | 275350
Not stated | … | … | … | … | … | … | … | … | … | … | …
Total |  |  |  |  | … | … | … | …
Spreadsheet: 728729d1618591191-help-with-a-simple-formula-test-commission-snapshot
Sheet: Deal 8

 |  |  | Commission Snapshot
 | Client |  |  |  |  | Deal #
 | Date Deposit Taken |  |  |  |  | Commission Modifier
 |  |  |  |  |  |  |  | 0.045
 | Closing Volume |  | 100000 |  |  | Contingent ? |  | No
 | Deposit Amount |  | 15000
 | Warranty Amount |  | 1395 |  |  | PIF this Month |  | No
 | Total Upgrades |  | 5000 |  |  | PIF Month |  | January
 |  |  | Commissions
 |  |  |  |  |  |  |  |  | Future Commission
 |  |  | Power Bonus
 |  |  | Velocity Cash
 |  |  | Warranty Bonus
 |  |  | CV Commission |  |  |  |  |  | Commission Month
 | Total Commission
Spreadsheet: 726596d1617308374-lookup-multiple-ranges-example
Sheet: Sheet1

 | Break Type | Break Hr | 07:30:00 | 16:00:00 | Start |  | End
 |  |  | Start Time | End Time | Lower Limit (>=) | Upper Limit (<) | Lower Limit (>=) | Upper Limit (<)
 | B1 | 0.25 | 09:30:00 | 09:45:00 | 07:30:00 | 09:45:00 | 09:30:00 | 11:30:00
 | L | 0.5 | 11:30:00 | 12:00:00 | 09:45:00 | 12:00:00 | 11:30:00 | 14:00:00
 | ML | 0.75 | 09:30:00 | 11:30:00 | 07:30:00 | 09:30:00 | 11:30:00 | 14:00:00
 | B2 | 0.25 | 14:00:00 | 14:15:00 | 12:00:00 | 14:15:00 | 14:00:00 | 16:00:00
 | EL | 0.75 | 11:30:00 | 14:15:00 | 09:45:00 | 12:00:00 | 14:00:00 | 16:00:00
 | A | 1 | 09:30:00 | 14:15:00 | 07:30:00 | 09:30:00 | 14:15:00 | 16:00:00
 | B3 | 0.25 | 16:00:00 | 16:15:00 | 14:15:00 | 16:15:00 | 16:00:00 | 18:00:00
 | C | 1.25 | 09:30:00 | 16:30:00 | 07:30:00 | 09:30:00 | 16:30:00 | 18:00:00
 | *If Day total = less than 4.5 Hours then no break type
Helper Column | Punch |  | EMP ID | QTY | Date | Time | IN/OUT | Job Time | Break Type | Raw Day Time | Helper Column 2 | Last Punch Time
 | PUNCH IN |  | 001234-UR | 0 | 3/4/21 | 07:30:00 | 1 | 0 |  | 8.4 | 1
 | L515801 |  | 001234-UR | 0 | 3/4/21 | 10:15:00 | 2 | 2.75 | B1 | 8.4 | 2 | 07:30:00
 | 5-S |  | 001234-UR | 0 | 3/4/21 | 10:50:00 | 2 | 0.58 |  | 8.4 | 3 | 10:15:00
 | L515801 |  | 001234-UR | 362 | 3/4/21 | 13:56:00 | 2 | 3.1 | L | 8.4 | 4 | 10:50:00
 | 75K863 |  | 001234-UR | 800 | 3/4/21 | 15:50:00 | 2 | 1.9 | B2 | 8.4 | 5 | 13:56:00
 | 5-S |  | 001234-UR | 0 | 3/4/21 | 15:54:00 | 2 | 0.07 |  | 8.4 | 6 | 15:50:00
 | PUNCH IN |  | 002345-DR | 0 | 3/4/21 | 07:30:00 | 1 | 0 |  | 8.45 | 1
 | [NAME] |  | 002345-DR | 1050 | 3/4/21 | 15:45:00 | 2 | 8.25 | A | 8.45 | 2 | 07:30:00
 | 5-S |  | 002345-DR | 0 | 3/4/21 | 15:57:00 | 2 | 0.2 |  | 8.45 | 3 | 15:45:00
 | PUNCH IN |  | 003456-ML | 0 | 3/4/21 | 07:30:00 | 1 | 0 |  | 8.35 | 1
 | 75K863 |  | 003456-ML | 3156 | 3/4/21 | 15:51:00 | 2 | 8.35 | A | 8.35 | 2 | 07:30:00
 | PUNCH IN |  | 004567-TC | 0 | 3/4/21 | 07:30:00 | 1 | 0 |  | 8.33 | 1
 | [NAME] |  | 004567-TC | 1100 | 3/4/21 | 12:55:00 | 2 | 5.42 | ML | 8.33 | 2 | 07:30:00
 | L515801 |  | 004567-TC | 405 | 3/4/21 | 15:50:00 | 2 | 2.92 | B2 | 8.33 | 3 | 12:55:00
 | PUNCH IN |  | 005678-SA | 0 | 3/4/21 | 11:44:00 | 1 | 0 |  | 4.12 | 1
 | 75K863 |  | 005678-SA | 3000 | 3/4/21 | 15:51:00 | 2 | 4.12 |  | 4.12 | 2 | 11:44:00
 | PUNCH IN |  | 006789-HT | 0 | 3/4/21 | 07:30:00 | 1 | 0 |  | 4 | 1
 | GE0952100 |  | 006789-HT | 275 | 3/4/21 | 09:02:00 | 2 | 1.53 |  | 4 | 2 | 07:30:00
 | GR0950100 |  | 006789-HT | 500 | 3/4/21 | 10:30:00 | 2 | 1.47 |  | 4 | 3 | 09:02:00
 | GR0950000 |  | 006789-HT | 400 | 3/4/21 | 11:30:00 | 2 | 1 |  | 4 | 4 | 10:30:00
Spreadsheet: 819450d1677514998-get-the-last-18-numbers-and-highlight-or-list-down-the-difference-last-18-numbers
Sheet: Sheet1

No.
4
9
21
20
22
27
14
27
8
23
0
5
3
1
18
9
33
10
28 |  |  | 10 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 | 4 |  |  |  | 1 | 3 | 4 | 5 | 8 | 9 | 10 | 14 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
17 |  |  | 28 | 10 | 33 | 9 | 18 | 1 | 3 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 | 4 |  |  | 1 | 3 | 4 | 5 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
3 |  |  | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 | 4 |  |  | 1 | 3 | 4 | 5 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
6 |  |  | 3 | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 | 14 | 22 | 20 | 21 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
22 |  |  | 6 | 3 | 17 | 28 | 10 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 | 14 | 20 | 21 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
10 |  |  | 22 | 6 | 3 | 17 | 28 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 | 14 | 20 | 21 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
21 |  |  | 10 | 22 | 6 | 3 | 17 | 28 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 | 14 | 20 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 14 | 17 | 18 | 20 | 21 | 22 | 23 | 27 | 28 | 33
13 |  |  | 21 | 10 | 22 | 6 | 3 | 17 | 28 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 | 14 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 13 | 14 | 17 | 18 | 21 | 22 | 23 | 27 | 28 | 33
11 |  |  | 13 | 21 | 10 | 22 | 6 | 3 | 17 | 28 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 | 27 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 11 | 13 | 17 | 18 | 21 | 22 | 23 | 27 | 28 | 33
16 |  |  | 11 | 13 | 21 | 10 | 22 | 6 | 3 | 17 | 28 | 33 | 9 | 18 | 1 | 5 | 0 | 23 | 8 |  |  | 1 | 3 | 5 | 6 | 8 | 9 | 10 | 11 | 13 | 16 | 17 | 18 | 21 | 22 | 23 | 28 | 33
Spreadsheet: 680239d1590870062-how-to-copy-every-10-rows-from-multiple-sheets-to-one-sheet-2020-05-30-oeldere2-rezalearner-680235d1590866880-how-to-copy-every-10-rows-from-multiple-she
Sheet: sheet1

...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Spreadsheet: 101117d1299258452-adding-several-cells-based-on-content-rec-03-event-data
Sheet: Rec 03-Event-Data_

Participant 1 |  |  |  | Participant 2 |  |  |  | Participant 3
Timestamp | Page | Time on Page |  | Timestamp | Page | Time on Page |  | Timestamp | Page | Time on Page
23694 | 1 |  |  | 17353 | 1 |  |  | 63908 | 1
32584 | 2 |  |  | 29736 | 2 |  |  | 87329 | 2
36186 | 3 |  |  | 31028 | 3 |  |  | 93293 | 3
54424 | 24 |  |  | 44846 | 4 |  |  | 113885 | 4
66271 | 25 |  |  | 120164 | 3 |  |  | 131419 | 5
73339 | 26 |  |  | 121936 | 4 |  |  | 143031 | 6
116301 | 25 |  |  | 123348 | 5 |  |  | 153457 | 7
117099 | 27 |  |  | 137810 | 6 |  |  | 162579 | 8
120441 | 28 |  |  | 142748 | 7 |  |  | 175029 | 9
135197 | 27 |  |  | 153592 | 8 |  |  | 193203 | 10
135561 | 26 |  |  | 172068 | 9 |  |  | 209629 | 12
136423 | 25 |  |  | 340870 | 10 |  |  | 211819 | 11
138644 | 24 |  |  | 386160 | 11 |  |  | 233589 | 12
142224 | 23 |  |  | 396684 | 12 |  |  | 258299 | 13
145429 | 22 |  |  | 402246 | 13 |  |  | 273145 | 14
174882 | 21 |  |  | 411810 | 14 |  |  | 282051 | 15
186481 | 20 |  |  | 420080 | 15 |  |  | 297865 | 16
198471 | 19 |  |  | 425633 |  |  |  | 329509 | 17
199840 | 18 |  |  |  |  |  |  | 343153 | 18
202974 | 17 |  |  |  |  |  |  | 364383 | 19
204679 | 16 |  |  |  |  |  |  | 391099 | 20
206624 | 15 |  |  |  |  |  |  | 401619 | 21
208384 | 14 |  |  |  |  |  |  | 422915 | 22
211373 | 13 |  |  |  |  |  |  | 455621 | 23
213059 | 12 |  |  |  |  |  |  | 467791 | 24
218082 | 11 |  |  |  |  |  |  | 491593 | 25
220262 | 10 |  |  |  |  |  |  | 503207 | 26
222316 | 9 |  |  |  |  |  |  | 532867 | 27
224734 | 8 |  |  |  |  |  |  | 545245 | 28
231669 | 7 |  |  |  |  |  |  | 557947 | 29
235440 | 6 |  |  |  |  |  |  | 574611 | 30
237454 | 5 |  |  |  |  |  |  | 588287 | 31
243299 | 4 |  |  |  |  |  |  | 602219 | 32
246959 | 3 |  |  |  |  |  |  | 618535 | 33
253590 | 2 |  |  |  |  |  |  | 627697 | 34
259867 | 1 |  |  |  |  |  |  | 641775 | 35
263725 | 2 |  |  |  |  |  |  | 662585 | 36
265993 | 3 |  |  |  |  |  |  | 680727 | 37
270675 | 14 |  |  |  |  |  |  | 704479 | 38
276422 | 15 |  |  |  |  |  |  | 721879 | 39
279643 | 16 |  |  |  |  |  |  | 744547 | 40
281339 | 17 |  |  |  |  |  |  | 755427 | 41
284467 | 18 |  |  |  |  |  |  | 784849 | 42
289503 | 19 |  |  |  |  |  |  | 803027 | 43
293001 | 20 |  |  |  |  |  |  | 813789 | 44
295077 | 21 |  |  |  |  |  |  | 837821 | 45
297041 | 22 |  |  |  |  |  |  | 851723 | 46
302981 | 23 |  |  |  |  |  |  | 864949 | 47
310193 | 24 |  |  |  |  |  |  | 911782 | 48
322211 | 25 |  |  |  |  |  |  | 936578 | 49
325807 | 26 |  |  |  |  |  |  | 970110 | 50
331757 | 27 |  |  |  |  |  |  | 981114 | 51
338615 | 28 |  |  |  |  |  |  | 989280
345335 | 29
356943 | 30
377337 | 29
383527 | 28
387971 | 27
390271 | 26
392411 | 25
395093 | 24
401463 | 23
417653 | 22
432735
Page | P01 | P02 | P03 | Average per Page
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
Spreadsheet: 192006d1352282533-link-the-background-color-to-background-color-of-another-cell-holidaysheetcalculations_template
Sheet: Q1

2013
JAN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
FEB |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
MAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hol + ADV
 | 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
Alton
Dries
[NAME]
Stijn
Sven
[NAME]
Spreadsheet: 27688d1221140864-automatically-add-the-payments-into-a-summary-worksheet-sample-1-
Sheet: Borrower1

Date | Principal | Interest/month | Payment Due | Payment Made | Total
 | 15000 | 1200 |  |  | 19800
2008-08-15 00:00:00 | 2500 | 800 | 3300 | 3300 | 16500
2008-08-30 00:00:00 | 2500 | 800 | 3300 | 3300 | 13200
2008-09-15 00:00:00 | 2500 | 800 | 3300 | 3300 | 9900
2008-09-30 00:00:00 | 2500 | 800 | 3300 |  | 9900
2008-10-15 00:00:00 | 2500 | 800 | 3300 |  | 9900
2008-10-30 00:00:00 | 2500 | 800 | 3300 |  | 9900
2008-11-15 00:00:00
2008-11-30 00:00:00
 | 15000 | 4800 |  |  | 19800
Duration | 3
Spreadsheet: 58941d1259231455-multiple-if-formulas-test
Sheet: Sheet1

NR | LAST NAME | FIRST NAME | ARRIVAL | DEPARTURE | WORKING HOURS | WORKING HOURS W/O LUNCH BREAK | Extra hours | Shift
1 | [NAME] | Pripas | 07:00:00 | 23:59:59 | 1900-01-01 00:00:00
2 | [NAME] | Tal | 21:59:00 | 05:58:49 | 1900-01-01 00:00:00
3 | [NAME] | Uish |  |  | 1900-01-01 00:00:00
Spreadsheet: 865219d1712259558-find-a-centile-for-the-nearest-array-value-for-a-specific-age-liver-proforma-in-progress
Sheet: Sheet1

liver pt proforma
DOB
liver diagnosis
cirrhosis?
ascites?
PMH
diabetes?
PEI?
obesity?
weight
est dry weight
height
MAC
HGS level
left/right
1
2
3
age
male/female?
HGS centile
HGS % of mean for age
HGS change
diet Hx
bf
am snack
L
pm snack
em
bb
ons
current [NAME]?
est intake kcal
est intake protein
est reqs kcal
est reqs protein
CHO every 2-3 hours?
adequate protein?
adequate energy?
nausea?
vomiting?
steattorhoea?
ADVICE
glycogen explanation
high protein explanation
bed time snack ideas
high protein ideas
ONS samples (list)
ONS on
faecal elastase
creon advice
creon dose meals
creon dose snacks
creon dose ONS
total creon/day
total creon/month
safety netting
given dietsheet?
d/c, pifu, f/up?
HGS
Spreadsheet: 677139d1589210928-populate-calendar-and-summary-invercargill-leave-copy
Sheet: LeaveCalendar

Location : | [NAME]
Name
Date | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours | Leave type | Hours
2020-04-20 00:00:00
2020-04-21 00:00:00
2020-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IFERROR(LOOKUP(2,1/(COUNTIF($A$3:A3,tblHelperLeaveCalendar[Name])=0),tblHelperLeaveCalendar[Name]),"")
2020-04-23 00:00:00
2020-04-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IFERROR(INDEX(tblHelperLeaveCalendar[Name],MATCH(0,COUNTIF($A$3:A3,tblHelperLeaveCalendar[Name]),0)),"")
2020-04-25 00:00:00
2020-04-26 00:00:00
2020-04-27 00:00:00
2020-04-28 00:00:00
2020-04-29 00:00:00
2020-04-30 00:00:00
2020-05-01 00:00:00
2020-05-02 00:00:00
2020-05-03 00:00:00
2020-05-04 00:00:00
2020-05-05 00:00:00
2020-05-06 00:00:00
2020-05-07 00:00:00
2020-05-08 00:00:00
2020-05-09 00:00:00
2020-05-10 00:00:00
2020-05-11 00:00:00
2020-05-12 00:00:00
2020-05-13 00:00:00
2020-05-14 00:00:00
2020-05-15 00:00:00
2020-05-16 00:00:00
2020-05-17 00:00:00
2020-05-18 00:00:00
2020-05-19 00:00:00
2020-05-20 00:00:00
2020-05-21 00:00:00
2020-05-22 00:00:00
2020-05-23 00:00:00
2020-05-24 00:00:00
2020-05-25 00:00:00
2020-05-26 00:00:00
2020-05-27 00:00:00
2020-05-28 00:00:00
2020-05-29 00:00:00
2020-05-30 00:00:00
2020-05-31 00:00:00
2020-06-01 00:00:00
2020-06-02 00:00:00
2020-06-03 00:00:00
2020-06-04 00:00:00
2020-06-05 00:00:00
2020-06-06 00:00:00
2020-06-07 00:00:00
2020-06-08 00:00:00
2020-06-09 00:00:00
2020-06-10 00:00:00
2020-06-11 00:00:00
2020-06-12 00:00:00
2020-06-13 00:00:00
2020-06-14 00:00:00
2020-06-15 00:00:00
2020-06-16 00:00:00
2020-06-17 00:00:00
2020-06-18 00:00:00
2020-06-19 00:00:00
2020-06-20 00:00:00
2020-06-21 00:00:00
2020-06-22 00:00:00
2020-06-23 00:00:00
2020-06-24 00:00:00
2020-06-25 00:00:00
2020-06-26 00:00:00
2020-06-27 00:00:00
2020-06-28 00:00:00
2020-06-29 00:00:00
2020-06-30 00:00:00
2020-07-01 00:00:00
2020-07-02 00:00:00
2020-07-03 00:00:00
2020-07-04 00:00:00
2020-07-05 00:00:00
2020-07-06 00:00:00
2020-07-07 00:00:00
2020-07-08 00:00:00
2020-07-09 00:00:00
2020-07-10 00:00:00
2020-07-11 00:00:00
2020-07-12 00:00:00
2020-07-13 00:00:00
2020-07-14 00:00:00
2020-07-15 00:00:00
2020-07-16 00:00:00
2020-07-17 00:00:00
2020-07-18 00:00:00
2020-07-19 00:00:00
2020-07-20 00:00:00
2020-07-21 00:00:00
2020-07-22 00:00:00
2020-07-23 00:00:00
2020-07-24 00:00:00
2020-07-25 00:00:00
2020-07-26 00:00:00
2020-07-27 00:00:00
2020-07-28 00:00:00
2020-07-29 00:00:00
2020-07-30 00:00:00
2020-07-31 00:00:00
Spreadsheet: 238874d1369748734-4-digit-code-for-similar-product-new-product-unique-code-4-digit-codes-with-colour-codes
Sheet: Sheet2

 | Fruit | ID
1
2
3
4
5
6
7
8
9
10
11
Spreadsheet: 865140d1712202242-modifying-a-sequence-of-numbers-so-that-it-contains-a-0-adjust_days_left_example
Sheet: Adjust Days Left

 | Days to Expiration | 4
Day of Week | Date | Signal | Tentative Days left | Actual Days left
 | 2014-03-27 00:00:00 | Buy
 | 2014-03-28 00:00:00 | DBuy
 | 2014-03-31 00:00:00 | Sell
 | 2014-08-28 00:00:00 | Buy
 | 2014-08-29 00:00:00 | Sell
 | 2014-09-30 00:00:00 | Buy
 | 2014-10-01 00:00:00 | DBuy
 | 2014-10-02 00:00:00 | DBuy
 | 2014-10-03 00:00:00 | Sell
 | 2014-12-31 00:00:00 | Buy
 | 2015-01-02 00:00:00 | DBuy
 | 2015-01-05 00:00:00 | DBuy
 | 2015-01-06 00:00:00 | DBuy
 | 2015-01-07 00:00:00 | DBuy
 | 2015-01-08 00:00:00 | Sell
 | 2015-01-28 00:00:00 | Buy
 | 2015-01-29 00:00:00 | DBuy
 | 2015-01-30 00:00:00 | DBuy
 | 2015-02-02 00:00:00 | DBuy
 | 2015-02-03 00:00:00 | Sell
 | 2015-02-26 00:00:00 | Buy
 | 2015-02-27 00:00:00 | DBuy
 | 2015-03-02 00:00:00 | Sell
 | 2015-03-25 00:00:00 | Buy
 | 2015-03-26 00:00:00 | DBuy
 | 2015-03-27 00:00:00 | DBuy
 | 2015-03-30 00:00:00 | Sell
 | 2015-04-30 00:00:00 | Buy
 | 2015-05-01 00:00:00 | DBuy
 | 2015-05-04 00:00:00 | Sell
 | 2015-05-26 00:00:00 | Buy
 | 2015-05-27 00:00:00 | DBuy
 | 2015-05-28 00:00:00 | DBuy
 | 2015-05-29 00:00:00 | DBuy
 | 2015-06-01 00:00:00 | DBuy
 | 2015-06-02 00:00:00 | DBuy
 | 2015-06-03 00:00:00 | Sell
 | 2015-06-25 00:00:00 | Buy
 | 2015-06-26 00:00:00 | DBuy
 | 2015-06-29 00:00:00 | DBuy
 | 2015-06-30 00:00:00 | DBuy
 | 2015-07-01 00:00:00 | DBuy
 | 2015-07-02 00:00:00 | DBuy
 | 2015-07-06 00:00:00 | DBuy
 | 2015-07-07 00:00:00 | Sell
 | 2015-07-27 00:00:00 | Buy