tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 821992d1679042592-index-match-from-table-and-date-excel-help
Sheet: Theo

Month | January |  |  | COS p/Unit | Total COS |  | Name | COS |  | PLU |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Date
 | Menu Item Name | Menu Item # | [NAME] | Single | Total |  | Avocado | 3.26 |  | 10070003 | 100030005 | 60040005 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  | Bestikk i Bambus | 0.87372 |  | 20040002 | 300010009 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
1 | Avocado |  | 170 |  |  |  | Coriander | 0.6961 |  | 100030004 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
1 | Bestikk i Bambus |  | 237 |  |  |  | [NAME] | 5.00039 |  | 700010007 | 700010004 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
1 | [NAME] |  | 87 |  |  |  | Extra Patty | 5.026 |  | 60040001 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
1 | Extra Patty |  | 219 |  |  |  | Frisk Chili | 1.2388 |  | 600030001 | 20050009 | 100030001 | 400030001 | 500030001 | 700010013 | 60040004 | 700030001 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
1 | Frisk Chili |  | 123 |  |  |  | Marinerede rødløg | 0.823 |  | 100030002 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
1 | [NAME] ([NAME]) |  | 242 |  |  |  | [NAME] ([NAME]) | 1.5389 |  | 10070002 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
 |  |  |  |  |  |  | Avocado | 3.34 |  | 10070003 | 100030005 | 60040005 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 | February |  |  | COS p/Unit | Total COS |  | Bestikk i Bambus | 0.9523 |  | 20040002 | 300010009 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 | Menu Item Name | Menu Item # | [NAME] | Single | Total |  | Coriander | 0.685 |  | 100030004 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  |  | [NAME] | 5.0144 |  | 700010007 | 700010004 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
2 | Avocado |  | 188 |  |  |  | Extra Patty | 4.998 |  | 60040001 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
2 | Bestikk i Bambus |  | 224 |  |  |  | Frisk Chili | 1.244 |  | 600030001 | 20050009 | 100030001 | 400030001 | 500030001 | 700010013 | 60040004 | 700030001 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
2 | [NAME] |  | 90 |  |  |  | Marinerede rødløg | 0.888 |  | 100030002 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
2 | Extra Patty |  | 221 |  |  |  | [NAME] ([NAME]) | 1.523 |  | 10070002 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
2 | Frisk Chili |  | 135
2 | [NAME] ([NAME]) |  | 250
Spreadsheet: 91539d1291234517-excel-2007-vba-conditional-case-limitations-jacglc2010_partslist_ron
Sheet: Parts

StockNumber | Description
10001 | Alpha
10002 | Bravo
10003 | [NAME]
10004 | Delta
10005 | Echo
10006 | Foxtrot
10007 | Golf
10008 | Hotel
10009 | India
10010 | [NAME]
10011 | Kilo
10012 | Lima
10013 | [NAME]
10014 | November
10015 | October
10016 | Papa
10017 | Quebec
10018 | Romeo
10019 | Sierra
10020 | Tango
10021 | Uniform
10022 | Victor
10023 | Whiskey
10024 | [NAME]
10025 | Yankee
10026 | Zulu
Spreadsheet: 4e94c7ef-4755-42f2-89bb-563bbfd475e2
Sheet: Sheet1

