tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 867856d1714642357-network-days-formula-not-handling-cases-when-start-date-is-weekend-calculating-time-duration-in-between-working-hours
Sheet: Start and end times

A | B | C |  |  | St time | End time |  |  |  |  |  | Holidays
2024-06-23 07:48:30 | 2024-06-24 09:09:11 |  |  |  | 08:00:00 | 18:00:00 |  |  |  |  |  | 2023-05-07 00:00:00
2024-06-22 07:48:30 | 2024-06-22 09:09:11 |  |  |  |  |  |  |  |  |  |  | 2023-08-05 00:00:00
2024-06-27 07:48:30 | 2024-06-29 09:09:11
2024-06-27 07:48:00 | 2024-06-27 09:09:11
2024-06-20 17:48:30 | 2024-06-29 09:09:11
2024-06-18 12:30:00 | 2024-06-23 09:30:00
2024-06-20 12:30:00 | 2024-06-24 09:30:00
2024-05-10 07:48:30 | 2024-05-13 07:09:11
 |  | =IF(AND($A9>0;$B9>0);IF(INT($B9)=INT($A9);IF(NETWORKDAYS($A9;$A9;$M$2:$M$3)>0;(WEEKDAY($A9;2)<6)*(MEDIAN($F$2;$G$2;ROUND(MOD($B9;1);6))-MEDIAN($F$2;$G$2;ROUND(MOD($A9;1);6)));0);(NETWORKDAYS($A9;$A9;$M$2:$M$3)>0)*($G$2-MAX($F$2;ROUND(MOD($A9;1);6)))+(NETWORKDAYS($B9;$B9;$M$2:$M$3)>0)*(MIN(ROUND(MOD($B9;1);6);$G$2)-$F$2)+IF((INT($B9)-INT($A9))>1;NETWORKDAYS($A9+1;$B9-1)*($G$2-$F$2);0));"") | =IF(AND(A2>0;B2>0);MAX(0;MIN(INT(A2)+G$2;B2)-WORKDAY(A2-1;1;M$2:M$3)-MAX(A2-INT(A2);F$2))+MAX(0;NETWORKDAYS(WORKDAY(A2;1;M$2:M$3);WORKDAY(B2;-1;M$2:[NAME]:M$3))*(G$2-F$2)+IF(INT(A2)=INT(B2);0;MAX(0;MIN(INT(B2)+G$2;B2)-WORKDAY(B2-1;1;M$2:M$3)-F$2));"")
[NAME] length:
comparision
Spreadsheet: fc6a74c8-a2cc-46de-929c-929f55b864ae
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HEVG | Test | HEVG | Hepatitis E Virus IgG Antibody, Serum | HEV [NAME], S | Enzyme Immunoassay (EIA)-Screening Procedure | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel	 Submission Container/Tube: Plastic vial [NAME]: 0.5 mL | 0.1 mL | Hemolysis	Mild OK; [NAME]; OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative | Tuesday, Friday; Varies | 5 days | 9 days | 1 | 86790 |  |  |  |  | Rochester
HEVG | [NAME] | SST | Serum SST |  |  |  | Frozen
HEVG | Result | 86211 | HEV [NAME], S | HEV [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1530670c-73cb-47b1-8266-396da68759cb
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 2. HOUSING AND PERSONAL FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Housing Finance - Banks ; |  |  | Original | A2437051V | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Housing Finance - Permanent building societies ; |  |  | Original | A2437052W | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Housing Finance - Wholesale lenders n.e.c. ; |  |  | Original | A2437053X | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Housing Finance - Other lenders ; |  |  | Original | A2437054A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Housing Finance - Total ; |  |  | Original | A2437055C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Personal Finance - Banks ; |  |  | Original | A2437046A | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Personal Finance - Credit co-operatives ; |  |  | Original | A2437047C | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Personal Finance - Finance companies ; |  |  | Original | A2437048F | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Personal Finance - Other lenders ; |  |  | Original | A2437049J | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2437050T | 1985-01-01 00:00:00 | 2011-06-01 00:00:00 | 318 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 605830d1547305386-extract-results-in-a-row-from-a-formula-extract-values-from-count-formula
Sheet: Sheet2

 |  |  |  |  |  |  |  | 2 |  | 1
 |  |  |  |  |  |  |  | 1 |  | 1
 | + |  |  | 2 |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  | 1 |  | 2
 |  |  |  |  |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  | 2 |  | 0 |  |  |  |  |  |  |  | example: in I:I there are only 1 and 2 number ,at J1 there is a formula which counts a cetrain event,at K:K I need to extract the counting results of J1
 |  |  |  |  |  |  |  | 2 |  | 0
 |  |  |  |  |  |  |  |  | I want in  K:K a history of the counts of J1
Spreadsheet: eric_saibi__9951__110601R
Sheet: Moss Landing 07

Owner Name |  | Duke Energy Moss Landing LLC
Station Name |  | Moss Landing Power Station
Unit Name |  | Unit 07
NERC Region |  | WSCC
State |  | CA
Fuel Type |  | Natural Gas
Capacity |  | 812 MW
Start Date |  | 2001-09-28 00:00:00
End Date |  | 2002-04-28 00:00:00
Prv. Start Date |  | 2001-12-07 00:00:00
Prv. End Date |  | 2002-01-17 00:00:00
Comments |  | Turb/Boiler/SCR
SIC |  | 4931
Plant ID |  | 1011212
Unit ID |  | 1005367
Outage ID |  | 8919
Spreadsheet: tracy_geaccone__40277__Non recurring Q3 2001-asset sales
Sheet: Madera

Madera Ranch
Pro Forma Loss Calculation
(In millions of US$)
Cash Consideration Received |  |  |  |  |  | 11 |  | 141.5
Less Transaction Costs (estimated) |  |  |  |  |  |  |  | -3
Outcome of Consideration placed in Escrow |  |  |  |  |  | 0 |  | -10
Net Consideration Received
Cost Basis:
 | Azurix's Equity Investment at 7/31/01 |  |  | 35.2
 | Loans to Madera to be contributed at closing |  |  | 0
 | Capitalized interest recorded at Azurix Corp. |  |  | 5.8
 | Additional funds to be invested or loaned to Madera
 | 8/1/01 - closing date |  |  | 0
 | Intercompany net receivables from Madera to be
 | contributed at closing |  |  | 0
 | Equity earnings/(loss) from 8/1/01 - closing date |  |  | 0
Total Cost Basis
Working Capital Adjustment |  |  |  |  |  | 0 |  | 0
Debt Adjustment |  |  |  |  |  | 0
Pre-Tax Loss
Tax Loss on 338H-10 Election (estimated) |  |  |  |  |  | 0 |  | 28.2
Pro Forma Azurix Loss on Sale
Spreadsheet: 149304d1333823511-merge-data-from-two-columns-in-to-one-test
Sheet: Sheet1

Data-1 | Data-2 | Result
Rows("1:1").RowHeight = | 2.25 | Rows("1:1").RowHeight = 2.25
Rows("2:2").RowHeight = | 12.8
Rows("3:3").RowHeight = | 1.95
Rows("4:4").RowHeight = | 12.8
Rows("5:5").RowHeight = | 1.95
Rows("6:6").RowHeight = | 12.8
Rows("7:7").RowHeight = | 1.95
Rows("8:8").RowHeight = | 12.8
Rows("9:9").RowHeight = | 1.95
Rows("10:10").RowHeight = | 12.8
Rows("11:11").RowHeight = | 1.95
Rows("12:12").RowHeight = | 12.8
Rows("13:13").RowHeight = | 1.95
Rows("14:14").RowHeight = | 12.8
Rows("15:15").RowHeight = | 1.95
Rows("16:16").RowHeight = | 12.8
Rows("17:17").RowHeight = | 1.95
Rows("18:18").RowHeight = | 12.8
Rows("19:19").RowHeight = | 1.95
Rows("20:20").RowHeight = | 12.8
Rows("21:21").RowHeight = | 1.95
Rows("22:22").RowHeight = | 12.8
Rows("23:23").RowHeight = | 1.95
Rows("24:24").RowHeight = | 12.8
Rows("25:25").RowHeight = | 1.95
Rows("26:26").RowHeight = | 12.8
Rows("27:27").RowHeight = | 1.95
Rows("28:28").RowHeight = | 12.8
Rows("29:29").RowHeight = | 1.95
Rows("30:30").RowHeight = | 12.8
Rows("31:31").RowHeight = | 1.95
Rows("32:32").RowHeight = | 12.8
Rows("33:33").RowHeight = | 1.95
Rows("34:34").RowHeight = | 12.8
Rows("35:35").RowHeight = | 13.42
Page:2
Rows("36:36").RowHeight = | 2.25
Rows("37:37").RowHeight = | 12.8
Rows("38:38").RowHeight = | 1.95
Rows("39:39").RowHeight = | 12.8
Rows("40:40").RowHeight = | 1.95
Rows("41:41").RowHeight = | 12.8
Rows("42:42").RowHeight = | 1.95
Rows("43:43").RowHeight = | 12.8
Rows("44:44").RowHeight = | 1.95
Rows("45:45").RowHeight = | 12.8
Rows("46:46").RowHeight = | 1.95
Rows("47:47").RowHeight = | 12.8
Rows("48:48").RowHeight = | 1.95
Rows("49:49").RowHeight = | 12.8
Rows("50:50").RowHeight = | 1.95
Rows("51:51").RowHeight = | 12.8
Rows("52:52").RowHeight = | 1.95
Rows("53:53").RowHeight = | 12.8
Rows("54:54").RowHeight = | 1.95
Rows("55:55").RowHeight = | 12.8
Rows("56:56").RowHeight = | 1.95
Rows("57:57").RowHeight = | 12.8
Rows("58:58").RowHeight = | 1.95
Rows("59:59").RowHeight = | 12.8
Rows("60:60").RowHeight = | 1.95
Rows("61:61").RowHeight = | 12.8
Rows("62:62").RowHeight = | 1.95
Rows("63:63").RowHeight = | 12.8
Rows("64:64").RowHeight = | 1.95
Rows("65:65").RowHeight = | 12.8
Rows("66:66").RowHeight = | 1.95
Rows("67:67").RowHeight = | 12.8
Rows("68:68").RowHeight = | 1.95
Rows("69:69").RowHeight = | 12.8
Rows("70:70").RowHeight = | 13.42
Spreadsheet: 083e82e0-acbd-472b-9e97-a570d0afd6b8
Sheet: Sheet1

CENTRAL NEW JERSEY COUNCIL, BSA | 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
Course Title
District |  |  |  |  |  |  |  |  |  | Course Code:
 | Location
Who is Course For
 |  |  | Date(s)
 |  |  | Time
Cost per Person |  |  |  | $ |  |  | if received in Council by:
Pre-Requisites/Notes
Questions? Contact: |  |  |  |  |  |  |  |  |  | at
Refund Policy:  There are no refunds for any activity, training, or program whose individual fee is $10 or less. (Example: If the fee per participant is $10 and a unit submits payment for five participants, there would be no refund available.)  For individual fees greater than $10, 80% will be refunded if received 2 weeks prior to the date of the activity, training, or program.  All cancellation / refund requests MUST be made in writing, be submitted to the Office Manager, and state the reason for the cancellation (e-mail communication is acceptable).  The full policy is available on the Council's website.
Returned Check Policy:  It is the policy of this Council to assess a penalty in the amount of $25 for insufficient funds when a check is returned to the Council.  A letter from the Accounting Specialist is issued to inform the submitter of the returned check advising them another form of payment (money order, cashier’s check, or credit card) including the $25 should be submitted.  The full policy is available on the Council's website.
CNJC cannot accept payment by credit card on total fees less than $20.
Course Title |  |  |  | 0
District |  |  |  | 0 |  |  |  |  |  | Course Code: |  |  |  |  |  | 0
Location |  |  |  | 0
 |  |  |  | 0
Who is Course For |  |  |  | 0
Date(s) |  |  |  | 0
Time |  |  |  | 0
Cost per Person |  |  |  | $ | 0 |  | if received in Council by: |  |  |  |  |  | 00:00:00
Participant's Name
Street
City |  |  |  |  |  |  |  | , NJ |  | Zip |  |  |  | -
 | E-mail |  |  |  |  |  |  |  |  | Phone
 |  | (Primary method of communication.)
 |  | Leadership Position |  |  |  |  |  |  | Troop |  | Pack |  |  | Crew |  | Unit #
Submit early registration fee only if paid and submitted to Council by: |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Make checks payable to: |  |  |  | CNJC, BSA |  |  |  |  |  | $ |  |  |  |  | Total Submitted
 |  | Send to: |  | 2245 US Hwy 130, Suite 106
 |  |  |  | Dayton, NJ  08810-2420
Spreadsheet: 761454d1640909218-vlookup-of-sorts-steve1
Sheet: Sheet1

 | GREEN | 17 | 40
 | YELLOW | 1 | 42
 | RED | 2 | 38
 | MAGENTA | 3 | 44
 | CYAN | 4 | 46
 | CYAN | 9 | 48
 | CYAN | 10 | 36
 | CYAN | 11 | 42
 | CYAN | 18 | 40
 | CYAN | 19 | 40
 | CYAN | 20 | 42
 | CYAN | 21 | 38
 | CYAN | 22 | 44
 | CYAN | 23 | 46
 | CYAN | 24 | 48
 | CYAN | 5 | 36
 | CYAN | 6 | 42
 | CYAN | 7 | 40
 | CYAN | 8 | 40
 | CYAN | 12 | 42
 | CYAN | 13 | 38
 | CYAN | 14 | 44
 | BLACK | 15 | 46
 | PURPLE | 16 | 46
24
23
22
21
20
19
18
17 |  |  | GREEN
16
15
14
13
12
11
10
9
8
7
6
5
4
3 |  |  |  |  | MAGENTA
2 |  | RED
1 |  |  |  | YELLOW
 | 36 | 38 | 40 | 42 | 44 | 46 | 48
 | ABOVE - YELLOW IN [NAME] IS THERE BECAUSE C3=D52 SO PASTE B2 INTO [NAME]
 | RED IN C51 AS C4=[NAME] PASTE TO C51
 | ETC
 | needing formula for each cell -  b29 down and across h52
Spreadsheet: 709156d1608192216-google-sheets-filter-multiple-login-and-logout-login-out
Sheet: Sheet1

 |  |  | Login | LogOut
Agent 1 | 12/15/20 4 AM | Login
Agent 1 | 12/15/20 5 AM | LogOut
Agent 2 | 12/15/20 6 AM | Login
Agent 2 | 12/15/20 7 AM | LogOut
Agent 1 | 12/15/20 8 AM | LogIn
Agent 2 | 12/15/20 4 AM | Login
Agent 2 | 12/15/20 5 AM | LogOut
Agent 2 | 12/15/20 6 AM | Login
Agent 1 | 12/15/20 7 AM | LogOut
Agent 1 | 12/15/20 8 AM | LogIn
Spreadsheet: 857772d1706689744-20-day-look-back-from-last-entry-20-day-lookbackdone
Sheet: LOOKBACK

List of Unique Dates (descending) |  |  | No of days to look back | 5
 |  |  | [NAME] | Min
Spreadsheet: 648199d1572932699-how-to-find-the-value-of-a-product-or-aggregation-according-to-its-sum-product-value
Sheet: Sheet1

 |  |  |  |  |  |  | VALUE CODE | PRODUTS
 |  |  |  |  |  |  | 1060 | GREEN PLATES
 |  |  |  |  |  |  | 66 | ORANGE PLATES
 |  |  |  |  |  |  | 293 | YELLOW PLATES
 |  |  |  |  |  |  | 129 | RED PLATES
 |  |  |  |  |  |  | 1061 | PURPLE PLATES
 |  |  |  |  |  |  | 131 | SILICON PLATES
 |  |  |  |  |  |  | 731 | INDIGO
 |  |  |  |  |  | ENTER CODE |  | 1255
 |  |  |  |  |  | ALL PRODUCT MATCHED |  | GREEN PLATES, ORANGE PLATES,RED PLATES
 |  |  |  |  |  |  |  | ANSWER SHOULD BE IN I13 AS SHOWN
 |  |  |  |  |  |  |  | because aggregation 1060+66+129 equal to 1255
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 45

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
45 | 2007-02-16 00:00:00 | 7.8 | 1.42 | 8.6 | 3.5 | 2.8 | 2.4 |  |  |  | 11.5 |  | 1.609886808812993 | 1.3 | 0 | 10 |  |  |  |  | 0.6
Well #45 | 2013-10-11 00:00:00 | 6 | 1.51 | 7.72 | 3.09 | 3.5 | 0.7 |  |  | 4.8 | 8.9 |  | 1.5 | 2.5 | 0.05 | 6.1 |  | <0.10 | <0.02 |  | -1.7
Well - 45 | 2014-02-05 00:00:00 | 7.6 | 2.16 | 11.33 | 4.52 | 4 | 4.5 |  |  | 1 | 15.9 |  | 1.4 | 3.7 | 0.05 | 7.2 |  | <0.10 | <0.02 |  | 0.9
Well 45 | 2015-04-02 00:00:00 | 7.6 | 2.01 | 11.55 | 4.81 | 4.3 | 4.5 |  |  | 1 | 15.3 |  | 1.5 | 3.9 | <0.05 | 7.7 |  | <0.10 | <0.02 |  | 0.8
Well 45 | 2017-05-03 00:00:00 | 7.43 | 1.949 | 12.1 | 4.6 | 4.62 | 3.678762688833826 | 3.678762688833826 | 0 | 2.52 | 9.1739 | 1247 | 1.6 | 3.83 | 0.035 | 0.03523000000000001 | 0 | 0.487 | 0.215 | 0.019
W45 | 2018-05-29 00:00:00 | 7.95 | 2.306 | 13.9 | 5.64 | 5.28 |  | 4.639916873151627 | 0 | 1.34 | 12.553 | 1475.84 |  |  | 0.04 | 8.518 | 0.064 | 0 | 0 | 0.006
Spreadsheet: 883486d1732103993-use-the-other-formula-instead-of-vlookup-formula-index_match-for-vehicle-duty-slip
Sheet: data

date | epi# | name | design | slip no. | date | date end | start time | end time | type | reg# | make | capacity | start reading | end reading | Total | PLACE | PURPOSE
2024-11-12 00:00:00 | 0001-01 | Mr.[NAME] | Director | x | 12.11.2024 |  | 11:05:00 | 12:05:00 | Van | ABC-1234 | [NAME] | 800cc | 6800 | 6810 |  | Godown | Site visit
2024-11-11 00:00:00 | 0001-10 | Mr.[NAME] | Manager | y | 11.11.2024 |  | 11:40:00 | 16:40:00 | Toyota [NAME] | LED-8556 | Toyota | 3000CC | 115056 | 115080 |  | Factory | Check the material
2024-11-13 00:00:00 | 0001-09 | Mr.[NAME] | Sr.Manager | 5 | 11.11.2024 | 11.11.2024 | 10:30:00 | 12:30:00 | Car | EFC-1235 | Toyota | 1300CC | 7000 | 7035 |  | Market | For material price verification
Spreadsheet: 264247d1378828527-extracting-and-sorting-data-from-source-worksheet-excel-2003-top-5-autosort-revised
Sheet: Top 5 By Division

 | Note:
 | Shorter name on [NAME] for easier linking to other Worksheets
 |  |  |  |  |  |  |  |  |  |  |  | Maint
Match | Priority | Installation Name | Installation Number | Fiscal Year | Building Number | Yr Built | [NAME] | FCG | GSF | Q-Rating | F-Rating | DOL Division | Construction Type | HDR Assigned WO Number | Project/WO Number | Project Title/Short Job Description | Purpose Code | Purpose Points | Condition Code | Condition Points | Component Code | Group | Component Points | Project MCI | Building MCI | Total Points | Total Points (Hard Code) | Cost Estimate (ROM) | Funding Source | Comments
1
 |  |  |  |  |  |  |  |  |  |  |  | PO
Match | Priority | Installation Name | Installation Number | Fiscal Year | Building Number | Yr Built | [NAME] | FCG | GSF | Q-Rating | F-Rating | DOL Division | Construction Type | HDR Assigned WO Number | Project/WO Number | Project Title/Short Job Description | Purpose Code | Purpose Points | Condition Code | Condition Points | Component Code | Group | Component Points | Project MCI | Building MCI | Total Points | Total Points (Hard Code) | Cost Estimate (ROM) | Funding Source | Comments
1
 |  |  |  |  |  |  |  |  |  |  |  | SS
Match | Priority | Installation Name | Installation Number | Fiscal Year | Building Number | Yr Built | [NAME] | FCG | GSF | Q-Rating | F-Rating | DOL Division | Construction Type | HDR Assigned WO Number | Project/WO Number | Project Title/Short Job Description | Purpose Code | Purpose Points | Condition Code | Condition Points | Component Code | Group | Component Points | Project MCI | Building MCI | Total Points | Total Points (Hard Code) | Cost Estimate (ROM) | Funding Source | Comments
1
 |  |  |  |  |  |  |  |  |  |  |  | Trans
Match | Priority | Installation Name | Installation Number | Fiscal Year | Building Number | Yr Built | [NAME] | FCG | GSF | Q-Rating | F-Rating | DOL Division | Construction Type | HDR Assigned WO Number | Project/WO Number | Project Title/Short Job Description | Purpose Code | Purpose Points | Condition Code | Condition Points | Component Code | Group | Component Points | Project MCI | Building MCI | Total Points | Total Points (Hard Code) | Cost Estimate (ROM) | Funding Source | Comments
1
Spreadsheet: 740443d1626343385-increasing-the-reference-row-in-a-series-of-random-formulas-by-one-demo
Sheet: 2021-22 Q1

Performance Indicator | Current Year Q1 | Last Year Q1 | Q1 Ave Past 5 Years |  |  | Column BCD Formulas | Column BCD Formulas | Column BCD Formulas |  |  |  | Q2 Sheet
Measure 1 |  |  |  |  |  |  |  |  |  | The objective is to increment the formulas by 1 row on theQ2 Q3 Q4 sheets so that on the Q2 sheet measure 1 is:
Measure 2
Measure 3
Measure 4
Measure 5
Measure 6
Measure 7 |  |  |  |  |  |  |  |  |  |  | #=Preventing!B3 | #=Preventing!c3 | #[NAME]Preventing!d3
Measure 8 |  |  |  |  |  |  |  |  |  | and on Q3 sheet | #=Preventing!B4 | #=Preventing!c4 | #=Preventing!d4
Measure 9 |  |  |  |  |  |  |  |  |  | And so on
Measure 10
Measure 11
Measure 12
Measure 13
Measure 14 | n/a | n/a | n/a
Measure 15
Measure 16
Measure 17
Measure 18
Measure 19
Measure 20
Measure 21
Measure 22
Measure 23
Measure 24
Measure 25
Measure 26
Measure 27
Measure 28
Measure 29
Measure 30
Measure 31
Measure 32
Measure 33
Measure 34
Measure 35
Measure 36
Measure 37
Measure 38
Measure 39
Measure 40
Measure 41
Measure 42
Measure 43
Measure 44
Measure 45
Measure 46
Measure 47
Measure 48
Measure 49
Measure 50
Measure 51
Measure 52
Measure 53
Measure 54
Measure 55
Measure 56
Measure 57
Measure 58
Measure 59
Measure 60 | 0.8328 | n/a | n/a
Spreadsheet: 763843d1642428147-what-formula-will-pick-the-value-from-the-colored-font-cell-need-help
Sheet: Sheet1

 |  |  |  |  | BM | ZM
20 | - | 5 | 10 | B000001FK3
7 | - | 8 | 10 | B00000DCH2
10 | - | 5 | 10 | B000024LSD
20 | - | 7 | 10 | B000025AZ7
20 | - | 5 | 10 | B0000265PW
20 | - | 5 | 10 | B00002MV0W
20 | 6 | 3.64 | - | [NAME]
20 | - | 5 | 10 | B000058USU
20 | 5 | 3.68 | - | [NAME]
20 | - | 5 | 10 | B00005OM5L
20 | - | 5 | 10 | B0001GAVNY
20 | - | 5 | 10 | B0001NPU0G
20 | 5 | 5.15 | - | B0002ISG7E
20 | 5 | 3.64 | - | B00081MWUM
20 | - | 6 | 10 | [NAME]
20 | 5 | 7.27 | - | [NAME]
5 | - | 4.95 | - | B000HEZ7N4
20 | 5 | 3.6 | - | B000IHYWIG
20 | - | 5 | - | B000JJSRU2
20 | - | 5 | 10 | B000PSJ9ZE
20 | - | 6 | 10 | B000VJVGF8
20 | - | 5 | - | B001AGNRYO
20 | 15 | 8 | - | B001ECPV8Y
20 | 15 | 5 | - | B001MYKYOU
20 | 15 | 9 | - | B002J8LVOA
20 | - | 5 | 10 | B00316QY6Y
20 | - | 6 | 10 | B0032BVEQS
20 | - | 5 | 10 | B003JIOHCW
4 | - | 5.77 | - | B003JMRA8G
7 | - | 2.72 | - | B004EMRZLW
Spreadsheet: 113013d1308947401-formula-to-obtain-a-numerical-value-corresponding-to-descriptive-questions-and-answers-multchoiceanswervalues
Sheet: Sheet1

Question Number | Answer Letter | Answer # | Value1 | Value2 | Value3 | Value4 | Answer Value
1 - Pain | B | 2 | 45 | 30 | 15 | 5 | 30
2 - Salary | C | 3 | 50000 | 80000 | 110000 | 140000 | 110000
3 - Days in | A | 1 | 10 | 20 | 30 | 40 | 10
 | ^^^ Change the Letter Answer for the multiple choice question from A,B,C,D
 | Watch the Answer Value Change in Col H
Spreadsheet: 729563d1619170160-fill-out-blank-with-the-assign-value-and-count-starts-with-6-book1
Sheet: Sheet1

No. | EXPECTED RESULT |  |  |  |  |  | NO. |  | [NAME] | [NAME]
1 | 10-11-1 | 10-11-1 | 1 |  |  |  | 1 | 10-11-1
2 |  | 10-11-1 | 2 |  |  |  | 2
3 |  | 10-11-1 | 3 |  |  |  | 3
4 |  | 10-11-1 | 4 |  |  |  | 4
5 |  | 10-11-1 | 5 |  |  |  | 5
6 | 10-11-2 | 10-11-2 | 1 |  |  |  | 6 | 10-11-2
7 | 10-11-3 | 10-11-3 | 1 |  |  |  | 7 | 10-11-3
8 |  | 10-11-3 | 2 |  |  |  | 8
9 |  | 10-11-3 | 3 |  |  |  | 9
10 |  | 10-11-3 | 4 |  |  |  | 10
11 |  | 10-11-3 | 5 |  |  |  | 11
12 |  | 10-11-3 | 6 |  |  |  | 12
13 |  | 10-11-3 | 7 |  |  |  | 13
14 | 10-11-4 | 10-11-4 | 1 |  |  |  | 14 | 10-11-4
15 | 10-11-5 | 10-11-5 | 1 |  |  |  | 15 | 10-11-5
16 | 10-11-6 | 10-11-6 | 1 |  |  |  | 16 | 10-11-6
17 |  | 10-11-6 | 2 |  |  |  | 17
18 |  | 10-11-6 | 3 |  |  |  | 18
19 |  | 10-11-6 | 4 |  |  |  | 19
20 |  | 10-11-6 | 5 |  |  |  | 20