tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 26003d1217861068-problem-with-timesheet-copy-of-timesheet-problem
Sheet: Sheet1

Date | Day | Start | Lunch | Finish | total hours | total flex dec | Flexitime |  | Flexitime taken | H conv dec | J conv time | Holidays
Carried forward |  |  |  |  |  | 0.25 | 00:15:00 |  |  | 0.25 | 0.01041666666666667
JANUARY
2009-01-05 00:00:00 | maandag | 08:00:00 | 01:00:00 | 23:00:00 | 15 | 8 | 08:00:00 |  | 1900-01-01 00:00:00 | 0 | 0 | 0
2009-01-06 00:00:00 | dinsdag | 08:00:00 | 01:00:00 | 23:00:00 | 15 | 8 | 08:00:00 |  | 1900-01-01 00:00:00 | 0 | 0 | 0
2009-01-07 00:00:00 | woensdag | 08:00:00 | 01:00:00 | 23:00:00 | 15 | 8 | 08:00:00 |  | 1900-01-01 00:00:00 | 0 | 0 | 0
2009-01-08 00:00:00 | donderdag | 08:00:00 | 01:00:00 | 23:00:00 | 15 | 8 | 08:00:00 |  | 1900-01-01 00:00:00 | 0 | 0 | 0
2009-01-09 00:00:00 | vrijdag | 08:00:00 | 01:00:00 | 23:00:00 | 15 | 8 | 08:00:00 |  | 1900-01-01 00:00:00 | 0 | 0 | 0
Total for week |  |  |  |  |  | 40 | 40:00 |  | 1900-01-01 00:00:00 | 0 | 0 | 0
Total for week + c/fwd from 2008 |  |  |  |  |  | 40.25 | 40:15
Spreadsheet: 142285d1329764267-vlookup-issue-using-pivot-table-data-example
Sheet: Control

Sum of Count | Column Labels
Row Labels | A | B | C | Grand Total
201101 | 1000 | 2000 | 10000 | 13000
201102 | 1500 | 2500 | 12000 | 16000
201103 | 1200 | 3000 | 20000 | 24200
201104 | 900 | 4000 | 25000 | 29900
201105 | 1300 | 3500 | 30000 | 34800
Grand Total | 5900 | 15000 | 97000 | 117900
Spreadsheet: 267480d1380091483-help-please-how-to-sum-every-6th-cell-supplier-purchases-example-copy
Sheet: Example

Puchase Totals
Financial Year 2008/09 |  |  | NOTE | For Financial Year 2008/09 need the formula to equal
Financial Year 2009/10
Financial Year 2010/11 |  |  |  | However in my real spreadsheet I have over 22,000 lines
Financial Year 2011/12
Financial Year 2012/13
 | Total Puchases