Report Type: | Expression Report | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Date: | 06:39PM 02/22/2004
Filename: | HF_M4_430A_msk500.CHP
Probe Array Type: | MOE430A
Algorithm: | Statistical
Probe Pair Thr: | 8
Controls: | Antisense
[NAME]: | 0.05
Alpha2: | 0.065
Tau: | 0.015
[NAME] ([NAME]): | 1.65
Scale Factor (SF): | 0.897
TGT Value: | 500
Norm Factor (NF): | 1
Background: | Avg: 42.62 | Std: 0.90 | Min: 40.50 | [NAME]: 45.00
Noise: | Avg: 2.58 | [NAME]: 0.19 | Min: 2.10 | [NAME]: 3.10
Corner+ | Avg: 255 |  | Count: 32
Corner- | Avg: 15135 |  | Count: 32
Central- | Avg: 12706 |  | Count: 9
The following data represents probe sets that exceed the probe pair threshold
and are not called "No Call".
Total Probe Sets: | 22690
Number Present: | 11823 | 0.521
Number Absent: | 10504 | 0.463
Number Marginal: | 363 | 0.016
Average Signal (P): | 497.6
Average Signal (A): | 23
Average Signal (M): | 67
Average Signal (All): | 271
Housekeeping Controls:
Probe Set | Sig(5') | Det(5') | Sig(M') | Det(M') | [NAME]') | Det(3') | Sig(all) | Sig(3'/5') | Sig(3'/M')
AFFX-B-ACTINMUR/M12481 | 3110 | P | 3859.8 | P | 6505.6 | P | 4491.8 | 2.09 | 1.685475931395409
AFFX-GAPDHMUR/M32599 | 4210.1 | P | 3672.4 | P | 4274.9 | P | 4052.47 | 1.02 | 1.164061649057837
AFFX-18SRNAMUR/X00686 | 7791.7 | P | 2575.1 | P | 4882.5 | P | 5083.11 | 0.63 | 1.896042872121471
[NAME]:
Probe Set | Sig(5') | Det(5') | Sig(M') | Det(M') | [NAME]') | Det(3') | Sig(all) | Sig(3'/5')
AFFX-BIOB | 183.2 | P | 386.2 | P | 174.2 | P | 247.87 | 0.95
AFFX-BIOC | 531.8 | P |  |  | 367.6 | P | 449.71 | 0.69
AFFX-BIOD | 372 | P |  |  | 2414.3 | P | 1393.19 | 6.49
AFFX-CRE | 5292.2 | P |  |  | 7095 | P | 6193.59 | 1.34
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 40

कार्यक्रम PROGRAM |  |  | स्वणय ऋण की रूपरे खा CONTOURS OF GOLD LOAN | PROG CODE
 |  |  |  | IT 1833
तर्षर् समूह/SUBJECT GROUP |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | TO IMPART INTEGRATED WORKING KNOWLEDGE IN GOLD LOANS
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration, Entry Test, Industry level Analysis
 | II | Our Gold Loan products and that of peers - A comparative Analysis
 | III | Agriculture Gold Loan Products and Retail Gold Loan Products
 | IV | Gold loan sanctioning process      Documentation and policy guidelines,      Online Application and Digital Documentation Processing of [NAME] payments through SAS-[NAME] package.
Day 2 | I | Monitoring and Internal control mechanism for Gold Loans.      Maintenance of proper Registers      Safekeeping of Gold Jewellery      Quarterly Balancing of Gold Loans
 | II | Monitoring and Internal control mechanism for Gold Loans.      Reappraisal guidelines and capturing of details & Payment of Reappraisal fees through SAS - [NAME] package      Reconciliation of various GLs related to Gold Loans
 | III | Recovery mechanism in Gold loan accounts      SMA in gold loan accounts      Process of recovery      Gold ornaments auctioning process      Process flow of GLAP Package.
 | IV | Customer Relationship Management & Data Analytics Tools
Day 3 | I & II | Methods for assessment of purity of Gold. Identification  of  Spurious  Gold   -   details  and  demo  by  [NAME].
 | III | Business Ethics and Value System
 | IV | Implementation of OL, Exit test, Valediction & Feedback
