tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 3756a66f-f450-4260-88dc-84f5456d2663
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
 | 8731.0 Building Approvals, Australia
 | TABLE 81. Value of Building Approved, Chain Volume Measures, Original - Northern Territory
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
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total houses ;  New ; |  |  | Original | A590537T | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total other residential building ;  New ; |  |  | Original | A590538V | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A590539W | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590540F | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590541J | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590542K | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Northern Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590543L | 1985-09-01 00:00:00 | 2010-06-01 00:00:00 | 100 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: stacey_white__39010__Power Remote Office 2002 Plan Expense
Sheet: Project Assumption WS

[NAME] | Project Name | Start Date - Month | Start Date - Year | Est Complete Date - Month | Est Complete Date - Year | Project Type (C=[NAME], E=Exp, M= Main) | Hardware (.90) | Software (.91) | .92 [NAME] - within your dept | .92 Enron Labor - Infrastructure | .92 [NAME] - Other Dev | .93 Contractor Expenses | .94 Other Expenses | Total Est Proj Costs | Comments / Assumptions | ENA % | EIM % | EGM % | Corp % | EBS % | EES % | ETS % | E-OPS % | Infra % | [NAME] | E-COM % | OTHER % | TOTAL %
 | Power Remote Office |  |  |  |  | M | 0 | 0 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (From [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Sum of Projects)
Note:  This worksheet does not link into the other spreadsheets. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diff
This worksheet was created to assist in budgeting at the project level.  Please
note the following cost elements equal the above cost types:
Cost Type | Cost Element
.90 | 52504500
.91 | 52504500
.92 | 52000500
.93 | 52507400
.94 | 54005000
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: Condo FHA

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
Conditional Approval |  | True | False | Team Rosa | Conditional Approval
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit Conditions |  | True | False | Team Rosa | Submit Conditions
CD |  | True | False | Team Rosa | CD
Final Approval |  | True | False | Team Rosa | Final Approval
[NAME] CD |  | True | False | Team Rosa | [NAME] CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
KOT Initial |  | True | False | Team Rosa | KOT Initial
KOT Resubmit |  | True | False | Team Rosa | KOT Resubmit
Spreadsheet: 672720d1586970693-filter-with-multiple-or-criteria-help
Sheet: Current Priorities 

Brand | Inititative | Priority | Status | Timing | Team
AB | Test 123 | 1 | In Progress | Q2 | Ops Marketing  International   Domestic Team A   Team B Team C
CD | Test 456 | 2 | In Progress | Q2 | Ops Marketing  International   Domestic Team A   Team D Team E
EF | Test 789 | 3 | In Progress | Q2 | Team C
AB | Test 1122 | 3 | In Progress | Q2 | Team D
CD | Test 1455 | 2 | In Progress | Q2 | Team E
EF | Test 1788 | 1 | In Progress | Q3 | Team C
AB | Test 2121 | 1 | Next on Deck | Q3 | All Teams
CD | Test 2454 | 2 | Next on Deck | Q2 | Team E
EF | Test 2787 | 3 | Next on Deck | Q3 | Team C
AB | Test 3120 | 3 | In Progress | Q2 | Team D
CD | Test 3453 | 2 | In Progress | Q2 | Team E
EF | Test 3786 | 1 | Requires Discovery | TBD | Team C
AB | Test 4119 | 1 | Requires Discovery | TBD | All Teams
CD | Test 4452 | 2 | In Progress | Q2 | Team E
EF | Test 4785 | 3 | In Progress | Q2 | Team A
AB | Test 5118 | 3 | In Progress | Q3/Q4 | Team A
CD | Test 5451 | 2 | In Progress | Q4 | Team C
EF | Test 5784 | 1 | On Hold | Q2 | Team C
AB | Test 6117 | 1 | On Hold | Q2 | Team C
CD | Test 6450 | 2 | On Hold | Q2 | Team E
EF | Test 6783 | 3 | On Hold | Q2 | All Teams
AB | Test 7116 | 3 | On Hold | Q2 | Team E
CD | Test 7449 | 2 | On Hold | TBD | Team E
Spreadsheet: 848862d1699479854-formula-to-calculate-an-agreements-remaining-value-with-an-escalator-value-calc-multi-year-escalator
Sheet: Frontend

New Colocation Agreement Value
Annual Rent | 12000
Escalator(%) | 4
Escaltor Interval | 4 Years
Total Years | 10
Total Value
Year | Monthly Rent | Amount
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: bb2874cb-1658-4f53-b63a-01da6430d3a9
Sheet: Sheet1

2002 official [NAME] | Unnamed: 1
State of North Dakota Results
Precincts Reporting: 663/663 - Total Ballots Cast: 128519
Downloaded at 4/24/2014 10:35:04 PM
 | [NAME] ([NAME]) Neumann - NON
Justice of the Supreme Court - NON | 97859
 | [NAME]
Public Service Commissioner - DEM | 46446
 | [NAME]
Public Service Commissioner - REP | 54859
 | [NAME]
Representative in Congress - DEM | 52403
 | [NAME]
Representative in Congress - REP | 56570
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 90165d1289925925-time-sheet-calculation-time-sheet-calculation
Sheet: OUTPUT

EMP ID | Date | 1st Time in | 1st Time out | 2nd Time in | 2nd Time out | 3rd Time in | 3rd Time out | 4th Time in | 4th Time out | 5th Time in | 5th Time out | 6th Time in | 6th Time out | Worked Hours
853 | 2009-06-27 00:00:00 |  | 08:07:00 | 11:05:00 | 11:09:00 | 13:02:00 | 13:02:00 |  |  |  |  |  |  |  | How to calculate Worked hours
853 | 2009-06-29 00:00:00 | 07:42:00 | 11:05:00 | 11:12:00 | 13:56:00 | 14:02:00 | 15:53:00 | 15:59:00 | 17:13:00
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
853 | Continue...
Spreadsheet: 148838d1333571732-vlookup-to-return-column-header-name-problem-excel-look-up
Sheet: Sheet1

 | 2 |  |  | 5 |  |  |  |  | 10 |  |  | 13 |  |  |  |  | 18 |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  | 40
Employee ID | AIQUIC | AIWCS Prod | CAPRI | CRUIS | DBS | DCRS | DMS | Eexcess | EMIS PROD | [NAME] | eStart Prod | eUPS Prod | EWC | EZ Audit | iView | iworks Prod | LAN request | MVR | ODEN | PLSEARCH | PPS Prod | PROMS | [NAME] | RefSys | Rumba (GA40, 50) | SAP | SCI | SWC | TSO | USER Extension | WTS | Approval Automation | CASL | CMS | Cognos | CORE | ecso A&H | ecso PC | ecso WC | IMPACT | [NAME] | iSuite Prod | NextGen PL Search | OneClaim US | OneClaimAuto | OSCAR | PTS | SCS | Toolkit | Coverall | eSPS | Fortis | iCAP | Intellirisk Basic | ISONET | Legal Exchange | NCCI | RAID | Recall | Receivable Edge | BR4 | CARS | DBS
5200309 | OK |  |  |  |  |  |  |  | OK |  |  | OK |  |  |  |  | OK |  |  |  |  |  |  | OK |  |  |  |  |  |  |  |  | OK |  |  |  |  |  | OK
5200306 | OK |  |  |  |  |  |  |  | OK |  |  | OK |  |  |  |  | OK |  |  |  |  |  |  | OK |  |  |  |  |  |  |  |  | OK |  |  |  |  |  | OK
5200307 | OK |  |  |  |  |  |  |  | OK |  |  | OK |  |  |  |  | OK |  |  |  |  |  |  | OK |  |  |  |  |  |  |  |  | OK |  |  |  |  |  | OK
5200305 | OK |  |  | ok |  |  |  |  | OK |  |  | OK |  |  |  |  | OK |  |  |  |  |  |  | OK |  |  |  |  |  |  |  |  | OK |  |  |  |  |  | OK
5200257 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OK |  |  |  |  |  |  |  |  |  |  | OK
Spreadsheet: 285977d1387981374-conditional-formatting-demo
Sheet: sheet

S.NO | Fleet No. | Reg.No. | Name | Make | Model | Eng.No. | Chassis.No. | Reg. Exp. Date | Winch Model | [NAME].No. | Winch Exp. | RAS Exp. | Lifting Exp.loose equip | crane and forklift insp
1 | AS-100 | 2689 ML | Winch Truck | MAN | 2011 | 51528561282858 | WMA34WZZ6BM570945 | 2014-01-01 00:00:00 | HS50P-20B | 7157019 | 2013-12-11 00:00:00 | 2014-09-09 00:00:00 | 2013-09-09 00:00:00
2 | AS-100T | 685 ML | Trailer | ATLAS | 2011 |  | ZTAA8200003 | 2014-01-01 00:00:00 |  |  |  | 2014-09-09 00:00:00
3 | AS-101 | 2386 ML | Winch Truck | MAN | 2011 | 51528560892858 | WMA34WZZ5BM570922 | 20/08/2014 | MS50P-20B | 765986 | 2013-12-11 00:00:00 | 25/09/2014 | 2013-09-09 00:00:00
4 | AS-101T | 812 ML | Trailer | ATLAS | 2011 |  | ZTAA8200001 | 20/08/2014 |  |  |  | 25/09/2014
5 | AS-102 | 2178 ML | Winch Truck | MAN | 2011 | 51528561132858 | WMA34WZZ6BM570928 | 20/08/2014 | MS50P-20B | 664212 | 2013-12-11 00:00:00 | 17/09/2014 | 2013-09-09 00:00:00
6 | AS-102T | 754 ML | Trailer | ATLAS | 2011 |  | ZTAA8200002 | 20/08/2014 |  |  |  | 17/09/2014
Spreadsheet: 681138d1591367881-value-error-when-using-mid-formula-mid-formula-help
Sheet: Sheet1

Client | Client Grouping | This is the suggested formula
PALACE ENTERTAINMENT (1019018) - PALACESANDCASTLE ACTIVE (504)
PALACE ENTERTAINMENT (1019018) - PALACESUTCH WONDERLAND ACTIVE (515)
ZELIS HEALTHCARE (1213023) - ZELIS HEALTHCARE ACTIVE (101)
ZELIS HEALTHCARE (1213023) - ZELIS HEALTHCARE COBRA (901)
ZELIS NETWORK SOLUTIONS (1213023) - ZELIS NETWORK ATLANTA CORP (101)
ZELIS NETWORK SOLUTIONS (1213023) - ZELIS NETWORK ATLANTA/CORP CBR (901)
ABCComp (ABCCOMP) - ABC COMPANY - DIV 1 (001)
[NAME] (ECAB003) - CHAMBERLAIN-HOUSTON ACTIVE (B01)
[NAME] (ECAB003) - CHAMBERLAIN-SAN ANTONIO ACT (D01)
CONCRETE SUPPLY CO, INC. (ECAB005) - CONCRETE-DEPT 015100 ACTIVE (003)
HIGHGROVE PARTNERS (ECAB006) - HIGHGROVE PARTNERS-ACTIVE (001)
RUSSELL LANDSCAPE GROUP, LLC (ECAB007) - RUSSELL LANDSCAPE-ACTIVE (001)
KING GREEN (ECAB012) - KING GREEN-ACTIVE (001)
NORTH GEORGIA TURF, INC. (ECAB013) - NORTH GEORGIA TURF-ACTIVE (A01)
UNLIMITED LANDSCAPING (ECAB016) - UNLIMITED LANDSCAPING-ACTIVE (001)
HEMMA CONCRETE INC. (ECAB017) - HEMMA CONCRETE-ACTIVE (001)
CITY OF HANNIBAL/PUBLIC WORKS (RCAA002) - CITY OF HANNIBAL - ACTIVE (001)
[NAME] (RCAA009) - CLASSIC AIRE CARE - ACTIVE (001)
[NAME] (RCAA009) - CLASSIC AIRE CARE - ACTIVE (001)
[NAME] (RCAA009) - CLASSIC AIRE CARE - ACTIVE (001)
BELGIOIOSO CHEESE INC (RCAA014) - BELGIOIOSO CHEESE - ACTIVE (001)
Spreadsheet: 98103d1297165121-counting-items-between-dates-in-two-columns-count
Sheet: Sheet1

 |  | Application raised date | Outcome
 |  | 2009-06-01 00:00:00 | Grant
 |  | 2009-07-05 00:00:00 | Granted
 |  | 2010-09-13 00:00:00 | You have been granted
 |  | 2009-06-01 00:00:00 | it’s a grant
 |  | 2009-07-05 00:00:00 | Grant
 |  | 2010-09-13 00:00:00 | Granted
 |  | 2009-06-01 00:00:00 | You have been granted
 |  | 2009-07-05 00:00:00 | it’s a grant
 |  | 2010-09-13 00:00:00 | Grant
 |  | 2009-06-01 00:00:00 | Granted
 |  | 2009-07-05 00:00:00 | You have been granted
 |  | 2010-09-13 00:00:00 | it’s a grant
 |  | 2009-06-01 00:00:00 | Grant
 |  | 2009-07-05 00:00:00 | Granted
 |  | 2010-09-13 00:00:00 | You have been granted
 |  | 2009-06-01 00:00:00 | it’s a grant
 |  | 2009-07-05 00:00:00 | Grant
 |  | 2010-09-13 00:00:00 | Granted
 |  | 2009-06-01 00:00:00 | You have been granted
 |  | 2009-07-05 00:00:00 | it’s a grant
Spreadsheet: 10f1c5b6-7fe1-45ac-85d4-5e6eb2690a25
Sheet: (F) Tuit Fee Discounts

ATTACHMENT F - 2012/13 Enacted State Budget Allocations, Tuition Fee Discounts Adjustment
 |  | -1 |  |  |  |  |  | -2 |  |  | -3
 |  |  |  | 2012/13 Tuition Fee Discount Adjustments based on 331,716 Resident FTES
 | Campus | B 2011-02 Final Budget Allocations |  | Tuition Fee Discounts Academic Year (AY) Eligibility Based on 2010/11 Final Database With 2012/13 Fee Levels |  | Tuition Fee Discounts AY Eligibility Further Adjusted to Reflect Funded Enrollment Targets from 2010/11 to 2012/13 |  | 2012/13 Enacted State Budget Allocations Total Tuition Fee Discounts (Foregone Revenue) and GF Grants1 / 100% Distributed Based on Need |  | 2012/13 Enacted State Budget Allocations Tuition Fee Discounts Increase
 |  | $ | % | $ | % | $ | % | $ | % |  | (Cols. 2 - 1)
 | Bakersfield | 15817300 |  | 19287000 |  | 18920500
 | Channel Islands | 6215700 |  | 6605200 |  | 7038900
 | Chico | 22678800 |  | 26243000 |  | 26135600
 | Dominguez Hills | 28907000 |  | 34295600 |  | 32515600
 | East Bay | 21925800 |  | 24660400 |  | 24513500
 | Fresno | 34935700 |  | 41522500 |  | 41090700
 | Fullerton | 45000900 |  | 55818500 |  | 53010900
 | Humboldt | 15031900 |  | 16370600 |  | 16321500
 | Long Beach | 50505800 |  | 60383400 |  | 57779000
 | Los Angeles | 42333400 |  | 50150500 |  | 48235200
 | Maritime Academy | 1638900 |  | 1822000 |  | 1905600
 | [NAME] | 8975700 |  | 9255600 |  | 10125600
 | Northridge | 52903000 |  | 62846400 |  | 61985500
 | [NAME] | 31198800 |  | 36607500 |  | 35281600
 | Sacramento | 41288400 |  | 49711900 |  | 49050700
 | San Bernardino | 34143300 |  | 39632800 |  | 37932600
 | San Diego | 40341800 |  | 49165600 |  | 47454700
 | San Francisco | 43742300 |  | 53499500 |  | 51300700
 | San Jose | 34907300 |  | 42500400 |  | 41399700
 | [NAME] | 14682500 |  | 17733300 |  | 16480200
 | [NAME] | 14289900 |  | 17033000 |  | 17775600
 | Sonoma | 9644100 |  | 11662800 |  | 11756900
 | Stanislaus | 14726500 |  | 18518900 |  | 18148600
 | Campus Total
1 Includes $33.8 million grants funded by General Fund appropriation.
Spreadsheet: 219764d1362936829-conditional-formula-to-lock-unprotected-cell-s-on-a-locked-sheet-based-on-a-cells-colour-test_sheet
Sheet: Main

 | All white cells are currently unlocked for data input. Dependant on the input of C11 (input value of between 1-4), then certain cells are coloured out.
 | The cells that change colour, require to be locked so no user input can be undertaken. All cells positioned as per original worksheet.
 | Protection PW = "test1234"
 | Input cell (Numeric between 1-4)
 | Data A1: |  | Data A2:
 | Data B1: |  | Data B2:
 | Data C1: |  | Data B3:
 | Data D1: |  | Data B4:
 | Header 1 | Dimensions (M) | [NAME] | Dimensions (M)
 | [NAME]: |  | [NAME]:
 | [NAME]: |  | [NAME]:
 | Total Height: |  | Total Height:
 | [NAME] | Dimensions (M) | [NAME] | Dimensions (M)
 | [NAME]: |  | [NAME]:
 | [NAME]: |  | [NAME]:
 | Total Height: |  | Total Height:
Spreadsheet: 718444d1613142407-automated-employee-department-rotation-rotation-example-1-
Sheet: Sheet1

 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-04 00:00:00 | 2021-02-05 00:00:00 | 2021-02-06 00:00:00 | 2021-02-07 00:00:00 | 2021-02-08 00:00:00 | 2021-02-09 00:00:00 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | 2021-02-12 00:00:00 | 2021-02-13 00:00:00 | 2021-02-14 00:00:00 | 2021-02-15 00:00:00 | 2021-02-16 00:00:00 | 2021-02-17 00:00:00 | 2021-02-18 00:00:00 | 2021-02-19 00:00:00 | 2021-02-20 00:00:00 | 2021-02-21 00:00:00 | 2021-02-22 00:00:00 | 2021-02-23 00:00:00 | 2021-02-24 00:00:00 | 2021-02-25 00:00:00 | 2021-02-26 00:00:00 | 2021-02-27 00:00:00 | 2021-02-28 00:00:00
[NAME]
[NAME]
[NAME]
[NAME]
Station 1
Station 2
Station 3
Station 4
Spreadsheet: 272649d1382453312-formula-to-calculate-change-of-a-value-across-two-tables-tracker1
Sheet: Week1

Programs | Subject1 | Subject2 | Subject3 | Subject4 | Subject5 | Totals
101 | 4 | 7 | 3 | 9 | 1
102 | 5 | 7 | 5 | 7 | 4
103 | 1 | 5 | 2 | 5 | 6
104 | 2 | 8 | 5 | 4 | 2
105 | 6 | 0 | 1 | 4 | 1
106 | 0 | 9 | 0 | 4 | 7
107 | 3 | 1 | 0 | 8 | 0
108 | 0 | 2 | 5 | 3 | 9
109 | 2 | 0 | 0 | 1 | 5
110 | 4 | 0 | 7 | 6 | 6
111 | 2 | 2 | 8 | 0 | 4
Total
Spreadsheet: 125003d1318796519-excel-2007-excel-doesnt-copy-zero-values-796743-excel-doesnt-copy-zero-values-example
Sheet: Sheet1

Number 1.720 | Number | 1.72
Number 14.500 | Number | 14.5
Number 16.600 | Number | 16.6
Number 108.000 | Number | 108
Number 36.000 | Number | 36
Number 1.620 | Number | 1.62
Number 72.300 | Number | 72.3
Number  7.240 | Number | 7.24
Number 29.000 | Number | 29
First, select cells C1:C9
Then choose Format Cells
Format as Number with three dp
Then use Text to Columns, delimited
with space as the delimiter
and output to cell $B$1
Or, you could just output the data
and then format the cells in Column C
And you could choose to ignore the first column
and format Column B as Number
Spreadsheet: 776488d1649758644-every-unique-uid-to-populate-180-in-column-b-if-countif-sample
Sheet: Sheet1

UID_MIRG_NCRF | AHT
216059938SXX24 | 180
219701978ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 0
220147826ARARA | 180
220147826ARARA | 0
220147826ARARA | 0
220228144TXXMA | 180
220310022VIJPX | 180
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220310022VIJPX | 0
220362586MXXJA | 180
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
220362586MXXJA | 0
Spreadsheet: 729527d1619145680-formula-to-count-consecutive-non-zero-values-and-reset-count-after-a-non-zero-value-inventory-fifo-shrink
Sheet: Sheet1

Analysis | 2021-04-22 00:00:00 | 2021-04-23 00:00:00 | 2021-04-24 00:00:00 | 2021-04-25 00:00:00 | 2021-04-26 00:00:00 | 2021-04-27 00:00:00 | 2021-04-28 00:00:00 | 2021-04-29 00:00:00 | 2021-04-30 00:00:00 | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00
Forecast | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572 | 2.821428571428572
Shrink | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86 | 0 | 0 | 0 | 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Expected Shrink
Spreadsheet: 207137d1358368544-rendering-column-values-for-selected-entries-example1
Sheet: Sheet1

 | 2001 | 2002 | 2003 | 2004
Mohammed | 4 | 3 | 3 | 1
[NAME] | 3 | 2 | 3 | 1
[NAME] | 2 | 3 | 2 | 1
[NAME] | 1 | 4 | 1 | 2
Sara | 3 | 4 | 2 | 1
Summer | 4 | 4 | 3 | 2
[NAME] | 2 | 3 | 4 | 3
Abdulla | 2 | 3 | 2 | 1
Basel | 1 | 4 | 1 | 2
[NAME] | 3 | 4 | 2 | 1
[NAME] | 4 | 4 | 3 | 2
[NAME] | 2 | 3 | 4 | 3
Spreadsheet: 790668d1659943155-index-match-but-excluding-the-first-result-indexexcluding1stresult
Sheet: Tabelle1

 | ID | Latitude | Longitude |  | Latitude | Longitude |  | 1st result | 2nd result
 | 72528704724 | 43.10833 | -78.93806 |  | 43.098535 | -77.441969
 | 72528899999 | 43.27 | -79.07 |  | Table 2 |  |  |  | 72529014768
 | 72529014768 | 43.1167 | -77.6767
 | 72529599999 | 43.25 | -77.6
 | 72530094846 | 41.96019 | -87.93162
 | 72530599999 | 41.908 | -88.249
 | 72530799999 | 42.067 | -87.683
 | Table 1
Spreadsheet: 92267d1291895399-dynamic-x-axis-values-of-chart-students
Sheet: Student_Grouped

 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | ColNum
English | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 0 | 8 | 1 | 2
Physics | 9 | 12 | 11 | 10 | 12 | 9 | 13 | 15 | 22 | 22 | 36 | 36 | 49 | 51 | 36 | 57 | 33 | 1
Maths | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 7 | 6 | 7 | 6 | 7 | 12
French | 9 | 8 | 8 | 12 | 21 | 18 | 14 | 14 | 15 | 18 | 13 | 11 | 54 | 54 | 0 | 0 | 0 | 1
Arts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 12 | 9 | 15
Music | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 21 | 24 | 15
Spreadsheet: 587260d1534932611-selecting-rate-from-one-table-entering-date-in-another-table-example-for-forum2
Sheet: Sheet1

 | DATE | SHIFT | NO. OF PERSONS | AMOUNT | TOTAL BILL |  |  | 2016-11-19 00:00:00 | DAY | 4714
 | 2018-08-22 00:00:00 | DAY | 2 |  |  |  |  | 2016-11-19 00:00:00 | NIGHT | 5696
 |  |  |  |  |  |  |  | 2016-11-20 00:00:00 | DAY | 6823
 |  |  |  |  |  |  |  | 2016-11-20 00:00:00 | NIGHT | 4325
Spreadsheet: 37991d1236101946-attendee-data-solution-signuplisting
Sheet: Expo1

Expo1 | 9 | Attendees |  | This counter tells column A how many names to bring over. The list goes blank after that.
Name1
Name3 |  |  |  | This list dynamically watches the KEY index on Signup
Name5 |  |  |  | and brings over the names that match the key and the
Name9 |  |  |  | row number on this sheet -1.
Name13
Name14 |  |  |  | The first name appears on line 2, so to get key 1, we use
[NAME] |  |  |  | row()-1 to result in "1" and that's a unique ID in the index
Name18 |  |  |  | on Signup.  With a unique number, we can pull the matching
Name19 |  |  |  | name with a standard INDEX/MATCH formula.
 |  |  |  | Change an X on Signup and this list updates instantly, automatically.
 |  |  |  | This would also work on separate workbooks, too.
Spreadsheet: 838672d1691245426-if-statement-with-3-different-criteria-help-etaf
Sheet: Sheet1

 | ANSWER
[NAME], 27, 40 T, 11, 24 | [NAME], 27, 40 T, 11, 24
INTEREST ADDED | INTEREST ADDED
40 TIVERTON BROADBAND | TIVERTON BROADBAND
IF A2="" : RETURN ""
IF A2 DOESNT START WITH A NUMBER *RETURN* A2
IF STARTS WITH A NUMBER *THEN DO*(RIGHT(A2,LEN(A2)-3)