Total
Customer 1
Financial Year 2008/09 | 4541
Financial Year 2009/10 | 2232
Financial Year 2010/11 | 15212
Financial Year 2011/12 | 2513
Financial Year 2012/13 | 2655
Customer 2
Financial Year 2008/09 | 15616
Financial Year 2009/10 | 151
Financial Year 2010/11 | 5695
Financial Year 2011/12 | 2516
Financial Year 2012/13 | 8546
Customer 3
Financial Year 2008/09 | 9562
Financial Year 2009/10 | 1653
Financial Year 2010/11 | 21651
Financial Year 2011/12 | 5645
Financial Year 2012/13 | 12312
Customer 4
Financial Year 2008/09 | 15613
Financial Year 2009/10 | 1561
Financial Year 2010/11 | 656
Financial Year 2011/12 | 6565
Financial Year 2012/13 | 9655
Customer 5
Financial Year 2008/09 | 15616
Financial Year 2009/10 | 9655
Financial Year 2010/11 | 5845
Financial Year 2011/12 | 7453
Financial Year 2012/13 | 5452
Customer 6
Financial Year 2008/09 | 26546
Financial Year 2009/10 | 1265
Financial Year 2010/11 | 121
Financial Year 2011/12 | 56
Financial Year 2012/13 | 5216
Customer 7
Financial Year 2008/09 | 1531
Financial Year 2009/10 | 1561
Financial Year 2010/11 | 2652
Financial Year 2011/12 | 9959
Financial Year 2012/13 | 8955
Customer 8
Financial Year 2008/09 | 1262
Financial Year 2009/10 | 21628
Financial Year 2010/11 | 2186
Financial Year 2011/12 | 1256
Financial Year 2012/13 | 2626
Customer 9
Financial Year 2008/09 | 7897
Financial Year 2009/10 | 8474
Financial Year 2010/11 | 7545
Financial Year 2011/12 | 12561
Financial Year 2012/13 | 15
Customer 10
Financial Year 2008/09 | 1513
Financial Year 2009/10 | 1515
Financial Year 2010/11 | 956
Financial Year 2011/12 | 9554
Financial Year 2012/13 | 8477
Customer 11
Financial Year 2008/09 | 7456
Financial Year 2009/10 | 8218
Financial Year 2010/11 | 21562
Financial Year 2011/12 | 125
Financial Year 2012/13 | 2521
Customer 12
Financial Year 2008/09 | 21562
Financial Year 2009/10 | 2151
Financial Year 2010/11 | 8847
Financial Year 2011/12 | 985
Financial Year 2012/13 | 33941
Customer 13
Financial Year 2008/09 | 26212
Financial Year 2009/10 | 451
Financial Year 2010/11 | 4584
Financial Year 2011/12 | 5166
Financial Year 2012/13 | 5163
Customer 14
Financial Year 2008/09 | 6516
Financial Year 2009/10 | 1561
Financial Year 2010/11 | 1516
Financial Year 2011/12 | 181
Financial Year 2012/13 | 7799
Customer 15
Financial Year 2008/09 | 2628
Financial Year 2009/10 | 987
Financial Year 2010/11 | 4748
Financial Year 2011/12 | 8894
Financial Year 2012/13 | 9898
 | 7741
Spreadsheet: 166282d1341517137-indirect-formula-and-naming-problem-question1
Sheet: Sheet1

 |  | Amount
 | [NAME]
Customer Name | Amount | quantity
Abc Ltd | 7600 | 1
DG corporation | 118132.5 | 2
Xyz tex | 25846 | 3
Advanced Technology | 3815.624 | 4
Axis traders | 12290.46 | 41
XL Technical | 14200 | 6
KD Trading | 26125 | 7
PR Middle East | 73240.75 | 8
DP Trading | 62883.498128 | 9
DLL corporation | 2100 | 17
[NAME] | 0
Spreadsheet: 125270d1318950484-get-autoshape-name-from-cell-shapesv2
Sheet: Text

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shape | Number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Circle | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Triangle | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Square | 3
 |  |  |  |  |  |  |  |  | Link to shape | Select shape | Select Number | Comment
 |  |  |  |  |  |  |  |  | Duble click | Circle | 2
 |  |  |  |  |  |  |  |  | Duble click | Circle | 1
 |  |  |  |  |  |  |  |  | Duble click | Square | 3
 |  |  |  |  |  |  |  |  | Duble click | Circle | 3
 |  |  |  |  |  |  |  |  |  | Listbox | Listbox
Spreadsheet: 80314d1280489036-comparing-two-sheets-to-find-common-records-multi-criteria-lookup-example
Sheet: Sheet1