Spreadsheet: david_delainey__8096__2000GroupExpenses
Sheet: Sheet1

 |  |  | 2001 Pro Forma
 |  | Group Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  | ENA BUDGET |  |  | 2000
 |  |  |  | People | Office | Equipment | Consultants | Other | Total | 2000 | [NAME] | Tot/HC | [NAME] | Stretch | Net | 2000 Net | [NAME] | Headcount | Headcount | [NAME]
 |  | BA&R | Colwell | 10050000 | 818000 | 528000 | 188000 | 374000 |  | 11487000 |  |  | 700000 |  |  | 10787000 |  | 124 | 118
 |  | Transaction Support | Colwell | 2600000 | 89000 | 37000 | 1200000 | 0 |  | 2373000 |  |  | 1500000 |  |  | 2073000 |  | 15 | 11
 |  | Energy Ops/EOL Trading | Beck | 35452000 | 4407000 | 8009000 | 1977000 | -1550000 |  | 43099000 |  |  | 5364000 | 1083000 |  | 38299000 |  | 463 | 455
 |  | Human Resources | [NAME] | 6488000 | 616000 | 338000 | 881000 |  |  | 4543000 |  |  | 2796000 |  |  | 2443000 |  | 69 | 41
 |  | Legal | [NAME] | 14836000 | 1307000 | 550000 | 18054000 |  |  | 38298000 |  |  |  | 83000 |  | 15602000 |  | 91 | 96
 |  | Public Relations | Thode | 864000 | 1708000 | 67000 | 87000 |  |  | 2642000 |  |  | 0 |  |  | 2442000 |  | 9 | 9
 |  | Tax | [NAME] | 4484000 | 330000 | 259000 | 954000 |  |  | 5395000 |  |  |  | 83000 |  | 3638000 |  | 38 | 27
 |  | Research | Kaminski | 8522000 | 602000 | 546000 | 458000 | 393000 |  | 3762000 |  |  | 8238000 | 83000 |  | 2362000 |  | 60 | 42
 |  | e-source | Colwell | 1213596 | 351021 | 388923 | 192000 | 0 |  | 0 |  |  |  | 83000 |  | 0 |  | 16 | 16 | 0
 |  | CABC | Tholan | 2055700 | 393000 | 180967 | 500000 | 0 |  | 3324000 |  |  | 2100000 | 83000 |  | 3324000 |  | 16 | 16
 |  | Technical Services | Redmond |  |  |  | 11971 | 0 |  | 3023000 |  |  | 0 | 83000 |  | 3023000 |  | 26 | 11
 |  | Treasury | Defner | 3343000 | 263000 | 114000 | 0 | 3333000 |  | 3170000 |  |  |  | 84669 |  | 3170000 |  | 23 | 15
 |  | TOTAL
 |  | NOTES:
 |  | * Other - includes net decrease due to expected corporate allocation;
 |  | * Bill/Out - expected charge out to EIM/EGM/other for BA&R, Transaction Support, Energy Ops, HR, Legal (including charge out of outside legal to ENA groups), Public Relations, Tax (including charge out of outside tax to ENA groups), Research, e-source (assume 60% outside ENA), CABC and Treasury(including $3.3M in facility costs for TurboPark)
 |  | * Stretch- every group given a stretch charge of $83,000 in order to keep flat to 2000 forecast; includes negotiated numbers for BA&R, Transaction Support, Energy Ops, Human Resources, Public Relations and Technical Services
Spreadsheet: 27c115d3-bdfc-4606-ba6d-5450a4d0fafc
Sheet: Sheet1

