tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0d575341-66e2-47c5-b33b-f6b1471c0ce3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Prescribed Grazing - 528 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | ID-CPA-008
 |  | Range & Pasture Computation Worksheet |  |  |  |  |  |  |  |  | Idaho
Natural Resources Conservation Service |  |  |  |  |  |  |  |  |  |  | January 2014
 | Ranch : |  |  |  |  |  | Location :
 | Technician's Name : |  |  |  |  |  | Date :
Mangement Unit Name |  | Total Acres | Ecological Site / Forage Type |  |  |  |  |  |  | AUM's/AC | AUM's
 |  |  | Response Unit | Acres | Similarity Index | Forage Value | Total Lbs/ Acre | Harvest Efficiency | Adjustment Factors
1 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
2 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
3 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
4 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
5 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
6 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
7 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
8 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
9 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
10 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | Management Unit Total |  |  | 0
Total Acres |  | 0 | Total AUM's For Operation |  |  |  |  |  |  |  | 0
Comments:
Spreadsheet: 09b7c3ec-a6eb-484a-bdf5-f81713e21a5f
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (1 Entry):
 | 6 Test and measurement 6.4 Thermal units 6.4.2 Micro-thermographs without contact
No. | Company | Country | City | [NAME] | Hall/Booth
1 | InfraTec GmbH Infrarotsensorik und Messtechnik | Germany | Dresden | 01217 | A1.148
Spreadsheet: 854070d1704036679-choose-col-with-with-filter-choose-cols-filter-data-added
Sheet: Sheet3

 | Your expected results:
 | 1 | 75 | The  American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | 8 |  | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
 | My formula:
 |  | 75 | The American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] (Main)) | 6 | 45 | 40
 | 8 |  | #N/A | 2 | 9 | 11
 | 145 |  | #N/A | 0 | 0 | 0
 |  |  | #N/A |  | 0 | 0
 |  |  | #N/A |  | 0 | 0
 |  | 75 | The American Insurance Company Limited. | 3 | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd | 0 | 0 | 3
 | 7 | 9 | [NAME] ([NAME] ( (Main)) | 6 | 45 | 40
 | 8 | 0 | Myselfi & Associates Trading Pvt.Ltd | 2 | 9 | 11
Spreadsheet: 858404d1707121807-options-in-filter-arent-alphabetical-examplenumeric
Sheet: Blad2

Artikelgroep | ([NAME])
Artikel
46
125
0004
0005
0006
0007
0009
0014
0016
0019
0020
0021
0062
0063
0066
0072
0073
0089
0097
0098
0099
0100
0101
0105
0106
0108
(vazio)
Total Geral
Spreadsheet: 02389d1c-d165-4da5-984a-8783b32e48cb
Sheet: Degrees

Degrees
C& I meeting Date | New Degrees | [NAME] | Modification Details | [NAME] | Effective Date | Approved by AA | Date BOT approved | CO's Approval Date
2012-10-10 00:00:00 | NA | Visual Art  AA Option 2 | ART 179, 166, and 280 moved from Required to elective courses for the AA |  | 2012-09-01 00:00:00 | 2012-11-07 00:00:00
2012-10-10 00:00:00 | NA | Visual [NAME] | ART 179 and 280 moved from Required to elective courses for the AA |  | 2012-09-01 00:00:00 | 2012-11-07 00:00:00
2012-11-14 00:00:00 | NA | Music
2012-11-28 00:00:00 |  |  |  | Computer Engineering Technician AS | Spring 2013
Spreadsheet: d7269d85-279a-457c-94f4-6a068005cd73
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
5191 | 5486 | Anastasiya | Polyanskaya | RUS | 23 | 00:00:00 | 00:00:00 | 00:15:14 | 00:00:09 | [NAME] | 1 | 00:25:17
5191 | 75637 | [NAME] | Polyanskaya | RUS | 21 | 00:00:00 | 00:00:00 | 00:15:16 | 00:00:07 | 00:09:56 | 2 | 00:25:19
5191 | 6744 | [NAME] | Langit | PHI | 22 | 00:00:00 | 00:00:00 | 00:15:16 | 00:00:08 | 00:10:07 | 3 | 00:25:31
5191 | 32605 | Regina | [NAME] | AUS | 0 | 00:00:00 | 00:00:00 | 00:15:45 | 00:00:11 | 00:10:25 | 4 | 00:26:22
5191 | 31820 | [NAME] | Ying | SIN | 0 | 00:00:00 | 00:00:00 | 00:15:41 | 00:00:07 | [NAME] | 5 | 00:26:31
Spreadsheet: 152191d1335283359-listbox-item-selection-to-got-to-specific-sheet-1-excellent-forms
Sheet: Sheet1

 | a | b | c | d | e
 | 71 | 54 | 58 | 29 | 31
 | 78 | 2 | 77 | 82 | 71
 | 5 | 42 | 87 | 80 | 38
 | 97 | 88 | 6 | 95 | 37
 | 53 | 77 | 6 | 60 | 47
 | 30 | 63 | 65 | 27 | 28
 | 83 | 83 | 59 | 99 | 92
 | 23 | 70 | 99 | 25 | 54
 | 11 | 100 | 68 | 2 | 58
 | 11 | 11 | 80 | 29 | 5
 | 30 | 39 | 31 | 95 | 98
 | 41 | 28 | 17 | 17 | 65
 | 42 | 42 | 72 | 33 | 64
 | 575 | 699 | 725 | 673 | 688
Spreadsheet: 878657d1725894738-conditional-formatting-or-pivot-table-sample-workbook-2-
Sheet: May

Weekly / Monthly Spend Tracker - Total Controllable Expenses
Operating Supplies |  |  | Repair & Maintenance |  |  | Contracted Services / Other |  |  | Utilities |  |  | Week Of | SUMMARY
 |  |  |  |  |  |  |  |  | (not included in SUMMARY) |  |  |  | Total Controllable Expenses
Budget | Actual | [NAME] | Budget | Actual | [NAME] | Budget | Actual | [NAME] | Budget | Actual | [NAME] |  | Budget | Actual | [NAME]
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  | 2024-05-01 00:00:00 |  |  |  |  | [NAME] for M7, copy down to M11:
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500 |  |  |  |  |  |  |  | [NAME] for [NAME], copy down and across to columns E, H and K:
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500
2500 |  |  | 2500 |  |  | 2500 |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | **MONTH** |  | 0
Check
Vendor |  | Material |  | GL |  | Amount | PO # | PO Date | ETA | Delivered | Received | Invoiced | Invoice # | Status | Date Paid
 |  |  |  | Repair & Maintenance |  | 1000 |  |  | 2024-05-01 00:00:00
 |  |  |  | Operating Supplies |  | 2000 |  |  | 2024-05-02 00:00:00
 |  |  |  | Contracted Services / Other |  | 3000 |  |  | 2024-05-03 00:00:00
 |  |  |  | Operating Supplies |  | 4000 |  |  | 2024-05-04 00:00:00
 |  |  |  | Repair & Maintenance |  | 5000 |  |  | 2024-05-05 00:00:00
 |  |  |  | Contracted Services / Other |  | 6000 |  |  | 2024-05-06 00:00:00
 |  |  |  | Operating Supplies |  | 7000 |  |  | 2024-05-07 00:00:00
 |  |  |  | Repair & Maintenance |  | 8000 |  |  | 2024-05-08 00:00:00
 |  |  |  | Contracted Services / Other |  | 9000 |  |  | 2024-05-09 00:00:00
 |  |  |  | Operating Supplies |  | 10000 |  |  | 2024-05-10 00:00:00
 |  |  |  | Repair & Maintenance |  | 11000 |  |  | 2024-05-11 00:00:00
 |  |  |  | Contracted Services / Other |  | 12000 |  |  | 2024-05-12 00:00:00
 |  |  |  | Operating Supplies |  | 13000 |  |  | 2024-05-13 00:00:00
 |  |  |  | Repair & Maintenance |  | 14000 |  |  | 2024-05-14 00:00:00
 |  |  |  | Contracted Services / Other |  | 15000 |  |  | 2024-05-15 00:00:00
Spreadsheet: 736548d1623725699-solved-find-most-recent-valid-cell-and-return-its-value-example-3-
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: 148171d1333215354-split-name-from-1-column-to-2-names
Sheet: Sheet1

 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Rhys Ruddock
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Eoin Reddan
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Fergus McFadden
 |  | Eoin O'Malley
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: c4aa1d8a-9b9a-4ca5-9ef7-b65cc91847b8
Sheet: Total Request

Calculator Instructions:                                                                                                FOOD GROUP - FRUIT | Click on a processor name to access its calculator.  While calculator formats are different, each will help you estimate the number of pounds you will need by asking for your estimated number of servings, ect.   Note, each excel spreadsheet is restricted by food group.  While some processors offer multiple items on one calculator, your request will only populate on the Total Request tab if it is within the food group listed on that spreadsheet.  You will need to pull up the beef spreadsheet to allocate beef pounds, the chicken calculator to allocate chicken pounds, ect.
 | The calculator will automatically calculate the number of pounds you will need for a specific item, and will input that number on the Total Request tab.  Once finished, take the numbers in yellow and transfer them to your NOI Request Form.  Be sure you are inputting the correct number of pounds for each processor.  The processor number on this form should match the processor number on the NOI Request Form.
Processor | Broker | Contact | Material | [NAME] | USDA Value | Total Value
52. AdvancePierre (apple) | Elite Foodservice | [NAME] | 100208 |  | 0.686
53. AdvancePierre (peach) | Elite Foodservice | [NAME] | 100219 |  | 0.5994
54. AdvancePierre (pear) | Elite Foodservice | [NAME] | 100224 |  | 0.6667
55. Citrus Systems (orange) | GVM Food Marketing | [NAME] | 100204 |  | 2.2474
56. Horizon Foods (apple) | Advantage Waypoint | [NAME] | 100258 |  | 0.7219
57. Horizon Foods (cherry) | Advantage Waypoint | [NAME] | 100237 |  | 0.8626
 |  |  |  |  | Total Value:
Spreadsheet: 887184d1737400747-copying-similar-data-from-multiple-sheets-onto-one-summary-sheet-how-to-quickly-and-easily-test1
Sheet: Sheet3

INFORMATIONAL CERTIFICATE
PUT Type: | RTD
PUT Tag No.: | 281-TE-5712F-A
Tolerance: | Class A
Calib. Ambient Temp. | 22
Calib. Date: | Dec. 02 2024
Actual Temperature (°C) | PUT Output (Ohms) | PUT Output (°C) | Deviation from Actual (°C) | Acceptable Tolerance (°C)
-0.49 | 99.914 | -0.22 | 0.27 | 0.13
NOTES:  PUT = Probe Under Test PRT = Platinum Resistance Thermometer
All calibrations are based on ITS-90 temperature scale.
Approved by:
Performed by:
TV
00506, Rev.8, 2013-08-30, 1/1
Spreadsheet: eric_linder__9655__4_02act
Sheet: EPEData

 | 37080.48541666667
 | NEWMAN 1 ,MANL, 31  , 65  , 37  , 78  ,  0  ,1
 | NEWMAN 2 ,ECON, 52  , 77  , 37  , 83  , 26  ,1
 | NEWMAN 3 ,ECON, 94  , 95  , 37  ,103  ,  1  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,ECON,100  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,205  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 277 ,  337,  172, 371 ,  27 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,MANL, 38  , 40  , 28  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 32  , 32  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 49  ,100  , 45  ,151  ,  0  ,1
 | RIOGRANDE,, 119 ,  172,  103, 248 ,   0 ,
 | PALOVERDE,MANL,395  ,395  ,395  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 44.34,  618,  626,   89,    6,    0,21911,91
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 852577d1702563083-bonus-points-in-a-league-table-penang-league-aligw
Sheet: Fixtures

Competition Fixtures |  |  |  |  |  |  |  |  |  | Teams: | 6
Round | Match | Home Team | Score |  | Score | Away Team | Ground |  |  | Games Against Each Other: | 2
 |  |  | 5 |  | 0 |  |  |  |  | Team Number | Club Name | Home Ground
 |  |  | 1.5 |  | 3.5 |  |  |  |  |  | Blackmoor | [NAME]
 |  |  | 5 |  | 0 |  |  |  |  |  | Basingstoke | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Burhill | Burhill GC
 |  |  |  |  |  |  |  |  |  |  | Camberley Heath | Camberley Heath GC
 |  |  | 2.5 |  | 2.5 |  |  |  |  |  | West Byfleet | West Byfleet GC
 |  |  |  |  |  |  |  |  |  |  | West Surrey | West Surrey GC
 |  |  | 2 |  | 3
 |  |  | 5 |  | 0
 |  |  | 5 |  | 0
 |  |  | 2 |  | 3
 |  |  | 1 |  | 4
 |  |  | 3.5 |  | 1.5
 |  |  | 2 |  | 3
 |  |  | 2.5 |  | 2.5
 |  |  | 0 |  | 5
 |  |  | 3 |  | 2
Spreadsheet: 57474d1257645165-entering-mathematical-formula-formula
Sheet: Sheet1

 |  |  |  |  | V | [NAME]^2))[G4+G5-(G5cosI6+SQRT(G4^2-G5^2sin^2I6)]
 |  |  |  |  | VCC | 8
 |  |  |  |  | B | 4
 |  |  |  |  | L | 0
 |  |  |  |  | T | 0
 |  |  |  |  | 0 | 180 | 0 |  | Replace 0 with increments of 5 up to 540 degrees.
 |  |  |  |  |  | This is the basic layout of your formular, however I'm not sure of the placement
 |  |  |  |  |  | of all the brackets. Bacially, you'll need to establish a cell location for each input
 |  |  |  |  |  | value to the formula. For example V, Vcc, B,L, and T are input values that maybe
 |  |  |  |  |  | will change. I would make sure the first part, everything before the first square bracket,
 |  |  |  |  |  | of the formula calculates correctly, then I would work on the other parts.
 |  |  |  |  |  | The above formular is not exactly correct, but is only what I think your approach
 |  |  |  |  |  | should be. If you try to use this in a work sheet, be sure to remove the ' from before
 |  |  |  |  |  | the equal sign. The red 0 is suppose to be your symbols with the line through middle.
 |  |  |  |  |  | These probaby should have cell locations too for (i.e.
 |  |  |  |  |  | You may need to seperately calculate "cos" and "sin" and replace them in the
 |  |  |  |  |  | formolar above with the cell reference of their results on you worksheet.
 |  |  |  |  |  | Remember test each section of the formula seperately to besure it calculate correctly
 |  |  |  |  |  | [NAME]
Spreadsheet: 37196d1235141230-add-numbers-which-have-a-string-summing-number-with-text-atached-array
Sheet: Sheet1

Name | Pay Frequency | 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 | Total S | Total A
[NAME] | Weekly | 8A |  |  |  |  |  |  |  | 4S |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8S |  |  |  |  | 12 | 8
[NAME] | Weekly |  |  |  | 8A | 8A | 8A | 8A |  |  |  |  |  | 8S | 8S | 8S | 8S |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 40
 | How do I  automatically add up a string
S stands for Sick leave
A means Annual leave
Spreadsheet: 754536d1636305740-finding-values-and-blanks-in-a-range-book1
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
1 |  |  |  |  |  | 7 |  |  |  |  | 1 | A | 3 | B | 5 | C | 7 | F
1 |  |  | B |  |  |  |  |  |  |  | 2 | C | 2 | 6 | G | 5 | M
1 |  |  |  |  |  |  | F |  |  |  | 3 |  | R | 2 | 1
1 | A |  |  |  |  |  |  |  |  |  | 4 | 4 | T | 8 |  | D |  |  | 7
1 |  |  |  | 5
1 |  | 3
1 |  |  |  |  | C
2
2 |  | 2
2
2 | C
2 |  |  |  |  |  | M
2 |  |  |  | G
2
2 |  |  | 6
2 |  |  |  |  | 5
2
2
3 |  |  | 2
3 |  | R
3 |  |  |  | 1
3
4
4 | 4
4
4 |  |  | 8
4 |  | T
4 |  |  |  |  | D
4 |  |  |  |  |  |  |  | 7
4
Spreadsheet: 221442d1363553142-need-several-values-to-line-up-to-return-a-specific-value-need-formula-help-please-book1
Sheet: Sheet1

Conf.dt. | Conf.t. | Time Between Scans | Team | Day of Week | Shift # | AM or PM |  | Sunday | 1 | 2 |  | Day of Week | Time | AM / PM | Shift #
2012-04-29 00:00:00 | 04:15:16 | 00:00:00 | Red | Sunday |  | PM |  | Monday | 3 | 4 |  | Sunday | 06:00:00 | AM | 1
2012-04-29 00:00:00 | 04:18:35 |  | Red | Sunday |  | PM |  | Tuesday | 5 | 6 |  | Sunday | 06:00:01 | AM | 1
2012-04-29 00:00:00 | 07:19:07 |  | Blue | Sunday |  | AM |  | Wednesday | 7 | 8 |  | Sunday | 06:00:02 | AM | 1
2012-04-29 00:00:00 | 07:20:43 |  | Blue | Sunday |  | AM |  | Thursday | 9 | 10 |  | Sunday | 06:00:03 | AM | 1
 |  |  |  |  |  |  |  | Friday | 11 | 12 |  | Sunday | 06:00:04 | AM | 1
Note that April 29th, 2012 was a Saturday PM shift that started at 1800hrs |  |  |  |  |  |  |  | Saturday | 13 | 14 |  | Sunday | 06:00:05 | AM | 1
and so should actually be shift 14. |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:06 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:07 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:08 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:09 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:10 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:11 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | Sunday | 06:00:12 | AM | 1
 |  |  |  |  |  |  |  |  |  |  |  | This list actually lists every second of all 14 shifts
 |  |  |  |  |  |  |  |  |  |  |  | I thought I could figure out a formula using this
 |  |  |  |  |  |  |  |  |  |  |  | but I'm lost!
Spreadsheet: 96816d1296096328-ranking-rankaftersort
Sheet: Sheet1

Family No | Other | Rank
9 |  | 1 |  | Sort first by column A
9 |  | 2
9 |  | 3 |  | Then use the formula in column c
9 |  | 4
10 |  | 1
10 |  | 2
10 |  | 3
10 |  | 4
11 |  | 1
Spreadsheet: stacey_white__38974__5 day idea
Sheet: Sheet1

 |  |  |  |  | 2002-07-05 00:00:00
Date | NE | MW | SE | ERCOT
2002-06-25 00:00:00 | 10 | 20 | 30 | 40
2002-06-26 00:00:00 | 20 | 30 | 40 | 50
2002-06-27 00:00:00 | 30 | 40 | 50 | 60
2002-06-28 00:00:00 | 40 | 50 | 60 | 70 | 5 day rolling P&L | NE | MW | SE | ERCOT
2002-06-29 00:00:00 | 50 | 60 | 70 | 80
2002-06-30 00:00:00 | 60 | 70 | 80 | 90
2002-07-01 00:00:00 | 70 | 80 | 90 | 100
2002-07-02 00:00:00 | 80 | 90 | 100 | 110
2002-07-03 00:00:00 | 81 | 100 | 110 | 120
2002-07-04 00:00:00 | 82 | 110 | 120 | 130
2002-07-05 00:00:00 | 83 | 120 | 130 | 140 | 5 day rolling P&L
 |  |  |  |  |  | Link to these numbers on the P&L page
Spreadsheet: kate_symes__18948__New Notification Report 0101
Sheet: Apr 2001

 |  |  |  | Notes: | All Dates Are in mm/dd/yy format
APRIL 2001 |  |  |  |  | N/C = No Change
 |  |  |  |  | See "Changes"  Worksheet for short list of new changes
 |  | Former Counterparty Data |  |  |  |  | Updated Counterparty Data |  |  |  |  | GCP Updated On |  |  |  | [NAME] Use Only
Change Type | Legal Eff. Date | Name | BA ID | CP ID | Short Name | Inactivation Date | Name | BA ID | CP ID | Short Name | Comments | Name | Shortname | Inactivation |  | Notification Date
Name Overlay | 2001-03-05 00:00:00 | [NAME] | 67064 | 1518 | PAINEWEBBERORP | N/A | UBS PaineWebber Inc. | N/C | N/C | UBSPAIWEB | Have SOS Certificate and Certificate of Amendment in hand. | 2001-03-27 00:00:00 | 2001-03-30 00:00:00 | N/A |  | 2001-03-27 00:00:00
Name Overlay | 1998-07-16 00:00:00 | Waste Management, Inc | 55990 | 55990 | WASTEMAN | N/A | Waste Management Holdings, Inc. | N/C | N/C | N/C | Have Certificate of Amendment in hand. | 2001-03-27 00:00:00 | N/A | N/A |  | 2001-03-27 00:00:00
Spreadsheet: 679392d1590396105-sum-cells-based-on-other-cells-in-their-row-book1
Sheet: Sheet1

value | name | name | name | name | name
1 | a | b | c | d | e
2 | b | d
3 | a | e | c
2 | a | b | e | c
5 | e | d | c | b | a
6 | b
7 | e
1 | c | e | b
3 | a | b
4 | a
Spreadsheet: 76779d1277272112-return-data-based-on-date-test-file
Sheet: BASs and IASs to be Lodged

2010-06-23 00:00:00
[NAME] |  | [NAME] |  | Monthly
ZYX Pty Ltd |  | [NAME] |  | Monthly
YZX Pty Ltd |  | [NAME] |  | Monthly
123 Pty Ltd |  | IAS |  | Quarterly
911 Pty Ltd |  | IAS |  | Quarterly
777 Pty Ltd |  | IAS |  | Quarterly
380 Engineering Pty Ltd |  | IAS |  | Quarterly