First Name | Last Name | Title | Company Name | Address | City | State | Phone | Company Type | Location Type | Symbol | Ultimate Parent | Language Preference | Fiscal Year-End | Rev ($ M) | Revenue Growth % | Income ($ million) | Income Growth % | # Empl | Employee Growth % | Employees At This Location | Assets ($ million) | Market Value ($ million) | R&D ($ million) | Advertising ($ million) | Auditors | Bank | Founded | Helper Column | Non-Array | Array
[NAME] | Reed | Owner | Company A | 777 [NAME] drive | Los Angeles | CA | 1234567890 | Private | Single Location |  |  |  |  | 0.7 | -- | -- | -- | 22 | -- | 22 | -- | -- | -- | -- |  |  | 1992 | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | Cockrill | Owner | Company B | 777 [NAME] drive | Los Angeles | CA | 1234567891 | Private | Single Location |  |  |  |  | 0.9 | -- | -- | -- | 20 | -- | 20 | -- | -- | -- | -- |  |  | 1992 | #N/A | #N/A | #N/A
[NAME] | Smith | Owner | Company C | 777 [NAME] drive | Los Angeles | CA | 1234567892 | Private | Single Location |  |  |  |  | 0.2 | -- | -- | -- | 4 | -- | 4 | -- | -- | -- | -- |  |  | 2001 | [EMAIL] | [EMAIL] | [EMAIL]
Trevor | Smith | Director | Company A | 777 [NAME] drive | Los Angeles | CA | 1234567893 | Private | Single Location |  |  |  |  | 0.2 | -- | -- | -- | 4 | -- | 4 | -- | -- | -- | -- |  |  | 2001 | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | Reed | Owner | Company C | 777 [NAME] drive | Los Angeles | CA | 1234567895 | Private | Single Location |  |  |  |  | 0.2 | -- | -- | -- | 5 | -- | 5 | -- | -- | -- | -- |  |  | 1980 | [EMAIL] | [EMAIL] | [EMAIL]
[NAME] | Cockrill | Owner | Company A | 777 [NAME] drive | Los Angeles | CA | 1234567896 | Private | Single Location |  |  |  |  | 0.3 | -- | -- | -- | 8 | -- | 8 | -- | -- | -- | -- |  |  | 1993 | [EMAIL] | [EMAIL] | [EMAIL]
Trevor | Smith | Owner | Company B | 777 [NAME] drive | Los Angeles | CA | 1234567897 | Private | Single Location |  |  |  |  | 0.1 | -- | -- | -- | 3 | -- | 3 | -- | -- | -- | -- |  |  | 1995 | [EMAIL] | [EMAIL] | [EMAIL]
Eliza | Smith | Owner | Company C | 777 [NAME] drive | Los Angeles | CA | 1234567898 | Private | Single Location |  |  |  |  | 0.2 | -- | -- | -- | 6 | -- | 6 | -- | -- | -- | -- |  |  | 2006 | [EMAIL] | [EMAIL] | [EMAIL]
Spreadsheet: robin_rodrigue__33246__YTD Recon
Sheet: Sep 00

 |  | 2000-09-01 00:00:00 |  | 2000-09-05 00:00:00 |  | 2000-09-06 00:00:00 |  | 2000-09-07 00:00:00 |  | 2000-09-08 00:00:00 |  | 2000-09-11 00:00:00 |  | 2000-09-12 00:00:00 |  | 2000-09-13 00:00:00 |  | 2000-09-14 00:00:00 |  | 2000-09-15 00:00:00 |  | 2000-09-18 00:00:00 |  | 2000-09-19 00:00:00 |  | 2000-09-20 00:00:00 |  | 2000-09-21 00:00:00 |  | MTD |  | YTD |  | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (as of 8/31)
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34601336
South |  |  |  |  |  |  |  | -56275 |  |  |  | -65413 |  | -299322 |  | -155697 |  |  |  | -44770 |  | 267337 |  |  |  |  |  | 443016 |  |  |  | 5263447
Tholt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13810919
Lenhart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3171259
Kuykendall |  |  |  |  |  |  |  | -22420 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5682608
Total
Spreadsheet: 885701d1735528582-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-error
Sheet: Roster

Start Date | 3-Feb | 10-Feb | 17-Feb | 24-Feb | 2024-03-03 00:00:00 | 2024-03-10 00:00:00 | 2024-03-17 00:00:00 | 2024-03-24 00:00:00 | 2024-03-31 00:00:00 | 2024-04-07 00:00:00
 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5 | WEEK 1 | WEEK 2 | WEEK 3 | WEEK 4 | WEEK 5
Staff Name | Days (Wed off) | Days ([NAME] off) | RLEAVE | RLEAVE | RLEAVE | WEEKDAY EVENING | WEEKEND DAYS 10 | DAYS (Tue Off) | WEEKEND DAYS 10 | DAYS (Tue Off)
 | Days (Wed off) | Days ([NAME] off) |  |  |  | WDE1 | WED10 | Days ([NAME] off) | WED10 | Days ([NAME] off)
Spreadsheet: 60596d1261098635-form-development-help-adding-rows-sample-worksheet
Sheet: Data Entry

The first sheet is my data entry sheet.  I have a lot of links and cross calculations on it already.
For question 1, this is the kind of operation I need:
 | Are there any unliquidatd claims? |  |  |  |  | <----Y or N would be entered here.
For question 2, this is the kind of operation I need:
Secured Creditors Reaffirmed: |  |  |  | <---Number of creditors would be entered here.
 | Creditor | Collateral | Value | Claim | Int. Rate | Monthly Payment
 |  |  |  |  |  |  | <----spread sheet would insert enough rows here based on the number of creditors entered on D10.