athletes_idAthletes | Rk | Nation | Date of Birth | ID Number | Last Name | First Name | Total Pts | Fenc | Swim | Ride | Comb | Swim time
39745 | 1 | KOR | 10/02/92 | M039745 | [NAME] | [NAME] | 4588 | 840 | 1324 | 0 | 2424 | 2:03.04
39664 | 2 | RUS | 13/09/92 | M039664 | SHUGAROV | Ilya | 4568 | 1040 | 1284 | 0 | 2244 | 2:06.40
37680 | 2 | GER | 04/12/92 | M037680 | KRUEGER | [NAME] | 5616 | 968 | 1220 | 1200 | 2228 | 2:11.69
39426 | 3 | MEX | 07/04/93 | M039426 | CAMACHO | [NAME] | 4548 | 1000 | 1204 | 0 | 2344 | 2:13.28
37962 | 4 | HUN | 03/08/92 | M037962 | DEMETER | Gergely | 4532 | 760 | 1336 | 0 | 2436 | 2:02.24
37070 | 5 | ESP | 05/01/92 | M037070 | HEREDIA VIVES | Aleix | 4468 | 920 | 1152 | 0 | 2396 | 2:17.41
39217 | 6 | BLR | 06/04/93 | M039217 | BIRUK | Aliaksander | 4464 | 840 | 1276 | 0 | 2348 | 2:07.32
35912 | 7 | POL | 04/07/92 | M035912 | DZIUDZIEK | Karol | 4388 | 960 | 1204 | 0 | 2224 | 2:13.07
38991 | 8 | FRA | 26/09/92 | M038991 | PRADES | Valentin | 4364 | 880 | 1192 | 0 | 2292 | 2:14.00
39234 | 9 | LTU | 29/05/92 | M039234 | KONTRIMAVICIUS | Lukas | 4360 | 800 | 1244 | 0 | 2316 | 2:09.68
38927 | 10 | EGY | 11/03/91 | M038927 | SEIF | [NAME] | 4344 | 840 | 1272 | 0 | 2232 | 2:07.39
39640 | 11 | CHN | 17/05/93 | M039640 | HAN | Jiahao | 4336 | 840 | 1344 | 0 | 2152 | 2:01.49
39186 | 12 | UKR | 15/08/92 | M039186 | FEDECHKO | Yuriy | 4312 | 840 | 1264 | 0 | 2208 | 2:08.19
39312 | 13 | USA | 22/05/92 | M039312 | SCHRIMSHER | Nathan | 4216 | 840 | 1264 | 0 | 2112 | 2:08.31
39355 | 14 | SVK | 29/06/92 | M039355 | SZALAY | Jan | 4208 | 1040 | 1236 | 0 | 1932 | 2:10.42
37071 | 16 | GBR | 29/06/92 | M037071 | LONGDEN | Gregory | 4132 | 640 | 1244 | 0 | 2248 | 2:09.99
39736 | 17 | BRA | 02/08/93 | M039736 | MUINHOS | [NAME] | 4108 | 640 | 1244 | 0 | 2224 | 2:09.97
39298 | 18 | BUL | 22/07/92 | M039298 | IVANOV | Doicho | 4088 | 800 | 1152 | 0 | 2136 | 2:17.65
38708 | 19 | KGZ | 15/09/92 | M038708 | BAKTYBEKOV | Ilias | 3992 | 840 | 1140 | 0 | 2012 | 2:18.43
37166 | 20 | KAZ | 14/08/93 | M037166 | SOBOLEV | German | 3944 | 720 | 1144 | 0 | 2080 | 2:18.09
38876 | 21 | GUA | 04/05/93 | M038876 | IMERI | Jorge | 3936 | 740 | 1172 | 0 | 2024 | 2:15.99
37917 | 22 | ITA | 21/05/92 | M037917 | MICALIZZI | [NAME] | 3884 | 680 | 1272 | 0 | 1932 | 2:07.36
37529 | 23 | CZE | 12/03/93 | M037529 | BILKO | Martin | 3836 | 600 | 1212 | 0 | 2024 | 2:12.40
39744 | 24 | AUS | 30/06/92 | M039744 | RENFREE | Todd | 3688 | 560 | 1104 | 0 | 2024 | 2:21.65
Spreadsheet: 117147d1312474387-excel-2007-if-blank-enter-another-cell-value-book1
Sheet: Sheet1

Y5 | Z | Y5 | In Column A            IF cell C1=ISNOTBlank, enter cell value C1, OR IF cell C1=ISBlank, enter cell value B1        (Results as per red text)
Z | Z
Z | Z
Y3 | Z | Y3
Z | Z
Y7 |  | Y7
Z | Z
Y9 | Z | Y9
Spreadsheet: 234027d1367985092-how-to-create-option-or-combo-box-within-cell-validation-lists
Sheet: Lead

Date | Name | Gender | Residence Status | Contact |  | Project Type | Subject Property Address | Advisor | MLS | Listing Price | Offer price | Down Payment | Loan Amount | Last Follow up date | Next Follow up date | Referred by | Commission Ratio | Current Status | Note
 |  |  |  | Something else
Spreadsheet: 842561d1694606503-help-with-auto-fill-formula-help-15-
Sheet: Rolling week

2023-05-01 00:00:00 | Order | Fill | Av
S | 6000 | 5888
V | 8200 | 7500
O | 14000 | 13500
2023-05-02 00:00:00 | Order | Fill | Av
S | 6000 | 5888
V | 8200 | 7500
O | 14000 | 13500
2023-05-03 00:00:00 | Order | Fill | Av
S | 6000 | 5888
V | 8200 | 7500
O | 14000 | 13500
2023-05-01 00:00:00 | Order | Fill | Av
S | 6000 | 5888
V | 8200 | 7500
O | 14000 | 13500
2023-05-02 00:00:00 | Order | Fill | Av
S | 6000 | 5888
V | 8200 | 7500
O | 14000 | 13500
2023-05-03 00:00:00 | Order | Fill | Av
S | 6000 | 5888
V | 8200 | 7500
O | 14000 | 13500
Spreadsheet: 22c255f9-deca-4c23-96fc-5211a4635019
Sheet: Sheet1