Secured Creditors Reaffirmed: |  |  |  | <---Number of creditors would be entered here.
 | Creditor | Collateral | Value | Claim | Int. Rate | Monthly Payment
 |  |  |  |  |  |  | <----spread sheet would insert enough rows here based on the number of creditors entered on D14.
For question 3, this is the kind of operation I need:
 | Plan Payment: |  |  | <----An entry could be added/changed here and the cell would be linked with cells on other tabs.  A change to ANY of the cells would update the cells on the other tabs.  I could change it here or on the quick summary or on the data entry tab.
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: NGPL

 | 52862 |  | 6828 |  | 6838
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 36628 | 36611 | -62566 | -64614 | 26856 | 27482
2 | 36686 | 36611 |  |  | 27507 | 27482
3 | 36629 | 36611 |  |  | 27519 | 27482
4 | 36620 | 36611 |  |  | 27475 | 27482 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 20050 | 19611 | -381 | -21181 | 27352 | 27482
6 | 26429 | 23911 | -42793 | -41764 | 27354 | 27482 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 20665 | 20611 | -57780 | -58347 | 27331 | 27482
8 | 24643 | 24611 | -64422 | -61514 | 25361 | 27482 |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 30250 | 30611 | -14801 | -15514 | 19818 | 15654 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 30614 | 30611 | -16689 | -15514 | 19928 | 15560 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 21184 | 30611 | -15652 | -15514 | 24670 | 16294 |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 | 32868 | 42611 | -26653 | -26514 | 21374 | 15844 |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13 | 24656 | 24611 |  | -14 | 24197 | 26294
14 | 20682 | 20611 |  | -14 | 27354 | 27471 |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15 | 19469 | 19611 | -8210 | -16914 | 33492 | 33554
16 | 19863 | 19611 |  |  | 33492 | 18351 |  | 127244 |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17 | 19689 | 19611 |  |  | 32430 | 25000 |  | 8222
18 | 39166 | 19611 |  |  | 10870 | 30124
19
20 |  |  |  |  |  |  |  | 96781 | 23852
21 |  |  |  |  |  |  |  | 38685 | 4050
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2002-02-28 00:00:00
2002-03-18 00:00:00
CBS Dollars
 |  |  | 146195 |  | 338741 |  | 121117
 |  |  |  |  |  |  | 64404
Spreadsheet: 94173d1294055215-filter-list-with-formula-filter-list-with-formula
Sheet: Sheet1

Code | Number |  |  |  |  | Criteria Is not to show those value with same Code and same Number
G | 7
F | 6 |  |  |  |  | Below list is what I want (NOTE : must not sort the database) |  |  |  |  | Here is what I tried but only work for single column (NOTE : The second column value is not right)
E | 5
D | 4 |  |  |  |  | Code | Number |  |  |  | Code | Number
C | 3 |  |  |  |  | A | 1
B | 2 |  |  |  |  | A | 8
A | 1 |  |  |  |  | B | 2
G | 14 |  |  |  |  | B | 9
F | 13 |  |  |  |  | C | 3
E | 12 |  |  |  |  | C | 10
D | 11 |  |  |  |  | D | 4
C | 10 |  |  |  |  | D | 11
B | 9 |  |  |  |  | E | 5
A | 8 |  |  |  |  | E | 12
G | 7 |  |  |  |  | F | 6
F | 6 |  |  |  |  | F | 13
E | 5 |  |  |  |  | G | 7
D | 4 |  |  |  |  | G | 14
C | 3
B | 2 |  |  |  |  | Question is how to make a formula to generate those list I wanted?
A | 1
G | 14
F | 13
E | 12
D | 11
C | 10
B | 9
A | 8
Spreadsheet: 80776d1280964792-auto-populate-a-by-name-list-on-a-separate-sheet-based-upon-expired-dates-example
Sheet: Main

NAME | CERTIFICATION A | CERTIFICATION B | CERTIFICATION C
Jon | 2010-04-01 00:00:00 | 2015-05-01 00:00:00 | 2014-09-15 00:00:00
[NAME] | 2009-06-29 00:00:00 | 2013-12-01 00:00:00 | 2014-12-01 00:00:00
Sue | 2014-08-23 00:00:00 | 2015-02-01 00:00:00 | 2014-02-01 00:00:00
[NAME] | 2013-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-11-01 00:00:00
Spreadsheet: 216976d1361951728-dissemination-of-informatin-based-on-sheet-title-participation-levels
Sheet: 20

Member's Name:
Address:
Cluster:
Group
Total Land Holding:
Irrigated
Unirrigated
 | Input Supply |  |  |  |  |  |  |  |  |  | Collective Marketing |  |  |  | Seed Production |  | Sales
Date | [NAME] | Fertilizer | Maize Seed | Pesticide | Sundry Item | Vegetable Seed | Wheat Seed | Wheat Seed (SP) | Seeds | Total | Maize | Wheat | Vegetable | Total | Wheat | Total | Bag Packing | I.S.A.P. | [NAME] | Total
Spreadsheet: jonathan_mckay__17192__June Index Summary
Sheet: Tenn 500

EOL Transaction Summary Report
Criteria: | Traders
 | [NAME]
 | Product:
 | US Gas Phy Fwd
EnronOnline Report | All Counterparties
Product | Date-Time | Volume | Price
US Gas Phy       TENN 500                Jun01           USD/MM | 05/29/2001 03:17 pm | 3305 | 3.665
US Gas Phy       TENN 500                Jun01           USD/MM | 05/29/2001 12:53 pm | 1447 | 3.7375
 | TOTAL VOLUME
Weighted Average
Spreadsheet: 105104e3-1856-4743-b12d-c76e01452f91
Sheet: Sheet1

COUNTY | DISTRICT NAME | DISTRICT IRN
Lucas | [NAME] | 48207
Lucas | Maumee City | 44362
Lucas | Oregon City | 44602
Lucas | Ottawa Hills Local | 48215
Lucas | Springfield Local | 48223
Lucas | Sylvania City | 44875
Lucas | Toledo City | 44909
Lucas | Washington Local | 48231
Spreadsheet: 156166d1337198078-a-fun-one-matching-rows-to-columns-sample
Sheet: Sheet2

Player | Team
Spreadsheet: b15ed1b3-ced5-4d27-b060-35ad5aea8b08
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 11974 | 11866 | 11311 | 10255
20 - 65 | 50193 | 45127 | 39258 | 35054
65 und mehr | 21033 | 21828 | 23716 | 24480
Insgesamt | 83200 | 78821 | 74285 | 69789
%
unter 20 | 14.39182692307692 | 15.05436368480481 | 15.22649256242848 | 14.6942927968591
20 - 65 | 60.328125 | 57.25250884916456 | 52.84781584438312 | 50.22854604593847
65 und mehr | 25.28004807692308 | 27.69312746603062 | 31.92569159318839 | 35.07716115720243
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 23.85591616360847 | 26.29467946019013 | 28.81196189311733 | 29.25486392423118
Altenquotient | 41.90424959655729 | 48.37015533937554 | 60.41061694431708 | 69.83511154219205
Gesamtquotient | 65.76016576016576 | 74.66483479956567 | 89.22257883743441 | 99.08997546642323
Gebietsstand: | 31. [NAME] 2008
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 83394d1283372655-separating-different-products-ex-1-
Sheet: Sheet1

Sum of Price | Column Labels
Row Labels | a1 | a2 | b1 | b2 | c1 | c2 | c3 | Grand Total
A | 2.5 | 4.3 |  |  |  |  |  | 6.8
B |  |  | 2.3 | 2 |  |  |  | 4.3
C |  |  |  |  | 1 | 3 | 2 | 6
Grand Total | 2.5 | 4.3 | 2.3 | 2 | 1 | 3 | 2 | 17.1
Spreadsheet: 95322d1294933419-update-drop-down-menu-data-when-source-is-updated-cv-weighting
Sheet: Sheet1

CV weighting
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | Criteria |  | Within a 5 mile radius | Within a 25 mile radius | Currently working within an IT related role | Linux experience | cPanel experience | SonicWall experience | ADSL troubleshooting | Working with virtualised environments | A to C GCSE Maths, English and Science | Microsoft Certified Professional | IT related degree | Computer building and repair experience | Poor grammar on CV |  | Total Score
Applicants Name
[NAME] |  |  | 10 | 5 | 10 | 0 | 10 | 0 | 0 | 0 | 0 | 5 | 0 | 10 | 0
Scores
1 | 0 | 10
2 | 0 | 5
3 | 0 | 10
4 | 0 | 15
5 | 0 | 10
6 | 0 | 10
7 | 0 | 5
8 | 0 | 10
9 | 0 | 10
10 | 0 | 5
11 | 0 | 5
12 | 0 | 10
13 | 0 | -15
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: AB

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 473452d1470218866-sum-corresponding-number-of-duplicate-id-alireza123456
Sheet: Sheet1