Governor and Lt. Governor - REP (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 6/20/2013 5:58:28 AM
Precincts Reporting: 604/604 - Total Ballots Cast: 92213
2004 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 0716 | 21 | 21
Precinct 0718 | 85 | 85
Precinct 0727 | 34 | 34
Precinct 0741 | 37 | 37
Precinct 0747 | 105 | 105
Precinct 0755 | 49 | 49
Precinct 0758 | 19 | 19
Precinct 0762 | 35 | 35
TOTAL | 385 | 385
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: a51d3fe4-066a-42af-8ef4-ac6166fcc4a5
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
 |  |  |  |  |  |  |  | Storebrand Forsikring |  |  | Jernbane personalets |  |  | SpareBank1 Skadeforsikring
 |  | Informasjonsfelt | Synlig | Default | Format | [NAME] (besluttet ws 2008) | [NAME] (basert på input) | [NAME] | Kan gi stopp hvis | Konsekvens 1 | [NAME] | Kan gi stopp hvis | Konsekvens 1 | [NAME] | Kan gi stopp hvis | Konsekvens 1
 | Forsikringsobjektet | Biltype | Ja |  | Nedtrekksmeny |  | OFV?(personbil, kombinertbil, varebil)
 |  | Merke | Ja |  | Nedtrekksmeny |  | OFV
 |  | Modell (årstall, motorvolum, hestekrefter) | Ja |  | Nedtrekksmeny |  | OFV
 |  | Årlig kjørelengde | Ja |  | Nedtrekksmeny |  | 6000 8000 12000 16000 20000 25000 30000 40000 50000 Ubegrenset | 8000 12000 16000 20000 25000 30000 40000 |  |  | 12000 16000 20000 Fri |  |  | 6000 8000 12000 16000 20000 25000 30000 40000 50000 Ubegrenset
 | Forsikringstaker | Bonus opptjent | Ja |  |  |  | 80% 75 % > 5 år 75 % 1-5 år 70 % 1-5 år  60 % 50 % 40 % 30 % 20 % 10 % 0 % -10 % -20 % -30 % | Ubegrenset | Malus 10 % | Ikke pris | 80% 75 % 6 år 75 % 1-5 år 70 % 1-5 år  60 % 50 % 40 % 30 % 20 % 10 % 0 % -10 % -20 % -30 %
 |  | Postnummer | Ja |  | #### |  | ####
 |  | Alder bileier (fødselsår) | Ja |  | [NAME] |  | [NAME]
 |  | Antall år bileier [NAME] | Ja |  | ## |  | ##
 | Dekningsomfang og egenandel | Ansvar | Ja |  | Radioknapp |  | Radioknapp
 |  | [NAME] | Ja |  | Radioknapp
 |  | Kasko | Ja |  | Radioknapp
 |  | Egenandel | Ja |  | Nedtrekksmeny |  | 2000 4000 6000 8000 10000 12000 14000 16000 18000 20000 30000 | 4000 8000 16000 30000 |  |  | 3000 4000 6000 |  |  | 2000 4000 7000 10000 15000
Spreadsheet: 127094d1320162430-table-query-possible-pivot-table-_____table-query-possible-pivot-table-
Sheet: Sheet1

Name | Tutor Group | Current Grade | End of Course Grade
Test A | X | A | B
Test B | V | C | B
Test C | X | B | B
Test D | V | A | B
Test E | B | A | A
Test F | X | D | C
Test G | V | C | C
Test H | V | E | D
Test I | B | C | C
Test J | X | D | C
Test K | B | C | A
Test L | B | D | C
 |  | End of Course Grade
Current Grade |  | U | E | D | C | B | A | A*
E
D
C
B
A
A*
Spreadsheet: 39036d1237249138-taking-information-from-a-database-summarybycategorykey
Sheet: Category2

Company | Category | Subcategory | Date | Cost | Budget |  | Category | 1
ABC Towing | 1 | 1 | 2000-01-01 00:00:00 | 70 | 110 |  | Subcategory | 1
 |  |  |  |  | 175 |  | Entries | 1
 |  |  |  |  |  |  | CatKey | 1-1
 |  |  | Total | 70 | 285
Spreadsheet: 861893d1709728905-productivity-calculation-prodctivity-calculation-v1
Sheet: Sheet1

 |  |  | India | UAE | Saudi Arabia | South Africa | Ghana | Total
 |  | Budget 2024 - Productivity
 |  | Budget 2024 - FTE | 162.9999999999952 | 138.9999999999949 | 93 | 105 | 184
 |  | Budget 2024 - Volume '000 | 1558.953994887098 | 1151.893697106968 | 629.590304046388 | 344.6389352155448 | 552.0240658107899
 |  | Forecast 2024 - Productivity |  |  |  |  |  |  | Same as Budget Productivity
 |  | Forecast 2024 - Productivity |  |  |  |  |  |  | New FTE Based on Forecast Volume and Budget Productivity
 |  | Forecast 2024 - Volume '000 | 1413.494920269945 | 1082.598602596717 | 593.897626976175 | 288.7416296118869 | 477.8962568906358 |  | New Volume
 |  | New FTE Country Total
 |  | New FTE based on Total Column
Spreadsheet: 829574d1684320599-function-to-find-most-common-text-based-on-criteria-function-to-find-most-common-text-based-on-criteria
Sheet: Sheet1

 | Function to Find Most Common Text Based on Criteria
 | https://www.excelforum.com/excel-formulas-and-functions/1405605-function-to-find-most-common-text-based-on-criteria.html
 | Reason for Absence | Department |  | Department | Reason for Absence | Count of Reason for Absence
 | Injury Outside Work | Production |  | Administration | Infection | 2
 | Cold/Flu | Production |  |  | Gynaecological | 1
 | Headache/Migraine | Production |  | Production | Cold/Flu | 2
 | Cold/Flu | Production |  |  | Injury Outside Work | 1
 | Cold/Flu | Research and Design |  |  | Headache/Migraine | 1
 | Cold/Flu | Research and Design |  | Research and Design | Cold/Flu | 2
 | Infection | Administration |  | Grand Total |  | 9
 | Gynaecological | Administration
 | Infection | Administration
Spreadsheet: 328454d1403900251-i-need-a-way-around-the-drag-time-owing-log
Sheet: Time Owing

 |  |  |  |  |  |  | Calculation Area
 |  |  |  |  |  |  | Time owing |  |  |  |  | I column | k column
 |  |  |  |  |  |  |  |  | base time | 16:30:00
 |  |  |  |  |  |  |  |  | [NAME] | 01:00:00
Day | Date | Column1 | [NAME] (mins) | Home | Column2 | Column3 | Daily | Decimal |  | Taken hrs
 | 2014-06-02 00:00:00 |  | 00:30:00 | 16:30:00
 |  |  | 00:00:00 | 17:00:00
 |  |  | 00:30:00 | 16:30:00
 |  |  | 00:30:00 | 16:30:00
 |  |  | 01:00:00 | 16:30:00
 |  |  | 01:00:00 | 16:30:00
 |  |  | 00:00:00 | 16:30:00
 |  |  | 00:30:00 | 17:00:00
 |  |  | 00:30:00 | 17:00:00
 |  |  | 00:30:00 | 16:30:00
 |  |  | 00:30:00 | 17:00:00
 |  |  | 00:15:00 | 17:45:00
 |  |  | 00:00:00 | 17:00:00
 |  |  | N/A | 1900-01-12 12:45:00 |  |  | 01:15:00 |  | Half days Annual leave
 |  |  | 00:30:00 | 17:00:00
 |  |  | 00:00:00 | 16:30:00
 |  |  | 01:00:00 | 16:30:00
 |  |  | 01:00:00 | 16:30:00
 |  |  | 00:30:00 | 17:00:00
 |  |  | 00:30:00 | 17:00:00
Spreadsheet: 845310d1696853530-sumproduct-with-byrow-map-index-sumproduct-with-dynarr
Sheet: SUMPRODUCT as DynArr

 |  |  |  |  |  |  |  |  |  |  |  |  | Single-
 | Total | S | M | L | XL |  | S | M | L | XL |  |  | cell fx | DA req'd here |  | not working | not working | not working | not working | not working
 |  | 5 | 4 | 1 | 4 |  | 1.04 | 0.98 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 | 10 | 4 | 4 | 1 | 1 |  | 1 | 1.01 | 0.99 | 0.99 |  |  |  |  |  | 4.703999999999999 | 4.703999999999999 | 4.703999999999999 | 4.703999999999999 | 0.4 | #N/A | #N/A | #N/A
 | 11 | 3 | 2 | 5 | 1 |  | 0.99 | 0.99 | 0.97 | 1.05 |  |  |  |  |  | 4.276363636363635 | 4.276363636363635 | 4.276363636363635 | 4.276363636363635 | 0.27 | #N/A | #N/A | #N/A
 | 12 | 2 | 4 | 2 | 4 |  | 0.98 | 1.03 | 1.03 | 1.01 |  |  |  |  |  | 3.919999999999999 | 3.919999999999999 | 3.919999999999999 | 3.919999999999999 | 0.1633333333333333 | #N/A | #N/A | #N/A
Spreadsheet: 166868d1341837024-comparing-and-marking-data-from-two-different-workbooks-agentreport2
Sheet: AgentStatusReport

Server | Domain | Is Unix | Config Group | MS | Version | Last heartbeat | Agent [NAME]
Server1 |  |  | QDB1 |  |  |  | Running
Server2 |  |  | QDB1 |  |  |  | Unknown
Server3 |  |  | QDB1 |  |  |  | Running
Server36 |  |  | QDB1 |  |  |  | Running
Server4 |  |  | QDB1 |  |  |  | Running
Server5 |  |  | QDB1 |  |  |  | Running
Server6 |  |  | QDB1 |  |  |  | Running
Server7 |  |  | QDB1 |  |  |  | Running
Server8 |  |  | QDB1 |  |  |  | Running
Server9 |  |  | QDB1 |  |  |  | Running
Server10 |  |  | QDB1 |  |  |  | Unknown
Server11 |  |  | QDB1 |  |  |  | Running
Server12 |  |  | QDB1 |  |  |  | Running
Server13 |  |  | QDB1 |  |  |  | Running
Server14 |  |  | QDB1 |  |  |  | Running
Server15 |  |  | QDB1 |  |  |  | Running
Server16 |  |  | QDB1 |  |  |  | Unknown
Server17 |  |  | QDB1 |  |  |  | Running
Server18 |  |  | QDB1 |  |  |  | Running
Server19 |  |  | QDB1 |  |  |  | Running
Server20 |  |  | QDB1 |  |  |  | Running
Server21 |  |  | QDB1 |  |  |  | Unknown
Server22 |  |  | QDB1 |  |  |  | Running
Server23 |  |  | QDB1 |  |  |  | Running
Server24 |  |  | QDB1 |  |  |  | Unknown
Server25 |  |  | QDB1 |  |  |  | Running
Server26 |  |  | QDB1 |  |  |  | Running
Server27 |  |  | QDB1 |  |  |  | Running
Server28 |  |  | QDB2 |  |  |  | Maintenance mode
Server29 |  |  | QDB2 |  |  |  | Running
Server30 |  |  | QDB2 |  |  |  | Running
Server31 |  |  | QDB2 |  |  |  | Maintenance mode
Server32 |  |  | QDB2 |  |  |  | Maintenance mode
Server33 |  |  | QDB2 |  |  |  | Maintenance mode
Server34 |  |  | QDB2 |  |  |  | Maintenance mode
Server35 |  |  | QDB2 |  |  |  | Running
Server36 |  |  | QDB2 |  |  |  | Running
Server37 |  |  | QDB2 |  |  |  | Maintenance mode
Server38 |  |  | QDB2 |  |  |  | Maintenance mode
Server39 |  |  | QDB2 |  |  |  | Maintenance mode
Server40 |  |  | QDB2 |  |  |  | Maintenance mode
Server41 |  |  | QDB2 |  |  |  | Running
Server42 |  |  | QDB2 |  |  |  | Running
Server43 |  |  | QDB2 |  |  |  | Running
Server44 |  |  | QDB2 |  |  |  | Running
Server45 |  |  | QDB2 |  |  |  | Unknown
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw |  | EOG/TW Eddy
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
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
2002-02-28 00:00:00 |  |  |  |  |  |  |  |  | 32454
2002-02-28 00:00:00
CBS Volume
 |  |  | -112209
Spreadsheet: 767858d1644679560-get-values-from-assorted-range-and-then-place-it-in-increasing-order-get-values
Sheet: Sheet1

 |  |  | 50 | 666 |  |  |  | 1000
 |  |  |  |  |  |  | 78 |  |  |  |  | 50
 |  |  |  |  | 58 |  |  |  |  | 63
 |  |  |  |  |  |  |  | 66
 |  |  |  |  |  |  |  |  | 80 |  | 22
 |  |  |  |  |  |  |  |  |  |  | 21 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | 999
Spreadsheet: 218499d1362486090-auto-filling-an-annual-leave-calendar-annual-20leave-20tracker-20draft_a-1-b
Sheet: Leave Applications

 |  | Date Requested
Name | Initials | From | Full Day/ Half Day/ Multiple Days | To  (If multiple days) | Number of days | Accepted/ Rejected/ Pending (A/R/P) | Authoriser | Comments
[NAME] | MA | 2013-01-06 00:00:00 | Multi | 2013-01-17 00:00:00 | 12 | A | Allan Davies
[NAME] | MO | 2013-04-13 00:00:00 | PM |  | 0.5 | A | Allan Davies |  |  |  |  | Multi
[NAME] | SC | 2013-01-04 00:00:00 | Multi | 2013-01-06 00:00:00 | 3 | A | Allan Davies |  |  |  |  | Full Day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mick Gentry
[NAME] | PS | 2013-05-24 00:00:00 | AM |  | 0.5 | A | Allan Davies
[NAME] | SC | 2013-08-12 00:00:00 | Full Day |  | 1 | A | Allan Davies |  |  |  |  | AM
[NAME] | SC | 2013-01-20 00:00:00 | Multi | 2013-02-04 00:00:00 | 16 | A | Allan Davies |  |  |  |  | PM
[NAME] | MO | 2013-09-01 00:00:00 | Multi | 2013-12-05 00:00:00 | 96 | A
[NAME] | SC | 2013-06-04 00:00:00 | Multi | 2013-06-06 00:00:00 | 3 | A