Address | income3 |  |  |  | Address | income3 |  |  |  | Address | Total income3
20007018308 | 2000000 |  |  |  | 20007018308 | 2000000 |  |  |  | 20001011416 | 3400000
20012021716 | 9400000 |  |  |  | 20012021716 | 9400000 |  |  |  | 20003013005 | 850000
20004014305 | 4250000 |  |  |  | 20004014305 | 4250000 |  |  |  | 20003013013 | 24850000
20003013005 | 850000 |  |  |  | 20003013005 | 850000 |  |  |  | 20003013016 | 1700000
20001011416 | 3400000 |  |  |  | 20001011416 | 3400000 |  |  |  | 20004014301 | 7400000
20007018305 | 4250000 |  |  |  | 20007018305 | 6250000 |  |  |  | 20004014305 | 4250000
20007018305 | 2000000 |  |  |  | 20003013016 | 1700000 |  |  |  | 20007018301 | 30550000
20003013016 | 1700000 |  |  |  | 20003013013 | 24850000 |  |  |  | 20007018305 | 6250000
20003013013 | 24850000 |  |  |  | 20007018316 | 13700000 |  |  |  | 20007018308 | 2000000
20007018316 | 13700000 |  |  |  | 20007018301 | 30550000 |  |  |  | 20007018316 | 13700000
20007018301 | 2550000 |  |  |  | 20013024112 | 4250000 |  |  |  | 20012021716 | 9400000
20007018301 | 28000000 |  |  |  | 20004014301 | 7400000 |  |  |  | 20013024112 | 4250000
20013024112 | 4250000
20004014301 | 7400000
Spreadsheet: lisa_gang__22312__ENA_PGE_JUNE_5_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-06-05 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 50 | 25 | 25 | 25 | 25
0800 | 50 | 25 | 25 | 25 | 25
0900 | 50 | 25 | 25 | 25 | 25
1000 | 50 | 25 | 25 | 25 | 25
1100 | 50 | 25 | 25 | 25 | 25
1200 | 50 | 25 | 25 | 25 | 25
1300 | 50 | 25 | 25 | 25 | 25
1400 | 50 | 25 | 25 | 25 | 25
1500 | 50 | 25 | 25 | 25 | 25
1600 | 50 | 25 | 25 | 25 | 25
1700 | 50 | 25 | 25 | 25 | 25
1800 | 50 | 25 | 25 | 25 | 25
1900 | 50 | 25 | 25 | 25 | 25
2000 | 50 | 25 | 25 | 25 | 25
2100 | 50 | 25 | 25 | 25 | 25
2200 | 50 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | SNCL | PPM | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | ISO(T)CPJK/NP15 | MIRANT | APX(L)NP15 | ISO(T)MALIN/NP15
 | MID(L)WESLEY | SNCL(L)NP15 | PGE | ISO(T)MALIN/NP15 | SDGE(L)NP15
 |  |  | WESCO | APX(L)NP15
 |  |  | ISO(T)MALIN/NP15
 |  |  | [NAME]
Spreadsheet: ffd0dea4-5b81-4b2b-92f5-8d27d8f31317
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7497 | 21487 | Romina | Biagioli | ARG | 26 | 00:20:04 | 00:01:33 | 01:08:31 | 00:00:41 | [NAME] | 1 | 02:16:21
7497 | 54908 | [NAME] | Arteriza | ARG | 29 | 00:21:31 | 00:01:34 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
7497 | 39146 | Rayen | Asselborn | ARG | 30 | 00:21:53 | 00:01:31 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
7497 | 39151 | Camila | Makre | ARG | 28 | 00:21:54 | 00:01:38 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
7497 | 39572 | Tania | Sapoznik | PAR | 27 | [NAME] | 00:01:38 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 855050d1704773034-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker
Sheet: Oct

 |  |  |  |  |  | CALENDAR MONTH | OCTOBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes